I’m trying to update a a hidden field in a parent form when the user selects “bid” or “no-bid” on a child form. the formula i’m using is “@setdocfield($Ref;“Status”;option);Option” It’s being run from the input translation property on the option field of the child form.
However, the field on the parent form does not update. i even tried doing the operation as a post save event, in the thinking that the $Ref field is not available until the document is saved.
Still nothing. Anyone could shed some light on this?
Subject: Using $Ref
You probably already did this, but is the hidden field on the parent form editable?
Subject: RE: Using $Ref
Yes it is.
I tried it as both a computed field and a plain old text fiedl.
Subject: Using $Ref
Larry, Is there a computed field which is setting the status on the parent doc? This has tripped me up more than once – a computed field or something in the QueryOpen that is resetting the field after the update. --Ron
Subject: RE: Using $Ref
No i’m not running any postopen operations.
Subject: RE: Using $Ref
You could try a few things to debug this situation.
-
Verify the user’s access rights. The person editing the child document would have to have edition access to the parent document.
-
Try updating a brand new field instead of the status field. If the field appears at all (check the properties in the backend), you know it works. If it is empty, you know something doesn’t save. At least that way it will insure no other process somewhere else is resetting the status field.
-
Run it from the querysave or the postsave, not from the translation formula. You probably don’t want to change a value in the parent when the user could still cancel his change and return to the view, and now you have the parent status wrong.
-
Verify that you do not have some hidden save or replication conflicts. Otherwise, you may update the wrong document (the conflict) rather than the main one
Worst case scenario, you could always re-code it in script…
HTH
Nicolas Abesdris
Quintessence e-solutions Inc.
Subject: Using $Ref
two things to check:1) Are you sure the $Ref is populated ont he child after saving?;
- Is there a default view in the app? Not that it’s applicable here, but I remember some issues in the past about docs not able to be found if there’s no default view set.
Subject: RE: Using $Ref
Yes Bill. once I save the response document and view the properties(in the default view), the $REF field is populated. I even tried running as a post save operation.
One more thing on the information tab of the document properties of the parent document it shows the parents time as lat being modified when I created the response document.
it is weird, I looked at the domino example and did it exactly like that, and nothing.
Very frustrating…