Assigning unique coupon codes to records based on view from form

Hello! I am wondering if the following is possible:

Looking to have a form uses can fill out with different variables. (IE - income, number of children, zip code, etc)

I am then wanting to give them (could be via email using Zapier) a coupon code that is predetermined for a certain percentage off.

What I am thinking is, there will be different views for each coupon amount, and another table with all the coupons for that amount listed. Ideally, someone would fill out the form, Airtable would then (using Zapier, I assume) assign them a code from the correct table, send the user an email with code, then mark the code as used in the table.

Any help is appreciated, thank you!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.