Forum Discussion

EricTurrentine's avatar
EricTurrentine
Qrew Cadet
7 years ago

Email notification when spicific field changed missing user fields

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

App builders
Ask about Quickbase functionality
NotificationsEmail
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    7 years ago
    Make sure the [Assigned To] field is set to "Reportable"; otherwise fields will not show up in the Additional Criteria list.
  • EricTurrentine's avatar
    EricTurrentine
    Qrew Cadet
    7 years ago

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


    • LauraThacker's avatar
      LauraThacker
      Qrew Captain
      7 years ago
      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.
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    7 years ago
    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.
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      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.