I’m wanting to create an “Activity” table, of sorts.
With this activity table, I want to be able to quickly log details of what activity is being done at that time. All activities will have similar data: date created, type, customer name, etc.
But, not all activities will be the same, and all activity types will require their own data.
So, I’m trying to think around what is possible here. What I’d like to do:
Activity Table
Columns: Date/Time, Customer Account, Activity Type
Then, based on the activity type, in a manor of speaking, I’d like that to essentially “conditionally” or “dependently” open up a subset of additional columns relevant to that type of activity. It doesn’t have to be true conditional or dependency though…
I just need a little … collaboration to get my mind going in the right direction.
I thought perhaps I could use a table column type and then use the “lookup” to determine which subtable to display, but that doesn’t seem to work… as it wants me to select a table upon structuring the subtable column type.
I thought maybe using switchif, but I’m just not sure how to structure this in the best way.
I’ve been working with basically all of the types of activity that could possibly happen as their own column and using views, but this is very very cumbersome and clunky. Its resulting in having extra data that isn’t needed and a lot of empty rows… I just don’t quite know how to do it, but I’m sure there’s gotta be a way…