Shorten the displayed text in a report | Adobe Higher Education
Skip to main content
T
ThomasNe2
Level 4
November 30, 2023
Répondu

Shorten the displayed text in a report

One of our teams uses a custom form which request descriptions which can be rather long.

I have built a report to summarise information submitted on the custom form which contains the description fields. I have included a screenshot to illustrate an example of the length.

Is there a way to limit the amount of detail shown in the report details tab without removing this column? A way so only, for example, half of the content is shown?

Meilleure réponse par ajdifonzo

Hi Doug

 

Thanks for your response. 

 

I haven't been able to affect the result with what you advised.

 

I have attached screenshots here. 

 

Thomas


This should do it. 

 

valueexpression=LEFT({DE:Please tell us what you would like},150)

1 commentaire

ajdifonzo
ajdifonzo
Level 3
November 30, 2023

Hi, 

You can use the following to limit what is show. Since you noted the description field that is what I used.  The 25 would be the number of characters you would like to show. 

 

valueexpression=LEFT({description},25)

 

If this helps, please mark as correct so it can help others. 

T
ThomasNe2Auteur
Level 4
November 30, 2023

Thanks for your response. 

I have pasted this in but it results in the column becoming completely blank. 

The title of the column concerned is 'Please tell us what you would like' and I also replaced this in the coding you sent but the result is the same and the column shows blank. 

Any ideas?

ajdifonzo
ajdifonzo
Level 3
November 30, 2023

please provide the original text for the column so I can take a look. 

Conditions d'utilisationAccessibility statement

Loading footer...