Hi I am trying to call a webhook using a bot automation in appsheet. The purpose of this automation is to edit the column Available Stocks from the inventory table when a Stock Out log row is deleted
Void Stocks Out
{
"Action": "Edit",
"Properties": {
"Locale": "en-US",
"Location": "47.623098, -122.330184",
"Timezone": "Pacific Standard Time"
},
"Rows": [
{
"ID": "<<Filter("Inventory",([_thisrow].[ItemID]=[ID]))>>",
"Available Stocks": "<<Any(Select(Inventory[Available Stocks],[_thisrow].[ItemID]=[ID]))+[_thisrow].[QTY]>>"
}
]
}
This is the error I am getting
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |