Portals

Howdy all: I'm in Stupid mode today--I can't see how (in the attached solution) the Product portal is being filtered after choosing a category. I see that the layout has a script trigger assigned so that upon record load the script captures the record ID in Category and pushes it into a global field. Still, I can't see how the Product portal is being filtered--there's no filter assigned in the Portal Setup box, so...? *sigh* This is giving me a brain hernia--time for a Tylenol. Thanks in advance for your help. Nested Portal.fmp12

Greetings! A few weeks ago, some of you were kind enough to help me construct a database for my movie collection. (Thank you, by the way.) But I just now noticed something. It’s not really a flaw. There’s nothing really wrong. I don’t really HAVE to fix anything. So, I’m just asking this question out of curiosity. The database has a few portals with repeating drop down menus. I just realized I can select the same thing twice. For example, if I have the movie Jaws and select Genre, I could select Action/Adventure multiple times. Or, I could accidentally select the same actor twice. Is it possible to tweak the database so that this is pre…

I'm fairly new to FileMaker Pro (I'm just over a month in/trying to build as much as possible under my free trial as there doesn't seem to be a sandbox, before having to pay for licensing when we're not quite ready to go live with the app) currently producing a time management solution for projects managed under my husband's small engineering company. Our current solution is based on Macro-heavy Excel files that have hit their limit in programmability / aren't user-friendly for collaborative working, hence the branching out into app development to find a solution. (My day job is as a database analyst for an insurance company so Excel, SQL, Tableau are my main skills. L…

Hello Community I'm wondering is there a way to combine two technics: Filtering portal and Pagination the results. There is a nice sample here (thanks for sharing @comment), but I'm stuck trying to combine it with filter. I tried to make a list of ID (as summary field) to use this when result is true, but with no luck. My goal is to use multiple global fields as checkboxes or search string, and then display splitted result. This part is clear, but I cant connect it so the sample from mentioned post. Thanks in advance.

I have two tables: jobs and tracks. A track can be either "pending" or "not pending" on multiple jobs. I set up a TO where the relationship is to match trackIDs between the job and tracks tables, but ignore the current job, so that for each track selected in a left side portal, a right side portal shows only other jobs (not the job on the left) on which the track is pending, using a filter on the right side portal. Now I would like to toggle the left side portal between showing all tracks on a job (whether pending or not pending), or showing only tracks which are pending on other jobs. Either that, or better still, a conditional format on the tracks on the left so th…

Am a newbie! I have just added a portal to a coin database I created to speed up navigation and display search results. Initially, when I open my database, all fields are displayed with a solid red border (thickness of 1) as added by me. If I click on a portal row to display a record, the border of all records changes to a dotted line; the red border disappears. Can someone tell me what is happening, please?

I'm having a frustrating time with some portal filtering. What we have is essentially a calendar layout. Each day has a portal, filtering records based on the order date. This means that users can see the orders due on each day at a glance, and this has worked well for many years. Recently, business is getting busier and it would be helpful to filter the portals by the type of order as well. I've started by adding three Global fields to the Calendar table, which are essentially toggles that the user sets for what they want to see. These correspond with three fields in the order table. All are text fields populated with "Yes" or "No" I'd assumed that…

Hi All, Is it possible to create a conditional format condition based on the portal row number? In essence I would like to use the strikeout format for any portal row that is over 100. Thanks in advance. Milky.

Hi All, I have a Portal that tracks players qualification status for an end of year game. To qualify a Player must have played 8 or more games, but also finish in the top 100. The portal contains the following fields: Name Games Points. Currently the portal is sorted by Points descending and then games descending. What I would like to happen is that the portal is sorted in the following way: Sort by Games (but only if Games are equal or greater than "8" 😎😎 Then Sort by Points Then Sort by Games (for any Games less than "8" 😎😎 Then sort by points. Any help would be appreciated. Milky.

Howdy all: I apologize in advance if this isn't the proper forum for this question since it involves external data sources, ESQL, etc., but the crux of the problem is that none of the fields (in the portal) will sort. In the attached (original) file, everything works as it should. I've copied it, but instead of using an intra-file table for contacts, the file I created connects to an externally-sourced FileMaker Pro file elsewhere on the server for Contact data. The lookups for (external) data work fine in the new version--it's only the sorting part of the solution in the Sort layout that doesn't work, so given that everything was faithfully reproduced and …

Apologies, I've been away from FM for about 6 months and I'm having a mental block, can someone help please? I'm trying to get a portal to filter records and I'm using "<" & ">" to do it. The problem is I want record records > but also <, essentially, if we are talking about numbers 1 to 10 I want numbers greater than 4 but less than 7. If I use the "and" operator I get all records because I've used parameters that contradict each other.

my issue - an existing table, fully populated with data, now has an additional/new (numeric) calculation field HOWEVER the new calculation field result (a simple multiplication) does not appear/is not displayed. context - the existing table has 4 fields, a) item name, b) item qty, c) unit cost, d) item volume; new/added field is e) itemsValue (itemCost * itemQty) request - any suggestions please on how to obtain a displayed calculation result/value in the new field? fwiw - creating a new record displays the data as expected/required in all 5 fields. background - using FMP 19 standalone on Win 11 clean install regards, yoyojoe

