Los datos de la tabla (un inventario) se ingresan entradas y salidas por un formulario, estos movimientos se resumen en una tabla, tanto formulario como tabla tienen su propia hoja en database de google.
¿Como se puede formular el registrar por material la ultima fecha por entrada y de salida en la tabla
Here’s an English translation of your inquiry:
The data in the table (an inventory) is entered as incomings and outgoings through a form. These movements are summarized in a table. Both the form and the table have their own sheet in a Google database.> How can we formulate registering the last date of incoming and outgoing for each material in the table?
I think that the solutions on the following pages might help you:
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Most-recent-unique-child-records-list/m-p/454614
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/most-recent-entry-by-date/m-p/721968
The use of expressions like SELECT() and MAX() can be expensive, depending on how much data you have, how it is structured, and how complicated your expression winds up being. To avoid such issues, I have used formulas on the spreadsheet side to achieve the same ends. That approach, however, has it’s own problems.
Last date of incomings
LOOKUP(MAXROW( “formulario inventario”,“Fecha orden de ingreso”, and([_THISROW].[Material] = [Material],[Movimiento]=Entrada)), “Formulario Inventario”, “Fecha orden de ingreso”, “Fecha”)
Last date of outgoings
LOOKUP(MAXROW( “formulario inventario”,“Fecha orden de ingreso”, and([_THISROW].[Material] = [Material],[Movimiento]=salida)), “Formulario Inventario”, “Fecha orden de ingreso”, “Fecha”)
Wich can be translated into:
LOOKUP(MAXROW( dataset, column, AND(condition1, condition2, [condition3 …]), dataset, column, return-column)
With this i’m able to record on a table the last date for incoming and outgoings of materials.
I forgot about MAXROW(). Glad you figured it out!
