The Left Brain

Hi. I would like to create a report that contains records from first table and related records from second table below them. I have tried so much i dont think it is possible. The tricky part is that in some records there are nine related records and in some records there are none. if i make room for nine related record than most of the document looks empty. Any idea or help is appreciated.

Hi folks, I've been searching everywhere for a solution to what I am trying to accomplish and have not found one anywhere, so was hoping someone out there would be able to help. I am trying to create a custom sort in a solution. As in allow the user to choose any number of column headings and be able to sort in whatever order they wish. Now I know this is what you can do when you click the sort button. However, I don't want the user to use Filemaker's sort window as it will get very confusing for them to try and figure out some of the field names. My thought process so far is that I can create a couple of side by side portals that basically mimic the sort box. All…

I have a calculation which is generally working. It processes a lot of numbers. But I've run into some problems with some older data processing after updating some figures. Part of the script to calculate the value I need includes this line which is where I think it is going wrong: If[File::cWeightedAverage < 1] File = the FM file and cWA is the field which is calculated using a formula. However, what is the field value doesn't return a value less than '1' because it is blank? How do I put that into the script? e.g. main script section which includes this line is: Go to Field [File::cWeightedAverage] copy [select] If[File::cWeightedAverage < 1] …

Hi people. My script working slowly and any idea to speed things up appreciated. I import records about 60000 long to a field. And i have 60 more global fields with named as values from imported field i wrote a looping script which gets the name of active field, match it from imported field and counts the number of matching values in the imported field. Does that for 60 times and it get really slow. It is a commomly used script and i need a more practical way. Here is code: Go to Layout [“dış veri” (Dış veriler)] Set Error Capture [On] Allow User Abort[Off] Delete All Records [No dialog] Import Records [Target:“Dış veriler”; Method:Add; Character Set:“Unicode”…

This is just an example to demonstrate my problem... getastimestamp( getasnumber((timestamp(date(1;1;2001) ; time(0;0;0)))) ) returns 1/01/2001 00:00 getasdate( getasnumber((timestamp(date(1;1;2001) ; time(0;0;0)))) / 86400 ) returns 31/12/2000 (Australian formatted date) Am I missing something obvious? Using FMPA 12.0v3

I need to create a global field based on a found set calculation field. The problem is the global field keeps being based on the total records rather than just the found set. Any thoughts? Much appreciated. Thanks in advance,

Hi, I had a simple question that had recently come up in my scripting. When writing a script that contains a Custom Dialog with just the default "OK" button and no other buttons, is it necessary to use a Get ( LastMessageChoice ) script step right after to properly close the dialog and perform the next action? Or is it okay to just write the rest of the script steps that follow, right after the Custom Dialog step, without getting the last message choice? Since there really is only one button choice presented to the user and not multiple outcomes. Thanks for any insight! Bellow is a sample script with this scenario: # Show custom dialog with only one butto…

Greetings, I have a global field that is acting as a search bar to perform a find with the data stored in it. I have set an OnObjectKeystroke script trigger to the field to activate a script if the user presses the enter key while inside the field. Since most users are used to hitting enter on their keyboards to perform a search and it's much quicker, I've adopted this method as opposed to a search button. I would like to prompt the user with a warning dialog if they press enter while inside the search field, but happen to leave the field empty. The custom dialog would tell them to type some search criteria in, instead of leaving the field empty to avoid performi…

Hello, I'm currently writing an XML SOAP Request and it requires the time / date to be formatted in a certain way and I'm just wondering if FileMaker can format it like I require. I require it to be formatted like this: 2013-04-26T10:10:00 I need the T to stay too... Thanks, Scott

Is there any way to validate a field when the value of a different field changes? Example: I want my service tech to check a box for Type of Service before he is able to change the Service Status to Closed. Right now I have the Type of Service field requiring validation but I really only need that box checked when the status changes to closed. I don't want the person who creates the service to be required to check that box. Is there a script or something I can write to make it do what I want. "If Service Status = Closed, then validate "Type of Service."???

I have a database for my students - this includes a number of assessments - say 10. How would I be able to get an average score for each student bearing in mind that some students would have submitted all assignments while others would have submitted only some assignments. I want to be able to calculate the average based on the assignments they have submitted. Any help gratefully received Regards Edddiett

I have an application called "MEMBERSHIP": It has these fields: PKMEMID MemberLast MemberFirst Mem_Can (Holds "Member" or "Candidate" as appropriate) ActiveInactive (Holds "Active" or "Inactive" depending on the member status. I want to create Membership::gcMemberActiveSummary that is Global , caluclated field that holds the COUNT of (Mem_Can="Member" and ActiveInactive="Active") I have tried: gcMEMBERActiveSummary=count(Evaluate(ActiveInactive="Active" and Mem_Can="Member")) I suspect I have to create a layout, add the necessary fields.... filter the necessary fields and and then script a 'count' of the displayed fields then set the global fi…

I recently upgraded from FileMaker Pro 7 Developer to FileMaker Pro 11 Advanced. There are far more changes than I had originally expected, and so I'm carefully going through The Missing Manual book. I note that the FileMaker Runtime is approx. 100 MB larger than before! Anyway, I'd like to trap field entry mistakes at the time of the mistake rather than wait until the user clicks off all the fields. That's when the regular validation occurs. How can this be done with the new triggers? For instance, if more than five numerals are entered into a zipcode field, I'd like to trap that immediately (beep) and put the cursor back into the zipcode field. But that doesn't …

I want to convert a date into a hexadecimal format e.g. 1352951100000 Can anyone help with a script or calculation? Thank you.

hello everybody I am pretty sure, that I've read about a technique that allows me to do the following, but I cannot figure it out. 1. I have a field with the value "a" in it. This field has a OnObjectSave trigger. 2. Now I change the value to "b" and the trigger fires. While the linked script behind the trigger is running, I am sure I read somewhere that I should be able to retrieve the old value "a" through a relationship somehow. So...is it possible to retrieve an old value BEFORE a record is commited ? Anyone any ideas:) ?

Hi every one, Do you know any Filemaker solution for pharmacies/ chemists etc? I google but did not find any solution specifically designed for pharmacy. I am in Australia and it would be great if any one have solution for Australian Market. I have Filemaker Ver. 10. It would be great if I could find any solution in ver. 10. Thanks in advance. Regards, Tusif Note: I was not sure where I should post this topic. I am sorry if its wrong place. Thanks.

Dear FileMakers, I am attempting to write a script to Ping an IP address, perhaps 10 times over, and to output an average response time in ms, and the packet loss as a %age to fields in my DB. In my searches, I found an AppleScript which can be called from within FM and give a response time within a dialogue, but no %age packet loss, in a dialogue: https://discussions.apple.com/thread/3833490?start=0&tstart=0 And that is as far as I've got in quite a long time. Ideally, calling the script from within FM would trigger the ping test and output the time and packet loss to their respective fields, but if this is unfeasible then simply outputting to dialogu…

I want to create a found set based on a (return-delimited) list that I paste into a global text field, i.e., Mary Fred Joe I've got something that works; I'm wondering if doing a Perform Find prior to the loop, then using Extend Found Set in the loop is typical. It works. I just end up with (possibly a few) lines of redundant code: #Get the number of values in the global field: Set Variable [ $valueCount; Value:ValueCount ( Create found set from a list of values::gValues ) ] Set Variable [ $incrementer; Value:1 ] Set Variable [ $value; Value:"=" & """ & GetValue ( Create found set from a list of values::gValues ; $incrementer ) & """ ] Perform F…

For FileMaker Pro 11 Advanced, I'm looking for a custom function and calculation debugger. This would be like the script debugger, but for custom functions and calculations. Does anyone have a plug-in for this? Or is there another solution? My custom functions and calculations can be very complicated and thus difficult to debug by hand or by printing out intermediate variables.

Bottom Line: To FileMakers new Container, "your going to end up with too many external folder(s)". for my FMA12 i just not want a bunch of external folders laying around all over in various locations on my Mac !! My Quest has long long been to have all my photo library images all reside in one file / table. Currently the embedded images resides in a FMA11 file at 13,500 images at 6 GB. Unfortunately it is corrupted but do have its clone in FMA12. i could convert it but fear to mess with it as the file sits active open. i have 20 GB of images from my iPhone camera now residing in various folders on my desktop. KNOWING WELL ALL OF FILEMA…

I wanted to make a keyword generator for an SEO campain we are starting. this solutions seems to work fine, but I was interested in other ways to do the same thing and I couldn't think of any as I have been under the weather for a couple weeks and everything seems a little fuzzy right now.. Please add your 2 cents. Thank you. keyword.zip

I've just created my first invoice using FileMaker Pro and I am quite satisfied with the outcome. I am getting the expected result as far as information and summary information. There are place where an improvement could be made. I am using the portal tool to display each line item making up the invoice. I've got the number of possible row for the portal listed to 8. However most of the time ( > 95%) I will only have one or two line items to be written on the invoice. Being at 8, this cause to have a lot of blank lines between this line item information and the summary information. Is there a way I could have the number of row to be written depending on…

Before I begin building from scratch, has anyone seen a solution for managing window size and postion. I am thinking of a global variable to hold an array of window settings such as: layoutA; height; width; top; left layoutB; height; width; top; left layoutC; height; width; top; left Then a custom function to pull the settings: setWindow ( layout-name; h )

Hey y'all! I'm super new...very green if ya know what I mean, and I'm about to pull all of my hair out… Oh please, one of you Filemaker Gods please help! I've converted our business over to Filemaker from (don't laugh) Excel. There, I said it. Any way, I didn't put it together originally, I'm just the cleanup crew. So as much fun as I'm having with the relating tables thing (NOT!)(I'll be sure to come back and post more questions about that!!!), this calculation has me in a tizzy. In fact, I was going to ride today, and vowed I would when I had this figured out…it's 3am…the neighbors (and my husband!) would hate me if I started her up this late…well that's assu…

I am trying to create an Opener File using the instruction I've found on the internet. Unfortunately, I am getting the error message The account and password you entered cannot be used to access this file. Please try again. I've followed instruction's I've found on the internet (see attached). What am I trying to do? I've created this opener file to get access to the remote pZV filemaker pro apps I've created. The apps is located on a mac mini server. The step I usually do are the following : - Open pZV on the mac mini server - Open remotely the pZV app (this is usually manually done on three other macbook pro) I am trying to simplify the steps b…

My question may not fit in a left brain section of this forum. There no right brain section in the forum and I need an advise. With regards! Daniel SITUATION I've created a FileMaker Pro application which brings efficiency in the way my business operate. Lately, I've introduce the use of a bar code to get a quick access to my customer information. With the use of mobile device, I would like to know if someone knows a iPhone/iTouch app I could use to read my customer CLIENT CARD information and move the information onto a specific field in FileMaker Pro. In other word, I want to have a backup solution in case the bar code reader device I am using b…

I don't want to rely on the clients date time.. ..but grab it from external source.. Thinking about setting up an option to rent my FM application, and not let user set internal clock PC backwards? Any idea? ADDED FOUND THIS... now how would i get this... I think i can create a rental process if so, with little integration to my app http://www.kloth.net/software/timesrv1.php Get Date and Time from a time server There are several official Time Servers in the Internet, which provide time information. there are several formats and protocols used by these time services. The DAYTIME protocol, RFC-867

We were trying to use Month() calculation to set reminder. However, it is not returning the result as intended. We have a startDate field and would like to add exact 2 months to startDate as reminder. Intended results are: startDate > reminderDate 19/03/2011 > 18/05/2011 01/11/2011 > 31/12/2012 30/11/2011 > 29/01/2012 31/12/2011 > 29/02/2012 01/01/2012 > 29/02/2012 In remWe used Date(Month(startDate)+2; Day(startDate); Year(startDate))-1

This is possible I am not posting this question at the right place. Here is my situation. My process starts with an AppleScript being executed when I insert a SD card in my MacBook Pro. The script executes and when situations arise a cell "statusSD" is being updated in the filemaker pro database accordingly. In the meantime I've created a FileMaker Pro layout which is always showed on the screen. I would like to push this further. For example when the SD card is included I would like to have a button to appear with a different color as the script execution progress. For example, once the key is inserted in the computer I would like the button to show in r…

I have a Calculation field containing text such as "Cats & Dogs" and "One, Two, Three" I need to replace all occurrences of 'space' in every occurrence in this field with a string ('&nbsp;' as it happens) but when I use functions such as LeftWords or PatternCount in doing this, the '&' is ignored, and the 'commas' in One, Two, Three get stripped out. I presume that FMPro is treating anything non-alphanumeric as 'whitespace'. What is the most elegant solution to this problem? Using FMPro 8.5, and not planning to upgrade in the very near future...

I have a script that schedules children, based on their choices, into six class periods per day. We call these class periods "Focuses" (just so you understand the verbiage in the script). My staff had been giving me feedback that the the morning focuses attendance was jammed full and the afternoon was slack. This made sense because the script would schedule kids systematically starting at focus 1 filling the classes to focus 6. So I wrote a sub-script (Attached) that would randomize the order in which each focus was scheduled, so the kids were distributed into each class equally throughout the day. This works well but the this sub-script REALLY bogs the overall pr…

Hello I would like to see if there is anyway to have a text field scroll through a calculation in filemaker. Similar to a teleprompter. Thank you.

Hi. I'm a beginner with FM and study the Help and Tutorial of FM. I see that there are 2 dictionaries in FM > Main .mpr and > User .upr Both are stored in Application > FM. When I as normal user create a new word I cannot use the command Learn. Why ? Has someone an idea what can be the reason ? Thanks Jochen (.de)

Hi everyone! Glad to have found the forum, the tips here are amazing. So I was wondering if maybe one of you could help me tackle this conundrum. I've searched several forums but I can't find a clear enough explanation. I'm working on a database for a friend, based on school attendance. I have a Student table and an Attendance table. One Student can have many records in the Attendance table. So the relationship is a one to many from Student ---< Attendance. The two tables have the following fields: Student table Name Start date End date Attendance table Date Present Each student enrolls in an educational program and begins classe…

Hi, IN my DB i found very strange thing in my one of table records i saw 1 record having ? marck and due to this record it is creating problem with another record.it is relating with that 2ns record only. i cant view its values of any field can modify. please suggest me how to overcome this problem? I dont delete due to other record relating with it. thanks,

Hey guys, I have a invoice program I have been working on to try and keep track of my hours and overtime. Everything is 1 Layer, with each record being a seperate invoice. Select you date and clock in and outs and it calculates, how many hours per day, then totals it up for a 2 week cycle and display's the info at the bottom of the page, as well as showing any overtime (above 80 hours for 2 weeks) that was earned in a seperate field. After a record has earned some over time, that overtime is also shown in a field beside it called Banked time, which then gets carried over to the next record. The idea being is that for each invloice that is being submitted or printed y…

I'm sure this has been a past post, so if anyone can point me in the right direction... I would like to have a history of the last 5 or 10 records so that if interupted, one could go back to the previous record that they were working on... Thanks, -Marc

I'm pretty new to the FMP community so I apologize if this is not the right place to post this question. I am in the school fundraising business and I work with about 100 schools that do annual fundraisers (magazine, chocolate, gift, etc). Although my parent company does all the customer invoicing- I still wish to track year to year sales for each school. My goal in FMP is to view each customer record in a layout that shows: 1.) the info that rarely changes (school name, phone, etc) and 2.) information that is unique to the current school year (which includes comparison to some of the previous years data). I have over 105 fields that are unique to each sc…

I am using Windows 7 and FMP 11. When I use my mouse scroll, my records change instead of the window scrolling up and down. On a Mac, it scrolls the layout, but on Windows, it changes the records. I've read solutions online that suggest lock/hide status area, but I would prefer to keep the status area on the window. Has anyone come across this problem and found a solution? Thanks in advance!

Not sure where to even post. I would research but not sure what tools I would use (web viewer, dragon speaks, container) to even search. I have no idea how to even go about researching it. Can we somehow capture a meeting conversation with an iphone or ipad in FMGo? Can we also have that meeting converted to text back at the office? I know there are things such as Google Translate but can that work in FM?

Dear All, I have the following which works fine if the field "day" contains a single value like "Monday", but fails if it contains multiple values (like "Monday Wednesday Thursday"). Can you advise? If( day = DayName ( Get ( CurrentDate ) ); "Current" ; "" ) Many thanks

Some of my records I want to allow users to order. For example, I have a Table called Topics. I implemented this in the only way I thought possible: by creating a field called TopicOrder, which takes on the values 1, 2, 3, 4 ... Users can add or delete a record and move records up or down, and my scripts do all of the necessary bookkeeping, making sure that the TopicOrders form a continuous series starting at 1. If the integrity of this series isn't maintained, then various database functions are likely to act in screwy ways. I also created a consistency check that is performed on the server overnight, to make sure that all of the lists of ordered records in my database h…

I am racking my brain for a solid solution to scheduling problem. I have a system where the client had weekly events schedule, except for holiday and other closurs. A list a date would be supplied to clients so they didn't come in on the weekly appointment on closure days. To do this, I had fields for each day of the week, and start and end dates for the seasons. Then populated each field with a script that took the start day, and added 7 until the end date. Then allowed the user to take off closure dates and then the list for the relevant day was supplied the client. A new requirement is to add the option for appointments of either weekly, or 2 groups with…

Although, not quite as simple as that. I have a pretty straightforward recordset, with fields including "Start_Date", "End_Date" and "Revenue". "Start_Date" is always the first of a month and "End_Date" is always the last day of a month. The space between "Start_Date" and "End_Date" can be anything from 1 to 3 years. I need to calculate the revenue per year, so if the "Start_Date" is 1/4/10 and the "End_Date" is 31/7/12, I need to calculate the revenue for 2010 (from 1/4/10 to 31/12/10), for 2011 (the whole year), and for 2012 (1/1/12 to 31/7/12). In this case the 2010 calculation would give me 9 months, 2011 would give me 12 months and 2012 would give me 7…

Hello, this is what I’m trying to achieve… We are a window cleaning company, basically what I’m trying to do is automatically generate what a customer’s cleaning price would be to clean all their windows based on if the house is a 1 level or a 2 level, depending on how many windows, depending on where they are located (to cover gas prices).. I have created what I’m trying to do in excel, but I’m unable to get it to work in FileMaker (Different formula language) What I want to do is start with a base price.. say $25.00… then, for each window add say $2.00 (if it’s a 1 level) or add $2.50 (if it’s a 2 level… Then, depending on what city/zip they are loca…

Hey, can anyone help me with a formula? should be super simple... I just can't seem to write it out so FileMaker understands it.. Basically have just a few different variables.. Window Count = W House Level = L Base Price = Bp (Starts at $25.00) Exterior Price = Ep (= $2.00) Interior Price = Ip Forumla i'm trying to write is kind of as follows... If L is less than 2 then use Bp & Ep and then divide the W by 3 times it by (Ep x 3).... If the W=12 in this paticular situation, then the answer would = $49.00 Can someone help me write this forumla to make since within FileMaker.. Like I said I don't think it would be that hard, yet im' s…

I don't know what I did wrong but I can't input any new data iinto any of my records. Whenever I click into a box to add in new information about a project that is in progress it won't let me type into it. I am in Browse mode so I don't know why its limiting me.

I have a client who sent me a txt file with data I need to get into Filemaker 11. I can handle pretty much everything but am stuck on the address, which happens to all be in one field. Now getting the zip code and state is not an issue since those are the last two items on the address line, but where I am having issues are the streed address and city. Some cities are one word, some two and even some three. Addresses can begin with a number ( typical) but some don't. And no types of delimiter information in the field such as commas Attached is the file in question. Thank you in advance for any help! Brian foinspct.txt

Hello all, I am creating a inventory database for a bee keeper where he will keep track of the number of hives (along with sorted other things bee keepers track). He would like a layout which will show him by month what his ending count of total hives is. SO my problem is how to summarize across many locations the final count of all hives. Some locations will have many counts for a particular month while others may only have a few. The basic structure is as follows: Table: Locations Field: _LocationIDpk Field: Location Name Table: Inspections Field: _LocationIDfk Field: Date Field: Hives_count He will use this to track the loss o…

How can I determine if a month-year field is one month ago, two months ago... for each month going back 12 months? Is there any way to do it without having the longest calculation ever?

Rather reinvent .. just wondering. is there any plugin i can look at? Say from a client picklist.. I want to pull up a calendar ...like our Calendar function does Be able to click on multiple days for this client... highlighting each day Also to view a month having client ON CALL for emergencies on such and such days at a glance Thanks Rod

This topic is created so you can post and discuss your solutions to the 'great' challenge posted here : http://www.1-more-thing.com/Dynamic-Sort-Challenge.html Because 1-more-thing is a very rich company that offer an incredible range of services to FileMaker developers worldwide, we decided that the first to solve this challenge should receive something BIG. This is why we put great value on the table... a box of delicious Belgian chocolate! I hope you're going to try hard, and hopefully come up with better/crazier ideas than my own solution. It's only for fun!

Hi all, I have the table products and keywords. In this Each product having multiple keywords. The keyword should not duplicate in each of the product. But same keyword can used in the another product. In the keyword table I have the product id and the keyword field. How to validate the duplication. Thank you.

I made a purchase order database using the starter solutions but I want to add a function. I want to be able to select a button (like off and on) and stop the editing of the data. This would stop someone from coming back and editing information by mistake. How can I do that?

I have a system with Plans and Certificates. Each plan has many certificates. Within each Plan, certificates must have sequential numbering starting at 1 (not used as a relationship key - it is for other business reasons). I currently use a relationship and set the CertificateNumber to Max ( relationship to existing certificates in same plan ), but if two users create a certificate at the same time, it will get the same id! I need to make this impossible. I was thinking... Put a field in Plans called "NextCertificateNumber". When creating a new certificate, make sure the Plan record is unlocked, then lock the record, then create my new certif…

I've tried looking for this on the site but so far couldn't find the response, here it goes... I have a big list of records which I broke every single word and created a dictionary of unique words in all the records, omitted everything that has numbers or special characters, so only words were created. This is where I'm stuck, I need to identify in a new field if the word is wrong spelled, in other words, if there's a red line in the word I need to be able to identify it, but not correct it, just tag the record, so based on some criteria later on we can integrate those words into the dictionary. Is there any way I can capture this with filemaker? Thank…

Dear All, I have a field [values] where a range of values (say A - E) can be added. Viewed across a number of records we get something like Record 1 [values] A Record 2 [values] Record 3 [values] A Record 4 [values] C Record 5 [values] B Is there a way of producing a summary field of [values] where the above would return : A B C thank you

Hello, I need to process a string on over 6000+ records and will eventually become an automated routine, basically I need to clean a string which will be implemented in web publishing and I would like to know if there is a way with just 1 step to read a string and replace all the alphanumeric values (meaning a value that contains both numbers and letters) in uppercase. I already have a custom function that cleans the string based on the on the symbols I don't need. These would be a few examples of what I need to do: Original: Ultra2 SCSI Cable New: ULTRA2 SCSI Cable Original: CMOS Battery (7.2V, 15Mah) New: CMOS Battery (7.2V, 15MAH) Ori…

Here's a tricky one. Count the number of people in the room. If I had an infrared photograph I could count the number of bright areas in the image to get the number of occupants (or at least a statistically close value). Assuming I was able to extract the chroma value of each pixel and insert to a record, (plus a position field), I would have a map of the image. I have a vague idea about creating a virtual zone of say 100 pixels (10x10) in the top left of the image and doing a search for the records in the zone. I'd then need to find the record with the highest value. This would then form the centre of my next search and using get nth record re-evaluate my new s…

Most all of my Finds/Searches, I need to find a property that is closest to an address or zip code, and I'd like to either search something like "All properties within 30 miles of zip code 12345", or even "all properties within 30 miles of City Name". The problem is, I may need to look for something in Portland, Oregon, and come up with 1 or 2 properties, but I have 5 more just 5 miles away in Vancouver, Washington. Any ideas? Thanks.

On an order acknowledgment document that is based on an order line items table and constructed using a list view with headers etc., we are being asked to have one particular field display in the body part only on the first occurrence of the a piece of data. So the first record would display X in that field and in the list view nothing would display in that field for subsequent records until a new value appears. The list is sorted by that particular field and the logical way to do this would be to display in a leading sub summary part, however they are being very specific that they want it displayed in the body data. (They are trying to replicate their previous document…

I am sorry if this has been posted already. But the search system would not let me use those words. I am trying to enclose double quotes in a "send apple script", script. Here is my script. "¶tell application "& """ & "Finder" & """ & "¶set myTest to do shell script "& """ &"md5 -q "& """ & "/Volumes/Extended/tmp/" & Duplicates::Filename & """ &"¶end tell ¶tell application "& """ &"FileMaker Pro Advanced"& """ &"¶set cell "& """ &"Duplicates::MD5"& """ &" of current record to myTest¶end tell" "Duplicates::Filename" contains single quotes within the field, so I am unsure how …

Hi guys... At the moment within my database I have a layout which is meant to tally hire costs for loan of a product, within this, 2 sub summary parts so that records are grouped by the day they were collected by the client and the unique serial number given to each loan. The layout also has a grand summary in which the total of both the hire costs and Late fees are being tallied. This is all happening correctly. However, when trying to use these values inside a calculation that totals up both the hire costs and the surcharge for being returned late, only the very last record on the reports hire cost and late fee are being used. originally I had the calculat…

Hi All. I am in the process of figuring out a way to create letters based on a series of questions. Let's say I'm creating a "Court" related letter. The data entry user have to go through a list of questions like "Does the client have a witness?" , "Was there an officer present at the time of event?", etc... which will possibly lead to more follow up questions based on his/her answers. The output (finding) will/should be based on the answers and will be generated on a court letter template in MS Word. Is this something we can easily achieve in Filemaker? Is there an alternate suggestion/solution? Thank you, Dave

I am using the SortValues Custom Function which uses another Custom Function MinValue. http://www.briandunning.com/cf/290 (SortValues) http://www.briandunning.com/cf/288 (MinValue) MinValue is causing a duplicate in my SortedValues return set which returns: Access_Management_Policy_R1.doc Access_Management_Policy_R1.doc I should be getting back: Access_Management_Policy_R1.doc Third-Party_Access_Management_Policy_R1.doc For some reason the MinValue truncates my second filename to match that of the first, which is also the first item in the list of values being processed. If I use the SortValues with a decending sort (MaxValue), it…

Hello I want to call the content of the information of a phone number, like 071 2776469. I could for instance call http://tel.search.ch/?was=0712776469. It's easy to create that formula to make it work under FileMaker Pro 6 or greater. Another site (local.ch) brings more information on that number. Can anyone help me with a formula to catch this (in Firefox on older FMP, in the FMP window on newer versions). Thank you for your advice, have a nice day!

Hi Forum I need to change the content of af field after 24 hours. I think i need to make a field that stamps the time and use this in a calculation, but I am not shure how to make the calculation needed for this to happen. Can anyone help please? Thanks in advance... Kasper

I'm looking to build a recursive cf that generates a non repeating value list of positive integers within the upper limit and the quantity of items in the list specified at run time. for example the user enters 12 into a global field (ceiling) and 5 into a global field (qty). The cf should return a list of 5 random, non repeating, numbers in the range of 1 thru 12.. 1, 2, 4, 7, 12 ....good 1, 1, 2, 6, 9 ... no good because of the repeating 1 0, 6, 8, 9 11 .. no good because of the 0 3, 9, 10, 11, 13 ... no good because of the 13 4, 5, 6, .. no good because their are only 3 numbers -3, 4, 5, 8, 10... no good because of the -3 you get the picture. …

Well it's been years since I touched Filemaker, as it just never came up, but now I'm working in it again and I am finding myself slowly getting back in. I have a problem with parsing data out of a field and I hope someone can help me out, as it may be a simple calculation...or it may not be. Anyway...I've got a field from a distributor that I believe is using SAP and they export this field in a garbage in/out format which comes into Filemaker as: GROCERYSTORENAME # 6345 - LOS ANGELES, CA sometimes it doesn't have the store number: GROCERY STORE NAME - BOSTON, MA What I want to do is extract the store name, city, and state...and of course I've go…

Hello all. I have an issue for which I have been using the same solution for a long time but was thinking that perhaps I am missing something and one of you brilliant types may have a better way to solve this problem. We have several tables that keep numerical data that needs a running balance, with a total at the end. However, it is also necessary sometimes to pull a report which is a sub-set of the data in the total, say for a particular date range. The problem is if you restrict the data to a sub-set of the data, the balances will only be for the sub-set of the data. I have been solving this up to now by using a process which finds a subset of the data up to …

Hi There, I've been asked to construct a commission calculation that initially seems quite simple to me, but as I've gotten into it I'm find it pretty complex and its reached a point of painful. At it core the concept is that the commissions are calculated on two tiers. There is a standard percentage paid on all sales that fall below quota. A a higher commission is paid on everything above that quota. It seemed to me that it would be a pretty straight forward case calculation. The tricky part are the sales that come in tipping the scale with part of the sale being below quota and part of it being above quota. In that case the portion of that sale that bring…

never mind...

Hello everybody, I'm a bit undetermined about the structural design of a business assessment in FileMaker. Here's what I need and have: Table 'Positions' Table 'Values' Table 'Categories' I display the positions table, which contains the fields year, company, positionText and a calculation field with a fix value for every time period that has records in the table "Values" (M1...M12, Q1-Q4,Y). The "Values" table contains various fields for planning figures, actual figures and calculations with these figures. Basically it looks like this: year | company | category | customer or other planning positions | Y planning Fix* | Y actual/plann…

Hello All, Im not sure if this is the area of post. Kindly forgive me since I am a n00b. I am looking for help on celendars. 1. Is it possible that have the calendar date be grayed out or block after it reaches or was selected 30 times? Ex. If I have people choosing a particular date they want to visit and they select Jan. 1, 2013. If Jan. 1, 2013 has been selected or reached 30 times, it will either block the date selection or give them a note saying date is full. I am not great in coding but can understand a little bit. Again, a n00b 2. A report of who booked on that particular date based on name, email and phone number. I have a…

I have 10 Membership fields: memType1, memType2 etc... These fields are on a "Setup" layout To get to Setup, you click "Setup" on the main "Membership" window and another window opens and shows the setup layout. ok There is a 'Membership::Type field that is dropdown that previously was hard code with membership types: Yearly, Honorary, 25 Year etc... I decided to implement a system whereby when a user leaves the Setup window, a concatendated string of the Memtype1&MemType2 etc. is formed and inserted into Members::XValueListHolder. The Members::Type drop-down references Members::XValueListHolder as it's source. I CAN SEE Members::XValuelistHolder…

I was just writing some scripts that created related records, and came across an interesting error trapping technique that I thought I'd share... Sample script before error trapping: Set Variable [$id; invoice::id] Go to Layout ["lineItems"] New Record/Request Set Field[lineItems::invoiceID; $id] Set Field[lineItems::anotherField; "some data"] Set Field[lineItems::andAnotherField; "some more data"] Go to Layout [original layout] Here are a few possible error scenarios: user does not have privileges to create new records, script would error at the New Record/Request step, then ask the user if they want to continue the script or cancel it. If the u…

Hi, I want to integrate with xero application with FM Application.

I know typically databases are more efficient in some respects with the columns vs rows - tables that only have a few columns vs tables with dozens of columns. I am trying to decide were to place some data... I have a "Loan" and each loan generates two different Amortization Schedules - The difference between each schedule is the repayment interest rate - and each schedule is active as one determines clients value and the other is for the fund manager. (its complicated) Should the schedules be in one table? (Short & Wide) Each record is a monthly payment and i would have duplicate set of columns for each values starting balance, payment…

Hello, I am partially there, I'm stuck on one Total Grand Cost, I have a group of records (with individual Costs) I created a record that totals up the costs (Sequences) this is working fine. The issue is when I want to add up each total Sequence cost to have a grand summary at the bottom. It is not adding, and only showing the total sequence cost of the one set of groups I have selected. Please help! Thanks As always FMF

This is going to be tough to describe, never mind solve but please bear with me. We have roughly 100 departments in our university, most of which submit funding proposals every year. Each proposal is designated one of ten category types. I have a database which includes the department name, proposal date, proposal type and proposal amount. I need to produce a report which sums the proposal amounts for every category by department, as well as the total for each department, and to list the results side-by-side for each year from 2008 going forward. Using a report layout it's very simple to get the results for a single year at a time by searching from 1/1 ... 12/3…

Hello All; trying to develop something in my head but before i start perhaps someone can lend me some advice. E.G. BUttons with Global Values are going to be users choice When they Click / select the button, the item is added to their order, however, When they click the second option, the amount is changed based on user(s) 1st selection, Eg 2: Choice A Vanilla 8in Cake Choice B Chocolate Mousse Filling ( + $5) if 8in cake Choice C Style #ABC) + $7.50 If i use Customers Table --> Orders Table--> Line Items <---- Products Table --> * Think the attributes table would need to be here* But i have heard so many bad issu…

Hello, I am Trying to figure out how to do a layout/Calculation that I need to do the following: I already have it so that it breaks out records into sequences and calculates total costs. Within the Total Costs there is a possibility of 3 Facilities that are placing bids. I would like to have something set up so that I can see the summary of Each vendor. The field name I have is "Facility" and there are 3 possible options. "Facility 1", "Facility 2", and "Facility 3". So I would like to calculate the costs of the found records for each facility. Would appreciate any help on how to do this!! THANKS FMF!

Hello, I am trying to do a count of how many times a Certain word appears in a text field. I would like to count how many times "Suit 1" and "Suit 2" appears in my database, all references would be entered in the same fields, among different records. Thanks, Dave

I have a business that uploads large credit card batches for processing. We always have a couple hundred clients that have expired credit card dates on file with us. I'm trying to write a calculation that will compare today;s date (mmyyyy) with the expiration date (mmyyyy) of the credit card and flag those cards that have expired. The year portion is easy:I have a calculation field called C_Exp_Verify which looks like this = If (C_exp_Year < Current_Year; TextColor ("EXPIRED" ; RGB ( 255 ; 0 ; 0 ))) Now we are into 2012 and I want the calculation to flag credit card expiry dates for 1211 (December 2011) as well as 0112 (January 2012). I…

I am using FM 11 Adv with OSX Lion It's been a few months since I sat down to tweak my solution and I think I have forgotten something pretty basic... (Yes, I have consulted this forum and several books; to no avail) I have a membership application. There are 2 tables: Members & Dues Members: PK_MemberID MemberLastName Dues Status (Late or Current) Dues: FK_MemberID DonationAmt SummaryDonationAmt (Summary of DonationAmt) I have created a report with a subsummary which 'breaks' on STATUS. I have sorted on STATUS. It works. But, if I bring the SummaryDonationAmt field into the Summary 'band' it seems to just include the r…

Okay, I can't wrap my head around this at all. Please clue me in! The task is to create a simple excel-like table where there will be columns with current month dates (like 1 to 31) and rows with employee names. Inside the cells the shift status is presented, it's either empty (no shift that day), day or night. I can't understand how to program and present this at all! Either with a portal, or with a list view. Would be grateful is somebody could advise on the solution/implementation theory.

FMP databases contain tables ... and each table contains records. But records can differ markedly in size according to the current contents of individual fields ... most notably, text fields and containers. Is there any way to Get Size(Record N)? ... without having to add up the sizes of the individual fields (which can be dozens). Thanks in advance for any assistance.

Hi I have a database which relies on me updating 17 Excel spread sheets every day. At present, I download the files using Internet Explorer and save them to ../Documents/Temp folder. Filemaker then imports everything from script.The url and filenames are always the same. It works fine but I was wondering if there is any way to get filemaker to do the downloading for me as well. Maybe I am asking just a bit too much though?? Chris

Hi Sorry, new here so please forgive me if I am in the wrong area! I have a file which relies totally on externally provided data. I cannot link directly to the data and have to download the individual .xls files manually from the internet and I store them in a child-folder called "Lincs" in the My Documents folder using a direct path name. Problem is, this will be used by other people in other countries and the route to their My Documents folder is differnet to mine. To get round this problem I used the following in my script: Set Error Capture [ On ] Set Variable [ $file; Value:"filewin:" &amp; Get ( DocumentsPath ) &amp; "namefolder" …

dear FileMaker Forum, you can run infinite number of scripts by their names all from inside one FM global field without using the "if" statement!!! i had it working in one of my older solutions just fine!!! but since i am a disabled war vet with disability that puts limits a lengthy concentration / discussions.. i need to be shown, "WHAT TO DO", "NOT TOLD WHAT TO DO". Thats i work. i pretty much not think what to do. i just do it!!! if it doesn't work do it again differently!!! i did have it working.. i was running numerous scripts all from one global field with a very simple AppleScript step. then i complicated it by wanting to run only one of six s…

Hello all, I have a field and I want an auto enter calc that does the following. Look at existing values for all records, find the highest value, and +1 That's it, but I can't seem to get the calc right. Thanks

I have a field with the following date in it. Month/Day/Year I then want to take the Month and Day and add in a different year. (01/25/2000) The problem is when i Select; Left Date_As_Number; 5) I get Day/Month as opposed to Month and Day (25/01) Does anyone have any thoughts why? Thanks in advance, .

I've been pondering the last couple days over how we negotiate the needs of databases and users in the structure of ID numbers — not necessarily primary keys, but not necessarily excluding primary keys, either — and I'm wondering who else thinks about these things and what conclusions they've come to? Other discussions on these forums have hashed over design opinions of primary keys based on what's good for the database — "always use meaningless serial numbers" or "just use universally unique IDs", etc. — but any conversation that begins with what's good for users gets diverted to what's good for databases. UUIDs are great for databases, but they suck for users because th…

anyone know what happened to their blog or is it that they just havent updated it sinCe Last year September? thank u. -i I am trying to figure out what the "999999999999999" is doing here in this partial script please: top = getValue( " & variableName & " ; 1 ); " & variableName & " = middlevalues( " & variableName & " ; 2 ; 999999999999999 )]; OR is it just as a placeholder?

Hi all, I have a 45 phrase/word list. Out of that list I want to create 102 random sets of those phrases/words in a text file. It's sole purpose is to then use that exported data file to create 102 5 x 3 Bingo/Buzzword tickets. I have manged to create a single instance of this in Excel, but thought that FM would make a better job or so I thought. Has anyone performed this before? If so please tell me how you achieved this. Many thanks in advance. Mark

Hello everybody Here is what I try to accomplish. Our service is suppose to create reports. A document with tabels, screenshots, some text and save it within filemaker. But is must be comfortabel like using a word processor. I do not want to use an external programm that creates files, that must be inserted into filemaker afterwards. The solution should lie within filemaker. Now my thought was to use a WYSIWYG editor like http://nicedit.com/ combine it with a webviewer and integrate in filemaker. Or some good plugin. The solution should be portable if possible. Here are my problems. My tests show that when I use the webviewer to display html + bas…

I'm Web publishing a Database of children's games. There are 4 fields; Preparation (sometimes empty) How_to_Play (Always filled) Variations (sometimes empty) Notes (sometimes empty) I am trying to create a nested IF function that only displays the field if it has some text in it. Just displaying one big blob of text listing field after field is obviously easy, but I want to add a header above each field if the field I included. I am getting stuck because the 1st, 3rd and 4th field are all variables. This is as far as I've got; If (Preparation=0;"";"PREPARATION"&¶&How_to_Play) Up until here is fine, but now adding the IF function if Variation…

Hi all Given: * Table "Employees" - Field: EmployeeID (unique) etc. * Table "WorkEntries" - Field: EmployeeID - Field: Date - Field: TimeFrom - Field: TimeTo etc Wanted: * Table "Employees" - Field: NrOfSundaysWorked (calculation) Remarks: * There can be more than 1 work entry per employee and date. I guess this makes the problem non-standard. * The wanted information must be available for all employees concurrently (e.g. in list view) and in real-time (i.e. no manual refresh triggering) Example: Employee ID 3 worked as follows: Sun, Nov 6th 2011, 10:00 - 12:00 Sun, Nov 6th 2011, 14:00 - 18:00 Tue…

Hi, I am looking to create a script which loads a list of facilities (not a problem) out of a facilities table and then loops through them. Again not a problem. My problem, due to being new to filemaker (I am a Mysql man historically), is that while looping through them it needs to: Foreach facility; load all events relating to that facility from the events table (not a problem on a one by one basis for me) and then loop through the events and extract MTBO .. etc statistics and write them off to a statistics table to keep 3 month rolling stats on all facilities. I am having trouble getting my head around the actual embedded loop mechanism. I cant find …

I have a field that houses an email address. Lets say one of the addresses is [email protected]. What I'm looking to do is create a script to convert this email address to: http://www.lovefilemaker.com. Accomplished by auto-entering http://www. and then taking all that is past the "@" sign and adding it to the previous, then pasting all in another field. Sounds simple to script but it's giving me a heck of a time. There has to be an easy solution but I'm not seeing it. Any help?