Hi comunity,
I have a question regardning the following example
Collection colCart i create with no prblem
| Teamname | TeamCity | TeamMusic | TeamFruit |
| Fish | City1 | Pop | Apple |
| Lion | City2 | Disco | Citrus |
Then i will fill my two TextInput fields.
I have two TextInput.Text like this bellow
Color1 = TextInput1.Text = Green
Color2=TextInput2.Text = Yellow
And then i try two create my second Collection colColor
But when i try to create my second collection and use the values from the first togheter with the vaules from the second there getting problems.
It only take the first row in the first collection and not the second. like bellow
| Teamname | TeamCity | TeamMusic | TeamFruit | Color1 | Color2 |
| Fish | City1 | Pop | Apple | Green | Yellow |
I use the code bellow. What am i doing wrong?
Collect(colColor;
{ Color1: TextInput1.Text;
Color2: TextInput2.Text;
Teamname: LookUp(colCart; !IsEmpty(Teamname)).Teamname
TeamCity: LookUp(colCart; !IsEmpty(TeamCity)).TeamCity;
TeamMusic:LookUp(colCart; !IsEmpty(TeamMusic)).TeamMusic;
TeamFruit:LookUp(colCart; !IsEmpty(TeamFruit)).TeamFruit
})
