Translate your Enterprise apps in 1 second

I must have seen dozens of implementations of this exact same web app during my 25 years as an Enterprise developer. And to be honest with you, I'm tired of implementing the exact same app, over and over again. "Don't reinvent the wheel" comes to mind. Hence, I decided I wanted to create a "micro service web app", providing me with all translation features I could possibly need in the future. And more interestingly, I will create the entire app, in 1 second, by simply clicking a button. If you don't believe me, feel free to watch the following YouTube video, where I demonstrate how I solve all my translations needs, for the rest of my life, in 1 second.

The SQL script I am starting out with can be found below.

How to Enable Third-party Cookies in Google Chrome

The newer versions of Google Chrome block third-party cookies by default. Cookies are considered “bad” as they are mostly used for tracking users on the Internet but some cookies serve a useful purpose as well.

For instance, a GSuite add-on may open a small sidebar inside Google Sheets and this sidebar may need to communicate with other windows that are opened by the same add-on. Since the windows are on different domains, the only way for them to communicate with each other is through third-party cookies.

This video explains why some third-party cookies are necessary and how you can selectively allow cookies inside Google Chrome.

GSuite add-ons including Document Studio, Form Notifications and Mail Merge require you to enable third-party cookies in your browser to save user preferences and settings.

Allow Third-party Cookies for GSuite

Here are step-by-step instructions on how to enable third-party cookies in your Google Chrome browser. This will only allow cookies for GSuite add-ons in Google Sheets, Form, Docs, and Google Sides.

Step 1: Open Google Chrome browser, click the settings menu in the top right (3 vertical dots).

chrome settings menu

Step 2: Click the “Privacy and Security” option in the settings pane.

Settings Privacy

Step 3: Expand the “Cookies and other site data” section under the Privacy and Security page.

Block Third-party cookies

Step 4: The “Block third-party cookies” setting should be selected to continue blocking all cookies except those served by GSuite add-ons.

GSuite addon cookies

Step 5: Click the “Add” button under the section that says “Sites that can always use cookies” and enter the domain https://[*.]googleusercontent.com in the input box.

allow third party cookies

Click the “Add” button, reload your Google Form or Google Sheet and the addon will continue to work as before.