Calculation Engine (Define Fields)

Hi, I was wondering if there is a faster shorter way to write a case statement with multiple criteria. For example: case( field_1 = "apple" or field_1 = "pear" or field_1 = "apple" or field_1 = "peach"; "fruit") basically I wan to know if I can type field_1 = all the values for that result in it without having to type field_1 = for each value that will result if fruit. Like: case( field_1 = "apple", "peach", "pear"; "fruit") I am just a lazy typer I guess, but can something like this be done? Thanks in advance

Hello I have a database of zip codes. The problem is that for a certain zip code all the hamlets and intersections are listed. For example for the zip code 13421 which is the city of Oneida I get another field which claims that zip code to be the same for Oneida Castle , Scribners corners, Five Corners, Kenwood, Merrillsville - Anyway the main city field is called city and the field with the alternate names is called hamlet I would like to find a way to replace the field "hamlet" with all five field content as shown above to the new record would be city "Oneida" hamlet "Oneida Castle , Scribners corners, Five Corners, Kenwood, Merrillsville' …

I want to know how extract part of a field. For each record, I want to extract the last part of an email address. For example if the email address is [email protected], how can I extract 'world.com'. Your reply is much appreciated.

hi all! let say i have 2 fields. 1 is creation date(it will automatically fill the current date). and another 1 is due date (drop down calendar) what i wanna do is, if someone choose a date from the calendar which is before the current date, custom dialog will appear... but i donno how to do it.. someone help me plz

I am having a terrible problem. I have a very simple database which will have 2 images for every record. I have 6 records and my datbase is up to 80MB but the pictures are a maximum of 1mb each. I have not deleted any records so I can not understand where all the fat has come from. This can not be right. When I am up to 1000 records my file would be rediculously large. Is there something I can do rather than storing a reference, I used to do this in the past but always ended up with more problems than advantages.

I've got a field "Client Type" that, if changed, I would like to know what user changed it last. I think what I need to do is create a calculation field to return that User's name, but I don't know the verbage to write it. Please Help!

I need to know is there a way that ican force a user to enter a strict 8 digit date field ie. DD/MM/YYYY. I have to export data to other programs that use a strict 2 digit date and 2 digit month field so would be very useful.

Hello Everyone, Don't know if this is where this topic should go, but here it is. I'm trying to figure out a solution to adding steps in an operation on the fly. I'll set it up as best as possible. I work for a job shop company that builds per customer specs. It can be very complicated with hundreds of pieces with numerous operations to complete. I'm trying to create a database that will allow our engineers to simply add an operation in any order needed to complete the job. Like a "click and drag" operation. An option to later add an operation "on the fly" would also be important in case something was missed. I have three tables. Job Table, Opera…

Hello fellow FM'ers, I'm in the process of designing a database for a services firm and want to ask the following: I can see a drop down calendar option as a field. You can only select one date at a time. This is wonderful for other operations but what happens if you want to select a group of days together? Say for example, a customer wants 23 lessons in the month of March, altogether that is 23 days. I wouldn't want to put 23 drop down calendars on my layout (1. It wouldn't be efficient 2. It would be a very pig ugly layout). I can manually type in the date but it is not very efficient and there would be more of a chance of human error. Does anyone kn…

I want to place a global container field with the "delete" icon at the end of a portal row, it will be attached to a script to delete a row. The thing is that I don't want the image to appear on the last empty row of the portal. Therefore I would like to place a calculation container field that won't display the image if the row is empty (last row). The questions are: What would be the best calculation? do I have to make a calculation for each table, or a general calculation will work for all portals?

I need to pad numbers with zeros at the end when they have no numbers, to the second decimal place. Example: Entered by user 1 1.5 2.25 6.05 4.8 2. All these number should be padded with zeros, if needed, and should look like: 1.00 1.50 2.25 6.05 4.80 2.00 Does anyone know of a good function that will take these numbers and pad them?

Two questions... 1) Suppose I setup a field to contain a 3 digit (numeric) area code (USA, for phone numbers). Is it possible to "automatically" jump to the next field after the third numeric digit is entered? 2) Can the active field be made a different color from the rest of the fields (so the user always knows from the backgrund color which field they are entering data into)? Thank you.

hi everone, i know that this is a simple one but how do you change the record number. i have a bunch of records and then added some more to it. i need some of the new ones to fit in with the others... example: existing record number 33 and in need to add a new one and make it 34. i know that this should be easy, but i can't seem to get it. thanks Peter

