Detail Views: Space-Saving Trick to Display Columns Horizontally

Detail Views show all the columns stacked vertically, which leaves a lot of wasted screen space.
02%20AM

Make certain columns display in a horizontal list by creating a slice, and a virtual column:

  1. Add slice, select the columns you want, also add the Key column.

  2. Add a Virtual Column: REF_ROWS(“SliceName”,“KeyColumnName”)
    this relates every record back to itself, with the child being the new slice with limited columns

  3. Replace the individual columns on the detail view with the new virtual column.
    11%20AM 02%20AM

This also creates horizontal dividers in the Detail View and can be used to separate sections.

18 Likes

That’s a very nice idea. Thank you very much @GreenFlux.

2 Likes

You’re welcome! You can also hide the VIEW button, since it doesn’t really apply with this approach.

In the UX/Localize section, just rename VIEW to “” when CONTEXT(“View”)=‘View Name’

However, the (1) remains.

3 Likes

Cool, this looks like something that could help me, TYTYTY!!!
I have a Meetings App to schedule Meetings, each meeting will have 15 Roles for Members. I need to compactly display a simple/succinct “Next 3 Meetings” view that shows the next 3 meetings Date & their Roles. See Example below. I am building a Google Doc Template to Workflow email this out to Members, but I would like to also be able to display this inside the App, similar to how my Template image below is laid out. I don’t need the table squares to appear like in my Template image, just the data. I am using a table inside my Template Doc to keep everything lined up nice-nice. I think that you are doing something like this with your brilliant Trick here. The display advantage that I want is that I can only display the Role Name once, down the left hand side, and not for every single Role displayed. This is the only way that I can keep all Roles on one Page in my Template email. I think this view in my App will mainly be viewed on a Desktop, but conserving space on Device screen is just as important as in the Template Doc. Nobody wants a 3 page Report when all data could easily appear in one Page if Smartly formatted.
**And, slightly related, I have not yet figured out how to pull the future Meeting Date 2 & 3 & future Role data into my Workflow template, or into a View inside the App. It’s gotta be possible, if you know how to do that, I need it, please & TYTY!!
04%20PM

Yes. You just need to use <<Start: >> and <<End>>
e.g.:
<<Start: Filter("TableName", condition-that-will-get-you-the-next-3-meetings)>>
<<Greeter>> <<Atendance taker>> <<...other stuff...>>
<<End>>

If you get the filter condition correct, it will iterate over all the records that fulfill that condition and do whatever you put between the Start and End tags for each of those records.

1 Like

OK great! TYTY! I’ve already used this <<Start: <> in an Order/Order Detail App, so I should be able to translate to this. Thanks bro!

This is super slick, thank you!

I’ve got the slice and VC setup as you’ve described and it appears to be working! That being said, for some reason only the values are showing on my Detail page and not the column headers (in your example, ‘Status’ | ‘Deadline’ | ‘Total’). In my image below, the values are represented with ‘1’, ‘2’, ‘3’, that I am hoping I can get to show with qualifying column names above them. Any thoughts?

2 Likes

UX>Options>Table View> Show column headers

2 Likes

I’m clearly new here. :man_shrugging:

Thank you my friend. That (obviously) worked like a charm!

Hola buenas tardes, soy nuevo en la comunidad pero no veo como puedo generar una consulta general sobre unos temas que tengo dudas, lamentablemente no hay mucha información de video tutoriales en español y esto hace que no pueda avanzar, le agradecería si me indica como se hace para hacer la consulta en la comunidad o si tiene información donde hay vídeos en español. Gracias.

Is there anyway to get rid of the (1)?

This works also perfect with Deck View or other views :slight_smile:
Thanks again to @GreenFlux

4 Likes

Cards also display nicely horizontally, except the headers get centered for some reason, not that I mind.

4 Likes

I haven’t tried using this with deck or card view. Thanks for the tip, @Fabian and @Bahbus!

I just realized it would be useful for adding a ‘header section’ to the Gallery or Deck View, which I have previously used Dashboards to achieve. But Keeping everything in the same view has its advantages when it comes to CONTEXT() and other Dashboard limitations.

2 Likes

The nice things about Gallery vs Card for inlines (unless it’s been changed recently) is that Gallery inlines display a single line with a scrollbar if it exceeds the view. Cards move downward as they exceed the horizontal space. I also like inline Decks occasionally.

3 Likes

You’re welcome! You can also hide the VIEW button, since it doesn’t really apply with this approach.

In the UX/Localize section, just rename VIEW to “” when CONTEXT(“View”)=‘View Name’

However, the (1) remains.

AppSheet moved where the (1) is shown, so this is less of a problem now. Unfortunately there is still a small clickable area that can’t be removed - but at least its less obvious.

2 Likes

“” or "" is not working to me. It will be ignored, and “View” is shown.
view

" " (with whitespace) is working. But as @Jonathon said, you will still have a clickable area- I marked it gray. And this happens no matter what kind of whitespace you are using. I tried it with hair space , thin space , six-per-em space.
Space

The best result I got from using this expression. It’s just a NewLine with no whitespace.
"
"
image
Absatz

The clickable area gets very small.

4 Likes

Another use case: