May 25, 2023 01:20 PM - edited May 25, 2023 01:21 PM
I am trying to follow ongoing contracts on a timeline view. However, the timeline will not display items that don't have a Start and End Date.
Following some other topics, most notably this one, I am trying to find a workaround where an automation automatically updates the End Date to match Today's date.
A Checkbox is ticked for all contracts flagged as "Ongoing". The "Find" step locates the ones where "Ongoing" is ticked, and the "Update Record" steps supposedly updates all End Dates with the "Today'scDate" field value.
However, as seen on the attached screenshot, I get an input error. I used the "Find & Update" method quite frequently and never got this result before. I usually use "When record matches conditions" trigger, maybe the error lies within the trigger ?
Also attached is the formula of my "Today's Date" field in case the error lies in the formatting, but I checked it so it matches Airtable's format (I am in Europe).
Thanks in advance !
May 26, 2023 03:54 AM
Could you try changing your formula to just be `TODAY()` and attempting the automation again?
May 26, 2023 04:12 PM - edited May 26, 2023 04:13 PM
I'm curious - why is it that you get to have a link to your website in your signature when others don't? I've been told by the moderators here that it is against "Community Guidelines".
May 29, 2023 12:53 AM
Thank you for your answer ! I just tried it, and got the same error unfortunately.