Layouts

I have a cabinet shop. I'm trying to develop a piece of software to help us generate shop drawings. Â We build a lot of different types of cabinets but we use essentially the same math for all of our work. Depending on the type of cabinet some of the math needs to show on the shop drawing and some of it does not. The attached jpeg shows what three typical cabinet styles might look like. Â The basic report starts with various fields superimposed over a CAD drawing we drag onto a layout. Depending on the type of cabinet you are building a GO-TO script takes you to the appropriate layout. There are a lot of acrobatics associated with all this navigation. Â Â I…

I cannot take a picture of the ghosts ... every time I touch my Mac they disappear. But they exist in 13 sometimes when I hover above an object. These tooltips which display in browse mode about how to design while in layout mode are not ones put there by me. Several times while attempting to capture the image of the hovering tooltip, they have disappeared and I could not get the EXACT message and I should think the exact message would be important in searching through code to find the break so finally ... today ... I just wrote it down instead of trying to capture it: Choose an outer shadow effect for the objects New file, no tooltips. Browse mode. …

I am creating a huge number of reports for a customer in FM13Advanced. I have to align a lot of text and am spending a huge amount of time tweaking this.  Is there a simple way or something that I'm not seeing when doing this menial  task, as in Indesign or any other layout program?  See example below.  Notice the slight alignment issue.Â

Currently I m using sort selection drop down menu (trigger) to sort my report with different kind of segments, by month, by year, by customer, by user and by product. Each segment give me the different total on sub-summary column. When i m put this thing on filemaker 12 server or using instant web publishing, this sub-summary ain't working. And worst thing my boss insist for this function, because he can present our record/business to management anytime anywhere when they asking.... By any chances someone can share with me your work around idea? Really appreciate.... Thanks hwachai

Hi, Still learning and trying solve. I have a, maybe dumb, question : I know that to get and use the name of a button is not possible, and I am wondering if there is any trick that would allow me, and others, to get the name or better said the text typed into the label field that appear when the cursor pass over the button. My idea is to generate a relation based on that text and make popup a window including the related data. Any trick, link will be very much appreciated. Happy and prosperous 2014 for everyone

Hello All! I am having trouble building a complex subsummary report efficiently for a real estate database. The report layout is simple: I basically have a layout with 18 columns, all years, 2000-2017. The layout only has subsummary parts, no body parts. The subsummary part I am using to display data is sorted by a field called Micromarket (basically a geographical area). I want to display the number of units built in each year for each Micromarket. I have the report working perfectly, but I had to add many fields to my property table to accomplish this. The fields are as follows: Field Name: Number_of_Units_2000: Calculation: If ( (Year_Built)=2000;Number_of_Unit…

Hi there... we have a product information table and layout which shows product information. They are all different products and some have options/data that others do not have... For example we sell washing machines that have a spin speed and load capacity And we sell fridge freezers that have a cubic capacity but obviusly not a spin speed. What is the best way of showing these specific options so that unused data is not shown? I thought about maybe using a portal that is populated by a calculation depending on what the product is?

I have built many layouts using the typical approach of basing the layout on the Line Item table and using a list view with header and footer and it work great. However, I am designing a solution now where the line items currently are not products as much as they are brief descriptions of the work to be done of varying lengths. I plan to move them away from this to a more structured "Parts" table, but the transition may not occur for a while. Obviously, by using the standard method I would have to make the body part and associated "Product Name" field large enough for the longest description. Then the short "part" descriptions will introduce large gaps of whitesp…

v13 now offers the possibility to use "System Settings" to show decimal and thousands separator. this means you don't have to add calculations to display the correct value. maybe i'm missing something but i couldn't find any related information in the release notes. hth pixi

Is there anyway to have my buttons on top of a slider pane uniformly stretch (that is each one gets wider) when the window is stretched? I am using an ipad size as the basis of my design for the buttons. I am afraid though, this isn’t possible. This also includes fields, but again I can’t have the behaviour I want, I usually have a field in the middle I stretch, which aesthetically isn’t where it’s at. Having said that, if there is no other work around, I am going to use scripts here to script in going to a new layout upon a considerable change in screen dimensions. Which is possible in FM 13

This is probably really rudimentary knowledge, but I am drawing a blank here: How do I set the sequence the fields are accessed when one presses tab, or any other button acting like commit and go to next field.

Are there any pointers, or standard practise for this? Perhaps, possibly, everyone has their own style and there are no hard and fast rules for creating help pages.

Finally getting a chance to play with fmp12. in Inspector, position, I used to have the choice of inches, centimeters or pixels. In fmp12 the default choices are inches, centimeters and what I assume are points. Are pixels gone? I am guessing they probably are because of retina displays doubling up on the resolution, but I would like to know for sure.

After making a number of changes to a database, I ran into a perplexing problem where I would call up a layout in a script by a name calculation, and the proper layout wouldn't appear. But the layout of that name very definitely exists, so there seems to be no rhyme or reason why I would get an error. Does anybody know if there are situations where a layout can't be navigated to by name? If it would help to have a demonstration of the problem, I have taken the database, which is fairly complex, and modified it so that the problem can be easily observed. At 12 MB, I cannot attach it, but it can be downloaded from Dropbox. https://www.dropbox.com/s/uo2akt6vxljfk…

Hello I am using he barcode font CCode39 and does not work as expected. I would like to have the barcode not being separated by its own value number. I only want to print the barcode. Is there something special about barcode in filemaker pro 11? Thanks! Daniel BARCODE-RESULT.tiff BARCODE-LAYOUT.tiff

Is anyone else naming their layout elements, such as back and forward buttons, buttons to navigate records, search fields etc. If someone’s practise this, can they say what advantages it has and where they find it useful ultimately?

Basically I'm experimenting with different display strategies and I like the idea of using merge variables as buttons. My objective is to create a static number of merge variables, named $$mergeVar1-$$mergeVar10; then based on some trigger, declare these variables dynamically by way of a loop; then create some kind of button toggle/command functionality based on the name and content of the variable I press. I like the idea of using merge variables because the toggle command "list" could expand or shrink based on the scenario I prescribe. This is basically in alternative to using multiple sets of radio buttons, in which some of the radio fields might be irrelevant/taking u…

There not much info on the ver12 or Ver13 I have found... using Accessibility Inspector I having problem clicking Label drop down.. gettin nothing.. then hangs me.. can't change object focus ..only to get released exiting layout no save.. whereas other buttons have 1 option, seem to work. and then allowing a Title and Help text entered and Saved ..read by Seri Narrator Any clues? TIA

Hello: I have a layout where the title bar is off the screen and I can't seem to grab it to pull it down. I know there is a key combination on WINDOWS using the mouse keys to pull down a window like that BUT is there a key combination to grab it and pull it down on a MACINTOSH. This has been eating at me for a while. Thanks. Dom

I need to name my webviewer so I can treat it by name for the object properties. It used to be easy but I can't find out how to do this anymore/ thanks

I am having problems with the way maps are presented in windows. I am alternating between fm 12 and 13 but I haven’t tested 13 yet to see if it solves the problem. Namely the map assumes a position towards the left and I cannot center it or zoom out (btw, am I right in assuming ctrl or cmd and “+” doesn’t work in the web viewer. It’s not so far for me.)

Somehow this is supposed to work, and work for windows too (since fm 13), as it’s reported in the change log. Yet somehow it won’t work for me. I have field with a web address but cmd click doesn’t seem to do anything.

So.... Is there a definitive list anywhere of calendar implimentations & 3rd party options? 1. It would be great to have a listing of them, so one can make an intelligent decision. 2. It would also be great to have some comparisons by "knowledgeable" individuals regarding their options. I'm looking for something to inject into a solution, which allows me to easily add in project dates (from other tables), have it create deadlines (say a set of preferred alerts at X days prior to), and have the ability to tie into iCal or some other such integrated platform... Ideas?

Is there a way to format a layout so that it will dynamically change when printing a receipt? I am in the process of creating a POS for a quick service restaurant where the receipt needs to show any modifications to the customers order? As of now, I am contemplating building a field which would build the order in html to print, but that doesn't sound efficient. I was hoping someone could point me in a direction where this could all be handled within filemaker. Here's an example. A customer orders 3 lattes, one with 2% milk and no foam, one with skim mik and caramel the other just normal... Receipt says: Latte........$3.50 Skim C…

I've created several databases in FM12 and consistently find that when I define borders on a field they only display on the record currently selected. I've also noticed that they do not appear when using the field in a report which also has the borders defined. I thought that I'd seen some of my previous FM12 databases show this border specification on all records . . perhaps I was looking at an FM11 database. Is there a trigger that I can set in the inspector to change this so that all records will display the border formats?

I am running into a curious problem. I have a navigation wrapper script that essentially goes to a layout and displays a particular found set. There are a few scripts involved: Wrapper (sets some defaults) -> Filter (refines records to display) -> Sort I am putting some variables in the script to show me the overall time it takes for this layout to load for the end user (i.e. for it to display the data). I use "Get(UTCMsecs)" at various points to record how long certain steps take in addition to the overall time. I then have a dialog show me all these variables at the end of the script. Putting the "start" and "end" timer-readings around just the …

I periodically duplicate a layout and then tie to a new table occurrence related to the original base table. I find that I have to go through and mechancially update each field on the duplicated layout to refer to the new TO even though the fields are exaclty the same corresponding fields that originally referred to the source TO that I duplicated It is a mechanical task that drives me a little buggy. Is there some way of saying in one command "update all these fields on this new layout tied to this new TO to actually refer to this new TO or do I have to continue to do it field by field in the mechanical fashion that I am currently employing? FM PRO 12

I have a layout that shows a WorkOrders table with fields WorkOrderNo, StartDate, Technician and HoursWorked. I've set it so that there is a sub-summary for sorting by WorkOrderNo and by Technician (Drop-down list of the names of the technicians). There is no problem with sorting by WorkOrderNo. But, when I sort by Technician, I start getting some funny results. For instance, if I sort by "Bob", I might get the following sub-summaries: Bob - WO-100001 | Dec 18, 2012 | Bob | 5 - WO-100003 | Dec 21, 2012 | Bob | 2 Bob - WO-100006 | Dec 31, 2012 | Bob | 4 John - WO-100002 | Dec 19, 2012 | John | 5 The desired result is that only a sub-summary for "Bob" should appe…

Hi everyone, Here is my issue : I would like to create a runtime solution that : - would be shown full screen (completely full screen, without the menu bar, like Chrome or Firefox full screen options) and - would work with keyboard shortcuts (actually the user should be able to launch some scripts : command + 1 for example) I thought about 2 solutions (which don't work) : - creating a "normal" runtime solution but I can't find how to remove the menu bar (for going full screen) or - creating a Kiosk runtime solution but then I can't use the keyboard Would you have a solution ? Thanks :-) Phil

We seem to be having some major issues laying out a new document set in v.12v3. I'm not sure if there has been some change between pre 12 versions and 12 that is making this relatively simple task so painful. In this document set there are a series of leading subsummary parts, a body part, a trailing subsummary part, and finally a trailing grand summary part. We need vertical lines that cross the subsummary parts and the body part to essentailly separate colomuns visually. The body part (and the vertical line) need to slide up based on field contents. We can't seem to get predictable results for this. Does this function differently in v12? Suggestions? …

Hi, all: What's the "best practice" when it comes to creating reports in FileMaker for both domestic (U.S.) and international users when it comes to paper size? Currently, all the reports in the solution I'm working on are sized for Letter but I could adjust the print margins 1/4" smaller to accommodate the narrower A4 paper...but that doesn't appear--to me, anyway--that it's the best solution. TIA for your input!

I seem to recall FMP would store the last window position and layout when a file is closed. Was it just a dream??? osx10.9 FMPA 12.0.4

Hi all. I have a navigation button with a dropdown list that takes the user to the selected layout. Is it possible to use images in the interface via two or more concatenated fields in the form of ImageContainerGlobalField & NavigationListField

I am creating a membership directory from my FM membership database. I would like to get the names of the states to repeat at the top of the next column or page when the number of records for a particular state doesn't fit in only one column. I have two leading "sub-summaries when sorted on", the first for Country and the second for State. I will be printing in two columns per page. Thanks for any help in advance.

It's just a vector forward icon I am using, pasting it from illustrator to fm. Using the layout on a mac client there are no problems, but on windows the icon is whited out so to speak. Quite possibly a bug?

When I am posting a new topic on this forum my browser window shows ' Posting New Topic - FMForums '. If I go to window menu this same browser window will appear the same in the drop down list. In my filemaker setup however the windows do not take the name of the layout but the name of the database, and each addltional windo a numeric suffix as in, NAData, NAData - 1, NAData - 2... Is it possible to have the layout name instead? Thanks

I 've read all I could on them of course, all I managed to, to be exact. Yet, I still can't figure out why on certain layout where I am trying out a title header (for the purposes of having a clear indication of the current layout name and purspose) on my layout it doesn't appear in browse mode.

Hi, I've dropped Google map on a layout and I get a message about the Browsers font size not being supported. Any way to sort this? Also, How do I get the map to present without side panel on the left?

I had to implement my own, and I was wondering since in the form views you only get one record, how do you navigate it then, since the starter solutions have been created with the provision to run them without the status bar, and I refer to the desktop ones, not the iPad or iPhone ones.

I am toying with some of them, mostly for the ready made, iphone and ipad layouts. But I see a lot of /* */ comments in the scripts where values should have been and values set to "" in script steps, in the contact starter solution for example. Do I conclude correctly that they do indeed require modification to run properly?

Hey guys. I was browsing the interwebs for a calendar solution to show the duration of booked assets. I found a simple one on here but can't seem to relocate it. What I'm looking to do is have all my assets listed down the left of the chart, and have the days of the month listed across the top. It would be in a monthly view. The chart would have the booking date ranges in a "bar graph" spanning that date range for the respective asset. Is this feisable? I'm going to keep looking for the original post I found, but this is what I'm going for.

Hi guys. Can someone tell me the standard practise to create personalized layouts. That is, say an employee's personal layout with their data, and everything related to them. I suppose there's an opening script and a Get(AccountName) command, but I don't know if I should use it for a PerfomFind script step or not. Any help appreciated.

Hi, I change my layout number to a name as soon as the layout is created. And I've been stuck navigation to my layouts via the name not the number and here is why. Any help here i would be grateful. Thinking I could just use the "Get ( LayoutNumber )" function. But to my surprise, nope! I get the layout number based on the layout order in the layout pull done menu, hmm... 1 Home 2 Navigation 3 Preferences 4 Portal 5 ... ect. So if I'm on my Portal layout, "Get ( LayoutNumber )" gets ... 4 Not ... 23 Which is what I'm looking for 23. Yet LayoutID ( FileName ) produces a list of all my layouts by ID. So where is the Get ( LayoutID ) I…

Often i might have a global $$var in its raw format like 1 or 0 I rather display on layout in a different format... ie "your right" or "your wrong" Using a new calc field, a case or if statement,, just doesn't seem work well using $$var? . Any idea? TIA

Hello! I'm a software developer who is used to programming with languages such as C, C++, C#, Perl, PHP, etc. A client asked me to help him with a clients/sales management solution for his company based on FileMaker. I'm experienced with relational databases and had no problems setting up the necessary database for him. Creating simple Layouts to populate tables such as customers, products, invoices which are directly related is not a problem. I do have problems with copying data between unrelated tables though. Say I have the following DB tables (FK stands for foreign key, PK for primary key; table names are surrounded by hash signs: '#'). # Customers # ID (PK) Name …

Hello, I'm working on setting up an email campaign in Filemaker and found a tutorial that references a template that came with the Business Productivity Kit that looks so perfect - it would save me heaps of time. On the phone support told me these files would probably work with FMP12 but I can't find a download for the BPK anywhere! Does anyone know if it is hosted on any sharing websites or would be able to upload it? Or know for certain if it works? It must be knocking around on someones machine somewhere and as far as I am aware it was free! Thanks, Jon

It seems rather clumsy. So here's what I do. Two tables one is employees and the other companies, pk for companies has to populate its fk counterpart in employees. On my layout I choose to show Company Name to populate a fk_Company_Serial no, and then I have the company name looked up and auto inputed. I 'd like to know if there's a more elegant way to do this. Or any other way for that matter. Regards.

Data-entry fields don't expand for easy reading of large text blocks. Another thread has spurred this concept http://fmforums.com/forum/topic/89853-dynamic-field-size/ I would like to brain-storm the best solutions using native FM in the following scenario: Situation: Parent table with child table of Notes (or comments or chapters – large segments of text). Need: I want to scroll pages of text easily from parent, reading from one note to the next. I do not want to have to expand the field to read - only scroll a single field. This may contain notes, chapters in a book, dissertation etc. When I see something I want, I want to click on it and open a window …

When a field has a script trigger attached to it and you view the field in layout mode, an icon is displayed to show that the field has a script trigger attached. Why should this icon appear twice, and what does this mean?   I attach an image which shows the duplicated icon and the script trigger dialog for the field.  The layout is in a database hosted on an FMP11 Server Advanced installation, and the layout is displayed in an FMP11 Advanced client - this installation is Windows based. The field itself is a date field from a related external file hosted on the same server. Field entry is not allowed in browse or find mode. The field is set as a button …

Hello, We have a long document as a single record. I am trying to build a table of contents when we save as PDF. I need to determine the page number of the subheadings, which are fields. I have a script that pulls the subhead and its correct page number, but only if I can get it to the correct page by go to last then go to previous. The problem is I do not know what page the field will be on. Under the subheads are numerous sliding up fields. thanks, Jim

I have a database with multiple tables. Two tables do not have a relation set up. I want to see on my screen both of these tables and flip through one or the other and enter fields. I would like it to look like when you have two databases open you can have one open on the right side of your screen and one on the left. Something similar for two tables within one database.

Hello there, I am brand new to FMP 12 and wow do I have a lot to learn. I am stuck and hoping you can help: Basically what I have is forms that need filed out for different rooms in a house, but its different for each house. In one house, I might need a form for the Kitchen, Bathroom, and Bedroom. In another house, it might be the living room, office, and kitchen. So what I have right now is a checkbox with all the different rooms. What I would like to do is, based on clicking on select items in that checkbox, to have a layout page created with each one of the checked boxes seperated out into a different layout page. So I would have seperate pages for Kitc…

In reference to: http://fmforums.com/forum/topic/83953-portal-sorting-with-fm12/?p=408698 Hi, I am doing a task and I am thinking to use this Virtual Sort from Jeremy, by the way, excellent! But I don´t have any portal and what I need is to make something like the Sort Dialog Window, I know how to coose fields, maybe comments clarify them better for the end user and with the field list I´d like to do the same you did in your work jbante, but, have you anything more to help me? any advise or something to use your modules in a normal layout and sorting data with your scripts, I have no buttons, I´d have the list of fields and the order (ASC / DESC) of each one separ…

Hi, Â I use "Tool Tips" quite often, and I have a client where the tool tips were not working except for one. Â As I investigated the tool tips that did work, which was only one, I notice that the "Tool Tip Image T" in Layout Mode was bigger than the "Tool Tip Image T's" that were NOT WORKING. Â No matter what I did to change the size of the Tool Tip image "T" to no avail. Â I even tried coping the text, then changing it to the text but the image "T" goes small all the time now on this file Very strange. Â This is the only clue I've got to why the "Tool Tip" is NOT WORKING for my client. Â Now the "Tool Tips" all work on my computer regardless of the "Tool Tip T…

I have a FMP file that loads various other FMP databases into a single file. In my header, I have a logo and a portal-based menu that links to layouts that load data from those individual files. For all other layouts (photographs, boxes, exhibitions..etc) everything works fine, but with Contacts, the header contents will not appear. Similarly, the Photographs layout loads an image and title information from the Images database file. Again, the header contents will not load until I have entered the ID# from the Images database. Does anyone know what could be causing this? Thanks in advance, Ryan

OK, so I've asked other questions about scripts in the appropriate section, but think this might be better posted in this section. I have a List View report that contains a list of data appropriate to the logged on user. Whilst the amount of data shown will be different based on the user, it will always only show a list of client names. What I need is for the user to be able to select a client name and that to take them to another screen, which is populated with the appropriate data from another table based on the selection. I have a table called ClientDetails, and another call ClientContacts. The field (ClientName) is a relationship between the two, with a Value …

FM11 Starting with the first tab, I fill the field with the required information, then it takes me to ne next field in order, but after a nth field in order, the "unmodifiable field" message appears, where is the error ?

I found several others have stated this conplaint as far back as FM7 so I guess I'm with company. Kind of surprised that it is still not fixed. Anyway, I couldn't input certain Thai and Lao characters in FileMaker text fields or labels. But it can read those characters all right when those text are input directly via MySQL and displayed in FM (I use FM12 Pro). Even more curious is that I can type those characters in FM Go! Have seen a lot of suggestion about copy/paste, opening up scripts and all, but I would really prefer a built-in solution. I'm trying to push FileMaker to replace my company's current database software, but the inability to type common Thai/Lao …

I'm pretty sure the answer is "No", but just in case I've somehow overlooked the obvious in my various searches, I was wondering if anyone knows a way to change FileMaker's Default Table View Properties.  Specifically, I pretty much ALWAYS want to "Include Header Part" and "Include Footer Part" when in Table view, but I have to go in and check the appropriate checkboxes every bloody time I create a new layout. I don't think it would be so annoying if it weren't for the fact that it's buried a couple of layers deep...  Thanks--

These fall into the category, "things that baffle me but are so simple I'm almost too afraid to ask..." 1. Sometimes, in Layout mode, when I click on a field directly the layout tools are dimmed (font, bold, underline, etc.). However if I select the field by dragging the mouse across it, then all the layout tools are active. What's that all about? 2. What is the best way to ensure that layout text, text fields, and numeric fields all line up nicely on a straight line? It seems like numeric and text fields don't always line up well, especially if they have been stretched vertically. Setting the alignment to the bottom, and using the 'align > bottom edges',…

I have a strange issue. We have a table of data with about 250,000+ records. On occasion a new record created by one user will show for another user with "??" in some data fields and the other data fields will be blank. This persists for the affected user until they quit FileMaker and re-open the database. 1) Does not appear to the be typical data corruption issue that shows a "?" in every field. - Issue only appears one user's FileMaker Pro while other users can see the data fine. - A restart of the user's FileMaker Pro client always resolves the issue. - "?" shows as a "??" in some fields while other fields appear blank. 2) Issue appears to affect records a…

