Calculation Engine (Define Fields)

I am trying to understand whether to use the filter function in a calculation. Here's the scenario: I have one table called AllModules. This field contains four text fields: ModuleName, ModuleType, ModuleBody and ModuleID. The latter is concatenated from ModuleType and Module Name (ie, Module Name might be "Weekly" and ModuleType might be "Cleaning", so ModuleID would be "CleaningWeekly"). ModuleBody contains text that describes the ModuleName (ie, "This is a weekly cleaning module . . . ") One a separate related table (related via ModuleID) I have a text field called CheckboxField that is set up as a checkbox. This field automatically reflects the value list of…

How can I write a script that when a user tabs or clicks in a field, it selects the entire content of that field? Is it possible to make FMPro 7 run a script when a user clicks into a field?

Hello, I have a field called "contact id#" that is the link between two related tables I have. How do I make this field unique so that it is impossible to imput a contact id # in one record that is already being used in another? TIA!

I have a report that is run on a database called "events" which has a relationship with another database called "acts" via the actID. In the events database I am running a report to show total income for events by Act and one of the fields shown for each returned act is Target Gigs which is stored on the Act record in the Act DB. It is showing fine in the main part of the report but I have a summary at the bottom that I want to display the totals for the returned records and it is calculating fine for every column except Target Gigs which is showing the total of all target gigs for all acts, not just those returned by the find request.

I thought I had a good start on this then my brain fizzled out. What I want to do is have a user, in a runtime solution, enter a password so that other users can't accidentally delete records; the password would be required before each record is deleted. (Yeah, I know I could make it a one-shot deal through an account privlege set-up, but trust me...the users need this kind of set-up.) So, the problems I'd like to solve are... 1) How can the primary user enter a password (and be able to change it later, if he or she wanted to) without having to "hard code" it into a script...which a runtime user can't do. 2) I tried to enlarge the text in the user-defi…

I'm trying to use FMP to track class/student attendance. I've got my classes and students setup and what I'd like to do is be able to enter in who attendend what class and then run a report saying average attendance is...I'd also like to run a simiilar report sayind "john smith attendended an average of ..." make sense? Anyone know how to do this? I'm trying to use a check box for a simple check meaning "yes" and unchecked for "no" on attendance. Thanks for all the help!

I'm trying to get a weekly report with the following things: Artist's name (We have a few) Thier totals for the last week (How many images they got done and put into Production) Everything I've tried I can't seem to get working. I don't get proper totals. Please I'm begging help!

