Automatic Email Notification (include Date Modified Field)

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Hello,

We have a few automatic notifications which go out when a record is added, modified, or deleted. The notifications Message Type is set at "Default".

For an email notification on a record modification, the standard verbiage we get is something like the below. It basically is an indication that a record was modified, and then includes the fields which were modified.

Question: Can I add the Date Modified field to the Message Type "Default" Email Notification? I would like to have the notification for these modifications to include the Date Modified field. Looking at the field properties, I don't see where I can add the Date Modified to a notification email.It appears that I could do a customized email, but based on an add-on we have we need to keep these notifications on Default.

Thank you.

---------

<user> changed the QuickBase application <application name>.


Call 189 was changed:
<Field Name 1>changed from Call 4_60478223 to Call 4_6047822
<Field Name 2> ... changed from no to yes
<Field Name 3>... changed from *empty* to 1.00 <Field Name 4>... changed from *empty* to 1.00
Click on the link below to see this call in QuickBase:
<link to form>

This is an automated notification from a QuickBase application.
If you feel that you should not be receiving these notifications
please contact the application's manager, <application manager>,
and ask to be removed from the notification list.
Photo of Ken

Ken

  • 50 Points

Posted 5 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
I doubt the us a way to change the default message, but in general, you can make your own custom message. For notifications, you can include  a phrase like

customer status was changed from [old.customer status] to [customer status]

Each field, and I assume but do not know for sure without testing including the date modified field, can have its previous value accessed by using the field name prefaced by "old."

But a problem that you will have in a custom notification is that you won't be able to just show what changed.  For fields which did not change, the old and current values will be the same.
Photo of Rick

Rick

  • 10 Points
Does this "old" prefix work for the Multiple Record Version?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
I don't think that it could, because with the multiple record change notifications you just get a list of the records which changed.
Photo of Rick

Rick

  • 10 Points
Yes, that's my current issue. The list is a link to a report in QuickBase. I'm needing a way to capture the previous field values.