Substitution formula with an entity code instead of the description

Mateo DE LOS RIOS
Mateo DE LOS RIOS Active Partner
Second Anniversary First Comment 5 Up Votes
edited April 2020 in Platform

Hello all,

 

I know that we can use subsitution formulas to obtain the selection of an entity:

 

image

 

However, are there subsitution formulas to obtain the same information, but using the code in the formula instead of the description?

 

For example, for the entity:
- code: "E_0000000018"
- description: "Customer".

 

Today I use the  "@Customer" subsitution formula. But I would like to be able to use, for example, "@E_000018".


I need this advice because if I have to change the description of this entity with "Partner" (for example), I will have to change in every screen the "@Customer" formula.

 

Thank you,

 

Mateo DE LOS RIOS

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers

    Hi Mateo DE LOS RIOS,

     

    as explained in the referenced help-page, you could use @Selection_Ex(Entity="Customer", Display="Code").

     

    Kind Regards,

    Helmut

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers

    Hi Mateo DE LOS RIOS,

     

    I'm sorry, I think I misunderstood your question.

    No, there currently is no way of using the substitution based on the internal (file-)name of the entity. It would be great--of course--if you had the opportunity to use "real" variables; you might consider opening a new idea in the community.

    There might be a workaround to achieve your aim but, that would mean more effort than changing the entity name in each screen.

     

    Kind Regards,

    Helmut