Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

Testing if a rich text field is blank

I have a rich text field that passes a link to a file ("<a href='"& URLRoot()&"up/"&Dbid()&"/a/r"&[Record ID#] & "/e7/v0' target='_blank' >" & [File] & "</a>").

Is there a sneaky way to test if this field is blank (via dynamic form rules or a formula)? Right now, any typical ways of testing if blank, say no (presumably because its not blank, there is a formula....it's just that the result is blank)?

All I can think of is to test if the file field is blank at the origin, and then bring that check down and use it in formulas and dynamic rules. Is there a sneakier/simpler way?

------------------------------
Mike Tamoush
------------------------------
Formulas and functions
Tables and fields
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    What is in [File].  Is that perhaps the name of the file?  if so you can test is that is blank.

    But a better way would be to create the field at the source and have an IF to make it blank if the file is missing.  Then look up that link down to children and it will truly be blank if here is no file.  Then a form rule can hook on blank.

    Since you have to build that link anyway as you may as well always build the link on the Source table and then look up the link as opposed to constructing the link at the Target.  The other  advantage is that perhaps for some reason where you create the link at the source might be a parent to some other child tables so you might get lucky and be able to use the same source field in two different relationship look up fields.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------