I'm trying to create a form that populates two different text fields based on the selection of a drop down menu. I have no scripting knowledge and am confused by everything I'm reading online. Can someone please help me.
I'm attaching the file. I already made the form but can't figure out how to do the drop downs.
I want to made a selection in the Item field and then I want it automatically populate the description and price.
I am attaching links for the form and an excel document with the items, descriptions and prices.
But my question is, doesn't every item in your item list HAVE or correspond to an item description? If so, this would be easier to NOT have a list box for the description and unit price but have a text field that displays the proper description for the item and price when something is chosen from the list.