Calculation Engine (Define Fields)

I have a property management company and need a way to stay current with the clients. The properties stay the same, my clients information changes. I want to be able to type in the clients last name and have a listing of all property id's (in a pop up list) associated with that name, then when you select the ID the property information comes up. I have one table (client info) with: first name; LAST NAME; home address; home phone; PROPERTY ID; PROPERTY ADDRESS; PROPERTY NUMBER I have another table (Property info) with: PROPERTY ID; PROPERTY ADDRESS; PROPERTY PHONE; LAST NAME I have related PROPERTY ID of my client info table to my property info table …

I am a beginner in FM with no real database background and have search this forum but found no answer to my problem. I have Invoice table with Discount field (in %) and Discount amount field. How do I set those fields, that I could enter discount and calculate Discount Amount, or I can enter Discount amount and Discount is calculated. I would like to have both options available to me. Also, I would like to enter Discount number in % (let say 10 for 10%) no 0.1. Thank's in advance

There are three fields involved. 1. Operation (Value List)Text Field 2. Hours (Number of hours a worker spent on the operation)Number Field 3. Operation Cost (Hours X Operation Cost)Calculation Field The Operation field is using a Value List of operations with the hourly cost of the operation the last word of each text string. 710-10 - Design 114.00 710-11 - Web/Html 110.00 710-12 - Disk Preparation 088.00 710-13 - Illustration 109.00 710-14 - Scanning 090.00 In the calculation field I need to pull out the last word from the Value List…

I am trying to duplicate a record but leave certain fields blank and leave certain fields with the original information provided? HELP

I am new to FMP7 and I am looking for a more elegant solution to the question below. I have 3 variables with the values of a, b or c. I want to create a new variable that counts the number of times the value "c" occurs within a record. I could create three new variables that issolate the "c" using the If and/or Case function and then create a variable that "counts" the number of "Cs" in the record but there must be a more effeicient way of doing this. Also, is there a way to create mutiple new variables using scriptmaker so you don't have to "muscel" your way through the point and click menus, as you could using SPSS syntax? Any help would be appreci…

I have a calc that uses a case statement. In my view it looks good but it didn't work right. Here's what it is about: I have 3 fields, called A, B, and C, and of course the calc field called D. Now field C, can have a value of 1 or 2. Now I want it to return a value based on the month range and also the value of C. So I wrote Case( month (get(currentDate)) >=4 and month(get(currentDate)) <=9 and field C =/ "2"; field A; field C =/ "2"; field B; "" ) Now today is October 1 and my calc is still showing field A results. Is there something wrong? I need field C to be a not equal statement because there might be more values than just "1" and "2" …

Need help - explanations 1. If any solution- routine - error check in fmp > 6 for testing is computer connecting on Internet or not ? 2. How to cline some html text which is grabbed from internet that only text information stay in input field ? Mean clean commands; elements; functions and ... all other what isn’t real text information inside some fm > 6 db. Something with Replace or Substitute calculation ? Ino [color:red] [color:red]

Currently, I have a container field that contains file references. If the user double-clicks on the container, the file reference opens the file (which is on a shared volume).. My boss is lazy, and doesn't want to have to double-click. He wants to single-click. Is there some way I can write a script that will open the file automatically on single-click. Export Field Contents is not want I want.. I want to open the file reference.

I am a very eager but programming thick beginner. I have created a very simple file where I enter orders from a client. I have set it up so that I can manually enter the product and then the quantity ordered and then I can add the price which is subtotaled. I was wondering if there was any simple code that would allow me to have the price entered autoatically once the product is selected. In other words: I enter the product field and a popUp menu appears with the list of products I have available. Once I select the product I need the price automatically appears in the item price field and is add to the sub total and total calcualtions. Can some one help me with this? …

I have a table called jobs, that lists all of hte work going through at a given time. I also have a table called Job Status which gives the status of those jobs. We often print the Job Status Table to take to our production meeting. What would be the easiest way to set up a time stamp for the report itself so the manager knows what date and time the report was printed out? Thanks

Hi, I have a database for members. Each year they pay a particular amount depending on their status. In the database i have a table for payments, in that table are two fields: Year Amount Paid For each member a new 'payment' record is created. On a related table i have two more fields: Year (a drop down list containing years based on the payments table) Total Revenue i want to be able to select a year and have the revenue appear in the revenue field. I know the basic consept of the solution: 'the sum of {amount paid::payments} when {year::payments} = {year::main} just not how to implement it, or the functions to use. Apol…

Having trouble getting a 'Fraction of Total' to work in a summary field with FileMaker 8. Works as expected in FM 6 & 7. Has anyone else noticed this, or is it just me?

