Calculation Engine (Define Fields)

Each record in my database has a field "Project Number" Multiple records can/do have the same Project Numbers. I want to define a field that will indicate if a particular record is one of the 3 most recent entries with that Project Number. Does that make sense? Thanks, Tim.

I'm trying to set up a calculation field which creates a sequential series of data for all the records in a found set. I'll be using it to create numbered labels for test items in a printed test. Currently, after using a "find" function to create the list of questions I want to use in a test, I can manually type in 1, 2, 3, etc. into my "sequence" field. However, I'd like to harness FMP to do it automatically instead, to turn "seqence" into a calculation but am having trouble coming up with a calculation to do so. Now I'm wondering if I need to use a script with it (Find, then Sequence....) Any ideas, suggestions or calculation scripts would be wonderful. Thanks

Is it possibe to have a conditional value that if is true will change the Text style or colour. For example: If a date become more then 5 days old, the font colour would change to Red or the font would go bold. Can anyone save my *** ?

I have a field that needs to contain 22 characters, no more, no less. How do I do this? Thanks in advance.

Is there anyway of using list view when hosting files over the web

Is it possible to have a Date field, but behind have a coloured calculation field. So when the date becomes so many days old, the coloured field would show through and the date would appear, say red. I know this is very vague but it's hard to explain?

