Select + Date + Date + Select

📅 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?

If you require assistance or encounter any issues, please don't hesitate to contact us for further support.