So, I have 3 input fields - a dropdown, a radio button and a checkbox for user input which is concatenated in the code to be a value (random, but the value is called ‘phoebe’). The query works when there is an option chosen from all 3 (the first 2 are required, the 3rd is an ‘additional items’ and is optional), but not when only the 2 required inputs are there. Even though this concatenates to a value which is present in the database, just as the values are for the 3 options.
i.e. 3 bedroom house + standard pre-purchase report = concatenated value “phoebe” = ‘S PP-PS-Report’ which is the database, but does not get passed to the quote calculater repeater.
but… 3 bedroom house + standard pre-purchase report + hill site = ‘S PP-PS-Report HS’ works, and the value from the database shows up in the repeater.
Is there some kind of validation going on that I don’t actually want to be happening?
Code is as below:
// For full API documentation, including code examples, visit Velo API Reference - Wix.com
import wixData from ‘wix-data’
$w.onReady( function () {
});
export function dropdown1_change(event) {
let size = $w(“#dropdown1”).value
//console.log(size);
}
{
let phoebe = ${$w('#dropdown1').value} ${$w('#radioGroup1').value} ${$w('#checkboxGroup2').value};
//console.log(phoebe);
}
export function button2_click(event) {
let phoebe = ${$w('#dropdown1').value} ${$w('#radioGroup1').value} ${$w('#checkboxGroup2').value};
let x = phoebe;
console.log(x);
search();
}
function search() {
let phoebe = ${$w('#dropdown1').value} ${$w('#radioGroup1').value} ${$w('#checkboxGroup2').value};
console.log(phoebe);
wixData.query(‘QuotePricing’)
.eq(‘quoteType’, phoebe)
.find()
.then(res => {
$w(‘#repeater1’).data = res.items;
});
$w(“#group3”).show(“fade”, fadeOptions);
//$w(“#box1”).collapse();
}
let fadeOptions = {
“delay”: 500
};