Calculation Engine (Define Fields)

First of all thanks everyone for the help so far. This is my first stab at FM. I think it is a great program. Now for the problem. I am making an invoicing solution that is very specific to my business. Probably could have done it in M$ Access, but believe that FM gives me more options and looks like one I become a little more familiar with it, should be faster to finish with. attached is a clone of my solution. as you can see, I am having a problem with the summary's in the printed invoice. I cannot figure out how to get the previous balance, overdue balance and total balance on the printed invoice. this solution started out as the joinprint solution (th…

I bet this is a common one, but I'm a self-taught novice and new to this forum thingy. I've learned about using "show only values from 2nd field" in value lists, and placing two fields on top of one another, (one unable to be entered) in order to enter the serial/id but see the meaningful data about a record. It's great stuff but I think my data entry screen sucks for my users because I have to stand over their shoulder and say things like.. " Now hit enter" and "Now hit enter again" and "no don't type in that field with a strange number showing, click somewhere else then click on the field again to get the menu.." and "Type faster, if you stop it starts again.." (ref…

Hello Team, I have a database with a table for "absences". Each absence record has a field for the absence date, and a field that displays the week of the year that the absence is in. So a given record would have the following fields; Absence Date: 10/13/2006 Week Of Year: 41 Of course there are hundreds of absence records, and they will be from various dates and weeks of the year. I need a calculation that will identify the week of the year that has the most absences for the found set of records. I'm hoping for something along the lines of "the week of the 6th of November" or "the week of 11/06/2006 to 11/11/06" Something along those lines.…

Does anybody know why GetField("FieldName") returns the quoted field's value but GetField($$globalvariable) will not, even though $$globalvariable contains the exact text string "Fieldname", quotes and all?

Does anyone have any suggestions on how to solve this problem? I want to create a database to inventory liquor bottles. I want to scan the barcode on the bottle, and enter a count for full bottles, or weight of the bottle for partial bottles, and have the total amount tallied in a report of all bottles at the end of the counts. I have the liquors all entered in a table with their barcodes, full weights, and empty weights. The idea is to scan the barcode, perform a lookup to see what the bottle is, and if it is a full bottle (or multiple full bottles) enter the number for the bottles. If it is a partial bottle, set it on a usb scale and enter the weight of the b…

Hi I thought I was getting too big for my boots and now I know it -I set up a script to export a found set of records and formatted a button so that it exports the found records with the fields I have nominated into a csv file on my desktop - it runs perfectly on my computer - however it's a shared database so when other users try to use the button - it just doesn't work - we get the error message saying file is locked or in use - can anyone help me discover what I am doing wrong please - it's probably somethign really basic that I have missed very grateful for any help thanks Carol

I have a field that is the date a job is sent away, I need to keep track of the total length of time a job is away for. I've currently got a field that is a calculation, TimeAway=If(Date Returned>0;Date Returned-Date Sent;Get(CurrentDate)-Date Sent). So if there's a date in the date returned, it gives the number of days it's away for, that works fine. If there's no date in the "date returned" field it the calculation works when I manually change the date sent field, but it doesn't update each day. How can I force it to recalculate the field every day?

Hi all I can't figure why it is possible to check both DATA and CALCULATED VALUE... If I enter something into DATA, no calculation will be performed ! Or am I missing something ? For example: My field's name is: AutoEnter Into Data there is: 1+3 Into Calculated value there is: Evaluate ( AutoEnter ) I was thinking that when a new record is added, that field contains: 4...but no.

Hello, I am trying to create a schedule builder that will display a schedule when given various college classes. So far, I have the database structured as follows: 2 Databases: Schedule and Courses. The Courses database contains a record for each course offered. The Schedule database is where I would like to assemble the data in such a way as to build a weekly schedule. Currently, I have eight fields to choose courses in the Schedule database - the idea being that six to eight courses represent a typical semester's load. I then created a relationship for each of these eight fields to the Courses datanase, matching records using a unique CRN (Course Req…

Hi everyone! In first place, I know that is a lot of invoicing systems topics and examples around, but none of them have a simple functionality that I'd like to add to my company's system. I need to do the following: everytime an item is added to the invoice, the stock level is decreased by the quantity sold. I've tried some solutions like Sum(quantity) but it do not work as I expected Anybody has a simple solution to do this? I do not want to run a script triggered by the user, to avoid errors... This is a small example of the tables and fields. Any suggestion is welcome. invoice_stock_example.zip

