Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Selecting documents from a library on a wordpress server

1516 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Robert_Wornan
4 - Data Explorer
4 - Data Explorer

Hi,

I want to allow a web user to select documents based on categories and be able to access them via their URLs.

I have two tables. Firstly, I have a Documents table which contains the name of the document, the URL, a long description and one or more categories. The categories are linked to a Categories table. The primary key is an auto generated sequential number.

The second table contains the list of categories. Categories is the primary key. There is also a field which is the link to the Documents table and contains links to the documents that contain this category. In airtable, if I click on this field, I get a list of all the documents related to this category. This is what I want.

My question is to know how to enable this selection of all documents of a chosen category on a web page. I assume I need some sort of view, but I can’t see how to implement a view that gets multiple records (read-only) from linked tables. Also, I’d like to have some control over how the data is presented.

Advice would be most appreciated.

Bob

0 Replies 0