Calculation Engine (Define Fields)

I am sure this is quite simple. I want to type in a client ID from my client table into my sales form which would then enter the clients Name, etc. I have established relationships between the two tables and have layed out fields matching the two tables. When I use find mode in Sales and enter a client ID I get this error: No records match this set of find reguests. After many hours of reading thru th ehelp files I am still at a lose. This should be the easiest thing to do??

I'm two weeks new to FMP, so I am by all means very much a newbie. Originaly I thought this was a pretty simple problem but I'm no longer sure if it is. I've simplified my situation here; any help would be appreciated. Basically, I want create a record with a visit number attached to it, serialized on CId's. I have a ClientTable with a unique CId and client information and a VisitTable with a visit number (N) and visit ID (VId). A record in VisitTable holds: VId, CId, N, and other info. VId = CId&N CId currently is entered by the user and must be a value already present in ClientTable. N should be 1 if the entered CId is not already in VisitTable, 2 …

I have a database, and I am going to duplicate it, strip the data and build up a new database (they will work in very simialr ways). However I notice that the RecID's for my CDML web files are still vey high numbers, and I'd like to bring them back down - so how do I "reset" the database to think it is young instead of old? Thanks A

How do you make a field concatenate its text contents instead of displaying a "?" if the text is too long to fit in the field?

I have an identifier that I want to generated based on other information entered. It seems redundant and chancy to make the user create the identifier when they have to enter in the other info. Example: FirstName: Mary LastName: Watson SSN: 123-45-6789 resulting identifyer: WM6789 I know how to concatonate, I just don't know how to extract precise data from a field. Help please? -parima

I have which I have set to be a button - user clicks on it, a little window displays, they pick the item and it puts the item name in the field , which is defined as a button. However, when they do a find - they click a button i have called find, I put the layout into find mode and I would like to allow them to enter criteria in that field - so one immediate option is to create another layout. (oh this field is set to a gray color and embossed) Is there a way to toggle this button-field to just field and change the color to white? I just thought it would be great if I could avoid having to create another layout just for that thanks, Sincerely, J_…

Hi everyone, I need help understanding how FileMaker processes the following lookup conditions ... Structure: Contacts to Invoices (on ContactID, standard text) using = Invoices to LineItems (on InvoiceNo, standard text) using = I need to lookup the Contact field SalesRep into both Invoices AND LineItems. I know it appears redundant but there are various SalesReps which may add onto an existing Invoice and their payments adjusts accordingly. Sales Reps trade Contacts like baseball cards. So the control of charging out an Invoice or LineItem is determined by who possesses a Contact at the moment an Invoice is created and also at the moment each Lin…

ok so far ive gotten this Credit_lookup= GetField ( "Ref1" ) & GetField ( "Ref1 Copy" ) causeing the file to place the ref1 and the ref1 copy field next to each other on the same line, ive tried "ref1"

If I have a field that contains text, seperated by paragraph returns such as: Apple Orange Banana Pineapple Cherry And I have another empty tect field... Is there a calculation that can be used that if I type any of the words contained in the first field, the calculation would return a positive value. For example, if I type "Orange" in the second text field, the calculation sees that the first field contains the matching word "Orange" and so the calculation returns a value of "Yes" Larry

Is there a way to have a calc that determines if a record is part of a found count? Say I have 10 records in the found count... I know I can have a field that uses Status(CurrentFoundCount) and will return 10 I can also put "@@" on the layout, and it numbers the records in order from 1-10 If there was anyway to do the equivelant of If("@@" < Status(CurrentFoundCount), "Yes", "") Of course that is impossible, but it was the best way I could think of to describe what I was trying to do. Larry

I've been searching the web relentlessly for info on the best way to generate a Table of Contents in a lengthy report, and surprisingly, what I find is next to nothing on the subject. Is it not possible? I'm posting in this forum because I'm hoping that calculation fields will be the solution (vs. a script). Any help is appreciated.

I am working on creating an imaging store for our design department. One of the requirements they want is to automatically import fie height, width, dpi, and pixel information you see in photoshop or even in the window properties into the database fields in FMP. When I use the import folder function, I could not find such details in the import option. Does anyone know if there is a plug-ins that I can use to do this?

Hi, I am using FMP Developer 7 on Windows XP. I am trying to define a calculation field called

Hi there, considering myself slightly above newbie (FM) I am stuck with the problem of getting a lookupvalue (number) from another table in the same db. the function inserted refuses absolutely to produce results and is continously balking: The specified field cannot be found. I am using/referencing the field from the account/field list of the table involved. The formula looks like this: "Lookup ( Accounts::Commission_Discount {; 999} )".Can anyone help me with some enlightenment? Appreciate very much any hint to guide me on the right path!

I have a calculated result being input into a global number field. Is there a way to limit the number of decimal places displayed or calculated? Thanks.

