thanks

tysm sir

Bro very good video, I have a question. I have a GYM. So I have my clients on a spreadsheet. Name of the customer, the start date and the end date of their subscription. Up to that point everything was fine. Now I would like to take that data to a Google Task. I don't know if you could help me give me an idea of ​​how I could create that Scrip. thank you so much

@ashtonfei

2 ай бұрын

Will these tasks be created all in your account? Or you will need to create them for your clients and the coaches?

@arum.69k

2 ай бұрын

@@ashtonfei That's right for me. The idea is to be able to create a simple task with a name, start date and end date. And then upload that data as a task in Google task, I have been using copilot. But I reached a point where the task is created but the date is not recorded. My programming knowledge is low so it is difficult for me to identify the fault. Since I created a code with the help of copilot.

@ashtonfei

2 ай бұрын

@@arum.69k Try this function to create a new task into your account, make sure the Google Tasks API is enabled in the advanced services. const createTask = (title = 'This is a test task', dueDate = '2024-06-04', listName = 'My Tasks') => { // find the task list by name const getTaskListByName_ = (name) => { const items = Tasks.Tasklists.list().items return name ? items.find(v => v.title === name) : items[0]; } const tasklist = getTaskListByName_(listName); // create the task instance const taskInstance = Tasks.newTask(); taskInstance.title = title; taskInstance.due = new Date(dueDate).toISOString(); // format the due date; // more properties developers.google.com/tasks/reference/rest/v1/tasks#resource:-task // create the task in the found task list; const task = Tasks.Tasks.insert(taskInstance, tasklist.id); return task; }

Thank you! How i can show in this project pic from google drive?

@ashtonfei

2 ай бұрын

Try this 1. Make the image file public. 2. Get the file id and try to create a URL by the following pattern. drive.google.com/uc?id=fileIdHere

Could you please make employee leave management connect with attendance employee connect with salary slip with googlescript? Thank you

@ashtonfei

2 ай бұрын

Thanks for you comment. I am very familiar with the HR process. If you can provide a workflow of yours, then I can check what I can do with it.