Script Workspace and Script Triggers

Hi, I have a list of clients in an excel spreadsheet, and I would like to batch edit a field in the file maker database based on that list of clients. I am a novice on FileMaker scripting, so here is what I've tried. I've tried using custom dialog to get input (thinking about copy-and-pasting here) from the spreadsheet, but I am not even sure if custom dialog supports multiple line of user inputs. I've tried using open file to grab the client key from the excel spreadsheet, but am not successful. I would appreciate it if someone could give me some directions on this. Thanks.

Hi all, I have a custom function that returns the layoutID. How do I have to write a navigation script to go to a given layout based on the ID of the layout, instead of the hard coded name of the layout. The Go to Layout function gives only two possibilities: Layout Name by calculation or Layout Number by calculation. TIA

Hello there, Is there a way to get the idle time? Sometimes I want to make a modification to the structure of a database, but can't because a user is still locking a record and he's away from his computer for a while. I would like to commit or revert the record when a user has left his computer for let say 10 minutes. I was thinking of a trick using a global variable, the modification timestamp and the "Install OnTimer Script". Thanks for any suggestion.

Ok, I'm a bit new at this, but here is what I am trying to accomplish: I have a database for my clients, I enter them in, and then I have layouts for a Cover Sheet, and a Contract, which I have a script that prints them. I want to have a field that stores "Contract Print Date", and then when I run that script to print the contract, it automatically fills in the field with the date or timestamp. Can someone provide some insight for me on this? Thank you.

