Learning Claris FileMaker
317.3K views | +9 today
Follow
Learning Claris FileMaker
Give life to your data with an easy to use database ... I'll share cool FileMaker stuff for you, avoiding the programming part of it as much as I can.                        #WorkplaceInnovationPlatform #Claris
Your new post is loading...
Your new post is loading...
Scooped by Didier Daglinckx
Scoop.it!

FileMaker Pro 17 is here | Troi-plugin

FileMaker Pro 17 is here | Troi-plugin | Learning Claris FileMaker | Scoop.it

The release of version 17 of the FileMaker Platform brings a lot of new features.

 

An interesting post from Troi will give you a clear overview ...

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Troi URL Plug-in for FileMaker Pro 12 to 16

Troi URL Plug-in for FileMaker Pro 12 to 16 | Learning Claris FileMaker | Scoop.it
Send and receive data from any http URL


Troi URL Plug-in can help you fill in forms on internet, all from FileMaker Pro. It also retrieves data from any http URL.

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Parsing XML data in FileMaker Pro | FileMakerProGurus

Parsing XML data in FileMaker Pro | FileMakerProGurus | Learning Claris FileMaker | Scoop.it
Getting data from web sources is the trend in FileMaker (and all other languages) these days.  

With the popularity and breadth of web services available to your clients, it's no wonder they need it.

For example, your client may be using a web store order consolidation service, one that brings in all their orders from Amazon, e-Bay, and other similar online stores (OK, it just so happens I have a client doing this...).  

The consolidation service is valuable, but it is a large company and suffers from the large company curse:   It's not easy for them to customize for individual customers, which opens a door for enterprising developers willing to learn.

So when a client wants to get data from, or send data to, the service, it's up to the developer to find a solution.  

That means you need to find ways to make FileMaker talk to the service.

One very popular way data is offered to clients by companies like this is XML.

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Troi Text Plug-in for FileMaker

Troi Text Plug-in for FileMaker | Learning Claris FileMaker | Scoop.it

Parsing of XML data

With Troi Text Plug-in you can get XML nodes out of XML formatted text and parse the info into separate fields in your database. You can get the contents of the nodes and child nodes and the attribute data of the nodes.

Set creation

The ANDText, XORText and NOTText functions lets you find all lines that are the same in two text fields, are lines that are different in two text fields and all lines that are in one but not in the other text field.

Lines and Word functions

Troi Text Plug-in's Lines and Word functions let you return:

all unique lines of a text field
all unique words of a text field
all lines in a text field sorted alphabetically
the n-th line of a text field. No difficult calculations to get it, just ask for it!


SumText function

The SumText function creates a dynamic field that concatenates all text from a field in a related file.

Every time records get added to the related file the SumText is automatically updated.

It is the text equivalent of the Sum() function.
Please note that FileMaker Pro now has a List() function, which provides much of this functionality.

We have left the SumText function in to keep the plug-in backward compatible.

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Troi URL Plug-in for FileMaker Pro 13

Troi URL Plug-in for FileMaker Pro 13 | Learning Claris FileMaker | Scoop.it
Troi URL Plug-in lets you post and retrieve information from the Internet.  tweet from Filemakerretrieve web pages, imagesfill in forms on web sites or your intranetget online data like stock quotes, weather reports, etc.automatically add information to listings and online databasessearch the Internet for terms or other specific itemsget the postal code or time of your cityprocess credit cardsuse as a filemaker web services plug-in
No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Troi URL Plug-in for FileMaker Pro 12

Troi URL Plug-in for FileMaker Pro 12 | Learning Claris FileMaker | Scoop.it
The Troi URL Plug-in can GET, POST PUT or DELETE a URL. You can also use it as a filemaker web services plugin.
Didier Daglinckx's insight:
Also possible with the plugin ...Tweet from FileMaker Pro

Troi URL Plug-in 3 also contains three authorization functions, which make it very easy to work with a Twitter account and post tweets! We have included an example to get you tweeting in no time! There also adds several other improvements, like a new function to URL encode text.

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Troi Activator Plug-in 4.5 for FileMaker Pro 16

Troi Activator Plug-in 4.5 for FileMaker Pro 16 | Learning Claris FileMaker | Scoop.it
What is Troi Activator Plug-in?


Troi Activator Plug-in is a very powerful tool for triggering scripts remotely.

 

All from within FileMaker you can:

 

- trigger a FileMaker script on a different computer (remotely)
- trigger a FileMaker script over internet
- use the built-in security to prevent unauthorized triggering
- send a number (e.g. a record ID) and a long text with the trigger
- start and stop listening for remote trigger messages with one script step
- communicate with databases in different FileMaker versions or even runtimes


Except from remote triggering you can also use the Activator Plug-in for:


