Script Workspace and Script Triggers

What's the best tool for analysis of an FMP7 and above solution? The DDR is clearly limited, and Documentor, because it depends on the DDR, shares those limitations. Back in the days of FMP6 and before MetaDataMagic was an excellent tool, but after all these years New Millennium hasn't moved that product forward. Here are some of the problems I'd like to analyse. 1. Which scripts and calculations are using a particular Custom Function? 2. Likewise with Layout Named Objects, Value Lists, Layouts, Scripts, TOs and much else. 3. Are there any calculations and scripts with unknown tables and fields, and if so where? 4. What tables and/or TOs aren't being used…

I've done work with databases in a Web environment, manipulating them with SQL through PHP and Ruby... But I seem unable to get a handle on how FileMaker works. I can't seem to do regularly simple and logical tasks with FileMaker... Using a button, I would like to take a field from the most recent record in another table into a field in the last row of a portal. I've been working on this simple task for over a week, and it has frustrated me, and I have gotten no where. This is for a kids program that has weekly programs (and has for years) and we keep track of the kids and their attendance... In the file they have now, they have 5 years of data based on a single…

i was given a batch of 9,000 or so records for reporting purposes. there's a script that was already made so i can query for a specific date & area from the records. It worked fine.. But when I imported about 500 new records in CSV format - the script won't recognize them. What am I doing wrong? I'm able to view/browse the new records. Everything seems to be fine.

Set Field[_work_order::t_technician; Account::At_User_Name] When creating a new record I have this script step and it doesn't put anything in the t_technician field. I want it so when creating a new record it takes the user name form the account table and put it into the technician field in the work order table. Any ideas?

Hi, I wrote this little script to delete accidently created records on exit. [color:green]If [ ServiceHistory::Serial Number = "()" and ServiceHistory::ServiceDate = "()" ] Delete Record/Request Close Window [ Current Window ] Else If [ ServiceHistory::Serial Number ≠ "()" and ServiceHistory::ServiceDate ≠ "()" ] Close Window [ Current Window ] End If Refresh Window What is wrong with this script? Thanks for the help Toby

Good afternoon all! Well I work at a small newspaper, and we run a pretty simple process here. We input data we receive from the courts and input them into "template" filemaker files. We then import these template files into the main database for our internal use. The internal DBs hold all data and also perform several scripted procedures. We need to export "todays" new records to the specific web db, we also need to export the new records for print. We accomplish the print export by exporting the records to text, then use a ms word merge doc to finish up the editing. These files have been working great until the last month or so. Now we are having issues with "…

Hey everybody, first post here. I'm brand new to scripting in Filemaker, as I've been mostly using its xml web publishing feature for Flash backend communications. What Im trying to figure is how to make a script that does the following: There is a table called 'Sessions' that contains the records to be used. There is a field called 'sesID' that contains a unique identifier for each record. There is also a field called 'criID', which is a 8 digit number assigned to each of my clients. When each record is created, there is a timestamp field that auto-enters on creation. This database is designed to track when users log into our system (a piece of sof…

From within file maker I am trying to launch an external windows .exe file. I have tried many different combinations of syntax, spacing and coding but cannot get the file to launch with the correct command-line option. Please do not be confused by the URL, I am not trying to launch a webpage. I am trying to launch the below. What is the best script step to make this happen, and what would be the exact syntax. Thanks for your assistance.

I want to create a backup script, and now the one below loops continuously until the esc button is clicked. I want the script to save each time the database is opened. Clear[select] Save a Copy as["Expense Report.fp5 Copy.fp7";copy] Perform Script["Backup"] What does the script need to produce a reminder to backup to external media in a dialog box each time the database is closed? What kind of script allows the backup to occur for multi users? Thank you

I have a script which saves a PDF to a predetermined folder on the server - attaches it via email then copies the PDF to a folder of the users choice (selected using apple script - "choose folder with prompt…"). Works ok except the time it takes to save across a remote network. So if i could reverse the save order, creating the PDF to the users choice folder first and make the save back to the server later in the background it would all be much smoother. But I am not sure how the mail script step can find the users selected folder and can I make the copy process in the background and not hold up filemaker. Thanks hope that makes sense.

Hi All! OK here is my dilemma... 1. have a project database and would like to have the form fill in work like this: Once the client number is typed it the client name field will automatically populate with the corresponding client name. 2. Also need to do simple (not simple to me, lol) reporting based on ONE of the fields. For "Job Status" the report should only show items that are "Open" I would also like it to have a header for each client. i.e.: John Doe Foods Project 1 Project 2 Jane Doe Foods Project 1 Project 2 Can anyone here offer assistance? I already have a basic report set up but Im having problem…

I'm well aware of the need to Commit Records in FMP9 after a scripted routine which creates new records and sets fields within those records. However, I've come across a situation where, despite that command being made both immediately after setting fields, and again also at the very end of the scripted routine, the new records don't make their appearance in the expected portal, nor in another layout which is specifically for the table that should be for those records. However, if I quit the file or FMP and relaunch, then the fields are there exactly where they should be without any further action. If you're with me so far, then let me spell out some more of the spec…

Is there a way to dynamically set the height of the field? I am trying to concatenate contents of multiple fields text fields into one. As the contents of individual fields are not known, I am wondering if there is a way to dynamically set the height of the concatenated field ? Thanks for your help...

I have just upgraded to Filemaker Pro 9, mainly because of the "append to .pdf" feature. However, I can't seem to be able to figure out how to append the reports in the order I'd like. I have several tables, all with the PAYEE in common. One is a Cover Letter, one is a report on Product Sales, one is a report on Digital Sales, etc (some of the reports are multiple pages for each payee). How would I write a script that would sort them by PAYEE... Cover Letter, then Product report, then Digital report, then the next PAYEE, and so on, instead of just all of the cover letters, then all of the reports, one by one? I sure hope I'm making sense here! : I'd appreciate any help!

Hi all, I have an issue with my script in its earliest stages. I go to related records and try to loop through them to simply display the values in a dialog box (with the intention of actually doing something with the fields later). After the first related record, the loop continues on the original layout instead of the next related record. In one instance, there are 4 related records and I can see them returned correctly in the other window but the last 3 are ignored. I have to hit esc multiple times to stop the script and I am returned to the original layout somewhere in the middle of the foundset instead of the record I executed the script on. Please see atta…

I have found 4 records, for each record I want to copy a couple fields and put them into another layout. What script elements/calculations do I use to tell it foreach record found do this..... I think I can handle the set variable, go to new layout, set field to variable. I just don’t know how to do this for each record found. Consider me a newbie. Thanks in advance.

Hi, Is there a way to replace an element in a list by using it's index? Let say a function such as ReplaceAtIndex(list; index; theNewValue)? If not how would you work around this problem? I want to replace numerical values in a list that contain bins to create a column graph.

Ok. I know this is a rookie question... Is there a script step that just saves the record? I couldn't find one. Someone is creating new sales order number, and then not filling in data, and somehow the sales order number is not saved. So I would like to automatically save it when the order is created. My current solution, in order to save, I have the script that goes to the data entry screen, creates a new record, goes to the main menu, then back to the data entry screen. Does that sound right? or does someone have a better solution. Thanks.

I am trying to analyze a FMPro 3 application for redevelopment. I have no experience in FM (any version). In one particular layout (Search Records) if the user selects the Enter key on the keyboard a search of the data is performed using the search criteria entered on the screen. My question is how can I find out what script (if any) is run/called once the Enter key has been selected? Basically what I am looking for is the "code behind". Many thanks in advance!

Hello: I’m trying to Configure a container field to accept a file path to a jpeg from a text field, and then to display it as a picture in the container box. I have been able to get the container field accept a path through a calculated value using GetAsText (FieldName), and to display the jpeg as a file (which can be opened or exported), but it will not display as an inserted picture. Ultimately I need to automate the insertion of pictures via database generated file paths. Exmp: file:/Macintosh HD/Users/jon/Desktop/Shapes/pic3.jpg is entered in “field_1” pic3.jpg displays as a lovely little picture in container field “field_2” – provided of course that t…

I accidentally put a Close Window script step in my Open Script, and now my database immediately closes when it is opened. Am I screwed, or is there a way to have my file ignore the Open Script? Thanks for any help.

Hi I'm fairly new to filemaker pro. I need to have a field auto complete when another is filled. I have a field that has status and a drop down list. And another which is a ticket number. I want filemaker pro to create a ticker number when status is filled in, but filled in with the words complete. Thank to who ever can help me. Here's a link to my file if I confused you a little. http://storage.leo712.com/ex.fp7

Hello guys, I feel quite silly to ask that but I can't figure out what is wrong with my script. I'm defining a field and the calculation looks like: Case ( Procedure::Stato = "E" and Procedure::Data Scadenza ≤ Get(DataCorrente) + 30; "In scadenza"; Procedure::Stato= "E" and Procedure::Data Scadenza < Get(DataCorrente); "Scadute"; Procedure::Stato= "E"; "Effettive"; Procedure::Stato= "O"; "Obsolete"; ) The first 2 cases don't work. How can I define multiple clauses? MANY THANKS

I need help figuring out how to constrain a found set based on if one field is within 10% above or below the number in a different field. For instance field one has a value of .75 and field two has the value of 1.25, so being outside the range of 10%, it would fall in the constrained found set. Same would be true if the numbers in the fields were flipped. Any suggestions? Thanks

Is there any way to trap the user's 'OK' or 'Cancel' input. I need to perform different housekeeping routines before exiting from a script that allows the user to edit records, depending on whether the user hits OK or Cancel, so I want the script to continue after the Pause/Resume script [indefinitey] script step. Hitting OK allows this to happen, but if the user hits cancel it exits all scripts and bypasses the houskeepine routines. I need to trap the Cancel in some way therefore, so that I can over-ride it and route the script appropriately. I'm new to filemaker, but have long experience of Omnis which provides a numerous event trapping options for dealing wit…

Hi I'm a beginner and would like a script to create a number of blank records based on a number inputted to global field. I've tried but can't get it - please help - ty

I have a script that performs a find then exports the records then does other things. The problem is if there are no records to be found it stops the rest of the script and displays a dialogue box that says “No records match this set of find request” If it finds nothing then I want it to find nothing and export nothing and move on to the next step. Not stop the script. How can I over come this?

Hi All, I have spent most of today working on a file but I may have killed it! I suspect that I have added a "Close Window" script step that is also the same script that is set to run when opening the file. So there is a millisecond flash of the window, but now enough time to display any buttons to overide it. Is there anything I can do to recover it? Thanks in advance Andrew Turney

I have a simple script to duplicate the current record. But, the record is not duplicated. No error is shown, even with error capturing off. But if I debug, I see it is returning error 3 - “Command is unavailable (for example, wrong operating system, wrong mode, etc.) “. If I use the duplicate record in the menu, it works fine. Also, the script steps works fine in other files, just not this one.. I have full access rights to the file. Any ideas ?

Hi! I want to script inserting file into a container. I use the "set field" script step, specifying the container as the target and this as the data "filemac:/paht/to/my/file/myfilename.txt" The icon of the file appears in the container field as though I added it thru the insert file menu, however when I click on the file icon in the container, i get the following error message: "The file (filename) could not be found and is required to complete this operation". If I add the file manually from the same directory, it works. What am I doing wrong? Thanks Manuel

Hello! Q: I have in my script to select the correct window, but it does not bring it to the front. How can I bring a window to front? THANKS FOR ANY HELP! MORE INFO: I have a layout w/ portal. I have a script that when you click on portal line, it will open new window. In this script, user Abort is off, and ends with script pause/resume indefinitely. This keeps user from navigating to another window and or closing window. This all works fine. But the new window also has a portal with a script that will open a detailed window of line item. So at this point, there are three windows open. Problem is, if user is in the "third" window and clicks on the "f…

I have an FM7 file that includes a field called 'Settlement Letter Content". In this field users freely type a letter which starts with a salutation and then the main content: For example: "Dear John, Your account is now settled........" I want to be able to extract the "Dear John," part and add it to another field via a calculation. I am unsure how to extract/trim the content of the "Settlement Letter Content" field so it only takes the saluation. I appreciate any help.

I am trying to use a notes separator script in several different notes fields throughout the database. I would like to use If, Else If script to allow the script to be written only once. Here is what I've got. New to databases. Any help? If [FieldType ("Test.fp7" ; "Customer::Notes")] Go to Field [Layout::Notes] Else If [FieldType ("Test.fp7" ; "Service::Notes")] Go to Field [service::Notes] Set Selection [start Position: 0; End Position; 0] Insert Text [" "] Set Selection [start Position: 0; End Position; 0] Insert Calculated Result [misc. formula] End If Where does the Else fit in? I've tried various spots and just can't get it …

I am trying to automate our monthly reports. I have a script that is triggered on the first startup of any given month. I am using a field - utility:LastReportMonth (Example - January = 1, March = 3, ...) So, I was thinking that an easy way to perform a find within my script was to do the following: ... Enter Find Mode Set Field (AR_LineItemsPaymentDate;Utility::LastContractReportMonth & "/*/2008" Perform Find I have tried numerous ways of handling this, but I am always getting the (No valid criteria..." error. I have searched all over and am not seeing an easy solution to this. What am I doing wrong?

Hello all, I have some problem about encoding the subject of some email I'm sending through OL express or 2003 (I suppose with 2007 version too). If I put a character like the Euro currency symbol (€) in the body of my email, when I receive the email it is properly displayed, but the same entity is substitute by an annoying question mark (?) in the subject. Is there any solution to 'encode' the subject too? I use the filemaker sendmail function (not plugin or 3rd party software other than MS Outlook), filemaker pro and adv. 9 (v3) and outlook Express (win XP). Thank you!

Hi Everyone, I'm new to Filemaker so forgive the newish question. I'm just got a job in sales and that is the reason for my purchase of the FileMaker software. I have been playing with the software for the last few days but i'm stuck on 1 thing. I want to make a table below the contact information to track "communications" made with the client. I want to have a button that will allow me to "create a new communication". When I click on this button it will create a line with 3 boxes: #1. Time stamp(auto fill out) #2. Communication Type (Phone out, phone in, email out, email in, etc DROP DOWN BOX) #3. Notes box where I can type anything I want. …

Hi, Last week a client of my taxi solution phoned to say that she had made a boo-boo in entering some dates, and the machine was in a 'creating records' loop. Basically the story is this: When a driver is not going to be available to drive for a depot for a period of time, a record is created in the Holidays table for each shift and date that s/he will not be driving. So the user enters a start date and end date and the script starts a loop which creates two records for each date between the start and end date. She mistakenly swapped the start and end dates around and clicked the Start button. (I had unfortunately not yet updated her to the lates…

I have developed a business need to be able to conditionally format the active field on the fly. I have a database that has a list of manufacturing tasks. The field names in this database are: Task 1 Task 2 Task 3 Etc. There is an additional field that counts the number of workers that are available to perform these tasks. I would like to be able to change the colored fill pattern for any particular field based upon quantity of workers available. For example: If WORKER QUANTITY = 1, Task 2 = BLUE FILL If WORKER QUANTITY = 2, Task 2 = RED FILL I would like, however, to be able to accomplish these formatting decisions without g…

I'm trying to relate one record to another via scripts. Basic structure is: Posting Layout: - Show Records from Posting - show portal records from Project Posting ID My challenge is getting the Project ID into the Posting record field to allow the portal to work. The portal process is working, but only for the first Posting in the table. More on that later. I have button "Specify Project" the purpose of which is to link a Project with the Posting. The button opens a Select Project list which contains a button next to the desired project. That button performs a script which is supposed to update the Project ID in the Posting record with the Projec…

Anyone got any thoughts on the best approach on burning imported files to disc via a script. I am building cross platform but am happy to start with OS X first, I am thinking via… • Applescript or • iTunes or • Automator Any thoughts would be great. best Stuart

We've run across a Windows XP machine that seems to be the only machine that won't execute two specific set field steps. The script executes properly on a mac as well as a second Windows machine. It seems like the issue is specific to this one machine. Has anyone seen anything like this before? Any suggestions?

Like the subject says, is there a fix for this problem or I must use "gotourl"?

I want to create a assembly of records from multiple tables that can be stored and used anytime by pressing a button. Creating a button and executing the script is not the problem. I'm thinking I need to export the records to folder for import as needed. The problem is not exporting the data and having the data come back in but for it be assigned to the new ID. SIMPLIFIED SCENARIO: Table A is related to Table AA & AB. I would create in TABLE A the title of the "Assembly". Records from AA & AB would be the assembly. Any help or tips?

I'm at a loss. I've got a customer that is using one of our FM developed DBs and uses Lotus Notes for his email. We put in the email function that opens automatically the user's email. This person's e-mail setting (internet options>programs>email) is set to lotus notes, HOWEVER, each time he presses the email button in the FM DB, it pops up what I believe is an MS Outlook set-up wizard. It is asking to choose a profile name, or create a new which becomes a MS outlook wizard, VERSUS, opening up lotus notes. Any ideas?:? Thanks!

Hi All Have read the help files on creating filepaths, but no progress here. Setup: FM server running on Windows SBS network, with 9 Windows machines and a couple of Macs. Want to do: Save record as .pdf to the server from any workstation Working: Windows machines save the .pdf with the correctly calculated name (by a variable) in the correct place on the server according to the windows filepath. Not Working: Macs give the error "(filename).pdf could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk" I tried saving to the local Mac machine instead by adding a local filepath for th…

I am trying to figure out a way to test a record for modification. I have a record that contains perhaps 20 fields, including an auto enter Modification date timestamp field. What I wanted to be able to do was check the timestamp. If the record was modified from when they entered it, give them an option to save it or revert the changes to what existed when they got there. I can't seem to get it to tell me if the record was modified, or if it was, to be able to revert the record to what was there before the user entered the record. Is there an easy way to do this? Thanks, Mike

Hi I'm having problems attaching more than 1 file in a send mail script. My script saves 2 pdf's in to a folder on my HD titled: "IMP1.pdf" & "IMP_Report.pdf" then with in the send mail options I select: filemac:/Macintosh HD/Users/ftp_server/Scripts/IMP/IMP1.pdf filemac:/Macintosh HD/Users/ftp_server/Scripts/IMP/IMP_Report.pdf but when I receive the email I find only one PDF that is the one that's first. I have tried selecting each one separately and I receive them OK but when selecting together I can only receive one. Any ideas.

I'm looking for a way to insert a username and password into an email that is generated by a FileMaker script. We send out approx. 200 emails to clients, who each have their own usernames and passwords to access our website. We currently add the username and password manually but are looking for a way to insert a variable into a script that could process this dynamically. Has anyone had any experience with this before?

I know i can trigger a script from a menu item. Is there a way to trigger a menu item from a script from Filemaker without a plug-in. I assume I could do it with AppleScript, but i hate the ideal of scripting a application from within the application.

Hello All, I am a beginner for scripts, could someone help me to check what's wrong with my scripts. What I want to do is using loop to copy all the related records (Name, Qty, Unit) from "inquiry layout" to " Inquiry for supplier" layout when I click on Create inquiry for supplier bottom. My script only works on supplier 01 not supplier 02. When I click bottom on supplier 02, the related data will copy to supplier 01 again. I don't really what's wrong with it, could someone please help me. Thanks in advance. James Looping_sample.zip

Hi all, I've been trying for hours and I can't seem to figure out an easy way to do this. Here's the scenario: I need to figure out a way of testing to see if the related records of a found set of records have commonalities, and if so, what those commonalities are. In more specific terms, I have a found set of records from a table called Assets. An Asset can be related to one or more Projects (via a Usage table). In the course of a script, I need to test to see if my found set of Assets has at least one project that's common to the entire found set, and if so, the ID(s) of the Project(s). I've been working on this for a while and I just can't find a…

I have an issue with a script I'm running. If I absolutely have to I can go into detail about everything that the script is doing but I'm hoping I can get some direction from a simple explanation. When I run my script normally, which is an import records script (very over simplified description), there is consistently an anomalous extra blank record being created. However, when I run the script using debug scripts to watch and see where this extra record is coming from... it doesn't happen. This result is consistent. Every time I run the script extra records are created, but every time I try to debug the script (importing the same set of records) there is not an i…

Newbie here I want to input the zip code and have filemaker fill in the city and state. Do you have a script sample for me?

Hello. I'm trying to pass a large amount of data from one DB to another by using a script parameter. So far it's working fine in my testing, but I'm wondering if there's a limit to how large a script parameter can be. Does anyone know if there's a maximum number of characters? Thanks.

i am looking to make an image show up when select an item type. I have an image field and i have a model# field. I was wondering how i would make a script that would grab an image from a folder named the same as its model number so when you type in the model number the image shows up. Anyone know how this is done? I would love some help. Thanks in advance mattyj

I have a field option calculation on a F Name Field that strips out formating and adds title case. TextStyleAdd (TextStyleAdd ( F Name ;Plain) ; Titlecase ) (Do not replace - is not selected) Works great! Except when I do an email merge all the title case formating is lost. Many times the information in the field is placed there by a script parsing a web page. Would I be better off formating it within the set script on entry? Also assigning a field on a layout to be bold that contains the F Name field will not show in bold. Even if this is a field that joins the F Name and L Name fields.

Hi all I have a pretty good understanding on how filemaker works, I just cant get this script around my head. I have a script in which users fill out fields using the Show Custom dialog script. Initially the script ran as show custom dialog (title;please enter;field1) replace field contents (field1;current contents) This script ran fine up until recently where new exceptions are brought up. So far I came up with an IF nest for the exceptions but it does not seem to work. If(field1 = English) show custom dialog (title;please enter part number; field1) replace field contents (field1;"I cant figure out a calc that only replaces contents with on…

Hi. My script evaluates a large global text field for certain criteria. When the criteria are found, a new record is created using a value from the global text field related to those criteria. I only want one record for each value to be created even if the value repeats in the global text field. Furthermore, a record with that value may already exist from previous data used in the global text field and if found again in new data, a new record should not be created. i.e. if the value in the global text field has been encountered before (either in the current global text field or those that have been evaluated previously) then a new record should not be created. …

Hi. If I have a script that contains a Print Setup command, what information gets stored with this script step. The reason I ask is that I am having problems colour printing in a number of scripts and the common element is that the first print Setup script step has the printer driver defaulted to black and white, despite the subsequent Print command set to colour and the windows driver set to colour also. Does anyone know of a simple way of rectifying this? Or will I have to change every script step with a Print Setup command to Colour in the printer driver options?

When entering data in a form, is it possible to jump past fields based on the value entered in the field one is currently in? For example, if an employee is male and the next 5 fields pertain to a female, can a script be written that will skip to the 6th question when "male" is entered in the current field? Thanks in advance for any help!

Hello, this is a message reply from my tech re: problems we are having with this version of our Filemaker app trying to get a 9, to function using MS dialer... [color:red]See Dialer code attach My client has a PBX we need to access, to get an outside line that is not appearing to happen? Maybe someone here can help.. or been there.. Thanks Rod ----------------------------------------------------- Dialing the 9… I am reading all this… and it still looks to me, Sorry if I am wrong,,, the dialer code appears to be filtering the phone#? SEE CODE at end of doc Isn’t this canocial order? +1 (222) 444-1234…

I am womdering if it is possible (and how if it is) could I send text from a field to the Cellular phones of students. So many students have them that many have asked us to send them messages to their Cellular rather than their e-mail. Thank you.

Hi All I am new and very beginner with FM. I have been using Helix for years, but am forced to recreate my small business DB in FM because Helix is a "classic" app. What I need is a script that will insert the current date into a date field (date billed) on all records of the current found set. I have tried insert date, but it only inserts into the currently viewed record. I think that I need to use set field, but I can not get it to work. Please help and thank you in advance Brian Tacy Coco Tree Home Services Cape Coral, FL 33993 cocotreehomeservices.com

Hi. Newbie to the forums here... I have a database where I have two fields of data - let's call them field A and field B, and what I'd like to do is get Filemaker to automatically copy just the first 5 characters of field A and paste them to the start of the data in field B. E.g. Field A currently says '1234abcd' and field B says 'efgh' and what I want is for Filemaker to add the '1234' part to field B, so that it ends up saying 1234efgh Does anyone know how I do this? TIA!

Hello, this looks like a simple issue but since I'm a newbie scriptmaker I can't figure it out. I have a field that contains a string, the string is formed by a arbitrary number of letters followed by 3 digits, for instance ABC001, ABCDE123. What I need to do is to split it into 2 parts, the first one has to contain the letters and the second one the 3 digits. I'm trying using "right" function but I couldn't make it so far. Could you please let me know the best way to handle this kind of issues? THANKS and HAVE A NICE DAY!

..... why isn't there one? I know there's a button but I need a 1 click continue and go to.. etc.

I am trying to figure out how to restrict a field to a set amount of characters. I tried using the maximum number of character restriction but it still allows you to type more than I set, but it will not let you continue. I want the field not to let the user type more than the assign characters. Can anyone help

I'm prepping a FM 7 customer database for export to MySQL. I've created a password field and want to assign a temporary password for each record. I'd like to assign something like password1, password2, password3, etc, to each successive record. I can't figure out how to set up a script to keep the field text constant while adding a number incrementally.

Is it possible to go to a field based on the result of a calculation? For example, elsewhere in a script I may set a variable called $fieldName to the value of "Field6". Later in the script I want to go to that field and get the contents from it. Can I go to Field = $fieldName? I don't see this option anywhere, but it seems like something people would want to do pretty commonly. Is there a workaround?

Is there a way to create a batch of records based off a list: I have a list of "Current Student" names in one database related to "Student Name" in another. Currently the process I use is creating records one at a time, going down the list selecting each new student. Is there a way to create a record for the first student in the list, then create a new record for the second student in the list, then ..., to the last student in the list? It seems it should be entirely doable, but I can't find the right script step to step down that list. Thanks! Daniel

I have a simple script that copies data from one field into another. I'd like to apply this script to all of the records in the database. How can I make the script advance through each record?

Does anybody know a script which lets me exit a loop using a button???..... I have a loop already, I just need to stop it (but not get rid of it completely). I'm working on Filemaker Pro 9.

I would like to make a script that can send an email to the selection of records I get from using find. How does such a script look like? The e-mail script that is part of the template contact databases only sends email to the current record. I am aware of the email-function that lets me send email to the selected table (results from find), but I would like to make a button within the layout - to do this as easy as possible for the users of the database. This is probably a very easy script, but I´m not very familiar with FM at this point. It´s a brilliant program, I would have to say! Thank you so much for your help.

Hello, please excuse my question if it seems trivial. I'm new to filemaker and using scripts. I have a database where data is input into text fields . I have a vertical range of 10 text boxes, sometimes data is entered into 3 sometimes all 10. I'm trying to make a script that makes a form that only shows the data for what is input, as well as a specific line of text under each of these data. One of these text boxes asks for sizes range (ex size 7 to 12). I need a text line that prints out the following ___7 ___8 ___9 etc. based on the sizes range. I know I could make a script that, tells the database to slide up based on data, but how to do I get the t…

Hi I would like to copy and paste (eg to a word document) several lines of script steps. For instance if I’d like to ask a question on this forum that requires showing all the steps in a script. Using FMP8.5 and Windows XP. But I can only copy the scrips steps onto my clipboard and then paste them into another script (ScriptMaker). I cannot paste the script steps outside of the file maker programme. I also can not print them. Any suggestions please?

I apologize in advance if this topic is in the wrong place, but honestly I did not know where to post it. Is there a way to get a "map" of sorts that will show for a particular layout, the associated scripts that go with certain buttons. I am looking for something that will help me proof the functionality. To make sure that each button is connected to the proper script/action and the detail of each script, without click on every single button in browse and/or layout mode.

I guess I just can't see it.........but there's a oops somewhere in here. I'm getting a "yes" in every record sometimes showing as updated=yes even though the import file was empty. some lines are abbreviated...... Import Records [ Source: “file:update.txt”....Method: Update matching] Set Field [ table::gErrorCode; Get (LastError) ] If [ Get(FoundCount) = 0 ] Show Custom Dialog [ Title: .....] Set Field [ table::number of import errors; 1 + table::number of import errors ] Show All Records Go to Layout [ “whatever” (layout) ] Exit Script [ ] Else If [ table::ErrorCode = 409 ] Show Custom Dialog [ Title: ......... ] Set F…

Hi all I would like to attach a script to a button which will take the user back to the previous layout - regardless of what the previous layout was and possibly back thru several layouts in the order they were accessed (a bit like the back button on a web browser). I realise this may involve the use of functions but I am a complete amateur as a scriptwriter so any pointers would be greatfully rec'd Thanks for reading

I have a repeating field that payment amounts are entered into. I need a script that will cause the date and time to be auto-entered into an non-editable list when a payment is entered into the repeating field. Is this possible?

I hope this is an easy question: How do I code a script to turn the FM Network Settings Network/Sharing radio buttons to On or Off? The first line of the script probably is Open Sharing, but then what? TIA for your help! Rich

I have a solution running on server 8 that has an a startup script that takes me to a layout with no fields on it (a splash screen) then it performs a find and then jumps to another layout on the same table. Sometimes though, when I open the solution, the first screen displayed is a layout from another table that has a summary field on it and the users have to wait while FM does the summarization, then it performs the opening script. The two tables are related to each other. Why is it jumping to this table and layout first before the opening script is run? For the moment with only a couple of thousand records it is not that annoying, but later when there are hu…

OK, I know this happens to others, but I have not seen a solution for this problem. We have converted a FM6 solution to FM9 and left the files separate. The files are served via FMS9. We only updated the file references and all scripts and calculations. The solution is running just like it did in FM6. All scripts, navigation, etc. are working as expected. Here is the problem. In FM6 when USER A changed files from FILE A to FILE B, via the Window Menu, the cursor was removed from the original file (FILE A). This meant that USER A no longer controlled a record in FILE A since it was NOT the foremost (front) file. Now in FM9, when USER A has their cursor a…

Is there a way to specify which email account is used to send an email? As I can see it, you have to manually alter the account or the default is used.

Hi all, I have several minor tables linked to a main information table. I would like to create a script that on the press of a button creates a new record in each table and populates the linked field. I can do most of this but the problem comes in creating a new record in all the tables - it seems that I need to go to the related layouts before I can add a record - is there any other method of adding records to a table without visiting the layout? Thanks Rich Update: No problem. I just created a chain of goto layout, new record, populate field instructions for each layout and there is only the usual screen refresh and it is barely noticeable.

hey, so here's the deal. I'm working on a database for a rooming house, I'm trying to devide the 'payment' by the 'daily rate' to get the number of days the tenant will be paid through, so I need to ad the resulting number to the paid through' date field. I have no clue how to go about this. I just grabbed this from some other thread, and think it could be modified for the last part of my script. Date(Month(DD Start Date); Day(DD Start Date)+ RESULTS; Year(DD Start Date)) any help would be greatly appreciated. Thanks, Manuel

I am trying to create a perform find script where a person can perform a search based on one or two criteria. I am having issues cause either it finds everything or it replaces data with in my records. How can I fix this?

I am trying to figure out a method that I can always use to define my buttons for navigating to various layouts in a solution. I want to set my parameters for this without hard coding the parameter value - I like the idea of referencing a field. I would rather reference a field value that dynamically gets its value from a calculation so I do not have to worry about breaking the script. I do change layout names during the course of development because they are used in other areas like window titles, etc. In the FileMaker Pro Bible (page 443), there is an explanation about using two calcs in order to obtain the LayoutID instead of the layout number or layout name. Sin…

Hello all, I have two inventory tables, one with available inventory and one with sold inventory. I want to be able to select a field within a record in either of these tables that will move the record to the other table and delete it from the current table. I have no experience with scripting so I'd appreciate any assistance as I simply don't know where to start. Thank you!

Is there a script that would allow me to MOVE (as opposed to copy) a record from one table to another? I have a database of homes that are currently on the market; I want to add a button that would allow someone to easily move a record to a closed sale database while also removing it from the on the markets.... Is it even possible?

Hello folks, I'm writing a script to export some files from a container field. I need to order the exported files by a field called "manufacturing date" that has the format "mm/dd/yyyy" but because of the slashes FM doesn't create a folder called "mm/dd/yyyy" but three folders (one inside the other one) "mm" "dd" "yyyy" since it interprets the slashes as a path subfolder. Is there a way to tell it that the field must use as is without creating any subfolder? Thanks and have a nice day! Sig

I use the script step Save a Copy as to create backups of my files. For example, I use Save A Copy As["$filename",compacted]. $filename is a script variable that creates the file name in the format I want it. However, the script step places the backup in the parent directory (where the parent FM file is) and I would like to save to a sub-directory of the parent. How can I do this?

I have a data parsing challenge with a CSV file of web orders I download from our website. Each order comes through as one record with fields for name, shipping address etc.. Then there is one field that contains ALL the ordered items. This could be one item or 10 items. I now need to create a script to parse this into separate records. So if for instance someone ordered 4 items, the script needs to create 4 new records and in each insert the data from one of the ordered items into several fields. This is how the data arrives in one field. You can see the delimiters "|" separate "fields within the field" and "~" defines a "new record within the field". 1|SKU1|$1…

I wrote a simple script: Show All Records Delete All Records Set Next Serial Value (I set the Specify target field to my ID field and specified the calculation = 1) After running the script the first new record has a blank ID, the second record has an ID of 1. If after running the script I go into Define Database and open the field ID and don't change anything and then go to the layout and add a new record it start with the ID = 1. I assume I am missing something easy here. Thanks.

Hello, I'm a FM newbie (I started working with it 10 days ago) I have a DB (made by an other guy) that has a container field. This field contains for each record an embedded PDF file. I don't know the name of those files, I know just the container field name. Is there a way to export those files into my filesystem? THANKS and HAVE A NICE DAY! Sig

I have a field Product Code on the Main Page. I have 10 different Product tables (Product 1, Product 2 etc.) all related to Main Page What I want to do is instead of creating a different script for each of the different product, is to create one generic script step. Currently my script is essentially: SetField(Globals::_Global Product Code_;Product 1::Product Code) Whereas I want SetField(Globals::_Global Product Code_;[layout by calculation]::Product Code) Is this possible? all I can think of having is get(layout name)::Product Code but this doesn't work Any comments or help would be greatly appreciated what I

I have a simple question. I have an excel sheet with a string of text/numbers I want to separate each part of the string into individual fields if the string is: Item: PK050 - 05 Simple Part 8819GT the formatting is the same with the exceptions noted there are approximately 4000 records I want to separate, 'PK' [sometimes this is three letters] '050' [sometimes two numbers] '05 Simple Part' '8819GT' I don't need 'Item:' Thanks in advance

I've been working on getting all my scripts for basic search, sort and navigational functionality "portable", so that they work on any given layout in my solution. I've succeeded, with the exception of portals which still create a huge overhead in programing time. I got stuck quickly, when I realized that there's no way to go to a related record by calculation. Otherwise, I could maybe use object names to indicate what portal I'm in, and where FileMaker should go. Does anyone have an idea how this could be accomplished? It's just about the basic functionality: add record, delete record, go to related record. Thanks!!

I have a database that is structured like: Client--->Jobs--->Items I need a way to be able to take a series of Item records and copy them to another job. How can this be automated?

I have been using Thunderbird successfully for months and now have hit the wall when trying to send to a larger group of clients - 126. Can send email from FM to smaller groups 4-27 easily, but chokes on 126. Any ideas?

I've been trying this a number of ways, but what I'm ultimately after--a Prior Balance Field--keeps eluding me. I've tried large, messy calculations; extra tables with redundant information; fields with redundant information. Unfortunately none are working the way they need to. I have a script that finds records by a date range (i.e. June, 2008) and makes a report for that month. I need to include, however, any prior unpaid balance. I am not having any luck in fields, so I'm trying scripting. I'm thinking this is possible, but lack the scripting expertise to figure this out. Here are details: Psychotherapy Billing database includes: One table with Clie…