Jump to content

Search the Community

Showing results for tags 'portals'.

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

  1. I'm hoping someone might be able to help, or at least point me in the right direction. I'm creating a portal that displays a student photo, but would like the ability to navigate forward/backward through the photographs in the portal without the vertical scroll bar. My < and > buttons currently point to a Go to Portal Row - Previous/Next script step. It works great when "Allow vertical scrolling" is turned on, but does not work with it turned off. It does work with Allow vertical scrolling turned on and show scroll bar set to "When scrolling", however, the scroll bar appears on mouse-over. Any suggestions on how I might be able to achieve this? Many thanks! Matt
  2. Is it possible to put a portal in a layout in database B that displays data from database A? I don't want the information to be editable from database B, just visible there. To (perhaps) complicate things further, the data I want to pull in and display is stored as a repeating field in database A. Possible or no?
  3. Hi Knowledgable People! I run a martial arts club and have been busy redesigning my database to include a lot of new features. Using my limited knowledge, books tutorials and the knowledge on this forum, I have managed to create Invoicing, Roles and a variety of other things that I didn't know how to do previously. I am now trying to create a Grading Skill Set. This is where multiple techniques or skills are assigned to a Belt level. My problem is that I can't seem to create the Grading Skill Sets the way I want to. THE PROBLEM What I am trying to acheive is to create the skill set in the Grading Skill Set layout (which is working!), but add the techniques to the Grading Techniques table via a portal on the Grading Skills Set layout (which is not!). The relationship between the Grading Skill Set table and Grading Technique table allows for record to be created and deleted. The Grading Skill Set layout is shown in the Grading Skill Set.jpg attached. The reason for trying to do it this way is so that I don't forget to add a technique to a Skill Set and if I do, I can see that it is missing and create it on the spot. There may be many techniques with the same name appearing in the Grading Techniques table so by adding them this way, I will know which one belongs to which skill set, without accidently adding a technique with the same name from another skill set to this one. Each technique needs to have its own Primary Key, but, whenever I add a new technique in the portal it assigns the same Primary Key to each technique in that portal. Obviously, this can't happen and I get an error as shown in the Error.jpg attached. I have clearly missed something along the way and have been pulling my hair our to try and work it out, but to no avail. BACKGROUND TO THE PROBLEM I currently have 3 tables: Grading Rank Levels - Where all of the different ranks (belts) a student can acheive are created Grading Skill Set - The join table that will pair the Grading Techniques with the Grading Rank Level Grading Techniques - Where the different techniques that will be performed at each grading level are created The tables are currently joined as shown in the Relationship.jpg attached. WHAT AM I MISSING HERE? Any and all suggestions would be welcomed at this point. Thanks in advance!
  4. Hi, I believe I'm having a problem with an unidentified key concept. I hope to get pointed in the right direction. I am attempting to build an English horse racing form here in Tokyo. I import all the data from Excel and am working from a single table (I believe this might be the root of my problem). I did a few tutorials and I felt pretty comfortable with the basics. At my first attempt (and I thought it was strange at the beginning), I gave every piece of info that would appear on the form its own field. With a possible 18 horses running in a race, and 5 lines of past performances per horse, I ended up with almost 2,000 fields. I filled in each past performance line through look-ups from the race id. It was pretty cool and at the same time obviously wrong. So I bought FMP12 The Missing Manuel, and while I feel as if I am getting through the text well enough (I can build an invoice!), when I come back to my project I have been lost -- to a point of great frustration. I moved to trial and error for a few days and decided to come here. I have attached a sample form I borrowed from the Daily Race Form (and simplified it) to show what the end product would look like. I see it as a Mast Head, 18 Sub-headers (1 for each horse), and then 5 lines of past performances for each horse. To get away from 2000 fields I figured I must have multiple TOs (18?) of the single table I have, then I figured I need portals for each horse to display the 5 past performances. I've been working this angle to no avail and figured I must not have grasped a key concept. From what I've written -- is the missing concept apparent? Thanks, Paul race_form_model.pdf
  5. I would appreciate a little help as my head is getting sore from banging it! I have a 4 tables Students - pkStudentID, also contains name address etc Classes - pkClassID, also date etc SC_JoinTable - fkStudentID, fkClassID, fkCarnetID, payment method, payment amount so far they are working ok, and I can have students attending many classes, as well as each class with multiple students. Where I get stuck is how to structure my last table. Carnets - pkCarnetID, fkStudentID A carnet is a bulk purchase of Classes, in this instance of 6 classes (although that may change in the future) What I want to do is have a CarnetStatusField that switches to "inactive" once the student has attended all 6 (or Xnumber) classes. I have a portal that shows the Classes::Date, etc... where SC_JoinTable::fkClassID = Classes::pkClassID and SC_JoinTable::fkCarnetID = Carnets::pkCarnetID I can't seem to find a way to count the number of records in the portal. Am I missing something simple or is my logic crazy?
  6. Surprise, surprise. I am also a newbie but hopefully I have a softball question for someone just lurking around. Okay, so I originally built a solution for our church directory with the following schema: FAMILY _kp_family_id _kf_member_id last name MEMBER _kp_member_id _kf_family_id first name It was structured like this so that we could do a printed directory page and make use of the portal to just list the first names and their personal cells, email, etc. Now, I'd like to take that solution and also integrate an Attendance chart so that we can take attendance using FileMaker Go and an iPad. This is where the extent of my knowledge begins to be stretched. My goal is for every unique service (Sunday Morning, Sunday Night, Tuesday night, Saturday afternoon, etc.) to have a list that has every members' full name (last, first) and then a group of radio-buttoned statuses next to each of their names. It will look, ultimately, like the attached pdf. I color coded items that I'm guessing will come from a unique table. Will you please help me sort this out? Thank you, Jason Attendance.pdf
  7. hey gang, I was doing some testing after looking at a file from Todd Geist on his devcon discussion on commit records and learned alot from it. I suggest you take a look. http://www.geistinteractive.com/blog/2011/08/understanding-commit-record-video basically i downloaded the files and was looking at his sort on one of the portals as i did not see a realational TO for sorting ; which i thought was the norm. Also, his take was pretty darn ingenious. he uses a Let([ ] ) statement within the portal he wants to sort and a global field is placed on layout for you to type in information to find precise name, etc. I have definately made this very simple and please take a look & see if you like. The beauty of this is the Get(ActiveStartPosition) & the Position Functions. Yeah, i said the same thing, but when i did it, i was just stunned by the simplicity yet elegance and once done, you have a library of this for future projects. thanks Todd!! portal_filter.fp7.zip
  8. Navigation of portals in FileMaker is a pretty simple affair, you either have a scrollbar, or you don't. In this article we demonstrate another way to navigate portals using a pagination style. We also demonstrate how it can be implemented at the relationship level, or the portal level using filtering. Read the Full Article Here…
  9. Hi Guys, I've been trawling google and many forums for the last couple of days after numerous failed attempts, I'm now relying on the expertise of all of you. I currently have the following calculation: If ( IsEmpty ( Invoices::Search ) ; Invoices::Product Category Filter Popover = All Products | Popover::Category ; PatternCount ( List ( All Products | Popover::Item ; All Products | Popover::Supplier ; All Products | Popover::Internal ID ; All Products | Popover::Resale Price ) ; Invoices::Search ) > 0 and Invoices::Product Category Filter Popover = All Products | Popover::Category ) set up as a portal filter and it performs perfectly to what I needed when I was only testing with a few products in Inventory. I now have 36000+ records and would really like to only show items with a value of more than 0. I found a suitable calculation (subbed in my own field) on filemaker: If (All Products | Popover::Stock < 1; 0; 1) But cannot find the right area to add to my above calculation. Can anyone help??? Thanks Nathan
  10. I have a database that tracks events at locations in cities. Each event has a Unique ID. On my cities form, i have a portal that shows the List of locations in that city for each event. It also shows the Event ID for each location. Because locations have multiple events, the locations will show up more than once with different Event IDs., and each event may have more than one (or no) locations.   This is the portal in my layout. What I'm trying to do is get an average for each city of the number of locations per event. I set up two summary fields in the Lists table (which is the table shown in the portal). One is supposed to calculate the number of events, the other calculates the number of list items for the city. Once I have these two, I can calculate the average. My summary field for the number of events doesn't work. I have it set up as Summary = Count of Event ID (running with restart), when sorted by List::Event ID - which is the field the portal is sorted by. Is there an easy way to calculate the number of different event id's in the portal? Example - if the event ids are 3,4,5,5,5,6,6,7 - I want it to return 5 because it represents 5 events. Thanks!
  11. Hi All, I'm new to these forums so hopefully I'm posting this is the right spot. I'm fairly new to the more complex elements of Filemaker and have just started getting into Portals. I have two databases, one for Projects (quoting, invoicing) and one for inventory. Through portal filtering I've been able to pull up inventory based off of the type of material chosen in the PROJECT that matches the material in INVENTORY. Specifically, if I'm quoting Material "A", the portal only shows the available material "A" from inventory. Is there a way for me to go one step further and 'tag' the available inventory for a specific project? For instance... 1. Project 'Smith' requires two pieces of material "A" 2.The portal of INVENTORY shows three available, "A-1, A-2, A-3" along with the value of each 3. I want to tag specifically A-1 and A-2 and have the sum value of those become a value in my project database for this specific record only. Each project is a record. I assume that I could filter matching the PROJECTS::Project Name = INVENTORY::Project Name, but that would require going into inventory and tagging the material. I could also do this by typing in the name of the project in the inventory portal in the PROJECTS, but I was hoping to create an easier method like maybe a check box or something. Something I could click and it would put the name in and then give me the value of the material. Any advice would be appreciated. In the mean time, I'm going to use two portals, one that allows me to type the project name into INVENTORY from the PROJECT database and the second that specifically shows what inventory I've assigned to the project. Thanks
  12. Good morning guys, I am relatively new in filemaker however it is amazing how quickly you can develop an application that saves us a lot of time. However, it is a week that I got stuck in development. I am creating a database for the management of some recipes, for which I need to select all of the ingredients (in a portal) and make sure to display on another portal the list of the nutritional elements. For this I created three tables "Recipes", "ingredients", "nutritional elements", plus 2 join tables "Recipes & Ingredients" and "Ingredients & Nutritional elements". For example, the recipe "Spaghetti Bolognese" is composed of "pasta 50%" and "tomato 50%". The problem is this: in the portal I must display the nutritional element name and its concentration (10% crude protein), whose concentration is the sum of the protein made from pasta, and the protein made from tomatoes (so it is a field calculated). I ask you for advice on how to proceed.
  13. I am struggling with something that should be simple, but cannot figure it out. Below are three tables: Contacts, MaterialsTransactions, and MaterialsTransactionLineItems Within a layout showing records from the Contacts table, I created a portal showing records from MaterialsTransactionLineitems (so contacts could see each item and not just each transaction) Layout = Contacts Table; Portal = MaterialsTransactionLineItems The field on the left is MaterialsTransactionLineItems::Transaction_fk; the field on the right is MaterialsTransactions::TransactionDate Given the relationship, why is the date not showing correctly? Instead, just showing first record for all? Is it the relationship, or the way I have created the portal... both? Thanks
  14. Portals have been around, in FileMaker Pro™, for as long as we can remember and they are an ubiquitous part of the program. Portals have both positive and negative points to ponder, which can be maddening! This article by Michael Rocharde explores what they are, when to use them, and the pros and cons associated with them to try and keep your database solution from the Edge of Forever failure. Read the article in its entirety on the web or grab the PDF for your reviewing pleasure at leisure.
  15. This could very well be a very complicated question, but I'm hoping that someone with far more knowledge than me will have a quick answer to this issue. I have created a financial database that I use to display my boss's financial information via different reports. Let me first say that I KNOW there is a better way to do this, but I have managed to make this work for almost five years, so I'm just looking to fix this one issue, not restructure my database. No question about the fact that I probably did things the hard way. Oh well... I use this database file only for the current year. I generally make a copy of the file and then erase prior year data so I can start fresh. However, some data must remain in the database, like budget information. I enter the actuals on a monthly basis. I have one report that is called "Cash Flow Summary" that is mostly portals used to display the relevant data for each month. Each month remains blank until the data for that month is added to the file. However, when I generated this report for the first month in 2014, it found data for future months that doesn't exist in the current file, and some fields that are blank when there is data to be displayed. I have compared this report structurally with prior years to see what I may have done wrong, but everything looks identical. I even compared prior years that worked to other years that worked and cannot see where I'm going wrong in 2014. They all look the same structurally. As an experiment, I made a copy of the file so I could erase EVERYTHING and see what happens with this report. The Cash Flow Summary report is still pulling data from other sources even though the file is empty of records. I just don't get it. I tried to attach the file, but it says I'm not permitted to upload this type of file. I'm not sure how I am going to get assistance if I can't provide the file for someone to review. Anyone who can offer a suggestion here will be greatly appreciated. Thanks in advance for your time and assistance.
  16. Hope someone can help. I have a number of related tables. Companies Company_addresses Personnel Personnel_addresses Companies relates to Personnel and Company_addresses Personnel relates to Companies and Personnel_addresses Company_addresses relates to Personnel_addresses (sort of) The intention is to have unlimited addresses for both companies and the personnel related to those companies In the companies' form layout I have a portal that shows the related personnel. This relationship is based on a company_ID key. In the companies' form layout I have a portal that shows address fields. This relationship is based on a multikey drop-down global field. In this way I can select from a value list that includes Address 1 - Street, Address 2 - Postal, Address 3 - Billing, Address 4 - Shipping, Address 5 - Other. This displays each address without requiring any more real-estate on the layout. In the personnel's form layout I also have a portal that shows address fields. It's the same concept as above but with a separate value list that includes Address 1 - Work, Address 2 - Home, Address 3 - Postal, Address 5 - Other. What I would like to achieve is an auto-enter calculation or lookup in the personnel_addresses table so that when a personnel record is added in the companies' personnel portal the address info for the company's Address 1 - Street is added to the personnel_address table as Address 1 - Work. Just thinking about this makes my head spin so I thought I may be able to lean on smarter people than me via the forum. I could put together a simple db with just this functionality if it would help. Possibly needs a script trigger on the personnel portal's fields? Any thoughts?
  17. We have a table of job reports which displays the following fields: 1. Job number (unique number) 2. Job Title (text which is autofilled using the job number) Portal results showing a list of work done: 3. Work Done (number) 4. Hours (number) 5. Cost (number - based on an fixed hourly rate multiplied by Hours) Beneath the portal it then shows a total field: 6. Hours Total (Total of all hours displayed in the portal) 7. Total Cost (Hours Total multiplied by a fixed hourly fee) --------------- I want to create a new table with a portal search that I can type in multiple job numbers in a search field and it will display a list from the table above in the following format: 1. Job Number, 2. Job Title, 6. Hours Total Then I will create a couple of fields at the bottom which will add all the hours and give a total cost. The problem is I cannot work out how, or if it is even possible to search for multiple job numbers in a field to display the relevant results in a portal. Is it possible or do I need to go about it in a different way?
  18. Hello everyone, I have found a stange behaviour with filemaker. I have two tables linked by a third one. I want to navigate using the portal. But if I use a script on layout exit, then the behaviour is abnormal. Please have a look at the enclosed database and try normal, then abnormal layout. Please tell me if you consider that it is a bug or not. If it is a bug, should I report it to Filemaker Inc. and how? Thanks for your help, Regards Possible bug.fmp12
  19. First, I'm using FileMaker Pro 11 Advanced on a Mac platform I've created a calculation that returns the number of rows that appear in my portal, but it only shows the number of rows before the portal filter is applied. My calculation is this: Count ( Child::MatchField ) I've managed to do this on other layouts by creating a match field that encompasses all the criteria for the records that I want to appear in the portal. However, this particular portal iis filtered by variable information that basically allows me to narrow my results to more specific data. For example: In the Parent table, I have one record and in the Child table I have 20 records that match the criteria for the relationship which is: Parent::PrimaryMatch = Child::PrimaryMatch The portal filter returns any or all of the following matches: Parent::Value1 = Child::SecondaryMatch or Parent::Value2 = Child::SecondaryMatch or Parent::Value3 = Child::SecondaryMatch Which returns only 8 records. How do I get the Portal Row Count to only show 8 instead of 20?
  20. Hi - I'm a bit confused about how fields with results of SQL calculations interact with a portal. On a layout, I have a portal into a table which is related to the layout. I'm trying to use an ExecuteSQL calculation to simplify subcategorization of the data on the primary layout. I have sQL code that works fine when I set the parameters manually (hardcode) but when I put in arguments with fields that correspond to the portal rows I'm not getting the expected results. I understand that ExecuteSQL ignores table relationships on the graph -- but is that true for the arguments I'm feeding it? Or to put it another way - if I have fields in a portal that are calculated with ExecuteSQL - do they not care about how that portal is connected to the related layout? More generally - is there a way to do what I'm doing on a portal with SQL without using a portal? I know I can do a join in the code - but I'm unclear how I'd display the data on a layout - getting a list on a form layout the way you can with a portal. HOpe this makes sense! Thanks, Michael
  21. My database has only three tables... ITEMS - Which is an inventory of tools for the company. • BOOKED - Which records an audit of each time each item is booked in or out of the stores • TESTED - Which records an audit of each time an electrical tool is PAT tested [safe to use] The individual Items are displayed in a list layout called 'Item List' which is basically the 'Home Page'. The BOOKED events are displayed in a portal in a 'form layout' called 'Item Booking'. I've set the sort order in the portal to show the last 'booking' at the top. The easiest way to this portal is to click the small blue "go" icon in record on the "Item Bookings" layout. What I have tried to do is display the last "booking location" from the portal [at the top] in the 'Item List] so that at we can see the item's current location without having to view the portal each and every time. I managed to display the latest Booking Primary Key - [Max ( Booked::Book_Pk )] - but couldn't get it to reveal where it was last booked too. I shall spare you the list of things I have tried but before giving up completely thought to seek help here where I received helped before. Personally, I thought an auto entry by calculation would have been best but I just couldn't figure it out. Please find the file attached. Any help would greatly be appreciated. I have FileMaker 13 on my Mac at home but V15 elsewhere, if you alter the file please export in V13 to spare me having to leave the house to open it up on the other computer [V15]. Test-23.fmp12
  22. Hi all, forgive me if this is in the wrong place. I could not easily figure out where to post, apologies in advance. I was wondering if there is a way to have a records sorted in order of "date/time" last viewed. The idea being to have a list which the user can easily see records they were last dealing with and to use that list as hot links to those records. An example of this functionality is how Microsoft word gives you a quick find list of recently created documents. Kindest regards Ozziggy
  23. First of all, I hope everyone here along with your families, friends and loved ones have a very safe and prosperous new year. Now, I'm not really sure where this belongs topic wise. It could be either layouts, portals, tab controls or scripting. I have a layout that contains tab controls, outside the tab controls are fields that pertain to all the info that belongs within the tabs. Static info if you will. In the attached example, the static field is the TourID field. Contained within the tab is the Tour Expense information. It contains two portals, one for cash received and the other for cash spent. No problem so far. The problem I am having is this; whenever I start a new expense period, I cannot seem to get the cash received and the cash spent portals to show the latest information. They always show the original data. Also, using the new period script as it is written, the db automatically adds a new (empty) field to the cash given portal. This has to be a simple step that I am overlooking but hours have turned into days and I need to move along. In other words... "Somebody please help me..." Regards and once again, Happy New Year, Charlie TabControlPlayground2.zip
  24. I am working with INT and MOD functions to generate receipts. For example an amount splitted into 5 receipts. The first 4 have the highest integer and the 5th has the remainder. What I would like to accomplish is to show through a portal a calculation field with the result. I have made a sample file to explain my idea. As always, thank you very much for your help. NumberOfReceipts.zip
  25. for some reason my portal field has stopped showing the scroll bar and will not create new records, but alters the last record, effectively wiping it out. This is hell on the billing, since these are essentially purchase orders. I have scroll checked in the portal layout box, but no joy. When I invoke the inspector, the appearance and position tabs work fine, but EVERYTHING in the data tab is grayed out and I cannot check the scoll bar function there, or any other box. Adding to the mystery, when I duplicated the layout and replaced the portal with a new one, the scoll bar reappears, but as soon as i revert to Browse mode, the layout goes back to the original, dysfunctional layout and portal and WILL NOT allow me to change to the duplicate layout with the working portal (visible scroll bar) (a new name and everything.) I have named the portal as an object on the original layout and invoke it first with my script. basical open object, go to last line, set several fields, etc. no conditional formatting, just filter for latest seven records and sort ascending. Maybe I have to call it something else on the duplicate? FMA 11, OSX 11.6. Files too big to post. Menu set to standard.
  • Create New...

Important Information

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