Portals

Hi, I'm pretty new to FileMaker, so I hope I can explain my problem. In my database I have portals that contain up to 3 rows. Each row has a "status" field. I'd like to get a summary of one particular value in the field depending weather it is in the first, second or third row. In other words, if the "status" field of the 1st row says "done" and 2nd and 3d rows say something else, I want that to reflect in a separate "master status" field as "done". Same if "done" is in 2nd or in 3d row. Does anyone have an idea if it could be done? k

ok.. i have a portal, and one of the fields that is displayed is a calculation field. One of the fields it is calculated from is on the layout with the portal. Now if i change the field i have to click on the portal rows, or change layouts and then go back, or change to another mode and then back again, to get the calculation to update, or atleast display that it is updated. Its probably updating, its just not showing up in the portal. Unfortunatly using a script is out of the question (unless i were to use a plugin to activate the script when the user leaves a certain field, and I dont want to install a plugin on every machine that will be using the database). So there i…

Hello I've been unable to find a simple example on how to create a invoice layout (using portal's and relations instead of the old way via repeating fields which I'd like to avoid) My needs are rather simple as most of the taxing fields etc have been created as well as the value lists for the products and services --- {don't know if this really matters}. So all that this solution requies is a way for the user to select the product / service via a list , which they must be able to add too. Manually add quantity and other non-constant data. Any help on how to put this together will be great!!? thank you Synergy ------------------------------------------------------…

I have a single DB for student records. When you bring up a specific student there is a portal that shows who that students siblings are. To accomplish this I created a field called ID1 which is defined as: Student Last Name & Right(Primary Home Phone,4) so that any students that share a common last name and the last 4 digits of their phone number are considered siblings. Then I created a self relationship where ID1:ID1 and I place this in a portal. It brings up the siblings but it also lists the current record. So that the current student shows up as his/her own sibling. Is there a way to elimanate the current record from the list?

Hi, I am not good at scripting so I am looking for an example I can look at to use. The sample I am looking for is a regular invoice db, with a portal of multi items, found on a relational db with multi records. of cource it will not print correctly, so I am looking for a script that will copy the informaion of the portal and paste it in to another layout for printing. Looking for a very simple example, since I am new to scripting. Much appreciated Mark

I have an invoice file related to two line-item files, which display in separate portals on the invoice layout. What is to best way to layout a report (the printed invoice) to print all line items for each invoice? Are there any problems to lookout for? Thanks.

I have two Databases: AnnualReturn and Director AnnualReturn has the fields: ClientNumber, AGMDate Director has the fields: ClientNumber, ElectionDate and ResignationDate In the Annual Return Database, I need to generate a report which reflects only those directors from the Director Database serving at the AGMDate. I am trying to filter the portal to select those records with related ClientNumber in the Directors database which have an empty ResignationDate or a ResignationDate later than the AGMDate for the related records in the Annual Return Database and ElectionDate earlier than the AGMDate. I can't seem to come up with a key field for the relationships to accomp…

How do you duplicate a record and also the data in the portal? I have two DB's, one called Quote Builder and another (which servers the portal) called Quote items. How do I do this, I cannot figure out what script steps to use....

Within our POrtal we have many items shown, when you click on the portal row the corresponding relted information is shown to the right. This works fine, However the issue we have is that if we click on a portal row which is way down the list, the list refreshes itself and you lose sight of the record. Can you lock, or hold a portal row, instead of having to scroll back down the list? or better yet get this item to be put at the top. We did have a sort option on the portal but this has been removed. Hope this makes sense. cheers

I Have a Tool Maintenance database, that I have constructed from two files. (Header & Detail). Is there any way I can view a filtered list of the detail file (Sames as Excel) when I bring up a tool number (ie Header Info). Ie I only wish to see all the work done by a specific person in the portal not all the people. Hope it makes sense. Any help appreciated.

I'm working on a donation history database and I can't seem to figure out how to do this. Basically, I have a record with the donor's bio info, and a portal displaying his/her donations. How do I sum all of his donations and have it appear in the bio info record? Hope this makes sense. Thanks ahead of time.

Hi, I have two articles in my stock as 7VLR and 7VLR+, on the invoice in the portal field it just show 7VLR so if I want to select 7VLR+ I have to chose 7VLR and then typing + after R. What should I do to see the 7VLR+ display in my portal field. Thanks, The Beginner Duc

