Portals

Hello there, I am trying to build a layout that have a tab control, in each tab control I have a variation of the same portal, each set to a different filter, lets say three tabs with a portal in each. The filtering works fine and all that but, on that layout to the right I am trying to setup an "expanded view of the record", so if in the portal I show only about the five main fields, on the right side of the layout I want to show many other fields from that record. I've got that working by set a button on the portal row that: The script above has only one field set to "copy", the real one has about 12 fields. What the script is suposed to do is set a var with the cu…

I'm having an issue with a set of portals that I have created. We wanted a horizontal display of different related records, with tall vertical areas. We are showing up to 3 boxes of details across a single row, so to speak. The layout is based on "TableA". TableA is related to "TABLEA_portals", which is just a table-occurrence of TableA (it's a self join). The layout is based on TableA. The portals all use TABELA_portals relationship. These are scratch records, so we create and destroy them regularly. The one record created at the start of the process is used to tie other related records in the set together, via the relationship. The detail box, on the left, isn'…

Hello all, I have been trying to create a layout with a Portal interface that mimics a typical online shopping interface. I have created a layout that has a 9x9 grid of single row portals to display the possible buyer choices. Each single row portal has the initial row starting at the next incremental value (1,2,3,4 and so on). This works great except when the possible choices are less than nine but causes the following problems when the choices are more than the 9 portals. 1. I need to create a way to to select the next set of possible choices for when the possible choices exceed 9. I was planning to use arrow buttons on the bottom to scroll to the next set of items…

Dear Friends As I have make the simple Estimate file for quotes the product. Every thing is ok only one thing which I could not get the solution. Though I have try several options but unable to get the result. When I prepare the estimate quotes for a particular company of different products items. As I select the first line item name and click that item name field .By script Here I get the product details of that item name and also the no of companies name to whom this item name has been transact. Its ok but I want to filter this item name by the selected company for what we are preparing the quotes. It will be helpful for me to preview the details of last transaction of…

I am interested in rendering multiple virtual lists on the same layout at the same time. A couple methods have occurred to me, but the method that seems easiest to implement would be to simply use repeating fields for my Virtual List table, and making sure to reference the correct repetitions in the scripting and on the relevant portals. Seems like that way you could have as many virtual lists on a layout as you have repetitions for your fields. I have no idea if this is a bad idea or a good idea, if it negatively impacts performance compared to other techniques such as having multiple virtual list tables, etc. Is there a widely accepted technique that is considered the …

I have this script For some reason, it refuses to go to the next portal row and just copies the first portal row up to the count number of times. I would like for it to use commas after each crew info, instead of an enter, but when i tried various options, it keeps giving me error 101. Description field on the table is on there twice, just to avoid layout object issues, once on the on screen menu under another tab, and once again off the main displayable screen.

I have two tables. Expense Items And products The tables are linked by Product Name. So in the expense table i have a product name and a cost for it. In the product table i have the product table and a portal that shows me every expense that was assigned to that cost. How can i make a report layout that shows the product name from the product table and every expense underneath that product name that was assigned to it along with the grand total of the costs. Right now i only show 1 expense item for the product and then it breaks and goes to the next product name in the report. Example I have a product called IBM and in my expense table i have 5 exp…

Sorry, new to FMP 9. I have a portal with multiple rows. I need a button/script that will copy a value from a field in portal row X, by clicking on a button IN THE SAME ROW. I guess the problem is that clicking the button in a specific row of a portal does not first select that specific portal row (related record) for the copy/set field whatever command. Thank you.

Greetings FM community, Hopefully this can be useful to as many as possible. I've looked around and couldn't find the answer to this one, so perhaps it will be. Objective: to have a text string that filters in real time the values shown in a portal How's: -I have a portal inside a popover to display a list of records, in this case displaying names. In the Inspector, the portal's name is set to "PortalClients" -Above that portal (see picture), is a text field (edit box) where the user can enter a text string to filter out the values shown within the portal. That field is called "filterString", and is defined within the layout's table as "text". -In the text field's…

Hi all I'm aware that what I'm about to ask could potentially be quite complex. I've watched some instructional videos on how to achieve something similar, however one technique isn't compatible with the other (i.e. creating a "Tree" within a portal that can then be re-arranged with drag and drop). Here's my situation. I'm essentially trying to create an invoice through a portal. Some invoice items are "line" items only, meaning they don't need to be "nested" or be a part of a "tree". They're there on their own. Some invoice items that are going to be added are called "kits". Kits can basically be defined as follows: > Samsung 15" Flat Screen LED Monitor - Sa…

Hi, I'm a new learner and did search the forum and web but can't find straight answers to this. I have a portal from a related table. Now I duplicate the port to make 3 single-row portals, and I want to show the first row in the first single-row portal, the 2nd row in the 2nd single-row portal, and so on... I create a calculation field using get(recordnumber) to dynamically general row number. I try to use portal filter to do the calculation with row number, but it doesn't work. I know this is problematic because the portal filtering is performed before sorting records, but I just can't figure out another way to do the trick. So, is it possible to achieve what I w…

I need a way to allow operators to move portal rows up and down in a portal. Is there a best practice that folks like? Perhaps point me in the direction of the preferred solution. Thanks in advance!

Hi! I have four tables which are connected as follows: A < B > C < D In the layout of table A i have a portal which is displaying the records of table B. In this portal I have also a field where I can select a record of C and another field where I can select a related record of D. The value of table D is stored in the field of table B. When I change the record in the layout of table D it doesn't affect the stored value in table B. How can it be done that a change of a record in table D will also affect the record in table B?

