loop in query for view -- how to aggregate?

I use the below formula for a view and a dMC. Yet, it will only return the last record i, not all of them. When I create a button to alert all i, it will prove the loop works correctly.…

Still no field alignment options?

I guess I got distracted by life and didn't notice this until now. Am I missing Left, Right & Center alignment options?

Storing array in a table column

Hello friends, I am new to Ninox and learning to get acquainted to it. I have a Parent/Child tables setup (Products and 'Product Details'). In the Products table I have T-shirt types (Round Neck for…

I encountered a very strange problem.....

I encountered a very strange problem. I set up a table in one of my databases, and the code is as follows: let Table := (select 'Procurement').--- <tr onclick="ui.…

Regarding the issue of popping up another table record from a table...

I set a button in table1 to jump to the first record of table2, but there seems to be an error. Where could the problem be? Thank you for your help.

• Answered

A question about writing HTML code.

I have two pieces of code. I want to write the table data from code one into code two while retaining the style of code two. How should I write the code?Their structures are different,…

Help Needed: Error: Database Connection Failed on Ninox

Hi everyone, I have migrated my complete data from Salesforce and imported it successfully, yesterday it was working fine, but right now, I'm encountering an error while trying to connect to my Ninox…

unable to use google maps

Recently had to re-install the app on my phone. Now I'm unable to us google maps to direct me to an address. Error message is "Goole Maps is not installed or switched off",…

Size of database - Delete images fields and files

When I delete recordings with images (file), it deletes the data but keeps the files. I have a database size problem. How can I fix it?

Does Email with Starter Cloud allow it to come from my email/domain?

I'm currently using the Mac OnPrem version and I'm considering moving to the Starter Cloud however I want to use email, and will Starter allow you to have the email come from your domain?…

• Answered

Database Split

I have been doing a major overhaul one of my Ninox database tables. Sometime during this process the tables has split into 2 parts. I had a database called "Workflows", containing hundreds of fields.…

• Answered

Selecting Location for Local DB on Mac

Hello... New to ninox, looking pretty awesome so far. I want to store my database locally on my Mac. I don't want to use iCloud. But I want to choose where the database gets stored (ultimately it…

• Answered

Regarding the issue of modifying a sub-table of a sub-table.

Created an order database. The Orders table records the product details of an order; the Products table records product names and quantities; the code table records code information, etc.…

• Answered

Calendar

I frequently use the calendar funtion in Ninox. Syncing with Outlook etc. is great. However, I can only specify date/time and subject. Is it possible to expand the possibilities:…

Help with code to create non-repeating set of 10 numbers

So I'm working on trying to create a non-repeating set to 10 randomly selected numbers between 0 and 9. I have this in a formula field: let x := [number(void)]; while length(x) < 10 do let newItem :…

• Answered

Populate a field with values from a list

Hello! I need to write some values in a field. There are around 10 different values, that i want to put in a field in random order. I guess i first need to put them in a separate table,…

Mac app update to 3.11

After updating the Mac app to 3.11 I get a white screen with no database???

UD Array Functions by Index

This has definitely been a progression. Typically, array manipulation is done by using the array's index rather than by the index value and that's how these functions work.…

Full screen button , maybe the solution I was looking for since a while...

Finally I think that I've gotten a definitive way to nicely handle a fullscreen home menu button. I was doing an Intranet project and i needed to have a nice "homepage" with full of informations on…

Issue with a script that does not display the expected value when two fields are equal

Pgr.('Total Earned Value' := if cnt((select 'Progress-Cost Report')['Total Earned Value' = xFld4]) > 0 then null else xFld4 end); The problem with the part script is that when the "Total Earned…