How to update row using rowObject in SpreadSheets?
I’m also looking how to do this. Has there been any responses please?
There are two blocks that you can use to update a row using a rowObject: 'UpdateRow' and 'UpdateRowNum'. The first one assumes that you have the row ID of the row that you want to update (which will automatically be in the _id property of the object or objects returned by GetRow or GetSelectedRows). The second one (i.e. 'UpdateRowNum') assumes that you know which row number in the table that you want to update.
'UpdateRow' updates individual columns of the row indicated by the rowObject. The rowObject must have a “_id” property containing the row ID. The rowObject will also contain property keys corresponding to each of the column names that you want to update. Any missing columns in the rowObject argument will remain as they are set the table.
'UpdateRowNum' is similar to 'UpdateRow' but takes an addition input of the row number that you want to update and does not require that the rowObject contains a “_id” property, since you are identifying the row by number rather than id.
I hope this helps.
-Mark
1 Like