gid | gid is a script that adds , commits , and pushes

I have started to create a form with Apps Script, using materializecss to create a menu with 3 different layouts.

1. when I embed my URL to the New Google Sites, it doesn't use the layout (modal), I need to know how to select one of the 3 sidebar options.
2. After submit, the form data is posted to the spreadsheet, but it doesn't redirect to a different page.
3. it seems it will redirect without validating data, the if sentence is not connected to the redirect function.

...

I have just started using Docker as it has been recommended to me as something that makes development easy, but so far it has been nothing but pain. I have installed docker engine (v20.10.12) and docker composer (v 2.2.3) as per the documentation given by docker for Ubuntu OS. Both work as intended.

Whenever I new up a new container with docker compose, no matter the source, I have writing privilege issues to files generated by the docker container (for example a laravel application where I have used php artisan to create a controller file). I have so far pinpointed the issue to be as follows:

By default docker runs as root within the container. It "bridges" the root user to the root user on the local machine and uses root:root to create files on the Ubuntu filesystem (my workspace is placed in ~/workspace/laravel). Then when opening the files in an IDE (vscode in this instance) I get the error:

...

This is what i get after i use ddev start on new or any other projects. I clear all docker images, volumes, etc... and problem repeats again...

Does anybody has the same problem, does it have any connection with versions:

• Docker version 20.10.11
• Docker Compose version 2.2.0
• ddev version v1.18.0

...

I am currently writing a Google Apps Script inside a Google Sheet to read data from a list of spreadsheets (spreadsheet url is provided by the user). However, I cant seems to find a way to check if the url is valid or if user have access to the spreadsheet or not before calling SpreadsheetApp.openByUrl().

I have written the following code to "validate" the url:

...

I am following this guide to add Docker support to my existing NextJS + TypeScript project and deploy to Google Cloud Run: https://github.com/vercel/next.js/tree/canary/examples/with-docker.

However, the build your container step:

...

I have multiply taps in one sheet A, each tap has 5000+ rows, some rows have the same content and want to find specific rows, while entering content and copy those rows which are matching to a different sheet B and keep the formatting etc from sheet A.

Example: I need to make a shipping/order list I have 2 sheets Sheet A is full of information (my stockload), multiply tabs with a lot of rows in each tab. in Sheet B (new URL) I want to filter the information.

Lets say, I have 5000 articles spread in 5 tabs on Sheet A, someone is ordering 20 articles, so I just want to scan the EAN or any other code on that article to Sheet B, and all rows with that data, will be imported. Now I have a brand new list with only the 20 articles, which I can share to the client.

I have tried with script:

...

I'm wondering how to inverse the font color of a cell's value based on the background color automatically to make it readable.

I've used the following script to get the background color automatically set upon pasting hex color codes into given cells How do I change a cell to the color of the hexadecimal value of a cell in Google Spreadsheets?, with sample sheet here

...

I am trying to send email using sidekiq but it's not working. Here is how i setup sidekiq with ActiveJob

Gemfile

...

I need to group rows in a dataset based on a rowwise comparison or matching of four different variables in a way that it can be computed fast. The dataset has the following shape:

id start start_sep end end_sep 1 A 1 F 1 2 B 0 G 0 3 D 1 H 0 4 D 1 J 0 5 E 0 K 0 6 F 1 L 0 7 A 1 O 0 8 H 0 P 0 9 A 1 P 1

Specifically, I would like to group those rows that share the same value in either start<>end, end<>start, start<>start, or end<>end and have a matching value (>0) in the related start_sep and end_sep column. start_sep and end_sep are basically an additional check if the first match is correct. Groups usually contain matches of two rows, but can be of any number in size if a rows start and end matches more than one. Matches are always unique, so there won't be a matching conflict of two rows with the same matching start and end combination.

Here is a little illustration of potential match combinations in the columns 'start' and 'end':

For the example above, the expected result would be:

id start start_sep end end_sep group_id 1 A 1 F 1 1 2 B 0 G 0 NA 3 D 1 H 0 2 4 D 1 J 0 2 5 E 0 K 0 NA 6 F 1 L 0 1 7 A 0 O 1 3 8 O 1 P 0 3 9 A 1 P 0 1

In this sense matches can occure within a row

I can do this with a slow for loop and a set of conditions, ie., selecting a row (if group_id is NA) finding all matches (based on conditions describing possible match combinations) and asign group_id. But since my dataset has 1 million plus rows, this is a very slow process. See below an example for a single case example below:

...