Calculation Engine (Define Fields)

I wonder if antone would be able to give me a couple of pointers on FMP. I

Is there a Calculation that can count the number of charecters in a text field? (ex. "FFFF"=4, "FFF"=3, "FF"=2, etc...)

Hi all, When we double click on a container field in a form, it's by default bringing us to the "Sound record" dialog box. However, for my case, I don't want that to happen. Can we actually change the default from "Sound recording" to anything else, eg. inserting file, so that anyone can easily double click on the container field to insert the file? Thanks in advance everyone........ Rgds, Ren

I have a list of 30 - 600 people in a pictorial booklet lets just say 30 for now. They are sorted alphabetical. This is the output I need filemaker 7 to do. 3 record per page. On page 1 we would have A on the top left and Z on the right bottom of page. What would be the best way to sort this.. I have a pictorial directory number field I would like to sort. I am close to a good sort using some calculations and scripting to paste a sort order numer into the pictorial directory number field but the right records are top to bottom and I need them to be bottom to top. Page = 1 -- Left Record = 1 -- Right Record = 28 Page = 1 -- Left Record = 2 -- Right R…

Hello, I wish to validate entered data so that a value entered has not been entered before. I am using a data entry layout which just has global fields, when the user clicks on a "create" button a record is created and the data is tranferred from the global fields into the record. One of the fields is a serial number. They are not entering the number sequentially, so I can't have filemaker automatically put in a number. What I want to do is check when the number is entered to see if it matches any value that has already been entered. I see a validation of "member of value list", is there an equivalent "not member of value list". Or, is there a fu…

I have a database of papers, including authors, proceeding titles, page numbers, etc. I'd like to create a field that will combine information from various fields, to use in a bibliography. I know I can accomplish this with a calculation field but I am hoping to find a template already created. Does anyone know where I can find a bibliography template?

Hi everyone, Can someone tell me how to insert today's date (dynamically updated daily) into a field?. I want to be able to calculate the "days remaining" for a particular task to be accomplished. I also have another field that contains the number of days the task should be completed in, which I enter at the time of the creation of the task. I then want to be able to look at the days remaining field to see how many days I have left to complete the given task.... I also have a field for the date the task was created on. I figured I would need to know "today's date" in order to see the remaining days. How do I do this? I did see a script step to Insert Current Dat…

I have a database with several tables. One table, contains several global fields which are referenced from other tables. In my 'global' table, there is only one record. I have one field mid_locked which is a calculation based on a few other fields in that table. That value can change when the user sets other fields (dates, periods, etc). I reference my global field mid_locked in my main data table. The problem is, the field does not retain any value changes because it is defined as a global. I can get the value changes to stick if I check "do not store results", but then I can not reference the field from my other table as it's not related. Any thoughts on ho…

I have a column that consists of multiple names seperated by commas. I need them to be seperated by / Is there an easy way to reformat the data in those columns?

i have a tricky problem, but one that many people must have come across before. my solution requires that i create a unique code for all my contacts. previously, i allowed my users to choose their own code and used 'validation' to ensure that there were no duplicates. i now wish to automatically generate this code. generally, the code is set to the first three letters of the contacts name and a numer starting with "01". the "01" is concantenated from a standard default number field. for example: if you enter "coca cola" as the contact name, the unique code becomes "COC01". as a matter of interest, i have set the code to ignore the word "the" in co…

Hello.. I have a file, with multiple tables in it. I have some raw data in one table, and I want the summary in another. I relate the two tables, with a common stock number. In the raw data tabel I have a Summry that is the Total of the raw data per stock number. I use Get Summary function to bring it in to the form. In the Summary table I just want Stock Number and the Summary Number. I can not get the number to show up, I've tried setting things equal to raw data table, I've tried putting a field in the layout that would be the same thing etc.... Any ideas?

Hi, I'm a noivce at this, but, I was hoping someone could help. I'm trying to create a script or an action in which if I typed a "serial number" then it would automaticly bring up both a "product id" and drescription". Also, I was wondering if I enter a certain text in a "field" how could I disable another "field" because the previous "field" was filled in. Example: If someone had a tax exemption number then the tax "$" figure would become "0", but, if there was no tax exemption number than the tax "$" amount would have a "$" amount. If you could help write or show me how to write the script for both problems, that would be very, very helpful. I…

I have three portals displayed on a layout which filter upcoming shipments (Invoices) according to a combination of flags, status

Hello, I think there has been a change in how GetAsCSS() works after the FMD 7.3 update. And that's my problem! I have a field (F1) the content of which I intend to save as a HTML file. It contains formatted text (smallcaps, italics, etc.). I use a script and the function GetAsCSS(F1) and save it to a file with the extension HTML. Up to FMD 7.2 this worked perfectly. However, with update 7.3, if I use the same operation everything in the field that was Plain (font) becomes several pixels smaller than the other text. (My text does not contain any information concerning the size of the letters. They all are default.) Here's my example: the GetAsCSS() resulted till u…

I'm sure there is a simple solution but my brain can't quite see it at the moment. I'm trying to make a calculation based on whether a date in the future is within 14 days of the current date, more than 14 days in the future from the current date or less than the current date (ie. in the past). I tried date > Today +14 date < Today +15 date < Today .. and various combinations. The idea is to apply the results to a portal so I can show the three different sets of patients who are to be reviewed in the next 14 days, or who need review more than 14 days from now and those who have been reviewed in the past. I can't get it to work and any ideas much appr…

Trying to write this function using filemaker pro 7. I am relatively new to filemaker with some programming background. Planning to use it to create a multiple choice question bank for my students. The sample picture in the attachment showing the intended logic of the database uses simple items like fruits within the table.

In many cases I don't want the auto entered Modification Date to change when Replacing the Field Content of browsed or found records. Unfortunately the "Replace Field Contents" dialogue does not show a checkbox permitting this exception. How can the auto-enter Modification Date best be turned off when Replacing a fields content ?

I have a FM7 database with several date fields in the yyyy/mm/dd format I need to get to standard mm/dd/yyyy format. The computer system default is mm/dd/yyyy. The file was probably originally an excel file import. When I try by changing the date format in the layout mode (from leave as entered), the result is a ?, which reverts to the previous yyyy/mm/dd format when clicked upon. Is there no way to change this easily, short of a complex multistep find and replace operation?

Hi all, I've been searching but can't find any tips on this. I want to do a file for booking conferencerooms, and my idea is to have a matrix where the rows are each room and the columns are dates. The matrix should consist of the rooms and, say, 7 days including the start date. When I want to check the availability I should enter a date in a search field and the "availability-matrix" will be filled in with info about each conferenceroom. Heres the snag; I want the corresponding field to be green if the conferenceroom is available and red if it is not available, all depending on if there is a reservation done in the "reservations"-table. Is there a way t…

Is this possible? OS X, File maker server Want to be able to search certain parts of the PDF from the filemaker db

Hi, all. I am trying to create either a "script" or a "calculation" but, I have forgotton how to do such and was hoping someone could help. I would like to create a Tax Exemption "text" which relates to the Tax Number (7%). What I mean is that I have an set amount lets say $1.00 and the tax calculated is .07 totalling $1.07, but, if I entered a tax exemption number, than that $0.07 is now $0.00 because of the tax exemption. How would I go about doing such. Thanks.

Is it possible to format a field to display fractions? I want to enter my values using decimals (10.5), but have the record read 10 1/2. Tried "number format" in layout mode but fractions aren't an option. Running FMP6, but have access to FMP7 if needed. Thanks

We rebuilt this database (magazine.fp7) after updating to Filemaker Pro 7 from version 5. The database is used to compile MLS real estate listings for publication in our monthly real estate magazine. The file magazine.fp7 gets data from the other two files, directory.fp7 and magazine sections.fp7. Now the last two fields in the export field of the Ad Copy layout are not populating (Ad Name and Ad Phone). Can anyone take a look at this and help me to straighten this out? The files (with one dummy record)can be seen at Welcome Home magazine . Thanks in advance.

How can I get this calculation working? Case ( Card Type = "Queen" and Expansion (does not equal sign) "Stone Age" or "Renaissance" or "1800";"Qu";) Basically what I need to happen is, if Card Type says Queen and Expansion doesn't say Stone Age, Renaissance, or 1800 then this calculation field should say Qu.

