Discussions

Expand all | Collapse all

Weekly emailed report when a field is added or modified

  • 1.  Weekly emailed report when a field is added or modified

    Posted 12 days ago
    I have a table that contains 1000s of contacts.  I am trying to create a weekly notification that is emailed to a user when a specific field (email address) is added or changed.  I can create a notification for each record, but would rather it only be emailed weekly for those that have been added or changed.  Any help is appreciated.

    Thank you.

    ------------------------------
    Angela Angela
    ------------------------------


  • 2.  RE: Weekly emailed report when a field is added or modified

    Posted 12 days ago
    If you just want to let users know about changes to any field, then you can make a report  of records where the Date Modified is during the previous week.

    But if you need trap changes to just one field then you need a process to record when that field changes.  To do that the best way would be to create a field to hold that date and then set up an Automation or a pipeline to write the current date into that field.  Make a field called [Today's Date] with a formula of Today() and Copy that value into the field.


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------