Exploiting the database without slowing it down

I am curious about how your JSON string looks in Postman

The one I save looks perfectly normal in bubbles data/app data view.
When checking with Postman or the public API endpoint using chrome it looks like this.

image

That’s what happens when you put a JSON string into another one. The backslashes preserves the double quotes so when you extract the JSON from the other, it is still a valid JSON string.

1 Like

Hi, this is a great tool! In the example the list of components is static and the ‘update json’ can edit a row. Do you know the expression that would allow for adding/removing a row in the components list?

Sorry to ask question here. Are there ways for us non-tech/no-code users to inplement this? Doesn’t understand Json or JS yet

Love the post, and I do see it was made in April. For today’s bubblers you car try the “For Each” element under the Toolit Kit plug-in. It will allow you to achieve the copy functionality as it iterates through a list.

4 Likes

@hgm.business As configured, the JSON update can only edit existing rows. If you’d like users of your app to add/remove “components”, you’d need a function that adds an item to the JSON template + another one to remove item. It can be achieved with some basic javascript.

Currently the JSON template is saved as default value of a custom state in the element “ADD INSPECTION (grp)”. If you want to edit and save the template, you’ll have to save it in the database as a “thing”.

If you want to visualize the JSON template, copy/paste it here: https://jsonformatter.curiousconcept.com

1 Like

@shu.teopengco This post is a workaround the Bubble way to manage data; it’s a bunch of tweaks to save data into a single row.

There’s currently no 100% no-code solution. Sorry bud

1 Like

“No code”

1 Like

Which is a faster experience for the user? I have your plug-in, but am just now running across this post and like it’s solution since I’m experiencing the same issue.

Thanks for your feedback,
George