Google calendar mysql database sync jobs

I need someone who is well-versed with and Google Drive to help me automate file organization and syncing, specifically around video documents. Key Responsibilities: - Implement automation for file organization and syncing using and Google Drive - Develop a system to automate the creation of video documents - Set up triggers for video document creation at scheduled time intervals Ideal Skills: - Proficient with and Google Drive - Experience in automating file organization and syncing - Familiarity with video document creation and automation - Ability to set up triggers for document creation at scheduled intervals Prior experience with similar projects will be an advantage. Please share relevant examples in your bid.

...website's search engine rankings, primarily on Google. Key Requirements: - I need a professional with advanced SEO knowledge, capable of guiding an intermediate team. - Experience with Google search engine optimization is a must. - A track record of successful SEO consultations is a big plus. Your role: - Evaluate our current SEO status and provide actionable recommendations. - Advise on keyword strategy, on-page and off-page optimization. - Help us understand and implement SEO best practices. The outcome we're looking for: - An actionable plan to improve our website's search engine rankings, with a focus on Google. - Clear guidance for our team to implement these recommendations effectively. Ideal Skills: - Advanced SEO knowledge - Google...

I'm looking for a skilled developer with Square Space experience for some specific updates on my site. Key Requirements: - Custom message on checkout: This needs to be displayed with the product we're calling the custom message product. - Delivery calendar with availability: This needs to be integrated onto the checkout page.

...an expert in Google Sheets who can help me with a one-time analysis. The dataset to be worked on is quite large, with over 1000 rows, so I need someone who is well-versed in handling and analyzing large datasets in this platform. Key tasks for this project include: - Data analysis and visualization: I require someone who can understand the dataset thoroughly and present insights in a visually appealing manner. - Formulas and functions calculations: You should be able to create complex formulas and functions to derive the necessary insights from the data. Ideal candidates should possess the following skills and experience: - Proven track record in data analysis and visualization using Google Sheets. - Strong expertise in working with large datasets (1000+ rows) within ...

...who can integrate a cloud-based database into my project. Ideal Skills: - Strong proficiency in Java - Prior experience with database integration - Specifically, experience with cloud-based databases, Microsoft Azure in particular, is a big plus The Project: - Your primary task will be to integrate Microsoft Azure, a cloud-based database, into an existing Java project. - The project already has a well-defined structure and the database will serve as a key component. - The database integration should be secure, efficient, and scalable, meeting the highest standards. - There will be no need for user authentication or API integration, as this project is solely focused on database integration. Please only apply if you have good experience with...

I'm looking for a skilled Google Ads specialist to manage my Google Ads campaign. Key Responsibilities: - Create, manage and optimize Google Ads campaigns to drive traffic to my website. - Utilize industry best practices to generate leads and boost sales. Ideal Candidate: - Proven experience in managing successful Google Ads campaigns. - Strong understanding of Google Ads best practices. - Ability to analyze campaign performance and make data-driven decisions. - Strong communication skills and professionalism. Please note: - The main goal of my Google Ads campaign is to increase website traffic, generate leads, and boost sales. - The target audience should be tailored to suit the characteristics of my business. - While I have not specifie...

I need a skilled developer to build a database for my charity website. Your primary responsibilities in this role will include: - Building a comprehensive back-end database - Importing volunteer and event details into this database The volume of data to be imported ranges from 100 to 500 entries. The ideal candidate for this job will possess: - Strong knowledge in database management, creation, and data importation - Prior experience with charity website databases is a plus - Demonstrated ability to handle both volunteer and event data I'm looking for a swift completion of this project without compromising on the database's accuracy or functionality.

I'm in search of a skilled professional who can finesse my current audio and video setup at my Downtown Miami condominium. Key Requirements: - Audio Optimization: I specifically need improvements in sound quality and noise reduction in place. - Video Enhanc...quality, reducing noise, as well as adjusting lighting, framing, and camera settings - Excellent understanding of audio-visual equipment and its setup - Strong communication skills and a professional demeanor -I have a Rodecaster console, Shure XLR microphones, and two Sony ZVE10 cameras. I want to connect them to an Atomos Ninja for simultaneous recording, and I also have the necessary cables to sync all the audio, but I don't know how to configure it. Therefore, I need a professional to come to my condominium to...

...communications. Responsibilities: - Email Management: You will be responsible for sifting through my inbox, prioritizing emails, drafting responses, and ensuring that my inbox is organized and up-to-date. - Calendar Management: You will be in charge of scheduling meetings, appointments, and planning out my day to day activities. - Data Entry: Accurate and timely data entry is crucial to this role. You will be expected to input a variety of data into spreadsheets, databases or any other systems as needed. Ideal Skills: - Proficient in Microsoft Office, in particular Outlook for email and calendar management. - Excellent communication skills, both written and verbal. - Previous experience in a similar role is preferred. - Highly organized, detail-oriented, and able to...

I need help setting up reports on Google Analytics and optimizing my Google Ads campaign. Key Responsibilities: - Setting up specific reports on Google Analytics - Optimizing my Google Ads campaign Ideal Skills & Experience: - Proficient in Google Analytics and Google Ads - Experience in setting up website traffic, conversion rates, and e-commerce sales reports on Google Analytics - Previous success in optimizing Google Ads campaigns to achieve specific advertising goals - Excellent communication and problem-solving skills Please note that this job may involve giving guidance on the types of reports that should be set up on Google Analytics. If interested send me message or write Gibbs. So i know you have read this.

I have a Wordpress plugin called Sales Agents B2B and I'm looking for a skilled Wordpress developer to make 4 small customizations to it. The customiz...subagents created by agents in their account - Showing the assigned sales agent in the list view of users - Modifying existing features: - Ensuring sales agent visibility in the list view of users The ideal candidate should have experience in: - Expertise in Wordpress plugin development - Understanding of user roles and permissions - Proficiency in PHP and MySQL for plugin customization - Previous experience in CRM system integration would be a plus Please only apply if you have relevant experience and can deliver quality work within a reasonable timeframe. I'm looking forward to hearing from you.

I am seeking a skilled PHP developer to create a distance calculating sript for me. This script will be responsible for calculating the distance between multiple coordinates stored in a MySQL database. No user interface required as the coordinates will be retrieved from the database directly. Key requirements for the project include: - Create a script that can fetch the coordinates from a MySQL database - Calculating the distance between these multiple coordinates accurately If you're a developer with experience in MySQL PHP and distance calculations, I would love to hear from you.

I'm seeking a charismatic Georgian male voice-...unique voice to a commercial project. A standard Georgian accent is required to bring authenticity to the project. The ideal candidate should have: - Experience in commercial voice acting - An ability to deliver a performance with a humorous tone - A Standard Georgian accent We are looking for a VO male actor to dub entertainment videos. We need translation ( script is given in English ), VO, and sync. We have a potentially large volume order, so consider please as a long-term cooperation. Approximately 4-5 videos weekly ( 125$ per 5 episodes )-could be negotiable The average length of the video is under 15 minutes. Let me know please if you are interested additionally will ask you to do a short demo. Contact me for more deta...

I'm requiring a proficient Java developer for a college project. The main task will be building a web application along with database integration. I'll need you to implement vital functionalities, such as: - A user registration panel - A user login page - Fee structure - Contact us section - Admin as well as user registration option - Subjects and courses - Basic website navigation functions For the front end, HTML and CSS skills are necessary to render a clean and minimalist design. It's vital you're experienced in these domains and can provide examples of your past work. Looking forward to your proposals.

...experienced database professional to assist with a relational SQL database project. You will need to assist me to answer questions about the following: The required tasks include: - Relational data bases ( administration, normalisation, sql workbench, my sql, data modelling) - Writing SQL queries - Designing the database schema - Optimizing query performance This project specifically involves MySQL, sql workbench, so proficiency in this database system is a must. The complexity level of the project is intermediate, focusing on tasks like joins and subqueries. Ideal candidates will have: - Extensive experience with MySQL databases - Strong SQL querying, schema design and query optimization skills - Proficiency in working with relational da...

...involves inputting numeric data from digital files into a Google Sheets document. Key Project Details: - **Data Type**: The information you'll be working with is purely numeric. - **Data Source**: Files will be provided in digital format. - **Output Format**: The final dataset should be organized in Google Sheets format for easy access and sharing. Your role in this project will include: - Accurate entry of all numeric data from the provided digital files. - Ensuring the data is correctly organized within the Google Sheets document. Ideal freelancer for this job will have: - Proficient experience in data entry, with a focus on numeric data. - Strong attention to detail to prevent errors in the dataset. - Familiarity with Google Sheets or a similar p...

