INSTALL ON TIMER SCRIPT?
Im doing a plan forthe production of materials.
What i have is my main layout 'BUILD ORDER'and another layout 'PRODUCTION PLANNING'.When the build order has all its info added there are 3 fields the user must edit, STAGE/PRIORITY/STATUS. PRODUCTION PLANNING WILL BE USED FOR PEOPLE IN PRODUCTION WHO JUST NEED TO SEE THE ORDER. IT WILL BE DISPLAYED ON A WIDE SCREEN AND SORT OF LOOK LIKE AN AIRPORT /DEPARTURE ARRIVAL SCREEN
STAGE HAS 4 OPTIONS: STAGE 1= BUILD ORDER
STAGE 2= PRODUCTION
STAGE 3 = COMPLETED
STAGE 4 = READY TO DESPATCH
and N/A so the script wont pick it up.
PRIORITY has three HIGH,MEDIUM,LOW these are generallykept the same throughout manufacturing stages unless the build order is changed
STATUS should really change in accordance with the STAGE field depending on the layout they are in.
STATUS:WAITNG= BUILD ORDER
IN PRODUCTION =PRODUCTION
READY TO DESPATCH=READY TO DESPATCH
So what i need it to do is every 10 mins to udate itself and add to the production layout the products that were created on the build order layout. in accordance with what is in the status field,and when the script obtains WAITING in the status field in stage 1 It changes the value in it to IN PRODUCTION.and shows up on the Production layout. When the product is completed the person who has created it selects completed and so all the status fields change.
iF HOWEVER THE STATUS FIELD SAYS N/A THE SCRIPT DOESNT ADD THE INFORMATION INTO THE PRODUCTION LAYOUT JUST OVERLOOKS IT.
I hope this makes some sense im not even sure if it can be done!