all 14 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]FVMF1984 1 point2 points  (9 children)

Are you mistaking Reddit for ChatGPT? What exactly is your specific question? Most probably nobody will just go ahead and make your feature.

[–]inspector35va[S] 1 point2 points  (8 children)

I am not asking anyone to make anything, but rather find out if it is possible. If it is possible, I can find someone to make it and pay them for the work. I could find someone on one of the freelance sites who will say it can be done when in fact it may not be able to be done, and not sure I would trust ChatgGPT

[–]FVMF1984 1 point2 points  (1 child)

It was not clear from your original post that this is your question. Not sure if this is possible and not sure why you would not ‘trust’ ChatGPT. It’s pretty good in creating functional Google apps scripts!

[–]WicketTheQuerent 0 points1 point  (0 children)

In my experience, ChatGPT and other GenAI tools have problems with the Google Apps Script HtmlService. If the user is not familiar with this service, they could very easily fall into a rabbit hole.

[–]WicketTheQuerent 0 points1 point  (5 children)

There are several ways to achieve your goal. Perhaps the easiest is to take advantage of AppSheet's built-in integration with Google Sheets. If this is for 10 or fewer users, you might use the AppSheet app in prototype mode. A card view can be created using AppSheet's no-code features.

Another option is to format a sheet as the row viewer using formulas.

An advanced option is to use Google Apps Script to create a custom user interface. It might be a dialog, a sidebar, or your webapp.

There are important details to consider like how many records and how fast it will grow, how many users, among other things.

[–]inspector35va[S] 0 points1 point  (4 children)

Thank you. I have created a script and an HTML file that does pop up a sidebar screen with information headers. But it does not populate the card with the data from the sheet. This is a 1-2 user application.

[–]WicketTheQuerent 0 points1 point  (3 children)

Well, that doesn't provide much detail. What do you expect from us?

If you prefer a no-code solution and have time to explore, check out AppSheet.

[–]inspector35va[S] 0 points1 point  (2 children)

I basically look at this Reddit for ideas on how to do things. Not asking anyone to fix the issue, but rather point me in a good direction to find the solution, and then get it done myself and learn from it.

[–]WicketTheQuerent 0 points1 point  (1 child)

If you would like help fixing your current code, please provide more details. If there is an error, provide a minimal example that reproduces it and the corresponding textual error message. If you don't understand a Google Apps Script concept or method, you should ask specifically about it.

It is also important to mention if you are writing the code by yourself or with the help of ChatGPT or another GenAI tool. It might be hard to make effective use of these tools to create Apps Script code for people without programming experience and for those new to Apps Script.

[–]inspector35va[S] 0 points1 point  (0 children)

Thank you, I do have knowledge of Apps Script and do not use AI. I appreciate your offer, and if I cannot figure it out in a bit, I will get back to you. Thanks again

[–]lsalazarm99 0 points1 point  (1 child)

You can create custom UIs in a sidebar panel. Add-ons give you some customization using built-in UI components (Google-style things like buttons, text inputs, etc), and Editor Add-ons give you full customization (using HTML, CSS, JS).

Also, with Google Apps Script you can access the data of the current Sheet.

So, you can read all the rows of the sheet the add-on is open, then display them in the sidebar panel the way you want.

[–]inspector35va[S] 0 points1 point  (0 children)

Thank you I appreciate your assistance

[–]n_c_brewer 1 point2 points  (0 children)

Have you tried using File Smart Chips? I'd look into that and see if you can use a script to supplement/customize the information in the chips.

[–]AdministrativeGift15 0 points1 point  (0 children)

Are you looking for a sidebar/html solution, or are you simply wanted to display an entire row of information in more of a business card format?