Im new to corvid and trying to do a search in a data collection for an input made to a form but it isnt returning any results. TIA

Ask the community
,
1

1379×742 56.3 KB

2

Hey Saic,

Try to use onKeyPress() event handler instead of the onChange() method.
*Pay attention to write in eq() method the Field key and not Field Name.
*That the database name is written correctly.

Best of luck,
Sapir

3

thank you for your reply.

this search returns results with the following code.

wixData.query(“BOOKING”).eq(“Bookingnumber”, $w(‘#BookingNumber’).value)

This field was created by an insert function in the code.

1574×621 31 KB

4

this search doesnt return anything and was this code

wixData.query(“BOOKING”).eq(“Booking Number”, $w(‘#BookingNumber’).value)

This field was created when the form submission button was created.

As seen the field names look different. The field created by code is enclosed in square brackets. The field name created by the form looks different. I’m guessing i’m accessing the field name incorrectly but not sure what the correct syntax should be

1574×621 40.1 KB

5

Because you used the field name instead of the field key.

6

Thank you both. Got there in the end :slight_smile: