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?
Solved! Go to Solution.
Instead of this:
INDEX( [Related OPERATIONSs], 1).[OPERATION_TYPE_UID]
try this:
INDEX( [Related OPERATIONSs][OPERATION_TYPE_UID], 1)
Instead of this:
INDEX( [Related OPERATIONSs], 1).[OPERATION_TYPE_UID]
try this:
INDEX( [Related OPERATIONSs][OPERATION_TYPE_UID], 1)
Works like a charm, thanks a ton Steve!
User | Count |
---|---|
39 | |
29 | |
23 | |
23 | |
13 |