Is there a way for individuals to view subsets of data?

JonathanBowen just gave me a great answer to me last question so I thought I’d ask another.

As described in my last question, we’re using AirTable to track investments by our Invest Group members. Lots of members. Lots of deals. Each member with their own investments into various deals. Each investment a member makes is captured in a record that’s the intersection of a member and a deal.

Ideally, we’d like to show this data to our members online. But they can only see their own investments.

I’ve (sort of) figured out how to use Page Designer to generate a PDF report for each member that shows their individual investments but we’re looking for something that can live online.

Is there any way – possibly through a Zapier integration I haven’t thought of – to publish a webpage for each unique member?

Ideally we’d be able to password protect - with a unique password – each page but if they were randomly generated, impossible to guess URLs we could distribute those and that would be good enough.

Thanks in advance for any insight anyone has.

-Peter

1 Like