I’m looking to set up a more complex form than I think is possible using Airtable standard forms, but am unsure what alternatives will definitely do what I want.
We are hoping to sell refurbished bikes and collect gift aid from the sales. I need the buyer to be able to use a form to lookup the ID of the bike they are buying, and for the form to then pre-populate some fields with the correct information (e.g. price, bike description). We then need the bike buyer to be able to say if they have a voucher which entitles them to a subsidy, and for that subsidy to be taken away from the final price they have to pay. We don’t need this form to then act as a POS system.
So assuming we have two tables, Table A contains details on the refurbished bikes and Table B contains details about the subsidy I want the form to look a little like this:
- Lookup bike ID (look up in Table A)
- Bike Description (prefill based on 1)
- Full Price (prefill based on 1)
- Subsidy scheme (lookup Table B)
- Subsidy amount (prefill based on 4)
- Total Due (formula 3-5)
Any suggestions on how to achieve this?