Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Dynamically filtered shared calendar view

Topic Labels: Views
2142 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Ronni_Metiya
4 - Data Explorer
4 - Data Explorer

I am embedding calendar view of a base having exam dates and assignment deadlines into my website, and providing users the option to select which subjects they want to see records. How do I change the embed URL dynamically to result in {Subject} = ‘Subject 1’ or {Subject} = ‘Subject 2’ …?

The advanced filtering option is working for API but not for embed.

Please help, thanks

4 Replies 4

I believe you can just use the Shared View URL Filters for this, and just add the filters like so:

https://airtable.com/embed/[EMBED URL]?backgroundColor=red&filter_Subject=Subject%201

You’d need to write your own code to refresh the embed’s URL etc

I’m curious why you don’t want to just use the embed’s view controls actually

Screenshot 2022-09-26 at 7.03.07 PM

Yes this works when I want to filter only a single value of Subject. However as I mentioned I need to have OR functionality so that all records having ‘Subject 1’ or ‘Subject 2’ or ‘Subject 3’ or … ‘Subject N’ are shown, and this thing is not mentioned in any of the official articles I went through. I even tried with advanced filter URL like in API endpoints, but for Views it didn’t work.

Also I don’t want to use the view controls since the app intends to only show exams for the subjects a user has. User should not have to filter Science subjects everytime and there’s no point in showing History to a user if they don’t have it (just taking an example)

@Adam_TheTimeSavingCo

Oh you’re referring to this bit I take it? Sorry about that, since Airtable’s OR() syntax is different I thought you were just giving examples of filters you needed heh

Yeah. Apparently something like “https://airtable.com/embed/shrXXXXXXXXXXX?filterByFormula=OR(condition1,condition2)” doesn’t work for views