Search the Community

Showing results for tags 'portals'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Custom Function Library


  • Journal

Community Forums

  • Community Resources
    • FileMaker Pro 15 Discussions
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 15
    • FileMaker Server 14
    • FileMaker Custom SSL Certificates
    • External Server Authentication
    • Stand by Server Deployment
    • Legacy FileMaker Server Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
    • FileMaker Discussions
    • Brain Food
  • FileMaker and the Internet
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker


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


  • FileMaker User Groups

Found 50 results

  1. Hello, I am back to working in FMP after a multi-year hiatus, and I am rusty and am currently stuck. Hoping someone can point me in the right direction. I hope I am posting in the right topic. I am building a solution where we have a number of many-to-many relationships that are being used via portals. This is the issue that I am having that I am stumped on. In this instance I have the following db graph: Workshops <--=--> WorkshopStaff <--=--> Staff Each workshops may have multiple Staff and Staff may participate in Multiple workshops On the Workshops layout I have a portal to WorkshopsStaff In order to add Staff to the Workshop I have a button that brings up a popover with a portal that lists all Staff from which to select. I can select a Staff Member and they get added to the WorkshopStaff table. This popover was more or less modeled on the "invoices" starter solution The way I am displaying the portal inside the popover is via a table occurrence like this: Staff <--X--> StaffList (Cartesian relationship) My issue is that the portal in the popover (the result of the cartesian relationship) displays and works as intended as long as I have one related entry in the WorkshopClient table. But for a new Workshop for which I don't yet have any entries in the WorkshopClient table the portal in my popover comes up empty. What I am doing wrong or is there a better way to populate the list from which to select staff? Thanks a bunch. -J
  2. I am so frustrated after two solid days of working on this really simple join table example. I am trying to create a little iphone application in which I can quickly track my homeless outreach contacts on the fly. I have been so frustrated. I made a lot of progress at one point by just deleting the portal and starting over. I attached two databases, test which works just the way it is supposed to. A simple widget model based on something I saw on youtube. and Client test which is my attempt. Test works fine. Client test is very similar with a couple of extra fields including a calculated full name field but nothing significantly different. Right now the problem is the relationship will not create a new record in the join table. Maybe I don't even need a join table. Not sure but the join table was one of my attempts at a solution. I have been using filemaker since 6 but only sporadically. I used to be able to create simple solutions on the fly but I just spent the whole weekend trying to get this to work. I don't have any hair left to pull out! Help! test.fmp12 NewClientTest.fmp12
  3. 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
  4. Hi i have an event table and a coordinator table. Until now each event had only one coordinator. There has now become a need that at some large events require more coordinators - could be upto 5. I have a login for the coordinators where they could see events which are assigned to them. The relationship is that the cordinatorID in the coordinator table matches the coordinatorIDF in the event table. I created a coordinator2IDF in the event table and tried to relate it aswell to the coordinator table but what happens that it even breaks the first relationship. How could i modify my table it should work like that with my already created table which was until now a one to one relationship? i would appreciate if someone could help me out on this...
  5. 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
  6. 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.
  7. 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.
  8. Is it possible to have the first line in a portal blank for data entry, rather than scroll for the next blank line. If one were to have two years of data, who would care about seeing two years ago data always on the first line?
  9. OK Here goes an question that I hope makes sense. The small POS that i am working on is progressing however, I have just noticed an issue with a popover portal display that i am not sure is correct or how to work around it. I will try and explain. If I create a new transaction record and dont put any data into the portal where the dummy product is In the image i.e. it is blank then when i click on the Green fruit /veg button to the right and the popover displays, i get a blank portal display. whereby i am looking to get When the popover displays. The popover is 7 portals side by side to form a grid. It works absolutely fine if a product has been entered into the left hand side eg where the dummy product is. It then displays. I tried to enter the dummy at new transaction via script and then delete it in the same script but the popover is again blank. The popover portal is based on a seperate table to the portal where purchases are entered. Any clues as to what i might be missing. This is in FM15ADV. on windows 10.
  10. I have a portal showing items, i want to have a column that displays serial number for each item, serial number has to start from 1,2,3,etc. i want the serial number to adjust accordingly when the user deletes any item, i.e. if user deletes item no. 3 i want all the items to shift up and fill the space left by number 3. How do i achieve this.? Am using filemaker pro 13.
  11. GOAL: I would like to either click on a button within main portal and in doing so the Sub Portal FK activate those records that match the Portals PK. CURRENT PROBLEM: When I am within the Main Portal if I want to time-stamp PK record 6 I would have to manually type it into the FK. In addition, it would get confusing because it is showing TimeStamps from both of the Main Portals PK. HELP REQUESTING(Thanks in advance): I would like to write a script that when I click on a button within the Main Portal it only SHOWS those records within the sub portal that are related to that PK. EXAMPLE: Within Main Portal:{See Figure 1 below} I click on the red button. In doing so, the Sub Portal only shows items with a FK of 6. I am hoping then I can go to the last row and add a new time stamp within the Sub Portal should I choose. THANKS: I know your time is valuable and I am really an grateful. **************************************************************************************************************************************************** ****************************************************************************************************************************************************
  12. I'm designing and working with my first Filemaker database using Filemaker 12 Advanced and Ipads using the Filemaker Go app (self hosted). I am having issues with random records going missing from the whole database (in each table and TO). There is no evidence that the record was ever in the database at all and this only happens every once it a while and is not restricted to a single Table; it happens in multiple tables, randomly, with no correlation between the instants. I would say 1 record in 50 goes missing daily. I have 9 main tables that are connected with a key. Each table has TO of every other table attached to share information through portals on each table. Table1 can create/delete records in Table2, but not vice versa, Table2 can create/delete records in Table3, but not vice versa... and so on and so forth. I am the only person who can delete records at all but especially from Table1, which removes the record from every table in the Database. None of the TO have the ability to create or delete. What could my issue be? I checked relationships, scripts and fields. Could it be the Filemaker Go app? Thanks folks!
  13. I have a portal that I will call LIST OF CUSTOMERS. (Photos #1 & 2) My desire is to type the first few letters of a company's name in the global field CallReport::ChooseCustomer and click on a red square button (Photo #4) to populate the portal LIST OF CUSTOMERS with an alpha-sort of my customers' names starting with Customer2::CustomerName >= CallReport::ChooseCustomer at the top and ending with Zywux on the bottom. Everything works PERFECT except the portal does not refresh such that Customer2::CustomerName >= CallReport::ChooseCustomer is listed in the first row of the portal no matter how many times I click on the red square button! (The top-left red arrows on Photo #3 signify repeated attempts to refresh the portal.) However, if I first click on any field, for example, in the field Additional Information shown on the right half of Photo #3, then I need only click on the red square button once for the portal to refresh and list the customer name satisfying Customer2::CustomerName >= CallReport::ChooseCustomer in the first row as desired. I would be grateful if someone can tell me how to changing my programming such that after typing the first 3 or 4 letters of the company's name in the global field CallReport::ChooseCustomer I could then click on the red square button causing the portal to refresh and produce the desired outcome. That said, it would be really cool if I could type "K" and K-Line, the first "K" company would be in the first row; type "L" and Kline would now occupy the first row; type "O" and Kloke would grace the first row. However, if the it too complicated for me to understand, using the little red square button is just fine. Thank you for any assistance you could provide me. Sincerely, Joe
  14. I am adding a new table to a system. The purpose of the new table is to be a personalized gateway into this rather large existing system. I am trying to define a relationship where the current projects for the user are presented in a portal on the gateway layout. So far so good, and it is working… with a catch. The problem is the user might be assigned to one of three different functions in the existing file the data is pulled from. The user's name could appear in one of three discrete fields, in any of thousands of records. I have it working based on a relationship to one of these three fields. But I can only find a way to have an "AND" relationship to the other two fields. What I need is an "OR" relationship: the user name in the gateway table related to function 1, OR function 2, OR function three in the second table. After I got things working with a single relationship I created two more occurrences of the second table in the relationship chart and related the remaining two function fields to the user name in the gateway table, but it still only pulls data from the first relationship I established. Any ideas?
  15. Hi, Am doing my first project as a beginner with Filemaker Pro 12 and am stuck at a point. Please help me out on what to do. am using these fields in a portal: Opening Stock, Closing Stock, Quantity Received, Quantity Sold and Stock Balance So for the first step: Opening Stock = Stock Balance then for the other steps or next inputs: Stock Balance is to = Quantity Received - Quantity Sold. Now, at the end inputs (say for 10 rows), the last value of the Stock Balance is automatically the Closing Stock. Please how can I do this? Is it possible in portal and if not, how can I achieve this
  16. I have a portal showing 10 records, i want to only display records number fiive and above, the goal is to prevent record 1 - 4 to from being visible.
  17. FileMaker just keeps getting better! With 14 we have more flexibility than ever before when it comes to creating gorgeous looking solutions. A number of a new layout styling options help make this possible. In this article we cover some of the new layout object styling options. Click here to read the full article!
  18. FileMaker 14 is here! To celebrate, FileMaker Weetbicks has written 14 articles all about FileMaker 14. Over the next few weeks we will be releasing these articles to the community. We cover all the cool new features (and some hacks!) and take things further as we usually like to do Stay tuned! Click here to read the full article…
  19. 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?
  20. I need a way to allow operators to move portal rows up and down in a portal. Is there a best practice that folks like? Perhaps point me in the direction of the preferred solution. Thanks in advance!
  21. I'm really new to filemaker and still getting to grips with how it all works. I have been following the Filemaker Pro13 Userguide as well as online tutorials, and am stuck with portals. I appear to have followed all the steps correctly but although my portal fields appear in the edit layout mode, when I close edit layout, no data appears in the portal. I have checked my relationships which all seem to be in order. Can anyone help to point me in the right direction please?
  22. I have a purchase order layout containing project name, purchase order number and date.This layout contains a Portal showing 'Category' 'Description' 'Quantity Purchased' 'Unit Price' ' Total Price' and 'Units Used' Where I enter line items off the purchase order. The 'Category' field is a drop down list based on the values placed in that field. The 'Description' field is selected from a 'Conditional List' from the 'Category' field. i.e. Category 'Timber' Description '4x2', '4x4', etc. I show all this on a report with two sub summaries for 'Category' and 'Description. I have deleted the 'Body' part and in the second sub summary (Description) part I have Summary fields for 'Quantity Purchased' and 'Quantity Used' These perform perfectly showing the correct totals. I also have an 'In Hand' field in the description sub summary which is a 'Calculation' field 'SumSummaryPurchased' - 'SumSummaryUsed' This however shows a Total which encompasses all the categories and descriptions together, albeit a correct figure. What I am trying to achieve is a quantity in hand for each description. Any help would be appreciated. Regards Doug Whitham
  23. 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?
  24. I set up a portal in a layout for table A with respect to related records in table B. The first screen shot shows the portal -- there is currently one related record, 1041.343US4.   I created a value list that is used in the portal. Thus, in the second screen shot, if I click in the box, you can see all the different values. This is working as intended.   Now, the problem I'm having is that the value list is not showing up for a new related record created in Table B using the portal from layout for Table A. See the third screen shot. If I click in the box, the value list doesn't show up.   However, if I were to enter anything, and press return to actually create this related record, and then go back to the newly created record, the value list appears.  That is, the value list is not showing up. If I specify the value list as a "static" list (i.e., use custom values), it does work. But this value list is "from field," specifically "include only related values starting from:" a table C that table A is related to. (If I say "include all values", the problem goes away).  The relationships are as follows. A and B are related by matter number. A and C are related by client. The value list is matter numbers from A, including only related values starting from table C.  Again, this works perfectly for any *existing* record shown in the portal. But, it does not work when attempting to create a new record.  I have the relationship between A and B set up so that A can create new records in B.  Let me know if this is clear! It's a bit of a vexing issue. I was thinking of work arounds, but nothing has worked so far.
  25. 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