Builders Board

HI. My name is Stepan. I work in the field of process automation, and often use Airtable as a database for my clients. Want to start a video blog about some tricks how to make Airtable automations. I’m here to ask, what kind of integrations/automation would be the most interesting for you? Feel free to make your suggestions here. Thank you!

Indeed, views provide a very powerful way to scope and optimize access to data. However, they cannot be dynamically altered to achieve what I consider hyper-performant script processes. Here’s an example… Imagine a table (a) with a view and when a record enters that view, search another table (b) that has 45,000 records in it for a single matching key so that a linkage can be established in (a) to (b). I’m not an expert in all manners of Airtable scripting, but I think the only way to do this is to iterate across the 45000 records in table (b) to locate the record ID such that the linkage can be updated in table (a). Ironically, searching for discussions about this place me in the commentary mix here. And even then, I’m not sure I expressed the issues succinctly. Two ideas come to mind when presented with this quandary - Ideally, there should be a searchRecordsAsync() method that uses the internal search capabilities to return a record (or record collection) given a field or record

Hi All! Was directed here from another thread, as I am not a JS coder, but would love to have this code requested below to learn from and continue to work on. I am looking to run multiple search scripts in three fields where users will enter a long format answer explaining their project needs. These are populating in a request table that I connected to a form interface. I have second Airtable that lists out my talent at my agency and have created a ‘Keywords’ column that lists out all the different expertise fields and past industries. My goal is to search through the long format answers client input and connect the keywords to the best match talent in my pool. Any one available to take on this project? I have budget and am willing to work with someone to set up this script. My goal is to have this script in the next week to continue automating other parts via Zapier, which I do have experience using.

I want to get only fields in my tables through the rest API. I have tried using https://api.airtable.com/v0/meta/bases/BaseId/tables api given in the https://airtable.com/api/meta documentation but it is giving me NOT_FOUND in response. Is there a way we can get only fields for the token provided through REST API?

I’m really proud to have worked on this and I hope that it brings some of you the joy it has brought me. So if your Labour Day resolution was to stop spending so much time pressing ctrl+c and ctrl+v migrating Google Sheets and Notion files into Airtable then you might want to check out Unito, our new 2-way integrations were designed specifically to save you time so you can seamlessly connect to all the other apps where work happens. Unito.io

Our business has used Airtable to make a database for our direct to consumer manufacturing business. The good news is that our business has grown, the bad is that we are constantly fighting with the 50K record limit. What we are looking for is connecting our Airtable database to something that can handle substantially more records. Basically using Airtable as a “front end” to the larger database. Currently, most of our records are tied up in the bill of materials (BOMs). Most of the BOMs are not currently active (we aren’t currently building that product), however, we need that BOM data to accurately inform our part purchasing. We currently have a workaround using Airtable’s table syncing but that has only bought us some time and is not the long term solution. At the end of the day what we are looking for is a way to use and store far more data than Airtable can handle while keeping Airtable as the place where our employees interact with that data.

Hey Airtable community, Today we officially launched our new Chart blocks on Softr. The new chart blocks work seamlessly with Airtable, allowing you to turn a table of records into stunning, interactive charts which can be created in a matter of minutes. To provide you with a quick example of what can be done with the new Chart Blocks check out this example of a building in public page to share your metrics. This template is now available to use today. We are continuing to iterate the new chart functionality and will be releasing a number of further improvements in the coming days. You can learn more about Charts in today’s update found here. We can’t wait to see what the Airtable community will use this new functionality for.

(Sept 2021) Hi, all! I’m looking for a consultant to help build out the text-based communications and ordering capabilities for a food pantry that serves 40,000 people a year with mobile and partner-based services across New York. We’ve piloted with my (very basic) Airtable and Twilio skills, and now we need to step it up! I have a light tech background, but I’ve managed IT and product development teams for many years and bring great respect for solid technical skills. If you’re flexible, reasonably fast, a good communicator, and interested in helping lots of low-income and older New Yorkers get connected to the healthy, delicious food they need, join us!

Hi all, My company is currently looking for an Airtable developer that would be able build our company’s financial tracking system. Preferably looking for someone who has worked with both entertainment and finance companies. We’d also love to work with a developer who can better automize the workflows we have in place. If interested, please email me at amelia@2am.com Thank you

Hello, I just made my first Script app writing my own custom code :tada: and wanted to share :blush: Context: I am working with a base that has gone through several iterations of development and am trying to resolve some contradictory data sets. Specifically, for a directory of people who get assigned a “level.” There are five different fields to compare and resolve so as to make a single source of truth for each person. My fiirst step is to identify where there are mismatches across the five fields (a rollup, two lookups, and two single-select fields). My first thought was to use a nested IF() ƒormula, but I found it difficult to construct the matching logic for the fields values and for when any them are without values (i.e. blank). My next thought was to use an array formula to make an ARRAYUNIQUE() out of an ARRAYCOMPACT() values (i.e. remove the blank values, then look for unique values). To my surprise, the Array functions are only applicable in Rollups or when the field

Hi, sometimes button format is not convenient, when you have to assign scripts, related to table, not records. i think that buttons needs at least be possible to show/hide in different records. And change label. And color. And script assig… okay, that could be done by “Switch” in single script :grinning: Well, I’m not with a complain or proposition, just want to share example of using Singleselect for UI. Triggered by automation, returns to default state “CHOOSE ACTION” (other records default is ‘inactive’)

Hi there, our company is searching for a developer that can help us automate our workspace in AirTable. For more information about what we are doing please contact me personally at: luka@yougrowpromo.com Best Regards, Luka.

