I know that HubSpot allows a user to not see empty fields on the Contact or Deal objects but is it possible to create a custome field on an object that will hold data that is not necessary to be show on the Object? Time in Deal Stage is calculated but it would be useful to put the data into a custom field but then not show it on the Deal Object to keep the object clean for the users. It would be used for reporting and other analysis. I assume you can create a custom field with the API and not have it revealed on an object. Is that the case?
I kind of thought that was the case. I can create custom fields in Pipedrive., Salesforce and other CRM to enable calculated fields, etc. that do not have to be exposed to the end user but was not sure HubSpot did that. I thought via the API you can create customer fields on the backend and not have them visible on the Object in the UI. No?
HubSpot is an app built on AWS and there is a structure to those apps that allows redundancy and stability. There are web servers, application servers and database servers. Data can and does exist in the database layer that is not available in the UI or webservices layer. The HubSpot API points to the database layer for loading and managing data on the backend of the application. The three layers operate independently with rendundancy so that applications are less likely to fail.
It makes total sense that there are database columns you can add because you can add custome fields to tables and that means the user has write access. The API enables you to have write access to the database and insert custom field and then populate them with caluclated data (say date calculations that are not readily available in the UI) and then those triggers can go in and send notifications of subscription expirations, or dated communications.
What I am wondering is why HubSpot does not have a way to class Users so that every column available can be seen or not seen based on the User class. For example, we have Sales users who are not sales professional but they can see sales just not all of professional. By allowing columns to be hidden from users but exposed to admins more work can be done through the front end for people not able to code to the API without a developer. It makes the HubSpot application that much more powerful.