0

Change Status on Multichoice Dynamic

I am trying to get the 'Status MC' change to 90% when I update the date in 'Real 4' but if I delete the date it goes back to 70% 'Status MC'. I try this but don't work.

if 'Real 4' then 'Status MC' := 4 or if 'Real 4' = null then 'Status MC' := 3 end

3 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 11 mths ago
    • Reported - view

    Where did you put the formula? In the trigger after update of the Real 4 field?

      • Rafael Sanchis
      • Rafael_Sanchis
      • 11 mths ago
      • Reported - view

      Hi yes I place in the Trigger after update of the Real 4.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 11 mths ago
      • Reported - view

       

      Change the script, this work. 👍

      if 'Real 4' then 'Status MC' := 4 end;
      if 'Real 4' = null then 'Status MC' := 3 end