Portals

OK...newbie here... I have been using FileMaker for sometime, but have never used a portal. Besides the bad instructions on the filemaker help menu.. can someone please explain the benefits or purpose of a portal. I think it will help in my app. I am trying to create a schedule of tasks for various days of the week. I need a popup menu which will list the next three weeks worth of dates and also need a list view which will actually create the schedule...along with summary fileds for each date...

I try to get this work, but it seems pretty complicated ... I like to show -in a 'self related' (timesheet)record- a portal with a list of records from the EmployeeID that is currently active in the browse mode. If that was the problem, I wouldn't have a problem .... But I like ONLY to see a list of records -in the portal- from a partical day, based on a 'date' field. Is this possible?

I've just read an old post on inventory where it was said "Next, you never print from a portal, print the P.O. from the P.O. Line Items file".Live Oak 09/15/02 12:54 AM May be I didn't understand. If not, I'm in big trouble...Let see I use portals for every Order Form, Invoice, Quotation,.... In summary, for instance, to edit an Invoice I use datas from - A Product DB - A Client DB - A Central DB that compills all the information (quantity, net price, customer orders N

I have a Portal that has seven rows, but continues beyond that with information. If for example there is 15 rows of info, i want to be able to print all of them. Right now it only prints what is displayed? Am I going to have to write a script to complete this task?

Hi, Is there an easy way to get a summary that adds a certain field of all the related records? Or even through a portal to show a summary of all the records by shown in the portal? Thanks, Anthony

I use a french version of FM. So it is quite difficult for me : - to use the good terms when posting - to understand all the answers (particularly with script definition...) As I want to take max profit of my visit here, does anyone have an English guide of FM (.pdf) or a URL where I could find this documentation. Comparing the two guides, I would probably understand better...and quicker.

I can't get this to work; I want to see -in a portal- only the records from a customer (from a related contacts file) that have a certain checkbox selected, let's say the checkbox 'active'. So I only want to see the records by 'companyname' and checkbox 'active'. How do I do this?

Hi, There is a layout of a master file that displays 7 portals (of 7 related files). The rule is before I am able modify any data in of these portals, I need to click a button to unlock/lock, the script runs behind this button is to check some kind of verification of all lineItems of all portals before it lets me

I have a main database that contains business address information of on it. There is also a portal that displays names associated with the business. I want to print a form letter to each of the names in the portal with the appropriate business address on each letter. Right now I can only print one letter of the first name of each business, no matter how many names are associated with it. I know I can print the letters from the names database but then I would have to select each business at a time and print the letters. What I really want to do is print letters to all the names of all the businesses residing in a certain zip code, say, or all the franchises of a fast food …

I have a contact file in which I would like to show a relationship between contacts. These could be family members, business etc. I have tried creating a relationship with a field ContactID to ContactIDGlobal, where ContactID is a serialized number and ContactIDGlobal is a Global field. When I create the portal, I can't get any fields to show. Am I on the right track? Should I approach this differently? Why can't I enter the field within the portal? Any help greatly appreciated

Hi there, I got a form layout with a few global fields and a portal derived from a different global field relation. User "abc" entered his cursor in to one of the global fields. At the same time I tried to click on the portal and got the following error: "abc is modifying this record. You cannot use it until abc is finished" ( but at the same time I can enter into the same global field user abc is in) There are no enterable fields in the portal but some of them are buttons. I am not trying to enter into a real field in the portal. I am just trying to click on a portal row. But I get that problem. (note: we both are on the same record) Please…

Hello all, I'm trying to figure out how I can get a calculating field to look at the rows in a portal and compare them to find the highest value in a given field. Then the calculating field should display that highest value. To further complicate it, I only want to include certain rows - the rows to look at are marked with a "1" and the rows to ignore are marked with a "0". (The problem I am trying to solve involves looking at which activity completed by a given person within specific dates involved the most number of hours - if that helps!) - I'm stumped! Thanks in advance, Leah

Is there a way to test if you're in the empty portal row? the portal row for adding records? OR, is there another way to solve this problem... Most my files support "notes"... a portal that has three fields in each row... Date the note was entered, User that entered the note, and the Note itself. To add a Note, you normally just click in the empty Note field at the bottom and start typing. Today's Date and your User name get entered automatically. However, with the fields organized the way they are, I am sure some of my users will naturally try to click in the Date field and type that in. I could easily disallow entry into the Date and User field, so …

Most my files support "notes"... a portal that has three fields in each row... Date the note was entered, User that entered the note, and the Note itself. The Notes are sorted by Date, descending... so the most recent note is first, and the oldest note is last. Thus, when you add a note, it will naturally be inserted at the top of the Portal. But the blank row you click in is at the bottom of the Portal. The user will find it non-intuititve to go to the bottom to type in a record that belongs at the top. They will also find it upsetting to have the bottom row jump to the top when they hit "enter". QUESTION 1: Is there anyway to get the empty row to appear a…

Dear All, I use a field (text) with look-up depend on parent field. when I click in portal to add a record ..sometime a field with look-up work...sometimes it does not show up. Do u have any idea why look-up in portal has problems? Thanks

I have a database from which I'd like to create a report. I only want to report three fields. I've got the report made but I have to physically call up ech record myself. Is there a way to have the fields automatically created when I create them in the Parent file without changing the original location to my report and then creating a portal back the file that is now the original? Thanks. Peter

From what I have read on these forums, it's evident you can't have specific nested portals. But I have not yet found a solution to my problem. I have three files: Customers, Invoices, and Products. Customers has all the contact information and orderID, invoices simply has the orderID, productID, and quantity. Products has productID and the product name. In my customers file, I have a layout that presents the customer information and a portal to the invoices file to show the quantity and productid of the orders. What I want is for the portal to also match the productID with the product name from the products file. That way you get the actual product name instead …

I have a field in File A with consecutive numbers on different lines (e.g.) 1 2 3 4 5 etc. In a related file, File B, I have created a lookup that appears as a pop-up of this field. I can click on the field and choose a number from the list and that number appears in the field. I then have another file, File C that has a portal to FIle B. This same pop-up field still acts as a pop-up, but there is nothing in the list! What happened and what can I do to get it to work correctly? Peter

Basically I need a field that will be used as a trigger for other events. I need a field (a date, number text, anything) that will have data that will change in some way anytime a new portal row is created or changes are made to a portal row. As an example: Count(Related::One) Counts the number of portal rows, and changes for each new addition or deletion. But for my purposes I need a field that will indicate changes that IS NOT based on a relationship. This field is being used in such a way that anytime the data in the field changes it triggers another event, but if the field is based on a calc that uses a relationship it wont work for my trigger setup.…

I'm combining two fields which have information originally entered via a portal. Normally, when information is changed in the portal the information in the related field updates automatically. However, I have found that when two fields have been combined the information will no longer automatically update (because it is now a caluclated field?). Is there a way to force an update when a change is made in the portal without a script - or do I need to just keep the fields separate? Thank You.

Dont seem to have any luck with this one. No matter what portal row I click in, this function always reads 0. How do I get it to display the portal row number for the row within which field I am in? LR

Help! I have a DONORS db (parent) and a related db of Donations (child). In a portal (of donations), I do a find in the donation date field for all donations made during the year for DONORS. The found set of DONORS includes anyone who has donated during 2002, which is great, but the portal also lists all the pre-2002 donations. How do I omit these pre-2002 related records so I can print a YTD tax receipt for each DONOR. DONOR db -has name, address, phone, etc. Donation db -donation amount, cc number, date, etc. Relationship as follows: ID key field in DONOR db =:: ID field in donation db. I have beat my head 4 hours now on this and can fi…

I have two portals in the same layout, both are related to the layout, but not to each other. Only one shows up when I go into browse mode. All of my fields are easily inside the portal. Portal B is set up exactly like portal A. In fact, both have the same type of information (Phone, Address, etc.), just coming from different files (employee residence while at school, employee residence while at home). Any clues as to why Portal B's not showing up?

Hi I got a portal in Invoicing that shows information located in Inventory. From the Product Code field, I created a pop-up list to show the product codes located in Inventory and its description. When I select the pop-up list, I see partially the list of product codes. Many product codes don't show up within the list. What's going on? Where are they? Why?? Any idea Bikeman17

I would like to be able to wrap text in a portal based on the length of the the data returned. Example: Directions 1 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX YYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYY ZZZZZZZZZZZZZZZZZZZZ I don't want to display any additional blank lines at the end. Thanks, John

Hi, I have two Qs about portals in a self-joining relationship: 1) How can I omit the record "itself" from its own portal? 2) It seems that the portal only looks at the first related record. Is this true? If so, this self-joining relationship is not as helpful as I would have hoped (it can't relate one record to several others; it can only relate one record to one other record? And the one other record is always the same?) -For example, I have set up a self-relationship for the purpose of de-duping. Thus, the "Bothnames" field in record A is matched with all other records with the same "Bothname". The portal in record A shows record A (this is the undes…

Dear All I have a small problem which I could not figure out how to do it , I could do it with the script only, it takes too much time and I don't think that is the solution. Example. Name , Number record 1 - A - 1 record 2 - B - 2 record 3- A - 3 So I use the self-join base on Name and use a portal in another layout I will get like this ... NAme Number A 1 3 B 2 But the point is the same file ...it gives me 3 records , it mean I will get A,B,C with related portal and I don't want it How to do it in the same file? and when I go to related record , it give me all the record not just the related one? ...I …

I have a client database and a comments database in filemaker 6 on win 2000 and mac os9 and osX. In the client database I have a layout with a portal that shows all of the comments associated with this client as individual rows in the portal. Many of the individual fields in the portal are pop up menus with fixed value lists, just to set the stage. I would like to specify values in two or more of the fields in the portal to do a find that would perform like a boolean AND search. If I find based on more than one field in a request in the parent record, it acts like a boolean AND, which is no surprise to me. When I do a similar search in the portal for say: all…

Dear All, I use a self -join of the same database to get many employees of the same manager but it gives me the same number of record of parents record, but I want to show the parent record (manager) only once . And also I would like to find the data in portals. If i use two separate database , it is ok but the same datatabse ., it gives me alot of problems Any one have done that before or have an sample file? Thanks

Using a portal, each row has a field with an email address. I need to have a calc field that will grab all the emails from the portal on the page and list them with a line break between each one. Tried this a number of ways with no luck. Anyone done one like this before? LR

Is it possible to perform a find in a portal? More specific, when i go to my layout with the portal, enter find mode, select a field and enter my find criteria, and select find, the portal still shows all the related records, I was expecting it to show only the related records that met the find criteria. LR

I saw an example of this...but not quite sure how it was done. A main job database. Each record represents a job. A second database which contains a record for each contact. The user opens the main database. The user hits an add button, the second contact database comes up, you select one of the records from a list view, the contact databse closes, and a line item representing the selected contact is added to the main database on the first line of what could either be a portal or a multi-line field with a scroll bar. Hit the add button again and do the process over again and a second line is added with the next contact. Go to another record in the main dat…

Is it possible to have a field with a calculation which will result in sowing a number that represents how may records/rows exist in a portal? LR

I'm building a small invoice system. I have 4 databases for client information, product description, delibery invoice and "final invoice". There are some relationships between them who allows me to include new related related records like "line items" in one portal in the delivery invoice. Now I need to show the related delivery invoices of any client in the final invoice, based on a value list obtained from the delivery invoices IDs, but I can show only the first related record of one client. In other words I need to show in the final portal related records from the delivery invoices including the "line items" of each referenced item. Example, show a portal with 2 de…

FMP is 6.0 both Mac & Pc Is there any way to keep the extra line from showing up in Portals? Note: Relationship from [Contacts] to [Names] file is by IdNbr and "Allow creation of related record" IS checked. I have a [Contacts] file with a portal from [Names] file. Along with the related fields I also have a

I have a portal in a contacts DB that I would like to display all records with the last name beginning with a, b, c, etc. I have calculation filed which determines the first letter of the last name and scripts which sets a global field to specific letters. My portal is based on the relationship FirstLetter = :gFirstLetter What I get is a mess...if I set gFirstLetter to A I get the name associated with the current record repeated the number of times there are A names. What am I doing wrong? Do I need to create another file to handle this? Thanks.

Hi! I have about one day left to prove to my work that this database is the way to go and I can't get my portal to show on the web! [FMP-Portal: publications] [FMP-Field: publications::Author] ,[FMP-Field: publications::Pages] [/FMP-Portal] Isn't this all I should have to enter to have this happen???

I have a DB in which I have a portal showing records in another DB. It basically tracks operations and the times they were performed. The portal shows all of the operations from a certain job. I am building a schedule that will show the last operation from that job. How do I find the last portal record based on time and date of operation. Right now it always finds the first operation.

Have Parent file (Faculty) pulling info via portal from Child file (Commitments). Parent file has two (2) portals - one portal for Commitment Amounts using relationship "commitments" key field ID# and one portal for Expenditures using relationship "commitments paid" key field ID#. Both portals allow entry in related file. All data entry is into Parent file. My problem is when I create a new entry in "commitments" portal a blank portal row is placed in "commitments paid" and vice-versa. Is there a way to correct this. I don't want blank portal rows created in the other portal. Could this be due to using the same Child file?:?

I am putting together a database and calendar in FM and have run into a user interface problem. When my client creates an appointment block at let's say 8 am to 9 am and another at 11 am to 12 pm, I want the daily or weekly calendar view to be able to show the user there is an empty space for the 10 am to 11 am block surrounded by the two appointments. FM Portals with multiple rows don't work that way. They like to be consecutive. Has anyone come up with a solution to this problem. For the most part the calendar part works fine, except for this issue.

I came across a portal use that I have not seen before. I was hoping someone could shed some light on it. The first step is pretty straight forward. There is a portal that show 5 different line items (5 different related records). At the beginning of each line is a button. Now normally if I was doing this the button would have a script, click on the button and it would open up the related database and go to the related record. This button did it a bit differently. Clicking on the button stayed apparently stayed within the same database file, went to a different layout, and showed a larger portal with 20 or so fields of detail for just that record. I can't q…

Hi people, I've got FieldA that has the following checkboxes - "Skoda", "Lada" and "Ferrari". What I need to do is have a portal that views all records that have both "Skoda" AND "Lada" checked. I've managed to do a calculation field - Calc which uses "Skoda linebreakchar Lada" that manages to show entries that contain Skoda or Lada. Help! Thanks, Steve Griff

Hi people, I need a little bit of help solving out this feature: - I have this field with a number of checkboxes. What I want to do is have a portal displaying the amount of records that each specific checkbox has been checked... Example: - Value List called "Cars": "Ferrari", "Skoda", "Lada" In the portal Ferrari Checked 4 times Skoda Checked 6 times Lada Checked 17 times Any idea on getting the portal to show each item? I guess getting the count would be Count(Car_Checkbox == "Ferrari") or something... help! (or would the only way to do it is to have 3 calculation fields having count() for each checkbox…

Hi all, Yet another question that is probably ridiculously simple - I want users to be able to add a related record directly into a portal, which I know is possible, but for some reason it's not working. I have "allow creation of related records" checked (as well as allow deletion of related records, which does work). What am I missing? The message I get when I try to type directly into the portal is "The relationship 'Session 1' is not valid and must be corrected before this field can be modified." The relationship I am using is Event ID & Specific session number::Event ID & Any session number - this brings up only the records for a particula…

i've been able to filter a portal with a field that has 4 choices d1, d2, i, m so it can filter by each choice... is there a way to filter through a range... for example...i want to display i AND m or maybe d and m the primary field is client_code and the above mentioned field is type so the way it is now is client_code & " " & type (primary file) client_code & " " & g_type (related file) thanks mallikai (fmpro 5.5 windows xp/mac os x)

I am using a barcode scanner to scan product information into a portal. Among other information, the price for each item displays in each line of the portal. Is it possibel to have a field outside of the portal display just the price for the last item scanned (a specific field in the last row in the portal)? I believe I would have to use a calculated field as I do not know if I have a means of executing a script after each barcode scan. I would like to have the price displayed in a much larger font so that it is easier for the user to read. I have been unable get a calculated field to work properly. Thank You.

I have a database of 550 names consisting of contact information (name, address, telephone, etc...) I have set up a portal to group records based on whether or not they are the same members of a family. Some families only consist of one member, but many have anywhere from 2 to 8 members. Ultimately, I want to print the entire database on a layout that groups the families together. So far, I'm wasting a lot of space because I have the portal set up to accomodate the largest family. Is there a way to make the portal automatically adjust its number of rows depending on the data that it needs to show? M.

Hi, In the previous subjects, I have read that portals aren't always the best things to put on a report, yet i have a report containing 3 portals with 0 to 20 rows. Now the only thing I want to do is to keep the portals together when I print them. So if the 3 portals fit on one page. I d like to print them on one page. If not i want the first to be printed on the first page and then the others on the second. So i want portals not to be cut in half. Is there a way to do this? Hope someone can help me,... Thanks, Thierry

Simplifying my situation as much as possible here is my dilemma: Two databases A and B. A is linked to B with 3 different links: Link Z relates to a subset of all the records in db B, Link X relates to a subset of the records related to Link Z and Link Y relates to another subset of the records related to Link Z. Together the records related to links X and Y equal the total records related to Z. The layout in db A has 5 portals: Portal 1 is related to db B via Link X and shows 8 rows with a scroll bar. Portal 2 is related to db B via Link X and contains the total of the records displayed in Portal 1. Portal 3 is related to db B via Link Y a…

I have been in database development for 15+ years but have just acquired a client that is using FM5 to manage some major functions in his business. I know I should do some more research before posting here but time won't allow it. Issue: His main database contains information regarding his clients, ie billing, contact info etc. These records are accessed via an 'event number' which is formatted 'MMDDnnnn' where nnnn is a sequential number from 0001 to 9999. (example 06021591) As part of his normal business procedure he also keeps scanned and faxed documents and photos in another application (PaperPort). His 'product' is this PP collection of info which is eventu…

I need to print the items in a portal to a pre-printed form. The pre-printed form has 14 rows for information on each page and my portal can have any number of rows. Therefore, I need to find a way to print only 14 rows at a time from the portal. The information to be printed will be entered via a portal. And since each portal of information has a unique ID, could I sequentially number each item when entered and then have items with numbers 1-14 show initially to be printed? Or is there a better method? Thank You [email protected]

Hi, I hope someone can point me in the right direction on this one. I have files A and B. File A contains a portal showing related records from file B. So far so good. What I want to achieve, is to select a portal row so that I can see all the fields of that related record in a second (single row) portal on the same layout. Hope this makes sense. Any help greatly appreciated. Thanks Boyd

I've got a big database spanning over several files, those files has different fields. All this is linked together via a menu system. But, how do I do a search function that finds the criterias in more than one file? If it was so that every field was unique, this would have been no match, but now, I've got some fields that is unique, and some that isn't. I want this search function to both contain a "multisearch" that seeks for the inputted criteria in every single field in every file, and a "normal" search function that let's you input one criteria per field. The matches should be displayed in a list and then the right one to be choosed of the user. If I ne…

Portals can only be used with related file(file with relationship)? Is this true

I have a DB that has, let's say, 10 records. I would like to create a portal in that same file that lists a particular field of each of those records within that file, so that I can have a clickable list. While viewing record 3, I can see the list,click and be taken to record 8, etc. I have tried creating a self relationship on a global file to no avail. Is this possible? Thanks

I have a problem with portals (as you guessed) but for me it is easiest to learn by example. So since I can't find any portals in the templates from filemaker 6, can anyone tell me which template might have a portal or point me to a filmaker database with a portal in it? Thanks

Hello everyone here's my dilema The db in question is basically a flat file setup The group only wants to add a particular feature. I'm not sure if it is possible. The end result is to be able to select a file from the portal and create a new record with most but not all of the fields automatically ! 1. When they do a search on the form view layout the request is this; to have a portal that will display the found set of records...(simple enough) 2.a couple of the fields required are pop up lists...(here I run into the problem that these 2 fields w/n the portal's list of records the data on them is that of the record being viewed and not the file(s) being shown i…

Hi, I have set up a layout in a file called orders which has a portal on it, the file also has a relationship with a line items file. When I enter a id in the portal the other fields are filled in via a calculation, which is great. The problem I'am having is when I create a new order the data is still shown in the portal (line items). How can I clear this?? Thanks for you help, this forum is a lifesaver!

Hello! I have a CDML-based form that displays a master record along with related portal records from a secondary table. Ideally, I would like to be able to edit both the master and portal records from the same form at once. When I submit the form for the master record, I get a 102 error (field name not found). When I remove the portal fields, this error goes away. This must mean that the 102 is generated because FM looks for those field names in the master table? Is there a way to edit the related records? If so, can anyone please lend assistance? Thanks! Kevin

Hi, I would like to know how to enter a id in a field on a portal and then all related data shows up automatically in the portal ie; I enter "111 (ID)" and one hundred and eleven (Title) Numbers (Description) etc.. shows up in the portal line. I want to scan items via a barcode reader that would add them to an order. should this be done within a portal or not?? Thanks in advance

hello i have 2 databases, one which has user,level,mid and another database (say db2) has only user.So i setup portal relation between those 2 db's using user. The field 'level' takes only 3 values say "1,2,3". i have three portals in db2.What i want is all which has level=1 should go to portal1 and level=2 goes to portal2 and so on. how to do that? Hope this makes sense bye geethanandh

I have a layout with 2 different portals. In portal "A" I want to select specific row to show information in portal "B". I can get this to happen however the row in portal "A" that I select should remain hightlighted. Have seen post in the past covering this but am unable to locate. Any help would be appreciated...

Hi every body... Maybe this question is so easy, but please I need your help. Ok, How can I create many fields in a portal from a payment field, with just a click? For example: In my DB I have a option to create the payments, in this layout I have a field (num_payment) in this field the user indicates the payments for a patient (i.e. 10), ok, how can I create the 10 records in the portal just with a click (I think this should be a script), but in this Portal I have a date field, how can I make the 10 records with a month of difference between them. I hope you can understand my english, pelase excuse my bad english. Thanks

I have a portal with a pop-up list. Depending which selection is choosen in the pop-up list, I'd like to have a small graphic display in that portal row. I have a container with the graphics. Thank You.

Using FMP 5.5, on OSX and Windows. After adding a new record in a daughter file, the entry is not visible in the portal of the mother record until the mother record is closed and reopened. Any clue as to what might be happening? It does not appear to happen in OS9 or Classic mode of OSX.

Hi, I've tried searching threads for this, but really, I have no idea how to phrase the search. * I have 2 files, one with images and the other representing their sales. The sales file draws a related image into the Sales file via a normal relationship (uniqueID) and that's fine. However, I also want to view the related images via a *self relationship* in the Sales file (for a sales report). Is there any way to view a field's content which is related from another file via a relationship, via a self relationship in the child file? Maybe I should be bringing the image into the sales file via a lookup...but it seems a bit cumbersome to have to have the im…

I just inherited an interesting project. One of the things it does is bring out a 1 to 8 page report.... Using about 20 portals. The good thing is that the author made most of portal share one lineitems database (using dynamic keys method, and not using all fields) so in theory I could print from the line items, but there portals from other databases. so it won't be easy. As well, the author made it so if the portals are empty, they do not print (and shorten the report). I havn't really figured out how he pulled this off. I think he is using print sliding. Almost everything in the print layout is a calculation the is something like: If(IsEmpty(field), "",…

I was happily doing my thing with portals until I started reading this forum, and now I've gone into complete panic mode. Here's my situation: We have an interview that's administered to students every three months. So far, we only have two of these interviews administered, so each student will have two interviews associated with him/her. I have a file called Student for student demographic information, Questionnaire, and Scoring Profile. The Scoring Profile is a file that takes the values from the questionnaire and scores them. I need to display a summary of the differences in each of the question from the first time the test was administered, to the…

I have a one to many job_header to job_items. I have a field setup in the job_items db called 'category' which is either P, L or O. I have a calc field of: If(Job Header to items::CATEGORY="L",Sum(Job Header to items::CHARGES)*.6,0) and also If(Job Header to items::CATEGORY="P",Sum(Job Header to items::CHARGES)*.35,0) I finally add these two calc fields together with: tot_com=L_com+P_com to display the total of the fields in the portal out on the form. Problem is that the calc is ignoring the condition of testing the value of CATEGORY. Any help appreciated.

Okay, I'm an idiot. I am trying to set up a portal to show in list view the inventory from the database (there is only one database). I drag out the portal, select "Item" in the show records field, click okay, drop a field on there, and nothing. The portal shows a list-type box and nothing else. I doesn't matter if the field is relational or not or if i group it or not, or any other the options for the protal format are different. I have been using filemaker help and the Filemaker Pro Bible (the greatest series of reference books on earth!) and they describe the exact procedure I am telling you about right now. The relationship I am using is set up like this: the …

I have a portal that displays a list of documents and has 2 buttons: one to move a document up one row, and another to move a doc downone row. The portal is sorted based on Sequential # (number field). The scripts work for a number of moves and then one or the other screws up, but not always the same one. I can't figure out why. Could the portal rows get changed (resorted) by FM before the script terminates so that I'm not on the row I think I am? Does anyone see what I'm doing wrong? _iloc and _ipos are global number fields. Move Sale Document Up: Set Field [ _iloc, Status( CurrentPortalRow) ] If [ _iloc = 1 ] Halt Script End If Go to Port…

Hello, I am creating an attendance solution for a school. I have 3 files, Students, Teachers, and Attendance. In an attempt to not have to scroll to the bottom of the portal window to create a new record (automatically), I have created scripted buttons that create a new record from the student database into the attendance database and sets the status of attendance. This works just great. I am running into problems displaying the info in a portal to give some sort of feedback to the teachers about which student status that have completed, or where they are in the list. The first records work just fine because it only has the one related record to display. By…

Each one of my records refers to a specific auction number. When an auction doesn't sell, it is duplicated, and the previous item # is put into an "old item number" field. I'd like an easy way to show how many times an item has been put up. I think i would need to "loop" a portal, but not sure how to do this. Of if you have a better idea, let me know. Thanks -j

The desired capability: To have portal records resorted by clicking on portal column headers. I've already implemented my own solution. The reason I'm posting this is because I'm confused by all the solutions to this problem I'm seeing out there in Filemaker land. I haven't seen anything as elegant as what I've done and I'm just wondering why some of the solutions I've seen are so complex and bulky. My solution: 1) Create a field called 'portal sort number' in the file that your portal looks into. 2) Define your portal to sort on 'portal sort number'. 3) Attach portal header text for column X to a script that sorts your file on field X then l…

I'm working on a receiving db where I'm getting the raw info from an old DOS accounting system (so I can't set everything up right the first time!). I'm currently importing two files into two dbs. I have a header file (PO #, date, name of vendor, etc.) and a line items file. The line items come to me flagged by a status field as either Open or Complete. Typically, a 100 line PO could dribble in from the vendor over several months, meaning any given line item could go from Open to Complete without affecting the status of its neighboring line items. I've set up a layout in the header db with a portal that shows all line items associated with a PO#. What I'd li…

I have been using portals for a long time. But - never think of the connecting files as Parent and Child. I just want to make sure I have each one labeled in my head correctly. For this example - I will use Invoices and LineItems. The invoices db has a portal to the lineitems for individual line entry. The parent file would be the LineItems database and the child file would be the invoices databases. Correct? If I am thinking backwards - please let me know and help me to understand why it is the other way. Thanks

Situation: In my layout I have a nicely sized portal with a number of fields inside, each field has some space around it for legibility sake. Problem: When someone clicks on the row without clicking inside one of the fields, the whole row turns black to indicate it is selected. Similarly, if I change the fill color of the portal to a dark color (it is currently white) a lighter contrasting color will appear. Question: Can anyone suggest a more refined way to handle this, for instance a lighter gray on a white background. Or is this built in and unchangable?

can anyone suggest a way to do the following. I need to be able to create "x' number of related records in a portal where x is the total months between 2 dates. Basically i have a date range from 1/1/2002 to 3/1/2002 which equal 3 months (anyone know how to calc that to reach "3") and then create "3" related records starting with January and ending with March. The end result would be that i select employee A in the portal from a value list, FM would then create 3 records with the same employee name which auto incremented months ending on March. does this make sense? Thanks!!!

When using a portal to create new records, is it possible to include other fields outside the portal (but in the same record as the portal), in every newly created record? Thanks

I have two database files. "Contacts" and "Projects". The "Project" database is using two portals to display related entries from two relationships from "contacts" called "primary" & "secondary". For each "Project" Record there are several primary contacts and each primary has several "secondary" contacts related to it. The number of "secondary" contacts for each "primary" is not known but i would like each to be displayed associated with the proper "primary" contact. Theoretically placing a secondary portal in each line of the primary portal. Any help would be appreciated.

Hopefully an easy one for everyone, except me! Simple Notepad file with Portal plus related Notepad Line Items file. Items are dealt with and then deleted from portal but how can we retain the items (archive them) in the Line Items file when they are deleted on the portal? We have not clicked 'also delete . . .' in the relationship box. Thanks for any comments.

I posted this message in the Define Fields area - but I really think it needs to be in here. I am duplicating invoices - that have a portal on them. When I duplicate the invoice - the general information duplicates, the date is increased via my script, and the inovice number is increased. But - the portal information (line items) does not move over as well. I have tried to create a realtionship between my Line Items and Invoices using the Invoice # in the Line Items and the Original Invoice # in the Invoices - hoping this would pick up the information - but I have had no luck. Any advice you could give would be muchly appreciated. I will keep trying in t…

I have a checkbox in my related record. All my other fields show up in my portal row, but the checkbox field does not show anything. Is there a way to have it show the checkbox and also have it where it is selectable? LR

Hello, I've just tried porting a runtime solution to Mac and most everything works okay. One odd behavior; in a portal that shows only one row at a time, the "go to next row" and "go to previous row" scripts do change the row number but the field data remains what appears in the first row. If you click in the fields, they update to what should be in the row navigated to. The full version that I brought to the mac, navigates the portal rows as expected, only the runtime appears not to update portal row data. If I click in the scroll bar area, above or below the scroll bar, the page up, page down effect does switch portal rows with updated data. FMPro Dev 5 Mac 8.5. Tha…

Any tips on why a portal scroll bar would not be visible. It is in the area to the right of the portal and can be clicked on...but, It is not visible...

I have a database with about 10 files, several users, and several automated tasks. I'd like to create an "event log" wich keeps track of items such as "user ID, script name, file name, and results such as: email successfully sent, email successfully received, script executed normally, script error occured, etc." Since i want a centralized file, i figured i'd use a portal. But since i want to do this wish as little adjustment to the other files as possible, what would be the quickest and easist way. I'm not against using an "error code" system that later translates into an error message. Thanks -j

I have a set of 3 databases: Clients, Interface, Files In my interface, I have a client search field which triggers a list of client names with matching string in a portal ("client name portal"). By selecting the relevant portal row, this will bring up the files for each client in a separate portal from the files database. I have a cbackground container in the client database which is a calculation: if(ClientNumber=Interface:tClientNumber, gBackground, "") The cBackground sits in the ClientNamePortal in the Interface and highlights the selected portal row. No Problem. However, in a multi-user environment. If two users are looking at the same list o…

I have 2 database tables: The parent database table (Contract) displays related Contract Logs, from the Child database table (Contract Logs) via a portal. From the parent database, I can use the command Goto Related Record to select the relevent record in the Child Database. Is there anyway that once a record in the Child Database is selected, the relevent portal row in the Parent Database can be selected. Everytime I try to highlight a SPECIFIC portal row (by file contents for example), only the first row gets selected. The other portal row option (first,last,next etc) aren't specific. Any Ideas? thanks

Hello I

I just recently had a need to print a list through a portal. I noticed that it only prints the shown part of the list. I was wondering if there was a way to have it print the entire list, similar to how a columnar list/report does. I tried making a columnar list and placing related fields in it, but it only shows the first related record, not the entire list. Also, I dont want to just extend the length of the portal because the potential for the list to get longer is high. Thanks in advance for the insight. Ken

I have 2 portals with views into the same db, one which views sales and the other views orders. I'd like the sales portal to view only records with sales, and the orders portal to view only records with orders. Currently both portals display all related records for the original record. Is this possible?

Hy, In a file , I got 2 portal. By a script, I'm able to copy the data form my first portal, but I'm unable to copy the data from the second portal it copy just the last record of this portal.... Do you know a way to do this ?? Thanks in advance ! Pierre Turcotte [email protected]

My FM experience is someplace between beginner and intermediate. I've hit a stone wall with portals in developing a genealogy database. I'm using FM 4.1 on an iMac. I have 4 files: PEOPLE (serial#, name, birth and death dates for each individual); PEOPLE DETAIL (with fields for info on details of each individual); MARRIAGE (details of each marriage of each individual; and FAMILY (displaying how each individual is related to others). I use serial# of PEOPLE as match field to the 3 other files. In FAMILY, I want to display the individual's parents, each spouse, and the children of each marriage. In each of the three portals I have the same problem. Using the Spou…

I have a DB and I want to create a notes portal that will appear in all records in the DB. These notes are not specific to any record in the DB.

I have a portal with studentsnumers and an icon with letter send/unsend. When i click on the icon a letter is printed and the icon for that one student is set from unsend to send When i shift click on the icon the letters for al the students in this portal are printed and all the icons are set from unsend to send. One problem with following script --> it never stops. It doesn't exit on the last record. Go to Portal Row (first, select entire contents) Set field (T_Students::bevestigingsbrief,3) Loop Go to Portal Row (next,select entire contents, exit after last) Set field (T_Students::bevest…

I have a database where products are selected by use of a portal. These products can be selected by item, carton or by square metre. The product database has different fields for each of these values, and are entered correctly in the portal database by a relationship. I would like to total all the items with the square metre type selected, normally I use the sum function but it adds everything in the portal row, and Iam struggling making a selective sum. Example product1 M

This is a problem that I run into with almost every data base I create. In my latest database I actually have 2 related databases. The first is "Clients" and is a basic contact manager. The second is "Policies" which holds all the policy information for all my clients (in case you haven't figured it out this is for an insurance agency). In my Client DB I have a button that creates a new policy. The script is supposed to copy the client id, open the policies DB, request a new record, past the client id and based on the id the pertinent demographic data from Client DB is shown in related fields (like last name, first name, etc.). Then back in my Client DB I have a portal th…

Why is the blank portal row that follows a data row necessary? It is very confusing to the user.

I have a main Invoice DB, but related to this I have an InvoiceDescriptionsDB. Related by Invoice number When someone raises an invoice, they may have many parts to the invoice which are created in the InvoiceDescriptionsDB. The InvoiceDB shows all of the descriptions for each invoice within a portal. How do I show a total amount - for all the parts - on the Invoice DB. At the moment all that happens is that it shows a total for all parts for all invoices. Thanks

Hi there, Just FYI, when duplicating multiple layouts, where the portal is based on different relationship, somehow it's not enouph to just double-click on the portal to change the relationship. You have to physically re-draw the portal, then specify the relationship that this portal is based on. At least I had to do it for my solution. My guess is that's the bug in fundamental programming of the object-oriented side of the FM. If anyone has any clues out there, please enlighten me. Biking days are here again.