Script Workspace and Script Triggers

I have a simple script that creates a found set. The last step brings users back to browse mode, but also seems to show all records. I would like to be in browse mode with only the found set. Thanks for your help. Jason

For some reason buttons formatted as Record Up and Record Down are no longer changing to next or previous record? Deleted them and recreated them but still no joy. All other buttons function... Any thoughts

Hi All. I not an expert in filemaker, yet not a beginner also but I have a quesiton for anyone who might be willing to answer. I have a martketing database in which I generate reports based on the different types of criteria involved, such as total amount spent, top ranking products, so forth. Once this report is generated I see the page with the customer info relating to the criteria I just defined in the report. Is there a way to get a script to launch a google map of the customer address based on the search criteria of the report?? Alex

I am trying to modify an existing filemaker dbase written by someone else. I have no great programming skills (understatement). A key field has six choices relating to a hospital site (say) A or B and area of work (say) X or Y or Z. ( choices AX, AY, AZ, BX, BY, BZ ) This is the first field of data entry, is there any way that as this choice is made the Data Entry screen can change to a layout that contains site specific fields and is clearly identifying the Hospital site the record is dealing with? I am trying for 2 layouts with a common core, of fields on the left side and the right column of fields having a few significantly different fields. Is this fe…

My interface for searching for invoices includes the usual stuff - date of order, Invoice_ID, subtotal, shipping cost, tax - as well as fields for name, address, city, state, zip. An invoice actually contains two name&address sections: Bill To, and Ship To. I want my Find tool to bring up records in which the name & address criteria matches either the Bill To or the Ship To section. I've got something like this: Enter Find Mode [] Pause Script [indefinitely] allow user input (A: save the find criteria that was entered) Constrain Found Set [] find recs using BillTo address fields Enter Find Mode [] (B: restore the find criteria from abo…

Can some one tell me what additional script steps are necessary to make this FMP6.6 script work when the files are converted to fmp8? My operating systems is Windows XP. I have two files. File A and File B. In File A I have a portal that allows me to view and create File B records. The script steps are: In File A. Copy [select, “student ID”] Perform Script [subscripts, external, “File B”] This step performs the following script in File B New Record/Request Paste [select, “Student ID”] Open [File A] The final step in this script returns me to File A where I see a new blank record in the portal. When these files are converted to FM…

I have 2 fields: Revision Date Revision Number I want to display the last record of Revision Date and Revision Number as part of a header for a report. I'm tried to create a calculation field, but I am not good with scripting in FMP. Also, I have tried to sort the data, but this doesn't seem to work at all in a header. Any help would be greatly appreciated. Thank you very much in advance!

Ok when upgrading a client from any version of our system we have a script that goes to each individual layout and shows all records so that every table, racord accross the database is found. Different clients obviously may have different layouts so its extremely slow to build this script as I have to ensure every table, layout etc is covered in this script. If there a way of building a script that does something like this... Show all records on all layouts? or automatically goes through each individual layout and shows all?

i have hard time understanding the logic behind BT(Filemaker Business Tracker). this thing is an open challenge, i think that is the reason why they left the source open , i bet you they are laughing at all the questions that pour in the forums about how this jewel with its elegant look and monsterous design could be put together in one single file. all i have been trying to do is to be able to understand the nav. i know it has to do with previleges, access, ...so forth ... but i wish if someone can help explainig the meaning of the calc: Case ( ( PatternCount ( "¶" & Get ( ExtendedPrivileges ) & "¶" ; "¶" & Module::Label & "¶" ) ) ; Module::ID ) …

Hi I want to create a button and to count every time that button pressed. The purpose is to figure out the total number of a particular number of items I have encountered on a particular day. I intend to have a record a day and to be counting about 20 – 30 variables that I need to total at the end of the day With this total I would like to perform some simple math’s functions. I would appreciate somebody’s help :)

I need to be able to generate serial numbers in new records. I am aware of the auto-enter serial number features however for this database I would like to use a script to generate a serial number. Does anyone out there have any script suggestions? Thanks for your help in advance. I am putting the finishing touches on this database and I wanted to add a little more flexibility to the serail number piece of the database.

I have this script that I built in FM Dev 6. This script is put on a calculation field that is a container. Case( PatternCount( SortField, "LastName¶" ), GetRepetition( SortPicture, If( MiddleWords( SortDirection, PatternCount( Left( SortField, Position( SortField, "LastName", 1, 1 ) ), "¶" ) + 1, 1 ) = "Ascending", 1, 2 ) ) ) Basically what I need is, If SortField = LastName then If the SortDirection = "Ascending" then put in the 2nd picture from the SortPicture container. If the SortDirection = "Descending" then put in the 1st picture from the SortPicture container. The default picture has to be the 3rd picture from the SortPicture con…