Hi, Me again. OK, so I have gotten so much help from you people I can't thank you enough. I have figured out my page problem and it is working like a charm. Now, I want to highlight the word in the Page file. I have made a script that will do this but my question is, are all text formatting functions case sensitive. I have a calculation based on what is entered in a global field and all the words that are on that page changed except the ones that were capitalized. Can anything be done about that?

hi all, I am trying to parse out two fields that have data and page numbers. The field contents look like the following: "THERE..............5" or "xxii; xix; 188; 188; 189" I want the first field to simply break into two new fields: "word" (THERE)and "occurance" (5). I did the occurance part with a rightword function. I tried the word with a leftword function but some are compound words using "-" or even some with apostrophe's. I know there is a way using length and position. Like anything to the left of the ... (some have more than 3). The second field I want to break into fields named for the page numbers and how many times it appears on t…

Is there an elegant way to check for 'illegal' characters, according to a schema that you define? For example - users are allowed to create an on-screen alias for themselves, but you don't want their alias to contain any characters like: !@#$%^&*()_+-=:;"',./<> etc. How can you perform validation on a text field to make sure that it doesn't contain characters you don't want? Thanks,

Hi there, I need to create a field for a call center database, where this field sould contain the Date & Time together, i.e., when I create a new record, this fiels is our Call Log number. Ex.: the client call today 2005/02/02 at 15:03 I need that in the fiel appear this--> 200502021503 Is it possible? Anyone can help me? Thanks in advance. Regards JD

Is there any way to look up a value from another table if the Key field is not an exact match? For example, I enter part # J1234 in my quote form. If J1234 does not exist in my pricebook, but J1234A does... can I have it return the lookup data for J1234A? Thanks! -Scott

Excuse me for being dense. I have three fields, Subject, Number_One and Number_Two. I want the max for these two number fields summaries at each change in subject. So I created two summary fields Summary_One, Summary_Two, each set as Max of those number fields. When I place these two fields in my subsummary by Subject, I get correct numbers. Then I tried adding them with another calculation field Added_Number = Summary_One + Summary_Two. However, when I place this field in the subsummary, it do not get what I expect. I get a much larger number, the source of which I haven't found yet. Please let me know my fundamental misunderstanding a…

I have information as Event, EventTimeGroup, SecondCount. I am able to summary the beginning and ending SecondCount for each EventTimeGroup. However, I want to know the difference between the ending SecondCount of the previous EventTimeGroup and the beginning SecondCount of the current EventTimeGroup. Example: Thing1 1 22 thing2 1 44 thing3 1 66 thing4 2 88 thing5 2 99 I know that EventTimeGroup 1 began at 22 and ended at 66, and that EventTimeGroup 2 began at 88 and ended at 99. (Using summaries based on sorting by EventTimeGroup.) How can I calculate that 22 second elapsed since EventTimeGroup 1 ended and EventTimeGroup 2 began? …

Hi guys, Has anyone every come accross a formula that will text format a field like so The user inputs: my name is david.i live in a town.Please vist me And the format output from the formula My name is david. I live in a town. Please vist me All i want really is the first letter of every sentence capitalized and there be a space after every . Any help very much appriated. D

I have a week number field and a year field (both numbers) and I would like them to return the date for the monday of that week. Any suggestions

Hi, Setting up a calculation of type MyTime - Time(8;0;0) and then formatting the result of such a calculation as HHMM rather than HHMMSS or use any format appears to change the result *displayed* whenever the calculation yealds a result from -1 hour to 0. So that if MyTime is 7:30, the result will display 0:30 rather than -0:30. Above a gap of 1 hour, all is working fine. Tested on French version FMDev7. Is this the same result you get ?

Hi. I would like to specify a calculation for a field A. For fields 1.... n, I want to count the number of fields with the value ? or {blank} (i.e., a non-numeric entry). Can somebody assist me with the syntax? Thank you, Gwen

Hello...I need to figure out how to define a field that will sequentially number subrecords that are created through a portal of a main related record. For example, I have a table with a field that sequentially numbers records created in a log of images. In another table I have a field that I want to sequetially number the revisions to that original image. Example: original main records are sequentially number 1, 2, and 3, then I want the subrecords for original main record to also track 1,2,3. I create another field that joins the two numering sequences and display it in my portal rows as the revision number: First main record with subrecords 1-1, 1-2, 1-3 Se…

Hello everybody, Is it possiable to make a calc that looks at a fields date of modification and when it is over 30 days from current date it will flag it for reminder either by popup mesage and or by appearence on a portal? Joseph

I am trying to define a calculation field to concatenate multiple text fields. I cannot find contatenate listed as a function and it does not seem to be recognized as a function is there a way to do this in FMP 7 is the procedure any different for FMP 6

Can't find a simple way to add in the footer something like: Page ## of nn ## is the current page nn is the total number of pages Is there a symbol for number of pages to use with ## for (current page) to do this?

I have 2 Databases, 'Quotations' and 'PO Request' From the Quotation Database I Generate a PO Request using 2 sub-scripts. (1) Find Current Quotation Number (2) Perform an external Sub-script. This external sub script is in the 'PO Request Database' and just Imports the required fields for that Quote from 'Quotations' to 'PO Request'. One of the Fields I import is the Quotation number given as Qnnnnn. Within the PO Request database I have another field called a 'PO Ref Number' that copies the data from the imported 'Quotation No. field and Substitutes a 'P' to give the Pnnnnn PO Ref Number with the same nnnnn part. Because there can be a number of PO Req…

I'm making a layout for logging my video tapes using timecode ins and outs for my clips. I want to simply type in 8 numerical digits and have FileMaker put a colon in the number after every two digits, so I don't have to type the colons in by hand after every 2 time code digits. I've tried every combination of settings that I could think of in the field options panel etc. I found a layout online, but it required me to type the number in one window, and then it put the number with the colons in another window. I'd like to type the number in, and in same window put colons after every 2 digits when I tab out of the box. Is this doable and can I get pointed in the r…

Hi, I was wondering in Filemaker 7 if there is a way that the slashes or dashes be put in place as the user enters eight digits in a field. I.E. as I input 03 than a slash appears automacatelly then input 26 then another slash then input 2005. Thanks in advance.

Anybody else making databases of events? How are you handling dates, particularly multiple dates? For example, a concert may hold two weeks of dates until the tour solidifies and they settle on one particular date. Or a basketball tournament may occur across three days. Thus multiple dates per event. In 5, I had date as a repeating field, but that has obvious limitations, first being the number of dates an event can have is limited to the number of repetitions the field has. In 7, since I can have multiple tables in a single file, I thought I'd make Events one table and Dates another, with the Dates table having EventID as a foreign key. Sounds good. I can…

I have a layout where a text field DESCRIPTION is entered into as an Edit Box. I have another layout that is a form letter and it displays the field DESCRIPTION as a merge field. My problem is that I can not figure out how to force a text line to automatically wrap at the end of the last word on a line rather than breaking words in half. This problems occurs on the first layout when I originally enter DESCRIPTION and also on the second layout when the merge filed is displayed. How can I force the text to automatically wrap to the next line regardless of the size of the text display box or the merge field function? Seems to me that this should be very simple but …

hello all ... i work with a photography company and i am looking to create camera cards ... i am currently using filemaker as my primary database program ... The "Camera card" is an 8.5x11 sheet that will display 9 records on it ... this is relativly simple... but here is the catch ... i need the records to be sorted very oddly before printing ... see the attached three images to better explaing what i need. Lets just say that my database has 27 records for sanity's sake. on the cards i need the records to be printed "stacked" what i mean is that on page 1 the first record should print is the first of the nine slots. (see attached) however ... the second record needs to …

Ok, So I have a fields named "Surv". This field is a calc field... a simple case function. When I go to storage options I can not change it to any indexing. So here is my problem.... How do I make a portal Index itself off of a calculation field... Noting shows up in the portal... Is there a way to make this work? Oh, I know about the auto-enter calculation... that works but I need the number to chang when I change fields... auto enter only works when I enter a new record... Help, Joseph

Sounds like a beginner question If[isEmpty ( field )] What I was looking for is "if not emty", i need a check on a field and if it is not emty a popup should open. I tried isValid but it did not work.. Any ideas?? Thanks

Hi, part of what I'm trying to develop includes a timesheet and record of tasks undertaken by the user. Basically, I have a table for the Timesheet. On the Timesheet, there is a portal to enter in tasks for the day. The relationship is Accountname and Date, so the timesheet only displays tasks for that User on that specific day.... pretty straight forward. My problem is this, I would like to be able to display the time used in the day as a 'bar' so it is easy to see if there are gaps not accounted for and the user could then ether add in tasks that were forgotten or adjust times of existing tasks. It would be handy to highlight overlapping times also, so they can be …

Is there any way I can limit the number of characters a user can enter in a certain field? I have a script that matches two fields and then displays some related data in a different layout. Lately it will occasionally display the data from a different field in the record. In each of those cases, the field that is being compared in the find has an extra character, usually a space. I'm thinking this extra character may be messing up the search (I'm grasping!) and would like to sound an alert or something if the user exceeds 8 characters in that field. Any ideas? Thanks-- Susan

I'm building a networked solution for my cabinetshop. My ultimate goal is to be able to save my CAD drawings as PDF files and have them available for view at client stations throughout the shop. I'm having a problem getting the image to show up crisp and readable on the screen. I'm not sure if the problem is software based or hardware based. The only monitor that works like it's supposed to is a 20 inch apple display on a Mac G4. My network is configured as follows: Computer 1: G5 Imac > Filemaker Server > Filesharing turned OFF Computer 2: G5 Imac > Dedicated server that only holds images > Filesharing turned ON. Computer 3: G4Tower…

