The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.
Here is a way to automatically pull information from airtable into Excel via power-Query using a bit of coding.
If you are looking to just copy and paste the code you need without much explanation, ignore the details :slightly_smiling_face:
Detai...
Problem Scenario:
Airtables datetime_parse function is unable to parse a date from a 1970 serial format.
A date column is pasted in your Table in as a serial number (ex UNIX format or 1970 serial format).
(Lets say that column is called "Instrument...
First of all, many compliments on the android app:
I love it and it is very user friendly and intuitive.
Now, when adding an attachment to a record, the options are: camera and file picker. But I need to make and attach a pdf using the phone camera…...
Not sure if I’m too late to the party, but here is a tutorial I made covering how to do exactly what you are asking: Airtable link to Excel via Power Query
It is complete with pagination code.
Email me if you have questions, but full disclosure, I do...
I suspect this is the error:
Contents(“https://api.airtable.com/v0/appfSBJGSgkE7a6tF/COVID-19%20Tracker?view=Treatments%20and%20Vaccines?offset=”&[WebCall][Value][offset]
Should be as follows:
Contents(“https://api.airtable.com/v0/appfSBJGSgkE7a6t...
you may be having the same issue other’s have had.
Airtable link to Excel via Power Query Show and tell
@Adolfo_Ferreira and @Ivan_Larson
I tried using Adolfo’s code, and it looks legit. I see no reason why it is throwin...
Hello Simon, please send a screen shot. If I understand you correctly, your solution is to create another field to extract the data from your linked record field in a more friendly fashion.
EX:
Lets assume you have an INVOICES_tbl (that shows the to...