Calculation Engine (Define Fields)

Hi There I have a multi user database that has been working fine for years, however I have just added my new MacBook and seem to have a date issue only of this machine - The problem seems to coincide with arrival of my new Macbook or in the installation of Parallels Workstation software. I use a global field which is refreshed via a script with the system current date on login, however on my Mac only, the date is entered in a US format instead of UK. All the regional settings on my Macbook are correct & I have tried looking at the use system format setting. Other standard "auto enter" date fields seem to work fine, just the global script updated …

I have a checkbox and boxes 1-32 i need to seperate the checked items so that one data item goes into one box.I have this done but i need to change my script so that the data items goes into a random box.

I'm new to relational... so please forgive. This is probably an easy one. I have a table, TEST REQUIREMENTS, and each record has a field called "Type" (say... types A, B & C) I have a table, called TESTS. Tests can only be of type "Type" A, B & C. So, when entering a new record into TESTS, I select Test Type... but then when it comes to what requirements are covered by the test, I want to limit the user to making choices from the TEST REQUIREMENTS table of only the matching type (e.g. A, B or C) I understand how to make the relation between Tests and Test Requirements. I do no understand how to limit the relation to a matching type. Any ideas…

Is it possible is to disable the Revert Record Option when validating a field and the validation fails? I want only to allow the user to go back and correct the field and not Revert. The reason I would like to do this is I had to setup to only save record by a record exit commit. The problem is when committing the record if one field is not valid and the user chooses to revert record option it will revert all changes in the record since last save. I tried doing Commit Records with the Skip Data Entry Validation but it still runs the validation (not sure why) if that would work I thought maybe I could do the script with two commit records: once skipping validation an…

Hi, I have never really dealt with container fields before and I'm having some problems understanding how to insert pictures into a repeating container field. I want to insert 3 pictures, a red box, a yellow box, and a green box. I have a To Do List, and want to display a certain picture next to (or within) the portal depending on when the item needs to be completed. I created a new repeating field in my To Do List table, with 3 repetitions. Do I need to put all three pictures in each record, or do i need to make a seperate table that just has one repeating container field? My main problem, however, is that I can't figure out how to put 3 pictures…

I need to have a calulation that will return a value of "0" if the read value is -.25 or less, but then display the total values after this amount. ie: Employee gets 15 minute break paid. Any time over the 15 munutes will be deducted. My atempt at this, though I know it is not correct: Break 1 grand total = Break 1 total If(Break 1 total < -.25, 0)

Alright, I'll try to make this brief and to the point. Three tables. Royalty DB. Table 1...Project Table 2...Tracks (ProjectGroupSubtable) Table 3...Group I want a calculation which summarizes the number of tracks by a group on a certain project. (This will then be used in a seperate calculation to figure out royalties) Right now whenever I try to use Count(field) it counts tracks by a Group over all the projects instead of just one. I've read about using sub-summary parts, but I'm under the impression that these wouldn't fit my situation, am I wrong? Thanks! jon

I have a container field that I put a 400 by 400 picture into named RV5000.jpg I want to have a script or automatically duplicate and resize that picture into another container field as a 200 by 200 picture and rename it RV5000_medium.jpg Any suggestions?

Is there a way to quickly clear an entire global repeating field that does not require each repetition to be deleted? I am currently implementing a set of back/forward buttons in a database using a global repeating field of an arbitrarily large size. Since these type of buttons act as a stack, I tried to implement the functionality as one would normally use via an array (i.e each new page visit yields a push on the back stack, clicking back pops the value off back and pushes in onto the forward stack). Since FM8 supports accessing individual elements of a repeating field dynamically (I have done this in previous versions of Filemaker via string operations), using a …

I have an existing contact database where the address is broken into 8 seperate fields. Can anyone help me combine these into a single field? I tried digging through the FM8 Help section by searching "concatenate" and "append" too, but didn't find anything to help. The fields are as follows: House_number House_suffix Direction_prefix Street Direction_suffix Street_type Unit_type Unit_number An example could be: House_number = 275 House_suffix = -1/2 Direction_prefix = West Street = Riverdpoint Direction_suffix = Street_type = Cir Unit_type = Unit_number = Another example: House_number = 1136 House_suffix…

I am working on a POS system and when the user is in a particular window I need them to be transferred to a login screen if the computer is idle for a specified period of time. Is there a way to do this in FM8?

