投稿時間:2023-04-26 18:30:48 RSSフィード2023-04-26 18:00 分まとめ(35件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
ROBOT	ロボスタ	ミッキーマウス仕様の『LOVOT』販売好調　販売期間を延長　渋谷など全国6ヶ所で展示キャラバン開催　ミッキー仕様のLOVOTに会える	https://robotstart.info/2023/04/26/micky-lovot-extension.html		2023-04-26 08:39:57
IT	ITmedia 総合記事一覧	[ITmedia News] 日本の量子技術情報が丸分かり　理研や内閣府がポータルサイト公開　新情報・学習コンテンツなど集約	https://www.itmedia.co.jp/news/articles/2304/26/news167.html	itmedia	2023-04-26 17:45:00
IT	ITmedia 総合記事一覧	[ITmedia News] エプソン、プリンタ用インクなど値上げ　スマートグラスも	https://www.itmedia.co.jp/news/articles/2304/26/news161.html	itmedia	2023-04-26 17:03:00
TECH	Techable（テッカブル）	学習塾業界必見！「選ばれる塾」になるために注意すべき3つの誤解とは？	https://techable.jp/archives/204697	市場規模	2023-04-26 08:30:29
TECH	Techable（テッカブル）	VTuber小日向ぽんのコラボグッズが販売開始！ レザーポーチなど全6種類	https://techable.jp/archives/204738	vtuber	2023-04-26 08:06:17
IT	情報システムリーダーのためのIT情報専門サイト IT Leaders	国内大手企業の75%がSBOMを認知、14%は導入済み、詳細の把握が難しい課題も─タニウム調査 | IT Leaders	https://it.impress.co.jp/articles/-/24776	国内大手企業のがSBOMを認知、は導入済み、詳細の把握が難しい課題もータニウム調査ITLeadersエンドポイントセキュリティ製品を手がける米タニウムTaniumの日本法人、タニウムは年月日、SBOMソフトウェア部品表の認知度や取り組みについて国内企業を対象に調査した結果を発表した。	2023-04-26 17:12:00
python	Pythonタグが付けられた新着投稿 - Qiita	GPUメモリ8GBでStable Diffusionを動かす	https://qiita.com/golyat/items/dfd1dd58c89a6d570caf	windowspythoncudatorchcu	2023-04-26 17:51:01
Ruby	Rubyタグが付けられた新着投稿 - Qiita	Rubyの特異メソッドについて	https://qiita.com/pyon_kiti_jp/items/f6b872431c5fb29e8333	ubunturuby	2023-04-26 17:12:41
AWS	AWSタグが付けられた新着投稿 - Qiita	Vue.jsでフロントエンドアプリケーション開発（その３：Amazon S3上で動かしてみる）	https://qiita.com/tonarinohamuhamu/items/6297be4a46f5ac6a879c	amazons	2023-04-26 17:22:41
AWS	AWSタグが付けられた新着投稿 - Qiita	自分用GPTサービスをAWS Copilot CLI × AWS App Runner × Chatbot UIでホスティングする	https://qiita.com/watany/items/8bff48e1cd65e1c33b16	apprunner	2023-04-26 17:02:20
Docker	dockerタグが付けられた新着投稿 - Qiita	docker UnixHTTPConnectionPool Read timed out エラー(メモ)	https://qiita.com/rikuto125/items/4b65b886cbc231d039c5	errorforpostgresunixht	2023-04-26 17:57:50
Git	Gitタグが付けられた新着投稿 - Qiita	【エラー】SourceTreeで「git applyがコード1で終了しました」と出たときの直し方	https://qiita.com/kyosinari/items/26a799797b5416156a52	gitapply	2023-04-26 17:30:34
海外TECH	DEV Community	Top 21 AWS Services to Optimize Your Cloud Deployment	https://dev.to/imsampro/top-21-aws-services-to-optimize-your-cloud-deployment-3ji4	Top AWS Services to Optimize Your Cloud DeploymentCloud deployment has grown in popularity recently as businesses seek a more cost effective and scalable infrastructure Amazon Web Services AWS is one of the leading cloud providers offering a wide range of services to meet a variety of corporate requirements They have over services to select from making it difficult to identify which ones are appropriate for your cloud setup We ll go through the top AWS services that can assist improve your cloud deployment including all of the major features and advantages This article will assist you in determining which AWS services will boost your cloud operations and company success Introduction to AWS ServicesAmazon Web Services AWS is one of the most popular cloud computing options for organizations of all kinds AWS offers a variety of cloud based services that can assist organizations in optimizing and streamlining their IT infrastructure In this post we ll look at the top AWS services for optimizing your cloud setup What are AWS Services AWS services are cloud based computing services provided by Amazon to its clients These services let enterprises to execute apps and store data in the cloud rather than on local servers AWS services are scalable adaptable and dependable and they may assist enterprises in lowering IT expenses and increasing efficiency Why Should You Use AWS Services for Cloud Deployment There are several advantages to using AWS services for cloud deployment AWS is well known for its dependability and scalability AWS services may assist organizations in swiftly and effectively scaling up or down their IT infrastructure as their needs change AWS services also offer a high degree of security and compliance which is critical for enterprises that must secure sensitive data AWS services are also cost effective since businesses just pay for the resources they utilize Computing Services for Optimal Cloud DeploymentElastic Compute Cloud EC Amazon Elastic Compute Cloud EC is a scalable cloud computing solution that enables enterprises to operate cloud based applications and workloads Businesses may use EC to deploy virtual machines choose the operating system and software they want and scale their infrastructure up or down as needed EC is a low cost and adaptable option for organizations of all sizes EC Container ServiceThe Amazon EC Container Solution is a scalable and high performance container management service that makes running and managing Docker containers on EC instances simple Businesses can quickly install manage and grow Docker applications in the cloud with EC Container Service LambdaAWS Lambda is a serverless computing solution that enables enterprises to run code without the need for server setup or management Businesses may use Lambda to develop code in a number of languages submit it to AWS and run it in response to events Lambda is an efficient and cost effective option for enterprises that require rapid and easy code execution Storage Services for Efficient Data ManagementSimple Storage Service S Amazon Simple Storage Solution S is a scalable and long lasting object storage service that allows enterprises to store and retrieve data from any location on the internet Businesses may use S to store and manage massive quantities of data while only paying for the storage they utilize S is a low cost option for enterprises of all sizes Elastic Block Store EBS Amazon Elastic Block Store EBS is a block storage solution that offers Amazon EC instances with persistent storage Businesses may use EBS to build and manage volumes that can be linked to EC instances as well as scale their storage up or down as needed EBS is a dependable and cost effective cloud storage and management solution GlacierAmazon Glacier is a low cost archival storage solution for enterprises that allows them to store data for long term retention Businesses may use Glacier to store data that is seldom accessed and only pay for the storage they use Glacier is a low cost and dependable option for long term data storage Database Services for Streamlined Data ProcessingRelational Database Service RDS Amazon Relational Database Solution RDS is a cloud based database management service that enables enterprises to effortlessly install and grow relational databases Businesses may use RDS to pick from a number of database engines including MySQL PostgreSQL and Oracle and conveniently maintain their databases with automated backups and software upgrades DynamoDBAmazon DynamoDB is a scalable NoSQL database service with seamless scaling and quick and predictable performance Businesses may use DynamoDB to store and retrieve unlimited quantity of data as well as flexibly scale their database up or down as needed DynamoDB is a low cost and adaptable option for enterprises that want scalable NoSQL databases ElasticacheAmazon ElastiCache is a managed in memory data storage service that enables enterprises to develop and run high performance caching applications in the cloud Businesses may use ElastiCache to quickly create and manage Memcached or Redis cache clusters improving application speed and scalability ElastiCache is a dependable and affordable solution for enterprises that want high performance caching Networking Services for Reliable Cloud ConnectivityVirtual Private Cloud VPC VPC is a secure and segregated virtual network that enables the deployment of AWS services into a virtual network that closely mimics a regular network You may use VPC to manage your virtual networking environment such as IP address ranges subnets and route tables Route Route is a highly scalable and dependable DNS web service that directs customers to your apps You may use Route to handle domain names and traffic routing to AWS services like EC instances load balancers and S buckets Direct ConnectDirect Link is a dedicated network connection that allows you to connect your on premises equipment to AWS via a private high bandwidth connection Direct Connect allows you to avoid using the public internet and establish a more secure and dependable access to your AWS resources Security Services for Enhanced Cloud ProtectionIdentity and Access Management IAM IAM is a powerful tool for securely managing access to AWS resources You can use IAM to create and manage users and groups issue permissions and manage access to AWS resources Web Application Firewall WAF WAF stands for web application firewall and it protects your online applications from typical attacks and vulnerabilities WAF allows you to set security rules that accept prohibit or monitor web application traffic GuardDutyGuardDuty is a threat detection service that monitors your AWS resources for malicious activity and illegal access in real time You can detect and manage possible security issues using GuardDuty before they become a problem Analytics Services for Better Data InsightsAthenaAthena is an interactive query service that allows you to use conventional SQL to explore data in Amazon S With Athena you can analyze massive datasets fast and simply without the need for sophisticated infrastructure RedshiftRedshift is a high performance fully managed data warehouse that can store and analyze petabyte scale data You may execute complicated queries across various data sources with Redshift and gain quicker insights from your data Elasticsearch ServiceElasticsearch Service is a fully managed search and analytics service that enables real time data search analysis and visualization You may create sophisticated search and analytics apps with Elasticsearch Service without the need for complicated infrastructure Management Services for Seamless Cloud OperationsCloudFormationCloudFormation is a service that allows you to write code to create and provision AWS infrastructure You may use CloudFormation to automate infrastructure deployment and guarantee that your resources are handled consistently and securely CloudTrailCloudTrail is a service that logs API calls made on your AWS account and sends you the log files CloudTrail allows you to track changes to your AWS resources and address operational issues OpsWorksOpsWorks is a fully managed configuration management solution that automates operational duties including deployment monitoring and maintenance You may use OpsWorks to guarantee that your apps perform smoothly and effectively ConclusionSo AWS has a whole bunch of cloud services that can help all types of companies get on board with the cloud And if you pick the right ones you can make your cloud stuff work better and save money too Hopefully this article gave you some good ideas on which AWS services to use for your cloud setup FAQWhat is AWS and what services does it offer AWS stands for Amazon Web Services which is a cloud computing platform that offers over services including computing storage database networking security analytics and management services Can I use AWS services for free AWS offers a free tier that includes certain services free of charge for a limited period After the free period expires you ll be charged according to your usage Make sure to check the pricing details for each service before using it How do I choose the right AWS services for my business Choosing the right AWS services depends on your business needs and goals Consider factors such as your workload data volume scalability requirements and budget You can also consult with AWS experts or partners to help you identify the most suitable services for your cloud deployment What kind of support does AWS offer for its services AWS provides different levels of support for its services including basic developer business and enterprise support Each level offers different features and benefits such as support response time and access to AWS resources You can choose the level of support that best fits your needs and budget Thank you for reading Soumyadeep Mandal imsampro	2023-04-26 08:52:52
海外TECH	DEV Community	x-crawl v7 has been released	https://dev.to/coderhxl/x-crawl-v7-has-been-released-54pk	x crawl v has been released x crawlx crawl is a flexible Node js multipurpose crawler library The usage is flexible and there are many built in functions for crawl pages crawl interfaces crawl files etc If you also like x crawl you can give x crawl repository a star to support it thank you for your support FeaturesAsynchronous Synchronous Just change the mode property to toggle asynchronous or synchronous crawling mode ️Multiple purposes It can crawl pages crawl interfaces crawl files and poll crawls to meet the needs of various scenarios ️Flexible writing style The same crawling API can be adapted to multiple configurations and each configuration method is very unique ️Interval Crawling No interval fixed interval and random interval to generate or avoid high concurrent crawling Failed Retry Avoid crawling failure due to short term problems and customize the number of retries ️Proxy Rotation Auto rotate proxies with failure retry custom error times and HTTP status codes Device Fingerprinting Zero configuration or custom configuration avoid fingerprinting to identify and track us from different locations Priority Queue According to the priority of a single crawling target it can be crawled ahead of other targets ️Crawl SPA Crawl SPA Single Page Application to generate pre rendered content aka SSR Server Side Rendering ️Control Page You can submit form keyboard input event operation generate screenshots of the page etc Capture Record Capture and record crawling and use colored strings to remind in the terminal TypeScript Own types implement complete types through generics ExampleTake the automatic acquisition of some photos of experiences and homes around the world every day as an example Import module ES CJSimport xCrawl from x crawl Create a crawler instanceconst myXCrawl xCrawl maxRetry intervalTime max min Set the crawling task Call the startPolling API to start the polling function and the callback function will be called every other day myXCrawl startPolling d async count stopPolling gt Call crawlPage API to crawl Page const res await myXCrawl crawlPage targets viewport width height Store the image URL to targets const targets const elSelectorMap figy aovj for const item of res const id item const page item data Wait for the page to load await new Promise r gt setTimeout r Gets the URL of the page image const urls await page eval elSelectorMap id img imgEls gt return imgEls map item gt item src targets push urls Close page page close Call the crawlFile API to crawl pictures myXCrawl crawlFile targets storeDir upload running result Note Do not crawl at will you can check the robots txt protocol before crawling This is just to demonstrate how to use x crawl MoreFor more detailed documentation please check	2023-04-26 08:46:02
海外TECH	DEV Community	Step By Step Quick Guide: How to Create an Ecommerce App?	https://dev.to/quokkalabs/step-by-step-quick-guide-how-to-create-an-ecommerce-app-37ml	Step By Step Quick Guide How to Create an Ecommerce App In this fast paced digital world learning how to create an ecommerce app is no longer new You can find guides anywhere However the crucial point is how to create an ecommerce app that enhances the customer experience and improves customer retention The most critical touchpoint is providing a seamless mobile and web experience With over of traffic coming from mobile devices sales through mobile ecommerce apps are increasing To achieve this it is essential to partner with an ecommerce app development company to develop an effective ecommerce app that attracts more visitors increases sales and retains customers Therefore before contacting an ecommerce app development company for your eCommerce mobile app development it is crucial to follow a step by step guide on creating an ecommerce app Let s dive deep into it Step By Step Guide How to Create an Ecommerce AppIn this quick step by step guide I recommend choosing a trusted company for ecommerce app development because it requires experienced professionals to make it competitive in the market and ensure long term success Define Your Ecommerce App Goals Before You Create an Ecommerce AppThe first but most crucial step is defining your and your app s goals before you start to create an ecommerce app You should be clear about what type of benefits you need from your retail business Few ecommerce apps are popular nowadays in the market Let s have a look BC BB BG Business to Government BBC CC CB Ask these questions yourself before developing an ecommerce app Your primary purpose for developing an eCommerce app Your current and future goals How will the app allow the business to increase sales What is the issue you want to solve with your mobile ecommerce appNow here I have collected some ideas for developing an ecommerce app Fashion Jewlery market AR VR headsets and accessory storesVape hardware flavor and liquidsSmart Home products and accessoriesOnline learning platformsNiche subscription boxesOnline groceries and foodsPet foodsWedding goods And more…But but but if you don t want to waste time reading this blog I suggest directly reaching out to an ecommerce app development company for your mobile ecommerce app development Identify Your Target AudienceThis is the next stage where you must decide which audience you target by developing an ecommerce app Here you have to check that you are developing where there is a demand for your app You can also consider some unique mobile ecommerce app features to take advantage of You must make a user persona to get the target audience correctly Analyze The Market CompetitionThis is the third stage where you must analyze the market competition Just blindly developing an ecommerce app doesn t make sense There is massive competition in the world You need to check our direct and indirect competitors like Google Play Store Apple app store and other places A unique ecommerce app development makes users go WOW So considering them mobile app development of that ecommerce app should also be individual for users and problem solvers At last point make sure you are developing an ecommerce app for a large audience not just specific audiences Now let s see the next stage Define The Main Features of an Ecommerce AppThe features are the heart and the blood of your mobile ecommerce app When you create an ecommerce app the features must be the priority which should be the problem solver for users by giving the best UX Here I have collected a list that should be added while developing an ecommerce app User onboarding Authorization User profile Multiple payment systems Rate comment and review products Push notifications Quick checkout Wishlist Admin panel And other components Monetization Model SelectionNow this is the step where your business starts earning after ecommerce app development In this stage you can recover the cost of your mobile ecommerce app by monetization Below I have created some examples to consider adding to your monetization plan Offering in app purchases Freemium model Subscription model Create An Attractive Design for an Ecommerce appAfter choosing the right features and the suitable monetization model this step comes afterward This stage is most important because it needs to be visually appealing to the audience It s all about the design of a mobile ecommerce app to be successful Here designing an ecommerce app means knowing your target audience s desire and problem and serving them what they want and how they can easily access it Here I have created some valuable points you can consider while designing an ecommerce app Make the app simple to use and avoid hard things that take time to understand Research how users use the app and design it in such a way Remove unneeded components from the app Add a user navigation button Focus on the first time experience with animation that is catchy and appealing And other more Avoid these things while designing an ecommerce appDon t mix UI and UX Avoid low contrast fonts and layouts Don t get confused about adding a feedback mechanism Select A Right Mobile App Development Platform to Create an Ecommerce AppIn simple terms this matters extraordinarily when you are into ecommerce app development Focus on what platforms you want to reach like Android iOS Windows and more Here hybrid app development of cross platform app development comes in handy when you want to get a bigger audience with less budget So developing an ecommerce app is all about the budget and audience you want to target You can also go for Native app development but you will only get one platform app for Android or iOS The decision is yours If you are confused contact the ecommerce app development company for a quick solution Start Developing an Ecommerce AppYou can start converting your design to a fully fledged mobile ecommerce app at this stage It s recommended to go for MVP app development which helps fix many problems that come later after developing an ecommerce app You can reach a good ecommerce app development company for MVP development You may have a question right now What will be the cost of developing an ecommerce app For that you can contact a good company for round figures Testing Ecommerce AppWe have seen how to create an ecommerce app in the above steps but now it s time to test it after developing an eCommerce app Testing an ecommerce app is most important because a tiny bug can ruin the whole user experience that you want to let happen In testing you must look at many factors like user experience responsiveness navigation data security loading time battery consumption resource consumption secure transaction etc If you reach the ecommerce app development company for your ecommerce mobile app development they will do it thoroughly for you Release Launch Your Ecommerce AppNow in this stage it s time to release publish our app on app stores like Google Play Store and Apple store after developing an eCommerce app When you create an ecommerce app you may have already decided on what platforms you want to focus on So start uploading apps on suitable platforms like Google Play Store and Apple App store You can upload necessary screenshots descriptions short videos and more on these platforms But if you have a connection with an ecommerce app development company they will do it for you Market Your AppNow it s time to market your app for more traffic to your app Ensure your app is entirely bug free to give a fluid experience to users A fluid experience on the app works like word of mouth and this mobile ecommerce app can grow crazy You can market your app by using the methods below for more traffic Landing pages App store optimization Social media That s it for now We are not going into every detail If you want any assistance you can contact the ecommerce app development company for solutions for your ecommerce app development Final Wise Words This post presents a step by step procedure for developing an ecommerce app The current market provides an excellent opportunity for new ecommerce mobile apps to enter the market The key is understanding the user s problems and providing them with the best experience through unique features Currently ecommerce companies earn millions of dollars daily and you can also succeed in this field Do you have an idea for developing an ecommerce app You can reach out to an ecommerce app development company and they will handle all the tasks for you Thank you for reading Please share this blog with others so that they can benefit from it as well FAQsWhat are some factors to consider when choosing a development platform for my ecommerce app When choosing a development platform consider factors such as scalability security customization options and integration capabilities Additionally consider the target audience and their preferred devices and operating systems How can I ensure that my ecommerce app is secure To ensure the security of your ecommerce app implement measures such as two factor authentication encryption secure payment processing and regular security updates Additionally conduct regular security audits to identify and address potential vulnerabilities How can I optimize the user experience of my ecommerce app To optimize the user experience of your ecommerce app focus on factors such as navigation search functionality product information and images checkout process and personalized recommendations Additionally conduct user testing and gather feedback to identify areas for improvement What are some effective marketing strategies for promoting my ecommerce app Effective marketing strategies for promoting your ecommerce app include social media advertising email marketing influencer partnerships search engine optimization and targeted promotions and discounts Additionally gather and analyze data on user behavior and preferences to inform your marketing strategies How can I leverage data and analytics to improve my ecommerce app To leverage data and analytics to improve your ecommerce app track metrics such as user engagement conversion rates and customer feedback Use this data to identify areas for improvement and to inform decisions related to product offerings marketing strategies and user experience enhancements	2023-04-26 08:23:27
海外TECH	DEV Community	Power Apps, How many ways to make a Calculator	https://dev.to/wyattdave/power-apps-how-many-ways-to-make-a-calculator-5aeh	Power Apps How many ways to make a CalculatorLowCode is sometimes thought of as simple and repeatable There are fewer building blocks so there is only one way to solve a problem And although this is kind of true it s not quite times out of there will be an out of the box solution that is quick and easy to implement but there are times and ways to be more creative And that is where most of the fun comes from One of the few missing out of the box solutions in Power Apps is calculators so I thought I would look at all the different ways we could create a calculator and what I can learn So how many ways can you create a calculator well I found at least Standard ButtonsGalleryCodeTimerAbacus Standard The idea is pretty simple each number and operator is its own button component We have variables vsOne First numbervsTwo Second number set to so we know it s not used vsCalc OperatorvsEquals Show resultviValue resultIn a nut shell we hold first value in vsOne and on operator we store operator and set vsTwo to and store next numbers in there Then on equals we use switch based on operator to complete the action Reset ButtonSet vsOne Set vsTwo Set vsCalc Set vbEquals false Set viValue Number ButtonIf vsTwo Set vsOne Value vsOne amp Self Text amp Set vsTwo Value vsTwo amp Self Text amp Operator Button Set vsCalc Self Text If vsTwo Set vsTwo Set viValue Value vsOne Value vsTwo Set vsOne viValue amp Set vsTwo Equals ButtonSwitch vsCalc Set viValue Value vsOne Value vsTwo Set viValue Value vsOne Value vsTwo Set viValue Value vsOne Value vsTwo Set viValue Value vsOne Value vsTwo Set vsOne viValue amp Set vsTwo GalleryThe Gallery approach is similar to the buttons but has the advantage of automatically positioning all the buttons The gallery requires the following array of items C We then roll all the OnSelect code as they all the buttons use the same code All ButtonsIf IsNumeric Self Text If vsTwo Set vsOne Value vsOne amp Self Text amp Set vsTwo Value vsTwo amp Self Text amp If Self Text Switch vsCalc Set viValue Value vsOne Value vsTwo Set viValue Value vsOne Value vsTwo Set viValue Value vsOne Value vsTwo Set viValue Value vsOne Value vsTwo Set vsOne viValue amp Set vsTwo If Self Text C Set vsOne Set vsTwo Set vsCalc Set vbEquals false Set viValue Set sPrint Set vsCalc Self Text If vsTwo Set vsTwo Switch Self Text Set viValue Value vsOne Value vsTwo Set viValue Value vsOne Value vsTwo Set viValue Value vsOne Value vsTwo Set viValue Value vsOne Value vsTwo Set vsOne viValue amp Set vsTwo CodeThis one I personally think is pretty cool instead of using buttons why not user the keyboard We have a similar approach but this time we don t save to variables but a single row in a collectionUnfortunately there was no easy way to use a Regex well one I could find so my approach was to split the input into an array and then loop over each character saving appending to the single row array which we use as an object to store variables as you can t set in a ForAll loop The logic isIf is number and no operator saved append to key one as this is the first number in the formula If is number but operator saved append to key two as this is the second number in the formula Else set to operator as we know its not a number After ForAll finished use operator to select formula and display resultsEquals ButtonClearCollect colInput Split inCalcCode Text Set viValue ClearCollect colResult one operator two value id ForAll colInput If IsNumeric ThisRecord Value amp amp Index colResult operator Patch colResult id one Index colResult one amp ThisRecord Value If IsNumeric ThisRecord Value Patch colResult id two Index colResult two amp ThisRecord Value Patch colResult id operator ThisRecord Value Switch Index colResult operator Set viValue Value Index colResult one Value Index colResult two Set viValue Value Index colResult one Value Index colResult two Set viValue Value Index colResult one Value Index colResult two Set viValue Value Index colResult one Value Index colResult two Set vbResult true Timer As I have mentioned before Timers are another more flexible way to do loops in Power Apps The approach is similar to the Code ForAll loop approach with a few small differences As this is more a For loop we don t increment over each item but count and do an index comparison And as we can now Set variables we don t need our single row collection Equals ButtonClearCollect colInput Split inCalcTimer Text Set vsOne Set vsNumber Set viValue Set i Set vbResult false Set vsCalc Set vbCalc true This time we are going to Incement over every item from the split string When we hit the length we stop the loop select the formula and show the result If less then length we check if is number and vsCalc is blank as then we know if first or second part of formula If it is both we append to vsNumberIf it is number but vsCalc is not blank then we check to see if vsOne is blank if it is we copy vsNumber over and clear vsNumbner ready for second number in formula Then we append again to vsNumber Finally if it is not numeric then we save is as vsCal as we know it is the operator StartvbCalcRepeatvbCalcOnTimerEndIf i gt CountRows colInput Set vbCalc false Set vbResult true Switch vsCalc Set viValue Value vsOne Value vsNumber Set viValue Value vsOne Value vsNumber Set viValue Value vsOne Value vsNumber Set viValue Value vsOne Value vsNumber Reset inCalcTimer If IsNumeric Index colInput i Value If vsCalc Set vsNumber vsNumber amp Index colInput i Value If vsOne Set vsOne vsNumber Set vsNumber Set vsNumber vsNumber amp Index colInput i Value Set vsCalc Index colInput i Value Set i i AbacusWant to go truly innovative then lowCode and Power Apps has got your back Why use a calculator when you can use an abacus The abacus is built by aligning gallery s with the right the unused beads and the left used The gallery is populated by matching collectionsScreen OnVisible Clear Button OnSelectClearCollect colSelected type ones show val type tens show X val type hundreds show C val type thousands show M val type tenthousnads show ̅X̅ val ClearCollect colUnSelected type ones show val type tens show X val XXXXXXXXXXX type hundreds show C val CCCCCCCCCC type thousands show M val MMMMMMMMMM type tenthousnads show ̅X̅ val X̅X̅X̅X̅X̅X̅X̅X̅X̅X̅ The gallery has a lable showing the collection val on Select of the label with patch the value with length and patch the other collection with its val and the show Gallery label OnSelectIf ThisItem val lt gt Patch colUnSelected type ThisItem type val Left ThisItem val Len ThisItem val Patch colSelected type ThisItem type val LookUp colSelected type ThisItem type val amp ThisItem show The last step is converting the colSelected item val s to a number Text of Result label Len Index colSelected val Len Index colSelected val Len Index colSelected val Len Index colSelected val Len Index colSelected val As you can see there are loads of different ways to solve any App solution it shows how important a good design review is to help plan before development A copy of the app can be found here	2023-04-26 08:13:55
海外科学	BBC News - Science & Environment	iSpace: Japanese Moon lander likely to have crashed	https://www.bbc.co.uk/news/world-asia-65389730?at_medium=RSS&at_campaign=KARANGA	lunar	2023-04-26 08:22:18
医療系	医療介護 CBnews	診療報酬改定施行後ろ倒しへ議論開始、中医協-日医委員「医療現場の負担の極小化」を主張	https://www.cbnews.jp/news/entry/20230426165222	中央社会保険医療協議会	2023-04-26 17:25:00
海外ニュース	Japan Times latest articles	China flexes national security powers with high-profile arrests	https://www.japantimes.co.jp/news/2023/04/26/asia-pacific/crime-legal-asia-pacific/chinese-national-security-laws/	China flexes national security powers with high profile arrestsCharges have been brought against a prominent Chinese journalist from a state run newspaper as well as a Taiwanese political activist for allegedly inciting secession	2023-04-26 17:47:29
海外ニュース	Japan Times latest articles	Japanese startup fails in historic bid to put private lunar lander on moon	https://www.japantimes.co.jp/news/2023/04/26/national/science-health/ispace-moon-lost-signal/	Japanese startup fails in historic bid to put private lunar lander on moonThe firm Ispace is believed to have fallen short of making the world s first private lunar landing after miscalculating the distance to the surface and	2023-04-26 17:33:05
ニュース	BBC News - Home	Ed Sheeran denies copying Marvin Gaye song at start of New York trial	https://www.bbc.co.uk/news/world-us-canada-65394202?at_medium=RSS&at_campaign=KARANGA	marvin	2023-04-26 08:45:33
ニュース	BBC News - Home	Not proven verdict to be scrapped in Scottish courts	https://www.bbc.co.uk/news/uk-scotland-65397235?at_medium=RSS&at_campaign=KARANGA	government	2023-04-26 08:16:41
ニュース	BBC News - Home	King Charles: Chocolate bust created to celebrate coronation	https://www.bbc.co.uk/news/uk-england-berkshire-65396837?at_medium=RSS&at_campaign=KARANGA	charles	2023-04-26 08:22:50
ニュース	BBC News - Home	Lucy Bronze: England and Barcelona defender has keyhole knee surgery	https://www.bbc.co.uk/sport/football/65396264?at_medium=RSS&at_campaign=KARANGA	Lucy Bronze England and Barcelona defender has keyhole knee surgeryEngland and Barcelona defender Lucy Bronze undergoes keyhole knee surgery and will miss the second leg of the Women s Champions League semi final her club confirms	2023-04-26 08:43:07
ニュース	BBC News - Home	Sudan: Third evacuation flight of Britons lands in Cyprus	https://www.bbc.co.uk/news/uk-65395361?at_medium=RSS&at_campaign=KARANGA	separate	2023-04-26 08:46:14
ニュース	BBC News - Home	Sudan crisis: War crimes suspect free amid chaos	https://www.bbc.co.uk/news/world-africa-65394913?at_medium=RSS&at_campaign=KARANGA	darfur	2023-04-26 08:31:51
ニュース	Newsweek	ポリオ、コレラなど致死性病原体を保有する研究所をスーダン戦闘員が占拠「極めて大きな生物学的リスク」	https://www.newsweekjapan.jp/stories/world/2023/04/who-141.php		2023-04-26 17:33:09
ニュース	Newsweek	「愚かで有害」との反発も...「中国依存」深まるロシアで、中国語が大ブームに	https://www.newsweekjapan.jp/stories/world/2023/04/post-101484.php	「愚かで有害」との反発も「中国依存」深まるロシアで、中国語が大ブームに欧米からの制裁で孤立を深め、頼みの綱とばかりに中国への依存を強めるロシアで、中国語学習が大ブームになっている。	2023-04-26 17:03:00
IT	週刊アスキー	タクティカルFPS『VALORANT』でエピソード6 Act IIIが開始！	https://weekly.ascii.jp/elem/000/004/134/4134705/	actiii	2023-04-26 17:40:00
IT	週刊アスキー	新感覚キラキラスイーツ、光り輝くジュエルマカロンを販売　小田急百貨店 新宿店SHINJUKU DELISH PARK （小田急エース北館）に「POP UP ONE＜ジュエルマカロン＞」が期間限定出店	https://weekly.ascii.jp/elem/000/004/134/4134660/	delish	2023-04-26 17:30:00
IT	週刊アスキー	「CAPCOM GOLDEN WEEK SALE」が各種デジタルストアで開催中！本日から新たなタイトルも追加	https://weekly.ascii.jp/elem/000/004/134/4134717/	capcomgoldenweeksale	2023-04-26 17:25:00
IT	週刊アスキー	虎ノ門の話題のパン店が新宿に登場！　小田急新宿に「with life bakery」が5月2日まで出店	https://weekly.ascii.jp/elem/000/004/134/4134656/	withlifebakery	2023-04-26 17:15:00
IT	週刊アスキー	エプソン販売、一部製品・サービスを7月3日より価格改定。原材料費高騰のため	https://weekly.ascii.jp/elem/000/004/134/4134707/	原材料費	2023-04-26 17:30:00
IT	週刊アスキー	メルカリ、愛媛県と岡山市で「メルカリエコボックス」と梱包資材を配布	https://weekly.ascii.jp/elem/000/004/134/4134699/	実証実験	2023-04-26 17:35:00
IT	週刊アスキー	エクサウィザーズ、企業向けの生成・対話型AIサービス「exaBase 生成AI built with GPT-4」の予約受付を開始　5月中旬サービス開始予定	https://weekly.ascii.jp/elem/000/004/134/4134692/	aibuiltwithgpt	2023-04-26 17:30:00