'Yes or No' in Display Form to be inserted in SQL Non Query
Good Afternoon!
I have a very simple workflow that uses a Display Form to collect information from an inspector and submits that information into a SQL table.

My question is that some of the information that I want the inspector to collect are Yes or No questions. What is the best way to display this in the form (Two checkboxes maybe?) and then how would that data then be captured in the SQL Non Query task? Thanks so much!
0
-
Hi Lisa,
Yes, checkboxes or radio buttons would probably be the best option for collecting yes/no reponses. To capture that in the SQL Non-Query Activity, you can compile the the SELECT statement or command beforehand (perhaps using in a series of Assign activities) and then pass that into the SQL activity by filling in the parameter section. We do not have an example of a SQL Non-Query workflow, but this example here follows the same set up: https://support.geocortex.com/essentialsGSCCodeGallery?sub-nav=codegall&main-nav=essentials&#!/feedtype=SINGLE_ARTICLE_SEARCH_RESULT&id=kA460000000bljw
I hope this helps.
Regards,
Carmen
For example, you may have a variable called "0
Du måste logga in om du vill lämna en kommentar.
Kommentarer
1 kommentar