I have two reference fields on a form, a column called Workflow (referencing the wf_workflow table) and another column called Workflow Stage (referencing wf_stage table). I want the choices in the Workflow Stage lookup to be dependent on what's chosen for Workflow. Based on what i've read from other community posts, it sounds like I would have to write an advanced reference qualifier for the Workflow Stage field, but I can't seem to get it right.
My form looks like this:
The lookup for the Workflow table only has the Names of the workflows. The lookup for the Workflow Stage contains all the stages for every workflow version (which is not quite the same as just workflow). I am able to dotwalk to Workflow field through Workflow Version. My current advanced reference qualifier looks like this: javascript:"workflow_stage.workflow_version.workflow=" + current.workflow.name; but that does absolutely nothing.
What am I missing to get this ref qual to work?
