Gmail html signature 2018 jobs

I'm looking for a professional who can take my Google Sheets application and turn it into a fully functional web app, accessible to anyone, without the need for a Gmail account. Key requirements include: - Conversion of the existing functionalities to a fully operational web app - Implementation of data manipulation and calculations on the web platform - Ensuring user-friendly design and intuitive interface - The final product should be easily accessible and usable by a wide audience Technical Skills and Experience: - Proficiency in web development using HTML - Experience in data manipulation and calculations - Prior experience in app development, especially in converting existing tools to web-based platforms - A strong sense of design and user experience - A good unde...

Hello, we are looking for someone to help manage our Facebook and Instagram account by responding to DMs, comments, and engaging with users. Additional tasks/skills: - Doing research, data processing & analytics - Creating Reels on Instagram / TikTok videos - Gmail, Google Docs (Docs, Sheets, etc.) - Good customer service - General admin - Knowledge of Quickbooks - Has good English and interpersonal skills We are looking for someone who is flexible to work from 5 to 40 hours a week.

I'm looking for an experienced apparel designer to create unique and sharp designs for my brand 'Climax X LLC'. The designs should be inclusive of all my selected items: T-shirts, Hoodies, and Caps. Key Requirements: - Incorporating QR code logos: Each design should integrate a QR code logo. This will serve as a signature element across all the items. The QR codes should be designed in a way that it's aesthetically pleasing and not overpowering the design of the apparel. - Color Scheme: The designs should follow a specific color scheme. I would like the designer to suggest and implement a suitable color scheme to enhance the visual appeal of the apparel. Target Audience: - The designs should cater to a broad market. Be mindful that the target audience includes...

...of Experience in Hotel Industry who can work 30 hours a week and handle a variety of administrative duties. The primary responsibilities of this role will be managing my schedule, scheduling appointments, handling correspondence, and providing excellent customer service to clients. Ideal candidates should be proficient in Microsoft Office (Word, Excel, PowerPoint), Email Management (Outlook, Gmail), and Calendar Management (Google Calendar, Microsoft Outlook). The candidate must be fluent in English (Speaking & Writing) Your ability to multitask and maintain a high level of organization is crucial. A background in customer service would be an advantage. This is a remote position, and you will need your own computer and reliable internet access. Working hours - 30 hrs/...

I'm seeking a creative and thoughtful redesign of my company's logo, with the goal to modernize our brand image, improve brand recognition, and attract new customers. The focus should be on updating the icon or symbol, aiming for a literal or representational style. Along with the logo redesign, I'd like an update to our Brand Guidelines, Presentation Templates, and Email Signature to reflect our new look. Ideal Skills: - Logo and brand design - Strong visual aesthetic with an eye for modern, literal design - Experience in creating branded materials such as presentation templates and email signatures. Remember, we're hoping this redesign will help grow our appeal to new customers, so an understanding of market trends and consumer behavior is a plus.

...can be searched for and used for future jobs (also ability to edit / delete part). - Ability to export each completed job card (including attached PDF files, pictures and notes) to a PDF. - Sync with Quickbooks Online to allow the syncing of customers - Sync with Quickbooks Online to send completed job cards for invoicing. Updated: - Ability to print a delivery note on job completion (or have signature iPad) * We do NOT need any type of scheduling or tracking for employees. Primary Users: - Employees and Managers/Administrators: This system is primarily for the use of employees who will be responsible for carrying out the tasks listed on the job cards and the managers/administrators who oversee these tasks. Employees will need access to all past completed and active jobs. Mana...

I'm looking for an experienced HTML developer to help me design, code, and develop the front-end of my portfolio website. This project will involve: - Crafting a visually appealing website design that aligns with my professional needs and showcases my work effectively. - Converting this design into clean, efficient HTML code. - Developing the front-end of the website to ensure a seamless user experience and optimal performance. The main goal of this website is to serve as a showcase for my professional portfolio. Therefore, the ideal candidate for this project should have a keen eye for design and a strong understanding of user experience principles. Key skills and experience required: - Proven track record in website design, HTML coding, and front-end developm...

I have an existing HTML php website and I'm looking for a skilled PHP developer to implement some additional functions, primarily time tracking features. Key Responsibilities: - Implement additional functions to an existing HTML website - Develop a time tracking feature - Ensure the website remains user-friendly and aesthetically pleasing Ideal Candidate: - Fluent in PHP with a good command of HTML - Previous experience in developing time tracking systems - A creative mindset for enhancing user experience

