What is the file type? Are you only working with images? What is the column type of "FileUP"?
When does FileUploadSupp get triggered? It looks like the file is uploaded via one of our upload components, which triggers the submitToAudt_database query
It may not be relevant for images, but if you're uploading a file with text and only want to pass some text to a database, you may want to try toggling on 'parse files' from the upload component, which will create a property with the file's content
Hi @Tess Thank you for getting back to me as soon as you could.
I want to upload all kind of files like excel,images and text files.
My column for FileUp is Varbinary(MAX).
It gets triggered once a user chooses the type of files they would like to upload for approval and clicks submit that's when the desired file will be saved in a database.
Thanks for these details. I don't have a ton of experience with MSSQL's varbinary type, but I used the second response in this external post to get this working. I hope it helps!
I also checked internally & saw that we have a feature request for making it easier to work with Varbinary data in Retool. Hopefully, that is something we can ship in the future to make this more intuitive!
1) Insert file from fileButton component. In this case, I am using an image.
2) Query that file in Retool. If needed, convert the file into base64 in order to display the uploaded image in an image component: