About ScottE

ScottE · 12-27-2023

This Bot used to work, and I'm "unaware" of anything that I've changed that could possible affect the Bot.Goal: It's a simple bot that creates a draft email in GMail via Apps Script whenever an AppSheet Form ("EMAIL") is created. Problem: When the EM...

ScottE · 11-10-2023

I used GV to automatically provision the Obi302 for use with the single line in my GV Workspace account. I now need another line.Before I add an additional line to my GV account, I want to know if GV will auto-provision 2 lines or will the provisioni...

ScottE · 11-29-2022

I don't suppose this is possible. [Y/N]#Feature Request?I have an icon that links to external Google documents, but I use a Group of Actions to actually open it.The first action has a "Create Timeslip? [Y/N] confirmation popup, but the browser (actio...

ScottE · 11-15-2022

Is this a thing? Begin able to drag an item from the GDoc, Gmail, GCal list to an Internal Workspace Add-On icon in the GUI panel to create a new Appsheet form.I've been dreaming about this for some time, but I'm really just at the script kiddie skil...

ScottE · 11-13-2022

I have a project management app with a table of "Items" such as "Doc", "Phone" "Event" "Task", "Email", etc.Each "Items" row has a ENUM field [I/O] with "to", "from", "other" as potential values. Each "Items" row also has three (3) ENUMLIST Fields [T...

ScottE · 12-28-2023

SOLVED: In AppSheet I had Apps Script "Function Parameters" that were blank for planned functions.I put "" in them and solved the problem of my scripts not running.There was obviously some AppSheet code change that disallowed "blank" entries. I would...

ScottE · 02-10-2023

@Fabian_Weller The @BMAP account was mine under a different GApp login that I no longer have. I seem to recall a PM from an admin indicating there was a bug, but I had already come to some resolution. My recollection is a bit fuzzy, except to note th...

ScottE · 11-15-2022

Yes, Add a row to a Table., ideally I would like a generic form to popup for manual edits or notesI already have several scripts that "scan" for changes in the Google services (Contact, Calendar & Tasks) to sync the data back to AppSheet, but I don't...

ScottE · 11-15-2022

I have a project & time tracking app, where items (emails, docs, files, etc.) are associated via the item's "Google ID" with a project or a person in my app. This way I can see all associated project items. I usually create the items from within my a...

ScottE · 11-14-2022

@Marc_Dillon I went with an ugly hack, IMO. I populate the [I/O] field with the illegal ContactID, forcing a user to manually select "to/from/other", and thus overwriting the default LINKTOFORM value for [I/O] with valid date.@Steve with the new/old ...

My Stats

GENash's Bio

Badges ScottE Earned

Recent Activity

Bot Problem: Event Triggers Process, but Apps Script based Task does not run

Multiple GV accounts with dual line Obi302 hardware

Pause Grouped Actions until Action with "Need Confirmation?" has been acted upon

Google Workspace "Add-On" to drag and drop to create new AppSheet Form

Different Action Results with "New" vs "Saved" Data Row using Reset on Edit & Initial Values

Re: Bot Problem: Event Triggers Process, but Apps Script based Task does not run

Re: GCalendar Daylight Savings Time Issue

Re: Google Workspace "Add-On" to drag and drop to create new AppSheet Form

Re: Google Workspace "Add-On" to drag and drop to create new AppSheet Form

Re: Different Action Results with "New" vs "Saved" Data Row using Reset on Edit