AnsweredAssumed Answered

pop up Alarm

Question asked by thong127 on Jul 8, 2009
Latest reply on Jul 10, 2009 by LaRetta_1

Title

pop up Alarm

Post

Hi all members of the forum,

 

These are some of the contents of my dataBase

 

Product Name 

Expiration Date

Quantity Received

Quantity Used

Quantity Balance

 

On the quantity balance I made a calculation "Quantity received - Quantity Used" and my problem is I would like to make a script for a pop up reminder that will remind me if the quantity balance of any material reached to a certain level (10% level) based from the Quantity received.

 

I have a script for the reminder based from a birthdate reminder which I have read.

 

1. Enter find mode []

2. Set Field[Reorder:: Quantity Balanced: If(Reorder::Quantity Balanced {lessthan or equal   to} .1*Reorder::Quantity Received;""]

3. Performe Find[]

4. Set variable[$found;Value:Get( FoundCount )]

5. If [$found>0]

6. Set variable [$counter; value:1]

7. Loop

8. Set Variable[$names; Value:$names & GetNthRecord(Reorder:

9. Exit Loop If($counter = $found]

10. Set Variable [$Counter; value:$counter + 1]

11. End Loop

12. Show Custom Dialog["Attention! Reorder Products"; "Products Need to Reorder:¶" & $names]

13. End If

 

Kindly help me organize the script based from my data.

 

Thank you very much.

 

Thong

Outcomes