Portals

I have a portal that is defined to have a scroll bar, but one does not show. The portal is defined as having 4 rows, and I am looking at a person who has 5 entries, but there is no scroll bar to see the 5th entry. Any help appreciated, TIA

Hello everyone I have a nice puzzle to solve. First this is the structure for this part of the database. -Models tbl -Rooms list tbl -Rooms Line Item (related to Models) Fields: ModelIDfk, RoomIDfk, Qty, width, lenght, height, sq.feet, Nb_windows etc. -Products tbl -Products by room Line item (related to models and rooms) Fields: ModelIDfk, roomIDfk, ProductIDfk, Qty, price In the models table have portals for line Items: Rooms and another for products by rooms. 80% of the products that goes into a room can be defined by calculation from the Rooms line item. Example if in the bedroom there is 2 windows, there will be 2 air-heater. For eac…

Hi, can anyone help me with a puzzling problem. I have a layout displaying a portal. In the portal I have a field for dates. There are clusters of entries for a given date then clusters of other date. What i would like to do is display a separator line between different dates. I have tried creating a self join using a get(portalrow) calc field and get(portalrow)-1. This does not work presumably because get(portalrow) only returns the active field. Can anyone think of a way. Joseph SL

HI, Can we perform search in portal.if yes then plz suggest me can i do this. Thanks, Deepak

I have a portal that was showing multiple records just fine. This page tracks donations made to a non-prof, and when a donor name is chosen, it finds the correct number of records, but the portal only shows the first record. Also a summary field, which previously had shown the total of all records, now only show the value of the first record. All fields are inside the first line of the portal, and the portal is defined as 1 row with 20 repetitions and a scroll bar. Can anyone suggest what happened here? TIA

I was asked a question on a support forum for Non-Profit businesses about displaying grandchildren records rolled up to a child record via a portal. Here is the desired result: This is on a Parent of Donor... My first thought was to use the List function but that wouldn't give the desired effect of grouping the data, but I am not sure there is another way to accomplish the desired design. Any ideas? Thanks Kevin

Hi There, I'm having some woes with what seemed like a simple idea at the time. I'm using Filemaker Pro Server 8 on Windows. My database has uses 4 tables that are causing the woe: Contacts, Companies, Addresses, and Lookup. There are several many to many relationships involved: a Company can have many Addresses as well as many Contacts, A Contact can have many Addresses, etc. The Lookup table is used to track these relationships and I have scripts that add ID's to the Lookup fields to make this easier to maintain. Here's where I run into trouble: on the Contacts and the Companies layout, there is a Portal to Addresses that displays all the related Addres…

I have an application with a STOCKS table. Stocks Table is composed of: stockid.pk stock_symbol stock_name I have a layout based on stock. On that layout I have a tabbed interface. In a tab I want to have way for the user to add a new STOCK. I tried duplicating the Stocks table with Stocks2 and setting a relationship between them using stockid.pk (with allow addition and deletion turned on on STock2). [color:red] But, when I add a portal to the tab and base it on Stock2 I get only a single stock entry and not the list of existing stocks. Got any ideas? Thanks

I am building a database in which I want to use a portal that has a similar behaviour to the portal used in the Event Management Starter solution which is displayed on the Events->Details->Contacts tab. Namely, when clicking on the Name field in an existing or the new record row, a drop-down list of names (if they already exist in the Contacts Table) appears and by clicking on one, it is selected for use in that record. Since the field's control style is defined as a normal edit box and the table on which the portal is based seems in fact just to be a collection of pointers to the Contacts table, I cannot see how this drop down list is generated. I'd be v…

Hi All I have a layout (layout1) that has a portal in it. This portal is displaying 2 fields (field1, field2). There is a "add" button outside the portal on layout1. When this button is clicked, it takes the user to Field1 of the portal with the drop down list open. Now once the user selects data from the drop down list of field1, I want the cursor to land on field2 of the portal with the drop down list open for field2. I cannot get this to happen. Any help in this would be highly appreciated.. Thankyou

My staff and I are working on a room reservation database and we're trying to figure out the best way to show people the available rooms for a given start/end time. An event name is created in one table, a related table holds all the instances of that event, and a third related table holds the locations for each instance. Right now we've got a portal that shows all the instances (Tues 2-3, Wed 9-11, etc.), and what we'd like to do is next to it have a portal to the locations table that shows which rooms are available based upon which instance/portal row they choose. Our problem is that our search for available rooms is handled by finding all rooms that have conflicts (…

Hey First I need to say thanks for Søren Dyhr to create this calendar function back in 2006.. =) Called CalcVsGenSlots CalcVsGenSlots to quickly fill you guys in here is a summary what Søren Did. with my modifications Here is following tables and relationships Relationship Events::Start_time = schedule::cSchTime Events::Date = schedule::cSchDate Table 1 (schedule) Fields cSchID, | auto enter serial cSchTime | Mod ( SlotID - 1 ; 48 ) * 30 * 60 cSchDate | Let ( [ sunday =Contacts::gDate - DayOfWeek ( Contacts::gDate ) + 1 ] ; sunday + Div ( SlotID - 1 ; 48 ) ) Table 2 (Events) Field EventID auto …

