Builders Board

hi there, i run a construction and property management company. just starting using Airtable. first task is to get someone to convert our ugly excel sheets into Airtable bases next is to consult on how to setup other bases for our business thanks!

I need a fairly advanced Airtable database set up and automation created based on the Airtable database for a subscription box company that delivers different items in each box based on customer preferences - no two boxes are alike. Box Dimensions Medium box: 27.9x21.5x14 cm (11x8.5x5.5 inches) volume: 8397.9 cm Large box: 30x30x15 cm (12x12x6 inches) volume: 13,500 cm Box types and cost of goods Regular - should fit in small box only, cost of goods is $10 More Loot - should fit in small box only, costs of goods is $15 Figurine, should fit in medium box but can also fit in large box if required. Cost of goods is $30 (this is the only box relevant to this job currently) What I want to accomplish using Airtable, HubSpot, and external scripts (if required) HubSpot contains all of our customer records and their item preferences. Airtable contains the database of all

Relatively simple project for our medical marijuana farm - but need some help. Specifically - we need lots of different reports but I’m not sure how to produce those easily in Airtable. Thanks!

We are looking to build a project. Create a Contact/Lead management system that not only houses all of our contacts/leads, but can “Merge” the db fields into simple Form Letters of choice, that can then be printed fro mailing. Kinda like a we can with Filemaker Pro. Is this something anyone can help us with?

