Calculation Engine (Define Fields)

Can anyone throw some light on this problem? I have a simple table of addresses, linked to a person table. There are two auto-enter by calc fields. One is Line1 & Line2; the other is Suburb & State & Postcode. Really complex stuff. Both have 'do not update' unflagged. Both have do not calc if all empty. The basic fields are entered in a portal when new people are added. Recently, for a new batch of people, these calcs have stopped working on initial entry - but only for some people. On my system, if I change the Suburb, for instance, the calc works. At first glance, it looks as though the Address records in the portal are not being committed - ever…

Hi forum, Ok this should be SIMPLE, but on closer inspection its not. I have 2 Fields, A and B. If A="allow input" I want the user to be able to type something in Field B. If A="dissallow" I want the user to be blocked from typing something into field B (just in the way as if "dont allow mods" was clicked in the field definition, which of course, for field B, is not clicked). I tried it with overlaying a calculation container field over Field B with a color, but if A=disallow, one can still click in it. I could then check for mods in that field with a validation but that is suboptimal because it still allows the user to put something in in the firstplace which…

Hi! I'm using Windows 7 and Filemaker Pro 10 Advanced. I'm having a field "Phone 1". This field is for local Mobile Numbers (10 digits) As someone enters a number XXXXXXXXXX, I want it to reformat automatically to XX XXXX XXXX. What kind of calculation do I need to do... I'm brand new to calculations... Thanks for all the help I can get! /Fred

I have two tables which relate to each other. I want to get a value (cost comparison) which is an average weighted by quantity (for one month say) for a matching item into one of the tables - tables are matched . I have no idea how to do this - sorry! Can anyone help? let me try and give an example. File 1 has a list of items e.g. products: laced shoe, trainer, sandal etc; colours: brown, white, fawn etc; sizes: 6,7,8,9,10 etc (these are also the matching fields in the other table) but it also has, for example, a field 'price paid'. Now what I want to do is add in a field 'latest cost' which is an average of the cost data picked up from, say March 2010, in another ta…

I am new to FileMaker (using FM 9 Pro Advanced)and have a db that I brought over from Access. I am having problems knowing where to go with my report. I have customers that pass referrals to us. I need to create a report that shows how many referrals are given each month and the outcome of those referrals (25 poss outcomes). In Access, I did a pivot table based on the month and outcome. In FM, I "think" I need to create new fields. To get the month from my date field, I think I need a MonthName. Beyond that, I am confused. Is GetSummary the way to go? Also, I am having trouble with FM terminology. Would my breakfield be the customer? Thank you in advance for…

I have a table of photographs with timestamps. I need to mark a single record that is in each group (anyone will do for now). The group is defined as a set of records that has a sequential sequence, where each neighbouring record(by time) is less than 5 seconds apart. i.e. The camera creates bracketed image groups at different exposures and angles every 4 seconds, using a mechanical automatic panoramic device (each photograph combines together later create a single HDRI panoramic image). When viewing a set of images in fm, i only want to see a single image from this group. If i was able to create a separate ID for each group then that would be great -…

I've had a search of the forums, but the details of this problem make it hard to find an appropriate solution. This is related to my previous topic in the layout forum: http://fmforums.com/forum/showtopic.php?tid/214304/ As noted above, I'm trying to produce a quote/invoice layout which looks like this: Descriptive text for service 1 Item 1 service 1 12m £5 Item 2 service 1 5m £4 Descriptive text for service 2 Item 3 service 2 4m £8 I'm still open to suggestions which would enable this entirely within FM, but my current plan is to export the relevant data to a word-processor and merge it into a …

Hi, I'm looking for a way to lock the value of a field pass a certain date, the date would be coming in from another field. Has anyone try this before? Yann