Hi everyone, Although I use GTRR for most date ranges, occasionally I need to perform finds (example, script for finding HireDate range) on smaller tables. I have about 15 situations in which I use this similar calc 'thinking'. I want them to be the best possible. Here are my two attempts: Fields (all date) DateFrom DateThru gFiscalStart (global pre-filled at host with our fiscal start) gFiscalEnd (global pre-filled at host with our fiscal end) My first calc (clunky) Case( not DateFrom and DateThru; gFiscalStart & "..." & DateThru; DateFrom and not DateThru; DateFrom & "..." & gFiscalEnd; not DateFrom and not DateThru; gFi…

Real quick, anyone have any idea if its possible to make a calc field that strips everything except letters and numerals? Like the regular expression "[a-zA-Z0-9]"?

Is there a way to use tabs within a calculation field? I have three separate fields of data. I want to make a calculation field that combines the data in all three fields into one field, while aligning the results to a tab. So, it would be [field 1] & 'tab' & [field 2] & 'tab' & [field 3] I need to line up data from the calculation field between records, and I can't get nice columns. I tried counting characters and using spaces, but that only works if I use a fixed width font (which are ugly, IMHO).

Although it seems like it should be really easy I cannot figure out how to do this. I am creating a time tracking system and I will like to set each time entry to be related to either a Job or a Task, but never both. On my layout I have two pop-up menus, one with Job#'s and one with Task#'s. I would like to be able to select either or, but it I select both a validation message occurs. I am very new to FMP, so this is probably not that difficult. I have tried several options by validating data through a calcuation, but I think I am just doing it wrong. my job field is: tim.job# and my task field is tim.task# I assume that I need to have a validation ca…

i'm trying to share files within a database on a host computer with other computers. I originally uploaded the entire file into the database which worked well for sharing, but made the database un-sustainably huge. so someone suggested i just put in the reference to the file, so that it can be called up from the host computer when a remote user tries to download it. trouble is, when i try to download the file (say a pdf), my remote computer tells me it can't find the file....any idea of where i'm going wrong here? thanks in advance for your help.

Hey everyone, first off. thank you. all your questions and answers have been a huge help in me getting my bearings on this program. you all are awesome... my question - i have a field for 'total height' in inches. and i just want to make a field that will convert it to X'Y for instance...... they input 68 into the inches field. and the next field will say 5'8 any advice would be greatly appreciated. thanks again.

While working on designing my database, text alignment for fields and field names is always set to right. How do I change it or is there a way to have Filemaker change from always having right aligned text to left aligned. Thanks.

I have a field that is a calculation for an inventory #. THe first part is a code taken from a related file (DCXII-1 for example). The second part comes from the current record (edition # 1/25 is turned into 1.25) so the total calculation is: DCXII-1-1.25 INVENTORY MAIN::Image Inventory Code & "-" & Inventory Number Endcode The Image Inventory Code automatically pops up in the record - then the rest of the inventory # is completed when the edition # is set. For some reason, when I put the dimensions into the record (a completely unrelated text field, for instance 20"x24") the first part of the calculation disappears. This does not happen when I …

I have an image database with rights managed photos; I would like to be notified when the licensing agreement expires. I have a container field with the image and an expiration date field. Email notification or some sort of flag within the record would be perfect. I found a thread a few months ago but cannot find it now. How do I make this happen? Mac OS X FM v7

I'm writing a calculation that needs to include ASCII non-printing characters - specifically, ASCII 2, (STX); 3 (ETX); and 26 (SYN). How do I get these values into the result? Any help thoroughly appreciated - thanks! Tony

I recently imported pdf's into container fields, a scroll bar automatically appeared on pdf's with more than one page. Now when I manually enter multiple page pdf's (right click container, insert picture) the scroll bar does not appear. How do I get the scroll bar? FM help says container fields cannot have scroll bars but obviously they can. Mac OS X FM v7

Senario. I have a main layout. It has various fields, 1 (one)of which has a repeating number field(7)[NAME]. Layouts 2 through to 8 are basically 1-8 paged duplicate layouts with a few common fields. Reason. If there is an entry in some of the repeating[NAME] fields, then i want to create a script to navigate to a corresponding layout. But i want the value(if any) from the [NAME] field/s entered into the other layout fields. Why. In the main layout i have the repeating field that may or may not have any values placed in them. It can have values in any or all of the fields, but not necessarily in each adjacent field repetition. If there is …

Hi all, Every time I select a particular ID that is displayed automatically through a drop down list, it shows the correct ID format (e.g. 0001) but whenever the record is saved, the ID format will change to 1 only. In the database, I've set the serial auto number for the ID to 0001 increment by 1 and on the layout, I've set the number format for the ID field to "General Number". Does anyone know on how to fix this? Thank you..... Rgds, ren

I know how the equation IsEmpty works, I need to know if there is a way to say the opposite... when the field is not empty do this.... is there a easy way? Joseph

I haven't paid much attention to the creation order of fields until I began toying with the technique I uploaded in this thread: http://www.fmforums.com/threads/showflat.php?Cat=0&Number=160625&Main=160253#Post160625 ...where dependencies works both ways. It's so that if you deside to add a new field to your solution, and you by accident defines the global first - will the transaction not work. The order to make it work is: 1) Define the non global 2) Define the global 3) Make the autoenter for the non global field, it important to stress Get Field( is needed, the timing difference plays a role... 4) Make the autoenter for the global wit…

