Portals

I have a portal in a Purchase Order Input layout that relates to an Inventory table. The inventory records have various item numbers, and each item number has size variations. When an item has a negative "Available" value, I want it to show up in the portal. The problem is that all of the size variations that are negative availble show, and I want only one of each item. In other words, I need it to function like a value list. I can create a value list and use a drop down list, but I prefer to use the portal if possible.

Hi there I have an Client layout with an portal with number of personal to do with the Client. On the portal row I have placed an Button with scripted to receate pop-up window where I have log on that personal But what is happening all the other personal on the portal seem to link to the same log! How do I create an new unique log for each personal? attached is the database (have look at the client layout and the portal) Looking forward to you throughs as I bit lost on where to go from here Kind Regards Damian BD_job_tracking_v4Clone.fp7.zip

Hello, I'm trying to do two things which on there own are simple enough to do, but they don't seem to work together. The first is to filter a portal (in my case, I'm using ExplodedKey and ExplodedString as well as a checkbox set) and the second is to highlight the current portal row selected in my viewer table (see Viewer Table Demo from Foundation Database Systems). The relationship between my pref table and the portal_list table doesn't seem to allow for the filters to work with the highlight. Any thoughts? People.fp7.zip

Hello, I need help with a portal that will update automatically every time users open the file. I am using a global field in table [To Do List] and a text Field with an auto enter calculation in table [To Do List 2]. This works fine if you update the Due Date Field manually. The problem is I have over 2,000 records in the table and this number is expected to increase fast. The idea is to automatically display records with the following conditions [Do Dates] < [Current Date] and incomplete tasks in the portal. Please advice me what will be the best way to accomplish this task Thanks. To_Do_List_Copy.zip

When viewing a database record with portal row with a number of portal rows the portal rows refresh slowly when you scroll up and down using FM 8.5 and XP. This does not occur using OS X 10.4.8. Anyone know of any work arounds? I have spoken to FileMaker tech support and they said this is expected. I view it as a bug.

Hi, I am attempting to use the table filtered two different ways through different portals. I have tried to link to a global field, set to the filtered value, from a separate table. I have also tried global field on the main table. Both give me a blank portal. Any help would be appreciated. I have attached a copy of the layout that I hope illustrates what I attempting to accomplish. Bill test.zip

I have problem deleting portal record with the X button that I created. Whenever I do an edit portal first and I press the delete button, the "Permanently delete this ENTIRE Record?" appears. BUT when I directly press my X button without editing the portal record first. the "Permanently delete this one related record?" appears. I check my relationship between my main table and portal table "Allow creating" and "Delete this related table" on portal table both checked. And for the main table both unchecked. What did I do wrong? Please help.

I have a portal -- lets say a To Do List to give a visual. I have made everything I can including putting a button that runs a script that sends an email with what I need. The Problem is that I need the Script to only look at the subject box of the line I am on (Portal Row) that I hit the Button on. Every time I use the Script it looks for only the top most portal row -- the most recent one. I need it not to do that but to capture the portal row that I am on and use the subject line on that portal row. Can some one write this script? Thank you

I have a portal that shows me data from a join table. I need to put a button that will run a script that will pull data from the id field in the portal row, and find the record in the master table on the other side of the join table. How do you pull data from a field in the portal row. I know this is basic, but I can't seem to make it fly. If I can get the data out of the field in the row, I'll be fine. Thanks for your help. Steve.

Hi, I'm designing a layout that will be used to print records. I have a portal that shows a list of items that can be anywhere from 1 to 29 items in length. What I would really like to do is make a portal that has 2 columns and 15 rows. That way I can make the entire printout just one page. Is this possible? Thanks, js22

ivve just read anothr post that says this isnt possible : but whats the answer? basically i have a portal of contacts who work for a company on the 'companies' layout. because a single contact may have many phone numbers and there can be lots of contacts i created another table for contact numbers. so basically i want to be able to see (on companies layout) all contacts and all thier phone numbers. lil help? p.s. if ur confused by all the fields in the 'contacts database dev' table its because im working with a 5year old DB, jus updated to 8.5 and im giving it a major functionality overhaul and the data is currently in that table.

Hi all, I've search around for something like this - and I can't find an example... AND I can't figure out how to do it. In a portal, I'd like to have alternating row highlights not by every other row, but every other occurrence of a field value. For example, say I have a portal with 15 items listed. I'd like a container field with a alternating white/off white shade to fill in based on groups of records. In my 15 items, I have a number field. The portal is sorted by this field. If in these 15 items I have 5 different numbers - ie. I have 5 sets of items (3 records each) that have the same number, I'd like to have the portal display with the 1st set of numb…

I posted this a few weeks ago but really had a chance to look into the problem so lets see if I can be a little more descriptive. The problem: Blank records are being created in a database(this should not be happening). Background: I have sorted through some things and found that the relationship between this database1 and database2 is an(=) and has the checkbox "allow creation of records into this table via the relationship" under database2. However when I uncheck the box I am no longer able to use the dropdown box (as in it becomes unclickable)on the database1 to see the files of Database2. Question: Is there a way to set this relationship up to still …

I know I should know how to do this, especially since I've done it in FM 5.5. I have a portal displaying on a page. I want to be able to hit a button and add a record to the portal. Previously in 5.5, I had relationship set up which was a field with a "1" in it relating to a field which I would do a set field to through the relationship to that field. This is odd, but would create a new record and enter the data I specified in the set field every time I hit the button. I can't get this to work in 8.5. Is there a new/better/different way to do this? Thanks, Mike

Hello, I'm having a problem with a custom portal sort. The sort is based on a value list that is made up of related records from another table. I have created a table of Shakepearean productions. On the main layout is a portal that contains a list of actors and the characters that they play. For example in a production of Shakespeare's 'A Midsummer Night's Dream' I have a list of actors playing various roles including Hippolta, Oberon, Theseus, Titania etc. I want to show the actors that play the most important roles first so I have another table where each record contains a role name and a play id that is used to link it with records in the table of production…

When I changed the data of related fields (Date, Code Number or Firm) The records of portal disappeared How can I solve the problem? Thankz Study_Portal.zip

Using FM Adv. 8.5 I have two files: UI_file.fp7 doclib.fp7 I want to provide users a way to assign publishers and authors to a document from a list of each. The list should dwindle based on already assigned authors or publishers. In the UI file I have a pop-up with portal showing the list of not-related publishers (for example). This is working and is based on a List() function calc in the doclib file. As this number of rows in the portal grows I'd like to be able to filter this list using a VL (A-Z). The attached screen shots show the TOG, the pop-up picker window and the relationships. There is a separate pop-up for authors and publishers. …

In FM 8.5, I can't figure out how to show the number of portal records found. I just want a count of the related records!

Hi, I currently have a portal filtered by 3 different criterias that go from global fields on the parent side to the child side. The interface and the data is also seperated out into seperate files. The globals reside on in the interface file. So the filtered portal is working but the user also wants the ability to perform finds. Since the filtered portal can not be used to perform finds because of the multiple key relationship, I am assuming that i have to have them do a find on another layout that has direct access to the other data correct? Has anyone ever created a filtered portal with the capability to do finds as well? Any recommendations or tips?

Is there a way to display portals rows horizontal instead of vertical?

I've attached a sample file to show in general what I'm up against. So let's say you have two tables, the parent table is books and the child table contains all the proposed titles. So you have a layout showing records from the parent/books table with a portal showing all the related records in the child/titles table. Now, what I need to do is have the ability to select which title is current so we can retain the list of all proposed titles but track which one we are currently going with. So that boils down to a primary key of sorts in order to make sure only one title is selected as current. So that's what I have in the sample file. The only…

Ok here a sample file of what I am trying to do. In the Routing table it is a list of parts and in the Routing Data Table contains steps these are master files that are for initial building of the traveler tables. These are like MASTER RECORD for each part number. The Traveler table get its the information first by typing in the work order pulling the Item number then based on that number it pulls routing header information from the routing table. Information is changed in the traveler table it is not reflected into the Routing Table. Like wise, once a traveler gets the information once from the Routing Table, changes to the Routing Tables do not modi…

Hi there, I'm using a portal in my database which I wish to automatically populate with some data (roughly the same data is looked at for each record for which the portal exists). This data may be wanted to be deleted or changed by whoever is entering it however. I do have a value list containing everything I need to be in this portal. Would the proper way to go about doing this be make a script which, on creation of each record, populates the fields which the portal is drawing from with the auto-enter data? If so, how would this script work? Thanks a lot! Michael ps If you need to see my file to understand this better, let me know.

Hi, I have a field - gender. I need to count number of males and number of females in the portal!! when i do count function it only read the first one in the portal. I want to be able to say Select Gender = "Male" and Count. what do i doo??? please help!?!

Hallo people, I have a set of records, where each record needs to be conected to a different set of records.(a subfolder of records in a record). How would you do this? I'm stuck!! Thank you in advance!! (this forum is saving me as I'm new with FM!thanks)

Hello All! I have a portal loacted on one of my files. This file is called "Addressbook" The Portal is supposed to be gettings it's information from the table in the file "ToDo" I have created a link going through the "Task" field joining up the two tables. Everything works fine when i click on the portal to add a new reccord. BUT, i don't want to do this. I wan't to go into the file "ToDo" and create a new reccord. But, when i do this, it does not appear on the Portal. How can i get it so that it will display all of the reccords found on that table? Thanks.

Hi I think I being a bit thick but I am experimenting with relationships. I have a products table and a quotes table which I want to be able to add products to my quotes layout I beleive the best way to do this would be to use a portal and add products into this? Thanks

Still rusty on portals. I think these questions are pretty elementary, but they're beyond me and my Missing Manual. The db I'm developing is for a gallery, so includes contact information for artists and detailed entries for their works. 1. On the artist's rolodex entry, a portal shows a list of all works by that artist. A container field to the right of the portal wants to display the graphic included with the related record I'm clicking at the moment. Layout necessitates that the cotainer can't be inside the portal [to register, the repro needs to be 150 px tall]. It displays fine the graphic associated with the first record in my portal ... can I convinc…

I have a portal (lower half) and I would like to have the data shown in the portal always sorted by what exists in the "Title" field (upper left). What I would like to have is a search function the moment I commit to an entry in the Title field, so that it shows me in the portal below, other items with the same or similar names. I can then select the item row in the portal and have the upper half of the screen populated with that record. OR select nothing in the portal and start a new record using that title I entered, and hit the "New Entry" button to save it. What I'm doing is a database of Apple II peripherals and related items, by catagory, condition, …

