Script Workspace and Script Triggers

Hello everyone, As I am still relatively new to FileMaker, especially, scripts, I would like to ask for your help. I am currently in the process of preparing a historical database of officials delegated to maintain order in private estates. The existence of both the officials and the estates needs to be confirmed by historical sources. So the 3 tables are: Sources, Jito (the officials) and Jito-shiki (the jurisdictions in estates). One source can mention multiple officials and estates; an official may appear in many sources and hold jurisdiction in numerous estates; lastly, a given estate may appear in multiple sources and may have been under the jurisdiction of…

I'd like to add a condition to this to not do it if "id" already exists in the table: Set Field [ Moby_Countries_Values::ID ; JSONGetElement ( $record ; "id" ) ] So that value, 'id' is embedded within the blob that I'm parsing already. In that loop some of the array sets may exist, others many not already. If [ not IsEmpty( $countries ) ] Set Field [ ISBN::JSON_VariableView1 ; $countries ] Set Variable [ $Cover_Group_ID ; Value: ISBN::ISBN_ID ] Set Variable [ $n ; Value: ValueCount ( JSONListKeys ( $authors ; "" ) ) ] Freeze Window Go to Layout [ “ISBN_Meta” (ISBN_Meta) ; Animation: None ] Loop Set Variable [ $i ; Value: $i + 1 ] …

When i choose script workspace from the drop down menu, the display does not show on the screen. It shows that a window is open but there is no display. It happened once before and re-booting fixed it but not this time. Any ideas on what it could be? Thanks.

