Possible to Import to Smart Multi-Row Field?

[Denver Thomas]

I'm trying to import an excel file to populate a confiforms, and am having no luck importing to Smart Multi-Row fields.

A smart multi-row with three rows with the text "dog", "cat", and "cow", respectively, exports as,

"dog cat cow"

Turning around and trying to import that same thing results in an empty smart multi row field.

Is there a particular syntax for importing to smart multi-rows that works?

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @Denver Thomas 

As with any "smart" fields in ConfiForms, when you import, you need to provide and UUID of the record this smart field is linked to

For multi-value fields a comma separated list of UUIDs is expected

Alex

[Denver Thomas]

So first I tried,

4dea8560-1df4-4cef-bfa8-ae5ae01a83f6 = entryId

A,B,C = smart multi-row field

This attempt at least populated the smart multi-row field with a single row "A"

Then I tried,

4dea8560-1df4-4cef-bfa8-ae5ae01a83f6,4dea8560-1df4-4cef-bfa8-ae5ae01a83f6,4dea8560-1df4-4cef-bfa8-ae5ae01a83f6 = entryId

(the same UUID repeated 3 times, separated by commas)

A,B,C = smart multi-row field

This resulted in a blank smart multi-row field

What am I doing wrong?

[Alex Medved _ConfiForms_]

Hi

Sorry, I struggle to understand what have you tried... but here is a little demo of what I was trying to say

http://recordit.co/kOgo768xU2

Hope it helps

Alex

[Denver Thomas]

This did eventually steer me in the right direction. I didn't realize I'd have to import the data into another form first, and then import from that form into a second form to construct the multi-rows I wanted