Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Jun 21, 2021 12:54 PM
I am trying to figure out how I could create an automation that would fill one cell with tags when the new record that I have made consists a certain word. For example I add a product type chair, it would add all the tags that I would use for chair.
Is this possible to do in automation or should I try to think of a script?
Thanks for the help!
Jun 21, 2021 02:39 PM
You could have several different Automations, one for each keyword, that inserts a predefined list of tags into the multiselect field.
Or you could use a single Automation that includes a Run a script
action. Here is a very rudimentary script that checks incoming text (provided by an input config
variable) for matching predefined keywords:
let {text} = input.config()
let keywords = [
// Add more {keyword: "", choices: []} objects as necessary
{keyword: "new", choices: ["New", "Featured"]},
{keyword: "chair", choices: ["Furniture", "Seating"]},
]
let applicableChoices = Array.from(new Set(keywords.flatMap(pair => {
let {keyword, choices} = pair
// remove the ".toLowerCase()" parts if you want keyword matching to be case-sensitive
if (text.toLocaleLowerCase().includes(keyword.toLocaleLowerCase())) {
return [...choices]
}
return null
})))
output.set("choices", applicableChoices)
Then add a Update record
step that fills in the multiselect field with the choices
output from the script.