Hi there, i am new to softr and building my first client portal for our company (+80 employees).
I want to create a file library with documents, which are stored in airtable as attachment and linked to a specific contact (Name + E-Mailadress).
I designed a list in softr, where i want to show the attachment file name like “detailed drawing.pdf” and a button, where the client can view or download the file. The file name must be dynamic as the attachments are different from customer to customer.
The first problem I encountered is that I cannot access the file name of the attachment in airtable.
Someone knows how to fix it? 
Does it not work if you have a field type as Text and map it to the Airtable file field?
Alternatively
it works to extract one file, but it’s quiet difficult because we have more attachment files in a row.
To illustrate this, I have sketched out my idea here:
In Softr i want for each file a line with filename, cover media (i think it just work on jpg, png and not with pdf) and download link from Airtable.
I wonder if there is no better way to handle documents like in a library with softr
I can see that this will be difficult to achieve, and would certainly require a much more complex formula in Airtable to extract all file names per row at least.
I don’t know if you can consider your Airtable base to be extended, but one idea that comes to mind is to have a separate table of files, one file per row/record. Then you can have linked records between users and files (many to many). This would allow you more flexibility in Softr too, and you could more easily have one attachment per row with one button for download.
I second this. I think it would be best to have a table for Files, where each file has its name as a designated field for that record. So the schema would look like this:
- Users table
- Files table
a. User (relation)
b. File (attachment)
c. File Name (single line text OR formula)
d. Cover Media (url OR attachment)
If you want the file name to be editable, it should be single line text. But you could have the first iteration be the text version of the file name, which you can accomplish with an Airtable formula field.
1 Like