Hi, I have asked a lot about the count function, but now i have solved my structure problem i still have a similar problem. I need a calculation which can count the ID's in my order table but exclude the ones that have a field "Cancel" set to Yes. This needs to return a total, i tried using a summary field but that wouldn't let conditions be used, unless i missed them MnR

I have a layout that has some fields that repeat. But on one layout, I want to show the field of repeat 2 as a merge field. Is this possible?

Hi everyone, I keep getting the feeling that my logic is wrong on this one - or that my calculation result just plain sucks. Every time I look at the structure of it and the resultant calc, I shudder. And if I shudder, I figure it's pretty wonky. I have a Rules table with one record. It contains several fields which mostly hold numbers. These fields determine when various actions should happen. Some actions are event-triggered; some display on a Sales Reps desktop requiring action; some are used in calculations and so forth. And Management (in Browse) can manipulate these rules to tweak their own business according to their needs. They can specify when a…

HELP! Hello I'm new at Filemaker and so far I love it. I do have this one nasty little problem that I'm sure is me just overlooking a setting or preference. What I'm trying to do is drag and drop text from a web page into a FM text field and have it take on the text fields attributes. When I take say Arial text off the web and drop it into my FM text field which is set for Helvetica it does not convert. It stays Arial with the same font size? I just want all text I drop into a field to auto convert to that fields text attributes. Any help is greatly appreciated! Thank you in advance Hef

Hi, Here is my question. I have fields with questions that the answer is yes or no. I want to skip the next field if the answer is no. Can someone share there knowledge with me and help with this question. Thanks in advance. Rob

Hi, Here's a strange one. I have a field where I have a button set up so when the user presses the button it enters a time stamp in the field. But I don't want the user to have the ability to just go in and modify the time stamp (but I want it visible still). Is there anyway to do this or do you have any ideas... it's for a time clock type thing. Vandy

We have a table of 179 fields, about 80 are calculations. Of the 80.. 35 are set to automatically create indexes as needed 10 are set to index all and the rest are set to do not store calculations. Is there a difference in terms of performance with FileMaker? The reason I ask is because when I defin a new field in that table it takes about 7 minutes for filemaker to finish, after clicking 'ok' to close the define fields dialog and exit back to the regular scrreen.

I have a field that calculates an amount based on what is in another calc field. When the one field changes the second field doesn't calculate. What am I doing wrong?

I want to bill an advertiser for an ad in this month's monthly paper. I also want to itemize past due amounts. I set up a list layout using the header for the current bill, and the body for past due amounts. Fields are issue_date for the current issue and past_issue_date for past due. Both issue_date and past_issue_date fields are formatted month/year My calculation for past_issue_date returns all dates instead of just past due dates... If(Month(TextToDate(Today)),"",issue_date) What am I doing wrong?

first wanted to say - Thanks to everyone who has helped me out, I really appreciate it. Second, I don' know why but I seem to be tripping across these interesting scenarios. I have 2 tables, one called UI_Table and one called Projects In the UI_Table I have 2 globals (among others) ; they are gSortOrder and gSortfieldName I have a script which when I click on a field in the Projects view I set these globals. Works good. I got creative and though "hmm, be nice to show this to the user". So I created another field, SortStatusCalc in Projects table (just a calculation field - unstored) and when I put this code in it, it only shows the contents of the first …

Constructing an inventory database. Along with all the fields that define the inventory item I have two fields to be used should the item be placed out of service. They are the "date" the item was placed out of service and the other is a comment area. Question 1 The fields in question are: Item Name and DateOOS (out of service). I wish to have the item name be set to "proper" AND change to the text to the color red IF the DateOOS is not empty. I can have the item name perform the Proper function and I can get the text color to change. I cannot get both of them to function at the same time. I am doing this all through the Auto-enter calculate wi…

All, I'm puzzled about how to validate a date field, i.e. to check for impossible or incomplete dates. In FP6 I could do this with the "isvalid" calculation. FP7 seems to be more tolerant. I have 3 numeric fields, Day_n, Month_n and Year_n, and I want to check whether the resulting date is valid. Of course, things like 1/0/2005 or 2/29/2005 should be invalid. FP7 just returns 12/31/2004 in the first case, 3/1/2005 in the second when I use Date_d = Date(Month_n;Day_n;Year_n). Consequently, IsValid (Date_d) always returns 1. Any ideas how to do a *real* check? Thanks for any ideas! Lutz

hi, how would i use a count function to return the number of occupied records? The occupied records would have the WeightNeeded filled in and i need to count these, but exclude ones with a field called "Cancel?" set to Yes. or i have just thought, or even better would it be possiable to make a script which when field "WeightNeeded" is occupied takes 1 off a global field so then i can get how many i have left?

