Hi all, in the Quotes module, many of the columns for line items are too wide which then makes users scroll horizontally and they hate that.
is there a way to make them adjustable please?
Thank you
Hi all, in the Quotes module, many of the columns for line items are too wide which then makes users scroll horizontally and they hate that.
is there a way to make them adjustable please?
Thank you
Hello,
Go to custom/modules/Quotes/metadata/editviewdefs.php , If file is not exist then copy it from modules/Quotes/metadata/editviewdefs.php and
modify name field array to have
'displayParams'=>array('size'=>100),
Do quick repair & rebuild from admin.
You can modify the width of QLIs columns by adding the attribute 'widthClass' inside each field def:
<?php $viewdefs['Products']['base']['view']['quote-data-group-list'] = array ( 'panels' => array ( 0 => array ( 'name' => 'products_quote_data_group_list', 'label' => 'LBL_PRODUCTS_QUOTE_DATA_LIST', 'fields' => array ( 0 => array ( 'name' => 'line_num', 'label' => NULL, 'widthClass' => 'cell-xsmall', 'css_class' => 'line_num tcenter', 'type' => 'line-num', 'readonly' => true, ), 1 => array ( 'name' => 'product_template_name', 'label' => 'LBL_ITEM_NAME', 'widthClass' => 'cell-xlarge', 'type' => 'quote-data-relate', 'required' => true, 'initial_filter_label' => 'LBL_FILTER_POPUP', 'filter_populate' => array ( 'stage_c' => array ( 0 => 'ativo', ), ), ), 2 => array ( 'name' => 'unit_quantity_c', 'label' => 'LBL_UNIT_QUANTITY', 'widthClass' => 'cell-small', 'css_class' => 'quantity', 'type' => 'float', ), 3 => array ( 'name' => 'unit_measure_c', 'label' => 'LBL_UNIT_MEASURE', 'type' => 'varchar', ), 4 => array ( 'name' => 'unit_price_c', 'label' => 'LBL_UNIT_PRICE', 'type' => 'currency', 'convertToBase' => true, 'showTransactionalAmount' => true, 'related_fields' => array ( 0 => 'unit_price_c', 1 => 'currency_id', 2 => 'base_rate', ), ), 5 => array ( 'name' => 'quantity', 'label' => 'LBL_QUANTITY', 'widthClass' => 'cell-small', 'css_class' => 'quantity', 'type' => 'float', 'related_fields' => array ( 0 => 'packing_quantity_product_c', 1 => 'unit_quantity_c', ), ), 6 => array ( 'name' => 'discount_price', 'label' => 'LBL_DISCOUNT_PRICE', 'type' => 'currency', 'convertToBase' => true, 'showTransactionalAmount' => true, 'related_fields' => array ( 0 => 'discount_price', 1 => 'currency_id', 2 => 'base_rate', 3 => 'quantity', 4 => 'unit_price_c', 5 => 'unit_quantity_c', ), ), 7 => array ( 'name' => 'product_unit_item_c', 'label' => 'LBL_PRODUCT_UNIT_ITEM', 'type' => 'varchar', ), 8 => array ( 'name' => 'operation_type_c', 'label' => 'LBL_OPERATION_TYPE', 'type' => 'enum', ), 9 => array ( 'name' => 'warehouse_c', 'label' => 'LBL_WAREHOUSE', 'type' => 'enum', ), 10 => array ( 'name' => 'quality_certificate_c', 'label' => 'LBL_QUALITY_CERTIFICATE', 'type' => 'bool', ), 11 => array ( 'name' => 'customer_item_position_c', 'label' => 'LBL_CUSTOMER_ITEM_POSITION', 'type' => 'int', ), 12 => array ( 'name' => 'item_number_xped_c', 'label' => 'LBL_ITEM_NUMBER_XPED', 'type' => 'int', ), 13 => array ( 'name' => 'ncm_item_c', 'label' => 'LBL_NCM_ITEM', 'type' => 'varchar', ), 14 => array ( 'name' => 'icms_tax_c', 'label' => 'LBL_ICMS_TAX', 'type' => 'float', ), 15 => array ( 'name' => 'st_value_c', 'label' => 'LBL_ST_VALUE', 'type' => 'currency', ), 16 => array ( 'name' => 'ipi_tax_c', 'label' => 'LBL_IPI_TAX', 'type' => 'float', ), 17 => array ( 'name' => 'total_amount', 'label' => 'LBL_SUM_SUBTOTAL_TAX', 'convertToBase' => true, 'showTransactionalAmount' => true, ), 18 => array ( 'name' => 'packing_quantity_product_c', 'label' => 'LBL_PACKING_QUANTITY_PRODUCT', ), ), ), ), );
I'm not a full dev, so before I attempt or ask a dev to package this up for me, can you confirm the expectations of this customisation, will it allow users to adjust column widths using mouse same as other similar layouts ?
hi Andre'
Cann you let me know if I understood your solution correctly please?
so does it mean each field width needs to be hardcoded, wheras solution from Bruce would allow each user to set the widths as they want?
hello Tony,
a few ideas that might be of help to reach better user adoption with less additional investments:
1.Show users how to hide right Panel View
2. Review a list of QLI columns, keeping really necessary fields in it - the list of fields to view in the QLI list is configurable in the Admin section
3. Hardcode the size of the QLI columns by setting columns widths that enable reviewing 80% of Quotes with no scrolling - might need some developers efforts
4. Equip users with higher resolution monitors - this could look confusing, but it is often reasonably cheaper than paying for hours of raw code development /testing/deployment or custom styles adjustments according to regular US/EU/UK rates
Best Regards,
Dmytro Chupylka
integroscrm.com
We make work in Sugar CRM system faster, more convenient and efficient
Yes, the solution I provided is a hardcoded size for each column. The solution from Bruce will not work once metadata/editviewdefs.php is not loaded anymore since version 7.0.