# Big Tables - I'm trying to create a Registration and Check In process but struggling with Big Tables **URL:** \ **Category:** Ask for Help\ **Created:** [February 13, 2024, 2:32pm UTC](https://community.glideapps.com/t/big-tables-im-trying-to-create-a-registration-and-check-in-process-but-struggling-with-big-tables/70785 "2024-02-13T14:32:41Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![mcjmccartney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mcjmccartney/32/70883_2.png) [@mcjmccartney](https://community.glideapps.com/u/mcjmccartney)\ **Post date:** [February 13, 2024, 2:32pm UTC](https://community.glideapps.com/t/big-tables-im-trying-to-create-a-registration-and-check-in-process-but-struggling-with-big-tables/70785/1 "2024-02-13T14:32:41Z")
Hi Everyone, I hope someone can help me. I have an Attendances Table that contains the columns below: ![Screenshot 2024-02-13 at 14.28.32](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/4/641e2fb01141acb7f8d6c1bc9dd5c0226cdb19d5.png) I then have an Events table where the below can happen… An Admin user can select a User from a dropdown to register and stamp the Registration date stamp - but sadly I can’t figure out how to remove this User from the dropdown once registered? Secondly - this registered User will then move over to the Check In dropdown allowing the same process to happen but instead stamped with a Check In date and is removed. I believe I am having trouble making this work with the lookup limitations because of the Big Table arrangements? Any help would be perfect! 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:** [February 13, 2024, 5:11pm UTC](https://community.glideapps.com/t/big-tables-im-trying-to-create-a-registration-and-check-in-process-but-struggling-with-big-tables/70785/2 "2024-02-13T17:11:20Z")
This is a tricky one, because you can’t use a Query into a Big Table as a filter (yet). So you need to get a bit creative. Here is one way you could do it (easier to explain in a video): https://www.loom.com/embed/5252d4a8bb464c1387e9e881cd497572 Link: [Big Tables - filtering a choice component | Loom](https://www.loom.com/share/5252d4a8bb464c1387e9e881cd497572) ---
**Author:** ![mcjmccartney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mcjmccartney/32/70883_2.png) [@mcjmccartney](https://community.glideapps.com/u/mcjmccartney)\ **Post date:** [February 13, 2024, 5:15pm UTC](https://community.glideapps.com/t/big-tables-im-trying-to-create-a-registration-and-check-in-process-but-struggling-with-big-tables/70785/3 "2024-02-13T17:15:26Z")
Hi @Darren_Murphy! I’m yet to check your video but wanted to get back to you prior to this as I’ve seen your videos help others out before and wanted to thank you for getting back to me with such detail as a video. Will check it out now - so glad I was able to explain it to a point where someone else would understand! 😅 ---
**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:** [February 13, 2024, 5:18pm UTC](https://community.glideapps.com/t/big-tables-im-trying-to-create-a-registration-and-check-in-process-but-struggling-with-big-tables/70785/4 "2024-02-13T17:18:18Z")
I just realised that I missed the most important part out of the video - how to apply the filter 🤦‍♂️ What you need to do is first create a Joined List column that targets the Multiple Files column: ![CleanShot 2024-02-14 at 01.15.50@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/a/0ad6b7e9160ed4e06ec77d90415c0acbb040f1af.png) And then use that column in the filter condition: ![CleanShot 2024-02-14 at 01.15.28@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/6/66c7441d84daa023e446778edb7df0f696ff7ffc.png) ---
**Author:** ![mcjmccartney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mcjmccartney/32/70883_2.png) [@mcjmccartney](https://community.glideapps.com/u/mcjmccartney)\ **Post date:** [February 13, 2024, 6:28pm UTC](https://community.glideapps.com/t/big-tables-im-trying-to-create-a-registration-and-check-in-process-but-struggling-with-big-tables/70785/5 "2024-02-13T18:28:35Z")
Hi again @Darren_Murphy, Just wanted to let you know that your solution has worked perfectly for me - this is exactly what I was after - what an amazing result. Thank you again, have a good day! 😀 ---
**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:** [February 14, 2024, 1:15pm UTC](https://community.glideapps.com/t/big-tables-im-trying-to-create-a-registration-and-check-in-process-but-struggling-with-big-tables/70785/7 "2024-02-14T13:15:30Z")
I guess the fact that you deleted that last post means that you figured it out? 😉 I saw it earlier, but didn’t have time to reply - was just about to reply now. 😃 ---
**Author:** ![mcjmccartney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mcjmccartney/32/70883_2.png) [@mcjmccartney](https://community.glideapps.com/u/mcjmccartney)\ **Post date:** [February 14, 2024, 2:02pm UTC](https://community.glideapps.com/t/big-tables-im-trying-to-create-a-registration-and-check-in-process-but-struggling-with-big-tables/70785/8 "2024-02-14T14:02:17Z")
Hi Darren! Yes I had thank you - and felt pretty chuffed afterwards but it was all thanks to your work with the solution above. 😆 I didn’t want to string out this feed so thought it best to delete the comment - but I suppose it could have been handy to anyone else checking this out. 👍 ---
**Author:** ![mcjmccartney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mcjmccartney/32/70883_2.png) [@mcjmccartney](https://community.glideapps.com/u/mcjmccartney)\ **Post date:** [February 15, 2024, 3:20pm UTC](https://community.glideapps.com/t/big-tables-im-trying-to-create-a-registration-and-check-in-process-but-struggling-with-big-tables/70785/9 "2024-02-15T15:20:17Z")
Hi @Darren_Murphy, me again… Would it be possible to make this work with selecting multiple Users from the choices dropdown? I realise trying that this way just joins all the User Id’s together. ---
**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:** [February 15, 2024, 3:42pm UTC](https://community.glideapps.com/t/big-tables-im-trying-to-create-a-registration-and-check-in-process-but-struggling-with-big-tables/70785/10 "2024-02-15T15:42:40Z")
Yes, all you would need to do is add a split text column that creates an array from the joined list, and then you should be able to use that in the Make Array column (not sure I’ve ever tried that, but I would expect it to work). ---
**Author:** ![mcjmccartney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mcjmccartney/32/70883_2.png) [@mcjmccartney](https://community.glideapps.com/u/mcjmccartney)\ **Post date:** [February 15, 2024, 3:43pm UTC](https://community.glideapps.com/t/big-tables-im-trying-to-create-a-registration-and-check-in-process-but-struggling-with-big-tables/70785/11 "2024-02-15T15:43:21Z")
I’ve actually come up with a work around - I’ve created a Checklist Collection that allows the User to Check all Registered Users and therefore stamping them with a check in date plus can select multiple users like a guest list. ---
**Author:** ![mcjmccartney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mcjmccartney/32/70883_2.png) [@mcjmccartney](https://community.glideapps.com/u/mcjmccartney)\ **Post date:** [February 15, 2024, 3:44pm UTC](https://community.glideapps.com/t/big-tables-im-trying-to-create-a-registration-and-check-in-process-but-struggling-with-big-tables/70785/12 "2024-02-15T15:44:35Z")
Ah, you replied at the same time as me. I’ll give this a go too - thank you! ---
**Author:** ![mcjmccartney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mcjmccartney/32/70883_2.png) [@mcjmccartney](https://community.glideapps.com/u/mcjmccartney)\ **Post date:** [February 16, 2024, 8:38am UTC](https://community.glideapps.com/t/big-tables-im-trying-to-create-a-registration-and-check-in-process-but-struggling-with-big-tables/70785/13 "2024-02-16T08:38:07Z")
Hi @Darren_Murphy, Very sorry, last question… How are you displaying the ‘Users Checked In’ column of your video please? The area where the names are appearing, thank you. ---
**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:** [February 16, 2024, 9:14am UTC](https://community.glideapps.com/t/big-tables-im-trying-to-create-a-registration-and-check-in-process-but-struggling-with-big-tables/70785/14 "2024-02-16T09:14:58Z")
In the Events table, I created a multiple relation column that matches the Checked In users array with the RowID in the Users table, and then a Joined List of Names via that relation (using a new line as a separator) ![CleanShot 2024-02-16 at 17.14.23@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/0/0082d5f61445ef3887ad430f09ac0639592a70dc.png) ---
**Author:** ![mcjmccartney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mcjmccartney/32/70883_2.png) [@mcjmccartney](https://community.glideapps.com/u/mcjmccartney)\ **Post date:** [February 16, 2024, 9:17am UTC](https://community.glideapps.com/t/big-tables-im-trying-to-create-a-registration-and-check-in-process-but-struggling-with-big-tables/70785/15 "2024-02-16T09:17:12Z")
Superb, thank you for all your help on this. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [February 23, 2024, 9:18am UTC](https://community.glideapps.com/t/big-tables-im-trying-to-create-a-registration-and-check-in-process-but-struggling-with-big-tables/70785/16 "2024-02-23T09:18:04Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.