Script Workspace and Script Triggers

Hi all! I'm developing a solution for a client that will be used by the clients on a Citrix environment. The client has Outlook on his PC but runs FileMaker 10 remotely on Citrix. The problem comes when I want to use the old "SendMail" script step to send the mail using the client's Outlook. For some reason FMP does not active the client's email app (which in on the client'S PC. It all works well when using the solution without the Citrix environment. Any suggestion would be greatly appreciated. I know I could use the new 'SendMail" using an SMPT account but the client would like to keep track of the emails in his outlook. Thanks for your help.

I'm in a bind and can't figure out how to proceed. I need to script the finding of records with both a "find" and "omit" request that are based on variables. As far as I can tell, there's no "toggle omit checkbox" script step. I can't use "constrain found set" due to requirement to use variables. Basically, I have: $thisyear $lastyear and am trying to find where Year=$thisyear AND Year=/=$lastyear (the year field is in a linked table holding dues records, one to many - person to dues keyfield relationship) I am using the -enter find mode -set fields -perform find format. Please help! Thank you all in advance!

Is there a way to control font size in the "SHOW CUSTOM DIALOG" script? Is there a way to add any kind of graphic to this dialog box?

I need to export telephone numbers contained in a portal from a related table, Telephone, along with the rest of the data for each given record in the main table, Raedbase; since the Export function does not provide for this, I have decided to copy data from each portal row into a series of fields, T1, T2, etc. so that these field contents can then be exported to a .csv file. I am building a script to copy the telephone::telephone for each portal row to T1, T2, ..., T8 (since the maximum number of rows holding data in any one record is never higher than 8) -- first portal row, telephone, would be copied to T1, next portal row, telephone, would be copied to T2, and so…

I am trying to create a script that does the following 1) copies a serial number contained in a field in a FMP table 2) opens spotlight, pastes the copied serial number and searches for that serial number (which is the name of a pdf file 3) opens the top hit in spotlight which will be the pdf file I assume I need to use either Applescript or Automator to get this done. I have played around with it with no luck. Any help would be appreciated. Thanks.

I am working on a way to automatically export all records from Filemaker to an SQL server. I've got this working first via ESS (Via a looping script: go to local layout, set variable, go to SQL layout, make new record, set field, ...). This takes about a second per record. Then I've tried it via the 'execute SQL' script step ("INSERT INTO " ...). This takes even longer. I'm wondering if I can use Multirow-Inserts (see http://en.wikipedia.org/wiki/Insert_(SQL)#Multirow_inserts ) to insert all records at once. Maybe not going back and forth between tables and layouts can speed things up? What about getting the entire local FM database into …

I am trying to make a script that will accomplish the following: 1)When I hit a button in one table (Table 1) 2)Switch to another table (Table 3) 3)Enter Find mode 4)Search by using a manually entered number 5) a)If no results create new record If results display record Any help on this would be appreciated. I am new to FileMaker can not quite figure out the If commands on there. Thank you.

Hi ! I just cannot figure out why this doesn't work: I Have 2 PrivilegeSets: User and Admin. The script goes like this: If[Get(PrivilegeSetName)="User"] Go to Layout["FrontPage_User"] Else Go to Layout["FrontPage_Admin"] End If In DataViewer Get(PrivilegeSetName) returns "User" and also in a control field "User" is shown. But still this directs User to the "FrontPage_Admin" -layout. With ScriptDebugger it just jumps over the first choice. I just cannot understand...

I need to make a script that would loop through a field which contains text, each sentence separated by carriage return or a value list... The script should go to the first value, add it into a variable then continue onto the next value, add it to a new variable and finally exit after last. I do not know how long the list will be or how many values will be inside, it will wary. If the script cannot create dynamic variables (IE. Var1, Var2 Var3 based on how many values there is)the script could set Var1 with the first value from the list, then preform what is has to do, then go to second value in the list and repeat. I got as far as making a script that will…

I hope this question is in the correct section, please move if not. Is there a way to have a script to Open a file and then using the 'When opening this file perform script' so i can do some stuff, by use of a PC Clock/Date? Say the file will open at 12:00am on the 1st day of each new month. Can this be done, or do i need to use windows Scheduled tasks etc Corey....

How would I go about setting up a script to auto delete records with a a blank value?

In my script I have a particular layout come up, I prefill three fields with default choices, then I want the user to either leave the choices or change them and then hit a button that will continue the script. The problem I have is that after the script puts in the values the message box pops up and doesn't let the user change anything until he pushes one of the buttons. I want the user to have access to the layout to set the fields up as he wants and then hit the button to continue. Ideas? Mike

