Script Workspace and Script Triggers

Is there a way, within a script, to create a list of all scripts that are currently active (paused)? Get(ScriptName)seems to only offer the name of the currently executing script. How can I generate the name of a calling script, as well as any currently paused script? Thanks in advance for any suggestions.

I am wanting to create a text field that makes it easy to place a timestamp on notes added to the text field. Does anyone know a good way to go about this? If you look at the attached image, you can see what I have in mind. Upon clicking the "time" button, the field automatically returns down one line, adds the current time, and then allows you to add text. Any help is greatly appreciated! Thanks for your time.

Hi all Wasn't too sure if I should've added this to my last post as they are vaguely connected. Anyway, I have added a cancel button to my layout that cancels a new record request. This effectively deletes the current record. I have also added a cancel button to my search layout which basically exits the current layout and switches to another. My issue is bypassing validation on clicking cancel. If I have a date field for example, that contains invalid search criteria, I would prefer it if validation does not take place so as the user does not have to change the field contents, and simply exits the layout. I'm not sure if this will be possible as the v…

Hi All, I am working on a database solution for a clinical research project, and I've come up against a problem. I use one table for patient information, and a related table to store outcomes data for each operation. My goal is to perform a find in the operations table, but I need to exclude any records with duplicate foreign PT_ID keys contained in the found set (duplicates arise from patients who have had more than one procedure done, but for this project only one data set for each patient will be analyzed). I would greatly appreciate any insight on how to construct a script that accomplishes this. -Ryan

Would someone please write a clear, concise tutorial in layman's terms for the Set Field script step? Or at least point me in the right direction. I have searched this forum and the entire Internet along with every book I have from v.7 to v.11 trying to understand this step. I am trying to get away from copy/paste and all I want to do is copy the data in a field then go to a different layout and paste the same data into the same field. IE; I have a table named Hotels which contains an auto-generated serial number field (HotelSerNum_pk). I also have a layout for printing commission invoices for said hotels. I have placed (and removed) and re-placed the same …

Hello, I need to selectively import a sizable number of names and addresses from an Excel spreadsheet into our company contact database, which is in Filemaker. Some names and addresses already exist in the database, others do not. The proposed methodology is to convert/import the Excel document into Filemaker, and then do the import using a script. Since my scripting expertise in Filemaker is somewhat limited, I'm hoping someone has or could develop a script that would do the following: Given a record in the source database (the converted Excel spreadsheet), 1) copy the "LastName, FirstName" 2) go to the target database -- the company contacts 3) pe…

Hopefully this can be done though I have spent a lot of time and have not been able to figure it out or find anything online to make this work. Here is the situation... I have a phone system in my office that allows me to select a phone number in any application (e.g. Internet Explorer, Outlook , Word, FileMaker, etc.) and press a keystroke to dial that number automatically. For this to work there is a small application that I install on my PC that allows me to set the keystroke I want to use to dial a number. Currently, I have it set to CTRL+D. So I highlight a phone number in any program, press CTRL+D and my phone on my desk dials the highlighted phone number. …

Hi I am trying to work out how to set the number of figures displayed in a calculation. At the moment it comes out to 10 or so decimal places and in effect, I want one decimal place or zero. I have tried using the number format in field settings; however the script below is set as text because it also has a labelling function to deal with and I cannot set the decimal places on this. The script below is displaying the result of a calculation in a different field/part of database which is displayed as a number format and this caluclation is displayed in number format so I can set this to zero decimal places. However, when I view the field it certainly looks like zero…

Hi everyone. First time poster, longtime non-intense Filemaker user. I overhauled a very bare-bones, leggy and non-reportable database created by someone else who didn't really know about the simplest of Filemaker's features. She'd had, for example, a field for each of three widget types and had been putting X's in the fields to identify widget A, B or C rather than have one field with a pull-down menu or radio buttons. The boss is going crazy for my new version with menus and automated scripts and stuff. And it isn't even very complicated, just so much easier to manage than before. ONE problem...each time we open the database we get the error message ""t…

I am having some problems developing a button script that will find all records that are in the current month, from one year past. The field that it will search is a date field. I am sure this is an easy fix for some, but I cannot seem to get my script to work. Any help is greatly appreciated, thank you!

I have created a button to open a application while in a database. I now format it to do a AppleScript. I write under the button Native Applescript: Perform AppleScript ["tell application "AppleScript Editor" to activate"]. Needles to say that the script tell application "AppleScript Editor" to activate works fine if ran directly from Applescript. I get error: A property can’t go after this identifier. It than highlights Perform AppleScrip I looked in the manual where there is an example of how to copy paste to a ApplewWorks document and as such I can see nothing wrong with my formulation. Anybody know why this happens? FYI I…

I would like to create a script that,given a value of WeekOfYear, creates seven new records, and populates the date fields with dates that correspond to the WeekOfYear. For example, for WeekOfYear 14, 2011, the new records would have the dates 3/27/11, 3/28/11, 3/29/11, 3/30/11, 3/31/11, 4/1/11 and 4/2/11.

