Script Workspace and Script Triggers

FM 12 Adv. I'm trying to use a layout trigger on record load. The script goes to related records on another layout to perform some operations and then returns to the layout. So, when I load a record, the script triggers, goes to another layout, returns to the original layout, and the script fires again. An endless loop! Any suggestions on how I can get around this?

I'd like to be able to perform a Traceroute during execution of a script running on FileMaker Pro (not FM Server) on a Windows 2012 R2 Server machine. Any ideas on how to do it? Thanks in advance! -Kent

I have a found set of accounts, for each account I am creating a set of records starting at the current date with each additional child record's date field incrementing by 8 days. The two loops are working fine. Date Records 7/1/2016 7/9/2016 7/17/2016 7/25/2016 8/2/2016 etc. I would like to stagger the start dates into 4 groups 1st Account's record sequence starts today. 2nd Account'srecord sequence starts 7 days later. 3rd Account'srecord sequence starts 14 days later. 4th Account'srecord sequence starts 28 days later. 5th Account'srecord sequence starts today. 6th Account'srecord sequen…

Hi All, I'm trying to see if Filemaker would be able to move a field in a row and move it to a specific column/field. In my sample i have many rows per each sales order. I would like to create 1 row with all the items sent to a new field. the goa is to have 1 row with all the items, but items under multiple columns/fields. I attached a sample, i'm hoping someone might be able to point me in the right direction. not sure if its a hard or something simple. Thanks in advance. Field Sales.fmp12

I have a variable with concatenating returns so to preserve empty values. GetField ( "n_nonBillableScreen " & $headNumber ) & ¶ & GetField ( "n_Mesh " & $headNumber ) & ¶ & GetField ( "t_Ink Flash " & $headNumber ) & ¶ & GetField ( "n_Stroke " & $headNumber ) & ¶ & GetField ( "n_Squeegee " & $headNumber ) & ¶ & GetField ( "n_PSI " & $headNumber ) I then am trying to create a dynamic variable that contains this list as I want to loop and create a lot of variables containing this dynamic list. I seem to run into the trouble of it being a …

I'm having a little trouble choosing the correct script trigger that, once a password field has six characters entered into it, the script trigger commits the current record so a calculation will fire; this way, a user won't be left wondering what to do after entering the sixth digit of their password--the script will fire a calculation (test for correct login credentials) that will take users to another layout. Obviously, the script will have the Commit Record step but I don't think/know if additional steps are needed. TIA for your help!

Hello, I am trying to figure out a way to auto-import print job log (CSV file) into the FIlemaker every day. I know that I can schedule to run a script on Server. Now, the real issue is to setup script step where I add file. I want to import everyday log file which has that date as filename , so it's not same file I am importing.. everyday it changes and my scheduled script will import file at specific time from Server remotely. I would appreciate any suggestion. Thank you

Hello, I currently use the send event script step with this command to delete any pdf file located in my cnpdf folder on Windows: cmd /c DEL /Q *.pdf "C:\cnpdf" How can I do the same in a Mac computer? thanks in advance for your help

Filemaker Pro 11 Adv Can't locate a (Get CursoPosition) function. I'm looking to cut the text from a "INSERTNOW" field and place it in a "NOTES" field, at exactly the point where I have the cursor positioned. Cursor position will change from record to record, according to my needs. I would manually move the cursor to a different location in the field, for each record. IE: sample text in the "NOTES" field: What the world needs now is love. Should I have the cursor at the end of the word What, I'd like to insert the text from "INSERTNOW", at that point. OR Should I have the cursor at the end of the word needs, I'd like to insert the text from "INSE…

I tried looking at the help files, but nothing works. I'm using FMP 15. It's just a sound effect, not very long at all. I've tried inserting the audio script step, then the AV play script step. I hear nothing. I'd appreciate if someone more savvy with sound could suggest what to do. Thanks!

Hi All, Does anyone know why my scripts drop down menu might be greyed out? I am unable access these functions. Cheers, Simon

Can a script be made to lock all the data on a record? I find that employees go back to look at old records but change things by accident.

There appears to be a bug in FM9 (and probably prior) with the ValueListItems() function. If you pass a filename in the first parameter that contains a period, the function returns nothing. That is, if the actual name of the FM file on disk has a period in it (such as a file extention), then the ValueListItems function return "". So.. if my filename is 'FMProDB' everything is fine. If it is 'FMProDB 1.0v1' the function fails. This happens regardless of whether the first parameter is passed as a string literal (i.e. "MyDabase.fm7") or by using the Get(Filename) function as follows: ValueListItems ( Get ( FileName ) ; "colors" ) I'm wondering if someo…

I have added a field with special notes. When I print this record using a script I would like it to pop up this special note on the screen before it prints so the user will not miss it. Is there a way to do this?

