Builders Board

With the upcoming upgrade tomorrow, now is a good time to think about your Airtable Backups Strategy. Of course, we all hope and expect the upgrade to go smoothly, but having a backup of your data outside of Airtable is always an Industry Best Practice. It’s an insurance piece of mind to know your have an external backup of your data in case of outages, accidental (or intentional) deletion of data/attachments, etc. Don’t worry if you’re not performing backups - you’re not alone! But today is the day to start. On2Air has you covered if you’re ready to start! For the fist 20 signups to our Backups solution, you can get a 20% off your initial subscription period (bigger savings on annual plan!) Check out the service: https://on2air.com/on2air-backups and on checkout use promo code: BACKUPNOW Oh and don’t forget to turn off any external automations (zapier, inte

We have an excel spreadsheet that we use to calculate pricing for customers. Our goal is to hire a consultant to develop a web enabled form that mimics the spreadsheet to add to our existing website as a self service option. Additionally, we need to add sign-on security so we identify the user and apply the correct pricing. The spreadsheet serves really well as a design template for our requirements. We will make ourselves available to collaborate on the business requirements.

We are looking to hire a consultant to help us set up a more complex workflow & automation. Here’s a brief synopsis of what we’re trying to do: We’ve started looking at how we can duplicate some of our client-specific views that we use for reporting purposes and we were wondering if there was a way to automate this duplication process. I believe that just using the duplicate option isn’t viable due to the formulas involved in each view and the different rollups required to set up the reporting view all need to be set up with it. We were curious if there was a way to automate this to where we can potentially set up and fill out a form and it automatically updates & creates the formulas with info that we input into the form, which would take this view duplication process from around 25 steps to just needing to fill out specific info into a form. Does anybody have expertise in this? Feel free to reach out to me here or at ju

Hi there, I’m part of a non-profit residential mindfulness center. We use notion and airtable for most of our systems including admissions, donation tracking, guest forms, and more. We’ve built it thus far in-house with a little bit of coding help. Looking to hire someone long term that can help with upgrading our systems including: Visual Dashboards to visualize our metrics (how many interest forms are we getting, tracking donation amounts, etc.) Custom links working with our Wordpress PayPal to create payment forms that will then automatically update AirTable record with paid and how much was paid Sending automated weekly reports of our various departments Financial Forecasting to track how we’re doing and more We’re pretty competent when it comes to making the tables and forms but the more advanced integrations and making it all into one system is a headache and would love some support for someone else to bui

Disclaimer: self promotion Hi folks! We’re looking for users for the upcoming beta launch for Shoptable, a Shopify <> Airtable integration. Shoptable brings the power of the Airtable platform to Shopify merchants by creating a live, bidirectional sync between Airtable and Shopify. Using Airtable to run your shop means you can leverage custom tailored views, automations, and reporting tools to run your shop, all within Airtable. There are almost 2 million Shopify merchants and they all use the same Shopify Admin interface. We’re going to fix that. You can check us out and get on our waitlist here: https://shoptable.app/ Feel free to comment below if you have any questions.

We are a small content site that need a way to keep track of contacts which we use to interview for article research in our writing process. On most articles we try to find an expert and interview them about the specific topic. The goal here is to keep track of people we’ve interviewed so we can reuse them and also make sure we’re not stepping on each other’s toes and emailing the same people at the same time. Right now we are tracking in various spreadsheets individually and we have to check with everyone if they have contacts or who is talking to who and when. Key Features: Contact Table - captures key contact info, tagging based on expertise, display last time we talked Interactions Table - log all the interactions we have with the contacts in above table Contacts Table: We want to maintain a good list of experts we’ve worked with over the years so we can tap them again if there is a good ma

I own a small furniture business in Sri Lanka. I would like to bring over all of my google sheets and set up all the documents on airtable with images so I can have my whole team using it. Would someone be able to help me. Thanks Jalal

Formula: IF( LEN(TODO_REPLACE_WITH_IBAN) > 0, IF( REGEX_MATCH( SUBSTITUTE(TODO_REPLACE_WITH_IBAN, ' ', ''), '^(?:((?:IT|SM)\d{2}[A-Z]{1}\d{22})|(NL\d{2}[A-Z]{4}\d{10})|(LV\d{2}[A-Z]{4}\d{13})|((?:BG|GB|IE)\d{2}[A-Z]{4}\d{14})|(GI\d{2}[A-Z]{4}\d{15})|(RO\d{2}[A-Z]{4}\d{16})|(MT\d{2}[A-Z]{4}\d{23})|(NO\d{13})|((?:DK|FI)\d{16})|((?:SI)\d{17})|((?:AT|EE|LU|LT)\d{18})|((?:HR|LI|CH)\d{19})|((?:DE|VA)\d{20})|((?:AD|CZ|ES|MD|SK|SE)\d{22})|(PT\d{23})|((?:IS)\d{24})|((?:BE)\d{14})|((?:FR|MC|GR)\d{25})|((?:PL|HU|CY)\d{26}))$' ), 1, -1 ), 0 ) Documentation: This formula checks if the structure of TODO_REPLACE_WITH_IBAN is correct (each country has its own specification). It only considers countries that are within the SEPA area.

Hey there!Do you use both Airtable and Google Drive?Yep, every single dayEh, sometimesNopeI wanted to show you how you can automatically create invoices (or any document) in Google Docs using data from your Airtable base.https://www.youtube.com/watch?v=lg_h6kDAak0 This uses the On2Air Docs. It allows you to automatically generate documents in Docs from any data you have in Airtable.Copy the free Invoice Google Docs template and the

Hello, i need something similar to this video. My budget is 100euro, you can contact me on andreibobocea619@gmail.com. Thanks a lot! That’s not my video, is builded by somebody else but it’s over my budget.

Thanks!

Hello, i need some airtable consultant who can build an automation or script with the following steps. We have a database where we add different tenders. After adding each tenders, we complete a form from where we can add products. After adding products we need an automation that add products and cost of the products in other table on a specific record.

Coming from the Salesforce world, I am used to the concept of converting a lead to an account/contact/opportunity record. I’ve been blogging about creating a CRM in Airtable and I just blogged about implementing a Lead Conversion process behind a Button field. Let me know what you think. Scott Hemmeter – 30 Sep 21

Hey Airtable community, It’s time for this weeks updates at Softr. We have rolled out a number of new updates this week we would love to share with you. Timeline Block With the new timeline block you can create a slick-looking vertical list with a timeline, complete with large image tiles, title, description, tag and filtering with your Airtable base. Perfect for creating changelogs and what’s new pages, portfolios and much more. Small List Block Introducing the new list block mini. No, it’s not a new iPhone but instead, a slimmed-down version of the list block. Perfect for when you want to fit more in a row or have a large number of items to list. Editing List Block In addition to our recently released List Details block edit functionality, starting from today you can now edit List Blocks. To put it simply, it allows users of your application to update list detail records directly via your So

Hi! I’m looking for someone with strong technical skills in Airtable to help build out workspaces for a temporary placement chef staffing business. I specifically need the ability to see which employees are available for short term placements at any given date, which employees are on assignment at any given date, and the ability to automate invoicing to clients that hire our temporary employees. I have the basics in place, but I need help with the more complicated aspects of the 3 needs listed above. I would like to start on this ASAP as we currently have temporary employees staffed all over the US and need to keep track of them. Thank you!

Hi, everyone! I’m hoping to find an expert who can help me pull together my business processes for a cleaner, more efficient workspace through the use of Airtable automations, web hooks, APIs and/or Zapier & Integromat. I also use MiniExtensions for a number of my current automations. I utilize Airtable as my primary database for my app created with Adalo. I have been reading through the API documentations myself, but to be honest I don’t want to risk setting up such a crucial step incorrectly. Here are my specific needs: When a record enters an Airtable view, create a new record in Adalo, send a SendGrid email to the address in the current record. Once the above steps are successful, move the record to a separate table. I have the majority of this already set up through Zapier - however, for some reason, the record entering the view is not triggering the Zap. So I am having to trigger it manually, but need to be able to trigger it either auto

I know I fell off the board lately, but it was for [I hope] a worthy cause. Data Deduplication v3.0 The third iteration of my deduplication routines for Airtable, totally rewritten, with additional features and functionality. Standard Airtable functionality Works on Free and Plus subscriptions Optional use of Pro features (record color, Blocks) Does not require 3rd-party SaaS integration Includes 3 “modules” Duplicate identification Suppression of false positives Merging of true duplicates Supports persistent tagging of false positives No need repeatedly to vet the same flagged dupes Suppressed dupes still evaluated against new records Color coding indicates past, new matches Supports real-time deduplication Each new record checked at time of data entry This version of the routi

