Hey guys,
I made a table that gets certain variables from a form once the form is submitted. The table is as follows:
This table gets User Names, the RITMs and the Date variable from the form.
I wanted to create a report with all three of these variables but in the report, only the User name and the RITM is being displayed and the Date appears blank:
What can be the reason for this and how do I fix this?
Thank you!
Hey Allen,
I meant to say that everything displays the same way in the Report as it does in the table except that the Date Column in the report has no variables in it, like the table does.
I did as you said and changed the name of the Date variable to OfficeDates to see if I was pulling the right date variable.
It seems that I was but it is still not displaying under the Date Column in the Reports for some reason...:
As you can see, no dates appear under the OfficeDates Column in the Report 😞
Is there anything else I can try?
If it matters, I loop through the form and obtain the values of the variables in a workflow. Here is my workflow code:
var array = (current.variables.officeListCAddUsers+'').split(','); //parse list collector
var len = array.length;
for(var i = 0; i < len; i++){
var grAddUser = new GlideRecord('u_office_365_users');
grAddUser.initialize();
grAddUser.setValue('u_add_user',array[i]);
grAddUser.setValue('u_requested_items',current.sys_id);
grAddUser.setValue('u_date', current.variables.needed_by);
grAddUser.insert();
}
u_date is the name of the Date Column in my table. needed_by is the name of the Date variable in the form.
