Using 6.6.2, I have a form that receives a token via a link from another form. The initial form has a grand total field called Total. When the user clicks on that value, I want the resulting form to translate Total to * so that it can be used in a search. Here's one of the many ways I have tried to accomplish this:
<init>
<eval token="form.Region">replace($form.Region$,"Total","*")</eval>
</init>
No matter how I format the eval statement (like, match, etc), it doesn't execute. I have even tried placing the eval statement in the initial form after the drilldown and before the link, and I still can't modify the token value.
This is much trickier than I thought.
Apparently it is not working to use form tokens in the init section.
I got it working by putting the eval token section in the search of the drilldown dashboard:
<panel>
<table>
<title>...</title>
<search>
<query>...$form.Region$...</query>
<progress>
<eval token="form.Region">replace($form.Region$,"Total","*")</eval>
</progress>
</search>
Alternatively, which might be the better solution: Use a done section in the initial search to set a token which you use to populate the drilldown:
<panel>
<table>
<search>
<query>...</query>
<done>
<eval token="Region">replace($click.value$,"Total","*")</eval>
</done>
</search>
<option name="count">10</option>
<drilldown>
<link target="_blank">...form.Region=$Region$</link>
</drilldown>
Hi! Could you post the initial form?
This is the drill down section from the initial form:
<drilldown>
<link target="_blank">/app/coo/by_bu?form.Region=$click.value$&form.BU=$bu_dropdown$&form.VM_DXC=$VM_DXC$</link>
</drilldown>