I think I've really designed a bad database structure! I've been asked to create a database to store confidential information on students. The district already had a student management database which is structured so the data is stored in an admindata file and the user interface is accessed through a separate file. Following this structure, and not wanting to be responsible for making modifications another developers databases, I created a new file called Student_Info. This file contains one table and all of the fields are globals. There is only one record in the file. On the opening layout, the user sees a portal related to the admindata file which displays al…

I have been developing a db that generates a "purchase order". Everything has been great,with help from this forum, until the users asked for another item. We need to be able to list all the products that make up ABC product below the ABC Product Description. Currently I am using a portal that the users pick the products, this in turn populates a table that I draw from for various reports including a purchase order. I have been looking at sub-forms but unless I categorize every product (10,000+) I don't think it will work. I was thinking about multiple portals. Add another field to the details table and pull from that. Can multiple portals be u…

Hi everyone, this is my first post. Here at work they forced us to change from Mac to PC (using FPro 7). We had a bunch of databases developed on the Mac. They work on the PC except for horrible printing problems. Most of the time what looks OK on screen prints out scaled way differently, with lots of stuff chopped off. My experience is that the first time I preview a report it looks OK. Then I print it, it comes out all screwed up and afterwards the preview on screen is all jagged and screwed up. Our PC-newbie systems admins set up a postscript printer for us to use so we could play with the scaling, but it still doesn't work consistently. It appears that FPro just can't…

Lets say I have 4 tables. Names, Items, a Join table, and a global table for an interface. The basic relationships are Names to Join, Join to Items, and then an interface table with global fields in it to Names. There is a value list created that shows all the related records from Names to Join. In the interface table I have a global field that I want to use a match key to find all records in Name that have a certain item number. In the Names Table, I have a calc field that returns the value list items of the Join Item IDs. So for lets say Bob, I will get a result of: 5 7 9 10 So When I type 5 in the global field I should get Bob in the portal I have on…

I have FileMaker Server 7 running on a Windows box at a remote office. In one of the databases I created a portal with a sort order that is controlled by a value list. The value list contains the following: Annual Dec Sep Jun Mar I can login to the FileMaker server, open the local FileMaker client and view the portal with the correct sort order. I can also access the database through a VPN using my Mac FileMaker client and see the portal in the correct order. What baffles me is that Windows clients on the remote office computers sees the same portal sorted alphabetically as: Annual Dec Jun Mar Sep

I need to put the portal row number into a field so that I can export it. I cannot use @@ as whilst it gives each row a number, you cannot export it. The sort order will always be exactly the same. TIA

Ok I have a portal that works great, it shows the user the information he needs to see. However the information is tied to timestamps dates which are required for a report. So i do not want the user to change the information in the portal just view it, so I locked the fields. I have a button that sets var. from the contact table and set fields in the call table with freeze window all that, and it works. My question is I'm trying to create another portal with one row so the user can click the new button and enter information into the 1 row and have the other portal just to see information it sort of works but the user can still change the info in the 1 row portal. …

I have a portal where I display the delivery addresses that have been used in the past for the current customer/dept. combination. Is there any way of filtering this portal so that any address only appears once no matter how often it appears in the relationship? TIA Phil

I am attempting to display a variety of dates which are entered through fields with drop down menus. I want the user to be able to select certain date "types" select the date and time, and then press a button which displays a list of the entered dates and related types and times in a portal which Is sorted by date. I have managed to write a script which creates a new record in a related table and displays the info correctly, however when you then change one of the drop down options it changes the item in the portal. I guess I'm missing a final step in the script which includes a "do not edit" from this field (I'm hoping you could still edit the portal field in the portal …

I just learned how to relate the same table occurance allowing me to create a portal on a form layout within the same table, but after thinking about it I thought I had read somewhere that portals would not work in a web published enviroment. I started out with a separate list view layout and had a header containing a couple buttons, and then later read that the header would not work properly in a web published environment. If both of these things are true is there another approach to accomplishing my objective. I would prefer having a list type view contained on the same form layout if that is possible. Thanks for any suggestions.

In FMP 8.5 does using a portal still lock (flag as in use) the current record and therefore keep other users from accessing the same portal? Edit: Clarification If 2 users are on the same record of a shared database and one user accesses a portal (activates the portal by scrolling or clicking into the portal), does it keep the other user from accessing the same portal with the new version of FMP 8.5? I know this is the case with earlier versions of FMP, I'm just wondering if this is still a limitation in v8.5 of Filemaker

i have a portal that is set for 25 records. Most of my portals want to show more that 25 so I have to scroll through them. Is there a way to print the portal and all the record it contains. I presently only get what i see on screen.

I am working with an order entry system that I have designd and am using a protal for the first time. The order entry pages has all of the basic customer information and the portal is linked to "Line items" for which an individual order may have 2 or 30. I'm trying to make the printed copy show all of the related line items regardless of the number, but can't figure out how to expand or slide the protal (or the information below the portal) to do this. It seems as if the only way to adjust the "View" is by specifying thhe number of rows in the portal set up box. I would like the portal to show as many or as few line items as are related. Help!! Thanks!

I need to know how to calculate a total / subtotal of a revenue field summarized on the value of a second field. For example: Summarize total dollars based on blue, green, red orders. How can I make a running total field or script / report to gather this info? Can provide v8.5 sample file if necessary.

I am trying to create a purchase orders database. I am new to filemaker and I am struggling with certain aspects of it. In MS Access I created a subform and allowed the users to select the item and the rest of the subform populated then peformed calcs on the items chosen. The purchase orders where then created based on the orders table that was created. I think I need a portal to do the same thing in FM. I have managed to get the portal and do the lookup but I can not get it to go to the next row. Our pricelist is 10000 records long and some orders will have only 3 items others will have 30 items. I don't want to do a lookup because each line has to be in…

I have a portal where I have two fields Brand and Total Spend. I get the correct total spend but when it displays each record instead of just the brand name and total amount. For example: Brand $100 Brand $100 Brand $100 etc... How do I get it to just list each brand once? Thanks for any help.

I need a simply way to get a count of the portal records in my layout. The portal is part of a reporting module. It is linked to my main job tracking db. I have various portals that show me jobs printed on a certain day, shipped on a certain day and whether or not they are late based on a comparison of due date and ship date. I would like to have a simple counter at the bottom of my layout showing me how many of each I have in a given day.

I'm trying to filter portals with checkboxes. Each record in the portal can have 1 of 5 different status's. Above the portal is a checkbox for each status. I'd like the user to see only the records that match the status of the checked items. After working on this for several hours I'm beginning to think it can't be done in Filemaker. It seems I need an "OR" instead of "AND" operator when creating the multi-value relationship. I've attempted several workarounds with no success. Has anyone solved this or have I ran into a limitation of Filemaker?

Several places in our in house solution I have layouts with a portal that has conditional graphics calculation fields to highlight a particular row or rows in the portal. If the value of one of the fields in that record matches some value of another field, it uses one graphic, if not, it uses another graphic. Often it is highlighting a row that the user has clicked, which in turn has filled in a field in the master table which controls what is shown in another portal. In FileMaker 6 and previous, I could do this and the row in the portal that is in essence where you click to get a new record would be using the graphic which was for the no match condition. In 8 it …

I have an order entry database in which each record originally had a container for the artwork that is to be used on the order. The quickest method I had of inserting the artwork was to simply copy the elements in the Illustrator file and paste it into the container. Now that I've been doing this for over a year and the file is getting rather large, I've decided to move the artwork to a separate file and put a portal with the artwork container in each record. This will keep my order entry file smaller. Ideally, I'd like to set it up so that the portal would show all the artwork for that customer (I could have it show only one portal record and then scroll throug…

I have made a database to track my client's invoices. Each client may have many invoices and each invoice may have many line items, each with a value. I wish to be able to see a list of a client's invoices in a portal with a total for each invoice and a running total showing the balance of their account increasing with each incvoice listed. The problem I have with the way I have set it up is that when a line item is modified in an invoice, the running total in the portal in the clients layout is not being updated. Changing layouts and going forward and back one record does not update it, but quitting and reloading the file corrects the running total. Could …

How do I make a field that will show the portal row number like this eg: 1 of 7 In other words it has to show the current row number and the ammount of rows?

Hi people, 3 days ago I started learning FMP, so if this question seems a drab, then 'xcuse me. I want to create a hybrid view; form and a list on one layout. Portal seems perfect, but the problem is, it "wants" to show data from related tables only, not the same table. How is this layout can be achieved? Thank you.

