Download Retool storage file with same name as selected row column

💬 App Building
1

Hello,

I’d like to use the value of newOrders.selectedRow.orderID (Smith_00006) to download a file with the same name from Retool storage by clicking on the entry. I tried to follow this thread but didn’t get too far:

Any help is much appreciated!

Thanks,

Dylan

image
image2804×1312 424 KB

2

I was able to get the File ID with the JS query below after geting the Metadata from Retool Storage.

const selectedOrderID = newOrders.selectedRow?.orderID;
if (!selectedOrderID) return null;

const matchedFile = getFileMetadata.data.find(file => file.name === ${selectedOrderID}.xlsx);
return matchedFile?.id || null;

image
image2762×1152 305 KB

3

Thanks for sharing this update, @DylanSeq! Glad to hear you got it working. :+1: