Show different columns for inline reference views from same table

ux
(Devina Maxwell) #1

I need some advice with inline views.
Is there any way I can make these 2 different inline views that come from the same parent table show different columns

Thanks in Advance, Devina!

(Aleksi Alkio) #2

Yes you can do that. Click that View(1) from the emulator and then open that view from the lower left corner (button “View”). You can set the order with an option “Column order”. You probably don’t have any chosen so it’s doing that automatically. Just add columns one by one and it will do that job.

(Devina Maxwell) #3

Thats a great tip Thanks , now i won’t get mixed up with my views. However my problem remains the same , you see when i change that view the above inline table changes as well I cannot get them to show different columns. i hope im explaining this clearly both lists use the same view.

(Aleksi Alkio) #4

If it’s the same inline view, then you should create a slice and then use that as a source for your virtual list column. When you do that, you are able to create a 2nd inline view (ref).

(Devina Maxwell) #5

Ahh i got halfway there just didn’t do the virtual column list , i’ll try thanks your always so helpful
Devina

(Aleksi Alkio) #6

You’re welcome

(Devina Maxwell) #7

I’m not doing so well I think I’m just not getting it. So both these inline REF lists have the same Reference table that seems to be causing me grief. cannot seem to make anything work. Thanks anyway Devina

#8

@Aleksi - I am also struggling with a similar problem. When I try to use a slice as the REF_ROWS source, and define a view that includes multiple REF_ROWS columns (eg: 2 inline views), I don’t understand how to specify which view each inline table should use. Seems to be auto assigned and I am not sure how to change that. In my case, the second inline view uses a Chart view that already exists, instead of one of the many table views I defined. Any advice appreciated.

see prior post: https://community.appsheet.com/t/filtering-a-reverse-reference-to-display-only-related-records-with-open-status/8767/8?u=mike
2019-03-22_14-40-27

(Steve Coile) #9

The view used is determined by the ReferencedTable property. If the column definition doesn’t display that property, you’ll have to create a new column with an App formula that uses the slice from the get-go (rather than adapting an existing column’s App formula)

1 Like
#10

@Steve
Hmm… don’t see that property. Will check again. My second REF_ROWS virtual column was anew one I created from scratch… but copied the original REF_ROWS formula from the first column so that may not be best way. Will take another look at why I don’t see that property…

#11

Well… In case his helps someone else. I solved this in a very strange way. It worked, but I am still not clear how the inline views are chosen. I was not able to find where to specify that…

Steps to fix:

  1. Created a new SLICE for the records I wanted in the inline view.
  2. Created a new View for that new slice to display the inline table as I wanted it.
  3. Modified the Column REF_ROWS formula to point to this new slice. … and the table view works!
    4. Modified the new View I created in #2 to point to the original Slice I wanted to use.
    5. Modified the REF_ROWS formula to use the original Slice I wanted to use as the source.
    6. Deleted the temporary slice and it’s associated views.

Weird and confusing way to get there, but it worked. And it did allow me to have two inline views displayed - one pointing to a table and the other to a slice. In my final solution I only wanted to point to the slice, but the original poster @Devina_Maxwell to know how I solved it.

Again… I never could find where to change the " ReferencedTable property" that @Steve referred to … wish I could located that.

UPDATE: I found I had not actually completed 5, and when I did, the wrong view was used again. So… my fix is to create another Slice and View, and use that in the REF_ROWS column. Very odd but I cannot seem to use the original slice and get a table inline view. So, I have one inline view coming from a table, a second slice only used for other views, and a third slice now used just to fix the REF_ROWS inline view. So works… but still confused :slight_smile:

1 Like
Filtering a reverse reference to display only related records with "open" status