When I use "Status (CurrentRecordNumber)" in a calculation it seems always to return the same number for a given record, regardless of the size of the found set and regardless of the sort order. It's as if it's returning the Record ID, not the Record Number. From what little I can find in QuickHelp or the user's manual or the filemaker.com knowledge base (and that's *very* little), Status (CurrentRecordNumber) is supposed to indicate where the record is in the found set. But I can only get it to indicate where the record would be if you did a Find All and did not sort the found records.

Hello, Does everyone know if I can in filemaker, use a Date entry form, like in access when we want the user to type a phone number ex. XXX-XXX-XXXX Thanks

... On each of my main layouts i have 2 fields: post code / state fields which are both fields from a related table that are related by the suburb name field (present in both the main TO's and the related suburb Table). While i know i could have used look up fields, i did this in order to avoid adding suburbs manually in a different section of the database. My question is this: If the suburb or state field is being modified on two of my main layouts at once, will record locking occur. My second question is whether record locking occurs by Table Occurance or by Table. Finally, my question is, if i enter a field within one of my main layouts, (not pertaining to a relat…

In filemaker 4.0 this is the formula I used for tracking Days Past Due and it works great, but in 7.0 it works fine after you put in a billed date. But before you do it makes a huge past due number. If(PAYED ACC< S TOTAL, Today- BILL DATE,0) In 7.0 it changes the comma's to simi colans and won't let you change them back to coma's Any help would be great

Hi! I'm fairly new to filemaker and I was wondering how I could show the # of total new records. I am already showing the total of all the records but I need to show the # of newest records. How do I go about accomplishing this? Any help appreciated, thanks.

Is there anyway to remove filemaker 8's dynamic spell checking feature from a particular field? Cheers, ~Genx

Hi all I am trying to get a calculation field called GST working to fuction like an if, elseif statement. THere are two situations where this calulation needs to be done. GST= If Classes::type="Movement and Music" then cost*.07 or GST= If Classes::type="birthday" then cost+14 Here is what I had for the first part. GST= If ( Classes::type="Movement and Music" ; cost*.07 ) THis works for the first instance. When I add: If ( Classes::type="birthday" ; cost+ 14 ) Filmaker complains that there is an operator missing. I tried adding an or in between but that seemed to give a value of "1" when either case occurs. Any Ideas about what…

Hello - I'm developing a db in V5.5 for creating printed ads. The way I set it up is this: I have a field for every ad piece (8 of them each on different layouts) and a field which identifies which category it is (called "Category" and is prefilled with the appropriate category name). The user selects which record they want with a checkbox from each layout. Here's where I need help. When they are done selecting I have a script which finds the selections (based on the category field), goes to another layout and displays them in a list. To display them I placed text in the body like this <><><>> there are 8 total and they display nicely one on t…

Hello, I am a newbie and I have 2 questions. I am trying to use the save as pdf in fmp8. The pdf has several graphical elements from a couple different tables. I need the pdf to be as small as possible. My questions are: 1) How do I get transparent graphics? I need to make sure what was white space in and around the graphic show up as transparent so the graphic behind them shows through. I have the graphics in vector art in Illustrator and freehand. I need the final pdf to be as small as possible. Less than 2 megs. I have about 8-10 graphics on the page. I need to make sure that someone can zoom in on the pdf to see if the appropriate trademar…

Is there a scriptless way to calculate a single Last-Modified date for an Invoice with LineItems shown in a portal? A "modification" would include not only changes to an line item, but deletion and addition of line items as well. Thanks, Chap

I have a field that is defined as the sum of 3 other fields in the record. However, I am trying to avoid misleading entries in the calculated field caused by one or more of the contributing fields being empty. Does anyone know of an easy way to calculate a field from 3 other fields only if none of the contributing fields is empty? Marcel

Is it possible to set up a field that if the user clicks on it, the field (or box) turns a color? Also, if it is possible could it also be referenced by another field. For example, if(Field 1 > "", "Yes","") Thanks for any help...

