Want to fetch only their unit's subunits in the field.

[Kruthik M Shiva]

Hi All,
In a record producer I have couple of fields like Unit and subunit which is reference field unit is referring from unit table and subunit is from subunit table (note :subunit table has unit field as well) so in a record producer If i select unit only there related subunits records should display for subunits I have used advanced condition in reference qualifier and it is displaying only there records but for some units there is no subunit for that I need to display n/a value while selecting what needs to be done for this please do share as subunit is also mandatory i need to select N/a for those units.
PFB screenshots for reference and please let me know what changes need to be made.
Thanks in advance.

[Siva Jyothi M]

Hi @Kruthik M Shiva,

You would need to add a reference qual for the sub unit field like below.

javascript: 'unit=' + current.variables.unit_variable;  - Replace unit field with the name of the unit in the sub unit table and replace unit_variable with the correct unit variable name on the form level.

Mark this answer as correct and helpful if it solves your issue.

Regards,

Siva Jyothi M.

[Kruthik M Shiva]

Hi @Siva Jyothi M ,
The advanced qualifier added is already working but for the units with no subunits right for that I am getting like no matches found for those units I want to add a record as N/A with no units specied in the subunit record. So, for which ever unit do not have subunit if they select those units, they should get this N/A option to select.