Smartsheet error - Row not deleted because its Smartsheet Row ID '' cannot be converted to type lon

[rodsouza06]

I was having a frequent error with smartsheet integration.

The message is:

Unable to delete row from table '<table>' - Row not deleted because its Smartsheet Row ID '' cannot be converted to type long.

When I checked the 'Queued Local Changes' I have noticed that the action to delete the row had the Row ID with blank value in request, and when AppSheet tells to Smartsheet to delete that row the Smartsheet API returns an error and then it is not possible to sync any changes.

In my case, It was happening because when the user do not wait to finish to sync the 'add action' and just deletes or edit the register, AppSheet do not get the Row ID from Smartsheet, but still requesting the delete or edit action to Smartsheet API.

The workaround that I have found in my case is:

In every edit action or delete action in app at 'behavior '> 'Only if this condition is true', put the expression:

ISNOTBLANK([Row ID])

I hope it may help who is having this issue!!

[Fabian_Weller]

@rodsouza06 Thank you for this workaround. Have you also sent a bug report via https://support.google.com/appsheet/gethelp ?

[rodsouza06]

Hi @Fabian_Weller !

I have just sent a bug report now.

Thank you!

[SmartsheetGuru]

@rodsouza06 Thank you for this. I just ran into this issue!