Hello,
My problem is that I want to get a view from a form that has 8 rows in it. All rows have a place for an email address, but they can be emtpy. The rows are for different levels of employes. Is there a way to show all the email in the same column on the view ? Not really sure if it can be done, but I trying to something like below
this is the code I am trying to use
Email = (ExP_Email!=“”) & (ExP_Email_1!=“”) & (ExP_Email_2=!“”) & (ExP_Email_3=“”) &(ExP_Email_4=!“”) & (ExP_Email_5!=“”) & (ExP_Email_6=!“”) & (ExP_Email_7=!“”)
Thanks in advance for any help
David
Subject: view column
Why not just display them all trimmed, as an array. Then you can set the view height to 9 and tick the shrink rows to fit (or just separate them with a comma).
Your column formula can just be:
@trim(ExP_Email:ExP_Email_1: etc.
Subject: Not sure
Being new at this I guess I not quite sure where to do what you are suggesting.Would this be on the form or in the view ?
Thanks
Subject: view
On the view, sorry for my brief post.
The view column formula needs to be what I suggested before.
Essentially this combines all the values of the fields on the document to a single array. The trim then removes the empty ones completely so you’re left with just the emails that are filled in.
What I was suggesting for the display options of the column (in the properties box), is that you can set the multi-value separator to new line or comma, whatever you like. So the view column either looks like a string of emails or a list.
If you do set the multi-value separator to new line each row of the view potentially has a list of emails, and you’ll need to change the view properties.
On the 3rd tab of the view properties change the Rows height to 8 lines, then check the ‘shrink rows to content’ option
Subject: That works !
Thanks that works and it makes sense at the same time
Thank you so much !!!