Script Workspace and Script Triggers

I am a college student working for a department in the school and we would like to keep a running check out system for our equipment. Lending Library is definitely the template that I think we should be using however my boss would prefer to make it easier. I'd like to know if there is any way that I can go to a 'contacts' record and checkout an 'asset' to the contact instead of the other way around. Essentially, my boss feels like it would be easier to go to the student's profile and check out several things instead of going to each individual item and checking them out to the student. If that is not possible with this template, than my next question would b…

I'm using the DoScript plug-in from http://myfmbutler.com/ in order to trigger scripts, but I've run into a bit of a problem. The script I want to trigger takes the user to a different layout. The layout the user is in when the script is trigger includes a number of fields that can't be left blank. The script is triggered as soon as a record is committed. However, this leads to a problem: if the user fills in every field in a record and then creates a new record, the first record is committed and the script is triggered. The script tries to take the user to a different layout, but by this point the user is being presented with a blank record, which doesn't valid…

I've written a script which copies data from a field which exists in multiple tables in my database, and then pastes the data somewhere else. Is it possible to use a script parameter so that I can have one script which will copy from different tables, depending on the parameter that is passed to it? When selecting the "Cut" option in ScriptMaker, I don't seem to be given the choice to cut from a field based on a parameter; I have to select the field from a list.

Is there a way to prevent users from using the OSX keychain when opening a database? I'd prefer a solution that works from within Filemaker, but I do have access to the user's desktops if need be.

I have a database file PAYROLL with multiple tables - two of which are TIMECARDS and PAYCHECKS and i have created a reusable script that will check to see if the tables window is open and either go to it or if there isn't one open then create a new window and then goto it and open the LAYOUT in the scriptname I am posting it because you can save a LOT of time - reuse it for any FILE and LAYOUT by just changing the script name since the script actually USES the name to find the window and go to the named layout. the only other thing that you want to change of course is the NEW WINDOW script step - just add your custom window size an location this one just uses a…

I have a database that tracks my company's products. Each record within the product database has related record(s) in two other databases for operations and color details. I'd like to create a script to duplicate a record from within the product database, but would like to duplicate all related records, also. The records are related by an auto-enter serial number, so when I use the Duplicate Record command, the related records disappear. I think the script should look something like this: Set variable "Old serial" (kp_serial_no) Duplicate record Set variable "New serial" (kp_serial_no) Find related record in COLOR DETAILS (Old serial) Duplicate all record…

I know previous versions of fmp server would not auto run scripts if the script exported something. Does fmp server 10 fix this? If not, can you run fmp client 10 and fmp server 10 safely on the same box?

I've been having a real serious issue with saving as pdf. I recently upgraded from 9.0.3 to 10 and there seems to be a difference in the way the pdf's are saved between the two versions. PDFs generated from layouts in version fmpa9.0.3 open just fine in both Adobe reader 9 and adobe acrobat 9 and reflect that they were created using Adobe PDF Library 6.1 PDFs generated from layouts in fmpa10 are NOT opening in reader but only in acrobat and reflect they were created using Adobe PDF Library 8.0 Both also reflect their perspective filemaker versions. I've tested this on multiple machines and both in XP and Vista and all have exactly the same issue. …

I'm getting reacquainted with FMP v10. I am attempting to create a field that results a certain answer based on a previous choice made by a user. I have a locations (X, Y, Z) for Company A, locations (U, V, W)for Company B, and locations (R, S, T) for Company C. If the Location field is the first field the user would choose from a predefined dropdown list (R, S, T, U, V, W, X, Y, Z) I would like the corresponding company Name (A, B or C) to then populate the box next to it. How would I accomplish that? By using a script?

My "application" consists of 10 files hosted on (currently FMS9) I have tried to upgrade to FMS10 and FMP10 but FMP10 (windows XP and vista) both crash when opening/closing files (FM throws a GPF) FM support say this is being triggered by some script steps in the closing scripts which is the same for all files broadly each file goes to a blank layout before closing this part of the application was inherited - is there any "right" way of closing multiple files? I can post the closing scripts if it helps many thanks

Hi, Would anyone know of a step-by-step guide for novices to create a script that when one record is created in one table that the record is also created in another table please. I know i can allow creation of records but i need to run a script in my situation. Thanks

Hey, I'm not sure if this is in the right section but i have a question about a script. I am looking to grab the first 4 digits of a 10 digit number Eg, work order - 7898754328 the (7898) is the location number and i want a script that will grab the 4 numbers from the big 10 digit work order number. Can anyone help me out? Thanks a bunch MattyJ

Hi all. I am trying to write a database which will track restaurant reservations which include customer names, reservation times, what table they are assigned to and what seat they have been assigned to. I am having problems coming up with a way to make the database create an error message when two customers at one table have been assigned the same seat. Is there a way to script this? As it stands right now, each reservation has it's own record and each customer has their own related record in a customers table, so essentially it needs to check all the customers per reservation. I apologize if I posted to the wrong forum. Any help appreciated :D

I have individual files for each school year. I have one file that contains pertinent info of all the students of all the individual files. Each record in the the "all" file has the year the student was here. What I would like to do is have the ability to click somewhere on the student ifo line in the "all" file and automatically choose and go to the appropriate "year" file ito that students record and be able to come back to the "all" file. Hope this made sense. Any ideas? Mike

Hopefully I can explain what I'm trying to do so that it makes sense. I have 2 windows open for the same table. A list view and a form view. I want to be able to select a record in the list view window and have the form view window display the same record. I've created a global field that gets the selected record ID passed to it and I can transfer from the current window to the to the form window. What I haven't been able to figure out is how to get the form window to go to the selected record from the list view. using go to related doesn't work as expected so I know that I'm missing some step. Any idea what step is missing? I'm not able to see it. …

I'm ready to pull my hair out on this one. For some reason its always the script printing that gives me the most problems. I have a script the batch prints about 20 pages from 5-7 differant layouts. Most of them are portrait but a couple are landscape. The one I'm having the most problem with is a script which runs to a few related records, and a loop process will print one of two forms. I have an "if" put in place to switch layouts with a print setup right after the layout switch. This prints fine from my machine that I've written the scrips from the other users it wants to keep the landscape form in portrait. I think I've tried every setting there is …

Hi, I would like to know if it is possible to specify just the name of the pdf file (path to be chosen by the user) based on a calculation (when the "Save Records as PDF" script step is executed). That is, when the "Save Records as PDF" dialog shows, is it possible to automatically populate the file name instead of showing "untitled.pdf"? Thanks in advance!

