Calculation Engine (Define Fields)

Hello, Setup: I have a many to one relationship (through means of a Portal)... I have a scripted that adds a new entry to my portal for only that record. All I want to do is to add a field next to the new entry (blank field)... so the inputer sees what they entered the last time for this record. Really just a reference... Help? Joseph

Uses Batch file so possibly windows only, attached file is fmp7. NO PLUGIN REQUIRED! 1. Filename obtained from embedded file via calc on the container. 2. Push Open button runs a script that- Exports file using a generic name, a batch scipt file is created and then run that changes file to original filename. File is then opened via an open url script. 1 Button, no user input. WARNING- one downside is that it will not open files that have a space in their filename. INPUT on this would be good if there is a work around. opencontainer.zip

Hi everyone, Is there a way to insert a folder into a container field type? It would be great if there is a way because I need to insert a lot of pictures into the containers and it would be troublesome if I have to insert the picture one by one. Thank you all.. Cheers, Ren

First off thank you for taking the time to read this post...but let me go ahead and dive into my problem/question. I am defining a database in which I want a user to be able to control some of the caculations by defining the values in those caculations. Also I want the user to be able to give a "name" for the field. Basically here is what I want: Fields To Be Defined "Field 1" "Multiplier" Fields To Receive Data "Amt 1" Fields Displayed on Form (Field 1 Text) (Amt 1) (=Multiplier*Amt1) The user will Define the values for the Field 1 and the Multiplier one time (can change in future). The Am…

Hi, I'm having a problem with global fields, one is a question, one is something I have never experienced before, and is counter to the way I understand global fields. 1: Is their a way to prohibit the changing of a value in a global field without "hiding it" on a layout that is not used? The prohibit modification box is grayed out in the field creation menu. 2: On a soultion I am currently using the value in a global field keeps disapearing. I set it (at 2,500, not that that matters) and then the next day it is gone. I thought that once you set a global field, that unless modified it is supposed to remain unchanged across all records, and be present w…

Hi I'm not sure if this can be done this way.. I'm wanting to use a calculated field in one database to display the contents of multiple related record fields from a second database. Is this possible? I can structure the data from the 1st related record, but don't know how to display the subsequent records. I could construct and format the data using a script or display via a portal, but I'd rather a field calculate this 'on the fly' Any help appreciated! Matt

So...I'm coming along in my FM education...and enjoying it! Here's what I'm trying to accomplish now and I can't find an answer (that is obvious to me anyway) in my FM books/manuals. Imagine if you will a Layout which looks like this (I'll call it "LayoutA"): -LayoutA- Field01 Field02 Field03 Field04 Field05 Next, imagine that I have the solution working so I can "hide" any of these fields when displayed in a different Layout...let's call it LayoutB. So I can create something like this if I hide Field02 and Field04: -LayoutB- Field01 Field03 Field05 So, the question here is...is there a way that I can "close up" the remaining fiel…

I have fields that are calculated with a custom function that is just text parsing to extract data from an e-mail body (stored claculation, once extracted the data will not change, so i think no need to use the "do not store option..."). So far so good... In the same script that gets my email body info to be used to extract content to my calculated fields, I want to use the info in the calculated fields in a IF step... My problem is when i use the IF script step to test the contents of each calculated field it's as if they have no data.. I have tried to use a commit step to "save & force the calculations to get processed. But that does not work An…

I have a field with a start date, and a field with a due date. I want a field that shows a % for how far along todays date is between the start and due date fields. I thought I had a calculation that would do this, but it will not update. The only time it updates is if I change the date in either the start or due fields. Anyone have a calculation that will continually work for this? LR

I have a situation where a served FileMaker database displays linked images which are located in a complex hierachy of folders on a separate file server machine. The file server went down and all the data was restored from backup with the exact same names and structure. Now many of the linked images are not displaying (the usual "Could not draw picture file: "image name"). There are more than 5000 records in the file, so reinserting images one-by-one is not an option. Based on a recent experience changing folder and file names to be PC-friendly, I know that the link FileMaker uses with image references is more complex than say an html "img src" tag, which is based en…

Hello, I know this must have been posted a thousand times. just point me to the right answer please, Imagine the case, you have a contact database with 2 tables, contacts and locations. im entering data, i get to country , i choose my country with a pop-up list and then I want the Province to be only the provinces of the previous selected country. I've already set up the locations table with its fields. But I dont know the calculation needed to filter down the results. At this point, I have to remember that the selected province really belongs to the country when I enter data. Any help would be appreciated. thanks a lot, Dan

Does FileMaker have a limit on how many pages it will print for 1 record. For example the record I need to print covers 9 pages. They are fixed, not sliding and the fields do not cross over the page separators. But it will not print pages 7 - 9. No matter what setting I put it on.

Greetings, fellow FileMakers! Does anyone know how to make a text box that won't expand when full? I have found the maximum number of characters limit that one can apply under the Validation tab in the field options when defining the database, but don't really want to go that route. Because of the variance in character height and width, it's hard to come up with a good number that will allow the user to fill the given space without going over the limit. Alternatively, if it were possible for the height of the text field on the layout to increase dynamically based on the number of lines of text entered beyond the "default" height, I suppose that would also work…

To facilitate the speedy entry of a date field I have defined a text field (service_date_text) that uses the "Auto Enter a Calculated Value" and unchecked the "do not replace the existing value if any" with the following calculations. Case ( PatternCount ( service_date_enter; "/") = 0 and Length ( service_date_text ) < 3; GetAsDate ( Month ( Get ( CurrentDate ) ) & "/" & service_date_text & "/" & Year ( Get ( CurrentDate ) ) ); PatternCount ( service_date_text; "/") = 1 and Length ( service_date_text ) > 2 and Length ( service_date_text ) < 5; service_date_text & "/" & Year ( Get ( CurrentDate ) ); PatternCount ( servi…

Well I'm Bummed, I entered this question before and it didn't post, so here we go again I have a contact database for a local university, each student in this school of the university is required to take certain test in order to be certified. This would be similar to taking the SATs or ACTs for college entry. Each student make take the multiple tests, multiple times, the best scores are their actual rating. i have stored all of these test results in a related table each record represents a different test type with the associated date, score and other non-crucial information. what i need to do is now determine which student HAVE or HAVE NOT met the criteria to…

I have a global container that holds two parallel lines. Behind the container is a solid color background field. The parallel lines were created in Pagemaker 5.0 on a Mac and pasted into the container. I have added a windows machine running XP and cannot correctly print from the PC. On screen the container is transparent and the lines appear as stripes against the color background. When printed from the PC to multiple printers the container loses its transparency and does not print the background color where the container is located. The printed output from the Mac is correct.

Hello! I have a simple billing database linked to a Client DB. I'm trying to get a monthly summary of charges out of the billing DB that I can store somewhere, i.e., a calculation field called 'January Charges'. Here's what I use: If (Date >= 1/1/05 and Date <= 1/31/05, Sum (Charge), 0) Instead of getting a sum of charges for January, I get all charges for that client totalled up...January and afterwards. I must be missing something here. Can someone tell me where I'm going wrong? THANKS! Corey

I accidently deleted everything in the define relationships window, including the table I use in the file. Now in every layout and every script, all the fields say <Table Missing>. Although I have restored the table as it was in the relationships tab, they still do not recognize it. Is there a simple way to restore everything or is it start from scratch time?

I'm a photographer ready to switch my public presentations from slides (the old-fashioned kind on film) to computer-based. I've looked at Premiere and Keynote, but FM might make more sense for me because my images can be easily searched and sorted. Does anyone else use FM this way? A few questions: Is there any way to turn off the menues, tool, and status bars so that the image shows against a pure black ground? Is there any way to manage color using embedded ICC profiles in container field graphics with FM? I've sized my pictures at 1000 pixels and formated the container filed to reduce or enarge, maintain proportions. Still, the images look a little soft. Any other advi…

this seems really simple, and i can't figure out why it won't work. in my members table there's a field, PhoneCell. in my directory layout, i want the field to have the text "Cell: " in front of the number, so i made DPhoneCell a calculation of "Cell: " & Members::PhoneCell. when i run the directory with data, i don't get a cell number, even if the member has one listed. where have i gone awry? perhaps it's in the relationships...i still don't seem to be getting those right. thanks db GLCCtestdatabase.zip

Is there a way to set a "flag" field whyle performing a calculation in another?? Set t_FlagResult to "PASS" when extracting valid data in another field.

Hi All, I need a little help figuring out a way to take return-separated list of vocabulary words or phrases, and split it into 2 balanced columns for my printout (to save space). Here's an example list: goggles aquarium turtles coral migratory shark seal pond ocean salt water starfish fish diver beach crab seahorses blowfish mammal They do not need to retain their listed order. I'm thinking one calc might do it, if there's an easy way to get every other line tabbed over on the previous line. In FM7, I would probably use a custom function to do this, but since this is in FM6, I'm not sure how to parse it.

Let's say I am showing a field's value utilizing the <<entervariablenamehere>> technique. (the value list is a series of check boxes) If I have a value list it is currently listing the value in the following manner: Cats Dogs Mice I want it to display this way instead: Cats, Dogs, Mice Is there a way to do this at all? Am I thinking it's difficult when it is really something simple? Please help! (I'm still trying to learn)

Quick question: I have a login system that sets a global field to the users name. Then as they navigate to the various related databases, they can look back to the login file and grab the name of the user from the global. Odd thing, the global does not seem to be sticking. I would expect that a user will log on to the server, and as long as they have the FM files open, the global will reatain the name that was inserted. Odd thing is, that some users will log in, their name appears in the global. They go about working, but in a few hours all of a sudden the global for that user changes and shows someone elses name. Should not the global retain the name the p…

Is it possible to list which layouts a specific field is used in without searching layout by layout :confused [color:"purple"]

I'm using the wonderfully simple age calc found elsewhere on this board by one of you brilliant calc-heads: Year(Get(CurrentDate)) - Year(Date of Birth) - (Get(CurrentDate)< Date(Month(Date of Birth); Day(Date of Birth); Year(Get(CurrentDate)))) The only problem is that I need it to show the age in years and months. Can I add a simple line to the above calc to get this to work?

I have a simple calc field that is used for 'alerts' to the user so they know what information is missing. I have two fields that are on the layout that are from a related record, one is 'wedlock' and the second one is 'mothers_name'. Wedlock is a yes/no, and the mothers name is a plain text field. I have something in my calc field as follows: if ( relationship1::wedlock = "", "Missing wedlock yes/no", "") & ^^ That part works fine ^^ if ( relationship1::wedlock = "Yes" and relationship1::mothers_name = "", "Missing wedlock details", "") Ultimately there are 3 other fields that I would like to include that in statement that if wedlock is yes and if an…

I have a db with several tables, two of which are involved in my problem: the Student and School tables. The school table has fields counselorFirstName and counselorLastName and address among others. The student table has fields: address, city, state, postcode, and then a calculated field named MailingAddress. The calculation for the Mailing Address field uses an if statement: If (address &#8800; ""; address; "c/o: " & School:counselorFirstName & School:CounselorLastName & School:Address) --Basically, if the student does not have an address in the db, the MailingAddress field should show c/o Counselor at the school address. My pr…

I don't seem to be able to get my fields to contain an initial value. I've tried Checking the Data option under Auto-Enter when defining the field but the data doesn't show. Where am I going wrong (apart from trying to build a database in the first place!)?

Has anyone converted Metastock version 8 or 9 stock market data to FileMaker format? Or even know of anyone who might have done that? [email protected]

Call me crazy, but is there no way to capture "the number of occurances" of many different finds all together in one layout? For example, a grid that shows the number of sales by country (rows), and by quarter (columns), the data being pulled and assembled from other db's. I've worked in FMP for years, but I fear I'm missing an entire concept (and am perhaps guilty of thinking in Excel), but it's really quite simple, and all the data is right there. I've tried tagging (1's vs. 0's), but brought the processor to its knees at over 300 calculation fields. Also tried subsummaries, but can't show the result of 50 finds at once, so no "number in current found set". Any thoughts…

How does one export a script made in one database in Script Maker, so that it may be applied in another database??

I am trying to put together a training program, and need help in getting container fields to respond properly. I have a field "fader.1.level" which is a pop up list, and a global container "fader.1.position" I also have a table with the two fields "fader.position" and "fader.position.graphic", from which to pull the graphics. I have added the relationship "fader.1.level" --> "Graphics::fader.position", and the popup list is in fact the list of "Graphics::fader.position" I would like the user to choose the "fader.1.level" from the pop up list, and have the fader position be shown for them. I am just stumped how to do this, as this is further down into FMP…

I posted this in the Sample forum, and per Fenton I am copying it here with an explanation. (Fenton, option 1 is most likely what I would do. However I am using Fm pro 6 with FM server 5, I desperately need to get this to work. I have all our files (over 40,000 pdf's) located on an old os 9 because this script: Set Field ["GBl*Resume Url", "http://(IP addres of os 9 computer) /" & Right Applicant ID.] & "/" & Applicant ID & ".PDF""] open URL [no dialog, "GBL*Resume URL"] does not work f using the ip address of our g4 which hosts out FM server 5 i have no idea about applescripts and would need it watered down and explained in …

I am using XMChart to create a pie chart that populates a container field. I am then creating a pdf and printing it. It appears fine in the PDF and prints ok at my personal printer, but when I send it out to the printer there is a bar going through the middle of the pie. Could it have something to do with the drivers I am using v.s the printer?

After much trial and tribulation and help from the FM forum, esp Comment and Stanley I have a working AJCC malignant melanoma staging system. One last request: Is there a way I can validate the system so that conflicting variables cannot be entered? As an example if: "in situ' is checked all other fields should be empty, except Clark level which should = "I"; the stage is "0" and the TNM should read TisN0M0. When the fields are filled in as above the correct calculation is performed - BUT is it possible to validate this such that if anything else is entered an error message is created ? or the other fields are forced to be empty or contain only certai…

Whats a quick easy way to change the sign of a number in a calculation field?

I have a simple database of publications. These publicaitons have from 1 to 6 authors. I need to be able to search by author, which works with a repeating field. I also need to be able to run a report showing all authors of each publication. How do I make this work?

Dear members, I hope I am posting my inquiry in the right location. Otherwise, please appologize and rest assure that as time goes on, I'll be more acquainted with the site and the proper forums. In any event, my question is regarding 'recurring note creation.' I've tried several ways to achieve the following to no avail: In a portion of my database, I'd like to have a button that whenever pressed creates a note with a time and date posted beside it, sort of the way ACT creates notes. It creates an icon link of a note that when pressed opens the note on a separate window. One can create a number of notes by pressing the SAME note button. How ca…

I need to create a serial # that goes up 1 according to its base. In other words: I have an invoice # that is RM-01-AB - It is a calculation that pulls the initials of the first name (RM) + Serial # + AB (referring to the type of product) However, I want the serial #s to go up per that person - so that the next one would be RM-02-AB. The serial #s need to be sequential for each client - I also want to have, for example, TB-02-AB. So that the # doesn't just go up with each new record - it goes up within each client's various records. I hope that this makes sense - any help would be great! Thanks! However, if the next record I create is TB-01-AB

I'm trying to use global container fields for some GUI elements in a layout and am having a problem with them disappearing or going 'all white' when other buttons are pressed in Browse mode. Specifically, I've got a list layout with a couple of buttons in each row along with data. In the header I've put a graphic task bar (container field),and some info on top of it, including other buttons (also container fields) and merge fields. If a user clicks a buttons in the list rows, the container fields in the header all go completely white, and obscure everything else within their footprint (as if they had been brought to the front of the layout). I discovered a partial fix to…

Ahhh...the learning curve...so much fun. Simple question today (I think!) How does one go about making a given field required? I know that I can set Validation to requre Not Empty, but I'm already using Validation to check maximum character count, so I need the custom alert menu for that. I'm just trying to create something similar to a typical web-based form that has required fields and prompts the user if they have missed a required field. Thanks in advance.

Hello, Here is an example of what I am trying to do: One FM file has 4 records: Name City State John New York NY John Los Angeles LA John Chicago IL John Miami FL I am trying to create one record out of these 4 in another FM file where City and State fields will be put in repeating fields: Name City(Repeating) State(Repeating) John New York NY Los Angeles LA Chicago IL Miami FL Is it doable? Thanks in advance for help!!! Steve

I'm trying to print our company logo and have inserted various file types (pdf, eps, tif) but they all print at a low resolution. The artwork is vector based and isn't a problem from Illustrator, but it seems FM downsamples the art to 72 ppi. Any suggestions would be welcome.

I wonder If anyone can help. I just received my copy of Filemaker 7 and have started off quite well. I already have my page set up with my database attached. What I want to do now is to import a folders worth of images associated with that database. Unfortuantely when I try to import the images within the first layout it places it in another layout (where it works)but can't seem to put them on the same page with both the text field and the container field working simultaneously. Can anyone help??

Hello all, I'm not very experienced with Filemaker so excuse me if this is a stupid question. I'm creating a database that keeps count the amount of profit a client has made by following our stock market advice since the date they joined. I have a database that contains the details of the stock advised, and it includes the date advised and the profit or loss made. I have a 2nd database that contains the client information, name, address etc. I need to have an alert when a client makes a certain amount of profit. I'm OK with everything except, I don't know how to calculate the runing total of profit/loss SINCE, the client joined. Help would very appreci…

Greetings all. Still very much in newbie-mode with FM, so bear with. Okay, let's say you have list of fields in a layout like this: item1 item2 item3 Is it possible with a script (or other method) to produce a result like: If <item3> = EMPTY then do not display in Browse mode else display <item3> end if end I know thats not FM's real scripting format, just sort of what I'm used too...but you get the drift, yes? Thanks in advance.

Okay, I have been reading posts on this board and the web, some book reading and manual reading. Could someone simply state how to go about opening a PDF natively in my Acrobat professional app. so that when I click on it, Acrobat opens up to view the file? I'm assuming through an auto script to an apple script? I downloaded troi file but could not get it to work. After I tried it, clicking on the script I created just blinked the screen. I have inserted it in a pic format, able to view it by zooming, but it just doesn't give me the resolution I want. I apologize for the newness of again another post. I'm just not getting along too well at this p…

I have a repeating global text field that I am trying to copy the data from the repetition into a repeating text field. I can get it to set the first repetition of the text field using SetField( "repeatingText,-1, GetRepetition(myGlobal, 1) ), but it will not get data for myGlobal repetition 2. I've also tried going to the repetition, copying it, and pasting it in the repeating text field. I am using the global to do finds my form so I'm in Find mode. Is there a special function for get repeating Global data? thanks!

Hi Im developing a database to log timecode information off of videotape masters in the field. Simple set up: horizontal set of fields to input the time code and then input what problems occur at that time code along with some other info. (example) Time code problems location comments. There are hundreds of these rows to input each time i go out. What I want is a button to add 10 more set of fields (see above) each time i press it so I can add fields/rows as I go Hope this makes sense Eric

I must have gotten stupid since the last time I worked with FMPro but....I am not able to put just a basic radio button on my layout. When I select Field Format;Radio Buttons, it makes me select a value list. I have fields such as"Yes" and "No" and a radio button next to it. All I want to be able to do is click on the button and move on. Help!

ok here is my problem im importing the information from a csv file from an older program that my company used. So, im kinda limited as to how the infomation comes in there are 8 feilds that contain the information for the billing these 8 feilds import data from 60+ other container feilds [color:"red"](Ref1 &

Hi all, I am trying to use Get(RecordNumber) in a field. It is placed in the body. On any other layout this works fine, but when used on a layout with a portal in it, it produces random numbers or at least it seems like it. The field is not in the portal but outside of it. Storage is turned off so it is calculating when necessary. Any ideas? Test it yourself, it doesn't work. Driving me bananas. I can't think of any other way to show the current record number in a field. I thought about pasting the contents of @@ (which does show the correct record number) into a field but there is no way to do that in a script. Thanks in advance

My father has made a database with a "image" field in which (this is the problem) sometimes he has "embebbed" an image, other times has just "linked" an image. I'd like to transform all the database in "linked" images, in order to avoid the file to become too big. How can I see if an image is "embebbed" or just linked and is there a way to quickly change the "status" of the field to "linked"? Thanks a lot and bye from Italy. Simon

hi all I have a FM7 application with 5000 products. Every product has a picture. But the database is 2,6 GB. Ofcourse because the images we use are sometimes +600kb or more. There are bmp's, jpg's, pict's and other formats. So it's very hard to do this automatically. Does anybody know a plugin to do this auto? this should excist, because i think it's a problem that many people have. And it would be a nice utility! Thanks for a fast response (because i'm busy with it right now)

Is it possible to add a PDF file inside a container? I am strongly considering purchase after reviewing the demo for a couple weeks. I am interested in creating a DB that will hold all my serial numbers and software reg codes. I also have some pdf's that are screen shots of online purchases and am interested in finding out if I can add these as well. One other question. Are there any sites out there that might possibly have a template that could possibly suit my needs? Thanks in advance. .

Anyway to have a timestamp field change automatically by modification of a given field? (without using a script...)

Hi, I'm trying to make a field display something that could be either text or a SORTABLE date (otherwise I'd just make it a text field with no problem). Here are my 3 fields: AtPrePressDate (date field) Completed (text field, which is a checkbox giving "x" when checked) Status (a calculated date field) if(Completed="x", "Completed", AtPrepressDate) AtPrepressDate obviously displays a date ok, otherwise I get the "?" in the field. I played around using the Case function instead, but couldn't really get it to work sufficiently either. Any ideas? I'm probably forgetting something simple, I always do that.

I am new to filemaker, I have two fields and need to insure field a is greater than field b. If it is less that b I need to keep a blank and display an error message saying it must be greater than b.

Is anyone having difficulty with FM 7 'Get(RecordNumber)'? The help file says it works just like the old FM 6 'Get(CurrentRecord)', but my db shows a record number for the entire file, not the current found set (which is smaller).

A global container field in FM 6 file holds small jpg, when the file is closed and re-opened the global container is empty. There are 2000 records in the file but no images, file size fairly small. Another sample FM file I created with 4 records doesn't have this behavior, it retains same small image in global container. Please, does anyone have ideas on what to check in the file with problem? Thanks.

Hello there. I have a database that currently has more than 350 fields and 200 records, with 20 layouts. For calculations, I've been using mainly the "If" function, and some of these calculations are quite massive. I suspect that this causes my database to take up to a minute to update all records when I start up, and this situation will only get worse with time. Recently, I've been coming under the impression that, for the type of calculations that I'm doing, the "Case" function will achieve the same result as the "If" function, but faster and cleaner. Therefore, my question is: If I completely redo the calculations, changing from "Ifs" to "Cases", will…

Hi everyone, This post isn't as complex as I'm making it look ... it's just that it uses a few different TOs and a few number calculations so I want to be sure everything you need is listed. Goal: Predict weight of package. Three weight factors: Product, Box (plus packing materials) and Literature (can be substantial also). In Product table, Product X weight displays 24.58 (approx 1.5 lbs) and this is pulled into LineItems (based upon ProductID). Both BoxWeight and LitWeight are determined by the Rules table. Owner plugs in those figures (in one record) to default-enter the value. He then tweaks the Rules table to improve accuracy. Rules is joined to Con…

I am trying to determine if it is better to use a calculation field or a auto enter field for this particular situation. Situation: Invoice system, invoice table and line items table. Each line item has a set of fields item number, quantity, description, price, discount and extended amount. Now, what would be better for an invoice system, to use a calc or auto enter for the extended amount field? Could anyone give some advice on this? Thanks

We want to keep track of a persons job classification. We import the data into FM via an Excel file. So basically if the job changed from "programmer" to "janitor" we would like to see a list of that. I tried doing 5 repetitions for the Classification and Classification Timestamp fields but it just keeps overwriting the first repetition and won't add new ones (leaving existing ones alone). Any ideas? Thanks!!

I am trying to design an invoice and stock system for a friend who has a bar and resteraunt and have now found out how limited my knowledge is. Of the 360 items sold, about 80 have multiple stock ingredients. How can I show the correct stock. I have the invoice file related to the line items file and the line items file related to the items file

We have a database that tracks tests. One field shows the date the test was ISSUED. Another field shows the date is DUE. We need a due date to calculate the Date ISSUED plus 11 days. So for example a test was issued on 01/01/2005 we want the DUE field to automatically pop in 01/12/2005. How the heck do we do this? We were able to do it with FM Pro 5 by doing DateIssued + 11 but that calculation does not work in 7 HELP!! Thanks!

Is it possible to edit the value of a summary field type? e.g. I have a summary field type of Total Price of $4000 but due to some circumstances, I need to modify that $4000 to $3500. The ideal solution would be if I am able to leave the original total price of $4000 then copy that value to a text field type and edit the $4000 to $3500 in that new field. Currently, I cannot modify either my original total price nor my copied total price. Any ideas/solutions will be much appreciated. Cheers, Ren

can this be done?

Hi I would like to extract date and time from a timestamp field. Are there any more 'elegant' methods than using left/right/middle string functions? Thansk for interest and suggestions

I'm a FM7 newbie, so be kind as I come up to speed on what looks to be a great product. I want to present a user with a list of 30 possible fields (i.e. First Name, Last Name, Address) and allow them to "select" fields via a Yes/No radio button which is associated with each field. So in this example, lets say the user selects 12 of the 30 fields. Then the user hits a button (let's call it "Build") and new layout is created using only the 12 fields selected. Finally, I need to be able to publish this to the web. I'm sure this can be done...can someone point me in the right direction? Thanks.

Hi, I have a table, which I created and I want to archive the data in that table to another table. so table one is tasks table 2 is tasks_archive 2 qs: Since I already have the tasks table created is there a way to just say "copy task to task_archive" - so I can get the schema/field defs -- rather than having to type all the fields in again? for archiving like I describe, I basically want to append a batch of records from one table to the other - is there a script step to do this or should I loop across back and forth between two layouts copying the fields ugggh! thanks for your help in advance, sincerely, J__

I want to format a field to have the record # (the way it is in the toolbar on the left) - and then also show total # of records, etc, etc...I tried doing it as a serial # - but the problem here is that if you delete a record, it doesn't adjust the way it does in the toolbar. ANy suggestions on how to do this? Thanks! Sarah

I'm trying to create a 3 level type selection process... Choose the Type of Business...then a corresponding Category... then a sub-category corresponding to the Category... ie - Service - Administrative - Data Entry Thanks to LiveOak I managed to get the Type and Category working okay, but when I try to set up the sub-category field it displays all subcategories as opposed to just the ones related to the Category chosen..I've selected the option to "include only related" when setting up the value list... Any idea what I've done wrong? ~ Julia

I am new to Filemaker. Am using repeating fields in an invoice. How do I analyse all the itmes used in a repeating field? eg say from 10 records that have 5 items each in a repeating field, I would like to create a report that would group the items by type from all 10 records and have sub totals etc. is this possible? thanks

I have a layout that I need to print pictures from: I print 1,2.4.& 6 pictures per page, I used repeting container fields for this. Is the best method of doing this or is there a better way? I read in this forum all the time to avoid repeting fields. So I'm just wondering if there is a better way to accomplish this task?

I have just finished a database for school use. The administrative staff have asked to include an emailing option to automatically send emails to students. Each student's user name for their email is simply the first letter of their Christian name plus their surname. "Mick Fleetwood" would have the user name: mfleetwood. In our school email system. it is only necessary to type in the username (e.g. mfleetwood) to send an email to the student's school email address. Could someone help me with a calculation that would take the student's full name from the Name field and put it in another field (a calculation field) as described above. This was my effort to da…

I need to insert a PAID gif. file into my invoice table when customer has paid. Can I do this with a container field & a script connected to the date paid field? To have it inserted right in the middle of the invoice at the time when paid, and not be there until it's paid? And how can I do it if its possible? Thank you

I have 2 db's and want to import some address information from DB1 to DB2... I can portal it and that's easy, but how do i do that if i want to place it in a text field so I can put City, State, Zip all in the same line? In the same db i would do something like "<<city>> <<state>> <<zip>>, but how do i do that when i have to reference it from another file? would it be like FILE2::city? thanks

I have a layout that I'm using container fields in a portal to store pictures (actually a reference to a picture) but sometimes I have 3 or 4 and maby as many as 10 pages, my problem is that when I only have a few pages like 2 or 3, when I print it wants to print all 10 pages ( as that is how big the table is) I would like to have a script or some way of printing only pages with filled container fields. And not the empty pages. Right now I have to physically look and count how many pages to print. Which is ok until I forget to look and just hit print and I get all 10 pages. I dont need 6 or 7 pages of empty container fields. Anyone know how I can fix this?

Hi All, How do I get a text field to always display "******" like in pasword fields?? Dan

Hello, Is there a way to have a date as a number field? I use several concatenated fields as a match field for a number of lookups and matching-record imports. All of the fields are number fields except for a date field, which has meant I use the numtotext and datetotext functions and the match field is defined as a text field. The lookups and imports involve large number of records, and I've noticed FM is much slower processing text fields in this situation compared with number fields. If there is some way of using a number for the date, so the match field can be a number field, and both FM and I will be happier!

Sorry, I am a newbie at this whole filemaker thing. I am trying to use a container field to put multiple pictures or word documents in each record. After reading some of the postings, I still can't figure out if it can be done. There is one that says you cannot put multiple pics in one container, but then there are others that seem like you can. I've tried putting a whole folder in a container field, but it literally puts the picture of the folder in, not the contents. Can a container field only hold one file at a time?

Hi Everyone, I am sorry, I know this has been asked a buch of times but I still can't get it to work. I would like to save PDF files in a FM database and be able to open them using their origanal program! I know how to do it by just saving a reference to the file, but not by saving the entire file. Would it be possible to move a copy of the files, via applescript, into one folder (associated to the database) during the import. That way I could one folder that contains all the PDFs and I could be sure not to move it or delete any files. I am using FMP7 and OS 10.3.8. Thank you very much for your help Sebastian

In an earlier version of FM, I used the sum function to gather the various totals of change orders in a related file. I created a relationship for each change order and had the program match the change order numbers. Now in 7, I get nothing. I have read what I can find but there seems to be very little written on the sum function. What changed in 7?

I have been using FileMaker for some time now but more in a flat file manner... And it was due to a specific question I posted awhile ago, but there

I have to build two solutions that require calculations in a record that are evaluated based on values in the preceeding record. For instance, one solution is a training log where an individual's performance on a particular exercise is tracked. As the individual increases the amount of weight being used in the exercise, another field displays the percentage improvement over the previous recorded amount. In another solution, I am recording a series of odometer readings. Each record has a reading but it also has a field that displays the difference in mileage between each odometer reading. I'm lost and was hoping that someone could give me an example of how to …

I have a parent / child database, records that exist in the parent table may or may not have a record in the child table. The form displays the parent data and the child data as a portal. I need to list all parent records that have a particular value in the child table or do not have a child record at all. Currently, the find option only displays the parent records that have a record in the child table and ignores the parent records that have no child records.

Hello, And thank you in advance I'm trying to simplify a Case calculation in Filemaker pro 5. I have two fields: Score and grade. I would like the grade to automaticly appear when I enter the score. The calculation I've created works fine, but I would like to know if it is a easier way. In my calculation I have to enter every number, for example: 60 = D, 61 = D and so on is there a way to say from 60 to 65 = D Your help is much appreciated thx [email protected]

When printing a form I have the page number inserted. How do you count the total number of pages you are going to print so you can have Page 1 of 3 inserted? Phil

I have a database with a calculated text field that builds a file path, based on information in other fields and adding the suffix ".jpg". There is a calculated container field (that references that text field) to display the jpg image. I would like to make another calculated field that return YES or NO, indicating whether the container field shows an image or whether it displays "THE FILE CANNOT BE FOUND" (due to a misspelling in the jpg file, or simply because it doesn't exist). Is there a function that can do this? Thanks in advance for the help.

Is it possible to tell an audio file in a container to play and loop from a script or container calculation?

I'm very new to FileMaker. MS Access has a great Calender ActiveX Control which you can link to a field to easlily select or change dates. I can't see a feature like this in FileMaker. Is this possible?

I have 2 text field in a database one text field can enter unlimited characters but the other one LIMITED up to 717 characters. I checked both field setting are same. Does anyone know why? We're using FMP 5.0 Thanks.

I've got a bunch of container fields. They fill themselves with an image from one of two fields. The container either gets nothing : "" or red.png or yellow.jpg Then i have a text field which is a calculation.. the calculation is simply the name of the container field resulting as text-- so it gives "", "red.png" or "yellow.jpg" This all works fine.. I have a layout that shows both the container field and the text field, and I see a bunch of graphics with the appropriate text beside the color. A bunch are yellow, and a bunch are red. When I do a find on the text field, if I search for "red.png", it finds all the records th…

Hi Forum! I have no idea where this should go. I've searched and have hit deadends on every thread. I have a series of letter templates with an extension of ADT. They are Word documents (at least their extension is set to open with Word) but they are from Act. They contain merge fields as [[Contact:26]] which were Act fields (which I'm pleased to say is no more). I'm more familiar with WordPro/AmiPro and WordPerfect. But Word should be able to use FM's merge fields here, right? How do I transition them over? And once transitioned, how do I choose which table occurence and record should fill the Letter merge fields? How do I call it? Can I automate…

Hi I would like to open a ms word document with a script using a field to define the document address. I can open the word application and define a specific file for that script using send event, but not for a field. I am sure this an easy and common task to peform. Any help would be greatly appreciated, Alex

Hello All, my field contains (must contain) the exact number of 12 characters. Example R9912345-LAX. How can I get a message pop up if a user enters less or more charcters? Even if it doesn't tell which charcter is wrong it makes the user at least check his/her false entry and with a little luck find the error and correct it. Thanks in advance, Andy

I have a field that give me a total of days, when i do a evaluation (sumerise field) Ex: 70 days In the footer I have a other fields that give me, how many time its gonna take doing this with a "X number of ressouce" EX: "1" person, then it will be 4.5 months. "2" persons then 2.2 months "3" persons= 1.5 months etc . . How can i make the calculation smarter by telling me:1 person= 4 months, 2 weeks. or 2 Persons = 2 months , 1 week P.S = a Month for me it is 20 days (no working during week-end Yeah P.s2 = So a week is 5 days thx, guy

Is there a way to change the text format automatically in the fileds within FM? I don't mean all the text formats FM gives you - but by copy & paste text into a field the format will appear as styled text...So if user do some research on the web and copy data into FM fields (without any buttons and scripts to paste the text without style) everything looks like patchwork...