Questions tagged [datatable]
An HTML table that is defined by iterating over a set of data, displaying information about one item of data per row.
175
questions
0
votes
0answers
17 views
How to preselect rows of Datatable exactly matching on filter?
If have a Lightning datatable that shows products matching all products starting with a value entered by the user in a filter field (so product%)
After hitting the Search button the datatable shows xx ...
1
vote
1answer
45 views
LWC is it Possible to Load the JQuery Plugin Datatables in a Lightning Web Component?
Edit: Solved!
I'm struggling to load the infamous datatables.net jQuery plugin into my Lightning Web Component. Even using the most basic example, I haven't had any luck. It seems like there are a ...
1
vote
0answers
83 views
How to fetch input field value in JS in LWC [closed]
in the below html code I am iterating 2 lists linItemData(11 records) and studyData(20 records)
<table class="slds-table slds-table_cell-buffer slds-table_bordered">
<thead>
...
1
vote
1answer
33 views
Inline editing datatable - show edit button on hover (LWC)
My column entries look like this:
<td aria-selected="true" class="slds-cell-edit" role="gridcell">
<span class="slds-grid slds-grid_align-spread">
<span class="slds-...
1
vote
1answer
24 views
How to edit cell value of lightning data table programtically
I have a lightning data table with a inline editable field. It working perfect as expected when I do manual edit and save. What I need in addition to the existing behaviour is, I need to edit the ...
2
votes
2answers
80 views
How to handle events from LWC datatable custom data types
I have created lightning data table MyLightningDataTable with a custom data type. This custom datatable is a child component of MyDataGroup component and MyDataGroup is a child of MyData component.
...
0
votes
0answers
10 views
Lightning Data Table
In Lightning datatable border is not showing in columns after scrollable.
<div class="slds-border_left slds-border_right slds-border_bottom slds-scrollable" style="height:37rem" ondblclick="{!c....
1
vote
1answer
118 views
Sending data to lightning-datatable lwc custom column type
I have a custom datatable with a custom column type containing a button, and a modal that pops up after the button is clicked.
I am having trouble figuring out how to send my datatable data to the ...
1
vote
1answer
45 views
displaying the lightning data in CSV file proper format [closed]
i am downloading the lightning data in CSV file as per the below screenshot
Now the issue is whenever i am trying to expand the Name column,the data is getting restricted to the name column only....
0
votes
1answer
35 views
Hyperlink a part of Text in Data-table column
I am trying to emulate the below view in LWC. The description value "Click here for Email Template" should only be hyperlink not the entire value, the value is passed from the apex class. Can anyone ...
0
votes
1answer
28 views
How to make a dynamic datatable with dynamic column count?
How to make such datatable, that will fetch all the columns in my custom object with particular data type and, when I add a new field to my object, the table will automatically fetch this field and ...
0
votes
0answers
11 views
Save flattened calculated field to object
I have a flattened datatable column like this one simplified:
helper:
newLine.amount = newLine.price__c * newLine.qty__c;
Now i need to create a new record on the SF Object with this "amount" value....
0
votes
1answer
29 views
Lightning-Datatable: Link to Case
Context - I am attempting to replace a legacy Visual Force table with a Lightning-Datatable. The only drawback I'm facing is that I cannot make the Case number in the table a link that jumps to the ...
0
votes
0answers
29 views
Why does a datatable that is nested inside a recordEditForm call onSubmit() on every inline edit?
As per the title, I have a datatable component nested inside my recordEditForm to display and edit some data (and never submitting, thus the suppressBottomBar="true"). The weird thing is that whenever ...
0
votes
0answers
23 views
How to add breaks in apex:datatable
I have an apex:datatable that lists opportunityLineItems. I want to render the columns based on the value of the lineitem field Product_Type__c and then add a break in between each group. I am able ...
0
votes
2answers
62 views
Passing parameter in getRowActions
JS Noob here.
I am currently following lwc datatable documentation to create a datatable with actions.
The constructor has an argument as 'data' which I want to pass in getRowActions method.
The '...
1
vote
1answer
525 views
lightning datatable (AURA or LWC) can automatically fetch records from database?
Is it possible to fetch records automatically from database just by mentioning columns?
Also can we use relationship fields to get data without any processing?
For example CreatedBy.Name ?
Other ...
0
votes
0answers
48 views
NavigationMixin : pages persist when going back
So I have this setup where I have a searchfield that, upon button click, navigates to a results screen where there is a lightning datatable.
Now, the problem is that if I go back from the results to ...
1
vote
1answer
547 views
Lightning Datatable Picklist and Lookup Work Around
I am aware that lightning:datatable does not support picklists.
The approved attributes are:
action
boolean
button
button-icon
currency
date
date-local
email
location
number
percent
phone ...
0
votes
1answer
64 views
Search & Column Sorting with SLDS Data Tables
I am trying to make a basic, external app with the Salesforce look-and-feel using Salesforce Lightning Design System (SLDS). Notably, the app includes data tables so I want to use the Data Table ...
2
votes
2answers
660 views
Re-Evaulating Selected-Rows in Lightning-Datatable When Data Changed
I've been stuck on this issue for a few hours now and don't seem to be getting any closer to resolving it.
I currently have a Lightning-Datatable with pagination that renders 20 rows at a time. When ...
0
votes
1answer
36 views
CSS for Excel Accounting Format?
I am working with a data table in Visualforce, and I am trying to get the columns with currency values to format similarly to how the account format looks in Excel, where it will align the dollar ...
1
vote
2answers
238 views
Cannot populate data in lightning data table
<aura:component controller="DisplayconsClass">
<aura:attribute type="Contact[]" name="consList"/>
<aura:attribute name="mycolumns" type="List"/>
<aura:handler name="...
0
votes
1answer
55 views
Is it possible to use navigateToSObject with data tables
I am using below to convert Subject column to hyperlink as below
{label: 'Subject', fieldName: 'linkName', type: 'url',
typeAttributes: {label: { fieldName: 'Subject' },
...
0
votes
1answer
571 views
Lightning Web Components lightning-datatable detect “select all” checkbox
When using the lightning-datatable component, by default each row has a checkbox beside it (unless so explictely specify hideCheckboxColumn to false). So when a row is selected the onrowselection ...
1
vote
1answer
1k views
Lightning Web Components inline editing Datatable - data update issue
I am starting with Lightning Web Components and I've tried to use data table.
For some reason I can see data being changed in table - but in js controller my variable remain unchanged.
js
import { ...
0
votes
1answer
524 views
Is there any way to disabled a row in a data table
I have a following data in a List,
From the following data I will create the native lightning datatable and it looks like follows
0: {Name: "Test Contact 2", Person__c: "a0j4E00000BY96GQAT"}
1: {...
0
votes
1answer
25 views
Merge lists to get a good overview
I have two objects (one custom object "sales", two standard object "opportunity" and "account") and I have three lists with aggregateresults.
Can I merge these lists into one list?
The goal of the ...
0
votes
1answer
959 views
Limit of records to show in <lightning:datatable> [duplicate]
I am new to lightning datatable, Using soql query we can get up to 50000 records, but is there any limit to show these records using lightning:datatable in lightning component ? If yes then how many ...
1
vote
1answer
209 views
Is there a way to insert a <div> right below a datatable row?
I need to put a div right below a lightning:datatable row.
Is there a way ?
0
votes
0answers
40 views
Is it possible to set a value (in table) dynamically through lightning javascript event?
I have list of object records displayed in a table on lightning component. I would like to dynamically set a field value when another field value is changed. I should be showing the set value to the ...
0
votes
1answer
862 views
Can we add bold style to last row in Lighitng Data table??
I am using "lightning:datatable" tag to display set of rows in UI. Few columns are numeric data. I needed last row to be summarized values of all the data set.
I don't find any standard summary ...
2
votes
1answer
46 views
Rerender not loading new records for datatable
I am displaying custom object records in a datatable. I modify the data using the Salesforce API (i.e. outside the current page), and then when the user clicks a button I want to rerender the ...
1
vote
1answer
456 views
Datatable inline lookup editing
As showed here we can easily implement an inline editing of a data table.
Now I will need to have this editable field to behave like a lookup field and not a normal text field.
Is this possible? ...
2
votes
1answer
1k views
Lightning Datatable - Errors Attribute
Could someone provide a working example of a lightning:datatable that utilizes the 'Errors' attribute? I want to validate fields in a datatable and flag the cells that need correction. According to ...
-1
votes
1answer
469 views
Lightning table header and body are not aligning
I have a component where the data is displayed using html data table aura:iteration. However the header is not aligned with the body. I have tried with many slds css but no success. Can anyone pls ...
0
votes
1answer
94 views
Line Break in Visual Force Page Table
i did already a little research and could not find the right answer to it.
I have a visual force page with tables for an invoice template.
In the details for line items, i have the description field, ...
1
vote
1answer
1k views
jquery datatables in lightning component
I have a lightning component which uses jquery datatables.User needs to filter the datatable using Stage picklist and date field.Based on the user selection(Stage and Date) then datatable needs to ...
7
votes
0answers
316 views
Lightning Datatable Action Violates Content Security Policy directive
I'm using Lightning Datatable with Static Actions and following the guide in Developer Salesforce.com Lightning Datatable component guide but getting the following error (seen in the Chrome developer ...
0
votes
1answer
290 views
jQuery DataTables Checkboxes in Visualforce Page
I am trying to manipulate multiple row selections using jQuery DataTables
checkboxes plugin.But having issues in getting selected rows from page to controller ...getting c.selected = false in ...
1
vote
1answer
972 views
Insert a link in lightning datatable Column Value
I am trying to insert a link in a result column of lightning:datatable
Below is the code snippet :
Datatable Code:
<lightning:datatable data="{! v.contactList }"
columns="{...
0
votes
2answers
100 views
VisualForce - Data Table - Floating Headers
I can't figure out if the Script itself isn't working or if I am doing something else wrong with my visualforce page. My goal is to get the table headers to stay visible but every single approach I ...
0
votes
2answers
30 views
add two numerical values from soql and show on visualforce page
I want to add actTotalAmount and purTotalAmount and show it on the visualforce page.
Right now I have another fuction to show actTotal and purTotal on visualforce page, but I couldn't find a way to ...
1
vote
2answers
30 views
Calculating grand total of child object's field
public static List <Pricing_Lookup__c> getGrandTotal(){
List<Pricing_Lookup__c> calculateTotal = [Select Name, (Select Name, Unit_Price__c From Activity_Lookup__r) From ...
1
vote
0answers
224 views
lightning:datatable table headers are disappearing in iPad safari browser
I am using lightning:datatable, the table headers are disappearing in iPad safari browser when I try to resize the coloum headers by draging.
Please help me in resolving this.
0
votes
1answer
90 views
Need help writing query for 3 custom objects in master detail relationship
I'm trying to create a table on Visualforce page like this.
Each pricelookup's description has it's own activity and purchase info.
Custom parent object - Pricing_Lookup__c
Custom child object - ...
0
votes
0answers
109 views
Compare Table experts needed!
Description:
I have a table like below, the Price Change row which contains '300' for 2018 and '600' for 2019 is the sum of values of all products per year.
Price Change is a column defined by the ...
1
vote
1answer
522 views
How to iterate sub query on lightning page
I want to display the contact names and opportunity names where AccountID is not null, I am able to display the contact names, can someone please help me to display the opportunity names too?
Below ...
0
votes
1answer
59 views
Display Relationships Between Lists on Visualforce Page
I have a list of strings.
I am using these strings to populate three other object lists by querying for this string.
For every iteration I am adding the lists populated to a List of lists. Ex: ...
0
votes
1answer
87 views
Show table headers in a row
I have below table where the headers and data are showing perfectly but in a same column. Instead I need to show them in a proper table format. Unfortunately, I am unable to do so.
Can someone please ...
