Builders Board

Ever needed to get the initials of a name that had more than first and last name plus some weird dashes and what not?Try this formula, which can also be used to get the firstname and lastname with a workaround of find() and search() which only returns the position of the first space in the stringLEFT({Name},1) & LEFT(REGEX_EXTRACT(Name,"\\s(\\S+)$"),1) I hope this helps!

Looking for an expert to support in building a scenario on make.com by integrating different modules including : rapid api and airtable. 

I am seeking an Airtable Solutions architect to help finish the remaining work on a tool. Much of the requirements gathering has been completed, and a wireframe has been built. The tool is designed to help facilitate payments from non-profit entities to vendors working on one or more of their projects. This tool will eventually move to custom dev but is being prototyped inside of Airtable.Remaining Work:Finalizing interfaces and applying proposed architecture to the current base (alternative, migrating existing data into the sandbox environment)Determine optimal data flow across Airtable, Ramp, and **bleep** and create the accompanying automationsMake, Zapier, or custom scripting can be used for thisThe ideal candidate will be experienced in Airtable, but have the ability to understand processes and architecture from end-to-end. Knowledge of accounting concepts is a plus.

Hey Airtable Community!  🎉 The countdown is officially ON for Daretable, the conference for Airtable enthusiasts happening in New York City on October 25-26! Whether you're a newbie or a seasoned user, this event is your chance to level up your skills and network with fellow Airtable enthusiasts. 🎙️ Are you attending Daretable? Share your expectations, questions, and enthusiasm for the conference in this thread for a chance to earn an exclusive Community badge! We'd love to hear what sessions you're most looking forward to, what you hope to learn, and maybe even who you're hoping to connect with! This thread can be a great place to start making connections with each other! P.S. While I personally can't attend this time around (and will be living vicariously through t

Over the past three years, I’ve designed several systems for my school division using Airtable, Softr, and Make. Other divisions have expressed interest in developing similar systems, but I no longer have the capacity to take on these projects. For example, the curriculum office is looking to create a platform that allows teachers to submit requests for professional development. The system would manage the entire workflow—from approvals and notifying stakeholders about decisions to adding hotel and travel information, per diem tracking, and collecting details about the training (e.g., objectives, alignment with the school’s mission and strategic plan). It would also allow for tracking the outcomes of the training.The system will be built using Airtable as the main database and Softr as the interface—similar to what I’ve implemented over the past few years, but designed by an expert.How much do you think a service like this would cost if outsourced? Specifically:

Ok, so first up i love airtable and think it is possible the greatest app ever made, i respect airtable and greatly appreciate the free version that they have given to us, it is AWESOME. I am not trying to abuse this generosity and i am not personally using this “Hack” as for reasons that will become obvious, the “Catch” makes it unusable for commercial use / the wider public. But works for personal uses as long as you are logged into the airtable account that has the videos uploaded. Same works for images and files i imagine. The Process Step 1: Upload video into airtable attachment field Step 2: Open this video so that you can see it playing Step 3: Right Click on the video and select “inspect” this opens up the coding for the website Step 4: Locate the web link for the uploaded video file, should be close to where the inspect element has taken you (Or Ctrl + F and enter a distinct word from the video name)

There has been quite a lot of interest here about sending PDF documents from you base automatically. Integromat recently introduced a PDF ‘app’ which converts HTML into a PDF and I thought I would see what could be achieved in a real world type scenario. I’ve written this up in a blog post which you can see here: Database Resources Sending a PDF document from your database with Integromat | Learn more about... Ideas and reviews of Cloud Database platforms

Looking for an airtable developer / expert to help figure out a solution to create Adobe InDesign documents auto-populated with airtable data.  

Hey everyone!We’re excited to announce that last week we released an Airtable integration for our static forms on Static.app.What does this mean for you?Now, you can easily collect form data by adding a simple code snippet to your static pages:<form static-form>...</form>Once that’s in place, all you need to do is connect Airtable, and you’ll start receiving your form submissions directly in your Airtable account.For a step-by-step guide, check out this article.We hope this makes your workflow even smoother!Let

Here're a few 'Run a Script' Action automations for integrating with MailChimp (create contact, tag contact, archive contact). In all examples, be sure to add your own values for mailchimpAPIKey and audianceId constants and add your own input variables e.g. email, firstName, lastName, organisation, tag etc.Note: these automations send the actual email address across to MailChimp instead of using an MD5 hash of it, as is recommended by MailChimp. Whilst these scripts are not necessarily insecure, the transport is still TLS encrypted (HTTPS), sending an MD5 hash is still a more secure method. CREATE A MAILCHIMP CONTACT// API Key a

https://developer.ongoingwarehouse.com/REST/v1/index.htmlWe are looking to migrate to a new WMS, and want to push product information from Airtable to the WMS when the information is updated in Airtable.An estimate on hours/cost would be great.

Hello everyone 👋Powersave, my chrome extension to quickly save to Airtable right from the browser has just been updated.It now provides custom autofill configurations. You can configure different strategies to map values from websites to your fields:Pre-configured exact valuesExtracting meta values from the page's headUsing CSS selectors to pull values from the page bodyContextual reading via AIIf one strategy doesn’t work, you can set up a fallback. Powersave will try one strategy after another until a value is found.The other functionality such as bulk saving and updating records right from the browser has been improved.Big thanks to anyone giving it a try 🙌 Feel free to reach out to discuss any saving workflow!Martin

Hello,My team uses the Page Designer extension to export pdf files for our customers. Until recently, the urls were active when exporting PDF files, but now the urls no longer work. We absolutely need them. Could you please help us? Thank you in advance,

Hello Airtable Community!I'm excited to share a project that's been around since 2020, but I realized we hadn't directly shared it on this forum yet. It's called BaseQL, and it's a tool that I think could be really useful for Airtable users who are looking to build more complex applications or integrate Airtable data into their existing systems. Essentially, BaseQL provides a GraphQL API for Airtable to simplify the process of building custom applications and integrations using Airtable as your database.For those unfamiliar with GraphQL, it's a query language for APIs that allows you to request exactly the data you need, nothing more and nothing less. This can be particularly powerful when working with complex data structures like those we often create in Airtable.Here are some key features of BaseQL:Automatic schema generation: BaseQL creates a GraphQL schema based on your Airtable base structureSeamless integration: Allows you to leverage

Hi, How can I make that when a new user signs up he gets a unique ID in the Accounts table and every time he adds a new record in other tables his ID shows in the column?

Hello!When I open the extension Page Designer, I cannot edit the preferences, i cannot do anything but close it.Any ideas?

We are experimenting with Airtable as a project management tool for our Graphic Design Firm. Working well so far, until we get to expense tracking. It’s easy enough to create a table to track individual expenses and link them to any open job in our “jobs” table, but when it comes to billing, we need a single document that captures ALL the expenses related to a job and presents them together in a report much like the attached “Cost Sheet”, which we currently produce manually for each job in Excel. Here’s what we need. I’d like to automate the Cost Sheet data entry process so that, at a push of a button, any member of my team can generate a pdf with this same info, and with data pulled from Airtable records. All the user would have to do is select a “job” and all expense records linked to that job would be gathered up and processed. Each expense record would be listed as a row in the table (like the highlighted rows shown in the example). In addition, header info (like that sho

So, forms just got the option “Collect respondent email addresses automatically (sign-in required)”. When this option is checked and people open the form URL, they will be prompted to sign in with Airtable or make an account. After that, they can fill in the form and the email address they used to sign in or to create a new account with, will be stored in a auto created “created by” field in your table. This opens up the possibility to let people change their data, using their email address as a unique identifier. When a record, let’s say a client record, contains an email address, you can crosscheck this with the auto filled in email address in the “created by” field mentioned above, by prefilling and hiding it in an email field in the form. Via automations you can access the underlying email address from the “created by” field and check it against the one in the

Airtable work needed for ongoing development of various platforms communicating with Airtable. The below is one of many projects we are developing. BACKGROUND: We are using Airtable to track delays in time-sensitive projects with legal ramifications for time overruns. Each new record (documenting a delay caused by other outside collaborators) is currently being sent out via Zapier/Gmail with URLs in the body of the email to the entire table (via private link) and to the record itself. This is a good first step for notifying our clients and documenting the delays. But since this line of work has the potential to go legal if the projects go past their contracted completion dates, we need the emails to serve as proper documentation of the delays. The problem: Emailing URLs that point to dynamic data that can always be altered by us (as the Airtable database owners) wouldn’t give us a strong legal leg to stand on should contracts ever go to court. NEE

Posting this here for anyone else who might find it helpful. While there are some great extensions for geocoding, I needed to simply convert an address into latitude and longitude and had a hard time finding a script to do it in Airtable + Google Maps API. I found this awesome script but had to modify it to only run on a particular view so that it didn't hit the automation / script limits. Here's my version for anyone looking for a way to geocode the record once it hits a particular view: Create number fields called Lat and Lng, get a Google Maps API key, create a view of records that have Address, but not Lat that can trigger an automation. let table = base.getTable('<TABLE NAME GOES HERE>');let view = table.getView('<VIEW NAME GOES HERE>');let result = await view.selectRecordsAsync({sorts: [{ field: 'Lat',

 One of my clients, an American production company, was spending a lot of time on invoices to the detriment of their high-value work – the production of corporate videos and ads. Consequently, to help them refocus on their core mission, I created for them a set of automations that streamline their invoice management system: data entry for inbound invoices, document generation and sending for outbound invoices. Those automations helped them reclaim around 10 hours of work per week. You can see what I built in 👉 this Loom

Hi! I am brand new to Airtable (and admittedly, brand new to the tech world in general), so I wanted to share my first project and get some feedback/suggestions. Some background on the project: My dad’s company is built almost entirely out of google drive and he is wanting to start transitioning over to Airtable to automate some processes that are currently being done tediously by his HR team. One of these tasks is keeping employees’ contact info updated regularly. Right now, this is being done by HR reaching out to employees individually to see if their info has changed and then manually updating in google sheets. Current Project: Import current employee info into new Airtable base and set up a form to be emailed quarterly to all employees which will allow them to change any information and update their record automatically once this form has been submitted. Step 1: I imported data straight from google sheets i

Hey there 👋Anyone using Airtable and Asana?We’re slowly launching our new tool, Syncgrip, and we could really use some feedback from folks who are already using these platforms.Syncgrip lets you sync data between Airtable and Asana in real time, and we’re planning to add more services soon.If that sounds useful, check out this quick demo to see how it works.The Beta is open to everyone, so feel free to try it out at Syncgrip. We’d love to hear what you think!Cheers!

Hello, we are a small music festival non-profit organization. We've been using Airtable for a few months. We are looking for a consultant to help boost our use of Airtable,Here are a few things we need Airtable to do:. Base design and management. Workflow automation. Assist in building a project management/planning tool in AirTable.We are based in South Brisbane Australia. We need you to physically come to the office for 4 weeks. Please respond with your experience/background and rates if you are able to help with this.ThanksBreeze

Hello, we are a very small non-profit and we've been using Airtable for very basic functioning for the past few years. We are looking for a consultant to help boost our use of Airtable, including tracking inventory, purchases and programming information.Here are a few things we need Airtable to do:Track project status/project management/to do tasks by employeeFeed assigned tasks from one base into another baseAuto-input purchases from our Jotform order formTrack used and unused inventory based on purchasesCreate contacts for participants based on purchase order historyPlease respond with your experience/background and rates if you are able to help with this.Many thanks,Christine