Calculation Engine (Define Fields)

Hi, I have users typing in d/m/yyyy when all dates should be entered as dd/mm/yyyy. I understand I can alter the formatting to display as dd/mm/yyyy but when you enter the field, it reverts to displaying d/m/yyyy. The same with exporting. I know you can export as formatted, but for various reasons which I won't get into, I am unable to use this option. So, I need to be able to somehow insert a calculated result to alter the d/m/yyy to be dd/mm/yyyy. I'm trying to figure out using something like counting the characters left of the / and if only 1 character adding the zero but i'm not so offay with the functions so any help would be appreciated. t…

I'm stumpted and I'm afraid the answer is right in front of me. I have 2 databases. One is Students the other Repository which contains various activities (papers, travel, presentations). A paper can have more than one author. When I enter a new paper I want to be able to list all authors and later do a search by author to find all papers by that author. I thought a value list using the name field in Students to start but then I don't know if I should use a related field or a portal or another method. Thanks for any help.

Is there a way to put an MS Word doc in a container or any other field and get a word count?

I have these fields: ----------- Customer ID Name City State ------ I need the Customer ID to automatically populate with the first 3 letters of the name, first 3 letters of the city and the 2 state code(MT,ID,WA) so Walmart in Boise Idaho would show up as "WALBOIID" in the Customer ID after entered. And advice?

Description: Hi Has anyone made a drop down menu autopopulate from the contents of a folder? Is this possible with filemaker? And if it is can someone point me in the right direction?

CONTEXT: I'm setting up a graduate student records database and I'm adding a component that tracks interactions between the program coordinator and students, e.g., "I had a conversation with X about Y" the student is linked to a description of the conversation (and it is capable of linking multiple students for when they come in groups bearing torches). PROBLEM: I'd like to add fields which count the number of interactions a particular student has had in the last six months, semester, and year. I can't for the life of me figure out how do implement this.

Hi, I am trying to better understand indexing. Is there any written article or paper that would describe indexes? - comparison between "minimal" and "all" - "word index" versus "value index" (are word indexes only for text? can value index exists for a text field? date?) - what situation calls for one type over another - what type is best if used for the occasional "find" - what type is best for a field that is used in a relationship? - what type is best for dates, numerical, text, ... - what are things to watch out for when using "default language" other than English? - when you pick 'Minimal' and 'automatically create indexes' how do you know wh…

Good morning. First off I would like to tell everyone how much I appreciate this forum, this is my first post although I have been reading almost everything I could for a good while. I just started using Filemaker about 3 months ago or so, basically trying to satisfy the boss. I work for a construction company, trying to keep track of our projects in-house. I was wondering how I could make a field auto calculate the number of weeks from the project start date, we bill weekly. For example, if we start the project on this Thursday, 1/19...any work we do from now until next Wed, 1/25, to put an automatic "1". Any work from 1/26 to 2/1, put an auto…

Empty fields show as blank lines in addresses on letters. I know how to remove these in Access, which is by creating a field with IIf's and isnull's around the address fields. How do I do this in FileMaker?

When I insert a PDf file or Word document in a container field how can I click on this so that the file opens for me to view? Hope someone can help this starter to Filemaker. Thanks

I am new to Filemaker (from Access) and have run into a problem I just can't get a handle on. I'm hoping one of you fine folks can point me in he right direction. Extra details are at the bottom of the post. In my main table (Catalog), each record can have many images associated to it. The number of images can vary by record from 0 to, say, 10. I would like to have one image display on the Catalog layout and be able to advance through the images one at a time using previous/next buttons. I have created a layout with a portal to the images and "next/previous portal row buttons. Problem is, when I test this, the next/previous buttons only work if I have all the portal …

Sorry for the terrible subject line. I'm totally new to Filemaker, so bear with me if the terminology is a little incorrect. I'm having a great deal of difficulty figuring out the scripting aspect of the program. Here's what I want to do. I am making a database of plants. I created a layout with a number of fields, some text, the rest containers for images. I have 16 image fields, image1, image2, and so on. I want to display one image at a time for each record and have buttons to loop through the images so you can see them in detail. Every record doesn't have the same number of pictures. The way I am approaching this now is to have 17 different layouts, …

