Calculation Engine (Define Fields)

If I am in browse mode and I am cutting and pasting data into a field, however the formatting, i.e. font, font size and color are coming over different since the data is being cut and pasted from various sources how can I reformat the data to display uniformly in browse mode? Ideally I would like my data to default to one font/format whether I type the data or cut and paste. Any help would be greatly appreciated.

Hi, Hoping someone knows how to do this! I'm using the "registration" template for education. I need to add a unique student ID number or serial number for each person that is attending a class or event. I'd like to be able to search by and view this number on all reports etc... Any help would be greatly appreciated! Thanks! Brian

I have created a Script that allows me to see who's payment is due today, Perform Find[] Specify, // next payment due date. How can I subtract a specific number of days from the current date?

Hi all Have tried all sorts to sort this one... also can't find a solution on this forum - hence the post. I have imported data from email packages. Unfortunately the dates in the same field are in different formats. One set is dd/mm/yyyy and the other is mm/dd/yyyy. This leads to some interesting dates eg: 08/13/2006. I would like to convert them into dd/mm/yyyy. The first part of my calc is If(mainDate(month>12) so that the conversion only takes place with the incorrectly formatted dates but I can't work out the conversion calc that follows Any thoughts? Thanks for taking the time to consider this Best wishes john

Anyone have any thoughts on how to force one field's auto-enter calculation to calculate before another field's auto-enter calculation? Perhaps a better question would be...Does anyone know what controls the order in which auto-enter calculations calculate in a table? I have a field(Field1) that has an auto-enter calculation that references another field(Field2) in the same table. Field2 also has an auto-enter calculation, but I want Field1's auto-enter calculation to calculate using the data that is in Field2 before Field2's auto-enter calculation calculates. Make sense? Any ideas are welcome.

We are currently using FM 5.0 I would like to be able to create a report that shows me our customers last order and the number of days since their last order. The key is I only want the report to show the last order only and not all the previous orders from the customer. Can this be done? Thanks for any help

Hi, I'm hoping somebody here might be able to help. I just pulled up a database that is being shared with server 7 and all of a sudden 75% of the fields are missing. There are what looks to be place holders in the define fields section, but most of the fields are now missing. The backup we have is to old, does anyone have any idea what could have caused this? Thanks, Eric

Help! I've hit a wall with what I'm begining to beleive is a bug, but I'm not sure. Can someone tell me if I can do what I'm trying. The attached database is a minamal version demonstrating the problem. What I'm attempting to do: -------------------------- I have several rows of a table (slips) that have a name and cost. Well all but one have the cost filled in, I want to figure out the cost of the empty one; Example hg 10 lg 5 lg 23 kids x where x = 50 - (total of others) or x = 50 - (5 + 23 + 10) = 12 That part actually works. Now I want a second table (fees) that will have one entry with the total for each name (the two tables are joined o…

I keep a "worklist" of final photographic prints in Filemaker and assign each work a number in the form "class.year.sequence.frame," such that a given work might look like "3.2006.021.9774" and I would like to have a calculation field display the prior maximum value. I know that because I've used periods as separators, the value will display as 3.20060219774, which is a little awkward, but still usable. However, when I created a calculation field called "Worklist_max" and defined it as: Max (Worklist number), it only displays a value in records where I have already assigned a worklist number. What I would like it to do is to show me the highest prior value when I create a…

I feel there's got to be an easy way to do this but I can't figure it out. My layout has a simple text field which is blank. I want to to insert an "O" for "old record" into all of my "found" set text field. How do you do this? I know I can do it when I import data in, but I need to add this after the import. :hair:

Hi, How do I add a serial number field to a layout and have it automatically put in the serial numbers? Thanks, MT

