Hello, I have a problem in appsheet. I have a time table where I have the hours from 9 to 20:00. However, when I try to get it through enum in the appshet, it comes out with 44 seconds less and then I get an invalid entry error.
If someone can help me I would be so thankful
Confirm the time values in your data source are precisely as displayed. Potentially, for example, cell B7 is actually 11:29:16 and is simply rounded to 11:30 according to the cell's formatting within the sheet.
Also, you can enable the Ignore seconds property when configuring a Time type column in the AppSheet table.
@dbaum wrote:onfirm the time values in your data source are precisely as displayed. Potentially, for example, cell B7 is actually 11:29:16 a
But if I have written 11:00 in excel, it cannot be rounded up, it should be the exact number and I have not touched anything
@informรกtico wrote:
it should be the exact number
Debe de ser, y para confirmar revisa quรฉ valor sale en la casilla de fรณrmula:
ยฟCuรกl es la expresiรณn entera de Valid if?
Pues si que lo es:
Y la expresion del valid if es esta:
No sale en tu respuesta ninguna imagen del valor literal almacenado, pero tengo entendido que lo has confirmado.
La expresiรณn no implica ningรบn problema, pero sรญ se puede simplificar. Para obtener la lista de valores de una columna entera, hace falta no mรกs, por ejemplo, Horarios[Domingo]
y no SELECT(Horarios[Domingo], TRUE)
.
ยฟCuรกl es la "Warning" que sale en la columna?
Revisa el resultado de cada componente de la expresiรณn a travรฉs de la funciรณn Test del editor de expresiones.
Supongo que referira a esto pero incluso con la id puesta me sigue dando error.
User | Count |
---|---|
43 | |
25 | |
23 | |
14 | |
13 |