Calculation Engine (Define Fields)

I hope there's someone out there who can assist with this. Keeping it simple, I have two related files; Projects - primary key = Project ID and Deliverables - foreign key = Project ID. There is a third unrelated file that will import records from Deliverables, the unique ID being Project ID & "." & Suffix (e.g. 12345.2). It's up to the user to enter the suffix via a portal in Projects, so to prevent duplicates, I created a Calculation field in Deliverables to concatenate the Project ID & "." & Suffix. I was disappointed to discover that there isn't an option to make the result unique, which is a problem. I've tried a variety of workarounds without auc…

I have a date field, usually have to input like xx:xx in 24 hours format, can I change the input ways to xxxx in 24 hours format then system can auto turns to xx:xxAM or xx:xxPM? Thanks

I am trying to work with an array of percentile values. The values are dependent upon BMI (Body Wt. Index) and age in half year increments. I attempted to work with the case function: If ( Gender = "M" and Age ≥ 4 and Age< 4.5; Case ( BMI ≥ 14.1 and BMI < 14.3; "5-10" ; BMI ≥ 14.3 and BMI < 14.8; "10-25" ; BMI ≥ 14.8 and BMI < 15.7; "25-50" ; BMI ≥ 15.7 and BMI < 16.4; "50-75" ; BMI ≥ 16.4 and BMI < 16.9; "75-85" ; BMI ≥ 16.9 and BMI < 17.3; "85-90" ; BMI ≥ 17.3 and BMI < 17.8; "90-95" ; This works just fine, but I need to set up many more "cases" in order to generate percentile values when "age" and "Gender" are diff…

Please help me, I have a problem with calculation I want to use a formula which do some simply calculation,the functions as below, when sales amount is over $1500, there will have 5 dollars extra per hour, and once have $500(per day) Sales amount extra, will have extra 5 dollars until the sales amount reach 5000, then there will have 40 dollars extra per hour and will count extra 2 hours. Everything seens fine but I have found a very serious problem, FM7 will take the sales amount 2,20,200,20000 as 2000, 9,90,900,90000 as more then 5000, I am very confuse, how should I write the calculation script, please help me... I need to finish the database by this weekend!…

Hello, I was wondering if someone can help me out with this. basically i want to track when a specific field got modified. i have field Status which is drop down and i want to track when a it get change from one status to another. I just want to track it using the date. any help would be appreciate it. thanks victor

I'm sure that I am overlooking this. I have a container field with an image for each record. Is there a way to have another field with the filename of the image in the container field? If not are there any suggestions for something similar?

I see that someone else has posted a similar question recently with what seems to be a discouraging answer. Surely it must be possible to do this?? I’m trying to work out how to automatically enter an image’s file name into a text field when the image is imported as a link into a container field, “Image”. FMP can do this when using its import function, but that rigmarole isn’t well-suited to adding individual images sporadically. I’ve tried setting up a calulation field using GetAsText(Image) which returns the following structure: size:640,424 image:folder/folder/MD_006162.jpg imagewin:/D:/folder/folder/folder/MD_006162.jpg I then tried using Righ…

I recently was having trouble with the relationships in my tables. In fm6 all the tables were separate, now in fm7 they can all be in one file. (I am told this is why the relationships are not working correctly)OK so how do I move all of my tables into one file? The purpose of the 8 tables are to create an invoice from data entry. I have layouts in my Line Item table, will I have to recreate everything from scratch? I did try to add a table to test, but after I created the table and fields I can't figure out how to look at the table I just created to add records? I can only see the table that I created this 2nd table in.And which table should I use as the primary Invoice …

Hi, First, I'm really not an expert with Filemaker and I'm not familiar with this forum. Hence, I'm not sure that this is the right place to post... Here is my problem and I would highly appreciate your input: I want to build a database for inventory and management of cells that are stored in liquid nitrogen. They are in tubes that are placed in kinds of drawers (triangular ones). In one tank, we have 6 stacks of 6 drawers, each drawer containing 60 tubes. At first glance, my problem seems easy and each entry of My Db could contain the coordinate of each tube: Container-Stack-Drawer-Position (in the triangle) However, the triangular shape of the drawe…

Please, does someone know how to do this? I've been trying since October to figure out how to do this and I can't. We have a folder with over 11,000 files in it. They are broken down into 10 folders. Each file is a pdf, which is in turn named after the record ID in FM 6 that the file corresponds with. I need to find a way to put this file in a container and when one of our employes clicks on the container they need to be able to download it from it's location (our main computer running FM server) to their desktop. Does anyone know how to do this?

I'm importing jpg images from various stock photo CD's, I have a Photographer field that should list the stock house & CD name: Photographer: Getty Images/Outdoor Adventure How do I specify to auto fill this info with each CD import? Each CD will have a different stock house & CD name. I've researched metadata import but this goes beyond my skill level and only the stock house info (not the CD name) is listed in the jpg metadata

2 questions: 1. how do I create a check box in File Maker Pro 6.0 I need a simple X in a box for if they want a service or leave it blank if they do not need this service. 2. I have a Customer field that links to another data base (Customer Data base). When I populate the Customer field in the Job Data Base-- I need info from the Customer data base (ie. Account number, phone, email and address) to populate the approprate fields in the Job Data Base. Sounds easy... I can't figure out how to acomplish this. Please help our database file has been deleated ... we lost all our archives so the sooner we are up and running the better. I have to re-enter all our f…

I have two timestamp fields and need to find out the number of days between them. You guys have been great answering all my questions. Thanks again. Jean

I am trying to create a laboratory table. I have two databases. One is patients including patient name, patientid etc. The second is individual lab values. Each entry has patientid, date, test and result. Example: Patient John Smith id=100 Labs: id-100 8/9/05 sodium 140 id-100 8/9/05 potassium 4 id-100 8/8/05 sodium 138 id 100 8/8/05 chloride 105 They are linked by id# What I want to do is to make a table for each patient with columns of test and rows of dates so the top would have sodium, potassium, chloride, etc The rows would be today, today-1, today-2, etc Ideally it would go back as far as you could scroll down.…

So we've got a photo database (designed from the photo template). We've got a Filemaker server computer, then we've got a Mac office server, where the photos are residing on a shared drive. All the images are being referenced through thumbnails. Basically, one computer may react differently to the database, depending on what user is logged in. User A may log-in and be able to "see" the referenced picture files, and be able to flip through them very fast. . But User B may log in and "see" the files, but the database runs soooo slow...it takes up to 15 seconds to flip from picture to picture. Any help or assistance with this would be greatly appreciated. Even our…

My problem is there are at least 50 - 75 records that are not being counted in one of my calculations. My calculation is to count each RecordID number (all unique and auto-entered) but for some reason, FMP overlooks these specific records. This calculation works for all of my other inventory items. Did I enter them incorrectly?

Newbie here... is there anyway to get FileMaker to support an increment function that relies on the date? I want to have my invoice numbers appear as 081005001,002,003...011,012, etc. (DATE&Increment) When defining the field options I cannot get the serial function to work in conjunction with other types of options. Thanks All!

I'm designing a database for ordering wearables (such a t-shirts, jackets, fleece, etc), and am having difficulty in organizing a series of relationships (and maybe calucations) to handle pulling an "appropriate" unit price for each line item. Problem is, each line item unit price is variable, depending on the product itself (a t-shirt versus a polo, for example), it's color (some colors are more expensive than others), and the total number of garments purchased (i.e., a sum of ALL line items). Moreover, the unit price is affected by how the garment is decorated. Separate pricing exists for screen printing versus embroidery. Within the screen printing variable, a ga…

When importing multiple images, I need two fields to auto enter serial #'s (ID# and Image#) The ID#'s import in the correct sequential order but the Image#'s do not. The field data looks like this: ID# 1265 Image# P01265C1ADT The serial # for the Image field is updating the wrong #, like this: P01265C1ADT P01265C2ADT P01265C3ADT I need it to update like this (to match the ID#) P01265C1ADT P01266C1ADT P01267C1ADT I do not have the option to rename the image field content (these images have already been archived under the current naming format) Is there a calculation that will specify which number set to update? (not C1, C2, C3…

In Invoices or LineItems, instead of creating separate calcs (or Auto-Enter Replace) of Day Of Week, Week Of Year, Month, Caledar Year, Fiscal Year, etc., I think I can use ONE multikey which will fit all my needs. I need these date calcs for relationships (dynamic columnar portals). Can I fine-tune this text calc please? // Date style multiline Let ( [ d = Date ( Month ( ShipDate ) ; Day ( ShipDate ) ; Year ( ShipDate ) ) ; m = Month ( d ) ; y = Year ( d ) ] ; DayName ( d ) & ¶ & WeekOfYear ( d ) & ¶ & MonthName ( d ) & ¶ & y & ¶ & Right ( y - ( m < 10 ) ; 2 ) & "-" & Right ( y + 1 ; 2 ) &amp…

Is there a way under the "define database" option to change multiple field types at once. I want to change around 30 text fields to Numeric only fields. Ive tired selecting multiple fields by holding down shift, but it will not let me change their "field type" options. Anyone know of another way?

I am importing ssn from an outside database. They left the ssn as a number not text and therefore 0xxxxxxxx becomes xxxxxxxx (1 number short)(there are no dashes in the data output). When I import this I want to add a zero if the length is <9. If (Length(ssn)<9;ssn="0"& ssn) Do I place this under validation or autoenter. I also need help with my syntax. thanks

I exported an old FM database to an fp7 file, then imported into a new fp7 database. I have two fields that must match but are not exactly the same, ID# and Image#, example: ID#1 Image #P0001CBS ID#2 Image #P0002CBS ID#3 Image #P0003CBS The old database skipped from record 861 to 864 (there is no 862 or 863) when I imported the data into the new file the ID# and Image# no longer match, i.e. ID#862 now features image#P0864CBS and so on... Is there a way to re-number and specify increments (starting at record 862) without re-numbering the entire database?

I have several calculation fields that are pulling information (text) from related records in another file and combining/formating it so that we can export it to another program. My problem is that although the fields worked when I created them, only some of them are working now. I have checked the storage settings and it is not storing the calculation(infact I can't change that) I have gone back to test the calculations and there don't seem to be any problems, so now I am stuck. Any suggestions as to why these fields would be blank?

I have a calculated average field that averages several fields in a record; the calculation returns a number with two decimal spaces ( 3.55, 4.76,etc). I would like to set ranges that would return a letter grade (10-9= A, 8-8.9= B, etc. ) into another field. Any ideas? I will be looking through resources and will post if I find answer. Thanks, Jack J

Hello, can anyone tell me how to make a scolling window in a layout. I have an invoice layout but all my item fields wont fit on the layout and I'd like to view them in a scrolling window rather than increase the layout size. I'm new to FileMaker but I've seen what I want to achieve in Sage software. Thanks very much.[color:black]

I've created 2 calculations to handle an interface issue and I was wondering if there was a way of "combining" the 2 calcs into 1. Here's the scenario: In a solution I've created, a user sets up pricing structure of items based on quantities sold. Quantities 1-10 might cost $1.00/ea., quantities 11-25 might cost $.95/ea., an so on, all the way up to the last quantity break. I've created 2 calculations for the interface. One calc shows the value for the start of the next quantity range, along with some text. The other calc deals with the last qty range by returning the value of the start of that range, along with some text. Take a look at the attached example and…

People in some industries routinely refer to number of thousands in terms of "K". In other words, 1K is the same as 1,000, 3.6K is the same as 3,600, etc. I've written an auto-enter calc in a number field to handle the conversion of the number in terms of "K" to the real number, i.e. a user enters "3.6K" in the field and the auto-enter calc changes it to "3,600". Here's where the challenge comes in...I'd like the field to initially behave as a lookup from a related field, and then, if the user wishes to change the looked up value, I'd like the user to be able to enter values in terms of "K" and then have the auto-enter calc convert it. Is this possible??? Wow…

I'm not sure where to post this question so I thought I would start here. I have a columnar type layout that displays a list of work orders for my cabinet shop. The problem we are having is that it is not so obvious which record is the active one. Is there a way of colorcoding the active field or record so that it jumps out at you on the screen? Thanks for any insight! Jarvis

I'm trying to design a database that displays images in container fields at specific magnifications that are based on calculations (e.g., 87% or 124% of original size). I considered using the script step that sets the zoom level, but it only lets you choose from a few preset values. I also thought of changing the size of the container field in the layout, as this changes the size of the displayed image. However, I don't know of any way to do this dynamically. Any thoughts or suggestions? Thanks.

i need to be able to merge related data from a varible number of records into one related field the data i have looks like this record # --- Field=ID #---Field=data 1 001 AA 2 001 BA 3 001 FD 4 002 GK 5 002 VX etc for 67,000 records total what i need in the end is record # --- Field=ID #---Field=data 1 001 AA BA FD 2 002 GK VX i thought i could use two tables and a SUM calc…

I have a columnar type layout with a variety of fields arrayed across each record. Field behavior is set for all fields to "select the entire field when entered". The annoying part comes when you enter the cursor into one field, all the other fields light up as though to display their field border. Is there anyway to make the other fields shut up when you're just trying to talk to one of them? Thanks for any help here, Jarvis

Let me premise that I have very little experience with FM, so if my question is too obvious please do not hesitate in referring me to the instructions. Here goes: I am making, say, a database for cheese. Each cheese has different sales in different countries. I want an user to be able, for each cheese (record) to select countries from a value list, and then insert figures next to the chosen countries. This bit I should be able to do. However, I then wish to be able to make a calculation of, say, how much all my cheeses sold for in france. I need to run something like a calculation field, that calculates across records, in a given field. What is not so simple t…

In a List view, is it possible to get the active record in a global field, and have it update everytime you change records without a script? gvar1 = 1 when i'm in Record 1, when i jump to record 12, I want gvar1 to = 12. Played around with this for a bit and couldn't get it to work. Just curious.

I helping a non-profit organisation create a small database to keep track of donations made by the sponsors, I created two files named donations.fp5 and donators.fp5, where i link both using the relations membership id to donators ID, but i am getting into difficult when i want to create a report to generate all the donations made by each and all members in the year. I am still pretty newbie in filemaker pro 6 but really want to help and complete this small project as the organisation cannot afford an out of the box software to do all these, it is also a learning opportunity for me as i am helping them out, so please anyone who can help, could help with me send tips on…

Curious why this won't work... I'm simply looking to make a status field empty if a product field contains any of the 4 options. If(lu_IDProduct= "SVC.DeKD" or "SVC.AsCP" or "SVC.AsDL" or "SVC.DLIn" , "" , "Back Ordered")

Is it possible to format a phone number field where one just inputs the raw numbers (no spaces)and the display returns parentheses, spaces and hyphens depending on the country. As per Excel:- Format Cell-Number-Special

I know this must have a very easy answer, but I can't seem to get it to work... I want a calculation field to show two decimal places -- even if they are zeros. The field sums two number fields. If the sum is "7", I want it to return "7.00". This is a simple, simple invoice. I have tried Round, Truncate and SetPrecision. It always returns "7". I know there must be an easy way to do this, but somehow I am missing it.... I have searched FMForums for decimals, cents, steprecision. No luck.... Please help!

I am creating multiple records with a single script step. Each of these records is blank, except I am numbering them using the Auto-enter Serial option. When I set the starting number to "1" and then increment by "1" all works well. However, if I delete all records and build another set, of course the numbering of each record picks up where it left off. My question is is there a way via a script to reset the initial value back to "1' without entering Define Database, etc.? If not, perhaps I could do my auto record numbering in a different way? Thanks in advance for any suggestions. Kirk

Thank you in advance to everyone who helps on this forum...you are great! What I'd like to do is have text appear that says "ALERT" (or something to that effect) when certain text is entered in a field. For example: We have a 'notes' table that is accessable via a portal in our main layout. If we were to enter in notes something like "user is due for an evaluation", we would like "ALERT" to appear somewhere on that layout because "evaluation" was in the notes. We'd also like other keywords to appear, so 'evaluation' wouldn't be the only thing it would hit on. Users on this forum have told me to use the following when there is *any* text in the…

Can't figure out how to get a calculation (or a script step, I'm not choosy here) to take the data I put into a date field as (7/29) and output it as (Friday, July 29th).

Last ( Test History::Test Received ) In our portal (test history) there is a field for the Test Recieved (date). How can I use the above calculation to always show the last test received date EVEN if it is blank (not entry)? Right now it will just default to the last date found in the portal records.

Hello - We've created a database to manage a fund-raising event we are having. I'm trying to create a field that will show the total amount raised, across all records. I've fiddled with it a bit and can't get it to work - can only get it to calculate a total of the record I'm in, not across the whole database. Ideally, I'd like it to calculate the sum of all records that may have information in the following fields: Sponsorship Amount, Table $, and Ticket $. If that's not possible, I can create a field that's called Total Amount This Record, add those fields up, and then have a Total Amount, All Records field, which would show total dollars raised, no matter what…

If I type a new value in i record is it possible to use the new value and automaticly create a button for that value. Ex. One layout (Fruits) and it's Record contains Apple, Orange, Bananas Another Layout (Names) contains Records with Peter Tony Bo that is related to the layout with the records containing Apple, Orange, Bananas A third layout contains Three searchbuttons "Apple" "Orange" "Bananas" and the records of: NAME FRUITS Peter=(Lookup Value from Names) Apple=(Lookup Value from Fruits) Tony=(Lookup Value from Names) Orange=(Lookup Value from Fruits) Bo=(Lookup Value from Names) Bananas=(Lookup Value from Fruits) New Record Johnny Cucumb…

I'm building a little testing solution. I have a question with 4 possible multiple choice answers...each answer being in a seperate field. I'd like to have a button that would randomly "scramble" the answers in each field. This way an answer "key" couldn't be created as the correct answer would not always be in the same place. Thanks in advance for any help/suggestions. ===Okay, I made a solution by doing a sequences of copy/pastes using temporary fields. Don't know if it is the most elegant, but it works.===

Good morning, I tried a few ways to do this but with no luck...is there a way to add to this calculation that will tell it that if field "TEST ISSUED DATE" has nothing in it (blank), that is should exclude those records? Here is the code I'm using: Case ( Get (CurrentDate) > CALC TEST DUE DATE and IsEmpty ( CALC TEST RECEIVED );"ALERT" ) Basically the calculation is working perfect (thanks to everyone who helped http://fmforums.com/forum/showtopic.php?fid/31/tid/168288/pid/169414/post/last/#LAST ), however it's also showing results from employees who we have not given tests to yet. Hope that made sense and thank you! Also does anyone …

I'm busily modifying a template file to suit my purposes. When I add tables, my instinct is to set up the main match field (things like User ID, Query ID, etc) as auto-assigned numbers in number fields. But the bundled template fields are auto-numbers residing in text fields -- beginning with something like 000001. Why is this??? I can see why you'd need the leading zeros to keep a logical sort order for text, by why not just use number fields which already treat 11 as bigger than 2 without having to resort to such tricks? Baffled...

I have a calculation that adds a percentage to a number. If I change the first number the percentage is not recalculated. Could someone please tell me how to get it to recalculate? Thanks Learning

I'm importing text data from another application. The date fields are in 2005/07/28 format and are importing as such. I need to change the format to standard Filemaker format of 07/28/2005. Help....any ideas? Thx.

I am trying to find a way to check if a field has a quotation mark either as first and/or last character I cant seem to find a way of asking because FMP sees the quotation mark as a special character when writing a calculation Is there any way of doing this ... to check if a quotation mark is in a specific position I dont have much choice in this since the quotations are in imported files from another application and I need to identify and remove them

I am desperate I have a database that needs to be in action by 1st Aug and I'm stuck. I have an invoice database that includes a stock table and and invoice table. Everything I book in to the stock table has a serial number and a creation date (as well as a product code and description that is looked up from a product table) . For various reasons I need to sell the stock in the order that it was booked in -not via a serial number as these are already on the product, but by the date they were booked in. I need a custom message to be shown when someone tries to sell a product that is newer than an older one that is still in stock. I hope i've explained myself clearl…

Is there away too insert a mutiple files into a container field with the ability too click on it and open each one(.doc, .xls) from the container field. I have a project where they want too insert mutiple emails or files into each record. So that when users view there record they can click and open the documents that accociate with that record. Any help on this would be awesome!

I have a database from which I would like to extract a count from various field combinations. A count from Type of Ad field (which is a pull-down menu field) and a Color field which is a radio button set with values of either "Black" or "Color". So what I want is a calculation field that gives me the total of all records that are both "Birthday" and "Black" and another calculation field that gives me the total of all records that are both "Birthday" and "Color". I want to summarize the totals of all records contain these combinations in a report layout.

I'm trying to create a report which in effect will count the number of sales for each salesperson has over a given period. Each sale invoice denotes the date and the specific salesperson for that invoice. I need the report to list each unique salesperson and the number of invoice records they appear in. The sales person varies from period to period. Presently I can use a list to sub summarize by sales person and then add the invoice. This is not very elegant nor practical when the number of invoice can get exceedingly large. Any thoughts?

I have created a database to manage the distribution of a large personal library to family members who have expressed an interest in various items. I have one field titled "status" in which I have a value list formatted as checkboxes. This value list is in the form of the initials of people being contacted. What I want to quickly do is find just the items in which two or more people have expressed an interest in the same item; i.e., where I have checked two or more checkboxes in the status field. Any ideas? I am somewhat rusty on my FM skills but thought this would be simpler than it is turning out to be. Thanks for any help out there. Bruce Williamson

I'm sure this is an easy one but... I want to validate a field to accept only 00 or >10 and <50 (i.e. 00 or between 10 an 50) I entered exactly as above but just got an error message

Hi, I have a database in which each record needs a unique name based on other values in that record. However, some fields may have the same value from record to record, so the "Name" field is calculated from a field "Namebase" & an appended unique serial number, which I obtained by using two self-join relationships in this table. If three records in the table share the same "Namebase", and a 4th is added that also has the same value for this field, then the serial number "4" is appended to "Namebase" to create the unique "Name". The only problem with this is that if I later delete a record, some of the remaining names will change (the serial numbers of some re…

I have a FileMaker Pro 7 database with 4 fields: Day, Month, Date, and Year. I want to be able to make up a search page, that will allow users to put a starting date (i.e.; Monday June 1 2005), and an ending date (i.e.; Wednesday June 3 2005). Is there a way to do this, without have to add the "Range" symbol?

Greetings! I have a question First - Sorry if this is the wrong section - seems to fit better here than anywhere else... Anyhow! I have a record set of about 200,000. The main field has a chunk of text in it. Would it be possible to somehow generate 2 new versions of those fields - each with punctuation added at the beggining and end of them? Note: it would be the same punctuation for all fields though... Example: Field: The brown cow goes moo I want to get: "The brown cow goes moo" and !The brown cow goes moo!

Autoupdate fieldcontent I need to have a field with a time stamp (no problem) and when counting time from the startingpoint till after 5 minutes (300 seconds) I need a list to open with differnet choises as a reason for why it took that time before anything happend. I used an IF (Field > 300 ; Message ; Message) and it works fine, but it does not AutoUpdate. If I do nothing, nothing happens. And the script is useless. Ex. When I send info to the startingtree I also send a timestamp and the next start I send a new timestamp. If there is a differense between the two timestamps of five minutes I would like to log that from a automatic choise (chechboxes) Say. …

I need to duplicate 100 records that that have 40 fields each. I'd like one field to keep it's current data and the rest of the fields to be empty. Is this possible?

Hi, I cant figure this one out and have searched the forums, but no one has addressed my specific problem: I just need to count the number of values in a field ie: if I had a 100 records with a field "color" I would like to know how many records have the value "red", "blue", etc. for the "color" field. It should look like this: red 5 blue 7 black 1 A subsummary report will not work as I need to view this in browse mode. Thanks in advance! Matt

I hope this is an ok place for this. It's really a report question, but there's no general report forum. I want a report of sales by customer, for a particular range of dates, and I'd like to sort it by sales. I have a summary field in my InvoiceLineItems table which is a total of the line item cost. For my report I have a layout with a summary part when sorted by customer name. That works fine, but that gives me a report sorted by customer name. I'd like to do a sort like this: TotalSales CustomerName But I can't sort by a summary field. Suggestions? Thanks.

Hi, Working on a solution hosted with FM Server where the goal is to place Excel spreadsheets in a Filemaker container field and be able to launch Excel and open placed spreadsheets from the Filemaker database. This is do-able placing Excel file as a reference into a container field and just double-clicking on it, BUT...the problem I'm having is that this site runs Filemaker Pro on macs and PCs. If the Excel file is placed from a mac client, then the file reference is filemac:/VOLUME/path - so ONLY mac Clients can open that file refence. Conversely, the files placed into containers from Windows clients have a filewin://COMPUTER/VOLUME/path reference format and c…

New to FMP7. Using Photo Catalog Template. When I use Import Records > Folder I get inconsistent results. All folders contain JPG images of sufficient size to fill container. Some imported folder images scale fine, utilizing either full width or height of container as expected. Others occupy only a portion of container, using neither full width or height. Has anyone else seen this behavior. Is there something I might be doing wrong?

is there a way to create a field, hidden from my users, to track who made the last modification--based on their login info?

Hi I need a summary field to count the number of unique values in a found set. Right now, all I can get it to do is count either all found records or "1". Just to make sure I'm coming across clear... if I have the following values in a found set 1 2 2 2 2 1 3 3 4 I want the summary count value to be 4 Help appreciated. Thanks.

I have a problem in getting validation separate letter+number "p1" and number only "1" as Unique value. If I define the (number) field as Unique value I get a message that the number is in use if I enter letter +existing numbervalue. If I define the (text) field as Unique value I have no problem entering Unique values ... but then when I use sort or find... Need to have numbers as sorting and text when entering. How do I do that. Or how do I calculate the Unique value upon entering data. Peter Norling Sweden Ps. The numbers entered are starting numbers for dragracing and Cars have number (1078) and Bikes have Letters + Numbers (Mc1078)

Hi I am supposing I will probably have to write a script to do this, but I am just wondering, for future reference, if there is a quick way to do it. I have a sorted list of financial transactions, some of which are marked as VOID. Is there a way to get the summary field to ignore the values of the ones which are in the VOID category? Thanks for any suggestions.

How do I create a field that I can use as a notes field. I cannot get the lines to show up and my cursor for the blinking line to let me know where I am typing is half the length of the field. Do not get me wrong the cursor is large but the text is exactly what I set "8 font". One more thing I have an auto enter script when someone edits an employee file. The script works almost worthlessly it always overwrites last note entered. It is suppose to Carrige Retunr at end but it has never gon to next line. Thanks Tony D.

Does anyone know how to have a field link to a folder on the desktop that contains many pictures?

[color:black]Hello, I'm using the 30-trial version of FM7. I'm setting up a customer database. The following situation I would like to realise: each customer entry has a hyperlink included to a local folder on the HD. For example: c:/customers/A Customers/ACompany/.... Is there a standaard feature in FM7 to create a browse option to the local hd? And the possibility to past the path into a specific field? On a user-friendly way? I've searched on a lot of forums but without any usefull result. I've also tryed the included trials of FM 7: file management, but I can't find the specific script that belongs to that specific action. Co…

i need to make a numbering system that includes the year count. the example is nr 05-001, 05-002, 05-003 etc.. 05 is the current year, it has to be kept up to end of 2005. 001 is a consecutive number, goes up with every new entry, till the end of the year. then on 1 january 2006 it has to star from the beginning and become 06-001. anyone idea how to do it? thanx a lot!

[color:purple]I am new to Filemaker Pro, but have extensive experience with Excel. I have a few questions about importing and exporting data - can anyone answer a few basic questions? I would be so happy for just a moment of guidance!

Hey everyone, my senario goes like this. My tech director built the system we have today in FileMaker 5.5 and we are curretly looking to upgrade everything to FM7. More specifically, as I was going through his scripts, I noticed he was checking for fields that were blank using the ' = "" '. However, now looking into the future and upgrading our database to version 7, I was wondering if the ' = "" ' method would work in 7 or would we have to change all the "" to IsEmpty? Will the behavior stay the same in 7 as it is in 5.5? Thanks J

hi guys, hope someone can help with this, I have a list of product names in a file, around 650 of them. If I save this as a merge file, i can then drag/drop it onto filemaker, and filemaker makes me a nice FM6 database with all the fields correctly named against what was in the original text file. However.... all the fields are 'text' fields, and they need to be 'number' fields. Going to each one and changing is rather a long winded way of doing it, any one got ideas of how to import this data straight without fuss? A few problems that you may encounter.... There are too many names for Excel to handle width wise The file is currently one …

I'm creating a patient database that will store scanned documents relating to a patient record. Heres what the tables will look like: Patient Table Patient Info Patient ID# (Relationship) Documents Table Patient ID# (Relationship) A Lot of Containers The relationship will be the patient's id#. Now heres the problem, the scanned documents are 200 - 500 pages. Does that mean I have to create 500 container fields to accomodate the documents? I'm planning on creating a portal in the patient table so the enduser can see thumbnails of the documents and when the enduser clicks on that thumbnail, they'll be able to see a la…

Is there a way to look at the information for a record just before and after? For example: If all the records have a time included and I want to know if the record before and after are within 30 minutes of the current record. Is there a way to autmotically flag and report those records?

I have made a calc. that pulls out which week we are in today. But what I need now is another field that shows the start date of that week number for the year that the record was made. What would that look like??

Hi all, I'm trying to write a Custom Function in FM Dev7 that has a parameter that references a field in a related table but of a different file. I'll bet there's a way of doing it but I can't figure it out for the life of me. Can someone clue me in, please? Thanks in advance for your help! :)

I think this is where I need to post - new to fmp. I am building a database where I need to have a list of dates (our trade shows) -- got that as radio buttons. I also have a field that lists all of the items we sell -- they never change and the price never changes. Now I need to know how to set it up so that when I click one of the radio buttons in my date list and then click buttons from my items list that it will associate those items to that date. Then if later in the year that same contact comes to another show and buys the same (or different items) it will track what items were purchased on each date. Can I do this using just the 2 fileds, but somehow set it up…

So I have a table that tracks transactions, and each transaction gets an ID number. The ID Number looks like YR-### and is a concatenatation of the YR field (calculation of two digit year), and the auto-entered serial. How to I reset the serial number every year or every time the YR field changes? This one's been killing me. Thanks, Lonn

This is my first post. I would like to create a script so that a container can easily be opened for editing (rather than having to right click and then select OPEN PRESENTATION). That way I could make the container itself be a button and all the user has to do is to click on it to edit it. I have powerpoint slides in containers. If the user double clicks on them they open for viewing. I am using FM 5. I would appreciate any help anyone can give me. Thanks in advance.

In FileMaker V6.0 in Windows 2000... I have two databases. The first one is manly for demographic info (name, address, phone, etc.) It does not duplicate names. The second one is for listing and counting contacts during the year. The number of contacts for each name in the first database varies

One book I have regarding FM7 talks about using containers and Pdfs. It says " a Pdf file inserted as a file shows the file icon. A Pdf file inserted as a Quicktime file shows the Pdf contents. " But when I try and do so it gives me an error saying The Quicktime movie file could not be inserted. Make sure the movie has been saved as self-contained and playable on non-Apple platforms. The book which I got this from was SAMS Teach Yourself Filemaker 7, which has been a good series for me when dealing with other programs. I have read previous posts regarding this topic and have not found anything which ultimately solves my problem of being able to view the actual .Pdf…

Hi, I've set up our database to use an incremental number on the creation of a new record. However, if anybody accidentally creates a record and then reverts it, we lose an invoice number and it throws the accountants into a panic!! I presume I need to calculate this in some way? Can anyone help? Many thanks Sari

I have an electronic job ticket. I would like to be able to track chnages made to any of the fields. My thoughts would be to have a Submit button that would take a snapshot of all of the data and then when someone changes anything, it would know that there has been a change and keep track. So it would read Rev 1, Rev 2 and so on. I would also like to highlight the field that have been changed so that someone else would see where those changes have been made.

I have copied my solution and I am reconfiguring the new solution for our upcoming year; If I've made the old and new relate will the formulas change in both if I change them in one??? [color:red] :confused:

First post here ... I have a table with three fields: Record ID: number Origin: text Statement: text I would like the third field to be a concatenation of origin and record id. I have tried auto-entry using calculated field: Origin -- works Record ID -- works Origin & Record ID -- only Origin shows up Origin & GetAsText(Record ID) -- only Origin shows Is there something I am missing? Thanks in advance! Sean

Hi everyone. I have another problem (surprise, surprise). I want to count the number of records that fit a certain criteria and show the results in a different table. For example: If Table 1::Field 1 = 3, then I want it to count all the records that have Field 1 = 3 and put it in Table 2. So far, I have: If ( Table 1::Field 1 = "3" ; Count (Table 1::Serial Number) ; 0 ). The problem is is that FMP only looks at the first record of Table 1 and not the rest. I am obviously missing something but I can't figure out what it is. Can anyone help me out?

Hi guys, This is similar to the PDF post by Slickwilly9. I have a solution that has manhole diagrams in it. Originally for demo purposes, I printed them out of Autocad as a PDF and converted them to JPEG's and inserted them into the DB. The potential client really wants to be able to edit the Autocad version and have them display on the layout. I know I can show the jpeg and use a send event to open the autocad file, but if it is edited, the jpeg obviously wouldn't be affected. Is there a way to view an Autocad drawing in FM or to use some external program to convert the autocad into a jpeg and use it as a reference so it will update the image in FM? Thanks in a…

Hi all, I have a table Customers and a table Products. They are joined over a table CustomersXProducts. A portal on the Customers layout from the CustomersXProducts table shows the items a customer buys. Each record in CustXProd. has a field called One, where a 1 is the automatically created value. A field Total is a summary of field One. I show that Total in table Products over the relationship ProductID=ProductID, so that in the layout Products I can see how many of each product have been sold. (See attached) (Something tells me I should be able to do a Count of Related Records or something, but that eludes me for the moment, hence the method us…

I've put my 3.5 hours in trying to get this to work but can't - so here's my question: Is it possible to Text format a date calculation, yet still maintain control over the format of the date itself? I have a calculation that changes the size of the text (of a date) if one thing and not the other, switching the field between 8pt and 9pt. This works when using the unformatted date "mm/dd/yyyy" but I would like the date to be "mm/dd/yy" and can't seem to format it this way unless it is a DATE calculation, yet the text calculations seem to be null. If I want the text calculations to be active, then it has to be a TEXT outcome for the calculation, but then I can't form…

I've been away from FileMaker for almost 7 years, I can't belive how much one forgets the little things. I'm working on a simple inventory system for a friend. It simply tracks products that his company sells (mostly furniture). A Product Line contains several products, each product has different finishes. When I am looking at the Product Line, I am summarizing the total of each Product (and subsuquent finishes) within the line. I am doing this by creating a field that is an auto entered value of 1 (called Constant). Then I'm using a self relationship to Count (selfbyProductID::Constant). Works great when I'm on the machine directly, but silly me didn't think about …

I have the Invoice table and the Invoice 2 table as self-join. I created a portal using the Invoice 2. There's the Category, Item, Qty, Price and Amount fields. I can do the Total field which calculates the sum of the Amount field of the portal. But I can't figure out how to just total the amount of only those of a paticular category. For instance, the total amount of only with Category = "Electronics". Please help.

Hi everyone! I have a database that tracks time spent working on various customer projects. The basic fields are: CUSTOMER NAME (text) TASK DESCRIPTION (text) ELAPSED MINUTES (Calc > Stop time - Start time) I would now like to generate a report that summarizes the time spent working on each type of task. In some cases we will do the task just once. Other times we will do the same task many times. I would like the report to indicate just one subtotal per task description. IE. if the task happens three times, sum the three discrete entries and report them as one subtotal. I would also like , if possible, for this report to be …

I spent the last day trying to figure out a first grade math with a SIMPLE Calculation. I have a table with a Number field reflecting high values. Let's call it "High" Then another field that is a Number value as well. THen I am creating a Calculation that says if If (field 2 > than "High ;1 ;0). JUst a simple first grade math. Well the Crazy thing is like this. Let's say High contains the # 55 Then Field 2 has a # 66 Based on this the result should be 1 right... Well Not according to Filemaker. it sometimes decides to consider the Value 500 or 600 not to be > than 55. So it is randomly giving me 0, or 1 not according to …

I am creating a report layout that retrieves data from another layout in the same database. There is Sales Tax section that I put 3 checkboxes for DC, MD, VA. I want to do "If state = "DC", check the DC box automatically." same to MD and VA. Another feature, even one box is pre-checked, users want the flexibility of unchecking it and checking another one. I created 3 fields, TaxDC, TaxMD, TaxVA, and specified them with each checkbox. The Value List used for the checkboxes is "Yes", which value is simply 1. First, I set those 3 fields as "calculation" fields. I put "If(state="DC", 1, 0)" in TaxDC; same calculation with state="MD", state="VA" to TaxMD…

Hi all, I try to do validated cal: A+B=C (In C much more than cost, if not pop up the message to me) Can anyone help??? Thank!

I've made a calculation field as follows: CountFIELD (a summary field that's a count of a text field)/TotRecords where TotRecords is a calculation field = Status(CurrentRecordCount) In a subsummary on FIELD, CountFIELD returns accurate data and TotRecords returns accurate data, but the calculation CountFIELD/TotRecords does not, returning 98.5 each time. Is there a way to make this calculation work? Or is there a workaround to get the same data in a different way? THANKS in advance for your help.