Builders Board

tl;dr version: A frequent query and/or complaint concerns users who wish to access data from a record for use in a calculation performed in a different record from the same table. Often this takes the form of a user asking ‘how to retrieve a value based on row number’; other times the user wishes to perform a calculation that assumes knowledge of the previous record — for instance, maintaining a running balance. A recently published base contains four approaches to this problem, three involving sequential records offset by varying numbers of days, and a fourth allowing retrieval of arbitrary data from the previous and previous-but-one record. Lately, I’ve been playing around with cross-record or multi-record calculations — that is, the ability to retrieve a value from a prior record for use with calculations in the current record. This is a recurring issue for users who conflate Airtable’s spreadsheet-like appearance with presumed spreadsheet-like functionality and wonder why they can

We need a mapping solution created using the Maps Block in Airtable. We are mapping properties and tracking marketing campaigns. Markers must identify property location and status by color. All data and notes on campaign results and properties must be contained in Airtable and linked directly to property/map location. Email directly Wealth@InvestHypothetical.com

We are needing help building “if” then formulas. This would help our team when they are using the database as an invoicing platform using the forms Airtable provides. Currently, some charges are separated from other databases to alleviate the need for directions. However, our clients want to combine the charges together. Overall we would like to fix a few roadblocks we hit after using for a few months.

Hi there, We are a voter guide platform and have been using Airtable for a few years now. This year, we are getting ready to build our biggest voter guide to date. We want to work with an Airtable product/project management guru and was wondering if we can hire a consultant that is a total pro at building out product/project plans using Airtable. Feel free to email go@voteprochoice.us if you’re interested!

looking for Airtable expert to design our workflow in Airtable. We are an appraisal company that is a few project we would like to use Airtable for. However, I’m not sure the best way to structure the project’s to potentially integrate with Airtable and would like use airtable more efficiently and taking advantage of the technology.

For a variety of investors and traders, it would be useful to have AirTable import current stock prices. Google Finance offers this simple functionality within Google Sheets with this format: "=googlefinance(stocksymbol, “price”). If there is a way to achieve this function in AirTable by linking to Google (or perhaps Yahoo), please share your thoughts.

I need some simple Airtable here. Mostly reading values from Airtable and throwing them through an API operation via python, then returning values and populating back into Airtable. Please let me know if you’re available to chat.

I couldn’t find a template that was already set up with an invoice and the option to add payments, see previous orders, etc. So I ended up making one! I’m sure there are issues with it, but it’s a good starting point. I hope you find it useful! Airtable Shared Invoicing - Airtable Explore the "Shared Invoicing" base on Airtable.

Hello, We have been using Airtable for almost a year. Currently we need to send an email to a vendor that has not billed us for various assignments. I would like to use zapier to send the emails or possibly Sendgrid. The email should contain all unbilled assignments in a list or table view for each particular vendor. Thank you

HI I have a music festival this has multiple stages and needs a time line with blocks designed for time slots and over three days… this needs to be in a calendar form so I drag and drop a band into another time slot. and then turn this into an online link to go to the website. can someone help design this. ?? thanks Kenneth

Hello, I work for a medical non-profit and am seeking assistance in setting up an Airtable workflow for our digital marketing efforts. This should be a simple configuration (no 3rd party integrations) with a goal of consolidating our various outreach methods (social media, web, email, etc). If interested, please respond below or reach out to me directly at edalboe@idsociety.org with your information and any work samples. Thank you, Elizabeth

Willing to Venmo for a formula I need. I have a list of incoming address as follows 1234 anywhere st, San Diego, CA 90001 I need to execute a text to column function based on commas.

Hello fellow consultants/experts, Dan from Openside here. If you’re like me, you love working with people building out workflows in Airtable. It truly is a remarkable product and has enabled companies to take their workflows to the next level. But, it’s not always easy and does take time. That’s where we (you and us as airtable experts) come in. Openside has been doing this for a while now, and believe we’ve learned a lot. We decided to open up our strategies and help more people get the help they need. We have a steady stream of customers coming in and want to make sure we can help them out. If you have any interest at all in what we are doing and interest in partnering with us in some capacity, check out this video and fill out a quick form to express interest: https://openside.com/join-experts nothing to commit to, just trying to broaden our network of amazing people we want to work with. Hope to hear from you!

I was thinking about how to add some functionality to a base and, for the base user, how they would trigger this. In most web apps functionality will be invoked by the click of a button - save edits, delete a record and so on - but this button functionality isn’t available in Airtable. But…Zapier provides a webhook component that can be invoked to kick off a Zap. I frequently use Zaps in my bases and they are mostly triggered by the standard Airtable triggers - new record or new record in a view. One downside to this, which this demo gets around, is that a record can only be triggered once (or once as a new record and once in a given view). By using webhooks to trigger the functionality, it can be executed an arbitrary number of times for any record. My demo for this is based on translating content from one language to another. I have some text in English and I want to translate each record of content into German: I set up a Zap that: triggers on-demand gets the EN content translates

