Script Workspace and Script Triggers

Hello, All }:| I have tried to make a little test app for FMP's realtime functioning. It's an Alarm Clock. I have 4 fields called Hour(Number, Global), Min(Number, Global), Sec(Number, Global), and Count (Number, Global). I then set each field to the Hour, Minutes and Seconds for which I want the Alarm to sound. Say: 01, 24, 45. I then have the following script: Set Field [ AlarmClock::Count; 0] Loop Exit Loop If [Get ( CurrentTime ) ≥ GetAsTime ( AlarmClock::Hour & ":" & AlarmClock::Min & ":" & AlarmClock::Min)] End Loop Loop Set Field [AlarmClock::Count; AlarmClock::Count + 1] Exit Loop If [ AlarmClock…

I have LOTS of scripts... about 100. I have forgotten which script handles a particular error routine. The error happens randomly and I can't reproduce it. I know the error number that it displays on the screen. I would like to search my scripts for that # (it is hardcoded). Does anyone know a way to do this?

Hi, I'm working on a database for the lab that I work in. Because reagents and procedures change frequently I have set up the database using 4 files. Each houses various information that contributes to the overall record. My question is scripting between files. I have a button that is scripted to open another file. Once open I need it to go to a certain layout in the new file. I can get the 2nd file to open without difficulty. But I can't get it to go to the certain layout I want. My current code is: Go To Layout[] I chose "Layout Name By Calculation" in the calculation field I put: "PrimerSub" Is I just put PrimerSub without the quotes I…

I've created a database that I'm sharing with two other users via FileMaker Network. I've created a script that prints an invoice, then creates a PDF copy of the invoice for our records. Because everyone works somewhat independently, I want everyone's PDFs to be saved on their own machines, but I'm having trouble getting the path right in my script. If I'm understanding the help file correctly, I should be able to do this: file:Desktop/Invoices/$InvoiceNumber This works fine on my machine (where the database resides), but the other guys keep getting a "(Invoice Number) could not be created on this disk" message. I've tried using different co…

How can I prevent FileMaker Adv 8.5 to perform a start script to run when I open a new window? In my solution I have a start script which is set to run upon opening the database (set in "File options..." When the database is opened and it is no need to run the start script again but I have noticed that when opening a new window the start script is trigged to run again. Why is that? When stepping forward in the script (using the debug) I can clearly see that when opening a "new window" the debug jump directly to the start up script and starts to step forward in that script in stead. Is it possible that the command "New window" can trig the start script to …

I have created a solution in FMA 8.0v3 that is hosted on FM Server Adv 8.0v2. The clients are currently using FM 8.0v1. There are some scripts that run perfectly on my Advanced copy but they do not run as expected on the clients FM 8. Can this be due to the differences in versions? I am downloading the FM 8 updates right now, but was wondering if anyone had any insight into this. Does FM Server Adv, FMA 8 and FM 8 software all need to be the same versions? Thanks.

I'm using a loop method to locate records. The variable holds the record id of the record from the previous table, so that when you go back, it will take you to the same record you left from. Go to Field[ComponentRegistry::ComponentID] Loop Exit Loop If[ComponentRegistry::ComponentID=$$AssemblyID] Go to Record/Request/Page[Next;Exit after last] End Loop But I don't like how the cursor is left in the ComponentID field. Is there a way to get rid of the cursor? I.e. have the cursor in no fields when the script is finished? I'm not seeing anything in any of the script steps. Thanks, --Dawn

Hi, I'm working on a script that export pasted images on a website and then refence the images to the web url. Here's my algorithm: Loop through all field if image --> Copy to temp folder End loop Export all images in temp folder to web Loop through all field if image --> Empty Activefield ActiveField = WebImage (Example: http://www.xyz.com/images/abc.jpg) /*PROBLEM HERE*/ end if end loop - I'm using MediaManager plugin. - The problem is that everything goes well except that when I'm updating the image, instead of reading the image on the web it reads it in the web cache! I've been looking for the web cache dir…

I am wondering if it be possible to create a script for an invoice to do the following - if someone gives us cash for an item, we would check a payment option box marked "cash" which would then prompt a calculation to take place where the amount received was subtracted from the total, giving us the change due. When a payment option was marked "credit" or "check" we would want this calculation to be stopped. Right now we have a calculation set up that subtracts the amount received from the total; however, we never input the amount received unless we are getting cash. What is happening as a result is that the "amount received" for credit cards is not being input, and …

If I have the same value that I want entered into a field for multiple records how do I do this?

Hi, I'm having a problem with the Insert Picture command. The problem is there is no dialog box that appears to choose the image file. I've tried also with Insert File and... nada! I used Get (LastError) and it only returns the number 3. Can someone help me here?

Hello, I'm working with a group of medical residents, and every week they send me an Excel spreadsheet which I need to import into a Filemaker database. Every week it's the same fields that I have to match up when doing an import, though it is tedious and time consuming. Is there a way to write a script so that each time I have to import, Filemaker automatcially knows which fields to match up? -Alisun

Hi, There is probabily a very simple solution to my problem but being new to filemaker I can't figure it out. I'm building a database where the records are numbered. I need help scripting a button that when clicked brings up a dialog box that says "Enter record number to view". The user then enters the number and then displays that exact record. If any one has any ideas that would help me out a lot. Thanks, js22

Can I check the privilege set of a user in a script? For example if user has privilege set = Admin run script other wise alert user via custom msg?

I found out recently that you can't make custom scripts with FM Pro 8.5, because I don't have Advanced. So now I am stumped. All I am trying to do is what would seem (and I don't understand why it's not standard) to be easy is make a phone number field that automatically seperates the area code and puts the dash in. I have several scripts, but since I don't have adavanced I can't use them. Somebody please help me.

Hi all. I am looking for some help. I recently developed a database for events. The database is used to store temporary information about guests so that reports and name tags can be made quickly while the event is happening. Due to the end users wanting all the events to be completely separate, I have had to create three different tables(invitee table, RSVP table, and a Event table) 11 times so that there can be 11 events happening at the same time. Within each invitee table, for example, is the exact same fields, that are named the exact same way. These field names really can't be changed. Here's my problem, I need to create a script that would ideally be used exact…

Hi everyone - First time post. I'm using buttons to run a script to simply go to a layout. I've created scripts that go to the layout, which when I run them using the key command work fine - ie they stay on the record I'm on. But when I call them from a button, they go to the layout but also jump to the last record in the database. It also goes to the last record when I have the button recall the layout directly. Any idea what I might be doing wrong? Thanks!

For various reasons I have to duplicate some information in my database. I've made a script that takes details from one record and uses them as the basis for a new record elsewhere in the database. My question is: can I add some kind of failsafe to stop me inadvertantly creating a new record with the same information twice? There are two key fields - 'Date' and 'Supplier' - that I've been trying to use to acheive this. Each of fields does not contain a unique value, but the pairings of these two fields are always unique - for example, there would only ever be one instance of '01/01/2006 and Acme Supplier'. I have been trying to create an 'If' script step along the l…

I am trying to build a database in Filemaker pro 8.5 like a teachers portfolio containing the average of student grades in every year from the classes of the school when grades are letters. For example: FIRST PERIOD: A SECOND PERIOD: B THIRD PERIOD: A TOTAL AVERAGE: A TWO A AND ONE B IS A TWO B AND ONE A IS B TWO C AND ONE B IS C etc. How to make this script in four fields and for unlimited records. When I add a students record in the database can adjusted to calculate in same way and in numbers. I have just started Filemaker and it is amazing. PASCHAL

How do I automatically create a new record if data is hand entered into 3 specific fields. Also, I would like the data from those 3 fields to autofill into the new record that was created. This is all in the same database. Thanks.

I'm using FM 8 Advanced and need help recording changes to some fields from a record to another table occurance in the same file. Do I have to do a script full of go to: field 1 copy paste field 2 copy paste field 3 copy paste ....? I could do a copy record but it only pastes delimited text in to one field. I really want to keep the data usable and clean. Thanks for any help.

I am curious if you can send two values through the Exit Script/get (ScriptResults) combo. So that when I do the "get (ScriptResults)" command, they are still distinguishable on the other side...I am trying to avoid making global variables so that I can reuse scripts. Thanks for your help in advance!

I have a mini calendar that I purchased from Scriptology Themes. It looks like the little calendar on the forum, I would like to be able to click on any date showing and have it set another single date field with the date. If anyone could help me that would be great. Thank you.....Tina

I'm working on a database used for handling technical support calls and I was wondering if there would be anyway to add a real time timer onto the form so that a CSR would know how long he/she has been on the phone, I've looked around but doesn't seem like you can do any real time stuff. Thanks.

I have an invoice table that once a record has been committed I do not want anyone to be able to edit or delete that record(invoice) Can anyone suggest the best way to deal with this? Cheers Guy

Hi, I'm trying to set a values to calculated field names and these fields are not in the Layout, so I can't navigated through them. SetVariable[$fieldPrefix; "img"] SetVariable[$linkPrefix; "txt"] SetVariable[$firstFieldName; Get(ActiveFieldName)] SetVariable[$fieldName; $firstFieldName] Loop if (PatternCount($fieldName; $fieldPrefix) > 0) SetField[Abase:$linkPrefix & $fieldName; $XYZvalue] // This is what I'm trying to figure out end if Go to Next Field SetVariable[$fieldName; Get (ActiveFieldName)] Exit Loop If ($fieldName = $firstFieldName) End Loop The purpose is that each container is paired with a text field w…

hi, im constructing an import structure for my database. im going to have an excel sheet with info like name_id, name_full, product_id, and product_full (amongst many), from which im importing. the thing is that i need to structure the info according to company and location. for example, if its a medical company located in the states i want to be able to predetermine those values before the import, to file them (the imported persons) in the correct way. what i want to do is to click a button called "import" and then have a popup window ask me about company and origin, where i then manually enter "medical" and "us". i know how to do the rest of the import …

I would like to put a script on a button to allow users to back up the file(s) they are working on. I have no idea where to begin, I have tried searching with no success. If any kind soul could put up an example/sample script I will be very grateful Thanks John

I have built a database for our departmental inventory. We do inventory each year, and as we find each item in the inventory, we have a "found" field, which we mark "yes" if "found" or "no" if we know that the item was lost or stolen during the year. (these marks are courtesy of checkboxes.) We also, regularly send items to salvage (we are an university) and would like an automated way to automatically mark items that go to salvage as being "found." I built a button to mark the items as "salvage" in the "location" field, but would now like, any items with "salvage" in the "location" field to automatically be marked "found." How on earth do I do this?

A question about backing up data got me wondering whether it is possible to identify all the tables in a file and iterate through that list programmatically. The idea is to be able to script something like (using pseudo code) Select All Tables Loop Go To Next[Exit After Last] End Loop Being able to do this would make import/export much cleaner and extensible... Has anyone done something like this? David

I have 2 files, say PARENTS and CHILDREN. I create a script in PARENTS that says go to a script in CHILDREN. The script in goes to in children gets records, sorts them and goes to a particular screen. The end of this process is to have the user in that final screen in CHILDREN. What's happening is, the script in PARENTS runs the script in CHILDREN except it returns to the screen in PARENTS. How do I get it to stay in the screen in CHILDREN? By the way, I'm running FM7. Mike

I've got a bunch of tables I have to import records to on a regular basis. Each table has a numeric ID auto enter serial field. After importing, the next serial increment in each table is wrong... a number already used. So after the importing I need to go to each ID field and tell it to use a "next" serial value that is after the last record I imported. What I want to do is run a script that grabs the hightest IDserial value in each table and plugs it into a field (Global) so I can use it for reference. Now I've got a feeling there are 10 better ways to do this... but anyway, what I find myself wanting to do in this script is make a loop that goes from la…

Hi there I am sending some email from a group of records and wonting to formate the text using some script but I am having trouble putting space and hard turn in the text formating please see below code Clients_people~CL_Client::Dear & Clients_people~CL_Client::first name & Clients_people~CL_Client::Email letter contents regards Damian

So I've been trying to figure this out and it's not coming to me. I have a fmp5 (I'm using FileMaker Pro 5) file that will contain a product name, two types of serial numbers, and the status of the product. On the front page, I would like it to display how many of each product we have with each status. Example: Product Names = Fruit The front page would say... Apples (Normal): 11 Apples (Eaten) 1 Grapes (Normal): 12 What would be the easiest way to do this? >_<

Hi, I'm using a business projects template and I've modified it to suit my business. I have existing tasks linked to projects that I can open up from the projects layout no problem. After doing some mods my problem now is that I can no longer create new tasks and link them to a project which already has tasks linked. Any help appreciated. Colin

I'm using the FMExample plugin to do transactions in my database. Problem is I have one XP SP2 machine that only loads the AutoUpdate plugin. I have reinstalled FM8 Pro twice. and It still won't load the FMExample plug in. I'm just about to the point of reimaging the machine. Any ideas? I think the problem lies in the registry. It works on all the other FM8Pro machines (Win and Mac) in the building.

Hi, I'd like to have a URL which accesses latest emails from clients. Does anyone know of a way to do this within a layout so that this URL opens my email client and then relevant email? Any help appreciated. Colin

Hello, i'm a newbie and i'm trying to figure out some of the scripts with scriptmaker. the one i'm interested in right now is export records. I have a button that when pressed, export records. my question is this. Is there a way to automatically export the fields you want? for instance I want them to be able to export a email.csv file so they can upload it into email management system. the only fields needed for the export are email. Is there a way to customize this without the user having to delete or add fields with the "specify field order for export" dialog box? I couldn't find a previous thread on this issue. If I've missed it please forward …

I am curious if anyone knows how to alter the "Custom Dialog" script step (or create something else) so that instead of having to enter a value manually, I can have the user check yes/no with a radio box, or select from a list of values. The goal is that when a record is created, a script will run, so that there are certain fields that they must define in order to create the record. If this isn't the right part of the forums for this, let me know and i'll go to the appropriate portal. Thanks!

Hello. I am creating/managing a database which includes a table for audio (AUDIO) recordings and one for musical scores (SCORES:Jazz Big Band scores). My score IDs are assigned in two fields (one is alphabetic based on composer's name and the other is serial based on acquisition dated i.e. ELLD 001) and are a match in both tables. In AUDIO, I have a field called "Track Names", which can hold up to 20 repetitions. I also have "Score ID pre" and "Score ID suff" which both have 20 repetitions. I want to create a button at the end of each of the 20 repetition rows in AUDIO which will open a new window with the SCORE record associated with an album track. …

Right now I have 2 tables 1) Company 2) Employees Im trying to make script that changes the field "active" to "No" in the company record and in the related employees records when someone trys to delete a record in the company table. I did a script that says Replace Field Contients [No dialog; RelCompanyEmployees::Active; "No"] This sounds like it would work great, but its replacing every single active field (even ones that arent related to the company) to "No". Both tables are related by the companyID Im I doing somethign wrong???

In Windows, double-clicking on an excel template icon CREATES a NEW DOCUMENT based on that template. In FMP, any reference I make to the excel template OPENS the EXCEL TEMPLATE! How do I reference the template, from within FMP, to make it create a NEW DOCUMENT? Thanks in advance

I have a script activated by a button on FM that simply uses a web viewer to open an ASP script. When you double click this button instead of single click it the script actually runs twice and causes duplicates in our data. Is there a way to prevent a double click on a button within filemaker? any information would be greatly appreciated. thanks!

Hi, What could be a script that would loop through container in a layout? As a VB programmer I would think of something like this, but I can't find the same functions under ScriptMaker. Go to Field [First] // First doesn't exist Loop If [isContainer(ActiveField)] // What is the equivalent in ScriptMaker? Set Variable [$filePath; Value: "filewin:c:/temp/" & Photos::PhotoID * 2 & ".jpg"] // I hope I'm ok! Export Field Contents [ActiveField; $filePath] End If Exit Loop If [No more field] // What is the equivalent in ScriptMaker? End Loop Any help would be appreciated Thank you

Hi all, Is there an easy way of creating a single PDF document by combining multiple subsummary reports? Thanks in advance!

I have several navigation buttons on my layout... one of which closes the window and executes some script steps. My problem is that users sometimes click the "X" windows close button in the top right corner of the window. Is there any way to disallow that and force them to click the layout's close button?

I have produced a checkbook register that tracks all of the checks I have written. Some of the vendors receive several checks in the course of the year. Some of them just receive one. [color:red][color:green]I would like to script a report that finds all unique vendor names and totals the purchases for each unique vendor. I would like to be able to total these on the fly,i.e., on one layout have the check register and on another layout have the totals for each vendor. Assume my purchases are as follows: Vendor A: $15 Vendor B: $20 Vendor B: $10 Vendor C: $20 Vendor C: $30 Vendor C: $40 The resulting total for the previous data would …

i have an open url step. the url is built by combining feilds like so If(IsEmpty(block);"R:2006Builders" & "" & Builder & "" & Subdivision & "No Block" & "lot " & lot & "lot specs";"R:2006Builders" & "" & Builder & "" & Subdivision & "block " & block & "lot " & lot & "lot specs") now the open script works on most users computer. but one user nothing pops up. any suggestions as to why or what to look for?

Hi all, Need some help on an error that I'm seeing OCCASSIONALLY. Several scripts in the system I've developed are used to create new records (rather than allowing creation through portals, etc.). Usually (although not in every case), I pop a very tiny window for the new record to be created in (go to the right layout/table) and then perform the new record step. I've put a trap in for the occurence of an error because a few times a day the new record step is failing. The trap has let me know that the error I'm actually getting is #106 -- Table is missing. Happens in different tables/scripts throughout the day. Any thoughts on why this would happen intermi…

Hi everybody, I don't understand why something will work perfectly in one TO but not another. The follwing script works perfectly in my Customer file but not in my Vendor file. The Vendor TO is a duplicate of my Customer TO and are related to the Letters TO in the exact same way Customer_Letters and Vendor_Letters. The portals are as they should be and the fields are correct as are the layouts and you can see that the script is the same as well. But the portal in the Customer layout works fine and the Vendor does not. In the Customer layout I click the New button which calls the following script and goes immediately to the Customer_Letters layout. When I g…

Hey friends- We had a printing script that looked like this: [color:blue]Go to Layout [ Deposit Detail ] Print Set Error Capture [ On ] It always worked fine. Yesterday, I wrote a log, new script. Now, for some reason, when we perform the priting script, it prints the new script steps. I'm totally confused. I tried taking every possible "print" script step out of my new one, and it doesn't help. Even when we try to print from the print dialogue itself, the same thing occurs. Can anyone think of anything i can do to fix this? Thanks so much, jesse

I want my users to perform a "Find" without them having access to Filemaker's "Find" dialog, for various reasons. I thought it would be a simple matter of giving them a layout where they enter the Find string, with a button which when pressed triggers a script which performs the Find out of their sight. But I can't seem to get it to work. Using FM8.5. Any help would be appreciated.

I have FM 8.5 on a Mac, and the folder "English Extras > Electronic Documentation" contains 5 PDF files. But none of them is for scripting! Is there a manual/users guide/reference book for scripting?

Hello I have a text file with addresses like below PETERS NEW YORK PIZZERIA 144 STANDART AVE Auburn, NY 13021 (315) 258-9488 I need to break the top line into the field "company" PETERS NEW YORK PIZZERIA I need to break the Middle line into the field "address" 144 STANDART AVE I need to break the Bottom Line into the fields "city" Auburn "State" NY "zip" 13021 "phone" (315) 258-9488 I need help on how to do this. I don't know how to manipulate text of find the second line or the last line Can someone please show me how to do this? Thanks Dave :

i have problems with my database, but i don't know, what is it caused by. i have some fields in my database that are auto enter serial numbers and i have some scripts to change them. i thik they are somewhere wrong. for some time everything was working well, but then it started to do some things and i don't know why. when the ID field have to have for example value 45 it jump to value 3 and because this field have to be unique everything has crashed. do you know about some case, when this can be caused? i use a script step 'set next serial value[]' to increment value in some cases, when i need to make new records automatically without inserting values by user. thanks for…

Could someone please help me? I am having trouble with writing a script and i'm at a loss to get started. What i would like to do is create a script that will do one of two things. First i have 3 fields ITEM, TRIGER and MASTER. ITEM is required, always. TRIGER needs to be Boolean MASTER is required ONLY is TRIGER is true. if TRIGER is false, copy the contents of ITEM into the MASTER field. Either way MASTER needs to be populated with something before the record is finalized. I would appreciate help with this. Thank you so much, this is a little too advanced for me. pryjda

Hi Not sure if it should be in ScriptMaker or Fields, but since I'll be needing both I better start here. This one has me going nuts... I have two weeknumbers+years to calculate their dates (a startdate and an enddate). I have a calc that says how many weeks are between them (counting sundays). What I need is the range between them, like: startweek=40, endweek is 45, the range it should show would be 40,41,42,43,44,45. To make things worse (for me) is that I want to add a button that will create new records in another table (line), containing the key of the parent record for relational use, but only one number of the range. So in this example I'd get 6 new…

Have a database with several test for students enclosed. When I want students to do a test I manually change their privilege set to allow access to 4 or 5 layouts. After the test I do the reverse. Sometimes, I forget a layour. Ideally I want to create a field for each test with a yes/no flag which will make the appropriate layouts automatically available to the students. When the test is done, just change the flag. I would imaging a script but have no idea where to go from there.

Hi guys, I dont know if this is even possible but I thought I would give it a shot. I am using the web viewer to display pdf files. I have an input screen that the user will enter the path of the file. Is there a way to have a "browse" button that will open up a dialog box, so the user can find the file and click on it and have the path entered for them? I have been doing alot of trouble shooting because my users aren't very good at typing in the path of a new file. I have made it as easy as I can by using filepath and keeping the pdf's in the same file as the filemaker file so they just have to type the path from the filemaker file and they still have trouble.…

Sorry if this seems a bit stupid - I'm a super neewbie. I'm trying to make a script for a 'back' button that will take the user back to the layout they just came from. I can't specify the destination layout explicitly because the layout with the 'back' button can be accessed from several locations. Any help would be much appreciated.

Hi, Is it possible to write scripts that are executed once a specifc user has opened an FM6 file. I'm thinking of a script that will execute a zoom-to command for a specific user whose particular screen resolution will otherwise make the file hard to read? PMDA

I have a created a database with students and and all their tests. I need to run a script to change the grade because of the new school year. I created a script, but it still changes the grade 12 to 13 and keeps incrementing everytime I run the script. Below is what I created. What I need is a script that increments by 1, but stops at 12. I am only a novice/beginner. I'm hoping someone can find my error or correct me. Go to Layout ["Student Records"(Student Data)] Show All Records Go to Field [student Data::Grade] If[student Data::Grade < 12] Replace Field Contents[No diag;Student Data::Grade +1] Go to Record/Request/Page[Next] End If …

A solution requires that I create a script or function that accomplishes the following on command: 1. Copy a predefined portion of the email address from each record. 2. Pastes all that is AFTER the @ sign of that record into a different text field on the same record. Simple as hell, I'm sure but not able to do it for the life of me. I know it's so simple, yet I'm stumped. Suggestion, help...please? Specific Scenario: One text record field (email addy) shows [email protected] I’m looking to only extract “aol.com” from that field and place it into another field in that record. Other records have email addresses of different lenghts, so I'm…

I would like to create a glossary of publishing terms without reinventing the wheel. Is there a sample file or another thread that someone can point me to that will allow me to basically display a layout of the alphabet and once I press the letter button another layout is displayed in list form with all the terms/words (records) starting with that letter. It doesn't have to be exactly like I described but similar. thanks.

Hey everyone, Need some help and couldn't find anything that really dealt with my topic. If there is one, let me know. Pretty easy setup; Receipt and Inventory Tables. Inventory records created through portal on Receipt table. Have a 2 dozen or so categories a user can choose from. I've created an Eventscript so when a category is chosen, a window opens showing appropriate data to appropriate record. Works great. What I can't seem to develop is a way to warn users about changing a category. Users will at some point make a mistake and I want a way to warn them that if they change the category, all information will be erased(which it will although not in sc…

I am in the process of migrating / redeveloping a fairly large system from Fm6 to fm 8.5. There is one file (jobs file) that I need to import data into filemaker 8.5 a few times a day. Is there a plug in that works with filemaker 6 and filemaker 8.5 to do this. I am guessing I will need to export out fm 6 and import into 8.5 and cannot have the 2 databases talk directly.

Is it normal for FM to take a VERY LONG TIME to do relatively simple SQL selections? I'm trying to execute the following SQL: SELECT Inventory.Ref_Number, Purchase_Order_Items.Condition, Inventory.Qty_Available, Ref_Number.Description, Ref_Number.Manu_Part_Number, Ref_Number.Street, Ref_Number.Weight, Ref_Number.Class, Ref_Number.Hot FROM Inventory, Purchase_Order_Items, Ref_Number WHERE Inventory.Qty_Available > 0 AND Ref_Number.Item_Number = Inventory.Ref_Number AND Inventory.PO_Item_Number = Purchase_Order_Items.Control_Number AND Ref_Number.Class = 'ATA Hard Disk Drives' I've tried it both within FM itself via ScriptMaker Execute SQL command, and I'v…

I am entering data into three fields on a handheld. I have set the DB up to perform a script every time it opens. The script combines the fields 2 and 3 into field 1. If I add data to all 3 fields in FM, the script runs exactly right the next time I open the file. If I add data on the hand held and sync it, the script does not run. The script will run automatically the next time I open the file though. It is as if I needed to open and close the file once for it to recognize the data brought in through the handheld. Any advice? Thanks a lot.

As a novice with scripts, I am having trouble trying to construct a script which will work when used with IWP. I have two Tables within a database. One Table (called "Members") has two fields: "Name" and "Password". The other Table (called "test") has two fields: "enteredName" and "enteredPassword". What I am trying to construct is a script which: -- takes the values entered in a layout called "StartPage" for the fields "enteredName" and "enteredPassword" in Table:test -- and performs a Find for the Record where they exactly match the values in "Name" and "Password" in Table:Members. If Find fails, I want the user to be taken to a layou…

Hey, I have a script I want to set the value of one field with two others. So my calculation is Field 1 & " " & Field 2 What I need is a carriage return instead of a space. Does anyone know how to do this? Thanks for your help.

I'm very inexperienced with functions, I'd like to include a script within a function but I don't know if I can do this. I have an inventory DB, my fields are "Retail Price", "Markup 33%", "Markup 35%", "Markup 40%" and "Variance". (I don't know if I need the Variance field, but I included it anyway)I want the function to tell me(either by beeping or displaying a message)when my "Retail Price" is less than any of my "Markup" fields.Can I do this?? Any help would be great. Thanks

Is there way to let filtervalue work the opposite which means it will show all values instead of the filtertext?

this is pretty disasterous. I had a db that was related like this: table Client Job job data key Client name Job Number job number contains: client name this worked fine. all scripts were fine...untill i was told that the job needed to be automatically created (even though they insisted they wanted to manually input it when i asked pre-start) so now: client gets an auto no on create (client no). a job when created gets its own auto created suffix (job suffix). these 2 hyphonated (concatenated) give me a job number. however to keep the relationships strong client no and job suffix are the keys throughout and define a job and job data. job …

I have a file that I want to export pictures from a container field. I can export the information but the problem is I need to create a file for each picture and rename it to include the title which comes from another field. Anyone have any ideas of how to do this?

I need to understand better how FMP handles calculation and data type conversion and hope you guys can provide the clarity. Here is the situation... If I use script; SetField(field 1 text type; (field2 text type & (field3 type number – integer))) When field2 = CB Field3 value = 0055 and integer = 5 Why is the result CB50 instead of CB0050? Yet when I do the same thing without the integer subtraction the result is CB0050? TIA, K

I'm running FM8SA on an XP Pro system with IIS installed as "localhost" for a server test bed for a web deployment of FileMaker. I also run FM8PA on the same system for solution development. I can't seem to make the Open URL script step in my solution work. The Open URL script step calls a php page stored in the webserver root folder, wwwroot. Does anyone know the correct syntax? In addition, I've checked the operating system level permissions and the webserver permissions. They seem fine. I can open the target php page directly from the browser with localhost/myphp.php. Thanks, Sailor1

Hi all, I'm trying to make a Statistics for my DB. Example: Status............Rank =======....====== Onboard.......Master Onboard.......A/B Ex-crew.........Master RIP..............Cook Ex-crew.........Master Onboard.......Master Onboard.......Cook Result: Onboard Master = 2 Cook = 1 A/B = 1 Ex-Crew Master = 2 Cook = 0 A/B = 0 RIP Master = 0 Cook = 1 A/b = 0 Out of my example I need to show this to my layout for a quick glance on the stats and also so i can put it in my report. I do not know if this is the right place to post this, but I do …

Hi, I want to allow a user to enter data (e.g. weight in lbs. and ozs.) in an easy shorthand ("5 3") and have a triggered script reformat that into a rigid form ("5#03"). I have been trying to use EventScript with an auto-enter calculation, without complete success. I have not been able to get the normalized data back into the input field. Here's how I've tried organizing it, normalizing a zipcode as a simple example. Using the debugger tools, everything seems to work properly until the auto-enter calculation attempts to return y, the normalized zipcode. Nothing is plugged into the field. Can anyone see where I'm going wrong? ZIP is defined as text …

Here is what I want to do. I have a record (item Number) with a protal (populated with Work Instruction lines that pertain to only the one Item). I have a job number record that I want to have the employee enter that will reference the item number. I would like the items that are in this Item Number Record to be copied to the Job Record (Any further changes to either record should not effect the other once the copy has happened). Script maybe?? Thanks James

Hi, I'm having a problem passing some variables through a script. Here's my script (I'm using french version) Run Script("ExportImage";Parameter: "Let ( [ $ImageFolder = $$FolderTrvVente;$ImageFilename = $NameImage;$ImageFormat = $jpegFormat]; "Image parameters" ) " // Only works for $ImageFolder Run Script("ExportImage";Parameter: "Let ( [ $ImageFolder = $$FolderTrvVente;$ImageFilename = $NameImage;$ImageFormat = "jpeg|640|480||512|72"]; "Image parameters" ) " // Works for $ImageFolder and $ImageFormat, but not $NameImage I can't pass local variable why is that? I'm new to FMP. I learned in all other programming lang…

I've put the web viewer to use in some areas in FileMaker and some people like it and some people don't. I've created 2 different layouts so that they can use whichever way they prefer, but I'm having trouble figuring out how to make my script decide what to do based on what layout the user is on. So basically I need: If layout = FirstLayoutName Do One thing Else If layout = SecondLayoutName Do Another thing Else Do yet another thing. End If Any info would be great. Thanks!

This has probably been asked I am new to forum and have been looking for an answer for two days Is there a way of starting a script when you exit from a field (rather the pushing a button) Thanks

In our invoicing system, I stored a running invoice number in a field in a table. When user has completed entering the invoice, my script will go to this table and get this running number, and then increment this number by 1 before exit. In multiuser, we often encounter two invoices having the same invoice number. It looks to me two users happened to go to the same field and retrieve the same running number. I tried using Open Record to 'lock' the field but it does not work. This is giving us a big headache. Appreciate any help how to overcome this.

I'm looking for a way to generally turn off the visual spell checker for all the database files. When using the file-options it will be turned on again by default after you quit and open FileMaker again. No big help. I looked through the spelling script steps and could not find anything useful there either...like including a script that turns off the spell checker for all files when opening the database... Did I miss something??? Stefan

Hi. I have a repeating global field - field[6]. Is there an easy way to clear all repetitions in the field in a script? Everytime the scipt is run i need to empty out the values in the field. I assume that i can do a Set Field for every repetition, but i think there is probably a more efficient way. Thanks!

Hi all, I recently started working with EventScript and am quite happy with it! It's really a handy thing! Lately a problem occured: I have a portal that displays projects that are related to a text. So users select an ID from a Value List by being directed to the last portal row to create new related records. After exiting the field, EventScript is triggerd by Auto Enter options. for some reasons it does this 2 times... So in case of an error I get the same message 2 times and the field validation for the field itself gets confused and messes up the script...I tried to work around it but the real problem is this 2 times! Does this sound familia…

Hi all, I am having an issue using the perform find function in the scriptmaker. I cannot figure out how to use a table field or a variable for the parameter in the find: (i.e., RecruitInfo.StartDate >= RecruitInfo.GlobalStartDate or RecruitInfo.StartDate >= $StartVariable) I can only see how to enter a fixed value. Does anyone know how to use the find function with variables or table fields? Thank you.

i need to write a script that...needs to do a find and print for each memeber of a value list. example: there are several job records, and each one is assigned to a certain person from said value list(joe,billy,sue). when the manager hits print there needs to be a print off of all joe's jobs. then another print off for all of billy's and another for sue's. but it needs to be flexible because names may be added or taken away from the value list at anytime.

I guess this is easy and that the question has already been asked but I can't see how to do it. I have a client records database with the usual fields like name, address, etc. What I want is that when you trigger the submission script it looks for fields that should be filled with info but are empty and then signals it through a dialog box. For example : the fields 'Address' and 'First name' are empty! Anyone an idea how to tackle this? Thanks in advance.

Okay, I tried a few things, but ******* that's hard for me. I'm a programmer from the MS world and trying to use FM is way un-friendly... I got to some new beginner problems. How do I pass parameters to scripts? Is there anyway to program code such as VBA? Can I create some methods (I believe that I need to use the scripts...)? How do I create global variables? Can I create something like: Sub ExportImage(ImageFolder, ImageFilename, ImageFormat) Export(ImageFormat) Export(ImageFolder) Export(ImageFilename) End Sub If so, where? If not, how do I perform similar results? Please help me... FM is maki…

I have two portals in the bottom of my layout, one to show "parents" and one to show "children". I want to put a button on each portal row that will allow me to go to that record. The tricky part is that I have a different layout depending on the record type (Component, Sub-Assembly, or Part), and different variations depending on the users security level. I already have scripts written to choose a correct layout depending on security level that I can call on. Now the script I wrote, displayed above, works sometimes and other times goes to a record that I can't figure out why it would choose that one. Am I missing a crucial step? I've attached the entire…

Never gone as far as posting a script before, but I just can't work this out no matter how long I stare at it. Okay. In database Whole thing, we're in table edition; art is another table. [These names are all truncated but largely accurate.] In art, EditionCount is a field that contains a number from 1 to 8. That represents how many copies of an artwork will be available for sale, at different prices. In edition, I want one record, related to the main serial number, for each of those copies [or editions]. The script has already found records that match the main serial number, so we've got a found set relevant to it. It has then checked to see whet…

I rarely use field-level validation but need to on my checks data-entry screen. User enters Amount (2-decimal number) which is the check amount. Validation on AmountTotal is: not Mod ( AmountTotal * 100 ; 1 ) and Filter ( AmountTotal ; ".1234567890" ) = AmountTotal or IsEmpty ( CheckNumber ) Validation is set to Validate Only During Data Entry and Validate Only if Field has been Modified is unchecked. As soon as an amount is entered, it creates a relationship to all outstanding invoices with similarities and they appear in a portal. Portal has PAY button which fires script to apply all (or part) of check to an invoice. Problem is - if user has entered m…

Tearing my hair out at midnight ... I know you've all been there. So somewhere in my fifteen-line script, I've caused a logic error, but I'm not seeing it. Every line looks right to me - but I must be goggle-eyed, because somewhere, I'm getting a hang. I know I once before used a feature that would test-drive a script, one piece at a time, soI could watch it unfold, but I can't recall how, or if it was a plugin [i bounce between a couple of clients with a couple of versions]. Should I start [when I get up] manually inserting a Pause between each script step, or am i remembering correctly that there's a switch I can flip to watch this happen in slow motion?

I would like to have a button over (or attached) to a pull-down menu that after user sets the field, the script performs a Go to object based on the choice made. As far as I can tell, there is still no "upon field exit, perform this script...". I was trying to trick it into pausing the script with the pull down "open", then continue after field was set, but there is no way to avoid user mis-interaction on that method. I normally would use bullet choices with buttons overlaid so when a user chooses the bullet marked Quotation I can fill in the field, set a few other fields and nowadays, Go to Tab Object, having made a tab for every bullet choice. Too many choice…

Can someone help this novice please! When my users create a new order they are able to select a category for this order from a value list Is there a way to restrict certain users to a limited number of options from the value list when they create a new order Thanks

Hi everyone. How can I get two fields contents to appear in just one field as well. By that I mean I have two fields Surname & 1st Name in that order. I would like the contecnts of those fields to appear in another Layout in just one Field called Full Name. How would I go about doing this please. Do hope you great guys will help me again here. Mark

Hello I hope that I have a really dumb question but I seem to be unable to crack it being a total newbie. I have a relationship between to sepaerate dbs via a serial number. In the master db I have a copy of the serial number in the second db set in a specfic field. Want I am trying to do is have a script as a button so that when I click on the field of the master db that has the serial number of the second, the second db opens and show the corresponding page. I have managed to get a script that opens the 2nd db but I cannot find anyway of it opening the right page. It just stops at the last opened page. The script is attached. You will all probably laugh but here i…

I have one field containing an "X" if I made a succesful transaction. Also for every week I fill in the number of the week as I work. If I want to have a "find" function that can find i.e. all the "X" I made at week 38. How can I combine this two finds in one go? I am not so good in FM so please write slowely

I currently took over on a project and need a little help on finishing it up. we are converting some old filemaker files (ver 5.0) to 8.5 I have all the scripts working save one. It takes data from 2 different tables and populates some fields along with some user inputs. I have it pass one field but it does not give me anything else. I can up load or email the files. Any help would be great! - I have botht the ver 5 files but there is a lot of data in them and the new set ver 8.5 that is cleaned out.