Discussions

Expand all | Collapse all

Testing If FIle Attachment is Attached

  • 1.  Testing If FIle Attachment is Attached

    Posted 01-29-2020 16:20
    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
    ------------------------------


  • 2.  RE: Testing If FIle Attachment is Attached

    Posted 01-29-2020 16:27
    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
    ------------------------------



  • 3.  RE: Testing If FIle Attachment is Attached

    Posted 01-29-2020 16:34
    If(ToText([File Attachment #1])<>"",1,0). all i get is 0​

    ------------------------------
    GMacri
    ------------------------------



  • 4.  RE: Testing If FIle Attachment is Attached

    Posted 01-29-2020 16:48
    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
    ------------------------------