Welcome to Trichometrading

Welcome to Trichometrading

We are happy to introduce with another successful project Trichometrading.

Trichome Trading is a Barcelona based company which operates in the flower and seeds industry.
We are developing a strong and sustainable sales platform to trade the best products in the industry.

Visit Trichometrading web page here.


Launching website for Barber Shop in Copenhagen

Launching website for Barber Shop in Copenhagen

We are happy to introduce with another successful project A/A Barber Shop.

A / A Barber Shop is the legend of the traditional barber shop in the heart of Denmark’s capital Copenhagen. You will be transported for a swift time from the moment you enter nostalgic dark style barber with its antique leather chairs and black and white photography adorns the walls. They offer professional care services that focus on traditional techniques but are designed to fit the modern gentleman. A/A Barber Shop services include everything from a straight razor knife to shaving trim and whiskey sampling to start. Sip on some of the world’s finest while devoting yourself to a new makeup. Whether you’re looking for a stylish, modern look or something from old days, their educated and highly talented shavers will help you achieve the look you’re looking for. A/A Barber Shop know there’s nothing worse than getting a cut that does not look like what you’ve asked for. Therefore, they take the time to be aware of what you want and deliver the best possible results. You will let our chips feel like a million dollars and ready to conquer almost everything. Not that you did not before. Vintage shave uses A/A Barber Shop professional set of tools to ensure high quality precise cuts. You know what they are saying they just do not do things they usually do. A/A Barber Shop specialists also use high quality products that can be purchased at the store.

Visit A/A Barber Shop web page here.


Insert images into Google Spreadsheets

Today we are going to explore Google Sheets. As some of you may not know Google Sheets, same as Google Slides are a word processor, a spreadsheet and a presentation program respectively, all part of a free, web-based software office suite offered by Google within its Google Drive service. Many people just know and like to call Google Sheets similar as Excel, but respectively laying on the internet and for free. Normally in order to setup a project and start working with Google Sheets all the users are required to have a google account. We are not going to start it from the basics, but rather focus on tricks and tips that can significantly increase the efficiency or simply save time.

Insert images into Google Spreadsheets:
This is going to be our subject in this post and we will try to explain how this feature works on google spreadsheets application.

Normally, when people try to insert image from the “menu options” or just trying to drag it from their desktop, application fails to display the image visual part. Here we are meeting very common issue, that many people struggle to solve. We will show some basic Google spreadsheets rules, that will give you a full understanding of how it works, same as you will also later have a great opportunity to try it yourself.

 

Google image function
Function for image display

 

Basic function “=IMAGE” together with valid image URL (image you would like to display) allows you to insert image inside a cell and display it visually. You can also control aspect ratio, what allows you to change size of the image in accordance to the height of the cell.

 

Basic Examples:
=IMAGE(“URL”) – Original image ratio fitted in the height of the cell
=IMAGE(“URL”,2) – Image is stretched to fit all edges of the cell
=IMAGE(“URL”,3) – Image retains its original ratio
=IMAGE(“URL”,4,50,50) – Including image options for manually changing ratio. You simply need to try changing 50,50 for the next preferred result.

 

Display of Google Spreadsheet images
Displayed images in Google Spreadsheets

 

For more advanced users we would like to share experience of how to also display images that are uploaded on google drive. Normally, it can be quite a headache to figure it out, but we know the way of how to help you. As far as we could experience google drive functionality together with Google spreadsheets, this function sample below is the only way to directly display images in the Google Spreadsheet cell. This URL structure is 100% reliable and fully dependable of id which is missing in the sample. ID is always unique and must be taken from the uploaded image URL on your google drive application. Once you have done it and combined it with the function example we provided you with, you must be able to see your result immidialtely in the selected cell area.

=image(http://drive.google.com/uc?export=view&id=*********************)

 

In case you are very advanced and familiar of how to setup Google Spreadsheets and Google Scripts, we also consider it mutual to have a script which can do a automated Google drive results directly in the preferred Google Spreadsheet just by simply pressing “run this script” function. See full function overview below:

 

Script editor example
Google Script editor example


function listFilesInFolder(folderName) {

var sheet = SpreadsheetApp.getActiveSheet();
sheet.appendRow([“Name”, “Date”, “Size”, “URL”, “Download”, “Description”, “Image”]);

var folder = DriveApp.getFolderById(“************”);
var contents = folder.getFiles();

var cnt = 0;
var file;

while (contents.hasNext()) {
var file = contents.next();
cnt++;

data = [
file.getName(),
file.getDateCreated(),
file.getSize(),
file.getUrl(),
“http://drive.google.com/uc?export=view&id=” + file.getId(),
file.getDescription(),
“=image(\”https://docs.google.com/uc?export=download&id=” + file.getId() +”\”)”,
];

sheet.appendRow(data);
};
};

This script will generate you all uploaded images on selected Google drive folder including its Name, Date, Size, URL, Download URL, Description and Image visual.

 

Google Script editor results
Google Script editor results in Google Spreadsheets

 

As normally we recommend to try it yourself for full understanding. Best way to learn is to try and see how it works.

We hope you liked our post and feel free to get in contact or write comments if you have any questions.

Kind regards,
Woxygen marketing team