Portals

Hello all. I have a line items portal, and I would like to be able to give a total price of all items in the portal on a per-item basis. It's easy enough to total up all the extended costs to show a Unifid total, but I would like to show a total for just "ICE" and a total for just "SHOVELS" and so on, all on the same layout. How could I go about doing this?

I am not good at writing scripts and I need help. I have 3 tables. The first is Inventory which contains vehicle description and ID No. The second is MileageFuel Use. The fields are Vehicle ID No., Date, End Mileage, Destination, Purpose, Fuel Type, Gallons, and Cost. The third table is MileageFuel Report. It is set up as a portal which has the related fields from MileageFuel Use. The relationship is based on Vehicle ID. I want to be able to show the records from the MileageFule Use table for a specific time period (7/1/10 ...7/31/10) for a specific vehicle. Right now I can show all travel and purchases for a given vehicle, but cannot break it down by time period. …

I've been chugging along merrily on a solution to track payments to our accounting department, but I seem to have hit a wall. Hopefully it's not a dead end! We receive payments from customers and need to track the multiple line items that a single payment can cover so that the money gets distributed to the correct accounts. I've got a table that contains information about the receivable (check #, total amount, date received, payer, etc.) Another table contains the accounts with their account numbers and descriptions. And I've got a join table called (perhaps confusingly) "payments" which connects an account and an amount with a receivable. For example, one record the…

Hi there, I have been using Filemaker for a few weeks now and am still blown away by how powerful the system is and what one can achieve. I have been reading so many posts here to get up to speed but can't seem to find the answer to my current query - Intro - We deal in shoes, and have a shoe database and another database that has all the components that make up the shoes (laces, soles, inners, etc...). These are linked by ID. I have a purchase layout where I create top level purchase orders. Each order gets it's own ID. In each order, there can be several underlying orders that have their own ID's that reference the shoe being purchased in the order. That…

Hi folks, My patient consultation notes table is set to display as a portal on the patient's main information layout (different file). One of the fields in the consult notes contains an image. I want to be able to click on that image in the portal so that it can be viewed as a larger object so I can see the detail of the image (and then be able to close that new window to return back to the patient info screen). Can I do this? Thanks Chris

Hi! I'm trying to develop a solution that will track work productivity. Our company tracks a certain fixed set of activities, which each employee must account for throughout the work day. Currently, when the activity has been completed, the employee makes a tally mark on a written shift report. At the end of the quarter, our supervisor counts the tallies for each activity and reports to headquarters. This is a total pain! Hence, the FMP solution... So far, I have set up the solution so that if the employee performs a certain activity, they click on the corresponding activity in a portal. This action activates a script trigger that adds a "1" to a numerical column n…

Hi. I have a script that adds several records to a table via a portal. I want the script to only add records if the related table is empty. If there are any records in the related table I want it to come up with a custom message. Thanks!

Hi all, I'm using portal to show data from related table "Tasks". One of field in task table is taken/related from another table "Contacts". How to make contact field in portal always up to date when data in contact table was changed. I was thinking use contact id instead contact name but I want to visualy operate with name and no id number. I must admit I'm total beginner in FM so if my question sounds silly be patient with me please:-) I would prefer step by step description. thank you.

My goal is to have the field color (company) fill in a different color based on the value. I have a customer database I have a job database and I have a calendar view database of the jobs using portals. When the job appears in the calendar view, I want each customer to have it's own fill color so that you can identify the company by color as well as name. Although each portal is it's own relation based on day of week. I have the basic idea of a transparent field and using a global container, but the portal is throwing me. Thank you

Hi, I'm writing a script to retrieve the record in a portal with the most recent date with it. I have sorted the portal in the layout with the correct order, but just don't know how to retrieve this related record.. I have a household table which relates to a comment table. So in the household layout, I have a portal to contain all the related comments, and they are sorted with most recent first. Now how can I retrieve the date of that most recent comment? Do I need to sort the records in the portal? If yes, how? Please advice. Thank you!

