It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Confiforms: Filter Smart Multiselect based on Smart Classifier

I have a form with 3 Fields: Industry, Sector, Application 

In a second form I have a smart classifier field called "selection" to select Industry and Sector. 
Application in this form should be a multiselect, so I have defined a smart multiselect, named "application" and linked it to the field in my first form, that was easy :) 

Now I want to see only the matching Applications to the preselected Industry and sector. I tried using a rule for field definition to apply a filter like this in the second form:

 

Field name to track changes: selection.sector 

Action to execute: Apply Filter on a Field 

Actionable field name: application

Filter to apply: application:[entry.selection.sector]

 

But I still get the full list of available aopplications instead of filtered values. What do I do wrong? Thanks for any hint. 

2 answers

1 accepted

Hi

How is your application field is related to selection?

Quick misconfig I see is: 

Field name to track changes: should be selection

But to tell more I need to see how the forms are related/connected - can you provide a storage format?

Alex

Thanks @Alex Medved _ConfiForms_ for your quick reply as always. Here is my source code:

 

<p class="auto-cursor-target">
<br/>
</p>
<ac:structured-macro ac:macro-id="1f29dd17-f6c4-4d21-ad17-980332170536" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">denomination</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="92125391-8381-4d49-8d3d-8a29b6e4003f" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">industry</ac:parameter>
<ac:parameter ac:name="fieldLabel">Industry</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="733c3254-c36e-422e-919b-bc94a2788a50" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">applicationsector</ac:parameter>
<ac:parameter ac:name="fieldLabel">Application Sector</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="bcaac652-2383-41e4-be40-669a58842e31" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">application</ac:parameter>
<ac:parameter ac:name="fieldLabel">Application</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<ac:structured-macro ac:macro-id="807de56c-6ca4-461a-a1b3-5ec382625aa4" ac:name="confiform-entry-register" ac:schema-version="1">
<ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<ac:structured-macro ac:macro-id="b7ea9a3d-3d9b-41ec-be8e-d7ffa9164544" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="formName">denomination</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<ac:structured-macro ac:macro-id="4b3f6b6a-2fc8-4fde-8043-01088395c568" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">references</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="645a2c71-79b6-4e83-aac9-d6ce941e94b0" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">title</ac:parameter>
<ac:parameter ac:name="fieldLabel">Reference Title</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
<ac:parameter ac:name="required">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="068fa5a3-66df-4241-9a49-fac6c0600ec2" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">assignment</ac:parameter>
<ac:parameter ac:name="fieldLabel">Assignment</ac:parameter>
<ac:parameter ac:name="values">[436767274:denomination]industry,applicationsector,</ac:parameter>
<ac:parameter ac:name="type">smartclass</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="a64e2ae7-fbc1-4f0f-95a6-6c59efacc820" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">application</ac:parameter>
<ac:parameter ac:name="fieldLabel">Application</ac:parameter>
<ac:parameter ac:name="values">[436767274|denomination|application|true||]</ac:parameter>
<ac:parameter ac:name="type">smartmultiselect</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="6b60eb70-3c26-462a-abcf-b3d0ee8305f0" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="fieldName">application</ac:parameter>
<ac:parameter ac:name="values">application:[entry.assignment]</ac:parameter>
<ac:parameter ac:name="action">Apply Filter on a field</ac:parameter>
<ac:parameter ac:name="actionFieldName">assignment</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="fd475240-7f41-4de6-8392-0c88d5a046e3" ac:name="confiform-entry-register" ac:schema-version="1">
<ac:parameter ac:name="registrationMessage">Thanks for your entry!</ac:parameter>
<ac:parameter ac:name="registrationButtonLabel">Add Reference</ac:parameter>
<ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>
<ac:structured-macro ac:macro-id="ca9ef62c-e1a2-47a5-9453-6d431fac3b23" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="enableFilterSupport">true</ac:parameter>
<ac:parameter ac:name="formName">references</ac:parameter>
<ac:parameter ac:name="enableSearch">true</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="f393e898-1a53-43ef-b6e4-664662154c19" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">title</ac:parameter>
<ac:parameter ac:name="fieldLabel">Reference Title</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
<ac:parameter ac:name="required">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="14ebcf6f-58fa-4b67-bc96-17c523095ede" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">assignment.industry</ac:parameter>
<ac:parameter ac:name="fieldLabel">Assignment</ac:parameter>
<ac:parameter ac:name="values">[434139967:denomination]industry,applicationsector,application,</ac:parameter>
<ac:parameter ac:name="type">smartclass</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="7b7673bb-437b-4448-af69-c0e28eea4483" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">assignment.applicationsector</ac:parameter>
<ac:parameter ac:name="fieldLabel">Assignment</ac:parameter>
<ac:parameter ac:name="values">[434139967:denomination]industry,applicationsector,application,</ac:parameter>
<ac:parameter ac:name="type">smartclass</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="f2c571d9-8ab0-49b8-b606-e147802783a8" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">application</ac:parameter>
<ac:parameter ac:name="fieldLabel">Customer</ac:parameter>
<ac:parameter ac:name="values">false[Agriculture=Agriculture|Asset Management=Asset Management|Automation=Automation|Data Acquisition=Data Acquisition|Drilling Equipment=Drilling Equipment|Energy Data Management=Energy Data Management|Energy Management=Energy Management|Ex=Ex|Exhaust Gas Cleaning=Exhaust Gas Cleaning|General=General|Mining=Mining|Oil &amp; Gas=Oil &amp; Gas|Process Water=Process Water|Pump Control=Pump Control|Remote I/O=Remote I/O|Sewer Network=Sewer Network|Tank Farm Monitoring=Tank Farm Monitoring|Telecontrol=Telecontrol|]</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p class="auto-cursor-target">
<br/>
</p>

For your configuration the filter would be 

industry:[entry.assignment.industry] AND applicationsector:[entry.assignment.applicationsector]

Thanks so much! 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...

8,393 views 6 6
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you