Confiform API Import: Smart Multiselect Field

[AmK]

Hello @Alex Medved _ConfiForms_, I am trying to import data into my form but I am having trouble with my Smart Mulitselect Field which is called AppID. The SmartMultiSelect fields is connected to AppDataForm

I tried importing a csv where the values of the column containing AppID looked like:
"123,456" where the numbers are the App Ids

But that didn't work.

Then since it's connected to AppDataForm, I used the IDs of the record in that form, and followed the same format above, but it still did not work. Any advice?

[Alex Medved _ConfiForms_]

Are you talking about importing data through the Import API from CSV/Excel?

For ConfiForms "smart" fields you need to import UUIDs of the records they are linked to.

And for the multi-select "smart" fields this should be a comma separated list of such UUIDs

[AmK]

Yes I am talking about Import API from CSV

Where do I find the UUIDs? In the connected App Data Form?


I already tried importing using comma separated list of the ids in the image from app data form, I am not sure if those are the same as UUIDs

[AmK]

BTW, In the CSV I put the IDs in a comma separated list surrounded by quotations: "<ID1>, <ID2>". Not sure if the IDs were UUIDs though

[Alex Medved _ConfiForms_]

If I understand you correctly, then in AppDataForm you have records that you link in some other form through the smart multi-select field

So, into this "other form" you will need to import values from "id" field in AppDataForm form

[AmK]

Yes, I have a main form which connects to AppDataForm. I use smart multi-select field in main form which connects to AppDataForm. 

Could you clarify what you mean by "import valued from 'id ' field in AppDataForm"

[Alex Medved _ConfiForms_]

Ok, I have this setup

mu - is my smart multi-select (in otherForm) that is connected to "source" form

This is what I import in my CSV

"c9b427d6-17e8-462c-9d35-8d61e9944f81,643612c5-d064-42b0-8524-de206809f52c"

Alex

[AmK]

deleted 

[Alex Medved _ConfiForms_]

Are these IDs of the records in a test form? Hard to follow your screenshots to honest, sorry 

[AmK]

deleted