Calculation Engine (Define Fields)

I too am a novice and have an FM DB of 8000 pix. I have thumb nail size pix which I wish to load into a bigger frame to view (sort of basic html action) in the same layout. I created a spcific containter & wrote a copy & paste into a container script but when I click elsewhere FM asks if you want to save the revision. As I do not, I tried to find a script that automatically says no cannot not find one. I presume there is a easy way of doing this, but what?

When defining a field, you can choose to make it unique, but I have two fields which, by themselves can be duplicates, but combined should be unique. For instance, I have an airport ID number and FBO name (the company that provides fuel, etc.). There can be multiple FBOs for an airport, but only one with the same name. Is there an easy way to stop duplicate records from being created at the time the record is being entered? Also, I need to create a script to show me the existing duplicates. TIA

Does anyone know how to create a field that will show the modification date of another field? For example, I'd like to keep track of when a client's address has been updated, and not just when his overall record has been modified. I'm assuming this is relatively easy (in fact, I could just put his address info in a separate table with a basic modification date field, but I try to keep my total number of tables and relationships down) Thanks

Hi, Maybe this is a lame question (absolute newbie), but it is driving me nuts: I'm trying to do an image database based on an older Excel database. I am using the Photo Catalog template provided with FM7. I have thousands of images (jpg) in a folder but I only want to import into FM7 the images for which I have the selected file paths in a column in the Excel database. But I simply do not know how to link the file paths to the image container in FM7. I do not want to do "Import from Folder" because then I get over a thousand unwanted images... I only want the ones to which I have the selected path as text (D:xxxx.jpg). I would most humbly apprecia…

Hey everybody- I am using 3 different drop down menus, i cant for the life of me figure out how to set it up so each combination of drop downs will return a different result. I could do it with IF AND functions, but that would be really tedious. Is there a quicker way to do it then touch each different combination with an if formula? Mark

I have a container field that contains a picture. I am using a new camera and here is the problem. The picture prints great from filemaker. It looks very pixelated in the container. Pictures from another camera look great. I tried resizing the field and it does not help. The picture is 4x5.33 at 150 dpi. Any suggestions??

I have 3 files linked, i.e. Addresses, Services, and Bills. Services lists unique IDs, their text Descriptions, and 7 different price groups. Customer_Status, which defines price group, is required entry in Addresses. Lookup based on Customer_Status enters prices for each service into Bills of 20 lines max. for each Day. Services for several days are later linked via Bill_No to print as one Bill. Problem: Bills, like individual quotes, are correct when viewed/printed in the correct one of seven layouts, one for each group of customers of the same status. So far, I have a Warning field which displays a message if the layout does not reflect correct Customer_St…

I have been trying to find a way to count the records that have a certain value in a field. I tried to run a count( case(field = "active")) but it didn't work. It might be easy... but if anyone knows, that would be great. Thanks.

Hi all, Have a self relationship and in the portal want to mark which record user is on with a different color. Any suggestions? Ricardito

I have one file for Employees which is related to "Groups" by a unique#. One employee can be a member of multiple groups. I need to send an email to each employee detailing what groups they're a member of. Is there an easy way to show the related values from Groups into a text/calc field for the the related employee? In the past I've used a script to copy the values from a portal to one field but would love an easier way. thank you!

I need to be able to create a filemaker calculation field that converts a given date into unix format. I have the formula for excel: [(DATE(Year,Month,Day)+TIME(Hour,Minute,Second)-25569)*(86400)] but converting the date to a numerical format in excel is not equaling the number that filemaker gives me. Help!

How can I block the fields so the only way to insert or edit data is to click on a EDIT BUTTON or something like that would allow me to do that?

I'm trying to set up a field validation forcing the user to always enter lower-case data. I can't get a calculation function to recognize the difference between "A" and "a". I managed to validate to numbers are required, with a Case with PatternCount test on all ten digits. But the case issue has me stumped. Steve Brown

I have newbie question... I have a price file in a fixed format: sku(6)descr(12)retprice(6)wholeprice(6) as one text string... "PD3456PRODDESCRIPT001899002499" How do I import into the database? (I went the excel route) I'd rather import it directly into foxpro And the other question is once I get the price as a text string of say "001899" how do I turn it into 18.99 number? Do I divide the number by 100 is that a calcuated field area? Thanks

I would like to define a format for a numerical field, so it shows the entered value as SMPTE timecode. can anyone help me as how to do this? it would be nice if one could just enter for example 61504 and the field would show '00:00:06:15:04 - mikkel

