Script Workspace and Script Triggers

Hi everybody! I have to create a custom login page for my database too. I know that it's unsafe, but I need it only to set different access to some users. I'm sure that the original program screen already does it, but I need a solution more attractive. PS: sorry for my bad english

Im little bit confuse how the invoice number works what i want is if i click the generate invoice it generates an invoice# but when i create a new record the invoice# should be empty

I'm trying to figure out some keyboard combo to take the user to the global field to receive the data to be inputted from a barcode scanner. What I'm trying to do now is enable a batch scan process, instead of doing just one at a time. I read somewhere else of someone using Shift-CapsLock on a keyboard to launch a trigger to go to the global field, I just can't get my head around the differences of the Get functions; TriggerModifierKeys, TriggerKeystroke and ActiveModifierKeys. I just want the user to be able to click a keystroke(s) on the keyboard and then start scanning the items in and when they are done that, they then click on the keyboard enter button and the work i…

Hi, I'm trying to get an on object modify script trigger to run on a global field that receives input from a barcode scanner. Is there a reason why the script doesn't fire? I've also tried using on object exit trigger, and placed within my script the step to go to another field or object to try to get it to fire but that doesn't work either. I have to physically click outside of the input field for it to fire the script. The scanner was placing a paragraph return at the end of the code and I removed that, but it didn't make any difference. I'm brand new to bar code scanning as well so if there is something obvious I'm missing here let me know. This is…

so, i've got a fairly easy problem here that for some reason is stumping me. Â figured that you guys/gals could help me out. Â basically, this is what's going on. Â i've got a database that stores default images in container fields. Â they are grouped by an id, but i have multiple id's that are duplicates. Â basically, i have and id for product A with an image for one item, then another product A with a picture for a different item. Â basically, i'm wanting to find a way to bring all product A records into one. Â i've attached an image for you to see what i mean. Â what would be the best way of doing this? Â Â Â

Hi- I have a container field which stores links to image files on my HD. I'm trying to write a looping script which will open all the files linked from this field in a given found set. I can do the finding and the looping but I'm stumped as to how I get filemaker to open the files themselves. All the script steps I can find seem to be for opening other filemaker databases. I'm using FP12 with Mac OS10.6 Any help appreciated. Thanks Jon

Perhaps someone can assist with the best way to resolve this problem... A simple database with two tables having a parent child relationship MANTA CATALOG < MANTA SIGHTINGS. MANTA CATALOG has only one record for each individual manta ray in the database but that manta ray may have been seen on multiple occasions (MANTA SIGHTINGS). Users will enter their sightings each day in the MANTA SIGHTINGS table with a photo of each animal sighted and add a value list of "pending" in a "photo status field". Eventually, those photos need to be matched against the catalog to see if they are an individual already in the catalog seen repeatedly (status field = Match) or this is a…

Hi, first off I'm using FM11 so it's not super containers I have stored the reference only to several thousand files (mainly pdf and zip) for which the path has been C:/mypath .. but we are upgrading our systems so I can't use the C: drive anymore. Is there a way to change the path to E:/mypath ? thanks

I have a value list $$List with 5 values and I want to assign those values to a repeating field with 5 repetitions. If I define a calculation field with 5 repetitions, I can set the values of $$List to the field successfully with: GetValue($$List; Get ( CalculationRepetitionNumber )) However, if I define a text field with 5 repetitions and use Set Field to assign the values, the same formula does not work. I have put Get ( CalculationRepetitionNumber ) under Repetition of the field to be set. However, the value of Get ( CalculationRepetitionNumber ) always remain as 1. How can I get it done? Is there a simple way to clear all the repetitions by calcu…

Here's the scenario: We have a database that has multiple related files, It was originally created with Filemaker 5 by someone else. Over the years I have modified it and created tables etc... and taken advantage of some new features. The company has never had the resources to have me restructure their database. That being said here is the issue now. They have started a new company and they want to use a clone of the existing database as is... I have created clones. Renamed files, changed the names of the external data sources etc... Both of these databases will be hosted on their filemaker server concurrently. They are currently using FMS 9. There are so many scripts tha…

Please help the NEWBIE !! Ok, for some strange reason, I can't seem to do the easiest thing .... I have two fields: FieldA has 2% in it FieldB has 3% in it I want to simply show the Total of the Fields that are Calculating, at the moment it shows 5% I did this by creating a calc field that adds one from the other, but I need it to deduct it from 100% so it would look like 95% HELP !

I need a script that after it's triggered it will pop a message up that tells specific information about a customer. Example. I have a customer named Martin Sprockets. When we ship parts we need to send an invoice to a third party for billing. This step gets missed frequently if our shipping manger forgets. I would like my system after making a shipper pop up and state that information so my manager will no longer forget. So basically I need whenever certain customers name are chosen for shipping if there is a note in the customer note area this will pop up and state that note after a script such as print has been triggered.

Hello, I'm using a script originating from the Filmaker website that is suppose to do exactly what I need: http://help.filemaker.com/app/answers/detail/a_id/3441/kw/finding%20duplicate%20records Show All Records Sort Records [specify sort order, Perform without dialog] Sort by Client ID in ascending order Go to Record/Request/Page [First] Replace Field Contents [Perform without dialog, Specify target field 'Mark', " "] Loop Set Variable[$id,'ClientID'] Go to Record/Request/Page [Next, Exit after last] If ['$id = ClientID'] Set Field ['Mark', '"X"'] Else Set Variable[$id,'ClientID'] End If End Loop Perform Find [Restore] Find …

