Script Workspace and Script Triggers

One of my reports uses a start date formatted as MM/DD/YYYY. I have written another script for a new report and here is what I need to happen; Â On the present report, say the start date is 11/01/2012 when I select the new report button I want to update the date to the same day (01) of the next month (12/01/2012). Â As you can see, I am now having to manually enter the date in order for the script to run correctly. Â Thanks much...

I use Ver 9-11.. In a each account I build a affiliate special field.. for displaying, showng the differnet affiliates associated with other accounts building a text field that looks like; 4 digits, representing other affiliate accounts, separated by Returns 1000 1002 MAST or the same above field could look like ".1000.1002.MAST" My question How can I make a PickList, To pick one of these account#'s from others Then firing a script sending a select account# or parameter to script? Thanks -appreciate

I am pretty new to Filemaker,and maybe trying to bite off more than I can chew...story of my ilfe.. I have used the GetUrl script and pasted html data into a field called "url_g". In this HTML I am attempting to get some data out of 4 tables and put them in their respective fields. I have tried numerous scripts to accomplish this, and am really struggling. A sample of the HTML code is below: <tr class="ysprow1" align="right" height="16"><td class="yspscores" align="left">&nbsp;2010-11</td><td class="yspscores" align="left">ATL</td><td class="yspscores">77</td><td class="yspscores">34:17&nbsp;</td…

I have a table, There is a primarykey InvoiceID, there is a secondaryprimarykey ProductID and there is a field TotalProduct. I want the sum(distinct field totalproduct) for a particular value of InvoiceID. Without the distinct function I arrive at multiple values in various rows of the portal readout - equivalent to simply Sum( field totalproduct) How do I get the Distinct effect in Filemaker?

I saw some posts regarding extracting file name and path from a container What I need is a little different: I have a container field (FM Pro 11 Advanced) with a link to external files. I need to find a way to extract the file extension. The path and the name itself are totally useless for what I want to do. Then I need to capture that info inside a script that would go like this: Case extension is .jpg extract content then open the file Case extension is .doc extract content then open the file Case extension is .pdf extract content then open the file etc End case What I'm trying to do, is to be able to…

Hello I have a simple relationship between fields in a portal , line item unit Enter (number of items in a warehouse -enter which doesn't change its value once entered, line item unit out of storage Exit (number of items leaving the warehouse) and amount in stock field, which is a calculatuion. line items in minus line items out. The relationship I created using set field on the invoice page Set variable [$$Amount in stock,Value Line Items:Enter-Line Items : Exit] Set Fiedl[Line Items Amount in Stock:Value $$Amount in Stock] Comit records no dialog and Set variable [$$EnterExit,Value Line Items:Enter-Line Items : Exit] Set Fiedl[Line Items Amou…

Hello, I'm creating a script that includes "New Record/Request" script step, and I am trying to find a way that the found set includes only this new record. In other words, I don't accidently move to another record because I accidently moved the mouse scroll wheel. I'm doing a New Record; Set Variable (of the new record ID); Find Mode; Set Field; Perform Find to achieve this effect, but there must be something more straight forward? Thank you

Hey guys, Im having trouble with a script, basically i have the following 5 fields (all text box) and 1 button to trigger script: Storage Type: Rack/Stack # Container Info: Starting Number: How Many To Create: Create Records (button) So now when i click the create records button i want filemaker to create as many records as "How Many To Create:" indicates but like i said im not sure how to do this, im sure it has something to do with a loop, but im really unsure on how to script it, been trying all night. any ideas?

HI to all . I have files of addres and i want to get back the geolocation of that address . how Can i do it ? thank you Dani

Currently I'm working to create a script that will help me navigate from my default page to other layouts with certain conditions. So I've created a field where I calculated the number of records sorted by a category (type) My goal here is to have a script with the following conditions: - If only one stamp is found, show in detail view - If more than one stamp is found, show in list view - If there are no stamps for that type, alert the user and stay on Dashboard layout so currently i have something along the lines of : the screen shot attached. Suggestions on how to proceed? Do I need to set variables here? edit: sorry move go t…

I am running FM 12 03 advanced in OSX.  I have a layout called Patients.  I have allowed the 'X' close button the window to let the user close the window.  When the user clicks the 'X' to close the window, I prompt the user with the querstion: "Are you sure you want to exit ?" (Y/N)  If they press No, I want to negate the 'X' close window button and leave the window open.    The problem is that at the end of the script, even if the user says 'No', after the script closes the window closes anyway.  I think I can capture their response in a $$Variable and then after the window closes if $$Variable ="No" then reopen the window. But, isn't…

Since FMP does not automatically update the year portion of a date, IE; enter 2/26 and 2/26/2012 comes up even though it has already past. I would like to place a trigger in the cell that would automatically enter 2013 the year if that date in 2012 has already past. I'm working in 2013 and I am constantly going back and changing dates. Thanks...

Hello all. I am trying to copy data from portal records into another related table (both share the same parent record as below) in order to populate binary fields for data analysis from a more flexible portal-based records structure.   Analysis_Variables l------------l Patients l------------l Patient_Autopsy ------< Patient_Infarcts  A patient will only ever have one record in the Analysis_Variables or Patient_Autopsy tables (that is created when necessary), but an autopsy can have multiple infarcts (entered via a portal "Infarcts" on a layout displaying records from Patient_Autopsy).  In Analysis_Variables, I have created fields for binary data input tha…

Hi, Please could someone help me out, i want to be able to hide a button until my percentage summary field reaches 80%, is theree a script which i could use to hide the button when i open the form but when my summary field reaches 80% it shows, im thinking i could do an if statement but would much perfer just to hide the button (Reason i want the not to be able to move on to the next layout untill the have got 80% correct) Many thanks

The problem is to open a document on Windows from FileMaker based on a stored pathname. This is no problem if you store the document in a FileMaker container (even as a reference), but can be problematic if you don't. I'm using FileMaker as the presentation layer for a MySQL database, so this doesn't work. I searched various forums and got some really useful hints, but not the complete picture. I thought I'd post this so that others with the same problem might not have to go through so much effort. In the Send Event script dialog, you can select a file or a calculation. File works fine. The problem comes with calculation, as this is sensitive to file paths with …

I a little confused with this script step. Freeze window, to me anyway, should keep the screen from changing until I use refresh window or the script ends. On my Windows machine this does not work. If I'm running a script that changes layouts the layout change is shown on the screen. I have a feeling this works on Mac and not Win? Like many others, I'm trying to minimize the screen flashing problem wherever I can. Thanks, Mel

Hi,  So I got a script that shows a custom dialog to change the layout and remove the subsummary so that the DATA shown on LIST view would be sorted by the column header. My question is in that how can I add to the script so that the custom dialog would only appear under one circumstance: and that is, when the subsummary is shown (ie: when the database is sorted by the subsummary, the dialog shows; but when it isn't it just automatically sorts the list descending/ascending.  In addition, I'm trying to use a global variable to capture the state of the subsummary report... suggestion on how to do this?  I've attached a picture of my script to this post for f…

Hello I have an Invoice database for which I am trying to create an automated notification function much as one might have a calendar function reminding one of meetings in an email program. I am hoping this notification function will scan my Invoices on a daily basis and report all Invoices that are termed "over due". Overdue equals Date Shipped (Date) + Terms (number) is greater than 21, then 42 then 63 (days). Meaning the script will function, unless the field Payment Status ≠ "Paid", and/or when the Not IsEmpty ReInvoiced Date (field). I say and/or since if Not IsEmpty Reinvoice Date and field Payment Status ≠ "Paid" the alert needs to run again at 42 days…

Hello FMForum! I am new to the forums, but I have a question regarding the creation of a header sort within a list layout. Let's say I've created a sort script that sorts the columns from descending/ascending. However, within this layout; I've also created a sub summary that sorts the record according to a certain category. What I want to do is include this category within the listings and create it so that the script for the button will give me the option to LEAVE the sub summary thus totally eliminating it and sorting the list according to the category within the layout. Suggestions? TY!

Hello there, This may be simple and obvious but I'm still learning. I am just learn FM Pro Adv 11 for 10 days. Okay, let say i have an invoice ( as i attach on file). I have invoice order layout, product is add by drop down list, and calculated by table. After i see http://www.filemaker...mlist/tag/modal, i want to add button to redirect to another layout (or popup window), this new layout is show my product list and i can select which item should choose. And after i click save, all item(s) will be show in list product on the invoice. How can i do that? Suggestions? regards, Ez Invoice_order.zip

Hi, I am building a runtime version for a client and would like to create a script that backs up his database. Essentially, it would need to make a copy of the file. I assume the .UBS file or whatever extension I use for it. Is there a script that could do this? Would it need to close the file first? Thanks so much for your advice, I really appreciate it.

How can I add a script step that isolates my found set to the single record I am viewing. Purpose is I have a script that exports XML, however it exports an XML file for all records in my found set. I need it to only export the single record I am currently viewing. Is this possible with out have to preform a manual find before I run my script? This works other then it does not commit the find

I am creating a log for modifications (simple file attached). It uses allow created function to create records based upon the fields' prior values in theory, relating through using a calculation field. I want records created instead of multiple lines because I want to be able to put the value back and also because it seems the right way to go. I have two problems I cannot solve if you would be so kind as to consider 1. With popup and radio, I cannot capture the prior value. I need want a single process which can work on all field controls including drop-down calendar although I forgot to include it in the sample. I have tried everything I can think of. 2. …

Hi, I'd like to make a script which fires from a button in Filemaker: 1. switch to an application called "Protools" 2. Press key "*" 3. Press command-v 4. Press "return" button How can i make this happen? And what kind of script language would i have to use? Automator? Any help is appreciated!

I have some container fields that were optimized for images, containing pdf files that were inserted as files. I changed the field to be optimized for interactive content so that the user can see the pdf, but the files just disappear. They reappear if I change the optimization back to images. There are a lot of them so I don't want to have to re-insert each file as pdf I have already tried importing the container data from a backup. I have also tried setting the field contents in a variable, then inserting pdf with the variable as the filepath. Neither worked. Any suggestions?

I receive several mails and each mail has an attachment generally with people CV. My database imports the email messagtes and tells me the patf for the various CV files. They come as PDF, DOC, DOCX or other formats. Through the Mac I am always able to copy the text no matter what the original file is How can I create a Script which using Applescript does something like tell application Finder to open the file pause indefinitively paste or go to next record? Each Record has a text field called Attachements with the file location such as MYMAC/Users/DANWAN/Desktop/Job-Mails/Danwan/INBOX/CV_Nam_2012-507de0081d207.pdf or MYMAC/Users…

Seems silly that I can't get this. My boss with full access run a script from Manage Scripts which should only be fired as a subscript which requires that it runs on a specific layout. I will not go into the damage it caused but you can say that I almost had to go job hunting. Two requests please that 1) how can that subscript find out if it is being rand from another script which it will be returning to after it ends or whether it was fired independently and 2) how do I tell it not to run if ran independently or if it is not on a layout with a base table in its name of payroll? I told owner not to do that again but I want to make sure. I've tried a few thing…

Helllo, I have to adjust current printing script. So that, based on country --> a different Invoice layout gets selected by the print invoice script. This to meet EU vat regulations... Different informations has to be present for costumes/tax authorities = different layouts my Idea: Based on companies country input in the records I can have the script make an IF script... Example: 1. if Companies::Country = "The Netherlands" = Layout 1 2.if Companies::Country = "Belgium or France or Germany... Or (inside EU) " = Layout 2 3.if Companies::Country = "other country OR lists" = Layout 3 4. If... No…

I have a table of manta ray surveys (Surveys table) with each survey receiving a timestamp. Each survey has multiple manta ray sightings (Sightings table, related by surveyID, one to many). The mantas are recognizable so there is an individuals table (Individuals) that also have many sightings of that individuals (Sightings table, related by individualID, one to many). On some sightings, a size measurement of the manta ray is taken, so the size field in the sightings table sometimes has a number, or is sometimes empty. I'm trying to write script that will populate a "Growth Rate" field in the sightings table. Essentially I want it to: 1. Find records in the si…

Hello, I'm oh so close to getting my script to work properly! It's a script (credit to bcooney!) that I use to Email invoices as .pdf attachments. Only part now that I can't seem to figure out is whether it's possible to make it such that a found set of records that contain the same E-mail address(es) go out as only one E-mail with multiple attachments, rather than several E-mails to the same person(s) going out with one attachment. Attached is a screenshot of the script I have so far. Thank you so much for any help/input!

I'm looking for a solution to mark records which have duplicate fields in a found set. For example after constraining a found set of client records I would like a way to mark those, and any other records outside of the constrained set which share duplicate values in certain fields such as the same email addresses or phone numbers, and then return to the original found set. Can anyone point me in the right direction here, thanks.

Hi, need a script step(s) to paste the contents of the clipboard to the next unused row in a portal. Which, I suppose, is by definition also creating a new record in the related table. In this case, my portal contains only one field. Both the portal and the field are from the same table. But as long as we're on the subject, I'd also know how to do the same thing if I were to have to specify a particular field because the portal contained more than one field. TIA!

I have a value list. Once the enduser makes a selection from the value list I would like to trigger a script where the user has three choices, to "Apply Primary" (which runs an apply primary script); to Apply Additional (which runs a applyAdditional script); or to cancel. What would such a script look like? I believe it would be "On Object Save" trigger.

Hello Board, Thank you for all your help so far. Even if you've not replied to one of my recent threads, i've read a lot of the posts here and gained some good understanding of what I'm doing. More importantly, i've built parts of a database that are working and helping people do their jobs. I still need some help. I need to build a script that will automatically create new records in a database. So, an operator inputs a JobNumber. This looks up data from the ProductTable. If the Product listed on the JobNumber has a field value (in a paticular field) of YES, then i need the operator to be prompted to enter a number (say 25). A script then goes to…

Hi all I have a slightly unusual problem I have a table which has two layouts - one for browsing and the other for finding The find layout is controlled only by custom buttons and menus I set it up so that when someone hits the perform find button it runs a script which takes them back to the browse layout This seemed to be working fine except the only machine where this works is the one with filemaker advanced on. It does not work on any of the other machines The script does not seem to run - it goes into browse mode on the same layout - something I am trying to avoid as I want to keep the two modes distinct Does anyone know what could be causing this I …

Hi Everybody, As you know, FM Pro 12 doesn't enable the user to double click the file in the container field to open it. Is there a way to script this, without exporting the file to the desktop? I tried the various solutions under this thread, to no avail: http://fmforums.com/forum/topic/83646-script-step-for-opening-non-filemaker-file/page__hl__container Thanks in advance for your help! J

I'm looking to write a script that prompts the user with a re-login screen when the db has been idle for 30 min. OnTimer takes care of some of this, but I've found no way to calculate the user's idle time. ( Also, I don't want to set an idle timeout on FM Server that would affect ALL hosted databases. I'm looking for a single-file solution. ) I believe there's a plugin that may handle this type of thing (FMButler?), but I'd like to be able to build this directly into the solution. Any ideas? Thanks.

A bit of an odd request here. Working on a client database that has several multi-page layouts. Client wants a PDF report that is simply a printed version of all the layouts ( a single record, but 18 pages ). The number of pages will always be static (18), because it's a single record. However, because we have layouts that are more than one page long, I haven't found a clever way to handle page numbering in the footer. I'm familiar with using calcs and set field steps to aggregate page numbers on muti-layout, appended PDFs. That won't work in this case. The big problem is that there appears to be no way to isolate a "page" in Preview mode. Any fiel…

Hello I would like to have a checkbox - either a single box where a value entered ie Y which does the same as the omit records box on the status panel So if the box checked and constrain found set is used then it will omit the found records I should say that my layout is a custom layout where all the finding is done using buttons with scripts Also is it possible to change the omit state using a variable ie Request the omit state using the function (normally would be 0) and then changing it to 1 by changing the value of the variable later in the script Any pointers greatfully rec'd for this one

Hi everyone, I will be very grateful if you can help : I have an accounts file I share via Dropbox with several colleagues,and I need to implement a script that will enable them to export all the files contained to a folder on their desktop,on a quarterly basis.So,it should work like : Make a Folder named " Exported Files" on the User's desktop (via AppleScript,I guess) Loop Go to next record,export field contents from the Field X to the above folder Exit after last and then Export Found Records to Excel to the same folder as above I know it must be relatively easy to compile such a script but as a newbie,I'm really stuck... Tha…

In my recipe database I have on tab for the recipe and one tab for the picture. For some of the recipes there are interim pictures showing steps of preparation. I thought about using repetitions, it seems there is not a lot of control over the screen layout. If I select 10 repetitions there are going to be either 10 "slots" down or across. I tried searching for some options but came up empty. Is there a trick I am missing?

I can't wrap my head around how to deal with this. I have a field (Field 1) with hard returns. I would like to use these returns as the basis for creating individual records. I need to script this due to the number of records involved. Here's an example of my starting data: Record Number Field 1 Field 2 1 abc Joe def 2 ghi Fred jkl mno This is the desired result: Record Number Field Field 2 1 abc Joe 2 def Joe 3 ghi Fred 4 jkl Fred 5 mno Fred

Hi there, I am trying to get my co-worker set up for E-mailing .pdf Statements to customers every month. I created a script for this which works just fine, except for the fact that if several statements have the same email on it, it will send multiple emails to the same recipient. I've attached my script. I realize that my If statement is way off the mark, but what I was trying to say is if the script finds a duplicate email, send the invoices as "records being browsed" so that those statements are sent as one, continuous, multi-page .pdf attachment to that recipient, rather than that recipient receiving multiple emails of one page statements. Otherwise, send o…

In my recipe database I have a layout of all of the recipes. I can click a field to select the recipes I want. In another field I can scale the recipe to 1/3, 1/2, single or double. I have a script that selects the ingredients for the select recipes, summarizing to make a shopping list. I can't figure out how to send the list via email. Ideally the request was to text the list to my phone, but email would work too. I have done emails, I scripted a mass email for a mailing list. So I have used to screens.

I've finally had some free time to spend on testing some of the things which puzzle me. One was suggestion by BruceR to use Replace Field Contents[] against a global for populating variables, such as a list of IDs from a found set. The results on 6,000 records were quite impressive: Loop in version 11 - 19 seconds Global in version 11 - 1 second I have a new favorite technique. Thank you Bruce from this post ... see post #7 http://fmforums.com/...ds/#entry394842 Even more astonishing ... when I converted the file to 12 and ran the same tests: Loop in version 12 - 2 seconds Global in version 12 - 1 second And I was sure to restart FM betwe…

Despite having worked with FM since it was Claris (!), I'm struggling to create a database solution for tracking hours under AWR for temps for our recruitment agency. If anyone has an FM solution built for this already, please get in touch! Many thanks.

I have two related databases. The first one is called "Invoices" and has two tables. The first table called "Invoices" has the following fields: "Record ID", "Invoice Number" and "Description". The second table called "Line Items" has the following fields: "Record ID", "Product ID", "Description", "Price", "Quantity" and "Invoice Total". The second database is called "Product" and has the following fields: "Product ID", "Description", "Price" and "New". This last field is a check box field that is check-marked when the product is new in the market. Now, as you can imagine, I have a portal in my "Invoices" database (and table) showing records from "Products" to which I add…

I have a script that acquires a value in a variable. For example: $CustomerName = "Tom Smith" I want to be able to retrieve the associated CustomerID from the Customers table once I have this value. Is there a way to do it without going to the layout, finding the record and the setting a new variable with the CustomerID? Can I use a lookup to do this? If so, how? Cheers!

Hello!.. looking for a simple starting script/relationship foundation to convert proposal records over into invoice records. Would be working with 4 tables: ProposalTable > TaskTable ~ duplicated into ~ InvoiceTable > ItemTable Any ideas?

Hi, Is it possible to trigger script to omit records inside the drop down menu. The data are from the a value list of property. I only like to omit records that are single residence from the property table. Thanks. Spidey

All I'm trying to do is go from one layout to another of an unrelated table and then perform a find as follows: Go to layout Enter find mode Set Field (moved to table; moved from table) Perform Find Set Field won't enter a value and neither will Insert calculated Result. Copy/paste will work and so will Insert Text. I thought Set Field should work with unrelated tables.

I'm trying to run a script that emails purchase orders to internal employees. We only have about 20. Currently the database uses user.name to identify who created the purchase order. I want to be able to email employees these purchase order base off of the user.name that created it. Is there a way to say for instance. User.name is mike.doll Email for mike is [email protected] How can i run a script that would do that. I'm assuming I have to add the email to the 20 user names somewhere and link them.

I have this converted FM11 to FM12 file, which in FM11 runs without a hitch. Now in FM12 it just plain seems to hang. The table has about 250K records in it, but that should not be a problem right ? When I do this script step FMServer statistics go to about 1500000 for elapsed time/call ; I/O time/call also thorough the roof. Eventually it seems to actually finish the script step ; it takes about several minutes. should I rebuild ? While waiting for your replies I will remove all unnecessary calks

I have a script that displays a report in Preview mode (due to sliding objects, etc.) However, once it's been previewed, I want to allow the user to go back to the previous layout. My script pauses when it enters the Preview mode so they can take as much time as they wish to view the report. How can I then cause the script to resume again?

Not sure where to put this question. The only way I can think of to achieve my goal is with script triggers so I thought I would start here. I am sure there is probably a more efficient way to do this. I have a database that makes extensive use of GO TO RELATED RECORD. Most of my time is spent on a list type layout monitoring design issues for my cabinetshop. Periodically I need to toggle to a memo field on another layout then back to the list layout. Both directions of travel are based on GO TO RELATED RECORD. When I return to the LIST layout It is hard sometimes to find my current record. Is there a way to make the current record (or field) chang…

Hi, Ive been building a script that inserts a picture into a container field, that has its location specified by a calculated text field, this works sequentially. This works quite well. However as the script works through the 40K records in the database I would like to run an Applescript that changes the label of the files as they are imported, to see if there are any that have not been incorporated, (or otherwise mark them). The bit that works OK so far is: Fo to Field [select/perform; Macintosh_HDOld Converted::picref] Set Variable [$File_Name; Value:Macintosh_HDOld Converted::picref] Go to Field [Macintosh_HDOld Converted::Pic] Insert Picture [Referen…

There must be an elegant way to achieve the following: I need data to update in fields A, B, C (table A) based on changes made to field Z (table Z). Fields A, B, C must be editable fields, not a calcs. I can achieve this two ways for now, neither of which I like: 1. Set the target fields (A-C) as lookups, then set an OnObjectModify trigger on field Z that runs a re-lookup script. I don't like this particularly, because I generally avoid lookup fields when I can, and the re-lookup script step is performed on all records in the found set. I just need the current record to be updated. 2. Script the process completely. OnObjectModiry trigger on field …

Hi, I have found an example on the web of an resourceplanner and in this example did they use this sign: "¶" resource_data_1::Res_data_status & "¶" &. What is the function of this sign..?? Thanks, Frans

Hi All, I need to create a frontend for users to upload audio files into ContainerField and then it gets exported/stored to a designated network drive. I also would like the ORIGINAL file in the ContainerField to now become a reference link to the audio file in the designated drive...is this possible? Any help is appreciated!! Thank you, Dave

Hello again filemakers, I have 2 tables one has contact data and the other has job data. They are related by a serial customer id number. I have already made a button that users can click and create a new job. Now i need to make a button that will allow them to view only the jobs for the customer they are looking at. So if i'm looking at my customer the Poop Bank, i want to have a button that will take me to the other table and display only the jobs that were made for the Poop Bank. Here's the script i have tried so far but it's not working: Go to Layout ["Billing Entry" (Billing Entry)] Set Variable [$ID; Value:Contacts::Customer ID] Enter Find Mode[] …

Dear All, I want to store more than one file of different format in a container fields, and also I want to retrieve the same files, whichever I want. Please help me doing this task. Thans in advance...

In version 11, file options allows a script to run, such as a startup script. It is gone. I found, I think, that it has been replaced by OnFirstWindowOpen. I thought I would then go to the layout which I specify in file options and that layout would hold a script trigger (with all its other ones) but it is not there. I read the help on it and it does not say where or how I attach it on file open. All it says is: OnFirstWindowOpen Triggers a script to run each time you open a window of a database file when no other windows for the file are open. When the script runs After the first window of a file is opened. Modes in which the trigger can be used …

hi, I an new to scripting. I have made a this script myself. Script does execute fine. But there is one little problem with it. At some specific point it does not assigns value to the field. I don't know why. I am attaching the image of my script. Because i don't know how to export it in TEXT format. I am highlighting the part that suppose to assign a value in the field.

I have one layout that has student information. The unique field is StudentID. I have another layout that has different information with the StudentID being the unique key. In the database relationship the studentid keys from both layouts is matched. Now I made a button so when I am on a certain kid and want to find out some information from another layout I click that button to go to the that layout. But I cannot seem to script where the layout will open to that student's record by ID number. I can get the layout to open but it will just give me that last student that the layout was open in. How do I script to go to that related ID? If I use related record it d…

Is it possible to create a matrix in FM? I am developing something for the hotel industry and they have very complex booking structures. What I would like achieve is the following. On the left from top to bottom are the names of the products such as luxury room, standard room, triple room,lotus,jasmine etc. On the top running from left to right are the date from date1 to date 31. I know the FM portals only display records as rows. How would one create the vertical columns? Can it be done? Maybe similar to a calendar display? Thanks

I'm on a roll tonight... I hope I'm not overstaying my welcome here , and also that this question is not a "tl;dr". A friend had a glance at one of my scripts and expressed concern at the number of variables I was using in a script to write values into my "Shipping Line Items" record (maybe 10 variables, all local). At some point, she had said "Lookups are useful where they are useful, but using variables is OK where it's appropriate." It appears that maybe I took some undue liberties with this... In this case, the source data is in one of two portals at the top of the layout. The user can "Add Line Item" to the Shipping Line Items table from either portal.…

Hey all, Using: Portals, Go to related record, Scripts, If/Else Statements Background: In a portal... I currently use a script to go to its related record in another window with LayoutA. Looking to do: I now have multiple layouts that I need to go, depending on Field1. Details: So if Field1 = "John" I want it to go to LayoutA If Field2 = "Betty", I want it to go to LayoutB If Field3 = "George", I want to go to LayoutC In a regular Script I have dont this and make it go to those layouts with no issue, but I am struggling to do this in a portal. So if anyone has any ideas, please let me know. Thanks!! Blake

Hi there, does someone know is possible to count Layouts but per each Table separatly? So if You got table: "Car" which has layouts: Price_List, Model and Purchase And then table: "Contacts", with layouts: Contact_List and Contact_Profile Obvious that table "Car" has three layouts and "Contacts" has two...but can we figure out that in script which will make calculation of how many layouts are per certain table? Any help appreciated Thanks in advance

Hi Everyone, I've checked and searched here and in the manual but no joy! I've got a container field that has things like pdfs jpegs etc in it, and i'll like to be able to see the file in the finder (so that i can then drag / drop into things like email). Can anyone point me in the right direction / link me to a solution? Im guessing that there's a script step of some type that would solve it. Many thanks for any help you can give, Slater

I have a script on a button that currently clears the content of a field. Can any one please explain how I could adapt the script so that I use the same script Ie. clear but the field clears depends on the parameter. For example I want button A (with script parameter for example "A") to clear the contents of field A, while button B (with script parameter for example "B") to clear the contents of field B, and button C (with script parameter for example "C") to clear the contents of field C. Any help much appreciated. Thanks

Guys, I've tried to look everywhere but I can't find the information I need. I need a script that performs a series of action. In the middle of the script I would like to have a dialog box that allows the person to insert some text. After that based on that text I need the script to perform a search in the database. Hope to be able to explain the problem... thank you for your help!

Hi, I need to write a script that (based on a unique key defined by user in a field of the current record) copy a field from the record that match the key in the same field in the current record. E.g.: I have a table "Contracts", the user is inserting a new contract, he choose another contract by a self-relationship of the table "Contracts" and my script have to copy the field "PaymentMethod" from the other contract in the current contract. This is only an example to simplify the understanding, the real problem is more complex. Thanks in advance.

I've been having some issues writing a script for a database I've been developing, and I hope someone can help. I'm not even sure what I want to do is possible, hence my confusion. Essentially what I want to happen is for FileMaker to check whether a particular value from a drop-down value list has been selected; if it has, then I want another field, one that was not previously visible on the layout, to appear. This visible / invisible field is obviously part of a table; I'm hoping that it will appear only when this “trigger” value has been selected. I should stress that I'm new to the world of scripting, so any non-technical help will be appreciated. I'm u…

I have a database with 3 tables. Customers, Service Calls, and Service ques. This question is about making a button that will move all of the customer information from the customer being viewed on the customer table, into a new record on the service table. So for example, if company A calls in with a broken machine i want to look them up on the customer table and then click a button that will go to the service calls layout, create a new record for this service call, and paste all of the relavant customer information into the fields so that each customers service call gets a new line that i can have a line for each service call. thanks, Justin

Post: I am using an academic gradebook application with FMP 12. I use one of my layouts to enter student attendance and participation credit by class date. For this layout, I create a new record for each class date, class ID and student ID. Because my database records consist of multiple students, multiple classes and class dates, I use a join table consisting of a unique Student ID and a unique class ID for each student and each class. To identify my student, I have placed a student ID field on my layout which is a unique field that relates to the Student ID field in my join table. To simplify data entry in creating new records, I made my layout's student ID fie…

I need to calculate a commission value from a currency field called "amount". Over the first 2500 the commission is 15% with a minimum of 40. Over the next 2500 the commission is 10% Over the next 5000 the commission is 5% Over the next 190000 the commission is 1% Over the remaining amount the commission is 0,5 % with a maximum of 6775. I am stuck Help is rewarded with a LinkedIn endorsement or enternal friendship! Dick

I have a script to determine whether or not a person is a teen at the time of a specific event: teenAtTheTime, calculation, numeric result Case ( ageAtTheTime>12.99 and ( ageAtTheTime ) <20 ; "1"; "0" ) I placed the field on my layout page and formatted the field as a check box, boolean = 1 How do I get the checkbox to be checked automatically if the condition is true? The way I currently have this set up nothing is checked when the condition is true.

Hi. When entering the height and width of a garage door I enter it into 4 fields: <<Height-Ft>> + <<Height Inches>> <<Width-Ft>> + <<Width-Inches>> It looks like this on the printed quote...... Height = 11' 7" Width = 12' 4" ------- Is there a way for me to add those 2 fields together and show the Height total and Width Total in Inches?? Any help would be valuable and appreciated. Paul.

Hi there, I've got a school database with a list of students. Some students attend once a week and others attend twice a week. I need to print small printouts for each student - if they come once, ONE printout, if they come twice, TWO printouts. I could do this by printing out all the students and then printing again only the students who come twice, but this will get messy as this is not a once print-off, it is an ongoing thing over the course of the next month and it will be a waste of paper if I am prining small bits on whole pages . I also don't want to duplicate each student's record who comes twice because then my database will lose it's accuracy. Can…

I send out to customers a PDF to sign. I either receive it back via email, where they have printed, signed, scanned and named it something, or via fax which comes to my email as a PDF with a horribly long serial number. They are always PDFs, and I'm hoping there is a way when I import them into the container field, I can have a script trigger or something that renames the file in the format I want. For example: Last Name, First Name -Job Number.pdf Is this possible? Thanks.

I had this problem with FM 8.5 and finally cured it but I don't remember how. I have search the forums and knowledge base with no results. Now with 11 it has come up again. I have two machines, one shares the files with the other (between my office and shop, I am the only user). The machine that shares the files starts up and launches FM and also opens the shared files. The problem that occurs is, about 75% of the time FM launches fine but does not open the files in the script. The script is simple and does work as soon as I click on FM in the dock and click "Open Recent". Why it works normally 25% of the time I don't understand. This is not a big deal as far as time spen…

I came up with a solution to a problem: I needed to title a set of records (items, descriptions) from a specific volume (search result of an indexed field) which is part of a larger set of all volume items for a publishing CMS. I used a standard deviation summary field to control the display of a conditional title to let the user know that all the records of a selection had the same value in one field; if the volume number is all the same for all found records. If the deviation is zero for that field then I know all the records have the same value for that field and it conditionally displays the title in the header that shows that value (volume number). If it is anything…

I can write a script that goes through each record and exports all the containers, but not all of my containers have the same file type. Is there a way to make it just either export the original file name, or preserve the extension? I have 15 containers per record, and I would prefer to name them "1.original extension", "2.original extension", etc. Is that possible? Thanks!

I have two tables, Properties and Quotes. On the Quotes table, I have a portal that sorts the properties by distance. For example, I put in a Quote for Miami, Florida, and it pulls the Longitude and Latitude from a third table of Zip Codes, then sorts them in distance from Miami. This part works great, but now what I want to do is have a search that sorts the same properties by distance from an exact longitude and latitude, for example a starbucks in Miami. When I enter the If statement, it doesn't work correctly. It either shows a mix of the properties, or they all show a distance of zero. I'm not sure what i'm doing wrong... Here is the calculation, which …

I am looking to create a consistent environment. Is it possible to have a client press a button that tells the server to preform a script rather then having the client application doing the work? I may be thinking about it wrong, but like a server will run a scheduled script, I would like a user to initiate a script by pressing a button but always have the server perform the action. The only information I am going off of, that makes me hope I can do it, is in the script dialog there is a compatibility drop-down for client, Web, and Server. I am hoping that the server can do more then just a scheduled task... Any ideas?

Hello everyone, I have a script used for reporting which goes through a series of layouts and saves and appends them to a PDF file. When using FileMaker Pro 11 Advanced, the output 15-20 page PDF file was about 1-2MB. However performing the same script in FileMaker Pro 12 Advanced results in a 40MB PDF! Are higher quality/definition PDF's a feature of FMP12? Is there any way of telling FileMaker to compress these PDF files to a more manageable size? Its really annoying becuase at the end of the script these files were being sent via email to recipients. We have a cap on email attachment size where I work and its not possible to send 40MB files. Is there a w…

Hi, when I select "Show custom dialog" in a script, by default only shows one line for introduce text... is possible to increase the lines?

Yeah I know there is no OnNewRecord script trigger - but this is what I would like to happen. I have a a table called Prospects where prospective clients input information via our website. New records are created in the Prospect table once the client pushes the submit button. Is there a way to trigger a script each time a record is created in the Prospect table? The script I have written simply emails my office manager to alert her of a new prospective so she can send them information. Thanks for your help, Jim

I just can not get Export Records to well Export any records. I am guessing I have something wrong with the way I am trying to write the export path. I am working on setting this up to run from a button press. The button gets the current visible record and then constrains the found set to just that single record. I am hoping to make this work two ways, one button to save to users desktop and second way to say to a share point on a server. I am running the clients on a mac that will be running the script via a button. I have two servers one windows server 2003. Second is a mac server 10.6.8 I would include a sample of what I have been using as an output path but…

I am VERY new to filemaker pro v11 [or any version for that matter]; I just began using it to manage data for a non-profit group. I am trying to write a script [assuming that is the correct way to go about it] that will be based off of one data field. When "yes" is selected from the first data field's value list, i want four other data fields to either all read "N/A," which is also an option in the value list, to disappear, or something to that effect... however, I have yet to write any code and my own attempts continue to fail so far! I suppose a third option could be that the other four fields are already hidden and only appear when "no" is selected. Any help …

When I run the script "Flag Enrollment Records & Import into Students" I get the following error: "A table cannot be imported into itself" Cannot seem to figure out where the problem is in the script. Please advise. Thank you. StudentList.zip StudentSchedule_FmForum_Aug23.2012.zip

I have a script which 1. Finds a particular group of records 2. Sorts them via: a sub-summary field (week commencing date), then a date field (appearance date). When I have run the script the first time after creating it or modifying it, everything works fine. Then if it is run again, it sorts through all records — not just the found set. It still returns only the found set in correct order but the time taken to sort through 10,000 records when it only needs to sort 60 or 70 is annoying to the operator. Why is it happening? One more thing: it only seems to happen if the script runs with no dialog — but if I run it with dialog nothing is required o…

Hello, I've decided to start a new thread as I think this is now a different problem from my last post. I've located my problem; but I'm not sure how to fix it. I have a script that will take the values from a certain field from my RunSheetLines table and then it will Set Field in another layout. When I disable or clear the sort function from my script, the variable will take all of the values from all of my desired RunSheetLines. But when I introduce a sort (I need to sort according to Date and then Time), some of the values from all of the RunSheetLines fail to be carried over. I can't seem to figure out why it is doing this, nor how to fix it…

Hello, Here is what I wish to achieve (I am in the event management industry): I have a final Estimate and from the information in its related EstimateLines table I wish to pull out a value of a certain field to use to populate fields in a PlanningDocument table. Working with Loop, and moving to next record, I have it working somewhat, but I can't seem to find a way to assign a different variable for each Loop/EstimateLine. I understand how to Loop with a counter; but what I can't seem to figure out is to script a different variable for each Loop? In other words can I do something like this: $Item + 1 Or is this the wrong approach? Might …

Hi, I have a script that insert text in a field, is possible at first move the cursor to the beginning of paragraph? Thanks. (maybe the title is better: "move the cursor to the beginning of paragraph" but I don't know change)

Hi all, I have the same problem as a previous post in 2010 (archived since). "I am using the WriteToFile function in ScriptMaster v3.33 with FM 10 Adv on Windows. I want to create a plain ASCII text file with CR/LF as the end of line characters. First I put my text field into a local variable $text and replace all CR with CR/LF using: Substitute( $text; [Char( 11); ""]; [ Char( 13); Char( 13) & Char (10)] ) Then I use WriteToFile to create the file. I have tried several character encodings when I register the WriteToFile function (ASCII, utf-8) but they replace my CR/LF with LF. I tried to specify MS-DOS but that encoding is not supporte…

Hi, please, is possible to generate a script that runs at change field? For example if I write "text" in any field in other field writes "You have written text" Thanks,

EOS a member here has really helped me a lot and got my FileMaker Pro 12 working great. But now my office decided that they will stay with Filemaker Pro 11 adv. and want the database rebuilt. I have moved everything over to FileMaker 11 but I am still getting errors and I cannot seem to find where I am messing up. I have rewritten everything that I could by printing out everything and redoing it but not working. I have attached the database and sample EXCEL data. I am thinking it is a scripting error. Thank you. OK, I tried rebuilding the whole database from scratch and now I get "Database cannot import to itself" when I run the Flag Enrollment script. I am really lo…

Hello, I am using a template adapted from the starter solutions (Event Managerment) on FMP 11. I need to copy an event and its guests (the users call them participants). The script is working fine for this purpose; however, I need to also copy the Participant Type for each guest. The script uses a global field to collect the contact ID's, event contact ID's and the Participant Types. Then it creates a new event record and uses a utility layout to create the new records. In order to move a blank into the value that's been used, I do this: Set Field [g_ParticipantType; Substitute (g_ParticipantType; Right (g_ParticipantType; 1); "")] This is whe…

I am trying to figure out the best way to navigate my user between separate databases without having to open the same databases over and over again. My users are on FMGO12 and I would like to keep the databases open (but hidden) so they do not have to keep loading each time they are accessed. I have a database called "STAFF" and another database called "PRODUCTION". I have a relationship that is based on the user's id. I have experimented with a "Go to Related Record" script step and this only works if I tell the script to open the results in a new window. So what do I do with the window that the user is coming from...and more importantly, how should I write the scri…