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

Value list to text result?


gumstic

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

Recommended Posts

Hi

I'm trying to create a text result from a simple value list.

What it should do is when something is selected from the value list,

then anywhere on a layout -a text result should show which is equal

to the value list selected.

Example:

Value list = Apple, Banana, Peach

If "Apple" is selected from the value list then the result could be

a green "*" text, if "banana" then a yellow "*" and if Peach then

a orange "*"

Thats it.

Any comments will be appreciated.

Link to comment
Share on other sites

Hi All,

I am having the same problem, I'm new to Filemaker (only know the basics) I am trying to create a database, with two fields one which you enter a number 1-10 and when a number is entered filemaker should eneter a name into the other field.

Example:

Number: 1 (entered)

Name: Jog Bloggs (displayed)

Any help would be great blush.gif)

Thanks all

Link to comment
Share on other sites

if value list is based on numbers:

second field formula:

choose(firstfielfd;"",name1,name2,name3 ....)

if you use colors:

make a repeating field which contains your colors (or colored text "*")

Case(firstfield="banana";getRepetition(repeatfield;1);

irstfield="apple";getRepetition(repeatfield;2); [....]

"")

You could also build value list on related files andalso show the second value in the list.

field2=listfile::description

Link to comment
Share on other sites

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