Help Desk System in GOOGLE SHEETS / Support-Ticket-System google Sheet

Project Description A solution based on Microsoft 365 needs to be developed that will automatically obtain a text transcription of a Teams Meeting and save it in a SharePoint library in Microsoft Word (.docx) format.Current Infrastructure Microsoft 365 Microsoft Teams SharePoint Online Administrative access to Microsoft 365 is available An App Registration in Microsoft Entra ID can be created if neededBusiness Process After the Teams Meeting ends, the recording is automatically saved in the SharePoint library in .mp4 format. An automatic process is triggered when a new file appears. The process retrieves the transcription of the corresponding Teams Meeting. A Microsoft Word (.docx) document is generated that contains the full text of the transcription. The document is automatically saved to another SharePoint library (the address is taken from the SP list with settings: source library, library for saving .doc files)Requirements It is necessary to: automatically track the appearance of new mp4 files in the SharePoint library; obtain the Teams Meeting transcription via Microsoft Graph API or another recommended method; not use manual user actions; operate under a technical application (App Registration), without using a personal account; ensure stable operation of the solution after deployment.Preferred Technologies Preference is given to solutions based on: Power Automate Microsoft Graph API Microsoft Entra ID App Registration However, other implementation options are also welcome.Project Deliverables Upon project completion, the following is required: a fully functional solution; source materials (Flow, code, or other components); setup instructions; a brief description of the solution architecture.In your response to the project, please specify How the transcription of Teams will be obtained. What technologies will be used. An approximate number of hours or a fixed cost. Similar experience (if any).

The site is built on the Next.js framework (based on React). All points in the technical specification need to be completed. The technical specification is attached in the file. I look forward to your proposals.

there is a website https://perfect-okna.com.ua/ main problems: SPEED ANALYSIS (Performance) Key issues (typical for such websites): · Large unoptimized images (JPEG/PNG without compression, no WebP). · Lack of lazy loading for images in the catalog. · Non-minified CSS/JS, many unnecessary libraries connected. · No caching at the browser level, CDN not used. · Server does not provide compression (gzip/brotli). · HTTP/2 not used. Checklist "Speed": · Compress all images, convert to WebP and add fallback. · Set up lazy loading for images (loading="lazy"). · Minify HTML, CSS, JS. Combine files where appropriate. · Enable Gzip/Brotli on the server. · Set cache headers (Cache-Control, Expires) for static content. · Connect CDN (Cloudflare for free). · Remove unnecessary plugins/scripts (especially if WordPress). · Use asynchronous loading for non-critical scripts (async/defer). On the homepage, there is often no clear structure "who we are - what we offer - why choose us - how to order". · The window constructor (if available) can be confusing, without hints, the final price is not visible immediately. · On mobile devices, the menu may shift, the calculator is not adapted for fingers. · Feedback forms are long, without phone masking, without validation. · No "quick actions": call with one click, messengers, chat. · Lack of "breadcrumbs" on internal pages. · Create a mobile version without horizontal scrolling, buttons no less than 48x48 px. · On the homepage, add a price calculator "in 3 clicks" immediately. · In the header – clickable phone number (tel:), messengers (Viber/Telegram) with icons. · Forms: only name + phone + "comment" field (optional). Phone mask. · Add a floating button "Quick Order / Calculate Cost" on mobile. · On product cards – "Buy in 1 click" button (opens a mini-form). · Add "breadcrumbs", improve navigation through sections. · Check text contrast, font size (at least 14 px on mobile). · No urgent offer (time-limited promotions). · Insufficient social proof (reviews, video reviews, number of completed works). · It is not explained that the price is "turnkey" (installation, delivery, dismantling). · No CTA (call to action) on every screen. Add a "counter" – how many clients have already chosen, how many windows installed. · Video reviews from real clients (short, 30–60 sec). · Block "Calculate in 30 seconds" right on the first screen. · Show the "turnkey" price: window + installation + delivery, with a transparent breakdown. · Promotions with a timer: "15% discount for orders by the end of the week". · Popup window with an offer for a free measurement when the user tries to close the tab. What to do: · Interactive 3D window configurator (color change, opening, glazing) – more on this later. · Mini-game or test: "Which window is suitable for your apartment?" · Cases: photos "before/after" in real interiors. · Guides: "How to choose windows for a noisy street", "Energy saving: which glazing to choose". · Heating savings calculator after window replacement. Urgent (Critical) 1. Mobile adaptation of the entire site, especially the constructor and cart. 2. Speed up loading: image compression, caching, CDN. 3. Quick order button (One Click Buy) on all product cards. Popup chat with the ability to leave a message in Viber/Telegram. 5. Valid HTTPS and redirect from HTTP → HTTPS for all pages. 6. Microdata Schema.org (Organization, Product, BreadcrumbList, Review). Important (High) 1. Update the homepage: add USP, promotions, videos, quick calculator. 2. "Promotions" page with a timer, updated monthly. 3. Callback form – simple, with a mask and automatic city code substitution. 4. CRM integration (e.g., amoCRM / Bitrix24) for automatic lead capture. 5. Add online payment (LiqPay, WayForPay) at least for prepayment for measurement. 6. SEO URL structure: /produkciya/plastikovi-vikna/, not /?page_id=123. Desired (Medium) 1. Expand the blog with articles for key queries (5 articles at once). 2. Interactive constructor with 3D view (separate block below). 3. Product filter by characteristics (size, profile, color, price). 4. Personal client cabinet, where you can see the order status. 5. Generation of PDF commercial proposal directly on the site. HOW TO IMPROVE THE CONFIGURATOR (Window Configurator) If it is currently a regular form with dropdown lists – this is outdated. A modern 3D configurator is needed: Mandatory features: · Step-by-step wizard: 1) room selection, 2) dimensions, 3) number of sashes, 4) color, 5) glazing, 6) fittings, 7) mosquito net. · Instant price recalculation at each step (AJAX). · 3D visualization (Three.js or ready js framework). · Saving the selected configuration in PDF (server-side generation) and sending to email. · Button "Send calculation to manager" – and a card with all parameters flies to CRM. · Ability to share a link to your configuration (for example, to send to husband/wife). · Full adaptation for touch gestures (swipe to rotate the 3D model on the phone) Price is negotiable!

