TEXT-BASED DATES CONVERSION ON GOOGLE SHEETS
Descrição da oferta de emprego
Google Apps Script - Convert Text-Based Dates to JavaScript Date Objects and Auto-Extensions I need a Google Apps Script that can convert text-based dates in a Google Sheet into JavaScript Date objects for further processing.
The script should handle auto-extensions if a due date is past the current date and the extension columns are blank.
Key Requirements 1.
Text to Date Conversion.
Convert text-based dates in "DD-MM-YYYY" format into JavaScript Date objects.
Ensure error handling for invalid dates.
2.
Auto-Extension Logic.
If the due date is past the current date and the extension column is blank, add a 2-day extension.
Testing and Verification 3.
Webhook Testing.
Use [login to view URL] to test webhook triggers for successful data transmission.
4.
Text-Based Dates.
Input the dates as regular numbers in the "Plain Text" format to simulate the expected format from the data source.
Ideal Freelancer Skills and Experience.
1.
Proficiency in Google Apps Script and JavaScript, with a focus on date conversions.
2.
Ability to create robust error handling for date parsing.
Project Deliverables 1.
Converted Dates.
A function or code snippet that converts text-based dates into valid JavaScript Date objects.
2.
Auto-Extensions.
Logic to add a 2-day extension if a due date is past the current date and the extension column is blank.
3.
Webhook Testing.
Code that sends data to [login to view URL] for verification We've already used ChatGPT to develop the initial code for converting text-based dates into JavaScript Date objects and for auto-extensions based on the current date.
Despite this, we're encountering challenges with accurate date parsing and webhook triggers.
We need a freelancer to focus on these specific issues and deliver a working solution.
JavaScript Arquitetura de software Google Apps Scripts Google Sheets Teste de Software ID do Projeto.
# Sobre o projeto 2 propostas Aberto para ofertas Projeto remoto Ativo em 38 minutos atrás
Detalhes da oferta
- Indeterminado
- Em todo Portugal
- Indeterminado - Indeterminado
- 25/04/2024
- 24/07/2024
Utilização de ferramentas específicas: aplicar conhecimentos em softwares como autocad, project, excel, google earth e google maps para a criação de planos, gestão de projetos e análise de localizações... (fator preferêncial);- disponibilidade para felxibilidade de horários e deslocações;- capacidade......
All candidates will be required to pass an online language and skills test, including a final competency based live interview... additional info: we are building our talent pool for this language and will communicate start dates when roles become available... learn as you work and be part of something......
No previous experience is neededworking schedule time frames: full time 40h/weekwork location: lisbon; our client is an omnichannel company based in portugalthe company proudly represents the leading global businesses such as microsoft, google, netflix, and the best-known social networks, providing customer......
No previous experience is neededworking schedule time frames: full time 40h/weekwork location: lisbon; our client is an omnichannel company based in portugalthe company proudly represents the leading global businesses such as microsoft, google, netflix, and the best-known social networks, providing customer......
No previous experience is neededwork location: lisbonour client is an omnichannel company based in portugalthe company proudly represents the leading global businesses such as microsoft, google, netflix, and the best-known social networks, providing customer support, technical support, and content moderation......
No previous experience is neededwork location: lisbon;our client is an omnichannel company based in portugalthe company proudly represents the leading global businesses such as microsoft, google, netflix, and the best-known social networks, providing customer support, technical support, and content moderation......
Outros dados de posição benefits: excellent remuneration package based on experience, skills and performance be part of a dynamic and creative team with positive and friendly atmosphere guidance and tools to reach your full potential meal allowance private health insurance yearly performance bonus relocation......
Language bonus gross: €2820 – €3240excellent remuneration package based on experience, skills and performancebe part of a dynamic and creative team with positive and friendly atmosphererelocation supportguidance and tools to reach your full potential... fluent in english (at least b2 level)previous experience......
Requisitos do trabalho your tasks will include:- ongoing customer service in the field of car rental,- ensuring the mobility of our fleet;- preparation of rental documents, monthly summaries and reports on branch activities;- carrying out the rental process,- maintaining good relations with current clients......
Outros dados de posição a gross monthly salary between €2100 and €3000 based on full-time employment... (depending on experience, performance, and the hotel where you will be based) you start with a fixed-term contract, with the prospect of permanent employment... you can also share these benefits......