Hi Everybody, I built a database for my patients a while ago on FM Pro 7. One of the fields on the main table was "Referred by" which recorded whether the patient was referred by a doctor, another patient or someone else (i.e. the milkman...). In order to achieve this the best way I found at the time was to use a free plugin called eventscript and fill the "referred by" field using a calculation If(Referred by type="Doctor"; S4HU_EventScript(Get(FileName); "Referred by doctor";""); If(Referred by type="Other patient"; S4HU_EventScript(Get(FileName);"Referred by patient";""); If(Referred by type="Other"; S4HU_EventScript(Get(FileName);"Referre…

One click etimate to invoice. i also have an invoice form that i want to auto fill from the estimate/order form. I have a order form, that has a status fields radio (qoute, invoice). when this qoute turns into an invoice I would like it to auto create an invoice. my line items are in a portal. Thanks in advance

I have 2 tables: Members Dues Members <-->> Dues A layout based on Members has Members data on the top 1/2 and DUES::portal on the bottom 1/2. I am trying to determine if using GET(RECORDID) return me to a specific portal row that, after it is sorted gets rearranged according to sort order. For Example: 2000 2001 2010 1999 Let's say I just entered 2002 at the bottom, blank row in the portal. I am trying to identify the 2002 row, then sort the column and then find the 2002 row again. I have written a script using Get(RecordID)but after it is run, it seems to find the recordID of MEMBERS (Not DUES???) and the go to Field ta…

In the Define Fields Options Auto Enter - Serial Number Dialog Box, you can assign a number, such as 1. Let's say you have an "x" amount of records, and you want to delete all, and reimport a new set of records. Is there a way to programically reset that field option back to 1, so the newly imported records start with a value of 1? I know its unorthodox way of doing things, however, it needs to be done somehow. Can anyone help? Thanks in advance, Habitude

Looking for a script to copy number of records from one table to another table based on a find condition.

I've tried with little success to copy portal content into a text file. The DB works perfectly but I cannot do this. The portal content is all text and consists of related files running in a portal. As stated before, the system works without issue. I have tried various looping scripts to no success (I am no scripting monster in any way whatsoever. ) that look similar to this. I know I am doing something wrong here as this contributed script looks fine to me but what do I know. Go to Related Records, in a new window, show related only. Loop .. Set Variable [$PortalContents; $PortalContents & Left ("¶"; Length ($PortalContents)) & PortalTable::Field X] ..…

If I have a field that contains values such as: 01 08 14 22 Q Can I write a script step such as 'Insert Calculated result' that will remove the 'Q' from this field and leave the other numbers in the field? There can different numbers in different quantities separated by a space. If it helps the 'Q' will always be the last value in the field. I was thinking one of the following functions such as PatternCount, Replace or Substitute may help.

How can you run a script to copy the contents of one field, then open another database, perform a find where it would paste the copied contents to one field. I'm trying to use Copy [select; work order:::Order#] Open file [invoicing] Perform find ? Paste [here's where I have the problem]

Hi, I need to constrain the found set after the user has performed a find, depending on the value of a global. Let´s say for instance that I have a database of cities, and before entering into find mode, the user enters "NY" the global. If the user afterwards goes to find mode, I would need the user to be able do a search with whatever criteria they want, perform the find, and afterwards (using a script trigger), constrain the found set to show only the cities belonging to the state of NY (as entered in global). The problem I have now is that I have created the constrain find script (to the value of the global), but if I choose to trigger it as "On Mode Enter [brows…

Im having a bit of difficulty with a project i am working on. I've taken a spreadsheet with variouls fields in it and have created a new database based on the spreadsheet. One of the fields is PointerToSource and contains the path to the image that i would like to insert into my container field (field name is image) I've setup the following script: Set Variable [$file; Value:test_import::PointertoSource] Go to Field [test_import::image] Insert Picture ["imagewin:/$file"] When i run this script, i am presented with the following error: The File (path to the file) could not be found and is required to complete this operation. The path…

Hey guys, I know this is a real newbie question, but I just can't figure it out. I have a loop script that runs when you go to a new layout, but once the script finishes it dumps me on the last record. What can I add to the script to make it return to the record that was being browsed? I think the key is using a "set variable" step on the record ID is in there somewhere, but have not been able to get that to work either. Thanks

In the database I'm making I have "modal" windows for creating new things (new events, new users, new teams). The scripts that launch these modal windows have a "Pause loop" that only exits if it gets a script result of 0: Loop Pause/Resume Script[indefinitely] Exit Loop If[Get (ScriptResult) = 0] End Loop Now the problem I'm running into is that sometimes filemaker will ask the user if they want to revert a record or if they want to save with its own default dialogue. When this happens sometimes the "New <thing>" window will close and the user will be stuck inside the pause loop of the creation script because the save/cancel buttons which r…

Hey guys, I need a little help to get me pointed in the right direction. I have a flat database which is basically a questionnaire. Next to each question, I have a checkbox. I'm trying to figure out a script that would add fields, if they are checked, to a "output" form that can then be printed and omit the fields that are not checked. Any ideas? Thanks

Have a long script. I would like to change every line to set a field as 2 instead of 1. Is there a way to do this without clicking the specify button 50 times?

Hi, With a button-click, i want to go to a specific layout. If there isn't a window open with this layout, it should open the layout in a new window. If this layout is already open, it should just bring the appropriate window to the front. FYI: i'm using multiple files in my application Sounds basic ... but can nevertheless not get my arms around this ( Anybody who knows how to do this? Thx,

I know this is really basic for most of you out there but being a newbee any help would be appreciated. I decided to check my script with script debugger and I get this error popping up Error Code "101" which is record is missing. I have included the script that I am running to go with this: Sort Records (Restore; No dialog) Go to Record/Request/Page (First) Loop Duplicate Record/Request Go to Record/Request/Page (Next; Exist after last) End loop Then I get error 101? Also what is happening is a global field set to 2000 as per all the records changes to the current year. Not sure how or why this happens? Anyone????

Hi to all! Does anyone know if it is possible via scripting first to generate a filelist in a directory(with or without subdirectories), and then use this list to create and populate a table? From what I am slightly aware of, it can be done in terms of VBA and Access (hmm, that's the enemy right? - yuk). Is there any solution for FM?

This Filemaker message, "This record cannot be modified in this window because it is already being modified in a different window.", has made an appearance in my MarinaPro Dockage Management Solution, but only in the FMP10 upgrade version, not the FMP5.5 version that has been in use for several years. As example, it pops up when I try to make an update entry in the "General Comments" text field, which is a relationship (Cust::Cust.fp7) field. Once I exit this reservations file (Resva.fp7) and come back to it, I can make changes that are reflected in the Cust.fp7 file as per normal. Anyone know whats happening here, and how to correct it?

I have a received a database from a colleague created in Filemaker 11. Scriptmaker contains hundreds of scripts that create sets of records. Strange thing is when I click on the drop down script menu and click on an item, a certain set of records are created every time even though they belong to a different script. Some scripts create the correct set of records but the majority always create the same set of records even though the scripts are very different. If I go into scriptmaker itself and then run a script, they all work fine.

How can you determine if a user is connected to a FMP database on his/her local computer or is connected via a LAN or WAN? The reason I ask is because I want to develop an Install On Timer script for a backup script (Save Copy As...) Since this script step is only valid on the computer hosting the database, I need this On Timer script to only run on the computer hosting the database. Make sense? I know this step is not valid when using FMP Server and I have a way of knowing if that is the case or not. I'm sure there is a simple Get function but I seem to be brain dead when looking for it. Thanks, Will

Hope I can explain this one. In general I have students that eat lunch. There are 3 categories, A, B, and C. There are 30 classes. There are a number of dates per month per schoold year. I need to gather the number of students in each class, for each day of the month, for each category. For example, class 01 for 1/1/1011 had 10 A lunches, 20 B lunches and 30 C lunches.Then it's done again for the next school day in January. After all dates for class 01 are used, we go to class 02 for the same thing. So I created a lunch database that has a table of classes - all are classes, like 01, 02, 11, etc. A table of all the days for each month that we have school. That table has…

Hi all, I'm setting up a database for a department with many groups, and most use FMP 7, so any solution I come up with has to work with 7. There are two more problems I could use a hand with, so please bear with me: 1) When searching through the database the user should be able to select if he wants to search the whole database, or just the entries from his group. How would I do that best? 2) When entering location data for equipment the user sets the group name in one popup box - and then he should only see the locations accessible to his group. How would I change the value list depending on what another value list has selected? Thanks for any …

Hi Guys, I have parent file which is related to a child table. The child table has a number of fields but I’m interested in getting the content from the two fields and putting the values into a field which is in the parent table. I thought I could use the list(child::fieldname) function which works, but theres an added twist. The twist is I want to merge duplicate portal entries into one, and that includes the price so for example here: Portal record says Item | Price Red | 20 Blue | 10 Red |20 Red | 20 Green | 40 However I want to store the following in a field within the parent record: Red 60 Blue 10 Green 40 Hope that makes sense?…

I have a "People" table and a related "Status Log Entries" table. On the People table is a button to create a Log Entry record for that person. How do I script it to get the Person's ID# into the Log Entry record without using copy/paste?

How can I navigate to desired "Client" record in a pre-existing pop-out window already displaying a different Client? I have a script (ClientDetail) that opens a new window to view detailed Client information. I'm allowing User to keep this new window open, leave in background and continue using solution how ever desired. Sense this is allowed, I have worked into the script to check if a pre-existing window is open and if there is, then select it vrs. open another window. So I got it to select pre-existing window ok, I just don't know how to navigate to the Client record User want to view. Typically I use [go to related record] but in this case the relation is …

I would like to set up a trigger of sorts to send an email for any record in the database that is based on an upcoming event date where the event date is less than 2 weeks away from a stored target completion date. I understand the logic needed (I have conditional formatting set up already to visually highlight the date), but is there a simple way to do this per record check (aside from looping through all the records to check this condition)? Hope I explained this OK.... Thanks -

FOR IMMEDIATE RELEASE San Diego, CA – February 1st, 2011 - Productive Computing, Inc., a Platinum member of the FileMaker Business Alliance, today announced the release of the Biometric Fingerprint Reader Plug-in for FileMaker Pro. The Biometric Fingerprint Reader plug-in allows for fast identification and secure verification capabilities that enable your FileMaker Pro scripts to recognize individual users without requiring passwords or card swipes. This technology can be used to recognize and authenticate individuals based on who they are, instead of what they know (passwords or PINs) or what they possess (keys or swipe cards). It does not replace the built-i…

In our database, we have a fied that determines when our client is paid through, field name is SW PD 2. Once the paid through date comes up, the client is also given a one month grace period which if they do not pay by that time, they are marked as off maintenance. We also have a check box that will override everything and put a client as off maintenance (last script step) This is my current script that runs on record load: If [ (TechSupport::SW PD 2 < Get ( CurrentDate))and (Get ( CurrentDate) < TechSupport::SW PD 2 + 31) ] Set Field [ TechSupport::Maint_Status; "GRACE PERIOD!" ] Commit Records/Requests [ Skip data entry validation; No dialog ]…

Now this should be easy, but I can not figure out a work around. Here is the simple problem, I need to have a simple script that sorts, BUT I do not want all fields from the table displayed. If you do sort manually, you have the option of using only the current layouts fields, but this is not available in the script step. Any ideas?

Hi, I really need your help. I am very new to filemaker and no programming experience. I just want to make a history page i.e. I want to copy the current value from 2 fields in a record and save it somewhere (into a new related table) with a click of a button, before changing/updating their value. it's like, if i click that button, it will copy from Table1(field1 and field2) and create new record at Table2, paste to field1b and field2b. I am using filemaker 11 by the way.. I hope you all understand what I mean. I know this should be easy for you guys.. Thanks

What is your recommendation? Is there a FMP function I can use to open a video file with VLC or it would be better for me to write a quick Applescript program ? Thanks! Daniel

FM 11 Adv. Is it possible to use a lookup table in FM? Similar to the way Excel can do it. That is, how can I store a table of data (say for example Fruit and Color). When I enter apple in a fruit field, FM enters the table, finds the corresponding red, and inserts into the field color. Of course this can be done the logical case or choose functions, or perhaps with value lists, but both are cumbersome to setup and maintain.

Hello guys, I have a question i got two Tables 1. Want to sign out 2. Signed out With the function i want that if Want to sign out = Yes and its the month ( 1 ) then the field Signed out need to be YES but if its not Month ( 1 ) then it need to be still remain at NO Can some one help me i am going to be crazy Here a screenshot http://webdisk.planet.nl/dalga000/publiek/album/functiefout.jpg

If i get a filed with the data "hello.how.are.you" how can I replace the text to "hello\how\are\you" Thank you Dani

I have a record that has 5 lines in it . example "line 1 line 2 line 3 line 4 line 5" Is there away that i can break it down in to five records. (the problem is the i get the above record from a external source and i have to break it down) thanks Dani

Hi folks ... after 5 hours of solid head beating, googling, experimenting and no luck ... I turn here. I have a script that works well when fired manually. But if I try to use it as a layout script trigger it loops. I understand why (I think) but I can't devise a work around. Here's the background. - I have two tables (Clubs and People) - records in each table contain geocode information (latitude/longitude) - I can run a script that determines the Person's location and can then calculate a secondary set of latitudes and longitudes that represents a 50 mile radius. (ie if latitude was 10.0 and I calculate latitude-variation and latitude+vari…

We are sending data from filemaker to sage using some scripts. We have found that the process breaks if there is no company name defined when posting. I would therefore like to alter the script so that on posting it checks to make sure there is a company name and if not instead sends the Firstname and Surname as the company name. Our current script: SET FIELD [sage::accountname; MD::CompanyName] What I would like: SET FIELD [sage::accountname; Then the second part defined by an if test(which I am not sure if it is right - hence the question): If ( MD::CompanyName; MD::CompanyName; MD::FirstName MD::Surname ) So I am trying to say if companyname i…

Banging my head on this one. Here is what I got going: I've set up a document management database for all of our service documents (close to 5000+), most are in pdf format. I have a container for the file, stored as a reference (so the end user can double click to open), and also have a global container to temporarily store the the same file without reference. Between FM scripts, applescripts, and automator I now trigger the script to insert into container 1 as a reference and that triggers an insert script to the global container which then exports it to a watch folder were automator extracts text, saves as a text file in another folder, then text edit opens and co…

I am attaching a picture of what I am trying to do. I would like to know if this possible to do this or not in FMP. I would like to browse through pictures in two different ways. The first way, one picture at a time using control buttons. This functionality I can implement without any problems. The second ways is by using a table view inside a tab. I have been able to Display records from a related tables in a layout. Unfortunately when I click on a row the appropriate picture does not show. As you can see in the attached document. I've put aside a box for where the picture is to be displayed. Is it possible to have a Table view inside a Tab showing r…

At the moment in order to make a multi key of the PK's in a current found set I make a script that loops through the records and add's their PK to a vartiable. Is there a more efficient way of doing this? i just like avoiding using a script if I dont have to.

I have a number of repeating fields (90) each with a concentration in (Field name = %) (number). I am trying to add an additional repeating field of 90 alongside which is a calculation of some variables. I have created a new field called SED as a calulation and then added the following where '%' is the value in each the repeating field already there and Retention factor and Total Amount applied per day are values from fields in that record. My intention is to calulate a new figure (title- SED) for each of the 90 repeating fields of concentration (%) Retention factor * Total Amount applied per day*%/6000 This works but I only get the first figure from t eh 1st r…

Hi I am working on a database and need some help with some field logic I have created one field that links to one database and I also have another field on the same layout linking to a different database. Each database holds slightly different information but related to the same variables/title. Quite simply, 'Field 1' consists of names 'category 1' to cat 11. Field 2 also utilises names category 1 to 11 but links to a different database. I would like to set a script or something such that if 'field 1 = category one' then category 1 is automatically input into field 2, same for cat 2, cat 3 etc, etc... triggering what it needs to in this field and…

I have a small db where we track our inventory movement. When our inventory team scans a serial number it will autofill the model number for them. I am looking for a way to add a model in a separate table if that model does not already exist. I have two tables currently. First table is Inventory (our main data entry table) and the second table is Model Numbers (where we track model numbers and their matching serial numbers). Is there a way, upon leaving the serial number field, if the model is not found to open a custom message that ask if they would like to add that model. If they choose yes, open the second layout, create the new model record, save it, th…

I am trying to write a script which would do a query joining two table together: Find all records in CustomerOrder table where field CustomerOrder:Status is equal to "C" Find all records in Picture table where Order:Status is not equal to "S" !!! Find all selected records in CustomerOrder table and all selected records or Picure table where field CustomerOrder:OrderNo is equal to field Picture:PictNo Set field CustomerOrder:Status to "R" Set field Picture:Status to "S" Show all records of CustomerOrder table where CustomerOrder:Status has changed I am quite familiar with MS-Access and Oracle SQL and would be able to do this query quite easi…

Hi. I have an issue that I cannot resolve and was wondering if somebody could please point me in the right direction. I will give you the cut-down, but relevant version. I have a table. It has two fields, "group", and "amount". For example: Group Amount ------------------ Apple 15 Apple 21 Banana 4 Carrot 45 Carrot 22 Eggplant 6 I am trying to create a script that will summarise these and put them into a global text variable that looks like this Apple 36 Banana 4 Carrot 67 Eggplant 6 The actual formatting of the text field I can do, but am having problems with the _logic_ in crea…

There must be a way for fm pro to call an AppleScript that will open a new email in outlook 11 use the address from fm pro and then let me fill in the message body. I don't know any applescript

Hi All, I want to close a related file using the Close File script step. When I try just simply calling it from a script I get error 13 - File in use. Thinking that the problem might be caused a field from the related file appearing on the current layout, I made a blank layout and ran the script from there. Still no dice. I tried creating a script in the related file that called Close File (Current File) and triggered it from the original file but still no joy. Any ideas?

This is complicated for me - but I have really tried to think this through. I am obviously lacking the knowledge of one or more fundamental techniques to accomplish what I am trying to do. I will try to do my best to describe the problem. In one table… 3 simple text fields for data entry: given_name middle_name family_name 1 calculation field (stored): uses the List ( ) function - the three fields above are the parameters 1 text field for data selection using a drop-down list: Created a self-join and value-list based on self-join to display the results of the List ( ) function just above. Up to this point - I can get it to work to a poi…

I have several unrelated FM files that I am using at work. I have set up several new fields some with calculations that only affect or use the other new fields that I am adding. Is there any way to take this new group of fields and copy them to complete separate and unrelated files without starting over and duplicating efforts.

I'm tearing my hair out but I hope this will be simple. I have a layout with a filtered "DISPLAY" portal on it set up to show field data from the record selected in a nearby "SELECT" portal. Works fine. I have a "Delete" button on the "Select" portal row that runs a privilege test and then deletes the portal row if the test passes. My problem is that when the script ends, the "Display" portal persists in displaying the data from the deleted record. I've tried having the script "Go To" the first or last portal row in the 'Select' portal, which I'd hope would trigger the Script Trigger assigned to that portal that re-sets a variable that in turn defines the filte…

I've looked at supplied at standard FileMaker script was when all of this started provided by BruceR I've looked at the template files and their scripts I've searched onto the web on that specific topic and I've tried many time and cannot figure it out. I have the a CustomerOrder table and want to get counts by grouping information together, For example, I have the following table: CustomerOrder InvoiceNo, IndexNo, OrderNo, Status 123456 1 0101 Photographed 123456 1 0102 Photographed 123456 1 2012 Ordered 123456 2 0301 Photographed 123456 2 0405 Ordered 123456 2 0512 Ordered 123456 2 0701 Ordered 123455 1 0104 Photographed 123455 1 020…

I've created a button "Burn DVD" when I click this the script down below is being executed. If I run this code as an Applescript application everything works perfectly. However, when being executing within FMP by clicking the "Burn DVD" button, I get the error message "Cannot find the record". The problem seems to be with the statements : tell (every record whose cell "N°Invoice" is NoInvoice and cell "SN°Order" is Index Order) set filteredRecords to every record whose cell "N°Invoice" is NoInvoice and cell "SN°Order" is Index Order What could be the problem ? Or is there a way within FMP to run an application inside FMP with arguments? M…

Is there a way to search across scripts for specific strings, subroutines, tables or fields? I am in the script window but all I can seem to do is "find" a string in the script title.

Happy New Year Everyone! I'm using Filemaker 11 Advanced on MacOSX 10.5.8. My Filemaker solution includes the need store files within the database as well as view them. Primarily JPEG, PDF, and QUICKTIME files. JPEG is easy, just insert as picture. PDF can insert as picture, but then you can only see first page and I need to see all pages. The only way to do this is insert as quicktime, which allows the controller to be used to navigate pages. This method however does not allow storing the file within the database, you can only reference. The only method I have came across to both store and view these files within a solution involves creating a group…

OK here is my problem: I am working on a Database that is basically a CRM. I use the Database to consolidate all of my contacts from various reports and sources. (all Excell format importable) The problem is, all of my reports I import from handle phone numbers differently. One report says: "8885551212" another says; "888-555-1212" (which is the way I would like them ALL to read)another does (888) 555-1212 and yet another does "888 555 1212" since there really is no set way the number comes in, formatting is a PITA. PLEASE HELP. I would like the format to be 888-555-1212, keep in mind I have over 5000 records in the CRM so far and import 10-20 leads daily. I ha…

All of a sudden I’m having a few problems managing scripts in the Scriptmanager I’ve got a bunch of scripts that are not in any folders, and until recently it let me change the order that they were viewed in the Scriptmanager Screen. Now suddenly it won’t let me change the order freely. It’s not displaying them in creation date order. It’s not displaying them in alpha order. I can’t see a logic to how it is displaying them, but there is a logic there. I know this because it will let me move some of the older scripts, but only within a limited area of the list. But the parameters of the area I can move them around in makes no sense to me. What I do …

I want to execute script and do not want any record type windows to appear during and after execution. Records are to be updated using that script and the out result would be updating the the count of a field showing in one of the tabs window. The execution is then process in the background

Hey all, Once again I'm coming to the forums for some much needed help. I'm working on implementing a label skipping script for the 5 different print layouts our small business uses, but I'm having trouble adapting the two solutions I've found into my database. I think I've decided which one would be a better fit to our database design. To give you some background, I have almost a decade of experience in IT so I understand how things work generally but I'm as green as they come when it comes to developing in FileMaker. I was hoping someone could give me some direction for the "virtual list" concept and specifically the file that Ocean West graciously provided. I…

my goal is to make script that creates a new job number(record) which is made up of the following information... month, year, then a rolling number starting at 001. I'd like the rolling number to begin 001 on the first of every month and reset back to 001 on the first day of the next month. so if it started today, my number would be 111001. If we did 200 jobs this month, then my job numbers for January would be 111001 - 111200. On the first day of February, the script would automatically change to 211001. Thank you in advance for any help in creating such a script. Rob Hunt

Hello all, I've been building a contact database for my company, based off of the "Contact Management" Starter Solution in FM10 for awhile now. We've got just under 6000 contacts, many who share the same company as other contacts within the database. Currently, I'm trying to generate four or five digit Client ID's for each company represented. Is there a way to create a script, so that every contact with the same company gets the same ID code, but if the "Company" field is different, a different ID is generated? Hope that makes sense, please let me know if any clarification is needed. Thanks for reading!

Are subscripts covered by the Allow User Abort [Off] in the calling script? -- or does each script have to protect itself? The Help File simply says "FMP automatically turns Allow User Abort on after the script finishes running". Which script? Does anyone happen to have experience with this in order to provide a definitive answer? Thanks in advance.

Have been searching on FM Forums but can't find what I'm after. I'm using a DB with a lot of documents in it and are using a single button to open the relevent document when I want to view it. Currently the script is: If [Documents::Name = "Doc1" Open File ["Doc1"] Else If [Documents::Name = "Doc2" Open File ["Doc2"] Else If [Documents::Name = "Doc3" Open File ["Doc3"] End If With 200 plus documents it's going to be a very long script! Many Thanks

Hey all, the calculation below allows the text string "END" to stay in position 12. Am I blind or is there a function that does this already? That is constrain a string to a fixed number of spaces. Let ( [ value = 888 ; gap = " " ; <-- SHOULD HAVE 19 SPACE string = value & gap ] ; Trim ( Replace ( string ; 16 - Length ( value ) ; 1 ; "END" ) ) )

I've created the script down below to input record in a table called InvoiceOrder using a return-separated list of code. The script is looping through the entire list and is creating required records in the InvoiceOrder table. However, there is always a none required empty record which gets added at the end of the table. I do not know why, could someone tell what I've done wrong with this script? Best regards! Daniel Go to Related Record [From table: “CustomerOrder”;Using layout <Current Layout>] Set Variable [ListArray1; Value:Substitute ( TrimAll ( Order1 & " "; 0 ; 0 ) ; " " ; ¶ )] Set variable [$InvoiceNo;Value:Custome…

What is the best way to prevent user interaction with FMP while a script runs? Predictably my users don't pay any attention to any sort of prompts or warning messages that I plaster about their screens when a particular script is running in the background and this results in the script exiting abnormally and them having to force quit and restart FMP. Even after being told multiple times not to touch anything while the script runs I still run into this problem daily. So, what is the best way to prevent someone from doing ANYTHING in Filemaker until a script has been completed?

I've got a few scripts with print steps in them. Generally, they print from the same printer at work but occasionally I (and other users) want to use them to print things at home. Also, there are two different printers used at work, and occasionally it would be nice for a computer to print to a specific printer rather than a script printing to a specific printer. However, if I specify print options, it seems the printer gets hardcoded into the script step such that I'd have to edit the script in the event I need to use a different printer. This doesn't seem very user-friendly. I feel like there must be something obvious I'm missing here. Does FileMaker just not do t…

OK, I am now jumping in using FM native functions. First one, verify for length of field work and second one for specified characters does not work. Can someone tell me why? Best regards! Daniel Manage database Go to Field Select field "Order1" + Options + Validation + Validated by calculation + specify SPECIFY CALCULATION WINDOW Validation for field "Order1"= Length (Order1) = 4 or Length (Order1) = 9 or Length (Order1) =14 .... THIS CALCULATED FUNCTION WORKS FINE Manage database Go to Field Select field "Order2" + Options + Validation + Validated by calculation + specify SPECIFY CALCULATION WINDOW Validat…

At Devcon somebody made a clever offhand suggestion about using a Script Trigger to sort of hijack the built-oin ListView button on the status bar to take the user to a custom-made List View layout. I've tried this out, and it works well for its purpose - - - but I've discovered that it appears I have to sacrifice the ability to use Table View on the original layout as a result -- since the script trigger is "OnViewChange" -- not, specifically, "OnLISTViewChange." It seems I have to disable Table View for the layout in order to avoid being whsked off to the other layout when a user clicks on it. Is there an angle I'm not quite getting here? It seems it should be …

Hi, I've been trying to use a script trigger attached to the last data entry field on a layout to jump to the next layout in a series and the script is behaving strangely and I thought I might ask the forum for some advice. I have the following script attached to the (second) layout (that normally runs without any problems on layout enter) which sets some variables and then goes to the first field on the layout Set Variable [ $$Current Measure; Value:If ..... Set Variable [ $$Measure Context; Value:If ( PatternCount..... Set Variable [ $$Measure Timepoint; Value:Neuropsych Sessions::pfk_Administration Timepoint ] Set Variable [ $$Measure Session; Va…

Hello, I am new in writing Script within FileMaker Pro. Over the last two years I have been writing applescripts modules to performs specific functions. I want to have a more structure and robust environment. I am then moving into FileMaker Pro. I am attaching down below an applescript program I want to recode in FileMaker Pro. However, I do not know about the FileMaker Pro scripting syntax I should be using. The idea, is that the operator is writing code order information into a specific line (Line1, Line2, Line3 and Line4). Each code is 4 characters long and is separated by a blank. For each of the code I want a record to be added in a FileMaker Pro table cal…

First off, this is my first post in the forums and I hope I got this under the right category. Here's the scenario - I'm setting up a login script that 1. checks if the person is logging in as a guest or registered user then 2. checks what the registered users access privileges are and finally 3. finds all of only that users records and switches to a specific layout. It works fine with one exception, when a registered user hasn't yet created a record it shows the "No Records" found message prompting them to Continue or Modify Find. Niether of which is what I want. What I'm trying to do is send a first time user to a page that explains how to use the solution a…

I have this idea I want to implement in our database, to include a tab in a tab control object that has restricted access, allowing only users in an administrative or developer permission set to go to the tab. So far I have added an OnObjectModify script trigger to the tab control that passes in as a parameter Get (ActiveLayoutObjectName), presumably passing in the name of the current tab before the tab switching action executes. Then in the script I'm able to identify the user permissions and selectively post a custom dialog informing restricted users they do not have access. I do this by naming the dev tab "dev_fields" and then using an If GetLayoutObje…

I'm trying to find the best way to keep a set of newly created records the focus of future actions. The particulars: I have a database tracking rental properties in our city. The inspector needs to send a batch of letters regarding properties that are due an inspection. The inspector will add anywhere from 1 to a few hundred new letters at a given time, and then need to view and print just those letters. I have a script that successfully creates a new batch of letters from the current found set, and creates these child records in a seperate table, referenced by the key "license #." Each letter has a serial #. It seems like I could approach this with a v…

This script basically worked with a repeating panel... Since then i have changed from a repeating panel to a portal How can I make this work with PORTAL ROWS. All this does is simply copies a value from FIELD_A and puts it in FIELD_B if a the value in FIELD_C is =>1 This is a loop script so it stops coping the value if FIELD_C is Empty or has a 0. Any help would be great. Thanks Jay. script_copy.zip

Hi Guys, Please see the script attached, it seems to ignore the inset file part of the script, leaving the field blank (which is a container field). Any help with this one will be greatly received. Cheers, Dan

Hi! I've made a database where whenever a product is finished, it's put into the database. I have a search script that can find all finished products for the current day. What I need is a script that can find records based on the customer, and then combine text from those records into one single email and sendt it. What I have so far is a script that finds all records, and sends one mail per finished product, but this can result in customers getting 10+ mails in a day. Is this at all possible? Thanks!

Hello, I'm new to filemaker and am trying to understand the capabilities. I'm an experienced developer, but see using filemaker as a way to jump start some database projects for my client. I have a scenario that I can't figure out how to approach it in filemaker. I have a 1 to many relationship between a person and daily activities. Each day, the client wants to be able to log daily entries for people. this part is obviously easy in filemaker. They also want to be able to batch add records for daily entries. For example, select 3 people and log and actvitity to tie to each one like I pick Jill,joe,James and log a running activity for today. This would allow…

I want to be able to create personlized emails for found sets. So for example if I run a search on 10000 contacts and come up with a group of say 2000 people how can I create an email that sends to all email addresses and insert the persons first and last name in the email when it sends. Thanks! Erik

I have 9500 contacts and some are duplicates. However the records are not complete duplicates of eachother. Some may be duplicates but all the fields in each record are not the same. For example I might have a john smith with an address and email address and other information and there may be a duplicate of him as john smith with all the same information as well as a date of birth. I would want to keep the record that has his date of birth because it contains more information and is therefore a more valuable record and thus the one to keep. The problem comes when I need to find which duplicate I want to keep. Is there some sort of script or module that can identify duplic…

I'm trying to do something that seems like it might be pretty common and ought to be fairly simple. Let's say I have a Table called Artworks and another Table called Keywords, which holds 1000's of records, a big lexicon of Art terms. I'm building a system where I can tag various artworks with any number of keywords. The tags will be kept in a join table between Artworks and Keywords. So, I would like to have a little textbox where the user can begin typing a keyword, and in a portal underneath, the Keywords beginning with the typed characters are displayed, and this list will get smaller as the user types. For instance, if the user types "pa" the filter…

Hi when using the perform script step within an existing script, is it possible to select the new script to perform dynamically via a variable? My thinking is as follows:- My initial script sets variables and calls various dialog boxes:- I then plan to have various different scripts set up for the various reports I need to export so if $$Variable=1 then perform script1 $$Variable=2 then perform script2 Regards Dave

I'm running into a brick wall on this one. I can't seem to find the solution. I have a FM Pro file with a few thousand records. Each record has a container field. And over the past few years I've been putting PDF files into those container fields. But now I don't want to store the file directly into that FM file. I want to keep the PDF files and the Apple pages files that I've put into those containers in a separate folder in my Finder directory. So, I'm trying to write a script that will loop through my records and export each container file (there's only one per record) into an empty folder that I've stored on my desktop. Each file to be exported has a unique name so I…

I have a table of contacts and also a table of donations. The donations table has over 20000 donations from all the different contacts. Each donations is stored by amount, date, event, and matched by a contact ID. I created a search in my contacts table that will search for donations based upon a date range and donation amount range. The results after running the search show a group of contacts that match the results and each contact has a portal. The problem is that each contacts portal after running the search does not show only the donations that are within the date and amount range. It shows all of them. So for example I can search for a group of people. Then i can en…

I have a portal that shows donations for different contacts. If i am on a contact i can go to their donations log and see a portal that shows all donations and pledges made by that contacts in list format on the portal and it tallys up the total and displays the sum at the top of the page. I want to be able to have a checkbox that i can select that will either show the pledges by that contact and include them in the portal and donations total or not. In other words if I click the checkbox that say shows pledges. The portal will also show the pledges as well as the donations and the total for thier donations will include the pledges. If i uncheck that box the pledges will …

Hi I Have a script which exports a layout(Report) to a pdf file, and within the script I am using the set variable function to generate the file path of the exported file. If I type in the file path manually all works fine:- "filewin:/C:/Keibudo Karate/Reports/Grading History Reports/" & Students::c_Student Name & " " & Get ( LayoutName ) & ".pdf" I have also created a separate table which I will use to set up the database default file locations, however when I use the following in the script it doesn't work:- conf_File Locations::cGrading Reports & Students::c_Student Name & " " & Get ( LayoutName ) & ".pdf" …

I have a donations portal that shows donations amount date and event. Some of these donations in the portal are actually pledges. I want to be able to have a checkbox that will hide the pledges if I do not want to see them. Also there is a field that sums up all the donations and pledges. If the pledges are hidden i want the field that calculates the total to not take those into account. How do i do this? I do not know how to set up the portal so It can either show the donations and pledges or just the donations by itself and i also do not know how to make the field calculate only the records being shown in the portal. Thanks! Erik

I have a FMP 10 Advanced database that links to audio files and video files by reference. I have written a script that calculates the file names in a found set and plays the audio file in the current record, advances to the next record, plays the audio file, advances to the next record, without the user having to mouse anything. Works as desired. However, I'm having problem with the video files. I want it to play the audio file (this works) and then play the video file and advance to the next record. But... after playing the audio file, it opens Quicktime and loads the video file, even though the video file reference is embedded in the record and …

I have 42 students and everyday a record is created for each in an attendance table. Each record collects the student ID, day, month, year and attendance status. How can I create a loop that will search for the "begin date" to the "end date" of the month (X) for each student? I appreciate any ideas Thanks.

For the purposes of the LastError value being updated, what actually constitutes a script step... E.g. does an If enclosure constitute an error (if no one knows i'll run some tests my self). [error thrown here] If[ Get(LastError) > 0 ] Exit Script[ Get(LastError) ] End If Does the script exist with the error thrown at [error thrown here] line or the result of the if clause??

Hi I have used set field by name in a script to set a field where the field name is set by a variable. It works great. However I would first like to check the contents of the field before replacing it so would like to use something like a Go to field by name but it does not seem to exist. Does anyone have a suggestion how I might get around this. Many thanks John

Does anyone know of a solution that has been created where a user can select different fields for an envelope address layout and then have it create that layout for all records. So for example if a user had 10000 contacts and wanted to create a mailing list that had each persons Salutation, First, Last Names and address he could do so and there would be a unique one for each contact. Thanks ! Erik

I am thinking about how I can work around the fact that outlook for Mac 11 won't work with fmpa 11. I want keep all my emails in one place and I need exchange server. So my question is this: is there any way of setting a different email client to be used by fmp while leaving the default email client as outlook?

For any help I receive I thank you in advance. I am donating my help to an old carpenter friend who doesn't want to learn anything new and I am stuck. Basically I have a situation where I have an account which we will call "Cash Checking". It has both debits and credits. Nothing mind blowing there. My friend wants to enter data once a month for the whole month. There are a bunch of other acounts too which also have debits and credits as well. He has a layout called "Audit Trail" That shows all the debits and credits for all the accounts he has entered data for in that month. Some of these accounts have carry over totals and some don't. The ones that don't are not a…

I have created a script that pops up a custom dialog box warning the user that they are about to be logged out due to being idle beyond allotted time. I have set up a Install OnTimer script that initiates the custom dialog box warning and if the user hits OK then it resets the Install OnTimer Script and they have bought more time. The problem I'm having is that if the user doesn't hit the OK button and is idle too long the script is paused indefinitely and I can't close the dialog box and thus log-out the user. How might I get around this?

I attempted to make a script to fill in a layout of about 25 fields with the current user name and timestamp. I want the script to leave the value in the field if it is already entered. Currently I've written out the script with the following logic "if IsEmpty(fieldName)" "set Field(value)" "ElseIF IsEmpty" which I have looping for the number of fields I have, because the script ends once the IsEmpty returns true. The problem I have is that the script is running very slow. Probably cause of the looping. But I can't quite seem to figure out a more efficient way to script this behavior. Thanks in advance for the advice.

Hi I am VERY new to FileMaker Pro 11, (never used it before this week!) I looked for the answer to the question I am about to ask, but cannot seem to find it. Ít is very simple I am sure.. anyway sorry if this is a stupid or redundant question but I am very fusterated, anyway here it is: I simply wish to use the open url to open a folder with the same name as the field called: Name_Last I created a button that will open (on windows) any folder (c:\records) for example.. and I have sub folders by last name of people. I would like to use the button to open C:\records\Jones or C:\records\Smith etc.. where Smith or Jones is the name in the Last Name field (Name_Last…