Skip to content

Instantly share code, notes, and snippets.

@Theminijohn
Created September 20, 2021 19:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Theminijohn/af56db35e6004ccb8e3265dc062c4fcf to your computer and use it in GitHub Desktop.
Save Theminijohn/af56db35e6004ccb8e3265dc062c4fcf to your computer and use it in GitHub Desktop.
Retool translation demo app
{"uuid":"8149c500-1a3f-11ec-947f-9bd3e5de1a62","page":{"id":40660211,"data":{"appState":"[\"~#iR\",[\"^ \",\"n\",\"appTemplate\",\"v\",[\"^ \",\"isFetching\",false,\"plugins\",[\"~#iOM\",[\"get_translations\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"get_translations\",\"type\",\"datasource\",\"subtype\",\"GoogleSheetsQuery\",\"resourceName\",\"20cfec76-87b2-43ca-abc6-754bea759304\",\"resourceDisplayName\",\"Google Sheets\",\"template\",[\"^3\",[\"queryRefreshTime\",\"\",\"lastReceivedFromResourceAt\",null,\"queryDisabledMessage\",\"\",\"successMessage\",\"\",\"queryDisabled\",\"\",\"useSheetRange\",false,\"playgroundQuerySaveId\",\"latest\",\"resourceNameOverride\",\"\",\"useRawSpreadsheetId\",false,\"runWhenModelUpdates\",true,\"showFailureToaster\",true,\"spreadsheetId\",\"1-oRbttzc0B9OqmbE4KMMe5yBrWoUXeM8l2Qv_dPDLkg\",\"query\",\"\",\"playgroundQueryUuid\",\"\",\"playgroundQueryId\",null,\"sheetUpdate\",\"\",\"privateParams\",[\"~#iL\",[]],\"sheetIdToCopy\",\"\",\"sheetName\",\"languages\",\"runWhenPageLoadsDelay\",\"\",\"doNotThrowOnDeleteNoOp\",false,\"data\",null,\"importedQueryInputs\",[\"^3\",[]],\"isImported\",false,\"showSuccessToaster\",true,\"cacheKeyTtl\",\"300\",\"filterBy\",\"\",\"metadata\",null,\"actionType\",\"read\",\"errorTransformer\",\"// The variable 'data' allows you to reference the request's data in the transformer. \\n// example: return data.find(element => element.isError)\\nreturn data.error\",\"confirmationMessage\",null,\"isFetching\",false,\"rawData\",null,\"offset\",\"\",\"queryTriggerDelay\",\"0\",\"watchedParams\",[\"^9\",[]],\"bulkUpdateRows\",\"\",\"enableErrorTransformer\",false,\"showLatestVersionUpdatedWarning\",false,\"useRawCopyToSpreadsheetId\",false,\"timestamp\",0,\"importedQueryDefaults\",[\"^3\",[]],\"enableTransformer\",false,\"valueFormatting\",\"formatted\",\"showUpdateSetValueDynamicallyToggle\",true,\"copyToSpreadsheetId\",\"\",\"bulkUpdatePrimaryKey\",\"\",\"runWhenPageLoads\",false,\"sheetTitle\",\"\",\"transformer\",\"// type your code here\\n// example: return formatDataAsArray(data).filter(row => row.quantity > 20)\\nreturn data\",\"events\",[\"^9\",[[\"^3\",[\"event\",\"success\",\"type\",\"datasource\",\"method\",\"trigger\",\"pluginId\",\"i18n\",\"params\",[\"^3\",[]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]]]],\"queryTimeout\",\"10000\",\"requireConfirmation\",false,\"queryFailureConditions\",\"\",\"limit\",\"\",\"enableCaching\",true,\"allowedGroups\",[\"^9\",[]],\"sheetRange\",\"\",\"queryThrottleTime\",\"750\",\"updateSetValueDynamically\",false,\"notificationDuration\",\"\"]],\"style\",null,\"position2\",null,\"mobilePosition2\",null,\"tabIndex\",null,\"createdAt\",\"~m1632162061332\",\"updatedAt\",\"~m1632164503546\",\"container\",\"\",\"folder\",\"\"]]],\"i18n\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"i18n\",\"^4\",\"datasource\",\"^5\",\"JavascriptQuery\",\"^6\",\"JavascriptQuery\",\"^7\",null,\"^8\",[\"^3\",[\"queryRefreshTime\",\"\",\"lastReceivedFromResourceAt\",null,\"queryDisabledMessage\",\"\",\"successMessage\",\"\",\"queryDisabled\",\"\",\"playgroundQuerySaveId\",\"latest\",\"resourceNameOverride\",\"\",\"runWhenModelUpdates\",false,\"showFailureToaster\",true,\"query\",\"var app_language = app_language.value\\nvar translations = get_translations.data\\nvar mapping = {}\\n\\nfor (var i = 0; i < translations.length; i++) {\\n mapping[translations[i].object] = translations[i][app_language]\\n}\\n\\nreturn mapping\",\"playgroundQueryUuid\",\"\",\"playgroundQueryId\",null,\"privateParams\",[\"^9\",[]],\"runWhenPageLoadsDelay\",\"\",\"data\",null,\"importedQueryInputs\",[\"^3\",[]],\"isImported\",false,\"showSuccessToaster\",false,\"cacheKeyTtl\",\"300\",\"metadata\",null,\"errorTransformer\",\"// The variable 'data' allows you to reference the request's data in the transformer. \\n// example: return data.find(element => element.isError)\\nreturn data.error\",\"confirmationMessage\",null,\"isFetching\",false,\"rawData\",null,\"queryTriggerDelay\",\"0\",\"watchedParams\",[\"^9\",[]],\"enableErrorTransformer\",false,\"showLatestVersionUpdatedWarning\",false,\"timestamp\",0,\"importedQueryDefaults\",[\"^3\",[]],\"enableTransformer\",false,\"showUpdateSetValueDynamicallyToggle\",true,\"runWhenPageLoads\",true,\"transformer\",\"// type your code here\\n// example: return formatDataAsArray(data).filter(row => row.quantity > 20)\\nreturn data\",\"events\",[\"^9\",[]],\"queryTimeout\",\"10000\",\"requireConfirmation\",false,\"queryFailureConditions\",\"\",\"enableCaching\",true,\"allowedGroups\",[\"^9\",[]],\"queryThrottleTime\",\"750\",\"updateSetValueDynamically\",false,\"notificationDuration\",\"\"]],\"^:\",null,\"^;\",null,\"^<\",null,\"^=\",null,\"^>\",\"~m1632162342442\",\"^?\",\"~m1632164573574\",\"^@\",\"\",\"^A\",\"\"]]],\"app_language\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"app_language\",\"^4\",\"widget\",\"^5\",\"SelectWidget\",\"^6\",null,\"^7\",null,\"^8\",[\"^3\",[\"enableClientSideMatching\",true,\"values\",\"[\\\"en\\\", \\\"de\\\"]\",\"allowOutOfRangeValues\",false,\"enableFuzzyMatching\",true,\"searchValue\",\"\",\"showFetchingIndicator\",true,\"enableCaseSensitivity\",false,\"validationMessage\",\"\",\"displayValue\",\"\",\"tooltipText\",\"\",\"value\",\"\\\"en\\\"\",\"maxResults\",50,\"placeholder\",\"Select a value\",\"label\",\"Language\",\"clearValueOnFocus\",true,\"labelMaxWidth\",\"\",\"labelPlacedOnLeft\",false,\"validationState\",\"\",\"events\",[\"^9\",[[\"^3\",[\"event\",\"change\",\"type\",\"datasource\",\"method\",\"trigger\",\"pluginId\",\"i18n\",\"params\",[\"^3\",[]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]]]],\"onSelect\",\"\",\"allowCustomValues\",false,\"disabled\",\"\",\"hideClearButton\",false,\"required\",false,\"labels\",\"[\\\"English\\\", \\\"German\\\"]\"]],\"^:\",[\"^3\",[]],\"^;\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"\",\"rowGroup\",\"body\",\"subcontainer\",\"\",\"row\",0.8,\"col\",5,\"height\",1,\"width\",2,\"tabNum\",0]]],\"^<\",null,\"^=\",null,\"^>\",\"~m1632162480948\",\"^?\",\"~m1632164438863\",\"^@\",\"\",\"^A\",\"\"]]],\"text1\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"text1\",\"^4\",\"widget\",\"^5\",\"TextWidget2\",\"^6\",null,\"^7\",null,\"^8\",[\"^3\",[\"heightType\",\"auto\",\"horizontalAlign\",\"left\",\"hidden\",false,\"imageWidth\",\"fit\",\"verticalAlign\",\"center\",\"tooltipText\",\"\",\"value\",\"{{i18n.data.movie_delete}}\",\"disableMarkdown\",false,\"overflowType\",\"scroll\"]],\"^:\",[\"^3\",[]],\"^;\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"\",\"^B\",\"body\",\"^C\",\"\",\"row\",1.2,\"col\",2,\"^D\",0.6,\"^E\",2,\"^F\",0]]],\"^<\",null,\"^=\",null,\"^>\",\"~m1632164037954\",\"^?\",\"~m1632164203150\",\"^@\",\"\",\"^A\",\"\"]]],\"button1\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"button1\",\"^4\",\"widget\",\"^5\",\"ButtonWidget2\",\"^6\",null,\"^7\",null,\"^8\",[\"^3\",[\"hidden\",false,\"disabled\",false,\"iconAfter\",\"\",\"iconBefore\",\"\",\"loading\",false,\"text\",\"{{i18n.data.refresh}}\",\"tooltipText\",\"\",\"styleVariant\",\"solid\"]],\"^:\",[\"^3\",[]],\"^;\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"\",\"^B\",\"body\",\"^C\",\"\",\"row\",2.6,\"col\",2,\"^D\",1,\"^E\",2,\"^F\",0]]],\"^<\",null,\"^=\",null,\"^>\",\"~m1632164293262\",\"^?\",\"~m1632164377813\",\"^@\",\"\",\"^A\",\"\"]]],\"button2\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"button2\",\"^4\",\"widget\",\"^5\",\"ButtonWidget2\",\"^6\",null,\"^7\",null,\"^8\",[\"^3\",[\"iconAfter\",\"\",\"hidden\",false,\"text\",\"{{i18n.data.open}}\",\"tooltipText\",\"\",\"style\",[\"^3\",[\"background\",\"hsl(141, 20%, 55%)\"]],\"styleVariant\",\"solid\",\"iconBefore\",\"\",\"loading\",false,\"disabled\",false]],\"^:\",[\"^3\",[]],\"^;\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"\",\"^B\",\"body\",\"^C\",\"\",\"row\",4,\"col\",2,\"^D\",1,\"^E\",2,\"^F\",0]]],\"^<\",null,\"^=\",null,\"^>\",\"~m1632164390278\",\"^?\",\"~m1632164406201\",\"^@\",\"\",\"^A\",\"\"]]]]],\"^>\",null,\"version\",\"2.76.18\",\"appThemeId\",null,\"preloadedAppJavaScript\",null,\"preloadedAppJSLinks\",[],\"appStyles\",\"\",\"testEntities\",[],\"tests\",[],\"responsiveLayoutDisabled\",false,\"loadingIndicatorsDisabled\",false,\"urlFragmentDefinitions\",[\"^9\",[]],\"pageLoadValueOverrides\",[\"^9\",[]],\"isGlobalWidget\",false,\"isMobileApp\",false,\"instrumentationEnabled\",false,\"customDocumentTitleEnabled\",false,\"customDocumentTitle\",\"\",\"customShortcuts\",[],\"folders\",[\"^9\",[]]]]]"},"changesRecord":[{"type":"QUERY_MOVE"}],"gitSha":null,"checksum":null,"createdAt":"2021-09-20T19:04:06.212Z","updatedAt":"2021-09-20T19:04:06.212Z","pageId":559582,"userId":12239,"branchId":null},"modules":{}}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment