Dynamic redirect based on form submission

[ChrisJackson]

Hi,

I'm trying to create a warranty registration process with a twist. I have a product that will be engraved with a QR code that user will scan to register their warranty.

I created a table with unique ID (Warranty_ID), name and email, file, as well as submission date and WarrantyRegistered with Y/N field type. I populated it with unique ID's starting at 00000001  and down.

I then created the DataPage and set it to receive parameters - the Warranty_ID specifically

I deployed this DataPage and copied the deploy url. I then generated a dynamic QR code and used the deploy URL, with ?Warranty_ID=00000001 as the parameter to be received. I created a QR code for each unique warranty ID, and attached as a file in each corresponding record as a record.

When I scan the QR code, it takes me to the DataPage and I'm able to enter name and email, and it stamps to the table correctly. It also automatically marks the Y/N field as Y and timestamps the submission date

What I need is for the next time the QR code is scanned (and only once the registration has been completed), for the url that was pointing to the registration page to redirect to another DataPage. 

I've tried to follow this method but can't get it to work, particularly the last option to redirect the user the first time they log in. https://howto.caspio.com/tech-tips-and-articles/common-customizations/create-user-specific-redirect-after-login/ I have a feeling it's because I'm not authenticating the page so can't use that as a method!?

Any help will be appreciated

[Vitalikssssss]

Hi @ChrisJackson,

I would suggest using a bit different approach.

QR code will lead users to the 2nd Datapage first and in case if there is no records under the  Warranty_ID the user gets redirected to the 1st Datapage that is the Submission Form.

The concept of re-direction if no records found explained in this topic:

 

Hope this helps.

Regards,

vitalikssssss

 

[Kurumi]

Hi - Just an update, you may now use Virtual Field and Calculated Value on this workflow.

You may use a Virtual Field as a holder or identifier of the value from the dropdown and then set the Form Element as Calculated Value. In the Formula, you may use a CASE WHEN statement like:

CASE WHEN [@FIELDNAME] = 'value'
THEN 'https://www.google.com/'
WHEN [@FIELDNAME] = 'value 1'
THEN 'https://caspio.com/'
ELSE
https://www.youtube.com/
END

After setting up the formula, on the Destination and Messaging configuration screen, set the Destination after the record submits to 'Go to a New Page'. Lastly, in the Page URL, call the Virtual Field from the field picker.

For reference, you may check these links:

https://howto.caspio.com/datapages/datapage-components/virtual-fields/
https://howto.caspio.com/datapages/datapage-components/calculated-values/
https://howto.caspio.com/function-reference/
https://howto.caspio.com/datapages/forms/submission-forms/#:~:text=to make conditional.-,Destination and Emails,-Here you can