Hey everyone! When I create a new record in my solution, I am brought to the first field (Field1)on my detail layout. What I want to know is how do I enforce that a value must be entered into (Field1) before proceeding (tabbing) to the next field (Field2). Basically, I do not want (Field1) to be blank/empty before any other changes are made to the record. I have FM Butler's DoScript plug-in, but I still am unable to achieve the results I'm looking for. Any help would be greatly appreciated. Thanks in advance, Jason

I am thinking of changing my OS to Linux. Can I run FMP 8.5?

Hi, I'm working on an already implemented FM DB. I know that in Access or SQL we can change from number to text without losing any content. Is it also true in FM? Can I change a number field to a text one without losing any contents? Thank you

I am looking for the method of creating a record that requires the data in two (or more) fields be unique. Thanks in advance.

I have just started to ues FileMaker and got a few questions: 1. I designed a database with several accounts. How can I display the current account name in a text box? 2. I inserted a time symbol but the time doesn't update unless I refresh the window. Is there a way to solve the problem?

Is there a way to let user enters the date by typing the day first then month? like 29/11 rather than 11/29. I got no problems changing the date format to display ddmmyyyy but no luck for the inputting portion, thanks.

how would i write a script that would always give me tomorrow's appointments. I need a formula that = "today + 1" , but i don't know how to write it ...

Hello, I have a question about formatting a text box. I am building a database for the chemistry lab that I work in. We want to keep track of our chemical inventory. I have a field in my database for entering in the chemical formula. I would like to format the field so that whenever a number is typed into the field it is always a subscript. I don't want any letters to be subscripts, just numbers. I'm not sure if this is possible but if anyone has an idea it would help me out a lot. thanks js22

Okay this is kind of complicated for me at least. I need to be able to do a calculation based off a specific field in another table. and which field is determined by a value list on another table For example: I have a table called currencies with fields as: Currency Name Currency symbol Exchange Rate I have lets say 3 records 1 is Dollars,USD, 1 2 is Pounds, BPD, (current rate) 3 is Euro, EUR, (current rate) Now I have another table Product Price (all of these are in dollar values only) I have fields of Retail Price Cost of Goods Current Margin these are easy math no problems here BUT: I have a prod…

I would like to have my "Name Title Male" field and my "Name Title Female" field together with "/" in between. That part is easy using the "&" symbol to concatenate within a calculation and placing "/" between them. But when there is no spouse and one of the fileds is blank it displays "Mr./" which is obviously no good. I created a new field just for the "/" symbol and tried a variety of calculations including "If(IsValid(Name Title Male and Name Title Female);"/";"")". My assumption was that only when both fields are populated will it show "/" otherwise it will show nothing. What am I doing wrong? -Marc

How do you force the validation of a field to occur right after you tab out of that field, and not only when committing the modified record ? Presently, I have Validated by calculation active, and it works fine, trapping any invalid entries I make in this field, but it only happens when I leave the record (next, previous, etc). What am I forgetting to do ? Thanks.

how would i write a script that would always give me tomorrow's appointments. I need a formula that = "today + 1" , but i don't know how to write it

Hi all. I have one question. In selecting serial numbers, are there any difference in having leading zeros such as INV00003 or just INV3? I would prefer the latter as it looks less messy but I would like to get the opinion of FM gurus on this.

Sometimes customers of mine enter their shipping address with german characters. Is there any way to have the german characters translated into english ones so that the shipping address is correct?

Hello. I thought this would be simple, but I can't find any other posts on this. I have a script that inserts files into containers. In some cases they will be plain text files. And in some of those cases, I want to be able to use scripts on the text data stored in the container. So, is there a function or method to just grab the ascii data somehow? Some limitations: everything is pretty much script-driven, and this is for a cross-platform runtime, so using a plugin or apple-script is pretty much out of the question.

i don't even know how to call this but what need is a field that i can add a day/month/year and have a warning valadation message appear 11 months in the future to remind someone of an expiration date. any clues.

I am totally new to Filemaker and am hoping that someone within the forums can point me in the right direction. Before I found this forum, I purchased "FileMaker Pro 8.5 Essential Training" from lynda.com and it has some good information most of which I believe will help as I get further along in this project however, it does not give any information regarding the initial database. I am totally stumped with the tables and fields portion of this. I cannot seem to wrap my mind around how to make my project work in Filemaker. I am trying to recreate what appears to be a database written in some other program but it appears to be a very simple program/database. The database i…

