Help with LF Formula on collection field

asked on August 5, 2024

I have a collection field which I am trying to grab the LEFT char out of the string. I am using a first collection field to first grab the entire value using index/row functions which works fine, but then I am also using another collection field to actually attempt to extract the LEFT char from the string of the first collection variable. I was able to create a js function to accomplish this, but I am trying to get better at the LF formulas and struggling with replicating this functionality with formulas. Any help would be appreciated!

Original Collection Field: siusom_GLFO_collection.unitDescription

First Collection Field Formula: =INDEX(siusom_GLFO_collection.unitDescription,ROW())

Second Collection Field Formula: =LEFT(INDEX(siusom_GLFO_collection.glfo_select_validation_collection_field_copy,ROW()),1)

0 0

replied on August 5, 2024

It just gives a calculation error:

This field contains a calculation error. References: .

That sounds like you have a typo somewhere. I'd check that the table variable and column variable are accurate here: "siusom_GLFO_collection.glfo_select_validation_collection_field_copy". Is there a reason that you can't just use the same reference from the first field? It should be identical.

=LEFT(INDEX(siusom_GLFO_collection.unitDescription,ROW()),1)

Question

Question

Help with LF Formula on collection field

Replies

Sign in to reply to this post.