Hello all,
In my survey I have the user choose an account ID (txt_Acct_ID) from a list which then auto-populates a number of answers from a csv file. In the case of a Mailing Address pre-populating a multi-line textbox, I am trying to concatenate a number of separate fields from the csv with newline calls injected. Example:
MailAddress1
MailAddress2
City, State Zipcode
Here is one thing I tried:
if(${int_ID_sel}>0,concat(pulldata('feed_mans','MailAddress1','AccountID',${txt_Acct_ID})+'\n'+pulldata('feed_mans','MailCity','AccountID',${txt_Acct_ID})),'')
The result is:
MailAddress1\nMailAddress2
So it appears not to recognize the newline call. I have a number of workarounds but would like this to work if possible. The use case is to pre-populate the field but allow the user to update it. And for this purpose, it actually makes the most sense to put the entire address in one field.
Thanks!
Jim