How to show only the latest search results (available rooms) to a user after form submission in Softr URL parameter filtering are not available

Ask the community
1

Hi Softr team & community :waving_hand:

I’m building a Hostel room search flow using Softr + Airtable + Make, and I’m stuck on what feels like a very basic requirement.

What I’m trying to achieve

  1. User fills a form with check-in & check-out dates

  2. Backend logic (Make + Airtable) checks bookings

  3. Only available rooms for that specific search (check in and checkout dates )should be shown to the user

  4. User is redirected to a Search Results page showing only those rooms

My current setup

  • Airtable tables

    • Rooms – all rooms

    • Bookings – confirmed bookings with room ids

    • SearchResults – populated by Make with available rooms per search

  • Each search creates multiple rows in SearchResults (one row per available room)

  • The Search Results page is connected to the SearchResults table

The problem

Softr always shows all rows from the SearchResults table, including results from previous searches.

I need Softr to show only the rows created by the latest search (or the current search).

Constraint

  • I do not see a way to filter list blocks using URL parameters

  • Redirect actions in workflows don’t expose query params for filtering

  • I cannot rely on logged-in user context (no user-specific filtering)

What I’ve tried

  • Adding an Is Latest field in Airtable and updating it via Make

  • Clearing old rows before creating new ones

  • Redirecting after workflow completion

  • Passing record IDs in messages / redirects

  • REST API + Make webhooks

All approaches eventually fail because Softr list blocks can’t reliably filter by “latest record” or URL params

My questions

  1. Is there an official way in Softr to:

    • Filter a list block to only show records from the latest form submission?

  2. Can a list block be filtered using:

    • A record ID passed via redirect?

    • URL query parameters?

  3. Is there a recommended pattern for search-result–type flows without dynamic pages?

At the moment, this feels much more complex than it should be for a very common use case (search → results).

Any guidance or confirmation of limitations would really help :folded_hands:

2

Hi @artur can you help here? I want to pass record id of a search (one record id per search) in url to show users their search results,is this possible? This is for hostel room booking app when user selects check in date check out date to see available rooms

3

@Soumyab first my recommendation would be to try doing all this in Softr as we have DB/Workflows and App in one syetem.

You would use our workflows which could also show nice UI before redirecting… you could generate simple UUID via code block in our workflow and insert that into table with that you will know that X rows belong to a specific Search… then in our workflow you redirect to a dynamic URL where you put fieldId=@UUID with that you will have what you asked for

Will users be logged in ?

4

Hi @artur Thank you for your reply. I will try softr DB and workflow. Thanks for your input

Users will not be logged in

5

Hi @artur I have moved all my data and workflow to url. I m having the hardest time to redirect to a dynamic url. There doesn’t seem to be any page or video on it (all pages lead to 404 error)

6

perhaps you can share with our support team and give access so we can check ?

1 Like