Ok guys, here it goes: I'm having a problem getting my database to detect if there is text in one field, and if there is, to jump to the next. What I have created is a transactions database for school lunches - as my dad is an IT teacher at a new school, however he knows nothing about FM. At the top of the screen there are buttons for the designated lunch item (i.e. "Hot Lunch" "Cold Lunch" "Fries" "Salad" etc..) When the button is clicked, the text (Hot Lunch, for example) is entered into a field, and the price is entered next to it (see screen shot.) However, when this database is going to be used, the staff member can't be typing in prices. He/she should ju…

Does anyone know how to recode? For example, I have a database of approximately 500 patients, and I have imported info. from a doctor, written as "1" "2" and "3". These numbers need to be translated into English. How do I change: 1 to YES 2 to NO 3 to MISSING Any help would be greatly appreciated. Thank you, Alisun

I am attempting to "not use tabs" for the data entry layouts and just use "fake tabs" (from the majority of advice on another topic). I am having trouble, though, with the buttons for the fake tabs. My layout is for one person and has the First & Last name on top and then come the fake tabs/buttons. The first button is Personal, 2nd is Position Info, 3rd is Appointment and so on.... each fake tab will be another layout. (attached are screen shots to further clarify) But when I am on John Smith and on the Personal tab, when I click the 2nd tab- Position Info, it moves to another name- like Jane Doe. What would a script look like for the buttons so …

Periodically I perform a find and get an error message that says: "no records match this set of find requests". [color:red]Is there a way to script an automatic selection of the CONTINUE button when this condition occurs? Thanks, Jarvis

I would like to select and delete a record from the middle of a portal and then renumber the remaining portal records #'s sequentially, from 1-12. Do I need to use a loop script and end when the script reaches the bottom (end) of the portal? Thanks, Jason

I'm trying to develop the following script that deletes records from a portal (based on a self relationship) and stays in the same layout until the final record in the portal is reached, and then deletes that record and goes to a different layout. I can't get this to work: If [Get(PortalRowNumber) = 1] Delete Record/Request[] Go to Layout ["Navigate" (QuestionBank)] Halt script End If Delete Record/Request [] Thanks!

I've been programming FMP for 10 years but I never used the "exit script" until recently. My solution had to permit a script to pause but still allow the script to be invoked again from the same button as I am validating the content of the field and the fields on the layout. In order to stop unnecessary recursions of the script I tried an "exit script" if I already had a record of the script running (held in a global). The peculiar behaviour was that if the script had, at any point, been exited then the script that was paused would also terminate as soon as it was resumed, thereby failing to perform the validations. I expected FMP to handle the scripts almo…

I am trying to create a script to go to a specific field depending on the script parameter assigned to a button. But the go to field (or set field) steps do not give me a calculation possibility to choose the parameter. Any suggestion?

I'm considering a setup where I have one "robot" user who is logged in 24/7 in a looping script that does tasks such as sending emails for IWP data that's received. I'd like to be able to track whether this robot user is in fact connected, so I don't forget to re-connect them after doing a database upgrade. I'd like my administrator account to notice that the robot account is not hooked up and notify me. There doesn't seem to be a "getConnectedUsers" function, though. Any other thoughts? Since the robot user will be in a loop, perhaps I could have it keep setting a one-record-table-field to the current timestamp. Then I could have my admin's user navig…

Is there a function or some other technique to allow a script to detect whether there have been any modifications made to the data on a layout, before that data is committed? I don't need to know what field(s) were changed, or how many changes there were. Just a boolean. I have a basic Invoice/LineItems layout and I would like to alert the user ("Changes made - discard or save?") if he attempts to navigate elsewhere after modifying the invoice. Obviously I don't want to put up the alert when he hasn't made any changes. Thanks, Chap

Hi! I have a layout for performing finds that looks identical to the entry layout except no pull-downs and no functional buttons. My Find script takes users to the find layout, enters Find and pauses. User enters criteria, resumes script with a button and user is returned to entry layout. If no found set, I have a mssg and user goes back to entry layout. However, the native FM mssg for no found set allows a "Cancel" which leaves users on a mostly non-functional layout. How do I bypass the native FM mssg? Or get rid of the "Cancel"? Modify find and Continue are okay.

HI, I am trying to populate a global field with the values from a Value List. I can not find the function (or script step) that does this. Any suggestions?

