The Left Brain

Hi All, Been looking at the blog from clickworks and think it is a great way to generate a PDF. The only thing is my attempt was to do the following: CLIENT: Click button -> Creates a record in a blank table (triggers client robot waiting) then return to original layout ROBOT -> Complete action as script has been triggered with the record on load and then will tidy up and delete all records and wait again until another record is created Sounds simple but there are times when he script is triggered and it shouldn't be. It isn't a flawless effort. I know its a rough plan but could anyone give me any guidance on this? Something else I could try or use script para…

I manage a fleet of workstations that are all configured to sync time with the NTP server 0.pool.ntp.org. While there are some Windows workstations in the mix, there are many Macs running OS X Mavericks 10.9.1, and for now I'd like to just focus on the Macs, since that's what my most vocal users are using. Even though I have everything set correctly in System Preferences, (i.e. the 'Set date and time automatically:' checkbox is set, etc.), the computers tend to drift over time. My own workstation was off by 2 minutes and 1 second today, for instance. I checked Activity Monitor and 'ntpd' was running with no apparent problems. BUT, the only way my time would update…

I thought this issues was going to be simple, but it turns out woking with time is something I've not been able to wrap my head around. Can someone please tell me what is wrong with doing this. If ( Get ( CurrentTime ) > "12:00:00 AM"; If ( Get ( CurrentTime ) < "03:00:00 AM" ; "TRUE" ; "FALSE" ) ; "FALSE" ) What I'm trying to do is find out if the the current time falls between two different times in the day. I want to know if the current time is between 12am and 2:59 AM and return a True or False statement..

I have 4 numbers.. 25.25, 25.5, 22.25, 22,5 If variable a is lower than 25.5 but not any of the 4 numbers in the list, then add $10.00 to B. or or if variable a is higher than the highest number in the list add $20.00 this needs to be in a calculation field. and advice would be greatly appreciated.

the project is currently a basic invoice system, however they do a bit of shipping and depending on the destination (us/international) and contents they have a fair amount of paper work (documents) that need to be produced for the pouches on the top/side and also for inside the box Most of the data is derived from the invoice or the related customer. I could add the necessary fields to the invoice table for the individual forms for customs / fedex / dhl etc. - fortunately every thing is a form view, and then just print these from a layout based on invoice. via buttons for each needed document. the other thought is this. create an enclosures table that a record is a sin…

I have a database with several thousand records and the following structure: Three fields in PARENT table: id: 1 parent_name: Produce list_of_children: apple,orange,grape,banana Three fields in CHILDREN table: id: fk_id_parent: child_name: What is the most efficient way to convert the comma separated text in the list_of_children field of the PARENT table into separate related records in the CHILDREN table? I assume that using a looping script is the best way. How would you set up the relationship and how would you loop through the creation of each child?

Besides asking the vaguest of questions, I was hoping to get some thoughts on the pros and cons of 2 approaches toward handling a Running Balance. Use-Case: In it's simplest form, a checkbook register. The key for this use-case is the sort order won't really change. Though there is the possibility of adding records into the middle of the sorted found set. Think, got my bank statement, and there is a transaction I didn't expect, or forgot to record ( or had to correct the transaction amount ). Approach 1: Summary Field I know this one has been talked about. The couple of things I know about this approach in the use-case I'm looking at is that the summary is based …

When running speed tests in a file, will Refresh Window [ flush cached join results ] completely reset a file? Is cache the only thing which might affect speed test? Because of my anal nature, I've always closed FileMaker and I used to also restart my computer between each test. Is there a way I can tell what resources each of these processes clear on Mac Mavericks, i.e. does closing FileMaker free more system resources which might affect the test than just flush cache? Does restarting the computer influence? I know that, during speed tests, all other processes should be shut down, such as backups, searching internet etc. or the effects can influence speed test…

Hi I would like to refine a database I have operating which creates a PDF, stores it in the Database and sends it out as an email. Works a treat. Sometimes other files need to be included in the email and it would be nice to store them and attach them as well without doing it manually in the email client. I have some ideas such as Applescripting the mail client or perhaps creating an archive folder of the attachments - but they are not cross platform. Any thoughts? thanks

I am developing a system for a kitchen design firm. Their contracts (orders) typically capture a husband and wife as the "client." My design has Party>PartyRole<Order as the structure. I also have a Party>Relationship<Party structure. I understand that it is important for them to "know" the relationship between the two people that present as "clients." We've discovered, of course, that 10% of the time, the two people are not husband and wife. They can be two husbands, partners, a father and daughter, a shell company (celebrities hiding their identity). So, I've challenged this age-old husband/wife idea and allowed more than one party to be a cl…

I have a time field which I need to work out firstly is it over 10 hours and if it is I need it rounded to the nearest hour. A simple IF statement helped me with the first part. The second part however I am not sure about. ie. 10:59:22 ~ 11:00:00 10:01:30 ~ 11:00:00

I have a table with companies listed. Some are clients and some are vendors (This is determined by radio buttons. Either you select client, vendor or both). I want to create a value list that just show my vendors in a drop down list and I am currently stumped. Any help in sending me down the right direction would be appreciated. Thanks in advance.

