Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Delete date field entries by Automations

Topic Labels: Automations
Solved
Jump to Solution
140 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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