Hello,
I would like to create a small app with Softr and Supabase.
In Supabase I have two tables Courses and CourseTypes. In Courses there is a column CourseType_ID which contains the ID of the CourseType.
Now I would like to display a list of all courses in Softr and display the respective CourseTypeName instead of the CourseType_ID.
Is this possible or not?
Best regards
Joerg
Hi @RedTiger80 welcome to the community!
The way we approach this in Softr is by first creating a item detail page for the record you’re trying to find more information for.
Then on that page, create a “linked list” which includes a listing of the items that relate to that item on the “item detail” page.
This way you can show all of the related courses that belong to that course type, for example.
Hi, thanks for the feedback. Let me explain it in more detail.
I have a list of courses and each course has only one type. For example “18-Holes” or “9-Holes”.
I just want to be able to see in the course list whether it is an “18-Holes” or “9-Holes” course.
I also have the problem that I would like to have the types for selection for the filter of the course list and not the IDs.
What can I do?
Best regards
Joerg
To display that data, you will also need to save that data on the course list page. With Softr, we can only show the values you have on the immediate record, instead of doing dynamic lookups for you. By saving the fields you want to show on the table you’re showing, this will solve it for you.
Similar to above, you’ll need to save the name of the record on the record as well, instead of just the ID which links to the other record.
I’m working on something similar, which should only display the options related to the item that was selected first. I’m also giving the option to select multiple items, and I’m validating it in Airtable.
