Script Workspace and Script Triggers

I have two global container fields, each with 5 repetitions. I want to script the updating of the repetitions in g_containerA from the like-numbered repetitions in g_containerB. I've constructed the following script: Set Field [ g_containerA, GetRepetition(g_containerB, 1) ] Set Field [ g_containerA-2, GetRepetition(g_containerB, 2) ] Set Field [ g_containerA-3, GetRepetition(g_containerB, 3) ] Set Field [ g_containerA-4, GetRepetition(g_containerB, 4) ] Set Field [ g_containerA-5, GetRepetition(g_containerB, 5) ] When I run the script, only the first repetition of g_containerA is set from g_containerB. The other 4 repetitions in g_containerB remain…

Dear Fellow FM Peoples, Newbie requires a little assistance. I have a value list which is being generated from a field. (Roll #) I have another field with the value list attached (Roll Selector) I have a Script which copies the Data from (Roll Selector) and performs a FIND based on your selection. The Script works just fine, the problem I have is with the VALUE List that is being generated from whatever the user enters in (Roll #). In that; say you enter a new number in (Roll#) then go directly to the (Roll Selector) the newly entered number does not appear in the value list until you click out of the field and click back in again. Is th…

I'm trying to write a script to navigate from the main file, the user interface, decide which of 6 DB's has the actual file and goto the related record. Up until now I've known which DB to return to and written the main file script to have the related file script as the last line. That way I leave the main file and stay in the related record in the related DB. With six DB's to chose from I can't use the same method. I haven't been able to write a script to leave the main file and stay in the correct related DB. Any ideas? I use a work request# as a key field. Only one main record and one related DB record share this key. Unfortunately the related record could be in…

I am building a relational database. One of the databases contains pictures in a container field. I want to also display these pictures within the layouts of the master file. Given that container fields are not 'relatable', how is this possible. Any suggestions would be most appreciated. thanks! fielding

Had 2 scripts on a database, one to backup on opening the database and one to backup the database when it was closed. Went into Scripts/Scriptmaker, highlighted each script individually and hit the Delete button, leaving no scripts in the database. Now on opening the database, I get the message, "This script cannot be found or has been deleted" I get the same message when I close the database. My manual says, page 10.10, "Important: When you delete a script, change scripts and buttons that refer to the deleted script" I really do not understand this as the scripts I wrote had only one line ie backup etc and refered to a folder on a drive where to backup to. Ca…

I have a server database and a server change log database. I have created a button in the server database that users can click on to take them to the related log entries in the server change log database. Simple, no problem. What I would like to do is if there are no related records present in the log database for a server, I want a message to show saying there are no entries for that server and ask if they would like to create a log entry for it. I can't seem to capture whether there are related records present or not. I tried using the status function: status(RecordCount) or Status(CurrentFoundCount) but neither would do what I wanted. Is there another status func…

I have 3 major files with a lot of layouts. I would like to know how to make a backbutton that would navigate backwords and forwards through the files and layouts within those files. I have 3 files called Registration, dealers, accounting Each has at least 20 layouts. Is this doable? Thanks Stan

I've got completely minimal training with Databases, but I'm trying to broaden my horizons for a particular project at work...specifically we're making a database of clubs we deal with, and I'm trying to get it to print out labels for stuff to send out. My theory was that I could create a field called "Sent", and if the value of Sent was "no" then it would pull all those records, print them in label form, return to the master layout, change all the Sent fields from "no" to "yes", and then return me back home, with all the fields that had previously been at "no" changed to "yes" with labels printed out, and the previously "yes" fields untouched by the process. I've gotten …

Hi list I have a summary layout that gives a return to a field and then a "found Count of Records" as well as a "percentage of the found count" the field that is being summarized is from a drop down list so the order that is displayed in the summary field is just based on the order that they are in the list. Is there anyway I can get this to display so it arranges the return in descending values based on the largest percentage of found records? Anyhelp would be appreciated. Thanks, Steve

I am trying to script a multi-field sort with no dialog. My management reports need to do an 8 level sort. The most I have been able to script is 1 level. I need a 1 button solution since management is not going to enter the sort information everytime they need to get a report. Thanks

is it possible to create and define a field on the fly? say, based on user input, create a field named what the user typed in (a calculation field) and define it in the script as well.

is there anyway to create an "auto-complete" feature just like IE? ie. Value List contains the following: 1 - Cheese 2 - Crackers 3 - Water If you start typing "C" you will see the Value list will only contain 1 - Cheese 2 - Crackers Then if you typed "Ch" you will see 1 - Cheese any ideas?

Hi I know this is an unusual question. But since a script is really somewhat of a macro, I just wondered if there is any way to script the creation of scripts that only change certain text characteristics in their steps. I know this could be a complicated answer. I am just trying to find out if there is some way to automate script creation and the naming of scripts.

is it possible to retain what printer was chosen in the Print Setup script? seems like if i change the printer and run the script, the printer in which i wrote the script for changes to the one i just used. is this at all possible?

I'm creating a database for an group that asks other individuals for 2 seperate Dues, as well as 4 different additional donations. I setup two files; Dues.fp5 and Payment.fp5. Dues.fp5 keeps track of the 170 individuals. The number of individuals will not change more than a few records a year. The main layout contains all the necessary fields (name, add, ph#, etc.) and a portal to Payment.fp5. Payment.fp5 is a list of all the dues and/or donations that each individual makes. It includes the fields PaymentType, PaymentAmount, Date, CheckNumber. The database is linked and working great. It allows the group the ability to keep track of multiple donations per i…

Hi, Is it possible to show a custom dialog where the user enters the information instead of pressing one of the three buttons? (for instance, if the user needs to enter one number between 1 and 10) Thanks in advance!

how do you target a specific field based on what a user has inputed into a field? basically, i am able to generate a field name based on user input; now i need to spit out a few other fields that are relevant to what the user input. ... does this make any sense? so if the user input "007" i have a script that creates the following text string "007_st" and there is a field name in my dBase called "007_st" and i would like to display it's value.

Hello, I have a database with files numbers. I've made a script which enables users to choose numbers from an index window ("inser from index" script command). On some keyboards, users can select files numbers, in the index window, quickly from the numeric keyboard (the right hand side of the keyboard), some other must select the file number with the shift + number (top of the keyboard). I cannot explain on which criteria it depends (some keyboards are OK, other are not). I do not have this problem on Mac. Do you have the same problem ? Is there something to set in the OS, in FileMaker ? Thanks for any contribution ! Antoine MDP Qual…

Not sure if this is the right section....anyway... I have a deal database setup which contains all the information for a specific deal what I want to do is to be able to associate a number of file (pdf/excel/word etc) which are associated to a specific deal number. Has anyone got any ideas / samples how to do this with out it being a manual job of having to actually write the file names in to text boxes? Thanks Simon

hi all im trying to add a custom dialog to a portal row delete script. I want it to say something like "Are you sure you want to delete entry Simon Page??" Yes/No Anyone know how to do this??? Thanks Simon

how can i get filemaker pro developer to be the recipient of an email (i can set up an exchange account for it) and when an email is sent, to create a record based on the details of that email? is this feasible, achieveable, doable or any other ...ables??

Hello and please help..I am so frustrated, I am in tears...really! I cant figure this out and I have been working on it for a week and I have tried everything I know..please help. I am really at my wits end.. HELP?? INVOICES is a database that uses LINE ITEMS database to store all the information ordered on each individual serialized Invoice. The LINE ITEMS database stores the styles ordered in the Portal In INVOICES, related record by related record. In the INVOICES database, the totals for each invoice are summarized, such as tax totals and shipping totals. I have to make a REPORT Database that summarizes the line items ordered by each invoice…

Is it possible to assign the function keys i.e. F1 ,F2, etc Mac or PC in filemaker? i would like to assign function key for the find function and also the new record request. Any help would be coool John

I'm developing a relational db for a repair shop. My question centers around the "MAIN" db as the user interface and the "CONTACTS" db which collects the customer information. The user starts in the MAIN db and selects a button to create a new record. The button calls an external script in the CONTACTS db that presents a layout in find mode. The user selects/types in the customer information and hits a button to perform the find. Three results can occur. Current record count = 0 then a new record is created in the CONTACTS db and the customer ID is passed to the MAIN db. Current record count = 1 the existing customer record ID is passed to the MAIN db. Current …

I've looked through most of the posts in the value list forum but still don't get it. I'm trying to create a dynamic value list that filters the down stream field value based on the upstream field value. I'm using FMP 6 and trying to use the "only related values" selection. This example is given for two fields but does not work when the third field in the selection process is added. I must be missing a simple but key piece to the puzzle. The sample db is an address book. I want to click in each field and see a filtered list that is based on the existing records. The first field, Company Name is no problem because it is based on a self join and shows all field v…

I have a database that tracks residents of a homeless shelter. Each individual has a unique ID (case number) as follows: 01.100. Also, each family member has a family case number: F01.100. The head of the family would be 01.100 with the members being 01.101, 01.102...All the members would have the family case number F01.100.As you can imagine, a homeless shelter has many reports; local, county, state and federal government as well as non-profits that help fund us. One of the numbers I have to generate is the number of families with 2 members, 3 members, 4 members, 5 members and 6+ members. Maybe I've been working on this too long but I'm drawing a blank here. Your help wo…

Is it possible to have FM click in layout 'white space' within a script so that no fields are selected?

Hey, I stumbled across something pretty neat today. It may not be news to everyone, but I found it useful, so thought I'd pass it on. If you use the Send Message script step you can print to or execute external programs. Everyone knows that. But you can also issue DOS command line commands too. (Remember DOS?) Send the message command /c your command line message or command /k your command line message The first version closes the DOS window when its finished. The second will keep it open. If you uncheck the 'bring application to front' option it is barely visible to the user. cmd /c your command will also work for NT, 2000, and xp,…

Hello all Hopefully someone can help me with this query: I run FMPro Server hosting about 25 databases .. all with password-protected external access. Our accounts director would like to be able to access one database .. via a browser .. from anywhere. As FMPro Server itself doesn't web-publish, and it's not a good idea to run FMPro Server and client on the same machine (certainly not serving the same file) I have installed FMPro client on our web server and am having it web-publish the specific database, served from our FMPro server. All well and good. The only problem I have is that now and again I need to reboot our web server. Obviously t…

in my database i'm constantly getting this error message: The previous script step, "Sort", could not be completed because it restores an invalid request. Do you wish to continue with this script?" when i run the following script line: Sort[Restore, No dialog] is there some global or application setting or preference i need to set? what causes this message to appear?

One field: date (which is a field of the type 'date' ) One script: Show Custom Dialog ["Enter the date" , "Enter the date please" , "date"] Buttons: "Continue", "Cancel" Input #1: date If one enters 1-1-1 on the layout itself and tabs out of the field, the date is 01-01-2001 If one enters 1-1-1 in the custom dialog, the date is 01-01-1901 Does anyone know what's going on? (This is in FMP6)

Here is my question, I hope that I ask it properly. I have a related db, 1 file has many records and many of the records have the same information, however, I only need 1 occurance of each counted. I am at a complete loss as to how to accomplish this. It is probably quite obvious, but I am lost.

Hello I saw an example of a map of the united states. Each state has its own irregular shape yet that is all that is selected when I click on it. I was just wondering how that is done. When I try I seem to just get a bounding box around the original if it is irregular. Just wanted to know Thanks Stan

but now i'm stuck.... i want one of the smart "sortable headers" that's visible on the List page of the purchase orders database. now i've added the fields HiliteLibrary, global container repeating; HiliteSortedBy global, text, HiliteOrderID with the calculation copied from the Purchase Order sample. i've imported the three scripts Sort by order id, Sort by order ascending, Sort by order id, descending renamed them and replaced all the values it missed out when it created them... i've also imported the start script and applied it to the document, which it does including the clear sort field script. on debug it stops at the line Sort Restore No dia…

Hi Everyone! Oh, help please. Weekend deadline project! This one has me stimied and I just stare at it and can't decide how to attack it, whether script, relationship and/or calc and how to even begin. Old DOS conversion data. Invoice LineItems unsorted in exact sequence I need. Fields: LineItemID (text, unique), Invoice# (text, not unique), ProductCode (text), TransCode (text), UnitPrice (number), ExtendedPrice (number), Quantity (number). If a Customer ordered 6 products, we many times gave them one (or more) free (called Buyer Review, Free Product, Replacement Product or Sample). In PeachTree, we had to list 7 products sold then add a credit li…

I'm dealing with a debugging issue, where I am debugging incorrect search results. Some search criteria is collected right after a "freeze" is issued and pressing "continue" resumes the script. The problem is, when debugging, leading up to that piece of the script is a long looped sort that I don't want to break out of, and without the freeze the script does not pause for needed criteria. Any idea on how I can debug this script? CJF

I have a FM 6 file with a script that shows a warning message if a user quits the application (not the file). This is needed to constantly re-educate users who quit the application without thinking. This script is triggered by FM preferences to be run if the application is quit. The problem is, if this script is triggered by someone choosing to quit the application, whether you use Show Message or Custom DIalog, the user has to do something (click a button) to cancel the dialog and allow the application to go ahead and quit. Otherwise it just hangs up there on the dialog. For various reasons I am running another script from this database remotely on a regular basis, …

Hi I have a map of a county in NY. I want to find a way to "light up" the zip codes when participants to my seminar show up and produce an illustrated map of the locations of the group. I think this is possible but am not sure how to do it. I can use a wingding font to get a small colored circle. It the zip code exists in the registrants then it would signal the file to put a little colored circle in that field. My real question is. I will have the participants to the seminar register so it will produce a list of zip codes. Iet us just say I have the following zip codes 13421 Oneida 13032 Canastota 13035 Cazenovia. 13214 But.... if 5 people c…

Hi all Our sales people send us a monthly report and we download it into FM6. Each record has a serial number. We would like to script the deletion of obsolete record if possible. We perform this step manually now. We compare the serial number sent in by the sales people with the db and delete the record in the db that are no longer listed on the sales report. The problem is that the report may contain new information that we would need to keep. Example: in the the db the serial numbers are as: 601 602 603 604 605 in the report from the sales people, the serial numbers are as: 602 603 604 605 606 We would like to delete record 601 and keep 60…

Hello I have a list of Countries that change with each find I do. I would like to ask all of you simply how I can ... Do a find and from the result of that find gather only every DIFFERENT country and automate placing them in one field called. "TheseCountries" separated by a comma for each country. Can this be done and how Thank you David

In a layout I have a series of fields with text data. Is there a simple way to do a script in FM that I can click on one of the fields highlighting the entire text then hit a button on the layout attached to a script ( or hit a fkey on computer) that will change the text color in the field I had just highlighted?

Scenario: Allow Staff to grab information via [Ctrl-C] (from within emails, websites, address lookup programs, letters or whatever) and insert accurate data into our database fields without the need to retype it (which allows typing errors) and without the need to jump back and forth copying & pasting bits and pieces of information (which might also insert leading/trailing spaces or garbage) as well as being a major pain. This would usually be used with the Customers or Prospects DB but not necessarily. I want to attach this parser DB to several files as a separate file and, although we will be networked, I

Hi, I'm going crazy trying to write a simple script to add one hour to a time field. Actually, it works the way it should if I use a24 hour time but if I want to see 11:03:13 PM, the system breaks down. I tried converting 12 hour time to 24 hr time for computing and the back to 12 hr but when I go to 12 hr it drops zeros like this: 11:3:13 PM. This happens when I try to add the "AM" or "PM at the end of the calculated result. Ideally, I'd like to drop the seconds so it reads 11:03 PM. Then I'll run the script and it'll say 12:03 AM, 1:03 AM, and so on... I'm using the following: Insert Calculated Result [select, "Scrach Time" , "Hour(Scratch Time) - 1…

I have a file with about 40,000 records. Several times a day a script is run by a user that goes thru every record and updates each record (don't ask why, but it has to right now). This script takes about 6 minutes to run. Other users runs scripts that find sets of these records. If the previously mentioned script that is updating the records is currently running, other users that run the find scripts get incorrect results and they take 10x longer to run. Can I add to the find scripts, steps that will return a message (and halt the find script) if the updating script is being run? The updating script is always run by a different user, obviously. Thansk in a…

I am having difficulty extracting text from the fields in a portal that I need to include in an e-mail. Each portal row contains two text fields and the portal can have 1 to many rows. I want to include the contents of each of the portal rows in an e-mail and therefor I am trying to create a script that loops through the portal rows and concatenates each of the row's field contents into a text field in the front database record. I think that the process should be as follows: 1) Identify the portal 2) Got to the portal's first row Loop 3) get first text field in portal row into front record field 1 4) get second text field in portal row into fr…

How do I write a function to test the first dozen letters of a string? Eg. string = "01-01-001 Cheese Grader" (field name is JOB) What I need is a function that will test to see... If JOB contains the string "01-01-001". Does this even make sense?

Hi all, How do I substitute text strings that are _not_ part of a larger text string. For example, if I want to substitute all the 'ark's within a text field with 'arrak' -- I want to make sure the substitution only works on the word 'ark' - but not on for example: 'bark'. In short: bla ark bla should become : bla arrak bla bla ark, bla : should become : bla arrak, bla BUT bla bark bla : should become : bla bark bla I have a feeling this is not difficult -- but I am hitting a wall and figured I'd throw this out there. Thanks,

Hello all! I am really interested in some help as to all of your ideas as to the simplest way to script to make filemaker print multiple labels of the same record! I have looked around the forum and there are some super confusing ways...Just wondering if someone has come up with a great easy script?? I have a system for my store and I need to make multiple labels of the same record..basically a page of labels from one record..why is this so difficult for filemaker to do?? Thanks for all of your help!! Ami

Hi - I have a project with 56 layouts in one file. There are times when I think it would really help the user to be able to click on a back arrow and get to the layouts they were at prior to the layout they are on. Is there any way to memorize the places in the file or files that a person goes to and make forward and backward buttons to get them there. Just wondering how this might be done. Thanks Dave

