Builders Board

I love the idea of Airtable, but I’m confused. Can someone help me set up my custom tables for my floral design and event planning business? I’ve tried a few tables that I can share with you. I know what I want, but just too slow working out how to set it all up. Please email me hello@dragonflyfloraldesign.com.au if youre able to help and let me know your fees!

Hi! A little while ago, I pulled information from a baker’s dozen rankings of episodes from the first four seasons of Black Mirror, Charlie Brooker’s dystopian look at technology and society, produced originally by Channel 4 and later by Netflix. I had been amused by there being general critical consensus as to the series’ high quality but absolutely no agreement as to the merit of individual episodes. I thought by gathering the data into one base and subjecting them to various analyses I might be able to identify trends or commonalities not apparent at first glance. Nope: They don’t exist — or, if they do, they are still too subtle for my ham-handed processes to identify. Accordingly, I followed the time-honored tradition of less-than-scrupulous researchers everywhere: If the data are inconclusive, change the goals. I had been looking for a project with which to test Airtables new Blocks feature, still in beta test at the time. If I couldn’t use Airtable to identify previously hidden

Use Airtable and Checkfront API to create a custom admin interface (spreadsheet style) Create a custom website user interface to embed into responsive wordpress website while intergrating payments through Moneris Virtual Merchant Terminal. We currently use google docs spreadsheet for entering online bookings manually at the moment. Skills required : Experience creating custom website inferface Able to integrate payments on website through Moneris Payments Fluent in English Job requires : Creation of work flow of the entire project (item by item - how each feature will be developed) Creation of custom admin interface integrated with airtable and checkfront API Creation of user custom user web interface Troubleshooting and edits to be made after the system is tested What need : Admin Interface Log in Be able to view all hourly/half hour rental items for multiple days on the one screen (like google spreadsheet - view file attached) Be able to enter bookings manually, by selecting th

I just found Airtable and I think it could probably really help us. We own and manage apartment communities and have additional locations where we’re doing development, retail or other activities. We currently track all of our location information (IS needs) like address, WAN Subnet, ISP circuits and so on. We have several ugly Excel Spreadsheets keeping track of all of this plus static IP addresses for multiple internet circuits across 50 or so locations. I’d like some help develop a working structure to replace this and enhance our ability to quickly access information. Thanks.

We are trying to map our building addresses via google maps, I am not a developer and have no idea how to program API’s/ make them talk to each other. Would greatly appreciate any help!!

I just don’t have the time to figure this thing out. I’ve already spent way more time than I should have and I just can’t get it to work, and I’m done. I need something that will list all my customers, their orders, and the items they order. I want to click on a customer and see what items they have ordered. I want to click on items and see who has ordered them. I also want to automatically add records based on an email receipt I receive of their order. I want a form that customers fill out that will tell me things like size, favorite style, color, print, etc. And it would be easy to see everyone that likes the color purple and is a size small, or looking for a camo print. And an “Action Item” - if I need to remember to send a customer something, or that a customer is paying me on Tuesday for the hamburger bought today. Ideally it would have a view that would have all the Action Items I’ve got going (right now they are all in my brain, and I need them out of there) on, and as they

Is it possible to pass variables from a webpage of mine to my base view it so that airtable is “prefiltered” for the user according to how they on the webpage? I imagine something like a drop down menu on the website where people can filter and search for specific rows in the airtable view that they get sent to. Thanks!

Hello, Our current process leverages typeform (beautiful forms) and textit (a two way sms platform that supports triggers and zapier). We are looking to leverage Airtable as our database to collect and update information from our clients. However, we seek consultation to create airtable workflows that deploy pre-filled typeforms to confirm/edit data in Airtable. Looking to find a solution ASAP! Thank you! Erika

Hello, we’re somewhat new to Airtable, but have a bit of experience with it now. However, I’m looking for someone to help us build out a Gift Card Database. A few key use cases: Enter new card/details Redeem card (partial value) Redeem card (full value) - “terminate” card A few reports (various filters) Maybe a form or two for input. Thanks in advance for considering this.

