Calculation Engine (Define Fields)

Is there any way to trigger the validation calc when a user exits the validated field instead of when the record is committed? I validate two year fields with a calc, but the validation doesn't occur until the record is committed, in which case it's not clear which year field is being flagged as invalid. This is esp. true if it's the *first* year field and the record is committed immediately after entering the *second* year field (e.g. by hitting Enter key). I suppose I could specify which field it is in the custom error message, but it would make more sense in the flow of data entry to fix such problems immediately instead of several fields later. decker

Is there anyway of creating a global field that is kept in the database? I currently have someone dedup the database by a number 1 - 20000. But once the database is closed I need it to remember at which number it was at so that it can return to this? Any help would be great!

I have A simple Portal... Two Fields Years and Amount All I need is a script or a calcuation that can add 1 to the number in the above row... Meaning when someone types in the first row the first column will be 1 and they fill in the amount when they go to the second line the year automatically says 2 they fill in amount... I can not use the "@@" text b/c I want to do a look up later... Does anyone know how to do this...or am I doing it all wrong? Thanks Joseph

Ok...I know I have asked this before...but I really need some help everyone... I have two tables (FM7) table one is called "Main" table two is called "Policies" I have a portal on the main page that shows all of the polices for that contact. What I need is someone to show me how to make a script that will open the Policies table...but here is the trick...when the script opens the policies table I need it to keep the same record or relationship to the main page...this way one someone is on a customer and they want to add a policy to that person only all they have todo is hit this button...and window opens and they fill out the information. they do not have …

I have a database with an auto increment serial field. When I try to import data from a tab file. This field doesn't auto increment. It's just blank. Now I have hundreds of records with this field blank. How can I fill this field after the records are already there? Please advise. Thanks

Hello All: I am having a rough day today because I cant figure this out: I have a field in a database that is a text field. It is pulling from a value list of Yes and No. When the user completes the search and the click on a button to start another search, i need to clear the check boxes in the table. They are for reference only. I can get this to happen by using setfield= "". That works well on the first record in the table, but i can not seem to get it to loop correctly and remove all check boxes. Any thought? Thanks Lakota

Hello. What is the way to add month(s) and year(s) to a date. For example: - Add 1 month to a date 5/17/2004; - Add 3 months to a date 5/17/2004; - Add 6 months to a date 5/17/2004; - Add 1 year to a date 5/17/2004; - Add 2 years to a date 5/17/2004; - Add 3 years to a date 5/17/2004. I am adding a number of days (5/17/2004 + 180 (6 months)), but the new date is slightly off by several days beacause of the obvious reason. Thank you in advance for help on this one.

Is there a way to force capitalization in a field? Thanks

I have two fields, field A contains inventory types, field B contains information about a particular inventory item. I need field B to contain a value (not empty) when Field A's content is equal to "item 1" but it can remain empty for any other inventory item that is not "item 1". Could someone please give me some guidance? I've tried several Validation by calculation formulas but can't get it to work at all. Any help would be appreciated.

I'm sure this will be covered somewhere and I would be grateful if anyone could direct me to the correct file or posts. I have a related file with all sportsmen (that's not sexist - they are all men!) list. Unfortunately the file gets large and I don't want to choose a starting letter in a second field to narrow the search in the name field. What I would like to happen is that when I type in the name field, each new letter narrows the names list automatically. Any help appreciated !

I want to sort the database by last accessed records. What sort of field should I add to achieve this? Thanks Simon

How can I duplicate a record and have one of the fields, previously with a value, return blank? I have a field "UnitHinge" that is a Text field->By Value List. The value list, "Hinging," contains "

Occasionally, when performing the following steps, FM blowz up and shuts down. I'm curious if anyone else has/is experienc(ed/ing) this? (FM 7 Developer) ---> Select container ---> insert object ---> select word document ---> paste HTML from website ---> exit/record request wait... ---> BOOM! ?

I'm trying to figure out how to do the opposite of filter without several combined calculations. -need to remove some text from a global field (i.e. 23x 35x 83x (-35x) = 23x 83x) - the text I want to remove is a field on a current record. - its for marking/unmarking records tia

Hello I have a script below that finds the first place that 2 fields in a record are empty. I have my files in list mode and they show up as a kind of report. The Problem I cannot figure out is how to get the cursor to go to the 1st record when it is empty, I always have 200 records to start. The present script below gets the cursor to the right place (the first empty record ) but that is not the case when there are filled in records beyond record 1 and a second empty record was for instance, record 16 , the cursor goes to record sixteen but not where it should to record one. (Because record one is emtpy. ) This is used for an auction and the 200 records s…

