Portals

I have an estimate database with a portal of related records from a subitems database. Within that portal I want to display a field that is related to the subitems database and not the estimate database. This is like a relationship to a relationship. Is this possible, and how? Thanks, Daryl

Using a script how would i be able to change a portal in a single record, so that the data displayed will always stay the same and never change; even if the data in the related records change.

I have created some scrolling portals which function correcltly, but now I cannot get the scroll bar to appear in any new portals I try to create. The new portals function normally (ie, they scroll) but the scroll bar is not visible... all my experimenting so far has been in vain. Can anybody help please?

I've been playing around with filtering portals using the "all" option. Two tables, a one and a many (say client and invoices). In the invoices basically I create globals g_1 g_2 etc then I create calc fields that are 1_calc= If (g_1 is empty, "all", g_1) 2_calc= If (g_2 is empty, "all", g_2) etc then I create field calcs field_1=field & "¶" & "all" Then I relate 1_calc to field_1 and 2_calc to field_2 and etc Now I have a portal with all the g_n's at the top as dropdowns and by selecting or clearing fields it filters the portal by what's showing and what's not in the globals. So I can filter by date, etc.…

I'm relativly new to filemaker (about 2 months now). I'm trying to make a layout with a dozen different tables on it summarizing different aspects of someones work. I figure that portals may be the key. Is there any good reading material online to explain how to do this? All the users data I wish to summarize reaside in 3 tables, Demo, QD and Contact. Demo is related to QD via ChildID and Contact is related to Demo via Contact ID. QD and Demo have most of the data I wish to show filtered to the current month via about 12 different fields. I can be more specefic but really I'm looking for the material to guide me in doing this. I've got Special Edition Using Filemaker &a…

In a simple Invoice table/LineItems table scenario I want to prevent the entry of duplicate product IDs in a portal based on LineItems table. This is to keep the user from choosing twice the same product code on the same invoice. Ideally it would go like this: If product P313 has been entered twice in same portal, show message "You entered a product twice" I tried a few things but no luck so far. Thanks for any suggestions

Hello, I am developing a database for a non-profit spay/neuter clinic for our local humane society. We are working in FM6 because it was very affordable. Among many things, I am trying to create an appointment scheduling page that pulls information from a Client (people) database and a Patient (animal) database. I want to be able to display, add, and modify appointments showing related information from both databases with one Client/Patient per line, showing only those appointments for that date. I have a third database with Appointment dates, Client ID, and Patient ID. Clients (with unique ID) can have many Patients (with unique ID) Appointments can have …

Hi all, Can I find date range in the portal row? I try to find it but they show me all the row...any idea to do it? Thank! I create the sample file....you'll maybe take a look...thank you very much! find_date_in_portal.zip

Hi I have become stumped and believe me I tried hard to find a result but to novail. I'm doing a search and getting a result in one portal that I managed to do, but I then want to use that data, The result can be one reference number or several numbers (In one portal line) I wish to use that data on the one postal line to filter another table so it will display only the results based on the other portal line. This does not sould very clear so I have included A image and hopefull what make it totally clears as to what I'm doing a zip file and the 3x .fp7 files I'm working on, well a cut down version of them. hopefully making it clear what I'm trying to accomplis…

Is it possible to make the rows in a portal selectable, meaning click on a row to select and populate another field. My setup is a field in which you select a trade, (carpeting, painting etc.) the portal displays a list of all companies under that trade. I want to be able to have my users select the given company and have it populate to a grouping where your choices are held. Should I use another portal? and is there a way to make that row selectable? (I.E. double click the row and have your selection populate else where in another layout.)

I have a portal that links to our main DB. It will list all of the jobs in house for a specific customer. It works great. But I want it to only show jobs that have not shipped. I need to "filter" out everything whose status field ≠ shipped. Any ideas how to do this?

I have a file with 2 tables. Person and Location. I have location related to person in 2 ways. Location Y ID field - related to - Person ID field Location N ID field - related to - Person ID field So I have 2 portals in person that is for YES AND NO. The problem is that with this setup the Location can be YES and NO. Is there a way to sort this so that either: The drop down list is dynamic so that if it is contained in LOCATION Y it can't be added to LOCATION N (or for that location Y again) Or Using a unique field Any help with this would be great thanks i have attached a rough demo to show the problem. Loc1 once it is added to t…

Formatting text colour on individual rows of a portal, how would i do this.

Hello All. I'm struggling with a question that I think is probably pretty simple to resolve, but I just can't find the solution. I have a database of about 35,000 records (of student financial aid awards). Each of those records has a student ID number, the dollar amount of the award, and the type of the award (loan, grant, etc.). I would like to find the total dollar amount of each type of award for each student. In other words, I want to be able to say "Student Number 1323 had a total of $750 in loans, $300 in grants and $1000 in scholarships." How can I calculate a total according to these two criteria: student ID and award type? By the way, I …

