Layouts

Hi, I am familiar with the send mail script step. What I'd like to do is include the first an last name when sending an email. In that way the receiver can choose 'add to contacts' and the first and last name plus the email will be added to contacts. If you make a calc field with firstlastnamefield & " <" & emailaddressfield & ">" and copy and paste the contents of this field into the 'to' field in Mail, it will include the first and last name together with the email address. However, if you use the same field in the script step Send Mail in the 'To' field, it recognises the email address, but skips the first and last name. Any idea how …

I have placed two instances of a repeating field on the layout, one to show all 6 repetitions, the other shows only the first repetition. Using "Hide object if.." I have the correct instance of the field showing up as required in form view, but table view only shows the one instance in any condition. Is there any way to achieve the same effect in table view?

Is it possible to freeze a part (e.g. Header or footer) in form view as is possible in List view ? I want to be able to scroll down a rather lengthy layout on an IOS device but still keep parts of the layout in a frozen state either at the top or the bottom of the screen. The frozen part would contain fields which display summary information for the current record as well as buttons for inputting data into the current record.

I just cleaned up my report by using Merge fields, and it's all very pretty now. However I've noticed now that if I click Find, I can no longer select any of the fields. Can you not use Find with merged fields? Is there a way to create a separate layout that it switches to when using Find? Edit: Never mind. I realized I can still access it in Table view, just not in list view. Ahh, the vagaries of FMP.

I'm trying to go to an object on a layer and having some trouble getting it to work as expected. Â Here's the relevant part of the script: Â Here's where you can see I have the object named appropriately on the same layout: Â When I run the script, everything else executes normally, but it doesn't go to the object. I also tried using Go to Field (as can also be seen in the script), but that didn't work either for some reason. Â Any thoughts as to what I might look at? Thanks for your help! Â Edit: Maybe I'm misunderstanding what Go To Object does. I'm trying to scroll down to where the item appears within the layout. It appears to be highlighting the ob…

Having both FM12 and FM13 running same screen///  Attach is one screen FM12 is way smaller..MY GOOD SCREEN  developed using 1024x 764 template... command fit window resize does a nice job..  no white border on side   NOW.. when opening using FM13...   same computer screen resolution My screen are NOT EVEN CLOSE..   what is Filemaker doing? (see 2 images attached)  WOW.. what a difference and I am lost to how to fix it?? All my apps developed to date...screens to date are classic.. WILL NOT WORK IN FM13      Â

 I have a membership application.  (Let me put up front, that I have been developing this app for several years and initially I made a mistake in the design by separating my Candidates table from my Members table... too late now)  Each candidate has a member that 'coaches' him.  This name is put in the Candidates::Coach field.  It is a popup that get's it's value list from Members::cLast_First_MI.  This works well.  The table structure is: Candidates::KF>--------------Members::KP  I have a report that sub summaries all the 'Coaches' and shows all their 'Candidates' (The layout/report doesn't change if it is based on Members or Candidates.)  …

Hello, I have a portal with a date field in the format DD-mmmm-YYYY for example. 01-Jan-2015. I want to line up the right side and left side of each portal entry for this field so the text lines up perfectly. I am able to line up one side using the justification options but when I use full justification it does not work. Is there a way to line up the dates so that the spacing changes for some dates to meet the margins of the field and the text lines up on both sides? Thanks in advance

Hi Guys, I'm writing a mail merge facility for my database. I've found the excellent custom function by nightwing which will convert mail merge text into data from my records. One of the things I need to look into is the ability to format tabular data into one of my mail merges. Has anyone created a grid in a field that holds tabular data? I know using the formatting toolbar, you can use tabstops if I was manually typing in the data but can you apply tabstops through scriptmaker? Also wondered whether you can apply any 'borders' to the grid data. Thanks Jalz

Hi, I use scroll up/ down home bottom I have some wide layouts... i know the scroll bar is on the bottom... but is there a way to pan to the extreme right when opening layout? Thanks

Hello there, just started learning FM trying to build a working DB to my store, one issue I am having is I dont want it to automaticaly save the record, so I've made a button to save the new record and go back to the "main" layout, so FM will pop a dialog windows asking if you want to save, cancel or go delete, what I need to change is that dialog window, it says "FileMaker Pro". I just want to change that text or remove it completely. Is it possible? Thank you very much!

Hi All! I work in a database that has several currency fields all set that way in US dollars. Maybe 1 out of 10 times I need to create a record where the currency would need to be displayed in euros, pounds, etc. Is there a way to make the fields editable so that I can ovverride the $ symbol only when I need to? Its not worth making the fields general since the majority of the time the value is $. Its also too clumsy to make a drop down box next to each field where you can select the currency symbol because there are MANY fields on the layout that display currency and its already a tightly structured layout. Any other ideas? Thanks!

I've noticed that some of my popovers get what appears to be a kind of loading bar at the bottom when they are opened. It appears for just about 1 second and then disappears. However, not all popovers display this. I thought it might have something to do with the client caching data that is being displayed in the popover, but even that is inconsistent. I have popovers that are displaying portals (something you would expect to have some indexing delay) and they don't get the bar. Then popovers that are simply displaying local table data will have one. It's obviously not a huge issue, but as someone who is a bit anal about the look of layouts, every time I open up parti…

Hello all, thanks for reading. I am using FileMaker 11.0.3, with the Business Productivity Solutions v7 (bps_Sales_Orders.fp7, bps_Inventory.fp7, bps_Contacts.fp7). There is included a report generating "Sales Numbers" which gives the sales value totals in £ per week, month, quarter, or year. However, I want to generate a report showing total inventory items sold. I have an inventory of 170 items and need to generate a report that shows, for example: October 2013: Part Number Item Quantity Sold 1172-2 Rock Teeth 1422 1172 Wood Teeth 342 1101 …

Hi There, I am trying to add a multiple product lines to an invoice but once I fill out the first line it won't allow me to add multiple lines afterwards. For whatever reason the boxes are not editable - can someone help me stat?! Thanks!

Hello When i create a layout with my database, the fields are automaticaly ready to receive any changes from the user, and i would like to know if is possible to enter on the layout only to "see" the records, and made any changes only when the user press the "edit" button. Thanks for your help I´m using the Filemaker 13 Advanced

I've created a report with a Grand Leading Summary. The problem is, I'm getting a blank line above where it's printing the summary. See the attached screenshots. Is there any way I can prevent this from happening? Thanks for your help! Â

Hi, I've got a strange problem. I created a table with: NamePerson = TEXT field Date = DATE field HoursWorking - NUMBER field Sector = TEXT field Year = CALCULATION field based on DATE Month = CALCULATION field based on DATE TOTAL Number of Hours = SUMMARY field (=Total of HoursWorking) With these field I create a Layout: 4 sub-summery parts: Year Person Month Sector 1 Body Part: Day The Body part shows the field: HoursWorking On the sub-summery parts are showing all the field: TOTAL Number of Hours. I would like to create a field that calculates the percentage of a Sector per Month (we need this for budged reasons). Each month = 100% …

Hello. I am not sure this is the right place to ask about this - perhaps it needs to be in logic layer section - but thought I would start here. Note: I only have access to FM11 Pro In my office we use several Filemaker databases for various teams. They work great and are customised to the needs of each team. The problem is this. Currently our reception opens up new entries for each DB as needed. Because we have 3 separate databases they have to open each one as needed and add a new record. I have been asked to find a solution whereby the databases do not change for the back-of-house teams but our reception gets a single screen from which they can cre…

Here's a head scratcher: Â I have sprinkled in a layout text fields made into buttons; when clicked, a script either inserts or deletes an "X" into/from the field. (They're used as checkboxes since it made field styling and conditional formatting possible/easier.) Â I have Set Tab Order enabled in that layout and have a problem: When users tab from a phone number (text) field into its companion "checkbox" text field/button, it selects the field's contents (see attached). This stops users cold by having to make them click outside of the field to "unset" the button then they have to go back to click if if they want to change its contents. What I want it to do is to im…

How much overhead is associated with conditionally visible objects? If I have a popover button or a slide control that is conditionally visible and the condition is such that this object is not visibly present, does the server have to evaluate for this condition anyway? If nothing is being drawn or refreshed on the screen does this add weight to the file? Put another way, if the condition is such that the object is visible, does this take longer to load than if the object was not visible?

I have a very simple database of inspection schedules (inspector, day, time, type of inspection, etc) - with 12 layouts, all of which load almost instantly, except for 1. There's not much special about the slow layout that I can see. It contains almost the exact same info as 4 other very similiar layouts - but it takes 15 seconds or more to switch to this layout, where the others are less than a second. It does have a bit more color, and a few more buttons, but I wouldn't think that would account for such a delay. Is there any way I can examin what's going on under the hood, as this layout loads, to try to find the problem? Short of that - are there key fiel…

I’ve used Filemaker as a simple database for years, but now I want to create a simple report. My data is currently in Excel. Attached is a pdf depicting an example of what I hope to accomplish. Can anyone please tell me if Filemaker can accomplish my goals, and if so, how should I proceed? Thanks so much, Anna Concatenations.pdf

Am I missing something here? The auto-enter incremental serial (attached fp7) is set to validate range 1-10. Purpose is to restrict total records in the table to 10. Create 11 or 12 records - even explicitly commit between records 10, 11 and 12. Not only does it allow the record creations but the serial quits auto-entering completely. This behaviour is replicated in 11, 12 and 13 on Mac OSX 10.9. I realise my implementation may seem weird but regardless, am I the only one who finds this behaviour unexpected? "Not only does it allow the record creations but the serial quits auto-entering completely." ​Ahm, actually this might be useful if the behaviou…

