Portals

Hi all - thanks in advance for any help you can offer.  I'm currently working on a report to show average keyword ranking (in Google search results) for a group of keywords, reported at monthly intervals.  I have a table which stores the average ranking position of 4 keywords, "marzipan", "flower paste", "ready to roll icing" and "fondant icing" each month (stored in field "SR_Keyword_Position")  In this table I also have a summary field ("SR_Average") which calculates an AVERAGE summary of field "SR_Keyword_Position"  I have a list layout for this table with a sub-summary part which has the "SR_Average" field on it which summarises the average ranki…

Apologies - I *think* this is a portal question, but it might be that something more fundamental is amiss in my approach... Apologies in advance..  I am working on a scheduling management application for a festival. We collect submissions from artists in a webform in which they also indicate their availability within the 8 days of the festival. Currently this is expressed as a single text field generated by the web form, users are given the option to select am, pm and evening (the broad structure of the festival day) - so the result is a field something like "Mon AM, Tues PM, Sat AM" for each submission.  What I'm trying to create is a schedule form whereby i…

Hi all - I'm working on a reporting tool to display the number of facebook page likes a page has and track it over 3 months. I have a portal displaying the number of facebook page likes over a 3 month period (portal fixed at 3 rows) (portal row 1) 31-Dec-2013 Facebook Likes: 1806 (portal row 2) 31-Jan-2014 Facebook Likes: 1917 (portal row 3) 22-Feb-2014 Facebook Likes 2017 I need to calculate the increase / decrease between the first and third portal row eg: difference between 2017 and 1806 (211) Any ideas on how this can be achieved? I can only seem to summarise totals / averages etc with summary fields.

Let's assume this structure TableA-----TableB------TableC - - TableD TableB-TableD relation is 1:1 If I insert a portal of tableC in the TableA layout and I insert a field of TableD in that portal, the field displayed will not be in relation of the tableC record (the portal table). It seems to display the last value of the the tableD field associated to table B. Basically to make it work I had to create an occurrence of table D and link it to tableC. Any way to avoid this ?

After creating a related record in a second window, I have a script that closes the window, returning me to the original window where my portal is then the final step in the script is to perform a window refresh. Unfortunately, the portal does not show the updated record until I manually perform a refresh either with the keyboard shortcut or from the menu bar. I think it has to do with the relationship being based on a global field (I've tried both global text and calc fields with the same result). Is there an easy workaround that I'm missing? Thanks.

]Hi,   First I want to apologize for my english language, which is not perfect.  I'm  trying to prepare some database for my own small company. For start I've used the FM starting point, which I'm trying to modified for my needs.    The issue that stopped me, is that I cannot populate a Portal related on (line table between PROJECTS and PRODUCTS) using a pop up Window. The option or technique to use a pop up window I choose, because on PRODUCTS table I have more then 500. records, which is uncomfortable to find some product   I attached the screenshot of the button script, but I cannot attach the script for the Pop up window, so I preferre…

Hello, A client reported that his wife, who does the accounts, noticed an extra row was appearing in her invoices. This row showed two fields containing '0' (zero) but formatted as 2 place decimal. When I investigated I saw that the empty portal row in the 'Sales Items' portal where the original items are created has these two values set. First shot was to go to the Sales Items and see if there was a phantom one. No. Once invoiced the items show in a file 'Invoice Items' and these are listed in another portal on a different layout. I produced what I consider to be a kludge fix by turning on portal filtering and doing this: not IsEmpty ( Sales Items::Code )…

I have 5 tables. Servers Software Relationship Service Service Defined The Servers table is populated with all the servers in my IT dept The Software table contains all the software from the servers combined. The Relationship table shows what software is contained on what servers. Some software is installed on more than one server. The service defined table will have two portals on it. I choose a service from a dropdownlist and then begin to set the servers associated with the service. I want the 2nd portal to show the software that is on that server and when i add another server to the service i want that portal list to add the software that is on that …

Hi, I have a Country table (CTY) linked to a News Article table (GPN) via a joint table. I am having difficulty getting a portal to display related records from the joint table, and have tried but couldn't figure out why. All I want is for the portal to display the title of the article. The portal in question is in a layout of the CTY, and is showing related records from the joint table, which has a calculation field that gets the article title from GPN. Somehow the portal is unable to display the calculated article title of the joint table. The calculation field in the portal is persistently empty - I enabled field entry in Browse Mode and found it has no content…

I'm a FM noob...so I apologize beforehand. Trying to learn as I develop my database. I'm developing a contact management database. The majority of the database is typical. The part I'm having difficulty regards a recurring 'event.' I want to be able to have a set of fields that show date, time, contact type (follow-up, 1st contact, etc), and notes that can be searched. This set of fields needs to be able to be repeated infinitely so that I can add a new field each time I contact them. It needs to be able to search and do reports on my database...such as search for contacts with last follow-up greater than 2 months ago.

I am wanting to do a simple questions survey. I have a participant table, a questions table, and a Results table. I would like to show all the questions entered from the questions table in a portal linked from the participant. I would like to record the result of the question in the Results Table. I understand that you can create a copy of all the questions in the results table for each participant, but I don't want to fill the results table up with unnecessary records. The attached file is a simple version of what i am trying to do. Please help Survey.fmp12.zip

I currently have a portal showing all invoices attributed to a given client. At the moment, I use the following portal filter calculation to filter based on the 'Amount due' balance (i.e. invoice status) for each invoice (using a drop-down list Client::InvoiceFilter, on the layout); Client::InvoiceFilter = "Show All" or Client::InvoiceFilter = "Show Paid" and Invoice::Amount Due = 0 and not IsEmpty (Invoice::_pk_InvoiceID) or Client::InvoiceFilter = "Show Unpaid" and Invoice::Amount Due < 0 and not IsEmpty (Invoice::_pk_InvoiceID) or Client::InvoiceFilter = "Show In Credit" and Invoice::Amount Due > 0 and not IsEmpty (Invoice::_pk_InvoiceID) What I want is f…

Hi all, Couple-days-lurker, first-time-poster here, definitely toward the novice end of the spectrum. I am working on a job tracking system (where each job is a "shot") and am building a layout for adding tasks to a shot. I want to be able to assign multiple people to the task, and so currently have a portal in my layout which references a "person" table. Each row contains "person::fullname" and "person::tempCheckbox", which I intended to use for temporary storage of, you know, whether they're checked or not. Is such a field in the "person" table safe if there's a good chance that multiple users will be adding tasks at the same time? Right now it's just me …

I have a portal on my layout that has about 5 rows, I have another portal from the same relationship next to it that is only 1 row displaying a picture(container). How can I get the 1 row portal to be in sync with the active row of the 5 row portal and show it corresponding picture. Do I need to separate table occurrences? Thanks

I have a database that tracks events at locations in cities. Each event has a Unique ID. On my cities form, i have a portal that shows the List of locations in that city for each event. It also shows the Event ID for each location. Because locations have multiple events, the locations will show up more than once with different Event IDs., and each event may have more than one (or no) locations.   This is the portal in my layout. What I'm trying to do is get an average for each city of the number of locations per event. I set up two summary fields in the Lists table (which is the table shown in the portal). One is supposed to calculate the number of events, the o…

Greetings. I have two unrelated tables in one DB. Database table "Main" has a portal with financial entries for clients: date, amount, description, etc. The second database is "Checkbook." Sometimes we need to draft a check with the same information that is keyed into that portal in "Main." Right now, we just re-key in that same information into the Checkbook table. Can someone point me in the right direction as to how to move values from one table to the other? I could write a script that would use "copy and paste" 4 times over, but I'm sure there is a more sophisticated way to do that. Thank you.

This question is based on mr_vodka's Basic portal Filtering topic: http://fmforums.com/forum/topic/72108-basic-portal-filtering/ I want to use the concept described here, of using a drop-down list on a layout, to cause the embedded portal to be filtered based on the user's selection. In this example, the filter options (drop-down list values) are based on a field value (Child_FMP11::Type). Because I'm going to be using this on a portal containing invoice information, the filters will be based on a numeric calculation, not a fixed field value. The calculations will be (aside from "All"); Invoice::Bal = 0 Invoice::Bal > 0 The sample file provided by…

Part of the database I am creating includes 19 portals across 3 tabs (10 on first, 5 on second, 4 on third) - with the likelyhood that more will be added. These portals are designed to help employees track status' that jobs are at. I wanted to create a way to minimize/maximize portals as desired by the employee to make it easier to see what you want and only what you want. I have been playing around and pretty sure what I came up with thus far will work, however due to the number of steps I feel there may be a better way performance wise as well as time wise for development. Just as reference, to minimize/maximize three portals there are a total of 14 tabs, 4 port…

I am working with INT and MOD functions to generate receipts. For example an amount splitted into 5 receipts. The first 4 have the highest integer and the 5th has the remainder. What I would like to accomplish is to show through a portal a calculation field with the result. I have made a sample file to explain my idea. As always, thank you very much for your help. NumberOfReceipts.zip

Aloha I am trying to create a columned portal table. My layout will contain several portals. Each portal will show several fields with the final field being a subtotal. A vertical presentation will be much easier on the eyes and the flow of my layout. Thank you in advance for your time and attention.

Have a portal pointing to an Invoices table, which accumulates all invoices across a number of an individual client's animals that I have treated. Whilst sorting the portal by date (in descending order), it is sorting the invoices by month, however the day order isn't always correct, and I can see no pattern suggesting why this is so. I have checked the date formatting for the date fields, and they are correct (dd/mm/yyyy). I don't have any second level filtering applied at this time ( e.g. by animal name) - which, incidentally, adding this level does not help matters. Any suggestions thanks?

I have a layout that contains a portal. The portal shows rows which contain dates. The master table (the "one" table in the "one-to-many" relationship) has two global fields, gStartDate and gEndDate. I would like to have a script that would do a find that would select all the records in the master table, that have related rows in the portal table, that fall within these two dates. What is the correct way to do this? Thanks very much in advance to all for any info (or alternate approaches)!

I have a file that displays thumbnail images in a grid (7 portals wide x 4 records). This displays the first 28 images that meet the portal criteria. In some cases there are more than 28 images that fit the criteria... and I'm hoping that I can use slide controls to allow the user (on FM GO) to swipe to the second slide control panel to see the NEXT 28 images that meet the portal criteria, etc. I pasted my "7 column" portal in the first panel of the slide control. (each of the 7 are the same portal, but starting at a different record number - ie. first column starts at record 1 and displays 4 records, the next columns start at record 5, 9, 13, etc.) My strategy …

