Suggested values-Value 'aaa' in field 'Task' cannot be converted to type 'Enum'.

Hi everyone, 

I have problems with "suggested values". 

What I want is to have a dropdown value (task column) depends on the previous value( Phase column). 

I found the solution from previous Appsheet Q&A: To set the "Task column" with "valid_if" and set the "Phase column" with "suggested_value" and its' column type is "Enum". Everything goes fine here and I do see the dropdown list as wished. However, after I submitted out the form, it said "Value 'aaa' in field 'Task' cannot be converted to type 'Enum'.

Is there anything wrong with the setting? 😂

 

 

0 5 83
5 REPLIES 5

Click on the Enumlist column and "Allow other values". Tick this.

 

Regards

Srikanth

Hi Srikanth, 

Thanks a lot for your help. 

It works to click the Enumlist and "Allow other values".

Another question is in this way, the user will have more than one choices while "Enum" allows only "one" choice. Do you know there anything I can do?

 

Thanks again for your help. 

 

Use an Enumlist in that case instead of Enum.

Thanks a lot. 

It now works fine in Enumlist. 😀

In the suggested values....

If you are using 2 or more lists... Then...

List(Concatenate(Text(List 1), text(List2))

 

The above can help.

Top Labels in this Space