Need buildout of Airtable for Manufacturing

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 bottlenecks from suppliers

  • Create PDF-able “client views” to show clients updated ship dates and status of existing projects (% complete, estimated ship date, serial no., tracking no.)

  • Accounting for manufacturing costs, labor costs, markup/OH and the variance from the estimate of these items to the actual quantities being realized

  • Automate the updating of hours spent on individual jobs based on a report generated by our WBS program

  • Other cool, time-saving stuff you can suggest

If you’re interested, please post here and I’ll reach out to set up a time to meet and discuss scope and pricing.

An NDA may be required re: our financials based on our sensitive clientele.

Hello Patrick,

My name is Eric and I’d be happy to go over my ideas with you via a phone consultation if you’d like.

Would you be available to schedule a call so we can discuss your project in detail so I can hear your ideas and provide a price and turn around time to get this going.

If you’d like to discuss your project, please schedule a free consultation with me via this link:

You can also connect with me on linkedin - http://linkedin.com/in/eckline

Best,
Eric

Hi Patrick - definitely we can help here. Feel free to find some time to chat: https://drift.me/openside

Also happy to sign an NDA.

Here is a link to our services: https://openside.com/airtable-services

Thanks,
Dan

Hi Patrick,

I am an experienced developer and would be able to implement this for you.
You can reach me on andrewjohnson56782@gmail.com

Best Wishes,
Andrew