View values from a list of things

If I have a data type with a related list of another datatype like this:

Movie

  • Title type text
  • Actors type List of Actors

Actor

  • Name type text

is there a way for me to see the Movie with a list of the Actor names in the app data view?

Looks like I can’t do a “join”, so I can only see the Movie with the IDs of the Actors.

Just change the primary display field of the Actor datatype to Name.

@gary.homewood

This may complement @adamhholmes great advice

  • rg of movies
  • in the text field inside the rg … add this expression … “current cells movie actors name”

Sorry, where is that? I can’t see that as an option in the data types definition.

You’re talking about the App Data tab right?

is there a way for me to see the Movie with a list of the Actor names in the app data view?

In which case it’s here:

Or are you talking about displaying data in your app?

Yes, displaying on the App Data tab.

That works, though its a shame I can’t display more than one field. I would like the flexibility of SQL!

1 Like