ie 11 history folder

C:\Users\user\AppData\Local\Microsoft\Windows\History

history is hidden so just write it out

md5 in js

here 

pip in modern python

if you download latest you will automatically get pip
the path is set with the install
so in cmd window type whatever -  pip install requests - for example and that should work

failover vs failback

here 

destructuring in js

arrays

[x,...y] = [1,2,3,4,5,6]

[1, 2, 3, 4, 5, 6]

x

1

y

[2, 3, 4, 5, 6]

 objects

var x2 = {name:"herby",amount:23423,happy:true,getStatus:function(){return this.name + (this.happy?" is happy":" isnt happy" )  }}

/with renaming variable

var {name:newname, getStatus:getit} = x2;

console.log(newname); //herby

console.log(getStatus); // function etc

Calculated Column logic

lets say you have a date column date1
you can have logic as follows

if(columna = "hello",Today(),"")

this should really fail because "" is not a date
it doesn't fail, but access for example will come up with #error

 lets say I want to keep the null



if(columna = "hello",Today(),date1)

this fails because of circular logic

if(columna = "hello",Today(),null)
if(columna = "hello",Today(),blank)

these are also not correct syntax

if(columna = "hello",Today())

that works but updates the column with a 0 which SharePoint shows incredibly as a 0

calculated columns in sharepoint

calculated columns (misnomer? they are real columns) update upon insert and update of the row. now , if you update the formula, sharepoint will show the new result but the underlying data will still be based on the old formula (you can see this in access linked table for example). he data will only really change when you do an update on the row