FileMaker Interface Features
-
How do you create a tab portal or single page portal view for browsing multiple address records for a contact? Ideas on creating a layout similar to the business tracker sample, where an additional tab appears with each address. In other words, the contact layout would allow two or more addresses in a non scrolling portal . Navigation arrows scroll through portal records. The tricky part is the interface. I need a tutorial on creating this layout with a complex many-2-many relationship. A sample database would help, yet a tutorial or book as a quickstart guide would be ideal.
-
- 0 replies
- 847 views
-
-
Hi all A have a portal to view welders repair rate for the years. I sort the records by year but the portal show the records in random order. I even tried sorting the portal manual but nothing changes. Any ideas why the portal does not sort. Thanks Lionel
-
- 6 replies
- 943 views
-
-
First off I just wanted to thank mr_vodka publicly for already helping me make tremendous strides in my database. I really do appreciate it. I have clients who own multiple homes: Smith owns: 1 A 1 C 4 D 6 J etc. Johns owns 1 X 3 D 8 F etc. This is all solved outside of the computer world because we assign ID numbers to each of the properties, but no one remembers the ID numbers so I want to first reduce the options by name and then to property. I have a layout where the clients call in and request maintenance to their properties. The office manager will get their last name (currently a pop up related back to the property layout-wor…
-
- 3 replies
- 790 views
-
-
Hi, I have to add a proforma page onto our existing database. It needs to link from our contact layout, to this new page. The tricky bit is the data. I want it to fill in certain parts of the form from the data on the contacts page, and to leave certain parts empty. Users should then be able to fill in the remaining data, print and then save it. I'm just not getting anywhere with having the proforma page pick up the data, allow the new data to be added and then saved all at once, its so far been either one or the other. It will be a one to many relationship, with each contact potentially having multiple proformas, so putting this in a seperate table w…
-
- 3 replies
- 800 views
-
-
I have some fields in my layouts that somehow were left at a default white color - while most of my others, I changed with the Fill Color (a Custom Color, I think) to the color of the background I created. Here's the mystery: I now want to change the "straggler" fields to the Fill Color of the others. Seems simple - just right-click on a correctly colored field - determine the color and make the stranglers match. Well I've tried that - but I can't identify any of the standard colors as having the selection box around them and "Other Color..." isn't checked (and I clicked into it anyway - no Custom Colors listed.) How can I get the "straggler" fields to match the…
-
- 5 replies
- 982 views
-
-
I am attempting to build upon a classic school database which is designed to track [color:blue]STUDENTS, [color:blue]CLASSES and [color:blue]INSTRUCTORS. In this database, Classes are identified only by their unique id field and not by a discernable name convention such as "Biology 101" or "Algebra-2" for example. Thus, to enroll a student in the proper section, the user (registrar), must be able to match the following fields to each class id: [color:brown]- ClassDay - ClassTime - ClassInstructor From a UI perspective, I need to show the user a [color:blue]drop down menu lsiting ALL the possible classes, diplaying {[color:brown]ClassDay, Clas…
-
- 2 replies
- 685 views
-
-
I have 4 portals in one layout. I need to be able to activate one of them depending on the result of some calculation. Once active, I can do the rest of processing. How do I do that in script? Thank you all
-
- 1 reply
- 765 views
-
-
I can actually do this already. But it always defaults to the first record in the portal. The solution probably has something to do with "Go to Related Record" or a simple find. But I can't seem to get it to work. Thanks for anyone's help!
-
- 1 reply
- 722 views
-
-
I have a portal in which I want to filter the portal items to show only the activity of the past 30 days. I know that I can use a selfjoin relationship using the creation date field, but I'm a little stuck on how to calculate the past 30 days into that. Can anyone make any suggestions? Thanks, Ron.
-
- 5 replies
- 774 views
-
-
I notice this in FM8 as well in FM7. Here is the situation. I have one database that had a portal when I select an entry in the portal that line turns black when i click on it (which seems normal because I am selecting it). However in another database when I click on a portal in that database all of the records in the portal are highlighted the color of my background and other portals on the layout are highlighted as well. Any idea what can be causing this? Thanks Ron.
-
- 2 replies
- 675 views
-
-
Hi All, In v7, I was able to get around the forced alpha sort in value lists by defining a second "space" field and sorting by that. In v8, it looks like that no longer works. Take a look at the attached in 7 then in 8. In 7, the list is sorted in the order the records are entered. In 8, they're alpha sorted. My goal, of course, is to be able to have a non-sorted dynamic value list with only one field being displayed. Since the sort option is disabled when displaying values only from second field, I can't see another way to do this. It looks like 8 killed one of my favorite workarounds. Anyone come up with a new/different way to do this in 8? T…
-
- 0 replies
- 768 views
-
-
Hello! I have a file I am working on. There is more to it, but I'm stuck at this little step. The file has Employees, and regions. I have field that has region, and then based on that a portal that displays the employees of that region. Simple right.. Now I want to be able to select the employee I want, to view there equipment (equipment is not part of this problem) So I think Radio Buttons, in the portal!! The radio buttons are based on the same realtionship that the portal is based on, and has the value from the relate field for the value list. The problem is that when I select a radio buttons, I get every employee. If I use a pop up list or menu it works fine, I …
-
- 18 replies
- 2.2k views
-
-
is there a way to save a custom layout theme...changing all the colors everytime i make a new layout is starting to get annoying
-
- 5 replies
- 1.2k views
-
-
A new collection (expanding in future) of tricks & examples for portals has been published at 24U Software's web site. Currently demonstrated techniquest include: Horizontal portal (records in columns instead of rows) Matrix portal (spreadsheet-like view of related records) Please enjoy the free example(s) and feel free to e-mail me with any questions or suggestions. HOnza HorizontalPortal.zip
-
- 1 reply
- 1.6k views
-
-
Hi, I'm having some problems with portals after moving from 6.0 to 7.0 (mac). File 1: customer info - has portal showing quotations and portal showing orders File 2: quotations File 3: orders When a quotation becomes an order I make a new record in file 3, import fields from file 2 and then show file 1 again. In the orders portal in file 1 the new order does not appear unless I first go to file 3, click outside of any fields (screen blinks once), then return to file 1 and refresh the entire relation. This worked flawlessly in FM6, but has the above "bug" in FM7. Relations are all intact. Am I missing something? I've tried going to …
-
- 4 replies
- 818 views
-
-
A new collection (expanding in future) of tricks & examples for tooltips has been added to 24U Software's web site. Currently demonstrated techniquest include: Implementing and managing multilingual tooltips Storing tooltips in variable arrays or dynamically named variables Switching between multiple languages or tooltip sets Accessing related data via the GetNthRecord function Please enjoy the free example(s) and feel free to e-mail me with any questions or suggestions. HOnza LocalizedTooltips.zip
-
- 0 replies
- 2.1k views
-
-
I am sure many of you have seen the new option in the value list dialog which allows you to display one field's contents and return another field's information. It's the check box named "Show values only from second field" in bottom right-hand corner of the Specify Fields for Value List dialog. I am trying to use this option in the following scenario: Tables: Items (contains records of items) Seasons (contains a list of different season in a year) Seasonal Item (a table that contains keys of the item and season records. A join file) Relationships: Item::ItemID_pk >> Season Item::ItemID_fk Season Item::SeasonID_fk >> Seasons::Seaso…
-
- 12 replies
- 1.6k views
-
-
I asked this a year or so ago, but I'm hoping more elegant solutions have been done. Given: Table A with serial # key field and some text field. Value list of Table A where the first field is the serial # and the second is the text. Table B with a # field set to display the TableA value list as a popup menu or list. Issues: 1) The popups don't display the second value list field if the layout field is not popped up. 2) Seeing the serial # is ugly, especially when sorting on the second field. Putting a calc field with just the 2nd field's value over the popup isn't elegant. 3) A reverse relationship where only the text is in the value list and a lookup o…
-
- 12 replies
- 1.4k views
-
-
I haven't been able to find an answer to this in the forums, but hopefully it's a very easy question. I created a field with a value list of four different options for mailing lists, and then used checkboxes (so that one person could be on four different mailing lists). However, when I go into Find Mode and select one of the mailing lists in the checkbox (to find all those people with the box checked), it returns tons of people who aren't necessarily on that mailing list. WTF?! I can't right-click the field in Find Mode for any kind of Field Behavior thingy... I don't know what to do. Please help? Thank you. (I'm smart but don't have any experience.)
-
- 2 replies
- 734 views
-
-
In table view, the field names become headers and are displayed horizontally across the page. The individual records are displayed as horizontal rows below the field names. I would like to reverse this orientation such that the field names are arrayed vertically in a column and the records show up in columns to the right of the field name. In MS Excel this is called transposing. Is something like this possible in FM8 Advanced? Thanks, Jarvis
-
- 3 replies
- 951 views
-
-
hey everybody, i'm trying to create something simple that i know you all probably know how to do in a snap. i need a way to track how much time someone is spending doing certain tasks each week. what i envision is a simple table with 3 columns: date, time, and notes. But i obviously don't want to create a different field for each "cell" in this simple "table." How can i do this without creating a different table occurrence to track this information? or do i have to? thanks
-
- 1 reply
- 832 views
-
-
I’ve having trouble getting graphics to show up in FMP without some sort of a square, white background. The files I’m being sent from the client are in .ai format (Adobe Illustrator.) I can make them into most any other format file (TIF, JPG, GIF etc) with kinds of options using Photoshop Elements. What do I need so I can put them in a Container file and have them display on any given layout – and I can successfully fill in their background color? (Believe it or not, I actually had it working for awhile with the initial images I was given, but didn’t write down what I did – and spent a good hour and a half last night trying to re-stumble onto the solution.) Than…
-
- 6 replies
- 1.3k views
-
-
Is there a "get" calculation that can return the current total portal rows? I need it to change dynamically as related data changes and results in different number rows. Additionally, is there a "get" that can return the current portal row? I'm hoping to create a global field with data such as: "Track 1 of 3456" that then changes when a different row is highlighted. Thanks for the help Greg
-
- 1 reply
- 644 views
-
-
Here's what I'm trying to do. There may be an easy way to do this, I just can't rap my head around it. Here goes. I have two tables in one file. With a relationship setup as follows. The primary table is set up to allow the user to create new records which signify groups. So with each new group you create a record. The new record only has two fields. Group # and Version. Both of those are user enterable. The file that holds all the records with all the info are in another table. When you create in a new record in this table you are able to enter a number signifying the record. So you'd be able to create records. 1a01, 1a02...2a01, 2a02 etc. The…
-
- 6 replies
- 937 views
-
-
Really can't believe I'm asking this horrendous newb question!!! I just can't seem to get a layout from within the same file to open in a new window. What do I need to put in my script in order for this to work? Many thanks Nick
-
- 2 replies
- 768 views
-
-
Is there a function that will change the background color of a field? I know how to do it manually, but, as part of a project, i'm trying to automate it with a script. thanks for any help
-
- 3 replies
- 951 views
-
-
I've been playing with Tab Controls and have my best kludge to beautify (IMHO) Tab Controls. Basically, the Tab Control's fill and stroke is turned off and the text set to 1px and background color. Container fields as buttons with scripts & script variables are used to track which tab is active & to change tabs. There are some other issues, see the demo. Please comment and/or modify the sample, I'm sure there's room for improvement. SamsTabControlDemo.fp7.zip
-
- 4 replies
- 2.1k views
-
-
Has anyone used only portals for all list layouts in a project? Usually a table will have 2 main layouts - List and Details. The List layout shows a list of items that when one is selected it goes to a Detail layout with all the relevant fields for data entry. The list layout uses 'View as List' and can be easily sorted with scripts attached to the column headers and a total can be put in the Footer or a Trailing Summary. All straight forward... BUT, has anyone used all portals instead? What are the pros and cons? I have setup a template that has a Menu on the right side of my layouts and using portals I can have a list without using the list view so my deta…
-
- 4 replies
- 914 views
-
-
A drop-down list which has a value list with about 20 values takes several seconds to drop down. I've read on the FM site that this can be caused by having multiple windows and/or open files. In this case, there are between 5 and 6 windows. And around 8 files. I've followed the separation model so the UI is in a single file and there are 7 data files. I cannot reduce the number of windows without hurting functionality ... ditto the files ... Has anyone been able to improve the performance of drop-down lists? (Drop-down menus are not an option because they do not drop-down when tabbed into ... only when data is entered ... also they allow data other than that in the l…
-
- 6 replies
- 1.1k views
-
-
Hi, I am fooling around with a mock client/order/invoice system and am having problems referencing some records from one table to another. I think it’s a simple problem, probably to do with an incorrect table relationship but I can’t seem to work it out ( I cant seem to find how to make a 1to1 relationship in filemaker, which is what I think I need.) This is the basic layout if anyone can comment. * = Key (auto/serial number) Basically the problem is I have a “clients” layout with a portal to “invoices” the portal displays information from the invoice table but I need it to also display a field from the orders table as well in the same por…
-
- 4 replies
- 764 views
-
-
I have an application that prints a rather large report. The customer is insisting that they have the option to print some portions, but not others. Does anyone have some insight on how this could be done? Example: Report could contain the following topics: Topic A Topic B Topic C Topic D Topic E Topic F Topic G Mind you, I jump through a number of hoops to create some of those topics – they are not just straight print offs of fields. Goal: User goes to a screen checks off that they want Topics B, D, E and G. So only those should print off in the report. (Weak) Brainstorms I've had about this include - making all the portions of the rep…
-
- 14 replies
- 1.8k views
-
-
Hi, I have a requirement for two portals on one form, selecting a record in one portal should display the associated items in another. For example one portal should display all image categories, and the other should display the images associated with the particular category selected. Changing the selection of category from the first portal should change the result in the other. All on one form or layout. Any ideas how this can be achieved?.
-
- 1 reply
- 653 views
-
-
Good day, I am a Newbie to FM. I have a text field that will contain no more than 50 words and an image in another field. I need to have the text wrap along the right side of the image and then continue below the image (like a mug shot in a newspaper column). How can I achieve this kind of text wrap? Thanks, Kevin
-
- 3 replies
- 1.7k views
-
-
Hey everyone, I need to issue a report that will have several summaries on the same page. they don't take up that much space, since they are just totals. and they want them all to be in the same report (and script) example: Topic 1 Total Patients Total Patients w/ Chronic disease Total Patients w/ Insurance --------- Topic 2 Count of Languages Spoken Count of Country of Origin --------- Topic 3 etc. these can't be grouped with each other because they are separate statistics. Can I put them on the same page??? when i make two separate sub-summaries, they just intertwine with each other. and i need them to be separate…
-
- 1 reply
- 710 views
-
-
I have a plant DNA database and want to show two portals side-by-side to show those DNA's that have been selected for PCR and those that haven't. My current solution uses two self-joins to the field "Select for PCR" which is either set to "Yes" or "No." The portal on the LEFT shows those records for which "Select for PCR" = "Select for PCR" between the original DNA table and the first of the self-joined tables. The portal on the RIGHT shows data where "Select for PCR" DOES NOT EQUAL "Select for PCR". In this way, if a record is set to "Yes", the portal on the left shows other that are also set to "Yes" while the portal on the right shows those that are set to "…
-
- 2 replies
- 650 views
-
-
I cannot seem to figure out how to get a button to show a popup. Are these only available to fields? That would be a bad interface assumption on FileMakers part. I hope that is not the case. I have a row of buttons at the top of the window that run scripts. One of these buttons ( I had planned ) was to have a popup that displayed a value list (already created) that had a list of the other records in this table so that the user couid jump to the another record in the list. Thanks in advance.
-
- 9 replies
- 1k views
-
-
-
I don't mind the added feature, although you do have to have a border on the right side of the field for the icon to show up in browse mode - without clicking on it It would be nice to see the icon without the need for the border - you can have a hairline around the field, but the calander then gets a thick border . . .
-
- 5 replies
- 1.1k views
-
-
Hello! I have a samll test database were I have a table Person and and a table Jobb since a person can have many jobbs I have a Person_jobb table. In that Person_jobb table I have a field that I want to show in a portal for every person. But it only takes the first value and show it on all persons in the portal See the example!! How can I make it so that it shows the stored data in the middle table for each row in a portal??? (Not just the first posts value an all rows) Many many thanxs too u that helps me!! // Jocke TEST.fp7.zip
-
- 3 replies
- 645 views
-
-
I want to open a new window with Hidden Status Area Locked. There must be an easy way but can't figure it. I have tried to use a script but it hides the Status Area of the parent window. Any idea? Thanks RD
-
- 4 replies
- 915 views
-
-
Hi, I'm not sure if I can do this, but I've learned that if you can imagine it, there is generally a way to do it. What I would like to do is have a value list of layouts. The idea being that the user could choose a layout and go to it (via a script based on the number value of the layout). The list would only be some of the layouts in the database also the list would have to be self editing to grow or shrink as layouts are created. I thought of having a database which contains just the layout titles and a way of distinguishing which should belong to the value list, and then have a calculation field based on the content of the selected layout. Not sure if this make…
-
- 4 replies
- 1.5k views
-
-
I use FM7 under windows. When a script ( that is triggerd by a barcode-scanner) ends, my application is not active anymore. I have a grey titlebar in stead of a blue one. It's not what I want because the application is meant to run whitout keyboard or mouse (only barcode-scanner & touchscreen). I can't find a scriptstep to activate the application, they all seam to be made for the windows, layouts, fields but not for the application it self. Any suggestions? thanks a lot Koen
-
- 4 replies
- 944 views
-
-
Does anyone know where or how to add the a list of open windows to the end of a menu, like the one in the window menu. Not the "Show Windows" sub menu that list all hidden windows. I need the list that is attached to the bottom of the window menu. I am trying to make my own window menu without the some the menus that are built into the standard FM Window menu.
-
- 0 replies
- 1.2k views
-
-
I browsed forums, googled web and news groups, but found no answer : I have a layout for browsing, and I would like to have a current record number/total number shown. Like "172nd of total 211 records" or just 172/211 How I do that? Thank you! .ez.
-
- 10 replies
- 1.8k views
-
-
Is there a way to export or copy a layout that is in one database (for one client) to another database (for another client -- that uses the same fields)? I can't seem to figure out how to do this.
-
- 1 reply
- 1.4k views
-
-
The setup: * 2 tables, related via as simple a=b relationship (text fields on both sides) (in my case, the tables are in different files, not sure if that matters) * in table 2, have the following fields in addition to the relationship key field - Text1 (text) - Text1AsNumber (stored calc, = GetAsNumber(Text1)) - at least 1 other field * have portal to table 2 from a Table 1 layout, set to allow creation of related recs * include Text1 in the portal, plus one other non-calc field The Behavior: do the following: * go to a new row in the portal, and create a record by entering a value in Text1 * exit the record * flip over to a Table 2 la…
-
- 6 replies
- 1.3k views
-
-
I am messing around with FileMaker 7/8's multiple window capabilities and have run into a bit of a quandry. What I am trying to do is gather info about all the open windows. I chose, for lack of a better idea, to select each window in a looping script and populate a global field with an array consisting of the position and size of each window. This works great if all the open windows belong to the file from which the script was run. While the script successfully selects the windows that don't belong to the file from which the script was run, it doesn't gather the info about those windows. I understand that it's a focus thing and that I would need to run a …
-
- 6 replies
- 1.2k views
-
-
Does anyone know a way to disable all menu sets that have been assigned to layouts? After I have gone through all my layouts and assigned their appropriate menu sets, I some times need to go back to the layouts and do some dev work on them. The problem is the standard FM menus are not accessible on my layouts. I can disable the menu set to a normal FM menu, but once I switch to another layout the menu set resets. Also I can only disalbe menu sets one at a time, not all at once. Hpw can any developer get his work done. There has to be a command that will allow the developer to disable all menu sets during his working session. Once the the solution is re-open…
-
- 3 replies
- 1.5k views
-
-
I'm using ver 8 Pro Advanced and love the Tab Layout until I hit on a problem. The table context is set to the table that I used on the first tab. I got two more tabs to work since they were key related to the first but my fourth tab is not related at all so I get an "unrelated table" error when moving into browse mode. What am I missing since I can't find any related info in the help files? The table context seems to be related to the complete tab layout rather than on an individual tab basis. K.
-
- 1 reply
- 1.3k views
-
-
FM added Tool Tips to Advanced (version 8), a much awaited feature. I previously used a plugin which was really not worth the effort. FMI's implementation is clearly superior to what any plugin could accomplish. First off, the tips work inside of portals, whereas the plugin only worked on the 1st row. I set up a whole bunch of tool tips as text calculations across a number of files. However a fair number of them would work in one file, but are in another file. As an aside, I find that the Define Fields takes a relatively long time to close. Now for the hint. Go to Link and download either of their clipboard utilities. One is freeware and for the most part work…
-
- 1 reply
- 1.8k views
-
-
I have just converted a file from version 3 to version 7. It seems to be working largely as expected except the pop-up lists are so slow. For example, I have a custom value list with 5 numbers in it. I click or tab into a field set up as a pop-up list taking values from the value list and it takes 2 to 3 second for the value list to appear and then once I have chosen a value it takes another 2 seconds to drop into the field (all times approximate). So something that I used to do in a second or less in version 3 is taking about 5 seconds in version 7. I have changed the format to pop-up menu and that is as fast as always. However, that option is not open for most of my val…
-
- 3 replies
- 719 views
-
-
Hi I've been struggling with creating a dynamic value list, based on selected options. The short story is that I've been trying to create a database, that list available translators, based on their language skills and what language the project is for. I finally managed to create this list, which updates as soon as I change the from/to languages. For this purpose, I've created two files/databases. 1: Employee database It contains information about the employees. The ID field is the short name for the employee. It also contains 10 x 2 Pulldown-menus for selecting from and to languages. (10 possible language combinations). An extra fie…
-
- 2 replies
- 943 views
-
-
I am having trouble with some scripts for window manipulation and user privelages. When I open one of the accounts it tells me it cannot run a function and then does do the window modifications. I need some guidance on what aspect of the privelages affect scripting. Thanks
-
- 1 reply
- 846 views
-
-
Is it possible to set a zoom level for each layout in a file? I have a "home" page that needs to stay at 100. When I switch to another layout zoom in to 150 it keeps everything the same. I guess I could set my "home" button to do that. Is there an easier way?
-
- 1 reply
- 748 views
-
-
I have a layout based on a Donor table which has a field Entity for designating the type of donor (person or business). If Entity for a given record is Person, I need a few other fields (Employer and Occupation, for example) that are not needed when the donor is a business. If I could show these extra person-related fields only when the entity is Person, that would make the layout less confusing. But how can I do this? If there's a better way to approach this problem, I'd be open to that also. I tried to use the new tab panel but wasn't happy with the results because many of the fields are common to both person and business. And that seemed confusing. Thank…
-
- 2 replies
- 697 views
-
-
How might I go about telling filemaker that the portal row with the blinking cursor in it is the one I want to be selected, and thusly the one I want deleted when the 'delete portal row' button is clicked? Because right now, it doesn't matter which row I've clicked on in the portal, it always deletes the first darn row. And it's driving me crazy. : Thanks in advance. Amber
-
- 2 replies
- 738 views
-
-
Hi, I'm trying to print a quote and seem to be having difficulties as certain parts of the layout are missing when I go into 'Preview Mode' although they show up in Browse Mode. I have 2 tables tbl_quote and tble__quote_line_items, the layout being based on the latter. The layout has a subsummary part (leading) sorted by tble_quote_line_items::Quote No - this appears in browse but not in Preview. Similarly, the subsummary part (trailing) which includes the line item total does not show up either. I have tried "sorting' manually but to no avail. Have I got the wrong end of the stick somewhere? Perhaps I am using the wrong parts or something?…
-
- 2 replies
- 827 views
-
-
I started playing with Filemaker's Menu Control, and so far as I can tell, it has a major default: It adds to the first menu that you create for the current file 2 entries...an Exit and a Help entry. The Exit stupidly causes FM to close, and I haven't found a way around this. That means a user could leave a solution inadventently, or in mid-task (say before validation). Stupid, genuinely stupid.
-
- 10 replies
- 2.3k views
-
-
I am trying to build a report that tells me how individuals have paid (ie, check, charge, po, etc.) Each of these is set up as a vlue list and set up with radio boxes for easy data entry. I need to build a report that lists each customer by name and then tells me which way they paid -- but I need each value to be it's own field. See below for a rough example of how the report would look Name Check Charge PO John Doe X Jane Doe X Josh Doe X I know (or think) that I will need to set up a container field for each "check", "charge" and "po." In each of those container fields would I do a I…
-
- 6 replies
- 985 views
-
-
I have a portal showing records from table "A" I can create records using this portal.. Now, in table "A" there is a calculated text field basically telling us what "A" is being used for. Everything worked and all was happy until, suddenly the "Blank" record, that shows in a portal to allow creation of related records, is now doing the calculation and showing resuls for no record. What gives?! Hints? Pointers? Anything? Many thanks in advance. -jim lee
-
- 3 replies
- 667 views
-
-
I know this is probably easier than I think, but I have a value list with radio buttons. How do I set it up so the user can choose more than one option? Embarrased and grateful.
-
- 2 replies
- 629 views
-
-
Hi, I am trying to create a dynamic value list using a related table but have a bit of a twist. Here’s the scenario: Two tables: Products and Invoices What should happen: Invoices table – user enters in a product ID, the product description is pulled in from the products table using the product ID as the key field, the user then needs to select the color of that product through a pull-down menu. The colors that are available for that product are generated through a value list using the related records option. The twist: In the Products table, there is one record for each product (i.e. there’s no duplicate records for each product); each product has a p…
-
- 3 replies
- 663 views
-
-
I have two databases, one for testing and one is the real thing. I've created a list view in the test db and it works perfectly. But creating the list view layout in the "real" db in exactly the same way as in the "test" db all I get is a blank white screen. Absolutely nothing is shown in Preview mode. When I switch to Browse mode the list view is revealed but with no records. I can't figure what, if anything, I've done differently. I've redone this "List" view a couple of times with the same result in the "real" db. But again it works perfectly in the "test" db. Veronica
-
- 6 replies
- 1.5k views
-
-
I have created a value list that I use for check box set that lets me set different status' of records (active, inactive etc...) Question is: How do I set it to default select a specific value? ie; everytime I create a new record I'd like it to default to checking 'active' from the value list.
-
- 2 replies
- 747 views
-
-
I was wondering if anyone had any good resources on User Interface Design. I'm looking for good books, websites, or other easily accessible resources. My personal belief is that good user interface design accounts for a large part of a databases efficiency and effectiveness and want to expand my knowledge in that area.
-
- 3 replies
- 1.4k views
-
-
Hi all, After reviewing the forums I was not able to find the way to put my portal in the footer part of my layot to work. My layout is in list view, and the portal wont scroll down or up with out messing all its rows. Does any body know a workaround to solve this Bug? Is this a bug or FM does not consider headers and footers as places to have portals? [email protected]
-
- 13 replies
- 1.3k views
-
-
I am a recent Mac convert. My primary position at work is buiding, maintaining, and using a MS SQL database with an Access front-end. I don't want to have to use a Windows box anymore so I am trying to switch over to Filemaker. I can't seem to find anything about UNION queries in Filemaker on the web anywhere. Does anyone know if this can be done? The reason for the UNION is to join two unrelated tables so that I can run calculations and summary reports. One table is "Employee Hours" and the other is "Expenses". We are a consulting firm that bills hours and expenses to our employees. If you need more info I can post examples reports I can currently run in A…
-
- 2 replies
- 726 views
-
-
Just a small problem, im trying to make an invoice (report). Two tables, related by a 'client ID'. One table contains the invoice items and the other the clients. When generating an invoice for a client im a bit confused as to how to only show the info for that client in the report, ive tried using a sub summary part by client ID, and then using related values from invoice, but although it shows the correct information it only shows one record, anybody want to point me in the right direction please? Cheers for any help, genx
-
- 4 replies
- 923 views
-
-
I'm migrating an FM6 application to FM7. After I carefully created three categories of layouts: 1) for entering Find requests, 2) for viewing data (no updates permitted) and 3) for full updating, the user has now informed me that they used to copy/paste data between layouts. Having defined fields in the viewing (readonly) layouts to not be used for Finding or Browsing, it does not appear to be possible to copy text from the fields. Is there a (hopefully simple) solution to this? (I know that earlier suggestions to other questions were to set up all updates using global fields and only when the data was clean move the data to the actual fields ... but …
-
- 2 replies
- 775 views
-
-
How do you create a Value List that only shows value related to the record your viewing? For example: Table 1 has A field labeled City that you type in the name of a city. Another field labeled qualities is a pop-up list with qualities of that city. So If I type in St. Louis in the city field, the options Arch, St. Louis Zoo, and so on would show up in the pop-up list in the qualities field. If I typed in Orlando instead, the options Beach, Disney World, and so on would show up in the pop-up list the qualities field. I assume I have to have another table with all the cities and there qualities. Thats no problem, I just don't know how to filter the pop-u…
-
- 4 replies
- 991 views
-
-
I have a very simple portal for transactions - a receipt field and a payments out field. Then a "diff" field isswimply Receipts - Payments The balance is given by a summary field using runnung total of "diff" The problem is that the balance will only update when I manually click into the Bal Field and then only for that record I must me appraoching this from the wrong angle but any help would be VERY much appreciated Yjanks
-
- 2 replies
- 713 views
-
-
I have a portal that shows all boarding reservations for a given date. Active reservations are given a pen number, and some reservations (like No Shows and Cancellations) are not given a pen number. I'd like to show ALL of the reservations, but make the active reservations show up on the top, and sort by them by pen number. In technical terms... When I simply sort by [pen_number], records with blank [pen_number] fields show up on top (obviously not what I want). So, I believe the correct method is by using the "Custom order based on value list". BUT, I do not know what to enter in my value list to sort ascending, THEN blank values... Any suggestions? A sp…
-
- 3 replies
- 769 views
-
-
I asked another question without realizing that Ineeded this answer first. Can you trigger a script from a set of radio buttons? It seems that you can only trigger scripts from calculation fields and buttons, is this incorrect? I would like the user to click on one of two options and have that value determin another action.
-
- 6 replies
- 929 views
-
-
I'm working on a (supposedly) simple invoicing database and I've made good progress thanks to the help I've had in this forum. I have an Invoices table and a lineitems table. I have a portal on the invoices table showing quantity, description and price from the lineitems table. In browse mode, everything is showing up in the right places. However, if I try to print or if I view in Preview mode, none of the portal rows show up. I've looked at Sliding/Printing but the items aren't checked to stop them printing. Any ideas? Regards Andrew
-
- 7 replies
- 1.1k views
-
-
-
Hi everyone, Is it possible to resize row widths when looking at data in table view format? Kristine
-
- 13 replies
- 1.2k views
-
-
I want to use a script to open a different layout in a new window, and I want to define the layout using a script parameter. I can't seem to get it to work. If I do the following: New Window Go to Layout(Layoutname) It works fine. If I simply want to go to a new layout using a script parameter, I can do: Go to Layout(Get(ScriptParameter)) But, if I do: New Window Go to Layout(Get(ScriptParameter)) It doesn't switch the new window to the different layout. Obviously, I'd like to be able to use a script parameter so I don't have to write a new script for every window I want to open. Anybody have any ideas about what …
-
- 3 replies
- 809 views
-
-
i think this goes here... the boss wants a hold button that when clicked some how displays that a record is on hold...but not by putting text into a field.. something like turning all the fields to red text and locking them...or putting the text "HOLD" over top of everything.... i don't really know how to go about this so any help would be apprieciated
-
- 2 replies
- 1.4k views
-
-
Something changed in the 'Set Tab Order' layout feature with FM7. When I went to assign a new tab order on a layout, I used to be able to click anywhere on the area of the field, using FM6. Now with 7, I've got to click on the arrow to assign a number to it. Does anyone know if this was changed on purpose, or is there some super-secret setting that I need to apply in order to be able to click on the field, like I'm used to and prefer? Thanks!
-
- 3 replies
- 917 views
-
-
Newbie-ish Question: I've noticed that when I first create a button - first I'm prompted to with the "Specify Button" window - then the cursor defaults to input the text for the button. Fine. BUT when I go to edit the text in the button, selecting the button in Layout mode brings you to the "Specify Button" window - but I can't seem to get to back to edit the button text easily. My gut says there must be a remarkably simple answer to this one. -Mark
-
- 2 replies
- 710 views
-
-
I'm developing an application and I've decided that I don't want the users to have access to the Status Area - I'm afraid they can get into too much "trouble." I have a few questions related to this: 1) How do I deactivate the Status Area in my layouts? 2) Alternatively: Is there a way to give limited access to the Status Area - so users can't get into say, Layout Mode or Preview Mode? 2) I'm working on a generic search routine which will allow users to search any of the 10 or so tables they can access. The problem is, they really can't understand search results without the Status Area. I provide navigation for them to see records one by one - but they don'…
-
- 9 replies
- 1.1k views
-
-
Hi, I am not sure if I am asking my question in the right section. I have designed an html document similar to a layout in my FileMaker Pro application so that I can distribute it electronically with dynamic data from my application. The problem is printing the html document. I want to add code inside the html document such that the document should print correctly with all the alignment. In other words I want to manage the page setup inside the html document such that the document should fit in a A4 page, portrait, arrange the left and right margins etc. This could be done using the "@page normal { size : <>}" but I don't know where to keep this code in the html doc…
-
- 0 replies
- 867 views
-
-
I'm working on a simple Invoicing database with a line items table and an Invoices table. In the line items table I have a Calculation field called "formatted_time" that formats the time spent on a job. For example, if I spend 69 minutes on a job the "formatted_time" field shows "1 hour 9 mins". This works as expected in the line items table. However, when I put a portal in the Invoice table the calculated "formatted_time" field doesn't work properly. If there is only one line item in the portal - the formatted time works as expected. But if there are two line items the "formatted_time" doesn't show properly. Each "formatted_time" field shows "1" - no matter how man…
-
- 3 replies
- 697 views
-
-
I'd like to have a layout where selecting an element in a popup list causes a portal to repopulate. I'd have no problem with this in an event driven UI, but FMP's layouts aren't event driven. So, how does one do this sort of thing. Here are the details for my schema so we can talk about specifics. I have a many-to-many relationship between Contact and Group tables via a Contact_Group table. In the Contact layout I'd like for the user to be able to select one Group from among all Groups associated with that Contact. Based on that selection, I'd like to update a portal on that layout such that it lists all (other) Contacts that are in the selected Group. So in summary,…
-
- 5 replies
- 904 views
-
-
anyone remember this topic Visual Appeal well i have hit my big 100 posts...and for my 100 i thought i would show what that discussion has gotten me feel free to say good or bad about my layout here it is my layout to see it bigger click enlarge at the bottom right of the of the image 100 posts yay me
-
- 8 replies
- 1.5k views
-
-
Hello, I have several relationships where the left side is a global version of the primary key, and the right side is the prmary key itself (like gContactID = contactID). I then use a GTRR step to go to the desired record. I have a couple of questions regarding GTRR: 1) Is GTRR faster than searching on the primary key? 2) Is there any way to dynamically specify the relationship used by GTRR? I was hoping for a "Relationship Name by Calculation" option. Regards, Sean
-
- 2 replies
- 723 views
-
-
Hi, We currently have a sku item database with all the product we sell. Each item can have 3 different sku assign to it, 11111 (is the item in it's english and french packaging), 1111101 (is the item in it's english and spanish packaging) and 1111102 (is the item in it's english packaging). I'm looking into a way to create a portal that will show all of the sku that are similar. Can anyone help? Yann
-
- 6 replies
- 709 views
-
-
We have a portal that is not updateing right. We open a window were the data is entered, when we are finished we close the window and we come back to the portal its not updated. We have to go one post forward or backwards and then back again and then its there!! Anyone have an idea about whats causeing this?? Ragards Joakim
-
- 2 replies
- 646 views
-
-
[color:blue]I have a field called "rfi_category" that is formatted as a checkbox with 8 values. "CC", "CI", "CL" "CODE", "DI", "IR", VI", "WM" are the values. I have created calculation fields for each that state: If (rfi_category = "CC"; 1;0) [color:blue]I have also created summary fields for each that state: Total of "count_cc" (running) The summary fields are the ones that I have placed on my layout, however all of the fields show "0" even if all of the check boxes are checked. Am I missing something?
-
- 2 replies
- 744 views
-
-
Hello Everyone, Thanks in advance for any help. I am trying to have a window open when you tab into a field through a portal. I have made the creation of records through portal avialable. When I tab into a certain field, I would like it to open a window with more options. I was thinking it could be done through a script or just a define button option, but can't figure out how to activate it by tabbing into field. Thanks again.
-
- 0 replies
- 790 views
-
-
I have a portal which is sorted by a calculation field set from a global field via a script button using a Case statement. This is fine for sorting ascending but I cant figure out how to sort the portal for a text field in descending order. Number fields are ok - just use 1/(field value) But How do I get a text field to populate the sort field in descending order for a text field. Thanks
-
- 1 reply
- 783 views
-
-
i tried to "specify button" on the first field on the portal line and set it to go to related record but it dosent work. can someone poin me in the right direction. a very good friend did this for me once but i cant even learn and undertsand how to do it from reverse enginerring what he did.
-
- 3 replies
- 748 views
-
-
Hello there, I have 3 tables: record, style and category. The category table is many to many relationship with the foreign keys of the two others tables. How can I have a field in the record table which contain all the related style separate by a ",". For exemple: rock, pop/rock, aor. Many thanks for helping me. Dom
-
- 3 replies
- 780 views
-
-
Hi everybody. I'm a long-time FM user, but haven't upgraded in a while. Been using FM Pro 5.5, and FM Mobile 2.0 on a Mac c OS 10.3.9 for some time, with great success. Upgraded to Mac 10.4 in May and have had nothing but nightmares! Can't sync, can't install FM Mobile conduit on my Treo 650 phone.Palm's latest desktop for Mac 4.2.1 has been recalled and is unavailable for download. Can't install the FM conduit even using the Missing Sync. HELLLLLLLLLLLP! I am a physician and had been using this system for keeping patient data with me; I feel lost without it. I'd be very grateful for anybody's assistance. Thx. PRB1 :
-
- 5 replies
- 743 views
-
-
Hello, I have a customer table that has a few fields that are boolean - blacklisted, closed, potential. I have a filtered portal where the user can choose a customer. The portal is filtered based on a low match and a high match (like in the book (Using Filemaker 7, Special Edition). The user types in the first few letters of the customer's name and the portal filters down. The effect I want is to be able to have the user be able to click buttons for blacklisted, closed and potential. If no buttons are clicked, then the portal is initially filtered to not include customers who are blacklisted, closed or potential. If the closed button is clicked,…
-
- 29 replies
- 2.8k views
-
-
anyone know how to make a button that flashes when new info is added to a record
-
- 1 reply
- 1.2k views
-
-
i have a layout that can be navigated to by several different layouts but on the one layout i only want one back button that goes back to which ever layout was used to navigate to it
-
- 6 replies
- 846 views
-
-
Find number of days between two dates. (Got it) If days are greater that 15: Change color of 15 and greater to red. Can this be done in one calculation? IW
-
- 1 reply
- 786 views
-
-
Is it possible to have more than one portal thats not related in a single layout?
-
- 11 replies
- 1.7k views
-
-
Hi, I'm having a lot of trouble trying to build a particular report. Perhaps this will seem like a really simple problem to you FM wizards, but I'd definitely appreciate any help you can offer. I'm trying to create a report that shows: An Hour -- A Segment ----- And Any Guests Under That Segment The trick is that instead of being stuck with the phrase "Segment 2", the user must be able to modify that label name to whatever he/she wants. My initial thought was to have a "lines" table. This table has a row for each hour, segment, and contact. While there are numeric hour & segment fields for grouping purposes, the user-modified 'DisplayName' is to b…
-
- 1 reply
- 689 views
-
Recently Browsing 0
- No registered users viewing this page.