Would someone please take a look at the attached db and give me some guidance on why the field "State" is not functioning properly. Thanks GRH_Contacts_v3.fp7.zip

Is there any way to isolate the pixel dimensions from a GetAsText ( Image ) string so that they can be used to plug into html code? GetAsText ( Image ) produces something like: size:501,341 image:My Images/picture.jpg imagewin:/D:/Database/My Images/picture.jpg ...whereas html requires syntax like: height="341" width="501" ...so if I could isolate the height and width dimensions into individual calculation fields, I might be able to plug them into another calculation that generates the body of a simple web page for all the images of a given set (see my previous question). I might have a hope of solving this myself, but am stumped by the variablene…

ok i have a checkbox of names, and 32 boxes when i click on a name in the checkbox the name enters in one of 32 fields currently using the auto enter function. I was wondering how could i change this to make the box the name goes in random.

I am designing a POS system and the technique that I am using to create the "order entry buttons" is way too slow. It is currently unusable. It takes several seconds to add one item to an order. My computer is pretty ******* fast (faster than the POS computer that we have purchased) so I am really screwed unless I can come up with a faster implementation of this design. Here is my current test file: http://billbe.com/POS_SpeedTest4.zip

I realized I made a mistake posting to this topic. I should have created a new topic. Many apologies.

Hello All. I'm sure some of you will laugh at how easy this question is to answer, but I've been having a hard time with it. Rather than go into the intricacies of my particular data, I'll use generic terms that should be comparable. Let's say I have two tables: Table 1 contains only employee ID numbers. There is one and only one record per employee. Table 2 contains one record for each sale. These records contain the employee id number, the amount of the sale, and the region. Because employees make many sales, there are lots of records per employee. What I need to do is create a field for each region for each employee, then total the sa…

This seems elementary, but I can't find anything about it and have tried every combination I can think of. I've got a field I want to trim, perform a Let function in and have text "Wrong Format" in the field if the user doesn't enter the correct info for the Let function. In what order should these steps be performed? I would think in as I've listed them, but can't get it to work. Should there be a Remove Text or Reformat Text in there somewhere? Is there a guide somewhere that shows the order functions should be performed? Thanks.

Hi, i have a solution with a STAFF lookup table that includes the info for all of the staff. The staff names will need to be entered into several of the tables throughout the solution. What is the best approach to take to allow a user to select a staff name for a field? I would like to have a small "Browse" button next to the respective field that will allow the user to choose from a staff name in the table. I currently have it set up as a pop-up menu that displays the first and last name fields from the STAFF table, but not sure that i like this approach. There are about 100 staff members. I will need to store the STAFF Id number in the parent records Tha…

I have a field that shows the current date on creation (via Auto-Enter), but I want that field to always show the current date. So, when tomorrow rolls around, I want this field to show that date. Any tips? -Conner

I'm using FM Pro 8 and have DB's hosted with FM Server 8 on a Powerbook G4 using OS X. I have a job DB that's used for job tracking, providing approval process, etc. Up to this point all job materials (Press releases, brochures, etc.) have been stored on a company server and users must access FM DB for current status, sign-off, etc. but access materials on server. I would like to start adding these files (mostly word, pdf, etc.) directly into FM DB so that all materials are easily available. I understand I can use a container field to store files but need suggestions on whether to store file or just reference. If I use the "Store only a reference to the file"…

HI. I have a layout with a portal with several number fields from a related table. I added summary fields for each column just beneath the portal. when i enter data into a portal field sometimes the summary field does not update with the new total until i click in it, sometimes it becomes blank until i click in it and sometimes it calculates correctly. Is there a better way to get the total numbers for the number fields? i am not sure what would cause the summary field to behave this way.

Just curious. Say i have several fields in a record. and i ONLY want a field called "Price" to have a color of yellow to highlight it if and only if the user selects "YES" for the field called "Charge customer" So what i want is the color to change, if the user selects "No" for charge customer, the background is say white for the price field. But if the customer selects "Yes" it will automatically highlight the field for price

I am trying to flag an event every quarter. Filemaker finds the most recent event using max function and using month function calculatest the month. eg 6/10/05 becomes june or 6. Now I want to add 3 months and get 9. Can I convert the 9 back to september with a function or do I need to lookup a table of months and numbers 1 jan 2 feb etc.

