Confiform Table Merger

[Ben B_]

Hello,

I have two forms -

Form1 with field myName (Text) and field myFriends (Smart Multi-Select on Name field of Form2)

Form2 with field Name and field Age

I need a table in the end that looks like this:

myName                             myFriends                       age

---

Ben                                     Alex                                 38

---

Ben                                     Cole                                 40

---

Austin                                 Alex                                 40

So first I have to flatten the Form1 to get 1 row for every smart multi select value then I want to add the age belonging to myFriends of Form2

Is this possible?

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @Ben B_ 

I guess it actually should be

myName                             myFriends                       age

---

Ben                                     Alex                                 38

---

Ben                                     Cole                                 40

---

Austin                                 Alex                                 38

But here is how you can tackle this - little video demo, hope it helps

Alex

[Ben B_]

Thank you so much!! Helps a lot - and of course u are right - Alex is 38 :D