Builders Board

Hi there! We’ve run into some roadblocks using airtable’s csv import block, and since we don’t have anyone well-versed in javascript on our teamvwe’ve come here looking for someone interested in this one-time project. We need to regularly import csv’s and have this app update existing records and create new records. All records have a unique identifier field (“RefID”), however it’s a calculated field (concatenation of a text field and the record ID). This is where the csv import block wouldn’t work, and we’re hoping this is something that can be “coded around” rather than simply being impossible! CSV’s to be imported will either have a “RefID” value matching an existing one or no value at all. If they match, then certain specific fields in the existing record should be updated with values from the csv (not fields that would impact the RefID value), and if there is no match a new record should be created. Ideally this would work with short and long text, single s

Hello Airtable Community, Back in 2017, our team published news about Airtable Importer that since then has been helping lots of this community members synchronize data between Airtable and Google Sheets. Three years later, today I would like to say that we’ve launched Airtable Importer’s brother and called it Coupler.io 2 All in all, our add-on: pulls data from Airtable, Xero, Pipedrive, HubSpot, Jira, Google Sheets (replaces IMPORTRANGE) - and we are going to add more data sources to it; supports automatic data refreshes : every 1, 3, 6 and 12 hours, or daily, weekly, monthly; offers replace (rewrites all) and append (adds new rows only) import modes. possesses a more user-friendly UI will provide User Stats internal web page and more to help you manage

Happy 2021 everyone! A new year, brings new projects to manage. And where would project managers be without their handy burndown charts? Well, with a bit of scripting and the vega-lite app, you can now make a burndown chart in Airtable! For the uninitiated (aka me until two weeks ago), burndown charts “show the total effort against the amount of work for each iteration.” Meaning, they help you answer the question “are we completing our tasks on schedule?” They usually look something like this: The line represents the planned tasks remaining, and the bars represent actual tasks remaining. if your bars are below the line that means you’re getting things done on time. The X axis can be grouped by the cadence in which you’re tracking - which could be days, weeks, sprints,

When a new client signs with us, a zap fires that creates the tasks for the project in a project tracking base in Airtable. Here’s an example of one project for one client: Then, as the engagement unfolds and resources are assigned to steps in the engagement, the tasks are checked-off. Right now, every Monday morning we forward clients the last email that we sent them with something like “checking-in on this…”. This is manual and we want to automate it. Here is what we would like: At Project Instantiation. When a new project is created, we’d like a Google Sheet to be created for the Client ID and emailed to to the client. Our services are fully productized, so there are only 5 project types with set tasks for each. The tasks in projects don’t change. If they buy engagement type X, it always includes the same tasks no matter who the client i

Despite the fact that we work and develop apps in a climate of extreme security, the fear concerning Airtable API keys is growing and will likely worsen in the future; Airtable, after all, provides an all-or-nothing API key architecture. And we often leave security requirements until long after the solution is working, at times creating serious exposure to our customer’s data. In Google Apps Script there are a number of ways to separate API keys from the code, but this is typically not enough as far as security professionals are concerned. Separation from code, they argue, still makes it possible for developers to discover the keys. But even this accessibility can be eliminated by moving your API calls into a library and enforcing a basic principle - … only the methods in the library should be able to call methods that can access the keys which are stored in the script project properties. This is achieved with a

Hi there, TL;DR: Looking for people willing to share their bases with me. I’m Don: I work in marketing at Airtable. And I’m looking for a few volunteers (6-8) who’d be willing to share their bases with me. Specifically, I’m looking for anyone who educated themselves on Airtable and anyone who’s particularly proud of their base (this is your chance to show off a bit). If you’ve published a base to Airtable Universe feel free to share a link to your base there as well! These bases will only be shared with other Airtable employees and won’t be shared with any third or external parties. I’ll share them internally with other marketers to help define what makes a good base (and how we can better educate our customers on building great bases). Let me know if you have any questions!

