Thanks Gareth!

Grab my Free Automation Webinar 👉👉 gapconsulting.io/webinar-registration 🤓🤓 Start a free trial with Fillout 👉👉 fillout.com?ref=gapconsulting ✨✨

What are the pros and cons of separate contact and client tables. I do business to consumer and business to business so I have set up a table that links backs to its self so contact and Clients can be on the same table. If I set it up this way is there a failure point I’m not seeing?

Get our *FREE AIRTABLE CRASH COURSE* here 👉👉 garethpronovost.com/airtable-crash-course ⚡⚡ Follow along in Airtable here 😍😍 airtable.com/invite/r/v0eI3ASY 🤓🤓

Is it still true, 7 months later, that AT's Interfaces can only be readable and not usable when embed unless paying for each user?

This was a great video , 🎉

Hi, I have enjoyed a number of your Airtable videos, thank you. I have a usability problem I wonder if you can give me any pointers on: We visit homes to help people reduce carbon footprint and save money by taking energy efficiency measures. On every visit we recommend or take one or more actions, each of which has a specific ‘deliverable’ that holds standard values for savings etc. The entity relationship is: • Visit to action = 1 to many • Deliverable to action = many to 1 We have many different deliverables, over 200. When adding a new action, which is usually done using a form that is prefilled with the correct Visit, the Deliverable field presents a long list that is in seemingly random order. I cannot find a way to sort or group the selection of links. Interfaces do not seem to help. This must be a common issue . . .

Thanks, Gareth for taking the time to make a video on these advanced functions; very helpful.

Always on point Gareth! Happy Thanksgiving!

Can you format the number in percent form?

Thank you so much Gareth!

Im building a database website for a company on softr with airtable as the backend and in project details i have their data added into a items details block and they can edit whatever data comes and goes out of it well what they want is a way to tell what user on the website added or removed something from this so like who last modified this information? Can do think theres a way to pull this off?

Get our *FREE AIRTABLE CRASH COURSE* here 👉👉 garethpronovost.com/airtable-crash-course ⚡⚡ Follow along in Airtable here 😍😍 airtable.com/invite/r/v0eI3ASY 🤓🤓

As someoe who has had a love/hate relationship with Notion for years... I really think I need to start using Airtbale after seeing how fast and intuitive it looks from your video!

Are you using ply for anything else?

Damn! I was really hoping it would be free for external users to use solutions developed by licenced users, in the same way Microsoft 365 developed apps are, in the main, free to be used by guest users. I have a simple membership database of about 1,000 contacts and wanted those contacts to be able to update their own data. $8 x 1,000 'Portal Users' is not even close to being a viable proposition! Great video, btw! I'm just disappointed with AirTable's direction on this.

Thanks for the video. Can't you do this with Fillout?

If i want to the total numbe will be fix in a number what can i do?😊

Try Ply out for yourself! 😍😍 ply.io/customer-features?ref=7ctgw 🤓🤓 Get our *FREE WEBINAR* here 👉👉 garethpronovost.com/webinar-regsitration ⚡⚡

Thank you. This was a really great start to understanding the basics of building Airtable formulas!

This is great but the pricing is not. I would sign up if it was cheaper

Is there a way when you edit the video steps it also updates the step by step and the audio? I'm struggling to have to update all 3 areas. Any help is appreciated!

Thanks for this great tutorial! I was unable to finish though, got stuck on minute 14 where we are in the content part (in the Google Docs button, under properties window), click + then find records, select grid, it opens up all the fields to show, the 'insert' button does not activate no matter what I select there. I tried finding out why in many ways but did not get an answer... Does anyone know how to fix it?

This is amazing, thank you so much! I've build some test invoices by following your video and it worked well (I did had to play up a bit to understand that I will always have to create a new invoice number first, then go to line items and select that invoice and add lines, etc.), but now I would like to send it as an attachment with my company logo, etc. How do we do that? You mentioned automations, is that an automation case (sorry for my ignorance)?

