Quick Base Discussions

Expand all | Collapse all

Can I send a Reminder Email to an Outside Vendor who's insurance is expiring?

  • 1.  Can I send a Reminder Email to an Outside Vendor who's insurance is expiring?

    Posted 07-31-2018 18:58
    I have over 1000 vendors  in Quick Base and I have to ensure their Worker's Comp and General Liability is not expired. I'd like to have Quick Base automatically send them an email based off of the date field field [Insurance Expiration Date].  I'm not able to do that as a reminder email because the vendors are not Quick Base users.  Is there another way to accomplish this?  

    Thanks!


  • 2.  RE: Can I send a Reminder Email to an Outside Vendor who's insurance is expiring?

    Posted 07-31-2018 23:42
    You are correct in your assessment that you'll need to send a notification and not a reminder in order to send it as an 'Open' email.

    Notifications are triggered when a record is added, modified, or deleted.

    In your case, you'll need to set up a trigger when the record is modified. This is only achieved when the record is actually edited and not simply updated as part of a formula.

    Automations allow you to modify records automatically (ie without manually changing the record or pressing an API type button). Since you have over 1000 vendors automation is the way to go.

    My recommendation would be:
    1. Create a new formula checkbox to 'check' when Today()= the date you want the notification to send.
    2. Create a text field where you'll indicate that the notification was 'sent'
    3. Set up an automation (located in the settings for your app) on every day to trigger when the checkbox you created is checked
    4. Then modify the new text field with value 'sent'
    This should initiate the notification to send once per day to all of the vendors who should get it. I have not tested it.


  • 3.  RE: Can I send a Reminder Email to an Outside Vendor who's insurance is expiring?

    Posted 08-01-2018 03:19
    I was wondering this myself if Automations could be used to trigger mass external emails.  I did a test and it seemed to work for me.


  • 4.  RE: Can I send a Reminder Email to an Outside Vendor who's insurance is expiring?

    Posted 08-01-2018 15:38
    Awesome!


  • 5.  RE: Can I send a Reminder Email to an Outside Vendor who's insurance is expiring?

    Posted 12-13-2018 12:56
    Actually, in a subsequent release, they changed these large updates to be done as a mass update so that method of triggering individual emails will no longer work.


  • 6.  RE: Can I send a Reminder Email to an Outside Vendor who's insurance is expiring?



  • 7.  RE: Can I send a Reminder Email to an Outside Vendor who's insurance is expiring?

    Posted 12-13-2018 16:36
    Is there a workaround for the change?


  • 8.  RE: Can I send a Reminder Email to an Outside Vendor who's insurance is expiring?

    Posted 12-13-2018 16:56
    I have a script that has the ability to walk down a report qid# and flip a toggle field to trigger emails.  It runs at the rate of about 3 per second which is slow enough to be considered individual updates.

    Contact me at QuickBaseCoach.com for one on one assistance.


  • 9.  RE: Can I send a Reminder Email to an Outside Vendor who's insurance is expiring?

    Top
    Contributor
    Posted 12-13-2018 17:10
    Yet another solution is to use script. You create an extra field called [Dirty] and through script update it with either a random number of the current time. This is called "dirtying the record." It is easy to implement. The [Dirty] field does not carry any supplemental information and is only a mechanism to get the record to change and trigger notification.

    I would argue that any script technique is superior to all other methods mentioned here not because of its individual performance but because it will open up your world to what can be accomplish with script. All the other solutions require you to do one-off setups and don't substantially expand your capabilities or portfolio of skills. I say script  everything!


  • 10.  RE: Can I send a Reminder Email to an Outside Vendor who's insurance is expiring?

    Posted 02-08-2019 20:53
    We are attempting to accomplish something similar. Is script still the only way to accomplish this?



  • 11.  RE: Can I send a Reminder Email to an Outside Vendor who's insurance is expiring?

    Posted 02-08-2019 21:03
    Yes. Contact me at QuickBaseCoach.com if you would like assistance