The Left Brain

Is there anyway to limit file references to a Filemaker account ? I have account A and account B. For account A, I would like Filemaker to see all the file references, and for account B, I would like Filemaker to see only a couple.

Hi all Need some help here In a field (Florida Rates)I have this information Dade 1.95 Broward 1.84 Palm Beach 1.840 Martin & St. Lucie 1.3 Rest of State .875 North East 1.150 I have another field called search..What I need is a calc that when I enter (as an example) into the search field "Rest of State" the field will return .875 or if I enter into search, "North East" the calc will return 1.150 Any help will be greatly appreciated Thanks Stu

I'm doing a if statment script that is checking to see if field "Plated_for" is marked "236". then exit script. My problem is that if the "Plated_for" is marked "237" or "240" it exits the script. How can I write if statment to only stop if "236" is marked? It can't be = because sometimes they might have 236 and 240 marked. Thanks.

Though not the biggest issue or really a problem at that, I am picking up some old database and the phone numbers are whacked out. So many people input data and there was no uniformity... so some records are... (212) 123-4567 212 - 123 - 4567 212.123.4567 (212)1234567 Maybe if all were like.. "212-123-4567" and one forced "style" I really don't want to break them up into 3 cells.... in some cases we have over sea phone numbers with + (44) 123-456789 coding... Thoughts appreciated... but no need to lose sleep on this one.

Hi, I've never used the Get(LastMessageChoice) and so far I'm running into difficulties. The problem I think is in syntax. I create a script with the ShowCustom message dialogue... have 2 choices... got that much, now when I go to the next step in the script.. the If part and type in the the Get(LastMessageChoice) it either gives me a field not found or an operator missing. Just to cover all bases, I place this text by dropping and dragging over the If from the scripts menu and just start off with the Get... right? This is really frustrating and probably easier than I think. Thanks for your help. V

I am reposting my topic from a day ago. I received many great replies, I thank you all, but after hours of playing with your feedback and googling the internet... I am still stuck, and consider my solution may be the best one going. My dilemna (in this simple example), I have 2 databases, contacts and jobs. If I am in my contact database and opt to generate a new job ticket, I want a script to simply take me to my job database, make a new record, and auto input the contact info I was reviewing at the time I started the script (My active contact record). It was suggested to use portals. I played with portals, but they are based on individual fields, not calculati…

Feel like this better belongs under "third party" forum but not under either of the subforums created there so here goes... I do work for a non-profit festival for which I've created a tickets sales database. We have ICverify software for processing credit cards. I have previously used these two items together by doing manual exports and imports with another company but it is now the office manager who is operating this system and I really need to automate the process. IcVerify comes with a "developer's kit" which details creating an in-between using Visual BAsic...problem is...I don't KNOW VB and don't have the time to learn at this juncture. Contacted ICVerif…

Hi, before anyone goes yelling at me to search, hear me out. I have 5 tables, one main table, and four sub category type tables. I need to be able to monitor for value changes in the sub tables ... from the main table. Keep in mind that all tables have only a one-one relationship with the main table. I was thinking of using something along the lines of the CF provided by nightwing, but the issue with that is it can't monitor related values... then i started thinking that i could have 5 different fields (one for each table) with each one monitoring individual changes... but i need to compound these into one sorted main calc field ... and to be perfectly honest we all …

OK... first, many thanks for all of your contributions to previous posts. I swear I am starting to figure this stuff out! Now, I have a new dilemna. I have multiple databses. In this example, I have a contact database (Company, address, contact info, yadie yada yada) and maybe a Job Ticket, requiring similar fields from my contact database. Lets say I do a find on my contact database... and I find my contact, John Doe @ Doe, Inc. I want to make a button (suggestions please), that on this "current record," I want to make a a new job on my Job Ticket Database with all of John Does info in place already. I feel like I have tried so many combination…

I just have one quick question... Is there anyway to change whether a field can be edited or not through a script step? Here's the situation: I have 1 field with radio buttons Yes/No. If that field is yes, then i don't want the user to be able to enter anything in my second field. If that is no, then i do want my user to be able to enter information in the second field. Thank you

I have a variety of fields that rely on one value list. To be valid, the contents of that field have to be a member of the value list (I don't want to use the filemaker validation because it's annoying). Anyway, i was thinking of using If(Substitute (ValueListItems( "filename.fp7" ; "valuelist" ) ; FieldValue ; "" ) ≠ ValueListItems ; 1 ; 0 ) But the problem is it picks up incomplete values on the value list as valid. Is there an easier way of doing this? Cheers, ~Genx

