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
Like Follow
62replies
-
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 -
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