The Left Brain

Hi, I have a table called "Employee Hours" that has Fields "Weekending"(date) and "employeename"(text). I would like to average out the daily hours so I can take "Employee Hours" and divide by 7 and get a daily average for that week. I want to somehow apply that weekly daily average to a month. Any ideas on how I could proceed with this? An example for October 2011 Bill had 10 hours for weekending 10/1/2011 30 hours for weekending 10/8/2011 15 hours for weekending 10/15/2011 40 hours for week ending 10/29/2011 and 25 hours for week ending 11/5/2011. Each entry is a record in my database. So I want to just find the average daily hours for 10/1/2011 to 10/…

Hi all I have a database prob that i cant get my head around it goes a bit like this...... I want to be able to add differing ammounts to a worksheet (and invoice) dependat on the day that the work is carried out..... if day one is a Fri then X ammount is displayed if day one is a SAt the a differnt x ammount etc etc Any ideas? Marc

I would like to give my users a runtime solution. I would like to have a startup layout that the user puts in their information and then when they want to use my solution the script sends them to paypal and they pay to get an unlock of the software. This would need to happen when they pay. I would like to know if anyone has done this and succeeded. Thanks Dave

Hello, I'm changing the way some stuff works in a large system. About 30 fields that were globals in a file before tables were introduced I am moving to a one record table. Trouble is the said fields are referenced in many calculation fields and numerous scripts. Is there anyway to automate the substitution of the old fields with the new?

I've got about 97,000 records with each record being a unique file name. The file names are everything from "Picture 1.png" to things like "724358428520_108594.TIF". What I need is a script that will look for a block of numbers in each file name, then copy that block of numbers to another field in that record. The blocks of numbers can be anywhere from six to 20 digits. They are not in the same place in every file name. They are always separated from the other components of the file name by a space, dash, or underscore. Some file names have numbers attached to letters in addition to the block of numbers I need (e.g., "coltrane-72dpi-727738.jpg"). Some file names hav…

I really like how FMP automagically displays the server name in the window title... Database (servername) ... and have just worked out a quick and simple way to get it to work for new windows too. Basically, the New Window command appends hyphen-space-number onto the end of the window name. The algorithm does some clever checking for "previous" windows and doesn't just keep incrementing the number. So, to get window named "Contacts (servername)" follow these steps: (First check whether a window called "Contacts" already exists: is it does then either select it and stop, or close it.) Create a new window called "Contacts - 2" Set the windo…

Hi guys, I've been searching through the forums here to get some insight into a problem I've been having, but I can't quite find enough info to figure it out. I have a FileMaker solution that tracks time spent on a job. Each job can have multiple time entries logged for it, and since a few people might be working on the same job, those time entries can overlap. For each job, I want to calculate the net amount of time that was spent. In other words, I want to ignore any time overlaps and calculate the total time spent in general, not just total up each separate time entry. Visualized, my data might look like this: 9 ------- 10 9 ------- 10 …

I need to duplicate a number of records. I can create a found set of those reocrds with a Find, but how would I duplicate all of them at once?

Following up on recent FM Forum advice, I have been trying to replace as much of my scripting of record validation using FM's native validation. I wish I had done this much earlier, but I have come across this particularly knotty issue: (1) In my database, users with the right privileges can create accounts for others and, during the process of creating an account, replace the script-generated account name with one of their own choosing. At the end of the process, an email is sent to the new user containing, among other things, the account name. If the send email step generates an error, I don't want to commit the new account record. The account should remain uncrea…

I am currently reading "Star Schema: The Complete Reference" by Adamson. I am finding many of the concepts extremely helpful, and I do not seem to find many of these concepts discussed in the FileMaker community. Maybe I travel in the wrong circles; maybe they really are not being discussed much. http://www.amazon.com/dp/0071744320/ Concepts include data warehouses; operational vs analytical database; fact tables vs dimension tables; designing for dimension table conformance; ETL; drilling across processes as well as drilling down and rolling up; data warehouses as places where non-3NF data are acceptable.

Got it working. As usual it was something unrelated to the topic title. I had the wrong window title so my logic would not flow.... I sure wish I knew how to delete a posting... Any ideas on how to do that?

A while ago I had to deal with a problem of frequent interruption (see http://fmforums.com/forum/topic/79247-unresolved-interruptions/page__fromsearch__1), which my IT person finally solved. (I still don't have a description from him of his solution that I can share on the Forum, though I gather it was fairly server-specific.) I have discovered that interruptions can still happen at inopportune times for unavoidable reasons--for example, the user's computer goes to sleep while a script is paused and a record is not completely entered and validated. It appears that the record remains in the database in incomplete form. This can cause problems going forward. …

Hello everyone; I must say that i find learning filemaker documentation , books,et to be quite repetitive. I have so much knowledge in other programs, etc that obviously took time to learn, but i was wondering if any experts could tell me if i am incorrect or on the right track. I have too many fmp books now that got me to at least understand basic stuff in filemaker pro. OK i understand there may be 20 different ways to do 1 thing but really? missing manual, filemaker desktop reference, fmp10 in depth. on & on. They all have basically the same information. Can anyone tell me different that basically to master fmp you have to take the bas…

I need help with a complex pay roll system I am working on. Sorry for the long post: I'll describe the business, my solution implementation, and my challenge. I have a table "StaffBookings" where each record is the amount of time a person works, and their pay rate for the period. It has staffid, start time, end time, hourly rate. (Work periods will not cross midnight.) The complexity is that on a given day a staff person may have multiple StaffBookings records, with different pay rates. There is technically no limit to the number of StaffBookings records per day for a person. The business rules are: 1) The full pay period for the day is the minimum start…

Hey guys I came back from devcon this year looking to try my hand at some virtual lists to possible make our solution a little more elegant. What I want What I'm trying to do is populate a single portal with a client's activity (that comes from multiple tables) and ultimately make the portal records "click through" so I can then jump to a particular record . I thought I could possibly do this with virtual lists, but now I'm not so sure it's a doable solution. Currently on the client screen we have a bunch of portals showing their activity in each table, which is really clunky and an eyesore to be honest. What I did I have a Client table, and initially …

Hi to All, I am facing problem in 1 simple thing but difficult for me as i am unable to sort out. My problem is that i have 1 field name is facilty in table ece.facilty has multiple values like a,b,c,d,e,a,b,f,g,a,b,f,g,...means multiple A values,b values and so on. Now i have impleemnt such type like if i select A from global field then in portal it just show only 1 rerord of A value if i select "all" facilty then condition it just show A,B,C,D all values only once in portal.no duplicate value of facilty. In DB could be multiple A value multiple B value and so on....but in portal it just show only one time per value. Thanks nee…

I was wondering if there were any advantages to building an invoicing system using separate tables for Purchases Orders and Invoices vs just one table for all Transactions... My thought process was to create only one table called Transactions with a TransactionType field to differentiate between an Income Transaction and an Expense Transaction. This way, the SUM of all or a found set of Transactions is essentially the Balance, showing Profit or Loss for the found set (or all). Of course doing this creates the need to show Expense Transactions as negative totals and Income Transactions as positive totals (much like a bank account ledger). This also allows me to…

I have added Ical event creation to my solution using some of Starks sample code and have added some additional trial and error applescript. What I have come up with works great. The one thing I lack is the ability to overwrite an existing event if I need to update information. When I update in FMP and push the info I create duplicate events. I have read a couple of threads on something similar but have yet to find a solution. I have tried having FM create a "UID" but it doesn't seem to fly with Ical. The one post I recall is Fenton Jones lending a hand. I just can't seem to grasp how I should obtain and use Ical's UID data. Can anyone simplify it for me. …

I currently have a dbase of equipment that I use to keep track of status, documentation and creating checkout forms. For each major piece of equipment (Camera, Tripod, etcâ�¦) I have built packages that include all the accessories needed to use that piece of equipment. I then print these checkout forms and fill them in when someone needs something. The limitation of this system that I would like to fix are as follows: - Avoid using several forms when someone is checking out several packages - Add equipment that is available but no included in any packages (cables, extra batteries, etcâ�¦.) - Assign the equipment being checked out to a person and have a ch…

Hi I've just done a stupid thing. I had 120,000 records, some of which had an entry in Address 2 but not in Address 1, and it annoyed me. So, to shunt the address upwards, I did a search for empty Address 1, then ran a script which copied Address 2 into Address 1, when what I should have done is CUT from 2 to 1. The result is that somewhere among those 120,000 records I have about 55,000 records which have the same text in Address 1 and Address 2, and since I didn't notice till some time later, I don't know how to identify the 55,000 and delete the text in 2. I tried creating a calculation field which subtracts 2 from 1, and hoped that this would result in a uni…

Trying to make sure to put my questions in the right section. Sorry if I guessed wrong. I fixed one problem by changing a layout to be based on a 'Jobs' table, to have it display correctly. Now, each line in that table (representing a unique record) has a button that I'd like to use to go to a detailed layout of the individual record from the 'Customer' table. So, I guess I need to get the customer_ID value from the line item of the job displayed and when I switch over to the detailed Customer view use that value to see that specific customer. If both layouts are associated with the same table, the button seems to work seamlessly, with the script doing not …

Users are uploading files using Custom Web Publishing via PHP to Filemaker using an Enterprise license for SuperContainer. We're all set on the actual uploading bit, but we want to manipulate the files some. Ideally, we want to be able to pull out each file from Filemaker as a single page pdf of "e-mailable" size (<400K). We have three goals: -Limit to single page (the lowest priority) -Convert image formats to pdfs (we could limit the uploadable file type, but some users aren't tech savvy enough to convert a jpg to a pdf) -Resize pdfs so each page is no larger than 400K (some users convert jpgs to pdfs before uploading and they come out huge) What…

