How to compare records within the same custom table and update a reference field.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2024 01:35 AM
Hi Team ,
Is there any script that can be written to compare records within the same table.
I have got a custom table that has records belongs to the year 2023,2024 and the problem is in the records that belong to 2024 ,there is a reference field called "Last year" which displays empty.
Expected behaviour is that the "Last year" field should have been mapped with the respective 2023 records and that means for every 2024 records there was already 2023 records available in the table but it was not mapped .
Is there any script which can be written in the backend to map the 2023 records with respective 2024 records ?.
Thanks
0 REPLIES 0