Calculation Engine (Define Fields)

I am trying to put a summary field at the end of a report, but the field is from another database so I can't use the summary calculation. I tried using a regular calculation (sum (Clerking:price)), but that just gave me the last number in the report. How can I get a summary price for the report?

Hi. This is my first post. Im learning FM and am new to using it as a relational DB, although I have used it casually for years as a flat file DB. Im trying to build a DB for my research and teaching in industrial design. It will have several files to store text and author information, images and video files. One file in the DB is called

Hi all, I own a video company and am working to improve my bid generation processes. Each bid is unique and I need to quickly and easily create a cost estimate document that is also unique. I have a master list of hundreds of billable items that could relate to any video project. I don't want to give my client a list of hundreds of items (some of the checked) that have nothing to do with their project, I only want to provide them with a bid that has their job specific line items. The question is, is there any way that I can put a checkmark next to various line items that will allow a dynamic report of ONLY the items that I have checked? I hope I am cl…

Hi there and thank you for showing interest... I'm not at the level of creating good calculations, please help me out. A Text Field contains: [color:"green"] Check This Little Van Thingy Out Please I wish to have a calculation that takes all the words and then puts a '|P' at every space. Creating: [color:"green"] Check This Little Van Thingy Out Please Now I need a script for a button that puts each line into a different field. also When a sertain word like '[color:"green"]Van' occurs, it needs to be put in a specified field. When this happends: All the other words after it need to go into just 1 field with spaces in between: [co…

I hope someone can help me with this! I need a numerical sort order field calculation, based on the sort order of three other fields. I am getting into trouble when I concatenate the three fields, due to Filemaker's nasty habit of dropping preceeding zeros (that I am using as place holders). Here are the individual fields and some sample data Reel = 0001 (can be up to 4 digits long) Scene = 0001 (can be up to 4 digits long) Shot = 0010 (can be up to 4 digits long) I have created a text calc field that creates a result: 0001 - 0001 - 0010 This one sorts correctly, but there is a looping script that looks at this field and tries to add +1 to it, i…

This has just gotta be a no-brainer, but maybe that's my problem . Anyway, I'm trying to get the maximum grade for each enrolled student and from there I have a calculation which will return the graduation year. My uncooperative calculation is: Case (Max (grade) = "4", graduationYear4thGrade, (Max (grade) = "5", graduationYear5thGrade, (Max (grade) = "6", graduationYear6thGrade, (Max (grade) = "7", graduationYear7thGrade, (Max (grade) = "8", graduationYear8thGrade, (Max (grade) = "9", graduationYear9thGrade, (Max (grade) = "10", graduationYear10thGrade, (Max (grade) = "11", graduationYear11thGrade, graduationYear12thGrade)))))))) Bu…

I have taken all the students in the colleges picture and stored them on Filemaker. I want to export all the pictures into JPG files with a field name as the file name. Filemaker will not allow me to export container fields. Is there anyway to export the pictures into another file or in to a jpg file. All help is greatly appreciated. Thanks

I'm using FM Pro 6 for my accounts. For budgeting I've set up Summary fields that are supposed to give me an average 'spend' in each category (eg: car, stationery etc). However these summary fields only appear to be accurate when I do a find on a single category -then the summary field for that category is accurate (and of course all the other summary fields return a zero value). Any ideas what I'm doing wrong?

Hi, So I thought I was being really clever. I have a script that needs to wait until a portal row is selected, I tried to create a global calculation which was: if(status(currentportalrow)>=1,0,99) The intention was while no portal row was selected it would return 99, as soon as a portal row was selected it would return 0. Then in the script I had a pause for the duration of this calculation field. Anyway it doesn't work, so I am not even a little clever ! I have posted this here because the basic question is how do you get a G calc field to get the status a portal row. But I'm sure there is a much better way to do this. Anyone go any bright ide…

Hi folks I have tackled my project, and thought I'd cracked it! hmmmm I have made some buttons (6) that take you to a layout, call "item 1 entry" through to "item 6 entry". I've made these as the users need to see what they are entering in a certain way! Once they have entered their data, they click the print button that links to "print item 1 entry label" layout. everything is fine until, maybe hours, days later someone needs to print a label that has already been input. If the user is on "item 4 entry", and clicks print, they get the data from the original layout ie "item 1 entry" but in the "print item 4 entry label" layout.... ...arrhh…

I'm pretty much an FM newbie. I've only been working with it for a few months now, but I've been having pretty good success, until now... For clarity, I'll try to strip this down to only the essential info: I'm working on a sort of time clock system (that's already a big simplification, but it's a very good one). I have one file, "File A", which holds all the employees. I have another file, "File B", which holds the time worked by the employees as durations (each record in the file is a duration worked). Each duration in "File B" is associated with one of the employees in "File A" and has a start and stop date and time (thus defining the duration). We …

is there a way to change a field's color based on how many records there are in a related db? i have a jobs db and a client db. i would like to have maybe 5 different colors which allow me to gauge the customer's number of jobs in the jobs db. ie. customer one has 5 jobs, i would like for their name to be in blue. customer 2 has 10 jobs, i'd like for their name to be green. etc. any ideas? thanks. josh

I know I have done this in the past but seem to have forgotten how. I have a small database with 1000 pictures, many of them are repeated and I want to mark those to keep and those to trash with a check box, archive and keep, How do I do this?

i am having a problem with the calcualation in a portal. the initial treatment plan has the hours required and remaining. the weekly progress report is where the hours should be subtracted from required. i just cant seem to figure this out. the file is attached if someone would like to tell me where i went wrong. the relational databse is in the second post. DRC_Test_Database.zip

I'm having trouble with validating a field by a calculation. Here's the goal. I want a field to be "Not Empty" if another field is not empty and a certain condition exists based on a flag field. Here's my calculation: If(not IsEmpty(Mark) and Status="p",1,0) Mark and Status are text fields. I want another field, Com, to be Not Empty if this validation is true. I can't seem to get this to work. Am I doing something wrong?

I'm importing data from a text file and parsing it (using the "middle" function). One of the data elements is a date (needed for subsequent calculations), but FM seems to read it as a number and converts that number to a date, which is not the date originally imported. How can I resolve this? I searched previous threads, but couldn't find anything similar. Thanks Dave

I have a small problem to get container field to work in Max Os X. I have attached a db that shows what I loadpic.zip

Hi, long time no ask, I have an interesting question , what would be the best way to get the filed names from one database and paste them into "Field Name" field in DataDictionary database? Let me explain, I'm creating DataDictionary database for explanation of the field names (trust me it's needed ). Rather than copying/pasting I'd like to import the values of field names into the field called ""Field Name" in this new database. I was thinking of using FieldNames function from AllFields layout, and then getting those values one by one into a repeating field, then using GetRepetition function to get those values. But the problem is that all the field names…

Here is the scenario... I have a layout with 40 fields named (Pagkage_1, Package_2, Package_3, Package_4, ect ect...) We will be entering letters into each of the fields... Some fields will have "A", some will have "AB", some will have "ABC". or any combination of them those letters ... or multiple of the same letters in the field... A = $16.00, B = $14.00, C = $11.00. I need a report that will tell me the amount of package A's ordered, B's ordered, and C's ordered. As well as the total amount of money that I should be collecting from the sum of each of the package letters. Please help me to find a solution to this nightmare ... I can do it, but I will have to create abou…

Pretty new to FM, and this is my first time to use a lookup field. What am I doing wrong? I have a global field (number) called gCurrentFee. When a new record is created I want to lookup gCurrentFee is and place that value in a number field called CurrentFeeLookup. So I create CurrentFeeLookup (number) and select Options -> Auto-Enter -> Looked up value -> Specify. I choose the relationship, a self-join where RecordID = RecordID, and select ::gCurrentFee. What I think should happen is that CurrentFeeLookup should be set to gCurrentFee, and then retain that value after gCurrentFee changes. But what actually happens is that CurrentFeeLookup is empt…

How does one take names from individual records in a contact list and display them in one continuous sentence, a line-by-line stream with commas separating the names? BTW, I know how to join first and last names, etc. Thanks in advance. L.

I am disappointed that FileMaker did not create a preference that allows the "Store as Reference" in the insert picture to be automatically checked. I import a lot of photos and it is repetitive to always have to check this box. Does anyone know of a work around or a script that will eliminate having to always check the "Store as Reference" box?

I am using the Patterncount feature to find the work "signed" in a description field. Here is my calculation: PatternCount(FoundDescription, "signed"). This works fine, except that it is only finally exactly the word "signed" - not SIGNED or Signed. Can I adjust for this easily. I need to find the word Signed in any format within my FoundDescription field. thanks -

I'm using the age calculation: NumToText(Year(Today) - Year(DOB) - If(Today<Date(Month(DOB),Day(DOB),Year(Today)), 1, 0))&"Years,"&NumToText(Mod(Month(Today) - Month(DOB) + 12 - If(Day(Today) < Day(DOB), 1, 0), 12))&"Month,"&NumToText(Day(Today) - Day(DOB) + If(Day(Today) >=Day(DOB), 0,If(Day(Today- Day(Today)) < Day(DOB),Day(DOB),Day(Today- Day(Today)))))&"Days" I copied it from a post I found searching here on the boards. First of all, I'm getting the wrong result. From the birthdate '4/15/1973' I'm getting '2003years,2months,27days'. Not only that, but it's not different for every record, it uses the same result for every re…

Hi, I'm working with mortgages, trying to calculate the MaturityDate based on the SaleDate and the number of months of payments, SaleTerm. For example, if a 240-month (20 year) mortgage closed on 1/15/2000, the first payment would be due on 2/1/2000 (and the first of each month thereafter), and the last payment should be on 1/1/2020. To calculate this I'm using Date(Month(SaleDate) + (((SaleTerm / 12) - Truncate( SaleTerm/12,0))*12), 1, Year(SaleDate) + Truncate( SaleTerm / 12,0)) There is some glitch in the month part of the date function. I think there must be some rounding-error issue. What it should do is find out how many years there are …

How would I calculate a field so that it enters another field value if it is empty? I know this is simple, but I have never done this. Is it under auto enter or validation?

I can picture what I want in my head and on paper, but I can't get my mind around it using the FMP functions - thanks in advance for the help. I am working on a accounts statements page. I have summary fields that add up my Over 90, Over 60, Over 30, and current due. My situation is - if there is a credit balance in the Over 90 column, I first want it to apply to the Over 60, and if 0, then Over 30, and if O then Current. And the same is true for the Over 60 with credits, Over 30. And the same is true for the other direction. If there is a credit in the current, Over 30, Over 60, and a balance in the Over 90 - I want it applied to the Over 90 first. Basical…

Not a question, just wondering if anyone's familiar with this. . . While working on a new layout, I changed the label of a field (not the fieldname itself) by preceding it with two colons " : " (to remind myself that it was a related field). In Layout mode, no change was apparent. But when I switched back to Browse mode, the label itself had become a dynamic timer. It clicks off hours,minutes,seconds every time you switch records !! hmmmm. . . .

What Im trying to do is, field A ( choose service ) and when a choice is made, auto enter a value into field B from field C. Field A is a list of hundreds of services, field C is the person whom is to get credit ,but multiple people can get credit on this form. Field B is who gets the credit for the charge. This way the person adding services only has to make a change once in field C instead of having to do it for every charge on Field B. Have I been able to confuse u?? I am pretty sure that i could write a script to do the checking and pasting, but i want it on the fly. Thanks for any and all help

Hi All I'm relatively new to filemaker, and now I have to pull it out of the bag. I want to have either a pull down menu or radio buttons, with 5 entries. I have designed a layout, and upon choosing/selecting 1 of the 5 choices I would like to link that to a client logo, so the logo will automatically be shown on my layout... why can't I seem to get this to work? apart from a complete lack of common sense! All help greatly recieved. Az

Does anyone know of a way to change a field to not allow changes to it once a certain criteria has been met. For example, if an invoice has been billed the "billed" field is changed to yes and no changes can be made to any fields within that invoice# but if it hasn't been billed then the fields are modifyable. Thanks once again!

I'm attempting this post for the second time...if this is a repeat, please forgive me. I'm new to the forum. I am building a tracking system for a clinical genetic research project at a university. I need to add the university's logo to some of the forms. I've got a copy of the logo as an Illustrator eps. I've tried placing it on layouts as an eps, and have converted it into jpgs, tiffs, gifs, psds, etc. Nothing works. Jpegs look the best but fuzzy. EPS, gifs and tiffs look pixilated. I'm sure that there is a solution to this problem. I'm pretty sure that it's my problem. I'm probablly missing something. Any hints are welcome. Dave

As far as I can tell, Filemaker adapts any renaming of fields so that you do not have to change any layouts or scripts. Is this true? Should I worry about renaming a bunch of fields in my database?

Hello, I have a perplexing problem, and I need a quick answer. I've developed a small database for tracking workflow in my office. It tracks the start date and time for a task and then the end date and time. Such as START 2/25/03, 12:30 P.M. ... END 2/25/03, 4:30 P.M. I need to create a field that can calculate the last END DATE. The problem is this. There can be multiple END dates, depending on how long the task takes. It could START and END several times. I only need the last END date or completed date, which could be anyone of multiple field entries as it's a repeating field. So, if works like this: So, say a task was started on 2/25 at 12:30. Then…

Dear All, I have 2 fields, f1 and f2 , and a calculated field c . c = f1 & f2 . since I don't want people to duplicate (f1 & f2) so I make calculated field c. But Calculated field does not have option for unique. How can I make it unique so people can not duplicate (f1 & f2) = c.

Hi all, I have some big doubts about my Unique records and key # settings method. Could you point out some weaknesses before I start with this and get fatal errors in the future. Creation of records and duplication is only scripted. I have in every files in my database, 1. a auto-entered text Unique_ID (Capt Kurt) for every records 2. n_serial num (prohibit modification checked) 3. Mod Time 5. Creation Date 6. clookup = (Mod Time*0) + serial num 7. several other serial numbers (prohibit modification unchecked) and nextserial# (for grouping records - where serial numbers are set to lookup through selfjoins to its respective next serial number-…

My contacts database currently has two addresses for each contact. I plan to create several additional addresses as well for contacts that have multiple workplaces or residences. This is what I would like to do with either calculation fields or scripting or whatever works: Each address would have a checkbox/button above it that says "Make default address". If the checkbox was selected, that address would be used as the 'default' for packages/shipping or running scripts on. I envisions an additional group of address fields that are set and then pulled for shipping, etc. Any ideas?

We would like to incorporate a document management system into our current filemaker databases. Is it possible to have a field within a given record where you could upload a file (probably word documents) and also be able to view files already uploaded? And if so, where could I find information on setting something like this up? Thanks Jer

Hi, I am a new user of the Filemaker. Now I am doing a project on the patients' database. The problem is there is a question for the patient: Do you smoke? if "yes", then "how many each day?"; else do nothing. Can I use conditional value list to solve this problem? Thank you very much for your time. Jayson

Hi people. I need some advice on solving this problem. I have two fields in my contact database called "Company Name" and "Client Name". What I need is a sure fire way of checking that when a user enters a piece of data into a record, that the user is not entering contact details that are already in the database. Basically, I need something to check that if the user has entered a company name and a client name combo that has already been entered into the database before, and if it has, spring up some kind of alert. Hope this makes sense, and someone can come back with an answer that will solve all my problemos! Thanxs people, Steve Griff

Is there any way to avoid the insertion of carriage returns into fields ? I need some fields to be one line only. thank you

I've always noticed that FileMaker can't export graphics in containers as accurately (color wise) as the graphic was put into the container. It can display them on-screen correctly but when it comes to printing a graphic or referencing it on a web page with CDML, it gets greyed. FileMaker cannot maintain true white. I believe that FileMaker exports all graphics as JPG and I know that JPG is a compressed format and a little quality is going to be lost for the sake of a smaller file. But, FileMaker (v4.1) should be able to maintain the color of an image. Anyone have any experience or ideas about this? How can I get FileMaker to give me back a clean image?

OK... so I've entered the twilight zone. Here's my field: "1" = "2" Here's my result: 1 What?:? No it doesn't! "1" does NOT equal "2"!!! For some reason, my computer has gone bonzers, and it is matching strings by length, not by contents. I can't figure out why, and it is driving me bonkers. What coudl possibly be causing this problem???

Today's issue of FileMaker Now includes the following tip (referring to Tech Info article #106308

Hi everyone! Well, I'll admit it. Sometimes I struggle to write a calculation simply because I

Well, now, this one woke me from a sound sleep! I had spent the evening reviewing my understanding of global fields and multi-keys and it really hit me, thanks to CobaltSky and Vaughan! CobaltSky -- But that doesn't stop you from transferring a value from a record to a global field (where it will then be 'seen' from all other records) ... the records may not be related but you can use this technique to script a 'transaction' between them anyway. Vaughan -- It gets even better when you realise that the multiple keys can be put into a global field. And these two together can be used to create one- or many-to-many relationships, up-to-date value lists and loo…

One of our clients has a contacts database in FM. Earlier today they reported an error so I started to do some testing on the db. I created a calculation field Test = company &"_"& first_name "&_"& last_name &"_"& phone. In none of the records the first name and last name are displayed [color:"blue"] in this test field (e.g.: ACME___555-123456 instead of ACME_John_Doe_555-123456) . The company name, the underscore signs and the phone number are displayed correctly. In addition, the field "last[color:"blue"]_name" is always empty when using a browser (web companion). Anyone had the same problem before? Thx. Guy

Once again I need your help with a simple thingy. It's 8:50 p.m. and I still haven't solved this simple calculation. I know some of you have this done in 2 minutes so could you plz help me out, while I finally roll into bed. I would like to have a calculationfield that presents the numbers 375 from the field Street, which contains: John S. Christianstreet 375-22 Easy huh, It would be nice it that calculation also would work when the field Street contains: Dr Docmanstreet 19 - 3 or 19 -3 Many thanks, Rakesh

Once again I'm stuck and hope somebody that has the knowledge has time to help me out. I'm working on a way to have the layout names appear in a PopUp menu so that the user can go to that layout. All fine... but I want the user to create layouts him/her self. This creates the problem that I want the new created layout appear in that PopUp menu as well. My guess is that it can't be done automatically because FM does not allow to do a Value List on the calculated field that contains the Layout names. So how do I get somebody to add the exact same layoutname to the normal text field that is connected to the Value list of the PopUp menu? Or are there other s…

Hi- I have a file (DRUG) that is self-related so that one of the drugs can be the "master drug." I would like to display for each record a text field like: drug name of the master drug (related drug name A, related drug name B, related drug, etc) I can make this work with a script, but can I do it using a calculation? The best I have been able to come up with is: drug name of master (related drug name A) Is it possible to iterate through related records in a calc? Thanks- Courtney

Howdy! I am having trouble doing this: If Animal field is "cat", "dog" or "rat", subcategory cannot be blank. (i.e. if Animal = "giraffe", subcategory must be blank) I am trying things like this to no avail: (Animal = "cat" and Subcategory <> "") or (Animal = "dog" and Subcategory <> "") or (Animal = "rat" and Subcategory <> "") or Subcategory = "" Any ideas would be appreciated! Thanks, Kay

