Calculation Engine (Define Fields)

OK - what I want to do seems straightforward but it is driving me crazy! I have a start date and end date of an event. Say start date is : 19/1/05 and end date is 15/4/05. I want a field to store month values for all months this event covers. ie: January, February, March and April. These need to be separated by carriage returns (for formatting as a check box set). Any help is appreciated.

ok, at first i was trying to do what we have always done in os 9. (sept up a script to find a file in a desktop folder that matches the applicant id # however when we x-fered to os 9 from os X we could no longer do that with os X (so now i have one old computer just hosting out resume folder.) so then i stumbled across container fields. I create one, I instert the PDF file(which takes time but hey if it works ...) then I go to double click it to open the file itself in acrobat, and it does nothing. am I missing a step? I am not versed in FM and I am largely self taught. Any help would be greatly appreciated

I've just got FileMaker 7. I'm from an Access background so please be easy with me :-) I have a Customer and a Bookings table. I need to open the Boooking Tables Layout and create a new Booking record from a button on the Customer Layout. I need the CustomerID in the Booking Table to be the same as the ID in the Customer Table so the records are related. Easy in Access. Can't seem to find how to do it in FileMaker.

I defined a text field to contain unique values. However, I expected that this would apply to the entire field, but it appears that if the first word in the field matches the first word in another field, that is considered to be a duplicate. How do I make the check apply to the entire field?

I

Hello all I have a question about the behaviour of a pop-up menu field. I have a field on a data entry layout that is currently standard behaviour. However I want to run a script that will change the behaviour of this field to a pop-up menu and possibly read only. Can anyone tell me if this is possible and if so how would one do it? Many thanks eSBee

Hi! New to Filemaker and trying to find out how to get a total from a field that is sorted by a category. There is a listing of items and amounts paid that also have a corresponding variable. There are six different variables and I need a seperate sum for each variable. Any guidance on how I might set up a function or calculation to find this? Thanks in advance!!!

I am working on a program where someone non experienced will be inputing data into a program and want to limit mistakes. I have 2 fields that I need to work with one is elk it contains either a x or blank and is a text field. the other is elkscore it is a number field that keeps a score for that field. In the program the person selects 2 of 3 choices for evaluation. The two choices will have a x in them. The one that isn't selected will be empty and I want to either put a 0 in the tally part of the number field ---------------------------------------------------------------------------- Application Layout Tally Layout Field name …

When a Quicktime container field is selected, is it possible to automatically cause it to play without operator intervention.

Is this a valid argument for a calculated field checkbox Case(testfield="a" or "b";1;) Should place a 1 in the checkbox if the testfield is either a or b To expand: Is this valid Case(testfield=("a"or"b") and testfield2 >"5";1;) should place a 1 in the checkbox if the testfield is either a or b and simultaneously the testfield2 >5. Seems like it should work but I am not having success.

Hi to all friends ! I can't figure why, if I have 2 repeating fields, the first one global with 3 repeaticions all filled with numbers, the second one number with 3 repeaticions with auto enter from calculation (not stored): = gFirstRepeatingField always evaluates and fills only the first repeaticion !! So it seems that I can't have a Field filled like the first (global) !:

Hi there all you amazing geniouses (if thats correct) I need a calc that will tell me how many days till a birthdate. I have tried this (Get(CurrentDate)-BirthDate)/365.2425 but if the date is passed it does some strange things. Any help will be greatly appreciated regards Ron

I know not many people like repeating fields but I use one on my system that hold dates for a day. Say, Monday, and stores the dates for all the mondays we have in our school. We run on a 46 week year and I had to put 48 repetitions (12 per quarter) and two of the fields are empty depending on that day's holidays. I wanted to know if there is a calculation that would get only values and not empty values... so the blank field would just bring over the next value. I can kind of see it, but can't think if it should be a case() or evaluation... any help would be super. Thanks

I need to find out how to change the color of a check box when it is checked on. Any suggestions?

From my client file I am trying to view purchase historys and totals. With a portal to Sales Line Item, I can see what the client bought, but I am having trouble creating fields for a client's sales totals, and separating them by, this year, last year, 2 years ago, etc. Showing totals for the entire period recorded is now problem. but it would be soooo nice to break up the years. Any suggestion how to calcluate this? Thanks,

I've created a new field that has an autoenter lookup. That's great for all the new records, but how do I get Filemaker to go back and run auto-enter again on all the previous ones? Thanks.