Hi, I have 2 tables, among others, they are tasks - invoiceLine Items table. I have a relation between the two and in the Tasks table i have a calculated field, which is unstored and sums up all the invoice line item records for each task. So, each time an invoice is request is entered, when you look at the tasks table, you'll see the "Total_Paid" field in each record of all the invoice line item records entered with the id in it. This has all worked fine - in a multi-user environment for awhile. For some reason, which I'm trying to determine and I hope maybe someone has seen this. The other day the Total_Paid field stopped showing/summing. Of course, the …

Hello, I'm a bit new to FileMaker and I've come to a situation where I have a Name field for entering a person's full name. However, if in case there is a name too long, FM seems to cut it off when viewing that field in browse mode. However once you click inside the Name field you see the whole name. My main question is, how can I have my database take a full name and perhaps display it in the name field as (first initial of first name and then full last name?). For example take a long name like Richard Blahblahblahman and have it displayed as R. Blahblahblahman. Thanks for any help!

hi, I am not sure how to get a field to except an input with 3deciaml places. The user has to basically input a weight (in kg) to the nearest 5g which i think should be 3 decimal places. I need a way to define the field to accept this. Ideally the decimal should be already in the field but it doesn't matter. MnR

You guys are so good it scares me. I have another one for you. I have an entry field that allows someone to enter a fraction and I hav another field which turns that into a decimal. Currently the calculation is as follows: Case ( Right (Amt Entered ; 3 )="1/8" ; If (IsEmpty (Left (Amt Entered;Length ( Amt Entered)-3 )) ; .125; I have this same line for every "common" fraction used in my solution. I am trying to make one that will use perhaps a pattern count to find the / and then divide the numerator by the denominator so it will work with whatever fraction entered. This also is needed for a full number and a fraction (3 …

Hi, I am newbie in FMP. Some fields on a record are about the rate from a service provider: ex: hours: 20$/hrs week: =hours*40 month: =year/12 year=week*52 So i'm using formula for thoses fields except for hours. What I really what to do is to be able to punch a number in any of the "Rate fields" and them automaticly it will updats the 3 others. EX: punch "400" in week, will update hours at "10", month at "1 733", and year at 20 800. EX2: punch "26 000" in year will update automaticly hours to "12.5" week to "500" and moth to "2167" What will be the best way to do that ? and what will be the formula? thanks in advanc…

I have a database consisting of many records and layouts. One of my layouts that I use for printing has a subsummary part. Each Record in the database has a number ie; 1m1, 1m3, 2m1, 2m2. When I go to this layout for printing which has the subsummary part it puts a heading over the records in that series. ie; Group 1: followed by records 1m1, 1m2; Group 2: followed by records 2m1,2m2. The group number is derived from the first number of the record. What I'd like to do is add another piece of data to that sub summary. For each group there is a version number that the user manually enters on a different layout. I'd like to have a calc that reads which group number is i…

Is there a way to prevent a user from quiting the file or application if he forgot to fill out a field. I played with a script, and the file option on exit the file. But no luck! Any help?? Thanks

I am trying to import data from one table to another. The purpose is to produce an export file in a preset format for use by another application. The big table called CR_1 is flat and used for the actual data export ... it contains the rules that apply to airline fares and are related to a number of smaller tables by one field (ContractKey) and when needed by a second matching fieldthat each contain various related parts of the data. For example a contract has various seasons of validity ( anything from 1-40 possible periods per contract) This data is held inother table CR_Season and related to CR_1 by the field ContractKey. Each record also has a sea…

Hello I am making a relatively small database and thus am storing files (not as references) in a container field. I want to view these files but the only way I have found to view them is to export the data. Is there any other way to do this? Is there a way to write a script that I can attach to a button that will automatically launch the program the file was made in and open it? Thanks for any help

I'm just starting out with calculations and have made some really simple ones that work (!) but I think what I want to do now is beyond what my mind wants to get around at this point. I have a table with records that are created through a portal in another table (basically a line items arrangement). I need to do a calculation to add all the quantities of items (fabrics) that meet two conditions from TWO fields in the LI table. So, there are: ShippedTo (a location) MetersShipped (a number) I want a calculation that says IF ShippedTo = (a particular location) AND if the FabricID for the record is the same (there can be multiple shipments to the same locatio…

Currently I have a portal based on data entered into a global field (let say gMake). When clicking on a row of the portal, there is a script that populates other global fields, (gModel, gYear, gColor). However, the specs for the interface has changed now, and now I have to have two fields but only one portal. In other words, Now I need gMake and gMake_Replace. When the user puts in Ford into gMake, then clicks on the appropriate portal record with button, it will populate gModel, gYear, & gColor. Then the user should click into field gMake_Replace. New values should come up in the same portal, and when the user clicks on the portal row, the fields gModel_replac…

I have no problem telling numbers to have 2 decimal places while in Filemaker, but once the information is published online they seem to get a mind of their own. For instance, in Filemaker I can view

Please excuse the ignorance on my part but I am a total n00b as far as FM and databases are concerned. I have just created a flatfile database which contains data on clients [Contact data etc,] and also membership and contract records [licence No.s and Contract refs together with the associated inception and expiry dates.] My question is this: If I enter a date in one field, can I apply a calculation on it amounting to a fixed period of time [such as eg. xx/xx/xxxx plus 4 weeks or xx/xx/xxxx plus 12 months] and then have the results appear in another field? I have managed to get a few other more simple calculations to behave like this with basic numbers,…

Dear all, I have a question and I really hope someone might have a answer for me. Currently I am developing an image database for fm6. every record should know about 2 kind of images - high resolution and low resolution. I am storing those files on a central place with the help of trois file plug in. what I love to do is that the user does not need to create 2 different images - instead filemaker can create out of the high res image a second one (the low res image). is there any plug in out there? so far I have tried a combination between the scripting possibilities photoshop and apple script but I would love not using photoshop for this task. does some…

Hey This might seem like a dumb question, but I am in the beginning phases of designing a filing system for a court office. I am wondering if setting a global field in a database will cause problems if the solution is implemented using advanced server 7. For example, Im using a script to add parties to a lawsuit record using a join table. I'm using a global field in the parties table to keep track of what suit the user is adding parties to. Now, if there are more than one users adding parties to different suits, I'm guessing one user will overwrite the global field entry so that the first user ends up adding parties to the wrong suit record. Is there a way …

I am very new to FMPRO7. I have html and Flash programming experience, so I understand the basics of programming. Can someone help me get started on creating a solution to the following problems? - User types in 6 digit number (xxxxxx) tabs out to have 6 digits formatted to xx-xx-xx - User types in 8 digit number (xxxxxxxx) tabs out to have 8 digits formatted to xx/xx/xxxx Any advise or help in this matter would be greatly appreciate. Thanks for your time, Carl

I am trying to make a few templates that I can cut and paste into new databases. What I have done is creat a NOTES table, where it has a few fields to personalize the global fields in the solution. Is there a way to have the user (or me) input into a field the starting number in an auto filled, serialized field without having to go into the properties of the difined field? For example, I would like to fill in a field in NOTES named Starting Serial Number, and have the field Computer.Info::ID NUMBER start serializing based on the value of NOTES::Starting Serial Number Does that make any sense? Thank you in advance for any help with this!

I have a multi-file relational database. One file contains a termcode which all other files use. The termcode is declared globablly in the "Admin" database since there is only the one record in that database. My problem is that when I am connected remotely, I can change the value in the field, but when i close the file and open it up again, the value is reset to it's original value. The only way that I have found to change the value is to stop FM Server and open the file locally to change the data. Is there some way that I can do this whithout having to stop the FM server?

ok here is what im working on, basically it is a printable form. The info for this form will be brought in from an .xls file and will drop into the form. There are two parts to it one will have the look of the current program being used Versaform (an old dos based program thats why we are doing this) the second will convert this information in to a printable format for sending out to clients as a bill. now i have much of this finished except for this. a normal row contains about 6 - 10 lines of infomation broken down into 8 columns of that row. but after talking to the owner it should be able to handle up to 60 lines from 8 columns. and if it has to make a second or…

Filemaker calculations can be used as an Internet Scripting Language example: "http://www.google.ca/search?q=" & "Company" & "" This Calculation when Transmitted as a URL to Google Searches for the variable in Company Example: Company= Acme Widget Co but I want to search for the phrase "Acme Widget Co" and Filemaker removes the " " or misinterprets the vatiable. Any Ideas? I tried single quotes and extra quotes neither solve the problem

I am trying to make up a table that takes one of three hazard risk categories (High, Medium, Low) together with a likelihood probability (Frequent, Probable, Occasional, Remote) to calculate an overall risk (HIGH, MEDIUM, LOW) such that a High risk and Frequent or Probable frequency results in a HIGH overall risk, and a Low risk and Occasional or Remote frequency results in a LOW overall risk (with similar results for other combinations). I can get it to work once, by defining calculation fields to give a numerical result for each of these parameters. I defined a value list using Pop Up values, then with related calculation fields giving a value of 1 to 3 for each of t…

What function do I use to display the current date all the time, not just when the record was created. Thanks,

I am trying to make a calculation to detect the word Monthly anywhere in a text string. current calculation will only detect it by itself not mixed in with other words. If(memo="Monthly";1,0) Thanks

I am working on a solution for managing school information. I have a table called "Classes" containing a 'Class_number' field (ex. 604) and a table called "Subjects" containing a 'Subject_Code' field (ex. MATH). I would like to calculate a 'Course' which would be a 'Class_Number' plus a 'Subject_Code' (ex. 604 MATH). If there are 12 different subjects (MATH, SCI, SS, etc.) then there would be 12 different 'courses' for 604. I was able to accomplish this with a script, looping through all the class records, but this becomes problematic when certain class numbers change or subject codes are added or deleted. I don't care if the 'Course' field is in an existing table or…

Hello. I have a table with 56 fields and 8 records (with data entered for some, but not all, fields for each record). I would like to constrain some of the fields to always include a fixed value. I tried using "auto enter data" and specifying a value (say '100'), both with and without "global storage" on. Why don't my existing records automatically update to show this value in the appropriate field for every record? I tried asking for validation (always) and specifying validation by calculation (e.g., [field] = 100. But my records still don't update to show this value. When I add a new record, it does automatically show the specified values in the appropriate fields…

I am working on a DB that captures the details of each sales rep

I have a field called "topic_id"...contains information such as "8BS". I want to set up a calculation field that uses information within the text string to calculate data. eg if the text string contains "8" then "Year 8" is generated. in a separate field...if the text string contains "8" then "Stage 4" is generated. I can't identify a text function that does this...is there one or do I need to make up a script? TIA Stephen K

I have two records... On the first I have several fields with lists if attributes in each by category such as Computer skills, Communication, etc. I want to be able to take these and paste them to another record under headings like Quality of work, Quantity of work, etc. So in the record I created I go through the list, select one, then click on a button next to it that relates to the field I want it pasted to on the second record Through a script it copies the field, opens the second record and pastes to the field I selected. But I have run into a problem. If I want to add to that field with more from other lists, it erases the first entry and pastes the …

Oy. Working on a massive project and one of the things I can't seem to figure out how to do is getting fields to work with each other. This is for a theatre (I'm not a contractor, just someone who works there). We use FMP to do our orders. The way it works now is that we've got a pop-up menu on our orders to choose a show. Then they type in the date and time of the show. What I'm trying to figure out how to do is make it so that when the choose a show from the menu, the date becomes a menu of the dates of the show. Then when they choose a date, the time becomes a menu of the times the show plays on that date. What's the trick to doing this, please? Thanks.

Hi. Sorry to perseverate on this (see "Auto-enter data" posting from yesterday). The 'Auto-enter' and 'Replace Field Contents' worked great for the fixed values. However, Re-Lookup is still not working for my case. Is it a problem that the "key field" (matchField) is a calculation, not text or a number? Just to be clear... What I want to happen is for the key field (matchField) to calculate a value from data entered Table X and for the resulting value to then be copied to the "destination field" in Table Y. At the moment, I have the destination field (in Table Y) defined as a number and set to Lookup the value from the matchField (Table X). But when I try re-l…

I have a container field which contains a reference to a file on the hard disk. I have written a simple script using a custom dialog which will allow me to rename the file on the disk. I would now like to update the container field to point to the renamed file. Is it possible to do this without going through the insert file dialog?

Hello I'm in the process of migrating from FM5.5 to FM7. I have 10,000 records are with file references to image files. Is there a way to automatically store all of the 10,000 images in the db containers, whereby replacing of the references to the files.

Hi guys, Hope your all doing good im using fm pro 7 and i need to install reports on the database. I have several table all with number and text and the usual db stuff. how do i go about doing the reports is my question. Do i define summary fields within the table itself and then calculate from there or do i define a reports table and look at the other tables and calculate therfore keeping the report central in one place. Any links, tutorials,examples or feedback i would really appriate it.

Just want to get clear that I am new to Filemaker Pro. I have developed a database similar to a CRM application, one of the problems that I am having is that I want to be notified when a lead is due for contact. I have the database setup to use the following fields: Contact Date = Last contact when lead Contact Days = Dates for leads next contact Contact Status = Due or OK If the current date is 24/01/05 and the lead was contacted on the 10/01/05 and the contact days were set to 5, the contact status was be equal to Due. Contact Status has the following calculation value, If((Get ( CurrentDate )> ld_Last Contact Date+ld_Contact Days);"Due";"OK…

Hi, this is my first post here. I tried to see if this question has been addressed before but if so I couldn't find it. Anyway, I'm trying to make the simplest flat-file general ledger but I can't figure out how to sum the accounts. The database is simple: Each record has just the date, amount, debit account, credit account, and description. So far so good. But I don't know how to sum each account. The problem is that for a given set of records for a given account, some of the amounts will be debits and some will be credits, and I don't know how to check for each one. I can't just sum the Amount field -- some of those entries need + values and some nee…

Hello, An apparent simple thing causes me some headache; I have following 3 fields: "COST", "DISCOUNT" and "DISCOUNT IN %" I want to either enter a $$ amount into field "DISCOUNT" and then get the percentage result of that $$amount related to "COST", OR enter a % amount into field "DISCOUNT IN %" and then receive the $$ amount in field "DISCOUNT". What I did: enter calc for "DISCOUNT" = ("COST" * "DISCOUNT IN %") ./.100 and enter calc for "DISCOUNT IN %" = ("DISCOUNT" ./. "COST")*100 When I do this I get the message that this would cause a circular definition after I enter the second calculation. Is there any way around this? Thanks, Andy

I want to bulk import jpeg images into a container field. I have found some posts related to this but could not figure out how to make them work in my case. I have created an AppleScript that downloads images from the web and renames them "product_ID.jpg" (where Product_ID is a field in the database). 1) I would prefer to have this AppleScript insert the image into the container at the same time it is downloading the file. Otherwise, 2) Importing the images from the folder they have been downloaded into would be fine. Or 3) If there is a way to have FileMaker download the image directly into the contianer field would be really nice. I wo…

