Service | Customer Service, Contact Center, Fie...

How can I count the assets in work order.

(0) Share

Report

Posted on by James_Oliver

186

I have to make something like ,Work order should allow a single asset only 7 times in 7 days

, like only 7 times a single asset can be added in a work order in 7 Days.

I should only able to make work order of a particular asset only 7 times in past 7 days.

How can I do that
anyone

Thanks in advance

All responses (2)

Answers (0)

Suggested answer

Dan Gittler - Dynam... on at

Like (0)

Report

RE: How can I count the assets in work order.

Perhaps javascript on WO create that queries the asset, finds all work order incidents for the asset in the last 7 days, and surfaces an error if it is more than 7? Alternatively you can store the count on the asset but it would require you to constantly update that field when work orders are created, and then update it each night so it only counts the last 7.
Suggested answer

Nya 29,058 on at

Like (0)

Report

RE: How can I count the assets in work order.

Hi,

You can create a rollup field in Customer Asset entity to calculate the count of the related work orders.

Here is a documentation about the roll up field which you can refer to:

Define rollup columns with Power Apps - Power Apps | Microsoft Docs