Help

Delete date field entries by Automations

Topic Labels: Automations
Solved
Jump to Solution
622 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Martin_Leber
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi. I need to have a calendar overview showing two fields - a delivery date field and a publishing date field. What i am trying to figure out is, how am i able to delete the delivery date field entry, so whenever the date is the exact date of delivery i am trying to delete the delivery date field entry, so in my calendar the delivery date is not shown anymore - but the publishing date is still visible.

Thanks in advance
Martin

1 Solution

Accepted Solutions
Vivid-Squid
11 - Venus
11 - Venus

Hi @Martin_Leber,
HMMM, that is unique.
Maybe create a formula that compares the dates and gives you a boolean result. Then use this result to update the delivery date to blank as needed.

IF({Delivery Date}={Publishing Date}, 'same', 'different')

image
image
image

See Solution in Thread

1 Reply 1
Vivid-Squid
11 - Venus
11 - Venus

Hi @Martin_Leber,
HMMM, that is unique.
Maybe create a formula that compares the dates and gives you a boolean result. Then use this result to update the delivery date to blank as needed.

IF({Delivery Date}={Publishing Date}, 'same', 'different')

image
image
image