I'm reorganizing a database and would like to set up a calculation which returns a "Balance Due" based on a check box value list. Currently, it works perfectly when only one of the check boxes is selected, but I can't get the correct calculation to work when two or more boxes are checked. Here's what I have: If(Session = "Camp1", 100, If(Session = "Camp2", 325, If(Session = "Camp3", 510,0))) So, if someone is coming to Camp1 the result is $100 and so on. If someone decides to come to Camp1 and Camp2, I'd like a result of $425, but the ways I've tried to set that up have all resulted in giving me a result of 0. I know I can simply add "Camp1 & Camp2" …

Very new to FM and the whole scripting process. Is it possible to create a script that will create a list based upon the status of a radio buttons value list. I am trying to track a database based upon a job being open or closed. I will create two buttons, one to view open jobs, one to view closed jobs and one to view all jobs. The way I have it set up so far is a radio button field named "JobStatus" using a value list named "Status". Status only has an "Open" or "Closed" state with the initial state set to "Open" when a new record is created. Any help would be greatly appreciated. I have been going through quite a series of system beeps trying to figure th…

need any help I can get. Situation: I have a main database that creates job orders and each job order is assigned a unique job number assoicated to a client code. I have created several source databases that are referenced in relationships with the main database. One of the source database manages my client list which allows me to assign a client code for each client and use that value as a reference value. An example would be, client name is George Swisher, client code is SWI. Always a three letter/number value. Now to the records (job numbers) in the main database. Each record (job number) created in the main database is associated to client codes. So each r…

