Script Workspace and Script Triggers

This is weird - I always write two scripts in my data bases; Command 1 takes me to the main data input screen, and command 2 puts me into Find mode, and places the cursor in a field I call Findit (a concatenation of the name, address, telephone numbers, etc.). Yesterday I found that these keyboard commands no longer work in any of my data bases; also those that have a script for Command 3 do not work. All of them that use Command 4 and above do work. I can select them from the Scripts menu, and they work. If I move them down the list, so that they become triggered by Command 4 or above, they respond to the keyboard. I am running on a Mac with OS 10.3.9; I'm usin…

What is the scripted equivalent of striking the "Enter" key and/or clicking the mouse in an area not containing a field, etc.? I'm always finding myself wanting to update the current record I'm viewing without a field being selected, etc...and refresh window doesn't seem to be the key. Thanks in advance.

Hi Guys I'm creating a script to add 2 carriage returns and some specified text to a field. How do I ensure that the cursor postion is moved to the end of any text already in this field? Thanks

I want to copy the value of a calculation field in one table to a field in a related record on a related table. I tried all kinds of scripts and calculations but I'm not getting the result I need. Am I overlooking something simple? This application requires single or multiple ticket numbers for each registration in a particular city. [Location] table contains one record for each location. New records are created in the related [registration] table. I have the ticket numbers(incremental numbers)based on the [location::last number used]. So, when new #s auto-enter in [registration::tkt], I want [location::last_number_used] to be updated. Possible? I'm stuck on…

Let me see if I can explain my latest difficulity. Say you have 10 fields...with 3 of them containing data and the rest empty, like: field01= "" field02= 2 field03= "" field04= "" field05= 5 field06= "" field07= "" field08= "" field09= 9 field10= "" What I'd like to do is write a button script that "moves up" the 3 fields which have data (in numeric order) to end up with: field01= 2 field02= 5 field03= 9 field04= "" field05= "" field06= "" field07= "" field08= "" field09= "" field10= "" I'm not sure if this is some sort of sort function or something else which is as yet unknown to me. As usual, thanks in advance for …

Greetings, I was talking with a teacher friend, and afterwards I was very curious about how to do the task below within Filemaker. I have known it is used often for parsing text, but I have never delved into that aspect... Anyhow we were talking about different categories, and mixing/combining them. So say you have Category A, B, and C. I have given them each their own table. Each one consists only of 1 field really, and each record set is just words. Within the main Category (A) I have a text Field that I want to have combined text in. For example: A+B A+C B+C etc (All within the same field, each having their own 'line') I tried …

I have the following script I'm using to determine the textColor of a field based on its contents: If [ testData::r001 = "√" ] Set Field [ testData::r001; TextColor ( testData::r001 ; RGB ( 25 ; 125 ; 50 ) ) ] Else Set Field [ testData::r001; TextColor ( testData::r001 ; RGB ( 235 ; 30 ; 35 ) ) ] End If You'll note that I'm applying this to field "r001"...I have 100 of these types of fields ("r001" - "r100"). The question is can I apply this script to all of them without having to repeat the script 100 times? Thanks in advance for any assistance.

Hi all, How can I protect against someone canceling a print and getting stuck in a layout in preview mode. Let me explain. I have a print script. The print dialog box comes up so the user can check the document about to be printed and choose a printer. If the user hits cancel, a dialog box appears saying "Print has been canceled. do you wish to continue with this script". Well, if the user hits cancel (for whatever unknown reason) they are now stuck in the print layout in preview mode. This does not seem to have an error code attached to it, because I have tried error capture on and no luck. So how can I protect againstv this happening? Thanks

What kinds of things can I count on not working in a modular form. I ask mostly because i was just modifing a fm 6 app for a client and found a situation where modularizing a 13 step script would save me alot of time. The script how ever did a slightly different find depending on a custom dialog box. Even though this script is called by scripts in the same file it seemed to ignore my find requests. what else should i expect not to work?

I am setting up a system that receives an order and warehouse staff will pick that order. Is there a way to send a realtime notification to the warehouse staff who are logged into the same system in a different location that there is a new order? Like an event trigger.

I want to know if I setup a database that uses multiple files, can I use the user login info from the home file in the other files? In other words, when a user signs into the main file and another file is called that should allow only records entered by the user to be shown, will the original user info carry over to the newly opened file?

I decided it would be quickest to take 10 minutes and write a sample file. What I want is the check boxes next to the dynamic month grid to autofill out the correct month in the check boxes in months below. Thanks Tony D.

