Solved

How to stop showing the message in Universal once its been shown in DEFAULT OR LAYOUT Code group?

  • 12 June 2023
  • 2 replies
  • 55 views

Badge

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

icon

Best answer by Anne Buit 12 June 2023, 10:49

View original

This topic has been closed for comments

2 replies

Userlevel 7
Badge +5

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;

 

Badge

Thanks Anne Buit, It worked perfectly.