Hi, I have questions regarding external users’ right with linked fields between 2 sheets.
For example, sheet A contains the information of chain restaurants, and sheet B is for local branches. So when external users such as local branch owners create entries for their branches in sheets B, I want them to be able to select the name of the restaurant(i.e. KFC, McDonalds, Burger King, etc) from the existing info from A. I used “Select from another sheet” and linked to the “Name” field in sheet A.
However, since external users can only see their own entries. Unless they create something in sheet A, they are not able to select from the existing list from sheet A.
How can I achieve this goal? Thanks!