I have a base containing a table for work orders and a table for clients. Works orders have a linked field to client name but when I try to get the client name in zapier it returns an ID rather than the text value of the client name. Should this work...

Here is a sample Airtable Lookup Test - Airtable Explore the "Lookup Test" base on Airtable. I would like Jobs::Total to show a sum of the Hours::time when Jobs::Work Order matches Hours::Work Order. ...

I currently have a table called Work orders and a table called Tasks. Work orders have related tasks but tasks can also have the checkbox “Next Action” and I would like to be able to see whichever task is set to next action in the work order table. I...