This is bound to be on here somewhere, but I can't find it after doing several searches. How do I get a zip code field to produce XXXXX-XXXX if the last 4 digits are entered and just the first 5 digits without the - if that's all that's entered?

Not sure if this is correct forum, but im having a hard time understanding a FM concept. What i want in my solution is the ability to prevent incomplete records from being added. What i envision is a "Submit/Commit" button that a user would press when all the information for the record has been entered. if there is any data missing or invalid, a message would relay that info. Since FM commits a record's data after it is added to a field, how would this be handled? I understand that i can set validations for every field, and i assume this is how i would handle this, but it seems like a lot of error messages can be generated if many fields are required and it…

I have a calculation field that will only display the final number in it's whole amount when there is only a whole amount. Is there a way for filemaker to display my muliplied amount to include .00? ie. $200.00 For now my calculation is as follows: Total= quantity * service rate

I have a database with the following fields: isbn location qty For each isbn their are 3 locations each with different quantities. This geographic info needs to be imported into another database by quantity. So that the lowest quantity location is used first. I have a scripting solution that works but it is very, very, very slow. Can anyone take a look and see another way of doing it? location.zip

I have a text field with a 60 character limit. Is it possible to create a calc field that will show how many characters are remaining as a user is typing into the text field?

I am helping a friend and got stuck. please help. This is what I have for a total break time. I need to have 15 minutes (or .25 of an hour) to be the starting time. So, the employee is allowed 15 minutes but gets docked after this amount. I am looking for the total over 15 minutes. Round(Hour( End Break 1 - Start Break 1 ) + Minute( End Break 1 - Start Break 1 ) / 60 - Lunch fake,2)+If(End Break 1 <= Start Break 1,24,0) Thank you, Don

When I open a new record I need to be able to have 2 fields automatically enter some pre defined data. Some of the data may be a date range and sometimes just some plain text. Hope someone can help me to do this. Thanks Martin

I think i am missing something obvious, but how do you set a field so that it must contain a specific number of characters? i.e. only three digit numbers?

I want to change the color of a time field based on it's running total value. I have a container set up with 5 different colors. I have a running total of time field set up to add the time it takes to get a days work done. I want the colors to change as the alloted time gets closer to the end of day. There seems to be a problem with the cal for anything over 4 hours. Is there something I need to know about adding time together?

I use scripts to enter boilerplate text into Invoice fields, similar to Quickbooks Items. The problem is I need to be able to reduce font size for certain portions. It is, of course, text only; I wish I could use HTML tags or something, but there seems to be no way to adjust typesize in Scriptmaker. I've been trying to use Insert Calculated Result>Specify Calculation>Replace(text,start,size,replacement text) But I think I need more training. Help! Anyone have an idea? Maybe there's a better way to accomplish this?

Say i have a number of member records, and each person is assigned points. If i had a field called ranking is there anyway to set it so it would tell me there ranking based on points. For the example the person who has the 10th highest amount of points,there ranking field would set to 10th.

I am trying to set up a cal that will tell me how many hours of work I have in a given day. My fields are defined as follows: Due date of Job; Optimal manufacturing date, which is 7 days before the due date; Amount of time required to manufacter the job. So what I need to do is find all the jobs due on a given day and add up the hours and compare the result to the available hours in a day. Sounds simple, but I would like to be able to see capacity for a longer period of time. So I would like it to calculate as I enter new work and as I get close to capacity, give me feedback indicating that.

How do I keep a running total of numbers. I have records that have units. i want to keep a running total of the units as they are entered. I do not need to display the result, but I want to use the running total in a calc that reflects capacity. So if I have 3 records whose units are 1, 3 & 5 I want the second record to know that there is 4 unites and the third record to know there is 9.

I am making a database for purchase orders - my problem is that i am moving from a manual system to an FM system I have 4 main suppliers and each one of them needs to have thier own serial # for thier orders. Example if i have supplier A, B, C. I would need to have order # A-1,A-2,A-3 etc.. B-1,B-2,B-3 etc... C-1,C-2,C-3 etc... How do i write a calculation that puts the correct serial # for Supplier A, B, C. I have tried many ways and i cant get it to work Thanks for your help

how would i set a variable that equals the number of the portal row. eg Say i assigned a script to a portal field, and i clicked on row 4 how could i get the variable to equal 4

