I should set the scene by mentioning that I have the IQ of a potato, so please be understanding. ![]()
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:
![]()
I would like to:
- 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:
- 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

