r/AppSheet

Estoy haciendo una aplicación muy sencilla para que mis 4 empleados guarden un registro diario de su actividad. Ya que los 4 van a usar siempre el mismo y único dispositivo que tendrá instalada la app, he creado un login con una tabla USUARIOS mediante USER SETTINGS. Funciona todo bien, con sus filtros de seguridad para que cada empleado vea solo sus registros y va todo perfecto hasta el momento de cerrar sesión, ya que el "LOGOUT" me redirige de nuevo a la vista SETTINGS donde se haría el login el siguiente empleado, pero me aparece en la esquina superior una flecha para volver atrás, volviendo a mostrar todos los registros del empleado que acaba de cerrar sesión.

Hay alguna forma de deshabilitar esa flecha o resetear todos los campos de user settings o alguna forma de evitar que se pueda pulsar ese boton o que al pulsarlo muestre datos del usuario anterior??

In table view if you have an Action associated with a field/column then only the action is displayed and not the value. Is there anyway to show both, or even choose which one?

I have many fields that have Actions attached to them, such as a open-hyperlink or copy-value-to-clipboard that I use mostly in a Detail view but as soon as an Action is associated to a field then in Table view only the Action icon(s) are shown. Even if I do a "show_if" in the Action to only show in Details view, the Table column will be blank.

The only workaround I know of is to create a virtual column that duplicates field and attach the Action to it, and then show both of the fields. This is cumbersome as I have over 50 of such fields.

Any other workarounds, or is this something Appsheet will improve?

https://preview.redd.it/l3ww12qc3b2h1.jpg?width=428&format=pjpg&auto=webp&s=26e7731a532b00e70d9611c316828b0e932bfe49

https://preview.redd.it/iwfay2id3b2h1.jpg?width=940&format=pjpg&auto=webp&s=9285916ad33e83d268b10dddddc82e569cbc5791

https://preview.redd.it/5nlpm9bw4b2h1.jpg?width=417&format=pjpg&auto=webp&s=1c0dbfa393277570b2a4c6c0ee940b5d61112fe5

So I deleted my last post cause I finally got it to work right after posting. This button I can not remove the [Favorites] <> true and replace it with CONTEXT("View") <> "Total of Movies" like I did with the other two. If I remove what is all ready in there as it will remove it but then the button does not function right. The button right now is a yes/no button so there are two buttons but only will show one at a time like an on/off switch. But if I change it to display the CONTEXT("View") <> "Total of Movies" like other it will show two buttons instead of just one at at time like before. See last image of what happens should only show one heart whether it is heart outline or heart filled. I want to get off menu but still work properly.

Hey everyone,

I wanted to open a discussion on handling one of the most notorious and frustrating limitations in Google Apps Script add-on development: the multiple accounts Authuser=0 trap.

The Context: My team recently launched a Workspace management add-on. Shortly after launch, we onboarded an enterprise client who left a great review but immediately reported a frustrating "nitpick": he's logged into multiple Google Workspace accounts, while he's accessing the add-on with his second logged account, the sidebar of our add-on was selecting the default account of their browser rather than the account actually linked to the active spreadsheet.

After consulting with my lead dev, we realised we were dealing with a platform-level infrastructure issue, and not a bug in our code.

The Trap: As most of you know, when a user is juggling multiple Google accounts in one Chrome window (e.g., u/0/, u/1/), Google Apps Script's HtmlService often gets completely confused by the session cookies. If they open the sheet with a secondary account, the underlying iframe still forces the add-on to authenticate using the Default account (authuser=0).

The result is massive user confusion, as the sidebar displays data or permissions for the completely wrong account.

No Workaround Found: We searched high and low but couldn't find a native programmatic patch to force the iframe to respect the active document's user context. So we advised the client to perform their admin operations inside a dedicated Chrome Profile or an Incognito window.

My Questions for the Community: Since we want to provide the smoothest UX possible, I’m curious how other devs here are tackling this:

1. The "Holy Grail" Fix: Has anyone found a reliable native workaround, undocumented parameter, or JS hack to force HtmlService to respect the active authuser index?
2. User Experience (UX): Do you preemptively warn users about this in your UI/onboarding flow, or do you just document it in your FAQs and wait for the support tickets to roll in?
3. Google's Roadmap: Has anyone who talks to Googlers heard any whispers on whether this is ever getting patched at the infrastructure level?

Would love to hear your thoughts, workarounds, and war stories regarding this bug!

I think I have a solution to this, but I want to be sure I'm on the right track (and not missing something simpler / obvious).

For the purposes here, I've got two tables. One is "Checklists". Each just has a name (and an auto-generated ref-list). The second is "List Items". Each list item has a name and a ref to a checklist (isPartOf, etc.). This works fine. I'm using LINKTOFILTEREDVIEW when selecting a checklist to get a deck with only the "owned" items in that list. However, now I want to allow adding an item from that filtered view... From reading similar questions, it sounds like the usual answer is to add an action on the form-saved event that populates any fields. So, two questions:

1. Is that what I need to do? Also - the default form-saved event does a navigate-backwards. Do I need to keep forcing that to happen (eg, group action that does the field setting and then navigate back?).

2. I'm pretty sure I can't get the context information I need without extra trickery. This seems similar to the "set the view title for filtered views" problem, where I need to stash the checklist's name in a global per-user table, then fetch it in the sub-view's display title formula? Assuming I go through that, I can also use that same stashed value to populate the new item's checklist ref?

Hi everyone,
I’m using AppSheet for an internal workshop management app. Recently, the “10 users exceeded” warning started coming back again, and I’m worried the app may stop working if the limit is enforced.

To be safe, I copied the app as a backup.

My idea is this:
Main App → currently connected to the live Google Sheet

Copied Backup App → I want to connect it to the same live Google Sheet used by the main app

The structure of the Google Sheet is identical, including the same table names, column names, key columns, and related tables.

My questions are:
Is it safe to connect the copied AppSheet app to the same Google Sheet as the main app?

If the main app stops because of the 10 users limit, would the copied app still work, or would it face the same limit?

Would deploying the app and then undeploying it help reset or remove the 10 users warning, or is that risky?

Is there any better emergency backup method for an AppSheet app that is already in use?

I understand the proper long-term solution is probably licensing, but I want to avoid downtime while I figure that out.

Any advice from people who experienced this before would be appreciated.

TL;DR
I want to leave a date field empty, but AppSheet defaults it to Today's date. Has anyone found a workaround for this?

I have a form with:

• “Event Start” → required
• “Event End” → optional

The issue is that even when I leave the Initial Value for “Event End” empty (""), the form still auto-fills today’s date. So, it looks like Date fields can never truly start empty.

In my use case, there are many times where only an “Event Start” date exists, and I would prefer the “Event End” field to remain completely blank unless the user explicitly sets it. Having today’s date appear by default means users must manually duplicate the same Event Start date into Event End just to avoid an incorrect date being shown there.

Is there any proper workaround for this, or is it just current AppSheet behavior?

Also, the date picker could really benefit from simple “Today” and “Clear” buttons. And the “Clear” button could be disabled for required date fields.

https://preview.redd.it/2dyai2x9l20h1.png?width=728&format=png&auto=webp&s=14423ae52d0a698f7145d31dd0ed1d4a138bbbf1