Portals

I'm trying to use portals in a FileMaker 'GO' application but the vertical scroll bar is too narrow. Is there an easy way to expand this width so a finger scroll will work. Any help is appreciated.

I'm not sure if this is best handled by a portal, or other means, but I'll describe what I have and want to do... I have a one to many relationship between two tables. The "many" relationship is a list of options... so to be really simple we'll say I have 3 related records giving different color options... Red. Blue Yellow Now, instead of having them listed in three different portal rows, I would like them concatenated to read: "Red OR Blue OR Yellow" These color options are really simplified, for the example, they could be full sentences. In MySQL, the equivalent would be GROUP_CONCAT... Any advice would be appreciated Thanks!

FM 11 ADV OSX My portal has the fields: DATE -----PAIDYEAR-----DONATION----DUES-------ASSESSMENT When a user enters the date, my system automatically puts the associated Dues and Assessment according to their membership type: (ie Life, Yearly etc) No problem here, this works. And, I can do an ONEXIT or ONSAVE script on the PAIDYEAR field to get the table to 'resort'. This works. BUT, the problem is that sometimes, after the PAIDYEAR is entered, the user wants to move to the DONATION field. This triggers the script which resorts the table. In this circumstance the user must 'visually search' for the year to go across to find the correct DONATION fi…

I am using FM 11 03 So, I am developing this kind of complicated application and for no reason, FM 11 starts acting like FM 10. Specifically, I create a table. I related it. I drag a portal under the appropriate TAB and.... The fields do not show outside of edit mode. So, I copy and paste the fields. No way. So, I drag the fields to the desk top and drag back. Nope. I delete the portal, create a new one, specify the fields and can SEE them in edit... no show in browse. THEY ARE ALL WITHIN THE CONFINES OF THE TOP PORTAL ROW... NO SHOW IN BROWSE !!!! If I knew what the 'trick is' (too bad there IS a trick... listening FM?), I've forgotten it. …

Howdy all, I have a table that displays related information via a portal. I have a need to look at all the text values in the related records, add them all together and then parse out the duplicate values. Example: Portal record 1 Driver 2 Loader 3 Loader 4 Supervisor 5 Loader Parent record Somehow add all the values from portal records into a field = Driver, Loader, Loader, Supervisor, Loader Then parse out the duplicates so that the field in the parent record = Driver, Loader, Supervisor Any help is greatly appreciated. Thanks in advance!

Hi there, I am a teacher in Richmond that is trying to design a database to improve the efficiency with which I can complete my report cards and I have been tinkering around with filemaker (after moving away from apple numbers) trying to streamline my process. Currently I have a "students" table that is joined to "Assignments" table through a "grades" table. I give the student a grade for a particular assignment and that creates a record in the grades table and based on the grade each student is assigned a comment for their report card. On the "students" layout I have a filtered Portal that shows the related records for each student for each subject. …

A GTRR step using the portal relationship gives the unfiltered portal results - I want to be able to select the filtered set - is there a way of establishing the set of records that are being displayed so I can process these in isolation? Thanks Brian

I have several Portals set up to record specific Product pieces of data. All the portals are unique to each record except the first one. Portal 1. Product Name: Notes/Data sheets/Documents Portal 2. Product Reference/Order Numbers/Prices Portal 3. Product Images Portal 4. Product Monthly Sales sheet All four Portals will relate to one Product per record as if that were my Topic/subject. The first portal will not change from record to record unless a different product is entered. For instance if I name that Product : PTP1B, I want the 1st Portal to save and remember everything I have entered underneath it in the notes or documents sections so that if I ever cr…

Hi there, i am trying to figure this out...i almost get it, but not quite. I have supplied a file along with this. What I am trying to do is when I enter a new record via the Control sheets, I want to see the list of products show up in the portal. We use the same products for the most part...on some days the products change by 2 or three different ones. As well by the session. I need to when creating a new record after selecting the session, have it show the correct products relating to that session along with their prices. In the portal, i have to enter the returns, extras, etc. and have the total on each line...stuff i can do. I just can't figure out the relati…

Hi All, I want to be able to get the number of portal rows in a record (essentially count the number of records in the related table for one given record). My setup is as follows. I have a layout pulling records from a table called patients, with the patient's details. There is a portal in this layout, pulling data from a related record called visits, which holds the patient's visits so far. I want to be able to put a count of the number of visits on the layout. I tried various things, but I get the total number of records in the visits table, not the ones related to the particular patient Any help would be appreciated. George

I was wondering if anyone has had a chance to test FM11's portal filtering with large databases that are hosted FM server. I have a solution that has 500k+ songs that are categorized. I've used portal filtering in previous versions using plugins and as well as not. I've used keywords as well as song title and lyric to filter on. Before I adopt FM11's portal filtering, I wanted to gauge my expectations. Would love to hear about anyone else's experience. Thanks! Michael

