Calculation Engine (Define Fields)

This seems like it should be easy, but I can't seem to get it. File 1 contains a portal showing the "program" text field from File 2. Entries are from a predefined value list. I need to create calculation fields in File 1 to be able to identify records that have match my search criteria. Example: PatternCount (<File 1to File 2 relationship::program>, "family literacy") returns a 1 only if Family Literacy is the FIRST entry in the program field. How can I make the calculation return a 1 if ANY entry in the program field matches my search? Thanks for your help! Mary Z

hi, I need to add in image as button in my program, just want to ask which type of format is more suitable, no need to print out. Because i try to create some picture and add in, the picture will change to no so clear(pixelate) .I found that the image in filemaker template is very nice, even zoom in also look clear, what is the picture type. Also want to ask where can i find(or buy) the picture/icon/button just look like Mac icon or the image in fm template? henry

I'm trying to create a field to sum a number field for a found set of records less the current record. For example, lets say I have 10 records in a found set and I want a field that will sum 1-9 and not 10. I've tried a calc summing all 10 values minus the value in the tenth record, but I cannot get it to work. The result will go on a form letter. Help anyone?

Hi ... I need to calculate the age of a person from their date of birth (DOB). I have tried a few calculations from previous posts but have had no success, and not sure why. I also need to know the number of days till their birthday .... I am not only after an answer to the calculation but the how and why, as I do not fully understand date calculations. many thanks Trevors

any one help?? as an example i have 20 records, within this 2 different products (10 of each) defined by a field (product code) there is 2 other fields cost per unit and sales value per unit. I want to have two summaries of the total or avarage of these two fields for each independent product. Thanks.