In FM 7, is it possibile to implement even driven? for example, when I enter data in a field, if the datum is invalid, then FM7 will automatically call a script file. If you have implemented this function, please teach me about the strategy. Thanks a lot!

I'm attempting to import some information from a text file and need to calculate a couple of dates. The date info I'm importing is a number, which is how most dates are stored. The number represents the number of days that have passed since 12/28/1800. So I import the data into a number field (FIELD1) and then have another calculated field (cal_Date) that looks like this Date(12; 28; 1800) + FIELD1 the result type of cal_Date is a Date. But the only result I get in the cal_Date field is 12/28/1800 on every record. This formula worked before under FMP 5 but doesn't seem to now. How can one add days and dates and get the correct result? Thanks th…

Is there a way to change Line colors in or on a field...just like you would change text color? Example... I want to change line colors in a checkbox... is there a simple way to do this? Joseph

Hi Guys Is there a way to have a field automatically condense,compress or squeeze text entered by a user if it is longer than the field size? thanks fastest

Can't for the life of me think what it's called, so can't give you a title lol. But I have calculated the difference between two dates (year based) What i now need to do is append a phrase to the end based on the number.. i.e 1 2 22 23 55 would become 1st 2nd 22nd 23rd 55th how can i do a calc based on if it ends with "1" insert "st" "2" insert "nd" "3" insert "rd" "4 to 20" = "th" 21 insert "st" 22 insert 'nd" 23 insert 'rd' 24 - 30 = "th" and so on The range will only be 1 - 40

Hi all: I remember seeing a demonstration by FileMaker staff last year of hooking up a digital camera (on the Mac only, they pointed out) and automatically importing images into FMP. I was wondering if it was possible to hook a camera up and, when on a given record, take a photo and automatically place it into a container. I can't try to figure this out myself as I don't have a camera at the moment. Any help is greatly appreciated. -Stanley

I have a field that determines what the best time to call a client is. Because we have had clients longer than this database, I haven't filled in all of the "Best Time To Reach" fields. The calc field that reads the BTTR field uses an Evaluate to update whenever the BTTR changes. The issue I have fallen upon, is that if BTTR is empty, it will not give me any value. For now, I got around this by using an If(isempty; 1 ; Evaluate (rest of calc)) Is this an expected behavior? If my question isn't clear, I'll post the calc. It's large, and not very readable though. ;-) Thanks

I've been working on this a couple of days and keep stumbling. If one of you would like to jump in and give me a boost it will certainly be appreciated. I want the checkbox in layout "Notes" to make the text of the displayed record to appear in the text box of the selected client in layout "Flag_This_Record". Obviously, only one note at a time can be "flagged" for any one client. Thanks. Flag_This_Record.zip

