Discussions

 View Only
  • 1.  Trying to show the field that changed in a notification

    Posted 09-20-2019 11:13
    I have set up notifications (single record) to send when one of the field data changes.  How do I show which field changed?  Also, [Last modified by] is not showing in the email.  This is my message:


    [JOB NUMBER] - [Project Name]
    PROJECTED START DATE - [Projected Start Date]
    LH VERIFIED - [LH Verified]

    ***START NOTE - [START NOTE]
    *****PAYROLL NOTE - [PAYROLL NOTE]

    BOARD COUNT PER WO - [BOARD COUNT PER WO]
    ONE COLOR - [(1) Color]
    TWO COLOR - [(2) Color]

    WALL COLOR - [Wall Color]
    CEILING COLOR - [Ceiling Color]

    FRONT DOOR COLOR - [FRONT DOOR COLOR.]
    EXT TRIM COLOR - [EXT TRIM COLOR.]
    EXT SIDING COLOR - [EXT SIDING COLOR.]
    EXT SHAKE/BOARD & BATTEN COLOR - [EXT SHAKE/BOARD & BATTEN COLOR.]
    EXT SHUTTER COLOR - [EXT SHUTTER COLOR.]
    MISC COLORS - [MISC COLORS-BE SPECIFIC]

    [Last Modified By]

    ------------------------------
    Lynne8817 Lynne8817
    ------------------------------


  • 2.  RE: Trying to show the field that changed in a notification

    Posted 09-20-2019 13:20
    Which one of the fields change trigger this notification?

    Maybe, you can have that field listed as the first or last field in your notification with the default text next to it (as a prefix or suffix) saying the field changed is: ...

    Hope that helps!

    ------------------------------
    Kingsly Samuel
    ------------------------------



  • 3.  RE: Trying to show the field that changed in a notification

    Posted 09-20-2019 13:37
    Any one of the fields can change.  thx
    Last Modified show now...thx

    ------------------------------
    Lynne8817 Lynne8817
    ------------------------------



  • 4.  RE: Trying to show the field that changed in a notification

    Posted 09-20-2019 13:28
    Edited by Kingsly Samuel 09-20-2019 13:28
    And, your [Last Modified By] should work. Wonder why? Check the field properties to make sure there are no restrictions.

    ------------------------------
    Kingsly Samuel
    ------------------------------



  • 5.  RE: Trying to show the field that changed in a notification

    Posted 09-20-2019 13:42
    If you include a copy of the form the field(s) which changed will be highlighted in red,.

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



  • 6.  RE: Trying to show the field that changed in a notification

    Posted 09-21-2019 10:22
    Thx Mark.  The form has alot of data in it.  I guess I could create a new form with only this info, tho.

    ------------------------------
    Lynne8817 Lynne8817
    ------------------------------



  • 7.  RE: Trying to show the field that changed in a notification

    Posted 09-21-2019 11:02
    Never mind all is good

    ------------------------------
    Lynne8817 Lynne8817
    ------------------------------



  • 8.  RE: Trying to show the field that changed in a notification

    Posted 09-21-2019 10:55
    I have created a new form to be used for this notification. It is not the default form for the table, however.  So, when the notification is received...and I click "here", the main form opens...not the new form?

    ------------------------------
    Lynne8817 Lynne8817
    ------------------------------