Hello Everyone, This is my first posting and I need help. I think there is probably a simple explanation for my problem. Here goes... I am making a database for an entertainment agency. I have 4 main tables ( Customers, Talent, Talent_lines, Jobs) Relationships : Customers > jobs (1 to Many) Jobs > Talent_lines (1 to Many) this is a join table as a single job can use many artists. Talent > Talent_lines (1 to many) The Problem. Most things are going well.. I have a portal in Jobs (form layout) showing the talent that is booked for the job. I am trying to print a contract for each artist(talent). When I originally set up…

Dear friends, I just very new in File Maker. Recently, i created a database contains bio data of students in our schools. It was around 6000 entry/student in the records. NOw, i got desperate when i need to count how many such as: male/female students, students with theirs tribes, and religion. For example: in my "Religion" field table contains entry: Islam, Buddha, Christian, Animist. How could i summarize how many are Islam, Buddha, Christian, Animist, etc. Thanks in advance for your kindness Yonal

Hello! I think I missed something. It should be simple. I've got 2 tables that are related. In the 1-st table -- Items, in the 2-nd one -- Parameters of Item with Amounts and DatesOfChange. I placed a portal into list-view layout to show Items with related Parameters (Amount) and filtered the portal by the Parameter's latest date of change. I need to calculate the sum of all filtered Amounts in the portal. I added a field in parent table with =sum(Amount) -- it shows the sum of all Amounts of all Parameters of the Item. Not filtered ones. I placed another portal with just one Total Summary field from child table and sorted it like the 1-st portal…

Is it possible to have FMP preferences or parameters being set to use VLC instead of QuickTime ? Best regards! Daniel

I am not sure where this goes so my apologies if it's in the wrong sub forum. Some background information: I am trying to create a runtime solution that should work on a Windows 2000 OS. I do not have access to older versions of FileMaker so I am using FMProAdvanced11 to edit a runtime solution (the .usr file) that was created in FMPro8.5; i know it sounds weird, but doing this ensures that the runtime will work in Windows 2000. Main Problem: My database has a Company Table with a field called LastUpdated. LastUpdated is a date field that is automatically updated with the latest modification date. I'm trying to create a layout that will show companies that…

We need to allow an operator to change the order in which related records appear in a portal. My thought is to have a 'Sort' field which would just be a number field and the portal would be set to sort to that field. Then we would have Up/Down buttons on each portal row which would trigger a script that would move the record up or down in the sort order by adjusting the number in sort field. I'm having a devilish time writing the script that would handle this. Can anyone help?

I'm using a portal to show images and prices of items that appear on a web page. Currently, one row per record, that scrolls endlessly. 1 2 3... I would like to show 4 items on each portal row, to approximate the layout on the web page, and be able to edit specific fields from the record being shown. 1 2 3 4 5 6 7 8 9 10 11 12... How can I set the portal to show an item + the next three items, and then skip to the 5th record for the next row? Even if a specific solution doesn't exist, I would like to just know the terminology I should be searching. So far nothing I've searched that I thought would be the correct term…

Hi All, I have a layout that holds 2 portal, which are both based on the same table. The portal on the left holds one record (actually a note for a staff member) and the portal on the right shows a list of the notes with a description and the author of the note along with created and modified date. There may be several hundred notes and what I want to acheive is the user scrolls through the records in the right hand portal and once they get to the note they want to view they click a button that I have placed on each row on the right hand portal so that the note in the left hand portal jumps to that portal row but I cannot figure how to write a script to go to th…

I've created an email template using as an example: "Dear" & (Space) "name" & field 1 & field 2 etc. I want to add the records from a portal which shows the data from a related table. For example, portal data shows for a specific record field 3 = Jackson, field 3 = Redding, field 3 = Wonder. How do I get these into the template above? The output from the template might look like this: Dear John, Re CDs {field 1} Please find a list of the CDs I am able to offer (3){field 3} in all. They are: Jackson, Redding and Wonder. etc Many thanks.

One of the graphical issues I find myself burning hours chasing my tail on is how Portals and the fields within them behave appearance-wise when you click into them Right now I have a simple situation where I have a 1-record portal holding a single text field. The portal is filetered so that it displays the data corresponding to the active row in a 10-row portal to its left. Works fine, function-wise. I have the filterd portal set to "Fill" with the same color as the layout background, and I have "Line" set to none, so that the portal will be basically invisible, and the single field inside of it has a white fill and a 1-pt Line , so in browse mode it just loo…

I have an order tracking file. each order has any number of line items in the order. When i update the status of each line item they show the status of the item in any portal that diplays that line item, Either orderered packaaged billed or delivered. Is there a way to make the order itself show a status that represents the status' of all its line items together. So for example if an order has three line items and all their status' are set to packaged, the order istelf in the order portal will automatically display a status of packaged. Thanks Erik

i have one table quotation with portal in which item code is coming from product table,i want to copy all data from quotation along with portal records in to sell layout. thanks in advance

I'm trying to develop a portal that will display all items that match a value in a global field. The trick is that I want the portal to dynamically filter the displayed information based on the global value as it is being typed into the global field. The best example I can think of is to visit the Extron.com web site. On their home page in the upper right corner is a 'search' field. As you type in data [i.e. 70-684-01], you'll see the displayed values continually grow smaller as you enter more specific information. Any suggestions would be appreciated.

