Hi, I am a chemical producer.
I have a guy that weighs the chemicals, and a second guy that mixes the chemicals thereafter.
As a quality check, I want to check if the mixer is using the correct ingredients which the first guy has weighed
This is what I have at the moment:
1. I have 2 different google forms which populate 2 different response sheets
2. The 2 forms are the same and capture the same data.
3. Each form is done by different person
I need the following:
1. I need the 2 response sheets to be compared live as data is being captured
2. If the data does not match, I require email to be sent out
Bu iş için 25 freelancer ortalamada $139 teklif veriyor
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this due to my experience with Apps script. It will be quick and accurate. I will start immediately and complete it with Daha Fazla
It can be done by app script, by "on form submit" trigger. Once form A is submitted, it will check if there's a matching record in Form B. If it is found (matching by unique ID), it will compare all the values. If all Daha Fazla
I am best in proof reafing and also a good chemistry student I will do your data entry and comparing work effectively