Script Workspace and Script Triggers

Hi, I need to enter into a certain field, certain data - primary key data from my pdf table. The only issue is, is that someone is on the record on another table were I need to enter this data and as the script step through this step ( set field ... ) I get an error "Record being used". This primary key value from the pdf table must write to this field ( fk_pdf_ID ) on this other table ... is there anyway I can either force commit the record the user is on if I see the error ( record being used ) so the script can enter the data, or force write this data into this fields on this record that is being used by someother user but in the background without commiting …

so i have 2 tables, A & B, & 2 layout, C & D. in layout C which contains fields from table A & B. is it possible to only create new record for the fields from table B in layout C that will also trigger new record in fields in layout D? i'm sorry if its a bit confusing, idk how to explain

Hello, I am not sure what I am doing wrong but I am trying to take a layout and save it as a PDF to a container field on the same layout. I keep getting this error that the "file cannot be found". If you wouldn't mind taking a look at the structure of the script and letting me know if you see anything wrong? Thank you in advance. Chris.

Good afternoon, I am trying to create a script that performs a find, gets the found count number. Let's say 20 records are found. And then performs a loop through each record, gathering the data from 3 fields and setting variables, IE record 1 effective date field, variable $effdate1, record 2 $effdate2, etc and then puts all of this information into a body of an email. I'm trying to list out all 20 of these records line by line in an email with the 3 fields of data. Example: Record 1: Field 1, Field 2, Field 3 Record 2: Field 1, Field 2, Field 3. What is the best script or function to list out all the variables, when the number of variable…

Good day gurus, need some advice or samples is at all possible. I have a layout with a portal, i also have two global fields (g_job_status_navigator and g_status_navigator), both are drop down with the value list test to the field content. I need some guide on a script that would allow me to make a selection from the either or both of the global fields and display the result in the portal. Any help is greatly appreciated Thanks.

I have a simple problem, I hope 😉 . I have a table that I created that shows 5 different possibilities. I have a drop down list in a table that users will pick, and it will take their choice and fill in two paragraphs with the data they chose. The problem is when they type to edit those paragraphs, it also changes the main data from the list. I want the drop down list to simply COPY the choice they chose into the boxes. What am I doing wrong????? Please help!! 🙂

I am commencing a massive re-write of the database we use to run our cabinet shop. This database involves a lot of fields and a lot of scripts. Much of the database is managed on a desktop computer but lots of the information is passed to an iPad through Filemaker Go. I want to make the scripts as efficient as possible. Many of them now require too many round trips to the server. I am hoping to do this with a SET FIELD script. I am trying to develop a script that collects data from the current record of one table and posts it into a new record on another table. This works fine if I move back and forth between layouts using copy & paste. When I try to …

I'm looking for a script that will create a record for each Sunday in any given year, but I can't figure it out.

Occasionally , when I try to delete a script I get the error "This script cannot be modified in this window because it is being modified elsewhere" . What's causing this and how can I stop it? No other script refers to the script.

Hello, I have a dozen fire departments that manage attendance records (related to an event) and they enter them by barcode scanning or manually selecting their name (ID) from a dropdown and clicking an Add button. I have been asked a few times for them to be able to add all members to the event attendance portal. I'm not too sure how to approach this. The members and their ID's live in the Personnel Record Table, The attendance records are created in the Attendance Table when someone is checked in. What is a good way for me to capture all the firefighters ID's in the personnel records table (or loop through the records) and then create new attendance rec…

The FileMaker 16 and 17 manual state very clearly: "Wait for event completion before continuing tells FileMaker Pro Advanced to wait until the event is finished before continuing. If you don't want to wait until the event is completed, deselect this option." https://fmhelp.filemaker.com/help/17/fmp/en/index.html#page/FMP_Help/send-event.html But I don't have that option in the script workplace? This is FMv16 on Win7x64 Is this only on Mac? The help does not state that.

It’s not as easy as: PatternCount ( Get ( ApplicationVersion ) ; "Server" ) Anyone know how I can determine if the FM application (FMP or FMPA, not Server) that a script is running on is the client or the server application? When using a remote database that is hosted on a FM application (not FMS), speed is very often an issue. So I need to determine if a script is executed locally on a FM application that is acting as the server (fast) or if the script is running on a client FM application accessing a remote database (slow). I would need to Exit the Script in the latter case. Checking the computer name (how can you do that?) would probably work, but is…

Can I adjust the Save Copy as PDF step to include the Title on the layout? For example, "Account List 2019". I frequently create lists for other years and would like to show the year in the pdf. Not just "Account list".

