Hi @Jeff_Hager thank you for taking the time to read and respond. I am fairly new to Glide and you are correct that I need to think in rows and not columns. I created a new sheet and app, to test you recommendation. The dynamic link, usign the relation, does not show all the Attendees.
The App idea is a Attendee App for a Coach, where the coach is able add Attendees/athletes when needed as well as creating Training Events when needed. When the training Event occurs, the coach can then click/check-box that the athlete is present at the training event. And this of course needs to be recorded for alter review. Hope this is possible with Glide. Here is the link to the basic app. Regards https://s2ioh.glideapp.io/
Whatâs not working? It looks correct to me. The only thing is your event tab is in detail view so it only shows the first event unless you have a filter, then it will show the first one that matches the filter. If you want to display all events, then change the tab to a list view and within the details of each list item, you can add the inline list relation of all attendees for each event.
Thank you Jeff, I updated the app and made some changes. I reviewed the documentation and cannot see how to implement the next step (âwhat is not workingâ) without some code/scripts.
When a new person/attendee is added, with the current structure, the attendee needs to be duplicated in the âPeopleâ sheet for each event (linking the People and Event sheet) meaning a lot of records for each person linking to every weekly training event. I do not see an option in glide to do this when a new person/attendee is added.
You would most likely need to use some sort of script to do this automatically. It would have to loop through all of the Events with an inner loop of all the attendees, then check if a record already exists. If not, add a new row. I canât think of a way to do it naively within Glide. You could kind of do it with formulas in the sheet, but any time a new event or attendee is added, then none of the checkboxes would line up
This would go in the first column of a new sheet. =transpose(split(concatenate(arrayformula(split(rept(unique('Events'!A2:A) & "\|", countif('Attendees'!A2:A ,"<>")),"|"))),"\"))
This would go in the second column. =transpose(split(rept(concatenate(arrayformula(transpose(arrayformula(unique('Attendees'!A2:A) & if(isblank(unique('Attendees'!A2:A)),"","\"))))),countif('Events'!A2:A ,"<>")),"\"))
This third column would hold the checkbox value, but like I said, nothing would line up once an additional event or attendee is added and the formulas above recalculate to add the new records intermixed with the rest of the existing records.