portal list to dropdown list

[chadski021]

i have this portal with 3 records with checkbox box on it 

and a droplist field for that portal what i want is to show only portal records with checkbox ticked

 

for example if i have 3 records 

photos, documents and files. If it ticked photos and documents in dropdown list it should be photos and documents only

[jbante]

Look into portal filters. You can search these forums and find several threads on how to configure them.

[chadski021]

Hello jbante im searching for the topic related to this but its difficult for me to understand without a sample file sorry im a filemaker newbie

[Lee Smith]

Why not attach your file, and then we can see first hand what you are trying to do? Also, this will enable use to your naming conventions for the fields, TO, layouts, scripts, etc.

 

p.s., if you need to see how to attach a file, follow the steps listed in this Site Instruction here: http://fmforums.com/forum/topic/88082-how-to-add-an-attachment-to-a-reply/

[Fitch]

In layout mode, double-click the portal to bring up the portal options.

Click the Filter portal records button.

The calculation you use here will depend on the method you've used to flag your records.

 

For example, if each child record has a text field with a single value such as "photos" and that value matches your drop-down values, the calc might look like this:

not IsEmpty( FilterValues( yourDropListField ; yourChildFlagField ) )

[chadski021]

Hi this is my example file as you can see there a dropdown in the Type field what i want as you can see theres a checkbox at the portal list what i want is if the checkbox is ticked then it shows the Typefiles field  in dropdown

 

https://www.dropbox.com/s/us7bgcqts1sl1nn/Test.rar

[Lee Smith]

Please attach your file here.

[bruceR]

Yes, Chadski should really upload the file correctly here.

 

I went ahead and downloaded it. It had only the first relationship which pointed to ALL records.

 

I added a second relationship that pointed to only the checked items.

 

Then I added a filtered portal based on the all relationship.

 

And a portal showing only the checked items.

 

Then modified the value list to display only the items from the second relationship.

TestMOD.fmp12.zip

[chadski021]

Hello Bruce is there a way to use only the ALL portal not the filtered and check portal 

[bruceR]

The portal does not control the value list. No portals are needed.

 

It is the second relationship that controls the value list.

 

The other portals were added just to show you how you can display the results.

 

It was suggested by another responder (Jeremy) that you might want to use a filtered portal instead of a dropdown list.

 

The filtered portal lets you see what that would look like.