Hello! I’m looking at airtable as a potential resource for many different projects our team completes. I have not set up a table yet and have a large google spreadsheet that I want to use for my first project which will be our trial run with airtable to see what it can do and if it’s the right fit for us. I do not want to have to be the one to set it all up and am looking for someone who can do that but who will also improve the information’s organization/presentation. I don’t want an exact replica of the spreadsheet in airtable. I have put together a bit of a video explaining what I need. I want the project price to include the design of the airtable (how it should look and operate - and I’d like to ensure a “pretty” look while being productive), set up and then training video explaining how to use the airtable.

Develop Airtable into a TV Production resource scheduling platform. Key needs: Build a database of TV production locations, resources and assets. From an existing primary Airtable database, import/Ingest event data into a the “TV production” database. Once the event data is populated in the production database, kick-off automated functions that have been identified. Design UI for Super-users to conduct resource assignments for the imported events. Specific resource assignment functions have been identified. Design read-only portals or dashboards (possible mobile app) to share schedule with users. Ability to generate requests to a third party portal (Coupa) and, Generate management reports. Please ping me at harabin.michael@gmail.com Thanks, Michael

I need an excellent Airbase consultant/implementer/developer to migrate my company’s hours and billing tracking system from its current implementation in Google Apps to Airbase. It is a mature system, thus the requirements and functional design are clear. It looks like this: DATA: Data is stored in multiple Google Sheets - monthly/daily work hours, per task for each employee; list of clients and hourly rates; lookup list of employees and hourly rates; aggregated and calculated monthly totals per client; aggregated and calculated totals for company across all employees-customers-years-months. Google app scripts are run to aggregate and calculate data and store in master sheets FRONT ENDS: Employee has a form that shows their list of clients and allows them to enter hours per day + comments Management uses Google Data Studio to visualize data and get reports, etc. Feel free to contact me at eli@techwriting.co.

Hi there, looking for a german speaking consultant who helps us with some airtable stuff. Please get in touch for more info. Cheers, Sven

Note: I finally found (and finished) the quick little project I started back in March — right before all my teeth exploded. :winking_face: Here’s another niche application: Code to generate random[ish] unique numbers in an arbitrary range — say, from 1 to 10000[ish]. What it does Generates a unique output number for every input number within the range. The relationship between the two numbers is not immediately obvious — and is difficult (although far from impossible) to discern, even if a user manages to see several numbers output in sequence. Why you might want to do it If all you need is a unique, random identifier, you’re in luck: That’s what RECORD_ID() is.¹ The downside is that something like recdalXVhg9AkUMG9 can be unwieldy; at times you may need to generate, say, a 4- to 6-digit value that is (a) unique, (b) random, and (c) not impossible to hold

Hey there, We’ve recently been looking for a way to evade the limits we face with Airtable API. Now, we’re happy to share a migration tool to move Airtable data to PostgreSQL with you. All you need to do is connect your Airtable data and your Postgres database, and click “Move”. As a result, you get a flexible solution with all your Airtable data migrated. Your credentials are safe – we do not store anything.The tool is totally FREE, and you’re more than welcome to tell us what you think about it and ask any questions! We’re willing to further improve the tool based on your feedback.

Is any tips/hint for exchange from one currency to another ? example is a sale of the same product in more currency around the world like $ (dollar) € (eur) £ (sterlin). I like show the product value in only € (euro) and imput in table the product value sale around world with the sale currency ? ( like sho : on sale cookbook 25€ | but my input is : store in london 20£ | store in newyork is 22$ etc…etc…) thankyou

We’re seeking an Airtable consultant to create a staffing tool. We’ve looked at the dedicated SaaS solutions for staffing firms and find them not flexible enough for our needs. We’ve already sketched out a set of user requirements. We are looking for a consultant to help create the tool, and then provide ongoing support over time as we will surely want to expand and improve the functionality. If you can recommend an Airtable consultant, please share their contact info or website. If you ARE an Airtable consultant with relevant experience, please share your email or a Calendly link and/or your website link so I can grab time with you.