Builders Board

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.

Hi I am looking for someone who can assist with Stripe integration and setting up Monthly and Annual Subscriptions.

I tried adapting the template for “Product Catalog & Ordering” but it breaks if you need for, say, User A to buy multiples of an item. What I need to do is to track orders for multiple people of items (Jersey in Small, Jersey in Medium, Shorts in Medium, Shorts in Large, etc.) and some people may order multiples of a single item – and I need to track and pass along the unit price * number to customer purchase total. Help?

HI. My name is Stepan. I work in the field of process automation, and often use Airtable as a database for my clients. Want to start a video blog about some tricks how to make Airtable automations. I’m here to ask, what kind of integrations/automation would be the most interesting for you? Feel free to make your suggestions here. Thank you!

Indeed, views provide a very powerful way to scope and optimize access to data. However, they cannot be dynamically altered to achieve what I consider hyper-performant script processes. Here’s an example… Imagine a table (a) with a view and when a record enters that view, search another table (b) that has 45,000 records in it for a single matching key so that a linkage can be established in (a) to (b). I’m not an expert in all manners of Airtable scripting, but I think the only way to do this is to iterate across the 45000 records in table (b) to locate the record ID such that the linkage can be updated in table (a). Ironically, searching for discussions about this place me in the commentary mix here. And even then, I’m not sure I expressed the issues succinctly. Two ideas come to mind when presented with this quandary - Ideally,

Hi All! Was directed here from another thread, as I am not a JS coder, but would love to have this code requested below to learn from and continue to work on. I am looking to run multiple search scripts in three fields where users will enter a long format answer explaining their project needs. These are populating in a request table that I connected to a form interface. I have second Airtable that lists out my talent at my agency and have created a ‘Keywords’ column that lists out all the different expertise fields and past industries. My goal is to search through the long format answers client input and connect the keywords to the best match talent in my pool. Any one available to take on this project? I have budget and am willing to work with someone to set up this script. My goal is to have this script in the next week to continue

I want to get only fields in my tables through the rest API. I have tried using https://api.airtable.com/v0/meta/bases/BaseId/tables api given in the https://airtable.com/api/meta documentation but it is giving me NOT_FOUND in response. Is there a way we can get only fields for the token provided through REST API?

I’m really proud to have worked on this and I hope that it brings some of you the joy it has brought me. So if your Labour Day resolution was to stop spending so much time pressing ctrl+c and ctrl+v migrating Google Sheets and Notion files into Airtable then you might want to check out Unito, our new 2-way integrations were designed specifically to save you time so you can seamlessly connect to all the other apps where work happens. Unito.io

Our business has used Airtable to make a database for our direct to consumer manufacturing business. The good news is that our business has grown, the bad is that we are constantly fighting with the 50K record limit. What we are looking for is connecting our Airtable database to something that can handle substantially more records. Basically using Airtable as a “front end” to the larger database. Currently, most of our records are tied up in the bill of materials (BOMs). Most of the BOMs are not currently active (we aren’t currently building that product), however, we need that BOM data to accurately inform our part purchasing. We currently have a workaround using Airtable’s table syncing but that has only bought us some time and is not the long term solution. At the end of the day what we are looking for is a way to use and store far more data than Airtable can handle while keeping Airtable as the place where our employees interact with that data.

Hey Airtable community, Today we officially launched our new Chart blocks on Softr. The new chart blocks work seamlessly with Airtable, allowing you to turn a table of records into stunning, interactive charts which can be created in a matter of minutes. To provide you with a quick example of what can be done with the new Chart Blocks check out this example of a building in public page to share your metrics. This template is now available to use today. We are continuing to iterate the new chart functionality and will be releasing a number of further improvements in the coming days. You can learn more about Charts in today’s update found here. We can’t wait to see what the Airtable community will use this new functionality for.

(Sept 2021) Hi, all! I’m looking for a consultant to help build out the text-based communications and ordering capabilities for a food pantry that serves 40,000 people a year with mobile and partner-based services across New York. We’ve piloted with my (very basic) Airtable and Twilio skills, and now we need to step it up! I have a light tech background, but I’ve managed IT and product development teams for many years and bring great respect for solid technical skills. If you’re flexible, reasonably fast, a good communicator, and interested in helping lots of low-income and older New Yorkers get connected to the healthy, delicious food they need, join us!

Hi all, My company is currently looking for an Airtable developer that would be able build our company’s financial tracking system. Preferably looking for someone who has worked with both entertainment and finance companies. We’d also love to work with a developer who can better automize the workflows we have in place. If interested, please email me at amelia@2am.com Thank you

Hello, I just made my first Script app writing my own custom code :tada: and wanted to share :blush: Context: I am working with a base that has gone through several iterations of development and am trying to resolve some contradictory data sets. Specifically, for a directory of people who get assigned a “level.” There are five different fields to compare and resolve so as to make a single source of truth for each person. My fiirst step is to identify where there are mismatches across the five fields (a rollup, two lookups, and two single-select fields). My first thought was to use a nested IF() ƒormula, but I found it difficult to construct the matching logic for the fields values and for when any them are without values (i.e. blank). My next thought was to use an array formula to make an ARRAYUNIQUE() out of an ARRAYCOMPACT() values (i.e. remove the blank values, then look for unique values). To my surprise, the Array fu

Hi, sometimes button format is not convenient, when you have to assign scripts, related to table, not records. i think that buttons needs at least be possible to show/hide in different records. And change label. And color. And script assig… okay, that could be done by “Switch” in single script :grinning: Well, I’m not with a complain or proposition, just want to share example of using Singleselect for UI. Triggered by automation, returns to default state “CHOOSE ACTION” (other records default is ‘inactive’)