Many of you have asked the question, “How do I make a table visible or different for multiple users?” The answer is that you cannot change the table view itself, but you can create your own table view. If you create a form view and create a record, then you can block it so that no one else can create another record.

In the next step, you will need to use both the view element and the select statement to select the desired table. You can specify that a view will show for a specific user or user group, then you can create a different view for another user or user group. You can also create some fields (text, number, date, drop down) to make the table searchable for the user. You can create a drop-down field to select and show a different view that has different columns as well, depending upon what the user would like to see. You can hide/show them based on the selection.

Also, if you bind these search fields to the browser then it would not affect another user’s screen. So, it doesn’t have to be the default table view in Ninox, you can just build your own!