Script Workspace and Script Triggers

I have a database set up with server 8 all workstations are running FM8 or FM8.5. I have a simple email script -- using built-in FM commands (no Plug in). Occasionally when sending email though FM an error pops up and asked if you want to report this -- then shuts down FM on the workstation. I have been using FM with this script for years and never this many crashes. Occasionally it will crash the same computers 5 times a day. Does anyone have an idea what I can do? Thank you, Joseph

Hello! Is there a way to script an import so that the when the Open File dialog comes up to select the file to import, the "Show" option in the lower left corner always defaults to "All Available"? I know I can do that if I also specify the file path, but the file to import is always different so I can't do that...thanks! Sally

Hello everybody, if this post is not in the proper category, please let me know. I have a customer database that is also being used for trouble tickets (all of that works fine, thanks to the help I received here for a function or two... or four). I would like to add a function that would allow employees to add attachments to the customer's file (emails, images, docs etc...). Now, I added a container for the attachments plus a button "insert attachment" that performs a scipt (a one liner, insert file in container "attachments" and made sure that the "store a reference only" was unchecked. It works well... for one file only. I would like to be able to keep multiple fil…

ok.. trying again.. using this script below New Script Go to Layout [ “Layout #36” (nasd_NOTE__cno) ] Perform Find [ Specified Find Requests: Find Records; Criteria: nasd_NOTE__cno::Tried: “Tried” ] [ Restore ] Loop If [ nasd_NOTE__cno::ndate < nasd_NOTE__cno::st_date ] Omit Record End If If [ nasd_NOTE__cno::en_date > nasd_NOTE__cno::ndate ] Omit Record End If End Loop what i want this to do is find all records with the "tried" field filled in, but i want it to only add the ones in the date range to the found set, it ignores both if lines and stays in the loop until i hit esc.. what gives?

Im trying to run what I assumed was a simple If statement. I have a start date and end date and I'm creating records for all dates that are Mon-Fri, doing a check before each loop iteration based on the following: If[(not DayofWeek ($Date) = 1) or (not DayofWeek($Date) = 7)] then go ahead through the part of the loop that creates the daily record. If it fails that it goes to the part of the loop that increments $Date by 1 day. No matter what value DayofWeek ($Date) returns it fails that if statement and goes straight to incrementing $Date. I tried switching to a ≠ without the not and it will pass the if statement every time. Am i missing som…

Hello I need to somehow fax, and I own already this activex component called FaxManJr http://www.data-tech.com/products/fax.aspx Has anyone used FaxManJr before.. in FileMaker? It worked in a VB app fine,, another VB coder installed it , I am looking for alittle guidance... would this FaxManJr work in my FileMaker app? Their link to this fax app above,,, I am real new even with Filemaker... can anyone give me some kind of guidance to start with.. like how to install or tell FM i am using a activex componet.. or call the fax app.. for starters ThankX Rod

Hello, Yes, it's me once again. I think this is relatively simple, but for some reason I cannot seem to be able to get it to work. Perhaps I'm on the wrong track. I would like to know if there is a way in FMP (there probably is...) to perform a find using drop down menus in a seperate layout/table to input the find parameters. Here's an example of what I would like to do. My database contains a section for trouble tickets. There are a few fields such as: Ticket number (automaically generated) Ticket status (open, closed in a drop down menu) Call back date (calendar) Call back time (drop down with time vallue list) To whom the ticket is assigne…

Attempting to make an invocing system and running into problems right and left. Basically it is a database designed so that 1000 of these "slips" that simply listed a client, what was done, for how long, and when are entered into records. From there I need to figure out the best way to put many of these onto one invoice form. The trick is I need to script it so that only the ones chosen (done so by activating the script) will be added. Does anyone have a good way to go about doing this, maybe someone who has done this before?

Good Morning All, Im a little lost in how to start if its even possible. I have a list of Items that im trying to keep a record of Sales and Qty by week. so what i have is the following WK1 Picture---Item number----Description----Sales/qty I also have WK2-WK 5. I just didn't have space to put this. Any how what iim trying to do is create a script to copy wk1 sales/qty to WK2 Sales/qty, and so one. So basically i want to keep a record on all sales/qty. hopefully this makes sense. the goal in mind is to be able to see in a list format up to 5 weeks of sales/qty. the way i see this script working is mov…

Is there a way to get around filemaker's "specify field" method of selecting a field in scripts? Are there any techniques for calculating field names to be acted on?? I am trying to make my scripts more abstract and multifunctional, but am being thwarted far too easily! thank you for your help, matt

Hello, I have a field (paid X)as a button to know when an expense record has been paid, it can be checked or unchecked. Two fields set up... #1) paid X calculates If (not IsEmpty (paid timestamp) = "X" #2) paid timestamp PAID SCRIPT If [Get (AccountName) not equal to "janedoe" or "johndoe" Set Field [paid timestamp: Get (CurrentTimeStamp)] End If Commit Records/Request [skip data entry validation; No dialog] NOT PAID SCRIPT If [Get (AccountName) not equal to "janedoe" or "johndoe" Set Field [paid timestamp; ""] End If Commit Records/Request [skip data entry validation; No dialog] The Script is... Paid Unpaid If…

I have created a report that, among other fields, contains two date fields. 1 field named planned ship date and 1 field named revised ship date. The planned ship date field always has a date entered. The revised ship date field occasionally has a date entered in it. I need to sort these records based on which ever field has the later date and the report needs to display each field. Any help would be much appreciated.

Hi, I am making a Loans Database for our helpdesk. The loan transaction is set up in a typical fashion in that there is a Transaction table, an Asset table and a join table for Transaction Line Items. All of this works. Some of our Assets can only be loaned to students in certain classes. For instance a particular camera is allowed for Art Students and Math Students. Being an Art Student or Math student means that you are a member of certain classes. So I was thinking I needed a couple more tables, Permissions table with a name (Art) and a list of classes (ART101, ART201). Then, PermissionLines linked to the Assets table. That way an asset is able to have m…

I want to be able to shutdown filemaker and any open db at a given time. Eg At 17:00 close open *.fp7 files and shutdown the application when i am awayfrom the office. i was thinking along the lines of a "End If" etc. Can this work?

I am a medic at an overnight camp and am trying to create a database to track the camper's medication delivery and all their illnesses and injuries while at camp. I am trying to create a script that will automatically, when executed, create records based on a record in one layout in another layout. I want to give it a date range and time of delivery range and have it generate each event (or time when pills are delivered). I attached my script, be kind, this is my first time making a script. Thanks for any and all your help! If [ MedicationLine::Times ≠ "" and MedicationLine::StartDate ≠ "" and MedicationLine::EndDate ≠ "" and MedicationLine::StartTime ≠ "" an…

How would you set a script step to open the File Dialog Box in WinXP? I'm trying to set a button to open the dialog so that the user can select the document they want to attach to an email and place it in the 'Attachment' field. I can do this in SMTPit with "SMTPit_File_SelectFileWithDialog" but, I am developing a runtime app for another user who does not have that PlugIn. Is there a way to do this in Native FM? TIA Al

I have a Custom Dialogue box which has two input fields one for a date and one for a time. The fields linked to the input fields have validation on them (Date dd/mm/yy and time hh:mm AM/PM) but this validation is circumvented by using the input fields in the dialogue box. Is there a script I can use as a next step to check the format of these field and show any errors. Many thanks

Hi, I'm wondering if there is any way to avoid the pop-up window requesting a login and password when accessing records from an external password protected file? Is this an issue for a served Filemaker project?

I am using a bar code scanner. It acts as a basic key board. I am using code128. My problem is I need to call a script--example ctrl+1 or ctrl+2. Within code128 it doesn't have ctrl+. Thus I can't call my scripts. My question is [color:red]does anyone know a way of calling a script other than using the contol key. Example might [color:black]be---@zz@1 which would do the same as ctrl+1. Thus @zz@1 might call script 1.

Hi -- this is a simple one, but I'm still a scripting tyro. I want to have a button on a layout that will enter the next available value in a field called 'Barcode'. This value would be the highest existing Barcode value + 1. Although the Barcode is a string of numerals, I have it as a text field since it's not used mathematically (right?). Is there a Function that "Gets" the highest value for a given field across all records? Or would my scripting approach here be to do a "Find All" / "Sort" / "Go to Last Record"/ Set Variable (to Barcode Field) . . . and then how would I get back to my original record to enter the value? Thanks! Albert

Hello all. I need help to write a script (I think a script is what I need) that enters a timestamp in a field and also records the user name when a specific field is modified. I have 3 fields: (1)"Status_Choice" - where manager chooses either "approved" or "denied" by a radio button; (2) "Status_Date" - is a timestamp of when the "Status_Choice" field is modified; (3) "Status_User" - captures the name of the user when "Status_Choice" is modified. I want fields 2 & 3 to update ONLY when field 1 is modified (when a choice is made), not if any other field on the layout/record is modified. Thank you in advance for any help B)

Hello everyone, This is a bit far fetched I know but I thought I'd throw out the idea to see if it's been done before. My thought is to have some sort of script/applescript that allows you to click on a send email button and instead of creating a new email every time, it adds to an existing blank email. So I could basically just search for the people I want to send the email to, the first click would create a new email but the send (depending on a selected option maybe?) would add the address to the previously created email in the To: field.

I have a built a script to execute a find request - however the returned results are not the same as if I create the find request mannually. The reason for the script is to utilize a graphical interface to simplify an and/or/omit type of search across several keyword fields. To make life easy, I created two concatenated fields that are strings of all the keywords associated to the record. When searching, we search on those two fields. So, for example - keyword1 is "blue" and keyword2 is "Wine" If you search indvidualy for "blue" you get 24 records returned and "wine" returns 116 both from the script and manaul finds. However, if you search for "b…

I am converting a fmp6 to fmp 8.5, I noticed that the attached script(s) do not work properly. whenever i use it, it inserts values from the previous entry. this is not good. I have tried to debug but no luck. attached is a pdf of the scripts. Thanks in advance TMscript.pdf

I have got a script that is sending me in circles! Basically the idea of the script is to search a stock file for a list of items. I give the user the option to select from three fields to search on using a 'Show Custom Dialog' box. Using the Script Debugger I have discovered that the only time that it writes data to the global field to be used in the next part of the script is when the default button is selected and not when either of the other buttons are selected by the user. Any thoughts?