Hi all, Hopefully you can give me a hand with this problem. I'm making a database in Developer7 that has the following tables and fields: Table #1 (SetUp) ProjectName Locations Dates Table #2 (Panelists) Name Address City State Country ZipCode Phone Email Notes OnPanels (a list of all panels that the panelist is on, based on the Events table. ) Table #3 (Events) EventName Description Location (value list from SetUp::Locations) Date (value list from SetUp::Dates) StartTime (value list) Duration (value list) Moderator (value list from Panelists::Name) Panelist1 (value list from Panelists::Name) Panelist2 (val…

I find the age of a person by using the formula (Get ( CurrentDate )-Birthdate) / 365 The result is a number. The Birthdate is a date. If I use a birthdate of 2/5/1925, I get the answer 80.019 (+more decimals) It is not February yet, so the age should not be over 80 yet. This is a strange rounding error or is the basic calculation wrong? This is with FM PRO 7

I'm trying to figure out a way of creating an auto-enter-by-calculation text field that will do the following: Auto-enter one of three different values in a field, using the following criteria: If no records in a set contain the text "Current Use", then "Current Use", will be the auto-entry. If there is already a record containing that value, then I'd like the next new record to auto enter "Transfer of Ownership" into the field unless a record in the set already has that value. And then, if there are already records in the set that contain those values but they don't contain a 3rd value "Building Permit", then "Building Permit" is the next value. Now if all 3…

