Hi
I have literally just found AppSheet after spending forever creating a HTML Form with Google Apps Script. Although it works, this could be better in the long run.
I am trying to create a quick pricing calculator to help me price up jobs.
Brief explanation. I am a sign maker, I use many different types of materials / brands etc but essentially all I care about is what type of media it is i.e Media Type A, Media Type B, Media Type C etc.
If it’s Media Type A, I know I can use it on Vehicle Graphics, Window Graphics.
if it’s Media Type B, I know I can use it for Magnetics, Premium Vehicle graphics.
My table looks something like this:
Media Type | Brand | Range | Application Type
Media Type A | Brand A | Range A | Vehicle Graphics (Basic)
Media Type B | Brand A | Range A | Vehicle Graphics (Basic), Vehicle Graphics (Premium)
I want a dropdown list that looks through all the Application types (separating values by comma) and displays them in my dropdown menu minus any duplicates.
When I select the option, It will then give me a dependent dropdown list of Media Types Available > Brands, etc. Finally storing all the info in a separate table.
So far I have managed to get a dependent dropdown menu but there are 2 options I can;'t figure out.
Firstly, how do I create the first dropdown list that looks for the Application types?
Secondly, how do I post the price back to the separate Google Sheets table without showing the form field?