Trying to understand how a User can edit a User Setting

I should set the scene by mentioning that I have the IQ of a potato, so please be understanding. :blush:

I’m aware of User Settings and have set up a Text settings, “N Recur Month” and checked “Show” and “Editable” and set the Initial Value to “YYYY.MM” as a reminder of the format. This setting will be used to enable setting the value via the UI rather than manually updating the formula:

User Settings.jpg

I would like to:

  1. Have the User (me only) change the value as required, e.g. to “2024.08”
    Issue: I can’t figure out how to do this. I guess an Action button is needed to pop up an INPUT() which sets the “N Recur Month” User Setting (but where does an Action button for User Settings go? Within the field of another table?). When trying to create an Action for this, there’s no option to use the User Settings table:

  1. Have a formula in a View use that setting to filter for that month
    Issue: I’m guessing a bit as to whether the below would be correct to retrieve the “N Recur Month” User Setting:

AND(
CONTAINS([Next Action Date], USERSETTING(“N Recur Month”),
LOWER([Is Arranged]) = “n”,
ISBLANK([Recur Contact])
)

And help would be much appreciated. I didn’t understand the answer given in this thread “Step2: the menu will display the user settings to the users” - no idea what menu that’s referring to):
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/How-does-a-user-change-their-user-settings/m-p/526567#M204151

Once you activate a row in the User Settings, Appsheet will automatically show a new view called Settings. It will be a menu view accessible from the app menu (3 lines on top left).

The User Settings will always be a form view. Of course you can rename the view Display Name.

However, ypu cannot make changes to the selection of the User Settings programmatically (via action button or bot). You have to acces the view from the menu and update values manually.

2 Likes

Oh, so that’s how it’s done! Beautiful. Thank you heaps @JPAlpano . Such a relief to have this sorted.

How is possibile to “activate” a row in User Settings ?

I’ve to simple rename one of the 5 Option here (i.e. “Activate Test”) ?

Cause when trying to create an Action for this, there’s no option to use the User Settings table.