Update other records values based on last record input
Hello Community,
Maybe a simple question for you guys, but I'm struggling with the following use case.
We need to ensure we have only Approved Supplier which we can deal with. Those approvals are based on evaluation and qualification as shown in the illustration below.
The example shows historical qualifications for the same supplier, and whatever the Qualification Status is, it is always the latest date that counts to show this supplier as approved. Therefor I'm using the "LATEST" column to filter my report with only approved suppliers.
The issue I have is to ensure that when there's a new qualification (so a new record) with a more recent date, I would like all the history of "LATEST" to get the value "OLD"
I'm using the following script but does not seem to help. Any idea of what I'm doing wrong ?
- for each rec in NEW_QUALIFICATION[QUALIFICATION_DATE > input.QUALIFICATION_DATE && SUPPLIER_NAME = input.SUPPLIER_NAME]
- {
- rec.LATEST="OLD";
- }
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Turcksin
Vinnie B - cloud-connect.ie
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー