Query a database for the specific field/row values


I am working on a calculation routine that will send results back to a form. My aim is to write a java script that finds specific field/row intersection values in my database. Then, using other input from the user and the filtered values, do my calculations and send the results to the page form.

I am struggling with how to code the filtering the field/row values into variables for use in the calculations. I have searched this forum for a method but maybe I am searching for the wrong words (I often have a terminology problem that emanates from coding Fortran and Visual Basic.)

Can someone give me some guidance? Or point me to some snippets that can help?

T Saha

Hello! It is difficult to help with no code snippet to start from, but it sounds to me like you will need to look through the wix-data API docs to see how to query what you are looking for.

Let me know if this is useful https://www.wix.com/velo/reference/wix-data