I have two tables in my database, which share information, (or should) In table 1 i have people and they are all assigned an ID. In Table 2 i have projects that are defined by an ID as well. In Table one i have the Person ID in Table two i have the project ID as well as the producer ID. The producer ID co-insides with the Person ID (its the same) I Need to figure out how to script to pull All of the projects Listed with Producer ID XX I have a tabular page built so far that has person on 1 and projects on two with several more tabs. so when i select a person in the first tab i want to be able to tab to the projects page and then see their projec…

I have a database that I am using for a coffee ordering solution. I can go to a customers profile and through a portal create a new order for a specific amount of coffee by weight and bags. I want to be able to see how much I have to make without having to go to each customers order profile and add the order amounts together. So for example I want to be able to click on a button and it takes me to a portal and shows me how much i need to make by automatically adding all the orders together and displaying them in like 5 pound increments. So if i have order from like 11 people totaling 10 pounds of coffee I want something to tell me to make to 5 pound batches, and then once…

Hi everyone, I am trying to figure out if there is a way to change the initial row of a portal through a script. I found the following post, which seems to indicate it is not possible: http://fmforums.com/forum/topic/31297-change-initial-row-via-script/ However, that post is from 2005 so I'm hoping maybe there is a solution now! If you have any suggestions I would appreciate it, Thanks rori

I ma trying to create a database that will manage shippings and orders and invoices. Does anyone know of any solution I could use as an example? Thanks! Erik

Hi all, I think that I am making a task harder than it needs to be. From my "Home" table I have a portal of related "External Companies". These "External Companies" have a related "Address" table for entering multiple addresses. From the "Home" table I want to filter (via temp field in "Home" table) the "External Companies" by fields in the related "address" table. For example, from the home table I would like to filter the portal of "External Companies" by a city name. My first thought was to add a calc field in "External Companies" to get List() based on related "Address" table and then filter by this. The problem is that the filter does not work unless all rela…

Hi all, I am new in FM. I has a 1 portals problem. How I can copy data portals to others portals. I check your sample files from forum, and I follow the way. Is fails. hope can anybody to help me? I already zip the file. The filename is C-File. Hope all of you can helps. Thanks

Hello Filemakers! I am trying to create a portal from pictures table to inventory table that contains only one switchable image (through a joint table - because some parts are going to use same picture, this way I will save memory). The problem is, portals don't work quiet the same with pictures and need some scripting I have no idea how to do... So I want a portal from the images table that has only one image at a time in it and next/previous/insert/export buttons below it, also below the picture portal I want to have a other portal to the image table, that would contain picture number and path to the image. This table also would have only one value at a tim…

HI I had created 3 table call invoice, statement and credit. Here i need to create a monthly statement for my invoice. In my statement we have date, invoice no, debit, Credit and Balance. Date.................... Invoice No...........Debit.............Credit............. Balance 12/29/2010............0001................... 120....................................... 120 12/29/2010............0004....................400........................................520 12/29/2010............0006....................320........................................840 12/29/2010..........CN0001....................................120......................720 My…

I'm having a little trouble with filtering a portal on a self-join. My relationship is a cartesian between VIEWER_vwr::ID and CalculationsFL::name (though, with a cartesian join, I'm not really sure it matters, as long as both fields are indexed) and my filter is as follows: If ( not IsEmpty ( VIEWER_vwr::filter_g[2] ) ; PatternCount ( VIEWER_vwr::filter_g[2] ; CalculationsFL::name ) ; 1 ) The portal shows all the records, but as soon as I type something into the global filter, the portal displays nothing. The global filter on the layout, by the way, is the second repetition. Any ideas what I am missing? Thanks.

Hi, All I' trying to implement a solution that manages Insurance Contracts that are considered as Proposition at a first stage. The number of insurances choice is 6. Every unique choice generates a proposition that will be sent to the client for approval. Now , I have a portal showing the Insurances id and Name in a drop down list of the 6 choices. What I would like is : Once a choice is made, not to be able to add a second choice or modify the choice, that was entered in the Portal, in the first place. Can some one please help me out with a detailed description of what has to be done? Thanks in advance and Happy Holidays. Nikos

Hi guys, I have created a CRM in which I have implemented a portal to add a checklist for things that need to be done for each customer. I have a Customers table, and an Actions table, which are related via the Customer ID field. In the Actions table I have fields: Action ID (serial), Customer ID, Description and Completed. The Completed field I have set as a checkbox to say 'Completed'. I want to be able to filter this portal to show 3 different options: All, Uncompleted and Completed. I've been messing around for quite a while and have no idea! Any help would be very much appreciated. Cheers!

Is there any way to list the values of a field in a filtered portal? Im filtering a portal with an unstored calculation field so I can't get my result via a relationship otherwise I would just use the list() function.

Friends, I'm new to FM and I have searched like mad, but it's hard when you don't really know what to search on. I have a table called 'ingredients'. There fields 'ingredientName', 'purchaseQty', 'purchaseAmt', and 'costUnit' (and about 10 more) I am trying to find a way to have a screen that would list all the values from the 'ingredientname' in something that looks like a portal with a vertical scrollbar, and when an ingredient is selected, the other fields would populate to the right. I'm ok with clicking a button next to the ingredient name. This way a user could scroll through the list of ingredients, select one (click name or button) and then the…

