How do I allow users to save social media in folders on my app? They can default to private, but change to public if preferred. Like videos, images, documents, etc., in the same folder. Folders within folders for organizing. Hashtags to find stuff later. Date saved. I want to filter by social media type, like Facebook, Instagram, TikTok, etc. Sort by most-recent saved, etc. Thanks.
1 Like
Hereās a sample Glide data structure for folders, assuming just one subfolder level, using IDs for relations.
Users Table
| ID | Name | |
|---|---|---|
| U001 | Kelly Dunn | kelly@email.com |
Folders Table
| ID | Name | OwnerID | IsPublic | DateCreated |
|---|---|---|---|---|
| F001 | Travel | U001 | FALSE | 2024-07-09 |
| F002 | Food | U001 | TRUE | 2024-07-09 |
Subfolders Table
| ID | Name | ParentFolderID | IsPublic | DateCreated |
|---|---|---|---|---|
| S001 | Paris Trip | F001 | FALSE | 2024-07-09 |
| S002 | Museums | F001 | FALSE | 2024-07-09 |
| S003 | Street Food | F002 | TRUE | 2024-07-09 |
- āā ParentFolderIDā links each subfolder to its parent folder.
- No subfolders within subfolders.
Media Table
| ID | FolderID | SubfolderID | Type | URL | DateSaved | IsPublic | Hashtags | Source |
|---|---|---|---|---|---|---|---|---|
| M001 | F001 | S001 | Image | https://imgur.com/abc.jpg | 2024-07-09 | FALSE | #Eiffel,#Paris | |
| M002 | F002 | S003 | Video | https://youtu.be/xyz | 2024-07-09 | TRUE | #Pho,#Vietnam | |
| M003 | F001 | Document | Microsoft Learn: Build skills that open doors in your career | 2024-07-09 | FALSE | #Itinerary | TikTok |
- Media can be saved directly in a folder (leave āā SubfolderIDā blank) or in a subfolder.
- Ownership is always traceable via the parent folder.
Hashtags Table (Optional)
| ID | Tag |
|---|---|
| H001 | #Eiffel |
| H002 | #Paris |
| H003 | #Pho |
3 Likes
After creating the Tables, how do I set up the Layout?
Do you have a visualized version of how you want to present them? You can just use a new tab with a Custom layout and add a collection, then play around to see what you like.