You are reading the article Trump Wants Tiktok And Wechat Deleted From Us App Stores By September 20 updated in November 2023 on the website Tai-facebook.edu.vn. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested December 2023 Trump Wants Tiktok And Wechat Deleted From Us App Stores By September 20
Trump wants TikTok and WeChat deleted from US app stores by September 20
The Trump government will force the removal of TikTok and WeChat from app stores in the US as of this weekend, unless a deal divorcing the popular services from the Chinese ownership is finalized. It’s the latest in a series of high-profile escalations done, the US Department of Commerce insisted today, to stop “malicious collection of American citizens’ personal data,” though critics have accused the policies of being the result of xenophobia and political maneuvering.
From Sunday, September 20, 2023, it will be prohibited to offer TikTok or WeChat through the Apple App Store, Google Play store, or other download stores in the US. Supplying the code, or app updates, in any way in the US will not be permitted, either. At the same time, no US payment or fund transfers through WeChat will be allowed.
From the same day for WeChat, and as of November 12, 2023 for TikTok, there’ll be an escalation of that policy too. In addition to the app stores ban, so too will “any provision of internet hosting services enabling the functioning or optimization of the mobile application” be prohibited in the US; similarly, content delivery network services for TikTok or WeChat functionality or optimization will be banned. US users will not be permitted to use VPNs or other peering services to access the apps, and using the “code, functions, or services” to access TikTok or WeChat functionality will be banned.
“While the threats posed by WeChat and TikTok are not identical, they are similar,” the Commerce department said in a statement today. “Each collects vast swaths of data from users, including network activity, location data, and browsing and search histories. Each is an active participant in China’s civil-military fusion and is subject to mandatory cooperation with the intelligence services of the CCP. This combination results in the use of WeChat and TikTok creating unacceptable risks to our national security.”
The announcement comes after the Trump administration’s August 6 executive orders which declared TikTok and WeChat risks to US users. That began an uneasy bidding war for TikTok, with Microsoft, Oracle, and Walmart seeming the likely contenders to take over the popular short video service.
More recently, however, Microsoft dropped out of the running. Earlier today, a deal between TikTok owner ByteDance and Oracle had been said to be tentatively agreed, but requiring approval from the US government to go ahead. However Oracle would not get the recommendation algorithm and other “secret sauce” that fans of TikTok have said make the app so addictive.
Instead it’s believed that Oracle would host the data of TikTok users on servers in the US, as well as being responsible for analyzing the app’s code to make sure there was nothing of security concern in there. The US government was also said to be granted approval rights for this newly reorganized TikTok’s board.
Where this new announcement leaves that proposed deal is unclear. If an agreement can be found, there’s a chance that TikTok could return to the app stores. “The President has provided until November 12 for the national security concerns posed by TikTok to be resolved,” the Commerce department said today. “If they are, the prohibitions in this order may be lifted.”
You're reading Trump Wants Tiktok And Wechat Deleted From Us App Stores By September 20
Tiktok Owner Bytedance Wants To Make A Smartphone
TikTok Owner Bytedance Make A Smartphone
Bytedance is not the only Chinese firm that’s seeking to construct a telephone because of its programs. Selfie app manufacturer Meitu had previously built a smartphone teeming with its own collection of photo editors.
TikTok’s Mobile app parent company, ByteDance(China), could soon be launching yet another ambitious project: own smartphone with pre-installed which will come preloaded its apps like TikTok, Flipchat and more.
2023 had been difficult of a year for ByteDance beacuse its popular video app TikTok banned by India for a couple of weeks. And after all The TikTOk App saw tremendous growth over the last few months.
ByteDance, the owner Zhang Yiming of apps such as news aggregator Jinri Toutiao, collaboration tool Lark, and short video app TikTok, is reportedly building its own smartphone in market to compete with Xiaomi, OnePlus.
Based on sources of Times report, the telephone would come packed with ByteDance’s several App — that include the information aggregator Jinri Toutiao, the omnipresent TikTok, and based on some rumors, an unreleased streaming music app.
Hence, companies such as ByteDance, apparently the world’s most precious startup ($75 billion) right now, are raising self-dependence. The Business has found success beyond its housing, particularly in India, where it seems almost 300 million consumers, mostly from TikTok (currently India’s most downloaded app).
ByteDance is confronting some uphill climbs on a worldwide scale. The continuing trade warfare of the U.S. and China can also wrench. The U.S. Department of Commerce banned Chinese technologies giant Huawei, by means of example, over spying and other national security problems, prompting Microsoft to wash its own laptops from its own shop and Google to cut company with the supplier.
Read also: – Huawei Countdown: May 20, and Continue through August 19, 2023
The move fits in accord with the organization’s strategy to go into the smartphone company. FT noted unsuccessful efforts of US internet companies when attempting to go into the smartphone marketplace, including Amazon and Facebook.
Chinese selfie app maker Meitu successfully parlayed a smartphone business into a deal with Xiaomi.
ByteDance phone manufacturers, such as Xiaomi, OnePlus, Oppo, Vivo and Realme will offer tough competition from the cheap Android smartphone area, to mention a couple. And when ByteDance would like to play with at the flagship smartphone area, it’s going to need to compete with all the established players such as the likes of Samsung and Huawei.
Best Online Thrift Stores Of 2023
We may earn revenue from the products available on this page and participate in affiliate programs. Learn more ›
Written By Chelsea Frank
Published Jun 4, 2023 9:00 AM
Online thrift stores provide a much-needed respite from the crowded, cluttered reality of second-hand shops. My anxiety is building just thinking about it. Shopping on the web, you can find incredible quality items at great discounts, sell your long-ignored clothes, and even shop for amazing second-hand home furniture that looks brand new.
The second-hand online market has come a long way from eBay (still an excellent choice, though). And with search tools and filters to help you pinpoint exactly what you’re looking for, thrifting has never been easier.
Thrifting isn’t just good for your wallet. It’s a sustainable option that reduces waste and gives new life to perfectly good garments and products. Plus, with all the supply chain issues from the pandemic, you don’t have to wait months for quality furniture to arrive. To help you find your treasures, here are the best online thrift stores to buy and sell just about anything.
How we chose the best online thrift storesIn order to select the best online thrift stores, we wanted to offer a variety of specialties to reflect the expansive marketplace and to help you narrow down what you might be looking for. For those reasons, we divided our “best of’s” to include furniture and home decor, menswear, budget, vintage, and best place to sell your clothes.
We evaluated our picks based on the variety offered: Does this thrift store offer an impressive and wide selection to suit different styles, tastes, price points, and preferences? We also looked at the website or app’s accessibility and ease of use. Is it clear how to sell and market your own clothes? Does the website have filters that make searching easier? Lastly, we determined customer satisfaction via reviews, monthly users, and other data to ensure that we’re only recommending sites that left customers happy.
Things to consider when shopping at the best online thrift stores Know your sizesSince most online thrift stores don’t offer returns, you’ll need to be more cognizant of sizing when buying clothes. Use size guides if provided, ask the seller how the item runs (true to size, large, etc.), and even try items in store from the brand to see how you tend to fit into their products. For example, if you’re looking at a secondhand dress from Vince, go to a store that sells Vince Brand and see how you typically fit in their garments. That way, when you go to buy online, you’ll be more informed. It’s a time investment up front, but it will pay off in the long run.
Pay attention to damageSellers should usually list whether the item has stains, rips, dents, scuffs, or any other damage. Be mindful when purchasing – look through photos, read the description thoroughly, and double-check with the seller before buying.
AuthenticateLuxury goods are often authenticated to ensure they are not duplicates or knock-offs. Some online thrift stores, like TheRealReal or Poshmark, for example, offer authentication for items at certain price points. Always make sure your item is the real deal so you don’t get scammed!
Ask for measurementsPhotos can sometimes be misleading. If you’re buying furniture or even clothing, ask for measurements to ensure a good fit before you’re stuck with a sofa that’s way too big for your living room.
Use filtersWith so much inventory, it can be super overwhelming. Always use the site’s filters to customize to your size, color preferences, brand preferences, and budget to wade through the noise.
HaggleSome sites are fixed pricing, but some allow you to haggle with the seller. Don’t be shy! Hit them with an offer and go from there—you never know how much you might save. Just make sure to be respectful of people’s time. Don’t chuck out a ton of lowball offers they shouldn’t accept.
Selling feeBefore you let go of your treasured belongings, make sure you fully understand how much the privilege of listing online is going to cost you. Some shops charge you an up-front listing cost as well as a percentage of the total sale. Others just take the percentage so you don’t have to pay until it actually sells. The site should clearly indicate its rates, so be sure to understand them before you start listing.
Best online thrift stores: Reviews & RecommendationsWith these terms out of the way, it’s time to get to our specific picks for the best online thrift stores. While we make specific category suggestions, specific needs can vary and overlap so be sure to check out the whole list before you decide where to shop or promote your listings.
Best vintage: Vestiaire Collective VintageWhy it made the cut: Nearly 3,000 new products are added daily and an incredible inventory of rare and hard-to-find vintage goods from all around the world makes Vestiaire Collective a truly unique thrift shopping experience.
Specs
Selling: Luxury Goods
Gender: All
Authenticated: Yes
Pros
More than 3,000 new products added daily
Authenticated
Resell within 72 hours and keep 100% of earnings
Global marketplace
Features rare, hard to get items
Cons
Returns are only accepted to Professional Sellers
With more than 3,000 new products added daily, Vestiaire Collective is a luxury consignment marketplace offering unique pieces and authenticated luxury goods. As a buyer, you’re safeguarded against counterfeit products thanks to their highly educated in-house experts who run the item through a rigorous authentication process. Their Vintage section features rare, super-hard-to-find luxury pieces like vintage Chanel bags, classic jackets, fine jewelry, and more.
Selling is also super convenient with Vestiaire—you simply list your item, wait for it to sell, ship it to their team of experts for authentication for free, then collect up to 80% of the sale once it’s delivered to the buyer.
Unfortunately, you can only return to Professional Sellers and not to Individual Sellers. However, if you aren’t happy with your purchase, they’ll allow you to resell the item within 72 hours of receiving it and keep 100% of your earnings. That’s an awesome and unique offering.
Best for furniture: ChairishWhy it made the cut: There’s a reason millions of users come back each month to check out Chairish’s hand-picked selection of beautiful and high-quality second-hand furniture. Plus, 2,000 items are added daily.
Specs
Selling: Vintage and Used Furniture, Home Goods, Art
Price Point: $$$-$$$$
Returns: Responsibility of Buyer (if approved)
Pros
A loyal customer base of 3 million monthly users
85% of their inventory is vintage
2,000 items added daily
A commitment to sustainability
Beloved by designers
Cons
Shipping can be super expensive
Not cheap, fixed pricing
With almost 3 million monthly users, Chairish is an award-winning marketplace offering an eclectic mix of unique vintage and used furniture and art. It’s not the cheapest option by any stretch, but for people who are wary of the quality of online thrifting for home decor and furniture, Chairish is your most reliable source for high-quality, durable, and long-lasting pieces.
Chairish boasts more than 2,000 expertly picked items added daily, so you can be sure you’ll never grow bored of their selection. Their platform connects 12,000 small businesses, artists, and designers with customers globally.
Return policy: You have 48 hours to request a return, and, if it’s approved, you’re responsible for the full cost of return packing and shipping. For Made-to-Order items, all sales are final. If you happen to be local and want to pick the item up yourself, your item will be final sale once you’ve inspected and taken possession of the piece. Shipping can be expensive, so note that when shopping.
Best to sell clothes: PoshmarkWhy it made the cut: Poshmark is one of the most convenient places to sell clothes given its easy-to-use app, prepaid shipping labels, and millions of users.
Specs
Selling: Clothing, Electronics, Accessories
Price Point: $$-$$$$
Fixed pricing: No
Pros
Easy to use app
Lots of eyeballs on items, quick selling
Prepaid shipping labels
Available in US, Canada, Australia
Cons
Not recommended for selling cheap clothing
Limited to three countries (not global)
With more than 80 million registered users across the U.S., Canada, and Australia on the app and 1 sale per second in the U.S., Poshmark is an ideal place to sell clothes at medium to high price points.
Poshmark isn’t just for selling clothes: you can sell electronics, pet items, jewelry, home goods, accessories, kid and baby items, and more!
If you have items to sell from popular brands such as Nike, Lululemon, Chanel, Coach, and Reformation, you’ll be selling in no time. Note that Poshmark takes 20% of the sale, and buyers are free to haggle. A tip: start your sale price a bit higher knowing it’s within the Posh culture to haggle.
Best for men: Menswear MarketWhy it made the cut: Menswear Market only accepts items that are in excellent condition with no major blemishes or alterations, so men can be sure they’re getting almost-new quality luxury goods.
Specs
Selling: Clothing, Shoes, Accessories
Price Point: $$$-$$$$
Fixed pricing: Yes
Pros
Free shipping on orders $50+
Personalized approach
Great customer service
Meant for luxury goods & designer items
All items must be in excellent condition
Cons
Not great for high-street or low-budget clothing
Pricey
Sellers: you only have 120 days to make the sale
Menswear Market is an online consignment shop for men with refined and high-quality taste. The online thrift store partners with suppliers around the United States in order to offer a wide variety of pre-owned luxury clothing, shoes, and accessories. This site is ideal for business attire, professional looks, and elegant menswear.
Menswear Market takes a more personal and customizable approach to men’s consignment, with excellent customer service. Free shipping is offered on orders of $50 or more, and you can even purchase in three different ways: via their online store, eBay, or retail.
We love that they only take items in excellent conditions with no alterations or major blemishes, so you can be positive the items will look fresh and new. They also represent a variety of styles and looks, so there’s something for everyone looking for this style of clothing.
If you’re looking to sell your luxury items, note that your consignment will last up to 120 days. Unsold items are either returned to you or donated to charity, so be mindful of this detail!
Best budget: Goodwill Online Thrift StoreWhy it made the cut: Goodwill is your mecca for budget clothing, electronics, games, books, home goods, and more.
Specs
Selling: Clothing, Electronics, Accessories, Games, Books, Home Goods, Etc.
Price Point: $
Fixed pricing: No, you can bid or buy full price
Pros
Committed to community impact
Some items are only $0.01 for shipping
Nonprofit organization
Unbeatable low prices
Cons
No real quality control
Some customers note prices have gone up
Prices are unbeatable; there’s even a section for 1-cent shipping. You can choose to bid on an item or quickly buy for full price. Prices on some categories have risen in recent years, so it’s a lot less likely than it used to be that you’ll find a treasure for extremely cheap. It has taken on more of a typical online thrift store role.
What we love most about this company is that proceeds from these items go towards helping over 24 million people overcome challenges to build skills, learn English, enhance their education, find jobs, and support individuals with disabilities to help them grow and thrive.
FAQs Q: Is online thrifting a thing?As you can see from this article, online thrifting is certainly a thing. And not only is it available, but it’s also awesome. It saves you money, helps reduce waste, and helps you curate a more unique wardrobe or style.
Q: What is considered a thrift store?A thrift store is a marketplace that sells second-hand goods like clothing, home decor, furniture, accessories, and other previously owned items.
Q: Are online thrift stores sustainable?Absolutely, online thrift stores are definitely sustainable. Studies show the fashion industry is one of the biggest causes of global pollution. By shopping secondhand, you reduce energy consumption and pollution, help to recycle plastics, tame our growing landfills, and more.
Final thoughts about the best online thrift storesWith so many products available at online thrift stores, buying new can be a thing of the past. There are plenty of well-made, durable, gorgeous, and desirable goods looking for new homes—so head to our recommendations for the best online thrift stores to find the items you need. Help save the planet and your wallet by thrifting!
Analytics Insight Predicts Disruptive Technologies Market To Reach Us$1.9 Billion By 2023
Analytics Insight has published a new market research report “Reinventing Businesses with Disruptive Technologies – A Comprehensive report covering six disruptive technologies with their Revenue, Forecast, Top Trends and Future (2023-2023)”. The report includes a detailed analysis of Artificial Intelligence (AI), Robotics, Big Data, Internet of Things (IoT), Cybersecurity and Augmented, and Virtual Reality (AR/VR) markets. According to the analysis, the market revenues of six disruptive technologies is expected to grow from US$1091.45 million in 2023 to US$1893.62 million in 2023, with a CAGR of 11.6%, in which AI accounts for 3.9%; Robotics 4.4%; Big Data 16.5%; Cybersecurity 14.1%; IoT 59.9%; and AR/VR 1.3%. The major driving force of such progress is widespread application of these technologies across various sectors and regions.
North America is expected to lead the AI, Big Data Analytics, Cybersecurity, AR-VR, and IoT marketThe global market for AI is forecast to grow at a CAGR of 29% from US$42.8 billion in 2023 to US$152.9 billion in 2023. North America is expected to lead the market with the largest share followed by the Asia Pacific, European region, and the rest of the world. The global market of Big Data is forecast to grow at a CAGR of 10.9% from US$179.6 billion in 2023 to US$301.5 billion in 2023. North America with the largest share is the leading region for the Big Data market worldwide, followed by the European region, Asia Pacific, and RoW. The global market of Robotics is forecast to grow at a CAGR of 10.9% from US$47.8 billion in 2023 to US$80.2 billion in 2023. Unlike, AI and Big Data, the Asia Pacific with the largest share is expected to lead the worldwide market followed by Europe, and North America. The global market of Cybersecurity is forecast to grow at a CAGR of 8.1% from US$153.9 billion in 2023 to US$227.4 billion in 2023. Where North America is expected to lead with the largest market share, Europe, Asia Pacific, and RoW are more likely to grab the following positions. The global AR and VR market is projected to increase from US$13.6 billion in 2023 to US$51.2 billion in 2023. Like, Cybersecurity, the AR/-VR market is expected to see the emergence of North America as a leader, further followed by the European and Asia market. The global market for IoT is forecast to grow at CAGR of 10.6% and is calculated to grow from US$653.6 billion in 2023 to US$1080.4 billion in 2023. North America and Europe are among the top two regions proliferating the market with the largest market shares among others.
BFSI is one of the fastest-growing industries across AI and Big Data MarketEvaluating sector-wise market, Analytics Insight observed that the BFSI sector with the largest market share is expected to lead the AI market, followed by Healthcare, Telecommunications and IT, Transport and Logistics, Retail, Media and Entertainment, and Manufacturing. Whereas across Big Data market, Telecommunications and IT and BFSI industry stand at the top two places with the largest market shares. The growth of Big Data is further driven by Manufacturing, Healthcare and Lifesciences, Transportation, Government and Defense, Retail, and Media and Entertainment sectors. Across the Robotics market, while the automotive is the largest sector by the end-user in Industrial Robots, further followed by Electronics, Metals, and Machinery, and Food and Beverage industry, by end-user in Service Robots, Logistics accounts for the largest market share among Healthcare and Military and Defense sectors. Across the Cybersecurity market, BFSI with the largest market share is leading, followed by IT and Telecom, Government and Defense, Healthcare, Manufacturing, and Retail sectors. Industry-wise, the Gaming market for AR-VR is forecast to experience massive growth, followed by Entertainment and Media, Aerospace and Defense sector, Healthcare, Manufacturing, and Retail. The data for industry-wide adoption and share of the IoT market, depicts that the Consumer Electronics industry is expected to lead, followed by Manufacturing and Retail, Transportation, Healthcare, Agriculture, and others.
Industrial Robots showcase a brighter future than Service RobotsBy application, the AI market is bifurcated into Machine Learning, Deep Learning, Natural Language Processing (NLP), Computer Vision, and others, where Machine Learning is expected to grow with the largest market share between 2023 to 2023. Sequentially, Deep Learning, Computer Vision, and NLP are also leading the market with significant projected growth. Across Big Data market, Analytics Applications and Performance applications are more likely to lead, outperforming other contributors including CPM Suites, BI Platforms, and Advanced Analytics applications. Moreover, industrial robots are expected to see considerable growth with the largest market share in comparison to service robots across the Robotics market. The cybersecurity market is expected to witness the growth of Enterprise Security application with the largest market share, followed by Endpoint Security, Cloud Security, Network Security, and Application Security. Furthermore, as per component variation, the AR-VR market is more likely to witness an upsurge in software-based adoption as compared to hardware-based adoption. Under applications, PaaS or Platform applications and services are expected to lead the IoT market, followed by Professional services and Connectivity applications. For enquires, send an email to
About Analytics InsightAnalytics Insight is an influential platform dedicated to insights, trends, and opinions from the world of data-driven technologies. It monitors developments, recognition, and achievements made by AI, big data and analytics companies across the globe. The Analytics Insight Magazine features opinions and views from top leaders and executives in the industry who share their journey, experiences, success stories, and knowledge to grow profitable businesses.
It Outsourcing And The “Unemployable” Us Tech Professional
American dominance of technology continues unabated, as giants like Microsoft, Google and IBM shape the landscape with big ideas and big dollars. Yet one species in this thriving landscape is clearly beleaguered: the American IT worker.
His challenges are numerous. A brutal recession makes hollowed-out companies hesitant to hire. Wages are stagnant. Well-educated H1B visa holders are happy to work for less. A multi-year trend toward IT outsourcing means emerging market talent is just an email away.
Worst of all, word on the street is that US IT workers aren’t keeping up with the global competition. The stereotypes, regardless of truth, have gained a degree of cultural credence.
The US tech professional is (according to lore) educated in a dysfunctional school system and distracted by an indulgent American lifestyle (March Madness betting pool, anyone?). In contrast, his Third World counterpart (probably Indian) lives to work and focuses like a laserbeam on his training – which never stops.
If you were the worrying type, you might think these negative perceptions and the IT outsourcing trend places American tech professionals on eroding ground. But tech outsourcing is an emotionally charged issue, touching upon combustibles like national identity and job stability. What’s perception and what’s reality?
Her positive experience, however, is not universally shared. “I have a very good friend and a longstanding client [an IT employer] who is continually frustrated,” says Bob Lewis, president of IT Catalysts, a consultancy that deals with hiring and other IT issues.
“Most of the people he interviews don’t seem to want to work very hard and seem to be far too open about their career aspirations compared to what they can do for him.”
“When those of us in senior management were growing up, the standard model was: One employer for your career, the employer showed loyalty to employees, which was reciprocated.” Those days are forever gone. Mergers and acquisitions, reorganizations, downsizing – today’s IT professional navigates an exhausting churn.
Lewis once even heard a CEO baldly state, “All of our employees need to understand that from here on in, they’re fungible commodities.” So much for employer loyalty.
For a young IT job candidate to muster an attitude of humility and gratitude in this atmosphere can be hard.
“I think a lot of the hiring managers resent that because, frankly, they’re less realistic than the people they’re hiring.” These managers are unwilling to admit that even today’s “permanent” jobs may be short or mid-term engagements.
“Members of this generation have a far more accurate picture of the nature of the work place, that no one is going to look out for their interests other than them,” he says. “What they haven’t learned is how to disguise that so that they can have an effective interview.” He’s even heard horror stories of young job applicants demanding, “Here’s what I want you to do for me.”
However, what some perceive as a weakness in young applicants may actually be a strength, says Nick Corcodilos, a longtime IT headhunter and owner of Ask The Headhunter.
Next Page: The Cowboy Attitude
Google Sheets Sort By Color And Google Sheets Filter By Color
Google Sheets sort by color and filter by color are useful techniques to organize your data based on the color of text or cells within the data.
For example, you might highlight rows of data relating to an important customer. Google Sheets sort by color and filter by color let you bring those highlighted rows to the top of your dataset, or even only show those rows.
They’re really helpful for removing duplicates in Google Sheets too.
As a bonus, they’re really easy to use. Let’s see how:
Google Sheets Sort By ColorSuppose you have a dataset with highlighted rows, for example all the apartments in this dataset:
Add a filter (the funnel icon in the toolbar, shown in red in the above image).
You can filter by the background color of the cell (like the yellow in this example) or by the color of the text.
The result of applying this sort is all the colored rows will be brought to the top of your dataset.
This is super helpful if you want to review all items at the same time. Another reason might be if they’re duplicate rows you’ve highlighted which you can now delete.
Google Sheets Filter By ColorThe Google Sheets filter by color method is very similar to the sort by color method.
In this example, I’ve used the Google Sheets filter by color to only display the yellow highlighted rows, which makes it really easy to review them.
There’s an option to remove the filter by color by setting it to none, found under the filter by color menu. This option is not found for the sort by color method.
Apps Script SolutionWhen I originally published this article, sort by color and filter by color were not available natively in Google Sheets, so I created a small script to add this functionality to a Sheet.
They were added on 11th March 2023. Read more here in the Google Workspace update blog.
Here is my original Apps Script solution, left here for general interest.
With a few simple lines of Apps Script, we can implement our own version.
This article will show you how to implement that same feature in Google Sheets.
It’s a pretty basic idea.
We need to know the background color of the cell we want to sort or filter with (user input 1). Then we need to know which column to use to do the sorting or filtering (user input 2). Finally we need to do the sort or filter.
So step one is to to prompt the user to input the cell and columns.
Apps Script Sort By ColorAt a high level, our program has the following components:
Custom menu to run the Google Sheets sort by color program
Prompt to ask user for the color cell
Save the color cell using the Properties Service
Second prompt to ask the user for the sort/filter column
Save the sort/filter column using the Properties Service
Show the color and column choices and confirm
Retrieve the background colors of the sort/filter column
Add helper column to data in Sheet with these background colors
Sort/Filter this helper column, based on the color cell
Clear out the values in the document Properties store
Let’s look at each of these sections in turn.
Add A Custom Menu (1)This is simply boilerplate Apps Script code to add a custom menu to your Google Sheet:
/** * Create custom menu */ function onOpen() { ui.createMenu('Color Tool') .addItem('Sort by color...', 'sortByColorSetupUi') .addItem('Clear Ranges','clearProperties') .addToUi(); } Prompt The User For Cell And Column Choices (2, 4 and 6 above) /** * Sort By Color Setup Program Flow * Check whether color cell and sort columnn have been selected * If both selected, move to sort the data by color */ function sortByColorSetupUi() { var colorProperties = PropertiesService.getDocumentProperties(); var colorCellRange = colorProperties.getProperty('colorCellRange'); var sortColumnLetter = colorProperties.getProperty('sortColumnLetter'); var title='No Title'; var msg = 'No Text'; if(!colorCellRange) { title = 'Select Color Cell'; dispStatus(title, msg); } if (colorCellRange && !sortColumnLetter) { title = 'Select Sort Column'; dispStatus(title, msg); } if(colorCellRange && sortColumnLetter) { title= 'Displaying Color Cell and Sort Column Ranges'; dispStatus(title,msg); } } /** * display the modeless dialog box */ function dispStatus(title,html) { var title = typeof(title) !== 'undefined' ? title : 'No Title Provided'; var htmlOutput = HtmlService .createHtmlOutput(html) .setWidth(350) .setHeight(200); } /** * helper function to switch between dialog box 1 (to select color cell) and 2 (to select sort column) */ function sortByColorHelper(mode) { var mode = (typeof(mode) !== 'undefined')? mode : 0; switch(mode) { case 1: setColorCell(); sortByColorSetupUi(); break; case 2: setSortColumn(); sortByColorSetupUi(); break; default: clearProperties(); } }The buttons on the dialog boxes use the client-side chúng tôi API to call server-side Apps Script functions.
Following this, the google.script.host.close() is also a client-side JavaScript API that closes the current dialog box.
Save The Cell And Column Choices In The Property Store (3 and 5)These two functions save the cell and column ranges that the user highlights into the Sheet’s property store:
/** * saves the color cell range to properties */ function setColorCell() { var colorProperties = PropertiesService.getDocumentProperties(); colorProperties.setProperty('colorCellRange', colorCell); } /** * saves the sort column range in properties */ function setSortColumn() { var sortColumnLetter = sortColumn.split(':')[0].replace(/d/g,'').toUpperCase(); var colorProperties = PropertiesService.getDocumentProperties(); colorProperties.setProperty('sortColumnLetter', sortColumnLetter); }As a result of running these functions, we have the color cell address (in A1 notation) and the sort/filter column letter saved in the Property store for future access.
Sorting The Data (7, 8 and 9 above)The sortData function is defined as follows:
/** * sort the data based on color cell and chosen column */ function sortData() { var colorProperties = PropertiesService.getDocumentProperties(); var colorCell = colorProperties.getProperty('colorCellRange'); var sortColumnLetter = colorProperties.getProperty('sortColumnLetter'); var lastRow = sheet.getLastRow(); var lastCol = sheet.getLastColumn(); var sortColBackgrounds = sheet.getRange(sortColumnLetter + 2 + ":" + sortColumnLetter + lastRow).getBackgrounds(); var sortColor = sheet.getRange(colorCell).getBackground(); var sortCodes = sortColBackgrounds.map(function(val) { return (val[0] === sortColor) ? [1] : [2]; }); sortCodes.unshift(['Sort Column']); sheet.getRange(1,lastCol+1,lastRow,1).setValues(sortCodes); sheet.getRange(1,lastCol+1,1,1).setHorizontalAlignment('center').setFontWeight('bold').setWrap(true); var dataRange = sheet.getRange(2,1,lastRow,lastCol+1); dataRange.sort(lastCol+1); sheet.getDataRange().createFilter(); clearProperties(); }And finally, we want a way to clear the properties store so we can start over.
Clear The Property Store (10 above)This simple function will delete all the key/value pairs stored in the Sheet’s property store:
/** * clear the properties */ function clearProperties() { PropertiesService.getDocumentProperties().deleteAllProperties(); } Run The Google Sheets Sort By Color ScriptIf you put all these code snippets together in your chúng tôi file, you should be able to run onOpen, authorize your script and then run the sort by color tool from the new custom menu.
Here’s the sort by color tool in action in Google Sheets:
You can see how all of the green shaded rows are sorted to the top of my dataset.
Note that this sort by color feature is setup to work with datasets that begin in cell A1 (because it relies on the getDataRange() method, which does the same).
Some improvements would be to make it more generalized (or prompt the user to highlight the dataset initially). I also have not included any error handling, intentionally to keep the script as simple as possible to aid understanding. However, this is something you’d want to consider if you want to make this solution more robust.
Apps Script Sort By Color TemplateHere’s the Google Sheet template for you to copy.
(If you’re prompted for permission to open this, it’s because my Google Workspace domain, chúng tôi is not whitelisted with your organization. You can talk to your Google Workspace administrator about that. Alternatively, if you open this link in incognito mode, you’ll be able to view the Sheet and copy the script direct from the Script Editor.)
If GitHub is your thing, here’s the sort by color code in my Apps Script repo on GitHub.
Apps Script Filter By ColorThe program flow is virtually identical, except that we filter the data rather than sort it. The code is almost exactly the same too, other than variable names being different and implementing a filter instead of a sort.
Rather than sorting the data, we create and add a filter to the dataset to show only the rows shaded with the matching colors:
The filter portion of the code looks like this:
if (sheet.getFilter() !== null) { sheet.getFilter().remove(); } var newFilter = sheet.getDataRange().createFilter(); filterCriteria.whenTextEqualTo(filterColor); newFilter.setColumnFilterCriteria(lastCol + 1, filterCriteria);If you want a challenge, see if you can modify the sort code to work with the filter example.
Apps Script Filter By Color TemplateFeel free to copy the Google Sheets filter by color template here.
(If you’re prompted for permission to open this, it’s because my Google Workspace domain, chúng tôi is not whitelisted with your organization. You can talk to your Google Workspace administrator about that. Alternatively, if you open this link in incognito mode, you’ll be able to view the Sheet and copy the script direct from the Script Editor.)
Or pull the code directly from the GitHub repo here.
Update the detailed information about Trump Wants Tiktok And Wechat Deleted From Us App Stores By September 20 on the Tai-facebook.edu.vn website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!