Jump to content
Server Maintenance This Week. ×

Field completion (Excel-style)


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

Recommended Posts

Yeah, I've seen that... and it is cool... but that's a little different (unless I missed something). What I am talking about is when you type in a few characters and Excel gives you a completion by finding another entry somewhere in the column that starts with those same characters... as you continue to type, it may select different completions.

You can sorta get there by building a Value List on the field and formatting the field as a popup. But popup list completion is just on the first letter.

The ideal would be if, in addition to the 4 choices we have now (popup list, popup menu, check boxes, and radio buttons), FMP would add a fifth choice: completion.

Link to comment
Share on other sites

I totally agree Brian! I swear somewhere recently I saw an auto-fill. I'm at work now, I'll check my downloads at home tonight. I guess I'm trying to learn too much too fast to keep track of everything I'm accumulating crazy.gif If I find it, I'll let you know! Yes, FM's list is getting quite long ... do you think they're listening?

Link to comment
Share on other sites

There was a type ahead technique on the databasepros site. Go to

http://www.databasepros.com

and search the resources for "Clairvoyance"

It uses a paused script, and blinks a lot, so I don't care for it too much (It also crashed my computer once).

My favorite alternative to a huge value list is to create a multi-key calculated field with a formula like:

cNameMatch =

Left(NameField,1) & "

Link to comment
Share on other sites

This topic is 7833 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.