I am not sure if anyone else is having the same issue as I am but in FMP 8 and 8 Adv, my global variables dissappear when another file is opened. This kind of defeats the idea of a global variable imo... I have had to result to storing my data in global fields again - and I was hoping I would no longer need to do that.

Um, i really couldn't think of a better topic name . I need a field where a user can enter either a date or text... but i need to be able to identify through calc if its a date or plain text. I was thinking of using If IsValid(GetAsDate(field)) but i'm also thinking that i have to use a date field for this and if i use a datefield for this it will give me an error if plain text is input... Also i'm using a custom dialog here and all three fields are already being used so i cant put any additional indication in (i don't want multiple dialog's). Thanks for any help or suggestions. EDIT: I forgot to mention that the "plain text" will have numbers…

I am new to FileMaker and working on a script for work. I was wondering if someone could tell me how to get values from a radio button.

I have two tables 1. Events 2.Notes Each event can have several notes I would like to be able to number the notes as they corrispond to the Event. By this i mean Event A has note 1 2 3 4 and Event B has note 1 2 3 where those notes are the 5th 6th and 7th note entered in that table. can anyone help?

DayOfWeek ( production_date ) ≠ 1 xor production_date > want_date that is my validation calc. the want date is the day the product needs to arrive. so when setting the dates the production date must be before the want date (production_date > want_date). also the production date can't land on a sunday, ever, because we are not open on sundays (DayOfWeek ( production_date ) ≠ 1 ). with that background...here is the problem. if you set want date to a date. and then try to set the date to a date after the want date. the message pops up and says no and the user changes it. if they set it to a sunday BEFORE the intended want date the message pops up an…

Crazy thought and idea. I am a printer, and I am trying to build a quote database in Filemaker 8 Adv. My crazy idea is... we deal with paper, maybe a 12 x 18 sheet of paper. We print, maybe a 8.5 x 11 sheet 2 up on the paper. Can you think of anyone to graphically display the paper and show 2 pages up on the sheet. With this, if the sheet size changed... or the page size went to say 3.5 x 2 (business Card) could it display 20 up on a sheet. Basically some kind of visual reference for the estimating department. Can't think of any great way to acheive this in filemaker. Many advance thanks for your thoughts and input on this. Mike

Hello all, I have encountered a slight problem. I need to export a series of found images into a new user created folder in a specified location. I tried the troi plug-in, but with no success. However, I did get the create new folder script to function. Do I need to export the file path to a new file and then somehow reference that file to pull the specified images? Any help would be greatly appreciated. Thanks Again

I'm required to convert images from binary (i.e. jpegs to Base64)using "Mime Base64" encoding for purpose of upload to a website using xml. Anyone throw me a hint how i could do this using some functions in fm... or given file references using XSLT or maybe vb script Wim? This is sort of quite urgent so if anyone could lend any sort of help that would be great, i am completely lost after an hour of googling. Cheers, ~Genx

Hi... I am certain there is the easiest solution here, I can't figure it out. I am dealing with mailing addresses. If I have a calculation where I am composing full mailing addresses.... Someones Name Address 1 Address 2 City, State Zip When address 2 is blank, how do I rid of that space? Many Thanks!

Okay, this is probably simple for someone here, but I just inherited a FM db from another guy doing a volunteer position at church. We have a field that is "Stay Length" and we ask the member to tell us how long they will be staying here: 1-3 months < 6 months 1 year 2-3 years Undetermined Other In the Db layout, these are presented as checkboxes (I guess radio buttons might be better to prevent multiple selections) Now, what we want is to automatically calculate a ETD (estimated time of departure) from these values Is there some way to use an IF-THEN type of statement to assign a numerical value to the string field and then add it …

Maybe I am just missing something, but is it possible to use a variable when setting the criteria for a Perform Find[Restore] step in a script. For example, Stock::Description:[=$Cur_Strategy], where $Cur_Strategy is a variable set in the current script. Thanks, Bill

I am creating an on screen keyboard for a touch screen and I can not figure out how to send a command that executes a backspace or a (delete). I need to navigate forwards, backwards and delete one letter at a time. Any suggestions?

