Script Workspace and Script Triggers

Hello I have a layout which has a sub-summary field, displaying sales values when the data is sorted by Month. My script involves the copying and pasting of the sub-summary values into another file, but I cannot get it to work. The instruction 'Copy [sub-summary value]' fails. I have a nasty feeling I don't understand how sub-summaries work and that their values simply aren't copyable. Can anyone enlighten me and, even better, suggest a workaround? Thanks Philip

Hi Everyone, I've encountered an issue I'm having trouble solving. I have a script that works fine on FMP 11 Advanced but when I run the same script in FMP 11, it doesn't give me the same result. For example, my script duplicates records from another table: duplicates records: 1,2,3,4,5,6 When using FMP Advanced: 1,2,3,4,5,6 is duplicated correctly When using FMP: 1,2,3,3,5,6 and is duplicated incorrectly. The number seems to be random on which record it duplcates incorrectly but always repeats the previous record and replaces the next record. I'm having trouble isolating the problem because FMPro doesn't have debugging tools and whe…

I’m keeping track of expenses and deposits in a related table and show the results in a portal. However, the calculated balance does not appear in the portal unless I click between portal fields or click outside of the portal. I calculate a running balance from a difference formula on each record: Deposit Expense Difference = Deposit-Expense Balance = Summary of Difference (Running). The portal includes the Deposit, Expense and Balance fields, not the Difference field. How can I get the balance to appear in the portal w/o clicking outside a field? A copy of the file is attached.

Kennel/Boarding solution. I have set up an invoice which takes most of its information from a "bookings" form. I would also like a button, "Add Service", to add additional line items contained in a value list in the 1st open row of the portal. So far my script reads: Go to Object [ObjectName: "Portal"] Go to Portal Row [select; Last] Go to Field [bookings::_kp_booking_id] This gets me to where I need to be, but I cannot figure out how to add a step to get to my value list, BookingType. This is my 1st attempt at a FileMaker solution, so please bear with my ignorance. Thanks in advance for your help! Believe me, it is most appreciated. Please let …

On another forum, a question was posed: http://forums.filema...cd768309#173535 OnObjectExit trigger - The only way I could make it work is to end the script with Halt Script. This struck me as strange because when a script ends, it halts anyway and we never need to end a script with Halt Script. Debugger shows it does go to the specified field but then immediately jumps to the next in tab order. I did not expect this behavior (between tabs and script trigger) and I am trying to understand the underlying logic: User tabs which exits field trigger fires and places cursor in field outside of tab order tab attempts to finish after script ends by moving to n…

hello i need some help: I am trying to run a script that will insert a pdf file to a field container . the script goes like this filepath ="imagemac:/mac/Users/usera/Desktop/to/Cliant/902/1638.pdf" goto field = [pdffile] insert image [$pdffile] at the end of the i get a empty filed no file is in the field , i did a check by GetAsText ( pdffile ) what am i doing wrong. Thank you dani

Is it possible to create a script at startup for the user to view the help-files on how to use the database, but select a checkbox 'Don't show help files on startup in future' so that they don't have to view the help-files each time they use it - only the first time. Essentially, is it possible for the user to either 'Disable a script' by way of running another script or perhaps, setting FM to run a script only the first time that the user logs in, not each time after that? Thanks so much in advance

Hi all, I have a question that I hope is easy to answer. I want to be able to batch import images into a database and have them automatically import into a matching records. For example: I have a record which in the NAME field has the entry: 6E-4 (A) and I have a picture file names 6E-4 (A).jpg. I want to be able to import that file from a batch and have it automatically import to the matching 6E-4 (A) record. I have a container field ready to go for it. Any thoughts? Thanks, Rowan

I have been using FM for quite a few years now. One thing I'm disappointed in is that you cannot name relationships. I always document my own databases and use the following procedure for documenting each relationship: The relationship is named with the table occurrences (TOs) involved in the relationship. TO1-to-TO1 Example Assume there are two related tables Customers and Items: Comments Relationship name Customers-to-Items TO names Match fields Customers::pkRecordID = Items::fkRecordID Include TO names …

Hi all Is it possible to sort records by email domain name on a set of contacts records. The way I have thought to do it is to create a variable based on the email - strip out the part before the @ symbol - put it in another field and then sort by that field. Has anyone got any alternatives and is there a function for taking off the first part of the email address Thanks for reading all

Hi, I've been trying for days to come up with a solution and I wonder if you could please help. I have got a Student Report Card maker whereby the user (teacher) simply selects the comments from drop down menus. The Categories are as follows; General Positive comments General Negative comments Reading Writing Grammar etc etc... For each category there are two drop down menus: The same phrases but the second menu is preceded with ' and' meaning that it must be the second part of a sentence. For example; Reading Menu 1: "He has a very good level of reading" Reading Menu 2: " and he has a very good level of reading" This allows the tea…

I would like to run a report and of course view in preview mode. I would like the FMP reporting script to save a .PDF of this report into the parent record generating this report. Relationship would be something like this; ParentProjectTable > ChildReportsTable. If I can avoid it, I would like to NOT save/export a file to desktop and then import. I would just want to save file straight into FMP, this may not be possible? I want to avoid saving to desktop because database will be used by multiple users and they have there own prefs on where they want to save files. Also, I want to avoid the (Can not find file path) notice. I think GOOD scripting can solve these iss…