hi guys i've got a single table to which 40 layouts are associated. these are layouts for print ads in different sizes. each layout has 6-9 user editable text areas. i need to display formatting rules for each text area the users can type into and need to display "x number of lines allowed, x characters allowed". the idea is that as user moves to the next text area, the formatting rules window updates and displays the rules for the text area the user is in at the moment. putting in validation checks for fields wouldn't work as the same "Paragraph" field might have 80 characters allowed in one layout and 100 in the other. the rules needs to be associated wi…

Firstly the last time I did some serious work was in FMP Dev 6. So updating a couple of solutions. I am having trouble with the long distance relationships (ha ha). I suspect this has been asked and answered before but couldn't find in searching, so here is my problem. I have 5 TOCs (Things)as follows Things A one to many to Things B one to many to Things C many to many Things E with join CE (D) in the middle. Things A -< Things B -< Things C -< ThnigsCE(D)>- Things E. The last many to many seems to be the stumbling block for me. On a layout looking at records from Things A I have a portal to show Things C (no problem). On the same layout…

I have a portal based on a self join (stocks) table. The portal is based on stocks2 and works well. However, I have an "X" button on the portal row to delete the portal row but unlike my other portals (which are based on regular tables related to STocks), when I press the X on STock2 to delete the row I was surprised to get "Do you want to delete the entire master record or just his one related record."? Deleting the Master Record deletes ALL ENTRIES in the portal .. wow! I would like the portal row to be quietly and quickly deleted without user 'approval' or a message. BTW, IN THE RELATIONSHIP JOIN, I HAVE TURNED on and OFF [color:red]"Delete Reco…

I am having a problem with overlapping portals. What I have is several portals each with one field that relate to the selection in a previous field. I am using the Portal Visibility trick which for the most part is working as expected. The problem is that the only Portal that allows editing is the topmost one in the layout. If I make a different selection in the previous field the correct Portal displays but you can not change it unless you go back into the layout and move it to the front. Is there anyway to make this work.

Hi, Is it possible to add totals to the bottom of portals? Or in some other way add a layer of summary to the layout that totals the data in the portal? Regards, Simon

Hi, I hope this has not been answered many times. My (seemingly?) simple problem: I have a parent/child relationship, and in the vast majority of cases there will be only one child. But there will be cases when there are two, three, or more child records, and those need to be accommodated. The chance of the number of child records growing to a large number (more than 3 or 4) is VERY slim. There are about 10 specific fields fields for each child, and a notes field. As in most cases it will be a 1 to 1, I am hoping to have a portal with all these fields for one record showing on my layout (like a little "standard layout" with the main layout). Then place buttons…

I apologize if this has been answered, but I can't find it. I have a file that uses a record ID and date. I have a self join relationship for matching record IDs and the date sorted as desc. FileName = Fiber Relationship = Fiber Shearing (match to Record ID in Fiber, sorted by date desc) Example: Fiber Shearing::Date in current record = 7/1/09 Fiber Shearing::Date in prior record = 6/5/08 I need a calc field (Prior_Date) to retrieve 6/5/08 in the current record. I tried: GetNthRecord ( FIBER Shearing::Date_Shorn; Get (RecordNumber) + 1 ) but that does not use my sort and retrieves the newer date into the older record. I know thi…

Hello, I am still pretty new to Filemaker but have done a ton of reading. Anyways I have a MYSQL database that I am working with that is used for lets say keeping track of stuff. What I have are a lot of fields that depend on the previous field. So I put them in Portals and I have Calculation fields set up and also relationships set up. The problem is that on new records the Portals will not display when the correct previous field is set. However on existing records on the database the Portals work fine. I have played around with setting the Allow records to be created option for the relationships also. An example of one of my calculation fields: case…

Hi. I'm brand new to Filemaker although fairly handy around MS Access, Oracle etc. Here's my problem/question: I have to tables - for the sake of this example, I'll use card. So the parent contains makes of car (Ford, GM, VW etc) and the child table are models. The related field is the make. I want to be able to scroll through the parent (car makes) and any child records (models) of that make should display all the fields of the child record in a form (NOT a row!!!) but in several columns and laid out in an arbitrary fashion to my design. I only want a single model to be displayed at a time and the vertical scroll bar (or another mechanism (button?)) s…

HELP!! I'm completely new to FM and am trying to create a timesheet database where we enter 2 weeks (one pay period). I've got the entry set up & it works exactly as I want - the problem is running reports. I have 2 portals going to different tables (LinesWeek1 & LinesWeek2), and now I need to merge the data for project reporting. Is this possible or have I completely messed up my entire structure? Can someone please review the attached file & help me figure out where I've gone wrong or what step I'm missing to do these reports? The report I have is only pulling off of one of the Lines tables. Thanks in advance from a newbie! Time_Sheet_Database.zip

