The Left Brain

I have had a brain lockup this morn. I am trying to strip a part no of ""/"", ""-". I have tried to nest these but cannot get it right. TIA Ivan FileMaker Version: 6 Platform: Windows XP

I have a procurement database where the Users can duplicate an old purchase request because the same item is purchased yearly. In my script for the user to duplicate, I have certain fields that are "Cleared" when the record is duplicated. I found that some of the fields that I requested "cleared" were not clearing. I realized that the User does not have access to those fields. How can I write the script so these fields will clear even though the user does not have access? Thanks! FileMaker Version: Dev 6 Platform: Windows 2000

I need to use an "Average Summary field" from another field in order to calculate, is this possible? Sorry, but I'm new in FMP!! I have 4 files: Projects, Staff, Actuations & Expenses. In this last one, I have all Staff salaries. Hours by month & salary change every month. I had summarized an AVERAGE price of hour for each person. My problem is: In Actuations (relation Staff & Projects; so how many hours "Mr.Smith" worked in "Project A"), I need to use this AVERAGE price from Expenses. I made a report from Staff_ID to know in which Project this persons did. But now, How can I use this "Average hour price from Expenses) in order to know the exact cost…

Hello, I have a field called "a". In field "b" I want to delete the spaces and points that are field in field "a" I use: Substitute(a;" ";"") The spaces are now gone, but how can I delete in the same formula the points? Greetings Jukkie FileMaker Version: 6 Platform: Windows XP

I would like to have the setField function calc a numeric result with a leading zero. I have tried various ways but no luck. TextToNum(Right("00"&Max(serial) + 1,2)) TextToNum(Right("00"&NumToText(Max(serial) + 1),2))

Hello, I need to validate my e-mail field. I want this to do by a calculation, but I don't know how to do this. The e-mail adress should look like [email protected] the it is a valid e-mail adress. Hopefully there is someone how can help me. greetings Jukkie FileMaker Version: 6 Platform: Windows XP

I understand that after an initial find, you can then constrain the find further, but I need to know if a script will hold just the constraint condition. say an employee search is done on various criteria. I would like have a button with a constrain for 'female'. So no matter what the search is the user will then click the constrain scripted button.

Hi, I'm in need of directions in developing a "Splash Screen" which opens before a user has to enter a password to open a file. In other words, once the user goes to the Host and clicks on a file name, the "splash screen" appears and then when they click "okay or agree", the password prompt appears. Your help is appreciated! Thanks, Littleitaly FileMaker Version: Dev 6 Platform: Windows 2000

