Set a button in a form to modify a field in all record in a table linked to it
I am new to Ninox and I did not find an answer to my problem browsing the forum (not perfectly at ease with English :( ).
I am working on a billing database with a table containing bills sent to clients concerning time spent working for them with :
- a form associates to a table "Bill" which show client information from client table and a list of hours spent from a table "TimeSpent" for this client.
Every month I generate a document I send by email to each client.
Records in my table "Timespent"contain Yes/no field (Named Transmit) regarding this entry was sent or not with a given bill.
I would like, on my "Bills" form, set a button which set to "yes" transmit field in all the records from TimeSpent table shown in the form and associate to this customer and this month.
The formula would be:
'TimeSpent'.Transmit := true
Thanks .. I 'll try
Thank you, Birger. That worked perfectly here.
Now this question: Where does the documentation explain syntax of formulas like that. It must be somewhere, but I can not find it.
With special characters ":= " my AI search result is empty.
It works for me too but not exactlly with this syntax ..I had to change quotes.
As Ron, did not find documentation
Hi, you find more information in the section about triggers:
We are currently updateing the content of the manual with more examples.
Please stay tuned.
Alex - So, the manual will have more examples. When will we start to see those updates? This week, perhaps?
I am staying tuned.