LinkedIn
Twitter
The following feature has been added to the Preview Program. Feel free to try out the feature and report issues or possible improvements in this thread.
AppSheet is expanding how text can be formatted. For data that is typed as LongText, app creators can now choose to render Markdown or HTML in Detail views.
Note: In all views other than Detail, the value will render as plain text.
How do app creators use the feature?
- Start with data that has HTML or Markdown inputs.
In this example, the Quote column contains HTML data and the Reviews column contains Markdown data.
- In the AppSheet editor, go to Data > Columns, expand the desired table, and set the Type field to
LongTextfor the columns that you want to render Markdown or HTML in Detail views.
- Click
to modify the row, and set the Formatting field to HTML or Markdown (depending on your column data).
- Save your application. You should see the rendered text within the Detail view of your app.
How do app users use this feature?
Users can input HTML or Markdown in the appropriate fields.
What are the supported views?
Currently rich-formatted text will only be rendered in Detail views - all other views will display plain text.
What are the supported data types?
The column type must be set to LongText with the format set to HTML or Markdown.
What are the supported HTML tags?
<a>, <b>, <strong>, <i>, <u>, <em>, <mark>, <small>, <del>, <ins>, <sub>, <sup>, <p>, <li>, <ol>, <ul>, <br>, <hr>, <blockquote>, <img>, <h1>,<h2>,<h3>,<h4>,<h5>,<h6>, <table>, <tbody>,<tr>,<td>, <th>
- Unsupported tags will be rendered as plain text.
- Allowed attributes:
for<a>:href,name, andtarget
for<img>:src - All other attributes will be removed (for example, inline styles such as
<p style="color:red;">A red paragraph.</p>will be removed and will not have any effect).
What are the supported Markdown elements?
Heading, bold, italic, blockquote, ordered list, unordered list, inline code, code block, horizontal rule, link and image.
Example: Using a virtual column
- Create a virtual column and set its column type to
LongTextand formatting to HTML. - Edit the App Formula to use the
CONCATENATEformula to combine HTML tags with column values. - Save and view your app.
The resulting app:
Please let us know your feedback in this thread!
โthis is a sample prog view ive generated with the text formatting, hope right align gets pushed out
Is there a future update to support word wrapping using rich text formats? Currently using markdown format doesn't support word wrapping text and forces the user to double-click to highlight the text and paste in a different editor to view the full contents of the field.
The redacted screenshot shows how the text acts as a run on line of text and cut off from view from the user. This is a "Details" view.
Hi there!
I found a bug I guess and wanted to share that here, hopefully someone from the team will see and solve this one day. The thing is about markdown code blocks. Once they are used in the long text column, the text that is included in them is truncated and the text after the block also, take a look at the attached screenshot. I think it shouldn't behave like that. I couldn't find a related comment so I decided to write my own. I am using markdown quite a lot and it is annoying sometimes so it would be sweet if it was fixed.
Thanks for your consideration!
