Forum Discussion

Qrew Captain

3 years ago

Text Multiline Cannot be used for notification triggers?

I have a proposal review system that is set to notify people when the status changes on the proposal to flag them it is ready for their review..... However, I want to also send an email if the comm...

Qrew Captain

It does not appear on the list of available fields in additional criteria

------------------------------
Ivan Weiss
------------------------------

Qrew Commander

3 years ago

It should appear. One thing I find is that if I have a lot of fields, I think they are in alphabetical (or some convenient order), but then I find my field randomly placed in a spot I wasn't looking. Carefully look at all the fields, particularly towards the end of the list or in a spot you wouldn't expect it. It should be there.

If not, then something else is going on, as my multi line fields do appear.

------------------------------
Mike Tamoush
------------------------------

IvanWeiss
Qrew Captain
3 years ago
I have checked this 3 or 4 times and it is not there. Does turning on logging prevent it from being usable for this function?

------------------------------
Ivan Weiss
------------------------------
- MikeTamoush
  Qrew Commander
  3 years ago
  Ahh. I think you solved it. I just looked, and the multi line fields I have logging on, also do NOT appear in the list. So yes, it appears turning on logging does in fact prevent it from being used.
  
  Maybe you can have a non logged field, with a dynamic form rule 'when record is saved, change Non logged field to value in logged field? And use that non logged field in the notification? It will recognize a change, but I dont think the non logged field will have all the text in it.
  
  ------------------------------
  Mike Tamoush
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    3 years ago
    Just make a mirror field with the formula equal to the logged field and then it will appear as a choice.
    
    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------