Hi all: I've just been asked to do a fairly simple job, a system for a school. It's the usual stuff: contact info, course list, classes, etc. However, the client wants to be able to view (and print) a student's schedule in a columnar grid, like the hourly view in a typical scheduling system, with the days of the week going across the top, and the hours going down vertically. I did a quick search, but found no threads that dealt with this (though I'm sure I've seen something like it.) The data I've got will have a different record for each instance of a class (for example, if a class meets Monday 10-11:30 and Thursday 1-2:30, there will be two separate records to…

I'm desperate

Hello, I posted this question in the "Script" section and hadn't gotten an answer just yet. I thought I'd post the question here since I'm thinking this is going to have to take place in a calculation field. I have created a calculation field which extracts data from a record to use in a "send mail" script. The problem I'm trying to solve is how to extract our report number (number field called "Rep No") from EACH record I'm browsing and send it in ONE email. The records I'll be browsing are all for the same customer, but I need each individual report number to show up in ONE email. I don't want to have to send multiple emails to the same customer. As it st…

I am going on 3 days without sleep and am bleary eyed and unable to figure this one out. I need to set a flag to "Y" when two dates are greater than a test date and where the foreign key is NULL. I am using the following formula but am not getting the desired result. Am I doing something wrong with the dates? If((Invoice Max Date>2/8/2004 and ICL Commission Header ID<1 and ICL Signoff Date>2/8/2004), "Y", "N")

Hello everyone! I am creating a KnowledgeBase of sorts for our IT department. Currently we have a FMP file with just a few fields to track projects, when they were opened, who's assigned to them, etc... There are 2 of us in the department servicing 100+ users. So if someone calls me about an issue, and this issue was already turned in by someone else and my partner fixed it, I would like the benefit of not having to research a problem when the answer is already out there. That's where the retention of resolutions come in. I am attaching what I have so far, but I'm not sure what else would make it better, or what I can take out. If you have any suggest…

Hello all, I need to format a field so that it contains the first 2 letters of each word from another field. I have not needed to do this before and I can not figure it out other than it looks like I need to use a script to perform some sort of "strip text" to obtain the results. Thanks in advance! FileMaker Version: 5 Platform: Mac OS 9

I'm overlooking somthing kind of stupid and I need someone to point it out. I have two Date formatted fields I'm working with: 1. Date Ordered 2. Date Needed the Field representing "Date Needed" is supposed to be 14 days after the "Date Ordered" is entered. Here is the caculation I've written to do that: Date(Month(WorkOrder_DateOrdered), Day(WorkOrder_DateOrdered) + 14, Year(WorkOrder_DateOrdered)) The initial "Date Ordered" is auto-entered by a script, however when this script is performed, it inserts the "Date Ordered", but will not insert my new "Date Needed" field until I manually tab through it. I wish to be able to have it automatically enter t…

I am updating a DB for a charity event that keeps track of ticket sales. Here is the challenge. There are 12 seats per table Each seat is $500 Max charge per table is $5000 Any quantity can be sold. e.g. - 32 seats = (2 tables and 8 seats) charge= 5000+5000+4000 FileMaker Version: 6 Platform: Mac OS X Panther

I have a file that is on a shared drive that is served up by FileMaker Pro. The other night I was working on it and the VPN connection went down. When I tried to open it I got the "FileMaker is performing a consistency check" message, then I got an error that the file is write-protected and can't be accessed. The only item I could find on the FileMaker support site was something regarding dragging databases to your local hard drive but that seemed to apply only to sample files that came with FM 5.5. I am using FM6 with FMS5.5...Thanks Version: v6.x Platform: Windows XP

Hi ! In my job we are working 24/7 days. We have a different salary for hours during night time (i.e. 9 p.m. - 7 a.m.) and for the weekends (sat + sun) and general holidays. When calculating salaries I should somehow sort out how many hours an employee has worked during night time and during weekends. The input from each day is currently "Name", "Start_day", "End_day", "Start_hour", "End_hour". Any suggestions or solutions allready done ? Thanks in advance Arttu Version: Developer v6 Platform: Windows XP

I hope this is the correct place for this question. I have been using FMP for some time now but I am a super newbie at formula/calculations and such. I finally convinced my school to do course selections for next year using FMP instead by hand using paper & pencil. And in doing so have ran into things I don't know quite how to accomplish. So any help will be greatly appreciated. Currently I have students typing in their ID number which will then bring up their record and the course selection layout. However I don't want them to be able to go back in once they have made their selections and edit it. I saw under the passwords you can limit the edit a…

I've got a student db, an assignments db, and a grades db. I have a many to many relationship between the Students and Assignments, and I store the grades in the grades db. The school program is broken into 4 blocks, and several areas in each block, which need an average grade each. I need to be able to get an average grade for each student for each area of each block. Is this making any sense? I can get a summary field to work for all grades per student, but that isn't what I need. Each part of each block, (several summary type fields) needs a summary of it's own. Please help! Version: v6.x

Hello, I have a calculation field that is going to be used in a "send mail" script. One of the fields that needs to show up in the calculation is a number field that contains a report number (example; 04-04567). The original field displays the number correctly, but when I put that field in the calculation, it drops the zero and the dash (so it looks like 404567). I've tried putting (NumToText) in the calculation and that doesn't do the trick. Can anyone tell me how I can get the number to display correctly? Thanks in advance!! Kristine Version: v6.x Platform: Mac OS X Panther

I run a little guitar store and I manage all my customers with my FM database, but I'm looking to build it into more robust inventory-management and POS solution. I have built two different ways to update inventory dynamically, one with a calculation (starting inventory plus purchase orders minus shipped orders), the other with a script (subtract one for each order that ships). Both seem to work fine, but I like the interface elegance of the calculation, and I don't like needing an undo script for those times when something changes or an order needs to be revisited. But I don't like to load up on calculations---they can make things sluggish. So I'm wondering if anyone has…

Greetings All, I'm just getting into the meat and potatoes of what FileMaker can do (suddenly I'm hungry), but I have always found some limitations in ease of use when it comes to working with summaries that rely on multiple criteria. Any summary guru around here, or possibly hints or links to stuff online that I can read about, reverse engineer, etc...? Any help would be greatly appreciated. Many thanks, Hurican Version: Developer v7 Platform: Windows XP

I'm not seing this, so I'll ask here. I have several dozen records right now in my database, each one with a field containing a total donation amount. I want a field that keeps a running total of that field across all currently selected records. Seems easy enough, but I'm not having much luck. Is this possible? Version: v6.x Platform: Mac OS X Panther

Hello, I've been quite a bit of time working on Filemaker for about a year so I'm not a complete newbie though, I have no idea how to post this question or what the feature is called: I have multiple fields which show Credits that were applied in a DB such as: 1. Pro-rated 2. Family Discount 3. Scholarship When working on statements layout, I need to itemize where the credits came from. Rather than placing straight text with the above 3 fields, I rather only display the field if the field is not empty. In other words, how do I generate calculation to show only fields that are NOT empty? Do I need to build a long "IF...then ..if, then" formula? I trie…

I am a FM novice, and am trying to create an inventory system that has three parts, Received, Inventory, and Shipped. I am not sure how to procede. I have created the three databases, but am not sure how to get the calculations to work, and how the relationships need to work. Also, I have read on some other posts that you need to use four files. Items contains one record for each item (what does that mean, and how is it done?), which I do not have, Orders (my Shipped), contains 1 record for each order, Restock (my Received), and Line Items (my Inventory), where most of the data is kept. I think I need some more clarification about how this is supposed to work. Any i…

I need to create a list that keeps a list of dates and intitials in a vertical column. I need to be able to create a button and a script I guess, that will cause todays date to be automatically entered at the top of the list , moving the rest of the list down one row automatically. I want to keep all of the dates at least 50 or 60 rows down. When the rows are completely filled with dates, I want the bottom date to disappear as new dates at the top are added. I want the button designed for each individual staff member so when they click their button, it will not only add the date at the top of the list, but their respective initials as well. I am a filemaker novice so…

Hi all, I am a network administrator (having fun with my filemaker DB projects) working on a simple calendar layout for room schedules at a non-profit so you can imagine, our budget is limited. The layout is a 7-day weekly layout for rooms scheduling using global fields. Based on my research, I could not find a simple answer and/or some of it was too complicated. Here is the lowdown on my project: Requirements: Display 7 day layout for each room onsite (preferably, as many rooms on a 11x17" sheet I can fit in it) which comes from two databases: CLASSES DB and private LESSONS DB both which have rooms booked. I have created a ROOMS DB which links to both and…

Does anyone have a quicky way to get the first letter of every word of a string? My client insists on using a serial number with letters that represent the product. So, I need to take a string which could be 1, 2 or more words and take the first letter of every word and concatenate it with a incrementing serial number. i.e. Georgia Bulldogs = GB001, or Alabama Crimson Tide= ACT001 and so on. Any thoughts? Version: Developer v6 Platform: Windows XP

I've been thinking about this for a while and cant get any where. I have made a Timer that is based on projects. Multi users can access it and it is based on project numbers. In a separate field their user name appended- this is unique and has been indexed. By using this index I can present the user with a list of projects via index. Each user has their own timer for a project and as such a project can have as many timers as there are users. My problem is I dont know how to isolate the job numbers that the user has created, so an index list shows only projects they have created. I dont want to create a relationship file for each user. thanks

Ok, this is going to be confusing so I'm trying my best to have it make sense. I will try and outline the steps on what I need it to do, there are actually two things i need it to do. 1. Pattern Generation The thing i want to download is a large series of images (from a webcam) and I am at the moment discerning the pattern behind their file numbering. Once i get that figured out is there a way in FM to automatically generate a list of values for each image? 2. The actual downloading (step by step): i) Sign into a website using my username and password. ii) using the list of values from above, add them onto the end of a web address iii)download each of …

Hi there, I have two databases. One is invoice and the other is material database. When I'am in the invoice database I have the following fields called: width, lenght & price. (Same as in the material database) When I fill in the width field the lenght field is comparing the width field with the material database and shows all the lenghts that belongs to the width field. So far so good. Here is what I want. When I select the lenghts that belongs to the width I want the price that belong to that specific record. Please ask me if you need more information, because I don't know where to start. Greetings Jukkie

Hi All, Im currently in progress with a job cycle project which basically calulates times per job at each stage etc. I have just found out that it needs to be calculated in working days only so therefore to exclude weekends and bank holidays. is there a caluclation which i can use to work this out? thanks in adavnce

Hi all - I am working with two dimensions - Order Status and Delivery Date. I need to generate a report that will provide the following type of output... ......................Dt1.......Dt2.......Dt3.......Dtx... Ttl Order Stat1.....50.......25.......20.......15.......110 Order Stat2 ....30.......20.......17.......19.......86 Order Stat3 ....43.......29.......30.......5.......107 Order StatX.....21.......13.......42.......74.......150 Total...........144.......87.......109.......103 Any advice on how to do this in FM? Is export to Excel my only hope? Thanks!

Hello everyone, I hope you've all had a good weekend! Here I am back onto "Version Control" software! I thought I would start a new post so that hopefully I can explain what I've tried to do - after all, it may be interesting to many of you. The ability to track the latest versions of a document created in any format and stored on a DATA server - catalogued through a Filemaker database. This has obvious office cultural problems - forcing people to create, edit, modify, etc through an enviroment other than their operating system. But, there is nothing on the market worth it's weight that allows you to effectively tag documents with a version number and ca…

What I'm working with, is a set of 16 mulitple choice survey questions. There are five possible answers each and I'm storing the values as a single numerical field My problem is, I want to do some statistics on this set of data, so I'm trying to find the simplest way to sort the data into the five possible values. The way things are currently calculating, I'm essentially creating five IF statement fields on each question that check the value of the answer (1 to 5) and if it matches that particular if statement, then that field contains a 1. Then I've got five more summary fields giving me a count of those if statements so I can get an accurate count of each…

Don't know where to put this question but here it is. I have a database of 600 contacts Name/ address/ phone/fax/ etc I have set up two fields username and password Username is not a problem Is there any way of generating a random password for each one within filemaker?

I have a booking database that assign a week of year number to bookings based on their dates,the problem is that weeks in the uk run from monday to sunday,so week 8 would be mon16/2/04 to sunday22/2/04 but filemaker is putting sunday22 as the start of week 9 not the end of week 8,is their a simple work around filemaker pro 4 mac g4 os9.0

Hey folks, I'm looking at working with a new client. They've got a contacts db that contains company and people info. They've had a problem with staff inadvertently hitting CMD D instead of CMD F and creating duplicate records and then not deleting the duplicate, so over time, the duplicate record starts to look different from the original because sometimes the original may get updated and sometimes the duplicate may get updated. Add to that nightmare the fact that some companies have multiple locations/store fronts, but of course there is no ID that associates multiple store fronts to a single owner. Store fronts can look very much like a duplicated record that has …

I wish to use repeating fields to perform calculations for an expense account application. I have 3 fields F1, F2 and F3 each of which have 10 reps. F1 represents actual costs incurred , F2 represents Advances paid and F3 represents the difference between F1 and F2. Each repitition represents an expense (i.e. rep 1 is Hotel, rep 2 is Car rental, rep 3 is Airfare etc.) The reps are consistant for all 3 fields (i.e. rep 1 represents Hotel expense in all 3 fields etc..). I want all the reps in F3 to be calculated (i.e. F1(x) - F2(x) = F3(x). First, how can I define the individual repititions of F3 to perform the calculations required automatically. Secondly, I want…

I have a file with 732 fields 114 relationships and 200 of the fields are calcs. If I delete a field 75% of the time my file crashes sometimes it will open back up other times it needs to be recovered. I have Recovered this file using the guidelines FileMaker has said is the proper way to Recover a file, but this file still keeps blowing up.(This happens on Windows & Macs). I have went through each calc to make sure it was properly done, I have deleted old fields & scripts that are no longer in use. In other words I have tried everything I can think of to make this a nice clean file, but still have some sort of an issue going on with it. Can someone sugges…

Is there a more robust solution that exists for loan balance calculations and payoffs for FMP? trying to figure mortgage payoffs to the DAY of payoff...plugin?: method??

Here's what I need to do without using a script. Field1 has radio buttons "Yes/No" Field2 would contain text. If field2 had text in it and the user resets field1 to "No" then field2 needs to be cleared of text. Any suggestions?

Wasn't sure if this was a right brain issue, since it deals with data display, or a left brain issue, since its all about computations and analysis. I thought of posting in both places, but then feared what Lee might do to me. Anyway, a bit of an update from yesterday, which was a spinoff of the movable objects / map question. The scatterplot can be produced under either of two methods. In the first, one record is gotten from the source file and passed to the plot file for display. This is repeated via a loop for each record in the source file. I thought I might improve the computation time by getting all of the data at once and passing it to the plot fil…

I was thinking about looping scripts and setting field values based on conditions and wondering which method (if either)is preferred: Go To Record(First) Loop If (some condition) Set Field(some value) End If Go To Record(Next, exit) End Loop vs Go To Record(First) Loop Set Field(If(some condition),some value, field)) Go To Record(Next, exit) End Loop The 1st example has more script steps, but the Set Field only happens if some condition is true. The 2nd example has fewer script steps, but the Set Field script step executes for every record. It would seem to me that the 1st example ought to be more efficient, but I've never test…

We have created our own in house solution to handle all our sales, inventory, customers, payroll, etc. Currently we are adding some new features to our solution. I have read on these forums many times that all inventory systems need to be transactional. They need to record all stock modifications (received and sold). Qur current inventory database tracks the amount of stock with one quantity field. We use scripts to add and subtract quantities when needed. Therefore, no transactional records. My question is, what are the benefits of having a transactional inventory? What does all this data, we will accumulate, show us. At first I thought that it would sh…

Hopefully this in the correct area. Sorry if it is not. I am working on a Christmas card, other holiday card sending database. It tracks what attorneys want to send holiday cards to what clients. This is a many to many relationship and as such I have a join file in the middle. I have the need to print a report that shows the cards that a attorney or group of attorneys need to sign before they are sent. In helping to generate this report I have a array that is built on each record in the client file. This array is the names of the attorneys that need to sign this clients card. The join file then has a field that is a unstored calculation that copies that array…

Let me see if I can explain this clearly... I'm building a punch clock app. The two files in question are "timecard" and "punches". Pay periods could be of any length of days, and are identified by a pay period ID (number). I'm trying to account for daily overtime hours. An employee punches in and out...which creates a record in the "punches" file. They will most likely create multiple punches in a single day. I have an overtime field in the "timecard" file which holds a time value. (number at which time begins to be overtime. It will most likely stay at 8:00:00, but the user can change to any value.) So, here's what I need to be able to do: For …

Hello everyone. One function of the database system I'm currently designing is a Notes section. One file, Clients, contains client information, while another, Notes, contains all related notes. Simple enough. Here's what I'm trying to accomplish: I'd like to never see the Notes file. I've created a layout in Clients that contains a portal showing all notes via a relationship (Show_All_Notes). There's also a Note field that is related via a second relationship (Show_Current_Note). In the Notes database, there is a calculated field called Current_Note that combines the Client ID (from the match field) and the current Note ID. An invisible button covers the Note…

The question is this: When making a duplicate record that contains repeating fields, is there a way to NOT duplicate the data in a specific repeating fields, other than using the script "Clear, "Field1 -2" etc. This database uses several fields that have repeats of 75 cells and using the above script method would require me to some 33,750 specific references to repeating field cells. Case: I want to duplicate the purchase order that has 2 repeating fields of 75 line items each. I want the "Item to purchase" repeating field duplicate exactly but I also want the "Price each" repeating field to be blank. Any suggestions??

Greetings to All I have been creating an Estimating system using a Portal to create the line items associated with the Estimate number. It now seems that my users requrie some form of a fee table to be used rather than entering the line items each time. My dilema is i have 5 differnet types of fee tables, associated across several differnet customer which may include different items. so as an exmaple here is what might happen New Estimate for Customer A preset costs from fee table 1 - Item A, Qty 1, $15.00 - Item B, Qty 1, $15.00 New Estimate for Customer B preet costs from fee table 2 - Item A, Qty 1, $10.00 - Item B, Qty 1, $10.00 If anyon…

Hi all, I'm in the process of designing a large system for CD sales data for royalties. The sales data comes with the album name, sales numbers, returns etc every month, from 8 different regions and sub-regions around the world. Once that is imported they need to be tallied by region. Thats easy enough, but the real kicker is that each album have a 'unit reserve' every 3 or 6 months. Which is 25% of that periods' net sales. That has to be then carried over and added to the next sales period. I'm not only stumped on how to create a carry over procedure, if an album has no sales (therefore not in a sales report) but have a unit reserve carry over, it will not be o…

I am converting an Excel spreadsheet to Filemaker. I am using the "large" function in Excel to get the most significant numbers from a selection. The user interface was easy, but I am stumbling on a method to figure the 7 largest numbers from a selection of ten fields. I am using a calculated values and can easily find the min and max by using "Max(race1,race2,race3,race4,race5,race6)", but how to find the 2nd highest number? Thanks for any help, RAD DAD

Does any one have any experience controlling a power distribution unit (PDU) from filemaker? I need to install 10 computers, and I need a way to control the incoming power to those computers from within filemaker. In other words, I need to turn on and turn off those computers from FM, and at the same time I need to log in the amount of time the computer has been up and running. If you have any suggestion it will be greatly appreciate it. In the mean time I will keep looking for the answer. Thanks in advanced Carlos

When you specify a script for a button you have the option to 'exit current script' is it possible to have the same function within the script. That way I can assign a keyCommand to the script as well.

Hope this is the correct forum . . . Has anyone used Dragon Naturally Speaking to control a filemaker application? I've been led to believe it can be done but nothing I can find on the ScanSoft website let's me know about functionality. Besides, there are several versions, and I'd like to know which version I need to control FM commands. Thnx Arny

The company I am working for has a project ID number they assign to each project request. Currently the number system is in a YY123 format (i.e. the first project request for 2003 would be 03001 and the first project for 2004 would be 04001). They would like to keep this format. I can figure out how to setup a calculation to input YY123 automatically for every record created, however I can

Hello guys & gyals, I want to create a database that keeps a track on versions of documents of any data type. I want to use a Filemaker database as the interface to open, create and edit all documents using any external packages. What I need the database to do is have the following information: field 1: document field type: object (stores a shortcut to a document dbl click opens the document - tried and tested) field 2: document_path: where the document is on the data server field 3: version_number: known by latest date/time field 4: Author of the document field 5: Creation Date field 6: Creation Time This database is to be viewed via a …

how would i go about setting up a system where users could type in a code from a given list (a list of about 100) and enter data pertaining to the code (a time card). i would then like to track how many hours have been allocated to each code. could anyone provide some insight please?

I have a list of records with a date in each record. I would like to create a script that finds the first record of each year and tag it. (currently there 1097 records covering eleven years, and the tag can be a simple boolean) anyone?

When creating labels, for example on a A4 paper with 2 columns of 8 rows you normally get 16 different labels. It is sometimes needed to produce a full page of 16 identical labels, the next page with 16 identical labels of the second person, and so forth. How do I tel FMPro to use the same value for the 16 labels? Thanks

I searched around for this, but couldn't find anything exact. Hopefully this is not a common question. I have an application (about 20 files) which I'm designing, but for the purpose of this question I basically have 3 files including a login file with a couple global fields that validate against a user file and then the actual application files. I need to keep the username global from the login throughout the remaining files so I have a way to define a relationship back to the user file a pull information about the logged in person (for example automatically insert his or her name). I tried setting up a script that would copy and past from one file to anot…

Hi I have a stamp script that will put a date/time stamp in a field for when comments are added. It works ok, except that I want it to go to the top first posistion in the field before stamping instead of the end. I looked around a little, and tried a couple of things, but couldn't realize a way to do it (I give myself a C- for effort, though). I was hoping that someone had done this before and had a ready-made calculation, so I can save precious brain cells that haven't already been destroyed by drugs and alcohol! Thanks

What is the proper syntax for three conditions: if statement = conditionA or (conditionB and conditionC) Do parenthesis work in this case? A = sum(zero) B = sum(one) c = isEmpty(field)

I'm about to start work on a project that will require a group calendar/schedule. I've never developed something like this in FileMaker, although I think I have a pretty good grasp on what is required. I was wondering if anyone has any thoughts on the subject, has built such a solution, knows of a good open-source solution I might be able to check out, etc? I've looked at a few commercial calendars build in FileMaker, specifically The Hive, Dave Dowling's Calendar, and Schedula Pro. Each applied to me on some level, but I'm really not sure I want to buy a solution and then try to integrate it. Given our needs, I feel that it may be best to write one myself. At a…

Hi there, I am trying to figure out if I can use FM Pro for statistical analysis. Actually I want to use it for forecasting (using moving average, regression or time series model) and am interested to compare errors for each model. Any idea if this can be done ? thanks,

hi, i have a hosted fm pro db which i host out using FM Server. the problem i have is that when a new record is created a script to create a unique ID updates a global field by adding 1 i.e goes up in incraments of 1. what happens is that once the user closes out of the db and re-opens it to create a new record (record ID) the global field changes back to the original number. Can anyone help please or come across this before?

I have, what I think is, a quick two part military time question. I've been reading my FileMaker book all night but just can't seem to get these to work. #1 I have a couple time fields. I have them setup as time fields under define fields and have them formatted as HHMM in 24 hour mode with a colon separator. When I enter a time such as 15:00 it works fine, however when I enter 1500 it makes it 1500:00. Any ideas? Do I have to write a calculation for this or am I just missing a setup step? #2 Is it possible to require that, for example, a start time is ahead of (or after in time) the insert time field. Are there any good tutorial links out there for somethin…

I would like to use a a

Hi all, I need help setting up calculations working with dates for a non-profit community school. I am developing a course listings database which lists courses and holds fields such as: start_date, end_date, number_of_weeks, days_of_the_week, number_of_class_sessions as well as others. I need to generate calculations that have the ability to list all the possible dates for a course. For example, let's say there are two classes: A mini-course which runs for 1 week based on 5 days meeting Mon, Tu, Wd, Th and Fri. Therefore, this class has 5 total class sessions. A course which runs for 16 weeks based on twice a week which meets Mon and Wed. Therefore, t…

Hi All, A weakness that I have is with text functions. My situation that I'm stuggling with is phone company data that needs to be put into separate fields. The data includes field labels such as @TN for telephone # but it's one long text string. The first problem is getting only the data to the right of the field label. The second problem is that the fields in the text string can vary. Not all fields are always included (otherwise I would do a search & replace in Word on the field labels and change them all to tabs). Sample data: @SYC X @ACT I @CS B @TN 9145263333 @NME ALLEN; CARPET @HSE 3085 @STN E MAIN @LOST MOHGN LK @FUL ALLEN CARPET @CDN WESTCHESTER @…

I am trying to set up estimated dates of when a Progress Report should be done for Special Education students. The reports are done approximately every 63 days, with the first report due after a "Meeting Date", and each of the other dates using the actual report date before it, but should NOT include the Christmas holiday break (Dec. 24th to Jan. 2) or summer vacation (June 15th to Sept. 1), but needs to continue uninterrupted after these dates. I have decided not to include other holidays, etc., as they are not as long in duration. At this point, I have 4 fields set up for these estimated dates, but can't figure out how to exclude the above mentioned dates. Here's wh…

I'm not sure where to post this topic so I'll start here. I want to control the user's ability to write to or modify a field based upon the user's level of authorization, without creating separate layouts. The user's levels are based upon a password db's settings. These are then defined as 100 (admin), 10 (user) and 1 (viewer). I know this can be done in the FM base password system, but that has is too generic for my project's spec's. Any suggestions?

I am trying to figure out if a date is the first Thursday of the month. I was thinking of comparing the week of the first day of the month to the week of the RunDate (always on a Thursday) if they match, then 1. Unfortunately 11/7/2002 proved me wrong, I is the first Thursday of the month but it is in the second week.. If(WeekofYear(Date(Month(RunDate), 1, Year(RunDate)))=WeekofYear(RunDate), 1, "")

I am working on a project for a client of mine. The client is familiar with a set of keyboard short cuts using the "F" keys to complete many of the functions my database will support. My question is if any of you have had any experience linking an "F" key (or any key) to a script which would then switch the layouts or another action? Thanks a lot!

I would like to set the clipboard to a calculation, I can only think of using copy but that means I have to have the field on the layout. Can anyone suggest an alternate way?

Hi, I'm struggling a bit with the reporting capabilities of filemaker. Here's what I want to do: we have 10 files each for a different kind of test report. each report has the name of the person who took the report in a field and the site of the report. I want to get a summaries for date ranges for all report kinds. So I want a report containing Start Date: 01-01-02 End Date: 01-01-03 Test: one Site Reporter | A | B | C | ---------------------------------------------- Site A | 10 | 4 | 2 | ---------------------------------------------- Site B | 1 | 2 | …

From time to time you probably need to clean up text fields by removing extra carriage returns or spaces. The trim function will remove spaces at the ends of text but not in the middle, and it will remove all of them, even though you likely want to leave a single one in place. So, a common procedure is to run the text through a Substitute formula like this: Substitute(InputText,

I have 30 databases split between 10 different subjects and 3 different salemen. Each subject is split 3 ways by the first letter of the company name therefore for example one saleman has letters a-g for 10 subjects etc I want to merge all the databases. My problem is that at the moment when a salesman searches for a company they only enter data in two fields CALL STATUS and ACTION DATE to find someone that they want to speak to on that day. When they are all merged they will have to seach for CALL STATUS, ACTION DATE, SUBJECT and ALPHABET (ie whether or not the company is one of their letters) I want to keep it so they only have to enter values in two…

Database A has field "components" that is formatted to show a related field from Database B as a checklist. The problem arises in that this field is not wanted in all records. In fact, when it is not wanted, a different field "free text box" is desired in the same piece of real estate. Is there a way to simply show/hide, if I have one field behind the other? There is no objection to having the user initiate the action. Thanks!

We have a simple PO system with 1800 records. On 175 of the early records all the cost entrees have disappeared. They were all originally recorded because we have hard copy run outs but on screen these first 175 now have no cost entry info or totals? I do not know how human error could be a factor because that's a lot of human error, especially when it's all in a row from the front. Any thoughts would be appreciated, could the amount of entrees be too much for it so early info is now being deleted? Any help would be appreciated. Thanks in advance, morning man

Is it possible that when my script is paused that i can place a 'resume' button on the layout. the reason why is because the left hand side of the screen is hidden and so the continue button doesnt show? if so how do you setup the resume script? thanks

I have a datafile that contains 200,000 records. I need to perform 4 exports. They are: 1. export records 1,5,9,13...etc. 2. export records 2,6,10,14...etc. 3. export records 3,7,11,15...etc. 4. export records 4,8,12,16...etc. As you can see it is beginning with a record and then every fourth. Urgent guidance is appreciated. Rob.

Hi To All I have a situation where i can't seem to validate against two fields I'm trying to create a Time and Date entry for a community hall and don't want people to be able to book the same time/date. So far i have created a number calculation field (DateReq + timeReq) to create a unique number. Then using a Submit script I copy the value to another field Validation field where i try to "Trap" the error and provide feedback to the user to say it has already been booked. I have used the Validate options under the Field Definitions but this results in them having to modify the Validate value which means nothing to the user. I really need to redire…

Does anyone know of a way to calculate elapsed time (in this case for a timesheet entry) over the midnight mark? For example, an Employee works from 5PM Monday until 2AM the following morning. How do I get FM to calculate this as 9 hours? I know I can do this using the Date & Time Plugin from Waves in Motion, but I'm not sure I need to purchase it for this one calculation. Thanks in advance for any pointers!

I am currently working on a database for the documentation of athlete's injuries and their playing status. I would like to run a report which shows the number of days an athlete has been able, limited or unable. I have a main database with athlete demographic information and a separate related database for athlete status (i.e. able, limited, unable). A new record is created in the athlete status database each time their status changes. An athlete's status may change daily, weekly or monthly. I was planning on setting up three text fields in the athlete status database. One each to keep a running total of the number of days an athlete was able, limited or unable. Ea…

Hello, I have a database that has 2 value lists, say field (1) is sales rep and (2) is customers. I would like to be able to select a rep in field 1 and then all the customers for that rep appear in field 2, so then I can select from the second value lst the customer name. Is this possible if so please help. Thanks Chris.

My client has a db of images that are stored as reference. So for a client machine to view the images being hosted on the server they would first have to mount the server and then open the DB. Any ideas?

Okay..... Once again, I'm sure I'm missing something fairly obvious but, I suspect, I'm standing "too close to the trees". Here's the background info ---- Database Type -> Seminar Reservation/Attendance Field Info (Fields to be reported on/considered); Household Position (HshldPoz) - Text (by Value List) Value List - [*]Head of Household [*]Spouse [*]Youth [*]Child [*]Speaker [*]Other Day of Attendance (DayStay1 - DayStay8) - Check Box (Y/N) Other data; - DayStay(x) will be corrolated to a date in the finished product. - HshldPoz must be a value list since each type is used to calculate seminar cost. Assumptions; Fo…

Dealing with another's code, I am trying to do the following. I am trying to perform a search on a newly defined text field using a pre-existing form. This form allows you to specify an account# and other information. Maintaining the orignal coders' convention -- criteria is plugged into it using Insert Calculation with the defined calcluation being a given field; simple enough. Next, the layout is changed to a layout which contains all fields in the database to finalize the search criteria. Finally, Perform Find is issued to execute the find. However, when I add my own new field to the form, and then reference it using Insert Calculation to put the info into the f…

Hi all, Sorry if this sounds a duplicate post, for those who already have seen this post , but I thought I should report this on a specific thread. Curiously, the way FM identifies non-alphanumeric characters may vary from your system settings. This is at least true for the ":" , which isn't considered as a separator on the French Setting (may be on other too). This may lead to some errors when your solutions might be dispatched around the world, and use some TimeToText functions for example. When I discovered it, I went for a search on the Forum to see if someone already had reported it, but nothing. In little time however, I've found a lot of a…

Is it possible to have filemaker auto tab to the next field when the previous field is full. For example, I have 4 fields XX:XX:XX:XX to represent a time code. Instead of having the user tab to the next fields which wastes time and yeilds mistakes, I would like them to be able to enter the data without breaks such as 00112233 and have it automatically enter in the the above 4 fields.

I have set up a script to relink image files to records via 'insideScan' It seems that FMP (osX) keeps crashing at random intervals. I am assuming that it is the memory but does anyone have any suggestion to the best settings to handle a script that has to loop through 4000 records.

I use a Now Contact as my primary contact manager. I want to export the data from Now Contact and Import it to FileMaker to do a field by Field clean up then Sync it with a Palm Device using FileMaker Mobile. The problem is the Notes Field in Now Contact. Now Contact allows for Multiple Notes to be present. When the data from this field is imported into Filemaker it has a character that looks like a Paragraph return character seperating the different notes. However is is not a return character. I have a script that uses a Substitute command that will find the character and replace it with a "-". The substitute command does not recognize the character so no substitution is…

Hi All, sorry if im posting in wrong thread!! What i want to know is: can Filemaker and Oracle comunicate with each other? thanks, rich.

I can't figure this one out. I have an invoicing system where I want to be able to show, if possible on the same page, a report that shows total sales for last year, divided by months, this year's sales, divided by months, and the percentage difference between these 2 years and the percentage difference between each months. In case my English is not good enough, need a summary field showing on the first column last year and the total sales for last year. Under that, I want to see each month of the year with total sales for each the months. Next columns is the same, except it will represent the current year. Next to the year field I need to see the total sale for that year…

Hi all I have a problem with a solution I try to build and I need some help. I have a CalendarDB and a ProjectsDB. CalendarDB has 2 layouts, "Monthly" and "Daily". Clicking on a date - field "CalendarDate" - in the "Monthly" layout, it brings to front the "Daily" layout for that date, that contains among other info and a portal which displays info from ProjectsDB or creates records for the ProjectsDB. ProjectsDB contains the fields "StartDate" and "DueDate" There is a relation "C_to_P", which relates "CalendarDate" from "CalendarDB" with "StartDate" from ProjectsDB. The result is that I can see only projects that start on that date, when I a…

Is there any way to give regular users a way to create and modify simple merge documnets? Anyway to fake it? The only thing I could think of is a kludge of nested Substitute and GetField functions, but it's not as dynamic as I would like.

Greetings all, I am in the process of developing a survey solution that users can answer questions on a laptop and where administrators can display the survey results real time with a click of a button. In addition the survey questions will also be loaded on a PDA and survey takers will be able to gather survey information via talking to customers and entering the answers via the PDA. PDA data will then be imported into the laptop that houses the main database that has all of the calculations etc for displaying the data/results. The main problem is that the people who will admin this survey tool know nothing about Filemaker. So my thought is to develop a fra…

Hello everybody! My database has three calculation fields for 1) Years, 2) Months & 3) Days since a person was hired into the company. My boss wants a Pop-Up List to keep him aware of employees who are in their month following their anniversary within the company (to help organize vacation periods). The Pop-Up List should jump out every time a database session begins. In other words, a Pop-Up List of employees whose Month Field = "0" (zero) and whose Year Field is equal or higher than "1" (one). Is there such a thing within Filemaker? Can it be done? If not, how about a Dynamic Layout that only displays employees whose Month = 0 & Year >= 1.…