Data source Airtable, horizontal list item with action: how to pass parameter with the record ID?

Ask the community
1

Hi All,

I’m working on my first Softr app. The data source is Airtable.

I’ve created a section with a “list with horizontal cards”. In each item, I’ve configured an Action. I would like that the result is to open another page part of the app and pass the Record ID via the URL.

  1. I’ve created a dedicated field in Airtable with the Record ID. The column is called CompanyID. The value is correctly displayed in the item.

  2. I’ve configured the action using “Open URL” with
    Page-name?CompanyID={{CompanyID}}

I’ve tried different syntax, e.g. with single curly brackets, but the value is not replaced. I tried also to publish the app, but no difference.

Could you please help? I searched in the documentation and also in the community, but did not manage to resolve it yet.

2

Hi there,

Softr provides this functionality built in for you - we call it “item details” or detail pages.

If you have a list block, and then click on one of those items, you can navigate to that items detail page.

In order to setup, you first need to create a new page that includes the “item details” block on the page, which is mapped to the same table (Company)

Then, go back to your list block, and configure the action to open the details page. Now you will see the company details as an option.

Then you will be able to navigate to the company detail page and see more details for that specific record!

3

Hi Jj,

Thanks a lot for your feedback.

I realise that my question is not fully complete.

My goal for the follow-up page is not to display the content of the entry related to the RecordID. I would like to display the content of Linked entries in another Airtable table.

How can this be achieved?

To summarise:

  • first page: horizontal list with items related to individual companies
  • when clicking on an item: I go to a follow-up page where I see another horizontal list with e.g. departments from a defined company (linked records).

Hope this is more clear.

Thanks for your support, Sergio

4

Follow JJs suggestion of using an items details page, with the first block being for that record (even if its simple, e.g. just contains the record name, or is even blank). You can then add the second list block you want, configure the source to be that of the second table, and then with a conditional filter you can specify to only show records in which Field X is exactly the record ID of the first block.

Here’s an example I’ve used to setup a list block of students being related to a single course:

image
image420×325 11.9 KB

1 Like
6

Thank you @Jjenglert and @Matt. I understood the underlying logic and implemented. I guess this is the related documentation:

I’ve one more question. I tried to use the same approach to visualise the details of a specific entry in a linked table. This seems not to work, at least I did not manage.

Working scenario:

  • list details of primary entry (e.g. company)
  • list of entries from linked table (e.g. list of departments)

Not working:

  • list details of primary entry (e.g. specific details about a department)
  • list details of linked entry (e.g. specific details about the related company)

Can you please confirm if the second scenario is possible?

7

Company > department works, if you save a list of departments on the company table.

For the same to be true, you’d need to save a related company on the department table.