I recently upgraded from Filemaker 11 Advanced, to Filemaker 13 (basic). Now when I create a database, or “Save As”, the new database has a blank icon, like a text file. This means I can’t tell my FM databases from my text source files. I have read various solutions online, and even done something in Terminal. Nothing is working. Does anybody have any suggestions? I have had no response from Filemaker Support.

I have been reading (and re-reading) a Performance Guide created by the people at Filemaker. This guide discusses an approach whereby the developer creates a series of blank layouts for each of the primary tables. A script is triggered when a user first logs in that loops through the layouts and eliminates the found sets in each table. Go to Layout ["A blank" (A)] Show All Records Show Omitted Only Go to Layout ["B Blank"(] Show All Records Show Omitted Only etc. etc I don't know exactly how or why this works so for now I am just taking it on faith. If someone could shed light on this or point me to a discussion about the concept I would be most apprec…

(I wasn't exactly sure where to post this but since it has to do more with appearances than anything else, I hope I chose the correct forum; if not, my apologies.) I have a calc field that's a record counter for portal records, e.g., "1 / 9". In my style sheet for the solution, field labels that have scripts tied to their respective field have a dotted underline so users can see that there's a something special about that field label. The problem is, fields are static in length but the record counter can vary its width based on the number of records: 1 / 9 is markedly shorter than say, 138 / 385. What I'd like users to see is the dotted underline appear the length…

Filemaker presented this message (names changed): "John Doe (Sally Smith)" is modifying this record. You cannot use this record until "John Doe (Sally Smith)" is finished. I understand that this is about record locking. My question is why are there 2 names? This is on a Windows OS 8 system and one of these users may have been accessing the file over a terminal server. Thanks in advance.

Is anyone else experiencing pixilated fonts in Filemaker 11 on Windows 8? Any solution? It seems to be something to do with an automatically installed OS update from Microsoft last week. Thanks in advance.

A B 1 Peter 60 2 Tony 70 3 Johnny 80 4 Mary 50 IN Excel, I can use following forumla to fin out highest score person, =INDEX(A1:A4,MATCH(MAX(B1:B4),B1:B4,0)) But it will not work in filemaker, any solution?

Hi all I've just had this request come through. I'm quite sure this is something that is beyond the call of duty, but thought I'd check to see if anyone has any suggestions: Often users modify a field but remain in that field, they do not commit the record by clicking the blank space on the layout. Obviously this means that that record is locked so no one else can modify it. The suggestion has been to have an automated timer commit script. Off the top of my head this would probably not solve the problem if the record cannot be validated because of other fields that need to be populated (which would happen around half the time I'd say). My instinctual posit…

Hi Folks, I'm very beginner on this platform, and may is a stupid question, but I tried to search post about this problem with nothing found I have a simple dropdown list that retrieve values from related table ( CatID ; CatName) , when go to layout mode I see only the CatID value and not CatName value What's is wrong ? Thanks in Advance

Hi, My client has sent me a 52 page PDF form of which quite a number of pages will be the basis of a report that comes from the Filemaker solution. Rather than manually create 52 pages in a new layout, is there a tool or method by which I can import these pages? Its mostly just text - I'm happy enough to tidy a few (display) tables and shading etc. Thanks in advance. Greg

I am conditionally formatting some field objects to change color based on a calculation. The color picker available in filemaker is far too intense for my purpose. I sometimes change the color by changing the opacity level of the fill pattern but this is still not exactly what I want. Is there a way to call out the color using hexadecimal values?

Sorry for such a basic question, but we recently upgraded from FMP9 to FMP13. Existing databases were converted. I need to modify tooltips...but apparently it has changed drastically (at least for me) with FMP Advanced 13. Silly question? How do you edit existing tooltips? I can't find the option ANYWHERE. The FMP advanced manual provides no guidance and just a vague statement that you can edit tooltips. I've been able to "show" which fields have tooltips, but nothing else. Right mouse clicking, looking in layout, format, etc., menu options doesn't show anything. Inspector doesn't show any options. Thank you!

Can somebody help me with decision of one problem? - Â I have data in different tables with different dates, but i need to place them all in one layout like a map. So 2009 year - it's first column, 2010 year - it's second column, 2011 year -it's third column and so on. So as you understand i can't do this with List View, because all dates come under each other, not left to right. Â Â

Hello Friends While working in list view I found that header pane freezes on scrolling window bar but in form view it does not freezes the header pane. It there any setting to do to freeze header pane in form view also. Thanks

Hi I have lines round some of the fields such as the characters field, but when you go to preview it fails to show any of the lines. I cannot see what is stopping it. I did a test of it on the layout All Units Copy 2 Any ideas or help is very very much appreciated. thanks fully working 2 copy.fmp12.zip

I am a newbie at Filemaker and one of my questions is, how do you get a layout to expand to fit the window? Thx

I'm having one of those glitches where I think I'm going mad. I have a simple Script that runs on opening a file that takes the user to the main layout, and includes a "Show/Hide Toolbars [show]" step. it has always behaved as expected. I've just finished adding a bunch of layouts / features for an iPad Go interface, so I have the start up script sensing what platform we're on and going to the appropriate layout. This is one of the first things I did, and the start-up script behaved well throughout the first 3 iterations of my new design. (I save successive 'Builds' so I can go back to a previous milestone if I screw things up.) Now with the whole solution comp…

Hi.. I been using Filemaker 12 advance.. tweaking on the template Expense Report. The screens are fine.. I just update to Filemaker 13 Advance... Now running the same Expense Report.fmp12 app.. My screens are bigger, my fields are not aligned What is possibly going on? TIA

Hi: I'd like to preserve line offset formatting in FMP. For example, here's what I have in Word: 1. Four score and seven years ago A. Four score and seven years ago I. Four score and seven years ago a. Four score and seven years ago b. Four score and seven years ago B. Four score and seven years ago I. Four score and seven years ago a. Four score and seven years ago i. Four score and seven years ago b. Four score and seven years ago i. Four score and seven years ago ii. Four score and seven years ago And here'…

In my database I have a couple fields that have currency information and I am only able to make one field per section have the $ sign show up when you look at the fields. I created the fields then used Inspector to select "currency" under Data Formatting to make the number show up with dollar signs but I can't get the dollar signs in all of the fields. Attached is a screen grab. Â Right now the Teaching Rate field on the section of the left shows up with a dollar sign and then Total Salary & Stipend Cost shows up with a dollar sign. I need all the fields related to rates and costs in these sections to show up with dollar signs. When I go to change the fields in Ins…

I'm confused about the meaning of the script step Adjust Window [Resize to fit]. The official Filemaker definition is that it "resizes the window to the minimum size possible while keeping all items in the layout visible." I have many layouts that each show a different portal, and I have a button for each such layout that opens a window with the layout in it. I'd like the window to have no unnecessary space around the portal. Right now I keep global variables for the width and height of each layout (adding in a buffer below the portal and to the right). When the button is clicked, the window is sized according to the global variables. However, whenever I change the l…

Not sure where to put this so please excuse if wrong. I am frustrated by programs which put a picture of the shortcut keys but do not explain what those little pictures mean. My latest frustration is for Status Toolbar. I know what the flower means because it is 'command' but what is the backslash with the dash thingy? Is there anywhere that shows shortcuts to ease my frustration? Thank you.

Hello, A topic about this was started last May, but I did not find an answer to my question, which is: in table view, how do I (or can I) add some space between the top of the letters and the upper boundary of the cell (so that the letters aren't touching it)? Thanks, novice/newby,

Using Filemaker menu Loging in as Guest Runtime compiled version using FM12 I am forgetting something? Why can't i focus a field and use copy paste features.. Guest has full editing privileges Using Filemakers Expense Report Template thanks from rod

I am looking to develop the correct technique for building out a report from data. Normally this would be easy since all of my data is controlled by me in that I build the tables and fields. In this case I need to pull records from another database system so all of the data will be pulled into one table. This table will also contain data from the year before it which will also need to be compared. What I am asking is what is the best way to attack this data. I guess the first step is to explain the data. It basically consists: sales_person_id customer_id order_entered_amount order_paid_amount transaction_date I will have one line for each order entered and eac…

Is there anyway to suppress a layout when printing so it is not displayed? I have a menu that drops down to print several reports, essentially the script for the reports does the following Go to Layout["JPF_printitems1"(Locator)] Sort Records -Restore;No Dialog] Print [] Go to Layout ["JPF_printreports" (Locator)] The report does go to the layout but the user does not need to see the layout, I would prefer to simply "Show Custom Dialog" + with dialog message like "Please while printing" and have it print with no dialog which is easily done, but I don't seem to find a way to prevent the layout with fields from showing on screen, if possible. Just looking for …

Hi i wonder if anyone can help me... I'm looking for a booking calendar year planner which can be used with filemaker pro i run a small holiday property business There are 30 properties and the objective of the business is to ensure each property receives holiday bookings. To show the bookings for each property I have been using a year planner onto which i can show how many bookings each property has and which dates are involved for each booking The year planner software i used to achieve this i was actually part of the basic software which was included with the old psion 5mx handheld pda - it's incredible that such an old piece of kit had such …

I am trying to freeze a certain portion of my record template so it stays in place while I scroll through the rest of the layout much like freezing columns/rows in Excel for convenient reference. In essence, I want to make sure I can still see things like the patient name/date of entry when I scroll down on the layout. Any suggestions?

Lets say: T1: customers T2: invoices In the customers layout I have a portal in a popover showing their respcetive invoices (ones paid, others unpaid). What I want to accomplish is (using conditional format for example), to show a tag about the state of the invoices, but only works for the state of the first row. Is it posible to do it for all the rows? I mean, someting like: all paid, none paid, or SOME paid (if there are a few paid but other few not). Thanks for your help. I attach a sample file to show what I'm trying to explain. DB.zip

I have a listing in table view and want to have a button attached to the line items so I can go directly to a particular line item in a different layout. Is this possible? Thanks in advance

> Version = FM12 Pro Advanced I'm having problems figuring out why objects won't slide up for me. I'm working on a new application for the office to do employment documents. To provide more flexibility I'll have to have some merged paragraphs meaning the letter closing needs to slide up based on the object above. Doesn't seem to be working for me. In the sample file attached there are two layouts, one with the closing (text & sig graphic grouped) and the other with them ungrouped. Neither changes how the objects slide. Any advice? >>>> Sample.ZIP

I think I have early Alzheimers. I used to know this but now I don't... go figure At the bottom left corner of my layout is: 100 - + StatusBare Browse/Find etc.. Question: "How do i make this are 'nonfunctioning' or invisible to the user? Thanks

I'm hoping someone else has seen this. When FM 12 first came out I watched every video I could find about it. I recall seeing in one of them the demonstrator copy a layout object, go to a different layout and paste the object in place. He even commented on how nice it was that FM 12 included this paste in place feature. Since then I have rewatched many of the videos trying to find where I had seen it but with no luck. Was I just dreaming or is there now a way to paste in place rather than have to make note of the position and type it in in the new layout every time?

I am using a modified Filemakers Expense Report Template for my own changing it some The report expense details page layout is forward, on the top right is a report button that show expenses reported bring up another new window stepping through the lines of code.. When I click report, it minimizes my Expense Report Layout and showing the preview of the report expense... then forcing me to maximizes report Expense Layout to continue I found, If I then drag the edge of my report expense layout maximizing it.... now clicking on report button leaves the expense report layout maximized How to i keep my layout max Hope that explanation suffices or i need …

I have 2 MacBook Pro running Yosemite 10.10 with FM Pro 12.0v5 that we are using from a remote site. When i open our customer file remotely on one computer everything works fine. On the 2nd computer the 1st layout of all customer info opens up blank. All other layouts are working fine. Nothing is visible other than a couple of lines showing where a couple of fields are placed. Going into layout mode all fields are still blank...a green dot but no field names. When I click on a field box the inspector pops open and the correct field is named. I also Checked the relationships and they are correct. We have 6 stations at the home office and they are working fine. Why wou…

Hi there! I am at a young creative studio. We are currently using Google Calendar to schedule 7 people in 6 rooms, and we are using Excel spreadsheets to create estimates, actuals and invoices. I really need a resource scheduling software that allows me to both people and resources available at an easy glance, allows me to see individual jobs, and people can see it on their iphones easily. Then, I need timesheet software that allows my team members to enter in their hours and it populates a spreadsheet compared to the estimate. Then once my client has reviewed the actual hours report and we've agreed upon a price tag, I need an invoice to be generated a…

I want the page numbers in my report to start at a specific value, as the report is going to be a section of a much larger PDF document involving other stuff not from FM. I've found a couple of old threads from several years ago, involving all sorts of fields and scripts, but I'm hoping things have improved since then. http://fmforums.com/forum/topic/32139-print-different-reports-with-sequential-numbering/ Thanks

I'm using FM13 Advanced (Mac) to develop a solution. I copied my original file, experimented with different background images for a layout, and also did some other development. The file size difference between my original file and the one with background image experimentation is significant...more than I would expect from the other development I did. As a test, I saved off another version of the file using the "Compacted copy (smaller)" option, but this had minimal effect. I also wrote a script to flush cache to disk, but this had no effect on file size. So I'm wondering...is it possible that FM has cached the unused background images I experimented with somewhere …

Hi! I am new to Filemaker but can understand today a little more than yesterday. =-) So, I have a database with students who apply for Examinations. Now we are using... PAPER! For this work and we want to port it to digital so the Examinations can be done faster and give faster results for students. It is all in a table like with their names in a collum on the left and blank spaces on the right for the Yes/No grade. And, there are the many subjects that are evaluated for them in the upper part of the table. Like: | Kick | Punch | Grabs | Total: Error / Detail | Result Joe | Error / Deta…

Hi there, Anybody come across the following - please help In browse mode when i click on an edit box field to enter data it disappears or i can not at all enter it in order to modify that text information in it, this is happening only on some records and this includes a container field(when i click on it it disappears and appears on another second click)

Hi, Not sure here … ? I have a client who wants to number their windows in the "Title" ... And it turns out that the calc looks like this for the active window that opens … ValueCount ( Window ( Get ( FileName ) ) ) &" of "& ValueCount ( Window ( Get ( FileName ) ) ), so ... "5 of 5" for example. The only problem I have is when the customer opens / closes windows the calculations for the other windows are static and I am not sure if there is a way to auto update the other windows without having to navigate to each open window and recalculate. Is there a way to auto update / number the other window as the user closes and open them ?? Th…

I have a simple FM 13 db with lists of Insurance Agents and the percent commission they make for each policy. This was previously an MS Works Mail Merge. Â I easily got the company logo and address into a layout and am able to filter (FIND) on a PayDate for those agents earning a commission at say the end of the month. I can also get each Agent's SubTotal and the Preview looks great for the letter I would send to each agent with their commission check. Â I run a report (Script) based on the PayDate and my have 30 agents getting paid. Â The "problem" comes in when an agent has enough policies that that more than a one page letter is generated. Each page has the co…

Greetings. I am new to the Forum and look forward to your help. I am using the Surface Pro Tablet while I am in the field - I am using a cloud hosting server - to complete reports. The issue I am experiencing is when I open the table/form, the screen does not size properly and I am forced to use the Vertical/Horizontal scroll bars. I would like for the table/form to size correctly so I can eliminate the sliding bars. Any help would be greatly appreciated.

Hey all, I'm trying to find a way to insert a page break BY record. That is, mark a specific record in some way, and say no matter where that record falls in the layout, break the page afterwards until the next record. I've played around with a "break field" and sub summary parts a little bit but I can't seem to make it do what I want. Also, I don't want any of this mechanism to be visible when I print. Any thoughts? Thanks, -Andrew

We have a message in the database that is sent out to end users at certain times. Filemaker used to properly format the line break tag <br> at the end of the lines where it was needed. Now it sends them along in the message which is confusing a lot of our non-technical users. I have removed them but now the message is not properly formatted and comes in on large chunk of text. Has anybody experienced this as well and have any advice for a solution to restore formatting the way we would like? Thanks in advance.

I have page numbers inserted into several layouts in a text box in the form "Page {{PageNumber}}" Since installing FMP13, all of my page numbers have started printing out in the form "Page $1.00" I've never had this problem and I'm sure it is something very simple, but I just don't see how to return it to a simple page number (e.g., "Page 1"). Any assistance would be greatly appreciated.

