How to apply filter on dropdown data

[Markisio]

Hi There

here is what I have:

formOne

• Fields
  • type
  • subType
• Values (type, subType)
  • x, 1
  • y, 2
  • x, 3

formTwo

• Fields
  • name - text
  • subType - smart dropdown from form1.subType

What I am looking for how I can add a rule to display in the subType only the values with type is x 

also, the same with the following

formThree

• Fields
  • name
  • jiraIssue - jira issue
  • score

formFour

• Fields
  • jiraIssue - jira issue (no smart from other form)
  • score - readonly or in tableview field

I am looking to populate the score from formThree to formFour in either readonly field or in tableview field

your assistance is greatly appreciated, thanks 

[Alex Medved _ConfiForms_ · Accepted solution]

Hi

Seems to be 2 different questions...

1. Using https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+Field+Definition+Rules#ConfiFormsFieldDefinitionRules-ApplyFilteronafield on subType on formTwo with the filtering expression set to

type:x

2. Using https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+Field+Definition+Rules#ConfiFormsFieldDefinitionRules-Lookupandsetvalue with a lookup filter set to 

jiraissue:[entry.jiraissue]

And the parameters set to 

score=[entry.score]

Alex

[Markisio]

Hi @Alex Medved _ConfiForms_ 

Thanks! 

#2 works fine 

#1 tried many things, for some reason the dropdown with filter applied return zero result, with text filter do we need to do anything special? I tried type:"x" , type:x, type:(x) but always no result. if I remove the filter I get the list populated with all the choices. am I missing anything :) 

[Alex Medved _ConfiForms_]

Hi

I dont know what does not work for you with type:x...

Visual demo of what I have commented earlier http://recordit.co/zQmtRd5MI7

(but there is literally nothing else that I have already said)

Hope it helps

Alex

[Markisio]

hi @Alex Medved _ConfiForms_ 

so odd now it works :) thanks a lot!