I have a couple of photo uploaders in my app and it's being uploaded to the root folder of retool storage. What do I need to do to:
- Make image capture upload to a folder.
- Move everything referenced in the table to a folder.
Cheers.
Hi @Scottsky!
For #1, here is a working example:
#2. Do you mean moving what has already been uploaded to the root, to an specific folder?
Correct, @Paulo. I gave the app to itchy trigger finger scientists. And they logged valuable data in to a proof of concept app. I dumped the CSV so nothing gets lost. But now I have to dance around this chunk of data and images associated with it like I care. So basically yea, goal is to moving a bunch of records I have a table with to a folder.
There is a Retool Storage action to 'Move a file to another folder.' If on that table, you have the ids of each object that is at the root, we should be able to move them to the desired folder.
For example:
I have this file at the root of my Retool Storage with the id of 1bc16b1c-3380-4695-b6fe-165b79cca32b
Here is the Resource query that will move the file to the desired folder ('folder1'):
Note: I set up the query to assign the value of
test through 'additionalScope.'
Finally, here is the JS that does the magic. We are triggering the 'moveFolders' query and passing the id using 'additionalScope':
Worked like a charm:
In your case, we'll just have to iterate over the ids you have, and for each id, trigger the Retool Storage query to move the object with that id. We can also add conditionals to move only files 'createdAt' some point in time, have a specific file extension, name, etc.