This is too Easy... except for me

[HemiRon]

I love filemaker. Even though Im not that good at it. I really need a filemaker consultant to help. Anyway here's my issue

 

 

I want to create a packing list, one of the fields I want if not empty then put an asterisk then 'part number field' formatted in the barcode font followed by another asterisk.

 

Why am I having such an issue with this.

 

Thanks 

[jbante]

If ( not IsEmpty ( Table::partNumber ) ; "*" & Table::partNumber & "*" )

[comment]

If it's in a calculation field, then you can leave the (default) option of "Do not evaluate if all referenced field are empty" on, and shorten the formula to =

"*" & PartNumber & "*"

Formatting the field to display in a barcode font can be done at the layout level.

 

 

This really is too easy: if you're "having such an issue with this", you should elaborate what specific problems have you run into.

[LaRetta]

Isn't this for display only?  It would be good to drop the calculation completely if possible.  Just an idea ...

 

Create a merge field of the part number inserting * before and after part number.  Then set the merge block to hide if IsEmpty ( PartNumber ).  Or would this not work because of the barcode font?