DropDown Column with user selection tracking

[hartable]

Is is possible to create a Drop Down column:

1. where each user can select an option,
2. The user AND what they selected gets recorded, and can be updated
3. Users can't see what overs selected

Additional question does user access to google sheets backends conflict with security set within the app?  

[jyothis_m]

Limit users to their own data

[hartable]

I have tried this multiple times now, and it's not working which is why I am additionally asking, if google sheet permissions can also cause conflicts.

I've tried:

• https://support.google.com/appsheet/answer/10104977?hl=en
• https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/User-Roles-and-User-Permissions-for-Access-Tabl...
• https://www.youtube.com/watch?v=2Z2qUTtxNFA
• https://www.googlecloudcommunity.com/gc/Tips-Tricks/Current-User-Slice-How-to-conform-your-app-aroun...

and a few others, but users are still able to see everything.

[jyothis_m]

is Require user signin setting enabled in your app

[Steve]

Yes, it's possible to (1), (2), and (3).

---

@hartable wrote:

does user access to google sheets backends conflict with security set within the app?

---

It can if your app is configured to access the spreadsheet as the app user rather than as the app owner. Nearly all apps ar best configured to access the spreadsheet as the app owner.