Hi Folks - this forum is just sooooo helpful! Thanks to a fussy bookeeper, I have a new problem with automating serial numbers for invoicing. This current calculation: [color:red]( If ( Month ( Sale Date) < 10 ; "0" ) & Month ( Sale Date) & Right ( Year ( Sale Date) ; 2 ) & newSerial# Invoice) returns: 03060000 03060001 03060002 03060003 etc… with each new record. However - now I need to figure out how to automatically reset [color:red]"newSerial# Invoice" back to [color:red]"0000" at the start of each new month. Any ideas out there?

Hi, I am new to Filemaker and to this forum. I have only experimented with Filemaker for a few days. If I have posted this in the wrong section, please move it to the appropriate section. I am trying to create a simple inventory program for a small non-profit organization that I am working with for a class that I am currently taking. This organization receives supplies from a manufacturer, assembles the supplies, and ships the finished products back to the same manufacturer. All of the supplies have individual Part Numbers. Once the parts are assembled, the finished product is given an Item Number. Different Part Numbers and different quantities of it make …

Hi Everyone -) I am currently developing a Membership database, but have ran into a little bit of a problem. On various layouts I have a field called 'Factory' that when selected, gives a drop down list of Factory Names/Code Numbers. When the user selects a Factory, the 'Factory Address' fields should be automatically completed. This information comes from the layout 'FACTORY' - where factories can be added/removed, and their details can be ammended. However, the issue i am having is that when i select a Factory from the drop down list, the address details are not automatically completed, even though the relevant data is showing in the 'FACTORY'…

Hi master! I have a difficult problem for a longtime. purpose Calculated in accordance with specified time-frame and repayment。 Description : I recorded data, showing the date of repayment deadlines, in the hope that the results will be automatically calculated to expire automatically after completion. Let me present statistical statements accurate statistical Current issues When I change the computer clock or open it at new days , the Records not eligible for the implementation of orders。 Request you to help teachers in the test presentation or modified. Thank you. test3.zip

No, I dont stutter. Has anyone worked up a calculation (or have some elegant ideas) that would evaluate a text field as if it were the text in a calculation, and return the text with invalid syntax highlighted and hints at why - a la the define calculation dialog box ('Field could not be found', 'an operator is expected here'...). I can imagine how it could be done, but from my view it does not look like a simple task. Thanks! -Raz

Is there a way to create a field that compiles entries from a repeating field? I am using a repeating field to track companies I am working with on a particular project. Entries in the field range from Zero to one or two, or up to as many as 15 or more. Accomodating this field on my layouts requires a separate layout, but it would be useful if I could create a field to feature on my primary layout for quick reference that summarized the results of the repeating field, like the following: [Company A; Company B; Company C; etc.] This seems like it should be pretty simple, but is beyond may current capabilities. Any help would be appreciated. Thanks, John

Hi all, and thanks in advance for helping a noob. I have a simple billing DB with a "finalize" script that needs to paste the last calendar day of the current month into a date field. Currently I'm just setting the date field with a static (but temporarily correct) value for the last day and then manually changing the script every month. What I need is a calculation that generates the last calendar date of the current month automatically. I'm sure there's a simple Date Function solution, but I'm stumped.

Here's what i need to do, and I'm not sure if it's possible: Out company needs to automatically generate a MATCHCODE field (a unique identifier), based upon the concatenation of three fields - the first five alphanumeric characters of the COMPANY name - the five digit ZIP (including leading zero) - the first four alphanumeric characters of the ADDRESS. note I say alphanumeric characters - spaces and punctuation are not to be included. Certain records would be easy, ie. COMPANY: Sharp Imaging ADDRESS:1143 Main Stree ZIP: 04054 would result in MATCHCODE: SHARP040541143 But this: COMPANY: A.B. Stryker ADDRESS: 14 Elm Stree…

