conditional logic - 'more than or equal to' operator

[Iain-g]

Hi there,
I'm creating a 'table' component with a select field for the number of columns (min 2 max 6). I then have a text field to show per column.

So with conditional logic I want to show the column 3 text field if the select value is greater than or equal to 3.

I can get the field showing with:

                   'conditional_logic'=> [
                    [
                      [
                        'fieldPath' => '../tableColumns',
                        'operator' => '==',
                        'value' => '3'
                      ]
                    ]
                  ]

so I know I'm close, but that only shows while '3' is the selected number, choose '4' instead and it rightly disappears, but if I change operator to
'operator' => '>=',
The field no longer shows for any select value.

Am I getting the operator wrong, or can I have several values for '==' ?

[MadFlip]

Hi lain-g, as far as I know, you can have several values.
This will work as AND:

'conditional_logic' => [
    [
        [
            'fieldPath' => '../tableColumns',
            'operator' => '==',
            'value' => '3',
        ],
        [
            'fieldPath' => '../tableColumns',
            'operator' => '==',
            'value' => '4',
        ],
    ],
]

And this will work as OR:

'conditional_logic' => [
    [
        [
            'fieldPath' => '../tableColumns',
            'operator' => '==',
            'value' => '3',
        ]
    ],
    [
        [
            'fieldPath' => '../tableColumns',
            'operator' => '==',
            'value' => '4',
        ],
    ],
]

[Iain-g]

Hi @MadFlip -
thanks, the AND version is what I need, but I pasted that in and the field doesn't show for either value then.

[Iain-g]

Just also tried the OR code, and that works for the first value but not the second 'or' value.

[MadFlip]

@Iain-g if I understood correctly what you want to achieve, this should work:

[
                'label' => 'Table Columns',
                'name' => 'tableColumns',
                'type' => 'select',
                'allow_null' => 0,
                'multiple' => 0,
                'ui' => 1,
                'ajax' => 0,
                'choices' => [
                    2 => '2',
                    3 => '3',
                    4 => '4',
                    5 => '5',
                    6 => '6', 
                ],
                'default_value' => 2
            ],
            [
                'label' => 'Table',
                'name' => 'table',
                'type' => 'group',
                'layout' => 'table',
                'sub_fields' => [
                    [
                        'label' => 'Column Text 1',
                        'name' => 'columnText1',
                        'type' => 'text',
                    ],
                    [
                        'label' => 'Column Text 2',
                        'name' => 'columnText2',
                        'type' => 'text'
                    ],
                    [
                        'label' => 'Column Text 3',
                        'name' => 'columnText3',
                        'type' => 'text',
                        'conditional_logic' => [
                            [
                                [
                                    'fieldPath' => '../tableColumns',
                                    'operator' => '>',
                                    'value' => 2
                                ]
                            ]
                        ]
                    ],
                    [
                        'label' => 'Column Text 4',
                        'name' => 'columnText4',
                        'type' => 'text',
                        'conditional_logic' => [
                            [
                                [
                                    'fieldPath' => '../tableColumns',
                                    'operator' => '>',
                                    'value' => 3
                                ]
                            ]
                        ]
                    ],
                    [
                        'label' => 'Column Text 5',
                        'name' => 'columnText5',
                        'type' => 'text',
                        'conditional_logic' => [
                            [
                                [
                                    'fieldPath' => '../tableColumns',
                                    'operator' => '>',
                                    'value' => 4
                                ]
                            ]
                        ]
                    ],
                    [
                        'label' => 'Column Text 6',
                        'name' => 'columnText6',
                        'type' => 'text',
                        'conditional_logic' => [
                            [
                                [
                                    'fieldPath' => '../tableColumns',
                                    'operator' => '>',
                                    'value' => 5
                                ]
                            ]
                        ]
                    ],
                ]
            ]

[Iain-g]

That's done it - thank you! I had the syntax wrong for 'greater than'.