The Left Brain

I'm using Troi file plug in to get a list of mounted disks in the field disks, i would like a script to do something if the field disks contains "job" and something other if the field not containing "job".

Is there a way to clear all globals in a table? I have a table that contains all of my global variables. I would like to be able to use a script that would clear them all out as the first step. I have tried: Show All Records Delete All Records but the nothing was cleared. I know that this works: Set Field [GLOBALS::color_g;""] Set Field [GLOBALS::type_g;""] etc. etc. but I have so many, it would be nice to have a cleaner way. I have searched the forum, but not found an answer that worked. thanks

I don't know where to post this so I thought I'd start here. I work for a small company (7 employees). Each employee has their own contacts either in Outlook or Mac's address book. The contacts are not all unique, we all have some in common. We also have a FM database with everyone's contacts combined. Some of our employees are getting tired of adding contacts in two places, and want to know if they can sync their contacts with FM. Who's already doing this and how?

I want to know if anyone has done this and how. Here's the situation, you want to create a global var on the fly. You don't know the name or value until you instantiate it. I was trying to create a script that would allow me to create a named var on the fly rather than explicitly naming it. My first attempt Let ( [ expression = "Let ( "$$" & myvar = myvalue" ] ; Evaluate ( expression ) ) results in an error because you cannot concatenate the name value in the LET statement. Second attempt Let ( [ var = "$$" & "myvar" ; val = myvalue ] ; Evaluate ( var = val ) ) returns zero and no global variable created.

I've read and tried to use different phone formats like instead of showing 5555555555 it shows (555)555-5555. But each time I try to use one, I get an error message or it doesn't work (or just doesn't like me, haha). So here is the latest one I have been trying to get to work, the bold,underlined, and italicized "format" is where I get the error saying the specified field cannot be found. Any help on trying to implement this would be appreciated, thanks - Jeff Let( [NumbersOnly = Filter(Phone; "0123456789"); NewNumber = Right(NumbersOnly; Length(NumbersOnly) - 1); NewFormat = Right(Format; Length(Format) - 1)]; Case( not IsEmpty(Format); Case(…

hi guys first post here. I am looking for a way to parse each instance of "friendid=870987" in an html code i have scraped with the web browser. This is my first foray into parsing data and after several failed attempts i'm getting a little discouraged. Any help would be much appreciated. Dave an example would be pulling this data from the following html----> [*] Steve McQueen >>>>>> 184040237 Steve McQueen also making a new record for each unique found id. Thanks

Hello folks. I'm baffled. Is there any logical way to use a column of data in an .XLS file as criteria for "finding"? If so, what's the execution to make this happen? Wouldn't the ability to import data into a find request and FM automatically create additional find requests for each row be an excellent feature, or am I on drugs? : heheh Thanks in advance. Tony - Las Vegas

I have written a program that manages ambulance dispatching. One of my customers has requested that a warning be displayed whenever a scheduled event has not been completed. Example: Patient is to be picked up at 8:00 but the driver has not reported in by 8:01 I can write a calc that compares the current time to the scheduled time, but I need to run this script on a continuous basis or at least every 5 minutes or so without it being initiated by the operator. Is there a way to do this? Is there a better way to check for expired times and warn the dispatcher other than using a script?

I am a doctor and I need to store patient info like photos and Xrays. I have downloaded a very useful freeware program called "medistic". This program lets you import a thumbnail of a pic of your choice. I also has a "Open" button that should open the jpg file. In the original script provided with the program, it opens the file in Safari (with an "open URL" command), but I want it to open in Preview. I am having trouble creating a script that opens a .jpg file that is in the container of the database. So far, I have gotten Preview to open a specified file but not the file that is contained in the record. Can anyone help?

Basically, I have about thirty tables with actual information, and some additional "working" tables for scripts and such. What am wondering is my relationships screen too complicated? Am I missing something about filemaker uses relationships. I have attempted to organize according the particular "function" and name the table occurrences accordingly. Needless to say I am finding it difficult to organize and name. I have attached a screen shot of part of the relationship screen. There are nine sections each a green title bar: Unit Information, Lock & Keys, Tenants, Lease (for one script), Accounting, Reports, Management Screen, Value Lists, Separate (e…

I am looking for a way to have a script check to see if a specific layout exists. Is that possible? I want to see if the following layout exists: (ScriptParameter) & "-guest" Any thoughts? How can you search the layout list?

I'm importing 500,000+ records froma tab delemited file. The file does not have package IDs and I need to create them. the logic is that the package ID starts with 000000001 and increments by one after the tenth record. I would appreciate any insight in to how I do this. Would the Let function be what I'm looking to use and if so can you suggest a syntax?

I'm not sure where to post this but it does involve complex calculations but also scripting. There is an example file to do this at FileMaker Magazine I incorporated this into an FM6 database for myself a few years ago and haven't looked at it since. I've just come out from under a rock and converted to FM 8.5 but the calculations seem to have broken, e.g. There is a calculation called "Power Path" which maps the file's file path and a script then launches the file. In FM6 the field definition is: Case( Left(FilePath, 7) = "http://", FilePath, Left(FilePath,2) = "./", Case( Status(CurrentMultiUserStatus) = 2, "Shared File - No Path",…

I have a Grand Total that is a summary of multiple records. When I make a change to any field I have to go to a different layout for the summary to update. Is there a way to force the summary to update immediately?

Is there anyway - perhaps with a plug in - to see when someone has changed text in a field in a shared database. I am looking for a way to do this in the same way that Word does. I edit a newsletter and want to put the articles database on a server. Then the proofreader could make changes in the article and I would be able to easily see and approve or reject her changes. Thanks, Rich

Hello. The calculation below was working perfectly in version 8. In 9, it's broken and returns a "?". It's a calc I picked up from this forum (I think) that wonderfully formats text for a later InDesign import. Note: The "Body Copy" is the field name reference. The paste here can't negotiate the special characters. Thanks for any help!! Let([ k=Substitute(Body Copy;["¶¶¶";"¶"];["¶¶";"¶"];["¶¶";"¶"];["";""]); a=Substitute(GetAsCSS ( k ); ["";""];[""";"""];["“";"“"];["”";"”"]; ["<";""&Let([T="<"]; [">";">"; S=PatternCount(T;"SPAN"); X=PatternCount(T;""); B=MIN(1;PatternCount(T;"WEIGHT: BOLD")); I=MIN(1;PatternCount(T;"STYLE:ITA…

Hi all, I'm relatively new to the FMP scene and work in Australia. I need a script or a formula to calculate dates in the dd/mm/yy format and not the American mm/dd/yy format. Any help would be greatly appreciated. Thanks.

To break the problem down to it's simplest form, I have a case statement that looks at a field "Modified Today" and if the field is today return Active else return Inactive. Sounds easy, the problem starts tomorrow when the field never gets re-evaluated for Inactive. I can unstore the field so it's get evaluated during browsing but I have a portal on a another database that looks up my active work but is empty due to the unstored field. Any ideas? Below is the Case Statement: Case(Modified Date = Today,"Active", Order_Status = "Job In" , "Active", Order_Status = "Progress" , "Active", Order_Status = "Approved" , "Active", Order_Status = "Reproof" , "Ac…

Hello there - Any help or advice on this would be greatly appreciated. Basically, I am creating timestamp fields that cover the beginning and end of reservations times. I'm wondering if there is a calculation function that will count the number of time overlaps and then post that information in a different field. For example, if I had one reservation from 3-5pm and another from 4-6pm, I want Filemaker to record that there is a conflict with the 2nd reservation.

Hello Forum! I've been using custom functions for few years now (gleaned from Topic #120434) in merge letters. When we create a letter with merge fields, we always handle it like this ... Dear <> or even Dear <> If I can guarantee there will be no other green colors in the text (standard black-text letter), can I instead replace the merge with something like this: Dear [color:green]FirstName Of course we want that style removed in the final letter but, when a path is long, using merge fields can be quite confusing and messy. And if a User needs to remove an existing merge field, they sometimes leave pieces of it behind. Bummer. …

OK, hopefully I can explain this well enough! Here's the database info: Database holds 'People'. One table. People that are 'related' to each other share a 'Family ID' so you can track relationships that way. So, we have student Bobby, father Bob, and mother Betty. They all have a unique ID, but share the 'Family ID'. So, when you are looking at Bobby, or Bob for that matter, you will see a related table that shows everyone else that has the same Family ID. So, one table, using a Family ID, to show the same people in that TO that are 'related' to each other. I didn't want to do a child Table and then another Table for other people becaus…

Here is the challenge: We are building a tool to control the naming of the items we produce. We have created a custom dictionary with abbreviations for each word, symbol or phrase. We need to force the users to only use those words, but envision an auto-fill type tool. They start typing a new description, but the dictionary only allows them to use the defined words and phrases and uses an auto-fill function to do so. Additionally we need to allow the use of whole numbers without having them added to this dictionary (if that's possible). If there is a new word or phrase needed it will require a request through an admin to have it added to the custom dictionary. …

Hi, I'd appreciate any help or pointers I can get for this project. Basically, my office has three multimedia projectors to loan out to faculty, and we want to make the rental system with Filemaker. So I've created web forms and everything to enter name, date, and stuff like that - but now I need to figure out how to take care of date conflicts. My problem is that I need to make the system so that only 3 projectors can be checked out per day. So that if someone tries to enter a reservation and they are the 4th rental on that day, Filemaker will not validate and I can set up an error message. Right now I have 1 basic field called Projector Conflict. I…

I have one table with several related tables. When and edit is made in the main or related tables, I would like to know which table has the most recent modification to it. To get the mod date or time I am using the Max function. The challenge is getting the 'max' user.

I will soon have to collect sales tax in more than just my home province, and I'm wondering if there are any best practices in this matter. I currently have a field for the rate (auto-enter the current Ontario tax rate), and a calculation field for the tax. Do I go simple - just change the rate depending on the ship-to province, and carefully make sure that sales-tax-reports never combine them? Or do I go a bit more complicated and add a new field, or (gasp!) a related table for sales tax. (might be an especially good idea if I plan to collect sales tax for a larger number of provinces in the future?) I've noticed looking at other invoices that it seem…

Hello, my name is simone, i would like say congratulations for this community! :-) i have got a problem in a file maker pro 9, im not able to visualize report any more for a script, i see the script in layout mode and seems fine but when i go on report view the page is blank, i would like ask you kindly if you are able to have a look to file attached best regards and thasnk for your help Simone filemaker_to_do.zip

I have a portal with records in it. In each record I have a date field. All I want to do is a basic find search to show all 2007 year's information. Filtering out 2008. I tried range... , =2007 nothing works. Why not? What am I doing wrong? A search should work in a portal should it not? Help

Is there any POSSIBLE way with a plug in or any type of external intervention to upload a pic from a container field to flicker or photobucket or for that manner just to an ftp site.

This maybe impossible, but we have a list of comment in a petition and would like to find common phrases among them. Does anyone have any ideas.

[color:red]This is my first post, so bear with me - I haven't quite got the Filemaker lingo down yet. : I have created a file containing all of our contact information (fields are named the same as the fields in Microsoft Outlook), and would now like to have these records automatically import into our employee's Microsoft Outlook Contacts (could it do this weekly on it's own or at a click of a button?). Unfortunately I have no clue how to do this. Do I need a plug-in? If so, which one? Thanks!

I'm trying to design a fairly stripped down FM db that will allow collect data from the Library of Congress to create a library catalog for a small school library. I would like to make it so that the user could enter the ISBN, and the database would query the LOC (most likely via Z39.50), and then have specific data (title, author, date, LCCN, and Dewey number) entered into a record. Anyone have any advice on the best way to do this?

I'm trying to make an "isDeletable_Boolean" calculation field and I can't quite wrap my head around it. I want to make sure that if the Institution_ID is used anywhere else in the database (which could be in students, courses, contacts, professors, etc.) you cannot delete the institution. I've done this before but it has usually been much simple with just one referenced field using If ( Count (student::constant) > 0 ; 0 ; 1 ). But now I need to check in many different places. Thanks for any help. UPDATE: Well, I solved it but my solution is definitely not very simple. I'm not sure if there's something out there that is simple.

I'm looking to make a selection calendar. I have a general calendar from the theme library and seedcode's free template. I like the idea that the user can change a global date field to modify the calendar in order to select multiple dates for an event. I don't think I want to get into recursive calcs, frequencies, and occurrences so I'm going with a UI that allows the user to pick the dates (either random or structured). What I see is attached in the AI Doc. Can some help? The buttons would patterncount the date I guess and set a Date selection global that I would have a finish button to script the creation of the selected dates.

Hello, My boss wants me to make a solution that will tell her who DIDN'T do an activity. Example: Say you have a solution to track training. A user signs in and does presses the "Yes" radio button or whatever at the end. You could easily generate a list of who DID participate, right? But how would you go about providing a list of who DIDN'T participate? Because if the employee never signed in the system, you'd never know. Say you have 50 employees, you could easily find who did the training. Pretend 15 people didn't do it... so you have a total of 35 who did, and you could name each of those 35... but you don't know (without cross checking by hand) the names …

Hello, I have a database with which I log time spent commuting in my car. Each trip is a new record, and I have over 3500 records. I have a summary field that adds all the times together so that I have a running total at the bottom of my layout. Each time I put in a new record, there is a noticeable delay in showing the summary total at the bottom of my layout. Is there a script, or faster way to summarize these totals??? Thanks, Tom

Hi, Rigth now when i pass a argument to a script from my understanding, the argument is passed as a value copy. Is there a a way to pass a field as reference? so i could modify the field's content in the script. somebody told me no so i wanted to check here first, but he suggested i name those fields with the same ObjectName and i could do it like that. any input or idea about that? Thanks

Have a solution hosted on a Filemaker Server 8. Have a table (Constants) used to hold global fields. One record. When I open layout on hosted solution and enter data in a field all is well. When I close the solution and reopen it the new data does not save. If I open a copy of the same file as a local file and enter data and close then reopen it the new data is there. Why?

My clients has contracts entered with loose descriptions for dates. Fortunately they are consistent with typing the month before the date. e.g. Fri June 29 - Sun July 1, 2007 Apr 26 - Apr 29, 2007 Friday Jan. 12th & Saturday Jan. 13th, 2007 For sorting reasons I would like a calc or custom calc what would extract the first date in the string. Has anyone see such a function? If not here is what I am thinking: 1. sub out all day name and abbreviations. 2. sub out all punctuation and ampersands. 3. sub out all double spaces. 4. sub out all number extensions 4"th", 3"rd". 5. sub all full month names to abbreviated 3 character names. 6…

Out of a text field I need several results: 1. Total count of words (wordCount function - no problem) 2. Total unique words 3. Number of sentences 4. Average words per sentence 5. Break down of word lenght (how many 1 letter words, 2 letter words, 3 letter words etc.) Any hints how to start doing this ? TIA

hi guys. I'm trying to export my FileMaker table to an Excel file, which is very easy. However, for some reason, the text from my drop down list does not get transferred across. Does anyone know a way around this?

I have four tables. Compounds Treatments Treatments_Compounds Join Weight The weight record is a related weight (grams). Treatments is just a table that records the event Compounds have information about them including the appropriate formula that has one variable that needs replaced, current weight. An example is x/20*100 were i need to replace x. I tried the Let fx but couldn't get a number result. Can anyone help Thanks M

Hi Matt at Filemaker Magazine has previously made a video about how to store graphics into $$globals, which I use now. The great thing is that the graphics is loaded into the client machine's memory and therefore loads fast. I use this primarily to buttons and checkbox graphics. The display e.g. of the checkbox graphic is fast, when it is loaded into $$globals. However, If I have 40-50 graphic records in the graphic table, the startup script, which loads the graphic records into $$globals, takes quite much time. Especially when the data file is opened over the internet. My schema is; Data.fp7 holds all data and the graphics table. This file is served from File…

Hello everyone, I'm new to the forums and pretty new to filemaker as well. I'm trying to accomplish the following, I have a list of serial numbers that have no one assigned to them, I'm looking to have to boxes in filemaker one will have the name of the individual I’m assigning these serial numbers to and the other will have the serial numbers being assign. I want to have a button that when i click on it will update the list for me. But I have no idea how to even start. Can someone please help me? Thanks in advance.

I apologize if this has shown up in other post. My question is, Is it possible to find the modification date of a file? Not the record, but the file. I looked at the get functions and couldn't find a way to do this. My reason is: 1. I use a script to backup my FileMaker database. 2. I have a field titled last_backed_up. This field gets time stamped ever time the backup script is run. 3. The backup script goes through multiple tables to see if any records in those tables have a modification date that is different compared to the last_backed_up field. 4. If there is a difference, the script then backs up the FileMaker file. If there is no difference,…

I am working on a solution to record start, suspend, resume, and completed times for any record. Its kind of a production event time tracker where the event can be stopped and restared at will by the user. Anyway... I have a workable solution (attached) but i would like to do it without the portal. If someone here would be kind enough to take a look and: A. reccomend a non portal solution B. advise me of any pitfalls when this is deployed in a multi user situation via server I would be humbly greatful. TIA Kris Test.zip

Hello everyone, I am working on a simple report card database for a school. Everything works correctly, except for converting number grades to letter grades. They want the ability to input number grades or letter grades into the database, but print only letter grades. No problem, just have the fields set as text fields and write a custom function that will convert any numerical value to it's corresponding letter. For some reason, my custom function is returning incorrect values for numbers greater than 99. It appears to only be reading the first 2 digits. For example, it will return an F for 100 and will return an A- for 900. Granted the 900 figure is …

Hoping someone has an easy solution to finding annual and biennial dates where the result omits weekends and possibly holidays. Any help is appreciated.

We are bulding a online tool for physics students where the student needs to be able to enter something like 6.23*10^-11 in one field and have it be evaluated as a number. This would be easy enough to do in multiple fields, but the idea is to have the students think of this as one number. If we could somehow parse the field contents and seperate the parts of the expression we could then do the math in the background and evaluate the number to see if it is within a specific numerical range.

I hope this post is in the right place. I have a database with multiple patients. Each patient has multiple records, which is accessed through a portal. Pretty simple so far, but I need to be able to have a field which automatically tells a user how many records each patient has so that they don't have to count. I'm really not quite sure how to do this. The patients are on one table, and the records are on another. Each record has its own serial ID assigned at creation. Each record is related to the patient according to that patient's SSN. What's the best way to handle this? Edit: I was able to figure this out myself by simply working with functions until I …

Hello All, I have a time log db that works well. Now the boss would like it to operate as if it were one of those magnetic boards that are used to track in and out status. I am sure it can be done, but I haven't got any idea where to start. In the attached file there is a table called TimeLog. It track the time a person logs in and out... (Obvious LOL) I would like a layout that lists all Employees and there real current status. It also needs to update dynamically as they log in and out during the day. Thanks... Lost in Thailand SupervisorLog_V2_Clone.zip

hello back again for some help. i have a report that is sorted by c_monthyear, it was working fine until 4 weeks ago. as you can see by the "reports.jpg below i get double months, and no july and other months. in the c_monthyear.jpg is the calculation. so i am saying the date of the invoice_date-4 i get a wrong calculation if i change it to invoice_date+4 it works or invoice_date0 any ideas as to why this is happening. thanks Robert

Hi all, I could use a little help, being a relative newb with FM and all... I have a db for courses and students, and have a portal that displays who is on each course. This is fine, but I would like to have a button that will draw the info from the portal so that I can email the entire group with one click...any ideas or suggestions sure would be welcome... thanks for your time...

I have a container field I would like to record sound via the microphone. Filemaker requires a double click in the container field to activate the record mechanism built in but I need it to be a single click button. Any suggestions that will work cross platform (ie, no external scripting) for a runtime kiosk application?

I have all my classical cd collection database in FM8.5. The cataloging of classical music is by composer, work, movements within each work, orchestra, soloists, conductor, etc. iTunes does not work well because the naming convention is so different--(it makes a real mess of titles and movements). Now I would like to que them to play -- I'm wondering if FM can used for playback of a kind of "playlist". It needs to play multiple files in succession like iTunes does and I can't see a way to play more than one track at a time manually by putting each track as a Quicktime file in a container field.

Ok so I know that this is a old post... but I've got a question along these lines... Our db was set up to have a billing and shipping address, the street address being one field. ie. "245 S. Lincoln St. Apt #B". We ship our products mostly in the US and Canada, but there are the occasions when we ship internationally as well. So now we have a customer file with over 15,000 records in it all with the one field Street Address (ok 2, Billing Street Address and Shipping Street Address). My problem is arising because some states in the US are going to a Sales tax rate charge by destination, both of the 2 states where we currently collect sales and use tax are eith…

Is there a way to get a field label or text object to 'automatically' shrink down after deleting some of the text, to its new minimum size without having to do it manually; ie. click and drag??? Fitz

I have a field with numbers. ie, 1-14,000. I nee to make them into 6 digit numbers starting with 000001 through 014000. What is the easiest way to enter a calc to do this? Thx Dave

I inherited 2 repeating values fields (7 values each) and need to now do some reporting on them. The fields track Ancestry (Mothers Ancestry and Fathers Ancestry) each hold names of countries that a person ancestors come from. The ultimate goal is to have a count of people reporting they families come from what country kind of like: Country | count Ireland 335 Germany 487 China 28 Switzerland 46 etc... Since each person has 2 fields, I think I need to merge the 2 to simplify thigs. So is it possible to merge 2 repeating fields into one without having duplicate values? Also if you have any other suggestion or advice it would be gr…

I have an 2-column excel file that I'm importing into FileMaker. The columns are Date Description After the import, in a third column: Type I want to display a shortened description based on the one imported. e.g. if imported description is: Safeway PMNT 00554 XLD 01/01/07 the short description would be: Groceries BUT the tricky part is that i want to base the parsing on another table. That is, there will be another table that has 2 fields: Keyword (in our case a record would show Safeway) Type (in our case it would be Groceries). Thanks

We use a sliding scale to charge our customers for shipping. I have been playing with different implementations of this and have gone as far as writing a really long calculation field, but there's gotta be a better way. I've attached an image of our sliding shipping scale. It's pretty straight forward until your order reaches $300 and then you start adding percentages. I'm using this data as part of a database to calculate item costs. I'd like to be able to select the shipping method (in a Shipping Method field) and then have it use the data in my Price field to retrieve the related shipping charges from the table (attached). Can anyone lend a hand…

Maybe I had too much Christmas Cheer, but I can't seem to get this to work. I'm hoping that this can be done as a Conditional Formatting, but I can't figure it out. However, I would settle for any method If not. Here is what I would like. Currently I have two fields (Notes, a Text field, and Char_To_Color, a number field). I want to to enter a number into Char_To_Color, like 15, (or any number), and have the data in Notes reflect the character on 15, and 30, 45, 60, etc. be colored Red, or whatever the multiples of the number entered are. (i.e. 35 would include 70, 105, etc.). Here is an sample of what I'm trying to say. Char_To_Color = 15 …

Solution: parse names Description: I've searched through the forums (honestly) but can't find the script to parse an imported file with names such as BAKER, ANGELA W. & CARL BARBER, JOE into Angela & Joe Baker Joe Barber Case conversion would be a wonderful bonus but I am desperate for the name parse. Working Under: Solution Status: Finished Pre-requisites: Author(s): Joe Harkins Date: 12/21/07 Credits: Instructions / Other Info: Disclaimer: FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written appro…

The following script is used in my messaging solution to reply to messages. Freeze Window Set Error Capture [ On ] Set Variable [ $ReplyTo; Value:Messages::From ] Set Variable [ $ReplyFrom; Value:Messages::EmployeeID ] Set Variable [ $OriginalMessage; Value:Messages::Message ] Go to Layout [ “Reply” (Messages) ] New Record/Request Set Field [ Messages::From; $ReplyFrom ] Set Field [ Messages::EmployeeID; $ReplyTo ] Set Selection [ Messages::Message; Start Position: 1 ] Insert Calculated Result [ Messages::Message; TextColor ( ¶ & ">" & $OriginalMessage; RGB ( 250; 0; 0) ) ] Set Selection [ Messages::Message; Start Position: Get(Active…

I'm trying to create a unique user field that is a combination of a user's first name, their last initial, and a number. To guarantee that every user's name is unique I need to make sure that each new user with the same first name/last initial as an existing one gets a new number appended to the end. For example, in the case of a new user with the first name Joe and last name Smith, the initial combination of first name / last initial would yield JoeS. Since he's the first JoeS in the system, the number field would add the number 1 to the end, resulting in JoeS1 as a unique username. When the next Joe Smith (or Joe Stevenson, or Joe S-anything) enters, the number field wo…

Here I Go Again, I Have a field "StartTime" type TIME I would like it to Display Red if the Value is greater than 08:15:00. I am sure it needs to be done with a text format calc but can't get it to work. If (StartTime>08:15:00; TextColor ( StartTime; RGB ( 255; 0; 0) )) Result=Text That displays all records as red. Help Please I have tried every permutation i can think of.

Hi, I would like to check your opinions on the best method to achieve the following. - The user fills in field A and the record is committed - Other fields in the same table needs to be autoentered with information. Generally, the date when field A was filled in, the time when field A was filled in, the user ID, etc. I know I can easily achieve this with the Set field function, but I have heard that this is not recommended (anyway, I would like to hear your opinions). None of the fields are user modifiable (only via script). A twist to this question is if the fields to be filled in are in a different table: the record to be modified by the Set field …

Hi, In a scripted find, I would like to create field labels for the following: Current year Current year - 1 Current year - 2 etc. This way, the user can search values (for instance, invoicing totals) for current year, previous year, etc. and myself, as developer, do not have to worry about manually setting field labels every year. How do you accomplish this? Merge fields and calculated fields are not an option because they would not display the value while in find mode. Any ideas? Thanks in advance

I have a single table containing First Name, Last Name and Company Name. Let's say I have 100 contacts and all those contacts belong to a pool of 15 companies. How can I display one instance of each company in a single text field ? It's easy in a report, with subsummaries... In other words I'd like to have a single text field displaying the 15 companies existing in the system as unique entries: company a company b company c etc... not as company a company a company a company b company b etc... Thanks in advance for you help!

I have a file which can contain one name such as John Smith or two names such as John Smith & Betty Brown. When there are two names they are separated by an "&". I would like to extract name 1 into two fields Contact1Name and Contact1Surname, and if a second name exists extract it into Contact2Name and Contact2Surname. To complicate matters, sometimes the surname is only included once in the data at the end as - "John & Betty Smith" Is it possible for the calculation to take into account that there are sometimes 4 names and other times 3? Any assistance would be appreciated.

Does anyone have expericence with connecting/using hosted filemaker dbs via VPN (virtual Private Network) I'm currently testing this and would appreciate any input/advice. One of the main problems is connection speed to one of my main dbs which is a total of 21 mb. i'm a bit in the dark if the db size is causing any problems although i don't think it will be although there are a few graphical interfaces within the database - any ideas? Thanks in advance, ricardo.

I have a portal that lists all case numbers related to a person. I want to make the case number field in the portal go to the record that is listed when clicked. Any ideas??

I need to code in a case number that will be like this: Name: Jane Doe, Phone Number: (555) 555-1211, and the number of the investigation = "DOEJ1212-001" for the first record. If there is 5 records on this same person it would show "DOEJ1212-005". My issue is how to make the field called Case Number reflect this code. Thanks,

I have a file which can contain one name such as John Smith or two names such as John Smith & Betty Brown. When there are two names they are separated by an "&". I would like to extract name 1 into two fields Contact1Name and Contact1Surname, and if a second name exists extract it into Contact2Name and Contact2Surname. Any assistance would be appreciated.

I have a client that supplies goods to a large amount of endusers. They have asked me to investigate the creation of a FM DB that can create a run sheet for the drivers. I have no idea on how to approach this type of thing, any help would be great.

It seems like there are a lot if inventory related questions here, so I hope I'm not repeating a post. I think I need a recursive function (which I'm not too great with) but any guidance will help. I have the following fields: QTYONHAND ( must be >= 0 ) QTYCOMMITTED QTYAVAILABLE ( qtyOnHand-qtyCommitted ) can be negative QTYPENDINGpo4CUSTOMER ( After pulling a part, the qtyCommitted is reduced and this field increases ) MINIMUMPURCHASE ( multi-use - aka unitsPerCase ) MINIMUMSTOCK ( Like a Reorder Point + 1 ) ROUNDQUANTITIES ( switch indicating that the purchase quantity must be in increments of the minimumPurchase - i.e. i…

Hi All I am having a real problem with portal filtering. Just can't seem to get my feeble mind around the concept. Have a db with two tables. Employee and TimeLog. I would like to filter the timelog portal by the current week. Have looked at all the examples i could find and just can't get it to work. Thank you all Supervisor_Log_Copy.zip

Hi, In a solution I am building, thousands of records are created in many of the tables during a year course. For instance, students courses and grades, lines of a project, of a quote, of an invoice, quotes and invoices itself. There is no clear point where this records become obsolete, but it would be safe to say that, six months after the end of the year (june next year), the records are not modified, althought they are ocassionally searched for and browsed. It would be great for searches if this records are not included in the table they search. Of course I could filter by year, but this is not the only issue here. Table size and network bandwidth is imp…

I am building a messaging solution. Everything seems to be working as planned except the reply script. When you click the reply button i would like it to take you to the new message layout and auto enter the To From info. I am sure it has to do with the fact that the record is in a portal. I need it to get the info from the active portal record. Help. Fred I figured it out myself. If anyone has any other ideas please, please feel free to express yourself. I know that there are a lot of ways to do this. All comments are very appreciated and quite welcome. MessageCenter_New.zip

Is there a way to have a "SSN" field convert 111223333 to "111-22-3333". I used to have this down, in some way, but am at a brain dead loss...

OK, Easy answer Stupid Question. Have a field (Read) that is a check box. Valuelist Boolean "1" Check in box and mark as read. I need to count the Number of unchecked boxes.

Hi... I have a few databases at my office that many users are accessing and inputting data. Many of the users are copying data from maybe an email and pasting the text, such as a delivery address and the text formatting is completely different than the field is set for...such as font, font size..font attributes. Is there a way I can control this? The users are inapt or too lazy to go into the file menu and adjust the color or font size, etc.... they just like buttons. So I was wondering if I could make a button to clean the fields up...or somehow force a font style in a field. Also phone number entry is not uniform.. some people type "212-555-1212" and some "(21…

Hello... I'm quite a beginner so I hope I even defined the title correctly. I have a table of products (clothes), a table of Fabrics and a Table of Orders. each product can be made from more than one materials (fabrics). I've defined a portal in the Product table with Fabric1, Fabric 2 etc. and Meters Needed from each Fabric. Now I'm trying to create a Fabric sorted report for the quantities of fabric needed, and looking for a way that I could unify the values in the different Fabric1(2)(3) fields into one field since Fabric2 of one product is actually the same fabric as Fabric1 of a different product. Hope you got me, if not sorry... thanks for any help, Nim…

I have a tab set used for admin functions. I would like it only to appear on the layout when the admin account logged in. I thought I could use JMO's visibility trick (which I have used a lot) with a calc using Get(AccountName). The calc is: ViewAdmin [if ( Show_Admin="Fred Jackson";Invoice ID )] Show Admin is a calc field unstored = Get(AccountName) The Relationship is Invoices(ViewAdmin)= Visible Admin(InvoicesID) The results should be that the a portal based on the Visable Admin TO appears only when the admin usere is the logon account and covers the tabs when anyone else logs in. The DB is hosted on FMS 8 I hope I have given enough info …

I have a set of pdfs that I email and I would like filemaker to batch extract the form data from these PDFs. Is there any guidance here about this subject? I am using acrobat pro 8 on the mac . But I need to get the data from the forms into filemaker. Any knowledge about this is appreciated greatly Many thanks Dave

Hi, Is there any way to send a message to a user when another user executes a script in another computer? A more thorough explanation, just in case is useful, is: - User1 creates a task and assign it to User2. - User2 can see in his computer a list of tasks assigned to him/her, in a list view - User2 press a button in the list view to start the task assigned. This runs a scripts that sets the starting date and should send a message to the user who assigned the task. The popup message must appear instantly in the computer of the user who assigned the task (the user that created the task record). Naturally, this can only happen if the user that is go…

How can I get the date range from a week number? I have a report that gives weekly totals based on the week number. I would like to also give the date range for that given week number. Any help would be great! Thanks Shawn

Hi, Is there any standard or recommended best practice for linking two tables ocurrences, assuming you are not creating the related records using a portal, but a script? (the key field is not automatically entered by FileMaker while creating the record). For instante, in the left side of the relationship: - should I use the parent table primary key field and link it to same field (foreign key) in the child table (on the right side of the relationship)? - or should I use the parent table foreign key field linked to same field (parent key) in the child table? - or is it just a matter of tastes and needs? You see, in a Quoting system where you have Q…

I'm trying to calculate players ages determined by a set date. For example, I need to find out how old a player will be by April 30, 2008 when the players birthdate is entered. Can someone please help me with this? Thanks Using 8.5 Adv on WinXP

I'm totally new at this filemaker thing, and am having a little trouble trying to figure out a way to do what I would like to do: I fix computers, and I need a way to be able to prioritize whose computers I work on first. The way I figured it out in my head is this: -Customer brings computer to be repaired -Enter in Customer's Info -Customer's computer joins a queue where the computers I've had the longest becomes the ones I work on first. Now, here's the tricky part that I haven't been able to figure out completely. There are certain occasions where some customers get priority over other customers. For example: If a customer comes in and …

Ok, this one is a doozy. As described in my background post I am developing a new app that among other things, must do financial accounting. The new solution needs to keep track of budget items (or accounts)as well as banking transactions. Which means double entry transactions. If a client brings in a utility bill it needs to be entered as a transaction under the utility account for that client. A payment from their bank account is going to be another transaction record but under their bank account. The payment will be a debit from the bank account but a credit to the expense/bill/creditor account. I can't think of a way to make that payment tra…

Hello, I need to implement a hebrew-gregorian-hebrew date calculation in to the filemaker. My best guess would be to make a CF or a calculation, but I'm not really familiar with that. I have an java and C++ code. I would really appreciate any help. Below is the java/C++ code Thank You In Advance, Dan Vokov DateConvertion.htm.zip hebcal-3.7.zip

I have explored several different solutions on emailing from Filemaker Pro. Most of them seem good but more complicated that I care to spend implementing them. I would like to create a simple button that takes the current found results and copies the contents of the email field into the clipboard. Not just of the current record but of all found records, thus allowing a simple paste into an email client's To: section. Is there a calculation or a script that would enable me to do this? I already have a calculation field that compiles as such: First_Name & " " & Last_Name & " <" & Email & ">" so I would want this field (Email_Addr…

Hello again have a date field that is an auto enter creation date. I need to format just the day name to a different color. [color:red]Mondays [color:green]Tuesday etc The field is formatted as Monday, 1 January 2007 I can't seem to get it to work Help!!!!

Hi...my calculation is multiplying an amount by 120%, so for example, $49.03 x 120% = $58.836 How do I round it to only 2 decimal places? The result I am hoping to get is $58.84 I am familiar with Ceiling and Floor, but they work on whole numbers, not on decimals. Thanks in advance!!!

We have a sku number generator set up with all the fields being required before moving on. This is done in the Define Data / fields settings. One field is automatically calculated with a sequential sku number unique to each file. We added a "commit record" line in the script to force a save as soon as the sku number is created. The user then has to finish entering the required fields before moving on. The goal was to prohibit duplicated numbers being created if two users were accessing this tool at the same time. It seemed to be working, but then we caught a duplicated sku number. It seems that the "commit record" in the script is not committing until all the requir…

Hi, I was wondering if there was any way to get text from a field that appears before a line break? When trying to export text with line breaks within the field, I am getting errors. I either need to remove the errors, or grab the text before the line break. Can anyone help? Thanks

Hi, I got a db with this scenario : DATE NAME VALUE 02/09 PIPPO 5 05/09 PLUTO 3 10/10 PAPERINO 9 11/10 PLUTO 2 and I am searching a way to calculate, with a calculation field, the total VALUE of one NAME in a period (like in September). Can anyone help me ? Thanks in advance, I'll appreciate.

Does anyone know if there is a reference that shows the order alpha fields sort on characters other than a-z. I frequently give users an option to sort a portal based on an alpha character value list. The problem is that an empty field is placed before "a" in the sort and I want to auto insert a character that will ensure empties are placed at the end of the sort instead.

it's that simple really, I having a terrible time of figuring it out. i have an impending deadline so you all will more than likely hear from me often. in advance, thanks for your time

I need to change some imported data that was entered as text. the users entered fractional data as ex. 3 3/4 instead of 3.75. I got the wonderful task of changing ~900 records that have this in multiple fields. Anyone have a solution they would like to share? Thanks.