Script Workspace and Script Triggers

I have FileMaker Server running on Windows. A batch file on that machine creates a JSON file daily. I'm writing a script to bring the contents of that file into FileMaker so I can parse it. The script I'm working with is very simple: Go to Layout [ “GLB” (GLB) ] Set Field [ GLB::error ; Get ( LastError ) ] Insert from URL [ Select ; No dialog ; GLB::companies_json ; "file:///C:\Program Files\FileMaker\FileMaker Server\Data\Documents\companies.json" ] Set Field [ GLB::error ; List ( GLB::error ; Get ( LastError ) ) ] The `Set Field` steps are only there to report the errors generated. So I have this script and it's set up as a disabled schedule…

Hi everyone. What I am attempting seems like it would be relatively easy for an advanced user but I can't figure out how to do it on my own. I don't think I have the proper vocabulary to fully describe the steps I want to take, so I will use screenshots to help illustrate what it is I want to do. Thanks in advance to anyone who can help. This may look crazy, but the chart is common in defining relationships of excavated contexts in archaeology. "Context" serves as my unique ID for each record in the table; the table is called "FContexts". When creating a new record, a new Context number is added, but these numbers are added as text entries, not auto generated as seri…

Greetings, I am using ScribeDocSaveFile to save a file: ScribeDocSaveFile( Get (DesktopPath) & ${Projects Set-Up}::__Store Number & "Special Quote.xlsx") However, I would like to choose as to where the file will be save to. Currently it is saving to my desktop.

I only delete a record in portal by cmd - delete and it ends up deleting the entire table... How can I disable the delete hot key? KC

Hi All, I'm quite new to FM but have created a database that requires different users to enter data. I would like users to only access the records they have created so need a way of filtering on login and specifying which user is creating the record. I have a user table with unique IDs that is related to my main table. Can this be used in conjunction with the built in account function or is there another way to do this? I'm using FMA14. Thanks Paul

The calculation: $$category = "11491961930" or "11491971250" or "11491971250" or "47995855093" or "47995855093" is giving me a TRUE no matter what $$category is. I have no idea what triggered this happening since it used to work properly. I tracked $$category in the debugger and it has $$category as a text string containing no numbers in my test cases so I don't know how it would be matching that to trigger the IF statement.

I've written a looping script to run through the records of an employe database to email me a notification if its their birthday. I'm looking for the best practice for handling the IF statement for the last record. For years, my EXIT LOOP condition has been if the $LastRecord variable (set at the beginning of the script) = the last record no. The problem is that the loop will perform the IF statement for all records, except the last (which it exits upon entering). My workaround, has been to perform the IF statement for the last record, when setting the variable, however, it seems redundant. I thought I saw an example where Omit record was used as each record was proc…

I've been doing merges for years using the "Merge Mail" script. It is a handy tool. To date, when I wanted to include a url, I just had the url be part of the e-mail. Currently, I'm trying to send a note with a *lot* of links, and want to hyperlink the actual text. But I can't figure out how to do it! Searching the web has proven fruitless. Any FM gurus out there who can shed some light on this?

Is there a way to create some type of notification (Like a Popup box) after a script has printed something.

Hi, How can I use Perform Find in script for finding single custom value from value list. It is in checkbox format. Many many thanks. Kent

I currently have Skype working within my solution, where it will dial out, pause for 15 seconds, then using the speak script step, will speak one of three different messages based on field content. Is there any way to have the 'system' or FMPro only speak when the call is picked up on the other end (instead of the random pause script step)?

Ive have the following script to create an address block from the individual fields in a record. Sometimes there is not data in the 'line_address_2' and this script will produce a blank line. Can someone advise me on what to add so as the 'line_address_2' field is checked for data and if blank then don't create a blank line, whereas if it contains data the data will be added. Thanking you in anticipation. title & " " & firstname & " " & surname & ¶ & houseno_name & " " & line_address_1 & ¶ & line_address_2 & ¶ & town & ¶ & county & " " & postcode

Hi all, In my solution for managing my clinic I made a single step script (that is triggered by a button in the portal) to import records from a portal row to another table portal row using import records step, all of a suddenit stopped working, I tried the script debugger, sometimes no error occurs but records are not imported, other times error 729 occur..any suggestions?

Hi, I'm afraid i don't know if this is in the right part. I simply want to populate a text box on my page that shows the total number of records where a field (Status) shows 'LIVE' Can someone help me please Thank you

The first 10 scripts in a database used to be available by hitting Ctrl-1, Ctrl-2, etc. What has become of this?

