Template expression

[BOTFORCE]

Hello!

I have a question about my template expression.

I want to get in my template the description SERVICES[Description] of a services (EnumList) and not the ID's.

Now I get only the ID's of the services stored in the Enumlist. How can I get the descriptions instead of the ID's in my template?

My startingpoint is the Graves table [GraveID] where I a´have in this table an attribute (EnumList) calles [Services].

Thank you

Robert

[WillowMobileSys · Accepted solution]

You'll need to create an expression to retrieve the list of Descriptions:

SELECT(Services[Description], IN([ID Column], [EnumList Column Name]))

You can either create a column in app for this, or use it in the template as is wrapping it with the usual <<...>>

[BOTFORCE]

THANK YOU!!