Hello, I am puzzled as to why this calculation will not fully work. It is a calc to format an address label. It is in fact taken from a file by Kevin Franks re:address formatting. It works, except for the If function I inserted into the calculation. Here is the calculation: Label: unstored, text Case (IsEmpty ( Organization ) ; "";Trim ( Organization ) & ¶ ) & Trim( First Name) & " " & Trim( Last Name ) & "¶" & Trim( Street Address ) & "¶" & Case( not IsEmpty( International_Addressing::city_line ); Trim(Evaluate( International_Addressing::city_line )); Trim( City ) & ", " & If (State =…

In FMP 7/8, pertaining to an auto-enter value in a field, what is the difference between selecting a calculated result and a looked up value? Don't they both result in a field entry that is changeable? Of course, I know that a field with a looked-up value is subject to relookup. But at the beginning, when a record is created, is there a difference in the value or the field?

Hello. I need help to set up a function or something similar, that would work as a "unique identifier" for a field. The "unique identifier" shall only let me know of a unique value if there are more than 3 caracters in the field. What I am looking for is almost the same as the built in "Unique value" function that is under the "Validation" tab. But if I choose that function, it will validate all of my input in my field. I.E. I got a field called "Dep_number" wich I can input numbers up to eight characters. I usually input two or eight chatacer numbers in this field. I don't want it to validate my two character inputs as unique, but I want in to va…

Hello all, I need to define a field so that on data entry you can only enter 13 digits an not more not less than that (only numbers). I found the MAX but no MIN. Thank you.

I have a customer db that has a status field in it. Currently a drop down value list of Warranty, Maintenance, and T&M. I also have a Warranty/Maintenance expiriation date field. I would like to have the status field automatically update based on the current date with the default value being T&M once the initial value has been entered via drop down I can do the basic calculation with the Case statement but is there a way to also allow the drop down so that when the customer is first entered you use the status field drop down and then at some time in the future base on the warranty expiraton date the field changes to T&M. Or is there a way to have a scri…

Guess it's a no go but can Filemaker handle 3,5 million records? 1 text field (max 30 characters), 2 number fields.

Hello everyone, is there any way when Sales Tax rates change to prevent the change from affecting older records? Say 1 year, the Sales Tax for a state is 5%, then one year later, the rate jumps to 6%, how would I keep the old invoice from changing 1 year later if the sales tax was calculated on the field level? Is there a better way to set this up? Thanks in advance, J

Hello everyone. Need convert numbert to text Ex. 1 to one. I Have FM 6.0 Thanks multiuser_modification_tracking.fp7.zip

Terribly simple question... where precisely do I put the "round" command in the "specify calculation" window. I have tried numerous ways... :(

Hi I have this problem: I have a filemaker solution on a Filemaker Server 8.1 (Mac OS X) with 12 users connecting through out the day. We normally create between 20 - 50 new records daily. What I have done is set up a layout so the users can insert a pdf file into a container field which shows a artwork miniature of the job they are working on. We have been using this solution since the beginning of November 05 and already it has grown in size to 880MB. I know this is because we are embedding the pdf into the solution so I would like to select the 'Store only a reference to the file' tick box to reduce the size. The problems I have are: 1. Were is the bes…

Secondary file has a field ("Picture") that once held path to image file. Later I respecfied the field (now ":Picture") to get new path from primary database file. Do I need to clean out the original path data from the secondary file, and, if so, how? Deleting the field with all its data would cause an enormous amount of labor to fix the problems spawned in other related files. Since the database is already sluggish (and when converted to FMP8 it's too slow to use), I thought I should clean out as much junk as possible. Thanks for any comments.

I have a table with 8 global fields. I increment the value of these fields via a script. I created this file on a local computer. When you would exit the file and re-open it, the global fields would retain their value, which is what i want. After moving it to the server and sharing the file, the global fields do not keep their current value after closing and re-opening the file. They revert to their original value. Why does this happen and is there something I can do to stop this behavior? Using FMP 7 and Server 7.

I'm trying to figure out how to make a report that will give me percentages on responses to a survey. I tried to browse through the existing topics but everything I saw was more advanced than this. I made a field with a value list -a checkbox set- with five possible responses. I want to make a report that shows the percentage of respondants for each answer. (People could pick more than one.) I tried making a calculation field using an IF function If ( FieldName = "postcard" ; 1; 0) which I would then use a count field to add up the number. I'm sure there is an easier way. But this doesn't work anyway, as it only gives me the records where they only selected…

is there any way to over ride a calculation field?

Well my project is coming right along and I thought "hey, I better take a look at this on a PC before I keep going!". Well now I kind of wish I didn't... The layouts are fine and all but here is a problem... and it is a major one for my database: There are two fields that aren't showing up. They are both containers: The first is just a container where images are dragged into. The second is what you fine folks helped me set up for displaying a 1 - 5 star rating gaphic. On my Mac they are great and work perfectly. However when I loaded my database up on a PC, both those two container fields are white boxes with text that reads something about: "In order…

Hi All I'm new to FM and this forum and I thank you for taking the time to read my post. I have two tables. Table 1 contains data for individual jobs on record. These records are categorised as either Completed or Remaining in a 'Status' field. Records a grouped together using a 'Project Ref' field. e.g. Record 1 Project Ref: 00001 Status: Completed Record 2 Project Ref: 00001 Status: Remaining Record 3 Project Ref: 00002 Status: Completed etc... Table 2 contains Project information such as location and contact details but I would also like to calculate the number of Completed and Remaining jobs for each Project fro…

Being the challenged FM user that I am... I can't seem to get a certain field definition calculation written - is someone willing to assist with "defining" the following?

I have data being imported from Excel (from many different sources) into a database...due to the way the excel template was originally set up, the name field is all one field...but within the database it needs to be broken down into fields by Title, First Name, Middle I. and Last Name. I'm in need of a calculation that can do this for me. Any help with this would be appreciated.

I want FieldB to autoenter "n/a" whenever FieldA changes, regardless of what it changes to. Thought I'd do this with Evaluate. So I gave FieldB the calculation Evaluate("n/a";[FieldA]) The result I get is usually "?" in FieldB. Though I seem to recall getting a "0" once and a "1" once. So... I'm obviously not clear on the Evaluate concept. Advice?

I am working on a database that will send meeting requests in the icalendar format. I have had great success, mostly, but i am having problems with the DESCRIPTION part of the ical. The ical standards state that the DESCRIPTION must only be 75 characters long at a time, meaning i need a return after 75 bytes of data, wether it be spaces, numbers whatever. Is it possible to have filemaker do this? Meaning count 75 characters insert the carriage return, cout 75 more, etc... Any help would be greatly appreciated, I'm beating my head against a wall here. TIA Bob

Is there a way to do this? Thanks!

Hi all, please forgive what may seem a stupid question. I have created a field incrementing by one, but if i delete a file it leaves a gap rather than moving all the files back one. Is there a way to move automatically files into the gap? Thanks in advance for any comments

I have added a new text field which has an auto-calculation option set, but it only updates on records which have been altered since the auto-calc field was added. How do I force it to update/recalculate the contents in this field only, so it will recalculate for records contents which were present before this new field was created and haven't yet been modified again? On a calculation field, this is easy, but I can't see how to do it on a normal field with an auto-calculation option set.

Hi, I used FM 6 and there was an option in the calculation field that says "today". That was very useful to display the actual date and to calculate for example days since last exam, etc. How can I do this in FM7. There is no "Today" option! Is there another way? Thanks Rodrigo, from Chile.

We succeeded in getting our database online and now the two fields that deal with conditional values are not working properly. Basically this is our dilemma. Neither conditional value field display their drop-down lists on the online version and yet they both work fine on the server based database. We have two fields with drop down menus: one with "Workshop Years" and the other with "Workshop Titles" that correspond to each other - these are the two conditional value fields. Is the web version of our database not able to display conditional value fields? Is there a way around this dilemma? Any help would be appreciated. Nemesis

I work for a graphic design firm and I've recently taken over the administration of our "Works in Progress" database, which includes project info, recording billable hours, invoicing, etc. Up until now we've been invoicing for total hours spent, but now we would like to designate on the invoice whether the hours were 'administrative' or 'design'. Each project has a unique serial number, and when hours are entered under that serial they are designated either 'administrative' or 'design'. I can do a 'find' and in our Time Log layout to get these numbers, but what i would like is to have 2 calculation fields on the Invoice layout that automatically calculate these …

How do I insert special characters such as the copyright symbol, something similar to @, but with the character c inside? AS well as the registered symbol?

How do I create a button to open a PDF File? "C:PDF FormsHOS.PDF"

Does anyone know of a way to count the characters in a field as you type them? I am only able to get the counter to update after I exit the field. I would like to have the counter update as you type. Thanks, Phil

Hello All, Ok here is the situation. I have an invoicing system that works great. But I need a validation system for our fulfillment department. This would consist of orders being sent to our warehouse and orders being scanned into the system for validation purposes. On one side of their screen I would like what should be on the invoice and on the other they would scan each item and after all of the items are scanned it would be validated and allow them to proceed to the next invoice. I have gotten as far as creating the portal on the left side of what should be on the invoice, but on the right side I am clueless as where to start. I have a barcode sca…

Thanks for all the help. This is a great forums. When I scan a part number it sometimes come up with 1Pxxxxxxxxx, the rest of characters real part number. The real part number can have 8 - 10 characters. How can I remove the first 2 characters (1P) if they exixt? Again Thanks!

Is there a way that when I am writing a letter and I want the date on file inserted into this letter that it can show up as the latter rather than the former?

Hi I want to generate a value list in one layout BASED on a found set from a different layout I have two tables, each with a layout: tblOperations [layoutOperations] tblSurgeons [layoutSurgeons] I want to generate a value list in layoutOperations BASED on a found set from tblSurgeons:Surgeon = "Mr" any help would be greatly appreciated! tim tblSurgeons surgeon___title John______Mr Sally______Professor Andrew____Mr

In a report, is there a way to have a field that is set to show 12/31/05 turn up as "December" so in reports I can sort by just month? Thanks!

I am having trouble with the following: Lookup based on Sell price with a relationship between 2 tables on Model, A & B fields. Here is an example of some data Model A B Sell Price SRAC 6 12 $4.42 SRAC 8 8 $4.21 SRAC 8 12 $4.76 When I enter: Model A B Sell Price SRAC 7 12 I get Sell Price = $4.21 which is how the 'Copy Next Higher value' is working. I would prefer to get the result of $4.76 so in theory the system would first match on Model, then on A, then on B. If B wasn't matched it would then take the next higher value of B. Can this be done?

I have the old Scriptology book that shows a technique for being able to show page numbers like: Page 1 of 3 Page 2 of 3 Page 3 of 3. The technique works, but is kind of clunky. That book was also written with FMP 5 or 6 in mind. Has FileMaker come up with a way of making this easier? Any help would be appreciated. Thanks, Steve

I would like to create a staement that would read like If(X>100 or Y >100) XXXX;YYYY I am having problems withe the 'or'. I guess this is not used in FM. How would I get this statement to go? Thanks

I am overlaying a transparent gif image over a jpg images. I am trying to save the result image as a jpg that can be used on our website. I am trying to figure out the way to do this and get the best possible webimage. I have 1,000's of images to create, so I need to automate as much as possible. I have found that I can saveas a pdf, then use photoshop to convert it to a jpg image. The graphic does not turn out to great through. Any help? Thanks

ok here is what im doing. Im working on a datebase that is for entering types of vehicles. there is a year,, no problem there is a make.. again no problem but i want the model field to only have the certain makes available so say i type in chevy i only want chevy models availble in the model field or if i type in dodge i only want to be able to pick from dodges. Any Ideas?

I'm using TextColor to Hilite some words in lines. The problem is it shows them with a space-like distance from their position. In the first example i'm replace "ebook" and in the second "is". as you can see it doesn't look good. I tried to change fonts and I have the latest update (FMD 7.03). Any suggestions to what may cause this problem?

Greetings and happy new year... I have a field that the data is populated through a checkbox. Could be 2 to 4 values checked. How can I split those entries into seperate fields? Example: The field "Skill" contains: Run, Jump, Swim I want field Skill01 to contain Run field Skill02 to contain Jump, etc.

Hello everyone, My issue seems pretty simple. The issue is, I set a variable to pick up a "PK" unique auto-entered number. This number is 7 digits long. The number format is 0000001, 0000002 etc. In a script I set a variable "my_num" to that "PK" so "my_num" should equal 0000001. Then I set a field in another table to that variable and the number that shows up is 1, 2 etc. The zeros are discarded. Is there any way to preserve these zeros?? Thanks in advance, J

Hi: I'm setting up a relatively simple database to keep track of particular codes assigned to specific people. All that is necessary is the usual contact information plus a list of these codes (5 or 6 alphanumeric characters). Each contact may have tens to thousands of these unique codes assigned to them, usually in blocks of 5, 25, 50 or 100. For example, Jon Smith may be assigned the following code ranges: AA100-AA124, ABC150-ABC199, and 200GH-249GH. Once entered, I will need to be able to run a search for codes within those ranges, like AA115, ABC165, or 215GH and pull up Jon Smith's record. Does this make sense? It seems like it should be a relatively simple…

Hi, I'm new to this group and I was wondering if there is a way in FM 7 to do this: See we use FM for our daily schedule of jobs we have to do (prepress department). One of the columns in the schedule is for "Technician". Whenever you click on that field for a given job, a list pops up of initials of all of our technicians. Each set of initials is in black. My question is, is there a way to have a default color assigned to each pair of these initials or are we stuck using the default of black. Thanks in advance!

how can i add some fields content in the validation rule's error message when i define fields.

Hello FM lovers, I am looking for a way to see the contents of a OS X folder via a container box. Is this possible? If possible, is it possible to open the files by clicking on them via FM ? Thanks

I have 2 fields. One for tractor fuel, and one for reefer fuel. I want neither to do the calculation unless the box in "calculate reefer fuel" is check as Yes. The same for "calculate tractor fuel. But I can't get this to work. (Calculate Tractor Fuel = "Yes") * Sum ( Reefer Fuel Expense By Trip::Total Reefer Cost By Trip ) If any one can help I would appreciate it. Thanks!

Hi I would like to substrack two dates and get the result in number. Something like 04/01/2006 - 01/01/2006 = 4 Thanks

I have a calculation field with a result of container. The name is entered by the user and then the related image is found. Calc: Path & RightWords ( Copy1 ; 1 ) & " " & LeftWords ( Copy1 ; 1 ) & ".jpg" It works fine when there are just two words in a name. i.e. "John Doe" in Copy2 field will bring in image "Doe John.jpg" But how should I allow for the following names: "John Cooper-Smith" image name: Cooper-Smith John "Jean-Guy Deveraux" image name: "Deveraux Jean-Guy" "Ann Marie Smith" image name: "Smith Ann Marie" Thanks in advance for any help

I have a table for company and I want to allow only one company to be entered therfore, only one record to be made. I started with making a serial field and trying to make a calculation that makes it unique and allowing only one number. But that doesn't work. How can you allow a number of records to be made in a table?

I have a field set as a pop-up list with two options for billing people: "Hourly" and "Flat Fee". Then I have a number field called "Fees" in another table. What I would like to happen is if I choose "Hourly" as the billing type, then the Fees field is a calculation of an HourlyRate * NumberOfHours (each of those is specified in other fields). If I choose "Flat Fee" for the billing type, I would like to be able to enter whatever amount I want in the "Fees" field. So, if the billing type is "Hourly" the Fees field need to be a calculation and if it is "Flat Fee" it needs to be a regular field. Is this possible? Thanks for your time.

How do I fet a filter to work for phone numbers? IE: 555-555-1212 would convert to (555) 555-1212? I see Let(phone = filter(theField;"0123456789");"(" & left(phone;3) & ")" & middle(phone;4;3) & "-" & middle(phone;7;4)) But do not know how to get it to work. Thanks

i have 12 feilds that display the a numerical limit for work that can be done that day. each day has a default value pulled from another table that contains 6 globals that define the default for each day of the week minus sunday. i had the 12 fields to go through this script to pull the correct default value: If ( DayOfWeek ( start_date ) = 2 ; capacities::roofmon ; If ( DayOfWeek ( start_date ) = 3 ; capacities::roofteus ; If ( DayOfWeek ( start_date ) = 4 ; capacities::roofwed ; If ( DayOfWeek ( start_date ) = 5 ; capacities::roofthurs ; If ( DayOfWeek ( start_date ) = 6 ; capacities::rooffri ; If ( DayOfWeek ( start_date ) = 7 ; capacities::roofsat ; "" ) ) ) ) ) …

Hi All, I have a large edit box field, multi line, with a vertical scroll bar, when I set behaviors to prevent access in browse and find mode the scroll bar does not function. Any one know a way around this? Thanks in advance

Ok, so I wanted to get fancy and added a TimeStamp field to my email activity table. I need to remember that "If it ain't broke....." Anyway, I am now getting this error message when I attempt to put content in the "Subject" field: "This field cannot be modified until "TimeStamp" is given a valid value. I have looked at "TimeStamp" field to make sure I have set it up properly and all seems ok. (Type = Time;indexed,creation time;can't modify;time of day) Can anyone give me an idea of what's wrong? Thanks.

I know this is going to sound silly, but My brain has turned to mush. I'm building a project manager in one of my solutions. Each action item has a field that allows the user to plug in the number of minutes that action item will require. I'm building another field that will calculate the sum of all of these action items and give me the total time (in hours and minutes) these action items will require. I will not bore you with the details, but lets just say that this small calc is a little pebble in my shoe that has finally demanded my attention. I'm not sure what I'm doing wrong but I can't get the field to display the correct hours:minutes properly. I'm sure I…

I have a calculated field which I want to be the field 'Title' with all occurrences of some characters (spaces, apostrophes, commas etc.) removed. This has worked fine when only substituting one character but I cannot make it work when I want to remove more than one character. I have tried: Lower ( Substitute ( LeftWords( Title ; 3 ) ; [" ";"_"] ; ["'";""] )) >ERROR: 'Field cannot be found' and nesting: Lower( Substitute ( Substitute( LeftWords( Title , 3 ) , "_" , "" ) ) , "'" , "" ) > ERROR 'Too few seperators' Neither works. What am I doing wrong? Thanks for your help

Hello, Sorry if this is in the wrong section. I am creating a membership database, in which i want to have a scratchpad/notes area for each member. The notes area needs to be accessable via the main screen for the appropriate member. Within the notes screen, i would like to have a drop down menu showing all the reasons why the note is being created (most of the items on the dropdown would be injuries). These are called 'Event Type Codes'. Obviously, it would have the ability for more than one note per member, and as more notes are added - an 'overview' list of previous notes to be created. (showing - Event Type Code, Date, part of any text entere…

What would be the best way to have a field get populated by a search option. In other words I have three fields that you can search by, Serial Number, LastName, and FirstName. If a person searches by Serial Number I want the information to come up on another layout giving all the information of that person. Trying to figure out the best way to start.

I haven't been able to figure out the best way to create a database with one container field in a portal with different numbers of photos per record. One record might have 1 related photo, another might have 5 or more. How do I do this? I want just want only one photo to show at a time, and click on an arrow to go to the next photo. I'm using FMP 6, and am probably only at a Novice level of experience. Thanks, Larry

I have some time fields formatted to display as HH:MM 24 hour. If you key in something like "3:00 PM" it correctly changes to "15:00" when you exit the field, but if you enter that field again, you see "3:00 PM." Similarly, if you concatinate data from that field with other stuff in a text field, you don't get "15:00" you 3:00 PM. I'd like to do an auto-enter replace calculation that changes any AM/PM stuff folks key in to actual 24hr times. ... I'd also love to never see any seconds display in the field ever under any circumstances... but I don't think that's possible as long as it's a "time" field.

Hi All, this has beeng bugging me for a while...and I've desperately been searching for a way to solve this, but have had no luck so far. My problem is this, I have a database that organizes student waiting for courses that are currently full. A student waiting for a course is marked in the status field as being Idle. In the even that someone drops the course, and the student waiting for the course gets it, they have Granted entered into their status field. When users open the database, I would like to show a layout summarizing the number of idle, granted AND red-flagged, and denied (the two other possibilities in the status field. The layout would read s…

I have 10 repeating fields labeled "invoice match", these all correspond with 10 repeating fields labeled "product id". In the invoice match field there is a formula which should return "Inv Match" when the statement is TRUE. Individually they work fine, each repeating field is corresponding to the right product id. However, I need to be able to do a find that will find any record that has any product id with its corresponding Inv Match True. I did one field with the simple calculation of, if(Invoice Match ="","","Invoice Pending") , but that is only returning the results from the first product ID, it does not look at the other 9 repeating fields. I need it to retu…

I want to be able to display something like this 1 of 2 on page one and 2 of 2 on page two I have orders that have several parts. I want to not only be able to count how many parts an order has "Count ( OrdersPart::kp_OrderPartID )" but when I am looking at a part in the layout, I want to know what part I am looking at...hense 1 of 2 Right now when I do a Get(RecordNumber) I get something like this 1 of 2 on page one 2 of 2 on page two 3 of 1 on page three The reason it is doing this is because I am looking up orders by Customer(this is my found set).Customers have more than one order...with more than one order part. Any idea how I could…

I WANA TO USE THE 2 FIELDS VALUE OF 3 PREVIOUSE RECORD IN A FORMUL OF CALCULATON FIELD IN A RECORD OF THE SAME TABLE. WHAT DO I MUST DO (IN FORMULE OF CALCULATION)?

I set-up a database using 4 container fields that hold icons. Each icon has been formatted using a navigation scripts (go to layout...). Each container holds 1 icon. The containers are designed to be used as navigational tabs and the set of 4 fields apears at the top of each of 4 layouts in the DB. Every day or 2 the data (icons) in all of the container fields is(deleted)simultaneously. This link concept is based on the FM Starter Kit DB "Praesto Jr. This scheme seems to work fine in that solution. Does anyone know of a way to prevent the deletion?

Is there a way to export fields and definitions to another FMP database? I am working with a large flat file and converting it to about 6 tables. I would like to use the fields, types and defs in a format similar to what 8 will provide at HTML, but want it in a db. It will help to manage the mapping of the data from the flat file to table. Thanks

I have a project that I am working on for placing Purchase orders. One Table is named Purchase Orders, another is Item Master, and the third is Vendor master. On the Purchase Order Table the Product Id (product being ordered) is a repeating (10 times)field, as is the product description, Qty, unit price, and extended price. In the Item Master, each product is its own record with its pricing info, quantity currently in inventory, vendor product is bought from,etc. I also have a field labeled "On Order." Item Master and Purchase Order tables are related by the Product ID. What I would like to do is get the total quantity of a particular product on order in the P…

I have a database with records of clients and want to do a report calculating different fields(age,gender,custody etc) I am a newbie and don't know where to begin to summarize these fields Any help???

Sorry if this question is inane...i'm a total beginner and a little knowledge does seem a dangerous thing in my case. i'm setting up a dbase of contacts to use as mailing list for a indie record company. i need to copy all the entries in the found set of email addresses, but all i can manage is one record (not all)...any help?

How does FM7/8 store images in container fields (under Mac OS X)? I have the feeling that if insert a JPEG, it converts it to some other lossless format internally (PNG?). I also remember reading a few months ago that you could get different results depending on whether you inserted the picture via drag & drop, cut & paste, or the insert picture command. Any advice?

Hello All - Does anyone here know why I would be getting the called for result in instances where there is NO accepted date? (Perhaps relative only to last section of case? Not sure.) Many thanks for your consideration. JW Case( ArchiveOverride = 1, "Archived", ProjectCategoryOverride <> "", ProjectCategoryOverride, CStatus::Accepted Date <> "", "Post CCA", "Pre CCA", CStatus::Accepted Date <> "" and AsBsRecdinMFPRUfromDelinDate <> "" and ACStatusNewRev = "On File" and DRSStatusNewRev = "On File", "Archived", CStatus::Accepted Date <> "" and AsBsRecdinMFPRUfromDelinDate <> "" and (ACStatusNewRev = "Pendin…

In a solution I'm developing, I need to set a "key" field; the key is two characters long, and will be unique to each of my customers and vendors. My business is small enough that I can be fairly certain of this, but it would be nice to have a calculation which can be changed if need be. Anyway; my current criteria are these: 1) Customer/Vendor name will be one or two words; two examples are: SportCrafters and Valley Bikes 2) The key field (Company Key) should be the first two UPPER-CASE letters in the company name (SportCrafters = SC; Valley Bikes = VB) 3) Not all of the companies' names will have two or more upper-case letters, so a manual-entry …

New to FM. I am sorry to impose, could you help me with something? I have a field in a layout that i want to sum over all records and get the result in a field on another layout. I tried the sum func. but it didn't work? Please help.

Another query from a novice that I'm sure is simple to someone out there, but I can't work it out... I want to create an alphanumeric ID field of the form AAA000, to have a unique ID field for a company. A user would have to enter 3 letters then 3 numbers, taking the first 3 letters of a company's name, then putting the lowest 3 digit number afterwards. For example: Thamesdown Printing would be entered as THA001. If a user then wanted to create a record for a company called Thamesdown Marketing, they need to enter THA002. If they try to enter THA001 for this second company, I need Filemaker to refuse to accept it. Once a unique alphanumeric has been entered,…

i need a calc of some sort that defines a feild to current date (i have that part) but updates at midnight...or will i be forced to have a refresh script step

Hi again, As long as I'm admitting my serious lack of knowledge about certain aspects of FileMaker I'll ask another question that I really should already know the answer to but haven't found the time to really understand. Whenever I define a calculation field there is option under the storage options tab that allows me to choose "Do not store calculation results -- recalculate when needed". I really don't understand when to check that box and when to leave it alone. On everything I have done so far it doesn't seem to matter whether I check the box or not. FileMaker displays the correct results. Can somebody tell me under what conditions I should check th…

i have more than 52,000 records. Everytime i open the file its automaticly sorting the record first. it's take too long to finished. i access the file using remote access with 384 upload broadband. how to make a default, when i open the file the sorting dont works. faster for me

I am building a database to manage tasks. Each time a task is generated, a record is created and the task is assigned to a worker. I have a field [COUNT] that counts how many tasks have been assigned to each worker. I would like to figure out what percentage of all the tasks each worker is responsible for. The calculation that comes to mind is [COUNT] / [TOTAL RECORD QTY]. I cannot, however, figure out how to post the total quantity of records in my database. When I try GET(Recordnumber) it just posts the number of records in a Found Set, rather than the number of records in the whole database. Perhaps I am doing this altogether wrong, and…

Hi, I'm sure this is really simple, but I can't find anything in the archives and the help is a bit obscure. : I want to clear some text from a field (which I'm using for 'keywording'). I have no trouble clearing the text string, with substitute, but I want it to only clear the string if it is a whole word. The text field is used for a relationship and it's values are separated with returns. So ... If I have : test test2 test3 and I want to clear "test" but "test2" and "test3" should remain untouched ... what function do I use? Also ... while I'm at it ... I can get the words to move up in the text field by replacing any instance o…

Hi, I have a DB that has alot of Photos in them. Most of them are jpegs in a container field. This has made the file size of the DB rather large and slow. I know that if I convert the jpegs to vector graphics, the file size would be smaller, but I don't know how to display a vector graphic in a container field. Can this be done and if so, how? If it can't be done, are there other options that will reduce the size of these photos and therefore the file size of the DB? Thanks in advance

Hi I wanted to create a series of dates starting at a particular date then continuing at weekly intervals after. I thought I could use a repeating field. Is it possible to define each field as a calculation based on the previous field (ie previous field plus 7). Maybe there is a better way, but it needs to be dynamic and changes depending on the initial date. This is the first step in making a project task based timeline database. I'm hoping i can use the same theory for the actual task duration and display. Thanks for any help!!

What does the comment "Indexed" mean in the Define Database comments column?

Description: I'm a Renovation Professionnal; I have different Docket Number in a file; and I have a lot of Picture (from Windows) and they are sorted in some file, and the name of those file is the correspondant Docket Number. I want to import automaticaly those picture in their file in FileMaker?!?!? Can you help me? Thank's

I have a database that assigns tasks to workers. Field 1 = TASK DESCRIPTION Field 2 = WORKER NAME I would like to generate a list of how many tasks have been assigned to each worker and I would like to have this list sorted in descending order, according to who has the greatest number of tasks. As tasks are added and assigned, I would like this list to dynamically refresh itself. Does anybody have a suggestion how to do this? Thanks, Jarvis

Hi there, How can I get the number of related records within a calculation field? Thanks. -Chris

I want to have a field that is enterable in browse mode but prevents the user from hitting the Enter or Return key and adding a carriage-return inside the field. I also want this field to start the Find immediately when in Find mode and you hit Enter or Return. It seems you can't do this? If you set it to "Go to next object using Tab Key + Return Key + Enter Key" then the field won't accept Returns while in Browse mode (which is good) but then in Find mode, hitting Return doesn't start the search either (which is bad). Any workarounds?

Another part of my database is capturing the styles of each string of text. But each string can have several atributes: "bold, italic, underline, etc" For now I have captured each into its own field in the table that holds each string as a record. I have anticipated that if I get a multiple style, such as {bold, italic} that I can pull an "exception" from another table that would pair up with its font into the calculated formatted output. If record 1 has "Courier" and "bold", "italic" I would want the font used to be "Courierbolditalic". But I'm having trouble wrapping my head around how that would happen. I had thought that I would combine the st…