Hello guys, I have a table called documents. each document has a code and a version. I have a layout where I need to display the document evolution: basically some data for each previous version of the same document. I have created a relationship between documents and documents (this instance is called documentsByCode) and I have tried different way to set the relationship up but no one works so far. Any ideas about how I have to set the relationship up in order to display for each document its history? Thanks and have a nice day

Hi. I need to do the following. I have a portal with, say, three fields per line. I want to give the user a button so that it will go to a script and put info into one of the fields in the portal. How do I have a script that will know how to go to a field in a particular line in a portal, or rather a field in a particular record in a portal.

Another problem. Say I have a parent record. I then have a portal with multiple records for children entry. I then have a button that should do the following in a script. Delete all the portal records for this particular parent and then create a number of portal records for this parent. Example: Parent Jones, children Fred and Agnes. Have a screen that shows the parent - Jones - record with all the basic info. Then I have a portal that has two records, one for Fred and one for Agnes. For whatever reason, I want to, with a push of a button in the parent record, delete Fred and Agnes and create children records for Pat and Mike. This is a simplification of what I really nee…

I'm relatively new to filemaker and have gone through a few books and the FileMaker training series but have been unable to find a way to do what i need to do. I setup a test database to try this before i created the actual database. The database will have 2 tables, one for clients and onefor claimants. On the client layout, i have a portal with a relationship to the claimant level which shows any claimants that are attached to that client. My question - Is there a way to open a particular claimant from the portal? The software we currently use is called TeleMagic. We have the database laid out in the same fasion. So if i were to open lets say client #…

I use FM for my clinical laboratory. Patients pay their dues in one, two or three payments. How can I make a portal to keep track of these payments for each patient.

This is probably a stupid question (there are no stupid questions..right?) Right now I have a Portal setup I don't really like. I was wondering if anyone had any insight into a calculated Portal, if it even exists. Right now I have a related table, and I only want it to return records based on two variables. I know what both variables are, One is an item number, the other is a Status. I have many Statuses stored in this table, but I only want it to return a certain one... lets call it "A" I had to create a Global Variable and keep it populated with "A" to fulfill the other condition of the portal relationship, the Item # wasn't a problem, it is already …

This is probably an easy question, but I can't find the answer. I have a script that as it runs, it populates another table, which I can see instantly on a portal. What I want to add to the beginning of the script is a test. I only want the script to run if the portal is empty. I know there is a isempty() function, but I am not sure how to use it. Right now I have it say... go to Portal Row [first] if(isempty(?)) where the question mark is, I am not sure what to put... How do I test to see if it is empty?

Hello. My name is Nick and I'm relatively new to Filemaker. This is my first time posting on these forums. I looked around and didn't see this question asked, so if it's been answer already, please point me in the right direction. Thanks My question is this: I want to be able to see and interact with a global field through a portal. I've actually gotten this to work before, but when i changed the fields to globals, it stopped working. I'll try to explain as best I can. I have a table and a table occurence with identical fields. I've set it up so that the portal on my layout is validated if a certain field is set to "yes" from a popup menu. So when the value in …

I am designing a database for a university that professors will use to log courses that they have taught. I have three tables: Staff, Courses and Course Records. I would like the professors to be able to open the course records table and select their name from a drop-down list, then be able to narrow down the list of courses by selecting a department (eg biology), a year (eg 3) and having the results displayed in such a way that he can then select the course that applies to him and continue filling out the form. I have managed to get the drop-down list using a list of values that takes from the name column in the Staff table, but i am having trouble with the cour…