Hello, I was wondering if someone can help me out with this. Basically i am working on report, i want to figure out how i can find the total records which were created a previous day. i have field call CreationDate, it is auto enter date field, i set up so it doesnt get modify. Now lay say, if today dates is 4/1/05 and i run my report. i want to find out how many new records where create the previous date base on the field CreationDate. Thanks victor

hi guys, I have a checkbox set defined on a field called media. the options are local newspaper local radio National newspaper National radio. I am doing a report and I need to count the number of local media. So i have a summary field that looks at the calculation however i cant seem to get the calculation working. If i use and if statement doesnt that mean it returns only one per record where if both local radio and local newspaper are selected it should return two. Thanks for Looking, D

Hello, I've been using FM7 to document a large inventory of artwork. At this point in the project I am reworking the database from a data entry tool to something end users will have no problem using. To that endI would like to develop a script to import images into records based on the contents of a particular field. Example: The records each have a unique inventory ID # (200405043) and it's matching image has a similar filename (200405043.jpg). As I said, I would like to have a button on the page that will go and find the corrosponding file and insert it into the records container, however, I don't have the experience with FM7 to know where to start and th…

Hi, Is there a way to change the background color of a field according to its Value List? I have a field: STATUS with VL (Available, Consigned, SOLD) and I would love it if the field could be colored RED when Status = Sold Thanks, Sarah

Hi I am trying to set up a calculated index field where the id's of my case files are formed something like mmyy-#### where #### is a serial number that is reset to 1 at the beginning of every new month. Any ideas how I might go about getting that to work? I just need to know a good way to reset the serial number.

I'm using a database to generate letter templates, and then customizing as needed by creating a new record and tailoring as needed. The main message body of each letter is contained in a text Edit Box field. My issue is that if a word extends past the edge of the field, the typed text just wraps around to the next line. What I'd like it to do is realize the width limitations of the field and move the whole word to start on the next line, like a Microsoft Word document might. Any suggestions?

Hi everyone, How do we use a loop to set values to a repeating field to each of its repeating values? i can manually define each repeating values in the repeating field. but is there a way to use a loop to do it? thanks

when inserting audio (recording from mic) into a container field you get play, stop and pause controls on the audio. once you hit save to close the controls how do you get them back? all that happens when double clicking the container field is the sound plays (and it friggin locks up the entire app while playing!). i couldn't figure out anyway to get the play/pause controls back up or to escape/stop the playback once started. so if you drop a 2 minute sound (say, a voice notation) into a field and then double click it, fmd7 will play all 2 minutes of it while the beachball spins. this can't be the designed functionality. so much use could be gained from an audio stor…

I need to calculate a date by a certain number of months later; i.e. if the date is April 5,2005, I need a date exactly 6 months later. How can I make a calculation that will account for 30, 31, 28, or 29-day months?

I am trying to display a graphic (or filled in color/shaded) field with text based on a calculation. I'm producing a letter that will serve as a receipt, so at the bottom I want the words "Paid Receipt" contained in a shaded box. This letter will also serve as a confirmation of registration to unpaid participants, thus the need for a calculation field based on the criteria of their paid status. How would I merge this shaded box in, only when the participant has paid? Currently, I have a calculation setup to display the words "Paid Receipt" if they have paid and blank otherwise, but I want it to stand out in a shaded box. Thanks for any help provided.

In our database we are going to have these two tables Codelist (with code and status, ....) and TimeEntry (with code) We want the user to enter in the code number within the TimeEntry table which will do a lookup to the Codelist table and bring over info about that code. BUT IF status is "I" for inactive, we want an error message to appear stating that the code is invalid, and we want none of the related data to be looked up. Does this make sense? Ifso how would we go about doing this?

I'm trying to enforce validation on my number field by using a calculation - the number field has to be 15 characters long, no more and no less. The only exception is if no data is entered at all, or zero characters. I can't seem to build a calculation that makes this work. You fellas have any ideas? Thanks Chris

Hi everyone, I am creating a stand alone solution that has serial numbers for access purposes. I have a global field (gSerial Pool) with all acceptable serial numbers in it. For now they are separated with a comma. I have another global field (gSerial Number) that is an entry field. the user enters a serial number and I have a third field, (gAccount Name) that will check if the number is in the list. the current calc looks like this: If( PatternCount (gSerial Pool ;gSerial Number); "Customer"; "Trial" ) I am using this so I can distribute the software for trial with limited access, if they register, they get a serial number which will open up all re…

