AutoFill string to populate a variable from a pre-defined List

[Strauss 0]

Hi All,

I'm try to create a string data entry that needs some fairly strict data validation.  As such it can only be one of a fairly large (Circa 100) list of predetermined strings.  Rather than a clunky drop down menu, I'd like to create a data entry system that will allow the user to start typing the string and and have the overall number of possibilities slowly reduce as the user gets closer to the selection they need.  

Very Similar to a lookup table in excel!!  Has anybody managed to create this and if so was there a specific tool that made this possible?

Any Advise would be appreciated.

Thanks

 

 

[BobLfoot 302]

7 hours ago, Strauss said:

Hi All,

I'm try to create a string data entry that needs some fairly strict data validation.  As such it can only be one of a fairly large (Circa 100) list of predetermined strings.  Rather than a clunky drop down menu, I'd like to create a data entry system that will allow the user to start typing the string and and have the overall number of possibilities slowly reduce as the user gets closer to the selection they need.  

Very Similar to a lookup table in excel!!  Has anybody managed to create this and if so was there a specific tool that made this possible?

Any Advise would be appreciated.

Thanks

 

 

Doing what you describe would go from simple to impossible depending on what Rockwell hardware you're using??

[pturmel 160]

Relatively simple in a competent SCADA package.  What is available to you?

[Strauss 0]

Thanks for the replies.  Unfortunately I'm using FT View SE v13.0 as this is the customer requirement.  This software doesn't seem to have too many many features built in to it compared to other systems ive used, but was hoping this might be hidden away in an active X component somewhere... Its running on a non Rockwell PC windows 10 PC.

[pturmel 160]

I haven't had to do something like this in FTView in many years, but it has VBA.  You should be able to define a list of strings as a constant, and upon changes to a text field, loop through them to produce a filtered list.  You could assign that to a list component's choices for the use to make the final selection.

[Strauss 0]

Thanks for the advise.  VBA is an option but will take some time to develop.  Was really hoping there might be a standard function that I was missing.  If I have time I will try the VBA route but for now I think I will stick to the clunky features available in FT View.  Thanks Again