Customer experience | Sales, Customer Insights,...

How to create field which consists of multiple values and multiple columns.

(0) Share

Report

Posted on by Saurabh-704

Hello All!!

I wanted to create fields in which we can add multiple columns and multiple values.

For example:

Name Role Total Vendors

X influence 25

Y Manger 29

Z Director 30

Like this I wanted to create.

Can someone please help me with this?

Thanks in advance!!

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Community Member on at

Like (2)

Report

Hi Saurabh,

Unfortunately, you can’t add table into field of the form. But you can create table in the form by following two ways.

1.create an entity includes these data and new a sub-grid to show them on the form.

(1) create an entity and new relationship between two entities that you need.

You can refer it:

https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/create-and-edit-1n-relationships

(2) create a sub-grid of related records to the form.

You can refer following:

https://support.clickdimensions.com/hc/en-us/articles/360007874432-Add-a-Sub-Grid-of-Related-Records-to-your-Contacts

2.write a web resource and add it to the form.

This is sample code:

<!DOCTYPE html>

<html>

<head>

<style>

table, th, td {

  border: 1px solid black;

  border-collapse: collapse;

}

</style>

</head>

<body>

<table>

  <tr>

    <th>Name</th>

    <th>Role</th>

    <th>Total Vendors</th>

  </tr>

  <tr>

    <td>X</td>

    <td>influence</td>

    <td>influence</td>

  </tr>

  <tr>

    <td>Y</td>

    <td>Manager</td>

    <td>29</td>

  </tr>

   <tr>

    <td>Z</td>

    <td>Director</td>

    <td>30</td>

  </tr>

</table>

</body>

</html>

You can refer following to add it as web resource to the form:

https://crmbook.powerobjects.com/extending-dynamics-365/javascript/html-web-resources/

This is result:

However, what you need to know is that web resources can only be modified by administrators, while subgrids allow users in the organization to modify data at any time.

Regards,

Leah

Was this reply helpful? Yes No
Suggested answer

Brandon Sambat on at

Like (1)

Report

You could also use the Editable Sub Grids option to create columns of fields - docs.microsoft.com/.../make-grids-lists-editable-custom-control. This would allow users with proper security the ability to enter data into the grid.

Was this reply helpful? Yes No
Saurabh-704 15 on at

Like (0)

Report

Thank you @Leah ju for your response. One quick question that whatever I add to one particular record will it be limited to that record only or to each and every record?!

Like for example if I am adding 'x' , 'y' in record "A", then unless and until I add 'X' or 'Y' in record "B" , it should not be visible in record "B".

Was this reply helpful? Yes No
Saurabh-704 15 on at

Like (0)

Report

Thank you @Brandon Sambat for your response!! One quick question that whatever I add to one particular record will it be limited to that record only or to each and every record?!

Like for example if I am adding 'x' , 'y' in record "A", then unless and until I add 'X' or 'Y' in record "B" , it should not be visible in record "B".

Was this reply helpful? Yes No