I run a media company with many podcasts, blog posts, youtube videos and more. I’m looking at setting up Airtable to be my content calendar and tracking. I’ve used Google Sheets as my main “database” but have been playing with Airtable and can see the power of it. It would need to be able to track tasks to individuals and give deadlines. It would be complex and likely need to integrate with Zapier which I use a ton of. Let me know what more you need to know! Thanks, Ryan

Hi All! Last weekend I was involved in putting on the Consciousness Hacking Holiday Party. We were using [MUSE Headbands][(https://choosemuse.com/) for a meditation competition. The headbands measure brain activity and we competed for the highest scores of relaxation and focus. With over 60 competitors we used Airtable to manage the entire competition. Each volunteer recorded the score of the competitor and took a picture of them. All the results were sent to the big screen in a “Keep sorted” Gallery view with the winners at the top and if their score was over 500, colored Green. Here’s a fun chart of results: Questions? Comments? Ideas?

HI I am a tour operator, I organise group tours, multiple packages, include various items in different currencies. I am looking for help to create a calculator that generate Package price per pax based on different package requirements. perhaps also calculate break even analysis

Looking for someone to help build out a Gmail integration that lets certain user emails be automatically added to the “Outreach Log” flow in the “Publicity” space. Please let me know if I can provide any additional info!

Looking for a consultant who specialises in Airtable who can help with building on a current database to make it more efficient for what we need. Ideally will be based in Sydney, Australia so they can attend meetings to discuss progress and questions.

Hi Airtable Community! We’ve been using Airtable for a short time to help us manage customer quotes, customer enquiries and bill of materials for our jobs (home landscape contractor). We think Airtable can do this job for us, but I don’t have the time (or experience!) to build this properly. Looking for an Airtable consultant who would be interested in taking on this project, to take what we’ve got to the next level. Jen

Dear Airtable Community - We are a small antique print business interested in migrating our data to from a too large excel spreadsheet to airtable. Our goals are for all of our office staff to be able to collaborate within the same database, access it from anywhere, and economize our workflow. This could include potential integration with our current Miva Merchant online store database, and other options we have in mind. Essentially, we enter products one at a time, assigning various elements, categories, etc, then once a week upload these to the online store via a tab delimitated flat file upload. Each product is unique and will only be entered once, but some items are relate or very similar. We are also considering other database options. Kevin

Hi all, I’m not sure if this can be done at all but I’d like to work out a way to add timesheet entries to the appropriate month. I currently receive timesheets with a week commencing date and then hours for Monday through to Sunday. I have defined which month each day of the week falls into with a formula - see screenshot: I would now like to run a report that adds up all hours worked on any project and in any given month but I can only come up with a report that rolls up the totals in two columns which doesn’t help. What I’ve got: What I’d like to have: Not sure if I’m just looking at this from the wrong angle but I can’t figure out any way to make this work and would appreciate any help on this. Thanks a ton.

I search an Airtable Formula Expert for some cases Example: here is a sample task, if you can solve it write me how much do you want for this sample task and your hourly rate for the future :slightly_smiling_face: input example: (a random/every time different number of words - seperated with , ) example: mama, mummy, mother, bear, mom, mama bear, funny, baby, love, mamaw, mother’s day, mommy, gift, gift idea, christmas, wife, family, pregnancy, lgbt, yo mama, dad, humor, kids, lover, mama bear clothing, pregnant, animal, big, cute, father, pride, yo, africa, bearded, dinosaur, gay, gay pride, girl, heart, mothers day, present, rainbow, twin, twins, animals, autism, autism awareness, beard, bearded collie, best mom, birthday, clothing, dog owner, football, fun, fur, gift for her, i love mama, kid, lesbian, lgbtq, mama design, mamabear, motherhood, motorcycle, formular: First task to create a formula who export only the first 50 words maybe helpful: a word counter: IF({Tags}, IF(LEN({T

I’ve just added a new post to my blog Online Database Expert which shows how to use Integromat to create Barcodes from Airtable records and then post the resulting barcode (or QR Code) image back into the Airtable record. You can see all of the posts relevant to Airtable (including the Bar-code one) here: Database Expert Blog | Online Database Expert Visit our Blog where we review database and other cloud / online platforms and where you can comment. The site also include a members forum where you can ask database related questions and offer advice (including a specific section for Airtable users).

I’d like to find an AirTable expert/consultant that I can work with in my current databases to: -Add Complex Logic based formulas to fields -Review overall setup, and work to Improve Flow & Efficiency -Integrations and Automation Let me know if you are interested, and your level of expertise with the AirTable platform. Also, let me know if you are available on the any Freelance platform. Thank you! Roy Daneman, Ventures Factory feel free to email: [roy@venturesfactory.com]