I've been looking for how to do this for a while but cant seem to find the way to manage it. The problem is that I have two fields that dictate if a charge is allowed to apply and if so how much that charge will be. Field A has 3 values set by a valuelist 1.Not Allowed 2.Free 3.Allowed Field B is for entering a value for the charge. If Field A=Not Allowed or Free then the user should not be able to enter B (it should be "greyed out"). Only if Field A=Allowed should Field B be enabled for use. I am looking for a way to have Field B "greyed out" as unavailable unless the user selects "Allowed" in field A Is there a way to do this?

I have added to a list of fields to be summed and they are set to repeat 40 times. I cannot get the subsequent repeaters to calculate. The sum calculation includes the base field and the option to repeat is also selected. Does anyone have an idea the sum function isn't working? Thanks, Lisa

I have a calculated field that takes two text fields and puts them together to show up as one field on a report. The problem is that it removes any text formatting (italics, underlining) that is in the original fields before the calculation. I need the calculated result to have the same text format as the original fields. Does anyone know if this can be done?

I have two tables: parent and child. Parent fields include Price ExchangeRate Child fields include Quantity ChildExchangeRate ExchangeRateUsed (conditional: Parent::ExchangeRate unless ChildExchangeRate contains value) Cost (Price * Quantity) USCost (Price * Quantity * ExchangeRateUsed) This arrangement is needed as quotes are often spread out in time. Most of the items are culculated using the Parent ExchangeRate but the ones done later may require a different rate. Global fields are out as I need the Parent::ExchangeRate to stick whle the file is hosted. This all works well at the Child record level, until I create a Summary field …

I've searched the help section of FMP 7 and this fantastic board to see if there is a way to add a time stamp to a checkbox. I would like it to follow the checkboxes caption, and be automaticly added at the time that the box is selected. Looking something like this x Class number January 21, 2005 I guess that is a date stamp. Can this happen, and if so how would I do such a thing. What about if I wanted to have an edit box inbetween. Sometimes the option is an elective, and it would be nice to have the selection written in. How do I do that? Just put an edit box next to the checkbox? Man am I a newbie...

I already have the calculation for age but I want the calculation to appear in months instead of years so that I can figure out Vacation Time. Example: Current Date = field 1 Date of Hire = field 2 Total Months = field 3 (Calculation that I can't figure out) Vacation = field 4 (calculation = vacation *.875) in months Thanks in advance for all your help