I was looking to update/recalculate a lot rows in a table, using an action adds to much to the sync so i was looking to use the API to update the rows. Assuming i want to update all rows on a table how would i make that call?
Here is what i want to do, the column that i want to recalculate (Total) already has an appsheet formula, I want to call an api which recalculates the apsheet formula for that column after reseting the values to 0 how can i do that.
{{
"Action": "Edit",
"Properties": {
"Locale": "en-US",
"Location": "4.623098, -1.330184",
"Timezone": "Pacific Standard Time",
},
"Rows": [ <<START: SELECT(Temp Roof replacement Template[ID], NOT([Material]="wtf"))>>
{
"ID":"<<[ID]>>",
"QTY/Length":"<<[Blank template 0 number]>>",
"input extra matrial":"<<[Blank template 0 number]>>",
"Total":"<<[update value?]>>"
}
<<END>>
]
}
Solved! Go to Solution.
@Pethipojquis56 wrote:
should i contact support?
Yes, if you've confirmed that the following expected behavior is not occurring:
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |