gridField - fv!row vs fv!identifier

Question

Hello Folks: 
 I am trying to figure out why the "value: ......." works when I use fv!identifier but fails when I use fv!row (this gives me all 14 values as the output) whereas I am looking for just the current grid-row's value (one value). The gridfied documentation seem to imply both are equi 
 As usual, thanks to the community on my Appian learning journey. 
 Ma

Mike Schmitt · Accepted Answer

The main issue is you're not using fv!row correctly at all -- fv!row is the row value , it's not something that you'd use to access a positional index of the original array, which is what you're trying to do here for some reason. 
 The proper syntax is: value: fv!row.number /* or whatever property of the original dictionary you want to access here */

Harshit Bumb (Appyzie) · Answer

The problem is with the ".number" in value. If you add the same on the data parameter, then fv!row should work.

Mike Schmitt · Answer

As an additional hint: sometimes i'll add a debug column where i just set the value to fv!row by itself - it displays the value of the entire row and helps me remember what properties i have available to add columns for (and to verify that the values look correct). You just need to comment it out, or set its showWhen parameter to false when not in use.

Mike Schmitt · Answer

MaNa said: examples where they use ".fieldname[fv!row]" 
 Can you link me to where examples are written in this way? I've never seen anything like that. Off the top of my head I wonder if you might be getting this confused with how rows are written when using RecordType data, which is more like "value: fv!row[ recordtype!RecordName.Fields.property ]", maybe?

Mike Schmitt · Answer

MaNa said: I usually use a local variable and look at the local variable panel or simply add a 'text field' 
 Those work well too - just not necessarily for grid data, which the example I provided handles reasonably well. In the old days there was no "local variables preview pane", so we *always* had to add a "debug" paragraph field in random spots on our forms to verify the values of local variables in question. These days it's much easier, luckily!

gridField - fv!row vs fv!identifier

Top Replies