This may or may not be the right way to do it so I am open to any suggestions: I have 10 markets with store locations in each market. I have different number of storesfor each market. I need to rank the zip codes within each market and would like to automate the process. The main problem is having the script recognize when the next market begins. Any help would be appreciated.

Here is one for you guys... So, I want to use the new PDF functionality in FileMaker to show my users a preview of a report. I want to do this using PDF instead of FileMaker's preview mode because the PDF is closer to, if not fully, WYSIWYG compared to FileMaker's preview mode. And yes, I am going to use PDFs to print this report as well. This works great. Using the Save Records As PDF step in a script I can create the PDF and automatically open it. If I just want to print it, the Send Event step can be used to print it without any interaction by the user. Also with the Save Records As PDF step, I can specify a password for the PDF. This is ano…

Hi, I've run into a snag, I want to run a script to sort & print reports at a certain time every monday morning, but am not sure how to approach this. I need it to work if the database is idle, so I can't base the script off modification time and dates.....

Greetings, I'm building my first FileMaker database. I'm following the instructions in the Filemaker Bible. I'm on "Defining the Go to Layout Buttons" (pg. 108 if you have the same book as me). When I click on the button tool and try to drag a button onto my database _nothing_ happens, so I can not set up any buttons. Has anyone run into this? Can you explain how to get this feature working? Is ther another way to get buttons to appear? Many thanks for any advise. Bridget

Is there a way to get this script to loop through all the rows in the Portal and commit them, or run this script on all rows in the portal. See attached Preview_of____Define_Scripts_for____CFP_Data_rev4-26-06-1______.pdf

A field "TitleField" contains the title of an article. The text of the article is contained in another field (ArticleField). I would like to create a value list that lists every title in the "TitleField" so that when the user clicks on a 3rd field the "ValueListField" and selects one of the titles, a script whould then take him to the record containing the text of the article associated with that title. Each title is unique. Any ideas? Thanks

While trying to write a script for a button I am hitting a snag. I am wanting to have a dialogue appear which asks the user if they are sure they want to start a new record and then give them the option of either cancelling the script or proceeding. I can get the dialogue box, but when I add the "cancel" button onto the dialogue box, it continues on to create a new record. When they click cancel I want the cancel button on the dialogue box to cancel the whole script. If they click "Okay" I want the script to continue and start a new record.

On part of my database I am tracking the licensing status of items submitted to our licensor. In one field I want to pull the status from a pull down menu. Once that is selected (this is where I need help)I want another field to show the abbreviate term. I.E. First field will say Item Approved, second field will say I/A. I want it to automatically insert the abbreviated field when I select the corresponding status. I know how to do this with a script, but only if there is a button pushed. Is there a way to do it automatically as soon as the field info changes, the second field will change. Also, I want to select a color for the status. I want it to be r…

I'm in the middle of building a database for a school. I've run into a minor problem with assignments. The way I set it up, I have two tables for assignments. 1. Assignments (Contains information on the assignment with an AssignID) 2. AssignmentResults (Contains the score for every student on that particular assignment) I have a script that goes to the related records of the enrolled students. Then in a new window, I open a utility layout for AssignmentResults. I used a loop to go back and forth between the windows copying and pasting the EnrollID into the AssignmentResults table. This was working fine. Now, it still works, but it seems really slow. It t…

Does anyone have the calculation of how to calculate someone's age using their date of birth?

Is there a way to have a script call/run an HTML page? Specifically, I need a menu item to run an external program (a browser) and bring up a URL.

I have a database which holds the name of organisations (field: ORG) together with the type of organisation (field: TYPE). The TYPE filed is populated using a checkbox field created from a predefined VALUE LIST. I want export lists from the database of organisations that match each of the VALUE LIST values. I can do this manually by finding all ORGS that match first value, sorting, exporting, etc. However, there are over 30 values in the VALUE LIST which proves incredibly labourious. Also the VALUE LIST grows as new types of orgs are added. Is there any way to automate this in scriptmaker? Any pointers would be useful. Many thanks

I have a layout with header, body and footer. In the header is a "Today" date field that shows the correct date (4/24/06) in Browse mode but an earlier date (4/19/06) in Preview mode. Anybody know why, and how I can correct it? Thanks.

I'm trying to write a script that will enter in a date and/or time field, when each record was last printed. I have a very large database that will take several days to print each record (on an ID machine) and I need to be able to "mark" the ones that were printed and come back to print the ones that were not. Any ideas?

