✏️ Editable Tables with Formulas / Online Spreadsheet

@BubbleSam

I did it and it did not work. Check :

that is what I am getting. Here is the workflow:

I am wondering why I can enter 2% directly in the cell? When I enter that, I get 200% after page refresh. Bug???

Hi, can we configure/change the language for the buttons : Search, Show, Entries, etc. ? Thanks

Hi @BubbleSam,

Question, super simple example… can I do the following with this plug in?

Column A = An API call that returns prices of something. Every cell in Column A would have a price.

Column B = Simple formula to do some math on the price to the cell on the left (maybe Price x 2).

Can I then reference a specific cell and place it in a custom state? Such as Cell B4?
In other words, "take the value in cell B4 and put it in the following Custom State… “name”

The equations in all of Column B would remain the same always, but the data that populates into Column A would change and come in from an API call.

Can we do this and can you show an example? Thinking about purchasing.

Thanks,
Danstrong text

Hi,

Is there a way to allow the user to create a bunch of changes, and have a “save” button that sends all of the changes at the same time to an API endpoint?

I need a way to send the state of the table to an endpoint (hopefully in json format).
I thought about using the CSV output (capture it in the workflow, and send it to an endpoint), but it goes directly to the browser.

When trying to insert a column of numbers, I get the following error message, how can I resolve this?

Screenshot_1

Hi @rein Can you share the solution?

Hi all! I would like to diplslay numbers in a cell with thousand separator. How would you perform that?

10000000 > 1 000 000

Thanks!

1 Like

Hi, Nice plugin, I was wondering i saw you published the data value, and it published the data but shows the formula instead of calculated value, any chance you can publish the calculated value ?

Hey @BubbleSam !

I have problems with formulas and storing the result of the calculation. Maybe you can help :slight_smile:

The first one is that “=21,5" doesn’t work but "=21.5” does. Is there a workaround to handle “.” decimal based numbers?

The second one is more complexe:
I’m trying to save the result of “=2*1.5” in a database. When I press enter I have the proper number in the cell “3” but this is not what it is saved in the database. What is saved is the formula without all characters. In this case it would be “21.5”.

Here are the workflows and screenshots to help you understand:

The workflow:

The formula:
Capture d’écran 2023-07-06 à 10.06.56

The result after I press enter:
Capture d’écran 2023-07-06 à 10.07.27

The same cell after I refresh the page:
Capture d’écran 2023-07-06 à 10.07.38

I understand that the cell value is the formula as text to re run the formula each time we run the page. Is there a way to retrieve the calculated value instead? I need to retrieve only numbers for further calculations.

Thanks :wink:

I’m having the same problem. Did you ever resolve it?

@BubbleSam I don’t seem to be able to get around this. It could be a Bubble update breaking the flow. Can you please let us know what to do?

In my case, I found that most of these errors were due to the data I was inserting into the column being empty. I got around this problem by replacing blank data with the number “zero”.

Greetings

I bought the “Editable Table Pro / Excel like” plugin and reading the documentation, I didn’t find information on some topics and I would be grateful for some clarifications:

1 - Is it possible to change the font and size of the cell content?

2 - I live in Brazil, and the most used decimal separator here is the comma (“”,“) and not the period (”."), is it possible to choose the separator for decimals and thousands?

3 - I would like to limit the number of decimal places that appear in a cell, is this possible?

4 - When a cell has a formula, I noticed that in the database, the saved value is the formula string (“=A1*B1”, for example), but I would like to access the values ​​that are being shown, is there a way to take all the data in a column (converted to the number that appears in the cell) and add them, because I need to save this value in another entity in the database?

5 - I would like to create a formula bar (like in Excel), for this, the plugin would only need to have a “selected cell value” state so that I could show this value in an input. However, I haven’t found a way to do this, is it possible?

I’m having the same problem. Did you ever resolve it?

I’m having the same error when executing the “Add column: text editab” action, were you able to resolve it?

Hi, I’ve designed a very simple sheet for now with two columns, one of which is editable. The issue is that when I update any value in the editable column it’s not updating in my database… following a bit more research and using your demo example, it seems the edited_record_id isn’t being populated when I edit the cell.

Am I doing something wrong?

Thank you

Debbie

A second question - someone in the reviews (not on the forum that I can see) mentioned the ability to copy a range of cells from Excel and paste them in here, but it’s not clear what the workflow should be for them all to be updated. Can you point me in the right direction? Thank you!

Hi there,

We’ve been using the following plugin from Digital Eye: Editable table pro like excel (https://bubble.io/plugin/editable-table-pro--excel-like-1619298395010x967154588765126700)

The error is pasted below, but it doesn’t occur every time. The pattern is as follows:

  • The user clicks on an element which triggers the plugin to create a table with 20 rows (only 1 column) which lists some text
  • Often/most of the time the plugin then sends the error…
  • However if the user refreshes the page, and does the same action of clicking on the element, then it works perfectly fine and the table shows the 20 rows without any issue.
  • So in conclusion it always bugs on the first try and never on following tries…

I wrote to the plugin editor (Digital Bird) but they asked us to post the question here. Any help would be very appreciated!

Error Bubble plugin

@BubbleSam for visibility (unsure whether you saw this yet!)
Appreciate any help you can provide :pray:

@BubbleSam Checking in on this - any help you can share as to why the plugin is causing this error would be appreciated.