I have a field called date. I want to keep in my database records that are no more than 5 monts old. I assume that this can be done by a fm script or applescripts. But the fact is that I have no idea of how to do this. Can anyone help me please? Thanks in advance

Hello- I have a script that has a SEND MAIL that has worked fine for a while. Recently, some users who have only the standard "MAIL" app that comes with OS X, have no luck getting the script to launch the app. In OS 9 there was a seperate control panel for Default apps. In OS X it is different. On these machines, Web email links in Explorer AND Safari correctly launch MAIL. Anybody ever see this?

Hi, I'm new to filemaker pro scriptmaking and I really appreciate all the insight I can get so thanks in advance for your help! In Scriptmaker, after performing a find through your database for a number of records, how do I program the scriptmaker to then insert the number of records I just found into a specific field in another database?

i'm an experienced lotus domino developer but new to filemaker for a small project... i want to generate a "work log" within a field, displaying what has been done with an issue, in my old world i would say something like txtHistory=txtHistory+txtLatestUpdate with an allowance for carriage returns etc. i'm unfamiliar with the Calculation feature of fields within fm, and everytime i reference the field i'm within it gives me a circular reference error. do i need a temp field or something similar? when does a calculated field get calculated - at read of record, or edit of record, or on change of data (which data?) or on close of document or some …

