Unused portions in a calculation
Is there a way to not have unused parts of a calculation appear.
I am creating a phone book. I have a table with fields for each element of a phone number (country code, area code, number, and extention). I have a calculation that put all the elements together. Before the field extention I have an "x" to indicated what the field is. If I create a record that doesn't have data in the extention field, the "x" still appears. Is there any way to prevent that?
country code & area code & number & If ( not isempty(extension) ; "x" & extension ; "" )
BTW, this is a post that would likely receive more responses if you had posted it to the Using Filemaker forum instead of the Filemaker Server thread. Let me know if you'd like to see it moved over there and I'll move it for you.