...convert my existing 9-page HTML website to WordPress. Key requirements are: - An exact match of the current HTML design with the WordPress theme. - Maintaining all the current features, nothing should be added or removed. - An intuitive CMS for content updates should be integrated, this will accommodate any changes to text, image content etc. - Convert the HTML design to a WordPress website including the CMS for updating content, I do not want to use any additional plugins apart from the essentials or core plugins. - I don't want to use any premade theme, it's a custom design that I need to be done on WordPress, so do not contact me if you are relying on existing themes and plugins to make the website. Ideally, the developer should have a wealth of...

...and conditions. 11. here you have to title the page; You are not alone! on this page we should add some of our customer logo's and at the bottom a small case studie and review from a user. 12. The last page should give a thank you page and again the quote; build a next level company. You have full freedom on how to design it, it just should be in the trend of our company focusing only on my signature and the colors connected to it (red; #EF5E5E grey; #495057). Also i added a nice gradient image, that might be used as coloring as well. Most important is that it is a nice looking document - professional and showing that we are worth it. All needed documents can be found in attachment. The ideal freelancer for this project should have experience in graphic design, document ...

We have a Figma design for a Shopify store, we want to transfer it to HTML/css. Below is the Figma homepage design file to transfer to HTML and CSS. Please pay attention to small details as it will be critical for candidate selection. Figma Design:

I need a professional who can help me prove that a signature on a business check is not mine. This is important as I'm being charged with passing a bad check and believe my signature was forged. Key Requirements: - Authenticate Signature: The primary objective is to prove the signature on the check is not mine. This involves comparing the signature on the check with my genuine ones. - Legal Context: Experience or understanding of fraud investigations and court procedures would be beneficial as this is related to a legal charge. Your Approach: - Signature Analysis: I would need you to compare the signature on the check with my genuine signatures to provide me with definitive proof that it's not mine. - Documentation: It's ess...

Need a responsive HTML page with a button, following functionality should only apply to a mobile device view (width < 780px) Once clicked the camera app should launch with an overlay frame, the overlay should include 2 buttons: A 75% transparent camera icon should capture the picture once clicked. The red button should close the camera app with the overly Once a picture is taken a confirmation page should show the recently taken picture with an overlay asking for confirmation and an button for retake (see confirmation page) Once the picture has been confirmed an asynchronous process should start compressing the picture on the client side and upload it to a digital ocean space. The application should be to capture the remaining pictures and display the confirmation page and as...

...seeking a talented web designer with strong HTML skills to update my product cards. The goal is to make them more modern, sleek, and engaging. Key Requirements: - **Style:** You'll need to embrace a modern-looking & sleek design aesthetic, ensuring the cards align with my vision for a polished and contemporary look. - **Card Elements:** The most important elements on these cards are the product image, the AI Chatbot Name, and a compelling CTA that reads 'Tap here'. These need to be showcased in a way that's visually appealing and intuitive for users. - The page will be used for mobile only. We can have the cards where the user swipes left to view more. Ideal Skills and Experience: - **HTML/CSS Expertise:** You should have a strong background in ...

...a basic HTML form that I need to be updated to look modern and professional. The key changes include updating colors and fonts, improving layout and spacing, adding modern styling and animations, and the inclusion of an image and background. Key requirements: - Update colors and fonts to create a modern, visually appealing form - Improve layout and spacing to make the form more user-friendly - Implement modern styling and animations to enhance the overall design - Integrate an image and background to improve the visual appeal further - The form should collect a single field of information, specifically the 'New Target' The form only has about 5 or 6 fields that are passed to it. The form is opened through a Python Flask app. Ideal skills and experience: - Proficie...

I need a striking logo that will serve as the centerpiece of my email signature and eventually the website for my company, 'TWIN FLAME FILMS'. Here is a detailed breakdown of what I'm looking for: - I would like the logo to feature the letters 'JK' interwoven with flames. These flames should also serve as the letters themselves, making the 'JK' visibly made from orange flames. - The text 'TWIN FLAME FILMS' should be displayed directly beneath the 'JK' logo, in a plain CAPITAL text in black color to contrast the orange flames of the 'JK' letters. I would also like 'TWIN FLAME FILMS' in white on another logo so it can be used on a black background as well as a white background. I'm looking for a graphic ...

