Simple question - multiple lines in view

HCL Domino Domino Forum
1

Hello people, I’m coming back to Notes after a 12 month absence, and I’ve forgotten everything I knew!

I’m slowly learning again, but what I’m having trouble doing now is displaying an address, in multiple line format, in a column of a view. How can I specify where the line breaks are? I tried @NewLine, but it didn’t make a difference.

Thanks!

2

Subject: Simple question - multiple lines in view

hi, mark the column in designer and choose properties. In the ‘Info’-Tab you can choose ‘new line’ as option for ‘separate multiple values’.

Column-formula is for example:

@Trim(

       @If(CompanyName != "";CompanyName;""):

	 @If(OfficeStreetAddress!="";OfficeStreetAddress;""):

	 @If(OfficeZip!="";@If(OfficeCity!="";OfficeZip+" "+OfficeCity;OfficeZip);								

	 @If(OfficeCity!="";OfficeCity;"")):

	 @If(OfficeState!="";OfficeState;""):	

	 @If(OfficeCountry!="";OfficeCountry;"")

        )

Hope this will help

(sorry my English)

3

Subject: RE: Simple question - multiple lines in view

Excellent, that was exactly what I needed, thankyou very much!

And your english is perfect… :slight_smile:

4

Subject: But why bother with all those @Ifs???

@Trim( @If(CompanyName != “”;CompanyName;“”):

	 @If(OfficeStreetAddress!="";OfficeStreetAddress;""):

	 @If(OfficeZip!="";@If(OfficeCity!="";OfficeZip+" "+OfficeCity;OfficeZip);								

	 @If(OfficeCity!="";OfficeCity;"")):

	 @If(OfficeState!="";OfficeState;""):	

	 @If(OfficeCountry!="";OfficeCountry;"")

        )

i.e. if CompanyName is not “” then use CompanyName otherwise use “”? Why bother?

@Trim(CompanyName : OfficeStreetAddress : (OfficeCity + " " + OfficeState + " " + OfficeZip) : OfficeCountry)