Portals

Is there a way to 'count' the number of records within a portal? For example say you have a portal and next to it is a box with the total number of records (as you switch records, the 'Count Total' adjusts accordingly).

Hi guys, I've created my calc ok to calc the current age of the bill (get(currentdate) - billdate) What I want to do is have a portal set up for each "age" i.e 0 - 29 days, 30+ (30 - 59), 60+ (60 - 89) and 90+ (90 +) So i've then created a calc (joinage) If(Paid = "unpaid"; Case(CurrentDate - InvoiceDate < 30; "0"; CurrentDate - InvoiceDate > 29 and CurrentDate - InvoiceDate < 60; "30"; CurrentDate - InvoiceDate > 59 and CurrentDate - InvoiceDate < 90; "60"; "90");"") I created several join fields (tried unstored calc, and global): JoinCurrent = 0 Join30 = 30 Join60 = 60 Join90 = 90 Joined them all u…

I love portals -- especially since I have got them to have popup lists that depend from other popups in the portal lines via value lists and lookups from the realtionship. I was just wondering if FM lets you take it a step farther. Let's say that the first field in the portal line is a popup of category choices (by some sort of calc) that represent different tables such that by choosing one a relationship is defined to the table of choice? Then if that was possible, would it be possible to define subsequent fields by a calc of some sort that see the relationship defined by the category choice and then would allow these fields to be then populated by lookups acc…

I'm a new user trying out techniques I'd like to use later. I read that it is cleaner to edit portal contents in nearby fields instead of in the portal. The way I understand this idea is that you transfer the record that you'd like to edit to the'platform' by copying the data into a 'global record' in another table. The fields on the 'platform' are actually fields from a seperate table and will then be copied back. See Vendor_Item_Platform layout 1. How do you make the portal non-editable or display only? Is this actually just the regular portal with a script attached to the rows? How do you get rid of the edit lines around each box. 2. Is the glo…

I have created a FM7 runtime that has one database with 22 tables. Everything seemed to be fine during testing but I have had it reported that when the database is heavily populated with data the portal rows in various layouts merge and become unusable. I know this is not alot of information to go on but if anyone has any pointers why this could happen I would appreciate the feedback. Many thanks

I don't quite know where to post this but I'll try here first. I have an inventory file that holds the details of products sold: item number, description, upc/barcode, retail price, wholesale price, etc. When a wholesale customer comes into the store, he picks out the items he wants and indicate to our sales associates how many pieces of each he wants. I would like to create a solution to scan in each upc/barcode to do a find in the present file, have the choice set into a portal, which would then pull up the price for the items via the relationship in the portal, and we can indicate how many pieces are desired. If the customer picks out 30 items, at the end of the se…

Is there a way to make the records listed in a filtered portal into a found set?

Hi, I can't find out where I'm going wrong here ... I'm sure it's quite simple. I have a self-relationship. I want to be able to change the sort order of a Portal, via scripts. To this end I've made a calc field, based on a global set-field and the sort order is from the calc field. The fields and scripts all work as they should, both when inside and outside the portal. BUT ... the calc doesn't refresh, so the sort isn't effected. Opening and closing the calc field's definition in Define Database, forces it to refresh ... so I *know* the logic is okay, but I can't find any script steps, to make it work. I'm working in FM8 Advanced and don't rea…

I have a database of author names that is sorted alphabetically by last name. In a related table, i would like to do a lookup on the value of an author field for a similar name in the Authors database and have a portal that shows the nearest match and the surrounding 10 records. is this possible? I can get the nearest match to show up, but do not know how to show the surrounding 10 records (previous 5, next 5) Thanks for any help

I read all about them.. I never used them before and have no one around me who knows FM. I'm all alone.LOL....but a bit frustrated. I do not know how to post it, so i made a file with notes of what I would like to do. If you have a chance and a creative mind to interpret my words, please look at this file and help if you can. Thanks. portal.zip

I have a portal to another set of records and am trying to place the data from the portal to a text file (various positions in the single text file depending on the cursor position selected). This works only at the end of the text file with the use of a set field script and a button on the portal. I have tried insert calculated result but this for some reason does not work with portals(it works with drop down lists).By selecting the drop down lists and placing a button script with a insert calculated result-- I can place text into the file any place the cursor is located. Any one else had this problem?

I want to be able to insert text into a field using a button! I also want this text to be inserted were the cursor is currently blicking. No problem here I know how to do that, but as soon as I place the button in a Portal it only inserts the text at the end of the field, and not were the cursor was before. It is like it leaves the field when you click inside a Portal. Is there anything simple I missed? How do I get the inserted text were I want with my button in the Portal? Thanks for your help!!!

Hi all I'm having a bit of trouble manipulating a portal. I want to only display 20 lines in a portal (without a scroll bar) at one time, and have buttons 'move' the records on to the next set of 20. I thought I could simply use the "Go To Portal Row" script step to accomplish this. However, although Filemaker is going to the desired portal row, it won't 'scroll' through the portal to bring this row to the top, with the result that it effectively does not go to the portal row. Does anyone have any thoughts?