Hi all, Â Seasoned FM developer here but really never done a lot with reports. Â So me thinks this might be a simple question... Â How do I have a summary field in a trailing grand summary, but summing a field from a parent table? Â See the attached screen shot which should explain pretty quickly what I'm trying to do. Â I think the issue is, I can have a trailing grand summary of a field that's based on the current table (and of fields showing the "body" section), but I can't have a trailing grand summary of a field that lives in another table and / or displayed in a sub-summary part.

I import the results for UK handicap races into Excel but it has grown to a large spreadsheet and has its limitations. I am the wrong side of cemetery hill and decided to keep the grey matter ticking over learning filemakerpro to import the resuts. I have successfully imported a small test database of results. So far I have the form in the database with the tables and relationships below but when I try to make a layout to view the form I get the horse name and form I get 1 outing and when I scroll through the same horse displays again with it's next run. I think it's because I have failed to fill the foreign keys in the horse_Race table. I also want to add a Todays runne…

I have a three table database in FMP 11 with the following tables: Contacts, Projects and Organizations. I have a layout that shows information on a particular project, based on the Projects table. Each project is associated with a client organization and another unrelated contact from the Contacts table - the salesperson. There is a drop-down menu on the Projects Layout for the contact person from the organization assigned to the project. This drop down list grabs information from the contacts table (a field for the contacts full name) which is sorted by the organization. For example, if Organization A has three project managers Bill Smith, Betty White and George Jones, …

Hello everybody, Reporting from Filemaker.com "When you view records in a table, FileMaker Pro displays data in rows and columns. Each row displays a record, and each column displays a field." And that is fine in most of the occasions...now what if one would like to invert this order ? In other words...would it be possible to set the layout (or data) so that each row displays a field and each column displays a record ? In particular I can very easily obtain something like this: Exam Date Field1 Field2 Field3 1 Jan A A B 2 Jan B C D 3 Jan E F G But would i…

I'm sorry for asking this question, as I know it is in the help section somewhere. I just cannot seem to find it. How do I set up a field so that's when I enter data into it, it always goes back to the font I use in my database? Currently, if I paste something with a different font, the fonts that was pasted remains. I want the font to resort to the default of the program. Thank you very much for your help, Fed

Attached my little code snippet and alarm layout.. I have 2 buttons to accept or postpone this triggered alarm... I want to ring a bell sequence, to recur over & over.... until.... maybe as an option.... For waking up operator not near or at their desk.. possibly sleeping on the job! To perform the alarm action.. How might i do this... TIA rod

I seek help on various forums from time to time but this time I'd like to give back. I had been seeking a solution to integrating Skype into a database for the purposes of dialling phone numbers or initiating Skype-to-Skype calls or chats, and got so far with it but it wasn't working cross platform. Various tips on other websites helped along the way, but I couldn't find a fully documented solution for cross-platform integration. Perhaps I didn't look hard enough, but a few weeks ago, I figured it out and have two scripts (one for dialling phone numbers and one for initiating calls/chats to a Skype name) that work on Windows, Mac and iOS. I have finally got around …

Hi guys, Hopping some can help and if what I am trying to do is even possible. I have a database with three tables user, project, project notes. I have one layout where I have a portal that lists all the projects (works fine), when I click on a project (using show related record) it show the details on the project as well as a list of notes of the project on another portal (works fine). My problem comes in when I click on a note from the notes portal it gives me the following message: " this operation could not be completed because this layout cannot display the result." I'm attaching a sample database. the error is on the "projects" layout with…

Hi, Im sure many peoples facing this problem. we will get the alert message by editng the particulat record when someother user doing the edit with the same record on other layout. Please tell me the possibility to modify the single record more than one user on multiple layout at the same time? I hope it could be possible to stop other users and do the edit. Thanks in advance.

I took over an FM12 database and found a button ( see enclosed attachment ), when in layout mode, with a blue line down the left side and was wondering if someone could tell me what it is? I could not find anything in the help.  Dom

Just like in a date filed you can have it that you click on the data entry box and a calendar pops up, from which you can choose a particular date, in a number filed, is there a way to get a calculator to pop, so you can calculate the value you want to put in the data entry box as a plain number?

Hello I have a subsummary report with a main group and subcategories. Some main groups only have one subcategory which is the same as the main group. Other main groups have up to 4 subcategories. Is there a way to hide the subcategory line for the groups with only one subcategory which is the same as the main group? If it were a pivot table in Excel I would just close the row. Thank you

