Community
Showing results for 
Search instead for 
Do you mean 
Reply

Edit Records Without Changing Lookup

Accepted Solution Solved
Copper Contributor
Posts: 126
Country: USA
Accepted Solution

Edit Records Without Changing Lookup

I'm sure there's an easy way to do this, but I can't see it...

 

I did a Lookup on Records that: 

1.  Included the word "SOLD" in Field 1

2.  Field 2 Did Not Contain Data

3.  Were Edited in the last year

 

I see the records.  I want to put the word SOLD in Field 2, but when I do that it changes the Lookup and I would have to do the search all over again!  How can I accomplish this easily? 


Accepted Solutions
Solution
Accepted by topic author Jillian Trish
‎09-25-2015 03:20 AM
Bronze Super Contributor
Posts: 1,170
Country: USA

Re: Edit Records Without Changing Lookup

Jillian -

 

Here's what I think would work for you.

 

Run the queries as you mention so that you end up with the resulting contacts.

 

Instead of then updating just one record, you could post your value to Field2 by using the Replace Date tool from the edit menu.

 

This will place what ever value you enter into the selected field of the entire lookup.

 

Hope that helps!

View solution in original post


All Replies
Solution
Accepted by topic author Jillian Trish
‎09-25-2015 03:20 AM
Bronze Super Contributor
Posts: 1,170
Country: USA

Re: Edit Records Without Changing Lookup

Jillian -

 

Here's what I think would work for you.

 

Run the queries as you mention so that you end up with the resulting contacts.

 

Instead of then updating just one record, you could post your value to Field2 by using the Replace Date tool from the edit menu.

 

This will place what ever value you enter into the selected field of the entire lookup.

 

Hope that helps!

Copper Contributor
Posts: 126
Country: USA

Re: Edit Records Without Changing Lookup

I knew there had to be an easier way!  Thank you, thank you!