Selecting specific columns to be viewed from a list

[o_darwazeh]

Hello!

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)”)

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!

[Lynn]

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

[o_darwazeh]

AppTech:

e Columns and pick the columns you want (eg, select all except Vehicle Model and Plate No.

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:

[AppTech]

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)”).

[o_darwazeh]

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)”)