How do I fill the demand field in an IDEA with the DEMAND NUMBER instead of the name?

christophosterm · ‎06-14-2017

When a Demand is created out of an idea in the Idea table, the field Demand is filled with a business rule.

However, this reference field is filled with the name of the Demand. And not the number. The latter is the case for all other reference fields.

Could you explain how we can change the name of the reference Demand into the number of the referenced Demand?

So we can work in a uniform way in our platform.

We have tried several ways to change this reference field to a number, however without success so far.

Thanks for your help!

Demand Number.jpg

DrewW · ‎06-14-2017

Reference fields show the value of the display column for the referenced table. So if you look at the dictionary for the Demand table go to the short description field, there you will find a dictionary override that has "Override display value" selected. Turn it off and you will get what you want. I would go with Emily McMullin's thought and wonder about the need for this change. Most of the PM's and users I work with know the short description they gave something not the number it was assigned.

View solution in original post

deneech · ‎06-14-2017

Hello Christoph

Do you have Demand -Reference -Demand on the Idea table? We have it on the Project because we do not use Idea. Also in the dictionary the table should be Idea and the Reference should be demand.

christophosterm · ‎06-14-2017

Yes, we do:

deneech · ‎06-14-2017

Hello Cristoph

Remove the Field from the form Layout and add it back.

thanks

denee

deneech · ‎06-14-2017

Hello Christoph

As I continue to think about what your trying to achieve. The Idea has to be approved to become a demand before the demand is created. You might need to create a client script to populate this information after the idea has been accepted.

thanks

Denee