We have a calculation we use for calculating Issue numbers for a print publication. It's one of the very first calculations I ever made in FileMaker. Back in 2006-ish. Long story short, I am in the process of building a new file from the ground up, and came across this old calculation...and thought there must be a more elegant or geek-tastic way to do it. So I was hoping I could give you the basics of the problem and see how you would approach it. For me this is partly an exercise to solve a problem, and mostly an exercise in learning. The Details Issue Numbers are typically 4 digits long ( at least until the year 2086...to which I assume we won't be printing th…

Okay… here’s a toughy. I’ve got a corrupt file, so we need to get all the data into a clone of a known-good backup. Obviously I can import it directly, but to be absolutely certain we’re getting rid of all corruption, my supervisor has requested that I export the data to merge files and then re-import it into the known-good clone, which sounds great to me. Unfortunately, there’s a snag: a lot of the data includes formatted text, which is very important to maintain. So, here’s the solution I came up with, repeated for each table in the solution: 1) Export all modification information (mod account, mod timestamp, etc.) to a merge file. 2) Loop through each field of …

I love filemaker. Even though Im not that good at it. I really need a filemaker consultant to help. Anyway here's my issue I want to create a packing list, one of the fields I want if not empty then put an asterisk then 'part number field' formatted in the barcode font followed by another asterisk. Why am I having such an issue with this. Thanks

Hi I have lot of simple comma separated text string than this here: -> Logo_ERNI;SMCStandardkabel;SMCStandardkabel_Z; -> SO8;SO8_Z; And I would like to convert to this: -> /L/o/Logo_ERNI.jpg;/S/M/SMCStandardkabel.jpg;/S/M/SMCStandardkabel_Z.jpg; -> /S/O/SO8.jpg;/S/O/SO8_Z.jpg; I managed to reach away this point: -> /Logo_ERNI.jpg;/SMCStandardkabel.jpg;/SMCStandardkabel_Z.jpg; -> /SO8.jpg;/SO8_Z.jpg; I don't know how to continue. Please let somebody help to solve this problem, if necessary, I send the partial solution. THX

To simplify my situation: I have two records in Table B, with parent A. I want to swap the contents of a field in the two records, but if the operation is interrupted for some reason (e.g., a network interruption), I want to be 100% sure that the records will revert to their state before the swap, i.e., that they won't be committed half way through the swap. My question is whether the only way to do this properly is with a portal: Create a portal for record A, then go to the two rows in question. So in effect the two records are open, as is their mutual parent. Perform the swap and then commit all records while in the portal. If the operation is interrupted, then all …

Report problems. I need to sort this report  by lets call them winners and loosers...  if their projected percent change for the year is positive number, they are a winner.. if 0  or negative.. they are a looser. I need to print seperate stacks of winners and loosers with  sum pages. the problem is you cant really do it this way.. I can not look at that projected field and qualify it as a winner or looser..The problem seems to be it sorting out by calc field that determines winner and looser.. it  seems to freeze the computer Their has to be a simpler way to do this that I am just not thinking of... please help... see attached. Â

I have a calendar plugin that does a great job turning those layouts into something visual so you can see how busy a certain resource is. What would be a great way to create records based off a master record? For example: The database is keeping track of a bus charter schedule. Clients call up and can hire the bus at any time however the bus may also do set routes on Monday and Wednesdays. If I was to create a master table and entered in the information required could I somehow get a script to run that would create records for the next 3 months for every Monday and Wednesday that occurred between now and 3 months time. Master Route: Description: 1 Hour Scen…

