Script Workspace and Script Triggers

I have a table of Customers and a table of Quotes. I have a script in the Quotes that takes the customer name, phone and email, sets them to variables, opens a new record in Customers, and fills in the name, phone and email. The problem is, I want to be able to do a Find in there and basically say "OK, that customer is not in the Customer list, so we will add them" or "Oops, looks like the customer is in the customer table already, so we did not add them". I don't know how to have it do the find without prompts, and not sure how to have it know that if the customer is in there do this, and if the customer is not in there do that. Any help would be greatly appreciated!

Hello everyone, Hopefully I have the correct sub-forum. I'm attempting to create a Windows Task to open FileMaker Pro 12 Advanced and log into the administrator account. This is to run some scripts on a nightly basis. I'm struggling to work out how I would get the task to enter the administrator username and password into FileMaker Pro and log itself in. Basic I know, but could anyone offer me some advice or guidance? Should I be using the command prompt for this? I'm running Windows 7 Professional. Any help would be greatly appreciated! Stuart

I am confronted with a weird problem I have never encountered before. I have just made a script in which there is a custom dialog box, however when the script runs the custom dialog box flashes on without pausing, rendering any response to the question asked impossible. My experience with custom dialog boxes up till now, was that they imposed an indefinite pause in the script so that the user would respond. Am I missing something really obvious here, or have I come across a bug ?

I was wondering how to accomplish that. I got a set of records, each with an item name and type, the purchase and sale price and the calculated net profit. I would like to make a script that finds the 10 most profitable sales and display them on a repeated field (?) (I am not sure about the last part). Anyone can point me towards the right lines of code. I am very new to scripting unfortunately. I tried this, where "T_ItemName" is supposed to be the repeating field (10) that should display the top ten, but it doesn't work: [*]Perform Find [ Specified Find Requests: Find Records; Criteria: D3 Database::DE_Sale Price: “>1” ] [ Restore ] [*]Sort Records by Field …

Hi, I have this bizarre problem. I have portal in which there is a Product, Qty, Unit Price, total price. I have made a script that triggers on Unit Price modification. It should put 1 in qty field then multiply qty with unit price and put it in Total price. The Script. " Set Field[Qty :1] set Field [Total Price = QTY* unit Price] " But nothing happens?. The unit price field is look-up field. So, it picks up the unit price as product value is entered. I need to know what i am doing wrong? Or there is another why to do it?

Ok, not sure where to start on this scripting. I can do very very basic scripting. Another member on these forums was nice enough to get my database set up but now I need to script to finish the database. Here is what I have. The import record brings in data from an EXCEL spreadsheet to an enrollment layout. Now I need to bring in the data from that to a Student Record layout so the information shows in a portal as one student schedule and one record. If I try it any other way I get 7 records for the same student. Not sure where to start. The member stated to write a script that first sorts by student name, then loops through the records and marks duplicates, th…

Hi there, I have noticed a change in behaviour with FM12... it is as follows. We have a layout where there is a calculation field. This calculation field is also a button which you can click on to go to a new layout. Even though it is a button, when in find mode, you can still enter a search term into the field. In old versions of filemaker this used to work fine, in FM12 when you enter find mode and click on the button/field to enter date to search for, it thinks you are trying to run the script to go to the new layout and obviously fails... What is the best workaround for this?

