I have created a table in a base that includes a rating field (1-5 stars). I am sharing it on a website.
However, I want to do the following and not sure if there’s a way to do it.
I want to be able to show on the website ONLY the records that have 5 stars and nothing else. I know I can tell the viewer to create a filter but that’s a hassle. I don’t want the viewer to do anything.
Sounds like what you want is a view share link. This allows you to link to or embed a specific view — including filters. There are a number of options and variations discussed in the referenced article.
Thank you for your answer.
I was able to go through your link but unfortunately, it seems it doesn’t solve my issue.
I am able to share a view where I have created a filter. However, it allows the user to delete the filter which I’d rather not give them the ability to do. I probably wasn’t clear on that earlier.
I want them to see only those records with a 5 star rating and nothing else.
It’s easy to get confused which link or under which login one is testing. In fact, after receiving your reply, the first thing I did was double-check the view link I’d created before responding to you — where, to my chagrin, I discovered you were correct. Only upon double-checking my double-check did I realize I had used the wrong URL in my previous test…
You can use Softr.io (a no-code platform to build powerful websites & web-apps using Airtable as a database, without any code) to display filtered data (list view, card view) on your website. You could also use a specific Airtable view and only display data from that view.
Hope it helps, feel free to check it out, it’s free.
Feel free to check it out, it’s free - https://www.softr.io
In my opinion Softr is a true game changer. Packed with powerful front-end tools with the versatility of Airtable and Zapier in the background. Great support and rapidly evolving feature set - I’m busily converting some heavily used Wordpress sites to this environment and the customer feedback is a 10 out of 10.