Skip to main content
Question

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

  • May 31, 2017
  • 0 replies
  • 67 views
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 record is added to Table A, create a record in Table B _on <effective date_>."

Effective date is a field in Table A and I want the Webhook to be triggered by the record add, but not make any changes to Table B before that effective date.

I didn't see any built in options for this and couldn't find anything related in the community.  Any ideas?
      This topic has been closed for replies.

      Does anybody have any suggestions here?  I have a really hacky workaround in mind but would love to hear from others if they have anything slicker.

      Current plan:
      • Webhook1: after a record is added to Table A, if the effective date is <= today(), create a record in Table B (final destination).
      • Webhook2: after a record is added to Table A, if the effective date is > today(), create a record in Table C (interim table).
      • Schedule QuNect to transfer data from Table C to Table D daily at 5am, triggering subsequent Webhooks.
      • Webhook3: after a record is added to Table D (by QuNect), if the date is = today, create a record in Table B
      Step 3 just seems really awkward, stepping out of the QuickBase software just to schedule an action.
      • JacobJacob
      • Registered
      • June 8, 2017
      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.
      Jacob - Thank you very much for your ideas and help on this challenge.  I have a working solution using the connected tables that you suggested.  The checkbox updates itself, the connected table is refreshed hourly and I am using webhooks to add, delete and edit records on the master roster.
      Terms & ConditionsAccessibility statement