I am creating a google calendar entry for a delivery date/time column in Monday. Once the delivery is scheduled, I only know the day. The zap errors out because no time was entered. I would like to set a default time in my Zap to midnight or 1am since I don’t know the timeframe until the day before the delivery.
Best answer
How do I handle a null value for time from Monday on Google Calendar entry
- Beginner
- 4 replies
Best answer by Troy TessaloneBest answer by Troy Tessalone
Please clarify what Monday Zap trigger event you are using.
This help article provide info about how to use the Formatter > Text > Default Value step that can be used to check if a value exists and if so use that value, else use a default value: https://zapier.com/help/create/format/set-default-values-for-blank-fields-in-zaps
NOTE: Zaps with 3+ steps require a Zapier paid plan.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Expert
- 31147 replies
Hi
Good question.
You can set a static time value as part of the GCal field.
OR
You can use Formatter > Text > Default Value.
- Beginner
- 4 replies
My apologies, Troy - I’m very new. Is this set in Zapier or Monday. FYI - I’m currently using the free plan version of zapier.
+14- Zapier Expert
- 31147 replies
Please post screenshots with how your Zap steps are configured in order for us to have more context, thanks.
- Beginner
- 4 replies
Thanks, Troy - per my email above, we get a delivery date a few days after a record is created for the customer. Then, as the delivery date approaches, we get a time. Since I don’t have the time when the zap runs to create/update the entry in Google Calendar, the Zap errors out with a Status Code 400 Bad Request - it’d be ideal if we could get a default time set for when the value is null.
Monday
Zapier
+14- Zapier Expert
- 31147 replies
You can set a static time value after the date for these fields.
e.g. [Cab Delivery] 12am
- Beginner
- 4 replies
Setting the time to 12:00a does not allow the time to update when I set it to the actual delivery time in Monday - the time remains set to 12:00a.
+14- Zapier Expert
- 31147 replies
- Answer
Please clarify what Monday Zap trigger event you are using.
This help article provide info about how to use the Formatter > Text > Default Value step that can be used to check if a value exists and if so use that value, else use a default value: https://zapier.com/help/create/format/set-default-values-for-blank-fields-in-zaps
NOTE: Zaps with 3+ steps require a Zapier paid plan.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.