Using Smart Dropdown picks to set field value

Question

I have a form fed by a smart dropdown table on another page. The table has 5 columns/fields and the main form has you choose 3 drop downs from that table.

What we need is for a field to be populated by the value in column 4 based on the options chosen in the 3 dropdown fields.

I've tried the following condition to set the value, but the fields just comes out blank.

Condition: Field1:Option1 AND Field2:Option2 AND Field3:Option3

Set Value: Field4=[entry.Field3.Column4]

Unfortunately, this is just resulting in a blank field for Field4.

I'm sure I'm missing something simple, but any help would be appreciated.

Alex Medved _ConfiForms_ · Answer

Well, just enable the "debug" parameter in the ConfiForms FormView Registrations Control and see if the rule triggers

Erin Smith · Answer

HI Alex,

The rule doesn't seem to trigger as Field4 remains blank.

The smart dropdown table (other form) does have the Column4 field.

If I switch the rule to an Apply Filter rule, it does filter the values, but we are trying to simply set the value so the user doesn't need to actually click on the dropdown and choose the 1 value that is there.

Thanks.

Alex Medved _ConfiForms_ · Answer

Does the rule triggers at all? Does the form, that the Field3 is connected to, has the Column4 field?