Set a button in a form to modify a field in all record in a table linked to it
Hi,
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.
Regards
7 replies
-
The formula would be:
–––
'TimeSpent'.Transmit := true
–––Birger
-
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.
Thank you.
-
Hi,
It works for me too but not exactlly with this syntax ..I had to change quotes.
As Ron, did not find documentation
regards
-
Hi, you find more information in the section about triggers:
https://ninoxdb.de/en/manual/calculations/triggers
We are currently updateing the content of the manual with more examples.
Please stay tuned.
Best, Alex
-
thanks
-
Alex - So, the manual will have more examples. When will we start to see those updates? This week, perhaps?
I am staying tuned.
Content aside
- 6 yrs agoLast active
- 7Replies
- 3740Views