I have an invoicing file with several fields (item number, description, unit price, extended price) in a portal. It can be automatically sorted by setting the "sort related records" in the portal relationship. But I want to set buttons above each heading, so that I can click on whichever heading, and the fields in the portal will be sorted by that heading, just like in table view. For example, clicking on the button for "item number" will cause the fields in the portal to be sorted according to item number. Likewise, clicking on the "description" button will cause the fields in the portal to be sorted by description. Does anyone know of a non-complicated way to d…

Hi I'm wondering! Is it possible to delete a record in a portal if the contents of one of it's fields are deleted. I know how to do it via a script, but in this particular instance it would be much neater to do it via a calc. Flook

Ok Guys and Girls, Simple question. How do I show the First entry (the oldest) of a portal? IE: Date of Entry Description 1-2-05 Documents 1-5-04 Addendums What I want just to show up in a sept date field is 1-5-04. For reports. Oh, I do not want to resort the portal. Thank you, Joseph

Hello all, I really apreciate all the help I can get... Every database I am working with, I end up in the same problem and here is one of them ... I cannot get the description displayed from the invoice file... what am i doing wrong? thank you in advance :... 1.zip

I have a table of patients that has a 1:many relationship to many tables. each patient has many medications, many lab values , many visits etc. I have a layout for each of these and the data is displayed in a single portal for each. This works great for entering data and viewing data. I would like to print a summary sheet for each patient with limited data. for example patient name at the top and below it show only active medications, last month of lab values (or last 4 values), and last month of visits. I can isolate the data by relationships (limit meds to active, limit labs to current date-30 etc) and put 3 or 4 portals on the summary sheet but this is no…

Is there a way to freeze the portal so you can exit, do a script, and then return the same spot you were in previously? I have scripted it so that I can leave the portal and then return to the previously selected record, but the record always shows up at the bottom of the list and the user has to reorient themselves to the data. Is there a better way?

Hi, I have a portal that displays all the shirts owned by a customer. I'd like to add some filtering controls above the portal display; for example, a "color dropdown" -- if the user selects "red" and presses the "filter" button, the poral will only show his red shirts. This is easy enough when the color filter is populated, but when it is empty I want filemaker to essentially ignore the shirt color part of the relationship. Right now, if it is empty it will only display records with an empty shirt color. This is something that would normally done through a record list outside of a portal, unfortunately we have to display a lot of data on this page so it…

I am selecting one of four named products through four buttons on a layout in the "Selection" file. Selecting a product using one of the buttons creates a record in the "Items-Ordered" file. These records are then displayed via a portal in the Selection file layout. The Items-Ordered records contain option fields which are effected by check boxes that appear in the portal on the entry layout of the Selection file. (The numerical values in these fields are the actual costs of the options selected) Each record of the Items-Ordered file has a calculation field, called Cost, that is the sum of numerical values in the various option fields. And there a…

I know this has been answered before but I could not find it in my searching. I create a portal and I place a button in the portal. How do I prevent a blank portal row with just the button?

OK, this has been driving me a little nuts; I think I have uncovered a bug in FileMaker 7. I am working on a Time Tracking module, and several of my scripts use the Go to Portal Row script step. Some of my scripts use the steps in creating a new related record (by going to the last portal row), and some simply go to the first or last portal row and modify or clear a time. Sometimes, for no obvious reason, FileMaker fails to enter the portal, and inserting a Custom Dialog check after it should be on the correct portal row results in the Get(CurrentPortalRow) = 0. Has anyone else run into this? I can't think of anything I'm doing wrong; the file I'm working…

Hello fellow filemakers, Is it possible to omit a portal row record? I tried the omit option and it omitted my entire invoice. The issue is some customers we bill are on different payment plans. Some we bill only once every 3 months, some we bill only twice a year, and some we bill every month. The problem is that only some of the line items on an invoice will be billed later, and I'm not sure how to do this. Any ideas?:)

I am building an image catalog and I have an image view layout. I also have an artist view layout with artist info a portal to the image table displaying all images by that artist. The artist information and the Image information are separate tables. I would like to be able to click on a particular image in the portal in the artist layout, and be taken to the record for that image from the image table in the image layout. Please advice on how to do this or any alternative ideas. Thanks

Hello, Here's the situation (fmp6). 3 tables: [color:blue]orders,products and product_lines. In product_lines I have a field [color:blue]number (=nr of products sold) Products has a calculated field [color:blue]nr_sold which sums the field [color:blue]number in product_lines where id_product=foreign key product in product_lines. In the table [color:blue]orders I need a portal which will show me the top-10 of sold products. Tried showing the products with [color:blue]nr_sold in descending order but the portal shows all records of products (of course) and takes to much time to load. I know this would be an easy one in fmp7 (or 8) but how do I solv…

