Filemaker Pro Portal Filter - multiple fields

[@TonyDiaz6502]

So.. in 15 minutes you just covered exactly what I've been trying to figure out for a few days.. one piece at a time. Here it's all straight and to the point. Thank you!

[@recipehacker9752]

Hey FileMaker Freak, you are a great teacher! A few suggestions for viewers: 1) don’t use serial numbers for ID fields 2) don’t refresh the whole window as it causes a whole redraw of window- just name the portal and then refresh the portal by name 3) the self relationship created is the same as the new master-detail feature for portals

[@shyotter61]

I love these shorter videos that you post from time to time. They serve (me) as great little reminders and pointers to things I'd forgotten from the demand distant past. I am a home user and use FMP for personal use! Kkeep up the great work :) Paul

[@miketrivisonno4891]

Thank you. I spent like an hour trying to figure out why my portal would filter on 1 field but not 2 or more. Watching this video helped a lot. I was using the "&" instead of " and ". lol. I feel so dumb now. If I didn't see you click on the " and ", I would have probably gone crazy trying to figure out what the problem was. Thanks again.

[@franbieb]

Thank you Guy for these - your youtube videos are very much appreciated.

[@albertoreyes1137]

quick and clear, thanks! thank you for sharing

[@jakubtomasek5965]

Most excellent. It was almost ten mins in before we got to the content of the title, but I learnt a bunch of useful things along the way. And then the "thing". Much appreciated. See you on Udemy, now that I know.

[@Sharpie2511]

Great video sir! Great explanation of the types of relationships.

[@ChristophLandon]

Hi Guy! This is exactly what I was after. Well documented, great tutorial. Thank you very much! Happy New Year!! Cheers!

[@jeffhansen5995]

Hi Guy, I Love your videos , they helped me immensely. one question on this subject, I created buttons for each of the filters that i want with a set field script, but what if i want to look at all records with no filter, how do i achieve that. buttons = | ALL | QUOTES | APPROVED | COMPLETED | ....How can i create an ALL RECORDS. I Tried OR's but that did not work it just returns a 0 in the field

[@recipehacker9752]

I would filter by using one field with a drop down list (instead of buttons) and that filtering field should be a calculated global field

[@williamf.yowtamag6996]

Thank you so much. Learned so much from you!!!!

[@lnebw99]

One thing missing: how do you clear the filter, if you want to see all entries again?

[@lexsemenenko9084]

First of all, thank you for the tutorial. Please tell me if I am wrong. There's a HUGE logic mistake in this program: Filters work when you are on any record (in your case there are four) And when you use the filters on a particular record, you always modify the values for that record because applying the filters actually updates the values for the field. It changes Genre and Mood of a song just by using the filters.....? This makes this solution of filtering not applicable. Also, the tutorial would be complete if you could add the following: 1. When you just open your file/MusicLayout, you see all of the portal items unfiltered. 2. For each filter, it would be nice to have a "Clear filter button" or an empty value which undoes just "that" filter 3. "Clear All Filters" button Anyway, I learned something, but it feels like just a teaser tutorial.

[@GuyStevens0]

Hi Lex, The object of this lesson was to enter song information and to see only related songs by mood or genre. Itś true that at some point I started changing the mood and genre velues, but that was only as an example. These genre and mood fields are not really supposed to be changed to other values. If you want to be able to change the mood and genre filter fields without changing the values of a certain song, then you need to use separate filter fields for the mood and genre. If you want to show all values you could add a hidden constant field with a certain value like "1" and add that to your filter. This could be a auto-enter data field that always enters the same value in one field. You could then have a checkbox filter field that uses that same value when checked. So checking this field would then match all records on the auto enter field. Greetings Guy

[@lexsemenenko9084]

Guy Stevens I missed the point :) Now it makes perfect sense, thanks, Guy! I will play with your suggestions tomorrow. Appreciate it much. I’m new to FM. Trying to develop a projects/tasks management solution to my unique needs.

[@charley2070]

I tried to get it work with a Global Filter Field (GENRE) and compare it to the genre Field in the portal filter Calculation as you did it. The Portal shows all records without the one one i am on. (because i set the relationship as you did) But the filter itself doesn´t seam to work when comparing it to a global field.

[@paulvandeventer7396]

Very helpful, thank you Guy

[@lexsemenenko9084]

Hey Guy, Here's video suggestons that I think many will find valuavle. 1. Could you record a video on how to filter portal rows without changing the values of a certain song? 2. How to filter a list view with multiple filters. Thanks! Love your channel

[@GuyStevens0]

Hi Lex, If you want to filter the portal without changing the values you can simply use new fields that are only used for filtering. All the rest of the setup is exactly the same as I have done it in this example. You can set those new fields to global storage to work better in a multi user system. But other than that the entire setup is exactly the same. I always try to show the absolute simplest basics so that people can understand how a technique works. Then it's up to them to expand on that and make it more complicated :) Greetings Guy

[@satori1312]

Great tutorial!

[@MuziekhuisLyanaStein]

Bedankt voor de duidelijke uitleg in je tutorials! Een vraag; ik wil van Access naar Filemaker overstappen en gebruik er vaak functie toetsen om bv naar een zoekveld te gaan. Kun je in filemaker ook functie toetsen toewijzen en hoe werkt dat. Alvast bedankt! Greets, Marcel Marell - Muziekhuis Lyana

[@GuyStevens0]

Dag Marcel, Je kan "Custom Menu's" maken in Filemaker die gestart worden door een toetsencombinatie. Deze menu's kunnen dan een script uitvoeren. En zo'n script kan zijn "Ga naar een bepaald veld." Je kan ook op een object of een layout een script trigger plaatsen die zichzelf gaat uitvoeren telkens er een toets is ingedrukt. Dan kan je bepalen dat bij een bepaalde toetsencombinatie een bepaalde actie moet gebeuren. Ook dit voert zich uit in een script, dus dit is heel flexibel. Ik gebruik dit echter zelf nooit en heb net even getest maar kon zelf de functie toetsen niet aan de praat krijgen. Ik heb een Mac en bij mij zijn deze toesten ook vooral gelinkt aan OS functies. Misschien werkt dit in Windows anders. Dat zal je eens moeten testen. Groetjes Guy

[@ontherocksduo]

Bedankt voor je reactie! Het zal in ieder geval op de Mac moeten werken, nu gebruik ik nog access op de PC waarbij ik de functietoetsen veel nodig heb. Maar ik wil het liefste alle pc's de deur uit doen ;) Maak je ook kant en klare/op maat oplossingen (of hulp daarbij) voor bedrijven en/of particulieren? Zou je me hierover willen mailen of bellen svp? [e-mail] 06-44162163 Greets, Marcel

[@GuyStevens0]

Momenteel heb ik het zelf veel te druk met meerdere Filemaker projecten. Misschien kan je best eens rondvragen op het Filemaker Community Forum. Daar zitten veel slimme developers. Groetjes Guy

[@gjermundification]

Nirvana is grunge, no? And the mood of nothing else matters has a mood of ballad, my 2cents

[@GuyStevens0]

Hahaha! Sweet! I Love it! :) But I'm seriously not making the video over again :) Greetings Guy