Hide records if a certain value is selected

[gowrann]

Can anyone point in me in the right direction - I have a task.fp5 db - in a defined field "status" a value list of "Yes", "No", "In Progress" is linked to it - when "Yes" is selected for the record I want to instantly omit the record from the list view

How do I go about this

[-Queue-]

If your field is formatted as a pop-up menu, then you can attach a script to it.

Go to Field ["Status"]

Pause/Resume Script [0:00:00]

If ["Status" = "Yes"]

Omit Record/Request

End If

Go to Field[]

This is a little trick that works with pop-up menus. Be careful, though, because more than one option can be selected simultaneously from a menu. So you'll probably want to validate it so only one option can be selected at a time.

[gowrann]

Queue

Thanks for your response, - my field is actually called "Completion" and is defined as a pop up value list with the values already mentioned.

When I attach the script to the "Completion" field and change the value to "Yes" - the record still remains in list view!

What am I doing wrong?

Script is:

Go to Field [ Completion ]

Pause/Resume Script [

[-Queue-]

The trick won't work with lists, only menus. Change your field format to pop-up menu, and you should be fine.

[gowrann]

Changed format to pop-up menu - record still stays in list if value changed to "Yes"

[-Queue-]

Hmm. Can you attach the file?

[gowrann]

was using Safari before - didn't work with attachments

Archive.zip