Hey guys, any ideas on how to build this doc in Coda?
Here you can see it in Google Sheets: https://docs.google.com/spreadsheets/d/1UkmJmR-ah69bUN7rsyZBOwAeWnimDmArLBwk6y0I_-c/edit#gid=1957062463&range=1:989
The idea is that you can modify the keywords from the column headers, and see whether there’s a match for each row in particular from the right side of the doc:
Thx for your help!
Hi @sourcingdenis,
There are various ways you could set this up to reference the words you want to match. This might help as far as setting up a way to count the number of matches in that row. I think that’s what you’re doing here.
Pretty much the same. You can join/concatenate with Join() / Concatenate() (duh), and you can RegexMatch() as well.
Although I don’t see any regex in there — you’re doing a substring match, so Concatenate().Lower().Find("hr") != -1 could be a more performant idiom.
You cannot take words from column headers — you’ll have to put them on a separate table, then take from there to put into your matching formula(s).
If the number of terms to check in people’s profiles is not a constant set (i.e. not just those 6 terms), you should do it as separate rows instead of columns or build some other sort of automation.
On unrelated note, that’s quite a database of Ukrainian recruiters 
Almost a 1000 souls, omg. Almost a shame I don’t have any use for it, since I’m not looking for any workforce positions anymore.
