How do I change which fields are displayed in an automatic email reminder?

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
My email reminders are showing every field in my application. I only want to show 12 fields. How do I make this change?
Photo of Jon Hanson

Jon Hanson

  • 70 Points

Posted 6 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
Settings for the table
Reports
top right set default report
and set your default fields.
Photo of Todd Horn

Todd Horn

  • 100 Points 100 badge 2x thumb
Is there a way to select a specific report to be sent in the reminder email instead of the default report?  
Photo of John Rogers

John Rogers

  • 400 Points 250 badge 2x thumb
Long shot, not sure if it will work.

Create a checkbox that is always checked
create a formula date field with this formula: IF([my checkbox field] = true, Now())
    -This will everyday return the current date

now instead of creating an email reminder, create an email notification
you can make it so that if date is equal to Sunday send notification, or whatever day you want

At the very bottom change to custom message and you can put any fields you wish into this automation.

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
You can use a Subscription Report to fire every day but the report being used would be set to have a filter which is true on the date you want it to fire. Subscriptions by their nature always allow you to specify the report being used.
Photo of Todd Horn

Todd Horn

  • 100 Points 100 badge 2x thumb
Thank you both for the recommendations.

The Reminders are nice due to needing to send an email 10 days after the date in three different date fields, but only limited info needs to be sent.  Easiest would be to have the option to select a specific report for reminders.

I'll see if I can make it work via Subscriptions or some other means.
Photo of Todd Horn

Todd Horn

  • 100 Points 100 badge 2x thumb
And... I got it to work with Subscriptions as described above.  Thanks!