Forum Discussion
JacobJacob
8 years agoQrew Cadet
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
8 years agoQrew Cadet
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.