Track Changes of a Date Field
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 tu...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
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.
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
------------------------------
I have a follow up question. Sometimes, I will batch edit several jobs at once, and when I do that it sends a summary email. Is there a way to make it send individual emails for each job that changed? Or would I have to update each job individually for that?
------------------------------
Allison Watson
------------------------------