I’ve been using Airtable for a while now on a limited basis. I really want to deploy to my entire company as a project management tool (one base with tables for Clients, Departments, Projects, Tasks, Notes, Events, etc), but two key features are missing for me: A Dashboard- What I’d like is a kind of “me view” that any user can use as a home page for the base… it would automatically display (in some simple grid/block form) everything related to a given collaborator… every client, project task, message, etc, that they are associated with… with clickable links to the actual record in Airtable. This is far more than a custom Airtable “View”, because it involves data from more than one table. A Reporting Tool - Basically, we need to be able to (at a moment’s notice) generate a printable project status report from a given Airtable view (a grid/spreadsheet-style view of dozens of projects, ideally with page headers/footers, numbered rows, labeled columns

I don’t have a sales background and I’m thinking this must exist already and I am probably reinventing the wheel. . . I need my table to track when and how I contacted each prospect so that I can see at a glance when I have made contact with someone, and when I should follow up and how I should follow up and notes about each connection. I am hoping to find examples that do something like this. . . . Thanks!

For business use Order system Task management Dashboard Catalog system Vendor database Need someone to help since I’m new to airtable Please msg if anyone is interested

We are new to Airtable and seeking help to set up a single view of pending/ongoing projects. Currently the information is stored in google docs and excel.

We are an international organization that offers wellness courses globally. We are looking to develop a contact database to handle all of our course prep, applications, processing and post course follow-up using Airtable. We would like the database to handle our first touch point of a new expression of interest of an individual and take them through multiple course applications, to post-course follow up, mentorship and communications with them many years down the line; and to organize all of this data in a simple and efficient way. We also want our workflow and communications with the individuals/groups to be as automated as possible using integrations through Zapier with mailchimp etc… We also need to integrate our workflow into our wordpress website We are looking for an Airtable, Zapier, and Wordpress expert to assist us with setting this up. We have a rudimentary system set up. We would like to take it to the next level.

i’ll pay :slightly_smiling_face: I’ve built tons of websites… but i’m looking to create something a little more concrete for a specific project… getting the plan & task list out of my head is proving somewhat time consuming… and translating it into a base might take me til next year. if someone has something that’s working for you in this realm, and you’d be willing to share, i’d be super grateful. Thanks

Need help setting up my database and linking records. Glad to share more information.

Hello, I’ve got an airtable set up and running, but I need help designing a formula that checks multiple cells and returns a result. I’ve tried to do this myself but to no avail. Its all IF formulas (I believe) If someone is interested and wishes to contact me with an indication of price that would be appreciated Thanks

I have just published the latest in my blog series about using Airtable combined with other Apps to handle specific business needs. In this post, I am exploring the use of Process Street, a tool for creating template based Checklists for making repeatable procedures, with Airtable. It provides an interesting option when you need people who you don’t want to access your bases directly, to have a means to interact with data in a structured manner. You can read more: Automating Processes with Airtable and Process Street

We are Epidemic Sound, listed in Wired as one of the best startups in Stockholm this year. We sign many new Songwriters/Producers and Singers each month, and produce about 150-200 new tracks per month. There’s a ton of information to organize and keep track of. People, music files, legal documents, lyric documents, status, revisions, etc. etc. We believe that Airtable can do the trick for us, but we need help to structuring and setting it up according to our needs. Ideally we would have it tailor made and integrated with appropriate Zaps and apps to make workflows automated and super easy to use. We offer work starting asap and we’d love to hearing from you Airtable and Zapier-fanatics! :slightly_smiling_face:

This week I nested an IF function three layers deep. It was hard to read and hard to write. There must be a better way, I thought. I read some articles that said to avoid nested IFs using AND / OR. Then I watched this video on how to use it: Bingo! Now I feel empowered to get even fancier with my formulas (if I need to) because I have these additional functions.

I need to calculate summary weighted averages - for example the weighted average interest rate for a number of loans that are records in a loan table. The summary bar is very limited and you cannot create any calculated fields there that I can see. e.g. Loan Amt Rate $100 5% $150 3% $600 9% The weighted average interest rate is: ( (100*.05) + (150*.03) + (600*.09) ) / (100 + 150 + 600) = .07 = 7% Any ideas as to how i can do this?

I’m looking for a solution within a form to inserat data into the database. Each data has separated fields for billing and delivery address. But sometimes they are equal, and it would be much easier to just set a checkbox if theses addresses are the same. If not, there should appear all the fields in the form to enter a different address for the delivery. Can anyone help me or show me a case where a form is done like that? thanx a lot.

Hello, I have an inventory database that need some assistance with. I have an Inventory table with part number, description, part ID, UPC description, cost, number of units… Then I have a transactions table. There are three types of transactions, RECEIVE to receive inventory into the Inventory table and a location, STAGE to delete inventory and stage to a project, and TRANSFER to transfer inventory from one location to another, which is basically a STAGE and RECEIVE in one transaction. I’m need assistance with the transfer, and my other issue is that I need to view inventory by location. Any developers out there I could hire to discuss and finalize the base?

I am searching for a consultant who can create a database of multimedia assets (photos, images, videos, written documents, story leads, etc.). The goal is to be able to quickly find assets based on type of media, geography, date, and a few other criteria. We need to start this work in November and it must be finished by March 2018.

I’ve just written a blog post which some people may find interesting on the topic of sending Email (or other) alerts from Airtable using Scheduled Zapier Zaps. If you’re interested check it out: Sending Notifications from Airtable I’d welcome any thoughts and comments!

I’ve noticed there have been some posts recently about Scripts for Airtable - for coders wanting a way to build clickable actions on top of airtable. I thought it might be a good idea to write an article for the non coders amongst us who may have similar needs - and it turns out that this is possible using Zapier (when Airtable is used in the Google Chrome browser). I’ve written an an article in my blog about how to configure a “Push Zap” to send an email to an employee (using my KasPer Lite base in the Universe) letting them know how much holiday (vacation) they have remaining in the current year - and also updating the Activities table in the base to record that the email was sent. You can find a link to the article here: Using Push Zaps

Main goals are to track the following: People looking for grants from us and their history People offering to volunteer and their history doing so with us People who have donated (how much, when, how many times total, average, via what program/ promotion) Grants we’ve applied for Who to follow up with next Event/ marketing planning Anything I’m missing. :slightly_smiling_face: FYI: Our NGO is GROWfound.org. We provide grants to individuals and groups doing research, prevention, and treatment of addiction in all its forms.

Hello! I work at a VC and am building a system to track all of the work and data associated with companies, projects, and people. Looking for a partner to help do some custom work (and possibly just generally advise since I’m new to the platform). I anticipate it will be several hours spread over the course of the next month. Examples: If I link to a LinkedIn company profile, I’d like to be able to pull in # employees and have it auto update. If I link to a company’s Crunchbase profile, I’d like it to pull in the company’s most recent funding amount and recent news. I’d like the system to remind me to reach out to each of my contacts on a predetermined basis. I would like to migrate all of the candidates I’m tracking in SF to airtable. Probably ~15 things like this. Please send me a private message if you’re interested, and let me know your availability, rate, and any questions you have. Thanks!

I want to combine develop an airtable that allows me to track general marketing activity as well as content development/publishing and link to website/channels to track statistics. I will need help on a ongoing basis once this first table is set.

I’m revealing a basic hole in my failed upbringing, but I could really remedial training on ARRAYs . I’ve looked at the formula documentation but … And, I’ve looked at the AT Community, but … So, I’m pretty sure that ARRAYS are useful and solve problems that I’m bound to have, or do have and don’t recognize the obvious solution. So, any pointers to entry-level training with lots of examples, documentation or videos will surely correct my personal shortcomings in this area.