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.
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.
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.