My App has ‘Parent Only’ tabs. I created a Users sheet and added 75 email addresses. I then added a column for ‘user specific’ and filled the column with ‘True’.
I then made the newsletter component 'visible if Newsletter contains True.
This worked well.
But then the column filled with True became empty. So I refilled. It was now working again.
This has happened constantly.
Any ideas why? Did I miss something when setting up?
Due to having to constantly refill the 75 rows with True, I see that I can’t fill down in any way?
If you’re using a public app, that “User Specific” column will be cleared out after a while.
What you can do is, if I’m understanding how you construct it, is to add that True column as a normal column in your sheet and do the filter with it. In the Users sheet you also have emails that are not available to view Newsletters right?
I have a Users sheet that contains the emails of all users who CAN view the Newsletter.
This users sheet ALSO contains a column called Newsletter and another called Timetable both of which are ‘user specific’ those 2 columns are prefilled with true.
The Newsletter component has a visibility set to only view if signed in person has their row with an approved email and True.