Help

Script that would select the correct single field based on a number

Topic Labels: Scripting extentions
900 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Goodland
4 - Data Explorer
4 - Data Explorer

Hi everyone,

I have a column (Exact Employees) which contains the exact number of employees a company has and a column (Employees) with a Single Select field with brackets like:
1 to 10
11 to 25
etc.

I’d like to have a script that would do something like:
Check “Exact Employees” and if number is between 1 and 10, then select 1 to 10 in “Employees” and so on.

Can someone help me get started?

Thanks

0 Replies 0