Auto add column with check box on attendence app

Hi all,

Could not find an answer in previous posts so asking here.
I have a customer using attendence app based on the template but with changes. He connected a Google form that allow users to add themselves to the list and than they auto added as columns using transpose formula.

The problem is that when they are added they actually created as new columns on the attendees sheet so golden doesn’t recognize them and they are not showing in the app (basically I need glide to auto add a checkbox column to each new column is this sheet).

Is here a way to do this automatically without needing to go to the editor and add each new attended manually?

Thanks!

Glide is unable to handle column names dynamically added or changed using transpose. The editor needs to reload the sheet to get the new columns and create new components. This does not happen automatically. The only way I can think of would be to instead create rows for each user, then create an new column to use for a switch or checkbox. Unfortunately you would have to then open each user in a list to check the box or flip the switch. This could control an image, so you could see a :heavy_check_mark: or :x: in the list. Not a great solution but what’s possible with what’s available. Ideally I think it would help to have a type of inline list that would consist of checkboxes. I don’t know of a good way to have a dynamic list of checkboxes on the same screen though.

Hi @Jeff_Hager, thanks for the answer.
Unfortunately this will not be a good solution as I will need to create hundreds of columns for the dates in which we have the classes scheduled… And it won’t work with calendar view as well

When you say “attendance app based on the template” do you mean that there is a template to copy from. I can’t visualize the structure of the spreadsheet from your question. If it is a Glide template can you give me a link to it?

I assume it’s this template.

Exactly @Jeff_Hager
The different is that the users use Google form to enter their name into the app which than using transpose formula move as new columns to the attendance sheet

Thanks, now I see the problem. I wouldn’t have written the app this way if I knew that the possible number and names of the attendees were not relatively fixed. Doing it the way the template is doing it does limit the number of possible attendees, and as evidenced by this issue, requires someone to change the app in the builder each time a new potential attendee is needed.

I would have most likely created at least 3 sheets; Names; Events; Attendees but would need more info about the actual usage to really think about the layout and how to dynamically add new names to the list of possible attendees.

1 Like

As I said the use case is simple.
Training classes which happen once a week every week.
The trainees add themselves using Google form to a sheet called participants, then, they are added to the sheet with the checkbox using transpose.
The trainer mark everyone that arrive to to the training himself.

Can’t really follow the idea you’re suggesting as how to hange the app

No problem if it’s working for you with the current process, then no need to rethink it.

It’s not working as the trainer to go into the editor and manually add every trainee that join with additional checkbox component.
If you have better idea I’ll be very happy to here how to automize this

Look at State Plates in https://dgmfc.glideapp.io/

That’s about my best idea for a dynamic checklist

I thought about doing something like that but that mean that you need to go into every trainee that come to the training and mark him instead of having a screen where you see all and check relevant ones :crazy_face:

1 Like