I have a field called No of players, it is formatted to count the number of data items checked in a checkbox. Is there anyway i could make a script that will go to one of my layouts(member) and create the amount of new records that are in the No of players field. eg No of players= 23 The script will create 23 new records. Also how many records in general can one database hold, till it effects performance.

Hello I have a short movie in quicktime with a series of paintings in a museum . Is there a way to control a quicktime movie within filemaker to get it to go to a certain frame. Maybe with a plug in or something. Just wondering Thanks Dave

Is is possible to have a script play a sound in a container field without having to go to the layout where the sound is stored? I've figured out how to have a script play the sound but not without changing to the layout where the field is. I would like to be able to play a particular sound when I have a custom dialog appear. Thanks for the knowledge, Mel

Hi All, I have two occurances of something that seems to be a related problem. This is in a newly converted FMP8 database, used to be FMP5. I have an orders database, viewing orderlineitems through a portal. Portal lines are displayed by matching ordernumbers, and is set to create new records in orderlineitems via the portal (i.e. we can just type new part numbers into new portal lines and records are created). If I go into orderlineitems after creating the line items, the order number IS there in the line item match field. Now: I have a calculation field in line items that, on a new order number entry, will equal the orderBillToID number FROM the o…

My database is designed as the front end to a MySQL database. I have a problem with the apostrophies. Many of my texts have apostrophies in them but the SQL database interprets them as separators. I have tried the "Substitute" function & the "Find/Replace" function in Filemaker to replace the apostrophy with an accent character, but the functions do not seem to recognize these characters. Does any one have an idea how I can replace these apostrophies?

Before converting to FileMaker, our Invoice numbers were generated in PeachTree as 000001 (text field). I saw no reason to have both an invoice number AND a serial so I continued with the existing InvoiceNumber (and left it as text). We are now at 256250. I have been asked (begged) by Owner if there is a way to re-start our invoice numbers AND to drop the leading zero stuff. As you know, this Invoice number holds many relationships together and is (what I consider) a major table. I also want to make that Invoice a number field instead of text (I think). Invoice 1 (text) will not relate to Invoice 000001 (text) so I'm fine there but if I make Invoice a number t…

I have two fields Country and Flags,flags is a container field and country is a text field using a value list/drop down menu. Stored on my computer is a folder with various pictures of flags,the order corresponds with the order of the value list. When the relevant country is selected, i want the corresponding flag to appear in the flag field,what would be the best way to do this. Thanks

I am hoping to take a found set of images in container fields and generate the guts of a simple web page in a calculation field using repeating segments of code like the one below. I already have the filename isolated in a calculation field, and have posted another question in this forum about isolating the pixel dimensions too (though dimensions are not essential). The repeating code segment looks like this: filename Contents of a description text field The above should be relatively simple to generate with a calculation, but the difficulty for me is how to get it to loop through a found set and add each repetition into the one text field or te…

I actually figured out how to get only 6 thumbnails on the page with the text I needed -- but I would like to print the thumbnails more than one page at a time. The actual use of this layout is to create a pdf. The way this template works only allows each page to be printed seperately; if you chose "print all records being browsed" you get several (the number of the found set) of the same thumbnail layouts. If you chose print "Current Record" you can get only one pdf of one layout of 6 thumbnails. If you use the "Next Page of Thumbnails" button to get to another 6 thumbnails, you can print the next page and so on. Since the actual use of this layou…

