Data is not updating

[Dican]

Hi!

I got two tables:

1. Entradas y Salidas

2. Reporte de Bodega

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"

Referenced row code:

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"

Set these columns code:

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! ❤️

[Marc_Dillon]

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

[Dican]

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

[Marc_Dillon · Accepted solution]

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

[Dican]

OMG! So damn simple!!!!!!!!

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