There is a fully ready one-page business card website - it was created by Cloud Code The contractor receives a ready ZIP archive (HTML/CSS/JS). It is necessary to make a quality adaptation for WordPress without using Elementor and other heavy builders.What needs to be done1. Pull the site onto WordPress create a custom theme; preserve the design 1:1; preserve responsiveness; preserve all animations; preserve all JS effects.2. Create an admin panel using ACF Pro All text blocks must be editable from the admin panel. Including: Hero Services Work (cases) About Process Testimonials Brands CTA Footer Contacts Social networks3. Repeaters Using ACF Repeater, it is necessary to create: services cases reviews client logos process stages FAQ (if needed)4. Flexible Content It is preferable to use ACF Flexible Content so that it is possible to: change the order of blocks; disable blocks; add new blocks without rewriting the theme.5. Cases Create a separate Custom Post Type: Projects Fields: title category description image link additional images (if necessary)6. Testimonials Create a separate Custom Post Type: Testimonials Fields: name position company photo text7. Site settings Using ACF Options Page, display: logo Telegram WhatsApp Email phone social media linksResult It is necessary to obtain: a ready WordPress theme; the ability to fully edit the site through the admin panel; without using page builders; clean code; preservation of all animations and responsiveness. If needed, I will send the link in private What is the price and timeline?

Project Meta Implement Viber integration without using third-party CRM systems. All work with messages should be done directly in our internal CRM based on BAS / 1C 8.3.Current System BAS / 1C 8.3 Custom configuration "Customer Service" Database of over 40,000 subscribersRequired Implementation Integration through an official Viber Business provider (TurboSMS, GMS Worldwide, or another agreed service). The button "Write to Viber" in the subscriber card. Sending messages directly from BAS. Receiving incoming messages via Webhook. Automatic linking of messages to the subscriber by phone number. Complete preservation of correspondence history in the subscriber card. Displaying the time, message status, and the manager who responded. Simultaneous work of multiple managers. Message templates for quick responses. Assistance with setting up the Viber provider, API keys, and Webhook. Transfer of all source code and settings after the work is completed.Acceptance Conditions The work is considered completed after successful testing of all functions on the working database and transfer of the source code.Guarantee 1 month warranty for fixing bugs related to the implemented functionality. Further modifications are carried out by separate agreement.Result After the project is completed, managers should be able to fully work with Viber directly in BAS: write to clients, receive responses, view correspondence history, and communicate without using third-party CRMs. All source code, modifications, API keys, and settings will be transferred to the client after the project is completed.