Hi I am still pretty shaky in the area of calculations and the limits of what they can do. I'm wondering how to go about calculating a list of related values from another table field. I'm not sure if there is a way to loop through the values, or if I'll have to create a recursive function somehow... Seems like if there is a way to write a loop, I could just run a loop with lookup(), but I dont think there is a way to loop in a calculation field. Any suggestion? I really don't quite know where to start with it. Also, I know somebody will probably suggest that I just create a value list on the related field, but my problem is that I need to be able to g…

In a DB, i've numerous fields and relationships, all named at the end with a "number". I use scripts with getparameters and IF/END IF structures. The problem is : it creates large script, with repetiting structures. My question : would it be possible to use a calc with the LET function and a variable to replace all thoses IF/END IF structures (or CASE structure within a calc field) ? Example : if getparameters = 1 then set field RELATION1::FIELD1="aaaaaaa" if getparameters = 2 then set field RELATION2::FIELD2="bbbbbbb" if getparameters = 3 then set field RELATION3::FIELD3="ccccccc" if getparameters = 4 then set field RELATION4::FIELD4="ddddddd …

I have three small thumbnail size container fields on one layout. There is a larger one that will display any of the thumbnail pictures that I choose. I did this since the load time for each record was getting long. I want to have the large container field to be initally empty when I go to any record. So I need somehow to clear the contence upon entering or exiting a record. Also - is there (as there is in Access) a script step such as "on enter" or "on exit" Thanks again

I need to sort records by ascending date and have the records with the blank date fields appear at the end of the report rather than at the first. There has to be a way to do this, but I can't find it. I'm looking at a FMPro 6 bible, and it even says "If a record contains nothing in the sort field and you perform an ascending sort, it will appear at the beginning of the set of sorted records". O.K., but we don't want these records at the beginning of the set. Help, please.

I'm trying to figure out how to calculate the correct elapsed time using the 24 hr format, start time is 23:00 and end time is 02:00. It should be 3:00 but is -21:00. The calculation is (end time - start time)I know there is a way to compensate but I can't figure it out. Any help would be appreciated. Thanks for you time, Bob...

We are using a custom function to create an array that includes 4 values per line: Date, DayName, "Weekend" (or "Weekday") and Price. (we can stack these (carriage return after each "field") or create a four-column array, whichever helps along the solution) We would like to Sum the Price "column" in a custom function. Thanks for your help.

Hey there, A little back ground on what I have and I am trying to do. Im a small business owner and I run my company with FM databases. My database that tracks all of my cases have various fields for case numbers, defendant information, court dates exoneration dates etc. For each bond that my office writes, attached is a power of attorney that has a tracking number itself. I would like to create another database or field in my existing database that I can keep an inventory of my power of attorney numbers. When I receive new powers from my insurance company they are numbered i.e. 570001524 - 570002524, I cant figure out a way to create new records with this type…

I am trying to create a calc field or sum field that would add the total points for each racer in a bike race. Each individual race results are reached thruogh sorting. I have attached the file. Any help would be appreciated.

I have a table APPLICANTS related to a T.O. of itself MULT. APPLICATIONS The relationship finds applicants who have applied to different departments at my company by EMAIL_ADDRESS = EMAIL_ADDRESS and APPLICANT_ID not equal to APPLICANT_ID I'd like to look through this relationship with a PatternCount to find out how many other departments are still considering the person. I tried to define this field in the APPLICANTS table: Still_in_review_by_other_departments [unstored, number] = PatternCount (MULT. APPLICATIONS::Review_Status; "In Review") The calculation only returns ones and zeros -- I'm expecting results more lik…

I have a filed that filters values from many different fields. Some of the values are, Green Hunter, Green Olive, Green Apple, Blue Sky, Blue Baby, Blue Water. Sometimes different versions of Green will show up in this field, along with different version of Blue. What I need to do is create another calculation field that filters all versions of Green and calls it Green and all the versions of Blue and calls it Blue. How would I go about creating the second calculation field? Any help you can give is much appreciated.

This is kind of a cross between Define Fields & Script Maker, but I'll try it here. We have a couple fields, that we really need to remain unchanged after the first time they are set (Account Number, Start Date). We recently had some problems with a couple getting changed. We have defined the field so that it cannot be modified. We tested it from the layouts, no problem. The problem looks like a standard FileMaker feature: You can change field values from a Script, even though they are marked as Non(Un?) Modifiable in Define Fields. Does FileMaker (v5/6) provide a way to completely lock down the fields, including preventing Script Maker from maki…

