Cancel Appointment in Acuity to Delete Row in Google Sheets

Dr Julius

Member
Hello,

I am seeking guidance in setting up how to delete a row in Google Sheets after the client cancels an appointment in google Sheets.

I have: 1)Set the trigger to Appointment Cancelled (In Acuity)
2) Set an action to Lookup spreadsheet rows in Google Sheet
3) Set an action to Delete Row
Problem: I have identified that the "end row" would be the index row, what should the start row be? The instructions said the "start row" "Enter the start row number of Spreadsheet to be deleted. Note that it will delete the next row available just after the start row number which is set.", which means it should be the row above, so what value should it be linked it?
 

Supreme

Well-known member
Staff member
Hey @Dr Julius

3) Set an action to Delete Row
Problem: I have identified that the "end row" would be the index row, what should the start row be? The instructions said the "start row" "Enter the start row number of Spreadsheet to be deleted. Note that it will delete the next row available just after the start row number which is set.", which means it should be the row above, so what value should it be linked it?
You can refer to the following thread regarding deleting the row from your Google Sheets.

 

Dr Julius

Member
Thank you! Can you also direct me to the workflow that speaks to Rescheduling and Edit Forms where changes are made in Google Sheet?
 

Dr Julius

Member
Thank you for your response. I have fixed the delete row issue.

Now, I am trying to update the spreadsheet row if the client clicks on "reschedule" or "edit form" in Acuity
 

Supreme

Well-known member
Staff member
Hey @Dr Julius

You can check out the following screenshot for your above concerning use case.

1654689924274.png
 
Top