Forum Discussion

MeaganMcOlin's avatar
MeaganMcOlin
Qrew Cadet
28 days ago
Solved

Dynamic Reminder: Recipients Based on Field Value

I’m setting up a 60-day reminder in Quickbase with additional conditions, but I need the email recipients to vary depending on the value in the “Short Title” field. For example: • If “Short Title” =...
Pipelines
  • MarkShnier__You's avatar
    MarkShnier__You
    28 days ago

    OK sure. Those Formula List User fields are tricky.

    The help text is here 

    https://login.quickbase.com/nav/app/9kaw8phg/table/6ewwzuuj/action/dr?rid=182&rl=fj

     

    So assuming that your existing users to be notified are in fact User fields then it would be

    Case("Short Title",

    "HYHOPE", ToUserList([user field A],[user field B], [user field C]),

    "RTOG 920",  ToUserList([user field A],[user field B], [user field C]),

    etc

    etc

    "xxxxx"  ToUserList([user field D],[user field E], [user field F]))

    But even if that works, it's actually a terrible solution because every time a short title changes you need to change the formula.

    Is there any possibility that the short title can come off a table lookup?. That would be ideal then you could choose the short title and the short titles Table would have a List User field, where you would maintain the users to be notified for each different Short Title. That way you don't need programming to make a change, somewhat just updates table values.

      

     

     

     

MeaganMcOlin's avatar
MeaganMcOlin
Qrew Cadet
28 days ago

Thanks, Mark! Would you be able to give me a sample formula to use? 

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
28 days ago

OK sure. Those Formula List User fields are tricky.

The help text is here 

https://login.quickbase.com/nav/app/9kaw8phg/table/6ewwzuuj/action/dr?rid=182&rl=fj

 

So assuming that your existing users to be notified are in fact User fields then it would be

Case("Short Title",

"HYHOPE", ToUserList([user field A],[user field B], [user field C]),

"RTOG 920",  ToUserList([user field A],[user field B], [user field C]),

etc

etc

"xxxxx"  ToUserList([user field D],[user field E], [user field F]))

But even if that works, it's actually a terrible solution because every time a short title changes you need to change the formula.

Is there any possibility that the short title can come off a table lookup?. That would be ideal then you could choose the short title and the short titles Table would have a List User field, where you would maintain the users to be notified for each different Short Title. That way you don't need programming to make a change, somewhat just updates table values.