Builders Board

I’m looking for some help on formulas and building automation sequences. Must be good with IF / Find / And / OR formulas for some immediate needs.

Our company uses Airtable as an interim repository for data to be scrubbed prior to loading in a MySQL database. Have information in multiple bases that needs to be merged and duplicates deleted. Thanks.

Hi, guys! I’m looking for someone to integrate a Zotero library to an Airtable base. Zotero is an app for organizing academic references. It provides a Web API (but no webhook), with detailed documentation. I’d like to sync my Zotero library with my Airtable base, so every time an item is added to my library, that same item is added to my Airtable base. Similarly, every time an item is deleted, the corresponding item will be deleted from my Airtabase base (although this feature is not so as important as the first one). I’m looking for someone who could write a script for doing that.

Hi Everyone, The no-code community (and the Airtable community in particular) is evolving fast, and there are already a lot of established experts writing on no-code trends, technologies, news, etc. Therefore, we thought it would be useful to compile a list of the most interesting (in our opinion) experts in the area that are worth following on social media: 100+ Top No-Code Experts You Should Be Following Should be helpful if you’re just getting into the no-code space or if you’re simply looking for new sources of inspiration and expertise. Cheers, Narek

There’s a ton of excellent tools for turning data in Airtable into websites. But how about the reverse - scraping data from websites into Airtable? After some good community feedback I’ve launched a direct Airtable integration on Simplescraper to help you do that. Choose a website to scrape, enter the details of the base and table where you want the data to appear, click run, and your data instantly appears in Airtable. Here’s a tutorial that scrapes jobs listings directly from Indeed into a base and it should work similarly on almost every website. I know

There’s probably an easier way to do this, but I was quite pleased with the solution I came up with. I’d be interested to hear what you think… I’m building an auditing tool composed of a large number of questions that can be answered Yes, No, or N/A. This needs to give an overall “score” as the final output, as a percentage, where questions for which “N/A” is selected aren’t counted towards the overall score, i.e. the score is calculated by the total number of questions answered “Yes”, divided by the total number of applicable questions. I set up a test version of this tool and filled in some results here. The “Score” field is worked out as follows: {Yes} IF({Q1}="Yes", "1", "") & IF({Q2}="Yes", "1", "") & IF({Q3}="Yes", "1", "") & IF({Q4}="Yes", "1", "") & IF({Q5}="Yes", "1", "") {Yes or no}

I would like to create an accounting system where different subjects after having scanned the QR code of the Seller could specify a certain amount, just a number, and transfer that ‘numerical value’ from his account to another For example: A scan QR code of B transferring 100 B scan QR code of C transferring 50 C scan QR code of A transferring 60 So each Subject has his own QR code and the software has to calculate the new balance of each Subject after each transaction Other features will be discussed later, thanks

Hey Everyone, As an active member of the no-code community, we at Softr always closely follow the developments within the no-code movement. Therefore, we’ve started a series of articles on no-code to share our thoughts and observations on different aspects of the no-code universe. The first one explores the evolution of no-code, its current developments, and future perspectives: The Past, Present, and Future of No-Code Let me know if it’s helpful and if you’d be interested in reading more similar content. Cheers, Narek

My new app “Ready-Made Formulas” is now available on the Airtable marketplace. This app includes over a dozen “ready-to-use” formulas for common tasks such as formatting numbers and dates as text strings to include in reports generating urls for prefilled forms and prefiltered shared views extracting attachment filenames and urls manipulating dates consolidating data from multiple fields into JSON format Simply choose your formula, pick your table and fields, and select your options. Then, copy and paste the formula into your formula field. Most formulas require a premium license.

We are looking for an individual who has an expertise with AirTable and can assist us with setting up reminders and a tracking system for our current account

Hi, I’m hoping to find someone who can help us create a custom calendar/ scheduling feature to keep track of our Digital advertising displays. Our digital screens have 8 slots at once and we’re hoping to find a way to schedule each slot for each of our locations months in advance so we know what is available to sell. Thanks!

International entertainment PR & Markting agency currently using Airtable is looking for a high end expert programmer to: review current airtable set-up propose changes to existing structure vs agency functionality requirements design new features in airtable for integration with Tableau for data visualization design client facing website to display data visualization

Looking for basic training on AirTable for a team of 12 - and for optimization of current bases.

The last time I looked at Coda and I put my suggestion about improvements for the Gallery view in Airtable: Suggestions for Gallery view (see Coda gallery view) Product Suggestions

