Variable reference qualifier

ebaileyybs · ‎10-31-2016

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;

Abhinay Erra · ‎10-31-2016

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;

ebaileyybs · ‎10-31-2016

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...

Goran WitchDoc · ‎10-31-2016

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

Goran WitchDoc · ‎10-31-2016

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