I have a spreadsheet that is populated with data via a google form. I also have a Google App script associated with the response spreadsheet. The script has several versions that do slightly different things and I need to run a specific version of the script based on a cell value in the response sheet. The problem is it always needs to be the last cell in column "J" with data in it.
For example, the form gets submitted and populates row 5. I need the "if statement" to look in J5. The next time the form is submitted it will populate row 6. That time I need the "if statement" to look in J6. And so and so on.
I'm fairly new to google app script, but I'm familiar with if statements.
Any help is greatly appreciated.