I have a view where I want a Response to Response doc to display under my Response doc. The response to response doc does show up in the view but I can’t get it to display the Estimate # & Name in the view. I have a column created to the left side in view but the response to response doc is there but no text.
My column formula: @If(Form = “Change Order”; “(Change Order) Estimate #:” + CO_Est_No + " / Name → " + CO_Bill_To; “”)
Subject: RE: Response to Response doc
What happens if you take out the @If? I suspect the value of the Form item is not actually “Change Order”. Probably the form has an alias, and that’s the value you should be looking for.
Subject: RE: Response to Response doc
I tried them both and the doc shows up in the view but no values.
Subject: RE: Response to Response doc
I’m assuming here that you read the document in Designer help about how to create a response column. I don’t know why you’re saying the column is “to the left side”. Is it a responses column? Is there only one responses column?
When you say “there is no text” do you mean that the column is completely blank, or that it contains the value "(Change Order) Estimate #: / Name → "?
I also don’t understand what you mean by “I tried them both”. You tried both of what?
What happens if you take out the @If?
Let me be clear; when I say “what happens,” it is not enough to say “it didn’t work.” Remember I can’t see your screen. I’m looking for an exact description of what you do and what you see.
Use the Document Properties dialog from a view to look at the document. Examine the value of the Form field and other fields, and think about what the value of the formula would be.
If the above does not solve your problem, we need more information about what you’re doing. If you’re not sure what information to supply, the C R I S P Y document might help you.
Useful blog: Best Practice Makes Perfect