- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-31-2016 08:04 AM
I have created 3 reference on my record producer. I am trying to add a reference qualifier to filter out options based on the parent of the record.
Here are the variables:
The tables referenced here have parent field to show which record is the parent from the former table (eg: a Tier 1 record is the parent of a Tier 2 record) Please see below example:
I have tried using the following reference qualifier on u_tier_2 variable but it will not save and it is not narrowing down the options based on the qualifier. Does anyone know if i have got this wrong and what it needs to be please?
javascript: 'u_tier_1=' +current.variables.u_tier_1;
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-31-2016 08:27 AM
Turns out the reference qual field had somehow been added twice to the variable form which was clearing when saved in the secondary field.
The solution I had originally is working as required.
Thanks for your help.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-31-2016 08:11 AM
You need to add this line to the variable attributes of tier 2 variable
ref_qual_elements=u_tier_1;
Ref qual: javascript: 'u_tier_1=' +current.variables.u_tier_1;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-31-2016 08:21 AM
Hi, thanks for this. I have got this working on another form without adding the attribute line.
I think it is because my app is scoped - weird things happen with scoped apps...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-31-2016 08:26 AM
Hi abhi_r,
Can you explain more why this should be used here. I'm have used this somewhere back in my head, but I can't remember the exact where. I my example below, It worked without this attribute, so Im curious what it really do and what's for.
//Göran
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-31-2016 08:12 AM
Hi Emma,
I looks correct if the field names is right.
For example I made this. Got 3 ref variables:
Depending on which country you choose, you should get a specific list of cities.. so the city record looks like this:
What does you mean with "will not save"?
//Göran