Email notification when spicific field changed missing user fields

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered

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

Photo of Eric Turrentine

Eric Turrentine

  • 490 Points 250 badge 2x thumb
  • lost

Posted 5 months ago

  • 0
  • 1
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 2,266 Points 2k badge 2x thumb
Make sure the [Assigned To] field is set to "Reportable"; otherwise fields will not show up in the Additional Criteria list.
Photo of Eric Turrentine

Eric Turrentine

  • 490 Points 250 badge 2x thumb

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


Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 2,140 Points 2k badge 2x thumb
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.
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 2,266 Points 2k badge 2x thumb
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.
Photo of Eric Turrentine

Eric Turrentine

  • 490 Points 250 badge 2x thumb
Assigned to is a user field in the tasks table
Photo of Eric Turrentine

Eric Turrentine

  • 490 Points 250 badge 2x thumb
No this is a member if the Tasks table
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 48,556 Points 20k badge 2x thumb
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.
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 2,162 Points 2k badge 2x thumb
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.
Photo of Eric Turrentine

Eric Turrentine

  • 490 Points 250 badge 2x thumb
Crazy thing that worked =D
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 48,556 Points 20k badge 2x thumb
:) 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.