Being a developer can sometime have its drawbacks with Bubble and their database as I feel you need to think differently sometimes. Here’s what in my head I want to achieve in Bubble:
I have 2 tables, Projects & Proposals where a project has many proposals. All I am trying to do is get a sum of the proposal amount where the project stage is “published”. So in SQL I would do this:
SELECT sum(amount)
FROM Proposals
INNER LEFT JOIN Projects on Proposals.ProjectsID = Projects.ProjectsID
WHERE Projects.stage = ‘PUBLISHED’
AND Proposals.Is_Latest = Yes
I have tried all different approaches but just cannot get this to work. Any suggestions with this?