The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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}," “,”")))),""))
)...