What is the LOOP or FOR( ) inside appsheet

AppSheet AppSheet Q&A
1

Is it possible to take a value from a parent table like “apple, orange, banana” and turn it into 3 rows in another table?

I would imagine this will require the use of some sort of iterative loop or for( ) function in programming, but I am not sure what is the name of the counterpart in appsheet.

Thanks very much in advance

2

There are no direct loop or for counterparts. Instead, you have to use actions. This post might be useful:

[FAQ: add row per value in EnumList](https://community.appsheet.com/t/faq-add-row-per-value-in-enumlist/30953) Tips & Tricks ?

Add one row per value in an EnumList column list. Try the sample app! For this example, the table from which the row-addition process will be initiated is called Control Table. The table to which new rows will be added is called Target Table. Use your own names as you see fit. Note that they could even be the same table. Control Table must allow updates; Target Table must allow adds. Control Table must have at least two columns for this process: EnumList (type EnumList; a list of Enum values;…

2 Likes
3

Hi Steve, thanks for your help.

If I understand the post correctly, I will need to use some sort of recursive algorithm with the use of workflow trigger inside app sheet, is that correct?

4

You can use ifs for the workflow to trigger and send emails

5

SunnyChu:

is that correct?

Correct!

1 Like