[New plugin] Fully Customizable Table / Grid

Hi @hhenske This has probably something to do with the custom CSS in the first column. I can’t really help with custom code in cells, but maybe you can try it without it to see if this still happens? If so, you could also try to run the ‘re-render’ workflow action when this happens to see if this fixes the issue :slight_smile:

Yes! The re-render worked! Thanks @Thimo!

Is a pagination input possible with the library?

Also, is there a way to disable the latest text wrapping update? Now all the text in my table buttons is wrapping to the next line when the column width is adjusted (I have enable auto width for columns checked and wrap text in header unchecked).

This does not seem to be supported right now.

This is interesting. I will send you a PM so I can see what is happening exactly. Maybe I can make the feature optional or disable it the the button columns :slight_smile:

1 Like

Hey, thanks for the awesome plugin!

Question, can I sort a column by date? I tried using the Sort as a number? option but it doesn’t work at all.

Look, it is alphabetically sorted, which is wrong for date.

PS: I’m using a custom dd/mm/yy HH:MM date format in this example.

Hi @darlantc, dates are automatically recognized when they are formatted like the date example on the demo page. Sort as a number? is for sorting numbers and, if enabled, will try to parse the values of your columns as number for better sorting.

Hopefully this helps! :slight_smile:

Your demo page example is very limited, all the rows use the same date with slight different hours.
I tried with and without the sort as a number option, the sorting is wrong on both because it sort alphabetically. You probably need to create another option specific to display dates with proper display format & sorting.

Look your bitcoin demo, the date column sorting is also wrong:

Ah, please look at the main demo. This bitcoin demo is made quite a long time ago and those dates are not correctly formatted for sorting. The date formatting on the main demo should be correct.

But yes I agree. Right now only US date formatting is supported. I will put this on my list to see if I can support more date formatting. I will investigate to see what the best UI and logic could be as this can be quite difficult to get right :slight_smile:

2 Likes

Thank you, I appreciate the effort to make enhance it further!

Hi there! Any idea why this would happen? Using version 2.71.0 with theEnable Fixed Table Height feature enabled.

When table first loads, scrolling works fine
Before scroll
image
After scroll
image

However, if a header is clicked on to using the sorting feature, after sorting the sorted column appears to bug out and overwrite the header as you scroll up:

Before Scroll
image
After Scroll
image

Thanks!

@Qip thanks for flagging! I just pushed an update (2.71.1) that should fix this issue! :slight_smile:

I’m using the is loaded conditional to display a loader for a table with over 400,000 entries. Since I have so much data, I opted to display 5,000 results at a time, then created a stepper to change the data source to the next batch of 5,000.

The loader is not showing when I do this because the table has already “loaded” despite switching the data source’s until and from numbers. Is there another method I can use for the is loaded conditional?

@sydney22 It depends a bit on how you are setting the data source. If you are setting a state, you could before setting the state set a custom ‘loading’ state to ‘yes’, then set the states for the table data, and after that set the custom ‘loading’ state to ‘no’. Depending on the value of the custom loading state you can show a loader in your app :slight_smile:

1 Like

Interesting, I’ll try that. Thanks, @Thimo!

Thanks. Top ranked customer support. :smiley:

1 Like

@Thimo, quick question for you, and my apologies if you’ve already answered it somewhere in this forum. The way the table app works requires you to provide each column with data individually, including the index, even if all the columns I’d like to display are all just fields from the exact same search. Say 10 columns / 10 fiields are used. Does that mean when the page renders, the app is executing 10 searches instead of 1? I’m tempted to do a single search on page load, push the results to a state, then point the app to the state. Again, may not matter in most cases, but just trying to understand potential optimization options. What I am ignorant is whether Bubble, or your app, is smart enough to recognize identical data pulls and not do it multiple times. Could you comment on this? Thank you much in advance, it’s been bugging me for some time. :grinning:

Hi @Qip searches are cached when they are executed again. So doing the same search multiple times should not slow down your app. However, using a state or hidden variable will make it easier to manage. I have used a hidden variable in the table on the demo page: Pluginpreview | Bubble Editor

So if you want to use a hidden variable you can take a look at the demo page for an example :slight_smile:

@Thimo I am having a similar issue as someone above. When I go to preview my page, I see that the table simply shows “Loading…” When I refresh the page, it continues to show loading. It was working great a moment ago, I added a few extra columns and it seized up and will not show anything but “Loading…” now. Here’s a screenshot. The table above in the screenshot is Bubble’s out-of-box table element.

@janiece.lincoln This means that you are trying to show incorrect data into your table. Are you by any chance trying to show other data than text/number data? This could for example happen when you try to display date objects without converting them to text. So, could you check if you are you trying to show fields of type “Date”?