update field based on another field on same table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-08-2024 10:17 AM
Hello,
I am looking to create a BR between these two fields
Fields
1. Office
2. previous office "previous_office"
When the field office changes, I want the field "previous office" to show what was within the offive field before changing. This is my current BR but it is not working.
When: before
active: (X)
advanced: (X)
Insert: Update: (X) Delete: Query:
Filter changes: office "changes"
Script:

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-08-2024 10:29 AM
@Averyy Script looks ok to me, can you double check the column name is correct in your script? Both fields are string type field ?
I would suggest add logs to check what values are coming based on that you can identify the issue .
Thanks,
Harsh