I'm trying to find a way to format the browse screen. In other words when I allow the layout to show a browse mode it takes up the entire screen, is there a way to lets say have a browse of a table show up within a box on the layout as opposed to the taking the entire screen? Or is it possible to have a browse show up in a popover? Thanks Paul

I created a solution in FM12 using pretty much a stock theme. When opening the solution in FM13 the fonts and layout haver gotten somewhat larger and now the layouts requires scrolling to acess the complete layout. (this is on Windows). Â

I've got a line items report showing sales for a quarter, summarized by County. I'm trying to figure out how, on this same report, to show a count of invoices on the subsummary part as well. Invoices are parents of Line Items. Don't know why I'm blanking on this. I feel like it should be pretty simple. Any ideas?

Wondering if anyone else finds this really frustrating: when working with any layout wider than the printable area, I cannot move an object outside the print margins with the mouse. I have to use the right arrows, and that is so slow!

I am currently updating a runtime solution that we have been using for 14 years, it is designed for crossplatform use. I am using Filemaker 13 advanced and doing my work on a Mac (Mavericks). When opening it in a windows enviroment the buttons/fonts look differently and aren't lined up correctly. I used fonts that are available on both platforms. I'm not sure what the solution is, I'm including screen shots as an example. Â Any help/ideas would be greatly appreciated. We are almost ready to roll out our solution. Â Thank you! Â Caroline Exception PC screen shot.pdf

Once again I was playing around with slider buttons, trying out a method I 'd attempted in the past without success (although to my chagrin, I 'd forgotten I 'd tried it before...): Buttons go outside the panel, and the highlighted button is hidden or shown based on the current panel, triggered by a panel change. Should work wonderfully and it's the best way to implement buttons for sliders it seems...on paper...sadly. The problem is you need to refresh the buttons with each panel change BUT the onpanelchange scirpt trigger gets executed BEFORE the panel change, hence you can't program it to get the current panel name and if it is X,Y,Z hide the appropriate highlighte…

Hello, I am trying to create a bank statement-style report of a supplier statement. Basically, the statement will contain four fields from three related tables. The fields are: Date, Credit, Debit and Balance. One table is "Supplier" which contains a unique supplier ID, the next table is "Invoices", and the final is "Payments", all linked using the unique supplier ID. So, the data is stored like this: Date(Both Invoices and Payments table), Credit(Payments table), Debit(Invoices table) and Balance(summary field). But, I can't figure out how to get the information from the Invoices and Payments tables to show on my report. I have tried creating a new table call…

I have a layout which includes a Sub-summary part sorted by a text field named "Description" in the Line Items table. Thus, the layout sorts each sub-summary alphabetically by Description. With the goal of having more control over how the sub-summaries are displayed I have added a number field named "Line_Item_Order_Number" in the Line Items table. However, when I change the sort field of the Sub-summary part to "Line_Item_Order_Number", the Sub-summary does not even show up on the layout. Any ideas why? I'm using FMP Advanced v12.

