Transform Data

If you want to do more in your workplace, and you might probably try the Transform features. Though is kind of advance mode but we still keep things simple and easy. So let's dive in how it might help you.

Let say you want to fill all the rows by numbers. Manually typing might get you fingers hurt, specially if you already had hundreds of row. This trick might help you. Just select a column, select the "Transform", in " Array Command" enter this code and leave the row as 0.

Then start executing the code. Voila!

What if you just want to start in a specific row and end in a row? Just run the same command but this time, input the start row number to the row textbox.

What if you just want to set a date for all row? Try to modify the command into something this

CREATED(08/04/2022)

You need to MM/DD/YYYY format the execute the code.

What if you just want to start in a specific row and end in a row? Just run the same command but this time, you need to modify some format. For command you need to add the word you need use and the start row number. Looks like this format

FILLSTOP(AVOCADO,5)

And to end that command in a specific row, just set the end row number in a row textbox.

You need to include first the word you need to replace (Avocado) and next the value that will replace (BANANA).

What if you just want to replace a specific value with an empty? Just run the same command but this time, you need to modify some format. For command you need to add the word you need use and use the "" or leave it nothing. That will serve as empty. Looks like this format

REPLACE(AVOCADO,"") or REPLACE(AVOCADO,)

Let say you want to sum a total of the entire data. Manually calculating them might get you brain hurt, specially if you already had hundreds of row. 

Note: This only work if the column is using Number data types.

Duplicating row features already added to our interface, you don't need to run the code anymore, you can easily use them from the row settings. However in case you just need to try, this command works and to identify the row were trying to clone, just enter that row number into row textbox.

Duplicating column features already added for our interface, you don't need to run the code anymore, you can easily use them in column settings. However in case you just need to try, this command works and to identify the row were trying to clone, just enter that column number into row textbox.

Are you wonder when the specific row created? Let say it was added via form or a collaborator, you can easily figure that out by running this code.

Thinking to uppercase all of your data?, you can easily figure that out by running this code. Just leave the row as 0 for default.

Thinking to lowercase all of your data?, you can easily figure that out by running this code. Just leave the row as 0 for default.

Thinking to generate a random string with combination of numbers and letters?, you can easily figure that out by running this code. Just leave the row as 0 for default.

Thinking to generate a random string with combination of letters only?, you can easily figure that out by running this code. Just leave the row as 0 for default.

Thinking to generate a random string with combination of numbers only?, you can easily figure that out by running this code. Just leave the row as 0 for default.

Thinking to join value from Column1 and Column 2 with a special character separator, you can easily figure that out by running this code.

Supported Separator: *.,$%&*#@+_=*

Thinking to encode your value using base64 you can easily figure that out by running this code. Just leave the row as 0 for default. Decode is not yet available, however you can encode it on your application end if your using an API for your data.

You might encounter some data compatibilities in some cases. You can file a bug here.