Problem:

The issue here is that the user wanted their custom query filter to function like an OR query instead of the default AND..

Solution:

Previously you were allowed to change the field comparison logic from AND to OR and vice versa but it got broken somehow in a recent update.

To work around this you're going to have to construct the query manually using the views hook. Add the following to your Toolset Custom Code section and it should help to resolve the issue.

The Toolset custom codes can be found at Toolset -> Settings -> Custom Code

add_filter( 'wpv_filter_query', 'filter_by_multiple_fields', 10, 3 );
  
function filter_by_multiple_fields( $query, $settings, $view_id ) {
    if ( $view_id == 1234) {
       $query['meta_query'] = array(
                'relation' => 'OR',
                array(
                    'key'     => 'color',
                    'value'   => '1',
                    'compare' => '=',
                ),
                array(
                    'key'     => 'price',
                    'value'   => '1',
                    'compare' => '=',
                ),
        );
    }
    return $query;
}

Now replace the 1234 with the ID of your view and then replace color and price with the slugs of the field that you are doing the query on. Remember to add the wpcf- prefix to the types custom fields slugs.

Problem:

Put different products into cart on different field values.

Solution:

After user submit the form, in server side, you can use filter hook cred_commerce_add_product_to_cart to change the product in cart automatically, see our document.

Relevant Documentation:

https://toolset.com/documentation/programmer-reference/cred-commerce-api/#cred_commerce_add_product_to_cart