FileMaker Interface Features
-
Hi, I'm not an experienced developper, but I understand the logic of filemaker. I don't know if Filemaker can do this. I made some search and did'nt find any exemple about this criteria. I think that's a conditional Value list but not sure. I have a drop down list with several item to choose. If I choose one item, I would like to have a second drop down list of this item. Ex:. 1st --------------- 2nd drop down ------- Drop Down =============================== car ---------> Ford; GMC; Chrysler moto --------> BMW; Yamaha; Honda boat --------> Bavaria; Tobago; Carter First I made a Portal row with a dropdown list of my item. I t…
-
- 1 reply
- 1.1k views
-
-
I have to produce a report where the client's main logo is on the first page of a (potentially) 3 page standard letter layout for a range of found records. The logo I have placed in a Sub Summary (Leading) part, breaking by ContactID. This ensures that the logo appears at the top of the front page of each Contact's letter. Unfortunately if the letter contents span two or three pages I need subsequent pages of each contact's letter to show a "continuation" logo which differs from the main logo on the first page. Is this possible?
-
- 7 replies
- 2.1k views
-
-
Upgrade to Mac OS 10.4.11 (and Safari to 3) disables pasting into web fields. Info can be typed, but not pasted.
-
- 0 replies
- 1k views
-
-
I am trying to write a script whereby clicking on a portal row displays selects the correct portal row and displays only the for the corresponding record in another layout. Have to admit I'm beaten on this one at the moment. I've been thinking on these lines: Copy [select; Related.Table::Field( Get ( PortalRowNumber ))] Go to Layout Enter Find Mode Corresponding Field in related table The Get(PortalRowNumber) displays a dialog which shows the correct portal row is selected, but nothing seems to be copied or pasted. Any ideas please? FMP9 on MacOS X 10.5
-
- 3 replies
- 1.9k views
-
-
Is it possible to scale down the size of a how the web page displays via the web viewer?
-
- 3 replies
- 4.5k views
-
-
Hello, I would like to create a drop down list that the user can use check boxes to select the multiple values that they want... this is similar to whatis available in Excel's Pivot table. For example if I have a list of employees and the user wants to review the work performed by 3 of the 16 employees I wish to offer the employee list so the user can select the 3 employees of interest. regards,
-
- 1 reply
- 7.6k views
-
-
Is it possible in an upgrade script to import a user's customized value lists into the upgraded datafile? I appreciate whatever advice anyone can give me, thank you.
-
- 2 replies
- 1.3k views
-
-
Hello I know nested portals don't work, but 'nested portal' best describes what I want to do. (please move this post somewhere more appropriate if necessary) I've got database which tracks Primary Materials [color:yellow](table 1), Composite Groups made of Primary Materials [color:orange](table 2), and the finished product made up from Composite Groups [color:green](table 3). I'd like to see on one page exactly what a finished product is made up from. Hierarchically like this: [color:green]Product [color:orange]-Group1 [color:yellow]--Material1 --Material2 --Material5 [color:orange]-Group2 [color:yellow]--Material3 --Material5 Some Prim…
-
- 14 replies
- 10k views
-
-
In my database I have a university selection button that when pressed a new window with a portal opens in order to select the university. It works perfectly except every time I click on the button I get the impression that everything but the newly opened selection pane flashes white. It's very annoying visually and I've tried using the Freeze Window script but that doesn't change any thing. Does anyone have any ideas? Let me know if you need further information.
-
- 2 replies
- 1.6k views
-
-
I have a client tracking database in filemaker that keeps track of my clients. I have a tab that has a portal that keeps track of their criminal charges. Each row has case number and description. I would like to use filemaker to print my file labels for my client. The label will show what charges the client has. Is there a way to use the data stored in the portal to create a summary field that can be used on the label? For example: Client: John Smith Case Number and Description fields in portal: 07-M-123 DUI 07-M-124 No Insurance 07-M-125 Obstructing an Officer Based on the above portal, I would like my file label to show: DUI, No…
-
- 2 replies
- 1.1k views
-
-
Previously I have set up portals, about 8 rows each with scrolling, and they had grids. I forgot how to create a portal with those grids, and the help file doesn't yield much help. I know it's easy, but I plumb forgot.
-
- 1 reply
- 927 views
-
-
I have an events database that is the end users use to track invitees, rsvps and run reports. This is set-up to be a temporary holding tank for current events and then all the information is to be transferred to our legacy system. I have a table for all the invitees, a table for all the RSVPs and a table for all the events. I use a portal to show all the "active" events a person is currently invited to. As part of the regular clean-up of removing events from this file I need to be able to find the people in my invitee file who do not have any current rsvps. What I need is to be able to find the people who are in the invitee table who no longer have a related rs…
-
- 2 replies
- 1k views
-
-
Three tables: PERSON - one individual LETTER - one letter SENTLETTER - one letter sent to one individual If I am looking at a PERSON record, and I have a portal of all of the letters that should be sent to that person, can I have in that same portal the related "Date Sent" field from SENTLETTER so that it only comes up on those letters that have a related SENTLETTER record for that one PERSON record? I can't seem to make this relationship without making a global in LETTER and populating it through a script with the current PERSON Unique Serial. This should be able to be done, but I'm not sure how. Any help on this would be greatly appreciated. …
-
- 1 reply
- 1.2k views
-
-
I created a layout and on two records the sub summary field does not display and there are values in the two records affected. Anyone have any idea why this is happening and have any solutions?
-
- 2 replies
- 1.1k views
-
-
If I want to have a web gadget show up in a form using the web viewer, how do I allow the user to interact with it but NOT have a scroll bar on the side?
-
- 5 replies
- 2.2k views
-
-
I need to create a report that shows by month how many records are created and modified based on date fields. Not quite sure how to approach this? I how do I get FM to count something that is a date field. Do I have to create fields for every month? Jan-Dec? As you can see I have no idea how to get this off the ground. Would really appreciate some help my boss wants this info by next Wed. Hope this is not a difficult and involve process.
-
- 2 replies
- 934 views
-
-
Hey all, This may be a pretty dumb question, and I'm not sure of quite the right forum section this should be in, but I feel I should put this out there to those a bit more knowledgeable than myself. I have asked my boss to get a copy of filemaker 8.5 advanced, so I could have access to custom functions and other niceties for development purposes. She got us approved, however, she approved us for 9.0 advanced. We already have 8.5 deployed on several computers (about 7 of them), and upgrading all of them to 9.0 is probably not an option at this point. Now, here's the question. Can you develop solutions using 9.0 that are usable in 8.5? The only experience I…
-
- 2 replies
- 1.8k views
-
-
Hello All I need to use a web viewer but in my situation I would not like the scroll controls or ( scrollbars ) to show. Is there any way to set or script this to occur? Thank you Dave
-
- 1 reply
- 1.1k views
-
-
Vendor~LocationFiltered|VendorID| is my selection portal. The user selects one of the listed related locations which sets the global z_gSelectedRowID to the locations ID. Which in turn, displays that location within the LocationSelected portal on the same layout. Vendor~Location|VendorID| is the base table relationship. My question is this, I want to display the first Location record of the Vendor to Location relationship within the LocationSelected portal when the user navigates between records. This would correctly lists the first location for the vendor, but also allows the user to select another location with the selction portal with it's respective relat…
-
- 0 replies
- 1.2k views
-
-
I have a container field that my clients scan a document into. On the same form I have 8 other container fields. Is there a way to have "right click" add a print option or some way to print only one of the container documents instead of the entire form?
-
- 1 reply
- 1.4k views
-
-
Hi all My problem is getting the correct description field populated for a record once a another record is created in the portal. I have a portal that creates records in another DB. The description can be rather lenghty at time so the description for the parts are stored in a separated DB and retrieve through second portal using a script. The problem arises when the user start to enter data in the second record, this creates another record in the portal so when the users retrives the description from the second portal, the information in the first description field in the first record is over written or the description is placed in the last record leaving the second rec…
-
- 1 reply
- 1.2k views
-
-
I just upgraded to Filemaker Pro 9. When moving fields in layout mode, there is a noticeble delay and lag time when dragging and dropping, making it very difficult to place fileds accurately in their place. My computer is not running slow in other prgrams, including older version of Filemaker which is working perfectly in Layout mode. Any ideas?
-
- 2 replies
- 1.3k views
-
-
can anyone help tell me if they know how to make tcards for resource tracking system i am a beginner
-
- 1 reply
- 1.2k views
-
-
I am in the middle of redesigning my DB in to a separation model. So I made a table only DB and a GUI DB. I imported all my tables from my combined APP in to the new table DB. I then imported all my records. I have 22,500 companies, 18,500 contacts, 9,000 emails. The rest of the 45 tables have varying records from 0 - 500. My data displays properly in my current combined app. It displays properly in the GUI. But, when I try to access my contact names layout (172 fields) the Tables DB crashes. I thought, perhaps, it was too many fields on one layout so I broke it down into three layouts: Display Fields (Name, address, etc.) Container Fields Global &…
-
- 3 replies
- 1.3k views
-
-
Hi there We started to use a FMP solution for our contact data management. Therefore, I imported data from various excel docs and somehow together with the import of the contact data some style data was imported too. Means: when I go through the FMP database now the data appears in different styles on the layouts. Text in the field is sometimes grey, sometimes black, sometimes arial, sometimes some other lettertype. It hurts my eyes and it looks unprofessional. How can I force the data to be showed in the style I defined when creating the layouts? Do I have to write a script and let it run through the whole data mountain to remove text styles? Or do we have an…
-
- 1 reply
- 1.5k views
-
-
Can I import data from excel directly into a particular part of a repeating field. Example, a rainfall field defined as a repeating field with 365 repetitions. I want to import the 3rd days rainfall into the third part of the rainfall field, the 4th days rainfall into the 4th part of rainfall field and so on. Is this possible. Seems a simple thing to do, but no option appears when I try and import data to identify which element to place the data into in the repeating field.
-
- 1 reply
- 869 views
-
-
I have a database that lives on a web based server. My application makes extensive use of conditional formatting but I can't seem to make these colored formats visible on any of the machines except the one that generates the conditional format. Do I need to add a plug-in to make this happen, or is conditional formatting not compatible with server based solutions? For what it is worth, I can't seem to make this work with colored container fields either. Any ideas? Jarvis
-
- 2 replies
- 1.5k views
-
-
Did that make sense?? I am trying to clean up the look of my layoutss and was wondering if Filmaker had the ability to dispay the name of the field inside the field? i.e have it look a bit like the google search bar at the top of browsers - it says "google" inside the search bar, until you start typing. Anyone have any ideas if this is possible?
-
- 4 replies
- 1.5k views
-
-
I have created a layout with 3 tabs, personal info, work info and additional info. While entering the data, it would be useful to tab from the last field of the "personal info tab" to the first field of the "work info tab". Possible?
-
- 6 replies
- 2.4k views
-
-
Does anyone know if there is a way of opening the Manage > Custom Menus menu via a script? For example there is a script step: 'Open Manage Database' which opens the Manage database window without the use of the File menu. I would like to do the same with Manage > Custom Menus.
-
- 0 replies
- 1.2k views
-
-
Hello, I have a join portal where the majority of the fields are not in the table that the portal is searching from. That is the portal is connected to table join, and there is a field from the join table for company id; however, every other field in the portal is from the company portal. I would like the portal to sort by a field in the company table. How can I do this? When I choose the sort option, the only choices I have are from the join table. Thanks a lot for the help.
-
- 4 replies
- 1.5k views
-
-
I've inherited a Filemaker database that I need to modify. When I go into layout mode, instead of seeing the field *names* in the various field boxes, I'm seeing little advertizing blurbs like "Powerful Scripts!" "Customizeable Buttons!" Is this some sort of security/secrecy option the designer activated, or what? What's the point? How do I get the field names to show up instead? Thanks Wickerman
-
- 2 replies
- 1.7k views
-
-
Hi, I have two fields that are filled in from a drop down list. Once the user selects from the first drop down, the next field needs to be populated from a drop down with the "child list" of the first field. If the first field is changed, then the second field must have values from the related "child list" eg. first field drop down list is: North South second field drop down list is based on the first field choice as follows: If first field north, drop down shows 1a 1b if first field south, drop down shows 2c 2d I have this working except for a validation on the second field. I need to validate that the second field is populated with …
-
- 2 replies
- 1.8k views
-
-
Hello - I have a 4 col layout with a sub-summary part. If the body part goes beyond the bottom of the column it finishes at the top of the next column as you would expect. However, I would like the Sub-Summary part to repeat at the top of the column when it splits the body part. Is there a relatively easy way to do this that I am overlooking? I have attached a jpg to try and help better illustrate my question. Thanks in advance.
-
- 1 reply
- 1.2k views
-
-
I use a checkbox set to set the value of a field, 'x'. The value list for the checkbox is based upon another field's values. Let's say the other field's values are a,b,c, and d. The user has checked 'c'. Later the value list is different because the other field's values are now a,b,c, and e (d is no longer a field value and therefore no longer in the value list). The checkbox set is now a,b,c, and e. The user checks 'e'. The value of the field is now 'd,e'. The old value, 'd', that no longer exists is still part of the value of field 'x'. How do I get rid of the 'd' in the value of the field 'x'? If the field is displayed using the check box set, there is …
-
- 6 replies
- 1.2k views
-
-
Hey guys. I've sort of been thrown into this whole filemaker ordeal. I'd love some help with a problem I'm having. The database I set up is for recording work orders for our editors and assistant editors. The work order itself includes things such as job name, number, editor, assistant editor, producer, as well as time in/time out, overtime, total hours worked... that sort of stuff. Now, what I've set up is it will generate a time sheet for an entered week using the name of the person entered. It will search in both the assistant editor and editor field (because some people will assistant on some projects, and sometimes they are editors on others). Now, tim…
-
- 1 reply
- 1.2k views
-
-
I am trying to create a complex report where the dates are going to be changing every week when it is generated. (First monday for 6 weeks past the report date) I have the two layouts created so the user enters the Report Date then a button takes them to the actual report, but I have calculated fields that are supposed to fill in those future 6 dates. I have those working, but now I would like to view them in a subsummary report. I read in the FileMaker Advisor of a "Value list of fields" feature, but it doesn't specify how I would create it. Any ideas? Thanks for any help I can get!!!
-
- 0 replies
- 874 views
-
-
I have recently been finding useful ways of using tooltips . I have a use for one, but I just can't work out how to execute it. In one table I have a field showing a numeric value (a £ amount) and in a related product table I have products that have a retail price . I would Like the tooltip in the first table (sales) to show all the product descriptions that retail up to the amount in the sales field ie sales Field = £270 tooltip shows products (stored in Product table) that retail from £0 to £270 and not above. I'm not sure if this is too ambitious Any help would greatly be appreciated thanks
-
- 2 replies
- 2.7k views
-
-
I am having a problem seeing a jpg that I insert into a field. Not sure if there are different types of jpg formats, but I can get some jpg to show. The error message I get is "The file cannot be found:7.jpg." Any ideas or thoughts would be great thanks, dave
-
- 2 replies
- 983 views
-
-
FYI, this is my first post. Is it possible (using sliding perhaps) to have columns and their labels hide when the value of their summary is 0? Or even a way for the user to select columns to hide? I have hidden fields by sliding left but I have not been able to stop resizing of fields since this will put the field out of alignment with other fields set as part of that column. It's also nice, though not essential, to use center alignment. There may be some conditional formatting that does this but I can't find the correct option. Also, I thought about using the table view, but the one problem is that I need to label columns using rotated text-field labels (as…
-
- 0 replies
- 2.2k views
-
-
I am working on making a database for events that we get invited to. Some of them only happen once for one date, others are 3 or 4 days in a row, while others are all the weekends in october. What is the best way to store this if someone wants to go in and put in a date or date range and find out all of the events that are happening for those dates. Now that I am typing this I am thinking that the date and time should be in its own table? While the other event information is in anohter table. Any suggestions would be greatly appreciated.
-
- 1 reply
- 985 views
-
-
Using FM9 Advanced , I am trying to use a tooltip to display a (text) fields contents in a larger font size. I am using the TextSize function to display the fields contents in a larger font size but it seems to have no effect. Has anyone managed to get this to work? thanks
-
- 2 replies
- 2.5k views
-
-
I am currently trying to edit the tabs when using the Event Management Template. When I enter layout mode, and double click the tab, I am able to get into the Tab Control Setup, but all the options are greyed out except for cancel. Is there any way to either, edit the tabs that come in the template or delete the original tabs once I have copied them? (since I am able to edit the copies) Is there a button that needs to be checked/unchecked?
-
- 3 replies
- 1.9k views
-
-
Hi, I'm playing with the Tab object for the first time. Is there a script step that will navigate between the tabs?
-
- 1 reply
- 904 views
-
-
I would like to create 3 reports in [color:red]different language[color:red]s (German, French, English). They all display a date which I then format to display the name of the day and the date. However, since FM is getting he systems format (e.g. German) it displays it in German (e.g. Mittwoch, 21.Juli 2007). How can i get it to display it in all three languages (e.g. Wednesday, July 21 2007) each on a separate report ? Thanks for your help! Martin
-
- 2 replies
- 1.1k views
-
-
I have a detail report that breaks down sales by sales person for each day. My subtotals and grand totals fine, but the detail of sales for each day is missing every other record....any ideas?
-
- 1 reply
- 1.1k views
-
-
I have a State and County table set up for value lists on another form that I want to change dependent on the Value selected in the State field (via drop-down list). What I mean is that I want the counties value list to change dependent on the State selected. Well that part was easy, I have a table with State and County that has all the counties defined by state and a relationship defined to the main "Projects" table by the "State" field. OK here is my confusion...if I create the Drop-down List using Values from Fields on the "State_County" table it will list everything regardless of State. If I define the Field in the form displaying data from the…
-
- 4 replies
- 1.2k views
-
-
I have two FM9 DB's that are using FM9's server. DB "A" is used to store account information and has a portal which pulls data from DB "B". "B" has 110,000 records. "A" shows data in the portal for only 500 to 2500 related records from "B". I would like to add 26 small buttons in "A" so that the user can go directly to the portal data that starts with the selected letter. This saves a lot of time as opposed to scrolling. I would like all the related records to show in the portal and then they could click on the "M" key and go directly to the row in which the "NAME" field begins with the first letter "M". Any help would be appreciated. Thanks.
-
- 3 replies
- 1.1k views
-
-
I will be having an installation in a non-US (non-$) country. Is there any way to set the currency symbol for a given runtime solution? Is there a value list of currency symbols in RM to choose from? I see that in formatting a number you can specify the currency symbol, but short of finding all the currency fields on all the layouts and changing them one by one for this one (for now) application, I don't know how to change that. And I'm not sure the standard character set would have a lot of the symbols. And then I would be managing two source versions for any updates. Not a pretty picture. TIA
-
- 3 replies
- 3.8k views
-
-
I am a teacher and am working with reports for grading. Is there a method for having the field and border adjust to maximum length of contents? In Excel If I have a row, it will adjust to the maximum height of any one cell in the row. I am using a 3 cell row layout and need it size to largest of the 3 cells in the row and to draw borders around each cell. Thanks, Michael Perry :)
-
- 3 replies
- 1.4k views
-
-
I have a table that needs to have graphics inserted into container fields, but the graphics are from the Corel Draw Graphics Suite Application. The extension on the graphics are all .cdr and filemaker says it does not recognize the picture. Will I need to convert the pictures to a .jpg or .gif? Any suggestions on how to get the graphics into filemaker without having to do a conversion would be great. Please move this thread if it is in the wrong forum. Thank You!! :qwery:
-
- 2 replies
- 1.6k views
-
-
I've created an 8.5 reference lookup database for automobile enthusiasts containing multiple tables that I want to share on the web. To use the information I've stored requires the user to select a series of scripted buttons, one at a time, each selection taking them deeper into the database. Each selection provides more focused information until they've reached the particular part of the database they want to view. [i.e. button 1 - selects a year, which displays every make manufactured in that year, button 2 - selects a particular make, which displays every model manufactured by that make . . . etc] My question is . . since the user interaction requires active chan…
-
- 0 replies
- 1.1k views
-
-
Howdy, all: I'm creating a run-time solution where a user will be printing a report that has four different fields in it. What I'd like to have users be able to do is select the sort order without having them manually set it up using the Sort Field command/script step. The four fields are: Cost_Category, Cost_Type, Date, and Record_Number. Ideally, there'd be a pop-up menu adjacent each field with each menu having a value list numbered 1, 2, 3 and 4. In practice, the user would choose the order of the sort based on the value list selections, click the report's script button, and away she goes. Obviously, there's gotta be a better way than scripting for 24 …
-
- 0 replies
- 896 views
-
-
Hello, I’m very inexperienced with FileMaker and hopefully I can get some help here. I have 3 color families: - Blue - Yellow - Black The each color family has different shades. For example, for the Blue family: Lite Blue, Lite Aqua. For the Yellow family: Lite Yellow, Pale Lemon. For the Black family: Lite Charcoal, Grey. Each color family has a range of color numbers: - Yellow ranges from 2000 - 2999 - Blue ranges from 5000 - 5999 - Black ranges from 9000 - 9999 I have created 2 tables. The ColorData table and the ColorFamily table. ColorData has 3 fields: - Color Name - Color Family - Color Number ColorFamily lists a…
-
- 0 replies
- 1.4k views
-
-
I am a VB.net developer against Access and SQL Server. I am using FM 9.0 Advanced (30 day trial). One of my friend asked me to design a small system that needs to work on both MAC and PC. To start with Customer/Contact side, i have designed the tables and added the relations between Customer to Contact as 1 to many. I have managed to create a layout to customer and contact on its own. Now i need that same functionality on one screen? How do i go about adding a new customer and adding many contacts to that customer? Any help would be highly appreciated for a newbie for FM. Mitesh
-
- 5 replies
- 4.2k views
-
-
Hello all, Is there a way for a web viewer to scrap information within a frame? I tried using View Source in IE or Firefox and they returned well. However, while I did that on Web Viewer, it returned message that it didn't support the frame. I attached the full message about the error. Any help would be appreciated. Thank you. Archive.txt
-
- 6 replies
- 1.9k views
-
-
Hello, is it possible to scroll through/print the pages of a report in preview mode with the status bar hidden? I hide the status bar in our application and I can't figure out how preview reports without it. Thanks Rick DeCollo
-
- 1 reply
- 917 views
-
-
THE SITUATION I have a script that changes a value in a related field, which then updates the calced cost value for that record, which then updates an unstored calc in the the current TOG which is equal to SUM(related::cost). The script then checks the the SUM value to make it is greater or equal to zero, else roll back value etc etc. The SUM calc is on the layout the change button is located on. THE PROBLEM: The SUM field is conditionally formatted to turn red when less than zero. If this is on, when the script goes to check the value of the SUM, even though the layout has updated with the correct new number and it has turned red, any reference to that…
-
- 6 replies
- 1.7k views
-
-
What is a SIMPLE way to get a found count of records in a portal? Thanks for your help!
-
- 2 replies
- 1.4k views
-
-
Hello, Is there a way to script your user name and password to auto enter when using web viewer??? Thanks, Tom
-
- 1 reply
- 1.2k views
-
-
Say I have two web viewers on a layout, one above the other - is it possible to click a link in the top viewer and the resulting page displays in the bottom viewer? I'm guessing the target attribute needs to be controlled, but then think even though the viewers have object names, there's no way I can use that in html?
-
- 1 reply
- 1.2k views
-
-
Hi all, had no idea what to search for so again, please let me know if I am repeating stuff... I am trying to create a start page with 'buttons' and the idea is that each button will link to another file. Ideally I would like to run that independent file inside a frame of some sort so it seems like it is still part of the same file and so it makes it easier to return to the start page. One thing to note is that the linked FM files have password protection in them - not sure if this will be an issue or not... is this possible? thx.
-
- 4 replies
- 1.3k views
-
-
I am using a url shortcut to open a remote db hosted on FM server. I have both FM 8.5 and FM9 instaled on the clirnt machine. When I when i Click on the shortcut it opens the remote wirh FM9 but I want it to open with FM 8.5. I can't figure out hoe to change the default program. Any Ideas?
-
- 0 replies
- 1.2k views
-
-
Hello, I have a "text" field on my report that extends four page lengths. If the text entered fits one page, I only want one page to print, instead I get all four pages no matter how much text is entered into this field. I have done this in FM4.0, I thought I was doing it right in FM 7.0. I selected the involved text field,and selected the following; "format," "sliding/printing," "sliding up based on all above," "also reduce the size of the enclosing part." When I view the layout in layout mode, I do not see the arrows pointing up, which identify the field as sliding-up. Any help would be greatly appreciated. Steve
-
- 2 replies
- 1k views
-
-
I have two tables: (Insured, Policy) I have a portal on the Insured Table that Holds info for the whole record. The relationship between Insured Table and the Policy Table is one to Many. On each policy page I have a small recap portal of the one on the insured page (Basically all this is portal (same used on the insured table but with the field entry turn off) . This all works great. What I need is a way to make the recap portal on the policy page be able to be sorted differently on each policy page. Is this possible? Thank you, Joseph
-
- 13 replies
- 1.8k views
-
-
Hi - hoping someone can help here. I've created a number of Access Databases in the past, and now I'm trying to move off Windows onto Mac OS - so I'm trying to recreate my Access databases in Filemaker Pro 9. So I'm starting with a simple relational database along the lines of Author --> Book. I've set up the tables and relationships, and I want a Data Entry / Display form. I've created a form Layout based on the Author Table, with a Portal to show related records fomr the Book Table. But the Portal will not populate with records. If I enter a new record in the portal it creates the correct new record in the table with the correct index keys, but will not…
-
- 13 replies
- 1.8k views
-
-
Ok I dont use FM that much so please be patient with me. Plus I'm in fm6. I have an inventory db that I'm working on I have main category , sub category 1 and subcategory 2. I have so many main categories and sub categories I put them into thier own files. But I'd like to have the user pick from a pop down for main category and then the sub category 1 and 2 only show sub category data based on what the main category is. example pick main category > cars then Subcategory 1 shows > Ford , Chevy , etc, then Subcategory 2 shows > sedan, truck, van, etc. if there's a resource to read Id be happy to read it or if theres another post what…
-
- 2 replies
- 1.3k views
-
-
I have a script to add court charges to a portal, but I must first click into a field in the new portal record, then the script adds the info. It works great but how can I get the script to select the portal by itself? There are a total of three portals on the page. Thanks.
-
- 6 replies
- 1.3k views
-
-
I have a value list showing me times. The initial value in the field where the value list is attached is already set. I want the use to, when they click the value list, have the starting value be the same as the value that is currently entered into the field. For example: The field currently contains the value "11:30AM". When the user clicks the field to enter new data, they see a value list of all available times for the day starting at 6:00AM with 6:00AM being selected. Is it possible to have 11:30AM selected so the user does not need to scroll?
-
- 3 replies
- 1.4k views
-
-
i have 2 tables: eps and price. they are related together by date field. how can i have a portal in eps form that has 15 most recent related record from price table in itself? i do it by deactivating "vertical scrollbar" but when exporting to excel it export all related records.
-
- 1 reply
- 960 views
-
-
Hi everyone, I have a report using two subsummary parts for name and job. The report should summarize each name and the job should summarize totals for the jobs associated with that name. The problem I have is the parts breaking across page boundaries. The button is unclicked (allow part to break across page boundaries) so the name doesn't and the jobs don't, but I do get a name at the bottom of a page and the associated jobs at the top of the next. Is there a way to keep both subsummary parts together on the same page? I cannot pick an arbitray number of occurences because the number of jobs varies too much. I hope I have explained this properly. Thanks in advance …
-
- 2 replies
- 1.1k views
-
-
I have a DB that works OK, prints OK, but when you look at it in Preview mode, the font turns to garbage - looks like the Martian alphabet. Any ideas?
-
- 1 reply
- 1.3k views
-
-
Hi Everyone I'm sure this is an easy one - I just can't quite work my way through it at present! I've a database with 800 records, each containing images, film-clips and related data. I want to build a couple of introductory layout pages that will help users with no prior knowledge of databases (some of them will be school-kids) to orient themselves within the database and find various useful sets of data. Let's call them 'meta-layouts' for the moment but they're just Menu pages - there's probably an actual name for them. These "Menu" layouts will only contain a background image, text labels and buttons - and from them the buttons will use scripts to go to various ot…
-
- 2 replies
- 1.2k views
-
-
Hi Guys, Is it possible to have a custom dialog appear when a condition is met or exceeded? Steve
-
- 7 replies
- 2.3k views
-
-
Hi, I'm trying to print a list of multiple related records. The parent table "Case" has two related child tables: "Gross" and "Part" (Gross and Part are each related by "__kp_CaseID/_kf_CaseID"). Generally speaking, for each "Part" child there is a corresponding "Gross" child (however I have good reasons for not joining these to make one table). There may be any number of Gross/Part pairs related to "Case". Anyhow, what I'm trying to do is to print the following information: (Header) fields from "Case" (Body) field from "Gross" (Body) field from "Part" (Footer) page break The trick is that I want all of the child records from "Gross" listed seque…
-
- 1 reply
- 1.3k views
-
-
I have a number in a number field that is for US Dollars. How do I format the number to display as a merge field with two decimal places. If it is possible to have it do the dollar sign as well that would be great but I can just preceed the field with a typed in dollar sign. Thanks, Drew
-
- 8 replies
- 2.1k views
-
-
he's got a list for boolean values, X and NO, and i want to turn a bunch of fields within the record to a single value, a checkbox, and was wondering if there was an easy way to: 1) check boxes off using a script? It's easy enough to go through any field in a record and do an if = insert text to get one box checked, but how do i check additional boxes without unchecking the first? 2) make check boxes show up without their preceeding item, for making a schedule with all the records in list form with one heading per check item and just the x in the body of the list? perhaps a similar trick to my first problem with a second list with as many blanks as there are checks…
-
- 4 replies
- 951 views
-
-
I have a portal with such fields as PartNbr, Quantity, etc… What script would take me to the row that contains a specific PartNbr. For expl when I enter FV362 in a custom dialog box I want FM to go to the row that contains FV362 in PartNbr field. The Go To Portal Row script takes me to a row number. The Go To Field takes me to the right field in the portal but it sits in the 1st row.
-
- 3 replies
- 1.3k views
-
-
Is there a way to create standard headers and footers (one for portrait and one for landscape) to be used on almost ALL layouts without having to copy and paste it on all of them? If I create an header and "group" all objects together and copy/paste it on all layouts THEN if I do change something on one layout, I'll have to change it on all layouts... and there is quite a lot of layouts in our systems. The portal approach seems interesting but maybe there's another specific way to do so. I'm still stuck with FM 7. Thanks I still concider myself n00b :
-
- 2 replies
- 1.6k views
-
-
How do I set up a portal to print multiple-page invoices if the line items exceed the 1-page length? In the case of 1 line item, we would only want a 1-page invoice; in the case of multiple line items that require more than one page, we would need a 2, 3, 4, or 5-page invoice.
-
- 1 reply
- 1.3k views
-
-
Hi, I'm an Access user, trying to convert over to FM. I'm assuming this is an easy one, probably already covered, but wasn't sure. So, I have two value lists (combo boxes). I want to base one list on the other...showing the related items. In Access, this is done thru a "Lookup" command. The data all exists in one table, but I want to filter the results so as to not show every record, so a filtered list is the best as I can describe. Example: Table: Brand X, Product 1 (and on) Brand Y, Product 1 (and on) Brand Z, Product 1 (and on) Form/Layout List 1: Brand X, Brand Y, Brand Z List 2: Product 1, Product 2, Product 3 So essentially w…
-
- 1 reply
- 1.1k views
-
-
Is there a way to have a merge field (type = date) formatted depending on if the system date is on USA or Europe standard? I'd like to have this merge field format as mm-dd-yyyy if USA and dd-mm-yyyy if Europe. Also is there a get function that will tell if the system is USA or Europe? TIA
-
- 7 replies
- 2.5k views
-
-
Hi, FMP fans! How do I enable a portal so that I can create new records from that portal? I've done this on a db I created about a year ago, and now I can't figure out how to do it a 2nd time. The worst! -Conner Fenton is my hero
-
- 2 replies
- 5k views
-
-
I have a standard summary printout in list mode and in preview the horizontal lines are not parallel! Of course it looks terrible when printing.... anyone seen this before?
-
- 7 replies
- 1.6k views
-
-
This is my scenario: please, please help! i have database with two tables looking something like this. table 1 record - field1 - field 2 1 - 22 - 5,600 2 - 30 - 7,600 3 = 56 - 3,200 4 = 60 - 1,800 5 = 90 - 10,000 6 = 100 - 35,000 table 2 field = value f1 = some text f2 = 54 f3 = you noticed that f3 in table 2 is blank. what i want is to fill this field via calculation doing this: first sort table 2 (ascending value of fiels1) then; look for the record in table 1 which is equal or the first greater than to f2 of table 2 (54). in the case above it is 56 (record 3, table 1) and put the value of field 2 of that specific re…
-
- 9 replies
- 1.6k views
-
-
Can anybody tell me if it is viable to use an i-phone to interface with a database that lives on a web based server? I would like to do this with something more robust than IWP. I would like to have filemaker loaded onto the i-phone. Any ideas? Thanks, Jarvis
-
- 1 reply
- 1.1k views
-
-
Anyone notice that potals size differently in 9 than 8.5? In 8.5, a portal in layout mode can only be vertically resized by an increment equal to the number of portal rows (like repeating fields). In 9, you can resize a portal by a single pixel. Perhaps as a result of the Auto-Resize feature?
-
- 4 replies
- 1.1k views
-
-
Hello everyone! Can someone shed some light on how could I get a SINGLE report to show both the Fiscal (YTD) totals along side Monthly totals? The report I am talking about is really a Monthly report that our customers would get, but I'd like the report to show the Fiscal (YTD) totals for reference. Any ideas are extremely welcomed! Thanks in advance, J
-
- 0 replies
- 1k views
-
-
I have a solution that has portals that work fine on the solution I built on my desktop. But when I put it on the server (All 9 Advanced) the portals do not populate. This is a Sepiration Model solution if that makes any difference. Is there something you need to do with portals unique to the server? Milo
-
- 5 replies
- 1.3k views
-
-
hi. i'm using FM for the first time on my mac. i'm a musician trying to create a database of local schools so i can do a personalized mailout. i want to choose whether the script is sent either to the head teacher or the music co-ordinator (and occasionally letters to both). can i have the two contacts in one school file, and then select which one i want to use for the mailout by editing the layout? or do i have to create a separate related file for additional contacts? i have read the manual, but being a musician, it's little technical. many thanks!
-
- 1 reply
- 1.1k views
-
-
I am setting up a new database for tracking lecture evaluations. Each month, 5 lectures are scored on each evaluation form that is turned in by that month's group of students. (The eval form lists the 5 lectures and there's a score assigned for each one.) I created a table for evals and a table for lectures. They are related by month. Evals has a fields LECTURE1, LECTURE2, etc. Lectures has the month, speaker and topic. I need to display each speaker's scores for their particular topic. I created a Calc field in Lectures called SCORE that uses Case function to display the score from the corresponding lecture. I then created a portal in Lectures to display t…
-
- 5 replies
- 1.4k views
-
-
I am using tab control in one of the layouts but when I switch to another layout and back again, the visible tab has changed from the one I had open. Why is this happening? Further to this, is there any way of controlling which tab view shows when using a script? For instance, when running an error-checking script, can it direct the user to a specific tab view in a layout or does it just go the layout and the user has to figure which tab window is to be corrected? I can’t see any options/preferences in the software. Martins
-
- 5 replies
- 2.3k views
-
-
Sorry if this is a very newbie question, but I've been looking everywhere for the answer but have yet to find it. I have text field with varying data length. I would like a layout report to print all of the text in the field. In Access there was a "grow" function that allows the text to expand down the page if there is too much (rather than disappear). Is there a filemaker function that will do this for a particular field as well?
-
- 2 replies
- 2k views
-
-
Hello all, I’m trying to relate two database tables, “Movies” and “Movie Clips.” I’ve created a portal in “Movies” that lets me look at “Movie Clips” that are related to that movie. It works great. But I’ve also created a portal in “Movie Clips” that’s supposed to let me look at “Movies” – so that I can note if a clip is drawing on footage from two different movies. Ideally, I’d be able to say that a clip is spliced footage from Movie A, Movie B, and Movie C. But, I’m having problems. I’ve got the portal set up so that it lists the Movie ID # and Movie Title in the portal in the Movie Clips table. I can log one movie into the portal, say, Movie A (Movie ID…
-
- 1 reply
- 948 views
-
-
Hello all, I created a columnar list report layout. Now, what I want to show the user is the total number of pages. In the footer, I have a page number symbol with the word "Page" in it. When I click preview mode, it reads Page 1. The report is actually 3 pages long. I want it to say: Page 1 of 3. How can I get it to show me the total number of pages in this report?
-
- 7 replies
- 2.1k views
-
-
I'm working on a database that I already have setup using a filtered portal. I think viewing the data would be better if I could filter again. Basically I'm trying to filter down the number of tracks in a portal first by having the user select a year, and then a group. I have the year part figured out but it gets a little complicated for me to understand the logic in how to filter again. First off is it possible? If not, then I'm just hitting the wind. Secondly, would I use some sort of the same logic as I did for filtering years? I've attached a picture of the portion of the database that I'm talking about. jon
-
- 2 replies
- 1.2k views
-
-
Hi, (this may belong in the print section, but since it involves a layout I posted it here) I have searched most of the day and can’t come up with anything close. Is it possible to have a report layout to print only the fields that have data in them? (if you know of post explaining this, could you tell me how you searched for it, I tried inserting all operators into the search and still could not find anything). Thanks, James
-
- 5 replies
- 1.2k views
-
-
I have a value list in my database with various choices and one of them being flower essence. I would like to know how I can insert two fields that would allow me to type in the type of essence ordered and the date it was ordered when I choose flower essence from my value list. Any help is greatly appreciated.
-
- 3 replies
- 1.2k views
-
-
Hello, I have a database that handles a slew of "running totals" (for argument's sake, call it 'calories consumed'). Let's assume, in this database I have 8 people listed, and I have all their calories for each meal during a week (21 in total). If I want to have a portal that shows each of the 8 people, with the total calories consumed (i.e., the total from the most recent record), *sorted* in descending order of total calories - how would I be able to do that? When I set up a typical portal, it seems to pull the data from the first record in the database; not the most recent (which contains the information I need). I'm using FM 5.5 -- it seems like th…
-
- 5 replies
- 1.3k views
-
-
I've got a Class Registration database. Tables Students Classes Registrations Payments Registrations is a join between Students and Classes and a one-to-many with Payments. I'm trying to create a balance sheet for a class that will show all the Payments made towards a Class, sorted by Student with a summary of those Payments. Right now, I've got a layout based on Payments. I GTRR from Class to Registrations to Payments and sort by student name. The total is in a summary field showing amount paid. That's almost fine. Students can register for a class without making a payment. So the "Balance Sheet" won't show any of those students. I c…
-
- 3 replies
- 1.2k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online