Builders Board

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 Tools and Integrations for Airtable - miniExtensions Tools that empower Airtable users to process unlimited records in bulk with scheduling and automation features. An alternative to Zapier and Integromat. We’re always looking to add more extensions. If you have an issue that you’d like us to build a solution for, please do not hesitate to reach out here!

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 edit credentials to enable auto-refresh and I am not sure in what way/format I should enter them. If anyone has an idea please tip me.

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 quick and easy reference for other people who were used to using the STDEV() function in Excel, bu

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 base on the Airtable universe. Here is the gist. Here is a link to the walkthrough.

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 tool, and 2) if Airtabl

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 hide from the table. The entr

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 in the dashboards. We provide support in 4 ways: :phone: Matching people in need with phone volunteers that talk to them every week and check if they need anything :woman_cook: Matching with cooks to provide hot meals :shopping_cart: Sending food baskets :bulb: Helping with general requests - from clothing to fixing stuff at home Base features: Volunteers and people in need manageme

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!

Hello, We’re an exercise service that launches new workouts daily. We’re using airtable to track our daily content production and would like to add a page for content programming - tracking number of plays of music, playlist selection, name of instructor, shoot days etc. We have it basically mapped out and working in google sheets but it’s a lot of duplicate info that’s already in airtable, so we’d like to integrate this into our main airtable. Is this something you can help with? If so, can you give me an estimate or hourly rate? We have the capabilities in house to handle this but don’t have the bandwidth. Thanks, Sam

Will like to talk to someone who knows both smartsheet and airtable tools, strengths/weaknesses so that i can make appropriate decision and potentially help with upgrading/transitioning to one of the platform. Will like to discuss project management capabilities like Gantt, dependency, scheduling, resource management etc.

Hello, I am currently in the process of moving our tutoring center away from spreadsheets. The first endeavor is setting up our contacts in Airtable. Right now I have student information in one table and parent information in another table and am attempting to link them together. The problem is that many parents and students from different families share the same first and last names. I have ID numbers that both the parents and the students share so linking them together should be easier, but I am having trouble creating a one-to-many link so that one family entry can be linked to multiple students from the student information table. I may also look for some assistance expanding our record-keeping in Airtable. Currently most of our student data is in various spreadsheets and I am hoping to consolidate that in Airtable. Thanks very much. – Jason

When using a form, you can pre-fill linked fields in forms by using the Record ID for the record you want into a single line text field instead of the actual name, then use Zapier, IFTTT, or (my personal favorite) Integromat to update the linked field with that record ID. I realize it’s cumbersome, but you just have to have it, it works. I do this for several of my forms.

Resolved: Please close thread – thank you!

Looking to convert this excel spreadsheet into an airtable so it can be easily managed and embedded into a website. Dropbox Golf League Standings.xlsx Shared with Dropbox I would like to easily be able to add matches and have everything update automatically.

For anyone interested in Airtable scripting, I’ve added a few new posts to my blog: 3 ways to loop Getting the unique values for a field Creating a record Creating many records Enjoy!