Hi, I am trying to set fields in a related customer record based on a choice made in a payments table portal row. The scenario is that in n the Payments portal row, the user will select a PaymentType from choices governed by a Value List. The Type chosen, will then set either one of two fields in a related Customer record via an attached script trigger - currently onObjectExit. if paymentType "Annual Membership" is selected, the Customer::Membership StartDate will be set with the date of the payment. But if paymentType "Monthly" is selected, the Customer::SubsLastPaid field will be set with the date of the payment. Reference: Script 1.p…

Hello All, I'm trying to create a field that acts as a timer (count down). I want to show when an order should be delivered and then the time left (timer) to prepare it. After the deadline has been met (usually no more than 8 hours from start to finish), I want the entire line to go Red (which I know I can do with conditional formatting). In order to get a timer field (with seconds) do I need to have the layout running a script to update itself every second? Or can I have individual fields do that by themselves? Thanks!

Hello, I am extremely new to Filemaker. I've been trying to learn it but time always dictates. I am trying to create what I believe is a simple database. What I am trying to do is to have a very basic system to track parts usage by our mechanics by either barcode or part number. Basically the mechanic would come up to the computer. Enter a unit #, worker order #, date, part #(either by manual entry or upc.) and qty. Then I would like to be able to print a report in the morning that will display Unit #, work order #, date, part # and qty. I can then take this information and enter it into our system. The problem I have is our system doesn't allow bar coding. Also s…

Hi all, thanks for your help in advance. I am sure there is an easy solution. I'm a self-taught beginner/intermediate user. I use Filemaker Pro 12 and sometimes 14 (depending on where I am working, home or university) on a mac. PROBLEM: I am using a script to export the full size image (jpg) contents of all records for a particular container field. My problem is that they export as images within text files and I need the original unmodified jpg image. Specifically, they export as filetype "TextEdit Document". My script uses "Export Field Contents", where I enter the container field followed by a semicolon and $Images. This sends the images to the desktop** just …

can someone help me, with a way of finding the internal script ID craig

Is there a formula / script that i can attach to a button so that when i press this button it will screenshot a pre selected or just in general screen shot the page on filemaker for me ?

Situation: a TableA with record(s) containing a multiline field (which happens to be a multi-line key) which I am looping through in a script. I need to lookup a related value from another TableB on each loop. Currently I have to set a (global) field in TableA to the n-th value of the multiline field at each loop and pull the related value from a relation based on that (global) field (TableA_TableB). Question: is there a way to script this using only variables? ie: Set $SomeRelatedValue = LookupValue ( TableA_TableB::LookupField , $SomeGivenValue ) or: Set Field [ TableA::SomeRelatedValue ; LookupValue ( TableA_TableB::LookupField, $SomeGivenValue ) ] …

Hi does anyone know how script a search that will search just 3 specific fields of a layout? All 3 search fields are propagated by the same value list. Value A, Value B, value C they could be in any of three fields "quick find" would find the search criteria and work OK, but my users can't select it via the value list that propagates the data fields. Any ideas on this this would be most helpful. Thank you..

Greets, all: I'm looking for a way to simplify a scripted Send Event request (after a Perform Applescript request to open a path to the appropriate folder elsewhere on a Windows server) to open Excel files where not only is their location not precisely known within six folders (Let's just name them Alpha, Bravo, Charlie, Delta, Echo and Foxtrot.) but the filename and extension (.xls vs. .xlsx) are in question, too. Here are the different permutations of the filenames ( FN = First Name, LN = Last Name): FN LN (no StudentID) + .xls FN LN (no StudentID) + .xlsx FN LN + StudentID + .xls FN LN + StudentID + .xlsx On the surface, it looks like a massi…

I have a script that updates my Filemaker database by importing information from other SQL databases. In this script is a dialogue that asks the user if they wish to continue as it takes a few minutes to complete. I decided to schedule this script to run from the server every couple of hours but wanted to still be able to let a user run it if they needed to update the database in between the scheduled updates. So, I left the dialogue in but wrapped it between ( If and End If ) checking for MultiUserState = 2 so the dialogue step would not execute if running on the server because show dialogue is not compatible. Well the script fails when running on the server (Sched…

Hey all, I'm trying to debug a de-duping script I have which runs after importing records. The script works by sorting the imported list by a match field, iterating through the found set and marking any record with the same match field ID as the previous as a duplicate. It mostly is working fine except in this one case which has me stumped as the values of the strings in each comparison are different but the condition tests "true". In the following code example when I run a comparison on the a1 and b1 derived values, c returns "1". If I use the static a2 and b2 values, the condition tests "false" (as expected). I have checked the derived b1/b2 values in the data view…

I have written two scripts to email invoices to customers. The first time I run the script everything works fine, but if I need to run the script again the emails are created, but only the final email has a pdf attached. If I close both of the databases involved the script runs properly again (one time). Any ideas? Thanks!

Hi First time asking a question on the forum guys so apologies if this has been answered elsewhere. I am in the process of building a staff database adapted from the personnel records starter solution. I have adapted the time off table to display start and end date of each week and each day (Monday to Sunday) is shown as a drop down with values of available, unavailable, booked etc. On the personnel list layout I have edited to show the fields from the portal in the same order. The idea behind this is that our operations team can look at the personnel list and find staff who are available to cover shifts as they come in (we work in a fast paced industr…

This question relates to FM12. Not sure if this 'feature' is available in 13 or 14 yet. I'm wondering if there is a way to script control of editing Value Lists. Two things up front: 1. I'm not referring to the Manage Value Lists menu; rather the "Allow editing of Value List" option in the Inspector. 2. I'm aware of alternate methods to re-create value lists using tables and relationships. I don't want to do that, but of course, I'll resort to it if necessary. The goal is to allow certain users the ability to edit value lists while restricting others. FileMaker offers many security layers that can be managed by developers, include access to the Manage Val…

On OS X FM15 but, from memory, this problem has been around a while. In the Script Workspace when I try to edit the name of a script I get cast out of the editing process very rapidly. I click on the script name, it highlights but as soon as I start to type, no matter how fast, the cursor is ejected from the edit box before I can complete it. I resort to typing whatever I want in the Notes app and using copy/paste. This used to affect many more such edit boxes. I believe it is less now. I ask, "Is it just me?", as I don't see others referring to this irritation and expressing frustration as it not being solved after being around for so long. Maybe…

When pasting a Perform Script step which contains a call to a script in a file not open or linked to the current file, FileMaker locks up. Discovered on Win 7, machine. In FMA 14, the expected paste result is shown in the attached file.

Hello all, I'm hoping one of you might be able to solve my little mystery! I've been using and modifying the Research Notes Starter solution, I find it very interesting dissecting these. I've sussed out most of the function but the $$Current_Type global variable baffles me, it's used as an auto-enter for the 'TYPE MATCH FIELD' in the 'Data' table which is then used as a match field to separate data into it's relevant portals; Notes, Media & Documents. Depending on which portal you create the record via 'TYPE MATCH FIELD' is populated with one of these 3 types directly from the $$Current_Type variable. But I can't see it in action anywhere, there are no script tr…

LS, My plan is to let the FMS handle more duties, without overloading the server. For instance 25 PSOS are allowed, so I would like to get the count of those sessions. How do I do that ? I would like to think there would be a simple way to know how many sessions are running and which script they are running. Or shouldn't I be doing this at all ? Regards.

I'm a novice & I'm trying to lock /disable a field based on the current user. I don't want the field to disappear if the user is not authorized to modify it. I want it to be visible to unauthorized users, but modifiable to authorized users. Here's the script I'm trying to use: If [Get(AccountName)] If [Get(AccountName) = "boss1" or [Get(AccountName)] = "boss2" Else Set Field [Table::Next Tab] End If End If

i have a script to find and add barcode if not available, but, the problem is, it is not automatically add new barcode, if the find result is not available, any suggestion about this script? i want to to find barcode through iphone camera, if not available, it will automatically add the new barcode. thank you script.tiff

I am merging and reorganizing roughly a decade's worth of FileMaker layouts, designed by a user without knowledge of how FileMaker works, and used by several employees over time. As a result, the formats of data entry have shifted constantly, making it difficult to effectively merge and connect data. The problem I'm running into is that First/Last name were calculated together without a " " between the names. As a workaround, data was entered into fields with either a space at the end of First, or beginning of Last. I currently suggest that the names be edited as they're used to display related data properly, but this is inefficient and burdens the user. Often, there…

In FM Pro 11 I have a script with two criteria: I want to change Upload:Genre to =Klassisk OR Jazz How do I do that? I havn't found the answer with Google and I can't find "the manual" for the script editor anywhere.

Hello, I'm working on a Retina Macbook with OS X El Capitan, FM14 Advanced. 1. I can't enter tabs in the edit window. When I try the cursor jumps elsewhere in the workspace. 2. I get flashing when in the workspace, like a screen refresh.

I have the following script: Set Variable [ $_file_path ; Value: "file:" & Get ( TemporaryPath ) & GetAsText ( AdArtwork::AdArtImage ) ] Export Field Contents [ AdArtwork::AdArtImage ; “$_file_path” ] Send Mail [ Send via E-mail Client ; With dialog: On ; To: InsertionOrders::Email ; Subject: InsertionOrders::Company & " Ad Proof - " & Projects::ProjectName ; “$_file_path” ] This works perfectly on OS X 10.11.4, FileMaker 14.0.4 with Mail.app 9.3 as the default mail program. It also works for at least one user who has Outlook as their default mail program. Another user, however is complaining that, while the Outlook icon bounces in the dock, no n…

Hi guys, This is a question i first posed in the relationship forum, but i think it's much more of a scripting question now. I need a script that when i click a 'generate job' button will create a new record in the job table and populate the job line items table with certain fields from the quote line items table. The best way to explain this is with an image, so here goes... I started off thinking about this in terms of lookup fields, but that didn't seem to work. I've read elsewhere about a 'set field' function that could work with a global variable set to the quote ID, but i'm unsure how to execute this. Basically, i need the Category, D…

I wish to create 10,000 records with a random number between 735234 and 736329. Actually, I want to generate these records as dates between 1/1/2014 and 12/31/2016. I used numbers thinking it would be easier to script. Numbers (or dates) can be repeated, the only criteria is that the record set be random. Any ideas how to proceed would be appreciated. Purpose of this request: To generate sample data for charts.

I have a data base of records I do a search for the found set I need then I try running the following script but it only duplicates one record. What's going wrong? I checked and the records are starting at number one. The only record that gets duplicated is record one. Here is the script. Loop Duplicate Record/Request Go to Record/Request/Page [Next; Exit after last] End Loop Any help would be appreciated. Thanks in advance.

How do I do a Filemaker script that deletes a file in Filemaker Go ?

Hello, I am gonna describe a scenario where total automation needed using only barcode scan, please bear with me: I am creating operator timesheet layout for product lifecycle in list-view. Each operator has a list of unique barcodes(printed sheet) for each production function. Every activity(function) of print production is assigned code (barcode) that represents function type as well as operator name: For eg. if John is working on new plates function for Press he'd scan barcode 301-1 but if Marc is working on the same function , he'd scan 301-2 , Now '301' represents new plates function and number after hyphen(-) represents operator. In John's case 1…

It seems that the way I have implemented Virtual Lists bogs down on large ( 10k+ ) record sets. Building the $$data variable works fast enough ( LAN, 7 seconds for 2k records to 13s for 3k ), but then building the $$col variables takes what seems like exponentially more time ( 11 seconds for 1K records, then 41 seconds for 2K records, 82s for 3K... Is there a way to improve the performance?

The script which I am using (kindly provided by another user) is: "http://www.publishersmarketplace.com/pm/search?ss_q=" & Contacts::First Name & "+" & Contacts::Last Name & "&ss_c=dealmaker" Using this script, I am able to generate the URL that I wish. The URL is different depending on who I am searching for, and as such each URL is unique to a specific record. I currently have a field set to perform this script - the problem is creating a button capable of going to this calculated URL. Trying to enter it as the URL to go to leads to me searching for Contacts::First Name rather than the desired first name. I am unsure of how to go forward…

I have two tables Temporary and Real, the procedure is that contacts are created on the temporary table, probably by the contacts themselves. then once they have been confirmed as Clients (ie after their details have been verified by our staff), I would want to move them from the Temporary table to the Real table. Please how can I achieve this?

I am trying to copy selected line item records from one table to another as part of an intended 'recurring transactions' structure. For some reason if I perform a find on line items for that transaction and attempt to import into the recurring line items table it wants to import all records (12000) and not the found set (1-20) as I would expect. I have just conducted some tests with other databases to confirm I have an issue with this database only. The test databases would only import the found set from table to table as expected. Is my db corrupt or is there some setting somewhere thats changes this behaviour? Any help would be appreciated. FM13.

Hello Friends , How we do get the list of previous dates transaction made by selected portal row item of selected customer in portal table.

Hello friends, I'm new to FM so if this topic isn't in the right section. I'm sorry for that. I have a small database that contains 3 tables. In on of the layouts you enter data about activities a client does. I'd like a button on that layout to go to the client record. Witch of course is in a client table. I used the standard script functions Go to record DB_GV_Clienten::Naam & DB_GV_Clienten::Achternaam Thanks in advanced

Hello, I am looking fr a way to script the otherwise manual process of going to a particular record whose number you happen to know already. In FM 14 Advanced- i go to records menu and pull down to "Go to record..." and then click on GoTo... in the submenu. I am then presented with a little dialog box which allows me to put my record number and off I go to the record. How do I script this ? I will be hiding the menu tool bar area in my solution so I wanted to put a button on the layout that would duplicate this functionality ... but cant find the step that pops up the dialog box ( NOT that dialog box, but the little one we were just talking about). …

I am using the MasterDetail layout from Todd Geist in a couple of places in our database. By default this layout loads the first 2000 records into the MasterDetail portal. In order to save time and bandwidth I've added some logic to perform a find for only active records on the first navigation to the layout. This OnLayoutEnter behavior is only done for the first navigation to the layout, because I don't want it to interfere with any found sets the user may have isolated on subsequent navigations. I've also added an OnModeEnter script trigger to detect entry into Browse Mode, which successfully squelches this auto-find behavior in the event a user navigates to the layout …

I'm creating a simple system to update a remote FM file from an android device, using Cellica Database". http://www.cellica.com/Products.html An ODBC connection has been created, and I can add, modify and delete records in my FM database from my android. I want to trigger a script in FM when a field is modified via the ODBC connection. None of the native FM script triggers work as they are dependent on layouts or user actions. I have tried DoScript, Scriptmaster and EventScript - using field validation. All work OK if I modify the value within FM, but none trigger when the value is modified via ODBC. With EventScript and DoScript, I get a failure message on the…

I am trying to have FMS run a script in a db server side by the client pushing a button which runs a script from the client machine. I had the idea of using a URL to accomplish this - cannot get it to work - anyone have any ideas? http://ipaddress/fmi/xml/fmresultset.xml?-db=DATABASE&-script=SCRIPTNAME

I have a layout with a portal with contacts and a second child portal for contact notes. I would like to save the last child row that was selected for each contact and to be able to go back to that child row when a given contact is selected. I am able to save the last child row visited by running a script trigger on OnObjectExit on the child portal. Set Field[ Contacts:LastRowNumber ; Get(ActivePortalRow)] I am able to retrieve the correct child note by attaching this script to the OnObjectEnter on the Contacts parent portal. Go to Object [ Object Name: "NotesPortal" ] Go to Portal Row[ Select; First ] Loop Set Variable [ $rowposition; Value:Get(Activ…

Hello everyone I am currently working on a database, which HR-Managers can access via WebDirect using login-information, to accede or resign their employees. I have made 6 possible option types for the HR-employees to enter data into, set by an unique ID, but with the use of the same fields. So... X fields with option type 1 (Accede) Y fields with option type 2 (Resign) Z fields with option type 3 (Maternity leave / leave) .. Etc. 6 option types in total. Now, based on my project description, a couple of the fields will h…

I am writing a script that I need to use the "Go To Field" is the fieldname specified in a global $$Fieldname variable? Any ideas? Perhaps there is a different scriptstep that I should be using? :B

I am getting an error viewing .pdf and .docx files from a container field. There is a button next to the container field that calls the following script: If [not(IsEmpty(Attachments_C::Attachment))] Set Variable [$Path; Value: Get ( TemporaryPath ) & "/" & GetContainerAttribute ( Attachments_C::Attachment; "filename")] Export Field Contents [Attachments_C::Attachment; "$Path"; Automatically open] End If This all works fine with Filemaker Pro - mac and pc. If I access the container and save the file(s) to the launch center, I can view both types of files using IOS 9.3.1. Using…

Hi Everyone- We have a wonderful updater for our vertical market product that is incredibly fast and visually clear. It basically imports all of the customer data into a clone which is delivered from a container. Once the clone has received all the user data we want to rename the old copy ( and put it into an ‘Archive’ folder) and the rename the new version’s copy. We use Nick’s Base Element plugin. On the Mac it works flawlessly and fast. On Windows, it always fails! Grrrrrr. Apparently, in our script, ‘Move and Rename’ which moves and renames the two files, the script causes the two files to open. And on Windows, an open file can not be renamed or moved.…

FM 12 Adv. Finding the latest record in a found set is straight forward, however I would like to identify the last record in each subset of a found set. For example, suppose the records have name and date fields. A found set contains 12 records: 4 John records, 5 Mary records, and 3 Fred records. I would now like to loop through the found set and identify the latest record (by date) for John, the latest record for Mary and the latest for Fred. I would then create a new found set of only these 3 records.

I am running FileMaker 14 on a Win 10 machine. I have a set of records that each have a field with a starting number and a field with an ending number. I have to perform a find that locates the record where the find criteria is greater than or equal to the starting number AND less than or equal to the ending number. I need to write a script that will just let the user enter the find criteria in a edit box and then go to the record. This will theoretically be only one record that would match from the dataset. Can anyone point me in the right direction with this? Thanks RDW

Hello All, This may have been addressed before and I am very new to scripting in filemaker. Basically what I am trying to create is a script where I can find records from a carriage return separated list. I have created a field and a button to execute the script. For Example: If I have 50 records for every US State, in the field I could put: California Nevada Oregon Thus populating just the 3 records. Any help would be greatly appreciated.

I am scripting the import of data into some 400 tables already established. I have the corresponding 400 seperate data files (excel cvs). The script step "import" doesn't seem to allow the selection of the "current table specified by the layout" as a target. I goto the different layouts right before the import but the import does not change to the table that is used by that layout. When writing the script I do select the "Current Table "mytable" " as the target, thinking that this would change during execution. Nope it don't. Soo, 1) Can I have a dynamic selection during script execution of target table for data imports. 2) How does FM select the table when doin…

I have a field that is a List of values I want to match records to. The field in the target table is also a List values. So my search parameters might be this list "A|B|F" (pretend | is a new line making a List) and my target search field might be "A|G|N". Since they both share the A, the record should match. I tried looping through each item in the search parameters list and doing a Perform Find on each, but each find overwrites the last. Apparently multiple search criteria do not add to the result set unless part of the same Perform Find. I tried some creative Find Requests like OneField = Length( FilterValues($SearchValues, ChildStatuses) ) > 0 - wher…

Hi! I've inherited a filemaker v11 database and I want to merge double records. The database consists of two files linked by a unique ID (social security number). Unfortunately layouts from one file happily use data from the other file and vice versa. This has led to the current situation where there are doubles, with one person having one record in file2 and two records in file1. Neither of the doubles in file1 is empty, they use the same table but are in essence two half-records, one with data from the layouts in file1, one with data from the layouts in file2. Additionally there's some extra overlap with non-identical values for the same field. So to get rid of dou…

When I set a variable this way: Set Variable [$StudentIDs = ""] the actual value of $StudentIDs is 0, not empty or blank. So it fails the IsEmpty test. Is this by design, it is a bug or am I doing something stupid? - Brad

Hi Is there any way of executing a file from the database. AS you can see I want to go directly to the file/image at the location on my computer so as to edit or whatever. Thanks in advance for any help pyorkie

Hi Forum, I am working on a script to be triggered when a field is modified so that it can pull data and update fields on a layout. Some data is in another file and i do not know if possible how to access this file and search for the data i need? Any thoughts on how to accomplish this? Thank you for assisting, Miss-Amen

Hi, everyone. I need help creating a script to trigger when a Container field is modified, as in existing contents is replaced or deleted. I would like a custom dialog box to prompt the user if they really want to modify the Container field which has already been populated with content. If they select "OK", the changes are made, but if they select "Cancel", the changes are not made to the Container field. The reason this came up is because I want to prevents accidental delete or replace of a container field's contents via the "drag and drop" feature that FileMaker has. A user can easily hit the delete key while resting on the field or drop a new file onto it w…

Dear FileMaker Pros, Perform Script on Server (PSoS) Doesn't Run I run FMP 13 (on Windows.) I import records to my Hosting FM Server from my Client. Running the script steps from the Client works well, but its a time consuming task of more than 4 hours, the records are big, almost one million. To save time, I switched the script to Perform Script on Server, (wait for completion, unchecked.) The script does not perform Import records, as it did without PSoS. My script steps on the hosting Server Db: ScriptName:"Import A" > Go to Layout ["Part_A"] > Go to Field [Select/perform; Stock_A::Field_A] > Go to Record /Request/Page[…

Having recently upgraded our Outlook, we are now running into the error where the Send Mail script step causes Outlook and FileMaker to freeze. I found the suggestion to use the Open URL script step with mailto, but is there then any way to insert the value of database fields into the Subject or Body of the email?

What are some favorite places to read about best practices in navigation for a FileMaker file? In considering the task of rebuilding a file, I'm guessing we need to rebuild in a specific order (1, import tables; 2, re-draw relationships; 3- value lists; 4... import scripts or layouts -- that's where we get stuck). It seems like the ideal situation would be to only have a few scripts that reference any layout. Almost no layouts would use steps "go to layout" or "go to related record" --- only a navigation script would. Do you agree? Before go down that path, I'd like to learn more about it.

Not sure if this is the right area to post this. I need to be able to create a number of records based on 2 numbers I enter. This will be something like : 0123-0001 to 0123-0035. I would like a new record for each number i.e., 0001, 0002, 0003 etc. How would I do this, or are there any examples anywhere? Thanks in advance for your help.

I am wondering how one would go about listing missing values in a group. I have a group of records that are assigned a value in a field called Incidental, for ease of use, 1-20. I may have 12 records with the value of 1, and 3 with a value of 2, none with a value of 3 or 4, 2 with a value of 5 and so on. Some records won't have a value at all in that field. I need to know if there is a way to generate a list of the numbers between 1-20 that do not have a record connected to them. Is there a way to poll the records and get a list of that? I created this script: Perform Find // Shows only records that have a value in the Incidental Field Sort Records // Sorts th…

Hello, i try to delete a paragraph or sentence if it contains a sting for example in this field i would like to delete all sentence containing string "romeo" so the result should be : Thanks you

I have a button on a portal that calls a script "Show_Container": Line 1: Set Variable [ $Param ; Value: Get ( ScriptParameter ) ] (name of container field is passed thru script parameter) Line 2: Set Variable [ $Path ; Value: Get ( TemporaryPath ) & GetContainerAttribute ( $Param ; "Filename" ) ] Line 3: Export Field Contents [ Table::Field ; ""$Path"" ; Automatically open ] Wanting to reuse this script in multiple places, I need to be able to replace the "Table::Field" in line three with a variable, but can't see how to accomplish this. Any ideas? Thanks, John

Hi All, I want to have a few options in a custom dialog based on a related field. I've been able to successfully get only one option to work using If/Case function (based on the first related record), but the other option does appear. Let me explain a bit more with an example: TABLE A - fields: Primary Key TABLE B - fields: Foreign Key, Menu Line Item I want to have different buttons appear depending on the menu information returned. I want to have a custom dialog button labeled according to what the relationship returns. Let's say the first person, call her 'Hungry Henrietta', chooses "Appetizer, Entree and Dessert" and another person, 'Sl…

I use the Insert Picture in a script to place the contents of an image file into a container. Under FMP14 I'm seeing a very brief message whenever the step executes. The message title is either "Insert File" or "Inserting". I have seen both. But the messages are so brief—just a flash—that I can't determine if there is more message content. I don't recall seeing them in earlier versions and there is no message option listed for the script step. Are these considered "standard FileMaker messages"? ... or could they be coming from the operating system? If they're FileMaker messages, can they be disabled? I'm running on Windows 7 Pro. Thanks in adva…

i am trying to write a script which fires on the first of the month. but it always fires no matter what the date. trigger birthdays send If [ Date ( Month ( Get (CurrentDate) ) -0 ; 1 ; Year ( Get (CurrentDate) ) ) ] Perform Script [ “Birthdays report this month” ] Else Exit Script [ ] End If

i used the get (temporarypath) to save a layout as pdf to send to its recipient, however started to get the attached error message it then skips this script step and creates mthe email with the attachment. Any idea why this is happening and how i could rectify it?

Hello friends, I want such an script which can increment the dates From the existing date in a portal row by button switch.

Hi - I have a table - call it main table - in which the key field is a calculated fields and is a concatenation of 3 text fields. I then have a sub table with the same structure. I am trying to add records to main table from subtable where they don't already exist in maintable. I do this by relating sub table to main table by the key field. My script loops through sub table and where get(lasterror)="101" (ie record is not in main table) I add the record to maintable. Trouble is I can't update fields in main table. The key field is a calculated field so i can't set field directly - but I can't set any of the 3 text fields because FM tells me i have to set the key field fir…

Hi, I'm loading some data into filemaker and the date field is coming is as text (23 November 2015). During my import routine to move it from a temp table to the correct table I want to convert it to a proper date. I've used the following code but I'm getting a syntax error in my conversion. I know this is correct syntax for SQL so why doesn't Filemaker recognise it? Any help is greatly appreciated. TIA ExecuteSQL ( " SELECT LegalForname, LegalSurname, MiddleName , PreferredForename, PreferredSurname, UPN , ULN, convert(datetime,convert(varchar(30),DateofBirth),103) as DOB, Gender, House, RegistrationDate , YearTaughtIn…

Is there a script step to send a message to another filemaker user thats currently logged in? Thanks! Matt

I have script which writes order line products numbers to list in single record Preference table. like this 36 127 19 44 This is related to our product table as Preferences global_product_number = Products product_number and our crew views this list of products in a portal on layout from Preference. Script trigger on order layouts fires ever 3 minutes if Get(openRecordState) or Get(OpenRecordNumber) and layout object is "portal" and purpose is to keep that list updated with 'currently being built products' so the guys can begin to assemble materials and schedule crew. It is not always exact since sometimes a product is deleted from order_lines and I…

FM 12 Adv. How can I delete the contents of a container field with a script?

I imported several hundred movies The filepath field apper as as such file://Cleaner/Shadow 2016/ProRES HQ files/09-XII PRORES/MVI_0025-Apple ProRes 422 HQ.mov How can I create a script to open the Quicktime movie using QuicktimePlayerPro7 and setting the View to half size? I tried "openURL" but it gives me nothing. I dont need to export anything just to be able to see them, possibly in my second monitor (but this is not essential) Regards

Hi All, I am really stuck on a particular part of my project and was wondering if someone could help. I have sample of the script below (full script much bigger but this outlines the requirement) Set Error Capture [On] Set Variable [$Data1; Value: Table1:Field1] Set Variable [$Data2; Value: Table1:Field2] Set Variable [$Data3; Value: Table1:Field3] Set Variable [$Data4; Value: Table1:Field4] Go to Layout ["Delivery Notes"] New Record/Request Set Field [Delivery Notes::Customer ID; $Data1] Set Field [Delivery Notes::Ship To; $Data2] Go to Layout ["Delivery Note Items"] New Record/Request Set Field [Delivery Note Items::Quantity; $Data3] Set Field [Delivery No…

Hi guys, I searched a lot but coudn't find anything that could help me. I'm using filemaker pro 14 and i'm trying to make a script that can reset all the fields in a popout button. I'm thinking of something like Go to field (first field) loop set field ("") // or maybe clear (select), not sure go to next field exit loop if ( current field name = "first field name" thanks for your help! because setting the value to " " for each one isn't the best solution, thanks for your help!

I want to create a batch testing script and test 300+ fields. So, in this example, I will be testing how the data in field calc::avg_vol is performing, so I will try to replace field contents from field calc::avg_vol to calc::temp_field. I don't want to write a Replace Field Contents script for each of 300+ fields. Instead, I came across with such an idea: Put field names into separate field and then put it to a variable, like this: 1) Go to Layout (Fields) 2) Set variable ($Name; fields::name) (e.g. calc::avg_vol) 3) Go to Layout (calc) 4) Replace Field Contents (calc::temp_field; $Name) But the problem here is that it treats "calc::avg_vol" like a text…

Could I get some help on script to cycle through a set of values in a field. Each time I click on the target field I would like to cycle through a set of values; (Yes, No, Maybe and blank) and of course stop clicking when I get the value I want.

Hi the way my solution work is some of the field are selected via popup or dropdown. i want that once it is selected another user viewing the record should see the dropdown grey out - not clickable.\ pleasse advise how i could do that thanks

Hi All, I have a container field holding a pdf and would like to run a script upon a button click that opens it in its native program or app. in this case Adobe Reader. Can anyone help with writing a script for this? I am lost and very new to FMPro. Cheers Simon

Hiya, 1st of all - I have personally refrained from posting for help on a forum as I wanted to try and read, learn and solve my problems using trial and error! I am learning the FMP platform from scratch and am currently in week 2 of it. My question relates to a file I have attached to this post - the products area. For each product I have a number of 'size options' within it and each with their own unique SKU (stock keeping unit). Each SKU needs its own barcode. My job now is to produce a method to easily assign an 'available' barcode to a specific SKU. Barcodes are purchased from GS1 and are globally unique. I have a table hosting a pool of barcodes tha…

Hi, We have a database which runs calculated applescripts to create customised Excel files. I have a test run of 890 records. The original Filemaker 11 version takes 13 minutes to complete. The converted Filemaker 14 version takes 56 minutes to complete. I have moved the files from the server to my desktop. Both tests have been done from the same computer (MacPro6,1 MacOS 10.9). Other than the conversion to v14, the files are the same. What have I missed? Does FM14 treat applescript or calculations differently? Thanks in advance.

I've have searched and searched and can't seem to find an answer. So here we go. I have two tables; "In House Jobs" and "Paper Catalog" with the following fields. In House Job Table consists of Paper Size Paper Description Cost Per Sheet Paper Catalog Table consist of Paper Size Paper Description Cost Per Sheet They are Related by Paper Size = Paper Size When I am in In House Job table I select the paper size from a drop down. Once a size is selected the Paper Description drop down changes based off that size. The lists are being looked up from the paper catalog. Once I select a Pap…

Hi There, I have a script that populates a table with StudentID based on a value list I created. This works fine when creating new records. Such as for a new weeks register. I click a button and it populates the table with a new week and all the pupils are added. Now I want the same script to function in a different table but I don't want it to add all the pupils every time. I only want it to add new pupils. So I need a step in the script that checks the table first to find records that already exist and then add only the records from the value list that are not in the table. A picture of my script is attached Thank you for any help.

Hello All, I have a script that passes a url to an IP/PBX (Sipxcom) which will then ring the user and once the user picks up the phone, will place the call to a phone number the user clicked from the FMP CRM. Its pretty slick. My only issue is that I cannot get httpost or httpspost to work. I can get the script to work correctly with Troi URL plugin from both client and run on FMPA Server. Here is the syntax for the Troi plugin (which works): TURL_POST("";"http://mydomain:6667/callcontroller/"&$userextension&"/"&$dialednumber&"?"&$userpw) Here is what the Wiki say from Sipxcom http://wiki.sipxcom.org/display/sipXcom/Configuratio…

Can a script be created that will show me the time created when sending emails?

I want a second floating window to open next to my "regular" window when I change to layout DocketForm and request a new record. . My script for this seems to work well enough to have both windows visible. I am using FileMaker 12 Advance on Windows 7. This is the script: Got to Layout ["DocketForm (Dockets)] New Record/Request New Window [Name:"OrdersPortal"; Height: 500; Width: 600; Top: 40; Left:500 Show/Hide Toolbars [Hide] View As [View as Form] The only problem with this part is that the new window appears immediately and the main layout window does not change to new layout (DocketForm) for an unacceptable period of time. My mai…

Hi i would like some help i created a manufacturers database, each ingredients has a unique 10 letter/number code. i want that if the code is already in the system it should tell the user the ingredients is already in the system, i don`t want it to replicate. please can someone help me script this to detect that.