I have a Contacts Table and an Addresses Table within FM12 Advanced. Each Contact can have multiple addresses flagged as Home, Work, Billing, Etc... I need the following behavior to be implemented: 1. Only One Address can be the primary address with all the other ones automatically flagged as Secondary. 2. When the first Address is created, it is automatically flagged as a primary address. 3. If there are multiple addresses, only one can be Primary. 4. When an address is changed to primary, all the other addresses related to the particular contact must be changed to secondary. 5. When viewing the related addresses within a Portal in the contact Database, They mus…

Since upgrading to FM12, I've been looking to utilize a simple lightweight sorting script to handle any field. What I came up with was a system where I give the field object in the list view a name, then passing this object name into a very simple script when clicking the header to do the work. The script looks like Set Variable [$object; Value:Get ( ScriptParameter )] If [$$sort_object <> $object] Set Variable [$$sort; Value:True] Set Variable [$$sort_object; Value:$object] End Go to Object [Object Name: $object] If [$$sort] Sort Records by Field [Ascending] Else Sort Records by Field [Descending] End If Set Variable [$$sort; Valu…

Hello I have a json date i get from URL and i whant to extract date from it. That data is lan and log. how can i do it.

Hello All,,, I have a problem with my script. This script identifies possible duplicates among members in our database. For Example: If when entering data if a member has the same last name and same zip code as another member then they are both identified as "possible duplicate" and then we can check to see whether they truly are the same member or not.. This will identify 2 or more. There could be 5 members with the same last name in the same zip code. Obviously if there is not a possible duplicate then we don't want the member to be identified as such: My script works good most of the time but I have identified a problem and need help. Here is the probl…

I am wanting to create a search box that as the user types in a field the results change in the portal. The catch is I would like it to work on an existing layout so the user doesn't have to switch to a find layout. I tried searching the forum but can't seem to find the answer, which I am sure is here somewhere. Thanks Thom

Hi All - I have a situation with a single client, so far, where FileMaker drops characters as the user is typing in a field. The layout the field is on has an OnLayoutKeystroke setup that calls a script that does some very non-intensive checks whenever a keystroke happens. I even went so far as to remove all steps except an "Exit Script" step and I was able to reproduce it. If I remove the OnLayoutKeystroke trigger entirely from the layout, all works well. So, I feel like it definitely has to do with the trigger. This does not happen with the same set of files on our local computers or on other clients that have the same application installed. Any…

Hi, I have a membership application which has a MembershipCandidate table. Each 'candidate' is coached by a Member. Part of the candidate record has the name of the coach along with the coach's phone number. In the table I have a CoachPhone field that is a lookup of the indicated coach's phone. This works great. The problem: When the coach's phone changes, the change DOES NOT get reflected in the Candidate report which shows the Coach's phone. I know lookup do not 'refresh automatically' so I tried changing records. No help. What works is 'reselecting' the coach's name from the dropdown from which the name is selected. Question: "Is there a scri…

Is there a way to trigger a script after a (portal) field value is committed? All the script triggers seem to run before the value is committed and so any set fields or insert calculations steps refer to the prior field value, not the current, active value. For example, I have a standard invoice layout with line item records in a portal. On the invoice record is a subtotal field. It is not a calculation and so requires a script to update it. I'd like to update this field each time a unit price is changed. Right now, I have it updated by using an OnObjectValidate script with the step Set Field (Invoice::Subtotal; Sum (Lineitem::UnitPriceExtended). For the subtotal…

Just wondering, for all you geniuses out there.... I have come across a spreadsheet conversion project to FM12 and in a formula on the spreadsheet they "Exclude Sundays" as a workday, So, if a job was scheduled (i.e. Calendar drop down) and it fell on a sunday, the script would "Bump it" a day, to never fall on a sundays..... hope that makes sense..... Is this easy to do with FM? Thanks -sr

I have a layout that I want to run a script that will do a find and only return certain records when it is switched too by choosing in the Layout dropdown. I tried using OnRecordLoad but that created a loop I couldn't break out of. My script was. Set Error Capture[On] Enter Find Mode[] Preform Find [Restore] If[Get(LastError) = 401] Exit Script [] End If Set Error Capture[Off] What I am struggling with is that there will be times that it will return zero records and then my plan was to add a script step to add a new record if that happens but haven't got that far yet. Thanks Thom

I have commissions that range from a few pennies to hundreds of dollars. I calculated the commissions with a simple formula and it gives me the commission amounts. I want to set a minimum commission of, say $15 and a maximum commission of $75. I used this: If ( BRBW Comm < 15; 15 ) and got all commissions < 15 to be set at 15. However, I wasn't able to add to that the part about if the commission is > 75, set all those to $75. Not sure what to use the Case or the If statement. Also, I would like to learn more about using scripts. Can you suggest a good resource for quickly learning scripting formulas? Thanks very much! …

This one has me stumped. I'm trying to use a web viewer in FileMaker 11 to look up a value from a website. I then use that value to find a record set and email the results. It works when I do it on the client, but when I run it on the server as s scheduled script it does not get the value. I also tried doing it with a startup file to trigger the script from a Windows Schedule and that failed as well. In order to simplify it, I set the script to just lookup the value and email it to me. Current script: The loop is to allow time for the page to render. I've tried upping it to as much as 1 million and still no luck. Again, this works when I run it from t…

