Jump to content

select-able conditional value list


johnmarcel

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

Recommended Posts

I am trying to make a list that is select-able and the values are base on another field. I have tried the following but for some reason the values are all or none.

If(at_client_sn=814; List(at_department; 
"ALBANY MEDICAL CLINIC";
"ALBANY SURGICAL ASSOC";
"ALBANY SURGICAL CENTER";
"ELM ST. PROFESSIONAL";
"EYECARE ASSOC";
"GEARY ST. CLINIC";
"INTERCOMMUNITY HEALTH";
"LEBANON COMM. HOSPITAL";
"LEBANON IMAGING DEPT.";
"LEBANON SURGICAL ASSOC.";
"MAIN ST. CLINIC";
"N. LINCOLN MEDICAL PLAZA";
"PHYSICIANS REF. NETWORK";
"REBOUND PHYSICAL THERAPY";
"SAMARITAN ADMITTING";
"SAMARITAN ENDOCRINOLOGY";
"SAMARITAN HEMATOLOGY";
"SAMARITAN INTERNAL";
"SAMARITAN NEURO SURGERY";
"SAMARITAN NUCLEAR MED.";
"SAMARITAN OB/GYN";
"SAMARITAN OB/GYN SURGICAL";
"SAMARITAN ORTHOPEDICS";
"SAMARITAN PEDIATRICS";
"SAMARITAN PLASTIC SURGERY";
"SAMARITAN PRE-OP";
"SAMARITAN RADIOLOGY";
"SAMARITAN RHEUMATOLOGY";
"SAMARITAN SPORTS MED.";
"SAMARITAN SURGICAL SPEC.";
"SAMARITAN UROLOGY"
))

Link to comment
Share on other sites

 

I have a department field that  has around 30 different departments. When the client field has the correct client in it i want the list to be available. but, i want to be able to select the correct department from a list. a drop down list will not work due to the fact i have over 2000 clients. 

Link to comment
Share on other sites

I think I follow what you need. Correct me if I am wrong. Do you only need a field with a full down menu of the the Departments listed in ASC order? If so:

Define a new table called "Departments" with one field called Department_Name (Text Result).

Populate the table with your Departments - one record per Department

Define a Value List called "Departments" base it on a field value Department::Department_Name

Bask on your "client" layout, you can use that value list for the Department field.

Doe that work for you? If not, please let us know.

 

Link to comment
Share on other sites

I tried that. it works great when that particular client is selected but, when another client is selected the department field is not able to be written in. i am probably missing some step.

Yup. Tell ya what, will you post a sample file (with sample data) with what you did and a few notes (in red text) on the layout of what you are expecting to see? I will be glad to take a look at it and resolve the issue. It is probably something simple.

Thanks!

Edited by dwdata
Link to comment
Share on other sites

Hi Don,

I was going to point at conditional value lists, but I’m not sure the file is normalized for that. A sample of the file will be helpful to see his schema.

@Johnmarcel - be sure to zip your file 

Lee

Link to comment
Share on other sites

Ah! I see. So... only show the values if there is a valid client selected.

Attached is a file with a method to get that effect. It uses a Value list based on a relationship. The left side of the relationship is a calculation that checks that a client has been selected. If not, there is no relationship to Depts and they are NOT visible ELSE Depts are visible to be selected.

Hope this helps!

client_depts.zip

Link to comment
Share on other sites

Thanks I will take a look at the file.

Yeah I tried that but, the problem is that the pop-up has to change dependent upon the client selected. on 90% of the clients their would be no pop-up but the department field would need to be able to be manually entered data into.

Link to comment
Share on other sites

What determines if a client get a list of departments or not?

What version of FileMaker are you working with? FileMaker 12 Adv. like your profile suggests?  Base on this, I will give my advise.

Thanks!

Link to comment
Share on other sites

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