---
title: When you want to sort email and attachment records by DateSent but attachments do not have the field populated.
description: LAW has a run command that populates the field value from a parent record into the same field on a child or attachment records. The simplest approach is to use the command to populate DateSent in the attachment records.
---
[Skip to content](https://kb.cloudnine.com/when-you-want-to-sort-email-and-attachment-records-by-datesent-but-attachments-do-not-have-the-field-populated#main-content)
English
Show submenu for translations
[Contact us](https://kb.cloudnine.com/kb-tickets/new?hsLang=en)
Open main navigation
Close main navigation
- English
Show submenu for translations
- [Contact us](https://kb.cloudnine.com/kb-tickets/new)
- [Go to cloudnine.com](https://cloudnine.com/)
[Go to cloudnine.com](https://cloudnine.com/)
Hello. How can we help you?
- There are no suggestions because the search field is empty.
1. [Help Center](https://kb.cloudnine.com/?hsLang=en)
2. [LAW](https://kb.cloudnine.com/law?hsLang=en)
3. [DataSent](https://kb.cloudnine.com/law?hsLang=en#datasent)
# When you want to sort email and attachment records by DateSent but attachments do not have the field populated.
## LAW has a run command that populates the field value from a parent record into the same field on a child or attachment records. The simplest approach is to use the command to populate DateSent in the attachment records.
This article covers the steps of creating a new field and populating it for email and attachment records.
Note: If you want the simpler approach, complete step 1 and then skip to step 4, and use field name DateSent in the Run Command. Remember it is not recommended to populate email metadata in non-email records if you will later be exporting metadata values.
1. Install the *Copy Parent Field To Attachment* run command on your workstation.
Obtain the zip file and instructions for LAW run commands from the link below: [https://answercenter.ediscovery.co/litigation/ac/law\_documentation/7.8RunCommands.zip](https://answercenter.ediscovery.co/litigation/ac/law_documentation/7.8RunCommands.zip)
Unzip the file.
Close LAW on your workstation.
Copy the *Copy Parent Field To Attachment.txt* file under the *Copy Parent Field to Attachment – entire case* folder to C:\\Program Files (x86)\\LAW50\\Run Commands and rename the file extension from .txt to .vbs. Note: there is a different run command that works on a tagged set of records only. Please see the instructions in that folder if interested in using that command instead of updating the entire case.
2. Create a *DateSort* field.
Access the Index menu option from the main LAW view and select Modify.
Click the green Add Field plus sign in the upper left.
Add field *DateSort* (or name of your choosing.)
Select *Document-Level* from the Table drop-down and *Date* from the Type drop-down.
Click OK and Save the new field.
Close the Modify Fields dialog box.
3. Copy DateSent to DateSort.
If you have a large case, this step is faster if you isolate email records in your Grid view but isn’t necessary.
Include the DateSent and DateSort fields in Grid view.
Highlight the DateSent field and select the Copy icon on the tool bar.
Now highlight the DateSort field and select the Paste icon on the tool bar.
\*\* Be sure the Copy Column dialog is confirming you are copying from DateSent to your sorting field!\*\*
After clicking Yes, DateSort should now populate for email records but not yet for attachment records.
4. Copy the DateSort email parent values to attachment records.
Close the Grid view.
From the main view of LAW, select Tools \> Run Command \> Copy Parent Field To Attachment (See step 1 if you do not see this command on your workstation.)
Select OK on the proceed dialog box.
Enter ***DateSort*** and select OK.
A dialog box will let you know how many records were updated. Select OK.
5. Use Grid View to QC your results:
See how the attachment record indicated by AttachLvl = 1 now has the same DateSort as the parent in the record above it?
- [CloudNine Training Videos](https://kb.cloudnine.com/cloudnine-training-videos?hsLang=en#main-content)
- [CloudNine Videos by Product](https://kb.cloudnine.com/cloudnine-training-videos?hsLang=en#cloudnine-videos-by-product)
- [CloudNine Review](https://kb.cloudnine.com/cloudnine-review?hsLang=en#main-content)
- [CloudNine Review Video Library](https://kb.cloudnine.com/cloudnine-review?hsLang=en#cloudnine-review-video-library)
- [Section 1: Getting Started](https://kb.cloudnine.com/cloudnine-review?hsLang=en#section-1-getting-started)
- [Getting Started: My Projects](https://kb.cloudnine.com/cloudnine-review?hsLang=en#getting-started-my-projects)
- [Section 2: Understanding Different Views](https://kb.cloudnine.com/cloudnine-review?hsLang=en#section-2-understanding-different-views)
- [Section 3: Searching](https://kb.cloudnine.com/cloudnine-review?hsLang=en#section-3-searching)
- [Section 3A. Smart Filters](https://kb.cloudnine.com/cloudnine-review?hsLang=en#section-3a-smart-filters)
- [3b: Search Term Lists](https://kb.cloudnine.com/cloudnine-review?hsLang=en#3b-search-term-lists)
- [Section 4: Working with Documents](https://kb.cloudnine.com/cloudnine-review?hsLang=en#section-4-working-with-documents)
- [Generating Images](https://kb.cloudnine.com/cloudnine-review?hsLang=en#generating-images)
- [Automated Redaction](https://kb.cloudnine.com/cloudnine-review?hsLang=en#automated-redaction)
- [Exporting/Producing](https://kb.cloudnine.com/cloudnine-review?hsLang=en#exporting-producing)
- [Section 5: Administrative Functions](https://kb.cloudnine.com/cloudnine-review?hsLang=en#section-5-administrative-functions)
- [Reporting](https://kb.cloudnine.com/cloudnine-review?hsLang=en#reporting)
- [Frequently Asked Questions and Issues](https://kb.cloudnine.com/cloudnine-review?hsLang=en#frequently-asked-questions-and-issues)
- [Cloud Connector](https://kb.cloudnine.com/cloudnine-review?hsLang=en#cloud-connector)
- [EULA](https://kb.cloudnine.com/cloudnine-review?hsLang=en#eula)
- [CloudNine Discovery Portal](https://kb.cloudnine.com/cloudnine-discovery-portal?hsLang=en#main-content)
- [CloudNine Discovery Portal Video Library](https://kb.cloudnine.com/cloudnine-discovery-portal?hsLang=en#cloudnine-discovery-portal-video-library)
- [Getting Started](https://kb.cloudnine.com/cloudnine-discovery-portal?hsLang=en#getting-started)
- [File System Workflows](https://kb.cloudnine.com/cloudnine-discovery-portal?hsLang=en#file-system-workflows)
- [Data Transfer Workflows](https://kb.cloudnine.com/cloudnine-discovery-portal?hsLang=en#data-transfer-workflows)
- [LAW Bridge](https://kb.cloudnine.com/cloudnine-discovery-portal?hsLang=en#law-bridge)
- [Global Monitoring Console](https://kb.cloudnine.com/cloudnine-discovery-portal?hsLang=en#global-monitoring-console)
- [Advanced Features & Troubleshooting](https://kb.cloudnine.com/cloudnine-discovery-portal?hsLang=en#advanced-features-troubleshooting)
- [LAW](https://kb.cloudnine.com/law?hsLang=en#main-content)
- [CloudNine LAW Video Library](https://kb.cloudnine.com/law?hsLang=en#cloudnine-law-video-library)
- [CloudNine LAW: Did You Know?](https://kb.cloudnine.com/law?hsLang=en#cloudnine-law-did-you-know)
- [Installation and Setup](https://kb.cloudnine.com/law?hsLang=en#installation-and-setup)
- [Print Queue Management](https://kb.cloudnine.com/law?hsLang=en#print-queue-management)
- [Turbo Import](https://kb.cloudnine.com/law?hsLang=en#turbo-import)
- [ED Loader](https://kb.cloudnine.com/law?hsLang=en#ed-loader)
- [Errors](https://kb.cloudnine.com/law?hsLang=en#errors)
- [Email](https://kb.cloudnine.com/law?hsLang=en#email)
- [Endorse](https://kb.cloudnine.com/law?hsLang=en#endorse)
- [Document Numbering](https://kb.cloudnine.com/law?hsLang=en#document-numbering)
- [Annotations](https://kb.cloudnine.com/law?hsLang=en#annotations)
- [Image Conversion](https://kb.cloudnine.com/law?hsLang=en#image-conversion)
- [Near Dupe](https://kb.cloudnine.com/law?hsLang=en#near-dupe)
- [SQL](https://kb.cloudnine.com/law?hsLang=en#sql)
- [Batch Printing HTML](https://kb.cloudnine.com/law?hsLang=en#batch-printing-html)
- [DataSent](https://kb.cloudnine.com/law?hsLang=en#datasent)
- [Filter and Search](https://kb.cloudnine.com/law?hsLang=en#filter-and-search)
- [Administration](https://kb.cloudnine.com/law?hsLang=en#administration)
- [Explore](https://kb.cloudnine.com/explore?hsLang=en#main-content)
- [CloudNine Explore Video Library](https://kb.cloudnine.com/explore?hsLang=en#cloudnine-explore-video-library)
- [Managing Cases](https://kb.cloudnine.com/explore?hsLang=en#managing-cases)
- [Importing](https://kb.cloudnine.com/explore?hsLang=en#importing)
- [Searching](https://kb.cloudnine.com/explore?hsLang=en#searching)
- [Exporting](https://kb.cloudnine.com/explore?hsLang=en#exporting)
- [Concordance](https://kb.cloudnine.com/concordance?hsLang=en#main-content)
- [Searching](https://kb.cloudnine.com/concordance?hsLang=en#searching)
- [eDocs](https://kb.cloudnine.com/concordance?hsLang=en#edocs)
- [Email](https://kb.cloudnine.com/concordance?hsLang=en#email)
- [Other](https://kb.cloudnine.com/concordance?hsLang=en#other)
- [Exporting](https://kb.cloudnine.com/concordance?hsLang=en#exporting)
- [Proof of Concept](https://kb.cloudnine.com/concordance?hsLang=en#proof-of-concept)
- [Concordance Desktop](https://kb.cloudnine.com/concordance-desktop?hsLang=en#main-content)
- [Email Database](https://kb.cloudnine.com/concordance-desktop?hsLang=en#email-database)
- [CloudNine Analyst](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#main-content)
- [CloudNine Analyst Video Library](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#cloudnine-analyst-video-library)
- [FAQ](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#faq)
- [Known Issues and Behavior](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#known-issues-and-behavior)
- [Account](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#account)
- [Projects](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#projects)
- [Import](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#import)
- [Export](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#export)
- [Machine Translation](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#machine-translation)
- [Reports](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#reports)
- [Investigations](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#investigations)
- [ESIA Desktop](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#esia-desktop)
- [ESIA Sync](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#esia-sync)
- [Administration](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#administration)
- [On Premise Software Q&A](https://kb.cloudnine.com/on-premise-software-qa?hsLang=en#main-content)
- [On Premise Software](https://kb.cloudnine.com/on-premise-software-qa?hsLang=en#on-premise-software)
- [EULA](https://kb.cloudnine.com/on-premise-software-qa?hsLang=en#eula)
[](http://www.cloudnine.com)
12848 Queensbury Lane, Suite 208 | Houston, TX 77024 | 713-999-4280 | [info@cloudnine.com](mailto:info@cloudnine.com)
Copyright © 2026, CloudNine