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?
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:
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:
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:
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.
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):
That’s a great advice! Thank you for sharing this!!
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.
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.
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.
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
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
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.
Easy to use plugin with advanced settings:
Demo 1 (Data Types & Formulas): Demo | Editor
Full Description, Documentation & Screenshots
here!
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 
Demo 2 (Spreadsheet like Google Sheets / Excel): 