Filter table results by user's address > state

Is there a way to setup filtering table results by a user’s address > state? I want to automatically only show table results to a user where their address > state matches a state field for a product. I’m not seeing a way and maybe it’s just too complex of a need for this solution.

Hi

Try creating a text formula using getAddressState see Text Formula Functions

Dean

Thanks, it looks promising but I’m not seeing where a text formula can be set as a filter. Do you know where?

Hi

Here’s what I quickly knocked up.

Dean

Thanks, I understand how to extract the State from an address using a formula. My actual question, though, is about using that State value to dynamically filter access to records — so that a user with State = X only sees records where State = X.

From what I can tell, there doesn’t seem to be a way to do this kind of automatic, dynamic filtering based on the user’s value — at least not natively. Let me know if I’m missing something that enables that.

Hi

Maybe try using User Roles & Permissions to achieve this.

Dean