Solved: Update a column value in a task using a value from... - Page 2

conscientia · 12-07-2023 07:23 AM

I've an automated task that at the end of the task I'm trying to set a column value on the updated row with a USERSETTINGS("Value").

I get the following error: Unable to find column '_THISUSER', did you mean '_RowNumber'?

Tried to explicitly use: [_THISUSER].[Value] - still no luck.

Seems like this should work?

Thanks!

Landan_QREW

Well, you really need the variable to be server-side if a bot is going to access it. That is not much trouble as any table in the app can be accessed server-side (with the exception of the USERSETTINGS table).

So in essence, you just need to create a table in Sheets or whatever your back-end is and have one row per user (as shown in the image below).

In the example, you will notice the app_role column is essentially a variable. This can be accessed by a bot in a number of ways.

The best way is to do a query based on the current user's email: ANY(SELECT(user_variables[app_role],[email]=USEREMAIL()))

Regarding the payment question, I don't think any deployed app can be free. Only undeployed apps can be free, but undeployed apps will not send emails to anyone but the app owner and I believe you can not have more than 10 monthly users on an undeployed app.

View solution in original post

Update a column value in a task using a value from Userssettings