How do I create an event on Google Calendar based on the value from Formatter?

Question

Hi,I am trying to create a google calendar event bud the date ov the event is dependant on the data that returns from the Formatter step.For example if the day of the week that returns from the formatter is “sunday” than i want the event date to be thursday (the last business day in my time zone)but if the formatter returns “wednsday” than the event date should be tuesday  (the last business day in my time zone).is that possible?

jesse · Accepted Answer

Hey @Konimboand for anyone following along! I am going to sum up some of the suggestions on this thread, for anyone looking to implement something similar in their workflow:You can use a Formatter > Date / Time > Add/Subtract Time to adjust Dates.You may also need to use a Formatter > Utilities > Lookup Table to translate Sunday to +4d to get Thursday.I think you may need some conditional logic also, like an “if event lands on Wednesday run this formatter step, if event lands on Sunday run a different one.”Maybe paths would also be needed in conjunction with formatter 🤔 I am curious to see what we can come up with! 🙂Best of luck! We’re here if you have any follow-up questions!

TamRazzleDazzle · Answer

Hey @Konimbo! Were you able to add in the step for adding/subtracting time like Troy mentioned? I’m not sure if that would solve your issue entirely. I think you may need some conditional logic also, like an “if event lands on Wednesday run this formatter step, if event lands on Sunday run a different one.”Maybe paths would also be needed in conjunction with formatter 🤔 I am curious to see what we can come up with! 🙂

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded