Hey guys! I just released a plugin that allows you to add a table / spreadsheet to bubble. After trying all of the paid options available, I still couldnāt find a plugin that would let me properly manage data in my table. (I even offered to pay plugin owners - no luck!)
I wanted users to input a list of info (like addresses and names) and make new bubble data with those inputs. I finally decided to make my own plugin for this, and I think it turned out quite good! Not only does it accomplish this, but itās flexible enough to be used for almost anything table-related.
You arenāt limited to just text boxes. Choose between text, checkbox, dropdown, autocomplete field, number-only, radio, calendar, image, and color picker. I focused on customization and support. If anyone has ideas to improve the plugin, Iāll try my best to update it.
Hi! I took a look, but Iām not sure I totally understand the issue. Are you having issues with just the bubble editor? Or are you also having issues getting the spreadsheet to show up on your live site. If itās the latter, could you copy and paste your column json to me? Thatās usually the culprit. (Or if you have a link to your app that would be even better)
Hi @DevoPanda, thanks for the plugin, the demo is amazing!
Just, there are 2 things I donāt getā¦,
Can I display data from a thing (bubble table row) easily? I guess I need to convert the thing to json with a thing2json plugin, but maybe there is something more straightforward?
And more importantly, can I auto-save data to the thing when users edit a cell? (and how?)
Hey, yes! That was one of the main uses I made this for. My main intention was for creating data, however I actually just made a few updates to make editing data easier as well! I added your question to the FAQ section of the documentation here and also made an example of this exact use in the bubble app here. (Check out the editor for it and how to set that up here)
I just sent the new update out, so it may take a few to see it. Let me know if you still have any questions - thanks!
Any hints on what might be preventing the plugin from showing up on the page? In the editor it seems to be ok, until this morning it was working and I didnāt edit anything in the settings, it just doesnāt appear on the page anymore. I even tried to get the exact same model that is in the plugin demo, but without success.
Could you send a screenshot of your settings? Specifically the āstyleā settings - (if you have a link to the editor that would be even better! Also, a link to the page itself would be useful if possible too)
hmmm!!! Perfect! With your request, I noticed that the column and row colors were off. After including, it came back again. I believe it may have reference to the new Bubble update that came out yesterday. Thanks!!!
Ah awesome! Thatās what I was thinking may have happened⦠Iāll make a fix soon to address that so others donāt run into the same issue. Thanks for posting, and if you run into anything else, Iāll be happy to help!
Is there a way to check (characters/numbers) the values āāentered in each column?
No matter how wide the overall height is, only 7 lines are displayed. I want to show more. The min dimension is set to 10,20.
For example, if you specify 2 for Freeze columns, even if you scroll left and right, you expected that up to the second column will be displayed fixedly, but it will all be scrolled left and right.
One easy way to get your column values is by using regex. Wherever you want to use the data, try getting the ādataā from the spreadsheet and āextract with regexā. Then you can add some regex like: ((?<="Column name": ")[^"]*) and this should return a list of results for that column. I realized that you might run into some trouble if a user enters quotes, so I also added the ability to replace double quotes with single quotes instead (you can find that under the advanced options)
I see! It looks like this feature was broken on the plugins end - Iāve just posted a new update that should fix this.
Unfortunately this feature is also broken with an update I made to the scrolling⦠I couldnāt find a simple way to fix this, so Iāll have to mark this as broken until I find a better fix Iāll keep trying on this one to see if I can get a solution.
Let me know if you have any other questions - thanks!
Hi @DevoPanda
What would you recommend doing to correctly convert the numbers? I use a plugin to import CSV that generates a json result, in which the user can see the result in your Json table plugin.
It turns out that the CSV file can come with different numeric formats:
Default format: 1,000.00
Alternative format: 1.000,00
Do you recommend, or do you have a way, to interpret this number and generate the correct result? I have a file that the product quantity is 1.500 but the table is generating a result of 1.5