We have a cross platform FM7 deployment that runs on Server7. An important part of of our business process requires that we attach a PDF of a scanned document to a record and to date I have done this using Insert File and stored it as a reference. The challenge is that when I do this on a Windows client I can't open the referenced link on the Mac and vice versa and opening this document when one of our customers call is very important. I would like to avoid storing the actual file in the database if possible. Any suggestions would be much appreciated. Many thanks.

First Question is this. Ok I have an imported list of dates from the previous program we were using here. In our new program I do not use date ranges I use check boxes. I need a way to assign date ranges to check boxes. Example ( )January 2005 = [color:red]1-1-05 to 1-31-05 ( )February 2005 = [color:red]2-1-05 to 2-28-05 ( )March 2005 = [color:red]3-1-05 to 3-31-05 Question two is this. How can I tell the software which one is first in sequence and last in a sequence so I can set up alerts for accounts who has a contract coming to an end. Example (x)jan (x)may ( )sep (x)feb (x)jun ( )oct (x)mar ( )jul ( )nov (x)apr ( )aug ( …

i initially posted a faulty script of mine here: faulyt script all the help i got before took me through extra steps and having to make new fields, which wasn't what i was looking for so i sat down racked my brain and found my own answer: a script to do a "search" for two or more possible values in a single field: go to record/request/page [first] loop if [table::feild = X xor table::field = Y] go to record/request/page [next;exit after last] else omit record go to record/request/page [first] end if end loop thats it what do you guys think?

I am setting up a system to run about 10 different database files. When a user logs onto the main file to login to the database, will this login info be carried over to the other files as they are called? Also, some of these other files have records that will only be shown to the user that created that record. How can I setup the system so that only the records entered by the user are shown in the main DB file and the other DB files as they are called? I hope this is not to confusing.

I'm going gray over this one. I know this is not a FM issue but I cannot get FM to perform the DDE Execute until I get it sorted out. Does anybody know where I can locate a list of the commands that MS Excel will accept through a DDE link? I need to do some pretty simple things in Excel with some summary data from FM but I would like to do it without user input. I cannot find much in the archives, Excel help file or the MS web page?

I have a simple script that creates a thumbnail for a given record based on the image path in that record. I have imported all of the correct image paths but now I need filemaker to physically make the thumbnails. How can I modify this script to go through all the records in a found set and perform this function??? Set Field [images::Thumbnail; images::image_path]

Greetings! Brief/Short Version: When creating a new Record for Table A, can you go to a related record from Table A via a script? There is also Table B, which might have several records in A linked to a single record in B (via a letter, in a portal). The field I want to go to a related record from, contains a letter (A, B, C, etc) that specifies which record within that record of Table B coresponds to it. Example: I am in Table B. I open a Layout which makes a new record within Table A but keeps it linked to that record in B. There is also a field which has a pop-up containing all records that exist in Table A for that record in Table B. Is it poss…

I have two tables; "TableA" and "TableB". Each table has four fields; "1", "2", "3", "4". What I want to do is... When I create a new record in TableB, I'd like to do something like this: TableB/Field1 = TableA/RecordX/Field1 TableB/Field2 = TableA/RecordX/Field2 TableB/Field3 = TableA/RecordX/Field3 TableB/Field4 = TableA/RecordX/Field4 "RecordX" is a specific record in TableA...it never changes. I can get this to work using a series of Go To/Copy/Paste type of scripts, but this doesn't seem to be very elegant and I have the feeling I'm not fully understanding the power of relational dB (I'm new here, remember) and that there must/should be a more ef…

i have this script Go to record/request [first] Loop If[job info::ship date < job info::date 1 shipping or job info::ship date > job info::date 2 shipping] Omit Record End If Go to record/request [next:exit after last] End Loop its supposed to compare the dates from date 1 shipping and date 2 shipping to the ship date field in the record and if it doesn't fall between the two entered dates then it is omited, now here is the catch when i hit the button to which this script is defined it works....sorta...it does about 1/3 of the records then stops...and if you click it again...it does 1/3 of what was left after the first click..and so on and …

I have a database in FMP7 that I enter a company's daily stock numbers. Example High, Low, Open, Volume etc. On another layout I have a portal that shows each days results for a company. Next to the portal I'd like to show the weekly average in a field for High, Low, Open etc. based on a range of dates that I type in like 02/03/2005...02/08/2005. I'd appreciate any help

I want to be able to set the start month in a field on the page. From that start month I want it to dynamicly fill out 12 fields with all the months from the start month. I have included a file to look at is much more descriptive and easier to understand.

