Set User Setting Based On Row Clicked

[PhilSt]

Hi Everyone, 

I'm not sure this is possible or if I'm missing something easy, but was looking at the Horizontal scaling article link below. I'm wondering if the User Setting can be set based on selecting a dessert type in a table (if that makes sense). Or, if I have a dessert type table if they have to select it there as well as manually inputting the value into the user settings. Thanks!

https://support.google.com/appsheet/answer/10104385?hl=en&ref_topic=10104704&sjid=939394805984638740...

[AleksiAlkio]

I'm afraid you can't change the Usersettings other than manually opening it. One workaround is if you have a users table, you could write the dessert ID to the user's record and filter based on that with an action when for example the dessert row is clicked.

[PhilSt · Accepted solution]

Thanks for the recommendation! Just for documenting info here's what I did:

1. Created a Users table that had an ID column (for a unique key, but I don't use UNIQUE() I use my own), User Email Column, and Desert Type ID.
2. In the View under behavior, when row is selected I had it set to a Group Action.
3. Create 3 actions: 1 that group action that calls the following: 1 that does the standard behavior of opening the detail view (using go to another view within the app utilizing LINKTOROW), and the final action that uses Data: add a new row to another table using values from this row): this writes the user Email as well as the Desert Type ID that was clicked to the User table.
4. Added a security filter to get the most recent Users value that was written (or just clicked by the user):
   IN([DESSERTTYPEID],
   SELECT(
   User[DESSERTTYPEID],
   MAX(
   SELECT(User[ID],USEREMAIL()=[User Email],true)
   ) = [ID],true
   )
   )
5. I'll probably run a nightly script to clear out the Users table as it's really just a transactions table of what they clicked on.