Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Loop thru table to make only rows that are not null visible

DKinsley
Level 9
Level 9

I created a table that has a question in one row and a hidden row directly below each question that can be opened (made visible) to add text in the ActionItem field.

I am trying to write a script that counts how many Action rows that have data entered into the ActionItem field (!==null) and make only those rows visible. 

Here's my attempt that does not work:

for (var a=0;a<Form1._Table2.count;a++){

for (var b=0;b<Form1.Table2.all.item(a)._Action.count;b++){

  if (Form1.Table2.all.item(a).Table2.Action.all.item(b).Table3.Row1.ActionItem.rawValue !== null){

   Table2.all.item(a).Table2.Action.all.item(b).Table2_Action.presence="visible";

  }

  }

  }

ScreenPrint.PNG

0 Replies