×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Showing Picture With Script.

Showing Picture With Script.

Showing Picture With Script.

(OP)
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

RE: Showing Picture With Script.

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

RE: Showing Picture With Script.

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.

RE: Showing Picture With Script.

(OP)
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....

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close