Ok i have the following two tables. Member(Name,Country,Points,Ranking,Season ID) Seasons(Name,Comment,Season ID) I have also created a self link from season to season based on Season ID,using a second occurence/copy of the season table(Seasonscopy).I changed the relationship from '=' to 'x'(ie match all records.) I have assigned members to various seasons then created a portal to show related records from member. However the portal isnt showing any data and i dont know why, ive done this exact thing in FMP7 before and it worked fine. What went wrong

A button triggered script changes a status field in every row of a portal. The user then hits a 'submit' or 'cancel' button to commit or revert this change. Submit button works as expected. In FMP client, every update is reverted when 'cancel' is hit. In IWP, every update is commited when 'cancel' is hit. The only way to revert is to keep track of previous values and reset the fields. Is this a bug or am I doing something incorrectly?

Hi, I have a portal in one layout and I would like to add a field copied from a different layout. I have added the field to the table and relationship, but it won't work.

A user of mine swears blind that he used to Export the Records from a layout that has a portal on it, and he would end up with a tab separated file that had all the records from within the portal in it.. His end result would loook like this: main record 1 portal record 1 main record 1 portal record 2 main record 1 portal record 3 main record 1 portal record 4 main record 2 portal record 1 main record 3 portal record 1 main record 3 portal record 2 main record 3 portal record 3 Currently though, when using the Export Records menu command.. he's only getting this: main record 1 portal record 1 main record 2 por…

OK, you'll have to think way back to FMPro v.6. I have set up a database of three related files to form a basic many-to-many relationship. One file is "projects" (manufactured pieces of furniture); another is "materials" (various lots of wood and so forth that is stored in inventory and then used in those projects); the third is a "lineitems" file that ties the two together, so that: In the projects file, I can view through a portal (to lineitems) all the various materials used in that project (and the dollar value of each). From the materials file I can view through a portal (again to line items) to see in which projects various types materials were used (and how much …

I have a report where I want all members info to print out. It looks like this: Name add city st zip phone I used a phone table for the phone numbers. On the report I have a portal that displays the phone numbers where I put the word phone. My question is, since everyone has a differnent amount of numbers, is there a way to tell filemaker to only use the amount of lines necessary for that record. Currently, I have to figure out who has the most amount of numbers and make it that big. This makes the report look messy when someone has just one number. Or is there a better way to do this that I am not thinking of? Thanks Dave

I want to be able to sort columns in a portal by clicking on the headers. I have read some of the portal search threads in here and they are no help. It's just a bunch of calculations and the actual implimentation is never discussed. How does it work? Why isn't there a sort portal records script step in Filemaker? So you can select the field to sort by in the portal?

Having used Filemaker for quite some time, I am not just beginning to get into the nuts and bolts of it ... and I now have a portal question. I have a record that pertains to someone that has donated items to our golf outing. At the bottom I want to add portals so each year we can track what year someone gave something, what they gave and the value of it. I can enter information for last year and no problem. Then when I get the next line and enter in information for this year it creates a whole new record. What am I doing wrong? Thanks, Brian

:) I have a portal that is based on a 1-1 relationship and I allow the user to create records in the portal, my problem is that everytime the user clicks out of the portal and goes back in there is a new empty line/record at the top of the portal. Which means her data that displays keeps moving down further and further. How can I stop this from happening?

I've searched the forum and can't find this particular portal filtering question. I'm not sure there's a solution, but I figured I'd try. I'm trying to create a layout which will list all related records in a portal or filter them by "last name". I have included a screen shot of my current layout which is currently filtering by last name. Settng up a relationship to filter by last name is easy. So is setting up a relationship to display all records. I'm tryng to figure out a way to do both. The box next to "search by last name" is a global text field. I have a relationship from the "transaction" record (in the portal) to this global. The transaction side …

I am wondering if I am completely off base here… I have a layout for People (that is the table) and the related table is Position (Job Assignment) One person can have more than 1 active job at the same time (ie half time receptionist, half time file clerk). However this is not the norm…. So how would I set up the data entry layout for that? Would I use portals? What I had envisioned is a normal data entry layout- that the user tabs from field to field with a portal window on the bottom that holds the data the user fills in (either on a commit or dynamically). That way, if the user has to fill in 2 half time jobs for Jane Doe, then the user can see the ot…

Anyone know how to add fields to an existing portal? When one initially creates a new portal, after the Portal Setup dialogue box, we get the Add Fields box. But once the portal is set-up, I can't find a way to get back to that Add Fields box. Thanks in advance for any advice!

