Builders Board

Hey ATCF!We wrote a no nonsense, step by step guide on syncing Airtable & Postgres so that you won't need to grow out of Airtable even as your data scales.Check it out here!

Azure/ SQL/Python export integration experience.

Hey everyone, I’m having trouble creating an employee scheduling base that has the functionality I’m looking for. Our company is a delivery service, and services close to 50 regions. For each region, there is at least one “opener” and one to two “closers”. The functionality I’m looking for: Be able to create weekly schedules by assigning employees to region shifts on specific dates Display employees in each shift based on their availability Have the ability to account for “call-outs”, which will be submitted through a form Have an easy UI for managers to create the schedule for each week The biggest problem I have run into is the date functionality, as there is no way I see to create a “week start date” function and have the rest of the week populate like in excel. This is also an issue with row/column management for me. I’m looking for someone to go over all of this for me, and either give guidance on how to

Hi!I recently made a video on how you can dynamically link multiple records in airtable to a single one using make. I know for a fact this is something quite a few people struggle with. Here's the video!https://www.youtube.com/watch?v=rWed6E8Fp0o&feature=youtu.beHere's a written guide on how to do it also:https://flexnocode.ghost.io/how-to-link-multiple-records-in-aritable-to-one-in-aritable/  

Good Evening allI have a script I am trying to bring alive. I am calling an HTTPS endpoint that returns an array of features. Each feature has a unique ID. After the initial fetch, I would like subsequent fetches to only insert new feature IDs if they are not already in the table. Each fetch from the endpoint returns everything added within 24hrs, not just new features. Therefore, I only want to insert new IDs.Table Name : lightningUnique Field Name : litIDFetch Unique Field Name : litIDHere is what I have for the script at this moment:   let table = base.getTable('lightning') let { records } = await table.selectRecordsAsync() console.log (records) let strikes = await fetch('https:********') let { features } = await strikes.json() console.log(features)   Thank you all for any help. 

Granting new feature requests, previously the domain of technology vendors, may change dramatically with the advent of AGI. Here's a simple example.Stephen Orr requested a new feature similar to the ALL() formula in Excel. I’ve seen many of his posts, and he’s sharp, so I watch his posts closely.A formula that returns a comma separated list of all values across records in a view for a given field:ALL({some field})This is a good feature request. I made a similar request in 2018 for Split(). That was 2,160 days ago. Still waiting. I hope Stephen is more successful in getting Airtable’s attention.What he’s asking for is tantamount

I keep returning to see if it's better. It's not. We try to create nicely polished content for all the great Airtable users, but this community app does not reflect the vast polish, fit, and finish of Airtable. [sigh]C'mon Khoros guys! This is content management 101.

I wasted a few hours on this so I figured i would save someone the same headache. Step 1. Create a shareable gridview link on your table Step 2. Create a Google Sheet Step 3. Click on the “Add-on” link in the main menu bar, on the dropdown select “Get Add Ons” Step 4. Search for “Airtable” and on the dropdown select “Airtable Importer by Railsware” Step 5. Install it, it’s free, but it works (I have no relationship with this company) Step 6. After you install it, refresh your Google Sheet, then go to “Add Ons” link again Step 7. Select the “Airtable importer” on the dropdown, on the flyout menu, select “Open Sidebar” Step 8. On item 4, paste your shareable gridview link and select import into current sheet The importer will only import the image URLs in the column’s cell(s). It uses link breaks in the cell to separate the URLs. If you need to remove the line breaks and replace them with a comma, Step 1. Select the column range wit

Hey everyone, I'm Ian, founder at Bracket. We make it easy to sync data between Airtable and other databases, like Postgres.Really excited to announce that after months of collecting feedback from members of this community, we've just released our totally redesigned interface! You can check out a demo in the video below, or try it yourself - most syncs take less than 3 minutes to set up :0Not only is the interface way easier to use than before, but we've released a bunch of new features:Ability to sync deletes automatically or manuallyAbility to spin up a Postgres table from scratch using just an existing Airtable tab (or vice versa!)Better monitoring and alertsHope some of you find this useful! Happy syncing 🙂

Hi there !Hope you’re all doing well !My name is Thomas, and I’m the founder of Nocodable, an online learning marketplace 100% dedicated to no code !We’re actively searching for instructors on Airtable to create courses on the platform in English.As you may know, creating and selling online courses is a great way to diversify your income sources, as well as building your audience and generating leads for mentoring or coaching you may offer !However, creating traction and finding customers for your course is a daunting task and requires a lot of efforts.Which is why we’ve created Nocodable. To create a big library of no code courses that everyone can browse, and to help vocoders share their knowledge and be rewarded for it.We’re commissioned base, so uploading your course is obvious

In the past six months, I have been building TaskRobin to save emails to Airtable. After you setup your email inbox and Airtable base with TaskRobin, you just need to forward emails that you want to save to Airtable to TaskRobin.Try our Airtable extensionI am happy to share that we have added more automation options for Airtable.In addition to automatically tagging emails, creating and maintaining a contacts table for your Airtable CRM, you can now create rules to automatically fill in your custom fields in your Airtable table as new emails arrive. For example, if you have a "Task Type" field and your incoming emails a