Hi all I have created an invoice system and the line items are displayed within a portal. The user can drag and drop lines up or down to re-arrange the order if they desire. I'm very happy with how it has turned out with the exception of one issue: the user can only drag and drop lines in areas of the portal that don't contain editable fields, and after some testing, it seems it's very easy for the user to accidentally drag field contents into the container field that acts as the drag and drop, or drag the container contents to one of the editable fields, creating a big mess. I'd like to implement a double click feature to allow the user to enter one of the fields (SKU, …

Can we able to create a new records without navigate to particular table [layout]. Means.. Im in employee table(layout), I want to create a new record in department table(layout) "without" navigate to department screen. (without using the goto layout script) thanks in advance for your time.

Hi All, I'm struggling with a script and count see what I'm doing wrong. The frustration is its a simple script. For some reason the script will not action the second option. If red it will run red script if blue it will run blue script, but if green it moves down to the blue if and runs the blue script. I'm so confused. The script is just a trigger to run another script all three of which are the same just with different layouts. Any advice appreciated.

Hello All, I want to script a find based on two fields. One field is based on a global field and is used 'straight' - I mean the global field's value is "Wider Life" and I want to search for all records with the value "Wider Life" I have another global field which is user selected {"Awaiting Confirmation"; "Confirmed"; "Rejected"}. I need to convert this to a single letter {"A"; "C"; "R"} using a Case in a calculated result of a set field like this: Go to Layout [ “CPD Attendance” (CPD Attendance) ] Enter Find Mode [ ] Set Field [ CPD::CPD Type ; CPD::gTypeFilter ] Set Field [ CPD Attendance::CPD Confirmed ; Let ( [ $Txt = CPD Attendance::gConfirmFilter; $Sym = Case …

Hi all, I'm working on a script to add a foundset of records to a portal in another table. It's more difficult than normal as this portal uses a line items system to allow the same record (in my case artworks) to be on multiple lists. I'll include images of what I have so far for this script. At the moment when you run the script it just adds one record to the portal (in PRICE LIST). To summarise... can any one suggest how I can be in my "ARTWORK" layout and take a foundset directly to a portal (which itself is in "PRICE LIST") that portals information from "PRICE LIST LINE ITEMS". Graph attached too. Not sure I can use replace field contents in this case.. ? thank …

I’ve created a variable $inv_check I'd like to use as a multi-dimensional array. While I seem to have created it ok, I’m stuck on extracting values from the array. $inv_check = inv_id & start_date & rate for a list of records. Each set of values is separated by a carriage return. For example: $inv_check= 100 1/1/10 1/5/10 101 1/5/10 1/25/10 106 2/1/10 3/1/10 Now I'd like to be able to run queries on a table using the data from $inv_check. I typically use the GetValue function for simple lists, but can’t seem to get the values past the 1st parameter. How do you extract values past the first parameter? Thanks in advance for…

does anyone know a scrip to run a scrip at certain time? i was able to use OnTimer Script but i can't make it run at time i want, example make ir run everyday at 7AM

Hi all I have a layout with a few portals in it. When I make a change in the primary record I want the necessary fields to be copied in to the related records (the portal data). At the moment I have an OnRecordCommit triggered script that goes to each portal and their records and makes the changes. It does seem a bit messy though, especially as it pops up when I'm running other scripts. Is there a standard/elegant way of automatically transferring data from the primary record to its related records? TIA

Is it possible to grab the current users password via script just like Get(accountname). I know this might sound like a strange request but the scenario I want to try and achieve is to re login from a mobile database to server with admin privilege run a script then relogin with the user account and password for the actual user. I would like to do this hidden and seamless. Yes i know i can run a script with full access privilege its just that my sync routine is only working with admin login not other user login and i just cant seem to find the solution as to why, however, this workaround does work as I have tried it albeit i manually typed the password back in for the user…

I went back to 13 because I found out that every few minutes when I work on a project in the scripting workspace I have lines jumping to other positions. Its a script (but same in others) with about 500 lines and every few minutes (like 5 or so so) when I edit inside the line and go out of its scope it sits somewhere else, lets say from line 315 to 330. Its not just sometimes its all the time every few edits I do.

I'd like to start collecting data on how often scripts and layouts are used so that I can determine which of them are obsolete. (I'm certain several scripts are no longer being used, but don't want to remove access to them until I have the data to back that up.) For scripts, I believe it will be easy enough to create a new data table, and then put a line in each of my existing scripts that just writes some basic data to the new table (script name, user, timestamp). Is there a fairly simple way that I could also look at layout usage? Something like a script trigger when a layout is entered or exited?

Hi Forum. I am having a little trouble with some navigation with my master-detail layout. It works perfectly fine on the PC, but no always on the iPad. I navigate from record to record with basic buttons tied to the appropriate script step (First, Previous, Next, Last). Every time I click a button, the record changes fine, and fires an OnRecordLoad Script trigger (attached). The purpose of this trigger is to scroll the portal to keep the current record (highlighted in the portal) centered in the portal. On the iPad, it will only scroll the portal every other time I hit the button. On the PC it always works. Does anyone see something obvious I'm missing? Any thou…

HI there, I'm in the process of replacing a few calculation fields with stored fields populated with scripted calculations to speed up the database. I think there are a few calculations all referring to each other & one table is so slow it's almost unusable. I've got stuck on this average - I thought it would be pretty straightforward - find the relevant records and average them. For some reason, it's just averaging the first record record. The found set is correct. The calculation is the same as it was in the original calculation field. What am I doing wrong please?! Mike AverageScript.tiff

Hi there - Miss A! here..... I have a script that search through records to find a record for a Tour with current date and create an invoice record(For that Tour) on the Invoice layout. When i run script through debugger it is ok but when script auto runs on server it creates invoice records for all tours in the tour list, even when there is no Tour with a current date. See script in file attached, am unable to upload script within. Please help - Many thanx, Miss A! Script.pdf

I have made a simple chat layout for our database and would like it to auto scroll to the bottom of the page when another account on another device makes a new record in that table. I want to sort the records ascending so the newest record is at the bottom, but I can't get filemaker to trigger any events on new record creation from another device. I can see the new record is instantly being refreshed because the scroll bar jumps, but I can't get filemaker to scroll down when that new record is created. Any ideas?

Hi gang, I wanted to see if there are any handy tricks out there to solve a problem I am having. I have a file called "FileA" which has an important script that runs every 10 seconds to update an activity list. I want the script to HALT if the active file IS NOT "FileA" and then RE-ACTIVATE when the script has been halted and file "FileA" has been re-activated. I realize I can script the HALT/ACTIVATE this interval script via navigation button, but my problem is the users have multiple windows up at a time and just click windows when needed. What would be nice is that scripts would run independent in their own file (in the background) so that if I was working or runn…

Hello! Disclaimer: I have worked with Filemaker for a few years, but I only have experience constructing simple scripts. In the database I am working with, each of my records has an image container field where I enter .jpg files. I need to export these jpgs. Because there are thousands of records, I don't have time to export them one by one by right-clicking the container and choosing "Export Field Contents". I need to find a way to batch export the images from this container for all records. I found this FM forum that seemed promising: http://help.filemaker.com/app/answers/detail/a_id/5822/~/exporting-the-field-contents-of-a-container-field And constructed the scri…

Hi, I know this is a very simple request that can be carried out with an enter find mode but I can't seem to get it to work for me. I've got a table with a number of records and I only want to show records that are between 2 certain date through the use of a script. TIA

Ok. I am working a script that basically moves inventory around in an inventory tracking database. There are Locations things can be and Inventory Items, they are connected by a join table called Items|Locations because item can be in many locations, and each location can have multiple items. The layout I am running the script from uses a table called tracking that keeps tracking records every time items are moved. It has a portal working from the table called TrackingLineItems, which is another join table between the Tracking Table and the Invenotry Items table. (See the relationship graph attached). The idea is that you put where you are moving items to and from (t…

I am looking to write a script that creates a set of new records (one for each week of the year) for each new employee added. There are 3 tables; EmployeeInfo, WeeklyPay, Calendar. The new records created in WeeklyPay need to have their EmployeeID set to the new employee's ID and the WeekID needs to be drawn from each record in the Calendar table. (Many other fields will also be set at this time but this is where I am getting stuck). Right now my script is populating the fk_EmployeeID field correctly but nothing is happening with the WeekID. Set Variable [$EmployeeID; Value: EmployeeInfo :: EmployeeID] Go to Layout [ "WeeklyPay" (WeeklyPay) ] Loop New Record/R…

Hi, I've written a SQL query that is returning a list of data for me. I've got more than one roq, seperated by a Return. I'd like to take the different fileds out into some fields in a table. This bit I've managed to do with the use of left/right/middle/position. So in the example below. $$LLData, I've gotten 13 and 1 out into 2 different fields. When I try take 2 out it is giving me 2 13|2|1 as it's not seeing the second 13|2|1 as a seperate record. Can someone let me know howI can get Filemaker to see this as 2 rows so I can loop through the list to pull the data into a table. TIA.

Ok. This confuses me. In script maker it shows popup which lists which steps are compatible. It says: server. So is that 'server' when I am writing a PSOS or 'server' when I am writing a script to run as nightly server scheduled script? I searched. I really did. For a full hour and 20 minutes!

Running on Mac OS, and need this script to move come files (.jpgs) out of a particular calculated folder/filename sequence. I've got this working in a separate applescript (to install said jpg files), but it's built slightly differently. The issue I'm getting is this: it errors out, and I get "Expected expression but found uknown token."... Not really sure what's causing this, but I suspect it's my escape marks that are not setup properly.... could any kind soul look at this and give me a little feedback? Here's the calculated AppleScript: "set myShCMD to \\\"mv /Volume/FOLDERNAME/FOLDERNAME/ \\\" & CALCULATEDFILENAME & " \".jpg /Volumes/FOLDER2/FOLDER…

Is there a way to pull field data from either a text or number field on the displayed page to complete a url within the FMPro 14 Browser Window.

Guys, I am trying to set a search based on the year of a date; full basic no problem. I am trying to make this work with ExecuteSearch script step, and I cannot having it work. How can I make it work as I want to use Year ( Get (Current Date) ). I tried with operadors =, ##, "", etc, without result, shame on me..!!! Any help will be appreciated Regards

I have a pretty large script with a few loops. All loops have a go to record next exit after last and somehow it is not and is going into an infinite loop. Is there a limitation to this I am unaware of? I do have steps after all exit after last commands. Is this a bug because everything I read said it will end the loop? Thanks for anyone that can help. Oh FM13

This may sound like a dumb question, but... When writing a script, what would be the difference between using GetField and just using the name of a field? ie. Set Variable [ $$SerialNumber ; Value: GetField (InventoryItems::__pkInventorySerialNumber) ] vs Set Variable [$$SerialNumber ; Value: InventoryItems::__pkInventorySerialNumber ] Thanks!

Hi there I need to perform a find on Table B while working on Table A from within a running script. The find is looking for the presence of a specific and constrained piece of data on Table B which, if it's found, should interrupt or halt the script. So it's effectively If variable1+variable2+variable3 are found together on TableB, abort the script, otherwise continue working on TableA. The context is that I need to prevent an import of data if it already exists on TableB, using variables 1,2 and 3 as flags. Hope that makes sense. Thanks

My scenario is to design a routine to allow a user to import data to a temporary table, review the data, add a status to the data, click 'Go' and import the data. Ideally I want all of this to run off of the same script, which is where I would imagine the Pause/Resume script command would work, but I'm having an issue. My script imports the data first, it then pauses perfectly, allowing the user to update the status as necessary. The user can then hit the 'Go' button which I want to resume the script and continue with the import to the main data table. It's at this point I think I've got something wrong. The button is set up with Action = Perform Script (Import Scr…

Hi, Im using the Get(ActiveFieldContents) in a script which is triggered when a field is entered, and when the field is exited. However, it fails to get all of the text in a large text field if some of the text is not visible. Upon exiting the field, the script gets all the text as appropriate. I am trying to detect if the field was modified, and if so to log the old and new values. This is playing havoc with my script and I don't understand why it doesn't evaluate properly in the first instance. Any tips would be hugely appreciated. Mike

I was just wondering if there was a way of getting filemaker to count blanks. I've got a GRade field, which for some reason hasn't been popluated in all instances (Although I've not forced it to before saving record). I want to be able to count the number of blank records but filemaker won't seem to do this for me. As you can see from screen shot I've writen a simple SQL statement which is returning an array, the first row of which I would expect to see 3 instead of 0 as there are 3 blank records in the time period been checked. Any help greatly appreciated.

I can find it, hidden under Tools: Debugger Controls. And it is a toggle to remove or insert the breakpoint as Command-F9. But nothing changes in my script when I do it even if I make sure the script step where I want to insert the break point is selected. Why did they remove it from the debugger panel? Why does it not turn red any more? I can not find it and it is irritating me because I have a loop with many records I need to skip and I can't. GRRRRAHAHHHH! I appreciate any direction here. Thank you.

If you're looking for the "Script Workspace Secrets and Tips" thread, it's been moved over here. ;-) Meanwhile, share your first impressions of Script Workspace right here. Mark

I found this post: http://fmforums.com/forums/topic/96509-lines-jumping-to-other-positions/ that seemed to be describing an issue similar to the one I was experiencing. It was suggested in that discussion that it could be the result of a corrupt database file. I don't believe this to be the issue. I have put together a short video that captures what I am experiencing. I couldn't get the video to upload, so here is a dropbox link to view it: https://dl.dropboxusercontent.com/u/44119740/FMScriptReorder.avi I guess I'm just looking to see if anyone else has experienced this. Maybe it can be nailed down as a bug.

I am trying to get FileMaker to extract the content of the inbox in mail. The code works on my computer but on my clients it has an issue. The code sets cell "g_Email_Inbox" and when I query that cell from applescript it returns its contents but within FileMaker on my client's machine NaDa. It displays as empty and any scripts within filemaker see the field as empty. I have attached the script for your use. Both new up to date machines. Client is running FM13 while I'm on 14. I will confirm that is not the issue but I suspect it is not. Really need so thoughts on this ... Im stumped Mail GetMessages.scpt

Hi. I want to change the default title bar of filemaker pro, i know about kiosk mode, is there a better way to achive this without forcing my application to go full screen..?

Hello, Hopefully somebody may know this and i bet its really easy but scripting to me is still the dark arts but I'm trying to learn. I have a field that is a value list of names and i want this name to be changed to an email address so that it can be sent to that person. i.e. "Paul" = [email protected]. "bert" = [email protected] etc How do i do this in the calculation field. Many Thanks

Hello, I am setting up a production/labor tracking database for our printing plant. The users in our various departments are to log in and record their labor time using the portal display. I have one layout for each department that has a start time and a stop time function. The prepress department portal needs to have a minimum time on the first in/out record if the actual labor is less than 25 minutes. I have attached a script that works correctly only if the user is under 25 minutes on the first record. I the user works over 25 minutes the record still shows 00:25:00. I have set the attached script to function "On Record Commit" in the prepress layout.

The problem. I have a DB with passwords. When one particular file is opened in the DB, lets call it file X, the user needs to do a specific action. This action is unique to this file X. If this gets forgotten at times (and it is) it creates problems. Solution I am looking for. To have some kind of notification or pop-up appear to alert the user. Or have a sticky type note that obscures part of the record and can be moved out of the way, but is there again when opened next time. Or anything else that would help forgetful users to be cleverer.

Not sure where else to put this, so here it goes. This is FMP 10, but the problem seems very straight forward. I have a series of number fields, and a date field. As part of my other functions in this table, I need FMP to simply enter the current date in that Date field. I have a startup script that FMP runs when it starts the file, and there rest of it runs as it should. But for some reason, when it gets to this part it puts the date in one of the number fields. I have triple checked, and checked again that the script is set to put it in the right field (it is only one step anyway) but for some reason it just won't go to the correct field. I've read elsewhere that …

Hi all I have placed a short chime WAV file inside an interactive global container field which needs to play when a script trigger runs a "Done" script. I have placed the field off the layout so it's hidden from the user. When the client changes the status of an event to "done" the script fires, updating the necessary fields and plays the chime sound before closing the popover. Now, if I have just entered the layout or come into browse mode, the script executes flawlessly and plays the media on the first run, however if I go to run the script again on another event the sound doesn't play unless I navigate off the screen and back or enter layout mode and return to browse …

When trying to create ics files, for some reason filemaker generates a blank.ics file instead of a proper file. It used to function correctly but somehow the script broke. there are no missing values, every field mentioned is filled out, and the virtual list it refers to is filled with data. What am i Missing here?

I have been asking for this feature for a couple of versions now. Thumbs up for being able to run a script right from the WorkSpace! TWO Thumbs up for actually being able to debug the script from the same place. (remember the 'old days' when you had to either mouse over to the Scripts Menu, or Manage Scripts window just to run the script? And if you forgot to check the Script Debug menu item you just had to hope it worked) Thanks! Jerry

hello to all. is there a away in filemaker to have a portal off invoices for one person . and when the costumer pays to select all the open invoices in to one filed in the recite ? Thanks Dani

Hi, I have a pdf file in a container field (not just a file reference). Can I generate a script (maybe through a send event) to print the pdf file?

Howdy! FM14 is exciting (except for the still-missing code searching)! One thing that is puzzling me is that when you are writing scripts and pop up a menu for script options (Enter Find Mode for example) and a button is hi-lighted as if you could hit return to press it. You can move from one option to another with the arrow keys, but I can't find a way to (for instance) check the pause checkbox with the keyboard. It really seems like you should be able to?

I have a layout with a tab control within it, the "Default Front Tab" is "To do List". Within the "To Do List" tab I have another 'Tab Control' with the following tabs... • Markus • Karl • Scot • Secretary These tabs are also so named as objects. Additionally these names are also the user names. • Markus [User Name, Tab Name and Object Name] • Karl [User Name, Tab Name and Object Name] • Scot [User Name, Tab Name and Object Name] • Secretary [User Name, Tab Name and Object Name] I set an 'On Object Enter' script trigger on the "To Do List" Tab as follows... Go to Object [Object Name: Get ( UserName )] - I also tried... Go to Object …

Hi, I've created a database that is going to run in kiosk mode for non-admin accounts and I have a script that runs when the file is opened that finds specified records, sorts them, goes to a specified layout, etc. Is there a function or script available that would let me run that same script after a predetermined period of inactivity, for example, the database would reset to its initial state (essentially run the open file script I created) if there have not been any keystrokes or clicks in the last 5 minutes? I've looked at the Install OnTimer script -- and do use it elsewhere in the database to set some variables and move from one screen to another after a set am…

Hi Guys I am stuck on a script trigger and I would really appreciate your help. I splice fiber for a living and I am trying to track the cabinet as I visit them. I have a from layer out fine with portals showing splices and notes Etc. I would like to navigate between the records by clicking on a cabinet name laid out like a compass face with the current cabinet in the centre and other cabinets shown around the outside of it in a circle NWES but using 8 points. I have this laid out fine with a field for each point stored on the table. When I click on the cabinet name to the 2 position I want that cabinet to appear in the centre and the one that was in the centre mov…

Hi, I'm trying to create a FM-script that would create a record in table A (Kassekladde), each time a person presses a button, from another layout which is based on table B (Posteringer). Here's the relationships: And here's the script: However, it only creates the two pre-defined values "999999" and "11111111", and the rest of the fields are empty.. I've tried a lot of different things, like using a global field as the primary key, but this didnt work as well. The idea behind this setup is to make some pre-defined (scripts) bookkeeping steps, where I only have to push a button, each time I want a particular type of transaction (not sure thats the right word …

A dispatcher for a firm that we do work for prepares daily routing sheets for her drivers. Her job would be made substantially easier if calculating driving time between points were automated. I believe that this should be fairly straightforward but I'm not sure how to do this. A plugin or a custom function that would be able to submit an origin address and a destination address via a script to google maps (or apple maps) that would return the calculated drive time between the two points. We don't need driving directions or anything very complicated. Just estimated driving time. I'm sure this has been done by others on this forum in the past. Thanks in advance for …

Hello again! My idea is to have a "screen saver" like layout, that shows some "to do" records, that would show only after some time idle, without any user input into the layout. I tried working with ontimer scripts but the results I got are kinda intrusive, they do execute the script no matter what the user is currently doing, what I want is to have it to happen only if they are doing nothing for like a minute or so. Ideas are welcome and apreciated. Thank you very much!

Hello there, I want to have few dialogs to show on specific times like 10am, another on 6pm etc, is it possible to schedule it to get the local time then go to the a popup object or would I have to keep an ontimer script running to check if the time is compatible? The thing is I already have an ontimer script running on this layout! Thanks!

Hello there, I am building a service orders system, and right now when I must add a new service order for PC repair etc I am using a button that goes to the service order layout and create a new record, the thing is, if I want to cancel that record by whatever means, I have set a button that deletes the just created record and goes back to the main layout. It works ok but it is not safe as if somehow I change layout, if the db loses connection or anything that makes me leave that layout or change records and I press the Cancel button, it will delete a previous record. Is there a safest way to cancel the record adition? Can I somehow use an empty "ghost" record, add t…

I am trying to pass the name of a script through a script parameter and then run it. I need to run it on a hosted file. Is this possible?

I've been using homebase's script to export ics files, but for some reason, It is failing horribly when i integrated it to my "solution". It either outputs garbage or it complains that there are no records to export. I've reimported his demo, reassigned fields, tried removing the "/*" and putting them back, and leaving it at " " or just leaving it at the field name. It always refuses to create the file and the debugger only tells me the record does not exist. What step am i Missing to get this to work? Â

How can i make a script run automatically every 24 hours. I have a database built using FM PRO Advanced 13 and hosted on FM Server 13. -Erik

Hi Board! Looking good, like the upgrade! My FMS13 app logs product coming off the end of our production line. We have a simple BOM table, with Parent_Stockcode, BOM_Level_Stockcode, Quantity, UOM, price. Each record belongs to a Parent stockcode as a child. Many childs build up the BOM list. The BOM list is added to by selecting a Child Stock Code from a 'Products' table and entering the details. Up to now, I have just summed the total BOM cost and when a complete product comes off the line, FM grabs the latest BOM cost from that SUM and copies it into a static text field. So the cost at that point is recorded. What I'd like to do now is attach the compl…

Hi, Some Wisdom. I am researching whether or not to utilize the "Perform On Server" script step to perform "Finds / Sorts". And thought maybe I could get some insight Phil had perviously help me on this issue from a previous request. And Phil, thank you. I am researching / understanding if the "Perform On Serve" is a better way to perform "Finds, Sorts, and Script in general" We have a very slow data feed on one of the solution and the "FOUND" set with conditional formatting really bogs down the database. Is there another way, maybe use "TEXT" to code a series of vertical lines to replace the conditional coloring ?? I guess it is still a calc and would have to r…

Is there a way to *automatically* change the text on a button? My preference would be (example) If Field1 = Male, button text displays "Change to Female" If Field 1 = Female, button text displays "Change to Male" Changing (field1) and the button text each time it is clicked. I've actually got several choices I'd like to to cycle through, but this would get me started. Thanks! Daniel

Hi! I have to create a way to track my martial arts students progress... In fact it will serve for more things, but focusing now I have for example Yellow Belt, wich has for example too, 3 techniques. I want to create a new "Trainning Plan" for each student on each graduation. So I imagine I could have: New "Trainning Plan" for "John" Choose wich graduation he would be in, "Yellow". Now I have access to the Tech 1, Tech 2 and Tech 3 list. I wanted to be able to have a toggle button (like this one here in the forum for notify about replies =-)) so I could know "John" has done 2 of the 3 Techs from Yellow Belt. And when I toggled that, it would give me a percentage o…

I appear to have lost the plot and for the life of me can't see what I've done wrong. I'm trying to enter data via a custom dialog to a global field. gActivityDate is a global date field I have placed the field on the layout. I can enter a date into the field and view the same data on multiple records (i.e it's global) My script: clear gActivityDate (i want it empty when users go to enter a date - the above was to prove it was a global) show custom dialog where input field is gActivityDate I can see in the Data viewer the date appearing in gActivityDate The field on the layout does NOT change I have added a few other global fields to see if I get anything click…

I have an "OnObjectKeystroke" script trigger that is executing a script when the user types a (Tab, Return or Enter). At the end of the script it returns the user to the field. The problem that I am running into is the (Tab, Return, or Enter) is being entered into the field. How can I strip away those characters from the end of the string that the user is entering? Here is my current script: Set Variable [$f; Value:Get(ActiveLayoutObjectName)] If [Let( [ n = Code( Get ( TriggerKeystroke ) ) ]; ( n=9 or n=10 or n= 13 ) )] Commit Records/Requests [] Go to Object [Object Name: $f] End If

I have about 100 databases in a folder that are referenced from external files. If I want to change the folder name or change its location, is there any way I can bulk update the file path under 'Manage External Data Sources'?

FMPro 2011 Advanced Outlook 2007 I have contacts in outlook that I want to sync with Filemaker. I'm using Productive Computing's Outlook Manipulator. Technically, the plugin is capable of push-to, pull-from, or delete-from outlook and is not actually a syncing tool. I'd like to set up some fields that will help me sync Outlook with FMPro. If Outlook as been modifed since the last sync, I want to pull from Outlook. Likewise if Filemaker has been modified while outlook's version has not, I want to push to Outlook. If both have been modified since the last sync, I want to flag the contact in FM as conflicted so I can parse it manually. I know I'll have t…

This is an error I am receiving when attempting to import some XML. I can almost read the critical bit of information that would allow me to correct the invalid character: "at line 1, col..." And, this error window cannot be resized for some reason. Is there a windows system log I look in to find the entirety of the error message?

Hello forum, I had a few questions regarding inserting, then retrieving a PDF from a container field. Scripts attached. What I have is a table for Customers related to a table Customer_contact. In the Customers Table I have a layout/procedure to write letters to customers, either individually, or in bulk. Then print. What I would then like to do is have the option (in the Customer_contact table) to either just put a record of the contact (date, which letter sent) or save a copy of the entire letter in a container field as a PDF. The reason for the 2 options are I only really want to save the letters that are related to unpaid invoices, not the bulk letters, ne…

I'm completely flummoxed as to how I should go about coding/scripting this report so it counts and averages scores; my apologies if I'm off-topic and posted in the incorrect forum. Please refer to the attached. The goal is to count the number of times a student earns "x" score, then those results are totaled and averaged. The data is stored in a Child table as two separate fields, DomainConcat ("1a, 1b, 1c", etc.) and Score (values from 1 to 3, only.) Example: Say a student has six evaluation records. Of those six records, for Domain 1: 1a, two records had a Score Count of 1; one record had a Score Count of 2, and three records had a Score Count of 3; the total reflect…

I have a slightly complex problem I am currently unable to solve. My FMP database allows users to create "clusters" of "observation" records that are formed by making new records on a join table. My users formerly used to be able to be able to display all of the records that were not part of a larger record "cluster", but a change to the database makes this function not work correctly any longer. There are now two separate categories of "clusters", that I distinguish between with a flag of 0 or 1 in a field on the observations table. Users can make 2 kinds of cluster records, "themes" and "patterns" and depending on the type of cluster the database automatically populate…

I am using GetLayoutObjectAttribute script step to grab the value of a field. What script step do I need to use to set this same object with a new value? Do I need to use the GetLayoutObjectAttribute to grab the Field Name and then use the "Set Field By Name" script step to set it...or is there a more efficient way to set it?

Hi all, I have portal which points to a table with an x relationship, so that all records are visible in the portal. Clicking on a portal hilights the row by invoking this script: SetField [trig_hilite, Get ( ScriptParameter )] where trig_hilite is a global number field and the script parameter is the ID of the record in the clicked row. Now that these two fields match, I can use a conditional format to hilite the clicked row. Works nicely, but if course there's always another level I want to go to. I'd like to recycle this script for other tables rather than making modified duplicates. It seems that modifying the script with an additional script parameter should allo…

I have a layout that performs a script OnRecordCommit. The script includes a sort. How can I "mark" the record and then, after the OnRecordCommit script finishes, return to the same record? Thanks, Kevin

I have a script that I found about five years ago but do not know where. It has been working great until now let me explain. I have a database of students that we always match the pictures up by their student ID so that was easy. I would use as follows: In my field I would create an "image field" and make it a container then I would click on options and put in the calculate field I would put: "imagewin:/c:/Photos/" $Students::StudentID & ".jpg" So the picture of the student also was identified by their ID number not by name. This has worked for 5 years and still does. The problem I have now though is that we created another database and we want to bring…

Anyone have a suggestion for a screen management utility for Mac? I use multiple monitors and would like to have Inspector and Field Picker on one monitor while working in a layout on my main monitor. I can do this manually, but each time I leave the layout, the Inspector and Field Picker reset to be on main monitor. I have tried several, but they don't seem to play well with FileMaker (or Adobe). Thanks, John

I have a simple script that lets you select a picture from a folder and have it stored and shown as a container. The script is: Go to Field [field name] Insert Picture [ ] It works fine. But I want to also store the filename reference in a separate field, so when I extract the file to Excel to use with MailMerge, I can get the filename which would allow access to the original file that contains the picture. I tried a number of script steps with no luck. Any support or advice would be appreciated.

Hi We (our company) have just noticed that loops in FM 13 is acting very strange. We setup a simple db-file on our 13 server (v5, windows server), to test a rising suspicion - (polling) loops work bad. We compared loops and on timer script, with and without pause. We let the script run for 15 minutes and did a count on how many iterations each setup managed to run during that time. The script is based on two clients - one that creates record, and the other reads and writes to the created record. The first client creates a new record when it sees that client number two has written to the last record. 1. 0,5 s delay, no loop, onTimer 451 2. no pause, …

Hi All, Basically, I'd like to define my export script to just dump a pre-named file onto the user's desktop, regardless of their username. The best way I know of to get directly to a user's desktop would be to use the Windows Environment Variable %USERPROFILE%Desktop . However, FMP doesn't like when I use the Windows environment variable in the file path. I noticed that they have an example for "$Variable", but it looks like that's for Filemaker variables and not Windows environment variables. Is this possible and I'm just getting the syntax wrong? Or is there a different way to do this? Thanks

I managed to write a script that copies from table to the top row of a related portal record, but I am having trouble making a button that does the same. Do I need a separate button to do this? Should i use a script trigger (and button) to fix this problem? I ideally would like to do this in one step and it's not working out ( I managed to get the script to create a blank record, but then it overwrites the same record over and over)

Ok so I was reading something here about Get(LastError) and so I was looking it up and help said "When you perform a script that uses this function with control script steps, the control script steps do not clear the last error condition reported by FileMaker Pro." so my question is what is a control script step? I have looked everywhere for a meaning and when I view the script steps, there is no 'control' section for the steps so I do not know what this quote above even means. Can someone explain it please or provide an example? Thank you.

Hi! English is not my native language and I'm using FileMaker in a other language so some spelling/translation errors might occur. I have searched and tried to find a solution for this but couldn't find any. I have a text field, let's call it "Table::Colors", where users either write values manually or paste values. Most of the time the user paste in values. I want to make a script/calculation that changes the pasted value so it becomes correct. --- The user usually paste something like this: "1Green 2Dark blue 10Red3 15Yell0w Purple4" --- I have a script that runs when the user enters/exits the field that looks like this: "Insert text [Table::Colo…

I've run into a new road block. I need to be able to copy information from a field, named Crewinfo, Which has calculated text (but is of text subtype) into another field named CrewList (Also of text type) I've tried List (Crewinfo) but it does not seem to be updating as I change the field. Also, I'd like it to stop after reaching the number field named (Crewcount) which is meant to cap the number of Crew selected. (Crewinfo uses a vlookup function (from briancunnings' website) to get the information i needed to display. I now need the ability to autolist each change (and maybe a button to reset the list). I am confused about this portion and need the ability to aut…

