Builders Board

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 Meltwater Loch, Dreamwater Depths, Blastfire Bog In lists containing one item, there’s nothing to change. In lists containing two items, I want the comma replaced with " and". In lists containing three or more items, I want the FINAL comma replaced with “, and” (preser

Hello, We are a small Center within a large non-profit looking for help building out bases that can be used to manage CRM, projects (project descriptions, funding amounts, latest updates), grant awards, strategic partnership relations, and our marketing communications strategy. We need tables from one base to be able to sync and link to another, and are looking for help building out roll-up tables. We have some things already built, but are looking for help in cleaning it up and making it more efficient. Thank you! Elena

Hi everyone - excited to announce that I’m running a 1-day Airtable Scripting Bootcamp on Wed 16th June. Info and booking here: http://bit.ly/airtable-bootcamp This is going to be a live bootcamp, hosted on Zoom and it is targeted at any Airtable users who want to get started with Airtable scripting. The introduction of scripting to Airtable has been a big deal and opens up lots of possibilities for processing, automation, integration and so on. But, if you’re not a hardcore coder, how do you get started? This is what the bootcamp will tackle. We’re going to cover: Intro to the scripting block Adding the script app and orientation Getting data from your Airtable base Updating records with a script Deleting records with a script Creating records with a script Filtering your data Transforming/summarising your data Running a script in an Airtable automation We’ll also cover some JavaScript concepts along the way. This bootcamp is open to anyone, but is targeted at new and beginner level

I’m looking to hire a consultant to connect an existing Airtable base to a new Gatsby site. The new Gatsby site will be very similar to a site that already exists using Jekyll. I do not know Gatsby well, which is why I’m looking to hire. I’m hoping to find someone well-versed in both Airtable and Gatsby. Thank you.

Retool and Airtable make a great pairing. Airtable is great for managing data around almost anything. Retool is a great for building internal tools on that data. For instance, you use this Customer Success Airtable template and Retool to rapidly build a customer success tool (as we do in the video below). Or, you can use this Product Catalogue template and Retool to build a resource management tool.You could even expose a customer portal if you wanted to. While not exactly no-code (you’ll need a little JavaScript / SQL), Retool takes care of most of the hard work so you can just focus on building your app. If you are comfortable with Airtable scripting - then you’ll be right at home in Retool. We created a video tutorial that shows you step-by-step how to build a custom app using Retool with Airtable and our service - Sync Inc. Sync Inc is just an option here. It makes it easier to build your app on Retool. But you can use the Airtable API if you are comfortable working working with

I have just published a blog post about using Integromat to automate processes in Airtable which people may find useful - any question please fee free to get in touch! Link to Post

I’m the CEO for a nonprofit in Northern Virginia. I have recently subscribed to Airtable. What I need is a consultant to help with setting up the database (forms; processes, etc.): clients>linked to multiple projects per client; about 100 data fields total. I will need to integrate clients/projects from a home-grown database into Airtable as well. In time, I will also need to build a robust grants managment and marketing database. This is my second priority. Can anyone help me with this? thanks

Within the last 3 weeks we had a team member build several tables for us. However, we have lost that team member. There are various simple things we need help with for everything to function properly. The first major issue we have is setting up a sync to Google calendar once it is noted/marked on the table. Is there someone who can assist, willing to pay. Thank you

We are an outdoor lighting company that installs lighting as well as sells product. We have a robust network of apps that speak to each other. We use airtable for our inventory and project management. We would like someone to help in building forms that will make data entry easier and more efficient.

We at Softr have collected the 10 most used Airtable fomrulas with practical examples for those who want to get into formulas but don’t know where to start. After reading the article, you should be ready to apply those in your own projects. Enjoy!

Trying to create an AirTable structure that fits the type of work we do and flow. Been using for a year now, and we can not make it work for our business, and trying to get help from someone to bounce ideas off of. We need to create a base for a To Do Tracker for our employees and projects, organizing clients, organizing projects. Open to paying someone to help build out our AirTable or teach our team how to use it the most efficient way.

Hi there, we’re looking for an 1099/hourly Airtable consultant for assistance on a handful of Airtable integration projects. This individual should have expertise in Airtable’s API & scripting, Zapier/Integromat experience and some prior experience using Webhooks to deliver data to Airtable. Expected need is approximately 40-60 hours starting in June 21 over a period of 4-6 weeks. If this sounds like a reasonable fit, please message me with your background and rates. Thanks!

Hey! I’m looking to get 5-10 Airtable experts for a few large projects. Please send me an email with a few of the projects you’re working on to xander [at] scopeinc [dot] com to pick the best. Thank you!

Hi Everyone, Many of us have faced a situation when Airtable suddenly goes down. Since our platform Softr is also heavily dependent on Airtable, we’ve prepared a brief guide on what steps you can take when faced with such a situation. Hope it’s useful. Cheers, Narek

I have a very small business … but big dreams. I set up my base with the help of a few people, but I don’t think I can accomplish all I need all myself. Backstory: I have a small bed and breakfast, and I use a Booking system called Hostaway to track reservations, the Hostaway API is connected to my base with a script that’s hosted on AWS. I need a lot of help with the functions and automation of this data, CRM and Financials (which are mostly coming from stripe). I was hoping to create a Junction table (I don’t even know if I"m using the term right) to combine the Hostaway data and the Stripe data, so that I can tell which booking is paid in full and which are not. I also wanted to track gift certificate purchases and link them automatically to the booking used with the gift certificate and the consumer who purchased the gift Certificate (guest vs. customer). I have this part almost done … but it’s not connecting automatically. There are a number of things I would like to do, but I d

Lots of exciting updates and news in Softr’s May update: :link: Linked Lists You can now display linked records in your Softr app. If you have two (or more) tables linked to each other, now you not only can show data from one table but also all the related data from other tables on the same page. Check out the documentation to see how that works on a specific example. :heavy_check_mark: Custom Form redirect on completion Your forms just got superpowers! Until recently the form submission would only change the Submit button color to indicate success. Now on form completion, you can either show a success message to your respondents or send your respondents to another page in your app. Check out our documentation for more details. :clipboard: New Form Fields Our custom form builder now also supports Date & Time field type, alongside the standard Date type. Add the field and it gets magically mapped to your corresponding Airtable date & time field. Moreover, we’ve added a Check

Hi guys, Joel here :wave: Over the last two weeks I’ve been working away on new features, updates and lots of improvements for Paytable.io. A membership platform and secure reader for Airtable. I recently dropped a thread over at twitter all about this, you can follow me on my journey over there if you want to keep in the loop with product progress as it happens. ​ Paytable is now becoming the perfect way to monetize any of your curated bases including research products, info databases, lead-magnets curated galleries, jobs-boards, tools lists, checklists and whatever it is that can provide value to your audience. Monetizing Airtable data has never been easier and Paytable resolves the issue of sharing actual airtable shared view urls which means no more leaked access links. Direct checkout links & customer onboarding improvements If you’ve got your own website, or just a simple landing page somewhere and want to start selling access to an Airtable database, it’s now easier than

Hey all, We’re a small company selling a very wide range of products with very shallow depth of inventory. We have buying / production / ops teams based in different locations, and they all need to be able to upload / access / update information regarding products, inventory, etc. In the past, because so many people have been involved with that buying data, we’ve had issues “baked in” so we’re looking at setting up Airtable to validate and verify data, and prevent mistakes from being created. We also use Shopify as our main inventory management system, but their IMS (Stocky) is very limited in terms of functions, and doesn’t really support inventory movements very well. Ideally, we’d like to set up an integration where Airtable holds all inventory, and records all inventory movements (deliveries, transfers, write offs, etc.), as well as uploads and updates Shopify products (inventory quantity, out of stock, new product uploads, etc.). We’d like to find a consultant who can help us set

I have a cool table that collects all the trade opportunities that i get. I can also do a calender view on it. the only thing i need to figure out is how to showcase the calendar view by points missed instead of event. Any ideas? I am using the free version so far.

miniAppMaker is a tool that allows anyone to make a mobile app without coding by using Airtable as the backend. Here’s how it works: Design your app in Airtable Add your Airtable IDs (API, base, tables, fields) to miniAppMaker Test your app. Wa-lah! This project is inspired by Airtable’s mission to “democratize software creation”. People are already doing amazing things with Airtable. We believe its power can be magnified if we allow people to turn their creations into mobile apps to share with the world. Especially when an entire app can be made in 30 minutes! Examples of apps that can be made: Internal business tools: operations manager for workflows, processes, tasks, inventory, delivery tracking…etc. Appointment/event management: classes, workshops, RSVPs or employee scheduling. For salons, spas, gyms, clinics, catering, tourism, photography…etc. Catalog/directory: a community-curated list of restaurants, recipes, apps, events…etc. Marketplace: for anything where there is suppl

We were thrilled to work with James Q Quick to make a video to show how to easily write Airtable queries. Had to share it with this awesome community: In the video, James shows how to replace complicated filterBy statements with SQL using Sync Inc. It’s just another great way to work with your Airtable data in scripts and other apps.

Hey Everyone, Airtable date formulas is a powerful tool that lets you perform date-related calculations, set deadlines, apply timezones and locales, and much more. But sometimes dealing with formulas can be a bit intimidating. So, we’ve prepared a list of most commonly-used date formulas with concise explanations and examples that you can review and start using right away. Enjoy!

Hello everyone, I recently saw a topic in this section about the “Autonumber” field. Some of the problems mentioned are not relevant in my opinion. Here are my requirements : Auto-increment a field Always take the last generated number + 1 Never change a generated number It does NOT : Recalculate numbers when a record is deleted Recalculate any number when record is moved … I use this to generate invoice/quotation numbers. I made a very basic script to handle this, feel free to copy and use it on your Airtable base. /*********************************/ /* A better Autonumber */ /*********************************/ /* Author : Florian VERDONCK */ /* Website : airtablefacile.fr */ /* Version : 1.0 */ /*********************************/ let config = input.config(); // Script configuration const TABLE_NAME = config.TABLE_NAME; const INCREMENTED_FIELD_NAME = config.INCREMENTED_FIELD_NAME; // Query all records, sorted by number descending (biggest numbers