Script Workspace and Script Triggers

I am looking for a pre-made script that will pick out the lowest price from each grouping of bid/quotations. The price selected should so up in red. I do alot of ordering of supplies and I am obligated to get bid prices and select the lowest. Very tedious. Need quick help.

Hi, In one file, I have records with a description field with entries like: - 11" Fashion Doll - My Happy Family Doll House Set - Tiny Doll House Play Set - Printed Nylon Drawstring Bag - Toiletries Bag w/ Plastic Containers I want to be able to look up words in this file from another file and be able to have all matches displayed in that second file. If words can be typed at random (not "sequential", for example, nylon bag, happy doll, bag containers, and have the matching entries found, that would be exactly what I want. I know that if I am searching within the same file (ctrl > F to perform a find in the description field), all entries contai…

I am trying to incorporate custom dialogs, but they do not seem to size to their content. Although you can resize and expand a dialog when it appears by dragging the lower right corner, all dialogs that popup after come up with those same expanded dimensions. How can I set the dimensions of a custom dialog programatically? Thanks.

What script would I use to check if a certain layout or a certain window (via its title) is open? Thx.

New to the scripting process in Filemaker, so please forgive stupid questions. I've placed a button on my data-entry layout that allows a user to print an invoice. The invoice is laid out differently than the data-entry layout. My script switches to the invoice layout, prints the selected record, then switches back to the data-entry layout. Is there a way to do this transparently in the background, so the user doesn't have to sit and watch the program switch between layouts? Thanks in advance!

Hi I want to create a script that automatically writes relative numbers (02, 03, 04) on a field from a related file. (as many relative nums. as num. of relative fields displayed). I would appreciate reply to thanks, Daniel

Apologies, but I couldn't decide exactly where to post this as I have a couple of questions covering several topics. If I'm in the wrong place, please advise and I'll repost where I should be. First and foremost, I am a complete newbie so any help will be most appreciated no matter how small or seemingly insignificant. I have attached my current WorkInProgress file. Most of it is working as I want it to, but there a few things I want it to do but can't seem to get right. My file is the beginnings of a much larger database to handle a whole host of things at work, but for the time being is just a contact management database. There are two tables - contacts a…

Could someone tell me what the popup options Halt/Exit/Resume/Pause are used for in the Options area of the Format->Button Setup... dialog? I wonder about this every time I go into this dialog and click Specify... to link a script to a button. I leave the popup at the default 'Pause', but I don't notice any pausing going on when I click my button--my script executes without hesitation.

Is there a way to loop through a field in all records to check it it's flaged? Here's what I am wanting to do. I want to be able to flag a certain item as preferred. When I go to flag this item I want it to first check that there is not a product of this type already flaged. I have hundered of products and I am afraid that it will strain the system, but it would be worse if 2 of the same items were flaged preferred. my product is Product::SKU So I would want to loop through all the Product::SKU that are identical to the one that I am entering. something like this..... loop----- if(Entered::SKU = Product::SKU and Product::Flag = 1) "Product already f…

I have a script that is looking for a pattern count in a global and if found, will flag that record. It seems to work except for similar records. If the string I am looking for is 1200A and the record contains 1200 it flags it. I don't want it to. My current script is as follows: if [ patterncount(global;record)] Set Field[flag;"Yes"] meaning if the contents of the record field is in the global field, flag it. But I want it to flag it only if the exact match is found. How do I do that? Thanks

I have a calculation for a person's age (paccdate-dob/365) The result is a number that is a very large decimal. I would like to round it off to the nearest whole number