I am looking for a skilled and reliable tester who possesses 20 Irish Google Play accounts to help me test my app and facilitate its approval for production on the Google Play Store. This is a critical step for my app's launch, and I need someone who can perform the task efficiently and accurately. Requirements: -Must have 20 active Irish Google Play accounts. -Ability to test the app thoroughly on each account. -Provide feedback on any issues or bugs encountered during the testing phase. -Ensure the app is approved and ready for production on all 20 accounts. -Available to start immediately and complete the task as soon as possible. Responsibilities: -Download and install the app on each of the 20 Google Play accounts. -Perform thorough testing to identi...

We are seeking a skilled individual who is proficient in using the Google Play Console to publish apps. As our app developer, you will be responsible for uploading, managing, and optimizing our app listings on the Google Play Store. Responsibilities: 1. Utilize the Google Play Console to upload new app versions, including APK files, screenshots, descriptions, and other necessary assets. 2. Ensure compliance with Google Play policies and guidelines to prevent app rejection or suspension. 3. Manage app metadata, including titles, descriptions, keywords, and categories, to optimize visibility and searchability. 4. Monitor app performance metrics, including downloads, ratings, and reviews, and implement strategies to improve user engagement and retention. 5. Colla...

...planning, tracking and sharing achievements of your hobbies. Key Features Include: Self-optimisation: Users input their hobbies/self-development items including their current and desired ability level, prioritisation, and schedule the amount available time they have for them. Hobbi calculates the optimal schedule based off data aligning your time with your goals. Scheduling Assistant: Interactive calendar integrating into work and personal calendars to help visually schedule time aside for hobbies. Progress Tracker: Data analytics to track progress providing weekly insights to help users understand their progress against the average trend and plan time better. Social Platform: Create a worldwide community to connect with friends and like-minded people with similar hobbies. Our g...

I'm in need of a Wix developer who can help me with adding custom features and functionalities to my website. I am trying to do the database structure for this page Each projects will load a list of tasks filtered by six different stages Each task needs to be comleted by the supervisor with acomment, photo/video upload / schedule a future task on calendar Once submitted that task will be read only with an option to edit edit/submit logs of who changed what and when - will be recorded this is the main task And may be will look for an option to create a dashboard to view these tasks status / add documents and projects etc but not essential

I'm in need of a New but skilled web designer to redesign my website with a free theme. Then you also need to delete google tag manager, analytic and console code then readd these. Budet fixed 25-30 GBP Thanks

I am in need of a one-time service to clean out my email database of invalid email addresses that generates too much soft bounce and hard bounce (and spam trap emails). Key Points: - **Objective**: The main goal of this project is to remove outdated or incorrect email addresses from the email database. - **Frequency**: This is a one-time project, not requiring ongoing maintenance. - **Current Platform**: I use Brevo as my email platform Ideal Freelancer Skills: - Experience with email marketing and database management - Familiarity with Brevo or similar email platforms - Proficient in identifying and removing invalid email addresses - Proven track record of improving email deliverability and marketing campaign results. I supply email addresses in CSV or XLS files

I'm seeking a skilled professional to optimize my Google My Business and search engine presence. This is an ongoing project that will span across various markets. My primary goal is to improve lead generation and sales through these efforts. Key Responsibilities: - Google My Business Optimization: Enhancing and managing my profile on Google to drive more local traffic and boost sales. - SEO: Implementing effective strategies to improve search engine rankings, increase website traffic, and ultimately drive more leads and sales. Ideal Skills and Experience: - Proven experience in Google My Business optimization and SEO. - Strong understanding of search engine algorithms and ranking factors. - Ability to craft and execute a long-term strategy across differe...

I am looking for a freelancer who can help me with Web Scraping. We have a list of websites that we would like to scrape specific data from, and have them put into a set of MySQL Databases (or maybe something else). The website that we would like to scrape data from each contain thousands of articles, and we would also want other metadata, such as Author name, article date, number of views, or any other metadata that we can take from the pages. Please bid, and we can discuss the first website, you can tell us how long you think it'll take to write the scraper. There are maybe 50 websites to begin with that we would like to do this for, in this one project, and we also have another couple of similar projects. Ideally, the scraper will run form a program, so that we can run it...

