Could you please provide any suggestion to build logic for below scenario??
Progress:
I have one data extension which has three columns:
- City
- Area
- Center.
I have created landing page which has the three picklist fields listed above.
in first picklist i have populated the distinct values from City
Challange:
First only city picklist is visible and the other two picklists should be disabled.
When the user selects any value from city picklist, then it should give call to marketing cloud server with selected city parameter before allowing the user to click the submit button.
The server will search the Area column of data extension, using passed City value and return the matched area values under particular city to new Picklist
I need help on two topics:
How this logic should be implemented - Meaning should call be made before clicking on submit button? Meaning when user select the value from picklist.
I haven't came across this server client scenario. I have seen some examples where RequestParameter() is used, but i don't exactly where should i write this logic. Should i create two landing page one for form and one two handle server logic?
Please explain with some steps