How to create an option of user consent to make record public/private?

[akshadaks]

How to create an option of user consent to make record public/private?

So that once the selects private no other user can see the record, and if the current user selects public, then everyone can see.

[Joseph_Seddik · Accepted solution]

I would do the following:

1. Register the user’s choice in an Enum or Yes/No column, with the display value as a question to the user. Let’s name it “consent”.
2. Create a column “userID” to capture the user who created the record and set its value to USEREMAIL().
3. Create a slice of your table and set its row filter to the following formula:
   OR(
   [consent] = “public”,
   [userID] = USEREMAIL()
   )

Perhaps more AppSheet-experienced fellows here can give us a better/simpler way.

Update:
There is also the Table’s Security filter, that you could fill with the same formula above, instead of creating the slice.

[Joseph_Seddik · Accepted solution]

You can show us some screenshots, of the app editor and the table source.

Alternatively, you can also share a link to your own App editor. HOWEVER, I’m not experienced enough in AppSheet to assess the security impact of this action, never used it and haven’t read about it.