Portal sorting, part 2 filemakerhacks filemaker tips. Returns a number representing the record that has focus in the current found set. Sep, 2012 the question on one or more of the filemaker forums was asked and answered. This will activate the correct portal for you to follow up using the go to portal row script step. It does not use recursion faster and requires only one function parameter. Dynamic portal filtering while you type using filemaker 11 s new portal filtering feature, you can now show filtered views of related records in portals without having to define new relationships. Filemaker portal table allow add, delete but not to edit. How do you get the count of the related records in a filtered portal. Filemaker pro advanced dynamically expanding portals. Unless, that is, you get creative with how you solve this particular problem. Aggregates summary fields in filtered portals filemakerhacks. Dec 15, 2010 hi phil, i have used a technique, i do not know if it is the same, where i put a merge field get foundcount on a empty row of a portal and it summarizes the number of records without having created a field in the childtable. Im not aware of any way dynamically alter the number of portal rows.
The entire question is how do i get a count of all the rows in a portal. Making creation of records in a portal more user friendly. Get field contents from clicked portal row filemaker pro. How to write a script to get total record count on filemaker. New filemaker pro interface on windows os, get a more native windows os. The older method found in highlight record row in list view used a scripttrigging plugin and there was another method that used a hyperextended web viewer to force row background color. In this case, we did attach this button to a script and all you need to do is choose a portal row number from the radion button value list above the button and then click the button. Different styles of filemaker portal row buttons thepracticalba. Jul 24, 2010 sometimes filemakers builtin indicator for what row you are on in a list can be a little lacking. So im having a little issue retrieving the value of a related field of a related row in a portal. Count records in portal with field criteria filemaker pro. It can be used for more flexible printed output or showing information from multiple tables within one single portal or list view. For example, a portal contains 20 records, but displays only 3. I want it to display the portal row number when there is data in the row like 1 data1 2 data2 and if the rest of the rows are empty it would not show.
However, whichever row i click on, it takes me to the last visited record. Returns the number of the current record in the current found set. Applying active state formatting to portal rows and list views. Again, there is no point in showing the x on our special portal row, because we cant delete it it isnt even a record. Aug 24, 2011 the value in the summary will change according to where the field is displayed, and in a portal, it will show the number of related recs shown in that portal. This is a very basic filemaker technique but is a very popular how do i. Setrecursion calculation function, sets the maximum number of iterations for recursion and loops within an expression. Dynamic portal filtering while you type filemaker inspirations. Nightwing enterprises doubleclick portal row selection for.
When we envision data management solutions, we tend to think of perfectuse scenarios, where no one ever creates a duplicate record, no one accidentally hits the new record button, no project is ever canceled, and certainly no errant script accidentally miscopies data. Right now, its set to go to the character details layout. Sorting portals the fastest sorter in the west the ability to sort portals is one of the most requested features for filemaker pro 3. Screen shot and demo have been updated to reflect this. Technically a portal can only display records from one table. The portal includes records with one of three different field values for the field named type of client.
Hello there, wouldnt it be just great to add new records in the top of a portal, instead of scrolling 188. Fortunately, there is a solution to draw the users focus to the row they are one. The third example has all the fields in the portal row grouped together and then these grouped objects are defined as a button. I want a script that takes me to a portal row and then duplicates the portal row. Dec 15, 2010 finally, using the same idea for the label, we can make deletion of records more intuitive. Returns a number representing the portal row that has the focus. Hello there, wouldnt it be just great to add new records in the top of a portal, instead of scrolling 188 records down and then finally finding the white line. Duplicating a portal rowrecord in filemaker solutions. Is there a way to go to each row s record from the portal. No doubt it will be added to filemaker s many features, soon. With filemaker 10, the easiest way, todate, is here. It has been collected in this format to allow solution developers to read the.
In this implementation, the technique system is operable in filemaker 7 or filemaker 8 on both windows and mac os. Filemaker portal show distinct value tutorial the scarpetta. Portal filtering is facilitated by a single recursive custom function, and the portal selection technique uses a single script with a calculation to provide the corresponding row highlighting. Iso filemaker magazine filemaker pro video tutorials. During conversion to filemaker 9, this was automatically updated to go to row by calculation. Turns out, there have been a number of attempts at making this easy it just hasnt been the case. Nov 10, 2015 originally, this example used the go to portal row by field. Portal row number worldwide filemaker community forums. Assuming you mean the total number of records in the current table, you can use the get totalrecordcount function. You can also click the current record number, type the record number you want, then press enter. It will give you a count of the number of a times a related field has data within it. Preventing careless delete actions in filemaker understanding the larger issues surrounding the delete button. How to show the number of portal rows a filemaker miscellany.
Normally, the leave is during one pay period, but if it goes over a number of paydays i have a button in the portal row that duplicates the last row and adds 14 days a pay period to the payday of the duplicated record. Sorting portals, the fastest way iso filemaker magazine. The navigation part of the script which takes me to the selected row works fine. I have for many years just used the count function to determine how. Besides the object name for the portal, at least one object in the portal has to have an object name, too. Get currentdate commit records go to portal row first go to field expensememo creating a new expense record sets the newemptyrow calc to 0.
However, i cant figure out how to do this within a script. I tried get portalrownumber but that returns only curr. Mar 04, 2014 this makes sure the selected portal row i use a background field with conditional formatting on a set global vs. In filemaker, showing distinct values in a portal can be accomplished in various ways. Navigate filemaker portal rows via crafted buttons. Find answers to filemaker portal table allow add, delete but not to. My cf returns only the row number count, not the visible values from the portal. In combination with a calculation field, it can be used to highlight the row of a list. In this video, i showcase how to solve the simple problem of showing and hiding a given button when a portal row is selected.
The second portal has a magnifying glass icon in the first row of the portal. Current record number number of records in the table. If the portal object name is unknown, nothing is returned. But in the meantime, heres a simple way to implement sortable portals in your current applications. This is a somewhat lame example of the go to portal row by. The way to do this is to not use portals but instead generate the report in a layout based on the table that contains the income and expense records.
For duration pauses the script for the number of seconds you specify. With the cursor blinking at me in the correct row, on implementing duplicate record from the menu to test the action, all records disappear from view in the portal and all other. Filemakerhacks filemaker tips, techniques and more. All you need to do is choose a portal row number from the value list and click the button next. I know you can create a new record in a portal actually in the related file by clicking on the next blank row and entering the corresponding data. Expanding portal rows it wasnt widely known or used until bruce robertson started promoting its use in ways which were previously not envisioned.
Im trying to create a button for each row in the portal which takes me to that records details page the one with the red box around it. The content in this document was originally written for the filemaker pro and filemaker pro advanced help. Selecting the correct filemaker portal in a script. If you need to join two tables then you have to do this manually or change the design and use one table instead of two since you want them in the same portal, then the tables are similar to some degree. One other thing to look at is to make sure that the portal button is totally inside the portal row if it touches the edge or overlaps, the button will not work properly. The answer is to use one of the aggregate family of functions called count. How to go to a specific portal row a filemaker miscellany. To make a portal active, you simple need to go to a field or a named object within it. I use a portal in the first table to enter the leave details leave dates, paydays, hours, etc. Feel free to follow along in todays demo file, portal sorting, part 2, if you are so inclined. So you will want to use the go to field or the go to object script step first, to go to one of the fieldsobjects in the portal. The value in the summary will change according to where the field is displayed, and in a portal, it will show the number of related recs shown in that portal. Calculates the total number of visible portal rows not the number of records shown in these rows.
In a portal, you need to be able to highlight a given record, and ensure that the portal row is visible. Post script triggers, it is possible to extend how filemaker behaves. Exit after last tells filemaker pro to exit the script when it reaches the last portal row. Consider a simple x piece of text in the portal which represents deletion of a portal row. Going to a portal row by the contents of a field can be scripted. The value returned is determined by the relative place of the record in the, and it changes depending on the find criteria and the. This means that this icon will appear in all portal row displayed. We havea portal that shows a number of rows, and an empty row at the bottom that allows a.
Find records that match a range of criteria in the same field. Navigate filemaker portal rows via buttons thepracticalba. Its a bit of a trick, but it can certainly be done. Go to last row, go to next row, for example, doesnt work. By calculation moves to the row number that is the result of the calculation you. Sep 08, 2010 so it is your standard garden variety portal. I was inspired by fabrice nordmanns function visibleportalrows. Conditional formatting is a great feature of the new filemaker. The problem with this is that, in order to show the number of records in the portal, it has to be shown in the portal, and therefore on every portal row.
However, i also want to parse out the number of records that are of client type 1, client type 2 and client t. Sep 14, 2010 this is a very basic filemaker technique but is a very popular how do i. A lightning fast alternative to the count function digital fusion. After you use a delete portal row script step in filemaker webdirect, click anywhere on the layout or use a commit recordsrequests script step to commit the deletion. One other thing to look at is to make sure that the portal button is totally inside the portal row if it touches the edge or overlaps, the button will. Based on requests from student of the philosophy of filemaker video series, this tutorials includes ten intermediate, ten advanced and ten expert tips and tricks to help you design better solutions in filemaker 15. Apr 07, 2011 my goal today is to strike a balance between cleverness and clarity, and also to take advantage of some of the features introduced in recent versions of filemaker hence the version 10 or later category for this article.