Adding Submit button to your App's page, Workflow button gets enabled. If you need to understand What are workflows, you can refer here 

Both SUBMITID and ROWID are reserved keywords which are auto-generated when a New data is added into Sheets using Workflow. New data can be added into sheets, either through Workflows or Sheets.

When new data is added through Workflow using Submit button, then there are 2 cases -

  1. A Single Row added into Sheet
  2. Multiple Rows added into Sheet (Using Section Repeat)

Single Row Added

In case a Single Row is added to a Sheet than both SUBMITID and ROWID will be unique in their respective column for that particular Sheet.

Let see an example to add Single row -

As shown above, We have a Product Form which has Product name, Product Quantity and Submit button control.  

As shown in above Workflow, Data is submitted into UniqueIdSubmissionId sheet (having 4 columns - ProductName, ProductQuantity, SUBMITID and ROWID), where product_name is unique name for Product Name control and singlequantity is unique name for Quantity control and SUBMITID & ROWID are auto-generated keyword which will be created when this data is submitted from Product Form.

As shown above is the UniqueIdSubmissionId sheet, where data is Submitted from Product Form twice - One with Product name Computer and Other with Product name Mobile. 

Multiple Rows Added

In case Multiple Rows are added to a Sheet than ROWID will be unique for all rows added whereas SUBMITID will be same for group of rows added together but unique with respect to previously added SUBMITID's.

Let see an example to add Multiple rows -

As shown above, We have a Product Form which has a Section Repeat control which holds Product name and Product Quantity and Submit button control. User can click on + More button to add more products.

As shown in above Workflow, Data is submitted into UniqueIdSubmissionId sheet (having 4 columns - ProductName, ProductQuantity, SUBMITID and ROWID), where section_repeat is unique name of Section Repeat control and product_name is unique name for Product Name control and singlequantity is unique name for Quantity control and SUBMITID & ROWID are auto-generated keyword which will be created when this data is submitted from Product Form. Additionally, To add multiple rows we need to enable Repeat Insert operation toggle and add Column names of sheet where multiple values need to be inserted in separate rows.

As shown in above UniqueIdSubmissionId sheet, data is added by submitting from the Product Form. As shown in above form image, 2 Products are submitted from Product Form in single Submit using Section Repeat. As you can see, since each product is added into different row and ROWID is unique for all rows added whereas SUBMITID is same for group of rows added together.

To Summarize, ROWID can be used to uniquely identify a Row in Sheet whereas SUBMITID can be used to uniquely identify group of Rows submitted/Added together.

Did this answer your question?