Maybe a silly question, but I'm just a beginner. How do you simply filter through a portal? Let me give you an example. I have 60 employees whose job changes each month. In the month of July, I need only 2 people to "wash cars". How do I create a portal with the following results: search all 60 employees and return only the names of those who "wash cars" in the month of July? In this same month, I need 6 people "painting the fence". So I want to create another portal, but this time search all 60 employees and return just those names of employees who are "painting the fence". Make sense? Any help is appreciated! jz

I know how to filter a portal list based on multiple fields. My question is, How do you filter a portal if you only want one value from one of the multiple fields? For example: I have a table called Cards with four fields. Call them 1,2,3,and 4. I have another table called Collection with one field. Call the field "style" What I want is to create a portal in the collection table that will show all the records from the cards table that matches the value in the style field. For example, if I typed creature in the style field in the collection table, I want the portal to show any record in the cards table with the word creature is in fields 1,2,3, or 4. I can…

I must be losing it! I know this is so simple that I am embaressed but I am mind dead about this. I have a portal that has worked perfectly up to now. It was originally a const1 type self join. The portal is now using a single key matched to a multi-value selector list of values delimited by a carriage return (so I can filter portal entries by a first letter in a name etc.). All the records show proper match field contents. The current problem is caused when I create a new record on a layout dedicated to the original table instance. The new record doesn't show up in the portal even though it has a proper match content. Switching layouts, sarting and stoping the program, s…

i have a portal on a layout to display servers and their tipout amounts for a restaurant. Now, when I enter the servers into the portal, are they not automatically related? because the second I hit enter, there are no more related records showing. but when i go to the layout that shows all the server records regardless of relation, they exist, and the correct variabkes match up. i will upload the file here to show what i'm taking about. the ones i have in so far that aren't working are under the banquets tab, and then under banquet 1 on the lunch shift of 9/18/2005, 9/23, and the dinner of 9/23. bizarre! thanks! amber tip_share_Copy.zip

Hello, I'd like to send a selected portal row's data to a field on another layout. Schema: 2 layouts ; 2 windows. Relationships: Table:Department Field:"Department" linked to: Table:Course on field: "Department" ------------------- Table:Student field:"special rec" linked to: Table:Course on field:"CourseID" The field "special rec" in the Student table is empty and waiting to be filled by a selected course. On the student layout, a button is clicked to pull up a window containing a layout which displays the departments with their respective courses in a portal. I then want to choose one of those course…

Can anyone explain a fundamental method to using portals. For example in using two tables on a many-to many relationship one needs to create join table and then have the join table be the basic portal, though the fields can come from the other tables. I can't get my head around why this should be the case. I'm a novice and its not clear when and why you should use particular tables over others when using portals. Even though there are clear relationships by using a different table occurence as a portal often brings a completely different set of results. Is there a clear method to this?

Hi everyone, I could not find a topic on this. Can I make a portal summarize my records? In other words, I have a descriptor field and a qty field. I have many records with the same descriptor (2pvc for example). I want the portal to show 2pvc only once with the summary field of the footages. How can I do this? thanks in advance

This is puzzling me: Is it possible to have a portal within a portal? Alternately, how to I display only the values related to items in a portal row?

A mini database for personal use with keyboard shortcuts The logic: The Field "Action" is Common For PC & Mac Then I have A field Shortcut for PC and A field Shortcut for mac. I just want to see the shortcuts in 2 portals (MAC -PC) filtered by the Keyboard Key and Then if this is possible filtered by application I try but I can't.... Download the File To see what I mean.... Can any anyone help..??? Keyboards_Copy.fp7.zip

I have a relationship/portal question. I am currently using three primary keys: Contact ID, Company ID, and Request ID. A Company can have many Contacts. A Contact can only belong to one Company. A Request can have one Company, and multiple Contacts. The catch here is that because Contacts switch Companies so much, the Request can have one Company, and Contacts from different Companies. On individual Company pages, I created a portal using â��EstRequestsâ�� as the basisâ��it gives me a list of Requests (Requests ID) that a Company is associated with. HOWEVER, when I try the same thing on an individual Contact page, it does not work! The only Re…

Is there a way to slid a portal in preview mode? I have a portal 20 lines long, I have made a report that utlizes the portal, but some records do not need so many lines for the portal, so I am left with a very big white space on my reports. Is there a way to slide a portal up when the other feilds are being used? Thank you, Joseph

In my solution, I have an In-Out Board where staff names are listed. There about 5 fields on it. These names are from the Staff table and are viewed through a portal on a layout based on a Home table. This home table is basically information about the company and has one record. The problem I'm running into is that only one person can edit one of the staff records at a time, since it is a one to many relationship (Home to Staff). All others are locked out until the user either clicks out of the portal or goes to another screen. Is there a way to allow multiple users to edit different staff records in the portal at the same time? -- Thanks

