Cascading Text Field Pulls in Wrong Information

[ChristianM]

Hi All,

I have a Submission DataPage with the following setup:

s_Stock = AutoComplete field that gets value from View A (view of Table A).
Multiple Cascading Text Fields that use the s_Stock field as the parent field to then pull cascading values from Table A.

The setup for the Cascading Text Fields:
Parent Field = s_Stock
Lookup Table = Table A
Filter cascade by = stock_number

The issue is that the Cascading Text Fields will sometimes pull in the wrong information. For example I have stock numbers 46207 and 46207C in my view. Here are my values in Table A:

 

When I type 46207C, the Make field pulls in the "brand" field from Table A which should be the "NORTH TRAIL" value. However, what actually populated is the "CHEROKEE" value (the value for Stock 46207).

It seems as though the filter aspect of the Cascading Text Field isn't taking into account the full value but instead the shorter value with same partial characters.  Any ideas?

Thanks!

[CoopperBackpack]

Hello @ChristianM,

I tested the DataPage with the similar settings and cannot replicate the issue you described.

Do you select the value from the list that appears when you start typing?

Because if you select 46207 and add 'C' manually, the value in the Cascading TextField doesn`t change.  

[ChristianM]

Hi @CoopperBackpack

Thanks for the reply.

The issue occurs when users type in the full value manually or paste the full value (not selecting from dropdown).