Hi fm masters! I have problem with concatenating repeating fields... I have incoming products (one product many factory serial numbers) and outgoing products (same serial numbers like incoming). So i need to display products and their serial number that are still in database. For example: Product one has been entered with next serial numbers A1234, B1234 and C1234. Then we selled same product but only two of them with serial numbers A1234 and C1234. In stock then should be only one product with s.n. B1234. Is it possible to make calculation from repeating field income and outging in other field on exmpl. sum (income-outgoing = sum) which shoul…

Looking up data from another data base with multiple related records is my challenge. My original intent was to set up one database (Location Tracking) for the details and upcoming scheduled changes of advertising for specific locations, and one database (Creative Changes) for entering the creative images/headlines/install dates as they change. I wanted to relate the Creative Changes to the Location Tracking via a portal, but it is impractical since the images take up a bit of room per line item and the portal always adds the next potential line item making the whole location image content reporting layout too long per location. So I would like to just relate …

hi, i'm sort of a newbie (6 months ago, started this program and put it away because i was frustrated). my first question: can you modify a calculation field? as far as i know, you cannot. if so, here's my dilemma: i'm in the medical field and want to create a database for my patients. one field (past surgical history) that i created is a calculation field so i could print out the field horizontally (Substitute(PSHx, "

hopefully I can explain myself.... I was wondering if there is a way to define a number of variables (or number of rows for a portal) based on a result from a field?: I'm working on a database for a m anufacturing sales department and need to set it up so they are force to give a description of an item based on the number of items that they say they are going to sell. (i.e. if they say that we need to cut 5 sinks cutouts for a house, then I need to force them to give model and dimentions informations for each of the 5 sinks. makes sense? the number of rows in a portal that specifies the sinks will depend entirely of the number of holes we have to make.....can this be …

Hello All: I have a database with several tables and a few relations that are doing one thing: Asking the user though drop down menus to select a bunch of criteria for our suppliers. Those drop-downs include a carrier, state, region and speciality. Once those have been picked, a 5th field is populated which tells the user how much money they can spend on a supplier for that criteria. This is piped into a portal that displays all the data related. What I would like to know is if I can use a calculation field in the portal to display only those records that are less than or equal to the 5th field: IE: If you return a set of data that states you can use a Supplie…

As well as Win2K, I use OS 9.2. I frequently transfer stuff to my MAC and back again using ZIP drives or (one way only) CD-ROMs. For some reason I've never been able to fathom, my MAC insists on using ";" as the separator in calculations and my PC uses ",". FMP happily converts back and forth as I move files from PC-MAC-PC-MAC. That was until today! I used a USB Memory stick thingy to transfer a file from PC to MAC and back. The ";" have stuck and my PC FMP wants ";" in that file. It regards "," as errors. Other files are OK. Does anyone have any idea where I might set the separators?

hello there, I've a script with a loop of this kind : setloop = 1 loop leftword ("test",setloop,1) setloop = setloop + 1 end loop if setloop = #whatever.. end loop where "setloop" is a number field. So, Something very classical ! don't bother on the leftword commande syntax ! What I would like to do is the same kind of auto-incrementing of "setloop" in a calc field, but of course "calc field" doesn't allow this kind of recursive loop. I've my nose on it and I cannot figure it out, how to get in the right direction. so, thank you for your help,

I may have asked this before then misplaced it all: How does one set up a field so that when text is entered, it automatically adjusts down, if necessary, to fit in the field box. For example, the description for a catalog item, optimally in a 12 pt. font, might be automatically stepped down to fit a longer description. Thank you

I have a container field which can display a reference to a Word document--right click, Insert File. I would like to click a button (run a script) which would launch Word and load the document. I've tried the Send Event function but it will either launch Word without loading the document, or do nothing. I can't figure it out. Thanks in advance.

Two questions from my experience playing with FMP7--I am a new FMP developer by the way: Q. The Moyer document of hints & tricks (MOYEC49.pdf) claims that field validation occurs AFTER auto-enter calculations, but my experiments seem to indicate otherwise. Who is right? Q. What's the behavioral difference between validate data entry "Always" and "Only on data entry" for field validations? If I choose Always, when do the validations occur? I have a third question unrelated to validation posted in the FMP3 message board too, but I'll throw it out here as well--why would a developer working with FMP3 choose to use GetAsNumber("") to indicate false in numb…

I have read many things that say that using a related file is better than using repeated fields in most cases. So I have stayed away from them (this being my first venture into the filemaker world). But now that I have been working and using the database that i have created for about 6 months, I am having a hard time understanding why the above statement is true. My example. I have a dealer file that list all of the retail locations of our customers and I have a related contact file that holds the people that work at the retail locations and all of their contact information. The way that the relationship is connected is by the dealer number and the city of the parti…

