Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Topic Labels: Scripting extentions
310 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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