0
Formulas
Hello,
When attempting to link entries together from two different tables via the cross reference function, Is there a way to get data entries to show up in the search results of "Find: X" when searching a specific word/name associated with a formula field?
- John
When attempting to link entries together from two different tables via the cross reference function, Is there a way to get data entries to show up in the search results of "Find: X" when searching a specific word/name associated with a formula field?
- John
62 replies
-
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? -
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
Content aside
- 6 yrs agoLast active
- 62Replies
- 21261Views