Making a Points inquiry form

Ask the community
,
1

Hello everybody

I’ve established a point earning system to reward customers in our family’s pharmacy. Were now using another software to record thee points. but I want to move everything to our webste database so people can consult how much do they earned.

I don’t know how to connect all the elements of the form so that people can type their customer card number to get a response. I’ve been looking on the Wix support section, but I can’t figure it out.

This is an example of what I need. Anything is connected to the database here.

1366×768 54.4 KB

This is the database with some example customers

1366×768 89.3 KB

I will be very grateful if someone could help me with this issue. I apologize if my English is not very good.

2

Your English is fine, don´t worry about it. But this Forum is about helping people out with problems in their code, not providing it for them. But basically, you should:
1)on Submit button click, call a backend function to query db for this “tarjeta”
2)backend returns query result to frontend
3)frontend checks if result is not empty
4)if not empty, show “puntos Totales”, else show “Tarjeta no encontrada” or something similar.