Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Show/Hide fields deppending on Value

Guillem Pascual Suasi
Guillem Pascual Suasi October 25, 2019

Hello.

I'm trying to build a behavior in order to show just the fields I need to see depending on the value of a previous field. We have 3 "sets" of fields, but with the script I'm using, it only works for the first set (SN), and I need it to apply to all 3 sets correctly.

Here's my script:

def Field1 = getFieldByName("SN (1)")
def Field2 = getFieldByName("SN (2)")
def Field3 = getFieldByName("SN (3)")
def Field4 = getFieldByName("SN (4)")
def Field5 = getFieldByName("SN (5)")
def Field11 = getFieldByName("SN (6)")
def Field12 = getFieldByName("SN (7)")
def Field13 = getFieldByName("SN (8)")
def Field14 = getFieldByName("SN (9)")
def Field15 = getFieldByName("SN (10)")
def Field6 = getFieldByName("New Net price (1)")
def Field7 = getFieldByName("New Net price (2)")
def Field8 = getFieldByName("New Net price (3)")
def Field9 = getFieldByName("New Net price (4)")
def Field10 = getFieldByName("New Net price (5)")
def Field16 = getFieldByName("New Net price (6)")
def Field17 = getFieldByName("New Net price (7)")
def Field18 = getFieldByName("New Net price (8)")
def Field19 = getFieldByName("New Net price (9)")
def Field20 = getFieldByName("New Net price (10)")
def Field21 = getFieldByName("Current Net price (1)")
def Field22 = getFieldByName("Current Net price (2)")
def Field23 = getFieldByName("Current Net price (3)")
def Field24 = getFieldByName("Current Net price (4)")
def Field25 = getFieldByName("Current Net price (5)")
def Field26 = getFieldByName("Current Net price (6)")
def Field27 = getFieldByName("Current Net price (7)")
def Field28 = getFieldByName("Current Net price (8)")
def Field29 = getFieldByName("Current Net price (9)")
def Field30 = getFieldByName("Current Net price (10)")

def NumberField = getFieldById(getFieldChanged())

def selectedOption = NumberField.getValue() as String
def Option1 = selectedOption == "1"
def Option2 = selectedOption == "2"
def Option3 = selectedOption == "3"
def Option4 = selectedOption == "4"
def Option5 = selectedOption == "5"
def Option6 = selectedOption == "6"
def Option7 = selectedOption == "7"
def Option8 = selectedOption == "8"
def Option9 = selectedOption == "9"
def Option10 = selectedOption == "10"

