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
    • FileMaker Server 17
    • FileMaker Pro Advanced 17
    • Command Line Data Migration Tool
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
    • GDPR
  • FileMaker Server Administration
    • FileMaker Cloud
    • FileMaker Server 16
    • 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
    • Other Internet Technologies
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • Brain Food
    • FileMaker Pro 16
    • 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 194 results

  1. 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.
  2. 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.
  3. 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
  4. 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
  5. 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?
  6. 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
  7. 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
  8. 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
  9. 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.
  10. The Problem: I have a filterable portal (1) displaying contact names from a staff table. I need to click on a contact to add them to a separate portal of invitees (portal 2) on the same layout (Events) . I then need the original portal to either hide (or in some other way denote) the people already added to the second portal. In other words, it needs to be clear that a person already invited can't be invited again. The layout is from the table: Events Portal 1 is showing records from Staff (filterable via a global search field) Portal 2 is showing records from EventInvitees I need Portal 1 to only filter through those staff who haven't been invited yet. Any help would be gratefully received. I am struggling around using 'conditional formatting', 'hiding when…' options and non-matching field relationships!! Thanks in advance! Fumblewinter
  11. 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
  12. 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
  13. Hi, i am stuck for a few days creating an many-to-many relation and view/edit it via a portal, which shows the many-to-many. for a better understanding i attached a screenshot of the relationship graph. in the "Personen" table there will be basic informations of all persons (Name, LastName, Birthday, etc.) a person could be an Employeee (Mitarbeiter) with additional informations, stored in the "Mitarbeiter" table. (RoomNumber, OfficeNumber, etc.) a person can also be be a child. if an employee have a child (or more), the basic data for the child is saved in the "Personen" table and with the many-to-many relation the "Mitarbeiter.ID" will be mapped to the "Personen.ID" in the "Kinder" table. so now i would like to have an layout, where i can add an Employee. first it is necassary to enter the basic informations of the employee (Name, Birthday, ..) to the "Personen" table. after that the "Mitarbeiter" table should be filled with work-related data (OfficeNumber, ...). after the employee basic data is entered and he has an "Mitarbeiter.ID" i will need to use a Portal to add childs, which are related to "Personen" and related to "Mitarbeiter". so does anyboday has an idea how to do this? or can explain whats wrong with my database "design"?
  14. 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?
  15. 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.
  16. 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
  17. Hi, I hope that someone on this community is able to assist me in a rather complex dynamical filtering of portals... I am working on a pretty complex CRM based on this demo for dynamical filtering of portals by Sara Severson: http://www.soliantconsulting.com/blog/2013/03/dynamically-filtering-filtered-portals But I have an issue when trying to dynamically filter the portal based on several relationships, that someone here maybe can answer... This is my situation: Filemaker file A (the CRM) contains a portal which I filter. The portal show posts from file B (Contact database) with the use of a relationship X. The relationship match fields in the two files are global fields containing just "1" - which matches all posts. The filtering of the portal here is working great. I can filter posts from the Contact database without any issues. But I would like a second dynamical filter field in relationship with a file C (an Order database) so I can narrow down the contacts in regards to what they ordered. So I made, in file A, another relationship between file B (relationship X) and file C (Order database). Here I match a client ID in file B with a client ID in file C. And adjusted the portal filter criterias accordingly, so it took notice of this second filter field. And yes, now it seemed that I could filter out specific orders, to find, for example, only clients in city X (from the file B, the contact database) which has bought item A (from the file C, the order database). But I noticed it didn't find every client with a particular order - after some debugging I found out that this procedure did only find the latest order a client made, in file C. In other words: If client A (from contact database) ordered item A and then later item B (posts in the order database), the filter did only find the client's order of item B. If I try to filter for item A, it found other clients that ordered this item, but not the client which ordered both A and B. It seems that the relationship between file B and C only matches the latest match, which seems a little odd. If I put a portal in file B (the contact database), with relationship of Client ID with file C (the order database), Filemaker found all orders, but only the first row in this unsorted portal here is found by the filter in file A. Any ideas? How can I make the relationship between file B and C in file A to find all orders? Here an image of the tables in file A, with some complementary information: https://postorder-hstrom.tinytake.com/sf/MTUxODk5N181Mjg2NDAz With kind regards, - Johan.
  18. 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
  19. I'm currently designing an iPhone client for a database with many thousand records. I'm looking for a possibility to only load 100 portal records at first, then allow the user to load more if desired. Apple is doing the same in their iOS Mail application for IMAP connections. At the bottom of the list there's a button which allows the user to "load more messages from server" (or similar). I think this could be very useful for mobile FM development in general. After many hours I sort of gave up... the portal in question is based on a join-table. See image attached. Any ideas and input most appreciated!!
  20. 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!
  21. 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
  22. 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
  23. Agentshevy

    Finding Omitted Records

    I have an attendance DB File that takes attendance of participants. By simply scanning their barcodes, their timestamp are recorded. on a more detailed explanation, I have three tables: Participants, Attendance and Attendance_Line_Items. The Attendance_Line_Items is presented in a portal placed on a layout from the Attendance Table. That is just the structure of the file. From the portal records, I have managed to calculate the TOTAL ATTENDANCE, TOTAL LATE participants and TOTAL EARLY participants. But I am currently faced with two major challenges: 1. How to get the Total of those that did not attend with respect to the Total Record of Participants I have? 2. How to get precisely, those Participants that did not Attend? Please, I don't know if my topic really explains my intention for this post, but i am hoping whoever reads this would understand.. Thanks
  24. 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.
  25. Hi, I'm having trouble conceptualising how to do this, but I'm pretty sure it's best accomplished with a script, and I'd appreciate any help you guys could give on how to set it up or any additional information. I have a product table related to a child tasks table. For each product, there is a list of related tasks. Many of the products come out on essentially identical schedules, which means there is a lot of redundant entering of the same tasks over and over again for each product. Ideally, I'd like to script a few buttons on the product layout that will add a pre-defined set of task records (each including a description and due date) to the tasks portal based on a variable (in this instance, the release date of the product). For different kinds of products there are different kinds of schedules, hence the multiple buttons. Hopefully this makes sense. Would love to get any help I can get.

Important Information

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