[SalesForce] How to concatenate fields using lightning:dataTable

I would like to combine the Account Name and Industry fields and display the values. Can someone please help?

component.set('v.mycolumns', [
            {label: 'Account Name', fieldName: 'Name', type: 'text'},
                {label: 'Industry', fieldName: 'Industry', type: 'text'},
                {label: 'Phone', fieldName: 'Phone', type: 'Phone'},
                {label: 'Website', fieldName: 'Website', type: 'url '}
            ]);

I have tried {label: 'Account Name', fieldName: 'Name', type: 'text'} + {label: 'Account Name', fieldName: 'Name', type: 'text'} and all sort of combination but nothing seem to work. Can someone help here?

I.e I want to display like Burlington Textile -> Textile

Thanks in advance.

Best Answer

No, you can't create formulas in a data table. You would need to calculate a value based on your criteria, such as:

dataRows.forEach(row => row.nameAndIndustry = row.Name + ' ' + row.Industry);

lightning-datatable and lightning:datatable do not otherwise support expressions for fields.

Related Solutions

[SalesForce] Lightning – How to use force:inputField

This is a current shortcoming of those components.

As explained to me by Doug Chasman, force:inputField and force:outputField have always been provided the metadata definition of what the sObject was by their containing component (for instance force:recordEdit). At some point they will be able to do so on their own, but for now, we need to help them.

The way to do this is to provide a default value object to the Account attribute, like this:

<aura:attribute name="account" type="Account" default="{ sobjectType: 'Account' }"/>

I just tested this out, and it works for me it works to get rid of the error.

[SalesForce] URL in

You are absolutely right that URLs should be able to have individual labels and the good news it is already completed to be shipped in Spring '18 release.

In Spring, you will be able to use type attributes to set the same label for all rows:

typeAttributes: {
           label: 'Company website'
       }

Or use another field to set the label:

typeAttributes: {
           label: { fieldName: 'urlLabel' }
       }

Obviously we wanted this in Winter but we wanted to make typeAttributes extensible for all types.

Best Answer

Related Solutions

[SalesForce] Lightning – How to use force:inputField

[SalesForce] URL in

Related Topic