Latest Contributions by DougBrowning

I am not sure since I keep seeing weird things with your csv file. When I open in excel I get this with ; FA0069920;FURNITURE AND FITTINGS;AIR CONDITIONER;AIR CONDITIONER - MIDEA;GOLDAIR;RM000501;M MKHABELA;MAIN BUILDING;FIRST FLOOR;RM000501;;EXCELLANT FA0069290;FURNITURE AND FITTINGS;AIR CONDITIONER;HIGHBACK 1;Highback;RM000501;M MKHABELA;MAIN BUILDING;FIRST FLOOR;RM000501;;EXCELLANT In Notepad same thing BARCODE;SERIAL_NUMBER_PLATE;ASSET_DESCRIPTION;ROOMNUM;ROOM_DESCRIPTION;BUILDING;FLOOR;SITE_DESCRIPTION;RESPONSIBLE_PERSON;ASSET_CATEGORY_ID;CATEGORY;SUB_CATEGORY;SUB_CATEGORY_DESCRIPTION_FOR_DEPRECIATION;CONDITION 5727;N/A;4 DRAWERS - CABINET - STEEL  If I import from txt in Excel I get this IF i use ; as the delimiter ASSETCODE ASSETCATEGORY ASSETTYPE PRODUCTNAME ASSETNAME ROOMDESCRIPTION RESPONSIBLEPERSON BUILDINGNAME FLOOR ROOMNO SERIALNO CONDITION FA0069920 FURNITURE AND FITTINGS AIR CONDITIONER AIR CONDITIONER - MIDEA GOLDAIR RM000501 M MKHABELA MAIN BUILDING FIRST FLOOR RM000501 EXCELLANT FA0069290 FURNITURE AND FITTINGS AIR CONDITIONER HIGHBACK 1 Highback RM000501 M MKHABELA MAIN BUILDING FIRST FLOOR RM000501 EXCELLANT FA0069281 FURNITURE AND FITTINGS CABINETS AND CUPBOARDS PEDESTAL PEDESTAL RM000501 M MKHABELA MAIN BUILDING FIRST FLOOR RM000501 EXCELLANT FA0069289 FURNITURE AND FITTINGS CABINETS AND CUPBOARDS PEDESTAL PEDESTAL RM000501 M MKHABELA MAIN BUILDING FIRST FLOOR RM000501 EXCELLANT FA0069291 FURNITURE AND FITTINGS CABINETS AND CUPBOARDS PEDESTAL PEDESTAL RM000501 M MKHABELA MAIN BUILDING FIRST FLOOR RM000501 EXCELLANT I am now not seeing a , but I way have used the wrong sheet. In the end I think you somehow set it to use ; instead if , - then called it a csv - which is really is not. I have attached a fixed version.  You could also use external_choices tab by a copy/paste instead. ... View more

When there is a username inspector hides - which causes it to go to "".  Whenever any field hides due to the relevant it will always blank the field (it does NOT just hide it but sets it to empty string).  So above when there is a username the field hides - which overrides the calculation and blanks it. Remove the calculation from inspector Use an if in the label. if( ${username} = '', concat("Inspector: ", ${inspector}), concat("Inspector: ", ${username})) ... View more