I have a text field for phone number. Is there a way to set the format like xxx-xxx-xxxx? In another word, is there a way to set 3 spaces, put a dash in, another 3 spaces, put another dash in, then 4 spaces? So users can only fill in the spaces. It's to control the data integrity.

I would like, on a form, to be able to have running information concerning miles traveled per month, and have this visible on the form all the time. There would be twelve calculated fields and when mileage is entered in, say, January the total miles traveled would be displayed in the January field. Each time a January date is entered the miles driven will be updated in the January field. And so on for each month I can get the total miles to work, but not the individual months. Suggestions?:? Thanks

Hello - I am creating a database to track donations and solicitations to a non profit group. I have three relational tables, the first holds individual person records. The second holds the data of how much they have pledged to donate/solicit. The third table holds the actual donations. Donations I am tracking by Individual ID. There is a second serial number named Solicitor ID. If a person donates, say, $100 and give credit to a solicitor, I mark that by attributing the donation to both IndividualID and SolicitorID. I have been successful in creating a summary field that shows on a layout how much an individual has donated, but I can't seem to get a …

Text functions are not my forte and any help would be appreciated What I have done is create a mailbox for my contact manager. When I download the mail from the server I will automatically relate the message with a contact if it matches any of the contact email addresses. The problem is I am having difficulty extracting just the email address from the senders complete name eg: "Joe Smith" <Joe.smith@@nowhere.com>. The common factor with all emails would be < > I need to extract the address without regards to content size within. Any suggestions.....

I must be missing something... I am making a log-in layout that lets you in as a guest but only to that layout when you open up the file. It goes there, and I have two fields, user name and password but I would like to have those "*" astricts to show instead of what is typed in the password field. How can this be done?

Hey all.. experienced SQL/Web Dev here, with about 48 hours of FM experience Needless to say, I've achieved about 80% of whats needed for my project (contact management system , but have this issue: I need to create a field in one of my Contact layouts that reflects the total of all that contact's donations; basically a sum of related fields in the donations table. I found out how to do calculated fields, and use SUM, but i dont know how to apply it to a situation when there are a dynamic number of fields/ records to be added. Any help/direction would truly be appreciated! -ekz

Is it possible to hide/omit a field in a single record based on a calculation thanks for all your help

How would I write the following expression in a calculation field weight/(height/100)^2 I have tried the Exp function and cannot get the correct syntax. Thanks, AZMark

Probably quite an easy solution, but i cannot figure it out, without using several million ifs. hmmm just wondering how i can get an email validation in the form [email protected] where as yyy has to be part of a value list with all the million .net .tk .com .co.uk. .il .de etc etc thanks mike

Sorry to pester but could someone help me with the following problem I have four fields complete 1 complete 2 complete 3 and criteria complete, each complete field can either be 'Yes' or 'No' Hw can i make criteria complete= The number of complete fields that = Yes eg Complete 1= Yes Complete 2= Yes Complete 3= No Therfore criteria complete would = 2

Is this possible I have a field called criteria complete, i have copied it several times IN THE SAME RECORD i was wondering if you could have multiple entries so i could have yes to one instance of the field and no in another, or do i have to make a number of new fields

I hope this is not to vague, but how would you concatinate two fields for example field 1 and 2.

Hi, I've got a DB for which the records have fields of IDs (text). I would like to create a file with such ID as a name - is this possible? Also, when the file is created I would like to open and close it with this ID, but in OPEN FILE script only have ADD/DEFINE file refs. Has anyone done this before? Many Thanks Kind Regards Andrew

say i have several categories which are records in a category field and they have a corresponding number, which is their amount higher means more popular well i was just wondering how i can make a layout include these fields, well sort of, i.e displays each category in order, so the most popular one is at the top, like a top 5. in descending order however i need this page for other things, and for it to be like to the side of a form? so i have a main form in the centre, and at the side, a list of the most popular categories and most popular items i think i have done counts and fixed relationships of calculation 'x', in the correct place, but i c…

I am slowly working on developing a DB for a business launching in the near future and struggling with a couple of seemingly simple scripts. I have a Full Contact Management DB using the standard template but customised layouts/forms for business details, personal details, networkers details, sponsor networker details, charity gift club, executive business programme, alternative contacts, employees postion, empl personal, empl emergency, and activities. Each contact has info entered into each layout as appropriate. I have a separate Networkers Contact Management DB and an Personnel Management DB. A long time back I managed to input trial info into the Personn…