I have a portal in which values are automatically entered via a script. I just went in and resized the portal, moved a few fields around, and now when I go back to browse mode, I suddenly can't edit any records in the portal! Previously, if I wanted to edit one of the automatically-entered values, I could click on the field in the portal and change it. I have no clue what I did to make those records suddenly not accessible--anyone have any ideas? Thanks in advance for any help...

Hi All I'm new to filemaker and having problem creating a payment system. Basically I’ve a table for customer order which have it own unique ID. Customer will leave deposit and pay balance on pick up or lay-by the order. I’ve another table recording all customer payment with unique ID. What I’m trying to do is create a payment system such that payment is link to Order. The problem arise when customer have more than one order but one payment. How do I go about sort out this problem? Please help!!!

If I want to have a user click on a record displayed in a portal row and go to that record on another layout, how do I do that? I'm a bit stumped on this one. I know it is probably simple, but any help is greatly appreciated. Thanks.

Superior knowledge requested! My Portal allows creation of new records, and this works fine - enter data in fields on last portal row and the record is created in the related database upon commit. However.... ...can I 'shuffle' the order of these Portal records? More specifically, all I want to do is click a button (in a row), which adds a blank record above (or below) the row with the button in it. Make sense? I guess some kind of sorting might be the key. Currently records are NOT sorted in the Portal, which is fine (records appear in the order they are created). Possible??

Hi, I assume someone has does this before. I want to add a column to the portal that will show the line number. This will allow me to do a quick count of items. Thanks, Skip

Here is what I would like: A portal showing one row that has a number of fields, and a button that will move the user from one portal row to the next. I can do this, if I choose "Show Vertical Scrollbar." It works exactly as I wish, and I just don't use borders, so the user never sees the scrollbar. In IWP however, the scrollbar is visible. What I need to know, is rather or not it is possible to use the Go [Next] Portal Row script step when the portal does not have a vertical scroll bar. I can't seem to maek the portal change rows if the bar is not there. Thank you.

I have read several FM books, read every forum thread and downloaded the samples, I even understand the CONCEPTS, but dang it, I cannot get this to do what I want. I am aware it will take you seconds, so I defer to your judgement: I have a list of Courses and ClinicalParticipants. Some of the ClinicalParticipants are hospital employees (TJUH), and some are not. I want to filter the Course portal to show the course expense based on all records in the portal, employees only, and non-employees only. I can't get the global filter in the right spot to be related to the right field. I know I'm inches away from the solution, and I dissected so many other databases to …

I have been using portal filtering for some time but came across a potential error that I am trying to resolve. When my portal filter is empty the calculation used in the relationship defaults to "0" (zero) which shows all of the related portal records. The problem that this creates is that any filtered fields that contain data starting with a non-alphanumeric character do not show up in the portal when the filters are blank which is not the desired result. To put it another way only items starting with 0-9 and a-z will display when the filters are blank. So I need to switch from using "0" to using some other chacter that is lower on the indexing list. I …

I want to have a "Duplicate order" button to duplicate a purchase order. Since the ordered products info was from a portal, it only duplicate the order info like PO#, date... the product info would be left blank. Is there a way to carry over portal records from the last record? I tried Go to Portal Row (last) then duplicate record. That only duplicate one portal row within the same PO. Not what I want. Thanks a lot for any help. -- MTG --

I know this has been discussed before but I can't find the posts... I have a table HISTORY in which I would like to place a portal to show certain records in HISTORY. I want the portal to be filtered by three different global fields. FILTER FIELD RELATING FIELD gContact_NameFirst <===> Contact_NameFirst gContact_NameLast <===> Contact_NameLast gContact_IDnumber <===> Contact_IDnumber (g meaning the global fields that I'm using to filter the portal. gContact_IDnumber and Contact_IDnumber are both number fields, while all others are text fields) Basically the portal is not working. If I eliminate 2 o…

hi there I am building an EPOS system and i need to have portals on screen. Problem i am having is the fact the scroll bar for portals is small and cant for the life of me work out how to make it bigger and this is causing problem using touch screen to operate it, is is possible to make it larger? withough having to use the zoom function! Cheers Ben

I want a portal to display 4 fields from reccords in my database Basically i have a database of people, and i want a portal to simply show the age, birthday & last name of, for example, everyone with "John" in the specific field. (their name) How can this be done? i can do it if it were in a different file, but where i want it displayed and the table are both in the same file.

I have Cases and Products (many-to-many); so I have a join table: CaseID ----< [CaseID|ProductID] >----- ProductID In the Case Table I have a field: zg_CaseID (global filter), set to a current Case ID. On a layout tied to the CASE TO I can display a portal with the related Products (from the Case_CPJoin_Product TO). What I'm struggle with is that I want to show those Products NOT related to the current Case (thus the user can select from this list without seeing the products already assigned to the current case, avoiding duplicate assignments). See attached picture (yes I know the TO name is messed up!). TIA

