FileMaker Interface Features
-
Solution: Simple Trick - reason to use a transparent button instead of field as button Description: If you select a field or group of fields, and assign a button function to those fields, they are no longer available for use in BROWSE or FIND. A transparent button over the fields, restricts the use of underlying fields for data entry (browse) but DOES allow them to be accessible for a FIND. This FIND is not available, if the fields are the buttons. keywords: button transparent find data entry Working Under: Solution Status: Finished Pre-requisites: Author(s) KirkR Date: 06/25/08 Credits: Instructions / Other I…
-
- 3 replies
- 1.4k views
-
-
So i found how to lock the status area, but how do I run the script when the database is opened? I don't know how to make a startup script
-
- 1 reply
- 1k views
-
-
Hello all, I would like to know if there is any websites that provide nice and good looking icons for database? One of them that I found was http://www.wpclipart.com/index.html (I believed this is a free one - public domain image) I think making a good looking database with nice icons would be a positive thing for a layout design. -) So, if anybody has experience in using some icons from websites, please share them with us :-) Thank you... :-)
-
- 7 replies
- 9.3k views
-
-
I've created a runtime application for which I created the help files as a small website accessed locally. The problem is (mainly on XP, not on VISTA or the MAC) when the user clicks the help button it will not launch the browser. Because the help files include narrated video help files, they would not fit properly in the internal browser. This is probably a security setting that preventing the browser from launching. Does anyone know what and where that setting can be changed. As I stated earlier, it'a mainly on XP and not on all XP. There is no rhyme or reason. On some XP SP2 it works on others it doesn't. Same with SP3. On VISTA it works and also on the MAC OS it …
-
- 0 replies
- 1.1k views
-
-
Hey, Is there a way to make the Part Definitions "buttons" display vertically instead of horizontally? I thought I had seen them that way before but I can't find a way to do it. Having them lay horizontally takes up a lot of room on my layout. Thanks - M
-
- 2 replies
- 1.2k views
-
-
I have been doing databases for a while, and one of the things I have not mastered is how I can run a calculation to determine the size of a popup window? I know it can be done, but how do I do it so that I don't have to continually go back and forth trying different sizes (Manually)? Any help is appreciated greatly! s.
-
- 1 reply
- 1.2k views
-
-
Is there any way to display portal fields in a <> text or a text field?
-
- 22 replies
- 3.2k views
-
-
Hi I need to add "audio file/ audio" icons to a FM file that I'm building, and just want to know where I can source them from. The FM file must have a professional look and I need a variety of sizes. Something like the icon that appears on the screen of an iMac when one increases or reduces the volume. cheers
-
- 3 replies
- 2k views
-
-
My portal does not show records created in the original table, But when creating records inside the portal they do are created in their related table. I want the portal to show records from the related table and keep updating as more records are created in their related portal. I thought that that would be simple but aparentely and i dont know what i am doin wrong.
-
- 3 replies
- 1.4k views
-
-
Hi, I'm trying to get a dynamic portal sort to work and it just won't. I've got a global field in table A and a calc field in the table B. THe global holds the name of the field I want to sort on. The calc is a case statement that calcs the field on which to be storted based on the contents of the global field. I've made sure that all the case statements result in text. THe portal is sorted on the calc field. I have buttons set up outside the portal that set the global field using the Set Field script step. But the portal is just not sorting right. It will change the calc field all the time, but it won't sort by it. WHy is that? If I go in and manually change the so…
-
- 2 replies
- 2.3k views
-
-
Just in case somebody hasn't already created one . . . * 30 easy puzzles * 30 moderate puzzles * 30 hard puzzles * Error checking * Unlocked / Full Access Soduko (external link due to file size 1.5M) I originally designed it with 81 Web Viewer cells for animated gif's, but it was just too darn irritating. A full 2-3 sec load time before the animation would start! So I scratched that idea and just went with static images. For anyone who missed my previous game posting you can find SpaceInvaders here: ThePost I appear to be the only nut making games in FMP, but I'm enjoying myself and have appreciated the positive feedback I've rece…
-
- 8 replies
- 2.7k views
-
-
My database is set up so that most of the data entry is done with the num pad. I have all the fields set up to move to the next field when the Enter key is pressed, but for some reason, I can't press FMP buttons like that. I'd like to use it for data entry. The user enters the numeric data, hitting Enter each time. When finished, the last time they hit Enter, it goes to a button. They should then hit enter again to push the button (starting a script), and prepare to enter the next record, but I can't make FMP press the button with the Enter key (the Return Key works just fine). It's not like it goes to the next field (like Tab does) either. It just, well, stops…
-
- 6 replies
- 3.3k views
-
-
I have a portal and I like to have Tabs inside the portal. It seems that the Tab can not be inside a portal on every portal row. Is their any workaround?
-
- 1 reply
- 1.2k views
-
-
I have duplicate records where one records has data in it and the other has "?" in all of the fields. When I try to delete the bad record, it doesn't actually delete. Any suggestions?
-
- 1 reply
- 1.2k views
-
-
I have a database of companies with a dropdown field ("Status") that lists their membership status as Active or Inactive. I'd like to conditionally format so that the "Company" field goes grey when the user selects Inactive from "Status". My mind's drawing a blank, here - any help appreciated!
-
- 2 replies
- 1.8k views
-
-
Hi There, I've been working on developing a FileMaker solution for a couple years now. I've done all of the research I need to do to make everything work data-wise, it's in about 40 different pieces (from me trying to make each piece of the puzzle work without messing up something else!). What I'm designing is a student information/administratio n system that manages all of the course selection, scheduling, etc. By no means is this a small task! I'm kind of stumped when it comes to designing a layout/GUI that works for the application. I've played around with a few different ideas as far as design goes and I'm not really satisfied with how it looks. I'…
-
- 2 replies
- 2.3k views
-
-
I have a drop down list that is reading from a value list. For some reason, the drop down list cuts off text on the right (the drop down box is too small). Previous drop down lists I've created have always been big enough to read all the text in the drop down list. Does anyone know how to control the size of the drop down list box? Thanks, Patty
-
- 5 replies
- 6.8k views
-
-
This url shows up in FM Web Viewer: http://www.filemaker.com/help/MacTOC3.html This url defaults to another FM help site page using FM Web Viewer, but works in a Browser: http://www.filemaker.com/help/02-Adding%20and%20view31.html I suspect the % in the url. Is there a work around? Thanks Steve
-
- 3 replies
- 1.7k views
-
-
Hi I am trying to create a portal which displays the current found set of records with an alphabetical sub-title (see attached example file). So far I have managed to get the portal working via a relationship to display the current found and have added an additional 26 records to act as alphabetical sub-titles. However I only want the relevant sub-titles displayed when their are corresponding records. I'm sure this could be created via a series of calculation key fields and relationships but have not managed to achieve it yet. Any thought on a simple and elegant solution would be most appreciated. portal_list.zip
-
- 4 replies
- 1.7k views
-
-
I have a portal of Contacts that displays as intended on a Company layout. However I want to be able to display checkbox options as a matrix across the portal so for each row the checkboxes are displayed without text - the text for each checkbox is used as a column heading on the layout outside the portal. Can this be done & if so how. Thanks
-
- 2 replies
- 1.4k views
-
-
[color:red]Can someone help or point me in the right direction? I'm trying to make a Drop-Down Menu, Check List, Pop-up Menu, etc... that creates a condition for a resulting layout. For example: If checked/selected Client, then display "Client" layout. If checked/selected Prospect, then display "Prospect" layout. I think it's possible... if it is can anyone point me in the right direction? If one were to enter info as a Prospect and change it to a Client (later down the road) could I get information to transfer to the Client layout fields or would I have to make a "Lookup Function" or a script? (I.E. [set Field [Clientes::Companía; Prospectos…
-
- 7 replies
- 1.7k views
-
-
Hi folks, i am really really new at filemaker developing and have a few questions regarding a database i am working on. I need to have a required step when opening the application. when opening i need the application to force the user to a layout requiring them to enter "sku" numbers into fields as returns, then process those returns before being allowed to move into the general application. I am completely lost as to how to do this. can anyone help me here?
-
- 1 reply
- 1.1k views
-
-
I have a basic field layout that I want to put a drop down box that shows certain scripts in it. I have say 30 scripts in the scriptmaker but only 5 that i use alot. So I would like these 5 scripts in this drop down box. So when I want to perform script 1 on record 99 I can pull down script 1 from the list of 5 scripts. I do not know how to set up a button/edit box to do this. Any help would be great/ Thanks
-
- 7 replies
- 1.3k views
-
-
I have a value list that is created via a table. The user needs a way to set the value back to nothing (null), after accidentally selecting a value from the dropdown list. How do I do this? I don't want to add a fake record to the table - and even then, the dropdown wouldn't be putting a null value back in that field... I can't allow them to type into that field (and therefore, be able to blank it). (This problem is related to my post: http://fmforums.com/forum/showpost.php?post/295804/) I'm hoping this is an easy question, and everyone will jump at the chance to give me that easy answer. : Thanks, Joni
-
- 4 replies
- 1.7k views
-
-
Phone Table contains Extension, Type (Phone or Fax) and Availability fields. I originally input data by Extension (primary key); however, on a related form, I want to filter the portal by Availability, sorting by Type. The portal works with the exception of the Sort Portal Records option. The records are still sorted by Extension. I tried sorting the underlying Phone table, but that did not affect the order of the portal. Is there a condition that causes a portal to ignore the sort specifications?
-
- 2 replies
- 1.1k views
-
-
I am working for a filmfest where we are going to develop a day to day calendar based on start time and end time of the program. The only part i need help with is to develop some way to arrange the movies and special programs so that it is arranged in a grid. The boxes must display information about the movie and tech info. The database in which the information will be inputed into has already been built. The only thing i need to develop is an external database that shows a day to day grid for everything going on. Also, to make it even harder, it all has to be in FM6. I have been trying a lot of things (related fields, etc) and i have drawn up blank. God S…
-
- 4 replies
- 1.2k views
-
-
Hi there, I am looking for a way to open a website in an external browser window (Firefox or Safari) and tell Filemaker to fill in one or more fields in this website. Unfortunately, it is not as easy as in other cases. The URL doesn’t show anything about the things that went into the website’s fields. So, something like „http://finance.yahoo.com/q?s“ & Company::StockSymbol won’t help. (The website I’m talking about is www.genios.de and the appropriate field is DB-Name oder Kürzel on the left side.) Your help is highly appreciated. ☺ Mike
-
- 0 replies
- 1.2k views
-
-
How to make a field linkable? I read this could be done, but I can't manage to find the answer. All I need to do is have the cust_name field jump to another layout. Will the linkable field work in Table View? Will it work with Instant Web Publishing? Thanks everyone.
-
- 2 replies
- 1k views
-
-
I am trying to figure out how to allow the user to click on an uneditable textbox and automatically change focus to the dropdown box next to it, and display the list of items. Background on why I want to do this: I have a large value list that is created via a table. In order to easily scroll through the large list, I have the value list displayed using a dropdown box on the page layout. But, because dropdown lists can't display the second value after you select an item and it would only show the id number for the item selected, I have another uneditable text box next to the dropdown box to display the second, text value chosen from the dropdown box. On the lay…
-
- 1 reply
- 2.3k views
-
-
I have a table named Purchases I have a table named PurchasePortal; it has only one field: Date, linked to the date field in Purchases It has a portal which I want to use to filter purchases as of...date or between dates When I enter a search criteria in the Date field I get an error message: "The value of this field must be a valid date in the range of years 1..4000 and should look like 12/25/2003" I guess the problem is that I am not in the "find" mode??? Help is much appreciated
-
- 4 replies
- 1.8k views
-
-
Hi, Can I define a repeating field in a script ? Like how we define the array ? I will have different number of values each time. I want to count the values .. say 3 array[1]=aaa array[2]=bb array[3]=cccc then use the values from array. The number of values will vary each time based on how many products the customer orders. I know we can define the repeating field in the table, but is it possible to define this kind of variable and assign the values in the script ? I know that we can get the values from the repeating field using GetRepetition(variablename;#) or just variablename[#] But how do we define that in a script and assig…
-
- 2 replies
- 1.5k views
-
-
I have 5 tables, all related 1 to 1. I want to display a conditional Value List for Practice Groups filtered by Dept category. If I use an Edit box for the Practice Group, it works. However, the attorney may be a member of more than 1 Practice Group. As soon as I use a Portal (instead of an Edit box), the Value List no longer displays for New records. Records that already have a Practice Group(s) assigned display (and can change) the Value List correctly. I have attached a sample with junk data. What am I doing wrong? Thank you in advance. ConditionalValues2.zip
-
- 1 reply
- 1.1k views
-
-
I work in a lab and am creating a database where we can store all our information. I have two lists on completely separate layouts, but when I press the new or delete button on one list, an entry gets added or deleted on the other list as well. Is there a way to separate them so I can have them run independently? I've named all the parts of the list different names so they aren't calling the same information. However, both add/delete buttons on either page both run the new record/request script. Is there a way to make this script NOT universal so it only adds a new record on the page I'm viewing?
-
- 11 replies
- 1.7k views
-
-
Hi guys! In order to protect my database and to force users to use the buttons on the interface to close a window (as there are scripts behind it of course), I would like to restrict user access to the default Windows or MacOS buttons to close a certain window. However, my main concern is, when I restrict access to menus from the priviligesets: 1. the default OS buttons are still accessible and 2. the copy/paste function is no longer available (they should be able to copy text from other applications if necessary) Any suggestions on how to resolve this? Isabelle
-
- 4 replies
- 2k views
-
-
Hello I have not been able to make the 'go to portal record (last)' command work with the web version of Filemaker. The script that is executing this command is executing from within the portal and I am preceding this command with a 'go to object' command, which references the portal I am referring to. It always ends up at the first record in the portal. Any ideas? Joe
-
- 5 replies
- 1.5k views
-
-
Hi I have a database of records (songs) that for which i need to add keywords that describe each song, e.g. "melancholy", "dark", "romantic", "driving", "ethereal" etc. Each keyword has a checkbox next to it. I want to create a field that lists out the checked keywords, e.g. "melancholy, romantic". Is there a way to make this calculation field? Thx:)
-
- 17 replies
- 2.4k views
- 1 follower
-
-
Howdy all! I got a simple question. Can you restart the numbering (@@) for every sub summary? For example: Fruits ( in sub summary part ) 1. Apple 2. Mango 3. Banana Animal ( in sub summary part ) 1. Dog 2. Chicken 3. Horse Every time, it has new sub summary "subtitle", it would restart the number (@@). Is there any option that I should choose? Thank you in advance for comments and suggestions :]
-
- 8 replies
- 1.2k views
-
-
In order to avoid popups in Value Lists, yet display foreign key field rather than primary key, I figured out the drop down menu covered by a non-enterable edit field (thanks to a forum answer) in a simple 1-to-1 relationship. However, I can't make it work in a 3 table relationship where a Popup Menu works. An Employee table holds all employee names and logins (primary key). Attorney and Secretary tables hold fields unique to each. Both tables are linked to the Employee table by login. If I display data from Attorneys:SecretaryLogin by using Popup value list pulling Secretary:Login, and foreign key field from Employees:Fullname, it displays the secretary …
-
- 2 replies
- 1.3k views
-
-
My table includes a category field. The records are sorted by category. When I display the records in a Portal, I want to display only the first occurrence of a category. Is there a way to hide a field if it is the same as in the previous record? Records may be deleted from the portal, which could change which record needs to display the category. Is there a (better) way to do this? Thank you.
-
- 4 replies
- 3k views
-
-
I am trying to get a portal to display the label from the related table(s) and it keeps displaying the value/pk. The drop down select box to pick the record shows the correct label, but once selected it displays as the value. I've attached a screen shot that I hope may help see what I'm trying to accomplish. Any input would be greatly appreciated.
-
- 4 replies
- 1.4k views
-
-
I'm new to Filemaker so bear with me if my question seems simple. Here's the situation: I have a table that is being used to process receipts. Each receipt is recorded on a single record, but may be accounted across multiple accounts. Is there an easy easy way to create a layout or report for each account that will pull the proper information out of each record? For example, let's say I spend $200 on computer supplies from Computers, USA on July 1. Of that $200, $100 went to overhead, $50 went to printing costs and $50 I charged to a project I'm working on. How can I process all of that information on one record, so that I can sort my transactions by da…
-
- 3 replies
- 1.1k views
-
-
I'd like to send the java script: javascript:NextPage(1) to a website from the webviewer. Is there any way to send this via post url. Thanks in advance
-
- 2 replies
- 4.9k views
-
-
I hope this is the right place to post this ... Field A calculates a value based upon a related file. It will not update unless I click on the field and then, only for that record. Field B is a summary field totaling field A. It will not update even when field A's value changes as above. If I do something like redefine field B, then it updates, but not by changing field A values. Any help will be greatly appreciated. Thanks.
-
- 1 reply
- 1.1k views
-
-
Hi and Thanks for any help. I currently have a value list based on field contents, and I use that value list as a custom sort order in the sort records dialogue window. Lets say the values are January, February, Mar... thru to December. My records are then sorted in this order. Problem is I want to change this sort order regularly. I may want to sort by March, then July, then October, then January and so on. Currently I have to edit the value list every time to customize the sort order. I would like to have "handles" on the value list entries so I can drag them up or down the value list, thereby changing the sort order. Is there any way to achieve this? Or is th…
-
- 0 replies
- 1.2k views
-
-
I want users to be able to delete records from a portal which is on a tab panel. The delete button also does some checking for certain situations with the related records. When the script is complete and the user is returned to the original layout the 1st tab is always reactivated. I get why it does this, the question is how to ensure the user is brought back to the original layout and tab. Right now I've got a script written to take the user from the 1st tab to the original tab. I know this is a kludge! Suggestions for the RIGHT way to do this. I put up a screen shot of the script as is.
-
- 3 replies
- 2.5k views
-
-
Hello I have an image file in a global container field for a FM web-based layout. The problem is that the image displays properly in the Filemaker client, but it does not show at all in the Filemaker web version of the same layout. Any ideas? Joe
-
- 0 replies
- 1.1k views
-
-
I applied CF to a field. I had a few scripts that would end with script step "go to field". After applying the cf, A user stated her button wasn't leaving her in that field as the last step anymore.. the script ran and ended it but didn't perform the "go to field" step. I tried, Insert calc.. just to leave cursor in that field, I tried set selection, insert text. Finally the only thing that I was able to do was name the field as an object and then use the "go to object" step. Anyone else encounter this?
-
- 6 replies
- 1.8k views
-
-
I am building a New Hire form. Based on the position of the new hire, I need different fields. Is there a way to make certain form fields active/inactive based on the contents of another field? Thank you.
-
- 3 replies
- 6.7k views
-
-
I'm putting together an alphabetical guest list. Sorting the guests names is easy, but what I'd like to do is setup the report so that it creates a line break at each letter. See below. How can I do this? J Jacobs, John Jenkins, Chuck Jones, Ed K Kelly, Peter Kramer, Ted
-
- 7 replies
- 1.5k views
-
-
I have a Line Items file. Each record is a product. Each product is in a single category. There are 6 categories, 900 products, and 60,000 records. I'm looking to create a report of a found set, sorted by category, showing the number of products in each category, AND sorted by the number of products in each category (in descending order) The report should look something like this: CATEGORY A Product1 1200 Product3 1150 Product2 1100 ... CATEGORY B Product500 1500 Product150 1000 Product200 890 ... CATEGORY C Product750 2000 Product10 1500 Product151 1000 ... Note the…
-
- 5 replies
- 1.4k views
-
-
Hello and thanks in advance for your help. I have a radio button (SaleChoice) with 3 values. I'm trying to find 'Price' determined by which of the radio values are chosen. I'm using this code but I get the error.."This field (FixedPrice etc) not found" Price = Case( SaleChoice = FixedPrice, Price1, SaleChoice = ReverseAuction, Price2, SaleChoice = Purchase, Price3 )
-
- 1 reply
- 1.1k views
-
-
we are a post production facility and keep a database of every commercial we make. they are stored on dat as well as wavs and high rate mp3s on an attached drive. i'd like to have the database listings (see attached picture) linked to the actual audio files so i can simply click on a title to hear it. the caveat is that i don't want to embed (if that's the right word) the files into the database or it would become unnecessarily large, i simply want to have the title of each commercial pointing to a location on a hard drive. is this possible?
-
- 1 reply
- 1.1k views
-
-
Hi I'm building my first database in FM Pro 9 and have the following problem: I have two tables. The first contains contact names and uses a drop down value list with hard coded options to determine the type of contact (client, supplier, staff etc). What I'd like to do is populate a drop down value list in a second, related table only with the contacts from the first table that are defined as suppliers. Could somebody give me some pointers on how best to achieve this? Thank you.
-
- 2 replies
- 1.1k views
-
-
I am using a checkbox list to select multiple items from a value list in one field. I then want to have an automatic calculation that applies different numerical values to the selected items and adds those numbers up to give a final score. It is used to calculate a person risk of complications from an operation. The more risk factors they have the higher the final score, but some risk factors have a greater weighting than others, hence the different values for each item. Should I use a checkbox list or individual fields for each item in the scoring system?? Thanks in advance David T
-
- 7 replies
- 2.2k views
-
-
I have my db set up to handle expenses. I have the main table, "Expenses" and a related table, "Expense Items" The Expenses table is the entire invoice/receipt, where as the Expense Items are each individual line item on the invoice/receipt. I thought about using the tab feature to separate my expenses. One tab, credit cards, the other tab Invoices, etc. Question...does that sound like the best set up for what I want? Any suggestions or advice would greatly appreciated. Thank you, Mary
-
- 1 reply
- 960 views
-
-
Hi there, Does anybody know how to get rid of the little black indicator strip at the left side of the window when in list view? I don't need it, but as I give my users no access to the status bar on the left, it makes the screen "jump" 2 pixels back and forth when switching from a Search layout to a Results layout. Sure, I could add 2 pixels on the left side in the appropriate layouts, but then I'd have the same problem with those users who are allowed to use the status area... Best regards, Mike
-
- 2 replies
- 1k views
-
-
Hi fellow developers. I have created a subsidiary database for testing out my layout and scripts. They have been tested and finalised. The question is: How can I export these layouts and script to my original project which is in a different file? I understand that records can be exported, but is there a way to export the layout and scripts? *Rewriting the script is an unlikely option because the script is extremely long. If anyone may, please advise me; or email me at [email protected] Regards, Ah Lee
-
- 2 replies
- 958 views
-
-
I've attached a file showing basic worksheet I'm working on. These repetitions will pre-fill with statistical data and also allow User entry. There are 5 portal rows side by side. The child records are one per year (as specified in StartDate plus numb_months (the number of months to jump ahead). Records are then created which span this period. There will be NO need to ever report on these worksheets. If the block being displayed is between (and including) the start month/year and the end month/year, I would like the repetition to turn white so it is clear what period of time is 'predicted.' So in 2007, January - April will remain grey but the remainder of 2007 …
-
- 30 replies
- 5.4k views
-
-
This is a stupid question. On my layout, it shows the white behind it as paper size? Although I already have objects off the "white" I cannot move objects off the white. When I try a "circle with a line through it" shows up. Something has changed because it never did this before. What has changed and how to I put it back? Thanks
-
- 2 replies
- 1.1k views
-
-
I use a long calculation field to produce a text report from multiple fields. I use a header and footer on each page, and often the text at the top of the page at a page break is "clipped"--I can see the bottom 1/3 of the first line of the text. There is plenty of space on the first page/layout, but on some subsequent pages, a part is clipped off. A vexing problem--any ideas? This happens in Preview and when printed.
-
- 1 reply
- 1.1k views
-
-
I know this is a longshot, but .. on a lark, I figure lets ask. I have a membership renewal form that is PDF, is there any way I can import this thing as a layout template, so I can use it as a report for printing and screen editing? The source of the form is a Word file. Otherwise it's a long weekend of fooling with layouts.
-
- 1 reply
- 908 views
-
-
I have been trying to find an answer to this question? Up to this point I am stumped. I have a list of words in a global field. I want to get the line number of the location of word based upon the location of the cursor in the field. For example, if the list showed: carrot celery broccoli spinach and the user had their cursor next to the word broccoli the computer would return 3 for line number 3. I would appreciate any help I can get in this matter. Thanks, Toby
-
- 3 replies
- 1.5k views
-
-
[color:purple]Issue: I created a DB for 5 different end users and when I opened the DB on their computers the layouts were either too small or too big to fit their screens. I had to individually re-size each one to fit their screen. Does filemaker not automatically adjust the layouts to fit multiple screen sizes? Is there an option I need to configure?
-
- 6 replies
- 1.6k views
-
-
I'm using google charts API in a web viewer and all my charts keep aligning to the left... anyone know what I need to do to the code to make everything align in the center of the web viewer... the titles keep getting cut off when they're too long. Code Sample: "http://chart.apis.google.com/chart?chs=320x240&&chco=4d89f9,c6d9fd&&chd=t:" & ass_running_records::rr_MinReadingAge & "," & ass_running_records::rr_MaxReadingAge & "|" & ass_running_records::rr_ageRangeLow & "," & ass_running_records::rr_ageRangeHigh & "&&cht=bvg&&chtt=" & ass_running_records::rr_FoundGroupTitle & " &&chxt=x,y&…
-
- 0 replies
- 1.2k views
-
-
Hi, I hope this question is in the right place. I am using Filemaker to create a database of unique identification numbers for individual study animals (turtles). We mark individuals by notching the shell in unique locations and assign numbers based on how many notches there are and their location. What I would like to do is create a series of checkboxes that appears on each record entry, and have each checkbox associated with a value. Once I check a box I want the individual ID field to add up the numbers to generate the unique ID code for that individual. I played around with value lists and scripts to try and accomplish this, but it didn't produce the re…
-
- 8 replies
- 1.9k views
-
-
I am trying to use the webviewer to look at a folder on a mapped drive. It works well, but when I try to open a picture in that folder, i get the following IE error message - running a system command on this item might be unsafe ... i can continue and it launches it - but it is just annoying.... I played around with security settings and the only way to I found to eliminate it is by enabling the 'launching programs and files in an IFRAME' for the Internet zone, i tried adding that mapped drive to my trusted sites and i worked with the settings on the local internet. Only enabling on the Internet zone does the trick, but it causes IE to warn me every time i start a browser…
-
- 0 replies
- 1.1k views
-
-
I am working on a very simple database and this is my first time using checkboxes. I am am little confused on how exactly to get data from them, and the FileMaker Bible doesn't help too much. The database I created is to create a list for outdoor activities (I know, I'm a geek). It has 2 tables, one containing the activities and the items needed (ex, Swimming; bathing suits, sunscreen, etc); the other table has the checkboxes so you just check the items you are going to do and it will populate a list for you, so we don't forget anything. I can create another field as a lookup, but that only gets the first item checked, which I how I figured it would work. The ch…
-
- 4 replies
- 1.5k views
-
-
Hey, Just wondering how a guy is supposed to set up a MySQL table so that it can be indexed. The goal is to get FileMaker to be able to use the data to create a value list. Seemed like a pretty simple requirement before I embarked on this journey... When I assign the appropriate fields in the ValueList dialog box in FileMkaer, I get the error "This value list will not work because one or more fields cannot be indexed. Proceed anyway?" Does anyone have a handle on what I gotta do to set up the MySQL table up correctly so that it passes the data to FIleMaker appropriately so that FileMaker can set up the ValueList? Any help or pointers in this direction…
-
- 1 reply
- 2.7k views
-
-
Hello again peepz, Please refer to the attached files for a visual idea of what I am trying to do. Basically when I click a row in the portal located on the right top half, it should display the details of the records on the right bottom half. However, I cant seem to find a way to do that. Could you guys tell me how to do that? I believe it has something to do with the relationships between the contractor and refurbishment tables but I don't know how to sort it out. Regards, Farah K.
-
- 2 replies
- 1.3k views
-
-
I am trying to create an estimate form that includes multiple fields that will have the same field name, but different values within the same layout. Is there an easy way to do it, or will I have to create a separate field for each section with a unique name for each field?
-
- 10 replies
- 2k views
-
-
Hello folks... I'm new here and have just started to go through this site... I have a solution I'm making for my own CPR biz right now. What I'm trying to do is this.. My course records table contains a course #. This course number is entered in a spot for each student we have. Also in the course table I have an option that states if everything has been completed with the course choose yes. Based off of another compnay's design what that is suppose to do is prevent that particular class to show up in the drop down list of available courses over on the student side of things. I can not figure out how to make that happen. I've done a search for that cla…
-
- 2 replies
- 972 views
-
-
I know this must be a kinda noob question, but I've searched the knowledge base and can't come up with a solution (which I'm sure is obvious.) I have a DB with three related tables: (1) Parts Bin, (2) Parts Container, (3) Parts. They are all connected by the same key, "Part Type." I want to print a report showing the contents of the bins. Each bin may contain several containers which themselves may contain several parts. The report should be simple-looking as follows: Bin 1 Part Container 1 Part 1 Part 2 Part 3 Part 4 Part Container 2 Part 5 Part 6 Bin 2 Part Container 3 …
-
- 2 replies
- 1.5k views
-
-
I am sure this was addressed before but could not find the thread. I have a columnar report that summarizes invoices by customer ID. I would like to have a GTRR button in the body to take me to the invoice. However, buttons don't work in preview mode. If I swich to browse mode I can't see the records. I have redesigned the report in list view, I can see all the invoices but they are no longer grouped by customer. Basically what I need is a report of invoices grouped customer ID with a gtrr button that takes me to the invoice or some sort of a work around to this issue. Thanks.
-
- 3 replies
- 2k views
-
-
This is the first opportunity I've had to use FMPs tabs. Wow are they cool! I've got a layout with nested tabs. I want to set a global field to equal the name of the active tab on the nested tab. I was hoping Get ( ActiveLayoutObjectName ) would do the job, but no luck. Is there a way to make this work without creating fake tabs (buttons) that script back to 0 point tabs?
-
- 1 reply
- 3.1k views
-
-
I cannot figure out how to display only the date and not the time of a timestamp field on a layout. For example, the timestamp shows up on the layout as: 1/1/2008 12:00 AM And I want it to show up as: 1/1/2008 Does anyone have any tricks up their sleeves?
-
- 2 replies
- 1.2k views
-
-
Hello Everyone, I am in the process of creating a database for a Tradeshow that we host and I am having a problem with creating a report that contains totals from 2 different portals on one layout. I have searched for an answer in the forums but being self taught I am still confused. I believe a have to create a self-join? but have no idea how or what tables to use, etc. Right now, I have a parent table (main) that contains all contact information. I then have a portal for booth space sales and a second portal for all other sales. Since we do the show once a year, there is a year field and for all the sales, it is linked to another FM database for pricing and items s…
-
- 10 replies
- 2.1k views
-
-
I am slowly learning Filemaker having started making the transition from the PC world to the Mac world and from Access to Filemaker. My MacPro is my first Mac since my old Apple II! I have a database that keeps a log of the computers and peripherals on our network. I have a table tblComputers that has a ComputerName field and a CurrentStatus field. I have a related table tblComputerLog that gets a value list from tblComputers using ComputerName. As it is now all of the computers are listed, active and inactive (Retired). I would like to have the value list in tblComputerLog create a value is of only the Active items. I have tried many things but they all se…
-
- 8 replies
- 1.8k views
-
-
I have an" Id" field that I must allow the user to enter numbers, letters or both in any combination. I am struggling to find a way that allows me to sort by this field. Any suggestions? Greg
-
- 2 replies
- 1.1k views
-
-
Sorry if this is a duplicate question. Is there an easy way to align objects layout to layout? I basically write down the numbers from object info and re-enter it to make sure it's identical. Is there an way to do this different or automatic. Thanks in advance Dave
-
- 3 replies
- 1.1k views
-
-
Hello, In a portal that lists attendees of a conference, each record has a value list that specifies whether the person will attend EventA, EventB, or Both. I've been trying to summarize this information in my layout with two fields - the first to count instances of "EventA, Both", and the second to count instances of "EventB, Both" - and can't for the life of me figure out what to do. I could list the calculations I've attempted, but I've a feeling that would be a waste of space and would prefer to start from scratch. Any assistance would be greatly appreciated!
-
- 8 replies
- 1.5k views
-
-
Hey there. I have a few search layouts I want users to run in Find Mode only; and for the results I created a few layouts that I don’t want my users to use in Find Mode (instead they should stay with Browse Mode, List View). My question is: Is it possible to create a layout or a privilege set so, that users cannot (accidentally) switch to a "forbidden" mode? Thank you for your input, polarpro
-
- 4 replies
- 1.2k views
-
-
I have a Form layout showing records from an employee table. The form contains multiple tabs. A portal from a related table is defined on each tab. Ex: One portal displays all phones/faxes/cells assigned to the related employee. If New employee, a script writes 54 Tasks (each a record in a Tasks table, related by login) and displays in a portal on a Tasks tab. The Tasks portal contains Status field (selected from a value list). So far so good. I have created 2 buttons above the portal: Show All and Show Open. I want the Show Open to omit any Completed tasks in the portal ONLY for the current record (employee). Instead it is omitting the records (employees) f…
-
- 1 reply
- 1.2k views
-
-
Hi, I have a system which sores books sold and their publisher. A report I need to display will take any subset of "sales" and give the following sub-summaries: a) The total number of sales in the found set for each publisher in the found set The percentage of the "number of sales for each publisher" compared with the total number of sales in the found set (for all publishers). Fairly simple, if you have 1000 records, and two publishers in the found set, with PubA having 200 records and PubB having 800 records then PubA will have 20% and PubB will have 80%. Sub-summary (a) from the above is displaying correctly. However Sub-summary ( is displaying …
-
- 4 replies
- 1.4k views
-
-
I have 2 portals on a layout, the left side is a portal showing all jobs to my attention. What I want to do in the right hand portal is show the details of the record I have selected in the left. Does anyone know how to do this?
-
- 1 reply
- 1.1k views
-
-
Hi everyone, I'm new to Filemaker and I'm attempting to make a employee timesheet, based on a two-week payperiod. What I've done so far is create a drop-down list for the start of the pay period. The end of the pay period is then calculated based on the start + 13. This works fine. Currently I have a drop-down list for day of the week. What I would like to have is a conditional drop-down list for date based on the day of the week for the pay period. For example, day of the week = Tuesday, the date drop-down list would contain 17/06/2008 and 24/06/2008. I am trying to build this with a case statement, but I'm not sure if I'm on the right path or no. …
-
- 2 replies
- 1.5k views
-
-
Dear peepz, I have designed a layout where the portal shall display some fields of the records related to the primary record. The portal occupy the upper half. The bottom half contains textbox, etc which is the basically the more detail field content of the records display in the portal. What I intend to do is that, when I click on the row in the portal, all data related to the row will be displayed in the bottom half. This will allow editorial amendments. Can someone tell me how do I do that? Regards, Farah K.
-
- 6 replies
- 2.1k views
-
-
I always get the message: "Record cannot be modified in this window because it is already being modified in another window" Is there a way to go around this one? Any magic fix? Cheers Greg
-
- 9 replies
- 6.8k views
-
-
I hope I'm posting this question in the right place...I'm trying to adjust an existing database to fit the following desired functionality: The user I'm working with wants to have an auto-filling field (Company Name) also display a name associated with the company (Full Name). These two fields are pulling their information from an external contact database where each client (Full Name) is a separate record (with the same Company Name in many cases). The problem I'm running into is this: When I teach it to show both the Company Name and the Full Name in the Company Name field, it only shows the first entry from the contact database. When I tell it to sort the ent…
-
- 5 replies
- 1.3k views
-
-
I have a summary report which works fine. It shows actions taken, grouped by staff and the specific action, and then it counts the number of actions. Each action has a date and I want to be able to filter the results if they fall between set dates. The dates which form the criteria for the report are entered in a custom dialogue box and become variables in the script. I have used these dates to give either a Yes or No result in a filed in the relevant table, the idea being to run the filter if the field says yes. So far so good, all works, but when I put the filter into the script the report does not run properly. Does anyone have any ideas? Picture of script attached
-
- 4 replies
- 2.9k views
-
-
Hi. I need a hand in setting up a relationship between zip codes and street names. We currently have the city field and state field data auto enter based on the zip. I'd like to be able to A) enter a zip code, then select a relevant street name from an editable dropdown list or : Enter zip, then start typing the street name and have autocomplete show me the relevant street names. I've attached an image showing how I have the data set up... My bet is that I need a new table for street names but I'm a noob at this so any help is appreciated. This next idea is strictly a 'wish list' item...but any direction would be great. I'd like like to get a …
-
- 3 replies
- 8.4k views
-
-
I have created a report layout. I have one sub-summary part that displays the "one" record in a one to many relationship. The body of the report displays the "many" part of the relationship. Is there a way to have the sub-summary part print again at the start of the new page if there are still records that are carrying over to the next page? Thanks! Patty
-
- 1 reply
- 2.1k views
-
-
Is it possible to highlight the selected row from a list of items (Columnar list layout) without the use of plugins? The little black box to the left of the row just isn't obvious enough. Thanks.
-
- 1 reply
- 1.1k views
-
-
I have an Offices Value List wherein officeID is first field (do not display) and 2nd field is OfficeName. The OfficeID is a one to many relationship. In Forms, the related Office field stores the OfficeID, but I want the OfficeName to display. If I choose to display data from the Offices Value List as a Popup Menu, it displays the OfficeName correctly. If, however, I display as a Dropdown List, it displays the OfficeID (1st field) instead of the OfficeName. (It wouldn't be so bad if I didn't hate the popup menu -- it gets in the way when I'm tabbing through a record.) It's using the same Value list. Why the difference in display??? Is there something I am m…
-
- 1 reply
- 995 views
-
-
Hello peepz, Can someone tell me why is it that the objects that has been placed on the first tab control shown in the rest of the tab control in my form? Then when I created more objects in the subsequent tab control, the later tab control objects appear on top of the previous tab control objects regardless of which tab control I am on. Regards, Farah K.
-
- 1 reply
- 974 views
-
-
Hi peepz, Is there a spread-sheet like function in File Maker? I need it as it would be a better way to present multiple lines of records. Regards, Farah K.
-
- 2 replies
- 1.2k views
-
-
Dear peepz, Could you please share with me how the auto-calculate function work? I have made field3 store the result of the addition of field1 and field2 in the same table. However, when I enter the data for field1 and field2 in the form, field3 remains empty. Regards, Farah K.
-
- 1 reply
- 1.4k views
-
-
This one has me scratching my head. I'm working on a touch screen, point of sale retail solution for a golf course. I need to generate a report at the end of a period of sales that summarizes the various "products" sold. There are 37 products, each with a PRODUCT NO., PRICE, QTY and DESCRIPTION. These are sub-divided into 8 logical groupings. On any given day there could be from 0 to over 50 units sold for each product number. The printed report summarizes the number of units sold as follows: NO. DESCRIPTION QTY PRICE Registration 001 Resident 2 90.00 002 Senior 0 0.00 003 Stud…
-
- 1 reply
- 1.1k views
-
-
dear all, i have create a check-box set to accept the user's input but when i tried it out, it wouldn't tick. the other fields works just fine. what is the error about? regards, farah k.
-
- 2 replies
- 1.3k views
-
-
I am using a calculation field that is (text) as follows: "Unavailable:¶" & ValueListItems(Get(FileName); "Count") I cannot get ANY value list to appear in this field - even with a simple calculation as follows: ValueListItems(Get(FileName); "Count") I have this exact same calculation in another File (and it works fine) but for some reason this does not work in this file. I have spent an entire day attempting to figure out the problem! Any ideas?
-
- 18 replies
- 3.8k views
-
-
I have 2 problems with my solution, the search function and the display value popup. 1: Display Problem. I have a zippit script that performs a "Spotlight search option" that goes through a triggered script. The script only finds the "Name" field but I wanted it to find different fields too. How can I do that? Login: Dev Pass: None Please see file (Script = "brain_find" 2: I would like to know how I can display the portal by just a category I choose. I started with the value names in the calculation, but I would prefer a value number so the customer can change its own categories. Thanks for the help! Clone5_copy.zip
-
- 0 replies
- 1k views
-
Recently Browsing 0
- No registered users viewing this page.