I created a text field with 7 repetitions. I want to auto enter the same value for each repetitions. But I can only get it to auto enter the first repetition. Is there a way to do this? Thanks for any suggestions. -quillpro

Greetings from a new FM7 user! The registration template that ships stock with FM7 is perfect for the training that I facilitate at my company. I would like to add one more little piece of functionality to it however and would like some guidance. All I want to do is create a field that will display the total number of registrants for any particular event. I assume that this will be a calculation field with some type of sum function. However, I'm not sure how to go about formatting this in FM7. Any ideas? Thanks in advance for your help. - - Jeff

I created a date calculation field to track changes to another field with the following calculation: If (IsEmpty(Status),"",Status(CurrentDate)) This works, except that when the Status field is null, the calculated date field contains a question mark. Is there any way I can just set the date field to null (i.e. no value)? Thanks, Kay

I'm starting this as a new thread although it follows on from Copying Tables - a good or bad thing. Here's what I'm trying to do, maybe someone could point me in the right direction. I work for a small charity and we need to collect evaluation data from people we work with so we can report to our funders. For example we run training events and need to collect equal opportunities data from those who attend: sex, age, ethnicity, whether they're disabled or not, sexuality, and so on. I started creating a database thinking I could create fields for all of these things with associated value lists to allow people to choose what sex people were when entering data…

I have a large number of MS Excel files that i need to attach to Filemaker, preferrably without incorporating into Filemaker thereby minimizing the overall filemaker file sizes. Each of these Excel files are related to an individual in the database through their social security number. what i would like to do is insert a link to the appropriate OLE obect into the container field for each record, having the container field change which excel file it is linked to based on SS# and potentially other criteria. The link itself to an individual excel file appears to work fine, but sure would like to add the variability based on related resource. i'm sure this has…

Hi again! Did a search for this one but haven't found it. I have a calc where end_time - start_time = total_time. This is fine but I would like to further refine this time in 1/4 hour increments. Ie, 1:38 = 1.5 or 1:45 = 1.75, etc. This must be the type of thing that comes up often but I really don' really know how to go about creating it. Any help would be greatly appreciated. Thanks once again!

Hello, everyone. This is my first time in the forums, and I am fairly new to Filemaker. My boss wants me to design a simple database that can keep schedules for 4 rooms. Where I am coming into problems is on the date and time validations. I am trying to figure out how to restrict someone from entering a reservation on the same time and date as another record for the same room. If this is not the right topic for this, sorry, please point me in the right direction.

Hi, is there a chance to tell the quicktime player in fm to start the playback of a sound file at a certain start-time for example at 00:05 instead of 00:00 ? thanx

How do you set up a calculation showing the number of days left on a 30 day demo? You know, "This demo expires in 12 days" kind of thing! I've seen it many times but I don't know how to write the calcualtion for it. Thanks for your help,

I have a [Customer] file where I send emails out of and a [Emails Sent] file that keeps track of the emails sent each day. What I can't figure out is how to get the field "DateEmailed" in the [Emails Sent] file to populate. It is set up as a Date field and to auto enter Creation date. I need to keep track of these dates so I can pull up what emails were sent on any given day. I could really use your help on this one!

I finally started playing with the Lookup function and, I'm embarrassed to admit, I'm a bit confused. What capability does this provide that's not already available with a regular lookup or an auto-enter calculation? A field set as a calculation field with the function Lookup("Relatedtable::value") seems to have the same result as making the field a regular lookup (and locking it to prevent overwriting the looked-up value), or auto entering the calculation "relatedtable::value" (and locking the field). All result in an indexible field that need to be manually tripped to repull changed values either by triggering a relookup or, in the case of an auto-enter calculat…

I finally did the upgrade to FM7!!! I heard that the relationships and working with pictures is so much easier. I have a line item report that is generated from an invoice, and I need to insert a PDF in a container field. Here are my questions: 1. Where do I put the container field on my report? I used the report wizard and have subsummary fields, my last part is a footer. 2. Will a container field print the PDF picture or the file reference text when the report is printed? The PDF's will be 8x11 in size and on a network drive. 3. How do I get folder looking tabs for my pictures like on the inside cover of FM7? It makes it look so easy to use on the box. …