I'm working on a project for a film production company. We're creating a system to manage many aspects of their production, from wardrobe and location approvals to continuity to creating a shooting schedule. As you can imagine, we'll be storing and organizing A LOT of images. From what I can tell, however, FileMaker's ability to display images is rather weak. For example, I have created a file to track locations. Each record contains all the relevant location info. Photos are stored in a separate file and related to the location. Some locations have 500+ photos (we're working with the location mananger to get him to organize his photos better...), yet the best …

Hi All - I have a solution in which I lock certain fields, using validation by calculation, in a record when the value of a field is set to "locked". It works versions of FileMaker prior to 7. It is no secret that with FileMaker 7 field validation by calculation happens at time of record commitment and that field validation by calculation in versions prior to v7 happens at field exit.... I have two questions: 1. Am I the only one who finds this bad? My clients can spend an hour in one record, without committing it, making changes to fields without being told that they can't do that until the record is committing and having to Revert the entire record to …

Has anyone had a problem with the appearance of pictures in container fields using IWP? I have an image database published on the web using FMP 7.3 and FMP Server 7.3 Advanced. The container field has been formatted with the "keep image proportions" box checked and "reduce image to fit frame" selected. The images are imported using a reference. Pictures are appearing distorted, either squashed (for portrait format) or stretched (for landscape format). I have tried everything I can think of including rebuilding layouts, checking and double checking field formatting, resizing the images, nothing seems to work. Can anyone help please? I neglected to mention in the e…

I changed the name of an FM7 database file on my Mac hard drive. But when I open up various items, it still refers to the original name of the file as the database from which it is drawing records. Is this OK? Should I not change the name of a database file? Should I create a new file with a new name, instead? Am I headed for any trouble after what I've done? Steve

I am re-posting the following query I had posted a while back - to which someone posted the answer to my question. However, now, two weeks later, I am having a problem with part of it -so here I will post my original post and then the fantastic response I got: ME: "I need to create a serial # that goes up 1 according to its base. In other words: I have an invoice # that is RM-01-AB - It is a calculation that pulls the initials of the first name (RM) + Serial # + AB (referring to the type of product) However, I want the serial #s to go up per that person - so that the next one would be RM-02-AB. The serial #s need to be sequential for each client - I also w…

Hi, I just recently learned of a new technique with value lists and I have applied it, but it does not seem to be performing as I would expect. In my Database called E-mail List I have set up a value list that: Uses values from a field, then Include all values is checked, then a second field is referenced and sorted by the second field. Then in a related database, I set up a field, formatted the field as a drop down list and referenced the above value list. This works AWESOME...I feel foolish that I never knew you could do this before. By the way, I am in a server 7 environment. My question is, when I add records to my "e-mail Database" t…

I know that I can create a text field and auto-enter a calculation. (In my case it's get(UserName)) How do I auto-enter on modify only? I want to a field that shows who last modified the record.

If I delete all of the records in a table I want to reset the Auto-Enter Serial Number ID field to 1 (one). Also, if I only delete some of the records I would like the serial number to be reset to the max of the ID + 1. I feel like I saw this script somwhre but cannot seem to locate it.

Hello, I am trying to finish an order processing program for my little book store. I have used Outlook/Word to create an email with lots of hyperlinks that I wish to send to multiple customers. I thought that I might be able to store the file in a container field, and then reference the field when using the send email script. I'm a bit of a novice however, and I can't figure out if I'm even barking up the correct tree (so to speak). Can anyone lend any advice on this? Thanks! [email protected]

I am looking for a way to set a field across a found set. I want to be able to do a Find and then mark those in the found set to all have the same text in a certain field. I am also wondering if there is a way to have a dialogue box come up to create the text that will go into the field. A script that allows me to do this would be great - I have tried to build one but am having some issues. Thanks! Sarah

I am a graphic designer currently developing an FM7 database to track clients, jobs, invoices etc. In this system, each client / vendor has a two-letter code (unique) associated with them. This code is currently used in a simple calculation, combining it with a three-digit auto generated serial number to create a job number. For example, the first record would generate AE001 and the next FY002. In this simple model, the client code is variable, but the serial number always goes up by one. What I'd like to do is have the job number auto generate in increments of one, based upon which client is selected. For example, if I created a new record for client code AE, the j…

I am trying to figure out a way to do what I am calling a "conditional Calculation" I have a table for ALBUMs and a table for WRITERS. there are Many WRITERS for each ALBUM. For each writer I specify a percentage ownership and assign them to either group A or group B I would like a field in ALBUM to calculate total group A ownership and a field to calculate total group B ownership. This way when I pull up any album I will immediately see the percent owned by Group A and the percent owned by Group B ...For example. Writer 1 - 10% - Group A Writer 2 - 30% - Group B Writer 3 - 20% - Group B Writer 4 - 30% - Group A Writer 5 - 10% - Group B T…

How would I go about generating a random set of whole numbers between 1 and 8 as a calculation field? Thanks!

I have 4 fields that each contain 4 characters. When the 4th character is entered in field #1, I want the cursor to automatically jump to field #2. Same with fields #3 and #4. This is similar to entering a product code when installing new software. Can this be done?

Hi, I have searched the forums for how to do this, but I couldn't find the answer. Sorry, if it's been posted and I just missed it. I am making a simple document library, and I want to display the size of files imported into my container field (named 'Image'). I have tried GetAsText(Image), but all it returns is the file name. From other posts, I know that people are somehow getting file sizes using what looks to be the same method: http://www.fmforums.com/threads/showflat.php?Cat=0&Number=134712&an=0&page=3#134712 http://www.fmforums.com/threads/showflat.php?Cat=0&Number=133384&an=0&page=4#133384 The files themselves are imported, …

I want to create a field that will return a "1" if the date in another field is after 1/1/2005 and return a "0" if the date is prior to 1/1/2005. The argument in the logical functions do not seem to be able to treat a date like a number. If I enter (If "date field">1/1/2005, 1,0) for the calculation for the field I want to create, FileMaker does not seem to under stand the > or the < as greater than or less than in relation to dates. What is the "language" you need to use in a formula that indicates "before or after" a given date? Steve

Hi, When we create a new "order" it is automatically assigened a date with an auto-entry into the "date received" field. This order may sit around for "X" number of days before it is processed, but that time(except for a highly unusual circumstance) should never exceed 25 days before the order is actually "written-up". We have a seperate field for "date-written" that is manually entered based on the date a CSR will actually add the detail to the order. Sometimes though, through sloppy entry, a CSR will put enter a ridiculous date that throws off metric we track called "time to write up from received". I know I can validate this field with a range, but it …

Is there a function in filemaker that will allow the developer to tell if a record is currently a member of the found set? I know this sounds strange, but it's what were trying to do. A little backgound: We have a fairly large FM7 database. We are trying to add a "back" button to the solution to allow users to return to previous screens and found sets. The layouts are no problem, but we're trying to figure out a way to capture all of the entries of the key field for the found set. This can easily be done with a value list, but that returns ALL values, not just what's currently actvie. It can also be done with a loop into a global, or a replace into a field …

I've got a Value List created with a lookup value based on a self relationship. I can add a field with a popup menu set to that value list and it will pop up the required values. If i add the function to a calculation field with text output, its empty. Am I doing something wrong? Thanks!

I have a repeating field with the entries "yes" and "no". I need to do a new layout for a report listing a calculation field using the COUNT function, counting the number of "yes" entries and also the number of "no" entries. What would be the syntax of this COUNT function? [email protected]

Does anyone know of a calculation to determine US Postal Rates (Priority Mail) based on zip codes and weights?

Two questions. I'm not very good with FileMaker calculations... If I'm givin a tab delimited file containing a field that has someones name as - Doe, John - How do I use a calculation to take that field and and reorder the users names to John, Doe? Also, how would I go about taking that field, and seperating both the last and first names into their own two fields? Not sure what functions to use or how to go about this. Thanks in advance. ~Daniel

I have a text string that is a file location. Its something like X:usersfreddocuments, or W:filesgeorgeshared. I want to extract the user name from the middle of that. The user names are all different lengths, and the locations are all different, so i can't use an exact length right/left function. I need to basically filter everything before the second slash and after the third. Any ideas.

Hi I'm entering customer names in a database, and want to make sure that I don't enter duplicates. From a FirstName and LastName fields, I've created a calculated field called Full Name which just puts the two together. It looks like you can't define a calculation field to be unique (or can you?), so i thought I'd try and create a warning sign that comes up when a duplicate Full Name occurs. I've created a container field called Duplicate Name, and the idea was to define it so that when the Full Name field is a duplicate, "This is a duplicate!" is displayed in the Duplicate Name field. Only trouble is, I don;t know how to write that definition. Anyone got any ideas? …

I am trying to create a field in Filemaker that will give me a Yes no answer depending on a number from another filed. I have a date field that records the Death Date of an animal. I would like to link that to a field that reports Alive or Dead if the death date is entered. Can anyone help with this? Thanks

Hello everyone, I'm kind of new to Filemaker Pro. I'm trying for filemaker to round a number up. For example.. I have a calculation that I want the result to be the nearest multiple of 10. For example if it's 84 then I would want my result to be 90.. I'm not sure if this is even possible but any help would be appreciated. Thank You!

As part of a script, I need to find the count of # of records with certain code (i.e. Their inventory #s begin with AB or DC or JK, etc...). In the script, the inventory code is stored as a global variable - so that it is recalculated each time it is for a different code. The code field is "Series Initials" Their is a self-join relationship between the global variable and the Series Initials. Do I use Count (" ")? - is it: Count (global variable)? I don't know if this makes sense - any help would be great. Thanks, Sarah

Part I: Thanks to a recent post, I have been able to show the File size and pathway of my referenced image in a table. I am wondering if there is a way to show all of the information in browse mode without clicking on the field. Currently, it only shows 234,436, etc, etc... When you actually click on it, it shows "file size:.....pathway:...." etc....How do I get that to show all of the time? Part II: Is there a way to script it to print the actual file rather than the referenced file? Thanks! Sarah

I have a client who is supposed to be creating links to files into container fields. You click the button, then link the acrobat document to the field. The problem is the DB contains about 10,000 records, 12 container fields and is over 1GB in size. Some of the client's employees are not linking, but embedding and I need to figure out which to get the file size down. Is there a way to tell how big (in kb) a field is? Is there some other way to determine if the object is linked or embedded? I have been monkeying around with ExportFM trying to figure out how to export the field contents to try to tell me. Any ideas? Thanks.

is it possible to hyperlink the contents of a field? i want to set it up so that a field holds a website and clicking on it opens up a web browser...

Hi, I am a newbie to this forum and FM. I am trying to create a db with 3 columns of fields, namely, 'Date Received', 'Amount' and 'Balance amt'. With these 3 columns, user will enter the info with specific to these 3 columns everytime there is a receipt. The 'balance amt' will always be updated based on previous balance and new amount received. Can anyone help to explain how to create such a layout. I am looking at unlimited rows. Thanks.

I suspect this is an easy question to answer, but I can't seem to figure out how to initialize a repeating field without 'touching' each of the instances within a field. I have ~160 fields that repeat 42 times each. I want to create a script that will let me loop through an initialization process or better yet, invoke a command that will initialize all 42 instances at once. Any help would be appreciated. Arny

Hi, I'm a newbie with Filemaker Pro 7...I want to create a formula as follow: I have a value1 and I have a conditions to have a result in value2 If value1 is < 1 then the value2 is 10 If value1 is > 1 and < 5 then the value2 is 20 If value1 is > 5 and < 10 then the value2 is 30 and so on.... How can I make this in Filemaker?...Please help!!!

Two-part question here. I'm working on a layout scheme which has a two text fields ("User Name" and "Password") and a button. I also have two value lists..."UserNames" and "Passwords." I'm hung up on figuring out the button script calculation which says if the value of "User Name" matches a custom value in the value list "UserNames" and the value of "Password" matches a custom value in the value list "Passwords" then go to layout "Success." I've messed around with the ValueListItems function, but that either isn't what I need or I'm not getting how to use it properly. This is really just a way for me to allow certain users access to a particular layout so I don't thi…

Is there a way to do an IF function that says if text field X CONTAINS the phrase "blah blah blah", then value Y? Thanks, Jeff

Besides all the previous postings, tech articles and hints I struggle with a validation in FMP7... I want users to make "clean" entries by defining some "must" fields. Actually there are several portals in my solution and 2 of them should contain at least 1 record. As all of the dedicated fields (including the one that counts the portal entries) are calculation fields another field has to do the job. What I read was that a calculation should do it best, but so far it didn't work out. I tried almost every combination of the settings...at no point a validation on record level worked. Ideally I think of a calculation if my fields that count the portal rows are empty…

I have a portal which displays images from an image table. I want to create a small check box to place in the corner of the image in the portal row that when checked for 2 different images would show those 2 images side-by-side in a new layout. I have a checkbox field called "compare", a couple of global container fields and a script that says something like If Images::Compare = "yes" GoTo Layout ["Side_By_Side"(Images)] then a couple of SetField statements but I'm not sure how to script it so the first checked image will display in g_Compare_1 and the second checked image to display in g_Compare_2.

Using FileMaker Pro 7 and I am stuck. I have just about everything like I want/need it to be in my database with this exception. I have a field named Category. In this field I have a lookup to a table that gives me a popup list where I can choose from my different budget categories i.e. 7104 Housing 7108 Transportation etc. In the look-up table there are only two fields, Number and Description. From my look up, the only info that is input into the Category field is the 7104. I also have a field named Cat. Description. I want the information from my lookup table to go there, but I want the Description to go there. It would look something like this: Cate…

Hi all, today a bit bad luck! I was think about this issue all the day also can't done it, hope anyone can give me some good solution! Please take a look my attach file, wich you'll understand what I want to do, thank!

I have a FM7 files where I've create a batch printing feature. The user checks off a "print" checkbox on every record they want to print and then they click "print" and a script runs through the checked records and print them. Yea. Simple. But now I have more than one user printing at the same time. The checkbox is a field of the record, so when one user clicks it, it affects all users. It's a mess. Anyone have any bright ideas on how to fox this? I've been thinking of repeating fields, or User and UserData tables. Everything seems too complex. Also, I'm not sure how I would get the layout to work. The records are listed in a portal, I'm not sure how to put a fi…

Creating a database that ties invoices to client records for an auto detailing center. Each customer car is assigned a unique CarID. On each visit, an invoice is generated that is tied to that specific CarID. I'm trying to create a field that will be set to a value equal to the number of times that car has visited, by doing a lookup on the number of line item records in the invoices database that match the particular CarID. Each time a customer's car record is displayed, it should show the number of visits. Can't seem to wrap my head around this one. Any help?

I'm very new to Filemaker and databases in general. I need some help! I am trying to figure out how to "household" a large list of voter files (30,000+). Specifically, I want to combine individuals who live at the same address (and have the same last name) so that I can mail only one letter to each household. I don't care about maintaining first names (I will mail to "The Smith Family"). I'm a graphic designer who uses InDesign, Illustrator, Photoshop, etc. all the time , but have never done anything with database programs. Any help that anyone can offer is greatly appreciated. I've been trying to figure this stuff out from "Filemaker Pro 7 Bible" but find the terminology…

Hi, I have a list of records with amounts which are calculated using a different percentage for each record. Only 3-4 different percentages are used. I would like to display the totals for each percentage at the bottom of a report. I know that I can create additional calc and summary fields and get the result this way or sort the report by the percentage field. I would like to maintain the particular report design and just place the totals at the bottom. Any ideas gratefully received.

We have a work order system on an NT Server (4.0) using FileMaker 6.0v4. People can go on the web and request a work order. Some work orders require an account #. We have two areas where you put your account# into. People in one area do not use the text box from the other area to put in the account #. After someone puts in the account for one particular area, a service rep can not see the account # unless the click into it and delete the return. If it is not done... the account is not charged. I know why this happens. Both accounts fields on the web form reference one single field in the database (billable_to is the name). If one group enters their account first it is n…

Hello, I am working on report with week number. Does anyone know how to make a calculation field that can show the start date and end date by supply a week number and year? ie: Year 2005 Week 2 = Jan 2, 2005...Jan 8, 2005 Any help will be much appreciated! Thanks!

Hi, This has probably been asked, but I searched and can not fin an answer, so please forgive if it has been. Is there a way that I can display the result of a calculation field in either RED or GREEN based on the result being positive or negative? IF the result is a negative number I would like it to be red, and if positive GREEN. This is one of the first things I have ever found that is actually easier to do in Excel then it is in FileMaker. (at least of course unless I am missing something totally basic. Thanks, Steve

hi, lets cut to the chase...I work at a small marketing firm and we use a combination of filemaker 5 and filemaker server 5.5, we use these to track our customers and current jobs. we have a form we use for our job jackets (a job number, contact info, and some misc details on the project). Now for the problem our web developer/multimedia designer/IT guy/knows how to use filmaker guy recently left the firm and now I (i am a graphic designer) am left to pick up the slack until we find a replacement. so my question is our job jacket is labeled with a number, the year followed by 3 digits (04-***)...well its 05 now and we need to change the year in our job numbering system. O…

In the Field Definitions for versions 5/6, when we select the "Index On Demand" option, how long does FileMaker keep the Index it creates? 1) Stores it to disk & keeps it permanently 2) Stores it "in memory" only, then loses it when the file is closed 3) Stores it only for the operation that triggered the "On Demand" As I understand it, the answer is #2. FileMaker will keep the Index around, until the File/Database is closed. BUT, I not at all sure I am correct. Anybody know for sure?

