I’m unsure of how to construct a search function that would match the full {ISBN} in [Books] against the {Padded Codes} lookup field that contains long mash of padded codes. I understand that the 13-digit string is padded with Xs (and so not of varyi...

Hi Justin, Thanks for your feedback. Sorry for keep piling on, but I’m being told that we’re stripping out dashes in Airtable (to integrate with an external database). Would there be a way to do this without the dashes? The full ISBN will still alway...

Hi, Justin. This solution looks exciting, thanks! One more thing – would it be possible to implement this workaround with {Publisher} being a multi-select? I assume there would be additional array manipulation, if so. Thanks again.

Hi Justin, thanks. This is Chris Yep, just the vendor/publisher name from the reference table into [Books]. I’m not sure why they do either, but I believe it’s just the way ISBNs get assigned. I can’t seem to add links in a reply, but you can check...