Let me say that this forum has been more than helpful. Thank you so much. OK, current issue I am working on... I have a "Daily Report" of jobs to be done today. My button to get to this Layout has the following script. (It won't let me cut and paste, so I'll paraphrase my code) Enter Browse Mode Go to Layout (Daily Report) Perform Find (Date [//} (Which brings up a Found Set for the current date) Sort Records (by Start Time) Scroll Window (Home) This works fine and dandy... TODAY. But, let's say I want to pull up this report for Yesterday, or Tomorrow, or The 4th of July? My thoughts are to put a field in the Header for Date with a pull-…

I have FM 11 Adv. Is there a function that will filter a text field for a specified word? For example, I have a text field and want to filter it for the word "Jones". I want to do this: IF [FilterInclude(FieldName; "Jones")] ... do some stuff END IF It seems that the FM Filter function does filtering to exclude all but the specified values. I want to 'detect' if the user typed "Jones" into FieldName in any word order. That is, it will detect the first, second third or nth word occurrence of "Jones".

I've made a simple database to create inventory item records for import into our accounting system. The database calculates various margins and sales prices for some currency exchange rates. I have a couple of numeric fields that need to be output with 2 decimal places to a TAB delimeted file. I have created a layout with all required fields and have formatted the numeric fields with 2 decimal places then use a script to go to that layout, create the file then export the items. Trouble is the numeric values have upto 6 decimal places which the accounting package doesn't like. I understood that FMP formatted the numeric field's output based on the current layout, this…

I have Customer table with a field for "frequency", number format with "12" or "6" or "3" etc. for how often they want me to come back. And, I have a Job table with a "date" field of every job. I want to pull up a list of customers who the last job I did was over a year ago and they want me to call them every 12 months, along with customers who I worked on 6 months ago and they want me back every 6 months, etc. (then, I'll put them into a form letter to print and mail). I am having trouble going through the "perform find" step of making a script. First of all, I am thinking logically, I need to "omit" any customer who has a job that is less than the …

This is a 'big' question so I am not expecting full answers - but I would appreciate some pointers to where I can get more info; I have a shared DB consisting of Job Records. Each Job has a status (ie: 'in progress', 'completed', 'invoiced'). The status of each record is updated individually, that is, I open the individual record and stamp it with it's new status. However, for the final status ('invoiced') I want to be able to open a list of all 'completed' jobs and stamp them all as 'invoiced' simultaneously. The problem I anticipate is that in the time between when I create this list and the moment that I stamp it's records as 'invoiced' another user on the system …

I am inputting field data using globals on an input layout. Five are working fine, one is not. They are all copies of the original that works. The data is created in the global layout and then copies to a new record using: [set Field [new::record[global::record]]. On the one with problems, script debug is showing an 111 error, "field repetition is invalid" and will not copy the data to the final record. The field repetition is set at 1, the default. I have tried to compare and see where the difference is, but can't locate it. any help is appreciated,

Hi Somewhile back I was working on a generic script to strip formatting from fields and wanted to be able to deploy it in any db on any layout without making any changes to the routine. I got it to the point where it would work for any layout, with any number of fields, even repeating fields. But I never cracked the logic that would detect portals and allow me to loop through fields in portals to "TextFormatRemove" on all of them. Is there some function I have missed? or some logic? I guess what I am wanting to ask, indirectly, is are there any fields from related records on this layout and, if so, what portalrow# are you (if any). Clearly the problem is so…

I'm a chorus teacher and I'm looking for a way to check out sheet music to my students. I may have 150 copies of a piece of music, all with the same barcode. How can I modify the lending library template to allow me to check out 1 copy to each student, and have the total number of copies available in the database decrease each time? Thanks.

I have a field for which I have 30 different (and distinct) value lists. I would like to have the drop-down menu for that field to display the value list I need depending on the value of another field. So, for example, if the value of field A is "ABC", then I only want the value list associated with ABC to be in the drop-down menu for field B. If the value of field A is "DEF", then I only want the value list associated with DEF to be in the drop-down menu for field B, etc., down the line for all 30 possible values of field A. Can I do this in FMP? FYI, I'm on a iMac G5 using 10.0v3, so please let me know if this is possible using this version of FMP... th…

I think the answer is probably "no", but I thought I would ask. The application I have in mind would mainly need to display the pilcrow for returns and the small right arrow for tabs. It would be a special-purpose, display-only field to show "literal text". IOW, the field would not need to print. I suppose parsing and replacing individual characters with WingDing symbols would work. But is there something easier? A setting or a special font? Thanks for any advice.

My current company has been using GoldMine for their CRM for a while. They asked me to create a separate "database" strictly for client-side relations, as opposed to customer-side (our clients have the products/services; we sell those to the customers.) Unfortunately, the term "database" in GoldMine is loose at best, as all of the separate "databases" still tie into one central UI. So if you delete a field from one "database", GoldMine deletes it from all the databases that exist. What this does is make it virtually impossible to make needed changes to make my "database" work properly, given the constraints of the main "database." Also, despite documentation to the c…

Boy, I thought this would be easy but the obvious is missing me. I have a two-table database of club members with addresses, member number personal info etc. in the 1st table and the 2nd table has their member number, names, and a field to fill in the years that they've paid. Back in Table 1 I wanted to have a simple list with their names and various years with an "X" showing that they have been members that year. I created a new calc field with the parameter If [Year] = 2011 ; "X" ; "" I created copies of this for 2010, 2009, etc. The problem is I can only get one "X" per member (not all the years that they've been a member get an "X") and not all …

I'm trying to create a script to automatically save and import a .csv file containing weekly currency exchange rates. The .csv file is available on the web. The importing should be pretty easy, but how to automatically open the link and save the .csv file? Any help would be really appreciated!

I'm trying to get the portal at the lower half of the display to sort on whatever the content of the "title" box above shows. Ideally, I'd love the focus to be in the center of the portal so I can 'see' above and below the closest line, but I'll settle for the top with stuff below it. But right now I can't get that portal box to do anything except what you see. Even the [view] button I can't get to do anything. So, if I'm in browse view, and enter "RAMw" in the item box to search on, the portal would sort to the R's, at least, and if more applicable as the picture shows, it would put the row with 'RAMWorks' in the center as it is now. This is intended to …

So in my database of 13,000 address, I want to enter a start address and a time (say 1 hour) and find all records whose address is within 1 hour drive time of the starting address. I know I'll have to hit a web service, via the Viewer, or export to something. I've played around a little with Google Maps, though not gotten an API yet. And Google Fusion tables, but haven't been able to get driving distances out of them.

Hi I have a basic survey with questions Some are yes/ no Some are multi choice One of the final questions is only applicable if the answer to an earlier question is 'yes' How can you set the later question so that it is visible only if the earlier question was answered in the affirmative ------------------ The survey is utilized by an operator ringing the person to be surveyed and asking the questions and entering the answers on the screen Thank you for any advice Bob M

I am on a project that requires group creation. Before I begin has anyone seen a nice sample of this. Many contacts to many groups.

Has anyone figured out a way to get all the names of a table using Filemaker functions without putting them all on a layout?

I am not sure what to call this kind of comparison so I have had a hard time searching for any information. I have two list that are used to manage record access security. One list is generated for extended privileges and the other is from field data. List One: London New York List Two: New York Toronto London I am trying to figure out a boolean calculation to see if ANY of the values in list one match ANY of the values in list two. Pattern count will only work if the lists are in the correct order so I think I need to figure out a recursive calculation to compare each value individually from list one against list two.

I'd like to pass a parameter to a custom function and return the local value for that parameter. I know that's a clunky way of saying what I mean. I want to code some values in a custom function return those values based on the parameter passed. I want Eval ( "dog" ) to return "bark". I tried this custom function: Eval ( parameter ) Let( [ dog = "bark" ; cat = "meow" ; mouse = "squeak" ]; Evaluate ( parameter ) ) But that didn't work. I could use a Case () function but I expecting a lot of values in my list. Thanks for any tips.

Hi there, I have some problems to put the date in English when it comes from a script. The only parameters I can modify are : - Either it takes the language of the OS (which is in French here) - Either it takes the language used when you created the DB (which is German ) ) How can I force it to be in English for all users ? Thanks :)

Hi Im struggling to show a summarised list of a particular field of a child in the parent. eg parent record relates to a list of rooms (child). Each room is in a building and Id like to see a list of buildings in the parent. Child records room1 is in building A room 2 is in building A room 3 is in building B room 4 is in building B room 5 is in building A In the parent I'd like to see a field with just "A¶B" It also needs to be indexed so I can use it in a relationship. thanks

I am trying to figure out how to create a calculation, script, or other method to calculate the din setting for ski bindings... There are four factors that need to be taken into account: height, weight, skier type and boot sole lenght. Its kind of an " if x is this and y is that and z is 5 then" kind of problem... Any ideas? You help and thoughts are greatly appreciated.

Hello, I never paid attention to this CheckBox. ( script action : Send Mail ) Now that I discovered and tested, I do not understand why FileMaker does not give us this option natively in ValuesLists ? Natively, when you check this box, you get the list of email address (or ... other !) in the mail software... I added a calculation to show. This file "FoundSet_test.fp7.zip" is just to demonstrate that the CheckBox "collect foundSet" is in FileMaker Technically, I do not understand why FileMaker does not offer this feature, Function or CheckBox from the moment that has long existed. (this option is ok in FM6....) It would be sufficient to …

Hi folks, I have quite a weird problem.... I have to search someone among a list of person.... this looks like this : This works fine for every one, except for the name "Frank Pintér"... The research is based on this layout : I do the name research (upon the "Name Concatenated" field) in every possible way (Last name first, then first name, first name first, then last name, upper case, lower case, considering the accents etc...) The thing is, when I manually research "Frank Pintér" using the search mode (Ctrl + F), it works... Here is the script i use : Code Here This lookds weird and I tried my best to make you under…

Hi everyone! Okay, here's the FMP challenge that I'm trying to work through: - We collect 57 fields' worth of information from every user who registers on our website. - That data is stored in our MySQL database in an EAV (Entity-Attribute-Value) table. (If you're not familiar with the format, it means there is a separate row for each piece of information (57 fields x 2500 users and counting) and the table has only three columns: User ID, Field ID, Value.) This table is called profile_values. - I currently have profile_vales established as an External Data Source in FMP, and I can create relationships with it, interact with it, and update it all in real tim…