In FM 8, the new feature "generate PDF" has the option to attach to e-mail post generation. My question is whether the e-mail address to which the attachment is being sent can be specified. If not, i'll just use a work around where I save it to a static location, generate an e-mail and set that static location to be the attachment using the traditional Send-Mail script step. Cheers, ~Genx

Is there anyway to check if there is a valid internet connection at time of script execution through script maker, and if not maybe through send event somehow? Cheers, ~Genx

I have been having problems with scripts that use the Import step: certain settings are being forgotten. There are two scripts: Load, and Restore. Load will import a flat, tab-separated file into an FM table "FlatOrders". Restore will Import the data from an FM file "OrderDB.fp7" that was "Saved as Copy" earlier. In both cases I want to be prompted for the location of the source file, but otherwise it should use the same Import Order and other options as before. I eventually found that I had to put each script through one "dry run" with the Source Data file pre-specified, in order for all of the settings to stick. After the dry run, I re-edit the Im…

I'm a newbie having a little problem with Filemaker and Outlook 2003. I've written a script that emails a report to a particular individual using my default email which is Outlook. The script works great however when Outlook is opened, I get the following message from Outlook. "A progam is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose “No”" (Yes) (No) (Help) I can answer yes and the email is sent. But it's a pain in the rump to do it each time. Does anyone know how to disable this message from within Outlook. I've checked within the program and also at the …

my old records were entered in the format of: dd-mm-yyyy for the Date, if i would like to change those records to the format of MM-dd-yyyy. what is the best way without messing up my records.

I am moving along in developing the Zip Code database described in #198987 in response to my initial request for help in #198974. (Thanks to all for ideas!) I would like to speed up Zip Code entry by using the Enter key to perform a script (creating a new record for the same Event ID, for example, so that the next Zip Code can be entered). I cannot find in any of my FMP books how to use the Enter key to perform a script. Can anyone educate me on this? If I can't use the Enter Key, then can I assign some other key to this, such as Tab or a letter key, F1, F2, etc.? Many thanks -- (Apologies for multiple submissions -- I thought I was experiencing a freeze of…

i have a situation where i have a found set of records then i have to make a number of related records for each of the origional found ones. i have a loop that works...but as i am getting more indepth with what i'm doing the loop is becoming more difficult to work with. i would have done it differently but can not think of one please help

Hi, I am using the GTRR to try and emulate a SQL Search. As long as I check of some data for each field it works perfect, but if I leave a related field blank it comes back with nothing. How can I use GTRR but let my clients leave one or more fields blank and still come back with the right results? For example, in SQL you might use WHERE City = "New York". Then if you leave off the WHERE City = "New York" you would get all the cities. In GTRR you can check off New York as one of the cities, but if you leave it blank it assumes it should have no cities instead of all cities so no records are found because they all have a city. Any help would be v…

Here's the problem. For some reason we want to to take a file, call it theOriginalFile.fp7, and first make a compacted copy of theOriginalFile.fp7 and call it theCopiedFile.fp7. Next we want to take that file (theCopiedFile.fp7)and make a clone of it. So I have automated the first portion. Takes theOriginalFile.fp7 and makes a compacted file, but I can't seem to "select/go to" the new file and continue with scripting. In the Save as script step one can open the file after saving, but i dont seem to be able to continue. Note: This is all part of the scripting steps, i'm not trying to manually copy and clone each file, I know how to do that. I will e…

OK, I am a brand new newby to FM. I have used SQL, PHP, Access, ASP etc... so not knew to programming just Filemaker. I have inherited a database in my new job and the DB looks rather complex. Part of the database allows users to log in and go straight to a page that sums their current activity and future activity. IE 5-45 Day Cases Due 10-6 Month Cases Here is the issue, I have a user who when they log in from THEIR machine their sums are all 0 IE 0-45 Day Cases Due 0-10 Month Cases Due But when I log on as admin or with higher permissions I get the correct numbers. Oddly enough if I copy the database from the server and login as anyone I get al…

I'm creating a database to hold our orchestra's library information including information regarding timings and performances. Each record is a different piece. For the timings, I have a total time, title, sub-time, and section field. Since each piece may have multiple sections, I'd like the subTime and section fields to be repeating. The totalTime will be the sum of all subTimes. I can do all this. What I would like, is to be able to press a button that would add an extra subTime and section cell below the current one. I'm not sure is ScriptMaker can do this, but applescript is ok with me too. Regarding the performances, I would like to keep track of the pe…

