Quickstart

const recordId = input.config().recordID.trim();
let table = base.getTable("YSWS Project Submission");

const queryResult = await table.selectRecordAsync(recordId);

if (queryResult == null) {
    throw new Error(`Record with ID "${recordId}" not found in table "YSWS Project Submission"`);
}

const data = {
    first_name: queryResult.getCellValue("First Name"),
    last_name: queryResult.getCellValue("Last Name"),
    idv_rec: queryResult.getCellValue("idv_rec"),
    email: queryResult.getCellValue("Email")
};

const searchParams = new URLSearchParams(data).toString();
const requestUrl = "https://submit.hackclub.com/api/verify?" + searchParams;

const response = await fetch(requestUrl).then(res => res.json());

table.updateRecordAsync(recordId, {
    "idv_verified": response.verified
});