erconcept.blogg.se - Filemaker pro 18 portal scrolling

There are two main features that are necessary for an effective recursive function: This is done recursively by calling the function within itself.Ī recursive function is a function that calls itself in order to iterate or loop through a problem. If we reach the last word in needle and find a match, then we return 1 or true. If a match is not found and we reach the end of the haystack, we return 0 or false. Once a match is found, we move on to the next word in needle. If that match fails, we move on to the next word in haystack.

In short, we start by comparing the first word in the needle with the first characters in the first word in haystack. If you are curious to know just how this function works, read on… Function Details If you give the function a different name, you will need to change the two calls to that function in the function text above. Don’t forget to add the three parameters listed above in the order listed and name the function FindWordPartsInText. Left ( word Length ( needle ) ) = needle įindWordPartsInText ( RightWords ( needles WordCount ( needles ) - 1 ) haystack 1 )įindWordPartsInText ( needles haystack start + 1 )Īt this point, you can copy and paste the above function and skip to step three if you wish. The function, which I am calling FindWordPartsInText, is as follows: If ( The function will return true if, for each word in needles, there is at least one word in haystack that begins with that word. This will be used to iterate through all the words in the haystack. When calling this function, we would almost always pass the number 1.

start: This is a number representing the word within haystack where we will start searching.It will most likely be the contents of one or more fields.

haystack: This is the text we are searching.

needles: This is the search criteria (the needles we are looking for in the haystack).

Our custom function will take three parameters: For instance, if the user types “port art”, we want to find records with the text “ article about portal filtering”, but not “air port art“. The reason we need a custom function is that we will need to iterate (loop) through each word in the fields we want to search and look for a match on any word entered as search criteria. To achieve the affect we are looking for, we will set a portal filter which will use a custom function that we will write that will find records that have words that begin with the search criteria typed by the user. Global fields can be accessed from any context whether or not a relationship exists between the tables. Tip: To keep your data tables clean and better organized, I recommend having a separate table to hold global fields that are not directly associated with a particular table.