Layouts

Good day, need some guidance. I have a Field: "Document Type" Options: "Picking Slip" or "Transfer" Then I placed another instance on the "Document Type" field, I configured the hide object on the second instance to only show if a selection was made on the instance. Then, I configured the hide object on the first instance to show only if there is no selection. My issue is that I can't get the first instance to hide once a selection is made. I have tried "isempty" and "not isempty" with the field name and with the "self" keyword. What am I doing wrong? FYI... The idea is that once a user makes a document type selection, they can …

We have a report that is a two-column report. The number of items varies on each column, due to the sub-summary breaks. Some groups of items have one or two items, some have many, etc. The person we're designing it for would like the sub-summary heading to print at the top of the RIGHT column when the group continues from the bottom left column. We've been trying all the solutions we can find so far, but nothing wants to work. Has anyone done this, or are there any "hidden" flags that we can possibly trigger somehow to get that header to print on the right side in this condition? Thanks.

Hi all, My current "design" of a button bar (with its three relevant buttons) that would allow a User to… View as Form View as List View as Table …has me scratching my head. JUSTIFICATION FOR THE FUNCTIONALITY The reason for building this View Layout button "functionality" is rooted in my quest to Hide Status Toolbar. Since I am hiding the status toolbar, I have been rebuilding the elements of the Status Toolbar that should be made available to Users (and to me as a "developer"). WHAT I CURRENTLY HAVE BUILT I have the buttons and the scripts working just fine that go the various Layout Views. See screenshot: 3_but…

Hello, I am using Filemaker Pro 20 but I’m really a beginner. I’ve made a simple flat file movie database, just to experiment with. Some of the fields have yes/no checkboxes. No problems with them. One field (named “RANGE”) is a checkbox group with four options. Those values are: 250, 500, 1000, and 2000. When I generated a report, I noticed the Range field wasn’t displaying all of the values. I widened the box and saw the values were vertical. I wanted them horizontal. I did some research using AI and found a formula to create a calculated field with the Substitute formula. Here is the formula I got from AI. I filled in the Range …

I have been using the excellent VirtualSort by @jbante for years and it functions very well, but sorting on an unstored calc is, as we know, inherently slow on hosted solutions with many records. I was wondering if someone has conjured up a new method for dynamic portal sorting that is significantly faster considering that 10 years have passed. I also wonder how the 'Server sorting' in Server 19 and later affects sorting on unstored calcs, as I read somewhere that it apparently does not work. Cheers, Andreas

Is it possible to use TextStyleAdd, or any stock function, really, to change the text weight in more than 2 steps (plain, bold)? I have a font that has "light" weight, then "regular" weight, "semibold" and so on. In CSS those are usually represented by a number that goes from 100 onwards allowing for precise control over weights. However I could find nothing of the sort in FileMaker. In fact, supplying "Plain" to TextStyleAdd fails to assign "regular" (bolder) weight to a text box which has "light" weight assigned in the layout. Is there a simple way to work around that?

Hello, I have a layout that displays a homeowner inspection report. The first page should show a header (name, address, comments, etc. and two of a possible 8 photos of the home. The second page should show the subsequent 6 of a possible 8. I set the layout up with a Sub-summary by Lot at the top to show the lot specific info and the first two photos (two single row portals starting at the record 1 and record 2 of the linked PhotoList table respectively). Then I set up the Body with the other six photos, using 6 portals, starting at record 3-8 of the Photolist respectively. Here's the first page = Leading sub-summary: Here's the second page = Body…

Can anyone tell me if this could be created within Filemaker? I'd like to add an audio player towards the bottom of a layout. It isn't a popover but more so embedded into the bottom of the same layout as the portal would be. You often see this with online sites like SoundCloud or similar. A couple of quick example screenshots are added below. Any advice would be welcomed. Thanks!

Hey folks, I created a simple layout with a portal. I included a couple of fields and a popover for an audio file. When I click on the green popovers and add an audio file, they seem to transfer to the other 2 portal rows but when I click on the yellow pop-ups, and pick any value from the list, they are independent of each other. Any reason why? Thanks! Screenshot attached.

Hey folks, I have a three-part question but all related. 1. I understand that when highlighting text in any field, the color is based on the operating system's settings (in my case, Mac's System Settings, Appearance). Can I use Filemaker to force and set the desired color rather than the OS's settings? 2. See the image with the calendar, can the highlighted box have the same "Corner Radius", just like the field? 3. See either image, can the text turn to white, only when it is highlighted? As always, many thanks!

