Formulas
Name
Formula Type
First Name
Last Name
Extract First Name
replace(prop("Name"), "[ ].*", "")
Extract Last Name
replace(prop("Name"), ".*[ ]", "")
Hidden Answer
if(prop("Reveal") == false, replaceAll(prop("Answer"), "[A-z]", "+"), prop("Answer"))
Correct
prop("Type Answer") == prop("Answer") or prop("Override") == true
Extract Handle
replace(replace(prop("URL"), "/status/.*", ""), ".*.com/", "")
Extract Publication
"§ " + replace(replace(prop("URL"), ".*//", ""), ".com.*", "") /* ALTERNATIVE */ replace(replace(prop("URL"), ".*//", ""), "[.].*", "")