I have a global field that receives data from another file. The data in this global field is concatenated. There are various field data in it and the script I have has to separate the data. One thing I

Hi! I'm in the process of writing my first 'dual platform' database (Mac & PC). I'm used to the added flexability of using AppleScripts afforded by Mac OS, and was a little surprised to hear from FileMaker support that there is no parallel alternative in windows .... is that true?? (As an example ... I'm able to use a simple AppleScript to set up a series of scripts performing different 'sorts' for different stages in the database (e.g. [sort 1 = sort by date & time] [sort 2 = sort by date & client name]) Is there no simple comparison in PC? Giles

I have a global field which stores numbers separated by a carriage return. How do I get rid of the carriage return on the first line? I know this mustn't be that hard but... Thank you for reading and eventually answering my question.

I am trying to create an organized structure of information. First step, user selects an option from a pop-up menu. Second step, depending on the option the user chose from the pop-up menu, another menu is generated right next to the first menu. Push in the right direction needed... cheers!

OK, here's what I have to do. We have a database of email addresses. I need to set up a script that will do two things: when a find is performed and a match is found, give a message "Sorry-that ID is currently in use" and start new find. If no match is found, give a message "Congratulations-that ID is available". Is this even possible? Any help would be greatly appreciated!

Is it possible to use a Set Field script step where the name of the field you are setting is a variable? Using the GetField command I can specify the outcome as a variable field name. Can it be done on the left hand side of the equation? For example: Set Field ["i" "1"] Loop Set Field ["ResultField1" "GetField(gVarFieldName)"] Set Field ["gVarFieldName" ""OutcomeField" & i"] Set Field ["i" "i+1"] End Loop First iteration ResultField1 is set to OutcomeField1. Next time through to OutcomeField2, etc. Is there any way to increment the field being set, so that the first time ResultField1 would be set, then ResultField2, etc. In a simi…

I have a script that pauses for the user to enter a field. The user at times wants to exit this script without entering any information. Is there a way to cancel this script without hitting the cancel button manually?

Is there a way to get the field name or contents from a field with a script, when the field itself acts as the button? I want to use a find technique throughout a solution by having a variety of fields acting as buttons to find their contents when they are shift-clicked (or some other modifier combination). I can do this by creating a script that is specific for each button/field that I want to use but I was hoping to have a generic script which can be applied to any button/field without having to identify each one (button/field) in the script. My best effort so far is to use the field/button to set a global with the field name and field contents (a specific s…

I've got two regular text fields that I want to merge the contents of the two into another (third) text field, without any of the words repeating. Field 1 - languages @ office 1 Field 2 - languages @ office 2 Field 3 - languages @ office 1&2 The two fields are more than likely going to contain different information in each. The languages are separated by a comma Ex - English, French, Russian, Jive, Polish, etc.. Both fields might contain the same language (or word) in each one. This is where I'm stumped. The words might be in different order, which make comparison difficult. I'm attempting to perform a word count (X) on Field 1, loop…

Hello all.. and thanks again for all your help!! I need to make a script that will enable a person to upgrade to a new version without losing any of the old information! I find this really necessary, because I am constantly changing little things on my system, and then when I need to upgrade the version of my database, I have to manually move everything over... How can I make this super dummy proof, so that anyone in my shop would be able to upgrade to the whole new system that I want to change next monday, for example? I have a large system that is comprised of 6 seperate databases connected in many relationships...so it seems that an upgrade script would h…

I searched for an answer in this forum but haven't found it (except for a suggestion from Laretta to print to a print to Windows generic text/only print driver which I don't know how to do). Can anybody tell me if I can retrieve the contents of a script in a field as text. I need to be able to search in my scripts and I'm sure there must be a solution that doesn't involve developer or analyzer. Poor me bought analyzer without realising I needed developer 6 (grrr..). So I can't use it. Buying the previous version of analyzer that works without developer or buying developer 6 is too much for my budget right now. So I'm looking for an alternative. Thanky…

In my drawing software I can define a specific district of the drawing sheet and zoom to it in a way that makes that part of the document fill the screen. In Microsoft Excel I can define a range of cells then return to that part of the document by clicking a macro (script) button. In filemaker I can set the zoom level of a layout with a script, but : Is there a way I can script a specific quadrant of a layout to zoom and fill the screen with just that quadrant? Thanks. Jarvis

I have seen others ask this question, but havent seen an answer to the exact thing I need. Little background. Have a FMPro Unlimited workstation that hosts files from a separate FM Server, publishing it to HTML using IWP. These files are password protected with the same full-access password. Got an idea from this list to create a new file (Startup.fp5) on the FMPU workstation with a startup script that opens the remote files. I set the same full-access password on this new Startup.fp5 file and the script works great. My next step is to get the opening of this Startup.fp5 file scripted so that I can run it remotely. If it helps, pretend I need to open this password pr…

I hope someone can help me here. I have been stuck on this for so long I just can't think straight. I want to set a global date field in a file by clicking on a day on a calendar file (the files are attached). I can work it for one date field in the file by scripting the calendar, but I want to use it on various date fields throughout a solution and I'm sure (I think!) that I should be able to leave the calendar file fairly well unchanged but vary the scripts in my other files as necessary to populate different date fields. I can open the calendar and can get whatever the currently set date is from the calendar but I can't work out how to pause the script from the…

I have a script which performs a rather lengthy find; I'd like the user to be able to cancel out of the find while it's running. Unfortunately, it seems that if the user cancels the find, the script gets halted as well. (It's a halt, not just an exit script -- I've tested running it as a subscript, and both scripts get halted.) The test script I'm using: Set Field ["g:Current Error", "TextToNum("")"] Set Error Capture [On] Allow User Abort [On] Perform Find [Restore, Replace Found Set] Set Field ["g:Current Error", "Status(CurrentError)"] Allow User Abort [Off] Set Error Capture [Off] Show Message ["Still running"] If ["g:Current Error = 0"] <cont…

Hello, and thanks for your help!! I am developing a POS system for my store, and I want to be able to have a shop keeper make an invoice for each customer, and then once they pay for the inovice and all is finalized, make a script that tells the record to be frozen from any modifications ever in the future... This is a fraud protection device that I really need, because if i do not do this, anyone could just change the invoices at any time and i could have some real problems with tax and such in the future... any ideas?? thanks ami

I'm having trouble with a script (MyScript) that calls a Custom Dialog box to enter a date into a global date field in order to perform a search. If the date is not valid, a message is displayed and the user has a chance to cancel or try again. I have made the "try again" part of this a script step to perform the same script from the start using an If statement based on Status(CurrentMessageChoice) and "Perform Script (MyScript)". There are other parts to the script which allow the user to try again if the found count is zero and I have used the same method to start again. However if a string of invalid entries and/or zero record counts are dealt with by…

I need to limit access to records by user by their Windows Logon Name. Essentially I want to copy their username out of the registry and paste it into a field in Filemaker. I know this can be done using a very simple VBScript, but I haven't been able to make it work. I would appreciate any help from a more talented scripter.

Hi everyone, Is it possible to use wildcard in a calculated field? What I mean is, instead of: or (Field A=1 and File B::Name="Dimitri") or (Field A=1 and File B::Name="Dany") or (Field A=1 and File B::Name="Daniel") or (Field A=1 and File B::Name="Dan") or (Field A=1 and File B::Name="Dimanuk") , 1, "") Write something like: Case(Field A=1 and File B::Name="D*", 1, "") I know this is not the right syntax, but you get the idea. I want to use the wildcard like in search. Thanks in advance

