AppSheet View Customize Extension Update – Boost Your Efficiency

[JOHNN]

After two years, my extension has finally been updated — and it will help you work with AppSheet up to three times faster!
It’s completely free, and you can download it now from the Chrome Web Store

Here are the key features:

Resize Columns in the Data Section

AppSheet displays all columns by default, which can make setup difficult — you often have to scroll left or right to see other columns.
To make things easier, I’ve added the ability to lock and resize columns to fit your workflow perfectly.

Update 2025:
You can now hide Display Name, Description, Search, or Scan fields. This makes AppSheet look great even on smaller screens like MacBooks.

Remove Extra Spaces from Column Names

When working with AppSheet, I often copy column names. However, AppSheet sometimes adds an invisible space at the end — meaning when you double-click to copy, it becomes [column_name ] instead of [column_name].

This small issue can waste a lot of time, so I added an automatic space remover to clean up copied names instantly.

Hide Password Fields

AppSheet doesn’t have a built-in password masking feature — so when users type passwords, the input isn’t hidden.
Now, if you name a column “Password” and enable Hide Password, the input field will automatically turn into a masked field (******).

Embed Looker Studio in AppSheet

AppSheet dashboards are great, but it’s even better for data collection than for visualization. For that, Google’s Looker Studio is the perfect partner.

Here’s how to embed Looker Studio into AppSheet:

1. In Looker Studio, open your dashboard → go to File Settings → enable Embed Mode → copy the file ID.

2. In AppSheet, create a new view named _Looker and set it to Dashboard.
   Then set Display Name to:
   IF(CONTEXT(view)="_Looker",'***',"Dashboard")

   

   (replace *** with your Looker Studio Dashboard ID).

3. Go back to the extension and enable Show Looker Studio.

That’s it! You can now view your Looker dashboard right inside AppSheet.

Thousand Separator for Number Inputs

When entering large numbers, AppSheet doesn’t show thousand separators — for example, it displays 100000 instead of 100,000.
This extension adds automatic thousand separators (currently in BETA).

Why BETA?
When processing input types, I discovered that Google’s default input switches to tel for large numbers, which doesn’t support millions smoothly. So the behavior for very large numbers may still be imperfect.

AI-Powered Display Name Generator

This is my favorite feature — mainly because I’m lazy.
I always name columns using MySQL-style syntax (no spaces, no accents), but for users, I want readable names in Vietnamese or English with spaces and proper accents.

Imagine having 30 tables with 20 columns each — renaming all Display Names manually feels like winter in Hanoi: it lasts forever.

So I built an AI tool to handle it for you.

How to use it:

1. Go to Google AI Studio and get your API key. https://aistudio.google.com/app/api-keys

2. Paste the key into the extension.

3. Choose the language and target table — then let the magic happen.

Your column Display Names will be generated automatically — fast and accurate.

My philosophy: “If you can do it faster, do it faster — extra time is for your wife, not for somebody else’s wife! ).”

That’s all for now — the full set of features in the latest version of AppSheet View Customize.
I truly hope this extension helps you work more efficiently and enjoy building with AppSheet even more. Hopefully, Google will officially bring these features to AppSheet soon. If not, in the meantime, you can use this utility I created. I hope it will be helpful for you.

If you’re new to AppSheet and would like to learn how to use it effectively, I’ve prepared a 98-page learning document that covers AppSheet from basic to advanced. You can access it here: https://discuss.google.dev/t/share-appsheet-learning-materials-from-basic-to-advanced-98-pages/. Hope you find it useful!

“Sorry admin, I wasn’t able to post in the Tips & Tricks topic as it is currently read-only, so I posted it in the AppSheet Q&A section instead. If possible, could you please help move this post back to the Tips & Tricks topic? Thank you so much! “

[Suvrutt_Gurjar]

Seems to be an interesting and useful chrome extension @JOHNN !

Except for point 3 ( Hide password fields) , all other features, especially Looker Studio embed, thousands separator and the AppSheet editor related features are interesting.

Hide Password fields may need more elaboration by you and critical review inputs by other AppSheet users because AppSheet does not inherently allow “password” entry in any of the apps. AppSheet delegates the user authentication to other providers such as Google , Microsoft etc.

@Jose_Arteaga : Request you to take a look at the post and help @JOHNN suitably to post it in Tips and Tricks section based on your review.

[Denzil_Snyman]

@Adam-google @Jose_Arteaga

Integrating looker into Appsheet has been a long time request, perhaps your team could speed up normal integration using your own iframe. Perhaps look at how external extensions got this working and take some tips

@JOHNN Your time into this extension is greatly appreciated… thank you for putting effort into these things… your a legend for getting Looker into Appsheet..

[AppliSuite]

@JOHNN

Wow, this Chrome extension is absolutely incredible! Thank you so much for creating and sharing such a powerful tool with the AppSheet community.

1 - Resize Columns in the Data Section:

This is exactly what every App Creator has been desperately wanting! The ability to lock the “Name” column while scrolling left and right through other columns would be ideal, but Google hasn’t implemented it yet. Your extension doesn’t provide scrolling, but the intelligent resizing functionality you’ve built is more than sufficient. This alone will dramatically boost development efficiency. Combined with the new Update feature that lets us hide Display Name, Description, Search, or Scan fields, this becomes even more powerful!

4 - Embed Looker Studio in AppSheet:

This is a fascinating feature! AppSheet’s chart views are quite limited, so I’ve been using Looker Studio for visualization instead. The idea of embedding Looker dashboards directly within AppSheet is brilliant. I’m sure many app users will embrace this functionality. Looking at your screenshots, it appears incredibly attractive and useful.

5 - Thousand Separator for Number Inputs:

This is a small but extremely thoughtful feature. Without thousand separators, it’s difficult to intuitively grasp the magnitude of numbers at a glance. Even though it’s in BETA, this addresses a real pain point.

6 - AI-Powered Display Name Generator:

Another brilliant idea! Many App Creators name their tables and columns in English. Thank you for including Japanese as a language option - that shows real consideration for the global community.

Your philosophy of “If you can do it faster, do it faster” really resonates with me. This extension will save countless hours for AppSheet developers worldwide.

Also, thank you for sharing your 98-page learning document. That’s an incredible resource for the community!

Keep up the amazing work!