Get Latest Date from Linked Form – No Script

Hi Bernie,

You would have to use a Script for this function.

There’s a function designed for getting the maximum value, but it only works for Number fields right now:

var max_value = record.getMaxOfLinkedFieldForField(linkedFieldID, fieldID);

But you could loop through the linked records manually and pick out the largest date value.

Sorry it can’t be done with a Calculation field though.

Here’s an example script that would do what you want:

function getMaxDate() {

	var orders_id = 'fld-41443e967b3c4bdd8e258eabef7ffc8c';
	var date_id = 'fld-3604363a4c07424294113852f4b3651e';
	
	var orders = record.getFieldValue(orders_id);

	var largest_date;
	
	for (var index = 0, count = orders.length; index < count; index++){
     	var date = orders[index].getFieldValue(date_id);
     	
		if (date) {
			// do something
			if (largest_date == undefined || largest_date.getTime() < date.getTime()) {
				largest_date = date;
			}
		}
	}
	
	return largest_date;
}

getMaxDate();

You would need to replace the fld-.... parts with the field IDs of your own fields though.

function LastDeliveryDate() {

var wellprodid = ‘fld-e5cb08e10b2c4f5ba277f18ad72b4ebd’;
var date_id = ‘fld-6700311b49074f97969c8a3780d63935’;

var delivery = record.getFieldValue(wellprodid);

var largest_date;

for (var index = 0, count = delivery.length; index < count; index++){
var date = deilvery[index].getFieldValue(date_id);

if (date) {
// do something
if (largest_date == undefined || largest_date.getTime() < date.getTime()) {
largest_date = date;
}
}
}

return largest_date;
}

LastDeliveryDate();

This is returning

5/1/24, 6:37:16 PM / Delivery Chemicals / LastDeliveryDate

LastDeliveryDate: TypeError: undefined is not an object (evaluating ‘delivery.length’), line:(null)

Yes I am I am joining Delivery Chemicals to Delivery form with a Join WellProdId=WellProd.  This will pull all deliveries to that location but I want to pull the last delivery date and the amount of gallons delivered at that time.

To me, it looks like var delivery = record.getFieldValue(wellprodid); doesn’t return any records. Is wellprodid correctly set?