Scripting Logic for IF-Then-Else

Hey ​@KenF,

I do not code, nor did I gave the following a shot, but you might want to test this out (Claude generated :D):

 

let {foundRecordNames, foundRecordDate, linkedRecordID, valStartupID, prevStatus} = input.config()

let table = base.getTable('TRK: 360° ASSESSMENT')
let recordsToCreate = new Array;

for (let i = 0; i < foundRecordNames.length; i++){
    let previousStatus = prevStatus[i];
    let currentStatus = (previousStatus !== "First Assessment" && previousStatus !== "Not Assessed")
        ? previousStatus
        : "Not Assessed";

    recordsToCreate.push({
        fields:{               
            "Previous Assessment Status": {name: previousStatus},
            "Current Assessment Status": {name: currentStatus},
            "Area Assessed": [{id: foundRecordNames[i]}],
            "TRK: ASSESSMENT": [{id: linkedRecordID}],
            "Startup Name": [{id: valStartupID}],
            "Assessment Date": foundRecordDate            
        }
    })
}

Completely different matter, but would love to have you join the March 2026 AT Community led Hackathon! Make sure to sign up!!

Mike, Consultant @ Automatic Nation 
YouTube Channel

Straightforward conditional. Inside the loop, resolve the value before building the record object:
                                                                                         
  for (let i = 0; i < foundRecordNames.length; i++) {
                                                                                               let currentStatus = (prevStatus[i] !== "First Assessment" && prevStatus[i] !== "Not
   Assessed")
          ? prevStatus[i]
          : "Not Assessed";

      recordsToCreate.push({
          fields: {
              "Previous Assessment Status": { name: prevStatus[i] },
              "Current Assessment Status": { name: currentStatus },
              "Area Assessed": [{ id: foundRecordNames[i] }],
              "TRK: ASSESSMENT": [{ id: linkedRecordID }],
              "Startup Name": [{ id: valStartupID }],
              "Assessment Date": foundRecordDate
          }
      });
  }

  The key piece is the ternary:

  let currentStatus = (prevStatus[i] !== "First Assessment" && prevStatus[i] !== "Not    
  Assessed")
      ? prevStatus[i]    // use previous value
      : "Not Assessed";  // default

  Both conditions use !== (not equal) joined by && (and) — so it only carries forward the
   previous status when it's a "real" assessment value, not one of the two excluded      
  statuses.

Gents… Thank you both so much. ​@Mike_AutomaticN ​@NickEFSJ 

Script works perfectly... Appreciate your help!