Hi guys,
I have a pretty simple calculator I want to present in Softr that tells my staff how many of a particular product will fit into what boxes e.g. They select “Chocolate Bar”, enter a quantity (e.g.700), and the calculator returns the result “2 x Large Boxes and 1 x Medium Box”.
In Airtable, I have everything setup and working. I have my Products table arranged by Product Name/SKU (this I would like as a dropdown in Softr, but Softr only allows this on single select or multi select fields).
For each product, I then have how many would fit in a Small, Medium and Large Box.
Finally I have my formula field which in Airtable (“Packing”). Once a quantity is entered in the “Freight Quantity” field, this field correctly advises what box combination should be used e.g. “2 x Large Boxes and 1 x Medium Box”.
I’ve tried using a form to return the result, but like I say above, it will not allow a dropdown for a user to select the products. I could make users type the SKU themselves, not very user-friendly, but possible.
Getting it to return the result is where I’m stumped. Is the form the right way to go about this?