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?

Automatic updated field with date for each time I update something

Hi All, I'm totally green with ninox, but I really feel I have tried everything I have read on the forum on how to make field that automatically updates with the date of today each time I for…

Problem with unique() function

Hi all, I'm having trouble making the unique() function work. I'm simply writing unique('Project Codes'.Currency) in my formula field. If the values selected are all the same (e.g.…

Initials

How can I get every first letter in each word in a field, for example, initial a name? Let say the name, John F Kennedy, I want it JFK. Thanks.

I can't sum just one month on column, i need sum month by month expenses

First of all I am not a programmer. I need to divide my expenses by month and by year, i hav it by yer, I have tried to use formulas but it is impossible for me it is like speaking in code.…

formulas in print view

I have a series of formulas to calculate the quantities of various combinations of variables. However they are not being printed accurately on my print view.…

My actual plan is not available anymore but i can't do the uploading

My actual plan is not available anymore but i can't do the uploading

mise à jour du plan

Bonjour, Je n'arrive pas mettre à jour le plan dans NINOX. LE message ne s'enlève pas et je ne sais pas comment faire pour régler le problème

question

testing question