I'm not sure if this is possible, but wanted to put it out there and see if anyone has any advice. I have a portal, on layout A, which displays a list of note records for a company. Using a global relationship, a user is able to click a portal row and see the selected items details. The use case is: User scrolls portal row, clicks row, portal row is highlighted, and details are displayed to the right of the portal. A second use case exists whereby a user, from layout B, can run a script that navigates them to layout A and automatically dispays the desired note details. The issue, however, is that if the selected note is not within the viewable rows, the highlighte…

i have an invoice solution with a portal . i need that the portal products can be type just one time , if somebody type the same product in another row , i will need that shows a message and then do something. i have been trying with validate menu and then unique value but it doesn't work.

Hi everyone, I have a table called tasks and I would like to show 4 portals on the screen side by side which show the found set of tasks for the 1st quarter, 2nd quarter, 3rd quarter and 4th quarter. Each task has the following fields - taskID, Task, Contractor, Quarter. How do I achieve this and what do I use as the join? Thank you in advance

A simple question: When a create a portal and I activate the option of alternate colors, how do I get the fields on my portal to follow automatically the same background color than the row where they appear. I tried pasting formats from some templates I found, but it doesn't work.

Hi everyone, I would like to be able to have multiple form letters that can be sent to all owners in my database. I can achieve this by having one form and putting merge fields on it. If I want anymore form letters I copy the first layout and rename it and then use a button to go to this layout. How can I create more than one form letter? Is it done via a portal? Also once this is accomplished can I do a find and then only send the form letter to the found set? Any help would be appreciated (including as much detail as possible for this newbie) Thanks in advance.

i need to know if i can find a specific portal row and then delete it , only using a script. i have a field , in that field i have to put the item number of the portal and then a button to delete that item number from the portal . do i need to loop? is that possible ? thanks,

Hi all I have two portals on a layout displaying two different sets of information. One displays records that have a return date matching the system date, and one displays records that have a start date matching the system date. The portals are on a layout that references the same table, so I have set up a self join with my booking table. The filter calculation is simply: Bookings2::Start-date = get(currentdate) And bookings2::end-date = get(currentdate) for each portal respectively. Thing is, the portals display no records. Is my calculation too simple?

I’m trying to set up my personal Sales Order Solution. It is meant for running (with a Spanish keyboard) on a Windows-OS 10” netbook, or maybe in a future on an iPad in KioskMode. With the help of St. Google, I’ve been able to do a decent solution until now, but at this moment I’m seriously stuck. Probably caused by an relationship error or maybe by an inappropriate CF. My problem is related to ‘item searching’. The items I need to search for, are in at least 4 languages: English, French, German and Spanish. Some are written in UPPERCASE, others in Proper Case, in lowercase and of course WITH accents. BTW clients are Spanish, so with/without accented first names…

I'm looking for technique that will allow a system operator to click and up or down arrow to determine where in the sort order of a portal an item will appear. I know there are a few methods for this but can't seem to find a technique article on it anywhere. Can someone offer me some help or point me toward an existing article? Thanks in advance.

I have a table with two fields "ID" and "Paragraph" as this: "ID" "Paragraph" ---- ---------------- 1 John is a student 2 Mary works hard I want to add a portal to this table to show the words of the paragraph as separate records: "ID" "Paragraph" "Portal" ---- -------------------- ---------- 1 John is a student John is a stud…

Hi, Very much a newbie here. I've created a PO/invoicing system, or am attempting to. Per most of the examples I've seen, I have a Portal in my PO layout for a Line Items table, which pulls from a Products table. The LineItems table contains the fields Item Description, Item ID Number, Discount Rate, Quantity, Taxable, Unit Price, Amount, Amount Taxable & Discount Amount. The records displayed in the portal on the PO layout are Item ID, Item Description, Quantity, Unit Price, Amount. When I type an item number into the field, it populates the description. It does not display the unit price, when I type in a quantity it correctly calculates "Amount". Then, …

Please see the attached file... you can log in as a guest with full access privileges. This is a very tiny file. The table attached to the form can get very long. It would be nice if I could sort the records by Fiscal Year, Quarter, and then ID. The Fiscal Year and Quarter fields should not be null. I've tried applying field validation but... in doing so I found the portal resets the rows upon field validation. It's very confusing so to the enduser so I haven't applied validation in the past. I've removed the portal sort and the reset but still, after validation the portal jumps. Is there anyway to have my cake and eat it to? I'd like it if when the enduser f…

perhaps, this subject has been made before. But I couldnt fınd in forums. and my brain has stopped for now.please help I have a field "city" named. there are so many records in city field. for example 1 paris, 2 newyork and 3 istanbul records.I want to see this result in portal thank you so much. Example.zip

I have found solutions on filtering portals by date ranges or by single words, but nothing for filtering both. I would like to know if a portal can be filtered by both? If not then my issue below is moot. I have a filter in place that will filter by date range: Test::Test_Date ≥ Globals::g_Test_Start_Date and Test::Test_Date ≤ Globals::g_Test_End_Date This works fine. Here is where my problem starts; when I try to filter by date range and by a couple of drop-downs using globals: or Test::Test_Type = Globals::Test_Type or Test::Test_Time = Globals::Test_Time or Test::Test_Location = Globals::Test_Location If I select a date range and two dr…

