Someone please help!
I'm working on creating a quote generator for an appliance company. We are attempting to automatically generate a price that depends on three things.
Appliance Type, Appliance Brand, and Job
Type and Brand are independent of one another. I've solved this problem by using the SELECT(...) feature to populate a dropdown for each of those inputs.
Job is dependent on Appliance Type. (EX. Washers will return a list of jobs for washer, Dryers a list of jobs for dryers, etc.)
I cannot seem to understand how to format this properly so that I will get jobs to populate a specific list based on which choice is selected in the Appliance Type form input.
Thanks in advance!
User | Count |
---|---|
18 | |
13 | |
8 | |
4 | |
2 |