Script Workspace and Script Triggers

I know this is simple but I am missing something and therefore cannot figure out what to do. Everything I try doesn't work. I want to create a script that will transfer me from Table A to Table B staying on the related record. That's it. I have a relationship that works between the two tables but just cannot figure out how to move from Table A to B. I am assuming it would be a find script with a set field by name? but I cannot get that to work. Any help would be appreciated. Thanks in advance

Hi All, I'm new to filemaker..and I have few questions. - I have one dropdown menu with different values. - I want other text box to filled up based on dropdown menu selection using script. How can I do that.?? Thanks in advance

I have a filemaker solution hosted on a server, but I cannot run server side scripts. I need something in my filemaker database that will run every 24 hours regardless of wether it is open or not by a client. My goal is to have a script that will run every 24 hours and produce an email with an attachment of my current stock for about 12 items. The email and attachment I have created, but I don't know a way to run the script automatically. Any ideas?

When you delete a record or to make a save somewhere.

I'm trying to make a layout that shows today's hours that have been reported by an employee. Basically a horizontal graph that shows 6:00am on the left and 6:00pm on the right. For each hour that has been reported I want it to "fill in" those hours on the graph. Hours are reported in another layout. One entry could be that they worked from 6:00am to 9:00am. In order to get the graph to "fill in" I'm thinking of having Conditional Formating based on a formula that finds out if there has been anything reported for that time slot. I'm planning on having a conditional formating area for every 15 min block. So for my block designated for 6:15am - 6:30am could …

This is strange and frustrating: I have a drop down list displaying ALL layout names. This drop down list is on all layouts. When a User selects a layout name from the drop down to navigate to it - it fires a script trigger that takes them to the layout. This seems to work except on some layouts it takes you to - a tab order object obtains focus. I have not been able to find a reason why it does so on some layouts - and not others. The behavior from the result of my script is different than just a straight "Go to Layout" button, or even a script defined to go to layout. It appears only to happen with the script I created. There are steps in the script…

Firstoff, yes, Outlook 2011 for Mac is set as the default email client. We use the Filemaker script step "Send via email client" extensively and it's always worked fine with Office 2008. The script step formats an email with recipient, cc, message body and attachments and passes it along to whatever client is your default, that is, Entourage 2004, 2008, Mac Mail, Thunderbird, whatever. However, it does not finish the job with Outlook 2011, which is a complete game changer for this office; a significant percentage of our sales outgoing mail is quotes, invoices, POs, etc generated from that simple script step. When I follow the script through with Filemake…

I'm trying to make it so that when the file starts up it sees what user group they are a part of and then takes them to a layout based on what privilege set they are a part of. Right now I just have a big IF script that checks for each user by account name but that could get lengthy depending on the number of users. Is there a scrip like Get (AccountPrivilegeSet)? or something similar?

Hi all I have this portal with projectlines in it. For every projectline the user can input a description. Since it's too big to put in the portal I would prefer a button on the projectline. This button must enable the user to click it and enter the description. (in a pop-up or so?) How can I do that? Is there an example I can use to point me in the right direction? Thanks ! Sabrina Horst

is it possible to see where a script is used/triggered ? When getting a database from someone else (or maybe your own) and you see several scripts, then it is not always obvious where this script is used/triggered. Is there a way? Thanks Sabrina Horst

Am posting this here because it only happens when I run scripts. I'm assuming my DB is corrupted, but don't know what to do about it, exactly. Is it only the scripts which are corrupted? Help!

I am a newbee to FM. I am using FM-11 on MAC OS 10.5.8. I created a database table and layout of STUDENTS that included their email address. I then created a second layout whose records were letters that included the student’s names, email addresses and grades. I plan to attach extra credit work to the letters. I was told that to send individual emails to the students required writing a script for a loop through a found set. I have no idea how to do this. If someone could write the script I need, I would appreciate it very much. If you could explain how it works and why, I would be even more appreciative.

Hi all I am trying to achieve a task in Filemaker 8 for a mac, and have spent hours trawling this forum for answers but no avail! I have a database with two fields, name and email address. I want to export each record as a PDF, naming each PDF from the name field as a seperate PDF, into a folder called invite on my desktop. Then attaching each PDF to an email generated by the email address in the record. Is this something that can be done? Am new to more advanced scripting so has me stumped. Any help would be amazing. Thanks! Graham

Hi all, What I am trying to do is create a script that will add the current found set of customers to a chosen group. I have the following tables: CustomersTable kCustomerID JoinCustomer_GroupsTable kCustomerID kGroupID GroupsTable kGroupID I know that I need to grab the kCustomerID for each record in the found set and place it in a new record in the JoinCustomer_GroupsTable (along with the kGroupID of the group I am trying to attach them to), but I just cannot seem to make the script work right. Thanks in advance!