How do I get my 10 digit string of number to insert the (###)###-#### format?

I don't know if this is even possible, but here we go ... I have a single-user database ... it is a very simple alumni mailing database with names, addresses, phones, e-mails, etc., and year of graduation. At various times of the year, I have various classes preparing for their reunions, and the class reps who are organizing everything would like to be kept abreast of address changes for their class as they come in. As organized and with it as I'd like to pretend to be, on some days when the address changes come in fast and furious, I forget to pay attention to the year the individuals graduated and to whether or not I should be forwarding the change on to the class rep…

Ok, Everyone has already helped me in the past with a Logical function but this one is more in-depth. I've been looking on the forum for a similar example but out of luck. Hopefully someone will be kind enough to spread their FMP knowledge on me again. I'm having a hard time grasping the formulas. I got a simple If() statement going, but thats about it. I need to search for some resources. Here's what I have: Estimate 1: $$$$$ Estimate 2: $$$$$$ Estimate 3: $$$$$$$ Selected Estimate: Pop up value list window with "estimate 1", "estimate 2", "estimate 3" Estimate Cost: Trying to pull data from estimates field corresponding to selected estimate. To…

I try to insert in a layout a pdf file. It's an image of a fiscal italian document and i want to use fmpro to add fields with automatic calculation. In the pdf file the image is ok, in fmpro is bad. Can you help me? Massimo Sorry for my English

I need to have a calculation field display text and a time stamp. The calculation field I have created works fine for AM times but not PM times. The PM times always display in 24 hour clock format. How can I change this. I swear I have done everything right...please ...prove me wrong. Bill

I'm sure this is pretty straight forward, but my brain has sadly lost its agility.... I need to create a calc field that concatenates various text elements, some static, some variable. Easy enough. The status elements are quoted into the concatenation, and the variable elements come from fields. For example: "Please say hi to " & "NameFirst" & " " & NameLast & "for me." My problem however is when any of the static elements have quote marks (") in them. This happens for example when I need to concatenate some Applescripts, or HTML, etc. etc. For example: do shell script "curl http://www.yourdomain.com/brochure01.pdf > ~/desktop/s…

First of all, sorry for my English. It's the first time I post. I use fm since 1998 and now I'm trying to applicate fm to my job (fiscal assistant). I have to print a report list with in the bottom of each page the summary of a numerical field of the record in the page and the previous pages. Can You help me? Massimo

How would I define a number field that will automatically go from 1 --> 200 without having to type every number in? I want to assign the numbers for the students in the school. Number 1 would be in the beginning of the alphabet. Thanks in advance.

I was hoping someone could help. I want to be able to run a report based on a due date field i have. This field is used to keep track of when our members owe for there next membership payment. And i wanna be able to run a report on who is late with there payment. Thanks for any help you can offer.

URGENT: Value list selection related to FIELD #67216 - 05/15/03 06:10 PM Attachment (1 downloads) Edit Reply Quote Quick Reply I am in the process of setting up a costing (labour)sheet but have run into a problem i cant solve as yet. As can be seen in the ATTACHED file, i require the [class] field to have a relationship to the [supervisor] field/s AND the [beltman] filed/s, So that after selecting the [class], and then inputting the hours on the job the costing FIELDS then calculate the {hours*related rate}. Any calc/relationship solutions to this??/ Thnx Corey.... Costing for labour.zip

Here's one I'm sure to feel stupid on . How can I keep the original field format when doing a copy/paste? Ex: Copy text formatted as Verdana but when pasted it pastes as what the field is formatted to be Times New Roman. BE NICE Michael

OK, this one has potential to be very embarassing... I have a text field which displays JUST fine almost everywhere I put it and no matter how I size it on different layouts (the text starts in the upper left hand corner, and continues down the text box, depending on the size, on the next line - you get the picture). Now all of a sudden on a new layout - no matter how I use the formatting icons or check all the other dropdown menus under field format and text format - it INSISTS on having the text on the left but CENTERED in the box - ie. if I've made the field large to accomodate records which have long decriptions, the records with short descriptions have their descr…

Hello, Is there a way to change the color of text in certain fields after a find is performed? I've tried finding the records I want & then using the replace feature but this only works if the text is the same. I am working with a housing database. When I search for rooms in one area, I would like those rooms found to be color coded. For example, If I search for rooms in the east wing (which is a field called area) I would like the room numbers(in the room numbers field) for the east wing rooms to display as red. If I search for rooms in the west wing,I would like the room numbers for the west wing rooms to display as blue. I have 2000 records and about 10 differ…

Hi, i have to produce some lists from a database ranked on number fields - like the number of branches a retailer has. if I put in '@@' on the layout, it will give them a ranking number, but I need to have them ranked equal if two or more have the same number of branches, like 19 20 21 21= 22 etc Is there a way i can do this? regards, jeff

A FM Forums User posted to following question: "I need to create a script that can randomly select 15 records, but I don't know how. Please help me." ----------------- My response was: Please let me know if the following would work. Will the Status(CurrentRecordNumber) update since it is stored? Create a global text field called, for example, "Linker" Create a text calculation called "RecordNr" with the following calculation: Status(CurrentRecordNumber) Create a relationship Linker::RecordNr. We'll call this relationship R1. Create a script as follows: Clear [select, "Linker"] Loop Insert Calculated Result ["Linker", Round(Random* Status(CurrentRecordC…

OK, not sure how to do this, but here's what I need. I have the following fields: BALANCE INTERESTRATE MONTHSTOPAY So if I have a balance of 2000, interest rate is 9% and monthstopay is 6, what field calculation do I need in order to calculate the resulting monthly payments and/or the total payment, assuming all payments are made on time?

Hi all- I'm trying to take 4 fields (Prefix, FirstName, MiddleInitial, LastName) and combine them into 1 field "WholeName." Below is my calc: If(Prefix <> " " and MiddleInitial <> " ", Prefix & " " & FirstName & " " & MiddleInitial & " " & LastName, If(Prefix <> " " and MiddleInitial = " ", Prefix & " " & FirstName & " " & LastName, If(Prefix = " " and MiddleInitial <> " ", FirstName & " " & MiddleInitial & " " & LastName, If(Prefix = " " and MiddleInitial = " ", FirstName & " " & LastName, "Check This Contact Name")))) It ends up returning a space before the first name …

(edited to add some more info...trying to clarify my problem) I have a report that has no body - just multiple subsummaries, in a large line item file. Every record in this file is an line item from a timesheet - related to both a staff member (who exists within a department and within a company) and a project. The Subsummaries are: Company Department Staff Member Project Name All of which have an hour total and a cost total, using summary fields. I want to also include a summary of the count of projects. So a staff person clocks 36 hours, costing $720, and worked on 7 projects total (each project also has a break-dow…

When I try inserting a CMYK 400 DPI jpeg into a container, the image doesn't show up and all I get is this error message in the container. Does anyone know what I'm doing wrong? I change the image to RGB and it stil returns the error, and I shrink the image to 72 DPI, it works, but that's unusable for what I need to do.

i'm trying to design a form that can be filled out to provide quotations for projects and am having trouble wrapping my head around the basic design. i have some experience developing relational databases in web applications but am new to FM Pro. i want to have a form with a series of checkboxes. each checkbox corresponds to an option. the user checks off which options are desired and prices for all checked options are added together to get a total price for that project. i was envisioning something like: Database 1 - Options (Option ID, Option Name, Price) Database 2 - Form (Option ID, Total Price) i would create a relationship based on Option ID…

Does anyone know of a way to hide a button if a text field is empty, without using 2 different layouts? Many thanks Eddy.

maybe someone can help me with this problem i have a global field called global color which is a container 3 repetitions ,a field called global color value which is also a container ,a field called price paid which is a number field and a field called value which is also a number field what i want to do is have the global color field place one of 3 colors into the global color value field based on if price paid is equal to value, less than value,or greater than value i can do it as a script. see example but as a calculation i am a bit lost for some reason global color = container 3 reps global color value = container price paid = number field value = number fi…

HELP! I need an invoice detail line to "repeat" and also able to retain modifications after lookup. Portals and related fields are recomended however my books say that portals do not retain modifications AND I can not get them to repeat unless I spec "repeating field" in field definitions. I know this is simple but some specific help would be GREATLY appreciated! JW

hi, all. i have two databases: abc & xyz. I will use abc to gather data that will come from radio buttons 1-5 for about 200 questions. i then want a button at the bottom of abc that when clicked will submit the data, then open database xyz, which is a series of essay q&a's. i need to keep the databases separate b/c i will be exporting this info to excel for others to use and they do not want overly large rows which would be created by the essay questions. this is being done over the internet, so it would also be nice if the person taking the quiz would not have to re-enter the password to go from one database to another. any quick help will be appreciate…

Hi everyone! Is there someone who could send me an example of a calculation field that acts like a summary one using the SUMMARY function? I tried to use that function but my calculation field is always empty, even if I sort all records with the correct field... Thank's a lot!

Hey everyone, it's been a while since i've toyed around here in the forums. Anyway, I have a question now. Is there a way to connect a camera to the computer and have FM acquire the image from it? I'd also like to be able to either set a default size, or scale (320x240) is the preferred size. Currently we use a digi-cam, take the picture, use photoshop to resize, then import into FM. We'd like to save a bunch of those steps and go directly in. Any help is appreciated. This is on a windows machine. -j

I have a "Modified By" field, but would like it to keep a running list of everyone who has modified the record. Can anyone tell me how to do that? I'm using FM 5.5 for Windows. Thanks.

Hi, Has anyone ever set validation up on a field containing National Insurance Numbers (UK)? If so would you mind sharing how you did this please, whatever I try doesn't seem to work! It either does not validate correct numbers or validates incorrect numbers! Many Thanks Ed

I'm having trouble getting a field to automatically update when other fileds change: specifically, I need to generate username and password fields using calculations based on first name and surname fields. The problem is, when a new record is created, those fields are blank and the calculation doesn't automatically update when they're filled in... How can I fix this? Do I have to write a script or do I need to perform some sort of lookup? Any help, most appreciated...

Hi all, This shouldn't be a tough one for you but I've been going nutz over it. I have my visual quickstart book and I've been browsing the forum but I'm still kinda confused. Basically, I have billing address info and shipping address info. I have a field that says "shipping same as billing". What I'd like to have happen is that if someone clicks the option for "yes", the billing field data automatically echoes in the shipping address fields. Otherwise, the user enters it manually. I can't figure out if and case statements. I'm confused what data goes into what section of the calculation. From what I've read, it seams like the case function is more powerfu…

I need to know if there is a way to format a field using a calculation that would resemble the "format field" commands for money. I need my calculated field to return: $123,456.00 My calculation right now only returns: $123456.00 (which leaves out the comma). The formula that I have is: "$" & [fieldname] & ".00" Does anyone have a suggestion on how I would insert the comma in the proper place? You might be wondering why I'm not using the field format. I need this calculated field to display in my web page. Web pages do not acknowledge FileMaker field formats. Any help would be appreci…

I have a dilemma. I have always been thought to show stock levels as a calculation. But I have a problem. I have a system that will not have a lot of quantities. In fact over half the items will be unique. That means that there will be only one item which will be put into stock then sold and that is the end of it. My question is, would I not be better off in this case to just have a stock quantity field that is updated. This will allow the system to work faster whenever those stock reports are needed. I reckon that there will be 50,000 records within a 24 month period. If I start putting in a movements file this will have at least double that because even for the …

I am working with credit card numbers. I want to limit who can see the entire number, and so after it's been entered and validated, people should see only the FIRST 4 digits, plus 3 dots, plus the LAST 5 digits. I have defined a text field calculation so: Left(creditcardtext, 4) & "..." & Right(creditcardtext, 5) Here's what I get: 1234123412341234 the original credit card number, in number field but when I use the Left and Right functions: 1234...41230 Left(CCnum, 4) & "..." & Right(CCnum, 5) so, I thought I'd check what the number field looks like as a text field. Sure enough, 1234123412341230 CCtext calc'd …

want to set up a REPEATING (25) Field [sITE] so that it is a BUTTON. Clicking on a specific Repetition enters a TEXT Value that was first inputted into anotherFiled [sITE NAME]. EG. SITE NAME is bhp; the Repetitions in the SITE field are persons names; If i click on say the 4th, 9th and 18th REPETITIONS of the SITE Field, rather that having to manually enter the SITE NAME (bhp in this case) into the 4th, 9th and 18th Repetitions , i want to have this value entered AUTOMATICALLY into only the repetitions i click on. Any help would be appreciated. Corey....

Does anybody have a script for converting a hexadecimal number into a decimal number. thanks

I am developing a job costing timesheet application where techicians enter their time and show how each block of time is applied to what job and general ledger code. The main file is TimeSheetEntries.fp5, where each block of time is a separate record (no repeating fields). If it matters, this file has a serialized, non-repeating key field called EntryID. I'd like for the default entry for the "StartTime" field to be the "EndTime" field from the previous record, to minimize the data entry burden on the technicians. Thanks in advance for the help.

1. I created a text field named [Comments] 2. Formatted [Comments] field to be check boxes using a value list [Remarks] 3. Set up a calc field named Comm2 as text field using the following calcuation.... [color:"red"] Substitute(Comments, "

I'd like to have two layouts for a record. One edit layout and one view layout. In the view layout, a user cannot change the contents, only view them. However, I've run into the problem that one cannot scroll in a locked field. Is there a way to display the contents without cutting off exess text?

I have a field sales tax. I need a good calculation for this field. The calculation has to say: If the description field is occupied and the dealer license field is occupied then don't charge sales tax, or if the misc description field is occupied and the tax exempt field is occupied then don't charge sales tax or if the field "sales tax" which is a value list with yes/no and the answer is "No" then done't charge sales tax other wise add the price plus buyers fee together then times by .066. case( not isempty(t_desc) and not isempty(t_dealerlic), 0, (not isempty(t_miscdesc)and not isempty (t_taxexempt), 0, t_salestax = "No", 0, (n_price + n_buyerfee) * .06…

I would like to customize my calculations, in that, whatever I type into a text field, I would like that to be used as the calculation in another field Example, I have four fields: A_1 , A_2, B_1, C_1 I would like to enter the equation 'sum(A_1, A_2)' (or any valid FMP equation) into the C_1 field, and have the B_1 field display the result of that equation. cheers kevin

Hi everybody, I would like to make symbol buttons like open, new, find, back buttons... in Winwords or in Filemaker. I don't know how to create these symbols in buttons. Could you show me how to do these buttons? I attach a button I want to do like this, for example. Thanks and hope to get your help soon. Snow

Hi, We have multiple images on a filesystem and would like to reference/display these within filemaker (as referenced via a filename field within filemaker). Is this possible? Is troi the way - for multiple users? J.

I'm trying to set up date calculations for our mailings. I've looked at the other posts on date calculations and didn't see a solution for what I'd like to create. I want to set up our database to give me a found set every Monday (when our mailings go out). Here are the fields I am working with: InitialDate: when we first hear from someone Letter1Date, Letter2Date, etc.: the dates when we send our weekly mailings, which I want to be on Mondays Saying "Letter1Date=InitialDate+7", "Letter2Date=InitialDate +14" and having it formatted as a date gives me one week (and two weeks) out, that I figured out. What I want to have happen is to have that date then…

Greetings, I am running FMP 5.0v3 on XP Pro. I have an invoice database with 2 portals, one for line items and one for payments. To calculate the total of the line items I use the aggregate function SUM(Relationship::Field). I use the same method to calculate the total of payments. The TotalPayments field gives the right amount except that if I put my cursor in the field it goes to zero (to nothing if I specify not to evaluate if the fields are empty). This is true only when I click on the TotalPayments field after clicking on the background (no focus), if I first put my cursor in another field then click on the TotalPayments the total remains correct.…

I have a need to produce database which shows the cumulative time in seconds between a number of events (about 10-30sec each) each stored in the same field in different records. I know I can use a summary field to show the running cumative total of seconds from the start but I need to also show the individual "lap" splits between say for example the value in record 2 and that in record 1. Then the difference between the value in record 3 and that in record 2 etc. Right through to the end of the file such that irf I add up the individual lap times I will finish up with the total time. I cannot see how to take a value out of a field in record 2 and substract value in reco…

Hello. I am working on counting symbols in a field including "&#8710;"(a triangle),""(a square), and "0" . I used the calculation below in a field to count the "&#8710;" now i need to get a total for each symbol. Would I expand upon the calculation or move to a script. The triangles and squares do not show up in this post. Fairly new to this. Thanks in advance. PatternCount (ling_2,"&#8710;")>0 I have a total on the found set in a summary field. norm

There are various ways to calculate work days between 2 dates that have been posted but I need one with a different twist. All of the calculations I have found assume that date 2 is after date one. What if date 2 is before date one and I want it to appear as a negative. Here is what I am trying to do. A project has a target date. It has an actual completion date. If the actual date is before the target date(early) I need it to show as a negative if it is after the target date is should be a positive. This shouldn't be that this hard but every time I reverse the calculation or try and multiple by -1 the calculation fails if it spans several weeks. …

i'm wanting to count the number of rows in a portal for a line item type invoice. we only have one "product", so each line of the portal needs to be mulitplied by the number of rows in the portal. any ideas? mucho appreciado. josh

One of the best things I learnt from FM Forums was to use the CASE function instead of nested IF calculations. Recently I have been wondering - their is no reason to use the IF function ever. For simple calculations that would require only one IF function I now just use the CASE function. Logically there is absolutely no difference. As I do not how FM interprets data I was wondering wether IF may be better than CASE in these situations. Any ideas?

I am making 5 separate invitations per page, and I want to print one name per invitation. Thus, I will have 5 different names per page. Since I have a list of 100 names, it will take me 20 sheets of paper. I can?t MailMerge, because it only cycles to another name at each new sheet of paper. There must be a way to print my list, maybe with some kind of calculated field or value list. How do other do it? I?m stumped. Thanks. Ted

I have an employee file. i have a DATE OF HIRE field and a CURRENT YEAR field. I want the Current Year field to show what year of employment the employee is in. so, if it's between the Date of hire and a year from the date of hire , then it should say 1 in the Current Year box. Once today's date = the date of hire + 1 year, then the Current Year field should change to say 2., and keep counting every year thereafter. How do I do this? Thanks

Hi All, I have a text field ... 270123 ..when I convert to number using texttonum then I got 27123. Because I would like to get next number of it by increasing 1 then I would like to have 270124 ...Is there a way to get from text to number by having 270123 instead of 27123 ? Thanks

Can i make a calculated field appear in a layout only when it contains info or a certain number? ie: Count(sku) Results ">=2" will show a picture or simply the result but anyhting with a "1" will not appear at all?

I have a fairly complex form with two date fields that between them define a period. Both have defaulted values but the latter date may vary after extra data is entered on the form. Since the defaulted value doesn't update itself once created I've devised what seems to me to be a convoluted and clumsy way to update the field afterwards with a script that is triggered by a button, but it demands the field be off the form. So I have a calculation to display the field value on form. This obviously isn't editable, which sometimes it needs to be. All in all I'm looking for a way to have an auto-updating, defaulted field with a stored value that's editable…

Hi All, I have a database with two fileds, field one is a repeating filed for number input. Field two needs to add up all the numbers in field one and display the total. Anyone know what the calculation should be? Thanks BW

I have a TOTAL figure field (totals) and a (Difference) field, trouble is i want the (Difference) figure to be CALCULATED from the PREVIOUS entry of the (totals) field. E.G Last months RECORD (March) the Balance was $625, this month (April) it is $500. THEREFORE i want a CALCULATION that will pick up the PREVIOUS months (totals) figure of $625 and SUBTRACT the current (next) figure of $500, and place the RESULT of -$125 (in this case) AUTOMATICALLY in the (Difference) field. I tried a SCRIPT to get this to work, but NO Good either. Any help will be appreciated. Corey...

I created this attached dB because I got tired of recreating the same calc for different solutions. I hope you enjoy.

Hey Folks, I have a series of fields which, when a "flag" is set, must be filled in. I'm doing it with "Validate only if field has been modified" UNchecked since it's setting the flag that determines whether or not the user is locked in the record until he fills everything in. The validation calculations look like this: not IsEmpty(RequiredFieldA) or Flag <> 1 not IsEmpty(RequiredFieldB) or Flag <> 1 etc. So, if flag = 1, the field must be filled in. Otherwise, go ahead and leave it blank. Flag gets set and cleared via various buttons, scripts, etc. all being called while in the record. I'm in a record, I set the flag…

maybe a strange wish : I want to overlay two containerfield that both contain graphics. Now i want to preserve the transparancy of the graphical objects. So object 2 is on top of object 1. Object 2 is partly transparant (at least the gif file is). How can i overlay these two containerfields so that i can see through object 2 (partly object 1) Thanks for any siggestions. Jitse

I know global calculations do not exist but this is what I would like to do. I have a database of 500 individuals with mainly contact information. I want to be able to divide these individuals into about 30 groups, each group having one leader (who is also part of this same database). I have already figured out how to do this using global fields on a separate layout. However, for now as I am scrolling through individual records, if I want to find out who a particular individual's leader is, I have to go to another layout where I manually search for the leader from a list of 30 leaders. I want the leader to show up on each individual record so that as I am scrolling I…

Hello, using the ValueListItems () design function i gathered items from two valuelists into two calcfields, every item separated by a paragraph (linefeed!?) from the next in each field. One field contains quotations from a text, the other page numbers. What i want to do is create a third (calc?)field, which combines the contents of the both fields in the way that it takes the first line of the first field, concatenates the first line of the second field, creates a new line, then takes the second line of the first field and concatenates the second line of the second field and so on. Unfortunately i do not find a text function that simply reads the first line of a…

I'm a new Filemaker user and thought I was a reasonably intelligent guy. I've scoured the relatively poor Filemaker manual and online help files as well as the FM Knowledge base and can't find the answers so I'm posting here hoping some kind, FM veteran will take pity on me. So, here's the deal. I've been trying to create a field that automatically enters and displays the Year in four digit format. I've created the field, made it a date field, and then tried a number of options including "Calculated value" and then selecting "Year (Date)" as the date function and get the lovely message "This filed cannot be found". The above issue is only part of my problem…

Can anyone tell how to save a user created color to the fill and line color pallettes (the ones in layout mode) fro FileMaker Pro 6 running on OS9 Mac? I figured out a way to mix my own colors on the Mac, but can't seem to find a way to save them, so I keep having to write down the numbers and re-enter them. Any help would be much appreciated.

I'm just wondering if anyone has come up with a solution for flashing (due to redraw) merge fields that have transparent backgrounds and are positioned over a graphic. I have the same issue as was discussed in this thread. Unfortunatly I can't give all of my merge fields the same color background, as Kennedy suggested, because the graphics they lay on top of contain color gradients. Any new ideas? Thanks

I have a container field that I need to be able to view the image full size (screen resolution), but I need to be able to scroll down if the image is too tall to fit. When I try to add a scroll bar to the field, either I get an error message, or the scroll bar disappears. Does anyone know a work around or a way to do this??!

Hello, I was wondering if someone can help me. i am trying to keep track of date change on database i am creating. Basically this database keep track of another database when changes are made to any of the fields. i got some of the fields to work but not the fields which are date. it does return the right info from the date field. this is my calc i have: If(lookup key cal = 1 & incrementer, "", "") & "Field:

Hi there, I am trying to create a menu based on the following: I have a catalog with a description field and a code field. There are lots of items, but they can be categorized, so for example, I have ( - description - code) - Red Door - 111 - Big Door - 222 - Glass Door - 333 - Wood Table - 444 - Steel Table - 555 etc... In another FM file, I also have a browse_description field looked up via a browse_code field. What I did so far was a menu with all the codes from the catalog (using a Value list, code field from catalog file). What I'd like to do is be able to enter a small text in browse_description so that …

Hi! I have a main db that houses student records and a relational db that houses assessment scores. I import all the 2nd graders names & id to the layout for a particular assessment. The assessment results are in a value list with 5 text choices. I need to then count all the first choice and turn into a percentage, then the 2nd, and so on. I tried to have two fields for the "performance" results "performance" & "performance#" and then nest if statements If(performance, "Achieved the Standard","1") But I don't think I was getting it right somehow. (I have this calculation if I separate the one field into 5 fields -- but the calculation is only co…

[color:"blue"] Hello .... folks ....Its been a while sence i've posted anything, so here it goes. I have Field A (date field - autoenter Creation Date) and Field B (text)... I need (: to have the number of days past the creation date entered in it (1, 2, 3, 4 ext) I can't decide!

I want to assign and ID number to every record in the database. I want it to look like this 04202003001 04202003002...etc. The first 8 numbers represent the date and I need them to change with the date everyday to reflect the date. The last 3 numbers are just sequencel and I would like them to reset veryday back to zero So I can start the next days record looking like this 04212003001, 04212003002..etc. How do I make this happen? Thanks in advance.

In order to properly calculate student GPAs in a report, I need to total a field called 'credit hours' and a field called 'hours' and divide them as needed. student-----CH---H student 1 - 16 - 4 student 1 - 04 - 1 student 1 - 04 - 1 Student 1: 24 - 6 (24/6 = GPA of 4 for this student) student 2 - 03 - 1 student 2 - 12 - 4 student 2 - 08 - 4 Student 2: 23 - 9 (23/9 = GPA of 2.56 for this student) Class Tot: 47 - 15 (47/15 = classGPA of 2.86 for this class) The problem I'm having is with the class GPA calculation (shown only in parentheses above). I need to take the total CH and divide it by total H when the class break happens in the report. …

Hello, I have a series of items represented by a text field with vertical check boxes. I want the items / boxes that are checked to appear as a string of horizontal text. Currently they come out only vertically, with a return charcter after each one. ie ONE TWO THREE How can I do this? -Evan C

I need to add up symbols in certain fields. For example how many &#8710; (triangle if you do not see it) are there in ling_3 in a given found set. Would that be done as a script or field definition? Could someone help me get started. Thanks in advance Norm

I am doing a character generator for a roleplaying game in FM6, mainly for testing the randomizing features. Using the Int(Random*6) I am able to simulate a normal 1d6 (one sixsided dice) roll with the mean value 3.5. But I also want to be able to do the unlimited rolls (Un1d6 has the mean value 3.75). Unlimited throws works like when you roll a number 6, that dice + a new dice should be rolled again and the result should be added to the other dices. I.e if you roll a Un3d6 and rolls 3.6.2 you take the middle dice (the 6) and rolls that one together with a new dice again and rolls (3.2.)3.4. The numbers inside the paranthese are the old …

Hi, I wish to generate a list of dates from a range field which changes on a regular basis. At present my range field shows 11/04/2003...21/04/2003 I now need to show all individual dates from that range in another field which includes the start and end dates. eg; 11/04/2003 12/04/2003 13/04/2003 and so on preferably using a calc field as it is awkward running a script each time. Manyt thanks Benzie

Can i make a calution that basically says if a field is empty it will not be displayed in the layout?

I am making another order manger and some orders have more than one item. How can i make the fields appear only when they contain info?

I have a requirement that states that an employee must have a chest x-ray every three years, or a TB skin test every year. I have tried to create a flag field that will produce a check mark if neither condition is met: Case((IsValid(X~Ray Date) and X~Ray Date - (Today-1096) >= 0), (IsValid(T.B. Test Date) and T.B. Test Date-(Today-366) >= 0), "", "?") For some reason, if both date fields are empty, I get a null return. If I define the flag field with either component alon, the check mark appears when the field is empty or out of date (e.g.) if I use Case((IsValid(X~Ray Date) and X~Ray Date - (Today-1096) >= 0) "", "?") and the X~Ray Date field …

I have two text fields side by side, and for each I did Format ---> Sliding and chose ?sliding left.? I was expecting field #2 to slide over and fill any empty space in field #1. The output looked the same with and without the sliding left option. Am I doing something wrong, or did I misunderstand how ?slide left? works? I found a workaround by using MailMerge, but that does not really seem consistent with how I understand FileMaker to work. Any ideas. Thanks. Thanks, Ted G.

Using 5.5 on Win98. The following problem has just started malfunctioning...its been working for well over 2 years without problems: I use the Troi file plugin ReferenceToClip feature to get a path from a BMP or JPEG file which I insert into a container field (in two completely separate situations: 1 into a global container & another into a record's container: neither works anymore). The plugin appears to be functioning since it loads the reference onto the clipboard (I'm also getting the proper return code). I know this 'cause I can paste the image onto a blank layout. However, I can't paste it into a field using CTRL V, nor will it be inserted under script cont…

I developed a program that tracks public school music students. Part of the program allows the teacher to grade a student on up to 15 musical selections. I know about "average" for numerical grades, but is there some way to average letter grades?

Hi, One of my clients needs a function in which he can enter a weeknumber and a calc will resolve that weeknumber to a valid date, in the current year. The outcome of that calc must be so that it is always the sunday in that week. So if he enters 11, it should display the sunday (and date) of week 11, ignoring all other days... I've been trying all sorts of things but i can't get the calc to work properly... I didnt even start on the 'sunday' thing yet since i can't get the weeknumber reversing done any suggestions? TIA JP

HI, I have created a customer database for my company, and I have 4 date fields for next service date, example 2 Months, 6 Months, 9 Months, and 12 Months service, sometimes only one of these field may have data and the rest might be blank, sometimes some or all could be filled in, or even none at all. What I would like to do is to somehow compare all of these fields and return the date that will need service next for my report. example the 2 month field might have 2/1/2002 and the 12 month might have 12/1/2001, so the 12 month service should be next for service, and should show up on my report. And if all the fields are empty no data, would like it just not print…

I'm writing an import filter from a cad program, one field in this program contains a combination of alphas and numerics in text form such as: 0.1uf 339K 22pf and so on, however the same field for different components will contain only text: shotky transorb and so on. Our data base seperates the numerics, so to do a final import we need to filter the numerics in this field. while experimenting I found that simply doing a text to num function on this field would in fact filter the numerics quite nicely, but when it encounters text only fields the result seems to be ambiguous, ie the result is not predictable sometimes a 1 or 0 or two shows up. Ok, …

I can calculate the current week using the following calculation, but I do not complete understand why it works so I cannot make it calcuate last week or the week before that DateToText(Status( CurrentDate) - Middle("6012345", Mod(Status( CurrentDate) - Date(1,3,1904),7)+2,1)) & "..." &DateToText( Status( CurrentDate) - Middle("6012345", Mod(Status( CurrentDate) - Date(1,3,1904),7)+1,1) + 5) The above calc will give me 4/13/2003...4/19/2003, but what I need is calc that if it is a Monday would be the past 2 weeks. The example below. 4/6/2003...4/12/2003 and 3/31/2003..4/5/2003 Any help would be great.

I need a compound interest calculation for 5% annual. None of the below standard included FM Financial calculation scripts seem to work for what I need, an increase of x% per year. FV (payment, interest

I have a product file joined to a sales order file, with a key of product ID. I want to show sales by quarter for the last 3 years. i.e. current quarter and the previous 11 quarters. I also want this to change automatically at the beginning of a new quarter, the data being rolling. I know that I need a calculated field in the sales order field to produce a key from the invoice date (which is in the sales order file), which can then be concatenated with the product ID , let's call them A to L. I think I'm OK on setting up the relationships, but need some help on calculating these key field values. Any help appreciated. Anrew Bruno

Can you copy to more than one global field at a time? ie.. copy field "db1_customer_number" set field "db1_g_cust_num" copy field "db1_code" set field "db1_g_code" perform script paste db2: go to field "db2_id_number" set field "db1:db1_g_cust_num" paste "db2_id_number" go to field "db2_code" set field "db1:db1_g_code" paste "db2_code"

I have this working for "CL", now I want to add checks for other letter combinations. Such as DL-N, Dl-A etc... How do I add these other tests. I am pretty new at this so I imagine it is easy. If(PatternCount(ling_2, "CL") > 0, cl_bar_image, "") Thanks for your help in Advance norm

I want to insert an id_number in a document only after it is printed and have that number increment by 1 for the next time the document is printed. How would I do this?

I want to store text files as records in filemaker. Unfortunately, I have two problems 1) Text fields only hold 255 characters. 2) I can't markup the text (ie various text sizes, bold). Does anyone have any ideas around this? I don't want to do merge files. I want all the info to stay in one place, in Filemaker. Regards, Evan C

I'm trying to optimize my localization procedures. The language strings are stored in one spot as repeat fields but are used over multiple files, which makes it easy for me to keep the overview and to switch the language. The disadvantage however is, that when the language is changed, I need to copy each individual repetition from the specific language repeat field into its respective new language repeat field. This works, but however is abit annoying as the script to do this gets pretty long (countless language strings * number of languages). nuff said. My question: Is it possible to do a calculation with the use of placeholders? Imagine the following fields: …

I'm using the contents of a global field in a calculation, but I need the contents of the global field to REMAIN THE SAME. This is working on a served file and every time I close the file and re-open it, then contents of my global field disappears. HELP!!! thanks.

Hi all, Here is the case Category for a Company/contact file. A company can either be a : - Customer or Prospect - and/or Supplier - and/or Other These are not really Status fields as I am not looking for active/inactives, but that's the way I defined them... The status would be first entered at the creation of records using 3 globals (g_statusProspect, g_statusSupplier, g_statusOther) with "toggles" scripts activated containers (when filled with a "1", the container shows a full menu button), assuming that a New "Customer" is a prospect. When the record is created from the globals, the appropriate numbers are filled into 3 num fields n_statu…

I have an employee list of about 12 people, and I need to make an absentee calendar to track days they were sick, vacation etc. The form itself will display employee information along with twelve mini-calendars. Now depending on the employee, say he takes January 2nd off "Wednesday 2002" I want to look at the mini-calendar for that employee (Twelve total mini-calendars for each employee) and check that date with a "V" or "A". Now I know there is another way to do this. I have no desire to create 365 fields for each day of each month. I honestly don't know where to start here, any hlp would be much appreciated...