Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Value lists a la Excel??


DaveK

This topic is 7860 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hi everyone,

I've been racking my brains over this one, so hopefully some kind soul can help.

My database contains many columns of mixed data.

E.G. Date, Number, Percentage etc.

I duplicated it in order to create a relationship. (It was all previously done on excel spreadsheet).

My question is this.....

Is there a way to do a search with the option of Equals Date, Does Not Equal Date, Is greater than date etc as in an auto-filter search as in excel.

If so could someone explain it as I am lost.

confused.gif

Incidentally, I would like to be able to have three or so different filters going at once.

E.G. greater than or equal to 1/1/2003 AND greater than 20% AND less than 2.

I have read the entire getting started manual and the full user guide, but just can't get my head around it.

any help greatly appreciated.

Dave.

Link to comment
Share on other sites

Congratulations: This is the first time I have seen this request in the four plus years that I have been a member of these lists.

IMHO I think you will have to script these to find buttons and maybe using a special layout. The trouble in using a value list is that once it puts the symbol in the field, you stand a chance for the user to remove it by entry. The only way to use the omit function is via the script step AFAIK.

Lets see what others have to say too.

Lee laugh.gif

Link to comment
Share on other sites

i have found an ineresting technique to filter records using the restrict record acces by field value function:

try opening using empty password

then inspect permissions with password "master"

This technique has certain limitations, but works well when NOT used on a self-join relationship.

recordfilter.fp5.zip

Link to comment
Share on other sites

This topic is 7860 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.