Updated question answers not pulling through in report

[Adnan Zamurred]

Hi, 

Once a request is logged e.g. a Problem, we have situations where the initial assessment may need changing. So for example, if the submission said the impact is 200 people, and I go into the question and change it to 300, the report set up still shows 200 and not the updated entry? Is there a way that the report shows what the new question field answer is? 

 

[Victor]

19 minutes ago, Adnan Zamurred said:

the report set up still shows 200 and not the updated entry? Is there a way that the report shows what the new question field answer is?

What report? Like an actual report or ... ?

[Adnan Zamurred]

Hi @Victor,

 

Yes an actual report built in service manager pulling custom fields through

[Victor]

@Adnan Zamurred is the answer to the question (the value) mapped to a custom field? ... if yes, I assume the report uses the values from the custom fields?

 

[Adnan Zamurred]

@Victor,

 

Yes the answers are mapped to the custom fields e.g. custom field B. So once its submitted, if change/edit the answer, would that not update the custom field? 

[Victor]

@Adnan Zamurred no, it won’t update the mapping

[Adnan Zamurred]

@Victor, 

Thanks for getting back. My question is, is there another way to do this? Maybe something I am missing? 

[Victor]

19 minutes ago, Adnan Zamurred said:

is there another way to do this? Maybe something I am missing?

No, you're not doing anything wrong. Is just that custom field won't get updated if you edit the question/answer on a request.

Now, you can theoretically retrieve the updated info from the Q&A table for requests however, due to how the data is stored in there (on rows as opposed to columns), it won't look pretty in a report...