Improve Table formatting

[gvlx]

Describe the feature request Tables are one of the most used elements in data entry, but also one of the most complicated to design.

The setting pane of the table element requires a lot of improvements, some of which I mention here, hoping other will add more details later on.

Improvements:

• [x] Column selection (which columns/fields are included)
• [x] Column sorting (order the fields are presented)
• [x] Column size
• [ ] Column formatting (other than size)
• [ ] Cell content rendering choices (img size, ratio)
• [ ] Cell links (cell has a link)
• [x] Row selector (row select check box)
• [x] Row links (row has/is a link)
• [ ] Row sorting (column based and expression based)
• [ ] Table formatting: borders, color patterns, banding, etc.
• [ ] Header formatting
• [ ] Automatic columns and rows for aggregation formulas (sum, count, etc)

Sugestions Creating a new 'complex table' element which behaves like a Repeater but with automatic header row and row sorting and selector mechanisms. Each added element creates its header entry automatically.

[gvlx]

I've just noticed (still a newbie here): the table element is a container.

Some (most) of the above can be solved if each added element can have a property to create its header. This would mean the table would be used without any visible columns.

Right now (0.9.177) it is left without a header:

[gvlx]

Linking to issue #1694 .

[mjashanks]

Thanks @gvlx - linking to this discussion also: https://github.com/Budibase/budibase/discussions/1913

Note that you can currently change the Column selection and ordering...

1. Unselect all columns
2. Select columns in the order you want them to appear

[gvlx]

Thank you, I was already using that feature ;)

[marco-santulli]

I agree that being able to "enhance" the current table with a couple of features would be of great help. I would suggest:

1. one can already add buttons and paragraphs to a table as extra column, but one must be able to specify a "name" for that column like in gvlx comment above;
2. it might be necessary to give a "readable" name to a column. The column names currently come from a DB in many cases, so it might not be very user friendly (without also considering the future need for i8n.
3. make the table cells writeable like in an excel, best with auto-save / undo or the option to "save" with a button
4. would be good to have the usual table perks from the end-user side: (sort, filter, download csv/xls)

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[AndrewSav]

Do we need to keep posting +1s to keep this open?

[Rory-Powell]

@AndrewSav we no longer automatically close stale issues

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[melohagan]

Table banding also requested in this discussion: https://github.com/Budibase/budibase/discussions/5197

It could effectively be the same as 'Quiet' but applied to even rows only. Call it banded or striped.

[marco-santulli]

Hi,

can we add a flag to tables to turn-off sorting? at the moment sorting doesn't really work for custom queries where we implement pagination manually. In that case sorting just sorts the current page. It should be possible to turn it off?

M

[melohagan]

Allow linked rows to be opened in new tab, as you can with clickable links within the rows (https://github.com/Budibase/budibase/discussions/5577)

[melohagan]

Allow individual table cells to be formatted: https://github.com/Budibase/budibase/discussions/6341

[melohagan]

Allow linked rows to be opened in new tab, as you can with clickable links within the rows (#5577)

Also want to be able to open Card links in a new tab.

[melohagan]

It'd be nice to have an option to type in a page number to goto.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity.

[AndrewSav]

Do we need to keep posting +1s to keep this open?

[melohagan]

Hey @AndrewSav No need to worry, this issue wont be closed until it's completed! The stale bot doesn't auto close.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity.

[leolivier]

The issue is closed but at least one thing is missing in my opinion: Column formatting (other than size): imagine I want to create a column containing an email or a phone number, I'd like to manage the formatting constraint at the column level and not each time I create a field in a form. Also, it might be a good move to create such predefined basic types as emails, phone number, ...

[mike12345567]

Closing this issue as new issues specific to the grid would be better - there is quite a lot of discussion here pertaining to our old table format, if there are specific issues pertaining to our grid and data layouts new issues detailing them would be preferred.