In the Datatable component has begun to show related field IDs instead of the name and URL, even when specified, for related object fields. Has anyone see this or found a workaround to this?
This bug started to show up in both Preview and non Preview sandboxes (haven't deployed this to production yet) for us a few weeks ago.
I updated to 4.3.7 today and it is still present. What is
reallyodd is two things:
1. Administrator users do not experience this bug.
2. When using Debug in Flow and running as another user, it renders properly.
The screenshot below shows the datatable component and the out of the box Datatable component that is due out in Summer '26, where it renders properly.
I have an open ticket with Salesforce support, but they have been "researching" for a few days now and it would be helpful to know if this is something bigger than our implementation or if there is a workaround.
Thanks!
Hey All,
I heard back from Salesforce. The issue here is as follows (per Salesforce support):
The ers_Datatable Lightning component renders lookup fields as clickable links by enriching the row data through its Apex controller (ers_DatatableController.getReturnResults). Inside getColumnData, lookup fields are only added to the lookupFields collection when the running user has Edit (Updateable) access to the field:
when 'REFERENCE' {
if (dfr.isUpdateable()) {
lookupFields.add(fieldName);
}
}
In other words, the documentation on the UnofficialSF website is might need some slight wording adjustment. That is, the user in question needs EDIT permissions on the field itself, not the just the object that the datatable is listing records for.
In case it helps anyone, I compared to the standard/out of the box datatable links to related records feature due in the next update and the "Edit" permission is not required. I do think the standard datatable component is still lacking a large number of features, though.