I am getting the following error when trying to do a calculation in a field. Can anybody explain what this means? FILEMAKER PRO caused an invalid page fault in module FMFC10.DLL at 017f:006ed28e. Registers: EAX=00000070 CS=017f EIP=006ed28e EFLGS=00010202 EBX=5f401901 SS=0187 ESP=009ab9c8 EBP=009aba3c ECX=00fee9f4 DS=0187 ESI=00fec2f0 FS=67f7 EDX=00fec2f0 ES=0187 EDI=bff555a7 GS=0000 Bytes at CS:EIP: 3b 50 04 74 09 8b 00 85 c0 75 f5 c2 04 00 50 ff Stack dump: 006fccfe 00fec2f0 bff555a7 00fec2f0 00fec2f0 00fec2f0 009abab0 007051ce 00000001 006fcca2 00fec2f0 5f4019fa 006fcd5b 00000001 5f4056c7 00fec2f0 The calculation is a Case/If S…

I have a group of records that include Office, Customer and Amount. I am trying to order the records based on the amount of each customer total by Office location. The final result will be adding an Order field that calculates the order of the records for a single office. For Instance: Office Customer Amount Order PA ABC $1000 1 PA DEF $900 2 PA HIJ $800 3 PA KLM $700 4 PA OPQ $600 5 PA RST $500 6 The order field has to be able to ca…

I'm trying to implement a global field [g_recent] that lists the last 10 records accessed within a file. This "stack" is updated [insert with calculated result] with navigation buttons [a pattern check "sub" script eliminates duplicates]. How to delete line 11 of g_recent when a new line is inserted into the stack. [email protected]

Hi to all. Please can someone help me with this? I have 3-dropdown popup lists for Date of Birth. 1) Day 1 - 31 2) Month January, February, March and so on 3) Year 1910 - 2003 Now what I need to be able to do is convert this into a date format in another field. Please Help Thanks in advance. Craig

Hi, I'm creating a db of books. I have fields for Author, Title, and Publisher. I want to join these together with a single calculated field to make a citation, such as: Author&". "&Title&". "&Publisher&"." with the result: Smith, Joe. Book of Knowledge. Everything Press. Is there any way that I can italicize the Title and leave the rest in regular type? I thought of just placing the three fields next to each other and italicizing the Title field. But since I don't know how long the Author field will be, it won't look like a single entry. I could use sliding fields for printing, but there is no way to get the effec…

Hi everybody, I've a simple question (I guess!). I manage a value list using a Pop-up menu. Each time a user want to add a value, using "others", he needs to go down the list (which is pretty long) to do so. So, is it any way to put the "others" on top of the value list ? Thank you in advance for your help

Hi... I am feeling very stupid, but I cannot get Status(CurrentPageNumber) to work for me. I defined a field "pagenote" as a calculation Status(CurrentPageNumber). It's simple, and should it not return the current page number for any record in a list format when I preview? Wouldn't records on page 2 have the number 2 in the field "pagenote" when I preview that page in the list? I've tried to define this status function a number of ways, but cannot seem to get it to display anything other than 0. You wouldn't think I've been using fmp for years... this should be filemaker 101, but I'm drawing a blank on what I'm missing. fmp 6.0.4 on OS X 10.2.3 thx for …

