Using “thisRow” seems to always give you text, even if the column you refer to contains a number.
ie its doesn’t seem to give you the “type” of data in the row, meaning you have to convert it back to whatever type it is.
Is this a bug or am I missing something?
Hi @Ian_T !
thisRow alone doesn’t return a value per se… it returns the row reference of this specific row in the table (and uses as a display, the value in the field you selected as
Display column in your table) .
thisRow being a row, stores behind the scene, all the values in the various fields you might have in your table for this very specific row.
If you need a value stored behind the row reference
thisRow to use it somewhere else, you can simply access (dereference) the appropriate value by appending
.[Name of the field where the value is stored] to
Which would look like this in its entirety :
thisRow.[Name of the field where the value is stored]
Here’s a small sample to illustrate
You’ll see 3 fields:
Namea number field which is also the
Display columnof my table
thisRowa text field with the simple formula:
You’ll see that the formula editor with small visual cues/hints will tell you that
thisRow outputs a row (nothing else, it’s a row).
thisRow.Name: a number field where I’ve accessed (dereferenced) the value stored in the field
thisRowusing the formula :
You’ll see that this time, the formula editor will tell you (still with visual cues/hints) that
thisRow.Name outputs a number (as the value within the field
Name is a number stored in a
Number type of field) .
I hope this helps
Thanks for taking the time!
I think issue was that the thisRow().column…gave me some text even though the column type was a number.
Hi @Ian_T !
Without more context I can only guess that you used
thisRow.[Some Number] in a formula outputting a text value, maybe ?
Formulas tend to expect an input of a certain type but they also output a value of a certain type.
So, depending on the formula you used,
thisRow.[Some Number] was potentially converted into a text value during the process…
This is just pure speculation
This actually solved another problem I was having and had no way of explaining so thank you!
My pleasure @Bradley_Skaggs !
Thanks for letting me know this helped you to overcome your issue !
It’s really appreciated !
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.