I'm just wanting to know if anyone has some suggestions as to way one particular layout would be updating slower than the others that are designed in a similar way. The layout is pretty much only portals. 4 of them in fact. One is a navigation bar down the side (staff members), the other 3 display the relevant data from the selected staff member. Only 1 of these portals is used to enter new records. The layout is based on my global table. Selecting a staff member updates, via script, the global staff id which the other portals are linked to by relationship (and other criteria). The majority of the time, selecting a staff member for the navigation portal is pre…

Hi there, I've built an invoicing database off of the supplied filemaker pro template and I'm trying to sort my portals through a category field that I define. By using the portal setup I sorted the portal records by that category variable...it seems to work fine and sorts them accordingly. However, when I then try and print out all of the portals into an actual invoice, it no longers takes this sorting into account and lists them as they were entered. Any hints how to keep them sorted? I admit I don't even know how I managed to make it this far. This is really my first attempt at filemaker pro and I don't really claim to understand it in the slightest. Let me kno…

I want to have a portal displaying records in the found set. For example: I have an Inventory table that has a self-relationship. I have a layout to show the full details of each record, and a layout that shows a list of inventory (through a portal). I have a side search area that filters this portal. However, I want to be able to allow users to be able to search all fields if they wish to - not just limited to those I have in the search area. So, I want to allow to enter find mode, perform the search, and then display it in the portal. I was hoping there was a way in FileMaker to determine if a record is in the current found set. I couldn't find a…

I have a pop-up menu upper left corner of attached image. That button is configured like this. The "Display data from" is set as a global field and the "Values from" is set with a value list from a Employee table. The "Use values from first field" is the EmployeeID the "Also display values from second field" is the FullName from Employee table. The button displays the employees just fine. Now I want to display the selection of the employee name to the portal. I have relationship set up from Employee table to WorkOrder table based on the employeeid. The portal section will display fields from the work order table. When we first load the layout the portal …

Hi all, I have a solution that I've recently split out into UI and data so users have better speeds when using over a WAN. And it works nicely... still kinda slow but acceptable. However, I have an "overview" or "dashboard" layout of portals which is going horribly slow even with a simple (one field, stored) relationship. The portals show order statuses so in one portal it shows all the orders at "waiting on payment" and in another portal, all the orders with a status of "ship", etc. The status is a stored text field on each order. So the relationship is really easy. But even across 600 records, it takes about 1 minute per portal to display the res…

I needed a way to manually reorder portal records from time to time and to keep a sequential number with each record for export purposes. This example I created does this via a looping script which allows individual records to be moved up and down the sort order and also delete records from anyplace in the sequence and have the remaining records automatically resequenced. I am not sure if it might get slow when dealing with large numbers of records but in my case there are unlikely to ever be more than a dozen or so. I am still a relative novice with FM so would be interested if there is a slicker / quicker / better way of doing this. Codeus ManuallyR…

Well that title wouldn't help much! haha I'll try and explain this with exactly what I'm aiming to do. I'm trying to create a layout for when I do our wages. The plan is to have 3 portals: 1. staff_LIST: a list of all the staff members that have completed work for clients within the wage period 2. staff_SHIFTS: a list of all the work (shifts) the selected staff member (from staff_LIST) has done within the wage period 3. client_SHIFTS: a list of all the work done for the client within the period which is selected from the staff_SHIFTS portal. All these portals would be based on a table called Shifts - it contains all the work done for each client. Kind o…

I need probably to figure more information B4, but maybe something simple will comment back Station station 1 works real well/ Parent Message file .. I have 2 instance of same , in Relationship chart... 1)Alarms, 2)Recurring Then on a simple layout, I have 2 portal, The only difference between each alarm and recurring is a field set .. to 0 or a 1 Never B4 noticed that on my Remote Log station #2, or even on my iPhone... All the message records are showing in the one Alarm Portal and other portal skeleton is there.. just not any fields or data. All my records are all showing in other portal?? Any quick thing comes to mind why?…

Hi folks, I'm stuck again!! I have a portal I'm using to input grades for class asessments. At the moment, to go from one row to the next I have to click on it with the curser. When I tab, I go to the start of the next row and have to then tab across to get to the same field on that row. I'd really like to be able to tab (or use the keyboard arrows) to navigate the same field on different rows of the portal, ideally using arrows to go to different fields on the same row; just like you would on a spreadsheet. Is the possible? I've tried with script triggers, but have had no luck! Cheers, MIke

I have an inventory table. It is the items of inventory only. There is no transactions of inventory bought (in) or use (out). As inventory prices change on purchase invoices the information is manually updated. I have decided I would like to track the history of prices. I have a child-table to hold the price and the invoice date. I need to populate the original purchase price field with the most recent entry in the portal. Other fields on the layout reference the purchase price field. I have related the parent-table to the child-table by a serial number on the parent-table. How do I populate the inventory record from entry on the portal?

I have a portal on our tuition bills that show all payments, one per line. The number of lines in the portal can increase, for a few parents, to more than fits on a page. Any ideas on how to continue a portal on a second page (like first 25 receipts come out on page one and the rest on page two)?

I am a newcomer, but am making progress, I hope. At any rate, I am trying to use a portal to display line item records that include a unique reference number, a short description (40 characters or so) and a much longer explanation that reads more like a note field. Each explanation typically has anywhere from 150 to 400 characters in the populated field. I would like a portal that allows me to add records, much like an invoice item, and then display the short description and long explanation field in their entirely in a wide line item portal format, which I assume will require much taller field boxes to display the contents in their entirely on an 8 1/2 x 11 size page. Is…

