Dynamically change the field referenced by a card

[Jimb0]

I have one unlocked card (Card1) in a form and I need to change the field it references based on the value selected in a pick list (Picklist1)

For Example,

Card1 currently references Field1

The Card1 DataField = "Field1" and the Default = "ThisItem.Field1"

I want to change the value in Picklist  from 1 to 2 and have Card1 DataField = "Field2" and the Default = "ThisItem.Field2"

I've tried updating these values with formulas in the OnChange event of Picklist.  The formula has no errors for DataField, but gives me a type error for Default because they are numeric fields and I am trying to enter text (ThisItem.Field2)

Any help is appreciated!

[mdevaney]

@Jimb0 
You can convert a text value to number by placing it inside the VALUE function.  Doing this will likely remove the error.

Value(ThisItem.Field2)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."