Make an element as title in a colum with diferent items

[javier94]

I have this... (attached picture)... with jomla 3.8.8...fabrik 3.8


as you can see.. i have 4 possible elements... that i have created as a repeteable group... and i have to repeat 60 times with diferent items.. same title element..

would be possible.. use the element title as a column title ? instead repeat the title element in each register ??

or maybe will be easier, not make a repeteable group??

There is a way to do it without use the php or custom list...?? all the post i have seen are making with php, and i don´t know to much.

what will be the best option.?'

thanks

Javier

 

[troester]

It's built in. Set Template=table in group "Repeat" settings.

 

[javier94]

Perfect!! Thanks!!

 

[javier94]

i have some troubles.. because the list crashed..

but i make a mistake.. i copied from other group.. and i copy a parent_id element.. i saw in details list... i'm gonna try to delete.. but i'm not surre.. if not.. i will create new list.. and will see if is working.. thanks!!

 

[javier94]

I show you here what I tryed... the elements now are ok...


As you can see there are 4 repeteable groups.. i set in template as " TABLE".. and the form is working.. the trouble is when you fill the form.. and save the datas... the screen remains white.. and you can not see nothing.. and no error syntaxis appear..!!.. seems is not working...

I have divided instead of one form... with 4 repeteable groups... in 4 forms with 1 repeteable group... seems now is working...

 

[cheesegrits]

Did the list display work when you had the single form with 4 repeat groups?

Problems with multiple repeat groups are often down to the size of the selected result set when building the list. Just because of the way relational databases work, when you have multiple joins, they are cumulative.

So, if you have a main table and one "left join" to another table (a repeat group) with (say) 5 related rows (repeats), the result set for ...

SELECT FROM parent_table LEFT JOIN child_1 ON ...

... is 5 rows. Add a second join, again with 5 rows, and ...

SELECT FROM parent_table LEFT JOIN child_1 ON ... LEFT join child_2 ON ...

... is 25 rows. Add a third with 5 repeats and it's 125. Add a fourth with 5 repeats and it's 625. Add a fifth with 5 repeats and it's 3,125. And that's just for one row in the table. For a list with (say) 10 displayed rows, multiply that by 10.

And although Fabrik "reduces" that data in list view, we still have to deal with potentially huge data sets returned from the list query, which can easily run PHP out of memory.

So sometimes, what looks like an error on submitting a form with many repeat groups, is actually an error on displaying the list view, after the submission redirects back to the list.

-- hugh

 

[javier94]

ok.. seems that if i divided is working.. i will try with more users and if is working is ok.. thanks!