I am creating a billing database. I created a relational db between the billing db and an anesthesia procedures db. In the anesthesia procedures db there is a procedure field, that procedure's coding number in a field, and the procedure's cost in a field. I have created a checkbox in the billing database from this related "anesthesia procedures" database. When a provider does a case, he would check the procedures he completed for a case. There could be more than one procedure, or no procedures if it is a routine case not requiring special monitors. I chose a check box so multiple choices could be made in the field. My problem is to create a calculation field (total…

In the user manual (not the "getting started manual") there are sevaral examples of databases used to explain the function of fields, formulas, fuctions, scripts etc. But I can't find the examples itselfs on the provided CD. Also Filemaker Holland could not help me. Can anaybody do? P.S. the examples are of FM Pro version 5!!!!

I'm working in the Windows environment (oh well....) My question is, is there any reason why I shouldn't use custom font sizes, such as Arial 11 pts., either for fields or labels. Size 10 is a bit small, size 12 uses too much space. Size 11 looks good. Any reason I shouldn't use this size? Thanks in advance.

I've got 2 related DBs, one with video files & info about the video files, and another for editors to log comments & timecodes about the videos. The vids play in their own DB, but when viewed in a portal in the other DB (so the editor can see the video as he builds the DB of comments) it won't play at all, it's just a still of the first frame. Am I attempting the impossible, or is there a way to get this to work?

OK. The issue with the Case( not working was localization - I had to use a semi colon instead of a period. But now, I have another issue - I'm building an online shopping cart and I have four databases - customers, carts, products, and orderitems. Orderitems is the database that the customer sees their shopping cart through - when a customer adds a product to the shopping cart, the product price is looked up and placed into the orderitems file. The quanity the user sets for this item is a field that directly resides in orderitems. My issue is this: In the end, I want to have lower prices for higher quanitities. I have three fields - quantity, price, and name. I w…

I am a beginner at Filemaker and have been using it for a couple days now in order to build a database to catalog my photos. I am a nature photographer so I will be photographing a lot of animals. Here is my problem. I am attempting to have three different fields in my catalog that will consist of the Common Name, Genus, and Species of each animal. I have a Pop up list on the Common Name field. What I want to do is select the Common Name from the pop up list and have the Genus and Species for that particular animal filled in automatically. I have created another database file consisting of the three fields (common name, genus, species) so that I can create a record of the…

Hi all, My brain is not functioning with this problem: I have a price field that I want to change based on a quantity field. If the quantity is less than 2 then I want it to be $20, if it is less than 24 and greater than 2 then the price should be $18, if the price is greater than 25 the price should be $15. Any help is greatly appreciated. Thanks, Chris

I'm rather new at this and attempting to round the results of a calculation. I want a calculation to have no more than two numbers behind the comma. Please can someone help me Thanks, Jeroen

This may be premature, as I am just starting to think about the problem, but I am concerned about how to attack this one. Here is the scenario. I will do my best to make this make sense, I think the problem is fairly simple to describe. I have a table of race results. This results file contains the following fields (among others that are of little importance to this discussion): vessel ID, division ID, race ID, position, and points. Each record represent the specific result of on race. At the end of the season (ad during the season for that matter), we need to produce a report that will list, grouped by division, and sorted with the groups based on the sum of the points …

I wanted to flag jobs in a request database that are past their due dates so I created a calculation field. If(due_date < Today, 1, 0) Then I display the due date in red if the past due field has a 1. The client told me they need to close and reopen the database to make sure the past due jobs are displayed correctly. If I edit due_date the calculation reflects the past due calculation correctly. For example, if I edit the due_date so it is greater then today the calculation is switched to 1. If I don't change the due_date but over time it eventually becomes greater then today, the calculation doesn't update, it remains 0. Does this seem correct? Sounds like FMPro …

I can't quite tell from your description, but I think you have some structural problems in how you are organizing your database. How about describing what you are trying to keep track of. Fields are independent of the layouts on which they appear, you don't need "new" fields for each layout. If you wish to keep track of information for a number of different computers, you would typically have a separate "record" for each computer with the same layout and fields. -bd

Is there anyway to get Filemaker 5.0 to show the animation in an animated .gif file or is that just a windows thing? I've got some really cool looking ones that I want to place in my Database but the darn thing won't animate. Can anyone help? ~Addam~

A script would be the best choice. Chuck

I Have two files one the clients "clients.FP5" and one for the inscrption "inscription.FP5". In Clients.FP5 I need to calculate a field that verify if a client as an inscription for the formation # "101" for exemple. So I have to look the inscription.FP5. If he is in #101 formation then the calculated field become "Yes" .Is it possible to do this wihtout using a script :? Thank you for your help !

In the help files for FMP (5.0) it says

When I choose to insert object into a container, I get a list of "registered" programs which will open and allow editing of the picture in the container. How can I add a program like ACDSee to the list so that it opens up the .jpg instead of MS Photo Editor?

Let

I'm designing a database with a pulldown text field (Select Postage Type) that is linked to a calculated field (Postage Rate). The pull-down field allows the user to choose from several different postage options for catalog mailings. The choices are: Standard Postage A Standard Postage B Custom When either Standard Postage options are selected in the (Seloect Postage Type) field the (Postage Rate) field automatically enters a numeric value using a Case statement. However, when Custom is selected I want the user to be able to modify the (Postage Rate) field which you can't because calculated fields are not modifiable. How can I make this work? Thanks for your hel…

I am trying to set up a layout of a toner tracking spreadsheet. As soon as I need to change a cart. I want to be able to say this: cart #------Date---Page Count------Page Per Cart. The way I was trying to set this up was that each time I change a cart the Page Per Cart column will change by subtracting cart 2 page per cart number from cart 1 page per cart number giving me a number of pages for each particular cartridge, then I eventually want to average them the Page Per Cart Column. I have tried to use repeating fields but that will only take the diference of the last repeated field with the new one. Any suggestions would be greatly appreciated. Thanks.

We have a video db that was converted from an old DOS program. One field is called "Level" and contains any combination of the following: P, I, JrH, SrH, A . If a video is good for the whole family it will contain ALL those letters. If it is specifically for High School it will only have "SrH". I'm preparing to combine this new db w/another one (for books) and i'd like to take this field and make it into a check-box field (which would be easier for us to search). I've created a field "Level Copy" and tried to make it a calculation using the Case command [Case(Level = "P", "Primary", Level = "I", "Intermediate",) etc. unfortunately, it didn't work. I made it a text …

quote: Originally posted by cheynooki: Is it possible to set a pop-up menu to auto enter data into a separate text field? I have a pop-up menu with 14 different values ... when I pull down to one of the entries, I would like the DB to auto-enter a few lines of text into a separate field in the same DB. Each value of the pop-up menu would call a different string of text to be entered in the text field. Where could the "conditional text" be stored while awaiting auto-entry (in invisible field(s))? Thanks in advance for any help. -George- Create a new database with fourteen records and two fields. Field one holds one of your values in the value list. Field two …

Is it possible to derive a visitor session ID from IIS5 as a person enters a site and make this the Record Serial # as apposed to auto-enter serial number or a calculated serial number?

Here's my minor dilema. I have many fields with long names. Like "Expression Cassette", "Gene of Intrest" and "Transformation Method". When I view the data in a table, these field names take up a lot of screen space. I would like to reformat the column titles to EC, GOI and TM so that more columns fit on the screen. But I would like to avoid changing the actual name of the field, because I want to avoid the "cryptic-ness" that that would create. I thought about creating an elaborate Header for the layout and hiding column titles, but that is static. If I needed to insert, move or resize columns, it would no longer fit. What do you guys think? Thanks!

I need HELP!! Does anyone know how to run a summary (running total) without including the first record of the found set? Help! I am currently using FileMaker Pro 5.0. I don't know if anyone here can help me or not, if not, maybe you could direct me to where I could get an answer to my questions. Question #1: I am developing a database to track my students timesheets. They fill out a monthly timesheet and are allotted so many hours per term to work. I have to track that time too make sure they do not work over their allotted time. I have one database called Student Monitors in which houses all of their information such as: address, phone, student ID, S.S number, …

I have an office field in a memo database in which employees can select from which office they're sending the memo. It is set to auto enter our main office because many employees forget to selct the office field. My problem is that when a memo is duplicated the auto enter data overrides the office selected in the original record. Is there any way to keep the auto enter data active but stop it from overwriting data when a record is duplicated? Thanks [ May 22, 2001: Message edited by: Tombstone ]

Can someone provide a simple validation calculation for an email address field? I want to make sure the user does'nt accidentally insert a space or line break in the address. There may be other illegal characters not allowed in email addresses, however, instead of researching email protocol, I figured someone hear could point me in the right direction. Thanks. Gordon

Hi, another question: For each class that's listed I want to sum up the grades but I only want to sum up the grades that aren't F, W, I, etc etc. So I only want ot sum up: A, A-, B+, B, etc. And add up the grades. I'm using just regular sum right now and that includes F, W, I which I don't want. Anybody know how to do a calculation for this? Henry

Please excuse me if this is a basic question. I work for a homebuilder and we are trying to make a database of all our paper documents (contracts, houseplans, etc.) saved as Adobe Acrobat PDF documents. We would like to be able to find and view the pdf documents from the Filemaker database. (Eventualy we would then like to make this avilable to our off-site employees over the web.) How do I include a "link" to the pdf file from the database to be able to find and view the document? What may be the best way to organize this? I'm using Filemaker Pro 5 and Acrobat 5 on a Powermac G4. I'm just starting to learn this so please include as many details as possible. T…

Here it is: I have an auto-enter Time_modified field, auot-enter Time_requested field and an Approval field. When ever a request is modified, the modified time will automatically change. When it changes, I need it to do this --> when the time_modified field does not equal the time requested field, delete the information in the approval field so that when a search is done for requests not yet approved it shows up in the search. The request will need to be re-approved when a modification is done. I am using a validation on time_modified. If(timemodified does not equal timerequested, 1 , approval = "") Above: the 'does not equal' is actually a symbol from calc…

Here's one you never heard of before. I recently went to work for an all PC office. One of our main jobs is to load JPEG's into this program called 'Thumbs Plus', the plus must stand for plus every imaginable nightmare you can think of. The thing that this program does is import(actually it just references and displays) approximately 1 1/2" thumbnails (in mass quantities, 100 to 300 photos at once) into a vertical column with other vertical columns for annotation. The concept is very slick and fits our needs perfectly. The rub is only one person in the office has a fair understanding of it. It's very non-intuitive, and has a mind of its own. Notes disappear, change or …

I need to count how many different client come to get our service. When a client come, a new record is create containing :is client # and the date . Is there a way to know how many different client come : Thanx

this must have been asked a million times but that won't stop me! is there a way to create a "school" year where the year is from, say, Sept. 15, any year to Sept 14, any year? So the "year" would then not be Jan 1 to Dec 31 but Sept 15 to Sept 14... many thanks, nati [ May 16, 2001: Message edited by: nati ]

Hi, I'm trying to merge some text fields using a calculation. I can enter text surrounded by quotes, like this: "some text" & " " & "more text". But how do I quote quotes within quotes? Like this: "some text" & """ & "more text". Obviously that doens't work... Using the word 'quote' doens't help either. Can someone give me a clue? I'm amazed FM is not able to quote quotes. I couldn't find anything in the manual nor the filemaker techinfo database, which seems to be down once again. I would like to prevent using seperate fields for just the 'quote' character. If I would do that the result would be this: "some text" & quote & "more text". Doesn't…

Hi all, Hope I can explain my question well, here it goes: I have a text field which is called the Remarks. This remarks is to capture any comments in text form. Now, everyday and every shift(3 shifts in total), the data keeper will have to key in comments. For example in 3 day time period, there would be a total of 9 records being created: Date1 Shift1 Remarks1-1 Date1 Shift2 Remarks1-2 Date1 Shift3 Remarks1-3 Date2 Shift1 Remarks2-1 Date2 Shift2 Remarks2-2 Date2 Shift3 Remarks2-3 Date3 Shift1 Remarks3-1 Date3 Shift2 Remarks3-2 Date3 Shift3 Remarks3-3 In a another database, i would like to sum up these remarks in…

I have a program to keep track of my project hours. My fields are "Date", "Start Time", "End Time", and "Elapsed Time" which is a simple calculation. I would like a calculation field that will multiply my elapsed time hours and minutes by a fixed dollar amount for an accurate billing amount. Ideas? Thanks.

I have two fields one that list start time and the other has the end time...lets call one feild "time in" and the other "time out" I would like total up time spent automatically in a third feild "Time total". Can this be done and how? I can't seem to figure it out. RET

Every day I need to import records from a primary dbase1 into 8 other db's, depending on the record type. I know I can perform a FIND in dbase1, and then open the targeted dbase and perform the IMPORT, but its tedious to do this eight times, and I'm a bit lazy . I know I can write a script to perform the eight FINDS in dbase1, but is it possible to include in that script, a comand that: 1) Opens up the target dbase 2) Commands that target dbase to import the records 3) closes that dbase, and moves on to the next FIND and target dbase Then I could perform all 8 imports with one button click. Or am I going about this all wrong? Any ideas are welcome!

Hi all. I need help with regards to creating a field which calculates the number of hours incurred. I am on FM5 btw. Anyway, I have to keep track of the number of hours incurred. So I have actually created 2 fields, namely: Time From & Time To. Time From is the starting time of work. Time to is the end time of work. So in order for me to calculate the number of hours worked, I will just created a new calculation field called Hours Worked = Time to - Time From. While this works great if u have the Time To greater than the Time From, this won't work if the hours happens at midnite. Say the person starts work at 11:30PM(Time From) and ends work at 6:30AM(Time To…

I am wondering if it is possible to take three fields (log1, log2, log3) and have them act as one field when I'm trying to performing a find. For example, I would put my search parameter such as a number like 001 in a field called log4 which would be a calculation field of the three fields (log1, log2, log3) and it would perform a search on all three fields at the same time looking for 001.

I have a field on my database that uses other fields of an other database, so it can't be indexed. But I have to export this field and other unindexed fields, like DBF, that are used on an IBM system. Because this fields are unindexed the exportation is very, very slow....something like 3 hours...how can I otimze it??? Does filemaker have an way to turn this fields indexed??? Thanks for your help

How can I store on a fietd the Modifier Name or the Date of Mofication of a specific field. It isn't the modifier name of the entire record but of the modifier name of the specific field...

If the result of the calculation is numeric, you can round the result off to a fixed number of decimal places using the round function example: round(field1/field2,2) rounds the result to 2 decimal places. If your refering to text results you may want to be more specific.

I'm setting up a calculation field with an If statement. If the result of the test is true, the result is 1. If the result is not true, the field must stay blank. How do I do that? The field must be blank because I need to use it for a summary field, which will count all non-blank fields. If the calculation result is 0, the summary field still counts it as non-blank. I don't want the summary field to count false results of my calculation field. Any suggestions? Thanks! LR

i created a Username and password DB for my clients logging into my site. I used their email address as their username. On the web page I used a find command to access the area. If I use just the password it works fine, however when I use both or just the username it tells me it doesn't like that. Is there a problem with the @ symbol when searching in a text field? Thanx Rob

Developing registration/inventory system for college media equipment. Includes the following; Database of students each with unique ID number. Database of equipment each with unique number. Database of checkouts each with unique number that includes a portal to equipment reserved database. The portal groups together equipment by checkout. Database of equipment reserved where each record primarily contains the equipment number, reservation date and student user. These records are created in the portal in the checkout database. Problem How can automatically check to see if a certain piece of equipment is already reserved for a date? I need to check that the …

I'm modifying a database made by another person. The ID Field is a numeric field (it keeps track of video tapes). However, some items have a letter as part of their ID code (par example - our CD Roms are CD - 1, CD - 2, etc; Equipment [vcr, screen, etc] are E1, E2, etc.). Now we have several duplicates in the video category and they are listed w/a decimal. So for 3 copies of video 345, their ID numbers are 345.1, 345.2, 345.3 This also refers to their shelf number so it helps us locate the video. Anyway, that prevents us from having a numeric suffix or prefix (at least in my thinking). So, a numeric field will not recognize the letters and a text field will not s…

i created a Username and password DB for my clients logging into my site. I used their email address as their username. On the web page I used a find command to access the area. If I use just the password it works fine, however when I use both or just the username it tells me it doesn't like that. Is there a problem with the @ symbol when searching in a text field? Thanx Rob

Does anyone know of a way to move from between fields using the enter key instead of the tab key? When entering just numbers is sure would be nice to not have to jump over to the tab key all the time. Thanks for your help. Frank

I'm working on Filemaker 5 on a MACOS system. I'm having a problem doing a calculation. I have a non-repeating date field (day a person viewed a program) and want to compare that date to the list of broadcast dates (repeating) that this program aired (giving me an error message if the date does not match any of the broadcast dates). I cannot seem to get the extend function to work and the help example is not that helpful. Any assistance would be greatly appreciated.

Hi I'm developing a database that needs to allow users to enter data in either metric or imperial. Which ever is entered results in a simple calculation providing the opposite unit field to be entered. My problem is that the user often is provided with mixed unit measurements by clients. On request I have developed separate screens for both imperial and metric, such that the user can freely flick between units. As stated when the user enters in one unit value a calculation provides the result of the corresponding unit. However if the user then wishes to edit this in the resultant the original entered figure remains unchanged. I'm sure there is an obvious solution to th…

Here's a brief summary of my problem. Database 1 - daily sales figures for multiple restaurants (fields include: store, date, sales amount, customer count) Database 2 - Summary database. In Database 2 I'd like to be able have it show me a layout with the following: Month - April 2001 Store 1 - Total Monthly Sales(Summarize total sales for 4/2001) & Total Customer Count (Summarize total customer count for 4/2001) Store 2 - same info as store 1 Store 3 - same info as store 1 I'm just trying to summarize data but I don't know how to tell it WHICH data (or dates specifically) I want to summarize. Is this something that's going to be accomplished with Script…

Can I post data to global fields from an HTML Form? thanks Rob

When a user cuts text from their web browser and pastes that information into the database, the font style, type, etc follows it. I need to create a mailing list with this data and unfortunately the font settings stay with the pasted data. Is there a way in which I can force a field to a particular font type, style, etc?

I am working on an invoicing database. I have three 1.po, 2.line Item, and 3.Vendor. When I try to use a dropdown list for Vendor name it will not work. if I use a combination of Vendor code and Vendor name the dropdown works but it wrecks the report in the line item database. the new po's show up but the names no longer do they new po's all show up under one vendor. however if I look at the records individually the show the proper vendor names?:?::?:?????? SOMEBODY HELP PLEASEE!!!!

Is there a way to create a field that can store user inputed URL's that will be active using a single mouse click? Active Link storage is the key. Thanks

