# ✏️ Editable Tables with Formulas / Online Spreadsheet **URL:** \ **Category:** Plugins\ **Created:** [May 7, 2021, 11:11am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132 "2021-05-07T11:11:48Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [May 7, 2021, 11:11am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/1 "2021-05-07T11:11:48Z")
> Online spreadsheet / Excel like tables for Bubble supporting formulas and multiple data types ✏ Check the demo pages to see it in action! 🔥 Easy to use plugin with advanced settings: - Can be used like a static read-only or editable table - Create professional Excel-like and Google Sheets-like spreadsheets - Formulas support - Powerful cells. It can contain text, html, number, image, checkbox, radio button, dropdown, calendar… - Cells HTML code support - Export data to CSV - Context menu support - Dynamically add / remove column and rows - Columns reordering - Responsive table automatically adapts to any screen size - Sorting, Searching, Pagination and more! 🔗 Demo 1 (Data Types & Formulas): [Demo](https://editable.bubbleapps.io/version-test) | [Editor](https://bubble.io/page?type=page&name=index&id=editable&tab=tabs-1) 🔗 Demo 2 (Spreadsheet like Google Sheets / Excel): [Demo](https://editable.bubbleapps.io/version-test/spreadsheet) | [Editor](https://bubble.io/page?type=page&name=spreadsheet&id=editable&tab=tabs-1) 🔗 Plugin Page: > **[Editable Table Pro / Excel like Plugin for Bubble, by Digital Eye](https://bubble.io/plugin/editable-table-pro--excel-like-1619298395010x967154588765126700)** > > Editable Table Pro / Excel like Plugin page on Bubble, by Digital Eye. Add Editable Table Pro / Excel like in one click to your app. Bubble lets you build web apps without any code. 📚 [Full Description, Documentation & Screenshots](https://bubble.digital-bird.com/plugins/editable) Feel free to post your questions, feature requests and bug reports 🐛 here! ![Advanced_Editable_Tables](https://us1.discourse-cdn.com/bubble/original/3X/d/a/da375d2846906388ab6262908724990638cffd3e.jpeg) ![8bda62353631a779d5558208b1ef41a25f0ccf2f_2_1378x578](https://us1.discourse-cdn.com/bubble/original/3X/5/8/58b4fb5c514c3999049f6fa11fea46fe637d58da.jpeg) ---
**Author:** ![jared.gibb](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jared.gibb/32/123329_2.png) [@jared.gibb](https://forum.bubble.io/u/jared.gibb)\ **Post date:** [May 7, 2021, 11:13am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/2 "2021-05-07T11:13:16Z")
Nice work Sam! ---
**Author:** ![kevonmayers31](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/kevonmayers31/32/93971_2.png) [@kevonmayers31](https://forum.bubble.io/u/kevonmayers31)\ **Post date:** [May 10, 2021, 3:42am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/3 "2021-05-10T03:42:42Z")
Can you show an example of a workflow to update the database with the edited information for the corresponding cells? I went to the editor for demo 1, but there is no workflow that does that. Also, could you explain the deletion process for rows? ---
**Author:** ![kevonmayers31](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/kevonmayers31/32/93971_2.png) [@kevonmayers31](https://forum.bubble.io/u/kevonmayers31)\ **Post date:** [May 10, 2021, 6:21am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/4 "2021-05-10T06:21:52Z")
I am also running into issues when using data types other than string. Attaching screenshots to hopefully help narrow down the issue. When trying to have a number field shown for example, the cell value is blank, and a column labeled “A” is shown to the left of it. Here is what it looks like: ![zip-number-issue](https://us1.discourse-cdn.com/bubble/original/3X/2/c/2ce556685f43469808babfacdf5612252de9d62d.png) I tested with string data types, and those work. This is an example with the same data (multiple records this time), but the data type is a string instead of a number: ![zip-string-working](https://us1.discourse-cdn.com/bubble/original/3X/c/6/c698dfd79e1be92654fcf21a066ea6a85eddafce.png) Still though, every time the page loads, I still see the column labeled “A” momentarily, then only the string based data/column label appears. For images, it just give the s3 file path, and doesn’t show an image. This is an example of that: ![s3-filepath](https://us1.discourse-cdn.com/bubble/original/3X/6/4/64a3a4ce4431d0969d8d13255deda8837a7e41bd.png) Here are screenshots of the workflows and data types for the “Zip” number record, and also the “Zip” string record. It may also be good to note that I tried on multiple tables and the same issue was happening for some reason. **Zip** - string data type ![zip-string-field-type](https://us1.discourse-cdn.com/bubble/original/3X/c/b/cb4dec04c4df69a9d55e145a9d2ca849e08c4665.png) Corresponding workflow: ![zip-string-workflow](https://us1.discourse-cdn.com/bubble/original/3X/2/f/2ff1f7e5aadfd390e0d02c5dec880ff67e3f62a7.png) **Zip** - number data type: ![zip-number-field-type](https://us1.discourse-cdn.com/bubble/original/3X/1/7/17e1f3a4dcd1cd5b4056f9fbd7678a1ca1fa504b.png) **Zip** - number workflow ![zip-number-workflow](https://us1.discourse-cdn.com/bubble/original/3X/9/5/950e0e391c9ecee7a8b2779ca81755b730bbfd51.png) I’d appreciate any guidance you can provide. Kevon ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [May 10, 2021, 9:33am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/5 "2021-05-10T09:33:28Z")
Here is a small example updating the database: [Demo](https://editable.bubbleapps.io/version-test/demo1) | [Editor](https://bubble.io/page?type=page&name=demo1&id=editable&tab=tabs-1) The database table has 2 fields: zip\_text and zip\_number: ![Editable___Bubble_Editor](https://us1.discourse-cdn.com/bubble/original/3X/6/2/62d4caf6e59f2e44c5148506cd6e7d38053d4848.jpeg) In the table we are also using 2 column types: text and number: ![Your_Bubble_app](https://us1.discourse-cdn.com/bubble/original/3X/9/4/94c8b6a7903c33b5f8ce32ca6874cc6a1cd13876.jpeg) Once an event of type “cell edited” triggers, we are ready to update our database using plugin’s shared states (edited\_value, edited\_col\_id and edited\_record\_id): ![Editable___Bubble_Editor](https://us1.discourse-cdn.com/bubble/original/3X/2/c/2c464ff54d46843cb59f9e99cbda2f35c935a260.jpeg) PS Please make sure to update the plugin to the latest version if it’s not done yet as a small bug has been fixed. ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [May 10, 2021, 9:35am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/6 "2021-05-10T09:35:50Z")
Regarding the image issue, are you inserting a column of type “image” or “text” ? ---
**Author:** ![lottemint.md](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/lottemint.md/32/26549_2.png) [@lottemint.md](https://forum.bubble.io/u/lottemint.md)\ **Post date:** [May 10, 2021, 11:21am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/7 "2021-05-10T11:21:27Z")
@BubbleSam It looks nice! If you are looking for an auto-refresh solution, please have a look at the below links. Video: [https://s3.amazonaws.com/appforest\_uf/f1620645289769x584170794830219800/excel\_001.mp4](https://s3.amazonaws.com/appforest_uf/f1620645289769x584170794830219800/excel_001.mp4) Editor: > **[Bubble Editor - Just4tests8](https://bubble.io/page?type=page&name=excel&id=just4tests8&tab=tabs-1)** > > Build stuff without code and launch a startup without a tech-cofounder! Bubble is a visual programing language. Instead of typing code, use a visual editor to build applications. Preview: [https://just4tests8.bubbleapps.io/version-test/excel](https://just4tests8.bubbleapps.io/version-test/excel) username password So, if a thing was updated, created, or deleted by someone else, the workflow automatically sets a new source. It might be helpful if you add the Output type of a thing here. So, you can make a change directly without doing a search. It will work faster. ![image](https://us1.discourse-cdn.com/bubble/original/3X/a/3/a355ccdbcb7c9243c601f72a18eba0d98fd28fb1.png) ![image](https://us1.discourse-cdn.com/bubble/original/3X/0/a/0a8f991af7061dfa65e18eb4ec117c1ea21ecb9c.png) ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [May 10, 2021, 12:33pm UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/8 "2021-05-10T12:33:34Z")
> [@lottemint.md](#): > > If you are looking for an auto-refresh solution, please have a look at the below links. That’s a great advice! Thank you for sharing this!! > [@lottemint.md](#): > > It might be helpful if you add the Output type of a thing here. So, you can make a change directly without doing a search. It will work faster. I agree with you on this point and this approach was my first idea. However I chose to populate the table column by column and probably from different database tables (or even calculated data based on other data) to have a more flexible approach. ---
**Author:** ![mr9sky](https://avatars.discourse-cdn.com/v4/letter/m/7feea3/32.png) [@mr9sky](https://forum.bubble.io/u/mr9sky)\ **Post date:** [June 25, 2021, 2:51am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/9 "2021-06-25T02:51:12Z")
With this, we can now create Airtable in Bubble now 😛 ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [June 25, 2021, 9:20am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/10 "2021-06-25T09:20:31Z")
Yep, it should be possible, with some limitations 😉 ---
**Author:** ![ahmed](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@ahmed](https://forum.bubble.io/u/ahmed)\ **Post date:** [July 4, 2021, 2:46pm UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/11 "2021-07-04T14:46:49Z")
can we get custom formula ? ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [July 4, 2021, 4:33pm UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/12 "2021-07-04T16:33:31Z")
Hi Ahmed, Here is the list of supported formulas: [https://bubble.digital-bird.com/plugins/editable#special-formulas](https://bubble.digital-bird.com/plugins/editable#special-formulas) Do you need something else? ---
**Author:** ![MrMaker](https://avatars.discourse-cdn.com/v4/letter/m/97f17d/32.png) [@MrMaker](https://forum.bubble.io/u/MrMaker)\ **Post date:** [July 6, 2021, 4:36pm UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/13 "2021-07-06T16:36:34Z")
I want to make my own custom formulas by adding a function or formula name and specify the URL API or a local formula using the JS formula plugin functions are able to take input/ inputs and return output every cell has content and actual evaluation I can pass a dynamic list of inputs (A, B1:Bx, C1:) I can get status if I am trying to drag a formula (when button drag formula is dragged vertical vs Horizontal) I can change the input of the formula slightly based on current cell , current column. ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [July 7, 2021, 8:21am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/14 "2021-07-07T08:21:00Z")
Hi there @MrMaker , In that case, plugin should store somewhere your formula name, formula handler and execute custom formulas. This is a very complex case and unfortunately it’s not currently supported. ---
**Author:** ![Rolder](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/rolder/32/148186_2.png) [@Rolder](https://forum.bubble.io/u/Rolder)\ **Post date:** [July 12, 2021, 4:21am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/16 "2021-07-12T04:21:07Z")
Hi @BubbleSam, I have been looking for a long time for a plugin that will help my users insert tables. Yours looks like it hits the target 🙂 But I can’t figure out how to add new things to the database. I can create them, but I can’t write data from the table to new things. I can’t figure out how to do this, help me 😨 ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [July 12, 2021, 8:25am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/17 "2021-07-12T08:25:18Z")
Hi @Rolder , Thank you for your feedback and question! I think you want to do something similar to our Demo 2? 🔗 Demo 2 (Spreadsheet like Google Sheets / Excel): [Demo](https://editable.bubbleapps.io/version-test/spreadsheet) | [Editor](https://bubble.io/page?type=page&name=spreadsheet&id=editable&tab=tabs-1) Please check out the Editor / Workflow and I hope it will be helpful! 😉 ---
**Author:** ![Rolder](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/rolder/32/148186_2.png) [@Rolder](https://forum.bubble.io/u/Rolder)\ **Post date:** [July 17, 2021, 10:54am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/18 "2021-07-17T10:54:54Z")
Thank you, I just managed what I was looking for. There is only one nuance left: ![table](https://us1.discourse-cdn.com/bubble/original/3X/c/a/cae2ff8012250f0c0e6dd635a02cc7025336876f.png) Is it possible to fix it through CSS or JS? ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [July 18, 2021, 7:27am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/19 "2021-07-18T07:27:08Z")
Hi @Rolder , Are you talking about bottom buttons? I think it should be possible to fix. Probably I can help you if you could share a demo page repeating the issue ---
**Author:** ![jeremy.shubert](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jeremy.shubert](https://forum.bubble.io/u/jeremy.shubert)\ **Post date:** [July 19, 2021, 3:52am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/20 "2021-07-19T03:52:07Z")
Great plugin, I have been getting this error recently: The plugin Editable Table Pro / Excel like / action Add column: Numeric a Editable Table threw the following error: jexcel/obj.createCellHeader@[https://dd7tel2830j4w.cloudfront.net/f1620166158622x557830045438484350/jexcel.min.js:1:21155](https://dd7tel2830j4w.cloudfront.net/f1620166158622x557830045438484350/jexcel.min.js:1:21155) jexcel/obj.insertColumn@[https://dd7tel2830j4w.cloudfront.net/f1620166158622x557830045438484350/jexcel.min.js:1:63040](https://dd7tel2830j4w.cloudfront.net/f1620166158622x557830045438484350/jexcel.min.js:1:63040) anonymous/instance.data.insertColumn@PLUGIN\_Editable-Table-Pro—Excel-like-initialize–Editable-Table-.js:198:29 (please report this to the plugin author) ---
**Author:** ![jeremy.shubert](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jeremy.shubert](https://forum.bubble.io/u/jeremy.shubert)\ **Post date:** [July 19, 2021, 4:13am UTC](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132/21 "2021-07-19T04:13:46Z")
I’m creating a Dropdown column, it appears that only the first value in option set will show up. I have data in the database, three different option set values. The dropdown column is empty for all rows except where the database value is the first option set. I can change the order of the values in my option set and the new first option set value will be the only entries to display. [Next page](https://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132.md?page=2)