c# - Google Spreadsheet API, Multiple User, Adding new row and Updating row at same time -

so able play google spreadsheet api, intend use c# apps database, people can use either web (via docs) or desktop (via c#).

there 1 problem i'm afraid of: there conflict if 2 people doing inserting + updating.

scenario:

there 2 user,

• a in charge of adding new row
• b in charge of reviewing a work , putting comment.

both a , b working @ same time.

conflict i'm afraid of:

when b using apps update comment, apps data , have row ranges, let a100:h100, a proceed add data.

i'm afraid if data added above a100:h00, when apps submit changes b, not placed in correct row.

is there anyway avoid this?

yes, can add , update @ same time using google sheets api. batchupdate best method work taking 1 or more request objects, each 1 specifying single kind of request perform.

when updating spreadsheet, kinds of requests may return responses. these returned in array, each response occupying same index corresponding request. requests not have responses. requests, response empty.

typically "add" requests have responses, know information (such id) of newly added object. see response list of supported responses.

sample update response:

{    // union field kind can 1 of following:   "addnamedrange": {     object(addnamedrangeresponse)   },   "addsheet": {     object(addsheetresponse)   },   "addfilterview": {     object(addfilterviewresponse)   },