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?

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.

Basic Beginners Help Please! How do you use info in column count as a table field?

I am on a trial version of Ninox after using MS Access for years. I am trying to figure out how to find the percentage of the count of 2 columns on a table.…

Rich text formatting disappears in final PDF file

Im on the cloud version. I have read all the posts about printing rich (or formated) text. Although in the print layout screen the formating is present, in the final pdf file not the rich text field,…

New To Ninox

Using HTTP function, how do you update the Ninox field(s) with the return value from, say, a POST call? Thanks,

Using an iFrame in Ninox to view a website

Can someone help with a sample script to add a website into a formula using iframe?

• Answered