Automatic date formatting
Budget: $10 – $30 USD
I have a Cognito form (see attachments for a screenshot) whereas an employee will complete the form as to their availability for the following week. I need to be able to use zapier to format and send the info to a google calendar or I can use zapier to send the data to a google sheet where it would get formatted with the correct date based off the day of week listed in the same column. Then I would use zapier to send to my calendar.
I don't care if the formatting takes place in the cognito form or if it happens on a google sheet. Somehow I need to automate the data from the submitted forms into displaying on my calendar for the following week.
I'm pretty good with Zapier, but don't see a way to translate the day of week to an actual date (next week) and have it work week after week. If there is a way we can skip the google sheet - I'm open to ideas/suggestions.
I don't care if the formatting takes place in the cognito form or if it happens on a google sheet. Somehow I need to automate the data from the submitted forms into displaying on my calendar for the following week.
I'm pretty good with Zapier, but don't see a way to translate the day of week to an actual date (next week) and have it work week after week. If there is a way we can skip the google sheet - I'm open to ideas/suggestions.