This question could as easily have gone in ESS or FM GO, but this seemed like the place. I have a portal in a FM Go iPad layout. It displays records from a related products table. The products table is a SQL ESS table. The relationship is defined by two global fields in the interface file which relate to a "locationID" and "categoryID" field on the product side. The product table has a field named "productID" which is not a primary key and is not unique. The primary key is named "entryID." So, in products you can have records such as "entryID: 100, product: widget, version: widget 1.0, productID: 500," …

I have 2 tables Members->>DES DES is a portal on Members. I have a report based on Members in which I need to pick off the top row of values in DES. (It is sorted Descending by Date) In my report, when I specify DES::Date, I do not get the top row of the portal. I think I can set up a 'scratch' field that will hold nothing but the current date and write to it when I input the date, but the question is "Is there a simple way to make FM recognize the top row of a portal and when the report sees DES::DATE it pulls up the TOP portal row DES::Date?

I am using FM12 adv in windows  The situation is pretty simple but I find it perplexing. I have 2 tables: Members and DES  Members-->>DES  DES is a portal on Members  I wrote a script that deletes a potal row in DES but when I run debug it clearly shows that despite using 'go to portal row (first) when I look at the values in what I think is the first portal row, I am actually getting the values in another portal row.  How can this be?  BEFORE The Delte Script   AFTER / During the Delte Script: Â

Sorry if "Portals" is not the correct forum for this question (For some users, that's better important than help us) maybe belongs to Scripts I have a layout with some portals to calculate a Statement, and I want to have scripts to add new portal row to an especific portal. The original layout is named "Enterprise" The portals shows info from "Statement" Table This is the script for the "Sales" Portal on "Enterprise" layout: Set variable [$StatementID; Value Enterprise::Statement_ID] Go to Layout ["Statement" (Statement)] New Record/Request Go to Layout (Original) Go to portal row [Last] Set Field [statement::id_edo_result; $StatementID] it works, but…

Hi, I have a wholesaler contact database in which I use a portal that points to my document database. Among the document database, I have a field named "expiration Date" the premise is that one of these documents, and there can be many, in the portal is a license, and that license expires. The expiration date field which is within the portal is only populated if it is a license document type (using a "document Type" field). How can I take that experation date and show it on the top of my form (outside the portal) so as we browse through the records I can see the experation date of the company's license.

Hello all, i had build a database for one of my sales reps. im testing the database just with him. the database is on his laptop , not server hosted. basically the database has one portal where the sales rep put the items the customer is ordering, then when he sends to print the purchase order the database sends an email (client email) with a pdf attached. now he is telling me that some records has no items on the portal ( not all of records) , but the record is in there with the customer name date of creation and everything except the portal records( empty portal). the strange thing is that the pdf i got from him of all purchase orders are perfect , all rec…

In my database there are 2 tables: 1 named "Project" with "project id" and "project name", and the another table for "Statement", related by "project id" field I need to have portals like this example image: To have input fields that i can type any information, input dropdown fields, and a button to add new records to the portal. http://1.bp.blogspot.com/-8N4sZht1XQc/UhTmArnkkUI/AAAAAAAAAJM/msslQlA6oZM/s1600/portal-dropdown.bmp I dont own the Data base from the image, not sure if the fields shown in the portal are from only one or many related tables, buy I just wanna know how to do it (input fields and dropdown) to try it on my database.

I'm doing my first major project and experiencing a great deal of trouble with keeping my portals operating correctly. I'm an old-time FM developer, almost full time since v2.1, and understand fully how portals work in every version of the program from 3-11. It seems like there are bugs in the portals in v12. I have a field in a portal, I nudge it one pixel to the right or down, still within the portal visually, and suddenly it doesn't work any more... it doesn't repeat, and if I drag the whole portal, it doesn't move with it anymore. My understanding was, the top left corner of a field determines whether it is in a portal or not, and in FM12 you have to drag it into …

Hello , i would like to know why in filemaker 12 all the templates when they use portals, they use a field "ID MATCH FIELD" on the table , what is this field for? please let me know thank you

I have two tables. One contains color info (red, blue, orange, yellow, etc.). The other contains artwork info. What I want to do is put a table on the artwork layout that would allow me to assign certain colors to the different art files. The trick though is that I don't want it to create a new "red" record every time I assign a design red. More of like a lookup value type of table. Is this possible?

Hi I have been searching all over the net on how to do this and I am getting some info but I cannot piece things together. I am trying to filter one of my portals to summarize data based on a radiobutton set. The portal is displaying info from the table "Visits". Each record has a format set to it either as "Lab", "HSCT", or "treatment". I have global field that will be the radio button set which contains the same values as the Visits::Format field. I want the portal to filter the data based on the global field; however it wont seem to work when I do this script: Freeze Window Commit Records/Requests Refresh Window [flush cached join results] My filter Calcula…

Hi, Originally I built my line items for a quote to just use the record number symbol to automatically number them sequentially. My users want to be able to change the line item number and sort it ascending and move line items around as needed. I have created a field "LineItemNumber" to hold the value and I have the portal sorting ascending based on those values. My problem is some users forget to add line item numbers so I need a way to set the numbers automatically if they do. Also a user may have entered some item numbers on a quote, and go to add another new item, but forget to set that new line item number for the new item. Is there a way to set the m…

So I have a portal to another database; the two are joined by a relationship that is a calculation field on both sides. I have "allow creation" checked, but typing into the empty bottom row to create a new record throws the error "This action cannot be performed because this field is not modifiable." That actually makes sense, but I have no idea how to get around it. Suggestions? Thanks.

Hi, I have a bunch of portals with a delete portal row button and it works fine. I am just wondering if there is a script set in FM where the portal row I want to delete gets highlighted so I know if I clicked the correct "x" button to delete the portal row? Thanks

This is really bugging me..I have a sales rep, customer, and sales order tables all related in a linear fashion. See image below. I have a layout based on the Sales Rep table with a portal on that layout showing related records from the SalesRep.Customer.Salesorder table.(Showing all sales orders by that sales rep) This is fine. Now, I want to show Customer's Company Name in the portal row, So I add field SalesRep.Customer::CompanyName to the portal. Doesnt work.(Column Company Name 1) NOW, just for fun, I added a second SalesRep.Customer.SalesOrder.Customer(Shown on far right of graph). I pull in that ::CompanyName and it works!(Column Company Name 2) I'm uncomforta…

to the FMP Guru's out there, My solution contains a layout based on Table A that has two portals, one portal shows records from a related Table B that is only one relationship away. it works perfectly fine. The other portal is based on Table C which is related to Table B and ultimately Table A. The relationship works fine, and the portal almost always shows the correct data. On this layout as you go through the workflow it eventually changes a field in a record of Table C and then exits the layout. You can see this change immediately on a layout that is dedicated to another occurence of Table C. Then if i go back into the layout that displays the portal to Tables B an…

I have a layout with two portals containing related records. Some records are duplicates so I'm cleaning them up by moving the related records within these pages to the record I wish to keep. In the top portal the movement of the related record works OK. I cut the record ID out and paste in into the record I wish to keep - so the ID disappears from the duplicate record's portal as expected. However, the same doesn't happen for the second portal. I cut the ID out and paste it into the record I wish to keep, which works as it shows ID, but it doesn't update the lookup field on that page, and the ID remains in the portal of the duplicate record. If I delete the dupli…

Hey guys, I am working on a database with the following relationships (with "---" meaing one and "<" meaning many [there are other tables/relationships etc, but they shoudl be irrelevant for this issue]): "Jobs" --- < "Invoices" ---< "Line Items" --- "Line Item Calculator" I have a portal on the "Jobs" table showing "Line Items." What I am trying to do is have a button on each portal line that will go to that record in the "Line Item Calculator" table. The issue I am having is that when I use the "Go To Related Record" script step it shows all of the items associated to that job, rather than isolating that one line item record. Im probably jumping…

Can a portal be made to 'slide' up like text fields? For example, if I have a portal that displays 20 related records, and the vertical scroll bar is selected, but there are only 10 related records for the current conditions, can the bottom of the portal 'slide' up so that the empty portal rows don't show?

Hi Folks, I hope someone can help; I've developed brain-fade! I have 3 tables: 1. musiclist (inc titles, song no/ID, composer etc) 2. Gigs (inc, date, venue etc) 3. Join table. I've got a portal on a Gigs layout pointing to the join table where I'd like to be able to add songs to gigs using a value dropdown based on the music in the music list. It doensn't really work - the song no isn't added, or is incorrect. It doesn't change when I change a song using the drop down. I can't add new songs using the portal; the dropdown doesn't work on the bottom row. I've attatched the file with data (there's nothing confidential) to compensate for my rubbish expla…