Hey guys, I created a portal and added a field and a button. The field is a pop-up list and the field and button do not overlap. See screenshot. As it stands, the button is located on the right side of the portal so I can only delete the row if the mouse is hovering over the button. What I would like it to do is when I hover over the entire row, the trash can will appear but I can only delete the row if I click on the trash can and nowhere else. I hope this makes sense. Thanks so much for your help.

Hey folks, I have a portal that includes a single field. As you can see from the screenshot, all of the rows are purple, including the “add keyword” row. I want the “add keyword” row to be light gray until I add a word from my pop-up list and it’ll immediately turn purple, like the others. As it stands, they're all purple. Would anyone care to explain how this is done? Thanks so much.

Hello everyone. Is there a way to adjust the dimensions of layout parts (body, header, footer, etc.) dynamically from a script? I have a popup dialog layout that I use as a card window, but depending on how much text there is I want to be able to shrink its height. I tried changing the height of the card window, but that doesn't shrink the layout itself and creates scrollbars. Any ideas or workarounds?

Hi, I have a database with about 300 fields in a single table, organized by Custom Order. It's a flat file (non-relational) data collection tool that I'm exporting to Excel for a statistician (the field names make sense in Excel). When I make changes to fields, I want to navigate from the field in Layout Mode to the specific field in Manage Database to eliminate searching by scrolling. Is this possible? Alternatively, is there a way to search for a field in Manage Database? Thank you.

I installed idautomationhc39m font on both of my client's computers, But the other one is not showing it just plain text. I already clear the font cache but still not working.

It's been a while since I've developed a solution in FM. This may not be the right place to post, but searching didn't get me anywhere. Using FM20 and, in list view, when I scroll down to view more records, the screen automatically jumps to the top. Can someone please help me with this?

Our database has a container field that we mostly have PDF's inside of, with the occasional PNG. Currently we have this container in three different layouts. On all layouts the scrollbar is visible when applicable. However, only one layout allows the users to interact with this scrollbar. This includes using the scroll wheel of the mouse and dragging the scrollbar with a click of the mouse. I've tried ensuring all the settings for this container field are identical across the three layouts, but nothing seems to fix this issue. One thing to note is the layout where it works properly does have the same Associated Table as the container itself, whereas the other two layouts …

Hello all and thanks for your time reading this. 😀 I have 3 tables : Call order items Relationships : 1 call has many orders, 1 order has many items. I am trying to design a layout where I can display the call information at the top of the layout, then the multiple orders information in a tab control object (one tab per order) and then the items information related to the order displayed in the selected tab. image I have created a portal in each control tab showing the order (I only display 1 row with the initial row set to 1 in the first tab, 2 first the second tab and so on), that seems to work, but now I want to display in a seco…

I use FileMaker Pro 15 and I've created a photo catalogue for sorting exhibitions and books. I tried to create a PDF document via the Print function on a Mac. Print > Save as PDF but the margins are quite large. The image layout is 590 x 320cm without a header or footer and the page setup is these same dimensions with zero margins. I was hoping to get near edge to edge images but the margins are quite large. There are what look like grey page breaks every two images. Is there any way to reduce the margins in FileMaker or is this just a quirk of PDF page generation?

I have been slowly redoing my solutions with the relatively new feature of using a portal to filter the results from the same table on a Form layout. This takes the place of having a list view and then clicking on the item to get the form view. I have a table of Lessons. One of the fields is Topics. I would like to have the functionality where I could select, within the Lessons Form, from a list of Topics, and then the self-portal on the form would show me all the lessons on that topic. Then I could select that lesson for other details to be displayed. It appears that I cannot use two self-portals to achieve this. I also tried using a global field with…

I've been using FileMaker for over 20 years, but up until today had never tried making a chart with it. I'm tracking the dates that students inquire about my school and would like to make a line chart that shows total per month for each year. I have the date field, a month(date) field, and a year field. There are a few hundred records. It's clear that I need to do something else to get this to work but I'm not sure what it is. Do I need to create 12 global fields that count the number of records for each month? If so, is that what I would put on the y axis? Do I need to add something to the relationship graph?

I run a school and keep track of almost everything related to the school in a FM database that I developed. The one thing that I don't use the database for is making transcripts. For this I have been using MS Word, making one file for each student. But I would prefer to have the database do it. To do this, I take the transcript template in word, save as PDF, and then insert it as the background on a layout. The functionality of this works fine except that I cannot figure out what the strategy is for creating the layout so that it prints as a pdf or just prints to paper in a way that works. If I don't set the sizing just right, a one page document becomes a fu…

