Builders Board

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

For those of you needing to perform a Standard Deviation calc (STDEV() in Excel), here’s a template you can use for performing this calculation with values across a single row (record): SQRT( SUM( POWER({Value 1 Field} - {Avg of Values Field}, 2), POWER({Value 2 Field} - {Avg of Values Field}, 2), POWER({Value 3 Field} - {Avg of Values Field}, 2), ... ) / (n - 1) ) Where n = the number of fields SUM’d, ie, the number of POWER() statements. You do have to manually enter each field that holds a value which you want factored in to the StDev calculation, and you have to have a field that calculates the averages of those values, so this will not work well for a dynamic data set (new values are constantly being added to the list of values needing to be included in the calculation). I use it quite frequently in calibration specs, however, so I figured I’d post it here as a qu

The inspiration for this script was the many posts that I saw where people wanted to setup default values when they create new records. In that way, it is similar to one of the scripts that has already been shared. However, I believe that there is no one right way of doing things, and I had ideas for a different workflow. This script fills in blank cells in a table based on a template record. It also requires no configuration of the script, and no changes to the existing table/field definitions. This script has the ability to make bulk updates to a lot of records very quickly, and it has several quirks and limitations. I only received access to the Scripting block when it was made public on Friday, so I didn’t have much time to get up to speed. I have many improvements in the works, but they will all take time to implement, and I need to sleep. Here is the

We are looking for help with Air table Project management Gantt Bidding Payments Estimating Etc

I’ve gotten Car fever and want to start doing research on used cars that fit my price range. I tried some of the consumer sites, but was really left wishing I had a place to look at all my research at once and compare things like average price and milage for a specific Make, Model, and Year. So I hooked Airtable up to the MarketCheck API via the scripting block and made a base that pulls in all available car listings within 50 miles of me within my specified Price and Mileage range. Then, made use of Page Designer and URL preview block. It’s pretty dank if I do say so myself. :star: :star: :star: :star: Overview of How it Works Here Copy of the Base Here Have fun y’all😃.

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

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 h

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

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 int

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