Ok, I've tried to create the relationship that allows data to be entered via a relationship from my BASIC PO INFORMATION table to my APPROVALS table, I created a key id in each table and matched them up and nothing seems to be working, PLEASE HELP. I have attached a clone copy of my database. Username: clone PW: clone I can't seem to attach an fp7 file? How is that possible. Please let me know or I will email the clone directly.

Hi, I have a filtered portal which may return a very large number of records, i.e. over 1000. I'm wondering if it is possible to limit the portal to only contain the first 100 or so? Any ideas are appreciated, thanks rori

Hi. I have an issue where I have a portal with alternative line fill shading (two different greys), and that portal sits on top of a tab control, withing a tab control - also different shades of grey. The screen background color is a very dark blue. In the portal, where fields are set as transparent, the field changes to the screen background color when being edited. I would have thought that the color in the field would be taken from the grey tab control immediately behind it. Why is it going "all the way back"? I cant set the field's background color to grey as I have the alternative line fill option set. Can anybody please tell me the "rules" behind fields …

I've got a hopefully easy to solve problem. As soon as a record is marked as closed (by entering a value in a field) I want to prevent the creation of new records in the postal. What would be a easy solution to this issue? Cheers

My Setup: Orders layout based on Orders table. Portal on orders layout based on OrderLines table. OrderLines table stores fields: OrderLineID, ItemID, Price. Item table stores fields: ItemID, ItemName. If each orderline in the portal displays only the OrderLineID and the ItemID (both fields in the orderlines table). This works well and is fast. Since I want to display the ItemName instead of the ItemID, I am using a pop-up menu style control with a value list based on the Item table. The value list is set to use values from the Item table with ItemID as the first field and also display values from a second field, but only show values from the second field. Th…

I have an Orders Table and a Suppliers Table. Each supplier has a distinct number, so that when I enter the number on the Orders Layout, it uses a Lookup to populate the fields with the supplier's name, address, etc. When I can't remember the supplier's number I have to switch to the Suppliers Table and look up the number, then switch back to the Orders Layout and enter it. I'm not sure that I fully understand the function of a Portal, but can a Portal be added to the Orders Table that allows me to scroll down a list of supplier's numbers and names without switching back and forth? I've been experimenting and tried to add one, but only the first row in the Portal had…

Hello once a gain. Ya, I'm stuck. Is there a way to open a portal with in a portal row? I would like to be able to enter a record in the Cash Out portal and open a portal from that record (like a pop up window) and enter item numbers. Each item number needs to have it's ID Key. Any help on this would be greatly appreciated.

I am trying to set up a calculated field that will give me the name of each related record in a portal based upon which record number it is. Basically, what I want to do is create a calc that will name each row of a portal whatever number of a series that the portal row falls in to and also count the total number of related records. i.e. - 1 of 5, 2 of 5, 3 of 5, etc. I'm not sure where to put the calc. It would make more sense to put it in the parent relationship so that it can count the related records, but when I do this using a count ( related record) field it only gives me the total number of related records in my portal.

Hi all Just started in Filemaker Pro 11 Advanced. I created a portal with a background so the rows get colored differently (standard function) The rows displaying however turn up white. I would assume they get the same color as the row they are on. What do I have to do to get the same color in the fields as in the row? And second question Every row in the portal has a field 'opmerkingen' which I want to display outside of the portal. The content has to scroll with the portal, showing the content of the row it's on. Is this possible and if yes, how ? Thanks Sabrina Horst

I can't get the simplest thing to work. I've got the port set up I'm telling it to sort by an indexed field that contains numbers and is set as "number". But the portal isn't sorting. I've even sorted the table that the portal is based on. No luck. What the heck simple thing am I missing? Thanks Christopher

Hi everyone, I am an beginner on FM, so please be patient. I set up a database which works fine so far. Now I want to perform the following: Inside my main table I have fields for keywords. In my main layout which shows all data from one record, I want to have a list of other reords having the same keyword. The list should change upon entering a new or additional keyword. Preferably when I would click to one record in the list, it should be shown instead of the original record in the same layout. I searched quite a while in the web but did not get a clue how to do that. I actually have no idea what the right search term would be. I hope that such a task is possi…

I have a simple check out/check in...system of tools I made a record for Tool One This record contains portal rows for People that will checkout and check in this tool. (Everything is work like it should.) Lets say.., TOOL ONE is CheckedOut(date) and CheckedIn(date) by BOB (after its check in it is AVAILABLE again to checkout) Lets say...again Tool ONE is CheckedOut(date) and CheckedIn(date) by LARRY In List view i want to view the most recent CheckedOut and CheckedIn information it only shows me the FIRST CheckOut and CheckIn Information of BOB. How do I view the most recent? Which would be LARRY's CheckedOut and CheckedIn infor…

