It seems to me that all the solutions being proposed within Obsidian have “friction” of one sort or another, and so let me offer a slightly counter view to those offered to you so far: it may be that Obsidian isn’t the best tool for your purpose.
Just saying this is sacrilege on this forum, but before you shoot me down let me explain the principle that I think you are grappling with here. Explaining the principle should help you solve for it, whether or not you decide to do so in Obsidian.
To headline the issue for you: two other software solutions you might consider would be AirTables (free version) or Notion (free or paid). Personally, I use Notion for the sorts of tasks you are describing, because it is in my view a better fit for this purpose. There is no friction at all of the sort you describe, but the downside is that Notion doesn’t do what Obsidian does well: finding the relationships between information you have stored. But there are pros and cons: see below.
As I’m sure you know, most professional CRM systems (Customer Relationship Management) that have the functionality you are describing - such as Oracle or Salesforce - are built using “relational databases”. Relational databases allow you to view or analyse the same data in multiple ways, and to re-use data across different tables such that updating the source data updates all the tables that use that data, and all the reports/data views based on those tables. You can enter data once, and see that data reflected in multiple reports and tables.
Neither MS Excel nor Apple Numbers are relational databases, the best they can do is “pivot tables” (in Excel) or Apple’s equivalent “Categories” that allow you to sort data in a table.
Pros of Notion for CRM:
(AirTables can achieve something similar, and is a more advanced tool, but is not as easy to use with a steeper learning curve)
- Notion is just a relational database with a very friendly and aesthetically pleasing user interface; so it overcomes the friction of using the same data entry across different ways of viewing that data
- You can create “relationships” between columns of one spreadsheet, and those of another… this “lookup” allows you to create “reports” that automatically populate, so that you can see the customer data in different ways for different purposes
- You can create your own data entry forms, for example a customer meeting notes template… and have it automatically populate your customer database
- Notion’s spreadsheet-style views allow you to easily create columns and rows, which you can then sort or filter; and you can put anything in a cell: a photo, a link to another cell, a page link etc
- Notion has built-in functionality like Kan-Ban boards, Gantt charts, Calendar views etc which are ready to use - you just have to format/structure them to your liking
- Notion is aesthetically pleasing, it is the exact opposite of a markdown environment, and so has less “formatting” friction
Pros of Obsidian for CRM:
- At the cost of the friction you mention, you can link your customer records to other information that you might want to connect it to…
- Obsidian is IMO a far superior tool for PKM
- Obsidian is a far better tool if you want to be able to navigate from anywhere to anywhere, using hyperlinks… and if you want to connect your Obsidian data with other data sources, such as databases, pdf folders, etc…
- Obsidian is a better tool for situations when you cannot structure the data entry and reporting formats in advance, because you don’t yet know how you want to use the data or even what it means… ie it is FAR BETTER than Notion for exploring ideas and connections
Hope this helps.