Calling all AWESOME, BADASS Airtable Gurus! (January 2021) My organization is NEED of an expert to whip us into shape! We have been using Airtable for some time now, but badly! We totally need help to optimize and automate business practices within our Airtable platform by providing recommendations and implementations for: • cleaning up our data!! • building creative database designs • streamlining our everyday process (best practices would be great) • streamlining data integrations/API’s with Zapier and SQL • establishing automations Training our staff to increase their comfort level in using the platform Serious consultants need to start immediately (within the next 2 weeks) with the project timeline between 1-3months Feel free to connect with me at liz@voteprochoice.us Thanks! Liz

I want to know if airtables supporting this demands: Can send data to external system if a record is created or updated Can apply customized function to a list of records Customized function can be integrated

Looking for someone skilled in both AirTable and data migration to move an adhoc database of people from google docs and sheets to excel. We have a list of about 400 people existing that we need to move over to a template in AirTable. Looking to integrate an AirTable form with Google Groups as well in the same base. Estimated about 50 hours of work.

Hey everyone, We have just launched membership functionality on Softr.io - the no-code platform to turn your Airtable bases into powerful web-apps. And now you can build anything from client portals, paid courses, membership communities, gated content/directories etc. using pre-built signin/signup functionality and assigning visibility conditions to your pages. Check out the video below to see how it’s done - https://bit.ly/3s7Z7b3 More details here - http://bit.ly/2K1qRN8 Would love to hear your feedback if you find it useful! :blush:

my company offers a career coaching program for pro female athletes and we are expanding/revising our existing program which runs on Airtable, Zapier and mini-extensions. most of the project is straightforward - making forms for various assignments, setting up mini-extensions so there are review links available for the athlete and the career coach, etc. we are changing from a 1-on-1 coaching model to group coaching so the more complex work will be around accommodating that change. we currently pay for pro versions of Airtable, Zapier, miniextensions and the openside connectors so we should be able to get everything done without writing code, although if you have the skill set to do that, that would be awesome! timing/goal is to complete this project in the next two weeks. i think total work will be around 15-25 hours. given our company’s mission, ideally, would love to hire a young woman in co

Dear Airtable community, Jake & Max here from Paylist :moneybag: :scroll: We are creating a new way for you to monetize Airtable databases. You will be able to charge a one-time access fee, a recurring subscription, or based on usage. Monetization of Airtable databases will open up an entirely new range of revenue-generating opportunities for people who curate great content online (or just curators as we call them). Use cases for database monetization include: Curation of art and collectibles Job boards and people to hire Curated lists of recipes or blogs Aggregated educational resources about a specific topic Geographical data about specific topics Music playlists Upcoming conferences, concerts and other events Lists of influencers / or people profiles in specific sectors This is not an exhaustive list, and we are excited to see what other use cases

I’m all set. Thanks.

