I have a list of customer’s
I have a form that uses select to identify which customer is receiving an order.
These orders feed into one sheet.
I have been presenting this information in an in line list.
I would like the information to be viewed by signed in customer, but just can’t seem to link customer name to email with relations link.
If you already have a relation in the order linking the customer name in the order sheet to the name in the customer sheet, then all you need to do is add a lookup column in the order sheet to get the email address from the relation. Having the email in a lookup column, you can apply a filter by signed in user against that column.
Cheers, I’ll give that a go.