AnsweredAssumed Answered

INSTALL ON TIMER SCRIPT?

Question asked by JessOttman on Apr 20, 2011
Latest reply on Apr 20, 2011 by philmodjunk

Title

INSTALL ON TIMER SCRIPT?

Post

Hi

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

            PRODCUCT COMPLETED=COMPLETED

             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!

Thanks

Outcomes