Hi, We currently allow our users to insert files (most resumes) into Container or Text fields. We do this one of two ways (depending on a preference that's set) 1. We use a script at the core of which is Insert Object. This works well, in that when we want to open the file again, we just use a Go To Object script step. However, extracting these files is next to impossible (Export Field Contents is not available for containers where Insert Object has been used). The Insert Object dialogue is also not that user friendly... You must select 'Display as Icon' in order for the above to work. 2. We allow the user to select the file (using Troi File), and the …

Dear Professionals, I'd like to restrict certain field so that the user can enter only a certain decimal number. I only want the users to enter: 1.5,2.5,3.5 and so on. Only x.5 But not: 1.1,2.4,3.7 and so on. I've tried the Round() function at Auto Enter Calculated Value, but did not work. I'd really appreciate if someone can help me out.

I have a multiuser solution where the users import records occasionally from an external SQL database using ODBC. The import action is "update matching records in found set". If users are modifying any of these records during the import, errors occur. I would like to broadcast a message to all the users of the database that an update is about to take place and that they should finish editing the record so that the update can proceed without problems. Is this possible and if so, how can it be done? Your help is always appreaciated!

Not sure that I'm in the right thread, but is there a way to move (in table mode) thru records using the up and down arrow keys and move thru fields using the left and right arrow keys of the keyboard instead of having to use the tab key or the mouse? I'm at the moment trying to migrate from Paradox to Filemaker, but this is the one feature that's preventing me from doing so. I mainly prefer to enter data on table mode and using the arrow keys makes it a lot easier. Thanks in advance.

I have a project that i am working on . in the report i have my client and i what to see a list of has orders what wood be billet like this. a. order date , order number ect ... b. order line ... repeat b. after this in will repeat a &b for this client thank you Dani

Hello, I would like to setup a button that when clicked, will create a directory on my hard drive... How would I go about doing this? thanks!

Hi, We have an ODBC application that connects to FileMaker. However, the FM database always has ODBC as off after installation (even though we ship it ON). Is there a way that we can run a script to switch ODBC on. I know I can open the ODBC Sharing window, but would like to switch it on for the current database. Any help would be greatly appreciated. Thanks, Jim.

How can i assign a specific layout to a specific user, so that when he logs in, he views a layout different from what the other users see.

This posting could easily have been put in the relationships section. Until recently I never realised that the scripted "Delete record" function behaved differently to the menu version.... If you have selected a portal row then the scripted version will delete the related record on that portal row - that's fine because it says so in the FM help system. If, however, you try to delete record from the "Records" menu the option to delete record is greyed out! If you were expecting the script to do the same as the menu then watch out!

I have created a series of Send Events that moves some files, zips the files, and deletes the files. There could be as little as 2 files and as many as 80, so the time to pause the script in between send events will be variable. Instead of having to overestimate the time required to process the aforementioned steps, is there a way to pause the script indefinitely until the command line returns a result, or closes? Thanks, -Steve

Hello Board! I've built a database that i've been using with no problems for a while; on FMPv9 on a Mac. I've since connected a Mac Mini with FMPv10 onto our network and shared the database. I can open it and navigate to records happily. When i click a button, i get the error message FMP Error -30872 This is a button that should move to a layout, print the layout, then transfer to the previous layout and progress to a New Record. Can anyone tell me what this error is? Thanks, H

Hello! I need to pass about 50 fields from one table to another. Can i pass more than 3 fields using the script parameter? Im using FM7Pro. Thanks!

how can i perform a search to a filed that will show me all records? that in one filed it can not be empty . example filed name b if it is empty it will not show that record. thank you Dani R

Is there a function or script available to turn a field off once the count gets to zero? I have a table that has four fields, I have the counting and subtraction working, except that the end user is able to assign keys even after all of the keys have been checked out. What I would like to find out is if there is a script or function that would turn the field off and alert the user to order more keys. Thanks for any help. Hal

Hi. I have a checkbox field with many checkboxes. I would like to create a series of scripted buttons that will autoselect preset groups of checkboxes based on the button. eg. Button A will select checkbox 1 and 2 Button B will select Checkboxes 3 and 4 Button C will seclect checkbox 1,2 and 3 and so on in various combinations Is there a way to do this? Thanks

I need to check if a month has passed since the last time a script was triggered by the "file open" script. So: File open blah blah Is condition a met? Is condition b met? Has 1 month (not 30 days) passed since last triggering? If all yes then trigger "find tardy donations" Probably simple but I can't get it. Tia Mike

For a scripted routine I need to evaluate the active tab (by it's name) on a tab panel. I may be barking up the wrong tree, I've been attempting to use the GetLayoutObjectAttribute — or else I'm just not seeing the solution when it's already in front of me. I'm sure this problem must be a no-brainer but this no-brain doesn't currently see it. Assistance appreciated.

Greeting all and thank you in advance for reviewing my post. Any guidance would be greatly appreciated. I am having a problem with a very small and simple FM database used to generate text files for a web server. Using the scriptmaker to do this, i am unable to finish dure to tthe following error: "" could not be created on the disk. Use a different name, make more room, unlock it or use a different disk. I've been playing with this script for a while now and even though i change my $path i always get eh same error. Here is my script: Loop Set Variable [ $path; Value:"/*"c:/text/categories/lvl2_" catigories::category_page ".txt"*/" ] Export Field C…

Hi all, I have been trying to using the Insert Text command in a find to set the field in Find Mode and then do the find. The steps are like this: 1) Enter Find Mode 2) Insert Text [table:targetfield;$variable] 3) Perform Find In the second step, when I tried to use the variable, it looks like this: 2) Insert Text [table:targetfield;"$variable"] It add the " " with the $variable and cause the $variable text to be insert instead of the value inside the variable itself. Does the Insert Text Command second field accept only string? If the Insert Text Command only accept string in the second field, is there a wo…

But I'm writing a script and for the first time, I notice the dialog box for the script step "Omit Multiple Records..." This applies in 9 and 10, haven't checked earlier versions. The dialog box says, "Number of entries to be omitted______". That's weird enough to make me pause. What's an "entry"? I'm omitting "records." If a mistake like that came up while I was demo'ing to a client, I'd be a little embarrassed. Am I being too nit-picky? Granted, I've probably added that script step a hundred times in scripts and never noticed the dialog, so what does that say about me?

I want to add a task list to my database, and I'm hoping I can use the new Install OnTimer Script step to create pop up reminders for when tasks are due. Any ideas?

It took 5 minutes and 2 seconds to duplicate 187 records and increment the date by one day. Is this normal or is my computer slow or my scripting choices poor? The script starts with one record which has the starting date. It gets duplicated 186 times, then the dates are entered in a loop: go to first record set variable [$$StartingDate; Date] go to next record loop set field[Date;$$StartingDate + 1] Go to next record(exit after last) set variable[$$StartingDate; $$StartingDate +1] End loop I'm likely to have many more records and more complex loops, so if it takes this long on a more simple one, yikes! Thanks for your thoughts an…

