Formulas

Hi Andrea,

if today() > ‘Data scadenza fattura’ and text(‘Status fattura’) != “Pagata” then ‘Status Fattura’: = “Scaduta” end

regards
Leo

are you sure? it doesn't work
a pop-up says: in Italian "Questa formula potrebbe non modificare i dati"..

that's right, the calculation field is not allowed to make any data changes.
You should create your formula as a trigger "after update" in the 'Data scadenza fattura' field. Or as a formula in the Button.

https://www.dropbox.com/s/r82as6qfnaquupd/Andrea.ninox?dl=0

regards
Leo

Hi Leo,

now it works as formula trigger, but not automatically. I would like the function to work automatically every day: checking if the date in the "Data scadenza fattura" field is before today's date and modifying the combobox. Is it possible that it works like this? This is a function that checks whether the payment date of an invoice has expired or not. THX

Hi,
where can I find the list of icons names?

Here:
Iconset.ninox


Birger - Ninox Support

Hi!
How to reset the ID counter to 0? Or how can I make it start from a different number, e.g. 100? thx

This is not possible. The Id is a unique automatic number created when a new record is created. This number can not be changed.

Birger - Ninox Support

...so how can I create a progressive counter number an order? THX

Have a look at the "Invoices" template. There is a automatic progresssive order number there.

Birger - Ninox Support

I have a database on my computer. I'd like to use it from iCloud. When I duplicate the database one of my calculations (a running balance) outputs the wrong amount for the 2nd and 3rd records. The rest of the records use the correct calculation but are wrong due to the beginning balances being off. I've tried deleting the calculation field and redoing it, but it's still off. Any help would be appreciated.

Thank you,
Don

Please send the database to me ( support@ninoxbd.de ) and I will have a loook.

Birger - Ninox Support