I'm completely new to FileMaker and I'm trying to learn it on my own. I need to create a contact database, which there already is a template for in FM11 advanced. However, I want it to be able to do the following: when a new contact is added, I want to be able to choose from 4 types of contacts from a drop-down list. This I have been able to figure out myself, so it's done. What I need help with is the following: when I choose one of the 4 types, I want a couple of extra categories added, depending on which type I choose. I THINK I need a script for this. Something along the lines of "if type X, then add categories "expertise", "current project" etc. Can…

You know that error that you see when two serial numbers of FileMaker log into the same server? The second copy to log on gets a message that the serial number is already connected to the server and FileMaker quits. I'm getting that, but in a very odd way I've never seen. First of all, the "server" is a copy of FileMaker Developer running on Windows. The client is FileMaker Pro running on Mac OS X. The error doesn't come up when the user connects to the server as one would expect, but when a particular script is run. This is a multi-file solution and one of the files tracks projects and another stores documents. The documents table is an external data source within t…

In our systems we will often use scripts to trap for incorrect or missing data. Around the office we call these 'loop catches' because we use a loop to trap for the problem. They usually look like this: Loop If[isEmpty(VariableData)] Show Custom Dialog ["Variable Data"; "Variable Data must be specified."] Go to Field[VariableData] Pause/Resume Script[indefinitely] End If Exit Loop If[not IsEmpty(VariableData)] End Loop I'm wonder in folks have a more efficient way of doing this. For technical reasons we do need to do these operations in a script, but I bet there other (perhaps better) ways to do this.

Is it possible to use a script parameter containing the name of the field to be modified into the first parameter of the Set Field By Name step? In other words I'd like to use the same Set Field By Name step to modify different fields by passing the name of the field to be modified into the script via a script parameter. It seems like this should be possible, but I'm not having any luck. Thanks in advance.

I wrote a script to create a new record in a related table and populate some of the fields. One of the fields is being populated by a variable that is saved from a global field before switching to the related table, and at the end of the script, I want to clear this global field. Here's what I have written: (starts from Teams table) Commit Records/Requests Set Variable [ $TeamsID; Value:Teams::TeamID ] Set Variable [ $ProgramID; Value:Teams::gAllPrograms ] Go to Layout [ “MembershipPivot” (MembershipPivot) ] New Record/Request Set Field [ MembershipPivot::TeamID; $TeamsID ] Set Field [ MembershipPivot::ProgramID; $ProgramID ] Go to Layout [ “Teams” (T…

this is a layout thing, but the problem i have is script related, so i think i'm right here. because i change field labels, i format my radio buttons with a generic 1,2,3 option. this is hidden, because i make the field very small, so you can't see the 1/2/3 text labels. when you now click an option, there's an ugly box around the buttons. therefore, i have disabled field entry and overlayed transparent buttons over the radio buttons. they are attached to individual scripts that change the field value accordingly. for a radio button with three options, that's already 3 scripts. considering there are many radio buttons in my solution, i already have a ton of scri…

I have flag fields for types of student financial aid Students::Pellgrant Students::Staffordloan Students::Plusloan How can I write: Set Variable [$aidtype; "Pellgrant"] Enter Find Mode [] Set field [students::$aidtype; 1] // to find records where Students:Pellgrant = true Perform Find []

It's been a while since I worked Filemaker heavily; last time was back on FM v5.5. What I'm wanting to do is take Excel data, import into FM Adv 11. This data relates to statewide technicians for the company. Creating the database is OK. Now that I have that, I want to perform a script that allows me to place a "sort key" note into a field to show whether that technician is in the north, south, or central part of the state. I can do a find on the tech by name in the script, but I'm rusty on how to then perform a field paste of all subsequent "sort key" fields relating to that tech. I.E. if I find all the records for Technician A who works in the north, I want to place an …

I am using FM 11 Adv. to create a non-profit membership database. The relationships are as above and seem to work. In the above layout, I hAve a MEETINGS::MEETDATE field. When a new Meeting record is created, the user selects the Date of that meeting in the Meetings::MeetDate field. This works. What I am trying to do in the two scripts above is: "Find Meeting Duplicates 1" grabs the current value of Meetings::MeetDate in $$MeetDate1. This happens with a script trigger of OnObjectEnter. Then with OnObjectModify "Find Meeting Duplicates 2" script runs and establishes the 'new' value of Meetings::MeetDate in $$MeetDate2. Ultimately I…

Im running a script to evaluate whether a field is empty and if so allow anyone to enter a value. If it is not empty only a specific user ID can change the value. My problem is that it seems all the script triggers only evaluate the script after the value is entered and the result is thus always "not IsEmpty = true" even though it is an empty field with new value being entered. Any advice, ideas or help would be greatly appreciated!

Hey Guys Maybe I've overlooked a simple way to do this, but I'm struggling to make the script I have written work efficiently. I'll start with a short background on my application and then I'll cut to the chase. I work for a popular cinema chain. I have developed an application for our projectionists to use to keep track of all the movie prints, schedules, auditoriums, projectors, etc., particularly in our large multiplexes. I'm pleased with how the application has turned out, however there is one function I'm trying to implement which is giving me fits. Every week new movies arrive and others are sent back to the distributor. What I'm trying to make is a …

