Script Workspace and Script Triggers

Hello I have made a database for an architecture practice's library. It only has one table and you simply click on the kind of book your looking for (e.g. windows/doors/stairs) and a list of all the related books shows. So it's a series of buttons and scripts. Pretty simple. It seems to be running smoothly but have come across two things that could make it easier to use. 1. If nothing is entered in the search fields I want an error message to appear giving the options to modify their find as opposed to just showing all the results. 2. If a search returns no results I want an error message to appear giving the options to modify their find as opposed…

When I run the send mail script and check off the "no dialog" option no emails are created. The FM help tool says that the emails will be saved to the outbox folder but that is not the case. I am running FM8 and Outlook on a PC and wonder if there a setting I need to change in Outlook to make this happen. Also, does anyone know how to pick up two attachments using the send mail function. I can attach one file sure enough but I really need to attach multiple files.

I am currently using fmp 8 advanced to manage a dreamteam statistics type tipping competition. At the moment however i am importing the stats by cutting and pasting 8 games worth of players statistics into a spreadsheet then importing them into fmp. IS there a script or similar to do this i have attached the websites that i am attempting to pull the stats from. http://afl.com.au/default.asp?pg=matchresults&spg=default&m_tournamentmatch_id=1660 this is just 1 of the 8 sites goto id 661, 662 etc also. thanks alot! RG

In Scriptmaker, is there a way to use the contents of a global field as the query for a find request? How do I do this? Or is the answer right under my nose? Thanks all - Daniel

I know this is going to be rudimentary for you folks,so I’ll apologize in advance… I’m a sole proprietor, running a small audio production shop. Until this year, I’ve used HyperCard (Mac platform), which uses a scripting language very similar to “lingo”, the scripting language in Macromedia’s multimedia authoring application, Director. Here’s my situation: At present, I have Filemaker 6 for Macintosh. In my “Projects” record set, I’ve two multi-line fields: ”Description” which holds what services or goods are being sold, and “Elements”, which holds the prices for those goods or services. Buttons are shown on the right side of the page th…

I have multiple scripts which works on my machine, but NOT on an other computer in our Nerwork. Both machines works with the same Filemaker 7. Example: Scriptname: Go to customer Script: Go to related record[From table: "Customers"; External; Using layout: "Customers"(Customers)] If I push the button on the other computer there is nothing happening. How come that a script like above works on my machine but not on the other computer?

I created a database with 2 tables. The Ancestor Records table has several fields such as Surname, First Name, ID#, Relationship, etc. Its purpose is to provide me with a list of the documents I have scanned into the computer for each of my ancestors. It also contains a portal with included fields so that I can add to a listing of documents I scan into the computer. The second table, Document Scans, has the same fields as AR (Surname, First Name, etc.) but also has a container field to hold the actual scanned document. A listing of that scan, and all others that pertain to that ancestor, ends up in the AR table via the portal. So, the AR table contains the l…

hi is there anyway to get a popup window for user inputs? t.i. can i get a user to enter a variable in a popup window, and then use that variable to calculate an answer? i know how to do this with reg. fields, its just the popup window i want. this is really all just consmetic and doesnt really fill any function, except looking cool... edit: realized that i posted this in the wrong thread (Relationships) moved it here instead...

got a small problem with some lines of code... im extracting info from a repeating feild, seperating the indivudual entries with a " | ". the thing is that when inserting the info into the designated field i always starts of with the " | ", and i need it not to... this is the code: setvariable[$$i; count(people::names)] setvariable[$$k; $$i] loop setvariable[$$i; people::names[$$k]] setvariable[$l; $l &"| " & $$j] exit loop if [$$i=$$k] setvariable[$$k; $$k +1] end loop setfield[target_field;$l] what i get out of thins is; "|craig|leanne|jody" and so on. help med get rid of the first " | " infront of craig...

hello, i have been trying to do this but still in vain. i have a field(date format) with the date of expiration. what i want is to have a script which will find data and show them on screen of those expiring 30 days from current date. any help. thank you

If I parse the letter 'A' out of a field is there any function or other that will tell me that the next letter alphabetically is 'B'. Parse a 'B' and the next letter is 'C' etc Thanks in advance Phil

I have a script defined that determines a Text string for years, where the output looks like "2004 2005" or "2006 2007", etc. I want to call this script from a calculation. Is it possible? The idea is I want to autofill in a field with the text strings above when a new record is created. If the above isn't possible, can someone suggest a way of accomplishing this task?

