Back Office
Step by Step Guides
Step by Step Guides
Guides that explain complex workflows 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
Simple Security
4
1
Convert Secret’s characters to numbers
The 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.
0
2Secret: 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
2
3
4
Show Formula
2
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.
💡 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
0
3Secret: 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
2
Step #2
Step 1
2
3
4
Show Formula
3
Fix Summed “out of bounds” numbers
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.
0
4Secret: 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
3
Step #3
Step 1
2
3
4
Show Formula
4
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.
0
5Secret: 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
4
Step #4
Step 1
2
3
4
Show Formula
Breaching Simple
5
Strong Security
1
Step by Step - Samples
Group
Index
Sample
Simple Security
5
1
Secret: H e y t h e r e !
Conv to numbers: 51 74 94 1 89 77 74 87 74 2
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
3
Summed: 110 144 182 89 181 161 161 160 133 72
4
Adjusted Summed: 14 48 86 89 85 65 65 64 37 72
5
Encrypted: \ W q x h Y H G E u
Breaching Simple
5
1
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)
2
GdQ[>(3Q → 50 73 60 24 21 09 37 60
Username → 64 88 74 87 83 70 82 74
3
Subtract → -14 -15 -14 -63 -62 -61 -45 -14
4
Adjusted → 84 83 84 35 36 37 53 84
5
Decoded → J o n o 1 2 3 J
Strong Security
5
1
Secret: Hey there!
Conv to numbers: 51 74 94 1 89 77 74 87 74 2
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
3
Summed: 110 144 182 89 181 161 161 160 133 72
4
Adjusted Summed: 14 48 86 89 85 65 65 64 37 72
5
Encrypted: \ W q x h Y H G E u
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.