Hi Guys,
Would you be able to help me with expression to hide column in referenced view.
I have 2 views. First where all records about the work go and Second where all records about work sites go. In the last one there is reference to the first table about work records and I want to hide one column here, because itโs just duplicates the name of a work site.
Many thanks
Solved! Go to Solution.
You have to build a completely separate UX>View then, for each case.
Since we have no info to work with maybe look at. ISNOTBLANK, SHOWIF, Set column order. Also this should be a Question , not ztips and Tricks.
Iโve looked. Still canโt work it out. Iโll try to put it together another way.
Iโve got view โWorkโ with column โSite nameโ. In another view โSitesโ thereโs related reference to table/view โWorkโ. So when I click on site name in view โSitesโ I can see related records from โWorkโ table
So I basically want column โSitesโ to be seen in view โWorkโ but to be hidden in view โSitesโ.
Thank you.
Hi @Apper Check out theses.
Hi @Lynn
Thanks for helping me out!
Iโve tried this expression IN(CONTEXT(โViewโ), LIST(โWorkโ)) , although itโs still showing me this column in view โWorkโ fully, in another view where I donโt want this column to bee seen, app is showing me it but with blank values. Basically in column โLoad number/nameโ it repeats value โFarmโ which Iโve already got up the top of the view.
Is there is a way to hide this column in another view completely?
Thank you!
Hi @Apper
I dont think you need the IN LIST . Try it without .
If I just use CONTEXT(โViewโ), the app is saying:
โColumn Name โLoad number/nameโ in Schema โWork_Schemaโ of Column Type โTextโ has an invalid show_if constraint โ=CONTEXT(โViewโ)โ.โ
You need to name your view
Now it is saying:
"Column Name โLoad number/nameโ in Schema โWork_Schemaโ of Column Type โTextโ has an invalid show_if constraint โ=CONTEXT(โWorkโ)โ.
Sorry Iโm very fresh in this and maybe I donโt understand it completly.
What expression youโd use to make it work?
Thanks
CONTEXT(โViewโ)=โWorkโ
Sorry for all the edits I am on my phone.
Sorry but itโs still displaying that column with blank rows.
Remove the column from the View:
Hi @Marc_Dillon , thanks for your suggestion
However I canโt remove this column from the view as I need it there to be seen. I just donโt want it to be seen in another view which is referenced to the first table.
You have to build a completely separate UX>View then, for each case.
Thanks a lot for your tip!
I thought I can do you with expression but this will do too!
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |