I have a scenario that adds a new row to a Google Spreadsheet. I need the new row to be added to the bottom of the spreadsheet and I don’t see anywhere in the settings of the module to control this. Currently the rows are randomly added to the sheet and are creating a huge mess. The rows cannot be sorted as there is a monthly row of calculations that need to remain under each month. Please advise.
Hi @ADEQ_GIS,
By default, the “add new row” module adds a row on the first empty row. So make sure you don’t have any empty rows in the middle of your sheet and the rows will be added as expected.
Hi,
Within that new row, if we have a date column, how do we format that column so it has the date as mm-dd-yyyy?
@ADEQ_GIS you can use formatDate function.
Cheers!
Super late to the party, but if anyone’s interested I found a workaround to this.
- use Get Range values to find out how many current rows there are
- use the array aggregator to count the number of rows
- add a new row by taking the number of rows and adding 1 (if there are 200 filled rows, I want the next row added to be row 201)
c
