@Suren -

This one’s a bit of a sticky wicket. Normally, you’d use Schedule by Zapier to trigger on something time-based. That won’t work in this instance. Nor would an updated record in Salesforce, since the field would just exist, not be updated.

What would work is to use a two-step process, involving Airtable.

Trigger = New Event in Salesforce

Action = Create Record in Airtable

In Airtable, you can automate the record shooting to a new view when the date is today. Another zap would then be:

Trigger = New Record in View

Action = Create Record in Salesforce

That should work, depending on what you want the final action to be. It’s a relatively simple setup – holler if you want our team to take a crack at it.

Hi @Suren!

The suggestion above by @adamsmartschan is probably what I personally would do as well. It’s a workaround, but it’s one that will likely become handy in the future once you get used to the setup It can be applied to other use cases as well.

Hi @Suren! Did @adamsmartschan’s suggestion help you with this one? We’d love to know if you were able to find a way to build what you needed