I want to use airtable to distribute audiobook codes to reviewers who request them. I need to keep track of who got which code, and have an easy way of seeing and evaluating new requests. Any ideas on how to configure this on Airtable so don’t have to double enter information?
- Audiobook codes are unique. They are also assigned to a specific book and specific country (UK/US)
- I need to keep track of which codes were already given and which are still available.
- I need to keep track of who got which code
- When a reviewer makes a request, they need to provide their email, the name of the book they want, their country, and a screenshot of meeting prerequisites
I have a Table 1 with audiocodes. Next to each code is the book its associated with, the country its good for (US/UK) and whether it has been given out or not.
I have a form in a separate table - Table 2. This form ask the potential reviewer for his name, which book he wants, a screenshot of pre-requisite, and the country.
Problem… I am having trouble coming up with a workflow where I fulfill requests - something that would associate the requester with a code I assigned him while changing the code to “used” status. Ideas?
Some considerations: I think doing a LookUp for requestor email in TABLE 1 would be impractical - with hundreds of requests, it would be a pain to figure out who the new one is, or to scroll through everyone.
would love your ideas!