Script Workspace and Script Triggers

I have a database that tracks all of the VFX shots we have in the current film I am working on. I am looking to get some help on creating a snapshot layout to report how many shots per vendor are estimated to be finaled for the week and how many shots actually are final. I have a table labeled "Status Report" that has a list of all of the shots we have in the movie based on vendor, with the field for vendor being "Facility". The table also has fields for the shot "FX SHOT #" and the date the shot is supposed to be final "POST: Final Delivery". In another related table, "Filmout Takes" we bring in all of the submissions we get from our vendors and that matches up to th…

I'm using GetNthRecord within a script and increment the record number parameter. It seems to ignore the parameter and return the value from the field in the current active record. When I try this within the Data Viewer, I do NOT get this behavior and it shows the correct record. Any ideas?

Hi all I'm trying to work with the Save as PDF script step routine in a multi user environment. The idea is that a user will click a button and save a PDF (which has a pre defined name)of a generated report to a location on the file server which they themselves specify. This is the part I'm having problems with. I've looked at the Filemaker tips and videos and can see how to structure a static path using variables. However, the use case I have is that the PDF generated can go anywhere the user pleases, so ideally what I want is a 'Save as' dialog box to appear to allow the user to navigate through the network to the desired location. What is it I'm m…

Hi i recently uploaded my solution to webdirect, however my clients are complaining that they find it dificult to navigate. this is because in Pro the system would bring up related records in a new window aside to the previous record whereas in webdirect the current window fills the entire screen and the browser back button doesn`t even seem to work it just takes you out of the entire solution. is what i figured i would place a back to previos record button on the page so the user can navigate between the current and previos record in an easy fashion. I tried to figure out how to achieve that but unfortunately can`t seem to ge to the bottom of it. …

I have a layout that has a search field on it, the search field does dynamic filtering of a portal. This works fine when I type in a series of letters with the keyboard. I have added a alphabet button bar to do entry with a mouse, when I select a letter with a mouse the selected letter is placed in the search field, this also works fine. My problem is, is that the search field does not recognize that a letter has been inputted, how would simulate a keyboard entry? Using this step to set filtering field. Set Field [TO6_List::g_search_list; Get(ScriptParameter)] Related question, how should I go about entering a series of letters into the search field for…

I'm trying to collect the correct answers from a test exam. For example, 35 questions, a, b or c as possible answers. I've made a script with a variable into a loop that collects the data such as: $Var [ question number & "space" & correct answer & "carriage return" & $Var ]. With it I get something like this: 1. a) 2. c) 3. a) 4. c) 5. a) 6. a) ... Is there a way I could make this appear in columns? Like 1. a) 4. c) ... 2. c) 5. a) 3. a) 6. a) or 1. a) 3. a) 5. a) ... 2. c) 4. c) 6. a) Thank you.

As the title suggests, just wondering if it's possible to resume a paused script directly using FMP URL? What I mean by directly is not having to call a new script in the URL which will resume the original script.

Hi everyone, I have a parent (Site), child (Inspections) and grand-child (Parts) relationship. I have a field in Site and a field in Parts which have both inherited the same checkbox value list (file with sample data attached) What I need: 1) consolidate only a single set in all items into Site::fieldList1 for the parent. 2) many of the values in both Site and Parts have spaces before or (possibly) after the value 3) If there is more than a single value in the result in Site::fieldList1 and one of the values is 'none', I need the 'none' dropped I considered recursive custom function, trimming the spaces first and then using ValueListItems() or …

I've been working on this much longer than I should - I must be missing something simple. I have this script set to run on first window open - would like to be taken to an ipad specific layout. Any idea what I'm missing here?