I am having problems with sending e-mail through FMP and I think I discovered the problem. Some fields have unnecessary spaces or carriage returns which translates into some ASCII boxes that Outlook doesn't like. As a result, the e-mails don't go out. Can anyone help me with a way that I can cure this problem without having to check each record one by one? Can I define the field so that these carriage returns or spaces are eliminated also ensuring that it doesn't happen during data entry? Thanks in advance for any help on this.

My db consists of transcripts of interviews. For analytical purposes, I want to count how frequently certain words appear. The PatternCount function almost, but not quite, gets me what I want. The problem is this: Suppose I want to know how often the word "my" appears in a line of transcript. I can use PatternCount(Transcript::Text ; "my") But this results in a lot of "false positives", e.g. "academy" and "Jeremy". I could eliminate these by using the search string " my" (with a prepended space), but then I miss any time the word "my" appears at the beginning of the text. Surely there must be some way to do a pattern count for whole words, right? Or …

Okay, basic set-up, I have stored a reference in a container field to a file. When I double-click the container field, the file (a Word document) opens up. Easy. But what I want is for a copy of the document to open, so that the original remains untouched/uneditable. I realize that I could accomplish this by locking my original file (so that when it opens, it will be read-only), but I need my file to remain unlocked for other purposes. Any simple solutions?

I have set up a database of sound effects, which are stored on the hard drive. By using the quicktime option of a container field, this enables me to realte each record to the audition file and then to audition each effect. There are two (related?) problems. If I move the Filemaker database to a different location, then the database tracks the move and it all still still works. However if I move the sound files to a different location, Filemaker loses them and still looks at the original location. Secondly it would be good to have a 'save' button which then copies the sound just auditioned into a folder set aside for the new audio project. Any ideas?

We've got a field in FM that holds HTML used for eBay auction descriptions. This HTML is generated dynamically using an ASP script. The field in FM that holds this is simply a single line that they paste their HTML into. It's not meant to see the entire contents of the field, just so that they have ability to populate it and see that it is populated. So, all you see in this field within FM is the very first line of the pasted HTML. The problem I'm having is that because the HTML is generated from an ASP script, the ASP code at the top of the page gets left out of View Source, and as such, it leaves a blank line at the top of the HTML code. When this is pasted in…

Hello all, i am trying to parse a logfile which begins with a timestamp like this "1146707632" . on mac osx, running date -r 1146707632 show that it means Thu May 4 09:53:52 HKT 2006 . is there a sane way to calculate timestamps to unix / epoch time and back? thanks a lot, overrider

Hallo, I tried to find another topic to answer my question... bad luck or bad finding skills : I'm trying to count the number of different values in a text or data field. eg: Field -> date 1-1-2006 present in 3 records 2-1-2006 present in 6 records 3-1-2006 present in 9 records my desired outcome should be 3 (3 different dates in 18 records) "count" function returns 18 : I need this to average a number of contacts (1 each record) by working days as in previous example: 18 (contacts) / 3 (worked days) = 6 contact per day (average) I'm just switched to FM 8.5 Advanced I appreciate any help. Thanks :

This is one of those things I know I could do if I could just find an example of something similar. In lieu of a more robust connection with another tool we use at work (which is ancient and not going to be updated), I'd like to create a quick method for pasting in some data from the old tool and cleaning it up and just showing the data we care about (via an auto-enter calculation step). The data I can copy/paste is multiple lines of text, with the individual field data separated by tabs. I want to paste this into a text field and strip out all but two values per line (the positions of which I can always determine by counting the tabs. So, each line would look l…

Hi, i am encountering a problem here i cant solve... : Take for example person A added a new record1 into table1, person B is able to view all records via table1. If A is to edit any fields of record1, is there a way whereby any changes are saved for viewing later while only displaying the latest changes to person B? Not sure whether i am making any sense here... Something like this. Person A new record in the table: x1 y1 z1 After editing: x1 y1 z1 x1 y2 z2 B can only see x1 y2 z2 but i want to be able to save both. The records consist of many fields so if possible any updates can be only specific to the field and not just adding a whole new…

I have a script that reads: GO TO FIELD (Gizmos[4]). This script always takes me to the 4th repetition. What I would prefer to do is select which repetition I want, based upon a calculation. If, for example, the value in another field =5, I would like the script to take me to the 5th repetition. Any ideas how to select this repetition based upon another field calculation? Thanks, Jarvis

