I have a query, I have created a web form, where the user will input the details.
I need to match if those details are available in the column of a schema,
For eg user enters ABCD4444567HGF, this should be present in the purchase table and on successful match, user details which are on the recipient table should be shown on another page.
I am not sure after entering the value how to find this value in the purchase table.
Any help is highly appreciated.
Once the users enter the vehicle number and click submit. Store this number in a ctx variable and then on next page do a queryDef on recipient and add the vehicle number variable in where condition.
and then you can prepopulate the forms with the queried data.
Can use JS with querydef, though maybe Preloading activity will work by changing Method to List of fields and using (guessing) the correct field?