I'm building a contact database from scratch that will allow me to enter as many address as I want for a particular contact by storing them in a separate table and using a one-to-many relationship between Contacts and Addressess. Entry and viewing of addresses are with a portal on the Contacts layout. Here's the problem. I have two requirements for how this should work. If only 1 address is entered, I want this to automatically be set as the 'Primary Address' (without the user having to do anything besides enter the address). However, if there is more than 1 address for a particular contact, I want to be able to choose an address to 'set as primary.' I can …

I have a table of Students records related a table of their Grades. There is a one Student record to many Grades records relationship (e.g. a record in the Grades table for each subject a Student studies). Each Grade has a field for "year". I have a layout based on my Students table which displays related grades for that student in a portal. However, when I select the Grade year to be the current year in my find request (set in the portal showing the Grades), it displays all the Grades records relating to that student, including those from previous years. Q: How can I filter my portal to display only the student's grades from the current academic year? Than…

Hi all. I'm sort of new to FileMaker. I'm trying to at a second level of "find" to a portal window based upon a pop up list or a another portal list. I have a relationship where ClientID shows me related records for all Order Numbers for that ClientID. But I want a way to choose an Order Number by clicking and the details of that Order Number show up in a portal of related records. I guess this is sort of like being able to look at the details of a client's invoices by choosing the invoice number. I've taken a screenshot to help explain this. http://www.studyusamagazine.com/downloads/Files/FM_Screenshot.gif I've been scratchig my head on t…

Anybody out there to help me with this? I'm trying to loop through a portal copying a field to a different database (not related). My problem is that Filemaker never makes it to the next row. It keeps copying and pasting the first row. This is the script: *********************************** Go to Portal Row[First] Loop Copy[select; pr::field] # paste contents via sub-script in external db: Perform Script[sub-Scripts;External: "db.fp5"] Go To Portal Row[Next; Exit After Last] End Loop *********************************** It seems the loop doesn't work because of the Copy command. Any thoughts on this anyone?

I am having difficulty getting a portal to allow me to create records, and also edit values. I have a people table, and I'm trying to associate children with their parents in a second table called people_parents. I created a second occurrence of people, and made my relationships from people to people_parents to people_for_parents. I then have a portal in a layout connected to people where I want someone to be able to create the parent record. I am able to make this work by pointing the portal at people_for_parents, and FileMaker automatically creates the join record in people_parents. The problem is that I have a couple fields from people_parents that also need …

Within a particular layout, I want to show only portal records that have anything in a given field - I have a many-to-many database: People [table 1] Organizations [table 2] Affiliations [table 3, links tables 1&2]. What I want is to show in a Portal within People only records in Affiliations that that have a value in a field within Affiliations called "special role". Doesn't matter what value is in role, just don't want it to be empty. I read http://fmforums.com/forum/showtopic.php?tid/170110/post/176995/ but this seems a little different... ideas??

Is this possible? I have a database of books and articles. I want to take multiple, separate notes for each, so I have created and set up a related DB (Notes SB). I can add notes in the main DB, and I can open a note from the main DB and show the full related record in the Notes DB. The portal in the Main DB layout shows only the first line of each Note, in a list form. But i would like to do the following: while in the main DB with the portal showing, use a script (command-1) to pop up the NOTES DB window, with a new record created. I know I can do this manually (go to last portal record, type something, choose open related record) but that gets rather tedious…

Hello all, I have two fields in a portal (month & year)that are defined as a pop up list. The pop up list is defined with value lists, month(jan,feb,march,etc)and year (2005,2006,2007 etc). During data entry when you select the year filemaker puts this year in all of the portal rows below, but when you select the month from the list it only adds the value to that field. I need the month to do the same thing, but I can't figure out how the year is able to do this when both fields are configured exactly the same. If I can get the Month field to do the same thing I can save so much time and clicking during data entry. Any ideas??? Thanks! Example: Month …

I have a portal (working perfectly thanks to mr_vodka) which filters and displays records based on their status (active, completed, canceled)-using global data. Can I define it through an additional value list "class" being (maintainence, electrical, plumbing, painting or all) The majority of the time it would be set to a default of 'all' but occasionally my boss would like to see if any one area is lagging. As you can see I tried to just duplicate g.activestatkay2 with g.activestatkey3 but ran into the problem of the portal only being able to be referenced to one table at a time? Thanks for your help

Hello I create a columnar list with a portal in it. The portal I made in FMP7 shows also the empty rows. Is there a code to show portals something like this: <> Or a code like CMDL: [FMP-Portal: InvoiceID] [FMP-Field: InvoiceID::Product Name] [/FMP-Portal] which shows only the related rows.and not empty rows which I specify in the portal setup? Greetings, Jukkie

