I am trying to create a form using airtable which does the following:
I have a sheet with a bunch of digital services are listed as products.
When a sales sheet is done at the end of the day, the rep selects all the digital services and products (like a website) which they sold in the day.
What I need is when someone selects that they sold a Google adwords package (price is flexible), than a field pops up to ask HOW MUCH in Rands ZAR value, the rep sold adwords for.
How could I go about creating that?
I need the rand value from that deal to be saved to the clients profile.