Builders Board

Having a Last Modified field sounds quite unimportant - but when combined with tools like Integromat it becomes very powerful - and this on top of the new Airtable / Integromat ‘app’ which makes Integromat so much more useful to us! I’ve written a blog post about this which will show how to use this new field type to drive processes - and it’s the first post which I’ve initially published on my new Blog / Forum site - Online Database Experts. This is a site aimed at users of Airtable and other similar platforms and all are welcome to join and collaborate about Airtable and other tools like Integromat. Here’s a link to the post: Using Last Modified Fields with Integromat

Hello! I’ve been delivering items from my farmers’ market to neighbors for the last 2 months and now I’m looking to scale our operations locally. I’m looking to hire someone to help me build a form that customers can use to place orders, and that I can use on the backend to sort aggregate orders based on vendor. Ideally, customers would use this form to order the items they want, make payment, and input delivery address and phone number for text notifications. I’d love it if these forms would feed into an order summary on my end where I can sort aggregate orders based on individual orders and vendor (because customers can order items from multiple vendors). I’d also like to be able to collect email addresses and refresh the ordering window each week. Hoping this is all possible with Airtable! I created orderfromfarms.com, but after the first week of sales have noticed that it doesn’t do everything I

Please contact me on noworriesmig@gmail.com or call +61 432636461 I have an existing issue with invoice amount calculation as when the invoice is marked paid, it affects all previous Invoices and there is also a problem of “circular reference” in invoice calculation.

Hi Airtable Users! After reading @ScottWorld’s response, regarding a keyboard shortcut, I thought it would be a good idea to post a list of shortcuts. Mary Kay Airtable - Support

Hey Airtable Community! I have a fairly developed Airtable Base that we’ve been using for about 4 years, but I need to add some more complicated formulas for calculating commissions based on type of venue, artist, and agent. I also would like some help with java in the script block so that we can duplicate auto populate a new Mission with preset tasks. I know exactly what I want, I just don’t know all of the proper syntax. For an expert, both of these jobs would probably take 15 minutes, and I’ll happily venmo you $25 for that 15 minutes. If you’re up for it, shoot me a quick message at mark@braveenough.com and we’ll set up a time to make it happen. Thank you!

Hey all. I am a content creator for travel brands. I have just tried out AT and would love to have my google docs imported and work with someone to tweek the system to fit my needs. Think of your mom who needs help on here…Im that woman. Please let me know if anyone is interested. Thanks! Annette

Small nonprofit, 5000+ records, clients, donors and volunteers. Interested in other services that integrate w Airtable. Looking to get something set up in next two weeks.

Hello Airtable Community, We’re Airtable addicts and need some help with Javascript. We’ve looking to append UTM codes to links in HTML blocks. See our post: Extracting text from between consistent characters After this task… We’ve built an economy on Airtable and are at the point of looking for an expert to help us refine the code that got us here. We’re starting to experience heavier loads and would like to make it more efficient and robust. ~Brian

Hey, We are circular fashion tech startup that recently launched a platform for reselling and shopping pre-owned fashion. Our platform is run in Shopify and we use AirTable as an inventory management system in which we prepare products that we take in for listing, track orders to be shipped, payments and as a base for our accounting. We have a steady solid base that is integrated to Shopify and other apps, but we are looking to automate our operations as much as possible and reduce manual steps related to handling customers and products. We are looking for an Airtable expert to consult us on process automation and showing what’s possible. Happy to explain more. If you think you are the right consultant, please reach out to johan@cirqular.se and elaborate in your experience and how you think you can help us. Cheers,

here is a solution for efficiently backing-up your Airtable base using Integromat this solution uses only 5 operations per 100 records and can therefor manage many records and backup runs even with the frre plan of Integromat. It can also easily be expanded to include encryption and various types of triggers and the backups can also be done to various other medium i.e. gsheets, MySQL etc. See details for the solution here - https://5im.pl/airbac This image is for display purposes and does not represent the actual automation.