I'm trying to create a Tab Control Panel containing seven tabs in FM19. Each tab contains a portal which I want to appear in the same position. I seem to be able to create three or four portals correctly by copying and pasting and then adjusting the copied portal, but subsequent ones appear in the wrong tab. It's driving me mad. I'm sure I've solved this before but I've forgotten how I got it to work. Has anyone got a method to solve this?

I know I've done this before, but can't remember how nor find how to do it. I have a portal, and I want to have the row number show up in the portal for each row. So, the first record in the portal would have a 1, the second a 2, etc.

If you need to have the option on in the relationships diagram: "Allow creation of records in this table via this relationship", you will always have an extra empty row at the bottom of your portals (see here). But if you don't want the extra empty portal row to be displayed, there is a workaround: You can conditionally hide all the fields in your portal, for example when the record is empty. In Layout mode, I enter into the box: "Hide Object, when" the following code: isEmpty ( Relation_to_Table::id ) This is only cosmetic, but nevertheless, it works great: Now, only those portal rows appear that have values in it. You might need to adjust background colo…

I _know_ this must've been covered here, but I must be muffing it using search operators since I can't find what I'm looking for. I found a few .fp7 example files dating back 14+ years ago, but I'd rather use more modern commands/schema that are available in later versions. (We're using v.20x FileMaker Pro, Mac.) I want a value list (checkbox form, global field) to filter the results in a portal but I'm just not getting the syntax right using FilterValues and/or ValueListItems. What's the correct calculation? Example: If the user clicks Alpha and Beta, I want both values to appear in their respective records/field in a portal. TIA for your help. -----------…

I have a portal that shows the 'ingredients' and quantities required to make/bake/cook a particular recipe; external to the portal I have a field called 'Wish to make' to hold a numeric value variously entered by a user. How am I able please to multipy the value in each portal row and show the 'sub/total' of each listed ingredient; i.e. each calculated quantity being the full amount of each ingredient needed to make the 'batch quantity' defined by the user? Thank you for any suggestions.

The Filemaker solution that I (sporadically) work on is used to manage equipment rentals. One thing I've recently been asked to add is a way for someone to type a query word / phrase, and quickly see a list of current rentals that have a matching item on them. It's used for a "hire desk" scenario, where someone at the desk can see a customer coming in carrying a chainsaw, say, and they can type that into the search field, and have the customer details appear. The resulting layout has three portals on it. They are based on a Cartesian (X) relationship between the table with the rental items, and a "Dashboard" table. Each portal is filtered usi…

Hi all, Please could you assist? When I add a part number and description to layout x, I need the part number to automatically be added to my parts catalogue if it does not exist How do I accomplish this? I also want duplicate part numbers to be automatically be deleted

I want to use UUID for all my tables and also for linking them together, but I don't want to show the long id. Yet I need them to pull up information from another table. How I can solve this dilemma? Thanks. KC Production.fmp12

Hi, I have a table called Books and a table called Publication. On a layout based on Books, I have a portal based on boo_PUB_BooksId (Books::Id = boo_PUB_BooksId), where one or two publication dates are selected. In a card window based on Books, I have a portal based on boo_BOOKS::Editor (Books::g_SelectedEditor = boo_BOOKS::Editor) that displays the nos and the titles of books from selected editors. That works fine. Except I want to add the publication date or dates in that portal. But I can’t manage to extract the dates from boo_PUB_BooksId (the portal on the Books layout). Could someone help me achieve that. I’d like the dates to be displayed as fo…

Hello all, I have a small accounting solution with two tables: Dashboard and Expenses. On a layout based on the dashboard, I have a 10-row portal that displays all expenses. I'd like to be able to move from the first 10 rows to rows 11-20, and then 21-30, etc., and back, by simply clicking two arrows, so that there is no longer a need for the scroll bar. Can someone guide me through this? Thanks.

Hi all I'm trying to build a simple solution which tracks which PRODUCTS have been selected on an ORDER and filters the list of available products so that for each new line on the LINE ITEMS portal, those already chosen don't appear on the list. I have three tables: ORDERS, LINEITEMS (join table) and PRODUCTS. My proposed solution is: • Have an unstored calcuation field in ORDERS called Products Chosen set to dynamically populate a List of ProductIDs as they're chosen (by using the List function on the ProductIDs in related LINEITEMS.) • Choose items in the LINEITEMS portal on the ORDER based on a value list called PRODUCTS UNCHOSEN which refere…

I've created a value list of discount types based on a table of discount types. I have a specific order in which I'd like these sorted in a drop down list. Is there a way of sorting these besides the order in which the records were created? (Sorry, this shouldn't have gone into Portals. I don't see how to delete it)

I'm making a database of customers and inventory items to sell to them. I've created a file of work orders, which would contain a portal to line item records, each line item linking to the work order number, with a line item for each item sold, quantity, cost, etc. This seems pretty routine. I've created a script run from the work order file that runs a script in the line items file. This script does what is needed, linking to the work order with the requested item info. The problem is that when the script is done, the line item created, and the user is returned to the work order screen, the new line item does not appear in the portal. It will only appear wh…

Hi there, I have attached a sample version of my database here, which I hope will help. My set up: We have grant schemes with applications. Each application is applying for funding which will come from a variety of sources: some from the scheme, some from us ("AIBN" in the database), some that the applicant needs to provide themselves ("AIBN group" in the database). There are numerous groups. The funding is also provided across several years, so AIBN might provide $50k in Year 1, $20k in Year 2 and $30k in Year 3, a total of $100k. Most schemes are only across a maximum of 5 years. Funding is added to the Application record via a portal linking to Finance.…

Hello, I have two tables, both have a field "name". Let's call them the "dads" table and the "moms" table. In a third table (call it the "children" table) I want to have a field ("parent") where the user can choose a name using a drop down. The values in the dropdown should be all available names of dads and moms. I cannot find a way to concatenate the lists. I can build a concatenated list in a calculated field but I cannot find a way to use that list in a dropdown. Is there a solution?

Hi, I'm trying something that seems very simple, but I can't make it work for some reason. I've tried all sorts of joining tables etc. I have three tables: A, B, and C. Table A is the parent of both B and C. (so there is no actual relation between B and C, but there are records in B and C with a common A father). I want to add a field to C that will store a field's value from B. For that, I want to create a value list of values from B for the user to choose from. However, I do not want to show every possible value from B, only those that share a common father in A with the relevant record of C. Is there a simple solution for that? Thank you

I have solution where "one address for customrer " multiable addresses of shippers and multiable addresses of receiver on an order. that solution is for a trucking company where customer is a load broker and carrier create a order where he picks multiable items from diffrent location and there deliver on diffrent location , but all address are save on one table , so next time when create order it paputale threre

I have two databases Ballets and Roles, I am trying to put a portal in ballets to enter and display roles. Then sort and display only the roles from the ballet indicated. Nothing is showing up on the portal? Here is the file! hbwardrobeinventory23.fmp12

I have a portal with an incremental search field. works great. I also, have a button bar with button reflecting file extensions. ex: pdf, pages, doc, jpeg, etc. The button bar with the scripts work great by filtering each file extension. The issue is I want the filtered result but I also want to be able to search incrementally within that filtered selection. Any assistance would be appreciated.

hey all, hope somebody can help. What I am trying to do is very simple I am sure, but I think I must have brain fog as I've stumped myself! To keep it easy, I have three key tables: 1) Days (where each record is a unique date) where lots of other information is held in other fields. 2) Foods (with a list of possible foods that can/have been consumed) together with extra information such as calories etc.. and 3) Meal Names ('Breakfast, Lunch etc). In the middle of the 3, I essentially have a join table 'Food Line Items' to allow many-to-many relationships between them all. ie. each meal can have multiple foods, each day can have multiple meals etc. …

