Connect Table to another

Ask for Help
1

Hi Glide brothers

I want to ask one question related to connecting 2 tables data.

In this example user will add client to the app with the form that will also have file picker in it.

questions:

1.How I can structure tables that way so that client can have multiple documents attached.

  1. How to structure tables that way so that each document have its own folder : (agreement doc on agreements folder, rules doc on rules folder)

  2. Must I add somehting o the table if I will let user to add missing docs later.

Thanks in advance guys

2

You should have 3 tables.

Users

RowID Email Name
a123 a@example.com Andy
b123 b@example.com Betty

Folders

RowID UserID Folder Name
fa123 a123 Andy’s Agreement
fb123 b123 Betty’s Rules

Files

RowID FolderID File Name File URL
fia123 fa123 Agreement 1 https://example.com/
fib123 fa123 Agreement 2 https://example.com/

The structure above means Andy will have a folder named Andy’s Agreement with 2 files: Agreement 1 & Agreement 2.

Betty will have a folder named Betty’s Rules with no files.

4 Likes
3

Great! Thank you very much!

Will that folder ID be created automatically, when adding files from app.

Is there any way to use multiple file picker and how to structure data in that case?

4

The FolderID is the rowID from the Folders table. It will be automatically created when you create a new folder, and when you add a file, make sure you use special values component to pass the folderID to the Files row.

For multiple files, do you want them to ultimately be on its own row in the Files folder, or a multiple file column in there will be ok as well?

5

great!

Two cases will work, just thinking that it will be more convenient to have it on the same row.

6

Then I think your File form can utilize a multiple file component, and write it to a multiple file column on the Files table.