Spreadsheets are Dead. They didn’t scale with the industry - so we have group text threads and breakout meetings to confirm redundant information that’s out-of-date before it hits the inbox. Thankfully, there’s a solution to our industry’s systems epidemic.
Airtable is the most accessible software development language in history. In a matter of hours, it allows non-technical people like you and I to create custom business apps that organize information, align the team, and automate the bulk of our work.
I know, I know: “Stop with the apps and find me the hits.” I get it. But the ‘hit record panacea’ mentality is what got us here in the first place. Besides, what do you think your bundle of inherited spreadsheets is, anyway? A custom business app! But you're missing the most important part: a relational database.
The mission of this channel is to explain the power of relational databases through demonstration. More at www.relationl.co/blog
Пікірлер
Is there way to use upsert without ID? like if Handle is unique one? Can we check it exists or not? Because two times Search Records make operations will be too much.
Hi Max. Thank you for the great content. Are you able to provide this base as a template?
Hey Max, how have you created individual 'Week' views under the same the same "Releases" Table? Thanks!
He there, check out this video. It should answer your question: kzread.info/dash/bejne/dK1rssGmkaS2g6w.htmlsi=uUbcupAQ1RWAyol1
Thanks for the video, it definitely clarifies the concept Are you familiar with the "generate pdf" integration by fillout themselves? If so, is it possible to include the "members" list in the pdf?
Hey Mosh, no I am not. I use documint.me for Airtable to pdf automations.
hello could you help me understand what results I could get if I add the jungle scout API for Amazon sellers to my scenario
Hey there. I can’t help with that unfortunately. Good luck!
Glide says filtering isn't a secure method, people can inspect and find other data, glide suggests that we use role, but i don't see any tutorial on role
I think they are referring to conditional visibility based on user role. You basically create a Role field in the User table and make certain elements conditionally visible only if current user's role is say "Admin", for instance.
This is great. Super-informative!! Didn't even know the interface option existed.
😉 new since Oct 2022 and it’s only really started to shine in the last 6 months.
Can you please do a tutorial on this automation or can you share the blueprint to the scenario?
Hey sifi, check my channel from April 2023. Here’s the link - > kzread.info/dash/bejne/fYSpl9erfaSxeKQ.htmlsi=En-p30BqTsVOAUWx
You can link records across google sheets tables as well. Using a importrange function.
genius! i was not aware of that.
Great Max
Brilliance through simplicity 🍻⛳️🌵
Clever🍻🌵🏌️♂️
Good vid!
Excellent. Although I think using the URL attribute to pass the family name was an unnecessary step in this case. I think we could have simply used @ and added the field directly from the first table. Since these tables are part of the same form, all of the information is available available using @. URL parameters are great for loading fields with record data that are not collected in the form. Anothrr cool idea would be to preload the last name field using @ in the default value. and we could also default the relationship value to child. Fillout is such a remarkable tool, They have truly done great things in the form space.
You are exactly right!
Greetings max, I would want to know whether you build airtable workspaces for business md how do you go about it ?
Hey there. Yes we do!
@@relationl let me have your contact email address, I will talk to you further
Hey MaxB, great vid, I was looking just for this! 🍻🏌️♂️🌵
Excellent!
Super interesting…. but not free
too bad my g
Simplescraper is the pure “no-code” option but also more expensive. If you’re willing to get slightly more technical the Apify.com is a lower cost solution.
This is AWESOME Max! I have been leaning into Airtable so much and barely scratched the surface. Thanks to your video I'm going to be more efficient and have more time to focus on other tasks. Please keep putting these out!
Thanks for the encouraging feedback Mike! As an Airtable power user, what’s one thing (concept, trick, etc) that you learned from these videos? I’m curious to understand where the gap is between “leaning in so much” and “scratching the surface”? What were you missing before? formulas? interfaces? Data structure?
@@relationl I never understood how to properly utilize linked records. Watching you create one for Artists and one for Reporting made it so much easier to create and understand. Thank you!
Amazing! Airtable is a game. He who finds the most “one-to-many” relationships in their data and properly expresses them using Airtable linked records, wins! I wrote a blog post about this last year. www.relationl.co/blog/airtable-is-a-game
Thanks Max!
❤❤❤❤❤
Great Info! Can you make a video for Updating Spotify plays of particular songs into airtable and rank them? Would really appreciate it!
Thank you! This can be done using a web scraping tool like Apify or Simplescraper. I will add this to the build pipeline for the tutorial series.
Hey Max, great tutorial, I am doing something similar but I want to build a fun project for myself using airtable and spotify, is there a way for me to populate the airtable base automatically with specific criteria? For example artists of specific genre, happy to discuss on a call if it's easier
Yes! Spotify has an open API that is free to use. Chartmetric has one as well although you must pay for a subscription. Either can be integrated with your Airtable base. Fee free to book a call using the link in description.
surprised you don't have more followers and views. these videos saved my life!
Boom. I love the feedback. Thank you. Are you building tools for the music industry? Or just in general?
Does GLide allow public users?
Yes! Thats the primary use case.
I do exactly like you but the values are not displayed when I loop. Some appear without loops and others not at all. However, the variable names are correct. I don't understand
Rewatch the part at 5:14 and make sure you're referencing the child table properly. If that still doesnt work then I suggest reaching out to the Documint team using the chatbot in the lower right of their interface. They will ask for your Template ID and then be able to inspect it for errors.
This is a wonderful solution, only better would be Airtable integrating this into their forms. I do have a question in Airtable I have a % field and when using Fillout I enter in 6.25 in the field it populates at 625% in Airtable. Any thoughts on how to fix this?
I agree that Airtable would be well served to have the best forms solution in the market. Especially since most people's introduction to Airtable is from having been sent a form. Regarding your question: there are two ways to accomplish this. 1. just type in .0625 into the fillout form. 2. click Logic in the lower right, then Calculations at the top. Create a new value that divides your % field by 100. Then close out the Logic section and click into the Integrations tab at the top of the page. Hover over your Airtable connection right at the top and click into it. You will see a list of Mappings. Change the Mapping of the % Field to the new calculated value you created. Let me know how that goes!
@@relationl I appreciate the suggestions. I was able to get the calculations to work, this is better for my brain to understand when entering the form. Appreciate your valuable time, thank you!
@@cottagekeeper i totally understand that! moral of the story is that Fillout has thought if literally everything :)
Thank you so much! Certainly I'll remember to get back here if need any other help in Airtable. Got a subscriber! Please, keep posting.
You got it! Thanks for the sub! I have a fun video coming soon in a slightly longer format. But it will be good for some newer Airtable users to see just how quick some of these larger builds come together.
Quick question. A new record is created for the child object when they click submit on the subform before the whole form itself is submitted. What if an applicant closes out of the form before they complete it? Or what if they want to delete a record they just generated? Doesnt this mess with the back end?
If they don’t submit the parent form then the child record will remain orphaned. You can leave it there or create an automation to have it deleted. I just leave them there. Same thing if they unlink a child record before submitting the parent form.
Thank you. Airtable is a struggle for most no-code users. They could integrate these options of date from, to, difference, etc into simple 1 click options easily.
Hey there. I found the Formula Playground extremely helpful when getting started with Airtable. It's a great resource for learning how to do all the stuff you mentioned: www.airtable.com/universe/expHF9XTWWwAT299z/airtable-formula-playground
@@relationl Thanks for the info.
what is the purpose of the checked/unchecked + radio button?
You are ultimately going to tell Make to look at the "Unchecked" view in the Intake table at regular intervals (every hour, every day, etc) and upsert any info it finds to the Creators table. I should have included a 4th module that updates the Intake record at the and to check the box, thereby moving it out of the "Unchecked" view so the automation does not run on that record again.
@@relationl Can you make a video on this please?
Can then the submitters edit their submissions? Why with airtable and not with notion or google sheets?
Hey! Yes they can edit their submissions, and Fillout integrates with Notion and Google Sheets as well.
Underrated video
Thanks! Remember to us Condition Groups to keep this all on one automation.
Questions: How does this look if you have multiple pages, does the page break cleanly, is there a way to add page numbers on the bottom of the page and include a page header on each page? Is Documint a safe company to share my business data with? I have concerns Documint will know our business financials, clients names, phone numbers, etc. All it takes is one rogue employee to give access to my data. How do I keep my sensitive business data safe with Documint? Do they encrypt everything?
The formatting is customizable down to the pixel. That’s one of the things I like most about it. Regarding data security, you’ll have to ask them directly support(a)documint.me
Upsert now works for me, thank to your demo Max!
You’re welcome!
it would be super helpful if you make a tutorial!
Ok deal! Let me know what type of data you want to see called into Airtable from Chartmetric API and I’ll do it!
Thank you so much, you save my life :D
thats great! well done!
Hey Max, how do you get the week number with the formula?
hey Steve, try weeknum(date_field). Also check out the Airtable Formula Playground: airtable.com/appCHsByjT6czDeJu/shrHgArBZ61sNOtKl/tblI8XyshuxkqqooY/viwGzKWn7S1bEaT0H?blocks=bipdCFHjZaYzAsFzd
You're my hero, Max! I couldn't find how to do this anywhere and I got it to work thanks to you. Big thumbs up!
yeah, Upsert is a superpower. well done!
🙌🙏
Follow you from africa
That’s great! Thanks so much.
Love it!
🤗 *promosm*
This is Great! Thank you!
you're welcome!
✨ Promo'SM
Make more automation vids with chatgpt
Anything specific you want to see?
Sickle Cell Crises sucks
When the work increases but the pay doesn't 😂
You should get a copy writer for your posts.
You know one? 👍
"promo sm"
hey Ken, are you a Chartmetric API customer?