Help

How to carry over a formula field value to single select field

201 0
cancel
Showing results for 
Search instead for 
Did you mean: 
george_glass1
4 - Data Explorer
4 - Data Explorer

I wrote a script in my automation to create a linking table of sorts that carries over records from two different tables. I have a field that is a formulated value in both source tables and in the target table I want that to be single-select. Is this possible? I cannot get the values to match up! The formulated value in source tables are based on dates, depending on what range the date falls in the output will be either one of 4 values: "Q1", "Q2", "Q3", or "Q4".

Now when I log the output of the target field value of each record (there are hundreds) I get:
"Q2, Q4, Q3, Q3, Q3, Q3, Q2, Q2, Q4, Q1, Q3, Q4, Q1, Q2, Q3, Q4, Q4, Q3, Q4, Q3, Q3, Q3, Q3, Q3, Q4, Q3, Q1, Q3, Q2, Q4, Q3, Q3, Q3, Q4, Q2, Q3, Q4, Q3, Q4, Q3, Q1, Q3, Q3, Q3, Q3, Q3, Q3, Q3, Q3, Q3, Q2, Q2, Q3, Q1, Q3, Q3, Q4, Q3, Q2, Q3, Q4, Q4, Q3, Q3, Q3, Q3, Q3, Q2, Q2, Q1, Q3, Q3, Q3, Q3, Q3, Q3, Q2, Q3, Q3, Q4, Q3, Q1, Q1, Q2, Q3, Q3, Q4, Q2, Q2, Q3, Q3, Q3, Q2, Q2, Q3, Q1, Q2, Q4, Q3, Q4"

Can anyone help me understand why this is? I'm assuming if I just plugged these "duplicate" values into the single select options it would work but ideally I need unique options.

0 Replies 0