Builders Board

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 fig

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 m

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.

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]

I am looking for someone that can set up reports, with buttons to choose which fields show up on the report and export the selected information to a nicely designed (with our logo) spreadsheet or PDF.

…but I will. :grinning: I just got a new Badge for viewing posts for 365 consecutive days! Pretty impressive, I’d say. It seems that I am the only one, at this time. I thought I would share this. Mary K

I just wanted to show (perhaps showoff :winking_face: ) one of our latest projects with Airtable. Using multiple Airtable tables our marketing client manages their projects, clients and incoming reports. They require their contractors to upload reports which we are using an AT form (soon to be custom form as client needs extra requirements) to input the data. Each of the customers are using a generated token based on the AT record ID which is part of their link to access the site ie. mysite.com/wo55eiruWERsdhf234 as security isn’t a primary objective they just don’t want “browsers” being able to have public access. These links can be sent out using the Airtable email block, these links are easily regenerated in AT and deactivated using a checkbox as well. Each client gets their unique link

I have 3 Tables in a base named “Bhakta Class Tracker”. Where I will prepare the class schedule for these devotees either monthly or quarterly. DevoteeList Topics Schedule It is not like outside regular colleges or universities. We are from Hare Krishna Temple. So it is a NGO and devotees keep joining at any time of the calendar. Not like certain period of time only they have to join. So I can’t fix the schedule for the entire year. It will change dynamically. So this schedule will be a mixer of new and old devotees. So for a particular day if I chose one topic and the speaker then I want to know the devotees who are idle. That I am able to achieve through integromat tool. But after finding out the devotees who are idle, I want to find out the topic which is common to all these devoees and that topic no one has attended. Since I have the list of topics for each devotees who have attended and not attended, so I asked f

Hi there - I’m interested in hiring a developer to help me implement a custom airtable function for our employee training event calendar on Airtable. We use one airtable registration form for all of our events and ask the registrant to select the specific training they are interested in and then submit the form. What I’d like to have happen then is the user (who filled out the form) is immediately sent an email with a outlook calendar invite file attached to it with the specific details (title, location, description, etc.) of the event they selected on the form. Anyone believe this is doable? Let’s chat!

Still a novice to AirTable so forgive my ignorance. I need to accomplish two things: Create a Gantt chart with multiple blocks per person so I can track when they are busy and when they are not. Right now I have created a task list and assigned multiple tasks to my team. But when I make a gantt chart (based on start and end dates of the tasks), it only shows them occupied for the first task. Example: John is assigned 2 tasks, one starting in July ending in September, another starting in October. But only the July task shows up on the gantt. What is the appropriate time function to use so that I can track utilization by time instead of just using a simple function that compares number of tasks assigned vs capacity. I want each individual working on one task at a time, but I am assigning them tasks that have timelines that do not overlap.

First, I am not trying to reinvent the baby. I am looking for a person or persons that has already developed something similar to either or both of the systems I describe; as such would hope to quickly adapted/adopted and implement in the next few weeks. System 1 - marketing project management System 2 - event participation management System 1 We have an in-house marketing department and are managing over 200 “projects” with multiple action items in various stagings of completion on any given day. Some of these are associated with our annual brand campaign but many are not. I created an excel workbook that outlines project scenarios. CAMPAIGNS would be created by the marketing manager only and then PROJECTS would be tethered to a campaign and could be created by anyone with login access. Project item CLASSIFICATION is limited but include: Advertising Collateral Event Planning PR Presentation Social Swag Wearables Web/App

Want to switch our small entertainment company from a Trello/Word/Outlook combo to Airtable, but do not have the time to learn and then design it. Would like to hire someone who could help me design and execute. Please contact me if you think you could help us create this. Thanks in advance. Gwenn

Develop a simple Web app with which would add a new inventory item. It would then save the item to Airtable, as well as to Shopify. Eliminate the dependency on Zapier, and it gives you more control over the entry of new items. For example, specify what fields are required and enforce any additional business rules that you might have in mind. Additionally, the Web app could be extended to support updating inventory items as well. So if you were to change an item in some way, you’d do it through the Web app, and those changes would be applied to the corresponding records in both Airtable and Shopify. The Web app will also be designed to support Shopify’s “meta” fields, so we would be able to implement the “dimensions” field - and any other fields that Shopify doesn’t support “out of the box," as well. basically “sync” data between airtable and shopify. shopify site is already developed with metafields in place. this syncing pertains to inventory records only and the fields a

I am working with a Wordpress dev. team that is building a site that will require integration with the Airtable API. We are looking for someone who has experience in this integration and can consult on a gig basis. There is potential to grow the work into setting up the front end bases in Airtable should we proceed. LMK - Scott

Team split between Europe and Asia need an Airtable developer/consultant to assist with numerous queries - recurring tasks/transactions, zap integrations, review of table structure, how best to implement various non-supported financial functions (FV / PMT excel functions) from excel into air table via Zap. Some graphical questions but mainly dev/API integration. Time zone of developer pretty irrelevant. Immediate start. tom.hall@paxholdingsltd.com

Hey, I have built a personal CRM for categorizing contacts. I have it hooked up to Google Contacts via Zapier, but I would love to contract with someone to help make sure those are well synced and some additional data is coming through via Gmail.

Hello. I am looking for a consultant who can provide support with setting up airtable for a plastic surgery clinic incorporating hr, marketing, legislation and sales. The clinic is based in London.

I need to combine multiple rows into one, where one of the columns is a linked record. Owners Table Column 1: Owner Name Column 2: Cars (linked to records on the Cars table) Right now on the Owners Table, there is a row for each car the Owner owns. So it looks like this: Name | Cars Bob | Camaro Bob | Mustang Bob | Challenger I’d like to look like this: Name | Cars Bob | Camaro, Mustang, Challenger

Hi We run a small Product company producing Sauces, Jams & Oils. We are looking for a paid Airtable consultant to build us a working project that helps us track raw stock, production costs, sales, profit margins, orders, stock levels. Currently we have 14 products across 3 groups. Thanks, Bruce - check us out at HornetChilli

Hey all, Looking for an Airtable and Zapier automation expert to discuss feasibility and implement the following for a manufacturing environment building large electrical and controls skids. We have a few disparate excel sheets built out and goals in mind, but feel the need to move to a database system to truly get what we’re after: Tracking the reception of Purchase Orders and generating automatic emails and automatic table updates as material quantities are changed by the client and our team (if feasible, from changes in a sharepoint Excel or some such) Track the deadline start and end dates on a project based on manloading, bottlenecks created by delivery of materials from (4) different vendors. Implement a calendar buildout to view gaps in the schedule. We have approximately (10) bays where skids are fabricated with a variable amount of employees dependent on size of skid. Track average delay times created by bottleneck

Hi there, I am new to Airtable and trying to work out ways it can help my business. The first area I am tackling is how I process my invoices. Can anyone tell me if I can share a base with another Airtable user who populates my base with data and pdfs supplied. It would be basic data entry but rather than get someone in my office to do this, I thought that using airtable woud mean it can be done remotely. If so, any pointers on where I might find such outworkers to discuss this with would be greatly received. Many thanks

Hi there, I need some help from a developer to use the Airtable API to upload a spreadsheet of entries but to simultaneously attach a corresponding JPEG file for each record. I work in picture post production, and the purpose of this is to provide shot information for every shot in an edit. The text data is easy to export, but I need to add a thumbnail of each shot / event as a visual reference. At the moment this is incredibly manual, when there can be hundreds of images to drag and drop onto each record. The jpeg could be named the same as one of the columns of data (e.g. 001.jpeg). Example files available on request. Any help gratefully received! Many thanks, Tom.

Hi, I am looking for an Airtable Consultant (hourly rate) in Los Angeles to help set up our Airtable hub for our business. The main needs are workflow/project tracking and business development CRM. Also, solutions for integrating google calendar if at all possible. Please reach out if you know anyone and I can share further project details directly. Best, GF