Help with show_if #view expression

[Linda_Marita_La]

Hi!

Need help with a deep link expression.
I have a column i want only to show in a slice. The slice is set to show this column. But it doesnt show. In the table the slice is based on i have had this column hidden. But i want it to show in the slice so i have to use show_if in the main table?

The slice is named: Kinnarps Workflow History, the column is [Registrert av]

The suggested deep link expression is:

“#view=Kinnarps%20Workflow%20History”

That is not working.
I have also tried:

“#view=Kinnarps+Workflow+History”
“#view=Kinnarps Workflow History”
“#view=KinnarpsWorkflowHistory”
#view=“Kinnarps%20Workflow%20History”
and so on and so on…

Can anyone help?

[Lynn]

Hi @Linda_Marita_Lauritz
Maybe you could have two slices for your views and allow the column in the base table.

[Suvrutt_Gurjar]

It sounds that you wish to show a specific column in certain view ( based on slice) and not in other views that are based on table.

If so, is it possible that you can use CONTEXT(“View”) function in the Show_if setting of the column’s setting pane to show the column in certain views only?

Edit : corrected the word from slice to column in the highlighted part above

[Linda_Marita_La]

I’ll try

[Suvrutt_Gurjar]

Please refer following “tips and tricks” post just in case you have not.

Hiding Fields in Certain Views with CONTEXT() Tips & Tricks 💡

In order to keep my forms as streamlined as possible, I frequently want to automatically population and hide fields - for example, when I’m automatically collecting the users’ email (USEREMAIL()), the current date or time (NOW()), location (HERE()), dereferenced value ([USER].[PHONE]), etc. I hide these fields in order to help users focus just on the essential form fields. One simple method for controlling whether a field will display in a form or other view types is to use the CONTEXT expressi…

[Linda_Marita_La]

You understand me correctly. I only want to show this column in the slice, but not in any other views.

I couldnt get this to work either. Here is what it says (and that is what it’s saying in any variables i have tried:

Column Name ‘Registrert av’ in Schema ‘Kinnarps Workflow_Schema’ of Column Type ‘Text’ has an invalid show_if constraint ‘=CONTEXT("Kinnarps Workflow History”)’.

The column “Registrert av” is in english “Registered by” and captures USEREMAIL().

[Suvrutt_Gurjar]

Please try in the show if constraint of the column

CONTEXT(“View”)="Kinnarps Workflow History”

Where "Kinnarps Workflow History” is the name of the view where you wish to show the column “Registrert av”

[Linda_Marita_La]

It seems valid but still doesn’t show.
Can’t rap my head around this

[MultiTech]

There is a value in the field right?

If it’s empty, it won’t be shown in the details view.

[Linda_Marita_La]

It’s always a value in the field because it’s set up to catch USEREMAIL()
That’s the inital value and not affected by user

[Steve]

A slice is not a view. You need to create a view (in UX >> Views) that uses the slice, then have your deep link target that view.

I also suggest using the LINKTOVIEW() function rather than the suggested deep link expression.

help.appsheet.com

LINKTOVIEW()

Constructed deep link to view

[Linda_Marita_La]

Thank you for the tip! I will try this when i get the time for it The app is now deployed and launched to multiple users and they are satisfied with what they can ser for now