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
The grid field expects a datasubset as the datasource. It iterates on the items and make each individual item available as fv!row and the corresponding identifier (datasubset.identifiers) as fv!identifier.
Hi Stefan:
Thank you for your response. I tried datasubset variations too. Those led to errors too.
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 */
Mike,
That makes so much more sense. I always wondered why I had to provide the variable name if the data-attribute already defined the data-source.
This worked.
Guess I have to review examples where they use ".fieldname[fv!row]" to access individual values to determine what is the difference by example and their example.
Thank you!
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.
Just follow the error message to solve this.
Check out this example from the documentation of how to use fv!row.
docs.appian.com/.../read-only-grid-configuration.html
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?
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.
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!