[{"_1":2,"_169":-5,"_170":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","ff2b4b5d46c0d41ac97a7ec389dfa57b1b567d3b","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_149":150,"_166":167,"_168":-5},"handle","syncretizm","name","formulaEndpoint","path","main.tsx","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":107,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":114,"_115":107,"_116":-5,"_117":-5,"_118":32,"_14":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":129,"_132":133,"_135":136,"_148":20},"id","d419fc60-26c9-11f0-9439-569c3dd06744","createdAt",["D",1746130873721],"deletedAt","legacyEnvVars",true,"privacy","public","description","imageUrl","085d3104-f117-4a9b-aac0-bf3e690fc39b","pinnedFileId","d41d9f28-26c9-11f0-9439-569c3dd06744","pinPreview","pinMigrated","screenshotVersion","likeCount","7cb049be-7bf9-4335-8abf-3980c82002d6","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_130":131},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yWHllSFJUUWRBUlRFUzRPY1F5VTAzZndTangifQ","org",{"_93":94,"_134":131,"_12":112},"avatar","branch",{"_137":138,"_95":43,"_101":139,"_140":102,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},"version",20,"d41a5930-26c9-11f0-9439-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":151,"_95":98,"_152":114,"_153":-5,"_154":139,"_155":138,"_156":107,"_103":157,"_137":158,"_159":160,"_161":162,"_163":20,"_164":-5,"_97":165},"d4e89868-26c9-11f0-9439-569c3dd06744","fileId","parentId","branchId","branchVersion","latest",["D",1701592820288],19,"fileType","http","content","export async function formulaEndpoint(req) {\n if (req.method !== \"GET\") {\n return new Response(\"Method Not Allowed\", { status: 405 });\n }\n\n // PARSE URL\n const params = new URLSearchParams(req.url.split(\"?\")[1]);\n\n // Extract the method and remove it from the parameters\n const method = params.get(\"method\");\n params.delete(\"method\");\n\n // Initialize an object to store the variables\n const vars = {};\n\n // Iterate through the parameters\n params.forEach((value, key) => {\n if (value) {\n vars[key] = value;\n }\n });\n\n // now params is a dictionary of all the parameters that are not 'method'\n // if params is empty, then we need to respond with an error.\n if (Object.keys(vars).length === 0) {\n return new Response(\"No parameters provided\", { status: 400 });\n }\n\n // the params contain either numbers or strings, depending on the method passed.\n // methods/functions include: add, subtract, multiply, mod, pow, divide, equal, =/=, >, <, >=, <=, and, or, not, xor, nand, nor, xnor, true, false, if_empty, length, contains, test, match, replace, replaceAll, lowercase, uppercase, repeat(#), strip_formatting, min, max, absolute, round, ceiling, floor, squareroot, cuberoot, exponent, ln, log10, log2, now, minute, hour, day, date, week, month, year, dateAdd, dateSubtract, dateBetween, timestamp, fromTimeStamptoDate, formatDate, parseDate, at, first, last, slice, concat, sort, reverse, join, split, unique, includes, find, findIndex, filter, some, every, map, flatten\n // variable types include: number, string, boolean, date, array, object, null, undefined\n // the return type is always a string.\n\n // EXECUTE REQUEST\n let result = null;\n\n // DICTIONARY OF ALL FUNCTIONS, MAX NUMBER OF PARAMETERS, AND ACCEPTED TYPE\n const functions = {\n \"add\": [\"infinite\", \"number\"],\n \"subtract\": [\"infinite\", \"number\"],\n \"multiply\": [\"infinite\", \"number\"],\n \"mod\": [2, \"number\"],\n \"pow\": [2, \"number\"],\n \"divide\": [2, \"number\"],\n \"equal\": [2, \"any\"],\n \"!=\": [2, \"any\"],\n \">\": [2, \"number\"],\n \"<\": [2, \"number\"],\n \">=\": [2, \"number\"],\n \"<=\": [2, \"number\"],\n \"and\": [2, \"boolean\"],\n \"or\": [2, \"boolean\"],\n \"not\": [1, \"boolean\"],\n \"xor\": [2, \"boolean\"],\n \"nand\": [2, \"boolean\"],\n \"nor\": [2, \"boolean\"],\n \"xnor\": [2, \"boolean\"],\n \"true\": [3, \"string\"],\n \"false\": [3, \"string\"],\n \"if_empty\": [1, \"any\"],\n \"length\": [1, \"string\"],\n \"contains\": [2, \"string\"],\n \"test\": [2, \"string\"], // test whether a string contains a substring, the latter of which can be a regular expression\n \"match\": [2, \"string\"],\n \"replace\": [3, \"string\"],\n \"replaceAll\": [3, \"string\"],\n \"lowercase\": [1, \"string\"],\n \"uppercase\": [1, \"string\"],\n \"repeat\": [2, \"string\", \"number\"],\n \"strip_formatting\": [1, \"string\"],\n \"min\": [\"infinite\", \"number\"],\n \"max\": [\"infinite\", \"number\"],\n \"absolute\": [1, \"number\"],\n \"round\": [1, \"number\"],\n \"ceiling\": [1, \"number\"],\n \"floor\": [1, \"number\"],\n \"squareroot\": [1, \"number\"],\n \"cuberoot\": [1, \"number\"],\n \"exponent\": [2, \"number\"],\n \"ln\": [1, \"number\"],\n \"log10\": [1, \"number\"],\n \"log2\": [1, \"number\"],\n \"now\": [1, \"number\"], // receives UTC offset\n \"minute\": [1, \"date\"],\n \"hour\": [1, \"date\"],\n \"day\": [1, \"date\"],\n \"date\": [1, \"date\"],\n \"week\": [1, \"date\"],\n \"month\": [1, \"date\"],\n \"year\": [1, \"date\"],\n \"dateAdd\": [3, \"date\", \"number\", \"string\"],\n \"dateSubtract\": [3, \"date\", \"number\", \"string\"],\n \"dateBetween\": [3, \"date\", \"date\", \"string\"],\n // 'dateRange': [3, 'date'],\n // 'dateStart': [2, 'date'],\n // 'dateEnd': [2, 'date'],\n \"timestamp\": [1, \"date\"],\n \"fromTimestamp\": [1, \"number\"],\n \"formatDate\": [2, \"string\"],\n \"parseDate\": [2, \"string\"],\n \"at\": [2, \"number\"],\n \"first\": [1, \"number\"],\n \"last\": [1, \"number\"],\n \"slice\": [3, \"number\"],\n \"concat\": [\"infinite\", \"number\"],\n \"sort\": [1, \"number\"],\n \"reverse\": [1, \"number\"],\n \"join\": [2, \"string\"],\n \"split\": [2, \"string\"],\n \"unique\": [1, \"number\"],\n \"includes\": [2, \"number\", \"string\"],\n \"find\": [2, \"number\", \"string\"],\n \"findIndex\": [2, \"number\", \"string\"],\n \"filter\": [2, \"number\", \"string\"],\n \"some\": [2, \"number\", \"string\"],\n \"every\": [2, \"number\", \"string\"],\n \"map\": [2, \"number\", \"string\"],\n \"flatten\": [\"infinite\", \"string\"],\n };\n\n // CHECK IF METHOD EXISTS AGAINST FUNCTIONS DICTIONARY\n if (functions[method] === undefined) {\n return new Response(\"Method not found\", { status: 404 });\n }\n\n function extractAndParseDate(dateString) {\n const match = dateString.match(/\\[\\[date:(\\d{4}-\\d{2}-\\d{2})\\]\\]/);\n if (!match) {\n throw new Error(\"Invalid date format\");\n }\n const datePart = match[1];\n const dateObject = new Date(datePart);\n if (isNaN(dateObject.getTime())) {\n throw new Error(\"Invalid date\");\n }\n return dateObject;\n }\n\n // CREATE FUNCTIONS\n function add(vars) {\n let result = 0;\n for (const [key, value] of Object.entries(vars)) {\n result += parseFloat(value);\n }\n return result;\n }\n function subtract(vars) {\n let result = parseFloat(vars[Object.keys(vars)[0]]);\n for (const [key, value] of Object.entries(vars)) {\n if (key !== Object.keys(vars)[0]) {\n result -= parseFloat(value);\n }\n }\n return result;\n }\n function multiply(vars) {\n let result = 1;\n for (const [key, value] of Object.entries(vars)) {\n result *= parseFloat(value);\n }\n return result;\n }\n function mod(vars) {\n let result = parseFloat(vars[Object.keys(vars)[0]]);\n for (const [key, value] of Object.entries(vars)) {\n if (key !== Object.keys(vars)[0]) {\n result %= parseFloat(value);\n }\n }\n return result;\n }\n function pow(vars) {\n let result = parseFloat(vars[Object.keys(vars)[0]]);\n for (const [key, value] of Object.entries(vars)) {\n if (key !== Object.keys(vars)[0]) {\n result **= parseFloat(value);\n }\n }\n return result;\n }\n function divide(vars) {\n let result = parseFloat(vars[Object.keys(vars)[0]]);\n for (const [key, value] of Object.entries(vars)) {\n if (key !== Object.keys(vars)[0]) {\n result /= parseFloat(value);\n }\n }\n return result;\n }\n function equal(vars) {\n let result = vars[Object.keys(vars)[0]];\n for (const [key, value] of Object.entries(vars)) {\n if (key !== Object.keys(vars)[0]) {\n if (result !== value) {\n return false;\n }\n }\n }\n return true;\n }\n function notEqual(vars) {\n let result = vars[Object.keys(vars)[0]];\n for (const [key, value] of Object.entries(vars)) {\n if (key !== Object.keys(vars)[0]) {\n if (result === value) {\n return false;\n }\n }\n }\n return true;\n }\n function greaterThan(vars) {\n let result = parseFloat(vars[Object.keys(vars)[0]]);\n for (const [key, value] of Object.entries(vars)) {\n if (key !== Object.keys(vars)[0]) {\n if (result <= parseFloat(value)) {\n return false;\n }\n }\n }\n return true;\n }\n function lessThan(vars) {\n let result = parseFloat(vars[Object.keys(vars)[0]]);\n for (const [key, value] of Object.entries(vars)) {\n if (key !== Object.keys(vars)[0]) {\n if (result >= parseFloat(value)) {\n return false;\n }\n }\n }\n return true;\n }\n function greaterThanOrEqual(vars) {\n let result = parseFloat(vars[Object.keys(vars)[0]]);\n for (const [key, value] of Object.entries(vars)) {\n if (key !== Object.keys(vars)[0]) {\n if (result < parseFloat(value)) {\n return false;\n }\n }\n }\n return true;\n }\n function lessThanOrEqual(vars) {\n let result = parseFloat(vars[Object.keys(vars)[0]]);\n for (const [key, value] of Object.entries(vars)) {\n if (key !== Object.keys(vars)[0]) {\n if (result > parseFloat(value)) {\n return false;\n }\n }\n }\n return true;\n }\n function and(vars) {\n let result = vars[Object.keys(vars)[0]];\n for (const [key, value] of Object.entries(vars)) {\n if (key !== Object.keys(vars)[0]) {\n result = result && value;\n }\n }\n return result;\n }\n function or(vars) {\n let result = vars[Object.keys(vars)[0]];\n for (const [key, value] of Object.entries(vars)) {\n if (key !== Object.keys(vars)[0]) {\n result = result || value;\n }\n }\n return result;\n }\n function not(vars) {\n let result = vars[Object.keys(vars)[0]];\n return !result;\n }\n function xor(vars) {\n let result = vars[Object.keys(vars)[0]];\n for (const [key, value] of Object.entries(vars)) {\n if (key !== Object.keys(vars)[0]) {\n result = result ^ value;\n }\n }\n return result;\n }\n function nand(vars) {\n let result = vars[Object.keys(vars)[0]];\n for (const [key, value] of Object.entries(vars)) {\n if (key !== Object.keys(vars)[0]) {\n result = !(result && value);\n }\n }\n return result;\n }\n function nor(vars) {\n let result = vars[Object.keys(vars)[0]];\n for (const [key, value] of Object.entries(vars)) {\n if (key !== Object.keys(vars)[0]) {\n result = !(result || value);\n }\n }\n return result;\n }\n function xnor(vars) {\n let result = vars[Object.keys(vars)[0]];\n for (const [key, value] of Object.entries(vars)) {\n if (key !== Object.keys(vars)[0]) {\n result = !(result ^ value);\n }\n }\n return result;\n }\n function trueFunction(vars) {\n // if first var is true, return second var, else return third var\n if (vars[Object.keys(vars)[0]] === \"true\") {\n return vars[Object.keys(vars)[1]];\n }\n else {\n return vars[Object.keys(vars)[2]];\n }\n }\n function falseFunction(vars) {\n // if first var is false, return second var, else return third var\n if (vars[Object.keys(vars)[0]] === \"false\") {\n return vars[Object.keys(vars)[1]];\n }\n else {\n return vars[Object.keys(vars)[2]];\n }\n }\n function ifEmpty(vars) {\n // if var is empty, return string \"True\", else return \"False\"\n if (vars[Object.keys(vars)[0]] === \"\") {\n return \"True\";\n }\n else {\n return \"False\";\n }\n }\n function length(vars) {\n return vars[Object.keys(vars)[0]].length;\n }\n function contains(vars) {\n return vars[Object.keys(vars)[0]].includes(vars[Object.keys(vars)[1]]);\n }\n function test(vars) {\n // test whether first var contains second var\n // second var can be a regular expression\n const regex = new RegExp(vars[Object.keys(vars)[1]]);\n return regex.test(vars[Object.keys(vars)[0]]);\n }\n function match(vars) {\n // match first var to second var\n // second var can be a regular expression\n const regex = new RegExp(vars[Object.keys(vars)[1]]);\n return vars[Object.keys(vars)[0]].match(regex);\n }\n function replace(vars) {\n // replace second var in first var with third var\n // second var can be a regular expression\n const regex = new RegExp(vars[Object.keys(vars)[1]]);\n return vars[Object.keys(vars)[0]].replace(regex, vars[Object.keys(vars)[2]]);\n }\n function replaceAll(vars) {\n // replace all instances of second var in first var with third var\n // second var can be a regular expression\n const regex = new RegExp(vars[Object.keys(vars)[1]], \"g\");\n return vars[Object.keys(vars)[0]].replace(regex, vars[Object.keys(vars)[2]]);\n }\n function lowercase(vars) {\n return vars[Object.keys(vars)[0]].toLowerCase();\n }\n function uppercase(vars) {\n return vars[Object.keys(vars)[0]].toUpperCase();\n }\n function repeat(vars) {\n // repeats a string a given number of times\n let result = \"\";\n for (let i = 0; i < parseInt(vars[Object.keys(vars)[1]]); i++) {\n result += vars[Object.keys(vars)[0]];\n }\n return result;\n }\n function stripFormatting(vars) {\n // removes all formatting from a string\n return vars[Object.keys(vars)[0]].replace(/(<([^>]+)>)/gi, \"\");\n }\n function min(vars) {\n let result = parseFloat(vars[Object.keys(vars)[0]]);\n for (const [key, value] of Object.entries(vars)) {\n result = Math.min(result, parseFloat(value));\n }\n return result;\n }\n function max(vars) {\n let result = parseFloat(vars[Object.keys(vars)[0]]);\n for (const [key, value] of Object.entries(vars)) {\n result = Math.max(result, parseFloat(value));\n }\n return result;\n }\n function absolute(vars) {\n return Math.abs(parseFloat(vars[Object.keys(vars)[0]]));\n }\n function round(vars) {\n return Math.round(parseFloat(vars[Object.keys(vars)[0]]));\n }\n function ceiling(vars) {\n return Math.ceil(parseFloat(vars[Object.keys(vars)[0]]));\n }\n function floor(vars) {\n return Math.floor(parseFloat(vars[Object.keys(vars)[0]]));\n }\n function squareroot(vars) {\n return Math.sqrt(parseFloat(vars[Object.keys(vars)[0]]));\n }\n function cuberoot(vars) {\n return Math.cbrt(parseFloat(vars[Object.keys(vars)[0]]));\n }\n function exponent(vars) {\n return Math.pow(parseFloat(vars[Object.keys(vars)[0]]), parseFloat(vars[Object.keys(vars)[1]]));\n }\n function ln(vars) {\n return Math.log(parseFloat(vars[Object.keys(vars)[0]]));\n }\n function log10(vars) {\n return Math.log10(parseFloat(vars[Object.keys(vars)[0]]));\n }\n function log2(vars) {\n return Math.log2(parseFloat(vars[Object.keys(vars)[0]]));\n }\n function now(vars) {\n // returns current time adjusted to provided UTC offset\n const date = new Date();\n const offset = parseInt(vars[Object.keys(vars)[0]]);\n date.setHours(date.getHours() + offset);\n // format date to ISO 8601\n return date.toISOString().slice(0, 10);\n }\n function minute(vars) {\n // from a given date, returns an integer between 0 and 59 corresponding to the minute of its date argument\n const dateString = vars[Object.keys(vars)[0]];\n const date = extractAndParseDate(dateString);\n return date.getMinutes();\n }\n function hour(vars) {\n // from a given date, returns an integer between 0 and 23 corresponding to the hour of its date argument\n const dateString = vars[Object.keys(vars)[0]];\n const date = extractAndParseDate(dateString);\n return date.getHours();\n }\n function day(vars) {\n // from a given date, returns an integer between 1 and 31 corresponding to the day of its date\n const dateString = vars[Object.keys(vars)[0]];\n const date = extractAndParseDate(dateString);\n return date.getDate();\n }\n function date(vars) {\n // from a given date, returns an integer between 1 and 31 corresponding to the day of its date argument\n const dateString = vars[Object.keys(vars)[0]];\n const date = extractAndParseDate(dateString);\n return date.getDate();\n }\n function week(vars) {\n // from a given date, returns an integer between 0 and 53 corresponding to the week of its date argument\n const dateString = vars[Object.keys(vars)[0]];\n const date = extractAndParseDate(dateString);\n return date.getWeek();\n }\n function month(vars) {\n // from a given date, returns an integer between 0 and 11 corresponding to the month of its date argument\n const dateString = vars[Object.keys(vars)[0]];\n const date = extractAndParseDate(dateString);\n return date.getMonth();\n }\n function year(vars) {\n // from a given date, returns an integer between 0 and 9999 corresponding to the year of its date argument\n const dateString = vars[Object.keys(vars)[0]];\n const date = extractAndParseDate(dateString);\n return date.getFullYear();\n }\n function dateAdd(vars) {\n // accepts date var and adds to it, returning new date, requiring three arguments: date, number, unit (can be years, quarters, months, weeks, days, hours, minutes, seconds, milliseconds)\n const dateString = vars[Object.keys(vars)[0]];\n const date = extractAndParseDate(dateString);\n const number = parseInt(vars[Object.keys(vars)[1]]);\n const unit = vars[Object.keys(vars)[2]];\n if (unit === \"years\") {\n date.setFullYear(date.getFullYear() + number);\n }\n else if (unit === \"quarters\") {\n date.setMonth(date.getMonth() + number * 3);\n }\n else if (unit === \"months\") {\n date.setMonth(date.getMonth() + number);\n }\n else if (unit === \"weeks\") {\n date.setDate(date.getDate() + number * 7);\n }\n else if (unit === \"days\") {\n date.setDate(date.getDate() + number);\n }\n else if (unit === \"hours\") {\n date.setHours(date.getHours() + number);\n }\n else if (unit === \"minutes\") {\n date.setMinutes(date.getMinutes() + number);\n }\n else if (unit === \"seconds\") {\n date.setSeconds(date.getSeconds() + number);\n }\n else if (unit === \"milliseconds\") {\n date.setMilliseconds(date.getMilliseconds() + number);\n }\n return date.toISOString.slice(0, 10)();\n }\n function dateSubtract(vars) {\n // accepts date var and subtracts from it, returning new date, requiring three arguments: date, number, unit (can be years, quarters, months, weeks, days, hours, minutes, seconds, milliseconds)\n const dateString = vars[Object.keys(vars)[0]];\n const date = extractAndParseDate(dateString);\n const number = parseInt(vars[Object.keys(vars)[1]]);\n const unit = vars[Object.keys(vars)[2]];\n if (unit === \"years\") {\n date.setFullYear(date.getFullYear() - number);\n }\n else if (unit === \"quarters\") {\n date.setMonth(date.getMonth() - number * 3);\n }\n else if (unit === \"months\") {\n date.setMonth(date.getMonth() - number);\n }\n else if (unit === \"weeks\") {\n date.setDate(date.getDate() - number * 7);\n }\n else if (unit === \"days\") {\n date.setDate(date.getDate() - number);\n }\n else if (unit === \"hours\") {\n date.setHours(date.getHours() - number);\n }\n else if (unit === \"minutes\") {\n date.setMinutes(date.getMinutes() - number);\n }\n else if (unit === \"seconds\") {\n date.setSeconds(date.getSeconds() - number);\n }\n else if (unit === \"milliseconds\") {\n date.setMilliseconds(date.getMilliseconds() - number);\n }\n return date.toISOString.slice(0, 10)();\n }\n function dateBetween(vars) {\n // accepts two dates and returns the difference between them, requiring three arguments: date1, date2, unit (can be years, quarters, months, weeks, days, hours, minutes, seconds, milliseconds)\n\n const dateString1 = vars[Object.keys(vars)[0]];\n const date1 = extractAndParseDate(dateString1);\n const dateString2 = vars[Object.keys(vars)[1]];\n const date2 = extractAndParseDate(dateString2);\n\n const unit = vars[Object.keys(vars)[2]];\n if (unit === \"years\") {\n return date1.getFullYear() - date2.getFullYear();\n }\n else if (unit === \"quarters\") {\n return (date1.getMonth() - date2.getMonth()) / 3;\n }\n else if (unit === \"months\") {\n return date1.getMonth() - date2.getMonth();\n }\n else if (unit === \"weeks\") {\n return (date1.getDate() - date2.getDate()) / 7;\n }\n else if (unit === \"days\") {\n return date1.getDate() - date2.getDate();\n }\n else if (unit === \"hours\") {\n return date1.getHours() - date2.getHours();\n }\n else if (unit === \"minutes\") {\n return date1.getMinutes() - date2.getMinutes();\n }\n else if (unit === \"seconds\") {\n return date1.getSeconds() - date2.getSeconds();\n }\n else if (unit === \"milliseconds\") {\n return date1.getMilliseconds() - date2.getMilliseconds();\n }\n }\n function timestamp(vars) {\n // converts received var to Unix timestamp\n const dateString = vars[Object.keys(vars)[0]];\n const date = extractAndParseDate(dateString);\n return Date.parse(date);\n }\n function fromTimestamp(vars) {\n // converts Unix timestamp into date\n const dateString = vars[Object.keys(vars)[0]];\n const date = extractAndParseDate(dateString);\n return date.toISOString.slice(0, 10)();\n }\n function formatDate(vars) {\n // formats date according to provided string format (e.g. \"MMMM DD YYYY\", \"dddd, MMMM DD, YYYY hh:mm A zz\", \"[Month of] MMMM, YYYY\")\n const dateString = vars[Object.keys(vars)[0]];\n const date = extractAndParseDate(dateString);\n const format = vars[Object.keys(vars)[1]];\n return date.format(format);\n }\n function parseDate(vars) {\n // takes ISO 1860-formatted string and converts into date object\n const dateString = vars[Object.keys(vars)[0]];\n const date = extractAndParseDate(dateString);\n return date.toISOString.slice(0, 10)();\n }\n function at(vars) {\n // returns the value at a given index of an array\n const index = parseInt(vars[Object.keys(vars)[1]]);\n return vars[Object.keys(vars)[0]][index];\n }\n function first(vars) {\n // returns the first value of an array\n return vars[Object.keys(vars)[0]][0];\n }\n function last(vars) {\n // returns the last value of an array\n return vars[Object.keys(vars)[0]][vars[Object.keys(vars)[0]].length - 1];\n }\n function slice(vars) {\n // returns a portion of an array\n const start = parseInt(vars[Object.keys(vars)[1]]);\n const end = parseInt(vars[Object.keys(vars)[2]]);\n return vars[Object.keys(vars)[0]].slice(start, end);\n }\n function concat(vars) {\n // can receive infinite number of strings or arrays and concatenate them into a single string\n let result = \"\";\n for (const [key, value] of Object.entries(vars)) {\n result += value;\n }\n return result;\n }\n function sort(vars) {\n // sorts an array\n return vars[Object.keys(vars)[0]].sort();\n }\n function reverse(vars) {\n // reverses an array\n return vars[Object.keys(vars)[0]].reverse();\n }\n function join(vars) {\n // combines the array in the first var into a string, separated by the second var\n return vars[Object.keys(vars)[0]].join(vars[Object.keys(vars)[1]]);\n }\n function split(vars) {\n // splits a string into an array, separated by the second var\n return vars[Object.keys(vars)[0]].split(vars[Object.keys(vars)[1]]);\n }\n function unique(vars) {\n // returns an array containing only unique values\n return [...new Set(vars[Object.keys(vars)[0]])];\n }\n function includes(vars) {\n // returns true if second var is found in first var\n return vars[Object.keys(vars)[0]].includes(vars[Object.keys(vars)[1]]);\n }\n function find(vars) {\n // returns the index of the second var in the first var\n return vars[Object.keys(vars)[0]].findIndex(vars[Object.keys(vars)[1]]);\n }\n function findIndex(vars) {\n // returns the index of the second var in the first var\n return vars[Object.keys(vars)[0]].findIndex(vars[Object.keys(vars)[1]]);\n }\n function filter(vars) {\n // returns a new array containing only the values that pass the test\n return vars[Object.keys(vars)[0]].filter(vars[Object.keys(vars)[1]]);\n }\n function some(vars) {\n // returns true if at least one value passes the test\n return vars[Object.keys(vars)[0]].some(vars[Object.keys(vars)[1]]);\n }\n function every(vars) {\n // returns true if all values pass the test\n return vars[Object.keys(vars)[0]].every(vars[Object.keys(vars)[1]]);\n }\n function map(vars) {\n // returns a new array containing the results of the function applied to each value\n return vars[Object.keys(vars)[0]].map(vars[Object.keys(vars)[1]]);\n }\n function flatten(vars) {\n // receives infinite number of arrays, which are combined into a single array\n let result = [];\n for (const [key, value] of Object.entries(vars)) {\n result = result.concat(value);\n }\n return result;\n }\n\n // EXECUTE FUNCTION\n switch (method) {\n case \"add\":\n result = add(vars);\n break;\n case \"subtract\":\n result = subtract(vars);\n break;\n case \"multiply\":\n result = multiply(vars);\n break;\n case \"mod\":\n result = mod(vars);\n break;\n case \"pow\":\n result = pow(vars);\n break;\n case \"divide\":\n result = divide(vars);\n break;\n case \"equal\":\n result = equal(vars);\n break;\n case \"!=\":\n result = notEqual(vars);\n break;\n case \">\":\n result = greaterThan(vars);\n break;\n case \"<\":\n result = lessThan(vars);\n break;\n case \">=\":\n result = greaterThanOrEqual(vars);\n break;\n case \"<=\":\n result = lessThanOrEqual(vars);\n break;\n case \"and\":\n result = and(vars);\n break;\n case \"or\":\n result = or(vars);\n break;\n case \"not\":\n result = not(vars);\n break;\n case \"xor\":\n result = xor(vars);\n break;\n case \"nand\":\n result = nand(vars);\n break;\n case \"nor\":\n result = nor(vars);\n break;\n case \"xnor\":\n result = xnor(vars);\n break;\n case \"true\":\n result = trueFunction(vars);\n break;\n case \"false\":\n result = falseFunction(vars);\n break;\n case \"if_empty\":\n result = ifEmpty(vars);\n break;\n case \"length\":\n result = length(vars);\n break;\n case \"contains\":\n result = contains(vars);\n break;\n case \"test\":\n result = test(vars);\n break;\n case \"match\":\n result = match(vars);\n break;\n case \"replace\":\n result = replace(vars);\n break;\n case \"replaceAll\":\n result = replaceAll(vars);\n break;\n case \"lowercase\":\n result = lowercase(vars);\n break;\n case \"uppercase\":\n result = uppercase(vars);\n break;\n case \"repeat\":\n result = repeat(vars);\n break;\n case \"strip_formatting\":\n result = stripFormatting(vars);\n break;\n case \"min\":\n result = min(vars);\n break;\n case \"max\":\n result = max(vars);\n break;\n case \"absolute\":\n result = absolute(vars);\n break;\n case \"round\":\n result = round(vars);\n break;\n case \"ceiling\":\n result = ceiling(vars);\n break;\n case \"floor\":\n result = floor(vars);\n break;\n case \"squareroot\":\n result = squareroot(vars);\n break;\n case \"cuberoot\":\n result = cuberoot(vars);\n break;\n case \"exponent\":\n result = exponent(vars);\n break;\n case \"ln\":\n result = ln(vars);\n break;\n case \"log10\":\n result = log10(vars);\n break;\n case \"log2\":\n result = log2(vars);\n break;\n case \"now\":\n result = now(vars);\n break;\n case \"minute\":\n result = minute(vars);\n break;\n case \"hour\":\n result = hour(vars);\n break;\n case \"day\":\n result = day(vars);\n break;\n case \"date\":\n result = date(vars);\n break;\n case \"week\":\n result = week(vars);\n break;\n case \"month\":\n result = month(vars);\n break;\n case \"year\":\n result = year(vars);\n break;\n case \"dateAdd\":\n result = dateAdd(vars);\n break;\n case \"dateSubtract\":\n result = dateSubtract(vars);\n break;\n case \"dateBetween\":\n result = dateBetween(vars);\n break;\n case \"dateRange\":\n result = dateRange(vars);\n break;\n case \"dateStart\":\n result = dateStart(vars);\n break;\n case \"dateEnd\":\n result = dateEnd(vars);\n break;\n case \"timestamp\":\n result = timestamp(vars);\n break;\n case \"fromTimestamp\":\n result = fromTimestamp(vars);\n break;\n case \"formatDate\":\n result = formatDate(vars);\n break;\n case \"parseDate\":\n result = parseDate(vars);\n break;\n case \"at\":\n result = at(vars);\n break;\n case \"first\":\n result = first(vars);\n break;\n case \"last\":\n result = last(vars);\n break;\n case \"slice\":\n result = slice(vars);\n break;\n case \"concat\":\n result = concat(vars);\n break;\n case \"sort\":\n result = sort(vars);\n break;\n case \"reverse\":\n result = reverse(vars);\n break;\n case \"join\":\n result = join(vars);\n break;\n case \"split\":\n result = split(vars);\n break;\n case \"unique\":\n result = unique(vars);\n break;\n case \"includes\":\n result = includes(vars);\n break;\n case \"find\":\n result = find(vars);\n break;\n case \"findIndex\":\n result = findIndex(vars);\n break;\n case \"filter\":\n result = filter(vars);\n break;\n case \"some\":\n result = some(vars);\n break;\n case \"every\":\n result = every(vars);\n break;\n case \"map\":\n result = map(vars);\n break;\n case \"flatten\":\n result = flatten(vars);\n break;\n default:\n return new Response(\"Method not found\", { status: 404 });\n }\n\n const responseString = result.toString();\n return new Response(responseString);\n}","deleted","label",[98],"permalink","https://www.val.town/x/syncretizm/formulaEndpoint/code/main.tsx","extension","actionData","errors"]