Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need some help!
Is it possible to make a script that creats a field with the value in the result column? I want to find out if we have done something with the same sort code for the client before.
If ClientNo and Sort code is the same on a older matter the answer should be No.
ClientNo | MatterNo | Sort code | Created date | Result |
110000 | 1 | 1 | 2015-01-01 | New |
110001 | 2 | 2 | 2015-02-01 | New |
110002 | 3 | 1 | 2015-03-01 | New |
110003 | 4 | 3 | 2015-03-15 | New |
110000 | 5 | 1 | 2015-04-04 | No |
110000 | 6 | 2 | 2015-04-15 | New |
Regards
Magnus
You need for this a resident-load of your table with a sorting on ClientNo and SortCode and could the use peek() or previous() to check the current record-value with a previous one: Peek() vs Previous() – When to Use Each
- Marcus