alexed1
Datatable v4.1.4 - Formula fields are not shown
This issue is relative to the older Issue #882
Details
I have formula fields added to the datatable but they're only being displayed while I'm configuring the columns inside the flow builder. But not being shown after saving and running the flow.
Noting that the data are retrieved from the database, so it has the formulas.
Versions
datatable v4.1.4 FlowActionsBasePack v3.15 FlowScreenComponentsBasePack v3.2.2
On a Sandbox API 58.0
Screenshots
In the configurator after selecting the columns to be displayed
In the debug mode or after activating
Also, I've tried different formula fields that includes both hyperlinks as in screenshots above and text only.
Your help is much appreciated. Thanks.
What if you put the formula in a rich text field?
On Sat, Sep 16, 2023 at 4:08 PM Ahmad Ezzat @.***> wrote:
@ericrsmith35 https://github.com/ericrsmith35 any help regrading this please?
— Reply to this email directly, view it on GitHub https://github.com/alexed1/LightningFlowComponents/issues/1452#issuecomment-1722306339, or unsubscribe https://github.com/notifications/unsubscribe-auth/AF4UHX6BS7ZOUWRVWXQYKSTX2YBLPANCNFSM6AAAAAA4LQZLAY . You are receiving this because you were mentioned.Message ID: @.***>
@ericrsmith35 but how to put a formula field that contains a URL in a rich text?!
You could create the link inside of a Text Template resource and assign that to the field value in the flow.
Have you confirmed FLS for the formula field? Newly added fields are not always made visible, even to the System Admin profile.
@ericrsmith35 Thanks Eric for your response. I tried your workaround and unfortunately it doesn't work! Even I created a rich text field in the object and filled it with data on some records and still coming blank to the datatable!
The FLS are visible for all profiles.
Can you please show how you have the formula field configured? Are the records created before the flow even runs?
On Sun, Sep 17, 2023 at 4:40 PM Ahmad Ezzat @.***> wrote:
@ericrsmith35 https://github.com/ericrsmith35 Thanks Eric for your response. I tried your workaround and unfortunately it doesn't work! Even I created a rich text field in the object and filled it with data on some records and still coming blank to the datatable!
The FLS are visible for all profiles.
— Reply to this email directly, view it on GitHub https://github.com/alexed1/LightningFlowComponents/issues/1452#issuecomment-1722563957, or unsubscribe https://github.com/notifications/unsubscribe-auth/AF4UHX7EMNJXQO2NFPCTXK3X25N4JANCNFSM6AAAAAA4LQZLAY . You are receiving this because you were mentioned.Message ID: @.***>
This is the formula field: HYPERLINK(CASESAFEID(Id)&'/e', 'Edit' , '_self')
And yes, the flow is only getting data from database and showing them into the datatable.
PS: the formula field is for an edit url, because the lookup fields don't allow inline edit. A formula that only contains a static text also don't work.
@ericrsmith35 I'd be happy to hop in a call to run through this together.
Check out slides #21, #22 from this presentation I gave a Dreamforce on an alternative way to edit Lookup fields from a Datatable. https://docs.google.com/presentation/d/1AQXf6LYrkdsOI3e-8747fTS_qqq1IRiK/edit?pli=1#slide=id.g23ed53c4c9b_0_16
On Sun, Sep 17, 2023 at 5:08 PM Ahmad Ezzat @.***> wrote:
@ericrsmith35 https://github.com/ericrsmith35 I'd be happy to hop in a call to run through this together.
— Reply to this email directly, view it on GitHub https://github.com/alexed1/LightningFlowComponents/issues/1452#issuecomment-1722569286, or unsubscribe https://github.com/notifications/unsubscribe-auth/AF4UHX3C3SWUNKHM6MSY743X25RETANCNFSM6AAAAAA4LQZLAY . You are receiving this because you were mentioned.Message ID: @.***>
Thanks @ericrsmith35 for your response. I checked the presentation and it's really cool. However, when I tried this solution the datatable is not refreshed with the new values after saving the record from the recordDetail FSC as shown in slide 21.
Also, I'm still looking for the formula fields to work because it will be more convenient for editing when selecting multiple rows.
The Datatable is "refreshing" because in my example the flow is restarting. In a more complex flow, you could redirect back to thew Get Records after the Screen.
I don't understand why this was closed as completed. I am having this exact problem (formula field not displaying in datatable) .
@woodya-coder Are you sure you're including the formula field in your query or "Get Records" element?
I selected the option of letting Salesforce store the objects for me. To produce the behavior this is what I did.
- added a simple formula field to account that returned the string "hello world"
- created screen flow with Datatable element.
- used Get Record to get some accounts.
- Put the formula field into the datatable (note that the preview shows the data as expected).
- Run the flow When I run the flow, the rows are there in the table, but nothing is visible.
@woodya-coder @iahmadezzat Please let me know if the Field-Level Security on the Formula Field is set to Visible for the Profile running the flow. If it is nopt set to Visible, the Flow Builder will still show the field but it will be blank when running the flow.
@woodya-coder @iahmadezzat Any update on checking the Field Level Security for the formula field? I am unable to reproduce this behavior.
Hello Eric Sorry I've been so slow on this. The field level security is set to visible for all profiles. The field accessibility is set to Read Only for all fields.
Are you able to see a formula field okay in the Datatable?
On Sun, Jun 23, 2024 at 11:04 AM Eric Smith @.***> wrote:
@woodya-coder https://github.com/woodya-coder @iahmadezzat https://github.com/iahmadezzat Any update on checking the Field Level Security for the formula field?
— Reply to this email directly, view it on GitHub https://github.com/alexed1/LightningFlowComponents/issues/1452#issuecomment-2185256075, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOUWFBSGXMM3NKKZ3XAJXVTZI4E2LAVCNFSM6AAAAAA4LQZLA2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCOBVGI2TMMBXGU . You are receiving this because you were mentioned.Message ID: @.***>
-- Woody Anderson [image: LinkedIN Profile] http://www.linkedin.com/in/woodyaanderson