Builders Board

Hi folks, I’ve been working on getting all of the transactions from various accounts (different credit cards, debit, investments) into one base for YEARS. Up until now, it’s been a series of monthly CSV imports (using CSV import block) which was a huge pain. Frankly, most months I’d give up and not do it. That is until I discovered TillerMoney and Parabola. Tillermoney imports all of my transactions into a spreadsheet and Parabola lets me setup a nightly runs to sync transactions between the Tillermoney sheet and my airtable base. From there, I can easily map each transaction to a category using a linked record on the vendor (working on standardizing vendor names with a script!) Here’s a quick video on how I’ve set everything up including the Parabola run and a template base to start from A few Qs that I expect to come up: Why not use the sheet? I work at Airtable so it would be awkward… more seriously, mapping vendors to a category is a pain. Why not use Mint or another tracking app?

Hi, We use Airtable extensively at our office (at MIT) - we’re about to take a program that is run off Airtable from MVP to large-scale operations and need someone with a bit more experience in creating integrated and scalable Airtable bases. Can anyone provide advice on bringing on an Airtable developer or consultant? Thanks!

Per a helpful recommendation from @Justin_Barrett, I’m interested to find help with the following problem. I have a base of companies and another base of investors, linking the two so one can see the investments of an investor and the investors in a company. I’d like to be able to upload a new csv that has another list of companies and their investors. Inevitably, these new lists might include some new investors in a particular company, but also not be exhaustive, so I’d like to be able to just add the new investors to the company, not overwrite the previous list. Eg. If Company in my database currently has investment from Investor A and Investor B, and I import a list that says the company has investment from Investor A and Investor C, I’d like the result to show that the company has investment from Investor A, Investor B, and Investor C. Here’s the thread with Jason describing the potential project - any thoughts on folks who could help? Import csv to add new multise

I represent the University of Colorado Denver - where I work - and the Digital Pedagogy Lab (DPL), where I am leading a workshop on Maker Education in late July. I am not spam or scam - this is a sincere introduction and invitation. We are hosting a virtual Maker Faire in the last week of July, and I was hoping Airtable – or an Airtable developer - might give just a bit of time and expertise – to essentially offer a ‘how it’s made’ style demonstration of what’s possible. Possibly even an Airtable for Educators type of demonstration. That’s the idea. The DPL event itself has about 500 participants registered this year, from universities around the country. Within DPL, we’re aiming for a mini-Maker Faire for a couple of hours during the week. All video virtual – folks tuning-in and browsing from home. I would really like to have Airtable at the table and demonstrated as a no-code maker platform. I am humbly fishing for an expert to give us 1 to 1.5 hours of your time on either July

SECOND UPDATE: @Carter_W, @Eric_Kline I managed to get some help with this scenario. Thank you for the interest. UPDATE: @Carter_W, @Eric_Kline, @cherry_yang1 I am still deciding what is the best way to do what I need done, so I just wanted to let you know what the latest is on this job quote. Thank you, Mary K Hi Airtable! I am looking for quotes for some scenarios that work together, that I need help setting up. If you you are very experienced with Integromat, Airtable and Airtable API, please contact me by DM. I will then provide more details. Thank you, Mary Kay

Hey Guys, I’m have a small home inspection business and need some help automating my scheduling (JotForm) to Airtable/Google Cal and would idealy have a 2-way sync between Airtable and Google Contacts and then sync that to Constant Contact… with JotForm (or other form) would like to integrate Google Map API for auto address fill (I already have that acct). Just need help with the details and finalization. Thank in advance. Also, while I’m using Zapier at the moment, it seems like Integromat can do more, but requires a little more knowledge than what I possess.

We have an airtable now that was created for our community. Airtable TBECLT Shuk - Airtable Explore the "TBECLT Shuk" view on Airtable. We would like to adapt it to be a selling site for our Temple Gift Shop, using the same format, having all items for sale from our shop.

Please contact for details. Believe this is simple to accomplish. Cannot do it myself. krowlinson@gmail.com Thanks Kevin

I am a real estate developer that needs an internal tool to keep track of multiple projects and require more functionality from the Map Block. I’ve listed out the main requirements, which I am certain can be achieved through the google api but not sure if they can be achieved in tandem with Airtable. I like the ability to view my table data side by side with map block and just need to extend the funtionality of the map block as below. Key customisations Search bar in the map block See street names and places on the map block satellite view Add markers directly into the map block and save to airtable database Add polygons directly in the map block and save to database Add measurement tool directly in the map block Easily filter what markers are seen (via a graphical widget) If this cannot be achieved using google maps, I would also be be open to using the mapbox api. Thanks for reading this and let me know if anything needs clarifying.

We run a small project management company that runs book printing and production projects for authors and publishers. We would like to use Airtable. We have a Miro Wireframe Diagram (which is available for Airtable Pro accounts) already created and an extensive Excel Spreadsheet mapping of our known database fields, their functions of each field and their potential values, as well as what other parts of the database need to be related to at that point. Need an experienced Airtable Implementer who has implemented MIRO before to get this up and running. We are a team of 3, a small company, but we have already tried sharepoint and a few other Project Management tools and failed to get what we needed. Link to Miro Wireframes with functionality comments: https://miro.com/app/board/o9J_kuBCIwU=/ Link to Excel Mapping of all Data Fields: https://docs.google.com/spreadsheets/d/1GYmw5RmqE4cMfkB0NY6nJWsF2czXPkcSo_aYDHNzJuI/edit?usp=sharing Please contact me at ryan@printopya.com

Looking for ideas. We’ve implemented it for launching custom emails (mailto:) to single and multiple recipients, and for launching a form through a URL. What other cool applications are you doing?!

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 need to make this business sustainable. I’ve been testing different website builders an

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 Airtable keyboard shortcuts The following is a list of keyboard shortcuts that'll work within Airtable. If at any time you need to see this list of keyboard shortcuts again, you can hit / and it'll bring up the keyboard short...

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 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.