Forum Discussion

GiuseppeMacri's avatar
GiuseppeMacri
Qrew Captain
6 years ago

Testing If FIle Attachment is Attached

Hey,

Running into a weird issue where i cant get If(ToText([File Attachment])<>"",T,F) to work properly. File attachments no longer spit out data if you run them through a ToText calculation. 

Anyone got any ideas on how to "test" if a file attachment is attached to a field?

Thanks

------------------------------
GMacri
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    Works for me like always, I just tested. What is your actual formula?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • GiuseppeMacri's avatar
      GiuseppeMacri
      Qrew Captain
      6 years ago
      If(ToText([File Attachment #1])<>"",1,0). all i get is 0​

      ------------------------------
      GMacri
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        your formula worked just fine for me

         as this this shorter version

        ToText([file attachment])<>""

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