Script Workspace and Script Triggers

Hi All I have a custom sound I wish to play at the completion of a script. The WAV file was placed in a global container within my "globals" table. At the point in the script where the sound would play, I have a Go to Field (Select;Perform) pointing to the global container, however the sound doesn't play, and upon further inspection the file doesn't show up when the db is accessed from a separate computer as I was under the impression the WAV file would be embedded. What could I be doing wrong?

Hey guys, I have a layout that I want to be used like a data entry form as in Access. Each time I go in and close the layout it saves a record. I have tried adding the fields as required fields but the annoying thing was if I don't use tab and just click out of the current field it has a cry and says x field is blank. It seems fairly sensitive. Maybe I have done it wrong. Any suggestions? Cheers

Hello, I have a field I have that will only need to display either "100" or "50". What would a script be that could allow me to click on this field and the value inside changes from "100" to "50" or vice versa. Cheers.

Hey All Trying to implement an "express return" type feature in my asset management system. What I'm looking for is to have a dialogue window open (or modal window) upon an Express Return button being clicked, the asset id field is presented in which they scan or key in the asset id, upon enter that record is found, the Return Item script is performed, and the user is returned to the dialogue window ready to have the next ID entered. If the record isn't found, a beep is heard, and the user is returned to the dialogue window. Clicking cancel will exit the loop and dialogue box. I have something along the following lines, but it doesn't work. Freeze Window Set Err…

Hi there. Very Newbie but trying to learn. I am trying to create a "QuickFind" script (by a search field) in my layout for an iPad version (just like the QuickFind | IOS in the starter solution contacts) but I can´t get it to work. I have a patient list showing on the layout "Patientoverview" that I would like to be able to perform a search in for a given name (first or lastname) in the iPad layout (without using the toolbar). The list will contain hundreds of patients and I would like to be able to find a specific patient quickly. The patient list is a list of calculation fields "FullName" created by two fields ; "Firstname" and "Lastname" in the same ta…

I've created a layout as a list view, specifying a single field to display which is a name field from a table. The issue is that, based on the permission level of the user, the list varies. I have three permission levels - System Admin, Office Admin and User. When an Office Admin logs in, the list shows all records from the same office location as the Office Admin (read from a table using ExecuteSQL and Get(AccountName) as identifier). So far I've successfully got the account name and permission set of the user, and based on that it's straightforward to use ExecuteSQL to get a valid dataset, but what I'm trying to suss out is how to display that data into the list…

I'm working on a client database with several tables and relationships. The majority of the child tables are related to a primary parent table. My client wishes to have a lock/unlock button that effectively restricts or enables editing for a given record (from the parent table) and all of its related records. I have done this before using Privilege Sets, where each table has a "RecordLock" field that is set to 0 or 1 for locking/unlocking. A script button toggles 0 or 1. However, in this case, I have dozens of relationships and potentially hundreds of records in play, so the script would need to go to 1 table, set 0 or 1, go to related records for that ta…

Sorry if this was covered elsewhere. I use Open URL FM script step to open, from a FM field, a Finder folder containing images or pdf, which a user would drop or open in Preview to view all in a single Preview window. I would like to automate this process and open the contents of a Finder Folder in Preview by AppleScript or similar, without user interaction. Is it possible? Unfortunately, I don't know AppleScript. Thanks for any help.

Good Morning, In the trucking business, drivers are required to record their entire day on what is known as a "Driver's Daily Log". A driver has many logs, there is one log for every date. Drivers should have one log handed in for every day of the year. One of the problems I have is ensuring that everyone hands in a log for every day. I need a script that can identify for each driver the logs that have not been handed in and alert the user.

Needing help generating a script that will do the following: I have a bunch of merge fields (which contain text, that the user defines in another layout) on a layout. I want to set the merge field item as a button. When the user taps the button (on iPad), I want the script to insert the text of the merge field, into a "TxNotes" field. Preferably, I want to have a single script that can be applied to each of the merge field buttons, inserting the merge field text of the particular button. Currently, I have an individual script for each button, which inserts the contents of the associated field - however, I need a considerable number of buttons, so want…

I want to perform a script, within a script... I want the first script to run and I have an If step in there that ends with Exit Script. When it exits the script, it goes to the next step in the parent script. Is there a way to have a complete exit script? Here is what I am trying to accomplish... I want some scripts to require a password to run. If there is a way to "Require Account Password" type step, I'd love the option. I don't believe there is, so I have a script that runs a check. Rather than cut and paste the steps on each script, i'd like to just "Perform Script: Password" on each one. Any advice would be appreciated. Thanks!

Hi  I'm setting up my first FileMaker Pro 12 Advanced Database, so am still getting to grips with the layouts/scripts etc. I have a project containing 18 screns to set up, and working through the forst of these, I have a question that is partially related to disabling entry to a control. I have drop-down to allow the user to select a name, and then assigned to that control is an event which gets the email addrsss and office location for the selected person (using ExecuteSQL). As these fields are non-editable, I have simply set them as textbox entries and unticked both the Browse mode and Find Mode checkboxes in the Behaviour section of the Data tab of the Inspector.…

