This is a simple series of steps to create virtual โshowโ -type columns. Thereโs some posts on this from awhile back, e.g. this one here:
But I didnโt see any explicit instructions on how to use this very handy column type!
a column of type โShowโ allows you to insert static, constant help text into your views.
Hereโs a reference app:
Itโs a bit quirky to create these virtual columns, You have to trick appsheet into letting you choose the type โShowโ. Here are the steps:
Create a virtual column with โโ as itโs formula:
Now change it from โunknownโ to โShowโ - in the screen below, our column โShow Textโ is still set to โunknownโ:
Now that you have changed it from โunknownโ to โShowโ click the pencil icon:
Change the category to โtextโ (in this example) and put some text into the content field.
Steps for Optional URL Type: you can create nifty looking hyperlinks by choosing the show category type of โURLโ and then using the Hyperlink() function, e.g:
And finally, on your view, SHOW types will not automatically show up like other fields will, so you have to explicitly and manually list them in column lists:
Now you can see them on your views! Hereโs a detail view:
And hereโs a deck view:
Happy virtual showing!!
Perfect. For some reasons I havenโt been able to have show columns work in virtual columns, always have blank random columns in my spreadsheet. Ill need to try this out sometime again.
OMG
This is exactly the steps I take to do thisโฆ Iโve never even thought about it before. I just do itโฆ
Awesome article
I think the Pro for Virtual Columns is also that you can edit the App without having conflicts with your users. I mean: If you add / delete a column in your spreadsheet, you will get in trouble with your users when they still have an older version of the App. I would assume that by using VCs you will be save
Is there a limit to the amount of text? Iโm using a Detail view and my text is getting cutoff. Only showing about 4 lines. Is there a better way to show a bit more text? Also, not able to scroll down to see all the text.
Basically:
Dashboard:
Detail View (2 columns: Image and Show)
Deck View
Deck View
The Show column in the Detail view is set to Text.
I donโt think so? See attached animation. Looks like you can have plenty of textโฆ I used the same app as above to testโฆ
Ha! You know what it was? I didnโt put the text in double quotes! When I added the quotes around the entire paragraph of text it displayed it all!
Anyone figured out a way to format this text specifically? Like bold a word or two, underline, etc?
Not possible (yet), but Iโve made a similar feature request:
There is also an iframe view-type in development. Hopefully it will allow using the same GDoc templates and enable viewing a row in the iframe.
Circling back on this to see if there have been any developments. Am using a SHOW Type, URL VC and just wanting to center the text so it matches the other columns.
Another question popped to mindโฆ anyway to use an icon or image as a hyperlink? I havenโt searched for a solution yet, so Iโll go and do that now.
Something like this?
You can use an Action โExternal: go to a websiteโ and attach it to an image column.
But this would appear under the image.
You cannot attach this Action to a Show column. I mean: You can, but it wonโt show up.
Thanks for this, @TyAlevizos ! Very clear. One point that I was unaware of until recently is that the Show-column type is not only useful to achieve a desired look โ itโs also useful in improving the efficiency and performance of an app. Hereโs a description of the column type from @praveen :
Until I read this, I didnโt realize that, as virtual columns, โShow typeโ columns are in a special โlightโ category. So, Praveenโs comment really opened my eyes.
I am currently working on an app with 8,000 records and need to have lines of text on to which I can โhangโ inline actions, as follows:
I learned from Praveen that whether I make the lines of text on to which I hand my actions real or virtual, doesnโt make much difference โ Iโll still make the device hold 8,000 copies of the same text in its memory. These lines of text cannot be show columns because show columns cannot take actions (at least as the platform is currently configured). So, Iโm kind of stuck. In regard to the headings (โCEFR-J data,โ โEnglish-Japanese dictionaries,โ etc.), however, these can be made into show columns. Judging from what Praveen has told me, the switch to show columns should lighten up my app.
I found this tip of yours today because I was thinking โHow is that Iโve been using AppSheet for five years and I am only now realizing that show columns are fundamentally a different (and more efficient) type of virtual column?โ I looked at the documentation but could find anything. The following article on column types doesnโt even bother to go through the various types and explain what they are for. The show type isnโt even mentioned:
The following article explains how to use the show type for videos but no mention is made of what makes โshowโ a special type of virtual column from a performance standpoint:
@MultiTech_Visions has made a very nice video explaining how to use this column type but the focus is on โhow toโ and it doesnโt seem to mention the efficiency dimension.
This really should be spelled out in the โColumn Types and Propertiesโ article.
I would give this community an A+ (Iโve learned so much from many generous people) but Iโd give documentation on AppSheet about a B or maybe even lower. If it had not been for the community I would have given up long ago. Even with A+ documentation, the community will continue to be necessary but it would seem to me that a lot could be gained in efficiency if more energy could be put into improving the documentation โ itโs better to explain something properly once in the documentation instead of trying to explain it individually to thousands of confused creators.
Thanks! In regard to my โB or lowerโ rating for AppSheetโs documentation, I felt a bit conflicted as I wrote that because, despite my concerns, I also had @Steve 's outstanding articles in mind. When AppSheetโs documentation is good (as with Steveโs articles) it is very good but . . . well . . . Iโm reminded of a little poem:
There was a little girl,
Who had a little curl,
Right in the middle of her forehead.
When she was good,
She was very good indeed,
But when she was bad she was horrid.
โHorridโ may be a bit too extreme but you get the idea.
In this article, SHOW type column is explained. (under โShow Typesโ) But itโs very hard to find.
And it contains a false statement:
โShow type columns are only permitted in Form views.โ
Maybe this was back then. But now we can enable them under UX > Options > Detail View
Thanks @Fabian ! Yes, I couldnโt find it. Thank you for showing it to me. I think that there should be a link to this on the following page:
Also, I think it would be nice if, in addition to fixing the error you pointed out, some explanation could be added about how show columns do not harm performance in the way that other virtual columns do.
@TyAlevizos Is there a performance/sync time difference between using physical Show columns vs virtual Show columns? Especially if the Show Content is grabbing information from each row?
The following comment from @Praveen indicated to me that physical columns may have more performance implications for apps than Show columns if you table is very large:
I've been looking for a way to add virtual show type columns for text and this is a great solution! Not sure why, but Appsheet is inserting the equals symbol in front of my text (show text should read "loaner vehicle", but in the app it's coming up as "=loaner vehicle". Any suggestions on why the equals symbol is there and how to get rid of it?
ICYMI, ensure that you don't include the = sign in your expression. In expression entry fields like the following, that's just an identifying icon--i.e., not something you type to begin the expression.
If this isn't your issue, I suggest share screenshots to illustrate your column configuration and the app behavior.
I'm having difficulty with incorporating TEXT([PERCENT]) and TEXT([NUMBER]) in the Content column of a SHOW field. The 'Test' feature in the Expression Assistant returns the correct string, but the string does not display in the associated form. TEXT([DATE]) seems to works, though. Can anyone else confirm this bug or make a suggestion?