echo $row->id in Group Member Email?

  • Brian F
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
10 years 6 months ago #69155 by Brian F
echo $row->id in Group Member Email? was created by Brian F
Hi. I've added the below QR Code to all my email templates so that when scanned it will link to the specific registrant's edit form. The edit form is password protected and is being used at the event's door to scan and to select "Yes" for a "Checked In" custom field in the form.

All the email templates are working as needed, except for the Group Member email template (email_group_member_detail.php); it's not echoing the "$row->id". The $row->id is pulled in the other templates. Is it much work to adjust the email_group_member_detail.php so that it can echo the $row->id as it does in the "email_individual_detail.php" email?

Code:
<img src='https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=https://www.MyDomain.com/index.php?option=com_eventbooking%26task=edit_registrant%26id=<?php echo $row->id; ?>%26Itemid=147'>

Thanks!

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago #69166 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic echo $row->id in Group Member Email?
Hi Brian

You can use $rowMember->id instead of $row->id and it should work well

Also, could you please describe exactly how you use these QRs code in the real life so that I can understand it and find a way to add better support for it in the extension?

Regards,

Tuan
The following user(s) said Thank You: Brian F

Please Log in or Create an account to join the conversation.

  • Brian F
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
10 years 6 months ago #69191 by Brian F
Replied by Brian F on topic echo $row->id in Group Member Email?
Hi Tuan, thanks a bunch for the weekend reply! Ah, I see the $rowMember now in the group details, that pulls the group member row value just as needed.

The ideal interface would be:
Have a "Attended" false/true(0/1) core field that's hidden to the registrant but maybe visible when editing to allow for manual changing. And there's a barcode (and QR code?) in the email (ticket) that when scanned will auto-update the table field to true for that specific registrant. Would be nice as well to be able to enter in the barcode number (or such) into a form to manually validate the check in.

I didn't have a lot of time to spend on this, and plan to work more on it later to automate it when scanned (currently all manual), but the clunky way I currently have it is:

I've created a radio "Checked In" Yes/No custom field with "No" as the default value and assigned it to all events right below the core fields, and am hiding it from the public using CSS - tried first having it as a Registered access but with it not being visible to the registrant it doesn't save the default "No" value; so I hid it and have it visible when editing.

I have my QR code included at the bottom of each email template that links directly to the edit form; with a note right above it saying: "The below QR Code will be used to access the event. Print this page or keep this email on your phone to show at the event:"

We're using iPads (and iPhones) at the door with the i-nigma QR Reader app that directs the URL directly to Safari, instead of using a built-in browser as other QR Readers do. The person working the front door will log into the site via the front-end using a "Registrants Admin" access group I set up that has access to the Registrants List and able to add/edit. They'll scan the code, it'll go to the registrant's entry edit form, they'll choose "Checked In: Yes" radio, then save, taking them back to the Registrants List.

It'd be preferred however for the front-door worker to not have to log into the site and manually make that change every time, but instead when scanned that it auto-updates the field value to true.

Please let me know if you have specific questions regarding how I'm doing our process. I can PM you examples as well if needed.

Thanks again for your rapid reply!

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago #69227 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic echo $row->id in Group Member Email?
Thanks Brian. I think it is quite clear. Will invest sometime to improve it soon :)

Tuan
The following user(s) said Thank You: Brian F

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc