Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Help with DDL

Avatar

Level 7

I have two DDL

DDL_A

Items:DepartmentA, DepartmentB

DDL_B

Items: 1233215000, 5672006000 (I have lots of numbers that starts with 123...Total 10 digits and lots of numbers that start with 567... and so on)

How I can force the user if they select a number that starts with 123.. from DDL_B the display item for DDL_A always will be:DepartmentA

Thanks

1 Reply

Avatar

Level 10

Hi,

You would need to have a script in the calculate event of DDL_A (which will set this to Read Only).

if (Substr(DDL_B, 0, 3) == "123"){

     this.rawValue = "Department A";

}

Hope that helps,

Niall