Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Verification using Adobe Campaign Classic Web Forms

jitendrak
Level 2
Level 2

Hi All,

 

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.

 

Regards

Jay

 

@Jonathon_wodnicki 

@DavidKangni 

 

1 Accepted Solution
Manoj_Kumar_
Correct answer by
Community Advisor
Community Advisor

Hello @jitendrak 

 

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.

 

Thanks,

Manoj

View solution in original post

4 Replies
Manoj_Kumar_
Correct answer by
Community Advisor
Community Advisor

Hello @jitendrak 

 

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.

 

Thanks,

Manoj

View solution in original post

jitendrak
Level 2
Level 2

Thanks Manoj for the quick response,

I have done the first two parts created a web form and while user enters the Purchase iD the information gets stored in ctx variable.

 

Is there any document or sample i can get for writing querydef?

 

Regards

Jay

Jonathon_wodnicki
Community Advisor
Community Advisor

Hi,

 

Can use JS with querydef, though maybe Preloading activity will work by changing Method to List of fields and using (guessing) the correct field?

 

Thanks,

-Jon