Emulate radio button behavior from checkboxes

Google Sheet Radio Button from Checkbox



The code sets the number format to @STRING@.

Set konten angka sebagai string di google sheet



The code will display the following toast:


The code will display the following toast:


Info

Info Terakhir

Google Sheet Toast

Tanggal Javascript



This code will look for the row of code that has the value of KodePOD in column G1.

VLookup on Javascript #3



The iterasiArray function iterates through the sourceData array of data and assigns the corresponding code for each item in the array to the kodePO variable. The barisDataPO object stores the current code and the tanggalnya variable stores the date of the corresponding row in the sourceData array.

Iterasi Array Javascript



The code first opens the spreadsheet with the ID '1pEGVc2q32yRCYhPxcl_xHwBfoI_ApgizkpX_4ngorzg' and then iterates through the data in the 'PO' sheet. For each value in the data range D:D, it checks to see if the value in column B is the same as the code dataKodePOD. If it is, the function returns the value of i+1. If the values in column B are not the same, the function logs a message to the logger and returns the value of i+1.

VLookup on Javascript #2

VLookup on Javascript #1



The code uses the getRow() and getColumn() methods of the Range object to get the row and column number of the cell in which the onEdit() function is being called, and then it accesses the sheet object for the sheet the user is currently editing (in this case, it's using the string "Prospek"). It then uses the getRange() method of the Sheet object to get the range of cells that intersect with the cell in which the onEdit() function is being called (in this case, the range starts at row 1 and goes up to row 11). It sets the value of the range's cell at the current date.

Watch edit on google sheet cells

Add menu on google sheet

Filters dataframe for column with specific value and obtains the single value of specified column.

Pandas get single cell value



The code paginates the collection.products collection by 500.

Shopify Pagination >50



The code will first set the variable i to 2. Then, when the user clicks the "trigger" element, the code will create a new "counter" element and will increment i within it.

Increase Value on Click



The code opens the spreadsheet named "sheet" in the current app.

Google Sheet OpenById - Open Different Sheet



The code above will display an alert on the user interface.

Google Sheet Alert



The code appends a row to the sheet containing the following data:

new Date(), waktuEdit, userEmail, 'TEKS', kodePOD

The code first creates a new Date object and stores it in the recordSheet.newDate column. Then it creates a waktuEdit object and stores it in the recordSheet.waktuEdit column. Finally, it stores the userEmail and 'TEKS' values in the recordSheet.userEmail and recordSheet.teks columns, respectively. Finally, the code assigns the kodePOD value to the recordSheet.kodePOD column.

Add new line of data on google sheet



The code clears content from the range B3:B6, sets the value to FALSE in the range A10, and clears content from the range C3.

App script reset cell value on google sheet

time 

react



The export default function ComponentName() function creates a div element.

React fuction


The code defines a function to calculate the count of apples and oranges. The function is written in such a way that it can be read from a string. The input string is split into lines using the "

" character as a delimiter. Each line is read and the following information is stored:

The first number is the number of the apple

The second number is the number of the orange

The third number is the value of the apple

The fourth number is the value of the orange

The fifth number is the total number of apples and oranges

The main() function uses the readLine() function to read in the input string. The input string is split into lines and the following variables are defined:

s - the value of the apples

t - the value of the oranges

ab - the number of apples in the input string

a - the number of oranges in the input string

b - the total number of apples and oranges

mn - the number of oranges in the input string

m - the number of apples in the input string

n - the number of oranges in the input string

Each line in the input string is split on the "



countApplesAndOranges



The code checks whether each element in the list is valid, including the list itself. If any element is not valid, the code will raise a ValueError exception.

validation-patterns

Python hello world

comment


 }

The save() method saves the given Film object to the film repository. The setId() method sets the assigned id for the Film object to the given value.

Christian Proto


The gradingStudent function takes in a grades array as an input and returns an array of grades. The gradingStudent function will look at each grade in the grades array and will compare the grade to 38. If the grade is less than 38, the grade will be pushed into the gradesFinal array. If the grade is 3 or less, the grade will be pushed into the gradesFinal array regardless. If the grade is greater than 3, the grade will be pushed into the gradesFinal array only if it is not less than the current grade in the gradesFinal array. If the grade is less than the current grade in the gradesFinal array, then the grade will be set to the current grade in the gradesFinal array.

gradingStudents

Pandas

Some of the ways on how to view data information in pandas. 


DataFrame Information

django


urlpatterns += path('articles/', views.articles, name='articles'),


The above code declares two urlpatterns. The first one, path('', views.index, name='index'), will be called when no urlpattern is specified. The second one, path('articles/', views.articles, name='articles'), will be called when the articles urlpattern is encountered.


urlpatterns = [


  path('', views.index, name='index'),
  

]

urlpatterns += path('articles/', views.articles, name='articles'),


In the above example, the path('articles/', views.articles, name='articles') will be called when a urlpattern is encountered that matches articles/ in the URL.

URLS DJANGO

 

export function isEmailValid(value) {
  return regex.email.test(value); }
 
export function isUrlValid(value) {
  return regex.url.test(value); }
 
export function isPriceValid(value) {
  return regex.price.

regex2

Creates a pie graph from the data types generated in a pandas DataFrame.

Pie Graph of Data Types



The code first creates a ChromeOptions object, which contains the following two options:

{ "add_experimental_option": "excludeSwitches", "useAutomationExtension": false }

Then, it creates a driver object, specifying the options object as the ChromeOptions object's parameter.

The driver object will use the options specified in the options object to control the behavior of the Chrome browser.

open selenium



This prints "hello world" on your console.

print hello world



In code, we first split the string into two parts, time and part. We then use the index of the PM symbol in the string to change the 12 to 12 PM. If the part of the string is not PM, it is set to the first 12 of the string. We then use the index of the AM symbol in the string to change the 0 to 12 AM. Finally, we join the parts together with a space.

timeConversion


The birthdayCakeCandles() function creates a list of numbers and assigns it to the variable number_candles. The function then loop through the list of candles and checks to see if the candle's number is equal to the max candle number. If the number is equal to the max candle number, the function increases the number_candles variable by one.

birthdayCakeCandles



The code computes the sum of all the positive numbers, the sum of all the negative numbers, and the number 0 (zeros).

plusMInusTwo

plusMInusOne


The following code imports the tkinter module, creates a root widget, and uses the Label() function to create a text-label widget. The widget is given a 30-pixel wide and 10-pixel high border, and is then packed into a tk.Tk object. This object is then used as the mainloop() object in a Python program.

TKinter hello world

Python decorator example



This code will print out the lines found in the file. First, the code opens the file in read mode and then calls the readlines() method on the file handler object to get a list of lines. Next, each line in the list is printed. Finally, the code prints a line that says "lemon's snippet'.

lemon file read


The code above defines a interface named NameComponentProps and exports a function that takes two arguments. The first argument is an instance of JSX.Element and the second argument is an instance of PropsWithChildren .

The NameComponent function takes an instance of FC and returns an instance of PropsWithChildren . The FC class defines a mutable interface that can be used to bind properties to elements. The PropsWithChildren class defines a immutable interface that can be used to bind child elements to properties.

TypeScript React FComponent with children



The echo command displays the string "welcome" on the screen.

starter



This code imports a gzip-compressed BSON document into a Mongodb database on localhost:27017.

MongoRestore


The code imports Context from the ./noteContext directory, initializes State with a Props object, and returns an HTML string that includes a Context.provider element that references state.children, which is an array of objects.

state for context api of react



The code includes the standard input and output library, printf(), and the scanf() function. The program prints "Name?" and then reads in a character and prints it followed by "hello" for the input character.

snippet1

This code uses Polly, RabbitMQ.Client, RabbitMQ.Client.Events, RabbitMQ.Client.Exceptions, Shared.OptionsBinding, System.Net.Sockets, and System.Text.

The Subscriber class is a background service that publishes messages to a RabbitMQ queue. It also handles connection shutdowns and connection failures.

The StartConnection() method starts the RabbitMQ connection and sets up the subscriptions.

The DeclareChannel() method declares the exchange and the queue.

The DeclareQueue() method declares the queue and the exchange.

The QueueBind() method binds the queue to the exchange.

The ProcessEvent() method handles subscription and message processing.

The Dispose() method releases all the resources used by the Subscriber.

Subscriber



Publisher creates a connection to RabbitMQ and initializes a model representing the message queues and exchanges in the broker. It defines a RetryPolicy object, which controls how often Publisher attempts to connect to RabbitMQ. It publishes messages to a queue, using a routing key and a mandatory flag. Finally, it calls Dispose to release the resources used by the Publisher.

Publisher



In this code, the date is in the format "yyyy-mm-dd HH:MM:SS", the time is in the format "HH:MM:SS", the commit is in the format "yyyy-mm-dd <commit-hash>", and the title is in the format " <title> ".

GIT - Log Format customized


The code above sends a POST request to the http://www.example.com/user/create page. The form_params variable contains the data that will be sent with the POST request. The email and name fields are required, while the password field is optional.

guzzle



This code defines two function parameters. The first function parameter is a function that takes an input value as an argument. The second function parameter is a function that sets the input value to the given value.

useState



The code generates a number between 1 and the numbers array's length.

Random with probability



url: "http://data.portic.fr/api/travels"
headers: {'Accept': 'application/json'}
params: {'params': 'travel_id,travel_rank,departure_uhgs_id,departure,departure_latitude,departure_longitude,departure_admiralty,departure_province,destination_uhgs_id,destination,destination_latitude,destination_longitude,destination_admiralty,destination_province,ship_id,ship_name,ship_flag_standardized_fr,tonnage,tonnage_class,outdate_fixed', 'shortenfields': 'false', 'both_to': 'false', 'date': '1787'}
data: {'travel_id': '1668', 'travel_rank': 1, 'departure_uhgs_id': '24999', 'departure': '2017-11-14 14:05:00', 'departure_latitude': 46.5167, 'departure_longitude': -5

Name	Language	Author	Uses
Google Sheet Radio Button from Checkbox	JavaScript	GS Guntar Susatyo	4
Set konten angka sebagai string di google sheet	JavaScript	GS Guntar Susatyo	1
Google Sheet Toast	JavaScript	GS Guntar Susatyo	4
Tanggal Javascript	JavaScript	GS Guntar Susatyo	1
VLookup on Javascript #3	JavaScript	GS Guntar Susatyo	3
Iterasi Array Javascript	JavaScript	GS Guntar Susatyo	5
VLookup on Javascript #2	JavaScript	GS Guntar Susatyo	3
VLookup on Javascript #1	JavaScript	GS Guntar Susatyo	2
Watch edit on google sheet cells	JavaScript	GS Guntar Susatyo	1
Add menu on google sheet	JavaScript	GS Guntar Susatyo	1
Pandas get single cell value	Python	o ottersity	3
Shopify Pagination >50	Ruby	MB Marvin Blach	0
Increase Value on Click	JavaScript	MB Marvin Blach	0
Google Sheet OpenById - Open Different Sheet	JavaScript	GS Guntar Susatyo	0
Google Sheet Alert	JavaScript	GS Guntar Susatyo	3
Add new line of data on google sheet	JavaScript	GS Guntar Susatyo	2
App script reset cell value on google sheet	JavaScript	GS Guntar Susatyo	1
time	Python	TG TOLGA GÜLCAN	3
React fuction	JavaScript	d dirman8	0
countApplesAndOranges	JavaScript	RN Rahman Niftaliyev	0
validation-patterns	Python	NH Nick Howes	0
Python hello world	Python	MB Maggie Basta	0
comment	Java	d dvdobrev	4
Christian Proto	Java	CP Cris Proto	0
gradingStudents	JavaScript	RN Rahman Niftaliyev	0
DataFrame Information	Python	WS Wyx Smrf	0
URLS DJANGO	Python	om oscar muñoz	1
regex2	JavaScript	RN Rahman Niftaliyev	1
Pie Graph of Data Types	Python	WS Wyx Smrf	1
open selenium	Python	SM Stefan Marx	1
print hello world	Python	SM Stefan Marx	1
timeConversion	JavaScript	RN Rahman Niftaliyev	0
birthdayCakeCandles	JavaScript	RN Rahman Niftaliyev	0
plusMInusTwo	JavaScript	RN Rahman Niftaliyev	0
plusMInusOne	JavaScript	RN Rahman Niftaliyev	0
TKinter hello world	Python	a ameyer117	0
Python decorator example	Python	a ameyer117	0
lemon file read	Python	s sxthunder	9
TypeScript React FComponent with children	TypeScript	AU Adan Uri Plata	2
starter	PHP	Fs Faustin samuel	0
MongoRestore	Shell	d dinacea93	0
state for context api of react	JavaScript	SK Sagar Kumar	0
snippet1	C	y yrgdro999	0
Subscriber	C#	CD Chris Dance	1
Publisher	C#	CD Chris Dance	0
GIT - Log Format customized	Shell	DC Daniel Carretero	0
guzzle	PHP	CF Codiga Fan #24465	4
useState	TypeScript	BD Bui Duy	6
Random with probability	JavaScript	a anastasiia-tilikina	0
API request	Python	GG Géraldine Geoffroy	1

Codiga Snippets, page 23