Community
Showing results for 
Search instead for 
Do you mean 
Reply

Applying the same text to 43 records

Accepted Solution Solved
Tuned Listener
Posts: 14
Country: United Kingdom
Accepted Solution

Applying the same text to 43 records

I want to add the same website address to 43 records. Is there an easy way to do this?

Running Act! 11 and XP.

 

Thanks


Accepted Solutions
Solution
Accepted by topic author gary_russell
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Applying the same text to 43 records

Yes, just follow these steps:

- Do a Lookup of the records you want to add the website address to

- Go to Edit/Replace Field

- Choose the Website Address field (or whatever field you want the information to go into)

- Type in the website information in the Value field and click OK

 

This will put that data into the designated field for all the contacts in your current lookup.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

View solution in original post


All Replies
Solution
Accepted by topic author gary_russell
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Applying the same text to 43 records

Yes, just follow these steps:

- Do a Lookup of the records you want to add the website address to

- Go to Edit/Replace Field

- Choose the Website Address field (or whatever field you want the information to go into)

- Type in the website information in the Value field and click OK

 

This will put that data into the designated field for all the contacts in your current lookup.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Applying the same text to 43 records

Edit | Replace Field will replace the contents of the field for all contacts in the lookup.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Tuned Listener
Posts: 14
Country: United Kingdom

Re: Applying the same text to 43 records

Perfect.  Thanks.
Copper Contributor
Posts: 108
Country: Canada

Re: Applying the same text to 43 records

Is there a means of replacing a portion of the value.

 

I have 400 records with a selling error in a portion of the address field  -  XXXXXX Cresent should be - XXXX Crescent

Tom David Moxam
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Applying the same text to 43 records

No, you can only replace the entire contents of the field

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Copper Contributor
Posts: 108
Country: Canada

Re: Applying the same text to 43 records

            Smiley Sad


Thanks replying, any add-on's?

Tom David Moxam
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Applying the same text to 43 records

Take a look at Swiss Army Knife at www.designr1.com.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Applying the same text to 43 records

Looks like Roy's suggestion may do what you are trying to accomplish, although there does not seem to be much information on the product's functionality on the website.  I found this .pdf manual for Swiss Army Knife 2..hopefully it will help you make a decision

 

Swiss Army Knife 2 Technical Manual

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.