Skip to main content

Hi everyone.  I'm not a coder so have been relying on ChatGPT to help me with scripts.  It gave me this one for a spellchecker that looks in a field for misspellings of the word "epilepsy".  I have checked the name of the field and of the table are correct and filled in accordingly, but when I run the script, nothing happens.  No error message, it just runs and the console remains empty.  Any ideas what's going on?  Here is my script:

 

 

 

 

// Define the table and field you want to check
var tableName = "YourTableName"; // Replace with your actual table name
var fieldName = "YourFieldName"; // Replace with your actual field name

// List of common misspellings
var misspellings = ["epilepsey", "epilipsy", "epilepcy", "epilepsy",
"eppilepsy", "epillepsy", "epilepsy", "epliepsy",
"epilespy", "epilepsie"];

// Function to search for misspellings
async function findMisspellings() {
var table = base.getTable(tableName);
var query = await table.selectRecordsAsync();
var foundMisspelling = false;

console.log(`Checking records in ${tableName} for misspellings in ${fieldName}...`);

query.records.forEach(record => {
var text = record.getCellValueAsString(fieldName);
if (text) {
misspellings.forEach(misspell => {
if (text.toLowerCase().includes(misspell)) {
console.log(`Misspelling found in record ${record.id}: ${misspell}`);
foundMisspelling = true;
}
});
}
});

if (!foundMisspelling) {

 

 

 

 

Sorry, I don’t know scripting, so someone else will need to help you there. But if you want to do this in a no-code way that doesn’t require any scripting or coding at all, you can always integrate the Bing Spell Check by using Make. If you’ve never used Make before, there’s a bit of a learning curve, so I give some good training tips in this thread. 

Hi @JonathanB
This code does not appear to have completed all of its generation.

Even if a function is defined, if it is not executed, nothing is output.

// Define the table and field you want to check
var tableName = "YourTableName"; // Replace with your actual table name
var fieldName = "YourFieldName"; // Replace with your actual field name

// List of common misspellings
var misspellings = ["epilepsey", "epilipsy", "epilepcy", "epilepsy",
"eppilepsy", "epillepsy", "epilepsy", "epliepsy",
"epilespy", "epilepsie"];

// Function to search for misspellings
async function findMisspellings() {
var table = base.getTable(tableName);
var query = await table.selectRecordsAsync();
var foundMisspelling = false;

console.log(`Checking records in ${tableName} for misspellings in ${fieldName}...`);

query.records.forEach(record => {
var text = record.getCellValueAsString(fieldName);
if (text) {
misspellings.forEach(misspell => {
if (text.toLowerCase().includes(misspell)) {
console.log(`Misspelling found in record ${record.id}: ${misspell}`);
foundMisspelling = true;
}
});
}
});

if (!foundMisspelling) {
console.log(`No misspellings found in ${fieldName} field in records of ${tableName}.`);
}
}

// Call the function to start the search
findMisspellings();

 

Hi @JonathanB
This code does not appear to have completed all of its generation.

Even if a function is defined, if it is not executed, nothing is output.

// Define the table and field you want to check
var tableName = "YourTableName"; // Replace with your actual table name
var fieldName = "YourFieldName"; // Replace with your actual field name

// List of common misspellings
var misspellings = ["epilepsey", "epilipsy", "epilepcy", "epilepsy",
"eppilepsy", "epillepsy", "epilepsy", "epliepsy",
"epilespy", "epilepsie"];

// Function to search for misspellings
async function findMisspellings() {
var table = base.getTable(tableName);
var query = await table.selectRecordsAsync();
var foundMisspelling = false;

console.log(`Checking records in ${tableName} for misspellings in ${fieldName}...`);

query.records.forEach(record => {
var text = record.getCellValueAsString(fieldName);
if (text) {
misspellings.forEach(misspell => {
if (text.toLowerCase().includes(misspell)) {
console.log(`Misspelling found in record ${record.id}: ${misspell}`);
foundMisspelling = true;
}
});
}
});

if (!foundMisspelling) {
console.log(`No misspellings found in ${fieldName} field in records of ${tableName}.`);
}
}

// Call the function to start the search
findMisspellings();

 


What would I need to add to it to give an output? @Sho 

Reply


Terms & Conditions