r/AppSheet

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

Por favor, requiero de su ayuda para crear una fórmula para el siguiente caso:

Tengo 2 tablas

“ORDENES DE SERVICIO” con los siguientes campos:

ORDENES_DE_SERVICIO_ID      

FECHA 

HORA  

EMPRESA          

CONDUCTOR ASIGNADO           

VEHICULO         

ORIGEN             

DESTINO           

NUMERO DE PASAJEROS            

VALOR 

PEAJE   

TOTAL 

AUTORIZADO POR:       

ESTADO             

OBS

 

Y la tabla ref “DETALLE ORDENES DE SERVICIO” con los siguientes campos:

 

DETALLE_ORDENES_DE_SERVICIO_ID   

ORDENES_DE_SERVICIO_ID      

FECHA 

PASAJERO         

C. COSTOS        

TELEFONO        

TIEMPO RECORRIDO    

VALOR 

PEAJE   

TOTAL

 

Requiero que en el campo “VALOR” de la tabla “DETALLE ORDENES DE SERVICIO” sea el resultado de dividir VALOR de la tabla “ORDENES DE SERVICIO” entre NUMERO DE PASAJEROS.

Gracias por su ayuda comunidad

https://preview.redd.it/ti9nw5o786zg1.jpg?width=618&format=pjpg&auto=webp&s=45d519dfc90adfa429418454cbc2b6a0df65655d

Hello im new to app sheet and was able to cook up a quick prototype for an app to manage the 3d printers for my university club. I unfortunately noticed the limitations of the free version which could limit the functionality such as the 10 user limit and not being able to automate the emails to everyone not the owner. I wondering if anyone had any tips Ive heard you can make dummy accounts which allow for up to 5 users so I could maximize use but I don't know if that leads to potential issues that could lead to my app being flagged. For context my club is pretty big (maybe 30-40 users)and I would like to find a way to utilize agents

Hola a todos, requiero ayuda con una formula, el caso es el siguiente:

tengo una tabla principal que se llama "ORDENES DE SERVICIO" y a su vez mediante tipo Ref, tiene enlazada una tabla llamada "DETALLE ORDENES DE SERVICIO". Lo que hago mediante esta app es crear una orden de servicio para transporte de personas y en la tabla secundaria los detalles de los pasajeros. En la tabla principal tengo un campo que me pide contar el numero de pasajeros que tiene la orden de servicio que pueden ser uno o varios. Espero haberme hecho entender.

Si alguien sabe como se podría hacer, le agradecería me diera ayuda con este caso.