Please explain how we can use index function with cdt? want explanation with example.

Hi sowmyak2554 ,

Lets assume you have 3 column in a CDT EmployeeData as "Name", "Number", "City". now if you want to fetch all the values of City column, you need to use the index function as below:

Index(Your_CDT,column_Name,default_Value)

Index(EmployeeData, "City", null)

And in case of Record type, code syntax will be same. but you can not index it directly by giving the column name, you need to pass the column name as below

Index(EmployeeData, recordType!yourRecordName.fields.yourField, null)

Hi sowmyak2554 ,

Lets assume you have 3 column in a CDT EmployeeData as "Name", "Number", "City". now if you want to fetch all the values of City column, you need to use the index function as below:

Index(Your_CDT,column_Name,default_Value)

Index(EmployeeData, "City", null)

And in case of Record type, code syntax will be same. but you can not index it directly by giving the column name, you need to pass the column name as below

Index(EmployeeData, recordType!yourRecordName.fields.yourField, null)