+8Greeting - 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")
Best answer by ChayceDuncan
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.
+9ToText([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.
+8Thank you! I figured it out a similar way by changing the formula to a checkbox instead of text. "If([Attachment]="",false,true)"
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