I have a portal with a number of related records. One of the fields in the portal is a calculated text field which shows the name of any user currently using that record, if any. If no user is using that record, the field is empty. I would like to sort this portal so that all the records which are in use by users are listed at the top of the portal in ascending order (A, B, C...). However, when I sort the portal in this way, FileMaker considers the empty records to come before those with values in them, and thus all those records appear at the bottom. Might anyone have a suggested solution for this? Thanks in advance. (Note. One thing I have tried is…

Hello. I'm working with a portal that displays dates from a separate table. There are several records that have the same date but only want to see each date once. Is there a way for a portal to display a value only once? Thanks

So, first time posting, hope this is the correct format. Here's the problem I'm running into. I've got a members table that that has the fields member ID, Member Name. I've got a events table with the fields event ID, Event Name I've got a registration table with the fields registration ID, Member ID, Event ID Basically what the Registration Table does is register a member for an event via a pull-down menu that pulls data from value lists created from the Member Name and Event Name. Problem is coming when I want to create a portal that groups all the members that belong to a specific event together. If you can help, I'd really appreciate it. …

I have made this timesheet for recording my work hours. I made a portal and relationship via the date of the time sheet. When I create a record in the portal, it makes a mirror duplicate of the record in the master. So when I create "1" record, and go to add the job codes in the portal, it makes another record in the main time sheet, not too difficult to fix, however I am drawing a blank on what I am doing wrong. Any advice?? Time_Cards.zip

Hi everyone, I work for a magazine and have to calculate how much to pay each contributing author based on the length of his/her poem or article (this part I have working: I have a "Lines/Words" field where the user enters the number of lines [for poems, b/c we pay per line] or words [for articles, b/c we pay those authors by the word], and a script trigger on the field performs a script to see what "genre" is selected from the drop-down menu (basically, article or poem), then computes the payment for each piece and puts this number in an editable field called "piece payment." I need that field to be editable (and not a calculation field) because sometimes we make s…

Maybe I am missing something but I have not gotten the following to work. I have a layout with two portals each with 4 columns. I would like to navigate within the portal from column to column on the first row then move to the second portal and do the same. The issue is that with tab order, it will not leave the initial portal after the last column but just goes to the second row.

Hi everyone, This is another general question that I got stuck with.. I have been using portals in my layouts, and I noticed that the fields defined in the portals are not field contained in the related table where the portal is placed, as portals are just field holders. Am I right? I just wonder if I can somehow make those fields be part of the table, as I need to retrieve the content of those portal fields in the layout where the portal is placed. Hope it makes sense. Thank you. :)

I have a product database with two tables, "products" and "productCategories". The productCategories table is setup as a portal in my products database. I have a found set in my products database (let's call the found set "Posters"). I want to assign all of the records in the found set to two different productCategories, "Movie Posters" and "Science Fiction". Is there any way that I can do this using the replace command without having to create a looping script to create each related record?

I've been trying to figure out a solution for this and have gone down this path, although I'm not sure if there's a simpler solution. Essentially, I'm creating a job application. There are radial selections for "Have you been convicted of a Felony?" and "Are you related to anyone who works for the company?" These are Yes/No fields and are stored in the APPLICATION table. The problem is that I want to "pop-up" explanation fields only in cases where the answer is yes. For the felony explanation field, that is easy - I have a one line portal that hides itself when the answer is no and it has one field from the APPLICATION table included. The relationship field…

Hi everybody, I need some help making a drop-down list in a linguistic database... The idea is that for each sentence that I analyze, I add the root verb (i.e. walk instead of walks or walked) of that sentence, which are stored in another table ("Verbs"). I have created a portal with, among other fields, the foreign key of the "Verbs" table and the field that lists all the root verbs. I want to make a drop-down list of these two related fields, with these properties: 1. if I press on the foreign key field, I want to be able to look up the relevant key, press on it and get the corresponding verb in the other field; 2. if I press on the verb field, I want to b…

Hi everyone, I have created a portal in the HouseHold layout to contain the household's cultural information (Asian, American etc) This info comes from each baby's record. Since each baby record contains cultural information, household with more than one kid would have duplicate cultural information (each sibling would have the same cultural info) So in my portal, the same cultural info would show up twice or more depending on the siblings' number. Is there a way to get rid of the duplicates in the portal? Is scriping the only way? I have a feeling that there should be a better way to develop this portal. Please advice. Thank you!

Hi everyone, I have a quick question to ask - in portals, can we still keep the drop down menus and such there? Seems to me that portals are just extracting the data from related tables, and it does not keep the data input format. I would like to have users use drop down menus in the portal when they enter new data in the future. Please let me know. Thanks a lot! :

I have a database with two related tables, Processing Systems and Processing Records. My relationship is based off of the processing record status (Complete or Active) and the machine that it is tied to which allows me to determine which system is available. Currently everything is displayed in a nice list with a one row portal view, which works well for an available system view but not for reporting. I need a way to list all records assigned to the system but also show available systems (with a 0 record count). Below is an example: Current Display: (list view with a one row portal) Tower1 John Doe Tower2 Jane Smith Tower3 (Blank - 0 related records) Towe…

I have a line item portal on an invoice layout. I have a checkbox on each line that gets checked by the user when that line item needs to be ordered - which works just fine, its just a little repetitive... I would like to have a single checkbox that would automatically check all the line items that are showing in that portal.

Hi all, I have several tables related to each other (tblBabies, tblHouseholds, tblStudies, tblLanguages etc) I also created portals about the babies info in the tblHouseholds. Problems occured when I tried to create new records of households with babies' information in the web version after I published the database. In the developer's end, I set the baby ID to be generated automatically, but it is not doing it in the web end. And the error message "This record cannot be modified in this window because it is already being modified in a different window." popped up when I was trying to input info in the portal. Anybody could explain why? Can I enter info in…

Hi, I have a fairly simple database with 4 tables - > Customers > Contacts > Sites > Survey_Results All of these are related by idCustomer. In order to keep things simple for users I'd like to keep all information on a single layout (Customers). This is simple for Contacts and Sites as I just created a tab control set with each of these two tables in portal form on their own tab. I starts to get complicated (for me at least) for the Survey_Results table. This table contains too much information to show in a portal (short of buying the users a couple of extra monitors to span the information across) so I have used a combination of tab con…

Hello, I want to create a portal that has a start date field and an end date field which will constrain the portal data. I'm not sure where to start. How does Filemaker handle dates; for example, is 1/1/2001 lesser or greater in value than 12/1/2009? When I enter a date range into the date fields, I want the portal to automatically update, so I imagine that I need to do this with my portal relationship. Can anyone give me some clues on how to start?

This could probably go elsewhere, but the Portal is where the problem shows up. Using Version 11, client & server. The Details: - We have multiple Contract Files, each with its own associated Payments File. Leftover archetecture from Version 6. - We have a Payments List Layout, in each Contract File. It has a Portal to the Payments File, Sorted Descending by Payment Date. - Has always worked fine, Version 6 & mostly in 11. Always works for me. - Each Contract File auto launches the Payment File, in a Start Up Script. Payments File is set to "Open/Hidden" (problem ??). The Problem: - At times, the Payments Portal is empty. No Payments show…

I would like to add a button in a portal to add pictures to a record. I want the button to take the user to a new layout with another portal where multiple pictures can be added for this record. Is there a way I can do this?

I have 2 portals on a layout that are displayed across multiple users. These two portals represent the status of a particular item, one portal represents unapproved and the other represented denied. What is the best way to ensure that if a user sitting on the layout is always seeing up-to-date information? I can script a refresh window script to refresh every 5 seconds or so, but that seems a little inefficient. Thoughts?

This seems like the easiest thing in the world to do, but for some reason I am unable to script a sort of a set of related records via a portal row. What I want to do is have a portal that, upon record creation, displays the order that the records are created in. After the user closes the window, any subsequent time that they go into the layout to view the child records I want a script to sort the records contained in a portal by name. For some reason trying to manually sort the records using ctrl+s or by using the Sort Records script step is not working. The only way that I can sort the records is by actually going into layout mode and selecting "Sort Portal Reco…

Why is it that when I insert a portal in a layout sometimes I see a table with all my empty lines and fields and in other times when I insert the portal it just creates the lines as needed. I have changed the view from list to table to forms & I can't figure out the difference

Greetings, I'm trying to beef up my current solution and can't seem to figure a good way to do it. currently I've got a Database hosted on server advanced where people access it through IWP. I have a results layout with a self-join relationship that shows the results of any search in that portal. The user then just clicks on the portal and it takes them to a details page for that record. This works great for searches but when I want the user to see all the records (5000+) it takes such a drain on the server to populate the entire list that it takes for ever and most people will want to view all when they first get in. I'm thinking of having it filter and create p…

Hello, I am new to FM and I need your help in printing portal rows. In the invoice example in FM starter kit ( http://developer.filemaker.com/images/pop_screens.html?src=/images/screenshots/Invoices_ScreenShot.png ) , there is a line items portal that displays the selected products. I would like to able to print each row of that portal on different labels. How can I do that? thank you for your help.

Can portal flash be prevented when flipping from record to record? I have built a self relation portal that I'm calling overview. This relationship basically displays any records without a close date, also has some on the fly portal filters such as status, lead artist, etc... The filters are global, records displayed in the overview portal are the same for ea. record. So when you flip from one record to the next, there is no reason for the portal to check it's self. But currently when you flip to next record, the portal clears it's self, then re populates the records, so this creates an annoying flash! Is there no solution to this? Please help. THANK Y…

I can't seem to get it. I have 2 tables, one is the invoice header date, invoice number name & address then I have subtotal and taxes. I created a 2nd table, lines which has qty, price extended price &invoice number . I have a relationship using invoice as the relationship. Then I used Go to related records script & a> it doesn't show up on my invoice & b> I get an error message "the operation could not be completed because this layout cannot display the results.". Where should I put this button What am I doing wrong

Hi there, There is something I can't pin point with my portal. I have 2 dbs. The first one holds a portal. The second one is used for logs. Every time someone logins, a new log is created but no logs are displayed in the portal. When I go back to the first db where the portal is located, then the logs are displayed. I am sure this is related to windows but I am still in the dark. Any help is welcome

Hi, I am wondering if there is a way to Limit how many records can be created in a portal. For example... I am recreating a form in FMP.. I wanted to use a Giant Portal, that has all of the different Fields being used. The catch is, I only want to allow at max, 12 rows of data per 1 Parent Record. What usually happens is the portal extends to allow more records, I don't want that to happen. I want it to stop at 12. I am trying to make it fit perfectly on a sheet... and I don't want to allow anything over 12... I know another way of doing it, but it requires a lot more time and work setting up a page simply for submitting data... this would sav…

Somewhere along the line I got the impression that it's a "Best Practice" (or at least a *better* practice) to build a little Child-Record-Creator system where the user onters values for a new child record in little global fields and then scripting a button to go and create the record, rather than simply putting browsable fields in a portal to the Child table and allowing users to create records by simply entering data on the next line in that portal. What I can't recall is *why*. There are times when this just seems like overkill, particularly if it's just a simple 1-field child, and adding such a system takes up extra space on the layout that's sometimes hard to …

Hi all, Trying to add a portal to one of my layouts and for the life of me can't get it displaying anything. Before I restarted the DB with proper key & foreign key fields it was easier! Attached is my relationship table display. What I'm doing is; From blank layout (Layout setup - show records from COUNTRY) Adding single field Specify Field - COUNTRY:_kp_country_id Inspector Data - Dropdown list Values From - First Field: COUNTRY::Code, Second Field COUNTRY::CountryName Show values only from second field This setup gives me "This action cannot be performed because this field is not modifiable" So changed Specify Field to…

Hi all. I have a portal on a layout with summary fields above the portal that gives me the total number of records and a summary of another field in the portal. Now I need to be able to have a field above the portal that can give me a count of records in the portal where a certain field is empty. Can anyone give me an idea on how I can do this? Thanks

Hi, I've been hitting the wall with this problem for a couple days. I keep getting close, but can't seem to solve it. I have a table for film festivals (FESTIVALS) joined to a table for deadlines (DEADLINES) by a festival ID Key. My goal is to set up separate portals showing me what festivals have deadlines today, in the next week, and in the next month, with info from both DEADLINES and FESTIVALS tables in the portals. So far no problem. I added globals to the deadlines with dates, then made TOs and joined them to the Deadlines table. So there's DeadlinesLastWk, DeadlinesToday, etc. These TOs are joined to Festivals TOs. The parent Deadlines TO is joined …

I have a situation where the order of portal rows on a given parent record is important, but I'm having problems retaining information about their order in related tables. It's complicated to put to words, but let's see if I can explain this as abstractly as possible. Table A is related many to one to Table B, and Table B is related many to many to table C. Table BC is a join table between B and C. Table B has a portal of join table BC, where the user can form a list of related items from C. the order of this formed list is important. A calculation in Table A forms a concatenated list of the values in the portal in table B using the List function (with Su…

First, This is my first post here, but I've used filemaker off and on for a few years, mostly for simple things, and mostly personally. I'm working on a project now which is a bit larger than stuff I've done in the past. Second, apologies for what is probably a fairly simple question. The problem I have is that I don't know what direction to look to experiment with a solution. Anyway, my question: I have a table "songs" and a table "albums", both with layouts. I have a join table to facilitate a portal on the 'albums' layout to list songs that are to be used in that album. That's done and working swimmingly. I would like to be able to show which album(s) us…

I want to set up an interface that works like a browser shopping cart, where one (main) image is shown with a row of smaller images representing different colors of the main image. I want the main image to change as the user selects a smaller image. Currently I have a layout based on a Style table with the image displayed thru a relationship based on style num. A portal shows all the available color images for the style. How can I change the displayed image via the user clicking on a smaller color image?

I have 3 files (hierarchies, Companies - subset of Hierarchies and contacts - subset of Companies) I would like to display the Key Contacts which are identified in the Contacts file. I created a calc in contacts which shows the record ID for only those records that hold the key contact identifier. After creating a relationship in the Companies file (Co_ID and Key Calc) I am able to display a portal in the Companies File showing the Key Contacts for that Company. In the Hierarchies file, my layout has a portal showing all of the Company locations I would like to now display those same contacts in the Hierarchies file (Hierarchies file shows multiple locations of the…

I have a few portals that are set up with a scripted sorting solution based on Excelisys's Extreme Portal Sort. This solution has worked very well for my needs. But my problem is that when a change is made to a field that the portal is being sorted by, quite often the portal resorts behind the scenes but the view does not seem to refresh. The result is the data being viewed is not lined up with the actual data. So when you make a change to a row you are looking at unsorted it actually changes the row that is really there after the sort. I have tried refresh window in a variety of ways but none of them seem to do the trick. Has anyone else who uses this technique experienc…

I have a number of portals, each with a button in the portal row linked directly to the DeletePortalRow command. Each of these these portals represent the Session Details (in a child table) for a particular client (registered in the Master table). All the DeletePortalRow buttons work fine (they delete only the portal row that the button is clicked in) except in one particular portal... When I click on the DeletePortalRow button - it deletes EVERY record (related or not) from the child (sessions) table. A scripted DeletePortalRow behaves in exactly the same manner. The only difference (that I can see) is that this particular portal has more than one row of data (3 actually…

I have an IWP-hosted database that keep generating the error message "Portal Related Record Contents Have Been Modified" when there are two users working simultaneously. They are both verifying the contents of records displayed in a portal. The individual records have a user account name field and the TO relationship behind the portal requires this field to equal the users account name, so each user only sees records they are supposed to check and verify. They never see or edit each other's records. Each portal row has a button "Verify" which they click, and it runs a script that sets a field in the record displayed in the portal row. They cannot enter any other fields di…

Hi Everyone, Does anyone know how to create portal records using checkboxes? I have 3 tables: (1) Products (2) Tags (3) Products to Tags (similar to a Line Items Table) For each product record, I want to have a layout that displays ALL tags (400 or so) in a checkbox format. Every time a user checks or de-checks a tag in the checkbox, I want a record created or deleted in the Products-to-Tags table. So every record in the Product-To-Tags table will have the foreign key fields of the Product UID and the Tag UID. Also, I want to be able to see what has been checked off as I'm checking in the checkbox.. I understand that this isn't the simplest w…

hello, i have an invoice database with a portal. the portal store all the items by a barcode scanner, so each item/style takes a line of the portal and if i have 10 items same style it will make 10 lines for same item. my question is , can i make the sales invoice to only shows me one line per item/style? for example those 10 lines with the same product code to one line and acumulate the quantity? hope you understand me Thanks for your help

Ugh -- maddening little detail I can't pin down. I made a solution a while ago with a little interface for creating child records from the parent context. A portal displays the current child records so that the user sees what's already been catalogued. Works fine. When there are no child records, the portal displays a first row with blank fields, and the little "Goto and "Delete" buttons I put into the portal. When a record is created, the new child is displayed and the blank row appears below it. Fine with me. But now I copied this portal and re-purposed it for use in the child table for managing *its* child records (grandchildren of the first table. I p…

Hi all: I have what I suspect is a very easy problem to solve...At least, I hope. I've spent days staring at these forums, and none of the offered solutions really address my situation -- at least, not in a way that my newbie mind immediately grasps... I have a Table of Books. For now, let's just say this table has four fields: BookID (serial number), BookTitle (text), ExplodedBookTitle (calculated value that basically explodes each word in the title), and BookInfo (text). I also have a Table of Licenses. Let's just say this table has the fields: LicenseID, BookID. These tables are related through the BookID, so that when I create a new License, I assign …

Hi, I create invoicing solution with separate tables for incoming invoice and outgoing invoice. In both of them I have calculation fields which can not be indexed because they calculate payment terms (30, 40, or 90 days from delivery). Calculation in field "c_valute" looks like: Get (Current date) - Incoming : When payable Result is a number. "Do not store results - reculculate when needed" option is selected. After that I created field which tells me if my payment is due or not. Calculation for field c_due": If ( Incoming : c_valute ≥ 0 ; "must be paid" : "not payable yet" ) Results is a test. "Do not store results - reculculate when needed" option is se…

I have a one row portal which contains a container field. For the life of me,I can't figure out how to script placing a photo inside that container field. It's simple enough when the field isn't in a portal, but how do you do it when it is? Thanks in advance.

I've been searching through various portal sorting techniques. Seems most people are big advocates of using "Tabs" these days for portal sorting. What's the next most common and easiest to implement. I've found such a variety that my heads starting to spin from all the options.

I have 6 records in a portal and i want to display portal record in new window as selected but it shows only the first portal row record.

I have a portal on a layout which is filtered by a drop-down list immediately above it, yet, when filtered, displays multiples of the same record. The filtering menu appears to do SOMETHING, as selecting an option alters the portal. Currently the portal is displaying the appropriate amount of records; the problem is that the portal only ever displays one record, and instead of displaying the appropriate records, displays the same record repeatedly. Pictures are below. Thank you so much in advance for your help! I have a decent understanding of SQL, relationship and database structure, though no formal training. I am computer-science acquainted, however, and u…

Please refer to the attachment. After the portal record is duped I'd like the focus to go to the newly duped record. The problem is, with the Go to Portal Row:Last script step the focus indeed goes to the last (and blank) portal row instead of the next-to-last one which has the newly duped record. (Ya gotta love truth in software coding.) So, how do I code the script to go to the duped record instead of the last (blank) one? TIA for your help!

I'm trying to produce a Filemaker version of a home budget program with similar functions of Quicken. I started out with Filemaker's "Check Tracker" template, and added additional features. I'm having some trouble implementing the "Split Transaction" feature. This feature allows a record to have sub records. As an example, if the record was a credit card bill, the split transaction allows typing in all the individual purchases made by that credit card for that particular bill. I could create a relational database file for each split, but that seems like alot of files to keep track of as the database grows. Is there another way to do this? Thanks, Ron K

Is there a basic way to count the number of records in a portal? But, I don't want the value in the portal. I want it on the layout that the portal is on. I have a portal relating account records to clients. Using information on this forum I figured out how to get the conditional formatting I want -- if there are more than 5 records in the portal of the same account type the back ground color is changed. What I'd like to do is have the number of records in the portal on the layout. Why? I want to perform finds based on that value. Thanks in advance. Christopher

I've looked at all similar posts, but answers my variation of this problem. I have a simple contact database with 2 tables: Contacts and phone_numbers. These are joined by contact ID. The phone numbers appear in the contact layout within a portal that contains two fields: type & number (e.g. "Work Phone" & "555-1234"). I've set the field behavior to allow data entry in find mode, but when I try a find of "Work Phone" in the type field in the portal, it says "No records match this find criteria". I'm not trying to filter the portal rows in the current record, I'm trying to find all contact records with "Work Phone" in the portal. The data type is text and th…

Whenever I enter find mode, the content of portals disappear, or there is a box from which you could perform a find. I'd like a portal to show record content while in find mode so I can script it and perform scripted finds by clicking the portal content. Is this possible? I know I could do this by creating a value list and creating a checkbox set instead, but unfortunately I need to be able to control the sorting better than the value list allows.

Is there a way to do a find for all records that contain an empty filtered portal? The portal is being filtered using Filemaker 11's new portal filter feature. Or am I going to have to create a filtered relationship in the relationships graph and then do an isempty search? It's a complex filter so I would really prefer not having to do it in relationship graph. Thanks!

how to add item from table which is in portal and display total item in other layout which is in portal

I copied a script to remove a portal row but it removes ALL of the entries for the match and deletes them from the parent file. I have checked and there are no permissions to either create or delete records between the tables upon which the relationships are based (either way). Any ideas?

Hello, this might be something simple but I haven't been able to figure it for the past 3 hours. I have one dbase.fp7 with over 1500 records. I perform a search and find for certain records and let's say the search gave me 7 records (field name = CUSTOMER_NAME). I now want to import these 7 records into accounting.fp7. accounting.fp7 contains a portal with 7 rows that is supposed to show only the 7 imported records. When I import the 7 records and look at the portal, I see the same database record (CUSTOMER NAME) in each row of the portal and not the 7 different names of my customers. When I set the portal fields to reflect the contents of the fie…

I have a database that is for a yearly convention. I have a table for the name and the amount of the of each session offered. I made a layout with a portal in order to open and choose which session will be attended. There can be up to 7 choices for the conference. My main table is demographics, then I have registration data for each year, related using the RSVPID #. For each registration table, I have the conference table related by the conference description. In the registration table i have fields for method of payment. When I register someone, after choosing their choices for the conference, I have a layout 'method of payment' I choose their method; i.e. PO; Ch…

Hi. in FM 11 I have a simple portal with a portal filter. Example: Clients and Orders. Depending on the value in 3 global fields, only subsets of all available Orders are shown in the portal for a client. Imagine a client has 12 Orders listed. I apply my portal filter to only show the ones from this year for example. And now only three Orders are shown in the portal. Question: Now I want to switch to the layout/table of orders and only show those three and not the 12. In other words I want to do a show related records with THE PORTAL FILTER considered. Possible? Or can anyone suggest a reliable technique for this? Switching layouts and refinding all …

Hi, is there a nice way to check if a portal is empty? Thanks by ChiSao

I am having issues creating a filtered portal on a users home screen. I am trying to filter a portal based upon a global number field on the home screen and a calculated number field in the portal record. I am filtering based upon two fields. The first is my primary field, which displays all records with a status of "Pending" and "In Progress". I have this field set to a check box and can actively filter between the two different statuses. When add the second portal filter and try to filter by specific number, the portal returns no results no matter I set the number to. If instead I set the second filter field to a text field manually type in the value of a rec…

Hello! Is there a possibility to show/hide portal rows? I have a table in my database for offers, which operate with data from another table through the portal. And I have the invoices file, where the same portal is placed. No problems so far. But, in invoices file I must hide some lines in portal. The deletion is not allowed, because the offer should stay untouched. Is there a way to do this?

I'm working on a database for field organizers to use in the Initiative-1068 Marijuana Legalization campaign in Washington State, USA. Petitions are individually (uniquely) numbered. The petitions are then checked out by the field organizers to volunteers. Volunteers collect signatures and then return the petitions to the field organizers who check them in before sending them in to campaign central. The database has two three tables: Volunteers, Petitions, and Contacts. In Volunteers, there are 2 fields for entering the range of petitions (field1= low#, field2= high#). Relating the range of petitions to individual volunteers is accomplished by: i. a self-relation …

I'm pretty new at this stuff but have a layout for Companys (Companys table) with a portal for contact names (People table) related thru a CompanyName field in each table. Problem is, in a company with multiple contact names, only the first name (first when viewing People in Table View) shows up in the portal. When I first set it up all the names were showing but since then (several days) something has changed. I have double checked the name spellings in both tables and the relationships. I need help. lorenb

I guess there is no answer to this, but it could be a good suggestion for filemaker team... Is there a way to make horizontal portals? I have to display a grid showing pre-scheduled sessions displaying time values. Three lines, one for today, one for the day before and one for the next day. Clicking on a timefield should bring up an appointments dialog. I actually made it working. there are three series of twelve horizontally aligned different portals. For each portal, I had to select a different starting row to display. But then I also had to duplicate the time fields for every portal, and manually program every field to be a button. The formatting was als…

Here's the problem... I have a 'jobbing database' and I have created a separate new 'time database' - the link relationship is the Job_No field. I have a view in the Jobbing DB where the user can add new entries by selecting their name from a pull down menu, then enter time and date in fields (within a portal view)... so via the portal the Time DB is building a list of users and their times and dates against a job number... this is all working well - a user adds new time to the main jobbing database and it creates a new record entry in the time database... Now management is concerned users may delete or edit other users time amounts against the job number (fo…

Hi, I have a related table called Po lines. What happens, is that customers place orders for goods not released yet ( we are selling CD's; DVD's-etc). We put all these orders in this table, then when we have enough orders for a particular supplier, we create a purchase order. However, in the PO lines table, you can have 6 different customers ordering the same product, for differing quantities. At present I create a Po and assign the Po number to all the records chosen in the PO lines table. Then in a portal layout i can view by po number, the order and its related lines and produce a summary report by catalogue number and total quantity for each item being ordered. H…

Hello, I'm a beginner user having a problem with calculating data in a portal based on a date field. The items I am working with are: Invoice (the portal table name) Payment Date (Date field) Payment Amount (Number field) I'm a guitar teacher and I would like to create a report that displays income sorted by year and then month. I am sure this is very rudimentary, but the other answers out there seem to involve more complex operations. Any help or direction would be really appreciated. Kind regards, Joel

In FM 11, can a portal be set up to filter for: Table::TextField contains the word abc somewhere in the field ... or is it limited to exact matches? (Table::TextField = "abc") Thanks in advance for any help.

As many of you know, FM11 solves the flicker problems that have plagued Windows users -- with ONE GLARING EXCEPTION. Portals flash like crazy whenever there is any background color or graphic involved. It is a devastating effect for the user. To clearly test and demonstrate the effects in a variety of portal/layout combinations, I built the attached example file. Of all 16 variations it includes, only white on white lessens the effect. Portal flashing makes FM 11 unusable for my primary application, which involves 72 layouts with portals. It is not practical to redesign them to remove Body Fill Color. The resolution must come from FileMaker in the form of…

Hi, This is my first post, I can't find a related discussion on what I want to find out. I am creating a layout for a Purchase Order. I have created a portal on this layout that relates to another table, called Purchase Order List Items. I want to use the portal to list the items we want to order. I have created a relationship between them that allows the creation of a new record in the Purchase Order List Items table when an item is added to the portal on the Purchase Order table. I have set the portal up so that it has only 2 rows, however sometimes we will want to add more than 2 items. Whenever I have added more than 2 items and gone to print the Purcha…

I'm using comment's dwindling value list (in FMP 8.0), which uses the ValueListItems function and a script to refresh window [flush cached join results], in a portal. It functions perfectly except for one thing. If I'm creating a new record in the last portal row and enter information and then use this script (which is fired by button attached to the field being entered) the other information, the entire row or record in fact, disappears and I'm now selecting a value in a second new record. Is there a way to not flush cached join results when in the last portal row? And while on the subject of last portal row - is it possible to not tab into the last row when en…

Hiya, I am stuck. I am trying to get a button in a portal row to take me to the assiciated record. I have attached screenshots if this helps. I am trying to get whichever record I select via the green "+" button ("screenshot 01") to take me to the "Data Entry" tab - "screenshot 02" and show me that record. The unique value in the recored is "Invoice Number". I have tried building a script. Here are the steps... goto the portal goto field "Invoice Number" copy enter find mode goto "Invoice Number" on the Data Entry tab paste enter browse mode. It will probably come as no suprise to you all but it does not work!!! How do I do th…

Hi all, I currently have a structure for my employees that allows them to punch in and out, multiple times a day. This table is called Employees InOut, now I'm trying to filter this portal by month (2 for February), this works fine, however, it shows: 02/01/2010 02/01/2010 02/01/2010 02/02/2010 Meaning some dates are showing multiple times (because they punched in multiple times that day). Now I really just want to show each date once. How would I be able to do this?

Good morning, everyone. I have a question the about the auto complete feature of Filemaker 9 Advanced. Is there any way possible to have the auto complete feature work with a drop down list that is tied to a value list and be able to click on the arrow and choose from a list of items. Here's an example. If I'm looking for all items relating to "Transmission" If I type the letters "tr" the autofill fills in "tracking bar" with "acking bar" highlighted. If I click on my drop down list it lists everything that starts with "tr" and I can choose from anything on the list. The problem is that the "tr" is no longer highligted and if I choose "transmission" from the list it …

Maybe I'm just having delusions of grandure here, but I thought that I saw someplace that Filemaker 11 would include a script step for "sort portal row". Does FM11 include this requested feature or have I been had?

I have 3 tables: SoldJobs, Labor, and Employees. These 3 tables are related: SoldJobs----------->(Allow/Delete)Labor<----------------Employees On the SoldJobs layout, I have a portal using the SoldJobs_Labor relationship. The portal fields are as follows: Date - EmployeeID - EmployeeName - HourlyRate - Hours - TotalLaborCost - CostedTo When the user enters data in this portal, most of the time there will be quite a few rows where only the date and hours data will change. I want to create a scripted button that does the following: Duplicate highlighted portal row In the newly created row, I'd like to delete the data in the…

Hello, I apologize for the title - not very descriptive. I have a couple of questions, but first let explain what I'm trying to accomplish and what I've done thus far. A company has 50 employees which work on different days. There are 20 positions that could be filled, but on an average day 10 to 12 are filled. Each employee could work at any position (and it changes frequently). What I'd like to do is track who works in what position for each shift (2 shifts per day). So far, I have the following tables: Employee employee_ID first_name last_name etc. Positions position_ID position_desc position_callsign Shift shift_ID shift_d…

I imported an application from FM4 to FM10. Table A and table B connected with an Id. Layout of table A with a portal where table B records are shown. Because I often enter portal records with several fields having the same data, I have a few variable fields on the layout and a pushbutton launching a script that does: Go to Portal Record(Last) - this creates a new portal record Set (portal) field x from variable x Set (portal) field y from variable y Go to Field(Z) - this is where I want to enter values. In FM 4 this worked like charm. Clicking on the pushbutton always gave me a new portal record with default values filled and the cursor in the field wh…

Hi I have multiple portals on a layout and would like to have a script that can copy all the rows from one portal to another. Portal_1 is a Estimate portal. Portal_2 is the one used for costing. I have other portals on the layout which do not need changing. There can be several rows in the Estimate Portal_1 so I need it to copy all rows and add these to Portal_2 any ideas.

HI there! I have a database with related tables which are all shown in a layout using portals placed in separate tabs. What I need to do is to be able to print a total concise report of the current record, but showing all the information from all the individual portals (relate records) which will be shown as separate sections of the report. The number of related records in each portal is not constant and therefore need something like sliding-and-auto-reducing for all portals. One of the problems also is that two of the related tables have around 100 fields each... I don't seem to have any idea for all of this. Does anyone?

In a student database, I have created a portal which details the student's enrolment. Example: Subject Year Assessment Institution Problem 1 I've created a new layout letter to advise the student of their enrolment details. However, if a student is enrolled in more than one subject, only the first subject in the portal appears on the letter. The 2nd and 3rd subjects in the portal do not appear on the letter. How do I resolve this? Problem 2 I want to create a report in a new layout which indicates a subject and lists all students enrolled in this subject. How do I do this based on the portal above?

Can someone please look at the attached file, and tell me why I would be getting a blank first portal row? Maybe I have my script set up wrong? I'm trying to get it where when I add a "stop" on the "loads" layout, it is automatically entered in the portal, and in the stops table. Thank you. Download file from here: http://www.crazyjamz.com/test1.zip until they get file attachments fixed, Thanks.

I'm kind of new at creating portals so bear with me please. I am setting up a database that has four main tables; Client, Contacts, Projects, Communications. The main layout is a view of the Client information with three portals showing all of the contacts related to that client, all of the projects related to that client and all of the communications related to that client. The portals are working fine on this layout. I also have layouts where individual contacts are entered (showing which client they are related to), individual projects are entered (showing which client they are related to) and individual communications are entered (showing which client and …

How do I show a specific related record, not just the first matching one, in a non-portal field? I have a table Class with the Student_ID as a key. Every Student_ID appears in multiple records (once for history, math, biology, etc.). In a related table Phone, I want to say, "Show me the phone number only for students who are taking history." FileMaker does list only those students, but the field for Class::classname displays "biology" or "math" or "history", depending on which record was created first in the related table. How do I (1) restrict the list only to history students and (2) ensure that the field "classname" displays the class that I ente…

Hello I have a strange problem. I created a portal and use Kieran MacMillan's FastCreate to enter the data. It goes well except for the first portal entry. It goes like this: I create a new record. Fill the client's name (or any other field). Then I go directly to the portal entry field and make a selection in the value list (or any other entry field, value list or not ). When clicking outside the entry field to commit it. The datas disappear. In my line items, the datas are there but not the client id (so it seams the relation doesn't work). Now if after entering the client's name I click outside the field to commit it, the portal works perfectly. …

I have a common type of database that handles customer information and invoices using the following linked tables. Clients –< Invoices –< Line Items >- Products What I am trying to achieve on the CLIENT LAYOUT is a portal that lists the products that customer has ever ordered and the volume to date with a valuation based on the latest price indicated in the products table i.e. Product Quantity Latest Price Valuation Product A 10,000 $5.00 $50,000 Product B 12,000 $2.00 $24,000 This assumes the client ordered both products, so if they had only previously ordered Product B it would show just. I think Filemaker does this …

I want to use a portal to display I guess what you'd call two "instances" of one field. Table "Glossary" has only two fields: "GlosId" and "Word." See following: Table: Glossary Field: GlosId (number, where records 0-199 are for Spanish words, and records 200-299 are for French words) Field: Word (text, Spanish or French words, depending on the value of field "GlosId") In the data entry/viewing GUI of the database (layout for table "References"), I've labeled the left "instance" as "Spanish" and the right "instance" as "French," but it does not work right. I want the Spanish "instance" to display only records whose "GlosId" values are 0 to 199, and I …

Ok I have a simple checkbox on each portal record. It allows the user to multiselect items. It is tied to a number field and the checkbox set is attached to a lookup list that has a single value of "1" in it. My plan is if it is checked then 1 else nothing. The problem is that a majority of the time if it is checked/unchecked I get a value of 0 carriage return 1 instead of 1. Below is how it looks. So what am I doing wrong?: Thanks Thom _____ 0 1 _____

Hi. I have a document storage solution that shows in a portal all documents pertaining to a customer. Some are letters in, some letters out some product images etc. The solution works fine. In one layout, I want to limit the records in the portal to a particular document type. Doing a search (either scripted or manually) on the document type field (within the portal) and the customer ID (outside the portal) fails to show just the desired documents within the portal. How can I achieve this goal? Thanks SB :