Field1.setHidden !(Option1 || Option2 || Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field1.setRequired (Option1 || Option2 || Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field2.setHidden !(Option2 || Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field2.setRequired (Option2 || Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field3.setHidden !(Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field3.setRequired (Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field4.setHidden !(Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field4.setRequired (Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field5.setHidden !(Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field5.setRequired (Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field11.setHidden !(Option6 || Option7 || Option8 || Option9 || Option10)
Field11.setRequired (Option6 || Option7 || Option8 || Option9 || Option10)
Field12.setHidden !(Option7 || Option8 || Option9 || Option10)
Field12.setRequired (Option7 || Option8 || Option9 || Option10)
Field13.setHidden !(Option8 || Option9 || Option10)
Field13.setRequired (Option8 || Option9 || Option10)
Field14.setHidden !(Option9 || Option10)
Field14.setRequired (Option9 || Option10)
Field15.setHidden !(Option10)
Field15.setRequired (Option10)

Field6.setHidden !(Option1 || Option2 || Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field6.setRequired (Option1 || Option2 || Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field7.setHidden !(Option2 || Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field7.setRequired (Option2 || Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field8.setHidden !(Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field8.setRequired (Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field9.setHidden !(Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field9.setRequired (Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field10.setHidden !(Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field10.setRequired (Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field16.setHidden !(Option6 || Option7 || Option8 || Option9 || Option10)
Field16.setRequired (Option6 || Option7 || Option8 || Option9 || Option10)
Field17.setHidden !(Option7 || Option8 || Option9 || Option10)
Field17.setRequired (Option7 || Option8 || Option9 || Option10)
Field18.setHidden !(Option8 || Option9 || Option10)
Field18.setRequired (Option8 || Option9 || Option10)
Field19.setHidden !(Option9 || Option10)
Field19.setRequired (Option9 || Option10)
Field20.setHidden !(Option10)
Field20.setRequired (Option10)

Field21.setHidden !(Option1 || Option2 || Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field21.setRequired (Option1 || Option2 || Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field22.setHidden !(Option2 || Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field22.setRequired (Option2 || Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field23.setHidden !(Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field23.setRequired (Option3 || Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field24.setHidden !(Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field24.setRequired (Option4 || Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field25.setHidden !(Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field25.setRequired (Option5 || Option6 || Option7 || Option8 || Option9 || Option10)
Field26.setHidden !(Option6 || Option7 || Option8 || Option9 || Option10)
Field26.setRequired (Option6 || Option7 || Option8 || Option9 || Option10)
Field27.setHidden !(Option7 || Option8 || Option9 || Option10)
Field27.setRequired (Option7 || Option8 || Option9 || Option10)
Field28.setHidden !(Option8 || Option9 || Option10)
Field28.setRequired (Option8 || Option9 || Option10)
Field29.setHidden !(Option9 || Option10)
Field29.setRequired (Option9 || Option10)
Field30.setHidden !(Option10)
Field30.setRequired (Option10)

 

Any idea or suggestion on hoe to make it work properly or improve it?

KR

Answer
Watch
Like Be the first to like this
604 views

1 answer

1 accepted

Suggest an answer

Log in or Sign up to answer
0 votes
Answer accepted
Peter-Dave Sheehan
Peter-Dave Sheehan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
October 25, 2019

For one... let's start by simplifying

Start by abstracting your field option from your action logic (think about being able to easily modify the fields or options. Then just iterate through and take the same action on each option.

def fieldOptionMap= [
   "SN (1)":["1","2","3","4","5","6","7","8","9","10"],
   "SN (2)":["2","3","4","5","6","7","8","9","10"],
   "SN (3)":["3","4","5","6","7","8","9","10"],
   "SN (4)":["4","5","6","7","8","9","10"],
   "SN (5)":["5","6","7","8","9","10"],
   "SN (6)":["6","7","8","9","10"],
   "SN (7)":["7","8","9","10"],
   "SN (8)":["8","9","10"],
   "SN (9)":["9","10"],
   "SN (10)":["10"],
   "New Net price (1)":["1","2","3","4","5","6","7","8","9","10"],
   "New Net price (2)":["2","3","4","5","6","7","8","9","10"],
   "New Net price (3)":["3","4","5","6","7","8","9","10"],
   "New Net price (4)":["4","5","6","7","8","9","10"],
   "New Net price (5)":["5","6","7","8","9","10"],
   "New Net price (6)":["6","7","8","9","10"],
   "New Net price (7)":["7","8","9","10"],
   "New Net price (8)":["8","9","10"],
   "New Net price (9)":["9","10"],
   "New Net price (10)":["10"],
   "Current Net price (1)":["1","2","3","4","5","6","7","8","9","10"],
   "Current Net price (2)":["2","3","4","5","6","7","8","9","10"],
   "Current Net price (3)":["3","4","5","6","7","8","9","10"],
   "Current Net price (4)":["4","5","6","7","8","9","10"],
   "Current Net price (5)":["5","6","7","8","9","10"],
   "Current Net price (6)":["6","7","8","9","10"],
   "Current Net price (7)":["7","8","9","10"],
   "Current Net price (8)":["8","9","10"],
   "Current Net price (9)":["9","10"],
   "Current Net price (10)":["10"] 
]

def NumberField = getFieldById(getFieldChanged())
def selectedOption = NumberField.value.value

fieldOptionMap.each{ fieldName, optionValues ->
   def formField = getFieldByName(fieldName)
   formfield.setHidden(!(selectedOption in optionValues ) )
   formfield.setRequired(selectedOption in optionValues )

}
View More Comments
Reply
Guillem Pascual Suasi
Guillem Pascual Suasi October 25, 2019

Worked great, thank you so much!

Like
groups-icon
App Central
TAGS
AUG Leaders

Atlassian Community Events

    See all events