Script Workspace and Script Triggers

Hi, I'm trying to send out an email when an activity is saved -- is there a way to observe the activity state and when it gets saved it can trigger a script? Thanks -Rob

Hi, I need some help. I have a notes field that has ¶ characters in it. I would like to be able to replace ¶ with carriage returns so that my notes are not bunched up. See below for example: Title: correct target audience, req. copy of BXL¶Description: ¶Title: DS: has not read the info. ring tuesday¶Description: ¶Title: DS-ring early next week¶Description: ¶Title: DS-Ringing bck, has not read BXL yet¶Description: ¶Title: DS-Patrick, int. but not for4-6 weeks¶Description: How can I do this?

I've inherited an old FMP application with multiple scripts. One of them (I suspect) is causing the app and FMP itself (actually v. 6.0 - Yes, I know!) to freeze; I want to try and capture at least entry and exit into each script and subscript called by the app to a log - so that at least I can identify any bugs in the script causing the freeze. What's the script syntax, please, for a line that will, for example, write to a text file (I'm on Tiger, 10.4.10) something like: print [entering script 1a] ... script lines ... print [completed script 1a] etc. Any other suggestions for ways to log script execution gratefully received. Thanks!

Is there a way to apply certain values (ie. a date or an author) across a specific set of records? I just want to apply the date and author field to 300 records rather than have a data entry person go back and select the data from a drop down for each of those 300 records. This sounds easy enough - any ideas? Thanks.

Recently, I have had situations where Filemaker 8.0 Server Advanced (on Mac 10.4) was acting strange. Relationships and searches weren't working correctly on certain fields. For example, say you have Customer X with a Customer ID of 5. I could view Customer X and it's customer ID, but if you searched on the Customer ID, you got no results. And any relationships that depended on Customer ID did not see Customer X. To fix this, I would foce the indexes for the Customer X field to be rebuilt by changing its Indexing to None, and then back to All. Unfortunately, this has now happend a few times over the past 6 months, all for different fields. This seeems to happen to so…

Hello, Is it possible to pass a filename as a parameter to a script which then uses the open file command to open said file? I've tried without any luck.

Does anyone know of a way that you could replace the "FileMaker Pro Advanced [Window Name]" in the top left of the main program window With something of your own? Thanks, Mel

I am trying to perform a find based on a date range. However, this range is based on weeks out. For example, Today is 8/16/07. I want to find all records between 2weeks from now, and 6 weeks out. I currently have this script: Let (cd = Get ( CurrentDate ) ; WeekOfYear ( cd )+2 & "..." & WeekOfYear ( cd )+6 ) However, I am not certain how to turn the week back into a date range for the field. I am thinking I am missing something simple, but am stumped.

I am working through Scott Love's article in FileMaker Advisor on making Pop-Up Pickers (August 2006) and wanted to modify his technique, but wasn't sure how. Essentially his technique is that the user clicks a button that calls a script to open the pop-up window. When the user clicks on the name of a person in that window, a parameter gets passed up indicating which field is wanted - in his example it is the primary key of that person. I would like for that pop-up window to return the results of different fields (possibly the primary key like Scott had, or possibly a foreign key depending on what I need at the moment), and I would like for the name of the field need…

How do I wright a script that will sort a portal? There doesn't seem to be a way. Am I just missing it?

Hey all, I'm trying to create a fool-proof editing ability in my database by setting all user's privileges to [read-only] then run a script which using the re-login script step relogins as a user with [data-entry] priveleges. Then the user edits the page. But then when they are done editing I want them to return to their own user account (so they lose editing priveleges again); I can retrieve the login but not the password. The front end of my database is just the normal login page for web publishing. I was thinking if I store the passwords myself I could retrieve them; is there any way to write my own login page? Thanks.

Hi, Not sure if this is the right forum. I have to add in temp tables to an existing solution, to improve data security. I cannot see a duplicate button on the table definition screen. Is there a way to duplicate and avoid having to declare all the fields (1500+) Thanks, Nick

i need to pass multiple parameters to a script. i was doin this via word lists. but the word list would cull operators which i had within the parameters. so the next soultion is to pass via vaule lists this is what i am sending ${Jobs (Timesheet Reference)}::Job Number) & "¶" & Timesheet Project Entry::Task Number but when a rip the values out of the list on the other side i still have random characters on the end ie 'the square' : now i assume this is possible or there is other ways to do this. i could do global variables but my coding backgrounds refuses to give in : so has anyone got any ideas, sure you guys do. the community has been alot …

Is there such a thing as an insert field script? I'm making a list to identify people with various skills and I only want displayed those fields that have data in them. I want to make a button at the bottom of the layout that runs a script to insert new fields so I can list more. Is there a way to do this in FM? Do I run a script or something else? I've included a picture to try and illustrate. Thanks

Hello all, I'm new to FM and I have a strange problem. I have a button which I wish to hide if a particular field is empty. Unfortunately I have not been able to find a way to do this as I can't find any general controls for the button (for example visible=false). Is it possible to do this? If so how would I go about it? Thanks very much.

Hi all, I am trying to understand the send url link in filemaker 9. For instance can I create a way for the server of a database to send my a link to my email everyday so I can access the database remotely. And if so can I modify them as well? Secondly lets say I create a database that emails links to it to the staff of a company. Can I make it so that each sent link is only for the database for a small amount of records. For instance I want to send out the records of tasks or jobs for a particular day. The database can send out the link and the user only needs to click on the link and go into FM and get only that information. In other words can I use email as …

I am fairly new to FM script writing, and am writing a script to (i) Import some records from an Excel spreadsheet into a table as new records in that table (ii) Set two fields in the imported records to specific values (but not change the field values in any records that existed prior to the import) Here is my problem. After I use the Import Records script step, I was hoping that the Found Set of records in my table would be only the imported records, and then I could step through the Found Set and use Set Field on my two fields. (Such a Found Set is what results from using the File -> Import Records -> File command). However, it seems that after using the…

Hi Everyone - This is my first (of many, I'm sure)post. So I have been working as a user and novice designer in previous versions of Filemaker for several years. I am now on the developer side of things and our company recently upgraded to 8.5. I'm doing my first design in here and, for the sake of learning, have been pushing this one pretty hard. We have the basic functioning up and running and now we're "fancying things up a bit". I was trying to take a tab layout and make it run scripts from the tabs. I've done the button part of things, but my script is the problem. I'm asking the button to search a group of records and show me only those with an "open" li…

I'm a relative newbie to FMP, I understand the basics of layouts and linking layouts. Also, we just upgraded to 8.5 from a VERY old version. I need to learn script writing. I'm trying to update our layouts and clean up the mess that we're working with right now. Is there a website that can teach me the basics? I've been through the help files and I'm just not getting very far. Any help would be GREATLY appreciated. TIA, Sue

Hi I am importing some xml and want to automate it so my script does (v.basic breakdown) this... 1>Custom dialog asking where the xml is. 2>Inserts this into a container as a filereference. 3>Sets a nonglobal variable ($xmlfilepath) from the file reference. 4>import xml, predefining the xsl file and I have put $xmlfilepath as the file for the xml. Its step 4 that falls over, When i check this script step it as defaulted over to http request. So I try inserting the $xmlfilepath variable as a calculation, when I run the script this time it will populate the http request window with the correct full filepath (filemac etc etc) but it throws up an…

I have two related databases ( parent = inventory ) and ( child = deliveries ). It works very well but I need a script where when a delivery is made it triggers an automatic email notification and attach a PDF copy of the delivery report. How can I do this ?

Hi there, I store temporary backup files of my database regularly and want to be able to delete them after so many days. I am trying to figure out how to use the Send DDE Execute script step (the program is for Windows) but cannot find any real information on how to use it. Basically, if I could get it to use the command line program, I think I know the commands to do what I want. Does anyone know how to do this, or at least, know of any good resources? Thanks, PerryL7

Is there a way to write a script that will edit a [color:red]specific value list? I have the lists setup so that each has the "edit" at the bottom of the dropdown. However, the user wants the ability to click a button and have a specific list open where he can add or delete entries all at once. I do not want him to have to go through the main menu of lists and have to select it before he edits it. I am not sure he is capable (I was hoping to create several buttons - one for each list and keep it in a "maintenance tab".

I have a simple script step Insert Current Date [] Is there a way to make that date bold?

Hello. I have FM Pro 8.5 and I'm trying to customize a FileMaker application (Donations 2.0). There is a portal with a list of rows (called "actions") and a button on each row. An "action" can belong to a Contact, an Organization, an Event, etc. The action record contains ID key fields for Contact, Organization, etc. My question is: how can I go to the appropriate detail screen for one of these related records by using just the ID field value? Do I have to use a Find and then a Show All (because I don't want to limit the related detail screen to a found set)? Thanks David

Newbie here. I have been given several tab separated text files that I have imported into FM. The records are set up with each person being repeated 4 times but some of the fields have different data. I need to get this data all in one row. Current look: Joe Smith address1 code1 validation1 Joe Smith address1 code2 validation2 Joe Smith address1 code3 validation3 Joe Smith address1 code4 validation4 What I need: Joe Smith address1 code1 validation1 code2 validation2 code3 validation3 code4 validation4 Hope this is clear enough. Thanks Dave

Ok so heres what I need to do, I have a many 2 many relations ship built between two tables Lists and Elements. I want to build a merge to new list feature. Whats the easiest way to do this. The new list should reference the existing Elements so changes made in the new merged list also appear in the original lists. Heres my current algorithm. 1. Create new list Get ID 2 Go to list Layout Select List to merge. 3. Begin Looping though selected. 4. Go to List Elements Layout. 5. Search for first List and get Element Id For each in a Loop 6. Go to many2many table and build link from new list to each element. 7. Loop back to 5. for each element. sea…

I am making payrole i want to restrict duplicate entry of worker.Can it be controlled by name of worker if it is reentered in the same month of same year?and how it can be controled?

Hi, I have a file with 100 records and I have found 10 duplicates records. I would like to be able to group the duplicates. 10 duplicate records, grouped with a unique id. Producing 5 groups. group ID's 1-5. I know I have to find my dup's first then sort them. I'm stuck on setting the Group Id field. How do I do this? Thanks in advance. Ghengis

I would like to be able to select a checkbox field in a record and get the contents of that field (ie set another field with the contents of the selected field) Is this possible? If I manually "copy" it works but if I use copy in the script it doesnt

Hi everyone, I am trying to automatically attach multiple files to an email. The send email says I can attach more than one file but if I am correct in my my understanding of this feature, it will look for the file in order of the list and stops once it finds one. I want to add more than one file, can this be done in a single email? Mike

I have a value list that gets its values from the Name field in the Clients table. In the Clients table, there is also a field Client Number. In a different table, I have a drop down box where the user can select a Name. What I'd like is to have the Client Number for that Name appear in a field in this second table. Do I have to relate these two tables to get this to work or is there another way? Thanks!

Hi, I have a customer table with customer ID (Number auto enter) as a unique key. I am writing a script which searches the customer table and brings the record with the MAX value of customer ID but this script doesnt bring any record. Below is my code for the script. Customer table is not related to any other table. Go to Layout["customer" (customer)] Enter Find Mode[] Set Field [customer::CustomerID; Max(customer::customerID)] Perform Find[] Sort Records[No Dialog] Go to Record/Request/Page [First] Enter Preview Mode [Pause] Enter Browse Mode [] Go to Layout [original layout] thanks

I can open a directory using Open URL function in sriptmaker. But how can I actually automatically open a file that is in that directory? I have s:/files (which opens) then I have doc1 which I need to open up. But I am not sure what to put after "s:/files" (is that as deep as the URL function will go? Can this be done?

Hi I need to be able to run a script once a week that performs a search for all outstanding work still out on approval that's more than 60 days old. I then need it to sort by customer and then email that customer just his work in a pdf file. The problem I have is being able to email the individual customers just there work unless I have 60+ scripts running one per customer. We do not always have oustanding work on approval for all customers. Is there a way that the script could seperate the found jobs into customers and then email that customer a pdf show just his work. Peter

Hi! I have a small problem or rather annoyance. I have a solution with multiple files and when using Go to related record script step with table from another file scriptmaker displays the wrong or unknown layout after closing the gtrr dialog - like this: GTRRBug? The script in itself performs as it should. What I am worried about is that this is a symptom of another more serious problem. Anyone else ran into this? Should I worry? (BTW: Recover does not help, save as compressed does not help) Thanks! /Tomas

Hello I have a Filemaker question concerning executing scripts when closing a file under File Options -> 'When closing this file': if I have a script configured to run when a file closes and the user does not expressly logout under normal circumstances (i.e. the user's session is closed due to Filemaker timeout or the user's PC shuts down, etc.), will the logout script still execute in these circumstances?

I have a layout that doesn't save changes automatically. I have a save button that does allot of validation and other neat stuff. My seamingly INSURMOUNTABLE problem is that when the user clicks outside of a field or button, FileMaker politely pops up a dialog asking the user if they would like to save the record, bypassing any save script I might have. For Me this is a HUGE problem. Is there a way to turn this off? It was suggested to me that I put a big button behind everything on the layout. Out of desperation I have incorporated this into some of my layouts but I'm certain there is a more "Professional" way to go about it without having a Black Flashing Backg…

Right now I have the database set up to only allow users to see records according to username. What I am hoping to do is when they login in I want the it to open up their employee page. I have tried a couple of things but no success. So if their username is sunshine then when they login into the database it takes them the sunshines employee page. I tried creating a script so that under file options I could have it run the script but I am not having success.

I am trying to get a record number of a record that is inputted. Example get customerid than find record then get recordnumber( place) then go to the record number

Right now, I have a field that sometimes has multiple names entered, each separated by a newline. My goal is that each of these fields has just one name entered, and I'm working on a script that would make a whole new record for each of these extra names. I'm trying to use the Position function find where one name ends and a new one starts, but I don't know what to use for "searchString". Any ideas? And if there is an easier way of doing this that would be great too. Thanks!

I'm trying to figure out how to set up my scripts (or other solution) so that when users sort the records by user inputable field "category number" which is a number that falls between 1 and 10 the number 10 category shows up in order (after number 9). To get around this I've been having the user put in 01, 02, etc for the category so that when sorted category 10 will fall after 09. Anyone know how to get around having to put in the leading "0" and still have category 10 show up after category 9 when doing a sort?

What im trying to do is click on the Route botton and have the system send an email to only the individuals that have a check under thier dept. I hope this makes sense. Thanks

After many, many years away from FileMaker... I'd like to launch a script that is triggered by a field's validation (i.e. the user TABs out of the field)...but the clostest option I see...might be using a custom funtion to somehow run a script(?) In other words, when the user TABs-out of this field, I want a script to launch, and I'd like to know the best method in which to implement this. TIA Mark H.

Hello, To give a little background on what I doing, I am developing a database to track alumni who have started companies. The alumni and companies each have their own table and I created a many to many relationship with a portal on the alumni layout that displays the company information. On this portal I have a button that opens a new window so that a user can insert a new company. This is needed so that they do not need to switch back and forth between company and alumni layouts. The script for the button is as follows: New Window Go to Layout [New Company] New Record/Request Go to field [Company Name] The problem is the following. I need the…

Could someone please take a look at the following script and see what's wrong: Open is a field in Parent that counts the nbr of “empty” child records in CHILD. I want the script to do the following things: If Open < 10 Go to CHILD table Create new record, put “A” in Source (in Child table) Repeat the above step until Open reaches 10 When Open reaches 10 Stop the loop and Exit. Expl: If Open = 6, when triggered the script should create 4 new records in CHILD. The script: IF [PARENT::Open < 10] Go to layout [CHILD] Loop NewRecord/Request SetField [CHILD::Source; “A”] Exit Loop IF [PARENT::Open = …

Hello, I have a "entry" menu that has the dept name. Each department has (or will have) an annual report. I can't get the script correct (with the variables etc) to go from the Com button to the Com report. Could it be that I have to make individual buttons and scripts per department? I have tried to understand all the recent posts about scriptparameters, but I am seriously lost now. Any guidance would be greatly appreciated. Thanks mucho in advance annual__blank.fp7.zip

In many years of using FMP and designing FMP DB, there has been probably a handful of occasions that somehow a script step is scaped and not implemented as expected. One of the very basic example of these occasions, is when FM is asked to enter a "Find Mode" and suddenly finding the script in browse mode instead, scaping over the request ?? and as a result unwanted results is encountered. I have very carfully studied this process and there seem to be no other explaination. I use FMP in multi-user environment with mix of PC and MAC and FM Server 8. Any suggestions ? Now I now that I can always use an "If" statement to make sure I am in "Find" mode, b…

I have a question on the time stamps. In our "notes field" we place a time stamp for when a person calls in, then lets say a week from now we need to place a new time stamp for the new note that we need to enter. The problem I am coming across right now is the time stamp is erasing everything that was before it and putting the "up to date" time stamp there. The question is how do those old timestamps stay there, when I hit timestamp a couple days later. Any help would be greatly appreciated. Thanks.

I'm stumped once again. I'm certainly greatful for all of the help all of you have provided in this forum. I'm looking forward to the day I can be answering questions instead of asking them. Topic at hand, I have a drop down list and cannot figure out how to change the color of the slider once the list is long enough to scroll. Thanks, Mel

Hello All, Ive got the data in my records just about cleansed. A have one field in particular with lets say the following details. ENG_1R (AEB ) MAT_3D (AJK) LAT_2Y (AJK AEB ) IT_2I (UAE ) I would like to remove the space before the bracket ends so record 1,3 and 4 would have the endings (AEB),(AJK AEB) and (UAE). Ive created a looping script with the TrimALL command but that removes all the spaces. Anyone have an idea of just removing the spaces in the brackets. Thanking all of you guys in advance.

Hello If I click in a portal field and change its value, Get(RecordOpenState) evaluates to 2 as expected. However, if I script: Go To Portal Row[select; First] Set Field[related:field; "something"] after the script has completed, the record is still open (I can revert it) but Get(RecordOpenState) shows 0. This difference in behaviour doesn't seem to be indicated in the FileMaker Help entry for Get(RecordOpenState). What am I missing? Thanks Simon

I'm building an image library and think this may be so common that it must have been done already. The image name is imported into a "Name" field, and we would like a "Description" field to be based on the name. The way these files are named is something like "SixWhiteMice.jpg" and I would like FM to recognize capital letters in the middle of a word and put a space before each capital letter. Final result should be Six White Mice in the "Description" field. Has this already been done? I would hate to reinvent this particular wheel. ~ ~ ~ ~ ~ ~ ~ FREEBIE ~ ~ ~ ~ ~ ~ ~ I have a "remove extension" script, which works like this: If [Right…

I am stuck. trying to write a script that validates the email address that the user enter's into my iwp. all i want to do is check to see if there is a "@" sign in the field somewhere. I have used position and length with the right and the left text functions, and i can't seem to get it to work. any help would be appreciated Thanks Tina

Hi, I have a file with 100 records. I would like to create a random number and then mark every 2nd record starting from the random record. I know how to create a random record (see below) GetNthRecord ( CountAndMark::ContactID ; Int ( Random * Get (FoundCount ) ) ) but I'm have trouble looping through all 100 records starting from the random number and marking every second. Please help. Thanks in advance Ghengis

I want to find out why it takes a certain script to finish. Is there a way to calculated the elapsed time from start to finish? USING FILEMAKER 6 Thanks in advance

My apologies to everyone if this has already been discussed. I want to use a variable across two different FM8.5 files - File A (holding school pupil contact info) and File B (holding invoices / accounts). The files are separate (and not tables within the same file) for a good reason and I don't wish to alter that. The files are related remotely however - the pupil ID being the 'key'. I want to pick up the pupil ID (the key) in File A and place it into an invoice layout in File B. I currently have a script in File A that contains a subscript. The main script sets the variable (the ID field in the Teaching file) - the sub script opens the File B, goes to the inv…

I'm using FM 8, Win Vista. I'm having a lot of difficulty using Getsummary functions. I need to use them because I need to calculate values based on Summnary fields. For example, can they be used in trailing grand summary parts? Sometimes they appear to calculate properly, other times not. I've attached a complete description of the program I'm preparing as well as screen shots in layout and browse modes. The only issue is with the TaxCredit calculation. It does not work correctly in either the subsummary or training grand summary parts. It does use the related field TaxRate and I wonder is this causes a problem with Getsummary calculations. Program_to_calculate_the…

hi there! in my db solution we have a layout displaying data from a contact table (address, name, etc.) and form the contactLog table. what I need is the following: I'm doing a find within the contacts and then I want to add a new record to the contactLog of each of the found contacts with the exactly same content. example: I'm putting together to print their address labels out for a mailing. I want to add to the Log of each of these contacts that Mailing x on day y was made. How can i make it easy for my db users to do this? Thanks for your help hans

I appreciate the FM Gods sharing their wisdom to help. Have created a line item list with date fields. Would like to generate scripted reports (monthly, quarterly, yearly) of the line items. Have created calculated fields to get first day and last day of month, qtr and year and a field to combine the dates (1/1/07...1/31/07). My problem is how to get that calculated field into the find window date field. Have tried copy/paste. Doesn't work. Has to be a better way.

Hi, I have a layout used to enter products in a invoice table. I have put a portal on the layout that lista all the products that we sell. (Not to many) I have put a button on the portal rows that when clicked it will insert the product key into a repition field as if it was selected from a dropdown list in that field. I think that it is a Case step but can't get the syntax correct. Basicly it needs to do the following: 1) Click the product button 2) Insert the Product id into the first available empty repetition field (1 through 10) 3) the rest of the fields(name, description, price) auto enter through relationship. The reason it needs to be this way…

I want to have certain fields populate when I exit a another field is filled, it can't be done through a lookup. I just need to trigger a script on exit of a field, can this be done?

Hi there, I am wondering if there is anyway to test for a connection to the internet. I am working on a script, where if internet access is available, will go to a website, otherwise it will go to a FM layout. I know about "Get(SystemIPAddress)" but I am going to be on a LAN, so I would get a system address as long as I am connected to the router (not necessarily the internet). Does anyone have any ideas? Thank, PerryL7

Has anyone heard of a way to get FileMaker to recognize a Left Click from a Right? Thanks, Mel

Hi, Calling all experts, please help - really stuck for a few days now..... Am building a touchscreen layout and I'm stuck on 2 buttons. I have all the alphabet and numbers being inserted into fields via the [insert Text] command. How do i recreate the Enter/Carridge return key and also a backspace function key on a button, reproducing the same results as if a keyboard was present. Thanks, Roy

I have a database of laboratory Orders which is linked to a table of Companies through the shared field, Vendor. Companies includes fields for Vendor, Street, City, etc. I originally set up the Orders table with the relationship between the Vendor and included the Companies fields for Street, City, etc. on the Orders table. This all worked fine and automatically populates the address info on Orders as soon as the Vendor is entered. Unfortunately, as addresses change or companies merge, I need to change the data for Company records and, as currently set up, this changes the data for any Order records that use that company. I am about to change the Order field to a…

I have a db that when it opens it is scripted to goto a container field that has a sound file and play that file via the select/perform function. It works just fine running in FMP but as a runtime it doesn't work. Any ideas? Greg

I suppose this has some scripting element to it, i always get confused with plugins... Oh well, the issue is that i'm obviously trying to integrate an auto update on start up, but the problem is that i can't even get FMSAUC_FindPlugIn ( "EventScript" ) or FMSAUC_FindPlugIn ( "EventScript.FMX" ) for example to evaluate. I've put the plugin into the autoupdate folder on the server in the same folder as my database and still no luck. What i should probably mention is that this is being evaluated from the front end of a solution. Cheers for any help, ~Genx

Greetings. I am new to FM and am having some difficulty using script parameters. I tried searching prior topics to find the answer I'm looking for, so forgive me if this is redundant. I am trying to use script parameters to pass multiple variables and everything seems to work fine except for passing the value of a field. I have a button that when activated will call a script to go to a different layout than the current one, create a new record, and pass along the primary key to the foreign key. In the script parameter dialog box I have entered the following: "id = "trade:__kp_tradeID"; layoutName = "letter"" "id" is supposed to store the value of the pri…

I have a layout that has several drop down fields. I would like the cursor to be hidden after each drop down selection instead of moving in tab order. I've tried setting NO tab order but then the drop down list stays on the field the user has selected. It would be GREAT if FileMaker would let you put an object in the tab order but I've found no way to do that. I've tried putting a dummy field in the layout and setting it as the only tab order field. This would work except the field is highlighted on entry and of course shows the cursor in the field. Any ideas on how I can get rid of this cursor?? Thanks, Mel

Hey, Folks - I've run into a problem I can't solve. Background - I have a huge solution file with a full user interface used by multiple organizations. The problem - Presently, when users are in a given module (say, "Workshops"), they click a "sort" button to pull up the FileMaker sort dialogue. Unfortunately, this gives the user thousands of fields, most of which are used for the UI and mean nothing to the end user. The goal - I want to set it up so that when the user clicks the "sort" button, he is brought to a layout that contains 3 popups (gSortField1, gSortField2, and gSortField3) and 3 radio button sets (gSortField1AD, gSortField2AD, and gSortField3A…

Hi Everyone! I Have no idea how to perfom this script. I have a Radio field for customers who are 'Reseller', with radio buttons "Yes" and "No". I want another field called: 'Sales Tax Rate' to calculate itself to add a sales tax value of .0825 for non-resellers and 0 for resellers Basically i want the field 'Sales Tax Rate' to: if [ ( Reseller) = "Yes" ] return a 0 to field 'Sales Tax' else return 0.0825 to field 'Sales Tax' Sorry if my coding is cheap im just a beginner.

I know that they had talked about building in the ability to trigger a script on field exit. Does anyone know if it's in there?? I don't see it.

Do you know how to parse out text from a field that has a huge amount of text. Each paragraph begins with a date, where I used a nested substitute calc to insert a "|" before each occurance of a date. Now the task is to create a routine that would copy each paragraph, and create a new record from those paragraphs into another file. Can anyone lend a clue please?

For my database if I wanted to place an order from a consumer's profile page, what is the best way to pull all their information from their profile into the order form? Ideally I'd like to be able to change contact information in the order form as needed.... but not always. I don't want to get locked into the information that pulls over. Thanks!! You guys are so helpful

Hi, I am new here. Could anyone tell me how to write the scripts that generate the serial numbers from “1” everyday? For example, “20070717-001”, “20070717-002”, “20070717-003”, “20070718-001”, “20070718-002”, “20070718-003” and so on. (2007 is the year, 07 is the month, 17 is the day. and the -00X is the serial numbers.) Thanks

Hi, I want to import a file into filemaker, do a record count and then split the file into seperate databases depending on a chosen number. Then I want to merge them into one database,keeping the order that they were imported into, and export the file as a csv again, keeping the same order. The bottom line is I want the ability to have an csv file and then duplicate and reorder the csv based upon the number of times the record needs to appear in the output. The output file is then used in a print layout software. I hope this makes sense? If someone could point me in the right direction I would be very happy! Thank you

I've got a section of a database where I am storing an image as a file. I would like to be able to click a button and have that image display into a container field. Thus far the most I can do is copy the file field and paste it into the container field, but that just puts the image icon in. Thoughts? -Matt

I'm trying to create a script that will look at all of our records and omit any duplicates. I know that I need to loop through all of the records and look at the address field but I don't know how to set the omit to remove the duplicates. Thanks for your help.

I was trying to modify the duplicate portal records of a found set of the original records themselves + the duplicates to distinquish between each other. I couldn't get the next record, exit after last function to work properly and came up this work around. (see attached) Does anybody see how this script can be improved? Script_question.pdf

Is anyone else encountering this problem? I am using the separation model for my solutions. I have noticed that at least on my laptop running Mac OS X 10.4 that the script step Go To Related Record refuses to display the destination layout if none of the tables reside in the file where the script step is being called. It simply displays: "Unknown" The script step does work even though the destination layout is not shown. If you edit the script step you can see the correct information. you just cannot print it out. I have provided a sample solution for others to review to see if they can see the same error that I do. Simply open the GUI file and open …

I have a situation where I pass script parameters to a local variable to run subscripts depending upon the user's preference for output type. This technique works fine in one database but won't work in the other. I have "Report Selector" layouts in both databases. Each report selector layout and the output layout are based on the same table respectively. There is a global field called [gOutput_Choices] in each table that displays as a radio button value list, (View, Print, PDF, etc.) Whichever option is selected by the user is passed as a script parameter to the set variable, ($Print_Choices), script step which will cause the appropriate subscript to execute. Usi…

Hi all Trying to learn something and I am proving that I am a slow learning. I have read so many times of this forums about the script parameter function and I am trying to understand how it works. I have read and reread the FM help file a dozen times and I do not understand how to pass a parameter to a script. I have included a sample file of what I am trying to do. I have attach the script to the four buttom on the sample file and want to go to the layout as noted on the button. Could someone lead me in the right direction of how this is done. Tanks in advance Lionel script_parameter.zip

I have been asked to create a database that will serve as storage for annual report for various departments. This will be accessed thru the web (IWP) and updates to each report could be done via the web. My boss would like to make it very user friendly and have buttons like Save Changes and Cancel Changes. The Save Changes is basically commit in my opinion. How do I cancel changes? So if a user goes into a report (that they have access to) make changes and then change their mind and hit the Cancel Changes button, what would my script look like? Do I have to store their editing in temp fields first and then when they hit Save Changes button, commit them to the …

This probably gets asked all the time, but is there an equation that would allow me to enter a quantity in an item field and in the quantity total it would multiple that number by 8 or 12, etc.? i.e. 1 six pack = 6 beers in the total?

I have a list layout with about 8 fields. I am trying to make a sort script that would sort the records based on the field a-z and z-a. I can accomplish it by writing two scripts for each field one soring a-z and the other z-a. I have arrow graphics to with I attach the sorting scripts however is there a better way then writing two scripts for each field?

I'm new, so be gentle. Database created from the asset management template in FMP Advanced 9 to keep track of computer installations at 9 locations. The View Inventory script works fine. But I want to modify it to be able to click and have it present me with an inventory list as each location. Where the script says "Perform Script ["Sort by Category Ascending"], I changed it to ["Find"; Parameter: Asset Management::Site] I can't figure out how to tell it which site I want to find the records for. It could be that I'm going about this in an entirely backwards or awkward way, so enlightenment is encouraged. Thanks.

Everyone has there own way of getting around the single parameter limit that FileMaker restricts you to. Here is a complete description of our solution. Please add your different techniques and comments on ours. Our solution involves passing parameters using name/value pairs.... so basically whenever you want to get something out of the script parameter... just ask for it by name. ie. GetParameter( "ProductName" ). Pretty Simple. Here's the post with a complete description of the technique: Named Paramters

Hello all, I'm an accidental techie looking for help. I am working with a database that has a separate layout for each month of the year (January2007, February2007 etc.) and I would like to create a script to use at opening that would take the user to the layout that corresponds with the current month. Something along the lines of, if the current month is June, go to June2007 layout. I have tried some options but clearly have no idea how to pull this one off. Thanks in advance.

When I try to add a new group it gets added inside that last group at the bottom of the script list. I can't move it to the left to get it out of that group. Same if I try to add a script or separator. Is anyone else having this type of problem? It seems quite flaky.

hello .. i am looking for a little help ... i have a global field that i put a number in (ie 750) i then want a script to create 750 new records. any ideas?

Hi, I'm having trouble completing a script that will go through a table and check off in the radio button. The field I'm investigating is state abbreviations where the radio button "US Resident" will be marked off as 'Yes' or 'No.' The times that I have tried to run the script has not produced the intended result. Loop Go to Record/Request/Page [First] If[tour::Partner State="AL" or "AK" or "AS" or "AZ" or "CA" or "CO" or "CT" or"DE" or "DC" or "FM" or "FL" or "GA" or "GU" or "HI" or "ID" or "IL" or "IN" or "IA" or "KS" or "KY" or "LA" or "MA" or "MH" or "MD" or "MA" or "MI" or "MN" or "MS" or "MO" or "MT" or "NE" or "NV" or "NH" or "NJ" or "NM" or…

Hello, I'm trying to do an Open Script for my database, that is quite simple, but it isn't working. I want to hide the Toolbar and the Status Area when I enter a non-Full Access login. Any login I type, Full Access, Basic Access, or else, shows all the toolbar and the status area. What could be wrong? I Atached the image of my OnOpen Script and a script called Unlock for development, that is a part of it. Thanks for help!

hello out there I have a few questions. Which way is the better one for scripting? Should I use one big script for my database? I jump then to the right position with scriptparameters. Or should I have many little scripts which I call like the normal way when I need them? What is better for the performance of the database.

Hi All, How can I find a date range in multiple fields? Example...I have 24 date fields and I have to pull all the records between 01/01/2007 and 01/31/2007? I have to do this for each set for each month. Please help! ;)

So, I've got a fairly large, complex database. There are 10 users. I have 2 front end layouts, one for Administrators, and one for end clients. What I would like to happen is that when the DB opens, it runs a script that will take the username and determine WHICH layout to drop them into. Any takers?

I was looking through the scripts and functions and was surprised that I cannot set the color boundary or background of a field. Is this correct? You can change evrything else, like the size, type or style of a field. Thanks for any tips or directions.

My confusion is in how to handle the logic and syntax of multiple branching events. I am developing a POS touchscreen system in Kiosk Mode for a golf course. No keyboard input. When a member's card is scanned it is entered into an edit box using: Insert Text[select;Transaction::Member_ID] Now I have a 5 digit unique member number. This in turn generates a 3 digit MTypeIDLookup number which indicates the type of price the member will pay when the transaction is selected. The member could be a Regular, Senior, Student and Others. Now comes my confusion...How do I script this? 1 - Has member renewed this year? If[Member::RenewalDate<01/01/2007] …

I'm a newbie and I'm stuck AND feeling quite stupid. I have a script that goes to a portal (of self-related records) on a layout, directly to Record#2. (Go to Portal Row [select; No dialog; 2]). The script then continues to loop through portal records and perform additional tasks. However, if record #2 doesn't exist (that is, there is only one related record), I want to abort the whole thing and generate an alert message. (If Record#2 doesn't exist, it indicates another problem that needs investigation.) I thought I could just trap for an error, but it doesn't appear to generate an error if there is no second record. It just continues on, even though it hasn't b…

How can I open a database without the start up script running (the one configured under file options)? The problem is that I need to edit the database but that script automatically exits out of the file. Thanks, Moses