Can you keep a secret?

Explore

Back Office

Step by Step Guides

Guides that explain complex workflows step-by-step.

Step by Step

Step by Step

Group

Step Num

Title

Overview + Steps

Additional Info

Sample Steps to Include

Sample

BTN Select Step

BTN f Select Step

CHK Selected Step

Step #

Notice

Nav

Formula

BTN Show Formula

BTN f Show Formula

Selected by Users

Convert Secret’s characters to numbers

The

Char Mapping

⁠

table stores each available character and assigns it a unique number. We use this table with Coda’s Filter() formula to map each individual character to a number.

We split the user’s Secret up into individual characters, then map each to a number.

We do the same with the user’s Password.

Secret: H e y t h e r e !

Conv to numbers: 51 74 94 1 89 77 74 87 74 2

Password: P a s s w o r d P a

Conv to numbers: 59 70 88 88 92 84 87 73 59 70

Select Step

⁠

Step 1

⁠

Step #1

Use these to walk through the steps 👇

⁠

Step 1

⁠

Show Formula

Shift each number to the right

We shift each letter of Secret over by a number of places. The number of places to shift by is determined by the user’s Password.

We then loop through the list of numbers from the user’s Secret one by one.

For each number, we find the corresponding number from Password, that’s at the same index in that array.

We add each pair up of numbers to produce a third array of numbers in the Summed column.

💡 If the password is shorter in length than the secret, we just repeat the password it until we have enough characters. Here’s what I mean:

Secret. My super long secret

Password. PasswordPasswordPass

Secret: H e y t h e r e !

Conv to numbers: 51 74 94 1 89 77 74 87 74 2

Password: P a s s w o r d P a

Conv to numbers: 59 70 88 88 92 84 87 73 59 70

Summed: 110 144 182 89 181 161 161 160 133 72

Select Step

⁠

Step #2

⁠

Step 1

⁠

Show Formula

Fix Summed “out of bounds” numbers

Each number in Summed will be converted into a character to produce the final encrypted text.

It’s therefore important that we make sure each number is “in bounds”, meaning that each number has a matching character in

Char Mapping

⁠

To do this, we use Coda’s FormulaMap() formula, which allows us to loop through arrays and process each item individually.

For numbers that are too high, we reduce each by 96 (the number of rows in our character mapping table).

This adjusted array of numbers can be seen in Adjusted Summed alongside.

For example, the first character, H maps to the number 51.

Its corresponding character in the password is P which maps to 59.

When we sum these up, we get 110.

110 is out of bounds because we only have 96 rows in the character mapping table.

To fix this, we subtract 96 which gives us 14.

Secret: H e y t h e r e !

Conv to numbers: 51 74 94 1 89 77 74 87 74 2

Password: P a s s w o r d P a

Conv to numbers: 59 70 88 88 92 84 87 73 59 70

Summed: 110 144 182 89 181 161 161 160 133 72

Adjusted Summed: 14 48 86 89 85 65 65 64 37 72

Select Step

⁠

Step #3

⁠

Step 1

⁠

Show Formula

Convert Adjusted back to characters

Finally, we convert each number in the Adjusted Summed array back to a character and Join() them together to produce the final Encrypted text.

Decryption

To decrypt our secret later on, we follow the same steps we’ve just run through, but instead of summing the password’s values, we subtract the password character’s value from the corresponding value of each character in the encrypted text.

Numbers that are zero or lower are adjusted to be “in bounds” by adding 96.

Secret: H e y t h e r e !

Conv to numbers: 51 74 94 1 89 77 74 87 74 2

Password: P a s s w o r d P a

Conv to numbers: 59 70 88 88 92 84 87 73 59 70

Summed: 110 144 182 89 181 161 161 160 133 72

Adjusted Summed: 14 48 86 89 85 65 65 64 37 72

Encrypted: \ W q x h Y H G E u

Select Step

⁠

Step #4

⁠

Step 1

⁠

Show Formula

⁠

Step by Step - Samples

Step by Step - Samples

Group

Index

Sample

Secret: H e y t h e r e !

Conv to numbers: 51 74 94 1 89 77 74 87 74 2

Password: P a s s w o r d P a

Conv to numbers: 59 70 88 88 92 84 87 73 59 70

Summed: 110 144 182 89 181 161 161 160 133 72

Adjusted Summed: 14 48 86 89 85 65 65 64 37 72

Encrypted: \ W q x h Y H G E u

Encrypted Text. GdQ[>(3Q!p/??5NZN>0\edi>\+ap8@],=~ju}-/cs

Guessed Secret. Username

(we'll focus on the orange text with the same number of chars as the word "Username" which we expect is the start of the user's Secret text)

GdQ[>(3Q → 50 73 60 24 21 09 37 60

Username → 64 88 74 87 83 70 82 74

Subtract → -14 -15 -14 -63 -62 -61 -45 -14

Adjusted → 84 83 84 35 36 37 53 84

Decoded → J o n o 1 2 3 J

Secret: Hey there!

Conv to numbers: 51 74 94 1 89 77 74 87 74 2

Password: P a s s w o r d P a

Conv to numbers: 59 70 88 88 92 84 87 73 59 70

Summed: 110 144 182 89 181 161 161 160 133 72

Adjusted Summed: 14 48 86 89 85 65 65 64 37 72

Encrypted: \ W q x h Y H G E u

⁠

Gallery

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.