Hi, I've been looking for a way to check (via a calculation) whether a text string contains any non-latin characters. Specifically I'm interested in checking whether text string contains characters only between code(902)-HEX386 AND code(974)-HEX3CE of the Unicode set (greek language), or others too. The string is not supposed to be large (<100 chars) in length so recursion limits will not be an issue I think. I only want to have a "switch" turned to (1) when mixed characters are typed (Greek + others). Can anyone help with building a function for this scope? (I'm really bad at this)

Is there a way to allow a user to define a filepath through a file-choosing dialog and save that path? I want to allow users to pick a folder that FMP will then do multiple photo imports from on a timer script. I can let them define their own filepath by hand, typing into a field, but incorrect filepath issues are hard for a layperson to diagnose and want to make it as simple as possible. Thanks, David

How can I calculate elapsed time for time sheet records? I have a field for start time and end time both setup as time fields.

does anyone know if it is possible to dial a number using a bluetooth connected cell phone? Would love to dial from my contacts database.

Does anyone have a suggestion concerning how I can calculate the date of the 3rd Friday for a month. Thank you.

Hi guys. Suppose I have a field called Fruits and ten records on my database like this: 1 Orange 2 Orange 3 Apple 4 5 Orange 6 Grape 7 Apple 8 9 Strawberry 10 Grape I'm looking for a summary field that would return unique instances of Fruits which in the example above would be 4. I was thinking of creating two fields. A calculation field that would return zero, if the Fruit field is empty, one for the first instance of each fruit and zero for the remaining fields. Then I could use a summary field Total of or Count of to get the result I want. Any suggestions? Thanks in advance.

creating a small solution to open various video files (non Quicktime compatable) with VLC. With a normal (dos) command line: vlc.exe filename opens the file automatically in vlc. Using the Open URL in a script, I can get it to open VLC (vlc.exe) but not the file (by itself (like a text file), or using the vlc.exe filename) Any thoughts?

Hello I build a browser like navigation using the snapshot feature. Works really nice. But now I've found some layouts within my file where I cannot make a snapshot. I cannot figure out why. I can go "File>Save/Send Record as>Snapshotlink" and click on it. But nothing happens. Other layouts however work just fine. I hope that my databsae is not corrupt. Any ideas ? Robert

[color:blue]I need some serious help with this! : I have a rather complex database solution that I want to clone, copy then install onto a laptop that will be used remotely without internet access. The user of the laptop will read, modify and add new records. The user will not make any changes to the structure of the data. The user will come back into our office once a week or so and hook into our network at which point we can make the transfer. How in the world do I get the two databases to synch / merge the changes. The original database it is copied from will also be changed. Primarily it is three files that will be modified... or um, thre…

A client stores pdfs in the Quote table. The pdfs are received as e-mails. Sometimes the pdfs are received with multiple quotes in one document. The client then has to open them and print to pdf for each page. Is there a way to automate this, Filemaker does the splitting? Applescript solutions welcome.

Hi guys I have a problem which I am sure is easy to solve when you know how! I have three Date Fields named: LastAppointment, RebookedSince, and Cancelled My calculation field needs to display the name of the field with the greatest date in. So for example if (dates displayed DD/MM/YYYY): LastAppointment = 01/01/2011 RebookedSince = 02/01/2011 Cancelled = 03/01/2010 My calculation field would need to display "Cancelled" as that is the field with the greatest date. It also needs to ignore any empty fields Hopefully someone can head me in the right direction here, Many thanks!

Hi all, again I am so sorry if the answer to this is right in-front of my face. I have a simple sales database, each record has date, year, item number, quantity, price, cost, dept and category and maybe a few other fields. I have several reports that work well on this data base but there is one report that I would really like to make. I would like to be able to do is summarize any day and compare that number to the same day the previous year. I currently have reports and summarys that work for any given time period but I can not figure out how to show another summary for last year on the same screen or do calculations based on the summarized day, like the difference …

I have this script which currently performs finds and downloads an excel report for the user. My question is in the Perform find can I send it a variable as the user now wants to select specific Vendors. Or is there another way of doing this. Allow User Abort [ Off ] Set Error Capture [ On ] Freeze Window If [ Purchase Orders::PO_ExcelCount = "" ] Set Field [ Purchase Orders::PO_ExcelCount; Purchase Orders::PO_ExcelCount + 1 ] End If If [ Get ( ScriptParameter ) = "Exit Open Production" ] Set Variable [ $desktop; Value:"filemac:" & Get ( DesktopPath ) & "PO Exit Date Report" & Purchase Orders::PO_ExcelCount & ".xls" ] Perform Find [ Specif…

Dear All, I ma facing very miscellaneous problem in my file.before installing this file onto client's FM server its size was as little as should be.but after installing it on server when i again download it from server and again use it for modifications in my file i saw its showing huge amount approx. 271.9 MB.however i tried lots of solutions to overcome this like delete all records,delete all relationships from relationship graphs still not sorted out this. Please tell me the all the reasons who can increase your space in file specially that reason which drastically increases the space in your file like happens with my file. …

Hello to All, Have anyone has idea of implementing signature verification and thumb impression verification...I have to do three things into my application: 1.Storing data into smart card . 2. Signature verification of customer. 3.Thumb impression verification. ....if any1 has any document,file, article related to this i will very thankful. Thanks in advance

I need to open remote file via a script and when it occurred, i see a blank page in FP which says Open Database. In order to open the intended database, i have to go to the "windows" menu and choose item two which is the database i need to open. Number one in the "Windows" is "Remote". What do i need to do to make database open without choosing it later. Thank you. Al

I'm trying to use filemaker to auto generate some php programs for me on the fly. The end result is the php code being dumped into a global field, and exporting the field contents. Unfortunately for me, the text output is unicode, and that doesn't jive with my webserver. If I manually change the text formatting from unicode to ansi the resulting .php file works fine. I'm wondering if there is a workaround so I don't have to change this manually. I appreciate your wisdom. Curt

I'm running some tests to see what techniques work for best performance over a WAN. I'm running into a problem with Filemaker's cache. Is there a way to clear the Filemaker's cache? Refresh Window[Flush cached join results] only gets me halfway there...clearing relationships, but not local data. Flush Cache to Disk[] doesn't have any effect at all. Right now, I'm exiting the application every time I run test which is really annoying.

Is there a way to disable the window exit (upper right corner of window frame "X" on windows or the left red button on a mac) function. I would like a clean bar on the top of the window (with text is ok) and force the user to use the buttons that are built into the Filemaker database as opposed to just killing the window.

senerio, trying to count the number of days it takes to move product from one dept. to the next but not including Sat and Sun (here is the kicker)and every other Friday. I have date stamps on the transactions to and from and a calculation that gives me the cycle time, but that includes our days off. How do I get a realistic cycle time?

I am trying to make an if statement based on 3 fields being the same between the two tables. If all the criteria matches then information from KPMONTH_ID Table B is transferred to KFMONTH_ID Table A but it's not working. Any thoughts? If ( TableA_Month = TableB::TB_Month and TACode = TableB::TBCode and TableA_Year = TableB::TB_Year; TableB::KFMonth_ID ; "Find Month ID") Basically I am trying to automate transferring data from an excel file into my data base. I have my Months as a separate table from the days as they address different information. I need to track Months separate from days. Based on this I created two tables. Maybe this is over kill and Days and M…

About 5 years ago I wrote a desktop application that we use to do invoicing and maintain customer information. The program is written in Visual Foxpro. Unfortunately, Visual Foxpro doesn't have a web option, so we wrote a program in Alpha Five that handles the web part of this application. Alpha Five provides the back database for online ordering and customer maintenance. The problem with this app is that we had to create a sync system that would keep the data synchronized between the desktop Visual Foxpro tables and the web Alpha Five tables. What I would like to do is write a solution in Filemaker that would allow us to do both. Access the files from…

Has anyone successfully installed FileMaker (any version) within Ceedo (www.ceedo.com)? Ceedo is an app virtualization framework that allows you to make many applications portable. It's kind of like U3 technology except that you can try to virtualize any app install onto a USB device for portability and not just apps made to be portable. Ceedo intercepts reg writes and keeps them in their own hive which is integrated into the main User and LocalMachine hives when the Ceedo framework is running. Anyway.... The main FM install goes fine in Ceedo but when I run FM it never displays the interface. I can see the FileMaker Pro.exe thread running but nada on scree…

Hi, I'm working with filemaker pro and I would like to make a button that does a sendmail (on instant web publishing) , but I need some way to do and export to excel. Can I make a script on filemaker pro , that I can call from a web browser that sends mail with an exported excel?

Looking for the best approach. I have a field 'password' that on record creation gets populated with a random string. The field validation set to unique. So, I would like the password filed to auto populate with a unique number. Can I create a looping calculations (on its own, or via custom function ) that will keep trying until it is unique. OR, do you think it has to been done with a script.

I am trying to create a grocery style checkout program. I need some help in laying out the ground work and implementation. Goals: 1. Allow user to scan barcode or manually enter item codes. 2. Computer must determine prices based on rules a. quantity discount for item b. discount for bundled items c. flat percent discount based on customer d. flat percent discount based on total of sale The difficult part I am having is implementing the rules 1. How do I look up the correct charging price based on items sales rules. 2. How do I store these rules and prices so they can be looked up during the sale? I am…

Is there a way for a script using Copy All Records[] to reliably identify all of the columns that are copied from an arbitrary layout? Fields <> onto the layout are included in the copied data but are as yet a mystery. I want to provide for my users the Copy All Records menu item/Script Step with a few improvements. To make it easier to use without having to hit Alt/Option, I have added a menu item "Copy All Records" to the Edit menu. My implementation has the following features. (1) No global fields are copied (and no containers) (2) I can control via a script to omit fields named in a certain way (i.e. fields I use for user interface feat…

I would like a calc or CF to break a list into consecutive groupings. i.e. 001, 002, 003, 004, 005, 006, 007, 008, 009, 012, 013, 014, 015, 018, 019, 020, 021, 022, 027, 028, 029, 030 Desired result: 1...9, 12...15, 18...22, 27...30 Note the original list is separated by returns not commas.

Hi all. I have a table where filenames of photos are stored. The filenames go by the following pattern: MP_Vol##_p###(###-###).jpg This is because they are scans of an old inventory book, where the # in the parentheses represent the inventory serial numbers included in a page(p###) of a certain Volume(Vol###). Once the filename is stored in the table, I use calculation fields to "capture" separately the range of inventory items of each page. In order to have a quickfind (search-as-you-type) functionality, I have included a global FILTER field (placed in the header), where the user can either enter a single number or a range. Using a OnModify scri…

Hi all: For most of my FM experience, I've been using fp5 technology. I recently got FM 11 advanced and I am struggling to catch up with some of the enhacements since my previous version, FM6. I wanted to take advantage of the "new" feature of a layout where you can uncheck the "save record changes automatically." What I found is that I can tab to the fields all I want, but as soon as I click in an empty space or try to change the record, it will prompt me to save changes. I read the help file and this is indeed how this is supposed to work. In my solution, I have an edit button on the main layout. When clicked it will go to another layout with the fields…

Hello everybody I'd like to develop a workflow control. I am tired of coding each possible way of what the next workflow-step might be. I thought I base the workflow on the records overall status code. A overall status code is nothing else then a combination of status fields. Each field holds a status, like "in process" or "open" or whatever. Depending on what the overall status is, I can choose, lets say from a dropdownfield, what the next possible action should be. An action will alter a status field and therefore the overall status leading to a new overall satus code. Each action is tied to a script. All of the overall status codes will be stored in…

I want to remove all duplicates from a portal view. Any ideas? What I have is many stores grouped together with a multistore ID. I only want one of those stores to show up for each group of stores. so I only want unique values of multistore ID's

Hi I'm trying to extract text from field using this calculation. Let ( [ start = Position ( text ; prefix ; 1 ; 1 ) + Length ( prefix ) ; end = Position ( text ; suffix ; start ; 1 ) ] ; Middle ( text ; start ; end - start ) ) The problem is that I don't have a unique suffix string. The prefix string is unique and I'd like Filemaker to extract the text between the prefix and the first occurrence of the suffix that comes after the prefix. Did that make any sense? /Johan

Hi there I'm getting mad trying to do something (which would be very very easy in Java or PHP) in FileMaker. Here is the thing : I have a list of modules I get from a checkbox. This looks like this : AA BG BR SR1 SR2 ... And I would like to store each module in a tab (a variable with repetition in fact). If all module were written with 2 letters, that would be easier... but it's not the case ;o) Set Variable [$mod_list; Value:Global::G_Export_Module_List] Set Variable [$mod_list_tab; Value:""] Set Variable [$repet; Value:1] Loop //It's here I need your help ;-) End Loop Thank you in advance for your help …

Hi, I am using EZXSLT to export to a word document. It works great but for each new template I have to hard program the export order. Is there a way to set the export order at runtime based on mappings stored in a table related to the template? Thanks

Okay, I may be silly by placing this question in this forum but I am certainly having difficulty figuring this out. Is there a script to compare one text with another and give a degree of match. So a complete match would return 100% but if only two of three words in the one field are seen in the other field, 66% will be returned? What I am trying to do is evaluate a field that a user enters free text with a keywords list and then enable the user to use an "Auto Generate Keywords) based on their text to create an index table of matching fields. I hope this makes sense. Thanks

Filemaker is supposed to handle null $$ vars by not storing them at all, but if you define a $$var and then clear it in the Data Viewer, it still persists! Can't think of a possible use for this, but I thought it was interesting.

A client, given a birthdate, wants to know the age of contacts in Year, Months, and Days. I built a function that I thought covered all the bases, but in testing it I kept getting results I didn't expect. I think the problem is how an age in how I'm defining YMD. I would simply say that a person is x number of years for the years completed, y number of months for the months completed and z number of days. How would you define the age of someone in YMD? Please do a sanity check for me: Today is 3/1/2010. Joe is born on 12/31/85. How old is he? Jill is born on 12/30/85. How old is she? Express ages in Year, Months, and Days.

I have been getting really uptight with a problem that makes my life a little inconvenient. I use a lot of container fields with that 30 sec. recorded audio. When they are recorded on my windows machines, they play on any system. However, I guess mac records it in some kind of mac compression. Anything I record on my macs, can't be played on my windows systems. Has anyone found a way to fix this? Is there some kind of codec I can add to my windows systems that will allow me to play them?

I have a field that contains values separated by semi-colons. I need to take each of those values and turn them into their own records, maintaining the data from the other fields in the original record. For Instance... I have the following fields: ProductNumber Code Keywords Sample values would be... 5522 IM Boards; Dry Erase; 3M And I want it broken into the following: 5522 IM Boards 5522 IM Dry Erase 5522 IM 3M I'm trying to create some form of looping script that will do this to a table of 50,000 records. : Help!

This is probably simple, but I'm a bit rusty so if you can help, I would love it! I'm trying to find the top 10 scores for a field. Then I need to average these top 10 scores and put it into another calculation. There are a few calculations I may develop based on similar things. (ie top 5 scores if there are less than 10 records).

Hi everyone, I'm a little lost on even how to begin doing this. here is what I need to do: - Need to add to a table (using a script) a 'block' of serial numbers. - Serial numbers follow a standard convention, only the last two characters change (i.e.: ABC123456, ABC123457, ABC123458 or ABC1234A1, ABC1234A2, etc.) Also on the alphas, it ends at 9 and restarts, eg.: ABC1234A9, next up would be ABC1234B1, etc.) - I don't mind breaking up entering straight numbers (at the end) vs alphanumerics at the end. - All must end at the final position. For example, Alphanumerics end at "Z9", numerics end at "99". So...ABC123401 through ABC123499 Alphanumerics: …

Lets say i have two fields. Each field has the same text in most cases. Is there a way to have the text that does not match the other field appear in a different format ? (color / bold / etc)

Im sorry if Im posting this in the wrong place, but here goes. I have a potential client in a French speaking country. They were requesting both english and french be displayed on each field and that the drop down menus hae both englaish and french choices. Is there a way to have more then one language loaded for the FMP client? and I am assuming that I would need to develop that database on a french only version of FM11. Any input would be greatly appreciated. Thanks.

Hello All: This is a puzzle caused by the way FMP internally formats dates. If you're at all conversant with the issue, you know that FMP's default format for all dates is based on the date format on the machine where the file in question was first created. For those of us in the US, that means that for almost all of our files, FMP is internally formatting the dates as mm/dd/yyyy. Now, FMP will display the dates in whatever the current system format is, so for the most part you never have to worry about the internal formatting. And the actual date value is based on the number of days since 1 January, Year 1 CE (or 1/1/0001). Now that we have the introduct…

Hello everyone, I have a calculation field called "Total Payment" that I want to do two things: 1) Sum all the values of a certain field 2) Take that result and, if the result is less than 40, override the calculation and set the "Total Payment" field to 40. Is there a way to do this in the calculation field without having to write a script? Here is what I have as a calculation for the TotalPayable field. I don't know how to "attach" the two parts of the calculation: Sum(table:field); Case(TotalPayable < 40; “40”) Do I need to use more parentheses? Brackets? What do I use instead of the semicolon? Thank you!

