WinClipboard ( String )

Sets calculated or related text to the Windows clipboard, use with Send Event [ script step ]

Average rating: 4.0 (2 votes) Log in to vote

onefish
onefish

Sample input:

Text from table::field
(not on current layout)
$variable text
"directly typed text"
All special characters!
!@#$%^&*()_+-=[]\{}|;':",./<>?

Sample output:

Text from table::field
(not on current layout)
$variable text
"directly typed text"
All special characters!
!@#$%^&*()_+-=[]\{}|;':",./<>?

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/* For use with "Send Event" script step to copy field contents or calculated text to the windows clipboard. Fields do not need to be on the current layout. Uses Windows Powershell and requires version 5 or higher. */

If ( IsEmpty ( String ) ; "" ; 

Let ( [ 

S = String ; 
Sb = "'" & Substitute ( S ; [ "'" ; "''" ] ; [ "\"" ; "\"\"\"" ] ; [ "{" ; "{{" ] ;  [ "}" ; "}}" ] ; [ "¶" ; "{0}" ] ) & "'" ; 
C1 = "powershell.exe -command \"" ] ; 

C1 & "$str = " & Sb  & " -f [System.Environment]::NewLine ; Set-Clipboard $str\""

) )

** Windows Only **

This custom function copies text to the Windows clipboard. It uses Microsoft Powershell and requires Powershell 5 or newer (generally pre-installed on Win 8+ systems).

The function must be used from a Send Event [ script step ]. Select "odoc" and "calculation". The function generates the entire call so just add the text to be copied in the function parameter. The function will fail if any text is concatenated before or after the function output.

( String ) can be any text normally available through the Filemaker calculation dialogue. Fields do not have to be on the current layout and no global temp fields are required, as needed for methods using FM's in built Copy ( script step ).

Useful for copying text for use outside the Filemaker environment, such as URL's, compiled text for web forms, etc.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

WinClipboard ( String )

Comments

Support this website.

Support this website.