Data is not updating

AppSheet AppSheet Q&A
,
1

Hi!

I got two tables:

  1. Entradas y Salidas

Dican_0-1651692125422.png
Dican_0-1651692125422.png1154×110 6.28 KB

  1. Reporte de Bodega

Dican_1-1651692143046.png
Dican_1-1651692143046.png465×117 2.47 KB

I want to update the table “Reporte de Bodega” with all the entries and exits of products from the table “Entradas y Salidas” based on products and dates.

So I made a few actions:

Action from the table “Entradas y Salidas” which makes reference to the table “Reporte de Bodega”

Dican_2-1651692368896.png
Dican_2-1651692368896.png958×475 35.8 KB

Referenced row code:

Dican_1-1651684940387.png

Action from the table “Reporte de bodega” which is supposed to update the rows that has the same name of products and the same date from the table “Entrada y Salidas”

Dican_4-1651692505201.png
Dican_4-1651692505201.png946×459 32.1 KB

Set these columns code:

Dican_2-1651684965258.png
Dican_2-1651684965258.png797×201 5.83 KB

At this moment all I can do is update the first line row of the table “Reportes de Bodega” while all the other products keeps marking me as zero.

Any ideas?

Thanks! :heart:

2

Huh? What are these expressions? Where are you using them? What exactly are you trying to do?

3

Hello! Just edited my question, is that enough information? Thanks!

4

Key values must be unique. You are using the same key value in multiple records in the Reporte de Bodega Table. When multiple rows in the sheet have the same key value, the app only considers this as a single record.

https://help.appsheet.com/en/articles/1023086-what-is-a-key

5

OMG! So damn simple!!!

Thanks Marc!! Been hitting my head agains the keyboard for hours for this ! HAHA THANKS!