Is it possible to have a calculation: If(Price >0,perform script "select rate","N/S"). When the select rate script is performed it sends out a number. In other words can you perform a script through a calculation? Also, is this script (select rate) possible to operate as is? Enter browse mode Allow user abort [off] Set error capture [on] If[rate_code =

Being new to the forums, I hope that this question is placed correctly. I am developing a database using FM Pro Unlimited to display help desk phone analysts' statistics. The supervisor accesses a web page using Web Companion, enters a date and is given individual and team stats for that day, week, and month. I have 4 tables that house raw data that have a series of key fields defined based on the ID of the individual and the date. The data is used by series of tables to do the periodic calculations as follows: Table Names Supervisor Daily Supervisor Weekly Supervisor Monthly Agent Daily etc, etc These tables have a key field that is an unstored…

Hi, I did search for an answer in previous threads but couldnt find an answer. I have the following problem: I use maxs to create my solutions on and I've made one runtime (as a test) on a wintel box. Worked ok but the weird thing is that on my screen (1024*768, flatpanel) the layouts are as I wanted them to be. The runtime on a pc however shows a smaller layout. About 30% smaller or so. I've checked the settings on that flatpanel and it has the same resolution as I have, yet all is way smaller and more difficult to read. Is this something thats 'normal' on a pc or is it something I did wrong? Either way, I need to get this fixed and I'm not planning on re-doi…

i thought this would be really straightforward but alas not This is what i want to do .i have a field called "filepathtext" it contains the filepath of a file .I want to take that field and remove the filepath section of it EG OSX:file:myfile^gnat. i would like to move the "myfile" part to one field and the text after "^" to another field . the problem is i cannot use a "left/Right/Middleword" statement because each record has a different file path and therefore a different length ,what i am trying to do is find a function that finds SPECIFIC TEXT and not WHERE it is ... any ideas THanks Paul Apted

I have a purchase order database, where products are selected using value lists and after making your selection a lookup is used to find the cost of the item this is shown in a calculated field unitcost. The line entrys are stored in a portal called purchaseorderlineitems. I need to apply a discount to this unitcost (ie Linetotal = (unitcost-discount) * qty, this is fairly straightforward. But, I need to be able to apply discount as either money (ie

I was just putting together my A/R report when it occured to me that it would be really handy to have receivables grouped by the age (30 days from now, 60 days, 90 days, 180 days, 1 year, etc.) The only way I can think of is to have a calculation field on the receivable like this: Case(Status(CurrentDate) - receivableDate < 30, 1, Status(CurrentDate) - receivableDate < 60, 2, Status(CurrentDate) - receivableDate < 90, 3... etc. Then group and subsummarize by that field in the report. Is that the best way? Would this be slow if there were a lot of records because Status(CurrentDate) would have to recalculate for each record? Also, would I…

I have one field containing a number, and another field containing (possibly) a list of text strings. For example... Field1: 55555 Field2: 12345123456 OASDG2345 0897ASDF0A Now I want a calculation field that will list all of the items in field2 preceded by whatever is in field1... 55555-12345123456 55555-OASDG2345 55555-0897ASDF0A Any ideas?

I have a database that contains data as well as images. It is hosted with FM Server 5.0 on a Mac with OS 9.2.2. When a Mac laptop with a secondary monitor at a remote site logs on, the data is visible and editable, but the images are not. When the secondary monitor is unplugged from the laptop, the images are viewable (on the laptop monitor). Does anyone know why this happens and how to fix it. My client can't unplug their secondary monitor every time they want to see the images. - thank you

Hi can anyone solve a problem for me. I have created a form in FileMaker Pro 5.0. It runs over 10 layouts. At the end of each layout is a 'Submit' button which takes you to the next layout. Most of the fields are required to be filled in so under 'Options' for each field I have validated them 'Not empty' and to 'Display a custom message if validation fails'. So what I want to happen is if you are on layout 1 and forgot to enter your telephone number in the required field when you click on the submit button a message comes up "Please supply telephone number". Simple yeah? No!!! What comes up is a message saying '"Supplier" is defined to require a value, but …

Hi everyone! I'm trying to figure out how to give Management and our Accountants exactly what want. Management wants services refelected as a plus and payments reflected as a minus (which makes sense to me). But our Accountants want everything listed as Debit/Credit - listed as a plus on both sides. And then Adjustments can be either a plus or a minus depending upon the adjustment! Our new AR and GL is functioning but I can't seem to make everyone happy. Services reflect as a plus in Services dB and payments reflect as a minus in Payments dB. When it posts to the GL, I convert payments to a plus to post to both debit and credit. But then Management wants to…

I have a Juke box of sorts with songs in a container field and search facilities - I am using a portal to create a Play list, but I can't find a way to make a sound file in a container field play automatically. I want the script to go to that record and tell the song to play, then move on to the next song etc. Any help would be most appreciated !

I have a database with about 12,000 records right now. The print layout will be like a label layout, it will be 6 labels per page. My problem is this. I need a page number in the corner of the page but it needs to reset every 125 pages. Basically, we are going to print these labels and split them up every 125 pages, and the easiest way to do this is number 1 - 125, then restart the numbering 1- 125, restart, etc... this way when they are splitting it up they can just leaf through the pages and watch the number, when it gets close to 125, they slow down and can split it up real easily. The solution i can think of (and am about to work on) is either a calculation fiel…

Hi, I am trying to set up a system that will allow automated import of images into my database. The database is a real time catalog of inventory for what is essentially a high volume architectural consignment store. I would like the user to be able to place a product in a photo booth and then hit a button in FM to "suck" a picture of the object into the current record in database. The pictures need to be jpegs of sufficient quality to publish to web. I think with combination of troi file and applescript I can handle images once they are on the HD but my current problem is trying to find a good way of getting the images on in the first place. The troi…

I am trying to create a field which looks to a field in another file and asks if it contains certain data. The field in the external file contains names seperated by a carriage return. The fictional if statement I feel I want to use would be : if(relationship::externalfield contains "JOHN","yes","no") ANY IDEAS ? What I have is a database of members and a database of events, I have a script to add a member to an event which copies the member name into a field in the events database for that event and does a carriage return. I then want a field in the members database which checks if that member is in the event. I have tried to use repeating fields in the …

Hi, This seems to be such a simple little problem, but I just CANT get it to work. I think the problem may be of my understanding of AND and OR's in Filemaker. I've done very similar to this before, but never with multiple conditions. I have a grade level field that is one of two, High or Low. If the person is High, the comment_whole can be of the length 'High length'. If the person is low, the length can be 'Low length'. This are different numbers, as it depends how they're printed. If the comment_whole field is longer then the appropriate length, I want it to show up with some sort of text showing the user, at the moment "error" will do. This is what…

Hi All, I have two fields 1. which contains a number which corresponds to a picture (jpg) 2. and another which is the container I wish to have a script which imports the jpg into the container without dialogue. Is there any way to do this? TIA Benzie

Here is the scenario I insert a photo in and have the "Store only a reference" box checked. If I copy and paste the image is the copy a reference also or is it not?

I have 10 different field calculations that represent commission types. I need only to assign one commission per client. How would I assign each client their commission permanently and have it calculate?

Hi In the old time, when FMP was giving "could not draw picture file" message inside a container field, I could fix the problem by deleting a file called "XTND Translator List" stored into the "System Folder/Preferences" folder. This was with OS 9.2. Now that I get the same message under OSX... what should I do?

I am currently designing a simple product database and my quandry is this. There is a item code that should count up from 1 to a number anywhere from 5 to 95. I then should be able to set the number back to one and the subsequent new records should start counting up again. I know about the increment ability in the Auto-enter options but it is a bit of a pain to go into define fields everytime I want to start at 1 again. Is there a calculation I can use like Max(field) + 1 that won't throw a circulation error. The product items are in groups so I can query just the group I'm after and find the last (and highest) record of this field. Please let me know if you…

I have a solution that is basically a quoting / PO / Invoicing program. Well, what we need is to be able to put a cost (our cost) in and a mark up% or a mark up set amount and it calculate the pricing (cust. price). Easy enough... Well, some places that we order wholesale from give us their catalogs. In the catalogs are the MSRP (customer price) and a letter code that tells us how to get to the cost price. So what i need to do now is allow for entry of price and the letter code to calculate our cost and our mark up % to get to that price... I can do each one of these INDIVIDUALLY no problems. But what we need is to be able to insert EITHER the cost OR the PRICE …

More difficult than it seems.. In list view I want to highlight the selected record with a different color, with a calculation field (result container). The calc meets the condition, the container gets a color. Sounds easy. But how to determine in a record that it is selected? All references to status(currentrecordnumber) seem to bite their own tail, because selected or not, the condition is always true as the status (currentrecordnumber) in the record itself does not reflect the selection. Anyone any ideas how to achieve this? Thanks Harryk

Hi, I know this has been asked before (I just did a search) but perhaps things have changed.. Is there any way, aside from a quicktime movie, to get an animated gif to work in FMP6 ? any hack, workaround, experimental feature? Anyway at all? (apart from switching layouts really fast!) thanks for any info.

Does anyone know why it takes a while before filemaker (mac version) is playing a sound? Like the "beep" script step? Thnx in advance! Jeff

Hello everyone - I'm a complete newbie at FMPro - but I am an avid Mac user and like to try to do things myself. I'm setting up a small home-based business, and want to use FMPro for product lookup, invoices, customer lists and the like. The first thing I did was take my product pricing from my distributor and import it into FM - so i can look up cost on a particular part number easily. That works well. What I can't figure out is how take a field - say MSRP - and use that as a basis for two discount fields - one 15% off and one 10% off. All fields are defined right now as text. Maybe I don't have the right book, but I'm not finding any answers. Can any…

Hi Everyone! I have related two dBs on a Match.Key. Main dB HistData (114,200 records) with cService.key (text, unstored) as: DateToText(ActivityDate) & ClientID & StaffID & ProcedureID & NumToText(Amount) Child dB Service (4,843 records) with cHist.Key (text, stored) as: DateToText(DateOfService) & ClientID & StaffID & ProcedureID & NumToText(LineTotal) My problem is that the Key is 'relating' them even when it shouldn't. Both date fields are formated as date, both dollar fields are formatted as number and the ClientID, StaffID & ProcedureID are formatted as text in both dBs! When I place both Keys on a ta…

Hi everyone! I have a text field which also contains a date. I need to move the date to its own field (ServiceDate) but I'm having trouble pulling it from existing text. I tried using Substitute(Description, " ", "-") to at least separate the description from the date (so I could then pull it easier), but it substitues the three spaces with three dashes I've considered LeftWord, RightWord, Left, Right, and Replace but can't figure out how to handle it. Does anyone have any suggestions? Existing data is: W/H 5% LCARE 05/24 MED/ADJ INS # 67081584 05/30 Pers Check #1751 INS # 2617 07/26 The above data doesn't reflect that there are …

I there a way I can have a random alpha numeric code generated in filemaker whenever I create a new record...

I would like to have a status windows that shows if a statment has already been paid. I have one file with the statement and the status windows and another file that contains an associtated record based on its serialnum. What i need is to have something like (if serial number exist in file paidcommison then show COMPLETED otherwise show UNCOMPLETE) possible? tony

Hi there - I have created a number of files for my company. They include 'clients' 'suppliers' 'library' etc. I have created a 'start up' script that opens all my files and minimizes them - awiting to be used. I have added buttons to each layout/file that 'opens' one of the files. BUT if I am the host it is quick and opens instantly. However, if i am a guest then it takes up to 8-10secs to open the file. It appears as though it is searching onto our server for the file. HOW CAN I JUST GET IT TO OPEN THE FILES QUICKER? SHOULD 'OPEN' ONLY BE USED IN THE START UP SCRIPT? AND SOMETHING ELSE WHEN ALL THE FILES ARE OPEN??

Hello all. I've been trying to create a repeating field that starts off with a default value of "yes" in all the repeating fields but I've had no luck. Only the first "cell" of all the repeating field has "yes" as a default value the rest have nothing in them when the record is created. Anyone know how to set all the "cells" in a repeating field to a default value. Thanks for the help.

Thanks for this forum, i hope i can help members with some of the issues. However i would like to start with a question myself. I am using filemaker 5.5. How can I define a text box with a scrollbar that is not editable by the user. Thanks Jitse

Hi Everyone, FMP newbie here. Running version 5.5 on Mac OS 9. I've created a database to keep track of whats on my archvice CD. Each record contains 4 fields: Archive #, Date burned, CD location, and CD Contents. The CD contents are copied from the finder and pasted into the text field for CD Contents. This makes each folder name on its own individual line. Some of my archive CDs contain over > 180 files. The list is very long. I have to turn on scroll bars however its still rather cumbersome. Is there a way I can create another text field box and have the contents flow from one to the next? Almost like a 2x column look instead of one long hard to manag…

Dear All I am sure that this has been posted before in the past so my appologies if it has but I have created a field that performs a calculation if the outcome of this calculation is greater than zero I would like the text to change colour. Please help.....if this is not possible in defining a field I am equally happy to write a script to do this but I do not know how to change colour via a calulation. Thanks in advance for any help

Good day Here is my situation. I have to create a database system for a nordic ski race event. Many participant and many categories. I want to sort the result 1) by categories, I have created a subsummary in the layout 2) The records heve to be sorted by result (HOUR), and then, that cause me problem, with the RANK (from 1rst to the last) and this ranking method heve to be repeated and refresh for each categories. EXAMPLE JUNIOR A Categorie Number Name TIME RANK -------------------------------- 23 Jos Blo 32:00:01 1 12 James B 32:00:03 2 [...] MASTER A Number Name TIME RANK -…

Not sure if this is possible, but I'd like to define a field for the last modifier. I know how to do this, but I'd like to exclude an individual. That is, to have a field that displays the person who last modified the file, unless that modifier was, say "Bob". Is there anyway to do this? Reason being, there is a script that runs on all records every night from Bob's computer and we don't care about the specific modification. Thanks in advance!

How do you round a number up to the next highest thousand? I've tried the Round function but it doesn't do what I want it to do. I tried putting in a negative precision number but no luck. Here's an example of what I need: Number entered: 54,001.30 Rounded number result: 55,000.00 Number entered: 38,202.03 Rounded number result: 39,000.00 Thanks for the help!

Hi all, I'm still working with 5.0 and am making an orderdatabase for a client of mine - the ordernumber is a unique auto-entered value. But what they also want is a unique invoice-number which has to be made when you click on a field in the order-record, and is not generated with a new record at the same time as the ordernumber. I wanted to use a seperate invoice-database for that and use a portal in the orderdatabase, but I don't seem to be able to use that invoice-field as a button to make a new record in the invoice-database? Can anyone help me out?

I have looked though the various posts in this and other forums and feel I must be missing something but all I want to do is create two fields that will tell me two things: The Record Creation Date And The record last modification date. Is there a simple way to capture and show these - the modification date is more important. Many thanks John

Ok, I want to make a particular layout, but I'm kind of confused as to how I should design it. I guess the best way for me to describe my layout is to show you how I'd like it to look. First off, here are some of the main fields... Song Title, Film Title, Status (can be one of three options...New, Researching, Complete). And here is how I want my layout to look ___________New________Researching_________Complete______Totals --------------------------------------------------------------- Film 1__|___2______________0__________________1_____|_____3 Film 2__|___0______________9__________________6_____|____15 Film 3__|___5______________1__________________3…

Can someone please advise me on the calculation I need? I have a field Hits (number) which can be empty, zero or any number from 1 to 20; a calculation field HitsStatus (result Container); and a repeating container field HitsColour. HitsStatus 'colour codes' records depending on the number entered by the user in Hits. At present HitsStatus is defined as Case [Hits=0, GetRepetition [HitsColour,1], [Hits<=5, GetRepetition [HitsColour,2], [Hits<=10, GetRepetition [HitsColour,3], [Hits<=15, GetRepetition [HitsColour,4], [Hits<=20, GetRepetition [HitsColour,5]] which shows a different colour as intended depending on the numbe…

I want to use FM to archive photos in a database. How can I import photos and preserve the IPTC caption info on the JPGs & Tiff so they are searchable information? Any help on this would be appreciated...