Hi, i'm new here and noobs on FM Just a few weeks of practice and learning so far. Ok, my problem : From Table A, i want to target a record based on a specific value $name, find the matching record containing that value in table B, then delete that record and come back to A. I can successfully create a record from Table A to B with this script : Set Variable [ $name ; Value: Recipe::Recipe_name ] Set Variable [ $category ; Value: "basic recipe" ] Set Variable [ $quantity ; Value: Recipe::Quantity ] Set Variable [ $cost ; Value: Recipe::C_total ] Go to Layout [ "Main Inventory" (Inventory) ; Animation: None ] New Record/Request Set Field [ …

Anyone know if FileMaker can denote a script as compatible with various platforms (Win, Mac, WebDirect, Server, etc) in the Script Workspace? Barring that, is there a utility that can check your DB scripts and give you a table of there compatibility?

Please can I throw myself on the mercy of this wonderful forum again.... I need to script the following steps, but I struggle to create the correct script. So could some kind soul give me the script that I need.... (There are approx 2000 records, and each has a value in a Field called "Search Key"). (I could if needed make a textfile or similar containing all the Search Key values) I want to : (1) search for the first value in Search Key (for example: ABC_101); and then (2) Sort according to the value of a Field called "Quantity"; and then (3) Export the contents of a Field called "Output Final" for all Found Records and save it as UTF-8/tab-deli…

I made webhook sms api integration into my solution , I am trying to extract data with formatiing with following calculation - "smsbalance" = Left ( RightWords ( GetLayoutObjectAttribute ( "SMS BALANCE"; "CONTENT"; 1 ) ; 3 ) ; 4 ) I am getting desired result but whats happening is "smsbalance" field is not getting updated till i enter into the field smsbalance click into it and clicking outside tried lot scripting entering into it commiting records refreshing windows webviewer is getting updated but not "smsbalance" as u can see i have 4 digit sms balance , how to calculated to any number of sms balance remaining ??/ hope i am clear…

I watch a lot of training videos on Youtube. Whenever a topic interests me I add the URL into a simple two field database that contains a DESCRIPTION FIELD and a URL FIELD. The database lives on Dropbox so I can find it wherever I am. Some of the videos last for 20-30 minutes but I am only interested in small sections that last for one minute. I would like to find a way to find those particular sections without scrubbing through the video. Is there a way to script opening the video and then go directly to that sequence of the video? For example: the part of the video I want to watch lives at 3:38/19:58. Could I add a third field called CHAPTER th…

I made global variable and made 2 scripts n1 and n2 n1 is working n2 not someone plz explain wats happening ???? plz FM GLOBALS.fmp12

I setup a script trigger on a field that runs on object modify. However, I can no longer access the trigger. The option in Format is grayed out. How can I access the trigger?

As I get older (and believe me I am pretty old) I find that I have lost track of things that I thought I once knew how to do. This is one such case. I need a report that shows a ZIP code and the total number of records that share that ZIP. How do I do that?

why copy pasting of script text is forbidden

Hi gurus, I have a layout with a "popover button" which label is "Hold", inside the popover i have a global field for the user to enter a note, there are also two button inside the popover labeled "accept" and "cancel". I then have a script that creates a record in a related table all is working find except that i would like to insert the name of the popover button into a field. I am able use Get ( ActiveLayoutObjectName ) and set the name of the inner button but how would i get the name of the popover button. Thanks Rudy

I'm using the File Open script step to open a FM file. How can I automatically bring the file to the front?

I have a table called MEDIA_SCHEDULE which displays related records from LINE_ITEMS via a portal. I have a script to create a new LINE_ITEM from the MEDIA_SCHEDULE. It takes the CATEGORY (Digital, Television, Press etc.) as a script parameter to set the category of the LINE_ITEM created. The LINE_ITEM is displayed in a new window. I would like the script to choose the layout of this window via calculation so that if the new LINE_ITEM::Category is digital it is displayed using the "LINE_ITEMS_Digital" layout. I know I could have a script trigger to change layout as soon as the category is set but I thought it would be more elegant to have it done within the New Windo…

how to auto execute code(get(triggerkeystroke)) 13 that is enter key without touching the keyboard through script

I have a table that we are going to use to create a users password and store some information in. I would simply like to take the first for digits of the user's last name and add that onto a word to create their password. I have been searching and can't seem to find a way of doing this? The data column that has the user's name has both their First and Last name in it. So simply put. John Smith would have a password of smitWelcome1! How can this be done?? And thanks a lot for your help!

Hi All, I have some issues with Set Variable / Set Field. From the Customer TBL - New Customer Layout, I create a new Customer Name. Customer_Id created auto. Script: The New Customer / Aircraft Layout opens from TBL Customer_Aircraft but no Customer Id is set. Please could you tell me where I am going wrong? Relationship is one to many

I have a table that I enter data into and one of the fields is a registration number. What I would like to happen is, if a registration doesnt exist it then opens up a window with the registration entry on. Is this possible ?

