Check for a value on a specific date

Hello!

I'm trying to build a listing function in my app where by a behaviour runs only on a specific date and adds a yes or no based on a particular column. 

Use case:
A customer says they're going to order a product during my visit today. I know their order day is later this week. I want to declare a date to check whether it's listed.

My data feed refreshes daily and I don't want to warehouse the historical data. I thought if I could trigger a function on a user declared day in the future to look for the listing and only run once, it would give me the details I need.

Thoughts?

Solved Solved
0 4 287
1 ACCEPTED SOLUTION

You store dates on a table, run a bot everyday which checks the dates on the table, if there is a date which corresponds with TODAY(), run whatever action required and delete the date from the table.

... is the general idea.

View solution in original post

4 REPLIES 4
Top Labels in this Space