lets

Functions
/
lets
Assigns values to multiple variables and evaluates the expression using those variables.
Accepts
All Data Types
Returns
All Data Types
Syntax
lets(variable, value, variable2, value2, ..., expression) variable.lets(value, variable2, value2, ..., expression)
JavaScript 
lets(
    a, "Hello",
    b, " world!",
    [a, b].join(" ")
)

 

JavaScript 
lets(
    a, "Hello",
    b, " world!",
    [a, b].join(" ")
)
JavaScript 
lets(
	date, prop("Date").dateAdd(1, "months"),
	lastDay, date.dateSubtract(date.date(), "days"),
	lastDay.day().test("6|7")
		? lastDay.dateSubtract(-5 + lastDay.day(), "days") 
		: lastDay
)
JavaScript 
lets(
	range, 
	prop("Dates").dateStart() != prop("Dates").dateEnd(),
	from, 
	range && prop("Dates").dateStart().test("AM|PM") 
		? prop("Dates").dateStart().formatDate("h:mm A") 
		: "",
	to, 
	range && prop("Dates").dateEnd().test("AM|PM") 
		? prop("Dates").dateEnd().formatDate("h:mm A") 
		: "",
	(from ? from : "")
	+ (from && to ? " → " + to : "")
)