How to filter fo ID and display text data and images filtered by the ID

Looker Q&A Looker
1

Hi all, how are you?

I’ve an aplication in appsheet with data stored by ID and I want to show the values corresponding of an specific row, for example but but like in appsheet if instead of the ID which is an specific number, I want to show for example the name of the person and the data related to that person.

How can I do that?.

Thanks in advance for the help

2

Hey,

Hope you’re keeping well.

In AppSheet you don’t need to expose the numeric ID to users — you can set a Label column in your table so the app displays a more user-friendly value like a person’s name. In the Data > Columns section, mark the “Name” field as the Label, and AppSheet will automatically use it in dropdowns, references, and detail views. If your images are stored in a column, make sure the column type is set to “Image” so they render correctly when the row is filtered by that person’s name. You can then use a slice or a filter expression like SELECT(Table[Image], [Name]=”John Doe”) to display only the related data.

Thanks and regards,
Taz

1 Like