I was trying to do a work around to make a portal sortable by different fields. I created a field in my related table that is a calculation which is Get (RecrodNumber), then a script that will go sort that table how I want it to sorted. It is correctly sorting the related table, and it is showing the record numbers in order as it should on that page. But when I set the portal to sort by that field, it won't do it. I can specify any other field and it will display them in the order of that field, but not the record number field.. What's even stranger is I put that record number field on my portal, and it shows the numbers in order, even though it doesn't match wha…

Hi all. I am attempting to filter a portal in a few different ways. I have a daily time sheet displayed in a portal that is department specific. Table: Day Portal Table: DailyTimes (Day::ID = DailyTimes::DayID) Each work day the user opens the current day record and can open a card window and be shown another portal with applicable crew who are in the system that could be working that day. Table: Day Portal Table: PR_Crew (another instance of the "Crew" table). Not every crew member works every day. Currently I have it scripted where the user selects a checkbox next to the names and the script loops through and adds the crew to the daily time sheet for that day.…

Hi all. I believe this has a simple solution, but I've been unsuccessful. I have a table of records (table "b" - "Entries") shown in a portal on table "a" ("Tester"). Table "C" shows the occurrences without duplicates. These records have two values that need to be "summarized" within the portal. Furthermore, in table "a" I have two global fields, "start date" and "end date." To further breakdown the related records I have a relationship filter: "start date <= check date" and "end date >= check date". I am able to get the portal to show each instance of the related record within the date range, however I want one instance of the related record to show with …

I’m trying to set up a simple “Dashboard” style layout, the objective being to help users see the state of play with orders at a glance. As things stand, the Dashboard layout is based on its own table, and uses filtered portals to show records from an Orders table. So my prototype dashboard consists of a bunch of small portals, each filtered differently to give a total number of orders with a particular status. For example, “All orders due to leave today” is just filtered by Date Out = Get(CurrentDate) Then there’s another for “All orders still to leave” which is filtered the same way but adds Order Status ≠”Dispatched”. The plan is to have a whole seri…

