Jump to content

Search the Community

Showing results for tags 'script'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
    • Accounting Solutions
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by FMPug.com
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions
  • FileMaker Platform
  • Forum

Blogs

There are no results to display.

There are no results to display.

Categories

  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 151 results

  1. Subscripts

    Hi Guys, Just a quick question for a beginner, I have created multiple export scripts, and notice that when I create a master script with the numerous subscripts being called, sometimes the output isnt correct, whereas when I run each script one by one (rather than lots of subscripts within a master script) the final result is fine. Could there be anything wrong with using subscripts for this? Should I always have an Exit Script step at the end of each subscript? I hope that makes sense Thankyou
  2. Hi, I want to create a Dropdown List of numeric options to select a range of records. For example, the Dropdown list would contain: 5 10 20 50 100 ------- edit... Each option would select the next 5;10;20;50 or 100 records to the right. A Checkbox would be populated (with an X) in the selected number of contiguous records; Then, a Find Selected Checkboxes would return the selected records. The contiguous selection should be independent of whatever the current state of Found (Sorted/Unsorted) is. Any help will be gratefully acknowledged. Best, Daniel
  3. Printing in different orientations

    I have a database, which has two printable forms. One has been designed in portrait, and the other in landscape. Both of them are only ever printed using buttons tied to script steps, never manually. I was hoping that there would be some way to specify orientation via the script. However, after some poking around of my own and light Google searching I am thinking this may not be so easy. I am able to go into Print setup to change the orientation just fine, however this sets it for the entire database which is not all around helpful. While specifying the options in the print step, I am able to change orientation. For some reason though, this changes the default orientation across the entire database. Not even while running the script, but just specifying it in the options of the script step. So now I'm at a loss. If this is not able to be done, redesigning one of the forms wouldn't be that difficult. But if there's a way to do what I'm trying to do, any assistance would be greatly appreciated!
  4. Use Case: I've got a graphic (in this instance, a complete human body). I want to mouse-over and click on say, the hand, and have that trigger a script, with a parameter. I'd hope to simply have a single script, read the parameter (which would in fact grab the value of the tooltip), and have that passed into the script. It seems to me that the various flavors of "get(objectname), etc don't seem to have a way to grab the actual text that's in the "tooltip" or "object name". Am I missing something in there? I'd love to be able to create 50 graphics, name each one by tooltip (or object name), and not have to create/modify a script for each and every single graphic. thanks for any help! EDIT: as a temp work-around, I've manually dropped the objectname into the script parameter, then have the script punch that into appropriate fields.. It's annoying to set up, and takes 5x's as long, but that's currently the only method I've got for this. Any further options?
  5. Open File Script

    My end goal is to have a button that, when clicked: 1. Opens a pdf form from my server 2. Fills in the form using data entered into FileMaker (I'm using FileMaker 10) I'm on step one and and trying to use the "Open File" script, however it's not working. Can the "Open File" script be used to open non-Filemaker files, such as PDFs?
  6. FileMaker 16 introduced a collection of built-in functions for manipulating data serialized as JSON. This makes it easier for FileMaker applications to interact with many web services. This will also make JSON the de facto standard format for scripts within FileMaker to pass parameters and results to each other, improving code sharing within the FileMaker community. JSON does not have a broad palette of scalar data types to choose from: text, number, boolean, and null. Even with those, FileMaker's JSONGetElement function always returns a text result, even when the serialized JSON value is a number or boolean. So I made a handful of custom functions and scripts for sending and receiving typed data with JSON. The module is hosted on GitHub, or you can download it directly.
  7. Hey folks, I am working on a layout that auto-populates a bunch of data from related fields. One of the fields is called district_number which has the numerical 1-12 value, depending on the district. I am trying to get a script to read the district number, then based on the value have it populate data in another field. I started by setting the district_number as a variable, $DistrictNumber Then I have the If statement: If[$DistrictAddress = "01"] Insert Text [Select;xxx::district_address_label; "District 1 P.O. Box 3700 blah blah blah"] Else If [$DistrictAddress = "02"] Insert Text [Select;xxx::district_address_label; "District 2 P.O. Box 3700 blah blah blah"] Else If [$DistrictAddress = "03"] Insert Text [Select;xxx::district_address_label; "District 3 P.O. Box 3700 blah blah blah"] ... etc... End If But ti doesn't work. Any help on what I am doing wrong is much appreciated!! Thank in advance, RT here is an image of how it looks
  8. Hi. I have a search field, a user types his customer number in it. I want to when a user types his customer number and press inter-script run. how can I do this work? I use on object keystroke but when I want to type number script run and user can't type phone numbers. how can I fix this?
  9. I have a php script that takes two PDF files and merges them into one file. I am using this in conjunction with the insert from URL script step. The way the script works is it takes two PDFs in container fields and base64encode each files. Then, those two base 64 strings are POSTed via insert from URL. I've tested the script forwards and backwards and it does combine the PDF files reliably. The issue is when posting from FileMaker. What typically happens is the first page is combined twice and that's my resultant PDF. My php script checks that both inputs are different and throws an error is they are identical. I don't get any errors there. Is there a way to POST a file from insert from URL?
  10. Hi. I seem to find variating answers to this topic, so here I try again. How do I use a variable to perform a find in a script? I want to use the field contents of the current record to search for similar records. Background: We send a lot of people out to different countries and I want to make a script that makes an excel sheet with various data based on the country field of the current record. Hence, if the current record is going to France, I want to see everybody that we currently have in France etc. However, we have two return dates so I need to do two searches: 1. Country+ departure date <=// + arrival date >=// 2. Country+ departure date <=// + Extended arrival date >=// Is it really true that perform find cannot handle a variable? Hope you can help.
  11. In one of my layouts I have created an ID Card like view that has a persons image and layered over the top of it I have some fields. Is there a way to export that composite as an image? I was thinking something like if I grouped the composite and gave it a name I could export it as a script step but searching came up with mostly how to copy layout objects to a different layout... Currently it works to screenshot the composite but I would like to automate the process a little bit. Thanks for any help
  12. I'm looking to create a script and place it in a button to exist on two layouts (BACKUP and MAIN), to accomplish the following when activated from either layout: Copy current ACCTNUMBER If current layout is MAIN then go to BACKUP layout and show the same ACCTNUMBER record. else if current layout is BACKUP then go to MAIN layout and show the same ACCTNUMBER record. ....I'm sure it's a no brainer but right now I'm totally missing some small step to start the script ....help?
  13. Hey, I have a Tab-Separated Text File which I want to import to a database that I just created in FileMaker Pro 15. The text file essentially is a log of events, for instance, one line describes an order, another line describes a payment that has been made. The problem is that I somehow need to import all these lines into different tables. I want all lines in the log file that describe a payment in a table called Payments, and all lines that describe an order in a table called Orders for example. I'm just starting out with FileMaker so forgive me if there is an obvious solution that I'm not aware of. I have a background in software development, so the only solution that I can think of is writing a small program myself that does all the parsing for me and creates separate text files that contain all the orders and payments and other events that have been logged in the file. Then I could simply import each file into the table I need all the data in. So to sum everything up, my main question is if there is a way to somehow parse the text file before importing it. I know that you can create custom scripts in FileMaker but I'm not sure if what I need to do can be done just with that. Thanks in advance, Mike
  14. Hi, I wrote a script in FM Pro, which reads a list of files from given directory, searches through a set of records, and uploads each file into a container field of a matching record (the matching occurs by file name = unique record id). The script works great.... in FM Pro.... but not in Web Direct I need your help in finding a solution for Windows system. Thank you!
  15. I have a solution to track employee expense reports which contains a container to store a pdf of related receipts. Currently, I create a multiple page pdf of receipts in Apple Preview, then paste it into the container. Was wondering if it was possible to create a FM script or AppleScript to drop a single, additional pdf into the container and "automatically" create multiple page pdf with the existing container contents? Thanks in advance!
  16. Hi All, I'm struggling with a script. I have three tables - Clients, Progress notes, and Add on progress notes. From a layout on the clients table I want to go to related records in the Progress notes table and if a field (Set AON) is set to "1" the script will print the progress note and then go to the add on progress notes table and print the related record(s). Then back in the Progress notes table, if the field (Set AON) is blank, print the progress note record. Below is what I have but it's not working as I expected. It is printing each of the records from the progress notes table first, then prints the record from the Add on Progress Notes (I'm actually not printing them but trying to save them all to a PDF file which can be saved or printed). I know this seems convoluted but I need these steps to happen in this order because I need the Add On Progress Note to Print right after the the Progress Note since they go together. Also I need the Progress Notes to be in order by date. I'm using FM Pro 13 Advanced (13.0v9) on a MacBook (other users are running XOS and Windows) with macOS Sierra Version 10.12.2. Any help would be greatly appreciated. I have struggled with this for several days with no luck. I would say I'm a beginner to intermediate with FM. Scripting in FM comes after my real jobs of being a mental health professional and a small business owner so I go for several months at a time between working on the development side of FM. Actually, I could use some therapy myself after fighting with this script! Print Progress Notes.pdf
  17. Hello, I am wondering if there is a script step or or other mechanism which would cause the automatic activation of a drop-down list, or a pop-up menu, as if I had clicked on it.
  18. The database has table1 with “Sample No” field relating it to table2 with “Sample No” field. Table 2 has a portal on a layout with Table1. Each portal row has the Category field with one of 3 values (MF,BP and CC). There are about 7000 samples. Each sample has from 1-12 portal rows displayed with 1 or more occurrences of the 3 category values one of the values shows the count of each value per sample. The question is how do I write a script so that every sample has all 3 category values (MF,BP and CC)? I have the following scripts for when there is only one value/portal - one for each of the 3 values (3 scripts are the same except that “Molecular Function” is substituted for BP or CC and “Molecular Function” = MF): Perform Find [ Specified Find Requests: Find Records; Criteria: Transcript Database::Regulation: “=test” ] [ Restore ] Perform Script [ “Sort by Sample No” ] Go to Record/Request/Page [ First ] Loop Go to Portal Row [ Select; First ] If [ GO_GOT::Putative Gene Function Category "Molecular Function" ] ≠ "Molecular Function" ] ≠ If [ GO_GOT::Putative Gene Function Category Go to Portal Row [ Select; Next ] Go to Portal Row [ Select; Last ] Set Field [ GO_GOT::Putative Gene Function Category; "Molecular Function" ] End If End If Go to Record/Request/Page [ Next; Exit after last ] End Loop I can not get a script to work on a portal with only 2 categories so that only one of the 3 categories is added per sample. Transcript Database v05 test.fmp12
  19. Is it always safe to delete a script when the DDR lists no Layouts that use the script and no other Scripts that call the script? I'm trying to clean up my file without shooting myself in the foot: I can't think of why I would ever need such a script, but don't want to find out the hard way that I could still need them. Thanks in advance, Guy
  20. Script to Run Report Blank

    I am using FileMaker Pro 12. I wrote a script to look at a field and if the value is less or equal to .70 it will run the report. I have it set to Auto open an EXCEL spreadsheet. When the script runs I see that it finds the records but then my EXCEL spreadsheet is empty. Here is the script: Perform Find [Restore] Save Records as Excel["TotalAttendance.xls";Automatically open;Records being browsed] Go to Layout[original layout] Show All Records In the Perform Find [Restore] I have the following coded: Find Records PersonnelRecords::PercentDaysAttended:[<_ .70] That is suppose to be less than and equal to. Did not know how to show it with the keyboard.
  21. I have an FM Table called PRODUCTS (shown on lines 2-5 in the image file). I want to transform this into an FM Table called TRANSFORMED (shown on lines 7-8 in the image file). How do I do this in FM? (I am indicating return-separated lists with tilde's (~) in the image.) Also, does this TRANSFORMED table structure make sense?: I intend to have a JOIN on the TRANSFORMED table's PROD_ID field with the PROD_ID in my SALES table for an export (to Excel) of the SALES table based on a match on one of the return-separated list values in the PROD_ID field.
  22. Insert From URL timeout

    I am using Insert From URL to send HTTP GET request to my server and get the result. I have a function PING that returns 1 if the server is online, but it cannot returns 0 if it is not so I am catching the error on filemaker : Connection timed out; the timeout value is 60 seconds. Is there a way to reduce this timeout value so the user does not have to wait a minute to know that the server is offline ? Similarly, if a process takes too long to answer, is there a way I can timeout the Insert From URL command ?
  23. I am using a custom function to format a number into currency format ( two decimals ). RoundDecimals(11.0) = 11.00 The problems occurs when I use a variable: $amount = 11.0 RoundDecimals($amount) = 11.11 Similarly, I get the same error using a string: RoundDecimals("11.0") = 11.11 Is there any tricks to get around this issue ? This is the custom function that I used (I replaced the comma for a dot and defaulted second parameter to 2): https://www.briandunning.com/cf/974
  24. Folks I'm having a bit of headache with a search script. I want to search a date range from today to 90 days in the future. Currently I've made a script with a step saying: Insert Calculated Result [Select; "date field"; ( Get (CurrentDate) & "..." (Get (CurrentDate) + 90)] Being in the UK, I'm working with a file that was created on a US computer - the month and day are the wrong way round. I've changed the text on the system to use system settings but that still doesn't solve it! Frankly, that's quite ridiculous! Surely a bug like this that has been around for a VERY long time must have been ironed out of the software code? From what I understand, to avoid this, I need to create a clone of the whole database copying everything across to stop this calculation showing up the MM DD round the wrong way. I don't really want to have this headache, so I tried creating Calculation Fields in my Products table (that actually show up the right way round) and using them in the above code, but the search field just show up as empty aside from the "..." in it. Are there any workarounds for this to save me the headache of cloning a rather complex database with a few dozen tables?
  25. I'm trying to execute a windows cmd script server-side from client machines. I've got this working locally using Send Event, but I found that this command isn't compatible with server schedules, which I believe would be the best way to do this in conjunction with a flag. The specifics of the script I'm wanting to deploy are: We use Google Apps for our user accounts, of which we have thousands. We currently use Google Apps Manager, a cmd tool for making remote changes to accounts and other aspects of Google apps, on a linux server as part of an automated workflow that is triggered by Filemaker/ODBC etc. However, occasionally the process trips up, or a user needs changes to be made to their account so I'm wanting to create an interface in Filemaker that the team can use to execute a server-side script that performs actions on a record-by-record basis. E.g., one of the script steps is Send Event [""; "aevt"; "odoc"; "cmd.exe /c gam create user " & Enrolled Courses::Gmail & " firstname " & Contact Details::First Name &" lastname " & Contact Details::Last Name & " password " & Enrolled Courses::Password] - this works when run locally on the server, but not from clients due (I presume) to the Send Event step. We can't install the command line tool on each of the client machines due to security implications, and also because they're a mix of macs & PCs and the server is Windows, so I really need to be able to execute the cmd.exe server-side (although there is a Python flavour of the tool, if that opens up any options). If there any way to do this that also allows passing the required variables? Many thanks in advance. Paul
×

Important Information

By using this site, you agree to our Terms of Use.