Forum Discussion

40458's avatar
40458
Qrew Member
3 years ago

Re: Connected Table Auto Refresh More Frequently

This is delayed from when you posted, but thank you, Razi!! This worked amazingly for me just now and your sharing it is much appreciated. 

11 Replies

  • AidonOlligschla's avatar
    AidonOlligschla
    Qrew Cadet

    Hello All,

    Here is the problem I'm trying to solve: we use a third party system and receive email notifications.  However, email traffic is already excessive.  The goal is to create a dummy gmail address into these notifications, connect the mailbox with Quickbase, and utilize QB's notification structure to send SMS Text Message alerts.  All working so far except for my hourly limitation of the connected table refresh.

    I believe I've set the Webhook up correctly, including user token and replication ID, but how do I know how often I can have the table automatically refresh?  It would be fantastic if it could refresh every minute or two, as the SMS messages could then be received within a 5 minute interval of actual occurrence.  Screenshot attached for reference.

    Thank you,



    ------------------------------
    Aidon Olligschlager |
    Flight Operations Technical Support
    Pentastar Aviation
    Waterford MI
    aolligschlager@pentastaraviation.com | 248-202-9587
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend

      If you look at the history of the refreshes, you can see how many minutes they take.  I think you can refresh as often as you like, as long as the table is not already refreshing when you call for the refresh.



      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------
      • ChayceDuncan's avatar
        ChayceDuncan
        Qrew Captain

        Are you trying to trigger the refresh based on each new email being received? This may work for a while but if you get too many emails too fast and you trigger too may refresh attempts QB might interpret it negatively and shut down the sync thinking its corrupted. Its not an ideal solution - but you could move the http request to a Pipeline and copy it something like (4) times and have it run 15 minutes. Or 6 times for every 10 minutes etc. You want to give it enough time per Marks comment but not too much that QB thinks something might be wrong with it if to your point there is a lot of email traffic. 



        ------------------------------
        Chayce Duncan
        ------------------------------