Okay... I have a table of all my products. There's a table called order_items that linked to the products table. Each order item is linked to one product. The order_items also contains information on how much of of an order's payment went to that specific order_item. Each product in the needs to add up how much money was spent on it total. I made a calc field in the products table that just did a sum(order_items::paid), but that field is always blank. I don't know why, because I've used sum this way in other parts of the database, and it always works. I noticed that filemaker thinks my relationship between products and order_items is many to many when it should on…

Hi, I would like to have my Textbox background Change color on a calculation! Is this possible? Thanks for youre reply!

I have a database that has a text field called 'office'. Each 'office' has a corresponding number field called 'account'. I need to have the number associated with the 'office' automatically put in the 'account' number field when I put the name in the 'office' field. e.g.(If office="naples","091120","") My problem is the calcualtion field only allows so many calcualtions. Is there another way to do this?

Hello, I have a FM database that has many different tables. On one layout I have two container fields. On another layout I have one more container field. Everything was working fine until all of the sudden, opening a PDF in a container and then closing it and then clicking out of the container hides/deletes the icon from the layout. (All of the PDF links work this way now.) If a user clicks on the white container space it will open the file again (even though you can't see it anymore). What is going on? Can there be something other than a corrupt file to consider? Greg PS: There are no scripts to my knowledge that reference these fields in any way. …

Help please I am trying to create a database for my melanoma cancer patients. We "stage' the patients based on the histological diagnosis; measured tumour thickness (Breslow), whether the skin is ulcerated or not-ulcerated and on the microscopic depth of invasion (clark level). I have written a calculation field for the stage - "Tstage" based on the above variables. The calculation is based on a nested series of "If" calculations The calculation works perfectly until the tumour thickness exceeds 10. The calculation then fails to recognise the number is >10 and calculates a result as if the thickness was 1. Similarly if the thickness is 23 - the result appears to h…

In FM7 the new Auto-Enter calc functions in combination with the Evaluate(expression;trigger fields) seem very powerfull. However, I'm a bit confused as to under what circumstances exactly an auto-enter calc will update itself. Does it always update if the fields referenced in the calc change? Or, do you need to explicitely use the Evaluate() function along with trigger fields. I've heard that if you use Evaluate(), that the trigger fields only work if they are local to the table? I've read another statement that the creation order of your calc fields matters? Also, how do empty values and invalid relationships work? I.e. does delet…

Hello, I don't know how this can be done... Is it possible to have users enter information when field is empty and hide the contents from after? Thank you.

Sorry---don't know too much. I have a field called "code" that could have 1, 2, 3, or more codes, separated by a double quote (I don't have a choice). Example, code = AA, or AA"BB"CC. I want a calculation to look at "code", and put the results in a field called "display." There could be 1 result, or 3, or 10. By using a Case statement with PatternCount for each code and it's result, I got it working but it only spits out the first result. How do I make it look at all the codes in the "code" field and spit out ALL of the results in the "display" field (separated by a line break, comma, whatever). :?: THANKS!

I have Text textfield where i want to put any formula and get the valuue of this expression. Can i do it? In the formula i want to use any global fileds.

Hi, i was just wondering if it is possible to insert more than one picture in the same container field in FMP 7 ?? Thanks

I am trying to create a calc field or sum field that would add the total points for each racer in a bike race. Each individual race results are reached thruogh sorting. I have attached the file. Any help would be appreciated.

Happy Friday- Does anyone have an idea why when I do a lookup to determine if an ID is the same in two databases, filemaker sometimes returns a false negative; i.e., filemaker says they don't match, but doing a "find differences" in bbedit shows they're identical?? Thanks

I am trying to have a date field with a date and then another date field with the date 30 days after the first date? I can't figure it out - Any ideas would be greatly received.

I want to auto-enter a number value based on if a date falls with a specific date range. For instance, if the date is between July 1, 1980 and June 30, 1990, the value should be $25.00, if the date is between July 1, 1970 and June 30, 1980, the value should be $20.00, etc, etc. I tried this, but it doesn't seem to work (v_Date is the variable) : Case ( v_Date ? "7/1/1980" and v_Date ? "6/30/1990", "25.00", v_Date ? "7/1/1970" and v_Date ? "6/30/1980", "20.00") Also, does it matter if v_Date is a global field or not? -Scott

