Builders Board

I need to see if it is possible to create an inventory system for our subcontracting company and then integrate the purchase orders, receipts, and invoices into Quickbooks. We design a system, order material (some finished and some that needs fabricated), fabricate, and deliver to a jobsite. We order 10-15 times a week and each order has as many as 50 items and each item can have a few hundred parts at any time. I want to put in our items based on the vendor’s part number and use their barcodes. I also want to make packing lists when we ship. The packing list should create a single barcode for the multiple items that are in the shipping order. When the receiver in our company receives the shipment for work, they can see what is in the shipment. I want to see if we can create an inventory where items that are ordered specifically for a certain job don’t go to our inventory but to the job’s inventory.

Hi, We have used Airtable to store all of our data and need help building a user-friendly and responsive Website. The wireframes and specifications are in the following documents: Specification document: https://drive.google.com/file/d/1qXDSzZaEdC6X7Djve-0fh2SooDZsILVg/view?usp=sharing Screens: https://drive.google.com/open?id=1apeuZGiypC87HH5HdDDz8xd2o-PvqXrM All of the data populating the website is in Airtable. For read-only access to our current base: https://airtable.com/invite/l?inviteId=inviesiRd1QGNbnGU&inviteToken=f1ab2d05385fbaa5c0539ab9c93de07517a5baaa1cc203a9307def21b308b797 Please check our Mockup: https://projects.invisionapp.com/share/S4NI7T8YX7U#/screens/314220428 The following third parties are used. It would be great if you have You experience in all of them. Airtable Acuity Scheduling Google hangouts Our current goal is to launch by November 19th. Any introductions would be greatly appreciated. Thank you for taking a look.

I am seeking an Airtable expert to write several formulas per the below description. Zapier will be feeding data into Airtable, so I would like to get these formulas in before developing Zapier workflows. Link to Video Describing Requirements: https://www.useloom.com/share/facdd62943c44a578329e631bed17a85 Since, I cannot attach anything, below are the requirements as discussed in the above video link… Within ‘Operating Table_Main Client Record’, the following formulas need be written: – “Hours Since Proposal Sent” should count the number of hours (set as an integer and rounded up or down to the nearest whole number) since the proposal was sent relative to the current time (time zone = EST). If “Proposal Sent” is blank or set as “No”, then this field should be blank. Also, if “Proposal Accepted On” is not blank, then this field should be blank. – “Days Since Proposal Sent (Actual)” should simply divide “Hours Since Proposal Sent” by 24 and be expressed as a decimal with one digit of pre

Hi, I run a product importing company and need help designing our database. I’ve built a rough airtables database but I know it can be so much better. I’m looking for somebody to: Briefly understand our business and the workflow Look at the current airtable database Make suggestions to a redesign and/or features we aren’t using Execute on the redesign to the extent it takes any special skill Here’s a rough idea of the business: -We’ll have 50-100 orders (POs) -About 12 factories -Each shipment has lots of documentation that can be uploaded (PO, Bill of Lading, Packing List, Invoice, Shipping invoice) -Each shipment has a lot of information that can be extracted (value, type of goods, duty code, cost of shipping, ports etc. ) -We’ve been using it to track the status of each shipment (ordered, ready to ship, booked, on the water, delivered, etc). There might be some integration available with shipping data using the ship number or HBL, but that might be an overkill. Manual updating is

I am looking to empower my managers to take care of customers. Whenever a customer has a problem, they usually call the restaurant and let us know of an issue. This is great- we love the feedback, however there is a small percent of customers who take advantage of our good nature and call us regularly for a refund or credit. For example, a customer calling the restaurant six times in one month saying they received burnt food (hey, im not saying it cant happen, but really?). I would like our managers to use airtable on an iPad when receiving a complaint call to enter customer name, phone number, date, and a brief description of the problem. Ideally, when the form is being filled out by a manager who is on the phone with the customer, the new entry would either: (preferred) Automatically attach previous customer contact records stored in the complaint database (based on similar name and by phone number) to the new entry. This will allow us to see a history of complaints and issues by t

Is there any trick to get the menu “Hide fields, Filter, Sort” in other languages like French ? Could we add something to the iframe code to replace these specific words? Unfortunately, there are submenus or criteria fields in English as well. The best solution would be a parameter that would make the app displaying these words in a chosen language… Benoît

I’m trying to create a product listing directory with user accounts. Here is how the final result should look. I do not need the shopping cart, just the listings and user accounts. What’s the easiest way to do this? Can Airtable help? I’m seeking a consultant or peer who can help with this. Thank you.