Under FM6, I was able to perform a calculation to find Vertical Tab Characters (it would paste in a character that looked like a little box with an x in it) in a field, and change them to Paragraph characters. I needed to do this to eliminate extra Paragraphs, from text that comes in via ODBC and MySQL. Under FM8 (I've upgraded), I cannot paste in the Vertical Tab Character anymore. My calculation has been updated under 8 to seemingly be just a regular Paragraph. Anyone know if there's a way to do this?

I would like to thank everyone who has helped me since my joining this forum. I must say this is the best one I subscribe too. I hope that someday, I can do the same for you as well. I am having trouble with a calculation and I could really use a little advice. I am using a calculation to combine multiple fields (all from the same table) into a longer text field. Along the way, with my calculation, I am adding HTML tags to help me later when I export the field contents. Any way. I have come to a point where one of my fields is not always populated. This field is called "description_features" and it is the last field in set of 5 fields. Now what I would li…

Is it possible to have a script constantly running without it "freezing" filemaker? Case in point: Could I write a script that constantly poles the size and position of a window so that regardless of what I may be doing in the other window it stays in a specific place and size? I've tried this already but it seems to "Freeze" filemaker do to the looping inside the script. Am I maybe missing a script step of some sort that keeps this from happaning?

I am looking for someone to help me translate one field to another. I amsure this is super easy but i have experianced a few problems What I want to do is fix a formatting issue during an html export from my Filemaker server. I would like to convert the following field content…. • Charging/Status LED Indicators • Keyless ON/OFF Safety Switch • 400 Instant Amps, 900 Peak • Built-in 12 Volt DC Accessory Receptacle To read…. • Charging/Status LED Indicators • Keyless ON/OFF Safety Switch • 400 Instant Amps, 900 Peak • Built-in 12 Volt DC Accessory Receptacle This information is being translated into html for import into a client’s…

Is there a function similar to Upper() or Lower() that will hard format a field in Title Case? I only ask because i don't want to waste time making my self a custom function to do it if it already exists. Cheers, ~Genx

:bang: How to split one space in SURNAMEName field which is not spitted? Have a problem in database. I have lot of records with people surname & name bat in format: SURNAMEName MATICMato MIKICMirko NODILOIvan RUBESAAleksndar KALINICIvan PRSODado and so on ... [color:red]not spitted. I try out and try out bat don’t find the way to split them in format SURNAME Name. Only [color:blue]INDICATOR which I have is that all SURNAME characters are UPPER LETERS (uppercase) and Name characters only first letter is uppercase. Need suggestion how to split this field that [color:red]between SURNAME and Name i get (put) [color:red]one spa…

I'm looking to integrate SMS into one of my solutions. I've created an external file in .net that utilizes the api provided by the gateway, however i would like to know if there is anyway to directly integrate a .COM API with filemaker? If anyone can point me toward an open source sample of any SMS solution that would be great also. Cheers, ~Genx

Oh so I've got this to work in a sense but not how I need it to work. I have 3 databases: 1)List of Activities 2)Scheduling Database that uses a of activities generated from Database 1 3)A video logging database that also uses the activities list generated from Database 1 As of right now for summaries if you are in the Logging database there is a layout with a dropdown and you can chose a activity and it will tell you how many time that activity occurs in the logging database. The dropdown is a dynamically created list from the activates database. What I would like is a list of all activities and then a sum for that activity. I know I am able to do t…

Hi all, I am trying to write a calculation to make a URL safe string from a field. By URL safe I mean only containing A-Z 0-9 _ and - . I have a PHP script using regexp to do this on the web side but need to convert it to FM. Requirements ------------- Replace one or more spaces with a single "_" Replace one or more & with "_and_" Replace anything not A-Z 0-9 _ with "_" ([^_a-z0-9]+ I've been playing with the Substitute function but it appears I would have to do this individually for every character I dont want, and then check for double (triple, quad..) underscores. Can anyone help with this. Cheers Matt

I have records for various clients. Clients have specific deadline criteria. Lets say I have Client's A, B and C. I have deadlines of i, ii, and iii I have a trigger date - for deadlines i and ii only Deadline i Client A = 3 days Client B = 5 days Client B = 3 days Deadline ii Client A = 14 days Client B = 28 days Client B = 16 days Deadline iii Client A = deadline ii + 7 days Client B = deadline ii + 28 days Client B = deadline ii + 16 days Ok so fairly easy, on my initial table are fields (example data): client (A) Trigger Date (01/06/2006) Deadline i (Trigger Date + Standard:Deadline1) Deadline ii (Trig…

I have two questions, if anyone can help I would appreciate it. I am a member of a non-profit group, that was asked to volunteer to help create their database. I am getting in over my head, and it seems I need help frequently. 1) Using Filemaker 8, when setting a script to go to a specific layout, can you also specify which tab to go to on that layout? 2) I have members that belong to committees, and I have members that are officers. I have a table for commitees, and one for the officers. There is one Board that comprises the officers plus the members of one of the committees (Board of trustees). While I could easily just pick the members manually in a portal li…

Hello I have a situation where I would like to make a kiosk with a map that is interactive of an amusement park. All the places I want to find in the map have gps coordinates. They are in a filemaker database. I was wondering if anyone knows how I might automate the placing of a "star" for depicting the location on the little map in filemaker. I realize this technology might exist for a web page that filemaker might address. I am just stuck and one of you might be able to help me. I have about 300 coordinates on this map. The gps is important so others may use the coordinates but I can't think of a way to automate my process of showing where that is on a map I have mad…

