ABCDE
1
Template Version : 5.1.0
2
General Instruction to fill this observation solution template
3
Recommended: We suggest you use a unique resource name to avoid duplication in reports.
4
Don't change any labels of the tab and Don't change any column name's in each sheet
5
Take the help of the 1st row in each tab with 'Description of each field' as mentioned in below to understand what needs to be filled in a particular column
6
Note: Please avoid the special characters like double quotes(") and new-line(\n or an enter key) characters which are not allowed in our system as they may create issues in the reports.
7
8
Colour Codes to followHeader ColorQuestions Tab
9
Description of each fieldKeywordsDescription
10
Mandatory Fieldcriteria_idselect criteria_id from drop-down provided for each questions
11
Optional Fieldquestion_sequencewrite the order of the question, how you want to see them on App(e.g. 1,2,3...)
12
Conditionally Optional Fieldquestion_idUnique ID for each question (Alphanumeric)
13
instance_parent_question_idIf it is a instance type Solution, write the instance_parent_question_id
otherwise leave this column as empty
14
Details Tabparent_question_idWrite the parent_question_id, if it a child question (i.e. dependent question on other)
15
KeywordsDescriptionshow_when_parent_question_value_isUse the appropriate mathematical operator(Equal or > or < etc.) as per your questionnaire need
16
observation_solution_nameWrite a meaningful name of your observation solutionparent_question_valueWrite the 'response' of the parent question if this is a child question and particular response of parent question dependent on it. i.e write R1 or R2 or R3....... as per its dependency.
17
observation_solution_descriptionWrite a brief description about the observation solutionpage Select the Page no. against each question (P1, P2, P3.....), Based on your Page selection that question will appear on mobile screen. Example: If 3 questions have selected as P1 only, all three question will come on single screen.
18
Diksha_loginIdWrite your platform login ID (UserID of the observation solution Designer )question_numberYou may use 1,2,3.... or a, b, c.... or i, ii, iii.....etc. as numbering your questionnaire
19
languageLanguage of the observation solutionquestion_primary_languageWrite the Primary language name in which you are creating your solution (e.g. English)
20
section_nameName of the section which is going to be created (write some meaningful section label)question_secondory_languageIf you want to show your questionnaire in other language as well, you may write here(e.g. Kannada)
21
keywordsWrite some appropriate keywords question_tipIf you want add tip to your question, you may write the tip text in this column
22
scoring_requiredIf Observation is point-based scoring set to TRUE else leave it blankquestion_hintTo add hint to the question, write the hint text here.
23
entity_typePlease select any 1 of the entiy type of observation from the drop down providedinstance_identifierIf it is a instance type Solution, write the instance_identifier here. This will be label as ADD instance identifier text
24
question_response_typeSelect the question-response-type from the drop-down list as per question's need
25
date_formatUse the date format (DD-MM-YYYY) user will be able to edit the date once enter (Note: This is recommended date format)
26
Criteria Tabdate_auto_captureUse auto_capture only if you don't want let your user edit the date of observation once entered.
27
KeywordsDescriptionresponse_requiredIf the question is mandatory to anwser, Select TRUE option
28
criteria_idUse any unique alphanumeric text as criteria_id min_number_valueWrite the minimum number allowed to enter in case of data entry(number) & Slider type question
29
criteria_namewrite the name of the criteriamax_number_valueWrite the maximum number allowed to enter in case of data entry(number) & Slider type question
30
file_uploadIf evidences is required to attach for a particular question, Select as TRUE else FALSE
31
allow_audio_recordingIf you want to record the evidences in the form of audio, you any select as TRUE
32
show_remarksIf you want to show add remark option after that question so that assessor can add the remark, you may select it as TRUE
33
response(R1)Write your first response here
34
response(R2)Write your second response here
35
response(R1)_hintWrite the hint for your response 1(if needed) else leave this column
36
response(R2)_hintWrite the hint for your response 2(if needed) else leave this column
37
response(R1)_scoreScore to be given if option 1 is selected, leave blank if not required.

Note: fill column response(R1)_score to response(R15)_score only if observation is point-based-scoring else leave it blank
38
slider_value_with_scorescore for slider question.
The format to fill this column :
based on min_number_value and max_number_value column
min_number_value : score for this slider value , min_number_value + 1 : score for this slider value , ...... , max_number-value : score for this slider value.

Ex : if min_number_value = 1 , max_number_value = 5 .
Format :- 1:0.5,2:1.5,3:2.5,4:3.5,5:4.5

Note : Fill this column only if observation is point-based-scoring else leave it blank
39
question_weightageweightage for each question

Note : Fill this column only if observation is point-based-scoring else leave it blank
40
section_headerWrite the section header title here