Script Workspace and Script Triggers

I know I have added this to another post in a diff. area but I think to get an answer I need to post an actual question here..... My script is bogging down and I'm not sure why. I'm using a loop and have cleaned it up a bit so that it's all in 1 script. (Previously I had a "Preform Script" step in my loop) table::list table::isbns table:response_calc table:response_text All are global...... as are the others needed... wondering if that's the problem ?? .......first part to get a list.... Set Field [table::list .....] Freeze Window (Doesn't seem to work for me...) Loop Set Field [table::isbns; If(Length(table::list)>127; Left(table…

I'm using FM 11 Advanced on a Win Vista based HP Laptop computer. When I press Ctrl+Shift+S to open the script manager, the HP System Information window opens instead (it displays info on the installed system). Is there any way to stop this? It does not happen when running FM 11 Adv on my desktop Vista computer.

Hi there, I'm DC, I haven't been working with Filemaker for more than a few weeks, but I think I've started to get the hang of various functions and such. I am, however having real trouble with one particular part of my database. This Database is for a Healthcare company, providing Carers for the Sick, Elderly and Disabled. It records details of both the carers, and the clients for whom they care. it is a little more complext but that's the general gist of things. My problem is this, I need the database to be able to show the user which of the carers are available for appointments on a day to day basis, and show them in some sort of overview. So this would rel…

I want to copy my script to post on here for some help. I know there's a way to do it ... plug-in or something ... but I can't find it. Help??

Just started useing FMP 11 and need some help with: #1 if field_A has any data entered: set the validation to (Not empty) for field_B, field_C, and field_D. #2 field_A fails validation: if field_B has any data entered. #3 If field_A has any data entered: use layout_1 - If field_A and field_B both have data entered: use layout_2 - If field_A and field_B and field_C all have data entered: use layout_3: than open the layout (1,2, or 3) in a new web browser window if web published. Thank you....

I have seen posts throughout the forums here related to the above topic but nothing that really fits my dilemma. I set up a very small database to track tests run on equipment by category. For the most part everything has gone smoothly. People can enter data concerning the equipment, the manufacturer and the category of the equipment (i.e. scanner, mouse, phone, etc.). My issues is that when a user sets the category for the equipment a script needs to run that will automatically insert a set number of test for each category. The tests and the categories are related to each other in a join table called TestCertCat. This table consists of two ID values: on…

We have some employees that work from 11pm to 7am. They put this information into an In and Out field. When Total Time is calculated it is negative. To get around this I have created a Date In and Date Out field. Both are set up to autofill with the created date. I'd like the Total Time to have a script that when the Out - In = negative then Date Out is advanced by one day thus solving the problem. I will then hide the Date In and Date Out so that the user won't have to even mess with them. For Example: In time is entered as 11:00 pm and Out time is entered 7:00 am. Both the Date In and Date Out are autofilled with the date 8/20/2010. When calculated ther…

hi, I tried to implement a script to correct the improper input in an address text field.. for example, change "East" and "E" to "E." ; "Avenue" and "Ave" to "Ave." ... so the script is attached here, and i set the script to the address field as "onObjectModify" it didn't work for me.. the script seemed not be loaded at all.. Could anybody point out what might be the issue? Thanks a lot! :)

I have having some issues getting the Email to SMTP server working. I had tried several tests and have been unable to figure out what I am doing wrong. If I mail through email client, then it works fine... but I need to setup email notifications through filemaker, so the smtp option is what I want. I went directly to the server and tried sending a test email from the Notifications admin... it worked fine. What was strange was that is didn't require any login information. But if I try the same thing in my Database file, it doesn't work.. it says "The connection was refused by the SMTP Server" I don't know what else to try. Has anyone had a…

I have what I hope is simple problem. I have an application where data from a single table is displayed on two different tables. This was done to make the form easier to read. Now, I have a script that runs when the user enters a particular value in a control on the first tab and should up fields on the second tab. So far, the only way I have been able to do this is by using the following combination of script commands: Go To Field[Project::Project_TestDR] Set Field By Name [ Project::Project_TestDR; 1 ] Go To Field[Project::Project_TestDR] Set Field By Name [ Project::Project_TestGSRF; 1 ] Unfortunately, this has the side effect of switching t…

Just thought i would share an observation about the Print Setup script step in hopes this will save you some time that i invested. If its there, i missed it when searching these forums, the net and FM help. If you Set Error Capture [ON] before running a Print Setup script step in hopes of capturing if the user hit the Cancel button in the Print Setup dialog, beware of the following facts: 1. If you set the Print Setup script step to "Restore" print setup information, the script step will ALWAYS return '0' in Get(LastError) whether you hit the Cancel or OK button. 2. If you set the Print Setup script step to not "Restore" print setup information, the script …

I need script advice. I am creating an expense report database. Part of my layout includes the following information – Start date End date Number of Days (calculating end date - start date) Per Diem Rate City Each days per diem needs to be itemized so I need to create a record in a portal for each day that includes the date, rate & city. Any ideas? Thanks in advance!

I have my database set up so that the user logged in can only see their records which they created. The problem is that when they open the layout to see their records it shows a bunch of records. Is there a way I can add a script to the button that navigates to this layout view that automatically does a find and only shows records created by them instead of showing all records?

Hi, I am trying to develop best practices with scripts and variables, can you please answer the following: 1)Are variable names case-sensitive? 2)Is it good practice to pass named script parameters (e.g. a=5) and what's the best way to distinguish them (; or CR)? 3)Am I correct if for any executed script that has parameters I set variables that split up those in order to use them inside the script? From what I've read from FM-Help a method for this is: Evaluate("Let([" & Get(ScriptParameter) & "]; variable)") Does anyone agree/disagree? Is there any free resource you know for developer's best practices? 4)If you perform a script t…

