Transferring refs from one table to another

I have a PRODUCTS table , a PRODUCT_TEMPLATES table and an OPERATIONS table. The operations table’s rows reference some rows of the products table. Now, I have an action on each Product entry that when clicked, will create a new Operation entry for each operation that is already linked to the respective product, and link it to the last PRODUCT_TEMPLATE entry (which is created through another action) in the database.

Since the operations table is linked to the products table, there is a VC called “Related OPERATIONSs]” holding those refs. What i’ve been trying to do in order to extract the values of those refs is something like this:

INDEX( [Related OPERATIONSs], 1).[OPERATION_TYPE_UID] to get the [OPERATION_TYPE_UID] ref.

Despite the results returned being correct (checked through “Test”), I get an Error saying that the return type doesn’t match the required “Ref” type. Why is that?

Instead of this:

INDEX( [Related OPERATIONSs], 1).[OPERATION_TYPE_UID]

try this:

INDEX( [Related OPERATIONSs][OPERATION_TYPE_UID], 1)
3 Likes

Works like a charm, thanks a ton Steve!

1 Like