Made a field hidden on task table, but now it is not reportable, why would that happen?

[snow_beginner]

Hi, so there is a field 'Escalation Reason' which is a drop down field with 7 choices. It is present on the incident_task table and when a user escalates an incident, the value is captured in that field.

The ask was to make it a hidden field but still it should capture data and be reportable. I made it hidden by using the slush bucket in the form layout and moving it to the left side. However, now when a report is run, the reason is not captured. How can I fix this. Attached is a screen shot of the issue

So looking at the graph, this field was created in May last year and all the lines (blue colors) represent the escalation reasons for each of the month when it this report was run. The person ran it today (in January) and there is no data for the escalation reason (no blue line - he chose the reason as customer impacting). Why is this happening? How can I fix it?

[Dr Atul G- LNG · Accepted solution]

Hi @snow_beginner 

The reason can be data is so small ad ranges are more , so it is look like No line.

[Oya Orhan]

Hi there,

The field you hid cannot get its value. Check the new records if the field has a value.

If the field doesn't have the value, you can set its value by using business rule running for insert and update regarding to your requirement. You'll also need the a fix script to set the field's value for the related records.

I hope this helps.

Oya

[snow_beginner]

Hi,

The field does have a value in it. Although it is no longer visible on the incident_task form view, it is present in the list view and it has a value 'customer impacting'

[Dr Atul G- LNG]

Hi @snow_beginner 

Hi, so there is a field 'Escalation Reason' which is a drop down field with 7 choices. It is present on the incident_task table and when a user escalates an incident, the value is captured in that field.

Atul: Understood .

The ask was to make it a hidden field but still it should capture data and be reportable.

Atul: If you want to hide , dont bring the field on form.  and Data capture, you can use script / BR to capture the data.

I made it hidden by using the slush bucket in the form layout and moving it to the left side. However, now when a report is run, the reason is not captured. How can I fix this. Attached is a screen shot of the issue

Atul: Try to run the same in list view first, may be these is no data exists for these 2 days or it is not satisfying the overall run condition.

[snow_beginner]

Hi @Dr Atul G- LNG 

There is data in the field. I am able to see the selction 'Customer Impacting' in the list of the the incident_task table. See attached picture.