About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Unable to "wipe" previous Notion DB item, date/time value. Cannot set Date/Time value to null/empty.

  • 16 March 2023
  • 2 replies
  • 125 views
FreezingPete
Userlevel 1

Notion DB Item has property “Closed At” with date/time value set from previous “Closed” Zap that detects change in State (Open/Closed).

Zap updates the Notion DB Item to reflect the same source state (Open/Closed), also populates an empty, Notion DB Item property ‘Closed At’ with the received date/time value.

When the Zap again detects state change in source object, it successfully changes the Notion DB item ‘State’ from Closed to Open, yet unable to clear/wipe the “Closed At” date/time value.

I have tried using other properties from Find Notion DB item: Properties Closed At End (value) which is null/empty, no change.

I have tried using a code step to set and pass null value, no change.

Wondering if anyone else has seen this behavior and know how to clear the date/time value from existing Notion DB Item? Thanks for any help! :)

 

icon

Best answer by FreezingPete 16 March 2023, 17:15

View original

2 replies

FreezingPete
Userlevel 1

Found solution in this article ( https://stackoverflow.com/questions/69369385/clearing-date-object-using-notion-api ) and then added additional Zap action “API Request (Beta) in Notion”.

 

 

SamB
Rank
Userlevel 7
Badge +11

Thanks so much for sharing the solution you found here, @FreezingPete! So glad you were able to make use of our (Beta) API request feature to clear the value from the Closed At property. 😁🎉 

Reply


Terms & Conditions