I have a table called events which relates to a number of other tables such as Company.
I have been asked to keep track of invitees (other companies) and attendees (also other companies but not necessarily the same) and to track if invited companies attended the event.
My first thought was a table with: EventID | Host (Company) | Guest (Company) | Invited (1/0) | Attended (1/0) ) and then use templates (EventID + Guest), another relation (template = template) and a rollup to compute if a Company was Invited AND Attended ( 1 is no, 2 is yes).
Seems easy to implement but smells a little half-baked - any other ideas??..
I think a simpler approach would be to use booleans for Invited/Attended, and then an if-then-else column that references each of those to determine if both are true.
If you wanted to know how many invited attendees actually attended a specific event, youâd just need a relation to your event ID, and then a rollup that counts the if-then-else true values.
Not wanting to open a can of worms, but does the data already exist in other tables? If it does, Iâd probably be looking for ways to leverage the existing data to get what I needed, rather than creating a new table just for this purpose. It seems like it would generate an awful lot of rowsâŚ
I have an Event table (with an EventID) and Events are smallish with 5 - 50 companies per Event. The list of target companies is 2,000 and growing. Attendees and Invitees are selected from this target table.
Events are specific to a territory and are usually Co-hosted (with another Company).
The table of âtargetâ companies is 2,000 rows and growing. One (Host) company will potentially end up with 25,000 âtargetâ companies across a number of different territories and with a number of different Co-hots.
I can add columns to the âtargetâ companies table but I expect that to be large and didnât want to overload it too much.
Not sure if this helps, but I am open to any idea. Thanks as always.
So if youâre going to create a new table that contains one row per event, per invited attendee, Iâd imagine that table will very quickly grow to tens (if not hundreds) of thousands of rows, no?
Just based on what youâve shared, I think Iâd be trying to do this tracking inside my Events table.
Add two columns, one to contain a joined list of InviteeIDâs, and another to contain a joined list of AttendeeIDâs, and youâre basically done. From those two columns, you can easily use a couple of array plugins to extract a list of those that were âinvited and attendedâ.
Zero extra tables or extra rows required.
In general the problem is: I have a large list of items (accounts) which I need to create subsets. Conceptually I want to âselectâ multiple accounts from a large list of accounts (see image) and then have them âmovedâ into this new table (or joined column). This is what the selection process looks like today but I only allow one account to be selected and then I âcopyâ that AccountID to the new row I am creating based on what I selected.
But I donât know how this would methodology would work when selecting multiple accounts. In this example I would want to go to one screen and select all the accounts that have been invited. At the end of the event I would select all the account that attended. Storing them as a joined list or creating a separate table.
I intend to use the Account table selection method a lot more but my current method is based on a USC âselected flagâ in the account table doesnât scale. It is fine when 1 account is selected (copying one AccountID into a column) but I donât know how to move multiple selected items into a column (like a joined list) or into multiple rows in a table.
Iâd imagine that youâll probably need to use some variation of the Trebuchet method.
It shouldnât really matter where (which tables) the Account options come from. As long as they can be presented in some sort of list that you can configure an action on, thatâs all you need.
I looked at this example and it is certainly seems easier in a Glide Page where you have more room to have a button next to a list of items as an âactionâ (and with less data). I watched another @Robert_Petitto video (Glide: The Trebuchet Method is UNREAL - YouTube) and he started with a checklist but moved to a list and then to a âless denseâ representation - card view.
My process was going to be:
Display a check list of accounts (currently used elsewhere for selecting one account)
Let customer search list and check all the accounts they have invited/will invite.
Push âMark as Invitedâ button
âMoveâ all the âchecked/invitedâ accounts into the Events âarray columnâ.
I currently implemented a check list (when selecting one item) and I was imagining I could use the same âUIâ for selecting multiple accounts and that I would process the entire list at one time after the user checks all the accounts. But Glide does not have an iterate capability when acting upon a check list and I donât see how I can create an action upon âcheckingâ an item.
I can âselect/inviteâ an account one-by-one by clicking on a list item (with a custom action) that would then âslingâ the item into the array. But the item list looks âdifferentâ because the custom action symbol (>) at the right but not actually taking you anywhere. Is it possible to âhideâ this glyph?
Net/net: In general with Glide I should be processing actions individually and not as a list.
With an Inline List using a checklist style, what you can do is target the Check Value at a User Specific Boolean, then you can have an if-then-else column that looks at the status of that boolean, and if itâs checked return the item (contact) ID. Then you can gather those up with a joined list column and use that to update your invite list. But yes, you need an action somewhere to make that happen. But Iâd imagine youâd have that anyway? ie. âCheck all those to invite, then tap a button to confirmâ?