I am trying to write a script that auto-fills three boxes based on a choice from a drop-down menu.
The drop-downs are called "LocationA", "LocationB", and "LocationC" and the boxes are called Breakfast, Breakfast 2, Breakfast 3, and so on with Lunch and Dinner. There are several options, like, if LocationA is $42/Day, then Breakfast is $10, Lunch is $12, and Dinner is $20. If LocationA is $56/Day, then Breakfast is $11, Lunch is $15, and Dinner is $30, and so on.
How do I write the script? I found an example but it doesn't work when I sub in my information.
Is there a formula, or just arbitrary values?
Well, this is what I was able to find online:
I'm positive the bolded areas are wrong. The version I was able to find didn't explain where those values came from, so this was our best guess. The code is supposed to auto-fill LocationA (Location 1) but also leave availability to fill Location 2 and Location 3.