FAQ

How do I make it so my table isn't editable?

Simply add "readOnly": true to your default column settings. See more on how to set default settings here.

How to hide all columns that aren't defined in the Column JSON

Set the default value of "type" to "hidden". This way, any columns that aren't defined here will not be shown in your table. Note: The fields will still be exported in the JSON, just not shown in the table.

What about hiding only specific columns?

Set the "type" to "hidden" for that specific column. See the columns sections here

How do I make it so only numbers are inputted?

Add a field for called "mask" and set it to "0". This make it so only numbers are able to be typed. See more options for masks here.

{
   "id": "amount",
   "header": "Amount",
   "type": "text",
   "mask": "0"
}

How do I enable a time picker on calendars?

To enable time, you'll need to add a field for "options". In these options, you can add "time" and set it to "true". You can explore other options for calendars here.

{
   "id": "date",
   "header": "Date",
   "type": "calendar",
   "options": {
      "time": true      
   }
}

Can I use this to create new data within bubble?

Yes! This was one of the main uses I made this for. Bubble allows you to send a list of json directly to their API in order to create new data. To do this, you'll want to set up a call in the API connector using the /bulk endpoint within your own app. Just make sure that the "id" in the column json matches the name of the field you want to add.

What about editing data?

Yes again! However, there's more involved with this one, so I made an example here. (View in the editor here)

First, you'll need to find a way to convert your bubble data into JSON data. There are plenty of plugins out there that will do this for you, such as jsoNest, however you can also do this yourself by using "formatted as text". You can see that in example I left above.

Next, you'll need to set up a way to make the edits. Bubble has a "patch" endpoint that will let you update the data using their API connector. You can send the JSON to that to make the edits.

Note: You may not want have this auto-update, since users may paste in multiple rows and change several items at a time. If this is the case, you may want to have a "save" button and send all the changes at once using a backend workflow.

When using masks, my "0" disappears

This is a bug, but can be fixed by enabling "Replace quotes in results".