I'm rebuilding a corrupt database. I've checked all the layouts on the corrupted files and they all appear fine, so have copied and pasted into a new file. I've rebuilt the tables from scratch. All was going well until I imported the scripts from the previous file. When working through them to check they were functioning correctly, I came across one that contained a GTRR script step. The layout it points to does not exist in this new file. Bringing up the dialogue box for this step allows me to select the layout I want it to go to, but when I hit ok it appears in the script as this 'phantom' layout. I'm very concerned that I have brought over corruption into th…

This should be simple but I am not sure which direction to take. [color:green]Alittle background - Working attorneys work on matters that are orginated from another attorney and matters that they are the originator; working attorney = WA, orginating attorney = OA I need to omit a few sets of criteria from a find set. I first search for the working attorney(WA) and for the pay period[color:green](this is user specified) I then omit records that have already been paid Then omit records that have not been entered for posting([color:green]this is all done by the script) - This all works fine. What I need is to then [color:red]omit records where the work…

I want to have a window pop up and be locked until the user clicks a "close button". I can create a script that allows user abort (off), opens the window and pauses indefinitely until the user clicks resume script, then I have it close the window. This works fine if the user just does data entry and hits a button that resumes script/closes window. However, there are times when I want the user to execute a script on that layout will the initial script is being paused. I tried incorporating the sub-script into the original window opening script but there is no good way to get this to work. The problem I am having is that the "resume" script step doesn't allow you to pas…

Hallo everybody, I want to create a script which will chage alignment of selected text in field. Not in whole field, just selected text (paragaph in which is a cursor). Usualy Title of text is cenetered, text is letf aligned, ec... I dont want to end user use "Format" menu and toolbar "Text formatting", because I have created Menu for end user. Any opinion will be helpfull. TIA

If i have a radio button field, is there a way to submenu one of the choices with radio button options and still be related to the same field. lets say the value list of a field called invasion is: No evidence of tumor intramucosal into muscular layer lets say i would like to sub menu the last one to one option of two using radio button also 0.5 cm or less 0.5 cm or more so the outcome would be: into muscular layer 0.5 cm or less.

How can I show more than one layout at a time? Can I make one window show them all? Or is there a script or something to be able to search for something within a certain recordset? For example: I have a layout (tours) and I would like to be able to lookup information on another set of records (like a list of destination ids). Is there a way to make a button that will open a search window and specify which records to search? Any thoughts would be appreciated. Amanda Y

I have an invoice layout that shows all invoices with a GTRR button to show related records (LineItems) in a new window. Invoice window and Line Items window are tiled. My problem is: each time I click on the GTRR a new LineItem window is created. After a while I find myseld with a dozen LI windows open. How can I keep FM from opening a new window every time I click on the gtrr button and get it to use the LI windows that is already open to show related records. Thanks for any suggestion.

I am trying to make a scheduler. I am scheduling equipment. Each job is set to run on a specific piece of equipment. I want to ask the operator what equipment(from a list if possible) and for what day. So I am using the Show Custom Dialog. It works, but can i get it to show a drop down menu based on a list I have created? Can I use the results in a find script?

I need help creating a simple date range search script. I want to do the following: 1. Click button to begin search. 2. Enter layout with Calendar to select start date. 3. Click "next" button to continue. 4. Enter layout with Calendar to select end date. 5. Click "next" button to continue with search. 6. Go to layout X and print. Thanks in advance. I know this isn't that hard, but I'm a little overwhelmed with figuring all this out since I haven't used Filemaker since the mid 90's. Alden

Hi, I am working on a medical database for a friend and the person who uses it travels to various locations to examine patients. What they want is to be able to generate a report which shows (for example) the number of patients seen, number which are female, number with a specific disease,etc for each location. The way they currently do it is to manually input numbers into Excel, but we'd like to automate this. They have it setup so that locations are displayed down the vertical axis and the various points of interest across the horizontal. Can this be similarly replicated in Filemaker? Do I need to provide more information before you can help? The other…

Technically, because this is setable in script maker, it is a valid topic. Anywho, my question is this. When you have a blank menu set (or any menu set it seems) the tools menu is always there. Anyway to get rid of it? Cheers, ~Genx

Are variables interchangeable between files or are they restricted to the file that initiates them? Cheers, ~Genx

I'm new to scripting in FMP and I'm having a hard time figuring this out. I'm working on a database to track meeting attendees - each attendee has a record in the main database with a unique ID number and a Yes/No field to track whether they attended. What I am trying to do is construct a related database (related to main db by ID number) where I can dump the ID numbers from the people who have shown up and have a script match up the ID numbers with the main database and change the value in a Yes/No Attended field in the main database. Has anyone seen an example of something like this out there on the web or can anyone offer any suggestions on how to go about …

