Calculation Engine (Define Fields)

I have a table to hold claim data. Each claim I want to assign a claim number to. I would like it to be the Julian Date plus a sequential number. Can FileMaker calculate the julian date? If it can not do the specific julian date is there a date function that gives the day of the year. If that can be done I can create a julian date. Thanks, Scott

Please! Help! I'm probably not using this complicated forum correctly but I can't find where its okay to ask a question! (I've been using FMaker for 10 years) I set up a database w/ field format and value list. Need to edit it. Now I can't get the check boxes to show up! I've deleted the whole thing and started from scratch a dozen times. I can make check box value lists on my other databases but not this one now! What am I doing wrong? Elaine

I've got a company details table / database with each company having a unique company code. At the moment the field is set so that it auto enters a serial number with a increment of 1 each time but what i really want is to generate a unique company code based on the name of the company. for example a company called microsoft would have a code of MIC01 and if you added a company called microwidget that would be called MIC02. Does that make sense? Basically I want to take the first 3 letters of the company name and a number (or whatever the best way is to do this) Thanks

Hi All, Cell phone numbers in Bangkok are being expanded from 9 digits to 10 digits next week, and I need a calculation (I think) to make our member database reflect that change. I need to insert an "8" after the first number (a zero). Example 01-XXX-XXXX will become 081-XXX-XXXX 084-XXX-XXXX, 086-XXX-XXXX, etc My field (Mobile) is defined as text. Seems simple enough, but it's beyond my understanding. I've been scouring the help files and trying to find something similar in these forums, but no joy. I just cannot figure what function to use to create the calculation. I've been using FMPro for a while now, but my needs have been quite simple. T…

I have a status field for which I would like to store a date when it is modified. I have Status and Date fields, but don't know the best way to evaluate the contents of the status field for a change - should I make a temporary field which stores what ever is in the status field and when the user leaves the record the temporary field gets replaced and then sets the date if needed? Thanks

OK, I'm stumped. I've got a multi-table database. I have 2 tables connected by a join table to allow many-to-many joins between the two. Table 1 has an auto-entered serial number id field as does Table 2; they are joined via Table 3 which has its own serial number field and values for the Table 1 and 2 ids. Table 2 is set to allow creation of records from Table 1 via this relationship. So far, pretty straightforward. I have a layout in Table 1 that displays a field A from Table 2 that allows entry; entering a value into this field in this layout therefore creates a related record in Table 2. So here's the question: I have another field B in Table 2 …

Hello everybody. Is there any way to have the drop-down list to display more values than two? I.e I want the drop-down list to display Firmname, Adress, zip and phonenumber. I use the drop-down list to choose senders and receivers in my transport registration db,and I have several firms registrated with the same name, and therefor I need to be able to see the rest of the info, before choosing firm.

If more paerson are entering data into same database at same time how the global fields useed in scripts works? Will a simultanious action crash the script?

Need some help. I am trying to use an if statement with a calculation in a repeating field that looks at a non-repeating field with the extend function. If(LH1 >= Extend(HEEL) and LH1 <= Extend(IHEEL) ," ","** **") This works perfectly except when there is no entry in the first cell of the LH1 field. It returns the ** **. If I make an entry then it works perfectly All other repetitions in the repeating field work fine. Any way to fix the first cell? I've tested both clicking and unclicking the " Do not evaluate if all referenced cells are empty"

Dear friends, I make a mistake with a DB with 3000 records. In a container field the DB has, I have inserted picture files not as references, and now the file is almost 2GB! How can I correct this and make these pictures be referenced (using the data in the container). Saludos, Javier

I have a global container field with images in it, it has 10 repetitions. I have a non-global container field with 10 repetitions. I would like to create a new record and have an auto entry calculation that populates the non-global repetitions from the global repetitions but can not seem to get this to work. have tried: getrepetition ( globalfield ; calculationrepetitionnumber ) Had this problem in v6 to any ideas? Stuart

I read the posts about text formatting/Pasting but could find an answer to my problem. When I copy & paste a formatted text from an extermal source (MSWord, email, etc...) into a text field in FM it does not retain the original formatting (bold, color, underline, bullets, etc...); the text is pasted as plain text. The only option I have under Paste Special is unformatted text. How to retain the original format?

hi i have a dillema what is better. i have three databases and i need to make some relationships between them. i know i can use a table from one database in another database, but sometimes i need to import more than one table and the relationship between them is not exported... also if i have three files, i have to define privileges for three times. and if is better to use one field with tree connected databases, how can i copy the database's tables and fields into another file? thanks for each reply... sju

I thought that there would be a simple way to do this but I cannot find it Basically I am importing large numbers of records at a time , converting the data and then exporting the result to another program. I have a calculated field that produces a list of values for each record, some of which might be duplicates. I want to remove the duplicate values from the field preferably with a calculation rather than by creating a value list and scripting a Replace Field Contents script step ... ie I would like to complete all calculations during the import process. During import the Field A is a calculated field that may well contain values such as ACPARGF …

Hello, i was wondering if someone can help me with this. i am trying to get percentage of a field in sub-summary report that i have. Basically i have this. i have a DB that track students, each student has the statuses of either, Pending, Applied, Enrolled, NonStart, Inact. I wanted to find the percentage for each of this status. i have included a screen shot to see what i mean, i want to know how i can find percentage of number 12 student that have the status applied.

For a project ( built in 6 ) we have to combine 4 images that were photographed and edited with Photoshop with transparancy. In Filemaker we want to show these photos on top of each other ( 4 ) but we lose transparancy after import in FM. Is it possible? What is the best way? TIA

Is it possible to get a summary based on another field? For instance, I have a database of liquors and wines, their cost per bottle, and how many i have of each bottle. I also have a value list field where I have selected either wine, or liquor. I would like to create summary fields that tell me how much total $ I have in wine and liquor separately based on the count field, cost field, and wine/liquor field. Is this possible? Thanks

For invoicing, I have set up repeating fields for quantity, size, unit price, and extended price. Unit price and extended price are calculation fields, based on quantity and size. Each field has ten repititions. I can only get the calculation for the unit price field to work on the first repitition. That field remains blank in all other repititions. What am I missing?

I have seen this somewhere just can't remember for the life of me where I saw it. I want to have a field that is caculated as: if( aTable:ID notequal bTable:storeIDs; textStyle(aTable:comment, BOLD); aTable:comment ) What I want it to do is if someone has read a comment, then they click a button that runs a script to set the ID number into a field so that comments, through a portal, won't be bold. So the bold ones haven't been read yet, like a new message system. These are messages that everyone sees on their own bTable. aTable is open to everyone to write to. I was thinking that one field that had the aTable:ID values in it seperated by the return command…

I am creating a database that will track votes taken in meetings. There is usually more than one vote in a meeting, but only several meetings a year. I would like to set up a unique VoteID field which should be the date (without punctuation) and a sequential letter. For example, on Jan 1, 2000 we voted on four things: death, taxes, sex, and war (um - not really, but this is just a scenario), in that order. The VoteDate field will read 1/01/2000, but I'd like the VoteID field to be automatically generated each time a new record is generated as: Death = 1012000a Taxes = 1012000b Sex = 1012000c War = 1012000d How do I do that? Any ideas? Thank…

Hi! I am designing an application that need to store image in a file. I noticed that 44 images (total of 84Mo on HD) goes up to 440mo once I store them in the filemaker file. Is that normal and is there a way I can compress them and keep a good hi res? thank you!

Hello - Apologies if there is an answer to this already - I've looked but not found. I would like to use a Filemaker database to store references to Applescripts. Nothing fancy, just something allowing me to keep a little extra metadata about the scripts. Even the Filemaker Document Library template should work fine. Here's the catch: I would like to import a folder full of scripts all at once and match them up to the container field, the path field, the filename field etc (just like with pictures/movies) but I don't see a way to do that. Does anyone know if there is a way to bulk/batch import files other than image files? Thanks much.

I'm looking to capture double quotes within a calculation for the purposes of producing a desired url For example trying to capture: http://www.xyz.com"abc" How would you script this? I can get to "http://www.xyz" but then I can't figure out how to capture the double quotes because they are inherent operators. I would think it would look like: "http://www.xyz.com"&""" but that doesn't work and for obvious reasons. Is there a substitue symbol I should be using? Forgive me - I'm not a programmer

I'm new to FM Pro so please bear with me. I've created a container field that I want to display a different picture for each record. I'm trying to create a button that will activate that particular container field and open a specific folder on my computer so that I can select the relevant picture for each record. I've managed to get as far as inserting picture with the button setup function but that requires that I select a particular file and all I want to do is open the folder containing the pictures. Can someone please help?...Thank you.

My solution has four fields for pictures. When I started this was not a big deal but it has grown to thousands of pictures. How do I take the pictures out and replace them with a reference? I am using FM 8 Advanced, thanks, on a Mac. Michael Spencer

I need to figure out a way to show a running total that restarts whenever a certain field changes. For example, I have the following fields: Page Number Space I'd like to show a running total of the Space field, but have that total restart whenever the page number changes (assuming that all records are sorted by page). I've tried using a summary field, with the options of Total Of Space, Running Total, Restart Summary for each sorted group when sorted by page, but can't seem to get it to work. Anyone have any suggestions and/or advice? Thanks!

How do I write a calculation that will tell me if a person with a unique ID has signed up to use a facility more than three times in a 7 day period? Thanks Lester

I have created a button to insert an object and it works beautifully. BUT, when I create a runtime solution, the button either does not work or it brings up a "record your voice" thing. Any ideas on what's happening? BTW, I'm running this on XP and the runtime is in Kiosk mode, if that makes a difference.

plz help me how to make profit .give me example or attachament file . thz

I have a Job ticket db I'm trying to set up. It links to another FM file for customer contact info. I would like it to generate a number on the job ticket every time I create a record. But each customer has it's own prefix, so each customer's numbers would be different to the last. i.e I input the details into the FM job ticket Customer A (CA), so job ticket will produce a sequential no. CA0001 - I then input a new record but with a different customer, Customer B (CB), this job ticket will say CB0001. Is this possible, or do I have to create a different db for each customer so the numbers work indepentently of each other and link back to the origin…

Hi, I have a field with content as follows "505 Woodland Terrace - 3" Which is a Property Address + the Unit. Is there a way I can extract the content of the address and the unit, i.e., use the "-" as the point where the data is split? So I'll have 2 other fields that read this one, and the first would output all the content before the "-" and the second field would have all the content after "-"? Thanks! Moosh

Hello, I work for a small publishing company. I have a few questions about a system we are creating to mamge our invoices and inventory. We have a few distributors and customers who order books from us on a consignment basis. It is simple to set up invoices for the customers who buy outright, and we have an invoicing database started. I am wondering the best way to manage the consignments. This is how the process generally works: The distibutor or customer places an order for books to have on consignment. We need to remove these from our inventory and put them in the distibutor's inventory, but they are not actually sold at this point. On a monthly basis, …

Hello, I have a slew of calculation fields in one of my files. However, 90% of them are calculations of related fields, and -- as far as I know -- they cannot be indexed. Consequently, the page loads VERY slowly. Is there any other way in Filemaker 5.5 to speed up the calculation field displays? Thanks!

I have no idea where to ask this question so I will ask it here for now. Can I input Japanese text into Filemaker applications? I am using a MAC that is set up to input in unicode and control/space bar shifts to Japanese in any application with no trouble. In filemaker however I cannot input in Japanese and just get gobblelygook. Any ideas suggestions? Can I even do this in Filemaker? Is there a plug in I need to set up? I looked into the help section and there was nothing about language at all. thanks

Greetings: I am running a database for my Adult shop, there is thousands of record. Each record holds information on a particular title. Each Title has it's own record. There is a Container field called "Image" which is on the database, i have also made 2 other Containers called "Image-front" and "Image-back". I have also put arrows below the container field. What i want to do is make it so that when you click on the right arrow it shows "Image-back" in the container field "Image" and when you click the left arrow, it puts "Image-front" in the container "image". Also i would like the Container field "image" to already show the image from "Image-fr…