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 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?
  • RichardPfister's avatar
    RichardPfister
    Qrew Cadet
    8 years ago
    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'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.
    • RichardPfister's avatar
      RichardPfister
      Qrew Cadet
      8 years ago
      Thank you!  I have not learned about connected tables yet but it certainly seems like a better solution.  I'll tinker with this approach and post back.
    • RichardPfister's avatar
      RichardPfister
      Qrew Cadet
      8 years ago
      I'm trying to build the connected table to handle this problem and I don't see a way to filter the connected fields using a dynamic date.  I can set it for "Now" but that doesn't update as time progresses.  The date field in the connection filter does not allow any typing, just date selection.  I want to create a connection that connects records whose effective date is <= the current point in time (i.e. via formula), essentially connecting fields to the new table when they become effective.  Any ideas on how to make this happen?
    • 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.  
  • RichardPfister's avatar
    RichardPfister
    Qrew Cadet
    8 years ago
    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.
    • JacobJacob's avatar
      JacobJacob
      Qrew Cadet
      8 years ago
      Great!  Glad to hear my suggestion in working.  It seems simpler than four or five tables and Qunect.  The beauty of Quick Base is that there are many ways to solve for the same problem.  Glad you found a solution.