Discussions

 View Only
Expand all | Collapse all

Setting up a Reminder to trigger a certain number of days if the date field remains blank

  • 1.  Setting up a Reminder to trigger a certain number of days if the date field remains blank

    Posted 10-13-2021 14:27
    Hi all,
    I'm not seeing what I need in the reminder notification functionality so I'm hoping for some advice.  Here's the 411:

    We have a service request form that is submitted by a member of our company to our Talent Development team when that member needs our assistance with a project.

    When we review these requests as a team, we assign them to one of our team members [Assigned Employee].  

    We are also asking our [Assigned Employee] to document the date that we respond to the requestor [Response Date].

    But, as with new processes, our team members forget to document the date they responded, and so I want to trigger a reminder to them that when [Reponse Date] remains blank for X number of days, send a reminder email to [Assigned Employee].

    Reminders do not allow me to choose the [Assigned Employee] field, even though in a Notification, I am able to choose the field.  So I was looking into creating a notification but can't wrap my brain around how to qualify when the notification needs to be sent. 

    Thank you in advance for your collective minds! 


    ------------------------------
    Trace Symonds
    Instructional Systems Designer
    Presbyterian Healthcare Services
    Albuquerque, NM

    2021-2022 QuickBase Customer Council
    ------------------------------


  • 2.  RE: Setting up a Reminder to trigger a certain number of days if the date field remains blank

    Posted 10-14-2021 00:50
    Edited by Justin Torrence 10-14-2021 00:50

    @Trace Symonds

    As long as the [Assigned Employee] is a user field, you should be able to select it in a "Reminder" email.

    If [Assigned Employee] is an email field, the only "Permission Type" capable of sending to an email field is an "Open" one. Reminders don't have a "Permission Type" setting, so I don't think this is possible.

    If that is the case, a solution could be to create a table that holds a recipient (email field), subject (text field), and body (Rich Text Field) and then set up a pipeline that will create a new record based on the trigger you defined.

    You could then configure a "Open" notification to send to the email in [Recipient] whenever a record is created in that table.

    Basically, your own little notification engine built on Pipelines.



    ------------------------------
    Justin Torrence
    Quickbase Expert, Jaybird Technologies
    jtorrence@jaybirdtechnologies.com
    https://www.jaybirdtechnologies.com/#community-post
    ------------------------------