I have a global repeating field where users can insert values that I then need to search and find. These values come from a list of values one of three variables and represent a value from that variable. I would like to write a dynamic script so that I can go down the global repeating field and find each example of the variable from the source. Only one variable is being used. I want to script in a way to tell which one it is, and then search on the values requested. Here is an example. dosage form variable global repeating field a b b …

I have a database that is muti-user and uses a script step to calculte a file path that is stored in a global field that I then use with the URL command to open a particular file (usually a pdf file). Example: Set Field("sht_path","Left( Status( CurrentFilePath), Length(Status( CurrentFilePath))-18) & "Drawings/" & drawing & "/" & sht & ".pdf"", then Open URL(No dialog, "sht_path". Anyway this approach works every time for the Host. Every time a user envokes the script they get what I believe is a system error that says the FMP5 is not a valid shot cut (Win 2k Prof). when I look at the global sht_path it has "FMP5://256.XXX.XX.X/---------" with the …

back again... this time i need to seperate and split up different words and subjects. i´ve got a list of people_names where each name is seperated by a "|" so that it looks like; mark|jason|alesandra and so on. now i want to spilt them up on the "|" to make it look like; mark jason alesandra and stick them into different fields (or perhaps a valuelist, cant really make up my mind...). ideas? thanks

I'm not greatly experienced with FM, but I've done several databases. However, this is one of those cases that is probably easy buy has me running in circles. I have three tables: Classes, Types, and Form. The Form is related to types by a type code and Types are related to Classes by a classcode, which is the first two characters of the type code. In a Form layout I have the type code, other information from the Type table, and the Class coming from the relationship Form>Types>Classes. All works well when I hand enter data. However, I'm trying to implement a script to allow the user to enter a new type that will be added to the Type table and the Form tab…

When having the script step:"Enter find mode" I cannot seem to commit the find? I always have to press enter/return key? Physically. Or, click on the find button which appears in the tool bar. What am I not doing...? I cannot find a step to commit the find? During a script.

im trying to create a random number calculator thats picks a random number[0-a]. how do i do this easy? ive tried diffrent variations of the Random function, and by using the Round(Random;0) getting it to only give me ints, but i need to be able to get the returnvalue to range [0-a]... little help please..?

Hi, Is there a way to debug the startup script ?? (other than running it once you're logged in)

I have two tables: for sake of ease lets call them Table A and Table B residing in a single file. In table A I have a field called "Design_Number". In table B I also have a field called "Design_Number". I would like to write a srcipt that when called freezes the window in table A, creates a new record in table B, then sets the data A:design_Number into b:design_number. Currently my script looks like this but it does not work, can anyone please help? Freeze Window Goto Layout ["DataEntry" (TableB)] New Record/Request Goto Layout ["HomePage" (tableA)] Set Field [TableB::Design_Number ; TableA::Design_Number] Any help would be appreciated. Se…

Hello, I own the book "the missing manual", searched it and didn't come up with an answer for my problem. Google... nope.... forum... nope... so here is my post: Whenever a student is placed in a grade, fm should automatically place new records in my payments table with the information about the costs specific for that grade. In the row of data would also be a field paid that stays null as long as the student didn't pay. This way I can easily report what's been paid, and most important, what's not!! I included a file with the basic tables, feel free to update this file because it would mean a great reference to me.. Can somebody please help me on this …

I have an FMP6 related DB with records from DB2 displayed in a portal in DB1 indexed by date. The DB relates to student detentions. If a student misses a detention I have set up a script that creates a detention on another day using the information from the record on the original detention day...which works!!! I'm trying to write a script to see if the student already has a detention on the day to be rescheduled. My script works if the student has or doesn't have a detention on the rescheduled date. But the script ends on the rescheduled date and I can't work out how to return to the original record on the original detention date. Can anyone …

Is there a way to know if the script-debugger is ON or OFF without having to open up the Tools Menu? Better yet, is there a way to toggle it on or off with command keys or a scripted button? Any ideas? Thanks, Jarvis

Hi, How can I run a check to make sure that a file "XYZ" is open from another file ? thanks, beta :)

I have an FMP6 DB with records indexed by date. I can manually Find then show records after a particular date (=>xx/xx/xxxx) but I would like to write a script to automate it. I can't work out how to add the => after scripting to enter Find mode. Can someone help me please. TIA Stephen

Hi, in a script I try to replace this character "|" by this character "". However, it will only recognize "" as a text operator not as a text string (of only the backslash). Any solution? Thx Berny

Not sure if I'm posting in the right board, but wondering if someone can help me out with the following (as I am new to filemaker as of yesterday). I have the following invoice files: invoice2004_01~12.fp5 invoice2005_01~12.fp5 invoice200601.fp5 invoice200602.fp5 invoice200603.fp5 invoice200604.fp5 invoice200605.fp5 invoice.fp5 I need to create a report that looks like the following: http://microtitan.ca/stuff/database_report.txt (txt file here to simplify the viewing) If anyone can give me a crash tutorial on how to do this, I would greatly appreciate it. Thanks!

I have a script that processes every record in a table. This can take anywhere from a few seconds to several minutes depending on the number of records and how much needs to be done on each one. I'd like to give the users an indication of progress so (1) they can see something is happening and (2) predict the time to completion. My first progress indicator was to refresh the form window as each record was processed. When there's little to do, the records change every 2-3 seconds. The users can roughly predict time to completion by watching the record counter in the left status area. Occasionally it takes up to 20-30 seconds to process a single record. I…

I have a calculation field which subtracts INITIAL TIMESTAMP from CURRENT TIMESTAMP. This field measures elapsed minutes from start to stop. I would like to keep a running total of elapsed time, kind of like a stop watch. I would like a screen to refresh itself periodically to post the current amount of elapsed minutes. Is there a way to script this field refresh, or does it require some kind of plug in? Thanks, Jarvis

I am creating a timesheet database to be accessed by employees via a web browser (IWP on FMSA). The startup script needs to get(accountname) to know which employee is logged in and then show them a list of their existing timesheets. I want to perform a calculation so that based on the results of get(accountname) get me the employee's ID number that I can use to search for that user's records that I can then display in a list layout. I'm stuck on the performing of this find. I though I could go into Find Mode, Go to a Field, enter my calculated value, then perform the Find, but that doesn't work in the browser. How can I specify a calculated find request?

Hi, I am trying to copy a child record from one parent record to another. Example, John's time worked is the same as Tom's, so copy John's time detail for Tom's time worked. Setting on Tom's time record, the one after John's, I want to id the previous record serial. Seems to me to be a good use of GetNthRecord. So I try the following: Set Variable [$$TimeSheetID; Value:GetNthRecord (Time_Sheets::Serial; -1)] I can perform the process manually, but when data viewer reaches this statement it evaluates ? Sounds to me like type mismatch but all fields involved are text fields. Any ideas?? Tim

It's been awhile since I've been coding in FM so please bear with me. We're heading over to FM8 advanced and the final DBs will be served. Problem: I've been given a spreadsheet with hard and software purchases for our dept. I've created an inventory DB with hard, soft, location, and machine names tables, as well as a table that is a straight import from the spreadsheet. All I'm trying to do through Scriptmaker, is have a hardware and a software button in the imported inventory layout that will, on a record by record basis clicked by me, add a record to either the soft or hardware table, copy the field data to pertinent fields and then omit the record from …

Hi. How do I calculate the date of last month's first Monday ? Eg. If today is in the month of July 2006, the result will be June 5, 2006. Thanks in advance. Pumin

i am so close and yet so far away with this script. what i am trying to do is this (see attached example) the table, original conflicts will be existing, every day, users will enter in conflicts in the new filings table. i need a script to run that will go to the first record of new filings that hasn't been searched yet (so a search for already searched, "no" needs to be done first), copy the client field, go to original filings enter find put the copied client in the conflict field and find, if there is a match, paste it in a new record in conflicts found along with the associated case name, if it finds several matches, to loop through the findings in original conflicts …

Hey all. Could anyone tell me if it's at all possible to have today's date show (//) in the format July 5, 2006? Any help would be greatly appreciated.

I have an employees database and i'm trying to run a simple quick search without requiring the user to click any buttons (well... kind of). I have a Layout that displays a list of all the employees. In the header there's a Search Field (Text, Global). When you click on the Search Field there's a button that starts a script. The script takes you to the Search field and then it pauses indefinitely. The user types in the search criteria and... this is where i have the problem: once he typed the search strig i want the user to be able to just hit enter to run the search however if you hit enter it will just create a new line in the search text field, it won't resume …

After much searching I can't find a way to make this happen.....Is it possible? $FieldName = "Customer Name" Set Field $FieldName "Joe Blow" Thanks, Mel

Hi. I have a simple 3 Table DB. Planning Objects and a Join Table JOIN_plan_obj Those Objects are in fact People. People how won´t come to an event if there is her best Friend (the condition) also invited. To shorten the whole thing an objekt has just 2 fields. Name and Vorraussetzung (condition) What I like to do is: If i choose Someone who has got a Condition Partner, which is not jet in the Join Table,i like to get at least an error massage that i have to invite that Person first. A simple File is attached and Zipped. I think first of all i need to fill in the Condition Fields for the Peoples with their Keys. And then start some kind o…

Is there a way of obtaining whether a recordset is sorted in acsending or descending order? I've looks through the list of the Get commands, and cant seem to find it. The reason I want to know this is because I have navigation script which allows the users to go to the next or previous records. When the records are sorted on a numertic field, I tend to use decending (as I want the highest number at the top), and at this point the navigation buttons work backwords. Thanks for any advice

In FM7 I am trying to do the following. Our campers take buses that are referenced by color, like red, blue, green etc. We also have campers in July and in August. I tried to write a script to choose all July campers but allow the user to choose the color bus and then print out labels for all those in July that use whatever color the user chose. It just doesn't seem to work right. I tried to find all july campers and then do a paised find and run it constrained with the color. I wanted the user to put the color in a temp field and the script should place it in the find. Am I making any sense? Mike

Guys, Almost finished building a system in 8, and was thinking about this. At present my users can add delete, duplicate records within my system. In the past I've has users that have deleted records and then wanted tghem back, and FileMaker tends to do physical deletes. I am therefore considering incorporating a logical delete function in my solution, where I will add a delete flag to each table, and if the value is true, the user wont have access to that record (using privileges). Just want to hear if any of you guys have used this kind of method for deletion or would like to suggest an alternative method for retrieving "deleted records".

Hello Fellow/Female Datamates, I am looking for some help on… allowing user to control script by providing options, for example: PRINT -or- CANCEL If user chooses PRINT, script will continue to print. If user chooses CANCEL, script will close print window and return to original layout. I do not no how to set up script so these options are presented to user. Also, can there be more then tow options/choices? ——————— On that note, I would like to set up a REPORT script, that when ran, it will ask user… "Which report do you wish to run?" - Quote Script - Invoice Script then depending on users choice appropriate script will run. …

I've been using this calculation, where I know that I want the WindowWidth to be 1000 pixels wide. (Get ( WindowDesktopWidth ) / 2) - (Get ( WindowWidth ) / 2) This calculation can't seem to set the left position correctly when called as the script performed on open, as the WindowWidth hasn't been set until within this script step. It does work, if the script is manually activated, once the screen has been correctly sized but incorrectly positioned from start up. For now, I know that we want the window width to be 1000 and / 2 of this is 500 Therefore (Get ( WindowDesktopWidth ) / 2) - 500 works on start up . . . To test this, op…

I've got a layout I use to create (and print out) checks. It's simply a layout with a series of edit boxes and a portal on it. One of the edit boxes on this "checks" layout provides the amount. The whole layout works great, but I've got one little problem. I want the layout to generate a record only when the value in the [Amount] field reaches a certain value. How? I would make the [Amount] field a calculated field in some way. Right? I'm really in the dark as to how to go about this. Please help. Thanks, -Dave

Hey all, how is it possible to ged rid of annoying script messages after canceling a script step. For example: Export Records, window opens to save a file if I hit cancel in this window a new window pops up asking me "export Records has been canceled. Do you wish to continue with this script" how can I ignore this useless windows?? Thanks for the help!

Hi, I have two DataBases one Contacts and the other Invoices. I'm going to use the Invoice DB to print Invoices I have with customers. On the Invoices I need to include different types of contacts (IE: Primary, Billing, Support, etc). In the Contacts DB I have a feild for each contact type (IE: Primary, Billing, Support, etc.) which equal either "Yes" or "No". On my Invoices DB I created a "Primary_Name" field. What if statement do I need to use if Contact::Primary equals YES then populate with Contact::Name? Thanks!

not sure if this is the right place...if not, sorry. is there anyway to sort scripts in the script menu...alphabetically or such...i have a huge list... just wondering. thanks.

I’ve been struggled with this simple problem and I am sure (or I hope) someone out there has a simple solution. What I try to do is to remove the space and carriage in the last line of text. I know how to use substitute to remove carriage return, but I have a note field that carriage return is ok unless it is the last line of text. The note field need to convert to html format and the last carriage return (returns) is a pain to deal with. Thank you for your help. -JJ

I could really use some help trying to complete a script. Manh thanks to all who may help. I am trying to write a script tha honestly i'm not sure how to start. What i would like to do is first of all is copy the contents of one field (large blocks of text)into another field. After duplicating the infomation i would like to do a find and replace on all bullet points "•" and replace them with "+" then find all the hard returns "¶" adn relace them with a comma ",". If there was any way do this with a calculated field, tht would be even better. That way i would not have to run the script over and over. but how whould i know. That is why i ask the ex…

Forgive me again for asking a low-level question. I'm reading through my FMPro Bible and not finding anything on this topic, but I suspect it may be because I don't have the right word for it. I'd like to have a script where it will insert text "x" and "y" in several consecutive fields over many records. But, I'd like to be able to define "x" and "y" each time I run the script. I'd also like to be able to define the starting field each time. In other words, when I run the script I want it to ask me where to start filling in fields, and what to fill them in with. Is there a word for what I'm trying to do? Where can I find more information on it? Tha…

I created a script that executes when the file closes. It is assigned in the File Options menu item. These script steps cause the script itself to repeat (Close Window)..if it's the last window open (Exit Application) (Close File) However, if I try (Exit Script) or (Halt Script)the file won't close. QUESTION: What script steps can close the file without re-triggering the script that executes when the file is closing? I've attached the script that executes when the file is closing [color:green]g_LogOff and the script it calls, [color:orange]g_BackupCurrentFile.[/b] 1147816147-g_LogOff.txt 1147816157-g_BackupCurrentFile.txt

I'm using FMS 7 on Windows. I need to schedule a ScriptMaker script to run on one of the databases. What's the best approach? Under FileMaker 4, I used to just schedule a task on one of the clients that would open a dummy database that had no fields, but would run a script that ran external sub-scripts. I've found this approach to not be that reliable so I'd rather the server handle it. Thanks in advance.

I would like the ability to kick users from records (i.e. commit the record only for a second) during a script (it's a nightly script so they won't be doing anything anyway) - is there any way to do this short of kicking them off the server using idle connection time or things like that? i.e. any script step. Cheers, ~Genx

Hi guys, I'm trying to do something rather simple (...I thought at least).... I want to display a dialog so the user can enter a name for a "customer". If a record for this "customer" exists I want to display and edit this record, otherwise I want to create a new record with this name filled in. Here is my script: Enter Find Mode [ ] Show Custom Dialog [ Message: "Please enter name:"; Buttons: “OK”, “Cancel”; Input #1: Customer::Name, "Name:"] If [ Get (LastMessageChoice) = 1 ] Set Error Capture [ On ] Perform Find [ ] If [ Get ( LastError) > 0 ] New Record/Request Set Field [ Customer::Name ] End If End If The …

I think I want to use the Set Field script step. Here is what I want to do. It's really very simple. I've got table [Join], which has the following fields: [WellId] [OwnerId] [interestId] [interestType] [ProductionMonth] [Year] In a related table, [Owners], are the following fields: [GasPrice] [TaxRate] In another related table, [Wells], is field [McfId] My layout, "Data Entry," is based on table [Join]. I have value lists to populate all of the fields, and that works great, but I need to automate... (rhyme not intentional ) Here is what I want to do with layout "Data Entry" 0. Click a button to create a new record in table […

Hi Guys, Ive got a table which has got multiple types of data. In my interface file I allow the user to navigate through the records using scripted buttons (with the parameter next;previous). Some records maybe protected from certain users, so what I would like to do in my navigation script is to skip the records with <>. I've wrote a script to do this, but Im thinking that I could program this a little bit more elgantly and possibly introduce a recusrsive custom function? As I'm not too sure on hopw to write a CF, anyone out there that can help/guide me? I have attached my current navigation script as a pdf for anyone that wishes to see wh…

How can I auto enter information into a find a script? For example I would like my script to goto my field called "name", copy the name, enter find mode, paste into the field "name" then perform the find. I know this can all be done with an easy copy and paste script, but I know there is also a better way to do it with "set field" and the proper use of the find features. Problem is I can't figure it out. Can anyone help me out? thanks, Steve

I have a simple inventory database, where I want to use a button to set a field to either allow modification, or deny modification acording to the previous state. I just can't find a way to script the allow or disallow modification of a field. Am I completely missing it, or is it trickier than I first thought?

I'm a beginning Filemaker user! I'm using it at a driving school to keep track of student records. Basically, students are organized by student numbers, which include a class number (a number might be 06-003-04, which means the student is #4 of the class 06-003). One of the things that we do regularly is enter attendance. I've figured out how to make a script to do that: it's a pretty basic "Insert...next field...insert" script. But it doesn't take into account kids that were absent on a given day. Here's what I'd like my script to be able to do. I'd like it to ask me for the last names of the students who are to be omitted from the attendance marking (the …

I have made a test file for myself to work out some scripting which I want to include in a larger budget accounting file I want to make. The file has one table 'main', with the fields budget category [indexed] transaction transaction date transaction month [calc, indexed] transaction year [calc, indexed] and an occurrence of the table 'main' called 'main for scripted total' related to the 'main' table by budget category, transaction month and transaction year What I would like to do, ultimately, if I can figure out how to do it, is script the creation of new records and individual budget category totals and subtotals. I want to set these fields so …

Is it possible to hyperlink out of filemaker to open other folder on the disk ?

I'm using the go to portal row script step, but need to define the active portal. At present, the script goes to the wrong portal. Thanks

Is there any way to trigger a script upon selecting a menu item? Thanks

Are there any comands in the custom dialog to have a simple line break, just like a line or 2 space in between tex? Thanks

I need to write a close script to find all the blank records and delete them upon closing, I wrote a script to find the blanks in a field but when the field is already blank it trys to delete the entire data base is there a way to do this. Thanks in advance. Randy

Hi Gang, I have a FM database that several users will be able to access simultanously. I want to have a place where I can see which users are currently logged on. Is this possible? I know that if I click to close the file, then a list of connected users appear. I want to do a more elegant solution. Thanks, Nandito

I have a layout with a portal that displays all the records using a [x] self join. I want to be able to sort the portal using buttons on the layout above each portal field (to mimic a table- like layout). How would i script it so that the buttons can sort the portal and toggle between ascending and descending?

I am trying to write a script to create an import process into a specific temp table. The data will then be manipulated and placed in the main table. I have tried selecting a table (is there a function for this?) before I run the import function but all I get is the main table as a choice and all others are hidden. I have also tried a Perform Find on the temp table to try and select it but that did not work either. Is there a way to explicity state which table to use for the import and delete all records command? I even made a relationship between the main table and the temp table, though I don't really want one. The Perform Find might help but I can only …

This seems like the most basic Find function but I can't make it work. I need a script to go from my portalled Invoice to the related Line Items database and find all the related records. They are related by Invoice Number. In other words once I am in the Line Items, I need to be able to enter find mode, and somehow use the Invoice number as the Find criterion. Seems like in Filemaker 5, I could just enter Find mode, then tell the script to go to the Invoice Number field and Paste the contents of the clipboard, then perform the Find. Well, the field never gets pasted into. I can't find any way to script a find request by using the contents of another field, eit…

HI folks, I have created a script to find duplicate email addresses. First it finds all records that has something in the field and that part works fine. But when it enters the loop to mark duplicate records based on two fields, I keep getting the same number of records that it found when it was checking to see what records had something in the email address field to start with. I even threw in some show custom dialog boxes to see what was the content of some of my fields during the script process and I can't figure it out. Note: Neither the DupCheck or Mark Record fields are globals. These two fields as well as the email address field are text fields. ---…

Hey, Just wanting to know how / if it's possible to identify a field as Table::Field rather than having to pick the value from a dialog when using the set field step. Thanks, ~Genx

I have a Master table of test names that I want to copy into another table, one record in the second table fore each record in the Master Table. I previous versions of FM I would just import the fields from the master file into the second file, but am at a loss to know how to accomplish this in the FM8. Can anyone please suggest a solution? Thanks!

I am writing a script to take transaction information from a transaction file, format it, and send it to a holding file (where the info waits to be transferred to a mainframe via PHP). The format of the transaction file is: Headre info Detail Line Info Trailer Info So one transaction record = three records in the holding file. I would like to lock the holding file while the three records for the transaction file are being created to avoid the possibility that two transactions are added at the same time, causing the Header / Detail / trailer order to get mixed up. Is there a way to lock a file at the beginning of a script so that only the current …

I need to write a script that will copy the entire field contents from 1 table to another. I need to do this for multiple fields. Can anyone help with the "Set Field" parameters to do this? Thanks in advance for any help! John

I have a related db and I would like to automatically generate a PDF document of a selected record and send it by email . Could this action be initiated when data is entered in a designated field ? Any ideas and guidance would be much appreciated.

Hello - I was wondering if it was possible to create a button that, when pressed, would be programmed to open up an Entourage (Mac email) window with the email address from a specified field in the 'To' field of the Entourage window? Thanks for any help!

Hi - I am new to FileMaker (Pro 7), though I've worked a bit with Access... I have created a report which is printed when a button I scripted is pressed. Under this button I have created a field which I would like to be automatically filled in with the date of impression of the report. How do I do this? I'm sorry if someone has already asked this question - I coudn't find an adequate response. Thanks!

Can the SendMail script step send without prompting? I built a button that sends a preconfigured email message. It works but it prompts the user to confirm. I have set the step to "Perform without Dialog" but when the button is clicked, a window (that appears to be from FM) pops up saying, "A program is attemping to send the follwing email message on your behalf:" Is there a way to perform this entire task without prompting?

I would like to refresh a Find every five minutes to show a list of patients who have arrived, but have not been seen. The Find is easy, but how do I script it to run without manually triggering it? ~Dennis

I am trying to make a button so that when it is clicked, it checks to see what the value of a radio button is...and depending on the value, shows a certain layout. i have it so that it gets the table and the field name...but i'm not sure how to say what i want it to be equal to. ie. If table::fieldname = ...?

Hi all, I know how to specify a file and run a script in that file, but can that file be dynamically selected? I plan to use this in my navigation system. Any ideas? Tim

I have two scripts, "Swipe" and "Process. 1.) Swipe - Simply navigates to a credit card swipe field. When the user swipes the card it parses the data into the appropriate fields. 2.) Process - Send the swiped data to the credit card company and returns the results. I want to execute both tasks in one button click. I would like the script to prompt for user to scan card...and then automatically go to step two after they swipe it. It takes 3-5 seconds for the magnetic reader to send the data and another second to parse it but I would prefer to not force the user to scan the card within a certain number of seconds, I am looking for a solution that does…

How can I prevent the script from opening a window if it already exists? I have a script that opens a new window with a keypad for numeric entry. Users at the kiosk keep clicking on the window behind the keypad (hiding it) and then the script creates a new one each time that it is run.

Situation: I have two Databases. One is called Companies, the other Contacts. Each company record has a LocationID. Each contact has a ContactID, but also has a LocationID so they are assigned/related to a particular company. Fact: In the past, I have re-numbered ContactID, no problems, but that was ok, as LocationID in both databases were obviously unaffected. Basically I know how to re-number a field. Problem: I will be merging some other database data into the Companies and Contacts databases. However, the there is a conflict with the LocationID's in the databases that are to be merged. Question: So all contacts are still assigned/related to same co…

Is there a step i can add to a script, that IF there is NO Records found, then I get a (0)Zero value that i can paste into a field? At the moment, if NO Records are found i Get the dialog box asking to Modify/Continue/Cancel Find. Any Help appreciated... Corey....

This is probably pretty easy, but I am new to Filemaker and could use some help. I have two tables with the same fields. One table is used to validate the field. Once validated, I want to copy the contents of the field into the Master Table. Validation Table___________Master Table ------------------------------------------------- Name ---copy entire contents> Name address -copy entire contents> address I want to write a script that will copy from the validation fields to the Master fields (same names) after a user validates the information. I beleive Set Field is the best method for this. I cannot figure out the calculation to select the en…

This one is most likely a no brainer for fm pros...but I am a novice at best. I have a repeating date field that I need to auto enter the current date each time an inspection is performed. I can get my script to check for empty, enter the date, and advance to the next field, if not empty - but that's as far as I can go. I'm thinking I need a loop in here some where to dig down untill I reach the first empty field, but I can't quite figure out the loop function. Here's what I've got so far: Go to field ["Recheck Date"] If["IsEmpty{Recheck Date}"] Insert Current Date Else Go to next field End If Any Suggestions??

I am attaching a copy of my script for any help suggestions anyone may have. First problem: Every few runs the script crashes FM and I must restart it. I have not had more than 50 records in the queue at any time. It has happened with as few a 4 records. Second problem: As you will note I am creating a history log after each email is sent. To send 36 emails took about 6 minutes. I am assuming it is the create record portion that is slowing down the process. Is there a way to send the emails first and create the records afterwards? Third problem: The ::gMailSent counter drove me nuts. I finally have it working, but can't help but feel it could hav…

Hi guys and gals, I have a question relating to data verification in portal rows. I have a relationship of invoice -> invoice credit -> receipt. The receipt table holds the details of a payment received by us from a customer. The amount of the customer payment can then be divided up into as many invoice credit records as desired. An invoice credit may only be attached to one invoice, but an invoice may have any number of credits attached. Similarly, any number of credits are allowed per receipt - so long as the numbers add up. The invoice credits, not the receipts, affect the final invoice balance, which is a value copied from a calculated field to a non-c…

in what way does FMP8 store the index? by that i mean; does it simply assign index to every entry (using the "Auto-enter Serial") cronologicly or can i hash the index some how? my point is that i dont want to end up with empty spaces if i delete, update or move anything, you know the old reoccuring problem... :

When creating a record I need a number inserted in order to count the records that are related to a given master file. I.E. Our bids have multiple rooms, each room needs a serial number. Kitchen, 1, Bathroom, 2 etc. I have tried multiple ways to find the current record count, add one to that, etc... I know it is something simple, i just can't figure it out.!?.

Is there a way that I can script to have a user interface to enter the find parmaters. For example, say I want to find data entered between two dates, but I want to user to set the dates each time they run the script. Is there a way to have say a box pops up that the user can enter the start date (START), and click enter and the another box pops up and the user enters the end date (END) and then the scripts finds START..END? I come from using MS Access and could do this in that program, looking to see if there is a similar function here? Thanks, Scott

Ok, this is driving me nuts. Newly converted FMP5 to FMP8 solution. Lots of portals to other files, etc. I generally have a "green button" on my portal rows to allow us to jump from, say, a jobs file with a task portal to each particular task. Some of these simply used the "go to related record" button event, and some used scripts when I needed additional steps to be taken in FMP5. Problem is, these two steps don't seem to work the same anymore? The button event takes me to the right record in the other file, as I expect, but the "Go to Related Record" script step does NOT take me there, or can take me there but only finds the first related script …

I have two unrelated tables - table A and table B. I am trying to place a layout name from table A into table B using scripts. I have a calc field (gTableName) in table A that gets the LayoutTableName; I want to place the value of gTableName in to a field (tableName)in table B. I am trying to avoid a relationship, because table A is already related to another parent table. I get an error when trying to relate table B to table A, because table A is related to another parent table. Thanks

Hi, I thought I'd try using FM's built-incustom dialog instead of designing a new layout for one input field. Problem is, if I try and enter a non-numberic value directly into the global field, it fails - as it should. But the custom dialog using the same global field happily accepts and sets the field with data that violates the validation rules. Error capture has been on and off (and captures zero when on) so I presume this is either a bug or I've missed something. Help appreciated! Best wishes, dave,

I have a scripted "print" button that inserts today's date in a field. When I use the button I get the print dialog box and I can select from "Current Record", "Records Being Browsed" (the default), and "Blank Record". When I print all the "Records Being Browsed" I'd like to have the date inserted on all the records but as it is now, it only inserts the date on the first record. Is there any way to have it insert the date on all the records that get printed? Thanks! Deborah

Question on how to auto generate IP address into IP table? For example, When I fill the field called LAN range as 192.168.2.0/255.255.255.0, then I want it to generate the range of IP from 192.168.2.1 to 192.168.2.255 into the IP table. The IP table has field called IP. How to write the script?

Meant to put this in Define Fields. OK. I looked through the posts and can't figure this one out. I have one date, a Deadline date, and need to show the date 3 days prior from that date. The problem is I can't include weekend days. All the formulas I have seen are based off of a start and end date. Even when I reference a field (end date) that takes the Deadline and subtracts 3 days it doesn't worked. Thanks for any help. I am sure I am missing something.

I am creating an on screen keyboard for a touch screen kiosk and I can not figure out how to send a command that executes a backspace or a (delete). I posted this question to another area of this website but judging from the lack of replies I think that it should have been posted in this section. I am pretty new to FM 7 & 8 so I am probably doing lots of things the wrong way. I need to get this up and running tonight for a customer install tomorrow. Here is a sample of my file. Any help would be greatly appreciated. KEYBOARD.zip

Can anyone provide a script for this? I currently have 4 tables and layouts: Invoice, Clients, Services, Lines items each with their own auto entered id's and related fields. I been really learning a lot with the redesign business and invoicing coming from a "flat file" mindset . . . and still learning more with now scripting. Any help would be greatly appreciated. -brian