How to update a field with a lookup value from another table?

In the image above, I have selected an employee from the Employee table via pop-up. Now, however, I want to populate the "emp_fk" field in the Tasks table with the Employee's "emp_pk" field from the…

• Answered

Aggiornamento del calendario

Bisogna aggiornare le opzioni del calendario, non è possibile per noi abbonati avere un calendario così debole. Forza Ninox !!!!!!!

Button to open calendar

Quando creo un appuntamento tramite un modulo ho bisogno di visualizzare il calendario per cercare una fascia oraria disponibile, come posso aprire il calendario e magari anche ridimensionare la…

Delete record if fieldA := fieldB

Hi, is there a way to completely delete the current record if a formula field results in a specific value or equals another given field?

Are there Trigger limitations?

I have a DCF (DMCF?) where a "Trigger after update" has the code: 'V.Välj Region' := ""; 'V.Välj Distrikt' := ""; 'V.Land' := text('V.Välj Land') it does't work BUT if I have the code: 'V.…

• Answered

CSV Import not working on Mac App

I used to use the cloud version of Ninox to all my databases and used to import data via a CSV file. Recently i moved from the cloud version to the Mac App.…

Jump to tab from a View

Hi, is there a way to clicking on the result of a view field (which shows the results of records from another table) and jump to that record in a specific tab? (But only from this view)

Date of value specific changing

Hello ! I'm looking for how i can get the date of when a value is becoming negative. I'd tried this code : "if 'Value' <= 0 then today() end" but the function today() returns the date of the present…

• Answered

SMS/text function?

Is is possible to have a field function that initiates an SMS/text message? It would be separate from the phone number field/button. Similar to what happens now with the phone or mail button,…

• Answered

Searching not working as expected (new to Ninox)

I have a column with a Status. It has values like Complete, Partially Complete, etc. I just want to show the values where it's "Complete", but I can't figure out how to enter that in the search…

Ninox Not Syncing with iCloud

I downloaded the iCloud Ninox app, but it doesn't see the Ninox databases that are in my iCloud account. The only (apparently non-synching) way I can get the data on iPhone is to save an archive.…

• Answered

How to create balance table from income and expense tables

Hi. I have two tables: 1. Income table - consisting of several fields and a formula named "total income"2. Expense table - with "expense amount" field. How can I create a balance table that will show…

database wide variables

I'm a teacher, and a lot of the formulas/views/filters are based off the current school year. Multiple times I reference either a students grade, the current school year, the current trimester etc.…

Joining text strings with carriage return

I have a clients table where each record has several address fields. Eg. address 1, address 2, city, state, post code, country. I want to join these fields into a single multi-line address but…

# of linked records in LINK FROM fields and VIEW fields

Another question: How can I access in code the # of records linked in a particular LINK FROM field? How can I access in code the # of records in a VIEW?

LINK FROM tables

If I link a record from another database using a LINK FROM table as above. How can I access that linked record in code? Or to multiple records linked this way?

Populate a Related field

I need to populate a related selection field (consignee) based on the value previous selected in other selection field (entity). The consignee selection field will have various values available…

Not to update a field after completed

Is it possible to block a field after it is change or writen after first time? I mean, I dont want to be able to update it.