In this video, I show three different ways to hide fields in your Google AppSheet app. This is useful for improving the user experience by ensuring only the most relevant information is displayed to your app’s users. Here’s what I cover:
Hiding Fields Completely Across the App
Sometimes, a field is only used for backend processes and doesn’t need to be visible anywhere in your app. For instance, in the example notes app I used, the Note ID column is only used internally by AppSheet for tracking and offers no value to the end-user. By unchecking the “Show” option in the data menu, this field can be hidden throughout the entire app. This ensures it won’t appear in any views or forms.
Hiding Fields in Specific Views
There are scenarios where you might want certain fields to appear only in specific views. For instance, in the notes app, I hide Public Comments and Private Comments from the list view while keeping them available in the detailed view of a note. Using the Column Order settings in the view configuration, you can control which fields are shown and in what order, allowing for cleaner and more focused views tailored to user needs.
Hide Fields Conditionally
This hides fields dynamically based on specific conditions. In the example, I ensured that Private Comments were only visible to the note creator. By using AppSheet’s expression editor and creating a condition like [Creator] = USEREMAIL(), I made sure that only the person who created the note could see those private comments. This conditional logic ensures sensitive information is displayed only when appropriate.
Want More AppSheet Videos?
If you found this video helpful, I’d love it if you could subscribe to my YouTube channel and turn on notifications. That way, you’ll be the first to know when I post more tutorials about AppSheet and other no-code / low-code tools.