0

FORMULA & ALERT

Hello, 

I have a formula to compute the age of a person. So, I am using the formula : age('DATE DE NAISSANCE'). That works properly. 

But, in the same time, I would like to create an alert if the age is under 18. Is it possible ? If yes, how to do it...

Thanks already for your help !

Best regards,

Raphaël

5 replies

null
    • Nick
    • 6 yrs ago
    • Reported - view

    Hi,

    you can use this code as Trigger After Update in your Age field:

     

    if Age < 18 then alert("Your text here") end

    • Nick
    • 6 yrs ago
    • Reported - view

    Sorry, use this code as Trigger After Update at table level (and NOT Age field).

    • Raphael_Vieira_de_Matos
    • 6 yrs ago
    • Reported - view

    Nick, 

    Thanks for the answer. But I have already something with if at table level. How can I add this second trigger ?

    Best regards,

    • Nick
    • 6 yrs ago
    • Reported - view

    Hi Raphael,

    you can have as many as you need, just separate them with a semicolon (;).

     

    ...

    end;

    new trigger...

    • Raphael_Vieira_de_Matos
    • 6 yrs ago
    • Reported - view

    MANY THANKS !!!!

Login to reply

Content aside

  • 6 yrs agoLast active
  • 5Replies
  • 2039Views