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!
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):
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!
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.
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.
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).
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.
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.
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)
