@Trim

HCL Domino Domino Forum
1

Should the following code work when trying to put 2 fields together in 1 column for a view. Right now it just gets the names and not the email from the form

@Trim(Travel + ExP_Email:Producer + ExP_Email_1:Manager + ExP_Email_2:Director + ExP_Email_3 :Designer + ExP_Email_4:Assistant + ExP_Email_5:Vendor +ExP_Email_6:Contact + ExP_Email_7)

2

Subject: @Trim

@Trim((Travel + ExP_Email):(Producer + ExP_Email_1):(Manager + ExP_Email_2):(Director + ExP_Email_3):(Designer + ExP_Email_4):(Assistant + ExP_Email_5):(Vendor +ExP_Email_6:Contact + ExP_Email_7))

3

Subject: RE: @Trim

I now get a message saying

Collation number specified negative or greater than number of collations View

And it still only show the names

thank you

4

Subject: RE: @Trim

I think Betsy may have forgotten a pair of parenthses after ExP_Email6 and Contact…

@Trim((Travel + ExP_Email):(Producer + ExP_Email_1):(Manager + ExP_Email_2):(Director + ExP_Email_3):(Designer + ExP_Email_4):(Assistant + ExP_Email_5):(Vendor +ExP_Email_6:Contact + ExP_Email_7))

Try…

@Trim((Travel + ExP_Email) : (Producer + ExP_Email_1) : (Manager + ExP_Email_2) : (Director + ExP_Email_3) : (Designer + ExP_Email_4) : (Assistant + ExP_Email_5) : (Vendor +E xP_Email_6) : (Contact + ExP_Email_7))

5

Subject: RE: @Trim

Thanks for catching that, I was not sure if it was supposed to be that way or not.

But… now it only gives me the names and not the emails too…

any idea ?

Thank you again

6

Subject: RE: @Trim

It works now, thank you both so much.When I tried before I put a ; into the code where I was supposed to put a :

Thanks again for helping me