I am having an issue trying to combine fields into...
# general
p
I am having an issue trying to combine fields into 1 text area box if a certain option on a different field is selected. I am able to get 1 of the fields to show in the text area box but not all. The formula I am using is
{custbody_eym_company_name_fda} || {custbody_eym_address_1_fda}
. I also tried
{custbody_eym_company_name_fda}||{custbody_eym_address_1_fda}
and still only get the 1 line. I know there is data in the other field because if I put the 2nd field first - that one does show but the other does not.
a
try using concat({custbody_eym_company_name_fda},{custbody_eym_address_1_fda})?
might also need to use NVL function if that second field isn't always guaranteed to have a value
p
No go with using concat. Am at a loss as to why this does not work.
k
what are the field types of the two fields?
a
Is the second field you're referencing not "stored"?
p
@KevinJ of Kansas both fields are text fields that populate from a customer record. my workflow is in a sales order.
@AFL Yes, both fields are store. Should I have the action that combines the field in a different state / workflow?