Switching an External GET Source from Text led search to Integer led details?

Hello generous & helpful people.

Using an External Collection, how would I set up my pages to switch External Collection data GET sources?

For example, a User search has been set up with a form input to search TV shows by name. (thanks to @dilon_perera 's help)
Screen Shot 2022-03-02 at 10.07.17 AM

One of the data points returned is a numerical ID (integer). When a user clicks on a result, I’d like to use the numerical ID (integer) to deliver the data for the “Details” screen. I’ve set up a custom action to “Get info using tv_id”. Successfully Tested. But don’t know how to display the results of that action on the Details screen.
Screen Shot 2022-03-02 at 10.09.37 AM

Screen Shot 2022-03-02 at 10.12.31 AM

Any ideas?

I was playing with the TMDB a few days ago. I’ll look into it.

I’ve been asked this a few times in DM, so moving it to the front so everyone can see… I think the issue is different endpoint request. It may needs to be set up as a collection, instead of Custom Action?

Search by Name - https://api.themoviedb.org/3/search/tv?api_key=<<api_key>>&language=en-US&page=1&query= {tv_show_name} &include_adult=false

Get info with ID - https://api.themoviedb.org/3/tv/ {tv_id} ?api_key=<<api_key>>&language=en-US

I got it. You can create an internal TV show database within adalo.

Then, in your search list, you’ll need a nested list of internal shows.

I’ll record a video real quick.

Here you go: https://www.loom.com/share/3d696dee20f94be4ba965c8487a9b49f

1 Like

Is the nested list inside of the collection? Or below (butted up against) the collection?

Also, thank you so much! This community has been amazing. And I’m so appreciative for the smarts and creativity being shared.

Hi Jordan,

Unfortunately we can’t use custom action values in the other screen ( someone correct me if I’m wrong :slightly_smiling_face: ). We need to store them somewhere and then use them. Like creating a record in a collection with the custom action values and showing that record details on the other screen.

Or maybe crating some properties in the Users collection and storing them there and showing like Logged in user> that property. Or with inputs but if there are multiple values then there might be multiple change input values actions and might become slow down the app.

I tried to see if we can use External collections for this but it doesn’t have a results key.

Anyway I think you got the answer from Mario!

All the best with your app!

Thank you

Yeah, Jordan messaged me in a DM to inform me that he was able to configure it using the logic I provided.

You’re right also Dilon, there is no results key to create an external collection of the TV show database outside of the search since it only pulls individual records. That’s why we have to create a record and store it.

1 Like