Great news thanks I have that working but have another question.
In the zap we have a step send evaluation form to teachers.
I need to automate the date required for that item in Monday.com Obviously the field is the date the event is due to run plus say 24 hours Hopefully the below will make it clear.
This is where I need to pull the date in
But I need it to be this date shown below plus 1 day
The issue is that each event is different date and rather than having to manually enter it is there a way to select that date plus a day in zapier
Best answer by SamBBest answer by SamB
Glad that’s working now @Magpie2000k! Hope you don’t mind but I’ve moved your new question out into it’s own topic since it’s different to the one being discussed previously.
It’s possible to use date/time modifiers like +1d to add a day to a selected date in a date/time field.
For example this set up: Would result in the date being added as 2023-04-21 in Monday.com. And as the field from Google Sheets that contains the date is select that will meant that whatever date is present in the row that triggers the Google Sheet will have 1 day added to it automatically by the Zap.
Just make sure to leave a space between the selected date and the date modifier ( +1d). You can find out more about working with date/time modifiers here: Adjust date and time values in Zaps
Glad that’s working now @Magpie2000k! Hope you don’t mind but I’ve moved your new question out into it’s own topic since it’s different to the one being discussed previously.
It’s possible to use date/time modifiers like +1d to add a day to a selected date in a date/time field.
For example this set up: Would result in the date being added as 2023-04-21 in Monday.com. And as the field from Google Sheets that contains the date is select that will meant that whatever date is present in the row that triggers the Google Sheet will have 1 day added to it automatically by the Zap.
Just make sure to leave a space between the selected date and the date modifier ( +1d). You can find out more about working with date/time modifiers here: Adjust date and time values in Zaps
Thank you all I have sorted it with all your help out there.
I have now mastered what to me was a fairly complex Zap. Lets see how much more fun I can have and time I can save the whole team… Should have used this on so may projects over the last few years.
Just to make sure we're on the same page, is the issue you're encountering related to the same Zap discussed in this post? If so, it would be super helpful if you could provide some context and perhaps share some screenshots of your entire Zap setup. This will allow us to better understand what might be going wrong.
We're particularly interested in seeing the "Action" section of your action steps, which includes all of its fields. Here's an example of what we're looking for:
