Does anyone know if there is an ability to set up Matching rules between two tables? For instance, I’d like to search the text-based inputs in one column if it matches a rule then I’d like to insert a referenced item from another table.
Ex.
If the word “conceptual design” appears in a column called Notes in Table 1 then refer to Table 2 and a column called Activities which has an item called “Concept Design”. Append “Concept Design” to a new column in Table 1 called Activity Name.
There is probably a smarter way to say this but I hope someone has a clever solution