I have a lookup field giving me three different states: “act”, “belong” and “commit” How can I count how many times “act” is in this lookup field? If I use COUNTALL, I just get the total sum of states in this field. How can I just count just “act”? ...

Slowly I am getting a better understanding of Airtable :slightly_smiling_face: I have a table called task: And a table for completed task: So far so good. When a user completes a task, a new record of the task is created in “completed task” along...

I have grouped some fields in my Airtable. How can I get a specific “count” or a “sum” with API? How can I access this data through API? I am interested in getting the different counts and sums for each group. I.e: Score_act: sum 41 Task: “Jeg har k...

Hi! Have not figured out this yet. It seems like a task, but I am not sure what the most elegant solution is. How can you add a +1 to a number if something happens in a record? Regard, Tor Martin

Hello Airtable community. I am a designer whose brain is hurting after struggling to get a decent grip on building dynamic databases in Airtable. I have a lot of questions, maybe you have some of the answers? This is my Airtable: Airtable - Hodebra a...