- triggering a script on a specified date and time
- scheduling events which trigger any script you want
- running a script from any FileMaker calculation, for example a tooltip calculation

- validating fields on exiting a record with a custom script suited to your specific needs

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

FileMaker Pro 16 is out: giant steps with external script steps!

FileMaker Pro 16 is out: giant steps with external script steps! | Learning Claris FileMaker | Scoop.it
A giant step
Congratulations to FileMaker, Inc. on the release today of version 16 of the platform.


Troi Plug-ins for FileMaker Pro 16
We have been working hard to prepare our plug-ins for FileMaker 16.

Later today we will release more information. Stay tuned or subscribe to our newsletter.


New: External script steps!


The release of Version 16 of the FileMaker Platform brings a lot of new features also for plug-ins.

 

...

 

New features in the FileMaker Platform

The release of Version 16 of the FileMaker Platform brings a lot of new features.

Here is a list:

Development improvements

  • Layout Objects window
  • Cards
  • PDF support in FileMaker Server and FileMaker WebDirect
  • New FileMaker Pro interface on Windows OS
  • Copy and paste value lists
  • Variables in FileMaker data source references
  • Enhanced Data Viewer

Integration

Connect to other data sources and get even more from your FileMaker apps

Trial Features

Get an early look at these new integration features

  • FileMaker Data API
  • Tableau Web Data Connector for FileMaker

Security

  • Get new tools to secure your custom apps
  • OAuth 2.0 support for accounts
  • Clickable security lock icons

Mobility (iOS)

  • Animations and transitions with scripts
  • Enhanced signature capture
  • Region-monitoring script

Scalability

  • Share data with even more users via a web browser
  • More User Connections in FileMaker WebDirect

 

Read more on Troi blog !

Didier Daglinckx's insight:

The release of Version 16 of the FileMaker Platform brings a lot of new features.

 

Here is a list ...

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Troi Serial Plug-in for FileMaker Pro 12, 13, 14 and 15

Troi Serial Plug-in for FileMaker Pro 12, 13, 14 and 15 | Learning Claris FileMaker | Scoop.it
Troi Serial Plug-in gives FileMaker Pro the ability to read from and write to the serial ports of the computer directly from within FileMaker Pro without the need of a separate application.

 

And it works completely cross-platform!

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Troi Dialog Plug-in for FileMaker Pro 10 through 13

Troi Dialog Plug-in for FileMaker Pro 10 through 13 | Learning Claris FileMaker | Scoop.it

Real dialogs that you completely control

Troi Dialog Plug-in adds powerful dialog functions to FileMaker Pro:


- see a full size dialog show dialogs with variable text and up to 4 buttons
- show temporary flash screens
- show a progress bar for lengthy operations
- show a list dialog
- show a big input dialog
- present images and movies fullscreen
- get the current date and time, including the fractions of a second
- let a user input text through a dialog with up to fifteen fields
- choose these input fields to be any of the following: simple text, password field, popup list or check box
- mix these input field types as you see fit
- pre-enter text into all input fields
- have the results of the dialog put into fields without parsing
position the dialog box anywhere on the screen
- add a standard icon or your own icons, in standard size or extra large
- add a custom icon from a PNG image, including transparency
- set the text for the dialog title bar


and more...

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Details on Troi File Plug-in for Filemaker

Details on Troi File Plug-in for Filemaker | Learning Claris FileMaker | Scoop.it

Troi File Plug-in is a very powerful tool for getting access to information outside the FileMaker Pro database.

Any files stored on the rest of the computer can be accessed through the functions of the plug-in.

 

Suggested Uses 

 

Troi File Plug-in can be used in a lot of ways.

 

Its 64 functions give you a universal tool that can be used in a lot of databases.

 

Below are a few suggestions on how Troi File Plug-in can be useful:

 

• Batch import of images, movies, sounds, text files, etc.

• Keep your database small, by storing only references to images

• Check integrity of files on disk

• Create a web site by exporting multiple HTML files

• Update solutions, by moving database files into place

• Read and write custom formatted files, for example from legacy systems

• Catalogue complete projects, including pictures

• Manage images, movies and other files.

• Launch files with their appropriate application directly from FileMaker Pro

 

No comment yet.
Scooped by Didier Daglinckx
Scoop.it!

Activator Plug-in for FileMaker Pro

Activator Plug-in for FileMaker Pro | Learning Claris FileMaker | Scoop.it
The Troi Activator Plug-in is a very powerful FileMaker plug-in for triggering scripts remotely. You can trigger a script on a different computer, at a certain time and do custom validation.
Didier Daglinckx's insight:

Ever wanted to tell other users you changed an appointment or ask someone to get out of a record?

 

Now you can with Troi Activator Plug-in!

 

The Activator is a very powerful tool for triggering scripts across the network, even over the Internet!

 The new version 3.5 is live
No comment yet.