Calculation Engine (Define Fields)

The topic of this post sounds a bit unlogical... I know... ;-( Here is the case. I need to change content in a field without using scripts. Text Field A autoenters the first word from Text Filed B when a new record is created. After this i want to change the content in Text Filed B so everything remains except the first word (the word that now also is in Text Field A). Well... this is a circular definition! I get it to work all right with scripted buttons but in my sollution buttons is no option. If I could get a script run everytime a new record is created my problem would be solved... but that is impossible... isn´t it...? -So the only option is to make Calculation Fiel…

I found this TrimN Function at www.briandunning.com. How can i edit this function so that. Text="s1234567¶s556677¶s889911" Input Data TrimN(text,"S") Output Data 1234567 556677 889911

I have a number of records and I want the sum of them to be "100" (ie percent). If not, the user shall be prompted. So, I built a selfjoin based on a Key field and built a validation like this: sum(selfjoin) ≠ 100 But, I cannot in my life get this thing to work. I have used if, case, and other things to get it to work, but it won't. How should a proper validation on a selfjoin be built?

I just recreate my time card from a FMP template with all the repeating field, into a separate record, since I'll be using an automatic data entry. Now lies my problem, its simple. I'm generating a monthly report for each employee, and each total hours they've been working. so I relate the employee table and time card table to create the report. How do I summarize total working hours for each employee, monthly in the report? I tried a summarize field in timecard table with no success. should I create a summarize field in the employee table? but how about the monthly part? Help Thanks for all the inputs

I have a field that uses a value list in my database. I would like to have that field "require" a selection during data entry. I want my data entry person to not leave that field blank before moving on to the next entry. Is there a way to require a field have an entry before the record is saved? HawkLA

I am trying produce invoices. I have looked st the Productivity Pack invoice but csnnot mske sense of the script. there is s step in it that says 'If [not(fnIsWebConnection)]' that i cannot find any reference to. In Access i would just make a filter Query. Please help. Love the program but must be too old to learn new.

Does anyone know a way to sort a report by summary fields? I have a energy efficiency report that lists houses with sum-of-gals fuel consumed and sum-of-gals per sqft. It would be helpful if the report would list the buildings with smallest gals-per-sqft first but FM8 does not allow sort on summary-fields. Fields are: house_name, delivery_date, gals_of_fuel, calc-field: gals_sqft=sqft/gals_of_fuel sum-field: sum of gals_sqft The sqft comes from a related locations-file that has various house details such as total sqft of the building. Thanks, Jos.

Hello, I'm wondering if it's possible to do calculations by dates. I'm looking at doing a budget database and I would need calculations to be done by the month. My current structure is 1 table, "Budget Allowances" that has the amount of money that can be spent in various areas, food, gas, rent, entertainment ... I have a second table, "Expenses." On this table you enter all expenses and select what type of expense it is (from a value list of the areas) What I am looking to do is have a summary page where it takes an amount from "Budget Allowances" and substracts amounts from "Expenses" labeled for that particular area. Ex: Budget Allowances::Enterta…

I have a portal with a series of records - each is a company with an amount paid. Some records duplicate the company but with a different amounts. I'd like to get a total for each company. I've made a relationship between the companies and tried the Sum(field) function but without success. eg field1= company field2 = amount field3=Sum(table1amount:amount) relationship field1(Table1amount)<---->field1(table1)<-----> (other table and field) I know I can do this with subsummaries but would like the result to be dynamic. Thanks for any help

Hi everyone, I'm trying to understand lookupnext function and just can't fugure it out... My database contains 2 tables. One is a list of tasks with each task having an id number. The other table is named task, where I have 2 fields; the first being an id number field and the second the "supposed" lookupnext value field calculation. My goal: I would like when I enter a task number to see in the other field what will be the next task. ex: table1 1 = wake-up 2 = breakfast 3 = work etc... table2 when I enter the number 2, i would like to get the description "work". 1 = breakfast 2 = work Can anyone help me. I have a…

Hi everyone, I know that I've seen this here in the forums, but for the life of me I can't find it again... I have two databases and I want to add the functionalities that I've developed in one to the other. So I want to duplicate the layout and the field definitions that go with it. As there are a lot of calculations involved in the table that I wish to export, I don't want to have to re-type the defs and risk making a typo mistake, thereby blowing the functionality of the calcululations. So, how do I "export" the field definitions from one database and "import" them into another? Thank you! Mac Hammer

I have a database of customers and prospects. If they reply to an ad they will get entered to win something. How do I track this with the intent to pick a random winner, and how do I pick the winner at random? Thanks in advance for any help. Sorry were still on 5.0 v3

I'm very new to databse design and I need some help with a calculation that i'm working on i have 4 tables. customer, product, line item, and category The line item table is connected to the product, customer tables and the product table is connected to the category table and contains the pricing information i can get the sum of all the purchases made by a single customer but i am not sure how to get the sum of the purchases in a single category for each customer. any help on this is greatly appreciated thanks

All, I hope this is in the right forum. I've found topics in this forum that were similar, but not close enough to give me my answer. I have created a value list that displays as checkboxes. (Is my terminology correct?) The value list contains the different categories I want to group my records by. For this purpose let's say that there are 4 values in the list -- male, female, married and unmarried. If the record was mine I would check off male and married. (The fact that my example values can be mutually exclusive is simply a coincedence and not a part of my problem.) I want to be able to create layouts that show all the records that have one of thos…

Hello, I have - a series of join files for interrelated databases (using FM 5.5). Here's the situation. One of the fields is an 'average' which averages all the occurences that meet a certain criteria (specifically, the person's name and the game name). Consequently, all the occurences for that criteria have the same data in that field. For example, if we were playing Monopoly, and we were checking the % of time Bob won the game, and he played 4 games and won one, then, each of the 4 instances in the join file that show Bob PLAYING Monopoly, would show Bob's win percentage as 25%. OK - now, let's say Bob plays again, and loses. His n…

