Analytic App

Question

Hi,

Trying to create a workflow for the Users, like I have one table in SQL server database and the table has 2 columns (FirstName, LastName),

Now, I want to create something that users can just pass the parameters like they can just enter the FirstName and lastname in the Text box tool and it should be insert as new row to that table.

Please advise!

Many thanks..

jrgo · Accepted Answer

Hi @ppatel

Unless there's some detail I'm missing, it should be a pretty straight forward app. Just set up your output tool to where it needs to record to and be sure you set the "Output Options" correctly. Workflow attached.

LordNeilLord · Accepted Answer

Hey @ppatel

I'd go for something simple by updating a text input tool and then appending to your SQL server (I use the select tool to just for the length to 255)