Hi. Is there any way I can detect if a window is running an OnTimer script without manually controlling this in the relevant script? I would like to be able to check if the automation is running as planned, either in the Data Viewer or within other scripts. Cheers, Andreas

Please forgive if I'm posting this in the wrong section. I am coming back to FMP work after too many years and getting back up to speed by looking at the Starter Solutions in FMP 11 Advanced. I've noticed that in the Contact Management Starter Solution, if you double click on the container field intended for a photograph, it will open a small window for audio recording, and allow you to create an audio file which you can play-back from that container. This is the first time I've seen this audio recording option, and I would like to use it in the future. Does anyone know how this script operates? I'd appreciate any advice.

I've seen this sort of question before (but the answer still eludes me), so excuse me for asking a very similar question. I have a backup script I've written for a legacy database. Don't ask me why but their database is in 3 files. I plan that on exit each of the files creates a backup which gets emailed to someone as an off-site backup. To reduce clutter I want the backups to go into a folder on the users desktop called "DB_Backups" This works fine on my Mac, but not on the users Windows computer. They get the error "could not create the file . . ." Set Variable [$filename ; Value: "backup.fp7" ] Set Variable [$filepath ; Value : Get(DesktopPath)…

EDIT: Found it. I want to move Students records to my Graduates table. Is there an APPEND function similar to what dBase has/had?

I have a flag field, empty at the start, that I want to flag with a "Y". Finding that set of records with empty fields, Enter find mode [] Set Field [invoice::processed; ""] Perform Find [] doesn't work. Enter find mode [] Set Field [invoice::processed; isempty(invoice::processed)] Perform Find [] doesn't either. If, instead, I enter "N" in the field first, then later: Enter find mode [] Set Field [invoice::processed; "N" Perform Find [] That works fine. What is the syntax for a found set based on an empty field? Or what is a better approach? Thanks

Hello All again, My solution is almost 100% complete, just tidying up a few things, so thank you all who helped me along the way with advice. On to the next question... I have a script which finds all jobs quoted in the last 7 days (see "find Script" screen capture attached) - this script works well. I have written an Error Capture script which seeks to identify "no records found" in a find enquiry (see "Error Capture" screen capture attached). I want to introduce the Error Capture script into the find portion of the script, but I am not sure where to put it. What I want from the script is ... Start the lookup, if records are f…

I'm thinking of using filemaker pro 11 on a tablet (with a full windows os) as opposed to using filemaker go on an ipad. Has anyone had any success running a script to automatically import photos in to filemaker from an internal camera on a pc tablet? I know its automatic using ipad/filemaker go - but I imagine I need to create some kind of OS based script to do it on the PC. Specifically, I don't want to take a bunch of photos into a folder and then import them. I'd like to be in an inspection report, fill out a description and then trigger a script to snap a photo and load it into the container field in that row, then move on to the next row and repeat, etc...

What's wrong with this script? Copy does NOT copy to the clip board. $$string gathers the email addresses ok. all the other variables work (I can see them in Debug) Ideas appreciated.

Hi everyone, I'm trying to do a record search in a script. The result is counted with a Get(FoundCount) function (i think that this is the right name because my localized version is Dutch). If the counted result is smaller then a given number it is allowed to enter a new record. The value 0 is smaller so in this case the user must be able to enter a new record. The case is when the result is 0 I am prompted with a dialog "No records found" Is there a way to avoid or supress this dialog box? Thanks in advance for your help. Kind Regards, Adri Oosterwijk

Hi, I'm looking for a script step (or custom function) that will allow me to check the validation rules associated with a field from within a script... (so I can do something like If (field passes validation check)... The problem is that when I use the "commit record" step in the script, the user gets presented with the error message defined in the field options settings from within the database manager window and the script pauses for their input (revert or cancel). I'm looking for someway to prevent that message box from popping up and scripting my own procedure (revert the record and show a different dialogue) I've already looked at this (http://fmforums.com/…

HI im a newbie to FileMaker, have had experiences with DB programming basics before but that was 7 years ago. I'm currently trying to see if it's possible to trigger an email to be sent automatically by filemaker once the value of a drop down list changes. While on the layout view, i set the button set up to "Send Mail" and upon testing it did send, but it was after clicking the list and not even changing anything. Hope someone can help. thanks, you help will be greatly appreciated.

Hello again, Is there a way to have users select (either with a check box next to the field name, or by clicking the field name itself etc) a field and have it appear on a new layout as a report? Depending on what the user wants to see, they may select different fields everytime they want to do a report. For example... I have a layout that contains about 40 fields. I want the user to be able to perform a find within that layout, then select the specific fields they want to see reported. If the user wants to see how many sales a particular sales person has achieved in a particular month, show the individual sales and have a total dollar value shown on…

Hey everyone, I feel like there should be an easy answer to this question but I have yet to find it. I want to change the value of a Pop-up menu field using a script. That is easy enough. The problem is that the pop-up menu value list contains two values with only the second showing. The first is a record id and the second is the name of that record. So, when you select the pop-up menu you get a list of names. When you select the name it actually fills in the field with record ID, but you still see the name. However, when I set the field using a script it shows the record ID instead. Does anyone know how to fix this? I have tried refreshing the record I have also u…

I'm using FMP 11 Advanced on Mac. Once I open a database, I should be able to go to Files->Sharing->Instant Web Publishing. But that feature is not on the list. Files->Sharing-> only has Filemaker Network... 4 (4 being a second choice item) Any ideas?

I want my users to see a progress bar while a script is running in the bacground to update their files. How can this be done?

Hi. I need help with a script line that will insert a variable into a field. Here's the premise: I have two related tables: contact info and project info. From the contact info layout, I had a script that copied the clientNumber and then created a new record in the project table and pasted the clientNumber into the new record thus automatically linking the project to the client. The copy/paste method fails of course because of clipboard issues. Now I'm trying use a variable to handle this task. What I want is for the script to set variable X to the clientNumber then when the new record is created, insert the value associated with the variable. I've been ex…

I'm trying to create a script (that will function on any layout—that is, one that doesn't need any field names or layout names written into the script itself) loop through all of the fields in the current layout once, count the number of fields that are empty on the current layout, and then set a variable "$Empty_Fields" to that number (the number of empty fields on the current layout). I'm struggling though and I know that one of you guys can whip upa simple script in seconds that'll accomplish this...any help would be greatly appreciated! thanks,

I've made some great strides with my invoicing solution for the local rental inspection department - Comment, bcooney and others have been extremely helpful! I think I'm in need of a nested IF statement, or a case function, in a script, but I'm having a bit of trouble wrapping my mind around the logic. The script I'm working on takes a group of dwelling units that are due for "recertification", loops through the batch comparing the ownerID - when a new owner ID is found, the next InvoiceID# is created, and the following recertification fees are placed on that invoice, untill a new, unique OwnerID is encountered. This is working very well with the single compa…

how do i delete a topic? (vs erase it's contents like this)

Hi All, I've just started having some trouble with date formats. I start off in a Search Layout/Table where I enter a Start Date and an End Date into Global Fields from that Table. From there I trigger the following script: Go to Layout ["Table1" (Table1)] Enter Find Mode [] Insert Calculated Result [select; Table1::Date; "Search::Start Date" & "..." & Search::End Date] Perform Find [] This script has been working for over a year, and today I got the following error: The value of this field must be a valid date in the range of years 1 to 4000 and should look like "2003/12/25". Options given are "Revert Field" and "OK" All of…

Is there anyway to work around the fact that you can't sort by a summary field? I tried creating a new calculation field that equals the summary field but I didn't get the correct values to copy over. Any suggestions?

Is it possible to initiate a startup script without the pesky login dialog? In File Options... it appears you can turn off the log-in system, but it still pops the dialog asking for the admin PW. Any work-arounds for this?

Hoping someone can help me as I am a rank beginner and what I'm trying to do is rather complicated (or so it seems). I have a table which has a field called Visit and it's populated with the following: Month X - Day 1 (Day 2, Day 3, etc.) In another table I have a field called Month which shows the actual numeric value for each month: 1 for January, 2 for February, etc. What I need to do is to create a relationship between the two tables on the above fields and then I need to take the numeric value in "month" and insert it into the field called "Visit" to replace the X (which was used as a placeholder in another database.) I think I got the relatio…

Hey, I have a database with two tables - Main and Sub. There is a one-to-many relationship between the two i.e. One record in Main table has a unique key mapping to multiple records in the Sub table. I'm creating a data entry layout where I don't want users to access the two actual tables. Also, the data entry layout has a portal which means that user will be entering data into both tables at the same time. To protect my data, I intend to create two temporary tables(Main-temp & Sub-temp) with same schema as Main and Sub tables. All user data entry will go into these temp tables. And the user can either create new records or edit existing records (For edit reco…

I have some fields in the same table: FirstName LastName Status (A popup with two choices) street city st zip etc It is imperative/mandatory that the user be taken from the LastName field into the STATUS field. I tried OnObjectSave & OnObjectExit script triggers attached to LastName with script that has a Go To FIELD [status] but if the user clicks from LastName into another field, (say street), nothing happens. (looks like a mouse click over rides a script?) I am, again, probably making this more difficult than it should be. Ideas?

Hi All. I have a layout where employees can go to print what we call Sets. The script goes to the Sets layout, loops through till it gets to the next set that has not been printd, stops there and prints the set. After printing it tags that set as printed on this date by said employee. That all works great. The problem I'm trying to figure out is what to do if all sets are printed and how to specify a dialog if the loop gets to last record and exits without finding a Set to print. Here is my script. Perform Script [ “User Abort” ] Perform Script [ “Set Error Capture” ] Set Variable [ $param; Value:Evaluate ( Get ( ScriptParameter )) ] Go to Layout [ “Sets_F…

If I use the send mail script ( using client mail) only the first in the list of attachments adds to the mail. Any workarounds (other than a zip file)

How can I set Filemaker to open a specific layout like "About" and then open a specific record when meta is selected? I know this is a simple issue, but I cannot seem to find the answer. Using a Mac/SnowLepard, FilemakerPro Advanced.

Hello Friends!! The title is clear. How can i alter a list value dynamically?? Thank you very much!!

Hi, I'm working on a project where you need to select a few things and then press the ADD button (which has a commit trigger) to commit the record, however I noticed that users have a tendency to click somewhere in the layout , and then it will throw errors because you forgot to select something. Is there a way to turn off the "auto" commit when you just randomly click somewhere? Thanks

Hello all. I work for a company that uses Filemaker on a daily basis. Our previous tech guy built our system from the ground up, and now he's nowhere to be found. Our system needs to be updated. Some of the stuff I know is going to be very basic, like going in and updating a default phone number that has since been changed. Other stuff is going to be much more involved. I have full admin access, but that doesn't help if I don't know where to start. We're sort of screwed here and it's my job to try to see if I can get anywhere with it. Can you recommend a good place for me to start figuring out how FM works? I don't claim to be skilled in this area. To give you a…

Is there a way to 'Get Field By Name'? What I mean is can I retrieve the contents of a field using a calculated field name? Thanks, Fed

Hi all, I decided to try and build a simple calendar using portal filtering. I found a great article on the subject at here, and although it has been a great help, I am having trouble getting the calendar to display the date and events in all of the 42 portals (right now it just shows that information for the current month). Below is the script they used to set the variables and I just can't seem to modify it to show the information I want. Commit Records/Requests Set Variable [ $start; Value:GetAsDate ( Div ( interface::firstOfMonth ; 7 ) * 7 ) ] Set Variable [ $thisMonth; Value:Month ( interface::firstOfMonth ) ] Set Variable [ $n; Value:0 ] Loop…

Okay, I'm trying to make my software more user friendly. I have a report I want the user to be able to print or export. I present a dialog, they choose, all is good. Once I go to export, I want to export to a path stored in another table. So, I create a variable called $EXPORTNAME, then insert the path and a filename into the variable. Here's what I would like to see happen: User clicks export from the dialog. Software attempts to save to $EXPORTNAME (which contains the full path and filename) using the specify output file option in the export script step. If software gets an error, like if the path is bad or the destination is read only for the user, then it t…

Hi All, I am really new to FMP development and have run into a problem with one of my scripts. I have a script that searches record date ranges in the database and I need to be able to omit records that are within certain parameters. The parameters are taken from a drop down table. I have tried several different approaches and now the script seems to be generating new records?! the script I have is as follows Set Error Capture [ On ] If [ IsEmpty ( Inventory::Start Date ) ] Show Custom Dialog [ Title: Inventory::Start Date; Message: "Start Date must have a value. Please reenter"; Buttons: “OK”, “Cancel” ] Exit Script [ ] End If If [ IsEmpty ( Inven…

I have a field: STATUS. It usually contains: "Current", "NPD", "Late", "Suspended", "Expelled", "Deceased" or "" I want to do a report that includes everyone who is NOT "Deceased" It doesn't seem that FM Perform Find does NOT allow '<>' or 'NOT=' or anything like it so I used: PERFORM FIND ["Current"] Extend Found Set ["NPD"] Extend Found Set ["Late"] etc... down to... Extend Found Set [""] The weird thing is that trying to extend to the found set to include blank or empty records does NOTHING??? If this is so, how do I include empty or blank STATUS values?? Thanks

HI, Ive done a find and got my record set, say 10 records, and then the following line set variable [$Clients; value:list(CLIENTS:ClientID)] but it's only taking the 1st ClientID even though the get(foundset) shows 10. what's going wrong ?

Hello Friends! I would like to create dinamic fields in a table, for example, when a user click a button. How can i do this? and can i create a Table too?

I apologize in advance, but I am a self trained FM developer, and may not be able to accurately describe what I am looking to do, but unable to do. I need to be able to pull images into a FM database, via a script, from a remote location. For example, the image files reside on computer A, but the FM clients need to pull the images from Computer A to the database being used on Computer B. This is not a reference to the file but actually pull the image file into the DB. (Although I am tossing around the idea as we have over 40,000 images to load into the database). Where my script is going wrong is in the file path. I do not know the syntax that is correct. …

Hi there, I have a script that goes to a set of found records. I am trying to concatenate 1 field from each of those records. I need to somehow get my script to create a variable for each found record. Ex. If there are 4 records found I want to set #Variable1--> next record --> $Variable2--> next record --> $Variable3 --> next record -->$Variable4 My problem is I can't figure out how set the variables to accommodate different numbers of records (usually between 1 and no more than 5 records) Any thoughts would be greatly appreciated Chad

I have a backup script that runs when the file is opened which saves a copy of the file. I want to save the name with a timestamp so I'm setting this variable in the script: Set Variable [$filename ; "MyDatabseBU_"&Timestamp(Get(CurrentDate);Get(CurrentTime))&".fp7" Save a Copy as [$filename;copy] This returns the error “MyDatabseBU_03-05-2011 3:10:58 PM.fp7” could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk. If I change Save a Copy as [filename;copy] it saves a file called "filename" so the path seems correct. The full path on my Mac is file:../Documents/FM_Backu…

I have several questions about a script I'm doing and that "is poised to jump out of the map" . It has about 80 lines and it takes about 8 seconds to run now. 1. When it runs, I see displayed in the data viewer more than 35 fields with their data, all mentioned somewhere in the script. I guess this will be indexation, not if I'm wrong. 2. I have many parts of constant/fixed text and I include it directly as part of the variables. Is it better to do this or put it into a field and make the variable to extract it from there? I guess the second option would require more time, doesn't it? 3. Does it have any repercussion, positive or negative, that the name of…

Hello again, I know it is possible (in theory) to pass user entered info into a script, and I have trailed these posts to try to see if I could work it out for myself, but I have hit a snag. I understand the concept, but when it comes to actually writing the script, I fail misserably. The first... I have a main page that has a field "Path For Excel Files" then a text box so the user can enter the path name before he/she performs the Import (see "Excel Path Input Field" attachment). I need this text to be passed to the Import Record Script so the script goes straight to the specific folder so the user can select the appropriate Excel file to Import…

Hi Everyone. I have a layout with a description field and a note field. The user types in a description then clicks a button, which runs the following script. The script inserts the current date, the users name and the description and then a carraige return with the cursor flashing waiting for the user to type into the notes field. All works well, but when I try to attach the same script as a script trigger to the description field so that when the user tabs out of the field the script automatically runs, it insets the date, name and description, but the cursor won't stay in the field. (the field is set to not be editable in browse). I added a pause …

OK. This really isn't a FIND problem. I think FIND is working as designed. It is more of a 'user' problem. But, here goes: I wrote this script: see above The first line sets a variable $LastFirst equal to a concatenation of last and first names. Everything works great until I get to the 2nd from the bottom line. (In Blue) That PERFORM FIND ($LastFirst) locates the record that was showing BEFORE the PERFORM FIND "Members" or PERFORM FIND "Candidate" BUT IT RESETS THE RECORD COUNT TO 1 of 1. (which is should) Question: "Is there some way to do a find on all the "Members", for example, and then locate the record that was showing BEFORE the FIND and the…

Hi Guys.......... i have some problem with FileMaker pro. i want to insert picture in container field which size is more than 3 MB using FM ODBC. i am using insert query like in this way. INSERT INTO Column_name VALUES(PUTAS(?,'JPEG')); but this is not doing right things. plz help me about this for insert more than 4 MB file using parametrized query. Have a nice day.

Hello all: I have a problem that I'm having a hard time getting out of. I have an "OnLayoutEnter" trigger and inside this trigger I have a script that goes to a New Window, does some processing, and returns. The issue I'm having is that when the script hits the New Window command the focus goes back to the "OnLayoutEnter" trigger and starts to run that again. I'm just confused as to why it would jump back to the "OnLayoutEnter" trigger script and is there a way to avoid that from happening. Dom

Working in dBase IV years ago, I was able to put many scripts in one file and then refer to them as needed. A button would perform the script DO GetDate and it would go do that script (that was in a file of many scripts). It seems in FMP that scripts are always imbedded in the active layout. How can I store scripts elsewhere? Thanks

I have a radio button on my layout. It indicates either "Member" or "Candidate". It works. In trying to provide for the eventuality that a user will hold the shift key and click both choices, I tried to trap with this code: But, even though this code worked in a SET FIELD command in other code, when I debug it and step through the code, it is IGNORED with my ELSE IF.... WAZ UP WITH THAT? Thanks

I am working on a personnel database and am trying to create a script that logged any changes to employee information. What I am looking to do is dynamically select a field name. I think I can do this with set field by name, but I just can't figure it out. I have 3 global fields. g_olddata g_newdata g_fieldname 1.) I have a script trigger that when you select a field it displays a dialog box asking if you want to change the information if you enter the new ( let's say phone number ) and copes it into g_newdata 2.) it gets the active field name and copies it into g_fieldname, 3.) gets the active field contents and copies it into g_olddata. 4…

Hi This is probably going to sound stupid but how do I add a Carriage Return in custom dialog message? I have the following:- "You are about to email a report to:-" & Chief Instructor Details::Email & " Are You Sure?" and I want to enter carriage returns so that it will format the message to appear as follows:- "You are about to email a report to:-" & Chief Instructor Details::Email & " Are You Sure?" Regards Dave

Greetings, This is something I've noticed for a long time and wanted to see if anyone had any confirmation on if this is something to worry about or not. I suspect not but wanted to double check as I don't have a second printer lying around and this has to do with creating a script on site X, then deploying to site Y which has a totally different printer setup. The question is that in writing scripts, when you add the "Print [Restore]" command, Filemaker takes the name of the currently selected printer. So when you run your DB on another system, does the script inherently change the printer to that of a currently selected Default printer? ...or better yet, is th…

I am trying to write a script that incorporates a calculated Applescript to allow a user to select or create a folder, and then export the contents of a container field for all records in the selected set. The AppleScript gets the path, and sets a field to its value. Such as: "/Users/username/Desktop/Pictures/" For those who care, the AppleScript looks like this (it is in a calculated field so that I can retrieve the current database name--"MyDatabase" is an example of the calculated name): set selected_path to choose folder with prompt "Please select a destination folder:" set selected_path_posix to POSIX path of selected_path set selected_folder to s…

Hi everybdy......... Actually i m working with FileMaker pro v11.0, and i want to insert Huge binary data (text,picture ) in container type field in FM database using insert query. i m using parametrized query for this but this is not doing right things. i m using FM ODBC driver for this. can anyone help about this for struck at right point. have a nice day to all.

Hi to all, Actually i working with FileMaker pro 11, and i m creating a new FM database using FM ODBC. Now i want to apply Options for fields (Fields Properties) on the databse. i have appllied indexed property only on a new database using query. but i have no idea about the others properties such as: 1) Auto Enter ( Serial, Modification etc. ) 2) Validation properties (Strict data type, Not Empty etc) how could i apply above these properties programmatically on a FM database table. plz help me about these & give right direction. Have a nice day..................................... …

Greetings, This is something I've noticed for a long time and wanted to see if anyone had any confirmation on if this is something to worry about or not. I suspect not but wanted to double check as I don't have a second printer lying around and this has to do with creating a script on site X, then deploying to site Y which has a totally different printer setup. The question is that in writing scripts, when you add the "Print [Restore]" command, Filemaker takes the name of the currently selected printer. So when you run your DB on another system, does the script inherently change the printer to that of a currently selected Default printer?

Hi all! I am trying to find a way to repeat a perform script 800 times and I cannot do that manually; I went up to 60 records, but that was it. The script has to do with the creation of new records. I would be grateful for any advice Many thanks

Hi all, I've already read a topic on this forum on how launch a ping command through FM, since here all works. Now I must control if the ping works or doesn't, if works a square must become green, if doesn't must become red. How I can control if the ping worked?

I just spent a good hour reading past posts, but I have not found a conclusive answer. There MUST be one... I understand why scripts are allowed to run subsequently. It makes a lot of sense. But what if I have a situation where a user should not continue with another script (through clicking a button on the user interface) before the original script has finished? I don't believe this necessarily means bad design. I can think of plenty of situations that necessitate this. I'll repeat the question differently: I'm looking for a way to temporarily prevent users from executing scripts, so that a running one can finish in peace. Has anyone found a way to accomplis…

In the system we are working on there is a jobs table and a phase table, with each job having a series of related phases. In the job table there are key fields to house the phaseId of the current phase (_zkfCurrentPhaseID), and also the PhaseID of the next phase (_zkfNextPhaseID) in the production cycle. I need a way in a script to evaluate the current phase of production and set _zkfNextPhaseID to the recordID of the next related record. Because of how phases are added to the production cycle we can't just take the current ID and add 1 to it. It has to be the next related record ID. Any suggestions would be greatly appreciated. Thanks so much.

I want to create a repot that will only include records in a in field named "Include" that are checked with the check box. And the repot will not include records that are not check in the check box.

FM 11 03, OSX I can 'turn off' check boxes. I can turn on an individual check box. OK. I have a field with 2 check boxes. How do I 'turn on' both of them from a script? Thanks (pounding head on wall) ========== Got it to work: See graphic...

I have 20 fields I need to check and perform a funtion I would like to do it with 1 simple script like this Set Field [ mathsheet::countfield; "1" ] If [ "mathsheet::dn"&mathsheet::countfield="yes" ] If [ "mathsheet::depth"&mathsheet::countfield=26.5 ] Set Field [ mathsheet::dndepth26; mathsheet::dndepth26+"mathsheet::len"&mathsheet::countfield ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If End If then look adding one to the countfield... so if. dn1 = "yes" then do something in a field ending with the "1", then dn2 ="yes" then do something in a field ending with the "2" then dn3="yes" then do something.…

Hi, I am a novice in scriptmaking. I have a DB where I keep records of students for a Karateschool. I have a field named 'contribution' (date field) and a 'payment due' field (calculation field). This calculation shows me the message: 'payment due' when the date in the contribution field is one year old. This allows me to generate a report. But now I want to create a script for a popup reminder for each day a payment is due. Many thanks! Regards.

I am new in data bases so I still know only a few things, hope you can help. I’m trying to make a script to generate records based on related ones but I can’t end it. First related record goes ok, then goes to the next and ok too, but on the third goes back to the first and jumps to next, so I get first and second record ok and a nonstop second record. I’ll appreciate your help. Set Variable [ $P1; Value:Table 1::P1_ID ] Go to Related Record [ From table: “Table A”; Using layout: “Table A” (Table A) ] [ Show only related records ] Go to Record/Request/Page [ First ] Loop Set Variable [ $As1; Value:Table A::A1_ID ] Go to Layout [ “Table B” (T…

Hi to All, i am working with File Maker Pro 11,i m a beginer with this. i have make the connection with FM database using ODBC. and i have created new tables in that database using "create Query" programatically and insert some data in that table using "insert query" now i want to insert object (File, sound,picture) in the container field, and Apply fields properties programmatically on the table which i created. i have no idea about this, if anyone have something for this or, some idea about query for above task which will be execute, then please reply ............. your reply would be appreciated. …

I am running OSX 11 03 ADV The problem is simple. The solution, " maybe not so much." I have 2 tables: Members and Candidates. On the members layout (based on Members of course) I have the usual member information. To the left of the main Member information area I put a tall, thin, portal that is, via a Cartesian join, related to Members. That Members portal has a GTRR function that, when clicked takes me to the clicked detail information on the main Members area of the layout. THIS WORKS GREAT! (SEE BELOW) When a person joins our group, they are a candidate for membership. This is reflected in a field named MEM_CAN as a popup choice of "Member" o…

Hi My issue is this. I have one table, Procedure to audit (id, date, fk_procedure (the procedure/area to be audited). Then I have another table, Questions to answer in the audit (id, question, id_procedure)Then I have another related table, which we can call Items checkced during internal audit. (id, fk_Question_id, answer, non-conformance, actions, corrective actions etc.) Then I have a table, Procedures (id_procedure, procedure name, etc.). What I am trying to do is: When I conduct internal audits I want to create one or more records in the procedure to audit table. Then when I have selected what procedure is audited I want to click a button and create …

Hi, I have an add new record button on my database which 'forces' users to select a 'Client' and 'Client Contact' before creating a new record to ensure . The problem is that I have several scripts for this process and am convinced this cannot be the most efficient method. Script 1 opens the client window Script 2 is triggered when the user selects the client. It stores the pk_ClientID as a $$variable and then closes the 'Select Client' window and opens the 'Select Contact' window which is filtered based upon the pk_clientID which was selected in the previous step. Script 3 is triggered when the user selects the contact. It stores the pk_ContactID as $…

Running FM Pro 11 03 Here is the narrative: I have a simple database consisting of MEMBERS and CANDIDATES. There is the MEMBERS table and it's TO: MEMBERS_TO_CANDIDATES (See diagram below) People who want to be MEMBERS must first be CANDIDATES. Upon meeting the criteria to be MEMBERS, I want to copy "most" of the CANDIDATE information over to a new MEMBERS record. I have a button that drives a script that uses 'copy' and 'paste'. This works but I have read, on this forum, that a better method is to use SET FIELD. The way I have it setup doesn't work. Go to Layout "MEMBERS (Members) New Record/Request Set Field [Members_TO_Candidates::Name_…

I would like to create a script to trigger a few e-mails based on the relation between "priority", "pickup date" and "delivered date fields". --2 HRS PRIORITY SCENARIO-- If priority field = 2 HRS., and delivered date field is not fill in within 2 Hours or less, the script should automatically trigger an e-mail notice to: contact e-mail and copy escalation_1 e-mail. Then, if delivered date field is not populated within the next 10 minutes after the initial e-mail notice was triggered, script should trigger a second e-mail notice addressed this time not only to the same initial set of recipients but also add escalation_2 e-mail recipient. Finally, if delivered d…

Hi, I get orders from a well known online retailer by email notification. I can cut and paste the full details into a text field in FMP 11, but how do I search this field to extract and order number or a Stock Keeping Unit (SKU) number? I want a script to read the field, find the text "Ord No.xxxxx" and then place it into my dedicated order number field in the table. So searching the field would find: Ord no.123456 Then place 123456 into an order number field. Thanks in advance Chinablue

Hello everybody, i am working with filemaker pro 11 and wanted to ask your opinion to how to resolve a problem i'm stuck with. "sorry for the bad english but it isn'tmy native language" So, i have a first table A It contains 7 fields: Field 1: Productnr Field 2: Productfamily Field 3: Quantity Field 4: Price/unit Field 5: deleverynote nr Field 6: Total Price = calc of field 3 x 4 Field 7: Invoicenr and a second table B with two fields Field 1: Productfamily Field 2: Extra cost Relation between two tables is field 2 (table A ) & field 1 (table B ) productfamily What i want t…

Hello, I am new to this forum but it looks really great. We have an existing records system and we would like to allow all users to create new records while preventing them from editing existing records. I can figure out the script for new records, but I can't get the privileges set to accommodate this. Is such a thing possible? Thanks!

I have a portal within a layout and want to be able to execute a script when any value within that portal is change and committed. For Layouts, I see there is an onCommit script trigger -- but I want the equivalent but only within the portal. So if anything within the portal is changed and saved (committed) it executes a script. I was trying onObjectSave, but that doesn't seem to execute the script at all.

I have a found set of records and I would like to run a script on each record in turn. The problem is that when the script runs a different set of records is found, I can then return to the original found set but I need to find a way of returning to the record that I was in previously prior to running the script so I can go to the next record and run the script again and so on and so forth. I only want to run the script once for each record in the original found set. Thanks in advance.

What is the best way to copy calculation result to pasteboard? I have a report script that generates a quote. I want to copy a string info together from fields content, for example... "1457_ACME_ClientQuote" to the pasteboard. So when User Saves as PDF, all they have to do is paste "1457_ACME_ClientQuote" when naming the file. I don't like the idea of controlling the User into having to choose before report script starts to email, print, or export. I just build report and leave user in a new window, in preview mode. I allow User to close window, or leave it in background, etc... My Users like this as well. Then User can use status area to flip pages, export, sav…