Table queries jobs
I am on the hunt for five top-notch, native English-speaking customer support agents. The successful candidates must possess expert-level experience in customer support. Shift flexibility is a must as I require coverage across morning, afternoon and evening shifts. Extensive customer support experience is essential, and having a proven ability to handle complex queries in a professional manner will definitely make you stand out. SKILLS AND EXPERIENCE: - Expert proficiency in English - Exceptional communication and problem-solving skills - Ability to work various shifts - Proven experience in high-level customer support. I encourage all qualified applicants to place a bid. Let's make customer satisfaction our top priority!
...intuitive and user-friendly manner. Key webpage features include: - Display of exercise data: Each exercise's description and its difficulty level should be displayed. There's also a column in the database containing YouTube URL links, so another important feature the webpage needs is the ability to watch these exercise videos directly from the webpage. It is a simple database with only one table. - Users should be able to select the exercise they want from a drop-down list. They should be able to start typing the name of the exercise and the drop-down list should filter based on their text. Eg. if they type 'squat', the contents of the drop-down list should narrow to all exercises that contain the word 'squat'. - Exclusive admin rights: I would l...
...responsibilities: - Communication: the chosen freelancer must be comfortable communicating in Swedish with professional proficiency. - Grievance Management: Having a strong ability to handle complaints is key, so the candidate should be adept at resolving customer complaints effectively and ensuring customer satisfaction. Skills required: - Fluent Swedish Speaker: To effectively respond to all queries in Swedish. - Intermediate Customer Support: To competently analyze complaints and provide satisfactory solutions. - Patience and Persuasion: Above all, the ability to engage, understand, and manage customer complaints professionally is crucial. Previous experience in complaint handling will be an added advantage. Ensure that you're ready to provide 24/7 support, and can wo...
...as if dissolving into the entity. ***The Faceless Phantom slowly fades, leaving Thomas standing at the same spot. ***He stares at sleeping Faye with glazed eyes. ***Body rigid, his face twists as if tormented. Mouth wide open as if fear clogged his throat. ***His head sags. Goes back to sleep, still standing erect. FADE IN: INT. POLICE DEPARTMENT - INTERROGATION ROOM - DAY Cold and stark with a table and two chairs. There is a one-way mirror window on one of the walls. Thomas, haggard and disheveled, with dry bloodstains on his clothes, slumps in a chair. Across from him is DETECTIVE (30s, stone-cold, hawkish). DETECTIVE Mr. Hahn, were you in the room all night? Thomas looks distant. Not here. DETECTIVE WONG Mr. Hahn? Thomas barely nods. DETECTIVE WONG And yet you don’t kn...
We need to create a plugin that will handle the matching of products with the specific types of cars. The types of cars are actually the combination of the following data: CarTypeId - Maker - Model - Year - RoofType Their relationship should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the pr...
I'm looking for an expert in EA (Expert Advisor) to optimize the performance of my current EA system. In particular, I'm interested in: - Enhancing the trading algorithm: You should have a profound understanding of trading algorithms, as this task will require you to optimize my EA's functionality substantially. - Implementing better risk management: Yo...focus on improving the risk management aspect of the trading algorithm. This means you have extensive experience with risk analysis and how it's applied in trading algorithms. Having background knowledge in finance would be beneficial for this task but isn't necessary. However, strong analytical abilities, problem-solving skills, and an eye for detail are a must. Bring your expertise to the table and ...
...application's performance. Prior experience in user interface redesign will be an added advantage. Backend: - The primary task on the backend is to handle the implementation of new APIs. This requires a solid understanding of backend systems, particularly within the MEAN stack. Database: - While the frontend and backend are important, the database is equally crucial. Any expertise in optimizing database queries is a valuable skill I'm looking for. The ideal freelancer for this project should have: - Proven experience with MEAN stack development - A strong portfolio of similar projects - Excellent problem-solving skills - Good communication and collaboration abilities - The capacity to work independently and proactively If you believe you're the perfect fit for ...
Design a DJ table as per the sketches and drawings provided.
...communication, this must provide an all-encompassing experience for our dance studio users. Key Features Needed: - 'Class Schedules Registration': users should easily view and register for our classes. - 'Dance Tutorial Videos': Let our audience enjoy video content of dance tutorials from our studio. - 'Chat Room': A communication platform for users to discuss dance classes, schedules, or general queries. - 'Booking Studio Space': We have 2 dance studios for rent, users should be able to book them through the app. Registration Process: We require users to register for classes: - An Enrollment Form within the app itself - emailed to the Owner The preferred freelancer for this project must have the ability to merge these components into ...
I am in need of a skilled website developer to create a...automotive parts business. Key Features: - Product Catalog: I aim to display my products in a clear and organized manner. The website should allow for easy browsing and searching of products. - Contact Form: A simple, easy-to-use contact form is a must. This form should send inquiries directly to my email. - FAQ Section: I want to include a FAQ section where customers can find answers to common queries. Key Requirements: - Prior experience in developing similar informational websites is highly preferred. - Strong understanding of user experience design. - Proficiency in mobile optimization is a must. - Excellent communication skills to ensure the final product meets my expectations. Looking forward to your bids and creat...
...SEO, and we're eager to expand upon this. The desired candidate would: - Have a deep understanding of Google’s ranking algorithm - Be up-to-date on the latest SEO strategies and trends - Have proven experience in driving traffic, improving rankings, and generating leads/sales - Be based in or have expert knowledge of the Indonesian market. We're excited to see what you can bring to the table and help our business grow....
In quick expansion of our consumer base, I am seeking an Italian native speaker to provide customer support primarily through phone calls. The ideal candidate will have basic knowledge of sales to facilitate successful interactions with our customers. Key Responsibilities: - Answering product-related queries via phone calls - Utilizing effective sales techniques to ensure customer satisfaction - Necessitate top-tier communication skills Essential Skills: - Native level Italian - Proven sales skills - Exceptional problem-solving capabilities - High-quality communication skills I invite those who fit the bill of a proactive problem solver with sales expertise and a passion for providing excellent customer support to consider this opportunity.
...challenge lies in acquiring as much relevant data as possible for accurate predictions. Project Scope: 1. Preparation Stage: The freelancer will be responsible for identifying and researching all available sources of space debris data, both free and paid. This includes a comprehensive evaluation of data providers to ensure the data's relevance and quality. The output at this stage will be an Excel table summarizing the research, which will include provider names, links to data or registration, pricing (if it is a paid source), additional requirements from the provider, and descriptions of the data. We anticipate identifying up to 10 data providers. 2. Evaluation and Registration: We will evaluate the providers, register for their services, and handle payments if the data ...
Salary 2000 EUR Montly + bonuses I am looking for a native German-speaking individual who can effectively offer customer support for my business. Key Responsibilities: - Responding to customer queries over the phone with promptness and professionalism. - Resolving customer complaints while maintaining a positive and empathetic attitude. - Providing information and assistance regarding products to the customers. Ideal candidate's profile: - Proficient in German (native speaker level) - Proven experience in customer service - Ability to manage stressful situations - Excellent communication skills, especially over the phone. If you believe you're a good fit, please make a bid. Looking forward to working with a dedicated professional who can handle our German customer b...
STRICLY NO A.I (there is always spelling mistakes) I'm in need of a professional logo designer for my company, Precision Pipe Repair. The logo will be an abbreviated version, featuring the initials 'PPR' along with a combination of text and symbol. Logo : PPR...have: - Demonstrable experience in logo design, particularly for abbreviated logos - A strong portfolio demonstrating a variety of styles and an understanding of colour theory - Ability to cater to a futuristic and professional theme - A keen understanding of the pipe repair industry and the ability to incorporate this knowledge subtly into the design. If you can bring all these skills to the table and create a logo that meets my requirements, I'd love to hear from you. Please share samples of your pr...
I'm seeking a skilled developer to create an informational website primarily serving to present company information. Main features should be: - Displaying detailed and engaging company information. - Integrating a functional contact form for queries. - Establishing a product/services page to showcase our offerings. The ideal candidate should have experience in website development, particularly with informational websites, and understanding in creating user-friendly contact forms and detailed product/services pages. Proficiency in UI/UX design is an added advantage to ensure user-friendly design and navigation. Proven portfolio showcasing similar projects required. The focus here is not just a fully functional site, but also one with an engaging, intuitive design to optimize v...
... Only Native Spanish speakers from Spain!! As a rapidly expanding company, we are in need of a dedicated Customer Support professional who is a native Spanish speaker from Spain. This full-time role requires an individual who can provide exceptional customer service during afternoon shifts. The compensation package for this role is EUR2000/monthly. Responsibilities: - Responding to customer queries via voice calls and email, ensuring each customer receives top-notch service. - Using the Zoiper platform to manage customer interactions. Ideal Skills and Experience: - Fluency in Spanish (Spain Spanish) - Solid background in customer support, preferably in a phone and email environment. - Familiarity with the Zoiper platform is an advantage. - Excellent communication and problem-s...
I'm looking for a talented web designer to build a fitness website focusing on a robust online booking system. The priority functionality should be to enable booking for nutritional consultations, meal plans, and workout programs. Ideal Skills: - Proficiency in web design - Experie...functionality should be to enable booking for nutritional consultations, meal plans, and workout programs. Ideal Skills: - Proficiency in web design - Experience with online booking systems - Background in designing fitness or nutrition websites Design Preferences: Given that I have no specific design preferences, I would love it if you could bring your unique ideas and creative instincts to the table. Your portfolio, showcasing your previous works, will play a significant role in this sel...
1. We need a logo for our brand 'fysi' for our e-commerce business 2. The logo should represent 'Nature' in any form 3. It should have simply one or two colours, preferably black and white 4. We also require a source file with all the fonts and elements Any more queries or clarifications needed, kindly DM me. Thanks.
I'm looking for an expert in packaging design to create a visually appealing and modern box packaging design for my new product - screen wipes. The packaging should be: - In a box format - Small, with dimensions included in the template - Modern and minimalistic in style Ideal skills for this job include: - Graphic design - Packaging design - Experience in creating modern, minimalistic des...packaging design for my new product - screen wipes. The packaging should be: - In a box format - Small, with dimensions included in the template - Modern and minimalistic in style Ideal skills for this job include: - Graphic design - Packaging design - Experience in creating modern, minimalistic designs I'm open to your creativity and suggestions, so feel free to bring your own ideas ...
I need some help with a data model I created in Power Pivot. I have 2 data sets: one is Sales a...sets: one is Sales and the other is Stock. I have added both data sets to my data model and am now trying to create a pivot which pulls data from both tables. My Sales table pulls the data perfectly but the Stock table does not. Some context... When I pulled the data into the data model I added a column which I called DataModelLink. This created a 1 (Sales) to many (Stock) relationship between the two tables. As an example, I tried to pull the data of one particular style which had one line in the Sales table but 2 lines in the Stock table. For this reason, my Pivot is only reading one of two of the lines on the Stock data table. I am happy to share the...
I currently have a PHP script that echo's the value of a MySQL db and results appear 3 to a page using Pagination. I'd like the script modified to filter results. There should be a drop down box on the page with the selections of the drop down corresponding to the table column and when selected only the rows with the value of the column appear while still only displaying 3 to a page with page back and forward controls. In the below example of a db table the drop down box would contain the selections 1, 2 and 3. When the used selects 1 then the page output would only display Bob, Jane and Sarah. This is an already existing page with css in the output. Name Address. number ------------------------------------------------------ bob bris...
...evaluation tool (types of survey questions) that would be appropriate for this scenario, given the main outcome. You should include other variables of interest and a data analysis plan. State the variable types and specific analyses needed. Using the data provided (see attachment) , create a tables: Table 1 - demographics based on comparison groups, Table 2 - outcome table other associated variables with comparison groups, and Table 3 Analysis - multivariate analysis of your choice and written interpretation of the analysis. Section 2 - Scenario Two Scenario: Based on scenario 1 in this section, you have been asked to detail the epidemiological background of the outcomes of interest, obesity and physical...
I'm looking for a skilled professional to help me synchronize employee attendance records from ZkTeco ZkTime 5.0 to MSSQL on my local server. This is a daily batch update proces...structured in MSSQL in a way that allows for easy querying and reporting. - The process should be efficient and reliable, with error handling mechanisms in place. Skills needed: - Proficiency in ZkTeco ZkTime 5.0 - Strong experience in working with MSSQL databases - Excellent understanding of data synchronization processes - Ability to work with structured data and maintain normalized relations in a table-based format. Ideally, I'm looking for someone who can implement a robust and automated solution for this task. The successful candidate will be able to demonstrate their previous experience ...
>>Read first<< this is not a project this is a full-time job you will join our team of 14 devs don't bid blindly you will be ignored if you don't reply and start your text with >>Full Time Job << your bid will be ignored bid your monthly salary ask This is a full-time job 40h/w if you are not free don't apply ---------------------------------...where you've focused on these two platforms. Showcase your ability to adapt to different project scopes and requirements. If you can handle this dual-platform project with efficiency, we are looking to form a long term collaboration. Take this opportunity to be a part of an exciting, evolving project, while honing your Wordpress and Laravel skills. I am excited to see what you can bring to the table...
I am seeking a talented graphic designer to create a timeless classic-style logo that will captivate my target audience. The logo should strongly resonate with our audience in order to attract and retain their attention. It is necessary for any prospective freelance designers to deliver: - A highly detailed project proposal. - A clear understanding of traditional design principles. - A unique...target audience attraction. Ideal skills and qualification required for this job include: - Prior experience in designing classic logos. - Solid concepts on classic style branding. - Able to deliver on detailed project proposals. Your proposal should effectively illustrate how your design will engage my intended audience. I look forward to seeing the innovative concepts you can bring to the ...
...with key decision-makers through personalized interactions, effective communication, and exceptional customer service. Value Proposition: Clearly articulate the unique value proposition and benefits of partnering with our company, emphasizing our expertise, reliability, and commitment to client success. Follow-up and Feedback: Regularly follow up with prospective clients, address any concerns or queries, and solicit feedback to continuously improve our approach and offerings. Measurement and Evaluation: We will establish key performance indicators (KPIs) to measure the success of our efforts, including: Number of new business accounts acquired Revenue generated from new accounts Client satisfaction and retention rates Return on investment (ROI) from marketing and sales initiativ...
I am seeking a passionate video editor to create a compelling 30-second video ad for the upcoming release of my game. The main aim of the video ad is to promote the new rele...Utilize the gameplay clips I've taken to create a high-energy, captivating narrative. Ideal Skills and Experience: - Proven experience in creating video ads, particularly in the gaming industry. - Proficiency in video editing software and techniques. - Ability to understand and cater to the preferences of hardcore gamers. I'm looking for a freelancer who can bring fresh and creative ideas to the table, and deliver a high-quality video that will drive interest and excitement for the new game release. I have the video clips ready just need someone to mimick the style of this enshrouded ad
...programs. Essential Functions * Understand the history, structure, objectives, programs and financial needs of our organization. * Research grant opportunities from Ontario/Canadian government agencies. * Draft grant proposals and supporting documents based on the funding requirements of the organization. * Submit proposals to grant coordinators for approval. * Respond to internal and external queries on drafted and submitted proposals. * Maintain positive relationships with fund providers and other stakeholders. * Maintain records and submit reports related to grant opportunities. * Researches and identifies new Canadian Government small Business grant funding prospects to match our businesses priorities; * Generates high-quality proposals, narratives, applications and support...
Project Title: "Customer Order Management System" for an online retail business in MS Access. Objective: To develop a comprehensive database system that allows for efficient tracking and management of customer orders, inventory, and shipping. Key Features: 1. Customer Management - S...reports. - Customer order history and patterns. Instructions: Based on the given information do the following: 1: Create a DFD using Visual Paradigm. (Note: we have worked on VP in class) 2. Choose Entities 3. Create ERD based on the entities chosen 4. Create tables/files for each entity 5. Enter minimum 3 records in each table. Read the Key Features to create Columns/Fields in the tables. 6. Create ERD inside MS Access and join the tables based on the ERD 7. Create min 3 queries...
...consumers to view menu options, order meals online, and make reservations seamlessly. Key features of the application: - Menu Display: Should allow customers to easily browse various menu categories and individual meal descriptions. - Online Ordering: Requisite infrastructure for placing orders online, including a secure payment process system. - Reservation System: Must include a highly-efficient table reservation system with instant confirmation. Ideal Skill set: - Extensive knowledge and experience with Flutter app development - Strong fluency in Dart programming language - Proficiency in implementing secure online payment gateways - Previous experience with restaurant or similar e-commerce applications is a plus In your bid, please furnish samples of your previous wo...
...expressions, capturing nuanced emotions such as smirking and pensiveness among others. - Platform: Though the primary deployment platform isn't specified, a PNG format that can openly be edited and used across varied platforms is required. Ideal Skills: - Graphic Design: Expertise in designing refined, elegant, and vibrant PNG emojis. - Creativity: Ability to bring intuitive and refreshing ideas to the table. - Attention to detail: Capability to capture and design nuanced facial expressions accurately. A proven track-record on similar projects or in creating personalized emojis will be highly beneficial. This project demands a keen eye for detail and a knack for understanding and channeling emotions into graphic design. If this intrigues you, place your bid and let's ...
I require your expertise for an end-to-end testing of my Ruby on Rails application. Inclusive of all the components, which are Models, Controllers, and Views. Knowledge and usage of MiniTest, Simplecov, and Capybara for the testing frameworks are also required for this project. Key features for testing: - User Authentication - Database Queries - Form Validation The ideal candidate would be someone experienced with Ruby on Rails applications, fluent in the use of multiple testing frameworks, and specializes in identifying and rectifying potential pitfalls.
We need a dedicated customer support telecaller to act as a devoted link to both our existing and potential customers. You will be responsible for offering support for our services, responding to inquiries, resolving issues, and ensuring overall satisfa...dedicated customer support telecaller to act as a devoted link to both our existing and potential customers. You will be responsible for offering support for our services, responding to inquiries, resolving issues, and ensuring overall satisfaction. This role requires: - A proven track record in customer support roles, ideally over the phone - Confidence and skill in handling all types of customer queries - Knowledge of CRM tools - Exceptional communication and problem-solving abilities - Experience with service-centric businesses...
I'm in need...expert who can help in developing a relational database using SQL and Python. The project will primarily revolve around database management. Consequently, I would appreciate assistance in the following tasks: - Designing a new relational database, ensuring it's optimized for efficiency and performance. - Implementing data import and export capabilities for seamless data movement. - Developing queries to support the database's functionality and ease of use. The ideal candidate for this project should have a strong background in both SQL and Python, with a specific focus on database development. Experience with optimizing databases for performance and some knowledge of data import/export mechanisms would be advantageous. Moreover, an understanding of rel...
I'm in need of a de...Key features of this project include: - Extraction of table data: You should have knowledge and experience working with web data extraction, specifically with table data. - Selection of stocks data: The script should have the ability to select and extract information from the stock table. - Capability for multiple companies: The tool should be versatile to handle data extraction for multiple companies, not limited to just one. Experience in the use of n8n for data extraction from websites, especially in the finance sector, will be a significant advantage for this project. One of the page is: And the table is in the "premium" div. The credentials will be provided to the selected freelancer. The table looks lik...
I'm in need of an interior designer with experience in modern design aesthetics who can completely transform my living room and dining area. My preference is for a neutral color scheme with whites, grays and browns being the prominent tones. Key Elements include: - A medium sized and mpressive dining table, as I often entertain guests - A comfortable seating area that promotes relaxation, chats, and comfort. - Media Wall - Maximization of natural lighting - an aesthetic that capitalizes on light will be highly favored - Incorporation of features like a console, mirrors, wall art, center rugs, a media wall, and sofas with accent that combine style and utility. Special Attention should be paid to: - Nice, lush curtains that complement the modern aesthetic and enhance the spa...
When button clicked, the field of another table will changed to required. Only FTP no cpanel
Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.
...listings on a daily basis, as well as keeping the page updated with relevant and interesting posts for our followers. - **Video Editing:** As part of the content creation, you should be able to edit videos that could be used for property walkthroughs, testimonials or any other relevant content. - **Client Page Management:** You will also be responsible for the management of customer pages. Ensuring queries are responded to in a timely manner and any issues are handled professionally. This is a dynamic role that requires a proactive and creative approach to social media. The ideal candidate will have a proven track record of managing successful social media campaigns, particularly in the real estate sector. Your work should not only increase our visibility and engagement, but als...
Design and implement one page website. The website shall have a design similar to...libraries or APIs. Something like bootstrap + vanilla JS would be ideal, or bootstrap + jQuery. The website shall have a small database usage feature, in which every time the page is loaded, a new row is added to "leads" table with the following information: 1) Visitor's browser agent string, 2) Visitor's IP address, 3) 0 or 1 depending whether user is using a mobile device, 4) User's name, email, phone number and message if they fill up the contact form and click the "Send" button. Note: In case user send the form multiple times, then this data is overwritten in the same table row. After I accept your bid, you will get server access to the server that h...
Due to time and resource constraints, I need to migrate a component written in php (symphony) to Golang. The part on github relating to services towards the DB (MongoDb) and the new REST APIs (written in Golang) to access for interfacing is already active. The system will only have to execute queries on MongoDb (via Service) and render in twig template. The repository layer and service and repository are already developed in golang and will be provided. As well as indications on the function to be translated into golang. GIT access will be via wireguard VPN on the development environment
...examples is provided in the json format. We plan to have 1000 entries in this json at least. The database includes: Photo (each person will have at least one phone), name, birthday, occupation, transaction table, ... (please see the json file). Animations: when a user scrolls down new information block appears. Layout: The page should start with a photo of the person and a name on the left. See the attached file. In the middle of the page should be a table with trasactions, use a component from react here (or other possible framework): DData for the table comes from the json file. Please add in the bottom after all information from a user sign: Need more info come to us. Please add 2024 to the end of the page. The website should be mobile and
I have a google sheet with 400 exercises. I need to copy them all over to a notion document with a slightly different format. Here is the google sheet — https://docs.google.com/spreadsheets/d/1SCYzmyfXgZfhu4TFkBi0YQzbXjrzl4O-hVyZZ1eo1HQ/edit#gid=0 Here is the notion table (I will provide access to edit) — I need all of the videos from “Jen’s Exercise Demos” copied over with the name, the video url and the howToTips into the correct columns. All of the videos are vimeo links so should have “vimeo” selected in the videoType column Many of the tips have multiple number bullet points, I need there to be 2 lines between each bullet point, as demonstrated in the example rows. Equipment and
...tasks for my project. Although I chose to skip specifying the exact functionalities, the developer should anticipate working on tasks such as: Work on 45 pages, each very simple. There are 3 main page features: 1. View table from DB 2. Create new record in that table 3. Edit record in that table Most the pages are the same, just a different table. A few tables have some other functionality but it's all very easy. All html design has been done already, you just have to add some PHP/MySQL code to make the pages work with the database. You also need to create the DB, table and records. Though most have been created already. You would need to double check them though. I also need the web services to connect the DB to our mobile app. Techn...
Only FTP will be provided. Link 1 column with another table. and amend existing API only
I'm looking for a talented designer to create a comprehensive brand guidelines document for my real estate company. The primary goal of this project is to ensure consistency in our brand representation across all platforms. Key Deliverables: - A detailed brand guidelines document: This document will serve as a blueprint for our brand identity to be shared with partners, ensuring that ...guidelines for companies - Strong understanding of visual identity, color theory, and typography - Ability to interpret and translate brand values into visual elements - Experience working in the real estate industry would be a plus, but not a necessity. The successful candidate will play a key role in shaping how our brand is perceived in the market, and I'm excited to see what you can bring ...
I need an experienced web developer specializing in Magento PHP to assist with an urgent ...is time-sensitive and requires a quick turnaround. Therefore, you must be able to work efficiently and effectively under tight deadlines. - Detail-oriented: Attention to detail is key as the project involves the development of a user-friendly, high-quality web application. - Communication: Effective communication is crucial. You should be able to provide regular updates and be responsive to my queries. - Problem-solving: Being able to troubleshoot and solve issues as they arise is essential. If you can meet these criteria and deliver quality work promptly, I would like to hear from you. Please provide examples of your previous work in Magento PHP, especially any projects with similar time co...
We are a health food company. We need to update the table text of our 6 existing products. The lable design and layout do not need to be changed, only some text needs to be modified, and the text font needs to be consistent with the original labels.
