Forum Discussion

JackWoods's avatar
JackWoods
Qrew Trainee
20 days ago
Solved

IF Statement based on a file being attached

Greeting - I want to do an IF Statement to tell me if a file has been attached to the record or not. it does not seem to be working when i say Attachment=True. 

how could should I format my text formula field to tell me an attachment is present?

If([Attachment]="true","Yes","No")

getting started on quickbase
  • ChayceDuncan's avatar
    ChayceDuncan
    20 days ago

    ToText([Attachment])!="" will check if the file is present or not. 

    The only catch is that it will not be picked up until after the record is saved since the file is actually committed to the DB until that. 

3 Replies

Sort By
  • ChayceDuncan's avatar
    ChayceDuncan
    Qrew Captain
    20 days ago

    ToText([Attachment])!="" will check if the file is present or not. 

    The only catch is that it will not be picked up until after the record is saved since the file is actually committed to the DB until that. 

  • JackWoods's avatar
    JackWoods
    Qrew Trainee
    20 days ago

    Thank you! I figured it out a similar way by changing the formula to a checkbox instead of text. "If([Attachment]="",false,true)"

    • MikeTamoush's avatar
      MikeTamoush
      Qrew Commander
      20 days ago

      Similarly, this will also work (assuming a formula checkbox):

      [Attachment]>""

      You dont even need the if statement, as long as your formula is satisfying the true condition.