FileMaker General Discussions
Older discussion forums for previous versions of FileMaker
-
I am working on a database and have been very disappointed by the speeds I am seeing for browsing records. I finally found one of the sources. The attached pdf is of a "Thumbnail" view that I created. This is done by a relationship between a global and a unique ID for each image. The page consists of 9 portals, each 4 rows high, which show an image. I can scroll this view by changing the global that defines the relationship (with a script, of course). I have been very disturbed by update speeds in scrolling--about 25 secs for an 800MHz G4! I have investigated changing the portals and relationships, and was able to get some marginal speed-ups. But the biggest spe…
-
- 1 reply
- 945 views
-
-
Hello all, I should start with version 7 in a few days and have tested the trial version, but I cant make following: When I should convert my old FM5.0 database I think I should start from scratch but its a lot of scripts and saving time I figure about reusing the scripts. I tryed import scripts to the trial version. I can see the scripts but not mark them and not import them into FM7. So my question is: Is it possible import scripts from an old FM5 database or should I convert it to FM7 before I import the script? Or is it impossible? Best regards -Per
-
- 3 replies
- 1.4k views
-
-
I'm running Windows XP with FileMaker 6.0. I would like to have a (Windows) scheduled task run a FileMaker script at regular intervals. I'm pretty sure this can be done with vbscript (WSH). FileMaker has an example in the help section on how to do this but it's written for VBA not VBS and I think the syntax must be a bit different between the two "vb" languages. Here's where I am so far: Dim FMApp, FMDocs, FMActiveDoc FMApp = FMPRO50Lib.Application FMDocs = FMPRO50Lib.Documents FMActiveDoc = FMPRO50Lib.Document 'Launch FileMaker Set FMApp = CReateObject("FMPRO.Application") 'Set the Documents Object Set FMDocs = CReateObject("FMApp.…
-
- 3 replies
- 3k views
-
-
I have a send mail script for a solution that uses Outlook Express. It mail script works on my computer but does not even call up Outlook Express on my clients PC. I have looked in the msconfig win.ini file and there is no [Mail] setup as stated necessary within FileMaker Help. How do I install this win.ini file?
-
- 3 replies
- 1.1k views
-
-
Hi -son of newbie question. Like features of FM7 - have created web pages with FM6 and CDML. Have looked at XML and XSL but question is can I use XSL to post info back to FM7 - all the books I have been looking at talk about re-formatting the XML and how happy XSL will make you, but nothing about user interacting with the database. Would appreciate any insight into how to use XSL to pass info back to FM7. About to start a big project - would like to use FM7 but if this XSL thing is a non-starter then FM6 will be used Serc
-
- 9 replies
- 1.5k views
-
-
Hello- I have 2 fields: "Age" and "DOB" Can you please suggest a way to enter a person's age (via calculation,script)into the "Age" field once their Date of Birth is entered in "DOB"? Also, is there a way to calculate what the date would be 30 days after a given date? Thank you...
-
- 2 replies
- 804 views
-
-
Sorry, but I'm a stupid newbie. I am totally lost, but here's what I'm trying to do: I have a "yes" and "no" check box. When yes is checked, I'm trying to get a field to keep track of the number of times it is checked whether it be yes or no. For example, the database keeps track of number of jobs won and lost. So the final result should be something like this: 9 out of 10 jobs were won resulting in a job-received rate of 90 percent. I am so lost I don't even know where to start...
-
- 1 reply
- 790 views
-
-
I have a pop-up menu where the user will select a section by viewing a list of text names for these sections - this is coming from another table of sections which have associated ID's. How can I use the ID of the selected item rather than the text that the user sees? Thanks
-
- 2 replies
- 854 views
-
-
Hi, I'm a complete newbie whom is very very confused. I really need to be able to send 1 record (which is also the current layout), By email. I cannot figure out the script! I also cannot find help else where. Many many thanks for anyones time explaining this to an idiot, coops. [color:"666666"]
-
- 2 replies
- 922 views
-
-
The discussion in the foregoing post has gotten too hard to follow, and I wanted to post an example of the solution suggested by Espringer. The task is as follows: You are given a database of car models. You don't want to touch that database because it is used by others, and you don't want to add cruft. You have a data of people and car ownership, and you want to display: 1) For every person, the number of cars he/she owns, and which models 2) For every model, the number of owners of that model, and which owners I was stuck on how to do (2). The solution is in the attached sample file. Unzip and open People.fp7. Sorry about the ugly design CarsPeople.…
-
- 1 reply
- 803 views
-
-
I am trying to create a customer list data base, but would like to add a page that enables the user to sort records by a zip code range. I've created a layout that has two fields; a 'starting range' and 'ending range'. Can I do this?
-
- 4 replies
- 888 views
-
-
How can I have all windows maximzied all the time, instead of having certain areas restore the window to a certain size that's too small to fit all my other customly-added forms?
-
- 6 replies
- 974 views
-
-
I know this has been asked before, but I would like to bring it up again in the hopes that some new forum participant can shed some light on the topic. Is there a way to activate a script based upon the results of a field value or calculation. If the answer to a question is yes, I would like to perform a script. If the answer is no I would like to tab to the next question. Can this be done in FM7 or Developer 7? Are there any plugins available that could do this on a MacIntosh Computer? Thanks in advance, Jarvis
-
- 7 replies
- 1.4k views
-
-
When a user performs certain functions, such as adding a new record, I want my application to do certain things, either before or after this action takes place. The only way I know how to accomplish this is to write a script and provide a button that the user can click to execute it. My problem is that if the user selects the New Record option from the Records menu or uses the keyboard shortcut Ctrl+N, my script is altogether sidestepped. Now, I can instruct users to always use my button rather than the menu option but that seems like a rather unprofessional solution to me. What do other developers do to overcome this problem?
-
- 4 replies
- 975 views
-
-
I just recently made the jump from version 5.5 to FM7. It feels like a brand new world. Excited that they made all these great changes, but feels like I have to start my training all over again. Anyway, I need some help. I downloaded FBT to take a look under the hood. Looks fantastic, but Excelisys didn't seem to make it easy to add additional NavIcons to the default of 8. I switched to layout view and select "modules." Back in browse, I added a new record which allowed me to add a new icon. Back in "settings" I increased the modules portal to show 9 records. My new icon now appears in the portal. Now, here's the big rub, how do I get it to display on the Na…
-
- 1 reply
- 933 views
-
-
Hi all, I am a newbie to FileMaker, although I have some basic knowledge about what Database is.. (DB concept like relational DB .., SQL, etc) I am creating an image library database(which also includes information on those images) consisting several tables. The database is about food. The tables are like <recipe>, <package of food>, <restaurant>, <tableware> etc.. Each records in those tables has one or more images and each images might be around 800k and at least 10000 images total at the moment. I expect around 3-40000 or more images in the near future because we are planning to input much more data in the future. I know that FM7 suppor…
-
- 5 replies
- 1.3k views
-
-
I am looking for some suggestions on which software to puchase to create a catalog that is linked to my filemaker database. I've been doing some research on Adobe InDesign and QuarkXpress and was wondering if anyone has used these programs to create a printed catalog. Any help would be greatly appreciated.
-
- 13 replies
- 2.1k views
-
-
I installed FileMaker Unlimited 6 and Web Server Connector on Windows 2000 Server. If I reboot the server and connect to the Web Server Connector administrator page I get prompted to respecify an administrator account and I also have to reconfigure my databases in the "Configure by Host" page. This only happens if I reboot - if I have not rebooted I'm able to access the administrator pages without re-entering the information. The FMU 6 admin guide says you can reset the WSC administrator settings by deleting the fmwsc.properties file in the WSC folder - however I do not have that file in the folder nor anywhere else on the hard drive and I suspect that is related to t…
-
- 0 replies
- 860 views
-
-
How can I have a value list only list the apartment numbers that are "Empty" ?
-
- 4 replies
- 876 views
-
-
Hello~ I have a question. I am in Korea, and I found when I import a file with Korean filename and show the filename in the records(not having problems with importing those files with Korean names) or when I use value lists with Korean text to use in Radio buttons, check box etc., the letters become all □□□(empty squares) . I don't have any problems with typing Korean in fields and They are saved well, and are shown well when I reopen the files. The problems occur only when including importing behavior.. How can I solve this? Currently in Korea, there isn't any vendor of fileMaker. I bought a Filemaker in USA. T…
-
- 1 reply
- 1.1k views
-
-
Hi! I have a table with products and one with orders. Orders are registered in a portal and there are several lookup fields. Can I prevent the user permanently from performing a re lookup? Ideas are welcome!
-
- 5 replies
- 903 views
-
-
Using FM7, Win XP, for medical-oriented project. Am using lookup tables pretty extensively in my project and interested in "nested" functionality so that my lookup tables/corresponding fields are smaller/more manageable in the layout section. I will try to use a car database analogy to represent what I would like. Consider the car dealer/seller who has a field in his master database for a car (e.g. to be bought/trader). We'll call it field 1. Rather than typing it in it (e.g. Toyota; Camry; 1987; 4 door;) it is a drop down list or menu (with submenus) that would give him the choice of all the possible cars out there. For this example the drop down menu's first level w…
-
- 1 reply
- 1.8k views
-
-
Hello All, I am using oAzium Charts plug-in to add some graphics to my application. I can use the RGB command or the color names in the line commands of the plug-in to stablish the colors. I added check boxes in a "configuration area" so that the end-user can change the color of each graphic part (vertical bars, pie-charts, etc) based on names of the colors. However, I would like to know if it is possible in FM 7 to use a pop-up field where the end-user can change the color of graphics based on the colors itself, not the text. Or even better the end-user to use a tool like the fill color tool that exists in layout, where a plenty of choices can be made, just click…
-
- 0 replies
- 1.1k views
-
-
How I can disable New Record command in Browse Mode in Layout, is there any script for that, also like to know if it
-
- 4 replies
- 6.9k views
-
-
Hello I am totally new to fileMaker. What is the difference between making database of several files and tables? Is there any limitation to any of them? This might be in the manual , But plz be generous.. running out of time.. Thank you very much~
-
- 2 replies
- 897 views
-
-
I've searched the forums and couldn't find this addressed... It seems that I've been able to get sliding up to work correctly for everything except text objects (field labels). As long as the text objects are on one page (don't cross a page break), they will slide up correctly. As soon as they are moved below the first page break, they just disappear in Preview / Print. The other objects (fields, rectangles, lines, etc.) slide up fine, but the text objects are gone. I've attached a simple file to show this working. I'd appreciate it if someone could confirm that this works or doen't work for them as well. It smells like a bug. Of course, I could make the fi…
-
- 5 replies
- 1.3k views
-
-
I went to reinstall 5.5 Unlimited on one of my servers this morning only to find I have a huge scratch on my CD. I can't install 5.5 or the web connector. 1) Do you think this media is still available from FM 2) Can someone make me and ISO of this disc so I finish installing this weekend? Email me sam-at-systemsam.com
-
- 0 replies
- 1k views
-
-
I am developing a Property Management DB system now I need to incorporate the Invoice part of it. The Db has many units each unit has many different charged like; telephone, rent, parking, water etc... What is the best way to it?
-
- 1 reply
- 999 views
-
-
Hi! Two questions: In FM6 I used to create a template file with graphics and standard fields like creation date, serial number etc. In FM7, multiple tables in one file seems like a good idea. But now I have to create standard field by hand for every table. Is there a better way to make a template? Tabs for layout navigation is nice. But I don't want user to end up in that ugly "No access" screen. What is the best approach? Thankful for insights!
-
- 15 replies
- 1.8k views
-
-
Hi. Please bear with me. A friend of my wife's has asked if I could 'fix' her Filemaker application on MacOS 9.x (not sure which version, guessing 5/6). She bought a home-based aromatherapy business including the iMac and its applications and client base (I guess). The original owner/programmer is unreachable. The problem is, when she prints labels, there is a field that doesn't show in the label document. It's a warning, "External Use Only". I have looked around in page/print setups, document prefs, layout views, etc., etc., and cannot find this field. She wants to modify or remove this line from the labels. Can some kind soul point me to how I can locate …
-
- 2 replies
- 843 views
-
-
I have noticed that as you scroll down the portal on a record, and you reach the bottom, it does a kind of bounce, then starts to screw up the look of the records being displayed. The actual records are ok, just viewing them only. Am I the only one seeing this problem? I also tried to update the V2 update, but it won't work without the CD... and seeing that I bought the program from a download, I don't know what to do... maybe the problem is fixed with the update... any ideas or comments?
-
- 10 replies
- 1.6k views
-
-
Whenever I print, it does fifteen labels well, and then just jumps down about 5 lines and splits a record throwing the sequence of printing off. Any suggestions?
-
- 1 reply
- 862 views
-
-
I am very new at FMP. I taught myself so bear with me. I created a database for capturing various information on our Subcontractors. Our subcontractors are on several different jobs. I have a different record for every job that subcontractor is on because different data comes in from each job. When creating a report, how can I have the common data from each record not repeat? For instance it goes to the next record and prints the information only if the previous record does not have the same data. Andi
-
- 2 replies
- 837 views
-
-
Can anyone point me towards a summary of FM7's rules for maintaining the "found set" of records? It seems that if I create two entries in the relationship panel that point to the same table, each can have it's own found set. I rely on this to allow me to work on a different set of records in a script without changing the found set as seen by the user.* But then I discovered that if I open a new window using the same layout (and hence the same entry in the relationships), each can have its own found set. So as I am developing scripts that rely on knowing what the found set is, I sometimes manage to get very confused about which script steps will see which fo…
-
- 2 replies
- 1.1k views
-
-
I'm a slight newbie with FMP. We've bumped from 4.0 to 7.0...yup, a big one. I'm creating my department's database for equipment use scheduling from scratch so that we can take advantage of some of the new things with 7. One area that I would really like to get to work is the 'Show Custom Dialog' in the ScriptMaker section. The 'Show Custom Dialog' has the ability for and 'Input Field' area. This is to allow the user to enter information. What I'd like to do is have the user enter a date of the records he/she wants to print out and continue with the printing script. What I can't figure out is how to make the date that the user entered go into the 'Date' field…
-
- 5 replies
- 1.1k views
-
-
Hello, I work in a biochemical production lab, and we use Filemaker v5.5 to archive data regarding our production. As of late, our database has started to become quite sluggish. I have some ideas that may help speed it up, but i need to make an inquiry as to whether one of my ideas is worth the effort. I believe that in large part the database is getting bogged down because of the number of containers in each record, and the enormous size of picture files being inserted by some of the techs. There are 3 containers in each record, containing images of size exclusion chromatogram, anion exchange chromatogram, and biotinylation assay. Now, I'm almost certain there…
-
- 5 replies
- 928 views
-
-
I'm just learning Filmaker & have a question. I have a 2 page invoice I've created & I want to add a 3rd page. The 3rd page is "Terms & Conditions" (legal stuff) but want to have the ability to choose whether I attach this page to each record. In my mind ... I would have a button that would attach/detach this 3rd page. Or a simple way to hide/unhide the 3rd page. The 3rd page is 99% unchanging, static information with a few fields at the bottom that reference the invoice number, the date, etc (page identification). My question is this ..... How is the best way to do this? Would it be smartest to reference the 3rd page externally so it's not copied to each reco…
-
- 4 replies
- 888 views
-
-
After upgrading to FM7v2, I am getting a number of "Filemaker has unexpectedly quit" error messages. This is happening on 2 machines, one of which has a freshly-installed system, so I suspect that it is not related to the configuration of my computers. The database that I am working on is complicated, and the quits often seem related to trying to display portals. Are others seeing this? Do others feel that FM7v2 is less stable than v1? A
-
- 1 reply
- 901 views
-
-
Format painter does not seem to work for portals, at least under OS X, FM7v2. I click on a portal, click on the format painter, and click on a second portal, and I get some combination of line width and color that is not related to the original. Is this a bug for other versions of FM7v2? Thx
-
- 0 replies
- 843 views
-
-
I have just upgraded to fm7 (from 6) and most things have been fine except for an annoying feature with hidden windows. I have one main file that the user works from - if this file 'uses' another file, that file momentarily flicks into the foreground, even if it was hidden before, or if 'freeze window' has been selected. This did not occur in fm6 - how can I stop this happening? Thanks Emma
-
- 1 reply
- 867 views
-
-
Is there a way for putting an auto-tab (auto new field) funtion when a specific amount of characters is reached ? Thanks !
-
- 2 replies
- 882 views
-
-
Hi, I created a db called tuition The fields in tuiton are: Students Name, Beginning Balance, Payment amount, date of payment, next payment due, amount of next payment. When I click on tuition db from mainmenu, and go to student name choose the student I want, and once chosen Beginning balance automatically enters the balance(previous month balance-payment amount) into the field. Is this possible? Sorry if this is not clear trying my best! Thanks
-
- 1 reply
- 1.9k views
-
-
I'm trying to import FileMaker database into Microsoft Access (using ODBC driver DataDirect SequeLink 5.4). But all records with ANY numeric field with decimal number - are non-readable by Access (showing message as 'truncated data by decimal value data'). Altough I have reduced (rounded) original decimal numbers to just two digits (X.XX). Please if anybody knows what to do.
-
- 2 replies
- 833 views
-
-
Hi; This is my first post here so excuse me if I don't get things right first time. I have migrated an old FileMaker II file up to my newly installed version 5.3. It seems that is has gone OK except for one bug(?). My file is a simple data base layout which I use for our company's invoices. fields are simple
-
- 5 replies
- 792 views
-
-
how can copy a table from fm7 file to other fm7 file or to itself with other name with keeping filed definitions and datas.
-
- 1 reply
- 794 views
-
-
I have a form where I use a pull down menu to select a client. I'd like that to trigger other events too, such as select that client's phone, fax, email and company name in other boxes automatically - currently, I have to do all of these manually. So if I choose client A from the menu, client A's phone etc would appear in the phone area without me having to go there and select it from a drop down menu. I have very little experience with fmpro, so go easy on me! Thanks in advance.
-
- 1 reply
- 641 views
-
-
A quick question: does anybody know of a workaround/solution for records that have multiple associated files that can be stored in one container field without having to clutter a layout with a large number of containers. Currently, I seem only to be able to store one file per container field. It would be nice to be able to store multiple files in one container field. Any ideas? Thanks!
-
- 2 replies
- 1.2k views
-
-
Hi all, Can anyone tell me where are the host names (or ip addresses) stored when a host's DNS name or ip address is added permanently to the host list (or) How can I get rid of a host name that was added to the host list. Thanks FileMaker Version: 6 Platform: Windows XP
-
- 4 replies
- 3.6k views
-
-
I'm a new user. I am having to upgrade an existing application (.fp5) to version 7. After the upgrade, the application runs but every click takes about 10 seconds to respond. Has anyone experienced this?
-
- 2 replies
- 946 views
-
-
Hi folks, Sorry if this has been asked and answered here before but my searches came up blank. I have an FM6 database with a global field called gSystemID. I would like to script a routine that would import from an Oracle DB only records that matched the vaule in the gSystemID field. Here's what I would like to do as written as a simple SQL statement: SELECT phone, fax, city FROM installed_base WHERE system_id = gSystemID; There doesn't seem to be any way to insert a variable into the import records function. What am I missing here? Thanks,
-
- 5 replies
- 1.9k views
-
-
I have created 3 tables: 1. Songs 2. Collections (of Songs) 3. Concerts I want the capability to show certain collections to be viewed in a pop-up list in table 3. My first try at this was to create a global repetition field that allows the user to select the collections he wants to appear and use in the pop-up list, but it will not allow me to index a global repetition field in order to create a popup list in the 3rd table. How can I go about doing this?
-
- 5 replies
- 1.1k views
-
-
Hi, I guess this is trivial, but hey... I am trying to export data that is pulled into a table (A) from another table (: by look-ups. Other flieds are just pulled in as a related flield from table B. I need to now export this data from table A to an excel file. How can I do this? Since the data is not really sitting in this table the export to a tab delimited file does not work. Thanks, Stephan
-
- 1 reply
- 802 views
-
-
I am trying to make the ending balance (calculation field) in one record be the beginning balance when I create a new record.
-
- 2 replies
- 1.3k views
-
-
how do you calculate a field upon the creation of a new record?
-
- 1 reply
- 823 views
-
-
Hi! I have a question about serial numbers. I would like to type in manually also, and if I do so, I would like the next serial number to be the number I typed in plus 1. Is this possible (without changing manually in the "Define Database" menu choice)? regards /P
-
- 2 replies
- 866 views
-
-
I just converted from 6 to 7. When I fully justify text in a text box some of the letters on the right hand side are getting cut off! If I make the text box bigger or smaller it keeps on happening. Any suggestions?
-
- 2 replies
- 1k views
-
-
How does FM handle serial numbers *in different tables*? If they are required to be unique, does this mean *unique in the table* or *unique in the entire file*? That is, can the same serial number exist for two different, *unrelated* records in the same file (each in a different table)? (I have a specific perplexity, but if someone can explain the concept here, that may help me figure it out. If not, I'll give an example.) Thanks, decker
-
- 3 replies
- 1.1k views
-
-
I have several office databases all clones of an original. I would like to consolidate them into one data set, but allow only an admin and a manager to view the individual records associated with that manager's data. The only real field that is changed is an auto enter signature field and another of a similar nature. If it can be done, how do I go about doing it? Thanks!
-
- 1 reply
- 1.7k views
-
-
I am a new user to FileMaker Pro. I am a previous user of MySQL and MS Access. This switched came after my recent switch to a Macintosh with my purchase of a PowerBook. I am quite impressed by the software and realize that I have been missing out alot before switching over to Mac. i find the software very intuitive and easy to use. However, I find that this one feature: "portals" is very difficult to use, and is not very intiuitive and obvious at first. I have a few problems that i hope you could help me with. In using portal to display related records from another table, I have the following questions that I need help with. 1) When adding a portal to my page la…
-
- 4 replies
- 1.2k views
-
-
Hi I'm trying to create a script that will allow to duplicate a record and it's related records. The problem that I am facing is that when I duplicate the parent record, I need a way to get the related records of the original parent record. The way I was going to go about it is, Duplicate the parent record Store the new duplicated record id into a global (not sure if this is the best way, might be 6 thinking) Go to the related record of the original parent record. Loop through and duplicate the related records and assign the parent id with the value stored in the global. The problem is, when I duplicate the original parent record, I am at the du…
-
- 2 replies
- 893 views
-
-
I have filtered a table to select a certain city. Of all those records, I need to enter the county for those cities. Is there anyway i can update those records so i don't have to paste the county name over and over again? Help, Please!!!!
-
- 2 replies
- 941 views
-
-
wht's this problem when i try to open a fm7 that shared with instant web publishing in a windows 2000 advanced server?and what's it's solution? the maximum number of users allowed to connect to this server has been exceeded.
-
- 3 replies
- 974 views
-
-
Here's problem that has me stumped. I have a giant database of people, with addresses, genders, etc. I'd like to get this to the point where I have one record for each unique household where each household record includes the number of people in the household by gender, i.e. MM or MF or FF, etc. Anyone have thoughts one how to efficiently do this?
-
- 9 replies
- 1.5k views
-
-
As I understand it, you can set a relationship's default sort, and you can sort portals based on that relationship independently. All of which is nice. Has anyone discovered which is the more efficient, if your two sorts would be the same? Better to sort at the relationship level or leave that blank and sort at the portal level? Thanks, oh wise ones.
-
- 3 replies
- 886 views
-
-
has anyone found a solution for in FMP7 that will let you highlight a portal row of the current record being viewed no matter how the user navigates to that record?
-
- 2 replies
- 1.8k views
-
-
I am new to Filemaker and am about to start work on preparing a mailing list (250 names approx.). The mailing list is currently held by a colleague (on MIcrosoft Access). Is there any way to import it into Filemaker Pro 3.0? My OS is Mac 8.6
-
- 6 replies
- 1.2k views
-
-
The new update is here!!! Wohoo, Yiiiiha. Dont start downloading until my download is finnished, so you dont crash the server... I hope this is good. www.filemaker.com
-
- 5 replies
- 3k views
-
-
Hello I would like to know if Filemaker pro 7 can make a desktop Picture change on both platforms somehow. ? maybe a plug in or some way I don't know about? thanks
-
- 3 replies
- 785 views
-
-
Hi All, I am trying to calculate the change between records of the same field - i.e. the difference between Field1 with a date of 1/1/03 and Field1 with a date of 2/1/03 and between Field1 with a date of 2/1/03 and Field1 with a date of 3/1/03. This "difference" could be calculated on the fly each time a report is run or calculated once and stored with the 2/1/03 and 3/1/03 records since they will never change. Below is a sample of what I'm trying to do. Any suggestions are greatly appreciated. Thanks, PaulT Item_1 Date Inventory Change from Prev. Mo. 01/01/2003 550 02/01/2003 244 -306 03/01/2003 5 -239 …
-
- 4 replies
- 1.4k views
-
-
Is there a way to get the Field Names in TABLE VIEW to align in a column down the left and have the values display as horizontal rows to the right of the field names? I know that Filemaker is not a spreadsheet program, but it is so versatile in reporting that this just seems like it should be a no-brainer. Can anyone aim me to a solution here? Thanks, Jarvis
-
- 1 reply
- 1.1k views
-
-
The last time I used FMP was 5 years ago and I have forgotten most of what I learned. I do remember there was a simple and elegant way to put the field title "in" the field and then once you tabbed into the field or entered data the field title disapeared. I don't think this was done with calculations. I did a search on the web and in this group for the solution but found none. Anyone have any ideas? Thank you.
-
- 3 replies
- 729 views
-
-
Can anybody tell me why it is not possible to simply copy then paste all or part of one table into another one? This just seems like such a productivity enhancement that it can't have just been overlooked. Are there any plugins for the MAC that would accomplish this for me? Thanks, Jarvis
-
- 5 replies
- 1.1k views
-
-
I am using FM7 on a mac and have a customer layout with a portal to invoices. I click a button to go and add an invoice and then return to the customer layout with the invoice portal. The new invoice record does not appear in the portal until I click somewhere on the layout. After adding the record, I am using the "Commit" option. What am I doing wrong? Thanks for any help!
-
- 1 reply
- 922 views
-
-
What function would I use in a calculation to evaluate data in a repetition field with 10 repetitions compared against a field with no reps? I want the calculation to run the comparison on all 10 reps.
-
- 1 reply
- 886 views
-
-
New user to FMP7; have used MS Access 2003 before; am trying to develop a medical type database and just setting it up. For the sake of simplicity/learning the principle, I am trying to relate 2 tables/layouts. Table 1 is patient main table (demographics, basic stuff); fields are: patientID (unique number, serial autoenter; primary key) patientName (text field) Table 2 is patient visit data (new record each time patient is seen by MD); fields are: PatientVisitID (unique number, serial autoenter; primary key); PatientID (number field, not primary key; to connect to patient main table) DateOfVisit (date) complaint (text field; eg headache, etc) 2 corr…
-
- 10 replies
- 1.4k views
-
-
Hello, I am thinking of upgrading to FM Pro 7. I now have FM Unlimited 6. I have read some of the literature from FileMaker but it does not clearly answer these questions (nor have I found the answers in this forum, but I don't follow it every day and searching doesn't always come up a useful post): FM Unlimited 6 allows unlimited number of people to access a database over the web. Pro 6 has a severe limitation, don't recall exactly, but something like 10 users in a 24 hour period. How many people can access FM Pro 7 over the web using Instant Web Publishing? How about Custom Web Publishing? Any difference? I suspect that one cannot create a database …
-
- 1 reply
- 900 views
-
-
(No anoying dancing bananna here - but I feel like it) . Been working for weeks on a new ground up 7 solution. Because I thought I couldn't use Global fields for relationships - I had been avoiding them. Then, by accident, I discovered it works - at least for the way I was needing it. Now I just have to get my globals organized. Like in the olden days, they are all over the Tables - when I need one I have to go searching... . . . (Oh what the hell.. this one deserves the bananna... . . . . )
-
- 0 replies
- 1k views
-
-
I need to set-up a report to be sorted by the values in fields with 3 repetitions. So far it works fine but it only sub-summary sorts the values on the first repetition. Any idea how to fix it! [i have a list of office numbers and each receives one or more newspapers. I need to have it report what office numbers receice newspaper 1, 2, etc. The Newspapers are on a drop list that is assigned to the newspapers field (3 repetitions) I need it to list the office numbers by Newspaper.]
-
- 2 replies
- 1k views
-
-
How can I have the layout name and the total number of records show on layouts?
-
- 2 replies
- 1.8k views
-
-
Hello there... I have a strange problem in my office's FM Pro v.4. The server at my office hosts all my FM documents and domain clients who access any of the documents have to view them as guests. Everyone's using the same version by the way. One of the documents hosted is a staff personal particulars file which holds all the information about each staff. My job is to simply add in staff pictures into each profile (and I'm doing this NOT from the server but from my own desktop). I did it once about a few months ago by just cutting the picture in photoshop and pasting it in the picture frame in each staff's profile page. Now, when I tried it again a few days back, th…
-
- 7 replies
- 2.1k views
-
-
My question involves multiple applications of THE SAME VERSION: I have FMP6 Unlimited, FMP6-Dutch version, FMP6-Developer, FMP6-English v1 and English v4 installed on Mac OS X 10.3.3. So this is 5 FileMaker Pro 6-applications. I would like to know based on what the Mac OS X decides to open which app when I double-click a FMP6-database. Is it the last app installed? Or is it something else? And can I control that? What I do now, off course, is first start up the application I want, and THEN open the database. And I do a lot of drag-dropping. But I'm curious: how does the OS decides which app to open (since I have 5 more-or-less-the-same)?
-
- 1 reply
- 694 views
-
-
-
I am a New to Filemaker and am trying to set up a database for my small company accounts to mainly manage client details - job details - invoicing and accounting reports. Trying to build something along the lines of MYOB accounting but a little less complicated. I would like to know how I can create a layout with tabs across the top so I can store related information over the course of a few screen rather than all on one screen as it starts to get a bit cluttered. I hope this makes sense - If anyone can offer any advise on this I would appreciate it. I am working my way though most things using the help function but can't seem to find anything about this. T…
-
- 1 reply
- 827 views
-
-
I am totally new to FileMaker and I created a solution for a friend that will help him manage his 1,000-odd member records (turned out great,thank you FileMaker). Well I created this using FMP7 on my mac and went to install FMP7 on his computer.... only to find out version 7 can't be installed on windows ME or lower. Talk about frustrating.... so now what do I do?? Can FMP6 read a .fp7 file or am I going to have to install Win 2k on his computer (last resort)? This database I created is straightforward and does not use relationships etc. Can someone help me? Thanks
-
- 1 reply
- 974 views
-
-
How can I create a script to auto find all records in a date field within 3 months from today?
-
- 4 replies
- 1.9k views
-
-
I have been using a Cue Cat to catalog a collection I have. Yesterday, though, FM PRo 7 could no longer find the data the Cue Cat inputted. I took out the spaces in-between the two sets of numbers and it found the record (the barcodes I'm reading have two parts). I've been doing this for at least two years now and this was never a problem before. I tried several other programs and FM was the only program with this problem. So, I tried entering the barcode into a text field, instead of a number field, and it works just fine. I hesitate changing the barcode field to text because I don't know if this is an aberration due to a Mac OS update (I just did 10…
-
- 2 replies
- 1.1k views
-
-
I just started learning File Maker Pro 7 and have been doing well but have run into one thing I can't seem to find out how to do. This database keeps tracks of many dates. I would like to have basically a date field that is an array so that it remembers the last 10 or so dates entered (which can also be referenced in formulas and I would actually like to do this for many fields). Obvisouly making a sperate database that is relational would not work because I would need a new database for each record then. Is there anyway I can make fields work as an array? Thank you.
-
- 2 replies
- 969 views
-
-
Wow... I'm about 70% through this solution for Texaco, an automotive POS solution and this thing is really looking busy. It's not a converted solution, it's built from the concept up on FM7 with every new trick and gizmo I could find to optimize it. This solution replaces one built in FM6 that had many files and even more realtionships. This one just looks so ******* confusing becuase it's all crammed into one place. I need a monitor the size of my wall to see all this stuff. And - this is with as many advantages I could gain through all the new power of FM7.
-
- 9 replies
- 1.5k views
-
-
I've 2 following related questions of how to terminate an shared FM4 database automatically from the server. 1) I've no problem to scheduled a task to excute a script in a separated FM4 to close/exit a logined FM4 remotely. But my control script doesn't work if FM4 is left at login session. It's because that FM4 is not login yet. is there anyway to terminate the FM4 process either from the Windows or from FM4. 2) If the problem in the question 1 above occured at remote workstation then I can't terminate the FM4 automatically from the server, because the FM4 will ask the guest to logout and waiting for a response of on "Ask" button. …
-
- 0 replies
- 833 views
-
-
I am using a script to perform a found set of records; however, I want to be able to go to a specific record in the found set. For example, I'm on the current invoice record for ABC Inc (Invoice #2) and I'm interersted to see what other invoices exist for ABC Inc. I want to perform a search for all ABC Inc invoice records, but once the set of records is found, I want to view the original invoice #2 first. I feel like I'm close to a solution, but not quite there. Please help!! Much thanks in advance. Michele
-
- 3 replies
- 3.9k views
-
-
I have been learning FMP6 for the last 8 months, and have done some considerable progress. But I would appreciate very much to read your comments. I have a set of six DataBases related to each other that I use in my small business to print invoices, control the guys who haven't payed me yet, notify my customers when they are due, etc... Last week I took on the task to get my DataBase to notify my customers with an html-enclosed-email containing the items, prices, sub totals and Total of their purchases. Why html-email? Because I was using a script to "print to pdf" and attach to the email. But some of customers, PcUsers sometimes replied "can't open…
-
- 4 replies
- 796 views
-
-
I do a search on an indexed field, then I want to constrain that find by searching on a unindexed field. Filemaker insists on search all the records! This is a huge time waster in my 208k-record file. Is there any way around that? Why did Filemaker do this?
-
- 1 reply
- 592 views
-
-
I created a database with many files that are related to each other, what script do I use or need to send me to that specific field? e.g. file name X file name Y ((File name Y-1)) etc... (Field name Y-1) etc... Please help me
-
- 4 replies
- 663 views
-
-
Ok have set up a layout for printing with 3 rows accross. All is fine apart from when I want to print only record from my main layout. In this case it only fills one row. How do I get it to fill all 3. Also is there a way to select which row it prints in, i.e top middle or bottom. (All in relation to an a4 label paper, 3rows, 4columns) Thanks
-
- 2 replies
- 1.1k views
-
-
I have been developing multiple scripts over thirty files on my desktop. The scripts point to my computer's IP address. When we put the files on the server hosting FM Server, the scripts are slowed down dramatically because they are searching for the IP address on my computer. Is there any easy way to set all scripts to look for the correct FM Server IP address. The alternative is to open each script and point it to the correct server. Any help would be appreciated. Thanks. Kurt Bleicken
-
- 6 replies
- 982 views
-
-
Hi, I wonder if there is a way to allow user to select the columns that they want to see from related tables and display them on the next page whereby they can choose if they want to view as report or export search results. i hope i don't sound too confusing. The first page is actually a search form whereby user can define their search criteria and they can choose the fields that they want to see. On clicking the search button, they will be shown the list of search results containing only the fields that they want to see. From the search result page, they can choose to view the list as a report or export it into .csv format. Is this feasible? So far from my ex…
-
- 3 replies
- 824 views
-
-
I have found the function "If ( CODE="1" ; TextColor(NAME;RGB(150;0;0))". I have a field "name" and a field "code". If "code"=1 I want to turn the "name" field text red. I cant get this to work any ideas? TIA Ivan
-
- 7 replies
- 2.9k views
-
-
Hello, Does anyone else have experience with FM7/OSX with the new version being ssssoooooo slowwwwww? I'm running a G4/400MHz/512MB with only FM7 on it, and the application has become so slow that it is a pain to work with. Small scripts that took 0.5 seconds (which I already found to be slow!) in FM6 now can take anywhere between 5 and 10 seconds (changing between files and layouts) in 7.0. It is really horrible. All relations are local, so no wildcards etc., only direct links to files in the same folder. I'm used to PCs and run industrial programs on an outdated systems (P1, 64mb etc) that have about 100-200 scripts running at last twice per second. I do…
-
- 10 replies
- 1.9k views
-
-
I receive the following message opening the database: "FileMaker cannot share files because another user is already sharing files using FileMaker Pro on this computer." I verified that all users listed under EDIT/SHARING had the sharing off, but that makes no difference. Appreciate any help on how to reset this to share files.
-
- 3 replies
- 1.1k views
-
-
New to FMP. I would like recommendations about companies that host FMP databases. Please advise.
-
- 1 reply
- 1.4k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online