Truncating Text-Formula Fields in Builder Data Tables/ DB's?

Help Center Get Answers
1

Hi Knacksters.

I have done a thorough search of the Forums and cannot seem to find a solution to a problem I am facing. The closest topic to the one I currently face is: https://forums.knack.com/t/truncate-long-fields-in-records-view-in-the-data-side/6304

This automated truncating of longer field (text paragraphs etc) values in the builder Data Tables/ DBs , does not apply to Text-Formula Fields, which will seemingly display the entire output of the Text-Formula regardless of output length.

Is there a potential workaround for this, as a long Text-Formula output requires significantly more scrolling/ navigation on Data Tables in the Builder, & I am unable to use Conditional Rules based on a Yes/No Flag to alter the Text Formula output.

Any assistance would be greatly appreciated.
Regards, Brandon

Untitled
Untitled1126×916 182 KB

2

Hi Brandon,
you could add a paragraph text field and use a conditional rule to set the value of it to the value of the text formula field. Then it would truncate. The only potential issue would be that you wouldn’t be able to inline edit it; not sure if that would matter for your use case though.
Hugo

3

Hi & Thanks Hugo, but that unfortunately won’t assist me within the builder itself. That is where the Text-Formula would still not truncate and require significant scrolling/ navigating through records due to the full display of the Text-Formula Outputs in the Database Tables themselves
My issue is not one of the Live Apps fields not truncating, only within the Builder Data Table themselves. Unless I am missing something here. Regards, Brandon

4

Ah, apologies, I didn’t read your description proerly! I don’t have a solutio for that, but if you find one I’d love to know it as I have the same in some apps.
Thanks