Layouts

I'm working with a massive database with multiple users working together to add, edit, remove records etc. Periodically a record will be accidentally duplicated by hitting command-d--a miss-click of command-f. This causes a lot of problems if it goes unnoticed. Is there a way to disable this?

Hello, I am a newbie to FileMaker but a long time programmer ... I am working on an Art Gallery collection tracking application. A key layout in this application is a matrix of images, each representing one artwork item in the gallery's collection. Clicking on any image will take you to a details layout of that particular artwork (see link below to image) I've defined an Artworks table such that each row of this table documents a single artwork with fields such as Title, Artist, Material, YearCreated, Dimension, Price, Image, etc. List Layout and Portals, both limit you to vertical rendering of records, they cannot render records horizontally. I therefore m…

Hi all, something I discovered out of the blue - I often use a contact field in a related table and have two fields on top of one another. I enter into the lower field which gives me a popup list of related contacts, but I really only enter an ID which isn't shown in the value list. Upon exiting, the upper field (which you can't enter) is populated with the name of the contact. Now I found this: I only have one field which is the ID using the same value list, but is formatted as a popup menu and it works exactly the same way. No more aligning two fields. And because I use global value lists, I don't even have to have another TO to my contacts file in the gr…

Hello! How to create a personalized login system, one that introduces the name and password?

I'm currently optimizing a solution with approximately 1000 layouts. I know that at most 10% of these are being used, and would like to delete the others. Usually when I do this I put a text block on all layouts saying something like "IS THIS LAYOUT USED? IF SO INFORM ME [DATE]" Going throught 1000 layouts it's kinda tedious. Is there some kind of third party tool or other solution that can help me with this? Copy Paste is the only option I know of. Tia, Andreas

Hi Forum. I have a good fun problem for y'all here.... I generate a report in FM11 (Windows XP) and look at it in Preview Mode. It has 106 pages and i can see them all in preview mode and scroll all the way to the last page. My Report pages are numbered at the bottom it says on each page "Page 33 out of 106" "Page 34 out of 106" "Page 35 out of 106" etc and the last page says "Page 106 out of 106" Now I do SAVE AS PDF from the Menu while in preview Mode. My PDF is only 97 Pages long. The last page in the pdf says "Page 97 out of 106" All the information is in the pdf. I compared the screen output to the pdf. All the info is in the pdf, but…

Hello My name is Jon Petrie and I am in the same boat as you are and I am trying to setup the samthing as you are with Filemaker To keep track of my bank transactions.

ow can I add new data to a portal or to a related table?using another layout.? like this one;

Hi, I have field 1, which is set at Checkbox Set and uses a value list of three items (A, B, C). Then I have field 2, which I’d like to be able to hide whenever A or C, or both, is checked in field 1. Hiding field 2 when A or C of field 1 is checked works fine. But I can’t manage to hide it when both A and C are checked. I’ve tried several different calculations but nothing seems to work. Is this feasible? Thanks for your help.

Perhaps this issue has been dealt with before, but I couldn't find anything in the posts about it. Does anyone know if it is possible to tell FileMaker to keep the subsummary and the body together? I never want to have a page that only has the subsummary without the body with it, but I also don't want to make every subsummary break a new page. Any help?

I am developing a database and I need help meeting the required goals. It is a company that has about 450 branches, divided by 50 states, that they are divided into 9 regions. 3 layouts were created for the same divisions. Basically when an agency logs in they have about 12 buttons in the layout and clicking one goes to the agency information. Example: Agency 153 logs in and goes to layout A clicks the button and goes to the information for that agency. Agency 345 logs in and goes to layout A clicks the button and goes to this agency information. The same theory applies to states and regions. The big question how to implement this? I've tried…

Hi, I’d like to create a window, for lack of a better term, that opens up in a layout when a predetermined event happens. Is this feasible in FM? Could someone give me some guidance as to how to proceed? I guess I’ll need a script to make this work. I hope my description is clear enough. This is my first post on this forum. Thanks.

I had a use case where the user could select the background colour for a record in a list. While it's easy to select a background colour it's less obvious how to make it user-adjustable. I found a similar example which I've simplified to do this. It creates a container with a coloured image in it which is the cleanest way for my needs. This can then be used as a background image. It could be linked to a web viewer containing a Colour Picker but it's not needed here. Please let me know what you think and if it can be made more efficient or if there's another way of doing this. Generate Colour.zip

Hi. How can i do this? I have one template and i want to duplicate this template but i duplicate the layout the field contents is the same the each layout. How to do it so that the same data is not always the same? https://imgur.com/NWcAB1E The picture is same all layout, how to change this?

I have a TODO list. Some tasks I want to put off until tomorrow, but have them re-appear on my TODO List the following day. I have two tables; TODAY, and TOMORROW. I can get the individual records to go to the TOMORROW table ok by just using a button and script. This operates on only one task at a time. I am having problems getting the records in the TOMORROW table to automatically come back to the TODAY table the following day. I date the records going to the TOMORROW table and have tried to use this as a criteria to send them back to the TODAY table. One problem is that there are often numerous records and not just the one that need to be sent back. I have t…