I had an FM7 database, a few hundred records, that had a container field with a high resolution image in it. Rather than waiting for a delete to clear the field contents, I deleted the field from Define Databases and recreated it. The problem is even though the database is completely empty, it is still showing as 1.2 GB! Everytime it opens it goes through a "scanning unused blocks" for five minutes. I tried making a clone, doing a save as, and it still shows as 1.2 GB. Anyone know what is going on?

I need to keep track of software licenses and hardware warranties, but need to be alerted somehow when the current date reaches within 90 days of the expiration date field. Is this possible? If so, please describe in detail. I'm a fairly experienced user, but only moderately in the script area. I have managed, however to follow instructions to make pretty complicated scripts and calculations work. Any help would be greatly appreciated. Dave

I'm trying to get the value from a field in a TO into a related table's field. I need to have this field show live data and be able to be part of a relationship match field. I tried setting the field as an unstored calcuation. The calc. I used was GetField(nameofrelatedfield). Every field has a ? in it. I do not want to use a script if possible. Greg

I want to come up with points based on Get (RecordNumber). I am sorting by least time elapsed for a race. 1st = 10 points 2nd = 9 points 3rd = 8 points No points beyond 10 entries

I'm trying to figure out how to calculate a date from a week #. I have a simple calendar that I can switch from one week to the next. So if I am on week 14 I want it to calculate the date of Monday on that week (3/28/2005). Thanks,

I am creating a simple calendar component to our database and I have a calculation field that is Get ( currentDate ). It worked last week when I created it, but this week it still has the same date as last week. Does this calculation not update automatically? Is there a way to get something to continuously update (such as current date display)?

Hi, I am using a script to find a series of records. Each record is in a particular sector ie Supermarket Furniture Retail Fashion Field Sales As the script runs through the records it 'inserts a calculated result' into a global field. My Problem is that I only want the sector to appear once, so if there are three records with the same sector then only 1 instance of the word should appear. can anyone help me with a solution? Thanks Darre

