Portals

Apologies, I'm new. I have a database in FM7. I would like to exclude some records from showing up in a portal, but have those records that don't show, appear in a portal on the same page. Basically, we send out STUDENTS assigned to a SITEGUIDE to make VISITS to different SITES, one table for each. Anyway, there are different kinds of visits, but they all are recorded in the VISITS table--each record has a VisitID, StudentID, SiteGuideID, SiteID (pulled from SITEGUIDE). What I want is something akin to 'Show all Visits except attribute:TypeOfVisit="Special" in the first portal; in the second portal show ONLY Visit records where attribute:TypeOfVisit="Spec…

Hi, I'm working on a program for quoting. Whenever anyone quotes a product thats been quoted in the past I want to have a portal showing all the previous quote numbers for the product. I made a self join table and it seems to work great except that it shows the current record as well as the previous ones. Also even if a product has never been quoted in the past the table shows 1 entry with the current quote number. eg. Someone is working on quote 18050 for product X. Product X has been previously quoted in quotes 17865, 16555, and 18001. In the table I made to show previous quotes for the product it shows: 17865, 16555, 18001, and 18050 (but I want to exclude 1…

I have a self join table called banking which has two layouts, one layout is called "transactions" which lists transactions like a bank statement and contains and another layer "transaction detail" for modifying details. The portal displays correctly in transactions layout but I have added a button which has the value of go to related record. The problem is when clicking this button it just goes to the transaction details layout but it does not go to the record selected from the portal in transaction. I know this problem is related to the fact that this is a self join but im a little stumped on how to put it right. Any help you could offer would be very we…

Hello everyone. I am a newbie so please bear with me. Here is my problem. I have a db called actor. It contains the actor name and gender (male or female). My goal was to display 2 portals (one male) (one female) where user could select actor or actress and then go to the corresponding record. Reading other post on this site i found what i thought was a great example of a self join that even i could not mess up (but of course i did). I created a field called gender with a selection of "Male" or "Female". I then created a g_male calculation field ="Male" and a g_female calculation field ="Female". Next i created a relationship Actors( i thoug…

I am having a problem with a filtered portal in an app I'm developing. When a user creates a new record in this portal, FM over-writes the user-entered value in one of the fields (a field involved in the filter). I understand why it's happening, but I need to find a way to beat it, if I can. Here's the situation: I have a portal which users may filter by selecting a value from a pop up. That selected value is then used in the portal relationship to select only matching records. The pop up values are from a user-defined vocabulary, let's call them UserValue1, UserValue2, UserValue3, etc. I allow the user to select any one of those values or to select "All". …

I have created a portal which shows details of ads booked for specific clients. ie the portal is based on a client relationship. I want to be able further filter the portal to only show records for each client between particular dates.

I'm developing a system, have 2 portals on a screen, and need to copy data from one portal to another (Purchase order request Line items (POR) to Invoice Line items). I have a global field to input all the POR portal data into which I then parse into the proper fields for the Invoice line items. The first row goes across properly. I then "Go to field" in the POR portal and try to set the proper portal row by a calculation, but the Invoice Line item portal remains active, and the set field calculation for the global parser reads the first line of the POR portal. Any ideas are GREATLY appreciated. Systm info: Mac OS X.3.5 FMP 7.0v3

I am using Go To Related Records (GTRR) to toggle between files using a button in a portal. The first click-through shows all records (bad). The next click-back shows just the selected set (good). Each subsequent click-through show just the selected records in each file (good). How can I make the first click-through show only the selected set? I'm using a script, GTRR w. Show Only, external script to go to layout and mode. Thanks for any input Mark Microquest

How do i? Portal to display First 100 records - Sorted by Date Desc, So i can get the latest records from the database. Currently I create a layout that will pull all the records, takes a long time. Thanks Thanks....

I am attempting to hide and show buttons on a list view layout using a portal. The portal relationship it a self-join, eg. Display Button = :Display Button. The Display Button Field is a calculation that evaluates to "Yes" when all the criteria has been met, and "" if not. The portal hides and shows the button but not for the record that has just been updated by another user on the server (5.5). The button will only appear if you change layouts and return to the list view. Is there any way to have the portal appear without making the user run a script? The relationship is true, but the portal just doesn't appear.... am I going to have to use container fields to hid…

Anyone know what happened to this pugin. I can't find it on the WIM site.

Hi, I am wondering which technique to use for the following desired goal? I want to track incoming orders of groups of video tapes. I would like to create a new record for the whole group (rather then a record for each individual tape). This is all easy enough. But then I want to also have an individual record for each tape so that as staff members work on the tapes they can log their data. For example if I receive 15 video tapes I would want to create a PO containing data and instructions from the client in this record for all 15 tapes. Then 15 different people will work on one tape and will add unique data such about that particular tape. Some of the data will…

The deal is this, I use a filtered sorted portal on the left side of my layouts for a menu. What shows in the portal depends on a match between the "menuName" and "gMenuName" a global. The portal sorts on "MemuSort" a numeric based with numbers for sort position. Always worked in FM5-6 but in FM7 with the sort is set to "MenuSort" it does not. In fact if you open the portal properties and "reset the sort" it will sort but only stay sorted until you leave the layout, but upon return it is again unsorted. Is this just a bug in FM7 portal sort or am I missing something?

I just want to enter text in Field A of Record A, and have it appear in Field B of record B... I have tried and tried, but I just can't grasp this:(

Recently I built a DB using the FileMaker Business Tracker solution as a template. (I'm just at the beginning) but I can't solve a problem using a script on a portal. This is the situation. On the "Company" layout I have a portal from the "Contact" table that display the name of people working for the company. My intention is to click on the contact name on the portal in order to get more details (phone, mail, email etc). To do this I imported the script from the FM Business Tracker file and adapted it to my settings. The Script works fine. The Contact Details windows open but the record displayed is always the first one from the contact list. I'm sure that some pa…

Hi, When viewing a web page using Instant Web Publishing via filemaker pro 7.0v3 a portal I have showing info from a related file is blank. If I view it in the database itself it is fine.. Any ideas why IWP is showing it blank?? Beastman

I must be doing something wrong with my relationships because the portal doesn't seem to work. Under the chapters, I am trying to list the members of that chapter using the portal. File attached Thanks Dave

hi there, I just started using FM pro 6 about a week a go. I created a DB Now I want the key field to be an Auto number, so I go to the field options and set it to "serial NUmber" START 1 and incurment as by 1. This works fine we I use it in the browse mode, however when I go to I.E. to access the database this does not work. I tried this on two different computers the same issue. ALso I haveing the same problem with a script "I made a button that put the data auto in a given field", again this works fine in the Browse mode but when I go to I.E. or even Firefox the script does not work. Your help will be greatly appriciated.

I am using a portal to create records related to the main db record. Displaying a new record in the main db causes a blank record from the db in the portal to be displayed. Entering info in the portal creates the record in the related db and causes a new blank to display. Each time you enter info into the blank a new blank is created. The "blank record" does not actually exist in the related db. The problem is the blank record displays whether I want it to or not, even when I am printing out a record from the main db with its associated records from the related db in a portal. How can I turn off this "feature". While entering records, this behavior is great, but whe…

I have a system printing invoices for customers. Each invoice contains two portals, one for part and one for labour. Each portal is 8 rows high. When viewing on screen I simply enable the vertical scrollbar to allow more than 8 entries. However, I'm now creating my layouts for printing and can't figure out how to make the portal increase it's row count to allow all the extra portal rows to show. Does anyone know a way of doing this? Thanks

we've had to go stand alone with our student database until we upgrade to servce status... in transfer, our main student file (stud.file) is having difficulties backing up to original backup file... no problem except our main stud.file is the db for our teacher timetables (teachtime.file) and also calls on our teacher file (teach.file) for info... so our portals in teachtime.file no longer pick up info from stud.file... its somehow switched over to looking in stud.file.bu for its info (and this file no longer works!)... so I changed the lookup relationship file from stud.info.bu to stud.info thinking this would work... and now the records in browse mode in…

I have an FM7 file with a project table that conditionally relates to 4 other tables resulting in 8 different portals that I am trying to print. Because the results come from different tables, I am printing from the central project table and having very bad printing results when sliding portals. The first couple work then it fails compeltely. I know printing and sliding portals isn't optimal, but don't know of another solution off hand. Anyone seen this? HELP!

Hi Everyone, My question is about producing a portal, which filters out all but one particular type of entry in a field, but still allows data to be entered via the portal - as if the filtering wasn't there ... kinda similar to LAGirls enquirey just v recently - but not similar enough, i think, as the answers there don't work for me - or answers elsewhere including the samples file either. What i've got: parent: PEOPLE child: CONVERSATIONS 1 (people) to many (conversations) relationship (via ID_PERSON) So PEOPLE file has in it: ID_PERSON NAME and CONVERSAITON file has in it: ID_CONVERSATION CONVERSATION_SUBJECT ID_PERSON The…

Hello, I am trying to build a simple application that assigns points to people according to certain activities and at the end it adds the points for each one of them and ranks them from highest to lowest. So far I have not been to do that last part. I have tried many things, playing with portals, scripts with no luck. The problem is in the Reports Layout, I deleted all my trials/tests, to have a cleaner view. Any help would be very appreciated Pablo Points.zip

I have a sales file for 2 types of sales. Type 1 - Monthly sales, Type 2 - Marketing Sales. In another file I have a portal showing both Type 1 and 2 sales and another portal where I want to show Type 1 sales only. I have a different relationship for the 2 portals as they need different sorts but I cant seem to show only monthly sales in the second portal. I have read the "Only show certain records from a portal" but it doesn

I have two databases, Parent and LineItems. I want to be able to display a selected description of the data in a portal with numerous items. I then want to display all the information of one record in a large, single record portal. Finally, I want to show the user which line item is select in the portal by highlighting the portal row. Currently, I am setting a number field with a Max( LineItem::Serial_# ) + 1 and a decsending sort to highlight and dislplay the current record in the single portal. It does cause me a little grief when a line item is duplicated or deleted. Does anyone have another approach? Thanks

again a beginner's question? good methods to force a ###-##-#### for SSN and ###-###-#### for phone numbers on layout i'm sure you all have a bunch of answers, but i am a beginner i thank you in advance

Hi All, I'm going blind....I thought there was a function that gives the number of lines in a portal?? Not the current portal row. I am trying to stop a user from adding more then x-number of lines in a portal. If you have any suggestions...go for it, i'm all ears!! --Dan

I'm sorry, most of you will probably think this is a pretty simple question, however I just started using filemaker pro 7 for a university contact database i add a portal which has a relation based on SS#, i can add data and edit data in the portal however i cannot get the vertical scroll bar to appear on the layout. I follow the directions in the filemaker pro bible but it does not help me whats up with that??? is there a good portals whitepaper out there?? whats the answer

I have a layout with a portal that I'm trying to publish with IWP for Entry Only. When I view it on the web, I can only add data to one row of the portal. That one row works great and publishes the data to the right database. I just can't get it to give me another row. Am I just doing something wrong or is it not possible to enter data into multiple rows of a portal with IWP? (I'm using FMPro 6 with Mac OS 10.3.5) Thanks, Amy

I am trying to use a portal to so me related records from a table as I type into a global field. Example if I type 'Da' in he global field i'll get all the records from my user table that have a name of Davis, Dali, Dance.... Table 1 is Users has a field for ID, First name and Last Name (other fields too but not important here.) I have another table lets call it User Logs their main are relation is via the ID field. I've tried making additional tables and relating the global field to the ID number and many combination of that but i just cant seem to get it working. Any suggestion to get this working would be greatly appreciated.

I have a database that tracks education-related Personnel, Agencies and Affiliations (the join between a person and agency). In an Affiliation record, I track the role(s) that a person performs at a given agency. I store the roles in an 'affiliation role' table and the data is viewed through a portal (in the main Affilation screen). Problem: At an agency, a person generally fills more than one role (principal, administrator, school board chair). If I do a search in find mode, I can only enter one role in a portal. I can search for principles, or administrators. What if I want to enter more than one role so that I can find all of the people who are principles AND…

Im stuck! I have been try to set up a simple portal with two tables but Im doing something wrong, I set everything up but the data never appears in the poral area. Anyone know a good tutorial? thanks

Hi, I'm new here and new to FM7. I have been using 5.5 for years now. Anyway, I've been asked to design a DB using FM7. I have a few portals that contain numerous fields. To make it easier to read I turn on the Alternate background fill in the portal setup. It looks just fine until I use the scroll bar. When I start scrolling, the portal field boxes are no longer transparent. That gives me ugly white boxes on top of the background fill color. I'm sure to get complaints. Is this a known bug? I would like to be able to scroll without the portal fields reverting to a white background. Can it be done? Thanks for the help, Tom

I have a portal that is from another table that has ranges and prices for miles... They are linked together by the parents ID and both have recordID.. Example... ----------------------------------------- | (From Miles) (ToMiles) = (Money) per (Miles) | ----------------------------------------- all of the ( ) are fields in the portal.. The user can basically add add as many lines as you want. Heres my question.. I need to make sure the mileages dont overlap or theres a gap between the different from&to mileage records. Is there a ez way of doing this? Im also trying to figure out if theres a way to get what record someone is on in the child fi…

Am new to using portals. Have just upgraged to vn 7. Is it possible to click on any line in a portal and get back to that record whose fields are displayed on that line in the portal? I am assuming some scripting is involved. Where would it go? Frank Bugeja

Hi, I need to know if there is a way to turn off selection of a portal row when the background is clicked. I have a portal that takes up most of a page and has a layout inside of it. When I click in the back ground of the portal, it selects that portal row and changes the colors. I need a way around this. I have tried putting containers in the back ground that do nothing, but I can not get around it. Thanks

Can anyone help me to get some information to auto-enter in a portal. The information needs to automatically come up based on what was entered in the last field is that possible??

I am displaying search results and want to get around the limitations of 5-items in a list view using IWP; do I want to use a portal, or is there a better way to do this? If it is a portal I should use, are there any (simple) guides to doing what I want to available online? Thanx, P.

My portal rows each contain a small Delete button. Aesthetically I can't stand seeing a Delete button on that last, empty row that exists because of "Allow creation of related records". However, since I do need to create records in the portal, I'm trying to find a way around the "Allow creation of related records" option for the portal. My best effort so far has been to store the value for the related field into a global, and call a script in the related file to create a new record and fill in the related field. Back in the main script, I then GotoPortalRow[select,Last] and fill in the remaining fields. A new, blank record does appear in the portal, but GotoP…

I'm trying to have a portal show only the unique records, instead of every record, but not having much luck. Here's what I've got: Databases: Orders - main entry of order, has portal of Items which are related by Order Number. Items - each separate item in the order, includes the vendor and item ID. I want to create a portal that will show all the vendors used on an order as the same vendor can be entered on the order multiple times. I did manage to make a calculation which returns all the vendors from a relational value list. But I can't seem to relate this calculation in order to show the values in a portal. I got this tip from an earlier post, but m…

I am building a simple database that has 2 main layouts, the first is a control panel where you would enter data and the second layout is the list view showing all the data entries. My problem is that i would like to make a portal on a section of the Main layout where data is entered and have a portal that shows the list view in a portal window, so i don't have to switch between my main entry page and list view so all can be displayed on one page, that's the goal!! Is it even possible to use a portal in this manner? Someone please help! I am using filemaker 6 running on os x panther

Is there a way in FM7 that you can create a button to sort a portal. I know you can define a sort when you create a portal, but say the user what the change to a pre-define sort (ex. alpha based on lastname). Thanks for your help!

Anyone know how to make a portal in FM7 reset on exit of the portal like it did with FM6? Meaning, if I create a new entry in a portal via the bottom row, it stays there until I exit the layout and then come back. Used to be (when I walked to school without shoes, through 3 feet of snow and through Indian territory) in FM6, when you exited the portal by clicking in the open, the portal would reset and your new entry would hop to the top (if it was sorted descending via created date and time in the relationship. Now, it just sits like a lump at the bottom. Is there is a script solution to reseting the port (other than hopping into another layout and back?

I have a layout that has two portals. Both portal relationships are self-joins to the table that the records reside in. None of the fields are editable on the layout, and when one person is already on that layout it is locked and no one else can even scroll through the portals. Any ideas other than placing the portals on a layout not in that table (i.e. no self-joins)? The only goal I have is to be able to have everyone be able to scroll the portal rows no matter if 1 person or 40 people are in that file.

I am having some problems with getting a find to work within a portal and I am not sure what I am missing. I have two tables, workstations & unassigned licenses. There is a relationship between the two tables. I have a portal on a workstations layout that is showing the unassigned licenses data. When I enter find mode and put a value into one of the portal fields and hit find, it returns all of the data in the portal not just the data I searched for. I tried switching to the unassigned licenses layout and performing the find there, then switching back to the workstations layout but that did not work either. What am I doing wrong here? I should be able to do this…

I've been looking but I can't find a portal filter example that works via a date? Can anyone help Thanks

Hi Everyone, I have a file (Invoices) with many products for each invoice . Each product have a name, price, quantity ... and stored into another (and different) table (LineItems). These products (LineItems) are into the "Invoice form" (Invoice table) through a portal. Unfortunately, when I'm trying to search for products in the "Invoice form" through the portal (by Find Mode) I got many results that have no common words with the search criteria (same problem with numbers , Quantity, Price) . A search into their table layout (LineItems) will give the good results. Anyone have an idea Another thing : all the records have been imported to filemaker 7 (by T…

Enclosed is a sample of my database. When using the Admin User the POS window refreshes just fine...when using any limited account user (Even when you give the limited user full access to everything) the portal window fails to refresh properly. Thanks, Greg POS_sample.zip

Oh I looked, I did. For the past three hours and can't find something like this. I have employee table (staff activities) which is connected to activities (activities found) on many things. This is so I can filter the portal. It's very pretty and works great, filtering by date range, types, status etc. I call it activities found because it searches for the employee in the employee (staff activites) so only their page displays. Staff activities is not yet attached to our customers. Problem: When I click portal row with Go To Related, it only lists one. When I try to script 'starting from' staff activities, it doesn't give me a customer layout to go to because…

I'm setting up a guest list for each day of a tour. I have one portal that contains guest names. There will be a different number of names for each day. How do I set up a print layout to print the portal across a page breaks?

Hi there, Someone here know if Filemaker Pro 7 now have a better and easier way to be able to make the people directly add data on the TOP ROW in portal? I didn't see any change at this part, i'm surprise. I'm the only one? thx fred

I have a layout that has 5 portals on it. Each one is dependant on the previous portal as you work across the layout. As you click on a row in one portal a script is triggered to setting a key field that populates the next portal with related records for that particular item ... it also changes the background colour of the clicked row to signal it is the current selection. This all works fine. The problem I have is this. The number of records in Portal 1 stays pretty much constant. Portal 2 may fluctuate but never really exceeds 5 items. So the first two portals are working fine. However Portals 3, 4 & 5 often have more records than what my layout will a…

Probably a dumb question but is there any way to adjust the portal row height or spacing?

Sigh, this is really frustrating. I create a SIMPLE portal with a relationship to a remote database (that is password protected...but it's not asking me for a password). It works WONDERFULLY until I close the file. When I reopen it, poof, the portal is empty. I know this is really vague, but any ideas?

I need to know if it is possible to set up two columns in the body of a report and then have a portal populate into both columns.

Is it possible to build two portals which are inter-dependent? That means, when the record of one portal is changed and the other portal will display related record.

Hi everyone. I'm working on developing a volunteer tracking system for the local chapter of Habitat For Humanity. What I'm doing is building a database that will log volunteer hours, for the use in grants and recognition. i'm pretty good with filemaker, but have never used the portals. what i want to do is make the portal a time log of each visit, where they were, what they did, and for how long. i can get all that stuff working, but i can't get a new line to show up for the next entry! what am i doing wrong? do i have to set-up a script to do this, or is there a simple setting i'm missing? an example of what i'm talking about is in the "time billing" template…

Please explain how one gets and uses the portal row number. I have tried: field "Row Number" type number with auto enter calculated entry Get ( PortalRowNumber ) result returns numbers incrimented by one but the first row which should be one is some other number and field "Portal Row Global" type number with auto enter calculated entry Get ( PortalRowNumber ) result returns the number 2 for every row.

I am trying to create an iTunes-like interface to act as a front end to several databases (Magazines, Issues, Competitions). The idea being the user can click on a portal displaying Magazines which will then create a key for the next portal displaying the years that magazine has been published. This continues onto Issues published in that year and onto competitions run in that issue. I am trying to achieve a drill down like action where the user by clicking is filtering down the list of records. My problem is that when the user clicks on the Magazine Portal Row all the issue records for that magazine show in the year portal. Meaning there are duplicates displayed ins…

Hi there, I (re)built the FM example of the webstore which comes with the Filemaker 5 package.

I'm creating a db in Filemaker 7 for me to track musicians who will be performing in a worship service for church. I am working with 2 tables, (1) Music Schedule and (2) Music Schedule line item. I am trying to create a portal in the Music Schedule db to view the following in columns. Service Date Prelude Offertory 1/1/204 John Doe Mike Jones I really would like the prelude and offertory to be the same field from the Music Schedule line item table so when doing searches, I can do so in 1 field. How do I view the same field under 2 columns and yet tie it to 2 different categories without having it display in 2 portal rows with the same date? Thanks for you…

I call a set of records in a portal by defining the rel Date::Date , having a global that allows me to enter any date I want. Here's my problem: Once I have all of the records defined, I would like to filter more specifically, and to perform some calculations off of the displayed records. For instance, I would like to display in my portal records that are from one day (Date::Date), but filter those to show only the records that are in a specific facility (Location::Location). Is there any way I can use multiple relationships to do that?

I posted this message in the FMPro 7 General Forum as well.... I am not using a script to create the new portal records so I cannot use the Exit Record command and I've tried using a calc field behind the portal and that does not work.... I am displaying a portal window, which when a line item (UPC) is entered, it (the UPC field in my Items DB) does a lookup of an inventory item (in my Inventory DB). When using the [Full Access] log-in, the portal window refreshes after each line item is entered accurately displaying the new line item. When using any other account access (i.e. Data Entry only), the portal window fails to refresh automatically after each line ite…

Only the first row of my portal row (red text) is giving the right calc I tried a refresh - any ideas anyone? Thanks portal_prob.zip

I have a button placed in a portal in layout mode, which duly appears alongside each record in browse mode. I want to attach a script to the button that opens the relevant record in a new window using another layout, but no matter which instance of the button I click my script just opens the record from the first portal row. Any idea how I can make the button relate to the record contained in the same row?

I currently have a layout based on a 'Membership' table. I have a portal in the layout, which displays parts of a letter I have sent to that member. I have a button that, when clicked, takes me to the full record of a given letter. Fine so far... However, on my layout, I want to only show one particular letter at a time. To try and achieve this, I've set the portal to only display one row at a time and I've used a script as follows: Go to Portal Row (Select) This works fine - I type in the ID field of one of the letters and it highlights / displays that record in the portal. HOWEVER - if I click *out* of the portal, it defaults back to the first record…

Ok, I have a script that creates a new window and takes me to a layout with a portal on it. I want it to also create a new portal row. The portal is formatted to show 1 row at a time. When I go to this layout, how can I have the script create a new portal row so a new row is waiting for the user to enter in data? This seems like it should be simple but I can't find anything on it. Any help would be appreciated. Thanks! John

Attached is a most interesting example, showing that when a field is white, it does not update the relationship. The database has two tables, TimePicker with fields Time, gDate, gUser and cOne. TimePicker has four records each with a different time. The other table, Appts has Time, Date and User. The layout in questions has a portal with TimePicker selfjoined with cOne, TimePickerByTimePickercOne to show all the times and another relationship to Appts, ApptsByTimePickerDateTimeUserByTimePickercOne. One can easily make new appts but when you change the date in gDate, only the blue (transparent) or red fields automatically update, not the white fields. Any suggestions…

I was after some advice on a problem I have. I have a database in which teachers are developing a Unit of Work. Once the Unit has been created, they must input all the activities for that Unit. There may be a small number or there may be many. I decided to have a portal in the main file that relates to another file (activities) sitting off by itself. The relationship allows teachers to input as many activities as they like and I have created a script to print the activities in the activities file. The problem is, the relationship doesn't work properly, the activities go into the portal, but when you go to the activities file and sort, it only prints the first…

Is there a way to create a new record in a new file for a found set (of records in another file)-- do you use a portal?

I have two tables suppliers & purchasing each have their own layout, I have a portal on suppliers which lists all records relating in purchasing, works very nicely. But what I want to do is create a new layout with a portal on it that will list all records from purchasing not just records that are related to suppliers suppliers. Any assistance with this would be greatly appreciated. Many thanks

Can you have a portal within a portal, having the second portal related to the first.

Hi everyone, I have a FM7 doc wih 2 layouts. One for editing and one for printing/preview. In the editing menu i have a portal with an unknown number of rows. I want to print into the Printlayout the portal's rows and just after print another lines from another field (not in portal). This problem may be solved by merge fields (<<FieldName>>). When I have a repetition field and another std field, I can print the lines like that: <<RepetitionField[1]>> <<RepetitionField[2]>> <<RepetitionField[3]>> .... <<RepetitionField[100]>> <<OtherField>> In this solution, The empty…

i'm building a database for touring bands... each record in the database is a specific show date. right now, i have a portal that shows related records by Artist, filtered by Status (whether the show date is confirmed or not confirmed) and by Date. the user enters in the range of dates to be shown here's the tricky part (tricky for me anyway)... as the user tabs through fields in the portal, i would like the new records that are created to auto-enter an increase in the date by a value of one day, using the previous portal row as the reference. for example, if the last portal row being displayed has a date value of 12/04/2004, i want 12/05/2004 to automatically appe…

Is alternate background fill working in FM7? This is the first time for me to use it and I can't get it to work. The background is grey where there is no data. Ivan

I'm a little 7 brain twisted! I have 2 tables: People and Groups - I've placed a Groups portal (Cartesian) on the People layout. In groups I have GroupName, PeopleID and cPeopleID. PeopleID is a comma delimited list of group members and cPeopleID is a calc field that shows the person viewed in the parent record is a group member (shown by a check box). PeopleID populated normally via a script but I can't get cPeopleID to calculate as desired. I'm using PatternCount(?;?) and tried a variety of options with and without new TOs but just can't visualize it and am not getting lucky! Thanks in advance.

I am creating a new recipe in a portal on the persons layout. Only the name of the recipe is created. From here I want to go to the layout where information is added. I have tried a script attached to button: Commit records/request Go to related record (show only related records) also tried it without show only The script takes me to the correct layout but always to the first record. Seems to me that I may need to do a find, but have failed to create a find that picks up the recipe name and finds itself in the layout. The portal is in the layout of the person creating the recipe and is related through the person key.

See attached. I have used a technique I found for highlighting a current row but as soon as you go to the row of another portal it lose its focus there. Is there anyway of making these portal stay highlighted as you move across them? Any help would be great Thanks mutilple_portals.zip

Hi everybody, i need help please i'm trying to create a simple membership database, where i can store the date when they create their card and when it will expired. and also, maintain the type of membership. if, they choose "family" then they need to fill out the groupInfo portal. Problems: 1. if they choose "family" in their first period of their membership, and renew it as "individual", the groupInfo portal doesn't go empty. 2. if i click on the any of the row (history portal), the groupInfo portal show the same list. what i want is to filter it out (family and individual). (i want it to works like the history layout) What should i change…

hi all~ is it possible to export portal records in FM 7? if so... how? thanks.

Hello there!... I'm quite new to FileMaker and I seem to have a problem with using portals. I'm sort of creating a prototype database system that would handle Fashion and Accessories. 90% of my tables are already interconnected with relationships. For one, I already incorporated a Costing Sheet Form that uses a portal for input, and also made another form to list all my costing sheet data(also using portals). I've used this method from one table to another (e.g. My Costing Sheet data gets used under my Proforma Invoice Form, where it attempts to passively capture related costing sheet records and place the data into corresponding related fields in my PI. What I …

My problem is finding a recipe item in a large set of records, 6,600 in total and displaying the found list so that the user, on the web, can select one item. I deem the table and list views to be too limiting. For example a search on chicken will return more than 100 hits. I am wondering if it is possible to: Create a layout that contains a find function and a portal. The find would return a list of portal row numbers and the portal would sort them to the top.

I would like to do the following and I am not sure it will work (I can't figure it out). I have a checklist of items that the user will click on as done/not done/or N/A. I have this list of items in a portal on a layout, as the layout contains other information and the portal just needs to be there, Now the admin of the system will add to, remove, change, etc., this list of items, and when the user creates a NEW checklist, these admin items will show up in the portal list. For example... List of items admin enters (let's say in a 30 rep text field)... Checklist Item 1 Checklist Item 2 Checklist Item 3 ... Checklist Item NN Now the USE…

Hello, I am currently updating a number of databases that use many to many relationships. I've made use of the pipelining portal to streamline and simplify data entry, but have run into a snag. I know this should be simple, but I can't figure out what I am missing. I have three files: Courses, Instructors and CourseInstrJoin. Each course can have several instructors, and each instructor can teach many courses, hence the Many to Many reln. Here's where I'm stuck. I need to place data in the join file itself because there are instances where I need to record a piece of data for an instructor for a specific course. Like hours of teaching, for example. How do…

I have several portals and they all do it. When I'm at the bottom of the portal and then scroll back upwards, it's like FM forgets where it placed its lines and they double-appear all the way up. It's so bad I can't even read the text in the portal. Only clicking down again will it clear itself. Is there anything I can do to solve this problem. It looks terrible. I searched and found similar problems but not this one. Those can't be fixed. Can this one? LindaG DAC

I have a Patient file displaying data from a Reports table and Evaluation table through their individual portals. Both Reports and Evaluations are related to Patient via PatID field. Evaluation and Report tables are related through Eval#. TempID is a global field accessed via a universal link calculated field _constant=1 Script to create Report record: set field Evaluation:TempID, Eval# go to layout Reports new record request set field Report:Eval#, Evaluation_constant:TempID set field Report:PatID, Evaluation:PatID The Report and Evaluation tables are related through Eval# because data from Eval is merged into the Report record. I know my Pa…

Newbie here! Hello All! Been using Filemaker for 3 days now so be easy on me.... I have 2 tables: photos and categories. I want photos to be a child of categories in that photos has a category field that I want to be a reference to the category table. I know that this can be done by creating a pop-up in the photos layout that gets its values from categories - but that is a poor solution if I ever wanted to edit the category list. I attempted relating the tables and creating a portal in the photos layout and it almost worked - but one problem still remains. I removed the "category" field from the layout and replaced it with the portal which is a pop-up w…

I have a portal that displays data from a field in another db (of course!) that has "name", "type of activity", "activity group" fields. I want to select data from the "type of activity field" depending on the "activity group", to be displayed in the portal. Do I set up a new calculation field in the source database that matches data to the "type of activity" or can I set up a script to do the same in the master database? TIA The Novice...Stephen K

I have a problem with searching in the portal rows. Some of the values are accepted and i get the result of my search but for some of them i get a fout which says " The difinition says that the field can contain only the numeric values,..." how is that possible? I don't have a field with a numeric value and for some of the words i don't get any errors! Can anybody helps me please? Thanks,

I am trying to do something that may not be possible. Any help much appreciated. In attached file is a list of cost (in the "data" layout), each assigned to a project and budget line. The layout "summary" allows costs for any one project to be shown in a portal (via a self join relationship) and the total cost for that project displayed below. All OK so far. I want to be able to show costs in a portal for the given search project, but summarised by budget line, ie there should be one line in the portal for each budget line for which that project has costs, and the associated cost value should sum all the cost items for that project under that budget line. ie …

Is there a way to prevent portal scrolls back to the top row whenever you click outside the portal? I am using FileMaker 6.0.

Need a little fundamental help. I've developed a database solution with one master layout file, and 4 data files. The master layout file contains only related fields from the 4 data files. What I'm needing to do is on one of the layouts in the master file, create a list of records from 3 fields out of one of the data files. Can I do this within a portal? Can I script a loop somehow? I'm not too adept yet at ScriptMaker, so be gentle. Thanks!

I am working on a new solution in v7. Created a portal with create new records property selected. I entered some records for testing, then selected one portal row item and chose Delete Record. At the prompt for "Delete this Record?" I clicked yes and it deleted ALL the rows. Is this the expected behavior? Or am I missing something? I sure did not expect to have all the rows delete. I tried it a couple of times to be sure I did not select delete all records.

How do I set up my Job Tasks portal so that I can create records from the portal? I've moved from system 5.5 to 7 and don't know if there is something different or if I just forgotten how. My Job Tasks portal contains a job number field which relates to the Jobs Record layout/table that holds the portal. I can create records from the Job Tasks layout/table and see it in the portal on the Jobs Record layout but can't get the portal to give me a new record. Help please

I'm having a problem with my portals. It's a total graphical thing. My data is fine, but when I use the vertical scroll bar to scroll down, the fields get messed up. It's hard to explain, but I took some screen grabs I'll attach. It seems the when scrolling down, the rows that appear at the bottom of the portal are getting some ghosting of the fields previously there. And when I get to the bottom of the list, if I continue to hit the down arrow on the scroll bar, all the rows in the portal will get populated with the data in the last row. Was wondering if anyone has had this problem? Archive.zip

How do you protect a file from being deleted after it is created? This is my configuration: Portal Setup- Allow deletion of portal records (not checked) Edit Relationships- When deleting a record in this file, also delete related records (Not checked) Still allows deletion of files linked to portal.

Hi all, I have two problems: 1) I am working on a document control DB and was wondering if it is possible to put a link to a document in a portal and make that clickable to open the file? I know you can click to open a file if the link is stored in a container. I was thinking maybe I can put containers inside the portal but when I do this, clicking on the portal row does nothing. Maybe format the portal row as a button and have a script find the link and open it is the way to go? 2) Can I show a report in a container or portal field? Any help would be greatly appreciated, Rich.

Is there any way to get around the limitation on the number of rows in a portal? I have a portal that lists a number of events for a fund-raising program for a non-profit, and they think they eventually may have many events. Do I need to artificially limit the number of events (only show the last 25 or so), or is there some way to dynamically expand the size of the portal? I think they wouldn't mind it being essentially infinitely long if they could scroll through it all. Thanks.

... In a portal, when the user just clicks on a row (not into a field), the whole portal row turns black/negative. I've been in the midle of training users before, and they just get horrified when they do this - it's funny to see how quickly they click out of it. I use LOTS of portals and don't want to do some cheesey work around where I have to cover each portal with an invisible button that scripts GoTo Filed[]. This works, but it's a pain to resize and move with every littel adjustment. So, has anyone else found a setting or trick around this?