0

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

null
    • Birger_H
    • 5 yrs ago
    • Reported - view

    The formula would be:

    –––
    'TimeSpent'.Transmit := true
    –––

    Birger

    • ghjuvavinciguerra
    • 5 yrs ago
    • Reported - view

    Thanks .. I 'll try 

    • Ron_RLA720_mscpostpr
    • 5 yrs ago
    • Reported - view

    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.

    • ghjuvavinciguerra
    • 5 yrs ago
    • Reported - view

    Hi,

    It works for me too but not exactlly with this syntax ..I had to change quotes.

    As Ron, did not find documentation 

    regards 

    • Alexander_Koenig
    • 5 yrs ago
    • Reported - view

    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

    • ghjuvavinciguerra
    • 5 yrs ago
    • Reported - view

    thanks

    • Ron_RLA720_mscpostpr
    • 5 yrs ago
    • Reported - view

    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

  • 5 yrs agoLast active
  • 7Replies
  • 3726Views