I'd be grateful if someone could kindly put me out of my misery. I'm trying to use the "set field" script command but it's not working and I'm pulling my hair out! If I want a field to contain "something" I think the script should read; Set Field [table::field; something] but for some reason I can only make a script that reads; Set Field [table::field[something]] Any help in very basic fool-proof steps would be much appreciated. Thank you in advance

Howdy, all: Just a quick question: As it stands now in my solution, a user has to double-click his or her mouse to open a file reference (a .pdf) stored in a Container field. What I'd like to do is make the container field a button so when it's clicked once, the .pdf opens. Ideas? Thanks! Rich

This requires FMP version 10 Purpose is to have field values saved, and loaded via a popup menu. And stored in a field in the same record. 1. I believe I have “Save As” and the loading of sets worked out. 2. I need to figure out “save” and "delete". Not sure how to know what item was selected before menu changed. 3. Used a custom function for the menu field, would like to avoid but not a deal breaker. 4. Is there a trick to custom sort a value list, other then my spaces at the beginning? 5. Is there a trick to add a separator in the popup? Also, would it be better to save the sets in an XML format? fmp10_menu_sets.zip

I have a "list" view - as I cursor/arrow up and down the list a different record is made active - is there a way of getting the "active" record number - ie what i would like to do is a bit of conditional formatting on the list view that makes it slightly more obvious to the user which record they are on using a formula such as if get (recordnumber of active/selected record) - ie the one with the cursor) equals get(recordnumber) thanks simon ps any solution i use has to be 9 compatible but i am open to ideas...

I have a simple navigation script attached to a button that is part of a tab sequence. I cycle through the fields using the enter key. After the last field I land on the button, hit the enter key and the script runs. Good. I copied the file to another computer. Same OS (XP) same version FM9 Adv. However the button script will not execute. The cursor lands on the button but when I hit enter nothing happens. I tried on a another computer in our office, same results. I even tried it over the network, still didn't work. I cannot not figure out what the difference would be. Hoping someone can tell me. Thanks

Hi all, I have a linguistic data set that I manage in FM9. The mechanics of it are very simple and my database is not much more complicated than a stack of (non-relational) notecards. I'd like to turn this thing into a more sophisticated linguistic analysis toolkit, but want to know if what I'm thinking would be possible. I've spent a lot of time digging through the documentation and forum posts here, but am still unclear about what scripts can and can't do. I would like a script to go through the records in one of my tables, parse the text in some of that table's fields, and output a concordance tally. A concordance tally is a list of all the words that oc…

Does anyone know if the new Script Triggers work in Server 10 Advanced or is this new feature unique to the client software only. And I guess I'd like to know the same about the SMTP email trigger as well, does it work in FMP Server 10? I've looked but found nothing to confirm the functions are a part of Server 10. Thanks in advance for any a feedback you can provide. WG

Good Afternoon everybody, Can somebody point me in the right direction in how to do this or if this is even possible. I have a list of Products(item Numbers) in a portal, and im trying to route all jobs to their corresponding "artist". What i don't want to do is send 1 email per Item Number, because multiple Products (Item number) can go to the same artist. I want to be able to route hopefully with one click all Products(item Numbers) under my portal to the Artist that's assigned 2. Thanks in advance.

Hello all, I have been pondering this scenario for a while, but I inevitably end up with multiple commas or removing data that should not be removed, so I am asking for your help. : I have a field, Tags, which contains words or sentences that have been added to the record. "Tags" could look like this: ,Red,Apple,Tastes sweet Now, I have a second field, "Add/Remove", that allows the user to add a tag to the record. Now, if I enter "Round" and presses a button, then the word "Round" is added to the string, along with an leading comma, so the string now reads: ,Red,Apple,Tastes sweet,Round The script to do this contains a single "Set field" comm…

I am trying to create a scheduled backup for every day of the week. Does anyone have a sample script I can use to model after?

Hello all, I am not sure if this is the right forum, but I am giving it a shot. I have a database of IP addresses, and these addresses can have a fully qualified domain name (FQDN) attached. However, this FQDN is subject to changes over time, whereas the IP is not. So, it would be nice if I could get the field to do a: "host -t ptr ", or the eqivalent DOS command; nslookup, to automatically check the PTR. Is this possible some way? Best regards, Jes Kasper Klittum

