Hi guys,
I’ve created a scenario where a restaurant customer can scan a QR code to be taken to a form where they fill in their personal information, then they receive a text with a unique code to redeem a free appetiser.
All is working fine, however, now I want to set up a scenario where restaurant staff can search up the coupon code in the Airtable base to see if it’s valid and to mark it as “redeemed” once the customer has confirmed they would like to use their coupon code. How could I set this up? What interface could the restaurant staff use to search for the coupon code? So far, I’ve set up an interface on Airtable, where they can search to see if the coupon exists using the search functionality, but for staff to mark it as “redeemed”, I need to pay $24 for an account to make edits like this. So now, I’m just thinking ahead, if I have 10+ restaurant clients, costs would add up. So, I’m just wondering, is it possible to search the Airtable database for the coupon code, and then if it’s present, a message displays that it’s present (or not if it’s not present, but if present), then the user gets asked if they would like to redeem it, and if they click yes, the code is marked as redeemed on Airtable and removes the code from the person it’s linked to in a linked record? What app/interface can the restaurant staff use to search for the coupon code for free (expect, of course, the costs associated with Make)?
Hello @kshaan,
I can think of a few ways to go about this, but really depends on the details.
You might be able to get away with using something like Fillout.com. You can build forms that allow you to look up and update existing records in Airtable and literally takes minutes to build.
Another option to consider (without involving third-party tools) is using webhooks.
For example, you could start the scenario with a webhook.
Using a router, if the coupon code was NOT supplied in the webhook query parameters, then use a Webhook response module to serve back a simple HTML form asking for the code.
The submit button would call the Webhook again, this time including the coupon code and details about whether it was used, when it was used, etc…
If it wasn’t used, then display a button that will allow them to use it. This would call the webhook again, this time specifying that you like to redeem the code.
In summary, start the Scenario with a Webhook.
Follow with a router that takes 3 routes:
- No coupon code → Serve back a form asking for the code.
- Including coupon code → Serve back information about the code and optionally, a button to redeem it.
- Including the coupon code and redeem flag → Redeem the code, update Airtable, serve back a confirmation that it was redeemed.
2 Likes
hi @kshaan
You can achieve this by adding a “select one” column in Airtable with options like “redeemed” and “not used.” When a coupon is created, this column can be automatically set to “not used.” Then, when a customer uses the coupon, it can be updated to “redeemed.” This way, the restaurant staff can easily manage the coupon status without incurring additional costs for making edits.
Regards,
Msquare Automation - Gold Partner of Make
Free Consultation | Live Implementation
Visit us here | Youtube Channel
