Calculation Engine (Define Fields)

My homegrown (homegroan?) invoicing solution includes a calculation that simultaneously applies a discount to the invoices of clients who pay in X days and a surcharge to those of clients who fail to pay in under Y days. This has worked well until today, when one pesky client has slipped over the threshold and will now incur a surcharge on his invoices. However, I realise that the surcharge has been applied to all the client's past invoices, whether paid or pending, and this is definitely not OK. How can I lock the records to prevent the calculation from modifying these invoices? I appreciate any help, though I'm reluctant to send the entire db for perusal. Many…

how do i put in a field its value the previous year? my database is like this: year - number field name - text field income - number field income 2 - number field income is the present year, i want income 2 to contain income of previous year thanks

I have been maintaining an Image Database for my company. This Database entails Image references to a folder on the computer. It only stores a reference to the image as the database would otherwise not be able to hold all the external files. Now I have a new computer and installed the Filemaker software on it and placed the file containing all the images back in it's place on the desktop but Filemaker can't find the images (error message: 'the file cannot be found'). I was afraid that this problem would occur and am wondering if there is a way to fix it? Strangely, Filemaker is able to retrieve some of the images since being installed on the new computer (maybe 8 out of…

Hi All, I need help in getting an Individual shipping cost. My database has an order table and order line items table, 1 order can have multiple items on it. I get sent the Total Order cost which say is £15.00 and I need to break the total cost into however many items there are so that I can report on how much we have spent on x item. ie:there are 3 items on that order the individual cost would be £5.00 each. I have a field called Total cost and Individual cost - is there a way to have it calculated automatically? Many thanks Roy

I have a number field (dollar amount), and what im trying to do is based on the dept-value list i want the sum of all a.m.'s to go ontop. so if i have 2 a.m.'s. 1 with 100$, and the other one with 300$. i want my summary to say 400$. and the same thing with the other one. here is an example. the problem for me right now is trying to find a function to get the number and add them together if the value list is the same. Thanks Test.zip

I can't figure out how to have my FMP database be configured to open a different external file for each record in the FMP database. I have no trouble setting up the 60 or so different Send Event scripts that each identify a different external file to open (though, if there is a shortcut to this, that would be good, too), but what I'm struggling with is how can I add a button to a field to run this script so that the button opens a different file for each record.

Hi, first post and a newbe. How should I go about defining a field with the following format: 123456/78 123456/7 - max nr. of characters is 9 including the slash. - the slash comes always after 6 characters. - may end with xxxxxx/[color:red]1 or with xxxxxx/[color:red]12 any pointers appreciated.

Hi, is there an easy way to convert these character types to plain text markup? , etc

How do I write a calculation? I am new on write calculation. I have a database where I keep record of the registration and workshop, The registration fields are F1, F2, and F3 and the workshop fields are W1, W2, W3, and W4 How do I write a calculation If I am register to any of (F1, F2, or F3) and NONE of the W1, W2, W3, or W4 I would check the radio button as “Registration Only” If I a register to any of (F1, F2, or F3) and any of W1, W2, W3, or W4 I would check the radio button as “Registration and workshop If I am not register and only attend any of the workshop I would check the radio button as “Workshop Only” Any help wil…

Does anyone know of a function or calculation that measures the pixels of an image? Thanks.

I'm working in Filemaker Pro Advanced 8. There are 25,000 records in my database. I'm looking to create a script that sorts through all records and gives me only the records with 4 letters (or less) in a specific field and for the life of me, the script eludes me. The answer is simple...but I do not see it. :-( Any help would be appreciated.

Hi, everybody. I been trying to make this work, but nothing seems to work. I wish i was a filemaker expert.. : What i have is 4 fields. Dept, Amount, and Summary by A.M., and Summary by P.C.. In "dept" i have a drown down list (A.M. and P.C.) (with 6 repetitions) 1 of 1, 2 of 2, and so forth in "ammount" is a number field with 6 repetition So in essence "dept" and "amount" have a 1 to 1 ratio. The "summary by A.M.", and the "summary by P.C.". What i want for these two fields, and i CAN't make it work is to have a summary. For example i want Summary by A.M. to give me the sum of all the "ammounts" that have the "dept" A…

How do I make a field mandatory based on the contents of another field? For instance, if the status is Approved, the Approval Date should become mandatory. If the status is Denied, the Denial Date becomes mandatory. In the Approval Date, I could go under validation and enter the calculation If (status = “Approved”; not isempty(dateapproved)) But it doesn’t make it mandatory What am I missing? Thanks in advance

Please help me out, I'm stuck! : I have a value list (it's a drop down), that lists different booth sizes (ie: Small, Medium, Large, X-Large) that people request when they apply to be in our trade show. I want to get a grand total of these size requests. I was thinking, I want to create another field that will tell me how many small booths someone has requested, how many medium, etc. etc. Can someone tell me how to do this? All help is very much appreciated.

I would like to make sure that a field with text in it doesn't get printed until it is spellchecked. You can do it manually with the edit menu. I want it to pop up as the field validates that there is text in it. Please help, I feel like I'm just not looking in the right places.

does anybody know why below evaluate function require back slash between a+1 & b+2 ? it wouldn't work without it. and i noticed that in let calculation , "&a+1,b+2&" will work. why do i must use back slash in evaluate calc and not in a let calc ? calc = Evaluate ( "Let ( [ " &"A=5 , B=10"& " ] ; a+1 & ", " & b+2 )" ) regards, kyle

I created a script using open URL, to open a folder on a windows server. However, if I connect to the database using open remote, and I then try to call the script to open the folder on the server, Filemaker hangs, searching for the IP address. But if I establish a VPN connection first, and then call the same script, it works fine. Is there a way that I can require Filemaker to test for an active VPN before calling the open URL script to prevent the user's computer from hanging up?

I have a db that is used to record survey results. Several of the fields that get filled in, are drop downs. For instance, we record what Language tours are conducted in. The drop down lists 5 possible laguages. I want to generate a report that allows me to input a date range, and then gives me a list of the # of tours in each of the 5 laguages. Also, I have a field in which we record the membership number of visitors if they are members, and leave this field blank if they are not members. I need to again, after entering a date range, determine the total number of members visiting and the total number of non members visiting base on wether the membership number field is f…

Hi, Is it possible to have a PDF in a container and field... create a button and script it to PRINT the PDF... I was thinking it could be done with AppleScript. I might be overthinking it but in the past I remember somehow exporting data from a field... dropping it on the desktop... and printing it then the file would be deleted... all thru applescript. Am I wrong?

Is it possible to email contents of container field as an attachment from a mac or xp.

Can anyone else replicate this? An auto-enter calc won't update if doing so violates the "Validation by maximum number of characters" condition. I created two text fields. Test1, Test1Calc. Test1Calc is an auto enter field with the option of "Do not replace..." unchecked = Test1. Under Validation options, "Maximum number of characters" is checked and set to 3 and "Always Validate" checked. If I enter 3 or few characters in Test1, Test1Calc updates correctly. But if I enter more than 3, Test1Calc does not update and I receive no error message. If I change the validation from "Max..." to "Validated by calculation" = Length(Test1Calc) :less: 3 …

All, I hope it's just a coincidence that the last post was also about modification dates. But, my question is different. I have several important fields that I need to keep track of who changed them and when. The only way I've been able to think of getting this to work is to have each of these fields in their own table. I would then have a user account field, creation date, modification date and time, etc. I am then able to get all the audit information I need or want. Oh, of course, these tables would be related. My question is this -- is there another way? Is there a way to have multiple modification date fields in one record pointing to specifi…

Hi all, I am working in a letter using filemaker send Mail, I am trying to use the TextStyleAdd ( text ; styles ) on the specify calculation but for some reason what I want to be bold is not showing as bold at the e-mail. Any help will be appreciated. By the way here is what I have on the specify calculation: "¶"&TextStyleAdd ( "Workshops:"; Bold)&"¶¶" & Case ( not IsEmpty (W1 ) ; WS1 & ¶ ) & Case ( not IsEmpty (W1DA) ; W1DA & ¶&¶) & Case ( not IsEmpty (W2 ) ; W2 & ¶ ) & Case ( not IsEmpty (W2DA ) ; W2DA & ¶&¶) & Case ( not IsEmpty (W3 ) ; W3 & ¶ ) & Case ( not IsEmpty (W3DA ) ; W3…

Hi, I'm humanitarian, can't think like programmer. Sorry. Need to do the following: - I have a portal (Sales Orders table) where I enter info about the books sold - I have Inventory table where I get information about all books received/returned/sold - I need to get EXACT amount of all the same books listed in the portal, under different invoice numbers. For example, on Invoice #123 I have 1st item "ABC book", sold quantity = 2, 2nd item "XYZ book", sold quantity = 3; on Invoice #124 I have 1st item "XYZ book", sold quantity = 1, 2nd item "ABC book", sold quantity = 1. RPOBLEM with my calculations: whatever I do I either recieve the total of ALL the books on tha…

i have a complex set of calculations and relationships to allow me to have a list view of one table with an expanded view of any given record in that table below it on the same layout. It is for timesheets i have tables: X(weekly timesheet) Y1(daily timesheet linked only via id code) Y2(daily timesheet linked via id code & filter for the day. monday, tuesday...etc) X(project/task logs for that given day) this is all working the problem arises when i am falling back through the hierachies and calculations are depending on calculations. 1 flows perfectly to 2 (a sum of all 1's). it also flows perfectly to 3 (same as two but different table instan…

I'm working on a new solution where I plan on hiding the status bar and creating a navigation system within the layout itself. The main reason for this will be to allow records to be viewed in either a view only layout, or a modification layout depending on whether the 'record_locked' field is set or not. I've got the navigation worked out, but have come up with one problem. I've created two fields in the table, 'table_record_numb' (unstored calculation field with the value Get ( RecordNumber )) and 'table_found_count' (unstored calculation field with the value Get ( FoundCount )) which I'm using for displaying in a 'Record x of x' format on the layout. I also have …

I hope I'm posting in the right place. Here's the problem i'm trying to solve: I have an Invoice table related to a SpecialPricing table (one to many relationship). In the invoice layout i have a portal that displays related records from SpecialPricing. Bu here's the thing... I need a field "zField" in the Invoice table that gets a specific value depending on the records that show in that portal. something like this: zField = if in the records displayed in the portal row you find item 1 or item 4 then put X if you don't find item 1 or item 4 then put Y. Now maybe there's a simple solution to this but i can't figure it out... what i thought was: c…

Hi Guys, Quick question, I have a field, let's call it Field A, and this field has text in it. Now, I have another field, Field B. Field B may or may not have text in it. What I want to do is this. If Field B DOES have text of any kind in it, I want the color of the Text in Field A to change to red. I've done this with validation from a drop down list before with other fields, but I cannot get this one to work, all it does it erase what's in Field A instead of updating the color. Here is a sample of the calculation I'm trying. Case ($Field B} = "*" ; TextColor ( Field A ; RGB ( 4 ; 54 ; 255 ))) Any insight or help with the Calculatio…

Hello, I'm trying to determine the best way to set up a running calculation that uses previous records as the base. Imagine, for example, 4 players play a game for the first time. The base score all players start with is 5000. During that game, Player 1 gains 100, Player 2 gains 50, Player 3 loses 50 and Player 4 loses 100. The NEXT time they play the game, I would like their base scores to reflect the changes from the last game (so, new scores would be 5100, 5050, 4950, 4900), and so on. I've been able to set up relationships within the file to allow the 5000 to be placed, and for all the computations. The problem is, I'm unable to set up a calcu…

Hi Guys, I have another question for you all. I want to have one field that pulls information in from 10 other fields withing my database. How could I create something to do that? I've been tooling with it, but haven't had any luck. So basically, something like this. FIeld A - First Name FIeld B - Last Name Field C - SSN Field D - Phone Number Then, Field E would be show all that information together in one text box. First Name, Last Name, SSN, Phone Number. How would one get a field to grab all that information and display it? Thanks in Advance,

Hello - I have a text field with a number-dash combination in it. It looks like this: 123-45-678-901 I need the numbers in a seperate field looking like this: 12345678901 I created a calculation (text) field to do this, but I have NO idea what function to utilize to remove the "-" from between the numbers. And the format (NNN-NN-NNN-NNN) never changes. Any suggestions? Thanks, Tony

'ello. I have set up a container field to "insert picture" from a specified source file. However, when I click the container button on "browse" or "find" mode, the field just flickers and never inserts the picture. I have checked the path name (automatically determined by "Add File" option), the format of the files I would like to add (jpeg), and anything else I could think of. Are there some intermediate steps I am missing? Such as setting-up border limits or pic resolution? -Or am I just overlooking something simple?

I have a field name "Chargeback" with 6 repetitions. each repetition has a drop down with 2 options. "P" and "R". My goal is that if all 6 Repetitions have R this will trigger another field called "status" to have the Letter "R", but if any of the 6 repetitions for chargeback have a "P". i want the Status field to show the Letter "P". I hope i'm making sense. Thanks in advance. Nestor

ok...noob here.... I like to select an item from the value list and have it auto serial. I got that part done, but I would like to to number consecutively to each item chosen from the value list, i.e. MDV-001 DV-001 then... MDV-002 and so on.. thanks! hope someone can help! cheers

How I can use regular expressions for validation of my field data and for use in scripts? Any Regex plugins for FM with support for backreferences?

I have a database with 3 item priorities - Very Urgent, Normal and Low. I was trying to create a script to perform a find and go to a layout to show items in list view. Rather than making 3 separate scripts, I thought I could use a generic script which gets one of the values - Very Urgent/Normal/Low and perform the script. In Myscript I have 2 steps 1. Perform find (Criteria set to MyDatabase::Priority[Get(Script parameter)] 2. Go to Layout["List View"] At the button setup screen, I do this 1. Perform script ["MyScript"; Parameter:"Very Urgent"] when run I get "No matching records found" Whats wrong here? Am I doing it correctly?

I use a button to show a custom dialog asking a user if they want to perform a function. Even if I cancel the dialog using the cancel button, the function is performed. This is how I did it in script maker [color:blue]Show Custom Dialog [] [color:blue]If [color:gray]--statements here [color:blue]Else [color:gray]--more statements here [color:blue]End If How can I abort the script if the user selects the cancel button?

Ok here goes... I have a solution deployed on server adv with one file that is giving me some concerns. File 1 has an unstored calc of Get (TotalRecordCount) in a number field called total_record_count with a text box field on layout 1 that references that field. If client A opens file 1 and goes to layout 1 and client B opens file 1, and goes to layout 1 both total_record_count and the total in the staus bar match. If client B creates a new record total_record_count and the status bar count match and show the new record yet client A total_record_count does not show the new record while client A status bar does show the new record created by clie…

I have a table that has the following fields: Stored Date = storing the datae when the record was created loadNumber = the number of the call that was taken, e.g. the first call of the day is "1" the last call of the day is 'n' What i am trying to do is make it so that the loadNumber resets itself and starts over at "1" at the beginning of each day. I tried the following without success Auto-Enter Serial Number and a calculation on that same section and then without the auto-enter number. The calculation was tried 3 different ways that made sense to me, but sadly didn't work. They are as follows: Let([stDate=StoredDate; nowDate=Get(CurrentDat…

Hi Guys, Ive been storing refrences to photos in container fields. The actual folder I store my phortos in is a shared webserver. All the PC clents can access and view the photos through their container fields. Unfortunately my mac clients can't seem to see the images. Is there something I can do to allow access to these images? Surely it must be a way the paths are stored

Hello all We recently became VAT registered in UK. However, some of our invoices do not have VAT added before a certain invoice number i.e all invoices before 117 do not have VAT added. All those after 117 do! Is there some way to stop VAT being added before 117 in calculation of formulae??? Look forward to any replies. regards BFGK

Am porting a set of FMP5 files to FMP9. 6,782 field names need to be converted to standard format (e.g., remove $ chars, leading numerics, etc.) I have all the fields in an Excel SS and am planning on cutting & pasting NewName over OldName, but it will be horribly tedious. Is there a third party application that will run on Filemaker 6, 7, 8 or 9 that can make this task bearable?

i have a field called account number, i only want to enter a 4 digit account# 1234 and after you enter the 4th. digit it will also trip the enter button to bring up that account information. Sure would like some help. i am uning ver 9. thanks

Hello all, I got bunch of records (as a result of find). How can I duplicate them in one go? I tried loop but when I used exit when the last record is hit, it exits right away because when the first record is duplicated it goes right down to the bottom of the list (making it the last record). Need some help. Thanks!

I'm trying to figure out how & where to place an if (I think it should be an if) statement that will allow me to only have sales tax calculated IF the state of purchase is New York (where I am.) I'm new to File maker (I'm switching over from MS Access.) So far, I have: If(state = "NY"; tax = (subtotal X 0.8625); 0) Can I add the calculation in the statement like that? Thanks for your help.

Sorry if this is the wrong place to ask this, but I was definitely NOT sure where to ask and this seemed the most appropriate. I have finally somewhat figured out relationships (they are working at least, and working the way I intend them to), so my question is thus: I have a table called 'trips' when entering data, the user will choose what type of vehicle is being used which will also determine how many places there are to sit on that vehicle. In this trips table, I need to make it so that if a vehicle contains 4 places to sit, there are places to enter 4 peoples names/ID's, if there are 6 there needs to be a way to enter 6 peoples names/ID's. In th…

In the he wonderful solution that I've inherited there is a number that is generated in a separate system and can look something like; ABC 22-01 ABC 22-01SP-R ABC 333-01 ABC 333-01SP ABC 4444-01 ABC 4444-01EF The ABC is a Type the next numbers are a family and the number after the dash are the individual, the rest is added and I'm still not sure why or when it get there but sometimes it there. In an attempt to clean things up, elsewhere they have created another field that is based on that number but is slightly different it will only be based on the first three strings and has underscores. So the above would look like; ABC_22_01 ABC_22_01…

Ok I'm running into a problem I haven't seen fixed on here yet. I have a large database with multiple records. On one layout there is a possibility that when it prints it could be more then 1 page. It's even possible it's more then 5 pages. Just depends on the data that's been recorded for that particular record. I'm trying to get it to read "Page x of y" where x= the current page in relation to that record and y= the total number of pages going to be printed but only for that record. The second record should start back at Page 1 of z. Where z= the total number of pages going to be printed for the second record.. and so on and so on. Any ideas?

Hi everyone...I'm trying to convert an employees name and ID number to email format. The only part I'm getting stuck on is the employees name. Payroll provides it electronically as one field as such: LAST,FIRST MI, Our email is configured as [email protected] (where "F" is the first initial of the first name and "L" is the first initial of last name and 1234 is a 4 or 5 digit ID number unique to the employee). So I need to somehow take the L and F (using the example above) and place it in a calculation. Does anyone have any ideas on how to do this?

I know this is somewhere in FileMaker help, but I can't find it. I would like to have a calculation show 'Failed Test' if the number in a certain field is below the number '70'. How do I do this? Thanks!

We are currently building a database for viewing PDFs. However, we are wanting to only use the reference to the PDF, not placing the PDF itself in the container field. We are using a central location for the PDFs on one our Mac server(server 10.4.9) When we do this, anyone on a Mac can view the PDFs as long as they are connected to that specific server. The Windows users cannot. They receive a message saying that the PDF cannot be located. How should I go about setting this up? I'm assuming it's because the PC's are missing the correct path to the PDF. I've searched every where for a answer but I'm coming up short. Any help would be greatly appreciated. Thank you in advan…

Hi, I am trying to get this to work and have succeeded but it stopped working or I probably changed something and now I cannot get it to work again. all help is appreciated. Please see the attached file (it is a bit messy - under construction, sorry for that). Take a look at my relationships. There is a table called Products. Basically once the Vendor is created in the Vendor table you can create Inventory line items for said Vendor. When you created the line items you can go to Product table and create products for said Inventory items. In products table you will need to enter Item_Id and Vendor_Id and it will then pull records from Inventory table and aut…

I decided to start a new thread because I didn't want to hijack someone else's here . I just can't help myself! I wanted to understand the evaluation order of the calculation referenced ... ... I created a new 9.0 file. However, even using an unstored calculation (result = number), my results wonk out. When I put a value in [color:blue]a (1) and a value in [color:blue]b (1), the calc turns to 11. I then enter 3 in [color:blue]c. Calc produces 14. No surprise. But if I delete [color:blue]b (1), the result is 13. And no refreshing changes it. In fact, if I then change [color:blue]a to 2, it produces 23. I created a new record. I put 3 in […

I need to calculate the date of the last day of the month a given date is in. If the date is 8/21/2007, I want the calculation to return 8/31/2007. I am using a calculated global field listed below. I get the error message "List usage is not allowed in this calculation" with the closing "]" highlighted. What am I doing wrong, or is there a better algorithm. -------------------- // To calculate the last day of the month from BLK209 date Let([ CSODate = g Date BKL209; CSODay = Day ( g Date BKL209 ); AddDays = If ( CSODay > 15 ; CSODay + 20 ; CSODay + 35 ); NextMonth = getasdate( CSODate + AddDays); NextYearNo = Y…

I want to pull info from my Students table into my Enrollments table, simply by starting to type the students name and have the field populate with available possibilities depending on what's entered. (Like a pull down of sorts) So, if I enter an A, I would get Aaron, Adam, Angie, and Ann. If my next letter is n, the list would shorten to Angie and Ann. I've seen this in action, but can't figure out how it was done. Any help would really be appreciated. Thanks in advance... Susan

For several months I have had a database connected to my webpage that could be accessed from other computers. Today I noticed that while I could access the db from my home computer via the webpage, I could NOT access it from any of several computers outside my home (I had been able to weeks ago from at least one of these outside computers). I use a static IP and have rechecked the URL given in the IWP dialog box; nothing seems to have been changed. Anyone have any ideas what's gone wrong? Thanks.

I have a lot of connected scripts that import an old system data schema into a new and "improved" schema. My problem is that every time I rerun the scripts, I have to go and reset the "next value" field back to the beginning. Is there a way via scripting that I can do this instead of having to resort to going to every file?

Okay, this is my first time here. I've been searching for an answer to my problem for about 6 hours, and now I'm posting. I'm working with a database of students for a university writing center. I didn't build the database, but it's what we have to use. Each semester gets a new database, and each database has two tables, one for student records and one for session records. Each student gets one student record of basic info, and each student gets a session record for each time they come into the writing center for a tutorial. We track primarily through email addresses. Once you enter a student record, the ID fields of both tables are linked, so when you start to enter…

I am sorry if I am not using the correct terminology here. I have a database that we use in our admissions office to track events school visits and information sessions. Once an event has been marked as "display on web" I don't want anyone to be able to change any of the location or date and time information. Can I lock a field so it is read only based on the value of another field? Would I do that with scripts? Thanks for your time. Janet

I am asking if there is any way to send an export from a filemaker file ( A tab delimited file) to a field in filemaker for later use.

I am trying to create an email that will tell people how many hours of lecture they have attended year to date. The setup is a bit hard to explain but here goes: 1. each attendee fills out an evaluation form for each hour of lecture they attend 2. their name & score on the eval form are entered into the database 3. i created a field named "hrs count" that does a running count of name 4. i created a layout that displays each lecture date and each attendee's name & hrs for that date. (Date is in leading grand summary. Name & "hrs count" are in a subsummary by name) I would like to be able to have a cumulative tally of hrs for each attendee so…

I need to count the number of times either one word or another is found in a field in each record. For example say a field contains the text "Front, Back, Left, Right" I need to know how amny times either "Front" or "Left" turn up in this field in this record. (Obviously 2 in this case!!) I can use Patterncount() to find either "Front" or "Back" but not I think for both words. Patterncount would the answer 1 for both cases. I guess I am asking if you can put an "OR" condition in a patterncount statement. Or is there another solution that I am missing (very likely) Thanks for helping.

I am setting up a database for tracking lectures and evaluations. One of the layouts is a letter that gives the speaker their average score on an evaluation form as well as the overall average for all speakers. I have the mean score for the individual speaker displaying fine but I can't get the overall mean for the entire database to display--it only shows the speaker's individual mean. I set up another layout that lists out all the evaluation scores and created a 'Composite Mean' calc field that displays the number I want. I tried using a set variable & set field script that retrieves this number then puts it into a field on the letter layout but when I do …

I have a Calculation field ('Final_Total') which currently adds up an Invoice Total + gov. tax. This in itself works great. I would like to add to this field the ability to turn the data red if over 30 days after the invoice date. I think somewhere in here my syntax is wrong or I have missed something obvious. I am very new to the wonderful world of calculations. My current calculation is as follows: Invoice_Total + Tax_on_total and Case (IsEmpty (Invoices::Date_received ) & Invoices::Invoice_Date < (Get ( CurrentDate )-30); TextColor (Invoices::Final_Total ; RGB ( 255 ; 0 ; 0)); TextColorRemove (Invoices::Final_Total)) Thanks in…

trying to create a startup script that will go to different layouts based on account priviledges and system platform. i want it to go to the web layout when an admin accesses it via a browser. thanks, Limore

I have two number fields 1 called prefix (sample data 087) and the other called number(sample data 1234567). I have a third field which I want to contain 353 then contents of prefix without the 0 and finally the contents of number.

Thank you in advance for help with this. I set up a message system in my file. It is rather simple. It consists of a table with two fields, message display and message input. It is related to another table via Foreign Key. Its purpose is to display "messages" on db home page through a portal. Basically my main navigation has a message button which when clicked on brings up a custom dialog box where a user can enter their message and it will show up in a portal on the home page layout. It is scripted and once the message is entered and the user hits ok new record is created in message table and that record is displayed on the home page in a portal. Next to …

Hopefully this is a simple answer. I have a calculation that returns a number, but I need that number to have two decimal places, even when the result is an integer. Is there a function that can return a text string for the number that will always have two decimals after the decimal point? The result is going into QuickBooks as an amount and it is required to have two decimal places (10.00 not 10) Thanks.

I'm trying to set up a report that will print date stamped information between two dates. This would be a weekly report and I want to show information added for the week in question. This can be a script or a setup for a form. Any suggestions would be greatly appreciated. Sculler

I have an import of one text field which is delimited with ~. There are 18 fields to parse from this one field. To make it easy AND to make it simple for future to determine how to modify the calc if necessary, I decided that each calc should be identical but the Developer simply specify the CHUNK NUMBER. Here's what I came up with. I originally used a calculation by Comment. But I could not figure how to adjust it to allow for specification of chunk without modifying the beginning and ending calculations; nor could I adjust it in case there was no beginning chunk. My idea is to add a ~ in front and at end of every field. Then the calculation is identical. …

How do I create a total page count field to put at the bottom of every page of a printed report? I'd like the footer of each page to read "Pg 1 of 5," "Pg 2 of 5," etc. I'm printing a report composed of a variable number of portal rows. I know I can figure out how many portal rows take up a page, do the math, and derive the number as a function of the number of portal rows. But is there a simpler way? Thanks!

Is there a calcualtion the replaces data in the current record with data from the next record in a found set? Thanks Gary

I have a situation where i need to count the number of leading spaces in a text field. Does anyone have thoughts on how to do this. Please keep in mind that spaces could be anywhere in the text, including trailing. I only wan to count the leading spaces. Thanks

I would like to accomplish the following: I have a table called Products. Three fields In_Stock, Reorder_Level and Order. In_Stock is a calculation that calculates how many items there is in stock based on sales and so on. Reorder_Level is basically a manually entered number that sets the inventory level at which the item needs to be ordered again. Order is a calculation that does: Case ( Products_Item_Quantity_In_Stock ≤ Products_Item_Quantity_Reorder_Level ; Products_Item_Code ; "" ) I have a sort of a home page, starting point that giver a brief view of things needed to be taken care of as well as a brief daily reports and …

I've defined several global fields in FMP5 but they aren't acting properly. I want the user to enter their own values into the fields and have it saved. Unfortunately, some of the globals save the data entered and some don't, meaning that when I come back into the application the values in the global dields have reverted back to whatever they were before. Any idea why this may be happening? Thanks The Mad Jammer

I'm working on a database which contains a defined unique serial number yearly, but this unique defined serial number can be repeated the year after that. for example: year 2006 "SNumber" contains AB100, AB101 and it has to be unique during 2006 data entry. year 2007 "SNumber" contains AB100, AB101 and it has to be unique as well. The big question is, how do I defined a validation on field "SNumber" as unique for each year? considering the typing error during data entry, so validation for unique value has to be turned on. Without the hassle having a separate database for each year? Thank you all in advanced

Hi guys, Im having a problem with an Open URL script to open a PDF file stored on a local network. I have found a solution but have not been able to perfect it, you can create a button that does an "open url" the url would be the address where the file is located on the server or computer for example: M:Filemakerpicsparcelpdfs1049.pdf I need the file name to change with each record according to parcel number (actual field on the database) M:FilemakerpicsparcelpdfsXXXX.pdf where XXX= parcel number so far I have tryed the following "file://M:Filemakerpicsparcelpdfsmalofdb::parcelnumber.pdf" but does not open, the only way I have gott…

I was wondering if anyone knew how to show how many "find requests" and which one is being viewed similar to the get(recordnumber) and get(foundcount) functions. The goal is to hide the status bar.

I need to look at the last character of a field and know whether it is alpha or numeric. Can anyone help me out on this?

I want to automatically save today's date in a sparate field if my user clicks the appropriate checkbox (and reset it if the checkbox is cleared). How do I do that in an older version of FMP? Thanks Jammer

Hi, Is it possible to show mulitiple lines (From Line Items File) into 1 field in the order table that are all attached to 1 order, so that it can then be emailed or used in merges. Thanks, Roy

I have a table of sales orders, and a summary field, Orders_sn for the Total of orders. I'm producing a report that shows the number of orders for each weekday, for each month, followed by the month's total orders. (Two parts, one sorted by DayofWeek, one sorted by YearMonth.) All that is OK. What I also want to is show the number of orders for each weekday as a percentage of the total orders for the month. (So as to see the distribution for each day of the week, for each month.) I cannot figure out how to calculate Orders_sn (summarized by weekday) divided by Orders_sn (summarized by YearMonth), and display it in the part next to the Orders_sn by Weekday…

Whew...let me see if I can explain this properly, and then, see if it's even possible. I'm looking to set up a running calculation for my boardgaming group. One formula basically compares the scores of the various players, and determines how much each player will win or lose. That total affects the previous "base" total, and a new base total is generated. So, for example, let's assume all 4 players start the game, tied at 5000. They're playing Monopoly. At the end of the game, the formula determines that the 3 losing players should lose 33 points each, and the winner should gain those 99 points. For the NEXT game, their scores would be 5099 and 3 players at 4967…

Does anyone know if you can convert the hyperlink tag using the GetAsCSS function? (i.e. You can convert , but ?)

Is it possible to use Repetition field as [color:red]Merge field ?

I am making a shipping calculator for my own small company's wholesale order. I have made a automatic weight-calculation and want that to control a field that can tell the price in money to ship that. Also of course I know it has to be connected to a field defining what country. The table of info I would like the calculation to be based on looks like this: http://www.post.japanpost.jp/english/fee/intel/ems.html How do I do this, I don't manage to find the way. Many thanks in advance.

Hello: I made a calculation which turns a number into text. The calculation was working fine, until I imported updates. When I went back to recalculate the fields, and chose "calculation" as the field type, it completely wiped out the data in the field. I tried it more than once with my backup copies, and each time the contents of the field is completely deleted. Can anyone tell me why this is happening?? Alisun

I am trying to complete a form that teachers can use to complete their lesson plans. Our state has performance indicators (numbers) which correlate with a specific objective (text). I need to have FileMaker Pro select the appropriate objective when the teacher selects the performance indicator from a pop-up or drop down menu. I also need for teachers to enter the date for Monday and have FMP enter the dates for the next 4 days. I'm confused about how to do this---I didn't even know which thread this type of problem should be listed under---conditional formatting, calculations, or scripting. Any tutorial or advice would be greatly appreciated. Thanks!

Hello Is it possible to script or calculate the naming of a file? I would like someone to back up theFilemaker file by a the contents of the text in a field- Or by the date and time. Can this be done by a script or a plug-in? Thanks Dave

I am curious if there is anyway possible to prevent a carriage return when in Browse Mode on a field. Instead of going to the next field when they press enter, it enters a carriage return instead. So they must hit tab to go to the next field which is an issue. Any ideas?

Greetings! Sample File Attached. SYNOPSIS: Calculation field clc_marker works except for the “Working” past due Case. I need Assignment clc_marker to dynamicly: Label assignment with “TARDY” if Assignment Status is “Working” and past due. Label assignment with an “X” if Assignment Status is “Complete” and past due. FAULTY CALCULATION: Case( date_deadline - Get(CurrentDate) ≥ 0; date_deadline - Get(CurrentDate); date_deadline - Get(CurrentDate) ≥ 0 and txt_status = "Working"; "TARDY"; "X" ) Please help, thank you for your interest! Sincerely, DynamicPastDueMarker.fp7.zip

Hi there. I am trying to list off authors in a database file. I effectively have four fields and am unsure how to tie them together for a list. First repeating field is text: authors_last_name Second repeating field is text: authors_initial Third field: book_name Fourth field is: concatenated version of first three fields. What Im trying to achieve is where there are two or more authors for any given book. Normally I would just field & field to concatenate them, but need to formulate it so that the single or multiple authors are listed as Smith, J. Brown, S. I then went on to want to add a single quote around the title - not sure how to …

Hello All! Sample File Attached. I am having troubles getting this calculation to work properly. I need to mark Assignment with: Repetition #2 (Purple) if Assignment Status is “Working” and past due. Repetition #1 (Gray) if Assignment Status is “Complete” and past due. Calculation works except for the “Working” past due section. Even if status field is marked "Working" calc results repetition #1 (Grey) I do not know how to set the criteria for the Case function in this calc to look for days past AND status. Please help, thank you for your interest. Sincerely, StatusByColor.fp7.zip

I wish to have a calculation field result in Years, Months and Day in business. I have a date field for date founded. Anyone have a niffty calc to do this? Of course, thank you in advance!

I'd like to be able to set up the "Territory Number" field in my database in such a way that it looks at the zip code in the record and then goes out to my Sales Territory table and finds the correct territory. The way the Sales Territory table is set up is as follows....It contains a Territory number, a "startZip" (such as 00000) and an "endZip" (such as 02100). I'd like the calculation to find the correct territory by comparing the zip code and finding the correct zip code range. Does this make any sense? Does anyone know how I can do this?

Hi All, I need help with a ticket number problem I am having. I want to have our CSRs put in just a number and have it have a letter in it. An example would be "H2345". I would like to have them enter "82345" and have FM convert the "8" or any other number that is there, to a corresponding letter of the alphabet. Is there a way to do this or should I start thinking of another way to do this. Thanks in advance Michael

Hello everyone. Well ... I have made the jump. I am moving from MicroCrap to Filemaker. I have purchased both FM9 Advanced and the server addition in an effort to convert several clients in an MSsql environment to a more friendly and hopefully more user friendly FM solution. But I am having an issue understanding something. Please enlighten me. I need to make several complex math calculations based on various field data from a single table. These calculations do not need to be stored but rather just displayed to the end user. In Access I would simply create a text entity and assign a calculation. No muss no fuss. But in FM I have to create a fi…

Does anyone know of a way to serially increment text? For example, if a field contains the value of "A", incrementing it would result in "B". A value of "B" would increment to "C", etc. I haven't found any built-in text functions to handle this, and would like to avoid having a table to store replacement values.

Hi, I am trying to put in a generic code that returns "Record 1 of 25". Here is what I am using.. "Record "&Get(RecordNumber)&" of "& Get(TotalRecordCount). Unstored. But each time I go through different records the two numbers are always the same. (record 1 of 1, Record 23 of 23, etc.). What am I doing wrong? Thanks

I've been using this calculation for years with V6 and earlier versions: If(terms = "First of Month" , DateToText( Date(Month(Invoice Date) + 1,Day("1"),Year(Invoice Date))) ,If(terms = "Upon Receipt", Invoice Date ,If( terms = "30 Day", Invoice Date + 30, DateToText( Date(Month(Invoice Date) ,Day("15"),Year(Invoice Date)))))) When I converted to 8.5 the calculation changed to: If(terms = "First of Month" ; GetAsText( Date(Month(Invoice Date) + 1;Day("1");Year(Invoice Date))) ;If(terms = "Upon Receipt"; Invoice Date ;If( terms = "30 Day"; Invoice Date + 30; GetAsText( Date(Month(Invoice Date) ;Day("15");Year(Invoice Date)))))) It returns a value of "…