Importing Values to a Numeric Formula Field
Any advise on how to import values from a csv file into a field with a formula or lookup? Any ideas on design change to make this work?
Forum Discussion
If you have a table of duty rates in a table called HTS, you would change the Key field of that table to be the HTS #. But in fact if you are importing from more than one country you would need to create a Key field which is a concatenation of the HTS and the country.
such as
0901.21.0050-Canada
The HTS table has the duty rate.
The on your styles table you would create that same formula to result like
0901.21.0050-Canada
using a formula text field
Then make a relationship based on that concatenated field and lookup your duty rate.
such as
0901.21.0050-Canada
The HTS table has the duty rate.
The on your styles table you would create that same formula to result like
0901.21.0050-Canada
using a formula text field
Then make a relationship based on that concatenated field and lookup your duty rate.