Trigger after update - ImportFile from URL - Doesn't work

Hello Ninox community! I have a scenario in INTEGROMAT to NINOX and everything works ok, including the URL of a file in a Ninox URL field. Problem: I need that,…

Counting records in a child table and storing the value in a field of a master table

I have 2 tables T1 (master) and T2 (child) with the following fields: T1(COD, TOTAL, T2) - here T2 is the reference field for table T2 T2(QTD, T1) - here T1 is the reference field for table T1 On a…

Form elements Top-align

Any ideas on how to align elements in a form to top instead of bottom (Mac version)?

Interrogating the History information

Hi - is there a way to interrogate the database history? The history for my Db only goes back 48 hours but I may need to go back further when our auditors come in.…

I am trying to "Mass Update" multiple records. The Manual says it can be done but all of the help text and pictures must be for a different version. Nothing the manual suggest is possible with the 2021 MAC version I downloaded. Any thoughts on this??

I am trying to "Mass Update" multiple records. The Manual says it can be done but all of the help text and pictures must be for a different version. Nothing the manual suggest is possible with the…

Trying to e-mail with record in PDF attached

Hi all! Is it me or is mailing with attachments (record in PDF format) still not functioning properly? I have read many threads on this issue and as long as I am working with Ninox I still haven't…

Duplicate and Link New Data Entry from One Table to Another

I know this might be a dumb question but I am really new to Ninox so I help someone would be patient enough to read this. I have 2 tables, Product Masterfile and New Products.…

Conditional Calculation

I have two questions: 1) I have three fields, "Opening Balance", "Amount" and "Closing Balance". I would like to have a formula in the "Closing Balance" field calculated based on another field…

Farbstile zuordnen (Ninox Cloud)

Wenn ich einem Feld vom Typ "Berechnung" diese Funktion zuweise, funktioniert sie: if Relevant = "Relevant" and 'Feld1' = null then styled("Dringend", "Red", "White")else styled("", "White",…

Before and After values available in onUpdate events?

Is there something like this.value.before and this.value.after in the onChange events? For example, if building a ticketing system where the status changes from open to pending vs closed to pending,…

Free text

Anyone figured a way to make this line up with a regular field? Fields align vertically at their top. So a data field with label positioned above does not line up with any 'Free text' placed on the…

Sverweis wie in Excel

Hallo zusammen, ich habe eine Datenbank mit Artikeln. Ich habe da ein Artikel produziert wurde, einzelne Preismaterialien eingefügt. Diese Preismaterialien haben jeweils einen Wert,…

Having a problem with dates

Currently having a problem with the date format on the cloud version. I have tried this on multiple computers / on my phone and it works perfectly fine.…

Change colour of a formula box if it’s a year later

I have a Last Updated date box and a formula box called Last updated status, I basically want to make it so after a year from the date in the last updated box the formula for the status turns red. TIA

How to apply a HTML tag to the entire post and type it only once?

I read How do I use a small font size in questions and answers? and Allow the <small> tag, but I don't want to write  for each paragraph. For example,…

Variables: let vs var

Hi! I'm new in Ninox and I am wondering about the differnce between assigning a variable using "let" statement vs using "var" statement. So far, they've both worked fine in my coding,…

Automatic table cleaning after one year

in my database there is a table that collects information about discounts. But they are valid only for a year. How to make sure that all information in the table is deleted after a some time,…

• Answered

How do I copy line breaks from a multi line textbox or a rich text field into an email?

Hi all, I need to be able to sent mass mailings to all relations/clients. For this purpose I have created a form with a text field "subject" and a multi line text field "body".…

deleted database

How to recover deleted database?

Where are my formulas ?

Hi I can't no more see my formulas, only my columns ! How can I retrieve it ? Thanks

Trigger on Update not triggering

I want to automatically create some child records in 2 child tables. In the parent table, Trigger on Create successfully creates the required child records in one child table (actually it duplicates…

hide and seek

Well, not seek really. I have always thought the way that Ninox hides the parent, when accessing the child through the parent is really neat. So e.g., click on a child line to open that child in the…

Image link

I have an image field and would like to create another automatic formula field with the image field link.Anyone able to do it?