Skip to main content

Posts

Quickly navigate to active cells and ranges with the new range name box in Google Sheets

  Google is adding a range name box, located to the left of the formula bar, to improve navigation in Google Sheets. Previously, active cells were only indicated by a blue outline and could be located by scrolling or using the arrow keys. Now, you can use the range name box to jump directly to coordinates and named ranges in a sheet.  Additionally, this box provides a drop-down menu to easily access, manage, and create new named ranges in the sheet.  There is no admin control for this feature. There is no end user setting for this feature. The new range name box can be found at the left of the formula bar.  Rapid Release domains: Full roll-out (1–3 days for feature visibility) beginning on January 19, 2021  Scheduled Release domains: Gradual roll-out (up to 15 days for feature visibility) January 25, 2021  Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, and Enterprise Plus, as well as G Suite Basi

Loading complex CSV files into BigQuery using Google Sheets

  Building an ELT pipeline using Google Sheets as an intermediary BigQuery offers the ability to quickly import a CSV file, both from the web user interface and from the command line: bq load --source_format CSV --autodetect \ mydataset.mytable ./myfile.csv0 Limitations of autodetect and import This works for your plain-vanilla CSV files, but can fail on complex CSV files. As an example of a file it fails on, let’s take a   dataset of New York City Airbnb rentals data  from Kaggle. This dataset has 16 columns, but one of the columns consists of pretty much free-form text. This means that it can contain emojis, new line characters, Indeed, try to open this file up with BigQuery: 01 bq load --source_format CSV --skip_leading_rows 1 \ 02 advdata.airbnb_nyc_2019 AB_NYC_2019.csv \ 03 id:string,name:string,host_id:string,host_name:string,neighbourhood_group:string,neighbourhood:string,latitude:float,longitude:float,room_type:string,price:float,minimum_nights:integer,number_of_reviews

New option to block devices with basic management from accessing your organization’s data

  Google is adding the ability for admins to manually block or unblock mobile apps from accessing their organization’s Google Workspace data on Android and iOS devices with basic mobile management. These actions can be automated using device management rules (for supported editions).  Previously, admins had a limited set of actions they could perform with basic management—they could wipe an account or delete the device from inventory. However, they couldn’t block apps on those devices from accessing organizational data in the way that they could for devices with advanced mobile management. This launch makes that possible, helping to keep your organization’s data secure.  While the blocking action is the same for devices with basic and advanced management, advanced management allows you to proactively block devices based on the Require Admin Approval setting. With basic management, you can only do this on a per-device basis.  Admins: This feature will be available by default. To use it,

An Introduction to Apigee Edge

 

New tools to troubleshoot network and performance issues in Google Meet

  Google has added tools in Google Meet that makes it easier for end users to understand how their local desktop and network environments affect meeting quality. During a call, you can now go to the three-dot menu and select “Troubleshooting and Help” to see:  CPU load and network stability over time  Time segments highlighted when the local environment likely affects the call quality  Suggested actions to help improve call performance  Real-time feedback on the effect of any action taken on network and processing load  Tips for performing common tasks, like presenting content and recording meetings  Meet shares processing power and network connections with all other applications and browser tabs running on a computer. When the system is overusing its processing power or suffering from a bad network connection, Meet will try to adjust and maintain performance while consuming less resources. Some of those adjustments are less visible, but if resource shortages are severe or persistent,

State of no-code app-development

  It’s no secret that the world is changing faster than ever. Before 2020 became, well,  2020 ,  businesses knew that digital transformation was critical , yet few were prepared to make the pivot.  The events of last year caused a forcing function, accelerating the need for change in organizations around the globe. Problem solving required a  democratized approach to the tools of innovation , one in which anyone in the workforce, whether skilled in coding or not, could leverage technology to create novel solutions. The solution stacks businesses were working with needed to be rethought.  Though we typically associate app creation with traditional developers who write code, hundreds of thousands of apps were built this year by non-technical “citizen developer” app creators from around the globe. This democratization occurred because industries such as retail, construction, manufacturing, hospitality, telecom, education, real estate, IT services and more all sought digital transformation

Join a meeting with new options on the Google Meet landing page

Google is changing the options for a more tailored experience when Google Workspace users join or start a meeting from meet.google.com. When you click “New meeting,” you’ll now see the following three options:  Create a meeting for later: Generate joining information for a new meeting. You can save this information to use later. Start an instant meeting: Join a meeting in one click, without first going to the Meet greenroom. Once in the meeting, you can add others or copy the joining information to share. Please note, your camera and microphone will be on automatically if you select this option. You can turn them off once in the meeting. Schedule in Google Calendar: Go to Calendar in a new tab to create an event with Meet conferencing details automatically populated. Users will still be able to enter a meeting code or nickname to join a meeting. There is no admin control for this feature. There is no end user setting for this feature.  Rapid release domains - Gradual roll out  (up to 1

Why work with a Google Premier Partner? - Finetech Consultancy (Pvt) Ltd.

Close Partnership with Google The close and strong relationship with Google helps Finetech to always stay updated on the newest technology as well as incorporate best business practices to our strategies and procedures. This will help our organization to convey the knowledge and provide state of the art solutions to customers. A Google Certified and experienced team Finetech consists of experienced Google Workspace and GCP professionals who are bearers of Deployment and Sales Engineers certifications. Finetech considers recruiting highly qualified professionals or training employees to become GCP and Google Workspace professionals in order to provide the best solutions to the customer. Finetech has also achieved a Google partner expertise in work transformation, financial services and Google Meet due to the impressive team of professionals. Smooth Migration Migrating to Google with Finetech is easy and effortless as the team knows the precautions of avoiding  pitfalls. To maintain