Hi folks, I'm attempting to modify an incremental numbering script to include a conditional step, but since I just started playing with FM a few days ago, I'm having some problems. The idea: I have a script that increments the visible (not Internal) record ID's by +1. What I would like to happen is to round up the record ID to the tenths if the last ID digit does not end in zero. Then, the subsequent ID's in this batch should start at zero and increment by +1. In other words, instead of getting a sequence like 96, 97, 98, 100, 101, 102... I would like to get a sequence like 100, 101, 102, 103, 104, and then 110, 111, 112, 113 the next time the s…

Hi All here is my issue. I have a script that inserts the current time into a field. The script works fine, BUT filemaker leaves the blinking cursor in this field. I just want the value inserted without filemaker putting the cursor into this field. Is there a script step that can avoid this situation? Hopefully this is a super simple fix. Thx

OK, this is what I’m trying to do: Make a database that will accommodate multiple users with different levels of access. There will be three levels 3=data entry + restriction to records created by the logged in user 2= data entry (which will be a summary of level3 entries) + restriction to records created by the user who level 2 supervises 1=full access I have a user info table and seven “GOAL” tables. I want the permissions to be based off the level, but I’m not sure as how to script or calc. Any help would be MUCH appreciated! Thanks.

Hi all, I am in need of some assistance, Is it possible to timestamp or crontab a filemaker script? Either through PHP or filemaker itself? I have the script, it runs just fine, I just need it to run automated. Any possibilities? And I'm sorry if someone asked this question before, just link me to the thread. Thanks everyone, Ricky

I am currently working on a project, that requires a mobile barcoding solution within the facility. I guess what I am asking, is if anyone out there has seen a solution that can communicate to filemaker via the mobile scanner, what scanner to use (user has to be able to read data on the scanner) This solution would be used in our logistics warehouse for tracking product within the facility. Thanks in advance for your advice.

Hi all, Still pretty new and need a little help. I would like to take 2 strings from different fields and join them together in another field to create what amounts to an email address. I have done this in other apps but cannot locate the calculation method in FM9. I am sure there is an easy way to do this as the scripting engine seems powerful, but it is not apparent to me at the moment. Thanks in advance for your advice and support.

Good people of FM-knowledgeland.... I need help! I'm trying to get a script to assign a field to the value of an item in a valuelist. I have customers who have many accounts, the account numbers are stored in a portal with the first field set to the account name and the second field to the account number. I need a script to look for the account name in the portal of a given customer and assign the associated account number to a field. In order to make it as complex as possible, the account name and number fields are repeating fields (10). Thank you, any insights into this process would be very much appreciated. Peter PS: While I'm at i…

I want to know who in the team has the lowest weight. In my team the is 4 players (bob, carl, jim and paul) all of them have different weights. I want to be able remove and include the members. So I have made a value list member/not member for each member. Of course I the teammembers are gaining and loosing weight. I want to know which one has the lowest weight all the time, also when I remove one, two or three member and also when they are changing the weight. Could anyone help me to get a calculated field which shows the lowest weight of a member all the time?? test_av_minsta_nummer.zip

I have a problem being able to paste a text field's contents into a webviewer objects form field that is on the same layout. If a field is manually entered into and I use the keyboard command c to copy and then click into the webviewer object: Can not use keyboard command v to paste. I can right click on webviewer form field and then submenu click on paste and it works fine. Have not figured out how to script that mouse action though. I have tried to use script copy and paste function, but that also does not paste into webviewer field. So my question is, how can I script the functionality of going to a text field on a layout, copy it, goto webviewer o…

Hi all, i need a script that, after a find ,highlights or changes the color of only the text of the found records. Makes sense?? Thank you in advance.

I have some records that have unwanted space in the field before the information. Is there a text calc to remove it on the left of the information? Thanks

Hello fellow file-makers i have a time sheet that my employees punch in to i have a custom dialog that pops up on a successful log in but i would like the custom dialog to display their name based on their ID i tried using the get active field contents but that is exactly what displays so any push in the right direction would be extremely helpful thank you in advance to anyone who helps

I can prevent modification of individual text fields on a layout by using the OnObjectEnter ScriptTrigger to sense when the user enters a particular field to redirect the user. This doesn't work with radio button or check box fields because these fields are already modified by the time the OnObjectEnter ScriptTrigger fires. How can I prevent modification of individual fields (especially radio-button/check-box fields) of a layout without using record locks?

I have recently switched from Windows to Mac, and from Access to Filemaker. In one of my databases I had a hyperlink field which stored filepaths to .jpg and .pdf files, and served to open them. Nevertheless, this field has been imported into FileMaker as a text field, so I would need an AppleScript to open the file indicated in the said field. At the same time, I will be sharing my database with some Access users, so I would also like to have an AppleScript which helps me to easily store filepaths into a text field. I am aware that this question may have been posted before, but I have been unable to find it. Thank you for your help.

