Answered
FOF / Microsoft SQL Database Connector
Sam Calderon
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?
Glad to hear you are looking into MS SQL implementation, it is a very useful connector.
In the MS SQL form connector you can uncheck the box that says automaintain table, and write your own sql scripts there. So you could UPDATE as well by using that custom piece.