Airtable Devs wanted!Looking for a freelance Developer to create custom dashboards and roadmaps on Airtable.Dm for more info

 1-  Our organization operates various types of projects, each with different formats. Some formats are consistent across projects. We used the append option in Excel to compile them and bring them into our organization's master database. Is there a similar option in Airtable that allows us to append data of the same format from different projects together?  2- Projects often have different formats, and we would like to append data from specific columns of these formats into our master base. Is this possible in Airtable?  3- Different bases were created for data from different projects. If the append option works in Airtable, can it append tables from other bases into the master base?

Hi all!Wanted to share that Whalesync just added the ability to 2-way sync Airtable with Webflow E-Commerce!You can now manage all your Webflow E-Comm products from the comfort of an Airtable base 🎉We made a full announcement here but also happy to answer any questions!

We have MySql tables full of attributes, inventory, etc and want to sync this with Airtable multiple times a day. Not only new record additions, but also changes to data in existing rows. If you have the skills to accomplish a sync of record updates and row additions, please message me or provide contact details and work reference. Thanks!

Hello, we are looking for a simple inventory management base that computes runway times for parts and sub assemblies. Pretty small in scope. I am a software developer and am familiar with data structures, so I will be easy to work with, I just don’t have the Airtable chops and would love an expert to build this for us. Opportunity to extend the scope of the project into analytics dashboards etc, and projects in the future. Work with our small design brand: Studio Neat (http://studioneat.com)Reply here or email me at tom@studioneat.comThanks!Tom

I built Airtable-QnA that is easy to use and open-sourcedThe application allows you to ask questions and retrieve information from your Airtable content. Simply provide your OpenAI API key, Airtable personal access token, and Airtable URL to get started. https://airtable-qna.streamlit.app/ With Airtable QnA, you can ask queries in natural language and receive real-time answers without the need for manual searching. The application is o

Figured I would share this new capability with the community here. The team at Stack Moxie just release this cool integration with AirTable that lets you test your marketing campaigns right from an AirTable sheet so you can launch the campaign knowing it will successfully track through to your other MarTech tools!I think the use cases are probably more robust than what I initially thought about, but here was their post about it:https://www.stackmoxie.com/2023/02/15/airtable-spreadsheet-triggers/?utm_campaign=230215-Feature-Release-Spreadsheet-Triggers-for-Airtable&utm_source=referral 

Hi everyone. Just been playing around with interfaces and it occurred to me you could easily use Airtable with the record review, calendar and automation functions to set yourself up a fully functional journal, that includes email reminders. Template with instructions is available here for anyone who's interested: https://amazingairtable.gumroad.com/l/atjrn Enjoy!

Hello, is it possible to filter records based on info I have in an array (a series of 5digits codes, comma separated)  to show only records having a matching 5digits code (Single Select within a specific column)?

Hello everyone. I'm looking for an Airtable expert who can help me to create a base for my company. Basically, I run a booking agency for DJs, and I need to create a base to manage bookings. I have everything in mind already. I've created a base and included most of the features but I need an expert to master it. Looking forward to hearing from you if anyone is interested.

Our innovation center at Yale University is looking to pull our onboarding process for staff and student employees into Airtable to use automations and interfaces. Right now it's in aTrello board and Google docs. We've even got a great template to start, but my team lacks the capacity and interface expertise to pull this into Airtable. We are also interested in exploring whether or not a room reservation system could be housed in Airtable and a few other ad hoc Airtable projects. I'm looking for someone who has experience designing Airtable interfaces, who is available to meet remotely on occasion between 9am and 4pm EST, who can complete these projects by mid-July.

Hi, need some help! I make a chart on https://quickchart.io/chart-maker/ than i build a formula in airtable to pass the the variables [SUBSTITUTE("https://quickchart.io/chart/render/zm-2146d069-a493-4d97-90ad-3a4bc6766b7d?labels=" & ARRAYJOIN({items from graph 2 all},",") & "&data1=" & ARRAYJOIN({Rampa interna primaria},",")& "&data2=" & ARRAYJOIN({Rampa esterna primaria},",") & "&data3=" & ARRAYJOIN({Rampa interna non primaria},",") & "&data4=" & ARRAYJOIN({Rampa esterna non primaria},",")," ","%20")]

We are looking for an Airtable developer who can create a custom integration between Airtable and our ERP software (from ProConcept) to sync inventory levels. Our base is an AirPower template, which is feeding our Shopify website in development. The CSV generated by the ERP has only five fields: product name, reference number, EIN number, MSRP, and quantity. We need the integration built and tested in collaboration with the ProConcept developer, ideally within 1-2 weeks. There is an opportunity for ongoing work keeping things functional. :metal:

Hi everyone. Just want to share a formula to get the last element of a list of elements separated by coma. This formula also eliminates the empty spaces before and after the resulting text if there were any. I am sure it will be helpful to someone in the future.TRIM( REGEX_EXTRACT( {your_field} & ",", "([^,]+)," ) )Regards.