I'd like to have an indicator at the top and bottom of a portal to show that there are rows above or below that are not currently visible. Presumably I'd need to know how many rows are in the portal, and what row is at the top and what row is at the bottom of the currently visible rows (or what row is at the top and how many rows are visible). I haven't been able to figure out a way to do this. Ideally I want an button above the portal and one below, which can be disabled when the list is at the top or bottom respectively, and which will move the portal up or down a single row when they are clicked. Is there a way to do this?

What are my options for sorting a portal which displays records from the same table that the layout is based on? There's a products table and a status table. The products table contains a list of unique items, and the status table indicates the status of the product for each year. My layout is based on the products table and contains a global field to select a year, which returns the status for that year in the product portal. The problem is that my product list won't stay sorted. I've written a script to sort the records on layout enter, but when I add scripts for other things on the layout the list reverts to its unsorted state. Do I need to add a step to every scr…

I have a layout with records in a list in the body and a portal in the footer. When i am in the portal the mouse scroll wheel scrolls both the portal rows and the record list. When I am in the record list the mouse wheel only scrolls the record list. Is there a way to stop the mouse wheel from controlling the record list and portal rows at the same time when I am in the portal? I don’t require the portal row to scroll with the mouse wheel at all. Does anyone know if the get trigger keystroke function can control the scroll wheel? and if so what number is it? FM version 19.3.2.206 Windows

Greetings, all: I have two portals (to different tables side-by-side in the same layout.) In the left portal is a value list (Services) that's accessible by clicking the <CLICK ME> popover button (in the screenshot.) However, our manager wants to change it from a value list (within a popover) to a portal (which gets my endorsement because I'll be able to parse the data easier) because the value list takes up too much real estate. But, as you know, you can't put a portal within a portal, so how can I pull this off in this layout...which she doesn't want to change?

(Refer to the attached) Greets, all: I'm racking my brain on how to pull this off: The Parent table has school district records and the Child table has tasks needed be done for each district; the AT Responsible is the name of the person assigned to each task record. What I want to do is create a list of all districts and all taks while in the parent table; users will be able to click the AT Responsible field tha'll perform a scripted Find so they can pull up all of their records. As you can see, what's showing (for now) is a simple parent-to-child relationship with the school district field in the left-hand portal (which is the same School District field in…

Howdy, howdy: I have a self-join portal (by recordID) with five global fields above it that I want to use as filters, with the "default" filter being EVENT_PARENT_X_ID::EventDate__lxd ≥ Get ( CurrentDate ) so that if no values are chosen as filters, the portal will display the records with the current date, forward. The problem is how to set up the filter calculation so that if one or more filters have values chosen, the portal will filter records based on those values. The problem is--at least how I'm looking at it currently--is that I'd need to create many permutations for the filter calc to cover all conditions. Surely, there has to be a better way of …

I have a FM file with Students and Classes, each record has a unique ID and are connected via a join table. Each student can have more than one class. Students can not change their classes, only the Admin. I want each student to be able to see the student data of those who have at least one of the same classes. Any suggestions on how to set this up?

I have four tables (Projects, Customers, Products, and Users) and a Join table. All four tables have relationship with Join table, configure to be a many to many relationship. A record in layout based on Project have one Client, one Product, and multiple Users (using portal). I need to export each record to a csv file, and need to be a one liner. My issue is if I export based on Project table, I can not get one liner result if I have multiple Users in the portal. And also the second user (User 02) will have no information about Project, Client, and Product field, and sometimes users can be more than 5. Project Title Custome…