I'm running into a problem in a certain portal in my solution: When I try to create a new record by entering data, the record will not commit merely by leaving a field. Say, I have portal fields f1, f2 and f3: I click on f1, and enter "foo". I click on f2, and "foo" vanishes! I continue typing "bar" into f2. I click on f3, or click out, or do anything to commit, and suddenly I have 3 portal rows! One with "foo" in f1, one with "bar" in f2, and the usual blank one at the end. I have compared this portal to other portals on the same layout that are also designed for record creation, and I cannot find any differences, yet the others all work as they ar…

This is another classic School Database setup - Tables: [color:blue]STUDENTS, ENROLLMENTS, CLASSES. From the STUDENTS table, I've created a portal which contains student enrollment data. [color:red]Issue: I've been sucessful in setting up and displaying data from this relationship, however I also need the capability to [color:red]MODIFY records for that student contained in the portal. [color:red]For example: from the STUDENTS table the user [registrar] should be able to [color:blue]ADD a new class to the students record. Currently, I can only [color:red]view those classes (via the PORTAL) which had been created in the ENROLLMENTS table. Any modification mu…

I have created a database in FM8 to design a worship service for a church. I have 2 tables, 1 is the Service table and 2 is the songs table. I want to be able to view a list of songs sung in the past by 3 groupings. 1. Songs sung the least 2. Songs sung regularly 3. Songs sung the most By choosing a group such as the “least sung”, I want it to display the songs in the portal. My question is, how can I get the portal to display each song only once, rather than multiple times, even though the song has been sung more than once. Thanks for your help!

Hi, I need some help understanding horizontal portals. I downloaded the sample file that was so graciously provided by HOnza from 24U Software Company: ************************************** http://fmforums.com/forum/showtopic.php?tid/170001/ ************************************** The problem I am having is I am not experienced enough to understand how to make it work. HOnza said that it employed the new function GetNthRecord and involved creating a single repeating calculation field for every field that is supposed to appear in the portal. I'm hoping that someone can look at his example and show me how to do this with just one field at a ti…

Hello, could someone help me with a solution for this. I have a portal which shows various Films a client has purchased, the relation is based on the word "sold" in an "Actions" field so I have an "if" function to filter this, which works fine. Now for various reasons a Film may have the word "Sold" in the "Actions" Field more than once, so I end up having the same Film in the portal more than once. My question is how can I "filter" this, so that the Film in the portal only appears once. Thanks in advance Ian

Hello folks, I have two Tables, Orders and Products. On the Orders Layout, there is a Portal going to Products, related by an OrderID key. I need to create a calculation field in the Orders table that stores the price of the Most recently added product in the list. I also need a calculation field that stores the first products price. What's the best way to do this? Thanks a lot! Andrew

How do you create a tab portal or single page portal view for browsing multiple address records for a contact? Ideas on creating a layout similar to the business tracker sample, where an additional tab appears with each address. In other words, the contact layout would allow two or more addresses in a non scrolling portal . Navigation arrows scroll through portal records. The tricky part is the interface. I need a tutorial on creating this layout with a complex many-2-many relationship. A sample database would help, yet a tutorial or book as a quickstart guide would be ideal.

Hi all A have a portal to view welders repair rate for the years. I sort the records by year but the portal show the records in random order. I even tried sorting the portal manual but nothing changes. Any ideas why the portal does not sort. Thanks Lionel

