- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 09, 2025 12:48 PM
I'm looking for a way to share a calendar subscription link (e.g. iCal subscription) of a filtered view. Currently my Calendar view subscription shows all calendar events for all users - I'd like to have a customised link that's unique to each user (i.e. using their username / email address field taken from the table) so that they can only see their own events and not those of all users.
Any suggestions of solutions for making that work, please?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 10, 2025 04:28 PM - edited ‎Jan 10, 2025 04:28 PM
Here is the support article for adding URL filters into view links.
You can create a formula field that joins the base url for the view link with the url parameters for each user.
You'll want to use the ENCODE_URL_COMPONENT function as well to make sure everything is encoded correctly.
Example:
"{Base URL}?filter_" & ENCODE_URL_COMPONENT("Username Field") & "=" & ENCODE_URL_COMPONENT({Username Field})
Then, you can create an automation that sends each user their unique link from this field.
Note: If a user decides to strip the URL parameters and load the base URL, or get rid of the filter conditions on the view page's filter, they will see all events for all users. The only way to do this fully securely is for each user to have their own Airtable account so that you can create an interface that only displays data relevant to the logged in user. You'd need to pay for each user.
