0

Multiple trigger after update

Hello everyone, does someone know if it is possible to write  multiple trigger after update in the same field ?  I'm sorry but I'm not so expert in coding..

For example:

I have a table (VISITA)  with a multiple choice field (DECEDUTO)  that have a trigger after update formula that modify a DATA field. It works perfectly.

if Deceduto = 1 then
    let xdatadec := DATA;
    PAZIENTI.(DECESSO := xdatadec)
end

 

I would like to add to that another trigger formula to show a dialog, create a new record in another table (DICHIARAZIONE DI DECESSO) and print the record layout view; I've tried in multiple ways without  any results.

This formula  works good if insert in a button but doesn't if insert in the trigger after update of the multiple choice field above.

 

if Deceduto = 1 then
    let check := dialog("STAMPA DOCUMENTO", "VUOI STAMPARE LA DICHIARAZIONE DI DECESSO ?", ["SI", "NO"]);
    if check = "SI" then
        let myID := ID;
        let NN := (create 'DICHIARAZIONE DI DECESSO');
        let xdata := PAZIENTI.DECESSO;
        let xpaz := PAZIENTI;
        let xclient := PAZIENTI.PROPRIETARIO;
        NN.(Data := xdata);
        NN.(PAZIENTE := xpaz);
        NN.(CLIENTI := xclient);
        printRecord(NN.ID, "DICHIARAZIONE DI DECESSO")
    else
        null
    end
end

 

Any ideas ?? Thanks in advance

2 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    You have encountered the server side vs client side actions. Maybe someone can repost the list of server side actions. Triggers happen server side so alerts and dialogs do not work since you will never see them as they will "appear" on the server.

    If you were using the MacOS app with a local DB then it will work since your "server" is your computer.

    You will have to continue to use a button or remove the dialog and trust your code to work.

      • saffron_car
      • 1 yr ago
      • Reported - view

      Fred AH, ok!  Many thanks !

Content aside

  • 1 yr agoLast active
  • 2Replies
  • 97Views
  • 2 Following