Read Data from Tables without creating manual Links

Despite extensive searches and experimantation I now concede I am stuck I have 4 tables of data which one way or another are connected, all data comes from separate sources but are linked Tables 1…

Importing Date/Time from CSV

I have formats in a CSV file like the ones below but Ninox doesn't import them correctly. I've tried changing the format to ISO 8601 (the standard), but Ninox still isn't importing hundreds of…

Ninox Not Responding At All

I upgraded Ninox to the latest software and now if I don't make any mouse movements on the software for a few seconds, it freezes up until I go to a different application and back onto Ninox on my…

Problem of managing automatic record creation with trigger on the Ninox Mobile App

I have an "Activities" dashboard table where the activities performed by the workers are selected. After choosing an intervention category from a combobox field, which identifies the work done,…

Show value of line items depending on the choice field selection

Hello everyone. I have created a formula field to show the current total of our Petty Cash which is in a subtable. This needs to exclude amounts which were transferred to/from a bank.…

• Answered

Adding and removing items from a list

Hi From the list myPersona I have to delete names that I find in the list myEsclusi and add names that I find in the list myAggiunti. Can you please help me.

• Answered

Constraints - Please help!

I have four tables: Customers, Contracts, Notes and a table to associate contracts with customers: Clients / Contracts N: N. In the Notes table, I need to constrain the contract records by the…

Icons Color

Silly question maybe, but I haven't found any previous thread about this: is it possible to change the color of an icon? if I use the formula a icon("trash") the icon shows a blue trashcan.…

Count number of fields containing zero

In a table, I have 14 fields (this week, this week - 1, this week -2, this week -3, and so on, until I have the total miles in a field from 13 weeks ago),…

• Answered

how can I remove an item from an array?

I have found idxRemove() but unable to make it works... let say: let A := sort((select Achats).total_vente); idxRemove(A,2) tell me that the function not defined...number... Thanks!

Define start of fiscal year

I can use the function yearweek() to define the week number within the year, but that does not sync with my employer’s fiscal year, which begins on the first Monday of the new year.…

• Answered

Searching in Kanban mode

Hi When you are in Kanban mode and you want to do a search, you can only do it in the field next to the gear, there are no column titles with filters like when you are in "all" mode.…

Issue sorting in Kanban mode

Hi In Kanban mode I have a problem sorting. There are errors. Can someone help ? Thanks

Summary table of multiple tables

Hello all. I have multiple sub tables of different elements of a holiday booking, e.g. one for flights, one for hotels etc. In each sub table there are fields that are the same, such as Gross amount,…

Hide the icons on the ninox app

Is possible to hide the highlighted icons? Thank You

Create table via REST api

Is there any documentation/examples, how a table can be created via api? Is it possible with a POST command?

List of years/months/weeks...

Hello, I have a field with a Beginning Date and another one with the End Date. Is it possibile to have a list of the months and a list of the years (or whatever time interval) that those two dates…

Re- in a number column, I would like to continue with auto-numbering

Have a column with unordered and null numbers... While creating a new record, I would like to continue with auto-numbering using the largest number + 1...…

Run a script to Form open or Form Close

I would like to run a script when a form opens and/or when a form closes This would not be dependant on form creation or modification. At present (and not sure if there will ever be!…

Problem printing Layouts

Please see the image attached: on the left the Ninox print preview including several formatting elements as list bullets, spaces etc On the right is the pdf which loses all formatting elements.…

Ninox database file on iCloud isn't visible and thus difficult to backup

I am using the Mac version of Ninox on 2 Macs. I have the database file hosted on iCloud. When I look at iCloud storage, I know it is taking up space, but it doesn't show up as file that I can copy…

Impossible to add a new recording…

Hi I enter a new recording, (+ sign). I close the app. I open it, the recording does not appear… I start again and again… No new recording ! Can someone help ? Thanks

Problems with Formula Don't give me anything.

I have a Choice field With DateR1, DateR2...... to R5 What I need, Find all documents by DateRx that al delayed with respect to the CutOff date and not have Earned Value.…

• Answered

Button to validate required fields

Is there a formula to insert in a button that makes me the automatic validation of all required fields displayed in the mask including embedded tables or do I have to make a script on purpose?…