Selecting specific columns to be viewed from a list


I developing an application that is to be accessed by customers. As we are an automotive company, the purpose of this application is to enable the customer to access their vehicle repair history.

The picture below, shows the Related Repairs to the VIN (Vehicle ID) of the Vehicle, the expression used is: REF_ROWS(“Jobs”, “ID (VIN)”)

Related Repairs

The thing is, that I want to show some of these columns and not all of them. For example, I don’t want to show neither the Vehicle Model nor the Plate No.

What other expression shall I use?

Thank you!

Hi @o.darwazeh
Have you tried changing the column order in the view? The view will be …inline.

1 Like

I suggest creating a Slice of the Jobs view named something like Jobs-CustomerView. Select the Custom option in Slice Columns and pick the columns you want (eg, select all except Vehicle Model and Plate No.). Once you have the slice saved update your formula to reference the rows in the slice using something like REF_ROWS(“Jobs-CustomerView”, “ID (VIN)”).

Doing that won’t allow me to show the other columns in the more detailed view when clicking on one of the repairs, as below:


I have tried that, this forces me to add ID (VIN) in the view - which is the key -, but what was surprising is that even after trying that, nothing changed!

Used this formula: REF_ROWS(“RelatedRepairs”, “ID (VIN)”)