Hello I have a table with 2 fields "Number" and "Controlnumber" I have 200 records in the table. I need to find the first records that has both of those fields empty. I tried to combine 2 IsEmpty statements in one calc but I couldn't get it to work. Help is needed here if you can Thanks

Group: I am using FMP 5.0 Unlimited to hadle my database. I am scanning barcodes from client stations throughout the office. These barcodes Contain exactly 7 characters and all start with "F". I need to have FMP validate the data in the field to make sure it starts with the letter "F". Any thoughts on this? I have been looking at validation for text but have come up with nothing useful. Thanks in advance. Lakota FileMaker Version: 5 Platform: Windows 2000

This is a fun one. Have a text file with 500k of records so too big to separate tabs in excel. And when I import into FM7 i get something like 24 concatenated fields: ACLCPIC acllink 0001 &_PP_ALL F-41 Enter Vendor Credit Memo 0001 &_PP_ALL F_BGGF_BUK ACTVG * 0003 0002 0002 &_PP_ALL F-30 Post with Clearing 0001 &_PP_ALL F_BKPF_BUK ACTVT * 0012 0009 I figured calculations would work to f…

Hello all, I have a problem that I can't seem to figure out. I'm new and having trouble finding the answer to this question. I have a database that contains computer service data. When the machine is repaired, the technician clicks the "complete" button on the form that displays the information for that particular job, which timestamps that particular work order. What I would like to do is click on a button (it actually looks like a tab at the top of the form) that says "complete" and view all of the completed jobs at once. I would also like to click on a button that says "incomplete" (again, one that looks like a tab at the top of the page) and view all of the jobs …

I lost electricity. I had worked 11 hours straight on the design and was so absorbed that I forgot to back up. Now, when opening the file, I get "FileMaker cannot share file because another User is already sharing files using FileMaker Pro on this computer." It works fine in every other regard, that I can tell. But I can't have it doing this all the time! I have dragged a copy of the file aside and have also 'Save A Copy As.' But each time I open it, I get the same message. Rebooting again hasn't helped either. This system isn't networked. Before I start messing with it (because sometimes that can compound a problem), I want your advice. Please help…

Not sure where to put this. Sorry if its in the wrong place. I searched and got no hits so I dread my file is trashed. I have 690,000 customers. Boss wanted them in alphabetic order. I so sorted then exported them, deleted all records, closed the file (and it say it was rebuilding blocks or something). I then imported the data back. Now, ever since I did that, every time I close the file it says it's scanning for unused blocks. It never did this before. It is slower than before - before I put them in order. Did I hurt my database?

I have a file (called IndividualEventRecords) whose records are created through portal entry inside of several other various files (Timecards, DailyJobReports, MeetingReports etc). Is there a way to create a field that will self generate when the portal record is created that will then tag the record to indentify what parent file the portal record was created in?

Is there a point of no return with the usefulness of field indexing? What if I just index every field -- I have done this in Orders and ended up with a 700MB database. Will I receive a speed hit from the sheer bloat of the file and having o to reindex a lot of fields that cancels out speed gains from indexing? If so, what is all the criteria I should use when deciding to index a field? Thanks for your input.

Can anyone help with a calculation? My current formula is total cost is : (quantity/amount basis)* rate * distance. But if my total cost is less than $10.00, I want the value automatically to be entered $10.00. Obviously, if zero, it will be zero. Thanks Essenceprt

I have a flag that should be set to yes if a job status is "NA" and the current date is within 15 days of a requested date (Estimated Delivery Date). The flag that I am setting via the calculation is also the "key" field in a relationship to another file where a user can view all exceptions. Any ideas on how to make these two mutually exclusive uses jive? Thanks

Hello; I currently have a product database (photo catalog) and I'm having a difficult time using string functions to create a calculated field based on the 'File Name' field. I've named the product images with the product number (ex. rh0001.jpg). I'm trying to calculate the 'product number' field by stripping the .jpg from the 'File Name' field (ex. rh0001). I've tried the formula: Product Number = File Name - Right(File Name, 4) and I get 0001 as a result. Does anyone know how to just strip the file extension from the File Name field? Thanks in Advance for your help!! Rick

Is there any way to compute mode median on FMP.

Is there a GetRepetition equivalent for portals in FM 5.5? I'm trying to get the substitute function to find strings from several related records... For example, I have a long list of museum artifacts in a regular field called 'Artifacts' in a database named 'Museum'. I have a portal that contains related records from another database called 'Special' that has the names of each artifact in a field called 'Name.' Based on a relationship between 'Artifacts' and 'Name' in the 'Special' db, I have a portal in 'Museum' that shows all related records of 'Artifacts' that have a corresponding record. My problem comes from the next part. I want to have a…