Hello Can i use a portal to display all my clients from my table, and go to a client i choose from the portal? I use a TabControl with two tabs. On the first tab i have all the information about my clients and on the second table i have a portal wtith a list of all my clients. What i need is to select a client from my portal, and go to the first tab to view or edit the client i choose on the portal. I´m starting with filemaker :-) Thanks for your help

Is there a way to globally adjust the options I've set into a portal filter? I have a bunch of individual portals using initial rows 1-15+ and sometimes I need to adjust a variable to accommodate future enhancements, etc... I'd rather update 1 field and set the portal to that 1 field, so if a change is made, it will cascade the updated information to all portals using that same variable. Going back to edit all of them 1 by 1 isnt' fun. If possible, what is a good approach? Thank you!

Hello! *Please see attached file* I'm trying to create a field inspection sheet. Here's what I'm trying to achieve: -I want to create a portal that displays different elements to be inspected based on the project type. -I want the user to be able to comment on the inspected element. -The comments mentioned above should be different for each project The problem I'm facing is: -I am not sure how to create the comment field (yellow in the database) that would be related to the main record, not the one displayed in the portal. Is there a way to do this? I am also aware that I'm probably going to need a completely different approach. The reason I tried …

Hi there, I've only been using Filemaker Pro 13 for two weeks. Most of what I've written is working well but I am really stumped on a very simple problem: I have a field in my products table where the user can select a size from another table. This field shows the size name and works correctly. I then want to display related fields from the size table, so that after the user has selected a particular size, the height and width will automatically be displayed on the products layout. I have set up a relationship between the two tables, and set the height and width of the products table to be calculations, but the height and width never show up on the products screen. …

Greets, all: I have a portal where I'd like the user to be able to sort its contents based on a radio button choice: Date or Number. With Date, the contents would sort date-descending; with Number (a number that they would enter into a number field for each record (1...2...3...etc.)) the contents would sort number-ascending. On the surface, a portal only allows one choice for sort order: ascending _or_ descending. Is there a way I can pull this off?

Hey Guys, I've got 3 filtered portals on one of my layouts with each portal showing related records based on :- Events::Status = "Drive" Events::Status = "Build" Events::Status = "Event" Now what I'd like to do is hide the portal if there are no related records that match each one of the conditions. I plan on using the "Hide Object When" function of the new filemaker, however can't quite work out the calculation required. Is anyone able to point me in the right direction for the calculation required to count if there are any related records that have each one of the conditions as mentioned above ! James

I have a table of customers, and a self join TO, MyFamilyMembers to list all customers in their family (including themselves). Related by a family ID. The TO is sorted to put them in the order that I want them to appear in the portal. The sort is by the value of the product they buy, descending. I can show each family member's 'position in the family' by placing {{RecordNumber}} on the portal. I want to use that 'position in the family' in a calculation but I don't know how to refer to it or retrieve it.

Hi, so I have two tables, parent and child. The child records are dated amounts. I have a layout based on the parent table, and I'd like to include a portal that shows the monthly totals from the child table. Is there a clean way to do this?

I'm campaigning for our company to switch to FM 13 from Salesforce so that we can personalize and expand our sales database to include all the nice plugins and tools the app has to offer. I will be expected to replicate some saleforce's more desirable features that they are accustomed to having. One of these includes a list of recent items on a given individual record's layout. For instance, they open the database and find themselves either on a Start/Home page or on the first single contact's record and on the left we have a small column listing the last five most recently modified contacts (pulled from contact records). I have experimented with scripts and portal…

Hi! I am new to Filemaker, but have done several hours of tutorials and was pretty confident when I started to build a little portal yesterday. Essentially, my portal needs to act as a portal on an Invoice layout, where the user can add a certain quanity of specified products to a invoice list, which is then summed at the bottom. My first try did not work, but I found a fantastic little example Filemaker Pro file that seemed to work perfectly (admittedly, it was Filemaker 7), but its portal included fields that could be edited with the number of the product, which then populated the price further along on the line, and the user was expected to enter the quantity. …

Hi, I have a portal with five fields - 3 text, 1 date, 1 number; the first row displays all five fields correctly and the following rows display only the text fields. Any ideas as to what I'm missing here?

I understand that the standard way to show all the records of table in a portal is to use a cartesian self-join, but that trick doesn't seem to let you create new records via the portal. All I could think of was joining a global field called IsTrue in a different table to a regular numeric field, also called IsTrue, in the table Child. Both fields are set to auto-enter 1. This trick sort of works, but it seems like a bit of a hack. Is there a more elegant method? I say the trick sort of works because I can't successfully reproduce one of the features that works fine in other portals. Specifically, I want to bypass the FM-native error messages and use my own. I have co…

Hi All, I am having issues with a report that I am trying to create. I have a report up and running and showing almost what I want, but a date constraint I have put on is just not working!! Here is my ERD: The basic crack is that I want to show a report of USERS, with a portal containing their JOURNEYS. I have built my report with the USER table as the basis, with a portal based on the CLAIM table, showing Journey::fromId , Journey::toId and "date" from CLAIM. The report is nearly complete, but the date script doesn't work: Enter Find Mode [] Set Field [Claim::date; GlobalDateFind::GlobalStartDate & "..." & GlobalDateFind::GlobalEndDate] …

