Jump to content

Replace data from field w/ data from another field


This topic is 7798 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a number of fields that relate to the postal address of a company. But sometimes our contact at that company has a different address. So to the right I have identical fields, with slightly different field names. I occasionally use these alternate address fields, making the company address, which would be to the left, irrelevent to that contact. When I export the addresses, I would like the unique contact address, if there is one, to replace that company address in that individual record. How do I do this?

In other words, "If the alternate address fields (on the right) have content, then use that content and not the regular address content (on the left)."

Harry

Link to comment
Share on other sites

Most of the databases I have seen have Bill to and Ship to addresses.

After the bill to, there is often a button for "Same", which runs a script:

set field, shipAddress, billAddress

set field, shipCity, billCity

set field, shipPostal, billPostal

set field, shipProvince, billProvince

...etc.

Link to comment
Share on other sites

Define another field as a calculation.

Like your last sentence, the calculation is:

if(name1="",name,name1)

where name is the original field, and name1 the 'identical' field.

Create this calc for each field in the address, then export the new calc fields

Link to comment
Share on other sites

This topic is 7798 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.