I know this has been covered somewhere, but I can't seem to find it. I have a field that is called Homework. I set it to a check box with all the homework that we have. So if this student bought homework 1, 2, 3, then I would check the box. But this student A has a brother, which has another fild called "family". Well, mothers don't want to buy two sets of the same homework for their kids. So, I am trying (unsuccefully) to have a lookup, I should say a refresh, that will show the homework that other family members have bought. I have a relationship from "family" to "studentID" fields and I have set the the "homework" feild to do a lookup using that relationship. It is ok,…

Hi All, I have something like this ... Total Money = km * $0.80 for all old records. If i want to increase 80 cents to 1 dollars and i want to keep old records as 80 cents ... just for new records are 1 dollars. It means for new records Total Money = km * $1. And so on if i want to increase 1 dollar to 2 dollars and also want to keep olds records. I don`t want to use look-up since look-up in portal sometimes it works sometimes does not. Any help is really appreciated. Anh Tran

I am converting a FM5/6 database to FM7. In the original I have a Calculation Field (Times used) that gets the "Count" of how many times a serial number is in a field (Serial Number). When I converted that one Database the same calculation works. This is the calculation of the converted file. "Count(Serial Number of Software::Serial Number) However, when I try to recreate that calculation manually in the new database it does not work. When I recreate the calculation manually it ends up looking like this. "Count(software::Serial Number)" The problem is in the new database it always 1 no matter how many time i duplicate a record. I…

Hi everyone I am a newbie to FileMaker, so please be patient with me if I am not clear in the way I am explaining what I am trying to do. I am attempting to create a database that will accept accommodation bookings and want to have a field that will calculate the number of days that will or have elapsed between dates, for example. Field Name = ArrivalDate (Displays 3/05/2004) Field Name = CheckOutDate (Displays 13/05/2004) Field Name = TotalNights (Displays whatever the calculated number is). I imagine that this a fairly easy thing to do, or has already been done before, but I just don't know how to get my head around it. Thanks HeatherG

Hello to the community, I'm brand new,so this is my silly question do Filemaker support the condition 'WHERE' in a query? If not how can I do to SELET * FROM mytable WHERE myfield LIKE 'mystring' ? Thank you and sorry....

I need some real help...In more than one way... Here is the situation: I have a pull down field that automatically fills out address, phone, contact etc... information automatically. Well we also use this field to do searches for that company name...I need to make that field lock after the orginal input is done...but still have the ability to be made searchable...This way the other people in the company can not mess up the data base by forgetting to hit find before they use the pull down menu...When they do this they change the company for that contact... not good. Is there any way to make a field with a pull down menu have information that can not change after t…

I have a very simple question.....I think...but yet I still do not know...So I guess its not so simple... I need to make a check box have a value...meaning when it is checked the value in that field would then be "1" or "0"...But not seen all you see is the check box... All I can get is a checkbox to be checked or not checked...but with no value? Can anyone help...

I am trying to figure out a way to send the jpg in a container field as an attachement to an email. (The "attach file" button only allows you to select a file on the harddrive to send.) Can anyone think on a way to do this?

Hi evry'body! I

Does anyone know if there is any after market plug-in that can enable "type-as-you-go) technology? I have used the Clairvoyance script that is available in Scriptology, but I have found this to be impractical inside my organization. Frankly, I am shocked that Filemaker has not incorprated this into version 7. It would be such a huge help in cleaning up naming conventions that drive so many look-up fields, relations, etc. Any help or suggestions would be greatly appreciated. I have been tasked with cleaning up the naming in our database and I can't seem to get people to use Clairvoyance properly. I know, I know, that is a management issue, but welcome to my …

Hi all, I am trying to put together a calculation that, based on the students grade 9,10,11,12, determines the year of graduation. It of course depends on what month it is. This is the start I have. Hope someone can give feedback to a novice. Thank you in advance. Case(student::grade =12 & Month (g_current_date) <= 6 calc_year & Month (g_current_date) >6 calc_year +1,

Hello I have a situation where I have to send a 6 digit number to a company to be processed by email. Some of the file may have only 4 or 5 digits it which case I would automatically like to add a zero before the number. Can this be done with a calc? Thanks STAN

Wow you guys I hope this is an easy one Here is the set up: I have fields that I can enter information in these fields are formated for Numbers ($ & 1,000 seperators)...This is great...But when I bring these same field in the form of <<amount>> to my report they change into percentages (%). Why and How can I stop this...I can not make just fields on my report b/c there are in a paragraph. This is a huge problem for me. I have come up with makeing these field just text fields and that works fine. But what a pain to enter information and also have to formate it yourself....Very slow.. Thank you FileMaker Version: 6 Platform: Wi…

This is probably an oft answered question, but the searches I've done have not located an answer... Is there a straight forward method of having FileMakerPro5 display all checkbox selections? I have a registration form/layout where I'd like to use a few multiple selection fields, for instance; Attend Gathering where I would use a Value List that would include Thursday, Friday, Saturday, & Sunday. On another form/layout I would like to list folks that have registered and show which days they plan to Attend the Gathering. Just using the field for the Attend Gathering (field) checkbox only displays the first selection made. How can one display all se…

Hi everyone... Simple Setup: Customer Name, Address etc.. Each Customer page has 5 tabs on it (Policy 1, Policy 2, Policy 3 etc..) Each Policy # has several fields on it (Policy #, Amount, Purchased etc..) I have a report that recaps all of the Policies (Policy 1, Policy 2, Policy 3 etc..) But some times there is a need (want) not to show a Policy (and all of its fields..) is there a script that I can do to make certain policies not show up...Maybe a check box on the coresponding tab (Policy 1, Policy 2, Policy 3 etc.) that I can check so it prints on the report (If not checked does not print)... Expanded Detail on Fields: Tab: Policy 1 Fiel…

Hello everyone.... I have so many reports I think I am going to die....Here is the funny part...They are all the same except for the fields...ie: a report may have a field for Policy 1, a second report may have a field for Policy 2 etc.... Is there a way to make a report use any field name (Policy 1, Policy 2, Policy 3 etc...) this way when there is a correction on a report all I have to change is one of them not many....

Hi there, I see in another kind of Dbprogram, the possibility to do, a grey field if inactive, and white field if this field contain text or whatever. Like if the field is not used or didn't have any data, keep gray. When someone put some date on the field, the field are @on@, like white background and black text. I try to find a way to make it work on a Database in filemaker 7 with 23500 average record, so i try to find a way to keep the Database keeping going quick. I hope everythings is clear, thx fred

Hi, Sort of new to FM. How do I create a unique key out of more than one field? The problem; I have field 1; the ACO's in multiple buildings, and Field 2; the buildings. The ACO's may be duplicated over building's, but the concatenated key; ACO|Buildings should be unique. How do I accomplish that in FM7? Thanks, Jerry

Okay I am so frustrated right now! I have made several databases over the last few years and just last week my boss informs me I have been doing them all wrong. Now I am self taught and my databases have all been working but I have never used the Auto entry function. My boss says I should be using it for all prices that way if and when we update them we won't affect all the previous invoices and calculations. We are talking about alot of prices. so do I really need a separate field for each price and in the auto entry data field put the price? Is that the right way to do it? I tried it with the new billing database I am building but now my calculations aren't worki…

Let me first apologize for what are problably very beginner-esque questions. I've been working on this invoicing system for two days and my learning curve is painful (I've never used FMP). So here we go: These invoices will include a list of the tasks I completed and how long each task took. Obviously, there will be a different number of tasks performed each month. 1) How can I dynamically add or subtract fields to each individual record, depending on how many tasks I performed? 2) Once created, how can I dynamically place and size those fields, depending on how much text they contain (much like the way tables in an html page behave)? I've attached a .…

It seems so easy... I have a list of theaters, each of these theaters is in a district ("downtown," "suburbs", "northeast," etc.). I want to export a list of these theaters and showtimes with the district header, but only if the header is necessary (I dont want the header to repeat). i.e. this is right: DOWNTOWN theater 1 movies info etc. theater 2 movies info etc. theater 3 movies info etc. SUBURBS theater 1 movies info etc. theater 2 movies info etc. theater 3 movies info etc. this is NOT: DOWNTOWN theater 1 movies info etc. DOWNTOWN theater 2 movies info etc. DOWNTOWN theater 3 movies info etc. SUBURBS theater 1 movies in…

I'm trying to find an daily balance average. I want to count how many unique days are in my find. For instance I have a find made up of 6 records. Out of the six records there are 3 unique days. Jan 1, 8, 22. I want to be able to use 3 in my average calculation SumLineItemTotal/UniqueDays Can anyone clear the cobwebs? Thanks! Cin

Hi! I created 3 global fields: 2 Text (pop-up menu with value list) and 1 Time. When I enter data on any of them the same data does show up on all records as a global field is supposed to work... However, in the rest of the machines on the network (all Macs with 0S 9.2.2 and using FM server) the changes on such fields do not show up... The change is only reflected on the individual machine where the change was made. I tried quiting FM server and opening the db from one of the machines as the host (I thought it was a FM server issue where it wasn't sending those changes) and then having all other machines connected to it but same thing... What's the solution…

Hi I have a summary field which is a total of a calculation field. The summary field only updates after closing the file and reopening it. I tried changing the storage options but I get a message telling me I cant change the storage options as the calcultion is based on a related field ( which it is). any ideas? thanks

I experimented briefly on my trial version to see how the new feature of inserting files into container fields works. It seemed pretty easy but I couldn't work out how to open the files once inserted in the field. I'd imagine you could do this perhaps with a script linked to button or something?? Can anyone point me in the right direction? Also, for storing multiple documents in a single record I assume you would use a repeating field? Any tips? FileMaker Version: 7 Platform: Windows 2000

I have a grand total for each customers order for each record. But now I want to also have a Supreme grand total of all of the totals in every record add up into this supreme total. is this possible ? Does it involve the summary parts ? I can not make heads or tails of the summary parts and if anything that they do.

I like the new ability to (at layout level) provide Undo to people. Too bad it wasn't at the field level (or is it?). I use Ray's Audit log for 7. It somehow tracks each field change (i can use it but don't really understand it). Why can't that information be reversed to provide our guys with a revert ability at the field level? Audit logs capture it? Why can't they be used to put it back? Maybe even several levels. Pete FileMaker Version: Dev 7 Platform: Windows XP

New to FileMaker - trying to calculate fields based on two variables: for a school math assessment database I want to set some fields that will return certain numbers if two things happen - if the year is "xxxx" and if the grade level is "xxxx" then the certain fields will equal specific values. I started with a Case calculation for each of those certain fields, but then I realized that those results would only be good for one year. I didn't know how to make the results be possibly different in different years. If the Benchmark Level is gr3, then Number Sense would be equal to 6, but how would I write it to be if the year is 2003-2004 and the Benchmark Level is gr3, th…

Hi, I have 2 DBs: Contacts and Groups. In Contacts DB I would like to collect in one field all GroupNames of the Groups the particular person belongs to (separated by break). Is it doable? Thanks.

To export my data to the web I need to substitute: ' with ' example: I'm Michele, becomes I'm Michele. Apparently filemaker doesn't understand my calculation: Substitute(detail_user, "'", "'") Because nothing changes. How can I make this calculation work? The version I'm working with is FM5.0. Thank you for reading and eventually answering my question.

I have a situation where I think the best solution would be to use a series of repeating fields. After searching/looking through many posts here, it seems that there is some sort of resistance towards using repeating fields. I have two fields (actually about 10 but two will suffice for now) with 10 repetions each. fieldA can have one of 20 different values fieldB is the dollar amount associated with the value in fieldA What I want to do is for each different value in fieldA have a calculation field with the running total(sum) from fieldB. fieldA...........fieldB rep1 bbb.....rep1 10 rep2 aaa.....rep2 20 rep3 ccc.....rep3 25 rep4 aaa.....rep4 20 …

Hello there! I bit of puzzle and perhaps some of you have dealt with this issue. I have a container field that hold "my_file.exe" and going to that field or selceting works great= executes my file.... now, I would like to execute this file with some triggers/paramaters that I stored in text field. --------------- container_field: "my_file.exe" paramters_field: "-s/g-t" ---------------- C_compound_field: container_filed&""&paramters_field =============== stored as text or containder or :?? The goal is to execute my_file.exe -s/g/-t at ones. Am I apporaching this all worng? Send Message does not apply as I need the .exe file to be stored in …

Hello, I am trying to have a price looked up and automatically filled in to a sales record in a portal. I have attached a graphic of a simplified version of what I want to do to help explain. I basically have four tables, a list of products, a price chart, a client page and one to record all sales. When inputting a sales record I want the price to be looked up after selecting the appropriate currency and product name from pull down menus but I have so far been unable to get this to work. I would be very grateful if anyone could provide any example script or suggestions as to how to do this as it has been giving me a headache for some time now. …

Hi I need a calc to give me the week number preceeded by the last 2 digits of the year ( 2004 =04 or 2010 =10 but the catch is that I need the week to be from each Wednesday through Tuesday and change dynamically. The field for this is called Weeknum Not sure how to do this? Any and all your thoughts and expertise very appreciated Dave

Ok, so I am fairly new to FileMaker, but so far have had great succes in creating a database to manage a create orders for my business. However, I have run across one small problem with Get ( TotalRecordCount ) I have defined a field to assign each order a unique number using an auto-enrty of the calcualtion Get ( TotalRecordCount ). This ensures that each new record is assigned a unique number when it is created, based on the number of records in the table. It works fine as long as I am browsing ALL records. But, if I am looking at a found set and create a new record, the "total record count" is one less than it should be! For example: If I have on…

Can anyone help? I need to change a field that was previous defined and used as a repeating field to a single text box. How can I do that and retain the information entered into the repeated field lines into the redefined field? Thanks

How can I Calculate that??? ( the result is in field "Active & Inactive" ) 3 Field Group Active or Inactive Active & Inactive 10 Active 001 Active 001 Inactive 001 10 Active 001 Active 001 Inactive 001 10 Active 001 Active 001 Inactive 001 10 Inactive 001 Active 001 Inactive 001 10 Inactive 001 Active 001 Inactive 001 10 Inactive 001 Active 001 Inactive 001 11 Active 002 Active 002 Inactive 002 11 …

I have put the following into a calculation: Year ( Get ( CurrentDate ) ) & Case ( Length ( Month ( Get ( CurrentDate ) ) = 1 ) ; "0") & Month ( Get ( CurrentDate ) ) & Case ( Length ( Day ( Get ( CurrentDate ) ) = 1 ) ; "0") & Day ( Get ( CurrentDate ) ) Since today's date is 4/29/04, I'd expect the result to be 20040429. FileMaker returns: 200404029. I have checked that the result of "Length ( Day ( Get ( CurrentDate ) )" is 2, NOT 1. What am I doing wrong? I am running FileMaker 7.0v1a on a dual gigahertz Macintosh G4 running OS 10.3.3. Thank you for your help.

I've come across a function that must be in FM but I can't seem to find it. In a layout I have three fields for the creation of an unique order number an dthe fields are; 1 the year field 2 digits 2 the week field 2 digits 3 the order number What I need to get working is that the year field gets filled in automatically only with the last two digits of the year. The week field has a brother with which I want to reset the number field (3) after every week, so I made a check field with the 'WeekofYear' function but this field needs to be refreshed every now and then so that when the week changes the number field gets set to zero and starts counting again from…

I don't want to turn indexing off but I am unsure how indexing works in the background. Does it keep information from a long time ago indexed even if it doesn't exist anymore? I have a group of databases that are extremely slow on the server (lots of records, lots of indexing). I am just wondering if it is possible to clear the indexes in the background or to clean them up. Could indexing slow down the databases like this after time? Is there a program I need to view this kind of information? Thanks! Marcelle

Repeating fields are much maligned, mostly for good reasons... So I thought I'd post a vindication of two potentially useful contexts for them (beyond storing global graphics, and other uses I've seen experts recommend). This is partly to see whether you all can set me right before I become incorrigible. (1) Data-entry and display convenience for multiple items from value list: I have an academic feedback database in which there is freeform text for prose comments, but also a repeating value field for "boilerplate" comments: explanations of standard grammar problems, observations about style or structure problems, etc. Students who get these comments recognize them …

Did you know that containers can have 4GB of data. Where as other fields are 2GB

Can you use Container fields in Labels. I tried and it was blank in preveiw mode, and browse mode.

Hi there- Although I've used FM for several years, I've never progressed beyond the pre-scripting (and other bad*** stuff) level. I've tried searching for the resolution to my problem, but part of my problem is I'm not sure what the term is for what I want to do. I'm not sure if this is a relationship issue or something that can/has to be done via scripting. In a nutshell, I'm looking to have certain fields (containing a static menu list of options) "auto-input" based on the manual selection of another field (also containing a static menu list of options). So basically: So basically what I want to happen that if I selected something from Menu B ("Ba…

I have a timestamp field that is auto-enter upon the commiting of a record. What i need is a field that returns the previous day of the record. Not 24 hrs. If someone commits it on 4/28/04 at 12:01 AM, then it should say 4/27/04. I looked through the date functions and didnt see anyway to extract the date from a time stamp field so i used: LeftWords ( timestamp ; 1 ) this returned the date of the timestamp value. So, i added a - 1 to the calc. Leftwords(timestamp ; 1) -1 But this gives me a ? in the field. Oddly if i create a two extra fields (three total), i can get it to work: "Timestamp" ; timestamp format ; auto-enters timestamp "Ext…

I hope this is the forum for this question. I'm having difficulty resizing groups of fields. I have no difficulty resizing a field with the object size box. the trouble is, I can't seem to resize multiple fields. Several fields will widen to the new measurement while others will widen slightly. I'm not sure what I'm doing wrong. Any help would be appreciated.

I'm trying to add sequential numbers to a document. The numbers need to go from 0001 to 9999. I have the numbering all figured out but, I can't figure out how to make the zeros print without adding a decimal point. (Ex; 0001, 0002, 0003 etc.) On the Mac I changed the field to format as decimal and set the fixed number of decimal digits to 3. Then I deleted the "." from the decimal separator box. Not very sophisitcated but this worked fine and just left a small space where the decimal would be but, when I view and print the same file on the PC a small square appears where the decimal should be! Can ya help me out??

Dear FM'ers, Does anyone know if it's possible to create fields in a new database by importing them? For example, I have a spreadsheet that contains a row a column of data and I'd like to import them as "fields" into a new FM Pro database (i.e. define the fields via the import). Thanks much, Rush

How do I do incorporate number ranges into a calculation? For example, Score = 15 to 25, Result = Advanced. I'm stuck! Kate

Howdy all: I am trying to get filemaker to validate a set of fields: Reason1 Reason2 If reason1 is empty, then reason 2 should have something in it, but both can not be empty when the user exits the record entry. Any thoughts on that? Thanks in advance for your help. Lakota2k

Please pardon the length of this post, but I

HI there...! (sorry for my bad English) I have G4 450 with 1Gb Ram and A Raid 0 Disk (5 Scsi Disks 10.000prm) I have a very good X icons collection (About 12.000) I developed (!) In Fm 7 a file with 2 fields 1) icon name----text 2) Icon --------container In the beginning (when I import (not a referense) the Folder with my Icons) the import process is fair good -about 15 icons/sec - after 2000 icons the performance was 5 icons/sec after 6000 icons the performance was 1 icon/sec after 7000 icons the performance was 1 icon/2sec after 7500 icons the performance was 1 icon/10sec ...wow...! Then I try several things like to put 1000icons/folder... nothin…

Hey Everyone.... I have a simple (yet I have no Idea) problem... I have a current date field <<Current Date>>...In all of my reports...But when I go to print them or even view them the date is not the current date...I have tried to refresh with a script that does not work...but when I go to define fields and look at it then go back evrything is correct for that day...but then again it will not change the next day....HELP

Hi I have a text field called "temp" it has 2 lines or pne paragraph return How can I remove the second line only in the field "temp" Thanks FileMaker Version: 7 Platform: Mac OS X Panther

I created a value list of State names ( Kansas, Missouri, New York) and need to change the text field to the State abbrevation( KS, MO, NY,....) I've changed the value list for future entries but need to change all the records existing in the current db. I got it to change one State name but the others...

I have a question about how unstored calculation fields work. Do unstored calculation fields take any storage space in the database or hard drive? Are they only stored in RAM on the clients computer. Do the calculations evaluate at the moment they are displayed on the screen. Does FM Server (5.5 or 7) store any of these unstored calcs for faster access. Example: I have an unstored calculation field 'graphicDisplay' that displays a graphic, depending on what the value in another field 'option' is (it can be a 0 or 1). I toggle 'option' field between 0 and 1 with a script button. I pull the graphics from a global repeating field 'graphics' to the 'graphi…

I know this can be a newbe question, but it will help me. I'm trying to create a secuencial numeric field that is increased in 1 in every new record, and it comes to 1 whith the new year. So, it will be: 2004 1 2 3 ... 2005 1 2 3 4 ... I've read in other posts about a relation and a global field, but I don't get it. Could somebody help? FileMaker Version: 3 Platform: Windows 95/98

HI All, Cyborg Sam was great in helping with my last problem so now I'm wondering if someone can help me out again. I have a database with 10 fields each of which have a drop down list of several different options. What I need to do is create a field so that I can determine how often an occurence of each type occurs. Its a little hard to explain in text so I've attached a mock up of the database. I understand that the database could have been designed better but I'm stuck with it!! Many thanks for your time. test database v4Copy.zip

Hello People! Perhaps a dumb question but how to get arround (be able to) enter into g_fields in Find Mode? to be more specific I am working on DateRange calculation and significant fields are: ---------------------- MyDate -date g_StartDate - global as date g_EndDate - global as date ---------------------- the idea is to use 'the range' script: ----------------------------------------- Enter Find Mode[] InsertCalculatedResult("REL::MyDate","DateToText(REL::g_StartDate)&"..."&DateToText(REL::g_EndDate)") ----------------------------------------- and then perform the find.... but the problem is that I have more than just date fi…

I have a date field which is a projected project end date. I have a calculation which calculated weeks to that end date. I have a 2nd calculation which highlights the row a color depending on how many weeks are left. My problem is that we allow projects to not have a projected end date. Both the records that have "0" weeks left (Basically this only applies to records with projected end date equalling current date) and no date are showing the same status. I would like the records that have no date to not have any row coloring. Is there a way I can differentiate "empty" fields vs. "0" fields. Cheers. Michael FileMaker Version: 6 Platform: Mac OS X Pa…

I am trying to make a field required but only if the value of another field is 'x". Scenario - this is an issues submission form for production support of a much larger enterprise application - the field in question is "Description of Requirement". This should be a required field only if the value of "Issue Type = Enhancement". I am a beginner, sorry for the ignorance. Thanks in advance. Jam FileMaker Version: 6 Platform: Windows XP