Clear(colGridData);
ForAll(
Gallery2.AllItems,
Collect(
colGridData,
{
'Date of Material Request': DateofRequestDC.SelectedDate,
Requisitioner: RequisitionerDC.Selected,
'Rig Name': RigNameDC.Selected,
'Well Number/Location': WellNumberDC.Text,
Field: FieldDC.Selected,
'Date Required on Rig Site': DateReqOnRigSiteDC.SelectedDate,
'Job Type': JobTypeDC.Selected,
'Date Rig Moved on Location': DateRMOLDC.SelectedDate,
'Item Description': ItemDesDC.Selected,
'Quantity Requested': QTYREQDC.Selected,
'Quality of Materials Requested': qualityofmaterialrequestedDC.Selected,
'Noted/General Comments': NotesDC.Text,
'Quantity Dispatched': quantitydispatchedDC.Selected,
'Date Items Dispatched': DateItemsDispDC.SelectedDate,
Dispatcher: DispatcherDC.Selected,
'Truck Number': TruckNumberDC.Selected,
'Status of Request': STATUSOFREQUESTDC.Selected
}
)
);
Patch('Material Request Grid Data',{'Items Description Text ': "<table border='1' width= '100%'>" & "<th>Date of Material Request</th><th>Requisitioner</th><th>Rig Name</th><th>Well No/Location</th><th>Field</th><th>Date Required on Rig Site</th><th>Job Type</th><th>Date Rig Moved on Location</th><th>Item Description</th><th>Quantity Requested</th><th>Quality of Material Requested</th><th>Notes/Comments</th><th>Quantity Dispatched</th><th>Date Items Dispatched</th><th>Dispatcher</th><th>Truck Number</th><th>Status of Request</th>" &
Concat(colGridData, "<tr><td>" & 'Date of Material Request'& "</td><td>" & Requisitioner.DisplayName & "</td><td>" & 'Rig Name'.Value & "</td><td>" & 'Well Number/Location' & "</td><td>" & Field.Value & "</td><td>" & 'Date Required on Rig Site' & "</td><td>"& 'Job Type'.Value & "</td><td>"& 'Date Rig Moved on Location' & "</td><td>" & 'Item Description'.Value & "</td><td>" & 'Quantity Requested'.Value & "</td><td>" & 'Quality of Materials Requested'.Value & "</td><td>" & 'Noted/General Comments' & "</td><td>" & 'Quantity Dispatched'.Value & "</td><td>" & 'Date Items Dispatched' & "</td><td>" & Dispatcher.DisplayName & "</td><td>" & 'Truck Number'.Value & "</td><td>" & 'Status of Request'.Value & "</td><td>" & "</Table>"})