Hello, I owned a ecommerce store in the art supplies niche. The first step of our workflow is Product Research --> then it we select the products we want to launch based on the numbers we see in the market research (sales volume and market demand) Quoting --> Once we select our product to get a quote on, our sourcing agent will send us mutiple quotes from different suppliers. This infomraiton should be capture Supplier Selection / PO --> ONce we have a supplier selected, we issue a PO. This is where we have a database with the product name and a item number , UPC code should be created by then along with (Costs, estimated shipping etc) . Invoice / Payment --> Once supplier receives our PO, we get an Purchase Invoice, now we track payments 30% downpayment, 70% remaining, etc, and bank details, payment date, next payment date for CASH FLOW projection. Shipment / Inventory --> We plan shipment based on container loads and different suppliers, every month we send one contain

I am the founder and director of Northwest Hospitality, a 501c3 nonprofit started in 2016 focused on programs to help people living in the streets of Washington state. I’ve been having a great time running our entire nonprofit on Airtable since we got started and my main database is a beast. While I’m very proud of everything it does, this main database could really benefit from an hour or two of expert review; I suspect there are several things that can be optimized. In addition, I’m struggling to build a homeless resource database that will be an incredible tool if I can do it the way I envision. One of our programs is hospitality kits which include health and hygiene essentials as well as a curated printout of local resources. The goal is to have these lists specific to regions in Washington like King County, Kitsap County, Whatcom, Snohomish, East Seattle, etc. Building the database in Airtable and using the blocks to format the printed versions is only half the battle as I also wa

Hello, need an airtable expert to help us struxture, configure, and setup essentially a company intranet. I can explain in more detail. Please contact ivan@triplemint.com Thank you!

I have a company that after 7 years still does not have an official, functioning data base. I’m looking to work closely with a team or an individual who will create exactly what I need. Payment will be based on completion of each form or template rather than hourly. Please contact me through here or you may text me at 312.909.7356. And I can call you with the details. It’s a property rehab and rent-out company with about 80 properties spread out all over the Midwest, requiring a lot of work before they are up to code for tenants. Would love to get this started ASAP! Please text me if you are interested to know more :)) -Emilie

Hello, I have an airtable set up; however, I am looking for: help with some of the formulas setting up a running balance help in properly displaying the relationship between some of my data Please kindly contact me for project details. Thank you. David Walters david@slklogistics.com

I’ve just discovered AirTable and think it could be an amazing tool for Communications and Student Enrollment work that I’m doing with our non-profit gymnastics club. Is the following possible? Student Data Base: birthdates, levels, etc, parents, ph# - important is contact email Events Data Base: 15 or so events will be attended - not all students attend all events - (students event schedules are set according to their Team/Group). In addition to students attending, this data base also needs date, location, schedules, etc - and possibly $cost info Group/Team Data Base: students are categorized 6-8 different groups; a student may be in more than 1 group - different groups attend different events Enrollment basically eligibility to attend an event depends on the Team/Group the student belongs to multiple Team/Groups attend multiple events student don’t necessarily attend all events they are “invited” to Needs To track enrollment of students for the various events Some kind of RSVP fe

I’m creating an Airtable base to manage my digital agency, it currently helps us track the profitability of our Projects (Hours estimated, hours used, budget estimated, budget used, etc) The next step is to build something that can take these estimates for our projects and drive out a capacity forecast. We need some assistance with rolling up the hours estimated between the start and end dates for our projects, allocating those hours to our employees, and then visualizing how much capacity they have vs how many hours they have been assigned to. It’s just too complex for me to figure out on my own, being new to Airtable. Looking for a consultant that can help me build this out.

I have started organizing a global community of yoga teachers and teacher trainees. We are looking to reorganize ( possibly redevelop?) the AirTable base i created so we can enhance our ability to access information, track our trainees and integrate them onto a global map for our website. Thank you!September 12, 2018 (Europe: Paris), September 11, 2018 (America: Los Angeles)September 12, 2018 11:00 PM (Europe: Paris), September 12, 2018 2:00 PM (America: Los Angeles)

School Food Matters is a small campaigning and food education charity based in SW London looking for help to move us from spreadsheets to a database. We’re not looking for a complicated CRM rather a central record of all our 10,000-20,000 relationships gathered over the past 10 years. An efficient and user-friendly search capability is key. AirTable seems to fit the bill so if you have experience working with charities with limited budgets and setting up databases, please get in touch. Thanks

