I want to pull the Author field of a response document into a view column and still keep the response document hierarchy. I cannot find a way to do this, any help is greatly appreciated!
Subject: Reponse Document Fields
I’ve done it by using an @If(form = X; X) in the view column. Works just fine.
Subject: Reponse Document Fields
You have exactly one and only one column to display whatever you want from a response doc, if you want to use automatic hierarchical display. The one column that should have checked the “show responses only” property and should be placed right as the first column.
In case you enable the property for more columns, Notes will ignore it.
So, to display the Author field along with other information, you have to build the string you want to display in the column formula.
Subject: RE: Reponse Document Fields
I haven’t been able to get this to work while keeping the Response document hierarchy. Does anyone have any more suggestions?
Subject: RE: Reponse Document Fields
Sorry, but that’s all you have. You can either add columns to the left of your one responses column (and in the column formula you can determine what to display - if anything - based on the Form field). But this will probably make the view look ugly.
Or you can change the formula in your responses column to include some text like " - Author: " + AuthorFieldName. But this way, author names will not be lined up in one column. That’s the way response columns work.
Of course, you don’t have to use a view, that shows response documents in a hierarchy. If the level of responses is fixed, you could create a similar look and feel using regular categories.
Subject: RE: Reponse Document Fields
Any column to the left of the response hierarchy column will show as normal. So, if you can have the response hierarchy column later in the view column order, you could put your author information first before the response doc column. If you only want to the display author info for the response doc, use the formula suggested in a previous response. Otherwise, you will need to compute a string to put in the response doc column. Depending on the size and complexity of your app, it is often better to put a computed field on the document and just display that field.
Subject: RE: Reponse Document Fields
“Any column to the left of the response hierarchy column will show as normal.”
Right, but it will also somehow break the design of the hierarchical display.