When trying to reference user settings values in automations, I observe inconsistent behavior and encounter confusing information in AppSheet Help and from AppSheet Support. I'd appreciate your perspective.
@Simon_Robinson wrote:
because this is a bot, its operating without login information
First of all, regarding @Simon_Robinson's question, my understanding is that the key distinction is whether the automation is triggered by a data change, in which case the user settings values from the user's device where the change occurred should indeed be available for reference in the automation, or triggered on a schedule, in which case there's no user's settings to reference. Is that your expectation?
Here's the issue I observe: I have longstanding automations with webhook steps that function reliably using the USERSETTINGS function in the JSON body. However, when I have more recently created automations using that same technique I receive an error in the app editor like the one in the OP. Seemingly in conjunction with the support case I opened regarding this problem, the Call a webhook from an automation - AppSheet Help article was recently updated to note "Do not specify USERSETTINGS() in the JSON body of a webhook task. It is not supported at this time.". Does that caveat match your understanding of the functionality?
@AleksiAlkio wrote:
ANY(_Per User Settings[CSVLocale])
Is your understanding that this technique should work? When I attempt to reference user settings in an automation using either USERSETTINGS() OR [_THISUSER] and it doesn't work, the error I receive is always what appears in the OP's last screenshot: "Unable to find column '_THISUSER'."
LinkedIn
Twitter