I set up multiple filter fields to limit a set of records shown in a portal. The filters work fine unless a field contains records with no data. Any records will null data in a field are not displayed. How can I show all records including those with null data. This is how it is set up... global filter field: _z__FilterStyle_gxt Calc fields: _c__FilterStyleStart_uct _c__FilterStyleEnd_uct Relationships _c__FilterStyleStart_uct ≤ Style__lxt _c__FilterStyleEnd_uct ≥ Style__lxt Script on filter field triggered on modify: Commit records/requests (no dialog) Set Selection [_z__FilterStyle_gxt: Start Position: (Length( DIR_Import::_z__Filt…

I have a database that records patient's medications in a portal. Field order = Medication, Dose, Date_1st_prescribed, Date_discontinued. A patient may be on multiple medications in the one category (eg: sedatives or antidepressants, etc and I have a number of portals, by medication category, stacked in a layout to handle this). I have two queries. First, how can I find and display specified portal values for a single patient? To clarify: Patient X might be taking three medications in the "anxiolytic" category portal (but the portal for reasons of space and usability displays only two rows). Over time the patient may discontinue a specific medi…

I have a portal that contains three fields: Vendor Material Price The portal sorts by price. For any given material, the least expensive vendor shows up on top. Is it possible to create a (4th) calculation field that queries this portal result and selects the top (least expensive) vendor for purchasing purposes? I like the portal to display my options but I would like the calculation to automatically select the least expensive of those options. Any ideas how to do this?

Hi all, I am creating a portal and from that portal I want to populate records of another table. I am doing this with set variable and set field. The problem is that if I click more than once the button on the portal row, the script create duplicate records. Ideas to avoid this duplication?

Hi I have a button inside a portal. If there are no related records, the button/script is not activated. Is there a clever workaround for this, other than simply placing a second scripted button outside the portal? Any help/suggestions much appreciated. : Grant

I've got a unique situation, in which I have multiple unique records that need to share a common identifier. Basically we have information from 4-5 different sources that contain similar (albeit unique) information about the same record. Basically the pseudo-structure of the data is: 111 1 2 3 111 2 4 5 111 3 2 1 111 5 1 2 222 5 8 1 ... I'm looking for a solution in which I can populate a table with said data, and display the records on an alternate layout inside a portal. E.g. I will have record XYZ within a layout that corresponds to the records identified by 111, and I want a portal that will auto-populate a single row for each correspondi…

Hello, I'm the classic "guy at company who was asked to make a database and the expectations have gotten out of control.." etc etc. I've developed and populated a shot tracking database for VFX on a film. My principle entities being: Shots Elements Assignments Artists A shot is comprised of several elements. I do not have a join-table and...unfortunately, instead of using a portal I, in my inexperience, used an interface with 6 foreign keys connected to 6 occurrences of the "ELEMENTS" table to allow a user to import elements into the shot tracking. That much of it works just great. What I haven't been able to do is form a portal in an Eleme…

Yes another one that searches for hierarichal things. : I've searched the whole day on google, but i couldn't find anything that will help me. i will explain what i want. I have a table with content and another one wich says it's an parent or an child ----------- [ content ] ----------- [ -id ] [ -text ] ----------- ----------- [ link ] ----------- [ -parent ] [ -child ] ----------- so... [ content ]-----<[ content ] How can i make an Hierarichal portal for this? thank you verry verry much! grtz Ravenix

Probably not possible: I have an EmployeeMaster table which is the source of a layout in form view. I would like to have a portal in the bottom of the form view that lists the Employees. In addition, and when a find procedure is used, it would list the found set. Since the EmployeeMaster is the main table and not available as a related table, the EmployeeMaster table cannot be used in a portal. Is there one of those exotic tricks that exists to accomplish this task?

Hi guys, in my invoice solution I have 2 different lines with object in it (1 with items and 1 with services). In my invoice layout I also have 2 different portals for these 2 lines. But I'm have some difficulties printing these 2 diffrent lines on the print layout. I already tried printing one of the line items and that worked perfectly. How can I make this work? Thanks

Hi, This is more of a general question about another portion of a database I have been designing and I am not sure how to proceed. I have to track the location of a given item from one location to another (the item having been sometimes shipped to various locations before returned back to its place of origin). I want to create a tracking history of this item and also want the main database to only display the latest location of the item. How is that for confusing. Anyway, any pointers would be great. I was thinking relationships together with portals? Bridge

Hi, I'm switching form MS Access to Filemaker Pro 10 and now I have a problem with my portals. I have two portals in two different forms ans in one of the form I get a new blank row to insert a new record automatic on the other form this doen not happen. I've checked everything but I can't see any difference in the portals. So where do I set the portal to an automatic new line to insert a new record Thanks

Hi, I'm having trouble with sorting my records by a timestamp. I want the newest record to be on top of the portal, but when I sort in the portal by timestamp_creation it will put the newest day at the top but have the times backwards. The oldest time is on the top. Any help would be much appreciated. Thanks, Bryan Anderson

Sorry.. just using the post to upload a file to link. Database.pdf

Greetings. Is there way to group portal rows? ie instead of showing a value for each item, show the sum of each category's value? Does anybody know how to do that? Greg

Hi all, I use Filemaker for quite a while but I am new to this forum. I am stuck with a problem and i don't know if it is solvable, but I think Filemaker should be able to deal with this. I want to create a (graphical) table in which the items are all costs. Each row stands for a person and each column for a specification. I want to pick the data from a (filemaker)table that holds the following fields: eventdescription person cost description (of cost) At each event one person will have more sorts of costs and I want to see all these costs on one line with the person. When using a portal I get all the records for one person with the different s…

Hi All. I have a script that returns to the portal row it originated from but the selected row is showing as the last visible row in the portal. Is there some way to make the selected row appear as the first visible row in the portal? Thanks for any help.

Hello all, I'm having trouble with record creation via portals and was hoping someone may be able to lend some pointers. There are Contacts, Companies, and then many things that each can have and share such as Phone Numbers, Addresses, Fax Numbers, etc. Contacts should also be able to relate to Companies as well. I've created a large join table called Lookup that can hold all the foreign keys of each related primary key in the other tables. I want new records in Lookup created to tie them together, which works 'half way'. If I add a Phone Number from the Contact layout in the Phone number portal, a new record should be created in Lookup with the two ID's. When…

I am using a letter in FM and use <> <> in a form letter that allows it to dynamically alter the size and spacing. I then used a portal to bring data from another database and when using the same form letter the first and last are not seen on this letter. The fields are <::first> and <::Last>. Is there a way to include this information in the form letter in the database that the information is being portaled into. Thanks in advance for any assistance.

Hello all, I posted on another thread with no luck so I thought I would start a topic to see if I could get the answer I was looking for. I am trying to sort a portal with header buttons that sort ascending when clicked and descending when shift clicked. I have the ascending part working with a global field and a calculation field. I have set up a global that sets to 1 or 0 depending on click or shift click. Now I am stuck. The instructions I am working with are lacking in detail at this point and I can't figure out how to tie it all together. Does anyone have a link to some detailed instructions on this method? I would like to mention up front that I…

Hello all... I have a layout with a portal that shows all sales data for a system I have. The portal only shows about 15 records and there can be many more records. I would like to setup a second portal that only shows the last record created with the portal row highlighted. So Portal A shows all records and Portal B right below it will show only the last record created and highlight the portal row. Any ideas on how best to set this up.

Hello, I'm pretty new at filemaker and could use some help. I'm keeping track of "submissions" in my main table. In each of those "submissions" there are "fundings" that I manage in a portal on the main "submissions" page. Each of these "fundings" also has forein keys from "Authorities" and "Area". So: Subs -> Fundings One to many Auth -> Fundings One to many Area -> Fundings : One to many Everything works fine up to this point, the trouble comes when I try to add in a new element to the mix, "positions". Each "funding" can have 1 or 0 "positions", which I"ve done as: Fundings -> Positions : one-to-one (the fact that I have a o…

Folks: am running a button/script off a portal row to bring up a mini-window to allow more editing room in one of the fields. But I keep getting this prompt: "This record cannot be modified in this window because it is already being modified in a different window" Any insight into how to resolve?

Hi everyone, I'm working on the Client Database at a homeless shelter, and we need a lot of assistance. We've got two important fields, Admission Date and Departure Date. They are displayed in two portals each. At the top of the form they are side by side and are used for simple entry. At the bottom of the form they are in larger font and are for display in a table, showing a history and being used for calculations. The operations staff at our organisation decided that it would be best for them if both sets of dates were listed descending, with the most recent dates at the top of the list. So there are two problems: 1. The new portal rows still sh…

Hi ! I'm wrestling with my database and now I'm stuck with this problem: There are invoices in one table. They have Status: "not ready", "waiting for approval" and "approved". The accounting can choose which invoices are shown in the portal. The problem is how to present the Total of each sub group, when portal data is changed. Now it shows only "Grand total" of all sub groups (i.e. even though the invoice is not "approved" yet, it's sum is added to "total") I hope you understood... ???

This is probably dead easy but I can't get my head round the best way to do it! I have a table called calender (A list of dates and activities) which I want to display as a portal on the frontpage of my application. That bit is easy. However, I want to only display future tasks. If I wasn't using a portal I would probably just perorm a find on the calender layout and just display future dates. Am I able to perform a find on a portal so that it only displays future tasks? The way I would probably do this normally is to write a script which did the following: show all records sort by date goto record nearest current date set orderfield as 1 go …

HI If I create a portal and place field in it they show up and work perfectly. If I decide that I want a colour fill (say white)in the portal then the fields will not show or come to the front of the portal. Any of the templates do this and it works and I cannot work out what I am doing wrong. Can anybody help? Glenda

Is it me or they didn't fix the problem with multiple portal in FM 10? I need 6 portals and in each one there is another one. How can I fix this problem? Thanx Here's a printscreen

Is there a way to determine visible rows in portal? Or to scroll a specific row into the visible row 1 position? Here is the issue, I have sets of data in a portal and as the user selects the master record in the above portal, the child portal below scrolls that set into view showing 1st row of that data in first row. I had the scrolling working by scrolling downward far enough that the first row set of data would appear in first row. But this all broke when the portal auto-sizes for larger screen resolution. So if I can get an answer to one of the first 2 questions then I should be able to do what is needed.

I find that the "delete portal row" script step doesn't work when I have the layout in Table View. Is this a known bug? I attach a small FM database to demonstrate. The 2 scripts work correctly (deleting a portal record from a related table) when the Main Table layout is in Form View or List View, but not when it is in Table view. For this test file, I've set up two different sorts of relationships: (1) a relationship from the Main Table to a secondary table called Other Table; (2) a self-map relationship from the Main Table to a second instance of Main Table titled Main Table Self-Map. In both cases, the relevant script will delete related records onl…

I am adding data to a file via a portal and after adding it I want to print it out. No matter how I design the TO relationship I can only get it to display the portal row with the lowest portal row ID number. How do I point to a particular row so I can print just the one row??

I was recently looking at some template files that came with the software, and this one in particular caught my attention. I would like to use something similar to the portal in it and was wondering if anyone could walk me through setting this up in my own database. Any help would be very much appreciated. Resource_Scheduling.fp7.zip

I'm having trouble with this and it may be because conceptually I've got it wrong. What I want to create is a portal which displays all records from a table, that contain a certain value. However, when I placed the portal in, all I get is one record at a time. I think my relationships aren't right, or perhaps I need to create an extra table? Any help would be much appreciated.

Hi all, hope someone out there can help... I am working on a workflow management system. I have a table that stores job stages and a related table that stores time logs for each of the job stages. for example a job may be created with a job stage "Design - Concept" and the operator may then log hours against that job stage on a few separate dates. I am stuck with producing a calculated field to evaluate all related timelogs and then returning the newest date for the related jobstage. So if the operator logged time entries against job stage "Design - Concept" on 01-Apr-09, 04-Apr-09, and 05-Apr-09 I would want the calculation to return 05-Apr-09. Than…

Am I crazy or is FM10 resetting portal row positions if any script step runs after a "Goto Portal Row" step? Previously in FM9, in this same script, "Revert Record/Request" could be run after the portal position step to pop the cursor out of the field used to step into the portal and the visible portal rows would not shift. In FM10, the portal always resets to the top. Anyone else seen that?

I'm new to FM, just got version 10 a few weeks ago. I'm proficient in an old legacy database program (filePro), but it's time to move on. I have a database of equipment. A portal relationship (to "servicehistory" table) holds the service history for an item. When available (i.e. the info gets written on the work order), there is a field for the hour meter reading, "hourmeter". I want a field in the main (equipment) table set to the most recent, non-blank, hour meter reading entered into the portal records. I spent several hours on it today. Everything else about FM has come easily, except this. Portal records are sorted by date, with the most recent ap…

I have a layout with two portals, each one shows information from its own related table and users can insert files in both, one portal for images and one for pre-recorded speech. I defined a script to insert files in portal 1, it works fine, but when I assign this script to a different button for inserting files in portal 2, it always points at first row in portal 1; each one has 3 rows, so I thought that possibly filemaker saw portal 1 (rows 1, 2, 3) and portal 2 (rows 4, 5, 6) as two pieces of the same portal, then, in script for portal 2, i used the script step "Go to portal row (4)" which would be first row of the second portal, but it didn't work. I'm confused, …

Hi all, In my university database, I have a portal which includes the fields of subject, year subject offered, not offered etc. Problem 1 I want to create a layout (letter) where I can selectively choose particular subjects to appear in the letter. Currently ALL the subjects appear (or as many rows as the portal has), which is not what I want. I want to selectively choose subject 3 and subject 5 for instance, to appear in the letter and no other. How do I do this? Problem 2 There is also a script set up as a button which database users can press to email individual students if a subject becomes available. Again, how can I selectively choo…

Hello all, I hope everyone is well and in good spirits! I'm looking for some direction/advice. I have just started working on an inventory solution/daily sales log. I just wanted to make sure I can accomplish what I'm after using a portal or portals. I have attached what we have been using to keep track of daily sales. (its a .pdf of an excel file) I would like to have my portal automatically display all the active items and look pretty close to the attached file. I threw a quick portal together and the drop down method works fine but i would like to make what Im working on as close to looking like what we had been using. A friend of mine put one together w…

Hi everybody, I hope i can get some help with this. I have a layout which allow users to insert sounds, or images, using a portal but, while images seem to work fine, when i insert mp3 files, i can't play them using double click on them. i was having trouble with this, but i found solution in this very forum, RIGHT HERE ; my own previous solution was to use a join table, (many sounds in one article - many articles can have repeated sounds from other articles), the problem inserting one different file in each different instance of the sound container field was very similar to that exposed in the link above; when i was trying my own solution i could play the mp3 files…

How do you show a found set in a portal? I have a very simple 1 to many relationship.

I have a portal to display line items for an invoicing solution. I've inserted a small graphic into the portal row and set it as a button to delete the row when pressed. When I create a record in the portal, it always shows the button on the next line. I've seen other solutions where this is not the case, but cannot figure out how to fix it?

Hi all, Please could you anyone help me out with this. I have tables invoice Product material In the InvoiceItem portal I have a quantity field. In the ProductMaterial portal I also have a quantity field. In a layout from invoice, I pull all the materials from the ProductMaterial Portal, but the quantity field always goes to the 1st field of the InvoiceMaterial,any suggestion on the calculation of the quantity field to go with the invoiceitem. Thanks for any help.

Here is the problem I'm trying to solve. I have a layout for invoices. In the layout is a portal for invoice line items. Each line item has a VAT code and VAT value and net price. I want to show a 'VAT breakdown' on the Invoice screen. This needs to be a dynamic list, with one line per VAT code. So if the number of invoice line items is 20, and between then there are three VAT types, then the 'VAT Breakdown' will show three lines, with the NET totals for each line. I don't want to hard code fields, one per VAT type.

One thing that draws me to FMP is how esthetically pleasing one can make the layouts. So I must be missing something basic when it comes to portals. I have a portal with alternating color rows. Looks great when no row is selected but when a row is selected all the fields turn to the same color and good-bye attractive layout. I know how to make the fields uneditable and have the user do her editing in another set of fields outside of the portal, but that isn't desirable. My goal is for only the selected row to change colors but not all the rows. Is this possible?

How do I do this? Hi, I have a FileMaker Pro 9 database that I am using to catalog material from 40 Indian tribes, and group by material type. Material types includes objects, images, people, media and "stories". My goal is to set up the database so the client can input all of this material on one or two layouts, each layout appearing to be one tribe's slew of material. I have made different tables for all the material assets (objects, images, people, media, story). I have also added a table called "TribeTribe" to act as a master tribe table, intending for the client to "create a new tribe record" for each tribe's collection of assets, as the client recei…

Hi all, stuck on a portal problem and wonder if anyone out there can help. I am working on a simple workflow management solution. The bit I am scratching my head about is as follows: I have the following tables: contacts, jobs & purchases. A contact can have a job related to it. A job belonging to a customer can have a purchase related to it. I am working on the purchases layout and I am wanting to create a popup 'chooser' window with a portal in it where the user can select a customer (dropdown) and the portal shows only jobs related to the chosen customer . I have made a few attempts at this but am not quite getting the relationship righ…

I recently upgraded to FMP 10 Advanced from 9, and while happy with many of the new featurs, today I'm appalled to discover that some very basic functionality in one of my file seems to have been compromised. What I built in 9 is a portal from a Main table to a 'Join' table that displays keyword 'tags' from a 'Lexicon' Table on the other side of the Join table. So -- Main titles joined to a Lexicon table via a Join table since A Title can have many Keyeords and a Keyword can have many titles. It works fine in my FMP9 solution. I have a filtering portal that allows the user to assign keywords by clicking on them, and another table displaying the terms already tagge…

Hi all, Please could you help me out with this. I have 2 tables... Table1 and Table2 Table1 contains orders Table2 contains the status of the orders In Table2 for each order there can be several records - each time an order status changes The order status is changed via a portal to Table2 in Table1 So against a particular order in Table1 I will go to the portal and set the status to ordered, or processing, or shipped etc Each time I change the status it is creating a record in Table2 just with "OrderNo" and "Status" and a date/time stamp. Now a seperate layout in Table1 I want to show the current status, so I reference using the rela…

I have a portal on a layout in which I need to show a number of fields and buttons (so that the portal row looks like a record in list view as opposed to table view). How can stop the portal row from showing as active if the user happens to click in the portal row? I want the user to be able to click on the buttons as normal. All the fields in the portal have been set to not allow entry in Browse/Find modes. Any advice?

Hello, I've got a page I would like to create, and can't work out a way to do it. I want to list all my clients at the top half of the page. I then want the bottom left of my page to display Client related details based on who is selected in the top list. The bottom right of the page will display all linked jobs associated with the client selected in the top list. I have attached a diagram of what I'm hoping for. Any assistance would be appreciated. Regards, David

Hi there, I am looking for a way to make a portal completely „non-clickable“. On my layout there are two tabs: The Edit tab contains the normal portal where related records can be accessed the usual way. On the View tab I’d like to show in certain cases just a greyed out image of the portal. I know that I can set the field behaviour of my portal fields so that the user cannot enter them in Browse mode. But the scroll bar would still be accessible. Thank you, Mike

Hi, I have a portal for users to input data. After users input the first two fields, I want to do a search to see if there are any existing records in the portal have the same values in these two fields and then highlight the existing record for users. My problems are: 1. I don't know how to highlight something in portal. 2. How do I trigger the script when user leave field two? Currently I am using FMP 9, I heard FMP10 can do that but I don't plan to update at this time. Thanks in advance for your help.

Show latest date in field. I have a portal row that displays products with date of purchase, on my main layout I would like to have a field that displays the latest date of the purchased product. How can that be done? Thanks

Hello I have 2 portals on a tabbed layout based on a self-join between a table of booking records. The first tab displays sub-sets of bookings according to Payment_Method "filtered" by a selection in a global field outside the portal. One Payment_Method is "credit card". On the second tab I want to display records where Payment_Method="credit card" and where another field CCAuthCode=0. Is there a way of doing this without creating another TO of the booking records. Thanks Paul

Hello all, I'm trying to solve a problem, and need a bit of guidance in the easiest solution. I'm modifying an existing db to suit my needs. In one table I have a list of items sold. So there will be anywhere between 1-10+ items (records) per transaction. Each item ordered is a separate record. Each "sale" has its own invoice number. For example, for invoice 0001, there could be 10 records in the sales history. So there will be 10 records and the constant will be the customer number and the invoice. Then in the customer table, I would like to have a portal that lists just the total per invoice so I can see their past order history. No need to list eve…

Hi folks ! I have a portal and button script configured there "GoToRelatedRecord" on it. It works fine, if there is a related record. Is there any way to configure it to create a new related record (in the same button script), if no related records are yet present ?

I have 3 databases: Quotes - Line Items - Products. I want to be able to create products from the lines portal located in the quotes database. How do I do it? Someone help?

I have noticed 2 things with a portal that seem to be acting as if there is a bug, however I could be doing something wrong. So I am looking for input. The following is my situation. I have two tables that are related through a field called "ActiveContractID". In the first table (the table being browsed) the field is a calculation as follows: Case ( ActiveContractName = "AFF" ; AFF_ContractID; ActiveContractName = "VF" ; VF_ContractID; ActiveContractName = "SP" ; SP_ContractID; ActiveContractName = "FIAV" ; FIAV_ContractID; ActiveContractName = "alFresco" ; AlFresco_ContractID; ActiveContractName = "Inspired Doc" ; ID_ContractID; ActiveContractName …

Hey Everyone. Could anyone explain to me how to sort a portal? I have two databases connect via "x" relationship. I want to be able to sort the portal by month and I would also like to make some sort of button or something to only show the top 5 recent records. Does anyone know how to do these things? Thanks for the help!

Jeez -- I've gone 'round and round on this for the past hour. I have a portal displaying item records from a join table with an "Insurance Value" field accessible to the user to set $ values. Just below the portal I have a Summary Field that totals up the Insurance values. (I have it set up as a text Merge Field since its display only) Basically, it works. . . But I'm struggling with the various ways that user behavior can make the Summary Field update itself . . . or not. If the user enters a value in a portal line item and clicks out onto the layout, the Summary field refreshes itself -- but if instead they tab to or enter another field directly, the Summary fi…

Long time reader, first time poster. Hoping someone can shed some light on a problem I'm having. I want to track the progress of Applications. Within each application can be a number of clients, so I want to create/list the clients in a Portal within the Application Layout. I also want to click on a specific client within the portal to show the Phone, Email, and Address of that client. I have attached the sample file I'm working on for your review. I would like the button marked "View" to populate the fields at the bottom showing the Phone, Email and Address fields. I have found similar posts, but I am a novice and couldn't come up with a solution for my…

i have a portal where i have set-up a table in which a crosstabulated total for each year is being computed (Stats). i would like to know how to create a numerical change auto-compute field to be placed beside the fields so the user can be notified of the changes as well as the difference. concept sample is on layout "What I want to accomplish". if my description isnt clear enough, pls look at the 'Stats' and 'What I want to accomplish' layouts in the attached fm7 file here . thanks in advance

I created a portal that is supposed to have different values in them but when ever i try to add another one, it replaces the previous one rather using the second line. I am very new to this program and I would be grateful for any help. ex: i want it to show two records that are unique (pre-set from a different table), but it only shows one, the most recent choice.

I'm in the process of trying to set up an inventory/order system for our company. I would like user to be able to enter the lot number and quantity of a product into the order main layout and that data draw into a portal for the Lot# and automatically deduct the shipped qty from the stock qty. Currently I have two tables: Order_number and Lot_number. In the Order_number table main layout, users can enter the lot # from which the product is being pulled in up to 3 fields: Lot_ID1, Lot_ID2, Lot_ID3. Users then enter the qty of product in fields: Lot_qty1, Lot_qty2, Lot_qty3 respectively. I have a sum field that sums those three lot qty's for a total of product shipped.…

Arrghhh -- I've spent the last half hour rooting around the forums in search of a thread I read last fall about various methods people use to create child records -- not by just typing into the last portal row (sloppy) or by scripting their way to a child layout (clunky) -- but by simply running a simple "Set Field" script that triggers record creation in the Child table via the realtionship (with record creation 'On'). I posted a question about this on a year-old thread, but not sure such things get seen by anyone: http://fmforums.com/forum/showtopic.php?tid/193433/post/318322/fromactivity/myposts/#318322 Any help? I feel there something important here I'…

Hello. I am having trouble deleting portal rows and would really appreciate some help. I have 2 separate files that connected who relationships are connected with one able to be deleted if the master record is deleted. Whenever I click to delete a child portal record from the parent a pop up box appears that says "permanently delete this one related record". Even with the portal row highlighted, nothing happens. So then when I click out of the portal row to commit the record, the entire master record deletes. I am so confused. Any suggestions???

Hi there, I have 3 tables: Orders, Order Lines, and Items. On the orders layout I have an Order Lines portal. I have a transparent button on top of the portal row and a platform below the portal for adding, editing and deleting records. I can delete portal records from a button on the platform. Yeah! I would like to add new Order Line records by selecting Items from a drop-down on the platform. I think I need to establish a working relationship between Order Lines and Items. I have a relationship, but since there are no Order Line portal records yet, there are no Items showing up in the drop-down! Do I need some kind of utility relationship? How do I do t…

I am trying to create a portal on the AI Advisors Note layout, but the data is not show. Can someone help me figure out what I have done wrong. AI_Tracking.zip