Is there any way to organize scripts by category? The ideal method would be something like a conditional value list where by I could, for example, select GO TO scripts and sub-select GO TO SPECIFIC LAYOUT scripts. Does anybody have a management type plug in for this? Thanks, Jarvis

I tried to print a script. I selected Print to File and Generic/Text Only. There were 2 problems. First: The screen became partially filled with large black characters written on top of each other. Second: When I opened the file that I selected, There was nothing there. I used Wordpad to open the file. Is this supposed to work? Printing the script directly to a printer works fine. Dave

I can not find my script that will allow me to: Add the word USA into the field Country for all records. Currently, all the records have nothing(blank) in the field Country. Can someone help me here, Thanks Chuck PS I am on version Filemaker 6

Hi, I am developing a filemaker application that requires users to enter in a username and password. What I need the system to do is only display the information related to that user for each of the layouts. Admin will have access to all. Is there an easy way of doing this in FM7 Developer? Thanks, Coffee.

I have three tables - Owner, Manager, Management Company. I want to create a contact list with all the basic contact information, but also includes a Title (Owner, Manager, Management). I want then to be able to display in respective portals on the specific company page all contact names associated with each title. I have put together a few trials but I cannot get them to display according to title. And I also have trouble displaying multiple records of contacts for a single company. Thanks

I have a message box in one of my scripts that I do not want the user to have the ability to close by clicking on the little "X" in the upper right corner. Is this possible? Can this feature be overridden and how? If not. How do I get my script to 'halt' if this button is used by the user? Thanks.

If you use the insert file script option to actually store the file within FMP in a container field, how do you either open the stored file or copy it out of filemaker? I don't want to store the reference path. I wish to store an actual Word doc. And then I want to either launch the word doc from within filemaker, or be able to copy to the desktop to open it. What am I missing here? Thanks David

I am trying to create a solution for a recruitment company. I've set up separate databases for recruiter details, and candidate details. Each candidate, and each recruiter is assigned a serial number as a reference ID. No problems there. Now, what I've been asked to do is have it so that you can go to the record for a specific recruiter, and see all the candidates who are related in whatever way to that, and vice versa. After trawling through the FM5 help files, I eventually got a many-to-many relationship up and running using the reference IDs as the base relationships. What I'm trying to do now, however, is get it so that, say, you click on a specific ca…

Still learning here...but it's not like I didn't try to find the answer to this elsewhere, so thanks in advance for helping with a "101" question...which is... How can I insert a record in a specific place? Meaning, say I have 10 records and I'm viewing Record5. Now I want to insert a new record right there so it becomes the new Record6, and the other record numbers (which I'm serializing and assuming I can use Get ( RecordNumber )) adjust accordingly. Thanks again for any assistance or suggestions or FM Manual page numbers, etc.

is there a script that if you have field "A" with a value list of "x,y,z" you can define a value list for field "B" out of a value lists "1,2, or 3" depending on what is chosen out of "x,y,z"?

Is there any way to tell a field that if it is defined as being 5 characters in lenght, that when the field is full to go on to the next ? Tks

I have an artist field in an artwork record. Upon entering the field I would like FM to check the name against the records in the artist table. This I know how to do. However, when the name doesn't come up a match I would like to go to a particular layout or be able to run a script that prompts me to add a new artist record. How do I do that???

I'm quite sure the answer to this is obvious. I would like to be able to place a number in a field...and then have a script which uses that number to create said number of blank records ("5" = 5 New Records). I can't seem to find any such "Create Multiple New Records" functionality. Thanks in advance for any help or suggestions. Kirk

Hi everyone, Because of a prior post, which I almost (out of excitement and curiosity) hijacked, I wish for feedback and enlightenment on this subject. In this post , Soren said ... My response (moved here to be polite to those on the other thread), was going to be: Soren, my goodness ... you almost make it sound like you're not quite sure exactly WHERE to put Commits!! The word 'sprinkling' suggests a hit-or-miss pattern. I realize you probably said it in that way because you have no idea what the scripts involve, but I couldn't help but jump in. Am I being condescending? Nope. Just curious. Because *I* feel uncertain almost daily on where a Com…

I'm working for an organization that want to keep track of art works by artists. I'm attempting to create a button that will allow a new art work to be entered under an artist. The goal is to have each record contain information about the artist (which will be the same for each piece of art entered) and information about the piece of art work. What kind of script will create a new record, keep the information about the artist but clear the information about the art work so that new information about a different piece of work can be entered. please help

