Good Morning everyone!
Is any one know if it is impossible to populate data in an view from more than one fields in the form? Thanks for the helps!!!
Subject: column in the view
Hi, If you mean can a column show data from more than 1 field then yes. Just string them together … such as …
Field A + " … some text … " + Field B.
HTH.
Andy
Subject: RE: column in the view
Thank you Andy! I mean only show data from one of the fields. For example, I have three fields in the form named: a1, a2, a3. I want to show data from one of these field in a column, but I do not cancatenate them. Is it possible? Thanks again!
Subject: RE: column in the view
hmmmmm … OK … just select the relevant field as your column value… you must be new to Notes …!!! Cheers.
Subject: RE: column in the view
Andy, thanks for your reponse. Yes, I am new to Notes. I mean I have a1, a2 and a3 in the form and they contains the same info. For example, The form contains family member one’s address and family member two’s address. I need to populate the address info in a column. Is it possible? I appreciate your help!
Subject: RE: column in the view
You are still not making yourself clear. Do you mean a1, a2 and a3 are address line fields in one document and you want them to appear one below the other in a single column in the view? Like this:
a1
a2
a3
If so:
-
set your view properties to show multiple lines per row and check off “shrink rows to content”
-
on the column properties, set the multi-value separator to “New Line”
-
then set your column formula to a1 : a2 : a3
If that’s not what you want, please clearly explain what you want to do.
Hope that helps.
Subject: RE: column in the view
Wing, Sorry for delay. I had meeting. Yes, this is I want to do. I appreciate your help!