Two subgrid for same entity

(0) Share

Report

Posted on by D_M

Hi experts,

I have an entity A with a form which contains 2 subgrids of entity B.

Both the subgrid columns are same. If I add a value to 1st subgrid, that should not show in the 2nd subgrid.

How shall I achieve this?

Thank you

I have the same question (0)

All responses (12)

Answers (1)

Suggested answer

Torrado 1,270 on at

Like (0)

Report

Hello,

Based on what you described, you need to create two relationships between Entity A and Entity B. That will split the Entity B records between the two subgrids.

When using only one relationship, the only option to filter the records displayed in the subgrids is by using different Views. You would need to have something (e.g. a field value) to differentiate the Entity B records that should be displayed on each subgrid.

Hope this helps you.

Please mark the answer as verified if helpful. That will help others in future.

Was this reply helpful? Yes No
Suggested answer

Jacob.s17 464 on at

Like (0)

Report

Is there any differentiator in the records in subgrid 1 vs subgrid 2? With subgrids you can set the Default View so with 1 single relationship, so long as the filter separates them, you're good.

Example:

Entity A = Company (Account)

Entity B (1:N) = Employees (Contacts)

Subgrid 1 = Employees in Ontario

- Default View = Contacts in Ontario

- View filter = State/Province (Contact) = Ontario

- set sub grid filter to "Related Records Only"

Subgrid 2 = Employees in Quebec

- Default View = Contacts in Quebec

- View filter = State/Province (Contact) = Quebec

- set sub grid filter to "Related Records Only"

let me know if this helps.

Was this reply helpful? Yes No
D_M 90 on at

Like (0)

Report

Hi,

Thanks for the response.

There is no differentiator field

Was this reply helpful? Yes No
D_M 90 on at

Like (0)

Report

There is no differentiator field

Was this reply helpful? Yes No
Verified answer

Jacob.s17 464 on at

Like (0)

Report

May I then ask what is the difference between grid 1 and grid 2? cause without a differentiator i don't understand its purpose.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi D M,

As per your query it seems you need to display 2 sub grids of Entity-B in Entity-A .

Regarding 'Sub Grid 1' data not to populate in 'Sub Grid 2' there must be some underlying business condition so please check the business condition and implement the logic accordingly using

configuration --> creating 2 different views to display in 2 different grids as per the business condition and restrict change of view.

Thanks,

Goloknath

Was this reply helpful? Yes No
D_M 90 on at

Like (0)

Report

Hi Jacob,

The two subgrids show the list of related actions to be performed. The subgrids are in different sections. The first section shows some information and necessary actions to be taken. The next section also works same way.

Was this reply helpful? Yes No
Suggested answer

Torrado 1,270 on at

Like (0)

Report

Hello,

Based on what you described, you need to create two relationships between Entity A and Entity B. That will split the Entity B records between the two subgrids.

Hope this helps you.

Please mark the answer as verified if helpful. That will help others in future.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi D M,

I believe I have already addressed your query above which will address your mentioned condition which I already implemented in my earlier engagement.

1. you need to create relationship

2. Create 2 different views of B based on conditions to be placed on 2 different sections on A

3. The conditions implemented will restrict the data duplication in both the grids.

Thanks,

Goloknath

Was this reply helpful? Yes No
D_M 90 on at

Like (0)

Report

Creating two different relationship didn't solve the issue. I tried but both the relationship had the lookup value mapping by default which cannot be removed

Was this reply helpful? Yes No