FileMaker General Discussions
Older discussion forums for previous versions of FileMaker
-
A question that I have in mind ever since I work with Filemaker. Clicking somewhere, anywhere, where there isn't any object often helps me to.. - make ugly field borders disappear - force calculation of a self-related field in some wicked Databases - ... how do I create the event "clicking on no specific spot" with the scripting features? I used to do dumb workarounds like opening and closing the Scripting tool, which gives me for some reason the same result, but I think its time for a smoother solution Martin
-
- 6 replies
- 845 views
-
-
Hi all, I've just started seeing an install error that I've not seen in my 6+ years of using FMPro. We've been using v5.5 (VL version) for several years on Windows 2000, the installation being handled by Novell's ZENworks (essentially just calls msiexec). This has worked flawlessly for many years. I'm not sure what's changed but in the past couple months, several of our users have received the following error message when trying to run the program after an install: "This application has been installed incorrectly or modified by another program. Please run the Installer to get a fresh copy of the application after determining the cause." There are no errors in th…
-
- 5 replies
- 1k views
-
-
I noticed that if I put a text field in a portal with @@ it shows a running count of the records displayed in the portal. What the heck is this feature? I can't find it in the help, and are there more? Dave
-
- 2 replies
- 603 views
-
-
Didn't know where else I could post this question, If somebody could help or direct me to a forum more suited let me know! Question/Problem: FM7 seems to shut off Font Reserve. I'm using the latest versions of each on Mac 10.3.4 - It happens on 2 computers in my office. Can't seem to find issues out there besides me. Anyone have this problem? goin' bonkers! Dan
-
- 2 replies
- 760 views
-
-
When going from one file (displayed on th desk top) to another file (hidden), end up with a displayed window and a hidden window for the same file. This causes the displayed file window to loose the hand pointer over buttons, and the show hidden list won't respond appropriately (ie. the duplicate window name is at the top and below are the other window names; when I click one of the names in the list, the item below is shown rather than the selected one). Upon opening, all files have an opening script that make sure the file is on a blank layout (no access), the window tile is set to file name and then is hidden. My script in fileA is: perform (external) scrip…
-
- 1 reply
- 771 views
-
-
I could have sworn I posted this yesterday but I cant seem to find it so if it's a dupe please disreguard, if not here is my problem: I have a database with auto entered serial numbers, the problem is I need to be able to enter numbers out of order as well as have the auto entered serial number pick the next free number. So far the auto enter works fine and I can enter an out of order number just fine, but when the auto enter gets to an out of order number that already exists it will still pick that number, I need it to skip numbers already in use... is this possible. Thanks.
-
- 19 replies
- 2.6k views
-
-
This may alient professional developers; sorry if it does, but I have a fp5 file solution that was cheap to buy, but expensive to add users, so I am torn between continuing it or just starting over with something that will let me add additional users at no extra cost, save the additional fp7 software. I have a small business; every bit helps. My question, does a migration from 6 to 7 allow me to add seats to a single user file, or is this code buried somewhere that is not accessible, except to the original developer, regardless of the version.
-
- 2 replies
- 646 views
-
-
Post deleted by Jamie Dahlstrom
-
- 2 replies
- 762 views
-
-
I'm wondering if anyone has a good, helpful location to bookmark for reference when various errors are encountered with FM. Currently I am attempting to add a record to an FM table and am getting the following: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL I am a very novice user of FM, so excuse me if this is an easy one for you gurus. The above record creation was in an attempt to insert values for only a portion of the columns, not all. My initial thought was that there was a "required" column that I was not including on the add. However this does not seem to be the case. Here is …
-
- 2 replies
- 732 views
-
-
I need some help being pointed in the right direction for a filemaker 7 solution that I am working on. I have been using filemaker for a while, but have just started working with portals in the last few months. I am working on creating a problem tracking system and here is what I want to do. I have 2 tables - equipment and problems. On the layout for the equipment table, I want to have a portal that will show all problems associated with that piece of equipment. I want to have a "new problem" button on that layout which will take me to the problem layout tied to the problem table. When I get to the problem layout, I want the devicename from the equipment table t…
-
- 1 reply
- 744 views
-
-
Guys, I need some help here, I am totally new to FM, and I am not a DB expert, so I use the filemaker's template for Home > Photo Catalog database to store digital pictures... all works great, the problem is when I try to open a remote database... the database opens great in the network, but the images won't load... any of you knows how to fix the issue? The error is "file not found" in the image field. Where is the problem exactly? TIA, Steve
-
- 3 replies
- 1k views
-
-
Does Filemaker have an easy way to copy a record and it's related records without having to do it all manually? I have a program that's used to enter quotes, the quotes are extremely complex with many related databases, my users want to be able to generate a new quote based on previous ones if needed since it can take up to 20 minutes to enter some of these quotes (they're for very complex fabricated parts). Thanks.
-
- 1 reply
- 773 views
-
-
Is it possible to duplicate a table so as to avoid haveing to re-enter lost of fields? Kirsty
-
- 1 reply
- 796 views
-
-
In fm 5 I used to be able to go to excel and get external data which would bring across data from fm complete with the field names. However I cant do this with fm 7 is there any way to export data with the field names attached? Kirsty
-
- 0 replies
- 1k views
-
-
Why can't I change the font to webding anymore? After my upgrade to FM7, former fields using the webding font work fine, while new fields won't accept any change to wingding fonts. A warning appears informing that for storing reasons the field can't be set to that font. But this just Layout!!!!! To bypass this protection the user could keep alt-control pressed while changing the font. Would be nice, but it doesn't do so! Any comments? Cheers, Martin
-
- 1 reply
- 1.8k views
-
-
I am haveing some problems with printing. I carry out a find then create a new layout useing the report setting. I can seethe data I want on the screen but when I want to print it, I only get the first line of data. What am I doing wrong?
-
- 2 replies
- 773 views
-
-
I am using an unstored calculation to show how much of a check needs to be posted. The calculation is as follows: Amount - Sum ( CashReciepts::AmountCredit ) where the amount is in the parent file subtracting the sum of the credits in the related file. Works like a charm performed in the same file where the data is kept. On the contrary, through a file reference, sometimes the calc refreshes and sometimes it just doesn't feel like it (Until the calc field is entered) . I have the layout set to save changes automatically. I don't know if it's a bug or what, but it seems there are some small differences how files act through references and when data and interface ar…
-
- 18 replies
- 3.5k views
-
-
I would like to keep a history or log of remarks that are entered into a specific field. Is it possible to allow a specific user to create a remark and then once they have left that field the remark cannot be modified? I need a history for a helpdesk like application. I need to be able to see all the remarks that have been entered as well as the date. Thanks for the help!
-
- 3 replies
- 892 views
-
-
How do I remove the dotted lines that appear around all fields when I enter into a field? Thanks for your help! Sam
-
- 1 reply
- 1.8k views
-
-
Hi everone!!! Im trying to figure-out if there's a way to programmatically check when a field out of 12 field was modified. I would like to know(via global field maybe) as soon as data is changed or added in a field on a layout. so if i have about 12 fields on this layout, i want to know when one of them is modified, and it can be anyone of them, its random. So i need code that could keep an eye on those fields, and the minute one of them is changed, i get a flag. Can it be done. Any ideas, tricks etc are more then welcomed and very appreciated. Thx. Pat.
-
- 1 reply
- 792 views
-
-
Anyone have experience using Filemaker as a COM Object? I've haven't done much windows programming but I am looking at doing some Python/Filemaker interaction via COM. Any good resources to look into?
-
- 0 replies
- 823 views
-
-
is there any way to completely lock out accesss to the status bar?
-
- 3 replies
- 770 views
-
-
I am starting to open my eyes to building preferences for my system... wow are the possibilities cool... I have a field in an accounts table called "group" I want to be able to assign each user to various groups: data entry manager director each with different privileges. Can I have the "group" field be a simple text field, and then if I want to assign someone to more than one group, just enter both group names delimited by a carriage return ?? I guess what I want to know is, can I easily test for Does a field = (or maybe contain) "y" when that field might contain something like this: g p x y z
-
- 4 replies
- 896 views
-
-
I just upgraded to the latest version of FM (7.0.3 i think). Now when I paste text from web pages the text retains the formtting - bold, fonts, colors etc. This is a feature I definately do not want. Anyway to turn this off?
-
- 2 replies
- 867 views
-
-
I have a repeating field.. with 5 repetitions. I want to make a script which, using a script parameter, will operate on each repetition of the repeating field. the script will simple insert a date if the field is empty for that repetition.. How can I do this ?? thanks
-
- 7 replies
- 1.3k views
-
-
Hi, I have both FileMaker Dev 7 and Filemaker 7. I use dev 7 on a Mac, but am trying to use FM7on Windows. On Dev 7 I see it the toolbar there is the filemaker option where I choose filesharing. Where Do I do this on windows using FM7... and PS I am trying to use it on FM Server 7, I am new so please be patient.
-
- 0 replies
- 598 views
-
-
Hi, I've been thinking about this problem for a while and I can't think of a way to solve it on my own!! I want a report grouped by department with a count of the number of students ID's in the department. Currently my records have multiple entries of student IDs. For example: Department of Education: 295321 295321 (same as above!) 456372 Department of Science 342133 342133 (same as above) 675432 Currently my report looks like this: Department Count Department of Education 3 Department of Science 3 I made a summary field on student ID. And this gives me a coun…
-
- 18 replies
- 4.1k views
-
-
I just noticed on a test PC system that my popup layout select will not scroll beyond the screen height, as I develop on Mac, I never noticed this in the past. Is this a known problem or do I have something set wrong the on the PC. I'm using developer 7.0.3 and WinXP on the problem system. Rod
-
- 6 replies
- 861 views
-
-
I have a solution with several tables and each table with several fields, is there an easy way to import the data to the new solution version everytime I update the solution?
-
- 1 reply
- 715 views
-
-
I have a repeating field stacked vertically.. I needed to conserve real estate, so I turned it down to 9 point.. and have tried to make the fields as vertically short as possible.. when I click into the field though, the edit box that shows up is a bit offset. It's only about 2 pixels, but since the field is 9-pt text, it's visually pretty bad looking.. I've attached a screenshot to show you what I'm talking about.. any ideas how to fix or get around this : FYI.. the reason the edit box is pink is because i'm using the technique whereby you set the background to a color, make the fields transparent.. and put them against a white background so that the fi…
-
- 2 replies
- 822 views
-
-
...an IRC Server ? It would be so amazing, if you could Chat live with one another or not ? WIth a simple app like this: http://www.hydrairc.com/ (PC) or http://www.snak.com/ (Mac). Thanks for your suggestions.
-
- 1 reply
- 1.3k views
-
-
Hello I am using filemaker 7 but when I email from my file it always includes my name and address from my regular email account in Mac Mail. program coming with panther. I would like to use my anonymous yahoo email account as my header on outgoing mail. Is this possible and how? Thanks STann
-
- 1 reply
- 814 views
-
-
I've hosting a database on FM Server 7 over a fast network.. The database only has about 1000 records in it. But, it has about 12 tables, most of which have fewer than 30 fields, however, the main table has about 300 fields in it... plenty of which are calculated fields. I have a startup script which detects which user is logging on, and then does a find to find the recrords that person is interested in, sorts the records, and brings them to a spreadsheet layout (built in LIST view, it has a few graphics on the layout... (small graphics on each record for little buttons), and a few container fields that I use for highlighting the record.. the problem is…
-
- 4 replies
- 1k views
-
-
Hey Guys, I was wondering if any anyone can tell me, or if there is a tutorial on how to create an exe from the databases you create in File Maker 7. I have a small program that I found, that was written using File Maker 6. Within its directory you have the exe file itself along with various .dll files. Obvious being a self contained program, although it was written using File Maker 6, you can take that program over to any computer, even if not equiped with either File Developer or File Maker, and run it like any other program. I liked the design of the program, so currently I am working with File Maker Pro 7, to create a similar version of this program, to suit my pati…
-
- 6 replies
- 1.1k views
-
-
Hi. A client is willing to upgrade to Pro 7 but wonders if it will run under Server 5 (or maybe it's 5.5). Since I can't find any mention of this anywhere, I'm guessing it's not a savory option. Anyone know? Thanks! Lurm
-
- 2 replies
- 821 views
-
-
I'd like a script to go to a window name, if that window is open, and if it's not, then open a new window and go to a certain layout ? How is that possible ? Is there something analagous to If IsOpen(Windowname) :
-
- 4 replies
- 1.2k views
-
-
Hi, Can someone help? What is the script statement for doing this please: if window "Invoice" is not present or closed, New Window "Invoice", h, d, ph, pv else goto window "Invoice" end if Thanks - I know it's got something to do with GetCurrentWindow or something but not sure what. Also, how do you copy from a field in one window into another window's field? I understand that you could have two windows open and be on completely different records, that stirs up a little fear of pasting into the wrong record - 'spose I can get around that but, is that correct? If you were to simply create a script that pastes into a field on the other windo…
-
- 7 replies
- 1.2k views
-
-
I have built quite a lot of Custom Web Publishing-solutions with Filemaker 5.5 & 6 and have just recieved version 7. Now I am converting my solutions to version 7, but how can I test if my web-systems work now? What happened to Custom Web Publishing?? The manual only mentions Instant Web Publishing, which still, In my humble opinion, is useless for serious use. And I, of course, need to be able to test my pages before moving them to the server, physically another place in town. How do I connect to my web pages under FMP 7? Am I overlooking something obvious? Pleeease don't tell me they have removed this function from FMP 7! It is my main reason for using Fil…
-
- 1 reply
- 867 views
-
-
I read this in a book. A find only searches in one table. You can set up an advanced find to look into several tables, but it will only return results in one table at a time. I am looking to use one exact copy of an interface layout to search into and pull up all records that have a mathing search term in all files. Example, I use find and search in a same name field for the word Beta, that should be able to pull up from several tables the matching field and all other feilds that were in those tables. The only way I know how to do this would be to combine ALL of my old table files from FM6, but I fear that would be a a mess of one huge file and b not a se…
-
- 8 replies
- 1.2k views
-
-
Pardon my ignorance here, but i just can't seem to grasp the whole mutliple file vs. one file concept. I have a purchased multiple file application in 6, but it's too complex for my needs (advertising agency, job tracking, time and expense billing) so I was hoping to use some of the available solutions from FM and modify them. But that would mean having multiple files instead of one, which I have been led to believe is the real beauty of 7. From an "expert" standpoint, is it still "OK" to have multiple files? Or should I attempt to cut and past the tables from each file into one large file? I can have relationships between different files? But do those files have to be op…
-
- 7 replies
- 1.8k views
-
-
Can I search a date field for blank entries ?
-
- 1 reply
- 754 views
-
-
Hi, I was wondering if anyone might have a copy of Developer 5.5 or 6 for sale? I'm using version 7 but need to deliver a project with Windows 98 support. I've just missed out on a couple eBay auctions. My plan B is to higher another developer to crank out the runtime version for me. TIA, Randy
-
- 2 replies
- 856 views
-
-
Can I force a user to use the dropdown value list on a field ? Note, I still want them to be able to type-to values on the list.. I just don't want them to be able to type something in the field (thus giving them the chance to try to enter something that isn't on the value list)
-
- 7 replies
- 2.6k views
-
-
I can't seem to phathom why, in db preferences, there isn't the option to open with layout or run an opening script! Am I missing something? has it been moved? The reason why this is so dumb is because I have multiple windows and it seems to open with the last window that was at the front when the app was closed. This means I have to go to layout mode, open status area, select the right layout, adjust the window size, etc - all because on load I couldn't get it to simply run a script to take me to a certain window of a certain size. Surely I'm missing something here? thanks for your help
-
- 5 replies
- 1k views
-
-
is there anyway of stopping a startup script from working before loading the database? I must be soooo stoopid - I created a new window in a startup script and noticed that under it there was another window there. So, I modified the script to delete the window FIRST before it creates a new window. Closing the window closes the database - I can't get in!! Help!!! What a perfect example of muippetry! Any ideas?
-
- 3 replies
- 898 views
-
-
I am running FM Pro 7 in Windows XP. I have recently encountered a problem. The ctl+shift+d shortcut no longer brings up the define database window. I can still select it from the menu, but I can't bring it up with the key combination. Has anyone else encountered and fixed this?
-
- 1 reply
- 721 views
-
-
I'm running Filemaker Server 7 on a Mac running 10.3.5, and am also running a few small MySQL databases on that machine. Could someone tell me what my options are for having Filemaker 7 read from, and possibly, write to, the MySQL database ?
-
- 7 replies
- 1.5k views
-
-
Hello again! I want to know what I have to do if I want to autofill a field with content from other tables. Ok here I try to define my problem a littlebit exactlier (sorry for my funny english) Table A fields: userID; userName; userPath Table B fields: userID; orderStatus; item I choose in Table A the 4th record. Now I switch to Table B. If I make a new record in Table B, I want that automatic filled the field userID with the content from the 4th record of Table A field userID. I dont want to add the userID by hand it should happend automaticly. What have I to do for this? thx for any further help.
-
- 2 replies
- 1k views
-
-
Hello guys! I plan to make my own DVD-archive. Please don't discuss like: "... there are good solutions outside ..." I WANT to make my own one . OK now my problem: How should I solve the problem if more than one user is using this application (database)?Yes they can work at the same time on the same Database, but I think that would never happen Following I planned before: One file; 1xUsertable; 1xMovietable; 1xMaintable the movietable contains all DVDs. the maintable contains calculations and some variables. And now the usertable? I don't know if I should make FOR EVERY USER A OWN table, or should I put ALL USERS IN ONE table. Is it possible to …
-
- 4 replies
- 671 views
-
-
Hi there, am a novice so i am sorry if this is a common question...I have a database I made in FM Pro7 that i would like to use as data in Word documents (office mac 2004) the only problem is when I open the data merge manager and open the FM dialogue for data, it will not recognize any of my FM7 files, only my FM5.5....and i have lots new stuff with the new program! What have I done wrong? Thanks for nay thoughts and suggestions dillon [email protected]
-
- 2 replies
- 802 views
-
-
First, a complaint: Why, when i search for "corrupt and must be recovered" on FMI's knowledge base, should i get pages and pages of results that have nothing to do with anything? I know it's been said before, but AAARRRRRRGGGGGHHHHHHH!! Now, my question: I am trying to write up a manual and am looking for the exact wording of the message i will paraphrase here: "[FILENAME] is corrupt and must be recovered. Please select Recover from the File menu." (FMP 6) If anybody has that handy, please post it, for i will soon be forced to open my valuable .fp5 files and then kill the power in the hopes that will corrupt something. TIA, Jerry
-
- 6 replies
- 1k views
-
-
I have installed the version 3 upgrade. Prior to the upgrade to version 3, in Filemaker 7 I had option to, when paste text in browse mode, to keep the text formatted as the layout was designed (ie: would not carry the font and formatting of where I was copying from, into the record, rather it would keep the formatting as you set it in the layout). Now it has reverted back to keeping the formatting of the where I copied from and I can not fnd option to make it keep layout formatting. - Arggg this is a pain in the butt and was one of the reasons I loved Filemaker 7, because you could achieve this without any scripting. I am thinking of reverting back to 7.0 but if any…
-
- 1 reply
- 880 views
-
-
I am a very part time Filemaker user who has not built a new database for years, and need help figuring out how to complete a project. I have a simple mailing address database that I want to use to print a form letter. I am creating postcards from 8 1/2 X 11 sheets that will be cut to give me four cards per sheet. I would like to print the addresses directly on the cards as opposed to labels. Is it possible to set up Filemaker to print the addresses from four different records onto the 8 1/2 X 11 layout? If this is possible, and someone can lead me in the right direction, I think I can figure it out. I am using Filemaker 3.0 on my Mac.
-
- 2 replies
- 1.4k views
-
-
I'm trying to create a grid/matrix-style view for my current FileMaker project and would welcome any thoughts on the subject. Let me explain... I'm developing a system for a school. When a student signs up for classes, he/she has the option of paying over time. The student must be paid up by the time the class starts. So, I have an Invoices table in my file, a Classes table, and a Join table connecting the two. I also have a Payment Schedule table where the broken down payments due are stored. Let's say that John Smith takes Business 101. Business 101 costs $500. John will make five payments of $100. John also takes Public Speaking. Public Speaking cost…
-
- 6 replies
- 5k views
-
-
I am trying to develop a method that will allow me to create an invoice in FM7 which has portal lines for the invoice items and will allow me to delete the whole record including related portal records if desired. However if the record is to be kept, it will assign the next correct invoice number to both the main record and the portal records to maintain the link. I have most of this working based on the main record being created with the ID field being the unique record number. When portal records are created they use this ID. On saving, the system increments a number from a single file table, grabs this number and sets the portal records to it and finally the main …
-
- 12 replies
- 3.6k views
-
-
Hi I am currently working at a museum where they have a database with a layout and in the layout in a thumbnail of a picture. The picture is referenced to the file. But as I have been working on the database adding new information the file will not break the 14 meg barrier. Each layout is supposed to have info about the artifact along with a picture. Whats happening is I will import the file into the database and when close and reopen the file some of the pictures say that filemaker "could not draw picture file." As I add more and more information, more and more files do not come back for viewing. Any one know how to fix this or do I need to seperate this large file…
-
- 2 replies
- 2.5k views
-
-
I can't figure out how to show one small window (eg pop-up help screen) over the top of a larger window. Using Go to Layout and Select Window commands, I keep ending up with just seeing one window. Is it possible to see more than one window from the same file at the same time? Thanks Philip
-
- 5 replies
- 2k views
-
-
Hi, Has anyone noticed a few weird glitches on layouts? Like, 1. a portal list that is white on a white background with 0 point sized lines displays periodic thin grey lines every two or three portal rows. When you change the colour to a dark colour it is kind of alright but still hard to disguise what look like lines. 2. When you select a portal line and then not select it leaves a line across the bottom of what you pressed without refreshing. 3. When you have modifiable fields (Behaviour set to input and view on find and browse modes) - click and hold on the screen somewhere it highlights all the bounding box edges to fields that you can en…
-
- 0 replies
- 828 views
-
-
1. Is there a way to transfer a callendar with schedules and to do items created in Filemaker into iCal? 2. Is there a way to transfer a spreadsheet created in Filemaker to Excel?
-
- 4 replies
- 1.4k views
-
-
Am trying to install a 10 seat Filemaker 7 volume license on a Windows 2003 server, for use by Windows 2000 clients. The server is running FMP server 5.5 for normal use & the FMP7 is for testing, as we migrate our solutions to FMP7. The program runs fine, sitting at the server, but when I share the folder, even with FULL admin rights, I get "This application has been installed incorrectly or modified by another program. Please run the Installer to get a fresh copy of the application after determing the cause." I uninstalled, tried installing to the default C:Program Files directory, tried the v3 update, rebooted the server, stopped FMP server 5.5 services,…
-
- 3 replies
- 3.2k views
-
-
I'm not sure quite where this question belongs, but I'm putting it here because most fundamentally, this is a question about v. 7's behavior... When I open a new window in a multi-table solution and go to a layout that is based on a different table that is related to the record on display in the first window, what happens? Does the new window display only the records related to the record on display in window 1, or does it show a different data set? I have a multi-table solution. In this solution, I navigate (using scripts) from one table to others, opening new windows as I go deeper into the system. So, a user opens a layout displaying a Customer record, which …
-
- 2 replies
- 849 views
-
-
I have a relationship that shows the other users who are logged on in a portal.. I'd like to arrange the output so that the users aren't listed in a portal, but are listed similarly to how they're listed on this web site... Other users logged on: Tom Smith, Joyce R., Bob C., Frank A. Can I somehow concatenate the records that would otherwise just show up as rows in the portal ?
-
- 3 replies
- 1.6k views
-
-
Is it easier to have multiple tables with many different fields rather than having one table with all the fields in it. Making it look like its another table. I'm soo disgusted with the complexity of multiple relationships within FileMaker. I think FileMaker should automatically create a relationship between tables when you create a field that equals a field in the other table. I find having to draw graphs is redundant. And then what sucks even more is I can't have more than one relationship between the two tables without totally screwing up my previous relationship. I'm starting to wonder why I even chose to use this pathetic program.
-
- 7 replies
- 1.2k views
-
-
Hi! How can I make a calculation BETWEEN two Nummber-Fields ? e.g: If( "Between Field1 and Filed2"; OK; Warning) But you may have noticed the Between value is not valid. Please Help!!
-
- 1 reply
- 874 views
-
-
I'm not using server. Is it possible for me to open FMP DBs remotely if they're in a previous version? Before I put FMP 7 on Panther, I was able to open FMP 5.5 DBs on OS 9 remotely from FMP 6 on Jaguar. Now it's beginning to look like I have to upgrade everyone (only three more stations, actually-) to move on. Thanks for reading this.
-
- 1 reply
- 944 views
-
-
Hi, I am trying to create a report and I am having some trouble. I have Evaluation forms for different courses turned in by many students having fields - "Most Beneficial", "Least Beneficial" etc. I want to create a report grouped by the Course ID, containing all the fields in the Evaluation form. I've managed to get this far. So my report looks like: course ID 1 Most Beneficial : All Least Beneficial: handouts Most Beneficial: None Least Beneficial : Teaching Course Id 2: Most Beneficial : All Least Beneficial: None Most Beneficial: …
-
- 0 replies
- 721 views
-
-
Is there a script step or plugin that will allow you to send a message to another user that is logged onto the database ?
-
- 1 reply
- 3.3k views
-
-
The "Evaluate" Function; Evaluate ( expression {; [field1 ; field2 ;...]} ); is suppose to allow more than one field "trigger" for the evaluate function, but when you try to put more than "field1", eg. "; field2", it gives you a "Too many parameters" error. Any one else running into this?
-
- 2 replies
- 1.2k views
-
-
someone can yell at me if they'd like for this question. how do i switch users without exiting out of FM?
-
- 1 reply
- 906 views
-
-
I am trying to automate a message which will pop up if you enter a social security number in a text field. The text field is more or less an area for comments and may contain anything from one or two words to a hundred or more. I want to make the automation where it will not allow the user to move on until the social security number is removed. I tried using a pattern count like this........ PatternCount (CustomerInfo::Textfield ; /*###-##-####*/ (1 )) but that only works when a ss number has all 1's. I tried using the @ and # symbols but FM doesn't recognize the symbol as a "wild card". HEEELP!
-
- 26 replies
- 2.5k views
-
-
Sorry, If this has been posted a hundred times, My brains hurting as I've been having loads of fun with FileMaker 7, understanding the new fundamentals. Im trying to rebuild an existing application that I've built with v6 as I think this is the best approach for me - converting was a real nightware. Anyway, I have created a text field called Type, and the user enters data into it via a value list popup. the valuelist contains for e.g. cat,dog,mouse etc, Is there a way I can enter Cat, but the value that is stored in my Type field is "C" (i.e. the first letter of the value for my selection. ) Thanking all in advance. Jalz
-
- 2 replies
- 763 views
-
-
I am currently working with Filemaker 5.0 on a macintosh OS 9 system. When I try to open the database file I get a message that says
-
- 7 replies
- 1.3k views
-
-
Hey folks Can I combine existing seperate database files into one master database? I have to get together an asset management system and I wanted to be able to give the Users, Hardware Assets, and Software Assets unique databases. I tried making a master list that contained all the fields I wanted for the three databases and then created three layouts accordingly. The problem was that I would create a record for a piece of hardware in the Hardware layout and then create a record for a user in the User layout but the two layouts don't share the same fields and when I went to enter a new user record I would mistakenly be adding the information to what seemed to be…
-
- 11 replies
- 1.6k views
-
-
How can i re-enter an installation code and user name in filemaker 5.5 (without new installation offcourse) On a Mac ? On a Windows ? Thanks Jitse
-
- 0 replies
- 1.7k views
-
-
Is there a way to change FM installation number without reinstalling FM... Which file need to be delete FM Windows version... tks
-
- 1 reply
- 698 views
-
-
Hi Guys! Got a small problem, as follows: Ok I've got Dropdown menu showing a few values out of a value list which is taking its info from a Table. Now the first record has an ID
-
- 3 replies
- 732 views
-
-
How do I take the value from a summary in table 1, and show it in table 2? Portals don't work, creating a field that links to the summary doesn't work.
-
- 5 replies
- 1.1k views
-
-
I'm very concerned about how FileMaker 7.0v3 handles a go to related record command when there are no records in the child table which satisfy the conditions of the relation. (This is related to the changes which FileMaker made in how a constrain find works if there are no records found.) If I do a go to RR in a script, and there ARE records which satisfy the relation, the target layout becomes active, and the found set of related records are shown (I thought this was only supposed to happen with a specific show window command, so color me confused.) If I do a go to RR in a script, and there ARE NO records which satisfy the relation, NOTHING HAPPENS. Instead of …
-
- 5 replies
- 767 views
-
-
Hello, I'm new here and fairly new to Filemaker. I'm stumped right now on what I assumed to be a very basic function (and I'm sure it is and I just don't know what I'm doing)! ;-) I have a database for a conference registration form. Outside of all the normal contact info, payment info, meals requested etc... there was a section where folks could sign up for workshops. There are 8 total workshop 'slots' over 3 days (workshop sessions A-F) and for each session time there are 8 possible workshops someone could attend. For each of these we've asked for their first, second and third choices (in case the room capacities get filled) which we will fill on a registrati…
-
- 4 replies
- 1.1k views
-
-
Here's my problem of the week: I have a text field that the user typically pastes a block of text into, and I would like to reset the font/size of the text so that it shows up properly on different layouts. But Filemaker 7 now retains formatting information with the pasted text, so even though it should be displayed in Verdana 14 pt on one layout and Verdana 11 pt on a different layout, it now displays in the pasted font/size on both layouts. In Filemaker 6, this could be cured in a script using Set Field (field, field), but this trick no longer works. I can use an auto-enter calculation to reset the font/size, but this doesn't "get rid" of the formatting, and…
-
- 3 replies
- 1.7k views
-
-
I have created an application which contains a portal on a particular screen. The portal contains a large number of records and it would be helpful to be able to search the portal to find a particular record, make some changes and then return to the original portal showing all of the data. Any suggestions as to how this could be done. Thanks in advance for any help.
-
- 3 replies
- 873 views
-
-
I am making a cross platform Medical Scheduler. I did a cumborsome calendar in the older FM5 version of my DB. I am recoding the whole think in FM7. I was looking for a technique or a plug in that allows me to create a fast, easy, calendar that will work in Mac OS X and in Windows XP/2000. The calendar should be easy to include, have dates that I can click to jump to that date and the ability to color code days that I flag as OR Day, On Call day, Office Day etc... Thanks in advance for your advice...
-
- 1 reply
- 745 views
-
-
My goal was to redo my solution with multi tables in one file. I created new tables in 7 with fields indentical to 6. converted each 6 file into a 7 one at a time then imported the records from the individual 7 tables into my multi table solution All of the tables imported except one table. The progress bar showed records were being imported. The dialog box says 32802 records imported, but when I go to the layout no records are there. I did this 3 times, once I created a new layout Same results. I did make sure the found set included all records. I am using 7.03
-
- 3 replies
- 717 views
-
-
Cat -- I can assure you that setting a field to "" WILL uncheck the checkbox. It will be an empty field. You may be seeing (or not seeing) the portal not being refreshed. Try this: clear the field, then change into Preview mode, then back into browse mode to force the screen and portal to refresh completely. Make sure you are upgraded to FMP 7.0v3 as it has an option in the Refresh Window step to refresh relationships. -------------------- Vaughan Bromfield Sydney, Australia I am not looking at a portal, just straight records. And you're solution does not work. This is very frustrating to me coz it seems like such a simple thing. Is there …
-
- 1 reply
- 1k views
-
-
Hi We have an extensive school based system with hundreds of scripts etc, however there seems to be one thing I cant do ( I wish it was only 1 ), - I want to use a button that when pressed will insert a number into a field - simple, but I want the count to increase by 1 each time the button is pressed. It must be easy but can someone help please Jim
-
- 3 replies
- 719 views
-
-
Could someone tell me whether I can create an .ics file directly from Filemaker on a mac (I searched the the XSLT library and didn't see anything) ? OR ---- does someone know of an app out there that will allow me to create an .ics file directly from ical or using some other app (on a mac) ? (other than Outlook or Entourage hopefully!!!)
-
- 1 reply
- 2.1k views
-
-
I am looking to create a script to enable the modification of any of 12 fields labeled category 1.....through category 12 on the same layout. Instead of creating 12 scripts I'm thinking that I should be able to use one script with a parameter that would define the specific field but can't figure it out. Is this possible?
-
- 4 replies
- 2k views
-
-
Right now my application allows the user to perform a search on one window then show the results onto a new window. The problem that I am having is that when they keep the results window open and go back to the window where they perform the search and conduct a different search I can't get the new results to show in the existing results windo. The existing open results window always retains its current found set. Does anyone know how I might refresh the existing results window with the new found set. Thanks.
-
- 3 replies
- 811 views
-
-
Hi, I want to create a patient report and have no idea how to do it. I've attached the file. There are 4 tables. Patient Chart, Encounters, Scans, and Medications. The ideal report would print the chart first, which is just one page of demographics. Then it would print the related encounters, but here's the tricky part. Each encounter may have a scan attached to it. They're related. This is nice because it's easier to just snap a picture of the injury then spend all night describing it. Anyways, the ideal report would print each encounter with all the related scans. Finally, it would spit out the related medications that I've given. I've broken the databas…
-
- 0 replies
- 1.2k views
-
-
Is it possible to create a field in a Timecode format and calculate it? I want a user to enter in timecode in and out in this format ( 00:00:00:00 ) It has to calculate (hours:minutes:seconds:frames) and output the total to give the user the duration of the clip. I haven't been able to figure it out a formula or anything else to get this to calculate properly... Also, how would I create an Imput mask for this? Sorry, I am really new at this part of Filemaker.
-
- 3 replies
- 1.3k views
-
-
Is is possible to create a scrolling area that would contain all of my fields? I have a simple db with about 35 fields that I would like to put in a smaller scrolling area so my record is not so long. Thanks!
-
- 2 replies
- 811 views
-
-
Well here comes one that will test even JT and Fenton, The file is attached, and Admin, password = Admin will get you in. This file for some reason is not modifiable, at least that is what it says. I am logged in as Admin and yet it tells me to stick it. I can't even change my password. What's up with that? Is Filemaker trying to see if I will throw my computer? Alrighty then, here goes: The current database is set up for a hairstylist to be able to invoice and keep track of things. I have an items table, some products(taxable) and some services(non-taxable). I also have an inventory table, this was for the hairstylists own stuff, not stuff she would sell. (…
-
- 10 replies
- 1.3k views
-
-
hi- I have an urgent need for some calculation help. I have a book title field in my records. I need to create a calulation field that removes all the spaces and puncuation in the titles and combines all the words. For instance, I have a title of: U.S. Communication services market : overview and future outlook. NEED CONVERTED TO: USCommunicationservicesmarketoverviewandfutureoutlook Is this possible? I need it to function the same no matter what the title or punctuation.
-
- 3 replies
- 838 views
-
-
A trailing grand summary part will only appear in preview mode or when printed. Try using a Footer part instead. -bd
-
- 1 reply
- 1.8k views
-
-
Can someone recommend a filemaker web host. thanks!
-
- 1 reply
- 748 views
-
-
I have created an application in Filemaker. It uses one file and has several tables. In one place the user clicks a button which should open a small Window for new product information to be entered. When the window opens at the small size, the original layout in the background disappears completely and then when the small window is closed the original large layout appers in the small window. Any suggestions as to what I am doing wrong. To help another funny thing appears to happen when I first open the application. A small window appers very quickly and then goes and is replaced by the opening layout. The little one cannot be accesses or seen in any way and I h…
-
- 2 replies
- 925 views
-
-
I have a FM7 server served solution that uses quite a few drop down lists that are derived from relationships.. but there's a problem....when connecting over our network, it takes a few seconds for the pop-up list to populate once clicked into.. Is there some way I can prepopulate the value list so that the user doesn't have to wait a few seconds after clicking into the field ? ANY advice would be greatly appreciated, because I'm finding my users click in, and then start typing something before it populates, and then end up with a bit of typed text that doesn't type-toward anything. A pop-up menu isn't really an option because you can't type-to your selec…
-
- 6 replies
- 992 views
-
-
OK, so maybe I'm asking too much of Filemaker here but is it possible to have two text fields auto-fill a third field? I've got a database for the user community that I support and there user-name/authenticator is always going to be their first initial and their last name (i.e, David Jones - "djones".) Ao I have a last-name field, a first-name field, and a user-name field - is it possible to create a script or calculation to autofill the user-name field with just the first letter from the first name-field and the contents of the last-name field to auto-fill the user-name field? Thanks for any help...
-
- 2 replies
- 862 views
-
-
I currently have a field which appears like a radio button yes/no format and have been useing a script which when the field is yes then it goes to a new layout or if no it fills in the no and lets you go on to the next field. I want to be able to adapt this so if the field is yes it goes to one layout and if no it goes to another. However the way i have it set up the field is blank to start with and when you first click on it , it will go to no then you click a second time it goes to yes...the problem is that when it first goes to no it follows the script and takes you to te no layout, so you have to then go back amnd click a second time...not very neat. the script…
-
- 1 reply
- 955 views
-
-
In the attached file there is an example of what i trying to achieve. I am sure it has a simple answer too. But to date cannot solve it. I have a series of fields (non-rep) that display a running total. Each field has an adjacent field that i want to display a break down of each seperate length of the total length. Each adjacent field i have set it to a simple calc to subtract the previous field result from the current field result, thus giving a break up of that separate length. The problem arises when i don't need all the fields and some of the remaining fields are left empty, the adjacent field will display the running total as a MINUS (eg -135) I h…
-
- 4 replies
- 1.3k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online