Google Apps Scripts Jobs

We need a speadsheet that can handle any number of jobs and allows us to apply dates, material lists, notes, etc. to given tasks and apply items from those days to both a daily and weekly task list.

Taking as reference this video, the task is simple, but there are many rules to follow: The main goal is to schedule alerts for making payments. Each Event represent a payment to be done. In some cases, one particular service must be paid in 2 payments, so 1 line may result in 2 Events. For examle, with this given data: [X] LSR/SERVICIO IN-OUT 13-17/04 Status Reserva Status Solicitud payment1 payment2 detail of payment [0] Hotel Hallef, Natales 14-16-apr requested 28 pax 0 100% payment 1 [1] Hotel Camino 14-16-apr requested 7 pax 30 10 15% payment 1, 85% payment 2 >>>>>>>>>>>>>>>>> "14-apr" under column "IN...

I need to QUICKLY develop a web app using google app script and google sheets as DB (for now). User would log into the app(UI) and complete an evaluation utilizing a form. That form will have free text as well as drop downs. The form will “write” to google sheets. I then need an “admin” login to where I can search a record and Update a record and/or add “delete flag”. The entry into the google sheet should contain time stamps, record id’s, record user id (pulling from login setup), and of course the form responses. The background of this is we have agents completing tasks and we need to evaluate whether those tasks are being completed correctly. I need to have a clean and professional UI for the Quality Assurance team to work out of. This could pot...

We are seeking an experienced AppScript and AppSheet Developer to help putting together an Appsheet App. The candidate must be detail-oriented and organized. Responsibilities: Develop applications using Google Apps Script and AppSheet based on data we already have in Google Sheets. - Collaborate with stakeholders to identify and analyze requirements, develop project timelines, and prioritize development tasks - Debug and troubleshoot issues, ensuring high-quality deliverables. - Create technical documentation to support ongoing development and maintenance - Provide technical guidance and support to other team members, as needed Must have experience with AppSheet not just programming experience.

Hi. I have a spreadsheet () that I want to integrate with Google Calendar and I already have a code that does that for me. However, I need the code to be tweaked so that: 1. one of the columns allows me to set the events to ALL DAY on Google Calendar; 2. one of the columns allows me to set the frequency of the events (daily, annualy etc.); 3. the code updates the calendar, instead of creating new events each time I run the script. BELOW IS THE CODE: function create_Events(){ var ss = (); var sheet = ("Teste"); var last_row = (); var data = ("A1:E" + last_row).getValues(); var cal = ("calendarname"); //(data); for(var i = 0;i< ;i++){ // index 0 = Nome do Evento // index 1 = Data e hora iniciais // index 2 = Data e hora finais...

Need to automate: 1) New google Email ID creation for businesses on custom domains (Section 2 in attached doc) 2) New group Email ID creation on that domain (between the client and the respective account manager) (Section 3 in attached doc) 3) Create Google Drive for every client on admin account, which will be linked between the client, the admin, and the respective account manager)

Necesito implementar bien sea una Api de easy invoice o un app script de google que no dependa de alguna hoja de cálculo como tal. Un generador de factura como la adjuntada. En la plataforma de thunkable. Solo sería un botón que junto con el componente Api Web genere la URL para la descarga en .PDF para posteriormente compartir. Podrían usar el ejemplo de este link para la estructura de datos.

I need to build business processes using google forms, sheets, app script and looker studio.