I have a calculation that has some sort of problem - perhaps I have not set it up right. I have a value list of Address Type (Museum, Gallery, Studio, etc...). If the type is Museum - I want the calculation result to be "Collection" and if it is Gallery - I want it to be "Inventory" and if it is any of the others I don't want it to say anything. Can Anyone tell me what is wrong with the following (and also how to have the default result = " " (nothing). For some reason, when I try to create it, it says that it cannot define the field (highlight the " { " right in front of the second "Address Type" Case ( Address Type = "Museum"; "COLLECTION" {; Address Type = …

I'm an Advanced FM7 user (Advanced, not Expert), I have actually developed quite a few very nifty solutions, but, I've never used a Repeating field. I don't see what good they could possibly be. Can someone give me a scenario/example as to when you would use a repeating field? Maybe I'm just missing the whole concept of them.

Hi, After much trouble trying to get portal records to print within an invoice or quote, I stumbled upon Repeating Fields. If I want to use these as merge fields, can I? If so, how? If this is the wrong place for this question, please advise. Ta very muchly

I have a text field that keeps a sequential case number that is incremented by one for each new record (i.e. 05-00001). My question is this...Is there a way to have that sequential number reset (06-0001)at the begining of each year. i have done this via script and it works fine in house however I have some users that connect via wireless CDMA (1XRTT) and at times due to a sometimes slow wireless connection cause the script to reset the case number when it shouldnt. That is why I would prefer to have the field reset without using a script. Any suggestions? Thanks, Ron

I am a beginner at learning how do this. What I need to do is create something that calculates, counts, summarizes (what ever you want to call it) the number of stores that each of our managers is in charge of. I need to be able to do a FIND by store STATUS (Active, Open, Hold) together with the PHASE (Pre-production, production, permit, construction). In the end I need to find the number of stores that Jim, James, and Brad each have that are active and in pre-production. I'm sure there is a really simple way to do this I just don't know where to start.