Good day all, My apologies if i am posting in the wrong group. I am looking for some advice to accomplish the following task. I have a database with 40 fields, i would like to create a dynamic layout that would show the fields with missing data. is something like this doable. I currently have a portal that show the users the records with missing data in the portal i want to add a button that will opens a window and displays the missing data fields. Thanks JMart

Hello, I have a portal that is moving around my layout. In edit mode, where the columns are aligned properly with the headers. list view browse mode, where the portal has moved to the right. I don't have any sliding enabled. Thank you in advance for the help

Good Morning! What is the best way to achieve this type of layout where I can have 4-5 tables shown and sorted with hundreds of accounts on one layout/page? Would you suggest 4-5 portals with filtered settings or is there a better way?

I like to see the page margins when working in layout mode. However, View page margins is always grayed out. This happens in all my FM 17 solutions, all layouts. How can I view page margins?

Hi all Apologies if this is doubling up, I have posted this here also https://fmforums.com/topic/104916-display-multi-line-records/?tab=comments#comment-475037 but I think this might be the better in this forum. It's quite a fundamental thing so I worry I've been using FileMaker wrong all this time! Is there a way, without the webviewer, to view a stream of multline records in browse mode? So, if I were to have a list of email messages, in which the body field has multiple lines, I would be able to see all those lines within each record. Rather than each record's body field being a fixed height thus resulting in cut off text. Thanks

I'm not well versed in summary layout parts and reports, but am trying to learn. I have a (personal) database to track investments (stocks, mutual funds, bonds, etc.). I have fields such as: number of shares, price, and value (technically: shares * price). Each record has three checkboxes: buy, sell, and current holding (previous (historical) records do not have 'current' checked). After establishing a found set (of a particular investment), I have a script that constrains the found set to buys, sells, and current record(s) (plural, because the same investment could be held in multiple accounts). (All historical records (except buys and sells) are thus not in th…

My horizontal scroll bar has disappeared. What should I do to restore it?

I have a billing system, from customer data. I have a script to create new invoice, it always worked fine. suddenly crashed and the filemaker closes whenever I intend to create a new invoice. Thanks for any suggestions to solve.

I am trying to extract lines entered in a repeating text field (named "Equip" w/10 reps) into separate fields (Equip1...Equip 2...etc) I am trying to modify (add to) a large existing database with alternate layouts so I can manage all the data better. I would assume a calculation or script to populate the alternate layout fields with the extracted data... Or perhaps a better idea? Any help is greatly appreciated!

