FileMaker Interface Features
-
I have 3 tables: Designer, Styles, Messaging The Designer table has a portal containing records from Styles matched by DesignerID. StyleID goes from Styles to Messaging, and in each record in the Styles portal on the Designer layout, I want a portal displaying the matching records from Messaging. However, currently, the second portal shows ALL the records from the Messaging table, as opposed to the ones associated by StyleID. Any help would be greatly appreciated.
-
- 7 replies
- 1.3k views
-
-
In a container field, is there a way to have a single page PDF display as a image on a PC as it does on a MAC. The benefit is the PDF is vector so printing is very sharp and file is small.
-
- 2 replies
- 1.1k views
-
-
I wasn't sure where to post this so please forgive me if it would have been more appropriate elsewhere. I have a simple report that I created using FM 11 advanced. The report is on a dropdown from the layout menu. When I view the report is contains all the proper formatting. When I place the databse on the server and the endusers view the report for formatting is gone. Any idea why this might happen?  My view that has formatting is the attached file named HomeCenter.jpg  The image the endusers view is attached and named HomeCenterNoFormat.jpg  This is my first stab at creating a report so it is extremely rudimentary...  Any ideas on why this is h…
-
- 3 replies
- 928 views
-
-
Hello Everyone, I am having global repetition field with value list. While change the value it is reflected in all the place where i placed the field. I would like to do the same process using custom function or else using let function. Can i have any example?. Kindly guide me. Else if there is any alternate way kindly share with me. Thanks, Jeeva
-
- 10 replies
- 1.1k views
-
-
I am using FM 12 adv v01 Is it possible to design a menu and then 'group' some menu items by separating them from other menu items by using a special menu character like '-' ?? ( I tried "-" but FM took that as descriptive text and produced an error) thanks Found it. There is a 'separator' choice in menu creation. I over looked it. As usual, after I post a question, I find an answer....
-
- 0 replies
- 1.7k views
-
-
Hi. I am looking to "grey out" a screen as I bring up a custom dialogue box. I have tried to achieve this by having a dummy field covering the whole screen that is normally transparent (no fill), upon opening the custom dialogue box, I set the fill (through conditional formatting) to be 50% grey. For the most part it works, but what happens is that on the main screen is a tab control box, and this seems impervious to this method - even when the dummy field is brought to the front. Can anybody offer an explanation, a fix, or an alternative method to achieve this? It's purely aesthetic. Thanks, Greg
-
- 2 replies
- 1.6k views
-
-
Hi all, I have a script that performs a number of find request and the last request I want to limit to the first row of a portal only. At the moment the script steps are: Go To Field: (selects the field in the portal) Go to Portal Row [select;First] Insert Calculated result( Enters the request data) Perform Find. I have tried moving the Go to Portal Row to the third step but get the same result. What am I doing wrong ?
-
- 5 replies
- 1.1k views
-
-
I have an employee logging in via web publishing to do some scheduling. I have inserted a web Viewer with our gmail account as the URL.... but nothing at all shows up. Other websites work, but gmail, google search or it seems anything to do with google doesn't show - just a grey web portal. Any ideas? Thanks so much and have a great day
-
- 0 replies
- 1.3k views
-
-
Hello all I am in the process of creating a contacts database with 2 layouts (CONTACTS and DONATIONS). On the CONTACTS layout is a portal which shows the data from 4 fields - Donation Date, Donation Amount, Receipt Number, Donation Use - from another layout (called DONATIONS) in the same database. My request What I am looking for is a button called "Add Donation" to be placed on the CONTACTS layout next to the portal which, when clicked, takes the user to the DONATIONS layout and creates a new (donation entry) record. Here the user enters details to 4 fields - Donation Date, Donation Amount, Receipt Number, Donation Use - that are included in the portal on th…
-
-
- 7 replies
- 1.4k views
-
-
Hi, I think I must just have some weird setting in place but I can't for the live of me find it. Every time I set a number field to display as a percentage it shows it as a percentage times 100. For e.g. If the number in "general" format is 40, and I set it to percentage it changed to "4000%". It's clearly only a display issue, as if I change it back to general it displays in the original format. Anyone have any idea what could be causing this? I've tried the same thing in a new database with the same result, so I assume it's a preference in FileMaker.
-
-
- 9 replies
- 7.2k views
-
-
I am running FM 12 v 1  There is a table: Patient There is a table: Doctor     PKDoctorID, DoctorLastName etc... There is a table: Procedures PKProcedureID, FKDoctorID, ProcedureName etc...  On the Patient layout there is the Procedures portal.   The procedures portal has FKDoctorID.  Here is my question: "When the FKDoctorID is defined as a popup, the DoctorLastName shows. When it is defined as a DropDown, I see the PKDoctorID ---- Why the difference?) Â
-
-
- 4 replies
- 1.5k views
-
-
When I go into layout on filemaker 12 the screen looks like graph paper was put on top of it with tons of boxes. How can I shut that feature off. I can hardly see the names of my fields. Thanks. Mike
-
-
- 2 replies
- 842 views
-
-
Hello folks! I apologize if I have stuck this in the wrong thread, but this seemed to be the best "fit". Move as necessary. I picked up FM on the recommendation of a friend to use on a project that I am involved with. I have found FM to be pretty easy to use, and I "think" I have laid the majority of the groundwork for my project. That being said, I've found that my lack of a proper working FM vocabulary has made searching for answers impossible. So, I am going to list a few of the features/goals I would like to implement, and maybe some of you could give me a better idea of what to search for. I don't expect explicit instructions, but they're always appreciated. …
-
-
- 20 replies
- 1.9k views
-
-
Hi all,I am struggling to find a means of showing the notes against a particular portal record by scripting the field to show in a related table when a portal record is selected. Affected Tables Installations Table Client Table Notes Data table Relationship that joins these tables is Client_No While in the Installation Table, (Installations Contact layout), I want to create a note in a portal from the Notes Data table which dates the note and have a separate Notes Field at the side of the portal into which the notes are entered for the selected portal row. I then want to have the note relevant to the portal row displayed when a button is selected in the desired Port…
-
- 4 replies
- 1k views
-
-
Hope this is possible. I have a layout with a bunch of fields and I need to be able to lock the fields so they can't be modified. Can this be done with the script trigger OnLayoutEnter using a field from the table that if > than blank lock the fields, or do I have to do this field by field. Thanks
-
- 3 replies
- 957 views
-
-
I have a school administration application. On a Staff page that shows a Teacher's record, I have two portals. On the left, the portal shows a list of the Courses taught by that Teacher. Clicking on one of these portal rows displays the Students taking that Course in the right portal. A button next to the Student's names takes the user to a screen where he/she can enter the Student's grade for that Course. My problem: on returning to the Staff page, I've lost both portals' focus (they've both returned to line 1). I've tried saving the portal rows, both as global fields and variables, but these both seem to be "automatically" changed (ie not under control of a SetField or …
-
- 5 replies
- 1k views
-
-
I am using FM 12 Adv v 1 (v3 is too buggy) My app, when running in Windows has this characteristic: If the user 'maximizes' the FM window and then maximizes my app window, when the app opens a new window, it causes the app window to shrink to it's "pre maximized" size. Specifically, in debug I can see that it is the New Window ["Reset Setup"; Heigfht: 10; Width 10; Top 3000; Left 3000; Style Document] command. Any ideas? Ron Update: I figured out that right before the Reset Setup window is opened, I collect $height, $width, $left, and $bottom and then after the Setup window is finished, I go back to the main Membership window and 'resize' it accor…
-
- 1 reply
- 821 views
-
-
Hi all to frame my problem i have patients that may have varying numbers of medical procedures/histories. I can easily make a portal from my main database table to a child table using the patient ID as the related field. This allow me to enter in the medical history for that patient using a portal rather than a repeating field. however to make this UI nice i would like to have one portal that is used to enter new records (histories) displaying only one row "ie the new one" and one portal below it that display the histories already entered for that patient (standard portal with scroll bar type look) Any ideas how i would go about doing this? Many…
-
- 4 replies
- 1.5k views
-
-
I want to create a value list from the records in a table. I also want to add the value 'All' to this value list as it will be used in a filter selection. How do I achieve this?
-
- 1 reply
- 979 views
-
-
I have a portal that all of the records are showing the same information as the first record. The table holding the portal is called Vendors, and the portal is built from Purchase Orders. When a purchase order is added some of the fields show the data from the first record, such as Image, date, etc. However, some show from the correct information. I've noticed that the fields that are being repeated are ones from a related table Styles which is related to Purchase Orders through Style ID. I don't really understand why this happens?
-
- 8 replies
- 864 views
-
-
Hi, I saw an example a couple of years ago in the forums but can't now find it again I know I can filter a portal based on a global, but can't work out how to show all. i've found things about putting a calc field "all" & ¶ ... but it seems this when the global is set by static value list ... my global is set from a dynamic TO I'm presumeably missing something I think the original example had something like filtering sales based on (US) city and 'show all' obviously took off all the filtering thanks cate (still on FM11 in case FM12 has some advancments)
-
- 1 reply
- 748 views
-
-
This is probably going to end up being embarassingly simple, but for now it escapes me! In reading the FTS 11 book, p. 4-29, it comments how with drop-down lists, using the show-second-field only option, that after the selection, the original value (usually a keyfield) is the one that shows. It suggests using an non-enterable opaque related field that contains the values displayed as the second field in the value list. Users clicking on this field would activate the hidden field formatted as a drop-down list, make selection, and after exiting, see the data in the second field rather than the stored key itself. My question is, how to do this? How does clicking in o…
-
- 3 replies
- 1.5k views
-
-
I've set webviewer up to display pages that require an SVG viewer to display images within the web pages. The images are blank within webviewer but display perfectly in Internet Explorer. Is there anything that can be done or do I have to abandon this idea? Thanks in advance.
-
- 0 replies
- 1.7k views
-
-
I'm a Mac FM developer, with limited experience on Windows, designing a db for a client on Windows 7 Enterprise. Currently, I'm developing on my Mac and then porting it over to a Windows 7 laptop for testing (FM 11.0v2 for both). I've encountered a weird scrolling issue that I can't seem to resolve: In Browse mode, I have a layout that extends down past the visible window space, and so requires some scrolling to see the bottom half. On my Mac, I can scroll down normally, using either my mouse or FileMaker's scroll bars (note: I'm not referring to the optional scroll bars for fields or portals, just the standard window scroll bars). However, on the…
-
- 10 replies
- 5k views
-
-
Hi All, I am trying to use some foreign characters in one of my fields. The problem that i am facing is that the tool tip is not showing these foreign characters. Instead it is showing blank boxes for these characters. Please help me in resolving this issue as i am stuck for 2 days. Thanks, Imran
-
- 7 replies
- 5.1k views
-
-
I have two examples where I would like a result and I've never been able to figure out a good way. Some of you are incredible on reporting so I want to check in for ideas please: 1) Can same report be used with or without a body? I create reports with many leading parts and then by sorting, it only groups and summarizing those parts. This is a great way to use the same layout for multiple reports. But if someone doesn't want the body, it seems I must duplicate the report and delete the body and maintain the two layouts. It doesn't sound like a big problem but I would rather keep it lean without the duplicity if possible. 2) Along those same lines, I have ma…
-
-
- 11 replies
- 1.6k views
-
-
I use a text box 'I declare variables' placed at the top of a layout and the bottom of the stacking order to declare variables that I display as merge variables. The technique was mostly pioneered by Comment and Mr_Vodka and now it has become one of my favorite techniques. But 12 does not respond as 11 does in this regard. Two files attached (11 and 12) - created in 11.0v3 (Windows XP SP3) and then dragged to 12 icon. 11 refreshes without script ... 12 requires a Freeze Window to force the refresh. If anyone is using conditional formatting with merge variables in these various ways, this is just a caution that it may require an additional refresh technique that w…
-
-
- 19 replies
- 2.6k views
-
-
Hello, Hope some is able to help me out here. I run a business, of which I track almost everything with File Maker. Is what I want to be able to do is take all the invoices from 1 month, add up the total and display that, and also be able to display the total number of sales for that month. I then want to put this onto a graph. They way it is setup is we have used the Invoices starter file, and then heavily adapted it from there. I have created a new table to store this information in, and create the graph from, but not sure how to go about adding the data and getting it in there. Thanks Sam
-
- 1 reply
- 1.4k views
-
-
This is annoying... an in focus text box will not show all its content if a tab oject is in the way ?!
-
- 4 replies
- 1k views
-
-
I have a employee table that has a list of all employees which then have two different fields with radial options 1. active or non-active 2. sales rep or installer In another table i have a popup menu based on the employee records but the list is very large and i would like to filter it based on the field being entered. For example in the sales table i would like to assign employees to the sale, one being a salesrep and also an installer to each sale. In the salesrep field I would like a popup menu that filters from the employee table based upon the criteria (active, and sales rep), in the installer field i would like (active, installer) any help? I added…
-
- 1 reply
- 1.1k views
-
-
The new button states in FM12 are awesome but at the same time they are driving me a bit crazy. I find myself spending a lot of time trying to clear out unwanted settings that are inherited from the theme. Is there a shortcut that I can used to assign the same button state to all of them (e.g., Normal State, In Focus, Hover, Pressed)? For example, if I attach an image to the "Normal State", I want an easy way to auto-assign the same graphic to all of the other states. Thanks.
-
- 2 replies
- 1.8k views
-
-
There is a "Category" field in Browse mode, Table view that I can't find in Layout Mode. I didn't make the database so I don't know how to find the field. I need to give it a drop down list, so please help me find it!
-
- 4 replies
- 1.6k views
-
-
Maybe I'm missing something totally obvious here, but why do the fonts behave so differently in MacOS and Windows with regard to styles (bold, italic). On a Mac you'd choose a separate font face such as Arial Bold Italic for example which on Windows in the same database is going to be rendered as just plain Arial. On Windows you have to select the "i" and "b" buttons to achieve the same effect, however on a Mac this becomes plain Arial with artificial bold and italic effects applied (definitely not the same thing as a true Arial Bold Italic). This totally breaks any cross-platform font compatibility for me beyond using plain font versions. Why's that? Any way to get aroun…
-
-
- 46 replies
- 9.6k views
-
-
Is this possible? Just like the javascript version we see on the net when filling out a registration form. So for instance a text field for inputting your first name would say "Enter First Name" in light grey, and when you click in the text box the watermark message disappears so you can start typing your name. Can you make this in Filemaker some how?
-
-
- 2 replies
- 1.7k views
-
-
I am creating a contacts database for use by members of my staff at a not-for-profit charity The main screen is the Contacts Layout. On this layout is an Add Donation button which goes to a Donation entry screen where donation details are entered. When these details are entered, the user clicks a button which should return them to the main Contacts screen - with donation details displayed in the portal. PROBLEM: When I am on the Donation entry screen and the Return button is pressed, Filemaker Pro exits. I will admit to a weakness in making portals work, so any help in making my donation entry work correctly is much appreciated. I am using FMP8. F…
-
- 3 replies
- 1.2k views
-
-
Hi, sorry if this has come up before, I've trawled through the posts but can't find a solution I've an Activity table with Date, Time, and Activity fields .. the data is filled in using one layout but I've another layout for printing it and on this print layout I want only the first of duplicate Dates printed and thought using conditional formationg to turn the date white would be a solution (i've used this elseswhere in the program and it works fine as we print only to white paper) at the moment I get 17/5/2012 9.00 checked doors 1 & 2 17/5/2012 9.15 checked doors 4 &15 18/5/2012 8.14 checked doors 3, 4 &5 I would like it prin…
-
-
- 2 replies
- 1.8k views
-
-
At http://www.pricerunner.co.uk/ there is a search form that can be filled in and results display automatically... Is there any way I can get filemaker to open my default web browser and fill in that field from a form?
-
-
- 2 replies
- 2.5k views
-
-
Hello FMForums! I'm a recent convert from Access to Filemaker Pro so I'm still trying to grasp just how different the two platforms are. So please excuse me if I say things that sound weird. I'm working in a layout right now and I'm trying to create conditional formatting to make certain fields visible depending on another field. It's a little tricky though, the source field draws data from a Value List and is set to function as a Checkbox Set. Basically what I have is a day selector, I'm setting up whether this particular task is done on Monday, Tuesday, Wednesday, etc... So some tasks are one day a week, others are seven days a week. In my layout I'…
-
- 3 replies
- 4.3k views
-
-
Is there a way to check that a particular font is available at startup time, for both Mac and Windows?
-
-
- 3 replies
- 1.7k views
-
-
I have fields for my Address, eg Address Line 1, Address Line 2, City, Post Code, Country I want to embed a map of this location into a layout. I have tried using the Google Maps feature under the Web Viewer, but it only takes to the Google Map site, and there is only a very small section of the map you can see. I do not need the search bar and such on the left of the site, just solely the map. I've done some research and tried to find a solution but can't really get it to work... Cheers.
-
- 5 replies
- 2.8k views
-
-
Hi I'm trying to create a "pop-up window" so users can select items from and return to the main layout. I also want to save the window location for user convenience, so the next time the selection window is called it'll show up at the same location as when it was closed. I set up a button to call the script that brings the window up and two global fields to capture the window's location when it's closed. Everything is working. The problem I'm having is when the main file is opened. My startup script is simple: -Go to the main layout -If guest account hide toolbars -Resize window to fit The floating window script: -New window called "Item Select…
-
- 7 replies
- 3.4k views
-
-
I have a Go app that utilizes signature capture for placing on some docs that get exported to PDF's. The problem is that if I scale the container field down to fit on the documents the signature is so light that it can just barely be seen. Even when viewed on the layout they are very light. Is there anyway to make the stroke bolder at capture time on the Go? If not, does anyone know of a way to possibly manipulate the captured PNG inside of the container (adjust contrast or something similar). If everyone else's experience is similar I may just send this to FM to look at. Considering that the purpose of capturing the sig would be to place of a form of some ty…
-
- 1 reply
- 873 views
-
-
I have a master layout where I am entering Books and multiple Subjects per book. One book has many subjects. Through a Find on this Master layout, I come up with a subset of records (Books and Subjects) that I need to run a Report on. My Report is another layout where I want to use the Found records to show each Book and its related Subjects. Each layout works perfectly by itself, but using a Button on the master layout to go to the Report (using GTRR or Go To Layout, etc.), the Report isn't using the Found set. How do I get the Report layout to use the records I found using the Master layout? Thanks in advance for any help. While Filemaker is not new to me, t…
-
- 6 replies
- 1.6k views
-
-
Why can't we have tick boxes? Every other app I know uses them... my boss wants them... even the setting in the Filemaker app uses them... why can't we have them!?
-
-
- 10 replies
- 2k views
-
-
I'm looking to implement drag and drop sorting on a portal but running into a problem. On a large portal where you scroll through the records, you cannot scroll while dragging an item. I'm thinking if there was a way to do this, Excelisys would have included it in their example. Anyone experience this problem before? Code example, http://www.excelisys.com/demos/Drag-and-Drop-Separation-Model-12.zip
-
- 0 replies
- 831 views
-
-
I'm stuck on this issue and not sure how to describe in a search so here is my post. setting up a new layout (see layoutmode.jpg), all the fields are arranged nicely and are perfectly sized. Once I switch to Browse mode (see browsemode.jpg) everything is stretched out (it seems to be 100 px long vs 19 px as it is setup in layout mode). Also, everything looks like it is stretched the exact same length (despite most fields being set to 19 px). As a test, I tried changing the A_t_ID_Folder field to a height of 200 px (it is identified with "RP120" on the top right of the screen of the browsemode.jpeg screenshot). And as you can see it is …
-
-
- 3 replies
- 1k views
-
-
I have tables like this: Grand-GrandFather-----GrandFather-----Father-----Son-----GrandSon How could I do a report to show me all the structure like?: Grand-GrandFather 1 GrandFather 1 GrandFather 2 Grand-GrandFather 2 GrandFather 1 GrandFather 2 Father 1 Father 2 Father 3 Grand-GrandFather 3 GrandFather 1 Father 1 Father 2 Son 1 Son 2 GrandSon 1 GrandSon 2 Thank you.
-
- 4 replies
- 1.1k views
-
-
Hello everyone, First, thank you for taking the time to read this plea for help. Second... I am using the Estimates pre-made template in Filemaker Pro 12. On the estimate detail screen there is a portal to Estimate Data. There is also a button that will delete the specific portal row. I want to create a button that will duplicate the portal row. I've read others writing about bad data management, but the case is that I may have to order 5 variations of an item and I don't want to have to enter it in 5 times. I'd rather just click a button 5 times and create 5 portal rows and then make notes about the differences in the notes field I added. I've tried a numb…
-
- 2 replies
- 3.1k views
-
-
I have set a button up on a field to go to object and specified "photos" in my case but it doesn't work. I have named a field on the tab I want to go to "photos" in the inspector. Don't know if this is relevant but where I want to go to/from are on different layouts and tables. Am I missing something simple?
-
- 2 replies
- 2.4k views
-
-
Hello All, I have a portal with a global field that filters the portal. I have been trying to figure out how to create a field that shows the number of records displayed in the portal rather than just the number of records related by the portal. I've tried various ways but it continues to show the number of related records, and does not change when I filter the portal. Any guidance pointing in the direction of a solution would be much appreciated. Thank you
-
-
- 2 replies
- 982 views
-
-
HI, I'm looking for a resource, website, company, individual that is very very good with layouts. Not the structure of a layout but the look and feel of a layout including the overall user interface. This is for an existing application in FMPro that is ready for wide scale distribution in a major renewable energy company in North America. Staff must use it and at some point down the road, we would like to arrive at a snappy user interface to go along with it. This is not a posting for a job, but a fishing excercise on my part to see what/who is out there. This aspect of the software has been 'neglected' as it's only had three users in it's 10 year life. Suggestions are a…
-
- 4 replies
- 928 views
-
-
Hello What is the best way to keep a floating document window on the same record as it's launch window when both windows are based on the same table? Also, is there any way to get the Floating Document Window to work in an expected way with Windows 7? It does not seem to be possible to work in both the floating window and the main window with the main window maximized and the floating window kept to specific dimensions. Thank you
-
- 10 replies
- 2.7k views
-
-
When you preview you can copy to grab a screenshot of the page being previewed. My portals aren't copying. Is that just how it works?
-
- 5 replies
- 1.2k views
-
-
Hi everyone, thanks in advanced for your help. I want to go to a specific tab when the word "anticipo" is included in a field. I mean: I have the field "Name" and in the same record, I have two tabs called "anticipo" and "Date". I'd need that if the value of the field "name" is, for example, "John Anticipo Martinson", the "anticipo" tab be shown. If the name is "John Einstein" (and it hasn't any "anticipo" in it), the "Date" tab be shown. I set a scriptrigger on tabswitch: if [PatternCount(name; "anticipo")] go to object [object name: "anticipo"] else go to object [object name: "Date"] end if But when I click in the wrong tab, the wrong tab is …
-
- 3 replies
- 2.6k views
-
-
I have a table relationship between..... MeasurementChart and (TO) MeasurementChart_Defaults_List_Gender_Customer MC_STYLE_GENDER = MCDL_GENDER and MC_ID_CUSTOMER = MCDL_CUSTOMER_CODE and MC_WORD_RETIRED != MCDL_USAGE MC_WORD_RETIRED will always have "Retired" as a value, automatically entered when user creates a measurement chart. MCDL_USAGE can either have "Retired", "Current", or be blank. My drop down value list is located on 2 layouts which are based on MeasurementChart. The value list itself is based on the Defaults list and is set to "Include all Values" and "Show only values from second field". My question is does the "Include all …
-
- 6 replies
- 1.5k views
-
-
Hi I hope someone can help me with this issue, Since Runtime solution is not network possible and i need to do a Kiosk Solution with the possibility to get information over network Ok so i will have to install a filemaker pro package in all my clients, but how do I Remove the scroll bars from layout in windows and go to fullscreen Or I am missing something here Please Help Thank you Walter
-
-
- 1 reply
- 3.4k views
-
-
I am trying to have a portal with records that contain a container. This container is to store either a video or audio file, and hence I am trying to use the enhanced interactive features. However, the container seems to stop working when put into a portal, outside of a portal it works fine, but inside I cannot even add a audio/video file to it. Has anybody come across this before? Cheers.
-
- 0 replies
- 723 views
-
-
I'm in the design phase of a database and have a question. I'm not sure if portals are the answer so this might be in the wrong place. My situation is similar to a dictionary: some of the larger dictionaries will have a discussion attached to a word definition, showing how a word and its similar words vary and how to use them in different situations. Example: take the words 'strong', 'secure', and 'impregnable'. Each of these has a record that defines the word. But each record also includes a discussion of the differences among these words and how you would use them in different connotations. How would an FM layout be constructed so that the discussion (which in…
-
- 10 replies
- 1.6k views
-
-
I have a report that is grouped and sorted by a sub-summary field. However, some of these sub-summaries cross the page boundary and half the data is on one page and the rest on the next. Now, I do not wish to start a new page with every sub-summary, as each one is only a few lines, but if it is going to break the page, is it possible to just move that sub-summary to the next page?
-
- 1 reply
- 760 views
-
-
I have a field in a portal that I wish to filter by, let's call it Time. Time may be 8am, 9am, etc. I have created a field called FilterTime, which contains values: 8am, 9am, etc. etc. and displayed it as a checkbox set across the top of the portal. Obviously, I want the records in the portal to display when they match the selected filters. I have the filter set up to filter records as shown: If ( IsEmpty(FilterValues(Items::Time; Protocols::FilterTime)) = False; 1; 0) This works fine. However, I also want an 'all' field in the filter, which will display all the times. Evidently, the filtervalues does not return anything because there is…
-
- 2 replies
- 1.1k views
-
-
I am using FM 12 Adv I have 3 fields: [startDate] [EndDate] [Duration] Duration is a calculated field that subtracts StartDate from EndDate and if ENDDate is blank, substitutes get(CurrentDate). This works. Problem: If [startDate] = October 20, 2012 and [EndDate ]="" then Duration = 3 days ... ok ( [EndDate] uses today's date.) But, when I start the program tomorrow, it still shows 3 days when it should show 4 days. Question: "Is there a way, withouot creating a layout with the 3 fields and looping through them to update them, to 'refresh' the calculation? I have tried going to the layout and doing a 'refresh window' and 'commit recor…
-
- 3 replies
- 1.4k views
-
-
I am using FM 12 Adv. This button is composed of 3 parts: "Add Patient" text, a + graphic and the green rectangle. I 'grouped' all 3 together. I decided to add some 'custom style' to this button. I choose yellow for "In Focus". The problem is that when I put the focus over the button, each of the 3 elements 'lights up' as I pass the mouse cursor over it. Question: "Since all 3 elements are grouped as 1 element, shouldn't the Custom Style apply to all elements as if they were one ? Thanks Ron
-
- 2 replies
- 1.4k views
-
-
Hi all - haven't been in for a while, but new job - convinced them FileMaker was the way to go; so a new database to build... I have a tabbed layout with a number of levels (each contained under a top structure of tabs - Time 1, Time 2, Time 3, etc) containing a total of nearly 500 fields at time 1 (and drawn from a Time 1 table). As mentioned I then have multiple time points (30 in all) that contain the same information (just the next time point along). To create the different time point fields I can (for example) duplicate the Time 1 table (and rename it to Time 2 - it does not matter if the time 2 fields are the same name as time 1 - I can easily take care of…
-
-
- 9 replies
- 1.2k views
-
-
I cant believe Im actually asking this question...Im using FM since donkeys years and have developed 6 billion dbases but this simple thing escapes me...it must be too simple thats what it is anyways here goes: I have a file with a portal. So far so good? That wasnt complex was it. Now, in the portal I have one field one each line/record in the portal. The field is called TempText. (ie the portal table has a one single simple field in it). HOW do I search for all the records that have the word HELLO in one portal line AND the word HITHERE in another portal line AS WELL? If I do strg-F im in find mode, I can type HELLO into the first portal row but …
-
-
- 6 replies
- 1.3k views
-
-
I have web viewer showing related info to the current record. Can I create a hyper link to: 1. a related record. 2. trigger a script.
-
- 1 reply
- 1.3k views
-
-
Hello, I have a database with seven tables. One of my tables loses its background color when using list view. I looked at all of the other tables but could not find a difference. Pics are attached. Can someone tell me why this is happening? FileMaker Pro 12 Advanced. Many Thanks!
-
-
- 4 replies
- 1k views
-
-
I have a field where people need to enter either a project name, or if it's not related to a project, they need to select from a list of non-project related choices. The project list comes from two fields (project number, project name) in a separate database that houses all of the projects and other project-related information. The non-project related list will be a static value list. There is a checkbox that the user should check if the request is not related to a project. If the box is checked, the value list should be the static value list from within the same database, but if the box is unchecked, the value list should be the list of projects directly from the…
-
- 3 replies
- 1.2k views
-
-
I am looking at a database that I will be reworking, but I have come across something I have never seen before. In the Manage Layouts window the icons have a star sort've icon. I am unsure what this means? I've attached a screenshot. Nevermind, I've figured it out - When a layout has a script trigger attached to it.
-
- 0 replies
- 892 views
-
-
I'm trying to come up with a way to allow users to create a list of cascading categories, which will eventually be used to help customers narrow down products on a website. The first two categories are entered for them in two fields in the same table. So they would see the following listed: Record 1: Garage Tools Record 2: Kitchen Silverware When they click on the record 1 ( Garage - Tools), a portal shows them all the subcategories for that record and allows them to add more as needed, such as: Hammers Drills Saws Crow Bars I added a second portal so that when they click on any of the subcategory records in the first portal, the second wi…
-
- 2 replies
- 1.2k views
-
-
I am using FM 12 Advanced on OSX There is something fundamental that I am missing. Here is the situation: I have a 1 to many relationship between Patients and PatientStats My layout is based on Patients My portal is based on Patient Stats I have a popup that displays Patients::_PKMemberID (yes I should change the name to Patients::PK_PatientID) Problem: When I select a popup _PKMemberID, the associated Patient::NameFirst, Patient::NameMI etc does not change? Plus the portal seems to not display propertly. What causes this weird behavior?
-
- 3 replies
- 1.1k views
-
-
Hello, I have a table called "objects" my objects are different from eachother, for example, lights, tables, chairs. I have alot of contacts but I just want to see some of the contacts when I choose lights for example, I know I should use a related value list somehow, any suggestions?
-
- 1 reply
- 1.2k views
-
-
By default in Table view, layouts show a series of fields in the top row, followed by field data in subsequent rows. In my case, that's too much horizontal scrolling to easily compare the data (there are relatively few records, but many fields). Is there any way to transpose the layout so that fields run down the first column, with data shown in additional columns to the right? I know this is similar to List view, but List view only shows one column for data, not multiple data columns.
-
- 2 replies
- 2.3k views
-
-
Hello FMForums, I have a question in regards to creating a layout that lists a series of type. Let's say, there's a Table for a Type and there's another table for Stamps. In relation between the two tables, one Stamp is labeled as a certain Type. Is it possible to create a layout having the Type as the main table and then what happens is, I will have a Type, followed by a list of stamps that has been designated/labeled as that Type? (For example: Similar to a sub-summary or would using sub-summary be the best option? Thanks, scchoi
-
-
- 1 reply
- 672 views
-
-
I have got stuck with my database and need some advice. My database is for a charity which does school presentations. School bookings are taken for a given date, particular school and a selection of presenters do the talk. I have set up a demo with the many-to-many relationships and portals in the booking layout. Subsummary Demo file.fp7.zip I need to generate end of term reports with summaries of team activity. Therefore the layout includes summary data from the bookings table, schools table and presenters table, and I have put fields on a subsumary part by term. I have given the specific info needed in the demo. e.g if schools or presenters do more than o…
-
- 0 replies
- 796 views
-
-
Hi, I have a portal that needs to display machines not active on any maintenance plan in a many-to-many relationship. The tables are (I did not include all fields, as they are not needed): tblMachines: MachineID Serialnumber ProductID .... tblMaintenanceContract: MaintenanceContractID Active EndDate .... tblMachinesMaintenanceContract: Identifier MachineID MaintenanceContractID Active .... tblMaintenanceContract can hold many machines from tblMachines. A machine can only be active on 1 maintenance contract on any given time. A maintenance contract that are not active can not hold any active machines. In the portal I …
-
- 0 replies
- 863 views
-
-
Hello to all I Have a layout that is sorted by CIty's in the sub summery i what to have a filed that will influence records that are onder them. Can It be done. i did a the prblem that i see is if a have a global filed in the i put in the sub summery and when i enter what i want to that filed and run i script it work fine the prblem that I have is that the user will see the data in the global filed in all the sub summery lines. Thank You Dani
-
- 4 replies
- 957 views
-
-
Working in FileMaker 12, Win. We have set up custom menus with limited choices and made it the default for all files. There are 9 files in the solution, hundreds of layouts and there are two accounts that I want to use the full menu set. I have created a script that checks the account name and runs a script with the install menu step as needed. Each file has a copy of this script. I have set the script to trigger on OnFirstWindowOpen and OnWindowOpen in the File Options menu. The change seems to stick for awhile. Entering find mode and performing a search seems to be one event that will cause it to switch back to the file default limited custom menu. I don'…
-
- 1 reply
- 2.5k views
-
-
I want to modify a delete portal row script. When the enduser clicks on the delete portal row button... I want to evaluate the value of Field1 the selected portal row. If the value in Field1 = the value on the context page called Field2... clear Field2, and delete the portal row, otherwise, just delete the portal row. now, after the appropriate portal row has been deleted, if the result is that Field2 value IsEmpty perform another script that prompts the enduser to assign a new value, but allow them to cancel if they wish.
-
- 10 replies
- 1.1k views
-
-
Hi, I'm trying to figure out how to get the information I want in a portal field... I have three tables in my database, A, B and A_join_B My relationships are (B is in the relationships graph as both "B" and "B_alt"): A.id = A_join_B.A_id B.id = A_join_B.B.id A.id >= B_alt.min_A_id Anyway, what I'm after is the following: My layout is of the A table. I have a portal pointing at B_alt, but, as a part of this, I want to have something in each portal row saying whether B is linked to A through A_join_B. Any idea how I could do this? Can I create a calculation field in B that will come up in the B_alt portal rows? I hope this mak…
-
- 1 reply
- 773 views
-
-
Dear All, I'm using FM Server 12 on the server machine, on development machine I use FM PRO Advanced 12 on a MAC computer, I have a very weird issue which is as follows: - I have a layout that has a portal to show records from another related table. - To add a record on the portal you click a button which open a new form to add the new record then when you close this form you just see it on the portal directly. - People access these layout through Remote connection. What's happening that on the MAC machine everything is going perfectly, on Windows machines when they open to add a record to the portal then save it nothing is there all the portal sho…
-
- 17 replies
- 2.4k views
-
-
HI All, I am looking for a tutorial on something that is probably basic, and probably already well documented - I'm just having trouble finding it: I'd like to create a list layout with a drop down box on the top that sets the sort term and re-sorts the layout. This exists in the FM12 "Content Management" starter solution, and I've tried to replicate it here, but I think I am missing something(s). I am working on the layout "Company Loader - Sort List". I welcome any suggestions! Thanks, Jeremy db.zip
-
- 1 reply
- 819 views
-
-
Environment MAC 10.6 with FMPA 12.0v2 I have a situation that works but needs to be refined because its not doing what the user requires. It starts out at style development where a user creates measurement charts for various stages of garment development. The layout(Enter New Chart Name) to create a new chart has 2 drop downs where the user selects a default measurement chart depending on size range and gender. The CUSTOMER drop down should display customer specific charts and the ALL CHARTS needs to display all charts minus ones that are designated RETIRED in the default chart. The default measurement chart table is actually a TO from another DB. Both Meas…
-
- 6 replies
- 2.6k views
-
-
I am looking to create a list layout, in which the user is able to select and deselect which fields they wish to see. And re-size them appropriately. Is this doable?
-
- 5 replies
- 1.1k views
-
-
Sorry, but I wasn't thinking straight. Obvious answer to something that was basic/fundamental. Please delete post!
-
- 3 replies
- 897 views
-
-
Hi all - I believe it was FM10 that introduced the feature where FileMaker maintains the sort order, if the records are sorted, on a layout automatically. So, if you have a window that setup to show records in list view and you sort those records, FileMaker automatically re-sorts when you modify the data in field(s) that the layout is sorted by. I hope I explained accurately. Anyway, I'm using FM11 currently and I'm wondering what effect that feature has on performance if you have 50 people that all have that same window visible all the time. I guess I want to know what exactly triggers that re-sort. Is it possible that all 50 workstations would try…
-
- 0 replies
- 926 views
-
-
Hi I had hoped to make a simple dwindling list to insert a 'number' extracted from list of numbers (a calculation). Obviously it needs to be more complex than i had thought. I have attached a file for info if anyone would like to help. cheers test.zip
-
- 6 replies
- 1.2k views
-
-
I have a report that is broken into sub-summaries. I wish to be able to count how many different summaries there are. How do I achieve this. I tried using count(fieldname) (fieldname = the field that the summary is sorted by) but it always returned 1.
-
- 7 replies
- 1k views
-
-
Hello I what to make a layout list of devices and the user can Select from the list one by a select box of the records. What am i missing here in the attach file Thank You Dani list select.fmp12.zip
-
- 0 replies
- 904 views
-
-
Hi, when i check the option to "allow creation of related records", in a relationship, a blank row will be added to my portal ... what can i do to never show the blank portal row until it is needed? i don't wanna go to another format ... add new record ... then come back to see my new record on the portal ... this cause on an iPad with fmgo an orrible refresh of windows ... can't use conditional formatting to hide the row ... the underground of my portal is transparent ... let it show the underground image. thank you. Stefano
-
-
- 7 replies
- 11.2k views
-
-
i have developed an inventory project using filemaker12 pro. i have facing the problem with custom menus to navigate from one form to another. can anyone pls provide a sample application regarding the custom menus.
-
- 2 replies
- 881 views
-
-
Dear all, I have been through the forum, and I have realised that printing portals isn't great (in my case I have blank fields and can't get the correct headline). My parent table includes 2 portals with data from 2 DIFFERENT tables. I have tried the following approaches: Solution 1: Print the portals: Advantage: I am able to print only the populated lines of the portal, and it shows exactly the data I want Inconvenient: It is very space consuming as the portal lines won't resize. As much as possible, I want my report to stay on one page. Solution 2: Import the related records into a new Print_Table and create a report from this table using P…
-
- 4 replies
- 1.2k views
-
-
We have a solution running in v12. Its a robust solution that is heavily trafficed. Oddly, on one of the machines (running 10.6.8 and FMP 12.2) data is not appearing in a couple of filtered portals. The exact same record and layout on a different machine (running 10.6 and FMP 12.1) the portal data does appear. If we turn the portal filter off the data suddenly does display. The offending filter reads: tic.LIN_Lines~RentalsOnly::zkf_ItemID ≠ 28286 and tic.LIN_Lines~RentalsOnly::_zkfModel ≠ "BSKT" It is filtering out a specific type of line item and product. Is there a known glitch? Any one have any thoughts?
-
- 0 replies
- 800 views
-
-
I have a table called 'Processes' - which holds the steps for completing each 'Process' I have a table called 'ProcessSteps' which are attached to each process. Each process can have many steps attached to it. ProcessSteps has a field called Step #, which I want to have as a value list (values can range from 1-10), but I only want to display values that are 1 higher than the maximum step already assigned (this is stored in a value called HighestStep). I have this working with a new table called Steps, which has all the assigned combinations in fields Step-Value, eg: 1-1, 1-2, 2-1, 2-2, 2-3, etc. My relationship then goes from ProcessSteps to Steps with…
-
- 6 replies
- 1.4k views
-
-
I've noticed a big change in the way FM12 handles larger layout objects in comparison to fm11 in a listview. FM11 prints the whole object even if the object is bigger then the layout section the object is placed in. FM12 doesnt put crops off the layout object to only be visible in the top-most section of the object. This prevents me from using large images, background images, vertical text, certain column graphics etc. I havent read this in the behaviour change list from FMI or saw a forum post, but i might have missed it. Is there any way in FM12 to print larger objects in a listview? Test pictures: Layoutmode fm11 preview mode fm11. Notice th…
-
- 9 replies
- 1.4k views
-
-
I have three small tables People, Households and Households2People. Households contains a numeric field, boolean format called, removeFromValueList. Those households where the removeFromValueList check box is checked should be excluded from the value list that appears on the Households2People portal (from the context of People). I don't where why this isn't working. I have a self join relationship from Households to a table occurance called FilteredTO_Households. The join ties the numeric field removeFromValueList with it's global equivilent through a "not equal to" relationship. The value list uses values on FilteredTO_Households and includes only related values start…
-
- 5 replies
- 1.3k views
-
-
Hi Friends, I am working on a Contact Management / Marketing Campaign Database. At its core is a many-to-many relationship connected through a Join Table connecting Campaigns and Companies. I'm building a layout that strives to collapse a lot of functionality on one screen, called the Campaign Tracker. It shows the records of each company associated with a given campaign with notes specific to each and a portal to each company's contacts. Now, I am trying to add an additional portal that shows all the companies in the campaign. So far, each portal I add only shows the company record i am already looking at, not all the companies of any given campaign. E…
-
- 6 replies
- 1.2k views
-
-
Hoi Guys I have a question. And i can't find the answer... Is it possible for customers of my DB to use there own stationery paper for reports? In email, pdf and print? I like them to be abel to import there stationery one time. And then it will be used in all reports. I included a example stationery Do i have to cut it in 3 pieces than? (header - body - footer?) or is there a better way? thx Tijn
-
- 3 replies
- 1k views
-
-
I have a report, that a field 'Comment' sometimes has many lines, sometimes none. I looked into sliding objects, but it doesn't seem to match what I need - or I didn't do it right.. If the field height has to increase, I only want it to for that record, not for all records, which in turn increases the spacing. Can someone please lend some advice :D
-
- 10 replies
- 1.1k views
-
-
Hoi Guys I have a question. And i can't find the answer... Is it possible for customers of my DB to use there own stationery paper for reports? In email, pdf and print? I like them to be abel to import there stationery one time. And then it will be used in all reports. I included a example stationery Do i have to cut it in 3 pieces than? (header - body - footer?) or is there a better way? thx Tijn
-
- 0 replies
- 768 views
-
-
Hi there, Been searching high and low for an answer but can't find one. Running FMP11 and have set up a product database consisting of two tables related via a number field; the article number. The first table holds all of the information about the item, the second table only holds information about the name of the supplier, the price and stock. The value list is set up as a related value list showing only the values (names) from table 2 (the supplier table). I've created a drop-down list in the supplier field of table 1, and it lists all suppliers found in table 2 perfectly fine. However, clicking any of the values in the list results in nothing.…
-
- 0 replies
- 1.2k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online