I have a simple Excel document one of my partner using as an sales order sheet. A few fields has to be fill out, such as quantity, type of goods and preferred delivery date. At first I tried to learn how to make excel style sheet and export data from Filemaker to xml. Since I am mac user it turns out, it is not a simple task. Then somebody told me to explore use of apple script. It works almost like a charm. Here is what I did so far. I created script in filemaker as follows: Set variable [ $quantity ; Value: Orders::Quantitiy ] Set variable [ $goods ; Value: Orders::Type of goods ] Perform AppleScript [ "tell application \"Microsoft Excel\"" &amp…

Hi to all Back to FM after along time. I am trying to add a layout that the user selects what product he is Selling with a checkbox . At the end after he finish. FM will generate a pdf with terms for etch product. The terms will br different for etch product. Thanks Dani

Does filemaker pro 16 have a "send in mail" command which can be built into a script? I seem to be missing something obvious. I have a script which I want to send an email to each customer in a set of found records. I can by using the send mail script command create a new email for each record, insert each individual email address, add to the subject matter and include a personalised note. What I can't seem to do is send a PDF of the record,(which is a laid out invoice with a graphic letterhead). If I don't use this script and simply use “send in Mail” from the print dialogue box it puts the invoice in a new email but I don't get the insertion of …

Is there a simple way to verify if a specific printer is installed on the users computer (macOS) prior to executing a print command via script? I know that some of the popular plugins extend print options, but I have a "one off" need to halt the script of a specific printer is not installed. Not sure if FMP can handle natively, or if its easily accomplished through AppleScript? FYI, the printer name is "Zebra ZT230-7". Thanks!

I have a list of items in a category dropdown list. If a user clicks on the dropdown and the item they want is not there, they can type the new item in. I want to add the new item to the list for future users. I have never used a loop before and the below script ends up in an infinite loop. I run it as a scrip trigger on the Category field as an OnObjectExit. I was hoping that once the item was entered into the field the script would loop through the existing list and exit if it found the item already exists. If it did not find the word it would add it to the list. Can someone help me with this please??

hi, I have a googlesheet through which I collect data, submitted with googleforms. example: https://docs.google.com/spreadsheets/d/1tg1CkSOrY-zFb9eGI2pHEH5JnxfHKvCoatwpI56ThgM/edit?usp=sharing By using Insert from URL with URL https://docs.google.com/spreadsheets/d/1tg1CkSOrY-zFb9eGI2pHEH5JnxfHKvCoatwpI56ThgM/export?format=tsv&gid=916562697 (same as the original link except that you replace edit? with export?format=tsv&, I can import the file content as a tab separated text into a text field, export it again as at tsv file and import it in the correct fields into Filemaker. Insert from URL [ import::temp file; "https://docs.go…

Trying to capture text from the web viewer: I want to get "On-Line Systems" Usually this kind of stuff is just right after the "Published by", but since this is a hyperlink it's got varied contents between that and the actual string I want. ;">Published by</div><div style="font-size: 90%; padding-left: 1em; padding-bottom: 0.25em;"><a href="https://www.mobygames.com/company/sierra-entertainment-inc">On-Line&nbsp;Systems</a></div><div With this script I can capture "<div style="font-size: 90%; padding-left: 1em; padding-bottom: 0.25em;"><a href="https://www.mobygames.com/company/sierra-entertainm…

I made a sandbox version of what I'm trying to do. When I make an entry on the left column, in one of the red titled fields, it's using a value list that is based on existing values in a related table of that name. If I type in something that is not on that value list, I get an "Add" button next to the field name. Click it and I've now created that "new vendor/publisher/developer". That's all good. If I pick something that is on that value list, I would like to load it's key (Vendors::ID) into Items::Vendor_IDfk so that I can relate the current record in Items to that Vendor. ...and why do the totals in the footer not work for the related tables? …

Hi, I have a field to count the number of records between certain date in calculation: ExecuteSQL ( "Select Count(*) FROM Order2 WHERE DueDate BETWEEN WeekStartDate AND WeekEndDate AND Decoration = 'Digital'"; ""; "") It works the first time but it cannot refresh in the field when there are changes. Is there anything I can do to refresh it? Thanks. KC

I have a Script that uses "Export Records" to export a file to the following path: file:../../../../Desktop/OUTPUT/Untitled.tab How do I get 'Untitled' replaced by the contents of a field in my Table?

Can i configure a script trigger on FM 8.5 to run when a customer looks at my database using Instant Web?...I want to limit what layouts he sees dave

Further to my previous question on the topic posted here, I am disappointed to say that after just upgrading to FM18 the issue is exactly the same. I have also downloaded the great utility SMTP_SendMail_Interrogation from SavvyData and it confirms that no combination of settings worked. But just so I don't post here for merely complaining, I'd like to know if anyone has successfully sent messages using the smtp script step and would share their tricks. It used to work for me in FM 10, but stopped working out of the blue. Thanks,

On our tiny relational db, we have CLIENTS - with Client nº, Source, FIrst_name & Second_Name Policies -with Client Nº, Policy Nº, StartDate, Premium, PolicyStatus ( i.e. Active or cancelled) Once the User has done a find, for the policies for their selected SOURCE, I want to print of a report, in STARTDATE order, with these details for all policies for the given SOURCE At the moment, I get the policies for the defined FIND SET i.e. the User selected SOURCE, but the report only shows the the FIRST policy for each client. What am I missing? NB Thisis on Win 10 Machine, with Filemaker 16

I have a script that prints off receipts in a loop, one for the office and then one to be given to the client. All works well, except sometimes we only need the office copy so I have a step : Pause/Resume Script [ Indefinitely ] At this point if we clink on Continue of press an ENTER key the script continues and prints the second receipt, but is we click on CANCEL, the script stops. This is technically correct, but I want capture this Error Code = 1 and return the user to the original Client screen Go to Layout [original layout; animation: none] ................................. I have tried and if Get (LastError) = 1 Go to Layout [original lay…

Hello I hope all is well and everyone is safe I have a dilemma I hope someone could help me I have been trying to figure it out but with all the video watching and reading and searching I have no Joy I have a Table for Contacts Table for Analytical Table for Samples I have joined them witch all works fine but here is my dilemma On the data Entry Screen I have my samples on my portal to be tested and then I click the popover to test the sample and choose the correct method I have used for the sample result. As you can see on the screenshot one test is Chrysotile / and the other is Amosite / But I may have to examine the sample…

Hi there I'm trying to set up a self join portal to show active orders only on an iPad (those classified as either overdue or ordered). I created a global value of 1 for the parent side g.ActiveStatus is set to = 1 and then on the child side I matched to a calculation field c.OrderStatus where records with "ordered" = 1 or "overdue" = 1. Calculation result is a number (global also is a number). However the related records will not show in the portal. To check my thought process, I removed the calculation on the child side and manually entered 1's, and the portal works. But with the calculation it does not. I tried to activate indexing, thinking maybe this has something to…

Good day all, I have a script that collects several reports from different tables and assembles them to email via the following code. How do I clear all the reports after the reports have been sent,(or before the next set of reports are compiled). Set Variable [ $Path; Value:Get (TemporaryPath) &"Products Active" & " " & Year ( JobCardItems::DateNextServ )& "-" & Month ( JobCardItems::DateNextServ ) & ".pdf" ] Save Records as PDF [ File Name: “$Path”; Create folders:No; Records being browsed ] [ Document - ] [ Pages - Number Pages From: 1; Include: All pages ] [ Security - Printing: High Resolution; Edi…

Good morning. I am trying to setup a portal for viewing products where there are a number of conditions by which I view this portal. This includes a keyword search and filtering by other criteria. The snippet below with the keyword search (second line), and the PatternCount() in the fourth line work fine, but the bit I am not getting to work is parsing the third line (in bold). The content of this line needs to be dynamic - so a field or variable that I point to. I know that if I put the actual condition text there (or True) it works fine, but not coming from a field or variable. I am assuming that this should be possible. Is there some other way to format this…

I have a Service forms database. Each form has a customer and machine serial number field with a value list for the serial number. Currently the value list shows the serial number as the specified field and it shows the serial number for all customers but I would like to know how to filter the pick list to show only the serial numbers relating to the customer on the current form. Can I do it using the pick list or do I need to create a portal?

I have set up an email routine for a client, who is using Office 365, and I am testing on my desktop at home before I move it to their server. I can send email in this script via my own domain, no problem, as I have been able to for many years. But it seems that no matter what options I use mail doesn't successfully send via Office 365. I've tried "office365.com", "smtp.office365.com", "outlook.office365.com" for the outgoing server. I've added an Exchange account in system prefs. I've tried every combination of port and authentication. It generally results in "The connection was refused by the SMTP server"... error 1502. (Sometimes 1506.) It is the same wi…

At wits end- When I try to send an email with a record saved as a pdf attached, it won't send. The email is sent fine via the SMTP server if I do not include the attachment. With the attachment in the send email script step, the error is 1506, can't send the email. The pdf is generated from a Save Records as PDF script step to $$ACORPReportTemporaryPath The variable was generated from Get (TemporaryPath) & "ACORPReport.pdf" If I email the value of the variable in the body of an email from the script, I get: $$ACORPReportTemporaryPath = /C:/Windows/Temp/S217/ACORPReport.pdf In the send email, for the file to attach, I have: $$ACORPReport…

Hi there, I am writing this post in order to request some assistance in creating a simple script which will allow me to find a number of records matching a certain criteria and then modify the date of those tasks. Brief - I have a simple database of which the primary function is to keep a record of jobs. A task list essentially. Each record has a number of fields included due date and status. Status are a pre defined list of string possibilities such as ''Open", "Complete", "In Progress". I have written a script which will find all records that have a due date of (today) and status of 'In Progress'. The script will then alter the due date of these rec…

I have a shutdown script where if you quit or close the last window, a dialog box comes up and asks if you really want to quit. Pressing "cancel" halts the script, pressing "continue" closes the last window and so quits Filemaker. I'm trying to figure out how to cause the script to continue and close the last window after a period of time (say, 10 seconds) if the user doesn't press anything at all. Script is: Open dialog that says "Close this last window? This will close dBase completely." If [ Dial_GetButton (DIALOGTEXT) = 2 ] >>Note: I use Troi Dialog<< Halt Script Else Go To Layout [ "DevStartup" (DevStartup) ; Animation: None…

I've been working for many hours trying to configure the SMTP settings so that FM10 can send email directly, rather than through my email client. (This is necessary if the email is to work over IWP.) I gather from reading other forum posts on this topic that a lot of other people have run into the same problem. But I've tried all the solutions I've seen posted, and nothing has worked. What I've done so far: 1) copied account info from my email client 2) set the port # to 465 and the password to SSL, plain password 3) left the name field blank 4) tried sending mail via Earthlink's SMTP (where I also have an account) 5) tried setting the gmail account in…

Hi, I am trying to created a group of related records in a portal based on a JSON array I have parsed. I have a bug where it only creates one related record in the portal and then creates a new parent record for the remaining # in the array. If the array has 14 items I get in the portal for the related records and then get 13 new parent records. Any idea what im doing wrong? Set Variable [ $$json ; Value: Bid_Requests::AirbnbJSONRESPONSE ] Set Variable [ $fkey ; Value: Bid_Requests::PrimaryKey ] Set Variable [ $ItemCount ; Value: ValueCount ( JSONListKeys ( Bid_Requests::AirbnbJSONRESPONSE ; "object.response.response_json.explore_tabs[0].sections[0].lis…

Greets, all: Attached is a script I cobbled together that works as it should, but I'm just wondering if there's a more elegant way of coding it: There are three text fields (Sort1__lxt, Sort2__lxt, and Sort3__lxt) where users can choose from a value list (with three values: Entered By, Date, and Student Name) the order they want the values to appear in a sub-summary report, e.g., Entered By as the first level, Date as the second level, and Student Name as the third level. I have a number of these same-style reports so what I'm doing is duplicating the same script and replacing the fieldnames for each one, but I'm thinking that there's gotta be a better way of co…

Hi All! I have been playing around with Filemaker 18 and have run into an issue that I am currently unable to resolve. I hope I don't confuse everyone with my query. FYI - I am not a developer and don't have a coding background. I have taught myself essentially everything I know by watching videos and reading forums and filemaker Help. I am working on creating a record of an interaction with a client. There is a way to create an appointment for the interaction and then that takes you the layout for documenting the conversation. The layout has multiple fields each of which link to their own tables. When I click on Topics discussed, this will launch a new w…

I can't seem to get "Go To Layout (layout name by calculation)" to work ... help? I'm passing a variable "$Layout" as the calucation. I've checked spelling over and over. I've tried different layouts. It simply won't honor the name in the variable. Any ideas anyone? I'm in the latest version of everything. Steve Shiver

hi all, need desperate help in putting together a script to find missing numbers between the lowest and highest. e.g. 1, 2.4,6,10 need a report to show the missing numbers 3,5,7,8,9 help is greatly appreciated Thanks.

Hi gang - I have another question, this time in regards to popup window positioning in a Windows 10, multiple monitor scenario. The problem is - I have the FM12 solution running on Monitor 2 (the extended desktop display), and when one of my popup windows activates, it always pops up in position, but on Monitor 1 (the main display where all the desktop icons are). I want the popup window to appear in relation to where the original solution is sitting, not 2 miles away on another monitor. Window positioning is important because the industry we're in requires multiple solutions and websites to be open for the research we do. Thank you all in advance!

Hello! I am assuming there is an easy fix that I am just missing, but I am having trouble setting a field to be a "Copy" button. I have an email field, and want users to be able to click on the email field to copy it to their clipboard since I have field entry turned off so users cannot edit it. I set the target field and selected all contents, but when I try it, it is still not copying and when I paste, it is something else that I have previously copied. Any ideas? Any other information that would be helpful? Thanks!

Greets, all: I have a script to import the data from an exported Excel file, then it does its thing and exports the data into a .csv file--and it works just fine--but the filename of the source file always differs so I can't hard code that filename into the Specify Data Source option in the Import Records script step. C'est la vie. However, I would like to extract that filename so when the latter part of the import script exports the data as a .csv file, the exported file has the same filename as the source file (but with a different file extension, of course). Is there a way to capture the source filename during the import process--as a variable, I reckon--so I can …

I have exported a PDF that I want to upload to a SFTP Server, but I cannot get it to work. The SFTP server is located at port 2222. File: $filepath FTP Server: ftp.theserver.com User: ftp_user Login: password I was trying with the Insert from URL script step, and specified it as follows: URL: sftp://ftp.tehserver.com:2222 cURL: --upload-file $filepath --user ftp_user:password I get error "Command is unavailable" Have I misunderstood the Insert from URL function or am I doing something else wrong? Thanks, Andreas

Hi, I have a script to truncate all the data out of the tables in an external FileMaker Database. I confirmed this works for one custom FileMaker database I tested with several tables. It uses the Base Elements plugin SQL TRUNCATE command to truncate all the data. However, we have many databases coming in written in a custom FileMaker application, let's call it Foobar, where the script workspace is disabled for each of these. For testing purposes, we would like to truncate all data from one Foobar database. I can run Base Elements SQL SELECT commands no problem on any Foobar database from my own separate FM database which runs the script, after I enter the correct us…

I have two files: (1) "Clients" and (2) "Orders". They are separate files, not two tables within one file. I am creating a simple script in "Clients" that will pass the unique client code in the current record to a script in "Orders" that will create a new order with that client code. In the "Clients" script I have a Perform Script command which is allowing me specify a script in "Orders". However, the list of scripts that it shows from "Orders" is not up-to-date. It shows scripts that I deleted days ago and does not show my newly created script for creating an order from a client code. I've tried closing the files and re-opening, and even recovering the files…

Hi all, on one machine where I have FMP v10 running, my mail scripts have suddenly (I think) stopped working. I created a test file, but I get the same results. The script used to work just fine. Now I always get a box saying "There was an error with SSL". My provider changed addresses a while back but the old server names are still working, presumably to not break everyone's email client. I have tried with both the old and the new SSL credentials and it makes no difference. Sending emails vial my normal email client app works fine, so the credentials are obviously correct. In the script, I tried leaving out the name (found that as a possible cause while searchi…

Hi guys, I am trying to create a very basic script that would allow for continues scanning, but don’t seem to be able to figure out how to get the script to work. i set a script trigger to execute on exit with the following script. new record go to filed [item_code] the idea is so when I scan an item the scanner will add a return at the end exiting the field, and so triggering to run the script over. all I get is an endless loop. thanks

Might no have been clear enough .... I have the label part figured the one part I'm having issue is having 4 labels for one record (or 2 or 3 depending) ... Hi everyone, I have to generate packaging labels based on the qty of an order and on how many units are in each package. To make this simpler to understand ... I have an order for 100 units, customer wants is order packaged in 25 units. So I need 4 label Pack 1of 4 , pack 2 of 4 and so on .... If customer was to ask for 50 counts packaging then it would only be 2 labels .... Where do I start ?

Why can I not add Azure AD authenticated accounts with the Add-Account script step. I have users authenticating in AAD who need to invite other AAD users to my filemaker application. If scripting is not possible then they will all have to be entered manually. Why is this not possible? I saw this, https://community.filemaker.com/en/s/question/0D50H00006h9Eaz/add-account-missing-oauth-users but there wasn't any explanation of why it wasn't possible. This seems like it could be done exactly the same as local accounts, but instead, the feature is simply missing.

Hi, I have a scripted Find. The script opens a new window (the original window remains in the background), enters find mode and pauses. The user inputs data in the available fields and then supossely press an OK button that resumes the script and carry out the search. Then the script close the Find window and return the user to the original window, showing the found set. It is like a 1 window original - 2 windows original-find - 1 window original-foundset game. The original FileMaker menus, Status area and Text ruler are all hidden. The problem is that if the user hits the keyboard Enter key instead of the OK button, the Find is carried out but the rest of the s…

Hi FMForums Community, When searching for Table::Type1 = "ABL" in my (1000 record) database I get 300 records. I've added a Portal and within the "Filter Portal records" option I wrote the following: If ( Table::Type1 = "ABL" and ( Table::Type2 = "XA" or Table::Type2 = "YA" or Table::Type2 = "ZA") ; Table::ID ; 0 ) I should be retrieving only 50 out of the initial 300 records but I'm still retrieving all 300 records where Type1 = ABL. The 50 records that fulfill criteria are visible and the other 250 are appearing blank. When I write: If ( Table::Type1 = "ABL" ; Table::ID ; 0 ) I retrieve just the 300 expected records. I don't understand why…

Good Afternoon, I’ve written a script to create a virtual list of titles from two tables. The script is executed from a table B record. It first searches for the records in table B where the author is the same as the author on the table B record from which it is executed, and then for table A records with that same author. Everything works fine as long as the table B record has only one author in the author field. When there is more than one, the script fails to loop through the table B author field. It looks like it is taking only the first author into account. The table B author field is based on a dropdown list of names all separated by a carriage return. I’m pul…

Hi, I'm sorting a portal on Document Title, Document Author and Document Number. The sorting is done by clicking on column headers, using the script and calculated fields below. The problem is with the sorting on the document number. It does not really work as for instance, in ascending order, document number 786 displays before document 85. That's because the sorting is done on the first digit, so adding a zero in front of 85 would resolve the issue, but renumbering documents 1 to 999 is not an option. So based on my research, it looks like the solution to this (or at least one solution) would be for the sorting script to add three invisible 0 in front of document n…

I am filtering a field called "OPEN" WITH RANGE 1...10 i m getting 487 records found from that record i want to filter "AMT" field with range 5000...10000 couldn't do it trying extend found set and constrain found set getting erratic results kindly help me enclosing file down plz

Background: I am moving files that are created and exported to another system. I create the files in FM and then manually enter the Terminal and execute a command. Now I want to automate this process. I'm on macOS 10.13 with FM 17. Problem: When I perform the Terminal command via AppleScript I get an error. I can do the exact same command manually in the Terminal, and it works, but not when Apple Script tries to do it. Details: Relevant script steps from Filemaker: Set variable [$shellScript; "tell application \"Terminal\" ¶do shell script \"./sendtonav CSSE " & $shellScriptParameter & "\"¶end tell"] Perform AppleScript [$shellScript] T…

I have a couple of scripts that do things in macOS Terminal via an AppleScript. It may look like this: Perform AppleScript [ Native AppleScript: tell application "Terminal" do shell script "cd /Users/admin/Desktop/Exportdata; curl -T Script1.txt -u filemaker:pass123 ftp://ftp.apple.com/" end tell ] Problem: I don't get any information if this work or not. Is there any way to see the command actual taking place? I added an "Activate" after the "tell" line, but that didn't help. As it is now, I do the scripts manually, just to maintain the control of what's happening, but that seems awfully old and not so effective. I would like to automatize this,…

Hi, I am after a fairly simple thing yet the new FM18 file features don't seem to do what I want... Goal: I want to import a file for external container storage. I want to change the filename so that it is stored with a job number prefixed to the front. So, all I am really doing is renaming a file. I don't want to use a plugin. That said, we have an ftp plugin and I think it may do this for us so I could do that but I prefer to avoid. I think I could do this: - Import into a global container, export it using a different name to the temporary folder, import it into the correct long term storage field and then delete the contents of the global co…

I knew this once, but... When entering the parameters for the Set Variable script step, what is the keyboard shortcut to access the Specify... button? Tab moves from input field to input field, but does not let me get to the buttons.

A simple script to close the file, saving a copy for backup, fails to log the user out. Each time I open the file after the initial opening, the login and password request is bypassed. Simple file closing script: 1. Flush Cache to Disk 2. Save a Copy As ... 3. Close File When I re-open the file, I am NOT asked for my login details. I need the re-opened file to ask for login and password on each opening. Simple opening script reads: 1. Go to Layout 2. Adjust Window 3. Show all Records Question: What do I need to add to either of these scripts to force FM Pro 18 to ask for login details every time the file opens? I can't find the answer…

I'm using the "Calculated value" option in the Auto-Enter Options dialog box to run calculations on several fields during an Import of data. It cleans up some miss spelled data. But I need to turn OFF the "Calculated value" options after the import is done using a Script step if there is one? Or some other method? And back on before the import as well. FYI... If I leave it turned on the Formula I have specified for the Calc will make the field data disappear if it doesn't match and of the possible calculation results. I did see the wonderful Auto-Enter options in the newly updated Import Dialog box in FileMaker 18, but that wants the formula's left activ…

Is this doable using filemaker Go or Windows? there's a speak function but it is only for OS X

This is continuation that i'm working on a Water Billing App. I need this calculation for my Disconnection Letter. I would like to subtract the last portal row or the row that is not "Due" and don't have penalties yet. so like the data show above, the bill #-08-0000133-5 is not yet Due coz it does'nt have a penalty yet, so this row will have to subtract to the total balance. like this Total Balance= 2,934.568-580.30 Total is 2,354.27 and it will show here: Thanks for the reply in advaced.

I prefer to use the mouse as little as possible. I have tried unsuccessfully to find keyboard controls for Script Workspace. For example, if I want to enter a Sort Records step, I can enter the command by typing s-o-r, then Return. But then I have to reach for the mouse to turn off the dialog and click the cog icon to get to the specifics. Once I get to the field list, I can use the keyboard for only a few strokes. For example, if I have fields nameFirst nameLast nameMiddle namePreferred entering n-a takes me to nameFirst, but it stops filtering at that point. Entering n-p, or even n-a-m-e-p, will not take me to namePreferred. Writing scripts is a con…

I created a script that emails invoices and applies a time stamp.. That worked great when used one layout page at a time. I was then asked if we could do multiple pages instead one at a time. I just had them find all the pages that they wanted to email so the script would email all that was being browsed. This method works great but it only applies the time stamp to the first page in the browsed pages. Is there a way to make the time stamp apply to all the browsed pages when emailed. I'm using filemaker 11 pro right now. The script that I'm using is below. Insert Calculated Result [Select; Invoicing:: Emailed Timestamp; Get (currentHostTimeStamp)] Go to L…

I made a script called - SPEAK assigned to a button as we know by pressing esc on keyboard we can pause a script but i want to stop the above script called SPEAK using Code ( Get(TriggerKeystroke) ) = 9 that is equal to TAB key HELP me please

I am trying to script completion status for each product that my cabinet shop builds. To make this happen I have created a library of possible cabinet styles. This library contains all the tasks specific to each particular cabinet style. The process starts out with creating a record in the PROJECT table, stipulating what style of cabinet it is then activating a script that imports tasks germane to that style of cabinet. The logic for this seems simple enough but I cannot get the script to properly import the tasks. No matter what style of cabinet I initially stipulate it defaults to the first style in the library. It also won't import tasks for the same styl…

Hi to all, In Server 18, I created a schedule script to run a script every night. I use an account with [Full Access] privileges I verify the script for server compatibility I verify that the script works correctly from FMPA When I run the schedule from the Admin Console I get the last run "Succeeded" but I don't see the results "As if nothing happened" What I can be doing wrong?

Hello. Please excuse the long-winded first post: I apologize for taking the time to ask such a basic question, but this is a platform I will only delve into if it solves this need. By the time I can answer that question, I'll have sunk an awful lot of learning into it, so I figured I'd ask in advance and maybe save the labor. I have no formal programming experience, but grew up in the kind of family that thinks teaching a little kid BASIC is a fun idea and I don't shy away from challenges. I do lighting for television and I need to setup a system to manage rental inventory in/out. I am coming at this from the rentER side, trying to efficiently track and record i…

With several different PDFs in different fields, and also in different related records, I need to combine the pdfs into a single pdf. I can save the current record Save Record as a PDF and this is the only script command that can append to an existing pdf. But that doesn't solve the problem of needing to append in PDFs from a variety of different container fields. For some reason, the Export Field Contents script step does not have an append option, as does Save Record as a PDF. Recommendations?

I have been trying to work this out for a while now but just can't get it to work. I have a ToDo app I am making for my own use. On the ToDo page i have a button that sends non-urgent tasks to a table called TOMORROW. It date stamps the task being sent to TOMORROW with the current date. When I open the app the next day I want a script trigger to go to TOMORROW, check the date of the tasks. All that are less than todays date (which should be all of them), it sends them to the ToDo table. I have it working OK but it only does one record at a time. It won't loop through the records for some reason?? A copy of the script is below. Any advice is appreciated.

Hi, I may be running out of lives soon, but after Comment's very helpful answers to previous, have a possibly final sticking point. I want to return all the Field Names in a given external FMP12 table, ie again I must use BE_FileMakerSQL function or something else, as ExecuteSQL won't work. Following produces error (returns '?'): BE_FileMakerSQL ( "SELECT FieldName FROM FileMaker_Fields WHERE TableName = " & Quote($table) ; "," ; ¶ ; $fm_file ) So I assume that FileMaker_Fields is accessible to Execute SQL but not to the Base Elements plugin function BE_FileMakerSQL. Following doesn't work either, trying the standard SQL query to get field(column) na…

I'm learning JSON to collect data into a java graph. The reason is that I want to show the answers to a survey question in a line chart. The table structure looks like this: (I do not know why the graph shows the relationships as many to many, they are not, but it is actually one to many. If anyone knows why it is like this then please tell..) I have a list view based on the responses table. I want the graph to show the requested result in the list view. The results are always from one question but the question is asked three times a day (in three different surveys) so there are three lines per date. The fields in the list view that I would like to collect…

I have a button on my layout that will open a folder on the network. It is working correctly and going to the specified folder. However, it is mounting a drive to that folder on my desktop. I do not want this extra clutter as I will have to Eject the drive as my desktop fills up with the icons from each button click. Here is my script when I click the button: I set three varibles Set Variable [$part1] <--simplified Set Variable [$part2] Set Variable[$completePath = $part1 + $part2] Open URL [ With dialog: Off ; $CompletePath] Image of filemaker adding mount to desktop when button pushed I am on a MAC. Thanks!

Greets, all: I downloaded this instructional file (https://www.seedcode.com/virtual-list/) to learn about virtual lists and I'm stuck trying to understand how part of it works, so maybe the wizened among you can explain it to simpleton moi; I'm in the corner wearing the pointed hat. After the Contacts script runs, the Interface Records layout is populated with records from $$VarContent, but I can't figure out how that layout gets populated with individual records from $$VarContent; the data within that global variable is return delimited, so how does it from that to individual records? VirtualList.fmp12

Hello I am having an issue with SMTP send email script step. The email sent is one hour ahead. FM server is version 16.0.4.406. The SMTP server is not in my possession, but I made a test of sending an email by logging to it from web and the time is correct. I tried it by setting gmail SMTP with my account and the time is still not correct. So I suspect this is a FM server issue. The FM server runs on a Windows Server 2012 which is installed on an ESXi. Both times on Windows Server and on ESXi are correct. Even stranger is the fact that if I use data viewer in FM Advanced with variable to watch Get (CurrentHostTimestamp) it shows the correct tim…

Hi, For some reason the script debugger is missing ?? when I open a file in FileMaker 18 Advance ... see pic. Has it moved ?? I can not locate it ?? Suggestions ?

I have a Number field «Kontakttyp_enum». It contains multiple (!) number values, depending on what the user has deemed to select (see picture). It works great — numbers appearing and disappearing in this field, depending on which checkboxes are clicked upon. Now, I’d like to set this field with the «Set Field» script step — but I can’t figure out how. I can read specific values (for example with the function «Position ( Kontakttyp_enum ; 6 ; 1 ; 1 )», but I don’t know how to add or remove a specific number. Has anybody any insight on this? It’s quite interesting. Even though it is a number field, the numbers seem to be delimited by Return characters (¶) — a…

Hi, I would like to use Curl with insert from for uploading picture with Prestashop Web Service. Everything i try failed. I use postman to test and it ran good with using form/data, i don't know how to "translate" something working on postman in FILEMAKER. Could you help me ? Thanks Tom

Good day Gurus, I am trying to check if a record exist during data entry and if it does display a "new windows" with a warning, to accomplish this i am using btih "Set Script Triggers" and error capture in the below script but don't seem to work. Field: kDocumentNumber - "Unique value" is checked Data Entry Window: Warning Message Windows Script i executing on exit using Trigger, here i am using The idea is if error "504" is capture show a new windows. if not exit script. What i am doing wrong or am i using the wrong approach to show a new windows based on an error. Any Help is greatly appreciated Thanks …

Hi, I have an account called Admin and staff. I want the staff account when they log in to send to a layout for staff but also make it like a window mode with no menu or title bar etc as they staff dont need any of that. Is this possible. Thanks

I am trying to loop through just 5 records (just using a test file) to copy owner ID's into consecutive fields on a separate layout. The loop is working, but copies each of the 5 ID's into each field over 5 fields. Can anyone advise what I am doing wrong please??

Hello, I'm working on a script to convert a list of numbers into a user friendly range of numbers. For example, here's a list of numbers 21 22 23 24 25 31 32 33 34 35 I would like it to set a field with: 21-25,31-35 I have a script that can easily deal with the first half, but I am struggling to make it work with multiple ranges. Set Variable [ $counter; Value:1 ] Set Variable [ $first; Value:GetValue ( range reverse::test unit numbers; $counter)] Set Variable [ $last; Value:$first ] Loop Set Variable [ $last; Value:$last+1 ] Set Variable [ $counter; Value:$counter + 1 ] Exit Loop If [ $last ≠ GetValue ( range reverse::test unit numbers; $counter) ]…

Is there a get function that confirms whether the whole set of records is in the current found set?

Ok ill try not to loose you. I have a layout "List" this shows tasks to do as Y which is setup from another layout in a job setup. On the job setup layout where the person pick Y this part of the job needs to be done, when the person does they choose their name and it auto fills the time / date in another field. What i want is this List showing the Y to be green, but if the person has done this part of the job and the timedate is in the compledate field then the y changes to a different colour like yellow. they are all in the same table too. Im hoping someone can give me help how to perform this. Thanks

Hi, I have a container which i click on and take a photo on my ipad and it shows in the container. I want to be able to click that image on the ipad or pc to view the image full size after. How can i do this?

Hi, in the same table i have 3 fields. Name (this is the drop down of names) Timecompleted Datecompleted I want to have so when a person selects their name in the drop down to complete this task that the current time stamp is filled in. I cant seem to get it to do that but ideally i would like just one field with timestamp 15:30 21/02/2019 I also have about 50 tasks which people can do so hoping a more simple way instead of a fll script for each one. Hope that made sense Cheers

Hi. I have 8 image containers. What im trying to do is setup so a mobile clicks on it and takes the photo (which i have done) but i cant seem to view the images after. Ive tried creating a view button but there isnt a function for view image. This is setup to be used on ios mobiles, android mobiles and Windows 10 pcs Hopefully someone can help.

Hello, I would appreciate help with the following. If there a simpler way, or if I've gone off in the wrong direction, please let me know. I want the user to be able to insert a PDF into a container field in each record of a table. To do this, I tried a simple script as follows, activated by a button in the layout: Go to layout [...] Go to field [...] Insert PDF [filemac:Macintosh/Users/kjc/Personal/Genealogy Docs] The problem is the Insert PDF script. When I paste the path into the script step, I get a message asking me to fix the syntax and try again. I don't know the reason for this. The help files give the following example of specif…

Hi guys, Hopping someone can tell me what i am doing wrong; All i want is a message if "Start Field" is greater than "end Field" and vice versa Attempt 1 Validate field during data entry WTS v2.0::DeliveryMilesStart > WTS v2.0::DeliveryMilesEnd Display message if condition are not met Conditional format to change color to red Issue: validation not work but conditional format is (using the same formula for both format and validation Attempt 2 Script: if [WTS v2.0::DeliveryMilesStart > WTS v2.0::DeliveryMilesEnd] Show customer dialog [message] clear [select entire contents \ target field: DeliveryMile…

hi guys, Please please please, What in the world am i doing wrong in the below script, it only works if the user has [Full Access] . Thanks for any guidance Jmart

Good Morning, We currently have a FM17 server set up, Over the past few months we seem to be having issues with PSOS, At first I thought this was one single script causing issues but after converting it to a client side script, other scripts keep popping up with the same issue. It runs, and never ends as seen by the image below. The script is stuck, has been running for 21 minutes and whilst stuck like this is preventing any other PSOS's from running. Trying to disconnect the user does not work at all requiring us to reboot the server to get everything moving. The script in question is very simple as also seen below. The server has been re-installed fres…

Anyone know the best way to do a simple, powerful script so that when triggered by clicking on a field, the content of that field is copied to the clipboard?

Hello again everyone 🙂 We have a big database that keeps track of several records that people scan and attach files to. Example, a court case and people scan in a police report, or drug tests, etc...... That database is setup to simple click on a button and it will export that data by using the "Export Field Contents" command on a button. It has been working fine for years.............. But the database file has gotten bigger, and BIGGER throughout the past 10 years!!! So they asked me to find a way to export our data, pdf's, pictures, etc.. outside the database. Which I did 🙂 . But now when I click on the button to export the data, NOTHING ha…

Hi all I'm trying to run a powershell script from the base elements plugin, and extract the result in to FileMaker. It works well except when the result appears to be quite large (though no bigger than 10kb in CSV form). Does anyone know anything about the limitations of this plugin function when it comes to returning the result? Thanks!

Greets, all: A simple question yet I can't seem to find a definitive answer: I want to have a script automatically run (in a hosted file on FM Server 18) on the last day of every semester that will create a report (which will be further scripted to be sent by e-mail to multiple users). What do I need to code/set up so the script will run autonomously? TIA for your replies!

Wow! It's been a while since I posted here... Since FM 11 was new... Any way. Working on automated process to bring info together, then export for another process. A new snag I don't know if I have ever solved before. I am exporting sales data. So the import file needs a line with customer data followed by multiple lines of product data. Line 1: Customer 1 Data Line 2: Customer 1 Product 1 Data Line 3: Customer 1 Product 2 Data Line 4: Customer 2 Data Line 5: Customer 2 Product 1 Data etc... I have all the data, but am unfamiliar with a method to script this..

I'm using a global script variable to display numbers on my layout. However, I would like it to display a zero when the result is zero. At the present time, it displays as a blank. Is there a way to do this?

I have a button script that changes the size of a selection in a text field. This is it: Insert Calculated Result [ TextSize ( Middle ( Get ( ActiveFieldContents ) ; Get ( ActiveSelectionStart ) ; Get ( ActiveSelectionSize ) ) ; $size ) ] A problem with this is that if the selection begins with styled characters (bold, underlined, etc) then the entire resized area becomes styled. If there is at least 1 unstyled character before the first styled one, then all styled and unstyled characters remain as they were. What is missing from the calculation?

I am trying to select the photo container field on my layout so that I can paste the clipboard contents in. Here is the AppleScript that I am trying with no success: -- Find the record in the FMP Database with Contact ID = myContactID show (every record whose cell "ID_Contact" = myContactID) -- create a found set tell layout "L300a_CONTACTS_Data_Entry" go to cell "Contact_Container_Photo" paste end tell Any ideas on what I am doing wrong or the correct way to do this?

Hello all, I'm using the script below to send emails with a PDF attachment contained in the record. However, I'd like the script to do this for each record in the table as currently it will only create one email for the record that is being viewed (I tried selecting the "multiple emails" field in the Send Mail setup but it didn't work). I figure this is probably an easy one, but I don't much about scripting yet. Anyone know how I can add a loop to do this for all records? Thanks!

I have a script that requires a pause for radio button input. The pause is currently set for 2.5 seconds. Is it possible to script this such that the pause stops (and the script continues to run) upon field modification?

We have a script that emails automatically, it uses the send mail by SMTP, we would like the logo in jpeg format to be embedded. The script is trigger when the status changes, so the SMTP is the best solution. Maybe I am missing something but I cannot see how to do this, we don't want to have to use a plugin. The body of the email is basically a calculation putting together fields based on the customer. Attaching the logo does not produce the desired result. There must be a work around... Thank you in advance! Caroline

Hello! I want to have an "on record load' script that will add a record to my audit log when an Individual record is viewed/edited, but I am finding that it is getting stuck in a loop since I have the script return to the individual detail layout/original record, so it bounces back and forth between the detail layout and the layout where the audit log record is created. any thoughts on how I can get this loop to stop? Thanks!

Hi folks, My first post. My projects are to import a QuickBooks Items table into FileMaker and update from tables provided from 4 vendors, each with three to eight files of varying structures. I expanded the QB file to include new data available from the source files, stuff we hadn't been tracking before, but will be relevant in the next update to our QB files. One problem I had was how to determine if the current source file contains a certain field, accounting for the different girls named used by each file for the same field in QB For instance, our Roll Price filed could be called Roll Price, Rollprc or Roll prc. In my pseudocode, I had three IFs, …

I am looking at a solution for inventory. One important request is that they need to be able to calculate the inventory for previous dates. E.g. the beginning of the quarter compared to today or this day last year. My thoughts so far to be able to do this is to have an article file and a stock movements file, all values and quantities of stock will be held in the movements file. Basically the last related record will be in the movements table will be current value, but we can also find the last related related record based on any date. Will this be a fast way to calculate or slow? I don't want to start and then find things slow down on me too much. …

I have been assigned a job to update/fix some problems with a FM Database that was created years ago by someone else. I have it all setup, except for one, simple problem. In the layout, it is set to show a person's name, address, zip, state city and phone number. The problem is that not everyone has a phone number listed. So if they don't have a phone number, the sentence will end like this "Stephens, ." If they do have a phone number it is, "Stephens, 544-545-5444". Is there a way to remove the comma if they do not have a phone number listed??? Below is an exact copy of that data they have typed in. They pull that data out of the database and then the pi…

Hello, This has got to be simple, and I'm embarassed to ask this; but can't figure this out. I want to create a script to create a new portal row/record. I've tried Go to Object ; but that seems to just go the portal field that I named. From there I tried Create New Record, but that just creates a new Record in the contextual table. Please any help will be much appreciated. Thank you