How appsheet determines the view type of a related column?

[_Excelrati]

Hi
I have a table of customers and a measurement table containing several measurements of their body.
The tables are related using a Customer ID column.
So the Customers table has a “Related Measurements” column showing with the formula: REF_ROWS(“Measurements”, “Customer ID”).

I have created several ref views from the measurements table that I planned to use in separate views/dashboards.
One view is of table type and 4 others are chart type.

I want the Customer_Detail view to pick the table view when showing related measurements. But it’s picking one of the charts instead…
Can you please explain how Appsheet determines the view type to be chosen if there are several ref ones?
I even tried going to the chart one that was chosen by Appsheet and changed it to be table type. What happened is that another one of the remaining 3 charts was chosen!

Is Appsheet giving priority to ref chart view over ref table views?

I hope it was clear

Thanks in advance

[Steve]

It’s been awhile since I looked into this myself. As I recall, it has to do with the order you added your ref views: likely the most recently added ref view is the one chosen. To “promote” an older view to newer status, copy the older one.

[_Excelrati]

Thank you Steve for your reply.
Unfortunately, it doesn’t seem to work.
After some testing, my conclusion is that it seems it will always take the latest CHART over any TABLE view…
I actually went and deleted all charts and re-created them. didn’t help…
The latest view was a chart, so I even went and changed it to be of table type. The result? It took the chart that was created just before that one…
Is this expected behavior or a bug?

Thank you

[Steve]

I suspect the behavior is “undefined”, meaning there is no “expected” or “correct” behavior. I’ll look into it more, though.

[Steve]

So I think the question of how the app chooses a view is probably academic; the solution to your problem is likely the use of a different slice for each ref view.

[Mike_A]

That’s seems to be the only way I have solved this… but it’s not really academic because it seems illogical and inefficient. I wish I understood the Appsheet design assumptions so it made sense how to approach app layout (less trial and error)…

[pravse]

Here’s how the choice is currently made:

• Ref views get higher priority than non-ref views
• Explicitly created ref views get higher priority than system-generated views
• If all else is equal, we choose gallery > chart > map > deck > table > card

Now that last part is questionable — we wanted to select more specialized presentations ahead of more generalized presentations.

We could have required that it be explicitly specified or at least go with a default that can be explicitly overridden. Still might be a reasonable thing to do. Adding @morgan FYI

[Mike_A]

@praveen - Thanks for sharing the logic! Love the idea of going with a default, but allowing us to explicitly override. Best of both worlds?

praveen:

We could have required that it be explicitly specified or at least go with a default that can be explicitly overridden. Still might be a reasonable thing to do. Adding @morgan FYI

[Fabian_Weller]

@praveen Any update on this?

[EugeneB]

+1 hope that it could allow us to override the default, as we are using reference table, we want to display the related ref table but when create a ref view chart for the dashboard. it display the ref chart view instead of the ref view table.

here it is how it look like, which not making sense to the the user

but we hope it could display in such.

or is there any workaround we could adopt currently?

[Steve]

How to change the inline view for reference table Questions

You’ll need to create a slice on the table, reconfigure the column containing the list of Ref values to refer to the slice rather than the table, then attach a desired inline view to the slice.

[Michael2]

Doesn’t happen too often but when it does, this drives me crazy.

AppSheet creates a system generated deck view for map points but does not expose this deck view as it does with other system generated view. Defining a deck view (ref) will override defined table (ref) views.

Madness I tel you…

@praveen @morgan

[Fabian_Weller]

I know how you feel
Please try to order the table view and the deck view to
first: table
second: deck
For example: If you have “My_View_Table” and “My_View_Deck” the deck will appear first and will “override” the table view. Just rename it like “My_View_Table” and “My_View_ZDeck” and you will be happy

[Fabian_Weller]

The workaround I described above doesn’t seem to work anymore. We seem to have no control over the Inline Views.
In a Gallery View, even when we set Show if to FALSE, it will be used as the Inline View.
The only workaround seems to be:

Allow to select which inline views to be used in a detail view Feature Requests

If you need a different inline view, you can: create a slice of the data create a table view of that slice create a new VC in the parent table with the appropriate ref_row() expression to reference the slice (see the auto-created one for an example) edit the detail view of the parent record to show the new VC instead of the old one.

[Yossio]

Yes I figured that out, but I think it is aukward. I think I rather just say in the detailed view which related view I want.

[alfonso123]

any updates on this topic?

[MissElle]

same problem. Waiting on some updates too. This is messing up what I need for my system. lol I hope there is a solution 

[Abnersi]

same here 😞

[ktsmediaprod]

Did they ever sort this out? I just ran into the same problem, my in-line TABLE view was replaced by a CHART view i made for another part of the program...

[Steve]

There's nothing to sort out, it's working as intended and the workaround is still what it was when I replied earlier in this thread: create a slice on the table and attach your chart view to the slice rather than the table itself.