Uploading pdfs to table

💬 App Building
1

Hello,

I am new to Retool and I couldn't find a resource/forum thread for the issue I have:

I created a form intake to append my table (works well) and would like to add a file upload (PDF) functionality so I can then easily store and retrieve PDFs from my table. Could you please indicate the steps to follow?

P.S: My Retool Storage query works (file is correctly uploaded) but can't manage to store the pdf url in my table

2

Welcome to the forum!
Have you read through the following:

3

Hi Scott,

Thanks for your message.

Yes I read through this Doc but I can't find a way to tie a pdf to a specific ID in my table to store it accordingly and later retrieve it if needed.

Let me know if that makes sense.

Thanks!

4

So you have yet to upload any files, or you have but cannot get the URL for each file in the table component?
Can you share some screenshots?

5

I am able to upload the file to Retool Storage but cannot get the URL for each file in the table component and make sure that each URL is tied to the right ID at form submission.

I shared 3 screenshots below including:

  1. Form + upload file query
  2. Table component + append data query
  3. Error message when I try to submit the form

Screenshot 2023-11-15 at 6.15.23 PM
Screenshot 2023-11-15 at 6.15.23 PM2902×1228 494 KB

Screenshot 2023-11-15 at 6.17.27 PM
Screenshot 2023-11-15 at 6.17.27 PM1920×840 132 KB

Screenshot 2023-11-15 at 6.21.45 PM
Screenshot 2023-11-15 at 6.21.45 PM1012×254 20.9 KB

6

What does the Data source look like used for the table?

7

It's a simple google sheet

8

I am sorry, I mean for the table component, if you are getting the data for the table from the sheet it will not contain the file information you uploaded into the Retool storage....assuming it was never there

9

Yes correct, I will also need to update existing rows with associated urls manually I suppose?

10

OK so still trying to understand.

  1. Get data from Google sheet and display it in table.
  2. Select row in table and populate form with selected row data and add a new field to upload an associated pdf with that row.
  3. When form is update...
    1. Is Google sheet updated with file name?
    2. Is file uploaded to retool storage?
  4. if 3.1 is true, then turning the name of the file in the table to a link can be done because there is a default link/file path as noted in the Retool docs I posted above.
  5. If 3.1 is not true... I need more information.... :slight_smile:
11

Yes flow is correct (3.1/3.2 included), do you happen to know how to generate this file name path?

12

Hey @ScottR, any idea? Alternatively, do you know someone we could add to this thread that could help? Thanks!

13

In the docs there is this:
your-org.retool.com/files assuming another backslash like /yourfileNameHere