[color:purple]Maybe there is a better way to do this, but I haven't figured it out or exactly how to do it correctly. Database example: Classic School Database. TABLES: [color:blue][students], [Classes], [Enrollments] What I am attempting to do: Using a classic School Database application, I need to create a custom sort order for the "[color:purple]ClassDay" field contained in the [color:blue][Classes] table. Instead of analphabetical sort, I need to sort data in this field in the following custom order: VALUE LIST field data: _____________________________________ [color:red]- (1) Mon. - (2) Tues. - (3) Wed. - (4) Thur. - (5) Fri. - …

I have several fields that have a number stored, 1-6, I want to know how I can total or cout how many times "1" was selected. Database: Student Misbehaviors Table: Each Incident Field Student_Behavior -- Number (recorded 1-6) Each number means…. 1 = Physical Contact 2 = Foul Language And so on I am making a report and want to know how many times a 1 was recorded in this field. P.S. The Field was designed this way because that’s how the data is imported.

Hello We have a web site where filemaker is handling the news section and the web shop. Now we want to put all the conctent of the site into filemaker(7). The question is what to do with images, mp3's and quicktime movies... Which way is the best? If we put all this in container fields, is it an easy way to get this out on the web? I just realized that by choosing "insert sound" or "insert quicktime" there is only a reference that is stored in the field. But by choosing "insert file" it seems different. Is that the way to go? Will such a solution slow down the system more than including file references only, and put all the media in separat folders? …

Hi all, I have a solution that uses a checkbox field that worked just fine until...for no apparent reason the checkbox field is behaving erratically. Here's the situation: I have a checkbox field on a layout that appears in a "popup" new window when the user wants to add keywords, or searchwords, to a record. The look and feel is much like MS Outlook when you assign a category to a record. Anyway, everything was functioning properly until, for no apparent reason, the checkbox field has "gone nuts". I can check and uncheck the first 10 values as one would expect. When I try to do the same to values 11-20 nothing happens. Then when I try to check/uncheck valu…

Hi all friends How would you calculate the worked nocturnal hours, knowing that the nocturnal timetable begins to the 22 and ends to the 6 ? A worker can begin the turn at 20:30 and end at 2:30, or can begin at 2:00 and end at 8:30. (or even other combinations) ;)

Setting up a database and i need to duplicate the record a certain number of times depending on the result entered on the orginal record entered... is this possible?

I want to incorporate the question of whether a seperate field contains a unique value into a calculation. i.e, Field 2 = if ( field 1 ValueIsUnique = true, result A, result B ) Anyway to do this?

Good aftenoon all.... Thanks to plenty of help/advice from fellow forum users, i've started to create a membership database. What i'm trying to do now is to create a scratchpad/notepad, where database users can enter text to make notes on a members data. e.g: member broke leg. 21/07/05 etc. The ability to add numerous notes per member is required, as is the ability to select a heading for the note from a drop down list. This drop down list contains headings that in our organistation are known as 'Event Type Codes'. Elsewhere in the database is the ability to add to this list of Event Type Codes, so the list for the scratchpads will need…

Righto, im currently utilizing text globals as critical relational fields... i know they are session specific but ive got them set as auto enter calculations... is there any reason they would disapear despite being setup as auto enter ... ? Cheers in advance, genx

Hi all I have convert an Excel speard sheet with 1500 records into FM Dev. 6. I need to find the lastest Serial Number in the db. I made a self joining relationship called Max_serial using the serial number field for the relationship and define a calculation field called Max_serial and used the relationship named Max_serial and chose serial number for the field. I installed this Max_field in the header section of a view layout. Example: Max[Max_serial:: Serial number] This only shows the serial number that the pointer is set to at that time and does not show the lastest serial. If you move the pointer to another record in the view layout, the field max_serial s…

Hello, I have just imported 223 records into my database which didn't contain the field "Mailing List" which is a value list with the values "yes" and "no". I need to set all of the records that have an email address in the email address field to have "Yes" checked on the mailing list field. I have tried doing scripts with if statements (i.e. if email address is valid then mailing list "yes" otherwise "no".) I've tried using the set field function as well as any other functions that seems to work. Is it possible to do this?! Or am I going to have to click "Yes" for all 223...?

Hi all, Wondering how I could calculate a running total of an object, but once that object is depleted, I want a new one that starts with a fresh running total. For example, say I want to see how much I exercise each day and I want to keep a running total (hours) of each activity I do for the entire day. Then the next day, I would like to start a new running total for each thing I do that day. So on and so forth. I wonder if this makes sense, I hope. So I have a field where you input the hours and a radio button field for new or old with the values "yes" and "no". If you select "yes" then a new running total begins. If you click "no" (object is old) then it co…

I have Quicktime files that worked in FMP6.0 developer but not in 7.0 developer. Any thoughts or fixes? The quicktime files play fine and dandy in Quicktime.

