Column Data Type Issues

[T_I_Phong]

Hi AppSheet Community,

I have two tables:

1. Orders: Contains an OrderID column (Type: Number, Key)
2. view_Orders_Details: Contains an OrderID column (Type: Ref, referencing the Orders table)

I’m encountering an issue where the OrderID column in view_Orders_Details seems to be interpreted as Text instead of Number, causing errors when using formulas like FILTER or SELECT. For example, I tried the following formula in the Orders table:

However, I can use the formula: REF_ROWS("view_Orders_Details", "OrderID")

[Aurélien]

Hello! Why not define your Order primary key as a text field, and enforce numeric input using a data validity rule like this: CONCATENATE(EXTRACTNUMBERS([OrderID]))?