Help with complex form functionality

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:

  1. Lookup bike ID (look up in Table A)
  2. Bike Description (prefill based on 1)
  3. Full Price (prefill based on 1)
  4. Subsidy scheme (lookup Table B)
  5. Subsidy amount (prefill based on 4)
  6. Total Due (formula 3-5)

Any suggestions on how to achieve this?

I think you need an intermediate Table. You have A: Bikes, and B:Subsidies. Add a “Transactions” Table.

Unfortunately you can’t display calculated values on your form