Calculation Engine (Define Fields)

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?