I am evaluating various platforms to build a custom production scheduling application for a client. Here are some details:
- Customers place orders for products they need produced
- Each order can have multiple line items for different products they would like produced
- Each order line item needs to be scheduled on one or more machines to be produced.
- The scheduled jobs for each line item need to be run sequentially, but not necessarily back-to-back. In fact, some products need to sit for a set period of time after one job before it can be consumed by the next job to make the final product
- If the date of the first job scheduled for a line item needs to be adjusted ahead or back, the other subsequent jobs need to be adjusted by the same amount of time as well. For example, if a customer orders “Product A”, which needs to run on “Machine 1” on 3/20, then “Machine 2” on 3/21, then “Machine 3” on 3/25, if the job scheduled on “Machine 1” is changed to start on 3/21, then the job on “Machine 2” needs to update to start on 3/22 and the job on “Machine 3” needs to update to start on 3/26.
If anyone has experience building a similar app, I would be interested in hearing about your experience using Airtable.
Otherwise, if anyone thinks that Airtable would not be a good platform for this type of application, I would be interested in that feedback as well.
I’ve also looked at ClickUp, which I think would work, but I think Airtable would provide a more open platform for adding new features in the future like Bills of Material, Routings, Inventory, etc…
Thank you.
