Skip to main content
Question

Reminder email -- How to change html vs. text OR how to change attached report

  • October 15, 2019
  • 0 replies
  • 34 views

Hi,

I have set up a Reminder email based on a date.  That is working.

When I receive the Reminder, it comes with a default table report of the record below the reminder text.

(1) I want to either remove or change the report picked

or

(2) force the reminder to be sent Text, which doesn't seem to default to the attachment (I see this when I "preview" the reminder).

It's simple to do these in the Notification emails, but the same edit options aren't available with Reminders (or at least I can't see them)

Thank you,



------------------------------
Rachel
------------------------------
This topic has been closed for replies.

  • Quickbase Alumni
  • October 15, 2019
Rachel,

For your 1st item:
You could try using a Subscription with a custom report. Let's say you want to be notified when a widget build request has not been completed after two days. In this example, there are 10 widgets and 3 users, Julia, Rachel, and Tom. Julia has 5 widgets remaining, Tom has 5 remaining, and Rachel's are all on time.

To do this, you could use a report that filters widgets by the date notification criteria and a Username field. Then set up a Subscription to send this report daily. If there is nothing in the report or nothing a user can see, the report won't send to that user. If it does, it will be filtered by what that user can see. As a bonus, the user will receive 1 email instead of multiple emails. Here's a quick example:

Custom Report:
Subscription:


In the example above, each morning, Julia would receive an email containing her 5 widgets, Tom his 5, and Rachel would not receive an email because there would be nothing in her report.

The negatives on this option are that the email will only fire once each day, and Tom, Julia, and Rachel all have to be QuickBase users with access to that app (i.e. more paid seats.)

I'm not sure on Item 2.


​

------------------------------
Evan Westbrook
PRIME Developer
Harder Mechanical Contractors Inc.
Portland OR
------------------------------

Forum|alt.badge.img+4
  • Quickbase Alumni
  • October 22, 2019
Hi Rachel - SmartEmailReminder for Quick Base can do what you want.  Have a look here: http://www.softtechexperts.com/smartemailreminder.html.  Contact me directly for more info.  Thanks.

------------------------------
Joe Acunzo
Quick Base Solution Provider
SoftTechExperts
joe.acunzo@SoftTechExperts.com
203-481-1222 ext. 316
------------------------------