How can we store Rich Text Editor's content From Bubble.io to XANO.

Pratik Adhane

I'm using bubble for frontend and through api i want to post data to XANO. I am using Rich Text Editor for Messaging we can say.
I'm not able to figure out how can we store that Rich Text Editor Content from Bubble to XANO.

Pawel Magdanski

Hi,

Not sure if i understand correctly? You mean how to store the text along with the formatting from the frontend?

Pratik Adhane

Hey Pawel, Thank you for reply.

Definitely this is what i ment. Text along with formating, Images etc.

Pawel Magdanski

Ok,

So if you save the text in Xano with the formatting performed in bubble for example:

Where the "formatted" is bold then Bubble should read when you send it back from Xano.

Did you encountered an issue with that?

Pratik Adhane

Let me clear more,
I install Rich text editor in bubble and i'm posting content using that rich text editor.
Sending attachment please have look of it.In Bubble its working fine

CapturePost.PNG

DBContent.PNG

This is how bubble database handle it automatically.

Pawel Magdanski

So if you send this texts to Xano and then return them to Bubble, I think they should work. Are they not right now?

Pratik Adhane

Hey Pawel, Sorry for late reply.
I did not try that yet, i'm confused what data type should i set to the column for storing this content in XANO .

Pawel Magdanski

I would just use text data type and give it a try.

Pratik Adhane

Thank you so much Pawel for your valuable time.
I'm able to store Rich Text Editor's data into XANO.

but only issue i'm facing is while fetching that data i'm not getting stored image in bubble any idea about that?

Pawel Magdanski

Can you show me how are you saving the image in Xano?

Pratik Adhane

Sure, sending attached image of database table.

MicrosoftTeams-image (3).png

Pawel Magdanski

Ok,

I see know so you are storing images urls' withing your text. That might not work. I think you should store the images separately from the plain text in Xano and use image element in bubble to to display them when you are fetching the data.

Pratik Adhane

How we can store image and text content separately using Rich text editor ?

Pawel Magdanski

Well I need to know a bit more about what you are trying to do to offer some more adequate solution.

Can you show me how it looks like in Bubble?

Pratik Adhane

Sure, sending attachment how bubble stores Rich Text Editors content.
In given attachment highlighted column stores image and text in same column.

bub_img_db.PNG

Pawel Magdanski

And if you are sending this rich text backto Bubble from Xano the images are not working, right?

Pratik Adhane

Yahh, right

Pawel Magdanski

Since you are sending it in the exactly same form and it works before you save it to Xano, I think it might be a Bubble issue.

Pratik Adhane

Ok Pawel, Thank you so much for your valuable time.🙂