Join us on Wednesday 21st July at 16:00 BST for a free webinar where we will be focussing on Smartsheet Data Collection: Forms.

During the demonstration we will cover the basics, and show you how to create a standard form, including how to: 

• Capture new data and update an underlying Smartsheet.
• Update the field properties by adding labels and help.
• Set layout options and default values.
• Adjust security settings, automated responses and design theme to make the user experience as straightforward as possible.  

We’ll also explore the Conditional Logic area where you can show only the fields, *headings or *dividers that are relevant.

Chief Smartsheet Solutions officer Debbie Sawyer will also present a run down on how you can use helper columns within forms to provide a set of dropdown values that relate to previous responses within the form, creating the appearance of conditional dropdown list values.

Clients are often asking us, “How can we use forms to UPDATE rows in Smartsheet?”  Smartsheet offers an Update Request function, however Update Request forms are not customisable. 

We have helped our clients resolve this issue by creating an updating form including conditional logic, by embedding webform technology into a Smartsheet solution.  Our CTO Dr James Harris will demonstrate how this is achieved and discuss the scope of possibilities this technology can bring. Read our case study on how we helped tech giant, Sony Electronics, with a bespoke webform solution.

As always, our team of experts will be monitoring the chat window and answering any questions raised within the demonstration allowing time for Q&A afterwards too.

We can’t wait to see you there!

Register now for Wednesday July 21st at 16.00 BST.

And don’t forget, you can Subscribe to our regular Tips & Tricks emails and get alerted about our latest Webinars. Subscribe to our YouTube channel too and keep up to date with our latest solutions and past Webinars.

*Exciting NEW features!

The post Smartsheet Data Collection: Forms. appeared first on SmarterBusinessProcesses.

When it was first introduced in 2010, the Quick Response code didn’t make much of an impact. While slick, easy data gathering might have been be appealing, not enough of us had the Smartphone technology to make it work. For those of us who did give QR a try, it required downloading a third party app, by which time you could have just found the link online.   

Today QR code creation is common place and every day practice in most businesses and communities.

What did QR stand for?

A quick-response code is a type of two-dimensional matrix barcode, invented in 1994, by Japanese company Denso Wave originally for labelling automobile parts. 

What is a QR code?

A barcode is a machine-readable optical image that contains information specific to the labelled item. In practice, Quick Response codes contain data for a locator, an identifier, and a website visitor tracking. To efficiently store data, QR codes use four standardized modes of encoding (i) numeric, (ii) alphanumeric, (iii) byte or binary, and (iv) kanji.

Creating a QR code

A Quick Response code consists of black squares arranged in a square grid on a white background, including some fiducial markers, which can be read by an imaging device such as a camera, and processed using Reed–Solomon error correction until the image can be appropriately interpreted.

The required data is then extracted from patterns that are present in both horizontal and vertical components of the image.

The spread of the QR code applications

The QR labelling system was applied beyond the automobile industry due to its fast readability and greater storage capacity compared to standard UPC barcodes. Creating QR codes was easy. Applications include product tracking, item identification, time tracking, document management, and general marketing

QR Codes in the time of Covid-19

During the Covid-19 pandemic, however, these codes came into regular use and in fact became a reliable source of data.

While the Track and Trace app has by no means had a smooth, controversy-free implementation (Excel Spreadsheet columns anyone?) it demonstrates the versatility of this type of code. With every shop and cafe asking us to point and click we’re really starting to see just how accessible it can be.

QR Use Cases

Today QR codes have become common in all areas of commerce and society, from consumer advertising, tracking in product stock taking, to supply chain management.

Typically, a smartphone is used as a QR code scanner, displaying the code and converting it to some useful form (such as a standard URL for a website, thereby obviating the need for a user to type it into a web browser).

QR code has become a focus of advertising strategy, since it provides a way to access a brand’s website more quickly than by manually entering a URL.  Not only is it super convenient to the consumer, the importance of this capability also increases the conversion rate and the chance that contact with the advertisement converts to a sale.

Now everything is automated. Instead of taking you to a third party website, the app collects all the information it needs in one simple step, and lets you go back to sanitising your cat or doing whatever it was you were doing before you had to zap the code with your mobile phone. So easy! 

This tech hasn’t just become slicker either. It can now be implemented at a fraction of what it used to cost. This makes it a total game changer, especially for anyone who needs to report progress or gather data while out on site. Find out how QR codes can drive efficiency in your business in our Appsheet with Smartsheet blog, or watch a quick demo below on how we can make it work for you.

The post #DRAFT_On the up: The Rise and Rise of QR Codes appeared first on SmarterBusinessProcesses.

When it was first introduced in 2010, the Quick Response code didn’t make much of an impact. While slick, easy data gathering might have been be appealing, not enough of us had the Smartphone technology to make it work. For those of us who did give QR a try, it required downloading a third party app, by which time you could have just found the link online.   

Today QR code creation is common place and every day practice in most businesses and communities.

What did QR stand for?

A quick-response code is a type of two-dimensional matrix barcode, invented in 1994, by Japanese company Denso Wave originally for labelling automobile parts. 

What is a QR code?

A barcode is a machine-readable optical image that contains information specific to the labelled item. In practice, Quick Response codes contain data for a locator, an identifier, and a website visitor tracking. To efficiently store data, QR codes use four standardized modes of encoding (i) numeric, (ii) alphanumeric, (iii) byte or binary, and (iv) kanji.

Creating a QR code

A Quick Response code consists of black squares arranged in a square grid on a white background, including some fiducial markers, which can be read by an imaging device such as a camera, and processed using Reed–Solomon error correction until the image can be appropriately interpreted.

The required data is then extracted from patterns that are present in both horizontal and vertical components of the image.

The spread of the QR code applications

The QR labelling system was applied beyond the automobile industry due to its fast readability and greater storage capacity compared to standard UPC barcodes. Creating QR codes was easy. Applications include product tracking, item identification, time tracking, document management, and general marketing

QR Codes in the time of Covid-19

During the Covid-19 pandemic, however, these codes came into regular use and in fact became a reliable source of data.

While the Track and Trace app has by no means had a smooth, controversy-free implementation (Excel Spreadsheet columns anyone?) it demonstrates the versatility of this type of code. With every shop and cafe asking us to point and click we’re really starting to see just how accessible it can be.

QR Use Cases

Today QR codes have become common in all areas of commerce and society, from consumer advertising, tracking in product stock taking, to supply chain management.

Typically, a smartphone is used as a QR code scanner, displaying the code and converting it to some useful form (such as a standard URL for a website, thereby obviating the need for a user to type it into a web browser).

QR code has become a focus of advertising strategy, since it provides a way to access a brand’s website more quickly than by manually entering a URL.  Not only is it super convenient to the consumer, the importance of this capability also increases the conversion rate and the chance that contact with the advertisement converts to a sale.

Now everything is automated. Instead of taking you to a third party website, the app collects all the information it needs in one simple step, and lets you go back to sanitising your cat or doing whatever it was you were doing before you had to zap the code with your mobile phone. So easy! 

This tech hasn’t just become slicker either. It can now be implemented at a fraction of what it used to cost. This makes it a total game changer, especially for anyone who needs to report progress or gather data while out on site. Find out how QR codes can drive efficiency in your business in our Appsheet with Smartsheet blog, or watch a quick demo below on how we can make it work for you.

The post On the up: The Rise and Rise of QR Codes appeared first on SmarterBusinessProcesses.