SmartDropdown - Excel Import Problem

[DannyRue]

Hello together, i hope you can help me.

I try to explan: I have two databases.
Database1 have all entries for the SmartDropdownfield in Database2
Database2 have a Smart Dropdown field with the entreis from Database1

Everything works good, but now i want to import in Database2 some entries with the SmartDropdown Field. If I import it from excel - everything fine. Table view shows the text, but if i got to edit - the field is empty.

So is there any trick for the Exel that he make it right?

The same problem i have, if i want to set a value to this field automatic, because confiforms cant set the right information.

Thanks for your help

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @DannyRue 

When you import a value for the smart dropdown you need to import the UUID (id field) of the record it should be linked to

As smart fields dont hold the actual data, but only the references to the records they are linked to

Same goes with the "set value" - UUID is expected. The easiest way is to make a lookup in the form with values by filter and get the matching record's id (UUID value) and set it

Alex

[DannyRue]

Hi Alex, thanks very much - it works with the id Number, PERFECT :-)