In regards to the calculation between two record
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
I need a calculation between two records in my app engine. I am currently working in dev environment - sandbox and needed to get a column which gives the difference between two fields.
as a example:
column 1: due date - 08/31/2025
column 2: lead time - 30
output : start date: 08/31/2025 -30 = 07/31/2025
and i want to use this a trigger daily on flows. How i can get this difference in my instance. I tried using formula but not working. my instance is currently not allowing me to script anything. can anybody let me know the logic can be used?
Thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi @RockRsv
8/31/2025 - 30 = 8/01/2025 😉
you can create a new field and calculate it into it. Will it be always 30 or it may vary?
if always 30, you can set a default value to the field to be always -30 or it can be onChange client script or a business rule.. please provide more details
/* If my response wasn’t a total disaster ↙️ ⭐ drop a Kudos or Accept as Solution ✅ ↘️ Cheers! */
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Thanks for the correction. It can vary. so i need to get automatically based on date date - lead time to get a date in the filed and schedule the trigger. @GlideFather
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
@GlideFather - I tried using the business rule in the properties but couldn't achieve the result. like subtract {due date - lead time}.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
@RockRsv Please share an error message, logs or screenshots..
what does “i couldnt achieve” mean? Was the br triggered?
/* If my response wasn’t a total disaster ↙️ ⭐ drop a Kudos or Accept as Solution ✅ ↘️ Cheers! */