Builders Board

Hey Airtable Community! I run a very small business and have been using Airtable to manage my order fulfillment processes. I love Airtable, but realize there are lots of beneficial Airtable perks and integrations I am not aware of and would like to speak with a consultant of sorts to help us optimize! Please reach out and let’s start a conversation about working together.

I’ve solved for how to use a list of ID numbers to highlight the rows with those ID’s. Search only lets you identify one row, and filters have to be chained together one after the other. When you have a table with 1,000 items, and an external source gives you a list of 50 ID’s that all need the same update how do you select them? My solution requires adding a formula field. By pasting all of your ID values as a string literal to search for that rows ID in you can create a flag that then lets you filter a view. Here is an example of the formula: SEARCH( Identifier, “12345 qwerty 292303 zx11k9i2”) In this case Identifier is the name of your ID field in the table. Each row of your string (you should be able to paste a column from excel) is one of the ID’s you wish to modify. The result of this will be a column with blank rows and arbitrary numbers. The number is the location in your pasted string where the ID was found but that isn’t important. Next you will probably want to create a view

Hey everyone! I wanted to share a guide I wrote today on how to create a Slack reminder todo app. It takes advantage of Airtable’s neat Trello-style Kanban view for management, and as a bonus, you’ll catch a glimpse of the start (and probably end) of my poetry career. You can see all the code as well as fork and deploy your own working version onto Autocode from the link. Would love to hear what you all think! Build a Slack Reminder Todo App (slack/slack-airtable-reminders) · Autocode Build a Slack Reminder Todo App (slack/slack-airtable-reminders) · Autocode View and Fork this Source Code on Autocode

Hi, Are you up for a great project with Airtable? My budget is 1,000 USD for this project. This is a Lead Distribution project. Which means that the Airtable will store new leads that are coming in from Typeform. The lead details will then be sent to Clients through SMS and the Clients will be given the option to purchase the Leads contact information. If the Client agrees to purchase the Lead the full Lead details will be shared with the Client. This project involves: AirTable Zapier Probably or React/Vue.JS Twilio/Sendgrid/Google Distance Matrix API integrations And any other integration I may have missed Please find the links to the Airtable template that I am working on and also the workflow (as references). I am happy to go on a skype call so we can go through the scope and we can clear any questions. AIRTABLE: https://airtable.com/invite/l?inviteId=invbEzvMj7WHotoWA&inviteToken=2de088df57b16f3561911b5773dd9cceba54903632b35a212574a65c2ef3b3e8 WORKFLOW: https://tinyurl.com/y29

I recently redesigned one of my personal Web sites - an art portfolio - using an Airtable base on the backend. If you’re interested, you can check it out here: http://art.timdietrich.me The site is PHP-based. It pulls all of the artwork (including the information about each piece and the images themselves) from the Airtable base via the Airtable API. It also uses Stripe to handle credit card payments, and saves the orders back to the Airtable base. And for email notifications and receipts, it uses Mandrill. More information is available on my blog: http://timdietrich.me/blog/airtable-based-art-portfolio-site-launched/ Thanks for checking it out - and let me know if you have any questions about it. – Tim

Hello! We currently use a Filemaker database to create and track complicated schedules (multiple hard-keyed start or deadline dates, dependencies that work forwards and backwards, 100 +/- tasks). I am looking for alternatives to that database and Airtable looks like a good solution. I need someone to build the initial schedule framework for me. Ideally the consultant would also train me on both using the framework and adapting it to additional schedule types. Thank you, Gailen

In response to a long-running post about needing a find and replace function here: Would love a find/replace option! Product Suggestions I am adding my own request to this list. Not sure why it is still missing, this is an essential database feature. Here’s a script that does just that: // This is free and unencumbered software released into the public domain. // // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. // IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR // OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, // ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR // OTHER DEALINGS IN THE SOFTWARE. // // AUTHOR: Jonathan Bowen (www.dragondrop.uk) // SCRIPT: Script for Airtable script block to find and replace text // DISCLAIMER: // - T

Hi, For a company that sells adventure tours I want to create Airtable that will replace 12 excel sheets. Excel is used to track enquires, clients, create offers and invoices, assign guides to tours, track availability, etc. I am interested in hiring a professional to help me build such Base. I am interested what would me approximate price for someone to build this. Thank you, Pjero

Hi there! I am working with a company that is using the Page Designer block in airtable in a unique way. I use it to make individual “profiles” of possible applicants out to my customers. I do not have a high number of applicants creating profiles (maybe 3-5 a day). So I go through and tweak/edit each individual profile layout on my own. But I run into a problem when I go to save the individual profile that I finished editing as a PDF. I have certain topics/fields bolded on the airtable block, and when I hit the “present” button it looks exactly the way I want it to. But when I press print to then save as a PDF, the bolding of all the text boxes that I’ve chosen to be bold, goes away. And I cannot get it to save looking like how it needs to. I have a windows working on 10, and one of my coworkers has a windows with windows 10, and one has a macbook. The macbook does not have this issue, but the other person with a windows does. This being fixed for us is paramount to running the busine

We need to be able to mass add additional information to our contacts and trace the date this info is added. We do not want to update their information, but add to it. We currently have 400 lines and need to add info to these lines 6-10 times a year. How do we go about doing this? After we get that info connected to each contact we want to be able to visualize their progression over time. Can someone help me with this? For example, John Doe joined our club made up of 400 members. Part of this club is you can participate in a class and/or join a support group. Our base is made up of the people who are part of the club. Our first set of data (pulled in 1/20) is an import we inputed from our database that shows 200 of the people that joined the club participated in the class and 150 of them joined a support group. We pulled another report from our database that includes attendance for the class and support group in 3/20. We noticed that 100 people were no longer in the class and 125 were

Hi - we’re a small size real estate investment company that is looking to migrate over to Airtable to manage our Sales and Marketing functions within our business. In addition, we currently have an Access Database that we use to generate Excel Reports that output investor returns. From what I understand is possible with Airtable, we can utilize the database functionality of Airtable to generate these reports. Anyways, I’m in charge of Business Development for our company and have no idea where to begin in this process. I’m looking to speak to some consultants to potentially help with the design/structure of this system. If you may be of support, let’s schedule a time for a call! We’re located in PST on the West Coast and would prefer someone in this time zone (but it’s not a deal breaker).

Hi, Are you up for a great project with Airtable? Price and time frame can of course be discussed. This is a Lead Distribution project. Which means that the Airtable will store new leads that are coming in from Typeform. The leads will then be sent to Clients so that they can buy the Lead. If the Client agrees to purchase the Lead the full Lead details will be shared with the Client. This project involves: AirTable Zapier Probably miniextensions.com or table2site.com or React/Vue.JS Twilio/Sendgrid/Google Distance Matrix API integrations And any other integration I may have missed Please find the links to the Airtable template that I am working on and also the workflow (as references). I am happy to go on a skype call so we can go through the scope and we can clear any questions. AIRTABLE: https://airtable.com/invite/l?inviteId=invbEzvMj7WHotoWA&inviteToken=2de088df57b16f3561911b5773dd9cceba54903632b35a212574a65c2ef3b3e8 WORKFLOW: https://tinyurl.com/y29uh5d4

As you may know, Airtable has direct integration with Slack ‘out of the box’. I have just published an article my blog which discusses how to use this to build an absence approval workflow, starting from an employee’s request through to notifying them of approval (or otherwise) - and with a little help from Zapier along the way. The blog post can be found here: Approval Workflows Article The article uses my KasPer Lite base which is available in theUniverse. I hope you find this useful and look forward to any comments…

Hi all, I’m looking for someone that can build me a custom block that is a PDF document viewer. There will be a single document saved in the attachment field. The document will be either a .pdf, .doc or .xlsx. I have a button to view document and would just like the block to display the document. **Edit: it does not matter if the .xlsx or .doc render for viewing purposes as a pdf I’ve tried page designer for this, but I run into two issues. First, it distorts the document making it blurry. Second, these are potentially multi page documents and it doesn’t allow a scroll or click to the next page.

we build a lot of online activities/courses using storyline (which is basically a souped up powerpoint for online course design). within storyline, you can define variables and run javascript to export data from courses. currently, i have a script that exports from from storyline into google sheets, but i’d prefer to have everything in Airtable. can someone help me do this? in case it’s helpful, the tutorial for the storyline to google sheets connection is here: Export thank you very much.

Tried overseas consultants, looking for someone local to help expand and build on a base

Hey everyone! I recently launched a tool for creating websites / web apps without coding using Airtable. We have templates for building sites: A discovery site like Product Hunt A job board like Indeed A service marketplace like Fiverr A gallery like Instagram An events site like Meetup A social networking site like LinkedIn You can create your own site with Airtable for free on Pory. Looking forward to getting some feedback and suggestions :pray:

Good morning! We are a commercial furniture dealership. We use Airtable as a Task Management Program to assist our teams in managing the high volume of projects we run. We have been using Airtable for about a year and we are looking to become leaner, faster, more efficient. I really need assistance in evaluating our current set up and find more efficient/better methods for updating project status and team deliverables/timelines. Thank you so much in advance! Genevieve

The uploading of images in the airtable is slow. If I try to upload images in bulk, it shows uploading and if I check after 30 mins …no images are being uploaded. Each image is more than 6 mb. Can anyone please let me know what can be the problem and how I can make the process faster. thank you

Hi there, My initial goal is as follow: scrap a real estate website with the basics: location, buy, property type, m², price ect with images import data to Airtable display of images as images not as url links automatize these tasks Thank you in advance Gilles

Hello! We’ve seen a lot of great ideas come from the community forum. It’s a place where everyone helps each other learn and can share the great stuff they’ve made with Airtable. To keep the good ideas coming, we want to challenge you to create something that’ll benefit the community. As a bonus, the most interesting, creative, and useful creations will receive some fun prizes :slightly_smiling_face: First up, we want to see how you can use Airtable to help manage your finances. Of course, a great budget framework is versatile and can work in a professional context as well. We know the community wants to see templates in the personal finance category, but don’t feel you need to limit your idea to a single use-case. You could create a budgeting tool, an expense tracker, or even an anti-budget. Be creative and use your skills to come up with a unique base that others can use and benefit from! We’ve even put together a starter template and a brief guide to get the ball rolling. You

I need a simple script developed. There are multiple records in a table. Each record has a field with other linked records. I need a script where I will be able to select the record I want (or better yet, do so by clicking a button field) and then it will display a numbered list of all the linked records in a particular cell.

Hi, We’re an e-commerce small business and are looking for some help with our inventory management system. We have two bases, one where we keep our sales and inventory data and one where we have product details. We want to be able to do a couple of things with our system: Combine the two bases, to have all our information in one place Have part-time employees enter product data, using two separate forms, without being able to access the whole workspace. We’ve looked at some options like miniextensions and stacker, but want something more suited for our purpose. It’ll be nice to have someone who can code maybe to build something specific to our use case If you know someone/ you’re that somebody who can help us with this, please connect! Happy to hop on a call and give more details about our project. Best, KJ

I’m looking for a third-party service that can assist in moving an entire CRM database from Salesforce into Airtable. I don’t think it’s as simple as a basic CSV import, as the database has a lot of records linked across tables as well as a lot of files associated with individual records. Is there any service that exists for this, whether automated or manual?

I am a small (1 person) travel consultant that designs complicated road trips for people. I would like to set up and use Airtable as my CRM, trip tracking, and building spreadsheets. Is there anyone who can help me get it all set up? Please let me know.