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!!