Forum Discussion

JackWoods's avatar
JackWoods
Qrew Trainee
22 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 for...
getting started on quickbase
  • ChayceDuncan's avatar
    ChayceDuncan
    22 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
22 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
    22 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.