[{"_1":2,"_174":-5,"_175":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":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","isTeamOrgMember","ENV",{"_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":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","a45694a1faeed7a48e6b6123449288e884a42bca","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",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":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",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_152":153,"_171":172,"_173":-5},"handle","busankimchi","name","tana-formula","path","main.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":-5,"_114":20,"_115":-5,"_116":-5,"_117":32,"_14":118,"_119":-5,"_120":-5,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":130,"_133":134,"_138":139,"_151":20},"id","b66f7028-b4a9-11f0-a57c-0224a6c84d84","createdAt",["D",1761730145164],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","019a2f4c-28d2-76d0-931e-dcaf0432f08b","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","019a2f4c-28d2-76d0-931e-e089b6d981a0","tursoName","tursoHostname","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zNGpib3I4QXUxNFZOaTRJR2JObTFsT2ZCcWYifQ","org",{"_94":95,"_135":132,"_12":112,"_136":137},"avatar","tier","free","branch",{"_140":141,"_96":44,"_102":142,"_143":103,"_144":-5,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_149":97,"_150":95},"version",2,"b66fdd74-b4a9-11f0-a57c-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":154,"_96":99,"_155":156,"_157":-5,"_158":142,"_159":141,"_160":161,"_104":162,"_140":163,"_164":165,"_166":167,"_168":20,"_169":-5,"_98":170},"ca9bc178-b4a9-11f0-bec6-0224a6c84d84","fileId","b672ba44-b4a9-11f0-a57c-0224a6c84d84","parentId","branchId","branchVersion","latest",true,["D",1761730178998],1,"fileType","script","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 } 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 } 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 } 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(\n regex,\n vars[Object.keys(vars)[2]],\n );\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(\n regex,\n vars[Object.keys(vars)[2]],\n );\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(\n parseFloat(vars[Object.keys(vars)[0]]),\n parseFloat(vars[Object.keys(vars)[1]]),\n );\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 } else if (unit === \"quarters\") {\n date.setMonth(date.getMonth() + number * 3);\n } else if (unit === \"months\") {\n date.setMonth(date.getMonth() + number);\n } else if (unit === \"weeks\") {\n date.setDate(date.getDate() + number * 7);\n } else if (unit === \"days\") {\n date.setDate(date.getDate() + number);\n } else if (unit === \"hours\") {\n date.setHours(date.getHours() + number);\n } else if (unit === \"minutes\") {\n date.setMinutes(date.getMinutes() + number);\n } else if (unit === \"seconds\") {\n date.setSeconds(date.getSeconds() + number);\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 } else if (unit === \"quarters\") {\n date.setMonth(date.getMonth() - number * 3);\n } else if (unit === \"months\") {\n date.setMonth(date.getMonth() - number);\n } else if (unit === \"weeks\") {\n date.setDate(date.getDate() - number * 7);\n } else if (unit === \"days\") {\n date.setDate(date.getDate() - number);\n } else if (unit === \"hours\") {\n date.setHours(date.getHours() - number);\n } else if (unit === \"minutes\") {\n date.setMinutes(date.getMinutes() - number);\n } else if (unit === \"seconds\") {\n date.setSeconds(date.getSeconds() - number);\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 } else if (unit === \"quarters\") {\n return (date1.getMonth() - date2.getMonth()) / 3;\n } else if (unit === \"months\") {\n return date1.getMonth() - date2.getMonth();\n } else if (unit === \"weeks\") {\n return (date1.getDate() - date2.getDate()) / 7;\n } else if (unit === \"days\") {\n return date1.getDate() - date2.getDate();\n } else if (unit === \"hours\") {\n return date1.getHours() - date2.getHours();\n } else if (unit === \"minutes\") {\n return date1.getMinutes() - date2.getMinutes();\n } else if (unit === \"seconds\") {\n return date1.getSeconds() - date2.getSeconds();\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",[99],"permalink","https://www.val.town/x/busankimchi/tana-formula/code/main.ts","extension","actionData","errors"]