You’re offline. This is a read only version of the page.
905
Hello everyone,
In the field service Accounts entity, I have a sub-grid that is linked to the account customer asset and another grid showing the related work order for that account.
Usually, I create the work order directly by pressing (+) from the sub-grid in the account entity, and once the form is opened, it automatically links the account to the Work order.
I want the "Primary Customer Asset field" to be also mapped automatically when I create the Work order from a related account.
The problem is if I do this directly from the "Accounts entity" the asset is not mapped to the Work order. However, If I try to create the Work order from a sub-grid inside the asset entity, the current asset related to the service account will be mapped to the Work order.
I already configured the filter query of the Primary customer asset field as below:
Can please someone explain in detail and provide an example to achieve the above scenario?
Any help is highly appreciated.
Thank you!
Hi EBMRay,
Account(Parent) and Asset(Child) is 1:N relationship;
Account(Parent) and Work order(Child) is 1:N relationship;
Asset(Parent) and Work order(Child) is 1:N relationship.
Mapping function can get value from parent to child, which is irreversible.
(1)Create Work order from Account:
Only accountid has been mapped into Work order.
Asset is child of account, one account have many assets, you can't map many assets to one lookup field in the work order form, which is impossible.
So you only can filter related records in 'Primary Customer Asset' lookup field, like screenshot you provide:
Which can make 'Primary Customer Asset' lookup field only show assets related to the service account.
(2) Create Work order from Asset:
Account and asset will both map to Work order.
Account is parent of asset, one asset can only have one account, so it can map to the service account lookup field.
Share
Report
All responses (
Answers (
