📅 Combine two selected fields with two date fields.
1. Overview
This Interaction is used where selected values from "select" fields and dates from "date" fields are combined to create a new value for a select field.
2. Example
In this example, the function combines information from selected fields (participant, plan-start-date, plan-end-date, and ndis-funds-management-mechanism) and creates a new value for the name field by concatenating these values.
async function handler(clev) {
let returnCommands = { values: {}, fieldMeta: {} };
let participantSelect = clev.getValue("participant");
let participantObject = await clev.api.getEntry({
recordId: "661815",
responseType: "iov",
id: participantSelect,
});
let participantFullName = participantObject["full-name"];
let planStartDate = clev.getValue("plan-start-date");
let planEndDate = clev.getValue("plan-end-date");
let ndisSelect = clev.getValue("ndis-funds-management-mechanism");
let ndisObject = await clev.api.getEntry({
recordId: "661817",
responseType: "iov",
id: ndisSelect,
});
let ndisName = ndisObject["name"];
let name = clev.getValue("name");
if (
participantFullName.length > 0 &&
planStartDate.length > 0 &&
planEndDate.length > 0 &&
ndisName.length > 0
) {
returnCommands.values.name =
participantFullName +
" " +
planStartDate +
" / " +
planEndDate +
" " +
ndisName;
return returnCommands;
}
}📌 Need Help?
