Hi everyone, we are building a little CRM inside Airtable and I am trying to do something that seems to be almost impossible. Perhaps I am just not seeing it. So, would love some help to get this going:
One table called Customers
Another table called “Health Score Reviews”
The first table is self-explanatory. The second one, has a series os “log entries” for every time someone from our Customer Success team interacts with a customer. In that interaction, they can add a SCORE to the interaction from 1 to 3.
We want to show the LATEST Health Score for that customer in the Customers table.
The first part I was able to do, which was to retrieve the max(id) for the Customer Health entries and pul that number to the Customers table.
The problem is that I want to Lookup in another column what was the Score that was registered under that ID. I am trying to use a Lookup field.
The idea is to retrive just the latest Score. But it doesn’t work and it brings up all the Scores associated with that customer, not just the last one.
What am I doing wrong?