Solved: Two apps using one spreadsheet - Page 2

yumei · 09-30-2022 07:09 AM

In my late night search for solution for something else, I came across one suggestion about creating a second app for the same set of data, but with different permissions, as a solution to control different levels of access. But I can't find it anymore.

So is that a viable approach? Has anyone done it? What should one look out for?

Islom

1 - To hide columns from users, you can use SWITCH() in SHOW_IF(2) section from UX(1)

2 - In order to give certain access for users you may SWITCH() formula in Table(1) -> Sample(2)
1)

2)

Also, check out this first: https://support.google.com/appsheet/answer/10107700?hl=en

View solution in original post