I hope this question is for the "portal" subject but Ill ask it also in layout. I want to create a ledger. I have 2 logical tables. Checks Due (amount, date) Checks Received (amount date) both of them have foreign key that represent a deal (where the money should be arriving in several payments) and I want a ledger to be created. where the lines are sorted by the date order. and I would have a total down at the bottom (or even a balance field on the right of the line) can I do it with portal? can I do it in a report? should I combine the "receivables" & the "received" tables into one table? I really dont want to do that.

Posted this in "Relationships" but no reply...so I give it another shot here as I still could not make it work...found something similar here but not quite the same problem, so: I'm working on a db with several files. One file (called "Links.fp7") holds all the links if records from one file are matched with others (like matching a Contact with a Project etc.) and it works just fine. Related data is displayed in protals and also the matching itself happens there. The problem is matching a project to another project. I set up the relationships in the Links-file (see attachment1) and it seems to work fine there. But I can't figure out how to draw the right i…

Hi there, I’m very new to portals, but somehow I find that portals are quite useful to an extend =) I’m creating an image database using tabs, and i had my image data records displayed in the portals, but when I delete a particular record, all my records will be deleted. I tried the delete record script and the direct delete record in the Browse Layout using the Menu bar (, ) but both will delete all my records. Plus, once I do a search, I can’t view all records in the “Image Overview” tab. How do I rectify it? And, is it possible to use a global container to contain the portals? Coz I just want to have 12 images/portals to be viewed at one time, so if I ha…

Hello I wasn't sure where to post this, I'd like to have a feature where users can browse files on our server then add a link to the file so that when another user clicks on the link it opens to folder containing the file they selected or the file its self we are using only macs. Additionally I'd like them to be able to access this feature via IWP, any ideas or capabilites that aren't present.

I am trying to create a Real Estate database. For each record (client) there are approximately 10 date fields which I need to monitor. Do I need to create a portal to display the list of dates in chronological order for each client? I am also hoping to have a "summary calendar" which lists all the upcoming dates for all clients on one layout, again in chronological order. Any advice would be grateful, I'm really struggling to work out how I can do this.

Hey all: I'm new to filemaker and relational databases. I am trying to create an application for handling orders of gift cards. My five tables (so far):/ Customers (customerId, customerFirstName, customerLastName, customerAddress1, customerAddress2, customerCity, customerState, customerZipCode, customerPhone, customerEmailAddress) Vendors (vendorId, vendorName, vendorAddress1, vendorAddress2, vendorCity, vendorState, vendorZipCode, vendorPhone, vendorEmailAddress) Cards (cardId, vendorId <-FK, amount, discount) Orders (orderId, date, customerId <-FK) OrderLineItems (orderLineItemId, orderId <-FK, cardId <-FK) OK, good enough.…

