Help

Re: Need buildout of Airtable for Manufacturing

670 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Patrick_Conlon
4 - Data Explorer
4 - Data Explorer

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.

5 Replies 5
Anonymous
Not applicable

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

openside
10 - Mercury
10 - Mercury

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

Andrew_Johnson1
8 - Airtable Astronomer
8 - Airtable Astronomer

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

Hey Eric!

I’m looking for a similar solution for my company as well.
I’d love to hear about what you have implemented.

Thank you
Dmitro

Kris_Hogh
6 - Interface Innovator
6 - Interface Innovator

Hey @Patrick_Conlon and @Dmitro_Khroma,

We’ve built a number of Airtable installations for clients and customised integrations which feed off the data in the tables. I’ve written about one of them here --> https://community.airtable.com/t/using-airtable-for-custom-reporting-and-access-control/23725

and I’m about to write another article about a hazardous chemical database that is basically a register for hazchem products and sends auto notifications when the chemical safety sheet is outdated and requires renewal which is an important legal requirement in their industry. This integration checks the base daily for any items reaching it’s used by date and emails notifications right up to the final day, it’s on Google Cloud Platform and uses sendGrid to email the stakeholders.

Happy to jump on a call and discuss anytime, book a meeting with me here --> shooshmonkey.com/bookme or email me directly here --> kris@shooshmonkey.com

Cheers!
Kris
Chief Monkey