hi all,  I have 3 field (see attached for layout)  field 1 is a checkbox field 2 is a pull down field 3 is a date  field 2 and 3 are placed on top of field 1  the issue I have is the if I place a check on any of the option on field 1 I can no longer select field 2 or 3, if there a way around this?   Thanks RudyM

One of the inspiring sessions I attended at Devcon this summer recommended this nice pack of icons as good for use with iPad solutions, so I went ahead and purchased them. http://www.streamlineicons.com I'm now realizing that I'm lacking some basic conceptual understanding of how to deploy these PNG icons in a Filemaker solution. If I "Insert Picture" to get the icon onto the layout I see that I'd need to actually store the icon in a folder somewhere accessible to Filemaker, which I'd rather not do. But when I use a copy/paste approach, the icon appears with a square white background -- not the 'transparent' effect I need. Is there a third option, or a wa…

I have 10 different Layouts on the project am working.. I want to users to be redirected to a particular Layout each time They login... Sort of a default layout whenever users login.. Please, how do I make for example ''Contact layout'' the default layout?

Hi, did something change ?. I have graphics ( eg logos) that I made into buttons and have the border change when the cursor hovers over it. I'm now unable to replicate it. In layout mode it no loger has the 'normal, hover, pressed, in focus' drop down, only normal. The existing buttons still work and I can turn a graphic into a button, but the hover thing isn't available Cate

Hi On the all units layout I have added some vertical lines to try to separate some of the data. However previously when I have added in separation lines and ticked sliding up based on all units and also resize enclosing part the lines displays only as long as the information that is in it. However this time the line seems to stay at a fixed length and I cannot see what is different this time. If anyone is able to have a look and see what I have missed that would be amazing. As i have spent an hour trying different things and they all result in the length remaining fixed. Thanks Sarah fully working 3.fmp12.zip

Hi - Anyone know if is posible to disable the operating system toolbar to force users to use a script to close the solution. Thank

Hello, I hope this is the best place to post this. I'm new to the forums, but have plenty of experience with older versions of FileMaker. I'm currently supporting a database based on FileMaker 6 / Server 5.5... You heard me. It's a rather long story, but the short version is that we will likely be redesigning the database from the ground up using FileMaker 13 in the near future. I'm in the process of researching some of the many new features that have been introduced over the years, and have hit a roadblock when it comes to designing layouts. We have many different devices, with a variety of resolutions (almost entirely Windows PCs), and I would like to be able to…

I'm having a difficult time trying to format a time stamp field to display only hours-minutes- AM /PM without also displaying date data. The field is populated using a "GET CURRENT TIMESTAMP" script. The result I get reads 9/12/2014 3:01:46PM. I would like to have it simply display 3:01 AM (or PM) I have tried the formatting dialog box in the inspector and have tried to set the date fields to be a custom format displaying "None" for each of the date attributes. I have attached a sample file to show what I am working with. How should I go about doing this? timeclock .fmp12.zip

Hello all, Â This is my first time posting on this forum so go easy with me. I have started using Filemake Pro 13 on Windows 8.1 for almost two week. Â I have recently hit a snag in the form of my background resizing to the width of the windowborder. Â This probably is just a setting i missed but after some frustrated hours of trying to find a solution i have decided to ask teh people who will probably know. Â So in short this is my problem: Â Layout background with fixed width keeps resizing to the windowborder. Â Thanks in advance. Â Harm

Hello: I don't know if I'm explaining this right but I have a text field that end users are cutting and pasting into. The text they are pasting into has left justification at the Tab point. Is there any way to retain that so the text aligns correctly. After the paste the text goes back to the margin. End users pasting something like this: • The quick brown fox jumped over the lazy dogs. After the paste it displays like this in the text box: • The quick brown fox jumped over the lazy dogs. Dom

Hello Forum! I apologize if this post is in the wrong place, but the 'Reports' section did not appear to have a place for just reports. I am trying to create a report using information from multiple tables. The relationships are:  Customers >-------Equipment >---------Service.  I would like the report to show all the customers that meet a certain criteria (the easy part). When I bring over their related records from Service, I only want to see their most recent 'Annual Tune Up' record, and if there are not any, then their most recent service record, and if they have no service records at all, then it can be blank.  Annual Tune Up, is a value in th…

I am now an intermediate BEGINNER Filemaker user. (1 month as of SEPT 2014) I heard that internally Filemaker understands the DATE VALUE as an INTEGER (whole number) that starts at 1 from the year 1/1/0001 I have multiple tables that relate primarily on the date... QUESTION 1 Is there a way to see this number? QUESTION 2 Should I Not Use DATE fields as KEYs in my relationships ? The relationships seem to be working fine, but this is early in my solution and fear I may get into trouble?? POSSIBLE SOLUTION :: Make an Auto INCREMENT serial number field and then match on those? ..then How do I ensure date sequence and a separate…

