Portals

Hello I want to use a popup menu as the first field in a portal. But it seems impossible to select it. I have a "No value defined" whenever I want to use it. If I put another field let's say to enter a quantity before the popup then everything goes well. Is it normal or am I missing something? In the respect of the design of this layout I want to make a portal with only one field... the popup menu. Thank you

In trying to create a patient/disease database for use in my blood pathology practice I am running into problems. My intent is to have patient information and Disease/diagnosis. Selecting a diagnosis should bring up salient criteria/features of the disease for viewing, classification criteria and an industry standard diagnosis "checklist". Classification schemes vary with organ systems; schemes and checklists will version-change with time. The Patient Table includes items such as NameFirst, NameLast, DOB The confusion is in how to create the disease side of the database; I may be making this more confusing than needed, but Diseases and their classifications…

Is there a way I can display a container that is within a portal row(a preview if you will)? I'd like to be able to display the file in a preview window in the same layout as the portal itself without having to run a Go To Layout script to see the file. Along with a nomenclature, this would aid in distinguishing which file is the correct container the user needs/wants to export.

Hi, I'm trying to figure out a way to show all related records which are related to a phone number. When the user enters the phone number, I want the portal to show the representatives or companies to which the typed phone number is related to. A representative is a person who works for one or more companies he may have multiple phone numbers (mobile, office, fax, etc) or none. The same thing for a company. So basically I've made 4 tables. Companies (pkCompanyID, ...) Representives (pkRepID, lastname, ...) worksFor (pkID, fkCompanyID, fkRepID, ...) phones (pkPhoneID, fkParentID, phone, extension, type, ...) As you can see, a phone can be…

Parent table is Account table in layout. Portal shows many "Apples" from my Child1 table belonging to only this account# with several other items , Oranges and Bananas too Apples, Bananas and Oranges, get populated in Child1 file, from a value-list from a 2nd Child table for all all counts When looking at 1 account layout, the portal are 3 apples of 5 other items How might I get an ongoing count of all the Apples, Oranges, Bananas when I relate to a different Parent account# I figure probably need something like a Count FOR calculation field. TIA

I'm having a problem with using filtered portals to display information that has different status i.e. - Not Received, Received, Finalized. I've set up a field on the main record itself to display the status information but I'm having difficultly in developing a relationship that will only display one type of status on each portal. I'm wondering what the best way to accomplish this would be?

Hi all, I have never run into this problem with web publishing and portal. The main problem I am running into is that assuming I have 2 table, 1 is the parent and 1 is the child table. You have a layout base on the Parent table with a portal to the Child table. In the filemaker client, you can create a new record in the Parent table, then create as many record in the Child table as you like. However, the problem I ran into is when I publish that database on the web. When you create a record in the Parent table and save (do not create a child record in the portal yet). Then try to click directly inside the portal to create a child record, it simply …

I'm not sure if this is the correct place to ask for help with a custom portal sorting function, but I am running into an issue when using portal sort extreme that I cannot figure out. I've successfully implemented all of the portions of this custom sorting function, but for some reason when it comes time for the Evaluate function to be used on the custom sort_formula field, the evaluate returns a "?". Looking at the contents of the sort_formula field everything appears correct (contents of field are "." & field_name) and is set up as a global text field but the evaluate still fails. Can anybody help?

I thought I saw this "trick" once upon a time but I can not find it now that I haev a need for it...of course! Is there a way to place a portal in a portal? Steve

I have a little issue I am hoping someone else may have run into and solved? I have a Work Order with a portal line item list. I allow input to the line item list via the portal (layout context in the main Work Order). The portal rows have a button which brings up a new window in the same line item record (Context Line Item Table) with another portal of content choices for the line item. Buttons in that portal input the chosen content into that line item. The problem is I have a conflict because I am on the same record in the Portal on the Work Order page and in the line item content choice window. Sadly the "commit" command in the choose script from the…

I have a portal with a gField above and a button next to it that creates a new record. This works just fine, my problem is that the portal shows a empty row that is not needed. Is there away to turn off the empty row?

I've created a portal to a table with a container field. In this field I added a file reference as a test. I want to be able to have others access the file using this reference however when others try to open the file it gives them an error and has then try to find the file. I can open it just fine. The file is stored on our server. What am I doing wrong? I was hoping to use the container field as an electronic file storage system. Any suggestions?

I have a portal with 80 rows. When it prints, at the page breaks I lose one or half of one of the records When it goes across the page break, the record on the break either disappears, or only appears as the lower or upper half of the record in Preview and when printed. I have tried the body summary options, none of which seem to do what I need. What am I doing wrong?? Thanks Frommy (I originally posted this as a reponse to a different thread a few days ago, but have had no response, so am trying again with it on its own)

I need to figure out a way to indicate that two records are similar within a portal. Within the portal records I have a specific field that where I want the value to be unique within the portal. If any of the values within the fields of the record within portal are the same I'd like to indicate that somehow or make it stand out. Does anyone have any suggestions?

It must be me that I am tired but I can't believe I cannot make a calculation field to change as the related data does! The only new thing to me is that I am working from data from a portal, but it shouldn't matter:THEY ARE NUMBERS FOR GOODNESS SAKE!. I use FM since the time it was claris. I am sure things got better with the new stuff, but this is basic and I am growing frustrated with 8.5 as it was a difficult migration (still is) from previous versions!

I'm simply trying to allow the portal text field to auto expand as moret ext is entered via browse mode. ie I have one row set for the view, but i want it to expand to two or three rows if the user enteres this much info - right now it disappears beneath the border, and I can't see it from browse mode. Thanks!!

If I have a portal with all of the information I want to export to an excel spreadsheet, is there an easy way to do this? I was thinking I could make a special layout with all of the same fields... and run a scripted button on the portal that would "Find related Records" and display it on the other layout, and then export it. It would be nice if I could just export the portal records directly from the portal.... is that possible?

I simply want to know if there is any way you can make a portal auto-resize in function of the number of displayed records shown within the same portal. It is a feature that would greatly improve layout designs in general. Also: I have seen a portal that resize automatically when the window is resized... I think it was in "starting point" free solution. How do I do this? I tried the "anchors" in the object info, with no results (it only resizes horizontally upon resize... why not vertically?) And finally: just like the way the topics are shown in this forum, there should be a way to "minimize/show" portal records from a whatsoever kind of titlebar button... or i…

Strange.. I have a portal that i am adding a 4th numerical field ... The field displays Yes, when i click on it i see my numbers.. Pd Price Recv Qty Sell price Qty Bal And Date I 've change field names, created a new... added a 5th field being a text type okay Copied a good num field to, change it flips doing the same thing? When I open the file, create a form and browse via Filemaker my data is fine.. There no field CONTROL setup Create completely new field same strange thing What goes here?

Hi all, Relatively new to this but am slowly catching on. I've created a database to record a group of people and their involvement in a series of projects. I have a table of People, a table of Projects, and a join table of Interactions, which records the two foreign keys and information about each individual person-project interaction. This all seems to work fine, including the relationship between the three. The trick comes in when I attempt to divide the interactions into two categories. A person can be involved in a project in one of two ways (Staff or Volunteer) and can change type from project to project. On the Project layout, I'd like to have two porta…

I've used FM over the years in a very superficial way. Now I'm trying to adapt one of the existing templates: Expense Report. I want add a field, Expense_Vendor (in order to identify the company the expense went to), to the Expenses table and have it show up in the portal of the layout "Expense Report". I've done that with no problem, but I'm not able to type into the field in the portal. I've tried looking at the other fields in the portal (Expense_type, Expenses_day 1, _day 2 etc.) to find what the difference in my new field is without any luck. I notice that these other fields have a small rectangle at the bottom, in layout view, that my field doesn't. Any ideas wh…

Hi Folks! How does one right a script that would take data from a portal and compile it into a single list in one field for that one order? I have a currently have a portal in my Order Table that shows what Purchase Orders are related to that job. I need to compile just the PO ID, the supplier name and the date ordered into a list that can print on the job docket. Thanks again for all of the help!

Hello, This is on FMP 6. Here is my layout: Header Fields Portal (set to display 10 rows) Fields Footer When printing with more than 10 records in my portal, it will only print out 10. How do I get it to print the remaining records in the portal to print out as a 2nd page? So with records with 12 records in the portal: So page 1: Header Fields Portal (prints first 10 rows) Fields Footer So page 2: Header Fields Portal (prints with the remaining 2 rows) Fields Footer (without sliding to fit all of it in 1 page)

Hi, I have this problem: I have a portal with different clients, and I'd need to include in the portal line another little portal... I've read here in the forum that 'portals into portals' don't work, but what should I do to solve my need? Now I have 3 different fields in the portal line, but I don't know how to produce reports joining that 3 fields contentss... please help!!! Thanks a lot people!!!

I would like to have a layout as an invoices overview. First portal: shows open invoices second portal: shows closed invoices third portal: shows invoices created today As you could see the 3 portals uses the same table (invoices) How could I do this? Thanks a lot by ChiSao

I have a filtered portal that shows an account # & account name which works fine. I would like to allow the user to select a row, have the row selected highlighted to confirm his selection then insert the account # into the primary table. I don't know how to do this but feel it must be something done quite often. Can anyone offer suggestions as to how to set this up?

Hello Filemaker world i am having a problem with portals im trying to make a cash register system for my work i have it so when you click a button it creates a new record in another table i would like then for that record to show up in the portal on the main page i think i have the relationship wrong or something Thank you in advance! Register.zip

Hi there. I am stumped on this. I made my portal where I can select any number of different products offered and then enter the quantities to purchase. I want to then view this in another layout showing the invoice and all of the items purchased in the current record. I cannot figure out how to display this information. I have created a "Line Items" table with the relationship to my invoice.

Hey, This is my first post on this forum and my first deep dive into Filemaker so please forgive me if what I ask is not possible or there is a simpler way. Essentially, I have a database that has a list of managers and the employees that report to them ...An example is below: Employee: Manager: David Josh Joe Josh Jack Josh Jeff Katy What I would like to do is produce a report/layout that shows a quick view of employee by manager. Perhaps in several portals? One for each manager? Or perhaps a cross tab report... The problem is that I am entirely unsure where to start and how to proceed. I …

Here is something I'm trying to do which I've found out is beyond my ability to figure out today. I am creating a database to hold government acts and regulations for quick lookup. I have attached a copy of the joins. I added the extra ID's being carried through because a duplicate number problem across regs and acts and this solved it and kept them easier to track. However... What I want to do is have only layout with a portal in it that lists the acts and regs by number so that I could just click on it and it would should show below the portal. For example Regs are by type;section;subsection;claus;subclaus. 1 (1) (a) (i) for example of course y…

I have a portal that filters rows based on various criteria. The portal row has a checkbox that a user can select which activates relationship so she just sees the rows with the check boxes she selected. Works great in single user mode, but what is the best way to make it multiuser compatible? So that one user can select some checkboxes and another user another grouping of checkboxes and they just see the portal rows with their check box selected? Thanks very much for taking the time to respond. WB

Howdy... Long time since I was here last, but hoping that one of the wizards here can help me nail this down. Anyway, writing a solution that creates a simple work order and it includes the usual entities like Contacts (or customer), Service (instead of product), Invoice, etc. The majority of the contacts come from a variety of Real Estate offices, they call and request an inspection service on a home they are negotiating. Many times they will ask us to invoice an Escrow company, which brings me to the scenario... Currently, to create a Work Order means locating that Contact (if they exist, is not creating a record for them first), and clicking the …

I have a table with the fields: date, company and performance. On a different table I want to display for each company a row for each year and the performance by month along that row. It seems that I would want a portal but when I try that I get multiple rows for each year and some strange data for each month. At this point I am not sure if the problem is with my data table or just some simple thing with a portal. Does anyone have a solution? [i am using FM 10]

I have a portal on "student" layout that lists details of students' applications to schools (drawing from the "applications" table). Each row is one application. One of the fields for each row (application) tells me whether that school accepts materials by email with the value "Y". I want a field that gives the total number of Y's in the portal. I.e., how many of the schools a student is applying to that will take email submissions. Is this possible?

Hi! I have a portal on my layout and the first field in it is a auto generated serial number. For some reason whenever I create a new record, the portal does not fill in the serial number on my first portal line. But if I fill in the other boxes and go to the next portal row, the second serial number will fill in and so on. Is there a trick to making the first row in the portal create this serial number? Thank you so much in advance for any help!

Good afternoon everybody, I went clueless how i can tackle the following problem. I have a table "Art Production" this table consist of - ap id_K -job ticket -item number -item name I have a second table "art file" this table consist of -ap id_F -art file id_k -art file number -art file name and a 3rd table "ink specs" -art file id_f -ink specs (15 repetitions) here is my problem. i will create one job ticket (table #1) and this job ticket will have multiple art file numbers, and each art file numbers will have up to 15 ink specs (thats the idea about the repetition field). at this point i don't know how to tackle t…

Hello everyone, I recently started working with FM database and have been asked to implement a new feature to our current database. I made a portal with flight information, with different fields such as date, time, flight number, etc. For each record there may be many portal records, for example any person may go on many flights. (This is a student information database). The flight records are sorted by date. What I need to do is concatenate, all the flight information into a new field which represents flight summary. This is easily accomplished when I only have one flight, however when I have more than one, each flight must be sorted by date and put into t…

See attached screenshot. I'm showing a selection screen for the user to choose a portal row. The portal shows related donors based on the data relationship using a global field called "Filter Option 2" in the Organization record. The script that displays this screen sets Filter Option 2 to "" (blank". Organization/Filter Option 2 is the field that is used on the layout shown. However, no portal data is shown until I enter something in the Filter field and hit the tab key. If I key "" into the filter, or any other value, then it works perfectly. How do I get the portal data to display on the initial presentation of the screen? Thank you. HJ das1.bmp

Not sure best topic for this problem, but I would like to modify one of the pre-built starter solutions in FM10: Home Budgets. I am adding dates and sub-categories fields to the different categories. Current problem is changing the name of the "LivingExpenses" to "MaterialExpenses" in the related tables that is listed in the "Portal Setup". The drop down list shows more tables than their is when I go to manage database, 2 verses 5 tables. Where do I find the these related tables? I think for all the pre-built in functions to work every occurrence of "LivingExpenses" must be renamed.

I'm using IWP and need a portal to show found records. It needs to be a portal as a list will not work in IWP and also I need to present the found files in a list so the user can scan down the list and find what they want. I cannot see what I need to base the layout and portal on. Any ideas?

Hi, I'm using portals and within each there are some dropdown list behind edit box. The problem is the lists edit boxes do not refresh with the selected values in the list. I've done a small camcast. So you can see by yourself. Link to the camcast Thanks for your help

Hi, I'm building a invoice layout for printing and I would like to combine two field values into 1 field to reserve horizontal space for other fields. These fields are within a portal. The values are in a related table to invoice, the portal is showing these values ok. So I try to show the invoiceID within the portal: <> and it shows perfectly. Problem is I can't seem to show the related field eg: <> shows the exact same thing for each row '<>' instead of my value! Combining 2 fields <> - <> doesn't work either. I double checked the spelling and the field names are the same as in the relative table. What can my mi…

Hi, Has anybody tried to change row position in horizontal portal (multiple portal)? I want to add two small arrows inside each portals to allow the user to move the record left or right. - The records in the portal have a position field. - The portals are horizontal I know there's a complicated way using GTRR stuff, but is there a simpler way? Thanks

Ok, this seems basic, but I'm having trouble figuring out a way to make it work... In a layout that displays Rerservations (only the previously selected one), I would like a portal that displays and allows selection of contacts to be included in the reservation. So far, everything works when joining tables like this: Contacts::ID x SelectedReservation::ID But as the contacts list grows, it became arduous to scroll and search all the time. What I need now is a "Quicksearch" kind of thing... So here is what I tried: In the contacts table: - added a "SearchString" text calculation field that merges information to look for. the calc goes like: Co…

Just not quite grasping Portal Filtering and Global Storage. Database consists of investigations records. Each record has a case number. Each record has, for ease of explanation, a to do list portal. When a to do item is completed, the completion date is entered in the portal. If it is not completed the date field is empty. I need a separate layout with portal that displays all the case numbers with non completed to do items. Basically show me which date fields are empty. I've checked all the posts for days and I just cant grasp it. I can pick apart an example db pretty well if someone could throw together a very basic one. Thanks.

I have 3 tables listed: 1.State Appts 2.Cert Footprint 3.Qualified Cert Footprint 1. contains fields "state" and "carriers" 2. contains fields "state" and "agent" 3. contains fields "state" and "agent" and "carriers" I have created relationships of each of these to a 4th table which acts as the portal window. I have two portals currently. The relationships for 2 and 3 are based on "agent" so when I select a particular agent in the 4th table I get results showing the states they are licensed in the portal connected to 2. and I get the carriers the agent is appointed with in the portal connected to 3. My challenge is to create a portal that will…

Hi, I am developing a solution in which i have a portal in which i am adding employee names, what i want is that after selecting any employee in portal then the same employee will not added further in the portal.suggest me how can i do this .

Is there a way to group records that are marked by a status field as "Active" together in a portal? For example, I have 5 records 1)Active 2)Active 3)Inactive 4)Active 5)Inactive I would ideally like for all the "Actives" to be together and the same for the "Inactives" in the portal as such. 1)Active 2)Active 4)Active 3)Inactive 5)Inactive I would also like to highlight the "Active" portal rows with one color, and the "Inactive" rows with a different color. Is that possible? Thanks in advance for any help.

dateEntered ...Auto enter acct ...1000 ////mother Account last_name ...Smith ////child Clients We create accounts stuffing patients under In a portal, we have a client list of lastnames sorted by date In each acct# has 1 record--the lastname default is "Office" In a portal..i am trying to Exclude records = "Office" Seems simple..

Ok, I could use some suggestions for this. I have a very large repository of information spread out across 3 tables in SQL. In FMP, I have created 3 table occurrences of these sql tables and have defined relationships between the common variables. I am attempting to mirror that database here in Filemaker. on a Daily basis it uses a previous order date to show all of the new orders... I use a portal to display all of the information from the 3 tables that I need on the screen for that day. I wrote a script that will loop through this portal and copy the data to my filemaker table. I set all of the values into local variables... I then switch to my …

I'm having difficulty with creating a filtered portal on the criterion of age. I am trying to make a portal provide choices filtered by input from the user in fields of LastName, FirstName, Gender, and (DOB or estimated_age). It is actually working to filter by user input, but the age calculation is incorrect because it currently is stored. This is not a big deal for a 50 year old (the estimated age looks up +/- 20%), but is a substantial issue for a 14d old if the calculation is not refreshed for a few weeks. The example file is attached. The user can put in the LastName, FirstName, Gender, and estimated age. The user input is placed into a global field and…

Hi, On one of my layouts, I have a text field in which you can search for a last name to see if it is already in the database (e.g., you'd type in "Smith"). If the name exists in the database, all occurrences of the name (Mike Smith, Derek Smith, etc.) show up in the portal below the text field. I want the user to be able to click on each name and be taken to that person's record (in my "contact" layout). Right now, every time you click on a record in the list (if there is more than one name), you are taken to the record that matches the *first*/top name in the portal. (If the list had the following names in the following order--Mike Smith, Derek Smith, Lydia Smit…

I am still new to this, but here's what I am looking to do: I want to have a IWP user go to a layout(portal?) and be able to help custom create a layout that they could then print out for their own use. We have 32 stores that do their own "in-store" flyers and we would like them to be able to create their own using information and pictures from the existing database, and allow them to in put their own pricing. This information would then be displayed in a layout I would build, that would have existing corporate logos, and a bunch of mini layouts setup on that page. So on the entry screen they would have a row of fields: Event Date #1 SKU Sale Pr…

Hi all, I wonder if anyone out there can help. I am working on a job management system and I have hit a bit of a brick wall in filemaker namely the lack of ability to display portals within portals. In my job management system I have a jobs table, a job stages table and a staff table. For the particular layout where I am having the problem i have created a parent - child - grand child relationship with jobs to job stages to staff. The jobs layout shows job stages associated with the job (as you can see) The problem that I have come up against is that I want to add staff members to the job stages and because there can potentially be more tha…

Hi--we recently lost our IT person who had created out database. Prior to her leaving, we thought we were able to gather information from a layout where she had placed a portal. I am not familiar with programming, and am now trying to get the data out. Here is my question: She created a portal with date, type, description and other information fields located in a table. When the original fields are full, the fields then appear to copy and create themselves again in another line of the portal. However, they are not seen in the table. I know I sound really ignorant, but where is the data being stored? This information is basically historical data on an individual contact.…

Did not see anything addressing this, so I'll ask. I have a portal that is sorted on one field (Field1). I want to compare the values (dates) in Field2 between the first and second row in the portal and determine which is the earlier date. I don't use portals often enough to know if you can do calculations between fields on different rows. Any and all help is appreciated.

Hi, I know i have seen this in the past but cant find it again. (urggg) A kick to the forum post on this would be appreciated... I have a portal displaying data with a DELETE button for each row. The problem is that the row directly after the last row of data shows the DELETE button, even tho it has no data in the portal row. Only the one extra row has this, the rest are blank as they should be. (see attached picture) I would be great full for a point in the right direction to find the solution to this...it just looks bad right now. Thanks,

Hi All, I want to generate an email that includes a report either as a PDF or an excel file. I want the script to automatically generate the file name. Current date_Text specific to the file (Username etc). However, when I try to use the script step save a PDF or excel, I get an error message. I think it is how I'm trying to save the file. I use a set variable step to set $Filename to generate the name. I just want to set it to the person's desktop (Win/Mac). Help?

I am very new to FM, so please be patient with my ignorance. I'm trying to make improvements to a database that I did not build myself. So I am still struggling to understand some of the ways this database works I have records for "members" and each member has multiple location addresses associated with it. The multiple locations are entered into a portal linked to the members by a member ID number. I need to build a script that returns members locations based on an option selected in a drop down menu field that is part of the portal. So for example, a location could be a Store Front, and Office, or a Warehouse. These are the three options in the drop down…

Is it possible to create a portal that shows fields from related records in three different tables? If so, how? If not, how do I get around the problem? I have a many to many relationship between two tables, with a join table in the middle linking them. I need a portal showing fields from each of the many tables, and one field from the join table. Edit: Problem solved by creating calculation fields in join table to specify the data I need so they are all in one table. Then portal works perfectly. Apologies for bothering the electrons on this board.

Is there a way to delete a portal row, without deleting the related record attached to it?

I've created a layout displaying a parent record and a portal displaying the child records. I've create another layout, this time displaying the parent record and one child record, I need to create two buttons that will then change the child record displayed, one for up, one for down so as I can cycle through the child records.

Hello, I have a DB setup and running and have just started to use it live after much testing and tweaking. I have found a problem, that im not sure ware it come from so not sure how to look at fixing it. My Portal is displaying records that it should not. I have customers, each customer has systems and each system has inspections. The portal shows the inspections done in the past for the system selected for that customer. For some reason (and seems to be random...i cant see logic in it anyway) when in the customer record the portal is showing inspections done for other customers systems. Here are two screen shots which show the portal setup and the …

Dear Professionals, New row for entering portal data is defaulted to be at the very bottom of the list. Is there a way to keep it at the very top?

Good Day everybody! I have a "big" problem: in my database, one of the layouts contain a portal that display records form the same table. What I am trying to do is just to go to the related record in the same layout(on the right side of the layout I have the portal , and I want to display in the left side the information about the record that I will select) I created a "go" button in the portal that I set it up to a script. The script will just use the filemaker function "Go to related record", but is not workiinnngggg.....not even "Go to Record" is not working! Is there anybody that has some ideas how to make this to work? : :qwery: :qwery: :qwery:

I understand how to filter a portal with a global variable if the layout and portal are both drawing from the same table. But I have a layout that shows records from 1 table and include a portal that displays related records from another table. I want to filter this related portal. For example, table 1 is called Company, with a field (that I want to filter on) called Status. Table 2 is called Investors. A Company can have multiple Investors, and Investors can invest in more than one Company. I have a 3rd table called Shareholders that links the many to many relationship between Companies and Investors. I have a layout that draws records from Investors table. Tha…

im trying to use a dynamic date range on a portal and it does not work. i tried performing a find of 9/25/2009 on the portal and it brings back all the original results on the portal. i can not perform a find from the date field. MORE DETAILS i have an employee table and a work order table the employee layout holds a portal from a relation from the work order table and i would like to perform a date range find to check on weekly status of work orders. But i can not even perform a search so im guessing this is why its not working

Hi! I have a simple subscribers database w/3 tables: subscribers categories subscribers_categories (many-to-many relationship subscribers to categories) I have a portal that I can use to *see* multiple categories assigned for each subscriber, but I can't *enter* more than one category through the portal. I do have "allow creation of related records" checked. Please help!

I’m trying to sort records using a more “natural” sort order. By which I mean that given a text field with records: 1 2 10 A B C etc. will sort to user’s expectations (in other words, not like this): 1 10 2 etc. There’s a great algorithm for this: http://www.davekoelle.com/alphanum.html However, implementing in Filemaker is problematic, to say the least. Prior to version 10, filemaker wouldn’t be able to iterate the calculation properly, and even in version 10 it’s incredibly slow. If anyone is interested, attached is a file with sample data, and some attempts at getting this to work. alphanum.fp7.zip

I’ve probably caused this problem myself. I have a Layout based on global field that hold a Yes value. I have a Portal on this layout that show records that have been selected in another layout by clicking on a Checkbox. The relationship is on these two fields. Now, it works. A user can select records by clicking the Checkbox and then go to another Layout that show just the they have selected records. Problem is, it only works in Portal. I need to print out this list and cannot seem to find a way to do it. I thought I would be able to create a Table Occurrence that would just show the selected records, by I get the full Table showing. Can someone offe…

I have a portal that when records in it are clicked, it will go to another layout showing more details. When the user returns to the layout with the portal on, it always goes back to the top record. How can I make the portal freeze position so the user goes back to where they were before they moved to the other layout?

Hi All, I have a portal that is filtered using return seperated lists in global fields. I would like to create a print layout to print the information as it is displayed in the portal. Alas I can't just do a find by setting a field with the value of the global it is filtered by. Is there another way to mimic the filtered portal in a print layout? Thanks

Is there a way to do a Replace function that will update all records in a portal, without having to loop through the portal rows? I have an ancestry/progeny relationship going 5-deep (5 generations) that build on each other with a parent-child relationship from the prior generation. It uses a list calculation to match to. The portals work great, but now I need to run a report (by animal) with all associated progeny, including the relationship (son, daughter, grandson.. etc.) I figured out that I can do this in a script by setting a field in the Ancestry table and then selecting that field to retrieve all the records that were set. However, the only way I …

: FOR SOME REASON THE SCROLL BARS ARE NOT VISIBLE WHEN A PORTAL IS CREATED AND MORE RECORDS ARE AVAILABLE TO VIEW. IF YOU SELECT THE AREA TO THE RIGHT OF THE PORTAL THE RECORDS SCROLL BUT THE SCROLL ARROWS DO NOT APPEAR. I HAVE CHECKED FONTS AND BACKGROUND COLORS ETC... BUT NO JOY ! ANYONE ELSE WITH THIS PROBLEM ? THE SHOW VERTICAL SCROLL BAR IS CHECKED !!!

Can someone suggest how I might visually highlight the top three values in a scrollable portal? The portal displays 20 out of a possible 100 records. The "top 3" would be the top ones out of the 100, so at any moment, all or none might be displayed. One alternative I've thought of is to have a script sort the Found Set and individually flag the top three values. The problem is how to trigger the script when there are changes to records. Any suggestions will be appreciated.

Hello Another strange problem. I have a portal that display Lists of line item. Many prices come from calculations, When I open my file and look at the portal, the calculated result show $0, when I click on the field the price come back. The summary field don't display the calculated price until I click on it. I suppose it come from the unstored calculation that generate the items prices. I can't store them because they come from other calculations. How can I solve this problem? Is there a starting script that I could build to solve that problem? Thank you

Hello I have a portal that can be access from a menu on top of it, wich display different categories (to sort the items). In each categories I can add items into the portal using a script. I do not want to allow the creation of records from the portal. I prefer a script because it goes to the related LineItem to get some variable and sets some fields first. Everything goes very well except when the portal is empty. Then I can't get last field information (of course) and I can't find the right way to tell the script something like: if the portal is empty just create a new record in the lineItem. In other words: -my script goes to the last portal row and col…

After much puzzlement I am asking for help. I have a portal that works normally in one tab and doesn't work in another tab in the same layout. I just copied and pasted into the other tab. I even pasted it outside the tab so I've got one copy in the tab section and one right next to it outside the tab and the one outside works (displays all related records) whereas the one in the tab only shows one record. I give up. Help please :0

Hi guys, New to this forum and this is probably a simple question to get answered but here goes: I have a portal with 2 rows and on each row I have a 'Google Maps' button. What I would like that button to do is grab the data from the 'P/Code' field and then goto the Web viewer layout to display the Postcode data on Google Maps Now the way I have it at the moment works fine for the 1st row only, I cannot for the life of me get it to grab the 'P/Code data' from row 2 or 3...4...5 etc I have tried quite a few scripts and calculations but must admit get lost in the math Image of portal rows: thanks, cheers, Martin

I have three databases/tables that all reference each other... a Line Items table with a calculated Quarter field (dependent on the date that the record is created) a Quarters TABLE that automatically generates a new record for each new quarter in the Line Items. a Client table with a list of clients. The clients table is linked to the Line Items table via Client ID. In my Client Database i am trying to display a Quarters portal that lists out quarters that Client has done business with us in, and show a sum of line items for each listed quarter. I am having trouble doing this. I've tried every which way but can't seem to get it. The best I can do …

I currently have 2 files: Projects and Quotes. In quotes I can add line items, which are based on value lists, if I select from this value list, the field called "cat_a" will fill itself with the number (e.g. 5), see here: http://robin.saestudent.com/Quotes.png When I select 5, next to it, it will also show the second value from the value list (or the name of the item). Now in Project, I have a relationship to Quotes so I can link to the quote as well and adjust it. However, when I import my value lists from the quotes files, and I select it in the portal, it will look like this: http://robin.saestudent.com/Projects.png In other words, the second value of t…

Hi People Is it possible to get a vertical portal, instead of the default horizontal format in FMP? I've got student assessment results that I'd like listed vertically by attempt. So x axis would be "attempt #" and y would be "question #". The resulting data would therefore be result. Any ideas? thanks Cory

Can some look at my code.. I have in view 2 records in my portal Attach 2 images 1 looking at userlayout screen other is the code to print or combine format of invoice to single field.. The green screen on very right.. is missing the 2nd or $40 item Code on right resultant only showing the 20$ item from portal first line as seen at green right most screen.. missing the 2 record? ...I am learning by doing.. stepping through its not looping back . fyi, my portal records are not sorted.. (want them in order entered) TIA Rod

Fairly new user here. Any way to do this? I want to display a small jpg from a web address in a web viewer, but have the viewer get the address from portal rows 1 through 6. I can get the first web viewer to display for the first row, but do not know how to match up the 2nd through 6th web portal rows to dispay in the individual web viewers 2 through 6. 1. Portal has 6 rows visible. Each row field data is a web address. 2. Created 6 web viewers on the page. 3. Have each portal row assigned to display the web page in a different web viewer. Using FMP 10

I have a portal showing a group of records with the following fields: title, description, serialNo, and versionNo. I don't want to show all the records though. I am trying to filter this portal to only show the most recent version of each title. This can be determined by finding all the records sharing the same title and finding the one from that group having the highest versionNo. Been looking to crack this for hours now! Thanks for your help!

Hi All, I have a portal that shows a list of Jobs. I have calculations under the portal that are based on the records listed in the portal. Each row / record in the portal hase a checkbox. When the checkbox is ticked the Job is included in the calculations, unchecked and that Job is not included. My problem is that the calculations don't recalculate until I click out of the portal. I have tried setting up a script trigger that goes to another object on the page, and I've tried having it refresh the window but it still seems like the only time it recalculates is when I cklick outside of the portal but not on any field or object. So I am looking for some advice on how …

I've been searching everywhere but can't seem to find any recent fix for 'portal pop.' Portal pop is where you have a long list of records on a portal list with a scroll bar that - the moment you click on a record somewhere down the list - the list resets back to the top again, very annoying! Can anyone help me with this or point me in the right direction? Thanks so much.

I have a 2 layouts; MainLayout is called INPUT and has several tabs Each tab has a portal One tab is called Add Transactions and is named accordingly. I wrote this script; [color:red]Set VAriable [$$portalrow;value:Options::optionid.pk /* This line captures the current portqal row */ Then there is some code that does a 'find' If [get [foundcount)>0 Show custom Dialog ... If[get(lastMessageChoice=2) Delete all records Goto Layout ("Input"...) Goto Object [Object Name: "Add Transactions"] Goto Portal Row [select;No Dialog;$$portalrow] Delete Portal Row [No Dialog] Else ... [color:r…

Is there a way to show multiple records in 1 portal on a single layout from multiple tables.? Thanks Stu

I have an Order Layout with a portal to an Order Line Items Table. Certain items are "kits" where there are other items that are members of the kit. When a user selects a kit and enters a quantity the Line Items portal automatically creates the new rows using the kit items information and appropriate quantities. What I want to know is if there is any way to prevent just those rows that are members of the kit from being edited directly. Specifically I don't want the users changing the items or the quantities.

My problem is two-fold-I have a parent and child database establish. In the child dbf--there is a narrative text field called contactrecord-it expands with the users input (which can be long). In the parent database, I created a portal to pull in all the related records so the user can view all their contacts in one place. How do I make the "contactrecord" input field expand and shrink as needed in the child database? I also include the fields of date and time in the portal. How do I make the portal field expand and shrink based on the childbase field? I also include the fields of date and time in the portal. I am a beginner in programing the scr…

UPDATE: Well this may be a first: after posting I disected 6 different postings and took a little bit from each (none related to containers) and made this thing work, or it seems to work anyway. I have a portal and I have a container, Photo 1. I have a button to insert a photo into container 1. All is good for the first portal row. Now I go to portal row 2 and enter data and then click my button to enter a photo into container 1 on row 2. But it shows up in the first portal row in container 1. How do you keep the photos in the current portal row? I have tried to follow what I thought my be similar from another post: Set V…

Ok, this one I need help with. I have a start date and an end date field in my portal row. I would like to create a calculation that will show a message (lets say 2 days out “ Injection Due”) And if todays date is greater than the end date “ “ (blank) I can do a case statement but it only works on the first portal row…how can I make it portal row specific? Thanks, Jim

Hello Everyone, I am a FileMaker newbie. But I have been a programmer for over 25 years. I started with Basic, to Clipper to VB. I have also experience in MySQL. But my question is this: I have two (2) tables, Chart of Accounts (which has only 3 fields) and Beginning Balances (which is related to the Chart of Accounts via AcctCode). So obviously, this is a one-to-many relationship. I already have a solution where you browse through your Parent Table, one record at a time, and automatically view the related records in the portal. But since I am only working with a 3-field table, I was wondering if I could browse the parent table in a portal, and as I mo…

I have a Table A and related with Table B. In Table A layout i have a portal with Table B records. Portal fields are ID, Full Name, Date. I need to sort the portal records by name, id and date in ascending and descending by some button action. (ie) Toggle the sorting of portal records. I have finished this task by creating many tabs and placing the portals. Sort ID by ascending in one tab and descending in another tab. Please help me to find a solution using any other ways other than tab idea.

By default the portal sorting option is available in the "Portal setup" Dialog box. It's working fine. But i need to write the script for the sorting the portal fields. When I'm click the field name in first time record will be ascending and second time the record will be descending. Can any one pls help to solve this issue.. Thanks for your time to read this..

When showing a customer record, I would like to grab the last 5 invoices for this customer and display them in a portal. What is the best way to accomplish. The idea is to keep the results small on this "top 5 invoice" portal (no matter if the customer has thousands of invoices). Thanks, Rich

Hi - I have a simple portal with two fields ( and ), sorted by , related to the Parent by . In the Parent, on the same layout as the portal is displayed, I have two other fields ( and ). I want to autoenter by calculation the contents of the first portal row date field into . I also want to similarly autoenter the last portal row date into I know it is (probably) possible to script this (via Go to Portal Row and std. logic from then on ...although I am still working through that solution with no satisfactory result yet) but it seems operator input will be required every time a new record is displayed to transfer the data. Autoenter specific portal …

client would like an option to move records in a portal up and down the list. Has anyone see a clean solution for this?

I have a table that contains multiple entries for a given ID. One of the items is an status field that shows one of two states ("New" & "Experienced"). I have a layout that has this field, and it only shows the first record's status field. How can I get it to show the one from the most recent (last) record? TIA