i made a calculation for a field and the output is text, when i try to search, it does not see the files prior to the modification of the calculation only the new records after modification,any remedy? the attached zip file has the field Mont_year calculation, and it generates 06 (for the year) 00 for the month and 3 digits for the records newly entered. any modification to the calculation it gets blind to the prior records when searching. hello.zip

If you are making changes in a both a parent record, and a related record using Set Field scripts, is there a way to selectively Commit the changes for only one or the other?

I'm not sure if this is the best place to log, but . . . I'm sure this should be easy, but I cannot figure this out. I have limited understanding of tables and so have created two different DB's. 1. Jobs (each job/record has a unique Job number [example - 06-0054]) 2. Expenses (some, but not all, expenses are related to jobs) For expenses that are related to specific jobs the corresponding job number is entered [06-0054] (but not linked to Jobs DB). What I want to accomplish: Users may enter job records and wish to see related expenses. I would like to write a script so that: job number of current record is copied Expenses DB is opened an…

I can't for the life of me figure out how to do this: I have a field (Tests Requested) that contains carriage-return separated values based on a checkbox set. I figured out how to search for a specific value and set a second field (Order Total) based on the price assigned to that value in a related table. The problem is, I can't figure out how to do it more than once in a calculation. I get an error when I try to put more than one if statement in a calculation. I tried using "&" to string if statements together, but then I get a value 10X the expected value, and if I check more than one checkbox, it multiples 10X again! How do you string together if statements? O…

I'm moving from FM Pro 7 under MacOS to FM Pro 7 under XP (well, I will also use FMPro 8 under XP) How do I get the Speak Script Step to work? Yes, I know that the script step < Speak ("phrase") > does not exist under the Windows XP versions of Filemaker. But is there any way to make a script make a voice announcement under Filemaker / Windows XP? Thanks! -Cliff

Hi guys, I don't know if this is a layout question or a security question but here goes. I have scripts that generate reports. these reports are not always printed but viewed in preview mode in the DB. (Not my idea). The question is when they are in preview mode the continue/cancel button is in the status area. I prefer to hide the status area from my users because I don't trust them. If they are inpreview mode and hit continue the script takes them back where they were, but if they hit cancel for whatever reason, they are stuck. The only answer I have had for this is to only have the home layout visible in the layout menu. I can't put a button on the layout bec…

I have a database that generates several lists using buttons with scripts. Each list is a location, and the fields provide details about the items in that location. Some fields are the same in each list and some are different. What I need to do is have the users go to each list, and be able to individually select some of the records on that list as "to be shipped" and have those records move to another list layout. This "Items to be Shipped" list would then be a compilation of records that were selected by the user from the various location lists. (I assume this layout would contain only fields that were common to all the location lists). I would appreciate…

Have a script attached to a button that deletes all found records in a table conatining rss news headers and descriptions and then runs an rss feed update to import to the table again. Is there a script that will check for an internet connection before deleting the records? (So if it fails i can run a custom dialog "Internet connection needed to update rss" and the existing items wont get deleted)

Hi, Now, I think I know how to use the set field instead of a copy/paste, but I would like to know if that will work in a server file, where there can be 2 simultaneously entries – 2 users running the same script at the same time, which is perfectly possible (and in which there will be different data trying to enter the same global field). For better viewing, the script runs like this: Set field [“Temp g”, “field A”] Enter find mode [] Set field [“field A”, “Temp g”] Perform find [] View as [view as list] Thanks in advance for some tips. Teresa

I have a text field in a database with 1200 records containing 3 lines of text: First Name Last Name Street City, State, Zip I need to extract just the Street name which has variable number of words of different lengths. What text function or script would be best to use? Thanks

I have 2 tables, 1 is for employees, 1 for Jobs. On monday I email each employee a report.pdf of the jobs they completed in the previous week. As the script stands now, it works great, I press a button, it enters find mode, i enter the employees name, it fills in some other criteria, performs the find, creates the report, saves the report as a pdf and email it using smtpit. What I would like is for this to be automated. Meaning, a looping script that would go through each of the employees names without me needing to input them individually. So my question is what would be the best way to accomplish this? To sum it up, each employee has a record in the employee…

I am a physician and i am indexing the cases in my emr manually to 06-MM-### so the last tripple digits will be starting from 0 every month. so the 5th patient in may of 2006 would be 06-05-005 and so forth. is there a script that i can use to automate the entry with that fashion so when the month revolves it will reset the last 3 digits to 000 and the month to 06. thx for any help i can get

