Solved: Show columns based on a certain fields - Page 2

marsbar · 11-11-2022 09:58 AM

Hi All

Im looking at a way to have certain data hidden and only visible when the correct password is added.

For this I'm using a table view "Data" with lots of columns and I also have a Form "PW" with 2 columns for [Name] and [Password]. I was hoping by adding a pre set name and password that the data would show.

I have tried using the Show_If filter on the "Data" table for the columns I want to hide: AND(PW[Name]=USER1),(PW[Password]=1234) ... then adding these in the form, but that didn't work.

Ive also tried to make a slice of the "Data" table that hides the whole table with the same formula... again no joy!

I have created a dashboard view with both the "PW" form and the "Data" table so I could test this and it isn't affecting the table view. Sorry if this sounds like Im stupid... but could anyone help please - tearing my hair out!!

Thanks In Advance

WillowMobileSys

The examples in the expression I gave were all for opening a Form for a NEW row. I did mention...

@WillowMobileSys wrote:

NOTE: there are other navigation functions you can use check the article for those other functions.

You can navigate to basically any view and showing any data you wish.

LINKTOFORM()

At the bottom of the above article are all of the other navigation functions available. Check them out.

View solution in original post