Builders Board

Looking for some contractor help ASAP. Please send me an email at dadau@yahoo.com if anyone has time and experience with this. Thanks. Uzair

This may be obvious to many, but it eluded me until today… It is a HELL OF A LOT easier to code (and debug) formulas in Textedit (or the text editor of your choice), inserting returns between segments (B). When you paste your code into Airtable, it’ll smartly remove those returns and create the code block we’re used to seeing (A). A IF({Auto-Status} = “Awaiting Review”, “ :mag: ”,IF({Auto-Status} = “Complete”, “ :checkered_flag: ”,IF({Auto-Status} = “Design”, “ :art: ”,IF({Auto-Status} = “Released to Supplier”, “ :rocket: ”,IF({Auto-Status} = “On Our Radar”, “ :satellite: ”,IF({Auto-Status} = “Production”, “ :triangular_ruler: ”,IF({Auto-Status} = “Cancelled”, “ :skull: ”,IF({Auto-Status} = “On Hold”, “ :zzz: ”,IF({Auto-Status} = “Design Queue”, “ :art: :soon: ”,IF({Auto-Status} = “Content Needed”, “ :question: ”,IF({Auto-Status} = “Unassigned”, “ :busts_in_silhouette: ”,IF({Auto-Status} = “Design Route”, “ :art: :arrows_clockwise:

Hi I have a base that records appointments we obtain for our clients. It pulls linked data and sends out zapier emails and records calendar events plus sets up followup draft emails - and it works fairly well. I’d like to improve the functionality of the forms and organize the relational tables a bit better. Basically, clean it up and iron out a system that’s bug-free and easy to maintain. This a fun little job in a really neat industry, Would love to get this done asap. And look for more automation opportunities too! Ryan Thomson Refinery Artist Management / Velocity EP

Looking to build a Company Register with the following data: Company details Company Directors Company Assigned to internal resources for follow up Contracts with the companies Activity with the Companies Timesheets Create role based views for the internal staff and dedicated workspaces. We can discuss the requirements in more details for implementation. Thanks, Shankar

Hi we have used Airtable extensively to manage our website content but now we want to build a simple transaction management and reporting tool. I have built a prototype but encountered some problems so looking for a consultant who is good with Airtable and databases. Financial Services area.

Looking for pro-bono or freelance help on a non-profit project using Airtable called “The Dream Machine” it is an armchair scientist strategy system to improve the future. I want to get feedback on how we have organized in Airtable and also get the prototype integrated into a website so we can manipulate the data much more easily and more flexibly. The project is large and we are just starting and don’t have funds yet but we are looking for an estimate/expert in Airtable to help with ideas/architecture/integration. http://zenka.org/the-dream-machine You can email me at hello@zenka.org for further information.

I would like to contract for one hour of screen-to-screen consultation to better understand how Airtable works and optimize a relatively simple table I am working on.

Our business is considering moving from FileMaker to Airtable. We are a digital media production business, with many (hundreds) contractors, clients, and jobs in many different diciplines. I’d like to a - Move over the data from Filemaker to Airtable b - Remake the current FileMaker system with Airtable, with new features. There’s quite a lot to this, so I need to do a feasibility study to assertain whether everything we want to do is possible in Airtable. Please message me with your offers. All questions and enquiries are welcome, but suitable candidate must be an expert in Airtable database creation and be able to understand how digital production workplaces generally function. This is probably a week’s worth of work (feasibility stage). If it progresses, we may offer you the job to create the Airtable database.

Hi, I’m a newish member of a six-person communication and marketing team, and we are interested in using Airtable for project management. I have used Airtable in the past and am fairly comfortable with it—the rest of my team does not have experience with it—but we are hoping to reduce the burden on any one staff person by working with an experienced outside consultant to get a comprehensive workspace set up. If we go this route, we’d first want to talk first about our needs and project goals (we’re based in Ann Arbor if there’s anyone local to us here), and get some help on the conceptual end before moving forward. Right now most of our stuff is housed in a bunch of different, unwieldy Google docs (and some sheets), and that works for just about no one. I do have a sample base that I think shows a fairly decent micro version of what we’re going for … If this makes sense and you’re interested in talking with us, please drop me a line with your rates and anything

Hi, We’re looking to build a database using Airtable but have hit a couple of roadblocks. Should be able to get up and running after a 30-60min Skype call with someone who knows their way around Airtable. If interested please do drop me a private message or leave your details here. Many thanks! Paul

Our non-profit initiative - the New Producers Group - is looking for someone who can tailor Airtable to enable South-South knowledge sharing between governments. We are putting together a database of information and also want an interface for easy exchanges between the collaborators (the governments) and a helpdesk function. It’s a short-term contract through the African Development Bank. Don’t be put off by the graduate degree required - do apply if you think you’re the perfect person for this! https://www.afdb.org/…/EOI_-_Consultancy_Services_for_Devel… Find out more about the New Producers Group: https://www.chathamhouse.org/…/new-petroleum-producers-disc…

I’m like to score someone’s responses to a form, but don’t know where I’d start. For example, I have a row with three choices: rock, pop, and jazz. Depending on the choice you make on the form it then gives you a score. Say I choose rock and it gives me a score: ‘cool’. I’d then like to build on that with other choices. So the form might ask if I prefer CDs or records. I choose records, and it gives me an updated score linked to my original choice. I’m now ‘very cool’. Does that make sense? And is it possible?

I think this is a medium-easy task. I need three-four tables, that are interconnected for coordinating an event. The time table is short - next week or so. The budget is shorter - we are an all volunteer new organization. No data to worry about - just need to get the framework set up to put it into. I can make the various fields, but where I need help is with the linking. The main list is a list of exhibitors. Some are also on Tab 2 as speakers. Simple, right? Where I need help is in making it so if someone is added as a Speaker, they automatically get added to the Exhibitor list. Then I need to have a 3rd Tab - Sponsors, who also automatically get added to the Exhibitor list. There is a 4th Tab - one for the company. It would track the role and year, based on the above entered data. Example: At a glance can see that Acme participate in 2016 (Presenter, Exhibitor), 2017 (Exhibitor, Speaker) I need to have some way to repeat this in upcoming years - maintaining

I have built out a base that our marketing & communications team hopes to use for project management, editorial calendars, and eventually some analysis and reporting. I have the general outline in place, and have thought through many of the details (and the team has been using a version of it for a while now), but I need someone to carry the work through and make it better. Part of the work is making views and labels consistent, but I welcome suggestions for how to make this work more effectively for us, including adding notifications. I need someone who can work on this over the next seven days. Please reach out if you think you might be able to help. Thank you!

We are a church diocese (a geographical grouping of churches) overseeing 45 church congregations and about 120 individual ordained clergy personnel and a similar number of individual lay church leaders within the 45 churches. We have created three bases representing the three areas of data management: 1) The Office of the Bishop or Diocese is the top level 2) the second base is Churches where all 45 congregations information is managed and 3) Clergy.where we track the 120+ individual clergy personnel. All of those three bases were created from Excel spreadsheets where we once tracked this information. We need someone who can help us to: Manage the three bases and link data within the bases to eliminate duplication of effort when records are updated. For example, an individual clergy person updates his/her record in the Clergy base, but he/she is also attached to one of the 45 churches in the Church ba

Airtable Community, 2 related projects that we’d like to get help with from an experienced Airtable user. Particularly looking for someone with experience building venture deal flow databases and reporting capabilities. Also want someone who has familiarity with calendar integration and automated email notifications. We may have need for assistance on additional work beyond the two items briefly outlined below. We may also require a signed Non-Disclosure Agreement due to the nature of sensitive data that may be reviewed during the process. First, we want to build out additional workspaces that drive off of a main database that has already been assembled. The new workspaces will be used to similarly display certain portions of our deal flow to partners with varying interests, with the intent of mirroring the main database populated by specific rows of data determined via tags from a single column. Second, we want to build a separate single base with robust metric

I have two short term rentals-- and this year will be expanding to 6. I use several different platforms – Airbnb, Booking.com, Homeaway, etc. In order to manage all of these, I use a management software called Tokeet, which has APIs with all the major platforms and pulls in my bookings into a centralized calendar and also allows me to send out automated messages to guests. My ideal is to use Airtable to do this…or at least to have the Tokeet API connect with Airtable to bring in the data from that platform. Looking for someone who can help me with this.

I could not figure out why when doing an alphabetical sort, some records were coming in “at the bottom.” For example I’d have A to Z for records 1 to 100 followed by a second A to Z of records 101 to 200. I could see no extra spaces, or anything to indicate why this was happening. At long last I discovered that occasionally CSV imports (mine were exported from Zoho) have a glitch where hidden tabs can tag along. The fix is a wee bit tedious, as you can’t just do a global replace (I did try that!), but it sure beats the alternative of retyping things (which was what I did for a while before getting determined enough to find the answer). Steps: Open exported CSV file in your spreadsheet program. For each column, insert a blank column next to it on the right. In that column, add the formula =CLEAN(A1) [or whatever cell is your first entry]. Use the copy / drag function (copy, format down) to fill the entire second column. That column now

Hello! Our successful startup nonprofit is using Airtable to track advanced participation and outcomes data and we would like to hire a consultant to coach us to use advanced views, formulas and filtering to “run reports” on our data (tabulating participation filtered to specific activities or date ranges or participant demographics), including offering suggestions for better table/base/field configurations. Ideally we wouldn’t want someone to just create the views/filters for us, but to work with us to create them and teach us how to think more cleverly about how we do things in Airtable. The ideal consultant would be equally skilled at creating advanced formulas, filters and views as well as teaching others how to create them (and communicating why). Potentially this project would include: *orientation to current base configuration and use *consultation for creation of several advanced filters/views/formulas to get desired tabulation results *ongoi

I am the owner of a creative agency and we are looking to consolidate and streamline our current business management system. Currently, we are using multiple Google Spreadsheets, along with Harvest and Trello (and QBO, but we don’t need to mess with that). Our system works, but it is cumbersome and I know we could be more efficient with how it all works together. I have done a lot of research into Airtable and think it will be a great solution for pulling everything together into a more efficient system for myself and team to use, along with running Zapier (?) to automate how everything works. I have decent skills when it comes to spreadsheets and systems, but don’t have the time to dedicate to creating this new infrastructure. Having said that, I think I have a pretty strong idea on what needs to happen. We are currently using Sheets for: Client CRM Contract master database Project deliverables tracking (time budgets, $ budgets, timeline

So, I have been trying to find a way to make weekly recurring tasks, and have figured something that works for me. Basically, just a complicated formula that updates the due date field each week to the same day of the week and time of day. Make a table that will act as a template for new tasks. This Post got me started. Make a date field, with the time, that will set the time you want to be your due date each week. Use this formula below, to make a separate field that will update to that day and time, each week, automatically. (You will need to edit the time zone to match where you are.) DATETIME_FORMAT(SET_TIMEZONE(DATETIME_PARSE(CONCATENATE(DATETIME_FORMAT(NOW(),‘ww’)," “, DATETIME_FORMAT({due time of week}, ‘ddd’),” ", DATETIME_FORMAT({due time of week}, ‘LT’)),‘ww,ddd,LT’),‘Asia/Bangkok’)

I am looking for an Airtable Expert to translate a spreadsheet with calculations and formulas to Airtable. The spreadsheet includes many columns with various variables from each product and several calculations are made based on points & value. Experience with web development would be nice, but not required. Extensive experience in the setup of Airtable databases with complex formulas is a must.

I need an experienced person to build an Airtable that will help manage my staff and clients scheduling. Features include: Staff can input available times. Clients can reserve time based on staff availability. Integrate with Google calendar to send appointments to calendar of both staff and client. Send reminders day before scheduled apointment. Handle payment through PayPal or Stripe. Integrate with QBO if possible.

Hi, I’m trying to set up Airtable to help manage and organize my laboratory. We are a molecular parasitology research lab. Some of the tasks I’d like to use Airtable for are managing our supplies inventory, orders for new materials, chemical lists, freezer maps, bio-safety compliance documents, etc. Maybe lab results as well, though anything with PHI must be kept on our university’s cloud app. I could really use some help setting this up. I’m currently on the free trial, but I’d like to set up a functioning system before bringing it to the head of my lab for approval (if he approves we will move to one of the paid plans). Is there someone who could help me with set-up? Or, if anybody has any tips/templates for use in managing a lab, I would really appreciate it. Thanks! Indira indira.chakravarti@gmail.com Edit - since I am unsure if I can use Airtable to meet lab needs I am not hiring anyone for set up just

We are looking for someone who has experience with Airtable databases (and blocks). There are 2 parts to this job: Part 1 - Building the Frame Work Part 2 - Migrating the Data Part 1: It will include building the frame work for: • Calendar System - currently all housed on a google calendar • Ad Unit Inventory - Table of all of our ad units • Client Insertion Order - Table of where each client is in their insertion order (contract) • List of Clients - appx 100 of these (in a CSV file) All the above things will need to be linked together and update together. Migrating the Data: We have 100 clients total. The document we need to integrate is currently a Word Doc (acting like a spreadsheet). The word document is 105 pages long. So that should give you an idea of the scope of work. I am including a page from it for one client as an example. The things crossed off have already been completed but would still need to be pu