Script Workspace and Script Triggers

Hi, completely new here. I have a image database and add keywords for the images. However, often I would like to select several images as they are similar, and type in keywords relevant to all of them. How could i do that? Thanks, Dimitri

I am wanting to create a selection box much like you see when you are exporting a table to a csv file. In that example, you see a list of available field names from the current layout. As you click a field name, it is added to the "Fields exported order" box and it disappears from the available fields box. In my case, I am selecting document types from a document type box. I have a possibility of anywhere from 1 to 50 document types for a given customer. I am wanting the user to select which documents are present for each customer. I know how to load the selection box.... (I presume that I populate a field with all the possibilities separated by line fee…

Hi, I have 3 tables with following relationship: FIRST TABLE >--- SECOND TABLE --one to one-- THIRD TABLE On the layout of THIRD TABLE I have a portal connected to FIRST TABLE. Now If I klick on a record in the portal I would like to open a new window with the layout of FIRST TABLE and the related record. Is there a nice way, without using the IDs in the script? Information: If I use just "go to related record" it works(but in the same window). Then I tried following script: OpenWindow(size) goToRelatedRecord (FIRST TABLE, layout of first table) This doesn't work Any ideas? by ChiSao

Hey guys, Thanks for all your help. I want to have a checkbox that when checked turns a contact into a company and thus creates a custom company serial number in another field. I've tried using a calculation for the custom ID field (ifValid checkbox then ) but it hasn't really worked out for me. Ideally I'd want the custom ID to be the first word of the company name and a serial number that only increments if there are duplicate first words. E.g. Stylistics Inc: stylistics1 Whatchamacallit Inc: whatchamacallit1 Brown Hardware: brown1 Brown Groceries: brown2 But again, only if the checkbox is checked. Any help would be immensely ap…

Hi, Is there a way I could format a button based on an active tab? I want to use buttons to navigate through tabs. The tab names (object name) are formatted as tab_sales_1, tab_sales_2, ... The button names are formatted as btn_sales_1, btn_sales_2, ... Thanks

So i have some time entries that i input every 2 weeks days are 1 to 15 and 16 to end of month. i have a script that now Changes these dates after the master record is duplicated with line items. My script at the moment just inserts the current date into the field, what i would like is that it kept the DAY date and just changed the month to the current month and possibly the year to the current year so when i get to december my year gets updated, so i do not have to go back and insert the correct day and year again. my "calculated result" on the set field step is [color:blue]Get ( CurrentDate ) i just need a new calculation but do not know where to …

could someone please give me the code to write a script that will uncheck a certain check box. i have a check box called "to print" I select this so I know I need to print that record, but after I have printed I have to go back and manual click on all the check boxes i had already printed. Is there a way i can find all the checked "to print" check boxes and deselect them all at once? please be specific step by step i have no idea what i am doing. i know how to click find and then select the to print check box and it brings up all the records where to print is checked. hope this all makes sense. any help would be greatly appreciated. :

hi i have read and searched and tried many scripts to do this my problem is my loop script works but it inserts the time entries from the portal to the same JOB_id number and not the new Job ID i think the problem is it is duplicating the line items which already has a JobID assigned to it, so my script need to ignore this previous Job_id number when it duplicates how do i do that here is the script i just cannot chain everything together in my head Go to Layout [ “Job Entry” (JOB__Job.tog) ] Go to Related Record [ From table: “job.TIM_TimeEntry”; Using layout: “TimeEntry_list” (TIM__TimeEntry.tog) ] [ Show only related records ] Go to Layout [ “J…

Is it normal that the Random function always starts with the same number? For that matter, it always uses the same sequence for me. Is there any way to reseed this so it seems more random (even though I know it's not truly random). It does me little good to have my random function start from the same number each time. Here is a sample file that I built with a button that populates a field with a random number when pressed. Whenever I close and reopen the file, it goes through the same sequence. http://mindbendtoo.biz/filemaker/ "random-test.zip" is the file Here is the sequence I get: .87584429228484828034 .086323888546938024047 .46119167956…

I have been exploring how to get data sets such as record ID lists from a found set. The following technique builds a a list at about 10,000 records/second. A 200,000 row list is built in 16 seconds. Processing 20,000 records is basically instant. Of course you can accumulate data from any field you want. The general idea is that: 1. The replace operation works on a found set without navigating the record set. 2. A replace operation can be performed on a global field; thus it is multi-user safe and does not change your data. 3. A replace operation can use let functions and variables and does not even have to actually write anything to the global field…

FM10 I need to trigger a script by using Filemakers navigation buttons ie going backwards and forwards between records. From the Help file it looks like I should be using 'OnRecordLoad ' but I have no idea how to use it. Can anyone help?

Dear Professionals, I need your help. My friend is working in a construction company and has a huge number (almost thousand) of line items in each of his quotation. He wants to create new invoice from this quotation. Or should I say duplicate the quotation line items as new invoice line items. He is currently opening new invoice window then drag and dropping all these line items from quotation not the quotation line. I can imagine his pain scrolling the portal rows and then making modification in the invoice... It would be so great if you could lead me to some clue. I'm using FileMaker 10 advanced on Mac OSX.

I am experiencing a problem with the Export Field Contents script step in Vista. When I check the Automatically open file box, the file does not open. The file is successfully exported to exactly where I have specified but it just will not open automatically. Others that I have checked with that are also using Vista do not seem to be experiencing this and the same script will open the file on my XP machines. I am using Vista Ultimate with all updates and this has been a problem with this computer since I have had it, even with previous versions of FileMaker. I'm currently using FileMaker 10.0v3 Advanced. Has anyone else had this problem or am I the only one? I have…

I know you can modify the window size via the "New Window" or "Resize Window" commands. Is there a way to modify the FileMaker Application Window Size? I Want to shrink the size of the Filemaker Application to the size of the open Filemaker script window.

How can I better control a find that returns no match? I'm performing a find in my script and have an [if LastError = 0 continue with script, if not exit]. This would work ok, but when find comes up with an error File Maker gives user an option to "Continue" or "Modify". I don't want to give user an option, maybe show a custom dialogue saying why script halted but that is it. I don't want scrip to stall, just to act accordingly. I thought I could just turn error capture off an I would be good, but that did not work. Any ideas on how I could smooth this bump? THANKS!

I'm a newbie here to the forum for the most part and to Filemaker, but what I have seen so far is great! Love this application! Now if I could only get "it" to work. My problem is I have two tables: 1) shipper, 2) receiver I'm trying to use the "SET Field" scripts to transfer a shipper's info to the receiver, but for the life of me, cant get it to work! I'm sure this is very simple, but I'm NEW and obviouly overlooking something. Does this have to be done with variables? I have posted my sample file for viewing. Thanks for your thoughts into this. shipper.zip

I have modified the default PO database layout to fit my needs....however I have a quirk that I can't figure out. When I click "Print Purchase Order" it brings up a preview of the purchase order as it should, but it seems to put each product entered in the PO on it's own page. Now, when I click "Email Purchase Order" it all shows up perfectly and all items on the PO are on one page. How can I get the print script to correctly display the items on one page? Thank you for your help : Edit: By the way, I have not touched any script at all when modifying this layout. So, if you were to create a new database and pull the "Product Order" layout you w…

Hi All, I am using the relogin script step in a script. I would like to have my script act accordingly if the user cancels the relogin. Is there an error code or message choice to detirmine if the user has cancelled the relogin? Thanks

Hi, I am trying to script sending emails with an academic report attachment to our parents. Specifically, I need to generate an email to each of my 9th grade students' parents (79 students). I would like to add their current midterm report as the attachment. The midterm pdf currently sits in a container field in the student table. I've read on the FMP site "Variables are not supported in file paths that are stored in container fields". Any ideas for a work around? Cheers

Whenever I import records, I have a script that automatically populates City, State and County upon seeing the zip code. Should the zip code not be present in the reference file, it populates all three areas with the letters URD (update relational database). All records show this whenever I import. However, when I manually re-enter the zip code in each record, the correct corresponding City State and County show up, as if by magic. Any help on where I've gone astray with either my relational database(s) or scripting? When I use a script to re-enter the zipcode in each record, I still get URD populated in each of the three fields. Woe is me. It seems as if…

Hi All, I ve been searching and figuring out how to archive a file which remains in the same file but can be summoned anytime to create; 1) duplicate record with different data set or independent of each other without changing the archive file. I can duplicate and had flagged the archived "inactive" and saved the found set and set privileges to be accessed only by [Full Access] accounts but; 1) PROBLEM IS - It is not independent of each other. Any changes from ... will occur to the other. ' i thought of exporting to an archived file but I am very sure there is an answer from our experts! Thank you sincerely... :

hi fms10/fmp10/fmp10a a series of fields on a layout have script triggers onObjectExit The layout should have no tab order The aim is to allow the user to enter a field value, tab out of the field and thereby trigger a script to force a commit/refresh so that the changed data is immediately updated on other concurrent user screens. with no object (i.e. no tab order) as such, tabbing out does not work, as there is no destination object to tab to. if a 'harmless object is defined, in order to make tabbing out of a field work, then the record stays 'locked' in a multi-user environment The aim is to avoid having to have the user click out of the …

Hello, I've setup some field validation using script triggers and it works well. My script has an Exit Script Result: 0 step to prevent the user from leaving the field if the data fails validation. My solution, like many, also makes use of scripted navigation and that's where the problems start. If the user modifies one of those fields and then hits a navigation button the navigation script is triggered first. Then, upon reaching a script step that takes the focus away from the field, the field validation script gets triggered, the validation fails with an Exit Script Result: 0 and the focus remains on the field, but the navigation script keeps going... so …

Got it! It was a rogue script step. I seem to be able to 'get' the answer once I ask for help... hmmmmm The startup layout has a script trigger 'On Layout Load' referencing a script that resizes the layout to 280 x 380. When FM is running and I DOUBLE CLICK THE .FP7 file the program starts as expected and the layout is resized accordingly. However, if I close that instance and choose FILE/OPEN RECENT I get a much larger window that was previously shown. Also, if I click the OK button on the smaller first layout it takes me to a larger input layout. If I exit my program from that larger input layout and then restart by double clicking the .fp7 f…

Hey guys! So I'd like to set up a script that creates a new entry on a new layout and copies over several of the field from the previous layout. Ideal would be if after this it copied back the new entries ID number into the relating field of the original layout. I KNOW that this may seem like a duplication of information which goes against some database rules but it's the way we need it to work. I've gotten to a point but when it comes to copying my script always ends up pasting only the first copied field...I'm trying to copy several fields to several others, not many to one or one to many. I've been trying a straightforward approach of using the copy…

Hi All, In an invoicing solution I am writing a script that needs to determine how many invoices a customer has. I preffer not to do this from the Invoices layout because It would require a find that would kill my found set. What would be the best way to goto related customer and find out how many child records that customer has? Thanks

Is there a script trigger that would work while entering a layout and where is it found? ie, OnLayoutEnter ? thanks,

Frustrated newbie needs verbatim script for no records found for online database. On my home computer, if no records match the search terms, I get a generic alert from FileMaker that no records were found. On the online database, nothing happens. I know you cannot use a custom message; I just need something to tell users the search turned up nothing. I have asked this before, elsewhere, but did not get answers that worked for me.

My job is that I count a keyword in the file maker database. I created a database file(a template), and I put some news articles in my database file So, do you know(or let me know) How can I count a keyword(e.g.: "Food" "storage") and a group word(e.g.: "Food storage") in the filemaker software? I really need to know the function (counting a word or a phrase) I used the "Find" function the function only shows me that how many news articles include "Food" keyword. But, it can not show that how many times "Food" keyword include (or is counted) in each news article and whole news articles(a month or a year amount) I created a script for the…

Hi all, I have a found set of invoices that I need to duplicate. I would like to loop through the found set and create a duplicate record for each invoice then set a couple fields before moving on to the next one. Of course I realise it isn't as simple as looping through and duplicating because once the first duplicate record is created it becomes the last record in the found set and the script then exits the loop (all the better of course, otherwise it would get stuck in an infinite loop). So, Can anyone tell me what the best techniqe for doing this would be? Thanks Ron

Using 13 values as parameters, all transfer except the 12th one. It is text of customer's middle name. What am I missing here?

I'm trying to get the most recent date in a particular field, across all my records. The field is Accessions:accession_date. The field is set to Date type. The date is not calculated, it's manually entered into the field when a new record is created (in some cases the field is empty when the accession date is unknown). I tried Max (Accessions:accession_date) but every time I run the script, I get the date of the record I'm currently sitting on, not the max date of all records. What am I doing wrong?

Hi all. Looking for a little help on this one. We are a calendar company that sells advertising on calendars we produce. So for each calendar a customer will only have a purchase once per year. What I am trying to do is create a found set of customers who bought an ad on a particular clendar last year but didn't buy one this year. The tables involved are: Jobs ( The calendar in question ) Customers Tickets ( Our equivalent of an invoice ) So I have started by doing a find for all tickets ( invoices ) for Job A for both this year and last year. Now I need to figure out how to get to the customers within that found set that only have Tickets for last year.…

I am working on a document management system. The documents will be stored in container fields (using OLE) using INSERT OBJECT in a script. Once a document is in the container field, I don’t want the users to be able to right click the container field, which the allows them opportunities to mess things up by giving them options like Insert Picture, Insert Quicktime, Open Document etc. Once the document is there, their only option should be to edit it. So, I just want them to be able to edit the document and I want to do this with a button and a script, not with a right click. But I don’t see any script step that allows me to do that. Is there a way I can allo…

Hi, I have a script that runs a splash screen with 'allow user abort' off. unfortunately i think ive got a bug in the script and it runs for infinity! Ive made a lot of changes to various scripts since i last backed it up and was wondering if there was a way of disabling scripts altogether or grab the scripts from the fp7 file? Any help would Really be appreciated, Thanks, Moaa

Hi. I have searched everywhere I can think of and I have not seen a solution to this problem. I am using Filemaker Pro Advance 8.5. I have a file with the following fields: Name, Mailing Address and Age. It contains over 200,000 records. Many people in the database have the same address (husband and wife for example) and I would like to omit or delete the duplicate addresses and only keep one record for each mailing address. I want to keep one person per address- preferably the oldest resident at the address. I know some of the addresses will not be exactly the same format (example 24-A vs 24a or Ave. vs Av.) and a solution to my problem may not work for those…

Okay, I've been searching around this forum for the past couple of days in hopes of finding a solution to what I'm trying to do. Sadly, I didn't find anything that may help me out, so I am posting this to potentially obtain some assistance from the gurus. I'm creating a semi-basic call management database. On the primary call screen, where all of the caller information is entered, there is a drop-down option called 'Call Status'. Basically, this is either 'Open' or 'Closed'. What I'm trying to do is this: when the 'Closed' option is chosen from the 'Call Status' drop-down menu, I want to trigger an event that locks the record from being modified. On the other …

Hi All, I've been working on this code and it seemed very redundant for me. But I cant seem to create a short but efficient code. Here's the scenario; 1. I have Employees(EMP) and Human Resources(HR) Table. 2. EMP contains the personal info and HR contains all the requirements which includes (11 status (text) field, 11 exp or renewal (date )fields and 11 days to expire (calc - renewal_date - get(currentdate)) field. 3. I developed a long repeating script that will trigger and remind if requirements are going to expire "EXPIRING", EXPIRED or CURRENT. Here's the Code: Requirements [ Tracking] Perform Script [ “Allow User Abort” ] Per…

I am trying to run a script that will find people depending on the letter that their surname begins with. The script does not show the custom dialogue message when records are not found. Any suggestions gratefully received. Set error capture [on] Enter find mode[] Insert calculated result[select; surname field; get (scriptparameter)] Perform find [] If [get(lasterror)=401] Show custom dialogue[“Message”;”There are no surnames starting with the letter “&get (scriptparameter)] End if

I hope this isn't obvious but I have a container that only store a reference to the file. If I double click on the container the file opens but how can I set a button to open the file. I'm not seeing anything in Script Maker to let me do this, I see lots of way to insert files into a container but no way to open them.

Having set up a FileMaker database as ODBC datasource I can access the database via the "Execute SQL" script step. Thus it is possible not only to work with the content of fields, but to manipulate tables directly. Where sys_LanguageVars is a table that can be accessed this way, Execute SQL = ALTER TABLE sys_LanguageVars ADD MyExample VARCHAR will create a field of type text with the name MyExample in the table sys_LanguageVars. This works like a charm, but: is it possible to set the option "globale storage" this way as well?

Is it possible in a script to determine the current mode? For instance I would like to have a script with an if statement that says If current mode = browse do this Else If current mode = Preview do that Else Do the other end If Thanks in advance. Ron

I have attached a jpg showing all my points.. I have 5 containers.. Designed to create a Image named and located at a certain path.. Everything is lowercase.. and every side by side the exact other codes (2 lines) is the same... and between 8 images.. 1 account 3 workshowing image.. the other container i get ERROR My other acct# 2 out of 2 images show or load by script.. Driving me crazy .. got to lol..

Have a script that (or hopefully will have) that performs a search automatically on user opening a file. If their user name and current date already exist in a particular field, then the script goes to that record, which they will then amend. If the search returns no results then a new record is created. How do I get a script step to say, "if no records found do x" and also how do I get the the dialogue for no records match this set to NOT appear. Thanks.

I am trying to write a script that does the following: 1. Opens a new window [app selection] layout that has a list of all possible menu items (I have this part figured out) 2.When I click on the arrow next to the item I want another script that takes this item and adds it to the purchase order [apps PO layout] 3. I want to return to my original layout and see the the item I selected in the [apps PO portal] For the [apps PO] I have a relationship formed using the [color:red]event ID field in the [event management] I also have a relationship between [apps PO] and [apps list] using the [color:red]Item number field The [apps PO] has the fol…

I currently have 3 tabs: Contacts, Quotes, Tasks and when I put a script trigger on Quotes and I put it on OnObjectModify, everything I hit another tab, it will start spinning and crash, as if it's in an internal look. If I just run the script, everything is fine, the script looks like this: Go to Field [invoice Total] Go to Portal Row [select;Find] Loop Set Field [sales Orders;...] Go to Portal Row [Next; Exit after last] End Loop Go to Field [select/perform;Address_Street] I don't see anything wrong here, any reason why this would get into a continuing loop?

Go to Record/Request/Page [First] Loop Perform Script ["Migrate"] Go to Record/Request/Page [Next; Exit after last] End Loop Im using his script to perform the script migrate on al my records.... For sme reason the script works fine for a while but after a few records filemaker freezes and I can't do anything but end task it. Is there something wrong with the logic i've came up with?

Hi, I'm new to Filemaker and I would like to create a button with following functions: 1. go to layout "..." 2. create a new record 3. put in id (into foreign key field )from the related record (Record I was looking before using the button) 4. now the user should complete the other fields by itself I know how to do this with portals and automatic creation of related records but in my case I would like to do the same thing but on another layout instead of portal. Could you give me some hints? Thanks by ChiSao

I wrote a script in FM9 that generates a report, narrowing information by user specified date range. Enter Find Mode Go to Field (orderdate) Set Field (orderdate) to DateRange Set Error Capture On Perform Find. Worked great in FM9, doesn't work in FM10. Seems to be a problem with setting the field to the DateRange, which is a calculated field based on a start date and an end date. The calculation results in a field value that is something like 1/1/2008...1/31/2008. Works if I manually enter it in while in Find mode, but FM10 seems to dislike that format when trying to enter it in to a date field. Any ideas on how to get around this? T…

Hi Not sure if this is the right part of the forum. I have a table with a record_ID field which is a unique number using the auto-enter facility. I have managed to create a number of records with duplicate numbers, (not sure how - but almost certainly when I was transferring stuff from an old database). I need to renumber all the records so that they have unique identifiers. The table does not have any related records at present so will not cause any problems renumbering. Many thanks for reading

Hi all. I'm the IT manager at a secondary college in Australia and we have about 1500 students. I've been wanting to let students have passworded access to some databases, but manually entering 1500 account privileges is impossible to maintain. Is there any way to securely allow 1500 (untrustworthy) souls access to only their own records? I wish Filemaker had something like an account/password table which could contain thousands of users, encoded passwords, privileges etc. Regards nylon

I have a number of help layouts. They have graphical components so am unable to create them as simple text fields/records, rather there are a number of individually numbered layouts with the various help screens. All of the help screens are named HELP_#. I will be adding to them at anytime. Each one can be individually opened via the ? on screen with a go to layout (HELP_ + get(scriptparameter)) I am trying to create a script that will dynamically loop through all of the help layouts and print/append them to a pdf. Everything is working fine, with the exception that the go to layout step will not work. The calculation works fine (i.e HELP_02 should be the n…

Forgive me if this is self-evident or I've missed the answer trawling through the forum.... Is there any way to intercept the automated "Save changes to this record?" dialog in FMP9 to get it to trigger a script? Yes I know this would be easy in FMP10 with script triggers, but upgrading isn't an option currently. I need to be able to automatically record and track all changes/edits made to data in a database. Specifically, I need to: 1. Have a record of who has made a change 2. When they made it 3. What the change was.... I can set up a related table linked by the Record ID to create a new record when changes are made using a Commit Record script ste…

Does anyone know of any command line triggers that exist when executing filemaker? Is there a way for FM to read the command line?

Hi, I am half way there for a new script that I am doing. This part is where I am not figuring out how to do it. I have 2 tables that share a relationship 'by date". The main table has all the data in it and the other table I am needing to create a summary of all the data 'by date" and by item. The script for creating the new record and populating the data from one table to the other works well (with portals and such). However, in the main table, there are multiple records with the same item. What I was trying to figure out is how to automate is only create a record 'by date' and 'by item." That means if I have 25 pens, and 5 rulers, only 2 records would be created i…

Hello all, I have a field I imported from a SQL file. In each record it has text and a 5 digit number. INSERT INTO `zipcode` VALUES('00401' I would like to remove everything except the numbers. I have 42000 records. Anybody got any thoughts how this may be done. Thanks

Hi to all, i am trying to make a solution to monitor Aircraft maintenance.I am currently stuck.I want to take a record from my task list of a specific aircraft,and make a workorder list that generates an ID for the workorder(for the specific aircraft) for future indexing.So i need to get that record ,copy it to a different layout(workorder layout)put an ID and be able to print it.I was thinking that i might need another table but i am not sure if it will work as i want. Thanks

I have a check register DB with several layouts. One of these is the actual register where the transactions are entered and it keeps a running total. What I want to do is this. Each week when the bills are done, and hence new transactions have been entered since last week, I want it to send an email statement with the new transactions since the last statement was sent. In the register I have a field called EM and when a transaction is entered (hence a new record created) that field is auto-entered to be "N". This part of my script I have pretty well figured out. I have it start from the top and look for the first record with an N. I then want it to copy the…

Hi all. I am think I am close but I am stuck. I have spent 2 hours trying to figure this out and I am at my breaking point. I have text field with a timestamp in it. I want to do date math between that field and the current date. My result is a huge number though. Any help would be appreciated as always.I have attached 2 photos one of the script and one the debugger watching the values. Excuse all the work fields just trying to debug it.

This script (see attachment) runs from a button placed on each row of student records displayed in listview. The script logs the attendance for that student for that day. This script performs very well in a multi-user environment on FMS adv where all 40 clients are using FM9 (windows) as long as only one person is using the script and entering attendance. But when additional users try to enter attendance for their students there is a delay (hourglass) of 2-3 minutes until the script is complete and the listview redraws. Users are entering attendance for their own students so there are no instances where users are entering attendance for the same student. Is th…

I thought I read somewhere that Filemaker Pro 10 Advanced Server had the ability to run a script at a specific time? Does anyone know if this is possible? I did notice when creating scripts, in the bottom left "compability" box you can choose "Server" and see if a particular script-step is compatible with Server. I am hoping I can write a script that will run once a day at a specific time, without the need of having a client machine running. Anyone tried this?

I've got a client with an FM solution that's been developed over the past 12+ years. As such, all of their "tables" (or at least the primary ones) are stored across separate FM files because that used to be how you had to do it. Now the solutions is so big it's too complex to try and migrate everything into a single file, much to my chagrin. Anyway, I've got PayPal IPN working to automatically add orders into a MySQL database which I have connected in FM as an external sql source. Now I need to create an FM script to create an actual Invoice in their current system based off the IPN order data. The problem, though, is that because of how everything is stored …

Hello I have a scrip trigger to go to a field onobjectexit. But when I tab out of it goes to the first field on the layout not the field in the scrip. Anybody know what I'm doing wrong. Thanks

hi . if i have a layout that enter in the field how can i lock the filed that it can not me modified ? thank you DaniR

I want a script to put up a window in Preview mode, pause, and allow the user to either (a) proceed to a Print step, or (: cancel but allow the script to continue running. As far as I know, there is no way to put active buttons on a window in Preview mode. What I'm trying, then, is the following: Allow User Abort [On] /* Cause Cancel button to be shown */ Allow Error Capture [On] /* Let me handle errors */ Show/Hide Status Area [show] /* Display side bar and buttons */ Enter Preview Mode [] /* Show current layout in Preview mode */ Pause/Resume Script [indefinitely] /* Wait for user to click Continue or Cancel */ Set Variable [ $e…

I'm having a rather difficult tiime with a script that i am going to try to do my best to explain. When setting up my database, i used the notes feature that is found in the Contact Management example database so that i could actually have a database of all the "Notes". Recently, i have tried to implement a new feature into our notes that lets the user enter in the amount of "hours" they had on a particular note. The script that i wrote to add the note can be seen in Script.png image that is attached. That part has worked fine and dandy. Now, i am trying to create a report that is based on the amount of hours a user has entered which is where i am coming into a …

Hi! I have a database that collects a sound via a script (Insert file script step). The sound is created from another application. After insertion, it should be possible to listen to the file through filemaker for another user. I guess, since I used that script step, the file can not be recognized as a sound file in filemaker, because I can not listen to the file stored in that container field. If you insert a sound file manually via right-click and "Insert Sound File" it is possible to listen to the container field, but then you have to record it in filemaker... (You don't get to choose/calculate source file) I also tried the "insert object scrip…

hello all any one can help me in getting a message on screen after the event took 24 hours

Im having trouble with a script that involves calculating a month. I have a field called "Assigned" that contains a date. What i am trying to do is create a script of all records that were assigned 1 month ago, 2 months ago, 3 months ago. So far, i have been able to figure out how to get the current date and take the month to subtracy by one like so: Month (Get (CurrentDate)) - 1 Now if i were to set that calculation as a variable of lets say $1_Month, how would i tell the program that i want to see all records whose assigned dates meet the criteria of the current month - 1, which would be July? Thanks

Hello all -- I have a list of records (from TO1) in a found set (lets call FS1) and it has a date range specified. I want to loop thru FS1 and create a record for each day for each record in FS1 to a related TableOccurrence (lets call TO2). I have Lookup() functions dragging a majority of the fields from TO1 to TO2. If I did this on screen I have a hidden layout that I transfer FS1 to ... and this hidden layout has a portal to TO2 that will allow me to add a record and all the Lookups will fire populating 95% of the new TO2 record. I created the script based on the the above paragraph (and it doesn't seem to want to play nice). However, I don't even kn…

Hello folks I have a system that does xml exports and xslt transforms. Currently both the FMP database files and the xslt files live on a file share, primarily to make the file paths for the exports easier (it was developed in FMP 6 days I think). I'm converting the system to live on a FMS server, so I'm putting the XSLT files into container fields and using the Export Field Contents script step to put the file into the temp folder from where it can be referenced by the Export REcords script step. The xslt file is getting into the temporary folder and when I open it in TextEdit it looks OK, but the export records step is choking with error 717 (There is …

Hello everyone. This is disturbing.. I have a function that creates an alphanumeric 'id'. This id becomes part of a URL taking an attendee to their record online, to register for an event (custom web publishing, php). So, the same series of id's is being generated in several databases. I can reproduce this problem at will. It's like FM is deciding on some kind of pattern ahead of time. That's not random. We're all on Mac OS X 10.5, FMPro 9.03. Any ideas? Let ( [ string = Middle("ABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890123456789"; Int(Random* 46); 1) & Middle("ABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890123456789"; Int(Random* 46); 1) &…

Hello, I have 2 questions. I am writing a script that can change font, style, size...etc... so that someone can do that without having to use the quickformatting.. It will be a little bit more elaborate later, I am just getting the basics down. in the script, I "Inserted Calculated Result".. here is the calculation TextFont (TextSize ( TextStyleAdd ( ; "Plain Text"); 14); "Arial" ) Question 1: where it says: Right now I only know how to put a specific field there... what function could I put there, that would capture the field name I currently have selected? Question 2: I have seen the basic shortcut that your first 10 script…

I am very new at this sorry if this is a dumb question. I need a script that find and replaces whatever it is i have on my clipboard meaning whatever it is i just copied. so i create a new script then go to perform find and replace....then specify...then on find what i want to put there a calculation i would guess that tells it to find whatever it is i have on my clip board. Is this even possible? all help is appreciated.

Good afternoon! I have a database with about 10 related tables, and have created a script that works beautifully but requires the open and close of a related window - causing the subtle but obvious flash of a little window (I've made it as small as I can!). I've tried using Adjust(hide) but the script no longer works properly when I do and my main (non-active) window starts going places it's not supposed to. I'd be most grateful for any help on how to properly Adjust(hide) or how to "hide" windows that are active with running script". Thanks!

Is there a way to trigger a certain script depending on the value selected in a value list. I have a list of 6 value's, each value needs to trigger a different script. Any suggestions?

Hi, I am curious as to why the log file for ScriptMaster's installation on the server seems to be placed in one of my users' My Documents360 Plugin Logs folder instead of in the FileMaker ServerLogs folder. Is this possibly because I have both FileMaker Pro and FileMaker Server installed on the same machine? Could this be a cause of random crashes of 360Works's ScriptMaster, which happens on my machine, if the user's My Documents folder was unexpectedly deleted, which happens on my machine with Citrix Users? Warm regards, Yaacov Please help!

Hello All, I have made a script (A print out is attached) The print out only show the first couple of lines, but essentially it repeats for multiple markets and sub markets. Everything works, except that I can not set the import order. I have tried "last order", but that did not retain it. I did try that step while the script was running. I will try it from the file menu, but I doubt it will work. Has anyone ever run into this before? Prospect_script.pdf

HI, I have 2 tables, Work order table Designs Table I have a portal showing my records from my designs table. I have a field (in my work order), that will be used for users to put a number. Lets say that users put in a 5 in the field. I want my script to create 5 records in my portal (left side of the jpeg). what can i use in my script that can create 5 new records? Thanks

I hope I'm wrong about this and that someone has a solution that I haven't found... As far as I can tell, it's not possible to get a script trigger on an enterable field to execute when text is dragged into the field. Is that correct? If so, this means that to use 'OnObject' script triggers, developers will more than likely have to turn off Drag and Drop (under Preferences). Otherwise, a user can always circumvent an 'OnObject' script trigger by dragging text into the field. On validate calculations do still execute. The only way I can see around this is to either turn off drag drop altogether in Preferences or to use a plugin like DoScript. BTW.. even…

I installed 10 after having used 5 for years. I updated the scripts that the conversion didn't update completely, but now my send email scripts are crashing the program. I'm using "send via E-mail client", as I was before. I've attached jpgs of one of the scripts, with the details. The scripts crash when they get to the Send Mail command. Baffled. Can someone tell me what I'm doing wrong?

Microsoft Access has a great function called "Collect data by using e-mail messages". Is there a plugin that can give filemaker similar ability? (i.e. automatically read email and populate data or trigger a script)

In my multi-file system many of the files are related which seems to keep 'closed' files on the hidden window list. So the closed files are never really closed - merely hidden. I also use $$vars to track a users movements, but it seems that when a file is 'closed' (but retained open for related reasons) the $$vars persist, whereas I expect them to have cleared because the file was closed. (Back in pre FM7 the files did actually close and I used global fields to do the same tracking) This in turn makes a mess of my opening scripts which are relying on some of the $$vars. For instance there is a 'home page' layout for every file which is the one to go to if the fi…

Hi everyone, I have a question regarding identifying available IP addresses without having a table containing all possible IP addresses, and marking them taken or available. Suppose I have a subnet, 10.99.1.0/24 (meaning valid IPs would be 10.99.1.1-10.99.1.254 (.0 being network and .255 being the broadcast address - and hence not usable) and i have a table with the used IPs, containing: 10.99.1.10 10.99.1.12 19.99.1.14 How would I make a script that would present me with a valuelist with the values from 10.99.1.1 to 10.99.1.254 - excluding 10.99.1.10, 10.99.1.12 and 10.99.1.14? Hoping someone has a word of the wise. : Best regards, …

I have one file that prevents me from reordering the Scripts. If I try to move a Script to the top of the list, for example, it always reverts back to it's previous location in the list. This began to occur when one of the scripts would not comply with an attempt to delete it. I have Recovered the file, but that has had no affect.

Greetings; I have a field called "Product_description" and "Product_description_html". what i want to happen is when you type the following into the field "Product_description"; "FEATURES: Pg 20- EVAN FARMER- While You Were Out's handsome handyman host kisses and tells about his music, his 'underrobe' and his search for Mrs. Farmer. " to this in "Product_description_html"; "FEATURES: Pg 20- EVAN FARMER- While You Were Out's handsome handyman host kisses and tells about his music, his 'underrobe' and his search for Mrs. Farmer."

this seems extremely stupid. I created a script to send automatically an email to the current contact. It's evaluating whether it is Mr. or Ms etc. and then it inserts the text of a certain field as body of the email. My problem is: I need to insert a line break between "Dear Mr....." and the body text and I just can't work it out how to do it.

I have a database for my cabinetshop that uses different layouts for inputting dimensional information. For example: If you are inputting overall width for a drawer bank you are looking a picture of the drawer bank on the drawer bank layout. while you do this. Similarly, if the width data is for a sink base you are looking at a layout that just shows the sink base. The width information for all cabinets is posted a common master list layout. You can go there to see all of your cabinets in one place. Sometimes cabinet information needs to change. It would be handy to be able to see the original layout image again while making the changes. The maste…

Im trying ot create a script that will perform a find upon login but am not having any success. The field i am trying to perform the find on is a list of users which matches the usernames to login to the database so i am trying to perform a field using the Get(AccountName) funtion as the criteria but instead it performs a find on the text Get(AccountName). Is there a way to perform a find based on this variable? Ive added a screenshot of how the Find Request is setup

Is there a technique available to determine whether the current window is the only window open? I have a multiple window solution and I want to attach a script to the Close Window button which runs only if this is the only window in the current solution. Possible? Much appreciated.

Hello, Is there any way an event on one account triggers a script that would run on another user's machine? Basically I want to create something so if a user selects something from a box or checkbox it causes another account on another computer to perform a script.. why you ask? I want to make one computer and one account set up for email me stuff but I don't want the other users to know it's happening. I have it set up now so those emails are timed events through a combination of applescript and filemaker with mail rules in place. Any ideas?

Is there a difference, any difference in the world, between editing a record by clicking on modifiable fields and editing a record by running a script that uses nothing more than the "Open Record/Request" command? I have a problem with FileMaker crashing when I commit records in some of my layouts. It freezes, and if I force quit it and restore the file, I find that it has added thousands of empty records to the tables. But the thing is that this only happens if the way I first got into the record is when I have used the script. I reduced the script to one line, "Open Record/Request", and still the problem happens. It does not happen when I simply click in a modi…

Let([ Vals = ValueListItems(Get(FileName); "FieldSelection"); Pos = Position(Vals; "¶-¶All"; 1; 1)]; If(System::gSearchTarget = "All"; Left(Vals; Pos - 1); System::gSearchTarget) ) thank you dani

I'm having a foggy brain moment ... I have a text field that I would like to delete all the text in the first 18 lines, for over 7,000 records. The field contains a Product description, product ID, UPC and vendor record. I have each of these in separate fields. The text files were imported (originally Windows XP Notepad) as .txt files. Can someone point me in the right direction? Data example:

I have created an elaborate field export script that seems to work fine. It seemed a monumental task compared to this I now can't seem to figure out... I run into trouble trying to prepare the content for export - my steps are: Modify Last Find - this works and finds the records based on the field I want - which happens to be the first in the layout. I then want to sort the found records by my Date field in ascending order and when sort is done, go to the First record. Sadly, FM fails to perform the Sort at all. No Idea why. Sorting works manually and as a separate script - saving the criteria and choosing "perform without dialog" circumvents the dialo…

serial numbers and UI updates I have been looking at the various posts for this topic and have gotten to this point. Thank you to all. The serial numbers include a small amount of text at the beginning for identification. We need to parse out the number, add 1 and rebuild the correct serial number to insert. Below is what we have tried, but the problem is that the Left and Right steps (3rd & 4th lines below) are not getting the field values. They are instead, splitting the field name, ie. "OPTION" (left) and "ons_id" (right) The desired result should be: "optn00" (left) and "002378" (right) for "optn00002378" Go to Field [OPTIONS::k…

I built a data base for work and at the end of our shifts a button closes out the shift and prints the report, then runs a Re-Log In script for the next attendant. My problem is if a user chooses the cancel button it will log them in as the last user. I tried to use the Get [Last Message] with no luck. Is there a way to stop this?

So, I have done a massive amount of research, and have looked through most of these posts as well as other sites. I designed a database for my workplace and I'm running into some problems. My dilemma: I want to force a user to input further detailed information into the "other" field but only if someone checks the box "Animal" (Animal Complaint). This is something I'm doing for my workplace and the field keeps getting missed. I know about the IsEmpty script, but I don't want it all of the time. Could anyone help me get into the right direction? FYI, I'm pretty good with FileMaker Pro, but need baby steps when it comes to new scripts. Thank you in adva…

I only just noticed that the script step Go to Record/Request?page [Next, Exit after last] produces error 101 when it goes past the last record. Error 101 is "Record is missing", which I can quite understand, however it seems odd to produce an error for a valid result as it should just 'Exit after last'

I am trying to figure out how to restrict a field to a set amount of characters. I tried using the maximum number of character restriction but it still allows you to type more than I set, but it will not let you continue. I want the field not to let the user type more than the assign characters. Can anyone help :D