Help on replacing the values through Business rules

[Aswin Chandras1]

HI All

 I will get an value in the last logged in user field in computer table I need to trim that and need to check the same in user_id in the user table. Example value is: abc@example.com. ABC is the user id value or RF ID in user table.

If the value is not present in user_id then I need to check RF ID value in user table. Now my requirement is if the value is not present/unavailable in the user table in both user_id and RF ID I need to clear the value from most frequent logged in user in computer table.

[Ankur Bawiskar]

@Aswin Chandras1 

share what script you tried and what's not working?

[Aswin Chandras1]

Hi Ankur,

I tried the attached script. Now I need to check both user_id and rf_id from user table. If value is not present in either of the field I need to remove the value from frequent loged in user.

[GlideFather]

@Aswin Chandras1 is ts insert or update and executed when before, after, async?

[Aswin Chandras1]

It is before insert and update