Script Workspace and Script Triggers

I have a template database that when you click on a summary record it goes to the main record view. However, if I create a new record it will switch layouts but not have set cursor in the first field, so I have to do that manually before typing which is annoying. I'm guessing I need a layout/window triggered script(?) that will work with command-n or when it switches from summary layout and what is the insert cursor in the field script step?

when i am running above script i am able to find for how many patients i wrote particular medication which is a global field giving it as script parameter , but i want to search with date range as u can see in the image , i am trying to give it as script parameter 2 into pdate as u can see in image , but i m not able to do it can some help me please hope u understand

Hello, I m trying to find 5 most occurred word in a text field. for exemple text : "Hello John how are you ? Jonh may I ask you to go out to night? I like going out at night, you remember." so the result will be : You (x3), John (x2), Out (x2), Night (2x) Hello (1) could some one help me with that Thank you

I just upgraded to FMP16 from FMP13. My applescripts no longer work. I get an error of -10004, for which I cannot find an explanation. Any idea what I must change to make Applescripts work in FMP16?

I am trying to create a button that deploys a script that opens a corresponding server folder based on the value in a particular field of the current record card. Here is what I have so far, but I can't figure out why it is not working: Set Variable [ $jobno ; Value: Project File Server Locations::_4_digit_Job_No. ] If [ $jobno ≤ "100" ] Perform AppleScript [ "tell application "Finder" activate make new Finder window set target of Finder window 1 to folder "Projects 0001 - 0100" of disk "TRG Projects" end tell" ] Else If [ "100" < $jobno ≤ "200" ] Perform AppleScript [ "tell application "Finder" activate make new Finder windo…

Hi, I've got a form that using check boxes to update a summary text box with information based on which check boxes have been checked. However, if one is checked in error and then unchecked I would like to remove the text from the summary text field. I've tried to use the Substitute the text with just a blank and all it seems to do is keep the text but put it in lower case. I had bullet points but then removed these to see if that would help but didn't I'm not sure where to go from here. Ideally I would like to keep the bullets but if they need to go that fine. Any help would be greatly appreciated. TIA

Hello, I have a table with changing fields created by sql. So i could have 2 or 50 different fields on the same table. Il would like to export all of this so 2 when there is only 2 , etc to Excel without manging export function from my script. I would like to export all not depending numbers of fields. Is it possible ? (sorry for my english) Thanks Tom

Having a mental block. I have a list with several sub summary fields. On the layout I display a count of the number of records included in each sub summary and this works as expected. Five records in sub summary X, count displays 5. Eleven records in sub summary Y, count displays 11. etc. How can I trap the sub summary count value in a script variable? Everything I can find or think of yields the total record count or found count. I need to trap the layout specific count values for the current sort sub summary sections. Is this even possible?

I have a script that save documents (Quotes, Invoices, Purchase Orders) to the user's documents folder. My script returns an error if the folders don't exist in the file save document path. Is there a way to auto-create missing folders? I need a solution for both Mac and Windows. Thanks. For example: ~user/documents/Company Docs/Quotes ~user/documents/Company Docs/Invoices ~user/documents/Company Docs/Purchase Orders

Hi all, I have a requirement to reduce the size of a database by removing records from the work system and importing them into an offline archive system but don't know how to automate the scripting between the files. Database 1 is a work system where, among other things, service records are created during a service and any problems found during the service are annotated and photographed on mobile devices. At the end of the service a summary report of all actions carried out and any problems that require the customers attention is produced, signed by the customer and emailed to them. With about 450-600 photographs taken each month the file size will ballon very q…

Hi all My scheduled server scripts call up my onwindowopen startup script, which is great. I specify that the startup script exits if it is being run from the server. The actual scheduled script then runs fine. However I don't want any of my scheduled scripts to run if the plugins are not enabled on the server. I thought I could achieve this by utilising the 'halt' script step on the startup script in the event that the plugins were found not to be enabled. While it does halt the startup script, it does not also halt the script that called it up (the scheduled script). I'm guessing though that this is because the scheduled script has not actually 'call…

I am updating an old database that I haven't used in awhile. I used to use EventScript plugin to launch a script from a calculation, but have lost it and it doesn't seem to be available anymore. Is there a built in way to accomplish this now? My calculation is just an if statement that checks if there is an entry in a related table, and if not, launches a script. Thanks

Hello I am using FMP13 and I have a MEDIASIZE field where all the data is something like this: 64.3 MB or 3.96 GB How to write a script which will convert to a regular number this information? As it si I can't sort the various records while converting them as an even number it will be possible Thanks a lot

