175
Hi everyone.
I have two entities, "Cars" and "Reviews". Each car can have multiple reviews and each review can only be related to one car. I have a question about the following.
Every time a new review is created I need to populate a lookup field on the related car record with the "newest" review.
How can I go about this, is the WebApi the best way?
As Per your requirement.
you can achieve through Custome Workflow as well Plugin.
After New Record (Review) is created you can get the record Order by "CreatedOn DESC" .
<fetch top="1" >
<entity name="review" >
<order attribute="createdon" descending="true" />
</entity>
</fetch>
Get the GUID and Update in Related(Car) Entity Lookup value with a recent Review Record Guid.
Hope this will help you.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (