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

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Nya 29,060 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Dan Gittler - Dynam... on at

Like (0)

Report

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.

Was this reply helpful? Yes No