Discussions

Expand all | Collapse all

Email notification when spicific field changed missing user fields

  • 1.  Email notification when spicific field changed missing user fields

    Posted 06-18-2018 14:04

    I have a tasks table that I want to send a notification when the assigned user is changed, to let them know that the user has a new task

    but the assigned to user field is not in the specific fields change option list



  • 2.  RE: Email notification when spicific field changed missing user fields

    Silver
    Contributor
    Posted 06-18-2018 14:25
    Make sure the [Assigned To] field is set to "Reportable"; otherwise fields will not show up in the Additional Criteria list.


  • 3.  RE: Email notification when spicific field changed missing user fields

    Posted 06-18-2018 14:52

    I checked the field properties and it is checked and locked I cant change the value




  • 4.  RE: Email notification when spicific field changed missing user fields

    Silver
    Contributor
    Posted 06-18-2018 15:05
    So, the [Assigned To] is a formula field?  Can you post the formula of the [Assigned To] field here?  Also - it looks like you might be using [Related Resource] fields to indicate an Assigned To from another table.  If this is true, your trigger would be when the [Related] reference field has changed, not the formula-output field.


  • 5.  RE: Email notification when spicific field changed missing user fields

    Silver
    Contributor
    Posted 06-18-2018 16:31
    So, the [Assigned To] is a formula field?  Can you post the formula of the [Assigned To] field here?  Also - it looks like you might be using [Related Resource] fields to indicate an Assigned To from another table.  If this is true, your trigger would be when the [Related] reference field has changed, not the formula-output field.


  • 6.  RE: Email notification when spicific field changed missing user fields

    Posted 06-18-2018 17:25
    Assigned to is a user field in the tasks table


  • 7.  RE: Email notification when spicific field changed missing user fields

    Posted 06-18-2018 17:38
    Is [Assigned To] a lookup field?


  • 8.  RE: Email notification when spicific field changed missing user fields

    Posted 06-18-2018 17:46
    No this is a member if the Tasks table


  • 9.  RE: Email notification when spicific field changed missing user fields

    Posted 06-18-2018 17:56
    A crazy thing to try (but I would do if this wuz me) would be to make a formula text field of

    UserToEmail ([Assigned to])

     and see if that field appears.


  • 10.  RE: Email notification when spicific field changed missing user fields

    Silver
    Contributor
    Posted 06-18-2018 18:48
    Sounds to me like a bug.  I had another field giving me odd behavior lately.  I had to rebuild the field.  Try building a new [Assigned To] user field and see if it shows up on your notification criteria.


  • 11.  RE: Email notification when spicific field changed missing user fields

    Posted 06-18-2018 18:48
    Crazy thing that worked =D


  • 12.  RE: Email notification when spicific field changed missing user fields

    Posted 06-18-2018 19:28
    :) so  sometimes with Quick Base there are weird bugs or just stuff that you cannot figure out and we find a work-a-round and just move on.  Chalk that one up to the world of the unexplained" and move on.