i am executed code to search a table in particular column. I am then trying to use an expression based on "if record exists" or if "record does not exist".
if we can nail this, this can have huge use cases...
here my excude code:
`const userInput = event.payload.text;
const record = await EmployeesTable.findRecords({}); // Get all records from EmployeesTable
const existingRecord = _.find(record, { 'pin': userInput }); // Find record with matching pin
if (existingRecord) {
console.log(
Record with pin ${userInput} already exists in EmployeesTable
);
} else {
console.log(
Record with pin ${userInput} does not exist in EmployeesTable
);
}`