Confiform - Copy Data into new Form Dublicates

[Maximilian Neufeld]

Hey there,
maybe one has a solution for that

I have a smart multi select field in Form1 
When this field gets changed, I want the values to get copied into another form.

This kinda works but for each value of the smart multi select two entries get created in Form2. Theres always a dublicate. What am I doing wrong? :D

Even if I just clear the smart multi select fully two entrys get created (with empty fields)

</ac:structured-macro>
<ac:structured-macro ac:macro-id="26b34951-9298-4133-844f-04ea9f113d7f" ac:name="confiform-ifttt" ac:schema-version="1">
<ac:parameter ac:name="condition">hasChanged(SmartMultiSelect):true</ac:parameter>
<ac:parameter ac:name="extras3">true</ac:parameter>
<ac:parameter ac:name="action">Copy ConfiForms Data</ac:parameter>
<ac:parameter ac:name="extras">FORM2</ac:parameter>
<ac:parameter ac:name="event">onModified</ac:parameter>
<ac:parameter ac:name="title">Name=[entry.SmartMultiSelect]</ac:parameter>
<ac:parameter ac:name="extras2">id:[entry.id]</ac:parameter>
<ac:parameter ac:name="who">FORM1</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>

[Alex Medved _ConfiForms_]

You have an option to flatten the rows enabled in your "Copy Data" rule

Which means it will make as many records in the target form as you have options selected in the smart multi-select field

[Maximilian Neufeld]

Yeah thats what I thought as well.
But if I put 2 Values in my Smart Multi Select and then trigger the copy my second Form looks like that:

Entry1  Value1

Entry2  Value1

Entry3  Value2

Entry4  Value2

If I only put one value in the Smart Multi Select 2 Entries get created. So its always double the amout of entries...

[Alex Medved _ConfiForms_]

This is exactly how the “flatten” feature works. Making unique combinations in the resulting storage

[Maximilian Neufeld]

Is there a way to only get 1 entry per value in the Smart Multi Row then? If I disable the flatten entries all the values of the smart multi row go in one entry.

[Alex Medved _ConfiForms_]

You can copy the data as in original record or flatten it. You can limit the "flattening" to certain fields only, by setting up the parameter "flatten by fields", providing names of fields to use for "flattening"

[Valerie Knapp]

Hi @Maximilian Neufeld , thanks for your post.

@Alex Medved _ConfiForms_ , can you help with this at all?

Best wishes