Ok sorry for the delay, in addition to the time difference, I work at night, so I just wake up ... lolll
Okay, I'll try to explain just what I want to do.
We are setting up an intranet for our factory. We have 2 continuous production lines 24h.
The operators of each line must complete a form to detail the minutes of stops of the line. Currently this form is in paper form.
We want to switch to an electronic form, and the needs are to be able to export in CSV for Excel compatibility and be able to print on request. So after some research, Fabrik seemed right for me, as these options are basic.
I created the form completely, it is functional and has 11 tabs (1 for each of the machines of the line), of which 10 are repeatable, because it is a dropdown with the possible reasons for stops, once the chosen reason , The employee enters the number of minutes of stops and can add a new reason.
All this is functional.
Here's where it gets complicated:
I added a 12th tab, because we want each form to be approved by the supervisor of the watch. So I need to be able to get a summary of the total number of stops minutes each machine (repeatable tab), as well as the grand total of stops minutes of the line, so a sum of each total. Then once I have this result, I have to be able to calculate efficiency with either a simple formula when using Excel, in the style: an item tells us how many cases the line produced, then Verifies how much is the standard of this product, then one obtains the difference of the standard VS the reality, and therefore the minutes of stops must explain the final result.
So basically, I am able to put in element that asks the number of crates produced. The supervisor must enter this amount.
But then how to set up a check of the standard of this product (probably a sql table with the standard in boxes / minutes) ... then deduct this amount from the actual crates produced, and display the difference of minutes of stops Unexplained.
In short, I find it difficult to explain in French, then in English ... lolll
If anyone wants to help me, I'm sure it's possible, but I do not know how to get started. I can easily give access to a good Samaritan who would like to see the form.
Thank you !!!