I have table with results of the market research. Some fields containing values "Yes/No/I don't know" I would like make the report which will be include total sum of not empty values and number of "Yes" answers, "No" answers and "I don't know" answers. How can I do that?

I am creating a solution to track the different functions of a trade show decorating company. Primarily the solution will track customer orders, make invoices and also create "load lists" or reports that tell the production people how many tables to bring to the event, how much on site labor will be required, etc. When I started working here they needed something that worked asap - so I threw together a very simple database that is sort of working but could be a lot more elegant. Now I have the time to properly design the system. But I’m a novice database programmer so I’m not really sure how to make things in the most efficient way. My current question is…

Hi all friends does someone know if there are international rules for the birthday of a person born on february 29 ? I think that if a baby was born on 02/29/2000, his birthdays were: 02/28/2001 firts year 02/28/2002 second year 02/28/2003 third year 02/29/2004 forth year ( on 02/28/2004 he was 3 years old) If what I think is right (internatinal rule), the calc for the age in years format: Year(theDate) - Year(birthday) - (theDate < Date(Month(birthday); Day(birthday); Year(theDate))) is always good except in this case.

I have got a field "Copy Cost" which has the following calculation. If(PatternCount(Payment Info; "Make Good"); 0; If(GetAsNumber(Count of words in text field) <= 20; 19; Count of words in text field * .95)) I now need to incorporate the following calculation into the first one. If(PatternCount(AD PRODUCTION; "Text Only Ad"); If(GetAsNumber(Count of words in text field) <= 20; 50; (Count of words in text field - 20) * .95 + 50)) Thanks in advance for any help.

I have the following problem: The child table is records of line items with an AmountPaid field related to the original parent table by a numeric field, ApplicationNumber. I have six calculation fields in the parent that need to contain the AmountPaid values for the first six related records (one-to-one) from that child table for export (along with a ton of other data from other related tables) to a csv file for upload to a mainframe. The user doesn't need to see/manipulate these values, so I don't need a portal in a layout. The original programmer created 6 different relationships with 6 fields in the parent table composed of ApplicationNumber & ".1", Applicatio…

