Locale backup has no data

Hello, when I download a backup and click on import archive locally on my Mac Ninox Database App, the locale backup has no data. Everything else seems to work, but the tables are all empty.

• Answered

Is it possible to split the Location field to several address formula fields in Ninox?

I want the Location filed to split and copy the address to several fields like Street, ZIP, City etc, is that possible?

How to create a field that displays all gigs worked within a range of dates?

I have the following tables Event Details, Staff, and a join called Event_Staff_Join. My payroll person would like to pull a list of staff that have worked any event between a date range.…

Show form of combined select (or array) logic

Hello, I want to show something in a form which is a combination of multiple wheres and conditions. I want the entries from table_A which have no value in the field bakery.…

• Answered

Switch with multiple for loops and consequents new records

Hello, for each person, I need to list all the academic years that person has been or is being hired, along with the startDate and endDate for each academic year resulting.…

Pulling data from Power BI???

I am a complete rookie when it comes to all of this but I've done my best to learn as I go. One of the main things I would like to be able to accomplish is this:…

Splitting data or trimming where a space is

Could someone please tell me how to remove all text prior to a space? I have a column "Colour" and the data is presented as "Clear 3mm", "Clear 4.5mm", " Lemon Grass 3mm" etc I'd like to be able to…

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?