For certain types of databases (i.e. Tasks, People, Organisations, Tools) I would like to have the ability to inherit/extend databases.
I want a base database called Person which has a few basic fields: given name, surname, email, phone, etc.
I’ll have database called Staff that extends Person, which in addition has fields like: join date, role, salary, etc.
I’ll have a database called Contact that extends Person, which adds fields like: company, meetings, etc.
I’ll have a database called Recruit that extends Person, which adds fields like: source, CV, website, etc.
Currently we have to choose between:
2. One massive database with lots of irrelevant fields, which also confuses
Multiple databases with same fields, which requires us to convert entities at times and/or duplicate results, which confuses folks
Multiple extension databases: One Person database and then Person-Staff, Person-Contact, etc. that maybe automatically connects some entries.
As you can imagine, none of these approaches are ideal for users as they are confusing and certain fields do not map, etc.
I love that I can have multipole entity types on a board (we use this for our task kanban), but of course I’d rather have a board that just lists all tasks irrespective if they are dev tasks, business tasks or support tasks (tickets)…
I still think the Lookup-based approach is potentially non-ideal and quite limited (even if editing in looked-up entity is added) vs. some kind of “inheritance” system or at least Individual Layouts for a node, hide fields etc and/or Tab Views in Entity Pages. The newer ability to Hide and Collapse Fields and Relations is helpful to deal with field proliferation but doesn’t address the need for different views of same/related data based on context.
That’s our current set-up for contact. Which is really confusing. We have really huge databases (example: our contact database) with a lot of hidden fields (which we only use in automations/formulas). But if a user wants to create a form or want to add a value in a table, they will see all fields. The list is quite insane