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
Right,
There are two solutions.
The first is to have a formula to calculate the key field and then a form rule to copy that to the real Key field.
The second is that in fact you can have a formula field be a Key field by typing in the API. I have found that works fine, except for importing such as imports off excel or table to table saved imports. it one of those undocumented things that i learned at an EMPOWER one year in a Q & A session.
There are two solutions.
The first is to have a formula to calculate the key field and then a form rule to copy that to the real Key field.
The second is that in fact you can have a formula field be a Key field by typing in the API. I have found that works fine, except for importing such as imports off excel or table to table saved imports. it one of those undocumented things that i learned at an EMPOWER one year in a Q & A session.