Hello, I want to create a portal based upon a field which combines two fields. Example: Client nr: 1000 (Unique ID) Status: 1 (Done) Combined field: 10001 (Client nr & status) Database 1 -> has the field "Combined field" Database 2 -> has the field "Combined field" Now I create the portal, but this portal only shows one record instead of all records basesed upon the field "Combined field" It is probably a indexing problem! Question: Is there a way to make my situation mentioned above work? OR (even better) Is there a way to pull once all the records based on the "combined field" into a specified field? Looki…

The attached file contains a simple example of a portal that displays information for a selected User. The problem is that I want to display results only for a range of dates contained in that User's base record (the date pair is different for each user and can be changed when needed). I've tried two different methods and both fell short of what I'm trying to achieve. Any suggestions of a straightforward method will be appreciated. Thanks in advance. RangeOfDates.fp7.ZIP

Out of curiosity, I've built a calendar (layout is in a different table). Built like this: Main Layout has 42 fields in 42 portals, each with a unique verifier. 2nd layout contiains information about each day/date and a unique verifier that links the two together. in 2nd layout, there is a relationship to an entirely different DB that pulls Sales Orders (just the order numbers) by date and lists all the SO's in a portal. Is it possible to pull that portal information into the portals? It goes like this: Calendar Day possible 1 of 42, uniqueID links to actual calendar days layed out in 365 records via uniqueID. Each record of the 365 has it's o…

