Community
Showing results for 
Search instead for 
Do you mean 
Reply

Blank fields with replacement

Accepted Solution Solved
Copper Contributor
Posts: 49
Country: Canada
Accepted Solution

Blank fields with replacement

I have a lot of customer that don't have a phone number in my database, I would like to know if it's possible to select those customer that have no phone and to put for all of those customer a phone number for example 000-000-0000 like that I will have a field that I can search in the future.


Accepted Solutions
Solution
Accepted by topic author infoconceptlc
‎03-05-2019 12:40 AM
Silver Contributor
Posts: 1,808
Country: United_Kingdom

Re: Blank fields with replacement

[ Edited ]

ACT is designed so that edit replace will always look at the list view so it is up to the user to do a lookup first so that the correct records are in that list.

View solution in original post


All Replies
Nickel Super Contributor
Posts: 446
Country: Germany

Re: Blank fields with replacement

IMO you don't have to fill the field with dummy data.

You can do a field lookup with the parameter "does not contain data". It will return all contacts w/o a phone no.

Andreas Schlesselmann
Melville-Schellmann GbR
Germany
www.melville-schellmann.de
Copper Contributor
Posts: 49
Country: Canada

Re: Blank fields with replacement

I know but i want to put it 

Highlighted
Copper Contributor
Posts: 49
Country: Canada

Re: Blank fields with replacement

tell me how to do a lookup field contain no data phone

Platinum Elite Contributor
Posts: 6,864
Country: USA

Re: Blank fields with replacement

Point the cursor to the phone field and click the right mouse button and choose Lookup Phone field in the context menu. In the lookup dialog, Operator field choose Does Not Contain Data.
Roy Laudenslager
Retired ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 49
Country: Canada

Re: Blank fields with replacement

OK and now how can I add phone number ?

Platinum Elite Contributor
Posts: 6,864
Country: USA

Re: Blank fields with replacement

Why bother. What purpose would it serve?
Roy Laudenslager
Retired ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 49
Country: Canada

Re: Blank fields with replacement

[ Edited ]

It's not only for this case particulary put also how to do the changes in several customer if I need to change several phone number for customers

Nickel Contributor
Posts: 274
Country: Canada

Re: Blank fields with replacement

Edit > Replace Field. Select the Phone Field and type 000-000-0000.

Gilles Cavin
http://www.exponenciel.com
Make sure you check our free Act! add-ons!
Create Web forms in seconds and import form results directly into Act! with Automatic Web Forms
check our latest add-on: Better Last Activity Date Tracking
Copper Contributor
Posts: 49
Country: Canada

Re: Blank fields with replacement

But this will change ALL phone field by the value I will put LOL