I am attempting to build upon a classic school database which is designed to track [color:blue]STUDENTS, [color:blue]CLASSES and [color:blue]INSTRUCTORS. In this database, Classes are identified only by their unique id field and not by a discernable name convention such as "Biology 101" or "Algebra-2" for example. Thus, to enroll a student in the proper section, the user (registrar), must be able to match the following fields to each class id: [color:brown]- ClassDay - ClassTime - ClassInstructor From a UI perspective, I need to show the user a [color:blue]drop down menu lsiting ALL the possible classes, diplaying {[color:brown]ClassDay, Clas…

I have 4 portals in one layout. I need to be able to activate one of them depending on the result of some calculation. Once active, I can do the rest of processing. How do I do that in script? Thank you all

I can actually do this already. But it always defaults to the first record in the portal. The solution probably has something to do with "Go to Related Record" or a simple find. But I can't seem to get it to work. Thanks for anyone's help!

I have a portal in which I want to filter the portal items to show only the activity of the past 30 days. I know that I can use a selfjoin relationship using the creation date field, but I'm a little stuck on how to calculate the past 30 days into that. Can anyone make any suggestions? Thanks, Ron.

I notice this in FM8 as well in FM7. Here is the situation. I have one database that had a portal when I select an entry in the portal that line turns black when i click on it (which seems normal because I am selecting it). However in another database when I click on a portal in that database all of the records in the portal are highlighted the color of my background and other portals on the layout are highlighted as well. Any idea what can be causing this? Thanks Ron.

Hello! I have a file I am working on. There is more to it, but I'm stuck at this little step. The file has Employees, and regions. I have field that has region, and then based on that a portal that displays the employees of that region. Simple right.. Now I want to be able to select the employee I want, to view there equipment (equipment is not part of this problem) So I think Radio Buttons, in the portal!! The radio buttons are based on the same realtionship that the portal is based on, and has the value from the relate field for the value list. The problem is that when I select a radio buttons, I get every employee. If I use a pop up list or menu it works fine, I …

A new collection (expanding in future) of tricks & examples for portals has been published at 24U Software's web site. Currently demonstrated techniquest include: Horizontal portal (records in columns instead of rows) Matrix portal (spreadsheet-like view of related records) Please enjoy the free example(s) and feel free to e-mail me with any questions or suggestions. HOnza HorizontalPortal.zip

Hi, I'm having some problems with portals after moving from 6.0 to 7.0 (mac). File 1: customer info - has portal showing quotations and portal showing orders File 2: quotations File 3: orders When a quotation becomes an order I make a new record in file 3, import fields from file 2 and then show file 1 again. In the orders portal in file 1 the new order does not appear unless I first go to file 3, click outside of any fields (screen blinks once), then return to file 1 and refresh the entire relation. This worked flawlessly in FM6, but has the above "bug" in FM7. Relations are all intact. Am I missing something? I've tried going to …

Is there a "get" calculation that can return the current total portal rows? I need it to change dynamically as related data changes and results in different number rows. Additionally, is there a "get" that can return the current portal row? I'm hoping to create a global field with data such as: "Track 1 of 3456" that then changes when a different row is highlighted. Thanks for the help Greg

Has anyone used only portals for all list layouts in a project? Usually a table will have 2 main layouts - List and Details. The List layout shows a list of items that when one is selected it goes to a Detail layout with all the relevant fields for data entry. The list layout uses 'View as List' and can be easily sorted with scripts attached to the column headers and a total can be put in the Footer or a Trailing Summary. All straight forward... BUT, has anyone used all portals instead? What are the pros and cons? I have setup a template that has a Menu on the right side of my layouts and using portals I can have a list without using the list view so my deta…

Hi, I am fooling around with a mock client/order/invoice system and am having problems referencing some records from one table to another. I think it’s a simple problem, probably to do with an incorrect table relationship but I can’t seem to work it out ( I cant seem to find how to make a 1to1 relationship in filemaker, which is what I think I need.) This is the basic layout if anyone can comment. * = Key (auto/serial number) Basically the problem is I have a “clients” layout with a portal to “invoices” the portal displays information from the invoice table but I need it to also display a field from the orders table as well in the same por…

Hi, I have a requirement for two portals on one form, selecting a record in one portal should display the associated items in another. For example one portal should display all image categories, and the other should display the images associated with the particular category selected. Changing the selection of category from the first portal should change the result in the other. All on one form or layout. Any ideas how this can be achieved?.

I have a plant DNA database and want to show two portals side-by-side to show those DNA's that have been selected for PCR and those that haven't. My current solution uses two self-joins to the field "Select for PCR" which is either set to "Yes" or "No." The portal on the LEFT shows those records for which "Select for PCR" = "Select for PCR" between the original DNA table and the first of the self-joined tables. The portal on the RIGHT shows data where "Select for PCR" DOES NOT EQUAL "Select for PCR". In this way, if a record is set to "Yes", the portal on the left shows other that are also set to "Yes" while the portal on the right shows those that are set to "…

how can i show a search resault in a portal

Hello! I have a samll test database were I have a table Person and and a table Jobb since a person can have many jobbs I have a Person_jobb table. In that Person_jobb table I have a field that I want to show in a portal for every person. But it only takes the first value and show it on all persons in the portal See the example!! How can I make it so that it shows the stored data in the middle table for each row in a portal??? (Not just the first posts value an all rows) Many many thanxs too u that helps me!! // Jocke TEST.fp7.zip

The setup: * 2 tables, related via as simple a=b relationship (text fields on both sides) (in my case, the tables are in different files, not sure if that matters) * in table 2, have the following fields in addition to the relationship key field - Text1 (text) - Text1AsNumber (stored calc, = GetAsNumber(Text1)) - at least 1 other field * have portal to table 2 from a Table 1 layout, set to allow creation of related recs * include Text1 in the portal, plus one other non-calc field The Behavior: do the following: * go to a new row in the portal, and create a record by entering a value in Text1 * exit the record * flip over to a Table 2 la…

How might I go about telling filemaker that the portal row with the blinking cursor in it is the one I want to be selected, and thusly the one I want deleted when the 'delete portal row' button is clicked? Because right now, it doesn't matter which row I've clicked on in the portal, it always deletes the first darn row. And it's driving me crazy. : Thanks in advance. Amber

I have a portal showing records from table "A" I can create records using this portal.. Now, in table "A" there is a calculated text field basically telling us what "A" is being used for. Everything worked and all was happy until, suddenly the "Blank" record, that shows in a portal to allow creation of related records, is now doing the calculation and showing resuls for no record. What gives?! Hints? Pointers? Anything? Many thanks in advance. -jim lee

Hi all, After reviewing the forums I was not able to find the way to put my portal in the footer part of my layot to work. My layout is in list view, and the portal wont scroll down or up with out messing all its rows. Does any body know a workaround to solve this Bug? Is this a bug or FM does not consider headers and footers as places to have portals? [email protected]

I have a very simple portal for transactions - a receipt field and a payments out field. Then a "diff" field isswimply Receipts - Payments The balance is given by a summary field using runnung total of "diff" The problem is that the balance will only update when I manually click into the Bal Field and then only for that record I must me appraoching this from the wrong angle but any help would be VERY much appreciated Yjanks

I'm working on a (supposedly) simple invoicing database and I've made good progress thanks to the help I've had in this forum. I have an Invoices table and a lineitems table. I have a portal on the invoices table showing quantity, description and price from the lineitems table. In browse mode, everything is showing up in the right places. However, if I try to print or if I view in Preview mode, none of the portal rows show up. I've looked at Sliding/Printing but the items aren't checked to stop them printing. Any ideas? Regards Andrew

I'm working on a simple Invoicing database with a line items table and an Invoices table. In the line items table I have a Calculation field called "formatted_time" that formats the time spent on a job. For example, if I spend 69 minutes on a job the "formatted_time" field shows "1 hour 9 mins". This works as expected in the line items table. However, when I put a portal in the Invoice table the calculated "formatted_time" field doesn't work properly. If there is only one line item in the portal - the formatted time works as expected. But if there are two line items the "formatted_time" doesn't show properly. Each "formatted_time" field shows "1" - no matter how man…

Hello, I have several relationships where the left side is a global version of the primary key, and the right side is the prmary key itself (like gContactID = contactID). I then use a GTRR step to go to the desired record. I have a couple of questions regarding GTRR: 1) Is GTRR faster than searching on the primary key? 2) Is there any way to dynamically specify the relationship used by GTRR? I was hoping for a "Relationship Name by Calculation" option. Regards, Sean

