Builders Board

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 college or just out of school. we have additional work beyond this project, and capacity to

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 you all come up with. If you have a use case for Paylist or are working on something similar, let’s set up a 30-minute video cal

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 answers will be different in 5 minutes? As time passes, any date formulas that depend in some part on the NOW() and TODAY() will change as t

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 shared in the hopes that the community will provide feedback on what’s still needed, what needs to be documented, what’s OK as is for now. My priorities curr

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 coming months and going forward in general, our focus will be on expanding and solidif

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—each additional character adds another level of specificity, similar to the decimal place system, so if you have millions of plus codes you are storing, and you remove two characters from the end, you sav

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.

Hello everyone, I just launched a new web application that lets you create a website or web app using an Airtable base without writing any code. Here is an article I published in linkedIn: Airvues: build web apps using Airtable databases without writing a line of code! If you’ll like to try it, you can sign up for a free account at Airvues If you have any questions about this new tool, please feel free to ask in the comments. Looking forward to some of your feedback!

Hello friends,I’m pleased to announce my beginner-level Airtable training course, “Learning Airtable”! 🥳It is available on LinkedIn Learning here:Learning AirtableLearn the basics of Airtable, a spreadsheet-database platform, including how to create tables, use different types of fields, leverage views, work with records, link tables, and more.For tracking data and creating custom business apps, Airtable, a spreadsheet-database hybrid platform, can be a powerful tool. Airtable expert Scott Rose starts this beginner course with the basics, presenting how to create a table and how fields work—including text and number fields, date/time fields, value list fields, attachment fields, and formula fields. Scott demonstrates how to work with records, including how to import external records; how to create, edit, and delete records; how to filter records; and how to sort and group records. Airtable gives you several different ways to view your data, and Scott walks through all the view options

Do you want to manually run a script on a record, but without opening a script app by clicking a button? True, a checkbox can act as an automation trigger, but if you have several automations that you want to manually trigger this way, you’ll end up cluttering your table with checkbox fields. This method lets you manually trigger one of several automations with a single field. I’ve done this in a couple of different use cases, and it works fairly cleanly. Make a single-select field named something like {Action} Add a choice in this single-select for the action you want to perform; e.g. “Generate Invoice” Make a new automation using the “When record matches conditions” trigger, setting the condition to be: When "Action" is "Generate Invoice" Add a script action that does what you want, passing the record ID and anything else you need from the triggering record Finish the automation with an “Update record” action to clear the {Action} field after the script runs Add more single-selec

Introduction I’ve analysed and made the below “State of the Art” regarding the “Backup & Restoration” topic. This analysis has been done on December 8, 2020. I’ve also defined what are the “key points” that matters to me, for a reliable Backup & Restoration system. (You might have a different opinion/priorities) I’ve summarized my findings through an Executive Summary below, and then analysed all tools I could find that might help regarding either “Backup” or “Restoration”, and summarized their limitations. Also, I created a poll below regarding what you need/expect from such a tool. :bar_chart: Context I realized such analysis for my company’s interests first (Unly), but thought it could be useful to the Airtable community. We might release our internal CLI “Restore backup” tool as open-source tool, because I couldn’t come across any similar available tooling, despite its current limitations. I’m also considering creating an Airtable App dedicated to “backup/restoration”,

Hi, We have a list of jobs with locations. We can view them on a map as individual markers. But we’d like to view all the jobs that are in a day as a route. e.g. Alternatively: we have a bubble app as well. We’d like an iframe from there to here But can’t use url preview or embed url preview: https://support.airtable.com/hc/en-us/articles/360044410033-URL-preview-app Cannot use our bubble url embed app: https://support.airtable.com/hc/en-us/articles/360015137434-Embed-app Cannot pass dynamic parameters. just a fixed url. Open to suggestions/workarounds/quick hacks. Sounds like possibly a simple react extension but not sure. Thanks ZubairLK

Hi everyone! I’m back with an update on our progress on Pory.io :grinning_face_with_smiling_eyes: We’ve been continuously improving our product over the last month and really excited to announce some new features: We now support existing Airtables! You can map your fields to our template to generate websites even faster. You can add different content blocks with embeddable Airtable forms You can add integrations like live chat and analytics to your site Keen to hear your thoughts :pray:

I do consultations by phone and follow-up with an email. The follow-up email template consists of approximately 600 possible paragraphs. Each paragraph has a number, i.e. 1.0. Most paragraphs are straight text, but some paragraphs also contain data that needs to be entered, if the paragraph has been selected for printing. I want to be able to submit the paragraph numbers desired and have Airtable export a text file with the final selections that I can copy/paste into the body of my email message. My time is limited. Is there someone who would set this up for me? I have staff who could enter the paragraph data. What I really need is someone well-versed in Airtable who can create the structure to do the above. I am Dr. Martin – drmartin@gamgroup.com or call 619-483-1906. Thanks.

Script developers are quick to reach for the Switch() directive in javascript. This is considered better than IF() statements for many reasons, but this is not specific to Airtable scripting; Switch() is used in all flavours of javascript and it’s a bit faster than evaluating IF() statements. But just as Switch() is a better alternative to IF(), JSON may be a better alternative to Switch(). Consider the requirements of my Benford’s example. Traverse every record to capture the first digit in the values of a target numeric field. Count the instances where the first digit is 1 through 9. This is a simple aggregation and one might perform the classification of the counts using a Switch() statement - one case for each count. This requires - among other things, ten variables to accumulate the counts and a Switch() statement to perform the counts. No engineer could be blamed for concluding this approach. Alternative… The alternative is just one variable; a JSON object that will ultimately

We already use Airtable and have a working database for payments, surgery(project) tracking. But need to improve on the model and create automations. Possibly integrations in the future. Since we are in Brazil, Portuguese speaking and understanding of Brazilian health management is desired. Thanks!