Issue
Using AI Build to pick up a selection in a paper form across 5 fileds, you know a rating system 1 -5
AI builder is trained and works well picking up the selection.
So the data extracted from the forms ok comes in as individual fields
for example:
Question1_Strong_disagree : unselected
Question1_disagree : unselected
Question1_ Neutral : selected
and so on (hopefully one selection only)
Question
How can i find the selected option then apply a value on the selection. Kinda of like like a count if for excel if strong_disagree= selected question1_mark = 1, if strong_agree selected question1_mark = 5
Then i guess error handling if it finds 2 selected for one value?
Any thoughts could be appreciated
Paper forms example
Strong Disagree | Disagree | Neutral | Agree | Strong Agree | |
Question 1 | X | ||||
Question 2 | x | ||||