Monthly updated gate code

Our HOA changes the gate code every month in our unit and I was wondering if there's a way to create a custom field where the value is a function of a lookup table. Has anybody done anything to address that?

There's no option for this built in (yet), but you could probably do something with Zapier!