I created an app with two profile tables, a private user’s table and a public user’s table. I want to create a directory tab to list the public users name, city, and department. The department is a lookup column so when I open the table it only pulls in the department for the signed in user. How do I display all columns so that all users can view.
Assuming that you have applied Row Owners to your Private Users table, then any unowned rows will not exist on user devices, and therefore cannot be displayed.
So any additional columns that you want to make available would need to be added to the Public Users table.
2 Likes