Showing Picture With Script.

[profilmgear]

Hello there,

I hope anyone can help me this time. I got a list of payroll records in filemaker. Some of the records in the list are wrong due to wrong calculation. There are too many data and it is difficult for me to check one by one. So, I will like to know how i gonna write a script to show a flag 'image' or 'picture'? Eg.

For every record,
If the salaryvalue is wrong, insert a picture to indicate an error.

Hope you are understand I am trying to say. Thks.

Regards,
Eugene

 

[TStriker]

Eugene,

I may have misunderstood your question but if it were me I would probably do something like this:

Lets say that your database contains a field called Vegetable which contains entries for both the word Potato and Potatoe. Being a Dan Quayle fan you like to spell it Potatoe. What I would do is create a field that was called Error_Flag and make it a calculated text field. I would make the calculation something like this:

Case (
Vegetable = "Potatoe";
"Correct";
Vegetable = "Potato";
"Incorrect";
""
)

I know you asked how to do it with a image rather than plain text but I get the impression that this is just a temporary thing so I would suggest just a simple method.

-Striker

 

[JeanW]

Some keywords here:

>> Some of the records in the list are wrong due to wrong calculation

How do you know the calculation is wrong for SOME records.
It seems that the calc doesn't take all the possibilities into account.
If you have a correct calc, you don't need to flag the wrong ones.

>> ...it is difficult for me to check one by one

If it is difficult for you, where you know where and what to look for, how difficult will it be for FM to find the wrong ones.
You have to tell FM how to determine a wrong record/value.

What is your definition of a wrong salaryvalue ?
If you give us more info about that, some can come up with a calc.
And I would look first to the original calc to see how to handle all the possibilties. I think there's something missing there.

 

[profilmgear]

Thanks for all your comment and advise. One of my colleague had help me to solve the problem... Thanks for drop by for spend so much time to read and reply.. I am very happy and appreciate it alot. Thanks again....