Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Approval System problem

Topic Labels: Automations
1471 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jared_Wright
6 - Interface Innovator
6 - Interface Innovator

I am trying to get set up a task system with sub approval stages that update dynamically if they are done early or late. Check out my video for more details.

https://www.loom.com/share/c2033ce26af54a62b5d4cc53c8e3c5ab?sid=bec94e89-54e0-4d89-a231-06bfa8872361

1 Reply 1
Alexey_Gusev
13 - Mars
13 - Mars

It's a hard task, that demands AT formula experience. In Task table you need to have rollup from Approvals with common info about all dates where stages were approved. In Approvals - formula which can extract a date of previous Approve, or if not, set initial planned date.
I suppose all approvals for Task X is linked to that task.
For example, Approve 1 received 2023-12-07, Approve 2 : 2023-12-11 , others still awaiting.  this info must be present in rollup field of Task table, and displayed from there as lookup 
In Approval table you need to craft a formula like
IF(  FIND ({Previous approve} & ':' , {Lookup of common info}) , MID ((Lookup..} , 14+FIND (({Previous approve} & ':' , {Lookup of common info})) , 10 )   
where 10 - len of date,
14 - len of 'Approve X : '
{Previous approve} = 'Approve ' & VALUE(RIGHT( {column containing 'Approve X'}))-1

output should be wrapped in some DATETIME_FORMAT to represent result as a date, or like DATESTR()
don't forget to wrap rollup/lookup fields in formulas in CONCATENATE() to convert array to string.
well, it's too long to explain, I created small raw example (a bit different from text here, but it's working), hope you can pause and see formulas. it's just a partial step in your task, you can get the idea and continue to fulfill your needs.
https://www.loom.com/share/de856b2370104665927cc41aec22e68f?sid=041e3e46-b880-4b7a-a13f-c239dd26a7d7