How do I save file-like data into the Adalo database? Blobs or buffers etc. The formValue seems to only be able to save one of these types: https://developers.adalo.com/api-reference/configuration/manifest-json/#type text, number, boolean, icon, color, date, list, action action may be the most pr…

Convert to base64. Something like Buffer.from(content).toString(“base64”) Should do it

That’s unfortunately poor compression, I’d rather store the binary data directly, and it seems like it should be supported since the database even has a File column datatype

As you pointed out in the component maker manifest, makers don’t have the ability to upload files. You can use the S3 service from @theadaloguy (I think it is his) or build your own component to store files in your own S3 bucket (or other file system). Otherwise base64 is the only option available t…

Thank you for the information. Do you happen to know how the built-in file Picker component works?

Yes, when you choose a file it posts to the adalo database endpoint which saves it to an S3 bucket with a random unique id and shows a preview using base64 encoding. Then when you save the record it will save the unique IDof the file in the database as text for future retrieval.

Why can’t a custom component do that?

Thank you. Where can I read the rules that are relevant to this part of Adalo? Do you know what action Adalo takes against developers that violate them?

I do not think there is any published guidelines, the only reason I know the limits is because I had a conversation with Adalo when I started releasing my components and my marketplace. The rules are that your component can only use what is in the API docs. There is no way to POST a file using the R…

In the video in this thread, how did you get Signature Phone > Signature Image to appear as an option in that menu?

How to save Blobs in database?

Get Help Database

TKOTC December 25, 2021, 7:12pm 8

It can technically, but building things outside of the developer docs is against the rules so accessing and posting file records is off-limits. But it is very possible if you know what you are doing as seen in the video in the post below

https://forum.adalo.com/t/every-new-beginning-comes-from-some-other-beginnings-end/20485/38

Topic		Replies	Views
Components can export Files to database Feature Requests open	0	3	December 26, 2021
Can we upload file from GDrive to Adalo database? Database	1	429	June 14, 2021
Possible to bulk upload images as part of records in Adalo database? Get Help	1	244	November 27, 2022
Make uploaded files sent to external storage External Collections, Custom Actions & Collections	4	1415	July 31, 2021
Other database for Adalo? Database	0	317	October 13, 2021

How to save Blobs in database?

Related topics