I have a form repeat with a nested form repeat and am having trouble getting the name/index to format correctly, which then makes the data from the child repeat insert into the db as an array based on each index of each child repeat instead of each as their own value on a separate row.
I have scoured every portion of the forums here and the documentation for this and in trying what I have seen to be the most commonly suggested solution for this it is not working as expected, so it is making me think that because most of these topics are 2+ years old there has been a change to how this works within Wappler and so maybe are not relevant anymore?
What I have seen most commonly suggested is in code line for the input(s) of repeat1 add dmx-bind:name"repeat1[{{$index}}]variableName" and of repeat2 “repeat1[{{parentIndex.value}}][repeat2][{{$index}}]variable2Name” (also tried $parent.$index to no avail). When I do this and view in devtools it outputs correctly, like this:
repeat1[0][varName1]:
repeat1[0][varName2]:
repeat1[0][repeat2][0][varName3]: A
repeat1[0][repeat2][0][varName4]: B
repeat1[0][repeat2][1][varName3]: C
repeat1[0][repeat2][1][varName4]: D
repeat1[1][varName1]:
repeat1[1][varName2]:
repeat1[1][repeat2][0][varName3]: E
repeat1[1][repeat2][0][varName4]: F
repeat1[1][repeat2][1][varName3]: G
repeat1[1][repeat2][1][varName4]: H
which should result in the db as:
ID__Ref_ID__Value
1_____0_____A
2_____0_____B
3_____0_____C
4_____0_____D
5_____1_____E
6_____1_____F
7_____1_____G
8_____1_____H
but then the post variables linked to the page form do not generate as expected, and when looking at each variables linked field, each has readded the repeat and index again on the front, resulting in this:
repeat1[0]repeat1[0][varName1]:
repeat1[0]repeat1[0][varName2]:
repeat2[0]repeat1[0][repeat2][0][varName3]: A
repeat2[0]repeat1[0][repeat2][0][varName4]: B
repeat2[1]repeat1[0][repeat2][1][varName3]: C
repeat2[1]repeat1[0][repeat2][1][varName4]: D
repeat1[0]repeat1[1][varName1]:
repeat1[0]repeat1[1][varName2]:
repeat2[0]repeat1[1][repeat2][0][varName3]: E
repeat2[0]repeat1[1][repeat2][0][varName4]: F
repeat2[1]repeat1[1][repeat2][1][varName3]: G
repeat2[1]repeat1[1][repeat2][1][varName4]: H
and instead results in the db as:
ID__Ref_ID__Value
1_____0_____A,E
2_____0_____B,F
3_____0_____C,G
4_____0_____D,H
5_____1_____A,E
6_____1_____B,F
7_____1_____C,G
8_____1_____D,H
I have also tried changing the name and/or id of the repeat 2 where it has its parent index attached to its beginning, which also didn’t work, as it just removes the array brackets and generates a string of the name of whatever you are trying to reference.
Is some way to prevent this from happening, where the repeat id is automatically added to the beginning of the input name in SC, or some other way of achieving this that I am missing? I know I could add a couple hidden inputs and reference each, but based on how frequently I have read this being a common problem, I figure there is probably a more straight forward solution that I am missing.