Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Possible to Import to Smart Multi-Row Field?

Denver Thomas December 15, 2023

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?

1 answer

1 accepted

2 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.
December 15, 2023

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 December 15, 2023

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_
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.
December 16, 2023

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

Like Denver Thomas likes this
Denver Thomas December 18, 2023

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events