FileMaker Interface Features
-
Greetings, I have a section on the Database that i am building, it is going to be used for the Attribs. There is actually 3 tables involved, * Attribs Controler * Attribs Value * Attribs Type Attribs Type: The idea of this table is that it allows for you to enter the type for in this case; * Colour * Size Attribs Value: This table actually holds the values of the Types, so for example; Colour Black Colour Red Attribs Controller: This is just holds the values entered for each of the products. [color:blue]Tables Attrib Controller: Attrib_ID Attrib_SortID Attrib_TypeID Attrib_TypeVal…
-
- 4 replies
- 1.8k views
-
-
Hi, How can I capture in a script whether i'm in Find, Preview or Browse mode? Thanks in advance, Garu
-
- 2 replies
- 1.1k views
-
-
Hi - Is there any way of making the text in a text field show as several columns? The text I'm entering is a medical history - it would be an advantage to have each symptom and main point on a new line, but then to be able to see it all at once I'm having to use a very tall, thin field. It would work a lot better with the layouts if it were a short and wide field, with the field formatted as several columns - a bit like in a word processor you can typically format a text box as having the text in several columns. That way I could see about 20 short lines of info on a field only 5 lines high. I had thought of having a few different text fields side by side and j…
-
- 3 replies
- 1.3k views
-
-
Hi, I have a layout, Client, with 3 tabs. From another layout I would like to come bak to the CLient layout, but to a tab that is not the first one. I know the function GotoLayout, but what should I use to go to a specific tab? Thanks, S.
-
- 2 replies
- 1.1k views
-
-
What would be the best way to create a global? value list? Basically I have a field which will contain same set of values always. The values that can be chosen for the field are: 1, 2, 3, 4, 5 and 10 1 = Brand New 2 = Used-Like New and so on. Should I create a preference table with 12 fields containing the mentioned values and relate that table via fKey to the actual data table and then have the value list get values that way or is there a better, more standard way to do this? I could use a value list with custom values of 1, 2 and so on but I want the user to see 1 - Brand New when they click on the field. After the selectio…
-
- 3 replies
- 1.2k views
-
-
Hey all, We've been creating call sheets for jobs but since moving into FileMaker with all our contacts, its becoming a little complicated to create them. Not that complicated but we'd rather stay in Filemaker and not have to use excel. So I'm trying to recreate the template we use in excel in filemaker in a way that records marked as "callsheet ready" would fill up the template automatically. I'm not entirely sure how I should go about this...I have attached the excel template we use. I'm no pro when it comes to FM so I'm open to any suggestions...I have the feeling FM may not be flexible enough to beat the efficiency of Excel when it comes to moving aroun…
-
- 4 replies
- 1.6k views
-
-
I want to create a help file for my runtime app for my office. It will house alot of info and want it condensed enough to not take up to much space but still be able to scan thru a large grouping of topics. Is it possible to have a list of topics on a layout and when you click on a specific topic it opens up so you can read the info about the topic underneath it and minimizes when you select another topic?
-
- 1 reply
- 1.2k views
-
-
I have a fairly straightforward table (i.e., records appear as a table in View as Table) that sums up numbers in fields using summary fields. The summary fields are placed in the Trailing Grand Summary. In View as List the summary fields display just the numbers that are the sums of values in the displayed records. Unfortunately, in View as Table each summary field is preceded by the word "Total:". Because each column of numbers is very narrow, the printout of the table shows only the words "Total" (or a fraction of it) instead of the actual numbers. I am fully aware that I can resize the width of each column and make the full "Total: XX.X" appear, but this ruins the enti…
-
- 3 replies
- 1.8k views
-
-
Hi. I need to do the following. I have a portal with, say, three fields per line. I want to give the user a button so that it will go to a script and put info into one of the fields in the portal. How do I have a script that will know how to go to a field in a particular line in a portal, or rather a field in a particular record in a portal.
-
- 12 replies
- 2.2k views
-
-
Summaries are prob. my weakest point ... after portals that is. I want to have my layout show past sales based on the item # and display in list format from the most sales to the least: Total quantity for each item Item # Item name Thanks....
-
- 2 replies
- 998 views
-
-
Hello, not sure if this is the right place ... I use FM6. Previously using the mouse scroll would scroll through records. Now for some reason it scrolls the page up/down in a single record. I'm not aware of making any change. Does someone know about this and how I can get it back to scrolling records? Thanks for any help!
-
- 5 replies
- 2.3k views
-
-
Hi to everyone.I want to scroll my layout when i am in browse mode and when i have checked view as Form. I use Show/Hide Status[Lock;Hide] script because i don't want to scroll the records, but the layout isn't moving!
-
- 1 reply
- 1k views
-
-
Hi, I just upgraded to 10A and I went to make a blank layout and it has lines all over it...I cant tell where the page ends? These are not the ruler lines, these look like page breaks both horizontal and vertical (broken spirals). Is there a way to turn these off? Jim
-
- 6 replies
- 1.3k views
-
-
I'm working with two tables, Vendors and Products. There's a join table listing matches of Vendor IDs and Product IDs. The interface shows two portals, one listing Vendors, the other listing Products. When the user clicks on a Vendor its vendor id goes into a global. Vendor #9 is selected by the user. There are two records in the Join table showing "9" in the Vendor ID column, with a value in the adjacent Product ID column. I need those two Product Names in the Products portal to become bold. How can this be done? With appreciation
-
- 9 replies
- 1.8k views
-
-
Another problem. Say I have a parent record. I then have a portal with multiple records for children entry. I then have a button that should do the following in a script. Delete all the portal records for this particular parent and then create a number of portal records for this parent. Example: Parent Jones, children Fred and Agnes. Have a screen that shows the parent - Jones - record with all the basic info. Then I have a portal that has two records, one for Fred and one for Agnes. For whatever reason, I want to, with a push of a button in the parent record, delete Fred and Agnes and create children records for Pat and Mike. This is a simplification of what I really nee…
-
- 3 replies
- 1.1k views
-
-
Working on my first FMP project : and I want to create a dropdown list that will only show the appropriate choices for companies in a given state. The state is part of a table of people that you will search for by name, address, reference #, etc. I want to filter the dropdown list to only show companies that operate in the state where the people are. What is the most efficient way to do the filtering? Should I just populate another table by triggering a script that will do the appropriate find and then populate the value list from there? New to this ...thanks in advance for your advice!
-
- 2 replies
- 1.1k views
-
-
Hello again... Conditional formatting does nor work in IWP-environment, but is there any way to get around that limitation ? I remember that I saw somewhere a trick to do that but now I cannot find it anymore... //R2D2
-
- 7 replies
- 2.5k views
-
-
I have a solution where I have several "small" master data layouts that I have linked to custom menus. the custom menu runs a basic script which opens a new window, loads a layout and resizes the window. The problem I have is that if my start point is my main interface which has a much larger window size the transition to the new window is pretty jerky. If I have a utility (small) window as my start point the new window works fine. Anyone have any tips here for calling "new" windows of a smaller size.
-
-
- 4 replies
- 1.4k views
-
-
Hello, I created 3 summary reports/layouts in FMP10 and they works fine when I am on FMP10 clients. When I tried to view the summary from FM9 clients it showed that there're records but the view shows nothing. is there any known incompatibility issues in summary for FMP9 and FMP10? Thanks! NESE
-
- 2 replies
- 919 views
-
-
I have a daily calendar that's linked to our service ticket table. Sometimes more than one item is scheduled at the same time, it's okay if multiple items are scheduled on the same service ticket number. But there is a conflict if multiple items are scheduled at the same time for more than one service ticket. For example: Ticket 123 Termite Insp 9 am Ticket 123 Home inspection 9am Ticket 456 Termite 9 am I want the field to go red or add an asterisk, something so I know that there is a scheduling conflict. The scheduling conflict would be ticket 456. I can conditionally format when there are multiple items at that time but I want to do it based on t…
-
- 1 reply
- 1.2k views
-
-
How do you escape ## on a layout? When I add it directly to the layout, not field, I get a question mark. I tried quotes and but it did not work.
-
- 1 reply
- 986 views
-
-
I'm relatively new to filemaker and have gone through a few books and the FileMaker training series but have been unable to find a way to do what i need to do. I setup a test database to try this before i created the actual database. The database will have 2 tables, one for clients and onefor claimants. On the client layout, i have a portal with a relationship to the claimant level which shows any claimants that are attached to that client. My question - Is there a way to open a particular claimant from the portal? The software we currently use is called TeleMagic. We have the database laid out in the same fasion. So if i were to open lets say client #…
-
- 4 replies
- 1.1k views
-
-
Can you specify opening screen size when setting up for runtime?
-
- 2 replies
- 1k views
-
-
Don't know exactly where to put this question. I am converting an application from FMP6 to FMP10. I have been doing the development on the MAC, but it will be cross-platform. I just put it on the PC to make sure it is working and am finding some problems (what seems to work really well on the MAC does not work as well on the PC, such as navigation between tabs and layouts; on the MAC they run very clean, on the PC a lot of flickering and jumping.) So, I am now re-writing scripts to run smoother on the PC. If anyone has some insight into that, I would appreciate your thoughts; but the question I have is on another matter. In FMP10, it automatically …
-
- 4 replies
- 1.5k views
-
-
G'day all, I haven't been developing for a few years now (and haven't checked in here either) but I'm considering taking up the art again to produce a contract and project management system for the organisation I'm currently working for. I'll have to upgrade my FM Advanced to the latest version. I'd just buy an off the shelf project management package but trouble is none really meet our complex reporting requirements: i.e. dynamic reporting of projects by directorates, locations, funding sources, strategic goals, etc. I know I can put the basics together in FM in pretty short order but where I'm envisaging getting a bit stuck for time is being able to display …
-
- 2 replies
- 2.3k views
-
-
I use FM for my clinical laboratory. Patients pay their dues in one, two or three payments. How can I make a portal to keep track of these payments for each patient.
-
- 1 reply
- 1.1k views
-
-
Hi everybody! Is there a way to show a $var/$$var on a FMP10 layout? Perhaps using that powerful tool called Webviewer? Many thanks for any idea! /steve PS my tables are filled with utility fields I would like to deprecate... ---- lexan-me-com
-
- 2 replies
- 1.4k views
-
-
This is probably a stupid question (there are no stupid questions..right?) Right now I have a Portal setup I don't really like. I was wondering if anyone had any insight into a calculated Portal, if it even exists. Right now I have a related table, and I only want it to return records based on two variables. I know what both variables are, One is an item number, the other is a Status. I have many Statuses stored in this table, but I only want it to return a certain one... lets call it "A" I had to create a Global Variable and keep it populated with "A" to fulfill the other condition of the portal relationship, the Item # wasn't a problem, it is already …
-
- 7 replies
- 1.6k views
-
-
This is probably an easy question, but I can't find the answer. I have a script that as it runs, it populates another table, which I can see instantly on a portal. What I want to add to the beginning of the script is a test. I only want the script to run if the portal is empty. I know there is a isempty() function, but I am not sure how to use it. Right now I have it say... go to Portal Row [first] if(isempty(?)) where the question mark is, I am not sure what to put... How do I test to see if it is empty?
-
- 2 replies
- 1k views
-
-
Hello. My name is Nick and I'm relatively new to Filemaker. This is my first time posting on these forums. I looked around and didn't see this question asked, so if it's been answer already, please point me in the right direction. Thanks My question is this: I want to be able to see and interact with a global field through a portal. I've actually gotten this to work before, but when i changed the fields to globals, it stopped working. I'll try to explain as best I can. I have a table and a table occurence with identical fields. I've set it up so that the portal on my layout is validated if a certain field is set to "yes" from a popup menu. So when the value in …
-
- 10 replies
- 2.2k views
-
-
I am wondering if anyone else is experiencing this bug in Filemaker pro 10. I have a value list created that references a rather small table to populate the value list. I created a Global Field on one of my layouts and made it a drop down selection based on that value list. Sometimes in Browse Mode, when I click on the drop down, it freezes up. The Program is still fine. I can click other fields, but the Dropdown remains frozen and is blank. I usually have to switch to another layout, and then come back, and it will work just fine. It only happens sometimes, but enough where I would be concerned my users will freak out. Anyone know what could…
-
- 1 reply
- 1.2k views
-
-
I am designing a database for a university that professors will use to log courses that they have taught. I have three tables: Staff, Courses and Course Records. I would like the professors to be able to open the course records table and select their name from a drop-down list, then be able to narrow down the list of courses by selecting a department (eg biology), a year (eg 3) and having the results displayed in such a way that he can then select the course that applies to him and continue filling out the form. I have managed to get the drop-down list using a list of values that takes from the name column in the Staff table, but i am having trouble with the cour…
-
- 1 reply
- 936 views
-
-
I set up multiple filter fields to limit a set of records shown in a portal. The filters work fine unless a field contains records with no data. Any records will null data in a field are not displayed. How can I show all records including those with null data. This is how it is set up... global filter field: _z__FilterStyle_gxt Calc fields: _c__FilterStyleStart_uct _c__FilterStyleEnd_uct Relationships _c__FilterStyleStart_uct ≤ Style__lxt _c__FilterStyleEnd_uct ≥ Style__lxt Script on filter field triggered on modify: Commit records/requests (no dialog) Set Selection [_z__FilterStyle_gxt: Start Position: (Length( DIR_Import::_z__Filt…
-
- 3 replies
- 1.6k views
-
-
Hello everyone, First post, please bear with me! In the database I took over the original developer had designed it as one visible window with layouts switching inside it, with no pop-ups. The Client now wants to take advantage of the FM10 dynamic reports and have them pop-out and have two or more windows open. However all the global fields on the layouts are the same so when entering in the global on one layout you also visibly enter on second, third etc layouts. Which will drive the users crazy. Any ideas how to show the globals being entered only in the foreground layout and not enter in the rest. Thank you. I know I can put different globals on differen…
-
- 5 replies
- 1.3k views
-
-
Hi all, I am trying to create a report where it shows sub totals sort by projects. As projects are really big, I need to break the report so that each project can be "separated" in a different page. Can this be done? If I do "Find" I lost the sorting set up, but I need to keep it. thanks.
-
- 2 replies
- 1.3k views
-
-
I found this inconsistency the other day. It seems as though when using a date format on a merge field in conjunction with conditional formatting, conditional formatting fails. See attached file. ConditionalFormat_DateFormat.zip
-
- 4 replies
- 2.3k views
-
-
This should be easy and I looked on the forum, but could not find an answer... I have the following: Valueslist::Species Valueslist::Category Valueslist::Value I need to setup values lists that are accessible to other files, so that a global field with Species will only list categories for that species and a selected category (as a global field or calc field) will list only associated values. "All" will be valid for Species (but the global field for Species will have an actual species indicated.) I tried to set up a simple one, using just the category and values fields, but can't get it to work: The Category is Contact and the values are cont…
-
- 1 reply
- 1k views
-
-
I have a database that records patient's medications in a portal. Field order = Medication, Dose, Date_1st_prescribed, Date_discontinued. A patient may be on multiple medications in the one category (eg: sedatives or antidepressants, etc and I have a number of portals, by medication category, stacked in a layout to handle this). I have two queries. First, how can I find and display specified portal values for a single patient? To clarify: Patient X might be taking three medications in the "anxiolytic" category portal (but the portal for reasons of space and usability displays only two rows). Over time the patient may discontinue a specific medi…
-
- 5 replies
- 1.6k views
-
-
Can FM convert a return delimited list into values separated by pilcrows? Using the list function I obtained a field with a list of values: BLB BLG BLK... I want to use this field/list in the a Filter function. Can I use FM to convert this list to BLB¶BLG¶BLK so it can be used in a Filter calculation?
-
- 11 replies
- 2k views
-
-
Hi everyone, I couldn't find this anywhere and it is driving me nuts. If I am in a table view in browse mode and rearrange the fields, I get a dialog box that asks if I want to save the changes. I have "Save layout changes automtically (do not ask)" checked off in preferences and in layout set up I have "Save record changes automatically" checked. This has only happened since I moved up to FMP10. Is there a way to stop that dialog box from popping up? Thanks Mike
-
- 2 replies
- 1.1k views
-
-
I'm using filemaker 7 adv, my users are on fm8 I need to change the text color of my "days" field, if the value meets specific conditions. Days = <90 color green Days = >90 color blue days = <120 color yellow days = <180 color orange days = >270 color red Heres what I tried so far. I'm not sure if i need if/else or if im on the right track just need alittle guidence. The code i have below was working for conditions 1 and 2 but thats it. any help is appreciated. thanks Case ( days ≤ 90 ; TextColor (days ; RGB ( 51 ; 153 ; 0 )); + days > 91 ; TextColor ( days ; RGB ( 102 ; 0 ; 204 )); +days ≥ 120 ; TextColor ( days ; R…
-
- 3 replies
- 1.9k views
-
-
I have an object with a container in it. Is there a way, in a script, to set the size of the object?
-
- 3 replies
- 1.1k views
-
-
I have been reading through several posts, and this has probably been answered in some regard. But I still can't find the answer I am looking for. I simply want a value list to be displayed Chronologically. Unfortunately, when I use the drop downs, it changes the sort order completely. The value lists are Jan 08, Feb 08, etc..... I put them in the correct order on the Table that I am referencing... they also have Serial ID's in the order of earliest to latest, but the drop downs re-sort it based on English I guess. Any ideas?
-
- 3 replies
- 1.2k views
-
-
Hello, Is there a way or plugin that would allow me to create or validate a text field with a fixed number of lines regardless of the number of characters. Thanks RudyM
-
- 6 replies
- 2.5k views
-
-
I have a portal that contains three fields: Vendor Material Price The portal sorts by price. For any given material, the least expensive vendor shows up on top. Is it possible to create a (4th) calculation field that queries this portal result and selects the top (least expensive) vendor for purchasing purposes? I like the portal to display my options but I would like the calculation to automatically select the least expensive of those options. Any ideas how to do this?
-
- 4 replies
- 1.3k views
-
-
I too have a hard time with the Reference ID of a particular record showing instead of its preferable known value, whatever it may be. I have read a few of the posts on this topic and many point to using Popup boxes in lieu of drop down lists others use a second field to mask the dropdown list to give an illusion of no foreign reference ID and others use a second window or form triggered by a button to make selections from a list view or portal. None of these solutions are friendly to data entry personnel who would like nothing more than to never have to use the mouse. They want to Tab into fields and start typing and Tab on to the next field. Unless they know th…
-
- 5 replies
- 1.7k views
-
-
Hi all, I am creating a portal and from that portal I want to populate records of another table. I am doing this with set variable and set field. The problem is that if I click more than once the button on the portal row, the script create duplicate records. Ideas to avoid this duplication?
-
- 3 replies
- 1.2k views
-
-
Hi I have a button inside a portal. If there are no related records, the button/script is not activated. Is there a clever workaround for this, other than simply placing a second scripted button outside the portal? Any help/suggestions much appreciated. : Grant
-
- 5 replies
- 1.5k views
-
-
I've got a unique situation, in which I have multiple unique records that need to share a common identifier. Basically we have information from 4-5 different sources that contain similar (albeit unique) information about the same record. Basically the pseudo-structure of the data is: 111 1 2 3 111 2 4 5 111 3 2 1 111 5 1 2 222 5 8 1 ... I'm looking for a solution in which I can populate a table with said data, and display the records on an alternate layout inside a portal. E.g. I will have record XYZ within a layout that corresponds to the records identified by 111, and I want a portal that will auto-populate a single row for each correspondi…
-
- 1 reply
- 1.2k views
-
-
This probably isn't the correct place to ask this question, but I didn't see a better place.... I have a new HP laptop and just loaded FM 7 onto it (the same version I've been using on a desktop for a while). In Layout mode, anytime I click on the screen and hold (like when you are moving an object)the screen goes black. While I'm moving the object I do get little flashes of the screen, but for the most part it is all blacked out. Any reason for this? and how can I stop it? Thanks.
-
- 3 replies
- 2.1k views
-
-
Hi Guys I just started on FM so please excuse me if this is too basic or not even possible. I am modifying an existing FM Pro 7 db in FM 10 adv. There are some 50 layouts with similar fields going into the same table. i need to make small modifications to some fields like changing the default color, default font etc. is there a fast way to do it? i was thinking change it in one layout and copy/paste it (would this break any references to tables/scripts that point to it?) but i also had a question in mind that for future purpose can all layouts point to the same object so if i even make a change in one layout, it gets reflected on all layouts? …
-
- 5 replies
- 1.4k views
-
-
Perhaps I'm missing something, but it seems like the developer should be able to set a default page size for each layout. For example, it would be nice to set in the Layout Setup if the layout should be portrait or landscape. As it is, it seems like the user has to set portrait or landscape manually depending on the selected report. This seems nuts when the developer could set configure this when developing the layout. With all the rich features in FMP this just doesn't make sense and when it doesn't make sense it is usually because I am missing something. What am I missing? Thanks
-
- 2 replies
- 2.2k views
-
-
Hello all, I am near completion on what I consider my first "real" FMP application. I pretty much home schooled myself on it - along with the help of many of you here. Thank you. I was wondering if anyone would be willing to look over my fp7 file and see how I approached things and if there are any glaring mistakes I may have made in terms of proper development? Basically this app is a tool where art vendors will submit new images and a spreadsheet that will get imported. It offers a spec view and a list view. You can choose art and create a catalog of the chosen items. Pretty simple in nature - but many of the needed bells and whistles kept me challenged.…
-
- 3 replies
- 1.5k views
-
-
I am trying to build a solution which will contain many layouts, some forms, some lists, some tables. What is the best method for navigating through these layouts. I want to have a number of categories and each category will have a number of layouts associated. i.e. a category of Census would have layouts for 1841, 1851, 1861, 1871 etc. Thanks for any advise you can offer.
-
- 3 replies
- 1.1k views
-
-
Hello again I want now to start a script when return key is pressed. I tries to use the trigers but only enter can be used. I have a form where someone sets its preferences and when hitting enter to save and close the window. The I show the onlayoutkeystoke script trigger but it starts ob every key I press I need just the return key.
-
- 1 reply
- 966 views
-
-
Hi, I have a layout that I show records in as a list. I want to be able to show users what line they are on by coloring the background of the record selected (background of the fields a different color). Is there a way of doing this? I know how to use conditional formatting on a per field basis, but in a list, this doesn't help me. Any suggestions? Thanks in advance Constance
-
- 2 replies
- 1.1k views
-
-
Hello, I'm the classic "guy at company who was asked to make a database and the expectations have gotten out of control.." etc etc. I've developed and populated a shot tracking database for VFX on a film. My principle entities being: Shots Elements Assignments Artists A shot is comprised of several elements. I do not have a join-table and...unfortunately, instead of using a portal I, in my inexperience, used an interface with 6 foreign keys connected to 6 occurrences of the "ELEMENTS" table to allow a user to import elements into the shot tracking. That much of it works just great. What I haven't been able to do is form a portal in an Eleme…
-
- 2 replies
- 1.1k views
-
-
hi all, I have a field that contains a description of each record. In my layout, this field is just above a picture. My problem is that some records have longer descriptions than others, and i would like the picture to always be immediately below the last line of text. Is it possible for the field to automatically resize in length according to its contents, and for the picture to move up or down in relation to the bottom of the text field?
-
- 1 reply
- 1.1k views
-
-
I'm evaluating FP10, and javascript is failing to execute in my web viewer. here is a sample: http://www.omansion.com/2020/fp10-test.html this works identically in FMP 8.5 and in Safari. But in FMP10, it is busted. I wonder if it is because I have installed webkit? Any help is greatly appreciated! -Dan
-
- 8 replies
- 2.5k views
-
-
One of my tables has a certificate layout that, when printed, generates what is essentially a Certificate of Merit with the person's name on it. That layout has, among other things, a field for the person's name. The field's default text size is 60pt and it works fine. The problem is that sometimes there will be more than one name in that field. It's even possible that there could be many names in there (like, 15 or more) and 60 point type won't cut it. I've managed to set up conditional formatting that will adjust font size based on the number of words. Generally this works well except when I have really long names to contend with. So when it's "John Smith, Mar…
-
- 5 replies
- 1.9k views
-
-
I am looking to add a layout that is a month view calendar - able to be clicked to show each month before and after.. ect.. like the normal calendars we all have in Outlook as an example. The calendar would show scheduled events based on records in my "bookings" table. Does anyone have an example of a calendar layout I can look at? Im not quite sure how to approach doing it where it creates the monthy view in a calendar format. I could always have a timeline list, but Id like to try and get it in an actual calendar view.
-
- 1 reply
- 1.4k views
-
-
Hi, Is there a way to visit previous or next layouts as in an internet browser? I'm able to navigate only to the previous layout, but no more than the last one. I guess it could be possible using a global variable that would stack the visited layouts with a cursor. Thanks
-
- 5 replies
- 1.4k views
-
-
Has anyone encountered this bug, where the tab label (but not the tab itself) is compressed (see attached screen grab). This is happening only on Windows, FMP9. The label is set to Verdana 10pt, no text style. Reinstalling FIleMaker can fix the problem, although it may reappear. It's happened with a couple of different Windows users. Any suggestions would be gratefully received. Thanks
-
- 4 replies
- 2.4k views
-
-
Hi all, I'm relatively new to FM, but I'm learning fast. My non-profit org. uses a FM-based database for tracking donor info. I'm trying to create a new layout for printing letters to donors, and my specific problem involves inserting a signature image into the layout. The letter text box includes merge fields for address, etc., and those work perfectly. I want to place a signature image in the layout between the "Sincerely" and the printed signatory name, AND I want everything to slide upward as the length of the merged address blocks varies from letter to letter. I tried breaking the letter body and signatory names into separate text boxes, with the signature …
-
- 2 replies
- 880 views
-
-
I'm having a hard time discerning whether a checkbox or radio button has been selected. The image on the screen is very faint. Is there a way make these graphics more robust? Would really like them to be bright red if selected. If that is too much to ask I would be content with just making them a little easier to see. Any ideas?
-
- 1 reply
- 1.2k views
-
-
I have embedded my database into my website through the use of an iFrame. Now, I'm getting this error: Message: 'top.iwp' is null or not an object Line: 50 Char: 27 Code: 0 URI: https://www.. I have tried to find a solution for my problem but to no avail. I see that this topic was discussed in http://fmforums.com/forum/showtopic.php?tid/201373/post/318242/hl/javascript/fromsearch/1/ but it doesn't seem that they have come to any clear conclusions?
-
- 0 replies
- 1.8k views
-
-
Hello again, Can I change the colors (Fill color and Pen color pattern etc) for a portal with script??
-
- 3 replies
- 1.2k views
-
-
Hello all! First time poster, week long lurker. Lots to read here. I have been building a simple solution for our fire department to teach myself FM9. We have been maintaining a database of burn permits in an excel spreadsheet for years. It is time for FM! I took the contact template supplied with FM9 and chopped/diced/cut/copied....and came up with my frankenstein of a solution. My problems: 1) At the very top of the page I have setup 2 drop-down lists. I want to just "freeze" them so they remain the same on every contact until changed. The 911 operators need to quickly see if it is a burn day or not and the reason, so I thought I would j…
-
- 3 replies
- 1.3k views
-
-
Ok, maybe its that Ive been looking at the screen too long, combined with my newness to FMP - but I cannot figure out how to make one single checkbox on my layout that when checked marks that record for deletion. I would like a checkbox where users can mark records... they stay marked until the button gets clicked that does a find for those with checks and deletes all the records of that find. Can someone help me? My head hurts! hahahah
-
- 5 replies
- 1.5k views
-
-
Hello, I have a layout that looks like this: When I press the button create new conclusion there will be some SQL executed. But when I then look to the conclusion id's there is none. But when i look in the database. it is there. It is in the drop down menu when I restart FileMaker. Is there a way to regenerate the drop-down-list? thnx in advance greetz Ravenix.
-
- 1 reply
- 1k views
-
-
Hi I am in the process of creating a database to store records of trauma patients that we look after. I want to have one layout within my database to classify wounds using the Red Cross wound classification system (see below). I initially designed something using a series of drop down menus for each variable and then used a calculation based on the chosen variables to calculate the score. This works - but as each patient may have several wound the system is ugly and I am trying to find a better way. I thought about using pop-up information windows - that give the definitions for the scoring system - but could not find how to do that. If anyone has any ide…
-
- 3 replies
- 1.9k views
-
-
Yes another one that searches for hierarichal things. : I've searched the whole day on google, but i couldn't find anything that will help me. i will explain what i want. I have a table with content and another one wich says it's an parent or an child ----------- [ content ] ----------- [ -id ] [ -text ] ----------- ----------- [ link ] ----------- [ -parent ] [ -child ] ----------- so... [ content ]-----<[ content ] How can i make an Hierarichal portal for this? thank you verry verry much! grtz Ravenix
-
- 6 replies
- 1.3k views
-
-
Hello everyone I'm trying to buid a report to compare litters weights over a period of time. I have created a table with those fields. Now in my report I'd like to see data sorted the way I can do it on an excel sheet. I want a way to evaluate weight growth between litters and by days. There can be 1 to 12 puppies per litter, of course it's never the same. If it's impossible to have 2 litters side by side, at least I'd like to have the puppies (colors) from one litter side by side. Any Idea how I can create this? Thank you Isa
-
- 0 replies
- 969 views
-
-
Creating a subsummary by date is very easy and printing my records this way is a cinch. What I want to do is offset my 'day' and create a subsummary where the 'day' starts at 6 am and ends at 5:59 am so entries after midnight still print the same day before midnight. Any simple solutions to this one? thanks
-
- 12 replies
- 1.5k views
-
-
Is it possible to control the application window size (FileMaker application window) under Windows? I would like to maximize the file window, so that there's only one frame, and then set the window to a specific size (or vice versa). Any ideas? I've been searching the forums for a while but didn't find anything...
-
- 4 replies
- 2.2k views
-
-
I am developing a form that needs to have multiple lines exactly 10 cm in length; is there a way inside of Filemaker to specify or measure the length of drawn lines?
-
- 3 replies
- 1.2k views
-
-
Probably not possible: I have an EmployeeMaster table which is the source of a layout in form view. I would like to have a portal in the bottom of the form view that lists the Employees. In addition, and when a find procedure is used, it would list the found set. Since the EmployeeMaster is the main table and not available as a related table, the EmployeeMaster table cannot be used in a portal. Is there one of those exotic tricks that exists to accomplish this task?
-
-
- 1 reply
- 2.2k views
-
-
Hi, we are developing a FM10 application and using Supercontainer to store usergenerated pdf forms (invoices, orders etc.) and scanned imasges (pdf's, jpg's etc). We tried using the webviewer to display a preview of these documents (coming from supercontainer). When trying to preview a PDF, the web viwer displays it properly on a Mac OS X client, but fails to do so on a Windows XP client. Is this to be expected or are we missing something?
-
- 2 replies
- 1.4k views
-
-
Is there a way to set printing to fit within the page when it prints. I am missing about 1 inch of data on a specific layout. I dont want to move things to accommodate for the 1 inch to appear. I checked setting and advanced settings and cant find anything.
-
- 4 replies
- 1.1k views
-
-
If I have a square area I want to input text into without it falling off the page but instead to be enclosed by a scroll box what is the best way to accomplish this? I have seen them before but not in any of my samples to see how its done.
-
- 6 replies
- 1.4k views
-
-
wasnt sure where to post this, so I picked layouts... I would like to have a configuration layout where common fields would be set that would be used elsewhere. For example: On config layout, user would fill in the field COMPANY NAME. I would like that field to be a global field that can be used on ony other layout where company name is needed. My problem is - how do I create this config layout to only allow ONE record... meaning users cannot add records and create more configs. Imagine it like the account profile here - a series of fields, but they cannot have multiple records for me. I do not need each user to have a config - this c…
-
- 4 replies
- 1.1k views
-
-
I have a value list built on the contents of a calculation field ("Quarter") which contains either "First Quarter", "Second Quarter", "Third Quarter", or "Fourth Quarter", then a space, then a year (2008, 2009, etc). So a typical value list might look like this: First Quarter 2007 First Quarter 2008 First Quarter 2009 Fourth Quarter 2007 Fourth Quarter 2008 Second Quarter 2007 Second Quarter 2008 Second Quarter 2009 Third Quarter 2006 Third Quarter 2007 Third Quarter 2008 Third Quarter 2009 What I want is for all the years to be together, with the quarters in logical order, like this: Third Quarter 2006 First Quarter 2007 Second Qu…
-
- 1 reply
- 1.2k views
-
-
Hi everybody. Is there a way to have a script rename and replace a layout with a new version? I have runtime versions that I need to keep up to date and this seems like a good way to do it. Thanks for your help. Jeff
-
- 3 replies
- 1.1k views
-
-
I'm trying to use firefox for my webviewer instead of IE. I did change the default browser setting with no success. Is there a way to do this in Vista 64? Thanks
-
- 2 replies
- 2.2k views
-
-
How do you get your file to load like an actual application. I have my control bar set and the file complete. I want it to open up like an actual application how is this done?
-
- 6 replies
- 1.6k views
-
-
I have a tabbed layout with Webviewers on some of the tabs. The tabs are named objects and I have a script which uses Go To Object to open the desired tab. If I click on the tab controls, everything displays correctly, but if I use the script move between the tabs, all of the webviewers display on all the tabs. I have checked the obvious, ensuring tab controls are inside the body, webviewers are inside the tabs etc but cannot find the problem. Does anyone have any ideas I should try? Thanks. Jim
-
- 2 replies
- 1.9k views
-
-
I am hoping that some one can help. We currently use FM 6 and it was all built and developed on Macs. As the business has grown we have started to get more PC's. As my Mac died it was replaced witha PC. However I now have major problems with Filemaker. Functionality stil works however we have lots of layouts that are basically letters that we print off. If I amend any text on these layout the formating goes wrong for all the mac users. Is there anyway around this and is it a known issue
-
- 1 reply
- 1k views
-
-
Can anyone help me figure out how to take the WebViewer one step further so I can automatically get driving directions from Google Maps using a set address (my house) for the FROM address and the addresses in my contact database for the TO address? I don't want to actually interact with the WebViewer to get the driving directions. I want them to show up in the Web Viewer automatically so I need to use a different URL address. I could not figure it out from Google's Driving Directions URL as it doesn't show the FROM and TO addresses in the actual URL. EXTRA CREDIT QUESTION: Then is there anyone out there who has the time to send me a sample file that can actu…
-
- 4 replies
- 4k views
-
-
Hi, Im not sure where to post this...I only use a PC so this may seem like a stupid question. When I download some of the examples here, they have a Mac file attached as well...how is the mac file produced. Can it be done from a PC or do I need a Mac to produce it? We have one guy at the Dept. with a Mac and he wants a copy of the db, and I have no idea how to produce it. Jim
-
- 3 replies
- 1.1k views
-
-
Hi, I was wondering if it is possible for me to change the middle mouse funcion to instead of rolling trough records to just scrolling along the layout. the reason for this is that i dont want people scrolling trough quotes table they have to go back to clients table and search the new client to have acess to his quote! Any one know if this is possible. or if there is a way to lock it trough a script would help too.. thank you!
-
- 1 reply
- 1.7k views
-
-
I'm trying to create book lists for high school students. Ultimately the data will be pulled live (read-only) via ODBC from the student information system the school uses, but while I develop the book lists I'm just replicating the tables in Filemaker (so I don't need an Internet connection to do my work). So the tables were defined by the student information system, not me. I have the following 3 tables: Students (one record per student) -student ID number -last name -first name -grade Schedules (one record for each class the student is taking) -student ID number (matches the one in Students table) -course number -period -teacher …
-
- 2 replies
- 959 views
-
-
Hi all! I know that is a basic question, anyway, how do I avoid the current window to resizie when pop up a new window? I mean, I created various pop ups, so it would be better to have just the pop up without any changing of the original window.
-
- 4 replies
- 1.2k views
-
-
Ok this has got to be a head banger. I'm in layout mode and my Align palette and arrange palette are grayed out - what gives?
-
- 4 replies
- 1.7k views
-
-
Hi gang - I have a container question I'm stuck on. I need to allow a certain logged-in group (call them DRIVERS) access to import files into a container field, but once they are uploaded and 30 mins pass, they will no longer have access to either remove or update them. They do need to be able to view them tho. The record will then pass to the next group. Then, the next logged-in group (EVAL group) should be able to view them in a pop-up window at full size, but never delete or overwrite them. Is something like this possible? I'm lost! Thanks, Tony
-
- 3 replies
- 2.1k views
-
-
hello I would like to make gray some fields in a layout. The reason is to create one layout that can be used in different circumstances. The basic layout is the same but I need to deactivate a checkbox or text filed. Lets say I have a form that has checkboxes. When I press the checkbox "other" I want to active the field near it to write in there. If it is not pressed it will be gray and inaccessible.
-
- 1 reply
- 1k views
-
-
Just downloaded FM10 and I would like to use the Business- email pre made template, however the template appears in a dark blue and the tabs are all formatted in the same color, is there a way to change all colors (including the top header rectangle box) without manually changing each box? thank you
-
- 6 replies
- 1.9k views
-
-
I have a calculated field that does multiple Case tests against several related tables and returns a text status value (i.e. Approved, On Hold, etc) based on the results. Rather than hard-code the status strings into the calculation, I'd like to use a value list, in particular one created from a table, but I can't seem to find a way to do so directly. I know I could use a global field with CR separated values and the various values functions, but since these statuses already exist in their own table I'd like to avoid that redundancy if possible. Am I missing something?
-
- 1 reply
- 1.1k views
-
-
Hi guys, in my invoice solution I have 2 different lines with object in it (1 with items and 1 with services). In my invoice layout I also have 2 different portals for these 2 lines. But I'm have some difficulties printing these 2 diffrent lines on the print layout. I already tried printing one of the line items and that worked perfectly. How can I make this work? Thanks
-
- 7 replies
- 1.5k views
-
-
Is there a tool that can create a graphical map of the layouts in a database? I am looking at Inspector, and though it gives great information, I can't find this feature. thanks,
-
- 0 replies
- 946 views
-
-
Hi, This is more of a general question about another portion of a database I have been designing and I am not sure how to proceed. I have to track the location of a given item from one location to another (the item having been sometimes shipped to various locations before returned back to its place of origin). I want to create a tracking history of this item and also want the main database to only display the latest location of the item. How is that for confusing. Anyway, any pointers would be great. I was thinking relationships together with portals? Bridge
-
- 5 replies
- 1.3k views
-
Recently Browsing 0
- No registered users viewing this page.