FileMaker General Discussions
Older discussion forums for previous versions of FileMaker
-
Hello Freinds, Like to know if it's possible or is there any script exist to detect a duplicate record during data entry and prompt for proceed or cancel. If some one can help me . Thanks
-
- 1 reply
- 710 views
-
-
I was hoping somebody could help me. Is there a way to log every time that a user accesses a record (reads it). I already am able to log all changes to records (an audit trail) but I need to be able to log simply opening a record in a layout. Is this possible to do? Thanks in advance for any help.
-
- 8 replies
- 2.2k views
-
-
Hi Is there an easy way to upgrade the FMP database at the end user sites, without having to save clone/empty files and then import them 1 by 1? I don't mean from FMP6 to FMP7. I mean just a new version of the same solution, but maintaining the users data. If there is no easy way, then has anyone tried making a batch file or similar? I have had a look at AutoIt www.autoitscript.com and it looks like it might be up to the job. Any help or ideas would be appreciated. Cheers Simon
-
- 2 replies
- 1k views
-
-
Hi All, This is my second post. This forum has proven an invaluable resource to the newbie Rex. Thanks to all that manage it and post. I am trying sort and create a report, records by the frequency of values descending from the most to the least occurances in a given field. Explanation: I have 70 records that have 20 fields describing them. I would like to sort the 70 records by one field according to the frequency that the values occur in the records. Much like the alphabetical descending sorting, but by frequency of the value occurance. I would like this to appear in a list. Example: 1. Bannana----------------->1. Kiwi 2. Apple------------------->…
-
- 4 replies
- 937 views
-
-
I asked a similar question in the AppleScript forum, but realized that the solution doesn't need to be AppleScript if...it doesn't need to be. Perhaps you can think of a better way to accomplish my goal. I have a FileMaker/Excel combination which is used for expense tracking and budget planning. (Think a bare-bones Quicken with some very specific customized reports and uses.) FM tracks the expenditures for different bank accounts and categories, and summary of these is brought over into the (existing) Excel spreadsheet to track performance and plan budgetting. The Excel file has a sheet called "Incoming Values" with columns for each month, and ~65 rows for all t…
-
- 0 replies
- 798 views
-
-
I am building a database for shop work orders I would like to be able to attach shop drawings in PDF format to these work orders. I imagine I should be able to do this by inserting them into a Container Field. The problem I am having is that when I do this all I can see is a faint rendering of the original PDF document. Printing also produces just a fairly faint facsimile of the PDF. This topic has been raised on the Container Field part of this site but does not seem to get answered there. Can anybody direct me toward a discussion of this topic? Thanks, Jarvis
-
- 7 replies
- 1.8k views
-
-
Hi, i am developing a little database for pdf documents... and i have this problem: I tried to print from filemaker the pdf contained in a container field, but I been able to print only the first page of the pdf. There is a method to print all the pdf from the container camp? Or a method to view all the pdf pages in the container camp? thank. Johnny ------ I live in Italy, and I am Cool, and sorry for my YeURRch english.
-
- 0 replies
- 722 views
-
-
there is a problem when one tries to loop within a portal. the problem is with the end-of-loop detection. Example script: Go to Portal Row [select; Perform without dialog; First] Loop ..... ..... ..... (your operations here) Go to Portal Row [select; Perform without dialog; Next; Exit after last] End Loop The above script enters an infinite loop and creates infinite new portal records in the portal. Is there a fix for this? or am I just scripting something wrong here? I tried taking out Select, but it doesn't do it. It doesn't seem to detect the end-of-portal-records in portal.... :-( and this script is very important for …
-
- 3 replies
- 942 views
-
-
Has anyone been able to use Flash MX Professional 2004 XML Connector Data component to connect to FileMaker Unlimited?If so, would it be possible to get a sample? Is it possible to start a Flash to FileMaker subject group under the Internet Heading in FMForums?
-
- 0 replies
- 1.1k views
-
-
I'm trying to attach a Filemaker 7 file to a post. I get a message can't attach with fp7 extention. Please help
-
- 2 replies
- 953 views
-
-
Hi Forum, I would just like to know if anyone has any experience with a biometric interface, using FM ? I'm looking to implement a fingerprint scanner, but I'm not sure if this within FM's scope. Eric
-
- 4 replies
- 1.7k views
-
-
I created a Portal record that has two calculations as fields. Both of them require a field that is manually entered; these fields are not with in the portal, and do not repeat themselves. Cost = (Length * Width) / 144 * Extend ( Three Quarter Hidden Field 1 ) Same for the other field. Lenght & Width are repeating fields. Cost only gets calculated on first record of the portal, I need the calculation for each record. I need help ASAP!! Anyone please [email protected]
-
- 0 replies
- 817 views
-
-
Hi, I am new to the forums and have a concern with FMP 7. I have been learning to use it for a project at work for the last month now and so far love it. However, I have noticed something that appears to be a major bug in my FM. In the memory settings, I changed the "Save cache contents" from the default "during idle time" to every 10 minutes. I have found that neither of which are actually doing so. I had FMP running for 3 days straight and added and modified records during that period, and never once did it save the cache. I know this because in the properties of the DB file, the last modified date and time were the last time I had closed the file (3 days prior). …
-
- 3 replies
- 1.1k views
-
-
How do I check the time on a frequent basis to run a script? I want to shift the application to single user for 1 hour during a scheduled nightly backup. But I don't see how to check the time without just making a loop that will tie up resources.
-
- 14 replies
- 2k views
-
-
In the older version of FMP, if I click on a script button in a portal row,say row 5, the script excutes in the record that's in the row 5. In FMP7, the script always excutes in the record in the first row. This problem really bothers me. I'm think about adding a few more steps to the scripts. Maybe I can use a global field to store the portal row number, then go to the related records, then go to the record which record number equals the portal row number. I wonder if I did anything wrong when I converted the database to version 7 that could cause this problem.
-
- 1 reply
- 664 views
-
-
Post deleted by joemacgruder
-
- 0 replies
- 637 views
-
-
Hi I see many web sites using what i call a Where You Are Directory Path with url's to navigate back like the example from eBay "Home > All Categories > Business & Industrial > Construction > Building Materials, Supplies" How can this be duplicated in FM?
-
- 3 replies
- 786 views
-
-
Hello All, I've searched the forums for any advice on conditional text color formatting, but it seems that this is a new option in FM 7. My question, is there a way to approximate this effect in FM 5? More specifically, I have a DB (call it DB_one) that will display names on a schedule table using data from DB_two (relationships have all been defined and work properly). I would however like to have these names displayed differently according to specific information from DB_two. If, for instance, DB_two xfield ="foo", then DB_two yfield should appear a different color in DB_one, otherwise default color. DB_two yfield will always appear in DB_one, regardles…
-
- 3 replies
- 1.3k views
-
-
Hello, I have a lovely FMP6 solution that we previously used under Mac OS 9, over the summer we have moved to OS X. Now, every one of my scripts that Maximizes a window causes the resulting window to be displayed behind the dock. Filemaker has graciously acknowledged the problem, but offer no advice or recourse. This has been fixed in FMP 7 from what I can gather. Anyone found any workable solutions around this problem?? Thanks, Randy
-
- 5 replies
- 1.6k views
-
-
I've read other posts but none are working for me. I'm building a simple inventory and want my quantity field to count how many records contain the same model number of the record being browsed. We may have 10 of the same item, but each needs a different record because of different serial numbers. So I tried the count(solution::model) and that is not updating the quantity like I'm expecting it to.
-
- 1 reply
- 872 views
-
-
Hi Guys, need a little help. I have a table with 8 fields, the first is what we call location numbers, the second is employee names. There are a multiple employees assigned to many of the locations. I need to show all employees in one field "maybe a portal" by location. I want to link this information to another table, if you can help with the employee part., i can do the rest. Please Help!!!
-
- 1 reply
- 1.6k views
-
-
I am still wokring on more reports. I found a useful thing to have on the reports is a little section that contains what exactly i'm looking at. For example, if I was looking up hours for a certain project between certain dates, it is useful to know what dates i'm looking between. Is there any way to set it so that the layout prints out the "Find" contraints used?
-
- 2 replies
- 898 views
-
-
When importing photos, I choose link but the paths are coded as absolute. If I burn the fp7 database with it's linked photos to a CD, the images aren't found because it's still looking for my computer's partition/folder structure. I want to make it default to using relative paths when importing images or files into a container field. Any suggestions on where to set this?
-
- 1 reply
- 739 views
-
-
I have an Access database that is currently still evolving as some of the uses people want out of it are changing. The last changes made it so I have to throw out alot and rebuild from scratch. It is a relatively small database so this haphazard method is not to bad. I decided to do the current rebuild in both Access and Filemaker because I would prefer to just migrate it over to Filemaker. I have several tables which are still usable and I want to import them all as a foundation for this build (the relations are not important they really started acting weird in access which is one of the reasons I am rebuilding). I was fooling around with things earlier and it appe…
-
- 2 replies
- 1.4k views
-
-
Good day, all. I am trying to find a better solution for a communication archive I am building. The purpose is to archive all letter and email communications for an educational program. These documents are created using templates. The project is to save each communication so they can be tracked over time. Currently I have three files, Contact, Communication Template, and Archive. Once the desired record or records are selected in the Contact ID (these are the people the letter will be sent to), a nav button/script jumps the user to the Communication Template where they can chose the type of Communication they wish Each Communication is a different layout in the Tem…
-
- 8 replies
- 1k views
-
-
Dear all, I have a text file that has a ton of names & addresses separated by one or sometimes two carriage returns. (There is also a carriage return at the end of each line) example: Tom Smith 12 Park Place New York, NY 10034 Bill Frankel PO Box 974 Mills Highway Minneapolis, MN 34387 Janet Parker UCLA West Wing Box 4343 Los Angeles, CA 94372 . . . Could someone recommend the easiest way to import this information into a simple Filemaker database ? I'd be happy with having each person having their own record, and getting the name into a "name" field and the rest of the address into an "address" fiel…
-
- 2 replies
- 788 views
-
-
I am trying to set up a field that will count how many times the same text in one field shows up in number of records in the data base. Ex. In field "bldg ID" the field has "TGE-HWD" and then in another record there is the same type "TGE-HWD". I want a field that will count this a "2 times" and show that in one record.
-
- 9 replies
- 1.2k views
-
-
How Do I publish in CDML a value list using ONLY Related values ? Value list works in FileMaker good, but when I
-
- 0 replies
- 732 views
-
-
Hello, I am learning the 5.5 version. So far I can layout and browse and have a file that works but now need to add some difficult (for me) features. First, I need to add a "message space" to the database used between two users. I basically want this: an indicator (flashing would be good or just a box/button that changes when a message is waiting) and a message field. I don't want this area to change or be stored with each record. I thought a global field was the ticket but only the host can change it. Then I tried "relating another file". I created a new file with just one field and went back to my main file and related it (or so I think). When I type in the field of the…
-
- 4 replies
- 1k views
-
-
Is there any way to change several records at once? I have a database and I want to change all the records for a certain field and rather than doing every single record (78000+), it would be useful to change all at once. Thanks
-
- 2 replies
- 2k views
-
-
Greetings, I am a newcomer to the forum and have only been using filemaker for about a year (though long enough to convince the company I work for that I am much smarter than I am - I love this product...) but I saw a post of yours from several months ago where you emphatically stated it was terrible to use sequential serial numbers in ID codes in filemaker. I have been using this frequently and would like to know why you feel this way. Thanks for any input...
-
- 12 replies
- 1.4k views
-
-
i was just looking throught the business tracker to get a first look at some filemaker 7 solutions. I'm still not that impressed with the fact that you don't seem to be able to have frames. i.e have a single top menu and a frame below that which you can use to navigate to different layouts to via the menu ...or have I missed something and this is now possible? Does anyone have any good demo files that show off some of the new things it can now do over filemaker 6?: Thanks
-
- 0 replies
- 748 views
-
-
I'm new to FileMaker and am trying to create a script that allows me to download a pdf file. I want to match the AD ID with the appropriate pdf of the ID and then using a button to download the file. Any help would be appreciated since I'm not even sure where to begin. I've tried a few things so far, but none of them have seemed to work. Is there a way to declare variables in Scripts inside FileMaker? I would need to do this because the AD ID changes with each record. Thank you in advance!
-
- 4 replies
- 828 views
-
-
Hi, I have recently posted this to the filemaker website as a bug. In FileMaker 7, if you have a portal where it needs a scrollbar, and have the portal have no border in between the entries, and you scroll to the last entry. And then press the scroll bar again, it will show that last entry sliding up but it also is in its original position. This problem is resolved however if you have the portal with a border. Hope FileMaker fixes this bug, because it seems kind of dumb to be forced to have a border in portals.
-
- 4 replies
- 928 views
-
-
I am still working with FMP 4.1 on a Mac OS 9.2. I am working on a database that contains 14 layouts in which data is collected which ultimately needs to be output as a report in .pdf format. I currently have it set up where 14 .pdf documents can be generated and compiled into a single document back in Acrobat Distiller. However, on the Mac, inserting the pages does not do so in alphabetical order, so they have to be manually adjusted afterwards. I am experimenting with running the entire report, with all the necessary fields, in/on a single layout. However, there appears to be a 111" height limitation on the layouts, and to accommodate for the 'worst case' scenario,…
-
- 2 replies
- 865 views
-
-
Hi I have need to display a shopping cart where the line item discriptons are from one to three lines long. When I place the items in a portal and leave room for three lines the spacing on the line items that are only one or two lines long have additional white space that i want to eliminate. I have not used FM since V4.0. I seem to remember placing html in a calculation field. Any ideas or hints on how to customize formatting would be greatly appreciated Cheers Gary Weisbrodt
-
- 3 replies
- 710 views
-
-
I'm building a database that multiple users will be able to log into online. I've created a table for users. Each user has a unique ID#. I've then created related tables using their ID# as the related field. How do I make it so when a user logs into the database, it recognizes the user and allows them to only work within their ID#? Thank you in advance - Jon
-
- 3 replies
- 776 views
-
-
I have a portal set to show three rows of fields - but which may contain more than three. I want a field elsewhere on the layout indicating how many rows of the portal have been filled. ie: if there are 7 rows filled, it will only display three but the field outside the portal will display '7'. Can it be done?
-
- 2 replies
- 866 views
-
-
Hello, I am building a database in fp 6 and I was hoping to get some feedback at the planning stage rather than when I am pulling out my hair. Data will be entered into 5 separate forms and will be captured in 1 filemaker file. I am planning on creating the 1 file and then making portals in 5 files all pointing back to the master file. I am choosing this method because changes made in either file will show up in the other file and the data in the master file should export successfully. I may add some buttons to move the user from one form to the other but that is down the road a bit. Any feedback would be greatly appreciated. Thanks Jo…
-
- 7 replies
- 1.2k views
-
-
I currently have a table of dates and if an entry is > a certain date, I want a calculation field named Status to be set to
-
- 1 reply
- 797 views
-
-
Howdy, Ok, So I'm trying to keep track of personal leave hours earned and used. In the report, i want to display only dates that have a record of PL aquired or used, however, i can't figure it out and instead it displays all dates making the report quite long and ugly. Thanks for any support. Akira
-
- 1 reply
- 790 views
-
-
I am trying to make a database that will summarise surveys. Each question has the answers: strongly disagree disagree agree strongly agree no onpinion I want to know how can i summarise the answers? i.e 5 Strongly disagree, 10 agree and 3 no opinion? I need to be able to do this for about 22 questions. Hope someone can help...
-
- 9 replies
- 2.7k views
-
-
Hi. I have problem I can't get around... I have a numeric field in db file A, in which I enter "0,5" (using "," instead of "." before the decimals is the norwegian standard - set in the Mac OS system settings) Then I have a calculation field in db file B which is just: relationship::numeric field. Here the zero is gone: ,5 It comes back if I set the numeric format to fixed decimals of cause, but I don't want that. Because if I enter 36 - I don't want in to display 36,00 I have tried to set the calculation field in db file B to turncate(relationship::numeric field, 2) and round(turncate(relationship::numeric field, 2), 2) and some …
-
- 9 replies
- 3.3k views
-
-
I am a new user to Filemaker. I have FM 6, which I brought two months before FM7 came out. I want to move my contacts from Palm Desktop (Windows XP)to FM 6 on Windows XP. I converted the contacts in Desktop to CSV. I choose Contacts as a template. However, a lot of fields are missing in Contacts, such as "country." Has anyone created a template that maps from the generic Palm contacts to a FM 6 template. I was told by Filemaker Tech Support to contact the forum to see if someone has developed something like this. Otherwise, Support said to build my own using the Contacts as a start. It will take me sometime to figure out how to modify the template. I'd like to move…
-
- 2 replies
- 744 views
-
-
I have a database with mulitple tables. With one button I want to transfer a record from one table to another. Is there a way to do this other than copy and pasting into every field? Heathbo
-
- 14 replies
- 2.6k views
-
-
I'm generating a report where I'm Summarizing data by Month/Year. The problem I'm having is the dates need to correspond to our company's fiscal calendar. So something with a date 7/1/2004 would need to go under the month/year 06/2004 (since according to our Fiscal calendar, that item happened in "fiscal" June). Does anyone have any ideas for how to create a calculation field that performs this conversion? BTW I noticed a function in version 6 called "WeekofYearFiscal", would that be useful in this instance?
-
- 3 replies
- 921 views
-
-
In a Filemaker 7 database that has several layouts, how could you script a "back" button that would bring you to previously viewed layouts (and perhaps??? found sets :?) If anyone has any idea of how this is done - even at the very simple level -- i'm very curious to find out whatever I can. I tried searching for previous articles about this and didn't find anything.
-
- 2 replies
- 939 views
-
-
Is there a solution that does NOT require FileMaker Developer that will automagically document my FileMaker solution? I'm not looking for anything complex, just information about which fields are where, which scripts refer to what, what is on layouts, etc. Any help/suggestions will be greatly appreciated. Thank you, Nancy
-
- 2 replies
- 782 views
-
-
Good afternoon Forum! First let me say I've read through the posts and you guys/gals are amazing. I thought I knew a thing or 2 about databases... there's so much I didn't know I didn't know. Okay, here's the short version of my question: I have 6 repeating fields in one database: 1 for a Rotation Code; the other 5 are Topics in varying orders. In a related database, I have a calculation field which evaluates the Rotation Code and selects one of the 5 Topic fields depending on the code selected. The result of the calculation only returns the 1st value and I want them all (there are 5 max depending on the rotation. HELP! If you'd prefer a longer/more-detailed…
-
- 2 replies
- 831 views
-
-
This will hopefully be an easy one, but I search around and couldn't find the answer. I have a DB w/ 20,000 + records. I want to find all records that have duplicate values in a certain field. Say I have a field called 'names'. I want to find all records that have the same value in the name field. I hope that makes sense, here is another illustration. Say there are many of records w/ Jane, Jack, Jeff, Karen in the name filed. I want to do a find, listing all records that are NOT unique in a given field. In this example, it would list records containing Jane, Jack, Jeff, and Karen. Can anyone help me out? Thanks!
-
- 1 reply
- 1.5k views
-
-
I'm working on a fund-raising app for a non-profit group. They want to keep track of donations, pledges, etc. They've designed the DB, and I'm building it for them. However, on gift entry, there's one layout for gifts, no matter the type. I have a menu for type: pledge, pledge payment, matching gift, etc. I have a summary field on the gifts db that totals all the gifts by each person. So far, so good. However, if someone enters a pledge for $1000, then pays it off with two payments of $500, the total is going to show up as $2000... it counts every entry as contributing to the total. What we really want is a way to have two totals: all money pledged, and all…
-
- 1 reply
- 694 views
-
-
i'm new to filemaker, can anyone help me? i'm trying view a subset of a number of repeating fields. for example, let's say repeating field WEEKS has been defined with every monday of dates 7/26/04 - 7/25/05, making 52 entries, but i only want to show 10 of these dates at a time, starting with a date that is selected in browse mode. i have made a popup list that shows all of these dates to choose from...now how do i make my layout dynamically show only these 10 dates? i took the specified date DATE1, and made a loop that went through WEEKS, incrementing COUNT by one each time to figure out the corresponding index number of WEEKS. question 1: is there an easier…
-
- 8 replies
- 2.3k views
-
-
Hi everyone, I'm trying to create a packing list that its sectioned by Boxes and sub boxes. I will be shipping CDs, and each sub box will contain 10 of these. Each Box will contain a non-specific number of these sub boxes. Here is the format that I need the packing list to follow: Packing List SCOTUS Order Shipped 8/6/2004 BOX # 1 Sub-Box # 1 1
-
- 6 replies
- 2.6k views
-
-
I've copied a page from preview mode and pasted into a container field. I'd like to then print the container field but everything I try comes out blurry. I've done this same thing in FileMaker Pro 6 and it's worked fine. I'm working on MacOS X 10.3 - FileMaker 7. Any help would be greatly appreciated.
-
- 3 replies
- 964 views
-
-
I'm creating a Task table to store all the tasks I need to do for several areas. I want one place to go to see what I need to do. I have the tables: People, Organizations, Events, Projects, and Opportunities, all of which I want to create tasks for. I want to be able to view the tasks I need to do for all or any of these areas. I also want to jump from any Task back to the record that it is matched to within any of the originating tables. The problem is I can't link more than one table to the Task table. If I try to use extra occurances of the Task table, I get threaded links back to organizations for which I have people matched (I'm matching people and organiza…
-
- 36 replies
- 4k views
-
-
Hello, some users of excel find it difficult to use fmpro because they haven't the possibility to create a crosstable or pivottable. ==> A crosstable is a summary of 3 tables. A little example. Suppose you have several buildings and you want to view how many studios, garages etc.are in the buildings. Table 1: building Table 2: elements (studio, garage etc) Table 3: building - elements BUILDING A B C D E studios 1 2 4 0 0 garagaes 2 3 0 5 6 appts 4 5 5 5 5 The problem is that it should be easy to add a new column for a new building AND that (suppose you…
-
- 2 replies
- 1.5k views
-
-
I have a proposal that has many lines. The formatting choice of 1pt is too heavy and detracts from the data and the "hairline" is too light. Is there anyway to add a format of 1/4 to 3/4 pt?
-
- 3 replies
- 975 views
-
-
I am undertaking a Multiple Request Find. I want to display all matching records in a related file. I have a script that will show related records, but it will only display the records that match the criteria relevant to the record I have selected. I want to display all related records that match each request in the Found Set for reporting purposes. Can you help please?
-
- 7 replies
- 1.4k views
-
-
Hi, I am exporting FMP data into another program which cannot handle any carriage returns. One of the fields has tons of carriage returns in it: some of them are at the end of the text, some in the middle of it, eg. University of Blah Department of XYZ I have tried using the substitute function to replace all carriage returns with spaces, and it works for the ones at the end of the text but not those in the middle. Can anyone help?? I have already tried the FMP experts email list, but no joy there so far. The only person to respond couldn't understand why returns in the middle of text should be any different to those at the end.
-
- 11 replies
- 4k views
-
-
I am currently using Filemaker Pro 7 and would like to use a Dymo Labelwriter label printer....very nice unit, but I'm not sure whether it works with Filemaker. Has anyone had any experience with this label printer? Thanks
-
- 2 replies
- 1k views
-
-
I have designed a two page layout (approx 130 fields) Page one (a proposal) can have up to 2 items listed. Each item consists of 14 repeating fields. Is there any way I can mark only one of the two items (with it's corresponding 14 repeating fields) carried to the page 2 layout (a factory order form) IE: Even though the Proposal lists two items, one may be in inventory and only the other must be factory ordered. Ex: Qty Item Model Size Color (these are 2 vert repeating fields) A B
-
- 1 reply
- 880 views
-
-
Seems that once I convert a file from 5.5 or 6.0 to ver 7, the visuals on screen are too large...by about 25%. I adjust for this by having a script set the viewable screen size to 75%. I'm sure this is the incorrect way to adjust for this but it is a temporary fix. My question is two fold. 1. What is the "standard" screen resolution I should be using? 2. What is the correct way to have converted files show on screen correctly?
-
- 1 reply
- 756 views
-
-
The bug I found is about the Substitute Function However everyone can check himself: 1) Create a new fmp7 file 2) Define 2 simple text field (text1 and text2). 3) Create 1 simple Script in which Set field text2 as Substitute(text1; "sometext"; "someothertext") 4) go in browse mode and fill text1 field with text to reach more than 4.000 chars (obviously u must insert the word "sometext" of the Substitute function above.) 5) Run the Script and unfortunately you'll find in text2 field the word "someothertext" doubled (practically "someothertextsomeothertext") Please may anybody check it and give me a feedback? Thanks guys
-
- 6 replies
- 1.2k views
-
-
I am trying to create a quote software for my company whereby I have created a unique ID# when the clients name is entered then you switch layouts and enter a room name and then you enter individual line items into a portal under this area. Then you enter a different room name and enter new items in the portal (etc. until you have entered all of the room and items necessary). My problem is keeping the unique ID# populated with the current unique id# in the room layout so that the room names are related to the current client. I can manually enter the number but I cant figure out how to autopopulate this field everytime I create a new record. I need this number to stay the …
-
- 3 replies
- 774 views
-
-
I have files which I need to store for 10 years or for ever. If it's for 10 years, file storage will end 12/31 ten years later. Is there a formula which gives me based on the "end"-date of the content of the file (say i.e. October 10, 2004) either an expiry date 12/31/2014 (it must be 12/31...)or - if its for ever - a date like 12/31/2999??
-
- 1 reply
- 785 views
-
-
Version 4.1v3 Status area Layout List. I work on several PC's all with FMP version 4.1v3. While in Layout mode With that Status area displayed the top button will list all the layouts I am using. Problem on some of the PC's the Layout list is in a column and on the other Pc's the list of layouts is accross the screen. Question: How do I change the setup option so that I see the layout list in a column as I have so many layouts that when they are displayed across the screen I can't see the layout name of the layout I want to select.
-
- 6 replies
- 1.2k views
-
-
I have the following formula in one file which works great. I want to round the result off to 2 decimals but I can't figure out where to place the (round) command. Normally I'd use "round(deposit,2)" but it doesn't work either at the beginning or end. Thanks If(Terms = "C.O.D",Total Proposal *.50, If(Terms = "Net 30 with Deposit",Total Proposal*.50, If(Terms ="Open Account with Deposit",Total Proposal*.50,0)))
-
- 1 reply
- 706 views
-
-
-
Hi all, Me again! On the hunt for some sort of table/chart/matrix listing interoperability between various flavors of FMS and FMP (client). For example, I have it in my head that FMS3 works with FMP3 and 4. And surely FMS5 works with FMP5. But does FMS5 work with FMP3 and 4? How 'bout Servers 6 and 7? For the curious, here's the "why"... My all-Mac office is now humming along fairly well with FMS3 and FMP4 clients. (Thanks to the assistance of this forum!) We're now on the cusp of establishing virtual offices for some of the staff. Like any other undertaking with such a Rip Van Winkle setup, the prospect of upgrading this or that comes up. Natu…
-
- 1 reply
- 1.2k views
-
-
Greetings! I'm new to the forum and glad to have found it. I own but don't currently have installed FM Pro 5.5. A couple of machines ago, I realized I wasn't really using it so didn't bother. Now I'm thinking about it again and also thinking about the current upgrade offer. Hence the questions. My primary use for FM would be as a digital image catalog. I've seen reference to that on the FM Page but no real information and I really, really need to know what file types version 7 recognizes. Specifically, I need to organize several Canon RAW photo types, primarily TIF and CRW images. I tried every search algorhythm I could think of but couldn't come up wi…
-
- 0 replies
- 1.4k views
-
-
hi~ i am having a problem, yet again (yes ;-)), with printing tables with grid in IWP. apparently, the table view in Inernet Explorer shows grid, but when printing out the the page grid is gone... any idea how to fix this or..?
-
- 2 replies
- 753 views
-
-
Hope someone is on at the moment (or soon)... I've done something dumb and can't get out of a validation loop. I have a zip code field defined as a required value. In experimenting with some other matters I created a portal that allows the creation of records in that file--but I didn't put in a zip field--nor had I yet added a delete row button. Now I have a record that I can't complete (no zip field) and can't revert or delete. I *do* have another window open for the same file, so I can access ScriptMaker. Is there any way out of this other than pulling the plug? Any help urgently appreciated. I'm leaving it open for now... RDecker
-
- 1 reply
- 1.2k views
-
-
Filemaker 7 has crashed on me a few times... it is a repeatable crash. I'm using FP7 to connect to a file hosted by FP7 Server hosted on OS 10.3.3 The layout I was using was a business letter had a global container field that was supposed to be displaying a graphic (a signature) that was meant to slide up/down with the text of the letter. The graphic was a pdf imported by another user. She was able to see the graphic on her machine, I was not able to see the graphic (all of us on OS 10.3), and when I clicked into the container field, Filemaker crashed If anyone can tell me what's going on, please do !! thanks crash log: Date/Time: 2004-08-13 15:46…
-
- 0 replies
- 1.1k views
-
-
If you view pretty much any layout in Layout Mode, It shows some kind of alternate text instead of the field name. What is causing that?
-
- 1 reply
- 837 views
-
-
I've been using Filemaker for years and always used the copy/new record/paste methodfor creating additional related records in a related database. This always bugged me because you would loose whatever you had on your clipboard. Then, I learned the portal trick (goto field, goto last repetition, set field). That is certainly better but it still requires portals in the UI that we don't want. I'm wondering if anyone has found anything new that makes this any better that doesn't require spurrious interface items. Thanks for your help! Eric
-
- 1 reply
- 850 views
-
-
Is there a way to NOT use portals if I want to have multiple records for the same ID shown? An example: I've got a participant number. Each participant number is unique. Each participant can have more than one appointment, but they may just have one. I'm trying to design a summary layout. I'm using the participant table to show most of the data but there are other tables from which I'd like to pull out data. As I said, each person can have more than one appointment but I can't figure out how to get the layout to show me more than one row if I don't use a portal. Is this the only way to get a repeating field?
-
- 1 reply
- 733 views
-
-
I have a database that is being used on both Mac OS X and Windows NT 2000. In one of the tables I have an 'insert file' button. This allows the user to insert a .pdf file in the database stored as a reference. Here's the problem: When a Mac user uses the insert file button, other Mac users can access the file fine, but when a Windows user tries to access the same file, a 'file not found' error appears. The exact opposite is true if a Windows user is the one who inserts the file. I know about hard wiring file paths for individual files. Is there a way to get FM Pro 7 to create file paths for Windows and Mac on the fly, without my having to go in and specifically type in th…
-
- 0 replies
- 809 views
-
-
-
hi~ this is yet another problem that i cant find a solution yet... for some reason the layouts are extended when being viewed in IE, and when one wants to print, the scroll bars appear! i figured that it's my layout that seem to be out of the margin, but even the ones that's within the margin is doing the same thing...
-
- 1 reply
- 1k views
-
-
Hello, I have a self join relationship that I use to find a value in a field that the user requests. This all works great, except when I export to either XML or Excel. My numbers are not formated. They are just like I entered them. I have it relating to a layout were the numbers are formated and I have make sure the check box is checked to pass on the formating to the export. This is driving me crazy, the same export procedure works great if the export does not need to be related by a self join. What am I missing. Thanks for your help on this.
-
- 1 reply
- 702 views
-
-
in the database that will update as I update the data in the record? The insert chart options don't seem to allow for this. Thanks, Vascular Researcher
-
- 3 replies
- 1k views
-
-
i'm slowly driving myself mad with frustration from trying to get a working group of db's for my small business: I have files for clients, work records, goods, job pricing, and invoicing, plus a simple book keeping file showing in and out payments. The thing is, I do a lot of invoices that consist of labour(from work records)only, and so i want the details to appear in the work records file, the job pricer file, and then finally the invoice file, plus the invoice total and number to appear in the book keeping file. Sometimes i need to have several items(either labour or goods) on an invoice, & sometimes I need just a general over all description. I've looked at …
-
- 9 replies
- 1.4k views
-
-
I'm adding a new password to a database I set up couple month ago. But even if I check all the box (except "access the entire file"), I got a freezen interface with "no access" on it. I have another pw I set up before, which has less access privileges, still can access. I use FM unlimited 6 and win xp. Can someone Please tell me why? Thanks!
-
- 2 replies
- 982 views
-
-
Hello, I develop database applications using FoxBASE+/mac 2.0.1. This is a very very old database system that is nearing the end of the road (even though it works in Classic.) In looking for other solutions I am also considering FMP. Can you point me in a direction or give me your comments on this issue. Does anybody have experience in porting FoxBASE to FMP? Where should I even begin? Thanks for you time! Danbo
-
- 1 reply
- 993 views
-
-
I have 2 fields in a table. Basically I need: if(Value in Field1 in any other record = Value for Field1 in new record) AND (DATE in Record = Date in new record) then disallow the creation of the new record. Please help me. I'm not that familiar with FileMaker. ~Jake
-
- 2 replies
- 804 views
-
-
Ok, I'm new to Filemaker, and fairly new to databases in general. Here is my setup: I have a table called "Master List". This is a list of all contacts. I want to have 2 other tables, "Members" and "Leaders". Those contacts in the "Master List" that are members, I would like to dynamically appear in the "Members" table, and likewise, those contacts in the "Master List" that are leaders, I would like to dynamically appear in the "Leaders" table. Contacts can be either Members, Leaders or Both. I have yes/no radio button field in the "Master List" for both Members and Leaders. Is there any way to dynamically generate a table based on those contacts that have "yes" f…
-
- 23 replies
- 2.3k views
-
-
I am having a problem with a calculation that is not working on the repetitions of a repeating field. it is to track a magazine subscription info. it works like this: 1. a date is entered in the 'invoice paid date' field 2. a field called 'first sub issue' then looks up the next value in another table which has all the dates for every issue published. [ie, if invoice was paid on 10/5/2004 and the next issue was published on 20/5/2004 and this is issue number 4, this will be the calculation result.] 3. a field called 'last sub issue' simply calculates 'first sub issue'+9. This all works perfectly in the first repetition of the fields, but not in any of the oth…
-
- 6 replies
- 2k views
-
-
Hey guys, I have used FM5.5 in the past, but very, very limited stuff. If you look at the FM7 Inventory template you can see a tab at the bottom that says Acquired Info, what I want to do is add another tab to the right of that that says Resale Info and another to the right with Installation Info. Each tab will have it's own information pertaining to the product such as MSRP and some end-user related notes under Resale Info and a product list ( installation accessories, X Recommended X Required) with links to those Inventory items as well as installation notes under the Installation Info tab. I really need to pick up a book on FM ( any suggestions? ) but in the mean ti…
-
- 2 replies
- 865 views
-
-
hi all. how does one make a find request within a portal and show only the found related records in the portal? i tried several times but it doesn't seem to work and keeps on showing all records in a related portal.
-
- 1 reply
- 730 views
-
-
I'm new to FM but not new to databasing. I've got experience designing and programming PHP/mySQL databases, so I'm pretty decent at coding. I don't love it but I can do it. I'm currently working on a database for my clinic so that we can track patients. It's pretty basic stuff, thus far. Just contact info, dosing information, schedules. The reason I'm using FM instead of mySQL is that it's a pretty elegant solution for designing a UI to the database. I like how easy it is to use. My question is this: What do I need to get this sort of system up and running. Currently, I'm just using the demo version of FM7. In terms of deployment, I'm going to have several diff…
-
- 21 replies
- 2k views
-
-
Hi, I'm a freelance geek, but I know damned little about databases. However, I do know that indexing is good where speedy search is concerned. Client's DB performance (server 3.0 on NT/client 4.0 on NT) was fine for 6-8 years and suddenly it's unusably slow. When client selects certain report options from the server, they get a status message that report is taking so long because it's sorting through unindexed records, then it lists the name of a field. When I look at that field, it's a dynamic calculation from the sum of other fields on multiple related DBs, which are dynamic calculations from other fields on multiple related DBs, and so on. There are 12 databases i…
-
- 0 replies
- 735 views
-
-
I have a problem that I know you guys here will help me with (you guys are the best)!. I'll try to make the problem easy to understand - I have two account types PAY_IN and PAY_OUT. Now what I want is that whenever the record is of type PAY_IN I would like the serial number to increase, but if I add a PAY_OUT the serial number shouldn't change. Any ideas on how this could be done?? Thanks Agent Shooter
-
- 1 reply
- 899 views
-
-
Any tips on troubleshooting this one? (I'm prob. doing something wrong...) I have a field validated and entered with a value list (pop up list) as either Yes or No. I can find based on those values manually with no problem, but when I try to script it, I get an error message, "No valid criteria." In the Find step of the script I specify "Perform Find [Restore]" amd specify: Finances::cleared: ["No"]. ('Finances' is the filename; 'cleared' is the field name.) I've also tried it with: [="No"]. Any help appreciated. RDecker
-
- 3 replies
- 690 views
-
-
Thanks to Mr. Brill, I have series of Find and Constrain Record Scripts running on my data. Is it possible to enter text on the page that will state which scripts are currently running. I would like a summary of my sorts to appear in the margin. For example: Data sorted by 1) Technical Success; 2) Males) 3) Diabetics; etc. So that as the user examines the data, he knows the constraints on his data. Is there a function such as the <<field>> function that would print the script name on the screen? Thanks.
-
- 2 replies
- 724 views
-
-
I am going to try and attach the zipped file again. Thanks to all who took the time to check it out. Dave EKGSTRESSTEST-6Copy.zip
-
- 0 replies
- 841 views
-
-
I've set up a database in our solution to record magazine titles, and we've been putting low-res cover scans (30kb at most) into container fields and serving these images using the web companion. I'm worried about the size of the database though. There's about 150 records with these images but the database file is about 8MB in size already. We'll be looking to probably treble that record number. 1) I was wondering if there was anyway to get the db size down? I really want the graphics to be stored in there - I don't really want it to be storing a link to the graphics. 2) I think the option 'store compatible graphics' is ticked in properties - does that …
-
- 0 replies
- 818 views
-
-
I'm creating a grade book. I have a table that contains the scores of each graded item for all students, in all of my classes. This includes homework, quizzes, tests, final exam, labs, etc.. Each class may have a different set of graded items (some classes may not have a lab, for example). So in this table, I have a student ID, a class ID, the graded item category and the score. In a related table, I have a list of my students and on a layout I can summarize, using a portal, the total and average that each student has earned for each graded item category. No problem. What I'd like to do is create a field in my student table that will hold each of these averages…
-
- 0 replies
- 750 views
-
-
Hi new to FileMaker Pro... I'm trying to create a script for FileMaker Pro that will export certain file to a specified directory. Is this possible and how would I begin the scripts. is there a template that I can look at and make my own? I'm not new to writing scripts just new to FileMaker Many thanks for being patient with me. Jovin..
-
- 14 replies
- 4.8k views
-
-
I have a database that I call Directory. We use this Directory to find which database a record is in. Currently I have to import records from all of my other databases manually so that the directory will be up to date. I would like to be able to enter a new record into any of my databases and have that record automatically show up in the directory. I think that I could probably get it done with a portal, but so far have not had any luck. Is that the best way to accomplish this or should I use an alternate method? Any help would be greatly appreciated.
-
- 6 replies
- 1.2k views
-
-
Hey guys, I am a die hard MS Access man, but recently heard about FileMaker and am interested. I have a large database that contains a subjects photo and basic information with subreports containing more photos and detailed information. My questions are this, Can FileMaker handle large number of photos and info per person like Access? Do the databases become huge and bloated? I currently store only the links to photos in my databases to keep them very small and easy to work with? Any help is appreciated before I drop any cash. I have the trial version now to tinker with. Thanks
-
- 3 replies
- 1.5k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online