I am trying to extract a mailing list from a list of contacts in a portal. I created a script that goes to the first row of the portal and then sends mail from the field email on the found set. It doesn't work correctly, do I have to loop a script going to each portal record to extract the email? Do I have to go to the related table, perform a find to find only the related records and extract the emails? or there is just a simpler way?

Hello-- Background: I am trying to develop a database for faculty contracts & attendance. The dept already has one that has hobbled along since FM4 and has a great deal of issues. The goal is the database I am in charge of developing will replace the current one and will be able to grow etc. Although I have database experience, I am new to Filemaker. (version is 8.02 and using both Mac & PC). I have several tables. People and Account are 2 of them. I have a relationship from People::acct to Accounts::c_Chartfield (this chartfield is a calculated field). I have data in the account- basically 5 parts that make up the 25 or so character account nu…

Perhaps somebody has the time to dig into the mayan calender and is able to create the code for translating the Gregorian calender into the 260 days Mayan Calender. Which is 10,000th of a day more exact than the standard calender we use today. Calculating the 12 months 365 days into 18 months of 20 days with 5 days in the 19th month (aka the 13 moon 28-day wavespell calendar 364+1). And to make it even more easy, not to forget the +1 day every year that needs to be added (Day out of Time). The Sacred Round of 260 days is composed of two smaller cycles: the numbers 1 through 13, coupled with 20 different day names. Each of the day names is represented by a god …

Is there a way, within one script, to have the Print Dialog box appear only once (so the user can choose which printer to print to), and yet to bounce back and forth between printing only the current record and printing all records being browsed? Given that I have to switch how many records to print, it appears to me that I can't do it without restoring print options, which negate's the user's original printer choice. Let me spell out the script: ...Bunch of script steps... GoToLayout (Table A) Print Setup [Restore, no dialog] Print [Restore] [color:orange](with dialog to allow user to choose printer - restore chooses "current record only") ...Bunch of …

