Hi All,
If you see the picture the record has two fields review date and status . Currently status is "in use" when review date is ahead of current date but status will be "retire" immediately when review date passes . Can we achieve it through flow designer ? Actually scheduled jobs are making the system slow so trying to achieve it through flow. In this picture when review date passes on 8th may the status will automatically updated to retire on the fly.
Thank you
1. Trigger type is scheduled, daily.
2. First action is Look up Records (plural) where Review Date is Yesterday.
3. For each item loop.
4. Update Record.
Hi @1_DipikaD,
Trying to understand why are you trying to implement it via flow designer is it because of performance ? then For the specific task of deleting a large number of records (like 1000s), a well-optimized Scheduled Job using scripting (GlideRecord) will generally offer better performance compared to a Flow Designer flow.
See if you can improve the logic of schedule job to tune the performance or split the scheduled job to run limited number of records in multiple shifts during non working hours or so.
Let me know if it helps you... if so action to mark as correct to clear the queue...
☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....
