AnsweredAssumed Answered

Sedt field depending on result of other field

Question asked by FilipePimentel on Dec 16, 2013
Latest reply on Dec 16, 2013 by FilipePimentel


Sedt field depending on result of other field


     Hello There, 

     I have two portals: one for LandPlots and another for payment of these plots. 

     On the LandPlot table I have a field set as check box for payment completed (once the land owner has made all payments). 

     On the LandPlot table I also have a c_Balance (calculation for value of Land-s_Payment), which once owner make payments the balance reduces. 

     I want to create a script/script trigger to automatically check the "paymentcompleted" check box once the c_Balance has reached "U$ 0,00". 

     I tried with a script using if, but I am not getting anywhere

     The script is: 

     if(LandPlot:L::c_Balance = "US 0,00")

     Setfield( LanPlot::Paymentcompleted; "Paid")

     Else If (LandPlot:L::c_Balance > "US 0,00")

     Setfield ( LanPlot::Paymentcompleted; " ") 

     End if