In my DB I have a text file which tells me the size of audio and video clips as such 927 KB or 1020 KB and 27.5 MB or 15.26 MB and 2.01 GB or 11,3 GB I used the following suggestion from this forum: Mediasize::MediaSize * If ( PatternCount ( Convert Mediasize::MediaSize ; "GB" ) ; 1024 ; 1 ) but while it works fine with GB it doesnt work with MB or KB Instead of doing a script a did a calculation as such Case ( PatternCount ( Convert Mediasize::MediaSize ; "GB" ) ; Convert Mediasize::MediaSize* 1024; PatternCount ( Convert Mediasize::MediaSize ; "KB" ) ; Left ( Convert Mediasize::MediaSize ; Length ( Convert Medi…

Hi gurus, I am sure I’m missing something simple, but for the life of me I can’t figure this out. I have a database with tickets. What I want is when a new ticket is created I want to see a popover (see attached) then I want the user to type in the top box and as they type I want to filter the list below (a portal) and once they client is shown they would select it and a ticker is created for the client. I sound a script and modified to fit my needs but can’t get it to work. Can someone stretch a helping hand? BTW the filtering is working but its not reflecting in the popover its reflecting on the layout.

I am at the moment evaluating Filemaker Pro for my company and have 2 tables. One is for customers and one is for devices. Devices are assigned to a customer and the tables have a relationship via the customer. I wish to be able to transfer the customer details from the customer table to the device table via a update button but am floundering on setting up the script for the update button

Peculiar problem noted in Filemaker Pro 11 with regard to the "Send Event" scripting function and Windows 10. I want to be able to launch multiple browsers from within Filemaker using "Send Event". Microsoft Edge and Internet Explorer launch just fine, but not Google Chrome. Chrome launches to a standard Google.com webpage and displays the "Aw, Snap!" message in the center of the screen with its associated icon. Any ideas as to how to get around this problem.

Greets, all: I don't want a particular script to run unless a record--any record--has been selected, first. I tried using Get (RecordNumber) as a flag but no luck there. I'm sure it's simple but for the simple-minded like myself, well... TIA for your help!

I have a database that assigns task to workers in my cabinet shop. The field "Worker" is populated from a drop-down value list. If you want to find all of the tasks assigned to a particular worker you select their name in the "Worker" field then click a (FIND WORKER) button that drives a FIND script. The FIND script reads as follows: 1 - Set Error Capture [On] 2 - Copy [Select Entire Contents] 3 - Enter Find Mode [ ] 4 - Paste [ Select ] 5 - Perform Find [ ] All of this works fine when run on a desktop computer but does not work at all when run in FilemakerGO on an iPad. Is there something I need to do different or is …

Hi all, I'm an FM novice who has a functioning database, and I'm trying to add layers of functionality to it. One feature I'm trying to design is a script to search through a Gmail outbox with certain keywords. In URLs, "%" translates to "%25". Filemaker appears to do this automatically - In Gmail syntax, you need to write "in%3Asent" to have the Gmail search bar contain "in:sent" which searches my outbox. Here's my current code for Go to URL: This "%" bit translates to "%25". I've tried "\%", I've tried creating a string, x, then having it open x, but no matter what I cannot get "%" to show up as-is, it always translates to "%25". Is there any way aroun…

Hi! Writing a script to try to find the current record I am browsing and getting a little stuck. This is what I have I think that I just need something after the semicolon in "Set Field By Name" Any ideas? Thanks!

Hi Can anyone advise on how i can script a button that would populate a Table view field with squential numbers. i.e.; i need to generate a batch of 1000 squential numbers starting at 010000000001 into field which could then be exported to third party program. Thank you for any hints on best practice here.

Good day FM Gurus, Sorry if I am posting in the wrong group. I am hoping someone can help me with a scrip (I think my issue is the script). I am trying to duplicate a solution I saw on you tube but for some reason I am not able to get it to work. Basically, all I want is to be able to add multiple attachments to a data base. Please see my file attached, and hope I can get some help. Ticket.fmp12

HELP!Can someone help me write a script that will automatically send pdf invoices to 54 of my tenants monthly? I am not very versed in writing scripts.

I'm trying to replace the field contents of a field (irrespective of table, but the field name is the same in all the tables) across a found record set using Set Field By Name and Replace Field Contents but it's not working. I also tried changing Current Contents to "Replace with Calculated Result" (using a zero) but that doesn't work, either. What am I missing? It seems like Replace Field Contents doesn't "see" the field. TIA for your help! Set Field By Name [ Get ( LayoutTableName ) & "::" & "zz_DeleteWarning__lxn" ; 0 ] Replace Field Contents [With dialog: Off ; Current contents ]

Help says: So does this flush only the table I'm on, all tables in the file, both files if separation, all files being served at the time? I see it used to force refresh if a portal won't refresh. I also see it used when in testing it isn't necessary. I read that it should not be used because it slows a system down. Slows it in what way - because the index must be created again for the table? I am thinking of using a process with a Preference single-record table but it will need to flush cache after every change. Do you think that would be bad on my file? Would other people in other tables get flashed also? Why would they flush cache after a Replace …

Hello everyone.. Guess I have been away for a while. Not fully back though because I am not really engaged with computer tech stuff at the moment. However, I really stumbled across a problem earlier today while going through my email logs. I observed that a server script I had set up has not been attaching the Pdf file report as supposed to. It only delivers the message while leaving out the file attachment. I did test the script when I added it but what I did not test was the result when run by the server. Allow user Abort [Off] Commit Records/Requests [No dialog] Set Variable [$FileName;Value:"Summary"&".pdf"] Set Variable [$PDFPath;Value:Get(…

HI folks, I've got an import new records script I'm working on. After I've created new records (based on Excel rows) are they always left in the found set? As far as I can tell that's the case, but don't want to rely on it! After the import I'd like to then set a couple of fields based on variables, and can't see another way to find the records that have just been imported to do that. Cheers, Mike

Hello, I m trying to multiplie a record by attributes for exemple from this : to get this : If someone could help me to do that thanks from this to this

I’m having a really strange issue with a goto related record script step after converting a file from *fp7 to *fmp12. There was no issue with this in FileMaker 11. The script step is linked to a button, to go to a related record (same record) based on the same table to a different layout that contains portals based on different tables. For some reason running the script when a particular record is selected crashes FileMaker 16, and I have to force close the program. I did think the layout may be corrupt in some way, so duplicated it, deleted the original an renamed the duplicate. I still have the issue. Strangely, it only appears to happen with one par…

This is an example of my path /Volumes/SHOWDOW_2017/SYnch Tests/00 - 11072017/Video 11072017/DSC9197.MOV How can I write a script to tell the finder to open the movie in QuicktimePro7? Thanks

Is there an equivalent script step for Update Link for *fmp12 files?

I'm using some script to direct users to different layouts when the access my database via WebDirect. At the moment all users are directed to one of two layouts using the following #t ( Case ( APP__Application::Type = "Long" ; "Application Detail WEB" ; "Application Detail Rapid WEB" ) ) What I actually need to happen is that when a "reviewer" logs in they are directed to "Application Detail Review WEB" for everyone else the above code is correct. Any help would be much appreciated.

Hello All, Below is my script for my webdirect layout ; I want to include a dialog saying "No record Found" if a user is searching and nothing is found. Freeze Window Set Error Capture [ On ] Allow User Abort [ Off ] Perform Quick Find [ Preferences::gSearchField ] If [ Get(LastError) ] Perform Find [ Restore ] Else Sort Records [ Restore ; No dialog ] Go to Record/Request/Page [ First ] End If Go to Field [ Preferences::gSearchField] Thank you. LoLa

I’m trying to create an interface that will find all entries in the month specified in the script parameter. If the user selects the Sep button, I want the script to query a date field for “2017-09-01…2017-09-30”. This works correctly when I do it manually, and a case statement correctly builds this string in the variable $_range. But when I try to script the query as follows: Enter Find Mode [Pause: Off] Set Field [Calendar::calDate; $_range] Perform Find [ ] it consistently throws a 500 error, even though I’ve set no validation restrictions. Set Field [Calendar::calDate; “\” & $_range & \””] does not resolve the problem. Can anyone troublesh…

LS, There must be a better way to go through the data I receive from a webpage. It returns a list of comma separated emailaddresses about 33k.Currently I am doing it like this.( See below). It takes about 4 minutes. I can move it to FMServer. On FMServer it takes 2:20 for 32114 records. So I'll stick to the server. I using FM15 at this client. Also multiple plugins are available to me, like MonkeyBread 7.3 Kind regards, ---- Freeze Window Delete All Records [ With dialog: Off ] New Record/Request Set Variable [ $i ; Value: 0 ] Insert from URL [ Select ; With dialog: On ; tester::g_text_field ; "url left out for privacy issues.php" ] S…

A change of aesthetics in a solution is forcing me to change from a portal to a pop-up menu and I don't know how to re-code the existing script; the portal works fine so I know the relationships are good, just that I don't know how to script a pop-up to pull the URL from a related record then use the OpenURL command. The related table has two fields, URL__txt (which holds the actual URL) and Value__txt (which has the name for the URL). In the portal at right, a button--made from the Value__txt field--when clicked, uses the OpenURL command to open the URL stored in URL__txt. So far, so good. The pop-up menu on the left, in the local table, has all the values of V…

Hi I have been asked to set up something that will send out email automaticly when the date in the "review date" field is 14 days prior to the current date, can someone help me with a script that would be able to perfom this task? I have also created and email field that will hold the email address. thank you Kassy

I have a folder in which files are downloaded on a regular basis every 5 minutes. I need to import these files automatically into filemaker table (existing) with a script that automatically runs every 5 minutes. Once the file in imported then the file needs to be moved to a "Archive" subfolder. Filenames will vary, but never duplicate. Files are text tab delimited. Here is the path of the files: /Users/unsername/documents/download/ I know that I can import multiple files with the menu. However again, this needs to run automatically every 5 minutes. Thank you for any help you can give. I am using Filemaker pro Advance 15

I am wanting to launch the Microsoft Edge browser using the Filemaker Pro 14 "send event" script element. Have tried: %windir%\SystemApps\Microsoft.MicrosoftEdge_8wekyb3d8bbwe\MicrosoftEdge.exe Nothing. Looking for some help.


I put a Triggered Script on a Container Field (in a portal row record) to run when it Validates (OnObjectValidate) and while it runs fine if I use the Insert File command to put content in the container if I just Drag and Drop the Triggered Script never runs. In other words am I correct in saying Drag and Droping content into a container field wont Trigger a script to run? 

Any suggestions for a work around?

Hi Guys, Just a quick question for a beginner, I have created multiple export scripts, and notice that when I create a master script with the numerous subscripts being called, sometimes the output isnt correct, whereas when I run each script one by one (rather than lots of subscripts within a master script) the final result is fine. Could there be anything wrong with using subscripts for this? Should I always have an Exit Script step at the end of each subscript? I hope that makes sense Thankyou

HI, Need some help / wisdom ... I, the solution provider never have a "Global" issues as being stated below ... I have a solution that some, not all of the solution global fields are not populating when the script writes to them ? A client had to move their DB to another server and upon upload, soon afterward, I was getting notification from the client that some of the solutions safety conditions were triggering messages where certain events won't happen ... upon further investigation, I've discovered that the "Users" global fields were not writing when the script would write to it ????? The user, after several "Log In's" attempts would get successful fiel…

Hi, I want to create a Dropdown List of numeric options to select a range of records. For example, the Dropdown list would contain: 5 10 20 50 100 ------- edit... Each option would select the next 5;10;20;50 or 100 records to the right. A Checkbox would be populated (with an X) in the selected number of contiguous records; Then, a Find Selected Checkboxes would return the selected records. The contiguous selection should be independent of whatever the current state of Found (Sorted/Unsorted) is. Any help will be gratefully acknowledged. Best, Daniel

Hi Folks, Can anyone spot what I've done wrong with this file path? The Events::gYellowFormFilepath contains "2017-2018" which is the name of a folder. Macintosh SSD and Mike (X) both had spaces - I've tried with and without. Neither have worked, but give the error file "could not be created on this disk..." "filemac:/MacintoshSSD/Users/mikekentdavies/Mike(X)/School/Concerts & Events/" & Events::gYellowFormFilepath & "/MusicDept_YellowForms_" & Substitute ( Get ( CurrentDate ) ; "/" ; "_" ) I'm pretty sure that all my read / write privileges are fine. There's lot's of free disk space, so I'm pretty sure I've bogged up with the file …

Greets, all: I'm trying to set up a part of a script where it constrains on a Primary Key to isolate a record, irrespective of its table, and I'm stuck on the syntax. The set-up: Variable: $_TableName = Get (LayoutTableName) The Primary Key: They all have the same naming convention in all the tables: _kplt_TableNameID" . The value inside every Primary Key is set by Get ( UUID ). Where I'm getting hung up is the Set Field syntax; the script (so far) goes like this: Enter Find Mode [Pause: Off] Set Field [ Evaluate ( $_TableName & "::" & "_kplt__" & $_Tablename & "ID" ) ; ????? ] Set Error Capture [ON] …

Hi all I have a global field that is populated by the end user. When they hit the enter button it executes a script, which refers to the value that has been entered in to that field. This utilises the Get(TriggerKeystroke) and OnObjectKeystroke trigger and function. When a keystroke is made on the field, the triggered script detects when the enter key has been pressed and runs another script. I have set the field to go to next object when enter has been pressed. The only downside of this method is that it tabs to the next object after the enter key is pressed. The only way to prevent this is to untick the 'go to next object using enter option. However when …

I want script to control Stock(Inventory) when i verify Cash sale. Help Me Please. this is my script and this is Retionship

When I sold my product I need to add product name then select serial number of product then add to portal table. However, if I want to sell a product in many items, such as 100 items, it is very slow to add one product's serial to table at a time. Is it possible If I fill quantity to sell and run a script to input amount of serial number, sort ascending, equal to the quantity to portal table ? script that I used for now

I would like to auto generate serial number to portal table equal quantity items that I fill. I wrote a script to create them but it is not work. I do not know I do something wrong in this script. Please suggestion for this situation

I have table Trainer Program Design_Templates. One of my layout, Add_Program Design I have 3 Pop up Menu fields that I would like it to show the data available related to each previous pop up menus then it should populate all the fields below.

I wrote an application to control product movement in my office but I cannot grouping duplicate list of product's name. For more information, My company's product need to use serial number to detect when it's received or sold out or comeback to repair. This is my script used to add data to table this is the result when I add to table ( I type in Excel for easy to see) but I need them to show like this So, anyone could you please suggest for this case

Howdy, howdy... I need a script--using either a button or popover'd button--that will delete a portal row; I can't use a "stock" button where it's set to Single Step and Delete Portal Row because the client wants to keep the look and feel to the UI and not use FileMaker Pro's default windoids/messages, so it has to be custom. To compound the problem, it's a tabbed layout where each tab (of 7) has its own portal to a separate child table. One problem is that because a user will click a button atop the portal row, it won't be selected so FileMaker Pro won't know the name of the child table beneath it...as far as I can tell, anyay. I did create a very lengthy …

When I try to create a perform find script step, FM hangs when I select a certain table in the Edit Find Request dialog. I can select other tables and the program does not hang. Only that one. I have to use Ctrl+Alt+delete to recover. The TO is a loner, it has no related tables. I ran recovery, but FM does not find any problems. Any idea what's causing this?

my scipt is take to portal row is dupplicate Helpme Please from use this layout my script button

I need some help in determining if I am missing something crucial here or if there is a limitation or bug in the function BE_ApplyXSLT from the BaseElements plugin. I am using version 3.3.4 (which is the latest) on Mac OS X 10.11.6 using FileMaker 15 Adv. and 16 Adv. I am unable to get any output from the transformation, nor any error. According to the documentation, the command shall return either 0 when successful or an error. Link In my testing it only returns blank, and gives no error even when no output file is generated. It should not return blank in cany case according to the docs. (I suspect there may be a documentation error and that it actually re…

Hi, I'm writing a find-replace script to change special characters to Unicode code and another script to change them back to special characters (see screenshot). It seems I should be able to assign the "Go to Field" once and run ~1000 Find/Replace(ments) in one go. I'm not going to switch to another Field during this process. Is the Script Workspace the right way to do this or would it make sense to have the Find/Replace units in another .fmp12 file? Best, Daniel

Hi- My OS uses the European date format: DDMMYY. Some of the .csv files I import contain dates in US format, which I would like to convert on import. I have the file options set to always use system formats, but the US origin files still import with MMDDYY dates. I've tried setting the date field itself to display in European format, but that doesn't convert the dates themselves, it just makes the field unable to display any date beyond the 12th of the month. Is there a script for converting date formats that I can include in my import script? Thanks for your help. Jon

Hello, I have included in my FileMaker Pro solution a native AppleScript module and when being executed I am getting the error message : Finder got an error: Handler can’t handle objects of this class. Unknown Error: -10010. When running this module as AppleScript in OSX, everything goes OK and there no error message being displayed. The error occurs only when being executed from FileMaker Pro. It is important to mention even with the error message the AppleScript still execute correctly. I've tried to find which line was causing the error by inserting "Display dialog" statement. No line in particular seems to be causing the problem. It hap…

In an existing solution for a client, I have a scripted modal loop that allows users to select from multiple criteria (value list checkboxes) and then generate bar charts based on the results. The script collects the find criteria as multiple find requests, performs the find, and then omits certain records based on an "omit" checkbox that may have been checked prior to the script being run. The client is requesting that the found set from the bar charts also be displayed in list view with the omitted records now included. I had thought using Extend Found Set would allow me to simply include records with the Omit checkbox, but because the previous script has run…

I'm trying to get a token from an authorization server using cURL in Insert From URL. When I make the following request in Terminal curl -i -X POST -d 'username=myaccountname&password=mypassword' https://authserver.com/login I get the token back in the response header. Since FileMaker doesn't support the --include (-i) option I haven't been able to figure out how to get the response header with the token. Anyone have any ideas on how to accomplish this? Thanks in advance! -Kent UPDATE: Okay, I figured out I can get a response header by using the option --dump-header and setting it to a variable. The only problem now is that the token …

Hello, In looking to make my database perfect, it has become obvious that I am going to learn Filemaker scripting. While I can Google and ask questions all day, I'd really like to learn how to do it myself (not so much the raw basic FM functions, but custom functions like 'case' etc.). As an example, with an old FM database, I had downloaded a script that would insert a decimal after I entered numbers in a field (for recording measurements). As an example, if the field entry was 'a' characters long, the decimal would be applied at position 'b'; if it were 'x' characters long, the decimal would be placed at position 'y'. While I used this downloaded script (along…

Hi can anyone help advise on a script step to export certain fields to an excel document.. I wish to export content from 20 fields from the current record into a single xls document presented in a single colum view. (not rows) e.g.: abc123 ASD223 etc many thanks

Hi guys, I have a Contacts table and an Activities table. A Contact can be a leader of many Activities. On the Activities Details layout, I want to be able to select a Contact from a dropdown and have a button that can then be used to take the user to the Details page for that contact. I've tried several things from researching, but can't seem to get it working. PLEASE can someone help me. It's driving me nuts. I'll also want to do show the Activities a person is leader of on the Contact Details layout, but I'm presuming that's a simple portal.

Hi Guys can anyone advise me where to start with my following problem. I have a "single record" with several image containers fields, each image also has an identifying code ref field e.g.: 0003889 when i search 0003889 in quick find how can i ask filemaker to find and highlight the field containing the 0003889 data field? The purpose is to show where on the page that code/image is placed on the layout many thanks for any advise you experts can offer.

Hi. I have a script that runs to add attendance to a fire department incident report. Before the script runs it checks the current time against the dismissed time of the call. If the current time is more than two hours after the dismissed time the script will not allow you to enter the attendance. My question is how would I add a second means of validation to not allow an attendance record to be added unless 15 minutes have elapsed from the start of the call while keeping the two hour time out component? Thanks Chris

I have a found set of invoice records using a search for line items matching "paper widgets". Each record has multiple line items but only one line with "paper widgets". "Paper widgets" may have varying quantities on each record. I want to get a summary count of "paper widgets" or the sum total $ across the found set. What script steps could do this? Thanks.

Hi, Charles Ross (Chuck) posted the following script in 2010 to split the contents of a text field into text chunks, using the last period (within a period count) as text chunk separator: Let( [ MaxString = Left( String; 100 ); // Get the first 100 characters of the original string. PeriodCount = PatternCount( MaxString; "." ); // Find out how many periods are in the substring. PeriodPos = Position( PeriodCount; "."; 1; PeriodCount ); // Get the position of the last period. Substring = Left( MaxString; PeriodPos ) ]; Substring ) I've only been able to get the first line to work with a given number of charac…

i have unchecked all , but when i click on scripts link on menu bar popup showing all script names how to hide them ????

in an window open script i have hid the menu bar now if i want menu bar again to be visible what to do

Hi Forum. I'm trying to do the standard center the window on a desktop when the DB first opens. The problem I am having is if I shrink the db window down to a small size, then close the db, when I reopen the window won't center unless I run the script twice, or change the script to have 2 Move/Resize script steps-the first to make the window the size I want, and the second to center. I feel like I'm probably doing something simply wrong. I attached the script that works. I also attached the file=Admin, no P/W. The file is set with OnFirstWindowOpen script trigger where the resize and move are all in one step. To replicate the behavior, open the db, m…

made all necessary things to run smoothly , but after running a script opening new window in card mode with show dialog step showing as master code above with an input field with a secret code but i want the code to be cleared please help me how to write a script to delete the master field aotumatically after showing show dialogue step please

I am trying to do a basic Insert from URL call with some CURL headers added and I keep getting authentication errors. This is the curl command sent by the provider for me to use. curl -X GET --header 'Accept: application/json' --header 'api_key: 1234567890abcdefg' 'https://mydomain.leaddocket.com/api/endpoint' This is the curl I am setting up -X GET \ --header 'Accept: application/json' \ --header 'api_key: 1234567890abcdefg' \ -trace $$curlTraceDump FM barks and says "Authentication Failed" but if I do this with the BaseElements plugin, it works just fine. What I found when looking at the Curl Trace was that FM is dropping some of the…

Hello, I have a few fire departments that use my database, each department connects using filemaker Go. In their database they have a button that runs a script that will collect some fields from an "Incident Report" and save them in a script parameter and then open a mutual aid database that is used by many towns. It opens the mutual aid database using the open URL script step and the username and password are hard coded into the script. The opening of that file triggers a script to run and create a new record in the mutual aid database and pulls in the field info it needs from the script parameter, then the script closes the mutual aid database. What I am…

My end goal is to have a button that, when clicked: 1. Opens a pdf form from my server 2. Fills in the form using data entered into FileMaker (I'm using FileMaker 10) I'm on step one and and trying to use the "Open File" script, however it's not working. Can the "Open File" script be used to open non-Filemaker files, such as PDFs?

Hi everybody, I m looking in filemaker 15/16 to launch on a mac a .jar file with parameters On windows it s show like that C:/Users/DrJonesX/Desktop/test/eCall.jar ADD*med1*1FD66D1*17-05-2017 and it s work great But on mac i don t how to convert it and launch it correctly Have i to use a plugin do that ( i prefer not ) or i need to use an other way like applescript? this is the file + parameters eCall.jar ADD*med*1FD66D1*17-05-2017 Thanks in advance for your time and your answer Jacob

I have a Value List "Quarter" with values: "Summer" "Fall" "Winter" "Spring" I planned to loop through these values and assign to a field using the various posts in the forum, but in testing the basic steps it's not working: Set Variable [$i; Value: 1] Set Variable [$quarters; Value: ValueListItems (Get (FileName); "Quarter") Set Variable [$count; ValueCount ($quarters)] New Record/Request Set Field [Program::ProgramQuarter; GetValue ($quarters; $i)] The field ProgramQuarter is not being set to any value....

Hello I need to run a daily script to unmount and mount a volume using applescript. The script runs fine in AppleScript but does nothing (as far is I can tell) in a scheduled script in FM server. Is this a problem of location of the files (on the server) that causes the AppleScript to not function? Testing the same on a local copy of the file works just fine. The script I'm trying to run inside FM: tell application "Finder" try eject disk "directie" end try end tell set my_volumes to "directie" set the_volumes to list disks if my_volumes is not in the_volumes then try mount volume "smb://192.168.0.169/directie" as user name "directie" w…

FileMaker 16 introduced a collection of built-in functions for manipulating data serialized as JSON. This makes it easier for FileMaker applications to interact with many web services. This will also make JSON the de facto standard format for scripts within FileMaker to pass parameters and results to each other, improving code sharing within the FileMaker community. JSON does not have a broad palette of scalar data types to choose from: text, number, boolean, and null. Even with those, FileMaker's JSONGetElement function always returns a text result, even when the serialized JSON value is a number or boolean. So I made a handful of custom functions and scripts for se…

I just loaded FileMaker Pro 16 and it doesn't look like running a script from a URL works anymore. I currently have several email notifications that send out which include a link if a person wants more information about the notification. It has been working fine but in 16 I get "Your access privileges do not allow you to perform this action." My privilege set is [Full Access] so not sure what it is talking about. Is there a setting somewhere in 16? FWIW, I'm still on FMS 15. Not upgrading until I've testing all core functionality.

In my DB I have a text field I want to read The SPEAK script doesnt have enough options for my needs as it doesnt allow changes in pitch, rate, volume and modulation. From witing FMP I can run the follwing Applescript set TESTO to (choose file) tell application "TextEdit" set dialogo to text of (open TESTO) say dialogo using "Daniel" speaking rate 100 pitch 60 end tell The only part i need is say dialogo using "Daniel" speaking rate 100 pitch 60 where "dialogo" should be the text field to read with the choosen voice, rate, volume, modulation in my db The original Applescriopt works perfectly from FMPad13. Use the Briti…

Hi I would like to have a log or list of users that modified a record, but I do not really need to see what they have modified. Anyway, I have tried using the on commit script trigger to fill a table with record ID, timestamp and account name, which in a way works but the problem with this is that every time something is modified in a record, like a radiobutton the script will trigger if the user clicks somewhere else on the same layout and same record. So it commits a lot of times, filling the table with countless and useless entries. I would like to see only the ten (or so) last users to modify the record (not those that only viewed it!). I can use a timer to do a …

Hey folks, I am working on a layout that auto-populates a bunch of data from related fields. One of the fields is called district_number which has the numerical 1-12 value, depending on the district. I am trying to get a script to read the district number, then based on the value have it populate data in another field. I started by setting the district_number as a variable, $DistrictNumber Then I have the If statement: If[$DistrictAddress = "01"] Insert Text [Select;xxx::district_address_label; "District 1 P.O. Box 3700 blah blah blah"] Else If [$DistrictAddress = "02"] Insert Text [Select;xxx::district_address_label; "District 2 P.O…

I have a script for the user to import an EXCEL file into the Database. I noticed though if the system is slow for some reason and the user does not look at the records tab to see that records have been imported the user may click import again thus doubling the data. How do I keep the user from inputting the same data twice? Here is my script: Go to Layout ["Choir Catalog Details" (ChoirCatalog)] Import Records [With dialog:off; Source: "CatalogImport.xlsx"; Worksheet: "Choral"; Add; Windows ANSI] Show All Records Thank you.

Hi, pulling my hair out here! I would like FileMaker to build a setlist based on which staff member knows what song. I have a database of songs and a database of players I have a join table that links these - it looks like this: STA01 SNGID03 STA01 SNGID04 STA05 SNGID03 STA05 SNGID04 STA05 SNGID07 STA07 SNGID03 I want to do take the above information and say something like this... Find: STA01 and STA05 Constrain find to all matching songs. *using the info above that would be... STA01 SNGID03 STA01 SNGID04 STA05 SNGID03 STA05 SNGID04 That would give me a setlist of…

I have a database field set with a validation of "Unique value". I am trying to revise a script that loops thru all the records and updates the value in the field. Currently, my script loop stalls when the value written in a record is not unique. I want to bypass writing the updated value if not unique, but I can't find a way past the Filemaker error code 504. All I can do is manually "Revert" to the original field value. Suggestions?

Perform Find[] Save Records as Excel [With dialog:On; ""Catalog.xlsx""; Automatically open; Records being browsed] Go to Layout [original layout] Show All Records I am getting the following error: ""Catolog.xlsx"" count not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk. I have a 2 TB drive with plenty of room. I have renamed it several times and made sure that it had full user access. When I debug I get this: Last error: [800] Unable to create file on disk I have made scripts many times before for EXCEL export and never had this problem. I have searched for an answer and have not f…

I am having a tough time getting the set field by name script step to work and hoping someone can help me with this. I have a file of sales transactions over many years. I have a related file for customers. The customer file has counters for how many times a customer visits each year, how many suits, sportcoats, etc. they buy each year ( visits_2017, visits_2016, visits_2015, suit_count_2017, suit_count_2016, suit_count_2015 and so forth). I would like my script to evaluate the year of the transaction in sales and update the appropriate counter in customers. I have been unsuccessful in defining a variable and set field by name combination to accomplish this ta…

Hello, I have a weird issue that just started happening when I use the 'Print to PDF' script step in a loop. I have a script that passes through and prints out a set of pages. When I use the script Debugger and when I reach the spot I am having issues with, I can see, during the preview, that it is in the correct record; showing the correct page, but once it is done and saved as a PDF, it is showing the first record that was browsed. I have attached a snapshot of the script I am using. If you notice, I have it go to the layout First, Performs a Find based on a Variable - It finds the proper records. Then it goes to the first record, (for th…

Hi. I have a search field, a user types his customer number in it. I want to when a user types his customer number and press inter-script run. how can I do this work? I use on object keystroke but when I want to type number script run and user can't type phone numbers. how can I fix this?

I have a number of scripts that have worked perfectly for years in previous versions of FileMaker, however in FMP 15 they causse FM to crash. They only way I have found to avoid the crash is to use the debugger and to use the "step into" button. That of course is a very cumbersome workaround. You can see one of the culprits below. Anyone have any ideas what's wrong here?

I have a php script that takes two PDF files and merges them into one file. I am using this in conjunction with the insert from URL script step. The way the script works is it takes two PDFs in container fields and base64encode each files. Then, those two base 64 strings are POSTed via insert from URL. I've tested the script forwards and backwards and it does combine the PDF files reliably. The issue is when posting from FileMaker. What typically happens is the first page is combined twice and that's my resultant PDF. My php script checks that both inputs are different and throws an error is they are identical. I don't get any errors there. Is there …

Hi everyone. I was wondering if you could help me . I have a database of service certificates and i wanted to create a script that would run when the admin logs in. Ive started it and it does what i want to a fashion (ive not added the admin part yet) but ive hit a problem and i cant figure out how to get around it. The problem i have is that its not taking into consideration that a new service has been done . Its picking up the old retest date not the latest one for that customer. i need to find ONLY the ones that havent been re-serviced yet. Im doing a find on the retest date 30 days before the certificate runs out so that i can organise the service to be done . …

Hi everyone. Strange behavior happening with my script that I can't determine the source of: I have a dropdown list on my Loans layout that triggers a script. The dropdown TEXT field is set to a simple Yes or No, and when changed, triggers this script. At the beginning of my script, I pass the value of the dropdown field to a variable "$returned". It correctly receives the selected value. And the value correctly matches that of the field Loan Sale::Returned. However, when I go to test the variable, or even the original field-- If($returned="Yes") or by testing If(Loan Sale::Returned = "Yes) --it does not validate. I even use a Show Custom Dialog box with th…

After my post from 2008: I gave up on localization, because the buttons on the dialog boxes couldn't be filled with custom text. Now that this is possible, I'm dabbling at this again and I have a question. For the dialog boxes, I've created a table with one record per dialog box. There's a field for the content and one each for up to three buttons. When clicking a button, I'm capturing two script parameters, one for the currently selected language and one for the ID of the proper dialog. This creates a key field and pulls out the proper text strings. This seems to work well so far (although I'm still at an early stage here). Now with field labels that stra…

I have a client using FM12 Server and Client. He's requesting a "screenshot" of a table of related data to be attached (in-line) to a script-generated email. I know of no way of scripting a screenshot within FileMaker without the use of a plugin. I was thinking of saving as a PDF and then attaching to an email, but his users cannot mount the FM Server, so there is no path I can assign to the exported PDF. Is there a clever workaround to achieve the desired result? I'm aware than I can display each field in the body of the email, but he wants it to be formatted in columns and rows the way it looks on the layout. Thanks for your help.

FM 12 often hangs with the spinning beach ball of death when I run this script (see attached). It "says" it's hanging on on a New Window script step, or, I'm assuming that because it's always highlighted in red when FM stops responding. The bottom of the Script Debugger window states, "unnamed button". I don't know what that is. The script is accessed by clicking a button. I've rebuilt the layout several times to make sure there is only button on the layout. The layout has no script triggers and the script itself seems relatively straightforward. I've recovered the file a few times as well to no avail. Any ideas? Should I rebuild the scr…

Hi everyone. I have something here that I'm sure isn't too hard to do but I haven't been able to figure this out myself and I can't seem to find the solution with a quick search either. What I have is a database with three fields that I would like to be able to search at once with a pop-up dialog box. My hope is to create a button that a user could click and be presented with a dialog box that allows a text string to be entered. This would then perform the same search on the three seperate fields and return a found set of all the matching values. So... 1) Click button 2) User enters data via dialog box 3) Search is performed (search string found in …

Hi all We have a web based tickets portal which creates new messages in our filemaker database - this is for customers' use. It does this using the PHP API (the website was developed by a third party). We would like the owners of tickets to be notified when the customer has added a message to one of the tickets that they are in charge of. Is there a way for filemaker/filemaker server to trigger a 'send email' script when a new record is created via the web portal? Or would it be simpler for this action to occur on the web side? Many thanks

Hello to all, I have a database and I want to block modification of the fields if a given variable is not = 1. can i do this? i have create a button that change the variable from 0 (non modifiable) to 1 (modifiable) but if the variable is 0 i want that fields are only reading. i use Filemaker Pro 15 for mac thanks Andrew