Share
Report
53Hello,
I was going to improve my app, make it faster and easier to access to data for flows and in general.
At the moment I have several fields in DataVerse for every single user input in gallery, for example:
ClearCollect(colTest;
{input: ""};
{input: ""};
{input: ""};
{input: ""};
{input: ""};
{input: ""};
{input: ""}
)
TextInput1 = first field in Database
TextInput2 = second field in Database
...and so on. Every single input control is assigned to a separate field in database. This makes a life harder, especially if I need to create some other screens with the same collections and refer to the controls.
I was going to create a logic which collects all data from gallery controls:
UpdateContext({varTest: Concat(ForAll(Gallery8.AllItems; TextInput25.Text); Value; ", ")})
then patch it to only one single field in database:
Patch(test; Defaults(test); {cr4f5_test: Concat(ForAll(Gallery8.AllItems; TextInput25.Text); Value; ", ")})
This works fine. The problem is appearing with loading the data and reproducing it to the new gallery, which reads it:
ClearCollect(colTest2; Filter(test; cr4f5_id = "1"))UpdateContext({varTest2: ForAll(colTest2; Split(cr4f5_test; ", "))});;
varTest2 works fine, but I got a nested table with "Value" in it.
If I'm trying to split it:
ForAll(colTest2; Collect(colTetete; {Result: Split(cr4f5_test; ", ")}))
I get a Result of nested tables with all data.
How do I split the data and collect it to create a Result (collection) like:
Text: Position 1
Text: Position2
Text: Position 3
...etc? Which would show it in an other gallery:
input: "123"
input: "125"
input: "1255"
input: "643634"
input: "4343"
input: ""
input: ""
..and be accesable with Index()?
All responses (
Answers (
