melinda's blog

Copy and paste the code below and execute it in your "master" Database in SSMS. The video above will demonstrate where the "master" is.
 

sp_configure 'contained database authentication', 1;  
GO  
RECONFIGURE;  
GO

I have a quiz that allows to user to take the quiz 3 times and if they don't pass on the third time, they don't get a certificate at the end of the course.
The counts reset when the user passes the quiz.

//Counts the clicks

$("a[href]:not([href*='"+window.location.host+"']):not([href^='/']):not([href*='volleyball'])").on("click",l)}

If the URL contains "volleyball' in it, the leaving site lightbox warning does not come up and the user is redirected to the site.

If you are trying to using Power Automate and following "I Am Lu" s Tutorial and you get a Bad Gateway error in your power automate. The Key was not made correctly. I am not sure if it is because I am on a Mac and Lu is on a Windows but if you want the flow to connect to AWS then run the below command in your terminal to get the correct SSH Key.

ssh-keygen -m PEM

The key should start with:

-----BEGIN RSA PRIVATE KEY-----

To add the condition for the Admin token flow here> https://powerautomate.microsoft.com/en-us/blog/automate-flow-governance/

Condition Basic Edit does not exist anymore for you would do this instead.

In the first condition field put an expression containing:

@or(equals(items('Apply_to_each_2')['Operation'], 'CreateFlow'),equals(items('Apply_to_each_2')['Operation'], 'EditFlow'))

in the second field put in an expression containing:

Ran into this issue and the simple answer wasn't too easy to find.

GO into you view

Go to the "PAGER" section (in the middle)

1. First copy and paste the confirmation twig template for webforms in the webforms module.

Then add a div to the twig template like this.

<div id="learning-objective-data">  </div>

In the div place your webform submission data token for the field you would like to grab

{{ webform_submission.data.Your Webform Field }} 

So it looks like this:

<div id="learning-objective-data">
{{ webform_submission.data.question1 }} 
 </div>

<div class="summary">
 {% set text = content.body['#object'].body.summary|render %}
{{ text|length > 80 ? text|slice(0, 80)|raw ~ '...' : text|raw }}
{% set text = content.body['#object'].body.summary|render|striptags %}
{{ text|length > 80 ? text|slice(0, 80) ~ '...' : text }}
      
  </div>

Recreating the process that's on our site.

 Create Media type for the Colorbox image.
 a. Add media type
b. I named mine Lightbox image
c. Media Source
d. Media source configuration = -Create - 
e. Field mapping- I only used "Name" as "Name"
f. Publish options = "Published" is ticked
g. Click the sprocket and change the image size to what suits you
h. sAve