I'm trying to do a very basic calculation in a report based on two summary fields. The data in the summary fields is working correctly within the sub summary p mart but the calculation appears to be doing it's math on the found set. What am I missing here?

I have a number field with 5 repetitions. The values are populated with a scripts that pastes a value into a specific repetition. I would like to keep a running total of the values for all 5 repetitions. For example: Rep 1 = 5 Rep 2 = _____ Rep 3 = 4 Rep 4 = 4 Rep 5 = _______ Current total of all Reps = 13 Any ideas how to do this? Thanks, Jarvis

I have 7k records in a table, each with a unique serial number ID. The field is a number field. (The serials auto enter in increment of 1). I want to get the highest serial value in the current set (or even all records in the table) It seemed so logical to use MAX(_ID) to get this, but it only gives me the value of the current record. Does MAX only work from the perspective of a related TO calculating the MAX value in the "child" TO? Isn't there a function that gives you the max value in the current table in the current found set?

I went to update the validation calculation for a field and got an error: "Unknown Error: 1218." and I am unable to enter the validation calculation. A inspection of the database shows that this happens on 23 other fields. The fields that have the error are shown to be validated by a calculation in the field definition but not in the DDR. I tried to Recover the database but it did not find any problems and problem I am having still exists in the recovered copy. I checked all of my backups and it looks like the problem happened three weeks ago. The database is in the final stages of developement so there is no data I actually care about. I just ne…

Can someone help me with this. When I use the checkboxes or radio buttons in FMP 8 they are too light making it hard to make out what was or wasn't selected. How can this be corrected? - Wagner

Hi all I am writing a new database where i am using check boxes for all the people that have are to read an entry. What i want to do is find a way to automatically uncheck their name from the list using a script - does anyone know how to do this??? regards paul

I am maintaining a 6.0 database for a client and though I'm reasonably familiar with FM basics, this is eluding me. I have two tables. One is a order table and the other is a product table. The order page has a data input layout and an invoice layout. The data input layout is formatted for 9 point and the invoice page is 12 point. There is a lookup of a product description on the order page from the product table based on a product ID. It works fine. The problem is the formatting of the size of the text is taken from the product table instead of the default formatting of the orders page. The product table is formatted for 9 point and the invoice from the…

hi newbie here. I am creating a solution for my optometry practice. I have a layout which has all the visit data. Prescription, vision, ect. I would like to have a Last visit field which auto-enters the last visit. should I use the getnthrecord function? or is there another way to display this? -Kevin

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.

If I am in browse mode and I am cutting and pasting data into a field, however the formatting, i.e. font, font size and color are coming over different since the data is being cut and pasted from various sources how can I reformat the data to display uniformly in browse mode? Ideally I would like my data to default to one font/format whether I type the data or cut and paste. Any help would be greatly appreciated.

Hi, Hoping someone knows how to do this! I'm using the "registration" template for education. I need to add a unique student ID number or serial number for each person that is attending a class or event. I'd like to be able to search by and view this number on all reports etc... Any help would be greatly appreciated! Thanks! Brian

I have created a Script that allows me to see who's payment is due today, Perform Find[] Specify, // next payment due date. How can I subtract a specific number of days from the current date?

Hi all Have tried all sorts to sort this one... also can't find a solution on this forum - hence the post. I have imported data from email packages. Unfortunately the dates in the same field are in different formats. One set is dd/mm/yyyy and the other is mm/dd/yyyy. This leads to some interesting dates eg: 08/13/2006. I would like to convert them into dd/mm/yyyy. The first part of my calc is If(mainDate(month>12) so that the conversion only takes place with the incorrectly formatted dates but I can't work out the conversion calc that follows Any thoughts? Thanks for taking the time to consider this Best wishes john

Anyone have any thoughts on how to force one field's auto-enter calculation to calculate before another field's auto-enter calculation? Perhaps a better question would be...Does anyone know what controls the order in which auto-enter calculations calculate in a table? I have a field(Field1) that has an auto-enter calculation that references another field(Field2) in the same table. Field2 also has an auto-enter calculation, but I want Field1's auto-enter calculation to calculate using the data that is in Field2 before Field2's auto-enter calculation calculates. Make sense? Any ideas are welcome.

We are currently using FM 5.0 I would like to be able to create a report that shows me our customers last order and the number of days since their last order. The key is I only want the report to show the last order only and not all the previous orders from the customer. Can this be done? Thanks for any help