...SEO specialist who can help boost my adult niche website's visibility on Google. My main objective is to significantly increase traffic to the site. Key Requirements: On-page optimization Off page optimization - Expertise in Google SEO: You should have a wealth of experience working with Google SEO, particularly in the adult niche, to help me achieve my traffic goals. - Keyword Optimization: I have a set of specific keywords that I'd like you to focus on. These keywords are crucial to the site's success, so it's important that you have a proven track record in keyword optimization. Please provide examples of previous work, particularly in the adult niche, that demonstrate your ability to drive traffic through Google SEO. Your approach s...

...regional filters Secure messaging system between users (escorts, agencies, and clients) Payment gateway integration for premium services and advertisements Admin panel for content management, user management, and analytics Skills Required: Proficiency in web development languages (e.g., HTML, CSS, JavaScript) Experience with backend development (e.g., PHP, Python, Node.js) Knowledge of database management (e.g., MySQL, MongoDB) Ideally site would be on Wordpress and use Laravel in front with Sage or similar theme. Familiarity with web security best practices and compliance standards Ability to integrate third-party APIs for features like payments and messaging Additional Details: We are open to using existing frameworks or platforms to expedite development. The project ...

...reminders for effective client engagement. 7. Profile verification system to ensure authenticity. 8. Documentation management for securely storing and tracking user documents. 9. Client status management to track user statuses and automate actions accordingly. 10. Seamless integration of WhatsApp for direct messaging, call logs, and automated messages. 11. Backend integration via API development to sync user data between the website backend and CRM. The CRM should be user-friendly, efficient, and scalable. Interested freelancers with relevant experience in CRM development, backend integration, and WhatsApp API integration are encouraged to bid. Please provide examples of similar projects and your approach to implementing the required features. Budget and timeline are negotiabl...

Hello! I need to build a module or functionality to the ServiceGo - Multi Vendor On-Demand Service & Handyman Booking Marketplace system for vendors. The module (functionality) should be the following, subscription model for vendors. In this subscription model, there should be a limit on how many listings (job services) a given vendor can publish and how many customers it can respond to. P.S. The above mentioned functionality is important to us, but even if you can't offer us such a solution we are also looking for the functionality of only registering as a vendor to pay a fee again, which should be per subscription. Link to the system:

My priority for this project is to improve my website's ranking on Google. To accomplish this, I am seeking a professional with strong SEO experience and a proven track record in creating high quality backlinks, with the exception of guest blogging backlinks and business profile backlinks, as I have not identified a preference yet. Ideal skills & experience: • SEO expertise • Google search algorithm understanding • Experience in obtaining high-quality backlinks • Proven track record of improving Google search ranking • Strong understanding of ethical SEO practices. Looking forward to a long term fruitful partnership with the right freelancer.

I'm seeking a Google Ads expert to help me run a campaign to generate leads from the professional segment (ages 25-54) on an international scale. Key Responsibilities: - Create and manage the Google Ads campaign with a focus on lead generation. - Tailor the campaign to cater specifically to professionals in the 25-54 age group. - Utilize a strategic approach to ensure the campaign's success in an international context. Ideal Skills and Experience: - Proven track record in Google Ads campaign management, particularly in lead generation. - In-depth understanding of targeting strategies for different demographics, with a specific focus on professionals. - Experience in managing international campaigns and adjusting them to suit different markets is desirable....

I'm seeking a data-savvy freelancer with a deep understanding of Instagram, to create a well-organized spreadsheet of micro influencers. There are three crucial components needed for each influencer: I AM NOT LOOKING TO CREATE FAKE SOCIAL ACCOUNTS - I WANT EMAIL ADDRESSES TO CONTACT THEM TO HELP CREATE CONTENT> 1. Instagram Handle 2. Number of followers 3. Their Email Search Criteria - total of 2000 records acrsoss - Dieticians and Nutritionists - Pregnancy and infertility - Mums / Working Mums 500 - 5000 followers only. Australian-Based Accounts