Hi gang, I am going nuts! But besides that, I have a problem with one of my calculations. In my job table I have a field called Job::Date_Received. In my job line item table I have a price field called JLI::Price_Actual. In my price table, I have two fields called Price::Rate_A and Price::Rate_B. the Price_Actual field is an auto enter calc as follows: if(Job::Date_Received < "09/12/05";Price::Rate_A;Price::Rate_B. It doesn't work. I used my data viewer and put in Job::Date_ Received. It showed 07/14/04. I put in a calc that said: if(Job::Date_Received < "09/12/05";1;0). It comes up "0". What the heck am I doi…

I have a table that has a self-join based on 4 criteria. The relationship will typically result in 0 related records, but could return up to 5 related records. What I'd like to do is check a field on each of the related records to see if the value "none" exists in a certain field for any of these records. Two ways I thought I could check for this were: Case ((PatternCount (RelatedField_thru_self_join_T.O.; "none") >= 1); "records found!") or by creating a related value list and checking that way: Case ((PatternCount( Valuelistitems(Get(CurrentFile); "Value List")); "none") >= 1); "records found!") But neither of these …

Hello to all the friends They are days that I try to solve this question: it is possible that a calculation gives back all the values of a number field of the entire DB? Without scripts and portals... From the first moment I thought was simple... instead it appears to be an absurd question (from which the object!) The summary fields make something of similar (in the sense that their calculation considers the finded records or all the records); in order to make this THEY MUST know the content of all the fields of the DB and, as an example, make of the sum. With the Last(field) function I succeed to obtain the last value of a relationated f…

I have a database with utility bills for our school district. There are multiple meters for each school campus, and 22 schools. I have bills for each meter for each school for each month for the past 21 months. I'd like to calculate quarterly totals for the schools sites (including all their meters), and then compare the quarters year-to-year to see if each school is increasing usage/charges (i.e. first quarter last year compared to first quarter this year). All the data is there - I just can't figure out how to get the quarterly totals across multple years, or how to do the comparisons. This is my first FMP database, so "beginner" may be an understatement!

I'm trying to parse out some text between ampersand characters using a global number field "Counter" within the Position function (e.g. Position( Text, "&", 0, Counter). The Counter field is based on the PatternCount of the ampersand character within the text. Going one step further I'm using the Middle function to hopefully get the text between the ampersands using the calculation; Middle( Text, Position( Text, " & ", 0, Counter) + 1, Position( Text, " & ", 0, Counter + 1) - Position( Text, " & ", 0, Counter) - 1) But for some reason when I want to increment the Counter field (e.g. Counter + 1)I'm not getting a result. Can …

It's been a long time since I had to use a repeating field so maybe I am just a bit rusty. Two fields in a line items table, ItemID and ProductName, both are repeating fields with 10 repeats. ItemID is defined as a number field, and ProductName is defined as a calculation field with a value that is calculated via a relationship between ItemID in this table to the ItemID in the Products table. The ProductName field is not being returned with this setup. If I change the field type to Text instead, it all works fine. What am I missing. Thanks for any help. Echo

I am trying to make certain I'm doing the right thing with a database with a container field. I would like to somehow have a link from FMP 5.5 to a WordPerfect text file. When the link is clicked, the file linked in the container is opened in its native app (WordPerfect). I have successfully done this once, but I want to make certain that I'm not risking the original file in any way, and that a container field is exactly the right way to link to this file. Is this the purpose of the container feature, or is there a better solution? TIA Lefo

I made a DVD database for my home collection, based on the template provided with Filemaker. So far, I have entered just fewer than 140 of my DVDs into my database. I decided to include cover artwork in a container field, which is about a 40kb jpeg for each DVD. However, my total file size for the database is more than 70MB! This means that each entry is using more than 1/2 MB for Title, Director, Country, Year, number, and 40 kb art. Obviously this is rediculous. I have not, to my knowledge, enabled any indexing options or anything that should cause the file size to increase by such huge amounts. Could anyone offer any suggestions before I go back to Acces…

I have a simple example attached of what i need help with. Setup: There are three tables: (Main, Company, Employees) The main table shows the company you want, the company table shows all of the companies in the data base with there employees The Problem: As you can see you can pull down any company you wish and then select the employee you want from that company... Cool I know ... it only shows the employees for that company. But I also need it to show the email address on the main page for that companies employee. This way I can do a auto email for what I need. Can some one add this this and show me how this is done. Thank yo…

Guys, Just curious, I've been playing/converting my solution to FileMaker 8, and it's quite neat compared to the previous version I was using (v6). I've just noticed when defining a field, underneath the AutoEnter tab, calculated value, you've got the "Do not replace existing value of fields (if any)". This feature's quite neat if you want to reformat data from fields within the same file. However I thought I would take this one stage further and try and populate/reformat data (automatically by unchecking "Do not replace existing value of fields (if any) option ) from related files - but this doesn't work. Has anyone managed to use this autoenter - calculated …

Is it possible to create a File As field like Outlook, in a contacts database that not only reflects 1st Name/Last Name but also takes into account the Company name field (which uses the 1st name as the 1st sort). Thus when sorting alphabetically, names and companies will be sorted together.

I don't know if this is a silly question, but I need somebody's help on this. For QA purpose, we need to create new database tables exactly copying from the original tables. The problem is since each table has about 60 - 100 field names, creating fields one by one for each table would be really time-consuming. Also we need to make sure these copied tables keep the same data types as the original ones. I checked Export/Import functions, but it looks they are for data record transference purposes rather than for data structure. So is there a way to copy table fields from one table to another? Please let me know. Cyont

Hello all, I'm no doubt doing something stupid, but i can't seem to enter data into a field in my database. In the attached database, is a layout called 'Factory'. This layout has a field to add a new factory. (This data gets added to other layouts, via a dropdown field - called 'Factory' - and such creates a list of factories for the user to choose from). When i go to create a new record, and start typing - it will not let me. Any advice would be most appreicated. Kindest Regards, Shane contact: shane [email protected] progress.zip

I've been trying to get a file name from the end of a path name (on Windows) with the following formula: Right (pathFile ; Position (pathFile ; "" ; Length (pathFile ) ; -1 ) ) The problem is that the backslash ()used in Windows file paths is rejected by the calculation dialog when I try to save the calculation. How can I get around this? Any help is appreciated.

has anyone had any experience with (or know how to) use a digital pad to capture a signature and have it appear within a container (etc.) within a filemaker record? For example an employee signs in using the digital pad and the signature appears as a jpg (etc.) within their filemaker record. Thanks!

My fmp7 file has three fields item, location, quantity. For each item there can be multiple quantities at each location and there are 15 locations. I want to know the two locations that have the smallest amount of quantity of an item. The rest of the locations can be deleted or omited. I can see that using a portal or some type of script would work but I just dont have the FMP skill to do it. Any help would be great!!

hey everybody, I want to create a field that adds together all the numbers in a certain field of all RELATED records in another table. basically, it's a list of related tasks, all of which take a certain number of minutes and i want to know, cumulatively, how many minutes total this person's taks are taking. how do i do this?

I am very new to FM and scripting so I'm sure this is a simple question. I thought I was writing this calculation correctly but it's not working so I guess I'm missing the big picture. My solution involves tracking conventions. What I want is a way to mark each convention record as either active or not active. A record would go to an inactive state 7 days after the end date of the convention. This allows time for final invoices to be created, etc. What I have done is create a field in the convention record that is called ActiveStatus. Then I've defined this field as a calculation. The calculation that I thought would work is this one: If ( End Date + 7 &lt…

I was wondering if anyone could explain how to remove the text that is automatically generated in shared fields in table view. [sOURCE TABLE :] is automatically generated each time I drag a new field into the layout using the field tool and I would like to remove it. Is this even possible? Thanks

How do I subtract a date from a date and get an answer by Years / Months / Days. Example: 1-1-04 subtracted from 8-1-05 returns 1 year 7 months 0 days Thank you, Joseph

I was just wondering if someone can give me a starting point on this. I have a customer service database. We track our client orders with this. Our clients go through a lot of employees. We don't know when they leave the employ of our client. When showing our clients orders, I want to show our clients contacts in a portal sorted by the highest number of orders by a contact, over the last 30 days. Table 1: Orders Table 2: Client Table 3: Client Contacts Portal: Want to show contacts sorted by number of orders over last 30 days. This way once a contact stops ordering our product because they no longer work for our client, they'll drop to the bottom of the…

"If (Photo Dates = Daily Sheet::Photography Date: and Daily Sheet::Church ID = CHURCH ID; Daily Sheet::Number of Sits ; 0 )" (photo dates is a repeating field that will match Daily Sheet::Photography Date: Church ID is not a repeating field in either file number of sits is not a repeating field either, but the field this calculation is a repeating field. the formula works perfect only for the first repating field. the other 32 do not. any thoughts? feel free to email me @ [email protected]

In FMP6 and previous versions we had a simple script which said Open URL(fieldname) where field contains the complete URL of a .pdf containing submitted documentation. For some reason with FMP7 this has ceased to work on some of my users machines, but not all. I guess the workaround would be to put the .pdf's in a container field, but before I start converting everything...any clues why it won't work and what are the advantages/disadvantages of using a container field to do this? Any help will be appreciated.

[color:blue] Hello all, Sorry of this post is in the wrong section. Also, hopefully the following makes a bit of sense. (I've attached a zip file containing the database/layouts that i refer to in the following text). I am trying to create a database for the organisation that i work for. With a lot of help from fellow forum users, i'm beginning to create something useful. Being very inexperencied with FileMaker, i'm having a spot of trouble completing the next stage of my task. I have a membership database that lets me add new members (very useful ), and that uses portals to create a scrollable history of all amendments made to each members …

Hi everyone, Just to ensure I'm not being delusional, does everyone concur that there is a bug with get(desktoppath). For starters it's putting in / instead of which is easy enough to fix, but it also puts an extra / in front of the string i.e C:Documents and Settings{name}Desktop Subsequently, I can't get it to open up my users file on their desktop Anyone??

Hi, I am having trouble with what I thought was a very simple lookup field. I have a simple table with 2 fields that stores Machines and the number of production "heads" they have Fields: Machine (text) Heads (text) In a realated DB when input is made in the Machine field, it matches and pastes the data to the heads field of the related DB. Simple. Problem is, it only works half right. The company I work for has named all of the their machines like this: 131A 131B 132A 132B (etc) When my DB does the lookup it is only seeing the first 3 numbers of the first occurence of a related record(s) and copies that "head" information ov…

I am new to FM8. This may be a simple solution... I have a Table that contains the answers to 50 test questions, in seperate fields, with 8 possible answers(A,B,C,D,1,2,3,4). I would like to have the item analysis for each question diplayed in one report, for example 5-A's, 6-B's, 13-C's. In addition... I would like to perform calculations on the results, for example what percentage of the respondants selected "A" for an answer. I have orderd FMP 8 Advanced.. if that helps at all. Thank you in advance.

I need to create a field which looks at an existing field and strips out everything in it which is between chevrons, i.e. replace with nothing. How do I put this into the function? I've tried asterisks and it doesn't understand them, I guess because in a function they mean multiplication! First post, hope someone can help! Emma

Hello. I'm new to Filemaker and I have a problem setting up my database. I guess this is a silly questions to you. Here is my problem. I have two tables one of these tables is used to store a company name. The company name should be unique so I added a Id in the table. It just looks like this Table Company field1 company_name field2 company_id Company id is set up to automatically asign a number and as a unique field. Company_name is also set up as unique field. When I create a new record and type in a company that already exist. Filemaker complains that this must be a unique field. I know that this is right but I want it to use …

I'm sorry if I post in wrong forum.. My question is it's possible to enter time in field with format time without enter ":", for example if I enter 830 it will show 8:30. I need your kind suggestion... Thank you for your kind attention Thx Ben

Hi guys, I'm trying to set up a database to convert data entered as mm.ss (e.g 2.30) into total number of seconds (i.e 2 minutes = 60 seconds, plus 30 seconds = 150 seconds) I have Minute ( time ) * 60 + Seconds ( time ) but that means my user has to enter in 0:02:30

I would like to add a field (Months) to a date field. Any easy way? Example: 1/1/05 + 42 months Answer = 1/7/08 ? IW

All, I could not find a solution to this problem in the FAQ, Forum Search or FM 7 Help. I need to convert umlaut and accented characters to the ASCII unicode representation, for example a-umlaut (ä) should become u00e4 Is there a calculation/function to do this? (I am aware that I could create a custom function, but cueerntly I don't want to enter into that effort.) Related q. Is there a way to get the ASCII number of a character?

Hi - Just wondering if there's any way to create a graphic which is addressable. For example, I have a calculation that results in "58%" and I want a "progress bar" to show at that calculation result. Is there any way to do this? thx Andrew

Hello all, i have a Portal which displays a set of Items. On the Portal i like to have one Field which displays the Number of Times the Item is on the Portal. It is no Problem that there are same Items on one Portal, i just need to know about it. So i made a Item_ID to Item_ID Relationship, a Calculation Field which does SUM (relation::constant1) . This Field only displays how many times the Item is in the Database though. How do i have to setup my Relationship please? Thanks,

I have 10 different record with note (text) and what I want is put all note in one field. Is anybody can help me ? I'll appriciate your kind help. Ben

I have quite a few unstored calculations that generate a whole bunch of status information on the fly. I just realized that if I remove a date from one of the fields (an acceptance letter date field), when I try to commit the record, Filemaker freezes. Sorry, I can't upload the file ... there are too many things going on to explain all the fields, relationships, and what they do... can anyone provide a general explanation of why this might be happening ? Thanks.

Hello, I have a Portal with a few Records, each have a Field containing the Time when the Record was made. Is there a way to calculate the elapsed time without using a script? So basically, last portal row time - first portal row time... thanks

Thank you for your interest!.. I'm looking to Tie/relate record ONE in Associates table to Project table as the "Company" Associate globaly to share with all Project records. Example: TableOneAssociates Fields: - mp_id_tableone (autoenter SS# T1001) - txt_assoc_name (just a text field) TableTwoProjects Fields: - glb_clc_tableone_first (global storage calculation field with result of (=TableOneAssociates: mp_id_tableone)[FirstRecordValue])) Associates can be many and work on Projects. One Associates can own multiple Projects. Associates have check box tag of "Company", "Vendor", or "Client". Associates can be one of these values or …

Sorry if I posted this in the wrong place. I have a time field that is formatted to enter time as 12:00 (24 hour format. I need to create a calc that will see the time and determine what particular shift (ie. 7am-3pm, 3pm-11pm, 11pm-7am). I was thinking of using a Case function statement with at getastext function, but it was wasnt working properly. Any suggestions? Thanks Ron

OK, I'm a filemaker noob here so be patient with me. I am in High School and writing a program for our school bank to use, they are just starting up and they don't want everything on paper, i started out in access, but i found filemaker was much easier to use. I'm still having one problem though. Here is what i need to do: I have one table labeled Accounts where all the acount information is including account number and a balance field. I have another table called transactions where all the transactions will be entered, such as deposits and withdrawls. I would like for everytime an account number is entered and the transacion amount is entered for those values to be …

I searched for this and found that is seems possible but not how to do it. Can I enter dates in this format DD/MMM/YYYY i.e. 01/JAN/2005 or does entry have to be based on the systems clock.

I have a complex database of plant DNA sequence information that is used in my research. I have just upgraded to FM 8 Pro Adv. Currently, the DNA sequence files are located on my MAC hard-drive and occupy around 500 mb of disk space. Ultimately, I'd like to begin archiving them onto DVD, which although not editable, would allow access to data contained within the files. So, I would like to store the reference to the sequence files. While on the hard-drive, I can still edit the sequence files using my sequence editor, but when moved, I'll only be able to look at them. Considering that I have a couple of thousand DNA sequences, I would not want to have to …

Hi Guys Im trying to script the storage of a pdf document within a container field. Well I've managed to script this using the Insert File script which is great. However, when I double click on the container field, id like the pdf file to open up and display, and I can't manage to do this. I've found an export field contents command, but that requires you to Export the file onto a desktop and and then open. Is there any other way to script the opening of an external file stored in a container field, without using the export field contents command ? As always, many thanks for reading this post. Jalz

I need serious help. No, I mean with FileMaker I have a relationship based upon numeric-date range key Products::cNumDteRange = LineItems::cNumDteShip AND Products::ProductID = LineItems::ProductsID Request: On each Product, look backwards one month from today (only counting workdays). Get sum total of quantity sold from two fields: Quantity (positive number) and ReturnedQty(negative number). Divide sum sold by workdays to determine (on average) how many are per workday (based upon the past month). Look at our Inventory and project out the DATE we will run out of product. I have calc called cSoldPerDay1Mo (number) of: Div(Sum(LineItems::Quanti…

Hello all, can someone tell me how to convert a Date like this 2005-9-13 into this 09/13/2005 so Filemaker will accept it in a Date Field? Thanks a lot...

I've got 3 tables: tbl_Quote, tbl_Quote_Line_Items and Estimate. Basically the user enters a breakdown of what they think a job will need in the estimate. They don't necessarily use the figures in the estimate for the quote, it is just a rough guide. However, bought in items entered in the estimate table are used. I am trying to do a forecast layout based on table estimate but I need the actual quote total (Summary field) which is in tbl_Quote_Line_Items. I seem to be having difficulty getting it to display. I've tried defining a lookup field in tbl_estimate to get the quote total from tbl_Quote_Line_Items so I can use a summary field to get the information …

Hi, I was hoping to get some feedback on inserting a picture vs just a reference. I know that when inserting the picture, it seems less fragile. But is there a performance benefit to just adding a reference?

I know this topic has been discussed many times, I’ve searched threads but cannot find - can someone please send me a link? I moved a FM database to another server, many of the images are stored as reference only, I need to redirect the file path to the new server and store the actual file (I may need to move the database in the future) Sorry for the redundancy, thanks in advance....

When inserting imagefiles into a database you can either choose to do that as images or as files. When doing it as images you can view them but not edit them, or you can edit them but not view them. You can choose to have the user insert a file twice but this is not very nice. *** THIS ONLY WORKS WHEN YOU INSERT A FILE/IMAGE WITH REFERENCE NOT WITH EMBEDDED FILES/IMAGES ***RIGHT NOW THIS IS MAC ONLY, DUNNO HOW THIS WORKS ON A PEECEE (pcfile? pcimage?) The folowing calculations are used in a calculation, set to type container, to change images in one field to file references in your calculation, or to change file references to images in yor calculation. …

Hi - I'm using filemaker dev 7. I have a pricing grid made up of quantities and prices at those quantities. 12 fields all together. I'm trying to create a calculation resulting in html which could then be exported. The problem I am having with my calculation is that filemaker see's some of the html and thinks its filemaker fields. Is there a symbol I can use that will tell filemaker to disregard whats in between the brackets or symbol and trat it as just text? I know you can use " " - problem is in html quotes are used. example of what i'm looking to achieve as a result of my calculation PRICING Quantity …

I have a normal text field or at least it seems that way, it is supposed to be a not field for the client but I cannot get it to accept more than one line of text. Does anyone no what I have set incorrectly? How I can get it to be a mulitple line field? Thanks.

Hi, It's been a while since I posted. New job, new city...holy cow....but I digress. Anyway, I need some help with what I thought was a simple calculation. I need to retrun the number of minutes elapsed between two times, with the curve thrown in that sometimes the times cross over AM/PM and my source times are entered that way as opposed to "military time" Start time = 11:47:33 AM End time = 12:13:37 PM Result = Minutes elapsed. If the result is more than an hour I still want it to return only total minutes. Can anyone help me with this one? Thanks, Steve Freeman

Ok, I'll go straight for what I need. I'm working on a database in which there is a time limit in creating a record. The record has to time fields. One is entered manually and shows an event that will occur at that time on a precise date (kind of TV show let's say). The other time field is automatically entered, and it has the creation record time. Now if the creation of the records happens after the time of the event that the record shows, this record shouldn't be created. Is there any way to triger the prohibition of creating the record at the time that was verified this is happening after the time limit? Or if it can't be triggered any other solution wo…

I am working in Filemaker 7 and wish to duplicate a table so I don't have to re-enter all of the fields again. I saw where FM 8 can do that but in the trial version I downloaded it makes a copy in the relationships view but doesn't actually create a new table. Each semester we will need a new table to house contract info for instructors. I need to create a new table each semester for separation purposes and it's going to be a pain if I have to recreate it every time. Any thoughts?

Is there a way to change the embedded file name of an image that is embedded in a container field? Oh, I hope the answer is yes!!! Here’s why... I have a FM7 file with thousands of records. Each record has multiple container fields with images embedded in them. I have a field that gets the name of the file in the container field (using the get as text function). The container fields that have recently embedded images in them do not pose a problem – the file name shows up fine. However, some records (the majority actually) which have been around for a long time (some since the FM3 days) do not have any file names associated with the embedded files. They show…

I need to protect certain fields from being overwritten once data has been added. This is for a solution where certain medical information must not be alerted, once entered. Any thoughts?

hello I have a db with a large list of mutiple choice questions for school, i have another field on a seperate layout that shows the answers. when you complete the test is sends you to a layout showing your answers and the actual answers. is there anyway to auto correct then answers and display if it's wrong or right in another field. I was thinking this had something to do with the case fuction Thanx in advance

Hi - Ok - not sure where this goes, but I saw a bunch of calendar and date related posts upon search in this forum.. so here goes: I have the demo of 8; previously, my only experience was with v4, which I used to build a rudimentary time tracking/project tracking/project info/billing system. (1998... and they still use it!) Anyway, I'm off on my own, and want to build a project management system - a simple one, a little at a time. Ideally, however, I NEED calendars - now, I've seen the popup calendar, but without knowing exactly how it works (and knowing it's not really too adjustable) I thought I'd ask: 1) Can I (elegantly) build a window which …

Hello! Im trying to get the path frpm a container field into a field. I am trying with a calculation field and Im doing GetAsText(Picture) but the only thing it is returning are a ?, does anyone have any clue why this doesent work? Regards Jocke

Sorry to be so needy today.... Can someone please download and open the attached file Op perf After Open screen Click on button "rank by employee cost per Unit" Script will display a sorted report. What I can not figure out is it does not sort properly. It should sort from lowest to highest based on cost per unit. Anyone who looks will see this is obviously not the result. I have spent hours trying to figure this out and I am sure I am doing something fundamentally wrong when I set up the report, but in following the insrtuctions from the FMP documentation regarding "Sorting records by subsummary values" I don't understand why it is not working.…

this has probably been asked in the past but I have not been aboe to find the answer in Archives. How can I write a calculation that will automatically factor for overtime pay without having to have a second field for hours over 40? In other words if Pay_Hours > 40, 40hrs at "X" rate, remaining hours, "X" rate X 1.50. Thanks for any help you all can give. Steve

Hi everyone, A different post reminded me of an issue I need to resolve. I am working in the Credits piece so this is opportune time to seek assistance. We receive 500+ purchase orders a month from various companies. Our computers never match on the final invoice total because each company rounds differently. Currently, Sales Reps have to add a "Rounding Adjustment" which adds/subtracts the difference. This prints as "Rounding Adjustment" on the Invoice below Shipping Charge and Payment and is restricted to +/- $1.00. I think I'm blowing it though because I get calls from stores because their Accountants want to APPLY this amount and ask 1) which product d…

I have a database (in FM Pro 7) made up of three tables: a Client table, a Source table, and an Event table. The database is a life-history database which produces a life-history timeline for each client. Each individual record in the Event table describes one event in the client’s life. Each event is derived from a single source (a record in the Source table). Each event has only a single source, but a single record in the Source table can be the source for many records in the Event table. (A source is typically an interview or a record, for example a medical record.) I want to define a field in the Source table which I call Source Code. This field will act lik…

Hi I am new to filemaker, I am trying to update qty in stock as I sell items in invoice by press update button -- set field in stock,qty_in-stock calculate result " Extend ( stock::qty_in_Stock )-Invoice::qty" -- only updates 1st entry not repeated fields. stock qty_in_stock is not a repeating field I appreciate your help Thank you in advance MrFix stock.zip invoice.zip

Hi guys, I have a database of invoices. What i'm stuck on is I need to create a total of just those invoices that fall in any given financial year. Australian financial year runs from 01/07/year to 31/06/year (e.g 1 July 2004 to 31 June 2005). I think my problem is text -v- date but can't seem to work it out. I have a global field being the entry of the current financial year. so if( CurrentFinancialYear = Invoice Year; Fees; "") But I can't even get InvoiceYear to be calc'd??? The calc of the InvoiceYear is: Case( InvoiceDate ≥ "1/7/2004" and InvoiceDate ≤ "31/6/2005"; "2004"; InvoiceDate ≥ "1/7/2005" and InvoiceDate …

I made a mistake by not entering serial numbers in my flat database files because I had not yet gotten a grasp on using relationships. How do I go back and repopulate the serials in the records that I've already created?

Can someone please look at this FMP6 file and help me out. I am doing this in FMP 6 because I need to run it through developer 5.5 as I don'thave the upgrade to developer 7 and when I finsih this I need to be able to distribute run time soultion. If you goto the second layout and then sort by Operator then enter preview mode and look under the column for aveverage pieces per machine hour, in the first row I get a return of 28 (expected) on the second line I get a return of 0 (zero) I do not understand why this is not displaying the right number which should be appx. 12 (maybe 13) This is freaking me out, I have never experienced this before. I know I must be …

Hi all friends they (FMI) said: But this: [email protected] is two words and this: libero.it is one word In the first example, with this calculation: MiddleWords (text ; 1 ; 1 ) & "-" &MiddleWords (text ; 2 ; 1 ) I'll give: raybaudi-libero.it Where is gone the "@" ? ( so I think that there are more then two characters (ampersand (&) and hyphen (-)) that identify the beginning of a word; the only one that doesn't is the period (.)) What do you think about ?

i have a field...that contains enough information that it would have to be scrolled through.... it also can't be edited by users... when you go into feild behavior and uncheck edit in browse mode.... you can no longer use the scroll bar.... help please