Hi, I have a requirement to lookup data in my line items file differentiated by the client name. The structure is as follows; Client table related to Invoicing table by Client ID Invoicing table related to Line Items Table by Invoice Number Line Items Table related to Items Table by Item Number One of the clients items price is different so I defined the price field in line items as: Case(Company="CHECKERS";Lookup(Items::Price);Lookup(Items::Price1) and that did not work so I tried changing the field to If(Company="CHECKERS";Lookup(Items::Price);Lookup(Items::Price1) and that doesn't work either. can anyone help please

Apologies if this is a silly question... I have a job number field which is set to serially increment each time a user sets up a new record. Users cannot delete a record. But I'm getting a few missing records in the sequence (which is a major problem because my Filemaker database has to link up and correspond with another database). I think this is happening because User A starts entering a new record, while this is happening User B enters a new record... and then occasionally User A abandons setting up a new record for whatever reason, leaving one missing number in the sequence. Any thoughts on the best way to prevent this from happening?

I have over a 1,000 fields in my form which were created and modified since Filemaker 4. There are, I'm sure, defined field names that are no longer used. I'd like to clean this up but I can't be sure if I'm deleted a field I am actually using on one of my layouts. Is there a way to see if the field is being used or exists on a layout(s)?

I am trying to esentially do a status calc where if in Field A, repitition 4 check box is enabled, then provide a result in another field. I can get the calc to show the right content in the destination field, but checking and unchecking the checkbox of the repitition does not change the result. Here is where I am at currently: If (status = GetRepetition ( status ; 4 ); individualname ; "" ) Thank you!

Hello Friends, Fields attached "value-list" will not pop up at end of creation script. How can I set it up so it does? ——— Below is description… I have a parent table to child to grandchild. I have a script that creates the child and child's grandchild record from the parent. I need to include in the child creation script an "auto-enter" and "go-to-field" at end of script. The field I have specified for the "auto-set" and "go-to" has a value list. When script is performed, auto enter and curser goes to specified field OK. But the attached "value-list" does not pop up. I wish for the value list to pop up at end of creation script. —…

Why are my container fields grayed out in my relationship graph. Every other field is normal. Also when I put a quicktime video file into the container field it won't play unless I create a file reference. Anyone know whats going on?

Hello, As I am trying to expand my experiance, I'm trying to make calculations harder on myself so I can learn. Here is what I did with finding the month number from a Month Name: Let ( list = ValueListItems ( Get ( FileName ) ; "Month List" ); ValueCount ( Left (list ; Position ( list ; Month::SelectMonth ; 1 ; 1 ) + Length ( Month::SelectMonth ) ) ) ) SelectMonth Values: January Febraury March April May June July August September October November December I didn't want to hardcode any months even though I could have used a simple Case function; what other ways are there to calculate a month number based on its…

I am using apple scripts with my database to manage my file folders. The record in the database hold the names of the folders. I am using apple scripts to create and delete folders, but I am having some trouble because I cannot figure out how to write a caculation which will export the " character. I want to create an caculation field that outputs the following: tell application "Finder" delete "volumeX:folderY:fileZ" end tell the path looks like this in the caculation: "volumeX:" & fieldY & fileZ ------------------------------------------------------ I have tried to use 2 global auto enter fields at the begining & ending of…

Is there a calculation that can take a container value from multiple records and convert them to a single record with repeating fields? I am not looking for a script, I need a calculation where the content can be updated in realtime.

In MS Access I had a routine to create a table of records. 2 records for each day between two dates I specified. One record was marked AM and one was marked PM. These were linked to a bookings table and the empty records showed as AM or PM slots that we could book as appointments. This method was very clear when the table was printed or displayed on the screen, showing free and booked dates in date order. Is there a facility in FileMaker to do this, or is there a better way of displaying free, unbooked dates?

I've got a rather large voter registration database (500,000 records) and I need to count how many people are in each precinct and determine the counts of types of voters within. Its just one big table with ID, Precinct, Affiliation Type. Here is what the data looks like... ID------------PR-----AFFILIATION 1121001--1108--DEM 1325484--1110--REP 2135113--1110--GRN I've done it with sub-summary reports, but it breaks it down vertically, and I need it broken down horizontally...so it will look like this.. PR----DEM--REP--LIB--GRN 1108--52---75---12---2 Any suggestions?

I recently asked for a solution to my problem and received an excellent solution from John Mark Osborne, using a join file. However, upon implementing this soution I discovered that I needed another option...here it is: I have a contacts database with a unique client ID. I have a projects database with an ID that I want to relate several contacts to and be able to view the projects through a portal in the client's file. I have now run into a situation where I may have several clients working for one company and I want to have a portal that will show any project related to the company name as well as the person working for that company. How can I accomplish …

I have a date field where the user selects a specific date. When the user selects that date I would like to have a record created. However if the user selects the same date again on another record I do not want another record created with the same date. I am new with filemaker and am unsure of how to go about solving this problem. If someone could help it would be great Jeff

Hello, this is my first post, so be gentle : I have a problem with date calculation. I have a time period. I need to "group" these days by months and then multiple each group of days with different number. How can I do that? Days in each "group" (1,2...12) can belong to different years. Am I clear? Thanks for help! LinaML

I notice a problem with images that have been added en masse through Filemaker's import folder function. A GetAsText ( Image ) string for one of these records returns only the following minimal information: image:/D:/Database/Subfolder/apricot.jpg As I'm trying to extract the pixel dimensions that are usually present through a manually-added image, I'm at a loss as to how to entice Filemaker to get the full information, like: size:501,341 image:My Images/picture.jpg imagewin:/D:/Database/My Images/picture.jpg Any body have any idea why these images are treated as second-rate?

I have a single non-repeating field with three values that are separated by returns. How can I use a calculation to convert it to a repeating field?

Hi all, First, I'm mostly a lurker, but I come here and very often find others' posts that I can glean helpful hints from. Thanks everyone who partipates here. Here's my problem for today: I am currently using a calc (with several repetitions defined) as follows: GetNthRecord (Extend(table::field); Get ( CalculationRepetitionNumber ) ) and it's working beautifully to turn records (rows) into column headings. But, the clincher is that I need it to be conditional. In other words, I only want to pickup the "nth" record if (and only if) a certain status field is equal to "Y". If the status is not equal to "Y", skip that record (don't make a column ou…

Hi All, Once again i wasnt sure where to post this thread but seen as though im using BT i will post here!! i would lke to open an image i have in a container field. E.g. a PDF file...i have inserted in to the the container field and i know there is a way to open up this file in acrobat and have seen this working before...but cant remember how it was done! Does anybody know how to do this?! Thanks in advance.

I have a 33000-record table of merchandise sales and returns that I have been able to manage pretty fairly with FMP. However, we are moving into more and more complex reporting and I find that the only way to classify line items for proper aggregation and summarization is to pack dozens of calcs into each line item...basically logical tests that tell FMP if a line is a sale or return, what month the transaction occurred in, etc... At the end of each month or quarter, I'd love to "freeze" the calc'd characteristics -- sort of the equivalent of Excel's "Paste Special -> Paste As Values"... Just looking for a way to avoid overloading FMP with tons of live/unstore…

Can someone tell me how the developer of this solution, managed to store his calculated global as un-stored? Interface_Rad I spent to long trying to figure out why I could not replicate what was done in this freeware, and then when I checked his global calc settings I discovered my problem. Anyone know how this was achieved?

I have a heck of a problem here: I need a calculation that makes a test due by the 30th of a calender month. But it has to be before the employees certification expires. For example: - Employee was last recertified on 5/22/2004 and needs to be recertified by 5/22/2006 - We issue him a new test 90 days prior to his certification date expiring - We need the due date to be at least 1 day prior to the expiry date, however it cannot be past the 1st (when we run all our reports on different systems, databases, etc.). I'll be happy with anything that will be due the 30th on the month prior (or something similar). So If the employee must be recertified b…

Hi All, Has anyone found a way to gather all field names from specific tables in a file without having to first make a dummy layout with all the fields from the table on it? Thanks, -Raz

I have an application with 12 different "full screen" diagrams inserted into 12 repetitions of a container field. My initial implementation has the user accessing them individually using 12 different layouts. I would like for the user to be able to step forward and backward through the diagrams from a single layout. Would setting up a separate display field be a reasonable approach and then use a calculated Replace Field Contents? I would greatly appreciate a recommendation for an approach to take on this -- or possibly point out a suitable sample file. Thanks in advance.

Ok so I am not really this dense all the time, But this is driving me nutz. I have a two file application using separation in that the data tables are in one file and the interface and some logic in the other. Mostly this has worked well, but here is the rub. When creating calculated fields in a logic table in the Interface file, I am having trouble with the 'Evaluate from' choice. As I understand it, if there is more than one reference to a table in the diagram, they should show up here so that you can choose the correct context. So far so good. I created a few useful calcs then a few days later went back to add some more and the context I was using does not …

Is it possible to use a Calculated function to auto-correct an entered text field? For example, if someone enters a "Middle Initial" for someone's name as 'A', could Filemaker automatically change it to 'A.'? The tough part is making sure the period only gets added when there is a letter entered in the field.

This question may have already been addressed. Is there a way to have the Insert Picture script to always default to a specific folder without naming a specific file in the file path list? What I need to happen is when the user calls the Insert Picture script a specific (default) folder will open allowing the user to select which picture to insert. The Specify Picture Dialog box appears to require you to name a file within the folder for the file path. Thanks for the help.

After disable the auto-save function, when I input the value in a form, FM always popup a windows which is ask me to save the record. How can I take away this popup?

Greetings, I am running into a problem solving the business rules by the owner which I hope FM8 will solve in a clean way: He wants every when a person creates a "job" to be comprised of: 2 digit year + 2 digit month + incremental job# that resets each 1st of a month. Ergo for today it would be: 0605034 or 06 [yr] + 05 [mth] + [we are on job#] 034. Yes he wants/needs the zeros as well... .... I am running into problems doing the correct calculation formula. I can get the month/yr/date easily enough, but my chief problems are: FM needs to know what the next number in the job sequence-- a lookup to see what value it should …

Hi all, Hope this is the right place for this? I have a FM8 solution that is being served by FM Server 7 Advanced with about 5 users, all Mac's. In the solution there is an area with a Global field for writing a letter to all clients, If I enter text in this Global field locally (not served) the text is seen and accepted, but when the solution is running on the server and one of the users wishes to change the text it always reverts back to the text I entered when they next start the solution? This also happens with other Global fields and when it was a FM6 version being served by 5.5 Any ideas? Regards Ian

Solution / : Helens Calculation For Scores Description: In order to calculate scores i need to add up 5 different scores from different fields, the take out the highest and lowest then add the remaining 3 up. can anyone help? Thanks Working Under: 8 Solution Status: Beta Pre-requisites: Author(s): helenthebouncer Date: 05/19/06 Credits: Instructions / Other Info: Disclaimer: FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated…

I have a three different price structure depending on which level a customer is buying at and so have to choose between 3 different prices on a lot of products. I can't seem to get the choice in there. I just get a zero. I have been trying a few things but don't seem to be able to get the answers to come up. Help. Bruce

Hi. I have two fields that I would like to allow a user to enter a percentage in. The total of the value of the two fields needs to equal 100%. Is there a way to allow values to be entered in either field and have the other field automatically change to the remaining percentage? I could only figure out how to make one a calc as the remainder, but i need to allow values to be entered in either field, so this wont work. Thanks.

One of the tables in a database I'm currently working with is a collection of images. The images are mostly logos and are associated with records in related datases. I'd like to be able to present a "catalog view" of image thumbnails. I can do this now with one big column of one image per row, but I'd like to have several rows on a layout. Is this possible? This is FMP 8 running on a Windows server with a mixed Mac/XP workstation environment. Thanks Dave

Ok, that sounds simple enough, but implementation in the database that I'm working on has been anything but. Background...creating a royalties database for a record label owned by a university which needs to track royalties for artists, publishers, and organizations (like the different University programs that get certain percentages of sales). It get's even more fun when you add in single song download tracking per project, but we're not there yet. Did I mention this is the first database I've ever built? Currently Projects and Organizations has a subtable that ties the two together and also allows a user to add in a percentage that each organization get's for …

I am a printer, I need to create a calculation that will give me my printing forms. For example: I can hold 16 pages on a form. If I had a 20 page book, I would need 1 full form and 1 form with the last 4 pages. I would print these pages 4 times on the same form because I have room for 16. We would call this 1 full 16 and 1 4up 4pg. My present calc is pages/16. I get 1.25. I need to isolate the 1 and the .25 so I can process them seperately. I also need a flag of some sort to tell me if I have a whole number or not so I can populate an additional field for the .25.

I have a table that contains about 2500 records, with approx 500 new records imported per month. The data is gathered via script (by date range and client) and put into a report format that provides grand summarys on the monthly data. Ie: Total Users/Sales/ etc for the month. I need to store the summary totals so that I can analyze changes in monthly usage per client. I know I can build a calulation to "sum" the information, but that does not allow the individual montly totals I need to see. I'd also like the ability to compare client to client. I don't want to pull a report everytime I need to look at the information. Is there a way to store this data …

Another user previously asked this question but I did not quite understand the answer given by T-Square : "create a self-join on the calculated field, and use validation to test whether there are entries on the other end of the relationship. " What I wish to do is prevent a user from putting the same item number twice (ie on two line items) during order entry. I have created a combined field of order_number&Item_number... but how do I use it to stop the user entering the duplicate?? thanks

I am trying to get the difference between the create date and a modify date. I have done this before in the past with no issue, but for some reason i can't get it to work now. All i have is modify_date - create_date. It ends up giving me a negative 6 digit number. For example, 2/28/06 - 3/16/06 = -732386 Am I doing this completely wrong? Thanks!

I have a 3 fields: StartDate (user input), EndDate (user input) and Dates (calc?). What formula or script do I need in Dates field to break down the range into dates separated by carriage return. For expl if StartDate is March 19, EndDate is March 23, I want in Dates field: March 19 March 20 March 21 March 22 March 23 Thanks in advance

I have a calculation field which combines order number and order date for a price lookup. I was have a problem with it so I placed the combined field on a layout to see the contents. The order date is May 17th 2006, which results in a value of 732448 in my combined field. But when I enter 732448 into Excel and format it as a date it returns the date May 16th 3905. Why is that ??

Does anyone know how to clear a field index once it is created? This is for an invoicing system that I use. I would like the descriptions to auto fill based on previosly entered values, but the index is already full of many values I would like to get rid of. Is there a way to start fresh?

I need to take a certain field(upc) from every three records and be able to export each block of three upcs as one record so the export would look like: line 1: 9999902244951, 987741000523, 982693000010 line 2: 724354004124, 724354004025, 724354003929 line 3: 606949007324, 606949007126, 606949006525 I know this may be done via a portal but how do you export portal data? Any help would be great!

How do I store a company Logo into a global container , so I can use that instead of pasting graphic logo on every layout? I know there is probably a easy answer, but for the life of me I can't figure it out.

I am looking for a way to calculate the size of a picture placed in a container field. Needs to be expressed in bytes.

I've been through The Missing Manual as well as posts here but it looks like the only way to insert a QT file into container field and have it NOT be a reference, is to Inert File... which, of course, would sacrifice the nifty QT controls. Am I missing something? The Missing Manual claims one can Insert QuickTime... in both fashions but I see no checkbox on the file dialog as Insert Picture... and Insert File... have. Thanks.

sorry for being a pest but i reeally need help...again. I think this requires some type of loop Ok i have checkbox(setup,participants)and then 10 fields(brackets,entry 1-10)i need a script that will enter the checked data items into there own seperate entry field and then stop when all checked items have been put into there own seperate entry field. eg I check A,D,E,G The script will put A into entry 1, D into entry 2 and so on and continue till all checked data is in an entry field

hi.. i currently doing leave application for staff management system using fm8. When staff make an application, they have to wait for admin approval first. my problem is 1. if previous application from the same staff apply leave on 1/5/06 - 2/5/06 and 5/5/06 - 6/6/06(approved by admin). Let say if the staff apply another leave on the 2/5/06 - 5/5/06 (not yet approve by admin). How to let the staff know that he/she has been already applied on that date 2. each time new application is made, reminder will be sent to admin by e-mail. is it possible to do it?

I'm working on a database in with I like to include a field for keywords where the keywords are seperated by e.g. semi-colons (. Is it possible in Filemaker Pro 7 to validate and/or auto-complete every single keyword (With entries in a table or value list)? I'm looking for something like how keyword can be entered in programmes like Reference manager or Endnote. It would be great if someone could help me!

Hi everyone, I have a checkbox that is a value list from a field. It is getting larger. It won't get terribly large but I am having a problem formatting it for a layout. Apparantly I can't add a scroll bar and when I click into it, it won't show all. Right now I am able to make it large enough to accomodate more than I currently have, but as time goes by it will outgrow the field size. The field will more often require multiple checks so a radio button or drop down won't work. What other options do I have? I can only make the font so small and the field so big. Thanks in advance for any help. Mike

Not sure if this is possible and i dont have a clue how to do it. I have a checkbox set (Setup;Participants)with a list of numbers from a value list determined by the field(Members;Member No). I need a script that will go to the Layout Members and go to the relevant record based on the numbers being the same, of every member checked. Eg I check the numbers 1 4 and 6, the script will go to the layout members and go to the records with the member Numbers 1 4 and 6. All help is greatly appreciated.

I have a projects database and a contacts database in FM 8. A single project may have several contacts from several companies participating. How can I relate many contacts to my single projects database? One is simple the multiple has me stumped. Once I accomplish this I want to create a portal in the contacts database that will show me all projects a specific contact is working on.

Does the count or sum version feature work with a single checkbox so i can have a field which counts how many data items have been checked. If not how would i do this. Also is there anyway for filemaker to recognise odd/even numbers using a script.