Builders Board

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!

To All The Volunteers: I would like to give a shoutout and a thank you to all the volunteers that go above and beyond, to help the Airtable members. Even with your busy lives, you still manage to find time to help. I, for one, am grateful for the many times that I received such great help. Thank you, Mary Kay

Hi, we are a venture capital firm and are looking for an Airtable consultant / developer who can help us develop a custom tool to easily and visually track upcoming events / catalysts for our portfolio companies. Baseline needs include an interface for inputting events, a Gantt chart visual summary output, and automatic reminder function. Bonus if we can figure out a way to integrate info like stock price / market cap from public sources. Please email me if you think you can help! Thanks kchu@fprimecapital.com

Hello, Im looking for someone show me how I can stack rollups from multiple tables into 1 summary table. Would like to be able to do this myself… but will be happy to pay for the tutorial For example (this is abbreviated) Table 1 … Has a rows for every day. Column 1… is Unique Page Views… Column 2 is Leads that came from the page views… Column 3 is a formula that calculates the conversion rate Table 2 & 3… Same thing I’d to create a table that has a row that summaries the sums of the values of each table … with each ROW being a table So Table 1 - Total Page Views In April , Total Opt-ins In April (The Conversion Rate would be a formula ) Table 2 - Total Page Views In April , Total Opt-ins In April (The Conversion Rate would be a formula ) Table 3 - Total Page Views In April , Total Opt-ins In April (The Conversion Rate would be a formula ) Let me know if you can help or have any questions

Hey, it’s Andrew the Founder & CEO of SportsForce a National College Athletic Recruiting company. We are a fast-growing sports company that is ready to dramatically expand our business and improve our operational efficiencies. We are seeking an experienced AirTable expert to assist with our integration and implementation of AirTable, Zapier, InfusionSoft (CRM), Google Sheets, Google Suite, and More. We foresee this being an ongoing project, not a short term engagement. We have put together a video overview to help you clearly understand our current goals, a few example manual workflows, and our software stack before considering the project. This is available upon request for great potential partners. We have organized documented workflows for a large majority of our business including video tutorials for many processes already. If you are up for an exciting challenge! Please comment here on why this project interests you and your quick background. Thanks, Andrew andrew@sportsforc

We would like to be able to see the capacity of teams at any given time based on current workload and future projections. I don’t want to be too prescriptive, but we have data at two periods within the lifecycle of a projects. In the beginning we have forecasted estimates of how long it will take and known future capacity - we would like to see if we need to hire for future time frame Once a project gets into scheduling - we have a decent view of capacity, but it would be great to do some rollup and reporting of that data.

Hi! I am building a digital bullet journal for my personal use and would like to hire a coach/consultant that could help me. I saw templates but I would like to have some tailored/complex features and I tried to do them myself but it takes a lot of time to even understand the right question/point of view, so I would be grateful if someone could coach me through it and potentially also delegate full parts of it and save a lot of time. Is someone interested? Thanks, and looking forward, Have a nice day, Giulia

Hoping to get some insight into how to build an airtable base. Context: Our business development department is collecting information internally on prospective vendors. They’ll then input the information into airtable with the expectation that all documentation can be outputted into 1 seamless “packet” of information taking all documentation from airtable. Here are the requirements of the base: 100+ vendors 3 Phases of document / conversation completion. (Ex: In Phase 1, we must collect the Brand Analysis document, and have a “Top to Top” conversation. Each Brand Analysis document and Top to Top conversation will be the same, but the responses will be unique for each vendor. There is a chance that the Brand Analysis document (for example) may live in Airtable, or may be an excel document. My fear is that if the information is standardized (even captured in a form) it’ll mean we must have a table for each conversation/document (brand analysis, top to top, etc.) Approval by management (

Hi all, Been using Airtable since 2018 and keep discovering awesome things everyday. One of my other ventures is building apps with no code web database tools. One of the new Airtable tools I found recently is a service called table2site (posted here before) which allows you to build websites using Airtable as your CMS. I built a site called NoCodeStudio and I’m really happy with how it turned out. Right now it’s focused mainly on Knack and Tadabase, and web design tools, but I’m planning to add Airtable resources as well. I’ll just stick this here to get it out of the way… NoCodeStudio is a community oriented collection of resources, tools, tutorials, builders, and more - specifically for no-code web database apps like Knack and Tadabase. Visitors can also submit new resources via an Airtable form. Thanks for checking it out - https://nocodestud.io And don’t forget to look at https://table2site.com No affiliations with table2site, just sharing.

I’m looking at learning more about Airtable and using it for my small business. This platform seems promising however a sales rep from another company (Quick Base) had pointed out the following limitations of Airtable. Airtable Limitations (according to a Quick Base rep) Limited Data Set Support: Airtable has a data limit of 50,000 records (rows) that organizations can quickly outgrow. Basic User Permissions Means Weak Data Security: Airtable has a basic user permissions security model that allows anyone invited to a workspace to view all of the info in that workspace. In addition, anyone needing to add or modify records requires Editor access which includes the ability to change and delete tables and views that may be needed by other users Lack of Reporting: Airtable lacks the ability to create reports that can be shared with management and others. Viewing tables with records grouped together provides very limited data summaries in the workspace. Are these statement accurate ab

I’ve seen a few posts in recent weeks from people asking about how to get started with Airtable scripts (e.g. here and here). I think people are, rightly, seeing the scripting block as a powerful piece of functionality and for non-coders it can be a struggle to know where to start (I know from bitter experience!). It is all there on MDN, but even the first sentence is putting up barriers: ==== JavaScript ( JS ) is a lightweight, interpreted, or just-in-time compiled programming language with first-class functions. ==== What?! My small contribution to this is to start an Airtable scripting blog with some practical walk-throughs of how to get to what you want to do with an Airtable script: Airscript Home An introduction to scripting on Airtable bases for new coders The aim is to provide an introduction to scripting on Airtable. It isn’t the definitive resource on JavaScript code and standards (not by a long shot) and, even within the Airt

With the recent launch of the Scripting Block, we’ve been excited to see all the handy things created with it (and cool to say that @openside won a contest with this nifty script also!). So we made a central resource to host ALL the user-created scripts (code + description + source) for the scripting block and put it here. It had to be done. :woman_mechanic: Here are a few screenshots: You were wishing for a central place to find all the script-block goodness, admit it. :slightly_smiling_face: See the Scripts Library Have a script to add? Click through on the link above to submit it. Hope it’s helpful!