Doubts using for loop with actions

[Valeria_Estrada]

Hi!
i’m pretty new using appsheet and i have a particular case that I don’t know how to solve.

How can I replicate this logic in appsheet?
Thank you very very much!

[Aurelien]

Hi @Valeria_Estrada

You may want to have a look there:

help.appsheet.com

SELECT()

Gather column values from row in table or slice

help.appsheet.com

SUM()

Arithmetic sum of list items

help.appsheet.com

AND()

Are all true?

In your case, that would give:

SUM(
  SELECT(TABLE B[Units per package],
    AND(
      [_THISROW].[Size]=[Size],
      [_THISROW].[Reference]=[Reference]
    )
  )
)

[Valeria_Estrada]

Thank You @Aurelien
I forgot to clarify that From the income of table A, I have to execute a series of actions recreating a loop where the result is the printing of all these rows in table b
that´s my doubt

[Aurelien]

Hi @Valeria_Estrada

You may want to use the expression I gave in a virtual column.
This way, the sum calculation will always be correct.
Please find here how to use it:

help.appsheet.com

Virtual Columns

Check out how you can use virtual columns to add more information to your app.

Valeria_Estrada:

I have to execute a series of actions recreating a loop where the result is the printing of all these rows in table b

I’m not sure of what you mean here, but I think the previous indication may be the answer to your question, i.e whatever data you append in the table B, the calculation made in a virtual column in table A will remain correct, because recalculated “on the fly”.

If that’s not the answer to your question, can you please share further details, context, and what you made so far ? Screenshots are best