Hey Everyone, It’s been a busy month for Softr, and we have lots of new exciting stuff for you. Check out all the news, new features, and improvements below: :1st_place_medal: #1 Product of the Week & Day on Product Hunt :jigsaw: Softr 2.0 Use Cases - Client Portals, Internal Tools, Marketplaces, Communities, Resources & Websites New experience for you :tada: New branding, logo and a redesigned website :rocket: New dashboard area :gem: Redesigned Softr editor navigation New Features :bust_in_silhouette: Sign in and Sign up via Google (for your app users) :sparkles: Sign in via magic link (for your app users) ↔️ Define items per row in lists :label: Dropdown filter type for lists :rocket: Performance Improvements :date: What’s Next?

After working with all sorts of Airtable users to get their bases connected to PowerBI, I wanted to provide a quick tutorial to the community in case you might be looking to connect Airtable to PowerBI as well. There are two ways to connect Airtable to PowerBI The Airtable REST API Using a service like the one I’m helping with → Sync Inc I’ll cover both here briefly: REST API These instructions pull together information across several posts here and here. Thanks to @Oscar_Diaz for getting this started - hope pulling this into one place can help.

Hi! So I recently noticed that if I am creating records in a filtered view that all NEW records added in that view will automatically get the same values that are required by that filter. This is pretty AWESOME! Ive been itching to get new records to auto-fill and this helps me get toward that goal. Feature request… If you could attach a form view to create records in a specific view, that would ROCK! However, I do also use the ‘prefill’ in the URL option to do that.

He creado la tabla de novedades Airtable en castellano para mis amigos de España! Airtable

Introducing Default Field Values via new Scripting Block Brought to you by the team at BuiltOnAir & Openside/On2Air Overview Airtable’s Scripting block brings a new level of customization to your Airtable bases. The Scripting block will allow you to run scripts to enhance your bases and manage tedious tasks. You can do things such as create templates for records, prompt users, create custom reports, and much more. Once the script is added to your base, you can use it with the click of a button. We are creating a library of scripts for you to use in your Airtable bases. We have many more examples on the way. Th

Hi there, I’m looking for help to to build an application to… receive a text file (upload button), parse it and run some calculations query airtable and display matching records verify a success or ask user to pick which record if multiple records match export an XML at the end. all within some user managed environment The XML combines data form the parsed input text file and the queried / matching records. There would also need to be security management for log-in (outside Airtable users) and some way of assigning user permissions within the App. The external JS modules of interest are… GitHub

Dear community! :wave: We are super excited to launch the new version of Softr on ProductHunt today ! :tada: - the easiest and fastest way to build powerful web apps and client portals from Airtable, in minutes. No code required. No learning curve. :rocket: It’s now trending #1 and we would love to hear your feedback and get some love on ProductHunt! :point_down: Product Hunt

Dear Airtable Developer, I’m looking for a person who can make me a dynamic form with a multi-checkbox option that is generated based on data that comes from the Shopify API. What I’m developing is a Customer Returns Portal in which my customers can fill in their ordernumber and zip code, so that they get based on that their order information in Airtable. In the form I want my customer to be able to get a dynamic multi-select-checkbox menu with that items from their Shopify order. So that for example, when a customer has places an order with 4 items, if they want to send 2 back, they can select 2 items, and send those 2 items back to us. For that I need the form to pull the order information from Shopify, and show the customer the line items based on the information they fill in, in the form. Kind Regards, Jimmy Jaspers CEO

i have 3 tables. Table 1: Expenses(fields: Date, Details, Invoice PDF, Amount, Category) Table 2: Income(fields: Date, Details, Amount) Table 3: Total(fields: Date, Details, Expense, Income, Total) What i need is: when i’m making a new entry on Table 1, fields Date, Details, Expense from Table 3 to auto-filled on a new entry. If i change something on that entry on table 1 (on that row) to be changed as well on Table 3. when i’m making a new entry on Table 2, fields Date, Details, Income from Table 3 to auto-filled on a new entry. If i change something on that entry on table 2 (on that row) to be changed as well on Table 3. and in the midtime in every row on field Total the expenses/income to adding/subtract accordingly. Its possible to be done with automations?

Hey all, i am currently looking for someone experience in designing backend with Airtable that can be connected with frontend Appbuilder such as appgyver. I would like to build simple to complex apps step by steps. Of course coach / Trainer / Tutor will be compensated. Many Thanks, Deric

I’m working on an amateur project that involves outputting nice-looking text. I managed to cobble together something that serves my specific needs and thought I’d share it here in case it helped anyone else (and also so I can save the link for reference later). Many thanks go to @W_Vann_Hall for the sample base demonstrating how to extract the last name from a field, which was a crucial piece in my “finding the last comma” puzzle. Is there a PROPER name formula in Airtable? - #3 by W_Vann_Hall Goal: Given a list of items separated by commas, add an Oxford comma where appropriate My data has a rollup field which returns items separated by a comma and a space. Example: Moonbreaker Mountain Dreamwater Depths, Meltwater Loch Meltw