How can I limit the number of records allowed in a table? I have a preferences table and I only want one record in that table - the record that contains the preference field entries. There is no need for additional records, and I would like to limit it to where if a user tries to create another record it will not allow them and instructs them on setting the preferences. I cannot use account name or login name security since this will be a runtime file distributed to a few different folks. Any idea or examples of handling this?

I have a button in a portal row to duplicate the row. If a user clicks the button in the unpopulated row, the script duplicates the record, not the portal row, when it should do nothing. The script is as follows: Perform Script [ “ErrorCaptureOn” ] Perform Script [ “UserAbortOff” ] # Freeze Window # Go to Related Record [ From table: “ord_ORLI__ORDERLI”; Using layout: “PTO__ORDERLI” (PTO__ORDERLI) ] [ Show only related records ] # Duplicate Record/Request # Go to Layout [ original layout ] # Go to Object [ Object Name: "ORD Items" ] How do I test for a existing row/record? Or, is there a better way to duplicate a portal row?

If a script is paused indefinitely, and I'm running a second script in the meantime - how can I go back to the first script and resume it where it was left without using the FM native Continue button in the status area?

Hi, I want to make a script that will put every datas of one colomns into another one, because if I do it manually, it will be pretty long to cut and paste everything, and I just have a week to finish this. So is this possible? It would save me a lot of time, so I could work on something else on that database I'm building. Thank you!

I have a file that contains data as a result of an import of XML data. I need to copy some of the data to another unrelated file. They do have a common field between them and I want to find the record with the same data in that field and copy some data that was imported to that table. For further clarification: Common field is: stock_symbol Import table: data imported Investment table: contains stock data The imported table has stock data in it. I need to look up the stock symbol found in the import table in the investment table and copy some of the imported data to it. I need something like the Lookup() function for an unrelated table.

I can't figure this out but I'm guessing it should be easy some. I have a database that already has a text entry field with many lines of data. Let's call that field "DataEntry1". I have new text entry field on the layout that is blank. Let's call that field "DataEntry2" I would like to create a script that will leave the first 10 lines of data as-is for "DataEntry1", and cut/paste all the rest of the text data/lines into the new field "DataEntry2". This would be a loop for the entire database. (It's fine if the "DataEntry2" field runs more than 10 lines or even an unlimited amount of lines.) I was thinking maybe PatternCount(DataEntry1, "…

I was wondering could someone help me with some problems I'm having with buttons...I can't figure out what's wrong. Is there a way to send my database so you can see the problem for yourself? If so how? It's probably something really simple I just am missing.

I hope I'm putting this in the correct forum location. I'd like to have a welcome message that says Hello (user). I have account names set up so that users can see only records they have created using the get(AccountName) command. In my employee table I have account name and first name. I'd like the welcome message to get the account name to find out who the user is and then use the first name field from the employee table. Is this possible? Thanks!

I am trying to loop through a number of records to get all the data from one field into a single memory variable. However, as I loop through the records, they are refreshing on the layout. More details... Each record contains information about a stock. One piece of the data is a stock symbol. I need to get all of them into a comma separated variable. I created a script that does this, but as it loops through the records, the layout is refreshing and it looks a little strange, to say the least. How can I keep the screen from refreshing?

Greetings, I'm a beginner to FMP10Advanced. I am trying to create a report to show the sales team who they should call for the week. I am working with records in the "Companies" table. There are 4 main fields I am searching through; Company category 1, Company category 2, Sales Rep, and Initial Sales Task. I am trying to write a script to only find the contacts that have "Initial Letter" checked, then another script showing contacts with two choices checked. Here is an image with some help to explain.

Can anyone suggest an approach to calculating a 15 record average starting with the 15th record. E.g., the 16th record would calculate a new average by dropping record #1 and adding record #16. The 17th record would drop record #2 and include record #17....and so on. Thanks.

Want to create a script to print a Profit & Loss statement for any given month without having to enter find mode and selecting the "from / thru" dates. i.e. If the month is August, find all records from 8/1...8/31 if it is indeed August and so on depending on what the current date is.

So I've been trying to figure this out for 3 hours now, I have no idea what is going on. Hope that you guys can help. I think this is the right forum since it is a calculation. If I'm in the wrong area please forgive me. So here is the script, very basic. I'm looking to capture video to a time and date stamped file in a predetermined folder location. For this I'm using the Troi file plugin and the Grabber plugin. Set Variable [ $filename; Value:BOSIS Basic::File Location & Get ( CurrentTimeStamp ) & ".mov" ] Set Field [ BOSIS Basic::Video File; Grab_OpenMovieGrabWindow( "-Unused" ; "QTKit"; "Built-in iSight" ; "$filename") ] I've run it thr…

Hello All I need a little help with “Middle”. I am trying to use a magnetic card swipe to retrieve First Name, Last Name, DOB and Address from a drivers license. I have been able to write the Middle scripts and all but the “Name_Last” and “City1” work just fine. There is no brake between them and with out knowing the length of the last name or city I have not been able to find a way to separate them. I have attached a sample file with the scripting and the info the card swipe gets for the strip. Any help would be greatly appreciated. %[color:red]FLPORT ST. LUCIJOHNSON$FRANK$GERALD^186 NW PEACOCK BLVD. APT. 501^ ? ;6666666666666666666=1107195899290=…

Hi, I have created a financial db tracking all my finances. There are instances, however, where within the current found set all my transactions need to be labelled, either with store_name (the store name), category, etc. For instance, if I loaded all transactions of "best buy" and i want to label every store_name field "Best Buy", i have to do it manually. I want to create a script based on a keystroke enter (such as SHIFT+ENTER) that will automatically populate all transactions within the found set with the result i put on that given cell. i.e. i put "bank of america" in store name and click the keystoke, which prompts a warning and then results with all the…

hello I explain what I want to do, I have 2 tables one country and another contact .... In my country I have a button layout that allows me to open the Contact layout. The script which displays all contacts related to my country is 'Go to related record. Until here I have no problem, but when ther is no Contact related to the country the layout does not Open. This is normal since I use the script 'Go To record related ....' So I push my script. Tell me if I'm on the right track. If I validate my id in my table country .. I think it makes sense. But it does not work ... My new script is the following 1 - go to layout ['contact'] 2 - if [isEmpty (COUNTRY:: ID)] 3 - …

I want to extract data from a table, select desired rows using condition on the field and count it. Thanks in advance.

Hi, I'm trying to set up a script which will print various layouts to one pdf. I would like the PDF to be saved to the user's desktop and subsequent layouts printed to append to the original file. I got it to work with a db stored on my local drive, using the following as the file path: filemac: $filepath Get(DesktopPath) & "HMMP_Interview.pdf" However, the filename it gives the PDF file is everything after "filemac:" and all I want is the part in quotes. Also, when I imported the script to the database hosted on FM9 server, it no longer works, I get an error message about not being able to create the file on the disk. How can I get this to wo…

I have a database that has a field with 4 checkboxes. I am trying to write a script to clear the first checkbox without touching the others. My latest attempt is: Show All Records Go to Record/Request/Page [First] Loop Set Field[Contact::Category; ""] Go to Record/Request/Page [Next;Exit after last] End Loop Show All Records I tried using a Get (FoundCount) = 0, but that put a "0" in all my records!! I know somewhere I need to specify LeftValues(Contact_Category; 1) to indicate the first of the four fields. When I try to do this in a calculation it tells me there is no such field.... I am using FM Pro10.

This is an interesting one for me as I can do everything else to this problem but the most important. What I'm doing is adding the required records from one table to a temporary table so I can export in the right xml format (for invoicing). I would use the source table for all the information apart from this one item - travel. Everything else gets itemised apart from the travel in which I just need a total of all the trips. The easy way out would be to itemise it as well but this would double the entries for the invoice and make some clients invoices several pages long. So the question is, how would I go about totalling the Travel field for each client…

Greetings; I am trying to get a script to copy and paste information from Layout B Fields 1, Fields 2, Fields 3, Fields 4, Fields 5 and to paste them into Layout A Fields 1, Fields 2, Fields 3, Fields 4, Fields 5. I read somewehere about SET Fields is better to use then Copy and Paste and even with that, it still isnt working. Here is a copy of the codng. If [phone list::Outcome1 = "Appt"] Goto Layout ["Booking Sheet"(Bookings)] New Record/Request Set Field [bookings::ApptStatus; Phone list::Outcome 1] .... When i run the script i get the new record, but nothing is being copied over.

Hi I am developing a billing system in Filemaker Pro 10 on running in Windows XP and I need to connect a Epson TMU220 tax bills printer, it's works connected to a serial port, controlled by an OCX in VisualBasic, I have the documentation of the OCX. the question is, How I can do to connect FileMaker Pro and the OCX which controls the printer from a FM script?. Thanks Luis

I have a script that pauses for the user to modify 3 fields in a record. Is it possible to have the script continue without pressing Enter or clicking on a Continue button once the 3rd field is modified? Or is it possible to script the pressing of the Continue button? I can trigger the selection of a button upon modifying the 3rd field but that doesn't "press" it. I guess what I'm asking in general terms is if there is a way for a script to be paused until certain conditions are met and then resume without the user having to click anywhere or press the Enter key. Cheers, Alvise

I have a client solution made up of two databases. The first contains all the data tables and the second, called Interface, contains all the layouts. In the Interface I have a series of seven layouts, each with seven buttons used to navigate between the layouts. There are three sets of users, the company owners, who have Full Access with full privileges, the production manager, whose privilege set is called Management, and artists who have no access to this part of the solution. Management can create, edit, and delete in all tables, view only layouts and value lists, and execute only all scripts. Each of the seven buttons is linked to a single script w…

Does anyone know of a way to recognize when someone presses a button while holding the Command or Shift key? I'm hoping to use this to allow someone to highlight multiple rows in list view (conditional formatting based on a global field equaling the record ID). I suppose I could just allow them to turn on a mode that would do that, but I was hoping for a more elegant solution...

I'm trying to write a script that copies an ID number from one Layout/Table, goes to another Layout/Table and finds any records with the same ID that I copied. I'm trying the Perform Find and Set Variable script steps but can't get it right... Many Thanks

If I wish the result of a user's entry in a questionnaire text field to command the selection of a particular tab in my layout, and a particular field in that tab, I assume that I need a script to do this. If the initial text field has four choices, and the result of this drop down list selection means that the user should enter data in different sections of the layout. I want the script to open a particular tab, and select a particular field. Any advice would be gratefully received!!!

I’ve just started using FMP, I’m teaching myself how to use it and I’ve hit a roadblock. I’m sure this is an easy question to answer, not sure why I can’t figure this out! The database in question tracks results in races. The data is organized such that each runners performance in a race occupies one record. Each race has a reference# and each runner has a runnerID. What I want to do is have a script perform a calculation to see the average speed over the previous 3 races. I created a new layout with runnerID and average speed fields. In my mind I envision that I need to write a script which when a runnerID is entered it will perform a find for that runners last 3…

Smart People, I need to open specific URL's in specific browsers due to website compatibility issues. All of my users are running FM in OSX and Windows via Fusion, probably 75% of the 100 or so websites are going to have to open in IE (esh!). I am able to launch IE after making an alias on the OSX side but I need to get IE to go to the specific URL. Any thoughts? Thanks, Peter

I created a script which sends an email through mail with a pdf attached. The text I wrote in the message box of the script is placed in mail as text on a black background, so one only sees a black box. The text is there as selecting the box highlights the text. Does anybody know how to avoid this?

I've searched online and haven't found the answer to this question. I think it's pretty simple, so I may just be using the wrong terms to try and find the solution. My apologies in advance if this is repetitive. I'm working on a rental system. One of the layouts allows the user to edit invoice details, including adding extra line items to an invoice. The line items are displayed using a portal. I use a plus-sign image as a button to add additional line items. The button calls a script that opens a new window and displays a layout with the additional inventory that is available on that day, then pauses excecution. In browse mode I use another little image next to each…

I have created a script that prompts the user to "confirm" that they want to delete a record in one of my tables. Even thought I'm asking them to confirm, another Filemaker message is coming up after mine asking them to confirm they want to "delete the entire record". Is there a way to suppress this message from Filemaker?

I'm designing a contact-management layout. Each record in this database can be either personal or corporate, and there's a checkbox on the layout so the user can choose one or the other. There are fields in each record for both personal and corporate info. Ideally I would use conditional formatting to hide irrelevant fields (e.g., the company name in a personal record), but this layout needs to work in IWP. So I've laid out the layout with two subsections, "personal" and "corporate." But I still want to prevent users from entering/editing data in irrelevant fields, so I've set up an OnObjectEnter script trigger that immediately commits the record if the user tries to…

I’am a bigginer in FMP. To explain, I wish to transfer data from one table to another. I have an application for HR. I plan to add several candidates for a position. the candidate does not yet sound the Employers. After selection of five potential candidates I will choose one and add it to my table Employers. Those here that I do not know how. That is to say that once my candidate is selected I want to transfer some data from my table candidate and send them to my table Employers. At the same time it would be cool to use to generate a auto employee number ... but already in short if I can transfer some fields of my table to my table Employers Candidate would be ideal. I…

Hello - I would like to have a script where the user can automatically be prompted to enter a month from a value list and that answer will update an auto enter field from define database. I know that it can open the entire define database but I don't want them to be able to make changes to the other fields - in short making it fool proof! Thank you.

Was watching some FM vids on youtube and noticed that one presenter was creating some calculations using the windows version of FM. At the bottom of the calculation screen there was a button "Evaluate Now". Is this windows specific or just FM Pro 10 specific? I'm currently us FM pro10 ADV Mac and there is now such button on my calculation screen. If it is only FM10 or windows specific what gives! I would really like to be able to see whats happening in my calculations seeing as running in debug doesn't go there. Thanks Michael

I'd like to add a dynamic field into a database of names. table 1: dates table 2: names table 3: dates & names while I am looking at table 1 layout (dates), I'd like a field in table 2 to somehow signal that a record exists in table 3 that matches it's name and the corresponding date from the active record in table 1. example: table 1: 5/02/10 table 2: John - YES James - YES Mary - NO table 3 5/02/10 - John 5/02/10 - James 5/14/10 - Mary 5/26/10 - Jonh 5/26/10 - Mary then if table 1 changes records: table 1: 5/14/10 table 2: John - NO James - NO Mary - YES table 3 5/02/10 - John 5/0…

FM 11 Adv, Win Vista: The script manager displays script folders in the drop down menu. However, when I click on the folder, the contents do not appear in the menu. Any suggestions? A bug in FM 11?

As I gain proficiency in FM, I'd like to replace all the instances of five or six virtually identical scripts that do the same basic thing with one more general script. But I am finding that this is not often so easy, as much as I am learning about objects and design functions. For example, there seems to be no simple way of replicating Go To Related Record when you aren't dealing with concrete, specific TOs. The tools sometimes don't appear to offer what is necessary, and I have had to consider introducing inelegant calculation fields to try to mimic the action of commands that work well with specific objects. I'd very much like to know what seasoned FM scripters do…

Hello! I am learning filemaker as I work on a database and would appreciate some guidance. I have a master members table (as primary key) I have a master games table (as primary key) I have the tournament date table (as primary key) I have a scores table (as foreign key: date, member, & game) So, when I create a new tournament record, I then assign a subset of games to play on that day. Then, a subset of members joins that tournament. Each time a member joins the tournament, I have to create a new score record for each game...usually up to 7 games. Is there a clever way to assign a member to the tournament, and automatically creat…

Not sure if this is the right forum. What I need is a way to capture the date and the exact time in a field. Here is what it is for. It is a tardy calc I am trying to build. I have a field with a value list and a drop down box. The user can choose between 1st - 7th period. Then there is another box that the date and the exact time needs to be put in. Can this be done automatically? In other words the user clicks on the field titled "Date/Time" and the date and the exact time is inputted in the field. Then I need that field saved forever. Because that same student could come back tardy again but on a different period. So I would need to be able to use that "Date/Time"…

I'm wanting to put in a signature for all my quote forms. I'm hoping I don't need a plug in. Currently I have a drop down list with my name and a few other employees. When someone make a quote form they choose the correct person from the drop down list. Then we print the quote and the person signs it above the text we chose from the drop down list. I already have a signature I can import. How do I make it so that when we choose from the drop down list the matched signature will be placed above the name in the text.

Hello. I'm updating a database I created for my company to keep track of inventory/jobs/purchase orders etc. and I'm stuck on one little thing (it's probably a really easy answer but I couldn't find it when searching). I've got an Items layout with the item ID referenced in a web viewer that shows the vendor's web catalog. I already have it working so that when I change items in my database it automatically changes items on the web viewer. What I want to do now is to put the web viewer on a tab control so that it does this in the background but does not display default, only if you click on the tab. I have in one of my scripts an If step: PatternCount(GetLayout…

I've made a report that shows all open work orders. Because orders are always being made and shipped I need to update the info every 15 minutes. I included the install on timer on my script. It updates and refreshs the page. Is this the correct comman to use? Also, How would you stop it once it starts. Is there a stop script timer?

I have a script that finds related fields in various tables in order to make a summary report in text format. It is getting rather slow now that the amount of records is increasing. I think that a main issue is that whenever I do a search to find the related records in related tables, the window is drawn. I have tried to Hide the window, but it still shows up and likely slows the script. Is there any way to prevent the window from opening in the first place? Thanks, Fed

I'd like to create a report that shows the future value of a savings account in yearly increments. Example: 2010 | $100.00 2011 | $105.00 2012 | $110.10 The parameters of the valuation like starting balance, interest rate, and how many years to project are in a table. I'd like to have a the line items in the report be populated by the database dynamically as the report is run. I'm thinking I could do this with the use of a script that populates a separate table then using this table to base the report from, but I don't have enough experience to know if it is the best way to do it. Does anyone have a better approach?

I would like to create a layout that looks like an excel spreadsheet. And I need help big time... My data has these fields: Date, player, score, game. I would like "game" to be the column head. I would like "player" to be the row head, and I would like to add the score into the "score" field in the grid. There can be any number of players. There will be anywhere between 1 - 7 different games. So, I would like the layout to dynamically create column heads depending on how many games there are on that date. Is this possible? I need guidance please. Thank you! example: (I would enter the score in the appropriate score field. Date …

Is it possible to detect if a script was triggered from the client or the server? I'm thinking of something like: Get ( ScriptOrigin ) // 0 = client and 1 = server Thanks.

Does anybody know by which priority script triggers are run? And also, if you set a default menu set for a layout, does it apply before or after the OnLoad layout script trigger? I would like to have ordinary FM menus if admin logs in but defined ones for normal users.

I'm currently using FM 9 and I'm trying to figure out a way to capture the date that a notes field was last modified. We may be getting FM 11 in a few weeks, so for now I wanted to do this without using a script. I thought maybe I could do it with a calculation function but I can't find one that looks like it can capture what I'm looking to capture. My database is already set up to capture the last record modification date. I want to capture the last date that one field was modified. Does anyone know of a way this can be done with FM 9?

The TO "Companies-JoinCP-People" manages a many-to-many relationship. Setting the Data Viewer to: Count (Companies-JoinCP-People) returns an accurate count no matter what record I jump to. However, when used in an If statement it does not. If(count(Companies-JoinCP-People) = 1 skips, does not enter the If statement when it should. Exactly the same thing happens if I create an unstored calc field with the formula "count(Companies-JoinCP-People)". It displays accurately in the Data Viewer but doesn't function properly in a scripted If statement. This is in FMP11. What am I misunderstanding? Kind regards,

I am trying to calculate a growth rate. I have a table of individuals (parent table) that were measured on multiple days (multiple measurement for each individual = child table). Because the growth rate is so slow, sometimes a later measurement is smaller than a previous one, just because of the accuracy of the measuring tool may not be sensitive enough if two measurements are taken close in time. I want the parent table to have a field showing the largest measurement (max(child:measurement)) and the smallest measurement (min(child:measurement)). Subtracting one from the other gives me the change in growth. I can get this far. I also want the parent table to sho…

I am creating a sort of question and answer table and I have many fields that are temporary. They gather the information about the user and how they are doing with the q&a. Then the data gets saved to another table. When the user finishes the data stays until a new user goes to the table and all the information gets reset, except for the questions with a script trigger. If someone else comes in the script trigger erases all the personal information and it becomes theirs(as each record is opened). Is there a way to lock the table for only one user at a time?

I made an inicial script with a "Close current window" command. But I did something wrong because now I can not open the file. Every time I want to open that file, it closes. Do you know how to open the file without scripts? Thanks in advance.

Hi, everyone! I hope I have this in the right forum. It seemed the best fit. I have no trouble copying field contents to the clipboard. That seems to work very well in v6. But I need to have a button that sends a particular text string to the clipboard. That I've searched and searched online for a solution to but nothing I've tried works. I've also downgraded my skill level to entry level. Perhaps in real life I am an intermediate, as compared to the average user, but on trying to do all this, I see that I'm actually a newbie compared to you folks so hopefully, a simple solution is possible in v6! My version is old but because I don't use FMP at work…

This is the last issue I can't find a solution for for my database. It would be very helpful to know if it's possible in v6 to change 2 of the attributes to text in a field. If the text is selected, it would be nice to set that selected text to bold and to the colour navy blue. Is such a thing possible in v6? Thanks much!! Much appreciated in advance.

Does anyone have a script that will look at address and/or phone number fields of a given record to lookup the correct time zone that record is in and then insert the current date and time? That would be very handy if you could share it. I saw a post (Post#262763 - http://www.fmforums.com/forum/showpost.php?post/262763/) on another thread showing how to calculate UTC time that was sort of on the right track minus a way to look up and/or calculate the UTC offets needed to figure out the right value for your given record. I also found a nice little Mac OS X app ( http://www.veladg.com/velaterra.html ) that does a lot of what I'm looking to do. Apparently the tz database is …

I need a way to attach a sound for a good or bad scan within the FMP application I am working on. The system works with a barcode scanner and I need a good scan sound and a bad scan sound but I need it to play without popping up an additional 3rd party media player of any kind. I am using standard wav files for my sounds. (Windows version solution btw) please someone aim me in the right direction toward finding the solution to this problem. :bang:

In a small network of two Macs running FM 8.5/FM 9, networked to a third Mac acting as a server via client software, will FM 10/11 script triggers be executable by the clients when they are running the earlier versions of FM?

Attempting to loop through found set and change status. I don't know get(last error) code that signifies no more records in found set and to break out of loop. Any help appreciated.

Hello, I've been using EventScript plugin successfully for running a script when a field is set to a specific value (an on/off radio button field). Can FM 11 do this natively? I can't seem to find any mention of this functionality anywhere. Thanks, Alvise

Hello all: I was trying to delete a record from my database when I got the following error message and I'm not really sure where to look to troubleshoot this. (see attached screenshot). I would assume its a relationship graph issue but again I'm not sure where to start looking. Any ideas? Thanks.

Hi there! I have a script going into endless loop and can't figure why, here's the story: I initiate a script for selecting a record in a pop-up window. To oblige the user to either select or cancel, I use a loop script step with an Exit Loop If set to recognize if a "cancel" result from a subscript has been returned. When I attach the cancel subscript to a button it works like a charm. But when I load it through an OnLayoutKeystroke Trigger (trapping if ESC is pressed) it returns an error 20, closes the window (as it should) and then pauses endlessly, not exiting the Loop. Can anyone help?

I need to compare fields across two tables, find matching data, and change the value of a field in one of the tables. What's throwing me in FMP scripting is that I can't compare arrays or iterate through a list. Here's what I need to do. I'd love any wisdom as how to best approach it. Look at the records below. Each has 9 fields. One key field and one field for each of four appliances, each with a corresponding field used to store whether the appliance is on or not. I want to copy the values ("on" or "off") in the "A" type fields in Table A records into any records with matching key fields in Table B. I know how to check for the related records between the tabl…

Hi All I have a layout with many check boxes on it - but I like nice graphics, so I have implemented a script to show these when each tick box is clicked. The trouble is I now have 15 scripts activated for each individual field - is there anyway to get just one script to act on many different fields, so that each tick box would display the graphics that I chose. It is important that an associated field, ****:Data contains a value (0 or 1) so that it can be used elsewhere ?? The script is basically, If "Tick"=1 Set Field[Tick;0] Else SetField[Tick;1] end if

Hi everyone.. this is another thing that's been im my mind but not sure if I can implement it or not- I want to incorporate a script with a pop-up error/reminder message for the data input. For example, when people input the address in the address field, I want to be able to detect if they input something like "Aparment" "Unit" or "Suite" (I assume this part can be done by a script) and if they do I want to automatically pop up an error message to remind them to input "Apt." instead... Can I do that in FM? Thanks a lot! :

I am running a script in FMP 9 on a mac that opens up a window with related records in order to act on the related records. I have made this window 1 pixel tall and 1 pixel wide, but this little box of a window still flashes if only briefly in a way that I'd like to avoid. Is there a way to hide the window but still have it be the active window for the script? I feel like there should be an obvious answer for this but I am stuck stuck stuck! Thanks! - Stephanie

Can you set up a field so that when you enter a set number of digits, say 1 number, it automatically tabs to the next field rather then manually having to tab?

I'm trying to replace data in a field after inputing records, however it updates all the records in the database. Here is my code: Show All Records Import Records [ ] If[Get(FoundCount) > 0] Go to Record/Request/Page [ First ] Go to Record/Request/Page [ First ] Freeze Window Loop Set Field [ Marketing::Group Name; Setup::Group Name ] Go to Record/Request/Page[ Next; Exit after last ] End Loop End If Refresh Window What am I missing?

I use check boxes to track job progression. One check box is "Sent solicitation email," another is "Sent brochure." I need a script I can run that would automatically check the "Sent brochure" box on every record in a found set, otherwise after using the found set to print labels, we have to manually check that check box. That's not realistic when we have found sets of one or two thousand records. Is a script to do this possible? How should it be done? It has been quite a while since I posted a question on this forum, but as always, I really appreciate the information shared here.

I have a script that executes "go to layout" just fine. However, I can't seem to figure out how to get the script to specify the layout "view as" (such as form view, or list, or table view) when it gets there. It lands on the layout in which ever view was last used. How can I get a script to switch the layout view? Thank you.

I am very familiar with how to utilize arrays in programming.. but for some reason in FMP I am a little lost on how set this up. I just need a very basic static array. I know it will have 12 values at max. I have a loop.. --------------------- Goto First Record Loop If Not isempty(Count) $item1 = Item $Count1 = Count Go to Next Record(exit after last) End Loop --------------------- What would be the best way to have $Item1 and $Count1 automatically become $Item2 and $Count2? Or in programming terms $Item[n] $Count[n]... where N is incremented after each record in the loop. The maximum the array will ever be is 12 Seems like…

I want to include in a script that copies a number say 25 from the field "Nos of copies to print" and pastes it into the Dialog Box "PRINT" (cmd - P) Copies: = (default = 1 ) changed to (paste) = 25 With FileMaker Pro if your mind can think of an Idea, you can do it with FileMaker - Top product and just keeps getting better

I want to create a script to export records... copy (field)-"todays code" export required fields Now - I want to paste "todays code" into the file name for the export document and what also would be nice is to place this file name with the "todays code" into its correct folder (which is static) any ideas

Does anyone else have this problem (and how was it solved)? Recently for some reason when I go to edit a script, the program will crash as soon as I open up the script to edit it. The first time this happened it was with a script which had HTML in it so I thought that might have had something to do with it. Now it's happening with another script that doesn't. I even deleted and rebuilt the script, in case something was corrupted, and it still crashes. I haven't changed anything on my system (that I know about) and these scripts aren't new. Can anybody help me out?

Hi all, I just created a label printing script that is used on 3 different workstations in the company. All 3 of the workstations have an identical setup: OS: Windows XP FM Version Filemaker Pro 9 Printer : Dymo LabelWriter 450(same drivers) The only difference is the regular inkjet printer at each setup. I have two of the workstations working properly, and only have the third one giving me issues. The problem is that, after printing a label, the default print settings for the inkjet printer are set to a Paper Size : 3 x 5. Even if I go into Print Setup and change it, it still prints a 3x5 size. The only way to reset to regular letter pape…

This is more of a is it possible type of question but i thought i may post it here to see how others may be doing it. We have multiple "How-To" forms that we frequently email our clients upon request. Rather than having to manually create the email i would like to script this within filemaker. What my original thought was is to create a separate tab within our database with a button to email each individual document. While that will work, it will take up more screen real-estate as well as look cluttered. Would it be possible to somehow have a list of all the documents available, possibly a checkbox list, and then have a user check of which document or …

Hi All I have a simple FMPro 8.5 database and I am trying to write a script in Scriptmaker to write one file for every record, containing the content of just one field, and with the file named according to the content of a different field. The following is a screenshot of what I have tried to do: It doesn't work, of course!! I have 2 problems (1) I don't know how to create the filename out of a field's content [so I've used qqq.htm just as a placeholder, until I could figure that out]; and (2) I'm not sure how I'll get a set of files (one for each record) written into the folder I want (called "specimens", in the same folder on my Mac as the …

One of the problems I worry about with my current solution is that a lot of it is script driven...which has me scratching my head as to how to prevent the end user from accidentally clicking another button which would cause a second script to start while the first one is still running. I've come up with the attached, quick-'n'-dirty script that I might use to prevent such a problem; it would be inserted at the beginning of every script so before the script can execute, if it "sees" that System::gScriptControl = 1 then it terminates the second script and lets the first one continue running without interference. At the end of each script would be: SetField [s…

(Mod: I wasn't sure this question should go into Scripts or Importing/Exporting, so feel free to move my post as you see fit.) I want to create a script that will allow the import of only .jpg or .png files into a container field. How do I code the script's step(s) so it will look at the file extension upon import? If the imported file isn't .jpg or .png is there a way I can use FMP error code 700 as a trap?

Can someone please tell me how to write a script that will search a text field for spaces and replace them with dashes?

I have a script running at 30 minute intervals with an attachment. The attachment works fine when I run the script manually. However, during the schedule, the file does not attach. The first thing I do in the script is set a variable: Set Variable [$_filepath; Value:Get ( DesktopPath ) & "_revision-" & TimeStamptoString ( Get ( CurrentTimeStamp ) ) & ."xls" The custom function TimeStamptoString ( Get ( CurrentTimeStamp ) ) is self-explanitory, though one can read more about it here ( http://www.briandunning.com/cf/117 ) Later, I export data (see screenshot). Finally, in the SendMail script step (which is otherwise working fine), th…

I have been reading some similar posts, but can't seem to get this to work. I have a db where each record is tied to (by using the same name) an external ods (Open Document Spreadsheet) file. I want to be able to click a link and open that file from the server. The files can be accessed by everyone in our office by visiting 192.168.1.80OfficeWorkOrdersWO-XX-X.ods Is there a way to create this link automatically? I know that container fields can hold references, but I would rather have a simple button link to the file from the time my record is created.

I am looking for a way to do some validation to keep users from leaving empty fields behind when creating a record. I can't use field validation to not allow the field to be empty because that only works when the field is active. If the user never enters the field the validation is never triggered. I can't just force the user into the field when the record is created because a line item has to be selected first before the field in question can be populated. Is there any equivelent to onrecordexit?

Hi, I have a script that checks the database for debtors. You input start and end date then it looks to see if a job has been invoiced > 30 days , then checks to see if the payment received date field is blank. It then produces a report between the 2 dates you inputted which works O.K. What the boss wants is if an invoice was paid on 17/06/2010 and you run the report from 01/06/2010... 15/06/2010 it still shows on the the report because as of the 15/06/2010 it was not paid. Any ideas?

Hello everyone, I'm a little confused over some script issues I have regarding modifying them. Quick rundown, Account: Supervisor Privilege set is set as follows: Records: create, delete, and modify in all tables Layouts: all modifiable Value lists: all modifiable scripts: custom privileges Under scripts I have 2: 1. Start, which is set to executable only 2. Authorize, which is set to modifiable However, when logged in under Supervisor account name, I am NOT able to modify the "Authorize" script as "Manage scripts" is grayed out. Can someone point me in the right direction as to what I am doing incorrect? Thanks in advance.…