Hello world ive been trying for two days now to make a script attached to a button that compares two fields contents from different layouts is this at all possible?

Hello friends i have a script which is connected to a button that shows a custom dialog asking for a username which then puts that name into a field i would then like for that button to become useless until they log out is there a way to do this? Thanks for any help in advance

How does the saying go? "With great power comes new responsibilities!" Is it possible to disable script triggers while other scripts are running? For example I have a Layout Script Trigger set for OnRecordLoad which runs in the middle of other scripts that go to that layout during their script process and interfere with the running scripts process. It would be nice to have a script step to disable/enable script triggers while scripts are running.

i created a script "script a" ( an if else script to put data from this layout in fields in this layout based on another data entry) and a button with perform "script a". it didn't execute.so i put a "beep" as the first step to see if the if then wasn't working. the script didn't beep. i tried just executing it from scriptmaker and it still won't execute. all help appreciated. judy

I have a layout script trigger set to run my script onTriggerKeystroke. And I am trying to run a script while on a layout, and without first being in a field. But each time I click the keystroke (Shift F) I get the standard...Before typing click into a field or select new record...after the script runs. I can not seem to suppress no matter what I do in the script. Any ideas how to properly use the Layout Trigger Keystroke without getting this error, and without first being in a field?

Is there way to create a script that will increment the serial by a letter. If i have an Item CRM001, and i hit a script button can i make it so that it assigns a CRM001A, then if i hit it again it will assign a new serial number of CRM001B? Thanks in advance.

Not sure if this is the right place to put this, but I saw another filemaker 10 example file here so decided to put it here. This isn't really earth shattering or anything amazing, but I really like it. the "your not in a field warning dialog box", really bugs me, and in my opinion makes my solutions feel unprofessional. I understand the need for it, heck even putting my own custom dialog box saying the exact same thing without the filemaker logo, I think will make me look more professional and help with the illusion that this really is my program. Anyways enough talk, sure smarter people have already thought of this anyways . Jeff FieldEntryWarning.fp7.…

How is the best way to delete a container's image file that is a referenced (not stored in FM) within FileMaker script?

Hi everyone, I am loving the script triggers but am having trouble with one thing. I have a solution where we enter unit codes and quantities. some unit codes like conduit, require a distance (point a to point : and the quantity is calculated. so I have a "from" field and a "To" field. Some units like a manhole only needs one field (I use the "from" field). I wrote a script that says if the unit code is "manhole" and the user tries to enter a value in the "to" field, it shows a custom dialog box telling the user he can't do that and clears the field. I triggered the script by keystroke. The problem is that it appears that the keystroke is merely postponed until …

I have a script to run a report and it is setup the following way... 1) Go To Layout "X" 2) Enter Find Mode [Restore] 2a)Specify find request setup for 2 fields 3) Perform Find/Replace [No Dialog] 4) Sort Records [Restore; No Dialog] For some reason when the script runs I have to click a "find" button on the status area on the left of the screen to continue the script? Why won't the perform find/replace[no dialog] step do this for me instead of me having to click on the find button?

Is it possible to add an item to a custom menu that does nothing more than activate a script? Thus far I've not been successful. What I'd like to do is supply the end user with a keyboard shortcut for on-screen buttons, and building a custom menu making script calls seemed to be the way to do it. See the attachment for screenshots of my approach. The menu turns up but all items are greyed out. This is in FMP9. I've posted this issue to both the Custom Menus and the Security forum (since when something is greyed out it's likely a privileges issue). My posting has received 47 looks over the past few days but no responses. Is what I'm attempting possible…

