Script Workspace and Script Triggers

Users work in Credit Memos in a new window. I want only a Close button. I want the script to test that each piece is done and branch depending upon the results. A Memo can't be Approved until it is Finished. It can't be Processed until it has been Approved. If everything is done, I want the window to simply close. As I list out the script, I realize there are many ways to write it. But I want elegant and I keep getting twisted in Else If[] and how to group the steps. Psuedo-script below: If [ Finished and Approved and Processed ] Close Window Halt Script Else If [ Approved ] Show Custom Dialog [ No ; Yes ; "Memo hasn't been Processed. Do now?"…

Hi, Probably a silly question... but still, why doesn´t the sliding option works every time? I have a big text (it's a contract) and it has lots of fiels in the midle of it (some are numbers, others text). All of them are with the sliding option on (sliding left), but they don't work all! And some of them are exectly the same... Thanks for your precious help. Teresa Sorry, it seams i posted it in the wrong place...

I have a simple script that goes to a container field that contains a sound and "select/perform" the field. In Windows it works fine but in OSX it does not. Any ideas? Greg

Dear all, I have searched alot to find a solution where In Stock QTY, gets automactically deducted after sales invoice has been raised etc. I came to this thread http://fmforums.com/forum/showtopic.php?tid/184927/ I downloaded the solution and studied it. I tried to implement the same solution in my database, but it doesnt work! I am attaching my solution. (You can login as Guest - with Full Access). I really really hopeing somebody could take about 5-10minutes to look at my solution and show what is the problem. I feel its a very minor problem. I am stuck on this problem for about 3 months now, so please please please help. Than…

Hi, I'm working on making a script to auto number fields in each row of a portal. Because of the way that we want it to print there are two portals. The first is 1-15 and the second is 16-30. I have been successful in auto numbering the first 1-15 but when I can't get it to go to the second portal to continue numbering. I've attached a template. I labeled in the code where I am stuck if you go to the script maker. To see what it does click the button and then enter a number higher than 15. It numbers 1-15 beautifully but not anything beyond 15. If anyone has any helpful ideas I would gladly accept them. Thanks js22 2_Portals_Script.fp7.zip

Hello all, I have this script (code below) that works, but I can't figure out how to get it to run using a customer as the search base. When this script is run I need it to do the script based on the current customer being billed. Thanks Dave

Hi and thanks in advance. I have a script which requests the user to type a date. The date is typed into a global date field. My problem is that, unlike typing a date direct onto a layout, typing it into a custom dialog doesn't check that the user has typed an actual date in e.g 3/112/2007 etc. My question - how can I test in the script whatever they've typed to see if it's a valid date or not. Thanks in advance.

hi, having trouble with a unique value, where the script assigns a new member id # on new record. we have only 2 users; when they click on the Add New button, they are getting the error message that the Memeber ID is already being used. the last id used is stored in a field called LastIDused, and is incremented by 3 after each new record. if [memberS::new_member_number] Exit Script[] Else Insert Calculated Result [select: MEMBERS::new_member_number; "C" & MEMBERS::LastIDUsed] Insert Calculated Result [select: MEMBERS::LastIDUsed; MEMBERS::LastIDUsed + 3] End If any ideas or a better way to do this? thanks in advance, rog

Hi, It's kind of difficult to explain, but I'm trying to find a good way to insert text (current date) into a field called details. What I have now is that sometimes the field can include on top: Bumped from 3/14/2007. Here the text begins,... Now I'd like to insert text (date) between those lines, so like this: Bumped from 3/14/2007. Robin - 3/16/2007. Here the text begins,... I tried to find a good way to insert it into this place, but it's difficult since the top date after "bumped from" can change, month can either be one number (1-2-3-...), or two numbers (10-11-12), so I can't base it on a fixed number from the left eithe…

I have raw data in a table that looks like below. Machine..Start.....End 132b.....11:32.....13:53 132b.....14:24.....15:17 132b.....15:39.....16:12 142a.....10:45.....11:16 142a.....11:23.....13:54 142a.....14:14.....15:17 153b.....09:08.....10:11 153b.....11:19.....12:39 153b.....14:21.....15:07 What I would like is a script that will loop through all of the records and then grab the first start time and the last end time from each group of machines and then place them in a global field (I think) so I can calculate the total time the machines were run on any given day. Machine..g_start..g_End...Elapsed 132b.....11:32....16:12...4.67 hrs…

I have a list of records in Browse Mode (FM 8.5)and wish to create an A B C... listing on the footer so that when a user clicks on say... "C" the script will list immediately and moves to the first occurance of an Upper(Left([fieldname],1))="C" etc. etc. and redisplaying said records from the top of the screen. Would appreciate any ideas as I am still banging my head with some of the new elements of this version. Roy B

Sorry, I think I posted this in the wrong forum earlier - Can anyone help me with serializing all my existing records? I created a field, and set it to auto-enter serial numbers starting with 000001, but unfortunately this doesn't work for existing records. Is there a way to "trigger" the auto-enter serial to do it's magic on all existing records? Thanks! Chris

I have a client who makes acoustical panels. There are only a few sizes of the blanks used. What I need to do is to chop up a blank into pieces to get what their client ordered, then figure out what waste pieces would be left over. For example, a client orders 2-48x48" panels. These would come out of a 4x8 panel (which is actually 49x97). The waste would be 1-1x49" piece and 1-1x96" piece (I want to get the width first, as the scrap is more useful later). In this case the waste is unusable for anything else (but they still want to count its square footage). In other cases the waste piece might be assigned to another piece ordered. That part I can do, as it's r…

Does anyone know if it's even possible to create a script to fill in web forms? I guess it would be something like roboform, but it would be inside of filemaker. I have been looking all over for a solution and can't seem to find any data on it. Any help would be greatly appreciated! Thanks Michael Moshkovich

Using the send email script step it seems you can only get one carriage return at a time, regardless of how many ¶'s you put. Is there a way round this?

Hi, I have a quick question. I moved from Access to filemaker and I was wondering if there was an equivalent function. In access when you program in VB you can hit F8 and it will work through your code step by step. It made it really easy to figure out where your code is going wrong. Is there a way to work through your script step by step so I can figure out where I need to correct or specify the script to make it do what I want? Thanks js22

Hello, I am building a subscription database for a quarterly publication and need to be able to identify records for expiring subscribers. The database contains a field for ending issue but the issue is identified by season and year ie. "Summer 2007". How can I specify that "Summer 2007" equals a specific date or date range without renaming the values in the field? I am trying to create a script that will identify only expiring records. Please help if you can, I am a graphic artist & web designer by trade and this database stuff is new to me.

I was wondering if there was a way to lock a record (allow no more changes) via script or checkbox? We have quotes and invoices which are editable by permission, but once the record is closed, we want to not allow any changes to be made (except by master password).

Using FMPro v7 and Mac OS X Tiger... I have a client database, one of the fields is the client's email address. I want an easy way to be able to view a client's entire email history. What I want to do is to be able to send a search from FMPro to Mail.app on the email address in the "email" field. I don't need to import the emails, just be able to click on an "email history" button in FMPro and be sent to view the results in Mail. How can I accomplish this? -=[ Grant ]=-

Hi all, I'm new here and to Filemaker, hoping someone can help me out... I am trying to analyze the results of a couple hundred surveys. The results of each survey are stored in a single record of a single table. What I want to do is perform calculations involving all the survey results, and I need to do things slightly more involved than simple sums and counts (more advanced than what you can do with a summary field, in other words - at least as far as I know). For example, one question might ask if the person plays soccer, football and/or baseball, and another ask whether the person lives in Toronto, Austin or Los Angeles. I want to be able to figure out thin…

I need to script that Imports a picture from a network share into a container. I found the "Import Picture" script step and it works great when I enter the whole string such as imagewin://Home-dc/ShareName/RealFile.jpg But it's a lot quicker to do it manually than have to type that novel out every time. I haven't figured out how to replace the RealFile.jpg with something like FileName&".jpg" that will get the name of the file from the value in a field named FileName.

I have a bunch of data in my database which is full of 's which I want to get rid of. I tried using Substitute(mytext;"";"") but scriptmaker got confused. Any other way of doing it?

My 8th grade students have elections for the school superlatives. They vote on most popular, most academic etc. I have already created the database that we will use for the voting. What I need is a what to tabulate the votes. I am not sure how to go about it. We have 15 categories and they will select a boy and girl for each of the categories. I would like to be able to see who won each category but I don't exactly what the script or calculation would be. If I could view the number of votes each student got for each category that would be even better but what I really have to have is the winner. Is there any easy way to do this? Hopefully I made it cl…

I need help writing a script that If Field A = 0 then Field B will auto fill with No (Field B is a pop up menu with Yes, No & edit) Can this be done?

I am a newbie to the forum, but I have been developing in FMP for years. I wasn't sure if this is the right forum for this question, but here it goes. Is it possible to script an e-mail with a url link to a specific record within a specific file. For example, I want to script a button that will send an e-mail to the contact from the current record with a url that would take them to a specific survey record. The survey would be shared via instant web publishing from FileMaker Advanced Server 8.5

Hi, I've a database that stores various calibration certs. What I want to add to it is the next due date, based on the last test date plus the frequency. ie. 1 month, 3 months, 6, 12 etc I've tried a few things but haven't found anything to work yet. Thanks in advance, Skip

Hi all A picture is worth a thousand words, so I have attached a sample file to explain what I would like to do. Thans in advance Lionel symbol.zip

I have a script that gets the current date, adds 7 to it and then displays all medical appointments in the database that fall between the current date & current date +7 days. The script is working great as long as there are appointments that fall in that range. If there are no appointments it gives me a message that no records can be found, puts "3/12/2007...3/19/07" (the range it is looking for) and most concernsing, when I try to enter Find Mode in different layouts, I get booted out of Filemaker and have to restart it. The current script is as follows: Enter Find Mode [] Go to Layout ["MedAppTick" (MedAppoint)] Set Field [MedAppoint::MedAppDate;Get(…

Hi. Got a database that tracks shopfitting installations for various store groups, various brands, that are all at various stages of development. What i am trying to do is perform a find manually by brand, store group and then 'current' projects. I then want to be able to run a script that will extend the found set to include 'on hold' and 'proposal' projects. The problem is that the script then includes all other brands as well, it is not using the origonal search criteria. i know it works if i do it manually, and i have tried to follow these steps within the script - ie modify find and then extend found set Any ideas?

there is a main filemaker database, when startup, it must perform a script from other filemaker file,the second has password because it shouldn't open lonely, but when the script performed from main file, i want to login to the second without any dialog, and i want open it with script, and write its username and password manually in startup script. how can i do that?

No doubt this has been addressed before but I can't find it. Will someone point me to a "user friendly" script for a data entry validation failure. (504 error capture. Custom dialog. Choice, allow or abort.)

Any way to have FM do a lit search in Pubmed (or other reference database) and then import the results (i.e., article title, abstract, authors, year etc) into FM fields?

To whom interested for: A big and crucial problem in educational databases with Filemaker Pro 8.5 is also the changes take place at every school year. I think that many teachers or educators met this problem when they have tried to build a big educational database. I think that is challenging for every programmer to do this if they have laser time to spend. Problem There are six classes in elementary school. How to change the year of the whole database with one button and do these consequently: 1. Delete the students that have graduated from the School. 2. Copy all the left students. 3. Change the class of the students in the higher level (exampl…

The email script does all the perimeters, subject email address... But the attachment shows up in the message body before the message text and the text is not formatted, no bold or italic. I am Mac 10.3.9 FMP 8 using Apple Mail. Please help Thanks Joe

I've burned a standalone runtime application to CD-ROM and would like for the end-user to avoid having to put in a default username when the application first opens. Is this possible through scripting or through configuration of file options prior to creating the runtime? It's evident that I'm a newbie. Thanks in advance.

Hello Everyone, I am trying to clean up a database I inherited and am starting with some of the scripts. I'm currently creating some reusable scripts. They seem to be working until one of the finds in the reusable script returns nothing. The script appears to finish cleanly, except that it will not set fields. The "Run" script fails when the script reaches the "Corporate" section. This correctly returns "0¶0¶0¶0" because there are no matching records. However, the "Set Field" script steps that follow never seem to execute. I can add other steps that will execute properly, but "Set Field" steps will not. When the "Run" script reaches the "Customer …

Hi, newbie here. great forum, lots of useful tips. Been using it for a while now, before taking the pludge to join in. I've come across a problem, and I don't know how to solve it. Does anyone know a script that will check the value within a field and then change the background color to say red or green depending on whether the value is a positive or negative number? Any help or advice greatly appreciated.

Hello. I have a database with a Users table. In the Users table there are fields: ID, name, acct (simplified for purpose of example). The field "acct" contains the same name as the account that the user will log in as. Throughout my database, the users are related to records in other tables through the ID field. There are times when a user will create a new record and the user's ID needs to be recorded in that record. I would like to automatically insert the correct user ID into a field of a newly created record based on the account that they are logged in by. It seems like it should be simple, but I cannot seem to find a good way to do it. I know about the get(…

I need to parse a date from a field. Unfortunately, the way it's entered is not consistent. It's always in MDY format, but somtimes it's M/DD/YY or MM/D/YYYY or MM-DD-YY, etc. What would be the best way to parse all of this data? This is on FM5 Thanks

I am writing a program to send email campaigns. I have edit boxes for user to enter subject, body, and a container to insert an attachment. The send mail script works for subject and body but how do I add attachment to message? I have tried to use a variable for a pathname, but I must be doing something wrong. Is there a way to attach the container field directly like the subject and body?

Hi all My welder db will insert a drawing of a weld symbol into a calculation field designated as a container field. The weld symbol drawings are all different in style. I would like to add some information to the weld symbol before inserting the weld symbol into the welder db. My first instinct is to add some fields into the container fields and completed the information there but because of the configuration of the weld symbol the fields would need to be place in different location for each weld symbol. Is there a way of scripting placement of fields? Thanks in advance Lionel

Hi Finally got my db up and running over the last 2 months, now reviewing a few staff comments. Have had a think around the following areas, but having difficulty working things out. Any ideas on what to do or where to look for further info is greatly appreciated. 1. problems navigating from project list layout (table), to job sheet layout (form), to time billing layout (tabs). I am using job No. as the common factor ( on all 3 layouts- auto fill), and button scripts (Go to Layout) to navigate. There is a tendency for wrong job no. to occur on time sheet layout, but not project list or job sheet layouts. does anyone have any idea why this may be happening? My only …

Dear all, I'm relatively new to filemaker and I'm having some syntax problems trying to make a script. I'm trying to perform a find on a range of records by a timestamp field. I have a custom dialogue which prompts the user to enter in the start date and end date and then I'm using a insert by calculated result script step to add times to both the start and end dates (I don't want the user to have to worry about entering a time) which are then placed into the timestamp field. The problem I'm having is that I'm getting an extra :* put in the timestamp field I'm performing the find on. The insert calculated result script step is as follows: (Sessions::E…

I am putting together a simple calendar and i'm having trouble scripting a button to advance my global master date field to the first day of the next month. This field will only have the date of the first of any given month. My first idea was the following script using another field "gMain Month" that is a calc to give me the month name based on the "gMain Date" field: If ( Calendar::gMain Month = "January" ; Calendar::gMain Date + 31 ; If ( Calendar::gMain Month = "February" ; Calendar::gMain Date + 28 ;If ( Calendar::gMain Month = "March" ; Calendar::gMain Date + 31 ; If ( Calendar::gMain Month = "April" ; Calendar::gMain Date + 30 ; If ( Calendar::gMain Mont…

I need some help. I am working in FM 8.5 on a Mac. I built a script that I now want to delete. When I hit delete and then click delete again, I get a message that says: "script can not be found or has bene deleted", BUT, it has not been deleted and nothing I have tried works to get it deleted. How do I get rid of it, or find the preference file and remove that, even if it gets ride of all of them. Please give me some advice thanks jack

Hi can you use a variable to specify search criteria in the perform find script step? Or in the enter find mode step? I may be silly but when I select the field to search and put the value $source in looking at the data viewer $source shows the value of 1234 but the field in the dataviewer when set in that script step is returning the value $source not 1234. Any ideas or am I barking up the wrong tree? I would have "Ahem" assumed that what I am trying to do is a little 2 script step time saver over the conventional... enter find > set field from variable > perform find, process?¿

Hi all. I have a small but infuriating problem. I have a script that sits in Find mode waiting for the user to scan in a barcode, once scanned it does a new find request and loops, doing it all over again. Once the user is happy they press a button on the layout and the current script exits and it goes off and finds the various barcodes. Great....except that the person doing the scanning can be up to 30m away using a bluetooth scanner, and so the terminal is prone to another user coming up to it and pressing the buttons (despite big warnings all over the screen!), losing all the finds done so far and generally mucking it up for the existing user. What I'd like to …

Hi People I hope someone can help me, I have been using Filemaker of and on for a few years but mostly basic stuff. I am currently working on a system which can print purchase orders. I have a file with one table in it at the moment. The table has a few fields such as Job Number, Product Code, Product Description, Qty Required, Line Total and supplier. The problem is that the user will enter all the items to be purchased for a particular job, which can be ordered from various suppliers so the user fills in the supplier field from a drop down box. Now what i want to do is have a script go through the table and print off a seperate purchase order for each supplier…

I need a script that will omitt a record from a layout, if (Field XYZ = 0) Then Omitt those records...via a Go To Layout Button. Can anyone help me with this? I've tried to figure it out but no luck.

I am trying to create a script that will bring me to a related record from another table and layout. I have a personnel table and an employeefunding table. On the employee funding report layout I'd like to be able to click a button next to a funding record and go the the Personnel layout for that employee. For some reason I can't make it happen.

Windows 2000; FMP 8.5 Advanced Problem: SEND MAIL script step Main Database is on a server being shared not served (But only one user as I run this script) Fields: “SSSDB E-Mail” Text “SSSDB::EMailAddressContainer” Global Text I run the following script Perform Script (“QSS List”) //gets fond set - 364 records Constrain Found Set (Omit Records: Criteria “SSSDB E-Mail: “=”) //eliminates 3 records where email addresses are blank – down to 361 recprds Set Field (SSSDB::EMailAddressContainer;””) //initializes global field to be empty Go to Layout (“For Mass E-Mail”) //has the EmailAddressContainer field on it…basically to…

Hello, I've got a major problem! I'm very new to Filemaker. I am making a database with Filemaker 8.5 (standard) and need to track peoples attandance every week. Every time a customer visits, a tally should be added to a counter, keeping track of their total number of visits by date. I would like to set it up so that I could, for example, pull up the membership records for any given month and any given indivudual. I'd like to see how many times they've attended and what dates they've attended. I've experiemented with setting it up using a text and also a calculation field, but so far I haven't been able to get anything that works. If you have any idea on how to c…

I always end up with too many open windows and would like to write a script which would close all but the same two windows. I have been trying to use the window names returned by the windownames function as variable to do a loop which would close one window after the other except the two I want open. I can't figure out how to assign the result of the windownames function as a variable. The variable should then be assigned to the SelectWindow function. Thanks for any help yknot

I am trying to combine two tables into one for a project. I have two tables (spanish and german). Each table consists of two fields term (english word) and translation (translated word in the respective language). Instead of having the user go to two separate tables to perform a spanish and german word translation ([color:red]performing a find on the entered english word then display the translated term for that record[color:red]), I would like to combine the two tables into one (no problem with that) and using a layout among other things to make a selection via perhaps a toggle to determine whether I wanted the word to be translated into German or Spanish. …

Hi, Could someone please help me on this.. I have 3 field with a repetitions 1-10, and i want to create a botton that will copy the texts of that 3 field into an other layer/field with a proper format I tried Set Field [textbox2; textbox2 & ", " & textbox1] but the result really messy and and it not work with repetitons 1-10

Some of our users are on a Mac and some are on Windows. I've got a script setup that includes an Export Records step. On Windows machines this isn't a problem because I can save it to filewin:/C:/filename.tab No matter what computer you're on (windows) this will work because the drive letter is C:. I know it's possible somebody could have changed their drive letters, but that's not likely. My problem is on the Mac side. The format for export records is filemac:/VolumeName/filename.tab The problem here is that many Mac users change the name of their drive to something else and there's no way of knowing what it would be for any given user. Is the…

Hi all, I've got a script that exports some data. I'd like to do a calculation for the file location / name. The name will vary with each export. I know there's a way to do it with a script parameter, but I can't quite fiture it out. For example, I want the export location to be: "filewin:/K:/Technical Services/E911/" & "test" & Location::julian_dt & ".dat" How do I perform the export records step and use a script parameter to force the location?

In FM6 I had a database that simply had scripts to open files. The same scripts opened files on the host or the shared machine. In FM8.5, I get strange results; on the host machine, it seems to open multiple windows of the same database. On the client machine, it sometimes opens without problems, sometimes refers me to the Files/Open Remote. Can anyone help? Do I have to have different scripts on host and client machines? If so, retrograde?

I've been trying all day to get my database to execute a shell script... I originally had this process working with applescript but filemaker server wouldn't run the applescript, thats why im trying to use shell scripting. the shell script works. I typed it in a text doc and dragged it into a terminal window hit return and it executes. but no combination of options in the 'Send Event' script step would run the shell script. I tried it sending 'do script' with 'document' and with 'script text'. I also tried making an automator action into an application that just runs the shell script, but choosing that seemed to do nothing, target application was still…

I am very new to FM, I am using FM 8.5 advanced I need to integrate SQL Server and FM. I did some research and found out that It is possible to execute SQL stored procedures from FM . My question is how to handle outpouts from stored procedures, if my stored procedure is returning values or recordset , how do I populate in FM ? It would really help and avoid duplicate coding if I call the same stored procedure from SQL server. Thanks

I have a couple of situations where I use Send Event in a Script to allow users to select files or folders. I do it by having the Send Event trigger an external script. Where I run into trouble is that the Filemaker script wants to just keep rolling along rather than wait for the external script to finish. Workaround I'm using is to have a custom dialog pop up right after the Send Event, and it sits there until it's OK'd. Is there a better way? Seems like it would sure be handy to have Send Event switch that tells it to wait for something to come back from what's going on outside. Maybe there's some kind of loop that would work? But can't think of how. I'd l…

Hello, I'm trying to setup a script so I can Set the value of a field that is on a separate layout. But first I need FMP to search if the value I'm going to use alredy exist on that table. The application is for a PO-Inventory system. My situation is such that I need to track expiration dates of a product, as well as its location, and quantity in stock. We have multiple locations, and normally these items are bought in batches. Items in a batch has the same expiration date. I've setup a PO, PO Line, Product, Batch, Location and ProdBatchLocation Tables. (Diagram attached). The area I'm having problem with is inputting values from PO Line to ProdBatc…

Hi there. I've recently done a course in SQL query language and wonder how I can use it to advantage with internal querying of a database. I don't want to link externally with other databases but it seems a powerfull language and I can't seem to get any joy when I request it for a script or scripted button. Surely ODBC is only necessary when linking with an external data source. there's very little info out there and the FM Users guide says next to nothing.'

Hi, I currently have a system that stores customer names and associated projects. My client has asked if each customer could have a serial number after their name - which would make up that particular project ID. For example; Customer Bob - Customer Bob-001 Customer Bob - Customer Bob-002 Customer Gill - Customer Gill-001 Customer Gill - Customer Gill-002 Can I automate this so that each customers project ID starts at 001 on creation? And add the functionality of when new customers are added to the system they each have a number assigned to their projects starting from 001. Hope this makes sense... it's driving me a bit insane!!! C…

Hi, My database contains details of several hundred scientific instruments. Each instrument type has a folder that contains subfolders such as manuals, correspondence, repair info etc. I have created tabbed folders and portals to display this information but adding the information is very tedious and requires two operations. First to place any new documents in the correct folder and then to import the file into the relevant portal. What I would like to do now is to scrap the portal idea and just have fixed text strings that show the path to the documents. By clicking on a text string (button) I want to open a new window with the correct folder opened and the do…

I'm trying to write a script to loop through records in my Project table, and for each project, print a report of the related records (from a different - related - table). How do I make my script account for the instance where no related records exist? (i.e., if no related records in table B, loop to next record in the Project table) It doesn't seem to be an "error" per se, so I don't think the get (lasterror) function will do the trick (that was my first thought). ~Courtney

I have developed application for small colleges. What I would like to do is Example: In the form that handles students admission (Student table), to open this same record in the form for Job Placement (JP table), using the social security as the key match element. This script could be triggered by a button. Now I need this script to verify that this same social security is not already exisitng and to open a message of some kind to notify the user that it already exists in the other table or that it opened it should it not already exist. Thanks in advance

Hi all, I'm using FMP 8 with server Advanced. I have two tables that are mirror copies of each other. I do a SQL call to update table B. Once I'm done, I want take a found set from that table and copy those records to table B. I'm not quite sure of how to accomplish this in FMP. Again the table structure & fields are exactly the same. Any thoughts?

Hello, Not sure I have the correct part of the forum. I want to be able to generate a serial number by clicking a button and I'm not sure of the best way to do this. I tried it by using a separate layout that holds just the primary key and is serialized, but I think there must be another/better way that I'm totally missing. Please help? Thanks Dave

I know that FileMaker has the ability to email straight from the program, but I'm looking for something different. I'd like to send the contents of a particular field to a new message in Apple Mail (preferably with the Subject and To fields filled out in the Mail message). Is this possible? I just need a push in the right direction (not very good with the scripts). Thanks

Hi i have a project on the go which i need a script for, its a complex process(at least i think its complex). What i need to do is this, i have a work order for a contractors office which once it is filled out i need the following to happen. when the work order form is completed, the information should then be placed in a clients database, an email will be sent to the project manager, as well as an sms message to inform the PM that a work order is in their inbox, i also need file maker to automatically go to various websites to perform ceredit checks, background checks, the result of the checks will cause a decline or acceptance email to be forewarded to the new cli…

Hi All, I hope someone can help with this script as it's driving me crazy. My script has a custom dialogue box hat allows the user to enter the number of days the part is going to take to arrive and then set the EDD or Working Days EDD based on this. The EDD works fine but when I try to use the WD EDD the value entered is not passed to the No: of Days Field so no value is set. I'm not sure why as both script sequences are pretty much the same. I've attached a sample file, Thanks Peter :-) Test.zip

Dear FM experts, In a given script we have a variable before to save a copy of a file, in order to specify the paths that a file should go. How can we display previously a dialog: "Do you want FM create directories for you if they do not exist?" How can we make the script to create these directories if they do not exist? Pascal

We want to assign a script to a button that will change the color of text in a particular field. We would have a number of different scripts for assigning different colours. Can this be done using a script. thanks

Whenever I run the following script, FileMaker freezes, and sometimes shuts down. Go to field [Catalog Number] Relookup Field Contents [no dialogue; Catalog Number] Catalog number is a unique value only field. At times we have had to re-create records that were deleted. When I do enter in information, I get this error: "Catalog Number:" is defined to contain unique values only. Allow this duplicate value? I do not understand how it is a duplicate value. I searched throughly for those missing records. I think my script problem stems from the duplicate value problem in the "catalog number" field. I'm still a novice with FMP, so any informatio…

I am new to FM scripting and am at present converting over some old dBase programs and have a problem. I wish to import a file using details already stored as global variables, that is, the file path is in one global field eg. (C:folder1) and the filename in another (eg. file.csv). I have no trouble importing the file manually into FM but using the Import Records command, scripted, I can't find a way of making it refer to the path and filename using data from the pre-entered global fields. There appears to be a path & file choice but that only locks it into a specific prenamed file. I hope my explanation is clear enough. Anyone help?

I am using the insert file function in a script. In the specify source file I have entered a variable. Before the insert file function is executed I set the variable with data from a field. If the file exists the file (or in this case the reference) is inserted into the container field and all is well. If the file does not exist an open dialogue appears. Is there any way to prevent this. I do not want the user inserting a file that does not belong in there. Error trapping will not work. The only thing I could think of was to add a second reference in the specify source file to an empty file. By doing this if the first file does not exist then the empty file is in…

I to all! I need some expert help! I have a database, and i need to lock some records, (entire records), with a script,geting acess to the record again with password. Thanks in advance for your help!

I'm definitely a newbie at FileMaker but am extremely excited to learn more and more. I'm going to start with an embarrassingly simple question. I've created a "client & project" database with a layout that contains a container filed. I've inserted a reference PDF file (the project estimate) into the container field. Here's the embarrassing question: How can I set up a script that lets simply lets the file open when I click on the container field? I can get it to bring up a dialogue box that asks me where I want to save a copy of the file, but I don't want to have all these duplicate files on my desktop that I'll just end up deleting later. Thanks so mu…

If in a layout I have fields that have drop down value lists or calendars, how do I get them to display automatically when I script goto[field] and pause the script for a selection or response?

I wan to create a basic appointment tickler that will pop up when a medical database is first started up. I would like a layout to pop up that lists the appointments from the current date out to 7 days from the current date. I was told I might be able to do it using something along Get (CurrentDate)...Get(CurrentDate)+7. Is this done with a startup script or with thhe defining of the fields in the layout? Can anyone show me how I would write a startup script that would make this happen? The table with the medical appointment data is called MedAppoint. The fields I want to show are MedAppName (name of person the appointment is for), MedAppDate (date of t…

hi I am only a basic level filemaker user so I am not very good at scripting. I have a database of about 200 journals all published varying numbers of issues per year - Each issue has its own record with dates for each stage of production. I need to create a layout which shows me the date the last issue of any particular journal was published and the date the next issue is due (each issue record has fields for these dates) but my problem is how to make a script which shows ONLY the dates for the last one published and the next one due - ie I can't work out how to do it without including every issue published in a year - some have 12 issues a year. I would be gratefu…

A general question about FM scripts. Is it possible a script run automaticaly if FM reaches a specific date instead to assign this script to a button? Pascal

I have a photo database which has gotten quite large. I import new photos to the file daily. The location of the stored photos on my hard drive never changes. To conserve space I would like to import the pictures as a file referance only. My problem is when you import a few pictures from a folder that contains 10k pictures it is quite time consuming. Is there any way I can script filemaker to import only the pictures that were created the day I want to do the import?

I want to show emails from inbox folder in outlook that are related to contact on my contact detail layout. Is it possible to write a script to get emails from users inbox then show emails related to contact in a portal, do I need a plugin to get those emails from outlook? Is there a way to write a script to import emails from inbox?

I know this should be simple, but I'm a complete beginner. The Sellers layout (form view) displays a record from the Sellers table (3 fields: SellerID, Address, AuctionDate). The form has a button linked to a script that takes me to the Lots layout (table view). The Lots layout displays the Lots table (4 fields: SellerID, Price, LotNo, LotName). The problem I'm having is this. I only want the lots of the current seller to be displayed - if the current SellerID equals 46 (Sellers layout) I only want the lots with same SellerID to be displayed on the Lots layout. What code do I need to use in my script to achieve this? Thank you for any help. d…

Hi I'm trying to run a script whenever I enter or leave a record, but cannot find a way to do it. Any ideas?

Hi, First, thanks for any help I get in advance. I have been playing with Instant Web Publishing. It's pretty cool, and I've been playing with the Open URL script step to jump between database files. I was just wondering - it seems like the default behavior for this step is to open the link in a new browser window - would it be possible for the link to be opened in the current browser window? If so, what switch (or parameter) would I pass in the URL? Thanks, Doc Tree

Hi I am trying to add a bold button and a red button above a text box. Just want to highlight text and then bold it or change colour to red. But only the highlighted sections. I have followed links, and tried stuff. But just can't do it! This is becomming detrimental to my health! If anyone has done this already could you possibly post the actual scripts? Would be very much appreciated. Trevor

I'd like users to be able to click a button that takes them to a folder where they can select an image file and then have it inserted into a field in the database. I've got a way to do that now that involves using Send Event to run an AutoIt script ... which grabs the path name after user file selection and stores it on the clipboard. Then my FileMaker script plugs the clipboard into a field and uses it in a variable to provide the path for an Insert Picture. Well, this works OK I guess, but is there a better way? Seems like Send DDE Execute would provide a better route, but can't find any info on how to do that. Anyone know where to look?

This more or less a feature related question for FM: Is there a way to ensure that a record cannot be changed once the data has been added to its various fields by script or other means? Thanks:)

I would like my fielmaker v 8 database to open with the view of 150% and to keep this size

It turns out I am terrible with Filemaker, so I'm hoping someone can help. I have a database that will be used by several people and so I want to make it dummy proof. For each of two tables there is a layout, so I use "layout" to refer to both a new layout and table in this description: On layout #1, I have a button that, if clicked, should switch to layout #2 and 1) create a new record if the ID field in layout #1 does not exist in layout #2, or 2) go to an existing record if that ID does exist. Thus, there will never be more than one record in layout #2 for each record in #1. Hopefully this makes sense. Any help is much, much, much appreciated!

Hi Guys, I'm still confused out of my head about this option.. If it is checked, will the script be able to access all fields even if access to those fields aren't available for the privilege set running the script.. The same question re importing / exporting etc. Cheers, Alex

I need something like a constant global. The following takes place in a peer to peer setting. We run a script twice a year in which a global field’s value is updated. That value is then used in a calculation by several thousand records until the next update. The updating of the global field is the last step in the script. In order to insure that the value remains constant across the network and user sessions, after the script is run and when no one is on the network, I will re-enter the value on the host computer in single user mode, close and open the file. Resetting it manually is not a big deal but I was hoping there might be way thru a script to set a global value tha…

Hi all, This one had me stumped. If you open the attached file and run the script named "caller" you will see that only one value is being assigned to the repeating field named "ScriptVariables". Is this a known bug ? is it by design ? limitation ? ... or ? test.zip

I'm approaching this as a Scriptmaker issue, but it might be a Relationships issue... I want to compare data in two fields, in two Unrelated records in two different files, prior to importing from one file to another. At the start of this process, File 1 will already have a single record in the found set. (I have scripting ensuring that.) One of the fields, "Business Unit", has data ("Consumer", "Industrial", or "Geos"). In File 2, a script imports an Excel-type file into File 2 (adds new record, then makes doubly sure only THAT record is in the found set). File 2 also has a "Business Unit" field, and it will receive data (one of the same three choices) from the Exce…

Main question How can I put a index from a field in a variable (comma separated) for using for viewing those as possibilities in a custom massage box? A have now made a script with a loop starting by record 1 exit by last and set a variable by the following calculation : $$revision & "," & VN_xx_type::Revision. The problem is I can not avoid a duplication in the output string. For example : Record nr. 1 2 3 4 Field [File] A A B C Field [Revision] 01 02 01 01 The contents of the variable after performing the script will be : 01, 02, 01, 01 and I want have : 01, 02 Is there a simple possibility ( an…

Well, I have exhausted the instructional sources I have access to on this. I can't find anyway to prevent a script from executing all script steps before taking any values for the fields in a new record. This is a problem as I want to use some of the new record's fields to add to a matching new related record in a related table portal. First enter main record, then create related record in the portal with some shared information automatically transfered. Problem is the values are placed into the new related record's fields before the primary record is even filled out. Of course this means blank fields in the new related record. I have tried using the commit …

Does anyone know of a way to go to a field by calculation. Here's the short story. When someone enters a drop down menu field, the drop down menu appears. If the user clicks inside the field the drop down menu dissapears. The user says "oops, I didn't want to do that, I want my drop down menu back!" The only manual way I've found is to click on another field then click back into the drop down field. I've tried a script which I initiated by making the field label a buttonGoToPreviousField...GoToNextField) Which works sometimes depending on tab order. Any Ideas? Thanks, Mel