teleren/devto huggingface dataset:
Understanding the working of Dynamic Forms with Google Sheets
Tags: webmethods, integration, connectors
Published: 2021-12-07 10:24:23

---
title: Understanding the working of Dynamic Forms with Google Sheets
published: true
date: 2021-12-02 15:53:14 UTC
tags: #webmethods, #integration, #connectors
canonical_url: https://tech.forums.softwareag.com/t/understanding-the-working-of-dynamic-forms-with-google-sheets/253668
---

Dynamic Forms make it easier to work with actions that expect data for custom fields. In this article, we will understand how to use the Dynamic Forms feature in a Google Sheets action, with the help of an example.

Let’s say, you want to create a workflow that adds a new row to Google Sheets each time a note in created in Evernote. To do this, follow the steps given below:

Step 1: Add and configure ‘Evernote - New Note’ trigger

[![image](https://aws1.discourse-cdn.com/techcommunity/optimized/3X/8/a/8a619f6f2d54ce871a06d436a507cfc5ecae3ed2_2_505x375.png)](https://aws1.discourse-cdn.com/techcommunity/original/3X/8/a/8a619f6f2d54ce871a06d436a507cfc5ecae3ed2.png "image")

Step 2: Drag the “Google Sheets” connector to canvas and select the ‘Add Rows’ action from the actions dropdown.

Step 3: Select action ‘Add Rows’. Select/add relevant authorization for your Google Sheets account and click Next.

[![image](https://aws1.discourse-cdn.com/techcommunity/optimized/3X/5/0/506185b21241a5718be9f8ab579177403c551ee9_2_517x203.png)](https://aws1.discourse-cdn.com/techcommunity/original/3X/5/0/506185b21241a5718be9f8ab579177403c551ee9.png "image")

On the action configuration page, select Spreadsheet from Spreadsheet ID and Sheet Name dropdown respectively. As soon as you enter the required fields, [webMethods.io](http://webMethods.io) Integration will automatically fetch the headers of all columns of the specified sheet in the configuration window. See the below image.

[![image](https://aws1.discourse-cdn.com/techcommunity/optimized/3X/4/a/4a9eab9d9a7ada35abc7ff77af63a828b2280c2a_2_517x268.png)](https://aws1.discourse-cdn.com/techcommunity/original/3X/4/a/4a9eab9d9a7ada35abc7ff77af63a828b2280c2a.png "image")

You can then add/enter the relevant values for each of these columns. You can keep a column blank if you don’t want to provide value for it. This makes it easy for you to add rows to your Google Sheets spreadsheets.

Once you have entered all the required details, click on “NEXT” test the action, and click on ‘DONE’ to return to the canvas. Our workflow is ready to use.

[![image](https://aws1.discourse-cdn.com/techcommunity/optimized/3X/5/7/579113203b1de70a7f90f0bf764a99fef64a7675_2_517x125.png)](https://aws1.discourse-cdn.com/techcommunity/original/3X/5/7/579113203b1de70a7f90f0bf764a99fef64a7675.png "image")

[Read full topic](https://tech.forums.softwareag.com/t/understanding-the-working-of-dynamic-forms-with-google-sheets/253668)
Day 1 - Advent of Code 2021 Solution
Tags: javascript, webdev, beginners, programming
Published: 2021-12-02 15:51:31

Basically this article is based on a YouTube video in which I am going to share you a solution of **Day 1 - Advent of Code 2021**

{% youtube cLEOH6aWHqU %}
To participate in [Advent of Code ](https://adventofcode.com/)
Fastify: How to gather usage /process metrics and send to StatsD
Tags: node, javascript, webdev, monitoring
Published: 2021-12-02 15:35:30

Hey 👋

Are you using [Fastify](https://www.fastify.io/) in your Node.js applications and Statsd Daemon to gather metrics?

Then we've got your back! We've recently released a plugin that may help you: [fastify-metrics](https://github.com/immobiliare/fastify-metrics)! 🚀

👨‍💻 What you'll get

- Automatic collection of Node.js process metrics;
- Routes hit count, timings, and errors;
- Less time coding telemetry and more creating your cool charts on Grafana (or wherever)!



Check it out on Github and let us know what you think! 
Don't forget to leave a ⭐️ if you liked it 🙏

https://github.com/immobiliare/fastify-metrics
Crazy Codigo - Haven't Heard That Name in a While...
Tags: python, programming, computerscience, career
Published: 2021-12-02 15:30:37

Hey guys! I guess we're on DEV now. 

So, for those of you who know us from our YouTube or Instagram, you already know that we keep promising new content and then, disappearing for 2 months straight. But, this time, we intend to set the bar reasonably low and put out 2 DEV articles each month (and yes, we will see this one through).

And for those of you who have never heard of us, hi! I am J and I run Crazy Codigo with A - my best friend, biggest cheerleader and soon-to-be roommate. 

What follows is our Crazy Codigo journey so far, future goals and much more. Read along...


![LOGO](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/nz90rppmlnwuy06y4nhh.jpeg) 

**A:** Hi....uh... I'm the awkward one in the duo. 
**J:** Clearly
**A:** _Awkward cricket noises_
**J:** Alright so, we started off Crazy Codigo in June, 2021 because we thought it would motivate us to actually complete some of the endless projects we keep taking up. How's that one working out?
**A:** Obviously not. We are still taking up new projects and not finishing them but let's pretend like that's not happening.
**J:** Yeah minor inconvenience. Nothing we can't move past :)

**A:** We started off as a YouTube channel. Our first video was us trying to convert a .py file to an .exe only to realize that we had kind of forgotten to make an output screen and our code was just terminal based. 
**J:** That video was exported in 480p and still exists on our YouTube channel. Check it out if you want -

[First Video](https://youtu.be/Eg2BFuEKgls)

![Thumbnail](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/l8gh0gw308a21m35vqcy.jpeg)

**J:** From that we went on to discover GitHub, 1080p exports, online college and DEV.
**A:** Also, just in case you're wondering, online college sucks. But we're going to get into that in a whole new video we have planned for you guys. Coming sometime this month. 
**J:** Yep. So, lookout for new notifications from our YT channel and head over to the link below to connect with us on many more platforms.

[LinkTree](https://linktr.ee/crazycodigo)
![LinkTree](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/t3obu6k1ddxtl7uvq2y2.png)
 

**A:** That's about it for this one. We'll see you soon with something new.
**J:** Cya.
What is ETL and why it’s so important?
Tags: etl, cloud, database, programming
Published: 2021-12-02 15:28:20

## What is ETL?
ETL stands for Extraction, Transform, and Load

ETL is a process that extracts the data from different source systems, then transforms the data (like applying calculations, concatenations, etc.), and finally loads the data into the Data Warehouse system. The full form of ETL is Extract, Transform and Load.

```
Here is a fully dedicated video on the ETL Process 👇👇👇👇👇
```

[![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/mmw8qygzibda4avcdtvl.jpg)](https://www.youtube.com/watch?v=Awq_zZsoXmQ&t=35s)


## Why do you need ETL?
ETL tools break down data silos and make it easy for your data scientists to access and analyze data, and turn it into business intelligence. In short, ETL tools are the first essential step in the data warehousing process that eventually lets you make more informed decisions in less time.




### ▬▬▬▬▬▬ WANT TO LEARN MORE? ▬▬▬▬▬▬

Full Terraform tutorial ► [https://bit.ly/2GwK8V2](https://bit.ly/2GwK8V2)
DevOps Tools, like Ansible ► [https://bit.ly/3iASHuP](https://bit.ly/3iASHuP)
Docker Tutorial ► [https://bit.ly/3iAT9Jx](https://bit.ly/3iAT9Jx)
AWS Tutorial ► [https://bit.ly/3iAT9Jx](https://bit.ly/30GFv1q)
GCP Tutorial ► [https://bit.ly/3mwh412](https://bit.ly/3mwh412)
Jenkins Tutorials ► [https://bit.ly/3iHnfv4](https://bit.ly/3iHnfv4)
Jenkins Pipeline ► [https://bit.ly/30CJGLB](https://bit.ly/30CJGLB)
Python ► [https://bit.ly/3I7bewU](https://bit.ly/3I7bewU)
Python in just 1 video ► [https://bit.ly/3EeqGVy](https://bit.ly/3EeqGVy)
Automating tasks using Microsoft Teams in webMethods.io Integration
Tags: webmethods, connectors
Published: 2021-12-06 09:28:29

---
title: Automating tasks using Microsoft Teams in webMethods.io Integration
published: true
date: 2021-12-02 15:22:37 UTC
tags: #webmethods, #connectors
canonical_url: https://tech.forums.softwareag.com/t/automating-tasks-using-microsoft-teams-in-webmethods-io-integration/253667
---

Microsoft Teams is a collaboration app that helps your team stay organized and have conversations—all in one place. [webMethods.io](http://webMethods.io) Integration has a Microsoft Teams connector which helps you post message on a channel whenever there is any event happening in any service.

You can connect Microsoft Teams with over 200+ connectors from [webMethods.io](http://webMethods.io) Integration

**Lets try creating a workflow using Microsoft Teams connector**

**Workflow name:** When a new incident is created in Pagerduty get notified on Microsoft Teams

- Go to [webMethods.io](http://webMethods.io) Integration and create a new workflow.

- In workflow select Pagerduty connector and select trigger event “New Incident”.

- For the trigger event, select existing or create a new connection, and select Service from the dropdown.

1. Now select Microsoft Teams connector from the connector palette on right hand side. And select action “Send Message to Channel”. Select existing or create a new auth.  

2. On action configure page, you can map the values from previous trigger, and click on Next and then Done.

Then your workflow is ready to use.

[![image](https://aws1.discourse-cdn.com/techcommunity/optimized/3X/1/3/1325386c30d42524d995f1ea65754f10e3c467a2_2_517x134.png)](https://aws1.discourse-cdn.com/techcommunity/original/3X/1/3/1325386c30d42524d995f1ea65754f10e3c467a2.png "image")

Check out a list of triggers and actions which are available for Microsoft teams in [webMethods.io](http://webMethods.io) Integration in the original article in the [Software AG Tech Community](https://tech.forums.softwareag.com/t/automating-tasks-using-microsoft-teams-in-webmethods-io-integration/253667).
Heard about web.dev from Google?
Tags: webdev, css, javascript, html
Published: 2021-12-02 15:02:53

I might be wrong but I think this product from google should get more attention from the general public who are trying to get into web development but are scrambled to get the basics right. This website has a collection of exactly that.

Never saw this before until I stumbled upon it in [Google Developers Products](https://developers.google.com/products).
As seen in the image, The bottom right one should take you to [web.dev](https://web.dev/).

Once you head over there you'll realize that there's a Huge collection of courses that should get your basics for Web development strong and further help you improve and make the right decision with your websites.
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/7pjb89tgg05yu7bvvpvi.png)

At first I thought to myself that this might actually be some sort of paid course but they are all absolutely free and each of them are few minutes of read with appropriate code snippets inside them to help you understand the concepts.

Something like this
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/l6vfxq2ed0r88s8mgxo7.png)

Maybe its worth a shot to check it out yourself :smile:
How To Easily Create Cool Progress Bar in Your Web App?
Tags: frontend, javascript, react, css
Published: 2021-12-02 14:54:43


![Mohmed Ishak](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/czyaipxp33ebktswrfuc.png)
Hello, devs! Do you see the picture above? That blue line is a progress bar. It tells you how much if a web app has loaded or not. It is not super important for a web app, but it really helps you to retain user's attention while the page loads for a second or two. So, how do you create that?

Of course, we're gonna use a package because someone else worked hard already to implement this, so why not use it? The package is called [NProgress](https://www.npmjs.com/package/nprogress). In this article, I'll teach you how to implement it using Next.js, but if I'm sure you'll be able to implement it in other technologies such as plain React and so on. 

###Step 1
Install NProgress package with this command:
```javascript
npm install nprogress
```

###Step 2
In any main file such as _app.js (Next.js devs would know), just import these stuffs I've imported (refer code snippet below). Then, inside your component, paste the first three lines which I wrote under `function JustAComponent() { ...`
```javascript
import nprogress from "nprogress";
import Router, { useRouter } from "next/router";

function JustAComponent() {
  Router.onRouteChangeStart = () => nprogress.start();
  Router.onRouteChangeComplete = () => nprogress.done();
  Router.onRouteChangeError = () => nprogress.done();

// ...
}
```

###Step 3
Now it's time to style your progress bar. Add a file called `nprogress.css` in your codebase and link your app to it. In my case, since I'm using Next.js, I connected that CSS file using the link tag.
```javascript
<link rel="stylesheet" type="text/css" href="/nprogress.css" />
```

###Step 4
If you copy and paste the code snippet below, you'll be able to see the exact bar which I shared at the very top of this article, but feel free to play around with it and change stuffs like color, width of progress bar, etc.
```css
#nprogress {
  pointer-events: none;
}

#nprogress .bar {
  background: var(--progressBar);
  position: fixed;
  z-index: 1031;
  top: 0;
  left: 0;
  background-color: #3943b7;
  width: 100%;
  height: 5px;
}

#nprogress .peg {
  display: block;
  position: absolute;
  right: 0px;
  width: 100px;
  height: 100%;
  box-shadow: 0 0 10px var(--progressBar), 0 0 5px var(--progressBar);
  opacity: 1;
  -webkit-transform: rotate(3deg) translate(0px, -4px);
  -ms-transform: rotate(3deg) translate(0px, -4px);
  transform: rotate(3deg) translate(0px, -4px);
}
```

Done. If you like this article, all I need is just a like. :)
What I did learn from Scrimba Js Course
Tags: javascript, beginners, tutorial
Published: 2021-12-02 14:51:24

After been taking some time from coding Js I needed to go back to the fundamentals. 

I started to build a blackjack with help from the tutorial and did learn how to work with math.floor() and math.random().

What is The Math.floor() its a method that rounds a number down to the nearest integer, and returns the result.And Math.random() method returns a random number from 0 (inclusive) up to but not including 1 (exclusive).
 
Both of them have a value can be important too generate Auth and also be used in Casino games and etc


Here is a code example:



 ```js
function getRandomCard() {
  // if 1     -> return 11
  // if 11-13 -> return 10
  let randomNumer = Math.floor(Math.random() * 13) + 1;
  if (randomNumer > 10) {
    return 10;
  } else if (randomNumer === 1) {
    return 11;
  } else {
    return randomNumer;
  }
}
    ```
5 easy tips for writing C# better
Tags: csharp, dotnet, programming, productivity
Published: 2021-12-02 14:50:47

Even if you are late with the project timeline or due date, it's important to write good code.
Writing code is not easy and this is the reason why you have to write a more readable and elegant code as you can.

Let's see some small syntax tips.

## 1. Reduce lines of unuseful code

Bad
```csharp
public ActionResult Index()  
{  
    return View();  
}  
```
Good
```csharp
public ActionResult Index() => View();
```
OR

Bad
```csharp
if (!string.IsNullOrEmpty(yourVar))  
{  
    //your code  
} 
```
Good
```csharp
if (yourVar is { Length: > 0 })
{
    //your code
}
```
## 2. Primitive data type validation
Avoid custom method to validate primary type. 99% of primary types has their own validation type.
```csharp
public bool CheckIfIsNumberic(string value) => int.TryParse(value, out int _);
```

## 3. Use conditional operator
When possible, to improve the readability of the code, use the ternary condition.
They help to read the code after a long period.

Bad
```csharp
public static string CheckFirstName(User user)
{
	var defaultFirstName = "Default";

	if (user.Name != null)
	{
		return user.Name;
	}
	else
	{
		return defaultName;
	}
}
```
Good
```
public static string CheckFirstName(string name) => name ?? "Default";
```

4. Naming Conventions 
Find your rules and be consistent in every projects.
Simple name for a single object, add the suffix List for multiple objects.

```csharp
var item = new Item();
var items = new List<Item>();
```
 
```csharp
var item = new Item();
var items = new List<Item>();
```

Try to follow the table below:
![](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/urdrnjv06scgy1uvswa4.png)

## 5. Optimizing Queries with LINQ
LINQ is very powerful to query objects in C# but it should be a bottleneck about the performances or, maybe in the worst case, for readability.

This code works, but try to take a look to the best version below this one
```csharp
public List<Article> GetArticlesByPrice(double price)
{
	var articlesList = new List<Article>();

	foreach (Article article in Articles)
	{
		if (article.Price< price)
		{
			articlesList.Add(article);
		}
	}

	return articlesList;
}
```
This is better:
```csharp
public List<Article> GetArticlesByPrice(double price)
{
	var articlesList = new List<Article>();

        IEnumerable<Article> lambdaArticles = Articles.SelectMany(c => c.Articles).Where(p => p.Price < 100);
	articlesList  = lambdaArticles.ToList();

        return articlesList;
}
```

## Conclusion
Feel free to share your tips in the comments and I will update my blog!
AWS re:Invent 2021 — A first look at the SageMaker Training Compiler
Tags: aws, transformers, deeplearning, compilers
Published: 2021-12-03 08:10:55

---
title: AWS re:Invent 2021 — A first look at the SageMaker Training Compiler
published: true
date: 2021-12-02 14:47:05 UTC
tags: aws,transformers,deeplearning,compilers
canonical_url: https://julsimon.medium.com/aws-re-invent-2021-a-first-look-at-the-sagemaker-training-compiler-3b6372286e5f
---

### AWS re:Invent 2021 — A first look at the SageMaker Training Compiler

In this new video, I demo the newly launched [SageMaker Training Compiler](https://docs.aws.amazon.com/sagemaker/latest/dg/training-compiler.html), a feature of SageMaker that can accelerate the training of deep learning (DL) models by up to 50% through more efficient use of GPU instances.

Starting from a couple of sample notebooks based on [Hugging Face](http://huggingface.co) models (BERT and GPT-2), I train both vanilla and compiled jobs, and I compare their performance.

{% youtube UA45V2GplU8 %}
Supercharge your local development with Netlify Dev
Tags: netlify, cli, tools
Published: 2021-12-02 14:44:38

---
title: Supercharge your local development with Netlify Dev
published: true
description: Learn how you can use the Netlify CLI to add utilities to your local dev environment, replicate Netlify's edge logic and routing rules, and improve you local testing and development.
tags: Netlify, CLI, Tools
cover_image: https://www.netlify.com/img/blog/og-feature-ntl-dev.png/
canonical_url: https://www.netlify.app/blog/2021/12/02/supercharge-your-local-development-with-netlify-dev/
series: Netlify - a feature a day 2021
---

> Throughout December we'll be [highlighting a different Netlify feature each day](https://www.netlify.com/blog/2021/12/01/highlighting-a-different-netlify-feature-each-day-in-december/?utm_campaign=featdaily2&utm_source=devto&utm_medium=blog&utm_content=cli-dev). It might just be the thing you need to unlock those creative juices, and [dust off that domain](https://www.netlify.com/blog/2021/12/01/dusty-domains-your-forgotten-domains-raise-money-for-charity/?utm_campaign=featdaily2&utm_source=devto&utm_medium=blog&utm_content=cli-dev) you registered but never deployed! Keep an eye [on the blog](https://www.netlify.com/blog/2021/12/01/highlighting-a-different-netlify-feature-each-day-in-december/?utm_campaign=featdaily2&utm_source=devto&utm_medium=blog&utm_content=cli-dev) and on [Twitter](https://twitter.com/netlify) for each feature!

Ok, Time to get productive!

[Netlify Dev](https://www.netlify.com/products/dev/?utm_campaign=featdaily2&utm_source=devto&utm_medium=blog&utm_content=cli-dev) brings a variety of utilities to your local development environment, and even replicates some of Netlify's edge logic and routing rules available to you for testing and development.

Netlify Dev is available as part of the [Netlify CLI](https://github.com/netlify/cli) which you can install globally on your system with:

```
npm install -g netlify-cli
```

Got that? Great! Lots of goodies await!

Now you can run `netlify dev` in your local project folder and it will automatically:

- Detect and run your site generator
- Serve your site locally
- Make environment variables available (More on those later this month!)
- Performs edge logic and routing rules (More on *those* later this month!)
- Compile and run serverless functions (And more on *those* later this month!)
- ...and more!

## More information

- [Netlify Dev](https://www.netlify.com/products/dev/??utm_campaign=featdaily2&utm_source=devto&utm_medium=blog&utm_content=cli-dev)
- [Netlify Dev documentation](https://docs.netlify.com/cli/get-started/?utm_campaign=featdaily2&utm_source=devto&utm_medium=blog&utm_content=cli-dev#netlify-dev)
- [Netlify CLI](https://github.com/netlify/cli)
INTRODUCTION TO HTML AND CSS.
Tags: html, css
Published: 2021-12-02 14:25:56


*HTML and CSS  are two languages that work together to create everything that we see when we look at something on internet.
       HTML is the raw data that a web is built out of. All the text, links, cards, lists and buttons are created in HTML.


*CSS is used to add styles to those plain elements, give it color, change the font and make it look great.


                                They are not a programming languages because they are only concerned with presenting information.
           Let's take a simple look of differences b/w HTML,CSS and JAVASCRIPT.


~HTML(Hypertext Markup Language): 1. a language that determine,how documents and web pages  
          are displayed.
       2.controls the layout of the content.
       3.provides structure for web page design.
       4.the fundamental building block of any web page.

~CSS(cascading style sheet): 1.a popular style sheet language
                               that determines how document 
                              created in html is styled.
                            2.it adds color, fonts, style to the
                            webpage.
 ~JAVASCRIPT: 1. allows us change CSS and HTML elements on our 
                website.
              2. adds interactivity to a webpage.
              3. handles complex functions and features.


                                                          thank you...........