I have a problem with a script that worked and all of a sudden, stopped to work:
"App Name" is a linked record field. "Add App On Sign Up" is another linked record field. When a value is inserted in "Add App On Sign Up", I need this value to be inserted in "App Name" (inserted, meaning adding a value, not replacing a value to "App Name".
Anyone has a better script to propose?
The error message is:
Error: Field "fldGBiazYCpFzbsOv" cannot accept the provided value.
at main on line 12Field "fldGBiazYCpFzbsOv" is the field id of App Name
const table = base.getTable("Members");
const query = await table.selectRecordsAsync();
for (const record of query.records) {
const appNames = record.getCellValue("App Name");
const addAppOnSignUp = record.getCellValue("Add App On Sign Up");
if (appNames && addAppOnSignUp) {
const updatedAppNames = appNames.map(appName => appName).concat(addAppOnSignUp);
await table.updateRecordAsync(record, {
"App Name": updatedAppNames
});
}
}