Forum Discussion

RichardPfister's avatar
RichardPfister
Qrew Cadet
8 years ago

Schedule a Webhook for a future date based on a field value

The basic webhook that I have used so far is: "After a record is added to Table A, create a record in Table B". What I want to do is very similar to this but on a delay.  I want to say: "After a ...
JacobJacob's avatar
JacobJacob
Qrew Cadet
8 years ago
How about just making table B a connected table and filter only the records where the effective date is on or after today.  You could then set it to refresh every hour.  Then only the records that have an effective date past today will pull into that table.  There are cons to using a connected table but this seems simpler than managing four tables.
JacobJacob's avatar
JacobJacob
Qrew Cadet
8 years ago
Sure thing.  Can you create a formula checkbox on table one that goes to true if the date field is after today "If([~date field] > Today(), true)" then fire off the the connected table based on that.