As part of their workflow, some of our employees prefer to drag-and-drop PDF's into the container fields of our FileMaker database. This works with files in local directories, but if they try to drag a file from a network folder nothing appears to happen to the database. If they use the Insert>Insert PDF command, or if we use the Insert File function in a script, then the files are imported perfectly even if they are in a network folder. I'm curious if anyone else has run into this, or if we simply have something strange going on with our network stack. This happens across multiple computers. All users are on Windows 11. We are using the latest version (20.2.1.60) of F…

Hi, I have a simple calculation field that consists of a fraction. The numerator and denominator are both number fields. On my layout, I've formatted the calculation field as a percent with a fixed number of decimals of "2". The result is decimal (not a percent), and the decimals are not fixed to 2 but instead have 16 numbers following the decimal. I've tried formatting the field as decimal with a fixed number of 2, and get the same result (16 numbers following the decimal). I've tried with and without storing calculation results. Any suggestions? Thank you, Jason

Hullo everyone! I'm using FM Pro 18 Advanced. I'm wondering if there's a way to format a field so that, should the content be longer than the field allows, the font is reduced until it is all visible. Basically, we have a couple of suppliers with extra- long product codes & at the moment they get cut off. (Increasing the field size takes away from the next field - which could also occasionally use this format...) Here's hoping! 🤞

Hi, I started a project from the invoice template in Filemaker 17 and I need some help formatting the print layout. My Invoice layout has different tabs for selecting different types of products, for example printing, framing, books and other products. Almost everything is working great, but I can't figure out how to format the print layout since it's not possible to have two body parts. This is the preview: This is the layout view: I can show the first tab's information in the print layout: I'd like to be able to show the "Framing" info and the other tabs' info when they are present. The fields in the other tabs are simila…

Hi everyone, I'm trying to adjust the invoice template to my invoice needs and I have it mostly working but I have one problem. I have this setup with a portal: The problem is, when I erase one of the records it erases the same line in all of the tabs. Is there a way to separate the different line items for each tab? Should Each tab come from a different table?

I have a summary field that shows the total of the prices of items listed in a portal. The summary field is a part of the table of line items, but is mainly viewed next to the portal, in another table. When I make changes to line items in the table (quantity, tax status, or discount), the summary field doesn't refresh unless I click somewhere on the layout outside of any field. Is there a way of doing this action by script? Refreshing the portal doesn't help, and re-looking up the value doesn't help (just gives an error).

Hi all, In FORM view I created some pop-up value lists assigned to fields defined as foreign key fields to related records from another table. The value lists are defined as using the "id" of the first field, and displaying the second field "name". Nothing unusual with this and works as intended. In TABLE view, the field functions just as it does in FORM view. This is fine for "data-entry" and functions as one would expect. However, there are times when I wish to see the values from the first field in TABLE view, and not the "display values from second field". How can I achieve this? I have poked around to see if the might be a configuration …

Looking for any tips. I have a very involved file, a complete software package for people wanting to offer Career Coaching. There are fields that information gets entered into, and a variety of functions to assist in the career process. I want to convert the entire file for use in China. Mainly thats a manual process, translating each label, the help text, etc. I plan to get someone to go through the file, first using machine translation, and then refining it so it flows properly, and is not just clunky sounding. Some of this is on the layout, and some is related to information currently in fields. So, everything has to be translated. Its a big project. An…

I was adding files to a tab, which is very hard if you haven't worked with tabs in some time. Hard to select exactly what you want to. Somehow one of the tab names disappeared. The name for the fourth tab should be send. I can't see how to recover it in the tabs setup: As you can see, the same appears correctly in Tab Control Setup. How to get it to reappear? Thanks.

Hi I have two same list view layouts , named "DashBoard" and "Ready to Bill" , both have Field "status" with dropdown list with two values , "working" and "Complete". I want when I change statue from "working" to "Complete" it shows in "Ready to Bill" layout only, and when I change value "Complete" to "working" back. records show back to "DashBoard""Layout. how I do that , please please any one help

I have a date field on a layout (in a portal, if that makes any difference) that allows the user to select a date with the drop-down calendar. I noticed that it is replacing the date selected by the user with the current date, at least at first. If you click it again and re-select the desired date, it will stick the second time. There are no auto-enter options or default values set. I have the 4-digit year and not empty requirement boxes checked. What gives? This is in FMP 16.