We need to find a freelancer that will increase the Speed score of Google Page Speed Insights - (95+ score guaranteed) for desktop and mobile version. The Optimization must be done for the site Kindly note that we want the design of the website to remain the same. Also, this site passes the achecker and we do not want that to break either.

Hello, I have problem with email contact form on my Wordpress website. Some time ago I changed hosting provider and contact form stop working. When I try to use it there is no error. Concact form inform that message was sent, but I did not receive it on my gmail. Can you help me fit it?

I need a professional email template designed to work smoothly on Outlook as well as be fully responsive on mobile devices. It will contain text and image content. Key Requirements: - The template should be compatible with Outlook. - It needs to be fully responsive on mobile devices. - The content will primarily consist of text and images. Ideal Skills and Experience: - Proficiency in HTML and CSS for email design. - Experience with creating templates for Outlook. - Understanding of responsive design principles for mobile compatibility. - Previous work examples or a portfolio demonstrating successful email template designs.

I'm doing a project demo and need to do use a sample image. I need an expert photo editor to place a photo on a license template for a demo. specific details onto the image. Please make the resolution match...The details below would be digitally placed: - Full Name VIRATA, ANA AVELA SY - Date of Birth 2003/11/17 - ID Photo (See attached, please edit to fit the box properly. Please make resolution of both to match) -Overlay date in white on photo 2020/09/23 - Nationality PHL - Height 1.59 -Sex F - Weight 46 - Expiration date 2025/11/17 -Address 41, 1108 BLUE RESIDENCES, KATIPUNAN AVE, QUEZON CITY -Signature (See attached) You would need a strong eye for details and deliver a professionally edited photo. Experience in handling similar tasks and a quick turnaround time will be ...

I would like to modernize this page: The website is written in basic HTML. I would like the content to remain exactly the same (including a table), but to use modern technology so that it would be displayed well on various mobile devices. In principle, the colors and style should also remain the same.

I need to build a Mac/ipad application. Write in swift so it’s cross compatible. It is an html website editor WYSIWYG. I don’t need anything fancy, but I am wanting to build this because I need this for myself and there is not good ones available and maybe others could benefit from it. What I want is an html editor with live preview, where you can switch between the html and editing it as a text document and it auto converts to html. Main features include: Manage organization, including multiple html documents integrated, as well as other documents such as images. Organize a “project” with multiple files and folders, kind of like an IDE but simplified for HTML editing. Expect your website as code files in the same folde...

I'm in need of a skilled motion graphics designer who can bring my logo to life. The animation should be dynamic and energetic, fitting for use on my website, across social media platforms, in presentations, and within my signature. Key requirements: - Create a dynamic and energetic logo animation - Ensure the animation is suitable for multi-platform use, including web, social media, presentations, and signature - Deliver the animation in GIF, AVI, and MP4 formats - Help me decide where to place the animation, for optimal visual impact Ideal skills for this job: - Proficiency in motion graphics and logo animation - Ability to create engaging and dynamic visuals - Understanding of different file formats and their usage in various platforms - Experience in creating conte...

Need a responsive HTML page with a button, following functionality should only apply to a mobile device view (width < 780px) Once clicked the camera app should launch with an overlay frame, the overlay should include 2 buttons: A 75% transparent camera icon should capture the picture once clicked. The red button should close the camera app with the overly Once a picture is taken a confirmation page should show the recently taken picture with an overlay asking for confirmation and an button for retake (see confirmation page) Once the picture has been confirmed an asynchronous process should start compressing the picture on the client side and upload it to a digital ocean space. The application should be to capture the remaining pictures and display the confirmation page and as...

We are seeking a skilled HTML developer to create a professional and visually appealing marketing email for our company, D'Agostino. The email should include our logos, photos from our website (), and the following text in Romanian: Stimați colaboratori, Suntem încântați să vă scriem din partea D'Agostino, cu scopul de a stabili noi parteneriate pentru transportul semi-remorcilor noastre mega de la terminalele de tren din Europa. Avem rute disponibile din Koln, Germania către Zeebrugge, Belgia, precum și din Verona și Novara, Italia. Oferim un tarif de 1.40 Euro pentru fiecare kilometru parcurs. Facturarea se va realiza săptămânal, iar plata va fi efectuată la 65 de zile de la emiterea facturii. Dacă sunteți interesați de această oportunitate sa...

