hello, how to get the file id of retool storage in table event? It seem We can only get base64 data instead of fileId(I checked upload to retool storage)
I feel like I am missing something here. After uploading a photo automatically to Retool Storage, how do I get the storage URL for the uploaded photo so that it can be saved to the applicable record in the field where I uploaded the image (using the save handler)?
Hi @taylorsearle,
Thanks for reaching out! It's a good question. After doing some testing, it looks like we need a feature request to expose the Retool Storage information, in addition to the base64 of the image 
I am moving this feedback to a new feature request for tracking.
If you really need a workaround in the meantime, I think you could create a hacky solution where instead of automatically triggering a Storage upload, you trigger a Retool Storage upload query on change. Then, on success of that upload, you could store the url and row's primary key in a variable. You could merge the variable with the changeset on submit. That said, it would trigger on every change so you would need it to be conditional on whether a user actually selects an image. If they are removing an image, you'd need more custom logic to not upload anything to storage, and potentially, remove an image from the variable. You'd also need to have conditional logic for clearing the variable if the user cancel's their pending edits. Again, very hacky, so I'd love to hear from other users if they have found a better workaround and I'll follow up if we ship a solution
1 Like