Hi folks, Today I face something weird in my layout. I have a calculation field called "Disp | Full Addr". The calculation is: TextSize ( "Address:"; 10) & ¶ & _Company Addresses::Address & ¶ & _Company Addresses::City & ¶ & _Company Addresses::Province & ¶ & _Company Addresses::Country & ¶ & ¶ & TextSize ( "Phone:"; 10) & $$Tab & ": " & _Company Addresses::Phones & ¶ & TextSize ( "Email:"; 10) & $$Tab & ": " & Email In my other solution before, the calculation goes normally. But, in this newly layout, I found that the result on Browse mode is not as desir…

As you'll see in the video/FM file, dragging an image over a Container field encircles the field. Is the blue border color/size modifiable? Thanks ContainerDragDropFormatting.mp4 ContainerDragDropFormatting.fmp12

Filemaker 16 pro on the Mac - Ventura 13.0.1. HP OfficeJet 9015e Printer Long term Filemaker user. clearly used to be able to do this easily. Regardless of the Layout, when in table view wanting to print our what's showing specifying all "records being browsed" in the print dialogue box, the app only prints out one record - the record in the table that happens to be selected. This has never happened to me before. "Records being browed" are all the records currently showing in the table view, right? Is there something I'm missing? Some setting that prevents Filemaker from pushing out all "records being browsed" in the table to the printer?

I must be missing something, but I only see a way to disable the Window Maximize on creation of a new window and don't see how I can disable this upon app startup. In short, I don't want users being able to make the app window any larger than I define. https://help.claris.com/en/pro-help/content/new-window.html

I'm using Adjust to Fit for FM GO and would also like to disable pinch/zoom but the Set Zoom Level script command does not seem to be able to LOCK without selecting a zoom percentage. Setting a Zoom % negates the Adjust to Fit command.

I’m considering adding popovers to my main layouts (accessible only to my account) which will contain most or all fields, portals, etc., to ease testing and more. #1 Since the popovers will be hidden from view, do the fields, etc cause any slowdown, memory usage, or other negative issues? #2 If the popover button is visible, but the popover window is not open, is memory, etc impacted or only when the popover window itself is opened? Basically, is there a cost to having items on-screen (but hidden behind tabs, slides, popovers, or through use of the Hide Calculation) or are the same detrimental effects realized whether visible or not? …

As you'll see in the attached video, when leaving the Address field, the blue line in place when the field is In Focus disappears other than the top section. Turning off the Inside Shadow fixes the problem. Is this a known issue or something I'm doing wrong? BlueLine.mp4

Hi all, I'm currently testing our filemaker database on Server and Client 19, previously using 16. When viewing layouts that previously printed off as PDF, they're now cutting in half and being split into multiple parts. The page split is in the green box in the below image: In layout mode in the position section, I can modify the width but not the height. Does anyone know how I can solve this?

I have a layout with multiple portals and quite a bit going on behind the scenes. There was a very noticeable delay in portal hover effects and tooltip presentation so I tore the layout apart to find the cause. It turns out that none of the complexities had anything to do with it, so I thought I'd share the cause with you. I'm attaching 2 videos which unfortunately don't show the portal hover row background color, but you can see the tooltip delay, which is gone in the second video. The culprit was a gradient background (white on off-white) on the layout body. When I removed any background, the delay was eradicated. This may already be known to many of you,…

A user is in a field which displays a dropdown list and hits the 'ESC' key, thereby selecting no item from the list. I'd like to trigger a script at this point, but it seems that simply closing the dropdown list by means of the ESC key, remaining within the same field, cdoesn't fall within the functionality of any of the script triggers. Is this correct? Is there a workaround? Put in a different way, if a user hits the ESC key, opting not to select an item from the dropdown list, I want to close the popover which holds that field. Is this possible? Thanks

Why would my checkmarks shrink and/or how do I control their size? When I set up this field two weeks ago, the checkmark was at least as big as the box and maybe bigger. Now it's struggling to be visible. I've been developing with FileMaker since 1992 and never encountered this one. Couldn't find an answer via Google. Thank you in advance.

I cannot get the web viewer to auto-resize. Is there a work around?

I got two email address fields. Validated for a @ present, and no hard returns and no empty spaces. Both are set for entry in the Find mode. Rather plain. Entering an existing email address into the Find mode, delivers a Not found. The others fields do act normal in Finds. The email address field is just one of many. The dbase has been operating since 1988 and I have never experienced this odd behaviour. I tried with the validation switched off. No difference. Any idea what I might have overlooked?

