Calculation Engine (Define Fields)

Hello i'm sorry if this is in wrong topic, but i don't know how classify it. So... i have got a problem. I have got database with dates.. fields: week ID(autoenter) start date(date) end date (start date +6) payment date (start date - 1) and i want to get current date and find in which week id current date is and display it in 1 field (and autochange it every time when for example current date passed end date then change week id +1

I am trying to put lnks to various documents into container fields in a database. (with links instead of storing actual documents, I can then click to open the documents in whichever software they were created in - all of mine are either Excel or Word.). As long as I don't shut down FileMaker (8.5 Advanced), everythng works fine. [color:red]If I close out the file and come back later, the links are [color:red]GONE!!..... [color:red]the icons have literally disappeared!! . HELP!!!

Is there a way that I can set up a time field so that if I enter a time of 930 that FMP will automatically format it to 09:30. or 1337 would auto format to 13:37, etc, etc. I can easily do this in (dare I say it) Access using input masks (as I can with phone numbers...but I digress) but I have not found a way to automate this annoying little data entry task in FMP. Thanks Steve

I would like to place a checkbox field that, when selected, would prevent the current record from printing when printing in the "Records Being Browsed" mode. Thanks for any help.l

How do I take a number field and make it add three other fields and ALWAYS be three a three digit number. For example: if the field adds 10, 15, 15, the answer in the field would be "040" or if I add 2, 2, 3, the field would contain "007" Thanks for your help Lester

Hi everyone. I want to create a database that contains suppliers' name and location. After I choose desired supplier I want to see its inventory information such as product name, product code, price, discount rate etc. I want to create it similar to link list. If you are of assistance to me, I' ll be glad...

I have a check box value list of whether a record is a bar or restaurant. Each bar or restaurant runs in one or many issues of the magazine. I would like to take a tally of which issues a bar or restaurant has run. The issue number changes every Thursday. So, 01/04/2007 the issue number will be 96 and Joe's Restaurant will be listed in that issue and in issues 97 and 99 but not 98. Not logical, but an example because some restaurants get relisted months down the line. I'm trying to think this through, but because I'm a beginning programmer, I just can't get my head around it. Can someone help me see this through? I've looked at the following post which comes clo…

Hi All. Have a little problem and would love some help. I have a FM6 database that contains a field holding a number. Several records can have the same number in the field. After doing a search on some other fields I might end up with 10-50 records found. What I would like to do is to get the numbers. But only one even if it is found in more than one record. The numbers I would like to make into a valuelist (that changes after a new search). Any help would be great The Dog

I have some calculation fields that depend on data entered in other fields to calculate and display the result as a number. I want the user to be able to override that data, or to be able to insert a value into that field if the calculation has not been made (field is empty). I have tried mightily to achieve that aim but failed. I am using FM8 Advanced. Help please!!

I have a simple text field calculation: "myPCDocumentsPhotographs"& fieldname For some reason FMPro will not accept it and says "This text constant does not end in a quotation mark". If I remove the "" after the word "Photographs" then it accepts it but reduces the initial "" to just "". Can anyone explain this for me please?

I'm trying to create a report that will display a group of monthly transactions, a subtotal by month (summary field), and an average of the monthly subtotals. I can easily get the monthly subtotals by creating a summary, but as most of you know, you cannot create a summary field based on another summary field. Using the Average function on the monthly subtotal field doesn't work; and I've tried the GetSummary function with no luck. I know I can create a new table and set up a calculation to display the monthly average there, but I'd like to show the transactions, subtotals and average in the same table. Any ideas?

Hi, In a portal I have a numeric field where the user inserts a value ("Price per piece"), usually something like 1,30. In the Invoice it will turn out as 13,00 (not what I want!). If the value is inserted as 1.3 it turns out the way I want it to in the Invoice, ie 1,30. Obviously I want the user to be able to insert the value with a comma and not a dot. Any help/suggestions are appreciated Anders

Is there a way to make a radio button set behave like a checkbox (accept more than one item from the value list) by default, rather than the user having to remember to hold the shift key down? Context: If the user forgets to hold the shift key, or misses it, all existing options are replaced by the selection - oops - info lost! Just use a checkbox set then I hear you say.....but.. I want the visual style of the radio buttons because some users get confused by the meaning of the cross in the checkbox (Am I saying yes to this option, if so why am I using a cross?) The only solution I can think of is to set up container fields with graphics looking like t…

Hello, We have a mailing database, and we have it set up so we enter in the main person's first name in the first name field, and their last in the last name field. If they have a partner or spouse, then we enter the partner's full name in the field "partner" What I want to do is set up a calculation field called "Label Name." So far I have First Name & " " & Last Name & " " & Partner Name. But what I want to do is set up a calculation that checks to see if there is a partner name, and if there is a partner name, include "and Parner Name." Otherwise what is happening is that my calculation is getting a result like "John Doe Jane" (Instead …

I want to use a summary field to display a running total in a report. As I add a record on the report the summary field goes blank and does not display the new total until I click on or script into that field. How do I make the field redisplay the new value without forcing the user to take some kind of action? Is this an unfortunate side effect of using a report type layout for data entry (I don't believe this is the case as I've just tested this in different layouts and it never seems to update the display properly)?

I have an invoicing/lineitems/inventory database. I want to track sales of new inventory, as well as sales of slightly damaged inventory of the same items. My thought is to have 2 fields in the line items table - QtySoldNew and QtySoldScuff. I want these fields to be mutually exclusive, that is, only one can have a quantity, not both. It seems like I need to have a validation by calculation that involves isEmpty or not isEmplty, but I am not sure what the calc would be. The idea is to enter the item #, then enter either a quantity under new or scuff, depending on which inventory it would come out of. Then I could set up 2 inventory calc fields in the inventory t…

printing a single field to Dymo script I have wasted loads of blank labels trying to figure out how to do this. All I want to do is select a field and have it print to the dyno printer. Any ideas ? JOnathan

I checked the 'unique value' under validation tab to prevent user from recreating duplicates, but i believe the error buttons (Revert, Yes, No) that appear when validationg fails are very unuser-friendly. Some of the users are limited to be unable to delete or edit records, only add. I can education them, but accord to murphy's law; "Whatever can go wrong, will go wrong" Thus is there any calc that can be use to mimic this function?

I am new to Filemaker and need some assistance. This is what I would like to have in my database. I sell classified ads and the minium word count is 20 for $30. I would like to be able to automatically calculate what it would be if someone had an ad that was 25 words. Help me out with what I have done or with something simplier...THANKS! I have created a field where I input the word count and then another field that lists the words over 20, then another field that will multiple the words over 20 by $1.50 and then add it to the $30 giving a total for the ad. However, some of the ads are less than 20 words and it creates a negative number. Anyway I can f…

I have a notes field that is a simple text field. I have created a script to add a new note with date, time, and user name. Now the users of this database have asked if the entries can be placed at the top of the notes so the notes will always be sorted from most recent to oldest. Is this possible? If so, what would I need to add to my script?

Hi Forum - I am using Filemaker 7 client and need the following calc - The Lowest Common Denominator (actually what I think I need is greatest common factor) over 5 columns. Not sure if I would actally need more than one field because it would run something like this - LCD(field1, field2, field3, field4, field5) Any suggestions ? Many thanks in advance Glorifindal

Hello All I Have a Problem. That is Let Suppose I make a Table Student And Its Fields Are: Name City Now I am Entering Records Like First Record Mr A XYZ Second Record Mr B XYZA Third Record Mr C NMJH The Problem is I want to check On Every New Entry Is This Name Already Exists or Not If The Name Already Exists then Messege Comes Sorry The Record is Already Exists So it cant b Saved And If its New Entry then Save That Entry. Like If i again enter Name MR A then msg comes Sorry Its already exists So its cant be save. Try with new name. I am verythankfull to u Waiting ur replies Umar Farooq

I'm guessing these two don't work together. The attachment is a screenshot of my relationship graph and field definition. I have no issues with getting the correct data from the L_placement_episode_pt_current TO, but the data I get from the L_placement_episode_pt_current_pv TO is random and not what I was looking for. A workaround is that I can have a CALC field in the the L_placement_episode_pt_current TO looking to the other TO, but that seems too FM6 for me. I'm using getnthrecord because the the L_placement_episode_pt_current TO is sorted and I want the second record in the found set. Any suggestions?

Hello, I am building up database, which is based on list of employees. In every record (person), there are few (20?) of fiels with text and one container with photo. When i would like to add the photo (working on Macbook with iSight), I open up Photobooth, make photo, save the file to desktop, open it with Preview, crop it, and Copy and Paste to database. (i didn't find something else how I can grab picture directly to database with crop ability). But: now I have 60 records (60 persons, 60 photos) in database. And the size of database is abou 30MB !!!! Picture on desktop (before I crop it and copy/paste it) has for ex. 84KB. When I drag and drop picture…

I have a transportations system that is broken in two parts. One picks up every Mon, Wed, and Fri, and the Other picks up every Tues, Thur, Sun Using today's date how can I define a field to tell me what day something will be picked up?

I've never used the Auto Enter option "Value from last visited record" and am wondering what use other developers have for it. Anyone use this? G

Ok, so I am trying to make some changes to a database I made years and years ago when I was inexperienced. Now what I did was use the following calc (that I got from someone on here) to create unique IDs: Right( "000000" & Status(CurrentRecordID), 6 ) & "-" & Right( "000000" & Status(CurrentTime), 6 ) & "-" & Right( "000000" & Status(CurrentDate), 6 ) The problem is that instead of doing it in a text field and making it an Auto Enter Calculation, I actually put it in a Calculation field, which has worked up until now. The people that use the database have requested a function to duplicate records, so I started working on creating…

Hello, I am trying to figure out how to total the numbers that show up in a portal. I have a file with land owner names and acreage they own and the location of their property. One landowner can own multiple properties and each property listing is a separate record. I have set up a portal that shows me each record with the acreage listed in each record, i.e. 1, 2.5, 3. Each acreage listed is a separate line in the portal. I would like to have a field in the portal that would list the total amount of acreage for each landowner. Is this possible? Thanks, MT

Here's my situation: I've posted this on another forum and got zero valuable help. I hope to have better luck here... For purposes of Quarterly financial analysis I have several reports that summarize different fields in various ways. One of these is number of accounts. My database consists of profit records for each client for each month of the year going back a few years. One report I'm struggling with is to show how many Unique customers we have in each state for a given fiscal quarter. Since there is a record for each customer for each month, I want to count a customer if they have a record for any of the 3 months in a quarter, but don't want to count…

Ok. Tough question time. This is one for the gurus, because I've got at least two massively different ways to do this and I wanted opinions about how to do this in the Seperation Model because the display will change per user, but the data will be edited and remain the same independent of user. Make sense? Problem: Display (VISUALLY) in a 'calendar' the attendance of individual students. Possible 365 days per year, Different Hours attended possible, 1000+ students. Use the Seperation Model to provide for differing display options. Probable (or existing) solution components: Customer DB Attended DB (key:Customer - 1 per date) ?? DatesAvailable DB …

We currently have a database with thousands of records, each one with a container field containing a reference to a file on our OS X Panther Server. We'd like to be able to upgrade the server at some point and possibly change its name and IP address. Is there a way to run a calculation on every record to update the referenced file path to reflect the files' new location on the new server? We're an all-Mac shop and we're open to using plug-ins if that will make the job any easier.

Hi guys (and gals?), I've got a database with container images, being accessed via a file reference. I was wondering if any of you knew a way that I could view the current file path... How do I actually view what that file reference is? I've tried displaying the field with text using the <> string on the layout, but that didn't work. Any ideas? Thanks, Chris

I want big to do field text and I want to use between the line The example:I am writing Field =(Filemaker Pro) Upper ( Adı Soyadı ) & TrimAll ( Adı Soyadı ;1 ; 1) The result= (FİLEMAKER PROfilemaker pro) How do I do Text Functions??

Hi all, How can I get the number like this: My number field 10,[color:red]567.89 Now I need to get the number [color:red]5, can this be done? I was using Left function but can't do it. Any Idea? Thank for reply!

I am importing data from a payment center (checks, not our credit cards which works perfectly). The csv format provides a header row record which has information I need to capture (there are no field labels). I will import all lines as records, write the header (first record) to variables then delete the first record. So far so good. But I have two problems: 1) No year: The remaining rows are PAYMENTS and I must be sure this doesn't break (this date is used for Aging and assessing Late Fees). Payment lines have the date as: 18-OCT 6-NOV I decided to convert this garbage to standard date and I figured I could just use the ProcessDate's year (it o…