Hi, I have a huge and complicated problem. I'm new to FMPro8, I'm working for a new company that created there DB in 1994 by the boss who is not a computer professionnal. They've been adding fields and tables since then... not normalized!! :s So think about that 12 years of development without normalization. My task is to create a new DB in parallele, but I also have to patch the original DB. The problem is that I have a 1800+ fields in a single table. When refreshing data, the speed for refreshing textual data is Ok, but when there's some picture that they fetch on a NetDrive, it is way too slow (I'm talking about 5+ minutes to refresh a single layout). …

The subject sais it all... How do I do this please? I'm sure it has been answered before but I cannot find it... Thanks, Lukas

Hello guru's! I am trying to find a way to display the field names from a table similar to the "LayoutNames ( Get ( FileName ) )" Function. I have looked everywhere and cannot find it!

I'm trying to connect to FM via ODBC. This normally works great, but I've run into an issue where one of the fields I need returned is a calculated field. As such, it cannot be indexed, and that calculation causes a very slow response when working with this particular data selection. Qty_Available is the field I need returned. It calculates the value based on Qty_Received - Qty_Sold. If create a Qty_Available2 field that is not a calculation field is there a way to have it automatically always have the value that Qty_Available has? This way I could use the second field in my SQL and since it's not a calculation field it will hopefully be fast. I need it to …

Hey all, Have patience, I am teaching myself filemaker. Ok, at this point I have a Customers table and a Contacts table. They are related via CustomerID. There can be many contacts for one customer. I have a field in the Contacts table called "Same Address". If the value of this field is yes, I want "address, city, province, postal code etc..." to be copied from the Customers table into this Contacts record. Any help is appreciated. Thanks! p.s. have tried to make Contacts::Address a calculated field using: If(Contacts::Same Address="yes";Contacts::Address=Customers::Address;"") - but it doesn't seem to work - if it says yes, there address …

i am using a calculation to set a field with text. i use the match of this text to another relational database (this is all in fm pro 6, unfortunately) to create a relational value list. up until now, the relation has been based on text. now i need it to calculate a text field as well as if it is after a certain date. and i am not getting the right results. here it is: If(Left(Customer ID, 5) = "Enron","Enron", If(Customer ID = "TS&S Employee","Employee", If(Customer ID = "TS&S General","General", If(Customer ID = "Tower Automotive","Tower", If(Customer ID = "Saint Vincents","St. Vincents", If(Customer ID = "Delphi Corporation" and Slip Da…

1) I currently upgraded from FM 5 to 8. Previously I scanned documents and stored the document file in a container as address to a "scan server" (actualy a old G3) Now with FM8 files able to store a terabyte of info, I can store the scanned documents inside the container field as a file rather than an address. The question is: will a file of 40-100 gigabytes or so cause the solution or the FM file itself to run noticably slower on the network then if these documents were stored as addresses? Also, any other issues I should worry about with saving (thousands of pages) as a file directly into the container field in FM8? 2) If the answer to the above is "save as ad…

Hi, I've been maintaining a database that had a repeating global container field with 5 repetitions. I recently added a sixth, and when I paste the correct image into the sixth repetition, it is no longer there the next time I launch FM. I tried both inserting and pasting with no luck, in addition to trying multiple image formats. I've also made sure that it doesn't store a reference to the file. It's a very small image simply comprised of a solid color. Have any suggestions as to why the container won't retain the image? Thanks!

Hi, I want to be able to put the recordid of the displayed record (in form view) in a global field automatically without script. Doing Get(RecorID) in a global calculation returns the last record id of the whole database. I tried a self relationship based on record id in a global calc, without much success either. I've thought of FM 8.5's get object layout, but my solution has to work on 8. Any help ?

Two problems I would really appreciate help with: I have lots of date fields, some are before today, some after. I want to have a field that will calculate and display the next date after today, and another field that will calculate and display the last date in the list prior to today. The two closest dates to today's date in two separate fields. A second problem is that I have two start dates for a project. I have a calculation that looks at these dates and works out a Due Date 90 days ahead for each of them. I only display the later date. The problem is that if those start dates have not been entered (the fields are empty) the calculation is still done and the …

This should be easy for someone. I have a checkbox field with 9 options run off a custom value list. I am running a report of how many times each option is checked throughout the entire db. There might be an easier way, but here is what I have. I have a calculation field for each option of the check box field. So I have 9 calculation fields. Each field will calculate a "1" if the option is checked. For example: If(T_strategies= "Presentation";"1";"") The problem is that if I have more than 1 tiem checked, the value of T_strategies is something else like: "Email Presentation" instead of just Presentation. How do I tell the calculation that if T-strategies h…

Does anyone know of an option or script setting that will automatically use a field's data as the document name for the PDF when using "Save Record as PDF"? Seems like it should be a natural feature but I must be overlooking it. Any help is greatly appreciated. Thanks.

Well this is probably simple and I am overlooking how to do it so I hope someone can please assist me. I have a studentid field that has a number in it. The leading zero is missing on all the numbers in this field because the excel file was formatted incorrectly and it lost the leading zero for every student id. What I need to do is insert a 0 (zero) in front of each number in the field. I can't figure it out all I manage to do is replace it. :-( Any help would be greatly appreciated.

I have created a main customer database with cust number, and I have also created a purchase order database to be able to track purchase orders for each client. I have setup a relation with the purchase order database, and have used a portal within the customer database to display/add/modify the data from the purchase order database. Here's the problem. on each purchase order I have a place for unit cost, then the tax on unit cost in another field. I also have a field right before unit cost that says TAXED? and options on 0 or the current tax rate. if left to 0 the tax isnt displayed in the unit tax field, but if current tax rate is selected it will show tax o…

Hi. I have a layout that has a portal for comments. I set a validation on the comments so that only records that were created by the logged in user can be edited or deleted [Get (AccountName) = REC_CREATE_ID] where REC_CREATE_ID is Auto-enter account name. This works but there is a problem. If the user edits any of the information on the main layout then tries to edit a record in a portal that they did not create, they are presented with an error message and option to Revert Record. If they revert, all the changes to the main layout are reverted as well. Is there a way so that ONLY the changes in the portal are reverted, and the changes to the main layout are no…

hi — sorry i know this may seem like a dumb question, but i am very new to filemaker and need some assistance. i have a database with over 400 records. in each record there is a 'word count' field in which a number is entered, such as "250" or "500" or "1500" depending on the number of words in a relevant item. i wish to create a field that appears in the header and which will give me a total number of words across the total records: ie a total word count for the project. i've tried some formats and simple equations but can't seem to get an accurate result. can anyone please let me know an easy way to create and format a field and an equation to get t…

I need to limit the number of characters that can be entered in some of my text fields in a table (ex: ClientCode: 10 char, ClientName: 50 char, ZipCode: 6 characters, etc). I just don't seem to find the place where I can do this in FM. Coming from a MS Access/classic DB development environment, I find it really strange that nowhere you define the length of your text fields when setting up a table in FM. Or am I not looking properly ? Thanks

Hi when do stored calculations recalculate? Can you force it with a script step? How about global calculations. How do they work and recalcuate?

How can I set up a field size to its content. I have a text field containing as for length very different texts. When creating a report in preview mode I would need the field to be changeble and be able to fit to content. I tried to make the field as big as largest recort and use "slide" options but this makes empty pages at the end in preview mode as my fields goes across to many page breaks in browse mode

How do you get a list of values in one field. I know can use the List function. But list function list out all in that field. Let say i got a table with 2 fields. Product ID and Serial Number. Taking note that the product id is not unique but the serial number is. I want to create another field which can list all the serial numbers from the particular product id in another table.

Hello Everyone, Im so very lost. I read the books, I've asked FileMaker but I can not figure this out. I created a database for our writers in our publication. I have to list the following for each writer: Article Name |_______________| Issue Contributed |_______________| Payment Amount |_______________| Note: Issue Contributed is a drop down menu A writer may have written in 1 , 2, 6 , etc issues. Here are the questions, 1. How can I add another section in each writers account when needed to add the above information? 2. How c…

I know I'm doing something wrong. I want a repeating calc field (30 repetitions) to calculate dates 30 days beyond the selected date. SelectedDate = date field where you select the date calcDates[30] = repetition1 = SelectedDate + 1, repetition2 = SelectedDate + 2, etc I originally had 30 fields calculating the previous field + 1 but that was cumbersome! There's got to be an easier way. I've tried a number of things: Let( [ repetition=Get(ActiveRepetititonNumber); lastrepetition=repetition-1]; If( lastrepetition=0; SelectedDate; SelectedDate + lastrepetition ) ) -----something to that effect; anyhow, it didn't work The most obvious: SelectedDa…

I read in one of FM books that FM can be setup to prevent the creation of a new db by the user. I went through FM Options, Preferences, etc.. and could not find an option to disable “New Database…” under File in the menu. Thanks for any suggestion on how to configure FM to only open files and run DBs and prevent users from creating new databases.

I'm looking for a calculation that will take the "fieldname" and it's "value" and put it together. For instance. I have the following: FIELD NAMES: filmtitle runtime rating THEIR VALUES: Great New Wonderful 25 minutes Rated R I wish for them to appear in a SINGLE (text) calculation field like this: CALCFIELD(result is text)= `filmtitle` = "Great New Wonderful", `runtime` = "25 minutes, `rating` = "Rated R" --------- You can see where I'm going with this... I've looked in the function "Fieldnames" and it does return the names of the fields, but I can't seem to figure out how to return the value along with the fieldnam…

I want to create a logic field which should be easy enough. But I need it to check if a folder exists. : eg [color:green]Field Name DoesFolderExist Y/N [color:green]If folder chuck exists set {DoesFolderExist} field to Yes else No Any help on this one would be very helpful. Not sure how to check for a folder. A calculation is probably the starting place. :qwery:

I have an object I've named RXREQ, it is a grouped object comprised of a pink rectangle, a dozen fields and some text. If I copy it in layout mode, go to browse mode, click into a container field (RxContainer)and hit paste, I get a nice image in my container field. Which is exactly what I want. Well not quite, I just looked, I get an image from Layout Mode - no data, just the image you see in Layout Mode. What I want is the object as seen in Browse mode But try to automate it and I get garbage, and odd garbage at that, text from all over the page.

Hi everyone, I am a beginner to Filemaker. I am creating a database for writers that contribute to our magazine. For example we currently have published 8 issues. And a writer may have contributed to 1, 3 or all 8. For each Issue I need to include the following info: 1. Issue Number 2. Article Name 3. Payment Amount How can I have multiple listings for each writer in the database? So that its list all of his/her informationlisted above for every issue they contribute to on their page. And after I have created the listings. How can I search for example for all writers who may have written in Issue 1, 2, 8, solely, etc. I really appr…

This Auto-Enter Calcluation does not seem to work. Result = Case(height<.75;"Restrict"; height>1.25;"Restrict";width>3;"Restrict";" ") Fields = Height Width Result This does work: Result = Case(height<.75;"Restrict";width>3;"Restrict";" ") But I need the full calculation to restrict if the first measurement is shorter than .75 and taller than 1.25. Any help would be greatly appreciated. thanks, Steve