Happy New Year everyone. Thanks for having a look at this one for me. I am having problems getting Status(CurrentError)to work properly (at all)in a wizard I have written for record creation. Having looked at various examples on the forums I still can't see what I may be doing wrong. 1. I have the Troi ClipSave plug-in enabled (in case this is relevant)- it probably isn't. 2. Policy Number is required to be Not Empty, Unique, Numeric Only. This is my script: Set error capture (on) Go to Layout ........... Show Custom Dialogue (buttons: 1 "Create" 2 "No Thanks") If [status(CurrentMessageChoice)=2] Show all Records Exit Script Else…

Using the script below displays the Delete Record dialog before going to the Residence layout. Why? How can I go to the layout first then display the Delete Record dialog? Set Field["gUserID", "Find User::UserID"] Go to Related Record ["gUserID"] Go to Layout ["Residence"] Delete Record/Request[]

Here is a tough one! I would like to run a script based on the value of a field ie: Fieldx = happy Instead of using if statement in my script such as if fieldx=happy perform script happy end if if fieldx=sad perform script sad end if i would prefer to bypass the if statement and perform script (value)fieldx is this possible? Stu

Hi, I'm trying to build a layout made only for search to simplify the live of my users. Here is the deal with my database It's a project database to keep track of job across our department. A job can have many different part A, B or C. The person of submit the job and the one who execute the job can change from part to part and the activity summary also. I would like to create an interface (layout) where the user will only need to fill one field to search, for example, the activity summary in each part. I need to do this so my user do not have to fill up to 3 or 4 field with the same information when the are search record. How can I achieved this…