I thought of several ways I could do this but always come up with snags. I couldn't even think of an accurate title that explains exactly what I'm after (maybe why I haven't been able to find anything through searching). Hopefully those higher up on the food chain can give me some direction In short, I'm looking to combine or group certain records that get exported to our invoicing software. We do this in the invoicing software manually but thought I'd attempt to cut out the middle man. What happens for this invoice export is I loop through records, storing the relavant data in variables, then add these records to a temp table that is formatted in a better way …

Hi, all: The title pretty much sums-up the problem: I want to create an FMP 'shortcut' so a user can automatically go to a specific layout in an FMP file on the server, then the shortcut closes; I just can't get the syntax correct in the script. What I have so far is: Open File ["Student Records"] Go to Layout [196] ...where 196 is the layout number of the form I've created. What am I missing so that the user goes to Layout #196? As of now, the file opens just fine but after that, nada--FMP and I just exchange dumb looks at each other. (I have a sneaky suspicion it knows who the real dummy is here.) TIA for your help!

Hello, this will be a quickie while working on my database I realized there are a couple of scripts which I am not sure are still used anywhere in the database, before deleting them I would like to know if they are used somewhere, is there a FMP function/command that will let the program check if a script is referenced/used anywhere in the DB?

Hi, right now I have five buttons each of them performs a different sort script, I would like to get rid of the multiple button and make a single dropdown list (attached to a value list) so that the user select the first option the script performs another script (formerly the 1st button), if the user select the second option the script performs the second script and so on. Now, once I created the value list and attached it to the new field I am rather clueless on HOW to instruct FMP to perform a different script depending on the values of the value list. Can someone with a knack for scripting help me out on it? Thanks in advance.

HI I have an apple script that works natively in Applescript but is failing with errors when called within a script "Perform Applescript". It seems to be something to do with the way FM_TXT is being read. The error is Can't get 40 thru 64 of "47". -1728 Here is the Applescript that works as an applescript. set FM_Output to "filemac:/Applications:MyTools:Database_Conform:Applescript:temp:000.xml" as alias set FM to (open for access FM_Output) set FM_TXT to (read FM) as Unicode text set AppleScript's text item delimiters to (ASCII character 10) set XMLNameLength to (offset of "16680" in (paragraph 1 of FM_TXT)) set XMLName to (text 40 thru XM…

Hi all I am trying to solve the following problem In list view I want to give the user the means to click a button at the top of the list and for that to produce a list of unique values in a seperate window for a given field It needs to work only for the found set. I can manage the setting up of the list using the list function and the new window, but the bit I am struggling with is the removal of duplicates from the list If someone could give me a few pointers that would be great Many thanks

I have been looking for a method to define a series of radio buttons based on the selection of another. For example if radio button for field "working" is selected as "No" i would like to auto select all other radio buttons as "No" on the form and not allow the user to redefine them. If "working" is selected as "Yes" i want all other radios to be as they are defines in the list normally. I am a little new to FM but have used Access for years. Access would use a active = false command to over-ride but i am not sure how filemaker will handle it. Thanks for the help. This has been a great forum for help getting started.

Dear All, Here I am working with Global Fields, but I stuck on a very logical error. The scenario is, In my global table, I have only one record. I am updating the records with the data of some another table, something using like, set variable and set fields, script steps. These all are working fine. But the problem is that, my file is on FMS. and I am hosting the file using different users. The updated data is visible on only that machine where it is getting updated. But not getting updated on another machine. For Example: Suppose there is only one record in Global table.. having value in the field Country as Australia in First machine. From second machine …

Hello , i need your help , i would like to know how to write a body email that shows me uncompleted task of the whole database ? complete=0 ( this is uncomplete task) complete=1 ( this is complete task) i dont know how to make a search and put the result on the body , this send mail script is going to be used in Filemaker server as a schedule script . please let me know a solution , thank you ,

Hi Guys, Don't know if this is possible but I'll explain what I'm looking for: I have a big layout with about 30 fields on there, when a client clicks a back button I want a script to check for any changes... If there has been a change I want a message to appear to basically say "You had made changes do you wish to continue." Is this possible? Thanks, Scott

I am trying to figure out how to batch data entry. Here is what I am trying to do. We have data that comes to us on a report that will "Clear" several individual welds. The report could have 100 or more entries on it. The actual weld data is gathered at a different time and is already in the system. I want to be able to select all the welds that would be on the report then Open a new layout enter all the report information then on save have information entered on the previous layout go to each of the weld records. (each weld is one record) All this being done in Filemaker 12

I have a location table where a user creates a new record, selects a location and enters the number of labels she would like. Then she creates another new records and selects a different location and the number of labels needed etc... When finished she wants to print the appropriate number of labels for each location. I've created a label table and in that table and I'm trying to write a script that will create all the labels for all locations. I've created a script that is able to create 1 label but I am not a proficient enough scripter to figure out how to write it so that it creates all the labels. Any assistance is greatly appreciated. I have attac…

Hello, I'm trying to set up a training database which will send an email reminder to users 90 days before their training expires, but I'm having trouble writing a script! I would like the email to send to Personnel Records::Email and for it to be sent 90 days before Training::Expires. Could someone give me a hand? Thank you! Personnel (local).fmp12.zip

Hello all Is there a command to capture the field name, not its contents, into a local variable?

I have an assessment database that enters a green square jpeg into a container field if an answer to a question is marked correct or a red square jpeg if an answer is marked incorrect. Currently I have the green and red square jpeg files standing alone in the directory where the assessment file resides and all has been fine. I now want to use my file with an iPad so I am trying to incorporate the green and red square jpeg files into the assessment file itself which will make things tidier. I created two tables, green block and red block, created one record in each table that contains a blockID field and a block container field containing the jpeg for the respective t…

Hello, I am new to the forum so im not sure if this is posted in the correct section so i apoligize if i have. I am having a problem with the if function, Script is as follows: If [$$Weekend="Yes"] Perform Find [Restore] Else If [$$Weekend="No"] Perform Find [Restore] End If The Perform Finds are two different finds, one serches for a number in week field and the other in a weekend field, but when $$Weekend is "No" it shows results that contain the number is either field, The code for the Finds are: Weekend = yes Find: Table::weekends =$$Number Weekend = no Find: Table::weeks =$$number Any help woud be appreciated…

What do you feel is the "strongest" way to pass multiple parameters to scripts in FileMaker? I am currently using using Ray Cologon's DeclareVariables but I think that some of the text I am passing is in the same pattern as the function is expecting, therefore breaking the text in the parameters. I am thinking that a solution that more resembles xml would be better. So.... What are all the cool kids using these days to robustly pass multiple parameters. I am looking for the solution that is least likely to break ( Due to text parsing errors?) . Thanks, Drew

Well Im stuck again , I updated to 12 from 11 (Which is Awsome by the way) but now when i use my Import script it pulls all my info in correctly except for my relational ID now . So it brings in all the info and then goes all the way back to the first record whcih there are thousands and begins to over write the Relationl id of all my other records. Any idea why? See below.... Allow User Abort [ Off ] Set Error Capture [ On ] Set Variable [ $id; Value:PM::ID_PM ] Go to Layout [ “Equipment_Database” (Equipment) ] Import Records [ "Equipment upload sheet.xlsx"; Worksheet: "Sheet1" ; Target: “Equipment_Database||id_project|” ; Method: Add; Character Set: …

I apologize if i am in the wrong group for this question........ I have a script which has been running fine for years (every 15 minutes), suddenly it has quit working properly - no code changes were made. Basically the script imports a tab delimited file (each field has double quote marks around the data) into a table. Once the data is in the table a 'Replace all' is used to strip off all the double quotes from the data. The issue now is approximately the top half of the fields in the table get the quote marks removed and in the bottom half they remain. What is interesting is this issue does not present itself when running the script using FM Pro Advanced (1…

I am importing records from another table. When I import them in if the "Spaces Allotted" field equals 2 than I need the record to be duplicated, if it equals 3 then I need it duplicated twice. I can Loop through and duplicate the record if "Spaces Allotted" = 2, but I'm having trouble if it =3 and also duplicating the last record if it needs it. Any help would be appreciated.

I am trying to create an applescript to copy (duplicate) a file located on a network volume to my desktop (for simplicity sake). My problem seems to be accessing the file on the network volume, because this script works for files located on my Mac. I know that the file does exist, because I also have a different applescript to open the file directly from the network volume which works fine. set source to "AMINTERNAL:NPI Projects:Experimental Docs:1556.13.1.ppt" set destination to "Drive 1:Users:simonen:Desktop" tell application "Finder" duplicate file source to folder destination with replacing end tell AMINTERNAL is a mounted network volume on my l…

Hi, I design a database for purchase product.My problem is: I want when receive a product, click on receive field and open receive layout (related with purchase and product), and I can enter date of receive and qty of product, and balance between qty purchase and qty of revceive product. Please look to my database and help me. TestReceive.zip

Is it possible to trigger a script when a user switches between tabs? I realize that I can place a button on the tab and use it to trigger a script but I was wondering if there is a way to trigger a script without using a button overlay.

I have built a small database for a charity to help them manage their growing membership records. Each record has a 'status' field where membership can be set to 'Active', 'Inactive', or 'Deceased'. Having argued that the charity should not delete 'Deceased' records because those records may be needed even though the person is no longer breathing or donating, the charity wisely asks that the database "should not show deceased people", but we should keep their records. How do other database designers deal with dead people? i could write a script that performs a find all records but omits 'Deceased', but as the database has many scripts using a 'find all', this …

Hi, I have no idea what I have done and have spent a couple of hours going round in circles on this. In the Invoices starter solution there is a drop down layout selector on the list options. This navigates between list based layouts. I modified the database and added a further list. I added this to the pop up menu "layout selector" and the menu started to only select the new drop down option. I fiddled with the script "Trigger | Layout selection" and the whole thing ground to a halt. I reimported the script - still not working I have checked: Link between drop down and Format - set script triggers in menu "Layout selecto" pop up menu Scrip…

Hello, I'm trying to find a way to do the following: I wish to generate an Estimate based on a type of Client ( I anticipate four types of Clients) Because the four types of Estimates based on the four types of Clients generally have a standard set of items (and pricings), I wish to find a way to create a new Estimate and have it populate automatically with items from my GoodsAndServices table. (Also I realized it is easier to delete EstimateLines than it is to input from a lengthy popup menu. In my GoodsAndServices table, I have the list of goods and services, each record tagged with field called "Category" which will have the value of "A"; "B"; "C"; o…

Dear All, I am trying to find a way to script the opening of the drop down calendar after someone enter a layout. This is to alert the use to and encourage the user to use the drop down calendar to enter the date. I've tried using "Go to Object" as well as naming the object, but it doesn't seem to be opening the calendar automatically. Can anyone suggest something to me? Thank you.

I have a simple field script for OnObjectEnter - which stores the initial value in a global variable. Then I have an OnObjectExit script that compares the initial value with the current value and if it changed I write the change to log table. The script catches the initial value for regular edit fields but it won't fire the trigger on fields that use popups for data entry. How can I capture the original value for the popup if I can't get the OnObjectEnter script to fire or am I just missing something? Dom

Hello I have a script that base pause in it. after the user haze two options a. to cancel b. to finish and close layout. I the button setup i select perform script and the options to resume and goto script cancel or close. after this i still get the continue button. What am i doing wrong? Thank You Dani.

I have a table with exactly 38 records and I don't want records added or deleted. I would like to protect against the user adding or deleting records in this table. Is there a way to do this?

I use this on occasion to change the text on buttons, it works very well with IWP for customer selections "with modifications needed - merge variables need to become fields..." , I just thought some one else might benefit from this technique.. but feedback is always appreciated too. buttons.zip

Please see image below and then details: How would you enable the editable field "Qty to Add" to highlight the selected record that has it's ID set in the global key field holder, when clicked in and has a value greater than or equal to 1? User can click on the fields to the left of "Qty to Add" and it highlights them blue. These fields are applied a button and a conditional format. The button script is: Set Field [project_salesorder_SALESORDERLINEITEM::_kg_SalesOrderItemsKeyHolder; Case (IsEmpty ( FilterValues ( project_salesorder_SALESORDERLINEITEM::__kp_SalesOrderLineItemID ; project_salesorder_SALESORDERLINEITEM::_kg_SalesOrderItemsKeyHolder ) ) …

When a new record is created does it mean that the person creating it automatically has possession or should they open record request? I can not figure how to even test it but if I need to set fields in the new record, should I do something to make sure someone else doesn't set the fields with other things before I can? As always, I appreciate any input. I spent 3 hours reading great things about record lock but still could not get my answer.

Our FM solution uses the mailto script step to automatically pdf a quote, attach it to a blank email, and populate the address field. We are considering switching from Entourage to Gmail, but I can't get this script to work with Gmail. I've tried their suggestion of the Notifier app. Does anyone know how i can get this to work? Thanks

Although I've been pottering with Filemaker for years, I'm still influenced heavily by my historical Access knowledge, despite not having used it for about four years. I'm having trouble getting around some aspects of Filemaker, and now the time has come where I need to develop something quite substantial with it I think I'll be asking a lot of questions! I have a pretty straightforward address screen with the usual fields (company, address, town, county and so on). I've also recreated the same fields for delivery address details (del_company, del_address, del_town and so on and so forth). What I'd like to do is have a button clicked that copies the contents of …

Hello all, It has been a long time since I have been programming on FileMaker. At the moment I have a project to create a database for some financing. The scroll function with the mouse wheel is great to check on my entered data, but I would like to trigger a script when FileMaker switches between the records during this scrolling option. (FileMaker has tot calculate some stuff before it shows the next record) Is this possible? And how? Or is it possible to deactivate the mouse wheel scroll option. Cheers

A few years ago, when I updated from 7 (6?) to 9 advanced, one (or possibly more) of my scripts broke. Seems like it should be a simple one, a lookup of the current month's orders. I found a workaround and have been using it ever since. I've asked for some help a couple of times, but never got an answer that I understood how to make use of. Needless to say, I don't know scripts. By looking at the following, can someone tell me what might be wrong with this script? Go to Layout ["Monthly Summary" (Orders)] Print Setup [Restore; No dialog] Perform Find [Restore] Sort Records [Restore, No dialog] Go to Record/Request/Page [First] Enter Browse Mode My…

I have a container field in a table that contains pictures that are linked only. I would like to make the file more portable by having the pictures embedded instead of linked as I don't always have network access to the server where the pictures are stored. I have tried to run a loop script that copies and pastes from the original container field into a new one but it only copies the link. Insert picture function dialogue box only seems to give you the option of adding a file path and not a field itself. Is there a way of doing this or will I need to do it manually?

I would like a script to control that the user entered the correct value in a field. And If the value is incorrect a pop-up should alert them. The field in question is the social security number (swedish). A correct value could be: 570322-1453 (YYMMDD-XXXX). Only numbers and a "-" as the 7th symbol is correct. Everything else is incorrect and should trigger the script onObjectExit. Thanks in advance!

I can't believe I don't know how to do this, but here I am. I have a layout with a button on it that is going to open a new window base on the same Table occurrence, and I want the new window to open up with the same Found Set as the window that the button is on. How do I do that? Is there a script step like "Go To Related Records" . . . or a calculation function that harvests a current found set, or . . . ? Thanks!

I want to provide users with some feedback in a text field on our layouts so they know what they have just done...But I don't want this message to appear forever I'd like it to dissapear after a few seconds... Is there any way of doing this? The only way I could think of to get rid of the message would be to use script triggers on the layout but I don't like the way this could mean the users doesnt actually get to see the message because the script trigger has deleted it...

I have a several similar scripts for opening pop-up windows to display charts and reports. I'm using a New Window step at the beginning to set the location of the new window on the screen, but leaving the dimensions blank, going to the desired layout, hiding the toolbar, and then Adjust Window: Resize to Fit step at the end. This is working fine for a layout where there is only a Body part, but for the ones where I have rand summaries or sub-summaries, I'm getting windows that ignore both window control steps: the window appears at the very top edge of the screen, and stretches the full height of the screen. Im attaching a picture of my script -- and of one of…

Hi All, I have been using filmmaker for 2 weeks. I try to revise the template and use it in my work place. Now I try to combine two template and revise that but face a problem. (The relationship of my data base is attached as Data base relationship1 and 2). I want to search and auto fill employee ID, name, and email on new layout when I type a button (button script named Show customer browser). But when I call the layout out (attached as new layout) and click the employee list (attached Input employee infomraiton). The data didnâ��t auto fill on the space. Can someone help me to figure out where the problem is and help me to fix it?? Many thanks for your h…

Hello, I would like to include a script in my database which would automatically send an email to a user 6 months before their training expires, but I'm relatively new to Filemaker so I'm not sure where to begin! Could someone lend me a hand? I include a copy of the database in its current form - the section relevant to this problem is under Personnel Details/ Training. Thanks in advance. Richard Personnel Records Copy.fmp12.zip

Hello, I would like to add bullets like word. I mean whenever a new sentence add. Once i click a button should be active. Once i release the button bullet should cancel for next sentence. How to do it. Kindly help me. Both windows and mac. Thanks in advance

Hello All, I'm just dipping my feet in scripts and I've trying this for a couple of days, but can't figure this out. I want to generate a pdf of an Estimate. I have a layout called Estimate Worksheet (based on the Estimate Table with portal based on EstimateLineItem). After filling out the Estimate Worksheet, I then want to go to my Estimate Printable layout (based on my EstimateLineItem table) and consolidate all the related line items for a particular Estimate, sorted (according to ItemCategory), and the generate a pdf. I can do this manually, but I want to automate this. But I can't seem to find a way to make it find all the related EstimateLin…

Everything works great in this script, however when clicked and the "send email" command is executed, in the to: field of the email message the phone number is repeated 5 times. Any ideas? Thanks Matt script.tiff

I'm trying to set up a Sort script so I can sort all my records by various fields. But the script I've set up isn't working and I don't know why! Could someone have a look and see what's going on with it? Thank you! H&S Database Test.fmp12.zip

Hello all! I work for a pool construction company and currently I have a date field set to automatically send a email anytime the date is changed. This either says that the event is happening, or if the date is removed, the event is not happening. Since we are a construction company, this can be changed multiple times during a week, if not in any given day. This means that sometimes my builders can receive 3 or 4 emails a day of the change. This isn't immediate need information, so I want to create a email that summarizes what they have as of that day. I want to create a "Summary" or "compiled records" email. I want it to look up the builder and sales representa…

Hi, I am new in FileMaker Pro. I have Keyboard Emulated Bar code Scanner. Here is what i am trying to achieve. In a layout there is field for bar code. As the Scanner scans the product i want it to be entered in that field automatically and curse move to next row for next item entry. How can make it? Kindly explain it fully i am New in File Maker. Thanks

Hi, I am fairly new in the FileMaker. I was working with a script and encountered a problem. I am made portal in which there are 3 fields and there is button in the layout. As the button is pressed the script triggers. But it only performs calculations for first row in portal and ends. I want it to run for each row in the portal. I am attaching the Script.

Hi, I was having a bit of problem in FileMaker Scripting. I made a script that as spouse to update each field in each row in Line Portal but it only updates the first rows field. When i insert new row it updates the first rows filed. I have attached the Script image. Kindly help me solve the issue. Thanks

HI i want to have a script that will open database #2 to layout "a" and when the user complete the input data. The database #2 will close and return to date base #1. The problem is the user enters database #2 layout name "a" straight ( to the same layout) when he finishes with the layout he should stay on database #2 and not run to database #1. can some one help please ? Thank you Dani

Just realized I posted this to the wrong forum. Please disregard here... and I'll repost under scripting. Thanks... mp I have two linked tables (one is my context... the other a portal placed on the context table). I simply want to be able to click a button to create a new portal row. I have looked everywhere for the problem… spelling, relationships, etc…. The script creates the new record but never sets the field with the __ID_PEO_pk ... I'm hoping it's glaringly obvious to someone out there what I might be doing wrong because I'm at my wits end... Tables: PTO_PEOPLE (context layout) __ID_PEO_pk Name PTO_STATUS_lineItems_j (portal) …

Hi All, In a FM Server hosted database with multiple files, is it necessary to close each file as the user exits? I see the need to do this in a single user environment, but when the files are hosted on server they are always open until closed by the server. The reason i ask is that while debuging my quit script one of the data files(Separation Model) threw an error 13 (file in use) since that data file was opened on the client by reference. Any one know the best practice is relative to the "Close File" script step?? Thanks in advance, Tim

hello guys and girls. this is my first time posting here so bear with me. i've made a simple database for checking kids in that I had down just fine. but due to privacy constraints i'm best off making separate layouts for each type of user/privilege set. and since this is all outside and paying for FM licenses for such a small thing is far form worth it. its all done on iPads or iPhones (depends on what we have for a given week). so this is where i need your help i need help designing a start up script that puts them on the right layout based on what they log in with and what device they are using at the time. I can get it to go to layout based on device and I c…

I am using Filemaker Pro 8.5 (MacOS 10.4.11) which for various reasons I am not in a position to upgrade at present. I have created a simple database of only one table. My purpose, which I have successfully achieved, is to manipulate and output data from this database (which only I use) as a set of 50 textfiles. The fields in the database include: category_number export_text I have a set of 50 scripts, named 1 to 50, each in the following form, plus a script called "PerformAll" which calls all 50 scripts one after the other. Each of the 50 scripts contains only the following: Perform Find [Restore] Sort Records [Restore; no dialog] E…

This script goes through a found set of records and marks a field: 0 It works perfectly until there are more than 9 or so records. Then it skips maybe 2 of them. Then I have to run the script again to clean up the remaining records (it then successfully marks the ones it missed). It runs mostly through IWP if that makes any difference? Thoughts appreciated!

Perform Applescript to Ruby script still the way to go? Anyone try beezwax's bbox plugin? Rfm is ruby to filemaker only right? Basically I am using a ruby script with the mechanize gem to fill out a web form on an external site with data. I'd like to use data from my filemaker database and return a success or a failure (the form website either displays a page or it hangs up on an error page if the data is not on the external site's db which is not accessible at all). Feedback is always important, but here it is really important.

Hi, I have a database of about 20,000 leads. I need to assign 1000 to user 1, 1000 to user 2, 1000 to user 3 ect. Can I script this? Thanks Ian

Hello, I have a table that records the start time and the end time for a job by each employee. I want to automatically have the start time be the end time of the last job completed. Something like: IF (Find all end times for today from a certain employee, choose the most recent end time, set the most recent end time as a $variable, set the current record start time as $variable) Else Allow to set start time field manually

hi, I wanted to create a script to update the stock value of the product. Here is the scenario. I have the 4 tables. Product (Stores the stock value and other product information) Purchase(My Product Purchases and total amount) Purchase_Detail(How many product i have bought and at what QTY) Stock(Keep track of the product purchase and sales) I have created portal in Purchase layout for Purchase Detail that allows me to input products i have bought and there QTY. I have setted the script trigger(Oncommit) on this portal. So, as i leave this portal the script triggers and it should update my stock in Product table and put a record in Stock table of wha…

I have created a windows "automation" script. I use this script to handle all window functions (such as open new, close, etc). It keeps things consistent and simple. Part of the script when opening new windows automatically resizes the windows to auto-fit the layout. This is great due to the varied screen formats used by the database users. Problem is, some users have large screens, and they are manually resizing the windows to use that space. They want to be able to have the window reopen with the larger size next time it opens. The Auto-resize command doesn't distinguish between the first time a window is opened-- and therefore needs to be resized-- and the n…

Hi, I am new to FileMaker Pro. I have a question that Can we make POS and Stock Control system with FileMaker using Bar code scanner and thermal printer for Prints? If yes kindly tell me any guide on it or any material on how to make one? Thanks Waleed Hassan

is there a 'white paper' that covers scripting issues with shared databases? For example, I believe the 'Replace Contents' script step will not work if one of the records in the found set is being edited by another client, and will not give an error. I'd like to head off problems rather than get surprised for them.

I have a very simple test file with two tables: A and B I have a very simple script: Import A into B File is hosted on FMPS12 Script works when executed from client side but not server side (schedule) I am sensing that it might be the file path. 'file:import-test' is what I have now should it be different when running from the server (via schedule)

Need help with a search script. Need to be able to type in a search box the numbers 0-9999 and find the matches in these 14 categories: SHEKINAH ART 1::Source RecNum 1 SHEKINAH ART 1::Source RecNum 2 SHEKINAH ART 1::Source RecNum 3 SHEKINAH ART 1::Source RecNum 4 SHEKINAH ART 1::Source RecNum 5 SHEKINAH ART 1::Source RecNum 6 SHEKINAH ART 1::Source RecNum 7 SHEKINAH ART 1::Source RecNum 8 SHEKINAH ART 1::Source RecNum 9 SHEKINAH ART 1::Source RecNum 10 SHEKINAH ART 1::Source RecNum 11 SHEKINAH ART 1::Source RecNum 12 SHEKINAH ART 1::Source RecNum 13 SHEKINAH ART 1::Source RecNum 14 Can message more details or screenshots if needed. Will also …

Hi, Quite new to FM so haven't learnt all the functions out there. Thought that someone here might know a good way how to script what i need. I've got three fields in a table, Provider, Group (1,2 and 3) and Value. The provider will change but the groups won't. I need to summarize the value for all groups for all providers (3 values per provider). Is there a way to summarize in for example a calculation the value for Provider A for group 1 and so on which i can then insert in to another table? Thanks in advance! Hans

Is there a script command that can determine if your in Browse Mode or Find Mode ? I'm having a blonde moment. Dom

Hi, My program will automatically generate a record in a table when a condition is met. I am just wondering if the same condition happens again when I open the program and I what to prevent duplicated record, is using a flag(global) a good way to do the checking? Is there other way to do it? Thanks. K.C.

Hi, I need to set a range for a perform find, this range needs to be from 2 months ago until today's date. Do you know how could I create this "2 months ago" date If we are 1/22/12, I would like to set a variable as 11/22/11 Any help would be appreciated, Thank you

I would like to save a record as a .pdf file and name the file using a combination of 3 field values. I have the script working to save the .pdf and a variable set to name the file ($filename). It work except how the file name appears. the information I'm trying to combine is: last name (smith) start date (7-1-12) project name (med) I set the variable calculation to : Employeefunding::employeelastname & "_" & Employeefunding::modstartdate & "_" & grantspeedtype1::ProjectName & ".pdf" which gives me a file name of _7-1-12_ I want it to say Smith_7-1-12_med What am I doing wrong?

I need to update regularly my database COMPANIES field "Freight" with a certain value like: If [Companies::Shippingport ="Rotterdam"] Replace Field Contents [No Dialog;Companies::Freight;"1500"] End If If [Companies::Shippingport ="Houston"] Replace Field Contents [No Dialog;Companies::Freight;"1000"] End If etc etc with 200 Different Shippingport,Differents Freights. HOW TO DO THIS in a script ?? Thanks for the help. William

I have 2 tables: Bids & Bids Flyers. Each Bid has a Bid ID, and each Bids Flyers has a Bid Flyers ID. I have a portal on my Bidsto show records for Bids Flyers. Some Bids may have 1 or more flyers I send. The problem is, each time I run this script it overwrites the original file name with the new data. I want it to make a new file for each one... Any ideas? Commit Records/Requests [] Set Variable [$filename; Value:Bids::Name & " Bids -" & Bids Flyers::City & " -" & Bids Flyers::Bids Number & ".pdf"] Set Variable [$folder; Value:Bids::Bids ID] Go to Layout ["Bids" (Bids Flyers)] Show All Records Go to Record/Request/Page [L…

i'd like to duplicate a parent record including all the children so you can make changes to the children but keep the original. all i can think of is a complicated hard-to-read script with a global to save the ID (serial number), marking the record, go back and forth... there must be a simpler way to do that! thanks, stefan

So in fmp11 on the mac the send mail script step worked with what ever your default mail program was. But in fmp12 it is choosing to ignore that and only use mail. Is this right?

I have a field "Update", and everytime I run a script on that record, I want it to add a line that says "Script was performed at TimeStamp". How do I add a line to the field, rather than using Set Field? I want to open the record and have the field show a list of each time is was performed. Thanks!!!!

I need to create the exact same layout with 4 fields and assign it to several tables with exactly the same number of fields. How can I create a Looped script in FMP12 which copies Layout Homework assigned to Table 01 as Homework02 assigned to Table 02? All tables already are populated with the fields content. HOwever as I have hundred of students and each worked differently I have more than 49 tables Portals are not useful as most data is graphics or short films Thanks for any help Regards to all

I have a basic shell script step that I have been using for years that basically copies a folder structure on our media server and renames it with a filemaker field value. In FM11 it takes about :02 to run, but in FM12 it takes about :45 to run. set x to cell "JobFileName" of current record do shell script "cp -pr /Volumes/vserver/vProjects/_project_template /Volumes/vserver/vProjects/" & x Any ideas as to why this takes so long? Thanks David

I have a script that goes through text records in a database and then triggers a remote script that speaks the text and then another script that updates the Date Last Read field. If I press ESC in the middle of the Speak script and thus abort it, it currently still updates the Date Last Read field, even though the whole text hasn't been read. I'd like it to only update the Date Last Read field if the whole text has been read. I assumed that it would be possible to monitor the Speak script result using get(scriptresult) in the main script but this doesn't appear to work. Get(lasterror) directly after the Speak script also doesn't appear to register an error. I th…

Hi! I'm new to FileMaker, so bear with me! I want my script to find a set of records, based on two variable criteria and one hard-coded criterion. The two variables - which are a range of dates and a name, are chosen by the user and passed on to the variable $$totalquantity at the press of a button which triggers the script. The script should then carry out a search, using these two variables as criteria in two given fields, and only include records that contain the letter A in another field (a product code). I then want to use the SUM function to add add the numbers in field "Quantity" for all returned records, and pass this sum into a variable called "…

I have a container field that holds a lengthy PDF document. Can a Filemaker script be written that would navigate to a pre-determined page within the PDF document? Or, must the client use the PDF navigation tools?

Hello again, I would like to create a script that allows me to clear just one field that are in the recordsdisplayed through a portal. Is this possible? The script I have only clears the field of the active record in the portal, but not the rest of the records that are displayed. My scenario: I'm looking at Record/Job #123. I have a portal displaying multiple records of all material that was ordered on Job #123. On each material record there is one field called "amount to bill." I would like the option to clear the contents of this one field when I press a button from my Job table. Please let me know if further clarification is needed and thank you so much …

I'm currently working on a time clock and I would like to be able to set fields with the current time but without the seconds. I know I can format to display only hh:mm but if the time needs to be editted when the field is clicked into it shows hh:mm:ss which I would prefer to simplify for managers and such who may need to make edits. So is there a way to trim the seconds off Get ( currentTime ) so that the actual value entered into the field is hh:mm rather than hh:mm:ss ?

Hi guys, I made a little script to protect fields from being modified (fields upon which I cannot put the option "prohibit modification on data entry") which triggers OnObjectEnter: Beep Show custom dialog ["Error!"; "This field is not modifiable!"] Commit Records/Requests[skip data entry validation; No dialog] Now let's say I make an invoice, I fill all the fields needed (customer's invoicing address, orderID, etc.) and when I'm done I'd like to have a button labeled "confirm Invoice" which triggers the script above on the invoice fields I just filled, so that the invoice I created is protected from future modifications. On script steps I can't see such…

I am creating a simple file to to play music. I am creating it to limit what my child can listen to or if the child is with the sitter i have created a rating system for the songs the child like. Each song is a record , each song has a runtime of x minutes and I have a container that holds the song in mp3 format. I have created a very simple script that loops through with a Pause/Resume script based on the minute length of the song. It works well if i select, in the inspector, Interactive content and start playback automatically. The defect with this is that if i open the record it plays(as it should). I have tried Go to Field[select/perform; table;Container], but it will…

Greetings, I have a large database I maintain for a company I work for. They have asked me to keep track of changes on one particular field. I have a good idea how to accomplish this with script triggers on that field, the problem I am facing is that this field could be on hundreds of layouts, and it is always possible someone could add it temporarily to a layout through the "modify layout" button. My changelog script would simply be another table with Key Index, Time Stamp, User ID, Before, and After. I think a script trigger would be easy enough to do it.. I think a on modify trigger? But, is there a way to apply this script to that one field in the da…

By now, I use this newbie method lol. I have a script that generates some new records in table 2, depending on a date in table 1, after a search. With a $variable get(foundcount) I count these records, so at the end of the script I can show a dialog saying "xx new records generated". After some improvements, now not all founded records need to generate a new one in table 2. How could I count only the number of new records generated?

I have a vendors table and a quotes table. I have a portal on the quotes table that shows "Potential Vendors". The portal simply shows all vendors with in a 100 mile radius of the Quote's zip code. I want to put a button on the portal for each Vendor that will run a script "Check Availability". That way, I can click the button for each vendor that I want to check that is in the radius. Sometimes, I might want to check them all, sometimes only one or two. The script would email the email address of the vendor, but it would pull some of the fields from the Quote record. The problem I'm running into, is the fact that there may be several different qoutes for numer…

Understandable for a newbie, there must be an explanation I still don't know. Script step: Perform Find. I have two variables: $FirstDayOfMonth, $LastDayOfMonth Into the find I set: $FirstDayOfMonth...$LastDayOfMonth (I use three points). Doesn't work. If I use the insert operator to insert the three point. Doesn't work either. If I set another variable: $RangToFind [$FirstDayOfMonth & "..." & $LastDayOfMonth] and use it in the Perform Find step WORKS. What am I doing wrong in the first two ways?

Is there a way to hide the field that is the object of Insert from URL?

I'm trying to accomplish a script to select/unselect all my check boxes at once. I have all months, sometimes I need to ckech just a few but some others I'll need to check the whole year and I'd preffer to check only one box than twelve, lol. Any advice of how to do it? Thank you.

Is there a way to make a script that will stop data from being changed in a record. I want to be able to assign a number to a record then lock everything from being changed.