Is there any way to script the deleting of layouts and tables, or must it be done manually?

Hi, I have searched around as I thought this would have been asked numerous times, but couldn't find what I was after. I have a field that stores a 0 or 1 depending on whether there is a related record elsewhere. The button take you to that related record and associated layout. I want to disble the button if the field contents is 0 (no related record). I thought I might be able to use conditional formatting, but there's no 'disable' option (which would be nice). How do I do this please? Thanks, Steve

I am using FM 12 Adv Since my membership application was started, I have stored the version number as a global, calculation (so that my import will not over write it). As I release a new version, I just change the value of the "Version" field.  Today I updated from version 1.48 to 1.49 and to my surprise even though the Global::Version field shows 1.49, on my layout it says 1.48. How can that be?  Shouldn't my layout say 1.49???  Â

I am using FM 12 Adv. I haven't seen a question about this so maybe I am the last person to get the memo. I have a layout. I have set Status OFF, Toolbar off etc... Yet, the layout still shows the '+' '-' buttons that let the user adjust the 'zoom' Question, is there a way to shut that bottom toolbar off??? Thanks

I have a layout, LayoutOne. I made a duplicate of it LayoutOneCopy. I made changes to LayoutOneCopy, and now I want LayoutOneCopy to be my new default layout. The problem is, all my links, scripts, etc. say Go To LayoutOne. If I rename LayoutOne to LayoutOne-Old, all the scripts make the change. Is there a quicker way to have all the scripts reflect the new layout name rather than going through each individual script and link? Thanks!

