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 195 results

  1. 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.
  2. 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.
  3. 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.
  4. 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
  5. 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
  6. 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?
  7. 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
  8. Assalam u aliqum dear Brothers I am creating a database for a Bricks Kilns. Though me being a beginner i have managed to make it somewhow but now i am stuck in making a portal of customers where i enter bills and the record should go tot heir related filed. I have following tables Customers (linked to with foreign key) Challan (further liked to) Challan Items The portal shows only one customer related record where as i want a portal where when i cretae record it goes automatically to related customer record. Sample file is attached Mushtarka_Bricks.fmp12
  9. Panagiotis Alexoula

    Portal with four fields from different tables

    Hello there. First of all im newbie in fm. I use the filemaker 16. I want to make a new base that keeps track of pages and especially registerstations and log ins. So i created 5 tables: "sites, user_names, passowrds, emails and account_descripion) I linked the tables with relationships. I created a portal witch have fields from three different tables, a field user_name from table user_names, a field password form table passwords and a field email from emails table. When i insert the first line(raw) in the portal ιτ seems to work. but if i try to insert values in the second line (say in a site you vave two accounts like facebook one ofiicial and the other one "a fake account") it seems that something is not working properly. I upload a 3m12sec video to show you what i mean. Please check it if you have the time. Also, the source file that im working on is in this link (filemaker 16 file): https://drive.google.com/file/d/1zW1jC6-dL1I9zEplo7Xw0dL3Wy8onKkl Thanks for your time
  10. enquirerfm

    Get data from a field in a portal

    I have set up a portal which correctly shows the records I need. I want to be able to select the data from one of the fields - say there are 5 fields across one row of the portal and there are 5 rows of data showing. Is it possible to create a script which I can assign to a button which would copy the data in field 3 row 2, say? Thank you.
  11. 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
  12. 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.
  13. 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
  14. 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?
  15. 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
  16. 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
  17. I am interested in rendering multiple virtual lists on the same layout at the same time. A couple methods have occurred to me, but the method that seems easiest to implement would be to simply use repeating fields for my Virtual List table, and making sure to reference the correct repetitions in the scripting and on the relevant portals. Seems like that way you could have as many virtual lists on a layout as you have repetitions for your fields. I have no idea if this is a bad idea or a good idea, if it negatively impacts performance compared to other techniques such as having multiple virtual list tables, etc. Is there a widely accepted technique that is considered the best way to render multiple virtual lists on the same layout? Or is my idea as good as any? Any advice here is appreciated!
  18. 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.
  19. Justin Close

    Tale of 2 Portals and 3 tables

    This question is related to handling records in a transactional way by using portals to create related records. In my first use case, though, the transactional part isn't really important; but there is a second use case where I would like to use the same structure (scripts and schema) where transactions would be important. The general structure currently: I have 4 tables related in a straight chain, ala an invoices-lineitems-sub_lineitems fashion. But the 1st table isn't relevant in this issue I don't believe. I attached a picture of the relationships. The important ones in this case, I believe are the Revisions, LineItems, SubLineItems tables. The relationships are pretty straightforward, excepting that I am cascading some values down the chain. Quotes::QuoteID_pk = Quote_Revisions::QuoteID_fk --------------- Quote_Revisions::aRevisionID_pk = Quote_LineItems::aRevisionID_fk Quote_Revisions::QuoteID_fk = Quote_LineItems::aQuoteID_fk ---------- Quote_LineItems::aLineItem_ID_pk = Quote_SubLineItems::aLineItem_ID_fk Quote_LineItems::QuoteID_fk = Quote_SubLineItems::aQuoteID_fk Quote_LineItems::aRevisionID_fk = Quote_SubLineItems::aRevisionID_fk Quote_LineItems::subLineItem_key_g = Quote_SubLineItems::aLineItemID_fkI have used the QuoteID and the RevisionID as part of the relationships all the way down the chain, on the idea that they would make data entry simpler: when the new related record is created those fields would automatically populate. Yes, it is duplicate entry, but I would like to have those IDs in each table locally so that an ESQL call can be made against a single table without having to create complicated joins in the query. The 2nd use case will be doing this. In the LineItem <=> SubLineItem relationship I also added a global key field to control which line items would be shown in one of the portals (see below). The UI is this: One layout, based on Quote_Revisions. This layout has a slide panel with 2 parts: one part has a portal looking into LineItems, the second panel has a portal looking into SubLineItems. Each portal has 'create records' enabled. There is a button on each portal that will create a new related record in that portal. So you start out looking at a Revision record with it's data shown at the top, and the portal to Line Items is first. Then if you click on a Line Item portal row, it sets the global key field and switches the slide panel to the other pane that shows the SubLineItems portal (but of course, still showing the Revision data). And then you can push a button on the SubLineItems portal that fires a script to create a new SubLineItems record there. The problem I have is in creating the related records in this SubLineItems portal. It seems that when I try to create a new related SubLineItems record through that portal two things are happening: one, the record gets created, but it also creates a new LineItems record in the process; two, the SubLineItems record gets related to the 1st LineItem record, even if it was the third LineItem you clicked on to navigate to the SubLineItems portal (and thus the global key field is set to, say, 3). I'm guessing that my troubles are coming from the fact that this portal to sublineitems is starting from the context of the layout's base table, which is Quote_Revisions. Thus the magic key technique, when it creates the record at that third level, relates it to the first related record in the set at each chain. But how can this be accomplished with transactional techniques? Would I have to create a new relationship directly from Revisions to SubLineItems just to accomplish this? Using the portal to create the record doesn't quite seem to be working. I would like to stay on the same layout; I imagine that making a new layout based on the LineItems table (instead of Revisions), would then allow the new related record to be based off the context of a specific LineItem record instead of it having to try and figure things out from the context of Revisions. But that's not an ideal solution it seems - having to create that new layout: Screen flash, no nice slidey effect, repeated work, etc. I also suppose that I might alleviate some of my pain if I left the relationships with just 1 or 2 predicates instead of the 3 or 4, and then manually wrote the other duplicate/related data via script steps. Not real difficult, fortunately. The 2nd use case is that my next task is to create a system for duplicating a set of related records. This is where the Quote_Revisions table comes into play. We want to provide a method for the user to copy and existing Revision, and all of its related records, to a new Revision that they can then edit. This is why I feel I need to use transactions, so that when creating the multiple related records I can easily revert things if a problem occurs in the process. Wow, that went on longer than I thought it would. Any one willing to take a crack at this? - Justin
  20. 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
  21. 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.
  22. 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
  23. Hi, I am trying to hide a field in a portal using a calculation on the "hide" behaviour. Based on this article from some versions back - https://www.teamdf.com/blogs/a-very-nice-way-to-format-a-sorted-portal-using-conditional-formatting/. However, I am trying to use Global Variables to achieve this. In short, my portal has a "category" field whose value is repeated. And I want to "GroupBy" it, and only show the first occurrence of the category and hide the subsequent ones. <category> <name> <description> Cat1 ... ... Cat1 ... ... << Hide Cat1 Cat2 ... ... Cat2 ... ... << Hide Cat 2 I tried to hide the <category> field using the behaviour with the following calculation: Let([ This = Category::Name ; $$Prev = $$NextPrev ; $$NextPrev = This ] ; $$Prev = This ) I keep $$Prev as the previous category value, so that if the current "This" field is the same, I attempt to hide it. This will hide all the <category> because presumably $$Prev = This. However, If I test a. $$Prev = "Cat1" b. This = "Cat1" "Cat1" gets hidden. I am just wondering if there's something wrong with my calculation? Thanks in advance!
  24. Hi All, I am trying to filter a portal using case to display records matching only one condition (the first it match going down), but it looks like the filter is taking into consideration all the options and displaying related records that match any of the conditions. EG: Case ( newA = oldA ; 1 ; newB = oldB ; 1 ; newC = oldC ; 1 ; newD = oldD ; 1 ; 0) I thought the filter would work by only showing me the records that matched the first matched condition, but instead it's showing records that match any of the conditions. EG: if I had a record that had 5 related records, 1 where newA = oldA and 2 where newC=oldC, the portal would show me those 3 records instead a of just the first one which matched the first condition newA = oldA. Can anyone give me any suggestions as to how I can get it so that the portal only filter 'stops' checking the case condition once it's found a matched one?
  25. 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!

Important Information

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