SmartDropdown - Excel Import Problem

DannyRue July 13, 2023

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

1 answer

1 accepted

0 votes
Answer accepted
Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 13, 2023

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 July 14, 2023

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events