Hi Team, I have table "products". Then I have another 5 tables for different kind of materials needed for production of the product. There are few common fields in material tables (as record ID, supplier, price but there are 4-10 different field which are specific for the given material table. Table product is related with each individual material table. What I am trying now is to set up a layout based on "purchase orders" table which should enable selecting materials from all material tables. I tried to create joining table for all materials but stuck with relational problems (many table occurences) and relations resulting in circle. I was t…

Hi, I'm looking for a way to see in a portal the last 10 added records. I was thinking on a calculation with the Max Function, but that is not working. Any Idea's .. Thanks Patrick

Hi I have imported an excel list with the first field being the person's Name. It contains Title, first middle and last names. I want to get rid of the title (Mrs, Mrs, Ms etc) which is always the first word so that I just have the name only Sometimes the field contains 3 words, but if the middle name is there, then there are 4 words in the field includinf the Title Can someone please help? Thanks

Hello Team, I'm looking for a good way to change date formats from; 20060922 to 09/22/2006 I've been playing around with the text and date functions within a calculation field but I'm getting nowhere pretty fast. Any help here would be greatly appreciated. Thanks. - Sez

The result of this calculation should be "9999/STATE/CITY/STREET". RightWords("ABC/01/9999/STATE/CITY/STREET";4) Instead, it returns "01/9999/STATE/CITY/STREET". However, it returns the correct result for these 2 variations: RightWords("ABC/01x/9999/STATE/CITY/STREET";4) RightWords("ABC/01/x9999/STATE/CITY/STREET";4) How do you get around this? (I am trying to extract the name of the Folder enclosing "STATE/CITY/STREET".)

hi! Sorry if this is NOT the right forum to post my question! I've been a member for a while but this is my first question..thanks in advance. I 'm a teacher trying to design a timetable for my school. it's a sort of a 5-day weekly plan where teachers can enter info about what they are going to teach throughout the week (lesson title and book page) ...Now if a teacher has two groups of students he can enter the same information for the two groups togther..( sometimes 2 teachers are entering the same info since they happen to teach the same level) One more question ... if one teacher (say science teacher) is giving a test on a certain day NO OTHER teacher of…

Hi all It's possible to check a field ( formatted as check box ) in a record in list view so that, if i'll check the same field in another record, that first field re-evaluates to uncheck itself ? That is easy with a script, but with AutoEnter calc and relationship ?

Has anyone re-created the graphic slider on the status area that toggles through the found records? It would be a very useful thing to intergrate into my database, as it allows a user to not only move through the records but also gives a graphical indication of the place in the find. Has anyone done this? If so how?? Thanks in advance!!

needing a calculation field that would always figure out what is the middle date. so if you had 2/1/06 as the start and 2/28/06 as the end, that it would like you know that the middle date is the 2/14/06. thanks

Hi all , I just make the [color:blue]Goods Receiving to my client, what I want to do is when they key in the [color:red]Cost or [color:red]Selling Price in GR, can I automatically update into my [color:blue]Stock Keeper Record field [color:red]Cost and [color:red]Selling Price? Hope your understand, Thank for help! test.zip

Created a portal with contacts in it. Created a button within each row of the portal record assigning the script 'Delete portal row' to the button. When I click on the button to delete the selected row it deletes all of the rows of the record.

Is there a way in Filemaker Pro to have it retrieve system information (operating system, hardware components,etc.) and auto fill the information into fields?

Hi, can I get a field to display the last date a record was modified without any user interaction, i.e they do not have to press a button to say the record has been modified

I know the total number of records is listed to the left in the tool palette. But is there a field I could use to show the total record count? Basically something that displays the total number of customers in the database? Thanks.

Hi there, I have a database where I have a field for Gender. The field can be entered by selecting "Male", "Female" or "Unspecified" from a pop-up menu. I am importing data from an existing database (excel file) where the fields were only entered as M, F and U. How do I tell Filemaker to automatically change the letters to words? (Eg. "M" becomes "Male"). I am sure a simple calculation should do the trick, I tried using a Case-statement, but it didnt work, maybe my implementation was wrong. Help would be greatly appreciated. Thanks! :

I have a child file of contact names usually there are less than 6 entries, sometimes 0. On reports I often throw a small portal to show up to three values. I'd like to create a calculated field in the parent that is a text summary of just the names from all the related contact records, and then the reports can just show the summary. Could anyone help with a recommendation on how to do this? Thank you.

I have a field that is populated from the web off a form using GetLayoutObjectAttribute... This field is then included in a meeting request for use in Outlook, basically an .ical file. This is what I'm importing: Case Summary: cust unable to browse* Description:*SAT:hzn* *TRANS:11 K *Software Version: *SERIAL_NUMBER: etc..... I have used the "*" to illustrate where my problem lies, in filemaker it shows up as a "square", I'm assuming this is some sort of unicode character. I thought it was a carriage return, but using the substitute function am unable to get rid of it. In ultra edit this shows up as a carriage return, not sure why the substitute isn't…

I've tried searching the forums but am not finding anything that sounds exactly like my situation - I'm not greatly skilled with FM, so if I am missing an obviously better approach to this, please let me know. I have a multi-table relational db set up to track artists' hours on various tasks as they build assets for the cg film we are working on. I have one table, asset_tasks, that holds every task (modeling, rigging, etc.) for every asset. So a sampling of the records looks like this: asset - task - actual hours box - modeling - 10 box - rigging - 12 house - modeling - 5 house - rigging - 3 The asset list and the task list are both populated from th…

I have a table that contains several different classes of images. I need to mix various images into one record in another table - It is a product catalogue that shows interchangable parts of a finished product. Am I best to separate the various classes of parts (images) into individual tables and relate these to the completed product table or is there a way to collect the required images from one table into a single product record in another table? I have it working the first way but would like to simplify the structure and updating process.

Based on a user's answers of 2 questions on (n) Records, I need (ValueList)summary results to be displayed on a fixed grid. I have downloaded the "Checkbox Summary" example and searched the forum, but not found enough information to help me get over the hump. I am attaching a base file and left out any relationship definitions in hopes that someone can get me going in the right direction. I have simplified my overall need to a 3x3 grid. Thank you very much, Robb Summary_Grid.fp7.zip

Is there a way to format a numerical field in browse mode so that clickling a little up or down arrow key increments the value of the field by one integer? This happens automatically for the year value in the pop-up calendar facility in FMP8.0 and I am hoping there may be a way of doing this on other number fields without having to create and define script buttons. Many thanks for any suggestions, George

Hello, I have been searching all over for an answer to this question. I am working on a membership database. There are three membership types: individuals, companies, families. I can't figure out how to set up the families layout when I have a couple who have different last names at the same address (John Doe, Jane Smith). I would like to be able to be able to find both names when I run a find so putting both names in a last name field would not work in a find. I'm pretty new to Filemaker but I know this has to be possible. Does someone have a sample layout? I am working off the contact template that was included with FM 6. Thanks, MT

I found the lower()and upper() function. I also know I could filter the data. What I want to do is replace the data permently. Current data [color:red]UNITED STATE OF AMERICA ===>United State Of America Any idea on function because I couldn't find it? Thanks Chuck

I have a script that I'm trying to setup to remind me that a backup of my data is due. The attachment shows my main script which is called up by another one. It is all based on 3 fields: [color:orange]SelectBackupDays - which is available to the user on a Preference layout that allows the user to select days via a value list: 5,20,30,60 or 90. This is set number of days that must be equal to or past before the user is prompted. [color:orange]LastBackupReminderDate - This is a date field that is updated with the current date ONCE the user prompted with a reminder. [color:orange]BackUpDatePreference - is a calc field with a number result based on (…