Calculation Engine (Define Fields)

I was wondering if there is a way to have a field with a pull down menu with some values in it. Then I want a find script that will place that value in it and perform the search. What I have is a roll call file that has all the students and the classes they have attended before (a line item sheet). But the student has attended our school for several years and I want it to show only the school year I want. Now, I am performing a find function and selecting the year. Then I go to reports and click on the roll call button. This runs a go to report function in preview mode with those values. I am cool with that. But my staff members think it is like walking and chewing gum at…

I have a repeating field with 12 values. Does anyone have a simple way to delete all the values in a repeating field in a found set of records. I was hoping a function to move to the next repetition in a field was available. But I can't find one. My solution currently contains 12 steps i.e. using the Replace["field rep 1",value] Version: v5.x Platform: Windows XP

Hi Guys and Happy New Year! I have a small problem (again) with my db. I created a field Named "VAT Amount" as a calculation (VAT * Net Amount) BUT it's not always that I want that calculation and then I want to be able to enter another VAT Amount manually. I set the field to "Allow entry into filed" But I'm still not allowed to modify that field

Hi guys... I'm a cold fusion programmer and am trying to adjust to the way filemaker does stuff. I'm trying to set the value of a field, using a calculation. I've successfully grabbed a timestamp value from the first and last records of a table by using the Min(FieldName) and Max(FieldName) and making the result a "timestamp". Is there a way to get the timestamp info I need from the next to last "max" record? in otherwords the max record minus 1? If I write the calculation as (Max(FieldName)-1), I get the timestamp minus 1 second. I need to get the actual value of the timestamp of this next to last record. I know i can probaly do it with scripting, but I wou…

If ( Last (PatternCount (RW_BookFormat , "HDRS|" )) , "" , "HDRS|

i have four databases at the moment. 'users', 'dvds', 'lists' and 'orders'. in the database users i have a field called 'orders made'. i want it to be able to search my database 'orders' for the name 'luke nunn' which will be in a field called 'name'. after it has gone through the database and counted all this i want my 'orders made' field to display how many there were. is there a script i can use or is it a formula i need to put in the calculation bit? help needed! Version: v6.x Platform: Mac OS X Jaguar

I have the following FMP7 calculation that displays an age as "xx Years, xx Months, xx Days". It works fine. GetAsText ((Year (Get(CurrentDate)) - Year (DOB) - If (Get(CurrentDate) < Date (Month (DOB); Day (DOB); Year (Get(CurrentDate))); 1; 0)) & " Years, " & GetAsText (Mod (Month (Get(CurrentDate)) - Month(DOB) + 12 - If (Day (Get(CurrentDate)) < Day (DOB); 1; 0); 12)) & " Months, " & GetAsText (Day (Get(CurrentDate)) - Day (DOB) + If (Day (Get(CurrentDate)) >= Day (DOB); 0; If (Day (Get(CurrentDate) - Day (Get(CurrentDate))) < Day (DOB); Day (DOB); Day (Get(CurrentDate) - Day (Get(CurrentDate))))))) & " Days" I'm hung up …

Hi. My database (one file) has 3 types of records: Customers, Addresses, Cards. There is a field that differentiate the records by the type. Having this set up, how to display for example 2 of 8 (Total 10) independently for each record type? Thank you. Version: v5.x Platform: Windows 2000

I am trying to format a credit card number field to automatically put a space after every 4th number. I have created a mask and it works well except that all credit card numbers are not the same number of digits. So if I make the mask for 16 and enter a 14 digit number, it adds numbers. Is there a way that I can get around this?

In my product database, I need to keep track of when pricing fields are changed. I have set up a field that shows the record modification date, but I really don't need it to change when any of the other field were changed. Is there a way that I can get the modification date for just one field on a layout? Version: v6.x Platform: Windows XP

i would like a calulated field called "RW_dateentered" to convert a field called "HB_dateadded" like in the subject. i tried Right( DateAdded , 4 ) & "-" & Middle( DateAdded, "3" , 2 ) & "-" & Left( DateAdded , 2 ) but it doesnt work. any ideas?

I just received V6 Developer and after converting some databases over from V4.1 I tried to delete a field in one of them. After choosing 'delete' my Mac crashes giving me an Error Type 3 message. I cannot delete any fields without getting this message. Any suggestions? Version: v6.x Platform: Mac OS 9

is it possible to define a field in a line items file so that after a report is defined you could add into a field before printing the report :?: thanks for any help Version: v6.x Platform: Mac OS X Panther

I have a string that contains various other fields data concatenated. I need to separate the data. I

Hi I have a series of Global text fields that I would like to have auto enter data in each one. Is this possible in anyway? thanks Stan

Hi, I need to create a field repeated for N times, but this N times have to be defined by the user. For instance, in a field named FIELD_1 I insert 5, and automatically FM creates 5 FIELD_2, all of which containg the same content (already defined). Is it possible? Thanks, Version: v6.x Platform: Mac OS X Panther

Hi, I have a whole stack of information that gets uploaded to an ftp site which is really strict on its data format. I have to display in filemaker the amount incl $ and thousand separators so it's easy to read, but when i export it, it is without formatting. Similarly, date formats must be with dd/mm/yyyy I have formatted the fields, but my problem is i have some users who ignore what i say and are causing issues such as: dd.mm.yyyy - since filemaker recognises this as a date, it allows it. I format it on screen to it appears as dd/mm/yyyy but because i can't export with formatting it resorts back to . 500,000.00 - filemaker recognises this…

Hello I am not really sure how to ask this question. I have 200 fields named A1-A200 I have another field called "Entry" I have a script that puts the name of the field in the field "entry" Is there any way to paste data from another field called "cost" into whatever field is named in Entry? For example "entry" becomes the value "a71" and cost is $1200 Is the a way to script or automate the placement of $1200 into the field "a71" or whatever results in becoming the field name in Entry? Thanks Very Much Stan Version: v6.x Platform: Mac OS X Panther

Hi, I'd like to use a field to store Modifier name, keeping a list of the last 5 users who have changed a record. I have tried to use a repeating field, but cant figure out how to move the entries along - ie from one repeating field box to the next - each time a new modification is mode. At the moment, each time a Modifier Name is changed, it overwrites the first entry in the repeating field. Any help on this - including if there is a better approach to keep a history of who changed a record - gratefully received. Dave Version: v6.x Platform: Windows 95/98

I'm sure this is simple but it's driving me nuts. I have 2 fields, <Loan Amount> and the <Percentage Result Field> I want to take the <Loan Amount> and get "%" (.004%) to display in the <Percentage Result Field> Calculation: Percentage Result = Loan Amount * .004 The problem is, if my loan amount is $241,587 it displays the result as $966.348 and I can't for the life of me figure out how to get rid of the extra 8 at the end of the decimal, and it seems to be rounding off, another thing I can't get rid of. Any help is much appreciated. -- Matt Version: Developer v6 Platform: Windows XP

Hi all I want to translate that excel formula =($B$4/1200)/(1-(1+$B$4/1200)^-$B$3) in filemaker but I am lost when I get to exponential...how would you guys program it the fields being: $B$4 = m_achat_taux int

I need help with a calculation that compares the content of three date fields in a related file. This may be the long way around a problem, so I'd like your help, please. I have two related files named Parent and Child Fields in Child are called Type1date, Type2date and Type3date. I need to 1.) find the most recent date in each of the three fields in Child(which may have different dates on related records); and 2.) make the most recent date of the three appear in a separate field in Parent to be used in another calculation. In the Parent file I created: RecentT1date (calc field, date result) = Max(Parent to Child::Type1date) Ditto for Type2date and Ty…

I have an address db that was created a long while back ( ie not related) As such there is a record for each staff member of a company. (hence multiple company records) To migrate to a related solution I need the company to have a unique id number. Is there a way I can do this - ie the multiple company records will need the same ID number. Many thanks Version: v6.x Platform: Mac OS X Panther

I'm trying to create a field that will calculate a non-unique random number between a given range (1-8) for each record. That is, each record out of 125, for example, would each have a random value between 1 and 8 for that field. Solutions?

How can I define a field B that pulls the value of a different field (field A) in the previous record? I want a calculated field - not a script. This is probably elementary, it is so simple to autoenter a value from a previous record - but I want it to calculate. Version: v6.x Platform: Mac OS X Panther

Is there any way to tell whether or not a container field is empty by using a script? Version: Developer v7 Platform: Mac OS X Jaguar

Hello I was using a text field to contain data that was looked up from another file. This means I would have to put the information in one record if there is no way to have a global field. I was wondering if it is possible to have a global field look up from another file or is there a workaround for this. Thanks Stan Version: v6.x Platform: Mac OS X Panther

Hello- I would like to trigger a script by a return key, Is this possible in filemaker through any means? It could be any other single key, but not key combinations. Just asking. thanks stan Version: v6.x Platform: Mac OS X Panther

I have a date field which I have formatted using the "date" menu item. Itshows a date as (i.e.January 24, 1998). I then have a calculation field which contains 2 other text fields and this date field. So, I used the function DatetoText(mydatefield) & text1 & text2. However the date always comes as (1/24/98). How can I keep the long formatting when using the calc field? Version: v6.x Platform: Mac OS X Jaguar

Hello I have two files - One called dealer list which has a picture of every dealer person. I have a second file called registration and when I type in a name that matches a name in the between the two files ( in a relationship) It is supposed to display the photo in the "registration" file but it won't do it. can anyone tell me what I might be doing wrong here. It seems simple enough but it just is not working. thanks stan Version: v6.x Platform: Mac OS X Panther

I have what I think is a repeating field. I set a field to a valuelist formatted with checkboxes. The user can select one, many, or none. When the user selects more than one, the field is populated like this: Value_1 Value_2 Value_5 It has a newline/paragraph entry after each line. The reason I'm explaining this is because I'm not sure if it's a repeating field or not. If I should be calling it sometime different, please feel free to correct me. Anyway, the problem that I'm having is I want to display these values in a portal, and would like the fields in the following format: Value_1, Value_2, Value_5 I'm assuming I can do a calculation …

I have my last name field and use it to calculate the email addresses we use in our office. I need to have a calc that will remove the ' (apostrophe) for a name like O'Neill or O'Shea. Can anyone help? The calcs I have tried either do nothing or completely wrong output I simply want the name to go from O'Neill to oneill, case does not matter. Thanks, Mike Version: v6.x Platform: Mac OS X Panther

Are MS Excel formulas similar to those in FMP? I would like to create a gradebook but can't find any good sites with FMP formula help. And of course I cannot find a book in my area on FMP.. I will probably only need avg, sum, weights (assignments worth a certain percentage of final grade)...I have a book on Excel formulas and I wanted to know if the symbols mean the same in FMP (I know +, -, and = mean the same but what about &, *, etc? Thx Version: Developer v6 Platform: Windows XP

I have discussed this before, but i am afraid i like to need more answers about this... i would like to do this with Filemaker, is it possible without a plugin? I have a database of vehicles. I would like to save document related to each and every vehicle. I want to save the document in a container-field, and not as a link. The database is going to be used on a Windows (Xp) Network. I want the user to clock a button that says "Insert Document". After the user have done this a browsing windows should apear, and the user simply choose the file he/she like to insert in the container-field. Because this database is supose to function like an supp…

I have a field that is text (04-APR-04) that is a date with this format I need to convert it to an actual filemaker date field 04/04/2004. Any Ideas? I got the field to APR/04/04 but it is still text and converting the month to numeral date has become a pain. Version: v5.x Platform: Windows 2000

Ooh, this is a stumper. I hope someone can help! Here are the fields we're dealing with: LastAssessDate = calculated date CurrentDate = calculated, using Status(CurrentDate), not Today function MayHrs = number entered in a related file (represents the month of May) JunHrs JulHrs, etc. for entire calendar year How do I make a calculation that figures out the sum of monthly hours between the LastAssessDate and Current Date? Example: LastAssessdate = Feb 1,2004 CurrentDate = March 30, 2004 JanHrs = 10 FebHrs = 24 MarHrs = 6 The answer I'm looking for is 30. I just don't know how to get there with a calculation. I had the start of a fie…

I'm trying to set up a calculation to auto-enter a shipping date that is 7 days from day of entry, excluding weekends. I've gotten it work except if the day you are entering is a thursday or friday. Since it spans two weekends, it doesn't exclude that second weekend. Here's the calculation I'm using, which I pulled from FMPro's site: Creation Date + shipping days + Int(shipping days/5)*2 + If(Mod(shipping days,5) +DayofWeek(shipping days)=7 or Mod(shipping days,5) + DayofWeek(Creation Date)=8, 2, 0) My "shipping days" field is a number which auto-enters "7". Help anyone? Version: v6.x Platform: Mac OS X Jaguar

My company has been using a database for over 5 years now. It is a very simple database used to print labels onto pre-formatted sheets of paper from matching layouts. Until two weeks ago, the database worked perfectly where there is a main page with a field (text_field) and you can type information, set the style of the text (bold or wwhatever) and the size and font and then click on the type of label you want to print (vhs or dvd, etc.) and it would keep those style choices. Unfortunatly two weeks ago, for no known reason, the database will no longer perform this necessary function. Any styles chosen on the main page are not carried over and all our formatting of label…

I have been trying to get this to work and looking back on this forum I saw a few example of how to do this but was unable to make it work. Lets see I need a field to be a Social Security Number field. I need to just type in my field nine number and have to format it automatically with dashes after the 3rd number and 5th. Ok lets just say my field is called

I've searched the web and have yet to find any way to make FM Pro fields display time the way I need to. I'm thinking about developing an event manager that has different sessions during the day with potentially hundreds of events in each session. I would like to have a time related bar across the top that would display: Session Start Time: Date/HH:MM:SS (static) +Session Running Time: HH:MM:SS +Session Ahead or Behind Schedule Calc: HH:MM:SS (elapsed time display so we know if we're staying within the time alotted) Event Start Time: Date/HH:MM:SS (static AM/PM) + Event Running Time: HH:MM:SS +Event Ahead or Behind Schedule Calc: HH:MM:SS (elapsed time display s…

Thanks for reading my question!!! I am working with creating a weekly lesson plan book to use in my class. I have a unique field that I am using for each week( like week 1, week 2, etc.) as I need to keep all info all year long. I am trying to avoid making a layout for every week and would like to set up some kind of field that would import/show the information from week 1, let me edit it and still save it in the week 1 field, then if I wanted week 2 info, using a button maybe, I could see the week 2 info, edit and save it... I've tried using the 'set field' command using scripting and I can see the data from week1 or week2, but can't edit it. Any ideas w…

Hi everybody, I am developing a DB for invoicing. In the invoice line I have the following fields: Description | UnitPrice | Coefficient1 | Coefficient2 | LineTotal LineTotal = UnitPrice * Coefficient1 * Coefficient2 An example could be

Anyone messed around with this yet? I tried loading the template FM7 includes for storing documents. I find when I load in a document, it doesn't automatically populate file size, path, or anything else. This would be nice, is there a way to get it to do this? Anyone understand how FM looks for files you put in containers? Is it in relation to the location of the database file itself? So if I want to copy a database and a bunch of external files to another computer, will they work fine if the folder relationships stay the same? cheers Andrew

I have a date field, and want to set validation. One of the dates they can enter is 9/9/2009. I set validate by calculation to "date = 9/9/2009" but I always get the validation error message no matter how I enter the date. Where am I going wrong? Thanks.

Alright, maybe someone can figure out if this can work: I have a database of solicitations, in which there is a calc field that sums transactions in another database flagged with a particular solicitation name to get a total for said solicitation [sum(Transactions by k_Solicitations::c_CurrentValue)]. This then feeds into a "dashboard" viewer database through a portal, which is obviously a bit of a strain on the system and one's patience... sloooooowwwwwww! I'm trying to come up with a way to create lookups for these calcs, so they display more easily. However, the usual mod-key trigger tricks don't work, since the actual solicitation record is not being modif…

Hi all I have this text field into which I store phone numbers. Entries usually look like this : 751-862-7845. I'm looking for a way to only keep numbers, so the field would now look like this 7518627845...is there a way to do this? thanks in advance :-) Luc Version: v6.x Platform: Windows XP

Does the increased file size of FM7 mean I can now store jpeg images directly in the container fields, or is it still prudent to just include a reference to their location in another file? Version: v6.x Platform: Mac OS 9

Hello we would like to make a button out of a field where we have to add a certain range of prices. I would like the user to be able to click on this field (button) and with each click raise the amount by 5 dollars and then start over. So the clicks would change the field like first click "5", 2nd click "10", 3rd click "15" But since there are only 3 possible entries if I click again it would go back to "5" and so on. Is there some way to do this with the mouse if the field is a button? Thanks for your help STan

Ooh, this is a stumper. I hope someone can help! Here are the fields we're dealing with: LastAssessDate = calculated date CurrentDate = calculated, using Status(CurrentDate), not Today function MayHrs = number entered in a related file (represents the month of May) JunHrs JulHrs, etc. for entire calendar year How do I make a calculation that figures out the sum of monthly hours between the LastAssessDate and Current Date? Example: LastAssessdate = Feb 1,2004 CurrentDate = March 30, 2004 JanHrs = 10 FebHrs = 24 MarHrs = 6 The answer I'm looking for is 30. I just don't know how to get there with a calculation. I had the start of a fie…

Just wondered if there is a way to look up a picture from a nother file. If you have the relationship set with two number fields, Can filemaker lookup the picture and bring it to the second file. Or is this a portal . Function. Somehow , I have to accomplish this. Thanks Stan Version: v7.x Platform: Mac OS X Panther

Hi. My FM database has 3 types of records (Customer, Addresses, Cards) positioned on separate layouts. Is there a way now to find out the CurrentFoundCount and CurrentRecordCount per each type separately? Thanks. Version: v5.x Platform: Windows 2000

Hi, I have a number field named AddendumNum. I want to build a calculation field named MultiAddendum that will copy the AddendumNum and add a suffix with numbers in a series for each new record with that AddendumNum. Example: AddendumNum 04-03b 04-03b 04-03b MultiAddendum 04-03b1 -- record 1 04-03b2 -- record 2 04-03b3 -- record 3 Thanks in advance! Adele

I made a Help layout with a Global Field. I would like to prevent the user from entering data into that field. I tried the "Field Format" and unchecking "Allow Entry into Field" but then the user cannot scroll through the Help section. Is there another way for me to enter the Help info but not allowing the user to change that info... thx

I currently have 8,500 CDs in my Inventory file. Each has a unique serial number generated by FMPro. On the Inventory main layout I have fields called Number of Discs, Number of Tracks and a button where I generate the related songs for every CD(s in a set) for the realated Song File. A portal displays the related songs, artist names, length, etc. The Song File fields include fields for Item No: "Serial No-1" which is just a calculation of Inventory Serial Number-CD 1. Also a field called Track Number.This has worked fine until now. I am in the process of putting my niche CD music business on the web and I''m going to be using an e-commerce package where customers …

Can you automatically add serial numbers to records already created?

Probably don't make sense but I need an ID# that goes up in increments of 1 and is issued to a new record when created. I tried the Serial number thing in the define fields menu but if a record is deleted that number is not replaced. The ID format is PE1, PE2, PE3, etc. thx

I want to close a popup list after the user has clicked on his/her selection. I know that using a tab index this can be done. However, i do not want to use a tab index because then somewhere on my layout there is always a blinking cursor. Does anyone have a suggestion on this or how can i avoid this blinking cursor. Thanks Jitse

Hi I have a need to make a new file from an old file at the end of an event. I have a field called" week number". Is there any way to save a new file ( as a clone with no records) and call it ( name it ) by the contents of the field " week number"? thanks STan

I have, I hope, a relatively simple question but need a little help getting on the right track. I am importing multiple-choice tests into a FM database and will use the DB to score and report on test results. There are over 150 questions in each test and the answers are in the range of "A"-"E" for each question. I need to convert the A to a 0, B->1, C->2, D->3, and E->4 for each question in order to develop a cumulative numerical score. What's the most straightforward way to accomplish the lookup? Thanks, Dave

Hi I have a field in a portal which is selected from a drop down which has the options yes or no. How can I set this up so that if nothing is entered it is shown as yes by default?? Thanks Simon

Oh brother. I have a number field, trying to be efficient - its used in many large dbs, is used in aging calculations so I used a number to keep it space-efficient. It tracks the customer terms. 1 = COD, 2 = Credit card, etc. Cool ... I thought ... But for all displays, I want it to show COD not 1. so i wrote calculation (pretty proud of myself for figuring out i might mention) with Case(Terms = 1, "COD", Terms = 2, "Credit Card", Terms = 3, "Cash", Terms = 4, "Net 30", "Other") But I think a calculation would slow network down more than relationship and I have lots of little things like this to track and if a calculation is created to display each one, i…

Hi there, I'm looking for a simple way to make some words in a text field like an "hyperlink" and thus the user could open a specific related record. I tried some search on this subject in this forum but I did not find anything. So, may be I'm a little bit blind. javascript:void(0) So, thank you in advance for your help,

Hi folks, I've been working on a music class scheduler program and I've run into an interesting problem. I have 10 groups of students (A thru J) that meet on a rotating schedule once a week. Assuming 10 weeks to a marking period and 10 periods per day, I made a grid of 100 fields - 10 weeks across and 10 periods down. If group A meets in period 1 on week 1, group A then meets in period 2 in week 2 and so on. Group B would meet in period 2 of week 1, then meet in period 3 of week 2, etc. So far so good. Fairly easy to auto-calculate. But here's the rub...teachers don't teach in every period of the day. And there's no way to predict in advance which periods they have off …

I am having a problem getting container field images to show up on my layout without a long delay. I have a global field with 50 repetitions. Each repetition holds a reference to a jpeg image. The actual images are stored in another file within the same folder. I have done this to keep the size of my database manageable. The images are called with a calculation: CASE datafield A= 2, get globalfield repetition 2, etc. Does size of the original JPEG have any bearing on how fast they show up on my screen? I am running a MacIntosh G4. Is there a better file format for these digital images? Thanks for any input, Jarvis

I have a numeric field (theDay) that is displayed as Check Boxes with a Value List containing the numbers 1 to 31 that represents the days of a month. I would like to find out if the day from a date field (theDate) has been checked in theDay field. I cannot use PatternCount(theDay,day(theDate)) because if the day is 1 then a match will be made on any day with a 1 in it such as 1, 10...19, 21, 31. e.g. [ ] 1 [x] 2 [ ] 3 ...... would match with 2/3/2004 [ ] 11 ..... [x] 21 ..... would not match with 2/3/2004

Just searched for two hours. Found too much on this one but nothing exactly saying what I need. We need to count how many letters (plus count spaces) in a letter. The body is one field and we need to know how many 'characters' it contains. There is a word count but no letter count. What a strange thing for filemaker to forget. I tried Count but it produces a 1 when it should produce a 46. filemaker help is ... well ... isn't helpful. I have the feeling I'll kick my own butt when someone points out the obvious but I'm out of energy. Linda

Hi Something I noticed today.... I have a separate layout for printing companies and the contacts within in them (which are in a portal and hence aren't all displayed when printing normally - plus im using a 1024x768 display so a4 landscape still prints out normally quite badly) The problem is that if someone has the record open you can't print, is there anyway to either let the user tell the person who has it that they want to access it....or any other suggestions?? Thanks Simon

Someone please help me! I've got a simple database with a date field. Unfortunately, the person who designed the database ahead of me originally created the date field as Text. I realized this error when I tried to do a search. When I went to convert the field to a Date field, everything converted to 1900s (i.e. if the date entered in the Text field was 9/1/03, it now comes up as 9/1/1903 instead of 9/1/2003). What can I do to "mass" fix this. The DB has about 1000 records with an average of seven dates fields per record!! HELP!!!!!

I need to ensure that all text entered in field Userid is all lowercase. myuserid = good myUserid = bad myuserID = bad myuSeRiD = really bad ... you get the idea. I've tried validating by calculation Lower(Userid) but that doesn't seem to do anything. I've also tried If ((Lower(Userid), 1, 0) but that got me into real trouble after I made it strict and didn't seem to work anyway. I've also tried searching the forums but I must not be looking for the right thing because I'm coming up with nothing. Can anyone help?

Hello I have a database in which i have a number of persons. Each person has a score of how many entries he have made in another database (ex John Doe - 11, Mick - 5). Now, I would like to make a graphical "score-bar" representing how many entries the persons have made, meaning John Doe's bar is 11 units long, Mick's is 5 units long and so on. - And I need it to get on the web using CDML! Has anybody got any idea of how I could do this? I have thought about making a calculation field that puts a number of vertical bars in a text field, corresponding to the persons number of entries, but I cannot figure out how to write this calculation. So: John Doe: 11 = "|…

Im trying to find a way to import true vector images from illustrator to filemaker. Is there a way on PC from Adobe illustrator? Everytime I reduce or enlarge a image it gets pretty distorted even with Maintained proportions checked.

I have a relational database called Graduate Applicant Status. In it I have a pull down field listing available graduate programs, which pulls the appropriate program code from another database. My question is, without doing a find for each program (there are approx. 55) and counting manually, is there a way do to a count based on what info is selected from the pull down menu? Any help would be appreciated.

I'm looking for the most efficient calc to validate that a user's entry into a global number field contains only numbers -- i.e., no punctuation marks or other non-numeric characters including spaces. The user should be able to enter a decimal mark (e.g., 22.5). The validation will be performed within a script prior to inserting the value into a regular number field. TIA for your help.

Is it possible to create a simple text field (FileMaker Pro 6), which grows and gets bigger, when I enter text? Let's say the field has only 3 lines, and I enter 5 lines of text. Then the field should become bigger; the other content under the field should move down as well. Is this possible? Chris

Hi all, I am not a very experienced Filemaker user and I'm currently facing the following problem: Our company has an Ethernet network with: 1 PC (Windows 2000) running Filemaker Server 5.5, 1 PC (Windows 98 SE) running Filemaker Server 5.5, 2 Macs (1 powerbook G4, 1 IMac) (MacOS 10.3) running Filemaker Pro 6.0 We have a database in which we insert references to mp3 files (via insert quicktime command). What we need to do is to be able to hear the mp3 files referenced in the database in all the computers in the network (except the one where Filemaker Server is installed). So far were only able to hear the mp3s in the computer where the link/ref…

Hi everybody! I've been browsing this group for quite a while and I've always found lots of useful information. I still consider myself to be a newbie, though. Hence my question: I have a database where one of the fields describes a filename fpr a jpg-file. This field is made up of parts of other fields in the same record (category, subcategory, date, etc.). So I use a calculation to generate this filename. The filenames can look something like "ALIBEC01REF010204.jpg" Is there a way I can check that the generated name is unique? If I choose the field type to be unique, I get lots of errors while entering the information. Can I validate the field? Any help on this mat…

I was debating whether to post this in the Emailing forum or here, but it made more sense from a Define Fields point of view... I have a database that consists of multiple related line items. Each of these line items will eventually get plugged into an HTML table as a table row. Using SMTPit, I then use one giant calculation field that combines a bunch of global text fields containing "raw" HTML and calculation fields that convert the data fields to HTML format. The result is a beautiful email. From a FM point of view, I'm looking to make a calc field in my parent database that concatenates related calc fields. For example, imagine these to be the calc f…

This is the code I have for a Text calc field GetRepetition( Quantity, 1) & "-" & GetRepetition(item,1) &"

Hi Guys, Hopefully a really easy question for you experts. I have a repeating field, called stages. It has 4 repeating values. I would like to auto enter all for repeating values, i.e. repetition 1 will have the value 1, repetition 2 will have the value 2 and so forth. When I click on the auto enter value, it only allows me to enter the value 1 in repeating field 1. How do I populate, repetition 2,3 and 4? Kindest regards Jalz

I have a layout with some fields on it and I would like to block all other field if the status field has been filled in with concluded. After that no other user should be able to change any data on the layout. I

Would like to have our company logo as the background fill on our forms. Is there some way to add a custom fill or use the logo for the background with fields inserted over it. Thanks

I am not exactly sure where to put this question, or maybe even how to word it . I am building a database for my cabinetshop and it has a lot of different components (existing & yet to exist). My objective right now is to develop small stand alone solutions with the ultimate goal of weaving and interconnecting them later. This database makes extensive use of container fields. In order to keep the file size manageable, these container fields typically just store a reference to an image, rather than the image itself. I have, for example, a file that tracks job costs. This file includes references to vendor files and labor files. The material files con…

Not sure where to post this please forgive if in wrong place... Have Products file. right now we store the Unit Cost right in each product record. But it's a guess. Then that cost is hard-coded as part of the lineitem when sold. All fine and dandy. But it's never accurate. See, we purchase 100,000 boxes and 50,000 cartons of bubble wrap. I'm trying to figure how to attach our ACTUAL costs onto products. It seems that I want to track inventory on boxes and bubble, etc. also but owner thinks that's not possible. Yeah, it'll be tough. Question please ... how do others try to match and handle their Cost of Goods Sold? Accountant is being an Accountant (p…

Ok, I want to insert a merge field <<Notes>> into a layout. I thought that the concept of a merge field was that it would expand to fit the amount of text in the field, that doesn't happen. The merge field stays the same size regardless of the amount of text in it? Any ideas if I am doing something wrong, or do I have the wrong idea on how/what a merge field can do. thanks for the help

Thanks everyone for the "break name into three parts" help I have a problem with the city state zip field. I'm trying to parse data from one field to three fields City State and Zip The data looks like this: Any ideas? Here is what the data is like: Lake Oswego, OR 97201 Portland, OR 97201-0000 Oregon CIty, OR 97830 Gresham, Oregon 97208-0001 West Linn, Oregon 97208-0001 Problem is Cities can be one or two words and Zip is one or two words. Any Ideas?

I have a database I've been using for several months, it has several hundred records. I now need each record to have a unique ID so Iwant to add a new field to this database. However, I need to generate a unique numberical ID for all of the prexisting records. How do I do so? For that matter, how do I auto generate new numbers when new records are added. Thanks!

Hello, I'm new to the forum and to filemaker. I have been learning quickly, but I have not found this issue covered yet. I would like to create a set of radio buttons "LOCKED" and "UNLOCKED" to control access to changing field data in my project. I would like it to default to unlocked when I start a new record, and then automatically switch to locked when I select to save this record and start a new one. Any help would be great.

I swear this has worked for me in the past but for some reason it won't work. I don't know what I have wrong ... Invoices joined to LineItems on Invoice# which is text similar to 0777736. Field in LineItems called NetTransAmount (number) which looks like: 26.47 -3.28 44.80 -58.27 I created a calculation (number) in Invoices with: Sum(LineItems::NetTransAmount) These lineitems are a merge of several dbs from an old DOS program. But my totals calculate all lineitems for each invoice except for the last one!: I created a new regular number field and set NewNumberField with NetTransAmount and sum'd that field - still nada. Won't gra…

I have a pop-up list fo data that starts with Please make a selection... I want to make it so that this can not be one of the submited answers. I can not figure out how to return an error when this is not changed to one of the choices in the list. any help would be very appreciated.

Hello all, Rank FM amateur here. You guys seem so advanced with this stuff; I hope you won't mind giving me some suggestions. I'm making a simple DB (hopefully) for a physical therapy practice. We see the same patient for multiple visits, often repeating the things we do from visit to visit for awhile. Therefore, it would be very useful to forward various field entries from the previous visit record as default entries for the current visit record. How might I do this in a simple and bullet-proof way? Thank you very much. Mike S. PS: I've been using FM for about 3 weeks--I'm afraid a broad brush or jargony explanation might totally lose me. T…

Why am I working on a Friday night? Alas. This can't be too hard but my brain has petrified - like wood, not fraidy cats! User inputs a booking date in field BookingDate. I would like a calculation to default the InvoiceDate to the last date of the month. So I pull the month out of the BookingDate and of course no "last day of" command. How about find first date of next month, then subtract a day? Good idea, but how to find first date of next month? Any ideas? You would have my forever gratitude! Kay

Is there a way to force someone to enter a value in a field before the record is saved? (I have a dropdown value selection in a portal field and I want to force a value in it before it is saved?) Any ideas? Thanks Simon

Hello friends, I was hoping to filter a couple of fields so that it automatically has certain characters enter themselves (if possible). I have FMP 5.5. Specifically I want to have dates entered like: 2/27/2004 And have the slashes come up automatically. I'd also like to do the same for phone numbers with hyphens. Is there any way to do this in order to save keystrokes? It's my first attempt at using FMP but I'm seeing that it's pretty powerful as an organizing tool. peace, Mike [email protected]

i'm creating a "drop board" type thing to play various short .wav clips during our youth services. I wanted to store these in FM so i can index them easily and find what i need quickly. Oddly, though, it seems when i play the files, they are cutting off the first half a second or so of the clip. It's not everytime, it's sort of random. has anyone else had this problem? i'm on Mac 10.3 with FM6 Thanks jeremy

I know there has to be a way to do this but I can;t figure it out! I run a very large embroidery shop. recently we took on a new customer that requires us to cross reference our thread with theirs. What I am trying to do is figure out a way that when I type in "their" thread number into a text field (or number field, whatever)our thread number pops up in a different field, that way I get automatic cross referencing. The problem is I can;t figure out how to do this! Any help would be HUGELY appreciated. Please, this is very important for me to figure out. thanks, Steve

Hi- I have a product image folder that I've created in Photoshop that I'm currently importing into filemaker, my question is when I import it, the photo's are not all displaying in the same size, but it's fine in Photoshop. Ultimately I just want these images to display at 100%, and right now some are 30% and some 120% (or that's how it looks) Is there a global setting or function that will control that?

I am having trouble extracting a persons name into three parts First middle Last. Data is like this: Smith, John Jones, Fred Johnson James H. I use leftwords to pull the last name but if I use RightWords for the First name the Middle Initial gets in the way. I would really like to gather all three fields. First middle and Last.

Hi, well i

Hi, I'm a new FMP user: I would like to create a db in which I insert a number (N) in a field and automatically N checkboxes are created, with a name from 1 to N. For instance, if in the FIELD1 I put the number "10", I would like to obtain 10 checkboxes, named from 1 to 10. Moreover, is it possible to convert number to text, like 1=A, 2=B and so on? And, finally, how can I associate an action to a single checkbox, like, for instance, showing me a sub-category when I select one particular checkbox? Thanks a lot, Ciao

First off, I hope I'm posting in the right forum. I'm totally new at all this. Ok. I'm stuck trying to define a field. Here's my problem: I'm providing a service with a cummulative 30-day warranty. If further service is necessary within, say, 14 days, I provide that service for free. However, if further service is necessary within a further 21 days after the 14 days, then I charge again for my service since the cummulative number of days has now exceeded 30; 35 days, in fact. How do I define one or more fields so that the cummulative count is reset to start over again from when I again charged for the service? I have a Days of Service field defined to subtract O…