Edd_Tillen - profile

Edd_Tillen · Feb 05, 2023

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...

Get an email address from a User field · Nov 03, 2022

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 (...

Edd_Tillen · Sep 30, 2022

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...

Edd_Tillen · Sep 27, 2022

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...

Edd_Tillen · Aug 31, 2022

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 ...

Edd_Tillen · Feb 07, 2023

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...

Edd_Tillen · Feb 06, 2023

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,...

Edd_Tillen · Nov 03, 2022

Brilliant, that works, thank you. Easy when you know how :slightly_smiling_face:

Edd_Tillen · Oct 03, 2022

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.

Edd_Tillen · Oct 03, 2022

Sure thing. I assumed sharing screen shots would be difficult on here. I was wrong, it’s really easy! I hope you can make sense of these.

User Statistics

User Activity

Exporting Airtable Data into PowerQuery

Get an email address from a User field

Use automations to update the last record of a different table when new items are added

Exporting Healdine Data to Confluence

Linked fields working both ways

Re: Exporting Airtable Data into PowerQuery

Re: Exporting Airtable Data into PowerQuery

Re: Get an email address from a User field

Re: Use automations to update the last record of a different table when new items are added

Re: Use automations to update the last record of a different table when new items are added