wip google sheet and form

we need a google sheet and google form based software ( mis , programming )
1. Master
a) Recipe (bom) master
b) Product master ( rm )
c) Product master ( fg )
d) Rejection reasons master
e) Break down reasons master
f) Operator master
g) Shift master
h) Machine master
2. Google form
a. For production entry
i. Recipe,
ii. Date, shift, machine
iii. Operator, rejection, reasons
b. Recipe
i. Date, and detail of recipe
3. Web form
a. Material receive from rm store (entry by rm store)
b. Actual shifting done from fg department
4. Result – wip ( stock information )
a. In the form – of rm , finished product , recipe compound
b. Stock auditing system