Hi, I created a dashboard with a bunch of buttons, attached script to every button, which allows me navigating to specific record of the Products table. Basically, every script is the same, with minor changes (only record ID field changes). The process of creating a script to every button is a very time consuming as I need to write a script that a) goes to layout b)finds the certain record 1 "Step: Go to Layout Layout: Products  2 Step: Perform Find" Is there a way to simplify the task? Thanks!

Hello, I m trying to set up a script the goal is to delete or substitute some words form a Title (field) feeded by a $list (list of word located in different table) exemple I Have a title in table A : - Memory drive flash pen stick 8gb 16gb 32gb 64 gb And I have a list of words in table B : 8go 16 go 32 go 64 gb Output, what I would like to get is : "Memory drive flash pen stick" Each title will have his own list with same reference, there is also a trick because as you can see Gb could mean Go, so I think the best is delete all words matched (8, 16, 32, 64 ...) then I have another script who will delete duplicate words in the field (ti…

Greets, and a happy, holiday season to all. This is one of those "Well, I could swear it _used_ to work..." FMP (PC) problems: I want a script to create a custom-named folder on the desktop (PC) [for exporting data purposes] so I used the following (see attached) Send Event command: "cmd /c md " & Quote ( Right ( Get ( DesktopPath ) ; Length ( Get ( DesktopPath ) ) -1 ) & "Job Chop-Chop! Backup" ) ...in earlier versions of FMP--and if memory serves--it used to work. (See https://fmrift.wordpress.com/2010/02/03/creating-a-folder-from-filemaker-windows/ ). However, when I try to run the script in FMP v17.x the script fails with the following error me…

I'm trying to get scheduled scripts to return an error in the filemaker server log so that I can monitor these for problems, ones that are not related to FileMaker functions, but that I define. Ie, if I expect a find to always return the same result (5 records for example), then I want to be able to log an error if the result is different, so that this is recorded in the schedule log, and can be emailed/alerted. I tried using an exit script with a result but that doesn't make it into the log. There's no 'set error' script step or function that I could find. I know I can make my own log within FM, but I'd prefer using the log. This is for scheduled scripts only. …

I just watched the Soliant Consulting video giving some information on the new Refresh Portal script step. I have to wonder...what is the difference between this script step and the Refresh Object script step? Didn't Refresh Object do exactly the same thing if you specified the portal object name? Is there some performance benefit to using Refresh Portal?

Hi All, I have a table with customer and registration in my layout I want to be able to go to a new record but the customer name must be automatically populated from current customer in previous layout. Both layouts are from the same table. I just can not get the set variable and set field to work I tried using global field but without success this is my code

Hello, I have a database that use different printers - DYMO FOR SHIPPING LABELS - BROTHER LASER FOR LETTER SIZE - IMPACT PRINTER TO PRINT AN SPECIAL FORM. each printer has a script with PRINT SETUP WITH NO DIALOG, ( I choose the printer and the paper size) and PRINT ( I choose the printer again) the problem is when I print with DYMO printer and then print with the BROTHER printer, the BROTHER prints with the DYMO paper size or vice verse, so I have to setup the PRINT SETUP step with dialog to choose the printer and paper size again, every time I send to a new printer I have to configure the printer and paper size. my question is, there is a…

I use a script to sort records in list view. However, when I create a new record, enter data in the first field and then tab to the next field the records automatically sort before I finish entering data. This is a real pain for entering data. I have "keep records in sort order" unchecked. However when I check it, the records still continue to resort. How can I stop this?

Hi, How will I approach to delete all records in a table where the container is empty. I tried a few scripts but ran into problems with most of them. Loop stayed in a loop I tried calculating container length and delete if length is zero, but the field does not calculate to a zero even if i set default to zero

I use FMPro infrequently--and would be most appropriately described as a novice. I've received help with the script below--but my portal isn't sorting by alphanumeric order--in the order I want it to. I have a text field in my portal called __pkPosnCtrl. There is a max string of 20 characters in this field but location of letters or numbers within the field vary. The script allows my records to sort by toggling back and forth between ascending and descending order. There is an optional script parameter of "__pkPosnCtrl" which appears on a button over the portal label. Below is the script (I've added comments to help me understand and remember what the script is …

hello, having an issue that cant figure out why its not working. Have a portal in a layout (Table: Customers), showing all records from the same table (Customer). all works well, meaning all records are showing in the portal. now I am trying to create a record via a button on the portal row in a different table but cant get it to work. in my script I have the following steps; This script runs via a button which I have on the portal row. all the steps appear to be running except the "set variable" is not pickup the selected row but whichever record its active Can someone give me an idea what I could be doing wrong. Thanks …

I’m trying to write a script that creates records for each Sunday in any two-month period. Below, the script creates records for January and February 2019. It simply checks each day of the month to see if it is a Sunday and if so, it creates a record. It does fine except that the second month portion of the script creates a record for the first Sunday in March! No doubt this is due to the fact that the Loop exits after 32 days. However it seems to me that since the DayOfWeek calculation is based $month2=2 (February) it should not result in a record with a March date. Is it necessary to make the loop dependent on the number of days in the month? I was hoping…

Hi, I have a tab control with a few tabs in my customer layout. I would like to goto a specific tab from another layout. I have the goto customer layout sorted but go to object does not give me the option to select the tab control nor tab control tabs how do I go about doing this?

Is it possible to trigger a script based on a string from a Drop-down list value in text field? In my Drop-down list, and from two of the listed text values in that list, when I have chosen the value, I would like to set a date field manually. I was thinking the script should open a Show custom dialog? Will it work some how, or maybe something else?

Hello FM Mavens, I need to accomplish the following task. I have several fields, sequentially tabbed, named A, B, C, D etc. Each of them can be set to 0, 1, 2, 3 or 4. User sets some of the fields to a number other than 0 THEN: I need a script that sets the fields that were left empty to zero. Obviously it could be done by explicitly defining the fields but there are dozens. I thought of something like Go to next field, if (isempty "next field") set "next field" to 0. The problem is that the (isempty <field>) function requires an explicit field definition so how do I accomplish that? Or there may be a better solution? Thanks …

Greets, all: I have a dozens of print-related scripts but I want to use scripts--instead of using scores of hard-coded calculation and summary fields--to test for the presence of values within fields both in same table and parent-child table fields--so if not all the required fields for a particular printout have values, either in the current record or anywhere in the found set, it's flagged and another script notifies the user that none of the (found) records meet the required minimum field value requirement. Is there an elegant way to do this all in scripts or am I stuck using calculation and summary fields? ( The calculation field sets up the test with a resu…

I have a simple script that allows the user to re-login under a different username. if the user has 'Staff' privileges, the status area is hidden. Otherwise, it is on display. This works fine. But for some reason the 'Resize to Fit' step only seems to work intermittently. The *first* time I use the button and go to a Staff login, it works . . but if I go back and forth a second time, it doesn't, so there's about an inch of dead window space opened up on the bottom of the layout. Can anyone explain why this is happening? Thanks! Here's a picture of the script . . .

How do I get a value from FileMaker Pro Advance 17 variable as ( $$NAME ) into an Applescript that looks like; tell application "Leitz Icon Software" -- Store path to this script folder. set pathToScriptFolder to POSIX path of ((path to me as rich text) & "::") -- Open blank label. open label pathToScriptFolder & "LabelWithAddress.LeitzLbl" -- Delete all objects to make sure the label is blank. delete label objects -- Create new address object. make new address object with properties {x position:0.3, y position:0.3, width:8.2, height:3} -- Change address object properties. tel…

Good evening everyone, how can I open a dialog asking me which datasets I want to continue working with? In my example (see picture in the appendix) I would like to be asked a question about the script when entering the layout. For which of the customers in the next layout I want to bring the open positions on the bill. A dynamic search field / dynamic dialogue, so to speak Is that possible? I am more than thankful for your help. Greetings David

We use WuFoo for data gathering over the web and then import the data on a nightly basis into a FMP database from an exported tab-delimited file. We've been doing this for a couple of years but WuFoo recently changed the way they encode attachments they no longer pull into the database. I had a simple script step using "Insert from URL" which read the URL from the exported WuFoo file and put the linked attachment into a container field but that no longer works and I can't figure out why. WuFoo tech support is unfamiliar with FileMaker so I'm hoping somebody here can help. An example URL is <https://umbforms.wufoo.com/cabinet/a060c9ed-3210-49e4-9882-55cebf863e8c&gt…

Good day, I urgently need help with customizing a program. From the standard solution something was created with a little more possibilities! However, I despair when creating the bill. I do not get it separated if I fulfill more than one order for a customer at the same time placing an order to separate the positions according to customers. Could someone help me there? I can gladly distribute the solution or provide the appropriate scripts. Likewise via PM or e-mail. I'm really grateful for your help. greetings

I have a script that the user triggers to set up an email which they can then edit and send. After sending, I want the user to have an option to store a record of the email in a sub-table - because if the user cancels the email, there should be no record of having sent one. I'm thinking the way this should work is I use 'Pause Script' after the 'Send Mail' step, and then after the user finishes in the email window and returns to Filemaker and either cancels the rest of the script process or continues with it and the sub-record is created. This can be achieved by just having the user click "Continue" or "Cancel" on the window . . . but those buttons can be a little…

I have a fairly simple privilege setup for a 'Staff' login that employs a custom Menu Set. I have simple script that runs on user log-in that installs the custom set if the user is a 'Staff' member. It works fine. But I have a 'Re-Login' button to make it easy for Staff and Supervisors to switch in and out depending who's on the machine. It does switch the privileges appropriately, but the menu set doesn't change. Can someone tell me what's wrong with this script? Here are both of them . . . Help!

I have many scripts that are generating a PDF using data from records in particular tables using several layouts to display all the data (lots of fields). We've always done the scripts just plugging away from beginning to end, hard coding the finds and sorts needed, switching from layout to layout, setting the print parameters for each layout, continuing until finished. My dream is to generalize/modularize these as much as possible. I have a couple of questions based on things that look like potential issues. (I think I know how to pass find and sort parameters and which layout to use for each page I need to generate, so I'm good there.) The first issue has to do …

Hi Everyone, I've got a JSON issue that I've been struggling to figure out. Here is a sample output of what I'm trying to do: { "fulfillment": { "location_id": 905684977, "tracking_numbers": [ "a4e6e7ca452c7873c2ef10234d042352", "81669206ee8e6164da5ac190af93e6ca", "3def69908a9530b5c46b282a988cf914" ], "line_items": [ { "id": 466157049 }, { "id": 518995019 }, { "id": 703073504 } ] } } It's the "tracking_numbers" that is throwing me off. I can build normal arrays like "line_items" no problem, but I've no idea how to structure the JSONSetElement function in a w…

Hi gurus, I'm seeking some advice on the best way to accomplish a task. I have a tables with about 110 fields, and i need users to be able to insert data into three fields at a later time via a popover. To accomplish this I am considering two options. Option 1 - place the fields in a popover and have the users populate them with the required data, in the pop over there would be two buttons one to close the popover which would also clear the entries and the other to commit and close the popover. Option 2 - Create global fields and place them on the popover where the users can enter the data and once a "Accept" button is pressed the data is committed and pop…

Hi, Can someone guide me on what I could be doing wrong in the below script. This script runs when the file opens. All the steps execute except the "install menu Set" but if I run the script manually after opening the file it does execute and the menu changes. Thanks JMart

Without the optional HTML and attachment parameters, my BE_SMTPServer/BE_SMTP_Send function calls successfully send an email. When adding the optional HTML and attachment parameters (HTML is null, attachment is text), the email fails with a returned error code 2: CURLE_FAILED_INIT (2) Very early initialization code failed. This is likely to be an internal error or problem, or a resource problem where something fundamental couldn't get done at init time. The attachment has just been browsed for and 'inserted' into a container field, and the file reference for the attachment established via 'getastext(<containerField>' Thi…

I have a couple of scripts; one deletes redundant records, and the other adds new records under certain cirumstances. Is there a scripting way to show how many records were added (or deleted), when the script finishes?

hi guys, Can someone point what I am doing wrong. the idea is to open a new windows and create a record on a related table. The windows name is based on the name of the button the users presses to open the window. the script I have is the following; The issue I have is that once I add "set field [WO Notes::g_work_order_notes; ""] to clear the field for the next note I get the following error. any help is greatly appreciated.

Hey guys I have a NAS which I administer by issuing commands via SSH inside of terminal. All that typing has become a little monotonous so I created a small FM solution to do it for me. This is one of my [native] Apple Scripts that are issued via a button click from inside of FM: on RunTerminal() set ScriptCommand to "docker restart 70763e5576a3 85201fbfccc4 935a69d98be1 afb9e027526d" tell application "Terminal" activate do script with command ScriptCommand in window 1 end tell end RunTerminal on run RunTerminal() end run It works great, but I want to customize it a little more. The alphanumerical numbers (70763e5576a3, etc.) are individual containers wh…

Hello guys, good afternoon. I need help regarding how to add two payments. As you can see in the image below, there are payments below the BILLING record. What I want to happen is, I want to ADD those two payments. After the two payments were added, the payment will be put into the Pay Bill of the BILLING record. (See the picture below) Here's my script but it won't work:

Hi i have a field that uses a drop down list of values from 1 - 5 to insert in the field. the field is on a portal. The portal could contain upto 50 records. i would like to limit the amount of time each value could be used to 16 times as that is the limit of spaces i have available . OPTION 1: i would want that once the limit is reached the value greys out if possible . OPTION 2: if not i would want that it a script should activate on a onobject keystoke / validate it should test it and not allow it. i would appreciate if one could help me out on this preferbly OPTION 1.

hello all, I am using insert from url script step in my server scheduled script with cURL parameters. Insert from URL step gives error 1, user cancelled action. I have added --max-time 30 option, but still same error code. I changed the url to any regular web page, it works. But it still not works with orginal url (mailgun api url). how can I handle this problem? regards, osman

Evening guys. I'm trying to invoke an error message of sorts (and/or even just a conditional format) if a value in a field is shared across multiple records. In my situation each record is assigned a color from a value list. The user can use the same color on as many records as they want, but I want to at least provide some sort of indication that it's already been assigned. I'm sure this is more simple than I'm making it to be. Help appreciated!

Hi all I have a looping script that allows the user to scan barcodes in batches. Based on certain criteria it's either successful or returns an error. It works great. I've now incorporated a "beep" upon an error return - works great. I've added a global container field off the layout and inserted an audio clip of a chime which I want to play when the result is successful. IT WILL NOT WORK. The container is a global, data formatting is set to "interactive content" and "start playback automatically". Field entry set to "Browse Mode". Does not play. Script Debugger returns error 102 (field not found) so I moved the container onto the layout and the audio file plays…

Hi, can i email to Kakao Talk or WeChat from fimlemaker ? i know i can text to cell phone from filemaker but since i never used WeChat , i have no idea. if i can , can somebody tell me how ? Thanks ,

Hello FM Mavens, I would like to be able to change an attribute (happens to be the size) of a selection in a text window with a script. (Basically, as if moving the size selector from the Formatting Bar into a button on a layout). I created a script that cuts the selection, puts it in another text field, makes the change, cuts it out and goes back to the original field but by then the insertion point is gone. I can manually paste it back of course. I wonder if there is a way to remember the insertion point somehow and make it a so the paste step uses it. Thanks Asu

Hello FM experts, this is a concept step for a more complex script but I need a script that has 2 independent features: 1: it selects the field it is attached to as a button 2: it can be attached to any arbitrary field and it does the same on that field. The imaginary script step would be this: Select field [the one I am attached to] The problem I am running into is that "go to field" can not be defined by calculation, while "go to object" gets confusing between the script and the field being grouped, as the problem detailed here [https://www.soliantconsulting.com/blog/story-about-go-to-object] seems to be a complicating factor. T…

Hi Guys, I currently use Insert URL in order to download certain files from an external FTP location, which I have managed to get working perfectly using the following curl options --user " & $usr & ":" & $pw & " -o Stock-Summary.csv" This works as hoped and downloads the file from the FTP, however, the company who provides us with these files has "moved the goalposts" so to speak. For whatever reason they are now prefixing and suffixing random numbers to said file, so I need to tweak this to somehow only get the latest version of this file which now looks something like this - Any advice or different approaches would be greatly ap…

Hello, I am struggling to make a send event work and I am running out of ideas so a bit of help is needed I have a script which will create a file on the desktop and then email it. After it is created I want the file deleted. Here are the steps of the script which deal with this need: The first one will create the path and filename to be created and then emailed Set Variable [$file; Value: "filewin:"&Get ( DesktopPath )&Substitute( GetAsText ( Get ( CurrentDate ));"/";"")&"_Report.pdf"] The second one will create a variable to be used in cmd as parameter for the del command Set Variable [$filedelete; Value: Replace ( Substitute( $fil…

I'm working on a small job scheduling system for myself. When a work order comes in I assign a date to it manually. What's I'm trying to do is show a list somewhere on my layout of remaining available dates in that month. I'm not sure where to start with calculating that or displaying it.

Firstly, sorry if this is the wrong section of the forum but this was the best fit I could find. I am currently using fmLog (https://app.works/tag/fmlog/) to keep an audit list for our dbs. It works great, except with certain characters. I believe this is the part that should be validating (removing) some chars that will break the script except it doesn't seem to be working. Let ( [ n = Substitute ( Get (ScriptParameter) ; "¶" ; "\¶" ); prefix = "$" ; e = PatternCount ( n ; " = " ) = 0 ; string = Substitute ( n ; [ " ; " ; "\"; " & prefix ] ; [ " = " ; "= \"" ] ) ] ; "Let ( [ " & prefix & string & "\" ] ; \"\" )" …

I have several scripts that I need to end with this stub: Go to Layout ["Client Data" (Client Data) Go to Field [Client Data::New Emergency Date; ""] Replace Field Contents [No dialog] The objective is to clear out the date field after processing is completed. However, I get a message stating "The previous script step, "Replace Field Contents" could not be completed because of an error". Do you wish to continue with this script? The objective is to clear out the New Emergency Date fields after processing is complete. What am I doing wrong? TIA

Hi gurus, I am trying to check if two fields are empty and if either are a message pops, if they both contain data a record is created on a related table. I have put it on a script but for some reason its not working. and I don't seem to be able to figure out why. Thanks

I need to connect FM16 to a SFTP server (download, read, delete). Does anyone have a working example that I could take a look at? Alternatively, I would love to see an example using Base Elements cURL functionality. I've got a script that does what I need it to, using FTP but SFTP is giving me trouble. Thanks in advance!

Hello, we are using filemaker server 16 and we just upgrade one user station from fm15 to fm16 and the print button is not working as always, when we open the database at first it prints ok (3 copies) but after some printing it begins to print just one copy. the script is setup to print 3 copies but before the print line it has some validation lines process. I don't know if it is pc hardware? is a pentium 3.2 ghz with 4 gigs ram... is too old for filemaker 16? please let me know thank you

Friends: I've been searching but not finding how to do a simple find script to attach to a button as follows: Show all the records (so we know we are searching the whole database) then Find all the records where the field "products" contains the text "film" Thanks in advance for your help, Migs

Hi, my cuestión is very simple, How does the script know the "script parameter" in the first row of the script IsEmpty ( FilterValues ( Get ( ScriptParameter ) ; List ( LineItems::ProductID ) ) )

Hi, After several days of trying this on my own and looking at various post. My file has at this time 3 dropdown's. I have "Length", "Width" and "Depth". I need at least 6 more in the future. Each field for "Width" may have the same value 1 or more times. Depending on the Product. The same goes to the other fields. I have 2 table set up. One for the "Data" the other for the "Product". In the relationship graft I have Data Length to Product "Length". And the same connection fo Width and Depth. I have "List view for each field. Now with my current design. I can do a find for "Length". This seems to work ok. Now the main problem I need the "DropDown…

Hi, The simple code here works. However, when it runs I receive a msg box that ask :Modify, Continue". I have it set to run "OnExit". The value is derived from a "DropDown". Am I missing something?

I want to exit a script if a search produces no records' I tried this: Go to Layout ["Client Data" (Client Data)] Perform Find (Restore) If [ Get (Foundcount) = 0 ] Exit Script End If What am I doing wrong?

I am looking for some advice, I am working on a database to track order activity form the time an order was generated to the time the order was delivered to the customer e.g. date and time for when entered, when printed, when sent to warehouse, when picked, also for each instant there is a start entry and end entry. then a calculation for the time each instant took. I would like to create a script that would find all records that contain empty fields (except calculations and auto entered fields), I know I can perform a find instant for each field using "=", but is there an easier way than to have about 160 find instances. Thanks for any advice.

I have a situation that I've never seen before. Mac OS 10.13.3 and FM Advanced 16.0.5.500 In a script, I had been setting a local variable called: $hours. As I was debugging part of the script I noticed that the $hours was being set as soon as the script was triggered - in Debugger not a single step was executed yet and somehow the $hours was set. I've tried everything I can think of and yet in that script $hours is still being set and the worst part is the value is not editable. Can't overwrite it with a script step, can't manually change it - nothing. I've deleted prefs, cache files, everything I can find that has filemaker in the the name in my User/Lib…

I am trying to position a new card window on the right edge of the window that it is being opened from. My calc for the FromLeft card setting is (Get (WindowLeft) + Get(WindowWidth). This only works (no gap between windows) when the originating window is all the way to the left of the screen. The more the originating window gets from the left of the screen the larger the gap between the two windows. I have also tried hardcoding the second value Get(WindowLeft) + 80 and it produces the same results. Not sure why this is not working.

Do not understand Get(ActiveFieldName) usage: Simple script: set variable $fieldname = Get(ActiveFieldName) 1. place cursor in desired field. 2. run script in debug mode, data viewer on 3. $firldname always null set variable $fieldname = Get(ActiveFieldName) set field (xyz) = $fieldname 1. place cursor in desired field 2. run script 3. field (xyz; text) is empty What am I doing wrong? Same problem with Get(ActiveFieldContent) Other Get(Active***) all appear to work as I would expect.

I have a sort of sales report and I'm trying to figure out how to show Top 10 Customers, Top 10 Products, etc....by Salesperson. So I have an Invoice ID, Customer Name, Invoice Total, ProductSKU and SalesPerson ID I have Salesperson ID in a dropdown from a value list...I'd like to know how to script it so that I can select a SalesPerson ID and see the lists of TOP 10.

Hello, I manage a bunch of files for Fire Departments. After the winter we have had I need to come up with an automated way to create attendance records after a weather event like a blizzard. Normally each firefighter either scans a barcode or selects their name from a dropdown to create an ATTENDANCE record for them which is related to the EVENT (Attendance Table for attendance and Events table for Events). Typically to create the attendance record I grab the key field "ID" from the event and the Personnel Record "ID" from a value list dropdown on the incident report and then create an attendance record in a portal on the Event Layout. One of the departments …

Greets, all: I want to script the creation of a folder--named Job Chop-Chop! Export--on the desktop (PC) and found this Web page with instructions ( https://fmrift.wordpress.com/2010/02/03/creating-a-folder-from-filemaker-windows/ ) but being a Apple person I'm admittedly hazy on Window filepaths and can't get the script command to work (see attached). "cmd /c md " & Quote ( Right ( Get ( DesktopPath ) ; Length ( Get ( DesktopPath ) ) -1 ) & "Job Chop-Chop! Export" ) I guarantee it's something as simple, I'm just not seeing it. Thanks in advance for your help! Strangely enough, re-entering the command caused the Send Event command…

Hi every body I have ancestor database "test file" attached . I need a script that gives me theses search results: If I search for a single name, I want to find the records where the last field is the "single name" If I search for two names "Smith George", I want to find only records with the last two fields having the two names "Smith as the son and George as the father" If I search for three names "Smith George John", I want to find only records with the last three fields having the three names "Smith as the son and George as the father and John as the grandfather" Search parameters------------Output (result) John-------------------------------…

Hi, Im trying to write a script to select unique records from a table (see below). WIth no result . On this particular example script should select only records 1,2,3,6.

Hi, I want to run a server-side script but don't know how to pass the parameter the script needs to perform. The script need todo the following go to layout, enter in find mode, set field, perform find, set field. This link says that you can pass information about the client’s context to a server-side script by using the script parameter in the Perform Script On Server script step but I have no idea how, I need to learn how. can someone guide me please Thank you https://www.filemaker.com/help/15/fmp/en/index.html#page/FMP_Help/running-scripts-on-server.html

I commonly use the same field names and some scripts in different Filemaker files. If I import a script I have to change the table name for all the fields in the script (although the actual field names are the same), which is a nuisance. Does anyone have a utility to do this automatically?

Hello forumers I have a small issue with an export on a network path. Generally the path is alive, but very rarely it can happen that is not reachable. When not reachable, you'll get the error message from FileMaker that file can not be created .... (error code = 800). Since this dialog box can not be suppressed by Error Capture =On, the script will stop there until someone goes and clicks on the OK button of the message. Was wondering, is there a way to check if the path is reachable, and if it is not reachable then to exit script? Thank you, Toni

hello , I have a script that makes a new record on my iphone . It works well except when your making a record for the first time. it makes on "inactive" record and on "Active" record. Thos is because the status field is empty for the first record. what would i insert to check if its empty , if so new record , if not make "Inactive" Thanks

Hello The following AppleScript is in a opening "Perform AppleScript" step in my database. In Filemaker Pro 13 this script set the Filemaker Pro field without out a problem. After upgrading to Filemaker Pro 16, the AppleScript no longer sets the Filemaker Pro Field Anyone have any ideas why? here is the AppleScript: --Make sure QuickTime exists; could be used to find any program if (do shell script "ls /Applications") contains "QuickTime Player" then --send information to FileMaker so opening script can set voicenotes properly tell application "FileMaker Pro Advanced" tell table "Preferences" …

Want to insert a link to PDF file so that the PDF is displayed Not like container - how?

Been way too long since last using FMPro. I have a table of imported records. There is a unique identifier for most records, but many are missing the unique ID. I need to 'fill down' so to speak in the table because I only entered the first account number. The file is flat for now because it needs to be imported into a larger database. I know how to do this by creating accounts and raw data tables, but I only need to fill down for about 800 records and I'm golden. I recall there's a way to do this, but shameful that I've forgotten. Any helpers? thanks! not the replace contents function, but a script that would find the field value, replace the contents of the n…

I understand this is an old thread, however I am having an issue with this and I am using BE_ExecuteSystemCommand. I am working on using the baseelements plugin to convert a file. I have the BE_ExportFieldContents working properly, but I am not having much luck with converting the file using ffmpeg. I have BE_ExecuteSystemCommand ("ffmpeg -i \"/Library/FileMaker Server/Data/Documents/IMG_4039.MOV\" -acodec copy \"/Library/FileMaker Server/Data/Documents/robert.m4v\""; 15000) Which doesnt seem to work. I have used terminal to get it working successfully with ffmpeg -i "/Library/FileMaker Server/Data/Documents/IMG_4039.MOV" -acodec copy "/Libra…

I might be reviving an old topic, but wanted to share what I have come with to run a script at a specified time of day. I have no Filemaker Server, I am running Filemaker Pro Advanced 11. In my example I want to run script "Export_DL4_Call" at 23:00:00 every day which exports data from file, let's call it "File1". I created another file, let's call it File2 on which I calculate the schedule of time and from it I call the script on File1. At first I tried with windows scheduler but it was not reliable at all. On File2 create fields "Time1" and "Schedule_Time" both as text. Create a script "Schedule_Time_24h" which runs every 24h with following steps: S…

I am attempting to use the following script in a Database: Set Variable [$supplierCount; Value: ValueCount ( List ( Suppliers::UUID ) )] Set Variable [$month; Value: MonthName ( Get ( CurrentDate ) )] Set Variable [$suppliers; Value: List ( Suppliers::UUID )] Loop Set Variable [$i; Value: $i+1] Exit Loop If [$i > $supplierCount] New Record/Request Set Field [Month::Month; $month] Set Field [Month::fk_Supplier; GetValue ($suppliers ; $i )] End Loop When I run it, however, it creates zero New Records within my "Month" database. I'm not sure what the issue is. My only hunch is that the List function isn't properly creating a List of the "Suppl…