Describe the bug:
I have a template column that populates a number from a column in the user’s profile (pretty much per Miracle method), but when I’m trying to use that template column as a “Row” value for “Single value column,” Glide resets it to the previously selected column. In the demo below previously selected column and template column have the same values (essentially looking at the same column elsewhere), but the same thing happens – it resets to the previous value. Not sure if it’s a bug or it’s expected behavior (I’m guessing that “Row” value needs to be a number, and it doesn’t recognize it as a number because it goes through multiple places until it gets here?)
Expected Behaviour:
The “Row” value in the “Single value” column settings should set to the template column.
How to replicate:
Edit select_var1 column
Select template_size_selected as a value in the “Row” dropdown
Click done
If you try to edit select_var1 column again, it resets to the previous value (lookup_size_index)
I think what you are seeing is correct and expected behaviour.
A template by definition is always going to return a string, even if it looks like a number. And a Single Value column expects a number, as you guessed.
If your template returns something that looks like a number and you want to use that in a Single Value column, then what you could do is first pass the template through a Math column. You don’t need a formula, just a single replacement. This should return a number, which you can then use in your Single Value column.
I haven’t actually tried the above, but I’m fairly confident it will work.