Can someone give me a rundown on merge fields? I've just discovered them and aside from putting them on printing layouts and avoiding extensive text calculations I'm wondering how else they are used. Are they acceptable for ANY field that doesn't require entry? Are they 'faster' than standard calculation fields? (I use a database that's hosted over the Internet and a couple layouts are calculation heavy and take awhile to load). What do YOU use them for? Thanks in advance, G

I have built an app for my client with several layouts/forms. I'm introducing FM to a large firm. I have to make this app sizzle. There are many doubters of FM that I have to convert. Guess what, they love MS tools; nothing else exists for them. The app will run on Win XP and eventually will be multi-user and web. For now, one desktop. Now I need to do some reports. The main report has to make calculations based on the selections made in the input forms, almost exclusively via many radio buttons for various aspects. In general the app allows someone to observe and assess and then record their findings during & after their inspection. I am trying to…

I have date fields where I applied custom formatting for the date to display as follows Fri, 11 Nov 10 2006 But whenever I reference it in a text field it displays as 11/10/2006. How do I make it display Fri, 11 Nov 10 2006 in the text field it is referenced? Thanks in advance :P

hello! this is my first post EVER! so please be kind. ive searched everywhere on the site to try to find an answer but nothing... so here is my setup: i am building a school scheduler where the user can see assigned "rooms", "periods", and "class". these 3 fields are on a table called "scheduler". And each of the fields are foreign and grabbed from their respected tables. what i need is validation calculation for each field (rooms, periods, class) that examines that no record creates duplicates. the tricky part is this: - a "rooms" can have the multiple "class" but not the same "period". - and vice versa, a "class" can have multiple "room…

hello! i need for the data entry people to add aditional fields on demand.. can this be done? thanks in advance

I need to generate unique serial numbers in a limited range (lets say 100 -999). Since the range is limited it would be important to be able to reuse deleted serial numbers. Let´s say record 1 in a database gets sn. 100, record 2 gets sn. 101 etc. If I delete record 1, sn. 100 ought to be free to use... if I only could get a script to apply this to the next new record. Greatful for help }:|-) PS. I´m using FM 6.

Not don't you all laugh ... but I would like to view our sales trends back through the past five years with the phases of the moon. I won't go into why - some of you understand while others think I'm nuts. But to most, it comes as no surprise - my being nuts, I mean. Is there a database (with dates and percentages) or is there formulae? I suppose it would need to be based on __% of Full Moon. How would I approach such a task? UPDATE: I did find this site which might give me the data I need. I believe I would need to base it on the Customer's location (we sell around the world) thus results would be based upon their location influence (more than ours). …

