Getting a view to work from a Form problem using @trim

HCL Domino Domino Forum
1

Thought I had the problem solved, but… being new at this Hopefully I can expalin what I trying to do

I have a form that has 8 rows on it. The fields in the rows are for different level of contacts, some rows have information some do not. What I trying to do is pull the information from the form into a view that has information. I need the name and email from each row.

I used this code below in the view but it only gets the first email row, and leaves the rest. And then goes on to the next form and does the same.

I was using it to pull the email and the names from the from

The first line of code will pull all the names out but the next line only gets the 1st email

@Trim(Travel:Producer:Manager:Director:Designer:Assistant:Vendor:Contact)

@Trim(ExP_Email:ExP_Email_1:ExP_Email_2:ExP_Email_3:ExP_Email_4:ExP_Email_5:ExP_Email_6:ExP_Email_7)

Any ideas ?

Thank you for all your help and suggestions in advance

2

Subject: Getting a view to work from a Form problem using @trim

A few things to check

(1) Look at the document properties and confirm there is more than one value in your ExP_Email(s)

(2) On the view properties - confirm the row height is greater than 1. Clearly if it’s set to 1 you will only see the first entry.

(3) Is the column properties set to show multiple values as seperate entries? If it is, then clearly you will only see one name on a line.

3

Subject: RE: Getting a view to work from a Form problem using @trim

  1. Not sure about more then one value in ExP_Email(s). The form is used by several users and store in the database. And now I trying to extrat the inoframtion so when the information is entered it would only be allowed one entery at a time.

  2. Have already done the adjustments in the view properties it is set to 8

3 )The box to show multiple values as seperate entries is not checked

thank you