Hi, I'm hoping somebody here might be able to help. I just pulled up a database that is being shared with server 7 and all of a sudden 75% of the fields are missing. There are what looks to be place holders in the define fields section, but most of the fields are now missing. The backup we have is to old, does anyone have any idea what could have caused this? Thanks, Eric

Help! I've hit a wall with what I'm begining to beleive is a bug, but I'm not sure. Can someone tell me if I can do what I'm trying. The attached database is a minamal version demonstrating the problem. What I'm attempting to do: -------------------------- I have several rows of a table (slips) that have a name and cost. Well all but one have the cost filled in, I want to figure out the cost of the empty one; Example hg 10 lg 5 lg 23 kids x where x = 50 - (total of others) or x = 50 - (5 + 23 + 10) = 12 That part actually works. Now I want a second table (fees) that will have one entry with the total for each name (the two tables are joined o…

I keep a "worklist" of final photographic prints in Filemaker and assign each work a number in the form "class.year.sequence.frame," such that a given work might look like "3.2006.021.9774" and I would like to have a calculation field display the prior maximum value. I know that because I've used periods as separators, the value will display as 3.20060219774, which is a little awkward, but still usable. However, when I created a calculation field called "Worklist_max" and defined it as: Max (Worklist number), it only displays a value in records where I have already assigned a worklist number. What I would like it to do is to show me the highest prior value when I create a…

I feel there's got to be an easy way to do this but I can't figure it out. My layout has a simple text field which is blank. I want to to insert an "O" for "old record" into all of my "found" set text field. How do you do this? I know I can do it when I import data in, but I need to add this after the import. :hair:

Hi, How do I add a serial number field to a layout and have it automatically put in the serial numbers? Thanks, MT

Hi Team, I have table "products". Then I have another 5 tables for different kind of materials needed for production of the product. There are few common fields in material tables (as record ID, supplier, price but there are 4-10 different field which are specific for the given material table. Table product is related with each individual material table. What I am trying now is to set up a layout based on "purchase orders" table which should enable selecting materials from all material tables. I tried to create joining table for all materials but stuck with relational problems (many table occurences) and relations resulting in circle. I was t…

Hi, I'm looking for a way to see in a portal the last 10 added records. I was thinking on a calculation with the Max Function, but that is not working. Any Idea's .. Thanks Patrick

Hi I have imported an excel list with the first field being the person's Name. It contains Title, first middle and last names. I want to get rid of the title (Mrs, Mrs, Ms etc) which is always the first word so that I just have the name only Sometimes the field contains 3 words, but if the middle name is there, then there are 4 words in the field includinf the Title Can someone please help? Thanks

Hello Team, I'm looking for a good way to change date formats from; 20060922 to 09/22/2006 I've been playing around with the text and date functions within a calculation field but I'm getting nowhere pretty fast. Any help here would be greatly appreciated. Thanks. - Sez

The result of this calculation should be "9999/STATE/CITY/STREET". RightWords("ABC/01/9999/STATE/CITY/STREET";4) Instead, it returns "01/9999/STATE/CITY/STREET". However, it returns the correct result for these 2 variations: RightWords("ABC/01x/9999/STATE/CITY/STREET";4) RightWords("ABC/01/x9999/STATE/CITY/STREET";4) How do you get around this? (I am trying to extract the name of the Folder enclosing "STATE/CITY/STREET".)

hi! Sorry if this is NOT the right forum to post my question! I've been a member for a while but this is my first question..thanks in advance. I 'm a teacher trying to design a timetable for my school. it's a sort of a 5-day weekly plan where teachers can enter info about what they are going to teach throughout the week (lesson title and book page) ...Now if a teacher has two groups of students he can enter the same information for the two groups togther..( sometimes 2 teachers are entering the same info since they happen to teach the same level) One more question ... if one teacher (say science teacher) is giving a test on a certain day NO OTHER teacher of…

Hi all It's possible to check a field ( formatted as check box ) in a record in list view so that, if i'll check the same field in another record, that first field re-evaluates to uncheck itself ? That is easy with a script, but with AutoEnter calc and relationship ?

Has anyone re-created the graphic slider on the status area that toggles through the found records? It would be a very useful thing to intergrate into my database, as it allows a user to not only move through the records but also gives a graphical indication of the place in the find. Has anyone done this? If so how?? Thanks in advance!!

needing a calculation field that would always figure out what is the middle date. so if you had 2/1/06 as the start and 2/28/06 as the end, that it would like you know that the middle date is the 2/14/06. thanks