Hi I am having trouble displaying a currency value on a report when inserting the result field as a merge field, Relationships are OK! In Projects Table, Quote Amount Field is displayed e.g. £3000.00 In Merge field on quote report it displays 3000 with no £ or decimal point when it is .00 Thanks Greg

I know you can't search a container field directly.. But I have container fields which stores audit documents related to particular suppliers. these docs are Word, excel etc. Is there some way I can create a text field which automatically( by a calculation?) takes the file name of the document that has been imported into the container field? Then the text field would be searchable. How do I do this. Had a look through the other posts in the 'Containers' sub forum but couldn't see anything.

I have a field that tracks status through a calculation that that results in a number of eithe 0, 1, 2, or 3. I need to have a count of the number of records that have a status of 2. This data will be displayed in a custom dialog. Any ideas? Thanks!

Hi! I'm new to Filemaker and I ran into some problems already... The thing is I'm making a contact list with some journalists info, but I need to separate them into groups (like fashion, music, cinema, etc). So far so good. The problem is that some journalists must belong to more than one group. I need to display this group information and add the ability for the user to add other groups as well. This grouping information must be availabe in find mode too! But my biggest problem is that I don't know where to begin... Any ideas? Thanks

I'd like the data entered in 1 field to cause options in other fields to automatically be selected. Can anybody explain and/or point me to a reference that explains how to do this? thanks!

I'm extremly new at filemaker I know pretty much nothing. I'm not asking anyone to do my work for me but I can't seem to find a starting point or a good enough resource to make this not consume all my time. My Vision: I'd like to be able to have the user login select what the documents type/title is, click a browse button select the file, hit ok. And click another button that imports the file renames it according to the records serial/document type selected and then mv's it to a folder automatically created from the serial/record name and organizes it based on the document/type selected, and lists it under the document type in the record that you can expand and vi…

I need a formula that combines two 'Text Format Functions' in one simple formula. Here is a simplified example. (One Table) Three fields: Priority(text), Title Entry(text), Title Result(calculated) So what I need is: The title to turn Red & Bold when the priority is 'HOT'. A formula or custom function that will turn the text in a field both Red and Bold at the same time, if certain conditions are true in another field. I have not been able to figure it out. Seems pretty simple, so I am ready to feel foolish.

I have a file that can be modified by several different persons. I'd like to have a record of who modified a record, and the date that they made the change. Even just getting the date would help. This file frequently has field definitions added, modified or deleted so just having a "Date Modified" field won't work because it changes whenever any field is changed, added or deleted. I have a feeling that Lookup fields might be the answer, but I have never used them. Can someone give me a good idea for a solution? Thanks, John Chamberlain

I have 2 tables and a join table - very simple. I have a portal in one table with a pop up menu assigned to one of the fields in the portal. I have tried for 2 days to get the pop up to pop up to no avail. I can't get anything in the portal. It was working three days ago but not now. I have re-built the database from scratch three times and stripped it down to absolute basics...nothing. what am I doing wrong?

i would like the format of my portal to look like a list in mac os x's finder. a small icon with the file name to the right of it. is it simply impossible to format that way or am i missing something? i can get a small icon, but the text is always under the icon. thanks Limore

I will need to save general settings for my application ie: NextInvoiceNo, NextPONumber, SalesTax, etc. They would need to be accessed from many different places in the application. Should i store them in its own table (ex: settings) in one record only - use global or regular variables ? What is the recommended way of doing this ? The application will be accessed in a multi-user environment (3 PC,s - 1 Mac - No dedicated FM server). Does that have an impact if I use global variables ? Thanks

Is it possible to have a calculation return its results into different repetitions. For example: Having a calculation field with two repetitions, then have it return the "true" result of an "IF" statement in repetition [1] and "false" result in repetition [2] Thanks in advance, as I can't find any references to this. Mark

How do i change what the product code is on Invoicing Solution ? At the moment it uses its own Product ID to the products i enter to make an invoice eg, I need to change PROD000012 to say R43 I have a catlogue that need inputting into File Maker with its own codes, descriptions and prices. When i create a new product file Invoicing Solution gives it a Product ID eg, PROD000012 (I need to change this to R43) So i can search for products by the correct code.