I am going to shoot myself if someone doesn't help me figure this out....Just kidding, but I got your attention right? I'm trying to make a script that will loop through my portal rows and set a flag to Bold header text. My problem is, it loops fine, but it keeps looping and creating records because of the flag.(Hense all the no no no no no's) I need it to stop when there is no record left in the portal. What am I missing? update. I got it to work by just changing the LineItems::row into a global field. I am not exactly sure why that worked though. Explanation anyone?

I had a served file which crashed yesterday. It was so trashed that Recover (after 4 hours of working correctly) would freeze up. So I exported new and modified records from 50 tables as Mer. Then I drug one mer to my Developer shortcut to open it and check it for empty or trashed lines. I visually checked them carefully. And then I ran a Set Field[ field; field ] - setting a field to itself, hoping that if there was a problem with it, it would show then. I repeated with every MER file. None showed damage. I then imported these files back into a clean prior backup (that I know has never crashed). But the new clone crashed when a script required setting one of …

I'm building a relational DB to track employee training, attendance, job performance and several other parameters. I'm having a problem developing the correct type of "FIND" scripts. Here's the problem: For certain actions, the user will want to find only a single record and then add data to other tables related to that record only. I know I can accomplish this by providing the user with a layout containing the right searchable fields and performing a simple find. For other actions, the user will want to find a selected group of records, and then have FM add the same data to all the records in this found set. (For example, a group of employees who have att…

Can somebody provide an easy tutorial on how to make checkboxes 'work'. For some reason, an error message appears if a user tries to check more than one box in the checkbox field [in Find Mode by the way]. I'm confused. It only works if you check one of the boxes [there are 18]. Let me know if you need any more info. I truly appreciate it!

I want to create a new field based on a field containing large numbers [ie. '81391002;]. I want the new field to shorten this number to the first two or three numbers. For example: '81391002' would be '81'. Currently, the field is in a number format. Can anybody help? Thanks, Sara

Hi guys, I am not sure this is where I should ask this but here goes. I have 5 fields labled Bldg_1 through Bldg_5. Some records have only bldg_1 some have more. I need a report that has all buildings sorted by building number. How do I find all the buildings from the 5 fields and display it in a single field to show all building numbers?

I have created a file database for my audio business. I have records for each sound effect in my collection (approx 80,000), and can now search them for particular keywords in a Description field. Life is great, but there's one thing I'd like to do... I would like to create a link to the file on my hard drive. This would keep me from having to open up an Explorer window, track down the file, copy it to the directory where I will be working with it, and repeat for each additional file I need. Currently I have three fields in each record: filename, path (without drive letter, in case the letter changes... the files are on a firewire drive), description. I would li…

Been trying to work this out, hope it's a simple answer for someone here! I have a databse that logs field activity by date, time, task etc. Field workers report in at various times and they log in their own tasks performed during the day. At the end of the night, the supervisor needs to print a daily log for the bosses to read in the AM. So I need to find it by date, then sort it by time and print. I got the date find easily, but how do I get the found records to sort in chronological order prior to printing? Thanks for any help.

Hi. I need to create a small popup that pops up centered over the main layout, includes an icon on the left, a text string on the right, then disappears after 3 seconds. It is exactly the type of dialog Filemaker itself uses to offer occassional messages/feedback, just that on mine there are no buttons and it disappears automatically. I say "lean & mean" because I want no maximize/minimize buttons, no zoom controls, no thick border, no scroll bars, no nothin'. I know how to create a custom layout and do a New Window--Pause 3 seconds--Close Window, but such a layout comes equipped with all the extraneous, aforementioned distracting stuff. Plus the window…

I want to make a script that will backup the database [save A Copy As] with a press of a button to a given location. I want to name the saved file BackUp_$TodayName.fp7, where $TodayName gives for example "Thursday". Is there anyway that it can be done?!

Every once in a while, and for no apparent reason, I'll use the GTRR step and set the destination layout but the info won't show in the Edit Script dialog, only in the GTRR Options dialog. Please see the attached screen shots for an example of what I'm referring to. The script step still executes properly by going to the layout I've specified. I just can't figure out why the layout is in the Edit Script Dialog. Has anyone else ever had this happen? :qwery:

The following conundrum is (currently) OS X specific and I'm using Troi File plugin in the script. I want to create a new record in a table "Documents" for each file (any type) in a target folder. In each of those new records I'd like to create a file reference that pertains to the file. To accomplish this I'm trying to pass the file path to the "Insert File" step via a script variable called $$filepath. The problem is that I keep getting the message that the file cannot be found. This is driving me nuts because when I view the variable $$filepath, it shows the exact file path. Aaaaarrgh! Can somebody please help me out here? Sample attached.

I know this should be super easy, but I'm stumped. I need to be able to count how many Order parts there are for each Order. Right it counts all OrderPartsID no matter what Order it came from. I just want how many parts for a certain order. Order #1 has 3 parts Order #2 has 4 parts Order #3 has 1 part Can't wait till after Christmas when my brain kicks back in. Thank you for the help.

I am viewing records (through a portal) from a database "file1" in another related database "file2" and viewing them through a portal in the 2nd file. I can select any of the items shown in the portal and use them in the second database. i.e posting them into a table within the second database. When I add items from the first DB to the 2nd DB the item that I just added will dissappear from portal1 (file1) then be shown in the portal2 (file2). When I send items into portal2 I obviously am turning off criteria of to which it is shown in the first instance. So, if I delete that same item from portal2 I wish that it be shown back in portal one, which is in File1. …

My wish: Loop through every table one at a time. Search for all records that have been created or modified past a certain date/time I specify (in global? Every file has identical CreateStamp and ModifyStamp field names) and export that data to file names equal to the table name. I assume I will pull VBScript into the mix for renaming the files. I am looking for the most elegant way of automating the script process to export this data. We are not (fully) in vs. 8 yet (although I have Developer 8 which can be used) in case you suggest variables here. I would then like to script the reverse - importing back into my appropriate tables but as two separate ste…

I am attempting to write a script that will copy data from fields in a portal row and paste the contents of each field in the portal row onto a line in a text field. I have the following script steps that accomplish what I want to do for the first row of a portal. Go to Portal Row [spots::SpotNumber] Go to Field [select/perform; Spots::SpotNumber] Copy [select; Spots::SpotNumber] Go to Field [Project::ScheduALL Notes] Paste [No style; Project::ScheduALL Notes] Insert Text [" "] Go to Portal Row [spots::SpotNumber] Go to Field [select/perform; Spots::Title] Copy [select; Spots::Title] Go to Field [Project::ScheduALL Notes] Paste [No style; Pr…

This seems like it should be simple but I cannot figure it out. - I have a database sorted in a particular order - I trigger a script to run a report. The script that runs the report sorts the database in a different order. - I would like a way at the end of the report script to sort the database back into its original order. The problem becomes the original order can be one of 14! Is there any way to remember what order a database is sorted in and then sort it in that order later? I have figured out a way in my mind to do this but the script will be long and ugly

Is there a quick script that commits all records in all open windows. Some times a script is trouble because a cursor is still in an active field.

I used the backup script under the FileMaker Developer 7 help files. It backs up the data after every 5th closing. I noticed that it puts a fp7 extension on it though. If I make runtime files for this program how will the user be able to use the backup? They would have to have FileMaker 7 Pro on their computer thus defeating the whole purpose of Runtime files. Could I just change it to a .usr extension? Or will this cause problems?

I'm wondering how I can specify the target field for a "set field" or "go to field" script step via calculation rather than a statically-defined field. I'm surprised that isn't an option, as it is for other "go to" script steps. Any tips?

I would like to create and maintain one layout and have that layout serve two groups of users. Group 1 has read/write access to all fields. Group 2 has read access to some fields, read/write access to others. I will have a login screen where I can store the user's group number in a global variable. Can I then dynamically change field permissions for the layout based on this variable? Thanks.

Ok... I'm a real beginner. That'd be wonderful if you could help me. I would like to have a dropdown list with categories. And I'd like to have a different layout for each category. So if the user picks category1 in the dropdown list, he will get layout1. Does that make sense at all ? Thanks for yor help ! Alex

Hello, In Scriptmaker, I'd like to insert a line in a script to remove a date from a date field. I would think I should use the "Set Field" script step, specify the date field I want to clear, and then enter "". However the calculation result must be a date so the field displays a "?" How can I rewrite this to simply get the date field to be empty? Thanks.

I know this has been talk about before. But I did many searchs and could not find out how. What I want to do is: [color:red]Goal> Open a comma delimited file and import it into one of the database. And repeat this for two other comma delimited file. I am manually doing it right now. It bites The problem is, how do I make sure the import has the right field aligned with the correct field in the database. eg. comma delimtted file= Chuck.txt "Name", "Dog", "school" database= info.dbf fields> Persons Name Persons Dog Person Hightschool How do I make sure Name=Persons Name and Dog=Persons Dog, etc. Then I need to loop i…

First time posting and I hope this isn't too basic a question. I'm probably more novice than intermediate when it comes to FileMaker. I work in human rights non-profit. I have a field in database marked "Race". Within this field we have a value list for White, Hispanic, African American, etc. For reports, I need to show how many people of each race are contacting my office within a found group. I know I could set up the races individually as text boxes and then set up another field to tally, but I like having the value lists (race types) all within one field vs. separate fields. If anyone could help point me in the right direction for the script, I'd …

Filemaker newbie here, transitioning from MS Access. Please forgive any stupid questions or faux pas. I am building a database to track every aspect of a design project. I have five tables working together: - customer info - project specs - billing info (estimates & actuals for all aspects of projects) - shipping info/tracking - project history/notes What I'm trying to do now, in simplest terms, is create a way for designers to open the project, click a "Start" button that will begin tracking their time, then click a "Stop" button. I want that billable time to be stored in the billing info table. I've got a good idea how to go about all t…

Looking at the Filemaker Help section it seems that they have improved the OS X compatibility with the Send Email script step, but I am wondering if this means that the only way to do this is if Mail is your default mail app on your OS? What if you have Mail, use it for some things and yet have another application set up as your default mail application? I for one don't use Mail reguarly so its not my default Mail Server, but I do have it on my computer so would gladly use it as the end result of a Filemaker script if necessary, especially considering that I am trying to create something for other users to eventually utilize. With this in mind, it would seem to…

Hello Ppl ... does anybody knows how can I lock the window's cross...that close all the windows .... I've seen it in o fm file but can´t do it.... Basicly... I dont wanna see the minimize, restore and clos windows on the upper right corner fo the window...(or locked them) Thanks

I have a script that uses a message to prompt the use if they want to creat a new record. What I'd like to do is have the message be displayed saying "do you want to creat a new record" then give the user the ability to either exit the script (which would be attached to the "NO" button on the message, or allow the user to contine and creat the record (YES button). My question regards the use of the message and how i can use that in conjunction with a IF statement perhaps to set the condition that allows the user to exit. any suggestions? Regards, Ron

Hi, I have a notes field as an edit box with a vertical scroll bar. I want to put the text cursor at the end of the first line of text. I put a time and date stamp and then want the user to enter text with out having to navigate with the mouse/cursor keys. Thanks Brad

Hi I need a little more help and hope someone have an idea. I would like to send all information from a layout in a mail. However the layout include a portal and I can only get the first line added to the mail. This option could be a calculation made in the Send Mail or Send Event option but I was thinking that maybe the best way is to make a script that show the information in a Global field that I then can add to the mail body. My problem is getting all the lines (5 fields and unknown number of lines) in the portal in the global field. Do anyone have an idea for me to try? Thanks for any help on this. Cheers Jens Peter

Hi, can anyone suggest the best way to go about, appending text (single word) to the existing text in a field, for a group of records which are showing in a portal? Any/all help much appreciated! : Grant

I am dealing with importing a number of contact files into a single fp7 contact file I am working on, but unfortunately some of the files only have 1 (full) name field and don't have first and last name fields like the new file I am importing into. After importing the full name into the First Name field, I created a simple looping script which copies the full name into the Last Name field as well, so I at least have automated getting the full name into BOTH fields. Now I want to create a script for each field which removes either the last name in the case of the First Name field and the first name in the case of the Last Name field. Any suggestions? Thanks…

I have been doing database design with Access and VB for quiet a while and started using FM about 3 months ago. I have two questions for the pros out there. I have a database used for employees to input their weekly work report at the end of each week. How do I: Q1. Once he/she selected name and date from 2 dropdown field, the program will do a search, if there is a record with the same name and date, bring the record for user to modify or add more info, if no match, generate a new record. It sounds easy but I really don't want to add a Go button or something to start the script. Can I start the script once these two fields are filled? Q2. I want the uses be ab…

I have this dandy little application I am working on that helps manage tasks. You create a task > Assign it to a worker Click on the worker > Find all tasks assigned to worker This is, for the most part, button driven. The names of the buttons are dynamic. If you change the name of a worker in the worker list layout, the name changes on the buttton. Everything was working great in Version 1. In version 2, I tried to minimize the number of scripts that I have to manage. So I substituted the [Get Script-Parameter] function for a lot of otherwise redundant scripts. Except that now the Perform Find Script breaks. I am going try …

I'm trying to figure out how to imcorperate one database we have for clients orders into another. What I'm trying to do is, taking the items they ordered and have another database to keep a running track of all the purses, bags, totes we sell. I want to have on field for purses with the total of all the purses we've sold, and so on, then at the end of the form have a total of everything we sold. How do I take the information (Well part of it) from one database and stick it into another without repeating layouts.

I have an application in which I script almost everything from navigation to searching and sorting to record creation, and I have found that a huge scripting problem arises due to the windowing features of FM7. Many of my scripts are used in combination to achieve my ends, and I have found it difficult to keep track of which window is currently active and which layout is displayed in that window. This gets particularly problematic when creating or deleting records in a script; if the window gets changed for reasons I haven't accounted for, the action will take place on the wrong table. OUCH! One way I had been working around this was to have each script establi…

Hi I need some help that I hope someone can help me with. I have a field "Type" where I have a value list added to holding "Type 1" and "Type 2". The user may change from "Type 1" to "Type 2" but when the "Type 2" is selected the field needs to be locked for futher changes. Do anyone have an idea on how to calculate this? Thanks for any help.

Okay so here is what I am trying to do and tell me if it is too easy and should not have been asked... I have two drop downs one next to the other and one is a sub list of the other. I would like for the first list to customize the second list. So for example if the first drop down selection is 1 then there would only be options abc in the second box. If in the first the selection is 2 then the second box would be def and so on. Is this easy to do or no? Also thanks for all the help on the highlight post i made lots of people seem to be usingit now.

Hi my specify calculation is something like this.. if (a=0; b =1) else if (a=1; b =0) else ("") but i can't get it working.. can someone corrects me.. Thanks a lot.. Kelvin

Hi, I'm quite the beginnner with this. I used MS Access for 2 years, but I wasn't the guy on the job that built it. I have a rough idea of how the software works, but scripts are completely new to me. I have a database started, and I want to put a button next to a field that displays a companies website address. I want to hit the button and have a script run that tells my computer to open up a browser, and take me to the address that is in the field of that current record I'm viewing. I'm sure this is juvenile to the forum, but I learn best at seeing how something is done correctly, and I want to compare it to my own script concept which isn't working. I…

I have a script that add content to a field; something like this: set field [target field; target field & source field] I'm looking for a way to use a different text format for the new content i'm adding. I don't have problems changing font, size, style, but i just don't know how to change the "paragraph" setting with the script. This is a printing form, it's a text field with a set field of every related information I have in my DB. What I want to do is add content with different margins to a field while keeping what is already in the field the way it is. Basically, i'll have a part of the content with 0.20cm margin, and another part with 1.00cm. How can…

I had written 9 scripts in a file which trashed. I'm using a good (prior) clone but I would like to save those scripts if possible. I'm considering importing them into my good copy. There are no 'table missing' or 'field missing' nor commented out sections. I don't want to risk bringing trash into my good file but it would sure save me a lot of time. Do you think it would be safe? I don't want to bring them in if there may be *hidden* damage. :wink2:

I have a problem with my related db. The parent db has a number of records with different customers, in the child db ( I will call it deliveries and inventory ) where when a delivery takes place, it deducts the delivered amount from the customes inventory and showing the remaining balance. The two db are related with a serial number ( I will call it Line Item No.) My problem is that when I have multiple deliveries from a specific customer's inventory, it always deducts from the original amount and not from the balance of the previous delivery. How can I do this ?/ Nick

I made a script called "Search for", the idea was to make a search that would allow the users to search for a list of results. Things like Booked, Missed, CBRS, Dispute, Special, etc.... Everything is working fine, up until the point after where you click the option that you want to search for. It comes up with the menu and when you select "Booking" , it will search for "Booking", however it will only search "Apptresult" and it wont search the other 3 boxes "Apptresult2" or "Apptresult3" or "Apptresult4". What i want it to do is search the 4 boxes and search for what ever is selected in the menu. I also want it to search the 4 boxes, just not the "Apptresu…

I have a 50,000 name mailing list DBF. I want to be able to select a range of zip codes for mailing, AND the number of records to find (or export.) I have the zip code range selection figured out, and I have provided a numeric Global field to enter the total number of records to find or export. This is where I hit the wall. How do I set FMP to find (or export) only a certain number of records within a found set?

I'm creating a database for the law firm I work for. I've set up a drop-down menu listing the different types of documents that are written. There's about 20 different documents so I really didn't want to create individual buttons. What I would like is to choose a document off of the menu and then press "go." I know there's a way to do this. It's just not coming to me. Any suggestions?

I have created three portal groups with fields in them to hide the fields based on a field selected. I would like to have all the portals on top of each other and the portal that gets focus to appear on top while the others go behind it. normally the fields that appear are all messed up when I put all three portal groups on top of each other. I am not sure if this is even possible with scripts. I hope it is otherwise i will be stuck with an ugly form having fields appear in three seperate places on the form depending on what the user selects. I can put one on top of the others by selecting arrange and then bring to front. You must be able to do this with a script. Th…

Hello, I want to know how I do to run a script without press any buton or field? The users in my database use a scanner and scan a employee card, after the scan I need to run a script to verify some information. In filemaker 6.0 I used Activator plug-ins (actr-schedule event). I tried to convert in fm 8 but it seems the parameters are not the same?? Anybody can help me? Thanks bruno vaillancourt quebec, (you understand why I am so bad in english) canada

I feel this question should have a very simple answer, but I can't find any solutions in several reference books. How do I use a script to insert data into the next empty repeating field? The Repeating Functions seem to be for retrieving data, not inserting new data. Set field doesn't allow for a field value to dynamically set the repetition value. Do I have to set up a loop and manually count each field to find the 1st one that is empty, store that value then do a series of If statements before I can enter the value to a set field with the specific repetition value? (yuk). Mark

Hi! There is an script that can hide and show fields? Thanks...

Hi Everyone, I have a course wait book database for a high school. In an outside database, I have a list of all courses being offered for that year. I have it set so that when a user clicks a field, it opens up this database which lists the various courses. I would like for users to be able to click "copy to course request" and for this button to copy the fields course, grade and period into the corresponding fields in my course request database. Is this possible without a complex portal?

Here is a situation I am having trouble wrapping my brain around... Background info: I am setting up a database to help organize a conference we are putting on for some (500 or so) students. During one portion of the day, the students choose 2 sessions from a possible 12. That portion of the day is actually split into 3 periods. They will attend a topic in each of two periods and eat lunch during a third period. Lunch could be during period 1, 2, or 3. The students will be split as evenly as possible in each of the three lunch periods. And the story continues... I will not know how many students have selected each topic, so therefore will not know how man…

how can you increase the siz of the buttons in custom dialog boxes....the text i am putting in the button is only two words..but they don't fit.. help please

Hi! As you know, I need help again!!! I'm trying to make a script that can get any account name existing in database but I can't do this!!! I've tried to use Get (AccountName) = "Everton", but this don't get an account name named Everton, this only compares if actual AccountName is equal the string I've put in code (Everton in this example). I need a script that get any account name so, if you can help me, I'll be very happy!!! Thank you very much.

hi I have a field order date I would like to make a script that omit the record if the order date is from the same month and year as the current timeStamp I will trigger the script on the last day of the month. My format in order date is 26/01/2005 it should not be 30 days back, but all the record from the same month How do i make the script ?

Anyone have an opinion on the relative merits of creating a child record in a related table via various methods? I'm thinking of the circumstance where you have a portal on the layout, but you need to have the related record creating scripted. Method 1 : Create the new record by (A) allowing creation of related records via. the relationship, ( going to the last portal row, and © setting any related field value, which will automatically create the related record with the proper foreign key. Method 2: Create a dedicated script to create a new record in the child table. Pass the foreign key as the script parameter. Go to layout (child table). New record. Set …

Hi, I have a script that has Filemaker perform a find request. The only problem is that when the the requested data can't be found Filemaker shows an ungly error message with various options. Basically what I want to happen is either for the script to simply end when the find fails or I want it to show some kind of a custom dialog. My problem with doing any of this is I can't figure out to put a condition in my script that says if the find fails then do this. If anybody could help I would be most appreciative.

I have old databases originally written in FM2 using lookups. We are currently on 5.5 and migrating to 8.0 For Invoices I have a separate db with invoice number as serial number and each time someone adds an invoice it runs a script to go to the inv# db add a new record, copy that value and paste in invoice file. I am trying to streamline a little and I believe I can have a separate table within my invoice db to do the same thing. For the life of me I can not figure out how to increase the value of the inv3 field in the table. I need another table because I don't need a new invoice number each time a record is added. Sometimes the invoices have to be revised and…

All of a sudden, I feel like a looped script is taking way too long. The loop works on a layout without graphics, and simply sets one of the fields with specific text and moves on. (No if statements or complicated calcs!) There are 4,000 records, and it's now taking about a minute to process every 40 records. What could be going wrong here?

I need to write a script to populate a layout with records, hiding duplicates. My records have a field that can be the same across several records and I want to show only one instance of this field rather than all records. How can I do this in a script? Thanks

I downloaded the Calender from the net. I believe it was called CCcalendar at the time. It was made for filemaker pro 7. Since then i have changed it a lot and there is two things i want to do. 1). I have made it so that it brings up appts from another database called "Work Database", however as the calender is set up atm it will add the appt to the date that is highlighted. What i want to change is so that it will automatically set the start date to that which is in the field "Apptdate1" in the file Work Database, instead of using the selected date for Start date. 2). Make a script that will automatically add all the appt from the work database and add them to …

I have to make a script that returns all records that have a specific month (example: november) to make a report, but I can't do this!!! I have tried to make this script for a long time, but I can't do this alone, please help me. Thanks.

Well hello to all. I have been building my first DB in Filemaker and ever evolving it since August. Let me say I am incredibly impressed with this DB and will be building many more DBs to come. So here is the thing, I have a drop down list for project status, I would like to write a script that when say shipped is selected the entire line gets highlighted. Curently we have the Client, Date, Type, and Priority, along with the Status in the list view. So can anyone give me a hand?

Ok since there seems to be an infinite way to do this I am just curious of which seesm to be the most effective for development and maintaining scripts. Method A For each "module" such as "Customers" I have one script "Manage Customer" inside that script I test for the script paramerters. On my layouts all functions or tasks that involve customers perform this script passing the appropriate paramater, such as New, Delete, Find, or some specific scripting function. This greatly reduces number of scripts as anything that deals with Customers can be manged via this single script. Method B: The other method would be to write a Function type script that does o…

Hi, I have a script that shows records by month and by day, but I want to filter this findset to show the days after 20 day of a month (example 11 - november) and the days before 20 of the next month (example 12 - december). Someone can help me? Thank you so much.

I am experiencing problems with adding sub-scripts to a "main" script(1). My main script already has a subscript(2) within it. This all works fine. I have another script(3) that also works fine on its own. I have tried to incorporate this third script into my "main" script (1). However, the script(3) does not work correctly once it is added as a sub script to the "main" script(1). Is there certain steps/criteria I should be adding into my scripts to ensure sub scripts work correctly?

Can you help me? I have a dabatase called "PONTO DIARIO", with a lot of fields. This database was created to one purpose: control employee time and day of work. I have 20 users and each user have an account name and password in FileMaker Pro 7. What I want? I want to make something (script, field, anything) to do this: Example: Log in with account Everton and password test Record something in database and exit the program. Log in with account Tiago and password test2 Record something in the same database, but the records of this account have to be separated of account Everton. Let me explain: Database PONTO DIARIO Account…

Dear All, I'm FileMaker beginner and I'm trying to make an application for practice. I create work order form that have portal in it, the portal will hold work order detil. The work order fields will be ('Work Order Number', 'Customer', and 'Date'). The portal will hold ('Work Order Item', 'Description', 'Quantity', and 'Work Order Status'). This is what I actually want. When I create new work order record, I want 'Customer' field filled by pick up customer data from file "customer.fp7" How to make this things possible in FileMaker Pro 7 ? Customer fields will be like this ('Customer ID', 'Customer Name', 'Address', 'Phone', 'Email', 'Website'). Please,…

Cna anyone assist me. When i enter a town name i would like the associated postcode also entered into a field. I would alos like to be able to make it wirk that if i enter the postcode, the town name would also be entered Thanks Jules

HI Guys Can anyone help we with this little problem, i need to automatically insert an image into my database ( a barcode) based on an automatically generated barcode. For example when filemaker generates the code MC0000100 i need the barcode image on my harddrive inserted into a field. Any ideas?? Thanks Jules

Im trying to develop a script that would allow access only certain users based on what account they are in. My solution uses the external server to authenticate users. I was trying to use an "IF" statement with the Get(accountname) function, however I wasn't having any luck. Any suggestions? Thanks, Ron

Ok, I have been trying to make a script that would work. I just keep confusing myself. I can get somethings to work but not the way it should. I have to generate a report every month on the taxes that have been collected for that month. This is based on two fields, "Date Sold" and "Total Tax" How can I write a user friendly script that lets the user put in what month to check for tax? I have tried the custom dialog but cannot seem to figure out how to write the script so the user can put in a range of dates, for example 051101 - 051130, and the user would get all inventory sold on November 1 2005 to November 30 2005 that collected tax. I need the script …

Hi, I have a bunch of records that each have a target date field. Is there a way that I can dynamically find the records that have a target date in the next 7 days? I can't hardcode any dates in there. I know I can find target dates after today by finding records where the date > //, but I can't seem to omit < // + 7 or do any date manipulation with dates in the find criteria. Thanks. -Chris

what is the general format for a script to send an email using verizon/yahoo. Something roughly like this worked for Juno: Open URL["mailto:email address"&?subject="subject"&"&body="text"]

I have a large database of almost 50,000 names which i am about to use for a direct mail campaign. I want to be able to choose a range of zip codes and then export a certain number of records from that found set. I can FIND A RANGE manually by using the range (...) symbol in the ZIP field, but how do I automate that in a script? I have used two GLOBAL fields to store the choices for STARTING and ENDING zip codes, however I can't use them in a FIND step in a script...they are grayed out. What am I doing wrong?

Hi, Is it somehow possible to make an external app to run a script within a FM file? So far, I've used an additional "script opener file", which opens the necessary extermal FM scripts in other FM files as a part of its own startup script. This file can easily be opened by another app. The problem with this approach is, that even when the "Set Use System Formats [On]" is the first step in the startup script, the dialog about system formats, requiring user input, still sometimes appears in client computers, depending on their setup. This particular step performs a critical function, and is often performed when the computer is unattended, so it would be…

Is there a way that I can make file maker read the output from a console app that I've wrote. I want to be able to create file maker plugins, but my language of choice is C#.NET, and I've yet to find any docs explaining how to make a .net FM plugin. TIA!

I am trying to set up a custom dialog box to ask the user to enter in a set of dates for entry into a search field. This works ok but I found that only the OK button works. When you press the Cancel button in the Dialog Box it just gives an error message on filling in the dialog box and then you have to press Cancel again on a different dialog box in order to get out of it. Is there some way to designate what each of the buttons do on the Dialog Box? I couldn't find anything in the help files or on the forums??? Derek

I'm hoping to create an initialization script that goes to a special layout with all my global fields on it and sets each of them to Null or 0. I planned to use a loop so that I would not have to enumerate every field I wanted to set, and go to each field on the layout and set it according to its field type (0 for number fields, Null for text fields). To do this requires that I be able to test the format of the current field, and if it's a number set to 0, and if it's text set to Null. Is that possible, or will I have to find some other way to get this set up? Thanks, David

hi.. I got this list view layout that list many form records and 1 of the field is fild id. There will be a button beside fild id field, by clicking on that button e.g. belong to fild id 008, it will bring you to the form layout and bring u to record which fild id is 008. Can someone help me on it.. Thanks a lot Kelvin

I have a bunch of records with a date field. I want to get the value of the earliest date to use in a calculation but cannot see how I can find it. Can you help? Guy

Hi, I need to write a script to produce a list of records. I need to reduce the results to only unique records, since I am interested in just two fields for this purpose and my database contains many duplicates over just these two fields. How do I not show only unique records in my results?

Maybe this isn't possible but I thought I would ask. I am trying to make my script parameters "dynamic" so if you loop through records, the calculation in the script parameter works for that record. However, it seems to be a static value that gets passed once. I wrote a custom function to capture all parts of an email and want to use that as multiple script parameters. Then I can use one email script and pass different calculations into the email body, etc. However, it seems like the parameters pick up the first record's info. and then that's it...even if I call the parameters again in a loop. Hmmm. Am I doing something wrong or is this not possible??

I am an MS Access convert and an trying to figure out a way to write a script to do a between search. In Access I was able to to find records between variable 1 and 2 and enter those variables each time I ran the find. I am trying to do the same here with FileMaker. I know I need to do FIND and I need to use the ... function, but how do I stop the query to let me enter the search parameters? Thanks for the help

I have a table called system that contains one record with all my next id numbers etc If I want the next invoice number for example my script would be along the lines of set field invno to system::nextinvno. set system::nextinvno; system::nextinvno+1 In a multi-user environment with the solution run from FM Server should 2 users attempt these script steps at exactly the same time would it sort itself out and form a nice orderly queue or is there something I should be doing to error trap for this ? I know this is highly unlikely but I just thought I better be on the safe side TIA Phil

I'm having trouble getting 'Send Event' to recognize an application as an application. I have an application file on my desktop which runs nicely when double clicked. I would like to launch this application from a script. When I 'specify' for the 'Send Event' script step, I choose 'Open an application' and then select the file. It is labeled as 'kind: application', yet when I 'open' it, no error message occurs and the 'target application' remains ''. Any ideas as to why 'Send Event' does not accept this (or other applications that I've had trouble with)? This particular application is an 'Install Anwhere' installation program but I've had similar experiences wit…

I have a script that adds a new record into a table. The script is called from a different database and a code is passed in as a script parameter. How do I check to see if the record has already been added? I figured I needed to do a find, but I cannot get it to accept the script parameter as the argument to the find.

Hello all, I have two tables, Table A and Table B, where A & B are related by an ID number. Is there a simple way that I can find all of the records in Table A that are NOT related to a record Table B? I will need to export this found set. Thanks! -Chris