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
Discussion posts and replies are publicly visible
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,
Quite possible I am confusing the two - but I am also wondering why I went down the variable.fieldname[fv!...] path. I have been using various interface recipes as the starting point for my learning process, so could be from one of those example - which I misunderstood.
But I will keep my eyes open if I come across it.
Thank you for that hint. I usually use a local variable and look at the local variable panel or simply add a 'text field'. Is there any better way to do debugging?
Thanks.
Hi
I tried this
a!localVariables( local!data:{{number:301,name:"Calcium"}, {number:303,name:"Calcium"}}, a!gridField( data: local!data, columns: a!gridColumn( label: "Number", value: fv!row.number ) ))
and it worked
Are you using a!localVariables if yes could you please share the data of you local variable from the local variable data section
I strongly feel your data structure is incorrect
KomalThe issue was my incorrect usage of syntax to access the data field. I was originally using it as shown in the image below.
As Mike Schmitt pointed out (and as your example shows), I was using fv!row as an index to the data ".number[fv!row]" which is incorrect. I should have used "fv!row.number".
I am not sure what you mean by 'data structure is incorrect'. The local variable I am using is as shown in the earlier image I had sent.
Thanks for your help.
Great. I assumed the data is improper dictionary structure and so you are facing issue while using .number.
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!