API Update rows

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 Solved
0 5 878
1 ACCEPTED SOLUTION


@Pethipojquis56 wrote:

should i contact support?


Yes, if you've confirmed that the following expected behavior is not occurring:

  • You use the AppSheet API to update a row.
  • That row's columns that have an App formula expression do not recalculate.

View solution in original post

5 REPLIES 5
Top Labels in this Space