Good Afternoon,
I recently built "Catch All" database that captures all of our orders from several different locations. (In-house, web, subscription programs, etc) This filemaker database is talking to UPS worldship through ODBC and with a keyed import from Worldship. We pull the needed data and then ship the package.
One thing that UPS requires on packages is the attention field which I have mapped, but information is not always populated in that field.
For example:
(Filemaker Field - Worldship Field)
Full Name - Name or Company
Address Line 2 - Attention
We don't always have data landing in the address line 2 field so the shipping department is having to copy and paste the full name in to the packages that don't have data in the attention field.
To circumvent this, I was thinking about building either a script or a calculation (in the ODBC database) in the address line 2 field that basically says "If this field is blank on import, then copy contents from Full Name field and paste it" This way it removes one more step from the task of shipping a package.
Your thoughts on how to easily tackle this are appreciated.
Marc