I have a database that is used to record inspection information in my manufacturing operation. When we find bad parts, information is recorded in a separate "Rejected parts database". The two tables are related by a serial number field. I'm trying to write a script in the Inspection database to open the Rejected parts database, create a new record and copy the serial number field contents from Inspection database to the Rejected parts database. Here is what I have, that is not working: Open file["rejected parts log"] Perform script ["new record" from file: "rejected parts log"] Set Field[rejected parts log::box serial number;Final inspection sheet::box serial…

Hi I have a customer that will be emailing me csv files that they have exported from there MIS system so that I can import into my FM solution. Each csv file will be titled with there unique Job No's. What I would like is once I receive the email the attachment is extracted from the email and saved into the Import folder I have set up on the desktop. Then from within Filemaker I run the script that searches for files in the Import folder and imports them into my solution and then deletes the csv file. I can import a file OK, have entourage save the attachment CSV file into a folder OK what I can't do is have my FM script select the files in the folder by…

Hello Everybody, I'm new to this forum and I'm also new to filemaker. I'm trying to create a script that will do the following: When I print, lets say 3 forms, I want that on one of the forms to be printed if a field named emergency is selected "Yes". Is this possible? Help is appreciated. Thank you in advance.

Hi I am very new to FileMaker but not to Databases in general. I have a notes field that I need to find a set of records and add a comment into the begining of this notes field. Can anyone show me what / how to write a script or even a way of performing this function ? Thanks :

i need a script that will find and omit records with one or the other of two values in a value list. attached is a screen shot of what i have now. i hope someone can point me in the right direction to debugging it. thanks deanna

Hi Everyone I would like to set a repetition by specifying the repetition number to set using a calculation. See example of my failure : best Stuart SetRepByCalc.fp7.zip

I am creating a database where the users have to log in. If they log in and have already created an entry, but need to edit the entry, I want a script to take them to it. If they have never logged in and need to add a new entry, I want another script to allow for that. What would these scripts look like? How do I check for the existence of a record? Thanks in advance

Just looking for some basic pointers on this; I have a script that builds a complete email ie: it populates, the address, subject and message body. I am now being asked if I can make the body into a PDF file. I have managed to trigger an empty email with the PDF sitting in the body, but thus far, I cant manage to populate the address and subject lines of the email. Any ideas how this can be achieved?

Just started using filemaker, got a basic grasp of the program but need some help with scripting. The database i'm working on deals with telemarketing of sorts, i need to make a script that will count how many times a call was attempted by a particular user, could anyone maybe point me to some sample scripts that could help in creating a script like this? thx in advance

I am trying to do a find by opening a new window in find mode and performing a find then close the window and go to the original layout. The problem is that the found set in the original layout does not show the new found results. I need to pass the found results to the original layout. Thanks

How can I write a script that identifies and deletes duplicates.

I have a database with several tables containing student information. Table A contains general student information. What I would like to achieve is that when I add a record in table A, a new record is automatically created in table B with just the student ID no just entered in table A. The other fields in table B will automatically be updated after the student ID is entered. I hope this makes sense. Can anyone help?

This is probably fairly simple however I cannot get it. How would I make the following script work without it leaving the layout from which it was run. IE - not changing to other layout while in browse mode. I tried freeze window and such, however if I remove GO to layout script step I cannot get it to work at all. See the attached picture for the script. Thank you.,

Filemaker 8 Advanced I have a script in one file calling a script in another file, via a button. Both scripts have "Allow User Abort [Off] as first step. When I click button the hour glass appears very briefly, but "Esc" is flashing. I can also hit "Exc" on keyboard while clicking button and it stops the script. I thought Allow User Abort [Off] would stop this? Does the Privilege Set matter? I would like: "Esc" to not appear Stop users from aborting the script Any help would be appreciated. Thanks.

Hi all This is bound to be helpful for a lot of people... when it works. I have a product database and would like to generate the RSS code for each automatically and put into on field, but can't work out the repeating part. The following is on a List All Products page layout. Not sure if this is best, maybe a portal would be better. Maybe it's all possible within a calculation field not a script. I have a calculation field that does the top and bottom part of the RSS code... "<?xml version='1.0' ?>¶¶¶Title here¶Description here.¶http://www.domain.co.uk¶¶http://www.domain.co.uk/images/logo.gif¶Title here¶http://www.domain.co.uk¶¶" // …

Ever since updating to Leopard it seems that filemaker loses my email signature whenever i generate an email using the send mail script step. Does anyone have a suggestion or fix?

hello all... i want to know how to 1 - create & 2 - write to a text file. its main purpose will be to write log-in activity of the user and nothing else. since the program wll run on stand-alone workstations [no server for sharing]...each workstation will have its own log file. for now all i want to know is how to create and then write info to a text-file. rest i think i can manage once i have a starting point. thanx in advance for the help.

Hi, I'd like to know if it's possible to know wether or not the current window is maximized or not. I want to do that to avoid a screen refresh (on windows) for nothing if the window is already maximized Thanks.

Hello, I'm having a bit of an issue with a script I'm currently working on. In my customer database, I added some fields related to callbacks for trouble tickets. Time (drop-down list so that nobody can screw the format up), date (drop down calendar) and whom the ticket is assigned to (email address of employee, drop-down list again for the same reasons). This script will run several times a day and should accomplish the following: 1. Check if the field (CallBackDate) contains today's date 2. Send an email to the email address of the person the ticket is assigned to with some details (customer name, phone number, time of callback, a copy of the customer's log …

Hey, I'm having an issue deleting scripts, I have full user access, and when I run the scripts, FM says the script cannot be found or deleted. So in scriptmaker I get the same message, even though they are listed. I recovered the file, no errors reported. Any ideas how to get rid of these orphaned scripts and I'll just redo them. thanks in advance

Dear Professionals, There are quite many duplicate contacts which my user makes. It seems it is so troublesome for my users to first search for the contact if they already exists or not. I need to delete these duplicate records very often since the drop-down list in Invoice shows the duplicate contacts and my users starts calling me for deletion. This is so annoying, and hope someone can help out from this nightmare. Are there a way to script to check for duplicate record when user clicks a new button. Or even a better method you the professionals use to prevent this.

I have a database that multiple employees use to submit their expense reports. I'm trying to write script to only show the records for the employee who logs in: Get (Account Name) Find records: name=Account Name Not sure the best way to do this, so an employee doesn't see everyone else's expenses? Thx

I have made an applikacation that would need to link via url to an pagemaker application. some of the information needed in the filemaker application is known in the the primary applikastion. The information is of type salesperson name/phonenbr etc. I can autosignon via url to the filemaker application, but not prefill the form in filemaker application with data from the calling application. Is it possible in som way to pass those field information(text) as a parameters in the calling URL?