Getting the current date/time takes a bit of work Airtable NOW() and TODAY() will return values in Greenwich Mean Time (GMT). You will want, instead, to get your local time zone values, or your times will be off and for part of the day your dates will be off as well. One way to do this is create a Formula field that applies your local time zone to the current time along with the format you prefer. You can then reference it from any other formulas. {Right Now}= DATETIME_FORMAT(SET_TIMEZONE(NOW(), ‘America/Indiana/Indianapolis’), ‘M/D/YYYY hh:mm a’) The Airtable field reference page refers to additional articles on the details of this, here’s a helpful one: (https://Formulas and date fields) Just be sure, no matter how you use them, to wrap NOW() and TODAY() with code. Testing Time Formulas How do you create test cases for a base where the right answe

Hi there, We are looking to automate our operations using airtable and creating a custom ERP some of the functionality we are looking to implement are: Customer data acquisition. Customer database management. Inventory management per customer, location, quantity and other variables. Reporting for customer database, inventory, delivery and integration with accounting software (Quickbooks Online). Time tracking to bill customers per activity. I would be working with you directly, I have a basic understanding of Airtable I just haven’t had the time to implement it. Looking forward to working with you,

Calendar Server This Base leverages Airtable’s Sync feature to provide a full rich calendar of recurring events to whichever base you need them in. Because you can sync the events you don’t need to do any coding; all of the complex date logic and arithmetic can stay in the Calendar Server base, the synced table holds all the important date information. Because it needs to be reusable and because it uses a LOT of date formulas this base has it’s own embedded test system (turned off by default in the the released base). The test system provides a way to assert the results of recurring events to ensure the base logic is working as expected. This test system discovered dozens of coding errors in the V1 product. No software is bug free, but the quality of this version of the base is much better than the original. This base is being

I will pay $3000 to remove the view larger version from an embedded Airtable View. Please contact me if this is possible.

Hi everyone, :pray: First of all, wishing you a happy, healthy, and productive 2021 - hope everyone had a good rest over the holidays. I’d also like to give a massive thank you to the Airtable community for supporting our journey and using Codemap.io to find no-code & automation projects and hire experts - the response and positive/constructive feedback we’ve been receiving over the past 3 months are nothing short of amazing, and we are truly thankful for that and for our vision resonating with you. :nerd_face: If you still haven’t, feel free to join us and sign up to get matched and hired for the right no-code & automation projects - we will keep operating on the basis of our “no bidding” and “no commission” concept for both experts & agencies. :moneybag: With a total of $600.000+ in project value since launching Oct 2020, we are really content with the demand side so far. Over the co

Hi, I’m looking to connect a Foxycart account with Zapier to Airtable which will pull in new orders and triggers a confirmation email to the customer. Orders to be managed in Airtable. QR code to be included Airtable for mobile: More on the barcode field type – Airtable - Support in the confirmation email to the customer

I am using Airtable to power my business and we have over a dozen different sheets that relate to one another. However, we need a schema reorganization as we scale. The tasks at hand are: Data cleaning (removing old relations/rows from old schemas) Automation (auto-creating/updating rows based on other sheets) Schema creation (ability to come up with intelligent schemas based on complex requirements) Looking for something with a dearth of Airtable experience and can handle deep complexity.

Finta is an upcoming application that allows you to automatically import your bank account balances and transactions to Airtable. If you want to be notified as soon as it launches (or if you would like to sign up for early access), you can join the waiting list here -> Finta | Product Hunt

Hi All, Just wanted to share a formula I created to convert latitude and longitude into Google Maps Plus Codes. If you are not familiar with Plus Codes, check out this documentation. The benefits to the plus code are: Every location on earth can have a mailing address The encoding of 10 characters plus “+” character is much more efficient in terms of number of bytes than latitude and longitude, which to represent the same level of specificity would need to consist of two floating point decimal numbers of 10 or even more decimal places specificity, requiring more than double the number of bytes, and a tuple type representation instead of a simple string primitive. Plus codes can be used in filenames easily because they don’t use reserved characters. Plus codes are compressible—eac

Hello Now you can create your own help center pages with same UI of Intercom using Airtable. Demo https://sites.hyperlyst.com/public/p01FhT1RGeepopO02nEyOjWmjTJ3/project/intercom/ Airtable Base https://airtable.com/shrCmTj7ma1whzk8h You can try it here https://app.hyperlyst.com/ Hope you like it.

Hello! I’m looking for someone to help sync existing Shopify site with an existing Airtable inventory tracking base using something like Shopify AirPower. Inventory is around 2000 items and growing. If that’s sounds like something you can help us with, please reach out at sasha@artifactnewyork.com.

Hello, I would like to know if there is any kind of template for scripts (not code) for my customer service rep to do outbound calling? She is calling customers right not to remind them of a bonus included with their purchase and I’d like to add the scripts so she knows what to say, as well as a follow up email and text. And then she can check off when she’s completed each task. I am hoping for some ideas.