Hi I have a report that has a section that is a sub summary by a field that is trailing. It splits the result across the two pages, but I wanted to see if there is a way to make it put cont... or something at the bottom so you know it is split over two pages. thanks

I have a list of clients. Every time I see them I have to record data about them that changes with time and I have to keep all the data collected, one set per date visited. Each set of date dependent data has multiple sub-sections. Something like this: CLIENT --< DatedFactfind --< Subsection. The Layout I want to create has the CLIENT name, then a portal showing the list of FactFinds with the dates they were done, and then I want to be able to click a button alongside each dated Factfind to show the relevant details for each Factfind - eg FactfindAssets with sections for Cash, Shares, Funds etc. Each subsection has different fields to suit their asset type…

I'm creating a billing report; pdf from layout. The typical Database Relationship was Client->Entity->Billable Thing. The report/layout is based on Billable Thing table and then grouped by Client and then Entity with sub-summaries. Now, wrench in the mix, multiple Clients can share an Entity hence the Many-To-Many relationship. When it comes to billing, for example, if two client's share an Entity 50/50, when creating a billing report, I still want Group By Client, then Entity, but show the billable things listed twice, once under each Client/Entity. This way it can be seen discretely what each Client is being billed for. I'm not sure this is possible…

Delete Portal Row with Dialog OFF or ON, reports [3] Command Unworkable (Wrong operating system or mode). Any advice - as this step doe snot work, script correctly moves on to next relevant record, all the way through the DB. I am have done a find for clients flagged as cancelled, then move to policy portal records for the client, check that policy is also flagged as cancelled and if so, wish to delete this record with the "Delete Portal Row [With dialog: OFF]", but then get the error message. Just thought, do I have to be on the client record to delete the portal row, or in the portal. Filemaker Help file is not much help and examples are really poor…

I have Clients, who can have many policies and each policy can have more than one claim. The Client view already has the Client details displayed on the left of the screen, a Policy portal next to it and if a policy number is selected (clicked) the policy details are displayed below - all on one screen. I want to be able to also now display any claims that may exist to the right of the policy details. So when a policy number is selected/clicked the policy details are displayed below AND if there are any claims they are listed to the right - then like the policy portal works, if there are any claims the User can select one from the displayed portal list and…

I have a "purchase date" field on a layout. I know I can set the format to "as entered", "12/28/14", "Dec. 25, 2014" etc. But I would like to let the user choose the format, say from a pop-down list. I suppose I could stack a bunch of differently formatted fields on top of each other, and hide all but the one format the user chooses. But is there a simpler way?

I want to export my data from FMP. I have a DB with different layout templates. Let’s say field 1 is the same in all the layouts. But field 2 is only in layout a, and field 3 is only in layout b. How do I export this best, so it all comes together in one file? Thanks.

I need to be able to show a preview in the container in much the same way that a jpg shows the image in the container. When loading a pdf into a container with Optimize for images selected filemaker has the following behavior. When loading a pdf into a container on my mac using right click - insert file, or script step - insert file, or simply dragging and dropping into the container, I get a preview of the first page in the container which is exactly what I need. It's visible on Mac, Windows and webdirect ( on both mac and windows ). But if I load the pdf into the container on windows or in webDirect ( on Mac or Windows ) I get the file icon and file name…

Good afternoon. Let's say I have a layout with several boxes on it that span the width of the page, and each box is a different section of data. Between each box vertically is a space of approximately 1cm so that when printed the boxes are not all jammed together. I have changed the visibility on some of these boxes and content so if that section is not required on the report then it is not shown, and the items below it move up - that all works fine. My question please is that if - for example - 6 sections (consecutive) are not required on a report, then there is a gap of around 6 cm between the section above and below it. How can I get around this please? …

Hi All, in fact, I try more than one time to improve the script to show a count employee check-in on the dashboard. Knowing that employee records are saved in (Staff car Layout), the dashboard will belong in ( visitor system layout.) while press the update button gives me zero and ignores any record save daily as shown above. Thank you in advance for any help 🙂

My solution is hosted in FMS on a Mac and there are a couple of Windows 10 clients. Some layouts include container fields set up to display PDF files (optimized for interactive content). Those pdf files are stored externally in the server but clients run the solution through a local file. Under Mac it's all right, but under Windows 10 it's a nightmare: it happened before, suddenly those PDFs don't display and it all seems caused by a software update (I can't tell if it's Windows 10 or Adobe Reader). The error message comes from Reader: "There is a problem with Adobe/Reader. If it is running, please exit and try again. (507:507)" it is not running alone, only through …

