Displaying Full LongText Notes in Table View

[Sherin_Premkumar]

Hello,

I have a field called Notes (Type: LongText) in my table view. Currently, the table only displays a portion of the text, making it difficult to read the full note. While I understand that the complete content can be viewed in the Detail View, I’d prefer to avoid requiring users to click into each record.

Are there any workarounds available, such as:

• A tooltip that displays the full note on hover?

• Text wrapping that automatically increases the row height to fit the content?

• An alternative column type or display option that shows more (or all) of the text directly in the table view?

I’m looking for a way to make the full Notes content more accessible without requiring an additional click.

[Suvrutt_Gurjar]

Like this will do? However it is a bit clumsy workaround and may need more testing for edge cases. Please note that an additional click on the action icon is required. Also another click to go back to the table view.

[Sherin_Premkumar]

Is there anyway I can skip the click and hover instead?

Else yes this is fine. can you guide me on how to do this?

[WillowMobileSys]

@Sherin_Premkumar

Is there anyway I can skip the click and hover instead?

Yes, You can assign your text to the Display Name of an Inline Action. When you hover over the action the assigned text will be displayed in a “tooltip” popup. See example below. It’s not very elegant but would do the job.

NOTE: there is no analogous way to “hover” on a mobile device so you would not see the “tooltip” text on those devices. @Suvrutt_Gurjar solution above would be possible on both Desktop and mobile.

[Suvrutt_Gurjar]

Hi @WillowMobileSys ,

@Sherin_Premkumar has mentioned below

@Sherin_Premkumar

I have a field called Notes (Type: LongText) in my table view.

Are you able to assign a long text column to the display name and then display that long text?

If that works, then yours is an ideal solution.

In the example you shared, you have hardcoded long text string in the display name setting.

I also tried the display name approach before suggesting the click based solution. I was unable to display text from a long text column in the display name setting of an action.

Upon seeing your post , I retested by entering a long text column in the display name but the action instead displays the original short action name on hover. My guess is AppSheet has restricted the action names to certain finite length or it does not accept the long text column in display name expression.

@Sherin_Premkumar ,

If @WillowMobileSys is able to display the long text column in display name setting of an action, then please consider his solution as most matching to your requirement.

Or else, I will mention my workaround in detail. My solution centers around adding the long text column in the “Confirmation Message” part of the action with some other changes in relavant settings.

[Steve]

@Suvrutt_Gurjar

Are you able to assign a long text column to the display name and then display that long text?

I’m pretty sure Display Name is Text, so newlines in a LongText value will be removed.

[Suvrutt_Gurjar]

Yes , correct Steve.

Action name display on hover was naturally my first test choice. It did not work.

The very reason I embraced " confirmation message" option that does require click on the action button.

I think @WillowMobileSys probably missed testing with a long text column in display name. Anyway I am sure he will revert.

[Sherin_Premkumar]

I don’t want to hard code the value and I also want to use LongText.

So my only option is to have an additional click on the action right?

Can you please tell me how to do that @Suvrutt_Gurjar?

Thank you so much, you guys!!

Y’all are the best.

[WillowMobileSys]

@Steve @Suvrutt_Gurjar @Sherin_Premkumar

Steve is correct that I did not consider that Display Name is Text versus your LongText column. As Steve mentions, any newlines that create spacing would be removed when assigned to the Display Name.

I just tested with a 3000 character text string and the “tooltip” handles it BUT not very well. The tooltip retains a maximum width so with very long text it will wrap off the screen. See image below.

But if the text you are saving is always under 1500 characters and you don’t need to worry about newlines, then Maybe the “tooltip” could work.

Regardless, it would be nice to see @Suvrutt_Gurjar 's solution. Because I’m not seeing how he accomplished it!!! (Hint hint)

[Suvrutt_Gurjar]

Hi @WillowMobileSys ,

Thank you for sharing your tests and background.

@WillowMobileSys

Regardless, it would be nice to see @Suvrutt_Gurjar 's solution. Because I’m not seeing how he accomplished it!!! (Hint hint)

Hi @Sherin_Premkumar and @WillowMobileSys ,

The main point is I used the “Confirmation Message” field of the action to display the long text column.

The implementation details are as follows:

Please create an inline action on the table with settings as follows. I have highlighted the main settings so as not to miss those. Please ensure the column ( I used [_rowNumber] ) that you attach the inline action to is included in the table view.

The group action should be without any constituent actions in the “Actions” settings as highlighted below.

Please ensure the display name is set to a blank as shown below:

Please add your long text notes column name in the “Confirmation Message” section.

You will also need the following changes in the localization panel. Need to add an expression for the “No” text as follows:

For the “No” text in localization, please have an expression something like

For “Confirm” text, need to add an expression as follows

For the “Confirm” text in localization, please have an expression something like

Finally, as already mentioned, this setup will need more testing for edge cases. The table view with this implementation cannot have any other action needing confirmation message because we have altered the confirmation message related “NO” and “Confirm” text localizations for this specific view.

Edit: I also confirmed that if the notes cell value has line breaks, then those are retained in the action’s confirmation message window.

[Suvrutt_Gurjar]

@Sherin_Premkumar ,

Yet another simpler option is to use input action on the notes column. This is a clean option. My preference would be for this input action based solution. If necessary, we can prevent the user from making edits in the table view using a suitable view specific valid_if expression on the [Notes] column.

The input action settings are as follows:

The expression for the [Notes] column in the above screenshot is as follows

The inputs can be configured as follows. Please ensure to configure type as Text instead of long text and default value as LIST([Notes]). Or else the notes will be truncated in the action display.

The valid if of the notes column is as follows. It prevents edits in the table view.

The valid if error message is as follows

Please see the valid_if error message showing up wherein the valid_if expression prevents edits in the table view in the following screenshot.

[WillowMobileSys]

@Suvrutt_Gurjar

Both of these are very nice and productive workarounds!!

[Jose_Arteaga]

Good morning all!

Once again, thank you so much for sharing!

If a solution provided resolves the original issue for you, please take a moment to mark it as the accepted solution. By doing this, we are helping other creators facing the same challenge to find the answers they need.

Also, I’m thinking these can be added to the Tips & Tricks subcategory.

Have a wonderful day ahead!

[Sherin_Premkumar]

Thank you very much, but tbh I do not like to change the confirmation Yes/No values to Back as I am using confirmation Yes/No to delete a record.

[Sherin_Premkumar]

Thank you, but would it be possible to see the entire value while just hovering? It is creating 2 extra clicks . instead of these 2 clicks, I can use the detailed view

[Suvrutt_Gurjar]

There is another workaround option I have suggested with the input action.

Of course it will not be as seamless as a hover.

[Sherin_Premkumar]

Perfect, I like the workaround using Input.

Thank you very much : )

[Suvrutt_Gurjar]

You are welcome. In that case you may want to mark that workaround as a solution.

It will be useful to any future reader of the post thread.