Script Workspace and Script Triggers

Hi everyone, I'm trying to post data to a Drupal application from FileMaker via the BaseElements plugin. I'm getting a token, setting authentication, headers, and the post variables via the BaseElements functions and I've followed examples but I'm getting the following error: {"error":"The type link relation must be specified.”} I can't find any information about what this error might be. Does anyone have any idea based on the output I've gathered below? A working cURL command that I'm basically trying to replicate that can be run from the command line is here: curl --include \ --request POST \ --user res_user:"password" \ --header 'Content-type: …

Hey all! I'm trying to get some Start Time / End Time fields working super smoothly for myself and other users. The fields are actual Time fields. I want people to be able to enter anything that resembles a 24 hour time and have it be recognised and then displayed as 24hr in this format: HH:MM So I should be able to enter 0730 and it will be recognised as 07:30AM and shown in 24hr format as this: 07:30 Or 1430 is recognised as 2:30pm and displayed as 14:30 Or indeed if someone wanted to enter it with the colon that would be recognised too (although this is less important) - so if I entered 11:30 it would be understood as 11:30AM and displ…

I'm using this to check for date clashes when booking a room. The idea is that when entering a new booking, as soon as a date is chosen in the "Date" field drop-down calendar - a script will run that has Find Matching Records [ Replace ; Date_Happening ] in it. That works, but I can only see the results if I include a View As [ Table/Form ] line - which isn't what I want. In the interest of speedy data entry, I don't want to do this checking in another form, or using another dialog box. I'd like it to just pop up a warning only if the date chosen already has something booked there. I've tried other ways using a summary field in a sub-summary, that work…

We use a DB that creates PDF reports when prompted (button that runs a script). There are 4 users of the same DB, 2 of them have no issue at all, and the other 2, when generating the PDF, the file is created (has a normal size compared to the ones created normally), but when opening pops an error message "There was an error opening this document. The root object is missing or invalid" and the file doesn't open with acrobat dc pro or acrobat dc reader (with google chrome it opens a blank page). I tried restarting the computer and the first report I create goes fine, opens normally, but when trying again the issue comes back until next computer restart. Tried reinstalling F…

I'm building a solution to allow users to access certain client records. Ultimately I will be need to do this in another FileMaker application with existing client records, but for the time being I'm working with a streamlined proof-of-concept application. Multiple users need access to the same client record, and users also need to access multiple client records. For example, User1 needs access to ClientA and ClientB; User2 needs access to ClientB and ClientC. I have attempted to do this via two additional tables: "user" and "userClient", a "UserClientIDs" value list, and a "RestrictedAccess" privilege set with custom record access. I am having trouble gett…

I have a script that builds an object that gets pasted into another application. Over the years this objet has grown in complexity to the point where its a few hundred lines. The problem I have is each time we update the object data I have to break it down line by line in filemaker with forced carriage returns and quotes inorder to preserve the formatting. Eg: { objType { ActionName{ action-item-1: test action-item-2: test2 } } becomes { objType {ActionName{action-item-1: testaction-item-2: test2}}} as soon as the script is run. Formatting seems to be preserved in the script itself but n…

From Comment's post waaaay back in 2007: Posted March 1, 2007 (edited) I don't know why you bother with the times - Filemaker will do it for you*. Just enter the search criteria as a date range: YourTable::YourStartDate & ".." & YourTable::YourEndDate BTW, it's preferable to use Set Field[] instead of Insert Calculated Result. [my formatting] ------------------------- Why is Set Field [] preferred?

I have numerous pdfs on my computer. I plan on developing a database to allow me to search for pdfs on specific topics. Is it possible to develop a script to add to a record to actually open the pdf referred to in the record?

I have a vertical market solution that requires database file names to be specific to the customer because I have multiple customers set up on a server (SBA licensing). I set up external data file naming using variables because that would save me some time when I update customer files to new version, i.e., I wouldn't have to use FM Developer tools anymore to rename them. It worked great ... until ... I tested running some of the more resource intensive scripts, some of which may have almost 100 records open and uncommitted at a time in complicated transactions. They've been setup to run as PSOS and it's worked out very well for almost 2 years now. The average time fo…

Metadata for our micrographs exports as a single .csv file that I can easily import into FM and contains two columns and about 100 rows. The column headings are something like Fieldname and Value. An abbreviated example would look something like: Fieldname Value Filename BCB6 60xz.oir BitsPerPixel 12 channelLaserDataId#01 LD405 etc. etc. I'd like to import the .csv, and rotate or transpose the table so that instead of 100 records, I end up with one record that has the following fields populated: Filename=BCB6 60xz.oir BitsPerPixel=12 channelLaserDataId#01=LD405 I already have a table generated from a trans…

What’s the name of the table? Can I access it with ExecuteSQL (like "FileMaker_Tables")? I simply would like to read its contents. When plugins can access it, maybe it can be done without? Thanks a lot for any insight! Gary

HELLO SIR I START USING FILEMAKER I AM GETTING THE SAME ERROR. I HAVE A SCRIPT WHICH FIND THE PRODUCT FROM THE LIST . I HAVE SCANNER WHICH READ THE QR CODE BUT AFTER SCAN I NEED TO PRESS SOMETHING TO MAKE THE SCRIPT WORK HOW CAN I DO IT., AFTER SCANN IT WILL RETURN THE ITEM FROM TABLE

I have reached a point in development where I can not name or rename a script. I am using Filemaker 18. I used all options. The title flashes for 1 second then i am unable to enter a name. Please assist. Thank you.

For a while, I was using several container fields to hold different PDF files, and then different scripts that would take a particular PDF from a container and attach it to an email. However, it's not working anymore and wondering if the following route would work better. We have a single PDF on a network drive (Windows). In the script, I added the path, but it doesn't want to "attach" (the email doesn't show any attachments). Wondering if I'm doing something wrong, and if you could advise on if this path looks correct. The path is: K:/Documents/Training/Answer%20Sheet%20.pdf I tried using: filewin:\\K:\Documents\Training\Answer%20Sheet%20.pdf b…

Hi all. I searched and couldn't find what I thought was the correct answer. I'm trying to have my solution successfully run a scheduled server script on the first day of each month. I have the server script running and working, now its just time to have it only run once per month on the first day. If I add the following to an "If" statement at the beginning of the script, does this look right? Get ( CurrentDate ) = Date ( Month (Get ( CurrentDate ))-1;0; Year ( Get ( CurrentDate ) ) ) Thank you in advance for you time! Chris K.

Happy holiday season, everybody. I just can't get Get(SystemPlatform) to work in WebDirect: When a user logs into a database using WebDirect, I want to steer them to a web-formatted layouts so I have in a script: If [Get(SystemPlatform) = 4] Go to Layout... blah blah blah I also tried the same instruction with quotations marks surrounding the 4, but that doesn't work either. Am I using the correct command or no? Because the same users can access the database via WebDirect or with FMP, I can't code scripts so they're taken to specific layouts based on their account names/types. (We're on v19.x in FileMaker Pro and Server.) Chee…

Hey All -- I have a search script that is working - yipee - it finds invoices within a date range and displays them I want to add an additional parameter that only displays the records found that also match what the user selects from a Picklist ie. Web Orders, Catalog Orders, Phone Orders Basically, FIND all invoices in a Date Range that were Phone Orders I can't seem for the life of me to make the additional parameter work. Does anyone have a direction they can point me in? I've attached what is working, I've removed all of the code that I can't make work - any help is greatly welcome - not sure if Modify or Omit is my best bet

Hi, I have a problem with a server side execution of the Send Mail script step and I assume it's because the certificate of the smtp server is problematic. When I use Send Mail from a local FM client, I am presented with a dialog box where I can explicitly trust the connection and afterwards the email is sent. However, running as a server side script (SSS) this is not possible: The Send Mail documentation says: "If the certificate cannot be verified in server-side scripts, […] this script step behaves as if it had been canceled by the user." I asume that this is the problem. Is there a possibility to connect anyway in a SSS? Or is there another workaround? …

OK...I'm having a complete brain freeze on this so let me try to explain (in detail) what I'm looking for. First off, I'm working in FMP11 (I know...don't ask). What I'm trying to accomplish: To display a single or series of records in a portal in one table based on a text field and a checkbox field on that table. The records are created on another table. The Setup: 1. I created a single database with two layouts, each having their own table. 2. In one table, I have it labled as "List" where I have roughly 10K+ records. 3. The "List" table has four text field. 3a. Chemical (Standard text field) 3b. Material (Standard text field) 3c. Rat…

The title of my post says it all. Well, almost! You will need to know that each set of found results get appended to the initial pdf using a different layout. I already have a script that is successfully creating a pdf and populating it with data from a search result using one layout, then performing the same function three more times, appending to that existing pdf using a different layout each time. In the event that the data from one search doesn't fill up the last page, there is blank space. I am wondering if there is any way I can do either of the following: 1) Somehow trim the blank space at the end of the last page of each set of results/layout so that the nex…

Seems a simple enough question, but cant see how to do it: where do I place a script that I want to run only when the database is initially opened - say, goto layout x, last record and verify integrity of database. So while User switches from one layout to another, when they come back to layout x, this script does NOT run again. Environment: Windows 10, Filemaker 16 TIA for any suggestions.

Good morning gang! It's been a LONG time since I've made mods to my database. But now, due to a change in the way the data comes in from the source, we have an issue that's making things very slow in the data entry group. Essentially, we have 2 lines of data in a field, but only need the first line of data (address number, street - ie "123 Anywhere St"), and we need that data copied to two other fields, the address number field and the street field. Here's the field we need to copy the num and street from: And here's the fields we need the NUM and STREET copied to: Now, like I said, it's been a VERY long time since I wrote this database…

Hello, I have a list of data, extracting/looping from Webviewer to a portal. I would like to sum last 400 record on every new record created. through portal it slow down too much so I try to integrate a script step to get list and sum previous 400 records the fast I found is "GetFieldList ( fieldName ; recordNumStart ; recordNumEnd )" it work perfectly on the layout of the table, but it doesn't work on a portal & table where the Webviewer is located. Is there anyway to get it work with the portal or other way to sum 400 previous record out of a portal ? thank you

I have a text field called “Events”. Some of its values are as follows: I’d like to write a script that will find all the records for which any of the values Alice_Austen_House_20?? appear and then do the following: 1) Insert the text “Alice_Austen_House” into the Events field 2) Delete all the text Alice_Austen_House_20?? from the Events field Here is the start of my script, intended to find the relevant records and then insert “Alice_Austen_House” into the Events field: Here are the details of the first step of the script: The first step correctly finds the relevant records, but then I see this error message: I’m puz…

Hello! I need help with a script with looping to evaluate and mark records. I have four fields: Name_Global, NameA, NameB and Tag. I want to have a result in a field: Tag that is true when either NameA or NameB is a match with Name_Global, but not when that same condition is in the following record(s). The first record does not need to be evaluated. Scenario: If the match is true for NameA, for example, in records 1 through 5, then no true result is needed. Records 6 through 10 is a match for NameB, so then record 6 Tag is true, but not records 7 to 10. Carrying on, records 11 through 15 is again a match with NameA so the Tag for record 11 is true, but not the r…

Hello, I am trying to create a kiosk solution (FM PRO), having a video in background and a press here button to start it. Can someone tell me if there is a solution to implement this: How to loop container mp4 ? Thanks for your comments and support

I have a few hyperlinks defined in my solution to allow for the direct access to folders & files in macOS. I have a mixed environment, with a few Windows machines and would like to also the same functionality for those clients. Here is my current script: Set Variable [$hyperlink; Value: "file:///Volumes/MISC/• MISC System Documentation/Documents/"] Open URL [With dialog:Off ; $hyperlink] Is there a similar command that might work within Windows?

Hello, I am trying to run a script when the user "exit the tab control object" but nothing happens. Does OnObjectExit or OnObjectEnter works with tab control ? Thanks for your replies

Hello, According to Filemaker.com Enable Touch Keyboard is Partial supported by Filemaker PRO. I am using Windows 10, and all my testes are NO or I can't figure out how to do it. Anyone tried it and is able to used it? Thanks for your comments

Good Afternoon, I have a table with 8 users in the table and a separate main table with all of my customer files. Currently each file is assigned to one of 4 users (I recently hire 4 new agents) I am looking to create a script that 1. Finds out how many current users there are. 2. Then takes the number of users 8, divided by total customer files (say 800) and evenly assigns the files to each agent. IE it balances out each agents workload to make sure each user has 100 accounts. Is there a function built in to do this in Filemaker? Thank you all in advance,

Morning all; As usual seeking the valuable input from the group. I have a script that is executed by a button that time stamps two fields and one field that sets a values the flag "Yes". Field: DateRecordReadyForInvoicing Field: TimeRecordReadyForInvoicing Field: FalgRecordReadyForInvoicing, set field to "Yes." Then I have a button that prints the records with a flag value of "Yes." My challenge comes in, in clearing the "yes" from the flag field, I am using the following script but don't seem to be abl to get it to work. Perform Find "Yes" Loop Exit Loop if flag value is "empty" Clear "Flag" Field End l…

Hello! I have written scripts to download when the button is clicked that it will download the file associated with that button. HOWEVER, is there a simple way to write a script to simple download the file associated with a button pushed, instead of writing a script for each button, will be over 50!!! A user can only click on button at a time, and each button has its own container field. I put a screen shot of the menu they will see, and a copy of the script I am using per button. Could I just have a general script to start once the button is pushed to get the name of the button and then download that file associated with it????? Thanks a million!!!

I have a text field that contains an essay. I need to parse each of the essay's paragraphs into separate records in a different table. The paragraphs are delimited by double line feeds. If I copy the essay into BBEdit, I can identify and select each of the paragraphs by running the expression \r\r.+ But I have no idea how to accomplish something similar in FileMaker. Can someone help? Thanks.

howdy all, need ideas on best practice for archiving and purging a database I have a database with 10 tables all with relationships, and approximately 40K recorded I would like to have a script (or plugin) that would allow me to move data older than 1 year to an identical database and then delete the found set from the master. I tried using the export import but can't figure out how to move all relevant records including the once from the relation. Any help or ideas would be greatly appreciated. Thanks Rudy

Hello Is there anyway or plugin to know which scripts are not being used in the layouts? similarly, for unused fields? for clean up purposes. Thanks

Hello World 😃 ! Its just great to be here! Here’s a good one for all you Pros out there; I program Filemaker since 30 years and this one is such a gem, it gave me a few great sleepless nights. Maybe you guys can come up with a better solution or idea. We want to create records in a simple flat database for different kinds of items (whooohooo! Easy so far!). Any item we put in is either in Group1, Group2 or Group3 and so on. Lots of people will enter items, each Item has its own group. Each Group should be numbered sequentially. For example, when a person wants to create a record, first I ask him for which group. The person chooses…

Hello Forum, Im writing a script for my locally hosted FM Database that will manipulate quite a few records in the database. Basically when a user changes the name of an item to something they type in, I must go into several tables to change other values depending on what was typed in accordingly. In a nutshell I must enter 2-3 tables, do a find, modifiy the records and then do the same on the next table and so on. All that is no problem. The question I have is this: How can I make this procedure, "indivisible"? What I aim to achieve is that while this routine is running, noone will interfere with it. If another user changes the name of the item at aro…

Hi. I wanted to share this routine I programmed in order to close my Filemaker database files every workday around 6pm. This script only runs on my Win10 machine at work and then I have a separate script that runs on macOS at home to close the file there. The reason I needed this is during the pandemic I worked a lot more at home and sometimes I would accidentally leave the database open at one location and then open it at the other location. Then OneDrive, where the databases reside in the cloud, would create a different iteration of the file because it can't resolve the differences in FileMaker databases. Hard closing FileMaker via the Windows Task Scheduler was what I …

I can't get the Send Event with calculation to work as I want. Send Event ["aevt"; "odoc"; "cmd.exe " & "c:/mytopdir/mydir/myscript.vbs " & $myvar] opens the cmd window to "C:\Program Files (x86)\FileMaker\FileMaker Pro 9\Extensions\xDBC Support\logging" and stops. How can I get it to execute the script with the open arg? Is it possible? Dozens of views, but no replies. Is this something that is even possible to do?

Greets, all: I'm looking to incorporate vCard creation into an FMP solution I'm working on, but the scripts I've found on the Web harken back to FMP v13* and earlier (before Base64 encoding) and they're a bit unwieldy to work with. Does anybody have, or can point me to, a script or custom function that'll create Vcards that's more recent/elegant? Thanks, Rich *https://hbase.net/2014/10/22/exporting-vcards-from-filemaker-pro-13/. I'm probably being dense, but I don't see where the Virtual List Utility table is (as mentioned in the artile.)

I recently built a new pc, purchased a high end monitor and installed FM 19. Suddenly my opening layout is 1/4 the size of the screen and I'll be darned if I cannot figure out how to have my Opening Script resize the opening layout automatically to fit the screen or at least be 3 times larger than it opens now. Yes, I'm sure it's a simple fix but I'm not seeing it. I'm tired of holding down CTRL and scrolling the mouse wheel to size it up. Any help will sincerely be appreciated. Please help. Thank you.

I am not very good at calculations. I want to create an invoice number from the date i.e. (210603) and a sequential 2 digit number. I have been using this forever but I would really like to have it automated. An example would be 21060321. Then I will need to add a if then script to start that as of today's date and leave all old invoice numbers alone. Anyone done this before. I know it is probably pretty simple. But not for me.

I am having difficulty with coming up with a script that numbers the sections of courses based on the teacher assigned. I need multiple sections of a course taught by a single teacher to have the same number, and each single section to have a unique number. For example: Math Grade 6 has 4 sections Math 6 assigned to Teacher X Math 6 assigned to Teacher X Math 6 assigned to Teacher Y Math 6 assigned to Teacher Z I want those sections to be numbered as follows Math 6 assigned to Teacher X, numbered 1 Math 6 assigned to Teacher X, numbered 1 Math 6 assigned to Teacher Y, numbered 2 Math 6 assigned to Teacher Z, numb…

Hi! Hope that someone can shed some light on the following issue: I have two checkboxes from the same table. First one is a text field with Auto-enter calculation which says if Checkbox 2 contains certain value, Checkbox 1 should be empty/unchecked: Case ( Checkbox 2= " EXPELLED"; ""). It works fine. However if I decide to override Auto-enter calculation, meaning having both Checkboxes checked and then uncheck Checkbox 2 making it empty, Checkbox 1 gets also unchecked although Checkbox 2 in fact does not contain value "Expelled" defined in the calculation. What am I missing? Any help is appreciated!

Good evening. I have been sending email using Office 365 for some time now and it has worked fine. On this particular client, MFA has been enabled - and rightly so for security reasons. However, email from FM (through O365) has stopped working. Now, I have been reading up and seen that we now use the MX name of your O365 tenancy as the SMTP server, port 587, TLS, plain password etc, yet this has not worked. I think I have tried most combinations - including "smtp.office365.com, port 25, no encryption etc. I have also created an "app password" for the account I wish to send from but this doesn't work either. Whilst MFA is not new to O365, has anybody had luck…

I use scripts with the "Open URL" hyperlink function to open files and folders in MacOS X. I'd like to extend this functionality to Windows versions of FM. Here is an example Script: Set Variable [$hyperlink; Value: "file:///Volumes/MISC/Manufacturing/Packaging/"] Open URL [ with dialog: off; $hyperlink] Works great in OS X, but I'm, not sure the function to use for windows?

Hi, Im having a play with fm pro on a friends pc for my mowing business, its really good as i can customise it how i want. My scenario is. I have multiple customers that have regular bookings like every 2 weeks. When i add a new job i would like to before commit select a "Frequency" and "FrequencyRepeat" So when i add newjob , i would fill in the details and mowing date then select every 2 weeks and repeat 20 times, then hit create order, this will then save this order and copy the same order but with the new order number and also the right dates. Im hoping this is possible as at some point i want to have this sync to google calendar too but t…

SHORT VERSION: I'm looking for a good way to go to a record based on a variable $flaggedRecordID initially set from the value of an active field (it's calc is: "Get (RecordID)", but where that field is no longer active (i.e., we're parked on a different record). DESIRED OUTCOME OF THE *ENTIRE* SCRIPT: Create a set of records (4, in this case) duplicated from template records, where the duplicates are modified ("DATE" replaced with today's date; this part is working). Then the user does some work with the records. DETAILS: I derive a found set (based on some text criteria in a field, and a field 'template' that is checked). I run a loop (see * at the en…

I have the following problem, I don't know how to make this specific script work properly. Sorry if it is in spanish since it was made for spanish speakers in mind I have four tables, Factura, Detalle_Factura, Presupuesto y Detalle_Presupuesto The relationship of these tables is like this This is the layout in which I am trying to run the script. The portal below has the data from Detalle_Presupuesto and I need to pass that data from the portal to Detalle_Factura This is the script I am trying to use but it only copies the first row of the portal row, I tried to do a loop too but it runs forever too This is the layout I am trying to …

Hi All, I have simple layout with a value list. This is a conditional value list that is changed based on a selection in the preceding field. I basically want to create a simple "Next" button to go to the next value in a Value List and I can't think of a way to do this. I am playing with GetValue and ValueListItems but can't find a way to assess the current value of the field and then add a +1 to go to the next value. Any guidance would be greatly appreciated.

I'm revising a solution that has been with me since FileMaker 5 Pro, imaginary tables below( the real one is about refining lumber ) however I expect more people to have relations with doctors and taking blood samples from a patient perspective. Let's say we have a table with all the options for testing blood. Selections from these are ordered by groups in 2 separate tables, one for groups and one for the members of those groups. Now when ordering a blood sample, let's say that doctor expects the patient to have a given type of cancer( or the architect to pick lumber for an arch, ) this will trigger an export as FMPXMLRESULT of the group member primary keys to Get( Tempor…

I am working on an age-old FM-solution, consisting of 60+ files, each file with 1 table, all files linked together. On start-up, the solution opens most of these files and shows some of the respective windows. Now, a client would like to be able to control the behavior (look) of these windows on start-up. In the main "dashboard" file, I am trying to write a script to go to each relevant window (Select Window) and manipulate it (Adjust Window). However, when I run the script, the focus remains on the file the script is running from. After "Select Window", any further "Adjust Window" script steps are applied to the main file the script is running from. …

I'm really struggling how to run .command file with passing parameter. My FM version is FileMaker 18 and MacOS(Mojave). What I have tried is running Perform AppleScript, in its calculation part I coded this "do shell script \"/Users/admin/Desktop/OrderBook.command PARAMETER\"" If I run this script, it keeps saying this error message /Users/admin/Desktop/OrderBook.command: line 1: OrderBook.csv: Permission denied Is there anyway to solve this? For your information, in my situation, I wanted to run command directly within PerformAppleScript but I gave up because it was really hard to solve syntax error with that. …

Hello! I'm trying to properly script importing a daily database into a master database. Everything in the script I have currently works just fine, except for the import step. I want to: arrange by matching names update matching records in found set add remaining data as new records and I want to set my matching field to the UUID in my database. dialog off I've found that when importing via script, filemaker doesn't really let you do "matching names" and set the matching field. I've resorted to setting the script to use Last Order and manually importing a sample file before I do a batch of imports via script. Kind of a pain, and…

Hi All, I'd like to use FileMaker to manage a Contracts file I've been keeping in a spreadsheet. It has become a monster. I also use the data to determine what our annual budget will be which includes estimated annual increases when the contract is set to renew. Accounting rules come into play depending on the start date of the contract and how that will be allocated monthly over the duration of the contract. I know FileMaker can handle this but the scripting is beyond me. I envision a script button that allows the creation of records in a separate table that auto calculates the monthly allocation like the one shown in the spreadsheet attached. The 2 scenar…

I am using the attached file to calculate amortization table for clients. However, there is a glitch in the app somewhere that does not allow the balance to be visible to the calculations in the loop. If I enter a loan for any amount and set the term to 30 years, at payment number 161 the balance is no longer visible or usable which creates problems for the following payment schedule. At payment 161 I can click in the field and it appears the correct balance is there, but it cannot be seen when I leave the field or used in calculations... This is a file I found here on the forum in a 2014 discussion... So I am looking for help to debug it.... Anny help will be …

Sometime in the recent past, certainly since FM 19, the little checkbox on the far left of the script pane has gone away and I can no longer select scripts to appear in the drop down from the menu bar. Instead, they all seem to appear. It's a puzzlement.

Hi people! I have a field which validation is set to Always, Allow user to override during data entry unchecked, unique value, custom message checked. When validation fails the message box offers two options: revert record and OK. Is there a way to trigger particular script if I choose OK? or is there a way to get the message with only one option (revert record) to choose? Much obliged!

Hi, I am working on a script, which finds a list of records, but I then want to omit just any duplicate records based a field being the same, but staying in the found set Is this possible?

Hello, I hope this is a simple question: Is there a reverse of the "Quote()" function, that would turn a calculated AppleScript in FM back to a straight AppleScript? I have a very complex calculated AppleScript that I need to retest. Thanks.

Greetings, I have two tables: Home Products (several types of products some of which are also sold as commercial products), and commercial Products (again several types of products and again some of which are also sold as home products). Each table has a summary field that totals the amounts of sales. I’ve created a layout based on a dashboard table, and I want a portal on this layout to display combined totals by types of products, whether they are home or commercial. So what setup is required to display each type of products (like blinds) only once, and the total amount of sales for that type, so that the end result looks like this: Blinds…

Hello, I have a database that I run on 3 different computers, all with Mac OS 11.2. FMpro is 18.0.3.317. A script uses an AppleScript that opens a browser. The AppleScript invokes System Events and contains a "do shell script" step. On all computers, FMPro, Script Editor Script Menu are "allowed to control computer" in System Prefs. In the other 2 computes, with the Intel chips, the script runs flawlessly but it stumbles on the M1. M1 vs Intel is the only difference between there 3 setups. I know that v18 is not officially supported with Big Sur but the programs runs perfectly well. Any suggestions would be appreciated.

Hello, This is likely answered before, but I can not find it. Probably I don't know the correct Filemaker terminology to search on. I have used "indirect" fucntions in other systems, but that does not seem to be correct here. My attempt to describe the goal: Set Variable [$ColName; "FirstName"] Set Field [Customers::FirstName; SourceTable::$ColName] In this case I would like, in the last step above, $ColName to be evaluated in such a way the value assigned to the field Customers::FirstName is the value in the field "SourceTable:FirstName." The above is the nut of my inabilty. In this case I have eliminated a few nested loops etc. If it was just t…

Hi All, I was wondering if any of your Filemaker gurus would have the answer to this one. I have some records where the input is something like this… <chapter-marker start="31031/6000s" duration="1001/30000s" value=“TEXT” posterOffset="11/30s"/> <chapter-marker start="31031/6000s" duration="1001/30000s" value=“TEXT WITH 4 WORDS” posterOffset="11/30s"/> And I would like a calculated field that would extract just the TEXT within the quotes. That Text could be 1, 2, 3, or more words. Any ideas?

Hi I have a script that duplicates everything in a record into a new one. It copies everything over, including three of the portals (character, featured and SPACT), but will not copy over the specialist portal. It copies it and sticks it listed in the character portal field but also gives it a 0. the specialist portal is one I have added on and I thought I had added all the correct info into the script. The script is called duplicate scene. and the info I added in was: line 8 in the specified export order so all the same field options for specialists were the same as featured and military (which is the PSACT portal) then …

Greets, all: I put this post here (in Scripts) because I believe there's a scripting issue, more than a calculation issue, going on here so I hope you don't mind. I'm trying to learn how to use the GetField command and in the example file on FileMaker's website, it givesthis one: https://fmhelp.filemaker.com/help/17/fmp/en/index.html#page/FMP_Help%2Fgetfield.html%23 . I replicated the script in the attached file and for the life of me, I can't get it to work--it's trying to sort what's in the SortKey field, not the values in the data fields, i.e., If you enter CustomerName in the SortSelection field, it's calculated to CustomerName in the SortKey field...but whe…

I have a script that when run opens the mail client with a order confirmation email to the customer and confirms the order in FileMaker. But is there a way to check if the user actually pressed send on the email before confirming the order in FileMaker?

Hi Folks, New here and new to FM, but I'm making some good headway.. I've made my way into accessing stock quotes via one of the brokers API's and been successful parsing out the response for a straight stock quote. I'm now on to options quotes, which has a more complex json response... I've tried using generator and generator seems to stuck as well with a "?" in the field mapping for a key portion of the response. Here's the complete body: { "underlying": { "symbol": "KO", "bidSize": 700, "bid": 52.5, "close": 54.84, "mark": 52.51, "quoteTime": 1609787762126, "fiftyTwoWeekLow": 36.27, "description": "Coca-Cola Company (The) Co…

Hello I have a dilema whuch I have been trying to work out I have hunted for a solution but with no Joy. I have a table for Contacts and a Table for Companies which is joined via a relationship. I have been trying to create a script that if the Contact does not belong to a company then the project in the Contacts Name or if the Contact belongs to a Company then Create the project with the Company name. I have tried with else and els if but with no joy. As anyone have a script for this to work for me. Thank You

Hi I have a 5 000 record with url to check on web viewer (loop > open url in web viewer ... check source code, go next) After 400+/- records it s slow down and in the end not respond at all. I went to check monitor activity and I see 30Go. If I close the file it s keeps the 30go and keep slowing whole Mac, but if I quite filemaker and open again it s worlds well until 400 more records ... anyone had to deal with such issus ?

Good morning, everyone! I have a milti-line field that I use to drop in a name and address, which I then have to parse out to other fields. I've attached an example photo of the multi line field, and the other fields to which I need to add the data. My question is - how can I use the text functions to "grab" the key data (such as the 2nd "address" line, the third "zip code" line, etc) separately, since we have the multi-line data issue? What would be the most efficient way to accomplish this? Thank you in advance.

Hi, We are importing data from CSV into a list of Certifications into a single table The data consists of Company name, Certification Type, Company Sector, Company Size, Town and some other fields. The data we get from another system is quite messy and requires a lot of work to make it presentable, but consistant enough for me to create a Clean up script to Set the fields as wanted. This all works great. The issue I have is when the Certification type is 'Type2" the data we get from the other system does not have the Company Sector, Company size or Town. So currently someone is manually copying these fields from the matching "Type1". (you can't do 'Typ…

Hi all, as per mentioned that I would like to add password in my script to allow if the password is correct allow to progrss to send SMS unless give him message the password is not correct. please find below my script:)

Hi, I have a script that sends an email to the current found set of contacts, each contact has a relationship to the company. When I perform the script it also adds an interaction to the Company interaction related to that contact. But even though the correct emails are being sent, it is only adding the interaction to the company of first contact in the found set it is emailing, and not the rest. I have attached pic of the last bit of the script that does the interaction part

In my database I've got a table that functions as a join table. Due to the nature of the data, I've got to create the records here manually - or at least with a script. There needs to be a set of records for each employee that contains their ID number and all possible dates of a given year. The workflow happens like this: An administrator navigates to the layout They enter an employee id number and the desired year into respective global fields: GLOBAL_AddYear and GLOBAL_AddEmployee A button is pressed and then the script runs to create a year's worth of records for the selected employee This is my script, which - as far as I can tell - does what…

Hello Forum, At our medical consultancy, we use FM to store pacients information. Different pdf documents are created and placed in a portal. When a document is created on the IPAD, I have a script that place that document in a field and it works OK. But when a new document is created for the same pacient, with the actual script, it will erase the old document and place the new document in the same field in the first row of the portal. I would like the script to create a new record in the portal and place the new pdf document just below the others. Can you help? https://cloud.edwin.es/index.php/s/2w58S5sEemcx7at Sorry, I didn't find a better w…

When I opt into having the user change their password on next log-in through the security pane, FM allows an empty value - basically the user enters nothing and just clicks OK. As I watch the script ... there is no error? I see the value of not using or having an Account Name and or Password but ... I can not allow a user on this file to just click through the FM's message box when prompted to change their password. I'm I missing something here ? Any suggestions ? Thanks.

as mentioned on the topic. I created script triggers in case exceed the specified date if the user normal will give him a message and exit application. I need someone to help me to improve my script or advice me.

Hello and thank you peeking at my question... I can not seem to get my scripts to behave in a way that is expected, driving me batty! OBJECTIVE :: Fix Popover Open button so that when clicked popover opens, and when clicked again the popover closes. CURRENT ERROR :: At the moment when Popover button is clicked the popover opens, and then just reopens when clicked again, which is not the desired behavior. NOTES :: To help illustrate my issue, I've attached some files. THANK YOU kindly for your time and help! 🤠 sample_popover_open_close.fmp12 I've been able to get the highlight open/close to work outside of this demo file. But NOT when I have a "clea…

Hi everyone, I've been using Filemaker for quite sometime, but I'm somewhat unexperienced when it comes to scripting. Imagine you have 3 fields, the first two use value lists. I'm struggling to create a script that will create a code with an incorporated counter on the third field. I exemplify: Imagine that in the first field, I have the following options: Orange (OR) Apple (AP) In the second, I have the following options: Red (RD) Blue (BL) If I chose Orange and Blue, i want that the third field should appear as OR-BL-001 (separated by an hyphen). Each time I choose the same combination of options, the field contents sh…

I know you can disable script steps but is there any way you can disable an entire script? I have some templated solutions that came with FM and just want to turn some off until I have the time to modify them to my needs.

I've got this to skip existing records when parsing incoming JSON.. If [ not IsEmpty( $screenshots ) ] Set Field [ Moby_Games_Importer::JSON_VariableView0 ; $screenshots ] Set Variable [ $PLATFORM_ID ; Value: "5" ] Set Variable [ $MOBY_ID ; Value: Moby_Games_Importer::Game_ID ] Set Variable [ $n ; Value: ValueCount ( JSONListKeys ( $screenshots ; "" ) ) ] Freeze Window Go to Layout [ “Moby_Screenshots_Meta” (Moby_Screenshots_Meta) ; Animation: None ] Set Variable [ $existingIDs ; Value: ExecuteSQL ( "SELECT Caption FROM Moby_Screenshots_Meta" ; "" ; "" ) ] Loop Set Variable [ $i ; Value: $i + 1 ] Exit Loop If [ $i > $n ] Set Variable [ $rec…

Hi, I have the following script step that works just fine, locally: Insert File [ Target: g::tmpc ; "$URL" ] g::tmpc is a global container field (that is deleted after the file (a pdf) is inserted. $URL contains something like "file://Macintosh HD/var/folders/m4/91h3r7mn2h71j7vmyzv4z7nm0000gp/T/S6847/File.pdf" (using the tempFolder functionality). When this is running on my FM Server 17 (script is called with PSoS) it just doesn’t fill the container field! It is very tedious to debug script steps on the server, but anyway I manage to check the Length ( g::tmpc ) after the insert and it is always 0. I also check the $URL and the existence of the file …

Hello, I have been building a inspection checklist solution and to reduce the tedious task of checking a radio set multiple times, I wanted to create a button that will auto populate my "Pass" checkmark field based on a "sample size" field. What goes on during my script is that the first instance in which I test this, it works perfectly. Once I continue to make more records it will only check 1 box and continue to do so as I push the button until there is an added digit change, then it will populate the correct quantity of "pass" check marks. example: If my sample size is 32, then it will put one check mark each time i push the button until i reach the 1…

I'm using Write To Data File script step to keep track of the outcomes of batch transactions in a text file. It's basically a log that users can view to see line-by-line what happened when they ran a batch process (which records succeeded, failed, queued for retry, etc.). Entries into this log have a lot of value to users in the short term, but have little to no value to them as they age. I'd like to purge the oldest entries (at the beginning/top of the file) when the file reaches a certain size. For example, if I want the max file size to be 128K and the new entries make it 130K I'd like to remove the oldest 2K of text in the file at a ¶ or line feed (so I'm on…

I have a script that runs via record creation with MBS. The script opens a new window in the main database and performs actions based on an incoming call. At times the new window opens but the main window gets/remains selected and that's where the action happens. It's 1 out of 4-5 times when this happens. I tried it with the same exact action, same result, it'll fire perfectly a few times, then in the wrong window. Any ideas?

I have been away from FMP for quite awhile, and have forgotten a LOT. I need a script (using a script trigger) that upon field entry will enter an 1 if the field is empty, or a blank if the field is valid. Thanks in advance

Can some kind person please give me a script that will: (1) place a Text field on the current layout, with location and size taken from 4 fields (x_origin, y_origin,width,height) (2) insert into that field the contents of a Text field called 'this_text' formatted with font, size, color, alignment taken from 4 other fields (fontname, fontsize, fontcolor, alignment) Thanks you. Philip Caplan

I have a client who would like his database to automatically generate a certain report every Monday morning. I thought there was a script step that could achieve this sort of thing but now I'm not so sure. I guess Filemaker isn't constantly checking the time after all, right? I suppose I could have a start-up script that checks the day / time when the file is opened and produces the report under certain conditions . . . but if the file is just left open, there's no way to trigger a script to fire at a certain time every week? Essentially, the client wishes to have certain information "pushed" at him at the beginning of each week so he doesn't have to remember t…

I have a field named "Databases" with the following values: "CORD", "SDHS", "Y Ballet". This field is displayed as a checkbox set. I recently learned that "CORD" should have been "DSA", so I naively changed "CORD" to "DSA" in the value list but then none of the records that were checked for "CORD" were checked for "DSA", which reminded me that the values in the value list are the values of the field Databases and not labels for checkboxes. I revised the value list to again include "CORD" and its checkbox is again checked for all the records for which it was originally checked. I wrote a script, shown in one of the attachments, to insert "DSA" into the Databases field…

I have FilemakerPro 16, and I would like a script that does the following: (1) opens a textfile on my computer, if it exists (or create it if it doesn't exist) (2) writes the content of a field at the end of the file (ie, as a new final line) (3) closes the textfile Is that possible without a plugin? If not, is there a cheap or free plugin that will enable this?

I am sure this is going to seem like a very stupid question, but..... I need to write a script that (1) goes to a particular field (2) removes any content in that field (3) replaces it with a single letter "y" Can some kind person please tell me the script steps to achieve this, as I cannot seem to figure it out for myself.

I'm trying to use an API command using Insert from URL with cURL options, this is what I have in the cURL options: curl -v -u <user>:<password> --header "Content-Type: application/json" -d '{"type": "typetest", "priority": 1, "description": "desctest", "subject": "subjecttest", "email": "[email protected]", "email_config_id":67 }' -X POST 'https://subdomain.freshdesk.com/api/v2/tickets/outbound_email' As described in the API documentation: https://developer.freshdesk.com/api/#create_outbound_email The command works well in the command line but not when executed through Insert from URL, do you know why? is there an error I can't spot? Thank you,

For years - at least fm 12 and most recently through fm 15 - I have used the script step 'send mail' successfully to send email through a gmail account. I have done that successfully as well with the base elements script steps BE_SMTPServer and BE_SMTPSend. Sending mail through gmail has recently stopped working in several different solutions that use these routines. Other, non-gmail accounts, continue to work so something seems to have changed with the way gmail handles requests from a Filemaker solution. I have verified the SMTP settings in the solutions against the settings specified on various web-sites that specify the gmail SMTP settings. I recently upgr…

I'm customizing the pre-designed Estimates database from Filemaker for a client and trying to modify the existing print script to add the current date to a field so they know when it was printed. When on a layout called PO Details, there are static infos there and there is a portal for multiple line items. Clicking on the Print PO button triggers a script that I'm trying to insert "Current Date" into a field AND open up a layout in a new window designed specifically for printing so that I can print the PO. The problem is that the print preview window that pops up shows every line item from all records (related and unrelated to the PO I am trying to print) rath…

I'm hoping to create a basic slideshow database that displays images of paintings and basic text data beside it such as title, author, dimensions etc. There will be about 150 images and I just want to import the text data from a spreadsheet and match the images via a unique filename as the match import ID from the spreadsheet. I'm using FMPro 15 and will use the Content Management example file that came with the app installation as that's loosely the look I want. How do I create a 'run slideshow' script that loops through all the records with a time pause of say 5 secs for each record? I found this on another post but it looks like it loops images from a portal?…

In a script, I execute a loop to compute a text string consisting of a comma-separated list of email addresses, which will be used outside of FM to send an email. The string is stored in a local variable, $EmailAddressString. When the string is fully computed, I set a global field to $EmailAddressString, and then I execute the script step Copy with target set to that global field. However, the string doesn't get copied to the clipboard. Instead, the Copy command produces Error 102: Field is missing. But the global field does contain the proper text string. Is there a restriction on Copy—i.e., one cannot Copy from a global field? If so, do I need to create a separate …

In FM18, I have two tables: "documents" and "recipients". The "documents" table has (among others) the "owner" attribute, while the "recipients" has the attributes "department" and "emailAddress". I'm working on a script that sends an email message to all the email addresses included in the records having recipients::department = documents::owner. The script is executed when clicking on a button in a layout related to the "documents" table. In the "send email" option form, I have selected "Collect addresses across found set" but now, what should I put in the calculation? Below you can find some script (they are in Italian) and th…

Hello, I have this applescript who is working well: do shell script "curl \"http://127.0.0.1:4490/action.html?macro=4A91C4B8*nome file.jpg\"" Since I should replace “nome file.jpg” with a Filemaker field value, I modified it to be a Calculated Applescript like this: "do shell script \"curl \"http://127.0.0.1:4490/action.html?macro=4A91C4B8*" & OrderLines::CustomerFileName & "\"\""" But this script always report me an error about “”” I guess there is some syntax error but I don’t see where. Anyone can help me to understand the logic and correct the syntax?

If I want to create a new record during a script, I need to select the layout that is associated with that desired table.. (Freeze Window.. create new record .. in the background) .. But if I just want to set fields in a particular table (set field Table::Field), If I do not change the layout, will those changes always be on the same / last record accessed on the non-visible table?