20 Posts
Olek
7 years ago
6
Topic

Hello!

I'm struggling with a big challenge (at least for me it's big). I'm trying to create a form consisting of many fields, which finally (in the front-end) will have to look and behave pretty much like Excel's spreadsheet. I mean - I'd like to display them in the form of a table. I guess the only way is to use seb_table, right?

So the unknowns start for me right here:

  1. I want to create a 'complex' table header (higher header row cells spanning few columns, lower header row rather regular)
  2. The bottom row of the table would have to sum values of the columns. I mean - let's say column A has values 10 and 5, so the cell in the bottom row would show 15. Column B has values 100 and 200, so the cell in the bottom row would show 300 and so on.

Is it possible with the seb_table in the first place? If so - how to achieve my goals? If not - what options do I have?

Thank you in advance for any ideas!

Get a Book for SEBLOD
4229 Posts
Kadministrator
7 years ago
0
Level 1

Hi,

are you looking for single item tempalte or mutiple items? Seb_table is to be used on muliple items search results (with each row comming from a separate record), so please first let us know if all this data will be from single item or multiple ones?

20 Posts
Olek
7 years ago
0
Level 1

Silly me, I didn't indicate it in the first post. The data will be collected from multiple records (one record=one row in the table). Range of records will be selected with the help of 2 calendar fields ('from' and 'to') in the search form. That's why I thought of seb_table. But frankly I have no idea how to create that extra row in the header and - even more important - the bottom row, which sums up values provided by records in the rowa above.

4229 Posts
Kadministrator
7 years ago
0
Level 1

Hi,

then seb_table it the right one for you. for the header you will need to add some css to get different headers for some columns. For the footer you have 2 options - do it in php or javascript, if you go for php you will need to copy seb_table template and modify it so that you will collect all values from certain field, do calculation and display it in the footer. Other option is to create custom javascript to do the same, with this option you don't need to duplicate template, you just need a script to read all values from certain column, do calculation and then inject a new row and a cell with this calculated value.

For all this options you need a developer or get our support service, there is no generic solution available.

20 Posts
Olek
7 years ago
1
Level 1

Thank you for your advice, I appreciate it. Will try to figure it out in the PHP way myself.

2 Posts
alkahest
5 years ago
0
Level 2

@Olek 

Did you find a solution for summing up columns in a bottom row? I am very much interested in it. I am a total beginner and don't know how to change the template (seb_table) and how to sum up columns.

Thank you in advance.

103 Posts
shubhaanshu
5 years ago
0
Level 1

Hello friends!

could anybody found the solution to sum up the column values?

Best Regards!

Get a VIP membership