Trying to create reports. Stuck on my Music_Title layout. Currently, I have two fields: Music_TItleA and Music_TitleB. Where the format is an Album, CD, EP it displays Music_TItleA because both sides are the same. Where Format = Cassette the Music_TitleA may/may not equal to Music_TitleB. eg: FOrmat=Cassette > Music_TitleA is "Christmas Songs" and Music_TitleB is "Easter Songs". I need to display Music_Ttile before print detail sideAB="A" and then Music_Title for sideAB="B". Where Format = Single, there is no Music_Title (I don't use iTunes approach and associate singles to albums) so need to put the "sideA" track into Music_Title and then "sid…

BACKGROUND I have a musical performance management solution (Gigs) which contains several tables including Gigs (performance dates, times, etc.), Songbook (information about an actual song performed), gigs_PERFORMANCES which joins the two, and other related tables. Two fields in the Songbook table are large text fields (Lyrics and Chart) which are the lyrics for a song and the guitar/piano chart for the song, respectively. Both can be long - particularly lyrics. Also a flag field indicating the presence of data in either field exists in the Songbook table. GOAL The objective is to print a lyrics book or charts book for a Gig or create a PDF of same (p…

For our retail store layout, we created a dropdown to allow the user to select an existing item of clothing, although we were hoping to filter this further by the category that the user selected (i.e.; kids, outerwear, women, males, shoes) so that they would not have to scroll through everything to find what they need. For example, the user would enter kids wear, and then the dropdown would solely have clothing related to kidswear.

I currently have a layout that contains a portal that shows all the products a customer has purchased. I want to add one new order. In order to select the product for that order I want to click on products to search through existing products. If an existing product does not exist I want the user to be able to add a new product

We are trying to sync the scrolling on the 3 portals we have for our layout. (All the rows in the 3 portals are related data).If this isn't possible do you have recommendation for how to make the layout easier to read when scrolling/navigation.

What I need to do is provide sequential line number for records instances on a report in list view. The number is of no value other than to provide a visual tool for departments to communicate. It's not stored, and it's not referenced by any other field or table. But the numbering must restart after a sub summary break for a new category. As you can see by my example (see pic for example marked in red) where the numbering continues 6,7,8... I need that to restart as 1,2,3..... at the new category. I know this topic has been discussed before and an article exists by Osborn. But I cannot find the article. I would very much appreciate a link to the article or a maybe an ans…

On the client - View as a table On the web - view as the layout Is it a way to have the same view?

Good day, I am having an issue that i never seen before. I have a very basic layout, 5 fields, and a global field for searching with a button to execute the search, all is working perfect, except that when i press the search button the result shift to the right, once i clear to show all the list shift back to the left. Any idea what i could be doing wrong. Thanks Jay Mart

I have a layout which is a list of names and addresses. There are 7 records and on the layout they are displayed from top to bottom. However, because he list is too long to fit on one page, when I print this list, the last two records print as a partial second column (apparently they are too wide) and not as a second page. How can I get the list to print as only one column and when it reaches the bottom of the page, print on a new page instead of as another column? Additional information. Sorry. I'm using Filemaker 19 on Windows 7.

I have two order tables. A bikeOrder table and a carOrder table. I now wants to have a list view where i can view all orders in the system, with a list layout but cant figure out how. any feedback is appreciated.

Consider a long list of records in list view. For each record there is a field. When an entry is made in the field, a script is run and at the conclusion the next record is selected. When reaching the bottom of the layout, the next record is not visible unless the user scrolls up. This has to be repeated for all of the remaining records. Is there a way to always keep the selected record, say in the middle of the layout? Or t least always visible?

Hi, I have encountered an error message I have never seen before. When trying to copy anything at all (fields, text, etc) in Layout mode and paste it on to the layout, I get the message: "This operation cannot be completed because it would exceed the maximum allowed dimensions of a layout." Can anyone explain this to me? With kind regards, - Johan.

I am new to FileMaker and I've accomplished quite a bit so far, but I cannot for the life of me get the borders to print. Anyone know how? I'm using FM 15 Pro using enlightened print theme with delineate unchecked.

Recently I've upgraded to Pro 19 and I noticed the arrow icons are gone in layout mode. It's pain in the neck to go to another layout. Any tips are welcome.

I have a client layout which displays one client per page. Each client has several phone numbers (home, work, mobile). I created a separate table for phone numbers (one to many) connected by the clientID. The phone table has ID, clientFK, type (mobile, home, work), and number. I created a portal on the client page to display the various numbers for each client. It works ok. I then created a Client list. Can I display a specific number from the phone list on the portal?? Thanks for any assistance.

Wondering if any insiders know if the "Animated Go To Layout" will ever be available on for desktop version of FMP?

Hi all, I would like to create a script or function for the Email field in case the entry of the email without @ give him an error or an invalid address. thanks a lot for any help or support

Hi all, Actually, as mentioned on the topic also as per shown below this layout dedicated for visitor in kiosk because sometimes the guest login to fill the required fields but for some reasons leave or ignore to complete it or change to mind to stay and leave ,Therefore the layout still shown till next visitor. I would like to add in my script to delete the request if some field empty. thanks a lot for any help or support

Hi, I'm newbie in filemaker, and I have started to build my first new database, but a new challenge floated on the surface that I believe someone can help. I have a category field "consignment item" that unit of measurement could be different (Kilogram, ton, animal, ...etc). The problem when I want to group or sort my report based on the "consignment item", the subtotal field count every value in the "amount" field whatever the unit of measurement was. Any idea how to fix this problem? Thank you, and I appreciate your help

I'd like to create a recipe app. One of the main features I need is to be able to present certain fields of recipies in a grid-like way. See image below as an example. I've been searching for quite some time now, but I cant even find examples of this in Filemaker. Is this even possible? Thank you from a newby. :-)

My first post on FM Forums so be gentle and don't flame... I'm desperate to ditch MS Access and a virtualised window on a Mac. I've created a new DB from data exported from Access - that's all good. I've got lookup working and summary fields working. I can also generate month and year fields via a calculation from a date field. But for the life of me, I cannot get the report to group *all* records from a given month in one block, no matter what I try. Instead, the report insists on grouping by day. The attachment 'Table' shows the table I've created. 'Report' (excuse the redactions) shows the problem - column 1 is the invoice date, 2 is the client (redacted…

I have just bought an HP printer. Everything works fine with the printer, colour works fine with coloured logos etc in Filemaker. However when I print a page with a container field with a picture in it the picture prints in B & W when it should be coloured. Any help appreciated.

I have a layout allowing the user to add custom categories to a drop down menu on another layout since these will change. A name plus active or inactive checkboxes. THE PLAN When the user interacts with the drop down menu the inactive names do not appear only active names. The idea is to also retain the record when the name becomes inactive in the future. Example Bob is active in May and available as a choice, but retires in June so no longer active so no longer available as choice, but if I look up that May record I still want to see Bob' name. Inactive and active checkboxes must act in concert and only one can be checked at any given time.

Dear Filemakers. I've developed an ERP and CRM all together for my company and I'm stuck in a layout for printing. As soon layout is ready to print I would like to add an extra fixed page with all the legal notice in a tiny font. How could I do to merge an extra page at the end of the document with all the legal content. Kind Regards and thank you very much,

I have a PDF that I cannot view in a container field. Interactive Content is checked. I assume the PDF file is valid because if I'm in Layout Mode with Sample Data on, the image shows in the container field. But, once I go to Browse mode, it doesn't show. If I view container attributes in the data viewer, it appears everything is as it should be. Any thoughts? Thanks, whardy

If a report only has one page, I still need it to print a second page in order to print the footer. What is the most efficient way to force another page, even if it is blank?

I'm testing the interactive content container and am finding that the video autoplay is unreliable (in my trials at least). I've checked 'Start playback automatically' in inspector but its hit and miss whether it works or not, but mostly not. Any ideas? Is there also a keyboard shortcut to run a video as spacebar doesn't work? I'm using FMPro 15.

Somehow the layout structure in Manage Layouts is out of sync with the structure of the menu that appears on layouts. (see attached.) How do get them back in sync? I'm wondering if this is a legacy issue. I have jumped versions of FM recently—from FM 15 Pro to 18 Advanced Pro.

I’m trying to conditionally hide some text on a layout when a certain field is entered and display again once the field is exited. I have accomplished this with the use of script triggers. I was wondering If it could be done without the use of triggers. Any thoughts? Thank you Anthony Conditionally Hide Text On Field Entry.fmp12

Hi. I have 2 dropdown lists of which one is dependant on the other. So if I select MEAT in the first fields only MEAT related selections are available in the second. I can add items that are not in the list OK, but they are not retained for future selection. Can anyone assist please??

Just want to check before I start: I want to reproduce a web page with tabs in a FileMaker layout to go along with the JSON data that's being imported. Is there some utility or such to utilize any existing markup? ... or do I just do it from scratch within the Layout Editor?

I am working on a shopping list. I have a drop down for the item I wish to add to the list, and for the amount to purchase. I cannot find the way to add them to a list (or portal) and they remain there. As soon as I select another item it simply replaces the previous item. Any help appreciated. Thanks.

Hi All, While in browse mode is there a way to detect if the active window (my layout) has visible scroll bars ? After using the "Adjust Window - size to fit" script step... I have a layout that is a list of items, depending on the number of records, this is likely to extend beyond the bottom of the layout window. If that happens FM (or the computer OS) will show a vertical scroll bar - that bar will "eat up" layout space and force a bottom scroll bar because of the 16 px of the scroll bar. I am wondering if there is a way to check for the presence of that vertical scroll bar to perform another "Adjust window" script step but this time add the scroll bar s…

Hi all I have a customer list in a drop down. The drop down field has an On Save script trigger which then performs a find in the same layout for the selected customer. The drop down field is configured to 'go to next object using' return. There is also an On Record Load trigger on the layout which pops up with a dialog if the customer's Attention field is populated. This all works fine unless I utilise the option to save the drop down field with the enter button. It ends up looking like this, with the white background. Once the user clicks OK the layout 'appears'. Thanks!

Gents, my app is related to contracts. Contracts may have different length. Please refer to the picture enclosed. I need the sign parts to move up depending on the contract length. But it doesn't work. I tried different options of sliding and visibility. Doesn't work. I am checking the result of Sliding and Visibility by printing a preview pdf file. Any ideas?

It's me again. This time my question is centered around how to reference a summary value from table A in a calculation in table B. The end goal is to calculate a running average of seconds per plant in the 'TrackingData' table by dividing time in seconds 's_Cumultaive Seconds' by 's_Cumulative PlantCount' from the 'Shipping Volume' table. After doing a bit of research I know that it's not possible to use the values of a summary field from table A in table B. So I made a field in 'TrackingData' to try and pull over the values from the 'Shipping Volume' table. That field does return the correct number of plants for each line in my subsummary, but it's …

I've got another question about subsummary parts and how to ensure that they present data for reports as expected. My layout is based on the most atomic table for the data to be displayed, but I'm having some trouble getting sub-summaries to be grouped by month. What I expect to see is this: Year January Department List - numerical data February Department List - numerical data ..etc. for each month of the year What ends up happening is that my data is grouped by each year, then one seemingly random month is shown, but the departmental breakdown shows as intende…

Hi, I need help for 360Works for modifying Word document on FileMaker. I'm following this tutorial for it: but I don't have Scribe functions like ScribeDocLoad,ScribeDocSubstitue etc Does these functions appear in the demo version or Do I need to buy the individual version?

Do I need to buy a license of FileMaker to import customs function? For example 360Works 's functions?

Hi, I'm new to FileMaker Pro. So I have a trial version of FileMaker Pro 12 Advanced. I would like to know if it's possible to integrate word documents into FileMaker and modify them with FileMaker data? I searched around but didn't find any solutions.

I'd like to generate a report based on data in a table, but the issue I'm running into is that I don't necessarily want to see any detail records. This is a table view of the data I want to report on: I created a report layout with the fields in the appropriate parts: This is what the layout looks like in browse mode: Using summary fields in sub-summary parts will get me the results I need, but I run into issues when trying to narrow the found record set. If I remove my detail fields from the body, then they're not present on the layout to perform finds... so I feel like I'm kind of stuck and unsure where to proceed from here. …

I have a database for our homeowner's association with lots of information that works very well, but have run into a problem when trying to print a directory of members. Most of the directory information is in the MAIN table; however, there is a second CHILD table with an occurrence for each child that resides at the address listed in MAIN. There is a sub-summary section when sorted by address, where I print all of the information listed in MAIN, and then I list the CHILD information in the body. I want an occurrence of the body to print for each CHILD associated with that street address. When I go to create the layout, on the first screen it says "Show records…

I learned recently that you can build a settings table that controls layout size, so that all your layout sizes can be adjusted from one table without entering each layout individually to adjust the size. How do you make this settings table and apply it?