I am trying to clean up text that contains some html code. How do I remove multiple occurrences of “< any characters >”? I am currently using a calc field containing: Let ( text= Trim(Substitute ( Descriptiton__lxt ; [" *" ;"¶" ]; ["*" ;".¶" ]; [""" ;"'" ] ; ["’" ;"'" ]; ["

Hi All, I need help with a calculation, and to be honest i don't know if its possible. I have a Birthdate Field, and Member Date Field for over 2000 members. I just created a new field call "commensing field" what i want this field to provide me is a year of when any member will be an Honorary membership. If order to be an honorary memeber, a member has to be older than 75 years of age, as well as 25 or more years as a member. So with that said, this new field has no provide me a year that will tell me the year that member will be honorary. Any ideas how i would start this calculation. My first idea was an if statement, but creating one i…

is there a way to truly convert the contents of a field to title case instead of changing its style (which doesn't really change the contents)? I need to apply this to a headline field that is always in All caps from the source. The problem with changing anything to Title case using styles is that there may be a word that needs to be in all caps (EPA, USA, FBI) so someone has to manually fix them. But if you apply a style, there is no way to change just one word. Also, FM's Title Case function is a bit dumb, it sees a quotation mark as the first letter of a word and will then change what it thinks is the second letter, the first letter of the word, to lowercase. …

Hi All, I would like to know the best way to deal with the format of a date field. Is there a way to reformat the date on entry to include leading zeros so that they can sort propperly? Thanks for any help :

Hi I have many sell records which start from 1 feb 2009, until now I want to count no. of month(it should be 15 months) in the calc. field but I don't know what function should be used. By using month(date), I face the problem of different year and can't count month. I need your help. Thanks.

Main table is types of vacuum tubes. Related table is ownership of various brands and shapes for each tube type, with a quantity field. Related table has summary field that calcs total of the Quantity field. This total changes as found set in main table changes. Primary layout has records of main table, with portal for related table. On this layout, how can I show total of Quantity field, for all records in main table, even if found set is less than all records ?

Aside from the fact that it is not very elegant... it's not working. There must be a major syntax error which I'm not seeing. Any ideas? Status = Case ( not (IsEmpty(Invitation Email Sent Date)); "Invitation Sent"; not (IsEmpty(Invitation Email Sent Date)) and (Invitation Response = "Received"); "Invitation Accepted"; not (IsEmpty(Invitation Email Sent Date)) and (Invitation Response = "No Response"); "Invitation Declined"; not (IsEmpty(Invitation Email Sent Date)) and (Invitation Response = "Not Received"); "No Invitation Response"; "Pending" )

BASIC SET-UP Table 1: Contacts Table 2: Grant Rounds CHALLENGE In my contacts table I have a field to specify the contact type, such as Applicant, Grantee, Nominee, etc. It's one field with check-boxes that originate from a value list. I'm looking to populate this field automatically based on related records - and hopefully without intense scripting. EXAMPLE There's a contact record for "Thomas Meyer", and there's two Grant Round records which are linked through Record ID to his contact record. In a field named "progress" (name doesn't matter) one of the records contains the string "Applicant", on the other record it's "Nominee". This sho…

Hey All, I'm by no means a pro at this, so I would appreciate some help finding a solution. I am creating a database which will contain a sequential set of commands for a group of people. The database needs to be editable. I think the best way to describe my problem is by example. Say I have 10 records. In rec2: Field 1 = "ON" In rec5: Field 1 = "OFF" In rec8: Field 1 = "ON" I'd like to make use of conditional formatting so that in rec2 through rec4, a field is bold, then in rec5 through rec7, the field is not bold, and so on and so forth. I don't know how to make it look back in the sorted list to see what the last non-empty record is.…

Not quite a newbie, but have more experience with Version 6 and earlier. I'm able to use portals and relationships OK. Somewhat confused on tables but think I'm OK on this. I have trouble with Get function for calculation fields. I can make broad ones work such as Get Filename, Get Application Version, etc. Some that I can't make work are centered around fields, portals and repeating fields. I suspect my problem is a gap in my basic knowledge of V7. Below are results for my calculations. Hopefully you can spot a pattern and give me a clue. The test file (parent) is simple. A single relationship, single table, single portal, single repeating fi…

Is there any way in Filemaker to define a field to be the text equivalent of a numeric field. For instance if I have a field with the number "100" can I have another field defined to say "One hundred"?

Hi all... I am working on making a time clock for my company. Everything is working fine thus far except calculating how many hours for the current pay period. I have 2 fields, one containing the begin date, and the other, the end date, I then have a calculation field for calculating the hours in that period. Given that each week is on a separate record, and our pay periods are 2 weeks, how can I make a calculation look across multiple records within a certain date range?

Hopefully I can explain this situation fully. I am building an invoice solution and am having problems getting some of my calculation fields to update without having to first save the main record. Schema Summary Main Tables: - Transactions - TransactionItems These tables have the following relationship: Transactions::Id = TransactionItems::TransactionId Each transaction item has a TaxCode, so I also have two instances of the TransactionItems table: Tax1_TransactionItems Tax2_TransactionItems These tables instances are also related to the main Transactions table but only contain items that match either TaxCode 1 or TaxCode 2 In the T…

Is there a date function that will automatically calculate a fiscal year? I have a report that details quotes and their values. i want to sort the quotes by fiscal year (09/10 and then 10/11) and then sub sort by Month. I have found the MonthName calculation, but cant find anything specific for fiscal year. My searches through fmforums have found only complex fiscal year calculations. is there something simpler?

This is beyond my basic scripting skills. I want a field with a serial number in it to reset each time a different field is changed from the previous record. More specifically, I have a field that contains a drawing number. I have a button that inserts the data from the previous record into this field. The drawing number might be the same for 80 records or just 2. Each time it is changed to a new drawing number I want the serial number field to reset to 1. Any ideas? Thanks!

I know this has been answered but can't get the Search feature to cough up the right results. Give a birth date and Get(CurrentDate) what's the calculation for an exact age?

I need to create a parent text field [Parent Table] that combines the first names of all of the related children [student Table] for use as a Merge Field in letters. Example: Dear Mrs. Smith, <> have been doing very well in school. I've always wanted to know how to combine fields from multiple related records but have never figured out how. Any help???

Hello, I was wondering if this could possibly be done without using a custom function such as "(timemask(textfield); an example would be that an input would be "0305" which would be outputted as "03:05AM". Due the absence of owning a copy of Filemaker advanced edition, the custom function is not currently an option. TIA. Jack

I've created a database that has a line item entry containing a field for Type. This field is populated using a value list that I've created. My ultimate goal is have to a calculated field that will contain only 1 occurrence of each type of item on my line item list, but the List function is resulting in strange behavior. I have a total of 10 line items encompassing 5 different types. Using the list function my calculated field displays some values as repeated and other values only once, leaving a total of 7 values. Obviously this is less than my total number of line items, but there are also repeated values in my list. Any idea what's going on?

Is there a way to create a calculation that will pull in the contents of a text field, concatenate it with a container field (that holds an Internal image) and then have that calculation result become the body of an email? I am trying to create an email that lets the user write a piece of text and then choose a graphic to be included (not attached)in that email text body. Any ideas? Using FileMaker 11A.

i what to run a script that will take the layout name into a Variable and then put the filed name. " Set Variable [ $lay; Value:Get(LayoutName) ] If [ IsEmpty ( $lay & "::status1" ) ] Show Custom Dialog [ Title: IsEmpty; Buttons: “OK”, “Cancel” ] End If " where is my error?

I thought I figured this one out…but…no I have 3 fields – book number, revision, page number I do not want duplicate combinations of these three fields so I thought I would set up a calculation field containing the data from these fields and use that to not allow a duplicate record to be created. But I can’t validate a calculation field. Is there another way to accomplish this? Thanks in advance

Howdy, howdy: I have a field in my solution that records URLs, but it gets unwieldy when printing their paths, which can be very long. What I need is a separate calc field to truncate the text so everything after .com, .org, .net, etc., is deleted. How do I do that? TIA for your help! Rich

Is there a way to convert data in a text field to date? I have a text field with the data 2009-10, which should read October 2009. How can I convert this data to a date field (Oct 2009)? Thanks.

My apologies if this is the wrong forum for this. I did a search of "time tracker" and "timer" without success. Is it possible to create a (start/stop) task time tracker with FM using the computer's clock? It would be ideal for linking to project budget monitoring and billing. Thanks. Leonard

How can fix the below calculation to round the result to a two decimal number? For example: 02:00:00 x $80.20 = $160.40, NOT $160.412457457 (I know the numbers are not accurate, just for sake of example) My current calculation: n_rate_hourly * (Hour(t_time) + (Minute(t_time)/60) Thank you for your help!

I need to calculate days between dates excluding weekends and company holidays. I have a StartDate and EndDate in my initial database. Do I need to set up a lookup table listing the company holidays and how would that look in a calculation? Any help anyone can give me would be greatly appreciated!

Okay so I am just trying to get a script to be able to look through each task record and get the task ID and then paste the task ID to a custom dialog as a type of alert system. So basically the user clicks a trigger button and an alert pops up using custom dialog or however, which then tells them each task ID that is associated with their name... I can't get the field to concatenate each of the previous ID's in with it, it just pastes the last field read. Any ideas? Thanks. The Fox

Is it possible so that a user can select the fields and order of concatenation in a table? For example I have 3 fields, Name, Pet, Equipment. For example the user may wish to concatenate the fields in this order Name Pet Equipment or in this order Equipment Pet Name.

Hi all, I have to change a database that was developed in 2003 and is on FM 5.5. The basis of the change is that a tax that was applied in 2004 is now being removed so I thought that should be simple, just base the calculation on the dates that the tax was applied to. Wrong It doesn't work, can any one see the error in the calculation. Case(Invoice Date>01/04/2004 and Invoice Date<01/04/2010; Trace Fees *.14;0) At the moment it just removes the tax from all of the invoices

I am still using fm6, because I can not convert greek text to the next fm versions. Does anybody know a solution?[color:blue] : My convertion results in attached file. 2010-02-03_101859.pdf

Trying to figure if there's a simple way to get the first and last records on a page when Filemaker is in Preview mode; idea is to put that info in the page header for quick-scanning purposes. It's pretty easy to do for a subsummary part, by using summary fields for Min and Max, but I can't figure out how to extend it to the entire page. Any suggestions? Many thanks!

Hi, I want to generate bar code without using barcode plugin.can we perform this kind of operations in filemaker if yes then plz help me out. Regards, John Wiliams.

I have a check-box set as a list of a bunch of different options for people to choose. How can i make it so that if for example they choose faculty, when they select that check-box another check-box field will appear so they can also choose past or present. So in other words, one could click on Faculty and then once they clicked on that, a check-box field with the options to specify if they were past or present faculty members would show up. If they unchecked faculty that check-box field would go away.

I have a sales table that totals, with a summary field, the quantity of items sold to date, sorted by the item's SKU. That is: Table 1 - Total Shipped_Title Sort (Summary) - Total of Quantity (running with restart), when sorted by SKU. On another table that also uses the SKU, I've used a calculation with the GetSummary function to show the quantity sold to date for each item. That is: Table 2 - Total Sales (Calculation ) - GetSummary ( Table 1::Total Shipped_Title Sort ; Table 1::Total Shipped_Title Sort ) But, I'd also like to break down the sales by year. On the original table, I created a summary field that appears in a sub-summary part that sepa…

Hi Everyone, I have created a script to export the line separator etc following this thread here http://www.fmforums.com/forum/showtopic.php?tid/192649/ As per my notes.pdf in the zip, I need a line break, not a paragraph break to be exported from filemaker. I suggest using note++ to view the "actual" link exported to see what I mean. Please see attached zip file which includes: [color:brown]Notes.pdf [color:purple]Notes about the problem Script.pdf Field.pdf !DO NOT DELETE - FM_Data.xsl [color:purple]style sheet I'm using to export 1279826.nrl [color:purple]Example link 1 1351098.nrl [color:purple]Example link 2 Export.fp7 [colo…

I have a portal that displays a list of people depending on certain checkboxes I select. How can I take the contacts listed in the portal and copy their email addresses into a "TO Field" so i can send a mass email to the people that were listed in the portal?

I am looking for a way to create a field ( that displays the Character Count of another field (A). I want B to display the character count of A as you type in A. Any ideas?

I have a drop-down list of school grade values 1-12. Is there a way for the grade to automatically increase by 1 each year so I do not have to go back and updates all the childrens grade every year. In other words if i set a child to be in 1st grade is there some kind of calculation I can set to make that field increase to grade 2 the following year automatically without having to manually do it myself?

Hi All, I've got a portal where I use "@@" to number each item. My question is relatively simple... is there any way to return this number either in a calculation or in a script? I need to use it. Thanks!

In a field I want to display a rounded up or down value that is the product of One field divided by another. I do not see how to display the results field as a whole number or specify how many decimal places in the field. WHere do I place the rounded function?

I have a date formatted as 18-MAR-2010 in a date field, I also have a text field with text in it. I created a calculation which combines these two fields into a third field. My problem is that I lose my date formatting once I get to the third combo text field. Is there anyway to hold on to that format or reformat the date portion once it is in the text field? This is the calculation I have for the text field - (Transmittal Date & " Group " & Transmittal Group) Thanks

I have a list of contacts. There is a field called constituencies that is a checkbox set of values. (Faculty, Staff, Student, Alumni, Parent, Donor etc...) The contacts may choose all that apply. Now I have another table to review these contacts with constituency as the primary key linked to the other table constituency field. This field is the same checkbox set. I have a portal that will display the contacts based on what checks are selected. The problem is that I cannot get the portal to display contacts exclusively. For example if i select alumni first in the checkbox I want the portal to display every contact that has the alumni attribute select. Then If i check anoth…

I'm weak on calc knowledge, but here's my goal. I want to display related field data in a tooltip as a hard returned list. The tooltip is formatted on the Partnum field in LiveJobs. I want to show all related historical partnums and thier release dates. I currently have data from the first related record showing in the tooltip: History::Partnum & " " & History::ReleaseDate How can I make the tooltip calc display data from those 2 fields in a hard returned list from ALL related records? TIA.

Hi, I read the help from FM documentation, but it is not clear. What is the difference between the two functions? Thanks

Newbie here. I've read and can't find an answer to this so I apologize if I overlooked a previous similar q&a. My table has a field called "type". There are only two options on the value list, either "tractor" or "trailer". I need a calculation field to show how many "tractors" and how many "trailers" when viewing them on a portal. Any ideas?

Hi, How do I show something like 'record 2 of 876 records' on my layout? I've use a Summary field to get the number of records in the found record set, but I would like to show the user where they positioned are within the found set. TIA

Forgive my incompetence, but I'm having a difficult time understanding the difference between the "total of" summary field and the option for "running total of" field??? When would you use one over the other? In my fm solution, I have records which have a field for hours of work. I want to have a summary total of all of these records when I filter the database within a date range. Both total and running total seem to work correctly. I can't figure out the difference between the two. Thx

Hi, Simple question, is there a way to get the system decimal separator? Thanks

I know how to create a relationship by date fields in the parent and child tables, but am unclear on how to create a relationship based on a calc for a date range, ie the way the calc would be written -- I think globals would be involved. I wonder if there are any readably apparent calcs I could use? Thanks in advance:)

I have a problem. I've made a "Preferences" layout where all the icons and logos are stored in container fields (global storage). I copy-pasted the icons to the containers. But every time I close the file and open it again all the container fields are empty. How can I preserve the data in those ?

I'm not sure how to create this. I have 3 fields from the same table on a layout - 2 drop downs (A & :& one edit box ©. Also involved but not shown is another field from the same table (D). The user will select A & B , fill in C, then click a button. I want the button to find records that include the data from the two drop downs(A & B ) then take the data from the edit box© and put it into field D of those records. Any ideas? Thanks in advance.

HENRY SMITH JONES BURTON-GOODRICH How can I build a calc to change these 3 example last names to proper case? The first two I know how to do, but when the field contains a - dash between two names with no space, I cant quite figure that one out.

Hi: I can figure out how to delete the last 2 words in a field. I created a field called "company2" I'm trying to delete the last 2 words in the field called "company". I'm using this calculation but the field is blank. RightWords ( Company; -2) Company field contains ABC Products Inc. Would like to have the calculation in company2 field result in just "ABC"

Hello, I have now been running my database with no great issues for nearly a year now. I now have a problem which I am sure is easy to fix however have been unable to figure out. We had a VAT (tax) change here starting 1st January 2010, I could change the calculation no problem however it changes all the database records so when we look back at old invoices it has the incorrect VAT on it. Can somone advise how to calculate the VAT field @ 15% for invoices raised before 1st Jan 2010 and 17.5% for invoices rasied after 1st Jan 2010? Currenlty the VAT calculation is: nett amount * .175 I have tried to use the "if" function when making the VAT calculatuion h…

I am aware that FileMaker can modify dates, for example, fora date a year later: (date + 365). However, in the case of a month later: (date + 30) does not return the same day a month later. Is there another way to calculate this requirement?

Is there a way to check if a user view a record from a separation model and not the data file itself?

I have 3 fields 1) Time In 2) Time Out 3) Total Hours I know this sounds basic, but I am getting crazy figures in the total hours. I did the Total Hours as a number with a calculated value of Time Out - Time In. I thought it would be a simple calculation, but it comes up with things like -12987 when I put in the time in as 07:00 and the out as 18:45. Any suggestions??

I'm an old programmer from the PL/C days. I've been spending time over the past few days looking up recursion as it works in FileMaker. I have an application that has a record id along with a father id and a mother id. I would like to write a recursive function that would go through the table assigning a relationship identification to each record. For example, the father record would have a "F", the mother record a "M" the father's father's record would be "FF", the father's mother's record would be "FM". I know this type of activity can be accomplished using recursion, but I'm getting stumped in how to pass the id's to the calculation. It appears in Fil…

Is it possible to fill a field with a global variables using auto-enter calculation? I know it's possible with a local variable in a script, but I have not been able with a global variable. Thanks

This should be really easy, but i cant figure out how to show in a field different tekst based on a field with the language, lets say i put in US i would like a field that will change to INVOICE when i insert FR it changes to FACTURE NL will insert FACTUUR ect, i would like to make a language depending invoicing system, now i have a layout for US,FR,NL ect but its really inconvenient to work this way. Hope someone can help me out on this beginner stuff. Best regards, Maarten

Hello everybody I have a simple formular: Let([ fwn=Get ( CalculationRepetitionNumber ); ]; Vorlagenmatrix[fwn] ) Fielddefenitions: (1) Vorlagenmatrix | Text[24] (2) SomeFieldname | Text[2] | Auto-Enter Calculation replaces existing value (3) SomeFieldname | Calculation[2] | from Tablename, "The formular: Let(...." The calulation at the top is used with SomeFieldname. Now I have two different scenarios: 1. Using Fielddefinition number 2 Result: [color:red]Only the first repetion of the "SomeFieldname" will adapt to changes made in the Fields of "Vorlagenmatrix" Now I change the type of SomeFieldname to "Calculati…

I am looking for a function or calculation to determine if a text string contains any alpha characters or is all numeric. The implementation is for a check number field that will automatically increment by 1 for each new check. If the previous check is an electronic transfer there will be no check number in the field. The result is the next check number is 1. I want to keep the previous numerical check number stored if there is an alpha character in the field.

I have a complex database that is getting above my reach. I have a pay rate field, that puts every employee into a rate list, which determines what they are paid for each job. I have a drop down list to choose what room they are working in (rooms) and this is filtered by who is logged in, therefore only shows the list of rates for that employee. But I also need to further filter the list by only showing the rate for the room they select in their time sheet. So a rate is determined by pay rate, room, then of course number of hours. My list now shows a pop up of all the possible rates for all possible rooms, and I would ideally just like to filter the list by the …

This seems like the most simple thing in the world to do, but for some reason I cannot take the sum of two summary fields and get them together into a total! I have created a report to document the number of phone calls in a specific location for my users. In my report I have two sub-summarys from my master layout; staff member and location. I've created two summary fields to tally the total specific types of calls that were made for each user in each location for a specific date range. Now I want to create two additional summary fields; One that simply adds the number of calls for each user and one that calculates the total amount of calls in a report. I've …

Anyone know of a function to return all occurrences of email addresses within a text field. The one at http://www.briandunning.com/cf/828 has some problems.

Hi! I have tables: 'Orders', 'Quotation' and 'Adress'. 'Orders' and 'Qoutation' can make new records in 'Adress' if user push a button. I want to FM count the records that contains the same company at the 'Orders' table and show the result in 'adress' table. (wich is in list view). Example: No.__Company__order count 1.___Mercedes__10 2.___Audi_______50 etc. I tried this formula but it's give a fake result: Count ( List ( Orders::Company); Company ) Anyone can help me?

I there a way to create calculation a field to display the current mode: browse, find or preview? I know the result must to be stored globally in order to display it in find mode. I have played around with the Get (WindowMode) function but can not seem to get things to work out. Any ideas? Thank You Anthony

Hey gang, I am attempting to achieve in Filemaker, something that is rather simple in softwares like Excel. I have a table with sales figures for a group of sales people (over 200) that I import sales data into weekly. I tag this data using a date token (1252010 for example would be January, 25th 2010). I am trying to get the database to spit out a total for sales revenue when the date is equal to 1252010 (week 1 of our year). The desired outcome is to be able to display total sales by week in a separate table. This database is quite meaty so suggestions on how to restructure probably wont be the best solutions. Any help would be appreciated.

I have some fields that cosmetically have very little room around them and would like the title of the field inside the field until text is entered. Anyone know how to accomplish this?

Greets, all! I'm temporarily using v9.0x of FMP so maybe there's a command or script step in v10.x that I don't see here, but how can I capture the Object Name of say, a field label or button to use in a calc or script? Fictional example: If(ObjectName(test::fieldlabel))="Whatever" Set Field[test:fieldcontents; "as if"] TIA for your help!

I currently have a date field with a drop down calendar that is used as a "closed date". This indicates when a file is closed and billed. We have to close files within 30 days but some of the users are back-dating the date to fit the 30 day window. I could take away the permission but that would create more work for our billing person. Is it possible to lock the date field and calendar to the current month?

I have a person working for me that no matter how many times I tell her she must enter a date as "x/x/xxx", she insists on typing out the month name, "Jan or January". Since this date is inserted as part of a script, I would like a way to filter what ever she types, to match what everyone else types. It seems simple, but I just can't find it. I spent yesterday looking and experimenting, but no go. Just point me, and I will try and find my way. Note: I have used the drop down calendar, but she would rather type. I can't fire her (my girlfriend's sister), but I am at the point I am considering looking for a new girlfriend.

How can I capture a current balance in a point in time? Tables: Customer, Order, Item Each customer has a starting balance, as they place orders, there balance is reduce by the price of the items. I need to report monthly, the beginning balance for each month, and show the Items and the ending balance. I understand how to build a report for all transaction. If I only want to show one month, how do I capture/show the balance at the beginning of a given month?

I was not sure where to put this question and I am sorry if it is the wrong spot. I have about 500 records and each record is a different job. Each job has a Job Status drop down that is linked to a value list. (Not Started, In Progress, Installed, Completed, F.L.O.S) The field is named WorkOrder::JobStatus I would like to have kind of a reports page that people can go and see a total number of each. I tried creating new calculation field with the following: from WorkOrder, = ValueCount ( FilterValues ( List ( JobStatus ) ; "Installed" ) ) With this I always get either a 1 or a 0. Any ideas would be great. Thanks!

I am trying to setup a calculation that filters out the data in a Text Field from entries in a Value List (i.e. provides keywords from an associated list). The data in the Text Field is NOT position specific and the list of potential keyword values is hundreds of entries long and will be changing over time. So I generated a Value List based on entries for values entered in another table. The "ValueListItems" function works well to provide a return delimited list of the entries in the value list but how do I turn this into a Filter command that requires the filterText to be a list of values each surrounded by quotations? Filter ( textToFilter ; filterText ) …

Still struggling with the FMP 6 to 7-9 blues. I have defined a checkbox field, but the boxes do not show. In FMP 6 there was an option to show the box outlines, but I cannot find that in FMP 9. How do I get the outlines for the boxes to show?

Hi I need the following and I think I can do it in a calculation field, but have also thought of a script. Field A is a date field. I want field B to contain the date of field A minus 60 days. But if the new date is less than today's date then it should display today's date. Can anyone help me with constructing fiels B? Kind regards, Mille

How would i go about creating a calculation that is based on the Text Color. So for example, if a field text color was black, then the value is gained, but if the field value is red, then the value is left empty. I thought of using CF, and setting any red text to white to make it invisible, but i actually need an empty value instead of an unseen value. I have tried several different calculations, what i though might give me the result, but i have yet to get the correct calculation.

Hi there, I've been reading all possibles forums trying to find a solution for my conditional summing, the problem is not so different but i don't know why I can't get it to work. like this in 1 table: A field with "IN" and "OUT" as a Radio Botton Set A field with the Value ( number value ) What I want is to make two new fields that gives me the sum of all INs and all OUTs in the table: Sum IN Sum OUT Thx!

Hi there, I've been working on a calculation to convert timecode into minutes and seconds, but am having some problems getting it to resolve properly. The calculation will round up to the next second if the number of frames is >= 15, roll over to the next minute at 59 seconds, etc. That's all working well, the problem is the calc is inserting zeroes in places where there shouldn't be any and removing them where there should be. Check the screenshots below for some examples: The format I always want it to return is double digits for both minutes and seconds, like "02:42." The reason why it isn't I think has something to do with the fact the source f…

Hi everyone We are new users of File Maker Pro 10 and we've got a problem, we hope you can solve. Lets say: we've got two fields. Field A and field B. We calculate field C, using field A and B in the calculation. Now we want to change some data in field C but filemaker pro shows us "not modifiable field" How can we nevertheless change data in this field C? Hope you can help us! Thanks Femca

I suppose something like this might work but my chr13 is wrong... I trying to remove those phantom returns in a text field Substitute ( g_pass_verify ; chr(13) ; "" )

I am FM challenged and would appreciate a shove in the correct direction re: a couple of date formulas/calculations, if possible... The first is to create a new date field by adding two years to an exisiting date field. The second is to create a new date field by first searching multiple date fields, confirming all contain a date, then finding the oldest date of the multiple fields and adding two years.

I don't use repeating fields much, so this one's got me beat: I have one repeating field with, let's say, 3 repetitions. Each rep could have a 1 or a 2 in it. I have another 3-rep field that's a container calculation. If there's a 1 in the first rep in the first field, I want a specific picture to show up (stored elsewhere) in the first rep of the second field; if there's a 2 in rep 1 of the first field, I want a different picture to show up in rep 1 of the second field. This works fine for repetition 1 of both fields, but how do I construct the formula for the container field so that repetitions 2 and 3 show a picture? Thx.

I'm stuck in my though process... What's the easiest way to remove any number of leading "0"s from a string? 005602 or 00067800

Is it possible to create a script to have the selected field with "TextStyleAdd" result(without specifying field name under TextStyleAdd)? Meaning, I want to make the text Bold by selecting any fields in records and by triggering the script to have them make the text Bold. I don't know if this is possible... Thanks in advance. John

Hello, I hope you guys can help me. I have created a date field that needs to trigger an email 10 days after it has been populated. First off is this possible using conditionals and if so what is the best way to write this? Your help would be greatly appreciated.

Hello everyone. I'm assuming this is a calculation question but if not I'm sorry.. I have a database I'm using for my firearms which contains info. about maint. and cleaning in two seperate portals just so I could keep track of them better. Now what I'm looking for is to pull the last date the firearm was cleaned and had maint. done on it automatically. Can this be done? Or is this another item I need to have to calculate manually for each record? I can't seem to engage the brain in order to figure this out. I'm sure it's stupidly simple that I will kick myself after the first response! : So I thank you in advance!

I am getting an FileMaker error message when I change field data in a window. At the same time another window with the same record is open: "This record cannot be modified in this window because it is already being modified in a different window." Is there a way to solve this problem without closing the windows? Any help would be appreciated. Cheers Greg

Hi everyone I hope I am posting this in the correct place - apologies if not. I have a couple of fields in my database, call them field A and field B. Field A contains a file name which may or may not start with letters but always contains an underscore and then some numbers. I need to copy the numbers after the underscore to field B. How should I best go about doing this. Many thanks Milt

Hi There, I'm new with FM10. I've created a data base to track daily Money Order sale. So everyday i enter the date and the sale of the day. i want to run an up to date total for that month and also look back previous month via enter two dates or enter the month. Please help. thank you, aesi