Hi All . i have i hope a simple question
I have a single select where my employees can choose a size of a product .
in the next field i have a price field and the next is a amount field and the last is a formular to get the price
this works as it should .
my question now , is there a way to give discount if we choose more than one in amount
for example i want to add a 50 % discount if anyone chooses 2 in amount . is this possible in Airtable ?