Best way to record multiple client details for one record in SharePoint list

Hi EmmaVR,

To record multiple client details in a single SharePoint list entry, you can use a Multi-Line Text field. This approach offers a structured way to enter and store client data within a single list item.

Steps:

1. Create a new Multi-Line Text field in your SharePoint list and name it "Client Details."
2. In the field description, provide clear instructions on how to enter client details in a structured format. For example, suggest that users enter each client's information in rows with columns for name, position, phone number, and email.
3. To display the data in a more readable format, you can use JSON formatting. To do this, follow these steps:
   • Navigate to the List tab and click Settings.
   • Under Columns, click the name of the Multi-Line Text field.
   • In the Column formatting section, select JSON.
   • In the JSON formatting dialog box, enter the following JSON code:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v1/column-formatting.schema.json",
  "elmType": "table",
  "headers": [
    { "title": "Name" },
    { "title": "Position" },
    { "title": "Phone Number" },
    { "title": "Email Address" }
  ]
}