We have a auto complete list 'Month_list' which displays all the months in a year.We also have 12 Yes/No drop down fields with lables as month names (January till december).
If a user selects a month in Month_list , we should make the drop down list with labels as previous month till December be visible and editable for user.remaining all months should be non-editable. For eg: if the users selects the month August, we should make the fields with labels July till Dec as visible and editable whereas the fields Jan till June should be non-editable/non-visible.
WE have also tried this using table componenet having two columns Month(with values Jan till Dec) and Value. In this case, we have to compare the selected month with the value in the text field and accordingly make the field non-editable. However we are not able to compare the column header in table comp with a text field.
Can anyone please suggest how can we add rules to accomplish this?
we are planning to have these fields as 12 separate drop down fields(with lables Jan till Dec) as rules not working properly for Table component. However in this case, if we include UI rule to show fields on field change event, we had to include 24 rules(12 for showing fields based on selected month and remaining 12 for hiding fields based on selected month) which I do not think is a correct option.
Please suggest of there is any other way to write UI rules for these fields so that the number of rules can be decreased.