Subform docid

HCL Domino Domino Forum
1

I have a subform which has three independent fields in them. They keep a visual history of what happened to a document, formula language writes into the three of them at the same time when someone makes a change in status, etc. I’m trying to analyze how statuses of the documents are changing on our database, and I was hoping to use the values in the subform to do this. Unfortunately it appears that the three fields Name, Action and Timestamp have no correlation to one an other in the database.

For simplicities sake I’ll only show two columns.

For example the following shows on the subform:

Name Action

Gil Save

Dave Approve

When I pull the values in a view with “show multiple values as separate entries” turned on I get the following:

Name Action

Gil Save

Dave Approve

Gil Approve

Dave Save

Is there anyway to get Gil Correlated to Save and Dave correlated to Approve? Gil and Dave’s roles may change on the next document and dave might save while gil approves. There are also 5000 Gil and Daves :slight_smile:

Thanks,

Gil

2

Subject: don’t sort the action column.

3

Subject: Does that really work?

I was wondering if there was a way to output the position of the value in the multivalue field? I think it can be done through lotus script. I know that name and action are written to the database at the same time I should be able to say that the first two values in the name and action field go together, if only I knew they were the first two. Is there a @ formula that will show what number the value is in the multi-valued field?

Thanks!

4

Subject: Yes, it really works.

Read Multiple values in multiple rows in multiple columns for details.

@Member can return the position of something in a list, but it’s not useful for this because the view column formula is only evaluated once for each document – not a separate time for each row. So it has to return all the values, and you have to let the view indexer do the matching for you.