I have created several layouts - apparently successfully and they display and work OK - but suddenly, when I proceed to edit the layouts, the theme background and margins are stuck at a position much narrower than the displayed width and and I can no longer drag it to change it. I can drag the length up/down OK but the width is stuck (see attached screenshot) Â This used to work fine but has recently got stuck. Â The layouts still seem to work OK but the editor has this problem. Â Â

Hi there, I have a customer layout in my solution. there is a button to create a new customer. All was working fine, then just recently, wWhen clicked it inserts a random address, city and state. These are not calculated fields. Just started. Dave

hello im still confuse how to use smtp can some give me a sample layout how SMTP works and send email with attachment

I'm used to seeing the icons in Filemaker and know they each mean different things (coffee cup, spinning beach ball mean the server is busy, hourglass or butterfly means something is busy on your local machine). But recently, I think since switching to FileMaker 12, we also get icons of double headed arrows -- sometimes pointing both up and down, sometimes pointing both left and right. What do these mean?

I am trying to create a scenario whereby a check symbol (Container field) appears when the result of a calculation in a subsummary part is true. I have the check symbol field: g highlight, container, global I have a calculation field; container, The calculation is: when x - y ≠ 0; g highlight; "" (x & y are summary fileds) I have inserted this field into the subsummary line. It does not function as hoped? Is it because this calculation is in a subsummary part? Are thoughts? Thanks

Lots of real estate is wasted on field name labels, especially in iOS. I'd like to see the field name label UNDER the field and visible only in Find Mode; in Browse Mode, the field data in this particular solution is self-evident. This is not what I want: I've been experimenting with conditional formatting with only frustration; I think I want a format that depends on the view mode but we don't have it. And, I've downloaded examples of solutions that others have designed, including the starter solutions, but haven't seen a resolution. Instead, lots of wasted space: Â I wonder if anyone else has resolved this?

Hi everyone please help me i have a text field containing "my 18th birthday" i want this to convert in "my eighteenth birthday" thank you

Hi.. Sometimes i might have a larger width dialog log... once done... then all my dialog boxes are that large size.. even if FM is restart... Thanks

Why - when using a drop down list and selecting a value in the list - does the cursor automatically go to the next field? Go to next object - nothing is selected for the field.

