Employee Profile App with Data from Sheets: GAS108

[@chaiwatpromma1584]

thank you so much . great work

[@arum.69k]

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]

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

[@arum.69k]

@@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]

@@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;
}

[@OrHaemetElad]

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

[@ashtonfei]

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

[@totoystone6562]

tysm sir

[@nancybella7474]

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

[@ashtonfei]

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.

[@DistrictEngineer-i5j]

thanks