Guys, The old guy trying to learn new tricks.. I am trying to devise a little help for a friend. The problem : A layout with a map pasted on it. On this map I need to set buttons with names, and want to see related record windows popup when I click the button. The layout is in the same database the record I am looking to visualize. I tried several way, but I only get the first record in the list.. I may not be smart enough for the task..! New to FMP 12, and not really familiar with triggers capabilities...!! However I am wondering how could I do to have the button name taken into consideration by FM and popup the window the correct record. Thanks in adv…

I'm bumfuzzled. I have a script with a show dialogue box utilizing the data input fields. Whether anything is entered, or if the fields are left blank, once you click the OK button, I get an error message that 'this action cannot be performed because these fields are not modifiable.' I have the set error capture script step on in the script. I've checked my security setting on these fields and they are modifiable. (They are global fields.) I've checked the fields directly on the layout, and they are modifiable. I've tried it with the admin level, still get the same message. Any ideas what is going on here? Thanks for any help.

This is a client request for an existing database. My client wishes to have the drop-down list for Field B displayed whenever Field A is exited. I had thought this would be a simple solution: OnObjectExit trigger on Field A calls Go To Field ( B ) script. However, in practice, this does not work. Stepping though in Debugger, the script does go to Field B and displays the drop-down menu, but then immediately exits Field B. In real time, the drop down menu is never displayed, because Field B is exited immediately after it is entered. NOTE: This occurs when exiting Field A with a mouse-click. I have already set the Tab Order so that Field B follows Field A …

I am assembling a script to find a criterion, export the results to excel ... I've done this but I have 50+ criterion to search and save out to excel. Is there a simple way of doing this? I'm having to cut and paste, change the criterion and output file name etc. Thanks! Lance

This script works fine when manually activated but doesn't work as the target of an an exit object trigger Go to Portal Row [select; Last] Go to Field [Checkout Line items::scanned barcode] Any ideas Thanks Paul

Ok, just wondering... If one would like to filter a portal with multiple "Strings" would one use a "If" or a "case" I am trying to Filter on 3 items and using the "Case" statement I'm only able to achieve 2....... Help ! Here's what I have so far Case( InspectionWork::Sample Complete="Complete";""; InspectionWork::Sample Complete="Revising" ) if I put a 3rd in like (On-Site) ...... it doesn't do its JOB !! why only 2?

Hello, I have a project table which can have many related quotes, but only one quote can be accepted. On the quote layout I have a quote status field with a drop down list of values like, prospect, estimate, accepted... I have a calculation field on the project table that counts how many related quotes there are that are accepted. On the quote status field I have an on object modify script trigger that sets the project status based on the changed quote status. I've tried to add to this script the condition that if the user selects "accepted" and the project accepted quote count = 1 then they are shown a dialog box that only one accepted quote is allowed …

Hey everyone, this has probably been covered in another thread, but I couldn't find one based on my search so I apologize if this has been incessantly covered under some title I didn't think of. I am trying to make it so when a user enters a certain description the instruction field is automagically filled in with basic instructions associated with that description. So for example you could have a drop-down field with the following descriptions: simple cream complex cream suspension and then based on the selection the user makes the instruction field (a text field) would be pre-filled with a set of instructions: If the user selected simple cream it w…

Hey guys Trying to implement some keyboard shortcuts into my database. Right now, for example, I'm trying to give the user a keyboard shortcut to close the active window and perform the other necessary scripts that I have run when the user clicks the "Close Window" button. I've managed to get the window to close after the ESC key is pressed: Set Variable [$code; Value:Code (Get(TriggerKeystroke))] If [$code = 27] Close Window End If However, I don't like that it's just the ESC (27) key on it's own. The ESC key is useful when the script is stuck in a loop, among other things. I am looking to use the key combinations Ctrl+Q (or Command+Q for Apple) to execute the…

I'm building an issue tracking system. Lets say I have 100 records now and 5 people responsible for adding data. I want to assign a record to a user with him and the admins being the only people that can edit that record. Ideally I dont even want the other users to see records not assigned to them, but I want to keep it simple first. So when a user logs in, he can only edit records he was assigned.

Hello, In my ios solution I open windows to make my scripts go easier because then I can just shut a window down, but is it possible somehow to close all windows down EXCEPT the first one? So if u have 4 windows open and u push "home" button it shuts down 3 windows. and I have 1 left.

I have a file of records (this is a large file). It might look like this (just a short extract) - say there are 90 different 'refs': Fields: Ref Batch no. Description Cost $ 120 1 Yellow jersey 160.00 (this is in fact the total for the whole of Ref 120 e.g. 8 items so one might suppose that ea. item costs $20 each - in practise they don't they each have other values) 120 2 Red jersey 0.00 120 3 Blue jersey 0.00 . . 120 8 White jersey 0.00 130 23 White ha…

Is there an easy way to check whether a field is used in any scripts and/or present on any layouts? I have a database that's been around for quite a while and I suspect that some of the fields are no longer used/needed. I've determined that we don't directly need the data in these fields (either it's captured better elsewhere, or it was for a workflow that no longer exists), but before I go deleting them I want to be sure that they aren't (1) present on a layout somewhere or (2) used in a script.

