Need help with appsheet api to edit row(s)

AppSheet AppSheet Q&A
, ,
1

I am using below post query to edit rows in my table:

URL: https://api.appsheet.com/api/v2/apps/xxxxxxxxxxxx/tables/COMPANIES/Action?applicationAccessKey=xxxxxxxxxxxxxxxxxxxxxxx

{
	"Action": "Edit",
	"Properties": {
	   "Locale": "en-US",
	   "Location": "47.623098, -122.330184",
	   "Timezone": "Pacific Standard Time"	   
	},
	"Rows": [{"ID": "<<[_THISROW].[PARTNER ID]>>" , "NOTE":"SOME NOTE"}]
}

Everything work as expected.
The comlumn NOTE in table COMPANIES is updated whenever the bot is fired.
BUT, it only works when column NOTE is blank!!

Question: How can I use appsheet API to find some row, on some condition, and edit its value?
In my case above, I can only find row ID and edit NOTE column when NOTE column is blank!

2

Do you have something in the Event’s condition rule? It should not matter if the column’s value is blank or not.

1 Like
3

Thank you for your hints. I’ve found out my problem. It’s because one of my column is set using formular app. I change it to text and it fixed my problem.

4

Excellent!