Updating a column based on a data entered via an action Set the values of some columns in this row

AppSheet AppSheet Q&A
1

Long time user of Google Sheets as an Appsheet data source. Started trying out the AppSheet database and looking at alternatives to using Virtual Columns. Not sure if this is possible. It works when I test the expression but not practice. By in practice, I mean when I try run the action and update the numeric column [s1].

Using the Action Data: Set the values of some columns in this row

ANY(SELECT(Points[points], 
([h1]-ANY(SELECT(Course[par1], ([_THISROW].[courseID]=[courseID])))
    - ((NUMBER([hcap])/18)
    + IF(MOD([hcap],18) >= ANY(SELECT(Course[index1],([_THISROW].[courseID]=[courseID]))), 1, 0)))
=[netScoreToPar]))

Is it because I am trying to update a numeric column with the value from a list?

Or is this even possible using the database and I need to go back to using Virtual columns

Thanks for any help

PM

2

I strongly recommend against AppSheet Database. I prefer Google Sheets. If you suspect virtual columns are causing performance problems, AppSheet Database will not help.

Aside from that, please clarify how your action isn’t working? Nothing’s changing? Wrong value? Changes but not when you expect it to? Please also post a screenshot of the action configuration. Also, since you didn’t mention it, please note how your action is being triggered.

3

Apologies @Steve for the late reply. It was purely research into using different sources. Will take your advice and stay away from the Appsheet Database. Thanks

1 Like