Hello, I'm having problems with working out this calculation. Ultimately I need the discount which is determined by a field called parsing price and will then be subtracted from the product subtotal. So far I'm able to calculate half of it to work and then the other half which is almost identical to the other parts of the same calculation is not working. What I want to do is calculate the discount based on the parsing price. I have copied an example of the problem and an explanations of the different components of the calculation. This is the calculation for the discount which only works up until I want it to multiply the subtotal by .15. This would only apply…

I have a brain cramp. How do I force "round" to round up? i.e. if an event is timed at 62 seconds, and I need it invoiced in increments of 10 seconds, the round command on 62 seconds gives me a result of 60 <<round(duration / increment)*increment>>. How do I get around this? I want the result to be 70 seconds. Please help ! Thanks, Ed.

I know how to make a field in the database unique. BUT how do I make ALL the fields in the same record and databaseall unique...?

I have a microsoft project like calendar / gant database. I am currently trying to make an event in the calendar have the ability to be dependant on another event being complete before it can begin, like the predecessor function in MS Project. Once I do this, then I can sort the events by date, then by predecessor on the gant chart. I have tried creating two fields, a predecessor field, which is a pull down menu off all of the events associated with the current project. The other field is a calc number field - predecessor number - relation to self file via current project:: Predecessor number +1 This is the closest I've gotten, but filemaker won't let me do it beca…

Hello...I've got a field which I set to display a msg when validation fails (under )define fields. The problem is that whenever the msg appears, the system would also sound and alert, which I'd like to disable. Is this possible?

When a new record is created: Is it possible to make the field auto enter the previous value of that field plus one? IE: If the last value in the field was 12, then the auto-entered value on the new record in that field is 13. Serial won't work, because I frequently must reset the value of the field to 1. Thanks

I have a related field, ::notes, which houses notes for the current record. The field is locked so that users cannot edit the notes. However, there is another field, addNote, in which a user can type text and click an "Add Note" button to insert the date, user name, and note text into the related ::notes field. The only problem with this arrangement is that the number of notes could be very large, and with the field locked against entry the user cannot access the scroll bars (which are enabled). I have tried using a scrolling portal, but eventually ran into the same problem: I could scroll the portal, but the not the field). Any suggestions would be greatly appreci…

I am trying to make a field mandatory, but only if any one of six other fields have been modified. That is, if any of the six fields have been modified, you cannot go to another record, without having first filled in the mandatory field. I hope this explains it well enough. Thanks, Dave C.

I just created a semi-large database (635 fields). After I inputed all of the fields i clicked done and noticed that only the first two-thirds of the fields were in the layout I also noticed that i can't enlarge the body any bigger than it already is. How can i get the rest of my fields to show up??? Thanx in advance

How do I reset the serial number counter back to one. I mean, is there a script or build-in function that does this? Thanks. j

ok... I wrote a post earlier... and I got a little bit of help but I need some more... I have a total fee on all of my records and I needed a grand total of all the total fees on the report. I was told to make a summary called grand total fees but now the grand total fee shows up on my report for each record. I also have another problem. I keep forgetting on how to make a report and change what I want selected from the records to be on my report... So if someone could remind me and help me out that would be great!

Hi, I'm trying to create a calculation field to automatically insert the current date into a date field when another field is modified. The database is a library loans system and I want the loan date to be entered in a field when the borrower field is modified. IE. On record modification: When borrower_field <> "", insert todays date into date_field When borrower_Field = "", clear date_field This must only occur when a record is modified. Can anyone think of a way to do this? - Thanks, Grahame.

I want to have filemaker generate and alphanumeric sku# by combining the contents (or first few characters of the contents) of one field with the contents of a serial number field. IE: first field = elephant serial field = 420 sku field = elephant420 or sku field = eleph420 Thanx 4 Your Help!

ok.. i have a database that keeps track of current projects that our art department is working on. in the database are 3 fields, pjStatus, pjDueDate, and pjCompleteDate. ok.. i want the status field to be a drop down list, that has options like; pending, in progress, overdue, and complete. probably a few more, and also let them type in there own if they need to... thats easy enough.. now the tricky part. how can i make that field automatically go to overdue if the duedate is passed, i was able to do this with a calculation field quite easy, but this does not let them modify the field if they need to. also i have a script that when a button is hit it enters todays da…

