DEV Community

m7s8n6
m7s8n6

Posted on

Is there any way to match the html one field data with the Google sheet column.

I have a google sheet, and I want to get HTML form data in that google sheet. The google sheet has 4 columns.

Voucher Code
Name
Email
Phone number
Voucher code column is already filled with voucher codes.

And in the HTML form, person will fill the voucher code, name, email and Phone number. Voucher code will match the voucher code column and data of name, email and phone number will be filled in the same row. Now here I have to check the validation. If the voucher code, already has name, email and phone number. Then there should give a error message that already someone is there on that voucher code. And if the name, email and phone number column is empty for any voucher code. Then only the html form data should go.

Please help me regarding this.

Thank you

Top comments (0)

Where Infrastructure Meets Innovation

Where Infrastructure Meets Innovation

Learn how to break the IaC security loop using pre-approved modules and tagged remediation to automate safe, scalable vulnerability fixes in this session at IaCConf on Wednesday August 27, 2025.

Join the Virtual Event

👋 Kindness is contagious

Take a moment to explore this thoughtful article, beloved by the supportive DEV Community. Coders of every background are invited to share and elevate our collective know-how.

A heartfelt "thank you" can brighten someone's day—leave your appreciation below!

On DEV, sharing knowledge smooths our journey and tightens our community bonds. Enjoyed this? A quick thank you to the author is hugely appreciated.

Okay