One of my clients insists on having the portal display the related records horizonally across the screen. Since i know that the users will not look at more than 31 related records at once (one for each day of the month), i could get around the problem by defining 31 relationships based on calculated keys. However, this would seem to be an ungraceful solution to the problem, as the portal naturally displays the correct related records with only one relationship. Suggestions anyone? ~Ati, jedi master

Hi, I can't seem to get a calculated field (from another table) to show up in a portal. The other fields are working, and they are based on the same relationship. thanks

In a parts sales operation, I have an Invoices database with repeating fields for Item No, Description, Quantity ordered, and Price arranged straight across as line items. Customers typically order numerous line items per invoice. In a related inventory control database, containing a tracking record for each part, I want to view in a portal only Invoice line items (especially quantities) matching a given Item no. I made a portal to the Invoices database, related by the matching item numbers. It successfully turns up all invoices mentioning a given item number. Non-repeating fields list fine: Date, Customer name, etc. Now the hard part: In the portal, from the repeating …

Maybe this is a simpler way, but I still can't figure out how to do it: See my earlier post below for the repeating fields attempt. I want to list multiple items and quantities sold on an invoice record. Let's just use multiple fields on the invoice instead of repeating fields as I tried earlier: Item 1, Item 1 Qty Item 2, Item 2 Qty Item 3, Item 3 Qty ... Item 25, Item 25 Qty Various part numbers will be entered into one or more the 25 Item X fields, and various quantities into their corresponding Item X Qty fields. Easy enough. But next I want to view and total up, in another database, a subset of these quantity fields based on the contents of their compani…

Forgive me...I'm new to Filemaker. I'm very used to Access, so I'm finding that this change to Filemaker is strange at times. In a nutshell, I have five files (or tables?). I have all of the proper relationships linked up, I believe. In one of my tables, which I'll call Table A, there is a field for courses. I can select the course by using a menu. (The menu values come from a field from another table). In Table A, there is another field called "Categories". It is actually a related field from another file. I have enclosed it within a portal which also is defined properly, I believe. When I select a course from the drop down menu, I want the category field to au…

Ok. The invoice file. The portal line_item inside invoice file. How can I give a never-changeable ID for each item line, starting, of course, from 1 for each invoice?

I am currently setting up a StudentTeacherClasses database using FP.5. Working with 5 files: StudentTeacherClassesRegistrationCourses. In Student layout I have a Portal from Registration which shows the Class ID & Teacher Name. I want to show Course ID & Course Name also, but I am not able to figure out why I can't. I'm guessing it is in the relationship, I am stumped. Thanks for you help!

I work for a Performing & Visual Arts School for the Disabled. Some cannot read so we use color dots & initials (RH,ST)instead of numbers on a name tag to indicate which classroom they are to go to (10 classes per week. How can I: 1)Change the color of a field by using a Value List. 2)Make the field look like a colored dot. Can you help? Thanks

How do I get a summary of records from one file to appear in another file? I am trying to track donation records for a non-profit organization. I have a Donor file which lists all of the personal info on the donors, and a Donations file which lists all of the individual donations that a donor makes. So, I may have 500 Donor files and 10,000 Donation files. In the Donor file I can call up a Donor Summary page and see all of the donations that a person made via a portal over to the Donations file. The portal shows me all of the donations for that particular person, but I don't always want to see "all" of their records. For example, I want to see all of the donations t…

There is a weird problem.. I have a portal, which I need to be located in the header part of my layout. Every portal line has a button with an attached script. These buttons are located inside the portal box. The problem is that these buttons don't work! When I click on a button, it doesn't activate. If I move the button outside the portal box, but leave it in the header part, it begins to work. Also, if I move the whole portal to the body part of layout, buttons start working too. So, the problem is clearly related to some "incompatibilities" between portals and the header part of layout.. I would appreciate any help on this issue!! Specifically - what is wrong …