An extension of Example: Netflix-style UI with a script, here we use OMDB API in the Scripting Block, to grab the Runtime/Duration of a given film from a given Airtable: Could of course be used with any API service, with a bit of adapting. Todo: add a max_count so that it doesn’t hit the API’s rate limits e.g. simply change line 20 to for (let record of result.records.slice(0,1000)) { add error handling (currently, if film is not found, the script simply skips to the next row).

Hi, I need help in integrating filtered views of airtable bases on dynamic pages of a duda website. The bases are integrated but I can integrate only the whole list The duda website is a licenced one via Ionos 1&1, so I don’t have the api thanks for your reply Dorothee

Hi Everyone! We’re announcing a major update to miniExtensions! Previously, we were offering each extension as an individual subscription. Starting from today, we are offering access to ALL of our extensions for a flat rate per month! (think Netflix model, for Airtable tools!). Our 30+ extensions and the new pricing plan can be found here: miniExtensions

I do not seem to find this anywhere on the community, so thought of sharing it. With the use of API key, we can easily integrate Airtable bases into power bi and design dashboards. In the PBI desktop got --> Get Data --> Web --> Advanced In the URL parts, enter the table URL here To authorize - select Authorization and enter this Bearer YOUR_API_KEY Click OK and your table will reflect here. This process has to be repeated for each table in the Base. Also, if a field is linked record type, this shows as a bunch of alphanumeric in the PBI. To avoid this, in the table create a new column next to linked record field and use ARRAYFLATTEN formula to overcome this alphanumeric and effectively present data in PBI. One thing I still did not figure out is how to set auto-refresh in PBI online as it shows to

For those of you needing to perform a Standard Deviation calc (STDEV() in Excel), here’s a template you can use for performing this calculation with values across a single row (record): SQRT( SUM( POWER({Value 1 Field} - {Avg of Values Field}, 2), POWER({Value 2 Field} - {Avg of Values Field}, 2), POWER({Value 3 Field} - {Avg of Values Field}, 2), ... ) / (n - 1) ) Where n = the number of fields SUM’d, ie, the number of POWER() statements. You do have to manually enter each field that holds a value which you want factored in to the StDev calculation, and you have to have a field that calculates the averages of those values, so this will not work well for a dynamic data set (new values are constantly being added to the list of values needing to be included in the calculation). I use it quite frequently in calibration specs, however, so I figured I’d post it here as a qu

The inspiration for this script was the many posts that I saw where people wanted to setup default values when they create new records. In that way, it is similar to one of the scripts that has already been shared. However, I believe that there is no one right way of doing things, and I had ideas for a different workflow. This script fills in blank cells in a table based on a template record. It also requires no configuration of the script, and no changes to the existing table/field definitions. This script has the ability to make bulk updates to a lot of records very quickly, and it has several quirks and limitations. I only received access to the Scripting block when it was made public on Friday, so I didn’t have much time to get up to speed. I have many improvements in the works, but they will all take time to implement, and I need to sleep. Here is the

We are looking for help with Air table Project management Gantt Bidding Payments Estimating Etc

I’ve gotten Car fever and want to start doing research on used cars that fit my price range. I tried some of the consumer sites, but was really left wishing I had a place to look at all my research at once and compare things like average price and milage for a specific Make, Model, and Year. So I hooked Airtable up to the MarketCheck API via the scripting block and made a base that pulls in all available car listings within 50 miles of me within my specified Price and Mileage range. Then, made use of Page Designer and URL preview block. It’s pretty dank if I do say so myself. :star: :star: :star: :star: Overview of How it Works Here Copy of the Base Here Have fun y’all😃.

I have a table with records belonging to various contacts. As an example, I have five records for contact A. These records are tracking numbers of shipments that we need to air freight to Contact A. I would like to email all 5 records in a Typeform link, so that contact A can select the shipments he would like us to ship and also provide delivery address information. Suppose he selects 3 out of the 5, the 3 should be added to an existing table, from which we will process the shipment. Is it possible to set up such a workflow?

Hi, been trying out Airtable for a few weeks and believe it may be a helpful project tracking/database tool for my firm. I run a structural engineering firm in the San Francisco Bay Area with about 20 employees. We initiate about 150 projects per year of varying size. Each project has statuses, phases, timetables, milestones, budgets, unique attributes (e.g. address, type, location, material use, etc) , a client, multiple outside contacts (architect, contractor, soils engineer, etc), and often multiple assigned internal team members (collaborators in Airtable parlance). I want to create a solution that 1) records each project, its attributes and contacts, 2) tracks projects status, phases, schedules and milestones, 3) provides a weekly workload planning dashboard for each staff member (based upon to-do project tasks), 4) provides staff timesheets, and 5) tracks project budgets. I am looking for a consultant to 1) advise as to the appropriateness of Airtable as a

Hi, I’m new to airtable and I’m sure this is the best possible solution for tracking projects if done correctly. I have tried watching many videos to figure out how to build the base that can help me monitor the progress but it’s all to vain. We are a video production company and work with freelancers. I need help from someone to help me build the base of possible. Below is the typical scenario - There should be 3 different tabs to get overview in a glance namely Current Projects, Tasks and Clients. Projects have milestones on which different collaborators work. Milestones are - Script, Voice-Over, Styles, Storyboard and Motion Design and there can be multiple milestones assigned to a particular collaborator. Current Projects is the main tab where fields are - project name, start date, end date, current milestone, collaborator name, milestone start date, milestone end date and status. Once the status is changed from ongoing to completed, the project should h

Have a look at the base here. We are a growing movement of volunteers who have been mobilized due to the current crisis to help the most vulnerable among us - the elderly, the refugees, the domestic abuse survivors, sex workers, single mothers, and others who are not getting their basic needs met. Who’s it relevant for? Mutual aid organizations and non-profits - tweak this base to suit your needs. Our process: We built an operations management system using Airtable. It works as a support ticketing system. Get the general idea by looking at this very high-level flowchart which also appears

Shows the posts in English. I want to keep the posts in Bengali. How can I keep the posts in Bengali on the airtable?

Hey All– I’m looking to build out some accounting templates to track AP/AR (accounts payable/receivable) by project. Are there any experts out there that want to make a few bucks and do a 1-hr ish zoom call and help me build out a few templates? Best, Ryan

I have two tables that have information that is needed to create formulas to auto calculate gaps. For example, I have one table set up grouped by Month and Coach and has columns that are in currency format. They have revenue amounts and other count numbers. I have another table that is created to calculate the gap between the numbers in the first table and the newly entered numbers from Coach inputs in a form within that second table. So somehow I need to get the information that is sorted by Month and Coach into the second table to create formulas to calculate with the new information that will come from the form. Thank you in advance!