Blank fields with replacement

[infoconceptlc]

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.

[ch1p · Accepted solution]

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.

[Melville-Schellmann]

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.

[infoconceptlc]

I know but i want to put it 

[infoconceptlc]

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

[Roy_Laudenslager]

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.

[infoconceptlc]

OK and now how can I add phone number ?

[Roy_Laudenslager]

Why bother. What purpose would it serve?

[infoconceptlc]

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

[gcavin]

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

[infoconceptlc]

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