Creating view with fields from multiple tables

Novice user question: I need to create views (reports, invoices) that allow me to draw data from multiple tables - e.g. I have three tables, Vendors, Expenses, and Clients,…

Set Background Color?

I can set the background color for Layout Elements/Tabs, is there a way to set the background color of the Record window (the first tab)?

Formula help please.

What formula could I use to to display the value of this choice field if one is marked, or "Not Rated" text if the field is empty?

Undo function

Hello, Is a "undo" function available for Ninox Online? Or how can we do if we don't want to save changes? Thanks in advance for your help. Have a nice day, David W.

Error in a script to find duplicates

Hi, I tried to remove the duplicates of names in a Ninox database with this script found on the forum but I have this error : "A table has not been find Oiseaux on the line 1, column 31".…

How does Ninox go with over 100,000 records

How does Ninox go with over 100,000 records? Does it slow down? Ash

Is it possible to set a Geolocalisation field and fill it with Latitude and Longitude format (ex.: N42º 34.5' E003º 54.6') and get the position en Maps as return?

Is it possible to set a Geolocalisation field and fill it with Latitude and Longitude format (ex.: N42º 34.5' E003º 54.6') and get the position en Maps as return?

Great to see the change to the forum

At long last we a have an update change to the forum - Thank you Ninox Even looks like we can add images again ? included test to see if works !!!!

Tables

Hi. I need to put in relation several suppliers (table suppliers) with sevral jobs (table jobs) at the same time. Whow can I do?. Thanks

Bonjour je suis nouveau sur ninox ... comment créer un bouton qui effectue un filtrage des données d'une colonne ? Hello I am new to ninox ... how to create a button which filters the data of a column?

Hello I am new to ninox ... how to create a button which filters the data of a column?

Novice user question: Running a report of filtered data including calculation

Hello, I'm new to this and don't know code. I want to be able to query out a set of records based on date (eg. payments to a specific vendor within a particular year) and then calculate the total…

Question about date fields ...

When placing a date field onto a form do you then have to format that 'date field' to the way you want to see it for every usage. ie, format(Date,"DD/MM/YYYY") Michael

Copy Data from one for into another then open that new record

Hi Having a bit of a blockage here I want to copy a few selected fields from one table to another table (which also has slighlly different fields names) so can't simply use duplicate(this) etc.…

How to relate everything to everything ?

An example of what I try to achieve is: I have table with all countries in the world and I want to mark on a scale from 1 to 10 how if they are at peace or war. How would I do that? Thank you

Delete or unsynchronise certain databases to free up iPad storage

My iPad storage is full (caused by having several Ninox databases including photographs synchronised). How can I remove certain databases from the iPad's storage?…

Can you please help how can I conditionally format dates like green in future, red in the past for 'Due date' field in To do list?

Can you please help how can I conditionally format dates

like green in future, red in the past for 'Due date' field in To do list?

Date format issue.

Hi , l have brought this query up before but not had a response. I have 3 team members under my data base, one of these team member dates are formatted to the American format ie,…

Some kanbans  are note displayed…

Hi In the kanbans view I have a lot of records but at the end there is written : "35 more…" and they are not displayed ! Is it possible to display these "35 more" ? Thanks

Taking into account first day of the month.

I have been trying to do a monthly summarization of invoice records. When selecting the month, Ninox omits the first day transactions i.e 01/01/2021 or 03/01/2021 etc.…

In menu cards the selection "multi" are displayed partially.…

Hi In view Menu cards the selection "multi" menus are displayed partially. ex in the database form view I have ”red” ”blue“ ”green” in a multi select menu in the cards view I have only ”red”… Is…

Service Outage?

Seem to have no connectivity to our databases

Google Street View Frame integration

Hi, How could i integrate a frame displaying a Google Street View of the Location/adress Field already recorded in each table, in order the watch the front of the building,…

Hi, I would like to create automatically a record in table B when creating a record in table A : the logic is that, when creating the record in Table A, I get the unique identifier of the record which I created , then i make a query based on this field (unique ID) to see if it is found in table B. If not found, then Ninox creates automatically the record in table B. How can I do this ? Cant find information on the programming language commands in Ninox . thanks for your help

please help me with the code

Is it possible to have a filter expression for character count?

Hi there, Is it possible to have a filter expression for character count? In my database I want to filter the view of a colum with "marketing manager" and limit the search to not include results with…