Cascading Dropdown Issue

[IamBlossom]

I have a Text(255) field which is set to Cascading Dropdown. I would like to use Formula field as Field for value, however, I cannot pull up any Formula fields from the available options. Is this a default behavior?

 

 

Thanks in advance!

 

[cheonsa]

Hi @IamBlossom, 

The type of formula field is equivalent to Text(64000). Text(64000) cannot be used in autocomplete, cascading, etc.

 

Use this formula instead:

CONVERT(NVARCHAR(255), [@field:First_name] + ' ' + [@field:Last_name])