Hi , I use Filemaker 11 on windows and mac. my problem , 01. I have 4 tables , I. CL name II. Agent III Agent Certifications IV. CL Certifications CL Certifications is caring sub records of CL name like this CL name test 01 CL NAME : ABCD CL Certifications for test 01 : test01cer1/ test01cer2/test01cer03 ----------------------------- Agent Certifications all so the same 1st we create the agent and we create the agent certification EX we create the Agent called MAX01 then we create the MAX01's Agent's certification . those are smiler to CL Certifications like this, but it can me different too. MAX01 has …

Hi, I have a layout with a portal view of another table. This table contains multiple client's information. If I want to send an email to each client in the table I've found I can do this . . . Go To Portal Row [First] Send Mail [To:clients::email, etc., ] Go To Portal Row [Next: Exit after last] Send Mail [To:clients::email, etc., ] However in the case that there is only one row present in the portal this script creates a second empty email. How can I avoid that? Many thanks, jim

I'm trying to implement my first production version of a filtered portal and have fallen flat. All I'm trying to do is display records that contain characters from a user-entered string. No matter what I do after entering the characters, I can't get the portal to refresh until I step away from the current parent record. Then it updates immediately. I've modified Mr. Vodka's simple example to show the results I'm getting. Indeed, if I change my field to a value list selection, it updates just like his example did. (BTW, my match field has to be in a separate record, as shown ... but this shouldn't make a difference.) Any guidance will be appreciated. …

Hi, I try to do a search in the portal table. The portal is connected to another table to list all the items. When I search the portal for a specific word, it list every records despite the fact that I only want to see the record with the specific word. Is there a thing I didn't do?... Thanks. K.C.

I have a database of about 1000 products. When looking at each record / product in layout view I want to see a list of 6 similar items to the current product in which customers might also be interested. A bit like the way Amazon does it. But I can't get it to work properly.... HELP!!! Here's what I have done: Each record has a product name and a unique 4-digit reference number. So I created 6 additional fields called "alternative_interest_1" etc all the way up to 6, and these fields have a drop down list attached of all the products so I can select the appropriate one. This then places the unique 4-digit number in the "alternative_interest" field. The drop dow…

I am trying to create two side by side portals that display records. On my left side I have a master list of standards, and on the right side I have a list of selected standards for the current record. I want the master list of records to filter out anything that the user has selected in order to limit the potential for duplicate records, but for some reason I cannot get the portal filter to function correctly. I have set up a script that allows the user to click on a master standard. When this do this the primary key value is added to a global variable and the record they have clicked on is highlighted. Conversely, if they again click on a highlighted record…

I know this has been addressed but I cannot find the answer to this. If somebody has a link, I would appreciate it. I have been reading every portal post on this forum.... I have a typical job_ID table with a one-to-may relationship to a line_items table with a many-to-one relationship to a items_id table. I would like to be able to summarize the following: Job ID: XYZ has a portal with separate line_items in it consisting of items_id: Qty Location item 1 front window 2 back window 1 side window 3 back door 2 front door 1 bedroom door 1 bathroom door How do I show just the total of doors or windows in either a layout or portal w…

I am an entry level developer and would like some help with a road block I have hit in a soulition. I need an explanation of how the portal and relationship setups would be for the following: Tooling Database. (Check In and Out features) Consists of three basic views: Tooling List User Form Job Form Tooling list shows all tools. User selects tools from this list. Selections are added to users (active account) "cart" on the user form, with a field showing the job number the tool will be used on. (This part I have working) What I can not get is I do not want the tools to be displayed on the job form, until the user confirms the tools in their "ca…

Hello everyone -- Setup Tables: Insured Due Diligence Two Records joined by INS_Insured::ID_Insured = DUE_Diligence::id_Insured Is there a way to make a portal on the insured page from the Due Diligence page that would already have contents (questions) in the portal... have the portal self-populate it self with a list of questions to be answered by check boxes... Example: Think of a questionnaire -- that scrolls... There are about 25 questions that have to be answered on each new insured --- Each question should be on its own line... Is this possible? To help better explain please see example attached Version 2 might be cl…

I am modifying the FMP Starter Solution: Expense Report. On the Expenses tab, I want to add a field, "HOW PAID" to allow a "C" or "R" entry. I am looking at adding this field in the portal to the left of the expense amount for each day of the week in the Expense Report. At the bottom where the starter solution shows "TOTAL EXPENSES", I want to break out the total of "C" and the total of "R" expenses then have a grand total of both "C" + "R" expenses for the week. What I can't get is how to total only "C" or "R" expenses in the portal totals. Also, I want to add a maintenence reminder that looks in the EXPENSES for the newest date an expense for OIL CHANGE w…

I am having an issue with adding a new record to a portal. I can edit records that show up in the portal, but am unable to add a new portal record as I get the message "field not modifiable." I have the "allow new records" selected in the relationship. The primary key in table 1 is related to the secondary key in table 2. I'm using FMPro Advanced 11 Windows 7, and FM Server advanced 11 Mac Snow Leopard server. I'm sure it is something simple, but I'm not figuring it out. Thanks.

I'm trying to create a database to book films and I need to know what exhibition copies are available (i.e. not already booked) to complete the booking. For example, let's say I have only one 35mm print of a film, and it is booked from 12/1-12/4 and 12/7-12/9. If someone requests 12/5-12/6 it would show up in the portal (and therefore available) but if someone requests 12/5-12/7 it would not. I'm not sure how to make the table with the "booked dates"...or what the (global?) field in the bookings table that is related to it should look like...any ideas on structure and portal relationships to get me started? Thanks! David

Hi, I have a vertical portal row on my Contacts layout with provides a quick navigation to different contacts. Imagine if you will a vertical list of all the contacts in the database to one side of the full details for each contact. I have the portal sorted A-Z by the full name. What I would like to do is add the letters A to Z beside the portal and have each letter as a button that when clicked, jumps to the relevant row where that letter first appears. ie, If I want to pull up Peter's details, I click on the 'P' and the portal scrolls to the first entry beginning with the letter P. Is this possible? All help is much appreciated! Andy.

I need to have a total of the "amount" field for records in a portal. The portal records are not all the records from the related file - they are filtered. I need to know what the total of the amounts for those records satisfying the filter is on an ongoing basis.

Hi, this is my first post in this forum. I'm using FM 11 pro with IWP. I have a portal filter based on a field that contains the current account name and the filter looks like: my_portal_table::my_filed = Get (AccountName) Using that in IWP it doesn't work. It seems that the filter use the name of the account that started the FM (not that of the web user). Infact the filter works fine if the web user and the FM user are the same, not otherwise. Where am I wrong? Thanks Ginetto

I have an invoice that the extended amount repeats on the blank line below. I have seen this before, but cant figure it out.

In a three year old FM database there are portals for data entry within a parent file and this design has been working fine until recently. Now, in at least two instances, the relationship key data in the child (portal) files have been lost/corrupted and the data no longer displayed in the parent file portal; if the keys are manually corrected, the data displays as it should. I suspect some form of file corruption -- and I wonder if this is a good time to "rebuild" the solution and, if so, what the preferred method for this would be. I am using FM 10 but could upgrade to FM 11 if it would help. Thanks in advance.

Hello! I'm hoping I can ask my question and it be clear what I'm going after. I have a layout which contains a portal of various information. Each line of information could be considered similar to what you would see on an invoice (for sake of simplicity we will say it is an invoice). What I am wanting is for there to be a button on each line of the portal. If the user clicks the button, it will take the user to a new layout (this part is obvious and easy to do). However, I also want that portal's line information to also be carried over to the new layout. THIS is where I am having problems. How do I get the line they clicked on to be carried over to the ne…

Hi, everyone, I have search lots of posts but still cannot find the one I need. And this is my first post here, I apologize if the question is an easy task. I want to show records in one portal with several fields: "Diagnosis" and "Date." For some reason, I hope when the content of Diagnosis is GS and GA can be seen on the top of the portal and in chronological order. While the rest of the diagnosis show in chronological order. Here's an example of what I want to display: GS 2009/10/12 GA 2010/01/13 XYZ 2007/08/23 DEF 2007/09/24 ABC 2008/05/10 GHI 2009/12/01 But in portal I can only choose to sort by Diagnosis o…

Hi, I was wondering if anyone had come up with an easy way to convert a filtered portal set in to an actual found set (short of doing a new find etc). The fields I am filtering on are unstored-calculation fields and not really suitable for old-school relationship-based filtering.

Can someone assist me with this can't seem to do a simple portal set-up. I want to setup a portal for all activities associated with a work order. When i creat a portal in the workorder based on activty I simply don't see anything. Pic attached. The fields I have is: activity_id>>joined to workorder (activity_id) activity_date(timestamp) activity_note Thanks again.

I have a DB that has many different layouts, all utilising portals to show related tour dates for one tour. Each layout has separate groups of information about each tour date. I am using a scrolling portal on each layout. When I goto related record, the scroll position jumps to the bottom of the viewing window. When I goto last record, then to the portal row (saved as a variable) then the record appears at the top of the window. Is there a way of getting the attribute of the location of the portal record on the screen so the next layout appears scrolled to exactly the same position?

Hello FM Forums, I've searched all over and haven't seen anything on this topic. Maybe it's a lot easier than i think but here it goes. I created a portal for a travel database to list activity for a group for each day. (each portal row refers to a day) Lets say i have 10 records with 10 days of information. When i go to table view to see my data, it shows me all ten records but only what happened on the 1st day. Can you get filemaker to show all 10 days for each record or am i doing this completely wrong? please help!!

I could need some help. I am designing a layout in which every employee writes down his/her work on jobs. I have a portal for the entries for the chosen day, another one with some details of the job currently entered and a third one with all entries for the current job. For helping the supervision of the entries (for the employee and for the team leader), I want to create a fourth portal with 7 lines, one for each day of the week. I could then show the sums for that day. What solution is suitable? I would prefer the monday being always on the top line of that portal, therefor esunday being the last. Thank you for your valued help

I'm using FM 8.0Pro. When I try to create a portal it displays and prints as a table instead of adding a line as you enter data. Any ideas

I have a notes section on a personnel management file. This notes table will allow me to write some quick things about a conversation i have with different people when i have it so i can remember what i last talked about with them. I currently am using a portal that displays all the notes I have on each contact sorted by date in descending order. I want to set something up so that when I am on a contact only the dates are displayed for each note that had been entered for that person and when i click on the date that specific note shows up in an area right next to the date. So in other words if I have a list of dates and I click on a date the note entered on that date for …

Hi guys.. I'm trying to make a portal that shows only matching records based on details someone has entered into address fields in an enquiry... So we have; Surname Firstname Address line 1 City County Postcode .. I want the user to be able to enter any info they have into the available fields and the portal automatically filter accordingly Am I going to have to make a long case statement along the lines of: Case( if(not isempty(address line1) and isempty("the other fields"); patterncount(address line 1; address line 1 related field ); if(not isempty(address line1) and not isempty(town) and isempty("the other fields"); patter…

Hi I need to develop a simple dictionary (NOT a Filemaker Dictionary) that have the word and the explanation of that word. That's it. All in Browse mode. The idea is to click on the list of words and appears automatically the explanation. This database have three fields: Word, ID, Explanation. The problem is that need to list 20 records (of thousands) of the Field Word with portal (or other way) with scroll bars and when do a click on any word then must appears the explanation in other field as I mention above. I try to create a relationship of the ID itself to get the chance to use portals but don't works... (It works in other FM databases made it by me) The onl…

Hi, been a while since I posted last, and I seem to have gotten stupider, as I can't figure out what seems like a fairly easy problem. Working in FileMaker 9 (yes, I know, but still...) I have a table of companies, a table of attribute types (say A, B, C, and D) and a link table of the attributes for each company. I created a portal that will display the attributes for a company, and the user can add a new attribute by clicking on the first field in a new portal row, then selecting the attribute type from a popup menu. This is all straightforward, but I'm trying to restrict the values displayed in the popup menu so that it will only show those attributes t…

Hi everyone, I'm developing an invoicing solution and have run into a bit of a problem. In my customers layout i want to see both the invoices and the line items related to that invoice. My thinking is to create a portal that displays all of the customers related invoice records and, based on the selection made by the user, have a second portal populate with the invoices related line items. I've created a script that sets a global text field to the primary key of the selected invoice, the next step is to filter the second portal based on that field, something like this: LINEITEMS::_kf_invoices_id = CUSTOMERS::xinvoice_id obviously this isn't worki…

Hi Everyone, After hours of searching I'm begging for some help here. Many years ago I built databases using MySQL and recently I tried to get back into it but I was lost. I decided to try out Filemaker and building the tables and forms has been pretty straight forward. However, I'm not getting the relationships at all! I have a table called 'people' and a table called 'roles'. I've also got a table called 'assignments' where I would like to give various roles to people and vice versa. I can't figure out how to do it! It seems that this should be very simple. In my searching I found this link to a document entitled White Paper for FMP Novices. In it is a …

Hey I'm having trouble figure this out.... Say I have a layout for table A with a portal to table B. How can I write a script to navigate from record 3 in table B to the layout for table A and have it automatically got to a specific field in the portal row of record 3. When ever I "Got to Layout A" then "Go to Field" of the portal, it just selects the first portal row, but I want it to select which ever portal row relates to the record I came from in table B. Make sense?

I'm not sure if a Portal is what I need here as I have never actually used one... Basically I am making my own money management system, what I'm stuck on is how to handle transactions with multiple categories... Each transaction will have it's own record in table or list view (might do form view if it will work) but some transactions may have multiple categories, so I would almost need multiple records within a record with a calculation to add up the total... I will have no way of knowing how many different categories might be on any 1 transaction, and most transactions will only have 1 category... Help!

I have a client request to create a layout that includes a series of about 5 to 6 portals. Each portal may display anywhere from 1 to 6 records. I can define all portals with the max records of 6, but the client would like to have the portals evenly spaced top to bottom, so that a portal with 2 records, for example, would have the next portal appear directly below, not with spacing for potential of 6 records. More akin to dynamic stacking, or like a portal of portals, the way you would have summary reports of dynamic length depending on the record count. I had thought about just creating it via a summary report instead of portals, but the other requirement is …

I have what seems to be a pretty simple task, but for the life of me, can't figure out how to do this. I'm using horizontal portals in a layout to display the records in the table in individual rows. Each row is in its own portal with the specific record defined in the portal setup. There are two groups of records and they each have a "type" the sets them apart. There are only six records in each group. I have already created the summary fields for totalling all records. I just can't seem to create totals for each group. I need to total/summarize the balance of each group in a row beneath the respective group. And this is all in one single page layou…

Hello. I have a portal that shows a number of records from another table. That table also includes several summary fields (that are not shown in the portal) that are used elsewhere in my layout. It seems that sometimes the summary fields do not update when I change data in the portal. If I click in blank space on the layout (i.e., not in the portal and not in any field) then the summary fields are jolted to their correct values. If I click in other fields, however, this does not happen. I can also get them to update by doing a GoToField call (w/o designating an actual field), but this has the ugly repercussion of causing the whole portal to flash. So... …

I work at a university and have a database with student information. Some of the students have different levels of scholarship awards that they use at different times in their collegiate career. The student information (name, demographic info, major, etc.) is in one table. I created a new table for the scholarship awards and linked it through the student's serial number in my database. All the award winners start out with an award amount ($5,500) that they can use whenever they are ready to work on their projects. I created a new layout with the student's information coming from the first table, and then a portal with fields for the project money. The…

I've had a search, but am not sure exactly what search terms to use for my problem.I'm sure this will not be the first time it's come up, and the answer may be glaringly obvious. I have a photo database. In my layout there is a large central copy of the photo surrounded by relevant details - date, place, notes, people in the photo. There is also a portal which shows related photos in that set. On the other side there is a portal which shows all photos arranged by date. Scroll up and down to select the photograph you want to see, click on the portal thumbnail and that record is gone to. My problem is that there are over 800 photographs, and every time …

what are portals , what is there use can anyone explain in simple language completely about portals

I've got very similar portals on two layouts. Each has 2 or 3 fields on a single line, and then a little icon at the end of the row for triggering a "Delete" script. Everythign works fine. But on one layout, if there are no related records to display, the portal looks totally blank -- just a box with 7 lines of empty rows, no lines where the fields go. . . . while on the other layout, with no related records, the layout displays a first row as though "ready to go" with empty fields visible and the delete button visible. I can't figure what I've done in the one that I didn't do in the other! I prefer to have the fields/button visible. Can someone ex…

I'm trying to create a portal filter to omit or include zero quantity stock lines in a related stock table that contains a quantity field. I have created a global filter field in my main table but I'm just not sure how to build the relationship to my stock table to get the filer to work. Thank You Anthony

One thing that drives me nuts an burns hours of my time is my bafflement with the behavior of lines and edges and alignments when placing fields in portals. For instance, if I have three text boxes in a row, I can play with borders and spacing between them to get various "looks" when displayed -- but if I put a little non-field graphic at the end of the row (for instance a Delete button in the form of an icon) the lower edge never wants to line up neatly with the field boxes -- I fiddle with embossing, various border colors (grey, black, none), slight re-sizing . . . and eventually stumble into a solution by doing something kludgey like adding an extra little line wi…

How do you delete a record right from the portal?

I'm trying something pretty basic but can't get it to work. I have a Table of Artists and a child Table of Paintings. On a Layout devoted to Artists, I have a portal displaying a single line of data about each painting by the current Artist. Fine. Now what I'd like to do is have a second portal that displays an image of a painting that corresponds to the row in the first portal, selected by the user -- so you can click on various paintings in the first portal, and the image would change correspondingly. So, I'm figuring I have a Global field in the Artists table, say Display_g which I use to build a relationship to a Paintings TO (or in a filtered portal) w…

Hello .. having a bit of a problem here... I have a portal that represents products for an order. There is a validation on the field "Colour" such that it will not allow the user to have more than 1 colour (done by Count Values) Now the validation works... but upon pressing ok after the validation warning, I am dumped back to the first portal row and NOT the portal row in question... (the last one) Any ideas?

I have a portal that is used solely to display some information, and I would like to make it so that users can't interact with the portal at all, meaning that even if they click on a row, it does not highlight/select that row. Is there a method for doing this built into FileMaker, or will I have to trick it by, say, placing something invisible over the portal?

I've got a layout with three related tables displayed in portals. Two of the portals are five lines long; one is seven lines long. I can only create five new records in each of the first two portals, and seven in the third one. Is there a way to get scrollbars on portals, or in some other way make it so I can enter an indefinite number of new records in each portal?

I am working on a project containing employees and projects. I have a portal displaying a list of projects related to each employee. My goal is to create a checkbox next to certain projects in the portal and then have the capability to export the project information along with the employees info to an XML file. I have attached a barebones version of both tables with several records and a portal to display as an example. Would someone be able to point me in the right direction? After I find a way to mark certain items and then export I will try to find out how to change the order in which they will be exported portal_example_01.fp7.zip

I am a new user to Filemaker looking to move my training diary into a database. I have my tables set up and am now trying to build a layout to view and edit the data. I've done a lot of searching online and made some progress but am now stuck. The basic structure of my database is: Training Diary which contains multiple training days which contain zero or more workouts which contain zero or more swim workouts. What I want to do is display a training dairy and let users add / view training days and from there select a day and show the workouts and select a workout and display the swim workouts. So far I'm managed to display the workouts for a given day by using a b…

I have a portal that I am displaying on a layout that has close to (and growing) 3,000 records. I want to only display the first 100 found records of a related set in this portal, however, using the new filter portal command in FMP 11 seems to only limit the number of portal records displayed to the user, not how many records FMP applies calculations to, and displaying a large found set in a portal takes a very long time on slower machines. How would I go about limiting the number of related records that not only are displayed in a portal, but also have calculations applied to them via the portal?

I have a database that shows name and date enrolled. The names are in one table and the dates in another. When I do a report the date field shows the earliest date for each name. I need it to show the latest date. Thanks