Update Google Sheet with typescript
To be able to programmatically update Google Sheets, we need to enable the APIs and Service in Google Cloud Platform. Create a new Google Cloud project Enable the Google Sheet API
Apply Imported Fill Color is not available in Lucid Charts
To display dynamic data on Lucid Charts. we can link Google Sheets to Lucid Chart objects. The Pull fill color from Google Sheets section of the Lucid documents explain how to set the color of an object based on the cell color, but does not mention one…
Configure Epson ET-3850 scanning on Windows 11
Install the Epson ET-3850 scanner driver and scanning utility Connect to the Epson ET-3850 scanner Scan with the Epson ET-3850 scanner
GIMP moves the wrong layer
When you try to move a layer with a transparent logo or text in GIMP, sometimes the background layer moves. By default the Move Tool selects the layer of the dragged pixel regardless of which layer is selected. The tool only selects the correct layer if…
ReferenceError: json is not defined
Remix uses the loader function to provide a behind the scenes API for the browser side script to supply data in JSON format. The function should return serialized data using the json instruction. When you get the error message: ReferenceError: json is…
Initial url (undefined) does not match URL at time of hydration
React web applications pre-render the pages during application build for faster display and “hydrates” them with the client side javascript to make them interactive and to display data. This error can have causes: Initial url (undefined) does…
Rotating pizza stone for the Ooni Koda 12 pizza oven
Pizza is awesome, we have never found anyone who does not like it. The Ooni Koda 12 gas fired pizza oven can fully bake a 12 inch pizza in 3 minutes, but we need to rotate it every 20-30 seconds to bake it evenly and avoid burning it on one side. The…
How to convert PostgreSQL array column to scalar column type
If your PostgreSQL database table contains “timestamp with time zone []” or “timestamp without time zone []” type columns and you want to convert them to “timestamp with time zone” or “timestamp without time…
TypeError: Cannot destructure property ‘…’ of ‘useLoaderData(…)’ as it is null.
React web applications (Next.js, Remix) use React hooks to transfer data between the server side and browser side code. Remix uses the loader() function to run code on the server to produce data for the web page, and the instruction in the browser…
Migrating a Next.js web application to Remix
Application configuration At this point Remix version 1 is “forward compatible”. It already contains the version 2 features, and you can start to use them before the official release. To enable the version 2 features in version 1 Migration…