Hello all! I’m using Coda from 2 days and I’m trying to make a Medicines tracker (tried this in Notion, but 80% of the stuff I wanted to were impossible that’s why I migrated to Coda).
Below you can see a dummy date of what I have.
I need to make a calculation inside Page
All Med for column called
It should take the Sum of Table
Daily Log New Column
Dose Where Daily Log New.Name = MedicinesNew.MedName
From what I understand the issue is because
Daily Log New .MedName is a relation list and it cannot compare. If I change Daily Log New .MedName type to
text it’s working with this formula
[Daily Log New].Filter(CurrentValue.MedName = thisRow.MedName).Dose.Sum()
How to make it work without changing the type to
I think you have edit access to the Doc.
Thanks in advance for the help