Import API ConfiForms

I have a question:

I imported an Excel file and used the data to populate a Smart Dropdown.
Now I want to apply Rules for Field Definition (e.g., show or hide fields based on selected values).
However, the dropdown doesn't seem to provide IDs or labels that I can use in my rules.

How can I get the necessary identifiers (like IDs or labels) from the imported values so I can apply rules properly?

My excel file has one column

импорт.png

должности.png

1 answer

0 votes

What exactly do you want to hide? Based on what?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I have 2 fields: "ex1"(smart dropdown) and "ex2"(text field)
After importing all the values, I want to hide field ex2 when i choose some of them (using Rules for Field Definition as usual)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@Alex Medved _ConfiForms_

I solved that issue,
but now I have another one.

I have two smart dropdown fields, their values I pull from Excel files.

Now I want to apply a filter between them —
so that one dropdown filters the other.

I'm doing it correctly:
I create Rules for Field Definition, then
Condition - d6:2
Actionable field name - d5

Filter to apply on a field:
d5:1 OR d5:2 OR d5:3 and so on.

But as a result, the field becomes empty —
specifically when I select d6:2.

So the filtering breaks.

What should I do in this case?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

What I was trying to ask is how your are planning to filter those

It might be that the best option here would be to use the smart classifier instead and have those items grouped, so each item has also a label

Field1	Field2
Position 1	ABC
Position 2	ABC
Position 3	XYZ

You create a smart classifier, selecting Field 2 as first field and then adding the Field1

So it will create 2 dependent dropdowns automatically filtered

Fisrt one with options ABC and XYZ (2 items) and second one is filtered dynamically based on the selection made in the first

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Good method!
But when I did it through the smart classifier, I encountered a similar issue

I have two columns
I imported them
Added them to the smart classifier, and now the list does not display
I can see that there are values, and when I click on any value it filters

but it feels like something is broken