I'm in need of an experienced Talend Studio developer to assist with a database migration project. Key Project Details: - **Data Sources**: The project entails integrating data from various databases. - **Primary Goal**: The primary focus of the project is to migrate the data accurately and efficiently. - **Data Processing**: The data migration will primarily be through batch processing, therefore real-time processing is not required. Desired Skills: - **Talend Studio Proficiency**: A strong understanding of Talend Studio and its capabilities is essential for successful project completion. - **Database Integration Skills**: Experience working with database integration is a must. - **Data Migration Experience**: Previous experience with data migration projects w...

...experienced individual who can enhance my Shopify website's online visibility through on-page SEO optimization, while also driving online sales via Google Ads campaigns. The primary target market for my luxury brand are high-income professionals, and lovers of black caviar. Key Responsibilities: - Conduct on-page optimization to improve SEO of my Shopify website - Create and manage Google Ads campaigns with the goal of driving online sales - Tailor strategies to specifically target australian consumers in major cities Ideal Skills and Experience: - Proven track record of enhancing SEO for Shopify websites - Expertise in creating and managing successful Google Ads campaigns - Experience in the luxury brand space is a plus - Strong understanding of the behavio...

I need a professional NextJS dashboard created that integrates Paddle for subscription management and MySQL as database Key requirements: - Create a NextJS dashboard: The design needs to be clean and professional. I'm not looking for something overly complex, but rather a streamlined and user-friendly interface. - Integrate Paddle for Subscription Management: This functionality is crucial for the success of my project. I need the dashboard to seamlessly handle subscription management through Paddle. Ideal skills and experience: - Proficiency in NextJS: You should have a good understanding and experience working with NextJS. - Experience with E-commerce integrations: Ideally, you have previously worked on projects that involved integrating billing systems like Paddle. ...

**Description:** We are seeking a proficient Google Forms and Sheets specialist to streamline our stock and inventory management process. The ideal candidate will have a deep understanding of Google Sheets functionalities and be adept at creating seamless workflows using Google Forms. **Responsibilities:** - Develop a Google Sheets template for maintaining stock and plywood inventory data. - Implement formulas and functions to automatically update current stock levels based on purchase and sale entries. - Design intuitive Google Forms for entering purchase and sale data. - Integrate Google Forms with Google Sheets to ensure real-time updating of inventory data. - Provide guidance on best practices for efficient data management and organiz...

want an excel expert for google excel sheet, who can make raw material data entry for purchase of raw material stock add and when someone uses it then particular raw material to be subtracted from that item two sheets one is for list of items & another is for entry

I'm looking to enhance the rankings of my website on search engines, with a primary focus on Google and Bing. I've not conducted any SEO efforts for my website previously, so it will be a fresh project. Key requirements: - Improve website ranking on Google and Bing - No prior SEO efforts, so a fresh approach is needed Ideal skills and experience: - Proven experience in SEO, especially on Google and Bing - Ability to offer a fresh SEO strategy - Knowledge of how to improve website ranking specifically on Google and Bing

Next month Google ads work -- - - -

I'm looking for an experienced Google AdWords specialist to help boost my e-commerce website's traffic, targeting an international audience. Key requirements: - Comprehensive Understanding of Google AdWords: You should be well-versed in how to best utilize AdWords to drive traffic and conversions for e-commerce sites. - International Audience Targeting: You'll need to develop strategies to effectively reach and engage potential customers from various countries. - Proven Track Record: It's essential that you have a successful track record in managing AdWords campaigns for e-commerce businesses and increasing website traffic. Your role will be instrumental in increasing my site's visibility and ultimately, driving more sales. If you have the expertis...

I'm currently in need of a proficient backend developer who specializes in Node.js. Key responsibilities include: - Developing user authentication - Integrating the database - API Development The chosen candidate will preferably be experienced in and MySQL, although this isn't obligatory. knowledge is a bonus. In light of a tight deadline, applicants who can start as soon as possible will be prioritized.

...it's fourth generation of ownership. My Dad started using a database program called Formula Coster on his Apple IIc to figure out how to correctly price our baked goods based on ingredient costs, labor costs, overhead, etc. The program also allows us to store the formulas and makeup instructions for all our products based on the dough batch and individual pieces from the dough. It's a simple program that we still use today, but are afraid it may not continue to work very long. Other programs exist, but are all cloud based and require subscriptions with features we do not need. I am seeking an adept database developer to either continue work on an in-progress database or commence anew based on existing requirements. This database is intended for e...