I have the following tables: Projects --< Invoices --< Applied Payments >-- Payments On a Projects layout, I have a portal that show invoices, like so… 1. $500 INV2014333-001 2. $300 INV2014333-002 I would like to somehow create a list that nested payments from the Applied Payments table into that invoice list, like so… 1. $500 INV2014333-001 $250 received on 10/1/2014 (check #234) $250 received on 10/5/2014 (check #254) 2. $300 INV2014333-002 $300 received on 11/1/2014 (check #265) Ideally, the number of lines would be flexible so that if there were only one payment on the first invoice the second invoice would mo…

Okay, so here’s the deal: my client wants a system that will allow him to recover all his FileMaker 11 databases within half an hour, in the event of a crash. It’s all working beautifully, all run out of a tiny database that simply imports the most recent data out of the Source File (e.g. the one that just crashed) into the Target File (e.g. last night’s backup). It’s very modular, less than 1 MB, with only about 400 script steps in the whole thing—and about 40% of those are a bunch of If/Else Ifs to import each table appropriately. Obviously, after each import, I want the primary key in that table to be updated appropriately. I can’t perform auto-enter options while …

Hi there, I have set up scripts & a layout and I want to force the user to close a new window (other table) in Browse Mode through a button. I don't the user to exit that window by clicking outside of it. Thanks in advance

Hello, I am wondering if there is a way to automatically upload an exported .csv file to an FTP server on a Windows PC. I already have a working solution for Mactintosh by running a calculated AppleScript, but I don't know much about Windows and I don't know of any equivalent for PC. The current method I have just calls cURL in the Terminal.

Hi... For instance I have a $var which is a text field that i've added items with line feds ( FM Paragraph Icon we use) So the layout format ..image might look like item1= $10 itme2= $11 item3= $12 Then I do a substitute command of $var ..into a $HTML_template var This is my way of creating a .. Invoice Form When I do substitute.. i loose the line fed and my field looks like item1= $10item2= $11item3= $12 I've tried doing a substitute Paragraph return for a <B> or a html line break but only to cause text to be Bold Somewhere I think.. not being a html person... spaces and linefeds are auto removed? Do i …

I don't know where to begin.. GPS plugin? and a map? Can FM handle this anyone?

Hi folks, I'm currently trying to turn a list of words into a progressive anagram tree, but I can't find a working way to solve that issue. Here's what I need to do: A list of words like this baseball football basketball hockey olympics nascar redistribution must be turned into a branching anagram like: A i - hockey r - olympics - redistribution L - nascar E - football K - baseball - basketball What would be the easiest way to establish that in FM? Really hope, that somebody can help me out ...

I would like to find out if there is anyway to change or make custom colors for a filemaker chart If, for example, I have 5 slices I wish I could use red, orange, yellow, green, blue and thats it. Is there any way to change this?

Option-Z on MacBook Pro (Mavericks) gives me Ω I find it interesting that: It sorts after all alpha, making it handy in place of prefix of zzzz etc It is allowed in field names without FM raising a fuss or wrapping with ${} When used in calculations, they all evaluate properly When used as table occurrence name it seems to work fine It is counted as a word and not as a word separator between text or numbers It is one of only a few characters I can find which sorts after alpha characters (Options P and M being others). I know Omega is used in many disciplines from astronomy to mathematics but I believe that FM considers it only a character. Many developers try …

Hi! I've got a list with among other data a number. I want to save in a field the count of those numbers, for instance on today's run we've got two counts of 104, seven of 201, 13 of 220, and so on (somewhere like ten different values every day). I has to be saved every night for a history. It will run as nightly scripts on a FM Server 13. What is the best solution for this? Sort Data, count the occurrences and feed a repeated field is the one I have in mind. Is this old fashioned or the way to go? Thank you for your comments on this.

We have a restaurant POS system developed in Filemaker, V11 right now, and have gotten a request to issue a temporary wifi password on the customers receipt. My problem is not generating the password, but finding a third party package that I can communicate with to issue and reset wifi passwords on the wifi system. The customer is trying to limit access time, yet give his premium customers the flexibility to stay on during their visits helping him control his long stay customer seating problem without doing this manually via the wifi software. I thought it was worth a try, but having problems finding a solution for the Wifi side that would be flexible enough to issue…

Hey I was wondering if anyone in the FM community came across a product that actually uses tasks to control a workflow. Example: I need a day off, so I fill out a form in Filemaker, press a button, and my superior gets a task. And i mean no simple email that will get lost eventually, but a pending task in Filemaker. A record so to speak. This task will lead him to a layout where he can a approve or decline my "day off" request. I was wondering if I have reinvented the wheel or if something like that exists? If anyone wants a demo, I can create a little video presentation. Its awesome :) adios [Added later] In our solution every workflow that s…

I have a few situations where I need to be something specific having to do with dates. For the sake of this example, let's say we're dealing with pay periods.  payperiods table will have 1 record for each pay period. It will have a pay period number, a date the pay period starts and a date the pay period ends. See attachment table.png   From other tables, when a user enters a date...I need to be able to return the pp_number for which that date belongs. For instance, entering 7/12/2014 would return 2.  Entering 7/19/2014 would return 3.  Nothing is set in stone here, I'm open to a different structure, I just need an efficient way of looking up the pay p…

Hi folks. I am trying to create a script in FM11 Advanced. The script needs to import a folder of images into the solution I am creating. The trouble I am having is I need the user to be able to choose the folder, but I don't want them to have control over any other part of the import. It doesn't seem possible to do this using the Import Records script step. Hoping someone knows a workaround for this issue as I am stuck! Thanks in advance for any help anyone can offer

There is a very useful option when you run the script step "Insert File" - you can choose the "Compress" checkbox to store the file compressed. Helpfully, FileMaker shows the icon and filename of the file in that container without any indication that it is compressed, but there is a lot less data being stored in the database (or external on the server ) and there is less data to transfer over a WAN or otherwise slow network. If you then choose to "Export Field Contents" of that container field, FileMaker silently decompresses that data to export the original file. Having looked at what is stored, it seems that silent compression is the gzip format. Let's say, however, …

Hi folks, I am trying to create a script where if the user clicks a button, a number of different layouts are saved as one PDF file. This is easy to do if I define the file path and the file name with the first layout I save as a PDF, and then append all the other layouts to it. However what I ideally need to do is allow the user to choose the file name and path. What I need to do is somehow capture these elements so the script can find the file and append the other layouts to it. I can think of a somewhat crass way of getting these elements separately (although to get the filepath the user would have to click on another file in the folder they want to sav…

The invoice portion of my solution has a status field which can be one of three values; draft (created but not sent), open (sent, and waiting for payment), and paid. Is it best practice to have this field: 1) a calculation based on whether or not it's been printed plus its outstanding balance 2) a text field that changes via script (the print script changes it to open, the receive payment script changes it to paid) 3) or a text field that is manually set Just curious if one method is by far more standard than the others. Thanks, Michael