I have a very simple invoicing solution and am struggling with automating the next invoice number. The invoice number is a text field and made up of 3 parts; the project number (446), "INV", and an incremental 3 digit number "001". invoice number = 446INV001 (next number would be = 446INV002) I'd like to have the invoice number field automatically calculate the next invoice number when a new record is created with a matching project number. How can I increment the final 3 digits but still keep the invoice number in the same format? I can work out the relationship bit without problem, but the calculation is stumping me. any suggestions? Jason...

When I have a database hosted with Server does the value of a global field change for everyone when one user changes it? What I mean is if user1 is running a script that has a global field in it set to 10 and another user sets that same global field to 15 would user1's value still be 10?

I'm completely baffled by a particular field behaving differently in different records. I have a field in table B called 'currency' which looks up its value from a field in table A. Sample values are USD, GBP, HKD, etc. The lookup works fine. The problem arises when I create calculations which include the 'currency' field. In some records the calculation produces a valid result, in others it returns zero. I've checked everything I can think of, including: -re-entered the values in the currency field, both manually and using 'replace field contents' to ensure uniformity -used various methods to test calculations, including creating calculation fields and also runn…

I am making a catalog with 200 similar items, some have jpg attached to them and some don't. I would like to print a catalog with all items in order. When the container field has no attached picture I want to move everything up in the layout. I have tried everything similar to text field in sliding and printing. However on my layout the empty container fields continue to show up as white space. Am I missing something obvious? Is this possible? Thanks in advance.

Is there a way to hyperlink a field to the web? More specifically, can I have a field, that once filled in w/ text can also point to a web site, that is different for each record? Thanks for your help. FILEMAKER PRO7/DEVELOPER WINXP SP2

I

I am having a strange problem. I have an Order Total field that is a total of product line items and sales tax. It is calculating correctly. The strange happens when I try to do a find for a total > 25. It comes back and says that it can't find any that match the criteria. If I scroll through the records, there are many records that fit the criteria. Any ideas what would be causing this? It started doing this after I deleted all the records in my tables and reloaded the records from a fresh copy of our production system. Before the reload, it was working correctly. I have no clue what is going on. I would appreciate any info. Thanks! John

I am an average user of FM6 and the magazine I work with has a small FM6 flat file for photoshoots with very basic information; Title of Article, Subject, Photographer, etc. My question concerns the File field which is alphanumerical label for the actual folder containing the images, the folders are filed by subjects. Each value in the Subject field has a two letter designator used in the File field. (AC for Aircraft, AR for Airports, CN for Concepts, etc) This label is manually entered. One has to find the last occurance of AV, write down the next number and then locate the last occurance of CR and so on. I would like to generate the file information based o…

Hi I am having a little trouble getting a calculation to work as I want/need. I hope someone canhelp me. I have two fields called [name] and [name2] When a designed list with only field [name2] is visible is sorted by the name, I would like the text to change from grey plain text to red bold text. I have made this calculation: Case ( SetSort = "A" ; TextStyleAdd ( Name ; Bold ) ; SetSort = "B" ; TextStyleAdd ( Name ; Bold ) ; TextStyleRemove ( Name ; Bold ) ) This make the text bold. But I cannot cange the text to red also - I have tried with [&] and [and] but nothing work. Any ideas ? Jens Peter

I'm new to this, and I'm not sure what the correct terms are for what I'm trying to do, but here goes: I'm using the Substitute function to remove some punctuation from a field. How do I string the Substitute functions together so that all punctuation can be removed in one calculation? Below is an example of what I'm trying to do...the calculation doesn't work and I don't know the proper way of combining the statements. Thanks! Substitute(title, ",", "") and Substitute(title, ".", "") and Substitute (title, "_", "")

I have a button that performs a Send Event function. I only want this function to be available if a txt_complete field has a value of "Complete" Is there a way to have the button be inactive or greyed out unless the value of the field is like above? This would be similar to the way many websites disable a "Continue" button unless you check a "Accept agreement" box. Thanks for any help

Hi all: This is an FMP 5.5 question. I'm using WordCount() to determine how many items are selected from a checkbox field. Everything goes well so long as the user chooses from the list (these are clothing sizes, so the main list is "sm" "med", "lg", "xl", etc.). However, they need to enter custom sizes at times, and there are too many to put in the list. I've just discovered that their syntax for sizes can go like this: "4", "5/6", "6", where "5/6" is an actual size. Unfortunately, WordCount() takes that "/" and determines that it is dividing two words. I'm sure that I will discover other strange punctuations (the client is a textile factory), so I want …