I need to determine the types of pic files a user is importing into our app. We only allow "Insert Picture(Reference)" into our DB because we don't want to jam up the DB. The reason being is that some people have been importing "peg", "PDF" files instead of valid "jpg or jpeg" files. When our china users try to access the style on their windows machine, because we do a refresh of all pics, we get the dreaded white screen of app freeze which needless to say frustrates them. The current script statements that the other "developer" put in doesn't work because it references an empty container field."see code...' I need to know this at the Insert Picture script so that…

OK here is the challenge, should you choose to accept it. Putt a text block on a layout, with text in it (say, "Crocodile Dundee"). Define a tooltip onto the text block: I want the text to appear in the tooltip. Make the text block into a button: I want the text to appear as the script parameter. Both the tooltip and script parameters have to be defined so that they automatically change when the text is changed.

Here's a new puzzler.... Build a Rot13() custom function. It should take a string and rotate each letter 13 places in the alphabet. Wiki Rot13 for more details. The function should only affect the letters on a string: A-Z and a-z. If you don't have Advanced, do the above, but for single characters and wrap it in a Looping script. Bonus points if you can do a string without a recursive custom function or looping. (I couldn't figure out how.) Bonus points if you build it so any integer can be entered as a parameter in the function, creating a general Caesar cipher. To keep it interesting, don't refer to any Filemaker resources outside of th…

Here's the challenge... Write a script that populate a field (TABLE::Result) with the numbers from 1 to 100 with these conditions: -for multiples of 3 print “Fizz” instead of the number -for multiples of 5 print “Buzz” instead of the number -for multiples of 3 and 5 print “FizzBuzz” instead of the number Go!

Hi guys I have a field which for example look like this: 1.22 45.1 43.45 I need to extract what's in front of the "." to one calc field and whts behind to another calc field for sorting reasons. Does anybody have an idea for this calculation? Thanks in advance... Kasper

Hi Everyone I am in need of a script that I just can't figure out. I have a field1 with this jim steve mac sue In field2 I need the output to be jim jim steve jim mac jim sue jim steve mac jim steve sue jim mac sue Jim steve mac sue steve steve mac steve sue steve mac sue mac mac sue sue I know it's done in loops but the logic escapes me. Thanks for all your help Stuj