hi i would like to know if this is possible. i have a solution which works in stage , first one completes stage one and if he wishes to continue he takes his stage one to stage two by creating a new record in stage two and autocompleting via variables in a script. however i do not want one should be able to create the same stage one again to stage two, thererfore i want that once a script has run once it should become inactive and display different text, is this possible through scripting? please can someone let me know there comments. thanks. or if someone has a different method that it shouldn`t be able to create a duplicate…

I know this can be done, but I am not sure where to begin. Related Records only give me one item back. I have: Table 1 has 50 records one field(part #) Table 2 has 10 records one field(part #) I want to use table 2,10 records to find those records in Table 1. So in the end, I will be seeing Table 1 with only those found records. Thus max would be 10 records(if all were found) out of the 50.

Not sure where to put this Sometimes I put a commit just because I do not know when it is not needed. Example, if I create a related record while on parent record by just using set field through to the child table and then I switch parent records, can I safely assume it has committed the child also? If I switch layouts to a different table, is the current parent committed automatically? Are there are guidelines to help me understand it? Maybe it does not hurt to commit just to be safe but I really want to understand it and not commit needlessly. thank you. btw, I searched for commit and was overwhelmed and most of it did not fit my request. If there are links …

I have a photos table with the images stored externally. Id like to move/copy from one database to another - both hosted on the same server. I have tried importing both the records directly and as a "folder" but as my up load speed is not great is it very very slow. On the same server it should be fast. Also have tried server script with errors. Other techniques gratefully received

Hello there Forum, On a filemaker 14 platform, i have a server scheduled script that goes through records and making use of the email field in order to send a Home Sync reminder to staff using SMTP, since its implementation it ran normal until very recently with no alterations on our system, i noticed there is an error in the schedule list for this script, i tried running script manually and i get an error message "Emails could not be sent successfully" also the email does not go through at all, that is none of the persons intended to receive it gets to receive it. Anybody have a solution to this problem please to assist me, Many thanks.

Hello, I am using Windows OS for my solution. I have a layout in list view showing events. An admin user is to add groups of people as attendees of these events by pressing a button to run a script. The script Freezes the window, changes layout, adds the attendees in the relevant table and returns the user to the original layout. This all works well, except for when the script returns to the original layout and unfreezes the window, the scroll position of the active row (the record that the user is editing) jumps to the bottom of the screen. I would like the scroll position to remain static or be returned to where it was before the script changes the layout -…

Hi guys, I am new to filemaker, I have managed to create a database following some tutorials but now I have encountered a problem I am unable to solve. I think the problem is mainly in the script. Because I really need this done fast I will transfer the first person that can solve it 30 euros. I am doing a research on flamingos in zoos. I have used two portals in the layout: one zoo can have multiple enclosures and each enclosure can hold multiple species of flamingos (see attachments). In the layout view this is working great, but I need it to work in the tableview so I can export the data. The problem in the tableview is that the EnclosureID used in t…

I have a field that displays a "version" in my invoices. All new invoices start as version "A", however when a certain script is triggered I need the version field to advance to "B", then to "C" if it's triggered again, and so fourth. I thought if I could capture the current version as a variable and then set the Version field as $version + 1 would do the trick, alas I was incorrect. What's the best way to script this? Additionally, should the Version hit letter "Z" I would like the alphabet to start over again as doubles, such as "AA", "AB", "AC", etc... Thank you! === Update: So some tinkering and I got this calculation to a…

I am attempting to make a start up file that, upon opening, closes and triggers a script that performs a 'open' script in my actual file. I have done this many times with out issue. However here is the problem. In my open script I am checking the IP address of the client. If it is within the building with the server it logs in thru one IP address, if it is outside the firewall it logins in through an different IP. For some reason filemaker is crashing when I try to add the second IP in my script. This actually fails in new files and in my original open file that works, however it fails when I try to modify the close file script. Any thoughts?

It's been many years since I developed in Filemaker. Still have my FM7 Dev sitting in the original box on the shelf. Anyway I have just purchased 2 Windows 10 tablets for the purpose of running a FM solution (which I still need to develop), collecting field data and photos. I will purchase FM14 momentarily to start development. The slightly tricky part of the equation is automating the camera and image importing into container. I know FM Go does this, and I know the lack of this functionality in Windows has been discussed many times over the years. I also know that there's video screenshot grabber plugins available but they are not good enough as image quality is very poo…

Hi, Im in deep trouble I need help using scripts I am making a homework managing app for a project and i have created a few fields; date due, subject, task, and task type I need help on how to process this information and show computational thinking I need help in creating POP UPS!! I am looking for something, when clicked on, pops up a screen showing the outstanding work when the user clicks on button 1 which has a date which has past . AND I'm also trying to make a button 2 which shows entries that are close to the next few days please help as soon as possible and suggest any features i can add to the homework manager and how to writ…

I have a script that is attached to a button on a layout. the script first step of the script opens a new window with sizing parameters and then goes to a layout. The problem is the script is resizing the window that the button is on, along with opening the new window in the dimensions specified on the New Window step. I can't figure out why this is happening. I don't want to change the size of the current layout when opening the new window. The steps of the script are: New Window go to layout perform find Sort Records Enter Preview Mode Thanks for any suggestions.

I'm using 14 Advanced, and looking at the Script Workplace. The left pane has my scripts. Some are in folders, some not. How does one move an existing script into an existing folder? I tried dragging but that won't work. Must be a different way? Or perhaps they are moved someplace else in FileMaker Pro?

I am trying to make a script to set a file path specific to each computer on which the script will run. All my attempts to use "Get SystemIPAddress" or "Get DesktopPath" to use in the variables are fraught with the problem that the results are not consistent with the computer they are on. I am running FM server with several clients and for example with "Get SystemIPAddress" I can get "10.0.1.55" as result on the computer with the IP of "10.0.1.4" if the file is already open on the computer running on "10.0.1.55". The same problem occurs with "Get DesktopPath". How can I get a result that is really specific to the computer I want the script to work on?

Once a year I must manually delete the number 6 from a field from anywhere between 300-600 records. I do this because I was informed that there is no way to automate the task since we also have other data in there, some of the data will contain a 6 (i.e. 16). The 6 can be by itself (no spaces), at the beginning of the string, the middle or the end. There are always spaces between the different numbers. I usually do this task on New Year's day and I would LOVE to spend my time enjoying the first day of the year in a different way, but I have not been able to come up with a solution - after trawling google and many forums, I'm thinking wasting my time and should just s…

The client has wanted to move from FM13 to FM14 for a while. What was stopping us was a strange data entry problem where the Retail Price field had a script trigger attached. This set another field to the VAT (sales tax) included price. There were a number of other price fields, each with a script trigger to adjust the other prices. All but the one on the Retail Price field worked. The script activated but it would get set back to the same value. Anyway, he bit the bullet and moved to 14. I had to find the problem and, in exasperation was about to redo the whole bunch of scripts on those script triggers. Then I noticed that the problem field was calling the wrong scr…

I have a script that runs on open. It insists on selecting a non-modifiable field even when I end the script with a go to object command. How do you get a file to open in a neutral state - ie with no active field?

I was lucky to have gotten an example file, which was based on designing a Subscription system. I think eos was behind it because of the file name. However, the subscription system was based on just three types 1 month, Six Months and 12 Months... I have tried to modify the scripts so that I can have more types like: 1,2,3,4,5,6... Months ( Basically all the months), I end up messing the whole system up. Please what values can I actually modify with respect to the required month I want? Here is a copy of the file.. LDprototype_subscription_eosMOD.fmp12

I have a solution that has some records that have somehow (via imports of the years, bad data entry by users, hanging a horseshoe the wrong way, etc) gotten NUL characters in some text fields. This is playing havoc on some scripted processes I use to concatenate data across multiple fields into the clipboard for quick transfer to other apps. The NUL is stopping the process somehow. So, I'd like to clean this character from the fields when it's found. But a general Substitute ( text ; searchString ; replaceString ) doesn't work since I can't specify the nul. "Char (0)" returns an "empty string" instead of the character according to FM Help and in application, this see…

Ok so should this be at start of every script unless we specifically have a special script where we want them to cancel if they wish? It seems backwards and it should always be off unless we say to put it on. and be consistent with error capture. Both off by default or on by default or ability to set the default in file options would be best. So does everyone use abort off in all their scripts?

Hi: Is it possible to require a password to execute a script = Password not Known = Halt script? Thanks Carlos

I have an inventory of prints, each print can be sold framed or unframed, as an example, if I have 100 prints, inventory will show an Amount In Stock of 100 for the framed option and Amount In Stock of 100 for the unframed option, even though physically I only have 100 prints. I only want one part number not two, when a print is sold, the print part number and the frame part number. If I create an invoice line, the Commit From Inventory script needs to decrement the Amount In Stock by one for both items, the framed and the unframed options, of a given size, even though only one of the items has been sold. The print part number would be PRO0029 and the two…

Hi I'm new so sorry if this is the wrong place to post this. Essentially I'm after a script that runs on startup that automatically centers the window instead of putting it in the top left of the screen. I already have a script that automatically resizes the window but I'd like it to display centrally. Thanks in advance.

I am trying to do some web scraping from the Yahoo! Finance site, the content I get back says the document has moved "The document has moved <A HREF="http://finance.yahoo.com/q?p..." etc with Insert from URL. If I use the same URL in Open URL, that I put in the Insert from URL function, the site is opened perfectly. Do some sites not work with Insert From URL? When I was testing the script it seemed like I was able to grab the source at one time, is the Yahoo URL dynamic? Thanks

LS, I would like to know if there is a white paper / best practises document of perform script on server ? Specifically, I would like some tips on how to do debugging of scripts that perform on server. I have some scripts that run fine on client, no errors. No result on server. TIA

Hello, How can one find the LastLogon timestamp of a user logging on a Filemaker file? is there a specific script for this?

Hi Suddenly when i click on the all units button in the scene details layout it generates the report, but on the last page of the report it will not add up the day totals. it is showing up on all the pages before but for some reason on the last page will display a 0, but as soon as you add in new records and therefore there is a new last page, the totals then display and the new last page shows a 0. I am not sure why it is suddenly doing this. Any help would be greatly appreciated. thanks Sarah Peach Crowd Breakdown.fmp12

Greetings, Your expert advice and solution would be greatly appreciated. Based on the Invoice Starter Solution, is it possible to have a script that will automatically add all products from a specific category into an invoice?Of course not everything in one line item but each product in its own line item? The trigger will be set by checking a check box. The process should also not duplicate the item if it already exists. Many thanks for your support. Kunal

Greets, all, and I hope you're in for some eats and treats later in the week. Please refer to the attached. What I'm doing is creating ten child records with the creation of each parent; each child is populated with a different value (in quotations) destined for the Inclusion__lxt field. As is, it works, but it's clunky; in my never-ending quest to become more competent with FileMaker, I'm sure there's an elegant way to loop this but I don't know how. (I'm sure it involves an Increment-type step to pick the appropriate value with each iteration, but I be flummoxed.) As always, your help is appreciated. Thanks!

I have 2 Webservers running IIS I have 2 FileMaker Server Advanced I want the ability to have high availability where if one server completely dies, the other one takes over. My big concern now is on the database replication. I want to have identical and always up to date by the minutes database on both FileMaker Server. Apparently there is no replication process per se with filemaker and after having spoken to tech support, they suggested that I create a script to commit a record on every Insert / or UPDATE to both databases. How do I go about doing that exactly? He said to link the script to every table. I am new to FileMaker. If there's a better way to…

Hi Guys, I've got a script which I need to replace multiple items. I can't use the substitute command as I need to be precise in what I am replacing, so I have a let function which determines the position and length of items and want to use the replace function. This all seems to work well, however I have come at a cross road where I need to replace 3 items in my $variable, so I have placed 3 replace functions in my script. The problem is my output is also tripling, just want to output 1 set of data. Let([ I declare all my variables which obtain the start and length... ]; Case( // If its the first one in the loop keep the st…

Fm 12. I’m trying to create a script that finds a range of records over a 30 day period. However, it gives the error “find criteria not valid” Enter Browse Mode Set Variable [ $EndDate; Value:Get(CurrentDate) ] Set Variable [ $StartDate; Value:Get(CurrentDate)-30 ] Go to Layout [ “Last 30 records” (Primary) ] Perform Find [ Specified Find Requests: Find Records; Criteria: Primary::Date: “$EndDate&"..."&$StartDate” ] [ Restore ] Any suggestions?

Mac osx Maverick last update, Fmp adv_14.04. This it work if my database ar in the document folder: "FMP://~/" & "MyDatabase" & "?script=MyScript" I tested a different path ....."Desktop/MyFolder/".... and it doesn't work: "FMP://~/" & "Desktop/FolderName/MyDatabase" & "?script=MyScript" My question: Does is possible to open(url) a file located in ....."Desktop/MyFolder/".... ? Many thanks

FM 12 Adv Timing is a text field configured as a checkbox. Choices from a value list are morning, noon and evening. I can create separate reports for each choice by searching the value list, but I would like to create a single summary report that displays all the data. The break fields would be morning, noon and evening. I assume it's possible, but I can’t figure out how to do the find in a script.

FM 12 Adv. I have a print script with only one step (print). When I click a button to run the script, there is no indication that anyting is happening. How can I display a simple message like "printing" while the script is running?

I am really confused with trying to get Send Mail as SMTP working with a Google Apps email address (i.e. [email protected] as a gmail e-mail address). I have been doing a lot of research on Google and FileMaker forums and can't understand why I can't get it working (as so many others have gotten it work with settings I have tried). I was hopeful when I found Savvy Data's amazing "SMTP Send Mail Interrogation" tool, but the results it produced two times are copied below. Does Send Mail as SMTP have to be run on a hosted file? That doesn't seem to be my issue, but I'm not sure. Does anyone have Send Mail as SMTP working with a Google Apps email address? If so, can y…

I need to determine whether a variable exists as distinct from whether it is empty. From what i can tell, if i access a non-existent variable, it returns empty. If $$foo doesn't exist, IsEmpty($$foo) returns true. But If $$foo exists and is empty, then IsEmpty($$foo) also returns true. How can I distinguish an existing but empty $$foo from a non-existant $$foo? Thanks,

I am trying to come up with a way to keep multiple users from working with the same record. I have a main table of leases, and for each lease a user needs to create (or link an existing) record in an orders table. All of the data entry on the lease layout is done using global fields - user enters the order data in the globals, then a script trigger fires a script that either finds a matching order or creates a new one, then creates a link record in a join table. After a lease is processed, a flag is set in the lease record as "completed". Then a script takes the user to the next record that is not flagged as "completed". I'm aware of checking for error 301, to see if a re…

I am not really good with scripting. I want a situation where by contacts with status as inactive are always omitted on entering the contacts layout. My challenge is to script this using the omit record script step. Secondly, another approach I want to implement is to have a check box field called HIDE which when checked, immediately removes (or hides but not deleted) that contact from the list, assuming I am on the contacts list layout... I don't really know if I have explained my question well... Thanks

I have a script which opens a new (dialog) window for user to enter information. The script pauses while information is entered. I want to allow the user to cancel the script (i.e. leave User Abort on) but if they do, I want the record to revert and the window to close automatically. I tried: If [ Get (Script Result) = "Cancel"] Revert Record/Request [ ] Close Window [Current Window] Exit Script [ ] but that doesn't seem to work. Any thoughts?

Hi all I'm having a little trouble here trying to validate fields using the OnObjectValidate Script Trigger. All aspects of my validation script works well apart from my test if a field is empty. If a field has not been modified the OnObjectValidate does not trigger the script when tabbing out of the field. I have used on OnObjectExit Script Trigger to run a script that solely checks if the field is empty which solves the problem to an extent. The problem arises if the user never actually enters that field by using mouse rather than tab. I do not wish to use the native validation for mandatory field as I would like all my dialogs to use the same format. …

HI All, i am new to Filemaker, and i am not sure i post in the right Topic here. I have the Layout list view and i have one field name "checked". I have create a edited box with global field named. I need help that when i type "Check" in global field and run script then selected or ommitted record will fill data "Check" to all the record in field name "Checked". Thanks for any help very much

Good day all, I am trying to email a PDF file using "Send Email" script step but there are two issues: 1- What ever I put in "TO" field, it would be blank in my Outlook when I run the script. I used calculations, fields and even typing an email address with no success. 2- When I attached any file to the script step, either using variables or direct paths, it would not open the Outlook any more. When I remove the attachment, it will open Outlook but with the issue explained in no. 1 above. Regards.

I have a database of contacts that need to be emailed (based on find criteria) at different times of the week and *tried to create a script that would send the email through the server automatically. Unfortunately it leaves out random emails and I can't figure out why. The problem doesn't seem to be in the FIND portion. Any ideas? GO to Layout [Layout Name (Table)] If [DayofWeek (Get (CurrentDate))=2] Perform Find Sort Records Perform Script [Ticket Count Email] Else If I do this for every day of the week Monday thru Fri (I think I could use a SetVariable here to make this less cumbersome but I don't know how) The Find seems to work fine. Here is the ticket count s…

I am running a script with full access privileges the last line of which is intended to check a found set. When the script gets to that step it says I dont have the access privileges to correct a spelling error in a record. My research to date told me that a script running with full access would override the security setting in the privilege set. Is this an exception or is there more to it? Putting "exit script" on the end solved the issue, as at presently advised

Hi When i click on one liner report or all unit reports it will show all the records (i.e. Scenes and their details), but when I click on the select unit report it seems to be omitting displaying some of the records but seems to know it is there as it is calculating it in the final day total. For example. if you select Main unit as the unit then scroll to 2nd Sept you can see the scene total is 100 for sc 49, but you can see it is saying the day total is 119. it seems to not want to show the record for sc 97 on that day. The record is there when you search or records for 2nd Sept and it says main unit so the unit is correct, but for some reason will not display in the …

In the midst of trying to tune a solution for better WAN performance, I started to get consistent FMPA v14.0.1 and FMPAv14.0.2 crashes with a particular script. The type of crash that kills the whole Filemaker app (on Mac OS X 10.10.5). This was not a problem previously, but seems is now consistent for this one action. The actions are related to modifying a value within a pop-up, and then running some triggered scripts upon dismissing it. I laboriously traced through a bunch of scripts by gradually moving around an Exit Script step and found that the offending command is, believe it or not, a Go To Layout command. If I leave it in (even if I replace it with a new line f…

Hi everyone, I've run into a problem that I'm having difficulty solving and am hoping that someone here can help. I'm working on a database that contains information about collared and released cheetahs: info such as location points (aka 'Fixes'), kills made by the animal, captures/releases of that animal, supplemental feedings, etc. One of the tables is titled 'Tracking Sessions' and receives a new record anytime that someone goes out to track (find) that animal in the field. I have a layout for Tracking Sessions that contains a portal to a table titled 'Tracking Notes' which contains all of the time-specific details that occur during any given tracking session. Each …

I have been trying to set up a means of locking down a record so that it can't be modified again.. For example, I want a record in the contacts table to become unmodifiable (locked down) by the user once the person must have entered his date of birth. Please how can I achieve this?

I have a Windows Server 2012 R2 Standard (64bit, 48gb ram) running FileMaker Server 13.0.9.905 and we have a problem where PSOS 'clients' are not getting disconnected after the script runs. They eventually fill up the activity 'client' window and over a few days the server eventually stopped accepting new connections since we hit the 'maximum simultaneous script sessions' limit. I have been watching this over a few months and the problem seems to go away after a reboot ... it seems to work fine for a few days disconnecting the session after the script runs, but then we go back to the same issue where it seems to never disconnect their session. we have a handful of psos…

FM 12 Adv. When I run the following script, it produces the error message “This script cannot be found or has been deleted” when it reaches the Go to Layout step. After I click ok, the script continues, finding and sorting the correct set of records. Enter Browse Mode Set Variable [ $$Issue; Value:VisitNotes::gIssue ] Go to Layout [ “Issue Report” (VisitNotes) ] Enter Find Mode [ ] Set Field [ VisitNotes::Issue; $$Issue ] Perform Find [ ] Sort Records [ Keep records in sorted order; Specified Sort Order: VisitNotes::VisitDate; descending ] [ Restore; No dialog ] Go to Record/Request/Page [ First ] I can’t figure out why the message appears.

Is it possible to execute a script on field entry or exit?

Hi, I'm looking for help with creating a script to transfer amended records into an audit log. For context I currently have a separate table that any amended fields move over to, how ever this works for one field at a time, but I'm running into problems when bulk importing a bunch of new records. When I import new records I get them to match up on one common field, the rest I want to record in the audit log but only if theres been a change. So far my script looks like this: This is just for one field and there are about ten I wish to audit log if theres been a change, naturally I can just repeat this part of the script and adjust accordingly. My problem is getting …

I am developing account recovery collection software and have just a few questions, here is the "work flow scenario" - Their are 4 users using web direct that have their own list of records to work. -(SEE LIST OF USERS JPG) 1) - Once a record is worked - the user needs to set a follow-up date 3,5,7 days etc - and when that date comes about the records listed with that date appear first when the user logs in. (Ex. work 10 records today and set followup date for 10/30 - then on 10/30 those records appear first out of the users overall work que.(SEE main Screen JPG)

I have a fairly decent size FMdb; everything seems to be working as I want it, as far as calculating and presenting the information I want. However, it's really slow on generating Summary Reports when I'm connected to it on a WAN, or on a FMGo. The reports has a lot of calculation fields; Some values are ExcuteSQL for some Dynamic value changes, and some are TO related calculations. I wanted to try the Perform Script on Server, but I can not wrap my head on how to get started. The reports I'm running, is basically doing a Find and Sort. I don't understand how the Get(Result)?? to get the found and sorted information to the Layout I want to display. Any help/resource wo…

Hey Guys, Do any of you know if I can use the open url command (or any other FileMaker command) to open a webpage on its own as a pop up and not as a tab. Ideally I need to inject some javascript (which I have) wrapped around the web address. I've tried to inject javascript with the open URL script but I've had no luck. I have also tried to created a button in the web viewer and when the user clicks on that, I'm assuming it opens another tab in the web viewer, as thats where the scope of the button was. Of course I can't debug this as FileMaker WebViewer doesn't have any built in debug tools for javascript (Windows - I.E) I've got the javascript method figured out as I…

Hello, I'll use a script to set a label number for one record. The script is now counting up but i won't count is down. So it starts for example with 10 and ends with 1 This is the script i'll use: Loop Set Variable ( $i ; $i + 1 ] // that's your loop counter Set Variable ( $$copy ; "Copy #" & $i ) // the global variable for your layout Print [ No dialog ] // set print dialog to print 1 copy only Exit Loop if [ $i = $numOfCopies ] End Loop Set Variable ( $$copy ; "" ) // clean-up; you only need the $$ while printing

I'm looking to create a script that when run sends a message to every user logged on that says basically "Congratulations" or in the future plays a video. Is this possible? Thanks Matt

Hi, I can't get the script below to return anything other than ? once I've joined the tables. Can anyone see why? TIA ExecuteSQL ( " SELECT b.ClearLearningRating, count(*) FROM LessonObservations a INNER JOIN Observations b on a.[pk] = b.[fk_TeacherEvaluations] WHERE a.obsdate >=? AND a.obsdate <= ? AND a.YearGroup = ? GROUP BY b.ClearLearningRating " ; "|"; "¶" ; $Repstartdate; $Rependdate; $RepYearGrp )

It has been awhile for me and I probably need to upgrade to 14 soon. For now, I am running Filemaker 11 pro on a mac using ElCapitan. The issue is I have a script that creates an excel file and mails it to someone. This use to work fine until recently. I don't know if it has something to do with El Capitan or not. If I run the script without the no dialog option, it creates the file on my computer, brings up the email with the file attached, ready for me to click send. If I select no dialog, it creates the file, and sends the email missing the attachment. The only recent difference is El Capitan. Does anyone know if this is the problem? Very Strange. Thanks, Dave

Hello FM Pros Would appreciate some tips for the following script problem: I have a situation here where my scripts in FM 13 Pro Adv takes more than 5 hrs to complete a calculation. OS: This is Win 7 Pro. with 16 GB RAM (i5 Processor.) I have Field "A" which is a 7 digit code numbers FIELD, which most often are repeating numbers, from 200 different types. (And I have upto 80 million records, in this field.) Code examples: 1234567, 2345678, 5678012,... Fields "B" to "Y" (are global Fields) provides a reference number for each type of the 7 digit codes from Field "A". For example the code 1234567, as above, the reference is, eg. HH/2015/Jul/132, Code 2345678 the …

I have a file called Call Log that tracks all incoming calls. There are certain clients that have earned a flag. I want to be able to notify the data inputer that the call they are entering is from a flagged previous caller. I tried by searching for dups upon exit of the call name entry using call name&flag. I am sure I am missing something. Any help would be appreciated.

I have a script that sets a variable, `$_record_number`, to `Get ( RecordNumber )` based on a specific criterion. Once it's been set, I want to bring that record to the top in list view. (It's possible that the criterion is never fulfilled and that `$_record_number` is empty.) The portion of the script that does this looks like the following: Go to Record/Request/Page [ Last ] Refresh Window [] Go to Record/Request/Page [ No dialog ; Max ( $_record_number ; 1 ) ] When the `Refresh Window` step isn't present, the script doesn't work correctly. Instead of bringing the record to the top of the list view, it brings it to the bottom. Unfortunately, the `Refresh Window` step…

At our office we were very glad of this new "Insert from URL" scriptstep, because we could replace: Webviewer->Pause->Parse result from getlayoutobject... with just Parse "Insert from URL". BUT Now it seems like in some cases, this is VERY much slower for some reason, that we can´t figure out. We have a mixed OS environment, some run mac and some run Win 7 (+ virtual XP) I am on a win7. Here is the story. I first encountered that I hade like more than 10 sec pause (not responding) when calling this script step. I also got a dialog saying something like waiting for http request. This went on for a day. The next day, I had the sa…

Hi there I have a data table consisting of values which are summarised into some very complex reports. Under normal circumstances, running these reports is time consuming and therefore a poor user experience. As it happens, 80% of the data on a report is historical and will *mostly* not need evaluating. Therefore, I've developed a script which runs overnight to create simple values stored in number fields on a related table. I report from this instead. This means the report is 80% quicker on loading. All well and good....but, there is still a chance that data could change in the period between the scripts being run at night. If the data changes, the related tabl…

I ran into a snag or bug with Date fields: In the style set for them (Drop-down Calendar), I have the following: Normal (light blue fill) Hover (white fill) Pressed (white fill) In Focus (white fill) The problem is, when you click once in the field, the fill turns light blue but when you click again, then it turns white (as it should with the first click). Unless there's something wrong with the set-up (or there's a bug), the only workaround I can think of is to set an OnObjectEnter script trigger where, when you click once inside the field, it fires the Set Selection script command using a Start Position of zero. That solution works, but there's a hiccup: I have a …

Background info: I'm working on a database that contains inventory items, with the help of a couple forums on this site I was able to setup an iOS button that triggers a script which scan a barcode and perform a find to display the particular items information and status. Insert from Device is used and it has an option to cancel the barcode scan, when cancel is pressed it will prompt the user if they want to continue the script or abort. My Database is setup as follows Tables Status Inventory Vendor Global Relationships: Inventory::VIN -> Status::VINID (VIN is the serial number which contains both text and numbers) Script: is attached Question Is there away …

Hello All, I want to save and print my MAterials that are expiring for the next month; Below is the script but it doesn't work. Can you please help me improve and correct it. Enter Find Mode[] Set Field[Materials::Expiry Date,Month(Get(CurrentDate))+1 Perform Find[] Set Variable[$found;Value:Get(FoundCount)] If[$found>0] Set Variable[$Counter;Value:1] Loop Set Variable[$names & GetNthRecord(Materials::Materials Name;$counter) & "¶" Exit Loop If [$counter=$found] Set Variable[$counter;Value:$counter + 1] Show Custom Dialog [Expiring Materials for the next month" Attention!! "ATTENTION!!!! NEXT MONTH EXPIRING Materials\"; \ & $names" Go to…

I have filter on my home page that show all staff within a particular dept. when the Head of Dept. logs in. This works fine when a staff member belongs to one dept only. I've now got the situation where a member of staff can belong to 1 or more depts. and I would need both HoD to see the staff member when they log in on the home page. This is currently working through the use of a calculation (in the staff table) that looks at the fk_DeptCode and returns the dept code and "SLT" in a list or just SLT depending on it's population. Going forward, due to the staff member being in two depts, the structure has had to change slightly to account for the many to many relation…

Apologies if this is in the wrong section. I've got an db for lesson observations. it's used via iPads. Teachers observe lessons and fill out some information based on a form. The issue I have is that when two teachers observe the same lesson and create observations, it appears that only 1 of them is actually been saved to the table(s). is there a setting that needs to be changed to allow two people to write to a table at the same time as we really don't want to be losing an observation or more each time they are carried out as we can have numerous members of staff observing lessons at the same time.

I have, what I believe to be, a relatively straight forward action I need to solve but can't seem to get my head wrapped around the solution. As an example I have two [2] databases, one call Master the second called Support. I have four unique fields in the Master table named Year, Make, Model, Style as well as a calculated field called YMMS which is constructed as . . Year_Make_Model_Style . . [Ex: 1932_Pierce Arrow_Model 38-C_Coupe Runabout]. I put the delimiters in place so I could hopefully parse them when necessary. My Support table also has these same fields including the calculated YMMS field. What I want to do is execute a script in the Master database that …

Greets, all: Forgive me if this topic's been covered--maybe my search criteria missed finding the answer here and on the web. What I want to do is while in List view, sequentially control the sorting of multiple columns with the ability to independently control the sort order as well. For example, say you have the fields, City, State, and Country, and the user wants to sort by Country (descending) > State (descending) > City (ascending). The user would hold down the Shift key then select the Country field, then click it again change the sort order to descending; hold down the Shift key then click the State field label twice (once to select the column, the second t…

Hi all, Apologies if this in the wrong place, but it seems like the best fit. Just wondering if anyone can help me out with a script I'm struggling with. The background: I have a button I'm using to launch a new window with another layout, then create a new, related record. This action will only happen if the user has completed a specific field in the original layout (__pkCollectionRef), step one of the script. With the new window open, the user will then make a selection from a checkbox set and close the window, which will put their selections into a field in the original layout. This part's all fine. What I want then, however, is for the button to be made inactive …

I importing a huge list as text files from FileBuddy which gives me file names, file location and file size fieldsImporting the text list in the Filemaker database the "SIZE" field is populated with text so I am unable to sort the sizes as numbers. the SIZE field looks as follows: EXAMSPLEs666,73 MB1,36 GB432 KBHow to I write a script so the "SIZE" text field can be converted in an integer?Example of possible results:if the text field is 921,5 MB the resulting number should be 921500000 orif the text field is 2,16 GB the resulting number should be 2160000000 fromorif the text field is 89 KB the resulting number should be 89000The syntax in the fields is always the same…

Hi All, How can i resolve this issue - "This file is locked or in use. Thanks, Deepak

Hi - I'm trying to summite a date of birth and save the resulting percentile calculation in the database: httppost://www.infantchart.com?datefield-1014-inputEl=2/6/2014 but I get an error instead of the percentile, I appreciate any help Thanks Percentile Calculation.fmp12

Hi, I’m trying to do an Insert from URL - to a field called URL Data Field - in a script using FMP 12 Advanced on a 2010 MacBook Pro: Insert from URL [Select;Test DB:URL Data Field ];”http://www.google.com/“] I am connected to the internet using WiFi and if I use Firefox, I can connect to Google almost instantly. When I run this script, I get a “Connection Failed” message. When I set error capture just before the Insert URL, FMP returns a LastError: 1631. When I research this error, I do not get very far. It looks like a problem with the target field: the field I am trying to insert INTO. The data base is 100% local: no server or remote fields or code, no fields in …

hi there, New to FileMaker Pro, just converted from Micro$oft Access. My problem is with field validation, I basically need a field to stop a user entering an incorrect postcode uk format e.g. LN94 4FM. I guess i must have to use a calculation or script but i need some help plz! MnR

I export data to a CSV file via a script in FM Pro 11. This must then be imported into a OsCommerce shop online. In my daily work I always work in "Browse Mode"> "Table View" and I therefore assume that the formating in the "Inspector" only affect the display on the screen and is not reflected in the exported file? It works, but the CSV file has two wrong formating: Price is written "149,50", but should be "149.50" Dates written as "01/09/2015", but must be "2015-09-01" My system (Mac OS X Yosemite) are in Danish and therefore the following formats: Currency: x.xxx,xx Date: dd/mm/yyyy My script is called "Butik" in the FMP and consists of the following steps: Go…

Hi there I've been banging my head all day, several days in fact, to create a sub summary report which can reuse records, have a part appear only once and allow me to assert more behaviour over the parts themselves. To complicate the matter it's in a crosstab format as well. I've seen on other posts that what developers do occasionally when preparing reports is to create a temp table of sorts to either store just what records are needed, or to store them in the way they're needed as well. The solution I have at the moment uses lots of summing up and calculations and is intolerably slow to load locally (10 seconds at worst) although it does give me what I need. I obvi…

How do I concatenate field reference in calculations? Data Components::Temp Field: & Get(ScriptParameter) & : selection = "some string"

Hi guys, Wondering if someone can point me in the right direction. I am working on a POS system (only small) and at the moment all is progressing nicely. I have a touchscreen keypad that I have implemented not the in built one and am wondering how I would tell filemaker or more succinctly the cash drawer to open say if they pressed a button called open drawer (for arguments sake). I'm assuming that each cash drawer might be different in how this works buts let say it requires the F9 Key to be pressed to open it. How would one simulate this through the open drawer button? Thanks in advance.

Hi fmforums! I'm looking to enter numbers like a calculator does this time round... The idea: Script to enter number from onscreen button in this case [1] firstly, get the quantity variable as text - eg [2] items then add the character 1 to the variable - eg [21] then convert the text back to a number [convert to integer] and drop it back into the quantity box - eg [21] items I found a custom function that works from brian dunning's website - but it *is* a custom function. AddTextRight If there is a way to script it without calling the custom function - it would help me greatly. here's an example of the script I'm presently using: …

I was wondering if there was a way to pass a repeating variable as a script result, or do I have to separate it out, and then remake the repeating field in the secondary script. Thank you, Fed

I have a products database containing a "link" (text field) to a specific product on our website. At the end of a customer service phone call, I would like to be able to click a button and have the contents of an email message from three other (text) fields and the "link" copied to the clipboard. This information has to be pasted into another application, which sends the message, and records the notes of the customer service call. I cannot send the message from FileMaker, it has to be copied and pasted ... The problem lies in making the "link" field into a working URL. Currently the product link is saved as text in a field. The email format is divided into three text fie…

Hello there, I am building the solution for my tech support company, we work with eletronics, games, pc's repairs etc, on my main layout we manage service orders and inventory, and I have the idea of keeping a way to monitor our productivity, for that I would need a way to read and start events from specific times, as I want few things like that: When the employe join early on the day, he check in the system and the system knows if he is late, or in time etc and I can have a custom notification for him based on that time; When he opens up a service order, he will be working on that until he closes it to end as done or waiting for parts etc, I want the system to monitor …

Quick assistance. I have multiple jobs that make up one project. In a layout I am linking the jobs table (letter, envelope, etc) to the project table (Direct Mail Project) by using a portal and many hidden Tab Objects. In the portal I have the following 2 fields: JobType (letter, envelope, etc.) and the JobID. In the JobType, I have a pop up menu and script trigger to select the appropriate Tab (letter, envelope) to prompt new fields for data entry. My script trigger is: Go to Object [ Object Name: If ( isEmpty (Job::JobType) ; "Blank" ; Upper ( Job::JobType))] Problem is twofold. 1. I can only get the first portal row to perform the correct lookup between th…

I am sitting on a Contact record, when I press a button I execute a Go To Layout, Image Gallery. The Image Gallery layout, show a list of images, when I select one of the images it is placed in a container field, Image_Gallery::Image_Data, on the same Image Gallery layout. I would like to run another script from the Image Gallery layout, that would copy the Image_Data contents on the Image_Gallery layout to a container field called Contact::Photo_Image, which is on the original calling Contact record. I was going to use a Set Field but don't know how to tell the Set Field which Contact record to copy to. There is no relationship between the Contact record and the Image…

Is there a way to use an If statement to determine what button was pressed and execute scripts? I am trying to make a few different buttons and I would like them to use 1 script file and based on the buttons ObjectName it would run different results...

I have an intermediate level of experience with Filemaker pro and am working on Filemaker Pro 13. I am trying to fix an automated script for removing a series of records based on a common identifier field. During this process I pass the identifier field of the existing record to a global variable, but can not pass it back after initiating the find. Below is this script: <<-- Beginning of Script -->> Show Custom Dialog ["Message"; "Do you really want to delete this series?"] If [Get(LastMessageChoice) = 1] Exit Script [] End If Go to Layout [""Schedule Visit" (Scheduling)] Set Field ["Scheduling::record_place_holder; Scheduling::Appoint_Set_Record]…

I've been inserting small bits of data from Filemaker Pro into other systems we've written for some time using "OpenURL". However, this approach works, but leaves you with a browser window open, and isn't able to see what the other system returns. So moving to the "Insert from URL" script step instead. This seems to work fine when the "Insert from URL" is the only step in a script, but it doesn't complete satisfactorily when "Insert from URL" is one of multiple script steps. What could be happening? My first thought was that perhaps the script step isn't given enough time to complete, but now I'm not sure that's the answer.