Lo' again all, I've updated my attendance file and its scripting. Its a little more manageable now. There are two ways that a user could input invalid or incorrect data when doing date range searches. They could search for a date range yields a zero found count (e.g. error = 401), or they could mess up and use the incorrect number of days for a given month (e.g. they could do a search on the range: 1/1/2003...1/31/2003). When i am doing a manual find and i place that in my date field (dateAttendance) it pops up the "The date in this field must be a valid date..." message. This is an acceptable and understandable function. However, when i script my date range se…

hi, new to board. trying to do the following: generate map and directions for sales reps(field) for an appointment date(field). essentially, having an email sent to the sales rep for their daily appointment sales....want to set it up with directions from appointment a to appt b to appt c....for sales rep A. then do the same for sales rep b etc. need to be able to come up with a way to integrate the sales rep appt slip with maps (web based... like mapquest) from appt a to appt b to appt c and send this in an email. utilizing FMP 6.0 any input would be much appreciated.

Hi guys, I want to show if the data in an individual field has been changed, or deleted, and who changed it. I know in FM there are several prebuilt fields, like "Modified By", and "Modified On", but these operate on a row, not just one field. In other words, when a user changes ANY field in a record, user's name will show. Is there an easy way to accomplish this? I can think of some complex scripting (Yaiks), but maybe there's a better way? Many thanks.

The user can pick multiple selections via check boxes. All the selections are put into one field. When they are entered into the field the selections are put one right after the other. What I would like to do is find each carrige return in the field and reploace it with 2 carriage returns this would put a space between inputed selections. I can use the position function to find the first carriage return but it does not work well for me for the rest. Any Ideas?

I have a solution where the user inputs data during certain times of the year. Does anyone know how I can make a field unmodifyiable after a certain date?

Can someone point me in the right direction for this. I have a database with 562 records in it and I want to enable the web companion so that people can log in from a web browser and see only about 23 of those records in form view. The 23 records that I want them to be able to see are for a winter tour coming up. I only want them to be able to see them as a report and not be able to search or enter any data (I can figure that part out). I can create a flag field for marking the records that I want displayed but I am not sure where to go from there. I also want the number of records shown to be dynamic based on whether or not I flag them. It seems to me that the best …