Boy Scout camping trip: Multiple poles are put up in various locations which are suitable for a campsite and the campsite poles are manually labelled onsite as 1, 2 , and sometimes as 10A, 10B, 10C. This naming of the poles cannot be pre-determined and may be a mix of number and text but text always follows the number if it exists. Scouts are then manually assigned to these campsites in FileMaker (also cannot be pre-determined) and any number of scouts can be assigned to same campsite in any order. Scouts put up tents with two scouts per tent. And now the requirement: 1. We need to group the scouts into two's for same campsite and print a sign with their na…

Hello everbody, Here it is my problem: I would like to loop through several fields of the same record, in the same multitabbed layout, in order to run a validation check (like if...else ) and in case replace the field content. Specifically, if the script finds a field with the content of 0.00 or "?" (ineffective computations) would like to empty the specific field, cleaning it up. I have read here an interesting topic on creation of dynamic arrays (in my case an array of fields names and contents) using the "execute SQL" function available in FM 12 and 2 variables ($FieldContent and $Counter). Unfortunately my environment is and will stay for a while, in FM 11. …

I have a script to print a record, but I need to check if the record was printed it can't be printed again, also if somebody make changes to that record, it can be printed.

Hello all-- Â With a script parameter connected to a button, it's easy to determine how many times a particular word appears in a field. But how can I determine the Nth occurrence of a word or text string that's currently selected in the field? Â In the attached screenshot, the second occurrence of the word 'text' is selected. What's the best way to obtain a result of '2' when testing for this? Â Thank you in advance.

