Script Workspace and Script Triggers

I know there is relatively seamless integration in FMPro for opening up a user's Email application to send an email from a record with an email address field, but with so many people accessing webmail like Googlemail and similar, is there ANY integration that works for this type of user? If there, is could someone kindly explain how this could be done? thanks!

I am writing a script that takes a parameter which is part of a field name (eg. BusDev ) and then builds the field's full name, looping until it generates a field name that doesn't exist. Completed_BusDev_01 [ perform calculations ] Completed_BusDev_02 [ perform calculations ] ...repeat... Until you generate a field that doesn't exist and drop out of the loop. I have tried to break out of the loop using IsValid (ie. Exit Loop If [ not IsValid($completed)] ) and IsEmpty (ie. Exit Loop If [ IsEmpty($completed) ] ), but neither one works. The loops continue well beyond the existing fields until I break out of the loop manually via a custom dialog option…

Hello , I would like to know how to set my script to go to specific layout if the last character of the field that im searching is 2? example: if im searching for " 2245-2" ... go to layout "2" if im searching for " 4587-3" .... go to layout " 3" hope you understand, thanks for your help. mauricio

I'm trying to collect numbers in decimal format into a variable, but I can't make them look in the decimal format I need. Say: 2.150 0.123 4.000 The "look" I need is 3 decimal places and if it's less than 1 the 0 before the point. Now I get: 2.15 .123 4 and I need: 2.150 0.123 4.000 I have tryed substitute, setprecision and there is where my knowledge ends, lol. Any idea? Thank you.

Hi, every one. I have a problem with stock transfer. I have a product table, order table , and stock transfer table , this table related with PK to each other. My Problem: I want, when create a order, when a product out of stock (in stock transfer layout according order number), I can see this change in order table, for example color of this product change to red or status of this product say SEND. thank you for help me.

I am trying to write a script to save an Invoice pdf. Manually the steps are: Step 1: Go to Layout xyz - xyz layout is a list layout, based on a Lines Table. on layout xyz there is a find script that selects all lines related to an InvoiceID. Step 2: Set field g_Find_InvoiceID - this is a drop down value list based on a field, c_Find_InvoiceID that finds all Invoice ID Step 3: Run script This script is: Enter Find Set Field:(INVOICES:: kp_InvoiceID; LINES::g_Find Lines_InvoiceID) Perform Find Step 4: I save as pdf Is it possible to automate these steps from the Invoices layout where the g_Find InvoiceID is automatica…

Hi all. I was hoping that the new ability to run a script from a URL, specifying parameters, could help me finally to launch a FM script on a different computer (host or client). If I understand correctly this is not the case: the "FMP://192.168.10.0/filename.fmp12?script=scriptname" will only run a script on the same PC on wich you send the URL (from web browser or other), specifying the IP address of the host. What I want to remark is that FINALLY it is easily possible to create records (or other things) from an external application, as long as it can compose an URL, sending a "do script" with the appropriate parameters. Before you had only Applescript (…

First off, I am very new to FileMaker, but want and need to learn. I am trying to create a script that will check if one field has a Yes entry and will also only return entries for an event that is in the future. I have been trying multiple solutions using the Get ( CurrentDate ) function but still have had no luck. Here is one of a couple of scripts I have tried that won't work for me. The scripts will narrow down the "Web Published" Field but I can't get the > CurrentDate to work. Go to Layout [ "LayoutX" (EVT)] Enter Find Mode [Restore] - (specified to EVT::Web Published: [=Yes] Insert Calculated Result [select; Date Start 1; " > " & Get ( CurrentD…

Hi everyone I have three fields which are set not to allow data entry in browse mode. Occasionally I need to be able to edit these fields, so I have to switch to layout mode, select the fields, check them to allow data entry, go back to browse mode, make the changes, back to layout, change back to disallow data editing, back to browse mode. It's all a bit of a hassle. Is there a way this can be scripted? Many thanks Milt

I have a dropdown that I'd like to be able to change with the arrow keys, then you press enter, it commits the value, and runs the script. Instead, when I press enter, it uses whatever the value was before I chose a new one in the dropdown, and runs the script. The script adds a line item at the end of an invoice portal, currently with the wrong value (unless I click, but I'm trying to get around using the mouse). I'm sure there's something simple I'm missing here? The following script runs on keystroke: if(get(triggerkeystroke)="paragraph (symbol)") Commit records/Requests [No dialog] Perform Script ["allocate] Exit Script [result: False] So, t…

Hi everyone, I have 2 fields called OwnerDate and TenantDate and I would like to use these 2 fields to create a popup reminder when it is 60 days prior to each of these dates. There are approximately 300 Owners and Tenants that would need to be checked. I would envisage that the script would run either at start up or by selecting a button. If anyone could help with examples, I would really appreciate the assistance. Thanks in advance for any advice or assistance.

Hello, I generate a fairly large number of invoices every month. Each invoice has a unique number and I currently save four separate electronic copies (customer & remittance copy, accounting and department copy). I'd like to automate all of this. Here is what I would like the script to accomplish in my fantasy world: - Perform a find with a box that pops up allowing me to specify the parameters of the find request from specific fields (I can do this manually as well, but am hoping to just make this part of the script) Once I have this found set of records, I would then like: - To save them as individual .pdf records to a specific destination o…

Dulcolax isn't the answer, here. What I want to do is enable a user to click a button on a layout (Object Name "Home_button") that will take him/her--by way of a script--to the Home layout along with changing the Page Setup to portrait; I'd like to use this scheme for a number of buttons that go to different layouts that have different page orientation. Where I'm having trouble is setting up the command string in the Optional Script Parameter field in the Specify Script windoid; I tried a number of different permutations of commands but just find the right one. I know the first problem is that I can't use the Get (ActiveLayoutObjectName) command on a button…

Hello , i have POrders layout with some repeating fields, now when i try to start the script to copy some fields to a related layout , why the script only copies the first row of the field? im doing something wrong? here i attached you the sample, thanks for you help POrders.fp7

I have two drivers for my laser printer, one to print to tray1 and the other to print to bypass tray. I would like to have a script that prints to the bypass tray but then resets the FM default printer to the tray 1 printer so I don't have to reset it manually. I've tried a script that uses the print script step to print to the bypass followed by a printer setup script step set to the tray1 printer. However, it does not reset the FM default. I still have to select it manually. Any suggestions?

Hi everybody, hope someone can help me. I have a field(phone field) where I have set it to only unique value input. When I key in data into this field and if the phone no already exist I have this dialogue box popping up that says " (Phone no) is defined to contain unique values only. You must enter a unique value" [Revert] [Ok]. What I want to do is to suppress this message box and prevent it from appearing and using my own custom message box instead. However I don't seems to be able to identify the error codes. When I researched around, there are information indicating that this could be error code 504. But when I tried to capture this error(i.e. Get(LastErr…

I have some questions about Server-side scripting. All concern my problem with record numbering. In the topic on this matter (see: http://fmforums.com/forum/topic/83982-continuous-numbering/ ) I was suggested to write the script on the server side. I enclose a simple example in the attachment. I would be very much obliged for your opinion on it. Main guidelines of the example: 1) The script must be operational round the clock. 2) The script reads a line from table T2, processes it (adds values of the fields AAA to BBB) and writes down the sum in the field CCC in the table T1. 3) The script deletes the processed record in the table T2. 4)…

I would like to make a script that would create a directory of aliases to clients project folders. My staff members need to access clients working folders to save projects in. All of the clients folders are in a share on our fileserver. What I would like is some kind of script that will make a directory on a share with the staff members name, then fill the directory with aliases to that staff member's assigned clients' project folders. I do have a relationship from the clients to the staff members and I have a calculation to the clients folders. I have used scriptworks 360 Scriptmaster to create folders in the past, but I am not sure …

I have a list of invoice dates. I would like to mark the invoice date record that is the closest to calendar month end date. I'm not sure how to go about doing this with a script. Any help would be appreciated. Invoice Date Mark 3/1/12 3/13/12 3/29/12 X 4/6/12 4/19/12 4/30/12 X 5/2/12 5/11/12 X INVOICEDATES.zip

hi all, i have a couple scripts that are meant to be looped every 3 mins. it involves downloading some data from some url, so my FMS cant do that. i had to resort to Windows 7 task scheduler. Quick question, how to setup that including the account and password to be keyed in automatically? i know i can work around that by leaving the FMP on. but i have a save as pdf script too needed to be run at certain hour. prefer not do so by setting up a 'live' clock in the layout and triggers. any clue guys? regards

I have 36 records in a found set, each with an email address. I have created a script with the intention of presenting a single blank email email to the user with all of the email addresses from this found set in the BCC field, and with a 'no reply' email address in the To field. The intended result is a single blank email presented to the user with all the email addresses from the found set put together in its BCC field so that one single email can be created and sent out to all of the BCC addressees. However, on executing the script, my email client produces a blank email for every single record - all 36 of them. Like confetti. All over the screen. It's like wi…

In a script I want to do a find, sort, print etc. I want the user to be able to choose multiple values to find, sort and report on. For example, for students grade reports, I have a field called grade. If the user wants a report on grades 1, 3 and 6, I want them to be able to choose all three at one time. How do I handle that? Even more, we have two classes per grade. For example the third grade would have 31 and 32. I may need a report on all third grades and 51. Any help? (The last part isn't as important as they can choose 31 and 32 and 51 if someone can tell me how to do that). Thanks Mike

Ive got this table with Field B and Field C, and another FieldA on another Table. I want to match FieldC to XXXXX then with the matching record, take fieldB contents and put it in FieldA... in SQL it would be something like Insert into FieldA, value from FieldB where FieldC = XXXXX. So sorry but i think this is something very simple... but my unfamiliarity with the concepts of the scripting in FM is giving me a bit of a learning curve. Hope someone can help.

I'm not sure where to post this. A zip of the file is attached. Running the script "Show Prime Record" sometimes produces the error message "This record cannot be modified in this window because it is already being modified in a different window." The script is triggered by the button after the "Prime Record" fields at the bottom of the initial window after opening the file. This seems to occur almost always on opening up the file, but sometimes after that as well. Anybody got any ideas what is going on here? Thurston County 12-2-00032-5 Oak Harbor v. WWGMHB, IC, WEAN copy.zip

Not sure if this is just an FM12 issue but don't know where else to post. I have just started 'sharing' my solution and am working through a number of issues. I like the way screens are synchronized when host/clients have the same layout displayed and one or the other makes a change. It seems to work - most of the time. A key layout in my solution has global variables in the layout Header that are calculated each time the screen is updated. When the body changes on one machine, the body changes on the other. But the headers are not updated leading to mis-information being displayed. Before I undertake some massive database, scripting and layout changes, I w…

I have the beep sound in one my scripts and it just doesn't sound. I tried to run a script with just the beep sound and still nothing. Is there a setting to enable sounds. The speakers are on and the volume is up high? Any thoughts?. Thanks so much.

I am using FM 12 advanced. I put a button on my portal that opens a layout that allows the user to specify a Start Date and an End Date. These two values are collected as gStartDate and gEndDate (global). Then in the portal I specify that Dues::Date >= gStartDate and Dues::Date <= gEndDate. This works. But, there doesn't seem to be a way to 'unfilter' the portal via a script? ?? I tried changing gStartDate and gEndDate to "" but that just shows nothing in the portal. I tried putting '01/01/1900' as gStartDate and ''12/31/2050' in gEndDate and this works. But, I have a merge field that shows the filter dates on the portal and it loo…

Hello! I am building a custom database for a delivery/trucking business. There is a field with the current zip code for each driver (record). I would like to create a querry that will allow me to enter a specific ZIP code in a search field, and based on that to find the closest Driver (record). It can also be within a radius of 50, 100 miles and so on.... Probably the easier way would be relation with google maps... Any sugesstions? Thank you!!!

I know this sounds silly but I’m having trouble grasping a loop function for what i am doing. I have written a script that imports from excel to a specific table works perfect , imports all the data I need as individual records , Great awesome. Here is the problem I cannot get them to relate; when the script starts I create a variable and copy my id for the parent record (Works no issues) I go to my separate table and request a new record (Works no issues) I set my field and deliver the id to the record (works no issues ) I import from excel ( Works no issues). This is where I have the problem I can’t seem to get the script to insert the id into the imported record…

Hello, I'm very new to Filemaker and am having trouble coming up with a script for locating previous records with entries in an ID field that are similar to the current entry. I have only seen threads about identifying duplicate records or using multiple fields to locate similar records. Here's the background for my problem. My database contains records of salamander captures, where each salamander is given a unique "code" (or ID) that allows it to be identified when it is re-located in the future (to track growth rates, movement, etc...). Each code is a unique color-position combination and each salamander is generally given up to five colored marks in any o…

Dear all, I have 2 tables main Table Names Total sales 2nd table Items Names total Value 2nd table::total value is a calculated field through some self joint relationship. i am trying to make a script to capture the total value and setfield to Main Table::Total sales by matching the names ofcourse this is a simplified version of the table. it is on a 50k records database. I am doing this is because i am trying to switch over from all unstored calculation fields to script based batch run so that i can increase the performance of the database because it is really slow now. regards

Does anyone have an example of a script to split email recipients (customer records) into smaller groups prior to emailing? My found set has maybe 500 and I want to split into groups of 50 or less in order to not annoy the ISP or be blacklisted as a spammer. I used to do this with a scrip in Entourage called 'split recipients'. Now that I've "Upgraded" (ahem) to Outlook I'm unable to do this, so its up to FM to save the day. Thanks Phil

FMP 11 client running on Mac OSX 10.6 FMP 11 Server running on MS WIndows Server 2003 I use the old but functional joinPDF command line tool from <http://download.cnet.com/joinPDF/3000-18483_4-36691.html> to automate the joining of multiple PDFs into a single file. The specific script step is: Perform AppleScript [tell application "System Events" do shell script "joinPDF/Users/Shared/FMP/mailing.pdf /Users/Shared/FMP/subrecipient-*.pdf" end tell] The command joinPDF/Users/Shared/FMP/mailing.pdf/Users/Shared/FMP/subrecipient-*.pdf works perfectly when entered directly into Terminal but fails as a FMP Perform AppleScript step with two error messages: …

Anyone know if there is any different limitations on server-side scripting for this version of server (ie allowing save as pdf)? I've got a few looping robots on a few machines and it looks like I'm going to have to buy a few fms 12 and fms 12 adv licenses since I use two separate instances on each robot machine (2 full-time looping scripts) and fm 11 won't connect to fms 12. This upgrade is getting expensive...

I am having a problem with importing a text file with the import records script step. I keep getting the error “the file cannot be found…”. I’m using the relative path approach and I’ve even tried using a full path. Both the target file and the FileMaker file are in the same directory. The file format for the target file is file:File Directory\Test.txt (although the example files in the Specify file dialog shows forward slashes!). I’ve attached a sample files, including the Filemaker file and the Test.txt file for testing purposes.I'm using Win 7, 64 bit. Any suggestions? File Directory.zip

I have several .png images I've placed on a layout as glossy tabs. The problem is when you click on a tab the background turns black as if it were a rectange rather than a tab.. Is there any change to change it so there's no color or the color is white? If I stick the tabs on a black background..."on click" the background behind the tab changes to white... there just seems to be no easy solution.

hello, sorry if this is the wrong subforum, I'm new to filemaker. the point is, I got a quite big file, and every line links to a soundfile. now half of the files were converted from an old format to .wav filemaker can´t find half of the files anymore. I couldn't find out how to batch-rename, plus the old format had no extension! so I need a batch like: if the path of the file has no ".wav" at the end, add ".wav", if there is ".wav", don't do anything" or some kind of "ignore file extension" function. is this somehow possible? thanks alot in advance, torque

I may be in the wrong topic forum here. This database is used by "Users" who add new records to the database each day. At the end of the day I want to lock those records so they can't be modified by the "User" the following day. There is an "Admin" login (Username: Admin, Password:Admin) for full access to all records, and a "User" login (Username:User, Password:User), which should allow new records to be added but old records can't be modified. To do this, I've created a "Lock" field that defaults to 1 with each new record. At the end of the day, the Admin changes all the lock fields to a 0 using a script (see script). Then the custom privileges for "User" is suppose to …

Hey All, I'm wondering if any of you have run into this problem? I am calling "Replace Field Contents" in a given found set, I'm setting a number field that contains 0 to 1. I can go in and change the values individually, but when I call the script step none of the records change. To add to the mystery, the script step does not throw an error code. Good 'ol 0, as if the script step was successful. There's no validation, lookup, calculated contents, or anything special about this field. It's a plain, pure, number field. Help?

Hi, I have a table, which i have a field named "clientnames" i would like to copy its contents into another table. By using setfield, it only copies the first value. i have tried using an id in another field. using setfield with if function but it returns same result. i know i have to loop it somewhere but i really have no clue now because i can't seem to specific a value using an id to update into the new table. please shed some light on this. thanks regards

We currently have a selection of Filemaker Pro applications used by a small community of users within our organisation. These application all use the one single database server. Given their success we are looking at the possibility of rolling these out over the next few years to up to approximately 10,000 users: of which 25% will have significant reporting and workflow requirements; and the remainder will be more data collection and can possibly be web based. Our main concern is knowing whether there are any issues with regards to scaling to this size and if there are any similar sites out there who have implemented something similar in size.

Hi any tricks to leave a layout and return to the last open tab on the original layout. I could use new window but would rather not. thanks

Ok, So below is an example text string i'll be working with 2~11~Test ID~4/19/2012 12:23:51 PM~USER~123.123.123.123 what I am trying to do is to get each section of the text (between each ~) into it's own field. I can do it to the first section with the following function Left( Text; Position( Text; "~"; 1; 1 ) - 1 ) But everything fails after that So in the end I am needed to create 6 fields. and those fields "using this example" would show the following. 2 11 Test ID 4/19/2012 12:23:51 PM USER 123.123.123.123 Any help would be appreciated!

FM 11 Adv, Win 7 64 bit I’m trying to use the Send event script step to open non-FM files. To enter a file name and its path, I go to the file in Windows Explorer, shift+right click the file and choose copy path to the clipboard. I then paste the path into the field in FM. However, the pasted path is contained within quotes. I strip the quotes from the path with left and right functions. The send event script then produces an error. If I type the path (instead of pasting from the clipboard) the script runs correctly. The attached file will make things clearer. I paste from the clipboard into FilePath. FilePath2 is a calculation field that removes the quotes. A script …

I have a layout with a container field that stores paths to jpeg files. I'm trying to write a loop script that works through a found set and opens all the referenced jpegs. The 'open file' script step only opens filemaker files, as far as I can tell. I have the rest of the script constructed, I just need to know how to request that a referenced file be opened. Would appreciate any help. Jon

My db currently relies on a lot of script steps and some significant Applescript steps. Has anyone tested Applescript or scripts in general to say if everything seems OK, or are there some issues? Going from FM7 to FM11 there was a bug in using Applescript where there needed to be something changed in a script because it went from synchronous to asynchronous running. Something like a delay or pause needed to be added after certain steps. I want to make sure I'm not caught out by anything like this in 12. Thanks Chris

Hi all I am new to Filemaker and I would be grateful for your help regarding a relational database I would like to build. I want to have one table with 10 fields, named 'objects', and to relate this table with another one that will have information on pictures related to the records of the table 'objects'. Each record in table 'objects' might have one or more pictures related to it. I would then like to have a different layout where I can see all the pictures that are available for object 1, etc. It seems easy to do, but I cannot find a way to do it properly... Any help would be appreciated! Many thanks

Hi Forum, I am trying to create a simple rent program in which there is a due date calculation. When it is a couple days before the due date, it will automatically create an invoice and receipt in the database. I am just wondering this script, should I put it there when I open the database or somewhere else. And how can I prevent repetition?.. Many Thanks. K.C.

Something I discovered today by accident. I don't know if this is common knowledge, but I guess not … Experienced Mac users will know that one of the many useful things the Cmd key (fka Apple key) will let you do is moving windows in the background, meaning that if you press and hold the Cmd key you can move a background window without it becoming the front window. So I used this technique today in FMA 12, or more to the point, I tried, but missed my mark and clicked on a button in the background window. Imagine my surprise when the button was triggered, but the windows kept their background / front positions! You can even click on a popup menu and make …

Dear, i would like to make a script that opens a url which contains a csv file and save it on my desktop periodicly. how can i do that? been tinkering around with openurl and searched for custom functions, still have no clue about it. PLease advise.

HI - I wonder if anyone could offer advice on scripting a find where the search criteria are stored as related records in an Attributes table. (Using a main table with an associated attributs table is something I learned about on Matt Petrowski's FileMakerMagazine website.) This is within a database that will catalog real estate records (Documents) that are on file in a county courthouse. Every Document is stamped with a reception number that is unique to the county where it is recorded. In scripting my find, I have to account for the fact that some states may have counties named the same, and some counties may have documents recorded with the same reception number. …

Hi I don't quite get how the 1 and 0 works in the case statement and how the if statement get the answer from the case statement. Can you help me to know how it works? Thanks. Regards, K.C. Let ([ vVersion = GetAsNumber ( Get ( ApplicationVersion ) ); vLowAccept = 11.01; vHighAccept = 11.99; vTest = Case ( vVersion < vLowAccept or vVersion > vHighAccept; 1; 0 ) ]; vTest )

i made 40million unique id each 4types each and i want to use case() script for it ,so that if i enter a value in one field automatically other 3 fields must get the values which i assigned using case() function --- is it possible to do it using case() as script box limits to 30000 characters only? ---is there any other method to it i hope my 40million id creation hardwork doesn`t go waste :idot:

My app has been under development for about a year. Yet, tonight, I went to a field with script triggers. I 'unchecked' OnObjectExit and checked On ObjectModify and selected the same script that was checked for OnObjectExit. Then I got this: "Filemaker can not share a file because FM network sharing is turned off." I pressed ok and it went away. But, "Why did this dialog occur?" My app is a stand alone, not networked app. (I am running FM 11 Adv) Thanks for reading Ron

I apologize in advance if this is an inane newbie question, but its vexing me and I don't even know how to phrase this to search to find a solution. I have a simple script that takes a user to a list in Preview mode, pauses so that they can look at the document and scroll through the pages, and then 'continue' back to the source layout. My problem is that the 'continue' button up in the top right is so small that my users just can't seem to find it, and they get stuck in the list layout. Not good design on my part. It is so unassuming up there in the top right, and the users are used to looking at larger icons. Does anyone have any secret ways to work around tha…

I need advice to develop a small application to support in multi-languages. its should support to all languages like labels, button names and title of the layout.. could any one please share your suggestion to bring this feature to my fm 12 application Many thanks in advance for your valuable time

HI, just as an introduction, I'm new in the FileMaker world. Following Table Structure I wish to implement in FileMaker: tblSalesHeader ID Date Product Template Category (this includes a predefines set of Products, which will be defined on another Form) 1 01/01/2012 Soft Drinks tblSalesLine SalesHeaderID Price $ Product (coming from the above selected (Product Template Category) 1 1.07 Coca-Cola ... 1 1.05 Fanta ... 1 1.9 Sprite ... ... tblProductTemplateCategory ID CategoryName 1 Soft Drinks tblProductTemplateCatLine Prod…

I am making numerous buttons. Each button will be next to a field on a layout. Currently I am able to copy the field data with the custom script step called "copy". The functionality is fine with one exception. It requires I specify the field to copy from in the script editor. I would like to have one script that uses optional parameters from the button. Is this possible?

I have a database recording driver infractions and unit km on a a daily log. These records are input on the same "New Log" layout through portals. My problem is, when a log needs to be deleted, I need the km and infraction records to be deleted too. Logs.zip

Hello, I have a database with a script set up to export fields into a merge file which I can then import. I've since added some new fields to the database Now when I run the script the new fields are not included within the exported merge file. I don't know how to adapt the script so that the new fields are included within the export. I believe it to be within the Set Variable where the script looks at what fields are to be exported within the "Set Variable" dialogue box "file:" & Get(DesktopPath) & "dataAllFnd" & LeftWords(Get ( UserName );1) & GetAsText (Year ( Get ( CurrentDate ))) & "_" & GetAsText (Month ( …

I have a window called Lodge Membership. I freeze window Lodge Membership] Freeze MAIN While it is visible, I open a window called Setup and put the DropDown Layout in it. I loop through Dropdown collecting values.... etc.. I close DropDown Select Lodge Membership Show a dialog box. The problem is even after I freeze Lodge Membership, when my script is run, and when the dialog box at the end if shown, I see a weird, empty window where the previously closed DropDown was located. I

Is anyone having any "Manage Scripts" issues? I had a free update to FMP 12 (I had just purchased a copy of FMP 11) so I thought I would give it a try. I took a solution I had created in FMP11A and did a conversion via FMP 12 - I went in to make some changes to a script, I made a copy of the script and it made the copy with a numerical indicator and placed it above the original script. I moved the copy under the origianl script and it popped right back above the original. I tried this a couple of times, then I moved it down about 6 or 7 scripts in the Folder...then the copied script jumped completely from its folder to a folder above it. And it will n…

... sorted by last name and then first name. My script is pretty basic: I show all I sort on Last Name, First Name I find [restore] mem_can="Member" // to show only members I create a window I goto layout I go into preview .... and the labels are NOT SORTED. Huh? Is there something peculiar about Preview? Here is my script exactly as written. (Notice I have disabled the constrains to just keep it simple) I suspect I am just 'missing' something about Preview??? Thanks for reading.. Ron Turns out I needed to Sort AFTER I Find..... But, there is another problem. After enabling the Constrain code... It does not …

Hi all. I have searched briefly for this and found nothing. Perhaps you can offer some guidance. I have developed a database that uses a particular bespoke font to keep up with the "style guide" this particular company is using. The database will be installed on select office computers on which this font will be installed. However, due to the custom sizing of the font, I want FileMaker to check that the font is installed on startup before allowing the program to run rather than replacing it with a standard system font. Any ideas? Thanks

I have a main layout called Members. On it, you can click a "setup" button to open a window that shows setup information. I want to make sure that only ONE instance of SETUP is open. What is the best way to look at the open windows and see if there is one called "setup" all ready open? Thanks Ron

I am trying to attach a 76Kw FM 11 Adv file but get the message "you aren't permitted to uload this type of file." What gives? Why can't I attach an FM file?

hey Everyone; script here is not parsing data right away. I have to move completely out of Vlist Layout and come back on to see valid data. Any advice would be greatly appreciated! thanks, -ian Q_A-notRefreshing1.fp7.zip

Hi, the issue im having is with a drop down value list. in my database at the moment is used only for two layouts. namely Project Details layout and Test layout. first of all the user goes to the Project Details layout and clicks new record. then a projectID is automatically created and allows the user to enter a project name, project description. after that the user needs to add particular drawings for a particular project which was created. then the user goes to the Test layout and it has a drop down list which calls all the project ID's which were created in the projectDetails layout. assume we created a project ID "1" and entered project name , project descr…

I am trying to to click data in a field and have the program automatically find all the records with the same data. Example: I have course numbers in a field called courses for every record. 123, 123, 127, 128, 129, 123, 123, 127, etc. I want to click on 123 in one record and have FM return all the records with 123 in the course field. I figure I have to create a script and attach the script with a button on the field. Any help will be appreciated. Thanks I am using FMP 6 on a PC

I am modifying an older (FM6) Filemaker file. It scores sailboat races and allows 25 races. Each race is a separate table (and file) and then there is another separate table (and file) to summarize and total the results of individual races. In each race there are numerous scripts and fields. I'd like to have the fields defined in the summary files and simply referenced from the files for the individual races. Is there any reason I might not want to do that? How is the best way - define in summary, redefine in each race by cross-referencing to the summary definition OR simply reference from each race script directly to the definition in the summary file? Also, it woul…

When my application is distributed it will have no records. However, when the ONSTARTUP script is run it sets ErrorCapture ON and UserAbort OFF. But if the user clicks anywhere on the layout (besides the 'add new member button), it produces this dialog. Question: "how can I suppress this message?" Thanks Ron

FM 11 Adv, Windows 7 (64bit) I’m going around in circles with this one. I’m trying to insert a match field into a record by selecting a name from a value list. The value list is based on two fields: field 1 which is the match field (fkRecordID) and field 2 which is a person’s name. The value list is set to show all values from field 2. However, there is one name on the list, say Sam, that I cannot select. When I try to select Sam, FM inserts another name from the list, apparently at random. I can select any other name with no trouble and FM inserts the correct match field. I’ve tried deleting and re-creating the Sam record but get the same result. I’ve tried changi…

Hi All, Thanks in advance. I have multi file application. Out of those .fp7 files in one file have global table where I stored all the global/common data & images used in application having one record. Now we found one issue some how the record form the globle table get deleted and because of that the functionality based on this table not works. There is no single script which delete the record from global table.Even I didnot delete the record. Can anybody help me to find out what is reason behind this situation.

Hi, I have a question, is it possible that when a record has a certain status it cannot be changed annymore. For instance i have records in a database with the status "paied" then the record may not be changed anymore. Thanks, Frans

Hi I try to export the 2 fields one at a time, but the data from the next record overwrites the previous records. Is there a way to add fields from each record to a file? Many Thanks. K.C.

Hello ; i am wanting a Tutorial or advice on building a keyboard using repeating fields. can someone point me in right direction? thanks -

Hi, I need a script to prevent users to alter fields content by mistake. I suppose that fields must be locked and to modify them a password must be needed. Or what else? Thanks George Papadakis

I have a database serving as a requisition form for kitting parts for manufacturing--there are 10 text fields to specify items (nuts, bolts, washers), and 10 fields for the quantities of those items. Part of a script determines the item with the lowest quantity, returns the name of the item, and then subtracts that quantity from all the other items. The user will not always use all ten fields, and I want to tell the script to skip fields that are empty, but it needs to treat fields with a value of "0" differently, and include them in the rest of the calculations. Will that work? the pertinent steps will look something like this: if ( ::part1 ≠ "") set field ( ::…

Greets, all: Here's what I want to do script-wise: 1) Compare two FMP files ("Student Records" and "Health Record Card") to see if Student Records has more records than Health Record Card. If they're equal in number the script exits, otherwise... 2) Isolate the 'extra' records Student Records then import them into Health Record Card. I was in the process of writing the script (attached) but stopped because when I run the script and it reaches the Show Omitted Only step, the command affects Health Record Card but not Student Records. Why is that happening when FMP is focused on the related record, and what's the tweak I need to fix that? I tried addin…

My portal records don't match the table it was based on. The ID_PAR.pk is incorrect in the portal (the table records are generating correctly). I have four related tables in all. HOUSEHOLDS (the parent), PARTICIPANTS, PARTICIPANTS_2_CHILDREN and CHILDREN. They are related as follows: HOUSEHOLD::ID_HHD.pk is linked to PARTICIPANTS::ID_HHD.fk PARTICIPANTS::ID_PAR.pk is linked to PARTICIPANTS_2_CHILDREN::ID_PAR.fk CHILDREN::ID_CHI.pk is linked to PARTICIPANTS_2_CHILDREN::ID_CHI.fk I have a portal on the PARTICIPANTS layout to the CHILDREN records allowing me to create new CHILDREN records from within the portal. The join table, PARTICIPANTS_2_CHILDREN, is c…

New to scripting and I'm just trying to write a new record with some fields changed. I can write the new record based on a related tables key field but none of the fields I set to new values change in the new record. here's the script For some reason I can't copy and paste it so this is an image file. (Explanation anyone?) Anyway the new records are written to Pay Records as expected using the key field from Form View but none of the fields I am setting are being written with the set value. I know this is caused by my own stupidity but a few days of research and I can't figure it out. Any help gratefully appreciated.

Hi, Can anyone help with the following script? The script is meant to generate an email to the people in the database who are filed under Work Camp, whose return date (Hjemkomstdato) is earlier than today, i.e., have already returned, and who have not yet given a rating. The script is in the attached picture: The details for the Contrained Set script are: In full, the script is meant to do the following: 1. Find the people in the database filed under Work Camp (from about 10 possibilities) 2. Find those whose return date is earlier than today's date. 3. Detect if they have already filled out the rating system (if that's the case th…

Hello, I've searched for an answer to my problem here and on Google but have not found one yet. Can anyone help? I have an Open Script that generates a report, saves as pdf and sends it as an email attachment if criteria are met. How do I check if either the file has been opened today or if the script has run today so as to avoid generating the same report and email numerous times on the same day? Cheers, Alvise

Hello people... I have a database that has two levels of privileges..those who can view the edit and delete buttons and those who can not view the edit and delete buttons.... I would like those who are not privileged to edit and delete, once they login...these buttons should not be visible to them while those with the privileges can view the buttons... Another issue is...I noticed that when people login..they can view the records previously entered which still remain in the fields..i wonder how to automatically have empty fields once a form is loaded....I tried script trigger on layout load that requests new records but this automatically adds empty records if…

I’m trying to make a script to automatically create certain receipts. With my little knowledge I have made something that works but trying to improve it I have a problem now. When I grab the information I need I set a field as “DONE” in that record, and I want this record not to be taken into account for the next time so I don’t create the same receipt twice. I know (well, I bet) should be done adding an If sentence, but I can’t make it work. Any help? I attach a sample file. Thank you. Receipts.zip

Possible or not possible ? When I create a new record in another table (freeze - goto layout .... original layout etc.) The webviewer on the layout (webviewer) I am creating the record from refreshes every time a new record is created. The webviewer contains a java-stopwatch (starts over when a record is created) probably cannot be stopped ?? Henk

The Sort dialog box allows you to sort on multiple fields, this I understand. But I was wondering if there is a way to script that same functionality? If I give users access to the Sort Dialog they won't want to scroll through the list of fields to find the one's they want so I was hoping I could script it. Is this possible? I haven't been able to do it. Anyone? Thanks. Dom Nevermind - brain freeze. Long night.

Hi,if anyone can help that would be much appreciated. I have a script that goes to a report of the current record. I do that by copying and pasting the current records group name. PROBLEM: when the script performs the find on the group name I need it to find the exact match, how do I do that?

I have a little record -creation script set up in part of my solution that involves a little pop-up window with several Global fields on it that the User fills in before hitting a "Create" button that triggers my script, which goes to the relevant layout, enters data in the various fields, then goes to a different sub-table and creates some records there before going back, clearing most of the globals and heading back to the original screen. It works fine. EXCEPT, bizarrely, if the User leaves a field called ARCHIVE_gl empty. In this case, the script runs as usual, and *mostly* works . . . but a few of the global fields seem to get 'Emptied out' temporarily along t…

In a script I have Set Variable for a list of scores. Example: 8 14 18 16 21 20 24 27 I am writing a loop to count the times a value occurs in the list. Then go to the next value. I tried PatternCount, but it counted 20 when I was looking for count of Value=0. $CurScore is the individual Value. PatternCount ( $List ;$CurScore & "¶") thanks, Jim

I am learning how to use conditional format and variables on layout. I have button which enters find mode and changes label and then when clicked again performs the find. Same thing I want with preview. If someone wants to preview they click preview button. And in preview it turns red and changes its label and then they click it again to exit preview - just like the toolbar shows. But I cannot find an 'exit preview'. The preview button does not respond to the Enter Browse mode command. I have the feeling I will kick myself once this is figured out so I have put on my shin guards ahead of time. preview.zip

I have a script that mimics a GTRR. The button is located in a portal row. Basically, the script sets a variable to the record ID for the portal row, then navigates to an unrelated TO, finds the desired record, then shows all. Except that it doesn't work on all the portal rows. On some rows, the show all step doesn't work. Anyone have any ideas?

Hi, I have a Radio button that I want to use in a Find Script but I seem to be missing a couple of things in the Parameters available: I have 2 Questions below... 1 - if I hit control F I can go to the field and click either YES or NO and then return and the search will only display the appropriate records (no problem there). How can I perform a find for all records with no value at all in this field? Is this possible at all? Or do I need to perform Omit Record and indicate both YES and NO results instead? 2 - I have tried to create a Script which does the same as above but I can't find the Script Parameter which allows me to perform a find in this way (as in a …

Hi everyone! I am trying to do something which I think it should be quite easy to implement. I have a layout (called Projects) from which I create new Budgets, which it is a different layout and table. Both tables are linked by a field in the DB. Therefore, what I am trying to do is a script which goes from Projects to the other layout and create a new record. My problem is the following; I need to link both tables inserting the value of the field id of Projects table to the field projectID of Budgets table. I am getting an error because the field projectID is not in the Budgets layout. What I am trying... set Variable [$code;Projects::Code] goTo Lay…

Hi, i am using this script i found in the forum. Problem is that it only duplicates the first found record and not the complete set. Any help ?? Unsort Records Go to Record/Request/Page[ First ] Set Variable [ $recordPosn; Value:1 ] Set Variable [ $foundCount; Value:Get(FoundCount) ] Loop Duplicate Record/Request Set Variable [ $recordPosn; Value:$recordPosn + 1 ] Exit Loop If [ $recordPosn > $foundCount ] Go to Record/Request/Page [ $recordPosn; No dialog ] End Loop To leave only the duplicates, add these two lines at the end of the script. Go to Record/Request/Page[ First ] Omit Multiple Records[No dialog; $foundCount]

Hello Everyone, I'm new to scripts and am trying to do something which is probably simple, but I can't make work. My company uses FM to quote projects. I have created a separate database for pricing per contractor. In the quoting database , the user has to pick which contractor they are quoting. Then when the user picks a labor item, the price for that item is found using an auto-calculated result using an IF statement. This is how it is set up, I'm sure there is a better way but it works now if you pick the contractor before adding the labor items. QUOTE::Cash Labor=Lookup(PRICING::Cash Cost)* QUOTE::Smith Contracting Labor=Lookup(PRICING::Smith Cost)* …

Hello Everyone; i saw pauseonError video for matt navarre showing his fmresults and i loved the auto tooltips when we was searching and wondered how i could go about doing that. EG. if the user hovers over a field it shows the tooltip automagically. [ * here you can enter in the zip code *] thanks, -ian

Hi, I would like to create a report from each individual customer, and then see all the items he ordered. The customer should be selected from a dropdownlist, and when de customer is selected the report is being shown. I have a table customers and a table Sales, the relationship is the contactpersonID. Can somebody help me to make a start. Thanks, Frans

If you can try this, you will see what it does. I am sure what i am doing is silly. But i want to test the data with valid search terms and this is not working> please can someone help .. thanks Set Error Capture [ On ] If [ IsValid( search::search term) & not IsEmpty(search::search term) ] Show All Records Set Variable [ $searchString; Value:"==" & search::search term ] Enter Find Mode [ ] Set Field [ search::data; $searchString ] Perform Find [ ] Go to Record/Request/Page [ First ] Loop # # no records FOUND - get out # Exit Loop If [ Get(FoundCount) = 0 ] If [ Substitute( search::data; """ ; """) ≠ $searchString ] Omit Rec…

I don't really know if this is a scritp matter or a calculation one. I have a table with many customers' emails. I use a script that picks them up from every record and place them into a field but sometimes two customers have the same email. How could I "clean" those duplicates? Thank you.