About MPearlman

MPearlman · 10-10-2023

I am developing an app that will have all my team member's tasks assigned by user so they can see their tasks by date or on a calendar in the app, but is it possible to send their assigned tasks to Google Tasks or Google Spaces in the Gmail pane? Wou...

Calendar View limited to owner/user · 10-10-2023

I have a calendar view that shows all tasks that are due (and color coded for each user), but I also have a "My Tasks" tab where each user can see just their tasks. This is working with a "Related Tasks" view, but I can't figure out how to also have ...

MPearlman · 10-10-2023

I created a starter app (based on a template) just to try things out and everything was on one table with multiple sheets. I had a sheet named "client list" and then another sheet for "projects" and a REF there back to the client list and (it took me...

MPearlman · 10-11-2023

Yes, I am using this as well to remind users when a task is due. The Google Task may be overkill if I can get everyone using a Desktop App view side-by-side with their Gmail in the browser.

MPearlman · 10-10-2023

I found this in the community! https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Google-tasks-integration/m-p/225476#M8690It uses Google App Scripts to create a bridge and webhook between Appsheet and Google Tasks. It was easy to set up and does w...

MPearlman · 10-10-2023

AMAZING! Tested it and it works! The only issue I see is that any time you edit the task it sends a new copy of the task through the webhook. So changing the status or due date creates multiple copies of the task. I wonder if there's a way to set it ...

Re: Calendar View limited to owner/user · 10-10-2023

Brilliant! I had to add a new REF column to my tasks table to include the email and then this works perfectly! I didn't have that there so I was trying to do it by owner name.

MPearlman · 10-10-2023

Thanks so much! Coding is not my strong suit so this really helped! Then I also realized that the sort-key is on the same table to call to the "client name" column to sort. I had previously called to the "clients" REF column. so the correct code is: ...

My Stats

MPearlman's Bio

Badges MPearlman Earned

Recent Activity

Processes to send user tasks to Google Spaces or Google Tasks

Calendar View limited to owner/user

OREDERBY to alphabetize dropdowns

Re: Processes to send user tasks to Google Spaces or Google Tasks

Re: Processes to send user tasks to Google Spaces or Google Tasks

Re: Google tasks integration

Re: Calendar View limited to owner/user

Re: OREDERBY to alphabetize dropdowns