Builders Board

Hello all, I’m looking for help on a particular project. It’s a visual directory of people/things/activities/relationships specific to a particular industry. I have a base in Airtable with tables setup… The 4 main tables are as follows: Person Company Project Relationship The idea is those 3 main entities (Person/Company/Project) all have relationships to each other… And that those relationships also carry data themselves. For example… Bill Gates (person) has a relationship to Microsoft (company)… but we also want to know the time range that relationship was valid (from, til), as well as the nature of the relationship (e.g. CEO). What I want is for this data to be available on a web portal with the ability to search the database and make queries. The queries could be simple: (e.g. “Show me all PEOPLE who work for MICROSOFT”), or they could be more complex (“Show me all PEOPLE who worked on WINDOWS (project) for MICROSOFT (company) between Jan 1, 1995 and Jan 1, 1999. As the p

Hello AT community of super smart consultants, I have been using an AT database for about two years now. Over the years, we’ve added, adjusted, and evolved it to what it is today. And what it is today is good, but in my gut I feel it can be better. Coming from the standpoint of ‘I don’t know what I don’t know’, I’m looking for someone to evaluate what I have, understand my business, and consult on ALL that can be possible using all available features of AT. Thank you for your help! Vita

I have an Airtable base, I have a website. How can I hook them together so that website visitors can search the databases?

I have a pretty simple database I use to make repair tickets. I receive the repair request via a form submission on our site and import it via Zapier. When I send each record field to the different shops to handle the repair, it takes about 4 pages of paper to print out. I essentially need to be able to reduce the amount of spacing between listed fields so it we can reduce the number of pages each shop has to print out. Anybody got experience with this? Thanks, Dominic

Hey all, So I am new here and totally new to word of airtable and databases, my knowledge ends at 10th grade excel. We are a bakery in Berlin, Germany trying to readjust to life after Corona. I came across Airtable but am too busy trying to run a bakery rather than trying to learn a whole new software. We are trying to get a database together, in which we can easily input new ingredients/suppliers/costings/recipes and link to our sales to manage our overhead better. Here is a list of things I am after. Ingredients and recipe costings (we reuse ingredients in our kitchen, bakery, retail space and online retail space, focus on zero waste) Easy recipe and costing generation forms intergration with pos (we use orderbird, cybake and shopify currently) production planning shift planning financial reporting. All this is just the start, we are seperating our wholesale department into a seperate logistics department, doing b2b and b2c. I know airtable is a powerful tool and would really appre

I either need to add a new field and link it appropriately or set it up as a new table and link it accordingly. Super quick turnaround preferred.

We are an alternative energy finance company in Dallas, TX that is reviewing Airtable to handle our (simple for now) database needs. In the short run I expect 1 base with 4-6 tables that focus on definable assets (with lat/lon coordinates), their links to a geographic area (counties or sections thereof), their owners, and then any contacts/CRM type stuff. I have built a prototype/sample myself, but am having trouble automating the links (writing the script defeated me for now). Could use immediate help for deciding, and this could turn into an ongoing gig. Local helpful (Dallas) but not required.

I use tags to highlight some characteristics of records in my table. In this dataset I want to highlight whenever I have a “Stale Deal” and/or a “New Customer.” I want to use multi-select options because they’re easy to filter and chart. However, I don’t want to manually tag each select option, because there’s a formulaic way I can assess these characteristics: ‘New Customer’ = Deal Count is one ‘Stale Deal’ = Time since last inquiry is > 30 days. I’ve tried to do this via a formula and isn’t pretty to write, read, filter, or chart by. So, why not replace that formula with a script? Works like a charm: Link to the base here. Happy Scripting! /* Calculations: 'New Customer' = Deal Count == 1 'Stale Deal' = Times Since Last Inquiry > 30 */ // Load Records let table = base.getTable('Data'); let query = await table.selectRecordsAsync(); let records = query.records // Create an Array of tags when a record matches the criteria let check = records.map( c => ({id:c.id,t

Hi everyone, I’ve a request, my situation is : I have a table with my customers database with name, phone number, etc. I attribute to each of them a partner. And I have a table for each partner. So I would like to know if it’s possible to put each customers in the right table of the corresponding partner automatically (using only the customer’s table) and how? Thanks a lot in advance!

When a record has multiple date fields, sometimes you’d like to know which date is the earliest. In the below example, each record is a social post that has different live dates for different channels. I’d like to know the earliest live date across all three channels. I could do this in a formula, but the ‘LIVE DATE’ field is also used by other teams, so I’d rather calculate the date with the below script (plus the awesome batchAnd script to do this for more than 50 records): Example Base Here // 🌸🌸 👇Add all the date fields you need here 👇 🌸🌸 let fields = ['Instagram Date','IG Stories Date','Facebook Date','LIVE DATE'] // Let Airtable know which table and views records you want to use let table = base.getTable("Content"); let view = table.getView('All'); let query = await view.selectRecordsAsync({fields:fields}); let records = query.records; // Find the Earliest Date let dates = records.map( c => fields.map( x => (c.getCellValue(x) != null && x != 'LIVE DATE') ?

Basically I want to use airtable to integrate the 2 worksheets of data (education business, data comprises student registration, payment, exam result and funding administration). Want to create a single data source for everyone in my company, and use airtable to display and data in a meaningful and productive way instead of relying on column view.

I’m not sure if what I’m trying to do is even possible with Airtable. But it needs to be as user friendly as possible because it will be used by employees of my company. I’m a service based company and I’ve been using Airtable to track work for various customers. Requirment 1 - Workorder To be able to fill out a form with relatively simple user experience. Ability to enter a lot of data into the form with a minimal interface (ability to hide fields until they are required would be ideal). Also data in the form must link to other tables and grab data from those tables. Also the form must be able to collect signatures. All on mobile. I tried out Fulcrum on a recommendation and it has everything I need for the form side, but not the data management or report side. So if you’re familiar with Fulcrum you may know what i have in mind. Currently all data is entered directly into the table and is a clunky experience at best. It’s embarrassing trying to teach people how to use it. Requ

Busco experto en crear plantillas de Airtable para tareas complejas de plantillas ya creadas por mi, pero que por conocimiento aún no las puedo completar. Por favor los interesados tomen contacto en Español comigo. Saludos

I am looking for someone to help me set up my database and mentor me through the program. I understand it, though do not have the time to devote to learning it to make sure I am setting up correctly. Thank you, Kirsty

It’s a quiet Saturday in my office and while I should be working on a client’s project, I found myself intrigued reading the various responses to Airtable customer requests for help from consultants. Some of them had me chuckling and others were simply boring. A few even triggered yawns from time-to-time despite being hopped up on Black Rifle Coffee. This post is yet another tell, and no show. Just a few tips from an old dude who’s written about 41.8 million lines of code. I’m an analytics guy, so yeah - I pretty much know how many lines of code I’ve written since 1978. Being this old and this “seasoned” in the fine art of crafting software, I get away with saying stuff that might come off as crude or insensitive. But, my candour might also help you avoid some blind spots. Feel free to push back on these highly opinionated perspectives and know that if these were considered crimes, I would be on death row. :winking_face: That said, here are some tips to pick winners - both consultant

Hello All, I am looking for a good article that explains what a Airtable base is? When I look at https://airtable.com/pricing Records per Base seems to be the main difference between Free, Plus and Pro? That leads to the question, what is a Base?

I have a a database in two formats, a complete one and one for public viewing with some private information hidden. I have three forms related to the databases that also need to be embedded on a website. Need some help, or direction to a tutorial that will give me some info on how to accomplish this.

I currently have all of the components on separate basic programs that I would like to integrate on AirTable, I understand somewhat but know that this platform is quite powerful if used correctly and need someone expert in all of the nuances in order to set up form the beginning in the correct way to maximize usage. We are a Tailor-Made private Travel Consultancy and also do some online web corporate events. Currently located in California during this surreal period of time but usually based in Florence Italy. Please contact me jennifer@tuscanturtle.com Grazie mille! Jennifer

Hi Is it possible to add a condition to trigger an action (like hyperlink redirection, e-mail, …) after changing the data from a specific field? Cheers, Marcelo

Bigwig.com.au is an Australian financial services business. We are seeking a developer with airtable API experience to help build our website which uses an airtable database as the back end.

Hello all, I’m looking to hire a good consultant that can put together a comprehensive Airtable with various bases. Some of these bases will need Zapier integration, with apps such as Typeform, Mailchimp etc. This will initially be a setup type consultancy, but then some ongoing ‘housekeeping’ with the project. Please contact me on sam@cholera.me Thanks

Just posted a 7 Wonders scoring app built in Airtable to Airtable Universe. Airtable 7 Wonders Scoring App - Airtable Universe This base is for those 7 Wonders fans who are looking for a scoring solution that can account for ALL the expansions (including the most recent, Armada)! ​ ... Let me know if you have any feedback! Thanks to @bdelanghe for helping with the scoring algorithms.

Good day. We are using a 3rd party ordering system for school meals and need to print physical vouchers (of the pre-ordered items) to distribute to children which they then in turn use to redeem food. Thank you in advance.

Looking for someone to help us build out a workspace for my race event. Basically this is how it breaks down: 1,500 Racers …making up 450 Teams… …across 80 different classes… …over two days of racing… …with 6 total races… …on 3 different race courses… There are many different components to the event like merchandising, ticketing, vendors/exhibitors, staffing, etc… We are looking to organize things under one roof and utilize AirTable to its full potential, just need some help getting things set up.

EdTech Start-up. While we can spend the time building everything ourself… We are looking for someone to create it quicker and more efficiently than we could - saving time and money down the line. We are also running into problems with users (we will have many ICs that need to view a workflow table AND only collaborate on it IF they choose- without admin permission or approval). We would prefer not paying individual user fees connected with Airtable for everyone who’s sitting around - maybe deciding to collaborate… so need to find a workaround. There will be a lot of little things like this where we could use an expert! If you are available for hire on Upwork - even better!