Well, i'm stuck! This is the problem. I have a couple of scripts working togheter. The first one looks like this. Go to record - First Loop If (check = "A") Set field (temp; someText) Perform Script (Script 2) Else If Set field (temp; somethingElse) Perform Script (Script 2) End If Go to record (Next; Exit after last) End Loop Then in script 2 theres a couple of other arguments and if's but it calls a third script. The problem is that when i let "chain" go to the third script (1 -> 2 -> 3) then it won't continue looping in the first script. But if i replace the 2 or 3 script with a simple one ju…

1. Within "Define Scripts" window... how do I copy my work (so I can show you what I've done) - copy/paste is not an option. 2. What is the best way to search for "IF" and "CASE" examples in context (vs. random use of these words) 3. My statement below works, but seems there would be a more efficient way in ONE line vs. many. Can you pls suggest a better way? If [test = "x"] Go to Layout ["x"] Else If [test = "y"] Go to Layout ["y"] and so forth... End If Much appreciated for your help. Thanks in adv.

basic contact sheet. I want to filter out names without certain area codes. I have 4 phone number fields, each 10 digit US numbers. any help would be appreciated.

I have a script that, among other things, counts records according to the content of a given field to later be displayed in a report header. I'm currently keeping the counts in global fields. However, if another user executes the same script with a different found set, the first user's global field value are mangled. Is there a way to define a "private" field or variable (other than the copy/paste buffer in Windows) that carries values specific to the current FileMaker invocation? Thanks for any help, Joe

OK Here is what I want. I need a way to add a note on a new line without deleting any of the old information. I have included a stripped clone of my File I am using it in. PLz help me solve this issue. Staff_Clone.zip

Hello, I have a script that performs a find then has an if - else statement based on the number of found records. It is perfectly reasonable to expect to not have any find results - The script is supposed to locate search terms with no results and perform an action based on that information. The problem I have is that Filemaker keeps popping me out of the script and asks me if I want to modify the find since there were no results. I am forced to sit and click "continue, continue, continue" over and over again. . . Of course, this is tedious and I feel like there must be some way to suppress this popup window. . or perhaps another way to perform this find. .…

How do I get the loop, see below, to exit after it has checked the last record? I've tried doing the same thing with Next Record - Exit After Last, but the script exits after only one iteration. It doesn't continue even though I've checked Exit after Last. Loop If ["Contact = "N_A""] Set field ["Contact = "Not Applicable""] Else Omit Record End If End Loop

hello all, the title says it all. Is there anyway to disable the use of a button by using a script. thx

Hi all, I

how is this done? i have a database showing 2 types of disbursements - expenses and purchases. if the entry is an expense, it should proceed with a certain layout, if a purchase another layout. I use FM7.

I am extremely new to FileMaker, and I am trying to write a simple script that will add all the values of a particular field throughout the database (MA) and divide it by the number of records (count) to get the average (MAA). I realize that there is an average function, but it's not working either, for some reason. Right now I have two test records in, the first being "5" and the second being "3". I set MAA to a global number, and I set MA to a number. But when run it from the first record, it gives me "5", and when I run it from the second record, it gives me "3". There is something I obviously am misunderstanding, so I am going to post the code here. Hopefully you guys…

Hi, I am creating a database of gene sequences and am having difficulty with a script to name new entries. My goal is to have a script to automatically assign a name to new entries, based on the values of other fields in that record. Each name must be unique. However, at times several records have identical field entries, and this would create identical names, so I am trying to automatically append a number at the end of the name, such as "01", "02", etc... The script should find all of the records with the same name base (ie all records that would otherwise have the same name), count them, and then add that value + 1 to the end of the name of the new record. …

So you can change to a layout based on a calculation, but I can't find anyway to call a script by a calculation. I'd like to store a script name in a record, and when a button is pressed on that record call that script. Anyway to do this? I'm about to try using the MacExample plugin with XMpl_StartScript

I'm building a program to look up an area code and display the time it is currently in that area code. I have a script which enters find mode, then I want it to perform the find and after the record is found and displayed, calculate and display the time at that area code. The problem is that after entering find mode it immediately goes to the calculation line. Putting a pause it doesn't stop this. Any ideas how to do this in the same script?

I have a script that creates a windows folder on my server drive o: with the same title as an estimate number generated by FM. Now, I want to copy sub-folders contained within another file at o:templates and paste them to o:Estimate_Log::Estimate Number which was just created. I'm not familiar with the send event or cmd language and have been shooting in the dark. Thanks for your help! Joe

While i search the forums here for my answer i thought i'd ask the question (I suck at useing search tools for some reason). I'd like to stop a running paused script. It comes down to me modify'n another solution that i did not write and the previous programmer didn't add in a return to menu button in this find algorithm. The algorithm sets a few globals, then goes to layout to collect the search criteria and does a pause/resume script step right after that is an if statment that checks to make sure both fields on the layout are full of something and does the find or informs the user that either or both fields where still empty. I'm trying to figure out how to c…

Hi, I'm new here and working with Filemaker 5.5 I'm trying to generate records based on two tables. Every combination of fields in the 2 tables should be generated. Another thread suggested something like: Set Field [ Counter; 0 ] Loop Duplicate Record/Request Set Field [ Counter; Counter + 1 ] Exit Loop If [ Counter = 200 ] End Loop ...I invented something like this (I'm a beginner) but my script doesn't stop. I would appreciate any help. Thanx a lot.

I've got a script that creates a new window for someone to enter a search criteria, and I set it to just be like a small pop-up window. However, when I'm viewing the main part of the database in full screen, it always switched to only a partially expanded view when I run the script with the new window. Is there a way to get a new window to open up on top of a window and keep the bottom window in full screen viewing mode? Thanks.

I want to create say 200 duplicate records at once, with consecutive serial numbers. I'm ok with the serial no. side of it but not the script to limit the creation of records to a set number. Appreciate any assistance.

I am trying to write a script, and I'm having problems. I tried to turn on the Debug feature, but it does not show up in my Scripts menu. Is there a switch or a preference that I don't know about? TIA

I have a layout which has a TO and a portal. If I wish to revert changes, I believe that I can only revert changes to the last record. If the user has started to enter data into the portal, then the changes to the main record are automatically committed. I want to put a button on the form to revert the changes, but I would like to put out a meaningful message, telling them that since they have inserted data into the portal they will not be able to revert the changes to the main record. Is there a function to determine the name of the "active TO"? p.s. Does anyone know why it is so hard to find any help on the Get function?

Hi, I'm using FMP 5 and Outlook Express. Today I migrated all my files (and supposedly all my settings, but we know how well THAT works) to a new computer. My 'send email' scripts still work (I believe) but are apparently sending the output into cyberspace instead of to my OE outbox. The only difference is that OE no longer has a user name for me, but I cannot find anything in FMP 5 pointing to a particular username or even email client. Can I fix this without having to delete and rewrite my scripts??

Is there a way I can make FM look for a picture in a certain folder then have the picture automatically get inserted in the proper field when I enter a name in another field? For example: I have three fields, First name, Last name & Picture. When I enter a name in both name fields I want FM to search a certain folder for a picture with that name and place it in the Picture field... Basically: first name + last name = image

Hello Everyone, I'm sorry if this is an easy problem. I'm pretty new to scripts, but o.k. with FM in general. I looked through alot of the old posts but still couldn't figure out how to make it work for my situation, or just didn't understand. Setup - I am trying to develop a database for my company that can create pieces for assembly. Each piece is unique but many pieces may combine to make a bigger item. Table1=Piece Builder Table2=Burning Details Table3=Sawing Details Table4=Purchase Details The tables are relational through field "Piece Number" I want our engineer to start with "Piece Builder." Be able to find a job # from another or…

Hello, I created a button below an object (a PDF file) in a container that says "print". Upon clicking it, I would like it to run a script to open the PDF file in that container, print it, and then close the PDF file. Any thoughts? Greg

This is kinda related to faxing ad printing, but there so little traffic in the faxing forum, so... Is there a way to fill out dialogs that script steps like [print] produce? I can choose "Specify print options" but I can only choose the options once, I can't choose them dynamically via the script. What I'm trying to do is fax a layout. I either want to choose the fax option and fill out the phone number with the customer's fax number, or I want to save a PDF to a temp file with a unique name so it doesn't get overwritten by a subsequent fax script. I can't figure out how to do either. I think it might be a job for AppleScript, but so far I'm striking out there …

I was just wondering if there is a way to email a straight text email (optional attachments) straight from filemaker to your ISP's SMTP relay instead of having filemaker open up your default email program. I need to implement automatic email notifications from certain events in the database. Thanks in advance. Coffee.

I have a membership database that contains several fields but I only need to print a few of them. Is it possible to sort and print the following ?--> Current Date Chapter First Name Last Name I am a FM newbie who is slowly learning how to write my own scripts but this one has me stumped. Any advice or suggestions would be greatly appreciated.

Longtime listener, first time caller, finally over my head. I've set up a self-join relationship, created a portal and scripted to delete dupes, as outlined here for FMP 6. Yet no records are deleted. My script: Go to layout ["de-dupe"(LegacyTest)] Loop Loop Exit loop if [ "Count ( LegacyTest 2::unique ) = 1"] Go to portal row [select, First] Delete portal row [No dialog] End loop Go to Record/Request/Page [Next; exit after last] End loop I'm hopeful that the problem is something that is new in 7 and only I don't know it. Any thoughts?

Is there a Line Item in a script that can tell the script who is logged in. Let me explane this a little more: I want to make a script that is an If else statement If [john] is running the script -- then do this else do this. can this be done? Help Joseph

I have a script which automatically imports (on a Mac) the last photo from a digital camera into a field. This works fine, but one thing I've noticed is that if there is no camera connected, it pops-up an error message and then goes ahead and imports whatever the last image that was imported into the field. Is it possible to check to see if the camera is, in fact connected somehow and then not do the import?

I am trying to get into a container text field information that I type in a DOS shell. Using Send Event Script Step I have worked with a .bat file to rename and copy files on the hard drive. But now I am trying to copy the results of a command to a Global text field. For instance, if I type dir I want to get the result of that command into the text field. There may be a command to store that result into a log file. If that is possible then I could only import that log file into the database. Thanks...

Hi everyone, I have a solution where on startup, it opens a PDF read me file and places it in the background using the send event script step. (This speeds up the "Help" button I have created). The problem I have is when the solution is closed, I want to close the PDF, but I can't find a script step to do this. Is there one? Is ther another option? Thanks in advance.

Hello, I want to know how can i make find loops so everytime i try to find something the next new result is going under the previous one. So as if i make 5 finds i will have the first line will be the first one the second one the results from the second one and etc. So if i have a table view i can see the one result under the other one. Can someone please help me?:???Thank you :

HI, i START USING FILEMAKER FOR A FEW DAYS NOW. I'M TRYING TO BUILD A DATABASE WITH CUSTOMERS AND THEN A NEW LAYOUT IN WHICH IF SOMEONE ENTER A UNIQUE ID CODE OF THE CUSTOMER IT WILL SHOW ALL HIW DETAILS IN A SINGLE LINE AND THEN FROM BELOW YOU CAN ENTER ANOTHER ONE AND SHOW YOU THE NEXT CUSTOMER DETAILS AND SO ON. SO IN ONE PAGE U HAVE MANY CUSTOMERS DETAILS BUT CUSTOMISING BY ENTERING HIS UNIQUE ID CODE SO U DONT HAVE TO REMEMBER ANYTHING ELSE. BUT THE PROBLEM IS THAT 'M TRYING TO UNDERSTAND HOW CAN I GIVE A UNIQUE ID NUMBER TO EACH CUSTOMER ENTRY AND THEN HAVE SOME LINE IN WHICH U ENTER THE CUSTOMER ID IN EACH LINE AND U GET THE DETAILS AUTOMATICALLY? LIKE EXCEL I…

I am using the import records script step, but when i try and define import order it says I dont have enough access priveledges. Im logged onto the file im editing with the admin (full access) account and this information is identical to the login for the admin account on the file from which i want to import. How do I get around this?

Is therre a way to perform multiple finds in a script? I have a file that contains 7 date fields per record. These fields show the date of each of the 7 events that occur for each record. I need to report the count of each event on a monthly basis (how many of #1 this month...how many of #7 this month?) I know I can do 7 combined finds manually, but I can't seem to figure how to script this. Any help will be greatly appreciated

I have no Idea where this post belongs but I'm going to put it here. Feel free to move it if it should be somewhere else... I have a container (picture) field and I want to have some text show in the field if no picture is present. How do I do this? I was looking in the help section and came across the IsEmpty function. I've tried using it but I can't get it to work for me. Can someone help me out?

I am running a script to import a found set from one file to another. The files have identical fields and structure. however when i run the script i encounter a problem with importing fields with repeating values. the first occurrence imports fine, however subsequent values fail to import. i made sure that they are not creating new values for the repetitions.. any ideas as to why this import is failing :? p.s. this exact script worked perfectly in v. 6 im currently running v. 7.3

Hi, I cant seem to export a .tab file with the field titles at the top (only the actual entries). Is this possible? I want to export to a text file that address book can import with minimal user input. thanks

i am working on a lineage (pedigree) type of database. what i would like to happen is that when i click on a field (showing dog's name), it would bring me to the records of that particular dog. for example, a record contains dogA, dogB is dogA's sire, dogC is the dam. if i click on dogB, it would bring me to dogB's main record showing dogB's sire and dam and so on. i thought all i needed to do was to get to find mode and get related records but i could not get any script to work. i probably need a sample script for this. thanks for any help in advance.

Hello, I have two separated files in FMP 7. In the first one, called "results", a set of 20 records are created, with two basic text fields sample_nr and result. The results are empty, and the sample nrs are identical. In the second one, called "encoding", one record is created with the sample nr and 20 fields. These 20 fields collect or calculated a maximum of 20 results. When it is done, a script updates each result in each record of the first field. It works well. My problem is when less than 20 results are generated : the result field of some records in the first file remains logically empty, and I have to suppress them. To do so, I start a script in t…

Forgive a newbie asking a dumb question to which I cannot find a posted answer. Is there anyway to script field behavior. I want, for example, to be able to automatically lock (prevent data entry in Browse mode) certain fields once a certain date has passed. Another related problem....is there a way to script the field color? I know how to script text color, but not the field background itself. Thanks for any help!

hi, I have a dbase with a table of users. Each user has an email address. How do I write a script to create a comma-separated list of just the email addresses of all of the users in the current found set? Ideally this should pop-up in a new window where the user could then just copy and paste it into whatever email application they needed. Seems like this should be really easy, but it's been awhile since i've touched filemaker and it's been a long week...

Is there any kind of alternative script editor that allows a little more flexibility in editing long and complicated scripts? For instance, I have big chunks of code that I would like to be able to simply cut out and paste into another script, or at least be able to rearrange within the current script. Coming from a background of free text code writing, having the steps available on the side is nice, but the contraints are extremely irritating.

Hi, i'd like to do a script that would import data from several records to several others (visible through a portal. Ok, i have a lot of bibliographical references through a DB with a lot of of related tables. To simplify everything, I want to do a "bibliography" layout. I was thinking of adding something like a button with a script that would import all the data from all of the records. This bibliography layout would be associated with another table (say "Biblio_ref") with one record for one references. That would let me see all the references at the same time through a portal in "Bibliography". I would like to know how i could do this. I'm not sure if it's cle…

Thanx LaRetta for the help with my first post... On to the next: How do I get the list view to sort one category by itself? For example: I sort things by Last Name then by Department. Now, all my records are sorted alphabetically. By Last Name then by Department. How do I get it to sort STRICTLY by Department? If I hit Last Name a few times, it will sort STRICTLY by Last Name. Why not the other way around? Am I making any sense?

I'm just started working with FM two days ago... I started with a template and changed it up for my needs. After looking and looking thru the help menus, I finally figured out how to work with scripts. Or so I thought... Below is a link to my file. Can someone please take a look at it and tell me what I'm doing wrong? My problem is this: I copied the sort script that the "Last Name" field is using, in the List layout view, and used it for the "Department" field. I made the nessessary changes to the script but it's still not working. Can someone tell me what I need to change. I must be missing something but I'll be darned if I can find it.Please be…

FMPV7 - I am developing a time card layout. The user needs to enter up to 21 days worth of date, time-in, time-out etc. I would like to be able to have the user enter the first date and then on the next line when they click on the date field have the script enter the Next Days Date automatically. I could use some help in developing the script steps or the calculation. Thanks Bob...

Hello everyone, I have a table that contains many records and a separate find layout that displays a limited number of those records based on if a field has been set. The find layout is in a popup window. Both layouts are from the same table. What I'd like to happen is when the user clicks on a record in the find popup window, the find window closes and the main window goes to a certain layout and pulls up the record that was clicked on. Basically, it's a "Go to Layout" but in a different window. . . I've tried setting up a temp field to store the record number, close the find popup, go the the correct layout in the main window and do a "Go to Record" and …

I need to sort a table's records, and number them based on the sort. But the user needs to be able to arbitrarily change the sort as well. I have a field for the sorting before a user changes things, called calc.Sort, and a field for the sort numbers called actual.Sort. When records are added to this list, they are not given an actual.Sort number. So, if I have a record set like: RecordNumber actual calc 1 def 2 1 abc 3 2 ghi I want my function to change it to this: RecordNumber actual calc 1 1 abc 2 2 def 3 3 ghi I've got a good script, …

Hi, I am very new to using FileMaker Pro 7 (or any version) so please forgive me if I'm asking a basic task. I have been working to get a button (made and ready) to have a script that will duplicate and then move the record and place it in a new database. Essentially, I have many records (750+) that need to be organized according to whether or not they are a chemical. I need 1 database that has a list of all the chemicals with no other types of supplies. Right now, there is no indication as to what the record is. I'm hoping that the button will identify them as a chemical and then place them into a new chemical database. What kind of scripts should I use? It loo…

Hi all I am trying to create a script that will find records that show "confirmed" on any of the services we provide and then omit records that are past todays current date. From there it will go to another layout and list all up and coming "confirmed" events. I am having trouble omitting records that are past due. Right now in my script I select to omit multiple records and then specify a calculation where I thought it would just be this "${1-4-2005NEW}:Event date &#8804; ${1-4-2005NEW}::todays date" Thats not working. Any help would be great!

Hi, I am trying to create a folder in windows based on a field name. I have a unique ID number for every record, and I am trying to create a folder that is named the ID number. I have my script set up, but everytime filemaker opens a MS-DOS CMD window, the rest of my script doesn't get typed out to create the folder. Here is my script: Enter Browse Mode [] Set Field [patientlist::Global; "cmd c/ md c:testfolder" Set Event["aevt";"odoc";Patientlist::Global The MS-DOS window opens, but the "md c:testfolder" never appears in the ms-dos window. If I manually type it into the ms-dos window, it works fine. Ultimately, I would like to replace the testfo…

I have a script that deletes several found sets of records and then imports data from an external file. I need end users to run that script just once at the beginning of each calendar year. If it's run at anytime again after that it will delete relevant current data. Is there any way to internally restrict or disable a script after it's been run once? Thanks for any help or suggestions!

I have another question regarding something similar. I have the following field names. ItemNumber Period1 Period2 Period3 Period4 1 CBM001-1B05 25 40 12 120 2 CBM001-2B05 20 10 40 12 3 CBM001-1T05 56 14 46 145 4 CBM001-2T05 23 15 78 34 5 MBM010-1B05 12 67 356 366 6 MBM010-2B05 14 266 256 134 I have about 3000 records similar like this one. Of course with different item numbers. What Im trying to do is the following: i want to add the qty for matching item numbers. The thing is that some item numbers have the same first 6 numbers, what difference them from all others is the last 4 #'s. For example i would want record 1 and 2 to be add together and turn …

Hi, I have a database that has a list of names in it, let's say the field is called NAME. I want to export each persons information into a seperate file using their name in the filename, for instance if NAME="Jane Doe" I want the filename to be Record.Jane Doe.csv. Is this possible? I'm somewhat new to filemaker and am stil getting used to the scripting features.

Strange thing going on. My DB window starts up maximized. When I write a script to pop-up a new window (and define it to any size other than maximized) BOTH the orginal window and the new window resize when invoked? The user closes the popup window when done with it and the original window stays small. Any idea why this is happening? Seems like a bug or glitch in FM Pro 7? If I never spawn a new window I am fine but takes away from the beauty of the DB. Also, this did not happen for the first week of programming. It started for no apparent reason shortly thereafter and remains. No new scripts were added to the mix that might have caused this. Any ide…

I have a script that goes from Layout A to Layout B and pauses to allow data entry from the user. On Layout B I have a number of buttons that allow the user to "auto-fill" specific fields together with a button that takes the user back to Layout A. e.g. Button 1: Scripted Routine 1 Button 2: Scripted Routine 2 Button 3: Return to Layout A If the user selects Button 3: "Return to Layout A" during my scripted routines for Button 1 or Button 2, how can I disallow this action so that the user must finish the scripted routines?

I am trying to figure out why this script is not working correctly. I have a field called SendTo. That is a dropdown menu and validated from another database file. I have a script that will send email using AppleScript. Everything works great except when I add the if statment. I am trying to tell the FM script to full different field data based on the value of the SendTo field. It works when I only have two options. ex: If SendTo = TEAM perform AppleScript ABC else perform AppleScript ABD End if Now when I add the other if, I does not work right. If SendTo = "TEAM" perform AppleScript ABC if SendTo = "BOB" perform AppleScript ABE else …

I'd like to have a script that says "File Attached" or "Issued", etc. in red text when certain fields are occupied and not show any text when there is nothing in there. So basically if a container has a file in it you would see text that says "File Attached" but if no file is in it, there would be no text. Or if a field has data in it there will be text, no data no text. Has anyone had any experience in doing this type of script? THANK YOU in advance to anyone who responds!!!

I am a FM newbie and have manage to create a membership database which I am now trying to tweak but am lost as to how to do. I created a Record ID file using the serial number function - how do I automatically renumber the existing records when I delete a record? Is it possible to be auto notified prior to my members needing to renew their membership? Help would be greatly appreciated but please remember I'm new at this and may not know the correct FM terminology.