Editable Data Table like Excel - New Plugin from Zeroqode

levon · March 22, 2018, 11:48am

Hey Zeroqoders
we have published a new plugin

Editable Data Table like Excel - This plugin lets you show your database content to a user in a very friendly and intuitive way (much like excel or airtable)

Here are the instructions how to make the plugin work.
Go to your app settings http://prntscr.com/inntef .
Go to API tab and enable option “This app exposes a Data API” http://prntscr.com/inntz1 .
Choose a data table which you’ll use in Editable Grid.
Go to Data > Privacy and choose fields which will be displayed in your grid http://prntscr.com/innwlr .
Go to Editable Grid settings and set your Data Type, columns and fields Unique ID which you want to display in Grid ( NOTICE! Columns name should be same as they`re in Database, upper and lower case should be respected ) http://prntscr.com/ino4y9 .

Here is the plugin page: Editable Data Table like Excel Plugin | Bubble

Demo page:

https://plugintests.bubbleapps.io/editable_grids

And some screenshots

Levon Terteryan
Founder @ Zeroqode & Bubblewits

let’s stay in touch on twitter!

Bubble Templates
Bubble Plugins
Bubble Courses
Convert Web to iOS & Android
No-code Development Services

getyouthy · May 12, 2018, 9:13pm

Heya just subscribed for the plugin. I’m sure I’m missing something with setting it up. After making the API changes I think I’m entering the wrong details in the Data Type and Column fields. Should I enter them as they displayed in the Data tab on Bubble e.g. First Name or as the header appears in for example the csv export first_name_text? Thanks!

levon · May 13, 2018, 2:15pm

Hey there,
thanks for giving our plugin a try
you should enter the fields as they appear in your data tab (case sensitive)
same with the data type.
if it still doesn’t work please send us the screenshots of your data tab, plugin settings and api settings
thanks
Levon Terteryan
Founder @ Zeroqode & Bubblewits

Bubble Templates
Bubble Plugins
Bubble Courses
Convert Web to iOS & Android
No-code Development Services

getyouthy · May 13, 2018, 4:33pm

Thanks for the quick response. I found that my datatype ‘My People’ was returning a 404 error in the javascript console so renamed it to ‘MyPeople’ now it works a treat so far. Seems to only like expressions without spaces. Thank you!

Lastly I’m a little bit worried about Exposing a Data API and security. If I have the appropriate API settings in the Privacy tab is there anything to be worried about?

levon · May 14, 2018, 8:26am

thanks for letting us know, we’ll try to fix this

if you do the privacy settings right then I believe nothing to worry about
thanks!

paul · June 27, 2018, 2:46pm

Hi @levon, I’ve installed the plugin but keep getting the following error, any thoughts?

karel · June 27, 2018, 3:17pm

Hi Paul
I’m sorry to hear that.

It will help us a lot, if you share with us more details about your issue, the same as the exact page (URL), where the problem appears.
Thanks in advance.

paul · June 27, 2018, 3:33pm

I just installed it following the normal instructions (I think!). If you PM me I’ll send you a link to the editor page.

karel · June 29, 2018, 2:48pm

Thank you Paul,
It helped a lot. We have found the issue but we will need some time to fix it. I will update on this on Monday.

Regards,
Karel

paul · July 3, 2018, 3:22pm

Hi @karel, any update on this? thanks!

karel · July 4, 2018, 2:39pm

Hi Paul,

Sorry to keep you waiting. We are hard working on the fix. It appeared much more complex than we expected.
Will Keep you updated.

karel · July 5, 2018, 9:34am

Hi @paul
Thank you for your patience. We have fixed the issue you referred. Please update to the latest version, and let me know, about the results

Regards,
Karel

sanastasi · August 7, 2018, 7:47pm

Hi, can this editable grid be used to facilitate workflow? It seems like no, but I wanted to check. If it could then it would fix on the biggest pains with Bubble which is creating a list of items for a user to select.

levon · August 8, 2018, 6:58am

can you bring an example of what you mean please?

bradf · August 8, 2018, 3:57pm

If I purchase this plugin, and create multiple sub-apps, do I have to buy the plugin for each app, or does 1 purchase cover my sub-apps?

levon · August 9, 2018, 8:20am

Good question, I will ask Bubble support and will update here

levon · August 9, 2018, 6:15pm

here is the answer from Bubble

It’s one plugin - one app. So if there are sub apps, since it’s a different app, the plugin should be acquired or subscribed. It’s the same logic as subscription-based plugins.

levon · October 15, 2018, 6:01am

We have just pushed an update that now supports fields which are a data type of another thing
For columns which are another data type you can indicate the data type and column from that data type that should be used in the grid using this syntaxis field1:datatype:field2, where field1 is from current data type, datatype is the linked table, and field2 is the field from the linked table that will be referenced

jeremy.shubert · June 6, 2021, 10:07pm

Is there a way to edit the column names that are visible to the user?

Ecaterina · June 8, 2021, 1:20pm

Hello, @jeremy.shubert
Thanks for your question.

If I understand you correctly, you are interested in renaming these fields:

Allow me to note that you can make it through plugin’s element:

In case you would like to know more about this plugin, please follow these steps:

test the plugin functionality/design by visiting its Live Demo page : https://zeroqode-demo-04.bubbleapps.io/editable_grids
make sure that you have checked the plugin description to investigate the structure and main setting points for the plugin settings:

image795×483 15.3 KB

Please let me know if any additional question will appear.
Best regards,