Script Workspace and Script Triggers

Hi! I'm trying to create a script which in case of user has forgotten his/hers password resets the account with a new random password and e-mails it to recipient. Here it goes (Don't mind the dialogues, if you don't speak Finnish : Show Custom Dialog [ Title: "Resetoi salasana?"; Message: "Tämä nollaa käyttäjän unohtuneen salasanan.¶¶Oletko varma, että haluat jatkaa?"; Default Button: “Peruuta”, Commit: “Yes”; Button 2: “Resetoi!”, Commit: “Yes” ] If [ Get ( LastMessageChoice ) = 1 ] Exit Script [ ] End If Set Variable [ $$pswd; Value:Middle("123456789abcdefghijklmnpqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ!?"; Round (Random * 61; 0)+1; 1) & Middle("123456789ab…

Hi all, I need scripting assistance; I have a script that searches on a layout for records on current date and creates invoice records on the found set in a different layout. I would like like after creation of each invoice record, i define variables and open another file where there is another script that creates a new record in that file and sets the fields to the variables defined in the first file. is at all possible to reference variables in a subscript that are defined in the main script? NB:Main Script and Sub script both belong to different database files. This the contents of the main script...... #Script used to create Invoices that n…

Hey group, I am trying to run a script that will loop thru a portal and change the date. It runs and works but is in an endless loop. Here's the code. Set Error Caption [On] Go to Object [Object Name: “PortalLabour”] Go to Portal Row [First] Loop Set Field [Labour::Date; DailyReports::Date] Commit Records/Requests [No Dialog] Go to Object [Object Name: “PortalLabour”] Go to Portal Row [Next; Exit after Last] End Loop

Hi there, I'm trying to build a particular report and was hoping to get some ideas / suggestions on the most efficient way to do this. Some background to start with: Using FM server 13 over WAN Local client in numerous locations across australia 3 related tables: Products SalesLineItems Sales In Products we have a field SalesCount - this will be populated using script based on report parameters. SalesLineItems has qty sold for each line item Sales has the date of the sale The report I want to run should do the following: User is in a product list view They enter a start and end date (in global fields) as the report parameters …

What I want to do is paste the contents of a portal into a text field. (A pretty good analogue of the intended use: I want to send an email to program participants who have requested it; whether they're attending one program or thirty, I want to let them know.) A couple of years ago, in a solution tracking budgets, I wrote a version of this that worked but used the system's Copy & Paste functions. Having defined the portal as BUDGET_PORTAL, I wrote: which worked fine (worked well, in fact) - but used the system's clipboard, which isn't desirable. Looking for advice for accomplishing the same thing via Insert and Get commands. I thought I had it w…

I have a layout with two buttons on it. Button 1 simply sets the variable for the chosen Section [$id_section; Value:TO1a_sites_SECTIONS] Button 2 runs the "Resume Script" command I'm trying to define a calculation in the Inspector's "Hide Object When" calculation so that Button 2 only appears after the variable is set. So far no luck and any help would be appreciated.

I know that there has to be a way to do this; and I don't want to make a Script Trigger for every field that needs this. I thought that a Script Trigger OnObjectExit like this would work, but I am getting an error (102: Field is missing ). Set Field By Name [ Get ( ActiveFieldName ) ; Trim ( Get ( ActiveFieldContents ) ) ] Am I doing something wrong, or am I misunderstanding Set Field By Name, or is there a better way to go about this? Thank you

Hi all, Â I need help. I am willing to pay someone who can build the script. Â I need a script that will work on Mac / PC that will generate a nested directory folder set from the records in my database. The nested directory folder set can reside on a users desktop after the script is finished executing for now. Â The records that are used for the directory folder names are related in a parent child arrangement in filemaker - so the hierarchy for these records exists. Each record will contain a text field that is to be used as the label for each directory folder created. Â I think the solution lies in AppleScript and VB Script. I do not have the capability of …

Using Filemaker 13 advanced. I have a field (Delta T Set) that contains a dropdown list, it may only contain certain values based on a value in another field (Rise Over) that's previously been entered. The user clicks on a popover that presents the drop down where they can make choices, I want the script to trigger on modify so that they receive an error message warning if it's not compatible with the type of value in "Rise Over". Right now they are given a warning but they are still able to close the popover or exit the field. I must be missing something... any help would be appreciated. I have the script trigger on objectmodify. Set Error Capture [ On ] If [ (Phot…

Hi, I must apologise first up if this is not quite the correct area to post this... I have written a script that extracts the information I need, and then writes the results to a PDF on a layout of choice. Works well. Problem is that I want to have it run automatically from the server at, say, 8am of a morning. The only line in the script that prevents it from running server-side (which is not a meat cut by the way ) is the Save as PDF command. Alternative options included running PHP, extracting it, into container field via a template etc, and by the end of the article I had a headache, so sought another option. One option was to have FmPro loaded onto the …

My script runs but with error 100 and no invoice or any record is created, any body be able to explain this please - Thank you. #Script used to find Chamäleon, Aclass and Blue Planet tours running on current date # Go to Layout [ “Console_Guided” (Console) ] Set Field [ Console::gn_Console_Trigger_chk; 1 ] Enter Find Mode [ ] # #FIRST REQUEST Set Field [ Console::TG_Start; Get ( CurrentDate ) ] Set Field [ Console::Operator_Type; "Chamäleon" ] Set Field [ Reservati::Final_chk; "Yes" ] # Duplicate Record/Request #SECOND REQUEST Set Field [ Console::Operator_Type; "Aclass" ] # #THIRD REQUEST Duplicate Record/Request Set Field [ Console::Operator_Type; "Blue Planet" ] Set…

Hello all, Since FileMaker is a 32 bit app, when it makes a Send Event call on a 64 bit OS, the OS does its magic folder redirection and forces FM to see the 32 bit legacy system folder of C:WindowsSysWow64 as C:WindowsSystem32. 9 times out of 10 this isn't a problem. The 32 bit system apps work fine. But, some things like the 32 bit version of reg.exe for reading a remote registry on a server won't work properly when trying to query a remote 64 bit target server. So, in these events, I need to force FM to call the native 64 bit sub-system when it makes a Send Event call to the OS. This is easy enough to do by hard pathing a call to something like cmd.exe by t…

Hi there, I'm running a script on fm13 server that sets a value in a global field. the issue is I need to pass that variable back to the client when the script completes. Is there a way to do this? the reason I'm doing it this way is that I'm looping through a found set and setting the global variable and it's really slow if I do it on the client machine. Mark

Does anyone have a script for resizing a window so it (fills any size display) on Windows 7 and 8? I am aware of the maximize script option but I am trying to avoid using it so I can open multiple windows without them getting all messed up.

Background - this database is a dressage show solution - among other things, it handles scoring of dressage tests. Dressage tests are patterns that horse and riders perform where they are scored on their movements. Some movements have coefficients where the score is doubled. All score fields have a corresponding calculated field next to them to hold the final score for that movement. Â My scorers enter the scores for each movement on the appropriate layout. I have already got a script trigger on each score that mimics a the way calculators work by setting a variable with the entered score and setting the next field with that score when the user hits enter or tab. This …

not sure what to call this but I would like to turn these two arrays: array1: A, B, C array2: 1, 2, 3, 4, 5, 6, 7, 8 into this: 1A, 2B, 3C, 4A, 5B, 6C, 7A, 8B Was playing with: GetValue ( array2 ; loop ) & GetValue ( array1 ; mod ( loop ; ValueCount ( array1 ) ) ) Just get stuck on mod ( 3 ; 3 ) which I can handle with an if statement but would rather let math solve it.

Hello, First post, sorry if I've posted in the wrong area, or if this information can be found elsewhere. Here's what I'm trying to do: I have a table into which I import a status report from a vendor… one of the fields imported is an "estimated completion date". Each week, I'll have a new status report (excel file that I import) from the vendor, with new/updated estimated completion dates for each record (along with other information), that I import using "update matching fields". What I'd like to do is create a separate field that displays the PREVIOUS estimated completion date once the NEW estimated completion date has been imported/changed. I originally cr…

G'morning, all: Talk about goofy: one of our users receives a text file on a regular basis where there's no delimiting--it's a fixed string around 4K-long filled with different field data and blank spaces. As I look at it, the data is in block lengths so the first block of data is 50 characters long (including spaces, if any), the second block is 75 characters long (including spaces, if any), etc. So, what I want to do is build a script to import the file into FileMaker (into a global field), then strip the data from the global field into separate text fields. My question is, what's the best practice way of doing that? I was thinking that I'd use a loop to cut the…

I am writing an application where I want to plot a UK grid ref on a google map. To do this I need to convert from the grid ref to lat/long, and then display this using the google maps API in a web viewer. I have found the following javascript http://www.movable-type.co.uk/scripts/latlong-gridref.html which appears to do the trick. Particulaurly, this part of the code: /** * Converts Ordnance Survey grid reference easting/northing coordinate to (OSGB36) latitude/longitude * * @param {OsGridRef} gridref - Easting/northing to be converted to latitude/longitude. * @returns {LatLonE} Latitude/longitude (in OSGB36) of supplied grid reference. * * @example * …

Hello, I have a table (Loreal) with records that contain basic information fields, i.e., Project Title, Customer service rep, Project Number (Kp_projectID). When I create a new record, the key field is auto-enter serial. However, I allow modification, BUT do not allow any entry to the field, so users can't alter the number. From this table, I create a "Quote" which entails 3 related tables, and all are keyed to (Loreal) All that works just fine. If a re-quote is needed, I want to duplicate the (Loreal) record, copy the original key into the duplicated record, then add an "A" after. So going from 00012 as the original, to 00012A as the duplicate. Then I crea…

Ok if an answer exists I can not find it. I want to make a button which that if a person is in a field, clicking it will make Control-I and then evaluate it like we can do manually. I have tried keystroke trigger and different things but can not figure it out. If someone can direct me I can follow up myself I just don't know where to begin. Also I tried using set field but that ruined what was in the field instead of giving me unique entries and I do not want it in find because it changes the current records found. I want the index and it must be simple. Thank you if you can help me. And thank you even if you can not.

Hello all, I have several scripts that perform a series of finds based on certain similar criteria. I'm mainly concerned about the FoundCount in each Find case. To create my Excel summary reports, I've been entering each FoundCount in manually. This is relatively quick, but it'd be better if I could get FM to print out a summary report showing the search criteria and the FoundCount for each Find performed by the script. Any ideas on how I'd go about this? When I tried creating a report, it didn't list every Find's results/criteria. Only the last one. Thanks in advance for your help!

I need help figuring out why my preview mode is showing nothing in the script below. Funny thing is when I use the script debugger tool and walk through each step, the preview mode works... The layout has a header, sub-summary, body, trailing grand summary & footer parts. New Window [ Name: "New Monthly Orders Total"; Style: Document; Close: “Yes”; Minimize: “Yes”; Maximize: “Yes”; Zoom Control Area: “Yes”; Resize: “Yes” ] # Go to Layout [ “Print Change to Live Order Report” (INVOICElogic_invoiceID_customerID) ] # Print Setup [ Orientation: Landscape; Paper size: 8.5" x 11" ] [ Restore; No dialog ] # Adjust Window [ Resize to Fit ] # Enter Pr…

Hi All, I'm running into some trouble with a script and could use some help. I have three fields I want to concatenate into a text string. The fields are named: Proxy 1 Proxy 2 Proxy 3 The concatenating calc field is named: Text String Export What I would like to do is have the Proxy fields display a value list of other field names in my table, such as: Shot Name Pull Name Description Vendor So, for each Proxy field you can choose which other field you want to include in the concatenated calc field. Now, the concatenating calc field is working fine, but I cannot seem to get the proxy fields to properly enter the values of the other fields. I have cr…

Hello All, I have a file with shipment information that I need to import into separate tables, a shipment name/id table and a shipment line items table. The problem is it is formatted in a way that the shipment name/id is located in column 2, row 1. The shipment line item information starts at row 9 and but the number of subsequent lines vary with each shipment. I’m not sure how to go about writing a script to create a new shipment in the shipment table using the value from column 2/row 1, then create child records in the shipment line items table with the values starting at row 9. I have written a couple executeSQL calculations that gather the shipment name and li…

Hello, any help with this would be greatly appreciated as I am really stuck with this problem. Basically I have a table for Jobs and a table for Purchase Orders(POs). One job can have many POs. I have a field on Jobs called archive and a field on POs called archive which is a check box. When a Job is finished it is archived to remove it from a jobs list and the same goes for the POs. What I would like to do is be able to archive a job and that in turn archives all of the related POs. I think the approach would be to set a script trigger so that when the checkbox is crossed it goes to the related records and goes to the checkbox objects and crosses the…

A couple of years ago I managed to create a trigger whichs opens my database in Filemaker at 7 o'clock in the morning. Now I want to change the behavior of that script, but I have completely forgotten how I made it. I have been reading about 'script triggers' and related topics, but this havn't solved the problem. In the menu 'Manage scripts* I havn't got anything like it. Where is such af script/trigger defined and stored og how can I edit it? I'm running Mac OS Yosemite. I have been looking in the calender, but can't find any actions starting 7 a.m. seven days a week. P.S. My actual need is now to close down Filemaker at 8:45 monday to friday, alternetiv…

This one's driving me crazy because when I manually enter the date range in the appropriate field during a Find the data comes up fine. However, when when the script calls the variables--which have the same dates I used when manually performing a Find--FileMaker sticks its tongue out at me. There's something amiss with the script step, Constrain Found Set [Restore], but I can't figure out what. Open the attached file, click on the Lists button, then click the GO button for the "...or Date" side of the layout; have the Script Debugger and Data Viewer open. Everything works until the script reaches the marked script step, Constrain Found Set (under the Constrain b…

Good morning, all! I have a brain hernia for you: I've been tasked with creating summary reports and I'm stuck with how to best go about parsing discrete values out of each "checkbox'd" field so each value can be counted then summarized. (Mind you, the file resides on our FMP server so I know there may be some limitations when it comes to scripting.) So, say there's a checkbox'd field named Fruit and it has the following ticked values out of a total of say, ten different different values: Apple Grape Peach Orange The found set has thousands of records; each record has either none, some, or all of the values available. I take it what I need to do is pars…

Hi- I've added a 'show dialog' script step to a script. When testing the dialog I find that both the OK and Cancel buttons allow the script to continue. I want the 'cancel' button in the dialog to cancel the rest of the script and revert the field, but I can't find how to do this. Checking and unchecking the 'commit data' boxes in the Dialog setup doesn't seem to do the trick. Any help appreciated. Thanks

I have tried to find out if there is some keyboard command to allow me to continue a script in the menu bar without using the trackpad?

Newbie alert! Sorry for the confusing title but but what else could I use? I want to use the row header text in a list layout to run a sort script, however as I can only add one script to each header I have added two arrows near each row header, one runs a script to organise the layout by that row in ascending order, the other in descending order. Thing is it look unsightly and I'd much rather do away with the arrows and be able to attach a script to the row header itself that on first press it sorts the layout by that row in ascending order, then if that isn't what I want... on the second press it sorts the layout by that row in descending order and so on and…

Hi there, I'm experiencing an issue with script trigger not working when a fresh layout is loaded. Here are a number of examples: OnModify script trigger on a drop down list The user goes to a new layout they select a drop down field which has a script trigger attached to it the first time it's selected nothing happens the second time onwards it begins to work OnObjectModify script trigger of a edit box being used as a filter The user goes to a new layout they type 1 character in the field with eh script trigger nothing happens they type a second character and the script triggers the field is cleared One character is typed The script trigg…

This must be easy to do, but I just can't think it through. Suppose Field#1 contains the value "Yes". Then I want to allow a user to edit "Yes" to "No". But if Field#1 already contains "No", then I want to prevent this being changed to anything else. I'd like to do this with minimal overhead - preferably no Script Triggers or buttons or dialogues - it should be seamless. i.e. if the user overwrites "No" with "Yes", it should revert back to "No" with no dialogue. Is this possible ? Thanks for your time.

I have a list layout that has ~600 records. This layout contains fields from both the current table, and a related table. I want to perform a sort on any of these fields. What I am noticing is the first time any sort is done on that layout, it takes quite a considerable time. After that, every sort is done instantly. Is this due to the related records? Is there a way this can be done without the delay? I can make a look-up field to grab the data into the same table, but I don't really want to be duplicating the fields. Is there another method to speed up this sort process? Thanks in advance. Edit: this is a hosted solution, when run locally it d…

Hi there, I have a situation where I want to run a script once a day eg. 1 am I currently don't have FM server so I'm trying to see if there's anyway to do this with FM Pro. As we're on a windows server - Initially I was thinking of simply creating a scheduled event that would open the file, then setup script triggers to run the script. The problem is that FM asks for login details each time and since it's unattended there's no-one to put the details in. Wondering if anyone has done anything like this before using FM Pro and what method they used.

Hi all Trying to use some key commands in the navigation of my database. In list view I have the character "e" (for Edit - char 101) set to open up a separate window where the selected record can be edited via a script that is activated by the OnLayoutKeystroke script trigger. The command works, however I'm presented with the "Before typing, press Tab or click in a field, or choose the New Record Command..." FileMaker dialogue box once the script has finished running. I've tried using Set Error Capture On to prevent this but I'm failing. Any advice?

Hi So I'm just trying to understand why my logic isn't working as expected. I have a pop-up menu within a portal that resides on one of six tabs of a multi-tab control. The options for the pop-up menu are 'Complete' or 'Pending'. The business logic is that if the field is Complete, it cannot be set back to Pending. So my logic was to write two small scripts; one to store the value of the field, and another to tell the user they are unable to revert it and to reset it back to it's original value. Â so the first script (called StoreCurrentStatus) is simply: Set Variable [$$CurrentStatus; Value:Client_ACTIVITY:_Status] The second one (called ResetStatusChange)Â is as…

Hello Is it possible to have a single script step that can be used to Sort on a number of different layouts each using records from different tables but where the sort field always has the same name - Type I thought of setting the Sort field something like a global field in a Globals table that evaluates Get(LayoutTableName)&"::Type", or a variable but cannot figure out how to use this in Filemaker's Sort function. Thanks Paul

I have a series of records that at the start of each session I need the radio buttons to be ideally blank so I start with a clear slate. But from what I understand this cannot be done so I have decided to go with the option choice of including a CLEAR option in my radio button options. The options would now read as follows: 1 2 3 4 5 6 CLEAR I created a script Go to Field [ lineitem::selected] Replace Field Contents [lineitem::selected [lineitem::selected="CLEAR"]] First everytime I try and run the script my calculation of lineitem::selected="CLEAR" has to be re-entered. Second I get the following message: records could not be modified because they were in use…

HI, I hope someone can help me. I've developed a layout (Learning walks) which is linked to the staff table on pk. On my layout I've got a drop down for the staff member (to store the pk) and overlaying this a popup menu for the same field which will show the name of the member of staff. Found this workaround on this site. It works fantastically as the staff members name is displayed and the PK is stored in the table. However, on the iPad app whenever the field is clicked on, the popup menu with the list of names appears (correctly) and so does the keypad showing numbers. Again this is correct as it's a number stored in the field. However, my users would…

Is it possible do a Save Find as a script step? Couldn't find it, but just seems like that is something they would have added in v10. Thanks

We have a truss plant, and I set up Filemaker Advanced 13 with our connector products, and want to input our connector plates as well. I have Filemaker Advanced 13 on our main computer running Windows 7, but I am using a iPad mini for my Filemaker Go and using it as a scanner. How in the world do I create a script or what do I do so that I can scan with my iPad using Filemaker Go my inventory in or out? I would like to use the QR code system. Just so that I could scan a QR code for a certain product and I would have the ability to put it in or out of my inventory. Any help would be so greatly appreciated. Thank you.

Hi, Â I am creating a school db and I want to ability to email a record to some colleagues. The send email bit works fine, it attaches a pdf as required to the email prior to sending. Â The bit that's gone a bit wrong (or maybe not!) is the actual PDF has only got the layour design on there, the data hasn't been added. I'm getting a header and name of the layout and then a blank screen. Â I've attached my script. Any help / direction is greatly appreciated. Â Thanks Ann

My MarinaPro solution utilizes 14 relational windows based filemaker tables. I have an occasional customer who, as a result of custom, uses the window "Close" button to exit Filemaker instead of a layout "Quit" button provided. This I would like to prevent. I have been able to create a script the will disable the "Close" command under the "File" menu bar command; but is it possible to create a script that will disable the windows "Minimum", "Max/Restore" and "Close" buttons located in the upper right hand corner of an open Windows layout window? Thank you for any help.

When I have a longer script it is difficult to line up steps to find out indents in the script. I mean like when there is loop and If and I am told I am missing an end loop or an end if. Do you all know what I mean? Is there a plug-in or tool I can use which draws a line down each of the indents so they are easier to see whether a step is in the first, second or third indent?

I use successfully this FMP and Applescript combined script from within filemaker to open clips we choose from our FMP file: Let ( mac_path = Right ( Substitute ( Media Path; "/"; ":"); Length (Media Path) - 1); "tell application "Quicktime 7"" & ¶ & "activate" & ¶ & "open " & Quote ( mac_path ) & ¶ & " set the dimensions of movie 1 to {480, 270} " & ¶ & "end tell" ) the script calls the clip in QT and plays it However I would like to be able to play the movie from a specific frame I have this Applescript which works perfectly within FMP using the NATIVE APPLESCRIPT FUNCTION attached to a button. set film to (choose file …

I wrote a script that takes a list of values separated by carriage returns and returns the list without any duplicates. So, if your list is: apple banana pear banana apple The script returns apple banana pear Here's the script: Set Variable [ $inputlist; Value:Get(ScriptParameter) ] Set Variable [ $outputlist; Value:"" ] Set Variable [ $num; Value:1 ] Loop If [ Let([numberinoriginal=ValueCount( FilterValues($inputlist; GetValue($inputlist;$num))); numberinnew=ValueCount( FilterValues($outputlist; GetValue($inputlist;$num)))]; numberinoriginal=1 or (numberinoriginal>1 and numberinnew=0)) ] Set Variable [ $outpu…

Hi All, I have written a date search script to perform a search on a field called submittedDate. (this is a date field in a table called claim). I have a layout based on a table called person. Person is linked to Claim, claim.id = person.claimId. I have also created an unrelated table with globalstartdate and globalenddate fields. I have created a layout based on this unrelated table and put two date pickers on that view and a button. The button runs a script that does the following: Go to Layout ["MyClaimLayout"] Enter Find Mode[] Set Field [claim::submittedDate; GlobalDateFind::GlobalStartDate & "..." & GlobalDateFind::GlobalEndDate] Set Field [cl…

HI folks, I'm not sure if this is the right place for this, but it certainly involves scripting.... My colleague & I both use my dept assessment database. At the moment, every few weeks, my colleague gives me a copy of her database and I import the new records, which adds any new assessments and comments. However, the Pupil table contains fields that could potentially be updated by either of us (at the moment, any changes to this table get made on my copy of the database). In the long term, I'm hoping to sync properly using GoZync (because it doesn't need FMS) or possibly Easy or MirrorSync. - I've already got UUIDs and modification date fields in each t…

Hi,  I hope someone can help me. I've create a script (posted below) which uses the Get(AccountName) function to look up the users account name in a table and return the department they sit in (as a FK). I then use this to perform a find on my layout and return only the records that the person has access to view.  This works, however, instead of just returning the 5 or so records I want (as it does if I were to perform a find on the actual layout manually) it returns all the records but has <No Access> populated for all the other records.  Can anyone tell me if I've missed out a step in the script or something else so I can figure out why it's not worki…

Hi there - Miss A! here Help please.... I have a script that searches through records of vehicle invoices, i group records(using summary field) according to registration number and i get the first record's KMreading field and insert it on KMStart field on Vehicles running cost layout for the corresponding Vehicle reg number record, i get last record of the group and take the KMReading field and insert into the KMEnd field in Vehicle Running cost layout - i loop through until last record and script serves this task well......... OK, now i want to go back to the invoice records, this time i want to search for a particular ledger account, group the records and S…

I have a database called CABINET DATA that I use to manage math for my cabinet shop. The database contains a lot of fields that are necessary to calculate the math but far more information than we want to have on the shop floor. I want to be able to extract the values from just a few of the fields and have them show up on a separate table called CUTLIST. If, for example, a cabinet contains 4 shelves I want each shelf to show up on the list individually rather than have a separate field that indicates quantity. By having each shelf show up on a separate line it is easier to see how many shelves have been cut and which ones remain to be cut. I would like to po…

Hi all I have a db setup that has a certain area for booking appointments. I want to be able to click a button that creates a new event in iCal, using the following fields in my database: Date of event Start time Finish time Client name (would become event name) Payment type (would be inserted into the notes section) Venue (venue) Is there any possible way to do this? Many thanks!

This should be easy for someone to answer. I have looked around on my own but haven't come across an answer. What is the maximum character limit for a script parameter in FM13? And, this may be a silly follow up question but I want to make sure, is that limit the same for scripts being run on FM Server 13? Thanks in advance.

I'm very new to FM Scripting so would be very grateful for any help in getting this off the ground. I have a FM database which I've connected to a MySQL DB via ODBC (Opencart). So far I have one table (Brands) which contain data which I need to populate two tables called oc_manufacturer & oc_url_alias using an automated script. Fields are: Brands::ManufacturerID (e.g 1) - copies RecordID to oc_manufacturer::manufacturer_id Brands::ManufacturerName (e.g Apple) - Copies the manufacturer name to oc_manufacturer::name Brands::ManufacturerLogoURL (e.g image/brands/apple/apple-logo.png) - copies the logo url to oc_manufacturer::image Brands::ManufacturerSortO…

Hi, In my experience, most people use about 20% of any language 80% of the time. Scanning through the long list of script commands in FileMaker (approx. 155 of them), I'm wondering which 20% (let's call it 30 commands) do people use most? This will give me an idea where to focus my reading. Many thanks, MG

So, I've been tasked with getting our FileMaker 10 working more the way we want it for 2015. I've already managed to get the layout and calculation issues fixed and working. Now I'm working on some scripting which is an area I've alwasy struggled with. Here is what I need to do. When we write up orders, some customers are tax exempt. I have created a field where I can input an "X" to label as Exempt, but I need to be able to remove the tax from the calculation for just that particular order. Here is a screen shot of the area on the layout I am talking about. Here is the script as I have it set up: Â If [Workorder::Tax Exempt = "X"] Â Â Â Insert Text [select; Workorde…

Hi Folks, I've got a couple of search boxes on the home page which all work fine. When there are no results, I have no problem leaving find mode and returning back to the original layout, but this could cause jitters for my colleagues. I've attempted to set up a way to trigger a custom dialogue if that happens, but I've never done this before and can't get it to work. I can see problems with the attempt below but have brain fade in fixing it! I think I need to use something like: If FoundCount=0 then goto dialogue box Else exit script? Enter Find Mode [ ] Go to Layout [ “Pupils” (Pupils) ] Set Field [ Pupils::FullName; Pupils::gPupilFind ] Set Error Capture […

Just upgraded to FMServer 13 and FMPro Advanced 13. When I enter text in a field, the cursor appears two, three, or sometimes four spaces to the right of where the next character appears! Makes it very difficult to correct typing mistakes, and is disconcerting seeing the cursor in the wrong spot. Anyone else experience this issue? BTW - I am in a window 7 environment, and no one else in the office has the same issue. I'm the only one on FM Advanced.

FILEMAKER PRO 11 - I need to find if a a video file exist before proceeding to the next step. I did not find such a function. However, I think I am about to find a work around. I have too many video files which are to big to be imported within FileMaker Pro. Instead, I store there reference to the file in the container. When I browse the table, the following message "The file cannot be found:" followed by the name of the file is inserted in the cell instead of a thumbnail. I've added a get(LastError) statement after the commit. It does not work. Is there a get function within FIleMaker Pro which would returned the value "The file cannot be found:". I would then …

One thing I really like about FMP is that you can specify a "calculation" for a perform AppleScript script step. However, this does leave something to be desired. Before each quote in the AS, you have to do a backslash, and at the end of each line, the paragraph symbol. A problem I've had is that it's difficult to debug AppleScripts entered in FMP scripts. If the script is "static" -- i.e., you don't construct the script using various FM fields, etc. -- it's easy enough, because you can create the script in AppleScript editor, debug, and then copy and paste into FMP and enter the appropriate backslashes, etc. However, this doesn't work well if the script is "dy…

Hi All, Is it possible to always open a layout as a fresh new record each time without the option of seeing any records that have already been input? My layout is a form with all other views disabled. This is simply a data entry form that is fire and forget. Many thanks

I have been stumped on how to have a script trigger when a field has changed. I want the script to be able to trigger without a user entering or leaving a field (meaning it should work with the database unattended). Here is the scenario: When a date in a date field equals today a script is triggered to send an email. Seems like it should be pretty simple, but I have not found a solution yet. Set Script Triggers will not work because it requires a user to exit the field for the script to run. Thanks in Advance for your Help - Sam

Hi there I am wanting to set up a scripted to make an ical event, with data from date and text fields is this possible? any tips would be greatly appreciated Cheers D

sorry, I am a novice in scripting... I have a button which has to invoke a procedure to fill in two fields with a minimum and maximum thickness value ; this should return a list of all records matching the values between those two; just as you can easily do manually in the find menu bar inserting the proper operators Attention: the minimum needs to calculate with ≥ , the maximum with < example: product 1 : min thickness 2 mm (≥), max thickness 4 mm (<) product 2 : min thickness 3 mm, max thickness 6 mm product 3 : min thickness 6 mm, max thickness 8 mm search: client wants a product offer between 2 and 6 mm > should return product 1 & 2, not …

Hello, I'm looking for a way to script FM to send UDP packets. I can't seem to figure it out. Does anyone have any suggestions? Thanks, Alex

I have a database with a "Customer" field that (upon record creation) automatically enters the customer's name from from the previous record. I would like to change this so that this field is empty upon creation but can populated with values of previous field upon hitting a button. How would I write a SET FIELD script that can populate field with contents of previous record?

Hi, Â I'm new to Filemaker and I'm using Filemaker Pro Advanced and the files are stored on the server. Â I've written a script that saves the record out as a pdf and then I want to attach this to an email and send it. I'd like the email to pop up so the person can manually enter the person he wants to send it to. I've attached the script I've written, any assistance would be very much appreciated. Â Thanks in Advance Â

Hello.... I have 6 blocks of container fields size 2.5cm by 2.5cm arranged horizontally next to each other and grouped , i am trying to copy this part of information onto a word document and all that am possibly managing is coping one image/field at a time - i would like that if i can copy this whole group of 6 fields at once. Is there a way i haven't utilised or am i on an impossible case? Many thanks for your will to help......

Looking for some help with creating a simple script. We have a database of inventory items, when the user enters a layout to search for the item, he is presented with a screen that has the item field on it and a button that performs a script. The idea is to simply perform a lookup of the number that is entered in the field and then open the next layout that shows the table view with only those items with that item no. I have created a script but something is missing obviously, what do I need perform the find on what is entered in the field, or is it possible to create a variable just for that search and then do a search and go to the layout. Attached is a picture of t…

I have a question regarding how FM persists local variables ("$") across iterations of a script that's called recursively. Say you have a script "dosomething". And in this script there's a loop: set variable $counter=1 loop perform script dosomething exit loop if condition-is-met $counter=$counter+1 end loop Obviously this is pseudo code, but I hope you get the gist. My question is, say the first time the script calls itself. You have the original $counter, and the "new" $counter. Does the latter affect the former? That is, I know that "$" variables are local to a script, but do they persist "into" another script (such as a recursive ca…

I am new to filemaker pro and was wondering if there is a tally mark function. My students use the database in the field when collecting data on transects, and at this point, they use the Duplicate button, which makes for long, tedious lists. Is there a function for tally marks? Thanks.

If a user indicates he/she wishes to exit the database, this script progresses appropriately to the 'Exit Application' step, but then loops back to the custom dialog a 2nd time! On the second pass through the script, the database closes. Any idea how this could happen and how to avoid users having to respond twice about exiting a database? I'm stumped. The same looping occurs if using the 'Close Window' or 'Close File' steps.

I have a script that collects the last update date of a set of records. I set a local variable to it ($LastImport). Set Variable $LastImport =xyz_0::MAX_LAST_UPDATE I setup a Import Records script step that goes out to an ODBC database (Oracle 10g) to bring into a temp table only those records that are >= than the last update date. "SELECT * FROM xyz_LEVEL_0_DATA_V WHERE xyz_LEVEL_0_DATA_V.LAST_UPDATE_DATE >= " & $LastImport & "" I get this error back: ODBC Error: [Oracle][ODBC][Ora] ORA-00936: missing expression I have imported data from this Oracle database many times directly into tables but this is the first time I'm try…

I have a situation where I have a table with 10 fields and only two records, and I want to compare them and spot any differences. I have written a script that compares the two records by: a) Set ten variables with the contents of the ten fields of record 1. Go to next record. c) Set ten more variables with the contents of the ten fields of record 2. d) Compare the twenty variables, a pair at a time (one from record 1, one from record 2) to be alerted when a pair doesn't match. But now I have to do the same thing to a table with 75 fields (and still just two records). I feel as if there may be a better way, as this would take a very long time to set up the way …

We are currently running Filemaker Server vs. 11 with about 20 clients. The server is currently hosting a Purchasing Database where we are trying to determine the best method for altering a data field when the user specifies a specific date range, creates a new record or duplicates a specific record. For an example, if the user selects a date in the range between 2/1 - 2/28, a corresponding fiscal period number would appear in the PERIOD field. This would also be true if the user changed the PERIOD number, the date field would then change to indicate the beginning date of each corresponding month. Any and all suggestions would be greatly appreciated.

Hi there - Miss A! here, i need your help please..... I wonder if this is possible - ok, i have a script in which i am using set field step to define a field on another layout, this field is set to use values from defined value list but i would like to set a value for it using script and without changing the fields data entry definition(that is without disabling use of value list) - see in script below for the lines with red font: Approve Order Set Variable [ $$Order; Value:Pack Safari Order::__ID_Order_PS_Number ] Set Variable [ $$Token; Value:Pack Safari Order::lxt_Token_Company ] Set Variable [ $$Account; Value:Pack Safari Order::lxt_LedgerAccount ] Se…

Here's the one I just finished up. For my legal practice, we routinely have to generate special PDF forms for submission to the patent office that list a lot of patents and related information regarding each. I wrote a script that: (1) takes the list from a field, and parses it to remove extraneous characters; (2) check whether each patent is indeed valid by querying Google; (3) for each valid patent, download related information from Google; (4) parsing the related information downloaded and generating an XML file; (5) causing Adobe Acrobat to import the XML file into the form. I had assist from some Troi plug-ins, primarily File, Dialog, and URL, and to a …

I have a script of sorts, where I can add "tags" to a record, for ease of searching. The difficulty I am having is when it comes to deleting those tags. Here is my delete script: Set Variable [$TAG; Value:CaseLaw::CaseLaw_ShowTag] Freeze Window Go to Layout ["Tags" (Tags)] Enter Find Mode [] Set Field [Tags::Tags_Tag; $TAG] Perform Find [] Delete Record/Request [No dialog] Enter Browse Mode [] Go to Layout ["CaseLaw" (CaseLaw)] Set Field [CaseLaw::CaseLaw_ShowTag; ""] Go to Field [CaseLaw::CaseLaw_ShowTag] Refresh Window The problem is, lets say I have a tag that is: "criminal negligence" and then another that is simply "criminal". Let's say I want to delete the cri…

Hi, I am a newbie. I am doing an index. How to search for the last record in preview mode on each page? Thanks. Kent

I'm working on an inventory database at the moment. It's relatively straightforward but I've hit a bit of a snag with one feature. What we want is for a user to be able to do a quick "stock check" process by zapping barcodes with a reader. Ideally I want this to be possible without returning to the computer - at the moment we have a USB reader with a long lead but will add wireless readers once the solution is up and running. When the reader sees a barcode, all it does is enter the four-digit serial number, as if it has been keyed into a keyboard at speed. I'd like each "blip" to create a new record - each record documents an occurrence of the object being spotted by…

Hi, I'm back on the forum after a long hiatus, and I'm kinda stuck. Hoping you can help. I'm trying to write a script that will look at a field "filename" in my dbase. I want the script to go out and look at that filepath on my computer and confirm that the file exists with the matching filename, and then get the filesize from that file and then put it back into my file record. I'm assuming I need applescript, but man, for a scripting language that is supposed to be easy, I'm finding it really difficult to find a scripting resource to help me. Any thoughts? And if that isn't enough, I'd love to be able to either change the filename on the disk to match the dbase…

Hi All, first of all, forgive my English, as this is not my native language and I'm not bilingual. Glad to be here....seems to me that I've come the right place to learn about Filemaker. I need some help naming variables dynamically to move forward on my development: - I have a found set that can vary according to what I've searched - I need to go record by record in this found set and assign a value to a variable. One value per record, therefore one variable per record. - After that, I need to manipulate those variable in another process. The amount of records found have an impact on how many variables the process would define. So, if I find 10 records, I ne…

Can anyone help me as to why this PatternCount evaluates to 0, when the first part evaluates to "2005", and the second part evaluates to "2005 2004" PatternCount (Interface::CurrentRegistrationYear;List(FamiliesOnInvoices::LastRegisteredFor))

I am trying to create a random number generator. It needs to be 4 digits long. This number is going to be a unique ID for 6 7 and 8th grade students. I know of the Int("0000", Random( *10). How can this be done so that it doesn't repeat?

I have a very simple Script sequence that is going to a Related Record via a portal row button. Â The problem that I'm encountering is that (seemingly randomly), the user will be presented with an error message stating that 'This record is being modified in another window' when they attempt to modify a field in the related record in a new Window. Â I say seemingly random because the only way that I am able to reliably reproduce this issue is if I completely close out of the solution, go to the original record in question, and then click the button to take me to the related record. Â If I close the new window and click the button again, everything works fine. Â Obviously t…

Hi guys, Miss A! here...... I really do not know how to word this one.......i have two database files, i have created a relationship and defined two lookup fields in database file one to look up data from related field in database file two, problem is lookup fields only updated on new records i am creating but the old records do not update. Problem is the records in file one are created first leaving the two lookup fields empty so that they update(supposedly) when a record is created in file 2. I do not know if i am in an impossible case here, i have attempted to use script but i can not access the other database 's layout when ever i am in the other database file and…

I seem to be having issues keeping my import scripts nicely lined up. I am trying to set up a script for importing a file on a recurring basis. There are new files put out (updated data) and I want to import those the same way each time. So I have created a script that lines up the fields in the file. First off, you have to provide it a filename (it seems) in order to even get field names with which to do alignments. Makes some sense, as it doesn't know what fields are named in the file if it doesn't have a file. But then if you delete that filename from the 'add file' window, those names go away. So then if you take the next file you want to import doesn't a…

Hi, first post here. Got a problem with a very simple AppleScript that I'm very sure that was working once upon a time: tell application "FileMaker Pro Advanced" return every record of table "Mail" whose field "InternalMessageID" is "<[email protected]>" end tell The error is: error "FileMaker Pro Advanced got an error: Event not handled." number -1728 from every record of table "Mail" whose field "InternalMessageID" = "<[email protected]>" I found a topic here on this forum with a similar error (http://fmforums.com/forum/topic/93624-applescript-grabbing-value-from-related-table/). But unfortu…

Hi All. I have a strange issue with the script below. My client wants to drag a PDF into a container field (works great), automatically create a cover page, merge the two with the cover page on top and place the new PDF into a different container field. I export the original PDF to the temp directory, export a cover page PDF to the temp directory and then run a command line line app called pdftk to merge the two. All of the files are in the temp directory including the newly merged one. Everything works great until the Insert File script step. When Filemaker hits the Insert File step it will: 1) Work 2) Appear to work but nothing is inserted into the other contai…

Hi, I have a text field formatted as an Edit Box. I've attached a simple script to run OnObjectEnter. The script, which I can't attach here since I'm on my iPad, checks to see if the active field is formatted as bold or not, and toggles the bold state on/off, and works a treat. I click on it and if it's not bold it becomes bold and vice-versa. The purpose of this is to indicate to the reader that this instance, in bold, is the first a given musician has played in a given production. However, when I change the field to a pop-up menu, the script won't fire. It's as if the field never becomes active. Anyone else encountered this issue? Rick.

Hi there, I'm having an issue when creating a new window. Here is what's happening when I create a new window: I create a new modal window and set a custom size, say - 400 x 450 When the new window is created the original window (which was maximised before) automatically resizes to around 240 x 330 and stays that size. When the script is completed running I simply maximize the original window and that works, but I want the background window to at least stay large when the modal window opens. I have tried a heap of different things but can not get the original window to stay large. I'm aware that when using FM on windows that all the windows re…

I am attempting to de-bug a dynamic sorting routine in FMP 12 Pro that dynamically sorts a list of names when letters are typed into a search field. This is based on the "Spotlight Search" template created by David Graham in 2009. http://bittailor.com. This solution uses a single table ("Contacts") and 2 Table Occurrences - "Contacts" and "Contacts_Filtered" which are related by the Search_Field in "Contacts" equalling the Search_Index in "Contacts_Filtered. Search_Field is a global text field Search_Index is a calculated text field using the custom function "ExplodeToMultiKey" which generates an exploded set of data from the entered text (e.g. Thomas becomes T, Th,…

We are all Windows users with XP, Windows7 and Windows8.  I am attempting to complete a script that creates a nest of 1 folder with 3 subfolders on another server. The script will create the folders on my desktop but not on the other drive.  Path to location is: http://fdsmsvws01/DIAPP  Top Level Folder for example would be: Test One Request  Sub Folders would be: Analyst Design Program  I have tried changing http: to filewin:, but result was unsuccessful.  Currently the users have to remote access to the location.  Script steps attached.   Help would be appreciated. Jim

Hi All, I'm not sure this is possible, but said I would ask the experts Idea: Clients insurance details need to be validated online. The online system is basic - you enter a policy number, click submit and it returns either valid / expired etc. Process Needed: 1. Client PolicyID entered into filemaker 2. Button with script to: Copy the contents of the policyID field Go to online website for validating the policy Pastes the PolicyID into the field on the site (uses javascript) Would appreciate any help on this matter. Many Thanks Oirish

I have table with multiple layouts which have a field called "statusSD". I do have scripts which run et change the value of that parameters. IN order to have the field status displaying the right color, I always run the script call "Refresh all layout" to ensure the "conditional formatting is being triggered. Is this the right way to do this? P.S.: At the moment the commit record does not work. However the script is only to give you and idea of what I am trying to accomplish. Thanks! Daniel customChecks.zip

Hi I am a complete novice at Filemaker. I work for an electrical installer and am creating an inventory system for the office to keep track of parts. I am basing this on a premade example I was given. What I am looking on doing is creating a script to search in multiple fields and return only those records. For example I wish to find all of the handsets of a particular type that are in the office. Since the stock system has a field which indicates where the part is (office, onsite, repairs) is there a find script I can use. I have attempted this myself but it just returns no records found and then doesn't return to an unsorted view of the layout. It would also be gr…

Hi! Having trouble scripting the navigation to newly created record. The catch is, script is leaving layout to create parent record, and upon return to a sort is performed. Any ideas on how I can solve this? Thanks!

I have excel file with time listed as 08:00:00 AM when I import into time field I get .33333333333333331483 and it is set as a time field and there is no auto-enter on it. I need to understand how to convert this number to the proper time. Thank you for taking a look at my script need.