On my layout, in addition to fields from the current table (Music), are two portals with related records (Trcks). I want to duplicate the entire record (Music) AND include contents of the two portals. (The layout is for example, an album with the tracks. have two (or more) copies and realize it's better to have separate records over a field indicator. The Music Table contains info on the album, the Tracks Table of the various tracks and time shown in the portal.)

[Newbie] - I'm trying to get my head around what would appear to be a very simple task (according to some of the video's I've found online), but I can't get the final result I'm looking for. I have a portal which I'm using to create a new record (customer address), inside my main "Contacts" layout, inside of that portal I'm trying to create a new record using a button (external to the portal). The button should add a new Record and display the Portal Row ONLY when the button is used for this purpose. Otherwise the portal should only have ONE blank field waiting to be populated Presently I have the Portal and button working but not as I need it to. When I have fi…

Portal1 on my Music Table layout has condition of side="A" and Portal2 condition of side="B". The portals contain the name of Artist and Track Name(s). When the Format=Single, I'd like the Portal1 Artist and Track_Name to appear in lieu of the Album_Title/Artist, per side. Tried If statements but not sure how to address the fields within the Portals.

Tried using Google and haven't been able to apply solutions to my portals. Now that I have one portal filtered into two, I need to revise the summary fields to count entries and total the time. My attempt: 1872:00:00 = Sum(SideAB TimeCalc::sideD_TIME) should be total time of portal "A" 13 = Count (SideAB TimeCalc::sideD TITLE) (because there are 6 in the portal "B" not shown) should be 6 total count of portal "A"in mm:ss format which isn't working unless I use hh:mm in which case less than one minute fails The same solutions for this side will be applied to the other portal. Then, I need two fields that combine the results for total count and total ti…

I have a script that tests the Product Code field, in a portal, for validity (using a script trigger -- "on exit"--Attached to the Product Code field) so if the user doesn't enter a known value, a Custom Dialog window appears telling them so; the script then clears the product code field so the user can re-enter a known product code. That part of the script works. The problem I'm running into is that after the script clears the Product Code field (k_ProductCode__lxt) using the Set Field command, I can't find the correct command to place the cursor back into the Product Code field so the user can re-enter a value ; I've tried many variations of Go To Field (using har…

My next problem is a shopping list. This database is for a game, in the game I play at manufacturing, and this database helps me determine what products to manufacture and which to avoid. I’ve attached a copy of the database. What I want to do now is create a list of all the base materials if I decide to build one product or another. All the Materials are listed in the table “Materials”, however, the number I need for various Goods is scattered throughout the database in various join tables. If you take a Material, (for instance, Tritanium) and you go to its record in Materials, I don’t see how to assemble a list of all th…

Hello. My first question here. I’ve been working with FMP since it was Filemaker, but I’m not a professional, and I think FMP has managed to get away from me this time. I have no idea why my summary fields aren’t working. Here are some of the facts: I’m designing a database to keep track of project costs in a game. Everything is fictional. The problem is in the second line of tables. I noticed the problem in this layout: This shows Items, that are used to build Goods, and the Items are made up of Materials. This screen shows the table Items, and the portal shows records from Items Material Join Table. Items are added to the portal by…

Friends: I'm having an issue where the portal shown below works fine in the application (FMP 16), but does NOT show on the web (WebDirect). I'm using the latest version of Chrome, and also the latest version of Java. Also, both logins are mine (the developer - complete access to file). Does anyone have a solution? Help!

Hi! I have a calculation field in a portal which shows the value according to ActivePortalRowNumber. Each row has a special determined value. When I manually enter the value in the field before the calculation field and thereby make a particular row active, my calculation field automatically shows the designated value. Great! But, if when I do the import from Excel, all data gets nicely imported and the portal shows the imported data but the calculation field is without value. I guess the importing process is not making a portal rows active so the calculation is not working. Any ideas how this can be solved? Many thanks!

Greetings. Reaching out for help as I'm staring at a brick wall currently. The more research I've done the more lost I've become. Primary Table is a List of ALL Active Matters. Each Matter is Unique. Portal is a List of Related Nominations. Relationship is the MatterID Two calculations are performed for Every Matter & Displayed/Saved in the Primary Table (Save Preferable) 1.1 Count the Number of Nomimations For the Matter (SUPPORTCOUNT). 1.2 Add the Value of each Claim per Nominations (SUPPORTVALUE) The above Calculations are for the Primary Table & Preferably a Saved Value. The Calculations Must be part of the visible Primary Row. eg:…

I have tried to find the answer to this but cannot. I have a HOUSE Table (parent) and an OCCUPANT Table (child). I have a portal on the HOUSE layout showing the occupants for a particular house. When I delete the occupant, it also deletes the occupants record!! I do not have the delete box checked in the edit relationship dialogue box. I have attached the file. Thanks for any assistance. HouseOccupantExampleForumQ.fmp12

Hi everyone, looking for an assist. I have related tables, and use a portal to display records. I would like those records to be numbered, simply 1 through whatever. I can't figure out how to get this done. Can someone help? Thank you! Roger

Is there a way to achieve this? Example i have 36 record, then i need to show only 5 record per portal. I have a total of 4 portals which bring me 20 records showing. Since 36 record can't fit on 20 row, I should have a button next and back. below is the sample, Number represents the record portal 1 portal 2 portal 3 portal 4 1 6 11 16 2 7 12 17 3 8 13 18 4 9 14 19 5 10 15 20 Under the portal th…

I have a table parent and a table child. And a join table child to parent because one child can have two parents, one parent can have many children on the Layout using table parent I would like to display the other parent (if it exists). For the life of me I can't work out how?

Hi, I created a form which has two different ports. My question is how to print a report data coming from two ports, since they are different. I can only print report from one portals... Many thanks. KC

Hi All, As per mentioned on topic I Would like ask someone to help me this issue because I am trying more than time unfortunately all is not successful to send e-mail for birthday in case have in the same day more than one employee. on filemaker server :

Hi all, As per mentioned on title ,I have two report in different layout in my database .I hope find script to solve my issue without change orientation every time manual. I have two type setting to report print. - First report print need landscape. - second report print news portrait.

Dear Developers, I'm struggling with an in-house Expense Report solution. I have a linked portal of LINE_ITEMS, which contains individual expense details. One of the fields in this related table is a container for receipt storage. I would like to include a field on the parent layout to add receipt data to the highlighted portal's field. I've been unsuccessful finding a related solution's implementation.

I have a STUDENTS (parent), and SPORTS (child) table. The relationship id STUDENTS_ID in the STUDENTS table, to STUDENTS_FK in the SPORTS table. I have a SPORTS portal in the STUDENTS table showing the sport name. Can I make the sport field in the portal a dropdown list to select various sporta for various students?? Thanks.

Hello, This is a question I'm not sure where to ask on this forum, and I'm unsure of how to approach the issue, being fairly new to FileMaker. I have a table of Contacts and some of those contacts need to visit our office every few weeks on a specific day at a specific time. Say we have 200 Contacts and 5 need to visit us at 9-10 on Monday of Week 1, 5 at 10-11, 5 at 11-12, and the same for Tuesday etc. They will repeat this same appointment after all the appointments have been looped through... On the layout for each contact I want to give an option to set both the Week, the Day, and the Time they will visit. I want the available weeks, days, and times to …

Hello everyone, I'm storing some videos in a portal in record A. If I'd like to have access to a video already stored in record A from another record, is there a way to reference that record A video in that other record portal. The idea is to avoid duplication and, at the same time, having a copy of the video in my solution, as opposed to storing it on my computer hard drive. Thanks.

I have a portal showing total sales in a summary field outside the portal. I have duplicated this portal and filtered it to show sales > $100. How can I show the total sales from the filtered portal in a field outside the portal please. Thanks for any assistance.

Hi Group Im not sure if im in the right place to post this but here it goes: I have a database with a container field for a photo and it works great but i would like to take multiple photos and have them show as thumbnails in the database file in what i assume to be a portal? and then a main photo container field in the database window will show the currently selected thumbnail in the portal. and i am assuming when taking photo's via an ipad i will select the container field take the picture and it will add it to the portal too. my thought is that i need another database linked to the main database to hold all the photos in and then the main container fi…

Hello everybody, Does anyone know if it is possible to adjust the portal height independently from the row height? This is the case: I have portal rows of 1100px high, but would like the portal itself to be 750px. I know I ones managed to do this, but now I cannot figure it out anymore. So actually I would like the portal to display only 0,68rows. Thanks in advance for your efforts!

ok i have a problem...I am trying to create a portal and i have done this many times woth out problems but now what is happening is the fields appear to be behind the portal and hance are not showing in browse mode. I have attached a file on my screen shots...I am really confused...i hva emade many portals and i have done nothing different this time round....why suddenly is this happening... I would really appreciate any help I am using filemake11 on a PC thanks in advance for any help or suggestions Tina filemaker help.pdf

Hello everyone, I once again find myself asking for your help, since I am fairly new to FileMaker and don't know where to start. As I mentioned before (for those who haven't seen my previous question), I am currently in the process of preparing a historical database of officials delegated to supervise order in private estates. The existence of both the officials and the estates needs to be confirmed by historical sources. So the 3 tables are: Sources, Jito (the officials) and Jito-shiki (the jurisdictions in estates). One source can mention multiple officials and estates; an official may appear in many sources and hold jurisdiction in numerous estates; lastly, a…

Hello everyone, I am fairly new to FileMaker and I have been trying to find a solution to my problem on all sorts of forums and in all forms of tutorials, but have been drawing a blank so far. Maybe you can help me. I am currently in the process of preparing a historical database of officials delegated to supervise order in private estates. The existence of both the officials and the estates needs to be confirmed by historical sources. So the 3 tables are: Sources, Jito (the officials) and Jito-shiki (the jurisdictions in estates). One source can mention multiple officials and estates; an official may appear in many sources and hold jurisdiction in numerous esta…

How do I update an active portal row number "Get(activeportalrownumber)" when I delete a row in any portal?. When I delete any portal rows that are in the middle of the portal, I cannot get the portal row number to update,change or refresh.. I'm using a script to delete the portal row when I click on a button but unable to change the portal row number. What function should I be using to correct the portal row number?

Hello good afternoon, I have 3 tables (Students - Readings - Books) related Students (ID; Name); Books (ID; Title); Readings (uuid; Date; fk_Studente; fk_Book) Students --- <Readings> ---- Books I intend to show a portal which books were ordered per student, how many times he took each book, knowing that he can take the same book more than once. I did follow this steps: https://scarpettagroup.com/filemaker-portal-show-distinct-value-tutorial/ to group the book. Any help to maker the counting by group?

Hello! I have a file where one of the features is to create (or import) spot cues. I have up to four spots in the file that can be recorded, and all are on separate tables. I would like to be able to have all of them shown on one layout as well so I can see all my spot cues at once. obviously I figured out how to do that individually, but now I want more. Recap, the four spots cue records have to be on their own table so their records don't mix together. I know I would need a relationship (I tried and didn't get much out of it.) then put each spot in a total on one layout. Each spot has at least 10 field (they're the same) but for each cue they could b…

Can anyone help me,how to filter portal with dropdown list,using global fields?

Hi I am using FM Quickstart V17 and have been adjusting the invoice part to work for invoicing rates of things rather then a product. I want it so I can add a date to the added rate ( in the invoice tab), when you click on add rate you can select a rate. but what I need to be able to do is assign a date to that rate so they know what days worked. I tried adding in a date field and that didn't work, then I tried adjusting the SKU that was already there into a drop down calender, but as soon as you adjust and select a date, the whole row disappears. Am I trying to do something that is not possible? if I am not could someone guide me to how I might achieve t…

Hi, I'd like to create a Portal with Categories for a single, rather large file with items. Each item is coded. The first 3 characters in the code define the Category. So, I'm thinking of filtering the items into Portal Categories like this: IF Left ( CODE; 3) = "321" Then show items in Category 1 IF Left ( CODE; 3) = "331" Then show items in Category 2 IF Left ( CODE; 3) = "341" Then show items in Category 3 ...and so on What should the real code be? All the very best, Daniel

I’ve got a database of film screenings, and am encountering some confusion when it comes to displaying data in a portal. I have a layout that displays a director’s name and then lists each of the films by that director that I’ve screened. Next to the title of each film, the portal displays the number of screenings of that title, and data about the earliest screening. My problem comes when there has been more than one screening of a particular title, and I’m unable to get the portal to properly display the correct city/state associated with the displayed venue for that earliest screening. In the case of a film with more than one screening, I can get the portal to disp…

Hello, I have followed the step-by-step tutorial offered by Filemaker to use the tasks add-on for the event management template. Everything seems to work perfectly, EXCEPT I can't get the task card to open in edit mode... Thus I can't edit any task information once I create the task, and I cannot delete either. I realize it's hard to help from such limited info, as there are a number of scripts involved. I can only say I wrote the scripts EXACTLY as instructed by the tutorial, and yet, no editing posibility. Any suggestions?

I'm hoping someone might be able to help, or at least point me in the right direction. I'm creating a portal that displays a student photo, but would like the ability to navigate forward/backward through the photographs in the portal without the vertical scroll bar. My < and > buttons currently point to a Go to Portal Row - Previous/Next script step. It works great when "Allow vertical scrolling" is turned on, but does not work with it turned off. It does work with Allow vertical scrolling turned on and show scroll bar set to "When scrolling", however, the scroll bar appears on mouse-over. Any suggestions on how I might be able to achieve this? …

The database that I maintain at the moment has a simple text field for “Order Notes” which is used for various miscellaneous notes that don’t fit into any of the other fields. It’s a bit of a “catch all” receptacle. A couple of problems have emerged recently. One is that staff have been relying on notes that have been written quite some time ago, treating it as “gospel” when in some cases it has been superseded. What I’d like to do is have an indication on the field of when the information was input. It wouldn’t be hard to add a timestamp that is changed when the field is updated. The drawback I see with that approach is every alteration, no matter how minor, u…

I've got 4 tables. Product, Vendor, VendorProducts and Product Price. A Product can have multiple Vendors. Each Vendor has their own price for a product. My issue is I want to also Track the Price changes a vendor makes but also show the latest pricing when looking at a product. When setting up the Portal to list the VendorProducts on Products is not an issue but returning the latest Product Price based on a timestamp is the issue. I could create a script to place the latest price in the VendorProduct but that seems like the wrong approach.. The other thought is maybe create a Calc Field in VendorProducts to return the price is thats possible? Or maybe there …

I am looking to eliminate the scroll bar being shown and add a visual identifier that more data is available. The scroll function still works and will show up once the mouse scrolls, of course. Example. Portal number of rows = 25 Number of records = 50 Visual cue to scroll down, or up, or both. Any point in the right direction would be great.

Hi there, I am sure there is a really simple answer to this but I just can't crack it. I have two related tables: Property and AoPC. Each Property will belong in a particular AoPC. I have set up the relationship and a set of tabs on a layout in the AoPC table. Each tab has a portal showing particular properties in that AoPC depending on the value in another field in the Property table called Influence. The Portal Filter calculation is really simple: If(Property::Influence = "25m";"25m";""), with a different value for each portal. There are three possible values in the Influence field: 25m, 40m or GWD. For 25m and 40m, this works perfectly. Also if the portal is…

Hello, I have a text field with a number of ID's separated by a carriage return and am in need of help creating a portal filter to return all of the child records that have IDs that are in the list of IDs. I have been working on using pattern count to no avail. Thanks for the help!

I've been working on a planner-style layout as part of a rental management package that I haphazardly develop. The idea behind the layout is to let users see, at a glance, how availability is looking for a particular item. There's a screenshot of it attached below. The items displayed are all records in my Order_Item table, they are essentially "line items" on a hire invoice. The planner itself is based in a separate table, with the items related using a Link-all arrangement. Then the portal is filtered to include only the relevant items. (The date range is constrained, and the item name is filtered via a PatternCount function) The blocks of colour that you see…

I was looking for an easy way to get a record count of a portal and couldn't see how to do it anywhere. Luckily I found a workaround to do it and thought I'd share. Select Insert | Other Symbol. Select FoundCount. Move the new merge field into a portal row. Hide the merge field by setting 'Hide object when' to True. Give the merge field a name, for example 'PortalCount'. Now you can use the following calculation to find the total row count for the portal: GetLayoutObjectAttribute ( "PortalCount" ; "content" ) Obviously you can change 'PortalCount' to whatever you like. If there's an easier (and less hacky) way to do this…

I have a parent table with contacts. This points to a child table in a portal with various skills the contacts have. Some contacts may not have any skills filled out, others may have one or several. Adding skills dynamically fills a value list of all entries in this field. There is also a portal which shows all contacts and I want to be able to filter it by skill. So I have added a global field, formatted as a drop down menu listing all the skills. So far, so good. Choosing a skill is supposed to filter the portal with all matching contacts, of course, but this does not work. I can kind of see why it doesn’t work, based on the way I set up the relationship, but …

Hi all, I have a layout with a portal from another table. At the end of the row there is a button you click to take you to another layout to add more information. Problem is no matter what button you hit on any row, it always takes you to the last record entered. Here is a video to explain it better: https://vimeo.com/350021672/a29ff64e2f Any help would be greatly appreciated. Thank you, Peter

I have a table layout but within the rows of that table layout is a portal that basically shows the last record created date, username and text. I believe this is massively slowing down my layout. When I remove the portal the layout speeds up and loads dramatically faster. my thought was to create a stored calculation field that changes or displays data from the last portal records and updates when other portal records are created. I would just now need to show the 1 calculation field on each row instead of having the portal Any thoughts on this idea?

Hi All, I'm going to try and explain this as best I can, so feel free to ask questions if something is unclear! I am building a database for clinical mental health. In working with clients, users will need to document a variety of forms using different measures, like an MSE, PHQ, DA, and other "forms" (the abbreviations shouldn't be relevant). On the client's dashboard, I'd like a portal showing all of their documents/forms that have been entered, but I dont want to have individual portals for each type of form, I'd like them to all be shown on the same portal. What would be the easiest way to do this? Is the best way to add fields from ALL of the forms to one t…

