# Help with a scheduling app **URL:** \ **Category:** Ask for Help\ **Created:** [December 28, 2023, 4:46pm UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071 "2023-12-28T16:46:10Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![FelipeMilian](https://avatars.discourse-cdn.com/v4/letter/f/4af34b/32.png) [@FelipeMilian](https://community.glideapps.com/u/FelipeMilian)\ **Post date:** [December 28, 2023, 4:46pm UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071/1 "2023-12-28T16:46:10Z")
Hello, greetings. I’m creating an application for scheduling the vehicles of the company I work for, in this case we have 03 identical cars, and to schedule the user has to select a date, a time and finally the car. The logic of the application is that when the user selects the date and time, there is a filter that consults a table where we already have some appointments completed, so users will not be able to select the same car for the same day and the same time. I’m technically blocked in this part, I can’t create logic in the tables so that there is this filter, so that when the user completes a booking, the car they selected does not appear to other users on the same date and time. I would be grateful for any kind of help. Thanks. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 28, 2023, 4:50pm UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071/2 "2023-12-28T16:50:47Z")
The below might help. > [@mortar\_board Advanced Booking App Tutorial (Step-By-Step)](https://community.glideapps.com/t/advanced-booking-app-tutorial-step-by-step/66386): > > [[🎓 Glide Tutorial - Advanced Booking App (Full Course & Cheat Sheet)] ](https://www.youtube.com/watch?v=EBuTMEa_aFQ) What’s up Gliders! Thought I’d share my latest free tutorial for those that might be interested. popcorn 𝗔𝗯𝗼𝘂𝘁 𝗧𝗵𝗶𝘀 𝗧𝘂𝘁𝗼𝗿𝗶𝗮𝗹 popcorn This tutorial is an in-depth, step-by-step, tutorial that shows you how to build an advanced booking app from scratch in Glide. nerd_face 𝗦𝘁𝗮𝘆 𝗙𝗼𝗰𝘂𝘀𝗲𝗱 nerd_face Sprinkled throughout this tutorial are countless insider tips, strategies, code snippets and techniques that w… ---
**Author:** ![FelipeMilian](https://avatars.discourse-cdn.com/v4/letter/f/4af34b/32.png) [@FelipeMilian](https://community.glideapps.com/u/FelipeMilian)\ **Post date:** [December 28, 2023, 4:51pm UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071/3 "2023-12-28T16:51:54Z")
Thanks You. ---
**Author:** ![FelipeMilian](https://avatars.discourse-cdn.com/v4/letter/f/4af34b/32.png) [@FelipeMilian](https://community.glideapps.com/u/FelipeMilian)\ **Post date:** [December 28, 2023, 7:50pm UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071/4 "2023-12-28T19:50:14Z")
Do you know if there is a way to use or something similar to CONT.IF in Excel but in glide? ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [December 28, 2023, 8:02pm UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071/5 "2023-12-28T20:02:18Z")
@FelipeMilian try [Query column](https://www.glideapps.com/docs/automation/computed-columns/query-column) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 29, 2023, 10:08am UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071/6 "2023-12-29T10:08:45Z")
Another tutorial that you might find informative: > [@litter\_in\_bin\_sign Trash your Excel Formulas](https://community.glideapps.com/t/trash-your-excel-formulas/55788): > > wave Hey Gliders! By request, I created a video that explains how to replace 14 commonly used Google Sheet/Excel Formulas using Glide computed columns and other native Glide functionality. Formulas are timestamped in the description. For good measure, I also threw in how to use the Excel Formula plugin column upside_down_facepopcorn Enjoy! [[Glide: Replace 14 Excel Formulas with Glide Computed Columns] ](https://www.youtube.com/watch?v=YITKadLUKNE) ---
**Author:** ![FelipeMilian](https://avatars.discourse-cdn.com/v4/letter/f/4af34b/32.png) [@FelipeMilian](https://community.glideapps.com/u/FelipeMilian)\ **Post date:** [December 29, 2023, 1:54pm UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071/7 "2023-12-29T13:54:06Z")
Thanks, but it didn’t work 😕 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 29, 2023, 1:55pm UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071/8 "2023-12-29T13:55:30Z")
What didn’t work? ---
**Author:** ![FelipeMilian](https://avatars.discourse-cdn.com/v4/letter/f/4af34b/32.png) [@FelipeMilian](https://community.glideapps.com/u/FelipeMilian)\ **Post date:** [December 29, 2023, 2:33pm UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071/9 "2023-12-29T14:33:47Z")
I took the videos as examples and was unable to apply the logic to my application. I have a table where I have a “unique value” and in another table also the same “unique value”, I now need to take another table and add these values ​​to check how many times it is repeated, that is, there are 3 tables, 2 with unique values and 1 that will add and bring the result, in execel I do this through CONT.IF ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 29, 2023, 2:35pm UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071/10 "2023-12-29T14:35:15Z")
Can you show me some screen shots of the data so that I can better visualise your goal? It should be fairly straight forward. ---
**Author:** ![FelipeMilian](https://avatars.discourse-cdn.com/v4/letter/f/4af34b/32.png) [@FelipeMilian](https://community.glideapps.com/u/FelipeMilian)\ **Post date:** [December 29, 2023, 6:14pm UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071/11 "2023-12-29T18:14:48Z")
Darren, if possible, I recorded a video if possible, you could watch it, I would be very grateful. Thank you for your attention. > **[Google Drive: Sign-in](https://accounts.google.com/v3/signin/identifier?continue=https%3A%2F%2Fdrive.google.com%2Ffile%2Fd%2F14vgQUvH2ja9U0KuHuva_L8q8WsYpjuCR%2Fview%3Fusp%3Dsharing&followup=https%3A%2F%2Fdrive.google.com%2Ffile%2Fd%2F14vgQUvH2ja9U0KuHuva_L8q8WsYpjuCR%2Fview%3Fusp%3Dsharing&ifkv=ASKXGp2HvNBwZxqoQJhZoXR47il7YOOzcLwz5LWKheLN2GBQYbhC3mcL3r5laQyGj48A5cZ7HXR-FQ&osid=1&passive=1209600&service=wise&flowName=GlifWebSignIn&flowEntry=ServiceLogin&dsh=S-1190305194%3A1703873683670319&theme=glif)** > > Access Google Drive with a Google account (for personal use) or Google Workspace account (for business use). ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 29, 2023, 6:16pm UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071/12 "2023-12-29T18:16:08Z")
Happy to watch the video, but you need to make it public first 😉 ---
**Author:** ![FelipeMilian](https://avatars.discourse-cdn.com/v4/letter/f/4af34b/32.png) [@FelipeMilian](https://community.glideapps.com/u/FelipeMilian)\ **Post date:** [December 29, 2023, 6:29pm UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071/13 "2023-12-29T18:29:37Z")
Sorry, Follow the link. > **[teste 01.mp4](https://drive.google.com/file/d/16UFdYMwpYL1H4n3E8g8xc2rhpkZLGc9O/view?usp=sharing)** > > Google Drive file. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 30, 2023, 3:16am UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071/14 "2023-12-30T03:16:58Z")
First up, nice work dubbing with ElevenLabs. So as I understand, users choose a date, a time slot and then you want to be able to show only cars that haven’t been booked for that same slot? You can bring the chosen date and time slot to the cars table, then use a query column that points to the Bookings table and filter by the date, time slot and the car to check for matches. If there’s a match, you don’t show the car. ---
**Author:** ![FelipeMilian](https://avatars.discourse-cdn.com/v4/letter/f/4af34b/32.png) [@FelipeMilian](https://community.glideapps.com/u/FelipeMilian)\ **Post date:** [January 3, 2024, 2:12pm UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071/15 "2024-01-03T14:12:38Z")
Firstly, thank you for your attention, I used ElevenLabs but I don’t know if it was good ;). Come on, the way you thought is correct, I did this logic using Google Sheets, I create a “UNIQUE ID” using DATE, TIME AND CAR to be able to check if that vehicle already has a scheduled time. I want to bring these formulas into GLIDE because Sheets sometimes “bugs”. So far I haven’t been able to find a logic between the GLIDE tables that I have in my app, but I’m trying 😕 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 3, 2024, 11:16pm UTC](https://community.glideapps.com/t/help-with-a-scheduling-app/69071/16 "2024-01-03T23:16:31Z")
> [@ThinhDinh](#): > > You can bring the chosen date and time slot to the cars table, then use a query column that points to the Bookings table and filter by the date, time slot and the car to check for matches. If there’s a match, you don’t show the car. Please try doing this and report back to us what you find. Ideally, you should bring all logic you can to Glide Tables.