I have the following Google spreadsheet. (they are form data of jotform) In column AQ is a unique code (it is a code read from a QR image from the Jotform form [login to view URL]), and in the AR column there is a link to open the form of the row (open the JOTFORM form to edit)
I want a page template in wordpress: [login to view URL]
that allows me to relate to this spreadsheet of google (or other).
to enter the page an from page scan again any qr from the mobile. The QR will read the code from column AQ, as we know. But I want that instead of reading the QR code open the Jotform link (column AR) of that row.
this will require specifying the link on the spreadsheet (https: //[login to view URL] ...) and the reading (AQ) and redirection (AR) column.
this is for the purpose of checking the data loaded in the spreadsheet.
This is the jotform: [login to view URL]
This is the spreadsheet: https://docs.google.com/spreadsheets/d/1w1t6V3paqoj1EXpIWG-XnqM8OumE7pHePQ1fdvU1jJc/edit#gid=0