lookupObj not returning record

Questions
1

Hi all,

I’m currently working with the lookupObj from the svyLookup module and I’m not sure what I’m doing wrong, but the onSelect function isn’t letting me use the record param it’s given. Whenever I application.ouput(record.contact_uuid) it returns , but if I application.ouput(record) it returns the selected record. I’ve tried this twice now, with the current form I’m working on, and with the orderItemsTable in the cloud sample solution, both of which haven’t worked in their specific ways.

Here is the current form im working on:

function onSelect(record, values, lookup) {
	
	var contactFoundset = datasources.db.cpro.contacts.getFoundSet()
	contactFoundset.find()
	contactFoundset.contact_uuid = record.contact_uuid
	var found = contactFoundset.search()
	application.output(contactFoundset)
	application.output(record)
	if (found > 0) {
		var currentContact = contactFoundset.getRecord(1);
	    if (record) {
	        var newOrder = currentContact.contacts_to_orders.createRecord()
	        if (!databaseManager.saveData(newOrder)) {
	            plugins.dialogs.showErrorDialog('Error', 'Failed to create a new order for the selected contact.');
	            return;
	        }
	        scopes.global.showForm(forms.orderEdit, newOrder);
	    }
	}
}

Here is the orderItemsTable function:

function onSelect(record, values, lookup){
	if (values && values.length) {
		foundset.pricelist_fk = values[0];
	}
	
	if(record) {
		record.forEach(function(rec){
			
			if (foundset.selectRecord(foundset.pricelist_fk,rec.pricelist_uuid)) {
				// increase quantity if product already in order
				foundset.quantity = foundset.quantity + 1;
				
			} else if(foundset.selectRecord(foundset.stock_fk,rec.stock_uuid)) {
				// increase quantity if product already in order
				foundset.quantity = foundset.quantity + 1;
				
			} else {
				// create a new order line for each product selected in lookup
				var newRec = foundset.getRecord(foundset.newRecord())
				newRec.quantity = 1;
				newRec.make = rec.make;
				newRec.model = rec.model;
				newRec.price = rec.price;
				newRec.serial_number = rec.serial_number
				updateStock(0, 1, newRec)
			}

		})
	}
	orderTotal()
}

For the order items table, I basically copied over the code from the cloud sample solution, but it hasnt seemed to work with anything I try.

Also I was wondering whether you can make the lookupObj.setMultiSelect(false) but have the form searchable at the same time?

Thanks!
Alasdair

2

Managed to get it working, I didn’t realise you had to treat record as an array instead of a record.
Here’s my new code for anyone interested.

Current form:

function onSelect(record, values, lookup) {
	var contactUUID = record[0].contact_uuid
	var currentContact = foundset.getRecordByPk(contactUUID);
    if (record) {
        var newOrder = currentContact.contacts_to_orders.createRecord()
        if (!databaseManager.saveData(newOrder)) {
            plugins.dialogs.showErrorDialog('Error', 'Failed to create a new order for the selected contact.');
            return;
        }
        foundset.removeFoundSetFilterParam('type')
        scopes.global.showForm(forms.orderEdit, newOrder);
    }
}

orderItemsTable:

function onSelectPricelist(records, values, lookup) {
	if(records) {
		for (var i = 0; i < records.length; i++) {
			var record = records[i];
			var fk = record.pricelist_uuid;
			foundset.find()
			foundset.pricelist_fk = fk
			var found = foundset.search()
			if (found) {
				var matchingRecord = foundset.getRecord(1);
				matchingRecord.quantity += 1;
				foundset.loadAllRecords()
			} else {
				// create a new order line for each product selected in lookup
				var newRec = foundset.getRecord(foundset.newRecord())
				newRec.quantity = 1;
				newRec.make = record.make;
				newRec.model = record.model;
				newRec.price = record.price;
				newRec.pricelist_fk = record.pricelist_uuid
				foundset.loadAllRecords()
				updateStock(0, 1, newRec)
			}
		}
	}
	orderTotal()
}

function onSelectStock(records, values, lookup) {
	if(records) {
		for (var i = 0; i < records.length; i++) {
			var record = records[i];
			var fk = record.stock_uuid;
			foundset.find()
			foundset.pricelist_fk = fk
			var found = foundset.search()
			if (found) {
				var matchingRecord = foundset.getRecord(1);
				matchingRecord.quantity += 1;
				foundset.loadAllRecords()
			} else {
				// create a new order line for each product selected in lookup
				var newRec = foundset.getRecord(foundset.newRecord())
				newRec.quantity = 1;
				newRec.make = record.make;
				newRec.model = record.model;
				newRec.price = record.serial_number;
				newRec.pricelist_fk = record.stock_uuid
				foundset.loadAllRecords()
				updateStock(0, 1, newRec)
			}
		}
	}
	orderTotal()
}