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 Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • 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

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 199 results

  1. 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"?
  2. 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.
  3. 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?
  4. 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
  5. 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
  6. 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 Â
  7. 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!!
  8. 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
  9. 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
  10. 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
  11. 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.
  12. 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.
  13. This is my first time posting, and I apologize if this is the wrong place. I've only been filemakering for a few months, so again, apologies if this is a stupid problem. I could use some advice. I'm working on a solution that must create monthly reports in the following form: http://i.imgur.com/Cf4Fjic.png I've given up trying to bend the summary fields to my will, and began using the following approach: Make two new tables - Queries and Reports. In queries table, I have fields for M1, M2, M3, Region, Category, Subcategory and four result fields (M1, M2, M3 and YTD.) I also have foreign key into the reports table. Then in reports table, I portal into the Queries table. When report is run, a bunch of queries in queries table are created. The Results are populated via ExecuteSQL expressions. My question is mainly this: Is this too backwards? I feel like maybe this is too weird of an approach and I"m just missing something simple about reporting and creating summaries? Thanks!
  14. 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.
  15. 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.
  16. Hi, My setup is a portal displaying a repeating field. This repeating field is an unstored calculation evaluating SCGetContainer (mypath ; id on SC). When my id value on SC is the first repetition of the field, SCGetContainer displays correctly. When I am using the second value, I get a blank display. Is this something that can be done with the SCGetContainer Function? Thanks for everyones help. ole
  17. 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
  18. Hello everyone; Attached i have a file, but what is bugging me is wonky behavior in table / form view, IN list view it works fine as far as i can tell. It is a very simple file, but i really am confused here. ANy help / direction would be great. emp.fp7.zip
  19. 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
  20. I currently have a portal showing all invoices attributed to a given client. At the moment, I use the following portal filter calculation to filter based on the 'Amount due' balance (i.e. invoice status) for each invoice (using a drop-down list Client::InvoiceFilter, on the layout); Client::InvoiceFilter = "Show All" or Client::InvoiceFilter = "Show Paid" and Invoice::Amount Due = 0 and not IsEmpty (Invoice::_pk_InvoiceID) or Client::InvoiceFilter = "Show Unpaid" and Invoice::Amount Due < 0 and not IsEmpty (Invoice::_pk_InvoiceID) or Client::InvoiceFilter = "Show In Credit" and Invoice::Amount Due > 0 and not IsEmpty (Invoice::_pk_InvoiceID) What I want is for the user to be able to also filter based on a date range. This date range filter would be mutually exclusive of the above filter. Scenario would be; Layout opens with portal showing all invoices. User has the choice to set a date range (using global startdate and enddate fields shown on the layout) - default is 'all' User has additional option to filter remaining items in portal using the above 'invoice status' filter. Should I be trying to incorporate the date range into the above calculation? e.g add a line to the above calculation like; and Set Field [VisitNotes::Date; DateRangeGlobal::gStartDate & "…" & DateRangeGlobal::gEndDate] or is there another way of having an additional portal filter using another means? Alternatively, should I be using, say, a List layout (not a portal), to implement these two filter types (date range, invoice status)? TIA
  21. Environment: FM13 with FM13 Server, mix of Windows 7 and 10. Is there a way to set a script trigger on if this portal row is new? IE, a script to run if this new child/portal record is new. We have a parent record, and portal to Children records. The children records have 2 fields: Profile Name and Process type. Our user would like to enter a new child record (profile name and process type). if the process type already exists, we will need to archive the existing record (matching the profile type). There is more bI want to start with this first. I see script triggers to the layout "OnRecordCommit", but no similar script trigger for portals. Any ideas on how to handle this? Or am I going to have to add a button to go to another screen to accomplish this? Thanks. I hope i gave enough info for you to help me.
  22. 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
  23. Hi, I've been lurking around the forums for a while now looking at various topics regarding database schema for Survey applications. However, despite the insight and templates posted on this forum I still cannot get my head round how to create a relational database for my application. Here's the scenario: I need to create a health and safety inspection application which will enable the user to carry out a survey of how well a specific location fares against a bunch of pre-set questions/criteria. So pretty much a checklist where each question is either a pass or fail response. Currently the survey is paper based (I have attached an example to this post) As I understand it from other forum posts, the basic schema of a survey should be Subjects (in my case Locations) --> Responses <-- Questions <--Surveys But I need to have different Sections for Questions as well and i'm having trouble incorporating another table into my schema. Please find the attached zip file with the schema I have so far and PDF of the current paper version of what I am trying to accomplish. Could anyone tell me if i'm going in the right direction with this? (is the schema okay?) I have hit a brick wall and been stuck at this point for a while now! Thanks H&S report Paper.pdf HS FORM.zip
  24. 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.
  25. 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
  • Create New...

Important Information

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