Sep 17, 2022 04:45 AM
I keep track of articles that I publish online and their internal links to other articles I’ve written. So the table is structured like this:
Field 1: Article Name
Field 2: Related field with multiple select, choosing articles from Field 1
In real life, it’s something like this:
Article 1 has internal links of Articles 2, 3, and 4
Article 7 has internal links of Articles 1, 3, and 2
I want to know which records from Field 1 do not exist in Field 2. In other words, which articles have I published that have not been internally linked in anything else I’ve written. In the above, Article 7 would be an example of the data returned - it has not been an internal link of another article (exists in Field 1 but not in Field 2).
I’ve tried a few different things but can’t quite get the results I’m looking for.
Can anyone help?
Sep 19, 2022 03:24 AM
Hi @Anna_Yang, this would be pretty easy to do if Field 2
was a linked field to another table instead of the same table, and so I think if I were you I’d just end up with two tables:
Articles
Links
And the two tables would both contain all the articles ever written, probably maintained by an automation or something
The workflow would then become:
Articles
, set the links via the linked field to the Links
tableFind Record
action to find all the records that aren’t linked to the triggering record and that does not share the same name as the triggering recordWhich gives you the following: