Automation

[paula]

Hi,

I'm creating a bot which should notify the 'former' Department Head that an Employee was reassigned to 'another' Department. If I wouldn't have nor I should have any specific 'former' department name and 'another' department name in the filter condition statement because there were options there, so it'd vary. What do I state in the trigger for the changes made particularly in Department?

Any idea would be appreciated!

[JuneCorpuz · Accepted solution]

---

@paula wrote:

What do I state in the trigger for the changes made particularly in Department?

---

---

[_THISROW_BEFORE].[Department] <> [_THISROW_AFTER].[Department]​

---

[JuneCorpuz · Accepted solution]

---

@paula wrote:

What do I state in the trigger for the changes made particularly in Department?

---

---

[_THISROW_BEFORE].[Department] <> [_THISROW_AFTER].[Department]​

---

[paula]

Thank you so much!

And perhaps, do you know how can I include the former Department in my email template as shown below?

Again, thanks!

[JuneCorpuz · Accepted solution]

You can use this formula 

[_THISROW_BEFORE].[Department]

[paula]

Thank you! Do I add a column for [new department] where this should be placed?

[paula]

Oh nevermind, I see I just had to copy it in my <<>>. Thanks again!

[paula]

Sir @JuneCorpuz , there's a problem, say the employee was reassigned to different Departments, it goes like this,

gives me ALL the former Department, starting from the first alteration. What do I do to just get the very last? Thank you!

[paula]

I saw why, I have all the positions filled when chosen once. And never altered in the excel, just adds to another.

But the reason I needed to separate [Position] per department is because I have different positions for each. And so I have made this columns REF type. Can you help me solve this? Thank  you!

[JuneCorpuz]

---

@paula wrote:

gives me ALL the former Department, starting from the first alteration. What do I do to just get the very last?

---

AFAIK this will only give you the most recent value.

[paula]

Okay sir, please take a look at this.

As I mentioned, I have several [Positions], therefore I could not state just [Position] because it would differ, it could be [Acctg Position], [Admin Position], [CMG Position], so on. So I did above. Since I have in the excel some of those true (they are also last position), it displays too. Do you know how I should sort it out? Thanks so much again for your time!

[JuneCorpuz]

You can add a new column called 'Previous Position' and create an automation with branching conditions to update this column if you change the [Acctg Position], [Admin Position] or [CMG Position] and put that in your report