I'm building an order form to use in our newspaper company to schedule newspaper ads. I've built two FMP files. The first (I'll call the "order form") contains the general (advertiser) information and production (size, color, etc.) information and the other contains the scheduled publications (we have 15+ newspapers) and dates. Each publication requires a new record. I use a portal to bring the scheduling information into the order form much as you would inventory into an order form. The problem: I have one record for each scheduled publication. However, ads often run multiple weeks in the publications (i.e. Home Town News (Publication), Wednesday editions, 7/1/01, 7/8/0…

Let’s say I have a master file A and a related file B A and B related by a field called ID In a layout of A, there is a portal to display records of B. Also in B, there is a field called Org Code. If Org code is duplicated (within a ID), then just display the first reccord in the portal. For example: B file: ID Org Code 1 ED01 1 D10 1 ED01 Then the portal should be look like: ED01 D10 Please help and take you in advance HP

Hi I have to insure that I cannot enter duplicate Line Items in a portal. Is there a simple way to do that or can I have an alert message that warns me that I have entered a duplicate? Thanks

Hello I have 3 tables. Event, Sponsors & Banners. In other words the Sponsors advertise in various Events with their Banners. Each Sponser has many Banners and this is easy to show all the Banners for each Sponsor with a portal. Each Event has many Banners but I want to pick the banners through a portal like line items on a product invoice. The Banners are essentially inventory items for an Event. To recap - both Sponsors-Banners and Events-Banners are 1-to-many but in the former I want to show all the Banners for each Sponsor and in the latter case I want to pick which Banner is displayed in various Events. I should also mention I want to copy each Banner into e…

Alrighty. Here's the situation: I have two databases. There is a relationship between the two databases between a calculation field "BLUE" in one database and a calculation field in the second. That part works fine. The problem: I have a portal in the second database. In this portal i have a field that is used in the calculation of "BLUE". Therefore, I cannot enter data and create a new record in the portal because the fact that this record is IN the portal is dependent on the field. Does that make sense? Hmmm, i'm not sure how clear that is. Basically I want to be able to add records through a portal and somehow autoenter data into a field, so that it matches …

I'm trying to develop a shipping database for my company. I'd like to be able to put several items onto one shipping label. So when I enter the barcode/unique number for the item, all of its information comes with it. I started by using portals, but it just keeps copying the same barcode down the entire shipping label instead of letting me enter many items.

I have a layout that I need to be able to display all of the records from another file. The second file has 100 records and will always onlly have a 100 records. I need to be able to have them in a column format (in browse mode) where column1 displays records 1-20, column2 21-40, ect.... . Is this possible? Thanks, Brian

I've created a new look for our IS database which has 3 portals looking into 3 related files: Hardware, Software, Work Orders. If a user uses the portal scroll bar it locks the portal and the other users get the "This record is currently being modified by ..." message. A way to prevent the portal locking is by limiting the access rights to read only but then the record can't be modified. Has anyone found a way around this?

Is it possibel to make a sortation of the diffrerent posts in a portal? Ou

My portal is displaying all records when I want just the found set to appear. Any suggestions? Thanks. L.

I have a HTML form to create a new record in DB1, with coding so a new portal record is also created. The relationship is based on an auto-entered serial number field - when the DB1 record is created, the serial number field is autoentered for both the new record and the new portal record. This was working fine. Then, I started looking into ways to verify that the portal record fields were completed on the HTML form. Due to Javascript problems (outlined in an earlier message, which no one has replied to :confused I decided to define the validation for the portal fields in DB2 as 'required' and let FMPro return and error message if the fields were not completed. On …

I need to isolate two out of many contact portal records in the child file for each record in the main file. I have a calculation field for each of the two contacts in the related record which works well in the related record. When placing the calc fields on a layout in the main file I only get results if the match is from the first contact entered in the portal. When placing the calc fields in another portal in the main file I get the results if the match is from the first or second record entered in the portal, because I set up the portal to show two rows, I imagine. Is there a way to get the results no matter what order the portal records are entered?

The easiest way to do this is with a script. Go to Portal Row [ First ] Loop

I just got back a repaired file from filemaker, but find I have to reconstruct a script. The number of records in the portal that match the common field are correct, but only the first record found is shown, then repeated. I also need a blank record at the end.

I won't my useres to add related records through a portal. The number of related records can vary a lot. On the input screen I have 5 portal lines visible. Is there a way of tabbing through the fields of one portal record and then tabbing onto the next portal row. At present, if I entre my data in the last field of the portal row and then press enter the portal jumps to the first row again, leaving me to scroll right through the portal again to get to the next new record. If this makes sense ? Help much appreciated. Thanks.

I'm building a database for video editors to log info into; one DB has the videos (and data about them) and the other holds their log entries, according to time-code. I want them to be able to enter into that database while being able to view the video (and info) in a portal in the top half of the window. But the video won't play in the portal. I think I had this working before, so what have I done wrong?

My data entry folks often duplicate records as only small portions of info need changed. How do I get all portal information to duplicate into the new record?

Let

Hello: I would like to know how to prevent duplicate records in a portal. For example, if I enter an item#, and in the next row I enter the same item#, how do I copy the data from the current row into the previous row? Thanks, Larisa.

Hi, I have to find a way to print the details (one line per SKU) of a product. All is well until one product has a clearance price: they want to see the new price and the old price *below" it... Can this be done with a portal (as it was) or should I use a totally different approach? Thanks for your input...

How do you get the information in the portal to display in seperate fields in a related file?

I have two files related by the I_CODE, where I_CODE is the key of the main file (say A) and have multiple existence in second file (: In a layout of A, the portal view is: I_CODE="A0001" key_in_B,value_in_B B1, 0 B2, 0 B3, 0 B4, 10 B5, 12 .... How can I do, if I do NOT want those zero value records to be shown in the portal?

I have made relationships between a material, line item and PO DB. The line item DB is storing all items purchased for a particular job off various POs via a portal. The relationships seems to be working in the PO and line item dbs, although only the very first record shows up. I

I have an invoice file where line items are records from another file in portal rows. The entries are a little more complex than ordinary sales items so it would be nice for the user to be able to delete a whole row/line when one is botched or needs omitting. I've tried a button which simply calls the "delete portal row" script but there is no response. I've tried to be sure a row is selected when the script is called to no effect. I bet I'm forgetting to?::? Thanks in advance, Bill

Hi, I have two files A abd B and they related by key called CWC Number. In one layout of A that have portal that show all record of B that has matched CWC. Example: You are looking at portal: Org Code Est 1 Est 2 AD10 1 3 FD10 2.4 5.0 AD10 3 4 In the SAME layout, how can I display the above portal that look like this Org Code Est1 Est 2 AD10 4 7 FD10 2.4 5.0 As you see it does not show the duplicated Org Code, but it show the total. In this case its show AD10 one time and its total. Assume I cannot make any change in the this view. View only. Let say I add another AD…

i have a invoice dbase, an product dbase and product detail dbase. the reason for having the prodcut detail is that a number of the different products have the same details (sheet music, guitar chords, audio file all of the same song). i want to be able to see the product detail in the invoice dbase, but it seems as though you can only view one level and i want to put a related related field in a portal. help!

I'm setting up a database to record the information for train purposes. I have a file with all the student's and another with the Classes. I've tried many, many different things using 1 and 2 join files and I get the same results. Here's what I want for my final results (omitting many records, if I can get a couple of them to work I should be able to get the rest): ClassName DateofClass StudentName ClassStatus(radio button w/ Requested, Taken) Every record in the above file should have an entry for all of the above fields My problem is that I'm trying to take a shortcut in my data entry. I'm entering the data in a file that looks something like the following: …

I've created a portal between two files in my fmp database. In the define relationships menu I have sort set to sort by company name. Companyname is a calculated field in our customer database which looks up a company's name, it simply holds companyname so it can be used in this file. Anyway for some reason the portal is unwilling to sort on this field and sorts on company ID instead. Thanks for your help.

I'm using an If/Else statement to evaluate 3 parameters in a portal loop, then print the appropriate form. After checking the first row of the portal and performing correctly the script goes to the next record. I'm not sure how to keep the script from getting lost after leaving the portal row to print. I'm using a set field to set a global portal row counter to 0 before the loop begins, then the if/else statements, then using two more set fields. The first is status(currentportalrow), the second adds 1, then go to portal row by field value, which is the global row counter. The go to next record command is the last step before the end of the loop. Any suggestions

Here's the situation: Items.fmp = inventory items Quotes.fmp = quotes for item prices Vendors.fmp = vendors Prices.fmp = inventory items with a quoted price added and an associated vendor In Quotes.fmp, I have three portals. Two list All Vendors and All Items, respectively, with transparent buttons over the portals that Copy IDs and Paste them into the appropriate fields. The vendor ID is pasted into Quotes field(vendor_ID)(one vendor per quote) - this part works flawlessly. The Item ID is pasted in the third portal, prices, into the field Item_ID. Here's the catch: this, too, works fine, but ONLY if you select each consecutive Item in order, starting from the…

I'm having the same problem with not going to the exact related record. My button is inside the portal row. It executes a script that says go to related record (only show related records). The related record is in a file that does other stuff with the records being showed in the portal in the master file. Not only do I want to go to the specific related record, I want it to go to a certain layout in the child file. This works fine with an external script before the go to related records command - but I always come to the first record. Am I missing something?: Thanks in advance, Chris

Alright, have a quick dilemma. Lets say you pull up a record in my database and you click on a portal field which has some options. That portal field is created, than it automatically creates another portal field...and so on. For this single record, I need the portal to give each 'line' and number starting with 1, and continuing +1 with each new record. The problem is, if I create a new record, and begin entering new lines in the portal, it is continuing the numbering from the previous record, but I need to it start over. Look at the example below: Record One (portal) Revision # Comment ----------------------------------- 1 Yum ---------------…

Need help! Alright is it possible to have a portal in a single file db, to display all the current records. What is needed correct self-join relation seperate files etc?! The end goal is to display on-line quotes form data, (the point of the portal is to only show what's required only , more data can be viewed on another part of the layout via a calculation fields) and then to process it.

I have two main questions. First, I have a Pond Info Master File that has portals to a Water Quality file, a Fish Info file, a Fecal Coliform file and 3 others. Due to space constraints, I only have one or two rows per portal. When I do a Find in the fields of a portal, say in the Fish Info portal for Category "Fish Kill" and Common Name "Grass Carp", I get results of every entry for that given pond, not just ones relating to Fish Kill. From the manual, I think I have gleened that there is no way around this but I thought I'd just make sure. Is there any way to conduct a find that only gets results for Fish Kill instead of Sampling, Stocking, etc also. Secondly an…

Hi: I am trying to summarize the numerical data within a portal. Each line items within the portal represents a sale and I want to total all of the items at the end but it is not working. I have the calcualtion as Sum(Order Summary::Total)and it is only totaling the first line. Please help!!

I'm having problems getting to filemaker 5 server through a gateway/router. I can't figure out what port the tcp/ip connection is through.. any help would be great!!! thanks

I have a number of clients for whom I distribute literature to industry agents. While the "pool" of agents is constant, each client has preferred agents which they catagorise as A, B, C, D, E or F. Each client catagorises the agents differently (eg. agent one may by catagorised as "A" by one client and as "D" by another client. I have created two databases: Clients.fmp holds a record for each of my clients. Agents.fmp holds a record for each agent. In Clients.fmp I have created a layout with a portal displaying the agent's names from Agents.fmp. So when I browse though the clients records it displays a complete list of agents avalable for each client. What I need t…

I have a portal set to show only one row at a time and looking like a 4x5 card. There is a set of buttons outside the portal which navigate to the nest, previous, last and first. They all work well except "next". When first going to this layout, the first click on next does nothing; the second click goes to 2 and all moves after that work unless a selection is made outside the portal; then the double is required again to ge started. I've tried a few things, like having the nest script first go to a field and this seems to work some of the time. Is there a better way? Thanks, Bill FM5/W98

Hi everyone OK I'm desperate at this point. My portal's are not working, and depite my referring many books. HELP Here's the summary Want to have some of the field info from Customers file to show up in a small portal inside "Jobs" file. then be able to select a customer from the portal, so that it gets assigned to a JobID (it's using it's own ID) . This process repeats in the "Log" file with the "Job" info to be assigne d to a LogID. Lastly within the Customer file there are two portals which are suppose to display the Job's and Log's relative to the current customer record being viewed! Overview (only the first portal -- hopefully I'll get it, and be able to set up…

I've got a problem that I can't figure out: A layout designed to print at quotation: three portals - one for product, one for company costs billed to the client, and one for factory costs billed to the client. In the two portals for costs (which are coming from different files), the portals are shrinking, but they both are skipping a line between each line of data. The portal lines are both the exact height of the single row of fields that contain them. The portal from the product shrinks fine and prints with single line spacing. The other two portals are printing like double line spacing. Any suggestions? I'm truly stuck. Thanks in advance for any help, Chris

I don't even know what to call what I'm trying to do so here it is-- I have a portal that lists records sorted by 'due date' What I want to do is have some distinguishing feature (i.e. a line or symbol) to show when there is a change of date in the list. an example would be: 4/1/01 4/1/01 ------ 5/3/01 ----- 6/1/01 6/1/01 Is there anyway to do this, any terminology that might help me in solving this? Much thanks ahead of time.

I've created a self-join relationship with a portal as the main entry and a second portal for the child records in another database. Along with this I've incorporated a Hilite current record trick and the Multisort trick from the Scriptology book for the self joined portal. The problem is this: When changing the sort field the relationship is based on (to any of my three sort orders), my hilited record moves with the record fine but the selected portal row remains the same. If the hilited record happens to be further down the list, the user can't see the hilite and confusion reigns... I hope I explained this well enough... Help anyone!!

hi, I have a portal with a small graphic in it and a few checkboxes for the user to check. Everytime a portal row is added FM automatically adds the next empty row. For printing this looks a bit messy as there's always an empty graphic in the next empty portal row. Am I missing (again!) a simple solution to this? Many thanks! nati

Hi there, I have created a calculation (number) field called Row Number. The calc is Status(CurrentPortalRow). I thought that if the cursor was in, say, the third row of a portal on the layout, Row Number would show 3. If I clicked on the the fifth row, it would show 5 etc. Whatever I do, it shows 0. What am I doing wrong please?

I'm using a pop-up value list from a related Database in a portal. When I choose one of the values a dialog comes up saying "This field cannot be modified until ":field" is given a valid value". What am I doing wrong? Art [email protected]

I have a portal list within a parent database. I want to click on the specific line in the portal and have it take me to that record in the child database. No matter what I do, the "go to related record" script takes me to the first related record in the child database. I don't want the first one! I want the one I click on! Thanks in advance.

I have a database that is recording medical findings. An option within each entry is to the finding to the patient. So I have another layout that I want to check the portal, and if it has "yes" checked for report to patient, I would like a series of fields copied over to the letter. The problem is that I can't get the letter to look at anything past the first entry in the portal. Does anyone have any experience that they would be willing to lend to me for this? If I am not being clear enough, please let me know. Thanks

* I have a group of approx 20 related database files (fp5) in my application * I want to create an inventory of reports and store them in a database - Name of Report - Description of Report * Each newly added report would be sorted into alphabetical order by report name * I want to view the reports in a scrolling portal (it's fine to have a separate portal for each type of report... "Clients", "Policies", "Plans", "Commissions", etc.) * Upon selecting a report, I would like to click the related "RUN" button (in the portal row) * This button would activate the appropriate script to run the selected report. As a new Filemaker user, I cannot figure out how…

{b}gCity & "-" & gSuburb & "-" & gSchool & "

I apologize if this is too basic. I have previously used portals to link to related databases and create new records (in the related db) by entering data straight into the portal. However, now I am getting the message whenever I try to do this that the field (in the child database) cannot be modified until given a valid value, and no permutation of data is ever accepted as valid by FM. I also notice that no list of records shows up in the portal (only the top row is active at all). I have checked that the field types are correct, new record creation is authorized in the related db, and the data entry clearly fits in the parameters for that field. Is this familiar to any…

I have two files. Sites and Letters. The site file has fields with computer information in the fields. There is a Site Name field, System Type field, MaintExDate and a Computer Serial Number field. On site or "Site Name' could have 12 records (12 computers at that site). The Letters file has a portal in it that has the related System Type, Compuer Serial and MaintExDate in it. The relationship is based on the unique site names. So the Letters file displays a Site name and in the portal all the computer systems related to that site. Based on the maintenance expiration date (MaintExDate) I want to only display in the portal those systems that have or will have…

Since I can't state the problem well, I'll just describe it (sorry for being verbose). I'm trying to do a search of students that are enrolled in our program for the Fall 2000 Computer program. However, when I do a search (the information is in a portal, with semester, year, and program as separate fields), I get all students that have any mixture of those values. For example, I get students that may have had Fall 1999 computer and Spring 2000 tutorial, since FMP doesn't distinguish between rows in the portal. Is there any way I can prevent this? Please ask if anything is unclear. Thanks.

To anyone who can help; APPLICATION: FileMaker Pro 4.1 PROBLEM: Scripting a button SCENARIO: There are 3 relational files. PI (Product Inventory), I (Invoice), and LI (Invoice Line Items). 'I' contains 2 portals, one for "PI" and one for "LI". While in "I", I want to click on a field "Model No" in the "PI" portal and paste it in the "Model No" field in the "LI" portal. I want the paste function to happen in the next available empty "Model No" field in the "LI" portal. I would also like to know if there is an efficeint way to delete portal rows from the main file. I extend my thanks in advance for any support. binkel @excite.com Fax: 860-563-8421

Looking for advice on how to move records in a portal that would be as easy as moving line items in script writing. That is to say, hold down mouse, then move the item up or down on the list. I am hoping that this would allow me to reprioritize the list of items. Thanks

How can I make a new record without going to the related database?

Is there any way to achieve sliding within Portals? We are trying to create a portal for Invoices which allow extra-long product descriptions to be accomodated yet not require extra-large space assignments. Fasteners_Database_development_07_12_05.zip

Please somebody know how can I paste in a portal (the last portal)? I want take from another fields, I try with a Set field and put in the related field but I need paste in the last portal. Apprexiate your help, thanks.

I am trying to implement a task tracker which is basically hierarchal in nature with three files: Projects, Milestones, Tasks. I need a Project report which will display the associated Milestones and tasks for the found set. The concept of a portal within a portal discribes it nicely, but seems to be impossible. I thought it might be possible to display from the middle level. Using a portal will show the child-tasks. But not sure how I can group all related Milestones together that are under a singe project. My boss sends me deep into FMP about once a year, so I never really get as good as I might. appreciate any help you might offer

Hi all, I would like to have two portals, both from the same related file, on one layout showing differnt data from the same field. Is this possible or is there an easier way to do this? Right now when I choose data from one field (it's a popup) on the first popup and then choose a different popup in the second portal they both show the same data. Many thanks, Nati

I got those text formatting blues.... I'm concatinating two text fields, one with partially italicized text, then viewing them from another file through a portal. The text formatting is gone! Anybody know a solution?

We have three database files currently to track mediations. The first is a Case database file with all information related to cases. The second is a Mediators database file with mediator contact information, etc. The third is a join file (I think) with a record for each time a mediator shows up in a specific case from the Case file. There can be up to 3 mediators per case. Okay, the Case file is set up with a portal to the join file so that we can enter a mediator for the specific case and a record is automatically created in the join file. This works fine except for one thing. Each case may have up to 4 mediation sessions. I'm trying to find a solution so that w…

I have Order records, Item records, and Product records stored in one flat file. I have a layout for displaying information about Order records only. It has a portal on it that displays the line items (Item records) for a given order. The portal displays an Item ID field which has a popup list that lets the user select from a list of Product IDs. When a user selects a Product ID it gets placed in the active Item ID field in the portal, no problem. Now, I have several other Item fields displayed in my portal along side the Item ID field. Some of these other Item fields are text fields and some are numeric. They get their values by LOOKUPS via the Item ID field into the c…

I have a layout with 5 portals. They are use the same two database files, but they filter the data in different ways. I want a user to click on a portal and then press a button on the layout that is able to detect which portal has the cursor to pass certain data through the button's script to an external script. Everything works, except that I can't detect which portal has the cursor. I'm using the set field script step with the following "Specify Calculation": Case( Status(CurrentFieldName) = Colleagues::cPersonOrganization, Colleagues::mPersonID, Status(CurrentFieldName) = Associates::cPersonOrganization, Associates::mPersonID, Status(CurrentFieldName) = Stakehol…

quote: Originally posted by Jeff Abraham: Hi, I'm using a portal to view multiple estimates for a particular job. I've tried a grand trailing summary and a sub-summary to view a grand total below the portal. It works fine until someone performs a find in the estimates database and only the found set is summarized. How can I always show a grand total of all estimates? Thanks! Either control the found set, or use the GetSummary function with a constant or global as the break field. This insures that all records are part of the function. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Consultant Database Resources mailto:[email protected] …

I'd like to be able to have portals resorted by clicking on header fields just above the protal. Example: A portal contains the following related fields: F1, F2, F3. Above each field is a text header: "F1", "F2", "F3". When I click on the F2 header I want the portal to be resorted on F2. It appears that portal sorting is completely determind by the sort option setting in the relationship definition dialog and that this can only be set by interfacing manually with this dialog. Is this true or is there a way around this?

Trying to create a ledger card metephor. Transactions in the portal are posted starting at the top and moving down organized by date (most recent at bottom and oldest at top). Would like to display to default at the bottom of the portal and show the last "n" records (The most recent) from the bottom of the portal up. Is there a way to do this conveniently. I know you can do this by setting bits on/off in the child records to allow only those records to show that are most recent. But, this cuts off the ability to scroll through all records. Any ideas?

Is it possible to view only a selection of records (based on different criteria) that are placed in a portal?

My problem is surely quite simple, but I am a newbie at scripting. Here it is: I have two files: main and second, and a simple relationship on one field. A have another field with the same name on each base. I have a portal, on main db, with a button to go to the second db on the related record, select a field (container with graphic), copy to clipboard, select field to main db, paste picture in it.Manually, everything works fine. When I script it, it doesn't work. Where is the trick ?

There's probably an obvious and easy way to do this, but I can't find it: I have a portal that displays a selection of records from the same file, via a self-join based on a unique number. This is in order to display groups of records that belong together. What I want to do is to show a mark (red dot) in a portal row when the user is in the matching record. I've got it to work, more or less, by means of a button in each portal row that triggers a series of scripts that go to the related record, update status information, and note the current portal row number. A calculation field in the portal causes a red dot to be displayed when the current portal row number equals …

I have a need to display only a specific row of a portal (i.e. the second or third row). Is there a command that can do this? Thanks much.

I have 2 databases (CustomerDB and JobDB) related to each other. In my CustomerDB, I have a Portal Window that looks at the JobDB. How can I sort the records in this window by JobDate? Also, are the records in this portal window printable? When I've tried printing, it only prints out the viewable records - anything that below where the portal window needs scrolling, don't appear.

I have an 'Employee Leave Record' file which fields appear in a 'Employee Records" portal. I want to be able to limit the records appearing in the portal to a certain year. Right now all related fields to the parent record appear in the portal and I want to have the option of only seeing records for a specific year.

The information got messed up in previous posting: I want to show in one layout four different portals, each showing a subset of related records. These are the tables: PROJECT projectID project name REL_DETAILS index rel_projectID type [A,B,C,D] item detail The first portal should show all record entries for 'item' were type is "A", the second were type is "B" and so on. Would appreciate any comment. Regards.

I have a portal that allows creation of new records. Whenever I add a new record, that information is displayed twice, once on it's line, and also in the new blank line where the new record is suppossed to be. So a blank line for a new record is not presented, but when I click on the duplicate 2nd line (where the blank line is suppossed to be) and change something, it will also change the first line. Does anybody know what happened and how to fix it? Thanks

I need to show in a portal a selection of records of another file, the problem is that I must have a selection with 2 key: one a IDusercode and another a typology of service, have a solution?

Dear FileMaker Pro's, In my FMP db I'm using portals with scrolling window to display data from related databases. The empty portal for entry of a new record disappears when maximum amount of portal rows has been used. Users are forced to scroll down in order to add a new record. I do not want a button with go to last portal row which clutter up my layout. Is there a work around or a way to force this line up in the portal? Anyone with a brilliant idea? Rik [This message has been edited by SayIT (edited May 16, 2000).] [This message has been edited by SayIT (edited May 16, 2000).] [This message has been edited by SayIT (edited May 16, 2000).]

Hello everyone, I would like to know how a script/calc could look through a group of records and note which was the first to have a checkbox set; then somehow notify the following records of this fact so they could set themselves in response. This is in an estimate where the value of the first item's labor can be taken at full value, while those that follow lose a portion of their labor value due to the implied economy of scale. Thanks Bill

Can you have a relationship to a relationship? I have a portal showing item,model and part number all coming from one related file. The item and model are fields in the related file. The part is a relationship to a third file. When I add the part into the portal only one part shows for all items, and models. Is it because its a relationship to a relationship?