I have a database that I am trying to produce a report from. I have a report form set up with subsummaries to sort the data. What I am trying to do is to get counts of the number of records in the subsummary as a whole, then just display a subset of these records. For instance, count the number of all red shirts, blue shirts, and green shirts as subtotals, and have these numbers print on the report as a subsummary header. Then display individual shirt data for the set of red shirts that are short-sleeved only, then for the set of green short-sleeved shirts, etc. The total number of individual records will be less than the totals displayed in the subsummary, becau…

I was hooping someone might be able to help me with this script. I have a portal listing records and am trying to make a button to open up a new window with the selected record. Heres my script so far: Set Variable [$Num; Value:Table::Field] Goto Portal Row [select; GetNthRecord (Table::Field ;$Num)] New Window Goto Layout ["Layoutname"(Table)] Goto Record/Request/Page [Table::Field = $Num] It seems to be working except a little box pops up and you have to confirm the number choice (it does contain the correct number though) any help would be appreciated.

We are operating 13 group homes and need to track reports produced by several case managers. I want to be able to print 2 lists of reports 1. by case manager's case loads. 2. by individual client. The reporting schedule is: an initial case plan is due in the first 30 days and quarterly case plan updates thereafter. All quarterlies are calculated from the intake date including the first one. So it goes Initial 30 days, first update 60 days later and updates every 90 days thereafter. The list will include the case manager, client's name, admit date, and (from the printing date of the list) reports due with the number of days till due reports overdue with d…

Umm, yeh, my get(filename) function doesnt seem to be returning the filename. It's a bit of a pain having to type it out when im trying to get value list items in... Just wondering if anyone else has this problem FM8 Advanced, v8.03

Has anyone implemented the MOD10A into FileMaker? If yes, how did you go about it to achieve the same results that this code would generate?

I want to link a numeric and a text field such that a specific numeric value will trigger the display of a word. Both fields are in the same table. For example, in the table nobility anyone who is a one is a knight. Anyone who is a two is a baronet. Anyone who is a 3 is a baron etc.

Thanks to your help, I have defined a simple database and entered the data. Now I need to reorganize the data into several timelines. The data tracks violence in the lives of high officers of the English crown who held office between 1603 and 1763. The tables reflect events in the lives of the officers. I would like to reorganize the data into timelines that list certain events annually such as how many individuals are alive in any given year, how many of them suffered a violent event of any kind in any given year, how many knights, barons, earls etc. were alive in any given year, how many knights, baron etc. had to suffer violence in any given yea…

I have a calc not working correctly, and I can't seem to find out where I went wrong. On the chapters new layout (financial tab), you will notice some calc fields that total dues and pac money for a payperiod, and for a year. The pac calc for the year is not working correctly. If you have another window up using the duesinput layout, perform a find in the far right column for 372 members, you will see that the calc isn't working right. I have attached the file. Thanks Dave C FAAMA.6.7.9.fp8.zip

Ok, folks. Before I really start planning my next big project i'd like to get your input. Here's what I need to build, borrow or steal: I have 10 laptops I would like to check out. I want a user to be able to go to the web and type in a date span for which they need a laptop and the site would return if any are available for that span of time. Obviously, this will require some sort of calendar, of which i have several choices. Also, it will require that I have some sort of calculation that tells me if any machines are not checked out for the entire span of time selected. This part of the project is what scares me the most. I can simply have a calendar with…

I stumbled accross this quite accidentally and im not sure exactly what to make of it, but it has given me a few laughs. I have a dynamic login screen, that is its an unstored calc that loads one of 6 login designs randomly. Now the thing is, when my users enter incorrect details, i show a custom dialog with an incorrect details message. If you then click okay to the message, the portion over which the custom dialog was sitting has now refreshed (while the rest remains the same) i.e. it is now showing part of a different login design where the custom dialog was sitting. Furthermore, if you drag the custom dialog over the calc, it will refresh multiple times producing…

I want to show some indication of the fact that the user is in find mode... i.e. the giant characters FIND MODE in red accross the screen... Well not exactly but close. Unstored calculations don't seem to evaluate in find mode... The closest thing i can think of that would do this is a global field with a merge field somewhere on the layout.. Wipe when leaving find mode, Add the words "Find Mode" when entering it, seeing as all my find modes etc. are script executed anyway. Can anyone think of a better way? Cheers, ~Genx

