Avatar

Level 3

Hello,

I have a finish time field in a memorandum agenda form which I would like an alert (message) sent 2 minutes before the finish time expires.

The script has an error message for the "," on line 4.

var vEnd = Time2Num(ActionsEndTime.formattedValue, "HH:MM") // this is the finish time

var vSec = 2 * 60 * 1000  // time in milliseconds - which is 2 minutes

var vFinish = vEnd - vSec // take away the finish time from 2 minutes to give a new time to trigger to alert

var vcurrent =  form1.ActionsHeaderFrame.DateTimeField1.formattedValue, "HH:MM") // this is the current time field

form1.ActionsHeaderFrame.DateTimeField1.execCalculate() // recalculate a hidden current time field to give the current time

if vcurrent = Num2Time(vFinish, "HH:MM") then  // if the current time equals the finish time - 2 minutes then show message

xfa.host.messageBox("You only have 2 minutes to finish the agenda " ,"Reminder",3,0)

else

""

endif

Can anyone please advise where the formcalc script needs correcting?

Any assistance will be most appreciated