Answers.Body: <p>I don't know where it is in the database, but on the Online registration tab of each event after installing the module I now have that selection and the token is available to use in emails.</p>
  <p><a href="https://i.sstatic.net/iGSVw.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/iGSVw.png" alt="screen shot showing Enable QR code" /></a></p>
  <p><a href="https://i.sstatic.net/AkCqu.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/AkCqu.png" alt="QR code token in Mosaico template" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-05-03T23:49:28.977Z
Answers.Text: One note - we had to make a change to the extension to fix the URL for updating an Attendee status from Registered to Attended. (Next thing after getting the code to show up). https://github.com/progressivetech/net.ourpowerbase.qrcodecheckin/issues/28
Answers.UserDisplayName: kathc
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-05-04T09:36:17.367Z
Answers.Text: Yeah, the token is available in some emails, but it seems that this is not the case in System workflow message templates
Answers.UserDisplayName: emma
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-05-05T12:09:44.883Z
Answers.Text: I used Mosaico templates to include the token (with the Mosaico message templates extension) https://civicrm.org/extensions/mosaico-message-templates.
Answers.UserDisplayName: kathc
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-05-03T23:44:42.097Z
Answers.LastActivityDate: 2023-05-03T23:44:42.097Z
Answers.UserDisplayName: kathc
Body: <p>I installed the &quot;QR Code Checkin&quot; Extension in CiviCRM 5.58.1 with Drupal. When I create a new event, I can activate &quot;enable qr code token for this event&quot;.
  Now, I want to update my event registration confirmation email text (custom System workflow message template for events): I want to check if the QR Code token is enabled for this event, and if yes, include the QR Code.
  So I think I need to access the &quot;enable qr code token for this event&quot; variable via the API (Smarty).</p>
  <p>Does anybody know how I can access this variable via API/Smarty? Or where the QR Code Extension stores this variable in the database?
  I checked in the table <code>civicrm_event</code> but couldn't find this variable. There is no other table having sth like &quot;token&quot; in the name except &quot;payment token&quot;.
  Any hint is appreciated.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-04-28T12:55:34.123Z
Comments.Text: Could you specify which extension you are referring to and maybe also your CMS and CiviCRM version? There is for example "QR Code Checkin" (https://civicrm.org/extensions/qr-code-checkin) and "Event Checkin" (https://docs.civicrm.org/eventcheckin/en/latest/)
Comments.UserDisplayName: Fabian
Tags: <civievent><extension><api>
Title: Where does the QR Code Extension store the value "enable qr code token for this event" in Database?
ThreadText: # Where does the QR Code Extension store the value "enable qr code token for this event" in Database?
  
  (Asked by: username_0 on 2023-04-28)
  
  I installed the "QR Code Checkin" Extension in CiviCRM 5.58.1 with Drupal. When I create a new event, I can activate "enable qr code token for this event".
  Now, I want to update my event registration confirmation email text (custom System workflow message template for events): I want to check if the QR Code token is enabled for this event, and if yes, include the QR Code.
  So I think I need to access the "enable qr code token for this event" variable via the API (Smarty).
  
  Does anybody know how I can access this variable via API/Smarty? Or where the QR Code Extension stores this variable in the database?
  I checked in the table `civicrm_event` but couldn't find this variable. There is no other table having sth like "token" in the name except "payment token".
  Any hint is appreciated.
  
  **Tags:** civievent, extension, api
  
  > **Comments:**
  > **username_1**: Could you specify which extension you are referring to and maybe also your CMS and CiviCRM version? There is for example "QR Code Checkin" (https://civicrm.org/extensions/qr-code-checkin) and "Event Checkin" (https://docs.civicrm.org/eventcheckin/en/latest/)  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2023-05-03. Score: 0
  
  I don't know where it is in the database, but on the Online registration tab of each event after installing the module I now have that selection and the token is available to use in emails.
  
  [![screen shot showing Enable QR code](https://i.sstatic.net/iGSVw.png)](https://i.sstatic.net/iGSVw.png)
  
  [![QR code token in Mosaico template](https://i.sstatic.net/AkCqu.png)](https://i.sstatic.net/AkCqu.png)
  
  > **Comments:**
  > **username_2**: One note - we had to make a change to the extension to fix the URL for updating an Attendee status from Registered to Attended. (Next thing after getting the code to show up). https://github.com/progressivetech/net.ourpowerbase.qrcodecheckin/issues/28  
  > **username_0**: Yeah, the token is available in some emails, but it seems that this is not the case in System workflow message templates  
  > **username_2**: I used Mosaico templates to include the token (with the Mosaico message templates extension) https://civicrm.org/extensions/mosaico-message-templates.  
  
  ---
  
  