Script Workspace and Script Triggers

I would like to know if it's possible for a script to auto populate certain fields with the same data based on matching ID's. I have a "parent" record which has a variable number of "children" records. I would like to be able to enter one address on one of the "child" records and if that address matches the other siblings addresses then a script would auto populate the siblings with the same address. This may be done fairly simply, but I am a bit of a newcomer to developing and just am not sure how this would be done. Thanks

Hi all, A quick one. I am printing the date using Get(CurrentDate) . I would like it to read April 20th 2010 rather than 4/20/2010. How do I do it? Thanks

I came up with a really handy way to document any and all changes that a user makes manually to any field. Basically, any field that I need to be tracked has an [color:gray]OnObjectSave script trigger assigned to it with the script parameter set to [color:gray]Get ( ActiveFieldName ). From here my script simply sets a field named ChangeHistory to: Get ( CurrentTimeStamp ) & " - " & TextStyleAdd ( Get ( ScriptParameter ); Bold ) & " modified to: " & TextStyleAdd ( GetField ( Get ( ScriptParameter ) ); Bold ) & " - " & Get ( AccountName ) & ¶ & TableName::ChangeHistory This results in a neat and tidy documentation of the record c…

I have run into this problem in many different ways, and I wonder if there is a good solution (I haven't seen it). I have a script that loops through a found set, and calls other scripts. If those scripts end up in the same layout as the calling script, then they can change the found set "behind its back", and end up destroying the logic of the script. For example, I find all records in Table A that meet a certain criterion, and I set up a loop to iterate through them. But in the loop I end up calling a script that needs to make a selection in Table A, destroying the loop in the calling script. So, the question is, how can one write scripts that don't need …

I'm importing a lot of data into a database and because of the way the data is formatted I need to write a script which will extract parts of a field and then apply these to other fields. For example, the problem field is made up of various elements, examples: (a) x6 size10 black shoes (: x8 size8 white shoes © x5 size 4 yellow t-shirts etc Prices etc are already in separate fields so for any one record using one example from above I would have the following 4 fields filled from an import: Field 1: Price $10 Field 2 (from a. above): Description e.g. x6 size10 black shoes Field 3: Supplier Field 4: Country of origin. *Field 5: Colour (empty) …

So simple that I can't figure it out. *blush* I have the attached script--and it runs fine for what it needs to do-- except after it's run it leaves the field, rezp__rez_name2, selected. I tried adding steps Commit Record and Go to Field [] to the script but it didn't help. Any suggestions? TIA for your help!

This is a two-parter since it's part of a start-up script, so hopefully both answers will be easy: I want a script step that will set Preferences to Preference > Layout > Web palette (216 colors). As far as I can see, there's the Open Preferences script step but that's it. Is there a way to set it as listed above? I also want the user to be able set (store) a window zoom level. Again, I can get halfway there with Set Zoom Level but I can't see a way of coding a variable to store and recall the level of magnification. TIA for your insight(s) and help!

Would like a scrip that advances the date of certain records in a found set. Simple database 1 table with 2 fields in each record, Date and New Date. The first field, Date, is already populated with dates, Mon and Thu dates. The 2nd field, New Date, is a user input field. The records are created in date order so no sort would be required. I'm trying to get the Date field to advance by the difference between the New Date field and Date field only for the records after and including the record that has an entry in New Date. Example: Record 1 = 04/05/10 Record 2 = 04/08/10 Record 3 = 04/12/10 04/19/10 Record 4 = 04/15/10 Record 5 = 04/19/10 Rec…

Hi all, I have a repeating container field with 24,let call them, icons. I need a script that will put those icons at random in 64 fields, in such a way that, per run of the script, the same icon ends up in the same field. Example: Field 1 to 64, same icon in field 5, 25, 30, 35, 40,etc. Next run of the script: same icon in field 9. 18, 27, 36 etc..., but other icon than in the previous run.... All the other fields can by filled at random. Any hint? TIA

I have a layout that defines a piece of equipment. I locked the fields that contain the S/N, date acquired, size, etc. so that the casual user could not accidentally change them. But now I have to allow for the addition of new equipment. I have created a different layout that only contains those locked out fields. Is there a scripted way to unlock the fields, then lock them again once the new equipment is entered? TIA

I have a GO TO LAYOUT script. When the script is called it goes to the [color:red]first record of the layout but I want it to go to the [color:red]current record. How do I make this happen?

If this is in the wrong forum, please feel free to move it. I came across something odd today in a FileMaker database, and I was able to recreate it in the attached file. I had a button that runs script on a related field on a layout. The script did a few checks, and then if they all passed, it had a Go to Field[Field] script step. This field was layered on top of another field that had conditional formatting applied to it. basically the formatting would color a section behind a few fields if certain criteria were met. The formatting field was a different one than the target of my Go to Fielfd[]. Every time I would run that script, it would go to …

I am coming up against a brick wall. If I add the following as an OnObjectExit trigger, it all works fine, but the moment that I enter an 'If' test before, so that it will only raise the Custom Dialogue Box if a condition is met, then nothing happens. It's driving me mad! Show Custom Dialog [ Title: "Do you mean?"; Message: "Do you mean " & Let ( Cleaned = Substitute ( Proper ( Trim ( Substitute ( Get ( ActiveFieldContents ); ["Mac" ; "Mac " ]; ["mac" ; "Mac "]; ["Mc" ; "Mc "]; ["mc" ; "Mc "] ) …

I have an estimating database with line items. I have created a record which is an estimate template. This template record contains a group of line items i wish to be able to optionally 'import' into any new estimate. I tried to set up an import script then realised i cant import from the same table. So i am trying to duplicate the template records and then copy the new EstimateID into the EstID field to link them to the new record. I have created a script which goes as follows: go to Layout [Estimating] Go to field

Hey guys. I'm hoping this is going to be easy, but I just can't wrap my head around this. I have a database that writes to a field called "log" whenever it runs a script. They just decided that they want to know how long it takes between certain scripts for reporting. I have created script a execute time, script b execute time and time between script executes. This works going forward, but somehow I need to extract the data from the old records. The log looks like this: VP Level Approval Requested. - 1/5/2010 - 3:11:51 PM VP Approved. - 1/5/2010 - 6:23:53 PM I need to somehow put the date on the line with "VP level Approval Requested" into the script a execute…

Hi All, I wanted to know if its possible to script that the FileMaker window should come to the foreground (or become the active window). Any help will be very much appreciated! Amram Chayim Eirinberg

Hi, I know that script debugger is very important, but I want to disable by startup script or any other way. Because I think my client has filemaker advanced and they can break my initial startup script. Thanks in advance for any thoughts. Regards, Tusif

Hi all I have a script that is setting 27 numeric variables. I then need to find the highest value - which I can do with the Max calculation. But I also need get the text name of the variable that contained the highest value. The only way I currently know to do this would be to build a Case statement that has 27 lines with each doing something like this: $V1 > $V2 and $V1 > $V3 and $V1 > $V4 ; "$V1" ; $V2 > $V1 and $V2 > $V3 and $V2 > $V4 ; "$V2" ; $V3 > $V1 and $V3 > $V2 and $V3 > $V4 ; "$V3" ; This would be a massive 27x27 grid. I know there must be an easier function for this (like Max) that would return the field na…

My customer aggregates a lot of text material (news articles) and in massaging all his data goes back and forth between MS Word and Excel with Excel being the last stop before importation into FM. This changes any curly quotes to normal quotes. I need to convert them back to curly quotes AFTER the data has been imported into FM. Does anyone know how to do this? I even tried a script that would copy the field data and then paste it back into the field but that did not work. Thanks

Hi, My first post so please be gentle... I'd like to get a script trigger to fire for records which are updated via a CSV or Excel file import. I've written the script and it works fine when I update a record on a layout for a single update to the record - the record commits as intended when I click away or go to the next record in Form or Table view, but when I perform a mass update of the records via an external file, the script trigger doesn't seem to fire (or at least the operations within the script haven't happened). Am I doing something dumb here, or is this not supported? Thanks Nick

Please Help! I've tried many options and can't find a work around. My desire is to emulate a web site in the need to press a "save" button or "submit" button to commit the record. If the "cancel" button is pressed the record is reverted to when it was opened (or in the case that it was a new record, it is deleted. [color:red]Try #1: I created an alternate table with the same fields and then when the user presses save a script imports the information to the real table. I did this instead of creating duplicate global fields in the same table, because it was confusing to deal with so many tables. In both cases it is cumbersome because if I add or take away a field,…

I've partially created a script which reveals that I am missing something about how FM treats Find/Sort commands. I want to produce a list of the Top 100 from a database. This is what I have so far: Show all records Constrain Found set {items marked with a N} Sort records [Restore] {sorted to produce the most expensive eg descending value} Go to record/request/page [first] Omit multiple records [100] {seems OK to here but then it adds back the constrained set omitted earlier} Show Omitted only What I then want to do is produce a list of the Top 100 (in, say, December 2009) Any help much appreciated...

Hi, Is it possible to insert an image in a container via url natively? I know it wasn't possible in FM 8.0 without a plugin. But how about FM 11?

I know I should know this, but I forget how to open a file without letting the opening script (set in File Options) execute. It's control-something, right? Also, has anybody also come up with a good system to manage opener files?

perhaps someone can help me with the following : I have a global text field - g_Month - which is used in a relationship. It contains a value list of Month names. There is a button on either side of this field on the layout which is supposed to cycle through the month names - How do I obtain the previous / next month's name ? Many thanks in advance, Kindest Regards Glorifindal

Hi All, I have a phone field that contains phone numbers, and a button that executes the 'Dial Phone' script step, I want it do dial the phone number in the field, how do I achieve this? Any help will be very much appreciated!

Hi there, I need a way to generate FDF files; I figure if I can make a text file, I can change the extension from txt to fdf and have it work, however there are a few file markers that need to be in the fdf for it to work which may cause problems in writing them to the text file. Those markers are: %FDF-1.2 %âãÏÓ %%EOF Any assistance would be much appreciated. Cheers! Pedrom Adeli

I am having a problem with the script below. It executes fine when there are no data entry errors. I have set Error Capture Off to allow FileMaker to detect fields that were defined to have a required value. After I enter the data (leaving a field blank) and click "Continue" it presents the standard FileMaker "Revert Record Yes/No" message and pauses. When I select "No" it places the cursor in the empty field. After entering the data and clicking "Continue" it does not return me to the script to enter the department. How can I return to the script to complete it?? Thanks for any assistance. Create New Participant Record #Setting "Allow User Abort" to Off removes…

Hi everyone, new to FM and trying to develop invoicing/project tracking solution. I got stuck at this point now where I could use some hints about how to tackle this problem. Let me explain a simplified version of the system in short: user creates quote for the project and later when the project is finished wants to create invoice from this quote (by reusing all the data from the quote). What I would like to do is to have a button that would bring up all the quotes related to the project and allow them to choose the one he wants to build the invoice from, so basically using it as a template. I was thinking this could be done with a script that performs fi…

I would like to make a script to add a set amount of records specified by a field in the layout. The records would be the same as the ones that i entered on the layout. I am making a database for our plant business. So it would be like this, on the layout, I would enter all of the details of the plant, and in a box (quantity field) on the bottom i would enter the quantity of plants that i planted. So if i entered 72 in the quantity field, it would create 72 records. It would be a lot easier than entering over 1000 records manually! Thank You in advanced.

Hi I am creating a database that will be a stand alone runtime solution. I wish to include a folder in the run times files that will store PDF´s relevant to each record. I have created files and opened files from a filemaker database before and so am happy with this but is it possible to have the file path so it does not matter where the client places the runtime solution files. ie it treats the main run time folder as the root? Many thanks for your help. John

I am logged into a FM 10 Advanced client with admin privileges and click on the Scripts > Manage Scripts menu and my menu set changes to one of the custom menu sets I have created with less than admin privileges and I am unable to copy a set of script steps. What I want to do is copy the set of script steps and paste them into a thread here in order to ask for some help with the script. Any suggestions will be appreciated. :bang:

Hi, I need to create a navigation bar that includes more or less navigation buttons depending on the access privileges. Also, this would be a multi-lingual solution so the label would have to change depending on the language. I'm using Nighwings' multi-lingual solution which is great: http://www.nightwing.com.au/FileMaker/demos9/demo911.html I wonder if anybody has some advise on the best way to do this ... thanks in advance!

Hi There, hoping someone can help me step through a list. I have a calculated field - using List(Adr::AdrID ) - which returns all the addresses that I am allowed to see. I have a "Previous 10" button and a "Next 10" button. I am trying to write a script that sets a global field to the set of 10 AdrID's applicable to the button - in other words - when I arrive at the page - the global field is populated with the first 10 in the list - if I click "Next 10", the global field should be populated with ID's from 11...20, click "Next 10" again, the global field should be populated with ID's from 21...30, etc If I click Previous here, the global field should…

Can anyone help me make a script that will allow me to duplicate the field without duplicating the content? ie: Name: Date of Birth: "Name: Jen Date of Birth: 10/20/80" "Name: Jen Date of Birth: 10/20/80" this is what it does, i want it to: "Name: () Date of Birth: ()" "Name: () Date of Birth: ()" "Name: () Date of Birth: ()" so that I can add new individuals () in each field. Thanks!! I've been trying for weeks.

Hi, I am building a solution in which date field is used in many places. Suppose i want to change the format to dd-mm-yy instead of mm-dd-yy.for this i have to change the format of date field every where in the solution.Is there any technique available to change the format at one place and it would be reflected every where in my Solution.

need script or calc that will take 40 lines of barcodes separated by returns.... 889765641 889765643 889765645 889765642 889765640 etc,etc then locate each barcode in a set of records and perform simple script step (like set a field, checkbox, etc.. Then go to the next barcode in the above example, set the field, etc. Then go the nex t barcode. thanks!

in a exit trigger how can i stop a user from exit a layout ?

Hi I have a looping script which holds a parameter that was passed to it by another script. The loop script is a simple loop with a pause. Loop Pause indefinetly EndLoop I then have a button on my layout that performs another script and the parameter is set ot get ( scriptparameter), the button properties are set to exit current script. In FMP 10 the parameter is passed from the loop script onto the script on the button but with FMP 11 it does not. Is there a reason for this? is this a bug? Can anyone duplicate this? This happens on both my PC Vista and Mac 10.5.8 using FMP 11 adv Regards Kev

Is there any trick to trigger a script when a layout is left - rather than when it is loaded? Apart from assigning the script, on layout load, to every possible layout the user might go to (not a comfortable option).

I have been scripting a few templates recently. All was well, until I was asked to do a different template, using the same scripting. I am tracking certain records with various ethnicity, female, male. When there are no records it gives me the continue button. I have tried to figure out how to enter the IF somewhere in there as a calculation (ie: If [Get (FoundCount) = "0"] "Continue"). I just want it to continue if there are no records and enter the 0. In one instant it came up over 150 times! I knew then I had made a huge mistake. Now I'm afraid I'll have to go back to each related record template and put some kind of code in on each Perform Find section. Is there…

The script in the attached file creates records in a table (table two) populating it with some of the data from table one. How can I create child records of table two, in a third table, populated with data from table One? Any suggestions would be appreciated. test_2.fp7.zip

I would like to create a script that would grab the record ID of all the records that have a checkbox field set put that into a variable and then set the contents of the variable to a field in a new record. There are times when it would be one record but others when it would be two or more. My thought is the end result will be a field with values separated by a return. The checkbox field is either a 1 or blank. Thanks for any assistance. Kevin

i'm trying do to a trigger that that if i have a document is not filed up ant printed i can see is it in layout 1 but if it was printed it will be seeing in lay out 2 .

Hi gang! I need a button that allows me to click the first time, and sort my records based on certain criteria in ascending order. The next time the button is pressed, we need the data sorted in descending order. Then next time, ascending, etc etc. Anyone had any success in creating a script that can do that? We have 10 and 11 in our org. Thank you! Tee

How is it best to move Customer order line item records to Vendor PO line items? A new Vendor PO record needs to be created for each Brand, and the Vendor PO line items table needs to be populated with Style records. Customer Orders and Vendor Orders must remain independent because data in either may change. Any suggestions would be appreciated. Table One: Customer Order Line Items Vendor Style A 1 A 2 A 3 B x B y B z Table Two: Vendor PO New record for A New record for B Table Three: Vendor PO Line Items Related style data (1,2,3) (x,y,z)

Is there a way to "flip" the sort from ascending to descending and back? In table view that is the way sorting works, but in form and list, via scripting you have to choose one or the other. Is there a way to script this automatic sort "flip"? thanks

I know how to do dynamic sorting based upon a global field, but what I want to try and do, is sort on different tables by the same field. The different tables is what's throwing me. An example: I have a few different tables all containing a field "Name" When the user clicks on a button to view the list, the scriptparameter chooses the correct layout/table to view i.e LIST_[color:red][get(scriptparameter)] [color:purple](e.g LIST_Legal) What I want to do, is go to the appropriate list, and have it sort dynamically. I have created the same field in each table (e.g name) so what I want to do is this. GO TO LAYOUT - LIST_[color:red][get(scrip…

I am new at this so hope my question makes sense. I have a quotes table and related line items table. i want to be able to copy some but not all of the line item records from the quotes table to a projects table (ie client approves some but not all quoted options). can i create a script that copies data from several fields of one record/line item in quotes and pastes it to matching fields in project line items?

Hi everybody, I have a simple filemaker database with several fields. when I press Command+C without selecting a single field, my clipboard gets a chain text of all fields of the selected record separated by tabs. I dont have any experience with filemakers scripting or with apple scripting. What I want to achieve is to modify this copied data. Lets say I only want to have the content of selected fields, separated by a "n". My first approach was to try to do this with automator, but I couldn't figure out how to manipulate the clipboard content. My next approach was to somehow do it in filemaker: either with a button that copies the the defined fileds to the…

I want to create a Runtime database that will be put on unknown desktop. Have a script to create a copy of the database on closing. I cannot seem to get the file path correct. I have: SetVariable [$Path;Value:"Filewin:" & Get ( FileMakerPath )& "Backup/" & $BackupName] Save a Copy as [$Path; compacted] where the folder "Backup" resides in the runtime folder. $BackupName is set in a previous step and works fin ewhre I set the path 'manually'. I cannot figure out making the Get (FilemakerPath) part to work. Where am I going wrong? Also, is there a rather simple way within Filemaker to script the creation of the folder "Backup"?

My brain just doesn't want to think today, so I need help with something pretty simple. I want to open a file that is stored in a container field. I do not want to export it's contents, just open the original file. I was trying to use Get (Filepath), then Open (URL) but I cannot get the Get (Filepath) to work properly. I keep getting the error message that the parameters aren't correct. Any help just getting a file from a container field to open? Not sure if I need to write a script to get this done, so I'm hoping I have posted in the right spot. Thanks much.

Script step provides a pause checkbox on Enter Browse Mode and I am trying to figure out when I might use it (of course manual View > Browse won't allow pause). When Browse is paused, I can modify data and scroll through records but I CAN'T create a new record, delete a record, sort ... well, you can try it and see what disappears on the records menu (in fact, many of the menus lose several functions). Of course as soon as I hit [enter], I lose the browse pause. So can anyone explain how it might be used? :wink2:

Hi, Is there an efficient way to write into empty fields only? Instead of writing a bunch of if [isempty(tableB::fieldA)] Set Field [tableB::fieldA; tableZ::fieldZ] end if I'm writing a script to allow user to start filling automatically the new database seamlessly. The old database was not normalized (18 years old project!!) and I create a new one which respect most DB standards. So I need an efficient script to transfert data from table_old to table_new_A, table_new_B, so on. Thanks for any help

Hello everyone We have a big database including information about father, mother, grandparents and siblings. We use scripts to create fields by calculations. These calculations are the same for the father, mother, grandparents and so on...except for the referenced fields, which are different: eg: to create a field 'Sudden_death_father' we use for the father: If (Position ( quest2::E6 ; "5" ; 1 ; 1); "Yes"; "No") (In question E6, if people filled in answer 5 then there is sudden death) For the mother it would be:'Sudden_death_mother' If (Position ( quest2::E6_2 ; "5" ; 1 ; 1); "Yes"; "No") For a grandparent: If (Position ( quest2::E6_3 ; "5…

I am using a global variable to capture the current value in a field and then re-insert that value if the new value chosen is invalid (statuses must follow a pre-defined progression). If an invalid status is selected, I display a dialog that says the selected status is invalid and then my script inserts the value of the global variable to restore the status to the original value. I am thinking I will have a problem with a multi-user system (which this is). If my co-worker and I change statuses on two different items at the same time it looks like one of us may end up with the wrong status when finished. Are global variables restricted to my login or are they sy…

I have the following script: Set Error Capture [On] Perform Find [Restore] If [Get (FoundCount) = 0] Exit Script [ ] End If If [isValid(Contact_Data::DupWarning_Address) or IsValid(Contact_Data::DupWarning_ID) or IsValid(Contact_Data::DupWarning_Name) or IsValid (Contact_Data::Incomplete_Record_Warning) Go to Layout ["Volunteer Information Sheet" (Contact_Data) Enter Browse Mode [ ] End If I have set the script, using File Options, to run when the file is opened and when it is closed. It runs fine when the file is opened, but it will not run when the file is closed. Anybody know why? TIA

Before I start getting into things over my head I thought I better ask for some advice. Currently all scripts work manually and checking the script manager I don't seen any issues with my script running on the server. I do need to figure a couple of things out. I need the server FM Advanced Server (OS X) to mount a Windows server share and unmount when finished. From my initial research I don't think FileMaker is going to do all this for me. Can anyone point me in the direction of a good starting point for having FM server connect to and disconnect from a window share?

I don't use Pause/Resume very much. Does it always give the option to continue in the Status Area? I'd like to remove that option if I can. All User About[Off] doesn't help.

This has been discussed a long time ago (see topics 34637 and 41683 for instance). Can anyone comment on the solution suggested by http://www.filemaker.com/support/kb/?answers/detail/a_id/1008 ? The field ¦ in not PatternCount(TextField, "¦") >= 1 suggests the existance of a 'soft carriage return as a result of wraparound'. Puzzled !

I was unable to find any posts / documentation in regards to automatically adding users so i figured i would throw this out there to see if it is a possibility. The current database i am working with allows members of the organization to register for access to the database. I have a form on the website that the user fills out which then saves the results to a csv file on my webserver and alos emails me a copy of the submitted form. Lately ive been adding 20+ users per day manually. Is it a possibility to have FileMaker read in the CSV file and add a user based on the fields in the file? The CSV's structure is as follows: Name Email Ret. Date Passwor…

I have a FM 10 DB hosted on a FM Server Advanced platform that I need to get to run a scriptdatabse everyday at 5 am and again at 12 noon to convert ODBC source records into usable records in the DB. At 5 am, no one is in the database but at 12 noon there may be people in the database. Any ideas on how I can do this? I looked into Install OnTimer Script, but this only works when a window is open, so that might work for the 12 noon, but what about the 5 am? I am sure that someone has done this and could help quite quickly! I guess I could have it run the script when the 1st person opens the database, but would prefer not to have it in the open script. Any ideas w…

Hi, I am new to FM. I have a field that will be used to capture scanned barcode. When the return key is received from the scanner, the OnObjectExit script will run. At the end of the script, I put the Go to field script, but it does not put the insertion point into the field so that I can scan the next barcode. How can I do automate this script to allow me to scan a barcode and run a script and then place the insertion point back in the field so that I can scan the next barcode. Appreciate your help. Thank you.

Hi, when a User adds an item (every item is unique) to an invoice a script marks the item as "charged". Now my Problem if the user deletes the invoice the item should be marked as "uncharged". No Problem If I'm writing a delete script assigned to a button but what if the user clicks on "delete Record" in the FM Menu? Thanks by ChiSao

Is there a simple way to strip all html tags from a piece of text held in a text field, so that you are left with just the text that is not enclosed by any tag?

I frequently use the Open URL script step to open a variety of text and pdf files and has worked for me flawlessly, but I have one workstation (pc/win) when this script step is encountered the pc tries to copy the target file to a new location. It immediately brings up a dialog box asking where you would like to copy the file. I have never seen This before. Any thoughts? Thank You Anthony Dixon

So I'm trying to do an automated save as pdf in my database. What I want to do is make it possible for someone to save a file by just pasting their path from a Windows Explorer address bar into a custom dialog box in FileMaker. The only problem I am running into is converting the "" over to a "/". For instance if I want to save the pdf in the path C:Documents and SettingsAdministratorDesktop then I need to tell filemaker to find and replace all the 's with a /. And my final save path will look like this filewin:/C:/Documents and Settings/Administrator/Desktop/. The problem I am facing in doing this is that Filemaker recognizes as an operator for division a…

Boy do *I* feel silly. I'm trying to use a splash screen for the first time, identifying the database name and my contact info, so I made a script that opens the splashscreen layout, but when i tried it, I found the last layout viewed also opens. So, I took a guess and put a "Close Window" step at the beginning of the script, which is apparently the wrong thing to do, since now when I open the file, it immediately closes the window and I'm left with no open file . . . which means I can't get back in to fix the script. In effect, I'm barred from entry to my database! D'oh! I figure there must be a way to circumvent the opening script, yes? Please? Holding s…

I want to perform a script on records created in the last 90 days. I would start out the script with a Perform Find command, based on the date created field, but now can I format this to show only records from the last 90 days. I tried using the "Todays date" symbol ( // ) and subtracting 90 from it and then doing a range ( ... ) from that calculation to the current date, but that didnt seem to work (syntax error).

Is there a way to undo a script that I just performed. In other words. Give the user an option to completely undo what the script performed? Like an on script/ off script button. So if the script performed a bunch of calculations on some fields and the user later wanted to go and not have that script been run on those fields click a button to undo it? Erik

Hi There, Am using the "send mail" event where there are ~2200 recipients in the bcc field. (one email using data from the current record; bcc - collect addresses from across found set) The database dies every time at this step. Completely shuts down Filemaker. Is there a known limitation on the number of recipients? I have checked our exchange and the limit is 64,000 so it's not that. Have tested on 2 different computers (XP -v- 7; 9.5 -v- 10) with the same results. Can successfully export otherwise to different format. (i.e xls) Thoughts? TIA

Hi all.. Need some help with this one. Am looking for a script which will allow me to go into a field and run a script without using script triggers. This will be used in IWP. IE I will have a field called field1. I need to make that a button and when clicked, I need it to run a script process and then leave me in that clicked field for editing without explicitly telling it what field to go to. I know I can do this via passing a parameter within the script but I was hoping for something a little more elegant that is more transportable. Any help would be appreciated Stu

How can I trigger a script in calculation field? Please help me!

Hi everyone! We're facing a big problem. We have a huge database considering family history. People filled in a questionnaire about their family (mother, father, grandparents and siblings) history. This data is put into a database, without any problem. Now to be able to use this data, we made new columns based on the original data, by using calculations (for example: in question 1, when people filled in number 5, there is "sudden death", so we made a column "sudden death": "yes"or "no") The problem is, we have made maybe over 100 columns using calculations (some of them really complicated by using case() and positions () with lots of conditions), the resu…

I recently noticed that one of my scripts hasn't been working correctly. If I run the script manually from a client, it works perfectly.The script involves running through a loop, which copies records to variables, then switches to a different table, creates a new record, and pastes the variables down, then switches back to the layout to continue copying until it reaches the end. This works perfectly... except when I schedule it to run automatically on the server. Then it usually only captures half the records, and at some point spits out the error Error (101) Go-to-Record... as far a I can tell, there isn't any compatibility issues with the serve…

Hello all, I am new to the forum (and to Filemaker)so hope I am posting in the right place. The file I am working on, I always have two windows open,side by side. I need to be able to always work on 2 consecutive records at the same time, and be able to go back and forth between the two. The record in the right window always needs to be 1 record higher than the one in the left window (so if I am on record 1 in the left window, the right window is on record 2, if 5 is in the left window, 6 is in the right etc.) Is there any way to automate the process so that whatever record I go to in the left window, the right one automatically updates to the next record up fro…

Hi, we pay our staff into their bank accounts electronically. our database field is Bank_account which we input how much the person gets paid..No problem. some people have 3 bank accounts. the boss wants a way to put a percentage against the other 2 accounts. So if he puts 30% on bank_account 2 and 70% on bank_account 3 the money is worked out and distributed across those accounts. Is this possible? Thanks

I am trying to write a script that will find records within a range. After reviewing other posts, I have tried several approaches, none of which work. At the moment, I am doing the following: Records in my To Do database all have a Due Date. I have created global storage date fields gStart and gEnd. Unsuccessful scripts include: Enter Find Mode[] Set Field[To Do::Due Date = To Do::gStart & "..." & To Do::gEnd] Perform Find[] This script returns error message "No Records Satisfy Criteria" even though I know that many records fall within the specified range. I note that many posts on this subject use a ";" rather than an "=" in the Set …

Im having trouble with a script that needs to run onLayoutLoad. I have a member's database that i am starting to setup users in. Each user's username is their email address. Each user also has a record in the database. What i would like to do is once the user logs in, have the database open up to their record. I've tried to setup a script that would Perform Find or Enter Find Mode, but it seems i cannot use the Get functions. For eaxmple, what i've tried to setup is a script that would look like the following: Members::Email = Get ( AccountName ) Problem is when i use the specify find requests, it actually searches for an email address o…

I'm having a problem with what I thought would be a simple script. Currently I have 4 different contracts defined in a value list. The user selects the desired contract and then clicks on the "Go to Contract" button that has the following script assigned. However, no matter the selection I am always going to the "Standard Purchase & Sale" contract. I tried using the Else script step between the first 2 options after the 4 individual If . . End If segments. This made no difference. What am I missing? Is there a better way to do this? Following is a portion of the script: Allow User Abort [Off] Set Error Capture [On] # If[Property Analyzer::Contra…

how to fetch record from portal records and show it in other layout.

Hi Having major issue working out a solution to the following issue. I have a customer base of let's say 1,000 customers, I need to export their data and supply them with a merged pdf form for them to check, alter and return. From what I can see it is easy to import one record into Acrobat (always first record) but there is no way to create individual pdf files for each customer. Does anybody have any ideas of either FM plugins or PDF plugins that would do the job? It is worth noting that there appears to be a windows based plugin for Acrobat called Automailmerge that would do the job perfectly but as I am on Mac it is of no use to me. Any ideas/help/guida…

i have a field computer serial number in my filemaker application,and i want as i open the application the serial number of my computer will automatically show on that field. How can i do this? please explain with example.

Dear All I am using FilemakerPro 8.5v1 on an Intel iMac running Mac OS X 10.4.11, with no current plans to upgrade either!! I have a database with a single Table called "Table1", with about 500 records in it at present, maybe 2000 more to be added in the future. I have about 100 fields in this table called, for example, "YA01 Clothes" or "BY20 Home Decoration and Wallpapers". In other words, each field name starts with 2 uppercase letters (A-Z), followed by 2 digits (0-9), and then a space and then a **varying** number of letters. Note that I ensure that the first 4 characters of each fieldname are unique to that table. More such fields may be en…

I posted this question in the Portals area since it originally is regarding copying records from one portal to another but I got no response regarding the issue with the last step of the script for looping to the last record. It was originally based on the example, Example_mod1.zip, made by lastpass (http://fmforums.com/forum/showtopic.php?tid/211726/). The last step of the loop is End Loop If ( Max ( Packageonedata::PoneID ) ) I imported the script from the example and modified it to mine and through some trial and error (I realize that fields names cannot include a digit or a "_", apparently) I got it very close. However, the script, otherwise, does it a…

Hi Folks, I have a database solution that generates windows to edit records in related tables. I need to manage the window clutter that this can generate. I don't think my script solution below is very efficient at handling this. There has got to be a way to reuse a window and still be able open a related record. How do you handle this? I know I'm just forgetting something simple. Thanks for your help. Cheers, LC Script Name: WindowClutterManager Set Error Capture [ On ] If [ Get ( ScriptParameter ) = 1 ] Set Variable [ $$window_name; Value:"Purchase Details" ] Select Window [ Name: $$window_name; Current file ] If [ Get ( LastError ) = 0 ] Clo…

I am trying to validate a variable in a script I created. I want the script to skip over the variable to an else statement if the variable is not valid but neither the if(NotValid) or if(IsEmpty) script steps are getting me the result I want. Is there something else I need to know about validating with variables?

I am looking for some help. I am looking to do a nested if within a calculation. I am looking to change the email based on the arrival and departure dates and whether they are the same. The two different sentences would read: Greetings! This email is confirmation your upcoming visit to John's College on April 2, 2010. or if they are viting for more then one day it would read: Greetings! This email is confirmation your upcoming visit to John's College on April 2, 2000 through, April 3, 2010. Can I do this? When I try to add this the "through, April 3, 2010." it gives me errors and trys to make "through" a field. Any information or links to as…

I am using a script to show a count down of 10 seconds. Loop Set Field [Timer, Timer - 1] Pause/Resume Script [0:00:01] Exit Loop If [Timer = 0] End Loop This works fine, but I just need to show seconds not hour, minutes. Is there a way to just show the seconds.

How can i change this error massage "this action cannot be performed because this field is not modifiable"

I need a script that will act as a counter when a button activates. Ideally, when the button is pressed the first time a 1 is entered, when pressed a second time a line return and a 2 is entered, ad infitum. Can anyone help me? TIA

This script deletes duplicates... except if the duplicates are the last records in the table. If the last "Go to Record" step is inside the "If" statement, this script deletes all of the last records. If the last "Go to Record" step is outside the "If" statement, it leaves one duplicate! Neither outcome is good. Any ideas? Delete Duplicates Sort Records [ Restore; No dialog ] Go to Record/Request/Page [ First ] Set Variable [ $ID; Value:Table01::ID ] Go to Record/Request/Page [ Next ] Loop If [ Table01::ID = $ID ] Delete Record/Request [ No dialog ] Else Set Variable [ $ID; Value:Table01::ID ] End If Go to Record/Request/Page …

Converted files from Filemaker 7 to 10. No problems but this one: Have about 18 files in a folder that are scripted to open automatically by one open script. Worked OK in 7, but I have two files that wont open automatically in 10. Filemaker says it cant find them, and I end up selecting them from the folder list each time. All files are basically the same. All files appear in the folder, but two wont open when instructed by the open script. Same format, same everything. Checked and rechecked all relationships and scripts in the other files. I must be missing something. Any one have any ideas?

I've have a few scripts that open a window and lock it until someone closes the window using a Close Window button to resume the script. Log story short I'm looking for a work around to help me out when yet another window is opened and the resume is broken. I'm looking for a way to write a script that basically says If there is an active script or a scripted paused Resume else close window. I'm not finding thing to let me know if there is script paused. Any suggestions are appreciated.

Have a database with the contacts linking to the sales invoice. The problem is the sheer number of records ( over 15,000 ), the fields that have autofill enabled takes about 5-15 seconds to sort through. Any way in making the field respond faster without disabling autofill? [color:blue]many thanks for assistance.

How do you nest two types of text function? I have TextFormatRemove (self) + Trim (Self) and I get a 0 in the field so I know this is not correct.

Hello all: I have a container field with a "reference" to a PDF on our WINDOWS server. Up to this point ONLY windows machines were using the app. Now with a few MACs when a Mac user double clicks on the container field - they get the error message File not found. I was thinking of putting a button on the container field and testing for the system platform and then use the OPEN URL script to open the file up. It works for the windows side but I must be missing something on the Mac side. I have my path on the mac side set to: smb://ServerName/directory/filename.pdf After executing OPEN URL with the above path it doesn't choke but it doesn't open the…

Good Day, When using the Insert File script step (store reference only, specify source file unticked), is there anyway to force Filemaker to open the dialogue box in a particular folder, so that users do not have to browse for the folder required. What determines the active folder, Filemaker or Windows? Tks in advance. Shaun

How does one do calculations between timestamps? Specifically I want to return the number of hours elapsed. Appreciated.

FM8, Mac OSX 10.4. Shouldn't the Adjust Window [Resize to Fit] script step reduce the size of the window to enclose my found records? It doesn't seem to do much of anything. I can reduce the size of the window manually, and then my footer comes up nicely and everything looks good. But if I then run the Adjust Window script step alone on a manually-closed-up window, the window opens to the height of the screen and I get a bunch of white space after the records in the body part and before the footer part. The layout looks OK, with sliding.