Builders Board

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!

Airtable, known for its low/no-code marketing posture is experiencing rapid growth and adoption by users who need to create code and by many who want to learn how to code to take full advantage of the platform. The irony does not escape me. About two years ago I predicted Airtable would soon enable users to create javascript code; seven months later, they did. I called it, but this was an easy prediction - it had to happen. A few weeks after Script Blocks was released, I made a similar prediction concerning code generators. I guessed aloud how long it would be before we might see some smart systems able to create complex scripts that perform some pretty useful automation and tasks. Mark that one off - today I got a preview from Dan @openside and I’m excited that he made this a reality. Watch for announcements on this soon from Openside. Imagine a tool where you point and click, make a few selections, and it displays the script action code needed to meet your objective. One might ask -

It’s not likely many of you known about Benford’s Law, but it will surprise you especially if you happen to unwittingly bet against it. Imagine a scenario - you’re having lunch at a counter cafe and the old guy next to you (i.e., me) says out of the blue… I will give you 20 bucks if you open any page in that newspaper and the first number you see starts with a 7, 8, or 9. And as part of this little game, if the number starts with a 1, 2, or 3 - you have to give me just ten bucks. Would you play that game knowing that the odds are stacked against me? It’s a two-for-one bet after all and numbers, of course, occur in the wild in even distributions, right? Um, wrong. Here’s a 10,000 record [data se](https://download .csv file)t of insurance information that I randomly chose for this article - download it and import it into a base. Then run the script block (included below) on these fields: hu_site_limit tiv_2011 tiv_2012 Here are the distributions of the numbers from the insurance tabl

Bonjour, Je suis gérant d’une société de construction située en Belgique. Je suis à la recherche de développer pour m’aider à peaufiner des workspace créés pour mon entreprise. Un workspace a été créée pour la réalisation de planning hebdomadaire et un second pour la gestion du service après vente. J’ai besoin d’aide pour: Créer des rapports pour impression avec entête, logo,…; Connaitre les possibilités pour réaliser des restrictions d’utilisateurs - Rendre par exemple impossible la suppression d’un enregistrement à une personne avec un statut d’éditeur; Possibilité de créer des liens avec un record suite à l’envoi d’un mail; Je me tiens à votre disposition pour de plus amples informations. Jerome SCHILS DELTA Constructions

We are new to Airtable and do not have capacity to build what we need in our project timeline. Seeking a partner to assist with the development a CRM/asset map to support state-level grassroots organizing that needs to be developed before year-end. Please message me if you are intrested in a tight turn and lets set up a call to discuss.

I’ve updated this show & tell to include a little better video that’s more complete and demonstrates many of the ways that MapBox and Vega-Lite can be blended to create a powerful visualization of data. And you can purchase this codebase as well. Happy Holidays!

Found this nifty tool on Product Hunt! Mantle supposedly allows you to turn your Airtable into custom internal tools with no code. You can natively integrate multiple SaaS apps too. Kinda cool and might be useful for someone :slightly_smiling_face: Link to PH: https://www.producthunt.com/posts/mantle

I know many people have been waiting for a HYPERLINK() function. This is not that, but its as close as we can get today. Check out how this simple script can create links that are dynamic and formatted with the text you want instead of the ugly full URL. Explainer Video: Loom | Free Screen & Video Recording Software Base: Better (Dynamic) Links - Airtable Universe Script: Create fully formatted links in Airtable · GitHub

Hi I have just discovered AirTable and have started to put together a database, is there a developer out there who can help me for a modest fee as I have limited knowledge of AirTable? If you can assist me please call me on 07976 797455. Thanks Martin