I've used this very helpful page to be able to export my tables out of air table and into Power Query, and from there into Excel: Sending Airtable Data to Microsoft Power BI & Power Query | Airtable SupportHowever, I'm having an issue that some seemi...
I’m trying to make an automation that sends an email to alert people when a task is almost due. The people have been selected in the record using a User field called ‘Responsible Person’. I kind of assumed that AirTable would know the email address (...
I’ve got a table where I add records, and I have another table where I’m trying to make an annual summary of all the records I’ve added to the first table. So I should end up with one record for each year on the second table, with multiple records li...
I’m trying to create a home page for my Confluence space with some headline data from a table I’ve got in AirTable.
I’m ultimately trying to create Power BI type cards on the page, showing a count / total of records in a view in AirTable. I’m not eve...
I’m working on an AirTable system that someone else started for me, and learning as I go.
I’ve got 3 Tables. A = Staff, B = Assets, C = Access.
On Table B I’ve got a Link Field to table A, so I can add a Staff Member’s name in a new record, and then ...
I think you've cracked it. I did know that so it sounds dumb that I fell into that trap. The top row in AirTable has a result in that column, but when the table is imported into Power Query, it puts a different row at the top, which doesn't have an e...
Thanks for the advice. I hadn't even considered third party solutions. It's frustrating, because this is working, it's just missing a couple of seemingly random columns. The really frustrating thing is, out of 10 columns, I only really need a couple,...
And I was updating the wrong table. I needed to be updating the NC Table based on the field where the two tables were linked. That then populated the linked field in the Summary table.
