A simple form for PDI operators to enter PDI details and loading photos.
The PDI details contains
- Project Reference number(string)
- Customer name(string)
- Container number(int)
- Container ID(string)
- Container size([ '40 feet','20 feet','Air' ])
- Date(Date)
- Shift([ 'A','B','C' ])
- PDI inspectors([ name(string) ])
- Issues([ [ issue(string),qty(int),status(sting) ] ])
- Status(['WIP','Completed'])
PDI photos to be stored as inside a folder named f"{Project Reference number} Cnt{Container number}" inside a one drive specified location.
PDI inspectors and Issues to be provided with addable and removable fields
All the details are to be posted in an one drive specified excel file