Hi, I’m trying to complete a workflow, and I’m not sure if this is possible with the help of Zapier.
I’m trying to create a “confirm order code” to continue. There needs to be a few steps;
- Customer scans QR code that they receive either on a physical voucher or email
- Opens up an “Onboarding Form” on Jotform URL within the QR code
- I need to look up the order code on a “Database of Sales” (Google Sheets), if the code matches, continue
- If it doesn’t match, error code shows
- I then need the form to look up the completed entries of the “Onboarding Form” (Google Sheets) to check that the code hasn’t been claimed already
- If it can’t find the code, continue, if it does, error code shows
- If the code matches and the code hasn’t been claimed, I’d then like the “Onboarding Form” to be pre-filled using the entry from the “Database of Sales” which I know how to do with shortening of the URL with Zapier
Is this possible? Open to suggestion of other apps if there is something I’m missing!