Why sometimes when I make a change in the graph or definitions and when I leave, does it say it is making changes to the layouts and it seems to go through every layout in my file even if it isn't even related to a table I changed? It is very slow. And it says I can skip it but it gives no indication of what it will mean if I skip it. It is very unfriendly with no message and no way to look up in help what it even means. Can someone tell me what it is doing and what it means if I skip it? And if wrong place my apology. It seems to happen when I access remotely and I wasn't sure if that might be why it is asking me. Even idea of what it is called so I can search?…

Hi, Â I've created a layout that uses 2 images to act as buttons running scripts. The problem I have is that the bigger my database gets the slower it is to navigate and it's due to the images. Â I've attached a screen shot of my layout. The images are on the far right of the body section. They're just very small jpgs. Â I'm guessing filemaker is loading this image for every row (rather than once and repeating) so does anyone know of a technique I can reduce the load I'm putting on the file? Â I've set up a few filters to reduce the list to the most recent/relevant records but it can still be a bit laggy. Â Using Filemaker 11. Â Thanks, Chris

I have created a sales summary report layout for my DB and the totals are working great, but for some reason, the percentages make no sense. This is a sub summary on two fields (Account Rep and Job Type).  The Total Sales Amount column is a summary field based on the Sales Amount.  Currently, the percentage is a calculated field based = Sales Amount / Total Sales Amount.  Basically, I want the percentage to be the percentage of the 4th column compared to the grand total at the bottom.  What am I doing wrong?  (Report is attached)  Thanks, Ryan Â

Windows7, FM-Adv, ver12.04 Why is it, when my mouse rolls over a hot spot, button ( causes the hand to show) then if i move the mouse pointer off that hotspot, (even roll it to the other side of the layout) it doesn't release the rollover hand until a click Seems like it should release the hand image when i am off the hot spot area TIA

I have a layout that displays "Job Notes" for historical review purposes. It is read only. The problem that I have is if a note contains a really long text, the user cannot see it all. What is the best way to display all of the data without having to create ridiculously large edit boxes? Most of these are one or two lines, but sometimes they put in a lot of text. An example is attached. Â

Someone tell me I'm not crazy, please, I just upgraded to FM 12 and am frustrated with reducing a body and/or subsummary part. If I go too far (in reducing the size), it deletes the entire part! What? I have done this several times now (and of course, can't get the part back) and would like to know if anyone is having the same problem and/or if there is a solution. Sometimes, I really want my part to be all the way up to the bottom of my fields and/or text, but don't feel like I can do this anymore. argh! thanks for any validation

Hi there, I am using Filemaker 10Pro and hit a wall. I created an invoice layout that works great for all my needs. Now I needed to add a deposit field to it that can be subtracted from the total invoice. All i did was add a new field called deposit (number field) then created an additional calculation field to subtracted it from the total to create the final invoice field. Seems simple enough. The total invoice and deposit field are both in the same table so there should not be any linking issues. The problem is I am locked out of the deposit field and cannot enter a number into here. It has to be something basic that I am missing. Any help appreciated. Thanks …

Hi guys -- I've FM 5.5v1 running on Mac OS 10.6.8. On one of the databases, everytime I created a new field FM would automatically enter it on the Table view but some weeks ago it stopped doing it. The database is around 90 fields so it's not too large. Does anybody know why and how to fix it? Best!

Is there a way to have more than one line and wrap text in field titles in table view? From what I gather I will have to change the height of all the cells in the table, instead of only the field titles, which is rather disappointing.

Is there a way to go to an object when in layout mode using only the keyboard?

I am trying to copy a few layout fields from a tabbed layout I have to another blank layout, but instead of fm only copying the selected form fields, it copies the whole tabbed interface, every single tab, including the current one, and including items not selected. Is this a bug or am I doing something wrong?

I can't find where to adjust the height of the body. I know I can drag that tab or its bottom line but I need precision. Where are those numbers stored please? I thought it would be inspector position but when I adjust body height, that number stays at 0. I am missing something basic I think. What stumps me is that I can see the height in Inspector but it won't let me access it. New to FM. Thank you for being patient with obviously silly question.

I'd like to know if there is a way to generate a window identifier. My goal is to be able to open two identical windows and then have conditional formatting or calculated fields appear differently to the two windows according to selections made by the user. If I use conditional formatting based on global fields then they will be set across both Windows. Addendum: OK. I did find this post, which talks about using a custom window title, which I've considered. That's a little messy.