Hey everyone! I have another question for this amazing community. I made a loom video here explaining everything. I hope I was making sense in the video, just in case ill describe my end goal here as well.
I want to create a button that will show on the Details screen of each piece of content that will take the user to a page showing the social media of that specific content creator. So if this video was created by John Doe, I want the button to take the user to John Doe’s information. If it was created by Alex F, I want the button to take the user to Alex F’s information. And so on with multiple different creators.
With this route of just making a bunch of If statements, I fear that as I have many different creators, things can get messy. Another idea is have some sort of loop that sees the creator is John Doe and it goes through all the sheets until it finds one titled that same name. Then it will show that screen.
Why you have different tables for each user? You can add all users to the Users table and just have a table for videos and in that table you can add a email column to specify which user created that record! And then in the Users table you can create a relation between the email and show them on the screen.
When you click on the button and to go to that user’s details page you can build a relation that is single in that table ( videos ) and add that to row in the show detail screen or show new screen and then in there you can access the details of that user!
Thanks for that idea it makes much more sense to go that route.
I have separate tables because the content creators aren’t users. Users won’t be creating any content. But I altered this approach a little. Let me know what you think. I hope this helps others trying to accomplish the same thing or something very similar as well.
I created a sheet specifically for the content creators called Creators Social. Just a list of their social medias, followed by links to them, an icon correlating with the social media platform, then a text column titled Creator which includes on each line the name of that creator.
Then in a sheet called Videos, I have all the information for the video, again a text column titled Creator with that creators name. Then a relation Column with these details:
I think your approach won’t be efficient row-wise. If you want to simply show a list of social media links for the creator, you can create columns horizontally in the same Creators table, you don’t need to have a separate table for each one because it will be hell to maintain.
I had a custom code snippet from a while ago to help with that. Let me know if that works for you.
I thought maybe use the Split Text to separate everything. But it doesn’t seem to allow with a Relation Column.
It’s also giving me on screen problems. With everything being vertical, I was able to have columns labeled Icon and Platform. For each image shown on the front end I set it to the Icon Column and then for the text underneath each image it was set to Platform. So I would see a screen of tiles with their correlating icons and platform names. But with having it horizontal, I can’t do this.