Hi, We currently have a sku item database with all the product we sell. Each item can have 3 different sku assign to it, 11111 (is the item in it's english and french packaging), 1111101 (is the item in it's english and spanish packaging) and 1111102 (is the item in it's english packaging). I'm looking into a way to create a portal that will show all of the sku that are similar. Can anyone help? Yann

We have a portal that is not updateing right. We open a window were the data is entered, when we are finished we close the window and we come back to the portal its not updated. We have to go one post forward or backwards and then back again and then its there!! Anyone have an idea about whats causeing this?? Ragards Joakim

Hello Everyone, Thanks in advance for any help. I am trying to have a window open when you tab into a field through a portal. I have made the creation of records through portal avialable. When I tab into a certain field, I would like it to open a window with more options. I was thinking it could be done through a script or just a define button option, but can't figure out how to activate it by tabbing into field. Thanks again.

I have a portal which is sorted by a calculation field set from a global field via a script button using a Case statement. This is fine for sorting ascending but I cant figure out how to sort the portal for a text field in descending order. Number fields are ok - just use 1/(field value) But How do I get a text field to populate the sort field in descending order for a text field. Thanks

i tried to "specify button" on the first field on the portal line and set it to go to related record but it dosent work. can someone poin me in the right direction. a very good friend did this for me once but i cant even learn and undertsand how to do it from reverse enginerring what he did.

Hello there, I have 3 tables: record, style and category. The category table is many to many relationship with the foreign keys of the two others tables. How can I have a field in the record table which contain all the related style separate by a ",". For exemple: rock, pop/rock, aor. Many thanks for helping me. Dom

Hi everybody. I'm a long-time FM user, but haven't upgraded in a while. Been using FM Pro 5.5, and FM Mobile 2.0 on a Mac c OS 10.3.9 for some time, with great success. Upgraded to Mac 10.4 in May and have had nothing but nightmares! Can't sync, can't install FM Mobile conduit on my Treo 650 phone.Palm's latest desktop for Mac 4.2.1 has been recalled and is unavailable for download. Can't install the FM conduit even using the Missing Sync. HELLLLLLLLLLLP! I am a physician and had been using this system for keeping patient data with me; I feel lost without it. I'd be very grateful for anybody's assistance. Thx. PRB1 :

Hello, I have a customer table that has a few fields that are boolean - blacklisted, closed, potential. I have a filtered portal where the user can choose a customer. The portal is filtered based on a low match and a high match (like in the book (Using Filemaker 7, Special Edition). The user types in the first few letters of the customer's name and the portal filters down. The effect I want is to be able to have the user be able to click buttons for blacklisted, closed and potential. If no buttons are clicked, then the portal is initially filtered to not include customers who are blacklisted, closed or potential. If the closed button is clicked,…

Is it possible to have more than one portal thats not related in a single layout?

I have a “main” record layout and users can click on a button which calls a script to open a smaller window to make certain selections from another layout. The results of the selection are seen back on the "main" layout in a portal. I've discovered that I can edit the data in the portal - and it updates back in table - which I really don't want. Is there an easy way to prevent this? I need the users to be able to edit this data - but never from this portal. Thanks in advance, Mark

I'm brand new at Filemaker (Dev 7), coming from an MS Access/SQL Server background. My database schema contains several many-to-many relationships, represented as usual with a "relationship table". The canonical example is a student table, a class table, and a student_class table. So, given that I have a layout displaying a given student, how do I display the class information for that student, given that the info I wish to display is actually in the class table, but I have to go through the student_class table to get the recordset? Thanks in advance,

I have a single portal on my layout where one of the fields is a number field. For each line of the portal I need to show the difference between the numeric value for that record and the previous record. For example Rec Num_Value Diff 1 3 2 5 2 (i.e 5-3) 3 9 4 (i.e 9-5) 4 14 5 (i.e 14-9) 5 21 7 (21-14) etc. The difference field will show the difference between that record and the value in the previous record. I guess it must be via a calculation field but I really dont have any clue how to start Any help please Thanks

Hello filemaker veterans, Filemaker cant display the mother data for subsequent rows of portal data when ported to excel, but only the first one (portal row data). I am sure this is a bug. Try it export any portal data with multiple rows to excel and some data from the mother file - and look what happens! first row id 1 - mother data.....portal data - sweet! the rest of the rows id 1 - mother data blank - portal data visible - bad! where is my mother data? this guys is having the same problem too http://www.dbforums.com/archive/index.php/t-1175557.html

all, been reading posts here the past week (since i've started with FM7) and i've found it truly valuable. thank you! been able to accomplish most everything so far, except for this challenging requirement. thought one of you may know of a solution. i've got 3 tables -- location, group, and permissions. the location and group tables are simply lists of possible entries, and are not "user-editable". the permissions table has a primary key of loc_id + group_id, and has a 3rd column of a permission value. it will contain a cartesian product of all location+group combos, plus the corresponding permissions value for each combo. i'm trying to create a form …

Lets say there is a Company table and a Employee table. Company Table fields: CompanyID Company Name Company Address gStatus etc Employee Table fields: EmployeeID CompanyID Employee First Name Employee Last Name Status etc If I wanted to have a portal show the records of the contacts for each company, with a radio button for full-time status and part-time status, its no problem as, I can have the relationship match on CompanyID and gStatus to Status. Now the problem is that I want the user to be able to select an option to show ALL the employees regardless of the status. I tried making a match from the gStatus key to a calc…

I have a simple database of company contact information. I want to create a portal to list the firm name of all records. How do I do this?

I have two tables related, Calendar and appointments. I have records from Appointments visible in a portal in calendar. I am trying to get a script in calendar to create a new portal row and enter the fields with data from global fields in calendar. It seems to keep writing over the last portal row and not create a new row. How do you create a new portal row (record) and enter data in it? Thanks in advance..

How do I the results from the portal so I can restrict results limited only to portal records shown? I am building a greyhound racing analysis software for fun and want to limit results. EX. Main layout is Raceform, List 8 dogs in a race Dog 1 Portal pulls in his average speed from Dog Stats database. (matched by dog name) I have an inequitable relationship so the records pulled in the portal show his average speed of races run before the race date, sorted by date, most recent race first. I have 9 portal rows showing, however my field in main layout (average calc formula )averages all his past races. I want the average only to reflect his last 9 races. …

I have a situation where I would like to highlight specfic records within a portal. If a series of records within a portal has the same data within a specific field. I would like it to stand out some how. Does anyone have any ideas? An example: Let's say I have a portal with five records in it with one field per record. In the field is a food item. Let's say Record 1 has "eggs" Record 2 has "fish" Record 3 has "cake" Record 4 has "eggs" Record 5 has "Turnips" I would like to make the portal highlight eggs because that piece of data has been repeated within the portal. When I mean highlight, I am just looking for any way to highlight i…

I am constructing a fairly complex database (at least it seems that way to me!), but I have encountered a very simple yet annoying problem along the way. For the purpose of this discussion, I'll only mention the two tables involved in my problem. I have two related files, one is a "Master" file and the other is a "Slave" file. The Master contains a portal that lists all the records in the Slave file. When a field is clicked on the portal, I would like the data from a corresponding Slave field copied into a field on the Master file for searching purposes. Unfortunately, my script only copies the information from the very first record of the Slave file. It seems t…

i think this goes here...it involves portals.. if i have records with info similar to the following: apple; red apple; green apple; yellow when i setup a portal in another layout it comes in how i want: apple (title of portal) red green yellow the portal set up isn't really the problem but it the fact that that portal shows up on 3 records shown identically...i hope that makes sense