We are a digital marketing agency with experience building and integrating cloud-based apps but are new to Airtable. We recently built out our first Airtable base and would like an expert to assess it and either optimize it or rebuild it. Attached is the schema Note: 1) I am not a db architect so this schema gives you sense but is not fully accurate. 2) The Contracts table should be linked to the Clients table in the schema but it is not. If you’re interested in helping let me know your availability, hourly rate and the estimated total hours needed.

Hey, I need help in setting up Zapier, Airtable and Wordpress API. Unfortunately the standard Wordpress Integration of Zapier is limited. We need to automate the posting of articles from Airtable to multiple wordpress sites. Based on the information given by Airtable, Article X needs to get posted on Domain Y Please send me a PM when you can help us

We are en environmental consultancy called EcoNomics, Inc. We work for several municipalities in California and ensure that they are in compliance with laws related to recycling. We are building a site audit tracking database that will be used to help set up new recycling programs in Orange County, CA. I have been building out this system in house and am starting to need expert advise. I’ve built out the system 90% of the way and just need help with best practices for data base management. From the raw data collected in the field, i’ve added some calculations in airtable to create what i’d call “key data points”, which in a perfect world would feed into a dashboard for our clients. In particular, I want to build a dash board for each of our municipal clients using the mapping blocks, so you can click on the map pins and see specific data points (hitting a wall here). I want to do most of the heavy lifting but I already REALLY could use a 1 hour session talking through some of my

Please email stephanie@montikids.com if interested - thank you!

Possibly of interest to some, the following is an implementation of Soundex pseudo-homophone encoding. As there are variations of the algorithm, care should be taken if using its output to search externally encoded databases. (I think this conforms to U.S. Census encoding, but I’ve found contradicting statements.) To use, copy and paste the following into the formula configuration window of a formula field. It expects to use an existing field in the table named {Word} as input, so adjust field names accordingly. (There are two instances of the field name {Word} in the formula.) Yes, it’s far from a perfect algorithm; yes, it’s rooted somewhat intractably in American English; yes, there are alternative encodings that may be more appropriate for many uses: Feel free to modify, enhance, and improve as you see fit — preferably releasing your improvements to the community afterwards. LEFT( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUT

I am looking for someone to create a simple Wordpress plugin. I need to pull Airtable records using the API and put them into an HTML formatted table, all wrapped in a custom [shortcode] that can then drop that table into any Wordpress page/post. I’ve been able to mess with a php function that pulls the specific records I want, however, moving forward to the table and shortcode are outside the scope of my ability. Key to this is the ability to filter records by a formula where {Field} = Wordpress Post Title. I have my database set for a particular field to match the specific titles of Wordpress custom post types. This should all be contained within a Wordpress plugin that also creates the shortcode. Contact me here and let me know if you think you could do this. This would be a one-time project.

Seeking support for an existing install of Airtable employing Zapier. This is a paid position, can work remote if skills/experience align

We’ve got our bases loaded and need your help to get the most from our AirTable set-up. You are a Seattle-based consultant or company with a proven track record of working with multiple teams to deliver a sophisticated, efficient and easily manageable AirTable base. Advanced understanding of system architecture, integrations and automations is needed, as is comprehensive knowledge of formulas, scripts and other mechanisms that make our system as smart as possible. You will be our North Star, guiding our internal teams through the development, training and implementation processes through tech-free speak and your comprehensive understanding of how AirTable works best. Using your stellar project management super powers, you will balance the wants and needs of multiple internal groups while staying true to the overall vision. What we are looking for… A self-starter who knows how to create and run a project plan that gets results, fast Verifiable project management experience developing a

Hello! We’re helping a client build their marketing site, and we also want to help release an MVP using Airtable (I think). Overview: The app will match a “teacher” with “student”. Each party will receive an email introducing them, and encouraging the next steps. Everyone will register through the site; this is an easy part— to connect Typeform to Airtable to collect all the data. (2 forms: teacher form + student form) On the admin backend, the “matching” of the teacher and student will be done manually. The admin will manually select both parties from a list and click to send both parties the same HTML email that contains connection instructions. (one email send to both parties) So here are the questions… Is it possible to build functionality to select two rows (teacher & student) and fire-off a pre-formatted HTML email to these members? What platform be needed to hold the email template and on-command, populate several fields with data from Airtable + send the email? To have an