Hello everyone, I am using FileMaker Pro 13. I need to add Portal to show data from related table. Some fields which I wanna add to Portal are "Foreign keys" from that related table that are linked-related to third table. Results I am getting in Portal from those fields are numbers, but I need data (text) from that third table that is related to that "Foreign key". Is it possible to create portal that shows text related to that foreign key, and if it is, how to achieve that? Thanks a lot!

Dear Sirs, I have a portal and I would like to display different field types, example two text boxes one with horizontal bar (holding for notes) and the other one plain text box (holding names), I also have a field with 1 and 0 data and want to display it as a check box inside the portal, is that possible? I use FileMaker 13 v5. Thank you. Regards Lamine

Hello all, I was wondering if you could help me? I have a portal for service records for equipment with each portal line being a different certificate. On this portal line i have a retest date. We have been missing some services for customers and this has created problems so on the main customer screen i wanted a field in company details showing the latest retest date. I just copied the retest date field from the service certificates layout and it does in fact give me data. but it gives me old data. If i then for the same customer make a new certificate the  date field on customers layout still only shows the older  date not the new one. How do i make this pick the la…

Hello Forum: I portion of my database is using the "Dynamically Filtering Filtered Portals" by Sara Severson found on the Soliant Consulting website (for some reason I can't paste a link). What I was hoping to accomplish was as the user (me only) was typing, the list filters down. This works fine. But if I type to the point where the portal goes blank (no records match), then I would like to allow the user the option of creating a new record. I attached the sample file. For simplicity's sake, I stripped out all parts of the DB except that related to this topic. U/N admin P/W 1234 The script affecting the portal filtering is at the bottom of Manage Scripts, and t…

NEWBIE I have in my database a table with its layout called DASHBOARD, it reports on certain date related things. However, although in a table called BLOODTESTS I wish to store a history of all employees blood lead levels, in DASHBOARD I only want a portal showing each employees next blood-test... I'll probably add within it a field showing how many days until or overdue. However I do not possess the necessary skills to ask Filemaker to identify the next blood test for each employee, that has supersedes all of those that proceeded it for each employee. I'm finding this difficult to explain so pressed for time decided to record a short two minute video exp…

I'm really new to filemaker and still getting to grips with how it all works. I have been following the Filemaker Pro13 Userguide as well as online tutorials, and am stuck with portals. I appear to have followed all the steps correctly but although my portal fields appear in the edit layout mode, when I close edit layout, no data appears in the portal. I have checked my relationships which all seem to be in order. Can anyone help to point me in the right direction please?

Hi folks, On my class layout (class table), I have a portal of that classes assessments (assessment join table), and when I select one the pupils (Pupils table) all come up so I can give them their marks, notes and attendance. This all works very well indeed (mainly because of the help you guys have given me!) One of the fields on the portal is a sort number (from a pupil_class_assessment_join table). I use this to put the kids into the groups they're working in. At the moment I do this by hand, just typing in the numbers. It would be great to automate this sometimes. I'd like to have a popup giving me the option run various scripts: Allocate numbers…

I have a portal and it has a popover button. Â Inside the popover button is a container field. Â I'd like to "Insert a PDF" into this container but its "grayed" out ( see enclosed picture ). Â The container is set for "interactive" but for some reason I can't seem to insert a PDF and I don't know why it's grayed out. Â Â Also, in my enclosed picture I have inserted the Filemaker Go Development Guide BUT its not interactive and I can't scroll through any part of that PDF document. Â I have the latest version of Adobe Reader installed on my Mac but I just can't seem to get this to work. Â Anyone have any ideas I can try? Â I even recreated the popover button but I st…

Hi, I set up a child table for "Notes" with Time stamps and used four different portals to bring them into the layout of my main table. For reasons that I cannot figure out the timestamp is not working correctly. I have tweaked the settings to no avail. After the first attempt, I decided that it must be related to the duplication of the time stamp for each notes field. So I set up independent time stamps for each field. I am starting to think that the problem may be that I can only have one time stamp per table. here is a screen shot of the layout. http://prntscr.com/5y5kcj and screen shot of table view. http://prntscr.com/5y5njr Thanks for advice

Hi,  I've been hired to modify a database that was built to archive the work of a visual artist. She has a number of works that are related to each other (studies for a piece, or variations on a work). The primary metadata for her works are stored in a table called "inventory", for which the unique ID (and match field) is titled inventory_id. I need to figure out a way to relate various works in the "inventory" table to each other. In order to do so, I created a table occurrence of "inventory" called "inventory_2", and then set up a join table between "inventory" and inventory_2" called "related_records" with these two fields:  inventory_id  Inventory_id_2  I then…

Hi, I am struggling to achieve what I thought would be a simple button script. My company table's layout has a portal showing the related personnel through the field - "company_id" in the personnel table. It also has a popover with a second portal which I use to enter the details of the personnel for that company record. I would like the popover, when I open it through the popover button, to go to a new personnel record. I would also like the "edit personnel" button, which is positioned on each row, to open the same popover but go to that portal row. At first I had the popover open with a filter on the portal for If [isEmpty (Personnel::First)] whi…

I have two tables: Table A and Table B. Table A contains information about a television program, whereas Table B contains the shot schedule for the program. Table B is represented in a portal row within Table A. I am having an issue calculating time. I have a field in Table A (total time scheduled) that uses the following calculation: Sum(Table B::duration) *unstored* Total Time Scheduled is formatted as time and Duration is formatted as text. The duration field in Table B needs a little flexibility so I have it as a text field (time wouldn't let me enter just seconds without zeros preceding the seconds). For example, if the shot is only thirty seconds, the user en…

Hi folks, I've got a portal with a list of kids in the class. I've set up two conditional formatting to flag up kids who are a certain percent below their all time average or the class average. The conditional for the class average is below (the other conditional is identical with the references replaced. Pupils::ThisYrAssesmentAverage ≤ ( Classes::AssessmentAverage - Classes::UnderachievementValue) and Classes::CompareUnderachievment="Class Average" Enabling these conditionals seems to have a disproportionally huge impact on the performance of the portal - it takes seconds to load and sometimes quite a bit longer. Class sizes vary from 2 to 28. Performance is fi…

I have 2 tables. 1 table is a list of products 2nd table is a list of expense reports The goal is to assign a product to each expense report. For example if i have an expense report that was to buy medicine i want to assign the product "Healthcare" to that expense report and have it saved as a unique record in a new table. However sometimes I have an expense report that is for two or more different products. So again for example i may have an expense report that was for buying medicine and also two pairs of shoes. In this case the products that should be assigned to this expense report would be "healthcare" and "clothing". However i want this expe…

Hi, I have a database that is using portals for item number entries for a job. I am looking for a way to look for duplicate item number in the portal field across multiple records. Using below as conditional formatting works but only per record ValueCount ( FilterValues ( List ( Child::Category ) ; Self ) ) > 1 How can i make it work across all the records? Do i need to use a script trigger instead?

I have a DB where i use buttons in a portal to go to other layouts I do it with past and copy script to like the different database but i don't like it. Is it possible to do it with relations ? The example will give a better idee. some suggestions would be great PHD.fmp12 2.zip

HI there, Â I'm trying to finish my invoice layout page. What I would like to be able to do is click a popover button to add an artwork (or artworks) to an invoice. I need to be able to list as many as necessary. Â I have managed to get the invoice addressee working fine, which is a similar idea but not a list - just a single field, so a bit more straightforward. Â I either need help with the relationships, or a script.. or somewhere it is going wrong.. I'll attach a series of screenshots rather than trying to explain more. Â At the moment my button goes to my invoice data layout but and asks me to save changes, and generally doesn't work.. I understand for a …

Hi Guys, I'm sure this must be fairly simple, but I am a FM noob. I have a layout which includes a date field and a portal of related records. What I would like to do is have two date pickers in the header of my layout - one for a FROM date and one for a TO date. I would like to then only show records that fall between those two dates. How would that be possible please?

I have a DB for entering medical test results. Each patient has about 100 tests in five categories. To make data entry easier, I have a self-relating portal displaying the tests fields filtered by the five categories . A drop down menu with the list of test categories and script trigger sets the portal to display only tests in a category. If all results for a test category are the same , I want to to auto-enter the value chosen from a drop-down menu using a script trigger. The script loops through the visible portal setting the test-value in the result field if the test category matches the corresponding variable. This all works well enough but I ca…

I have a master portal that lists an abundant of information. I then want to, based on that master portal, make a selection and transfer or link info into another layout. This same information from the master portal will get used in a variety of different records. Also the information that is transferred or linked to may change Can someone offer the best direction to tackle this as I am not sure how to get there. Looking just to be pointed in the right direction.

I created a portal that is based on a company table related to a Estimate_Line Item table. To this I have two related fields: parent client key = ::child client key and check box options= vendor (which is a calculation field="vendor) It currently tells me when I click in the portal on my company table that this action cannot be performed because this field is not modifiable. The portal is based on the Estimate_Line Item table and all fields located in it are from that table as well. Any help appreciated.

I have a purchase order layout containing project name, purchase order number and date.This layout contains a Portal showing 'Category' 'Description' 'Quantity Purchased' 'Unit Price' ' Total Price' and 'Units Used' Where I enter line items off the purchase order. The 'Category' field is a drop down list based on the values placed in that field. The 'Description' field is selected from a 'Conditional List' from the 'Category' field. i.e. Category 'Timber' Description '4x2', '4x4', etc. I show all this on a report with two sub summaries for 'Category' and 'Description. I have deleted the 'Body' part and in the second sub summary (Description) part I have Summary fiel…

I have switched to using transactions for the situation described below, and I am finding it impossible to maintain the full functionality that I had when I used to modify the children of a parent using multiple layouts, temporary records, and non-simultaneous commits. Each workshop (parent) in my database consists of, among other things, team members (children). Team members can be assigned or unassigned. (So, too, can workshops, though this isn't all that relevant to this problem.) The user can choose to view and operate on workshops (maintained as a list view) in either an assigned mode or an unassigned mode. There is a global variable (let's call it ShowAssigned) …

I'm working on a system that allows the head of each department to access and acknowledge monthly reports that are imported into the DB. 2 of the tables are as follows: (I've omitted other fields that are not required for this to work) Records table: pk_recordID, date_imported, user_name, user_dept, acknowledge_date, acknowledge_avg, kf_reportID, g_deptcode (global field that is defined based on user login) Reports table: pk_reportID I'm currently using reports table as a portal to reflect the following fields: Records::g_deptcode, Records::date_imported, and a button that displays a sub-summary list of records found based on Records::user_dept I need some …

Hi folks, Is there a way to alter the appearance of the scroll bar? I could have sworn it used to be possible with FM advanced, but I can't work out how to do it with 13adv and the white scroll bars stick out in the layout. Cheers, Mike

Hello all. I have a question that it's not clear in my mind on whats the most efficient way of doing this. I have 2 tables: 1 - exercise Type ( id, name ) 2 - exercises ( id, type, name ) So in a layout i have a portal that is pointing to the exercises table, in the same layout I have a checkbox field with a value list that points to the exercise types For example: --- Exercise Types Bicep Tricep Plyos Sprints and so on... --- Exercises Bench Dips (belongs to Tricep) Rope Pushdown (belongs to Tricep) Broad Jumps (belongs to Plyos) Squat Jumps (belongs to Plyos) and so on... What I need to accomplish basically is that every ti…

My database has Relationships of:  Clients ----< Policies ----< Renewals  In a layout on the Clients table, I have a portal that shows all of the related Renewal records  I would also like to be able to filter the Portal with 3 different global fields.  The names of the fields I want to be able to filter by are: Year, Carrier Name and Status.  The problem (at least I think it is the problem) is that the Carrier and Status fields are stored in the Policies table  I attempted to create the Carrier filter.  I created g_CarrierFilter in the Clients table.  Created a new table instance of the Policies and Renewals tables named Policies_filter an…

Hi all, i've got a portal with a correlated container field, containing mp3s. Seems FM not seems able to play the multimedia file, i can see only the name of the file in the container. is it possible to playback the audio in the container? any suggest is appreciate. best regards Corrado

Add New Record Button I have a portal on my Customer layout to display essential details of a customers Devices. Currently I can a new Device for a customer using the following method: Go to the last Portal Row Select a DevceType from a dropdown list (this creates a new record in the Devices table) I then click on a button (Edit) which takes me to the newly created record, now linked to the Customer table I then edit the Device record in full I would instead prefer to have a Add Device button: Click add device This creates a new record related to the customer from where I clicked the button Edit the Device record in full. In this manner I can then have the…

We have came across many scenarios where we want to,get a filter of related records inside a portal as per our need or our requirement,We want advance search in portals like, Example:- Suppose we want to get all names in a portal starting from the word "Z",or any phone number having this code 111 as the starting point. This can be easily achieved,we are going to describe the steps by which one can implement this mechanism of advance or instant searching in Portals,Please have a look below: Let us consider two tables: Customer Communication Information Create a Custom Function which will be used to segregate the word into a pyramid, Custom Function Name -- StackP…

Alright, it's simple. I have a solution for newspaper delivery. I have 3 tables: location, client and dropData. Location is information about the place to put newspapers (e.g. Bob's corner store, Yummy Pizza Shop, etc), client is each newspaper (Herald, Express, etc), and dropData is how many copies to deliver. I've got location and client related via a locationID, and dropData and location related also via a locationID. Then I've got a report for the delivery person that shows location records, sorted by route (multiple routes per person). I have a portal on each row showing only the dropData for each newspaper, but I can't for the life of me figu…

This is a bit complicated to explain but here goes: As you can see in the picture attached, I have a table with container boxes all along the right side. I currently have a script attached to those container boxes that says OnObjectModify - Perform this script. The script basically exports the container file, then goes to the related record in the related table and executes further actions. Heres the problem, everything works great, as long as the portal row has been (selected) (you can see this in the picture attached as its a bit darker) The portal row selector must be the same as the container field I drop my doc into. For me this works great but for the whole o…

I have a portal that displays multiple fields from 2 separate Tables. The portal is associated with table TDL The portals first 3 fields are associate with my main database table BWI, and the portals last 3 fields are associated with the table TDL. When I delete Items from the table TDL they aren't deleted from my portal. Thoughts? Thanks Matt

Hi All, Please be gentle. New to filemaker and FM forum! Did a search and didn't see any items on this! which probably tells me I have gone down a dark lonely road here! This is my first FM database. I have setup a layout with a list of items. I want to see the list, select a row and view detail of a selected item on the same layout to the right ( in pro at least). I elected to use the method I had seen posted somewhere along the lines of creating a global selected field in the principle TO for the sibling TO. For example : a customer has many orders. The detail is then presented to the left of the portal list. I have a slider with portals in each panel base…

Hi, I have a portal set up on a layout for Table A, which shows records from Table B. In the portal records, I am also displaying fields from Table C, which is related to Table B. When I export records from my source layout (Table A) to Excel, I get one row for each record in Table B, which is great. Exactly what I want. The problem is that the Table C fields from each portal record are all blank. Is there no way to get that data to appear in my export, since it is two steps away from the source table? Thanks!

First time on the forum in a good while. I'm trying to rejuvenate a hire bookings database which has had several people working on the development in the past and is a bit of a mess. The main "dashboard" layout has two portals on it, which list orders due to be dispatched, and orders which are out on hire and due to come in. Each of these is accessed via a relationship, with a "start date" field in the dashboard table relating to either the date out or date in field of the orders. The main irritation at the moment is that, because there are two relationships going on, there is a lot of duplication which seems needless. (Things like conditional formatting rely on fie…

I am attempting to import existing records from an Excel file and am having difficulty with the records showing up in the portal. I believe I have my parent/child relationship in line, and am using a script I found from another post: Set Variable [$DataTable ID; Value: DataTable::_kp_dataTableID] Go to Layout ["Initiative" (Initiative)] Set Error Capture [On] Import Records [ ] Replace Field Contents [lnitiative::_kf_dataTableID; $DataTableID] Commit Records/Requests ( No dialog) Go to Layout (original layout) ...however I am not having any success. Any help/suggestions would be greatly appreciated. Thank you PortalArchive.zip

Hi, all: I'm stuck. What I'm trying to do is...well...to save bandwidth, see my thread at FileMaker's site: http://forums.filemaker.com/posts/76d4f2428e (I tried to bump up the thread but to no avail.) Rather than set up four (Domain) tables, I'm trying to populate the data into one child table. Whether this is the best course of action, I don't fully know. I'm having trouble getting the field, HeadingNumber, to populate correctly when a user enters a value in its Data field. Also, I'm not sure I'm setting up the field correctly in the parent table in the first place: I have the Data (child) field in front of a portal box--the portal is juuuuust a bit larg…

Is it possible to put a portal in a layout in database B that displays data from database A? I don't want the information to be editable from database B, just visible there. To (perhaps) complicate things further, the data I want to pull in and display is stored as a repeating field in database A. Possible or no?

I just created any database, kind of a simple database for keeping records of student test scores, grades and finally the result. I have a layout with portal containing the class and respective scores of a particular student. Please, how can I go about doing other calculations with these scores from the portal.. Like how can I get the total score of the student? Average score? What other use can the portal be to me in respect to dealing numbers and figures?

Hello, I would like to create a script when there is a field that is empty it's show a custom dialog. The only thing i'm struggling with is the blank row the portal creates. This the script i have: Go To Portal Row [select; First} Loop If [isEmpty ( article::Number)] Show Custom Dialog ["No Article";"No Article"] If [Get ( LastMessageChoice ) = 1] Exit Script[] End If Else If [isEmpty ( Article::Description )] Show Custom Dialog ["No Description";"No Description"] If [Get ( LastMessageChoice ) = 1] Exit Script[] End If End If Go to Portal Row [last] End Loop

Hi,  FMP newbie here and I apologize in advance for a long winded post. I am creating an store signage distribution database. Basically what I'm working on is creating orders that contain lineitems of signs. Then each lineitem is shipped to many stores. Here are the tables involved:  sign_version - has a signVersionID store - Has a storeID order - Has an orderID line_item - line_items marry signVersionID and OrderID store_shipment - store_shipment marries lineItemID and storeID  *See item 1 in attached screenshot*  Everything work great until I'm working on the Store layout where I am trying to create a set of cascading portals. The first one…

Hi there, I'm a bit stuck with something and I'm hoping someone can shed some light on how to achieve what I'm after. I have a database with products and purchase orders. I have a global field that contains product id's in a list format. I am trying to work out how to take that values from the global field list and populate the purchase order line items (which are in a portal on purchase orders) with the list values. I need each list value to be inserted in a new portal row. The number of values in the list would vary each time the action is performed depending on which products were pre-selected. Can anyone help point me in the right direction…

Hi Knowledgable People! I run a martial arts club and have been busy redesigning my database to include a lot of new features. Using my limited knowledge, books tutorials and the knowledge on this forum, I have managed to create Invoicing, Roles and a variety of other things that I didn't know how to do previously. I am now trying to create a Grading Skill Set. This is where multiple techniques or skills are assigned to a Belt level. My problem is that I can't seem to create the Grading Skill Sets the way I want to. THE PROBLEM What I am trying to acheive is to create the skill set in the Grading Skill Set layout (which is working!), but add the techni…

Hi folks, It's a few months since I last played with portals and I'm now dosed with pain-killers, suffering brain-fade and struggling!! I'm using three tables: Day - DayClassJoin - Class I have DayClassJoin records created on the class layout, but the classes don't show up on the Day layout portal. As far as I can see, the relationships are all OK (linking the appropriate UIDs) The portal shows related records from DayClassJoin. The fields on the portal are from the class table. I've missed something stupid - any idea what? Cheers! Mike

Is there any way to rotate a portal horizontally accross the page instead of vertically?

I hope this is in the correct section. Â Hello, I am having trouble printing portals which are in sub-summary fields. I have a contact database where each person input their information in different tables. For example, medicine information, their emergency contacts, their Allergies, their physician information. All in different tables. What I'm trying to do is print it out. The first image attached is what it looks in layout mode, 2nd picture is in browse mode, 3rd is in preview mode(which is how it should look when it prints), 4th picture is how it actually prints. It is only printing the header. I am sorting all the sub-summaries by the contact_ID which every table …

Dear FMF Community, i have following Problem. Sometimes the content of my TextField/Portal is to much for the TextField/Portal, is it possible to show my customer a sign that there is more Data? This time FileMaker only doesn't show the content anymore, but you don't recognice that there is more. Sincerly, 51m0n

I have multiple tables in my database, my main table which holds most of my data, and may other smaller tables that hold various other data and link to the main database such as my smaller To Do List Table. I'd like to show the full record count of the To Do List Table as a (running count/number) on my main database table. However, I'd like it to display different counts for different users and specifications, such as Get current user: if matt then show a count of all records that have producer code 3. Whats the best way to do this? I have this count through various portals and filer on the main To Do List Layout, but I can't get it on my main table

I have a portal in my main database that displays records from the table (TDL) with a date and text field. I'm trying to write a script that copies the customer number from the main database, goes to the PLD table, creates new record, pastes the customer number (this is the key field in which my database is kept together) then goes back to the portal row from TDL, copies the text field, goes back to the PLD table and new record just created and pastes the text data into the text field. Currently my calc looks like this (see attached) but I'm not getting accurate copies. 1.tiff

Re a portal I have set up: in some instances when I click a record in a portal, it resets to the first record in the portal while in other instances, the portal will "stick" on the current portal - which is what I want - and not reset to the first record. Am using Filemaker 12. Anyway to stop the reset? Note: in the portal setup, "Show vertical scroll bar" is selected and "Reset scroll bar when exiting record" is not selected. Any help is appreciated! Frank

We have a portal in a layout for scanning in items for wholesale invoices, displaying records from another layout 'Wholesale Line Items'. Everything runs smoothly when scanning and entering items. A sorted packing list is printed, and we use this physical copy to pack the goods in boxes for customers. Many times, it would inevitably be necessary to change the item numbers of some items on the packing sheet, as we do not have some of them in stock and other items are substituted. For example, we scanned in the following items: Item No. Description 32249 Remote Control 01207 Coloring Book 12745 …

Hello, not sure if this is the right forum part, sorry if not. I am displaying a portal on a report but simply want to the portal to show the last 25 records, but currently it shows 25 records but starting from the very first record, so basically it shows the first 25 records, not the last. Can anyone help please. Thank you

We currently have a FM12 Database that’s used as an appointments system for a local community transport charity and was designed to allocate and book volunteer drivers time and vehicle from a pool of volunteer drivers in order to take residents of the community to medical and private appointments. We also run Minibus Hire, Club Bus And a Shopping Bus Service, which are also entered onto the system in order to record the bookings. In order to enhance the current Shopping Bus Service the system has to be able to allow multiple clients, (passengers) to be booked on a specific Bus Route and Service. These minibuses run on set routes everyday collecting the clients and tak…

I am having a problem in showing data from a second level relationship (not sure if this is the correct term). Here's the scenerio. Every year, I need to create new funds and expenses are created (PO, Direct Payment, Credit Card, Travel Expenses, etc) However, PO and Travel Expenses can be split funded by multiple funds. So when an expense is created it's not tied to the Fund, the Expense ID is created, and with in that the Expense Line. The Expense Line will contain a Fund field to tie it to the Fund Table. So my table relationship looks like this Fund --< Expense Line >-- Expense Now I want to show all the Expense related to the Fund table and Sum up al…

Hi all, I am having trouble with what I assume is a basic portal function, to use it as a button to goto the specific record selected in the portal on a related layout. For example; Student table and classes table Student layout contains the student name and a portal of related classes. When I click on the portal I want the classes layout to be presented displaying the record clicked on in the portal. It does not matter what record I select in the portal, the first matching (student) record is always returned. What am I missing? Thanks!

Hello all! Â First time poster here. Â I've built several Filemaker databases over the years, but have never had this issue. Â By the way, using Filemaker 13 on OS X 10.9. Â Background: I'm building an inventory database for my wife's company. Â Her business sells retail widgets. Â She usually has several thousand times in stock. Â The unusual aspect (for my purposes) of this business model is that every widget is unique and has it's own serial number. Â The serial number contains data with related info for that particular widget. Â I am trying to create this solution so that as an invoice is created, the widget's bar code is scanned and entered into the line item por…

I'm trying to put 3 related portals on a single layout to drill down data to specific records. Â In particular I have tables for Insurance Companies, Explanation of Benefits (EOBs), and Details. Â Each Insurance company sends us multiple EOBs explaining payments made on the the behalf of one or more patients. Â Â I would like to click on the Insurance portal to select an insurance company. Â This will show the EOBs received in the EOBs portal. Â The final portal should show the list of patients with claims on the selected EOB. Â Â In my relationship graph I have Insurances primary key linked to the insurance foreign key in the EOBs table. Â Then I have the EOB pri…

Not sure what the right forum for this question is, but here goes. I am developing a home owner association solution. I have tables for homeowners and addresses, each with uids so I can relate them. That's all working. Now I want to add support for mailing lists. An address may be in one or more mailing lists. The relationship between addresses and mailing lists is many-to-many so I have created a join table containing address uid and mailing list uid. When I display a homeowner I display all their addresses (may be more than one) in a portal. For each address I want to display a list of mailing list names that address is on. E.g., "ListA, ListB, ListX"…

For all intents and purposes I have two tables. 'tblCompanies' is a straight record of company details (UID = CompanyCode), and 'linkBusinessAreas' is a table containing business area codes stored against CompanyCode as the relational field...so one to many, tblCompanies to linkBusinessAreas. Now, as a company can have multiple business areas, I have it set up so when entering a new company, there is a portal to 'linkBusinessAreas' and records can be added that way. This works fine. What I can't figure out is making it mandatory to have at least one business area entry for the newly entered company record. At the moment, it's perfectly possible to enter a new comp…

Hi, I haven't found a way to use my onRecordLoad script with a portal. You know, whenever the active record of a portal changes, some actions need to be taken. Is there a way? Thanks a lot, Gary

Hi There, Â I am totally new to Filemaker but have a bit of experience making Access databases, My issue is as follows; Â I have two tables Subscriptions & Family Members, one ambulance subscription can have many family members covered. Â I have created a subscription layout with a portal to the family members in it, what I am trying to do is using a button popover add a new family member to the subscription. Â however when I add the popover and all the related fields inside it and create a button to add a new record, it first shows the family members already entered and when I click the add new record it adds a new subscription not a new family members. …

Ok, I have a portal issue. Objective: Portal layout I am using has space limitations so I want to be able to click a button and expand the picture in a portal out to a full screen view. When I use a script to open a new window (from inside portal)to enlarge a picture it goes to the 1st record every time and not the related record. I can then manually scroll through the records to the correct one... I have Table A: Primary Data Table ------------>Layout #1 Table B: Display Table with Portals.---->Layout #2 Enlarged view------------------------->Layout #3 My script is: Allow User Abort [Off] New Window [Name: …

I have a database of Donors I have created a “Dashboard” type view that I would like to add some portals to display useful information on the “Front Page” of the database. For instance, birthdays of donors, Annual donors “month-before donation due” reminder, and “Late” donors, to name a few. To accomplish this, I’ve created Table Occurrences for the desired Table::field and created a relationship to a global Dashboard::MatchField to create this “query relationship”. I’ve successfully accomplished this for the birthdays and “month-before” reminder listed above. Where I ran into trouble was with “Late” Donors. The field that I’m attempting to create the “query relation…

I am trying to replace the use of a repeating field with a child table. A number of years ago I thought I saw a method that would allow you to display portal data horizontally, but I can't seem to find it again. What I thought I remembered was you could have four different portals all from the same child table, each with the same field, but each one would display the values from a different child record. So the first one on the left would show the data from the first child record, the second portal would show data from the second child. I am on a Mac using FMPA 13. hoz_portal.fmp12.zip Thanks in advance for any ideas.

I've got to believe I'm just having a brief episode of "stupid" and I'm just over thinking this... I'm essentially trying to create a portal of summaries of items that appear in another portal. Here's the plan... I have a table with individual expense items. I then I have table used for invoicing the expensed items. The data is sorted by date and customer and category creating an invoice with the total amounts. There are several items on each invoice of the same category (i.e. meals & entertainment, or car rental or hotel). A simplified list of expenses on the invoice might look like this.. 04/01/14 Hotel $250 04/20/14 Car $63 04/02/14 M…

I have a table titled Matters and a second table titled Notes that relate to the individual matters. I have created a portal in Matters that displays an abbreviated version of the notes that looks somewhat like the the individual email list in Mac Mail. I would like to be able to select a individual note in the portal that then displays the complete contents of the note in a "note content" box next to the portal - similar to what happens when you select the individual email. If you put a field in the "note content" box it displays the content of the most recent related record. I'm thinking that the result I want could be scripted with a button over the portal row tha…

Hey, I have the following tables: sidebar_items ------------- id listable_id listable_type pages_pages ----------- id events_events -------------- id Now in my sidebar_items portal I want to display data from both the pages_pages table and events_events based on the listable_type. So if listable_type is page I want it to grab data from the page_pages table and if listable_type is events it needs to display data from events_events. hope anyone can help me!

I am trying to create a script that will go to the next row of a portal (thus creating a new, related record) and enter data there. For some reason, no matter what portal commands I use, I cannot get past the last row that already has data in it. Any advice on how to create this new record in the portal through a script would be appreciated. Thank you.

I am a novice learning Filemaker.I have a database for Horse racing(attached) and have come to a halt at 2 problems. 1.) In the Horse Layout I want to be able to type the Horse name in the box and have their past performances displayed in the Portal. The second is a bit too advanced I feel for me at the moment as I think it requires some scripting. In the daily races I would like the last 3 runs of each horse displayed in a Portal as shown in the word document attached. I don't know whether this is possible and would appreciate any assistance. many thanks Davey H RATEFORM.zip

Ok, this is one of those issues that you sort of feel like an idiot to have to post about because I have a feeling that the answer is completely obvious. I have two portals, one that was created in FM12 and the other than was created in FM13. In the FM12 portal, setting the anchor to both top and bottom on a portal will cause the portal to extend in size to include additional records and the portal rows stay the same size. When I do the EXACT same thing to the FM13 portal, the portal resizes but it also resizes the portal rows and does not extend to include additional records! I cannot for the life of me figure out why this portal is resizing the portal rows ins…

I have the following tables: [schools] ID School Name ... none = Allow Creation of Records, Delete Related Records [JOIN People with School] ID SchoolID PersonID Allow Creation of Records, Delete Related Records = Allow Creation of Records [People] ID First Name Last Name ... I have a layout "School Information" from [schools] as Form Inside the layout I have a Portal that shows related records from [JOIN People with School]. The portal row displays People::First Name, People::Last Name and several other fields. It has the People::ID field hidden. I am able to remove the relationship between the school and person by deleting …

Ok, Can anyone tell me if this is even possible? I have a fairly simple invoice solution... With one very troublesome issue. I have customer table, product and invoice table. I have an issue though that each product is base: Widgets, Gidgets, Gadgets, etc But on each and every widget I have a modification that I have to make: XL, engraved, Blue/Red, etc. along with notes for the invoice. But when I pull the records into the invoice in the portal and I allow modification in browse mode anything I type into one product automatically changes all like products. Ex: LINE #1: Widget: XL, Blue. Engraved. If I enter another Widget it automatically changes the pre…

hello I wonder how to change the way of portal look like. it is horizontal, and i want it to be vertical., search in inspector, there was no clue. like in excel, i want to enter data from left to right in my portal tool. thanks