Hi Maybe I'm missing something obvious but I can't figure out an easy way to capture a table name in a calc or function. I really want a Get(tablename) function that returns the table you are in when you run a script or a get(fieldtablename) that returns the table of a specified field. I have tried get(activefieldtablename) but this only gets the correct value when you edit a field in the same file that holds the field/table, it does not work if you seperate the data and interface into 2 files. I have wondered if this behaviour with get(activefieldtablename) is a bug because the get(activefieldname) works in the way you would expect in this situation. Any Ideas…

In Filemaker 7, is it possible to construct a function that will work like the Set Field script step but allows you to set the Nth repetition of a repeating field, where N is a value from another field or a calculation? For example the function might be Set FieldRep(repField;index;newValue) where repField is the repeating field, index is a number which points to the required repatition, and newvalue is the value to insert in the required repetition) The only way I have been able to mange this so far is to go to a layout where the variable is displayed, get the value I want to enter in the repetition into the clipboard, use a looping script to skip down th…

Before i start... where are the descriptions for each forum section, i couldn't seem to find them when looking for somewhere to post this...Sorry if i posted this in the wrong place, you'd think i'd know by now eh Lee? Anyway, here's my question, i want to know how much physical space a 30 character long text string in one record will take up on a computer. Or in a larger scale example: 5 text fields, each roughly 30 character strings, 1,000,000 records. Thanks ~Genx

Hello all, I am a bit new to FM Pro 8.I am using the Contact Management template. I also am using the Issue tracking one. I've created a relationship between then and would like to do this. I would like to have a button on the Conatact DB that when pressed it would open up the Issues Tracking one, and create a new entry to put notes in it for the client. An example being, I do a search in my Client DB for Jaser, I hit the button to open up the issues tracking so i can put an entry into it for Jaser. Hope this is simple, Thanks, Jaser

I have some calc fields that are being exported to an rft file with coding to format the new document ie bold, font size etc embedded in the calc. have worked out that to get a new line you have to have line in the code rather than a carriage return symbol. problem is that some of the fields are user entered paragraphs with line spaces in. is there a way to change a line space in a text field into line ? Thought about using the substitute but not sure how. Please post if you dont thinks its possible so I dont waste too much time working on it! Thanks

Is there a solution/plug-in that will allow me to run statistical models in FileMaker 8?

Years ago, there was a telephony product called YOYO produced by Big Island software for Macs. Big Island went defunct. With YOYO, when an incoming call came in, it used the caller ID number to search a Filemaker database, find the record with the phone number and display the entire record on the screen. My question is: Is there a product currently available that can perform this function. I maintain a database of over 100,000 property records with phone #s and do extensive direct mail. When prospects call, I want to see their entire property record on screen before I answer. YOYO was a product that did this beautifully. Although I use Filemaker to maintain …

The help notes for the PMT function in all FM versions advise that to find the monthly interest rate all you have to do is divide the annual interest rate by 12. This is incorrect. MS Excel also advise to the do the same calculation. The correct calculation is as follows: Monthly interest rate = (( 1 + annual interest rate /100)^ (1/12) -1) x 100 The simple method of dividing the annual interest rate by 12 would only be applicable if the interest was simple interest and not compound interest. Most loan repayments today are based on compound interest rates. FileMaker Inc. may need to update their help notes. Please note Microsoft need to do the sam…

Hello everyone - I am new to this forum, and I hope someone can help me I am building a mail order data base for my company. We need a unique invoice sequence# comprised of the following If Month=3 Year=06 Number= auto entry=0000+1 The return of the invoice number needs to look like this: 03060001 They are also asking that at each month's end. the first 2 characters roll over to the next month. I have spent days trying to find a solution for this. Any suggestions warmly welcomed!

Ummm, rightio here goes. I want users to be able to print labels. Labels come in different sizes. Most come with avery software codes. After a layout has been generated, is there anyway to respecify its physical body size and column size through script maker, or better yet just respecifying an avery software code? Cheers, ~Genx

I’m attaching a file of a process (gleaned from Comment) which creates a new portal record. If you type a value then commit the record (click on unused area of layout), the value should clear and appear in the portal. On Mac 8.0v1, it does … on Windows 7.0v3 and 8.0v2, it doesn’t. The inconsistency deepens as you explore further... I have 3 layouts with three different examples. It only works if 1) the child IDs exist on the parent layout, or 2) If you uncheck ‘Save Layout Changes Automatically’ in Layouts and FORCE save the record. Why would the fields being on the layout make a difference? Is it breaking because of the evaluation order (based upon fie…

Had one more question targetting user tracking records. What is the best practice to track records and record management per login user and over all login access. Tracking methods will include: number of completed records, number of semi-completed records, number of records skipped by login user. Once again, thank you for your time

Hello wonderful people ... problem relates to a script that CAN loop through a series of up to 15000 records (but usually no more than 100-200) in order to remove an id that pertains to each particular record from a global field... the global is for a relationship so it stores a pilcrow followed by an id...followed by another pilcrow and another id and so on... so basically the script is: allow user abort (off) freeze window loop Set Field [Ref::gFlagGlobal; Substitute(Ref::gFlagGlobal; ¶ & Ref::id ; "" ) ] Goto Next Record [exit after last] end loop now... the script works even if it does take a bit of time for larger amounts of rec…

I have a report with lots of subsummary's, and i need to be able to get a Page Count, is this possible? I bring up the point about subsummary's because i cant just get a count of records to try and estimate the number of pages. Cheers for any help or suggestions ~Genx

I have two tables linked. The parent is “Hotel” and the child is “contacts”. I am trying to create a calculated field in the parent that searches through the related records in the portal. I’ve set up the calculation however it only returns the answer for the first record and doesn’t appear to search all the related records and select the related record that returns the correct answer. I am doing this so that when I write a letter from the child I can take this information from the parent and hence have a link across related child records. The calculation that I'm using is: Champion = If (Contacts::Attended Workshop 2006 = "Yes"; Contacts::FirstName &…

Hello, In FMP7 I've got a field (A) with a simple pop-up list. On selection of the data, I'd like to set a second field (: to a particular value. I set my field (A) to be a button with a two step script. 1. go to field A (allowing selection of the data). 2. set field (: to some value For some reason, the second step doesn't execute until I select the field/button a second time. Any thoughts? thanks in advance, Heather

Here's the problem in a nutshell: Structure: Customers <-> Invoices <-> LineItems <-> Products Mission: Find customers who have bought, at any time, both Product X and Product Y - using only stored fields for the find.

Righto, im trying to get the exact size of available space within the filemaker window... i.e. the grey space that doesnt include toolbars etc... functions like Get(DesktopHeight) or Get(ScreenHeight) dont seem to be doing much for me... if theres an obvious function for this that im missing, feel free to berate me as long as you tell me what it is : genx

I'm wondering whether anyone has tackled this problem: I am in the process of creating a portfolio of my work, and I want to make screen shots of the databases I've designed. However, I can't put out screenshots of my clients' confidential data. In the past, I've taken the screen shots and smudged the data in an image program, but that looks crappy. I thought about running a Replace Contents command, but what I think would be really nicest was if I could find (or write) either a script or a custom function that would take the characters in a given field or even record, and randomly swap in new characters. Ideally, it would preserve word-breaks. I am working on l…

I have put together a simple timesheet app for temp workers. My original calculation for overtime worked well: I used Min(hours;8) for regular hours and Max(hours-8;0) for the overtime. However, I've run into a snag. The company I worked for changed the way they pay overtime. Now, overtime is based on a 40 hr week, not an 8 hour day. So, if an employee works 10 hours a day there is no overtime. When the employee reaches 40+ hours in a week-overtime is applied. I have a summary field for hours-that I;ve tried to incorporate into the solution--but it just doesn't work. I'm having a very difficult time figuring out how to calc the regular hours up to 40--then overtime hours …

I have filemaker 6 and have a DB with about 90,000 records. A ton of them are duplicates. Is there something out there that will remove all the dupes and leave only 1 copy of the record? Thanks!

Is there a get function to check which way your using the database... i dont mean whether you viewing data in form of list or table but rather to see if your in find or preview or browse mode... cheers

ok, im going to assume that if you develop something in fm 8, you cant expect functions such as GetNthRecord to work in fm 7... so my question is, was there some sort of work around you could do in fm 7 to achieve the same type of result?.. (keep in mind i only need the first two related records)... cheers, genx

Is it possible to check whether an account exists within a particular database by passing an account name to fm? Cheers, Genx

Hi all I'd love to be able to use a calculation field as part of a relationship (calc field <-----> text field) have you got any tips as to how I can do this, does FMP8 allow? Appreciate any tips - thanks

... sorry couldnt think of a good subject... im wanting a calculation (pref simple that will check that a particular field in all the records in the current found set have a particular value with the calc returning a true or false or 1 or 0 result. For example i have an imaginary field called male or female... if all .. dunno 10 records in the found set have the value "male" for the imaginary field return a value of true... Help would be muchly appreciated from anyone who has the time to spare. Cheers, Genx

Righto, basically what i have is a table which stores particular substitution codes and the fields to which they related... the idea is that these merge codes are substituted by the information of fields they are related to... now the substitute function works something like this... i never get the syntax right... Substitute(Substitute(Related::Body "<>"; help_field); "<>"; help_not_field) now the point is though, how do i do i add the codes dynamically using GetNthRecord or something?... if theres no way to do it dont worry, truth be told im just looking to reduce my workload a bit, anyway as always, thanks for any help. P.s. the codes are…

I need a calc. that insert the month before the current and the current year when a new record is created. In december it should be November, 2005, and so on.

Ok, this is short but sweet. When calling the contents of a related field through a calculation, only the related information in the first related record is retrieved, how would one go about retrieving the info of that field for a second or third related record? Cheers Genx.

Anyone have any experience with global search fields... i.e. a search field and a script that will search through all tables for matching text? Any resources would also be greatly appreciated. Cheers, Genx

Hi, I neeed to have a sum field that calculates the total of a numeric field for all the related records minus the value of first 5 portal rows. That is, if the portal looks as follows: PORTAL: row 1: value=2 row 2: 3 row 3: 5 row 4: 2 row 5: 4 row 6: 1 row 7: 8 I need a sum field that would give me "9" as a result (row 6 + row 7), disregarding whatever values are from portal row 5 to above ... any ideas? Thanks very much in advanced!

I understand to get a Ratio you: Divide both terms of the ratio by the greatest common factor (24/8 = 3, 40/8=5) State the ratio. (The ratio of 24 to 40 is 3:5) But can anyone tell me how to find the gereatest common factor between two numbers.

Hello all! I have looked over this site and could not find anything to give me a clue as to how to tackle this problem. I have an application in Version 6 (not planning on upgrading anytime in the near future). Here is the story: I am getting a data file from another database with 6 fields (filename, item code, upc, description, category, subcategory) to import into my FM6 database. The text file is tab delimited, with a comma delimiter allowed in either the UPC or Item Code field. I have put the UPC and Item Codes into another text field in the FM6 database called Product Code; this field is stored by concatenating each individual code with a CR/LF. So it …

two fields and two tables: - continent - country third table: - traveller when a new traveller is created a continent is select from a related pulldown. and then a country is selected from a pulldown that is related to the selected continent. If the user has selected both and then decides to change the continent. I would like the country to clear. If current country is not a member of the related value list. My first attempt was a field calc value: If ( Position ( ValueListItems ( Get ( FileName ) ; "county" ) ; traveler::country ; 1 ; 1 ) =0 ; "" ; traveler::country )

I have three tables - RESERVATION, PROPERTY & ISLAND. RESERVATION is related to PROPERTY based on "property id" - in both tables - and PROPERTY is related to ISLAND based on "island id" - in both tables. (There is only one "island id" per "property id" and only one "property id" per "reservation id"). I am trying to create a set of conditional dropdown boxes (based on value lists) on a layout based on the RESERVATION table. The user should choose the island name from dropdown box #1 and then dropdown box #2 would be limited to a list of properties only related to that island. I have seen the other conditional dropdown / value list posts but can't seem to get…

Each record in my portal row has a variable of 1. I have a script that first checks to see if I am on the last portal row: Sum ( relationship::var )= Get ( PortalRowNumber ) Unfortunatly this no longer works in FMP8. If the portal is active (a row is selected) the Sum function returns a '?'. So how can I do a quick test to see it the row selected is the last in the relationship?

I have two possible parameters +1 and -1. After I use them in the first part of my script, I would like to invert them for the second part of my script. so +1 becomes -1 and -1 becomes +1 what is the math function to perform this inversion. I would like to avoid an if statement.

Using calculations, are there any way to grab 1 value from diferents related records? Maybe is a stupid question… but I'm blocked. To give you an exemple… It's like a Client - Contacts relationship. You have 1 client with 22 contacts. I would like to pick up just the surnames of this related contacts (separated by commas), but in 1 calculation field only (no portals, no print), result= Text. Any ideas, please, please, please

Hi all: Sorry if this is a remedial question, but I have a text field that stores the body of a letter. I typed it out with some text formatting such as bold and tabs and stuff. Since each letter will contain info specific to each record (client) I created a calculation field that turns my merge field text into the actual data in the corresponding field, using nested substitutions. However, this calc field does not carry over the formatting attributes like bold and such. How would I accomplish this? Thanks for your help. FM6 on Win2k/xp

I wonder if you ever been involved in assigning rotating shifts. As I understand it can an employee rotate between 5 shift-types based on what he/she haven't done in the previous 4 shifts in theory. But in this case depends the assignment also on availability among the rest of the staff so it can't be a too rigid scheduling. The next task in line should more act as guidance, than be the actual one to assign. My initial thought was let the new GetNth... function gather the 4 previous assignments and use a custom function makes the opposite of what the FilterValue( does. with all the possible shift-types. That would be easy to do, if it weren't that the client ha…

1. Can I get the name of a file within a container. 2. Can I get the reference path of of a linked file within a container?

Hello There... This is my problem: I make A database with keyboard shortcuts Like these: Select All: Ctrl + A Auto Contrast: Ctrl + Alt + Shift + L Guides (show / hide) Ctrl + ; Move Cursor One Word Left/Right: Ctrl + Left Arrow, Right Arrow I have a field "shortcut" with the shortcut text only (Ctrl + A) I want to seperate this field in two Fields: So the Shortcut "Ctrl + Alt + Shift + L" to be Mod Keys: Ctrl + Alt + Shift Kbkey:"L" Or the Shortcut "Ctrl + ;" to be Mod Keys: Ctrl Kbkey:";" All The Short cuts word spaces are : Ctrl &" "& "+" &" "& Alt &" "& "+" &" "& Shift&" "& "+…

Forlmula is: X = (2 x Ablsolute Rank) - 1/ (2 x Class Size) Here is the question: I have a list of numbers that X equals (if X =.0017 then rank is 80 or X = .0023 then X is 79) 1. can I make a list of these valus of X's for filemaker to reference? 2. can I make filemaker round to the closet value of X; if X is in between one of those numbers I have listed. I hope i made myself clear?::)

Hi! I have a field that contains a calculation that gets all values from a valuelist. The list is the following: 1,2,3,4,5 and so on.... Now I want to take out the first value and do something with that, then the next and then next until the end of the list. How do I do that? // Jocke

I recieved an excel file with names The man who wrote the names put the last name first then a comma and then the first name. I want a calculation to make the name with this order First name & Space & last name Can you help with this problem???

I have a field called Pattern::FlaskSize and the contents of the field are dimensions of a box 18x18, 21x20, etc. I need to populate CastingQuote::DimCopeL & CastingQuote::DimCopeW for the Length & Width of the box. I have this script step that doesn't seem to be working: Set Variable [$Flaskwidth; Value:LeftWords(Pattern::FlaskSize ; 1)] Set Field [CastingQuotes::DimCopeW; $FlaskWidth] But it returns the whole data string 18x18. I'm assuming that since there are no spaces between 18 x 18 that it is interpeting 18x18 as 1 word.

Hi - I have a system that uses FileMaker to manage the items for a shopping cart. They are transfered to an MySql server on the site. I want to timestamp a record when it is modified and when it is updated to the MySQL server. If I use the regular modification date it is fine until I update the field that tracks when it was last posted. Then the modification date is updated again. I want to be able to select all records that have been modified, but not updated. Any recommendations? Thanks.

Does anyohe have thoughts on how to create a calulation for 10 business days?

I have Time fields that are currently set up to allow users to input the time as 1200. We use 2400 time format. Currently the time field is defined to leave data format as entered. I would like to go back and change all previously entered times to read 12:00. I would then change the time format of the field. I know I could setup a script and a loop to change all of the existing records. I was just wondering how I should create a calculation in the "set field" script step to accomplish this. Any input would be greatly appreiciated. Thanks, Ron.

Right, ive got a small problem, i need to be able to format a date in a certain field like this Saturday 22[color:blue]nd October. Is there anyway to get that second part (the nd) to automatically change according to what the date is... i.e. 21[color:blue]st or 23[color:blue]rd. Cheers for help, genx

I have a field that has the contents set by a series of checkboxes. So for instance, the contents could be 1,2,3 How can i tell the system to check to see if 2 exists, or 3 exists. I've used left and right words, but that woudln't give me to. is there a basic "if contains" command short of using the position command? Thanks.

Hi, I'm brand new to the world of filemaker so please forgive me if this sounds like a silly question. I'm building up a product catalog, and with the help of templates, so far so good. Two questions though. 1)The templates all default to using $ as currency. How do I change this to £. I've tried setting the default number format but this makes no difference. 2)My catalog also includes some old legacy products and I have a field called "Obsolete" (a check box to be exact). If this option is checked, how do I get filemaker to display a large warning stating "This product is obsolete". If the box in not checked, I obviously don't want/need a warning.…

Hi. I hope someone has a solution to this problem. I am trying to make a schedule to be able to give a date when work will be completed. I have 30 task fields,e.g. Task 1, Task 2, Task 3, etc. I want to create a formula that if one of the task's field is empty or = 0, then the calculation needs to go to the previous task field that has a value >1 in it and do the calculation from that task. Such as: Start date field: 9/12/2005. Task 1 has value 2 in the field (as in Task 1 will take 2 days to complete). So it will be 9/14/2005 before Task 2 can be started. Task 2 has 1 in its field so that means Task 2 will take 1 day to complete. So it will be 9…

Is there some sort of function that will check if the result of a calculation is negative? Cheers for help, genx