Hello all, I have a student database that has the total of intervention hours for each student. I am trying to do a calculation which is basically sum of the total hours of all their students divided by the total amount of students a teacher has times 24. Each teacher has a certain amount of students so I what i am doing is doing a find mode with the teachers name on the students side table and multiplying whatever I find times 24. Then this is how I am unsure on how to loop through the records and keep adding each field in the records until it hits the last records. So basically I want to sum the hours of each student that the is assigned to a certain teacher. I…

set Field (Status): Case (DayOfYear(Get(CurrentDate)) ≥ DayOfYear(::OutDate) xor DayOfYear(Get(CurrentDate)) < DayOfYear(::ReturnDate); "Inactive";"Active") This is a line in my script that I setup for availability testing. However It's not working Correctly, the Case is not setting the status field right, Is this a case where I should use if instead? Am I using the wrong operands? I need it to Test the Current date (or any other Date, which I was going to test later) The intent is that if The Current Date is between X and Y X being the start of the end date and the day of first return, that it sets a person inactive. For some reason, the only part that is fun…

Hi, Â I have the attached log in script that is running on my db to provide access to colleagues to certain records. Â I've just been informed that one colleague can see more than they are allowed so I've had a look at the script using the debugger again. Â When testing previous it worked fine, however, now that there are multiple users (via Pro app) on the system, it appears that it is not picking up the right accountname from the table but storing the accountname of the last person who logged in. Â Is there a step I can add that will get it to clear out the last login information from the script once someone initiates the script. Â It is possible that two…

Layout A (window A) has an input field that is validated on entry only Layout B (window B has related fields form the table in Layout A In my script I have a step that closes Window A However, I get a validation error dialog box when it gets to this step. Even if I take focus off by adding a select Window B, I get the same error If I do not close the window, I do not get the error. I tried ading Commit Records/Request before the close step - still get the error. Any general ideas, or do you need more specific information