I’m starting out with Bubble, and currently building a simple CRM system.
My database build as follows (only relevant things), so not all data is always completely loaded :
- Total Revenue (this should be sum of all products in Deal_Budget?)
- Product A revenue
- Product B revenue
- Product C revenue
- Deal - Deal
I’d like to have one datatype for sum of all values (revenue) of Product A, B, C as a datatype, to make it easier to grab just the total revenue. Currently I am using “search for value of deal_budget is Product A + search for value of deal_budget is…” etc, which feels very scrubby.
Any ideas how I can manage this? And additional question: is this database formating the most logical for a pipedrive / sales CRM?