Hi Team,
I have created the control procedure to show the user regarding their work permit expire in LAYOUT and DEFAULT code group (I have tried these two things). Its been showing correctly when the work permit date is not current date, but the problem is its always showing the message even we clicked on other fields too if the date is not current date.
Can anybody help me to fix this? How can I stop the message once its been executed?
Thanks and Regards,
Prabhu S
Best answer by Anne Buit
Hi Prabhu,
If you only want to show a message when a specific field has been modified by the user, you can use the @cursor_from_col_id variable to check the modified field in the Default logic.
For instance:
if @cursor_from_col_id = 'permit_date'
and @permit_date is not null
and @permit_date <> getdate()
begin
exec tsf_send_message 'warning_permit_date_not_today', null, 0;
end;
+5Hi Prabhu,
If you only want to show a message when a specific field has been modified by the user, you can use the @cursor_from_col_id variable to check the modified field in the Default logic.
For instance:
if @cursor_from_col_id = 'permit_date'
and @permit_date is not null
and @permit_date <> getdate()
begin
exec tsf_send_message 'warning_permit_date_not_today', null, 0;
end;
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