Is there a script step that will look at the version of FMP currently running on the local machine. Comment helped me with a script (http://fmforums.com/...__fromsearch__1) that Appends to PDF. The problem is that one of my clients is running FMP8 on a MacBook Pro. Append to PDF didn't start until v.9. What I would like is for FMP to search the version he is running and then add a custom dialog letting him know that that script only works with v.9 or later.

Hi All, I would like for the following to happen: In windows 7 using FMP 11: Event: a file is exported from a program to a specific folder called C:/programname/export I would like that event to trigger FMP11 to open and run a script. Using a plug-in would be fine if you know one that will do this. Of course, better if I don't need a plug-in Thanks for your help. Jeff

Hi, I've been messing around with trying to set up a way of converting currency on the fly by sourcing data from a web viewer. I've got it working in a test file but for some reason there's a lag in the info updating (you need to choose the currency multiple times) and I was wondering if someone would mind taking a quick look at it for me? I think it's something to do with storage but I've got myself in a bit of a knot! There are 2 methods I'm trying in the attached file. One is a simple relationship based on manually entering a conversion rate and the other is the above. This is the one I'm having (slight) issues with. What I'm doing is using a web vi…

I'm reviewing my somewhat limited error handling procedures so I can code to handle various possibilities in a better way. I need to know when I should be looking for errors, and when they do occur, what to do. Which script steps generate error codes and is there a list of error codes that can be related to a specific script step? - For example if a New Record step fails, what error codes should I expect to see? - Does the go to next field step generate any error codes and if so, what would they be? I can't find a list; maybe I'm not asking Filemaker's Knowledge base or Google the right question. Can anyone help? Brian

Hello. I have a database for tracking people on a certain course- (students in a 4 year plan). I have a report that pulls all students that are status=in progress and the contract was received within the term & year the user inputs in the user parameter (in the Show Custom Dialog script). I also have a similar report that pulls all students that are status=in progress and the “planner” was received within the term & year the user inputs in the user parameter (in the Show Custom Dialog script). I need a report that pulls both…. All in progress students that have turned in the contract & planner on the term & year the user enters. How…

HI, I've got an English teaching Children's games database. One of the fields is 'Topic' (animals, clothing, foods etc.) I have another field called 'Flashcard Game' which basically covers all games that are played with flashcards - and thus any topic can be covered as long as you have animal, clothing food flashcards etc.) When the game is a flashcard game, the field is 'Yes'. So I write the 'Perform Find script' that if 'Flashcard game' is checked as 'Yes', first search for the other criteria selected by clearing the 'Yes' and then extend the found set with all the 'Flashcard games'. The script works fine inside FMP but returns 'No Records found' in IWP most o…

I search for it and find wayyyy too many posts which are just using it as part of a script or something but nowhere can I find information about this step itself. Filemaker help does not say when and when not this works. My reason for seaching... I have several scripts which do a lot of things, going to different layouts, searching, sorting and even though I put Freeze Window at beginning, many times it still shows flashing and windows and I do not know what all because it is too fast. So I add another Freeze Window down in the script. And this goes on. I do not want to stick them anywhere and besides it doesn't work anyway. Can anyone tell me what breaks…

Hi I have a Main Menu layout from which a user will select a Report. When this option is selected, I run a script that Goes to a different layout -> Opens a new window, so that the new layout displays in a different window. This is fine but my Main Menu layout also takes the same dimensions as the new window. I want the Main Menu to remain in Maximize mode and the new window on top of it. Is there any way I can do this ? Any help would be very appreciated. Thank you.

I have two layouts; Show day and Off Day. I want to do a date range lookup which mixes Show and Off days. Each record has a Show/Off Day field. Then I want to print these dates, in date order and to the correct layout, as a single PDF file. IE; as a tour book. Is there a script step step to accomplish this? The reason for this is that the layouts are written using Merge Fields and each field has a label. The example below is a Show Day layout. On the Off Day layout, the Venue and Promoter Sections disappear and are replaced by an "Off Day" image. Many, many thanks for your help.

Hey Gang. just curious about this technique i am trying. To me this makes sense as i am using a global Variable on my main Layout and when i go to child table, the auto_ID will create the global key establishing relationship. Magic key i think is the name. anyone take a look & let me know please. thanks global_create.fp7.zip

Hi, I'm creating a IWP database of children's games.The games have worksheets which are displayed as images in a container field. In IWP, these images can't be downloaded to the user unless I Insert the image as a file (not stored a reference) in another field. I've got 1000's of worksheets so is there a script I can make that will essentially; Export field contents ('IMAGE' field; of Worksheet image.gif, to the temp folder) Insert file (into 'FILE HOLDER' field;of .gif just exported, don't store as reference) I have tried for two days to get this working, but I just can't do it. Or is there another way for the IWP client to download the image apart …

Hello, I currently have a script to relookup field contents but it runs this script through whatever records I may be browsing at the time, which could be thousands. How do I set up the script to run on the current record only? I tried to add a Go to Related Record but it doesn't seem to make any difference. Thank you!

Hello, I am writing a script that from an open record in Table A will create a new record in Table C, and after doing that will return me to the original record in Table A. Table A and Table C are related through a join Table B Table A --< Table B >-- Table C Usually when one moves from an open record from Table A to another Table C, one gets listed all the records of Table C. But this is not what I want the user to see. I want the user to get the "feeling" that there are no records in Table C when directed form an open record in Table A. Let's assume that Table A has 250 records and that Table C has 500 records. If we …