When specifying a calculation, one can fill in for "Do not evaluate if all referenced fields are empty" How do i disable the calculation if any of the referenced fields are empty.

Ok, I'm REALLY new to this and I can't figure it out! How do you add up the sum on all the records to have a Grand Total amount. For example on each record I have a calculated amount of money. I want to be able to print out a report which would show the calculated money from each record and then the total of all the money calculated from each record. Please Help!!!

Is there any way to have two fields combined to create a unique record. I have a timesheet database. The fields I would like to have unique are employee_id and time_start_date. I d not need a many:many realtionship. I just need to make sure that no one employee can be associated to the same week more than once. Both fields are in the same database. Any suggestion on implemneting a combo key? I tried creating a calculation but I am not sure if you can apply uniqueness to the calc.

I have a Contact's Database which contains contact ID's, contact name, etc.. I also have a logo database which contains information about the different logos the client can use. What I have so far is a repeating field that is filled in by the sales people with the contact ID's that are "allowed" to use this logo. So this field only displays the contact ID's and is related back to contacts, so the user can see in the contacts file the name of the logos "allowed" to that contact. What I need is a way to place also the contact name that corresponds with the contact ID in the logos database. Since the Contact ID field in the logos database is a repeating field, I coul…

I am looking to have fmp add data to a field as users enter it, the trick is I would like that data to automaticaly add itself to a pop-up list once entered. Example: I am collecting address info from my clients and As the zip code field is added I would like to have any new zip added to the pop-up list. Another example is state list or country list. Any help would be greatly appreciated nW

Hello, I am a novice database user. I have seen several people refer to a "line item file" as part of a solution. Could someone please tell me exactly what it is and in what cases you would use it. Thanks

