The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.

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

posted Sep 22, 2020 1:48:52 PM

Topic Labels: Scripting extentions

0 946 0

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