Couldn't find anything on this in searches. It seems like a simple task, but the way I'm thinking seems tedious. The task: I want to compare two lists of file names that should be identical (but aren't) to find out where the first difference occurs. I have table A with a field named "a". Ten thousand records with data (a file name) in field "a", alpha sorted. I have another table, B, with 10,000 records alpha sorted in field "b". The contents of these two tables should be identical. What's a simple way to compare record 1 in A with record 1 in B, etc., to find where they differ? Thanks again, guys.

I have a scripting problem that I can't wrap my head around. At least, I think it is a scripting problem.. Basically, the database matches salespeople with clients. So far, so good. I have tables and portals in place that allow me to relate a table full of clients to a table full of salespeople, such that the clients can have a relationship with more than one salesperson and vice versa. The join field between the salespeople and clients is a 'Contracts' table that allows me to characterize each salesperson as a primary, secondary, or tertiary contact to that client. The problem is this: I would like to be able to generate 'Assignments' for these salespeople, to …

I have a database I use to tag book and periodical quotations. Each record is tagged with a subject, and each subject has multiple sub-subject possibilities. I have been asked to make the database more user friendly (I have been using only for myself up to now) and put on the network for others to access via FM Server. For that reason I have been installing script buttons and dressing up the interface. I encountered the following problem in scripting a find. I have a find layout that has a drop down list from a value list for "subject". Based upon that selection, the second field has a drop down list with checkboxes to select one or multiple "sub-subjects". I want the sc…

Is something like this pseudo code possible? ---------------- open (DB:Filename Field) Write DB::Data Field close ------------------- I haven't found the functions to do this in the reference. Am I missing something? Thanks! -Jeff

Hi .. i have a portal with "item" field and another with "quantities" ....i want to make a report by customer ..all the portal has 30 items.. but i dont want the report shows me the items = 0 (quantities) ... can i restrict that?? .. i want the report with the items than are more than 0 thanks for your help Mauricio Monsalve

I have a repeating field with n values in it. I am gathering all data from the repetitions into a variable using the List() Function. I then want to check for two conditions, does the list contain the values 143 and also 33. However in using a pattern count the # 133 would trigger as true in the evaluation. I need it to return false. Whats the best way to proceed, Id like to not use an additional relationship if possible. Thoughts?

We have been successfully printing barcodes where we think we need them. Everyone talks about his part but rarely the implementation of using the barcode. Does anyone have some good references on how to use them. What I don't get is how do I specify that input from the barcode to do a specific task when all the computer sees it (as I understand) is keyboard input. Do I need to use a plug-in to watch a field? Even if that is the case how do I have input from the scanner go to the correct field without the user first having to click on the entry field? As with everything, it seems getting started with the basics is harder than continuing onto complex stuff. Thank…

I would like to build a script that allows the user to insert a picture into a container field. I think I want to use the [color:blue]Insert Picture script so I can be sure they only install a link to the image. But here is where I have an issue. I would also like to direct the user to a specific folder defined by the script, containing specific types of images suitable for the container field. The [color:blue]Set Path part of the script does not allow me to set a particular folder where the user can pick the correct image, only a specific image. I know I can leave the [color:blue]Set Path part blank and let the user navigate to it, and there is no wa…

Hello all, I'm new to FMForums. This is great! Working in Filemaker 7.0v3. I've noticed that newly defined fields get added to previously scripted imports. How can I prevent this? thanks so much! Sally

I have a table named Student. I have another tables named Grades. Grades holds all the classes taken with their grade, semester and other related information. They are both related with Student ID. Example: I need a script that will print the 2nd semester grades for the students selected. If the user selects a group of 10 students, then how can I have those same ten students selected have only their 2nd semester grades printed, one after the other. I am somewhat lost as to how to loop through the records selected. Hope someone has an example to see, test and modify for my case.

Hi there, I am wondering if anyone has a solution that would enable me to still collect addresses from found set but if the same email address appears twice it will ignore the second one? Any ideas would be appreciated! Rhys

I just upgraded to fp9 from fp7 and am trying to use the send mail function for multiple email addresses. I've been able to create a calculation so that the emails will be personalized but I also need to keep them formatted (some of the contents in the email include quotes which obviously creates problems). I also need hyperlinks to remain in the emails. Does anyone have any recommendations of how I can get around this so that my text remains formatted?

I have a Time Card solution that works nicely. What I need is an input system for a touch screen computer, no mouse and no keyboard. The setup that I would like would look like this (interface is already done). When an employee needs to punch in they would hit a button labeled IN. New window pops-up with 10 buttons set up (1 through 9 plus 0). They would then key-in their employee code (let's say 1549) and a new record is made with two fields. Employee code (the one they put in) and a time stamp. Everything works nicely except that I cannot get the employee code passed into the field. I tried creating a variable with a calculation of $$Get(ScriptParameter) - ea…

I've created a database in FM Pro 9 Advanced to pull new information daily from a Tivoli backup server's database. This information is then used for quick reference and reports. There are multiple FM scripts setup to send different select statements via ODBC to the Tivoli database, and the information is stored in various FM tables. As a note the Tivoli database accepts simple select statements but is not fully SQL compliant, and thus TSM tables cannot be set up to act as local FM tables. My problem lies in the fact that I must deliver this database and any updates to two other Tivoli administrators. Each time I do this I have to go through every script and allow th…

i want to know how to color textbox through script thanks

I have a seemingly simple problem with an insert file script not functioning. When I click the button the OS browse file dialogue doesn't pop up. I guess you could say - nothing happens. One important note is that the container field is tied to a related table. For example I have a form from one table called publishers. On that form is a container field from another properly related table called Documents. Using this setup the context ( right click ) dialogue doesn't even show the typical "insert" options. As a test I added the field to the "publisher" table directly and altered the script to insert into the publisher field and it works fine. I'm a relativ…

I have a field with an Auto Entry Serial Number. The field is a text field that uses a number with leading zero's, i.e. "00142" and increases by "1" with each new record request.I need to create a script such that when a record is deleted, the serial number automatically gets reset so the next new record continues where it was left. My trys using the "Setfield" script and adding 1 converts the serial number to a number and I lose the leading zeros. Thank you for your help. DT

I'm stumped at present with the following issue. I have setup a script to add comments to a worklog field adding a timestamp and account name prior to each entry. I have created a secure worklog field that standard users have no access to and made this field 'not modifiable' by standard users. To enable standard users to add comments to this worklog I have created a secondary worklog entry field which combined with a script enters the aforementioned timestamp and account information and then copies and pastes the worklog entry field into the worklog. This script has been setup with 'run with full access privileges' checked yet still does not allow modifica…

I recently moved from FileMaker Pro v5.5 to v9 when I got a new iMac and OS 10.5. In my dB's I had a SetField script that I used after I pasted text into fields from various sources, and the script would set the formatting of that text to whatever the field format was, rather than the formatting of the pasted text. In v9, the script doesn't do anything and I can't find anything in the Help file on the SetField function. This was the content of my script: Set Field (database::Field,database::Field) I had one line in the script for each field that I wanted the script to set. How do I accomplish this in v9?

Hi everybody, I've finished setting up a script using scriptmaker that allows me to send a newsletter to all of our customers with a customized header (Hello Mr. Y, Mrs. X. English or French). All works well, but I do have a bit of a problem. It seems I can only send emails in raw text. The only "html" I can input is a URL that will become clickable if the customer's email client is able to "grab" the URLs from the email and make them clickable. Is there a way to include some html code when sending an email? Something like a flash file that will be hosted on an external web server for example. Here's my current script: Go to Layout [ “email” (email)…

Novice user. Trying to write what is probably a basic script, but I am sooooooo confused. What I would like to do is return a price in a separate field (in the same layout, for now) when conditions are satisfied in two popup fields. These are both text fields, colors in one, sizes in the other(such as 38x97.5). Can someone help me out with a sample, or point me to the best help site for a beginner? Thanks very much

I have a db that we use to track production times. Sometimes there are multiple parts to a job. At this time, I only have a way to track time for the whole job. I capture set up time, run time and clean up time. If there are 4 parts to a job, I need to capture those 3 times for each part. I have created a table for this purpose and am going to create additional job tickets for each of these parts. I now have it setup to create as many tickets as there are parts, but I need to append a letter and number to the end of each new ticket number to reflect that part of the job. So, for example, if the original number is 12345, I need the additional numbers to be 12345 1A, 12345 …

Hi there, I am currently running a peer to peer filemaker database that is working reasonably well. I have one problem though... The host computer is running Mac OS Leopard and Filemaker Advanced 9, the client is running Mac OS Tiger and Filemaker 9. I read that when relative file paths are referred to in a script, if they are running on the client computer it will refer to the Filemaker folder in Applications which is fine. I therefore create a folder in the Filemaker folder called "Temp". When I run a script it exports some data as a PDF and does this fine, saving it in the Temp folder on the client computer. The script then tries to retrieve the PDF…

I am having a problem with a relatively simple looping script. The script checks employee totals for a month; values above a certain amount for an employee are carried forward to the next month. The script runs PERFECTLY when it is local. But when the files are moved to the server and run over the network, incorrect results are often (but not always) returned. In fact different results are often returned when the script is run on identical data-sets just a few seconds apart. Correct results are always returned the FIRST time this script is run over the network. Subsequently, incorrect results may or may not be returned. I have tried placing 'commit' s…

[color:blue]I have a portal on a Work Order form. In the portal are containers that will store job-related documents. The container objects are set up as buttons that trigger a script that prompts the user for information about the file. The problem is, since there are multiple containers, I want to use a variable to reference which container field the user has selected. For some reason, it seems that once the container object becomes a button, it can not be "selected" and therefore the Get ( ActiveLayoutObjectName ) or Get ( ActiveFieldName ) returns nothing. Does anyone know if there is a workaround for this, or maybe I am doing something wrong? Thanks!

Hi, Is there a way to scroll a field ( not the active window) down to a specific location, or to a highlighted section of a note in that field by script ? I am using both Mac/PC FMP 9.03. Thank you in advance.

Hi Group, I'm probably missing something basic but I was wondering if I could get some help on this question. How do I script to "find" an exact match on a find request? For example, I am trying to find SUP-618 but the reutrn gives me: SUP-618 SUP-6180 SUP-6181 SUP-6182, etc, etc. Any help would be greatly appreciated. Steve

How do I copy an entire record (all fields) into the same table? There has got to be an easy way to do this? I want to copy every field from a table and make a new record with that data… an exact copy… Duplicate Record doesn’t work, because the resulting ‘records’ are the same exact instance of a record! I want an independent/standalone copy of the record, so if I delete one the other remains. I am trying to avoid creating a variable for every field in the table, so if later down the road, fields are added to the table, the script won’t have to be changed. Like I said there is probably an easy way to do this… I’m just missing it.

Hi. This is probably simple, but I cant nut it out. I have two layouts, each attached to a different table. Table 1 is client info - eg name, birthdate, other_details, and table 2 is an episode form based on these clients - some fields which are the same - i.e. name, birthdate etc. I want to be able to copy the contents of several of these fields across from the clients table to the episode form in one go. I can copy/paste one field, but need to bring a handful (of field data) across in a single script. How do I do this please? Greg

I am trying to make a script that starts after I enter text in a field. After i click out of the specified field, the script would start. The script would then make certain objects visible, only after the script starts. For example, I type in the field, applicants name. Then, after i click out of the field, a group of buttons become visible, because the script, which just got activated, made those buttons visible. I have no clue how to do this, anything would help. Thanks

I have two tables one of customers and one of staff. I wish to create a script (run by a button) that assigns a member of staff to a customer. The criteria for this would be to assign a member of staff who have the Type "User" (Type is a field in the staff table) , the member of staff should have the lowest number of customers (No_Customers is a field in the Staff table and shows how many customers are assigned to that member of staff) and then if there were a number of staff who had this criteria (ie they were "User" types and had the same number of customers assigned to them which was the lowest number amongst all of the staff) it would randomly pick a member of staff…

I have a question about creating new portal records. I have a button set-up to run a script that will create a new portal record based on the number of attempts we have made to contact someone. If Number Attempts = 1 then a portal record is created that will enter in a date 3 days from now, with the person who is assigned to call, and it prompts you to enter in notes. The main database is linked to the contact database by lead number. I have the following script set-up: If [Customer Log::Rehash Number Attempts=1] Go to Layout ["Follow Up Notes" (Contact Database)] New Record/Request Insert Text [select; Contact Database::Follow Up Caller; "Am…

i'm trying to localize a solution. i put all the literal text strings in a table (one language per record) and use a global field pointing to the language ID to retrieve the proper strings. this works for field labels, buttons, etc, but the problem with dialog boxes is that you can only make their text and header field conditional, but not the text on the buttons. is my only option to duplcate the 'show custom dialog' script step with a bunch of 'if.. then' statements or is there a better way?

Hi I am creating a database (FMP8.5 advanced) for sending invoices to clients. Each invoice has a unique account reference number, a specific date and time fields and then several item numbers with fees. The item numbers and fees are on a separate table and are viewed via a portal. I would like to duplicate the record for that individual, so that I can create a new account, using some data that is repeated from the previous account, like the name, address, date of birth etc but I do not want to duplicate the information in some of the fields eg previous date of service and the previous item numbers and time fields. Should I be looking at a script that …

I am wanting to set up a SendMail scrip where in the body I want it to have both text and insert information from a field of the current record, but am unsure as to how to write this up. If, let's say Table::jobtitle is the record I want inserted, I would want the body to look something like this: Table::jobtitle is now available for you to view for approve. What I thought I could do is write up a calculation that says: Table::jobtitle and "is now available for you to view for approve." When I send the message, though, all that is in the body of the message is a 0. Any thoughts?

Is there a way to lock the scroll function once a script has started? I have a call list that I want an employee to work through, but I don't want her to be able to use her mouse to scroll between records, because I want her to select the "Next" button that records the call date and time. I have taken the status bar out of the layout, when she runs the script, but would like to make it so she is forced to choose the "next" button to move to the next record. Thanks!

I am a novice, so forgive me if I use the wrong terms. Just looking for some guidance I am using version 6 on PC and want to switch to mac. My database structure includes links to 20,000 photos that are not "imbedded" in the filemaker, but are in a folder on my PC....if I copy my data and photos to Mac is there any way to retain the links? or do I have to manually re-link all those photos?

When setting the criteria for a "Perform Find[]" how do you specifiy the contents of a field and not the field name? i.e. Action = Find Records Criteria = PaySlips::Employee: [=fEmployee] fEmployee is a drop down field in my database and I want the search done based on the current value in that field. But all it does is search for "=fEmployee" and finds no records. Where as the field contains a value of "Brian". I just cant find any examples of indirect referencing. Of course if I replace fEmployee with Brian it works but this is not practical as I may have 100+ employees and I'm not going to write a dedicated script for each person. Anyone know how to do this?

I'm trying to write a script that will confirm that several fields are not empty before a print. I am sure this is simple but i am hitting a wall. any help would be apreciated.

Hi all. Firstly apologies- I am new to FileMaker and this may seem like a stupid quesiton. I did my best to find the answer already using the search here, but had no luck.. I have a contact management database, based on the FMP CM starter solution. It has a button to send an email to the email specified, and I have a script to send an email to all contacts in the current lookup. It works perfectly in FileMaker, but in IWP it just does not function. The screen blinks and nothing happens. Other scripts- the report script and label script, function ok. Is there a way I can get around this? Is this normal behaviour or am I doing something wrong? Thanks in ad…

Is there any convenient way to control any of the standard function keys [PF1 thru PF12 along the top row of a standard keyboard] so that I can activate a db script when the function key is depressed?

I have a FMP 5.5 database with thousands of fields. A bulk of them contain a calculated result which defaults to a "No" radio button being selected. Is there some type of generic script loop that would go to each field - remove the calculated result - and have the field validation set to an existing Yes/No value list - then move to the next field? Thanks for any suggestions.

Hello. I'm using the send mail in my script. I made an email but now it's suddenly adding spontanious line breaks which aren't coded. How can I remove these? Or is there a better solution to auto send email?

Hello I have written a script that works (this is my first one so I am rather proud). It is a script that via a button click creates a record and copy & pastes certain info from either fields or value lists from one table to another. A pict of the script is attached. My problem is that it is not very elegant and prone to going mad on occasion. So I am asking my betters to show me how to make it more stable & efiecient. PS. I know it rather basic but we all have to start somewhere.

Hi, I want a script that will search my 8 field names, all numerical, and display the highest one on an invoice / new layout. I am a total beginner, so I thank you in advance!

Doing a database for a fishing tourney. Busting my head. Need some serious help with this script. Boats are chosen with a picker from the Tournaments table as participants. Each Boat has a number of Anglers. Boats and Anglers are related by iD. I created value list of both portals. The Boat list is a list of Boats chosen, and the angler list is a list of the Anglers on those boats. From either or both these lists I am trying to create records in a seperate Table called "payments" related by tourney id. 2 value lists Boat Id's & Angler Id's The Id fields are correct but I need help with looping script. ie: boats …

Hi I hope this is the correct sub-forum for my query. If not please advise and I will repost. I am running an online marketing campaign. I am a mac user. I need to turn the following 2 text documents: 1.Contacted people Lula-Vampiro,nh-last,elenith,Minocula,ey1000high,MissingLight,molo ni,sullivantpaul,devil_lynx 2.New people mickeymouse,Lula-Vampiro,ey1000high,donaldduck,devil_lynx into the following text document 3.New people I haven't contacted mickeymouse,donaldduck Please note that some of the names will have hyphens and underscores. My list 1 will eventually number over 50,0000 with list 2 numbering about 1000 …

Tried to create a find type script stringing together 5 different conditions for 5 different fields together. While using 2 conditions or running separate finds one by one gives me correct answers, trying to write a script for all 5 togetherI get wrong result - sure it is my script writing (dis)abilty. As an example Have a 6 field database 1st field = Customer Number need a script that will give me a listing of all the customers that meet following conditions FIELD(Text) 2 = contains the letter "Y" or is left blank FIELD(Text) 3 = Contains the letters "N" or "P" or is left blank FIELD(Text) 4 = Contains anything but the Letter "Y" (or left bl…

Anyone familiar with calling a DDE command? Here is Link showing FM command It doesn't seem to be doing its thing or no page gets into the que of PageMaster app Do i need to install DDE or something in my App?

Hi I need to be able to run a script that can search for a representatives work that is still unpaid and then sort these records by customer. This then needs to export pdf's showing individual customers outstanding work that I can email out to each customer. I have a script that can find all the work but it does not separate the PDF's into individual customers. Any Ideas

I have created a FM database for my world coins and I would like to keep a "running total" of all the different countries I have. Is there a quick script that I can use to have this displayed on a page? Thanks

Does anybody know how to get around the problem of accessing tables with names containing spaces? Usually, I would use ` character to delimit the name, however this does not seem to work with "Execute SQL". I cannot change the table names as it is Microsoft Dynamics : Thank you. Garry