I am quite new into app.sheet, so hopefully you guys can help me out.
We have a customers sheet(ref values), with customer data, first, middle name, last name, adress etc etc.
I want to create a dropdown menu, where we can select or search in the gsheet with all the customer information. We can search on firstname, middle and lastname.(ref values)
And we can save this data to another gsheet(dropdowns)
Already found an example of it.
This is working, but only for one column with the function ref, what i want is if i select one name in the ref values that he will also copy column middle naam, last name to gsheet dropdowns from the same row.
How can i do this is?