Dynamic Portals in Filemaker Pro®

This tutorial teaches how to make dynamic portal lists that update as a user types into a field.

NOTE: YOU MUST HAVE FILEMAKER V10 ADVANCED TO MAKE THIS WORK. If you don't have it, get it, it's worth the upgrade.


Here is the function mentioned:

Function name: IndexWord(Text;Header)

Copy from here V

Let(
[
tCount = Length(Text);
newHeader = If(Header ≠ "" ; Header & ¶ );
NewText = Left(Text;tCount - 1)
];
Case(
Text = "" and Header = ""; "";
tCount = 0; Header;
IndexWord(newText ; NewHeader & Text)
)
)

To here ^

Category:

Education

Tags:

• filemaker
• dynamic
• portals
• custom
• function
• row
• access
• database

[MarcosCabreraPhoto]

Hello!

I need a tiny help, it's about creating a script in FileMaker Pro 6 to find a related record in another file, ie I want to do a search of a customer invoice from a file called "FICHA CLIENTE" for a list of years in other traditionally files that are called "FACTURAS 2011, FACTURAS 2010, FACTURAS 2009…"

THANK YOU IN ADVANCE FOR YOUR HELP

[shaib23]

@SuperPubman

Hi ! Did you get an answer to your question about showing all portal records when the global searchterm is empty ? TIA for your help

[seasickdarwin]

One problem i have encountered, is that once you deleted the terms field; there is essentially no way to add additional data that can be queried. What I mean to say, is that once the Portal box is implemented, you cannot enter any more data within the terms field. If there is a work around please let me know.

[jimmecca]

Very nice. How might you make the search calculation for Jon Jay Doe = John Jay Doe John Jay Do, etc. as your custom function allows, - plus all permutations of the first letters of each word, such as, J J Doe Jo D J Doe Jay Do etc. ? :-)

[k4tay]

well done



[ozorg]

@purple375 lol! i was thinking MY macbook is going crazy .... but it's in the video ;-)

[purple375]

@purple375 I solved my problem :)

[purple375]

big thanx for you

Iam really enjoy with this lessons

and with you'r fan sound :D it's like my mac book pro :)

plz don't stop your video

[bonzaientertainment]

What screen recorder are you using ?

[SuperPubman]

Very simple to set up. Is there a way for all records to display in portal when searchterm field is empty?