Anybody know why my mod date and time fields no longer update? When I first created them (yesterday) they were acting properly (they showed the new mod time after the record had been modified. They no longer function this way. They simply display the last mod date and time (yesterday) Any help would be greatly appreciated

I have a table that contains records of stdent performance in several different classes across several different terms. I have a self-join relationship setup where: TermCode = TermCode Course = Course TotalAvg x TotalAvg If I define a field ClassAvg to be a calculation "Average ( Self-JoinTable::TotalAvg )" shouldn't this relationship allow me to see the average of all sudents in the same course in the same term as the record that I am currently viewing? Also, couldn't I define a similar field to get the standard deviation of the TotalAvg within the same course/term? Or am I just missing something fundamentaly wrong with my relationship?

I'm an experienced database developer but not very experienced with FileMaker. I've been unable to find an answer to this question: Is it possible to define a unique primary key which is composed of multiple fields? I can define several fields which are unique but really what I want is a compound key which is unique but not the fields which make it up. Is this possible?

I know there is probably a really simple solution to my problem, I just can't figure it out. Here it is: Say I have a field populated with "PPPYY-NNNNN". Now say that I want to automatically change the group of three P's to be just one P and the end result to be "PYY-NNNNN". Easy enough with an auto-enter calculation that uses the substitute to find the occurence of three P's and substitute it with one P. Now, let's say that the number of P's that could be entered into this field by a user is variable. Can't use the Substitute function for that. I was trying to write a recursive custom function to replace any length grouping of P's at the beginning of the…

Is it possible to create a layout as a record? Example: table of numerous documents for merging with customer records

My gut just tells me that before I write some crumby calculation, that someone out there has already written a nice concise calculation to do the following: I need to print out dates with "text endings"

It should work but doesn't I started with a Pause/Resume/Script("0:00:15") This gives a 15 second pause Then I tried to do for duration of field value (Global Field) Duration Where Duration is an entered value. It won't work. I tried a Global String, I tried a Global Number and I tried a Global Time. I must be doing something wrong. The pause works with a URL where a short time is used for a high speed connection and a longer time for dial up. Surely I am missing something simple. This is holding up s major project.

Hi, First off, I'm just starting with Filemaker, so I apologise if I sound an idiot . Anyway, I was wondering if it was possible to define a field where it counts the number of fields that have a certain value in them. It's basically a "Sum" function, but I need it to count how many records have the number "1" in a given field. I've played around a bit, but not been able to get very far with it unfortunatley. Any help you guys could give me would be very much appreciated.

Hi to all friends ! It'is possible to simulate in FM6 the function Evaluate(field1) of FM7 ? So that if i write something like: (2+3)*7+24/12 into fied1, i'll get 37 in a calculated field2 !!

I have been searching the forums and will continue to look but I wanted to add a newbie question about networked users on mac and pc. We are importing images into our database on a Win 2000 server with Filemaker server. The image is imported without a reference. First question is the images can be seen in the field, but later seem to disappear from the database, then we are importing them again using import file. We have tried importing them using folders with subfolders, just folder contents, and singly. We also tried cutting and pasting the image into the container. Second question is not all images are imported from folder. When we take the database off-line and impo…

Hi guys, I have a file with 3 repeating fields containing 25 repetitions each. I'd like to create a seperate file and get the data from the 3 repeating fields into 25 records. Any suggestions will be greatly appreciated.

Hi guys, I was wondering if there was a way to rotate a field. I have fields around a square diagram box and want the field to run parallel to it meaning the fields on the sides would read sideways. I tried to use the japanese format but either I am not understanding it or it isn't for this purpose. any suggestions? Thanks

Hi, This is probably a simple one! I have 2 databases each with a field 'dateastext'. One is a global, and one isn't, but they are both Text format fields. In my script, I: Set Field[file1::dateastext;GetAsText ( Get ( CurrentDate ))] which in one file returns: 3/3/04 and in the other returns: 3/03/04 and as a result I cannot link the two files on the date field for a portal lookup! Do you clever chaps (and chappesses) know and way to standardise the return... TIA, Bob

Hi Everyone, I have a database that tracks daily attendance of students. I currently use just one field on each student record called attendance log. Everytime the student attends class I have a script that pastes the current date into this field so it ends up looking like 2/15/2005 2/16/2005 2/18/2005 etc. What I was wondering is if I should keep doing what I am doing or if I should make an attendance table and create a new record for each time the student attends? I didn't originally do it this way because we have a little over 100 students and average about 30-40 attending each day. Would that be too many records if I did it that way? I would love to h…

I'm creating a database that will function similar to a website (but used on desktops only, not online). I'm trying to figure out how to do a couple of things. First, is there a way to create a header menu once and just include it in several pages (layouts) of this database? I would like to be able to modify this header menu once and have it automatically be modified on all pages that it appears. Second, is there a way to designate text as a link to a particular page? I know I can select the text box and make it a button, but is this the only way? I would like to be able to highlight certain words and designate them as a link to a page, like you can in html.…

Is there a way to prevent a field from automatically advancing to the next field? In other words, when somebody enters info into a field and hits return I don't want it to activate the next field automatically, just deactivate all fields.

Using FM7pro and server. I am trying to achieve what I thought was easy at first. It even worked for a few days!! I have a SITE database and a SERVICE database which has a Unique ID field called(ServiceID). In the Site Database I have a field (ID0) and a field (ID1) and a Calculation Field (ID) When the date for a 'service change' is equal to 'today' or older I want the (ID) field to display (ID1) else (ID0) This is the working calculation here - "If ( (Service Change Date > Current Date) or (Service Change Date = ""); Service ID0 ; Service ID1 )" BUT the relationship needs to use the Calculation field (ID) so that the service will change AUTOMATICALLY when t…

I have written a script which compares an entry into my field "Last Name" with the rest of all records in order to find customers with the same last name. Is there a possibility to let this script run after I press the TAB key to jump from "Last Name" to the next field? I've tried with specify button/perform script but this is not quite what I want because of course it only performs the script when I click onto the field. Thanks a lot, Andy

I'm having a problem using 'Evaluate' function to auto-enter data into a field. I'd like the Evaluate to be trigger'ed whenever a field changes in the current record. This trigger field is a calculated field. Its calculation is unstored and simply is a value in a related record in a different table. The evaluate doesn't seem to be getting triggered when the calculated field gets updated and I'm wondering if anyone out there has any advice on work-arounds etc. The issue seems to be that the calculation is based on a related record I can get it to work on a (unstored) calculated field so long as the calculation is based only on other values in the current t…

Hi there, I got an Accounts Receivable file that holds invoices that have outstanding balances. I got two buttons that generate statements. One for the last 30 days and the second one for the last 60 days. They will gather invoices by customer. When an invoice is passed due for 60 days, a 4% charge applies (calculation field). When clicking the second button to produce a statement for a 60 day period, some invoices may be due for the past 30 days only. So, no charge should apply to those one but it is not the case the way I did it. See how I tried to overcome that problem. Here

My script tracks how long it takes to run a particular script. I want to take an average of all of these times. I have a calc field that automatically subtracts end time from start time for the duration. I've created a summary field that takes the average of all the shown durations, and have placed the result in the footer of the body, however, It doesn't show the average, it shows another, much larger number. What obvious thing am I missing.

Hi, I have a question that might seem trivial, but I hope you can help me... I have an excel list containing more than 4000 records, each corresponding to one image (.jpg). The records contain information in several columns about the picture (sitation, date, site, photographer etc), and also one column with the filename of the corresponding image (f ex "2005.50.03.jpg"). How can I make a database that shows the information from the excel list and the corresponding image? The database should be exportable (to be burned on a cd) - i.e. the images should be built into the database. Thank you, Anja

I have a strange calc problem which I would need some help with. Basic I have a 52 rep number field and a 52 rep calc field set to container result Depending on the number value (nm) I want to get a pic from a container field. This is my calc (shortened) Let ( [ Nm=P_weeknm; High=User Season::WeekHigh; Low=User Season::WeekLow; Bar1=Graphic::Weekbars1; Bar2=Graphic::Weekbars2; Bar3=Graphic::Weekbars3; Bar4=Graphic::Weekbars4; Bar5=Graphic::Weekbars5; Bar6=Graphic::Weekbars6 ]; Case( Nm < GetRepetition(High;1); GetRepetition( Bar1;Round (nm;0)) ; GetRepetition( Bar2;Round (nm;0)) )) It works g…

I am looking for a general technique here to apply in various ways in various situations, so please just consider these hypothetical examples at face value for discussion purposes... Consider a number calc field called "Total" that evaluates to "4". In designing a layout, I can use number formatting to make this field display as "4.00". However, if I copy and paste the contents of this field, only "4" (not "4.00") winds up on the clipboard, or if try to move the contents of "Total" to a text field using a script like: [set Field: TextField -> GetAsText(Total) & " hours"] ...the resulting data in TextField is "4 hours", not "4.00 hours". …

I'm wondering if anyone has a solution to a very simple problem. I am trying to make a basic address label. The problem is my First & Last name fields have four repeating values. The merge field only displays the first of my repeating values. Is there a way I can specify which repeating value I want to be displayed? Any help would be greatly appreciated!

Hi everyone, I import a large volume of data daily. This is user-entered data that is not validated (pulled from the web). There is only one way to match this data to our existing orders and that is on the Invoice Number field (this is used to match payments to orders). Online User also enters their name but you KNOW how hard it is to match on name entries exactly. So I want to make a valid key out of this - or produce an error so we can quickly view and correct any funky entries. The Key must be either our InvoiceNumber (6-digits always starting with 0); the on-line purchase order number (4-digits), or the words "Trial". They also enter the correct Invoi…

Is there an easy way to add a TAB character into a text calculation? For example if I want a calc field to evaluate as something like: "Apple[TAB]Banana", ...how would I identify the [TAB] in the calc definition? My first instinct was " t " but that appears as literal text and not as [TAB]. Anyone? rrr

From time to time In a file which contains a field set as INDEXED, AUTO-ENTER SERIAL, CAN'T MODIFY AUTO, the contents of one sell will diasappear. I cannot determine why and therefore fix the problem. The field is vital as it is to be a relationship in severl related files [email protected] [color:"black"]

Hi All, I have a text field which contains basically random characters, alpha, numeric and symbol. I need a calculation which returns characters only up to the first non-alpha character. So: "xyz2y" returns "xyz" "y2r" returns "y" "abc$tyu" returns "abc" etc! Another of those problems I expected to be easy, but have only come up with kludgy, long-winded solutions for. Thanks...Sean!

Hi, I have a relationship calculations set up between two databases: monday = :user_mon_calc tuesday = ::user_mon_calc The calculation for 'Monday' is - DateToText(start_week)&"_"&username and 'Tuesday' is: DateToText(start_week + 1)&"_"&username etc etc and the calculation for user_mon_calc is - DateToText(activity_date)&"_"&username In my master file i have a portal for each day of the week, which i want to list all records that have the corresponding daay and username. The above seems to work when just displaying the correct rows, however when it comes to entering data into any of the fields in the new ro…

I can't get the Evaluate function to give me what I want -- I figure there's something simple I'm missing. 2 fields: txErrorMessage (text) and ctErrorMessage (calc, text). txEM and ctEM for short. txEM contains a FMP-calc as it's contents and I want ctEM to Evaluate the calc. Simple enough -- just letting a user type new error messages, using field references if needed, into a field instead of a calc field or custom dialog. here's the contents of txEM that i'm working with: "Your " &TB|SYSPREFS::txAppName&" software license for "& TB|SYSPREFS::txRegisteredCompany& " will expire on "&Datetotext(TB|SYSPREFS::dtExpiration)&"…

ok, i have been playing with and loving the import image from camera feature -- only to realize that it's not available on fm7 under windows. what's up with that? don't windows users use digital cameras? i would really like to include this feature in a new application being developed and the majority of it's users are on windows. i'll tell you what, after being unable to do a voice-notation system because of the container field's lack of playback controls on a sound file recorded into fm7, i'm growing quite disillusioned with container fields. can we finish up some of these half-baked features, FMI?

First of all I want to thank Moonshadow for all the help that has been provided in getting this database up and running. I am devoleping a Dispatch database for a small ambulette company. What I want to accomplish is this. In the main page that all the users will be viewing I want to show all available Units that are not assigned to a call. A unit gets assigned to a call when the user clciks on the time field that says dispatch and assignes a unit. Do I need two fields One to show the unit and the other to show available or assigned? Thanks for the help in advance. I have attached tha screen shot of the main screen. main.pdf

Trying to set up item price based upon width, height and style no from a price matrix . Can anyone help,new user.

I wish to have a "contain sequence" of letters in a type ahead key, unfortunately isn't the end truncated ...enough. Further shouldn't it be a custom function yet, eventhough the partner here are just about to become Alliance Member. Does anyone have such an algorithm handy??? --sd

Hi all, First post on here, my apologies if this has been covered before, I couldn't find it. My problem is this- I am developing a database for a scientific application, namely the recording of different species of insect when out in the field. Scientific (latin) names are used, for example, campestris . The problem is that, being latin, a lot of the names are very similar. So it would be a great help if I could write a way into the database whereby the user could type the first letters of the name, and the database would display a list of possible matches that the user could click on to get the right one. I'd also like it to be constantly updating, so if the …

Thanks for those whom have answer my posts already, but I have one "underlying" question that might solve my mystery. True / False: If you acquire an image file (by using script - Insert Picture) without selecting the REFERENCE check box, the image file will be stored on the computer you acquire the image. OR would the image be stored onto the FM5 database assuming we are dealing with FM5 server and clients machine. Same True/False question except this time we SELECT the REFERENCE check box. I'm having a hard time figuring out where the image really reside and more importantly is how I can allow client machine to "import" the image so that EVERYBODY on th…

My apologies for not taking time to search through previous posts for answers - time is a little precious and I need a solution. I have a field that is YES/NO. If the selectin is YES I would like to force the user to enter data in a text field. I'm using FMP 6 - which I do so rarely so I'm a bit of a novice. thanks

I have to produce a solution for production statistics with a visual differentiation between the three classes of results which are >5% below target, >5% above target and within 5% of target. As these results would be a calculation of a number against a pre set target, how can I combine this calc with FM7's ability to colour text. Chris

Hi, How can I get a calculation to look at a table of dates and generate the next available date for something ? An example of how I need to use this follows: For every employee that joins the company, they need to 1. have an initial meeting with the boss 2. go to employee orientation 3. get trained on the purchasing system Let's say the boss only meets people on the 1st and 15th of each month. Then, Employee Orientation happens every two weeks.. (1/4, 1/18, 2/1, 2/15, 2/29...) Purchasing System training only happens every two months (1/23, 3/23, 5/23...) How I'd like the system to work is: for each new employee, we'd schedule the da…

I have been at it and I know my understanding of if statements isn't that good. But what I am tring to do is produce a kind of school year calculation based on stopping date. I have a field that contains when the student stopped. I also made two more calculation fields that pull the date into year and month. What I need is a field that states: if( stopped_month >=4; stopped_year & "-" & stopped_year + 1) but it only produces a number 1. What I need it to do is have a school year starting from april to end of march the next year. So if a student stopped 2004/5/12 then I need the calculation to produce 2004-2005. Any ideas? Thanks Ryan

Post deleted by Elwood Blues

Text calculations and I don't get along. I have a string which always looks like this: StaffID ProdID TypeID xxxx xxxxx YYYYMM The x's represent what I need to isolate and can be one to several words. The IDs vary in length and type but are always separated by a space and always only one word. I've tried: MiddleWords ( BottleKey; 4 ; LeftWords( BottleKey; WordCount(BottleKey) - 1 )) ... but that gives me xxxx xxxx YYYYMM I've tried: Right(BottleKey; Length(BottleKey) - Position(BottleKey; " "; 1; 3) ) ... which gives the exact same result. Bummer. I can't drop the YYYYMM off the end no matter what I try!! Can someone help me wi…

Hello, I am a brand new user of FM and I need some help trying to do something that I have not found on the book I have "Learning FileMaker Pro 7". I am trying to create a autoentry filed that I want to use as an ID to keep track of classes that students will take in church. But I want the ID to be meaningful to us. What I have in mind is the following format: SJ-monthdayyear001. I am using an autoentry calculation with the following value: "SJ(month;day;year)-####" I'd appreciate your inputs as to what I am doing wrong or your suggestions on how to acomplish this. Thanx.

I have a membership db that I am trying to simplify data entry. One of the first items to be entered is the state in which a prospective member resides. After entering the 2 digit state abbreviation I would like a script to run to fill in 2 other fields. I have written the script which works great, however I would like to run automatically at the exit of the state field. Currently I have it assigned to a button. Is this possible and if so how?

I have put together a customer contact database in Filemaker and need to incorporate a weekly report of dates to visit customers each week. I

This is driving me nuts... I need to create a field that will take the values of a NOTES field from every record in the found set and combine them into one field. I need this combined field to be the body of an email. As of now I can only figure out how to set the message to be the NOTES field of the current record. For instance, if I have 10 records and they all have something in the notes field, I need to create a field that would have Notes1</p>Notes2</p>Notes3</p>etc... Aside...why doesn't the Send Mail function have an option for "Get values from every record" for the Message section? That's exactly what I would need. Can this b…

How would I design a field that always numbered the record according to the sort order? Say in a bike race I show all the Women times from the shortest to the most. First being the least time and so on. I did want to thank every one for the help on the portal button a few days ago. Nick