Is it possible to append a pdf with two different page setups? Here's my scenario: I have two different callreports a sales rep can do. A one page("CallReport 1 page Print" and a two page "CallReport Print"). I'd like a script to combine these reports when necessary so that our customer only receives one attachment with both reports. Here is my script: Set Error Capture [On] Perform Find [Restore] (this step looks for all reports marked to print) If [Get (LastError) = 0] Set Variable [$Filename; Value:"Service_Call_Report_" & Substitute ( Get ( CurrentDate ) ; "/" ; "-" ) & ".pdf"] Set Variable [$PDFPath; Value:Get (DocumentsPath) & $…

Am I wrong or Show custom dialog doesn’t work as its supposed (as said in help file). Notes If values entered into input fields don’t match the field type, a validation error message displays. The user must resolve validation errors before the dialog box can be closed. See Defining field validation for more information. I have a numeric field. Numeric only validation. Message. Working in the layout, a message appears if other value than number is placed into the field. Perfect. BUT, I’m trying to avoid the user to enter text into the field while running a script. I have tried to make a loop that works with an already set range of numbers. But if lett…

I need to delete a file off of my Cincinnati Laser from FileMaker. It gets it there via a FMScript that export field contents of a container to this location. So I know the file name and the path its all built in a calculation field on that record. But I don't know how to get that info into an Applescript using the FM12 "Perform AppleScript" script step When I hard code the path and file name (Shown Below) it works. "set set xpath to "Titanium Brain:Users:smartin:Desktop:Laser:1512-clr-c.cnc"¶ tell application "Finder"¶ delete file xpath¶ end tell" When I try to pass the field contents (Shown Below) it doesn't work. "set xpath to Laser::gCNCPa…

Hi everyone, this is my first post here ! I'm not sure if this is the right place to post my question. I created a database solution that uses the Insert from URL command in a loop to retrieve data from a website until certain conditions are met. This is for use at the company I work for to automate an otherwise time-consuming process. It works fine on my personal laptop, which logs in on a Guest account at the office. However, a runtime version of this database, run from my office PC, does not properly execute this script. The Insert from URL command is extremely slow and shows the window titled 'URL Data Transfer' for about a minute before finishing the script witho…

Hi there, I have a relatively simple question but I'm horribly inexperienced with FM and scripts in general. As the name suggests, I need to make some fields read only if certain parameters are met. I figure the easiest way to do this is with a script, however, beyond knowing what to write in a pseudo-code way, I'm a bit lost. I figure first I need to make the required field read-only. Then write an if statement that switches on write privileges once the criteria is met. Something like: Set field "sale price" to read only. IF status = sold field "sale price" = writable ELSE ENDIF How would I do this in FM12? I appreciate any and all help, thanks for re…

Hi all I need to have a script to do the following Open up a Url (which will be a doc file) using the Url in a fileld Once the document has downloaded and opened I need to select all, copy and then paste the text back into a filemaker field I have done some basic scripting but never with applescript My thinking so far is that I already have a small script to go to the url and then the word doc will download and open autmatically So then I need to switch from filemaker to word and select and copy - then put it back into the correct field in filemaker One of the problems is that I am not sure how variables work between the two applications So I am guessing I n…

Hi ... I can't get to work what I think should be something very simple. Our users write large fields of text. Several times they've complained because they've lost an hour of typing (medical report) Filemaker connectivity has been lost. Usually a power outage or VPN issue. I've tried to get them use to clicking outside the field and then back into the field to commit the data but I continue to hear "Why can't it autosave? Just like Word" .... Well ... I created a timer script that gets launched by an OnObjectEntry trigger. It then waits 60 seconds and then gets the cursor position using get(ActiveSelectionStart), does a set field to itself and then …

I've run across a really odd situation and wanted to see if anyone else has either experienced the same, or can provide a solution. A field on a List View layout has the OnObjectKeystroke script trigger. The script checks the Get ( TriggerKeystoke ), and will either go the next record or the previous one if the appropriate key was typed. Works perfectly fine when using the keyboard, but when I use a scanner, every time not all of the symbols come through into the field. It appears that the system isn't able to handle the scripting and all of the characters in such a rapid succession. When I take the script trigger off, then all of the scan shows up in the field. …

Hi Folks, I've got a school database underway at the moment. My current problem is that I want a way to move pupils up a year group annually. In the past I've just run a script that +1 to the year group field. But I reckon that's not the best way to do it... What I've got now is a year of entry to Year 7 field. I'd like to be able to work out the pupils current year group (7,8,9,10,11,12 or 13) using that and the current date. August is the ideal time to transition between the two as it's a clear month with no teaching. What's the best way to do this? With a calculation field or a script I run when needed? Thanks! Mike

I am trying to filter two variables but I can't make it work. Could someone point me what am I doing wrong? Thank you. Sample.zip

I am using FM 12 04 advanced. I have a Membership application. This script and problem revolves around two tables:  Members -->>DES  DES is represented by a portal on Members.   I have a fairly simple script (Just a bunch of If... Else if...). It works well.  The problem is that after my script ends (I can watch it in debug), the record pointer jumps to another record (most of the time... but not always).  I have added a Commit Record. No help. I have removed the Commit Record. No help. I have removed the Goto Object command and ... 'No help'....  Has anyone any idea why this happens? Looks pretty straight forward an…

I’m tying to make a script that creates x number of records. That number relays on a variable. Is it possible to populate a variable directly? I mean is it possible to make that the script asks me... how many records do you want to create? and let me enter a value, or do I need a field (so a table-layout) to set the value to populate the variable? Thank you.

hi guys,  im new here as well as filemaker user, i have a problem about my script, it started when i import table from my another filemaker file.  can you explain to me what does this error means.  " error in script: load source settings by number, we can't go to the correct layout. Either no source number parameter was passed into this script or there is no " Source X " layout where X is the source number".

We have a FM 12 solution which includes a contact list, and I want to create easy links to the contacts web pages and to email the contact from the list view, but from a UI point of view I don't want the buttons on the screen all the time. So I'd like to have the "email" and "web link" buttons ONLY appear when you hover over a specific contact and only for THAT contact. Using "hover" I can make the buttons disappear, and reappear when hovered over, but I want BOTH buttons to appear whenever you're hovering over the ENTIRE contact. I've though about making a background image that comes up and putting the actual buttons on *top* of that, but that seems sloppy and l…

I'm creating a find form which has several regular fields (where user can choose from drop down menu) and 1 field with 5 checkboxes. I need to make a script which will perform find through regular fields and checkboxes. User should be able to check e.g. first and fifth checkboxes and script should find all records with first OR fifth checkboxes (now it looks only for records with both first AND fifth which is wrong); and after this combine this find with other fields (using AND logic). I understood that I need to use extend found set however I'm not too much familiar with coding. I try to use the following script which does not work correctly: car_number is che…

How can I set up my startup script to know solution is being opened on an iPhone and open on iPhone layout? THANKS!

Attached is a new file created only for this test. It has never crashed. Tested on Mac 10.8.4 using FMPA 12.0v4. Not tested on Windows since my windows system is currently down. To replicate what seems to be the issue: Type a number into portal field. On first child record created in portal, it updates the Parent Balance (yellow) consistently whether I tab, hit RETURN or de-select by clicking the layout ( committing ). But in ONE situation, it will not update ... on all subsequent portal records, if you hit RETURN ( I'm on MacBook Pro ), the trigger will fire but the Balance will not update. We know that the cBalance calc updates (it's right below the y…

There is a script inside of which are these lines: Set Variable [$filterValue ; Value: Evaluate($quickFindField) If [ $filterValue <> "" and $filterValue <> "?"] ... do the actions So is this just a short or another way of writing If [ not IsEmpty($filterValue) and IsValid($filterValue) ?? I want to be sure I am not missing a different or additional meaning behind it and I can learning something else I did not know. Thank you.

We have a function that takes multiple script parameters in order to send an email. (we do this because we need to check for a maintenance variable which governs who gets the email) I am sending parameters as newlines and using (Get(ScriptParameter);1) to retrieve them. Works great unless a parameter as a newline, like the body of an email does quite often. I can use Quote(text) to get it into the function properly but once its there I cant unescape the newlines to get them into the email properly. Does anyone have a tip on how to either pass parameters that accept newlines or to undo Quote once it arrives (just for newlines if thats easier). I tri…

Hello All, I have a php script that import data from our web form straight into our filemaker... I'm just working on a mobile number validation script that I want to run once all the data base been imported, is the only way of doing it once the last field has been populated from the php script or is there another way of filemaker knowing once the import has been completed. Cheers guys. Scott

What is the quickest way to populate a repeating field -- when you want different data based on the record you are in? For instance, if DateField contains 8/20/13, I would like RepeatingField to contain: 8/20/13 8/21/13 8/22/13 8/23/13... But on another record, if DateField contains 11/20/13, I would like RepeatingField to contain: 11/20/13 11/21/13 11/22/13... Currently a script populates RepeatingField with a Loop and each Loop sets one of the field's repetitions. Is there a faster way?

I have a field that is populated by a dropdown list - when a user changes the value of that field, I want to display an alert. However, I only want that alert to show if they are changing from ValueA to any other value. Changing from ValueB, etc. should not show the alert. I apologize in advance if this topic has been covered - I've been searching for quite awhile, but couldn't find a solution... Many thanks!

Hello everybody, I am curently setting up a database for a little vet center. But I am now stumbling on several points. My main current problem would be the following: I have set up a portal on the receipt for Inventory based products (drugs, pet stuff...) but now I need another portal for non inventory based items (vet fee, pet hairdressing, ...). My main problem is that they are uneven, some times I will have many inventory based products and few non-inventory products, and some times all the opposite. So my big question is: How can I Script a button who might extend my number of total portal rows, while changing the location of the portal below. (so …

Guys, I've no programming background, so I am asking for help . I have a text field with an automated serial number of three digits by increment of 1. This serial is part of an ID number that includes the current date. I am trying to have this serial returned to 001 at midnight, meaning that every single day the serial starts at 001 up to maximum of 999. My problem is I cannot have the serial reset to 001, unless I do it manually. Any help will be very much appreciated If there is a link available so I can learn basic programming instead of sucking knowledge, it will be very much appreciated too, and I would feel better.. TIA

I have an imported data field that has various entries, such as "credit card" or "invoice". If "credit card" is selected then the amount in the "Amount" field has been paid online. If its "invoice" the amount is due and we need to send an invoice. What I want to do is have an IF type statement that goes something like: If Status field is "credit card", copy Amount to PaidAmount field, else If Status field is "invoice", copy Amount to InvoiceAmount field Any ideas? thanks

I've recently been working on a new project with some massive scripts (1,000+ lines) and I'm having issues when it comes to organizing those scripts into readable chunks. I just ran across the excellent TextMate Filemaker Bundle on the BeezWax blog (http://buzz.beezwax.net/2011/07/30/the-filemaker-ninjas-toolbelt-textmate-bundle) but unfortunately it only applies to the Calculation Engine and not to the Script Editor. I'm aware of the FM Pro Script Diff product, but what other tools are out there that would allow me more control over how scripts steps are displayed?

I am trying to sort out what the best way to transfer the data from fields in one table, to fields in another table. For example; I have a Cash Register Table, where Cash transactions are performed, and the results of those transactions are transferred to the accounts receivables Table. There are three strategies as I see it. 1. Use The transaction ID Field in the cash register as a match field in a relationship with the Accounts Receivable table that is set to create records in Accounts receivable, then use a series of "Set Field" script steps to Fill in the field data. 2. Set a series of variables in the Cash Register Table, GoTo The Accounts Receivable Table, C…

I'm trying to automate the creation of records in a table based on data from a related table. In this database, each Component has any number of Carriers. The Component has a unique number, six digits followed by a dash and an additional digit, such as 123456-1. In the Component table, the Carriers field is set to hold the number of Carriers, as entered by the user. Once this field is completed, I would like the script to automatically create a sequentially numbered set of records for the Carriers in the Carriers table. The Carrier numbering scheme is based on the Component number, and reflects the number of Carriers entered in the Carriers field in the Component tabl…

I have a very odd download of data from the backend of a bookings website that I need to process. It captures the person data and what they purchased. But if there are multiple people on the one purchase, it assigns the group total to every person, not the proportional total. So I get; ID, Number of people, Person, Amount 201 1 Joe $100 202 1 Mary $100 203 1 Zac $400 203 2 Paul $400 203 3 Sandy $400 203 4 Elise $400 I can do a sort based on ID, so technically I could do a summary count. So I could do something like: Sort records, count records in groups, divide Amount by Count and paste the result into a field 'Real Amount' How would I scrip…

I have a problem where the IF statement still skip to the ELSE even if there is  a match. To explain the logic here. I'm going through a file and prior to this I have a lot of string parsing and record deletion and everything works perfectly until these last steps to delete the dupes. I show all records I sort by location field so the dupes line up I go to the first record I set the variable  to the ocation field. I've tried local and global variable, but the same result I go to the next record The loop begins When the IF statement is a match it skips the deletion of the record and continue with the ELSE and loops

I would like to script some behavior based on the users ability to create, or not create, records in a table. I'm using native FileMaker security and would like the scripted test to use that as well to check, and not have to hard code access logic in the script evaluation. I know that I can attempt the create and see if its successful or not, but it would be nice to check for the access before actually trying to create the record. Yes, I could create and revert, but wondering if I'm overlooking a simpler way to test for an available command/action. -- Actual Use Detail -- The use case is a common popup dialog to search for contacts. If the user performs at least …

Basically there is now a need to take an offline copy of the database to customer's sites. we will be accomplishing this via Mirrorsync. In order to prepare the database i had to add a UUID field that gets generated automatically when a record is modified/created. Its a basic function that converts the date stamp and the record ID into a numeric UUID. This works for data going forward but I have 10,000+ records of data with no UUID. I need to create a way to go through each old record and modify it enough to kick in the auto-generating of the UUID field. Otherwise I would have to do it manually or Mirrorsync wont run since it doesnt like empty UUI…

Special thanks to MatthewF for helping me get started. I have form that will allow single input of serial numbers or allow for batch adding thanks to MatthewF The problem is currently I am using a prefix number then adding it to a number (rNumber)+sNum but I want the number part to be a defined length like 4 digits or 5 digits etc but if i have "0" in the rNumber it simply drops it or if it turns over it adds a digit. (rNumber= 003 becomes 3 or rNumber= 999 becomes 1000 when incremented instead of 000) current script in the calculated field is Left (serialPrefix; Length (serialPrefix) ) & Right (serialPrefix; 1) +rNumber+sNum What I would like is if …

Hi All, You'll have to forgive me if I have posted this in the wrong section, still getting a handle on some of the terms used in the forums. Onto my Scripting Issue... I am aiming to build a Database for my local Field Hockey Association, that will generate the Match Schedule (Fixtures) Automatically, based on the particular details of each League, such as Game Day, Weeks of Play, Number of Teams, etc. We have a total of 11 League broken up according to Age Group, Gender, etc. Some League have 12 teams, others only 5, so there is a Bye week for the Leagues with Odd Numbers of Teams. The most simple rule is that the Teams can't play more than once each G…

Hi all, Looking for advice on best practices (or maybe just what you are doing..) in regards to setting global configuration data for all scripts running within a file. Our situation specifically is FMP11 Server with FMP11 -and- PHP clients. We have need of global configuration variables. These are things like 'are we in test mode' or 'authorize.net api key'. Things that all scripts need access to but are global across sessions. We have approached this in 3 ways with different problems 1) A configuration table with key/value pairs. Pro: Essentially makes each config element a singleton value. Easy to manage Cons: Selecting records out of it is a bit o…

Hi Guys, I am hoping somebody can help me with this issue as it has me stumped. The Scenario I have a portal embedded on a layout that shows a set of records dependent on a relationship. The layout shows details for a job that we maintain, the portal shows a list of Equipment for that site with scheduled service dates etc. The Portal has check boxes that can be used to select records by inputting the RecordID into a global field and then using Substitute to remove said record from the global field but leave the others intact. Based off of all this the intention is that I have a set of global fields above the Portal that users can update various informatio…

Hi I am trying to use Set Variable to capture a date. Then I want to take that date, add one day to it and perform a find for a date range. My script looks like this Set Variable [$$Inv_date; Value:Inventory_Date::LastUpdate] Enter Find Mode Set Field [Date; ($$Inv_date)+1 &"..."& g_search_date] Perform Find It works some of the time but not consistently and I think the problem is that when I defined the variable it says "calculation result must be text" How do I get it to say "calculation result must be date"? Thanks in advance

What I am trying to do is create new records where the amount of the records is specified by the user. What i have is 3 field records, where two of the fields will stay the same for the loop but one field( serial number) will auto increment X times. so I have a form that looks like this Serial field [uR14M10000003] Field 2 [sO13333] Field 3 [v2.3] [button] So what I would think would work would be to when I Clicked the button ask the user how many times they want to increment said record, Set that to my loop variable, then add record for each time in the loop. ( it could loop 5 -500 times all depends on what the user selects) But my problem is I cant se…

Hello, I have created a task list for our company and I created fields that allow the users to enter a date on which they would like to receive an email reminder for that task (i.e. meeting scheduled, call so and so, etc.) I had everything set in place, and originally used various triggers to set off the script. First, I had a button that needed to be pressed daily (quite annoying). Then I had it set as a script trigger for when the first person opened the database on a given day. That still wasn't working out well. Any ideas or guidance for setting a scheduled script to go off at certain times of the day? Is that possible? I am working in FileMaker Pro …

Hello, I am using a drop-down list for a field with a value list. I have noticed the following. If I turn off the "Include arrow to show and hide list", whenever I click into this field the menu opens up. If I turn this on, I click into the field and nothing happens unless I click on the arrow to open the list. What I would like to do is use the arrow but ALSO allow the user to click in the field and have the list open up when they use the DOWN arrow. Is something like this possible? I can capture onobjectkeystroke for the down arrow, but I can't get the filed's value list to open up. Thoughts? Thanks! Stephen

Don't know were to ask question.. Can't click open Script editor? Does nothing!! Reboot computer restart open FM same everything set.. but script is broken... any ideas.. I done the for years. so i know my privileges, I can click file, manage dbases, lists privs,etc..

Hi, For some reason the script below that I have as an on open script for my file is not working in regards to hiding and locking the status toolbar from only those with Full Access. Am I missing something obvious? It does hide it, but the lower privilege user can still go to View > Status Toolbar and open it. I thought "lock" was suppose to prevent this? # # If [ Get ( CurrentPrivilegeSetName ) = "[Full Access]" ] Perform Script [ “Unlock_forDevelopment” ] Else # # restrict other users from seeing the toolbar Allow Formatting Bar [ Off ] Show/Hide Toolbars [ Lock; Hide ] End If # # Set default layout Perform Script [ “__Default_Layout” ] # …

I'm a little confused and can't figure out how to capture a script step that has a calculation using an the "Evaluate" function with an invalid argument. For example if I pass an argument that is not quoted and does not represent a valid field name. In case I'm not describing this clearly you can check out the example file. Thanks Error.fmp12.zip

Hello all, I am new at this. I am creating a database for a photographer and I am attempting to get a font color change across an entire row when a condition is set. Basically, the photographer creates 45 prints of one image. This is called an edition. I create a record for each print. So, 45 records. I have a status drop down field, where I can set that status to "Unprinted" as well as other things. I want the status to trigger a script? where the font changes across the entire row of the record into a faded grey if set to Unprinted. This way if prints 1-5 are printed they will appear in black. 6-45 will appeared faded and will not take atte…

I can not for the life of me get this script step to work when defining a specific volume. I am simply trying to insert a document with this path - filemac: /Volumes/networkFootage/Digital_Deliverables_Packages/aetv_68610_rebrand/_Delivery_Packages/68610_Delivery_13-0723/_VC_PackageSummary_13-0723.numbers It only appears as though this script step seems to work when using the Get(DesktopPath) or Get(DocumentsPath) ahead of the file name. Please tell me this is not the case. There error I am receiving is that it cannot find the file, thus I get the dialog box to locate it. I can manually insert (without using the script) without issue. Too many frustrating hour…

Hi Gang - long time, no post! Thought I knew most everything about FM but... I'm now trying to create a field (lets call it field_B ) which contains a history (including timestamp info) of another field (we'll call that field_A ). Field_A contains frequently updated prices, and every time the field has a new entry (price) or the price changes - either higher or lower - I need a history of the last previous changed prices, along with the timestamp of when they were changed. Neither fields are global - each record has it. The data is being auto updated by an SQL feed - this is how it might come in (appear): Field_A content at 8:00AM on 7/13/2013: <bla…

Hello. Is there any way to find what the tab order number is for an active field? Also, can this be scripted to jump to the next field in the tab order? Thanks, Stephen

It has been documented that FM12 introduced some serious issues with the onlayoutkeystroke trigger on windows machines, especially when a barcode scanner is involved. The issue is that the script trigger seems to interrupt the stream of characters coming in from the barcode scanner. While this worked fine in FM11, this method is now useless in FM12 on Windows. The recommended workaround is to add a global field to the layout, and use "onobjectexit" to return the cursor to the field after each scan. While this works fine for simple cases, I am trying to migrate a FM11 file that uses the onlayoutkeystroke method to FM12. The issue is that I have a rich layout with s…

Im pretty new to FileMaker and have a 2 part question. First, I wanted to know if there is somehow a current list of $ and $$ Variables used in scripts? The reason I am asking is to avoid potentially using the same variable name for two different purposes within scripts. I suspect this comes largely down to "proper development principles" to avoid such a conflict, however that sort of "evaluation" feature wouldn't hurt anybody. This is prompted by the fact that I had the same variable name in two seperate scripts; one to filter a portal and the other to set an FK (I caught it before it went into action, and upon further inspection one was global and the other was …

Hi, I have a multi Window Solution and qould like to ask if its possible to check if a Window is open or not. Because I would like to avoid the same window more than once at a time. thx ChiSao

I'm using the FileMaker Training Series for FM11 advanced. In Module 6 - Scripts, Lesson 6.4 "Using Scripts to Find Data", example 6.4.1 How can I set the criterion to the find request for the date field in the "Perform Find" script ?? The exercise says: "Select the Date field on the left, and enter “1/1/2010...6/30/2010” as the criterion" but when I click the Add button, there is a message: "The value of this field must be a valid date in the range of years 1 to 4000 and should look like 12/25/2003" What can I do ?

I have a problem with a report that needs to show what the inventory is at the start of any given month. This is made difficult because the report may not be requested until the following month, or later. I have tried several script ploys, but just can't seem to get one to work. Making a run on the first of a given month would seem to solve this, but if the first falls on a weekend or a holiday this falls apart because inventory can be increased or decreased on any weekend/holiday. Moreover, getting someone to never fail to run the report on the first is just not practical. Is there any way to script this? Maybe some sort of auto-run thing? TIA

I have a script that performs 32 find requests on the way to preparing a report. Depending on the monthly data selected, the script will find a "No records match this find criteria" message because the searches do not find any matching records. As it stands the operator has to hit "Continue" each time the message appears - what I would like is a script step that would automatically bypass the message(s) and continue the script without operator having to interact.

I'm not sure if I have the right approach here. I want to display a google map with multiple pins according to a found set (and in another instance the contents of a portal). I have a script that builds some text/html using 3 Set Field statements. Each Set Field statement is just plain text. The Set Field is then displayed by a Set Web Viewer step into an Object. The 1st and 3rd steps are common javascript, the 2nd step is a javascript array of addresses which is hardcoded for now, but should eventually be constructed from the data in the found set. With the hardcoded array the script would product the following text which will display a multi-pin map. data:t…

I am trying to implement the following and I am just going to run it by you guys very quickly. I am not sure it's feasible but here's how it goes. I 've divided our client list to certain types: private companies, governmental agencies, private individuals etc. I am planning to have a data input layout whereby each one of them has a separate tab and the user just goes to the appropriate tab to fill in the details. So if it's a private individual they 'll click the third tab (in this example) and go on to fill their data. There's of course a field where the type of client will be inputted. How do I trigger filemaker so select from a list to fill in client type based …

is there a way to convert the web viewer address to long lat and altitude this is my web viewer address "http://maps.google.com/maps?q=" & Client::Address & "," & Client::City & "," & Client::State & "," & Client::Postal_Code & "&z=" & " " & "&output=embed&iwloc=0"

Hello Is it possible to capture the fields sorted by in a variable? I have a sub-summary report with multiple sub-summary parts. The script will be set to Sort Records with dialog so users can take out or rearrange the order of the fields. I'd like to capture the actual sort order and use the variable as a header in the report. I see sort state as a get function, but don't see a get function for sorted fields. Is it possible to capture? Thank you.

Hi all! I've been reading this forum and learning from all of you for a while now (I am very new to FM), for some days now I have been trying to figure out how to fix a problem, I have read a lot and browsed through a myriad of posts and can't seem to work it out on my own, I will be very thankful if any of you could help me. I maintain a big database of products indexed by their UPC (EAN) code, they mostly come from one provider so importing stock updates is pretty easy, but now we have a second provider and I keep their products also indexed by UPC code in a different table. The problem comes when I try to match UPC codes in provider1 (they share most of the catalog) …

Hi I wonder if someone can help me with a script I'm struggling with. I have got the script below to summarise the total amount of clients we transport between any given dates and to count the number of vehicles used to transport them using two Summary Fields in a table called Journeys. The first summary field counts the vehicles used i.e minibus, DAR or a car and the second one just totals the amount of clients transported which is extracted from an input field on the journeys layout which is then displayed on another layout called 'clients transported' via a button on the journeys layout. This works fine but what I'd like to do is summarise the amount of c…

Well, I just did something very very stupid. I accidentally made a change in a script triggered (via "File Option") on a file opening, The really stupid change I made causes the opening window to immediately close, thereby closing the whole file. So, now the database closes automatically upon opening! And this was a nearly (>90% done) solution that I don't have a recent backup of. Is there any way to circumvent or disable the particular script or the File Option setting that triggers it on opening? EEK! HELP!

So, here's the problem I'm running into - I have a mobile file that has a field with checkbox input, which of course separates multiple selections with a carriage return. This causes visual issues when the report layout is run, and in desktop I got around that by using find/replace to replace the carriage return with a comma. Unfortunately, this isn't supported in ios. Anybody have any ideas on how to get around this? Thanks so much!

Hi Everybody! This doesn't seem too complicated at first blush, but I've been wrestling with it for over a week with no success. Goal: I need the all Children of a single designated Parent to be duplicated among all of the child-less records in a found set of Parents. This function is useful where the user wants to avoid manually typing into the database duplicate Children records among tons of Parents. I googled the forums and the net in general for instruction/articles, and couldn't find anything. Any thoughts would be much appreciated... Thank you! -J

Hi, not sure I am in the correct place - sorry moderator if you have to move this post around. I made a simple script mailto, passed all the steps to find out that to get an attachment FMP12 is looking for a file path. The database stores PDF files, I want to be able to share throughout email. Is there any trick to go around and send the PDF stored in the PDF field as an attachment to the email...?? Storing the PDF in a folder and only the location into the PDF Field has the advantage to keep the database slim, but any wrong manipulation of the folder can ruin work, and oblige to rebuilt all the file path .. On other hand, if I want to pass the database to iP…

I have two tables, OrdersSQL and OrderMirror. A primary ID and a text field in each table. My script copies the primary key from OrdersSQL, creates a new record in OrderMirror and pastes the ID into the ID field. The data field in the mirror table gets populated via a lookup to the sql table. Problem is, I get some of the text, but then it gives me a huge string of periods. When looking at the text in a text editor, each period is preceded by an inverted question mark. Â I've also tried doing a copy and paste as well as setting a variable and doing a set field. Same thing. Â What's even more disturbing is that when I walk through each of the script steps with Script…

Hey all, We are using FMP 9 - 11 Clients all on windows, it doesn't matter if the solution is run from a server or run from the local system. When I use Get (Temporary Path) I am expecting to get something similar to this " /C:/Users/ronc/AppData/Local/Temp/S10/ " it should end with Temp/S10. What I am getting is sometimes this " /C:/Users/ronc/AppData/Local/Temp/S10.1/ " or " /C:/Users/ronc/AppData/Local/Temp/S10/S10.1 " on different systems and clients. I can use Get (Temporary Path) in one script and it works fine, in another it doesn't, or go back and run the first script and it works fine. It doesn't matter if the software is on a server or is …

I have a single database that I use to store contact information. I currently have a script to export and backup all of the data as a raw text ".tab" file that is saved on the desktop. (For script step for the path, I set a variable and the following to save to the desktop: Get ( DesktopPath ) & "DataBackup.tab" Works great. But I want to use my database with FM Go, and then revise my script to save this "DataBackup.tab" file to dropbox, or to copy.com. (Copy.com is much like dropbox but with more free storage.) The problem is that the path needs to be revised since you can't save a file to the desktop with FM Go and the iPad. I need to change the…

I have a file that generates a report for a date range that is entered by the user (Start Date & End Date). I would like to have it so fhe user enters the two dates, then clicks on a button to find the records in that date range. How can I do this? TIA

I've not used FM Pro in some time and need help. Just upgraded to FM12. I have a check box list that user chooses to select which vendors will receive request for bid on new jobs entered. What I want is a way to grab names from chosen check boxes and find corresponding email from a separate vendor list and then send a separate email to each vendor (I know how to set up email). Unclear how I can accomplish this with check box. In the past I've used buttons for each vendor (yes, long list and lots of work to set up) that triggers scripts. However, the check box list would make it much easier. Appreciate any help that can be provided, and remember I'm a novice so plea…

Can someone help me out please. I am looking for an automatic way to mark newly created records and records that have had any modifications made. My plan was to write a script that would check a check box and then attached that script to the records fields with a script trigger so that if a field was changed the check box would be checked. I was unable to get a script to check a check box. Is there a simple way to do this? How would I mark newly created records? Thanks

Hello everyone, I have written a short line of code as a custom html in the web viewer such that when the link present in the web viewer is clicked it runs a particular script in the file with a parameter. It looks like this: "data:text/html," &" <html> <body> &"/"& Get ( FileName )& "?script=<scriptName>&param=" & <someField> &"'>View Map Detail</a> </body> </html>" Now I know that this web viewer is doing what i want it to do. upon clicking the link the script is executed with the appropriate parameter. However each time the link is clicked filemaker reopens the file that i am trying to…

Hi all I am a new FM 12 pro user and looking for tools that can help me enhance and speed up my file maker experience and learning curve. Specifically i would like Script management/ making tools Layout menus tools Suggestions with pros and cons would be useful thanks in advance

I have two fields: Closed Date & HW Platform. Goal: If the user selects the HW Platform field and Closed Date is empty pop a custom dialog. If Closed Date is not empty then no message. I have tried a few ways to use field validation to perform the check and post a message but no luck so far. I know I could do this easily with a Script Trigger. My question is can this be done with validation? And is one or the other method better? Validation or ST? FileMaker 12 FileMaker Server Adv 12

I'm currently building a FileMaker 12 database for use with FileMaker 12 Server and FileMaker GO where I have 18 users and 18 layouts (1 per user) for remote data entry to a single database. Each user requires a different layout for functionality purposes. I have permissions set so each user only has access (view only for layout, editing for record) to their own individual layout, but unless I set a gateway layout that has them choose who they are (with buttons that are mapped as "Go to Layout), I can't get them to their specific layout. I found an old script from FileMaker 2 that was supposed to look at username and then automatically take them to the approp…

If I open a Filemaker database in a second monitor, the dialog boxes pop up on the first monitor. Is there a way to keep Filemaker open in the second monitor but have the dialog boxes open in the second monitor as well?

The intro to my problem is going to be long because I think it requires a degree of explanation. I apologize in advance for the length. I have a project that involves, at present, designing restaurant and industrial kitchens (it may expand to all food areas). I have listed several hundred different pieces of equipment and have a file of printouts of their "overviews" and "cut sheets", or specifications. When drawing blueprints, each piece of equipment must be shown (to scale) and sequentially numbered. A copy of the Overview (general description and picture) and the applicale cut sheets, in sequential order, must accompany the primary set of blueprints. Having…

How can I invoke a script within a script after a found set is empty...? Much thanks all! L~

Hello I am wondering if there is any way in Filemaker 11 to run a script according to a calculationi (more specifically, according to a selection that the user makes). Here is an outline of what I wish to achieve. I have a global field, with a checkbox value list of the many reporting options available to the user. Depending on what he or she checks then the appropriate script should be run. For example -- If user has checked the "Cheque Requisition Report" then the "Cheque Requisition Report Script" should be run. If user has checked the "Cheque Requisition Report" and "Current Inventory Report" then each of the two scripts will be run. And so o…

Hi, Likely a stupid question but I'm having issues with it the nonetheless; I'm looking to create a script that generates a list of upcoming events based on a future date "start_date"; my thoughts are that this script should generate what I'm looking for however it is providing unexpected results (finding past dates not future). Go to layout x Set error capture on Enter find mode Set field [jobs_id::start_date; Jobs_ID::start_date & " >" & Get ( CurrentDate )] Perform Find [restore] Sort records [no dialog] Go to layout y View as {view as list] Calculated result is a date. I can perform a find manually and get the proper results b…

Hi, I'm writing a script to add "sessions" to my database. Each session has "Session Date" and "Session Time" fields associated with it. I'd like to prevent the user from adding another record with the exact same date and time. I've created a third field with the date and time combined as a unique identifier. I'm wondering what the best way is to compare this date/time field to existing records during record creation to make sure it doesn't already exist in the database. I imagine this is a fairly simple and straight forward problem but I can't seem to get a grasp on it at the moment with my current FM knowledge. Thanks

Hello, It may seem like a trivial matter but I would like to script something that would do the following: 1) Go To A Layout 2) Sort according to a Summary field 3) "Go To" the top Sub-Summary Part (that is above the Body) so that it becomes visible. I tried making a field in the Sub-summary part an Object and scripted a Go To Object. However this still does work, and trying the Go To Record/Request [first], it does not "scroll" high enough so that the Sub-Summary part and its fields are visible. I hope this makes sense? Is there any way to make this work?

I'm trying to write a script (using FMP 11) that will compute the number of whole months (and days) elapsed between 2 dates, where a whole month is defined as the period from the first day of that month through the last day of that month. So: Jan 1 to Jan 31 = 1 whole month Jan 1 to Feb 1 = 1 whole month + 1 day Jan 15 to Feb 15 = 0 whole months + 30 days Jan 15 to Feb 25 = 0 whole months + 40 days.

A phone number formatter, that reformats as you type, give it a try (FM 10 only)! [ This is just a sample, so I'm using American format, I realize not all phone numbers look like this. ] FM10Test.fp7.zip

Hi all, I hope this is right place for this question. I have to make a script which will make a record set of all variations where a have on first and third spot a character and on second a number. En result should look like this: A0A A0B . . . A0Z A1A . . Z9Z I would appreciate any help.

I'm having a problem with the "set field" command that doesn't make sense. I've used it many times in the past under the same circumstances without this issue, AND even withing the scipt I get conflicting go/no-go results.. I have two tables: "orders" and "orders line items". They're related by the fields "Order Number" and "customer number" present in both tables. On a particualr layout for orders, there are global fields "qty.g", "Product Code.g", "Customer ID.g" and "Order Number.g" that are intended to be added as a new single record to the "order line items" table. All these fields are global, and defined as numbers. A script first creates a new record in…