Builders Board

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

Without using Zapier or another app, would love to see empty, example bases of how to handle subtasks with Airtable. Thanks in advance.

I have a consulting business where I connect customers with our team of contractors. Each customer can purchase a different service package which may include multiple parts. I already have WooCommerce and Zapier connected to AirTable such that each new order results in a new line being added to AirTable and the relevant information is populated (name, email, order details, etc.). I’m now at the part where I want to automate the process of assigning contractors to customers and tracking their work completion. Been rattling my head for a couple days trying to figure this out but have faced a few issues. Looking to hire a professional that can help us build this functionality using AirTable!

I’ve created an Airtable to share with a large global research community working on fake news (https://airtable.com/shrhv3Vlezp7oOZIZ) and wondering if there are any tips out there for how to make this: More easy to navigate / accessible for people who are new to Airtable? Foster collaboration? would love to have other people add records to this as well, but a little worried about making it a completely open/editable database. Thanks! :slightly_smiling_face:

Hi guys, I work for a TV/Online production company based in New York. We’re just started using Air Table to track and schedule all of our programming, from pre-production all the way through to final delivery. I need a AirTable Expert / database developer to come on board for a day or two and look at what we’ve created so far and see if there is a better way we could be working. The work would ideally be based out of our New York office near Union Square but we can also do remote work. Thanks

Morning, I am a small business owner. I am looking to create a new base in Airtable concerning our daily petty cash. Would be interested to see if I can connect with an Airtable expert to see if what I want is possible and what would be the costs. I would like to use this base to address the following needs: Use the data entry table as a log which I then import into QB. (We don’t require help with the import as we are currently using Zed Axis). Provide management with visibility to key relationships derived from the data entry table. (Management is on Airtable). Provide management with a summary that contains linked records to “drill down” on an expense as needed.

Hi, I am pretty busy and could use someone to help me build out an airtable for my volunteer role hosting a radio show. We need it to: Airtable database requirements Enter all possible guests including their contact information, searchable show topics a. Track when they were on the show in the past, date and time slot b. Connect them to the show topic c. Other relevant information Set up recording day schedules a. We will record up to 5 shows in a day at five different times and I want this software to help me coordinate that, including printing out the daily schedule Set up our sponsors including invoicing, a. This is a database of our paying clients – within the same database of radio guests. b. Print out invoices c. Track what they bought, paid for, etc. Track the history of shows and topics so we can search on them for reference Hold release forms that come from our website (database)

Hi All, I need help creating a forecasting tool on Airtable which will tell me when to place re-orders taking into account different lead times from different factories. I have an excel spreadsheet created but I’d like the conditional formulas to be transferred to and work on Airtable, with a good way of summarising the data. Can anyone help with this? Many thanks, V

Advertiser Perceptions is building a database of the results of numerous survey research projects. We don’t have a database expert on staff and would need consulting to get the project off the ground (at least). We are exploring Airtable as well as other potential solutions.

Entering data this supposed to populate a report that we deliver at month’s end. It’s not working. Help?

Is Airtable capable of creating a table-view is this? Basically, I’m trying to track 8 episodes through various stages of my editorial process. I want to record when each of its milestones happens (rough cut, notes received, fine cut, etc etc). But I also want to see the status of every episode at the same time. So basically each point within the table would be its own database record B7, B9, C7, C9 etc… Kindly let me know if a followup explanation is needed. Thank you in advance,

I’m interested in hiring someone who could help me build a mock database in AirTable That would allow for the tracking of conference session and special event attendance for an Annual Conference. I’d like to be able to consolidate multiple years of attendance data using several related tables (People, People|Companies, Companies, People|Events, Events).

need help setting up an inventory database. Anyone interested in the job??

Looking for an airtable wizard to help us create workflow, views and integrations for core business processes, stakeholders, and external tools. You’d work directly with a product manager to implement based on user stories and requirements. We are fast growing startup who just raised a 60 million dollar series B.

An intro : A few days ago, working on one of my bases (dedicated to my pets), I requested some help to know if there was a way to track down, within Airtable, the Opening and Closing times of stores (or whatever opens and closes at some point), as the {Date} fields and {Duration} fields actually don’t allow an easy solution :thinking: . Well, fortunately, W_Vann_Hall gave me a nice perfectly working solution for which I’m still very thankful :slightly_smiling_face: :thumbs_up: , put everything in a demo base Air

Hi there! I’d like to hire an Airtable expert to teach me a few things. Rather than poking around the learning curve of Airtable, I’m seeking someone with experience with manipulating a large volume of data in Airtable. It’s a bit of an unusual situation with just over 40,000 contact records, many of which are duplicates, and I’m wondering what my options are for tidying it up. I need to remove duplicates, isolate records that have no email address, and allow someone else to go through and fill in those blanks. Once the data is clean, I want to set up Airtable to add functionality to our company’s processes, which I’ll need to learn as well. Thanks in advance, look forward to hearing from you!

Hi Everyone! Please read and let me know what your turn around time and fee would be here…I need some help with the following: If created date is in the last two weeks, and between the 1st and the 15th, payment is due on the 15th. If created date is in the last two weeks and between the 16th and last day of month, payment is due on the last day of the month. If payment is due on the 15th, payment will be issued on the 19th If payment is due on the last day of the month, payment will be issued on the 4th. So fields are: submitted (created at date), Due Date (formula/date), Issue Date Submitted: 4/3/2018 Due: 4/15/2018 Issue: 4/19/2018 Submitted: 5/22/2018 Due: 5/31/2018 Issue: 6/4/2018 Submitted: 2/16/2018 Due: 2/28/2018 Issue: 3/4/2018

Hey all, I’m looking into the possibility of creating a crypto portfolio tracker based on the CMC API. Something similar to this: docs.google.com Copy of Portfolio manager Example Portfolio Version 0. 13 Alpha release, Last update: 03/ 11/ 2017, Suggestion& Feedback, cryptofolio@ tutanota. com, READ IT To start your own

I recorded this video of a system I built using Airtable, Lob, and Zapier for automating & managing physical mail campaigns. I hope it is useful to anyone who is interested in using Airtable to manage this type of business workflow!

My firm has created a custom project management system using MS Access, a SQL database, and some Joomla stuff for a web interface. We started this in 2011, so it has become very tired and complicated. We are looking to move this functionality over to Airtable, but need some help doing this since we no longer have the guy in-house who built our current system. Please advise if interested, thanks.

I outgrew google sheets and am needing to quickly get up and running in airtable. The system I want setup will be for three events. It needs to have a master list of attendees, a list of event-specific attendees, and an event-specific transportation manifest. I also want to be able to track our hotel room block utilization.