Hello!
I am running into an issue where the field count is almost maxed out on two tables in my base and I need the ability to add more fields. In both of the tables, there are many fields that are used for reporting/stats. I considered moving all of those fields to another table but it’s not quite working out.
I do closing coordination for real estate agents. The two tables in question are the Properties table and Contacts table.
- The Properties table has records for each contract.
- The Contacts table has records for each of my agents.
- Each property record is linked to the agent for that contract in the Contacts table.
- Reporting in the Properties table is done based on the agent for things like properties under contract, properties closed X amount of days ago, etc.
- Reporting in the Contacts table is done based on the agent using rollup/formula fields that reference the Properties table for things like average sales price over X periods, commission totals over X periods, etc.
In the new table, I can’t figure out how to do this properly. I have tried a few different ways and keep running into roadblocks. I thought maybe I need a record for each agent that links back to their record in the Contacts table and a record for each property that links back to the Properties table (I figured these could be created with an automation when a new property is created in the Properties table). It just seems clunky thought and error prone. And I can’t get rollups to work properly because I can’t do rollups on lookup fields.
I tried my best to explain and would greatly appreciate any insight. Thank you!
