How to set maximum/minimum rows in a subtable?

[jockmunro.dcws]

Hi,

Is it possible to set the maximum/minimum number of rows to be shown on a subtable?

I would like to limit the size they can potentially grow. Perhaps then paginating after - say - 5 rows or something?

Thanks

[Angie]

Hi,

At the moment, there is no way to limit the rows of subtables.

A workaround would be applying validation. For example, you can create a stand-alone field with COUNT() to count the rows of a subtable:

Then, apply validation on the stand-alone field so that the only numbers under 5 can be saved. For example:

Note: you may add a customized error message if necessary.

[jockmunro.dcws]

Thanks Angie,

This is a good workaround.

Cheers

[rlegris]

Does anyone know if this has been added as a feature? The workaround does not work for us as we are keeping call logs in a sub table, and not being able to save will not work for us. But then we don’t need 20 rows showing either. Pagination would be great.

[Angie]

Hi,

Your requirement sounds more like this one:

Rows per page for Form View Subtables

Hello, I would like to request the ability to limit the rows in view for each subtable on the form view. We have many entries that have over 100 rows in a single subtable, and it slows down the page. Is this possible? Thanks so much for your consideration! Similar to the list view option: [image]

Our developers are still working on this.

[RagicSolutions]

Any news on this some of our sub tables are becoming very long.

If the pagination is the main challenge, then if I may suggest maybe just a link to view all the records in a new window would make things simpler. Something like https://www.ragic.com/myragicsolutions/mtime/5?pqv1001101=XYZ

Thanks

Ragic Solutions

[kanefranco]

The following thread may be helpful…

Rows per page for Form View Subtables

Hello, I would like to request the ability to limit the rows in view for each subtable on the form view. We have many entries that have over 100 rows in a single subtable, and it slows down the page. Is this possible? Thanks so much for your consideration! Similar to the list view option: [image]

[justin3]

Wanted to see if there were any updates or future plans on supporting pagination in subtables?

[funda.jeremy]

One of the issue with having a subtable without pagination is that the display of forms with long subtable records become very slow. In some cases, we might even need to void using subtable and opt for a “direct link” that points to the filtered records as it is just too slow and not usable.
In addition, if there are even 1 formula in the subtable fields exist on that main form, the edit operation become barely usable. You might need to wait a long long time.
So maybe pagination should be consider a higher priority function to be developed and incorporated to further improve the potential applicaiton of Ragic as a database platform.

[katet]

Hi Justin – thank you for reaching out with your inquiry. At this time, the ability to limit the number of rows in a subtable is not yet available. I have shared your feedback with our development team, and we will be sure to update this thread as soon as the feature is released. We truly appreciate your continued support of Ragic and thank you for your patience as we work to improve the platform

[katet]

Hi Jeremy – thank you for sharing your thoughts. As mentioned just then to Justin, at this time, the ability to limit the number of rows in a subtable is not yet available. I have shared your feedback with our development team, and we will be sure to update this thread as soon as the feature is released. We truly appreciate your continued support of Ragic and thank you for your patience as we work to improve the platform