I’m trying to see if a response document exists by trying use it’s form name, but I can’t get a handle on it.
The response document is viewable, once a categories are exapanded in the view…
what I"m trying to do is:
x := @if(@isResponseDoc & Form=“SRF”; “-!”; “”)
company + x;
But I can’t get a handle of the Form name…
Can anyone help?
Thx!
Subject: If you put in a formula of just “Form”
What value do you see?
Subject: huh?
I get the form name of the parent document only…
company + " " + form
which equals to :
somecorpName actionForm
Subject: I don’t believe your response form has the form name you believe it has
So by putting Form in the column formula for your response docs you can see what it actually is. Is your view set to show response hierarchy? Or no response hierachy? If set to response hierarchy, then response doc will only show in the correctly configured view column
Subject: It is correct
I can get the list of all response docs to show up in a column… but I cannot use the information it’s reporting. I need the field value.
two simplify:
2 columns
1… catagorized… Parent Doc (form = “SAP”)
2… Response Doc…many…
forms = "Action", "SRF", "Email"
I’m trying to append the column 1 parent document’s company name field with a * but only if the response form “SRF” doesn’t exist as a child of the parent in column 1.
Subject: If you are trying to use the value of a response doc in the parent docs column formula you can’t.
You will need to have something update the parent doc, to indicate there is a child doc with the value you want.
Subject: Thanks
Thanks to your suggestion, i was able to do the work around of updating a parent field when a child doc is updated…
Using:
@SetDocField ( $Ref; ParentField; “SomeValue”)
Thanks!