I searched the forum and couldn’t seem to find this, but I am sure that this has been requested by others. I have a portal and want to show the last related record in the portal. I have People > Jobs (one person to many jobs ) and Jobs> Contracts (one job to many contracts). I have a job portal on a People layout and I would like to display the last contract written off that job. <> I was writing a script and this is what I have so far… but it’s not updating the job_display field GTTR Go to Record/Request/Page ([Last]) Set field [Job::c_display_last_contract;Contract::cn_apptperiod] Go to Layout [“People” (People)] Go to field [Job…

Hello everyone, this is my problem: I have a field/value list 'Group' in my contact management db (i.e. Supplier, Client,...) formatted as a pop-up list. I would like to have a pop-up list of only the 'Suppliers' from that Group in my second db - purchases. I tried really hard, but being a beginner it is starting to smoke over here ...... I would be grateful for any advice/direcetions. Cheers.

I need to have Add Record on, but I don't want buttons in the last row to show (Export File and Delete). As a test I created a calc in a field of the portal file case ( isempty ( THE_Data_Field ) ,"", UI:Delete_Icon ) Works, no delete icon shows on the last "row". I'm just annoyed that I would have do that all over my tables where needed. Aside from the fact that I tested for a single field instead of a record present (TBD), Was there a more logical, easy method? I have a UI file, a Data file, and a FileLibrary (too chicken to store many file attachments to my "real" data.) The UI has image files to use as icons (instead of pasting/inserting on l…

I'm trying to implement portal filtering in this example and it is not working. I stripped down my example to 2 files: pft_ui.fp7 (the ui file) pft_data.fp7 (the data tables) Base Tables: Cases Status Status Assignment (a Case-Status Join file) I want to display a list of Cases in a portal from a layout (HOME) in the UI file (pft_ui). In this portal I want to show Case ID, Case Name and associated Case Status. I then want to be able to filter on the Case Status to show All, Open, Closed, etc. I've read the other postings and Chapter 16 of SEU FileMaker 7 by Steve Lane, et al., on portal filters. However I can't seem to get …

Hi, I want to have a portal (cause I need to interact with each lines), displaying all my products broke down by categories like in the pictures attached. I already know to do the categorie only portal (depicted in Categories_tree.jpg). I want to do a portal like "Product_tree.jpg" I have 2 tables one with categories tree and one with "products to categories" It can't be a report, because I need to have it in a layout and I need to interact with each line. It should work in multi-user environement so I guess generating a table for display is out of the question.

I have a problem to show the Fields from the "Inventory" tabe to show up in the "Contacts" Table. I created the "Inventory" fields in the contact table but none show, is it a relation problem? How can I get those relations to work? Thanks for the help Thomas Graph.pdf

I have a TO with the classes I teach. Each class/semester is a different record in that table. They all have unique IDs and are all labeled by the dates they are taught. What I want is to have a portal in a different TO that will show all the classes I am teaching this semester. I will use a drop down menu on that layout to pick which semester I want to see. Any and all help I can get is appreciated.

Hi All I am trying to make searching easier for my users, so have included a calculation field in my record that just concatenates all text entries for a given record to allow users to just type one query in one box and search against all the fields in that table. However, I have had to expand the database to include a second related table that is viewed as a portal from the main record. Does anyone know of a way that I can include the data from the related records in the portal to the concatenated calculation field? Hope this makes sense - feel free to ask questions if it doesn't... Thanks in advance yoshi

hi i have i don't have enough experience to solve my problem. how can i make the scroll bar of the portal to look like typical mac's scroll bar, not like windows'?

I have a main layout with two related portals. Portal A has two columns of data. I would like to add a button to the layout to move that data into new rows in Portal B, then be able to add additional rows to Portal B if necessary. Can someone please tell me the best way to copy the data into the second portal? Thanks very much!

Hi All. I have a portal with several fields, all based on a year. There can be multiple portal rows for any given year. i would like to add another portal on the same layout that will show the sum of a couple of the fields for every year in the first portal. for instance it would look like this: portal 1 2005 | 200 | 100 2005 | 100 | 100 2006 | 50 | 100 Portal 2 2005 | 300 | 200 2006 | 50 | 100 Can anyone help? Thanks!!!

Hi, I have a table with a portal that is the garden variety Main table with sub-list type of thing. I want to create a button that will make a new record in the portal, NOT the main table. How do I do this because I tried to use a button but only adds a new record via the main table. I really need to make this part of the DB all button driven. Thanks Vandy

Hi, I was wondering if it is possible to join the text from each field in a portal so you can mail merge it. Eg. Instead of this....(bill and his related records (car,bike and boat on 3 seperate lines) you can actually join the related fields into a field on 1 line seperated by caridge returns??? bill | [email protected] | Car Bike boat If possible you could then mail merge each person and their related records. If it is not joined you only get the first item in the merge. Thanks in advance Beastman

I have these 2 files connect like relational there is a field called protocol in the Project Tasks (PT) layout Note, that I want to link to Projects (P) you can see I connect them in the view Note Layout [if ask for other file do not need to open just cancel] the thing I cannot do is to put more option of the protocol field or add more Projects to a Project Tasks like 3-4 different for example a field about movie 0056 can be connect to politics 0042 or internet 0044 Any solution? DMAProjects.zip

Hi. I need some guidance: I have two tables, one with event registrations (T1) and one with promotional items (T2). In T1, I have a portal where I select the attendees and then I pull down a list of items that mirror, but are not yet correlated, to T2. I want an inventory field in T2 to decrease as the field in T1 is selected. If you can help, I'd appreciate it. Thanks!

Hi quick question, i searched but couldn't think of the correct words to use to search for my problem i have a port related to a database, with a list of products in it. on a layout showing a quote form. so my 2 tables are Quote and Products. the portal has a few related products to the quote. i want to take all the product names and put them in 1 feild one under another. "Product1 Product 2 Product 3 " and so on. all i can find is to add numbers together from related records using a calculation feild and the sum function. can i make a loop to get the data out or is there a function that can do this for me?

Hi, I want to create a multi-criteria portal and I'm having trouble with the logic. I have 3 ordinary text fields in a DB. I want to use global fields based on their indices to 'constrain' or 'filter' the portal. IOW ... I want to enter a word in the 1st global and see all matching records in the portal. When I enter a word in the 2nd global, I'd like the portal to 'constrain' the matching records and the same for the 3rd global. That's hard enough for me ... and I haven't managed it yet ... BUT! I'd also like it, if I could leave the 1st and/or 2nd globals blank and find matching records based on the 2nd and/or 3rd fields. Can anyone give …

Hello,a beginner here . I have portal showing customer/invoice no./order no. I want to be able to click on a specific order no, and that will allow me to bring up all records showing same order number. thanks preferably put it in another portal buy opening a layout would be acceptable

We have developped a fairly complex solution to help manage restaurants called BC Resto. Our main layout displays several portals linked to different tables. Unfortunately we are experiencing severe slowdowns when our program is used on a PC : On Windows XP, whenever we change something on the screen (adding a record, modifing a field and commiting for exampe) all of the screen redraws (even on top of the line brand new PCs) On the Mac, only the modified portal/record/field redraws. Is this a BUG ? Is there a way to change the way Filemaker redraws the screen ? Could someone attending devconf ask a Filemaker engineer what is going wrong ? You can d…

Is there an easy way to have it so that when I double click a related record from a portal it will open that record in a different specified layout? I don't see any simple way to do this in the portal setup or behavior. I tried to search for this in the forums, but it's a bit hard since I can't sort the search results by relevance, only the newest records come up at the front, but I'm sure this has been asked before. Perhaps relevance can be added to the searches in the forums so more questions are not duplicated. Or if I'm missing how to do that, let me know. Thanks

Hi Guys I have a relational DB that uses a left hand colum of navigation as well as the header. I need to create a list view for companies using about 5 fields but obviously cannot use the standard list layout as it runs edge to edge. I have tried using a portal but no matter what I do I can only get the details from one record to show on the first line of the portal. i.e. not all 200 records. Can anyone help

I have what I hope is a simple problem. I have a report that prints, among other things, images through a portal. The portal has three rows (the only field on each row is *picture*), and is set to slide if there is less than three photos. My problem is that one extra row prints when there is less than three. So, if there are three photos, they print, if there are two, three rows still print, but the third is blank, if there is one photo the second row shows up blank, and if there are no photos one blank row shows up. Any suggestions? Thanks!

We use an FMP order processing system for call-in orders, and after the order is taken, a "send mail" script runs to let accounting know to expect payment. However, in cases where the order contains more than one item (related records is a LinteItem table), the text calc in the "send mail" script step is only capable of sending the first item on the order. Is there a way to include all related records in a "send mail" text calc?

Hi Friends, I have a layout based on a person table. I would like to connect 2 people together based on a relationship like friend, wife etc. Because each person can have many relationships, I created a join table and linked it to another table occurrence of the person table. My problem is choosing the second person on my layout. I can enter the type of relationship (saved in the join table) but can't choose or type in a person reaching through that relationship. Can someone help me with an easy solution that I just can't see? or do I have to do it with a script? Thanks so much. D@rrylW PersonJoinTest.fp7.zip

I seem to be full of questions this week... Sorry again if this has been talked about before. What I'm trying to do is create a script step that will filter all results of a field so that the portal only shows what you're looking for. It's easy to do if its not a portal. What I have is 5000+ songs that people can play if they select them. Sometimes the name might not match what the people will be thinking so a search works much better in this case than filtering based on the first couple letters in the title. I'll attach the file, I'm currently just working on the songs layout to get it to work properly. jon Wheatland.zip

I am trying to write a calculation for a field that will compare a fixed date to a list of dates within a portal. If any of the portal lines has the fixed date then the script should return a value of "Yes." Within the portal the fixed date will never occur more than once per record. This is what I've come up with, but it is only returning yes if there is only one entry in the portal and the entry matches the fixed date: If( MultiplayerInServiceDate = Dates_Titles::AirDate;"Yes";"") where MultiplayerInServiceDate is fixed and Dates_Titles::AirDate is the field within the portal. The actual portal is in a layout that is based on the Titles table, not th…

I have a portal going on some of my layouts, and when you click on a field the portal entries show up as the background color I'm assuming because the fields are clear. The background color is brown, the portal color is white so there's a bit of a nasty difference. I need to have the fields be clear because (a) I have a highlight field to show the one selected and ( I would like to have alt bkg fill on the portal. This seems like a simple problem that has been solved before, so I apologize if this has been on the forum before. Thanks for any help or direction! I can attach an example file if the description isn't that good. jon

I have three table occurrences in my file: PAT Patient (record of every patient, with a field patientID) HCP Provider (record for each provider available including specialty area with a field called providerID) HPT PatientProvider (one record for each provider assigned to a particular patient with patientID and provider ID assigned) In the main patient entry layout, I have a portal based on a relationship between PAT and HPT using patient ID as the relationship. This shows which providers a patient has. It also allows creation of a record in the HPT TO every time another provider is selected for the patient (allow creation of new records is checked). The…

I had an example file a few months back of a contact list where you were able to select a record from a portal and it would show up on the same layout. From what I remember it was built off a self-join table, but I can't remember how exactly it went together. Does anybody have an example of this? I believe the one I had was an example for not showing the extra buttons on the last portal row. Sorry, I've been searching for this solution for the past couple hours and can't seem to find it. jon