Forum Discussion

JackWoods's avatar
JackWoods
Qrew Trainee
8 months ago

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
    8 months 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

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
8 months 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.