Hi All, I have a database which I have some of the field which I have a script which will cut and paste into a portal, but for some reason when I try to have the next record (First_Name2) at the next row, it is not doing what I want because it is replacing the first row. Any help will be appreciated. Here is the script that I have: Go To Portal Row [select;First] Go To Field[Main::First_Name1] Cut[select; Main::First_Name1] Go To Field[Presenters::First_Name1] Paste[select; Presenters::First_Name1] Go To Portal Row[Next] Go To Field[Main::First_Name2] Cut[select; Main::First_Name2] Go To Field[Presenters::First_Name2] Paste[select; Presente…

I'm stumped on this one. My portal shows related records for some entries, but not for others. First layout lists Customers (and some details) Clicking on a button takes you to the second layout which correctly gives all the details of that customer (same table). The second layout also has a portal to show the related records from a table listing documents. It works for some customers, and not others. I've ensured that the indexed field entries are correct (they are even automatically entered !) but they don't show up. Any ideas, please ?

Dear Friend I had made relation between Detail Record (A.fm5) and Portal Record (B.fm5) and i made button that alowed user see detail record from Portal. Because of long list of record in portal, how can I display or select record from detail record. For example if I click "JASON" in portal other windows will appear to show detail of "JASON" but when I close deatil windows it doesn't go to "JASON" again but go to first row. How can I direct to "JASON" row in portal when I close detail record ? Thank for your kind attention, I do really need an answer. Cheers Ben

Hi, I've learnt that @@ can be used to track the record number in a portal. However, the same @@ in the related table will give the current record number out of the whole table, and not just the current record number of the related records. Is there a function or short cut that I can use, that will show current record number from only related records? thanks indy

I've attached an example of a problem I'm having navigating through records in a portal with scripting. The go to to "first" and "last" scripts work, but not the "next" and "previous" scripts. Any suggestions? Thank you very much Jason PortalNav.fp7.zip

I am trying to filter a portal and having problems. I have tables of contacts, donations and donation detail. In the donation detail table the line items can be broken down to an ID field that is used to related to many other tables. Some of my contacts are builders who are, of course, building houses. Each house has a unique ID. This is the same ID used in the donation detail ID field. I need to link these ID's thru a portal. I have the inital files linked by contact ID so the builders are related to any donations by them. I created a second table occurance linking just the House ID to the donation detail ID. The problem is the table will list all donati…

I have a portal that allos me to see all of our jobs that printined on a particular press on a particular day. It work great. I want to have another portal that shows me all the jobs that shipped on a particular day. Do these need to be in the same layout?

Anyone can explain why Nth record stop calculate an unstore field with the following: Case(Get ( RecordNumber )=1;GetNthRecord ( num; Get ( RecordNumber ));num+ GetNthRecord ( SumStore; Get ( RecordNumber ) - 1) ) Thank

Hi there I have a kind of "home page" on my database containing a single record, and the layout has a collection of portals showing me the status of jobs, invoices etc. at a glance. The problem is that one of them doesn't work and I can't figure out why. It's the portal showing me all unpaid invoices. Here's how it works (or in this case, doesn't) The [color:red]INVOICES table has a calculation field called [color:red]STATUS which checks if anything is entered into the [color:red]DATE PAID field, then displays the colour coded invoice status accordingly, like this: [color:brown]Case ( not IsEmpty ( Date paid ) ; TextColor ( "Paid" ; RGB (0;160;0)…

I am trying to set up portal Navigation as described by Ray Cologon. After many hours of trying to get this to work I have "Most" of the problems solved. My main problem remaining is that when I click on the portal row the GTRR does not take me to the record. There is a CF as follows: GetNthRecord (Field; StartValue ) & If(IsValid(GetNthRecord (Field; StartValue + 1)); ¶ & GetValueSet(Field; StartValue + 1)) When I tried setting this up in a script to see where the problem was I get a seven digit number for RecordNumber?? so if I change it to the proper record number it goes to the correct record in the layout. Somehow I've got this …

I'm trying to make a textfield combine the rows in a portal but don't get it to work properly. I'm working with FM6. A full description is below. Hope someone can help. I've made two simple databases to test the procedure. If it works I will implement something like it in a larger database. The databases are called 'Countries' and 'Hotels'. The database 'Countries' consists of 2 fields: - Country - Text The database 'Hotels' consists of 3 fields: - Hotel - Country - Url I've made a relationship based on the field Country in both databases. A portal in 'Countries' is showing the urls of the corresponding hotels from 'Hotels'. So far so go…

I know there is nothing holding me back from adding more than one portal on a layout. However the database that I am working with is using one record for each layout. I am not sure I am even asking the right question, but how do I get the two(or more) portals on the same layout use the same data from 1 record? I can post screen grabs if needed. I am working on the interface portion of this project while another person is working on the backend functions. To make the project much easier to use I'd like to have multiple portals on the layout, while the backend developer is have issues with this. Any thoughts?

I have multiple portals in one layout. Does anyone know how to group them (or equivalent alternative) so they can all be scrolled simultaneoulsy with one scroll bar? I need the cell contents to line up.

I have several portals arranged in a horizontal way (same relation). Each should show only one row and the first record to show is set to 1, 2, 3,... . On a Mac the result is a horizontal portal showing me all the records 1, 2, 3,... of the given relation. On windows I always get an additional record showing outside the portal bounds. In the first portal I get record 1 and record 2 as a "ghost". In the second portal I see record 2 (and 3 as "ghost"),… Is this a known bug of FM 8v2? This makes my application useless on a PC (and I tried different machines) Maybe someone can direct me to a solution? Thanks, Martin

I have a database of publications to which materials need to be sent on different dates. The main table is the list of publications; the child table is the dates on which items were sent; the matchfield is a serial number. The main table shows the publication name and address at top, with other specification fields, e.g. Fashion, Major Daily etc.). Each record in the main table contains a portal with the related records for the artist and the 3 materials that need to be sent out. Having found a set of publications, and entered the information in the first portal row on the main table, is there a way to "replace" this information in the remaining records in …

On the opening layout (Sent to Vendors) I am trying to make three fields populate through a portal by selecting a name from a popup list. Take a look at this and let me know why it won't work. Phil Bid_Application_Form_Copy.zip

Is there a way to make a portal "auto adjust" to the number of records contained in it? I've got a report that is viewed as a list and is in one table, but displaying records, via a portal, from another table. There's an obvious problem in that when I print, if the portal only has 3 rows and there are 4 records, one record does not print. I've discovered no obvious solution. Making the portal 20 rows deep would be a waste of paper, considering each portal generally only has 1-5 records (but occationally, there are 20!). Does anyone have a creative way of dealing with this? Thanks much!

I have two files - one is a 'service diary', the other is a part-catalog. I'd like to be able to display the parts in the service diary so I don't have to open the parts catalog to find the part, but I have them all listed in the service diary. I can't seem to get portal to display more than 1 item (one that is tied to a relationship) and show ALL the records in the parts catalog... can I do this? am I even making sense....

I was wondering how it works with the creation of records through a portal. I have this set up in one instance where a invoice records are created though a portal by just entering information in the fields of the portal. When I tried to do this between two different tables I could not create records through the portal. I poked around to find something like "check here to enable the creation of new records" but could not find this. When I go to the layout of the new table and create several related records and return to the related table the records do appear correctly in the portal so I know the relationship is correct. But don't know why new records can not …

I've had difficulties in the past with this, so I'm not surprised I wound up back here to get a hint. My organization sends students out to different sites to receive different types of training (TrainType). Where The TrainType is = "Nutritional Counseling" (for example), I can match up Students:studentID = TrainingSession:studentID AND TrainingSession:TrainType = k_NutritionalCounseling (k_NutritionalCounseling is just a text calculation = "Nutritional Counseling"). This is working. The problem I have is that I want to make a portal (table view) of TrainingSession that EXCLUDES students who have graduated (table_view_TS#NotGrad). The example file sho…

I have a Companies table layout that has a portal for Contacts. This portal only shows one contact at a time with the scroll bar activated to enable scrolling to more contacts. A second portal on this layout lists the last names of the contacts that are entered in the Contacts portal. I want to be able to click the last name of the contact in the 2nd portal and have it display the correct contact information in the Contacts portal. Previous methods for going to a specific portal row from another portal on the same layout no longer work in FM8. I am referring to having a unique field in the first portal and using the Go to Field script step to get from the second…

I have searched and tried all the things that make sense and know the solution will be easy ... but alas it eludes this beginner. In a portal I want a button that takes record data from the parent and inserts into that portal row. Kind of a 'same as' option when user is entering data. I have the button working but only on the first portal line, regardless which row the button is. I know I need to somehow check which portal line (get portal row) I am on, then do the work on that line but I don't know how to get that data into my script ... how do I do this? Thank you in advance for your patience.

I have a strange problem. I have a series of fields that are calculated results via a case statement for a field called trans_descrip. Well it turns out there was some odd data in trans_descrip that was throwing off the case evaluation, so I cleaned up trans_descrip using a series of evaluations and replacements. Now, all for all the trans_descrips I replaced the calculated fields will not re-evaluate. If I go into each of those trans_descrip fields and add a space or delete and re-add the last character the calc fields re-evaluate. Very puzzling to me. Interestingly, when I created a new set of calc fields, and pasted in the exact case statements f…

Heads up folks. Recently I did some work in FM7. Basically I had scripted entry in to the fields in a portal to allow editing of existing data but prevent new records to be entered at the bottom of the portal. (New entries were handled in a different way to ensure data integrity and the relationship had to support creation in the related table) The script tested the current row against the LAST value for the relationship to allow/disallow editing. Then I ran it in FM8... Each time I clicked on the fields the script would exit against the test. I discovered that FM8 does not get the current portal row number until a field had been selected, whereas prev…

I've done it before, but a couple years ago when I was learning FMP on my own. I've forgotten and the supplied text and help menus don't help me. To give me a good starting point, will someone first explain why we use portals/benefits of portals and how to make it. Basically how I would get started with the records in a portal. Please I need help as I am trying to figure out the simplest way to save some records.

Hi all, I am desperately trying to get the items in a portal sorted properly but has so far failed utterly. I am trying to keep track of a number of images that are used in a number of documents, and therefore I use a Documents layout containing a portal showing the names of the images that are related to each document. And I would like to have this list sorted alphabetically. Each image can be used in several documents, so I am using a "link" table that connects the (unique) document ID with the (unique) image ID. Thus, my database consists of three tables: - one for documents - one for images - the link table that connects the document with the im…

Hi, Please excuse my lack of ability! I have a "bookings" portal on the main "patients" page and i wish to do a find on this portal to look for any bookings that have not been invoiced, but only those relevant to that patient. I can make this happen in a separate layout no problem (try the show uninvoiced bookings on bookings layout script) but can't work out how to do this within the "bookings" portal on the "patients" layout. I've tried a few different ways but can't ssem to make it happen. Any pointers or a proper solution would be very greatfully received. Thank you Patient_6.fp7.zip

I have a portal set up to track multiple presentation sessions by individual speakers (each record contains one speaker with the related presentations in a portal). What I need is to combine the session names from multiple portal rows into one field for printing purposes. Each portal row contains 11 separate fields, but I just need information from one of the fields combined. How would one go about this? Thanks in advance for any help provided.

Hopefully some more experienced users can show me the way here... Basically, my file has 3 tables: events, stock and hires. The 'hires' table contains records which link stock items to events, i.e. each record has a stockID and an eventID field. Relating eventID between the 'events' and 'hires' file allows me quite happily to show all the items from stock associated with the event in a portal. Fine. However, I want to have a seperate portal on the same layout which shows ALL items from stock, but with a marker in each row indicating the status of each item, relative to the event record currently being browsed - in other words, indicate which stock items are avai…

Hello, I have 2 new fields in an invoicing table that have been defined. I have an invoicing portal in my main layout, and I would like to add these two new fields to the portal, so that it doesn't mess up the existing portal setup. The only thing I can find that seems close is in the "Format -> Portal..." dialogue window. But, this only gives me the "sort fields" option, which I'm afraid to do, because I don't really want to sort anything....just add these two fields is all. Any help would be appreciated. Thanks. Nick

Hi, I can't seem to be able to have a portal within a tab where the layout is based on table occurrence 'widgets' and the portal is also based on 'widgets'. Layout Setup Show Records from 'widgets' Portal Setup Show related records from 'widgets' When I try to setup the records which are related to widgets, widgets is greyed out. Leads to to believe this is not possible. Help/advice would be much appreciated

Hi all, In the 1 record I have 10 portal lines, what I need is when I just click check box field (click about 5 portal only) and they only copy the 5 portal I'm click to the new record. Can this be done? I was think this solution about 2 weeks, hope anyone can help! Thank!

I've inherited a wonderfully complicated database that I'm trying to patch. I have some summary fields for the entire Breeding table that are supposed to display in Colony. Due to the sort order for some other content on the layout, the first record in Colony does not have a matching record in Breeding. As a result, the summary fields for Breeding are blank. How do I setup my layout so that the summary fields are not blank? Or is it even possible...?

Hi, I currently have a portal that is pulling sample text from other records. Unfortunately, the number of records it pulls from and the amount of text it needs to show varies. This results in the sample text being cut off, or not show in the size portal I have. When printing these reports, there's lots of empty space to account for all the variations. I thought a solution would be to have a field pull all the contents of the portal into one text field that I could then set to slide. I assume it's like a calc field, but don't know how to properly write the script to achieve this. Any help would be greatly appreciated. Thanks! -wing

Hello, How do I get a portal calculation to work. I need to get a sum from a field in a portal and place that number in a field outside of the portal. Any help would be great. Thanks

Hello all I'm trying to imitate the replace function in a portal. I used to have a pop-up menu so everybody is used to just choose a value and replace it in the current found set. Now that field is a portal, because I need it to hold more than one value. How would I set a selected list of records to one specific value in a portal? The problem is, that maybe some of the records already have that value. The script should just add the value to those records that don't have it yet. If you have an idea, please let me know.

I have a text field that I have set up so that the user chooses a color and then the text field changes to that color. It all works great on the screen, but when I choose print, nothing shows up. Any ideas?

Iâ��m not really sure if this is portal problem or a relationship problem â�� imho I think itâ��s a little of both. So please forgive if Iâ��ve posted in the wrong forum. Iâ��m trying to create a bidding system that will allow me to create proposals on the fly. So far Iâ��ve got five DBs: clients, vendors, product categories, products, bid builder. I am using the client db as the main interface for contact info and for generating proposals. The bid builder db is the conduit for pulling all the proposal info together. The problem Iâ��m having is getting the bid builder to show up properly via a portal. I need to be able to keep multiple revisions of individ…

I am using FMP Advanced 8 v 2. I created a company database, and included a purchase order function. The purchase order page has a portal to a purchase order items table. We imported our list of items from quickbooks, since we are now using the filemaker database. However, a number of the quickbooks items have descriptions which are too long for the portal window. I wish the program would text wrap, but it appears it won't. If I make the field big enough to fit all the text, then all the fields become the same size in the portal, and it becomes too large to print. I have tried using merges, but that doesn't automatically resize the size of the portal row. I tried d…

I am printing a 4 page newsletter, updating it monthly. I am using 4 layouts to create the look I need. I want to place it in a PDF. Currently all I get is a PDF per layout. Is there any way that I can get all 4 layouts into one PDF? Ideas?

I want to include a "Delete" button in each row of a portal (easy enough) but I don't want the button to appear in the empty row at the bottom (the one that's there for data input). I've found the 'visibility' techniques mentioned elsewhere, but I don't know how to apply it to a portal row object. Any hints would be appreciated! Chap

Forgive me, I haven't been under the hood since version 6. I've a database of crew members, say three fields, type (clients, staff, or contract) Positions (what possition will they hold as a client, staff or contract person) and name. I want to be able to create a list of everyone associated with a particular job in a portal. The first drop box is easy, list the values in the type field of the Crew table. What I haven't figured out is how to limit the options presented in the next drop box to list only positions appropriate to the selection made in the first drop box. Then the 3rd will present only people who are say contract / Assistants or Contract /…

Hi there, maybe someone can assist me to let me know what I am doing wrong here? --- I created a portal based on a relationship which allows me to create records. Creating the records is working easy enough when I enter the data so part 1 is a'ok. --- my PROBLEM is that a new blank record in the related table is created everytime I enter data, meaning I will end up with hundreds of blank records if it keeps going this way. a simple explanation of my file structure is this: file #1 - events file #2 - guests invited to events Its a simple one/many relationship, with the portal looking at the guests from the events file. The relationship is defined by ev…

I have a 1-row portal on a green tab control. When I click anywhere in it, outside the actual fields, the whole portal goes a disgusting purple. Any ideas on how to stop this?

I am trying to build a building space tracking system. My eventual goal is to have a view that shows all the active leases for 2 buildings per month. The attached file will open to a layout that has 2 portals.. one which shows the leases related to the "date" field. and the 2nd portal is meant to show the leases related to the "date_plus_one_month" field. The 2nd portal is not working.. could someone tell me why ? Also... in general, if anyone can comment on the way i'm approaching this problem, I'd love to hear any feedback anyone has for me. I'd eventually like to show not only the booked leases per date, but also a numerical count of the offi…

I am currently trying to adapt the Registrations template that comes built into Filemaker 7. I would like to add a payment piece to it to track multiple payments specific to the contact and to the event. So I would like the payments to show up in the registrations portal and the events portal. To print payment reports for each individual contact and each event. I understand linking and portals and relationships but am having a hard time figuring out the relationship already built into this template. Could anyone guide me through the best way to set this up? I appreciate your time and help very much!!! -Melody

I'm developing an employee training registration file. I have a portal listing all [color:blue]classes selected by an employee, and a portal listing all [color:red]available classes. My question: How do I remove the [color:blue]classes already selected from the [color:red]available classes portal. After all you can not register for a class that you have already registered for, so I do want them to be able to see it in the available classes portal.

Hi, I've just separated data in my files, from *all* info in Contacts to 'most' info in Contacts and 'some' info in Company addresses. It seemed like a good idea to have a separate company table, so that any change in a company's details is easily replicated across all associated Contacts. However ... as it happens I *only* use Portals to view my records and now I find that some of my portal/sorting/finding methods have fallen apart, because now I have some of the info required for the relationship in one table and other info in a different table. Question : Is it possible (I think it is, but I'm having trouble grasping it) to have a single Portal (Rel…

Attached is an example of "floating text" in portals that occurs on my layouts whenever an individual field contains multiple lines. I've tried various combinations of Format > Align Text and the paragraph line spacing parameters -- and have even tried different fonts. The solution I came up with is less than optimal since it spaces the text out vertically whenever the field is selected. I would prefer it to stay in its compact form (of single-spaced lines). Any suggestions of a better solution will be appreciated. TextProblem.fp7.ZIP

hi all. i have a portal where each row contains several fields for a given year. how would i show the year in the portal so that it is already populated when a user creates a record. For instance the portal would look like this before a user enters any data into the portal: |_1998___|_________|_________| |_1999___|_________|_________| I hope that makes sense. Basically i want to do a similar thing with date that "@@" does with portal row number. Thanks. any help is appreciated

I am using 8Pro Advanced and trying to send emails that would contain data from portal records. When writing the email script all non-portal fields are going into the email body just perfectly - but, of course, getting all portal records is not. Only the first or last portal record is coming out. how do I get all portal records into that email body? (FYI: has to go into body as text since it will be read by text messagers and a PDF , for example, will not work.) Thanks. Paul

Hi, Somewhat new to FM, but have been doing relational database stuff for years. I've got one table, "people" w/PK peopleID, and related table "people new clients referred", with a FK field 'peopleID'. Allow new records is checked in the relationship definition, but when the layout is used, the portal will only allow one record. Clicking on the second row only hihglights the entire row, but won't allow me to enter data in the 2nd record! Anyone seen this behavior? There are two screenshots attached - one of the relationships view, and one of the portal showing the 2nd row highlighted. Thanks! Matt

Hi everyone When I push a button within a portal is it possible by script to test if I am on the last row where the 'new' related records are entered TIA Phil

I once saw a post that explained how to create a top row portal entry solutions. I can't find it anymore. Anyone know where or have an example or explanation.

The following issue has me stumped: I'd like to design a comments feature which has a field for entering the text of the comment on one side of the page, with a portal on the other side of the page which displays all of the comments associated with a record (with no blank row for entry). Here's how I envision it working - after the user types a comment into the "commentsEntry" field and clicks the submit button, the "commentsEntry" field is cleared and the comment is posted in the portal. The portal is not editable. I'm thinking I need two tables - one for the entry field and another for the portal (where commentsDescription in table 2 is a lookup value …

I have a customer and I have a portal showing the contacts associated with the customer. The portal works on a relationship based on customer id. The portal is scrollable as there are many contacts. The relationship is set to allow creation of new contacts in the portal. Everthing fine so far. I have a 'use' button in each portal row. The purpose of this button is to set a field in the main record with the contact name from the portal. That is not a problem as long as the contact exists. A simple Setfield(main::contact;portal::contactname) does the trick. I hit problems however if the contact is a new one. If I do not leave the…

I'm listing Expense detail table in a portal and the Check Table, as a list, in the list layout. When a check is choosen, in list table, the detail of the expenses shows in the portal. Works well unless the portal needs to be scrolled. When scrolled the detail become corrupted. FMPro 7 Developer Steve

Hi - I have timesheet history table which stores hours, by staff position (eg: Coordinator, Manager, etc.) againts Projects. Each record also stores the Project ID along with other information. There are multiple records for each project. My problem is that I want to have a portal in my Project table which shows the position and total hours from the history file (I think through a combined Project ID_Position ID relationship). I can get the subtotals for hours to work but how do I limit the # of times a Position appears in a portal. The Coordinator may have 10 records with a total of 50 hours recorded. I want only one line to appear in the portal for each …

Hello...I want to avoid my portal showing the line for the next record that has not yet been created. My search in the forum shows that not allowing creation of records via the portal relationship will do that but that I need to create the new portal records with a script. How do I do that? If I have my script go to the line items layout and create a new record, it won't be related to my Order record.

Hi, I've built a new system based entirely on relationships so I'm never actually working directly on a record ... it's always via relationships. I've come across what is probably a design problem ... and I'm far far down the road with my files, so HELP! I have a Contacts file in which I view lists on the right side of my monitor via a Portal (I have about 6 portals, 1 each in a Tabbed window) then on the left side, I have fields based on a different relationship from the portals and I use a global 'setField' (set by a script on the portal row) so that I see the data on the left, related to the portal row on the right when I click on the portal row. This work…

Hi, I'd like to create a field that can show data from other fields from other records. The other records are all in the same file. But, I'd like it to be contigent on a series of matching data. So, "record 1" has "field A" and it should show data from "record 2, field X, field Y, field Z" on one line and "record 3, field X, field Y, field Z" on the next line. I've been able to achieve this using a portal and setting up a relationship with the file to itself. But, I'd like to have "record 1" only do this if "record 1, field M, and field N" matches "record 2, field M, and field N". Hope this makes sense, and any suggestions would be greatly appreciated…

Is there any way to reference the previous record in a calculation? I need to compare the text in one field to the text in the same field in the previous record where the order of records changes with each new find and sort. I've been doing it by running a script to bring the previous value forward and comparing that way, but I'm guessing there's a simpler solution. Thanks for any help.

Hello, I want a portal that shows our most recent 5 orders. The problem is, it takes forever to sort all 20,000 orders by the sort criteria I have on the portal. My portal only shows five rows and doesn't have a scroll bar... any faster way to do this? Thanks, Andrew Sorry if this has been covered before -- I didn't see it anywhere.

I am having difficulty wrapping my head around a script that will sort a portal in my document. Basically I would like to create button for each one of the column headers above my portal so that it will sort like Table View. I understand that this is done by telling the portal to sort by a special field that is recalculated by the script, but I'm not sure how to set up the script to change that field for each record. Can someone show me an example of how this is done? Also, can it be done using one script and different parameters, or do I need a new script for every single button? Thanks. Ethan

Again, I am familiar with Access and new to FileMaker. In Access, I would want to make a Form, and add it as a Sub-form to another form and do it iteratively. So for example I could create a form where I could enter a country, a sub-form to enter counties in that country, which would have a sub-form for the towns in that county. I know that FileMaker uses portals, but don't see how I could create a portal, from another layout (which would allow me to do as I've described above).

In a portal, I want to add a field that displays the row number. I tried Get(PortalRowNumber), but it displays the selected row, and not the row number. What fuction shall I use ?

How do I write a calculation to be used in the script step "Go to Portal Row (By calculation)" that would take me to the portal row with the highest ID number? My portal is sorted by a text field (Company), so when I add a new portal row, depending on the name of the new company, the new portal row may be row #2 or #5 or...you get the idea (meaning I can't have the script go to the first, last or next row. It must be a calculation). Since the ID#'s are generated automatically and are unique, I need to find a way, via calculation, of going to the portal row with the highest ID#, which would be the new one just added. Thanks for any help!

Hello, I have a database that tracks items on an invoice using a portal. I can total charges on the invoice using a Sum ( store::price ) calculation. How can I calculate total charges for a subcategory of charges? I want to do something like: if (category == "taxable") Sum ( store::price ) That might work in Python or C, but I'm not sure how to do it in Filemaker. Any ideas? Brandon

Question for the gallery: I have an inventory system in which i have a list of materials. These materials can be run through production but if all the m aterial is not fully produced we return that material to stock and capture the reason. The return to stock information is stored in another related table. As so i have an interface from the inventory perspective looking into a return to stock portal. my problem is with a calcualtion for the new weight. which is the origonal weight minus the used weight. I want to be able to designate the last available new weight a different color. i have tried to relate the rts info to itself to no avail and then also t…

Hi - I have a timesheet data entry screen where I'm using a portal to a timesheet history file. In the portal I have a value list where I want to show the Client ID and Client Name. I'm using the option of showing the second value only showing (easier on the users) and it works great - populates the Client ID and then captures Client Name. The problem I'm having is that I would prefer not to have the Client ID stay showing. I want to the Client Name to appear in that area. I've tried making the Client ID transparent and laying the Client Name field over the top but I keep getting both images when in browse mode. I could just make the value list based on Client Name …

Hi If some one could help me with this.. What I wanting to do is add record directly into the portal. Is this posable? Please see attached FHP file for the layout view with portal - this where I am wanting to add record directly into Kind regards hacky print_specs_Clone.fp7.zip