2 Replies Latest reply on Jun 29, 2016 11:46 AM by Will Thomas

    Filtering based on length of a field?

    Will Thomas

      We're looking to implement better 'bad data' safeguards, one of which is for phone numbers.  One of the filters I would like to create would filter out anyone who enters a number that isn't long enough to be legitimate.  Is there currently a way to say if a number is less than say, 7 digits? 

        • Re: Filtering based on length of a field?
          Dory Viscogliosi

          You can use form masking to require an input to be a certain format, but unless you're only getting US inquiries, or you are prepared to format for every country, I'd advise against trying to do this on forms.

           

          You could export your data and run it through excel, to identify records where a phone number was too long or short. Not sure if there are any more elegant solutions without going to a third-party provider.