PM Table Mismatch Warning

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.

2 posts
First unread post

2 posts

PM Table Mismatch Warning#823596

By ebryant - Thu Mar 28, 2019 3:09 pm

- Thu Mar 28, 2019 3:09 pm #823596

Is it possible to create an execute button or something the verify the information input into fields match the appropriate fields in a PM Table.

Example:
Person inputs his SS# and DOB correctly and the other fields will populate with the data stored in the PM Table. If one of the fields is incorrect then an error message could appear.

Thank you in advance

Re: PM Table Mismatch Warning#823601

By amosbatto - Thu Mar 28, 2019 10:42 pm

- Thu Mar 28, 2019 10:42 pm #823601

You should use the the validate property of text fields to ensure that the user is entering the type of data.

If you want to be creative, you can create a trigger that uses executeTrigger("DESCRIBE PMT_MY_TABLE") to get information about your table and then compares each field from the table with the data from your Dynaform. If there is a mismatch, use G:SendMessageText() to display an error message and then call PMFRedirectToStep() to redisplay the Dynaform, so the user can correct the data and resubmit the Dynaform.