1 Reply Latest reply on Jan 11, 2010 1:48 PM by philmodjunk

    Unused portions in a calculation

    jconner99

      Title

      Unused portions in a calculation

      Your post

      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?

        • 1. Re: Unused portions in a calculation
          philmodjunk
            

          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.