Autofill different columns with different input data, but only until a specific row number

[T_Lina]

I have several rows that I would like to autofill with different input data. 

I used the formula tool to fill the rows. 994 rows are filled with this input data (I don't know why 994 exactly). 

However, I only need 20 rows to be filled as only row 1-20 contain data. 

Can you help me to adjust the formula to only fill a specific number of rows (20) and not more (994)? 

Appreciating your help. Thank you. 

[AngelosPachis]

Hi @T_Lina ,

You can achieve that by using a multi-row formula. First, I would use a record ID tool to assign a unique ID in each of my tools. Then through the multi-row formula, you can say that if your Record ID is less than 20, then assign the input data you desire (in my example, I used the Field1 field)

Observe how my Top 20 records field is populated until row 20, although there are more data in Field1 past that.

Hope that helps

Regards,

Angelos

[christine_assaad]

Hi @T_Lina 

If there is a field that has always to be populated, you can write something like this;

if !isempty([Field1]) then "X" else "" endif

So basically, you are dynamically checking if this field (row) is populated, then it will go and fill the newly created cell with X value. If not, it will leave it blank.

Hope this helps. Cheers!