In Australia, every city has a 4-digit postcode (zipcode) as part of its address. For example Canberra, our capital city, has a postcode of 2600. I am creating a database of disability organisations. The aim of the database is to allow users to enter the postcode of the suburb they live in and the database will find all disability organisations within a +10 and -10 range of the entered postcode. If the user entered 2112 as their postcode, the database should be able to find disability organisations within the postcode range 2102 and 2122. There will be a field called "Postcode" in the database which displays the postcode of the disability organisation. I nee…

Any customers of mine (restaurant or hotels) use ever the same product, so i'd like to populate invoice portal with only that customer product. I create a Customer price list, where i save product and prices of each customer. Example: Customer: John's Product: white napkin 0,30 €, blue tablecoath 2,00€ Customer: Hotel Milano Products: white sheet 1,00 €, white pillowcase 0,50 €, white towel 1,00€ Naturally any product is a record I also created a related Value list for product i already have the script, the problem is that in every portal column i see the whole product white sheet pillowcase white towel -------------- white sheet pillowca…

tables, there are 4 Where PN register Bills active, passive and payments Details payments (payment method, direct remittance, bank transfer 30 days from invoice date) and the data to create the deadlines (bank 30 days I will have a field "30" that high on the invoice date) Master (to match the mode of payment to any customer or supplier) and Deadlines I would like to insert a bill, and depending on the payment methods, create their respective deadlines. each due date a record, bank transfer 30/60 I will create 2 records in deadlines, first 30 days higher than invoice date, the secon 60 days after. how can I create the script? thanx

is there a Script for merge field for example if i click this button it merge the field information

