Jump to content

Search the Community

Showing results for tags 'portal'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 17
    • FileMaker Server 16
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker DataAPI
    • FileMaker WebDirect
    • Custom Web Publishing
  • FileMaker Platform
    • FileMaker Pro Advanced 17
    • FileMaker Pro 16
    • Command Line Data Migration Tool
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • Brain Food
    • Legacy FileMaker Platform Discussions
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Member Lounge
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Site Donations
  • Site Advertising

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 197 results

  1. Hi everyone, on a file accessed via filemaker Go 17, I am using a scripted navigation to move records up and down in a portal that is inside a popover. This has worked in filemaker 12 like a charm and also works on a filemaker client. The records smoothly move up and down the list. However in Filemaker Go, the portal follows every move of the script as if it is not aware of the freeze portal. EG the down button is to move the record one record further down inside the filtered and sorted portal (like so) This is the script. - freeze window and go to portal - go to first line of portal and loop through the portal until I hit the record to move - go to next line and give the position field the value of my record to be moved - go to line above and give the position field the value of my record +1 - commit record and refresh portal via an x join - go to last line of the portal - go to the line of position of my record to be moved. Would anyone be aware of this issue or know a workaround to stop the portal from flickering? Thanks so much
  2. Gismo12

    Dropdown portal

    Hi, I have a drop down in a portal, how do i filter the drop down box to only display the record relating the record in focus on the active layout where the portal is inserted? example: I have a customer selected in my customer layout, the customer has several products related to that customer. when I click on the drop down list in the portal, I only want to see the products for that specific customer. The drop down is in the warranty portal, products are saved in the product table with a reference to the customer. Please could you assist?
  3. Hi i have 3 Tables Property , Units , Tenant. Each property has many units , Each unit has one tenant active but may have many inactive tenants from previous years. All working fine BUT..... i would need to show a table in the property layout of the units and each one only with its active tenant. The portal is based on the units table. However the tenant just show up the tenant that was first input to the unit. My question is , how could i get that only the active tenant should show to the unit? i would really appreciate it someone could guide me on this.
  4. I know I've done this before, but can't find an example of the functionality in my archives and can't seem to work out how to do it again. I've got two tables: PERSONS and CONNECTIONS. PERSONS has an `id` field and CONNECTIONS has `person_1_id` and `person_2_id`. There's a relationship from PERSONS to CONNECTIONS with `id` = `person_1_id` and from CONNECTIONS to another TO into PERSONS, connections_PERSONS, with `person_2_id` = `id`, but these relationships may need to change to make this work. On a layout with a context of PERSONS, I need a portal into CONNECTIONS that shows the names of the person on the other side of the relationship. So if Bill and Ted are connected, when viewing Bill's record I see Ted in the portal and when viewing Ted's record I see Bil's record.
  5. I'm using a global field to filter a portal so that each user can set the global field and view different sets of records simultaniously. The problem I am having is that if any user clicks into any field, it is locking all records for all other users. I came across these threads that I think are related to my problem: http://fmforums.com/forum/topic/57413-relation-graph-cardinality-question/ http://forums.filemaker.com/posts/96fc4993b8 I think it may have something to do with having a global field on the RHS of the relationship. Has anyone else experienced this? Everything else is set up and working exactly how I would like, but the fact that all other users are locked out from editing all records is a big problem.
  6. So I have a hosted solution, with a dashboard with a couple portals. When I go to scroll a portal, scrolling even one portal screen has a delay of a few seconds, ie I click the scroll bar or try to drag it, and it takes about 3 seconds before it moves. Running locally, it's instantaneous. Running on a dev server on my LAN, there's a slight delay, but minimal. Having read various threads about this situation, my first thought was it's due to a filtered portal, so I removed filtering, but that made no difference. I also read various posts about unstored calcs and other factors that would cause all the data to have to be transferred to the client over the WAN. But here's the thing - at the moment, there are about 20 records in the database, related to the particular portal. Clearly, moving that data can't be the primary issue - right? I do have a lot of Execute SQL calculations in related tables, and I've read that can cause poor performance. But wouldn't that only be a factor when there are a lot of records? Are there design /schema choices that would cause significant lag regardless of the amount of data? Thanks, Michael
  7. I have a portal that has about 100 'names' in it. This list is longer than the portal is 'tall' so the user must scroll down to find a name. After the user scolls down to find 'Smith' and clicks it, the portal 'scroll elevator' jumps back to the top. I would like the portal 'elevator' to stay showing 'Smith' I have set "Reset scroll bar when exiting porgram" OFF but it doesn't help. Thanks for your thoughts. Ron
  8. rtor451

    Portal in Web Direct

    I have developed an work order intake form on Web direct. The problem I'm having is that some users can't see a portal I have to enter certain information. Whereas most users do not have this problem. This is occurring on window users using Chrome. I am using FMP 16 and Server 16. Does anyone has any idea why this is occurring. Is this a chrome or windows problem?
  9. Hi, I am using this calculation in portal which calculates days in portal Date - (GetNthRecord ( Date ; Get ( RecordNumber ) - 1 ) ) how can i modify or do something else to avoid (?) in the first row. Sample file attached for any modification/help. Thanks for any help DateCalc.fmp12
  10. I have a dashboard in my school Information Management database. I have used the technique of single portal rows to display Aggregate data such as how many total classes there are during the week and a differnt portal (& table) to display how many students attend classes (Some once a week, some twice). Ok, so far so good, 36 classes, 193 class attendees. How on earth's name can I create a calculation that shows me the average no. of students per class. (5.36) because as soon as I take this summary aggregate field out of the portal it displays just a single records data? Mmmm, I'm a bit lost here. Thanks in advance for all your help.
  11. ron G

    Portal Elevator Control.... NOT

    This is genuinely weird.  I have a Members table that is the basis for Members form. On the form is a separate TO of Members that lists, vertically, Member Names. When a member's name is selected a GTRR runs which puts the member information in the main window. This works.  The member portal (Navigation) shows just the Member names. The portal shows a max of 28 names. The problem is if I select member #47, the member is selected and then the elevator jumps to the top.   I have tried to program for this:   And this code works .... As Long As I Am in Debug. Huh? When I run the code in development mode it frequently fails with a jump to the top.  Here is the portl setup:   Should this 'really' be this difficult? Is there a work around?  Thanks for reading....  Ron
  12. jimlongo

    portal across page break

    Hi, I have 2 related questions. I have a portal in my invoice. It is followed by a closing paragraph which slides up to where the portal ends. I am producing a pdf to mail to the user. The portal may grow to 25 lines which would take it across the page break. Q1. How do I get the break in the portal to respect the page margins? It seems to print the first line on the second page half cut off by the top of the page. Q2. If the portal is only a few lines is there any way to eliminate the blank page 2 of the pdf?
  13. I am using FM 12 04 advanced. I have a Membership application. This script and problem revolves around two tables:  Members -->>DES  DES is represented by a portal on Members.   I have a fairly simple script (Just a bunch of If... Else if...). It works well.  The problem is that after my script ends (I can watch it in debug), the record pointer jumps to another record (most of the time... but not always).  I have added a Commit Record. No help. I have removed the Commit Record. No help. I have removed the Goto Object command and ... 'No help'....  Has anyone any idea why this happens? Looks pretty straight forward and yet it happens... I am stuck and perplexed.  Thanks for considering this.  Ron
  14. Apologies in advance for the newbie question, but I really have searched extensively on the web, this site and various tutorials. My only conclusion is that I do not know which question to ask, as I am fairly accomplished in VBA. I am self-learning Filemaker Pro 12 as I need solutions for an Ipad and I like the ease of creation and modification on the fly. Essentially, I have a database where the master might be many hundreds of fields, or I could create myriad tables and keys - this is irrelevant to the problem. What I would like is to create a solution where at the first field of entry, a dropdown allows for a selection of, say, 10 choices. When that field is filled, depending on the choice I would like a specific layout to appear for data entry. These layouts may have some fields in common with others but never all. Put another way, if I have Item_Field, and user clicks A, I would like the layout for A to appear natively or show up in a portal below. When they click new record, it reverts to the main layout again. I might also need this process to be iterative i.e. several levels down. If this involves CASE scripting, that does not scare me, I just need to know what to look for in the reference materials as to what this process is called. Any help would be appreciated. Thanks in advance.
  15. zeak.smith

    Adding New Record To a Portal

    Hi There, Â I am totally new to Filemaker but have a bit of experience making Access databases, My issue is as follows; Â I have two tables Subscriptions & Family Members, one ambulance subscription can have many family members covered. Â I have created a subscription layout with a portal to the family members in it, what I am trying to do is using a button popover add a new family member to the subscription. Â however when I add the popover and all the related fields inside it and create a button to add a new record, it first shows the family members already entered and when I click the add new record it adds a new subscription not a new family members. Â Best Regards Zeak
  16. I have portal with related records.In portal row record I need find specific text (patterncount) from a field and sum up that records cost field. How do i do that? Do I need to do a loop every portal row and use patterncount to check correct record and sum that record cost field($costs = $costs + table::cost)? Thank you for your help.
  17. Hi, I was here a while back learning how to build a horse racing form. Thanks to those that helped, I've been producing a form for several months now. However, I never did figure out how to make the track averages and have FM calculate my speed figures. I'd like to give it another shot, as it will save me a tremendous amount of time. Right now I am doing all the dirty work in excel and importing the track averages and speed figures into FM -- so I'm using FM as a desktop layout program, which I suppose sounds crazy. I can get FM to produce averages in a summary report, but I need separate summaries to get my speed ratings (I think). I'll try and attach a photo of a mock-up layout that might be nice. A few things: There are ten tracks, and over 8oo possible race types i.e Tok_A1_12D (Tokyo, Allowance 1, 1200, Dirt). And I only indicate race types for races on dry tracks, so there is that attribute. Also all my records are imported into a single table - so 150,000 race records so far. Anyway, I thought things like 'do I really need to make 800 separate summary calculations?' But, if that's the way it is, then fine. And as before, I still do think I have some pretty basic conceptual misunderstandings about FM -- I appreciate all the help I can get -- even the slightest pushes in the right direction. R Ave = Class Average (for race type) W Ave = Win Average (for race type) Thanks, Paul
  18. Hi all, I'm working on a script to add a foundset of records to a portal in another table. It's more difficult than normal as this portal uses a line items system to allow the same record (in my case artworks) to be on multiple lists. I'll include images of what I have so far for this script. At the moment when you run the script it just adds one record to the portal (in PRICE LIST). To summarise... can any one suggest how I can be in my "ARTWORK" layout and take a foundset directly to a portal (which itself is in "PRICE LIST") that portals information from "PRICE LIST LINE ITEMS". Graph attached too. Not sure I can use replace field contents in this case.. ? thank you!
  19. ryansapp

    Filtering for fields in a portal

    So I'm fresh & new to FileMaker but am fairly savvy with MS Access. Struggling to setup a form/report that can display some fields by a drop-down calender (date range). • Currently I've got a small portal setup on my home page that I can select the date (already made a field that generalizes the month/year) from although ideally I want the selection to stem from the drop-down calendar range, and below it I'm initially wanting to see a total amount of "shop tickets" within that given date range. Following the completion of this, I aim to try to figure out how to add more filters so that I can then possibly see the amount of tickets that are tied to a particular "pump tech" or amount of tickets in the date range that were "repaired","new","junked",etc. I've read up on multiple solutions that should've at bare minimum addressed the initial situation, and mimicked the exact way (or so I thought) of how they set things up in other databases and yet I still end up counting the total tickets in the database and rather than having it tied to the date filter above the portal as I had hoped for. Any help is monumentally appreciated, thank you! -Ryan
  20. Hi,  I've been hired to modify a database that was built to archive the work of a visual artist. She has a number of works that are related to each other (studies for a piece, or variations on a work). The primary metadata for her works are stored in a table called "inventory", for which the unique ID (and match field) is titled inventory_id. I need to figure out a way to relate various works in the "inventory" table to each other. In order to do so, I created a table occurrence of "inventory" called "inventory_2", and then set up a join table between "inventory" and inventory_2" called "related_records" with these two fields:  inventory_id  Inventory_id_2  I then related "inventory" and "inventory_2" like this (with the ability to create and delete records from either table):  inventory::inventory_id = related_records::inventory_id  inventory_2::inventory_id = related_records::inventory_id_2  So far, so good - all of this works just fine. The problem that I'm running into is that when I display these related records in a portal, I am only able to see one side of this relationship. I realize that this is because I can only display one side of the related record. In other words, when I relate a work to another work, I can see that relationship in the portal from the record where I created it, but the relationship does not display in the portal from the page of the related record.  (I have the portal set up to show related records from the "related_records" table. The portal contains the following fields: related_records::inventory_id_2, inventory_2::title, inventory_2::image). I can see all of this info from the record that I have added this info to, but when I look at the portal from a related record, the info isn't there. I realize that this has to do with how the portal is set up (alternately, when I look at the "related_records" layout, I'm able to see both records at once). I'm just having trouble figuring out how to set the portal up so that the relationship can be displayed in both records. Any suggestions/insights would be immensely helpful.  Thanks Â
  21. Hello! Just migrated from FM6 to 12 and am enjoying all the power and flexibility! I have two tables (Materials and Restrictions) that are "joined" in a many to many relationship through a third table (MatRest_JOIN). The primary table contains information on organic materials, the second table is a listing of all the possible restrictions a material might have. That middle, joined table which allows the many to many relationship can be understood as... 1. A material can have one or many restrictions 2. A restriction could apply to one or many materials at one time 3. MatRest_JOIN table has an index (ID) of it's own records and then for each record has the fields MaterialID and the RestrictionID At present, I can select one restriction at a time to be added to the joined MatRest_JOIN table via a portal. However what I'd like to give user's the ability to do is see a list of ALL the restrictions possible, choose via a checkbox beside each of the ones they want and then add all those restrictions in one step to the joined table. So back in my main layout for Materials that has the Restrictions portal, they'd see all the restrictions they chose/applied to that organic material. I do have a couple ideas how to accomplish this, such as a loop in the script that looks at each record in the Restrictions table to see if the user checked it....then as it comes across those, it creates a new record in the joined table tying the ID's of the Materials and Restrictions table records, then it continues through the Restrictions list performing the same task until it hits the last record. That seems like the way to do it, however it also seems like a might be a big clunky...going step by step through one table (which at most would only ever have like 30 records/restrictions in there) and checking a flag, and creating a new record in the joined table, on and on. Any thoughts are greatly appreciated...thanks so much! Joshua FM12_Script_MultipleRestrictions.pdf
  22. The Missing Man

    Portal is not Modifiable

    I created a portal that is based on a company table related to a Estimate_Line Item table. To this I have two related fields: parent client key = ::child client key and check box options= vendor (which is a calculation field="vendor) It currently tells me when I click in the portal on my company table that this action cannot be performed because this field is not modifiable. The portal is based on the Estimate_Line Item table and all fields located in it are from that table as well. Any help appreciated.
  23. angbrav

    Printing related tables

    Hi everyone! I've been reading lots of post about printing a portal.. but I didn't find a solution which could solve my problem. The problem is the following: I have a table in my DB which is storing bills. Each bill is composed by products. Products are represented in a different table. Both tables are linked by billID. In the layout which is going to be printable, It has a header and a footer where I am placing all the stuff I want to be replicated in every page. Plus, I have a body part which is just composed by the products which are composing the bill. Right now, I am using a portal to place those products. My problem, which I guess is a common problem: I don't know if one page of products is going to be enough so I would like to dynamically generate more pages in case they are needed. Thank in advance. I hope I clearly expressed myself. Manuel
  24. I'm having an issue with a set of portals that I have created. We wanted a horizontal display of different related records, with tall vertical areas. We are showing up to 3 boxes of details across a single row, so to speak. The layout is based on "TableA". TableA is related to "TABLEA_portals", which is just a table-occurrence of TableA (it's a self join). The layout is based on TableA. The portals all use TABELA_portals relationship. These are scratch records, so we create and destroy them regularly. The one record created at the start of the process is used to tie other related records in the set together, via the relationship. The detail box, on the left, isn't a portal, but just fields from the local table/record the layout is based on. It is intended that this would be the first record of all the related records, the master-record so to speak. The next detail box is a portal to TABLEA_portals, starting at Row 2, showing only 1 row. (See attached image; only 2 out of a possible 3 'boxes' are shown. Each portal only shows 1 row, and each is individually defined to start at a different row.) Part of the purpose here was to make this modular, so that more/less detail-areas could be added at will, without having to edit a bunch of script parameters or some such. The portal row being shown would take care of all the context issues as to which record was being edited. My problem comes along when I click a button (text label w/ button action) in one of the portals: I want it to toggle the checkbox/field for that record in that portal row. The label is a text label that spans over the field itself - using the field label as the button hitzone makes it a better user experience. The button action is simply: "Set Field [ TABLEA_portals::FieldA ; 1 (or 0)]". The intent is to use the portal relationship to set a field for that displayed record, but the context isn't updating to reflect the portal-row that the actual button is in, like I thought it would. (And if you hit a button on the far left, looking through that relationship should be the first record, i.e. itself, so it should also update correctly - even though it isn't a portal.) For example, if the context is currently in box1 and I click the button in portal2, the field for portal1 gets updated, not the field in portal2. Now, if I happen to click into an actual FIELD that is in that row, the context updates to reflect that portal row, and the buttons work as expected. But then the buttons in the other areas only update this new context...until a field is clicked in the other detail-box...etc. And nearly everything in these detail-boxes is a button, not a field, so the user hardly ever is actually clicking into a field. (My screenshot shows a field that I copied to the side just so I could have one to click into.) Anyone have any ideas on how to make this work? Thanks, Justin
  25. I have a layout that contains a portal. The portal shows rows which contain dates. The master table (the "one" table in the "one-to-many" relationship) has two global fields, gStartDate and gEndDate. I would like to have a script that would do a find that would select all the records in the master table, that have related rows in the portal table, that fall within these two dates. What is the correct way to do this? Thanks very much in advance to all for any info (or alternate approaches)!

Important Information

By using this site, you agree to our Terms of Use.