One of my favorite features in FileMaker 19 is the new, undocumented script step, Execute FileMaker Data API.
The FileMaker Data API used to be a FileMaker Server only feature, used to integrate FileMaker data to a web service or a workflow. It is now available on the client side (FileMaker Pro) !
As I already wrote, it could be improved and I hope it will be in later releases, but it’s already a game changer.
Today I’m sharing a technique based on it, hope I made it understandable.
You can skip the long intro where I explain WHY I’m doing this by going directly to 5:40.