Greets, all: Â I'm creating a report where I need to average each heading's average but I'm scratching my head raw trying to get it to work. (Please refer to the attached.) Â For example, under Content Specialist, I want to average 2.13 and 2.71 which should equal 2.42 (4.84 / 2 = 2.42) but FileMaker has other plans and spat out 3.03...which is a result of taking all the gazillion records in the found set and averaging them out instead of averaging just the two (sub-summarized) numbers. Â I "get" that I need to create a new sub-summary but how should I code the (new) summary field so I get the average of the items listed under each heading? Â TIA for your help…

Hey Guys. I have a db with a lot of different text fields, I often makes changes to these fields, and i'd like to have a log that record all the changes i make on all the text fields. It should show each change as a new line like this: On "date" field1 got changed from "something" to "new something" etc... Anyone that can help me create that ?

Hello: Â I'm sure this is a head knocker but I can't seem to get my fields in a browselist to have the field borders show up not only for the current record but for ALL records in the list. Â You'll see in my screen shots that when I highlight a record the fields have border lines but I'd like to have all fields with border lines regardless of whether it's selected or not. Â Â In the 2nd screen shot you'll see that I do have a black 1 pt. line border for the field selected but when I go into browse mode it just doesn't show up. Â What am I missing here? Â Thanks in advance. Â Dom

Dear lovely experts, Sigh. Several years ago I volunteered to help an artist friend by setting up a graphically complex database which made central use of a specific dingbat font (for musical symbols). Long story*** but... Now, on a much newer computer without the font, faced with a request to re-generate the printout, I don't even see how I can find out what the font name WAS, since FM only shows me the substituted-in font when I [convert and] open the file. (And, to be clear, there's no way of even approximating the desired output with a different font.) Somewhere in the file itself must be the name or other ID string for the font actually specified by my la…

Hello, could you help me? I wanted to undo something in layout mode using cmd+z, but i pushed something other key and i changed somehow the background to grey. In every other mode can i see the theme perfect with the background except in layout mode. do you have an idea, how can i change to the normal view? Thanks very much, Csaba

Apologies in advance for the newbie question, but I really have searched extensively on the web, this site and various tutorials. My only conclusion is that I do not know which question to ask, as I am fairly accomplished in VBA. I am self-learning Filemaker Pro 12 as I need solutions for an Ipad and I like the ease of creation and modification on the fly. Essentially, I have a database where the master might be many hundreds of fields, or I could create myriad tables and keys - this is irrelevant to the problem. What I would like is to create a solution where at the first field of entry, a dropdown allows for a selection of, say, 10 choices. When that field is filled…

I've been utilising slides and pop-overs for data entry to try a minimise the number of layouts needed. Working lovely so far. I have a 'Company' screen, that upon entering shows a 'view only'. It has buttons for 'Find', 'Edit' and 'New'. Clicking these reveals buttons pertinant to the button clicked. When you cancel find mode, you go back to the record you were previously viewing. These seems to be default behaviour...fine. When you cancel edit, you obviously go back to the record you were previously viewing...fine. When you cancel new, you go to the last record in the table/found set...jarring for the user. So, when cancelling the entry of a new record, ho…

Hi, I'm trying to achieve something I expected to be straightforward, but after banging my head on a brick wall for 24 hours it's time to aask for help. I have a fairly straightforward company table and a contact table. Related one to many as you'd expect. When browsing a layout based on the companies table, I can see all the related contacts via a portal. I've never really done any reporting, but I wanted to create a report layout that gives me the company details at the top, and lists the contacts underneath. I expected this to be relatively simple, but I can't get it to work. I have the folowing report layout based on the companies table. Parts: He…

I have moderate understanding of Filemaker, so I apologize in advance, but I'm a quick learner! I have a database with thousands of records. I need to create a layout (though I'm not sure that's the best option) that allows me to choose specific records and insert them based on their unique ID. Ideally I'd like to type the record in and "add" it to this new list. Additionally, I'd love to display them as "boxes" both horizontally and vertically so I can see all of my chosen records at once. I'm just looking for any advice on the most efficient way to create this. Thanks so much!!

We've just completed updating to FM 12 from FM 11. Some of our report layouts have a very tiny subsummary part, so that the client name (which is how the layout is sorted) appears next to the first project, instead of above it. This was just to make our reports fewer pages, as printing a report with every project can be a real tree-eater. I believe I read something about how FM 12 handles this, but I can't find it now, and it looks like if I have a field on a layout which overlaps between two parts - it just doesn't appear at all. Is there a way I can make that field appear in full without taking up so much space? To summarize, I'd like the report to look lik…

I have a layout with an imported picture(container field) and want the USER to be able to add an object on top of the picture at the position they click with the mouse. i.e. Place a Cross or X at the mouse position. I believe I can create the script activated by a script trigger, but can't seem to find how to determine the position of the mouse when clicked ?