Hello, I need to make a script to omit a cancellation of the previously paid items from invoice line database. How can I make sure that what cancellation pair to omit? Here's an example of the data: Date Sess Desc. Charge Credit 2/2/09 Feb09 Item A $135 2/2/09 Feb09 Item B $1040 2/2/09 Feb09 Payment - Thank You $285 2/23/09 Feb09 Payment - Thank You $1175 2/24/09 Feb09 Refund $285 2/11/09 Mar09 Item B …

I'm wondering if there is a simple way to do that, rather than getting into some complicated text functions. Thanks, Michael

I have a section in my database where i input a purchase price of a product then how much i want to mark it up, and then another field to show the total price. I have another feild where if you dont put the markup price it it says "no markup inputted" but if there is a markup price in there it remains blank so basicly i want a field that tells me i left a field blank, how do i do that?

I'm wondering if anyone has done much in v10 with automatically generating PDF's from Filemaker and automatically emailing them without any operator involvement at all. I'm sure that this is very doable in 10, but if anyone has some head start tips I'd be excited.

I want to merge these two scripts. The majority of the commands in both of them are the same. There are just a few that are different. How do I go about merging them? Does it matter in what order the commands go? Script 1: Go to Layout ["data entry"] Enter Find Mode [Pause] Perform Find [] Go to Layout ["employee job hour for week ending"] Enter Browse Mode [] Print Setup [Restore; No dialog] Sort Records [Restore; No dialog] Go to Record/Request/Page [First] Enter Preview Mode [Pause] Go to Layout ["data entry"] Enter Browse Mode [] Script 2: Go to Layout ["data entry"] Enter Find Mode [Pause] Perform Find [] Enter Browse Mode …

I have the following problem. I use xml to get data from a ISP with TroiURL. Everything works fine, but I try to replace the tags to more simple tags. Like this one: 5 to 5 I have got this working with the calculation (see end) However, it takes only the first available line and not the whole text or other lines. <?xml version=1.0?> 5 OH3 9YH Z G 2097152 G HSHSH City E Y G 4096000 1235 Home 512k Classic adsl …

WinXP FMAdv9 One-file solution I want to import all records with “2008-2009” in the Year Field from Table A to Table B, but I want to check first to see if any records already exist in Table B with “2008-2009” in the Year Field. What is the best way to script this and are relationships needed? I’ve tried the script below but I get a dialog that says “This operation could not be completed because the target is not part of a related table”. I’m confused because Tables A and B are related (by PersonID). ---- Go to Layout [“Table B Layout” (TABLE ] Enter Find Mode [] Set Variable [$Year; Value: Table A::globalYearField] Set Field [Table B::Year Fie…

In FMP6 we could make a list of record IDs and then have FMP go to that particular set of records. How is this done in FMP10? Ideally I'd like to run a loop that conditionally gathers up these IDs into a variable, set a global field with the contents of the variable, then do a GTRR to that set. Is this the way, or is there something better?

I am trying to set up a script to send an email to a field specified recipient[Email Address]. I have done this thus far, however there is ONLY an option to either send: One email using data from the current record Multiple emails (one for each record in found set) I want to (if able) send One email, with a list of field values in the body of the email, possibly 2 field values [item Description] and [item ID]. eg. Say i do a Find for all records with a Due Date < Today, and there are 3 records found. I want the Field Values [item Description] and [item ID] listed in the body of the email. There would be 2 Field Values(Description & ID) for each rec…

I want a script that will allow a parameter to be passed to it. Suppose the parameter passed will determine the heading on the reoport (as well as other things, like perhaps the sort). In the script I can do a getparameter and then put "heading name 1" into a heading field to be printed out on the report. The question I have is, what if two or three users are at one time creating the same report, each with a different heading. How will we get three different headings if the heading name goes into a the same field?

Hello, I'm new here, let me know if this question is out of place. My company has an order tracking database. I don't use much of it, except its 'Time Tracking' table, which has an interface poorly suited to my needs. I've been given permission to create a separate database to design my own interface as long as it adds little to no extra work for the DB admin. My DB will have no real data, it's just an external window to 'Time Tracking'. 'ORDERS' has a script, 'Submit Time', that adds billing codes and costs which are updated occasionally by the admin. I would like to execute that script from a portal in my database. I have gotten half way there with a script…

Hello all, I am making a contacts database that is used by several different departments in my company, Here is that I'm trying to do: The database has categories for contacts. Come categories need addition contact information entered; for example 'Donors' When the checkbox for 'Donors' is clicked, a script trigger navigates to a layout that includes a tab 'More Donor Information' highlighted in yellow. When the checkbox is modified (turned off) the navigation returns to the record detail without the 'more donor information' tab. This works fine. However, if the user checks the 'donor' box and moves onto the next record, it stays on the 'more donor in…

Since a client can't update a global field, is there any way to get around that so a client can update a host's global field with a script?

Can you have an image change based on selection from a drop down box. So say i have a picture of an apple for Item 1 and an Orange for item 2. In a drop down in another layout i can select an item. Is it possible to have an image of that item show in a field or box of some sort based on my selection? Does it have something to do with web item and specifying the address of where the image is located?

How would I tell the script to auto enter Get(CurrentDate) in the Date field as it gets the info from an .xls file?

Is it possible to create a new script by finding and replacing fields in a current script?

How can I replace "_" with "/" in a calculation? Example script: --------------- (Field Value: Document Library::sceneshot = 170_25) (Field Value: Document Library::version = 001) Set Variable [$$sceneshot; Value: Document Library::sceneshot] Set Variable [$$version; Value: Document Library::version] Insert Calculated Result: $$sceneshot & "/" & $$version & "/" --- This calculation will now result in: 170_25/001/ I want to it result in: 170/25/001/

New to Filemaker 10, Auto sorting is great but sometimes you want to turn it off. Unfortunately you can't. Here's a work-around that's kinda clunky but it works: Write a script to copy the field you want to sort by to a new field that's hidden, looping through all records. Then sort by this new field. Changes you make to the original field won't cause a re-sort.

I see that you can trigger a script every time a record is loaded (made current). What about when you exit a record? I want to do a validation script every time someone attempts to leave the current record. There's tons of possibilities with this idea. Is it really not implemented or am I missing something?

Has anyone used this script step to set up Activity Reminders. Can you have multiple scripts waiting in the wings? Currently, I use scriptfire for this, but was hoping to find a native way to do it in FM. I look forward to hearing your ideas/suggestions.

Hi, I'm having a problem here trying to get the values from the custom dialog. I created a table in which there is two global fields. The problem is I'm unable to set the value to those field via the custom dialog. I always get empty values. I event tried with other non global fields. The custom dialog do not want to set the values to the fields. What could be a cause to my problem?

I am still trying to figure out how to stop my records from updating to new inventory level updates that are loaded via auto script from an .xls file. Either close the fields from updating themselves (which i have no clue how to do) or list inventory based on dates of updating and relate those dates to the day it was used against the inventory for that day. Outside of that i cant think of any other way. Any suggestions? I update my inventory to Microsoft Dynamics GP and export out into excel. In the morning the script is run and new inventory list is loaded replacing the old inventory. I was hoping that it would update previous records but obviously it does. Th…

when navgating around my layouts, it would often be nice to be able to return to the previously viewed tab in a tab control set instead of the default tab. i thought i'd store the active tab name in a variable, then use 'Go to object' to return, but i can't find a way to store the active tab name. how come we don't have Get (ActiveTabName) or something like that? is there a trick required?

In one of my scripts i perform i find but i need get the number of records found in that script because i need it for an equation. anybody know how to do this?

I have a script that tells a portal row to set a global field and activate another portal (portal #2). Then proceed to the portal #2 for data entry. If you attach the script to a button on the first portal, works great. I can use a view as form and then a go to field script step to jump the user to the next portal. However, if you attach the script to a trigger on a field in portal #1, it will not jump to the second portal. It always jumps down to the next creation record in the first portal. This is confusing to users because that new row in the first portal sets the global to nothing and then they get an error message in the second portal. Is there…

Hello, I have a Filemaker Pro 6 datbase that the user runs a script to import a table from a sql database located on a different server. We are upgrading that sql database to a new server. I need to change the import command to point to the new sql server. But I have no experience with FMP at all and the peope who build this script are long gone. Can someone tell me how to edit the import command to point to the new server? The command is: Import Records [Restore, No dialog , "DSN:olddatabase", "EXEC storedprocedure"] I want to edit the DSN to the new database and keep everything else intact. But when I click on edit the script the only available option I…

Is there a way to call a script from a field called "LAST SCRIPT"? I have a database that describes different products my cabinet shop makes. A lot of the initial design parameters are called via different scripts. I run a script then typically perform some other maintenance on the file, etc. When I am done with this maintenance I would like to be able to run the script again without having to select it from a drop down list. i.e. I would l like the computer to remember which script was last in play and run it again. I don't want to do this with the "pause" feature within a particular script. Is there a way to script a button to perform [color:red…

I have had ical automate certain scripts that open my filemaker solution and run a script that creates PDF's of daily work lists and emails them to my customers. This has been running fine until I have had to change my default mail program to Entourage from Mail. What happens now is if the script requires me to cc more than one address it puts a < > symbol at the beginning and end and entourage does not understand and sits in the outbox. example: This never happened in Mail before and only in Entourage. Any ideas

I'm not sure where to post this question. It might not have an answer. Is there a plug in somewhere or other way to enlarge the font size of the dialog boxes when managing scripts. Sometimes I have to audit a lot of lines of small text and I would like to make this easier to read. Also: In writing scripts for VBA there used to be a way to control colors of text. Can this be done with filemaker scripts? Any ideas how to do this?

I need help on this script. I have a layout with 3 different portal tables and the script should make a duplicate record and also duplicate the 3 portal tables. The script works fine with one table but it wont Loop/repeat the other 2, whats wrong with the script? Thanks # # # Set Variable [ $OrigWindowName; Value:Get ( WindowName ) ] Go to Related Record [ From table: “oil_quantities”; Using layout: “oil_quantities” (oil_quantities) ] [ Show only related records; New window ] Select Window [ Name: $OrigWindowName ] Duplicate Record/Request Set Variable [ $NewRecipeID; Value:recipes::recipe_id ] Select Window [ Name: "OilDupes" ] …

Hello A New User question here so sorry if the answer is painfully obvious... I imported an Excel spread sheet into File Maker and everything worked fine apart from each entries e=mail address appeared in the 'Street' field of the 'Main address' section. I didn't think anything of this and went about annotating and adding more information to each record. I then wanted to do a mail out via e-mail to all individuals on my database, but of course the e-mail address was in the wrong field. I started copying and pasting each entry individually because I could find no way of doing this simple task in bulk. I've also tried scripting but this only works for o…

Hi - I have a communication log with that allows a user to keep a separate log every time they have contact with a youth. It tracks the time and date and a topic and particular staff person. This works by Committing the Record to the "communication" table from the "youth" table. It works perfectly locally, however, when done with IWP - the log is somehow duplicated. It will give the correct ID for both logs. But in one log, will be the date and time (which are automated on creation) and in the next log - it will have the correct ID -but only have the staff, topic and note. How can this be fixed? Also - Can someone help me with a solution to combi…

I'm a newbie when it comes to scripting and I'm hoping someone can help me out. I have the following records in a table Product - Count Rock1 - 1 Rock1 - 1 Rock1 - 1 Rock2 - 1 Rock2 - 1 Rock3 - 1 Id like to build a script that takes this information and moves it to a new table and summarizes by the product. Product - Count Rock1 - 3 Rock2 - 2 Rock3 - 1 I am aware that you can get this result by using calculations or self-join tables but am interested in learning more about scripts and doing this with a script. I'm attaching a file with the tables and includes my attempt at the …

I have written a script to perform find of records within a date range. I want to add to that: find and omit records (of found date range set) by status (another field). Any help for a rookie woudl be appreciated...

Hi all, I am doing some layout work that requires me to accurately line up some lines with rows in a text box. I used custom line spacing to get it to look exactly right on screen. When I printed it - it was out of line (sigh). Saving to pdf gives me what I'm seeing on the screen, and prints correctly, but I don't want to have to go through this process. Any suggestions? PS Also, whatever I do in Mac & Windows is always slightly different and therefore out of line on one or the other.

I am trying to figure out how to develop a script that will do the following: Duplicate a Record, advance the date in a timestamp by one day, keeping the time the same, times number of consecutive days. How would I do that?

I am using Filmaker Pro 7.0V3 I am having problems with using the find script step. I have a database that is indexed by date and record number and sorted by date. The dates are in calendar sequence, but not all calendar days are in the database, as not all dates are “business days”, so using date functions is out. I wish to enter a date and find the records of that date and the previous 19 days to perform financial calculations on them. As the current date is entered I wish to have the “window” represented by the found set contain only the current day and the previous 19 days. I thought of using the (Record Number) of the current day for finding the records that = R…

Is there a function that lets me check for the existence of a window? I have a pretty complicated script that is called multiple times; I'd like it to create a window the first time it is called and then just select that window each subsequent time it is called. If (Window Doesn't Exist(WindowName)) Create Window(WindowName) EndIf Select Window(WindowName)

Is there a way to activate the script step: "Refresh Window" upon entering a record? I would like to make this happen without having to actually select a button or field or anything else? I would like the script to run just because I made the window active. Any ideas?

I have a 2 digit limitation, but more than 100 items. Our answer was to count 00 to 99, and then use a number/alpha combination. (ie. 99, 1A, 1B, 1C ... 2A, 2B, etc.) I have modified the last couple of records to 1A, 1B. How do I script that? This is wrong, but a start: Show All Records Go to Record/Request/Page [Last] Set field [ COLORS_Fixtures_color_status::color_step_g; Left ( COLORS_Fixtures_color_status::color_00_c ; 1) & Right ( Filter ( "ABCDEFGHJKLMNPQRSTUVWXYZ" , COLORS_Fixtures_color_status::color_00_c +1 ; 1 ))]

Hi all, I have a really annoying problem - I have a database, where i created simple logging system - every logged field runs an eventscript (by validation - Let ($x = S4HU_EventScript( "Incidents" ; "Log Field(ID, fName, fValue)";ID & ¶ & "Type" & ¶ & Self); 1) Then, I have a second database, where i have that Incidents database listed trhough portal. And when i change any logged field in that portal and without commit run another script/jump to another database or anything else, the whole filemaker crashes. It happens just sometimes and it never happens when debugging. Through Custom messages i found out that it crashes on first script s…

To provide a non-confusing Search routine I'm opening a new window which floats above the current layout the user is using. This floating window is blocked from closing until the user clicks either of its Cancel or Done buttons. The user sees the context, sets their criteria, executes the search within the floating window and if they click the Done button the current set of records should be transferred to the window below, and then the floating window closes. (A click on Cancel simply closes the floating window.) Here's the problem — transferring the found set in the floating window over to the window below. Elsewhere in this solution I've been using a layout …

Is there a way to script names for Saved Copies of an FM database? Specifically, Is there a way to timestamp the name for a file. What I would like to be able to do is: Create: [color:red]"File X" Save as: [color:red]"File X March 19, 2009" Any way to automate names of saved files?

I would like to be able to: Create a FOUND set Navigate to any particular record within FOUND set Select any particular field Copy the contents of that field Replace the values for that particular field in all other records using the value of initially selected field. (I hope I explained that right) Any ideas how to make this happen? Could I launch this replace function or would I need to start at the top record and work down? Thanks Jarvis PS: Can anybody tell me how to change my operating system & FM level? I selected FM 10 Advanced on Tiger but the profile indicates FM9 Panther.

I need to print a report that shows all the records for a specific term. My challenge is that certain records (based on a check box field) need to display/print with a line or strikethrough in all fields. Any ideas?

I need to validate there is data in all the fields of a portal row when the row itself is exited. I don't want to bother the user while they are in the process of entering data in the fields, only when they click to exit the active row. I can't seem to come up with a strategy. Field validation won't cut it and I've not identified a way with Script Triggers either. Assistance appreciated.

I have exported the html contents of a webviewer as text to a text field in another layout. I am trying to write a script to go through the text and extract urls from within it. All urls in the text begin http and the string is contained within " " I am running a looping script that goes to the first word, if its first 4 characters are http (Left ( $thisword ; 4 ) = "http") then i set the current word plus the next 20 to another variable which is exported to another field. The current word then increments by +1 and stops when current word = last word. This is ugly! I wonder if anyone can help me get the exact text of the url contained in the " "…

I have a global field called gCurrentClient. And after it is used in a script i want to unset/nullify the field. Does anyone know how to do this?

I am setting up a database for a small doctors office. Right now i am working on the client management table and layout. I would like to create a dropdown menu that has all the last names of the patients ans when you select a patient it switches the current record to that patients record. Does anyone know how to accomplish this?

Is there a way to toggle the script debugger on or off from the keyboard?

Might be a stupid question but how can I execute a script from a calculation function? Thomas

I'm baffled by a simple (I thought) script I've set up to create new 'Keywords' in a Lexicon Table that holds a record for each Keyword that the user can use to 'tag' various media items via a join field. Each Keyword involves 3 fields (Word/Category/Authority) and I've set up global fields for their entry and a script that takes these values and creates a new Keyword record based upon them. This has been working fine. But I want to make sure the user can't create a new Keyword with any of the three fields empty. So at the beginning of the script I did a triple "IF" condition: IsEmpty ( CFA_Lexicon::NewKeyword_g ) or IsEmpty ( CFA_Lexicon::Lexicon_Authori…

I set out to write a script (to run when exiting a text field) to locate and highlight any URLs in the text. Ideally, it would highlight the entire URL -- but I resolved to simply locate and colorize the “http:/” portion as a first step. What I’ve encountered are two data cases that I don’t understand. On the highlighting, the first “run” of the script works as expected. But selecting the same field contents a second time -- or selecting different contents -- results in what I will call color overrun. The entire field gets colorized by some mechanism. In my testing, I noticed another odd occurrence in that a popup selection duplicates any second occurrence o…

Is it possible to append data to a variable in a script? e.g., $variable = "abcdefg" {Run script appending "hijklmnop" to $variable} $variable = "abcdefghijklmnop" Also, is it possible to insert a line break character in this way?

hi if i have a layout and i what only when it run a script to enter a serial number how do i do it? dani

Before upgrading to Filemaker 10, whenever I ran a script to open the default email client, Outlook would open a new window and would be ready to complete the email. Now, after the upgrade, a window appears that says another application is trying to use outlook, is this ok? Then you hit "ok" and the new email message just sits in the outbox waiting to be sent. Is there a security setting to change it get it back to opening a new "compose message" window?

Hi, I have a script with a custom dialog where a user can enter a date. The field used for this is a global date field gdate. I have a loop in the script to validate the date entered into the custom dialog box but cannot get it to validate properly. Basically I want to stop people entering incorrectly formatted dates and/or typos i.e 1/1/117 or 1 July 2001 I have tried to get the date to be between a range (both using the getasdate and without): Exit Loop If[gDate > GetAsDate(01/01/2006) and gDate < GetAsDate(01/01/2020)] I have also added: IsValid(gDate) = 1 To no avail : NOTE: There is a lot more to this script (i.e th…

I am new to filemaker. I want to run a script after I select a date from a drop down calendar. I am sure there must be an easy way to do this but I can't find it.

Hi, I have a script that is acting erratically - usually it works as designed but randomly and infrequently it will fail to execute a Duplicate Record script step. I have read all prior posts on this issue but am still confused as to what is going wrong. Here is the start of the script. Enter Browse Mode [] Beep Show Custom Dialog ["Create a duplicate?"] If [get(lastMessageChoice)=2] Exit Script [] End If Set Variable [$$BidID; Value:BIDS::Bid_ID] Set Variable [$LaborRate;Value:BIDS::Labor_Rate] Set Variable [$Percent; Value:BIDS::PercentToInvest_Default Duplicate Record/Request Set Variable [$$BidIDNew; Value:BIDS::Bid_ID] …

Hi, I've written a simple script to copy any active selection to a field, using the following functions: Middle ( Get (ActiveFieldContents); Get (ActiveSelectionStart); Get (ActiveSelectionSize) ) The problem is that for some types of content the script copies only a portion of the selection (whether the field be a text or calculation field). When I try to evaluate the first expression -- Get (ActiveFieldContents) -- in the DataViewer, I get the following message: invalid argument was encountered and then the DataViewer goes blank. In particular, this bug occurs when the source field in question contains…

I've written a set of scripts and layouts which together produce a "found set" of records. How do I write a script which goes through each of these records and changes a field in each? Just in case it complicates things, the records in the found set are of two different types. Depending on the type, the field that I want to edit will change.

I'm trying to design a script trigger that would whenever the date in field "date1" is a Sunday would allow returning the cursor to the field "date1" clearing the field content and displaying a message stating a Sunday date was just entered please correct. The only lines of code I believe I have completed is: DayName(Get ( ActiveFieldContents ))="Sunday" as well as the message. This script being the basis I would then like to repurpose it in "date2" without hard coding the field the field name. I would greatly appreciate any assistance I can receive with this procedure.

Hi. I am looking for some suggestions on how to set up a system to alert me of a failure in my script. I have a few ideas, but I'd like to hear what others might think. I am running OS X 10.5.6 with FM 10 Adv on a dedicated computer. I have a second computer available to me with the same setup which is not dedicated to the database. My script runs nightly between midnight and about 5am and is quite complex. Failures are infrequent, but if they occur they may be due to operator error (I forget to reset everything after I access the database during the day), a network problem, as the script needs to access a networked data source, or FM/the computer crashes. I…

Okay so I'm pretty new to all of this. So any help or advice you can give me would be much appreciated. Basically I'm working on a medical database. I have multiple tables for various things: - patient list - ur numbers - med records - imaging records A patient can have any number of UR numbers, depending on how many hospitals they attend. Generally speaking, there is only ever 1 UR number per patient per hospital. So UR numbers table has ur_id which is related to id in patient records (which is related to records_id and imaging_id), ur_hospital and ur_number. I've set up med records and imaging records tables as task flow sheets, with v…

Wanted to set a script to export current record to .xls and save it based on customer and date combined so I can later decipher what file is what without having to open each one. I would literally have 20+ a day so trying to come up with an auto export command and naming convention. Thanks

I have two tables - Charges and Order Charges. I do a find for all Charges matching the specified Industry and Product. This part is working perfectly, returning 3 records in the Charges found set for the data I'm testing with. What I can't figure out is how to add a new Order Charges record for each record in the Charges found set. Please see my script below. Thanks in advance for any suggestions on how I can add the new Order Charges records from the Charges found set. Commit Records/Requests [ No dialog ] Set Variable [ $OrderID; Value:"gOrderID" ] New Window [ ] Go to Layout [ “Masterfile - Charges” (Charge) ] Enter Find Mode [ ] …

Is it possible to run a script on start-up of FM? I am not able to find a script helper.

As a relative newcomer to FileMaker, I'm having problems with the Perform Find command. Having read a number of posts on this topic, my understanding is that you effectively have to use the Set Field command to store the variable, because FM can’t deal with $vars in the Perform Find command. However, I’m obviously missing something very basic (or I'm merely being very stupid) as I don’t understand what, if any, parameters you should then use in the Perform Find command. I’m trying to write a script that will create an attendance record from two other tables Courses and Course_Lessons. The new record would be stored in a table called Attendance. Courses has d…

Hello, I just signed in to FM Forums, congratulations in advanced for this excelent research tool for fm developers, designers and users. In FM 9 Advanced, when I try to open a container field using a script (Go to Field [select/perform;container_field]), it give me memory error, but when i double click the field, it open just fine. The container is repetitive (5 records) so before the Go to Field[] script step, I select the record Go to Record[] script step. Another thing is that when I add the Flush Cashe to Disk script step, after opening the file, it works fine. This is not an option because its very very very slow : ! What I don't understand is w…

i am redeveloping an accounting system from vb6 and sql server in fmp. in vb i create sql server temp tables and work with them ( Insert Into #DocItem( ItemRow ,AsstantCode ,DetailCode, DetailCode2, DetailCode3, [Value], Article , ItemAttachMent , ArzCode , Amount , ArzValue ) Values ...) now in fmp when execute such sql in my scripts, an error dialog arised :"Invalid Object Name '#DocItems'".

I have done many scripts with loops but today I am having a brain freeze I believe. I am working on a payment screen for our database. There is a field for check amount and amount remaining. Then a portal which lists outstanding invoices for a specific customer. I want to click an 'Auto Apply" button that loops through the portal rows and applies the payments, Apply the full amount of the balance if the amount remaining is > or = the balance or apply the amount remaining if the balance is > than the amount remaining. For some reason it's not working correctly. The last portal row does not apply correctly. Here's the script, I'm sure it's something stupid that I'm…

Howdy. Is it possible to programmically scrape (or extract) road directions from the web viewer into a usable text format? A scenario: Work Order is generated with customers name & address, work order #, job instructions, etc... and somewhere on the page it has directions to the job in a format like: [Directions: From HQ, Drive South 2.5 Miles on First Avenue, Turn Left at First Signal, Proceed .5 Miles to Job at 2345 West Main Street] Something like that. I figure if the web viewer can display a visual map on the screen, maybe there is a way to tap into the code that produces the road map, yeah? Thanks in advance.

I have a db with two tables. I import into one table from an excel spreadsheet, with multiple rows of data. That works just fine, but want to create a new record in the second table and copy specific fields to it. The 2nd table also has portal for the records in table 1. I can get the first record created in table 2 but does not create the remaining rows/records from table 1. Help please!

Good morning I am currently stucked with a tricky problem. I want to create a script which does following (once for every table) -get the current serial number (which is also the key) in the database to be updated (old) -call up all records (old) -import all records (new) -set the current serial number in the new version I have no chance to get that to work. Any hint?

There's probably some rookie mistake that I'm missing here... My invoice layout contains a couple fields for entering discounts. The DiscountPercent Field is just a plain number field, while DiscountValue is a number field with a calculation (Auto-enter Calculation replaces existing value). The calculation is: If( IsEmpty( DiscountPercent ) ; DiscountValue ; SubTotal * (DiscountPercent / 100 ) ) This basically says that if there in a number in the DiscountPercent field, fill DiscountValue with that percentage of the SubTotal. If there's no number in the percent field, use whatever number is sitting in the value field. The grand total then subtrac…

Over the years I have found it very difficult to maintain consistent data entry from importing contact lists into our CRM (customer relationship management system). Trying to keep consistency on company spelling, city spelling and the best way to determine duplicate records before import. I am curious to know if anyone has come up with a good model to perform field comparisons that can account for spelling variations and naming inconsistencies to help identify a duplicate contact before transferring those contacts into their main customer list. I think it would be a quite complex script, however if anyone knows of a good place to start, I would find that most he…

Setup: FMP (v9) server & 5 clients Objective: To send a Customer an email with an Invoice as a ".pdf" attachment. Problem: When the script is performed locally on my machine it works great, however, when executed on the remote client machine it will not work. It must be a "get" filepath" issue ? The "Get (File Path)" script step is supposed to function the same on the server & client... but does not work or I am doing something wrong. It apparently is trying to place the ".pdf" file via the chosen path and can't... Script Steps: Set Variable [$einvoice.pdf; Value:Get (File Path) & "einvoice.pdf"] Save Records as PDF [Restore; No dialog; "…

I have a database that contains a table called "Emails" with a field called "message". Each record has a serial number. I have another table called "keywords" with the field "keyword". I have another table called "stats" which has fields "keyword" and also "serial number" There is a relationship between "Emails" and "stats" via the serial number field. I have written a script that takes the first "keyword" from "keywords" goes to the first record in "Emails" and searches content for a patternCount. If Patterncount >=1, a new record is created in "Stats" that copies the serial number from "Emails" and inserts the "Keyword" into "keyword". It …

I'm writing a script which performs a find which will always have as a result a single record. I now want to add a timestamp to that record, but can't work out how to do this in ScriptMaker: I know how to add data to a field, just not how to specify that I want to add the current date and time.

I am looking for a script to create a new layout so that the user can customize thier own one time reports. If this has been addressed already, I am sorry for the repost, but I could not find anything. Also thanks in advance for all/any help. Dan

Hello, I have a field called "Final OK". It is just a checkbox with one option: Yes I would like when that check box is selected that the record omits from the found total set, so it doesn't show up in my live jobs print summary. I assume it is an IF command with the omit record step, but I am having trouble figuring it out...any help is great;y appreciated. thanks barbara

I am trying to set up a simple data base, which after a set time (30sec) the page changes to the next layout without the need for the user to do anything (sort of like a timed powerpoint show), but still allow the user to enter data into fields as they appear (I am measuring user reaction speed and concentration)

I'm struggling with a Join structure which depends on an unstored calc. It may be that all I need is a script step to force the recalculation of the unstored calc. Here's the current structure for the Portal: Companies table|Contacts table Company ID = CompanyListAll_calc The unstored calc field has this formula: "¶" & List ( Contacts~JOIN::_CompanyID ) & "¶". The Contacts~JOIN TO has this structure: Join table|Companies table Company ID = Company ID When I open the CompanyListAll_calc field to examine its current storage settings the field recalculates and the missing record suddenly turns up in th…

I have two fields, A & B. When a user changes the value of A (not just enters, and then leaves the value the same, and saves), I want B to have a value set. I've been able to do this as follows. I wanted to check if this is a reasonable approach (given the use of a global variable; I've heard that using local variables is preferable at times, but I have two separate scripts currently), or if there is a better way. fieldA script trigger "OnObjectEnter" triggers: Set Variable [$$previousValue; Value:myTable::${fieldA}] -- fieldA script trigger "OnObjectSave" triggers: If [$$previousValue ≠ myTable:${fieldA}] Set Field [myTable::fieldB; "x…

Filemaker 10 seems to be fixing a lot of my pet peeves. One of my other problems is when a user selects a field to enter data but never commits the records. Using script triggers I can finally solve that problem. Jeff TimerCommit.fp7.zip

Hi there, I'm quite new to fm so this might be a noob question. I think I need to do some scripting but I'm a little stuck... I have a table (companies) with an unique id. Then i have a sub-table (departments) that is related to the first table and displays various departments per company. Now I want to make a button that can duplicate a company (duplicating all data except for the unique id), but along with this I want to copy all the departments. So I need to copy all rows from the depparments that belong to this company too. Any tips?? Thanx!!! Wouter

I have a script and some lines are preceeded by // - and I cannot select these lines to see what they mean. Can someone clear up what the // means. Thanks,

Help please!? I have 2 fields that I want to relate through a script. One is a radio button set for a field called "recoat" that is just yes or no. If the button is selected "yes" I want a different field that is "commission" to be set to zero. Is there any way that someone could help me with a script to set this up? Thanks so much!!!!