See this in action during DreamTX!
The Datatable Flow Screen Component has come a long ways from the original Aura component that included separate attributes for 10 different Salesforce objects in a single component. Once Salesforce supported the ability to pick the desired Object in the Flow Builder, at the time of configuration, it was rebuilt from scratch as a Lightning Web Component. Now Datatable has been reimagined again with the addition of a Custom Property Editor that’s used by the Flow Builder whenever a Datatable is added to a Flow Screen.
Custom Property Editors allow a developer to bypass the standard basic list of all component attributes in the Flow Builder and replace it with a Lightning Web Component that can present a logical and formatted interface for the user to configure the component. The CPE developed for the Datatable component takes this even further by including a button that launches a separate Flow that displays a special Datatable the user can interact with to configure their Datatable. I like to refer to this as my Custom Column Configuration Wizard.
Once installed, this component will appear as Datatable in the Flow Builder. DatatableV2 will still work with your existing Flows and can coexist with the new Datatable.
Here are a few examples showing how to build a Flow with a Datatable, how to configure the Datatable using the Custom Property Editor and how a user can interact with a Datatable. For complete documentation, visit the Datatable page.
25 thoughts on “Datatable Now Includes a Custom Property Editor”
Thanks a lot for that! I just noticed that OpportunityContactRole object is missing on CPE list.
There’s something that can be done to fix it?
I will be releasing an update that allows the selection of more standard objects.
LikeLiked by 1 person
I was actually coming here to comment that there were some objects missing from the available list, but I see your comment above now, so that clarifies that for me 😉👍
The 3.0.4 update now includes this as of 12/21/20.
Happy New Yearâ¦
Very excited on this new development which I have just tried to use but failed at the nth attempt.
When I select configure columns the application freezes and I get the following (Non)response:
Here is a screenshot of the Datatable partial configuration.
Any Ideas as to what is causing this problem?
DD: 0044 1428 654410
Mob: 0044 7785 722201
Eric Smith posted: ” See this in action during DreamTX!Flow Builder Demos 12/17 (1PM, 2PM, 3PM Eastern Time) The Datatable Flow Screen Component has come a long ways from the original Aura component that included separate attributes for 10 differe”
I am not able to see your screenshots. Can you put them in a shared directory and send me a link?
I just went to update to v 3.0.5 and I’m getting the following error message:
Error Number: 839023212-6133 (1902849370)
1. No MODULE named markup://c:fsc_pickIcon found : [markup://c:datatableCPE]
datatableCPE: No MODULE named markup://c:fsc_pickIcon found : [markup://c:datatableCPE]
Is this an issue with the package, or am I missing something?
I actually realised I missed update 3.0.4, so i ran that, d I’m getting this error:
Error Number: 393849117-8016 (104329808)
1. Cannot add component of type:LightningComponentBundle named:datatableCPE subjectId:0Rb5I000000H53u to another package because it is an installed component.
package.xml: Cannot add component of type:LightningComponentBundle named:datatableCPE subjectId:0Rb5I000000H53u to another package because it is an installed component.
You will first need to update the Flow Base Packs as there are some changes in those that Datatable takes advantage of.
I have both Flow components packages up to date. Still receiving those errors though.
Is there anything I can provide you to help?
Please share a screenshot of your Installed Packages from Setup and I’ll take a look.
LikeLiked by 1 person
Here’s a screenshot I’ve uploaded for you ( https://ibb.co/k91WSCD )
Are you able to uninstall Datatable v3.0.2? Do you have any other older versions of datatable installed?
Im getting this same error. The issue is I have the data table in ~40 flows in multiple flow screens and multiple lightning pages.
The only way I can think to fix it is create a sandbox, remove everything from prod, update the datatable then push the original config back from the sandbox to prod?
Unfortunately that may be the only way to get the upgraded version installed.
i actually found a way…
If i remember correctly, I removed all the metadata components in the package then it allowed me to either upgrade or remove then install without removing the component from a single flow.
LikeLiked by 1 person
First, I want to say that datable is a great addition to my flows- thank you for your work on it. That said, I just ran into an issue of late, I updated to the most recent version 3.1.1 but I am running into a date issue. The dates appear to be in UTC as they are appearing a day earlier that if directly queried. I am in ET as well. I saw your note that “If you add custom TypeAttributes to a Date or Datetime field, the value will be converted from a ‘date-local’ value to a standard datetime value. This will cause the value to be processed as UTC time rather than being converted to the browser’s local time zone.” However, I am not applying any custom TypeAttributes, I am using the default. I cannot seem to find a workaround. Can you provide any direction?
This will be addressed in the next release. I will let you know when I publish it.
This has been addressed in the v3.2.2 release. https://unofficialsf.com/datatable-latest-release-notes-v3-2-2/
Hi Eric. Thanks for the great component.
I am attempting to use the datatable to display a record collection of not yet created records. These records do not yet have a record ID. I’ve attempted to modify the “Key Field” parameter to another custom field “Custom_Id__c” for which I’ve populate a unique value for records in the collection. However, I receive this error when the screen with the datatable loads “Apex Action error: Unable to read SObject.”
I’ve attempted to look through the posts and videos but have yet to find any reference to modifying this Key Field parameter. Am I using this incorrectly or is this not an intended use of the component? Thanks
To “fool” the component, go ahead and use the regular Id field to store your unique temporary Id values. Just make sure that the first 3 characters of the Ids match the first 3 characters used by all Ids for the Object you are trying to display.
Hi, i have modified one of the paex code works fine in sandbox, but have problems deploying
Cannot add component of type:ApexClass named:ers_DatatableController subjectId:01p2y000000Rlt7 to another package because it is an installed component.
any ways around it?
Which component did you change?
I have a great use for the datatable, but I cannot edit the properties. Any idea how to solve this issue?
When I click the Configure Columns button under the Table Formatting header, a window opens, but never succeeds in loading. I’ve tried Chrome, Opera, Edge browsers, but similar result.
Please Wait… Loading Field Details. Or reference to a visualforce page which is blocked.
Installed packages are datatable 3.4.5, FlowScreenComponentBasePack 2.7.6
I installed the permisson set for the USF Flow Screen Component – Datatable
I’ve tried whitelisting the visualforce page in my browser, allowing cookies.
If you see this error when trying to Configure Columns, try going to Setup > Security > Session Settings and unchecking “Enable clickjack protection for customer Visualforce pages with headers disabled“. Also, in your Setup > User settings, make sure both Debug Mode and Development Mode are Unchecked.