Script Workspace and Script Triggers

When running scripts that Set Field in a related file on the network, sometimes it works and sometimes it doesn't. I've captured errors, and it is 102: Field is missing. If I run the script twice, it might work once, and fail once. Or work twice. Or fail twice. Anyone have any idea why? The original file and the related file are on FMProServer5, and there are no problems with the network. Is it possible that more than one user are trying to change the same field at the same time? If so, is there a way around this?

Anyone have any suggestions about an impementation of a system that would check user rights on a per record basis. The rights for users would change during the course of a year and could range from create records, edit only, read only, no access. these priveleges need to be set on a per user/per record basis.

How can I use the substitute command to add a space after a "." or a "," to every occurence in a text field, but only if the space is not already there. I`ve tried the following: Substitute(field name; ".*" ; ". ") Very thankful for any help Vegard

I'm trying to build an inventory system. I've got two databases, one has the parts and quantities in stock, the other uses the parts in variable quantities. I can pull parts with a relationship but can't figure how to subtract the quantity and have it successively deduct from the total. I've tried scripts but can't figure out how to execute the script when the qty is input, I've tried calculations and lookups etc. I'm just lost. Any ideas would be greatly appreciated. Thanks.

Problem 1: Want to have the current date enter into a field when the preceding field is modified. I can't use an auto insert because the date will change when some other field is edited. Problem 2: I'm trying to generate an ongoing history for a contact. I.e. if the "last contact date" field is changed, I want a "comments" field to pull the previously listed date (from the same field), the person whom they spoke with (from another field), and the name of the company they spoke with (from another field). Any help for a newbie would be appreciated. Doug

I'm trying to improve upon my gradebook db. Right now, I can either enter grades as % or as decimals in order to get an average. A coworker asked if I could assign a value to letter grades (IE A=4.0, A-=3.63, B+=3.38, etc) to make gradebook entry easier for teachers who would have to look up the number equivalents. I'm familiar with boolean yes/no, but is there a way to get FileMaker to equate a decimal value based on the letter grade I enter in a field? I tried creating a value list that displayed the letter grade and 'also showed' the number equivalent so they wouldn't have to mentally keep track but the value list only displayed the first entry for each letter (IE …

I have a task database for several clients that I use to bill them. How do I set up my print script so that It only prints out data relevant for the current month? (based on the task's date of course...)

I've used this technique before. Create a calculation field in your student db. the calc "If(mentor="yes", student name, ""). Now create a mentor list in your value lists and point the list to this field. You should only see student mentors on the list, and if you change the mentor field to no, the student should come of the list automagically. hope this helps

I need to Create a script to automatically add/delete records in a Dbase via a relational link. I have sett up a relational database to allow staff at the college that I teach at to input data for centralised record keeping. What I can't seem to do is create a script that will on start up check the records in my master file of students and will then add/delete records based upon what it finds in the master file. I am probably missing the obvious here but if anyone has a useful suggestion for doing this I would be very grateful. I want to make it idiot proof so that staff don't have to add delete records from the database. ------------------ Andrew.

Sorry for the length of post, but I'm an MS Access user and am having difficulty w/the syntax of the FMP scripting language. I have 2 FMP databases. Let's call them Original and New. The Original database has a table of approx 175 fields, including ID, Lat and Long. Some of the Lat and Long fields are blank, but the ID is always present. In the New database, I have the ID, Lat and Long fields. Data is present in all fields for all records. I'm not sure what script language to use (looping find/copy/paste; relookup; etc) to toggle back and forth to open the New database, look at the first record and examine the ID value. Toggle back to the Original database, Find t…

Hi! I got a Adress database and want to make a button that opens up my Invoice database and make a new record and put in name, adress... from the Adress database...

Hi, I'm trying to script a search on a date range. Currently the user enters values for the StartDate and StopDate which are Global fields for dates. In the script the date field is set to StartDate&"..."&StopDate in find mode and the search performed. For some reason, however, the search is only performed on the StartDate and not the range. Any ideas how to do this would be great. I had this working before then made changes which don't work and so now I can't remember what I did to have it working! Thanks, Louisa

Please can anyone suggest an easy way for us to work out which of 30 users is currently in a single user database (without yelling across the office!!!)? I'd be most grateful for suggestions or even a bit of sample code to help me along! Thanks, Al.

This is what I got : Filemaker 4 and firstclass mail. I would like to get these two programmes work together. In FM I can drag and drop an e-mail adres out of a field onto the desktop, click on it and it opens a new mailmessage in Firstclass . What I would like is that I can click a button next to the e-mail field in FM and that it does the same thing automaticly, I know there is a mail command or setting in FM but it only works with a few mail clients. Is applescript a solution for this problem ? Thanks Peter Boodts [email protected]

Can someone please tell me how to execute a script from the internet? I am trying to publish a database on the internet but when a user clicks submit on a web browser, I need a script to run. Is there some sort of Java script that I need? I am "cgi stupid" and would be grateful for any help that I can get. Thanks!

Does anyone know of a way I can prevent modification of a record after a certain date? We want to prevent users from altering a customer record after a certain period of time, say a month.

I am trying to write a script that will perform a find based on multiple variables. The script should bring in values from a related db. I tried to use the following: Enter Find Mode[ ] Set Field [

I have a database of students and some have volunteered to mentor incoming students. I have tried to create a script that, when run, will find all those where the mentor field is yes, and then erase the mentor list and fill it in with the found records. I can get it to find the mentors and open the value list window, but I can't figure out how to get the found records into the value list. The other option I was considering was some how exporting the found records to another mentor DB and just using the name field as the entries in the value list. Thanks in advance, qntgeek

I'm using FileMaker on a Win98 environment. I'm trying to setup a script that will allow me, without user interaction, to print to different printers. Everytime I try to set it up now, it won't print to the printer I had defined when I made the script. Any ideas? Thanks, Ryan

Hello, Is there any way to ex/import scripts form one PC to another and/or from one file to another(with the versions 3.0,4.0,4.1)? Thanks