_RowNumber" Required Issue in "Add new rows" Automation

AppSheet AppSheet Q&A
,
1

I’m encountering a problem when using AppSheet Automation to create new rows in the “QuotationDetail” table. This table has a “_RowNumber” column which is set to Required, but my Automation is unable to input the correct data for this column, resulting in the following error:

Error encountered in step with name [Add Rows To QuotationDetail]: Error: Perform DataAction 'Action for Add Rows To QuotationDetail' failed because Can't add or update a row because a required value is missing. Provide the required value and try again.
Missing value in column: _RowNumber
Expected data type: Number

What I have already tried:

  • Verified the “_RowNumber” column settings in the QuotationDetail table, confirming that Require is enabled.
  • Tested the Automation and examined the Log Errors.
  • Attempted to disable the Require setting for the “_RowNumber” column, but the issue persists.
  • Confirmed that the “_RowNumber” column does not utilize Auto-increment or any default values.
  • Searched the forums and found that other users have experienced similar issues. (Reference: [Link to relevant forum post])

What I need:

  • I need AppSheet Automation to successfully create new rows in QuotationDetail by inputting the correct value in the “_RowNumber” column.
  • I’m seeking advice on how to resolve this issue or correctly configure the Automation.

Additional Information:

  • Error screenshot: (Attach screenshots of the AppSheet Editor and Log Error)
  • QuotationDetail table structure: (Specify columns and data types)
  • Automation details: (Specify the Action used to create rows and any relevant expressions)
  • AppSheet version: (Specify your AppSheet version)
  • Data source: Google Sheets

Thank you for your assistance.

Capture d’écran 2568-03-23 à 18.14.30.png
Capture d’écran 2568-03-23 à 18.14.30.png1726×1290 437 KB

Capture d’écran 2568-03-23 à 18.14.06.png
Capture d’écran 2568-03-23 à 18.14.06.png2216×1346 266 KB

2

[_RowNumber] is a legacy column that was used to be able to apply a default key column when one wasn’t specified. It is assigned a sequential value automatically by AppSheet. Apps cannot assign values to it. Uncheck all properties to this column and then leave it alone - just ignore it. I strongly advise against ever using it in any of your implementations.

3 Likes