I have written a calculation and I think there should be a simpler version but i cant work it out I have twelve fields where a user should enter either a numeric value or a percentage. The fields together comprise a calculation to add a profit margin to airfares stored at buying price in the database. A user may specify a fixed price markup or a percentage depending on passneger tyrpe , one way or return and wholesale or retail. I use a single calculated check field to check each filed in sequence and return a value to show the first field with invalid data... so I use a case statement. What i have written for field one is Case (not( (Right ( Ag_AD…

I have a simple database to track the scores of a card game between 2 players. For this example, the 2 players are always the same. The card game has eleven hands to each game. My set up is: One table. A repeating field for each players score for each hand. A summary for each players hand-scores to calculate the game total. The database recognizes the winner based on the highest score- it also totals the number of wins for each player. As a side note, only one player per hand can score, so if one player has any score, the other players score for that hand will always be zero. I have a record for each game, they have serial numbers based on the order in which they we…

I have a db with a script that opens a new layout in preview mode that is a letter home to parents containing information from a student record. If I enter information into a new record, then go to letter preview all records are present. How can I set up a script so that only the letter associated with the particular record is generated. Student information comes from another db by SetField, Perform External script, etc. Also, can anyone direct me to a training program, book with this info in it...Quickstart and VTC don't really help me here (even if www.fentonjones.com did...thanks Fenton) TIA Stephen K

Hi there! I'm making my first attempt at a contact database and am not sure exactly how to do this... Each contact will have a category and a sub-category. Each category choice has specific sub-categories under it. (ie. Cat- Food & Beverage Related; Sub-Cat: Caterer, Bartender, etc) Each category and sub-category also have specific ID numbers. How do I create the fields so that in data entry the main category can be chosen and displayed in the field and then the corresponding sub-categories are available to be selected as well in another field? Any and all help is appreciated. Regards, Julia

In a table i have a number of fields (defined for a calculation) named 100, 200, 300, 400 500, etc. and would like to be able to just copy and paste the same function for each one. For example if i had: for the field named 100, --> If(table::price = "100" ; 1 ; 2) for the field named 200,- -> If(table::price = "200" ; 1 ; 2) I want to be able to substitute the name of the current field (not the active one, the one thats actually got the calculation in) where it says either "100" or "200" so I wont have to change it each time I copy and paste it. Any suggestions would be greatly apreciated, Thanks.

Can anyone point me to information about the order of evaluation of calculated and autoenter fields? I just spent an hour or so searching FMI's knowledge base, tech papers etc., to no avail. Things were fairly well defined in versions 6 and earlier, but I'm running around in circles trying to sort out some circular dependencies in a current project.

Hello I have three fields "pipeage" which is a date field "today "which is a date field and "yearsold" which is a calculation field I am trying to calculate the number of years the pipe has been there. So I am trying to get today field to display the year 2005 which I can't get it to do and then subtract for example 1950 from 2005 as 1950 would be in the "pipeage" field. and the answer would be 55 years. But I just can't get it to work. Could someone please guide me here Thanks Dave

In FM7, you now have the option to make a field an "Auto Enter" calculation that automatically updates, if you unselect the "Do not replace the existing value of this field (if any)" checkbox. So, what are the functional differences between an Auto-enter Calc Field (replace existing contents) and a Calculation Field (Stored) I understand the differences from a user-interface perspective (you can't type into a Calc field). But...are there any significant performance, speed, or size differences? Both fields are stored, can be indexed, and can participate in relationships, so it would seem that they should function more or less the s…

Ok I am trying to design a time and billing database that will calculate (obviously) what to pay lawyers for time worked during a specific time period. We are assuming that doing a search for all time entries from Jan 1 to Jan 15 would be a lengthy process (over 3000-4000 time entries total for that time period, approx.) due to the calculations. We were thinking that at the time of data entry changing that time period of Jan 1 to Jan 15 to a look up number of 1 and from Jan 16 to Jan 31 to 2 and so on... that way we would only look for the number 1 or 2; depending on which pay period we are processing, would be alot quicker. Does this make sense and would it be quicke…

I thought all the way to the metro about it, but couldn't find a real solution...so I got a specific problem with some Look Ups...Here's the scenario: I got 2 files, one for Contacts, another one for Organizations. In my Contacts database if a user enters a new record and links it to an organization, all the designated information will be auto-filled as LookUps (Address...). In case of more specific data the user of course can change this manually. So far so good. If an organizations' data will be modified of some reason a script can handle the Re-Look Up of all these fields - BUT - I just want to Re-look Up all these records, that had not been modified by any user s…

Hello, I hope anyone can help we with this problem: when I am working on the Mac (10.3.8) I can't delete any field from an special existing database. When I transfer this file to the PC then this fields can be removed. Does anyone know about this?

I just set up a relational database to move my pdf scans to another database. When I went to use the "replace button" to have the pdf file spread across multiple records it only went in about half of them. Never had this problem before I went relational. Any thoughts? Also, the servant file (used to hold the pdf scans) is larger than the main database. What is up with that? [color:"black"]

Hi there. I have 3 fields: Full name, First name and Last name The only field that is entered and displayed is "full name" - the other two are purely for sorting purposes. Does anyone know if there is a way I can make the first and last name fields calc fields that automatically separate the two names and enter the correct info? For example, if I entered "John Smith" into Full Name. First Name would become "John" and Last Name would become "Smith" Any ideas?

Searched on globals - can't find it. As I type stuff in a field on a list, I want it's UPDATE field, a date, to grab a global date which is in header. Auto-enter on this update field is set to calculated with the do not replace unchecked and calculation is just globaldate field. It doesn't put the date in each record as I type stuff in the field. Any time i change a field, i want this date (whatever is in the global) to change in the update field. i thought globals could be seen by all records. I don't want modification date because the date modified may not be today. that's why I'm using the global date. I'm missing something simple i suppose but now I'…

Hi All, The question I'm about to ask is similar to some already posted here and I've read a whole bunch of them but I still can't solve my problem. So, please help me. I need to create a different 5-digit sequential serial number for each category of items in my inventory DB. For example: Category: Packaging ----> item ID 7XXXX Category: Raw Material----> item ID 1XXXX Category: Resale----> item ID 3XXXX Category field is a member of VL formatted as a pop-up list and the appropriate category is selected when creating a new record. Thanks in advance!

Hi, I've added a new table to my database with six new fields, two are linked to other tables. In a new layout for this table I cannot enter into any of the fields to enter new data. I have made sure that in Field Behavior that the field can be entered in browse mode. These are text fields. There must be a simple answer that i am overlooking. Thanks Will

Ok. I feel like a fool. It won't be the last time. In the Specify Calculations View Functions By Name, there is a Get(flag). But it appears in none of the categories! None! It isn't listed in the Get Functions and it isn't listed if I View Functions By Type either. In fact, I went through every darned category in the functions list and can't find it. When I type Get(flag) or even just Get in FM help, it produces the Get() functions but it isn't listed there anywhere I can find. I can find no reference to Get(flag) anywhere. When in Help, I display the alphabetical listing of all functions, it isn't listed. I know I'll appear stupid for asking but I ca…

I am new to FM 7.0 and have accepted a projet from my employer to create a set of forms that are printable. I could really use help with a few things like creating a drop down list box then when value in drop down list box is a,b,c,d, or e put text/.gif/.jpeg/value in space 1,2,3,4 etc on form/page 1, 2, 3, or 4.... any help would be great tyvm` Silose

Hi! I have an invoice # that is the Date Created and a Company Code, eg: 032305HAG (where 032305 = today's date and HAG is company code for a particular client). To automatically insert this, I created a calculation: Date Modified &""&ED Contacts::IN Code However, what appears is some weird #: 732028HAG -- so the company code is going i correctly, but the Date Created is I don't know what - the # does correspond to the date somehow because it is different for a record from yesterday. Does anyone know why this is doing this and how I should fix it - is there a better calculation? Also, this is my first posting and I am an advanced basic user…

In response to my query about creating a calculation to put together a date and code answer, where the calculation is 032305HAG - the following response was posted: Filter ( GetAsText ( Date Modified ) ; "0123456789" )&ED Contacts::IN Code However, I don't have the "Filter" function - I tried just typing it in but it told me there was a problem - the only way I could get it to work was by taking out the "Filter." but is it possible, it actually needs to be a listed operator? (I am using FMP 6) My result is now: 03/23/05HAG - how do I get the "/" out? Thanks! Sarah

We manage small image archives for a number of clients who wish to view their catalogues via the web. We have been using FM5.5 to manage these archives and run our own web based stock image library. No problems until we began to upgrade to FM Server 7 Advanced. We want to use IWP to publish the smaller archives to avoid the cost of custom web publishing. One huge problem, we cannot get the images to appear when published to the web using IWP. Have tried calculations using the relative file path with the result as container, eg. "image:/<<filepath>>/" & Image ID, the image appears in the database before publishing using IWP but is replaced with a "?" icon w…

Hello, I have a calculation field that incorportates both Text and Numbers. I would like to format the numbers to have thousands seperator, but the calculation result has to be Text; given that, is there anyway to format the numeric values within the calculation? I tried to format the field in the Layout view by clicking on the merge field and then going Format->Number, but it didn't do anything (which makes sense since the result is being formatted as Text). Is there a function that I can use line by line within the calculation? Thank you for your assistance. Regards, Jason

Hello, I've made a small database that has both fields and radio buttons. For some reason the e-mail field works when you enter your e-mail, but then the next item is a gender radio button set. When I then select the female button, e-mail is replaced by female. Why? why? why? I didn't do them together, I don't have them linked in any way. I just don't understand.

Hi everyone, Well I know I could script-parse this puppy but I had the hair-brained idea I could use a calculation. So this isn't a desperate need to solve an immediate problem but I'm so irritated at my text-function disability that I really want to know what it might look like. I have attached my simple working demo. Two tables: Products and Inventory. Data for a product in one text field (multiline) thus and I need to count them. 'e' is for each (simple); 'c' is for case quantity (taken from the Products table), ie, 46 * Products::QtyPerCase. As you'll see, I haven't gotten very far in this calculation (reasons below). e 11 e 4 c 46 e 8 Wh…

When I worked with other DBMSs, I did not create indexes on fields where the cardinality (# of distinct values) was low. So for example, if there was a field with two possible values (such as yes/no) I would not have built an index because it would not improve performance and would in fact damage performance because of the time required to build, maintain this index. This was related to the "page size" used. is there an equivalent concept in FM? I have two questions: 1) is this a valid concern for FM7? 2) are the indexes built when the file is loaded (opened) or are they stored as part of the file?

I have an FM solution that generates summary reports. When it generates reports with less that 20,000 records the summary fields calculate correctly. When it generates more that 20,000 records, the summary fields will not calculate at all. I don't know if this is a limitation in FM or if my scripting my be incorrect. Any ideas?

Hello, i was wondering if someone can help me out with this. Basically i have a summary report base on the field call status. The status field is drown down menu. I have one calc that is not working me. This how i have it, i have the fields: c_Withdrawn Calculation = Status="Withdrawn" c_cnt_Withdrawn Summary = Total of c_Withdrawn c_c_cnt_Withdrawn Calculation Unstored, = Sum(c_cnt_Withdrawn) The calculation works as long I change the Status name to Something else. any help would be appreciate it.

I had set my hopes too high, when I had some autoenter fields containing: Evaluate(Case(0;0);g_Something) ...note that I out of pure sloppyness/lazyness, use Case(0;0) instead of "" because I then can duplicate the fields and change type afterwards ...even into time or date. But here comes the question, is there a way to prevent the autoenter to execute when creating a new record or duplicating?? In my ignorance did I believe that since we were talking about a global would it be like the same field every record, with no need to refreshing at all since it was global. --sd

Hi, all. We are trying to make a file that contains a bunch of PDF documentation. Two of us have worked on the file, myself and my boss. We both insert PDFs into a container field the same way, namely: 1. Right-click the field 2. Select Insert Object and then Create From File 3. Browse to the PDF or enter the path 4. Uncheck the "Link" and "Display As Icon" boxes 5. Click OK For the PDFs that the boss has inserted, when a user double-clicks the contatiner field, the appropriate PDF is opened in Acrobat Reader as expected, with the title "Acrobat Document in FIlename.fp5" in the title bar. However (and here's the kicker), the next mouse-click inside of Fi…

Another problem... I have a student behaviour db: student_name (value list from another db) time_out_id (auto-enter serial) various fields I have a script for new record which allows me to enter data... but if I go to another layout to select another student...to view their record before creating a new record...I can select another student but their name goes into the record of the student I just entered information for together with their own previous records... How can I exit the record, "freeze the record" then find a new student... Help please TIA

Hi All, I am having difficulty in creating a summary total of data in a related table. 1st Table (Comparison DB) contains the field "Site", "Machine Type", "Gross Revenue" 2nd Table (2002) contains the same fields but has hundreds of records because at any one site there can be multiple of the same machine type. The relationship uses "Site" & "Machine Type" The 1st table will only contain one unique record for each site and then machine type but needs to summarise the gross revenue from table 2 by machine type. This summary field needs to be placed in a report on table 1 (Comparison DB) but extract the data from table 2. Is this possible ? Hope somebody …

Here

I have 2 date fields and a notes field that I have to combine with no slashes or dashes or othe marks (for export into another program) This is the format I need to export: mmddyy mmddyy note This is my calculation field Action Date & " " & FollowUp Date & " " & Action Notes This is how the field should look: 020904 021004 client seems to think there is no budget but this is the result I get 731620 731720 client seems to think there is no budget -------- I'm guessing that a date format uses some underlying numerical calculation, because I get a similar result in Excel if I change a "date" format to a Text format. …

I have two databases, the first is a manufacturers database and the second is a database with every item sold with information such as the price and manufacturer code. In my manufacturer database I have a layout (viewed as a list) with a portal to find all line items with the same manufacturer code as the current record (there are about 50 total codes). That part works great, when I browse that layout it shows a summary of all of the sales from each company. I then have another leading grand summary at the top with a summary field that sums up each individual manufacturer. The problem is that it doesn't update consistently and I have a date range implemented. If I op…

I have a db with fields student_id (unique serial), names...etc, time_out_id (unique serial), behaviour (with text about the particular behaviour that caused time out), letter_home_number. In another layout I have a form letter sent to parents that includes the field: letter_home_number. What I can't work out is how to automate the letter_home_number...ie on first time out the letter number is 1, 2nd time out 2 and so on. I think I have to make the letter_home_number a calculation-count field but I'm not sure if I'm on the right track... Or do I need to have another field for each time_out record: number=1...do a find script then count the number …

Greetings, I have a need for a five-digit number, that always displays all 5 digits. So I have it initially generating as a serial number (00000 +1), which is working great. However there are occasions when I want to duplicate records, and keep this value the same. I made a global field to store the old value, and then just set the field on the duplicate via a script - but it is dropping the zeros when it displays it on this new record (which is not ok). Question 1 - Is there a way to force it to display any front end zeros if it is not 5 digits on its own? Secondly... It is quite common that these numbers are being changed to other values that already…

I have a question about formatting numbers. Is there a way to format a number such that if it is not a whole integer it will display as a number plus a fractional remainder? To complicate this further, I would like to constrain the fractional result to eighths (1/8) or sixteenths (1/16). For example: 1.625 would show up as (1-5/8) and 1.685 would show up as (1-11/16). If the fractional result was other than an eighth or a sixteenth I would like to have the number round to those type of fractions. If anybody could help me here I would sure appreciate it. Thanks, Jarvis