Set a Field to the Text Value of an Option Field with Scores

Hello Tadabase Community! :wave: If you’ve ever tried to use a rule or text formula to copy an option-type field with a score value, you’ll notice that only the score value is copied. I have a few methods that you can use if you’d instead like to copy the text representation on your option values.

Please see this video containing an explanation on two different methods that you can do to accomplish this. I’ve included some timestamps below to help navigate the video:

  • Background and info on the difference between the two methods @0:00
  • Equation method @0:53
  • Pipe method @3:20
  • Demo @6:44
1 Like