Look at the shopping list spreadsheet. The Status and the Remarks columns are currently empty. You may have guessed it by now, but those empty spaces are meant to be used by the robot to indicate whether or not it was successful in making the purchase. If, for some reason, it encountered an error while adding the item to the cart, it will write something into the remarks column.
Earlier, we read the entire spreadsheet into a collection. Now, let's try to update it using the MS Excel VBO library. To do so, we will create a new action page, as shown in the following steps:
- In the Weekly purchase of groceries process, create a new page named Update Status.
- Add two inputs to the Start stage. We want to pass in the status text message as well as the row number to update. Add the following input fields:
| Name | Data type |
| Status | Text |
| Row Number | Number | ...
