Thanks for the tag, @ScottWorld.
@Cathy_Anderson I think there are some formatting issues due to how the code got pasted into the forum. I believe this is how it actually looks on your end:
let name = base.getTable('Constituents');
let parent = await input.recordAsync('The constituent', name);
if (parent) {
output.text(`${parent.getCellValueAsString('Community')}`);
}
let taxonomy = base.getTable('Taxonomy');
let view = taxonomy.getView(`${parent.getCellValueAsString('Community')}`);
// pick a category
let category = await input.recordAsync(‘Pick a category’, view);
// if there is a category
if (category) {
const writeValue = output.text(`${name.getCellValueAsString('Category')}`);
await table.updateRecordAsync(name, {[Category]: writeValue});
return writeValue;
}
As a heads-up for the future, you can format long blocks of code by wrapping it inside pairs of graves triplets, like this:
```
code in here
```
Which becomes:
code in here
First off, when all that you’re outputting—or inserting into another function or method call—is the value from a variable (or another method call), you don’t need to wrap the string in graves, like you do here:
output.text(`${parent.getCellValueAsString('Community')}`);
You can do it like this:
output.text(parent.getCellValueAsString('Community'));
Only when you want to insert that value into some larger text string that you’re outputting would you need to do the more complex insertion method:
output.text(`The value I received is ${parent.getCellValueAsString('Community')}, and I'm not sure what to do with it.`);
That lets us simplify the start of the script to this:
let name = base.getTable('Constituents');
let parent = await input.recordAsync('The constituent', name);
if (parent) {
output.text(parent.getCellValueAsString('Community'));
}
let taxonomy = base.getTable('Taxonomy');
let view = taxonomy.getView(parent.getCellValueAsString('Community'));
The “pick a category” line is fine, so I’ll skip that. The biggest hiccups are in the latter end, and I’ll tackle them one line at a time.
const writeValue = output.text(`${name.getCellValueAsString('Category')}`);
Working from the inside out, you have name.getCellValueAsString('Category'). However, name was originally defined at the top of your script as a table, and tables don’t have a getCellValueAsString method. Only records have that. You already have the category that the user picked in the “Pick a category” query, so in the end, this whole line is unnecessary. There are some other issues with it (the output.text() method doesn’t return anything, so the writeValue variable probably ended up as null or maybe void), but those aren’t relevant to what you’re trying to achieve, so I’ll just remove this line and move to the next one.
await table.updateRecordAsync(name, {[Category]: writeValue});
This has several things amiss:
- The
updateRecordAsync method is supposed to be called on the table instance that was returned when you called base.getTable() elsewhere in your code. In your case, that instance is in the name variable.
- The first thing you pass it should be the record ID of the record you wish to update, which is currently in the
parent variable in your case.
- Because you want to assign the category value to the
{Category} field, you need “Category”, not [Category].
- We’re no longer using
writeValue because the category value is in the category variable
With those changes, this line should be:
await name.updateRecordAsync(parent, {"Category": category});
Now for the last line in that block:
return writeValue;
Only functions return values. Because we’re not in a function, this line can be omitted. That leaves us with this as the modified version of the script:
let name = base.getTable('Constituents');
let parent = await input.recordAsync('The constituent', name);
if (parent) {
output.text(parent.getCellValueAsString('Community'));
}
let taxonomy = base.getTable('Taxonomy');
let view = taxonomy.getView(parent.getCellValueAsString('Community'));
// pick a category
let category = await input.recordAsync('Pick a category', view);
// if there is a category
if (category)
await name.updateRecordAsync(parent, {"Category": category});
Let me know if that works.