This may sound very trivial or maybe im just having a bad day...I would like to get the name of an inserted PDF in a container filed and enter this in to a calculation text field...can anyone help?!! }:(

When I specify Get (ActiveFieldName) in a calculation field and tab through the fields the function returns absolutely no results. I have found this with several other Get functions as well. I have tried formatting the results as text and number, makes no difference. Am I missing something totaly obvious here or have I got a bad instalation? The help menu simply states that the function returns the field name currently containing the curser. Hopfully you all will be more help than the menu.

Hi, I need to add a slash to all double quotes in a text field so that when exported, it can be properly interpreted by the program we are sending the flat file to. So, for example, this: he said "hello, how are you?" becomes this: he said "hello, how are you?" It seems like a pretty simple fix by using the substitute function, but I'm having problems getting the syntax right, i.e. this doesn't seem to work: Substitute(FieldName;""";"") Any idea how to do this? Thanks, Andrew

Hi I have created a report layout that displays individual Job tickets showing there Required Date, Customer, Reference and Spec No. They are Sub-Summarised by the Customer, and also have a Trailing Grand Summary. What I would like to have is field in the summary definition showing the range of required dates that I searched for in the beginning. Something like this: " >28/2/2006 <10/3/2006" Also is there a way of having a Calculation Field in the sub-summary definition that only calculates the records it's found and not the overall total found records just like a summary field works.

I have several reports where I count the number of records found based on specific search criteria. I can't figure out how to get the counts from each report as hard data that I can display on a separate, single layout. If there is anyone out there who can help, I would sure appreciate it.

How can i get a balance reporte with fmpro

Hello, I need to make my date field only have 01/01/2001 type of dates as opposed to 01-01-2001. I'm guessing it's a validation calc? Thanks so much :-D

Hi. I'm wondering if anyone knows a way to insert data from a field/form/record/pdf copy or anything into a mail message generated using a mailto script. Obviously this feature works using client, but I'd love to find a way to include some data in the mail which will provide the recipient of the mail with more info than "a request has been submitted". I'm using fmp to serve forms, such as new user requests, on the web. When the form is complete, the mailto command generates a new message on the client computer and the client has to send the message. I'd love to find a way to have filemaker server to generate the message perhaps?

Hello! I'm trying to make field2 only editable if field1's contents match valuelistA. Otherwise, it won't allow editing of field field2's contents. (Ohhh the things we do to protect our data from lazy people!) Any ideas? Thanks!

I have a database where I use the exact function to compare text field A to text field B to alert me when they no longer match. I then need to find what the change was. Typically the data in the field is so small that visually finding what is different is very simple. Lately this has not been the case and am now looking for a way to highligh/identify or in some way display what text doesn't match between the two fields. Does anyone have any ideas or know of a custom function to solve this?

I try to create a field that can expand in relation to the amount of text I provide. That would be visible in the browse mode as in the preview mode hope I hear some good solutions gr Pieterbas

What sort of calculation can i use to check if the last WORD (rightword, 1) of a text field, is made up of just numbers. This is to be used to extract zipcodes from address lines. Generally, the address line field runs as follows: add1, add2, city, state zip but on occasions, the zip and state are reversed, or the country has also been added to the end. I therefore need to be able to check if the last word (or indeed whatever selection of text i pull out) contains just numbers - if so I can therefore identify it as a zipcode and copy it off into another field.

I have a crossplatform solution that manages lots of photos. FileMaker creates a thumbnail when it Imports From Folder. The thumbnails look beautiful when the import/thumbnail creation process takes place on a Mac but are marred by relatively intense moire patterns when the process takes place on a PC. The effect seems to relate to the platform used for the import not the platform used for viewing, i.e., PC created thumbnails look like crap when viewed on a Mac and Mac created thumbnails look great when viewed on a PC. Just for fun, I have tried resizing the thumbnail container to no avail... Has anyone else noticed this effect, or have any ideas as to ho…

I maintain several home DBs (FMP 3) for collectables, model trains, watches, etc. Largest is about 400 records. Layout includes a container for one photo of each item / record. Recently I switched from a "web cam" to a digital camera, and cannot get photos imported, even though I'm re-sizing & converting them from .jpg to .bmp before attempting to import. I get the following msg: ".BMP Format Picture Import Filter 1.0" and nothing happens. I have Photoshop Elements 3 available, if that will help. Is there a way to import as .jpg? Is using FMP 3 my problem? Any assistance in how to import photos will be appreciated. Thanks, Denny 101

Hello: How to prevent accidental delete or edit of records on a form? I sometimes find myself with "aaaaaa" or "111111" in a field. With people dumping pile of docs on the keyboard , this happens often. Is there a way to toggle "Allow field to be entered" (like in field format) On and Off with a script on a button to prevent this type of accidental edit?

I have a basketball program with over 300 members. Each year kids graduate (too old) or leave. I don't want to lose their information but I don't want to have them in the current "find" results etc. Is there a way to make an "ACTIVE" or "INACTIVE" field to define somebody's status and then leave all INACTIVE status out of finds and scripts or something ? Anybody know how this can be done? Any help would be appreciated. Thanks!

Here's my problem. A user logs into a FileMaker DB through a Custom Web interface (using PHP, and FX). A user is able to look at information about some subset of rooms, depending on access set up by an administrator. For each user, there may be one or more privileges, for example, user A may look at rooms in Bldg XYZ, while another user B may look at rooms in dept 123. User C could look at rooms for bldg QRS *and* dept 199. I'm assuming that I'll have to have something like this set of tables/fields: User: UserID Name Access: UserID Bldg Dept Room: Bldg RoomNum Dept RoomData A user will only be able to see data from rooms for which she ha…

I am trying to setup a field where each value is unique except for one instance. Example A number field where each record would have a unique entry except when entering the number 10 which could have multiple records.

Hi Guys, Not sure that this is the right place to post this, but Im developing a system, which uses the "£" symbol, to format any field that resembles money. My question is, as my client deals in the European Market, he will issue out Purchase Orders etc in Euros. I have created a Text field called currency, which I place in front of number which resembles currency. This looks untidy as the currency symbol is far left of the actual number field, is there a more elegant way of displaying multiple currencies in my system which looks like the Currency symbol has been applied using the field format option. Many Thanks as always

Sometimes I need to quickly find the unique contents of a field. I've (just now) borrowed (stolen) an idea from Matt P. which uses two fields (Input and Output) and Evaluate(). This is for values usually under 100 or so. It's a time-saver for me because prior, I would have to create a Value List and a calculation or grouped report. But do I even NEED a value list? If I type into input: Evaluate(ValueListItems(Get(FileName) ; "any VL")) it works great. Is there a way without creating a value list? It's too bad CTRL-I can't be used or even Insert from Index. Again, probably something simple I'm missing. This is only for on-the-fly developer needs etc whil…

I'm new to Filemaker Pro, and if this is an old issue or posted in the wrong forum, I'm sorry - I've tried searching the forum but perhaps I don't have the right vocabulary for what I want to do. I need to provide a database with access to certain static reference data that is unrelated to any given record. Globals are not an option here, at least as far as I understand them. To be specific, I am creating a database to track classified ads in the publication I work for. This is currently done in the ancient DOS database Q&A. Our publication comes out every two weeks. Under normal circumstances that means each volume will have 26 issues - but since the year h…

Hi, I have two fields namely address1 and address2. I need to merge these 2 fields seperated by commas. This is how I achived this: This is fine if both fields are populated, but if the second field is empty I get double ,, at the end of address1. Such as: I have tried to use the Substitute command without little success. Could anyone please point me in the right direction. Thank you

Does filemaker generate a RecordID (retrievable by the get(RecordID) funtion) that is unique to the Entire database, or only the current table? Cheers, ~Genx

I tried but failed to make a field that will display the number of days an action, when carried out, is overdue. I provided a field to record the due date, and another to record the date the action was carried out. I made a calculation field "date 1 - date 2" and it shows the number of days between the two. However what I want it to show is the number of days between present date and due date (if possible, showing black when there is time to go and red when overdue) and will freeze at the present (overdue) reading when a date of completion is inserted. I would also like it to email a message every day that the action is overdue, but that might be pushing it. Any h…

G'day, I've searched the forums but haven't seen a similar problem to the one I have. My problem is that I have to change a number of yearly calendars. I want to be able to quickly change some dates and values so the field box (not the text) changes color. I'm not sure what is the best way to tackle this. eg Fields: Date, ColorFlag Values would be like: 01/01/06 = workday 02/01/06 = holiday Using calcs and container fields with repetitions, color the field box 'Grey for work a day' and 'yellow for a holiday'. This way I could quickly change a date from a work day or holiday and the field colour box would change. Hope this makes se…

I've learned that you cannot sort reports by calculated text fields so I need to come up with some workaround. Sadly, I've been using FMP for about 1 month now and am not sure the simplest way to go about this. I have 3 calculating fields that check for weekly stock conditions and either display a big red "YES" or a plain "No" depending on the outcome of the IF condition. Each IF also checks a flag field to see if the warnings should even be displayed. I need to be able to sort on these conditions in a report. I'm embarrased to say that I got it to work by having the IF result in "YE5" (number 5 instead of S) or "N0" (number 0 instead of O) but such trickery see…

Hi folks - is there any way I can get FM to remove accents and other diacritic marks from characters. ie changing é to e Regards

I need to move a table from one file to another. Right now I'm looking at duplicating it by hand. Uggghhh... A better way? Thanks

Hi all, My problem is the following: I have a field which is related to a list made of three items let's say "past", "actual" and "future". I'd like to count the number of record where "Past" is selected, as well as the number of record where "actual" is selected etc... Could someone help me ? Thanks Matteo

Hi. I have a radio button value list of "yes" "no" and "maybe". Also, on each record, I have a field that is a numeric value called "total number of people". I am trying to figure out how to create a summary calculation of the "total number of people" value, but only using the records where "yes" or "maybe" is selected in the radio button. Thanks for your help!

How does one have defined feilds on different tables show the same information? Example: Table -- Main , Table -- Brokers On the main table I have a feild called Key_Code this works just how I would want this to work... But the problem comes in on the Brokers table... I need to have a feild on this page that sets its self to the main table code. I can not get this to work? Joseph

How can I return the result "Evening" if the TimeField is >17:00 and <24:00 ?

Hi I am new to filemeker and big database programs. In need of much help and babying I need to do the following. From a laptop a plasma display will show the daily range of courses at a training centre. It also needs to display a range of photos of training activities that change over automatically. I have manged to get the daily course info in a portal from a data table and have made another portal for the photos BUT..... The photo portal will only show the first photo from the photo table file as there is no script or way of changing the photos over. How do I write a script to do what I need? Also the plasma should only show the designed up databse window with no…

Hello all, Can anyone help me highlight the selected current record. More info: (sorry about my poor english) Fields: Dates, PO#, Customer, Item #, etc Layout: Fields are horizontally arranged (table format) Displayed: Viewed as List I am just trying to make the whole record highlight in a different color so it makes it easier to see the record on the same line. Thanks in advance R___

How do I export multiple records that include Container field attachments/contents to Excel? I need to export multiple records to Excel and one of the fields is a Container Field. When exporting, Excel only captures the name of the file (either .doc or .html) and not the contents. I'm able to export each Container Field individually, but that would be VERY time consuming and not practicle on a weekly basis. Any and all help is GREATLY appreciated! :smile2:

I'm having a bit of trouble using this function. As i understand it, the syntax of the function is Round(Numberfield ; Number of decimal places). Assuming the field contains the number 800, this function should return 800.00 when the number of decimal places is 2. Instead though i get 800 ... Is there are work around for this, im not thinking to well at this point. Cheers, ~Genx

I'm in the process of creating a bidding solution for a construction company (a rather ambitious project for my limited skills!) Anyway, I have created a Products file that allows for a product ID, name, unit cost, etc. that seems to be working OK. What I would like to do is have the ability to modify the unit cost as price changes occur. However, I need to be able to keep a running track of a product's previous price(s). The problem I'm running into is that I need to keep the integrity of all proposals created using previous prices. In other words, if the product SuperWiget was bid at $250, and unit cost increased to $300, I still need to maintain the $250 p…

Is there anyway to get a subsummary field as a percentage of that same subsummary in a grand summary part... hmmm, better question, if you reference a subsummary within a calculation field, will it recalculate within different subsummary parts. Thanks for help ~Genx

Hi, I'm somewhat new to FM, but sort of an old-hat with relational databases. One functionality I'd *love* to have in FM is a select list (drop-down menu) that will show the value of a related field at all times, but actually store a return ID in the field of interest. Both MS Access and Oracle have this kind of thing, which makes development of portal records to related tables easy. For example, a table of 'People', and a related table of 'relatives'. let's say you have a relationship between a FK field Relatives::PeopleID tied to People::PeopleID. In a front end, I'd like to show a list of relatives for this person. It seems with FM, you need to have one pick…

Hello: assistance is requested with this simple calculation. I want to be able to select the year of interest with a radio button and to make a calculation based on the data in that year. Yearly data for one record is lumpped together and not in annual tables (individuals in rows and up to 15 years data in columns). Is there a simple calculation to accomplish this without having to start over and manipulate the base data file? The file is attached. Thanks! changeyear.zip

Hi! I have this project for my class that involves me creating a movie database. The database has table for the movies and actors, now my problem comes in when I want to associate the movies with the actors, because the movies have more than one actor I don't know how to implement the movies table so it accepts more actors. Do I need to make fields for every actor in the movie? Because this would set a limit to the number of actors, or can I include all the associated actors in one field in the movie table? Any help is greatly appreciated, thanks. Andy

Hi, I'd like to create a calculated field (in FM8) that will contain a text string made up of concatentated strings from one field in all the related records (in one particular relationship). For example, if I had a people table, and a related cat table. I'd like a field in the people table that might say "Felina+Boots+Cooper+" for a person with those three cats. I'm not concerned about the delimiters. It seems like it should be easy, but it hasn't been. Thanks, Marek

I'm trying to set up a container field that has 5 repitiions (thumbnail size) then when I click on say repition 3 it shows up in a container field next to the thumbnails, this container field being much bigger in size. The thumbnail container will be 5 different angles to products. Any help would be much appreciated. I searched the forum for this type of problem but could not find any example like this.

Ok, I know I have asked this before, but let me put it a different way. Is there a way to do updates to a distributed app (file.usr) without losing any data and NOT using a plugin that costs $300.00? I realize this may be complicated, but I really need to do this, but I do not wish to pay $300.00 for a plugin. Any Advice??

I have produced a checkbook register with separate categories for different types of expenditures. I would like to be able to calculate the total expenditures per vendor name. If my checkbook register lists the following checks: Acme Woodworking : $15 Ajax Plumbing : $10 Ajax Plumbing : $12 Bob's Delicatessen : $10 Bob's Delicatessen : $16 I would like my final report to total the purchases as: Acme Woodworking : $15 Ajax Plumbing : $ 22 Bob's Delicatessen : $ 26 I will write a check to some of these vendors several times a year and some of these vendors just once. Is there a way for F…

My problem is in STOCK I have the Normal Price/Promotion Price, now when I key in the STOCK DATE FIELD FROM(07/03/2006)DATE FIELD TO(17/03/2006)and key in the Promotion Price Field. In the Invoice, when I select the Part No. and the Creation DATE in between this PROMOTION DATE, automatically get my PROMOTION PRICE, if not the PROMOTION DATE get the normal price. can someone let me know how should I do this issue? Thank! Promotion_date.zip

I want to reindex my database so that the number of records match the index number. There are already 1500 records. The database is not being used yet so it's ok for me to do this now, but I don't know how to tell FM to reindex all records. Tangier

I have a Line Items table that is related to my Customers table through the Invoices table. What I'm trying to do is Count the unique "customer_id" values that my Line Items table might have. For example, if Joe Smith has an invoice that has 2 Line Items. In my line items table, there would be 2 records for Joe Smith. If I did just a simple Count on Joe Smith's "customer_id" from the Line Items table, I would get 2. What I'm trying to figure out is how to Count Joe Smith once (or unique). I hope I explained this right. Please HELP! Thanks in advance, J

Hi all, I added a new field to one of my underlying tables (in Define Fields), then added it to the layout for that table (which is just ordinary Table view). The new field shows up in Layout view and List view, but I can't get it to appear in Table view. Any advice? Thanks!

I can't seem to figure out how to something that should be very simple. I have a transactions table. An invoice table. And I have a payments table. I need the ability to create a payment that is related to both the transaction and the invoice. The problem is that I should be able to post multiple payments to multiple invoices in a single transaction. I have a feeling that I could use a repeating field in the transaction table to achieve this, but I'm not quite sure how to construct. Can anyone give me some direction?

Hello, I really strugle with calculations in general, so need help. I have unique field WO#s that is the relationship between two databases. I am using the wo# field to populate a value list for my user to choose the appropiate WO# on another database. However, I only want the value list to display the WO#s for the past 14 days. I did nto see a way to create a list by calculation, so my only guess is to create a new field with shows only the last 14days of workorders and then define value list to show from this field?? Thxs.

Hello, Mac 5.5 server with Mac OS X clients environment. I am using this forumula "Length(TextToNum( Account Number) ) = 10" to validate if the user entered 10 integers and prompt if they have not with a message window. Formula works fine, except that this formula fails to recognize starting with zero "0" as a first valid integar. Example, if I enter "1234567890" formula works fine. But if I start with a zero "0123456789" the formula does not accept the starting zero as a valid number and fails as if the user has not entered 10 integers. All is well if the zero is in the middle and/or the end of the 10 integars. How can I modify this formula so a starti…

Omigod--this is so hard to explain in words...but I'm desperate to get my taxes figured out. I'm trying to find my total inventory cost of goods for business taxes (in report form - FMPro Version 6). For tax purposes, it's either 1/3 or 1/5 the total retail cost--I'm not allowed to use the full retail cost. I've got columns set up for: -The selling price of each item. -1/3 the selling price of each item (calculation) -1/5 the selling price of each item (calculation) I need to be able to select either 1/3 cost or 1/5 cost of for each product so that I can later combine them to equal the Grand Total Cost of Goods Summary. As long as my 1/3 &…

The result from function Get ( TotalRecordCount ) does not equal the last serial number in my table. For example the result of the function is 13273, but if look at the last serial number used its 13279. Could this be the result of an empty record that took up a serial number? If so, how do I locate those empty records and delete them?? thx.. Jess

In building a runtime solution, I'd like to have certain "overhead" items on hand for displaying on various layouts. For example: , which I would normally enter prior binding the runtime, but which I could change on a Master Parameters Screen after distribution, if ever needed. , which is stored in a calculated field using the Get(FilePath) function, also for display on certain screens. , which is a unique product/build identifier that I type in prior to binding. I would like to have these and other "overhead" items in a Master Information Table, separate from all user-related tables. I've determined that, since they're in an unrelated table, they h…

Within my FM database I have a table that imports text files via a script. Each file has multiple addresses, i.e. Name1, Address1, City1, State1, and Zip1 all the way to Name10, Address10, City10, State10 and Zip10. I want to create a table so that when this data is imported, it takes each address and creates its own record in a new table. It would also assign each address a unique ID based on the number of the address and the OrderID that is also provided. Any help would be greatly appreciated.

Anyone have an efficient way to return the value number of a value in a set of values? In other words, I have a set of values: sp56 sp30 sp25 sp100 and I want to know what value number "sp25" is in that set of values. I can think of a handful of ways to do this, but none of them are particularly efficient or elegant or simple. I feel like I am missing something so I thought I would pose the question to you fine developers. Anyone?

Filemaker seems to display linked images in container fields according to their print size (ala QuarkXpress) rather than pixel dimensions (ala photoshop & web browsers). This makes some low-resolution thumbnails unviewably small in filemaker if they have been generated without adjusting the dpi setting -- a common mistake that browsers mask. Is there a way to change filemaker's behaviour so that the dpi setting is ignored for screen display purposes?

Hello everybody. I'm trying to build a report from my Line Items table. This report is based on State. I'm using the Line Items table/layout to base my report on because I want to count the number of Customers sold to in that particular state. The report layout has the following Parts: Header, Sub-Summary, Trailing Grand Summary, Footer, and again is based from the Line Items table. I've placed my "customer_state" field in the Sub-Summary Part and the set break field properly to "customer_state". What I did was I tried creating a Summary field (in the Customers Table) that Counts the "customer_id" (running total, restart summary for each sorted group by "cu…

hello All I am trying to get the difference for the two Get flags: Get(FoundCount) and Get(TotalRecordCount) When I use them, even after a find operation returning 3 records they both give me the same number i.e. the total number of records in the table. What am I missing here? Thanks for any insight. TIA Rob

Hello All, Is there any way of using a calculation to 'spot the difference' between a field in one record and the same field in the previous record? I have a database where many records contain the same value in one field. I'm trying to highlight the row where that value changes. Effectively I want a field that can calculate itself as 'if field x this record not equal to field x in previous record, set something'.... but I can't figure out any way to do that as a calculation. Any ideas gratefully received! Thanks, Rob.

When I import new records, they seem to be grabbing existing serial numbers..and pushing the others down. How do I make it grab a unique serial number starting from the end of the list??

I get nothing on this when searching so either it can't be done, or it's so simple, it's a no-brainer. Can I have a report with a grand summary and put the results automatically into another field on another layout? This must be possible, yet I cannot find this in the manual or an example somewhere. The summary totals are just the points accumulated by racers over the season, but because there are so many classes for the racers, a simple total field is not how I want to manage the file. Thanks in advance for the help Russ

This may be convoluted but I'll "endeavour to persevere" in the problem description. The OS is WinXP. An FM3/4/5/6 database converted to FM8 with 12,000 records. Fields are simple - a container field and an id. Images are unfortunately stored via PASTE and REFERENCE. Do not appear to be any INSERTS. GetAsText on the container field gives me this: REFERENCE = image:Exploding_Moon.jpg image:/S:/Exploding_Moon.jpg PASTE = ? We are trying to get all in the REFERENCE storage mode. So the plan is to EXPORT FIELD CONTENTS via script, so we locate the "?" records and have a script that loops through the found set setting a dynamic export file na…

Is it possible to call a script from an auto enter calculation? Basically this is what I want to do If (get(PrivilegeSetName="Sales"; 1; (somehow call a script here?); It would be even better if I could do something like this: If (get(PrivilegeSetName)="Sales"; 1; perform a lookup on table::field; But I'm not sure if you can run a l can call a lookup from a autoenter calc... Thanks for any help. I seem to be coming up with some strange questions....

I need to use a lookup field to make a relationship that uses an indexable field. Is there a way to evaluate or dynamically lookup this field without forcing the user to relookup records. Upon data entry in the current table, upon entry of other fields from the other table, etc. This is a very frustrating aspect of the multiple tables now - getting information to each area without a lot of manual effort.

Help! I had a set of global text fields that were working fine and then I added a set of Global container fields and now neither of them will save their values when i close the databases. I tried deleted them all and making just one new text global and it still won't save. What happened?