Script trigger based on new record creation in external table

[Dagel]

I would like to run a script whenever FM recognizes that a new record has been added to my external MySQL table (orders). Since I don't believe FM offers any native script triggering capability for this, my thought was to set a global field with the total number of records in the orders table and then run a scheduled server script which would compare the count in that global with the current count, post the orders, then set the global with the new count.

I think that would work but I'm concerned what would happen if one or more records get added to the orders table while the script is running.

I guess I could add a field to the orders table that FM could write to indicating an order has been posted and then do a find based on that.

Any 'best practices' suggestions for this scenario would be greatly appreciated.

Thanks!