In the GestionEcole_23.fp7 joined file let us consider in Browse mode the INS_Liste Table modelayout which displa the INS table records : there are 14 records. 
Consider now the INS_Fiche Form mode layout : no surprise, there are also 14 records. Bur switch to Layout mode and look at any field, except the Zkc_Annee field : this fields is not drawn from the INS table but from the TO ins_PER__Eleve, double-linked to the INS table :
Zkf_PER(INS) = Zkp (PER)
Zkk_Eleves(INS) = Type(PER)
Zkk_Eleves contains the constant character string "élève". 11 PER records have a Type field which contains this text, so I expected to get only 11 records, but in fact 14 records are displ…

I am using FM 12 advanced v 4 in Windows  I have a layout based on Members. Members has a 1 to many relationship with DES table which holds a members Status (Suspended, Deceased, Reinstated etc)   When I run a report based on the script below, I get "SOME" of the DES records showing whatever is the TOP ROW of the DES portal. Sometimes, as shown above, I get a different portal row. (You can see the report showing the single record for Sperry dated June 2, 1997. It *should* show the top record dated June 9, 2003. Most of the other records show the top portal row record in the report. Sperry and Tietjens both show other portal rows.  Huh?  …

Not sure if a portal is the best way for this but the scenario is as follows: Have a database with the following key tables: ClientDetails(1 to many) - Horses(1 to many) - Treatment Visit - Invoice I have basic invoicing set up, associated with a given treatment visit (which is linked to the horse, and owner). The invoice layout is based on the concept of using a portal showing a separate line items table (as some invoices will have more than one service item added). Here's what I want to do; Have a button on the Client Details layout (labelled something like 'Aggregate invoice'), which goes to a layout that shows all invoices against that owner(don't wor…

I am using FM 12 04 in Windows. I have a report that has a portal on it. It shows a maximum of 3 records. It works. But, some portal records have 2 rows. Others have 3. Question: "Is there a way to have the blank records collapse the portal and avoid showing the blank portal row?" Thanks

Is there a way to monitor emails that i sent to but in portal What i want is Date Sent Time Sent and Sent To

Hello, Am I struggling with something or what! I fear that I'm trying to do too much with FMP9 and certainly more than my brain can handle! Simply put, I want to use a search string to filter a portal. Is this simple? On the Master table I have records of unique reference numbers (think contracts) consisting of an alphanumeric string, at least 9 characters long. On the portal table, I want to enter a string of 2 or 3 (random) numbers, then, (contract-side) perform a Position calculation which determines whether or not the string is contained within each record's reference number. The match and the filter would be based on Position equalling 1 (not 0). Problem 1: th…

I am running FM 12.04 Advanced in OSX and Windows. (I hope this situation isn't so complex I can't explain it properly)  I have a Membership application.  On the Membership layout there is a DUES portal (based on the dues table which is 1 : many with Members)  This works great.  But, I created a simple Sub Summary report that is based on the Dues table.  The first Sub Summary is based on Dues_Status ("Current or Late") The 2nd Sub Summary is based on Member::NameLastFirst  Of course I sort on these two fields    In the Dues portal there is a Dues::MembershipYear field. (Here is the weird part)  If Dues::MembershipYear is empty, i…

Hi,  I'm looking for a solution to create a find script in a portal.  I use a portal with a dynamic drop down menu to class my contacts. The dynamic drop down has 2 levels: Parent and Child (quite easy) - I call this a group.  A record can be part of several groups of course. Suppose that I want to find record that are member of 2 (or more) groups. When I enter the find modus in the portal it only allows me to fill in one row. So there is no way to have to find record who are member of 'Group 1' AND 'Group 2' for instance.  Does anyone know how to help me solve this problem?  Thank you very much in advance, Filip Langenbick  Browse modus: in…

Matt Petrowsky's recent solution (and video on the Filemaker magazine) to reorder portal rows using drag drop is inspiring, and will add much needed elegance to my database. I encounter one anomaly, and it relates to portals that employ a scroll bar. While dragging to a new destination, the portal rows don't scroll along with you. Has anyone who uses this solution had this issue? As a subscribed user of the magazine, I am unable to add Matt's technique file. Regards Eric http://www.filemakermagazine.com/videos/portal-row-reordering-using-drag-drop.html

is there a way to transfer value list of dropdown to portal?

Hello I have created a database for a hospital clinic that contains 3 tables: 1. Main- unique key=pk_main 2. Lab- foreign key=fk_main 3. treatment- unique key=fk_main The lab table and the treatment table both contain a date field and a description field (text) I want to be able to have one portal that will display the records of both the lab and treatment tables on the layout linked to "main" for example, date Lab description date Treatment description date Treatment description date Lab date Lab date etc Is this possible to do? If so how?

I've seen this done before, but forget where I saw it and how to do it. I'm hoping someone can refresh my memory...   I have set the relationship to allow creation of related records for the portal table occurrence, now I'm trying to cover the last portal row (the one that allows creation of a new record) with a clear message telling users to click on that row to add a record. It is currently a text object with conditional formatting testing if the primary key field is empty. This method requires the user to type data, then exit the field before the conditional formatting refreshes and the message is hidden.  What I want to do is have the message be hidden as…

How can I display last record in portal?

I have a simple situation and thought there was a simple portal filtering solution. I have a text field that contains phrases: "Newly Minted in New Hampshire" "New Ways to Run a Railroad" "An Old Story Told Anew" "Newfound Methods" When I set New as the filter keyword, it displays all four records. But what I'm trying to display are the first two. My portal filter is set as PatternCount (Table::Field ; Master::Keyword ) > 0 ... which I understand is looking to locate the text anywhere in the string. But this is where I thought there was a technique that could be applied. I've tried using apostrophes around the keyword and a equal sign prefix, bu…

I'm a software developer, but pretty new to FileMaker, and have been stumbling my way through building a daily assignment scheduling system for students from scratch. Yesterday when setting up a new layout, I encountered a maddening portal behavior in FileMaker 12 that I cannot figure out at all: On one of my layouts, I am able to edit fields in a certain portal row. In another layout, in an apparently identical portal, I cannot edit the fields. Based on my examination every property of the two layouts, controls, table occurrences, there is no difference that I can detect between the two layouts: - The field behavior allows data entry in both layouts. - …

Hello my partner what to do a file maker price quote for him self. and asked me for some help. the problem i have with what he want is he has 15 products and etch time he does a new quote all the items will be in the portal so he can go through them all. (so he can offer it to his client) what is the way to do this Tahnks dani

Morning all.... I will attempt to explain my problem as best as I can, please bare with me. I built my solution a few years back and it's had a few tweaks since. I am now trying to give it a overhaul on the UI. On one of my layouts I have a portal which brings records from [RECIPE] records into a jointable [DISH_RECIPE] This is a many to many relationship: many recipes can be on many menus This has functioned okay - upon clicking on the last portal line a drop down showed a list of all the recipe title fields, pulling in the data from the recipes ID The issue I don't like is that there is thousands of recipe records. What I want to achieve is the portal to display …

Hi, I am trying to find the CSS code to disable portal row highlighting. (Filemaker 12 adv) (or change the highlight color) I copied an empty portal (no fields) to the clipboard. Loaded the clipboard into Textmate. Than I can read the fmxmlsnippet of the Filemaker Portal I can change borders, background color etc. (load it back into the clipboard and paste it into Filemaker -works-) But I cannot find the way to disable the highlighting of the portal. There is a line that references to the highlight color but that seems to do nothing when I change it. Any ideas Thanks Henk Rotterdam Holland

HI, I have one portal in a layout showing the records from a table with no problem. If i place a second portal on a layout and set it to display records from the same table as the first portal it shows nothing. You can add records through it but both portals are showing different data although all the data is in the table. Any ideas how to do this? Thanks

Hi, i have a table called "stock" and portal on the admin layout displays the data from the table no problem. I need to put another portal on the user layout displaying the same data as on the admin layout. I need the portal to show the same data on every record, so when a user goes to next record the stock data is still displayed in the portal. i have tried self join but cannot get the portal on the user layout to show anything at all. Any Ideas?

How does one write a script to auto number a portal row as each new portal is created related to a record? I have an order database that has a portal for line items. I would like to give each line item it's own number. If I have to rely on people to enter the number it happens sporadically. I would like the user to still have the ability to enter the field and change it if they decided that one item should be ahead or before another.

Hi All, I have a database attached to this post that has a relationship between table "HOTELS" and table "TOURSv2". On a layout "ROOMINGLIST" (click on the "rooming" button next to the navigation buttons) I have placed a portal where I'd like to put a script on the blue buttons that deletes the according portal row. Why does the master record get deleted as well when I select a portal row and delete it? I only want the portal row to be deleted. The message asks me if I want to delete "that related record" and when I click yes, the master record on layout "GUIDED TOURS" is deleted as well. I have read the manual, have bought the "missing manual", I have searche…

Hi everyone, I am writing an opening script which will go to a certain tab control which contains a portal. This portal contains dates from 2+ years ago and also dates until the end of this year. What I want to do is upon opening, go to the portal row that contains the current date as the first portal row. I have played around with calculations to no avail. I have tried setting a $CurrentDate variable upon starting the script and then setting that field in the portal but i get a dialog box that says "go to record [734976] out of 10. When I press enter I get an error that the number is too high. When I change that number to 10 or less, it carries me to a diffe…

This is genuinely weird.  I have a Members table that is the basis for Members form. On the form is a separate TO of Members that lists, vertically, Member Names. When a member's name is selected a GTRR runs which puts the member information in the main window. This works.  The member portal (Navigation) shows just the Member names. The portal shows a max of 28 names. The problem is if I select member #47, the member is selected and then the elevator jumps to the top.   I have tried to program for this:   And this code works .... As Long As I Am in Debug. Huh? When I run the code in development mode it frequently fails with a jump…

I have a Portal that contains 10 Containers. Each Container is a thumbnail picture stored externally. I want to click on the thumbnail and open a large view of picture. I can only get it to work on first container field by opening new window. How do you change the field by caclulation to get different container to show?

Hi! I have a 'Days' portal on my 'Sheet' layout ( which shows list of days from a particular month). Requirement: 1. I want to display seven rows in the portal. 2. I want to be able to select a day from the portal and then position it in the middle ( i.e 3 days less than selected day are placed above the selected day and 3 days greater than selected day are below the selected day). 3. Allow scrolling using portal scroll bar. I am able to position the selected day in the middle using a portal filter and a script, however I am not able to enable scrolling using the portal scrollbar. Is there any other way I can achieve this such that the scroll bar will work…

im trying to copy a portal to another portal but the script i have only copy the first row , i need all the portal copied . it is possible to copy all the portal records? thanks for your help portal.fmp12.zip

I have a portal that shows log events as they happen, chronologically. For UI reasons I need the oldest events at the top and the newest at the bottom. I'd like the portal window to keep scrolling down on its own so it always shows the newest event (at the bottom) and as many previous events as would fit. I do not want to have to GoToObject to make this happen; I would like it to do it on its own. I know that I can do it backwards. I.e., if I sort the list in reverse order and have newest on top, then the portal will update on its own, happily showing the newest at the top all the time. But there are other things on the page that show newest on the bottom, so as I said, …

What I want to do: I want to conditionally hide or show fields in a portal row. The catch is a simple "background fill transparent" won't work on fields with drop shadow and additional styles as the styles still bleed through. I want the entire field to completely disappear with no trace. I know how to do this with portals on fields on the outside, but this is already part of a portal. The Why: The portal holds line items on an orders screen. When an order is submitted, certain assembly items explode to predetermined levels using their BOM information. I want this information visibly indented based on the the level it is on so that is easy for someone goi…

I have a 'products' table that I would like to incorporate in a layout that will be used by customers to browse through products in a shop. I would like around 4 records viewable at a time (2 fields - a container for an image and a description field , and then buttons to shift to the next set of records 1-4 , 5-8 ect. like this: has anyone successfully managed to do something like this? any help would be appreciated thanks

Not entirely sure how to explain this, but I have a layout with a portal. Most of the fields displayed in the portal are set as non-enterable while in browse mode, as the data is coming from a table that should not be edited. I have a script in the portal that needs to take the product ID from the portal and create a new record in another table, but there are times when I've noticed it creating a record for the wrong product ID. It seems that what is happening is that when I click into an editable field FileMaker properly identifies the record I am on and properly picks up the Product ID I want. However, if I just click on the button in the portal, or click on o…