I urgently need an e-signature designed for the Outlook platform. The design should be responsive and ideally completed within an hour. Key Design Elements: - Incorporate my company logo and contact information - Include social media icons and a link to my website Ideal Freelancer Skills: - Proficient in e-signature design - Experience with Outlook platform compatibility - Ability to create a responsive design - Fast turnaround time

Email signature required with logo clickable social icons and photo

Hi there, I require a nice email signature design which includes photo, logo, social media icons and clickable logos. Please provide examples of previous work.

I'm currently experiencing difficulty with my HTML website. There are broken links, incorrect formatting issues, and a general need for assistance with the HTML code. The "Admissions" section of my site is particularly afflicted by these broken links that require immediate attention. Ideally, I'm looking for freelancers who can bring rich experience in HTML and web development to the table. By demonstrating your experience in your application, you’ll increase your chances of landing this project. Let's get my website running smoothly again.

We are seeking a skilled developer to convert an existing HTML project into a Laravel application with Vue.js integration. The project involves migrating the frontend markup and styles from HTML to Vue.js components while integrating them seamlessly with the Laravel backend. Project Scope: HTML to Vue.js Conversion: Convert the existing HTML templates into Vue.js components while maintaining the current design and layout. Backend Integration: Integrate the Vue.js components with the Laravel backend to ensure seamless data flow and functionality. API Development: Develop any necessary APIs in Laravel to facilitate frontend-backend communication. Data Binding and State Management: Implement data binding and state management using Vuex or other appropriate met...

I'm in need of an experienced web developer to create a static HTML website based on a provided template. The skill set I'm ideally looking for includes: I will share the detailed info on the chat. There are around to 10 pages max. - Proficiency in HTML/CSS - Experience in responsive design - Knowledge of color theory, specifically warm tones. The website will serve personal usage and I wish to see a design that reflects warm tones including reds and oranges. The primary content for the site will be a mix of both images and text. The ability to streamline this in a balanced, easily digestible way will be highly appreciated. Please present relevant portfolio samples showcasing similar skills.

I need a talented graphics artist proficient in creating bold and colorful designs. I require a comprehensive br...a talented graphics artist proficient in creating bold and colorful designs. I require a comprehensive branding package including: - Logo design - Poster design - Brochure design The goal is to establish a strong brand identity for a product line poised for launch. Your designs should project a sense of vibrancy and liveliness that captivates our consumers and strengthens our product line's signature aesthetic. Ideal skills include proficiency in Adobe Creative Suite, graphic design principles, and a keen eye for details. Experience in branding projects is a plus. Please include samples of previous work that displays your expertise in bold and colorful design in...

Needs to add only HTML tags; No CSS. Only page content, No header/footer I am looking for a skilled individual who can accurately convert 38 .docx files into HTML. Key Requirements: - Should follow coding standards - You need to have a solid understanding of HTML structures and on page SEO knowledge. Ideal Skills/Experience: - Extensive experience with .docx to HTML conversions - Proficient understanding of HTML I look forward to seeing your proposals.

Only HTML tags needs to be added. I'm looking for a skilled freelancer to convert approximately 30 documents from DOC to HTML. This conversion should strictly include the content only, excluding any headers or footers. Key Requirements: - Conversion of 30 documents to HTML format - Ensure only content is included, no headers or footers - Implement a minimalistic style for the HTML files Additional Information: - The documents are simple in nature, with no tables or images, so the conversion process should be straightforward. Timeframe: I'm in need of this project completed ASAP. If you have the capacity for a quick turnaround, please feel free to bid. Ideal Skills: - Proficiency in HTML - Experience with document conversions - Ability to ...

I re...than simple verification. Key Requirements: - I'll provide a set of handwritten samples, and I need a thorough signature analysis conducted. This involves examining and comparing different aspects of the signatures. - The outcome should be a detailed report of the similarities and differences found in the provided set of signatures. This report should be structured and easy to understand, with clear conclusions. Ideal Skills: - Proficient in handwriting analysis and signature verification. - Experience in creating detailed reports on comparative analysis. - Ability to work meticulously and objectively. This project is crucial and requires a high level of expertise in signature analysis. The report will be used for decision-making purposes, so accuracy an...