In a table I have fourteen fields event [x] [date] and numOfDays [x] [number]. The scheduling layout should contain the first record and last record. My idea was to use two global repeating fields globalFirstRecord and globalLast to display these two records in the same layout. I am only able to assign the values in the following way: GoToRecord [First] SetField [

What is the best alternative to using repeating fields, whether it be in a single file or multiple file solution? My first issue is with a online form that requires pull downs to facilate multiple scanning within an order ((for the quote) ( on the html side is there perhaps a better option as well)) i.e. 5 scans at 5x7 in 4 color process, 12 scans at 16x20 in duo tone.? ( in this case there is a field to enter amount then the size and then the process. (The last two are both pull down menu's on the html form, as well as the FM5 db.)

I'm constructing a database of daily reports. Each day's report is a new record. Field "A" in each day's report must show a running total of the numbers entered each day into field "B," but here's the catch--the running total shown in "A" needs to include all the previous days, but not the current day. Is there any way to exhibit a running total up to, but not including the current record? Thanks in advance for your help. Jim

Hello I'm having a maintenance problem with a fairly large system developed by a former employee of the company I work for. I've been developing FM projects for years, and I've never saw anything like this, so... I hope one of you guys can help me to "see the light" . - Scenario: multiple-file solution (15 dbs) running from FileMaker Server on a G4; client-server access by 5 iMacs and 1 Dell PC. - Problem: every now and then, with no apparent reason and without any fixed periodicity, one specific field in a list layout of a LineItems database gets "locked". A script is supposed to paste a value in this field (yep, it has to be a paste, circumstances do not allow to …

In a database I am creating, one field has "scene" designations for film production work. The designations are usually a number sometimes followed by a letter (1a, 3c, etc.). I want to sort the field in ascending or descending order. The problem is, I've tried to do this and it seems to recognize the numbers but doesn't acknowledge the letters. How should this field be defined? Do I need to have the numbers and letters in separate fields? Thanks in advance for your help. Jim

I need to have a data base which hooks up to the accountants inventory module. They need to have unique product ID numbers for each product line. I would like to be able to generate multiple serial ID numbers i.e. B1 through B1000, P1 through P1000 etc. I figured out how to use many small files to generate a serial numberand then suck it back intot he main database but the solution isn't very elegant and doesn't allow me to apply the 'unique' option. Is there a way to just write a calculation that performs the serial function rather than using the built in one which only allows me one stream? Bruce BestCalculator001.zip BestCalculator001.zip

I'm Working into a database whose have more than 700 fields, some of them aren't been used. How can I find this unusable fields(fields that doesn't have any mencion in other calculation fields)

This probably SOOOOO easy.. but.. I have the need to have the database make a few decisions. So, I figure CASE is the way. However, I can get it work when there are two tests, results in the Calc but no more. In particular... Case(Shipped VIA="PYRAMID", MATCH SHIP CODE::Courier Charge, Shipped VIA="RUSH 4 U", MATCH SHIP CODE::Courier Charge, Shipped VIA="FEDEX", MATCH SHIP CODE::Courier Charge,"0") Shipped Via is a pull down value list MATCH SHIP CODE relates to Customers database the default result occurs when the user enters Pickup (or anything other than PYRAMID or RUSH 4 U) in the Shipped VIA field. The last test for FEDEX is always ignored... Is there a l…

I am new to filemaker and have this problem I have one field for the birth date of a person. How do I make another field that will automaticalle show the age of this same person? Thank You

This one is either so easy that the simplicity of it bewilders me or so complicated i am bemused - either way i need help. I have two db's a simple relation... based on the fact that the product description can change alot... so the description is built in the second db out of fields containing the elements of the product... with me ?... using a calc... SLength & "'" & " " & "x" & " " & SWidth & Inch & " " & Weave Type & " " & "Recovery Strop" & " Rated at " & Rating & "kg's, or double that rating for towing." Then ... in the invoicing db... i perform a lookup based on the selection of the product field... [which is a…

What is the correct specify calculation to achived the sum of each entery in a repetition fields? I have a pop-up menu field (time hrs.) with repetition X8. And a calculation field (total time) to add each repetition field entery together. I am not able to define a calculation that will add each entery together and display.

Hi, I'm trying to create a calculation field to concatenate multiple fields (about 10)into a single field (field1 & field2 etc). Thing is, some of the fields are empty and I do not want to add those fields. Does anyone know of a way to do this? Thanks, Grahame.

I have a file to calculate royalty payments from CD sales. It works fine, but the calculations are *really* slow (on a 9600/300 Mac), so I imagine that I have not made the most efficient code (so far at 2600+ records in the child file and counting). The master file holds one record per quarterly statement, the child file holds the line items, linked by the distribution date. Payments are collected by the distributor in either US$ or Can$, but paid out to the artist in Can$. In some exceptions, even the artist is paid in US$. To accomodate all these scenarios, I have, among others, defined the following fields: master file: USD_conversion [number] - the conversion rate…

Hmmmmm..... I've got a dbase where the records are people. There is text field called CODE into which, when required, the user can input an alphanumeric code (which gets used for all kinds of other things). The text field has a Strict, Unique validation. Fine. The problem occurs when I want to create a new record. The easy way is usually to duplicate an existing record where 80 per cent of the contact details are the same, and then just change the name and any other relevant data. But doing this duplicates the CODE field exactly, and no error message shows up indicating that it's no longer unique - even with the cursor in the field, or having just clicked out of it. Th…

Is it possible to scan a form into filemaker and then set it up for use?

I've imported QT audio into records in an audio db I've created. I would like to import the audio filename into a field, so I know the name of the file I've imported. How can I do this? The QT movie container does not show the filename, either, which would be an alternative . thanks

How do you Setup fields to hightlight to a different color when active?

Hello, I have a calculation field which = : hone number, where : hone number may be formatted with spaces aaa bbb cccc or hyphenated aaa-bbb-cccc. The calculation field is of type number and maybe there's the problem; it only shows all 10 numbers run together. I've checked the number formatting and set it to "leave as entered" but no luck. Any ideas? Thanks, Bill

I have two time fields named StartTime and EndTime. I have set the time format to be hh:mma/p. When I enter an afternoon time such as 3:00p, the "p" changes to an "a" when I tab out of the field. The correct time appears to be saved in the file, but the display has the wrong 12-hour qualifier. Does anyone have an idea about why this is happening? Thanks, Keith Silva