Can anyone help me understand how to use a Formula...
# general
k
Can anyone help me understand how to use a Formula (Text) to get a value from the database. I'm doing a Customer search and am trying to group by Territory. When I use
{territory}
it gives the territory name, but I want the primary key of the territory. I've tried
{territory.id}
,
{territory.internalid}
,
{customer.sales_territory_id}
and more, but none of those work. Can anyone help me get the primary key of the territory in a search?