Hello all, I have a script that creates a group of letters to be printed, from a found set in a related file. I'm stumped with the next step: some of these letters must be mailed to an owner, some to an agent. I have a key field that tells me which entity should receive the letter, and I have the contact info stored in either owner fields, or agent fields - but I can't quite figure out how to print the letter to the correct receipient. Seems like I could either sort and seperate the records into two lists, and then send each list to the appropriate layout to be printed. Or - is there a way I can set a field on a letter to import the appropriate …

Hi, Can anyone tell me how I would pass a script parameter between 2 databases please? Or if there is an easier way? Cheers

I have a field where the user can input text and I want them to be able to insert tags like or I want to use the tags as variables so I when I run a script I want to it to look for all the tags and process each of them and at the same time substitute them for something else. anyone know if this is possible /how to make this happen?

As I understand it, if you open a file directly which has a start-up script defined in the file options dialog, the script will run. However, if the file has been opened hidden, because of some relationship between it and the currently open database, the startup script seems not to run. Also, if I specify a script step in my current file which runs a script (not the start-up script) in another file that isn't open, the start-up script does not run. Is there a way of forcing the start-up script to run whatever way the file is opened? What I am trying to achieve is to set some global fields for the user however the file is opened - perhaps I need to use…

I'm interested in doing batch edits to my list of scripts, search and replace sort of functionality. I found an external utility called FmPro Script Diff, but as far as I can tell this software is awful. It crashes frequently, gets confused by folders in your script list, etc. Does anybody know of some other utility for working with FM scripts outside of FM's script manager? Or is this the only thing out there of its kind?

Hi All: I've been trying to figure this out on my own for a couple of nights now and I haven't fixed it so I thought I would check with people smarter than me! Problem: I keep getting error 504 which is basically the primary key constraint I set up on a field. Purpose: The purpose of this script is to add a related event from the Planner table when the values in the field "Interests" in the customer table match the interests field in the Planner table. The super script is a save of the customer record, and there is the possibility that the user changes the "Interests" for a customer. When this happens, the logic should go into the Planner table and find ev…

I have some records displayed in a portal each with a button to go to the record on a different layout that is based on a non-related TO. So it's not a GTRR since it's not going to record on a related TO. I am actually going to a record in the same underlying table but just jumping from one layout to a different one that is based on a non-related TO. My Relationship Graph is getting pretty spidery as it is and I am trying to keep to the anchor buoy method as much as possible. I have tried setting a variable with the original recordID and then go to another layout with a record that is related to the destination TO and doing a GTRR from there but it isn't worki…

Hello, thanks for reading... What I currently have is a customer info layout, with a button that runs a script to create a new invoice for that customer. I'd like to create a 'hotkey' to create the invoice, instead of mousing over to the button on the layout. When I add an OnLayoutKeystroke trigger that runs the 'new invoice' script when 'i' is detected, then of course any time you enter any data containing the letter 'i', the new invoice script will trigger. Is there a way to implement this by only triggering the script when no modifiable text field is selected? Thanks for any help, or suggestions for a better means to this end...

I have a script based largely on mfero's file, found here. The script moves data from FMP to iCal via Applescript. Here is what I passed to Applescript: BEGIN:VCALENDAR BEGIN:VEVENT DTSTART;VALUE=DATE:20101025T130000 DTEND;VALUE=DATE:20101025T140000 SUMMARY:Text/Text string here VFREEBUSY:Busy LOCATION:555 Street Ave., San Jose CA DESCRIPTION:Contact: John Doe (209) 555-5555, PO # Cl 0180762866, Company Job # 10-779 END:VEVENT END:VCALENDAR This worked until recently. I changed the code to this: BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Company//NONSGML FMP database//EN BEGIN:VEVENT DTSTART;VALUE=DATE-TIME:20101101T130000 DTEND;VALUE=…

Hi Everyone, I wrote a small filemaker tool to help me manage print jobs. In my solution, employees of my company often wanted to combine several print jobs into one job, so I created a tool for them. My tool relies on the fact that, in Preview Mode, if you execute the "Copy[]" script step with no parameters the entire contents of the layout are copied to the clipboard. My script copies various reports and pastes them into 8.5 x 11 container fields in another table. Then we find all the pages of the job in this table and print them. My problem is that this script is somewhat unreliable. I'm printing a 2 page job using this system, and the first page shows u…

Is there a method to set a script to run based on time - say every 15 minutes? Specifically, I would like to setup Filemaker to import all images that reside in a server folder - and I'd like it to check that folder at regular intervals. Is there a way to set this up in FM - or with a 3rd party plugin? Thanks much.