Good morning! I hope someone can help me! I have a script for saving files as PDf which works wonderfully, EXCEPT the files are 3x's larger and the resolution of graphics are worse compared to printing those same files as PDF's. So, my questions are: 1. Can I edit the PDF format properties to emulate the "print as pdf" version OR 2. Does anyone know how to imput the filename into the window for saving if using the print file function to push a PDF out If any of this is unclear (it is early and I haven't had coffee yet) please let me know. : Thanks in advance!

Hey folks -- I'm relatively new to writing scripts, but am figuring it out. In short, what I'm looking for is a script step that effectively presses "Enter." Here's why: I'm an editor, and in my video library database, I have a table of "Original Tapes" (raw tapes of documentary footage), each record with an individual tape number. Another table houses "Available Products," with each record being an edited production (and including a text field called "Raw Sources" that lists what original tapes were used in the edit). I want to go from looking at the original tape record to running a search in the other table (to see what "Available Products" utilize that r…

Is there a way to script a number field to be equal to the value of the preceding record + an increment of 1? I am not talking about the kind of serial number wherein the creation of a record increments the value by 1. I want to be able to enter a specific record and change the value of a number field to be equal to the value in the preceding record (plus an increment of 1)

Played a bit with script triggers today, have a question about tabs. I expected to be able to set a trigger on each individual tab within one tab set. But in checking this all the tabs in the set are set when one is set. Also can't seem to get a trigger when clicking on any of the tabs, with trigger set to object enter. Am I missing something here? I would think that each individual tab would have its own setting, similar to object names for tabs, and not sure why activating the tab does not trigger the script.

Am brand new to this forum and this product, but here goes. I have a data export from a supplier that I need to use in a database, but in its current format this is making it very tricky. The issue is that the csv file has 10 columns of text. The first four are in the correct format (for example make, model, engine size, trim), however the problem is that the next field can have upto 11 varients (for eample options: aircon/power steering/abs etc etc) based on the preceeding four columns and as such this is creating duplicate rows for each additional varient. What I would like to do is where make/model/engine & trim are the same create only one row, with…

Just wondering if anyone can help me with this? I have a conditional checkbox value list as a portal record, it can contain 10 items or 100 items depending on supporting fields. All the items have a differant value. Since there are so many, is there a way, through a script I can have all the items check when making a new record? I have been playing around but cannot come up with a script which will select all the items.

Hi, I'm trying to save records as a PDF in a specific directory and also insert the PDF into a FileMaker container field. I've been able to do this successfully, but for some reason the copy stored in FileMaker has a filename of "Invoicessomefilename.pdf" and this is inconvenient for users who try to save the file from the IWP site. Please let me know what I could be doing wrong. Here are relevant script excerpts: Set Variable [$PDF; Value:Get(DocumentsPath) & "Invoices" & $FileName & ".pdf"] Save Records as PDF [Restore; No dialog; "$PDF"; Records being browsed] Insert File [invoices::Invoice PDF; "$PDF"] Thanks, Brien

I'm an old hand at FMP6 but fairly new to FMP9. I'm working from a template of somebody else's work. In order to validate that I am indeed properly logged on with the correct identity and associated FMP privilege set, I create this calc in the same table as controls the layout layout I'll use it in. The calc itself also identifies that same table as the context. "Current Account Name set is " & Get ( AccountName ) & " current Privilege Set is " & Get ( PrivilegeSetName ) When logging in with a user account name and password, I would assume this should return that user's name and privilege set. But it doesn't. It returns the Admin account name and…

Hi there I have a display value list which I want to select and imports some data from other fields in the same table and populate other fields with the same fields names using a script. I have develop the script and set up the value list but can't connect the two. I'm wanting to do this because I don't want to manually replicate Data. I hope this describes my problem looking forward to hearing from you Cheers D

I have a simple script adding messages via a dialog. The dialog has one input field, a global with a default value (e.g. "Enter text here...". Dialog offers the user the chance to: (1) enter their comment in the input field (global) (2) click one of three button choices: add comment as a note; add comment as an event, and cancel. The oddity is that after much testing, only the default button works. If the secondary button is clicked, the "inputted text" never takes, and I get a message with default text "Enter text here...". If I enter identical text and click the default button, works flawlessly. I have stepped through this with Script Debugger to ensure …

Good morning, Using FMPro 9 Advanced and I'm having a problem with a script. There are two printers hooked up to the computer, a laser and an inkjet. When I set up my script I have it set to use the default printer which is the laser. Yet every time I try to print from the script it reverts to try to use the inkjet. Any help would be appreciated.

I'm working on a loop script that omits sections of the found set using a Global Number field to control which record is selected in the found set. For some reason, when using the Go To Record/Request/Page step with the option "By Calculation" - the calc being Global Number + 1 - it completes the action as designed, but clears out the Global Number value. I've checked it using the Script Debugger and Data Viewer in FMA. Any advice?

Hi, I am trying to create a script whereby i search another table for data contained in a field of another table, so far, using the 'found set' script step seems to be the right way, except i'm unsure how to place in the contents of another field into the criteria box, as it seems to want something plainly written in? any ideas very much appreciated, thanks!

I've just found the courage to try to convert a very complex database from filemaker 6 to filemaker 9. The original was 10 years in development, and has a great many complex scripts. (As I'm an amateur, some of you might see the programming as awkward) In any case, I have managed to make more than 60 notices of: "This record cannot be modified in this window because it is already being modified in a different window." go away, but two remain in the stubborn path of my executing scripts. Is there any way to find out which window and which record is being blocks, and which window is trying to do the other modifications? I've added "commit" lines all over the place. Particul…

I have a question about the new FM10 feature. I've enclosed a sample script. I have the OnObjectKeystroke on each of the enclosed fields. I would like the user to be able to push a single keystroke of T or F, and then move to the next field. I have it triggering a script that simply has a step go to next field. I do not understand why this gets caught in an endless loop after just pushing one key. This is not how I understand it to work via the help menu. Any ideas? Script_Trigger.fp7.zip

Looks can be deceiving ... I have found a slight inconsistency OnObjectExit (file attached)... Purpose: Go to next record and field text1 after you exit text3 field then commit the record. Place your cursor in text3 and tab (or click) out. The record actually DOES commit (I know this because you can immediately check Records > Revert Record and it is grayed out) but the cursor remains in the field and it LOOKS like it still has possession. Second script - Commit script shows what cursor SHOULD look like when it has been committed. I wanted to point this out because it can deceive people when they assume they still have possession. Cursor display and posses…

Hi, There are a way to automate a find Requests? For example: I made the following script: Go to Layout["Resumo do mes"](Expense Report)] Perform Find[Restore] Sort Records [Restore; No dialog] The Find Requests is: Date of End of Month >=*/*/2009 Every year I have to change the Find Request (in the past the Find Request was >=*/*/2008 There are a way to automate this? I tried to create a field (name dtfr) to be the Date to the Find Request, but didn´t know how indicate this field to be the Find Requests. Thanks for help!

I have the follwing script I use to print envelopes from my invoice table: Go to Layout ["Customer Invelpes" (Orders)] Show All Records Omit Record Show Omitted only Print [Restore; No dialog] This works fine from my invoice table. When I try to print an envelope from my Customers table it only prints the envelope that is the current record in invoices. How can I set this up so that it prints the record that I am viewing from my customers table? Thank you for the help.

Hi, Can someone please help a real green person perform this function. I'd like to be able to, select two dates and then at the press of a button send the results of a search to a layout that will be able to produce a letter that is only for customers whos birthdays are within the two dates. I've tried looking at other threads and kind of get them, but when I apply thier logic to my DB, it all goes wrong, I get confused, it goes more wrong and then in my heightened sense of confusion I find the delete DB button, and then I have to start over again. I've made some real progress this time, principly by avoiding this issue, and now I can't avoid it. I'll…

I have a text field with paragraphs of text, and I wish to create a scripted button that automatically formats (the active selection) with a particualr color size and style. I would like to leave the remainder of the text formatted as it were originally entered but I would like to be able to make various different selections throughout the field and click on my script button to change that selection's formatting to a preset format (bold highlighted in yellow and larger). Thank you, Chris.

Hi, I have a text field from which I want to extract the last 4 letters. I want to use these letters and insert them into a field during a scripted search. Here is my script: enter find mode (pause) go to field ( annuaire:# tel) insert calculated result ( select; annuaire::#tel;right ( annuaire::#tel bur;4)) perform find() The reason for my post is obviously because it does not work. Where am I failing? Cheers

Attached is my best effort at emailing an attachment. I can't get the file to insert until after sending a second email. New to scripts so please help with the final steps I'm missing. test.zip

In my database, I store cases assigned to me. Within each record I store a PDF version of that case in a field Case Brief::Case PDF. I send a form email to the victims of each case requesting further info. The problem is I want to attach the PDF case to the email when I send it to refresh their memory on the case to which I am referring. The attachment part is where I get lost. Thanks for everyone's help. Im using work's version of 8.5.

I'm trying to open an external file (PDF, MP3, whatever) from FM by using the Open URL script step. It does not seem to be working. I've attached the Open URL script step as a Button action. I tell it to use the current field ( a standard text field), which has the URL typed into it in this format: file://Users/username/Desktop/test.mov (or.pdf or .mp3) I also tried this: /Users/username/Desktop/test.mov I'm on Mac OS X and only need this to work on my local machine. Based on my research, it seems like I have the path correct. I've tried other paths as well, but none of them work. The button fires, but nothing happens. Thanks for any help!

I'm in the market for a plug-in to FMP9 which will enable end users to choose a folder on their hard drive on which to save an export out of FMP. Back in FMP6 days I was a happy user of the Troi plug-in for that purpose. Is Troi still the best of the breed, or has something else taken its place? Would appreciate hearing your views.