Question

Table in a collection

Forms Web Customizations How To Laserfiche Version 10

Updated January 7, 2019

asked on January 4, 2019

Hello,

i know this question is already asked, but is there a way to put a table into a collection.

not necessary a "Forms" table, but any functional table that adds rows and works well when we add or remove collection.

did anyone done anything similar ?

or is it possible in the newer versions ?

Thanks .

Maher.

0 0

Replies

replied on January 4, 2019

I have a situation where I needed to add 1-5 rows of data (3 fields) inside a collection. I resolved it like this:

1. I added the 15 fields (5 rows x 3 fields) I needed to my collection. Using CSS I got them to display as 33% width and side-by-side.

2. I added a hidden number field with a default of 1.

3. I added a custom HTML field with two buttons, to add a row and delete a row.

4. Using Javascript, I got the add and delete row buttons to increment/decrement the hidden number field. The Javascript also disabled the add row button when the number field was 5, and re-enabled it when it was 1-4. It disabled the remove row button when the number field was 1, and re-enabled it when it was 2-5.

5. Then I used field rules to only display the fields I wanted based on the hidden number field, when it was 1, it showed fields 1-3, when it was 2, it showed fields 1-6, when it was 3, it showed fields 1-9, etc.

This isn't actually a table, but it does appear similar to a table, and this solution doesn't scale really well, and you need to know the upper limit of the inner "table". But it worked very well for my purposes.

1 0

replied on January 4, 2019 • Show version history

Jared from Laserfiche said no on this thread in May of 2017:

Someone in that thread asked if anyone had found a solution as recently as March 2018.

Hope this helps clarify,

Chris

0 0

replied on January 4, 2019

I think it would help to know more about the use case. What are you trying to accomplish that requires a table within a collection rather than just a standalone table?

Understanding the specific need often helps in figuring out the best solution.

0 0

replied on January 6, 2019

Dear Jason,

i have managed to put a custom html editable table in the collection.

my case is that i have account opening process with joint accounts. for each account i have many information , within these information a have tables stating the children and DOB, sources of income, etc.. data that needs to be multiple for each account.

that's why i need it.

so what i will do is after putting the data in the custom html table i will move the data to a field in the collection comma separated in order to display them in the table at the next task.

regards,

Maher.

2 0

replied on January 7, 2019

The use case makes sense. If you have a low limit on how many different people can be on a joint a count, you could also try the following:

Create a separate table for each person on the account (table_1, table_2, etc.)
Create a hidden number field with a default value of 1
Use field rules to hide the additional tables if the value of the hidden field is less than _
Add custom html with "Add" and "Remove" links/buttons
Use JavaScript to update the increment or decrement the hidden field values when the custom links are clicked.

0 0

You are not allowed to follow up in this post.

Question

Question

Table in a collection

Replies

Sign in to reply to this post.