I need a Google Ads expert to help me increase leads for my professional services business, targeting other businesses (B2B) We are a point of sale software company specializing in the hospitality and retail sector (no clothing). Businesses like restaurants, bars, coffee shops etc. is our main focus. We want to generate leads for our sales people that will make contact and setup demos. Key Responsibilities: - Going over our current campaigns and optimizing them/adding new ones to gain more leads. - Continuously optimizing the campaign to improve lead quality and increase conversion rates. - Monitoring the campaign's performance, making data-driven decisions, and providing regular progress updates. Ideal Candidate: - Proven experience in setting up and managing successful ...

I need a deft hand at Google Sheets, capable of mastering complex spreadsheet formatting and implementing powerful formulas. Your role includes: - Applying conditional formatting to enhance data visibility - Using lookup and reference functions to optimise data organisation and retrieval Your skill sets should ideally include advanced understanding of Google Sheets, proficiency in the application of lookup and reference functions along with a design-eye for effective conditional formatting.

I'm seeking a skilled professional to develop and implement a Google Ad campaign to attract more leads and new customers to my custom packaging service. Experience required: - Expertise in Google Advertising - Deep understanding of the packaging and printing industry - Demonstrable success in monetizing ad campaigns What I expect from this project: - Visible increase in customer acquisition - Specifically highlighting our custom packaging services - Weekly report on lead conversion and campaign success If you can drive my business growth through strategic Google advertising, I welcome your bid.

My priority for this project is to improve my website's ranking on Google. To accomplish this, I am seeking a professional with strong SEO experience and a proven track record in creating high quality backlinks, with the exception of guest blogging backlinks and business profile backlinks, as I have not identified a preference yet. Ideal skills & experience: • SEO expertise • Google search algorithm understanding • Experience in obtaining high-quality backlinks • Proven track record of improving Google search ranking • Strong understanding of ethical SEO practices. Looking forward to a long term fruitful partnership with the right freelancer.

I'm seeking a professional web developer to create a website for our media agency. The main goal of this platform is to generate leads for our business. Key Features: - Photo Gallery: The website should include a photo g...is minimalist and clean. It should be professional and sleek, all while being user-friendly and easy to navigate. Ideal Skills: - Proficient in web development with prior experience in similar projects - Expertise in creating lead-generating websites - Strong UI/UX skills - Familiarity with photo galleries, video integration, and client testimonial sections - Experience with FAQ sections and calendar integration. If you feel you have the skills and experience required for this project, please get in touch with your relevant portfolio. I'm excited to c...

I'm seeking a Google Ads expert to run search campaigns with the goal of increasing my website traffic. My target audience is international, and I already have a list of keywords ready for the campaign. Key Requirements: - Proficiency in Google Ads: I need someone with a deep understanding of Google Ads and its various tools. - Experience with Search Campaigns: You should have a proven track record of running successful search campaigns that have significantly boosted website traffic. - International Audience Targeting: Given that my target audience is international, you should be familiar with the nuances of targeting different regions and languages. Your responsibilities will include: - Reviewing and potentially refining my list of keywords. - Setting up and m...

Cleaning Service website, bookings and route organization in google maps, and updates on google calendar

I need a CRM system that is less complicated than the one at , but with a few additional features. The system should be compatible with both web and mobile. Key F...Task and Activity Tracking: It should help me track tasks and activities related to each contact. - Email Integration: I want to be able to send and receive emails within the CRM. - Google Calendar Integration: It should have the ability to sync with Google Calendar. LinkedIn Integration: - I need the system to integrate with LinkedIn, specifically to fetch public profile data of people I am connected with on LinkedIn. Ideal Skills: - Experience in CRM development - Proficiency in integrating APIs, especially LinkedIn - Strong knowledge of contact management and task tracking - Previous wo...

Our development team just wrapped up front end development for a large-scale website. At this critical juncture, we're seeking advice to ensure that our back-end databases - PostgreSQL and Cassandra - will be optimally performing and highly available. Key areas of consultation include: - Performance optimizat...optimization strategies - Replication and high availability options - Ideal design of databases to accommodate the scale of our website Ideal professionals would bear extensive experience with both PostgreSQL and Cassandra databases, as well as a keen understanding of integrating front-ends to back-end databases. Your prior work with large-scale website infrastructures will greatly benefit our project. Database optimization and design aptitude is a crucial requirement...