I have an extimate layout that once a field in entered (onobjectenter) runs a script that pops up another layout for calulation purposes. The new layout accepts input for the calculation and should return the resulting value to the field and then move to the next field. When the script completes, the field remains empty and does not move to the next field. Do I need to use a variable to make this work or am I just going about this wrong the wrong way? Allow User Abort [ On ] New Window [ Name: "Input Dimensions"; Height: 1; Width: 1; Style: Dialog ; Close: “No”; Minimize: “No”; Maximize: “No”; Zoom Control Area: “No”; Resize: “No” ] Go to Layout [ “Dimensions” (Prod…

I am a newbie to FileMaker and use Pro 12 Adv with Windows Vista and Outlook 2007. I am creating my first DB and have an email function in it. I have tried with no success to create a script that will only send email if the email address field is populated. It seems that the script is not being looked at and the email will not work at all unless the "Button Setup" has been created. I have tried all the suggestions in the forums and other sites with no success. What am I forgetting? Thanks for all your help. Dave

I am using 'open URL' to 'post' data to a web-site. My script creates the URL for doing this. The browser (both FireFox and Safari) returns a 'Request URL too long' for some postings. It seems there is a limit to the url length the browsers will accept, although I have not been able to confirm. I could 'script' around this using multiple 'open URL' statements each posting part of the data, but each 'open URL' statement creates a new tab in FireFox. Have not tested on the Windows side but suspect the same result. Is there a way to suppress the 'new tab' result when using the 'open URL' script step? An 'endless' list of tabs to get the data posted is unacceptable t…

Hello, I need to remove text in a field which is separated by a ":". Is there a way of telling FM to use ":" as a delimiter and remove or replace any text that is following a ":" ? Thanks!

Okay... I am trying to remove a file using a calculated Path. Here is what I have so far. I have gotten the below Shell Script to work. "try¶ do shell script "rm -r /Users/en/desktop/dropbox/pip/Labels/FMFiles/Cable2.fmp12"¶ end try" What I am trying to get working is the Path of the File automated. The Filed below has the correct Path of the file. I don't get any errors when this runs. try¶ do shell script "rm -r _MASTER::FilePath & 'Cable2.fmp12'"¶ end try" Where am I going wrong? Thanks, ERIC

Hi i'm new in this forum, i'm italian and i'm sorry for my english. The question is this, i've a TO, where i save payments and invoices even for customers and suppliers. When i save a new invoice, i enter datas in this field: - Customer_supplier_name -customer or supplier (auto) -invoice number -invoice date -invoice amount When i save payment, i ente: - Customer_supplier_name -customer or supplier (auto) -payment amounts Now i'd like to create a script that take "payment amount" and set the first invoice wich is not "closed" an example occurred: #save invoices customer_supplier_name: PincoPallo customer o supplier: supplier (auto entered) …

Is is possible to have a script trigger when the value of a calculation field changes?

I currently have a script that pulls all US based off global dates and global center fields. It then omits certain results based off of the outcome "LTC". Is it possible once the report has pulled it's information to say "Ok now that you have these results, do a search for any other records including their Client number and case number?" Here is my current script in case you need it: Go to Layout [ “Test Report” (Client_Activity) ] Enter Find Mode [ ] Set Field [ Client_Activity::Center ; GlobalFields::GlobalCenter ] Set Field [ Client_Activity::Visit Reason ; "Ultrasound" ] Set Field [ Client_Activity::Visit Date ; Client_Activity::GlobalStartDate & ".…

Hi I have a Social Car DB which matches clients with a volunteer car driver to take them to various appointments. All is working well but I have a problem that I'm struggling with. It concerns the searching of the DB and the users of the DB being able to find some specific records between a set of record numbers (serial ID's) and then print the found records using a script. I'll try to explain in more detail what it is I'm trying to do. Every day new journeys are added to the DB Main Journey Form as clients phone or email the company and each journey consists of clients and their details, the destination where the client is going, times and dates and the driver an…

Im trying to create records in another table that is based on looping thru the Invoice line items of a specific Invoice. It is activated from a button on an invoice. Before the loop begins I assign the invoice id to a local variable. Perform a find on the line items table limiting the line items to just that Invoice. I than sort the line items by a specific field. The problem that I am having is the looping sequence only creates 1 record in the other table (from the first record in the line items found set)

Hi All My system uses "modules" which have additional windows that open out from it. I want to make sure the related module windows are closed before the user attempts to "close the module" For example: from the main menu the user can click "Lenses" which will take them to a list of lenses in a new window. The user can click the lens they want and it will open in a new window called "Lens QC {Name of lens}" I'm trying to prevent them from closing the "Lenses" module window while the "Lens QC ..." window(s) are still open. Each window has an Exit button. Currently I'm using this script (which I know isn't the best route to take). This script is attached to …

What is the correct syntax to include a field inside of the custom dialog? This is what I tried: "Are you sure you want to delete Invoice:"; Invoice::INV_Num FMP keeps telling me it expects and operator so I tried: "Are you sure you want to delete Invoice:" and Invoice::INV_Num but the resulting window would just show 0

In preparation for using Filemaker 12's new function "Install Plug-In File", in our current Filemaker 11 database, we created a new table with container fields for our plugins. We inserted the plugins for a PC with no problem but when we tried to insert a plugin to a container field on a Mac, Filemaker gave the error: "This file cannot be inserted because it contains other files inside it" We are not trying to insert the whole folder -- just the plugin itself. How can we insert a plugin to a container field on a Mac?

It is my understanding that a script can be set up to perform automatically what I’ve been performing manually. Can you give me some direction for the script. Let me begin at the beginning and I apologize if I'm giving too much information. I use a MacBook Pro running OSX 10.6.8 and FMP 12 Advanced. I use an Apple product called GarageBand. In GarageBand I import songs from iTunes and make what is called “Loops” which are selected parts of a given song. These song Loops are stored in; • Finder>Library>Audio>Apple Loops>User Loops> SingleFIles I go into the SingleFiles folder and copy the songs I want and paste them into Word. The Song Loo…

I modified a FileMaker12 sample database and removed the scripts it came with, none of which were applicable to my needs. I noted which actions they were connected with (I thought) and removed those buttons and reports. So, I have a "script cannot be found or has been deleted" message every time I return to one layout. I have gone through the help files and discussions on a number of sites, so I have checked 'File Options' to be sure there are no script triggers set to run, I have run a 'Database Design Report" which shows NO scripts, I have checked every item in the layout to be sure it is not calling/triggering a script and but can't determine why I am getting this m…

I have a database called attendance and i want to delete any duplication based on today date for same employee? I have a table called attendance report which will import from attendance table once i click on a button name WORK IN.  Thanks for your advise.  Regards,  Kishan

I wonder if it is possible to make a button that create in a predefined path a folder named with a field of database and a subfolder named with another field (ex. fields name and number create .../name/1234/) in OSX. And this button in case the folder already exists, then open it.

I have a contact -> equipment loan ->line items <- products    soultion.  In my line items portal which is on my equipment loan layout I have a item_In_Out field which auto calculates to say "Yes" if the return_date in the portal IsEmpty.  When a date is entered into the return_date field the item_in_out field clears.  This is so I can visually see which individual items are still on load per each Equipment Loan Order.  The problem I am having is portals seem to auto create a new empty portal row for you to begin entering new data.  When this happens the item_In_Out field auto populates a "Yes" because the return_date isEmpty whic…

Instead of taking my vitamin this morning I think I took a stupid* pill--I'm staring at a simple Let function as a script parameter and I just don't get it. I watched Matt P.'s fine video about the Let function and after the 26-minute presentation I'm still dumbfounded...which anyone can see: it's the classic FileMaker Pro 20-inch stare. (Twenty inches from my nose to the monitor.) Here it is: Let ($$deleteRecord = ADDRESS::_kpln__AddressID; "DeleteRecord" ) I get it that $$deleteRecord is equal to the key field ID number in the Address table. Fine...but after the semi-colon, what's the function of "DeleteRecord"? Is it considered the second part of a multi…

Could anybody suggest me a good way to trigger a script when the user is exiting the record? I need the database to check if a particular field has changed and IF NOT to trigger the script when user exits the record to remind him/her that this didn't hapen. At the moment i am thinking of creating a global field that would fill when record is modified then using OnRecordLoad to trigger the script that would warn the user in case that this field is not empty and further empty the field when the particular field mentioned in the first place HAS changed. Not the most elegant way to resolve this, i would think that there has to be some better way.

I have a container field where I store pdf files by reference. I'm trying to write a script that is triggered by OnObjectEnter which will open to my pdf folder. Here's what I have: Set Error Capture [ On ] If [ IsEmpty ( Court Calendars::Clerk's Calendar ) ] Set Variable [ $CalFilePath; Value:Year ( Get ( CurrentDate ) ) ] Insert File [ Court Calendars::Clerk's Calendar; “filewin:/o:/Court_Calendars/$CalFilePath/*.pdf” ] [ Reference ] End If I've tried using wildcards *.* for the file name, a dummy file name, and even no file name at all, but it never opens the intended folder. I was hoping that if I used a dummy file name which couldn't be found that my…

I have a file hosted on FMS 12 on a windows server 2008 r2 machine, serving up the databae to about a dozen users in the office, all but one of which are a mix of windows xp and windows 7. The otherone is the only mac we have in the office ( sorry Mac lovers ). Each work station has a an openner file stored on the local machine that opens the database remotely through an open script, then closes the openner file. It never was very pretty, but it got them there. Recently we had a new logo design and we're doing some design makeovers on websites and other things. So I was asked if I could make a nice splash screen with our new logo and improve the openning experience. I …

Hello, I am redoing a DB that was made in FM3. I am trying to determine what scripts are actually being used in the table and which ones are extraneous. Is there a report to that would tell me this? I've tried the database design report in FMPA12. It lists all the scripts but doesn't tell me if they are used. Any info is appreciated. space.... out EDIT: I found it in the report I mentioned above. For those that are looking for the very same this I was, create this report for the scripts. In this report, there is a field that says "Layouts that use this script" Ta Da!

Hi All, Â Got a weird problem for you today. I've got a global field on my layout, gScanSampleID, I use a barcode scanner to scan a value into it. The barcode scanner sends an 'Enter' keypress at the end of the scan, so I use the onObjectSave script trigger to run the script that does what I need to do with the scanned data. The only problem is, at the end of the script, I use a "Go to Field" to return to the gScanSampleID field, to make it ready for the user to scan again, but this isn't working! Â Nothing is selected, and I have to manually click into the field to scan again. Help? Screenshot of my script attached. Â Â

I would like for one of my databases to track the user's active or inactive status in FileMaker. My thought is that the tracking file needs to have a script which has a variable that gets updated with a "last action" timestamp sent from any of the open files, and an onTimer script that compares the current timestamp with the "last action" timestamp. When the difference in time exceeds a certain amount of time, the status is changed to "away", and when the user returns, the status is changed back to "online." I'm thinking that the simplest way to do this would be to have a script called "log activity" in the tracking file, one that any file that is open could call.. I'd …

How can I fire a trigger script base and a field change Before triggers existed, I used plugin ZippScript, in a calc field that called a script Thanks R

I have a script that calculates an area-weighted average for a selected set of records. The script calculates the correct result, but I'd like for the script to copy the result to the user's clipboard so they can paste it into another program. What I tried, and what isn't working so far, is that I created a global field, SCRIPTRESULT, and set the global field to the result. Then I used the "Copy" script step, with the "select entire contents" option checked. the SCRIPTRESULT global field is in the same table as the records the script is processing. Â Any tips for accomplishing this? Â Thanks! Â

Hi All, If then Statements are not my strong point. If anyone could point me in the right direction I would appriciate it. I have a script that looks to see if the person has already left his information at the desk. If so, when he checks out the clerks get a custom dialog box reminding them to send the customer to the other desk. Currently, if I click either "Ok" or "Cancel" it continues on with the script. I would like when the "Ok" button is clicked the script continues, if I click the "cancel" button it returns to the original layout. Below is my current script. Thanks everyone...MG +++++++++++++++++++++++++++++++++++++++++++ If [customer::ccInV…

Hi all! First off, I have been using FM Pro for about 15 years. While I designed basic databases, I never got real deep in. That changed this past week when I decided to re-design my main DB. This DB will contain injury records for high school athletes. I have been trying to grasp relationships for the last 4 days, and I must say, its been tough for me to fdully understand them. I did create a multi layer conditional value lists using a relationship, but I'm not completely sure how I did it though it works. Now I have a new desire. I want to be able to create a script button that does the following. If a specific injury is listed (in this case, a conc…

I am trying to figure out how to write a FileMaker script, using AppleScript, that will allow me to select a folder full of QuickTime video clips and import the following from each clip: Clip Length (duration in hours, minutes, seconds, etc, such as “00:00:08.67") Frame Rate (in frames per second, such as “23.98”) Frame Size (such as “1920x1080”) This metadata would need to be imported into each correct record in FM that matches the Filename. Can anyone please point me in the right direction?

I need to write a automatic start up script and I'm not really sure how. Right now I have a report that will calculate information from a set amount of records. You are supposed to put in a "Center" and a "Date" then click on my script "Run Report". I've found that whenever I'm browning records if I switch to that report it will fill in all the fields without my clicking of "Run Report". This can be a problem because there are almost 40,000 records. Is there a way I can have a start up script that has the report stay empty until I click "Run Report"?

I have a 'create new invoice' script/button which (using 'set variable' expression to insert current clientnotesID) takes the user to the Invoice layout ready for a new record to be entered. The script finishes with ; Go to Field [select/perform; Invoice::Date] .....to begin date entry using calendar wheel (iPad). I want to set the date field up so that when a date is selected, there is a check that the client visit doesn't already have an invoice for that date. (i.e. to stop the user entering another invoice for that particular dated visit.) I envisage a custom dialogue along the lines of: "An invoice for this client/date already exists. Use the "View …

I've run into a problem with a script when accessing the database through IWP. The script runs when users log on, and directs them to various layouts and sub-scripts, depending on their privilege set. The problem is that users with a Full Access privilege set aren't being handled properly: rather their treated like the other privilege option (Customer). When I access the database hosted locally on my machine, the script works in IWP, and there aren't any script steps that aren't supported by IWP. The script step reads: If ( Get ( AccountPrivilegeSetName ) = "[Full Access]" then go to layout, etc. I've placed a field on the 'starting layout' to show the Privile…

Hello, I was curious if anyone knows if it possible or not to script a download of a file using the "Insert from URL" introduced in FM12 in conjunction with some type of progress bar or feedback mechanism so the user knows that it is downloading or how much longer to wait? Thanks, Stephen

I need to create records from two lists of IDs. Every Line in $Types needs to create a record from first line in $Categories then another record for same $types and second line in Categories. After finishing first type, go to second and repeat. I can loop first list but get mixed up on how to loop second. I tried another loop but fail. Can someone give me script to create records from two lists like this?

Hi! Â I have a file with 'Check OUT' and 'Check In' functionality. I 'Check Out' a file from a container field to temp storage using 'Export Field Content' and 'Check In' from the same location(temp storage) using 'Insert File' after making changes. If I Check Out an Excel or Word file, and try to 'Check In' while the 'Checked Out' file is still open, I get the error 'This file is locked or in use.' (please refer screenshot) but the script does not throw any FileMaker error.(It works fine with Text file) How can I capture the error if file is open and FileMaker can not perform 'Insert File'? ( So that I can avoid setting flag fields) Â I am using Windows 7 and FM…

Hi All, I have created a DB in FM11Adv that assigns a new invoice number each time a new record is created. Currently when I set up the DB I go to the DB section and assign the starting number with increments of 1. I would like to be able to put a field on my preferences page that you can input the starting invoice number is 13-0005 for example and then as a new record was created, it would advance it by 1 and place it in the invoice field. It's working fine the first way, but it would be nice to lock down the access to the DB on set this way up and allow the user to set it. Any ideas would be greatly appreciated. MG

I am running a database on FileMaker Server 12, and have a number of daily imports and scripts that need to be run, but due to a limitation in the ODBC driver (connecting to 4D. Server can't run the imports, it has to be done on my client machine), I can't set up a scheduled script on the Server to run the imports. The thought I had on how to get around that was to have a scheduled script on Server which would populate a "Script Request" table, which would simply add a record to a table with when the script is requested, which script is requested, and the times that it can be run. Then, I'd set up an OnTimer script on my client machine that looks at that table fo…

Hi all, I'm struggling with the following scenario and would be grateful of any help. I need to synchronize two customer tables. The 'main' table is from an SQL database connected via ODBC and will be the 'master'. I need to add any new records from the SQL table into my local FM database (deleted ones don't matter). To find the new records manually in FM I can place an ID field from the FM customer table onto the layout showing the SQL customer data and do a Find for *. This shows me any matching records between the two tables. If I then Show Omitted Only I then see the New records. My problem is that I then need to remove any records which have a value of 0 in a…

I have a database where clients can come in for multiple visits under the same Client Number. The report that I pull will have them listed a couple times but what I'd like to do is omit the first time they are listed on the report and only keep the second. I have a script in place that will mark all duplicates with the following script: Go to Record/Request/Page [First] Replace Field Contents [Perform without dialog, Specify target field 'Mark', " "] Loop Set Variable[$id,'ClientID'] Go to Record/Request/Page [Next, Exit after last] If ['$id = ClientID'] Set Field ['Mark', '"X"'] Else Set Variable[$id,'ClientID'] End If End Loop Perform Find [Resto…

Hello, I am very new to FM and I have been asked if audit logging of changes to data in a single table can be achieved. From my Googling, it appears that it can be done (im using FileMaker Pro Version 10.0), by writing a script and having a trigger fire each time the data in the table is modified My question is this : how exactly do I go about this ? Ive searched for examples online but havent found anything relevant to what Im trying to achieve. Any feedback / direction would be greatly appreciated. Thanks. The structure of the table I have to work with is as follows & the fields that data would be changing in via user modifcation are "Action" and "Conclu…

When I use the following script step: If Rightwords(PETER ZIPPI::SOURCE OF INTAKE;1)="LAAS" I get the following warning: "This action cannot be performed because this field is not modifiable." This field is defined as Text, Always Validate, Required Value, Unique, Allow user override during data entry. I think this field is merely being tested, and no modification is intended. So why do I get this message?

I am working on a database that has fields named with bullet points in the names. I see that FMP will update "each layout and any field references used in calculation or summary fields" per this link Filemaker Help. I want to make sure I am not going to break any scripts if I update the field names. Can anyone assure me that FMP will update the field names in any scripts that may access or write to said fields? I could ask rather is there anything that is not updated when a field name is changed in the define database dialog? Thanks in advance!

I'm attempting to run a script via the browser to open a database and search for a specific record. I'm working from this tutorial: http://www.filemaker.com/12help/html/sharing_data.16.7.html All the script needs to do is find a record with a numerical value in a field called "Studio number", I've created a new script and it currently looks like this: FMP://192.168.1.100/GALLERY%20ARCHIVE.fmp12?script=opieno?val=5008 So... This URL will open the correct file and run the script, but it doesn't enter the parameter and find it. Here's the script (don't think its right yet): Enter Find Mode [Pause] Set Field [specific Pieces::Studio Number = $val] Perform Fin…

I have a lot of scripts. They are running fine. I do not want to debug them, but I would like to see the steps. I don't want to see them individually in the manage scripts window. That is too tedious to see each one separately. Besides, I forget the differences between them when I do this. How can I see the steps in each script? In other words, I would like to view script 1, then script 2, then script 3, etc.,. Perhaps by scrolling in a window, perhaps by printing them all out at once, not individually.

I have solution with many layouts, including Main Menu layout, Data Entry Layout, Repots Printing Layout How can I make the solution to go back to Main Menu after closing Data Entry or Reports Printing Layout.

I'm having trouble scripting a find for a 3-month rolling time period. I need to find a date range starting from 3 months prior to yesterday through yesterday. I can't seem to get my head around the calculation for that range. Can anyone help please? Thanks.

Hello, is there a way to keep a user in a Window unitl they make a selection -- and not allow them to selet other Windows from the background -- without having them in a Paused script?

I have a very simple startup script. When I open my database, all the steps run, except one. All the script steps run perfectly once the database is open and I trip the script manually. The line that doesn't run on startup is a simple date range find. I've tried disabling all the other steps except the find, and it still doesn't run on startup. Here's the script: View As [View as Table] Adjust Window [Maximize] Set Zoom Level [200%] Show All Records Perform Find [Restore] (Find Records, Court Calendars::Calendar Date: [1/1/2013...12/31/2013]) Sort Records [Restore; No dialog] (Calendar Date, Ascending Order) Go to Record/Request/Page [First] I …

Hi, I need help with my script In my file I use the Send Event cmd /c DEL /Q *.pdf1 "C:pdf" to delete a pdf file in Windows. The file will be located in a folder named PDF in the C: or Macintosh HD. I need to do the same in a Mac 10.8, do I need to create an Apple script in the OS fist? I appreciate any help or ideas. Thanks

How do I turn off breakpoints in Manage Script? Â Now every file I open have this grey sidebar to toggle breakpoints in Manage Script. Even creating new files from template. I did not open Script Debugger. Â Restarting FMP did not solve it. Nor restarting the computer. It is still there when creating new script step. I just want to turn it off so I can reorder my scripts. Â And since I did not open Script Debugger, what do you call/name this function? Toggle breakpoint in Manage Script? Searching the world wide web always point me to Script Debugger. And I couldn't find any answer in the Help file either. Â I'm afraid that this might be an easy thing to sol…

I have set up a database that allows employees to log in and out of tasks throughout the day so that we can track productivity and use the data to better bill. One of the features of the database is an "In Progress" button that allows department managers to, with a single click, see what employees are actively working on. It all works well except for end of day tasks. Every couple of days, an employee will leave without first logging out of their task. So the next morning, the supervisor will have to manually adjust their time. In an ideal world, each department manager would check the "In Progress" task before heading home to catch them right away, but we don't live in a…

Hi everyone! I work for a school district and I am recreating our leave form using Filemaker Pro 11. I have used Filemaker for a number of years and use relational databases. Once I get the form online, I want to try to script trigger it to email a copy of the form to the staff member who is requesting leave when their supervisor OK's it. This is the first time I have even used script triggers. As I was looking through the script categories, I set it to web publishing so I could see what I could use if I were to use a script. It looks as if you cannot do any Save as, etc. Is there a work-around where you can capture the form and email it? I read some of the cont…

Hello, Seems like this should be a simple one but so far, no luck. All I want to do is create a button that when clicked, will run a script that will find the most recent date in a specific date field. I've tried the max function and clearly don't know what I'm doing because that didn't work. I then created a summary field and set it to pull up the maximum date of this specific field but now I can't figure out how to create a script that will do a find for my date field to equal this max date summary field! Please help..I'm slowly but surely going insane over what I'm sure is something very simple. Thank you much!

Hi I have this strange problem in one script I am using to delete child records. The script is in the attached file. For example when there are 20 child records then the script finds 20 records, but when the script goes into the loop script it only deletes half of the records, so when I press the button "Delete" once there are 10 records left. When I press the button again there are 5 records left and so on. Can anybody point out what I am doing wrong here. The loop part does not loop though the found set. Regards, Reynir. Filemaker - Delete related record script.pdf

I have been away from FMP for a long time, and am now jumping back in. RIght away, I ran into a problem. This is a simple script step to increment a counter, but it does nothing. Case (PETER ZIPPI FILE::SOURCE OF INTAKE="STRAY - AT LARGE"; PETER ZIPPI FILE::Q1 Strays=PETER ZIPPI FILE::Q1 Strays+1) The record has the right data in the SOURCE OF INTAKE field, so why doesn't this increment the counter? Feeling stupid in LA

In my script I need to be able to select all the child records from a set of parents, so I'm using GTRR and the option to 'Match all records in the current found set'. The parent set actually contains some records that have no children, but nonetheless the other parents DO have matching children and script step produces error 101 (Record is missing) - but it actually completes the script step and shows the found records in the layout as required. Further investigation reveals that error 101 is produced if the current parent record has no children, but there is no error when the current parent HAS got children. So, the conundrum is how do I determine if the error…

I want to use a value list to search for an id number from the filed id. In this case number 1. I search and it shows the right record with id number 1, but every record that has number 1 in the filed for something else are listed to. I only want the record with id number 1 to show up, and not the others with a number 1 in another filed. Can someone please help me with a script that mange to do this.