Hello! Please read carefully before bidding. In a frontend web design to be converted to PHP/HTML. This is a shipping website with one main function: A shipping calculator. Custom built, no API. Primary objective: 1) Customer chooses from country and to country (Very similar to this website's interface: ). 2) After the customer gets a rate from two couriers only (UPS and FedEx) and multiple shipping services, the customer provides more information about three things: A) The sender. B) The receiver. C) The package. Then a customer checks out using Paypal. Secondary objective but not as important or could done possibly at a later phase: 1) Package tracking which possibly needs an API. 2) Basic signup and sign-in menu similar to this of

Hiring a hybrid NYC remote assistant for a clean energy company. Job is Monday, through Friday via ...-Scheduling clients with company for installs via phone calls -Keeping track of installs and inventory -Updating information for bookkeeping -Simple accounting and invoicing -Appointing clients to their appropriate sales rep -Social media management -Answering calls and relaying messages Must: -Speak English -Live in NYC -Have knowledge about common use of simple apps like excel, google drive, word, Gmail, WhatsApp -Organized Preferred: -Spanish / Chinese / Russian speaking -Website building, data security, tech -Photoshop -Living in Brooklyn or Queens Type : NYC only to show not a bot Please include a 15 second audio of your speaking voice to show you have english of working pr...

I'm seeking an HTML developer to assist with a range of tasks on a static website. Primarily, I'm looking to enhance the design and ensure its mobile responsiveness. - **Design Improvements:** I particularly need help with improving the layout of the site. So, if you have a good eye for design and can suggest and implement changes to the layout, I would be very interested in working with you. - **Mobile Responsiveness:** Mobile responsiveness is crucial for a site's usability and SEO. Therefore, you should be able to adjust the layout of the site for different screen sizes. This would involve ensuring that the site looks good and functions well on mobile devices. Ideal skills for this project include: - Strong HTML and CSS knowledge - Experience in web desi...

We are seeking an experienced developer proficient with the Vuexy theme to update our ongoing project's theme. Currently, the project is running on version 9.2.0, which is now deprecated. Our goal is to upgrade to version 10.0.0. Project Requirements: Upgrade the existing theme from Vuexy version 9.2.0 to 10.0.0. Ensure that all dependencies are updated and fully compatible with the new version, maintaining the overall functionality and stability of the project. We will provide all necessary files for the upgrade. Support and Collaboration: You will receive comprehensive support throughout the project to facilitate a smooth update process. We are committed to efficient collaboration and hope to establish a long-term relationship with a developer who delivers exemplary r...

We're looking for a web developer to refine an existing HTML page! You'll take a previously converted Excel sheet (.html) and enhance its visual appeal. This involves adding CSS styling to improve the layout, formatting, and overall aesthetics of the page. Experience with HTML and CSS is a must, and an eye for clean and user-friendly design is a plus!

...related fields (2021 & 2022 passout only)? Are you passionate about programming languages and eager to make your mark in the IT industry? Look no further! We’re hiring talented individuals to join our dynamic team. Position: Software Engineer Domain: Finacle (Banking) Location: Major cities in India and international locations Why Choose Us? Comprehensive end-to-end training in Unix/Linux, JSP, HTML, Core Java, Node JS, Node red, Oracle SQL, and PLSQL. Exciting projects in the banking domain Opportunities for growth and career advancement Terms and Conditions: Commitment: Minimum 3 years with us Training: First month (free accommodation), followed by competitive salary Performance-based increments from the second year onward Global travel opportunities Qualificati...

I need an experienced SEO specialist to help improve the search engine rankings of my local-targeted HTML CSS website. Key Points: - **Urgency**: The project is time-sensitive, and I need the work to be done as soon as possible. - **Local Focus**: The target audience for the site is local, so expertise in local SEO strategies is essential. - **HTML CSS**: The website is built using HTML and CSS, so experience with optimizing such sites is preferred. Ideal Skills and Experience: - Proven track record in SEO, particularly with local-focused sites. - Strong understanding of HTML and CSS and how they impact SEO. - Ability to work quickly and efficiently to meet the tight deadline. - Excellent communication skills to keep me updated on progress. Please let...

I want to replace the loader-animation on this template ... ... with another logo (see uploaded file). Best would be, the logo has some 3d-animation, not only rotating on one axis. What you must deliver: - logo file - instruction how to change the loader-animation in the template

As a d...coordinating with my contacts. - Managing emails and correspondence: You'll be responsible for filtering and replying to emails on my behalf. - Organizing documents and files: Keeping my paperwork in order is crucial. You should be proficient at filing, archiving, and retrieving documents. The ideal candidate should be well-versed in: - Microsoft Office (Word, Excel, PowerPoint) - Google Suite (Gmail, Google Docs, Google Sheets) - Calendar and scheduling software (Outlook, Google Calendar) In addition, fluency in German and Spanish, on top of English, would be considered a significant asset. This is a long-term role, with no strict deadline for completion. I value professionalism, discretion, and efficiency in my secretary, and I'm eager to find the right perso...

...the following assistance: - Setting up restrictions: I need to be able to limit the areas where sellers can operate in terms of ZIP codes and miles/kilometers radius. This is crucial for ensuring that the sellers' services are only available in the areas I specify. Ideally, I could have different subscription tiers for sellers based on the size of their geography. I'd also like to add apis for signature software and ID capture. I'm looking for a freelancer who has prior experience with WPJobster, particularly with customizing its functionality. The ideal candidate should have a strong understanding of WordPress, WPJobster, and be able to implement these geographic restrictions effectively. Experience with geolocation tools or plugins would be a plus. The goal is ...

I'm looking for a proficient PHP developer who can assist me with an e-commerce web development project. Here are the specifics: - The project involves building an e-commerce platform. - The website should be developed using core PHP. - Aside from the e-commerce functionality, no further special features are needed for the site. The ideal candidate should have a strong background in PHP development, specifically in building e-commerce websites. Familiarity with core PHP is required for this particular project. If you believe you have the necessary skills and experience, feel free to place your bid and I will be in touch with suitable candidates.

...with vast understanding of Bitcoin. This project involves integrating Coinbase as a payment gateway on my checkout system. The key requirements include: - Implementation of extensive transaction security. Beyond basic transaction measures, an integration of multi-signature wallets is crucial. Ideal Skills: - Proficiency in Laravel PHP - Extensive experience with the Coinbase payment gateway - Familiarity with Bitcoin and Ethereum transactions - Experience setting up advanced transaction security, especially with multi-signature wallets Additionally, I wish to integrate more than just Bitcoin in the future. To start with, Ethereum will be another cryptocurrency to support. Therefore, expertise in Ethereum transactions and familiarity with other cryptocurrencies will be ...

I'm in need of an experienced web developer who can help me fix a bug on my HTML website. The bug is causing an error message to be displayed whenever a form is submitted, along with several functionalities not working as they should. Key Points: - The error message is displayed when submitting a form. - The bug has led to malfunctioning of basic website functionalities. Ideal Skills: - Proficient in HTML - Experienced in bug fixing - Familiar with form submission errors I am looking for a quick turnaround on this project as it's affecting user experience on my site. Please provide your relevant experience and estimated time to fix in your bid. ********************************************************* WATCH THIS VIDEO URL IS

...developer to convert my existing WordPress site to a static HTML site. Here's what you need to know: - The primary reason for this conversion is that I no longer require the CMS functionality. This means you won't need to worry about the WordPress backend, plugins and the associated database. - The site has some dynamic elements like contact forms, comments section, and user login pages. These will need to be converted into static pages. - I would like to retain some specific design elements and functionalities from the WordPress site. These include the header/logo design, the navigation menu and the slider/carousel. It's essential that these are transferred over accurately. You need to have a solid grasp of both WordPress and HTML, as well as good unde...

I require a skilled and experienced web developer to create a custom HTML emailer for me. The emailer should be compatible with both Outlook and Gmail. Here are the specifics of the project: - You will be provided with a JPG image that will form the basis of the emailer. Your task will be to incorporate a single line of hyperlinked text in the middle of this image. The hyperlink should lead to a designated URL. - The emailer should be designed to display correctly across different email clients, especially Outlook and Gmail. The ideal candidate for this project would have: - Proven experience with creating custom HTML emailers. - Proficiency in working with JPG images and integrating hyperlinks into them. - A good understanding of the unique constraints and...