Hey all. Eek, getting things right took wayyyyy longer than I anticipated, but I finally “cracked it” and have posted a template doc for incorporating per-row encryption easily into your own docs. If anyone’s still interested, here’s a link to my new community post:
@Paul_Danyliuk thanks for your feedback about Row Activity and your suggestion of looking into volatility as a possible path around it. In the end, I used Forms as a sandbox for the user’s sensitive information, and although it ended up being a fairly complex solution with a number of workarounds, I think a user would experience the workflow as simple and straight-forward. Would love to hear your thoughts if you have a few moments.
Once again, thanks for all the love and I hope this little contribution ends up being something you’ll each find helpful in the future.