Skip to content

Instantly share code, notes, and snippets.

@phy25
Created December 29, 2022 07:10
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 phy25/134e637eab7be2d8e6f04ea0738db0bf to your computer and use it in GitHub Desktop.
Save phy25/134e637eab7be2d8e6f04ea0738db0bf to your computer and use it in GitHub Desktop.
Move Boxes Scanner Retool Mobile App
{"uuid":"6f71b304-8732-11ed-9065-4b26539f38d1","page":{"id":116329136,"data":{"appState":"[\"~#iR\",[\"^ \",\"n\",\"appTemplate\",\"v\",[\"^ \",\"isFetching\",false,\"plugins\",[\"~#iOM\",[\"tabscreen\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"tabscreen\",\"type\",\"screen\",\"subtype\",\"TabScreen\",\"namespace\",null,\"resourceName\",null,\"resourceDisplayName\",null,\"template\",[\"^3\",[\"items\",[\"~#iL\",[[\"^3\",[\"screen\",\"scannerScreen\",\"icon\",\"bold/interface-text-formatting-list-bullets\"]]]]]],\"style\",null,\"position2\",null,\"mobilePosition2\",null,\"mobileAppPosition\",null,\"tabIndex\",null,\"container\",\"\",\"createdAt\",\"~m1672288620614\",\"updatedAt\",\"~m1672296986532\",\"folder\",\"\",\"screen\",null]]],\"scannerScreen\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"scannerScreen\",\"^4\",\"screen\",\"^5\",\"Screen\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"title\",\"Box Scanner\",\"headerLeftActions\",[\"^:\",[]],\"headerRightActions\",[\"^:\",[]],\"gap\",16,\"padding\",[\"^ \",\"left\",16,\"right\",16,\"top\",8,\"bottom\",8],\"events\",[\"^:\",[[\"^3\",[\"event\",\"load\",\"type\",\"widget\",\"method\",\"open\",\"pluginId\",\"scanner\",\"targetId\",null,\"params\",[\"^3\",[]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]],[\"^3\",[\"method\",\"focus\",\"enabled\",\"{{ !barcode.value }}\",\"params\",[\"^3\",[]],\"targetId\",null,\"pluginId\",\"barcode\",\"waitType\",\"debounce\",\"event\",\"visible\",\"type\",\"widget\",\"waitMs\",\"0\"]]]]]],\"^;\",null,\"^<\",null,\"^=\",null,\"^>\",null,\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672288620614\",\"^B\",\"~m1672297421339\",\"^C\",\"\",\"^D\",null]]],\"$main\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"$main\",\"^4\",\"frame\",\"^5\",\"Frame\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"type\",\"main\",\"sticky\",false]],\"^;\",[\"^3\",[]],\"^<\",null,\"^=\",null,\"^>\",null,\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672288620888\",\"^B\",\"~m1672288620888\",\"^C\",\"\",\"^D\",null]]],\"barcodeRow\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"barcodeRow\",\"^4\",\"widget\",\"^5\",\"RNContainerWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"events\",[\"^3\",[]],\"cornerType\",\"square\",\"layout\",\"row\",\"justify\",\"center\",\"align\",\"center\",\"gap\",8,\"padding\",[\"^3\",[\"left\",0,\"right\",0,\"top\",0,\"bottom\",0]],\"width\",\"full\"]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"\",\"rowGroup\",\"body\",\"subcontainer\",\"\",\"row\",0,\"col\",0,\"height\",5,\"width\",3,\"tabNum\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"ordinal\",1]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672289115583\",\"^B\",\"~m1672289459127\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"steps\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"steps\",\"^4\",\"widget\",\"^5\",\"RNCustomCollectionViewWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"cardStyle\",\"flat\",\"showSeparator\",false,\"data\",\"[\\n {\\\"title\\\": \\\"Step 1\\\",\\\"step\\\": 1, \\\"date\\\": \\\"{{dataQuery.data.scan1[0]}}\\\"},\\n {\\\"title\\\": \\\"Step 2\\\",\\\"step\\\": 2, \\\"date\\\": \\\"{{dataQuery.data.scan2[0]}}\\\"},\\n {\\\"title\\\": \\\"Step 3\\\",\\\"step\\\": 3, \\\"date\\\": \\\"{{dataQuery.data.scan3[0]}}\\\"},\\n {\\\"title\\\": \\\"Step 4\\\",\\\"step\\\": 4, \\\"date\\\": \\\"{{dataQuery.data.scan4[0]}}\\\"}\\n]\",\"selectedItem\",null,\"padding\",[\"^3\",[\"left\",4,\"right\",4,\"top\",8,\"bottom\",8]],\"gap\",0,\"selectedIndex\",null,\"events\",[\"^3\",[]],\"instances\",5]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"mainView\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",5,\"^K\",3,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",1]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672289397159\",\"^B\",\"~m1672295299862\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"scanner\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"scanner\",\"^4\",\"widget\",\"^5\",\"RNScannerWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"iconAfter\",\"\",\"width\",\"full\",\"opened\",false,\"autoClose\",true,\"data\",\"[]\",\"buttonSize\",\"large\",\"iconBefore\",\"\",\"events\",[\"^:\",[[\"^3\",[\"event\",\"capture\",\"type\",\"widget\",\"method\",\"setValue\",\"pluginId\",\"barcode\",\"targetId\",null,\"params\",[\"^3\",[\"value\",\"{{ scanner.data[0].replace(\\\"-\\\", \\\"\\\") }}\"]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]],[\"^3\",[\"event\",\"capture\",\"type\",\"datasource\",\"method\",\"trigger\",\"pluginId\",\"dataQuery\",\"targetId\",null,\"params\",[\"^3\",[]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]]]],\"disabled\",false,\"buttonText\",\"Scanner\"]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"barcodeRow\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",5,\"^K\",3,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",1]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672289427535\",\"^B\",\"~m1672297539612\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"barcode\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"barcode\",\"^4\",\"widget\",\"^5\",\"RNNumberInputWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"iconAfter\",\"\",\"maxLength\",null,\"customValidation\",\"\",\"hideValidationMessage\",false,\"allowNegativeNumbers\",false,\"validationMessage\",\"\",\"formDataKey\",\"{{ self.id }}\",\"value\",null,\"labelCaption\",\"\",\"placeholder\",\"\",\"showStepper\",false,\"label\",\"\",\"_validate\",false,\"invalid\",false,\"iconBefore\",\"\",\"minLength\",null,\"events\",[\"^:\",[[\"^3\",[\"event\",\"submit\",\"type\",\"datasource\",\"method\",\"trigger\",\"pluginId\",\"dataQuery\",\"targetId\",null,\"params\",[\"^3\",[]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]],[\"^3\",[\"event\",\"submit\",\"type\",\"datasource\",\"method\",\"trigger\",\"pluginId\",\"imageQuery\",\"targetId\",null,\"params\",[\"^3\",[]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]]]],\"disabled\",false,\"required\",false]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"barcodeRow\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",5,\"^K\",3,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",0]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672289454848\",\"^B\",\"~m1672293329375\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"scanTime\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"scanTime\",\"^4\",\"widget\",\"^5\",\"RNTextWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"value\",\"{{ item.date ? new Date(item.date).toLocaleString() : \\\"Not scanned\\\"}}\",\"size\",\"large\",\"weight\",\"normal\",\"width\",\"full\",\"textAlign\",\"left\"]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"stepText\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",5,\"^K\",3,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",1]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672289998703\",\"^B\",\"~m1672295709052\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"content\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"content\",\"^4\",\"widget\",\"^5\",\"RNTextAreaWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"autoResize\",true,\"maxLength\",null,\"customValidation\",\"\",\"patternType\",\"\",\"hideValidationMessage\",false,\"minLines\",\"1\",\"validationMessage\",\"\",\"pattern\",\"\",\"formDataKey\",\"{{ self.id }}\",\"value\",\"{{dataQuery.data.content[0]}}\",\"labelCaption\",\"\",\"placeholder\",\"Content\",\"label\",\"\",\"_validate\",false,\"invalid\",false,\"minLength\",null,\"events\",[\"^:\",[[\"^3\",[\"event\",\"blur\",\"type\",\"datasource\",\"method\",\"trigger\",\"pluginId\",\"contentUpdate\",\"targetId\",null,\"params\",[\"^3\",[]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]]]],\"autoCapitalize\",\"none\",\"maxLines\",null,\"disabled\",false,\"required\",false]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"mainView\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",5,\"^K\",3,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",0]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672290082511\",\"^B\",\"~m1672294080045\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"checkBtn\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"checkBtn\",\"^4\",\"widget\",\"^5\",\"RNButtonWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"size\",\"large\",\"iconAfter\",\"\",\"width\",\"fixed\",\"hidden\",\"{{item.date}}\",\"text\",\"Check\",\"style\",[\"^3\",[\"background\",\"rgba(20, 65, 200, 1)\"]],\"iconBefore\",\"\",\"events\",[\"^:\",[[\"^3\",[\"method\",\"setValue\",\"enabled\",\"\",\"params\",[\"^3\",[\"value\",\"{{ item.step }}\"]],\"targetId\",null,\"pluginId\",\"updateStep\",\"waitType\",\"debounce\",\"event\",\"click\",\"type\",\"state\",\"waitMs\",\"0\"]],[\"^3\",[\"event\",\"click\",\"type\",\"datasource\",\"method\",\"trigger\",\"pluginId\",\"checkinUpdate\",\"targetId\",null,\"params\",[\"^3\",[]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]]]],\"type\",\"primary\",\"loading\",false,\"disabled\",false]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"stepRow\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",5,\"^K\",3,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",1]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672290143959\",\"^B\",\"~m1672295388836\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"stepRow\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"stepRow\",\"^4\",\"widget\",\"^5\",\"RNContainerWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"align\",\"center\",\"width\",\"full\",\"hidden\",\"{{ item.step > (dataQuery.data.scan_stage[0] || 0) + 1 }}\",\"layout\",\"row\",\"cornerType\",\"square\",\"justify\",\"flex-start\",\"padding\",[\"^3\",[\"left\",0,\"right\",0,\"top\",0,\"bottom\",0]],\"gap\",0,\"events\",[\"^3\",[]]]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"steps\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",5,\"^K\",3,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",0]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672290154548\",\"^B\",\"~m1672297646300\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"image\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"image\",\"^4\",\"widget\",\"^5\",\"RNImageWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"src\",\"{{imageQuery.data.image[0]}}\",\"ratio\",1.3333333333333333,\"mode\",\"center\",\"cornerType\",\"round\",\"hidden\",\"{{!imageQuery.data.image[0]}}\"]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"mainView\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",5,\"^K\",3,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",2]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672290269986\",\"^B\",\"~m1672294341583\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"camera\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"camera\",\"^4\",\"widget\",\"^5\",\"RNCameraWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"parsedValue\",[],\"iconAfter\",\"\",\"libraryOpened\",false,\"parseFiles\",false,\"maxSize\",\"\",\"appendNewSelection\",false,\"width\",\"full\",\"selectionType\",\"single\",\"accept\",[],\"opened\",false,\"hidden\",false,\"customValidation\",\"\",\"maxCount\",null,\"hideValidationMessage\",false,\"validationMessage\",\"\",\"showInEditor\",false,\"parsing\",false,\"tooltipText\",\"\",\"formDataKey\",\"{{ self.id }}\",\"value\",[],\"minSize\",\"\",\"buttonSize\",\"small\",\"_validate\",false,\"launchMode\",\"option\",\"invalid\",false,\"files\",[],\"iconBefore\",\"\",\"events\",[\"^:\",[[\"^3\",[\"event\",\"capture\",\"type\",\"datasource\",\"method\",\"trigger\",\"pluginId\",\"imageUpdate\",\"targetId\",null,\"params\",[\"^3\",[]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]]]],\"disabled\",false,\"minCount\",null,\"quality\",0.25,\"maintainSpaceWhenHidden\",false,\"buttonText\",\"Replace Image\",\"required\",false]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"cameraRow\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",5,\"^K\",3,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",0]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672290299246\",\"^B\",\"~m1672293758836\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"dataQuery\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"dataQuery\",\"^4\",\"datasource\",\"^5\",\"SqlQueryUnified\",\"^6\",null,\"^7\",\"89790bb1-c4cd-4abe-8561-a3caa51091bf\",\"^8\",\"retool_db\",\"^9\",[\"^3\",[\"queryRefreshTime\",\"\",\"records\",\"\",\"lastReceivedFromResourceAt\",null,\"databasePasswordOverride\",\"\",\"queryDisabledMessage\",\"\",\"servedFromCache\",false,\"successMessage\",\"\",\"queryDisabled\",\"\",\"playgroundQuerySaveId\",\"latest\",\"resourceNameOverride\",\"\",\"runWhenModelUpdates\",false,\"showFailureToaster\",true,\"query\",\"select content, scan1, scan2, scan3, scan4, scan_stage from move2023 where barcode = {{ barcode.value }}\",\"playgroundQueryUuid\",\"\",\"playgroundQueryId\",null,\"error\",null,\"privateParams\",[\"^:\",[]],\"runWhenPageLoadsDelay\",\"\",\"warningCodes\",[\"^:\",[]],\"data\",null,\"recordId\",\"\",\"importedQueryInputs\",[\"^3\",[]],\"isImported\",false,\"showSuccessToaster\",true,\"dataArray\",[\"^:\",[]],\"cacheKeyTtl\",\"\",\"filterBy\",\"\",\"requestSentTimestamp\",null,\"databaseHostOverride\",\"\",\"metadata\",null,\"editorMode\",\"sql\",\"queryRunTime\",null,\"actionType\",\"\",\"changesetObject\",\"\",\"shouldUseLegacySql\",false,\"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\",\"finished\",null,\"databaseNameOverride\",\"\",\"confirmationMessage\",null,\"isFetching\",false,\"changeset\",\"\",\"rawData\",null,\"queryTriggerDelay\",\"0\",\"resourceTypeOverride\",\"\",\"watchedParams\",[\"^:\",[]],\"enableErrorTransformer\",false,\"enableBulkUpdates\",false,\"showLatestVersionUpdatedWarning\",false,\"timestamp\",0,\"importedQueryDefaults\",[\"^3\",[]],\"enableTransformer\",false,\"showUpdateSetValueDynamicallyToggle\",true,\"bulkUpdatePrimaryKey\",\"\",\"runWhenPageLoads\",false,\"transformer\",\"// type your code here\\n// example: return formatDataAsArray(data).filter(row => row.quantity > 20)\\nreturn data\",\"events\",[\"^:\",[]],\"tableName\",\"\",\"queryTimeout\",\"10000\",\"requireConfirmation\",false,\"queryFailureConditions\",\"\",\"changesetIsObject\",false,\"enableCaching\",false,\"allowedGroups\",[\"^:\",[]],\"databaseUsernameOverride\",\"\",\"shouldEnableBatchQuerying\",false,\"doNotThrowOnNoOp\",false,\"offlineQueryType\",\"None\",\"queryThrottleTime\",\"750\",\"updateSetValueDynamically\",false,\"notificationDuration\",\"\"]],\"^;\",null,\"^<\",null,\"^=\",null,\"^>\",null,\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672290634655\",\"^B\",\"~m1672294664812\",\"^C\",\"\",\"^D\",null]]],\"clearBtn\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"clearBtn\",\"^4\",\"widget\",\"^5\",\"RNButtonWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"size\",\"small\",\"iconAfter\",\"\",\"width\",\"fixed\",\"hidden\",\"{{!item.date}}\",\"text\",\"Clear\",\"style\",[\"^3\",[\"text\",\"\",\"background\",\"rgba(255, 34, 0, 1)\"]],\"iconBefore\",\"\",\"events\",[\"^:\",[[\"^3\",[\"event\",\"click\",\"type\",\"state\",\"method\",\"setValue\",\"pluginId\",\"updateStep\",\"targetId\",null,\"params\",[\"^3\",[\"value\",\"{{item.step}}\"]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]],[\"^3\",[\"event\",\"click\",\"type\",\"alert\",\"method\",\"open\",\"pluginId\",\"\",\"targetId\",null,\"params\",[\"^3\",[\"title\",\"Are you sure to clear?\",\"description\",\"\",\"actionItems\",[\"^:\",[[\"^3\",[\"label\",\"OK\",\"event\",[\"^3\",[\"event\",\"click\",\"method\",\"trigger\",\"pluginId\",\"clearUpdate\",\"type\",\"datasource\",\"waitMs\",0,\"waitType\",\"debounce\"]]]],[\"^3\",[\"label\",\"Cancel\",\"event\",[\"^3\",[\"event\",\"click\",\"method\",\"run\",\"pluginId\",\"\",\"type\",\"script\",\"waitMs\",0,\"waitType\",\"debounce\",\"params\",[\"^3\",[]]]]]]]]]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]]]],\"type\",\"primary\",\"loading\",false,\"disabled\",false]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"stepRow\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",5,\"^K\",3,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",2]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672291002660\",\"^B\",\"~m1672295786549\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"imageQuery\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"imageQuery\",\"^4\",\"datasource\",\"^5\",\"SqlQueryUnified\",\"^6\",null,\"^7\",\"89790bb1-c4cd-4abe-8561-a3caa51091bf\",\"^8\",\"retool_db\",\"^9\",[\"^3\",[\"queryRefreshTime\",\"\",\"records\",\"\",\"lastReceivedFromResourceAt\",null,\"databasePasswordOverride\",\"\",\"queryDisabledMessage\",\"\",\"servedFromCache\",false,\"successMessage\",\"\",\"queryDisabled\",\"\",\"playgroundQuerySaveId\",\"latest\",\"resourceNameOverride\",\"\",\"runWhenModelUpdates\",true,\"showFailureToaster\",true,\"query\",\"select image from move2023 where barcode = {{barcode.value}}\",\"playgroundQueryUuid\",\"\",\"playgroundQueryId\",null,\"error\",null,\"privateParams\",[\"^:\",[]],\"runWhenPageLoadsDelay\",\"\",\"warningCodes\",[\"^:\",[]],\"data\",null,\"recordId\",\"\",\"importedQueryInputs\",[\"^3\",[]],\"isImported\",false,\"showSuccessToaster\",true,\"dataArray\",[\"^:\",[]],\"cacheKeyTtl\",\"300\",\"filterBy\",\"\",\"requestSentTimestamp\",null,\"databaseHostOverride\",\"\",\"metadata\",null,\"editorMode\",\"sql\",\"queryRunTime\",null,\"actionType\",\"\",\"changesetObject\",\"\",\"shouldUseLegacySql\",false,\"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\",\"finished\",null,\"databaseNameOverride\",\"\",\"confirmationMessage\",null,\"isFetching\",false,\"changeset\",\"\",\"rawData\",null,\"queryTriggerDelay\",\"0\",\"resourceTypeOverride\",null,\"watchedParams\",[\"^:\",[]],\"enableErrorTransformer\",false,\"enableBulkUpdates\",false,\"showLatestVersionUpdatedWarning\",false,\"timestamp\",0,\"importedQueryDefaults\",[\"^3\",[]],\"enableTransformer\",false,\"showUpdateSetValueDynamicallyToggle\",true,\"bulkUpdatePrimaryKey\",\"\",\"runWhenPageLoads\",false,\"transformer\",\"// type your code here\\n// example: return formatDataAsArray(data).filter(row => row.quantity > 20)\\nreturn data\",\"events\",[\"^:\",[]],\"tableName\",\"\",\"queryTimeout\",\"10000\",\"requireConfirmation\",false,\"queryFailureConditions\",\"\",\"changesetIsObject\",false,\"enableCaching\",true,\"allowedGroups\",[\"^:\",[]],\"databaseUsernameOverride\",\"\",\"shouldEnableBatchQuerying\",false,\"doNotThrowOnNoOp\",false,\"offlineQueryType\",\"None\",\"queryThrottleTime\",\"750\",\"updateSetValueDynamically\",false,\"notificationDuration\",\"\"]],\"^;\",null,\"^<\",null,\"^=\",null,\"^>\",null,\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672291381894\",\"^B\",\"~m1672293980695\",\"^C\",\"\",\"^D\",null]]],\"contentUpdate\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"contentUpdate\",\"^4\",\"datasource\",\"^5\",\"SqlQueryUnified\",\"^6\",null,\"^7\",\"89790bb1-c4cd-4abe-8561-a3caa51091bf\",\"^8\",\"retool_db\",\"^9\",[\"^3\",[\"queryRefreshTime\",\"\",\"records\",\"\",\"lastReceivedFromResourceAt\",null,\"databasePasswordOverride\",\"\",\"queryDisabledMessage\",\"\",\"servedFromCache\",false,\"successMessage\",\"\",\"queryDisabled\",\"\",\"playgroundQuerySaveId\",\"latest\",\"resourceNameOverride\",\"\",\"runWhenModelUpdates\",false,\"showFailureToaster\",true,\"query\",\"\",\"playgroundQueryUuid\",\"\",\"playgroundQueryId\",null,\"error\",null,\"privateParams\",[\"^:\",[]],\"runWhenPageLoadsDelay\",\"\",\"data\",null,\"recordId\",\"\",\"importedQueryInputs\",[\"^3\",[]],\"isImported\",false,\"showSuccessToaster\",true,\"dataArray\",[\"^:\",[]],\"cacheKeyTtl\",\"\",\"filterBy\",\"[{\\\"key\\\":\\\"barcode\\\",\\\"value\\\":\\\"{{barcode.value}}\\\",\\\"operation\\\":\\\"=\\\"}]\",\"requestSentTimestamp\",null,\"databaseHostOverride\",\"\",\"metadata\",null,\"editorMode\",\"gui\",\"queryRunTime\",null,\"actionType\",\"UPDATE_OR_INSERT_BY\",\"changesetObject\",\"\",\"shouldUseLegacySql\",false,\"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\",\"finished\",null,\"databaseNameOverride\",\"\",\"confirmationMessage\",null,\"isFetching\",false,\"changeset\",\"[{\\\"key\\\":\\\"content\\\",\\\"value\\\":\\\"{{content.value}}\\\"},{\\\"key\\\":\\\"barcode\\\",\\\"value\\\":\\\"{{barcode.value}}\\\"}]\",\"rawData\",null,\"queryTriggerDelay\",\"0\",\"resourceTypeOverride\",null,\"watchedParams\",[\"^:\",[]],\"enableErrorTransformer\",false,\"enableBulkUpdates\",false,\"showLatestVersionUpdatedWarning\",false,\"timestamp\",0,\"importedQueryDefaults\",[\"^3\",[]],\"enableTransformer\",false,\"showUpdateSetValueDynamicallyToggle\",true,\"bulkUpdatePrimaryKey\",\"\",\"runWhenPageLoads\",false,\"transformer\",\"// type your code here\\n// example: return formatDataAsArray(data).filter(row => row.quantity > 20)\\nreturn data\",\"events\",[\"^:\",[[\"^3\",[\"event\",\"success\",\"type\",\"datasource\",\"method\",\"trigger\",\"pluginId\",\"dataQuery\",\"targetId\",null,\"params\",[\"^3\",[]],\"waitType\",\"throttle\",\"waitMs\",\"0\"]]]],\"tableName\",\"move2023\",\"queryTimeout\",\"10000\",\"requireConfirmation\",false,\"queryFailureConditions\",\"\",\"changesetIsObject\",false,\"enableCaching\",false,\"allowedGroups\",[\"^:\",[]],\"databaseUsernameOverride\",\"\",\"shouldEnableBatchQuerying\",false,\"doNotThrowOnNoOp\",false,\"offlineQueryType\",\"None\",\"queryThrottleTime\",\"750\",\"updateSetValueDynamically\",false,\"notificationDuration\",\"\"]],\"^;\",null,\"^<\",null,\"^=\",null,\"^>\",null,\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672291504102\",\"^B\",\"~m1672293447466\",\"^C\",\"\",\"^D\",null]]],\"checkinUpdate\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"checkinUpdate\",\"^4\",\"datasource\",\"^5\",\"SqlQueryUnified\",\"^6\",null,\"^7\",\"89790bb1-c4cd-4abe-8561-a3caa51091bf\",\"^8\",\"retool_db\",\"^9\",[\"^3\",[\"queryRefreshTime\",\"\",\"records\",\"\",\"lastReceivedFromResourceAt\",null,\"databasePasswordOverride\",\"\",\"queryDisabledMessage\",\"\",\"servedFromCache\",false,\"successMessage\",\"\",\"queryDisabled\",\"\",\"playgroundQuerySaveId\",\"latest\",\"resourceNameOverride\",\"\",\"runWhenModelUpdates\",false,\"showFailureToaster\",true,\"query\",\"\",\"playgroundQueryUuid\",\"\",\"playgroundQueryId\",null,\"error\",null,\"privateParams\",[\"^:\",[]],\"runWhenPageLoadsDelay\",\"\",\"data\",null,\"recordId\",\"\",\"importedQueryInputs\",[\"^3\",[]],\"isImported\",false,\"showSuccessToaster\",true,\"dataArray\",[\"^:\",[]],\"cacheKeyTtl\",\"\",\"filterBy\",\"[{\\\"key\\\":\\\"barcode\\\",\\\"value\\\":\\\"{{barcode.value}}\\\",\\\"operation\\\":\\\"=\\\"}]\",\"requestSentTimestamp\",null,\"databaseHostOverride\",\"\",\"metadata\",null,\"editorMode\",\"gui\",\"queryRunTime\",null,\"actionType\",\"UPDATE_BY\",\"changesetObject\",\"{\\n \\\"scan{{updateStep.value}}\\\": \\\"{{new Date().toISOString()}}\\\",\\n \\\"scan_stage\\\": \\\"{{updateStep.value}}\\\"\\n}\",\"shouldUseLegacySql\",false,\"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\",\"finished\",null,\"databaseNameOverride\",\"\",\"confirmationMessage\",null,\"isFetching\",false,\"changeset\",\"[{\\\"key\\\":\\\"\\\",\\\"value\\\":\\\"\\\"}]\",\"rawData\",null,\"queryTriggerDelay\",\"0\",\"resourceTypeOverride\",null,\"watchedParams\",[\"^:\",[]],\"enableErrorTransformer\",false,\"enableBulkUpdates\",false,\"showLatestVersionUpdatedWarning\",false,\"timestamp\",0,\"importedQueryDefaults\",[\"^3\",[]],\"enableTransformer\",false,\"showUpdateSetValueDynamicallyToggle\",true,\"bulkUpdatePrimaryKey\",\"\",\"runWhenPageLoads\",false,\"transformer\",\"// type your code here\\n// example: return formatDataAsArray(data).filter(row => row.quantity > 20)\\nreturn data\",\"events\",[\"^:\",[[\"^3\",[\"event\",\"success\",\"type\",\"datasource\",\"method\",\"trigger\",\"pluginId\",\"dataQuery\",\"targetId\",null,\"params\",[\"^3\",[]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]]]],\"tableName\",\"move2023\",\"queryTimeout\",\"10000\",\"requireConfirmation\",false,\"queryFailureConditions\",\"\",\"changesetIsObject\",true,\"enableCaching\",false,\"allowedGroups\",[\"^:\",[]],\"databaseUsernameOverride\",\"\",\"shouldEnableBatchQuerying\",false,\"doNotThrowOnNoOp\",false,\"offlineQueryType\",\"None\",\"queryThrottleTime\",\"750\",\"updateSetValueDynamically\",false,\"notificationDuration\",\"\"]],\"^;\",null,\"^<\",null,\"^=\",null,\"^>\",null,\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672291571344\",\"^B\",\"~m1672292531149\",\"^C\",\"\",\"^D\",null]]],\"clearUpdate\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"clearUpdate\",\"^4\",\"datasource\",\"^5\",\"SqlQueryUnified\",\"^6\",null,\"^7\",\"89790bb1-c4cd-4abe-8561-a3caa51091bf\",\"^8\",\"retool_db\",\"^9\",[\"^3\",[\"queryRefreshTime\",\"\",\"records\",\"\",\"lastReceivedFromResourceAt\",null,\"databasePasswordOverride\",\"\",\"queryDisabledMessage\",\"\",\"servedFromCache\",false,\"successMessage\",\"\",\"queryDisabled\",\"\",\"playgroundQuerySaveId\",\"latest\",\"resourceNameOverride\",\"\",\"runWhenModelUpdates\",false,\"showFailureToaster\",true,\"query\",\"\",\"playgroundQueryUuid\",\"\",\"playgroundQueryId\",null,\"error\",null,\"privateParams\",[\"^:\",[]],\"runWhenPageLoadsDelay\",\"\",\"data\",null,\"recordId\",\"\",\"importedQueryInputs\",[\"^3\",[]],\"isImported\",false,\"showSuccessToaster\",true,\"dataArray\",[\"^:\",[]],\"cacheKeyTtl\",\"\",\"filterBy\",\"[{\\\"key\\\":\\\"barcode\\\",\\\"value\\\":\\\"{{barcode.value}}\\\",\\\"operation\\\":\\\"=\\\"}]\",\"requestSentTimestamp\",null,\"databaseHostOverride\",\"\",\"metadata\",null,\"editorMode\",\"gui\",\"queryRunTime\",null,\"actionType\",\"UPDATE_BY\",\"changesetObject\",\"{\\n \\\"scan{{updateStep.value}}\\\": null,\\n \\\"scan_stage\\\": \\\"{{updateStep.value - 1}}\\\"\\n}\",\"shouldUseLegacySql\",false,\"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\",\"finished\",null,\"databaseNameOverride\",\"\",\"confirmationMessage\",null,\"isFetching\",false,\"changeset\",\"\",\"rawData\",null,\"queryTriggerDelay\",\"0\",\"resourceTypeOverride\",null,\"watchedParams\",[\"^:\",[]],\"enableErrorTransformer\",false,\"enableBulkUpdates\",false,\"showLatestVersionUpdatedWarning\",false,\"timestamp\",0,\"importedQueryDefaults\",[\"^3\",[]],\"enableTransformer\",false,\"showUpdateSetValueDynamicallyToggle\",true,\"bulkUpdatePrimaryKey\",\"\",\"runWhenPageLoads\",false,\"transformer\",\"// type your code here\\n// example: return formatDataAsArray(data).filter(row => row.quantity > 20)\\nreturn data\",\"events\",[\"^:\",[[\"^3\",[\"event\",\"success\",\"type\",\"datasource\",\"method\",\"trigger\",\"pluginId\",\"dataQuery\",\"targetId\",null,\"params\",[\"^3\",[]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]]]],\"tableName\",\"move2023\",\"queryTimeout\",\"10000\",\"requireConfirmation\",false,\"queryFailureConditions\",\"\",\"changesetIsObject\",true,\"enableCaching\",false,\"allowedGroups\",[\"^:\",[]],\"databaseUsernameOverride\",\"\",\"shouldEnableBatchQuerying\",false,\"doNotThrowOnNoOp\",false,\"offlineQueryType\",\"None\",\"queryThrottleTime\",\"750\",\"updateSetValueDynamically\",false,\"notificationDuration\",\"\"]],\"^;\",null,\"^<\",null,\"^=\",null,\"^>\",null,\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672291581041\",\"^B\",\"~m1672293181093\",\"^C\",\"\",\"^D\",null]]],\"updateStep\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"updateStep\",\"^4\",\"state\",\"^5\",\"State\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"_persistedValueGetter\",null,\"_persistedValueSetter\",null,\"persistValue\",false,\"persistedValueKey\",\"\",\"value\",null]],\"^;\",null,\"^<\",null,\"^=\",null,\"^>\",null,\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672291628589\",\"^B\",\"~m1672291628589\",\"^C\",\"\",\"^D\",null]]],\"imageUpdate\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"imageUpdate\",\"^4\",\"datasource\",\"^5\",\"SqlQueryUnified\",\"^6\",null,\"^7\",\"89790bb1-c4cd-4abe-8561-a3caa51091bf\",\"^8\",\"retool_db\",\"^9\",[\"^3\",[\"queryRefreshTime\",\"\",\"records\",\"\",\"lastReceivedFromResourceAt\",null,\"databasePasswordOverride\",\"\",\"queryDisabledMessage\",\"\",\"servedFromCache\",false,\"successMessage\",\"\",\"queryDisabled\",\"\",\"playgroundQuerySaveId\",\"latest\",\"resourceNameOverride\",\"\",\"runWhenModelUpdates\",false,\"showFailureToaster\",true,\"query\",\"\",\"playgroundQueryUuid\",\"\",\"playgroundQueryId\",null,\"error\",null,\"privateParams\",[\"^:\",[]],\"runWhenPageLoadsDelay\",\"\",\"data\",null,\"recordId\",\"\",\"importedQueryInputs\",[\"^3\",[]],\"isImported\",false,\"showSuccessToaster\",true,\"dataArray\",[\"^:\",[]],\"cacheKeyTtl\",\"\",\"filterBy\",\"[{\\\"key\\\":\\\"barcode\\\",\\\"value\\\":\\\"{{barcode.value}}\\\",\\\"operation\\\":\\\"=\\\"}]\",\"requestSentTimestamp\",null,\"databaseHostOverride\",\"\",\"metadata\",null,\"editorMode\",\"gui\",\"queryRunTime\",null,\"actionType\",\"UPDATE_OR_INSERT_BY\",\"changesetObject\",\"\",\"shouldUseLegacySql\",false,\"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\",\"finished\",null,\"databaseNameOverride\",\"\",\"confirmationMessage\",null,\"isFetching\",false,\"changeset\",\"[{\\\"key\\\":\\\"image\\\",\\\"value\\\":\\\"data:{{camera.files[0].type}};base64,{{camera.value[0]}}\\\"},{\\\"key\\\":\\\"barcode\\\",\\\"value\\\":\\\"{{barcode.value}}\\\"}]\",\"rawData\",null,\"queryTriggerDelay\",\"0\",\"resourceTypeOverride\",null,\"watchedParams\",[\"^:\",[]],\"enableErrorTransformer\",false,\"enableBulkUpdates\",false,\"showLatestVersionUpdatedWarning\",false,\"timestamp\",0,\"importedQueryDefaults\",[\"^3\",[]],\"enableTransformer\",false,\"showUpdateSetValueDynamicallyToggle\",true,\"bulkUpdatePrimaryKey\",\"\",\"runWhenPageLoads\",false,\"transformer\",\"// type your code here\\n// example: return formatDataAsArray(data).filter(row => row.quantity > 20)\\nreturn data\",\"events\",[\"^:\",[[\"^3\",[\"event\",\"success\",\"type\",\"datasource\",\"method\",\"invalidateCache\",\"pluginId\",\"imageQuery\",\"targetId\",null,\"params\",[\"^3\",[]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]],[\"^3\",[\"event\",\"success\",\"type\",\"datasource\",\"method\",\"trigger\",\"pluginId\",\"imageQuery\",\"targetId\",null,\"params\",[\"^3\",[]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]]]],\"tableName\",\"move2023\",\"queryTimeout\",\"10000\",\"requireConfirmation\",false,\"queryFailureConditions\",\"\",\"changesetIsObject\",false,\"enableCaching\",false,\"allowedGroups\",[\"^:\",[]],\"databaseUsernameOverride\",\"\",\"shouldEnableBatchQuerying\",false,\"doNotThrowOnNoOp\",false,\"offlineQueryType\",\"None\",\"queryThrottleTime\",\"750\",\"updateSetValueDynamically\",false,\"notificationDuration\",\"\"]],\"^;\",null,\"^<\",null,\"^=\",null,\"^>\",null,\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672293194408\",\"^B\",\"~m1672293992506\",\"^C\",\"\",\"^D\",null]]],\"fab\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"fab\",\"^4\",\"widget\",\"^5\",\"RNFabWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"events\",[\"^:\",[[\"^3\",[\"event\",\"click\",\"type\",\"widget\",\"method\",\"open\",\"pluginId\",\"scanner\",\"targetId\",null,\"params\",[\"^3\",[]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]]]],\"icon\",\"bold/interface-id-iris-scan-alternate\",\"text\",\"\",\"disabled\",false]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",5,\"^K\",3,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",0]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672294273803\",\"^B\",\"~m1672294305227\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"stageUpdate\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"stageUpdate\",\"^4\",\"datasource\",\"^5\",\"SqlQueryUnified\",\"^6\",null,\"^7\",\"89790bb1-c4cd-4abe-8561-a3caa51091bf\",\"^8\",\"retool_db\",\"^9\",[\"^3\",[\"queryRefreshTime\",\"\",\"records\",\"\",\"lastReceivedFromResourceAt\",null,\"databasePasswordOverride\",\"\",\"queryDisabledMessage\",\"\",\"servedFromCache\",false,\"successMessage\",\"\",\"queryDisabled\",\"\",\"playgroundQuerySaveId\",\"latest\",\"resourceNameOverride\",\"\",\"runWhenModelUpdates\",false,\"showFailureToaster\",true,\"query\",\"\",\"playgroundQueryUuid\",\"\",\"playgroundQueryId\",null,\"error\",null,\"privateParams\",[\"^:\",[]],\"runWhenPageLoadsDelay\",\"\",\"data\",null,\"recordId\",\"\",\"importedQueryInputs\",[\"^3\",[]],\"isImported\",false,\"showSuccessToaster\",true,\"dataArray\",[\"^:\",[]],\"cacheKeyTtl\",\"\",\"filterBy\",\"[{\\\"key\\\":\\\"barcode\\\",\\\"value\\\":\\\"{{barcode.value}}\\\",\\\"operation\\\":\\\"=\\\"}]\",\"requestSentTimestamp\",null,\"databaseHostOverride\",\"\",\"metadata\",null,\"editorMode\",\"gui\",\"queryRunTime\",null,\"actionType\",\"UPDATE_BY\",\"changesetObject\",\"\",\"shouldUseLegacySql\",false,\"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\",\"finished\",null,\"databaseNameOverride\",\"\",\"confirmationMessage\",null,\"isFetching\",false,\"changeset\",\"[{\\\"key\\\":\\\"scan_stage\\\",\\\"value\\\":\\\"{{stageInput.value}}\\\"}]\",\"rawData\",null,\"queryTriggerDelay\",\"0\",\"resourceTypeOverride\",null,\"watchedParams\",[\"^:\",[]],\"enableErrorTransformer\",false,\"enableBulkUpdates\",false,\"showLatestVersionUpdatedWarning\",false,\"timestamp\",0,\"importedQueryDefaults\",[\"^3\",[]],\"enableTransformer\",false,\"showUpdateSetValueDynamicallyToggle\",true,\"bulkUpdatePrimaryKey\",\"\",\"runWhenPageLoads\",false,\"transformer\",\"// type your code here\\n// example: return formatDataAsArray(data).filter(row => row.quantity > 20)\\nreturn data\",\"events\",[\"^:\",[[\"^3\",[\"event\",\"success\",\"type\",\"datasource\",\"method\",\"trigger\",\"pluginId\",\"dataQuery\",\"targetId\",null,\"params\",[\"^3\",[]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]]]],\"tableName\",\"move2023\",\"queryTimeout\",\"10000\",\"requireConfirmation\",false,\"queryFailureConditions\",\"\",\"changesetIsObject\",false,\"enableCaching\",false,\"allowedGroups\",[\"^:\",[]],\"databaseUsernameOverride\",\"\",\"shouldEnableBatchQuerying\",false,\"doNotThrowOnNoOp\",false,\"offlineQueryType\",\"None\",\"queryThrottleTime\",\"750\",\"updateSetValueDynamically\",false,\"notificationDuration\",\"\"]],\"^;\",null,\"^<\",null,\"^=\",null,\"^>\",null,\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672294737620\",\"^B\",\"~m1672294871188\",\"^C\",\"\",\"^D\",null]]],\"stageInput\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"stageInput\",\"^4\",\"widget\",\"^5\",\"RNNumberInputWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"iconAfter\",\"\",\"maxLength\",null,\"customValidation\",\"\",\"hideValidationMessage\",false,\"allowNegativeNumbers\",false,\"validationMessage\",\"\",\"formDataKey\",\"{{ self.id }}\",\"value\",\"{{dataQuery.data.scan_stage[0]}}\",\"labelCaption\",\"\",\"placeholder\",0,\"showStepper\",false,\"label\",\"Scan stage\",\"_validate\",false,\"invalid\",false,\"iconBefore\",\"\",\"minLength\",null,\"events\",[\"^:\",[[\"^3\",[\"event\",\"submit\",\"type\",\"datasource\",\"method\",\"trigger\",\"pluginId\",\"stageUpdate\",\"targetId\",null,\"params\",[\"^3\",[]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]]]],\"disabled\",false,\"required\",false]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"mainView\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",5,\"^K\",3,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",4]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672294776903\",\"^B\",\"~m1672294831597\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"stepTItle\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"stepTItle\",\"^4\",\"widget\",\"^5\",\"RNHeadingWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"value\",\"{{item.title}}\",\"size\",\"h4\",\"width\",\"full\",\"textAlign\",\"left\"]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"stepText\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",5,\"^K\",3,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",0]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672295333112\",\"^B\",\"~m1672295392542\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"stepText\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"stepText\",\"^4\",\"widget\",\"^5\",\"RNContainerWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"events\",[\"^3\",[]],\"cornerType\",\"square\",\"layout\",\"column\",\"justify\",\"flex-start\",\"align\",\"flex-start\",\"gap\",0,\"padding\",[\"^3\",[\"left\",8,\"right\",8,\"top\",0,\"bottom\",0]],\"width\",\"full\"]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"stepRow\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",5,\"^K\",3,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",0]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672295354075\",\"^B\",\"~m1672297668549\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"cameraRow\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"cameraRow\",\"^4\",\"widget\",\"^5\",\"RNContainerWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"events\",[\"^3\",[]],\"cornerType\",\"square\",\"layout\",\"row\",\"justify\",\"flex-start\",\"align\",\"flex-start\",\"gap\",4,\"padding\",[\"^3\",[\"left\",0,\"right\",0,\"top\",0,\"bottom\",0]],\"width\",\"full\"]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"mainView\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",5,\"^K\",3,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",3]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672295844383\",\"^B\",\"~m1672296368299\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"open\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"open\",\"^4\",\"widget\",\"^5\",\"RNWebViewWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"iconAfter\",\"\",\"width\",\"fixed\",\"hidden\",\"{{ !imageQuery.data.image[0] || (imageQuery.data.image[0].startsWith('data:')) }}\",\"url\",\"{{ imageQuery.data.image[0] }}\",\"buttonSize\",\"small\",\"iconBefore\",\"\",\"events\",[\"^:\",[]],\"disabled\",false,\"buttonText\",\"Open\"]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"cameraRow\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",0,\"^K\",0,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",2]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672296053499\",\"^B\",\"~m1672296977653\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"download\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"download\",\"^4\",\"widget\",\"^5\",\"RNButtonWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"size\",\"small\",\"iconAfter\",\"\",\"width\",\"fixed\",\"hidden\",\"true\",\"text\",\"Download\",\"iconBefore\",\"\",\"events\",[\"^:\",[[\"^3\",[\"event\",\"click\",\"type\",\"script\",\"method\",\"run\",\"pluginId\",\"\",\"targetId\",null,\"params\",[\"^3\",[\"src\",\"let base64string = imageQuery.data.image[0].substring(imageQuery.data.image[0].indexOf(',')+1);\\nlet type = imageQuery.data.image[0].substring(imageQuery.data.image[0].indexOf('/')+1, imageQuery.data.image[0].indexOf(';'));\\n\\nutils.downloadFile({base64Binary: base64string}, barcode.value, type);\"]],\"waitType\",\"debounce\",\"waitMs\",\"0\"]]]],\"type\",\"primary\",\"loading\",false,\"disabled\",false]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"cameraRow\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",0,\"^K\",0,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",3]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672296352880\",\"^B\",\"~m1672296967715\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]],\"mainView\",[\"^0\",[\"^ \",\"n\",\"pluginTemplate\",\"v\",[\"^ \",\"id\",\"mainView\",\"^4\",\"widget\",\"^5\",\"RNContainerWidget\",\"^6\",null,\"^7\",null,\"^8\",null,\"^9\",[\"^3\",[\"align\",\"flex-start\",\"width\",\"full\",\"hidden\",\"{{!barcode.value}}\",\"layout\",\"column\",\"cornerType\",\"square\",\"justify\",\"flex-start\",\"padding\",[\"^3\",[\"left\",0,\"right\",0,\"top\",0,\"bottom\",0]],\"gap\",0,\"events\",[\"^3\",[]]]],\"^;\",[\"^3\",[]],\"^<\",[\"^0\",[\"^ \",\"n\",\"position2\",\"v\",[\"^ \",\"^@\",\"\",\"^H\",\"body\",\"^I\",\"\",\"row\",0,\"col\",0,\"^J\",5,\"^K\",3,\"^L\",0]]],\"^=\",null,\"^>\",[\"^0\",[\"^ \",\"n\",\"mobileAppPosition\",\"v\",[\"^ \",\"^M\",2]]],\"^?\",null,\"^@\",\"\",\"^A\",\"~m1672297153735\",\"^B\",\"~m1672297227835\",\"^C\",\"\",\"^D\",\"scannerScreen\"]]]]],\"^A\",null,\"version\",\"2.106.2\",\"appThemeId\",null,\"preloadedAppJavaScript\",null,\"preloadedAppJSLinks\",[],\"testEntities\",[],\"tests\",[],\"appStyles\",\"\",\"responsiveLayoutDisabled\",false,\"loadingIndicatorsDisabled\",false,\"urlFragmentDefinitions\",[\"^:\",[]],\"pageLoadValueOverrides\",[\"^:\",[]],\"customDocumentTitle\",\"\",\"customDocumentTitleEnabled\",false,\"customShortcuts\",[],\"isGlobalWidget\",false,\"isMobileApp\",true,\"multiScreenMobileApp\",true,\"mobileAppSettings\",[\"^ \",\"mobileOfflineModeEnabled\",false],\"folders\",[\"^:\",[]],\"queryStatusVisibility\",false,\"markdownLinkBehavior\",\"auto\",\"inAppRetoolPillAppearance\",\"NO_OVERRIDE\",\"rootScreen\",\"tabscreen\",\"instrumentationEnabled\",false,\"experimentalPerfFeatures\",[\"^ \",\"serverDepGraphEnabled\",false,\"useRuntimeV2\",false],\"experimentalStabilityFeatures\",[\"^ \",\"lockModelForUpdates\",false],\"experimentalDataTabEnabled\",true]]]"},"changesRecord":[{"type":"WIDGET_TEMPLATE_UPDATE","payload":{"plugin":{"id":"stepText","type":"widget","style":{},"folder":"","screen":"scannerScreen","subtype":"RNContainerWidget","tabIndex":null,"template":{"gap":0,"align":"flex-start","width":"full","events":{},"layout":"column","justify":"flex-start","padding":{"top":0,"left":0,"right":0,"bottom":0},"cornerType":"square"},"container":"","createdAt":"2022-12-29T06:29:14.075Z","namespace":null,"position2":{"col":0,"row":0,"width":3,"height":5,"tabNum":0,"rowGroup":"body","container":"stepRow","subcontainer":""},"updatedAt":"2022-12-29T07:07:45.124Z","resourceName":null,"mobilePosition2":null,"mobileAppPosition":{"ordinal":0},"resourceDisplayName":null},"update":{"padding":{"top":0,"left":8,"right":8,"bottom":0}},"widgetId":"stepText","shouldRecalculateTemplate":true},"isUserTriggered":true}],"gitSha":null,"checksum":null,"createdAt":"2022-12-29T07:07:50.334Z","updatedAt":"2022-12-29T07:07:50.334Z","pageId":1699463,"userId":462331,"branchId":null},"modules":{}}
id updated_at created_at barcode image content scan1 scan2 scan3 scan4 scan_stage
1 2022-12-28 00:00:00.00000+00 2022-12-28 00:00:00.00000+00 202212-01 https://s3.us-west-2.amazonaws.com/nonexisting.jpg Content 2022-12-28 00:00:00.000+00 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment