Hi @Jeff_Hager , glad to hear you are well. Same here, working from home and going out for walks mainly to the grocery since we are officially in lockdown.
Following your suggestions, within the post’s detail page, I added a form button to submit a unique ID along with the user’s email to a sheet called “Favorite Form Response”. In the same sheet, I created a relational column that matches the user’s email from another sheet called “Profiles” which contains user specific data filtered by signed in user. Then, similar to your family reunion app, which is great by the way, I also created a “Choice” sheet to add the dynamic list filter categories, in this case “All” and “Favorites”.
At this point, I have 3 sheets (namely “Posts”, “Favorite Form Response” and “Choice” ) that need to somehow relate with each other in order for a signed-in user to see their favorite post using the dynamic list filter. So my question is: What exactly are the relational columns that I need to create and in which of the aforementioned sheets?
I feel by implementing these changes I should be able create my own version of favorites and I would very grateful for any further guidance you can provide me with.
Thank you Jeff and hope to hear from you soon