Ok so I have two tables. Table A and Table B. Table A has 2 fields, Field A and Field B. Field A is a data point, and Field B is a category. Table B has 1 field, Field C which is a data point. I want to write a script that Creates 1 record in Table B for every record in Table A that match a specified category in Field B and copy the data from Field A to Field C for each new record in Table B. Example: Table A has 10 records. 5 of those records have the value "X" in Field B. For each record in Table A with a value in Field B of "X" The script would create a new record in Table B and copy the content of Field A to Field C. End result would be in T…

I have a donations file and I want the user to be able to select two dates a start date and an end date from two different fields that have drop down calendars. then when they hit search any donations that have been made between those dates will result in the search. I think i have to set the start date and end date fields as variables and run the search against the variables and the donation dates. The problem is that when i set the contrain found set in my sscript to search fro records where the donation date is greater than or equal to the variable that i created it wants a date format. But i cannot do this since the date will always be changed depending on what the us…

I'm trying to use this calculation to find out if we are on the last record in found set or not. But somehow it doesn't work. I can't figure out why. The field is dynamically generated so it can be reused on other tables. Let( $field = Get ( LayoutTableName ) & "::ID"; If ( GetNthRecord ( $field; Get ( RecordNumber ) + 1) = "?"; 1;0) ) Thanks in advance for your help!

Hi. Thanks for your help. I need an action to be performed based on a login name. Example, if Jane Smith logs in, I want a script titled Jane Smith to run. If Tom Brown logs in, I want a script titled Tom Brown to run.

hello all, this is my first post and would just like to say g'day to all first. I really need help in writing a script in dummy terms please, i believe it will need to be a Install On Timer Script and i have no idea how to do this. e.g. Vessel logs on at 10:00Hrs and states he will return back home at 16:00Hrs, I need a reminder to be given just after 16:00Hrs and be taken to that entry in our radio log for us to follow up on his where-abouts. The field that the script will need to be linked to is the ETR field (estimated time of return). Am using FMP 11 Advanced on Win XP service pk3 PC. Regards schnook

I was wondering how to change the Send Campaign script in FileMaker Email Campaign Management program so that it sends the emails instead of freezing them on the desk top and I have manually push the send button for every email I am sending. Thank you.

Hi. During the course of the scripts throughout a session, I have quite a number of variables set to parse values between tables etc. Being the kind of programmer I am, I prefer to clean up after myself and remove and non-essential debris. Although variables wouldnt consume much RAM (especially given how much RAM computers have these days), but is there any way (or need to) remove a variable once it's job is done? Simple housekeeping really. Cheers, Greg

Hi all! I need your help. I'm working on a database that will help me create test ads. Each ad will have several variables to test (headline, tagline, price, etc.) so I am trying to create a script that will generate a record for each set of possible variables (which would be super-great it it actually plugged the variables in). I'm picturing a separate database for each of the variables, but maybe repeating fields would be better? Thanks in advance for your help!

In a FM database with the following fields: "insured_value" (number) "current_value" (number) … I want to create a script that will create a found set as follows: "insured_value" is not null. … and: "insured_value" ≠ "current_value" -- Using OMIT with: Enter find mode insured_value = … finds all records with a non-NULL value for field "insured_value", which is what I want. Next, Find requests do not appear to allow the value of a field as part of the criteria, i.e., "insured_value" "≠ main::main_current_value" does not work. Do I need to create a global calculation field that calculates if "insured_value" = …

Hello Can someone tell me whether it is possible to change the name of an output file by setting the filename as a variable. I would like to have a date in the output file name. I have tried setting a variable called $filename which has the value Getdate, and then using that as the filename in the filepath but it just calls the output file the name of the variable. ie $filename Any help greatly appreciated

Hi Guys, Sorry if there is a simple answer to this one... I have a portal which looks up table 'accom' where the user can edit fields and add a new row . Each row has a further info link which opens a new window and goes to a layout for 'accom'. However when this new window opens I get an error saying this record is already being edited in another layout. So I know I have to commit the record before I can then go to related. When I add this step in however it won't navigate to the selected record it will only got to the first record in 'accom'. So I looked this online and the best option seems to be storing the portal row number in a variable and the…

Which record becomes the current record after a 'Go to layout' script step? So far it seems to return to the last record I was working on, but I can't find a place that clearly confirms that. For background, what I'm doing: I'm trying to connect people to organizations through an 'ORG CONTACTS' link table. While on the organization layout, they click a button to add a contact person - copy [select; ORGANIZATION:Org Name] Go to Layout ["ORG CONTACTS"(ORG CONTACTS)] New Record/Request Go to Field [ORG CONTACTS: Org Name] Paste[select] Go to Layout["CONTACTS"(CONTACTS)] Enter Find Mode[Pause] Perform Find[] Copy[select; CONTACTS::Contact ID] Go…

I am using a bar code scanner to enter number into Account field. I need a conditional script to enter the date into field "Adate" after the bar code scanner enters the acconunt number into the "Account" field and t6hen create a then create a new record. The new record has to be there so the bar code scanner has a new field to input into. The only way I can think of to do this is a conditional script. I keep having issues with any script I write. Any Ideas? Thabks a milllon!

I have a script that attempts to set a global variable to the value of the fields current cursor position via an OnObjectEneter and OnObjectKeyStroke script trigger. The global variable is set with the Get ( ActiveSelectionStart ) function in a one line script using Set Variable script step. I am getting problems arising that I do not understand the root of. When entering the empty field the variable returns 1, which is ok, then after entering one character the variable still returns 1. Furthermore if I move the cursor back a position the variable returns 2 when the cursor is position 1.

I have a script that uses The "replace content field" step to blank out a field content in a large database. Sometimes the replace content step takes a long time when records reach several thousands... Does anyone know a more efficient way to blank-out the content of a field in a large database? Thks

I am trying to do a simple script where I am increasing my global field + 1 for a series of looping steps but everywhere I look to add this it keeps telling me it needs to be a text field. Can I not add to a number field via a script? I know this is Filemaker 101 but any help would be appreciated. Thanks, -al

I have a script step : Open URL ("//121.44.25.227/Inventory.fp7?script=OpenInventory") It was working fine the other day. Now if using FM 11 it opens Safari and I get this response: "The requested URL /121.44.25.227/Inventory.fp7 was not found on this server." If using FM Go it, says "Loading Web Page..." for a long while then: " Failed to open "http:////121.44.25.227/Inventory.fp7?script=OpenInventory" Was there a change in how to open a served file with a script step or what am I missing. I can open the remote files in FM 11, and FM Go using the open remote file menu choices. Anyone know what is going on? Thanks

Hi All, I have a simple DB with contacts and insurance contracts that have an ending date. What I would like to do is to trigger a search that will look at the ending dates and give me an alert for the latter minus 30 days. Example: John Hardy's Contract ends on January 15th 2011. I would like to have it appear as a result of my search so I can send him his new contract. That's the general idea. A simple and clear script would be nice. Could somebody help please. Thanks

I have a basic script to display a layout with a related record. Currently i have the existing window used to display the related record. Then the use clicks on a button to navigate back to the original layout. However, i want to change this to display the related record only in a new window instead, then simply close the new window when done, and therefore be back at the original layout again. I change the GTRR script by selecting New Window. But for some reason the original layout, which i have set to Maximised, changes size to a smaller window next to the new window. How can i simply have the new window displayed on top of the existing window, withou…

Is it possible to find out what the next serial number in an auto-enter serial field would be - via script? Is it also possible to change the "next value" via script? Either increment, decrement, or explicitly set ? Many thanks, FM gurus!

I am creating a script to Close a file. I originally set the button to Exit the Application, but found in the instance that a use had more than one file opened, they were all closed. Is there a way to say : IF(.fp7 Files Opened =1;Exit Application Else Close Current File Only ?

Having set a variable in one database - using the $$ - is it possible to write a script that will place that variable in a filed in another database?

Hi - Scripting an import of an excel file with a number of worksheets. Is there any way to preselect the worksheet name? thanks - I'm using a variable for the file name.

Hiya All, Heres my problem. I have a list view for Orders: I have 9 collums. i would like two drop down boxes at the top. and when changed the i would like the following to happen: 1st box called EN_FILTER_STRING (global text) 2nd box called EN_FILTER_STRING_Status (global text) if a value is selected from the first box then only vaules with that data fronm the "Stage" collum is shown if a value is selected from the second box then only vaules with that data fronm the "Status" collum is shown Example 1st box ADMIN is selected then the list only shows the data with ADMIN in the Stage collum if the 2nd box is changed to OPEN then only dat…

Hi everyone, I am in the middle migrating a flat file database to filemaker pro and have run into a little problem. I have imported all the records into filemaker pro 11 and now I am need to move the contents of several fields to a child table. The old database only allowed for three phone numbers, and had fields for each number and its extension, like so: Phone1 Extension1 Phone2 Extension2 Phone3 Extension3 I need to move each phone number to a new record in related child table that has fields for: area code, number, and extension. There are about 10000 records so I really want to automate the process with a script, but I am not having m…

I have a script that changes to a "find" layout. If the find is performed the script works fine. However, if the user inadvertently runs the script and then does not perform a find but instead runs a different script, the script is stuck in the paused condition, requiring the user to click either Continue or Cancel. Is there a way to make the script end if it is interrupted in the middle? Here is the script I am using: Go to Layout ["Find Records"(STATS)] View As [View as Form] Set Zoom Level [150%] Enter Find Mode [Pause] Perform Find [] Go to Layout ["Tabbed Form"(STATS)] View As [View as Table] Set Zoom Level [100%] Thank you, Kevin

I have a field in a layout that has validation set to "Not Empty". On the same layout I have a field with a script trigger to run a script on modification. The script goes to another layout and deletes all related records in order to replace them with the new selection. Now, when a user triggers the script before populating the field with the validation the script proceeds to delete all records without leaving the current layout. Not a good thing. I remember seeing somewhere that a script can be set to bypass validation. Is this correct and how would I set it? Thanks

I'm looking for a formula which will convert seconds (e.g. 128 seconds) to minutes (2:08).

Hi. Not sure if this is a scripting, network or impossible question... Is there any way for a user (who is also network administrator) to set the value of a global field on a computer other than her own?

Hey guys, I have a complicated script which has several steps. It involves importing data from an excel sheet to a table and then distributing that data into 2 other tables within the database. To achieve this I use global variables to carry over the data from script to script. It all works fine. Except for some reason, if I try and run the script twice in a row, the second time the script gets stuck half-way. However if I close the file, reopen and try then, it works fine. So i'm guessing there's a conflict of some kind with the global variables. Is there a way I can reset all variables once the script has run? As if I had closed the file and started …

Whats the best way to change content of a field in all records found? Would you use find and replace... or some other way? Jay.

Does any one know how to make a script trigger work with a container field and script? I have a container field that works as a checkbox -- images other than standard x. But when I assign the script trigger to the checkbox cell (Container field) nothing happens.... Help... Thank you

I’ve got a multi file/Multi server deployment and a Server side scripting question. If you execute the script (ref attachment) via a server side schedule on the CT server FMS shows the script completed BUT.. the execution time was only 26 seconds and the data does not show up in the destination table as expected. None of the script steps show as client only, or hardware/network issues that would have abnormally terminated the script. Their were no backups running on the CA server at the time the sss was triggered.. Nearest thing I can figure is it’s a permissions issue… the script is set to run with username bob password 111111. The files on the CT server all have bob/111…

Can't thank everyone enough for the help I'm getting. Made major progress this past weekend on a project I have, in no small part due to the help I've received. So thank you! My current issue is the following: I have a table with a field called dateSent. No big surprise, this is a date field. What I am trying to do is the following: If the dateSent field is empty, I want it to display "Has never been sent". If, however, the dateSent has a date it in, I would like it to display the date. Any idea on this? I have a feeling it is some sort of calculation field, perhaps with the IsEmpty... but all searching I've done isn't coming up with the corr…

dear all I am a novice FileMaker user and am having some difficulty with a more complex (for me, anyhow!) database I am working on. So far I have two layouts. One layout displays records from one table and the other from another table. I have a 'Find' button on layout 'A' that needs to take a value from a field and perform a search using that value and display the records it finds from layout 'B'. I thought I would be able to achieve this by setting a variable and then performing a search using this variable as the search data. I can't seem to get it to work. Here is my script that I'm trying: Set variable [$findupn; Value:Students::UPN] Go to layout ["…

Hi All, I'm a bit of a newbie. Here's my problem... I have a one to many relationship between 2 tables, client and clients invoices. There is an 'invoice type' field in the invoices table with drop down choices of 'Deposit' or 'Remainder'. I also have a 'paid in full?' field with a drop down "yes / no" value list in the invoices table. In the client table I have a 'deposit paid?' and 'Remainder paid?' fields both on a 'yes / no' value list What I am trying to do is make an If statement script that says, If the invoice type is 'Deposit' then copy the 'paid in full' and paste it into the deposit paid field in the client table. This i…

I want to produce a field which is based upon another dependent field and whether another field which defines a format is equal to various different capacities. Example: Record 1: Product A: Bottle price field contains $100 The format field contains "Bottle" Thus the price per bottle (the new field I want to find - bottle_price_converted) is $100 (see calculation below). Record 2: Product B: Bottle price field contains $50 The format field contains "Magnum" Thus the price per bottle (the new field I want to find- bottle_price_converted) is $50 (see calculation below). Case(Field::Bottle size = "Bottle";Field::bottle_price_converted = Field::Bottle…

I am New trying to learn FileMaker. I am trying to write a script that will list calls for a particular shift on a particular day. Shifts are 24 hours long and run from 7:00 to 7:00 (6:59). I have a menu option with a drop down calendar where the user would select a date and then click a get button. Here I am trying to run a script that will perform a find and display all records for that day and shift. I have been trying to use two variables $$StartShift and $$EndShift. $$StartShift = DateEntrered, 07:00:00 $$EndShift= DateEntrered+1, 06:59:59 The script then tries to run a find on CreateDate with $$StartShift…$$EndShift I can’t get it to work?? Any id…

Hi. I just encountered a very strange problem. I am modifying layouts and scripts for a client who has an FMS server on their site. Whilst I experience the expected delays in operating over the Internet, over the last few days for some reason the script editing is really painful, yet the layout stuff still operates normally. A number of scripts are more than a page long and will take more than a second to render each line on my screen, often taking several minutes when things are really bad. Client at his end has no speed issues at all. I tried hosting the file on another server (also remote to me) with the same result, even though its a fast host and link.…

Is there a way to have more than 3 choices in Custom Dialog? I can use buttons, but only 3 choices are allowed. Is there a way to use a drop down picklist? Thank you, Fed

Hello, Is there a way to show the field borders (or one of the four field borders..top, bottom, right, left) based on a condition? For instance: If value > 100 then show field borders (or bottom field border) I've seen this done in an Adobe Acrobat form, but am not seeing the appropriate FileMaker command. Thanks.

I am trying to search for a group of notes within a certain date range. I am using two global field that the user can enter the desired start date and end date. The date field for each note is an autocreated timestamp with the current date and time with 24 hour notation. In my script I am trying to set two variables for my search. The first is $Start equal to startdate. and the second one is $End equal to enddate. The problem is that it will not let me use these variables in my search my perform find requests. It keeps asking me to use a field that is equal to a timestamp. How can I set variables equal to global field timestamp values and use them in a date range search? …

Hello guys, I am a noob in Filemaker and I am doing a simple accounting program. It works fine locally but whenever I turn on network sharing and go to another computer to test it the new record getting script which should give new number each time just doesn't work (it works fine locally though) and another thing it asks for some kind of confirmation on the left and I really don't know whats going on. I am attaching a screen shot for your reference. There might be some sort of common reason that the script I am using is just not working in network environment. I am stuck here. Any help will be appreciated. Here is a screenshot of the script: If you …

I have a file that for contact management. I can create note for each contact and they display in chronological order in a portal. I would like to create a script that will open a window and show a report for all notes made within a certain date range. I would like the list to be grouped by contact. So for example if I clicked a button, a script would run that would open a window and allow me to set a start date and an end date and then a list would appear with the applicable contacts and any notes that were written for those contacts between the selected dates for them under each contact name. How do I go about doing this? Thanks for all the help! Erik

Hello all! So currently I am able to use the 'Send Mail' via SMTP server to send an email. However, what I'd really like to do is the following: The user clicks a button, which triggers current script. The function of the script would be as follows: The current record the user is on would be attached as a PDF and mailed as an attachment to the location as detailed in the send mail script. The issue is making it so there are no popups. I want the user to be able to click the box, and all this happens without a single popup box. The 'Send Mail' trigger allows an 'attach file' option, but I can't find a way to have current record saved as pdf and au…

I have an excel file to import into FM. It has many duplicates, but they are different records. I need to assign an same Customer ID to all of the duplicates with the same name. Jack = Customer ID 1 Jack = Customer ID 1 Jim = Customer ID 2 Bob = Customer ID 3 Bob = Customer ID 3 Billy = Customer ID 4 Jack = Customer ID 1 When they created the excel file they did not create a customer ID. There are over 10000 rows in this file and about 700 customers total. Can this be done easily? I can not get any script I make to loop through correctly. CPE1704TKS

I have created a script that saves 3 layouts to a single pdf file by appending them. I just can not find a way to print the file after it has been saved. I know I can open it in a pdf reader and then print it but I want to bypass this step. I also want to save the pdf to the desktop and also a network location. Right now I have it save to a temp location. Here is the script. I sure someone can help me to make it better. # Set Error Capture [ On ] # Allow User Abort [ On ] # Set Variable [ $path; Value:"file:temp.pdf" ] # New Window [ ] # Go to Layout [ “Kit Consegna” (Modulo Contratto) ] # Save Records as PDF [ File Name: “$path”; Current record ] # Close…

So I've tried about every permutation of SSL / TTL and ports that I can think of... even tried the automated script that I found on the forums. Despite this I can not, for the life of me, get a script trigger that sends a record via email (SMTP) using gmail to work. Is this just not an option? The from field is a single word, etc... If anyone has this working, could you please enlighten me? Thank you!

I have been working with Filemaker for a while, since ver 5.5, but recently upgraded to a version with Script Triggers. I hoping that someone more familiar with them can help me understand something. I have two linked files, one with the data & one with the layouts. In the Layouts file, I have a "OnRecordLoad" script which performs as expected. The problem is when working with the Data file, it runs when changing records there as well. I guess I could just disable the script in the Layouts file, but with multiple tables it is easy to forget to re-enable it. Is this normal for Script Triggers to function this way? Thanks, Bill

Hi All I'm a bit of a newbie but can't work out why a simple find step in my script isn't producing correct result. Here is the set up: I have a field called 'Month' which has the values 01 for January, 02 for February etc. I want a script that will pull up all records that are say January & February. So I have a step in my script which is Perform Find, and have specified a find request to find when 'Month' has range 01...02. But when I run this script, I get records from other months as well. The weird thing is, if I enter find mode and do a manual search for those records (01...02) it works fine. What am I missing? Kind regards Peter

I am trying to trigger a script when the user changes from Print Preview Mode back to Browse Mode, but have been unable to have the assigned script run. Is this possible? What option do i use if it is? I want the script to: Show All Records; Sort Records[Customer];Scoll Window[Home] and Show/Hide Status Area[show] when exiting the Print Preview Mode.

I am new to scripting; so I am asking for help with this to allow me to study the logic and try to understand it. I have records in a field "course". These have been imported from an SQL database and has resulted in values from 1-5 in this field. I want to create another field in which these values are interpreted and displayed as "First Year 310"; Second Year 412" etc. What's the easiest way to do this? Case? A value list? I have been trying but not getting too far. Thanks very much for your time. pk

i have a layout with a tab control set. some fields show up in all tabs. in a script, i use 'go to field', but i'd like to stay on the currently active tab. but when the script executes, it always switches to the first tab and goes to the field there instead of just staying where it is. probably something simple (?). thanks, stefan

How would I make a script for this? If ( Table:Field = (empty); continue with script ; display message "Serial has already been used" ) I'm trying to make this part of a button. I'm using it for an invoice. The button adds items to the invoice. I don't want it to add the item if its already been shipped before. I'm able to do everything except the if statement to make it stop if there is already a date in the field.

Hey guys, I have a problem with my script. What i want that the script does is that if there is no internet connection, the script must not go further to set the field to "ja". i have made this script but its not working good. Can someone help me? for a script when internet is available that the script need to stop but when there is internet to send email and set the field to "ja" Here the screenshot

I have an accounts (income-expenses) table in a separate database. Can I script moving data via a $$variable into that outside table? I see where I can Open File but it seems the script can't go to a layout outside its own database. I could hit the keys again and type the data into that outside table, but I'd love to script it.

Classes::field1 = "Wed1" Classes::field2 = "Eve" Classes::field3 = "Sailing 101" I want to build a variable from two fields in one table: Set Variable[$twofields; Value:Classes::field1 + Value:Classes::field2] And then use this variable to identify a field in another table called Schedules. In the above example I'd have identified a field in the second table called Schedules::Wed1Eve. So that I can put Classes:field3 ("Sailing 101") into Schedules::Wed1Eve

Hi, Is there a way to obtain any number of words e.g. 3, 4, 5 or 6 say which are to the left of an opening bracket ( or alternatively to the left of a 1,2,3 or 4-digit number/ Thx. For example: Green large t-shirt (some text here) to obtain: Green large t-shirt or Green large t-shirt 234 to obtain: Green large t-shirt Since there might be any number of words before the bracket is there a way to look for the start of the bracket and just keep the words to the left of it?

I have written a solution for a therapy practice. The opening script uses the "Show Custom Dialog" script step to give the user feedback about which plugin's are functioning. It contains more information then can fit in the default size of the dialog box. Is there a way to set the size of this box so that a new user can see all the information without having to manually resize the box? I am using FM 11 advanced

I have a field which contains the data imported and which I wish to breakdown. One of the elements I wish to extract is a four digit no for the year, and then post this to another field. e.g. Charmes Chambertin, Tres Vieilles Vignes 1999 (12) I need '1999' to post to another field. The no. of words before the year changes - can be 1, 2, 3, 4 or as here 5. There is always a number after this in brackets, as here e.g. '(12)'. Perhaps that helps? Any help much appreciated> Thank you.

Hi, I'm new to filemaker and i need some help please. how can i use "," as delimiter so that I can get records each containing a string. ie: ab, bc, cd .... result : ab bc cd ... Thank you !

In Excel I can click data in a field and, once selected, I have the option to drag in whichever direction I like, and Excel enters/copies the data if I've selected one "box" or, if two boxes are selected and are in order (say "21,22..."), it will number the drag for me in order ("...23,24,25,26) etc. Is there a way to do this in FMPro? I'm sure it's something easy that I'm just blind to. But it gets annoying when I have 40 or 50 blanks fields that need the same data entered and I can't duplicate it easily, forcing me to go field by field to enter the same number or letter.

Hi, i need an approach to solve this: i have one table containing 100 fields representing bookable beds in a hostel. These fields are part of an occupation layout showing us which beds are free etc. I have created a 2nd table containing the same fields (name wise) working as "switches" to mark beds to be shown as occupied- these fields are automatically filled with an particular string. The required step is to copy this string from all fields in table 2 containing it to the corresponding fields in table1. This must be done for as many datasets as days are booked. The start date and end date data is to be taken from another table. I hope this is more or less…

I am trying to find a list of FMP error codes somewhere that I can import into my database for quick reference for an IWP application. Does anybody know of one?

I sure hope this is not a dumb question. I am wanting to run a script every night. This script will basically clean out the tables of data that didn't get used that day. I can write the script with no problem I just don't know how to get it to launch. How do I accomplish this? I Have Filemaker 11 Advanced Server on the main machine. Thanks Thom

I have been using FileMaker since 4.0, but have not used portals. How can I find the active portal row and paste it into a global field on the local database?

Field: "Date Collected start" I'm working with 100 year old specimens in a museum and, upon getting this job, found that the database created for updating and digitizing the collection had the date entered, for roughly 3,000 specimens, incorrectly. In the above field, the date is entered as follows: 1893-10-21 or YEAR-MO-DA I've created a new column named "Date" and need to change all 3,000 to a format that is either: "yyyy/mm/dd" (1975/01/23) or "dd/Mon/yyyy" (23/Jan/1975) I can do a find/replace (I believe) to change the spacer from a "-" to a "/". the "Date" field doesn't have to be rigid in that I change the Field Type to "date". I jus…

I am trying for field contents to trigger a script. Status = "Active" (by default) Field Served is changed by user to "Complete". This updates Active to "Complete". When Status = "Complete" I want to run a script. thanks, Jim

I'm trying to populate a global key field with a list of values. The global key field - when populated - will, in turn, populate a portal. I am passing parameters when the script is activated (clicking a button in a portal). I am passing two parameters: 1. Source field: the name of a field in a related table which has the values. 2. Target field: the name of the global key field to be populated. I am passing these as strings, not the field content. Once in the script, I declare these parameters as variables: $_sourceField $_targetField The parameters pass fine and the variables are properly set with the names of the fields. Sin…

Hello all, I am somewhat new to FM, but I do have intermediate database experience. I am currently using FM10 to implement a simple invoicing solution. My question is: what would be the best way to preserve an invoice's related client data once the invoice is closed (billed, archived)? For example, if the client's address changes, I'd like to keep a record of where that client was located when the invoice was issued. I guess this might be a broader data archiving design question, but for a very simple system, what would you do? I guess there is some sort of industry standard way of doing this? I am thinking of two solutions : A) keep all client records…

I'm trying to send a series of emails. Each email has a different .mp3 file attached to the email ... each .mp3 is referenced to a container field (Insert QuickTime) ... one container field per record. Is there a way to do an email file attachment using a calculation? It seems like the "Send Mail" script step only allows one specific file to be attached to all the emails.

How to take this format: 183|1,191|4,144|7...etc in a field, and create a new record for each set as follows ID Qty 183 1 (first record created) 191 4 (2nd record) 144 7 (3rd record) etc. Thanks!

Hi there, I'm trying to avoid writing multiple scripts to do the same functions for different tables...and I've run into an issue with trying to use a variable table name in my script. I'm setting the table name in a global variable in a script parameter, then in my script I run into problems with this: Set Variable [$mediaID; Value:GetFieldName($$MEDIA_table and "::MEDIA_ID")] the resulting variable $mediaID = '?' Unfortunately the table name that I need is not the current layout table or I could use Get(LayoutTableName). Does anyone have any suggestions for me? I've been banging my head on it for a bit now... Thanks rori

Smart People, Although the FM manual infers that OnObjectModify works with dragging and dropping into a Web Viewer, it does not. Feature? Bug? Workaround? Thanks, Peter

Well, I _thought_ it would be easy... Please refer to the attached. What I want to do is change all the lower-case letters to upper-case ones in a field throughout all the records in a solution. When I run the script I get a message that says, "The Find/Replace option "Current field" requires a selected field." I then have to click/dismiss that message 26 times. I wonder why! So, what am I missing here? I told FMP to go to a field, do its thing, and it doesn't. The nerve! The only thing I'm sure of it's that it's a definite PEBCAK* problem. [color:red]*blush* TIA for your help! *Problem Exists Between Chair and Keyboard just_in_case.pdf