Видео

you are welcome!

@@David-o3y7e thanks so much for you kind words. The Reporting table allows you to utilize the List View Hierarchy feature, which is a very elegant way of displaying the release schedule. You could also group by the Week field if you want. The truth is, a Reporting table used to be more important because it used to be the only way you could report data by time period. Now Airtable has the Dashboard page which does all of those calculations for you. I sometimes put things like Budget Categories into its own table in order to: 1) allow the client to add and remove options easily, and 2) assign attributes to each item like “Bucket” which can then be used as conditions to filter a Rollup field. I.e. how much money did we spend on Marketing? To accomplish this you would lookup the Bucket field in the Budget Line Item table from the Budget Category table and Rollup all Budget Line Items where “Bucket (from Budget Category)” is “Marketing”. Now your system is infinitely scalable. 😉

@@relationl Incredible. For those of us who are just starting out, the difficulty often lies in being able to visualize the potential of the tool, but following your guidance makes everything much clearer. Thank you so much for being the beacon that guides us through the sea of possibilities with Airtable!🙌

@@David-o3y7e you are very welcome.

@@ellieriversmusic thanks so much for your comment! This series shows you exactly how I build Airtable systems for major record labels. If you ran your business as an independent artist using this system, and then got signed by one of my clients then it would be a smooth transition!

@@nickcross410 hey! You want to create a form in the Run Log table that includes the Person field and then use the URL from that form to construct a prefilled version in a formula field on the People table. The field you want to prefill and hide is the “Person” field. This will give you a unique Run Log form URL for each Person to use to log their runs. support.airtable.com/docs/prefilling-a-form-via-encoded-url

Hey there, this is possible! Here's the support article that shows you how to add the Export as CSV functionality to your Interface List Views. Search the page for "Exporting interface data as a CSV", its toward the bottom. support.airtable.com/docs/en/getting-started-with-airtable-interface-designer

@@김상은-j3o I’m not sure I understand what you are asking.

@@sifisodhladhla8060 thanks for your comment! I would rather you rebuild it from scratch following the steps outlined in the video. Is that something you’re willing to do?

He there, check out this video. It should answer your question: ruclips.net/video/By7P_maAPSI/видео.htmlsi=uUbcupAQ1RWAyol1

Hey Mosh, no I am not. I use documint.me for Airtable to pdf automations.

Hey there. I can’t help with that unfortunately. Good luck!

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.

😉 new since Oct 2022 and it’s only really started to shine in the last 6 months.

Hey sifi, check my channel from April 2023. Here’s the link - > ruclips.net/video/KPu5urMAKHA/видео.htmlsi=En-p30BqTsVOAUWx

genius! i was not aware of that.

You are exactly right!

Hey there. Yes we do!

@@relationl let me have your contact email address, I will talk to you further

Excellent!

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.

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

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.

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.

Boom. I love the feedback. Thank you. Are you building tools for the music industry? Or just in general?

Yes! Thats the primary use case.

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.

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 :)

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.

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.

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.

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?

Hey! Yes they can edit their submissions, and Fillout integrates with Notion and Google Sheets as well.

Thanks! Remember to us Condition Groups to keep this all on one automation.

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

You’re welcome!

Ok deal! Let me know what type of data you want to see called into Airtable from Chartmetric API and I’ll do it!

thats great! well done!

hey Steve, try weeknum(date_field). Also check out the Airtable Formula Playground: airtable.com/appCHsByjT6czDeJu/shrHgArBZ61sNOtKl/tblI8XyshuxkqqooY/viwGzKWn7S1bEaT0H?blocks=bipdCFHjZaYzAsFzd

yeah, Upsert is a superpower. well done!

That’s great! Thanks so much.

you're welcome!