My app’s URL: https://go.glideapps.com/app/2NfKjUxV1G2vinRSh1zR
Hi,
When I add new columns to my spreadsheet, I would expect the app to add in new components for that data, but it doesn’t.
The app in question is one for attendance. When I add new people, I get the option to add new components, but nothing happens. I would like this to happen automatically as I don’t want to have to update the app every time someone leaves or joins the team.
Any ideas whats going wrong?
Thanks,
Dave
Glide will create components the very first time just to get you started. It will not create additional components or tabs after that because Glide has no way of knowing what you want after you have started designing and making changes to your app. I don’t use the “automatically add new components” button, because I have no idea what the results will be or what it will even add. I want the control to know which components I’m adding or removing.
If you are you making changes to your data layout that often, you should really reconsider how your data is set up. Once your columns are set, you should never have to change them very often. What should be changing is the rows. That’s how databases work. It looks like you have a checklist. Your sheet should have 1 column for name and 1 column for True/False and maybe 1 column for date. Then you can use an inline list with the checklist layout to get the exact same function your screenshot shows. That way you can add or remove rows without ever having to touch the app builder to add or remove components.
Hi Jeff,
Thanks for your reply.
My app is a clone of the sample Attendance app.
I agree re not having to change the app for additional data and this is what I am trying to achieve.
What I want is to be able to add extra people to record their attendance without impacting on the app.
I tried set up the data as you suggested, (see tab A2) and this doesn’t work as it doesn’t allow it to store a T/F against each date for each person.
I tried set it up transposed (see tab A3) which didn’t work for me either
The original functionality (the sample app) works best, but needs extra members set up as coulmns, which doesn’t work.
Any further suggestions?
Thanks,
Dave
I can’t see your app so I can’t see the tabs you are talking about. Go into your app settings, publish the app, and then share the url from there. It should look like xxxx.glideapp.io.
Done
I was thinking more like your A2 tab. This would require 2 sheets. One with just the unique dates, and the second like you have in A2. On the Dates sheet create a relation to link the date from the dates sheet to the date in the A2 sheet. The sheet with the dates would be the tab where you select the date. Once you click on the date, you will see the details for the date. This is where you can create an inline list using the relation and viewing as a checklist to show of the the names with a checkbox.
Another option is to just stick with the A2 sheet by itself and set a filter to only only show names where the date column is within Today.
There are a lot of ways to do this, so it’s pretty much your preference. My idea is going to create a lot of extra rows and exceed the free row limit pretty quick. Your original attendance tab is the most efficient, but you’ll have the problem with adding and removing names. If you wanted to get really crazy, you could create a column for name and a column for true/false and repeat several times in the sheet. You could then use the rich text component to show the name column value as a heading and then a checkbox component to record attendance in the true/false column. This won’t look as good though and may be a lot of work.
Thanks Jeff.
I will give those ideas a try.
I am just trying out glide for the first time today, to see how useful it is.
Thanks for your help
Dave