When i use the script "Go to layout" there is flashing with the screen on my windows filemaker application Could anyone please give me your idea to avoid this type of flashing while using the "Go to layout" script Or Please give me other suggestions to avoid this ! Thanks in advance.

[b]Find UNSOLD[/b] [i]#[/i] [i]# Attempt to get ALL sold & unsold records count[/i] [i]#[/i] [i]#[/i] [i]#[/i] [b]Set Variable [/b][ $$COUNT_sold; Value:"" ] [b]Set Variable [/b][ $NAME; Value:Get(ScriptParameter) ] [i]#[/i] [b]Go to Record/Request/Page[/b] [ First ] [b]Loop If [/b][ $NAME = Products 2::name and not IsEmpty(Products 2::sold) ] [b]Set Variable [/b][ $COUNT_sold; Value:Products 2::sold ] [b]Exit Loop If [/b][ $NAME ≠ Products 2::name ] [b]If [/b][ $COUNT_sold ≠ Products 2::c_sold ] [b]Else[/b] [b]Set Field [/b][ Products 2::c_sold; $COUNT_sold ] [b]End If [/b] [b]End If[/b] [b]Go to Record/Request/Page[/b] [ Next; Exit after last ] …

Thought I'd see if anyone has any cleaver ways to terminate a script in a controlled manner. Currently I use the get active modifier keys to accomplish this, pseudo code example: Allow user abort off Show message explaining operation and to abort activate caps lock If caps lock active tell user to turn it off and try again Exit Script EndIf Loop Exit loop if caps lock active Do a bunch of critical scripts that cannot be aborted during their operation GotoNext Record exit after last EndLoop Only problem is one customer who can't seem to grasp the concept of reading messages and understanding the concept of turning off the caps lock. …

attached i have a test app for when my clients add a suite to the current order. I am building separate modules in order to have each one run independent of the other, but connect with uuid's or similar. I am thinking to have a type ID in the database so type1 = "suite", type2="pullapart", type3="cake",etc so in my portal i can have a group id with all the necessary information added. Now i need to ask once i grab this data how would i go about doing the latter? thanks for anyone who can help. -ian suites.fp7.zip

I have a db that holds a lot of information about each unit in our inventory. I am attempting to write a script that would show a list of values "open" for a particular field (IP Addresses) Basically Field IP4 will have a number between 1 and 3 characters between 1 and 254. I want to find (after going through each record) which IP's are NOT being used (Wouldn't have a record). For instance: Record 1 = 2 Record 2 = 5 Record 3 = 10 I want a container field to be populated with: 1 3 4 6 7 8 9 Etc all the way to 254 (If 254 is not being used that is) Any ideas?

Hi I'd like to have a validation script run, whenever a portal row is commited, or more precisely: whenever a portal row loses focus AND was modified before. I tried Portal::OnObjectSave, whicht unfortunately doesn't fire for known reasons. I tried Portal::OnObjectExit, which fires too often, namely, even if the portal row data was NOT modified. I tried PortalField::OnObjectSave, which fires too early, because validation can only be done on record level, but not on field level. I have in mind to use Portal::OnObjectExit and there decide, whether a record needs validation based on a flag that was either set priorly using PortalField::OnObjectSave or by e…

I have a checkbox set with 30 'topics' for children's games. Some games can include any topic, so I want to check all the boxes. I created a script with 'Insert Text', and listed all the topics as per the value list. which does the trick nicely to select all the topics with one button. However, as the database grows, I think of new topics, and I don't want to keep updating the value list, then this script etc etc... Can I use the data in a value list as the text to insert in an 'Insert Text' script. I have tried without luck. Thanks so much.

Hello all, I am trying to script a find but I think that I am not doing it the most efficient way. I have a field that can have eight different values, A, B, C, D, E, x-A, x-B, and x-C The other field is a date field. I want a script that says, find records with A or B or C and the criteria in the line below And in the date field I want >=7/1/2011 and =(if the field is blank) How can I make a simple script to do this? I can only do it with many steps. Thanks Dave

Alright, I need some help. I read up on it and searched and I am still stuck. I have three tabs. Layout opens on default tab 1. If I select 2 or 3 I want script to run and script to run if returning to tab 1 but not if clicking tab 1 if they have never gone to 2 or 3. So I named them 1, 2 and 3 using the object name and I was thinking of something like this... If[ GetLayoutObjectAttribute( "2" ; "hasFocus" ) set variable $$left1 to "2" perform sub script [script #2] Else if GetLayoutObjectAttribute( "3" ; "hasFocus" ) set variable $$left1 to "3" perform sub-script[script #3] else If[ $$left1 > 1 set Variable[ $$left1 to "" ] perform sub script[…

Hi. I have a small problem that I need a hand with please. It's more about my lack of knowledge than anything. I have two tables. One is QUOTES and one is LINEITEMS. One of the fields in QUOTES is the Quote_Number, and the same field name is found in LINEITEMS. There are numerous records in LINEITEMS that are related back to QUOTES. I am looking to duiplicate a record in QUOTES, includuing all the LINEITEMS records associated with that quote. What is the most efficient way to duplicate this record, bringing the a copy of the LINEITEMS across with it. Thanks in advance, Greg

Hi All, I can't seem to use the "Save Records as PDF" script step on a particular layout. Every time I invoke it, FileMaker hangs and according to the activity monitor (I'm on an Intel Mac, Mac OS 10.6.8) start using 99% of the CPU. I've done my Googling into the problem and have found that some people experience crashes (no on describes the "hang" symptoms I am experiencing) when particular Adobe Acrobat preference files are 'corrupt'. Deleting the files seems to resolve the issue for the vast majority of people. Well, I tried that and it didn't work. Finally, I reformatted my computer, re-installed the operating system, updated it to current, and re-installed …

First and foremost, on this Thanksgiving Day I want to thank all the FMP gurus here for their timely assistance in helping me answer and solve the questions and problems I've posted here over the year. I'm sure I speak for everyone that we're all very grateful that you're here. ------------------------ I feel incredibly sheepish asking this: Why I'm having a problem inserting the cursor into an empty field--after running a script that copies a record--so the user can start filling that field with data? I've tried a number of ways to script it using the Go to Field, Go to Object, Set Selection, Insert Text script steps but for whatever reason(s) I just can't get t…

My File Close script navigates to a splash screen layout. The OnLayoutEnter triggered-script for this layout installs a menu set with almost no options. When the file opens, the splash screen layout is the current layout (as intended) and my Startup script pauses for two seconds, does several other things, then navigates to my Home layout. The OnLayoutEnter triggered-script for the Home layout installs a menu set with many more menus and options and all is well. The problem is that immediately after program execution exits from the Startup script, the OnLayoutEnter triggered-script for the splash screen layout executes and installs the stripped-down menu set. Wh…

Hi all, this seems very easy but has been driving me mad!! I have a portal with the fields: Date from - Date to - and Number of hours taken Once a member of staff takes some holiday the admin types in how many hoursa they have taken. On the same layout I have a field called Total hours taken. All I want is for a total of the hours taken from the Number of hours taken field. I've tried sum but that just adds the last record. I've looked at summary of Total hours taken but the Number of Hours taken filed is greyed out!! Any help would be gratefully received. Thanks, Jon

I have a text field called "Sample HTML Code" that contains the following contents: <tbody class="result"> <tr> <td> <span>Price not displayed.<span class="tiny"> <a href="/gp/feature.html?ie=UTF8&amp;docId=174014">Why?</a></span></span> <div class="shipping_block"><span class="price_shipping">+ $150.00</span><span class="word_shipping">shipping</span></div> <tbody class="result"> <tr> <td> <span class="price">$1,616.42</span> <div class="shipping_block"><span class="price_s…

Let ( [ ~isSameFIeld = "firstName" ; [color=#ff0000][b][i]~isSameField = $$SORT.FIELD = ~field ; $$SORT.FIELD = ~field //THIS HAS ME BAFFLED?[/i][/b][/color] ]; ~isSameField ) I JUST dont understand the mult-equals for all those variables? anyone ? -i

Hello All, I don't seem to be able to find out why a script that I have created to change from one layout to another doesn't work. I have 3 different layouts for 3 different products that I sell. If I create a new record I have created a script that upon clicking the button "new record" it asks me if I want product one, two or three. After selection a field called "BOOKING TYPE" sets itself to product 1,2,or 3 which triggers another script that changes the layout accordingly. So far so good, but now I want my buttons "next record" and "previous record" do a similar thing: lookup field "BOOKING TYPE" and if it is set to value Product 1, Product 2 or Product 3, the…

Hello , i want to know if i can create a portal that shows all the events of new records? for example: everytime any user creates a new record , show in the portal the record title, the person-user who creates the record, time,? please let me know, thank you mauricio

Hello! I'm new in scripting but trying to stop current layout from the switch to other one by the script that: 1. Verifies 2 arguments Exit 1 and Exit 2 (the sum must be less or equal then 100). 2. If 2 fields are <= 100, the user should not be able to exit the layout and be returned to the original one (selected field). I've wrote the script: If [Exit Strategy::Last Exit = "Error!"] Beep Show Custom Dialog ["Error!"; "The sum must be <= 100"; Exit strategy::Exit 1; Exit Stratagy::Exit 2] If [Get (LastMessageChoice) = 1] If [Exit Strategy::Exit 1 + Exit strategy::Exit 2 <= 100] Go to Layout ["Exit Strategy)…

Hello, I'm sure this topic has been covered but I was unable to find it. I have a list of Inventory parts and each part is a separate record showing its quantity. I also have a layout called "Inventory Log" in which the data from each record can be seen in columns and rows. Is it possible to create a script such that when I'm in my Inventory Log layout, I can update the inventory quantities in multiple records without having to manually update these fields? Specifically, say I have several Inventory items I need to deliver one day with the following fields: Part number: 24568 Widget Qty. on hand: 54 Qty. delivered: 36 I would like to be abl…

I have a script that is designed to either print or export an excel file with information. If I select print it works, but export, goes through the motions and doesn't save the file. I can't figure out what the issue is. If anyone can look at the jpeg and tell me where I went wrong, I would appreciate it. Thanks Dave

Hi, My database has a Send Mail script that creates an email for each contact. The Subject and Message are filled in automatically based on their respective global fields, which are editable by the users of my database. However this option is not available for attachments. My original idea is to have a global Container field where my users can insert a file, and then use the script to send out large number of emails with the inseted file as an attachment. Is there anyway I can make Filemaker create emails that also attaches whatever file my users chose automatically? The rationale behind this is that the users of my database have almost no training in Filem…

From "Triggered" Script B, I want to "Resume" Paused Script A. But putting a "Pause/Resume" step in Script B Pauses Script B rather than "Resuming" Script A. The only Script B step I have found that will end the Pause in Script A is "Halt Script." But this discards Script A's local context (variables, original layout, etc.), requiring "globalization" of Script A's context if I want Script B to "complete" Script A's steps before Halting. Am I missing another approach (without Plug-ins) to a Script B completion of Script A's Pause? Here is my understanding: If Script A contains a Pause (for controlled user input), Script A is ONLY "Resumed" if the user…

I'm looking to accomplish the following, utilizing a script: 1. Copy the contents of a text field to clipboard. 2. Open a Google search page. 3. Paste the copied text into the Google search box Once I activate the script, FP7 would go to the background and I'm left viewing the Google search results. Once I close the Google search, the Filemaker application would then be back in view. Is the above possible with FileMaker Pro 8 Advanced with Windows XP OS? ...any help is greatly appreciated.

Is there a way to automatically refresh a screen upon specified time intervals? I have a database that is hosted on a web server. We access it from my house, my shop office and the production floor at my cabinet shop. When I update it from my home office or shop office everything seems normal on the screen I key the data into. The screen view on the cabinet shop floor, however, does not automatically update with then new changes. The people on the shop floor are not aware of any changes to the database unless they remember to check in. I want to use conditional formatting to signal incoming information (white fonts with red fill patterns). This sh…

I am sure this is simple.... but I cannot seem to get it right. I have a script step to show a custom dialog box. It has one input field (a global text field). How do I make sure that the dialog box field is empty - I don't want the previous value to populate the dialog as it appears.

My solution is for an office environment where users each have different size monitors. So, of course, they each either cannot see the whole database or the database is just too small on their monitor, Isn't there a calculation I can insert somewhere to resolve this issue? I can only see the size adjustment to assorted percentages which aren't always appropriate... Thanks in advance... Dr. L

Hello, I have a file with two related tables: Jobs & Packing Slips. I currently have a script that allows me to create a new Packing slip/Record when I click a button from the Jobs table. Then I type in the corresponding Job Number from my Jobs Table into the Job Number field on my Packing Slip table, which then pulls in the rest of the values I need from my Jobs table onto my packing slip. I'm wondering if it's possible to modify the script so that in addition to creating a new record for me, it also automatically pulls in the corresponding Job Number from the record in which I triggered the script from. I.e.: I'm in the record for Job# 123, I click the but…

I have been racking my brain on this one, just cant seem to figure it out. I have a script which is used on our many product lines, each has it own database based on the criteria of our various customer's requirements, but they have a specific naming convention. So the script is placing data into the table using " Get(LayoutTableName)&"::Ship_Date" ", but I need it to validate if it even exists before I replace it. I want to enter ONLY if there is no data, not replace it. What I am tring to do is validate that the field is not empty, if it is empty, I will insert a date. Seems simple, I have tried " not(isEmpty(Get(LayoutTableName)&"::Ship_Date" …

Hello, I would like to get some guidance on using a script (attached to a button) that will expedite some of my database management. I currently need to be able to move files that are cataloged in FMP and open them in another application efficiently/quickly. I was able to use AppleScript to create a button on each record page to open the particular app but not to open the specific file within it. Any recommendations? Thanks.

Hi everyone. I'm a new member of FM Forums as I have always been able to find what I'm looking for on existing threads, but this time it's different! I have a database that contains values which can be viewed in an invoice layout. The invoices may need to be drawn up in euros or pounds, depending on what currency I have selected in my currency field. Each invoice needs to be sent to a different email address. I need FM to run a script every day to check whether I need to send an invoice. Invoices are sent 2 weeks before the 'balance due date'. I am managing to isolate the correct records (ie I'm able to find those records that need to be turned into in…

Summary: I'm trying to create a pop-up menu (F) that has about 10 different choices, and when the user clicks on one of these choices a script is performed. I'm trying to connect filemaker with Metrofax and I already have the right script to send the file through my email client, I just don't know how to connect it to a menu item. I have attached a sample file. When the user clicks the F a pop up menu appears with 3 choices, once the user selects one of those choice I'd like it to perform a certain email script. Any ideas? This is really urgent and all help is appreciated. Thanks MattFMPHELP.fp7.zip

I have a solution running on server 11. One person executes a script that finds records and then does a Delete All Records [No Dialog] while someone else is editing one of the found records. Will Filemaker delete everything except the record being edited (locked) or will it skip the delete step entirely leaving all records undeleted? Also, if two tables are conected via a cross join (X) and there is one record in table A and one hundred records in table B and you are modifying the one record in table A are all the records in table B locked? Thanks in advance for your help.

I am trying to click a button and have the user save a pdf of a layout. What I am specifically trying to do is give the user the option to add a custom title and text (prompt them to add something in dialogue box) in a specified location on the pdf. What I have done so far: Duplicated the layout and customized how I want to pdf to look. Created the script so that when I click the button on layout A it goes directly to the prompt save PDF of layout B. I want there to be a prompt to type the title of this report and have it automatically add it into the layout in a certain location and go directly to the save as part. hope this is clear enough any…

Based on the geographic location (Province) of the found records, I want to add a unique serial number to each record from a matching Province table/list. I've tried a loop script, but can only get the first serial number to work. I have 6 Provinces and 6 sets of unique serial numbers. Any thoughts/tips? Dave

Hi. I have a script request. Does anyone have an good example script for exporting a container field to a folder and store the address as a reference? Ive done some folder and file management with applescript in the solution, but this is a bit complicated and maybe there is a solution out there that would work with some adaptation. many thanks

Greetings, I have posted this problem on other forums, but haven't gotten any help. I have a scripting problem in a bookkeeping Database that can be explained in simpler terms by thinking of a typical invoice structured DB. Let's say InvoiceDB, Line_Items, and ProductDB Tables. Typical Line_Items portal data entry from an InvoiceDB layout. ProductDB has a field that classifies related products into classes, but not all products have to be classified. I am trying to write a sctipt that sets a class of products into the Line_Items portal (table) as separate items, were 1 or more products could be deleted (instead of entering items one at a time). I am closing in on a soluti…

Hi all FMP Server 11 and FMP 11 clients. I've got a table where I need to set two different serials, one when the record is created and the other at a later time through a script. I am using a a cartesian relationship to a one record settings table where I store and increment the serial number. The problem is when two users are pulling the serial at the same time, they get the same number. Right now the script is getting the serial number to use first and then incrementing it by one. Is there a way to lock the field/record in the settings table so it is guaranteed that the serial will be unique or should I try a different approach? Any help appreciate…

HELLO ALL WE HAVE A VESSEL LOG ON DATABASE THAT THE GENERAL PUBLIG CALL US AND LOG ON FOR THE DAY, THE FIELDS THAT WE USE ARE FROM = VESSEL REGISTRATION, FISRT LOG IS A VALUE LIST THAT CONTAINS YES & NO, CLEARED IS ALSO A VALUE LIST CONTAINING YES & NO. NOW SOMETIMES A VESSEL CAN HAVE 4-6 ENTRIES FOR THE DAY EG: WHEN THE VESSEL FIRST MAKES CONTACT FIRST LOG = YES, CLEARED = NO, THEN ANY OTHER ENTRIES THAT THEY ARE NOT SIGNING OFF CONTAIN FIRST LOG = NO, SIGNED OFF = NO, NOW WHEN THEY DO SIGN OFF FOR THE DAY FIRST LOG = NO, SIGNED OFF = YES NOW WHAT I WOULD LIKE TO DO IS TO CREATE A BUTTON WITH A SCRIPT THAT WILL ONLY SHOW VESSELS THAT HAVE NOT …

I'm sure there is a way to do this more efficiently than I am doing this. An outside application is passing data back into FMP on the clipboard. This data needs to be massaged before it can be used and the way for me to do this is in a script variable. The current solution is to 'paste' the data from the clipboard into a global field and then to set the variable to that global field. Is there a way, some function I am missing, to set the contents of the data directly into the variable without having to use a global field as a staging area? Thanks in advance for the forum's thoughts.

Hi all, I have a button set as a pop up menu with about 10 custom values. I'm trying to get it so that when the user selects one of these values filemaker performs a certain script. Any advice/help would be greatly appreciated! Thanks Matt

This is my situation, I have a table called "create parts" which holds a set of record of parts standarized with their info, I created a filter with a field which is related to this table by "type" for example: "inventory" type (pull down): plastics <----> "Create Parts" Type That would display all the parts in the portal that has the "type" I select. I would like to add a smart filter (a global for example) that if I start typing it filters within the current portal. for example: type: computer parts Will display: System board, LCD, Memory, CPU, Keyboard, Mouse, etc.... If after I select "computer parts" in type and it shows all t…

We have 4 agents in our office, and throughout forms on our layouts I'd like to automatically add their signatures to each layout. I have all 4 signatures as jpeg files, and all agents are assigned a number which is visible on their layouts. I'm looking to write a script that says: If (agent field) = 3 (agent number), then insert picture at specified location. Any ideas?

Good Morning! I manage quite well on my own all the time but then I run across something I really need and I can't fix so I come trotting back here <lol>. I still have my old FMP6 which I spent a lot of money on and I still can't justify upgrading; I have one database that I use a lot but that's it. Anyway, I found one solitary FMP6 script on the web that supposedly should bring up any number of records we choose in a random manner (I have chosen 1 record). Since my db handles a word list, that means that I would be able to have FMP6 choose words for me randomly and immediately rather than my doing it myself manually all the time (as I've been doing. Ve…

FM 11 Adv. How do I use the calculation field in Go to Record/Request to go to a specific record? I know the recordID but can't figure out how to use it.

Hello all. This is my situation, I’m creating a form that will work as a “product Creation” form, my idea is the following: Once the record is created with a unique product number the user needs to select the type of product that it will be created, the value list is based on a table I made with the products and will focus on the category, once the category is selected through the value list the trigger will go to the specific tab in the tab control to display the buttons that are available for that category. That is already working, where I’m failing is: I want to set the object name of each button through the inspector and when it is pressed call only 1…

HI Guys: I got a problem on writing a script to complete the following task, plesase help. I do have a table which contains all the details of individual product, including Model number, Details, Qty in Stock and Price. Every 6 to nine months, the supplier will give us a new price list (approx 500+ items) and I need to log individual item if there is a price change. My original idea is create a temp table which is exact clone of the original Product Table. When there is a new price list came in, I will Import into this Temp table. Each record will then compare to the Original Product table, if there is a price change , or new product, it will update the Orginal …

I have a field Type which has values A, B, C, etc. I would like to do the following: First, Find a particular record with Type = A Then find and display all records with Type = A and make the found record the active record It’s the last part I can’t figure out (make the found record the active record).

Hi guys, here's my situation: our company has been using the Task Management template for a couple of years, and it has been modified and added onto and some things are now broken. I'm tasked with fixing it, and I'm looking at the fresh starter solution as a basis (many of the problems can be fixed by cut/pasting the template scripts into the broken one). I have one hitch though.....in the layout "Project List View", there are column headers that are clickable and scripted to toggle sorting by ascending and descending order. I get the script part, but what I don't get is this: I go into edit layout mode, and right click on the header (which, again, functions as a bu…

FM 11 Adv. In a related table I have a field for say fruit. It contains many records for each piece of fruit: pear, grape and others. Is it possible to display a simple list of the names of the fruit in a portal without displaying all the records? For a example, simply display: apple, pear, grape, etc?. Some sort of filter?

Is there a way yet to edit scripts in a text editor?

I have a Send Email script using Email Client that opens up Apple Mail and puts the email address from Filemaker into the Apple Mail To field which is fine. If, however, the user clicks "Dont Save" in apple mail -- I can't seem to trap for this in Filemaker because the Get last Error message function returns 0. Any ideas how I can trap for the user clicking "Don't Save" in Apple Mail? Thanks. Dom

Hi, I'm having trouble conceptualising how to do this, but I'm pretty sure it's best accomplished with a script, and I'd appreciate any help you guys could give on how to set it up or any additional information. I have a product table related to a child tasks table. For each product, there is a list of related tasks. Many of the products come out on essentially identical schedules, which means there is a lot of redundant entering of the same tasks over and over again for each product. Ideally, I'd like to script a few buttons on the product layout that will add a pre-defined set of task records (each including a description and due date) to the tasks portal ba…

Hi, I know my basic scripts but am far from being able to add all the permutations and combinations when users don't do exactly as you expect them to... but am super keen to learn! Let me start here. I have a script that sets the print setup, enters preview mode and then takes the user to the print dialogue box. If the users presses 'cancel', filemaker shows 'Print has been cancelled. Do you wish to continue with the script'. I Users might be totally flustered with this dialogue. What do I need to add to my script in order to take them back to browse mode? Thanks so much,

FileMaker Pro 10 Advance I am not even sure if the is this right place to post this but here we go. I am working on a program that i would like to integrate with PayPal so that payments can be made for an order. It is fully functional with the exception of the PayPal integration. I don’t have any idea where to even start. This is the gap i need to fill though. Click make payment button - FileMaker sends $ amount to PayPal Costumer makes payment on PayPal - FileMaker receives some kind of conformation Once confirmation is received the program continues doing what it should if payment is placed successfully. I have looked around but have not se…

I have text that I occasionally have to copy & paste from a newspaper PDF file. The text comes in formatted like this: ELON—Elon University announced it has surpassed a $100 million fundraising goal in what the school calls its largest-ever fundraising effort. The private college has raised nearly $106 million in its “Ever Elon” campaign, which was launched three years ago. The college will continue collecting donations through the end of the year. I need to find a way to strip out the "extra" carriage returns without removing the ones that are supposed to be there. It seems like these is usually a letter followed by a carriage …

Hi guys -- I've a number field with numbers ranging from 3 digits up to 16 or sometimes more. Some of the numbers start with 14 and I need a script that removes such 14 and leaves the rest of the string as is. In other words, removes the first 2 diigts as long as they are 14. BTW, I've FM 5.5 running on SL 10.6.8.

Okay, I have read and am making a Preferences table. How can I keep it to one record no matter what? I check unique but that does not. I thought maybe Get(RecordCount) = 1 but I thought I should ask how other do it first before I get myself in trouble.

I know it can be done with script triggers, but in normal scripts, can I set a to pause/resume once data has been entered into a field? I.e., A user is taken to a field, and the script waits until he has entered the data and then it takes him to another filed or layout to enter another data. It seems that I can only pause it indefinitely or for a set number of seconds. Thanks a million in advance.

I'm used to coding in PHP (and maybe that is the issue here), but when I attempt to setup a loop based on the number of repetitions in a variable in FileMaker, it always seems to get fowled up. Let me explain: Let's say there are three records in a table called tasks Go to Record [First] Loop Set Variable [$i; Value:$i + 1] Set Variable [$taskid[$i]; Value:Tasks::Task ID] Go to Record [Next; Exit after Last] End Loop Now, in my brain, there should be three elements in an array-like variable called $taskid numbered 1 through 3, a total of three elements. Then try to use the variable later in the code to establish another loop: …

hi guys i have scenario but dont know how to execute. Suppose, I have a transaction table for payment having records of payment made through cash & cheque. They payments are shown in a portal row having cash and cheque in different rows. as shown in image 1. Now, the scene is that: When i plug a pendrive the newly payments made through cash should be exported in pendrive, and after ejecting the pendrive, the portal row having cash record should be omitted, as shown in image 2. Again when i plugin the pendrive the payments made through cash should be seen. And after ejection, the portal row should be removed. please fin…

Hi Everyone Please help me figure this out. I have a database that I schedule my photographers to photograph schools. I have 21 photographers who need to know where they have to be on any particular day. Here is some of the fields I have: School name Shoot date retake date photographers Confirmed Tentative Main_Retake_Cal (This is a calculation field for fining Main shoot or Retake purposes) Start_date End_Date I wrote a script that will find the schools that their retake date has be scheduled and confirmed and the script will no longer show the original shoot on the list. (Awesome if the shoot has happened already) However I need it to show the s…

I'm trying to create a snapshot link file from scratch. The reason has to do with the fact that when I create a snapshot link from a server-side schedule, it stored a local path to the server, but the snapshot link is sent to remote users and so the snapshot link fails to work. I've created a file that generates a snapshot link, but it doesn't seem to want to adhere to the declarations I've coded. I'm curious to know if anyone has any thoughts. I've created an example file whereby I have extracted the script I'm working in. Any thoughts about why it won't work? Encoding? Bad XML syntax? Thanks.. CreateSNL_ex.fp7.zip

Hi Gurus, I have a quote table that has a status field with these drop down values: Estimate Opportunity Under Client Review Revised: Under Client Review On Hold Cancelled ACCEPTED PO Received Deposit Received I have a script that generates an invoice based on the quote and it's line items. I want to exit the script and show a custom dialog if one of the last three values (ACCEPTED, PO Received, Deposit Received) is not showing as the status. How would you handle this? Thank you for your help.

Hi Guys, I have tried different solutions but without the luck. Here is my problem. I do have the database on the server (FMS) and I am using the FMP for accessing the database. I have the table with the following structure: Specifications TABLE 1. Name TEXT FIELD 2. Spec code TEXT FIELD 3. Doc file CONTAINER FIELD now: I have the file 0.doc on the server in the same folder as the database file. I would like to make some solution to: 1. When I insert the text to the Spec code TEXT FIELD 2. The script copy the file 0.doc to the new one with the name: (Spec code TEXT FIELD).doc 3. The script insert the (Sp…

I'm trying to determine if there's a way to return only unique values using the List function. I have two tables ( A, B ) each related to the same parent table. From the parent table, I need a way of determining if the set of unique values in A match those of B. List (field) gives me the set of all related values from either table. However, there are duplicate values in (field) for both tables. So, for example, List might return: 1, 1, 2, 3, 4, 4 etc. I need List to show: 1, 2, 3, 4 Any help is most appreciated!

Anyone figured out how to do an OnRecordExit script trigger? Not on Commit or Validate, but Exit. Users want a check that fields have been entered before leaving the record. Commit and Validate run too frequently. Thanks, David

Hi, I am trying to replicate an Access database command in Filemaker (see original Microsoft Access script below) =IIf([NodeEasting] Is Null Or [NodeNorthing] Is Null,"No data","http://195.49.180//DorsetExplorer/?easting=" & Val([NodeEasting]) & "&northing=" & Val([NodeNorthing]) & "&zoom=200&Layers=1,2,3,4,5,6,7&ptx=400000&pty=100000&version=fwma") I have the Easting and Northing fields in my FM database and I need to set up a button which 'on click' will generate the right URL address according to the Easting & Northing for each record and open the web browser. Help much appreciated.

I've spent a lot of time searching for options on auto formatting "names" when entered into a record (i.e. ensuring that names are entered with correct case etc). I'm now familiar with many options from Proper function to "Better Proper" custom functions etc. Further I understand that you can never cover every possible scenario of case usage within names. So, I've decided to take another route, it seems simple, but I can't figure out how to do it. What I'm trying to do: I need a script step that will simply "catch" any name field that does not start with an uppercase letter. At that point I'll just have custom dialogue pop up that says "Double check last name...yo…

I built a database in Filemaker Pro 10, with buttons to trigger email scripts. All works fine in FMP10. Upgraded the office to FMP11 yesterday and now my scripts are broken and won't work in FMP11. Anyone else having this problem? Anyone got any advice (apart from reverting to 10)? How do I get help from Filemaker people?? KB

Hi. I'm using File Maker 11 pro. I have a database with 2000 entries of names and I have their birth dates in my table. I want to have the people's names and their birth dates shown automatically on the current date when I start to use the File maker pro 11. How can I do that? e.g. Mary Jason -- 20 September 2011, Micheal Mark -- 19 September 2011. Today's 20 September 2011. When I start the program, I want to see Mary Jason's name and her birthdate automatically. Also the list needs to have the topic "Born on today". Thanks in advance for the reply.

Hi everybody! I am a kind of new with Filemaker (I am working on since 3 month). After spending my day to find an answer online, I am getting depressed, so I hope you will be able to help, and thank you for your time. Here is the context: I have a form which use a portal (I am displaying records from an other table) On this portal you can find several fields like date, tester name, serial number, part number...and a check-box SELECT I would like to let the user to tick the check box he wants (this part of the job is done) And then press a button which execute a script which save every rows of this portal that have the check boxed ticked AND NOT t…

Hi All, I need some help with a trigger.... I think!! :-) I have created a field that has a value in it. Not all records have a value in the field. I need to have a "Pop-up Message" appear when a user loads a record that has a value in the field. Any ideas? Thanks..MG

I have an older FileMaker soluation (.fp5) with several hundred entries in it. Each of those has a container and I'm trying to find a way to make a script to download all of those files into a location on my machine so I can reuse them for a solution on a current version of FM. The problem is I can't seem to find a way to automate that process with the older FM specifications. I would like to think it's doable because manually downloading those 500+ containers doesn't sound appealing at all... Anyone have any suggestions?

I'm working on a troublesome layout, which involves a layout to enter find criteria, and another to display the results. I want to display the search criteria in the results layout, and have been advised that setting a Global Variable to the value of the search field is the best way. This is in a script triggered on leaving the field. However, I cannot for the life of me find a script action that "gets" the current field value and allows me to include it in a calculation that stores the result in a global variable. (Not without altering the contents of the field, anyway.) Any help would be great. Thanks.