Here’s the scenario. I’ve got a “Monthly Report” layout in my database, which has a collection of portals showing There is a “Monthly Report” table which is linked to Orders via a many-to-many relationship. Each portal then filters based on multiple criteria, a combination of the date range and division/category. This way rental is separated out from sales income etc. etc. I’ve set up summary portals as well, using the single-line technique that I learnt from another thread here. So far, this is all working well and the admin staff are finding it really useful. Naturally, this makes them ask for more features. The latest request is to be able to see the p…

FM 17 I have a tracking log in the form of a portal where we enter data of shipments. Date input is drop down calendar. No problem. There is also a field to keep track when the shipment comes back. Date field with drop down calendar. The input on the first portal row goes instantly. The input in the other portal rows is only after 3 to 5 seconds. The drop down calendar stays visible for the given time (3 to 5 seconds) Removing the drop down calendar from the field and doing the input manually, instantly. Any idea? There is nothing complicated not fancy. Just a simple portal, simple relationship. TIA

I've been gradually working on a planner layout, which uses a portal and conditional formatting to display availability of hire items. It's working well so far, and is proving popular with users. At the moment, I'm using portal filtering to narrow down the selection in the portal, typically to just one product/item. Each occurrence in an order is displayed in a portal row. What I'd like to be able to do is temporarily exclude an item from the portal results. Sometimes the query used to filter the portal is too broad, or we have a very similarly named item that turns up when it isn't relevant. In an ideal world, the user would hit a button on that portal row, and it …

