In my dashboard i have set of inputs and when i submit the values gets stored in a lookup file.
2 dropdowns , 1 multiselect and 1 text field
Can i store the values from the multiselect into separate records in the lookup or how do i expand as all are clustered like this, not sure how to give a separator.
Multiselect name - Type
CCC eee hhh qqq
... in the lookup file it shows like - AAA ttt BBB fff CCC eee hhh qqq. how do i separate it?
did you tried to create a lookup like this:
Calling it in the multivalue?
the Multiselect input name is
1.my name is
2.the desktop is mine
3.there are many likes
Like this it will be, and it will be stored in the lookup as this
time ID count Type
13th april 2021 1234 4 my name is the desktop is mine there are many likes
I am not sure how to split it , can it be stored as this
13th april 2021 1234 4 my name is
13th april 2021 1234 4 the desktop is mine
13th april 2021 1234 4 there are many likes
Sorry but I don't understand your requirement:
What's the problem, to have these values in the lookup? or what else?
As I said, did you tried to put each value in a different row of the lookup, so you can call all the values from the lookup?