Skip to main content
Question

Track Changes of a Date Field

  • Jan 12, 2024 4:23 PM UTC
  • 0 replies
  • 225 views

Forum|alt.badge.img+4

I have an email notification set up to let the Sales Rep of a job know when a due date changes.  Is there a way for the email to display the original due date and also what the new due date is?  I turned on the tracking function for this field, but it seems like only I can see that info as the realm admin?  Is there a way to share the info so it displays in the email to the Sales Rep?

thanks!



------------------------------
Allison Watson
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

np,

in the email just use the syntax 

[old.date] to refer to the previous value at the split second before the save.  Quickbase will remember that value just long enough to send off the email.

https://helpv2.quickbase.com/hc/en-us/articles/4570355754004-Creating-custom-content-for-email-notifications

You can also use field references to capture the original value from a field (before it was changed) and display it in an email.

To do so, type old. in front of the field name, as in [old.status] or [old.description] for example. For example, say you've inserted the following custom text in your notification:

The city changed from [old.city] to [city].

If a user were to change the value in the city field from Boston to Paris, this line would display in an email as:

The city changed from Boston to Paris.



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------