This addition is 🔥

Still pretty expensive. 15 customers is not a lot.

I feel like this feature is extremely limited to users of Airtable. Hard to see the use case and benefits over other options. We technically can't have other company members use it that don't require full access. Ok, thats out (unless you create external emails, but not Gmail 😆) I feel like most companies would have a lot more external users/customers than a handful. So alternatives like Stacker or Softr are going to be cheaper. Or just use Airtables other own features like share views, interfaces and forms to view and change/update data. If this was aimed at companies for employees access/use, I believe this would be awesome. Nice and simple views, buttons, layouts, that would be effective. Guess we'll see. Or I could be wrong and this would benefit many users and their external guests 😅

HI! I've been going crazy for three days I have to synchronize trello with airtable and I'm already stuck in a simple scenario like yours airtable modules both seacrh and upsert record don't filter things for me with the formula as yours..

Love this. So excitied for this feature. Saves having another app to do this job.

Nice addition to Airtable. Still expensive though, and why no gmails for user login🤔

$1200 a year at the lowest (15 portal users) is just wow. They obviously have an agenda here...

Mny tks Gareth. What advantages does this offer compared to Softr or Stacker?

I cant wait.. Just signed up. I've been trying to find workarounds for this for a while! I have installers who access just their daily jobs and fill out a completion doc and upload photos. Paying $54 a month for them seems wild.

So if you take the example of customer service If I use Airtable to log cases and have 250 customers, I have to pay 250 x 8$ ?

Thanks for the intro to portals!

It's a good idea, and I'm glad (as a paying customer) they are investing in improvements! I would say15 users seems like a lot to buy for many use cases. And not allowing free email services (like gmail) to login to the portal would also rule out a lot of people. Why not be more inclusive ?

Thanks, appreciate your work!

Get our *FREE AIRTABLE CRASH COURSE* here 👉👉 garethpronovost.com/airtable-crash-course ⚡⚡ Follow along in Airtable here 😍😍 airtable.com/invite/r/v0eI3ASY 🤓🤓

I can't get the search record module to work as if he wouldn't perform the formula for me. My case is almost identical to yours, except that the first module is a trello module.

How do you make it so the dates are only counting work days?

You are a talented imparter of knowledge. I replicated your tables, followed your instructions carefully, and wow , it suddenly makes sense. Thanks!

Hi Gareth, thanks for the video. When using this form in Softr (as a url link, NOT as an embed), how can I pass through the Logged in User's ID to the form using a URL parameter? These forms have URL parameters that make each form submission linked to a particular piece of equipment, but I also want to capture the information of the user submitting the form automatically. Thanks!

Have you had a chance to look into Web studio as it's a true website platforms that allows you to connect with DB's like Airtable .. so tutorials on those would be great. A container block sounds like a pretty basic feature IMO .. but maybe i'm not the target audience.

Follow along with a free trial in Softr 👉👉 softrplatformsgmbh.partnerlinks.io/thnhee Grab my free automation training here ⚡⚡ gapconsulting.io/webinar-registration

Hey mate can you please do a demo on conditional forms relating to the question itself. i.e. If I am a user filling out the form, and I select a category from first question (e.g. Cars), then in second question I should only be able to view fields in the drop down that relate to that Category (e.g. Toyota)

Thank you Garth

This is helpful on the Automation side. Helps me figure out a wrinkle I hadn't quite tackled yet in my Airtable PM journey. One related issue I'm struggling with, I'm curious if you've got another video or thoughts on: it's helpful for my projects to see how the schedule changes over time. Is there a way that you recommend for tracking versions of the full schedule, or visualizing how task due dates and durations have changed over time?

Sign up for Noloco here 👉👉noloco.io/?via=gareth 🚀🚀 Get our *FREE AUTOMATION WEBINAR* here 👉👉 garethpronovost.com/webinar-registraiton ⚡⚡

🔥

Thank you for providing clarity on how SmartSuite dashboards work 🙏