One of the scripts in my FileMaker 6 accounts database has this step telling AppleWorks 6.2.4 to open a document: Send Apple Event ["Forecast.cwk", "AppleWorks 6", "aevt", "odoc"] If AppleWorks is already running, this works fine - but if AppleWorks isn't running the script tries to launch it in Classic mode. My workaround to date has been to have AppleWorks as a Login Item, but I would prefer to know what I'm doing! So, how do I tell AppleWorks I want it to launch in OS X?

Hi all: Upon login the database A, I'm trying to auto-perform the following script in database B: Enter Find Mode Set Field... Perform Find Set Field ("Global Field 1", "Status(CurrentFoundCount)") The goal is to then show the value of field "Global Field 1" on the main splash screen of database A. The problem is that if there are no found records to match the search criteria, FileMaker pops up an undesired window that says, "No records match this request - Modify Search or Cancel." Is there any way to avoid this message when the found count is "0", so that users don't need to click "Cancel" and they just see "0" as the number of found records in "G…

I

I have a very strange problem that does not relate directly to any topic. When I print a specific list view (from a script or not)if leaves out the name on the 13th entry. It prints everything else on that line - like age-grade-barcode, etc. I tried it on another printer to verify it was not just the print driver. It is not at the top or bottom of the page. There are 21 lines on the page. Any ideas?

I am an advanced beginner. I have considered several ways of doing this but they all come to challenges. An attendance database. To record Sunday attendance of children. I would like to be able to have a script to return who was attending on a Sunday provided by a quary. I can use Sunday numbers from weeks of the year in a repeating field (like the 25th repetition = the 25th Sunday of the year) or I could have a relational database and it would be the 25th field in the database. But all these require a way of telling the script just where to find the informaiton in a way I have not discovered. An alternative is to have a separate field for each Sunday's attenda…

I haven't found a way to go to the next, previous, first or last record using a script. If I want to change a field in found records, I find them, make a change and omit the record and repeat. Is there a better way? Larry

I'm a newbie to Filemaker and have no clue at all how to complete the following (or a lot of things): 1. I have different Word documents and depending on the data in a field (being imported from an Excel file) will determine which Word document should appear on a record (i.e. if the field equals ART then the document concerning ART should appear on a record, if the field equals COMM then the document concerning COMM should appear on the record, etc.). The documents could change so I need to make them linked OLE objects. 2. There will be text after the linked information but what happens to the line spacing between the linked information and text if the linked in…

I would like to import some records and at the end of the script tell the user how many records were imported. I know I could show a layout with that information , but I would like to use the show message script step, is it possible ? how ?

i'm trying to understand the logic of the status(currentmessagechoice) parameter. if there's no dialog directly preceding the evaluation, does it remain at it's last value? sometimes it seems to stick, sometimes not. perhaps it's cleared when a new script or subscript is invoked. anyone know for sure? thanks!

I created a button that opens a pdf in acrobat reader using a field with the filename and the Open URL script . There is a different pdf for each record. Now what I need to do is make a counter to see how many times the button was clicked on. I need to find the total for all records together, as well as for each individual record. Any help would be much appreciated.

I haven't been around this forum long enough to know whether this has been raised before, but I have noticed an interesting phenomenon: I had a number of troublesome scripts [usually with Scriptmaker calling an AppleScript to the Print Center (aka "Printer Setup Utility" now we have Panther] which were returning all kinds of errors; "Can't find application dictionary", "Application not running", etc etc Then, by chance, I made a clone copy of my master database yesterday. When I run the clone, every script which had been giving trouble ran perfectly ! So, does anyone know ? Does cloning=cleaning ?

I hope this can help someone else. I've been trying sporadically over the past year to resolve this. And this is on a PC so I'm not sure how a Mac would react. Problem: Normally, when you click on a Word template, a new, blank, unnamed file opens, based on the template. Using the "Send Message" or "Open URL" to open that file, however, results in opening the template file itself rather than a copy. Solution: Use the "Send Message" with some specific spacing and quotation marks. The trick is to NOT open the template file directly but to open Word with its "/t" switch, telling it you want to open a template. Here's the example: Winword.exe /t"C:Desktop…

I have created three similar scripts that I would like to nest/combine into one script. That way, I only have to press one button instead of three everytime I want to perform the scripts. Is this possible?

Hello, I'd like to add a functionality to my file where with a click of a button that is on that file, FM will check if there is any empty records in that file and automatically delete them from a file. What is the best way to do it? I tried using basic scripts, but there is nothing there. Thanks

Hi, I'm looking for a way to create a button that will open a folder from FileMaker. I have 2 field that supplies our naming convention when we create the folder in the server (all folder are created in a central place). How would I take the 2 field and put it into a path that will open the folder in the finder (I'm on a mac, put I would like a cross platform solution). Thank you