multiple options form

Hello @benlashley80

Your solution is not optimal. A better alternative is to enter an object with the data definition and access this object directly from the equations.

For example assuming you have three fields in the form:

fieldname1, a dropdown field for products with values: Accident & Injuries, …
fieldname2, a dropdown field for types, with values: Individual, Single parent, Couple, …
fieldname3, a dropdown field for units, with values: 8, 4, 2, and 1

Now you need only to insert an “HTML Content” field in the form (tick the checkbox in its settings that allows you to enter script tags in its content), and enter an array of objects:

<script>
db = [
{product: 'Accident & Injuries', type: 'individual', unit: 8, price: 78},
{product: 'Accident & Injuries', type: 'individual', unit: 4, price: 42},
{product: 'Accident & Injuries', type: 'individual', unit: 2, price: 24},
{product: 'Accident & Injuries', type: 'individual', unit: 1, price: 15},
/* The other tuples with the complete database */
];
</script>

Finally, the equation that determine the price is as simple as:

(function(){
for(let i in db) {
if(AND(db[i]['product'] == fieldname1, db[i]['type'] == fieldname2, db[i]['unit'] == fieldname3)) return db[i]['price'];
}
return '';
})()

And that’s all.

I needed only the fields to allow the users to enter the data for filtering, and an “HTML Content” field for entering the array of tuples (the tuples can include as much information as you want).

Using DS fields, you can enter your tuples in Google Sheets (a database, a JSON object, or simply a CSV file), and use them from the form:

https://cff.dwbooster.com/blog/2019/02/14/ds

This alternative allows you to update the Google Sheets document; the form will use the new data without editing it.

Best regards.

Hello @benlashley80

The process is straightforward, but assembling the dataset is a tedious and repetitive task.

Best regards.

Excellent !!!

Best regards.