chartanalyses

Hello - i have different historic data in my database K(n,t) n index of the chart data; t dates and want to analyse them statistically. That means i have to calculate formulas that are depending on…

How to show all fields at once?

It looks like Ninox only shows the first 7 fields that you add to a table, and hides every field after. From here we have to click the view button and drag each and every field one at a time.…

Formula with calculation between two different times

I want to make a different text for each hour, and then make the text coloured red when the hour (now) is in between a chosen time. What is wrong with this example? Example: if time(now()) > time(9.…

How do make a record creation step precompile a table with "Link from?"

I have a table that contains all the replacement parts used on the machines so that when I go to view the machine from the machine log you can see all the replacement parts used on that machine over…

Insert a line break in mailto body

Hi All, I am using an email field where in the body I have alot of IF statements. Below is an example of an IF statement {if 'Is PPC to be included in report' then 'Google Data Studio Link' + " TEST…

How to export whole database

how do I export all fields; when I chose export, only the first few fields are exported; I can't see a way to set it to export all fields

Search in formula field

Hi colleagues, I have a table that consists of 3 different text fields (lets say A,B,C). These fields are joint in a separate formula field to show them concatenated, too:…

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