Error: Perform DataAction โAdd Action FADโ failed because Field โKeyFieldโ in table โActionSheetโ is not updatable. Error: Perform DataAction โAdd Action FADโ failed because Field โ_RowNumberโ in table โActionSheetโ having key โโ is required to have a value. Error: Perform DataAction โAdd Action FADโ โAdd Action FADโ failed with exception Collection was modified; enumeration operation may not execute. .
I am getting the following error when Iโm trying to add a row to a sheet. I have not changed anything recently involving this action or the sheet and am now getting this error. It was working perfectly before. I tried adding an explicit key with RandBetween and a column but that doesnโt seem to have fixed it either.
Hi @Austin_Lambeth, did you add that โrandbetweenโ expression in your app, or in your spreadsheet? Also, is that new column set as editable in the AppSheet column settings?
The RandBetween is in App sheet. Yes it is set to editable.
Does your add-row action attempt to set the _RowNumber column value? Doing so is not allowed.
It does not. Attempting to set the row number value does not even seem to be an option from my action.
You should probably engage support@appsheet.com directly for this.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |