Changing Field content in found set

[projay]

Whats the best way to change content of a field

in all records found?

Would you use find and replace... or

some other way?

Jay.

[Lee Smith]

Hi Jay,

The Replace, if it is a one time need.

However, if it is going to be a reoccuring need, then I would look at using the Auto Enter, or a possibly a script depending on your need and what is being replaced.

HTH

Lee

Edited November 3, 2010 by Guest

[projay]

Hi Lee thanks for the reply. This will be a

recurring need. So i would need a script...

any suggestions

Jay.

[Lee Smith]

Not without some details.

Is it always the same field, then what is the field name.

What are you replacing. i.e. from what to what.

How is the found set being found.

In other words, tell me what you have now, and what you want to end up with.

Lee

[projay]

It is always the same field name. Here is what I am trying to achieve:

I give my customers quotes and if that quote is

accepted than i want to change Order_Type to Invoice.

Field is: order_type

So what will do is find all quotes accepted and

change the found set to invoices.

Hope this helps, thanks again.

Jay.

[comment]

Sounds like you are doing the same work twice. If you are able to find the accepted quotes, you should also be able to calculate the type, based on the same criteria.

[projay]

Not quite following. Whats the best way to change order_type field in a found set...so that it changes from "quote" to "invoice".

Jay.

[comment]

How do you create the found set to begin with? IOW, how do you know which quotes were accepted?

[Lee Smith]

I asked that question too, but it wasn't answered.