I have created a list report with a value list assigning values to fields of certain colours. All from 1 table – no related values. Layout is based on the same table. The script filters the number of records with a certain colour. The script button is located in the footer of the report. Excursion scripts: Departure show Pink Set Variable [ $DeptG; Value:customer::Dep_Date ] Go to Layout [ “Departure_List” (customer) ] Enter Find Mode [ Specified Find Requests: Find Records; Criteria: customer::Bus_Color: “=Pink” ] [ Restore ] Commit Records/Requests Set Field [ customer::Dep_Date; $DeptG ] Perform Find [ ] (This script is assigned to 6…

Hi everyone, I have a layout that I want to enter only one user at a time, i try a field where a script trigger on open layout makes a set field "1" and when closing the layout deletes it, so when another user enter the layout if the field is "1" denies the access, but if filemaker crash or the connection is lost, that field stays in 1 and nobody can enter the layout, how can this be solved? Thank you in advance for your help.

(I apologize if this isn't the correct forum for this, so feel free to move it to the proper one, please.) I'm stuck. I built a solution with a parent-child portal setup, the user can see the four, court reservations for the day (Current Setup attachment). However, she'd like to be able to see a "big picture" view as depicted in the Capture 5 attachment. I figure a popover or a jump to another layout is in order, but beyond that I don't know how to pull this off schema-wise, especially when it comes to filling out a range of time slots shown in Capture 5, e.g., Court 1 would have the time slots 8:00 and 8:30 populated with Practice (Emilio Lizard), blank spaces …

I have been watching and re-watching a web seminar by Mark Richman called "Eight ways to make Filemaker databases run even faster. https://www.youtube.com/watch?v=yNRNMgs--T4&spfreload=10 The basic goal is to minimize the packets of information that need to come down from and go back up to the server. He makes the statement that "if you can see it or touch it, it invokes the data" . To this end he advocates for using more layouts with fewer objects per layout. My question has to do with how visibility factors into this. A database I am creating for my cabinet shop has a lot of graphics that are grouped together with fields…

Hi Guys In layouts when I drag a field onto the layout it always uses the same font. I cannot find a way to change the default font. So at the moment every field I drag onto the layout I have to change its font size and resize the field box. I have read through a few articles which don't seem to show the same for my Filemaker (V.17 Pro Adv). i.e. Edit, preferences, no font tab. Also, in layout don't select anything and then change the font attributes, but they are greyed out. I've looked at themes and styles but cannot make sense of it if this is where I need to look. Your advice would be greatly appreciated.

Hi I am struggling to work out how to get my database to generate a report that shows the total characters for that day and not broken up by scenes. So it will show this is the total characters from the character field for that day from all the scenes. When you go on to the database. username admin password pirates it opens on the list layout. if you click on scenes then click on the report button for all units (the middle one) it will each scene for that day and the characters for that scene. What I am trying to do is get it to show all the unique character total for each unique one for that day. I thin it is the…

Is it possible to copy a layout to another database? Relationships, field names etc are not a factor. Have a backup copy of my database. Messed up a layout and want to restore it by copying the layout from my backup copy of my database.

Hi All, Basically the layout we have has many tab panels, and I have a forward and back button that navigates through the layouts. What they would like is when they come back to this layout it goes to the last tab panel (s) they were out. I would think a script that stores the isfrontpanel (layoutobjectattribute) in a merge variable but I am having a hard time figuring this out. It seems like it should be simpler and perhaps my brain isn't working correctly this morning (it happens! Lol). Can't see the forest for the trees. I included a screen shot as an example.

I have a list with three fields of data. The first is 'task', and the next two have autofills for 'not urgent' and 'incomplete. If the task field is empty I would like the record to automatically delete. I have messed about with 'IF (isempty)' but having no success. Any assistance would be appreciated please.

I have searched and my question does not seem to be asked. I am confused on when to use one or the other when I want to take a person back to a field. so example person types into a field A and before leaving layout I check many things that they did. I see they need to correct field A so I show custom message as to why and i want to take them back to field A. this is all on open record not allow commit first. Is it best to object name field A and use Go To Object or use Go To field? ps i have field validation usually also but i like to use nicer messages. Also I do not always know the message i want to give them until they are finished with several fields. Ca…

When I set a text object as a button to perform a script, it becomes “Grouped”. I find selecting the text for editing is very difficult. One option is to ungroup the object but then the button is deleted. Is there a simple way to select and edit the text without ungrouping it?

Hey.... Maybe this is a beaten topic....perhaps? While FM templates are amazing....does anyone know where to get free templates off the beaten path? I am a designer.....just looking for fresh ideas honestly. I want to see some cool layouts. Not the programing but the user interface. Every database can use a little refresher, visually. Thanks Mike

I go to View Show and select buttons but it never sticks. Once I close the file and reopen it, it no longer shows them. Can I make that setting stick?

I've recently upgraded to FMP 17 from FMP 10. 10 was doing fine, but I had to get a new computer and 10 won't run on it, so 17 it is. All of my existing files are running just fine, but I've now created a new file for something and have run into something that's driving me nuts. I have a layout that is set to view as a list. And my most recently used row is highlighted. I can't get it to go away. In 10, the very left part of the row was selected, which was just fine, instead of always having one row highlighted.

In older versions of FileMaker Pro, I could click on a field, show the text ruler, and graphically set tab stops - as illustrated in the picture here: http://www.filemaker.com/help/12/fmp/html/edit_layout.10.44.html In FM14 Pro Advanced (Mac OS X) I can't for the life of me figure out how to get into this mode. I've tried showing and hiding every toolbar I can think of, but nothing seems to get me the magical TabStop ruler mode. I know I can edit the TabStops numerically (Inspector/Appearance/Tabs) but I like the old graphical way. Did they remove this feature?

My FM 17 Pro does not have a Page margin option in the View menu, in layout mode. How can I show the page margins in layout mode so I can see that everything fits on the page?

[Folks: I'm not really sure where to post this question; the TOC or possible places is a little intimidating!] FMP 17, Mac 10.14.2 Question: Is there a simple way to search for text within a record, showing the result in a useful way? Setup: I have several databases that I've been using since back in the day when every table was distinct. One of those is called 'Memo', which functions just like the name. I learned long ago that while FM works OK in this way, it is hardly a word processor. I work with this restriction for many reasons. And, I just keep it simple. From time to time, though, these documents become lengthy. And, from time to time, I need t…

Hello I am experiencing a strange issue with the Inspector. It will not show field options, changing a field from edit box to Pop Up Menu for example. I am attaching a picture of what I see. I am working on FM 16.04 at the moment and the file is hosted on a server. I updated the server a couple of days ago to 16.04. I tried to connect with FM 17, still same result. I created a file locally, still same issue. I created a new user in Windows 7 and logged in to it with same issue again. What could be happening?

Hi All, I have 2 related table. when in layout 1, i need to go to related record in layout 2 When I write the script, I select layout 1, but table 2 is not in the list when selecting show record using layout. any suggestions?

Hello, I have been using FMP for only two weeks, so please excuse my ignorance. I am using a trial version of FileMaker Pro 17 Advanced (17.0.2.205) on Windows 7 After accidentally deleting my primary layout, I successfully copied it from a backup. However, since then I have not been able to switch to table view. Both the button and the menu command are greyed out. Is there another step that I must do to be able to use the other views? I guess I could try to make a layout that mimics the table view, but I'd prefer to fix what I have broken. Thank you

I want a layout with a fixed header for every page across the whole page, a leading sub-summary across the whole page, then another leading sub-summary and a body that each span two flowing columns, then a trailing sub-summary across the whole page. From what I can tell, FM can only do the flowing two column thing in all the layout parts except the header and footer, not specific to particular layout parts. Any chance 16 or 17 have that feature? (I'm in 14). If not, any ideas for a workaround? Any way to get the contents of the header and footer to vary like a sub-summary? Any other possible workarounds? Thanks,

I have a FMP file that contains records that show eight metrics per entry (date, ethnicity, number of adults, children, etc.). This is data from a Food Bank, tracking types of food distributed, distribution dates, and family statistics for each distribution. I need to construct a yearly report that presents this data in Month by Month lines and sliced in several ways: Number of adults, children and seniors who did, or did not, make a scheduled pickup Breakout of the same data by Ethnicity Value of each pickup Etc. This could result in 10 data points times 12 months or 120 fields needed to make up the report (daunting for me at least). I know I can export …

Thank you for enduring my simple question, but I just couldn't find this issue in the Forums. I'm using the FM Starter database "Estimates" and have heavily modified it (added fields, buttons etc...) to make it more usable for our Company. As you may know, the Estimates database is three integrated databases (Customers, Products & Estimates). I have successfully (thanks to the help on this Forum!) implemented many very useful features, but one eludes me. When you enter an Item, the Description is copied from the Products database auto-magically (I didn't mess with this). However, some in the company want to be able to change the Product's Description (add…

Hi under the scene list layout which displays in list view. I get it to sort via the characters but then also by their status. I wanted it to display somewhere on each record line it displays a record number. for example so I can see I have 2 that are the diva character and have been selected and 1 diva character that has been rejected so it puts a 1 on the line that is the first selected person, then a 2 on the next selected person or a total so when it has many people listed as each character I can see how many I have quickly without having to add it. Hope this makes sense? Username is admin passwor…

I'm keeping track of tournament results for a backgammon club in which each player receives points for achievement in our monthly tournaments, leading to a season champion at the end of the year. So I have a PLAYERS table and an EVENTS table and then a join table in between, PERFORMANCE, that holds the results for a single player at a single tournament. So, I have a list view that shows each player's results with a sub-summary part totaling their cumulative point total defined as a Summary field in the Performance table set to = Total of Points. This all adds up and displays fine. . . . but after sorting the records by Player name to get the sub-summary, I w…

This seems like a fairly simple problem,. perhaps I am missing something. I previously had a web object on a layout that would grab information from 2 fields, so the result of the search would be displayed for that record. The web address I used before in my web viewer: Case( CARRIERS::MC# > ""; "http://li-public.fmcsa.dot.gov/LIVIEW/pkg_carrquery.prc_carrlist?n_dotno=&s_prefix=MC&n_docketno="&CARRIERS::MC# &"&s_legalname=&s_dbaname=&s_state=~~&pv_vpath=LIVIEW "; CARRIERS::FF# > ""; "http://li-public.fmcsa.dot.gov/LIVIEW/pkg_carrquery.prc_carrlist?n_dotno=&s_prefix=FF&n_docketno="&CARRIERS::FF# &"&s_legalname=&…

I have a layout with three portals, all portals are showing the data as expected when printing. My issue is with one portal where i cannot get the data to print, i have i tried everything i can think of including creating a new layout with only one portal but nothing. Any idea what i could be doing wrong. Thanks

Aaaack! I was working on a layout I was using for a little "Card Window" I was trying to implement for printing up an ID badge, struggling to figure out how to make the window appear the perfect size without having any scrollbars along the bottom or side (is there any sort of "resize window to fit" layout script step I can use for that?) . . . But I did something -- I have no idea what, and now when I'm in Layout Mode, the Body/Header/Footer display only across like half the layout . . . in BROWSE mode it's fine, but in layout it's totally confusing. It's making me realize I don't really have a grip one what all the guides mean, which ones are "draggable", which ar…

Hi Everyone, We have a field called "Log History" in every record where we basically store the EmpId of the user with change details, whenever any change taken place. For example, content can be like " " Emp 502706627 on 5/15/2018 9:44:48 AM Emp 504384332 on 5/15/2018 9:44:45 AM changed Project status from Active to Parking Lot Emp 501234627 on 5/15/2018 9:37:05 AM Emp 501234567 on 5/15/2018 9:32:27 AM Emp 502673233 on 5/15/2018 9:32:23 AM changed Project status from Active to Parking Lot Emp 504358927 on 5/15/2018 9:31:49 AM Emp 5027090927 on 5/15/2018 9:31:34 AM changed Project status from Active to Parking Lot Emp 502706627 on 5/6/2018 7…

Hoping someone can help! I've searched Google and the forums and haven't quite found the answer I need. In my mind it should be a simple one but it never seems to work out that way. lol. Anyway, to put it simply, I'd like to drop an Adobe Illustrator file into a container and have the ability to open, edit, close the file and have these changes reflected in the container's contents eliminating the need to bounce back and forth between OSX folders and Filemaker. I've seen some info about using "Open URL..." but my attempts to use this have only resulted in a Safari browser window opening with an error message. I'm assuming I'm missing some link that sends it to the r…

Hi guys. I am sure this is a simple solution but I don't seems to be able to figure out how to it. I have a scrip that I execute when the file is opened, on of the lines I have is "Adjust Windows [Maximize], and it works as expected. my issue comes in when I execute a script with the "new window" command. the new windows will open as expected but the main windows losses the "maximize" setting and I have to manually "maximize" it. what am I doing wrong. Thanks

Hello all, I'm having a devil of a time getting a set of merge-field text to hide. The text is from a Summary field, which I want to hide if the value is 0. I have it in the Sub-Summary part, and everything else is sorting and displaying correctly, but I can't figure out how to correctly get this object to hide. I have a feeling it should involve something with GetSummary, but not familiar with using this function, and not finding the best examples of figure out online. Thanks in advance for your helpful answers!

Hi, I would like to know if it´s possible to create memory tables within Filemaker and how. I saw in a different RAD tool the option to create memory tables. The table is kept meanwhile the program is open and dismissed after is closed. I see this as a powerful tool for complex reports and to speed processes. Maybe there is an ODBC or JDBC driver for memory tables, Server side or client side.

I have a list of things that I sell. The list is in the Body. Above the Body is a sub-summary by item category. Everything in the body is set to not print. I grouped everything in the body. Sliding is based on 'all above' (house this doesn't make a difference); and I checked resize the enclosing Part. Below the Body is another Sub-summary by Item Number (this pulls in the Item descriptions). Then, I sort Item Category, and then Item Code. And then, everything works, which surprised the heck out of me. Except sliding is goofy, so I looked carefully for any stray element but found nothing. FileMaker Pro AdvancedMTP002.pdf The ideas I have for f…

(I'm not actually sure where to post this so forgive me if it's in the wrong place?) Once again I find myself in deep FM water with no wading boots. I am using FM Advanced 16.0.1.162, and Mac OS 10.13.4. In the screenshot, it's the field "Status" that's the focus of my question. The screenshot is arranged so that the Inspector is adjacent to the field I'm asking about ("Status"). Status is a text field. Validation is limited to a Value List. After I moved the Status field to the layout, I needed to change the appearance to use Radio Buttons conforming to the Value List. But, I can't select the "Control Style" field in order to change it. I've seen si…

The main toolbar with the arrows for navigating from record to record, find, etc. disappears. I removed the toolbar from a few windows that are controlled by buttons - to add related records, but the main window should have the toolbar. I have to recover the file to get them back and when I close the file they disappear again. I can't figure out how to fix this. - Under "File Options" - Hide all toolbars is NOT checked. - I have no custom menus - the only menu set is Standard FileMaker Menus Where else can I look to fix this setting? Thanks much for the help! - Lea

Hi, kind of new to FM and working on a task thing. What i have is the users are in the fm user setup and displayed on a a uer management page, i also have a create task, on the create task i have a box showing the users and i tick the ones i want involved in that task. At the moment when you open the layout for task list it shows all the tasks, what i want is that the only tasks users can see is the ones their user is setup to be involved in. I really have no idea how to make this. Im looking for guidance :)

I have created a summary field which shows a number - say $434,567. I want the field to return $435 eg thousands of dollars. Not really clear how to do this... many thanks for any help.

Hi Folks, I've just moved my database to a server. It works fine, but it's slower and a couple of the scripts now take enough time that I could do with putting up a wait / progress bar. The issue is that the scripts dive into other layouts to create records in other tables. Am I right in thinking that I can't use a Card Window and then change layout behind it? (I haven't actually used Card Windows before...) I suspect that this isn't an unusual thing to do - what are the standard tricks? Many thanks all! Best wishes, Mike

I've placed an eps image into a layout, the company logo that appears on every page. It hung around for a day or two and then disappeared, leaving its icon. I thought it might be a linking issue (even though I recall having embedded it) so I moved it to the folder, the icon changed colour. I have tried to re-import the image and now I'm told Filemaker "This file type cannot be used a picture" - I haven't edited the file at all in the interim. What's happening here? I realise, pragmatically, I shall just replace the image with a PNG and then copy into each and every layout, but, beyond my frustration I would like to understand what's going on.

I have a file that contains records that have a beginning date field and a ending date field. My summary report is working, it is breaking as it should and contains subtotals and a grand total. My problem is I want to report records that are between a user entered beginning date and ending date. How do I get those dates and use them to run my subsummary report?

Hi guys! I would kindly appreciate your help! I need a report for my employees uniforms. I have the employee table where I have these variables: employeCat, shirt size, shirt amount , pants size, pants amount, shoe size, shoe amount (employeCat can be administrative, designer, reception) So, I made 3 summary fields to add up the amounts and thus obtain the totals of each item. Soo, I'm having problems when creating the report, can't get it to work. For example, I need to see the shirt size L and see how much shirts I need for that size and the amount for the category the employee is in. I. E Shirt size L, 11 required for category…

I have hidden many fonts in the Windows 10 Font folder that I do not use. However, they continue to show up in the FM font menu. Is there a way to stop this? I would like to shorten the font menu to fonts that I use.

I recently upgraded from FMP 14 to 16. In layout mode, there was a line of text and icons at the bottom of the window. I don't see them anymore and can't find an option to view them. The line consisted of a zoom number (typically 100), a minus sign "-", a plus sign "+", an icon, and then another icon, and a mode selector - Layout in layout mode. I would like to use the second icon which changed the view of the part labels such as "Body" and "Footer". I would like those labels to be shown at the side and not on top of the part. Where did this option go?

I'm working on a database right now that handles general accounting information for a department of a university. My current layout looks like this: Where the left section has buttons to take you to the different layouts and look at various different tables, and the middle column is a scrollable portal to look at all of the jobs. On the right hand side for the "employees" section, I was able to fit all of an employee's data in that space, so it worked, but each job has significantly more data associated with it and doesn't fit in that space, so I was wondering if there is a way to make that section scrollable, but looking at the same record (i.e. The job desc…

Am a bit lost on what (I think) should be a quite simple script: Field 1 has a value list on layout. Field 2 is a general text field for typed data entry.. My goal is to use Field 1 to trigger/manage a script which does severla things, but then leaves the mouse/selector inserted into Field 2, for ease of use... So... When I select an item in that value list, an OnObjectExit triggered script: sets a variable from that, then clears that field inserts a calculated value (based on the variable created) in another field. Then it SHOULD "go to Field 2"... as in, after the script is done, the cursor should be inserted into Fie…

I used to know how to do this… I need a layout that tells me the total number of each plant on the list. Fields are: Plant Code, Qty. Sample data (using commas): AAAA,15; AAAA,10; BBBB,25; CCCC, 40; AAAA,5; CCCC,10 I want a layout that tells me the total number of each type of plant, like this: Plant, Total Qty (from sample data above) AAAA, 30 BBBB,25 CCCC,50 So,I tried making Total Qty field, and putting it in a trailing sub summary, sorting by Plant. This doesn't work. I also went through Phil's tutorial but apparently didn't follow directions. This has got to be Filemaker 101 but I am screwing it up. Where?

Hi There, I’m pretty new with using Filemaker, but still I built a solution that fits pretty all my needs (for now…) I’m still experiencing one big problem with my solution for which I would need help. Here’s the context : I run a little company. We receive financial reports every quarter. All quarterly reports ( Excel file or csv file) have the exact same form. I then created a layout based on the table created when importing the csv that works properly. My need: as I’m to receive a new financial report on next quarters (Q12018, Q22018, Q32018 etc.), I would like to pull the new data from my Main layout. Is there a way of having a layo…

While creating a new solution, the file starting to freeze up when I try to access Part Definition. I have to use Ctrl+Alt+Delete to close the program. It only occurs on this one file. File Recovery did not work, and saving as a compressed file did not work. Computer reboot did not work. What can I do?

Hi, I made a Filemaker Database a couple of years ago for a correspondence school, now I'm building the same thing for another school. The database has a record for each student and a field for each possible lesson they can be sent. When a lesson is sent the date goes in the appropriate field. For reporting I had no idea what I was doing, so I just made a table with a field for each lesson and a script that would search within a date range, take a record count of the returned records take that number and put it in my report table. The date range is set by global fields for the start date and the end date. The script would repeat for the 200 or so …

I'm trying to make a Filemaker solution to design labels. In the layout there are two fields I would like rotate 45 degrees. I have noticed that Filemaker rotate in steps of 90 degrees. However, I have not been able to find a solution for 45 degrees of rotation. Any help and advice is welcome to correct this layout problem, perhaps someone who knows a plugin that can help with this. or another clever trick to solve this? The layout of the labels is given and adamant, several labels have already been printed and will have to be replaced in a layout change. So adjusting layout is not an option in this case.

I was wondering if it were possible to have indents in a text field. I would like to have a bullet followed by a paragraph that is indented for all it's lines. If there is a further (more indented) bullet, the whole text should be further indented. I know FM is not a word processor, but I am wondering if this is available anyhow. Thank you in advance, Fed

How can I extract content from sub summary layout objects using? https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/getlayoutobjectattribute.html I'm able to grab the content from the first subsummary, not the remaining however. The following: set field( output; GetLayoutObjectAttribute( 'header', 'content' ) & GetLayoutObjectAttribute( 'row', 'content' ) & GetLayoutObjectAttribute( 'footer', 'content' ) ) works fine, the bad thing is that only row 1 finds its way to the output-field.

Hi guys - a very simple question which is bugging the life out of me. I want a brief comment to appear inside a field and then dissapear when the typing starts. For example within the address field i simply want the description address until the user enters the field and then it disappears. Ive seen this on many dastabases and havent a clue how to do it in filemaker ? Any help would be much appreciated ! Thanks Peter

I am trying to make a checklist for tasks that attaches to different records. Ideally I would have a table that keeps track of the tasks but I also need it to connect to each object. So for example, on November 1 , 2017: -Object 102 was washed and wax -Object 103 was dusted -Object 104 was washed with power hose -Object 105 didn’t have any work done to it. All the objects (102-105) are in a table that I'd like to remain static, and acting as a primary key. I’d like to create another table that has a record of what was completed for each day instead of creating a new record for each object and the particular thing that was done for it that day…

I am trying to build something like a bingo board to act as a visual management tool for my cabinet shop. This bingo board might be printed out on hard paper or could be electronically managed on an iPad. I would like to have the field names show up as a column on the left side of the layout with the field contents displayed in a spreadsheet type format on the right. The image of each cabinet would derive from a repeating container field. The value for each task would derive from scripts that are keyed to each cabinet type. A sink base, for example, would not have any values in the drawer box category but a drawer bank would not show cookie trays. When…

I have 19 different organizations with each one having different blood pressure readings. Have figured out how to get the name and number of records found as well as the total number of records in database using both Get(FoundCount) and Get(TotalRecordCount) when I do a search. I can get it to do the first organization and give me the correct data as I can see it matches the found set. What I will it take for me to get it to do this in a report form similar to this: Organization Number of Participants Total Number of Records in the System ABC Org …

I have a layout for printing on a letterhead and have inserted an image file as the Background Image to serve as the letterhead. Printing and Save to PDF work as expected, but for the life of me I cannot get the background image to display correctly in Preview mode. Not displaying correctly in Preview mode is not terrible except, when the client does a print preview and it doesn't line up, there will be questions...even though it print correctly. Basically, it looks like the background image has a pre-determined padding applied to it at the top, but all parts and objects are set to padding 0. Has anyone else experienced this? Preview mode - letterhead…

I have a file with 2748 layouts in it. I just completed the table structure design, with a layout for each table, 2782 tables in total (a few did not need representations in the layout structure). I split out my tables into folders. When I go to select a table from one of the folders, it does not navigate to it, but does not freeze, nor does it show an error, it simply behaves as if it is on the layout and continues functioning as if nothing had been done. This File is half ESS tables, half local tables and written in 13.ov3. Anyone have any thoughts on how this might happen and why, seen it even before, and what can be done, I am effectivel…

How to show the record number in a sub-summary layout? It should start at record 1 per group, the parts of the layout are header, sub summary and body, It should look like this Group A 1 John Doe 2 Jane Doe Group B 1 John Doe 2 Jane Doe

Does Filemaker 16 offer the ability to utilize responsive design? Is there anyway to create breakpoints within a database so as to have the displayed layout be appropriate for an iPhone, iPad or desktop device? If this is not possible and I need to create three separate layouts, how does the device know which layout to toggle to? I

Hello, Full disclosure: I am very new to scripting in FM. I am trying to hide an object based on 2 criteria: Leads::IsOnlineProposal = "No" and PatternCount ( $$Permissions ; "ViewOnlineProposal" ) = 0 When the Value for Leads::IsOnlineProposal is "Yes" I wanted my object ( just a big square to hide the customer data on the screen ) to hide everything on the screen. That part works great. But I wanted to give some users permission to still view the customer info ( or continue hiding the object ) when the permission is checked even if the value for Leads::IsOnlineProposal = "Yes". Thus the second part of the hide scripting in the hide section of the in…

I have a 4 column report for an invoice: Date, Activity, Time, Charge in that order from left to right. Activity can sometimes be 2 or more lines. I really want the time and charge fields to align horizontally with the last line of the activity field: so if activity is 5 lines long the time and the charge will print on the same line as the 5th line. if activity is only 1 line I want time and charge to print opposite the first line. I cannot get this to work: I have tried each field aligned in bottom, I have grouped and I have locked. Can it be done?

Hello All, I'am wondering the best way I would go about making a custom report. I have a table with results for around 30 different tests. I would like to make a report that could allow users to customise what results are included for example Test 1 - Result Test 2 - Result Test 4 - Result Test 12 - Result Test 14 - Result Would this be best done by using a sub summary when sorted by or is they a better way? Jon

Hi there. I have a list view layout that gets saved to PDF and print. On my computer everything looks good. However, on clients computer, the right side is cut off. I have the margin view showing and everything seems to be within the lines. I am using windows and client on Apple.

Hello, Noobs here. I am looking for some assistance that when I select a record on a form I am taken to that record. Example below. I am taking this simplified hypothetical example in the parts table with columns: Finished, Shared1, Shared2, Shared3 Row 1 values: A, B, C, D Row 2 values: B, A, C, D When Row 1 loads in the layout you sent, say that A appears on the upper right box. Therefore B,C, D load in the bottom in red Desired behavior: when B is then clicked, you want it to replace A in the upper right box and have A, C, D appear in the bottom in red. Thanks in advance, Brett

Hello, I would like to ask question for which I didn't find answer. I have several filemaker dbs which differs only by data entered. All tables and fields are same. My question is if it's somehow possible share layout design across all those databases because occasionally I need to modify that layout. Change it in all dbs could be time consuming. Of course I can have empty "design db" where I could re-import data after layout change but again it could be time consuming too. Also I'm wondering if is possible to use field name (in layout) without any table name and table would be used relative by table defined in layout? (Shows records from) Thank you

Our current system organizes employees into Teams, and those Teams into Groups. Reports can then be run that display employee time with a sub-summary part for Group and one for Team to give a big picture into performance (see attached image example). New management wants to split SOME but not all of those Teams into smaller functional areas. I'm trying to figure out what kind of layout and calculation gymnastics I'll need to do to display something like the example, but to add a third layer - only where a third layer exists. So it might look something like this: All Clinical Affairs Clinical Affairs Consulting Writing Clinic…

I'm scratching my brain raw as to why this is happening: same layout setup, settings are the same in the layotu setup, same (defunct) Electric theme; on a Mac, FMPA v16. Image 1 (from Layout "A") After clicking a button that fires the Adjust Window (Resize to fit), it sizes the window correctly. Image 2 (from Layout "B") After clicking a similar button. Notice the bottom-right corner. Image 3 (from Layout "B") I stretched it the window to the bottom-right so you can see it's the same as in Image 1. What could cause this to happen? There aren't any objects in the layouts so...?

is it possible to size a layout that matches the exact size of an object/container for export purposes (say 468x60 pixels) I'm wanting to do some graphic style layouts. Printing them limits you to the inherent dimensions available on your printer, but exporting them as PDF and then editing them further there is a distinct option. ANd I am more interested in keeping them in teh digital realm than in printing them to paper. Any way to export the results in the desired size?

i have Problem when I use OnLayoutKeyStroke. I use Barcode Scanner so I use OnLayoutKeyStroke But I have Ploblem about to click or type other field it's jump to Field Codebot( field for Script Barcode Scanner ) Plaese Help me to type or click other Field

I'm trying to do something that is turning out to be much more difficult than I thought. I want to produce posters for series of workshops, one poster for each series. I have accomplished this in the past using Mail Merge in Word. To simplify somewhat: In FileMaker, I have a script that creates an Excel file, one row per poster. The data gets pasted automatically into fields in the appropriate Word file, and I can produce PDFs from there. Different types of series need their own word file, but there is a manageable number of possibilities. I am attaching examples of two typical posters. Here's the problem I seem to be having in arriving at a solution that occurs…

Anyone have or know of a technique to employ to create a scrollable, read-only text field? This is mostly for FMGo (smaller iPhone display). In large text blocks flagged as read-only you either have to expand the text field to cover all expected text and scroll the entire layout or hack something together with a web viewer showing the text which requires a fair bit of html crafting to get the formatting to look right with the other layout objects. I'd like a more seamless solution (if one is possible) that keeps the hacking down to a minimum. thanks

I generate an invoice by a report. The work is totalled and then VAT/GST is calculated and the total work + GST = the invoice value. These 3 fields appear in a trailing grand summary. One above thew other above the other: Total Work GST Total this invoice Depending upon the number of items in the invoice the invoice may have more than one page. Again depending on the precise number of items in the invoice I can finish up having 2 of the 3 summary fields on one page and the remaining one on another page. I would like to be able to print the invoice knowing that the 3 summary fields will be kept together irrespective of the number of items…

Below is an example that I am having. It appears the actual field is sliding up. But there is still white space before the next field. Thanks.

I'm having some issues with the understanding of Sliding & Visibility feature of the Position section of the Inspector. I've attached a screenshot of the what it would look like when printed, but would like to know how to work through making that space below the last subject and bringing up the line separating the next grade. There are fields there, where the blank space is, but it has conditional formatting so that if the subject is missing, none of the other information will show. Essentially there are a total of 15 subject fields going down vertically but want the section to move up if the fields are empty so that the document could fit to one page.