If you find yourself collaborating with your team in the same base, it can be helpful to see the latest updates and when things were modified to make sure everyone’s on the same page. In this video, Airtable’s Becky Mak jumps into a base to show you how you can surface those updates. Additional resources: Support article: Last modified time field Support article: Use automations to timestamp status updates Support article: Record-level revision history overview Support article: Last modified by field If you know of other resources that come to mind, drop them in the comments below! We want to see your favorite Airtable tips! What’s your favorite Airtable feature? We want to know - share your videos on social and use the hashtag #AirtableAnswers so we can share them with the Airtable Community. (There might be swag involved… :eyes: )

Hey everyone! It’s Luannie from Pory. We’re super excited to kick off our how to build series using our favourite tool Airtable! Our first tutorial is on creating a members portal where I’ll be covering how to: :hammer_and_wrench: Navigate Pory (we’ve given it a lot of love) :electric_plug: Connect and manage users via Airtable :love_letter: Generate invitation links to existing members Let us know what you think and what you would like to see next!

Would like my client to be able to change one or 2 columns in the sharable view of airtable without making them a collaborator. Mini extension is too basic. I have embedded the airtable on a members page of my wix website. I would like for my client to be able to write questions or feedback about information viewed from the airtable

Hello everyone, I am running a cleaning service, and I want people in the community to request things to be cleaned. I use QR codes to list all active jobs as a read me file for the office community. I have a submission form embedded on the read me where the cleaners can check done all the tasks they’ve cleaned. I also want to add another recordID that has a form URL for people to check jobs they want the cleaning team to come in and clean that night. If anyone has any ideas, please let me know!

Hey Airtable community, It’s time for this weeks updates at Softr. We have rolled up a number of new features this week we would love to share with you. New Templates Firstly, we have two stunning new templates. The first one is an inventory tracking template created by our partner agency VisualMakers.de. This template is perfect for a small business to track and manage all your products, orders, manufacturers and purchase orders. Next up is our out of the box community template. This template is packed with advanced functionality and is perfect for anyone looking to create an online community. It includes a modern, minimal design aesthetic, community directory, a list of events and spaces and the members attending each event + loads more. Transfer Ownership You can now transfer ownership of a Softr application from your dashboard. This is something a number of agencies and creators have asked for. Now you can create Softr apps and transfer them to new owners in a matter of seconds. Th

Need to build a CRUD app on top of the Airtable database? UI Bakery handles it. Development takes minutes. Check it out https://uibakery.io/airtable-crud-builder

Hi! We are using Airtable more and more, but we have 2 projects that need someone who knows how to do a lot more with what Airtable offers. Project #1 - Level of Effort - Updating, Approving, and Sharing with multiple people. Currently we use an Excel Form (one form per person) that contains various types of information — employee name, employee supervisor, employee salary, reporting time period (quarterly or every 6 months), budget #s, budget descriptions, and the percentage allocated per month to each budget #. Every month must total 100%. And budgets also have start and end dates. Once this information is entered, it needs to be sent to the employee, the supervisor, the finance analyst, and sometimes a unit head. The supervisor needs to approve, then the analyst, then a unit head if applicable. If changes are made, the review process must start all over. Would love to run reports/views that identify those with any gaps (less than 100%) and when those gaps will occur. Would also like

Lennar, one of the nation’s largest homebuilders, is looking to contract-to-hire a full time associate to help manage their Airtable processes and reporting for the company. Job description can be found here. Please send resumes to: Ashley Max Director of Digital Content ashley.max@lennar.com

Looking to dial up your executive summary email process? In this video Airtable’s Head of Content, Margaret Jones, showcases how you can create send off emails summarizing all the content that’s shipping in the following week. Margaret uses this email to let stakeholders know about what’s coming in the pipeline (and share the amazing work her team is accomplishing)! Additional resources: Support Article: How to create email digests with automations Template: Content Calendar From the Community: Airtable Automation: How to Automate Email in Your Base & Save Time Support article: How to automatically send approval emails without leaving your base We want to see your favorite Airtable tips! What’s your favorite Airtable feature? We want to know - share your videos on social and use the hashtag #AirtableAnswers so we can share them with the Airtable Community. (There might be swag involved…)

Hey Airtable community, We have a major update on Softr to share with you today which i think you will love! You can now allow your users to edit Airtable data from with your Softr application. You can set up this ability in a matter of seconds starting today. The new editing functionality opens up an infinite amount of new possibilities with Softr and we can’t wait to see what you come up with. To give you a quick overview of this new functionality we have put together two short tutorial videos which you can check out below. We will be continuing to roll out the edit functionality to other block elements on Softr over the coming weeks so keep an eye out for future updates. • Softr editing Airtable records (all logged-in users) • Softr editing Airtable records (One user group can edit, the other can’t) Lastly, the edit permissions functionality is currently available on Softr’s Professional and Business plan members. However, we think everyone should have the opportunity to try this ne

-moved- to Products Suggestions.

Hey folks! Super excited to share with you that we launched Heep on Product Hunt today! We want to make it the best place to hire experts in modern no-code tools whether it is building your app, website or workflow automation. Your thoughts & support matter a lot for us, and we really would love to hear your feedback on Product Hunt today :eyes:

I am arranging 10 separate small group meetings for our CEO. I’m using Airtable to set up the sessions and send people to a form that allows them to select one of the meetings to attend. The meeting attendance is capped at 15. That part works okay. The problem I’m running into is how to send an email acknowledgement correctly confirming their date and time, and an Outlook invitation with the .ics info that will correctly drop it into their calendar. I’m trying to use Integromat to add the email portion and the calendar function but none of the date / time info is correctly rendering, no matter what I do. Need to get this out the door by tomorrow and I’m at a bit of a loss. Anyone have any expertise in this area who would be able to help me resolve this?