Reply To: Show Item No. and Item Description of Prod. Order

Hi Dave,

The missing step that we inadvertently forgot to describe to you is to also show and configure the ‘Data Fields’ field, our apologies for missing that earlier.

Here are the full steps end to end to get those two fields showing in the cell template and tooltip template, with copy and paste-able values.

Most of these steps you’ve already done, they’re just here for completeness:

 

1) Personalize the page.

Show three columns:

“Tooltip Template”

“Cell Template”

“Data Fields”

 

2) Edit the “Data Fields” value.   This is currently a comma separated value.

The default value for production order routing lines will be:

Prod. Order No.,Routing Status,Operation No.,Description,Run Time

To show item number and description, change this to be:

Prod. Order No.,Routing Status,Operation No.,Description,Run Time,Prod. Order Item No.,Prod. Item Description

 

You can use either the field name, or the field caption.

(Note: When using the field caption, if there are multiple fields with the same caption, it will use the first field that matches that caption.)

 

3) Edit the “Cell Template” field.

The default value will be: [Prod_Order_No] : [Description]

To show the item number and description, use square brackets and the name of the field to include [Prod. Order Item No.] [Prod. Item Description]

For example, let’s say we wanted it to be Production order number dash item no. dash item description we could have:

[Prod. Order No.] – [Prod. Order Item No.] – [Prod. Item Description]

 

4) Edit the “Tooltip Template” field.

Use <br /> to denote a new line in the hover.

The default value is:

<br/>Prod. Order No. :[Prod_Order_No]<br />Operation No.: [Operation_No]<br/>Op. Description: [Description]<br/><br/>Routing Status: [Routing_Status]<br/><br/>Starting Date:[start]<br/>Ending Date: [end]

<br/>Prod. Order No. :[Prod_Order_No]<br/>Item No. :[Prod. Order Item No.]<br/>Item Desc. :[Prod. Item Description]<br />Operation No.: [Operation_No]<br/>Op. Description: [Description]<br/><br/>Routing Status: [Routing_Status]<br/><br/>Starting Date:[start]<br/>Ending Date: [end]

 

5) That’s it, you should now have the item number and item description in the cell and tooltip template.

The pattern for both the cell template and tooltip template is to use square brackets.

In the square brackets you can use either the field name, or the field caption.

The underscores you see are the ‘odata’ compatible equivalent of the field name and/or caption, which are also fine, and just a backwards compatible option.

The only constraint is if you use the field name in the “Data Fields”, then to also use the field name in the templates, and likewise if you use the caption in the data fields, then you need to use the caption in the square brackets in the templates.

 

I’ve made sure that it is in our roadmap to both improve that experience and document the steps for this.

If you need additional help send me an email, and we can arrange some time to go over this, or other features.

 

Thank you for your time,

-Tim