Hi All, I'm guessing it's not possible, but I'm hoping it is none the less! I would like to conditionally format the colour of an entire portal row on a value from within that row. For example, I'd like all records with Field = "Yes" to be pink, instead of the default grey background for the portal. Is that something that can be done in FMP 16? Many thanks

When I add a new record in a portal, I need to scroll down to the bottom of the portal where the blank record is created. There must be a way to avoid having to scroll to the bottom of every portal to add a record. Any help out there?

I have a portal where tabbing from the last field on a row takes me out of the portal to a field elsewhere, rather than going to the next portal row. What is causing this behavior? (I feel like I'm missing something obvious.) Actually, there is only only one field on the portal rows that allows entry and is in the tab order. The idea is to tab from portal row to portal row, staying in this field. If I allow entry into another field on the portal row and put it in the tab order, this does not change the behavior. The field is in the layout's tab order; not the last object in the tab order. The portal is based on relationship that allows creation of new records. T…

Hi all, I ran into a bit of a problem, if you could please count me in the right direction. The question is actually 2 fold. In my table table I have a category and part number etc etc etc There is 5 categories On my layout I have 5 portals which i want to point to the different categories, so each portal should only reflect one category on each portal there is a dropdown to select the part number but again, if I am in portal for category 1, I only want to see part numbers for category 1 I am not sure how to limit each portal to only one specific category nor how to limit each dropdown to only one category. I tried using include onl…

Hello everyone! I have a main table Patients which contains their information and a related table Consults, which contains details of multiple consultations a patient had. Trying to make a layout that shows the consults for a given Date (DateFind) at certain clinic (ClinicFind). This is what I have so far using a layout based on the Consults table in a list view But I would also like to be able to add new consults for the given Date from this layout by searching for the patients name and creating a new consult for this patient for the day. Here I'm using the global field LNAMEFind and created a filtered portal based o…

Is it possible to do a sub-summary sort (like in List view) in a portal? I thought perhaps since you can now have a portal display records from the current table without a self join there may some way. Thanks David