FOF / Microsoft SQL Database Connector
I'm starting to investigate the possibility of having data from a Forms on Fire form (and probably therefore a Data Source) synced with a SQL database. Could you give me a bit of clarity on how that would work? Here's the use case:
- Field user inputs data on a form and uploads to the platform.
- Specific fields from the form are synced to a MS SQL server database and inputted into specific fields there, overwriting existing data if present.
Is it possible to have this level of control over the sync?