Whenever I activate the standard script to dial a phone number (from the current record's PHONE number field), a window pops up stating INTERNET call and fails. Shouldn't the window pop up stating DIALING phone ?....please help.

Hi. I’m new here. I just started using FMP 8. I have a script to cancel changes made to a record. If the user just enters the record and makes no changes I want it to exit without any dialog. If the user makes changes I run Revert Changes but only after confirmation. So I’m comparing the entry time to the current record to the record modification timestamp. The problem I have is the modification timestamp appears to only update when the record is committed. And once the record is committed I can’t revert changes. Is there a different way to check if the record was modified that doesn’t require the record being committed, without having to look at each fie…

I have 3 files for a check in progam for our school. When a parent checks in their student I want to copy thier student number and paste it into a different file so that we can track when and how often students sign in late. I'm using Copy/Paste but most of the time it doesn't paste the student # into the reports file. Thanks for your help in advance.

I have a series of dbs running where I work. They are now to be put out to the big bad world as well. How do I hide specific buttons?

Hi all, I would like to place a button in my filemaker application, and the purpose of this button when clicked is to execute external functions such as opening file (not necessarily Filemaker application file) or saving file, how can this be done? Or can it be done at all? Thanks in advance. NotPro

Is there an equivalent to the onChange function that is available in Javascript. I'm working on making changes to an existing system and I would like to avoid making procedural changes for the existing users. I'm trying to perform a script if the value of a certain field gets changed. The basic example is a text field which contains the status of a task. When the value is changed by a user to 'Done' I want a script to kick off that will perform a number of steps (i.e. record the elapsed time, write some stats to another file, etc.) I've tried searching both the layout and scriptMaker forums for words like 'on change' but so far no results. Thanks,

I sometimes need to run scripts to update calcs, etc.., but don't want all the last modified stamps changed to "admin". Any way to do this? Thanks! :D

I am trying to create a script that will sort data for a specified period. I want to specfify a start date and end date and have the data sorted and ready for printing. Thanks

Can anyone help me fix this script. Not sure if I have the if else statements correct... See attached. Thank you Script.txt

I am currently building a database in FileMaker 6 and I have created a Layout with a repeating field. Is there a script that would allow me to restrict the information entered into the field? For example the field repeats 10 times allowing the user to enter data each time. I would like to lock the field after information has been entered. To be more specific once the user enters data into a field they can not change it and will have to go to the next field. Hopefully this paints a decent picture of what I am trying to do. Can anyone help me? Thanks, Kasei

I have not been doing FM for a while and some things won't come back : 1. I have a button and I want todays date inserted in field A and time inserted in field B I know it's done from the script, but how? 2. It is a customer database and I want to have a drop down menu or similar with the options, New, Ongoing and Finished. When I choose one option I want the background color to change color, or if that is not possible a color box or something. 3. As I import the customers from Excel and work them of, some of the Customers is already done and I have a field saying "Yes". If the field "Yes" contains Yes, I want the status automatically being "Finished…

Hi I saw post # 172831 (Copy Paste problems) and I would like someone to explain to me how can I replace the Copy/Paste solution for Set field[] - which I think is suggested. In my (very humble) opinion, this would only work if the paste data was specific data… I have a lot of scripts using the copy/paste solution, so if this isn’t the best way to do it, I would be grateful if someone could tell me what to use instead. Thanks in advance Teresa

Hi, I would like to have a script set a field with a value list item. The field has a value list attached and shown as a radio button list. It is a conditional value list, based on a relationship. When this script runs, I would like it to enter the first choice of whichever relationship is present. How can I do this? Thanks

I've stumbled over this statement of Steven Blackwells: From: http://www.nabble.com/Case-vs.-If-t1350857.html#a3623229 This made me think, one thing is the metaphors or abstractions we deal with when developing, another is what's going on under the hood - which might be very different either we're talking calcfield or we're talking scripting. But what if they're more indentical than we dare to think??? Blackwell states that the days of RPN are over, which should mean that calcfields consider each statement as they comes, in reading direction. We have on the scripting side been provided with a new "Else If" that makes a kind of Case('ish behavio…

Hi, I’ve searched the Forum and found a similar problem (post #198062). I’ve tried the suggested solution, bus it’s not working with me… My script runs like this: Set error capture [on] Enter find mode [] Set field [“mark”, ““open””] Modify last find Set field [“mark_dup”, ““dup””] Go to field [select/perform, “popupmenu field”] Halt script Perform find [restore] If [“Status(CourrentError) = 401”] Show message [“bla bla bla”] If [“Status(CourrentMessageChoice) = 1”] Show all records End If End If So, if the “perform find” results in “0”, I keep getting the message “No records match this request.” Can someone show me what’s wro…

Hi, I have a table called "sequence" with records of the sort [color:green]Patient - text [color:green]Time - number [color:green]Sample - text [color:green]SeqLength - number In Sequences, there are often several entries that share the same [color:green]Patient, [color:green]Sample and [color:green]Time values. I have a related table "Visits" that has a single record for every unique Patient/Time /Sample combination (ie a many-to-one from Sequences to Visits). In Visits, I would like to have a field [color:red]AveSeqLength that is the mean of all of the [color:green]SeqLength entries from matching records in Sequences. Does anyone have any idea of h…

In a script, how do I Scroll the Window to the LEFT? Not up or down, but left and right. My script opens up a layout and it's scrolled to where the scroll bar is sort of in the middle of the layout, making it hard to see what is on the left of my layout. I'd rather see the left and have the right unseen. Need the scroll bar to be all the way to the left. This is driving me nuts!!! Thanks!

Hello everybody, I have a script to send emails with attachments and so far it works fine. But when it fills a new mail in OSX Mail he places the attachment on the top of the body. Any idea how I canget the attachment on the bottom?

Hi guys, I'm having a problem with a search request. One of the fields I want to search for is formatted as a radio button field (with value list: nt1, nt2, nt3) so you can select only 1 value. In my search I want to use a global with the same value list BUT formatted as a checkbox field. My idea is that you can select for example nt1 and nt3 so you will get all the records with the values nt1 OR nt3. How can I achive this functionality? I was thinking about getting one selected value from the global (checkbox formatted) fiels at a time and use that in new searches with omit records afterwards. But how can I get the values from the global field? I…

I'm trying to create a script that creates an invoice for a company. I want a script that can will take the name of company record that i am in and search for it within the invoice section. I can't figure out how to perform a generic script search using the record that i am viewing. thanks,

I'm having trouble getting this command to work. What I want to do is use adobe reader to open up a pdf file, but I tried an example first to see if it works. I went to the filemaker website and tried "Sed DDE Execute[service Name: "iexplorer"; Topic: "WWW_OpenURL"; Commands: "www.filemaker.com"] This is the example they give that will open up IE and go to the filemaker website. I put this in a script, and tried running it and nothing happened. This is on a windows system...am I doing something wrong?

I have a database that I use to manage Projects for clients. I am able to set Status to Pending or Open or Closed. I want to create a script that checks to see what the status is. If status = closed then the current record should lock itself and not be modifiable. I want to be able to change the status back to open if need be but if the status is closed then the rest of the field in the current record are not modifiable. Basically I have no clue how to lock the current record at all and then base it on these conditions. Any help would be great. Thanks.