Send event (printf function) works fine for pdf documents, but it doesn't for image files like jpeg, tiff and other... What function will print images?

How I can import XML file that is about 12 GB. I have an error after about 4 hours of parsing file, with no text in error dialog window.

I have 3 Tables In a short way it looks like: Objekt ADDR HOUSE ID_ADDRESS ID_ADDR ID_HOUSE Name Name (street or region) Relationships: Objekt::ID_ADDRESS=ADDR::ID_ADDR Objekt::ID_ADDRESS=HOUSE::ID_HOUSE Objekt::Name=ADDR::Name Objekt::ID_ADDRESS= Case ( not IsEmpty ( Objekt::Name ) ; ADDR::ID_ADDR; ) _____________________________ So From table Objekt I can get records from related table ADDR by matching C…

The problem is: Field has calculation result on creation (TextFormatRemove(Self)). So it's remove all styles, color, font from entered text. But when you press tab or enter or return, field is saving and you go to the next field, keyboard language automatically changing to english from russian... How I can solve it? Thank you for your advices.

Hi folks. I am having an issue creating a script. where part of it finds a word within a list (in a field). The word I am looking for is "Salary". However the list may contain lines that say one or more of "Salary", "Salary Increases" and "Salary Decreases". And I want to find if there is a line with just the word "Salary" in it. The patterncount function isn't doing the job as it will count (correctly) any of the three lines if they exist. Also, the order of the lines may change in each record so I can't tell the calculation to look on a particular line of the list. Is there a way to find just the word "Salary", ignoring the other two possibilities without actually s…

Hi folks, Is there a workaround to have a button work inside a portal even if there are currently no records in the portal's table? What I am trying to do is when the user clicks on a portal it pops up a box that once filled in will add the record to the portal's table via a script. For a number of reasons I don't want the user to be able to enter the information into the portal directly. I thought maybe turning the portal into a button instead of just the portal fields would do the trick but apparently not! Any help would be greatly appreciated James

Hi folks, So I have a conundrum! I am trying to create a field that will give me the total from the same line number in three separate portals. Trouble is the user can custom sort each of the portals with up and down arrows in each line which through a script changes a sort order field in each record. There are 16 records in each portal. My conundrum is do I create 16 constants and relate them to the sort order field in three child TOs (one for each portal) to get the sum of each line which leads to a lot of added fields and a ton of TOs, or do I do it through a script attached to a script trigger? My gut tells me to go with a script. Wondering if anyone thinks that t…

Let me first preface this by saying I am by no means an expert on Filemaker, more an enthusiast looking to save my small regional field hockey facility from purchasing an expensive shrink wrapped package. So... After searching high and low for a way in which to generate a sports leagues fixture, by using a combination of Custom Functions, Calculations and Scripting. I've also been working on my own to generate something that will get me closer to my goal. This forum post is VERY close, but I've come up with a few things that make for a little more flexibility. Also, the solution posted by Eos has an issue with calculating the fixtures for a league that has an o…

In my database I have three tables. Service Server Software (Among many others) The same software ID can appear on many different servers. Many different servers can appear on many different services. I want to do the following. When I select a service I can populate a join table through a portal, the different servers that support that service. Ex. I could choose the service call center on my Life Cycle Management main page. Then in a portal through a drop down list i can select the servers that are part of that service. I want to then under software inventory to start to show the software on the servers that i have selected for that s…

I am trying to create a calculated field in FileMaker 11 that contains javascript code. I have a database with a parent table "Slides" and a child table "Images". I have created a calculated field called "all_info" in the Slides table that formats all the fields into a large text field. But I am having problems trying to get the formatting correct when there is more than one child record... Example: Slide 00001 has two related records in the "Images" table. The Images table has a field "filename". Slide 00001 has related records with "imageA.jpg" and "imageB.jpg". Result I am looking for (in my "all_info" calculated field): filename[0] = "imageA.jpg"; f…

Hi folks. I am creating a solution in Filemaker 11 where one of the stipulations from the client was that one particular layout was in the form of a spreadsheet. I have figured out how to get around the lack of horizontal portals, and make it look how they want it. However the title for each column (there are 14 in all) is a date that is taken from a related table with 14 records, each with a date in it. I figured that rather than create 14 one line portals each starting from a different record number to create the column labels, it would be far less fiddly to create a calculation field with 14 repetitions where each repetition uses the GetNthRecord function to get a dif…

Some observations from a remote toadstool...I was doing some testing on fields and things and ran across some apparent oddities (odd to me at least). The field was set to 'Number' type: If the field is empty (null, whatever), it still evaluates to zero (i.e. field = 0? YES ). It doesn't seem like it should do this, i.e. NULL ≠ 0. You can add multiple lines to the field IF you are using a checkbox set. So, create a checkbox set with value list "0¶1", check them both and the data in the field is "0¶1". Now, I can't TYPE that data into the field (if it were a plain edit box - I can't hit 'return' and get a CR that is; I can hit option-7 to get a pillcrow). …

I didn't see a forum for security, which struck me as odd, but thought this might be the next best forum.. I have users logging into a solution where, once logged in, they have access only to specific records. More specifically, the can view records that belong to the same division as they user. I have the security working fine, but what I don't like is that users, upon logging in, will see a list of records which contain both records they can see and records marked with <No Access>. What's the best way to filter out the records they don't have access to? Since they don't need to know that those records even exist, I'd just like to filter them out but I'm not su…

Please see FileMaker Pro 12 database I've created to illustrate my problem: https://dl.dropboxusercontent.com/u/24821795/Example.fmp12 I want to count the number of times an Activity has been assigned to a Staff member, but there are a couple of things making it tricky (not impossible, I hope): 1. When the user performs a Find, the count should update to only include the found records. 2. The user can add to the list of activities. In the example provided, SelfJoinCount and Activities::Count are not what I want - they both count Activity (e.g. Archery has been assigned to two staff members), but do not meet criteria 1. above. Try performing a Find of Gender = M …

Hi folks, Have a Filemaker 11 question. Is it possible to set the formatting of a number field to only show decimals if they exist? What I mean is I know under formatting data I can set it to decimal and set fixed number of decimals to two. However if the number is a whole number it will show .00 after it, which is to be expected. However I would rather it did not as the number is a percentage (I can't make the field a percentage field for a number of reasons). The "Do not display number if zero" option only seems to come into play if the entire number is 0. Creating a "Round" calculation won't work as the number needs to be the complete number for other calculations …

Hello, I have a problem of speed on a database that I'd really like some help with. I have a table of topics. Each topic is related to another topic in a parent-son relationship. Example: Topic: Father: filemaker pro 1 (my code for father-of-all) complex calculation filemaker pro custom functions filemaker pro balsamiq mockups 1 features balsamiq mockups price balsamiq mockups what I need to do is to make them ordered in a way such as: 1. Filemaker pro 1.1. Complex Calculations 1.2. Custom Functions 2. Balsamiq mockup…

I want to know if there is a way to let filemaker calculate the CRC32 for a string (textfield). Do you know the calculation to do this? Greetz

i need my logged operators to Not Windows X quit FM but properly exit using my own script so we can close out some stuff that operator might have open.. Any ideas.. Now I test operator relogging in and force a clear that way using a operator_id, if they are still, then do something... or at some pre set time trigger script to test what operators are still logged on since the presistent_Id no longer works i am getting duplicate presistent#'s and got FM notice OS* no longer supports persistent uniqueness Any ideas come to mind.. how do you know who's logged in to or have FM lic up, who's who?

hello all, i was wondering if anybody could help me ? I am getting better at filemaker but scripts still leave me cold! . I have a certificate database that has 5 different certificates. In the layout the fields for each certificate are set by value list ( Pass, Fail Na). At the moment i have the following script but this just prints all the certificates which is fine if all passed. But it creates a lot of work if different people pass different subjects so they don't get that certificate . is there any way i can script this so that they only print  if they pass.  Thanks the script i have made is an attachment (screenshot)   Â

Hi, With filemaker 12 i am getting very strange behaviour. In my project, it is used by lots of uses. sometimes font size, color changed of some fields. Like as usual it is arial font, size 10 ,color black but its shows/changed as bigger font, color change. Please let me know as i tried lots of but not able to succeed to find out reason. What could be the reason. any idea. Thanks in advance,

I read the article by Excelisys @ "http://fmforums.com/forum/topic/90240-generate-code-39-barcodes-without-the-need-for-fonts-or-plug-ins/?p=414157" on barcodes using a repeating field and wanted to do the same thing with html and a web viewer instead of a repeating field, so with the use of some of his code and a little guidance from comment, the attached file is what I came up with, please let me know your thoughts or ideas or if I missed something please let me know... thanks HTMLCODE39.zip

[this is mac only] The attached sample will let you "quick look" a container field on a mac. But now in Mavericks it does not work. Does anyone know the fix for osx 10.9+ ? FMP-OSX-Quicklook-Container.fmp12.zip

Hi all, I created a text field that uses a calculated value and I would like a way to update all 1000 records in my database instead of going to the original field and typing the data in so the calculation works. Any ideas?

Hello, I have a need to 'spawn' a FMP file that is stored in a container to a location that could change (temp path) Then Run that DB and pass it variables that will configure it, Then take that now configured file and email it out. Here is the issues I've run into, I grab the temp path and pass it to the Export Field Contents step and select the option to Automatically Open, but this doesn't work. I know its not an issue with the file and path name etc. as the file is created and visible, also I can open other file types like PDF's and have them open after the export. Next I tried opening the file as I have done in other solutions with the Send Event 'odoc…

Hi, I am currently working on a FileMaker document management solution and adding and removing watermarks is a requirement of the process. The documents are office documents mainly Word and Visio and will be kept in container fields within the solution. Right now the best i have come up with is a send event script with the CMD code: start winword FilePath /mmacroname This opens the word document and calls a macro that removes or adds a watermark and closes the file. This works OK for word but I have not been able to find a CMD equivalent for Visio that lets you call a macro. Furthermore, this solution will be hosted on FileMaker server so all users would have to have m…

The TO names get trimmed on my calculation dialog. How can I fix this ?

I've just spent the last 4 hours trying to work out why the "export field contents" script step would work when I wanted to export to: Get(DocumentsPath). On OS 10.8, Get(DocumentsPath) returns "/Macintosh HD/Users/<my user>/ On OS 10.6 it returns /<my user>/ This is new to me... and I can't find this different mentioned anywhere in FM documentation or otherwise. Is this old news?

Hi All My client would like me to implement a tracking system for their cine cameras. Basically, our rental agents need book cine-style cameras by the particular asset id (mainly to keep track that all consigned cameras are sent out equally). Their current booking system will just book them at a SKU level, not taking in to account which camera has been sent out more times than another. Currently they have all their cameras in an excel spreadsheet with the days running horizontally. They fill each day in a certain color to show which camera is out and for the length of time it is out for (a date range). It gives them a chart view which is easy to read. The irritating p…

I'm working on a solution which I'm trying to optimize for speed (who isn't!) and I was hoping I could get some feedback on my current method. Here's the problem: I'm working on an assignment which is a scheduling system for shift workers. Each employee can, in advance, specify the dates and time ranges during which they want to be available to work. So some employees might say they would like to work Mondays to Fridays, 9am to 5pm, others might specify night shifts, others may say they're only available certain days out of the week. Given this list of employees, and a list of shifts (consisting of dates and time ranges) that need to be covered, I want to determin…

Can anyone tell me why: PatternCount ( "¶3¶3¶3¶" ; "¶3¶" ) yeilds a result of 2 ?

I dont know is this right place to post my question. Sorry if I m wrong How to execute PHP script in filemaker?

I quite often like to take some part of another script.. to a new script or share a piece of code attaching it.. to a email it never been, not like a regular editor where i can do so..... Using FM , maybe I missed something, or a new version.. all these years.. I think B4, I have sent a highlighted copy. to a printer driver,, clummzy i think that might have worked b4 I have too many computers all over i use.. not all with a print driver or the same... How do others do this? I wish I could just highlight copy to clipboard, then past to my Text Editor!

Hello, I understand the Attach option parm, in the Sendmail cmd... but need a direction to get, by browing for, the filename to attach Similar to another command, ie Export.. I am able to click my script button, then the export cmd, goes to a windows browser .. because I left blank the 2nd parm Then i can Browse looking for my xls file, to import Excel records.. Likewise.. I want to browse find a file... I am stumped? Get the filename and path,, passing the parameter to Sendemail attach command.. TIA RodM

Long time reader, 1st time posting, so sorry in advance if I did it wrong. I want to create a script that will return the closest reseller of parts based on zip code the consumer submits. I understand how zip codes work. My question is what's the best way of doings this with out multiple find requests looping a script. Things to keep in mind For this example I have 1 table with company and zip code. There is not a reseller in every zip code The only way I know how to do this is A- multiple finds Make a script that will do a search, then based on the found count widen the results for another search B- relationship Make a relationship with a te…

TIME ZONE UTC -10 UTC -9 UTC -8 Pacific UTC -7 Mountain UTC- 6 Central UTC -5 Eastern UTC -4 UTC 0 greenwhich mean time UTC +1 UTC +2 European standard Generally difference is 3 hours.. + ahead or - behind hours depends on where my system is located either on the WEST or the EAST coast... and where the client is .. My clients systems can be anywhere on the UTC chart... and their clients can ahead or behind I need to get a + or - number of hours returned from where I am located using 2 variables and 2 list similar to the chart above Does that make since...

Hi All, In FileMaker, I have created cross tab report using subsummary parts and summary fields. But because of lot of summary fields in my sub-summary part and trailing grand summary part, my cross tab report is taking more than 20-25 mins to load. So, I need to speed up this loading time of this report. So, for this I tried to create this report using HTML5 and jQuery/JavaScript with FM webviewer. However, I stuck at one point which is - how to pass summary fields data to html code since summary fields are working on the filemaker foundset. Can any one please help me to create cross tab report using HTML5 and webviewer? Thanks and Regards, Trupti Metas…

Hi, I'm using FM9 and the Open URL function to open a mailto: link and populate the subject and body in the user's email client. The body needs to have line breaks. However, on PCs the Paragraph character doesn't do anything and I've tried r and n for return and newline but that prints the literal string r and n. So then I tried using the hex value %0D which works on PCs but prints the literal string %0D on Macs. Is there a character code I should be using or a better way of accomplishing this? Thanks Here's the code called inside Open URL: "mailto:" & Dispatch Delivery::Delivery Contact Email & "?subject=POD - " & Publicatio…

Say I have a webviewer running a javascript count down timer. Is it possible using the filemaker URL Scheme to trigger filemaker scripts from this webviewer ?

Dear all, We have developed an internal Filemaker solution for our shipping company for the past two years. It has evolved to become the very heart of our business. Now the other offices around the world want to share our joy! Today we run it only in our New York office with twelve users. We have create about 10k records per month and have about 200k records in the database spred over three four main tables. Worldwide we would need to be able to scale to 100k records per month and 2M+ records in the database and 100 users from 10 countries. My first question is could filemaker support this from one server? Since management love world wide consolidates reportin…

I am using FM 12 04 adv  I have a membership application which includes a visitors table and a meetings table related as follows:   On a Meetings Layout based on Meetings. On the left is a members portal. On the right is a Visitors Portal. The visitor portal is based on VisitorMeetingJoin table.  On the Visitor Portal is:  MemberMeeting Join::KF_Member which is a popup based on:   Yesterday the app worked wonderfuly. Today, I open it and my KF_Member field, which shows LastName looks like this:  ,Bruce ,Frank2 ,Absher2 Bottom, Leo etc... McWilliams, Merchan, Jeromy etc...  This popup should show Absher2, Frank2 Bott…

Reset the size and position of all dialog boxes to their defaults. For Reset dialog sizes and positions, click Rese Can Ver12 Reset dialog boxes to their defaults, without having to go to Preference ? TIA

Hi I would like to know if there is a way to calculate if there is overflowing text in a textfield? I would like to alert the user that the field has more content than the eye sees by making a color change or inserting an alert image or something else. Is this possible? Does fielmaker have a function to check this by default? The field can be of different sizes. Thanks in advance... Kasper

I have a database with a list of CUSTOMERS. I created a bargraph of the nationality of customers using a summaryfield CUSTOMERS::sumNationalityCount = Count(Nationality). There are nationalities which occur only once in the database. I wanted the bargraph to display nationalities only if they occured more than once( Count only if there is more than one customer for a nationality). I thought of creating a self relationship between CUSTOMERS table, hoping to create a relationship between a CUSTOMERS::gMinNationalityCount to CUSTOMERS::sumNationalityCount. But then CUSTOMERS::sumNationalityCount is greyed out in the Table of Occurrence for CUSTOMERS. [Edit : I switc…

The attached file explains and solves the problem using a script. Â But there is a more elegant way ( w/o a script ) that can work even on FMP7... how do you think to solve ? Â SumReps.zip

Hello I'm working on a personal side project that processes game character information and will (hopefully) provide a set of leaderboards where you can find your ranking with a give weapon or vehicle. The issue I've run into is that even with only 10,000 characters with the most play time and only a small sample set of around 30 weapons from a single class of vehicle, it would take 4-7 days for the server using my script processes to finish a single run of updating that set of character weapon information. I'm looking for ideas on optimizing the script process or alternatives to get the data processed faster. Currently the largest chunk of processing is parsing …

Hi.. i'm new in fm. I want to show to browse the folder ....how to perform this.. i used inert file..but in this..it allow to choose file only not folder i just want folder.... i don't want to use plug-ins... plz help me in this.. thnks....

Am trying to incorporate a Framingham risk score calculator into a solution. The calculator generates points by looking up tables. The question is whether to create custom functions to lookup values or use relationships to wade through tables. For example, for the table listing cholesterol for age range, the table is represented as Cholesterol Age in Years (Men) 20-39 40-49 50-59 <160 0 0 160-199 4 3 200-239 7 5 240-279 9 6 280-999 11 8 The question is, Is it better to create custom functions to calculate the point score O…

Hope this is Left brain stuff.. I have a single record, there are 5 global field1, field2 field3 etc I need a calc global field, to show how many are empty of those filled in Can't figure.. TIA R

I am looking for a simple elegant calc that when the max number is hit it, calc 1 'Long' method: if ( current# + 1 = 4 ; 1 ; current#+1) simple enough I know, but I am guessing there is a cleaner mathematical answer.

My free Membership app is on the web and presumably being used by thousands of users.  I have one user who periodically gets two members to cross link their records by having the same PRIMARY KEY. (I put the PK on the layout so I can watch it as I go from record to record. Yep, the same key (2777) for each member.  Of course this means the 'One' table (Members) holds unique information but that each 'many' table is the same for both cross linked members.  I have checked all the relationships and made sure that the Member table is not able to be updated.  I have checked the Members table and made sure it can not be modified.   I do have a carte…

Ok, so, for a long time I've used FileMaker startup files run by Windows Task Scheduler to accomplish things I can't get the Server to schedule for me. Always worked just fine. I'm in the midst of a migration from FileMaker 11 to 12 and have built one tool in FileMaker 12 that I need to have run. I'm still on FileMaker Server 11 so I decided to just have Task Scheduler run it for me. The trouble is, every time I try to run it, I get an error from Task Scheduler: In addition, the Last Run Result in the task list is "%1 is not a valid win32 application". I did some checking and it seems to be related to a 32 bit application being run on a 64 bit operati…

Ok, Hi everyone... I have a db with 80 records. One field is for the "Manufacturer". I want to have a field on a global db that will display the "Manufacturer" that has the most occurrences in the other database. Is there an easy way to pull that value? I have looked at summary fields and a few calculations, but nothing seems to fit. so any ideas would be grateful. FMP 12 Thanks everyone. Blake

Ok I see that in web viewer I can access pdf's on my computer but how? No where can I find any info providing me guidance on how to access this. I see a video where they tell you here it is but never explained how to get there. • Also do the PDF's have to be all in the same folder or can I search for them all over my computer. Any help would be appreciated. Thanks in advance, The Missing Man

I'm sure that the sorting of IP numbers has been answered many times over, but I've been searching with no luck. I've got a filed that contains IP numbers.. ( 192.168.1.1 and 192.168.1.12) I've made the filed a text filed as number filed does not view correctly. In doing so the IP do not sort correctly if you I do not enter them with leading 0's. 192.168.001.001 192.168.001.012 is there away around not using the leading 0's Thanks

Hi, I'll bet I reached the full extend of my Right brain here..! I have a number field A with number of places (ie 47) in the main table. I have a number field B with number of used places (ie 38) in a secondary table - of course related by ID relationship I made a calculation filed to have a percentage of occupancy with the following Round ( ( B/ A) * 100 ) ; 0)... in the hope to read '81'.. but nope I tried a several configurations, and verified field to be numbers etc... I feel my math form secondary school are lost... Why a calculation field does want to give a result..?? Thank in advance

Hi folks. I have a line of a script I am writing that reads: IF[Get( CurrentPrivilegeSetName ) ≠ "[Full Access]"] 'do something' However it is not working and I'm not sure why. I have full access privileges turned on for the script. The script is being used as a script trigger to not allow a user into a certain tab on a layout without the correct permissions. I have set the correct permissions for a non Full Access user, and they would not see any data if they were able to go into the tab, but I don't really want them in there at all, even if they can't see anything. I have tested the script trigger part of the script and it fires, so the problem is clearly with the ab…

Hi Folks, Looking for a way to verify addresses. We have about 131,000 address records in a rolodex table for 34,000 people in our person table. Many of these are (obviously) incorrect/out of date, and often the problem is a simple typo or zip code error. When we get updated info from people, we want to incorporate a verification system so we can tell on the spot if a street name is misspelled etc... Here are 2 solutions we thought of, neither is perfect: 1) Get info from usps, make value lists of streets in given zip codes, and validate the street name by that zip code's list on entry. The major problem with this is that we're talking about NYC, so the lis…

I am using filemaker 11 advanced on a mac. I have a report with my members by state. It takes all my members, breaks them down by what state they are in and gives a total for each state. I have a summary field using the count function in the report. This works fine. I want to make it so it is sorted by the state with the most members descending order. Based on the help section in FM that I posted below, this should be easy. The problem is the summary field is greyed out and can't be added to the sort. What am I missing? Thanks for any help. I found this in the help section, but it doesn't help. Sorting records by subsummary values To properly display …

Is there a way to disable right click on webviewer but not disabling interaction to webviewer content? By the way onObjectKeystroke not working with webviewer so i need another way or a plugin. I am doing this to prevent users from viewing html source code.

Hi all,  Scenario: I have Product and Customer table. I have some records in Product table, having  fields, Product_name, Product_Category, Product_customer.  And also i have some records in Customer table.  e.g, Product table having 5 products. I have 3 transport as Product_category, 2 location as Product_category. John, as value in Product_customer field, in all 5 records.   Now , i want to calculate the maximum occurrence of Product_Category of a each customer in Customer table.  Output should be Transport.  Please see screenshot as reference.

Hi. i want to print a report from filemaker that has 50 webviewer objects. When i say it to print or go to preview mode they are shown as grey. To make them load their urls i have to goto form view and scrool through them. When current windows view contains webviewer in question it loads and then it can be seen on preview. Is that possible via scripting? How can i make webviewers load on preview? By the way i have tried set webviewer reset, reload and looping through records. they are not working.

Hi there, I have a variety of tables each providing me a summary total for a year's found set of records. I want to place all of these summary totals from different tables on one page so I can see all of my summaries for an individual year of records. But when I do this on a separate new layout, it doesn't give me my found set summary for the individual year as I would like but instead it give me the grand total for all the fields records combined from the table. I thought since I cannot link the summary to a different page that maybe I needed to create a global field and have that = the summary field but even that still gives a grand total of all records as opposed to…

Hi folks, Is there a way to get hold of the number of records that were updated in an update matching records import? (Without having to store the original record values and then create a loop to check each field of each record against the new ones?) I'm creating a script for a large import that imports from many different tables from another database (it grabs the address of the import file at the beginning, when the user chooses it, so imports everything from then on with no dialogs) Once completed I want a custom dialog that tells the user how many files were imported in each table. Getting an import number on an add records import is no problem but this one has me…

Hello FM Forums! I've been a long time reader, and many an instance had the itch to sign up and offer thoughts on a problem... but the star talent here shines so bright, that I have always opted to humbly read along and learn. And I've come across a stumbler which I cannot solve. Oh FMS11, with FMP11 mac clients, all the data for one record in a parent table is being displayed as "?" - question marks - one per field. This apparently happened when network issues occurred as child records in a portal were being edited. Beyond the question marks, all links to child tables are now broken from this context. One of the staff rebooted the machine (with phone…