Does anyone have a sample base, along the lines described in the recent blog post: Allocate your resources in Airtable’s Timeline view?
I’ve got a few years of AirTable experience, but I’m trying to fast track my learning about this.
Thank you in adv...
I can’t think of a better, easy-to-build-with database tool than Airtable, and flowing data from it for data visualisation in Power BI is a sweet marriage.
I’m not a coder, so I needed some step by step instructions, and you might too.
Here’s what I ...
Imagine a name string: Nina and Ian Fowler
I want to end up with: Nina and Ian by finding and removing: Fowler.
FIND() seems to function left to right, so while I can use:
LEFT(Name,FIND(" ",Name)-1)
To get: Nina
How can I remove the last name: Fowle...
I’m getting Quote marks and line breaks in fields, when I copy and paste the data to a txt file (or download a CSV). What should look like this:
MARKETING
MARKETING
ONLINE ORDERS
ONLINE ORDERS
Looks like this!
"
MARKETING
"
"
MARKETING
"
"
ONLINE ORD...
Thanks @Bill.French, I used the information in Oscar’s document. There were a few missing steps, so I have filled in the details and written them up with screenshots, in the document above.
@Plinio_Averbach
If you go to the bottom of this post, we’re almost there:
How to send more than 100 records using API? API
Great article Oscar!
That’s the middleware you needed and it’s ideal that you did this in PowerB...
Thank you @Oscar_Diaz and @Bill.French
I have almost got there. :slightly_smiling_face: I wrote out the code from the screenshot in the Medium article as below, replacing the [APP_ID] [TABLE_ID] [KEY_ID] with the appropriate entries, but PowerBI c...
It’s funny how so many threads about connecting Airtable and Power BI just go dead and unresolved. Did anyone in this thread find a solutiuon for this?
Excellent and very helpful, thank you.
I adapted some of your other helpful code from other links to arrive at this:
LEFT(
Name,
LEN(Name) - LEN(REPLACE({Name},1,FIND("~",SUBSTITUTE({Name}," “,”~",LEN({Name}) - LEN(SUBSTITUTE({Name}," “,”")))),""))
)...