We are a research firm. We need help creating research project management work flow. Need to track realtime flow, but also to archive specific data (auto populate) in existing excel and/or Access databases. Have used Excel and Access databases to manually manage but think Airtable could simplify and decrease duplicative data entry.

The link below is to a base I developed for tracking medical expenses. It can track expenses for any number of patients, medical services, and providers. The base allows the recording of charges, insurance amounts (disallowed and allowed), deductibles, co-insurance and co-pay amounts. It also can track amounts paid by insurance to the provider and to the insured, as well as payments made in settlement of bills from providers. There is a main Medical Expenses table and additional Patient, Service, and Provider tables. Each field has a description of what it is for, and there are several different views of the main Medical Expenses table. Of course, the sample data in the base is just that and is intended to show the various types of entries that can be necessary in recording expenses, insurance rulings, and personal payments. Copying the base is enabled on this read-only link. I hope that some will find it useful. Medical Expense Tracking Van Zeck

Hi there I’m looking for someone to assist me in the best ways to set up our base. I have started doing so, but before I get too far into it I need to make sure the way I’m doing it is correct for our needs. Also, some help in achieving the situation described below: I have created this summary table, and would like each cell to pull in the total (number) based on the other tables. This is for a magazine, the editions are listed along the top. We have two main sections in the publication (feature and non feature), with content and ads in each section. I would like to create a dynamic tally that shows the projected number of pages in each upcoming edition, based on the data in the other tables (content and advertisers). Each line in content table has dropdown fields for edition (21 - W18, 22 - Sp18 and so on), and section (feature or non feature). If it was easy to do I’d like to add a further way of analyse in the tallies, with another field from the content (type - which is a dropdown

I need to change the ‘description’ associated with my account userid, but haven’t been able to find where to do it. Where might I look?

UPDATE: Found a consultant, no further inquiries please. Hello, I work with a small (15 people) marketing firm in Venice, CA and we are integrating Airtable as our new project management system and need some help! We are looking to hire someone hourly who is available to answer questions, chat online over the next few months, and be available during work hours within the hour of request. We need someone to hold a live demo with the company either in Go To Meeting or in person. Thanks!

Yup, you just need to create a calendar view, share the calendar, copy the ical and then suscribe to this calendar with mac calendar, outlook calendar or google calendar. On the local calendar you can add “1 minute before” reminders. Working amazing for me and i can do “time blocking” with that :grinning_face_with_big_eyes: REMEMBER! You need to add start and end time to every task. I fucking loooooove airtable, can anybody send me some stickers here? i need to share the love (and take out the trello)

Check this out: https://airtable.com/shrzfQcmUqy92gkPi I’ve always wanted to journal daily but felt like I didn’t have the time to do it. However, whenever I do find old emails to friends, they transport me back into moments I’d long forgotten. So, I’m trying an experiment. What if I record my feelings during the day and occasionally add notes that will give my future self context? And what if I only select one of 5 emojis for my feelings - glad, sad, mad, embarrassed, bored, or afraid? Will I make this a daily habit with such a low threshold of commitment? And to make it easier, what if I automatically record the time, date, and weather? Will that give me more context in the future, without extra data entry work? If you copy this base and make it your own, let me know!

Late last week, I published v 1.00 of my Wardrobe Manager base, with an update submitted this past Monday. Descended from an earlier project intended to inventory the 1,200+ items in a local photo/video studio’s collection, this version has been tailored for the individual who wants or needs a more structured approach to managing his or her wardrobe. Where my bases have more often tended to be a tactical solution for an immediate problem, Wardrobe Manager is my first attempt at writing an application in Airtable. As a result, it includes more robust error-checking and alerting capabilities, better supports customization and expansion, and is more thoroughly documented than my earlier efforts. (A standalone [documentation] table within the base contains five separate guides featuring, as of v. 1.01, some 80 pages of documentation.) Screenshots Supported Functionality The system provides Database of clothing items. Wardrobe Manager supports – but does not require – an extremely deta

We are setting up AirTable to help track and approve Invoices on behalf of our clients. We are looking for help to build some checks into AirTable (or via Zapier or other) to make sure the invoice fits into the clients budget and that the client has approved the invoice before we export it to Xero. We will also need to get the client’s approval of the invoice and plan to use SMS for this. We have some of the database already built and some connections working using Zapier. We’re looking for someone familiar with AirTable and api’s. Some basic programming experience is essential. Would you please get in touch and explain your experience in automating checks and workflow with Airtable and possibly Zapier. thanks Elisa

I am currently setting up a job production system to have orders from our accounting system flow into Airtable and manage our manufacturing jobs. 70% of our jobs are pretty straight forward and have the same parts for each job and Airtable is looking like an EXCELLENT tool to assist us in what we do. About 30% of our jobs are much more complicating and have kitted parts, with assemblies inside of job methods which throws off my simplistic vision for this system and I’d like to stick to the vision as close as possible. I need an Airtable consultant that I would pay for the project of helping me design for this 30% of complicated scenarios. Airtable expert and database mind required! Please message me if you have interest!

Hi AirTable Users! AirTable is a fantastic tool that can be used in so many different ways, just like any out-of-the-shelf-spreadsheet-toosl, but easy, and in even more ways, especially when you are online! So for all BI developers out there, targeting all Qlik Sense Developers - I have find a way to integrate AirTable with Qlik Sense - I¨m sure it is possible to do also with other BI tools…such as Power BI and Tableau, as long as they are web-based. Example. Inside the Qlik Sense App in a simple Widget, you can embed a AirTable Form, allowing Qlik Sense Users to give feedback into an AirTable database. Then, you can load this feedback back into the Sense application presenting the overall feedback. The complete concept without ant coding or paid licenses! Amazing! The solution can also be used for Budget-processing, or any kind of solution where a Qlik user must be able to give back Data for further processing. Link to part 1 of 3 on my blog post on how to do this. //Robert

Hi everyone, What a lovely product airtable is! I’m looking for a help with my school and inventory airtable DB. I have some logical issues that I can’t solve on my own. Few examples: how to record biweekly attendance of 300+ students for 10+ different classes better payment records then current create inventory management and… create automated inventory management (if someone takes something, that item should decrease in my stock) add complex logic based formulas to fields review overall setup, and work to improve flow & efficiency We can do this with upwork, skype or something else, whatever work well with you. Feel free to email me at: davorbudimir9@gmail.com Who is ready to take on a challenge? :smiling_face_with_sunglasses: :blush:

I’m trying to create a few tables that would allow me to keep some information hidden from a client, while still allowing them to collaborate as fully as possible. Am looking to pay someone for a few hours work to make this happen…don’t anticipate it will be too complicated but it’s just more than I can figure out. Happy to chat more about the details if you’re interested. Owen

Hi All, I wonder if you might be able to please help me, I am trying to create a formula to sum amounts based on the status of a persons deal (think sales pipeline for lines of business). I’m trying to Sum a series of If statements (I think!) As you can see from this example, there are 3 types of incomes, and each person/customer might be Open or Closed under each line of business. So what I am trying to do is Sum all income types If the status is Open (I.e. to create a Total amount for Open deals). In this example Person 1 is only income type A and Open, so the desired outcome is to produce a $1,000 result. Person 2 has income in 2 lines of business, but 1 is closed, so I want it to only sum the Open one, again $1,000. But person 3 has income from lines of business A and C, and both are Open, so I want it to have a $2,000 sum. I have tried with If, Sum and Or statements, but I just have no idea what the logic is I’m supposed to use for what may be fairly straight forward for an e

I am looking for a contractor to help with the Blockspring Script feature of Airtable. I am looking to write scripts to import data into my project, in part via API and potentially with some web scraping. If interested please email me at rkaplan@kaplan.rehab – Richard Kaplan

building out a database for our art gallery, integrating some data, and creating some reporting. Nothing overly complex in what we need - I’m just struggling to connect databases/tables into single views and reports. We’ll probably need to start with some analysis since I’m still trying to wrap my head around the amount of data I want to capture and how much needs to be integrated. Thank you Karen