Document Created Error with Email

385 views
Skip to first unread message

Amanda Brantley

unread,
Apr 21, 2022, 3:22:13 PM4/21/22
to NV Autocrat Add-on
Here is the error I get:  Document successfully created; Document successfully merged; Failed to add <<TEACHER EMAIL>> as viewer: API call to drive.permissions.insert failed with error: Invalid permission value; !!Error Sending Emails: Invalid email: <<TEACHER EMAIL>>; Run via form trigger as aebra...@g.risd.org; Timestamp: Apr 21 2022 3:18 PM

What am I doing wrong? I am typing <<TEACHER EMAIL>> into the space of where to send the email because it is a different person each time. Why wouldn't this work?

Joseph Schmidt

unread,
Apr 21, 2022, 5:43:55 PM4/21/22
to nv-autocr...@googlegroups.com
You need to use the title of the column.  The best way to get that value is to click on the blue vertical bar and a popout will list the values.  Click on the value and it will be copied to the clipboard.




On Thu, Apr 21, 2022 at 3:22 PM Amanda Brantley <aebra...@g.risd.org> wrote:
Here is the error I get:  Document successfully created; Document successfully merged; Failed to add <<TEACHER EMAIL>> as viewer: API call to drive.permissions.insert failed with error: Invalid permission value; !!Error Sending Emails: Invalid email: <<TEACHER EMAIL>>; Run via form trigger as aebra...@g.risd.org; Timestamp: Apr 21 2022 3:18 PM

What am I doing wrong? I am typing <<TEACHER EMAIL>> into the space of where to send the email because it is a different person each time. Why wouldn't this work?

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/2afb49d7-5380-4f5d-b1b3-bc02bb0e5c50n%40googlegroups.com.

Amanda Brantley

unread,
Apr 22, 2022, 9:11:37 AM4/22/22
to NV Autocrat Add-on
Well, I thought I had typed it in exactly like the column heading, but your suggestion worked. Thank you!

Joseph Schmidt

unread,
Apr 22, 2022, 9:21:38 AM4/22/22
to nv-autocr...@googlegroups.com
You are welcome.  My coping and pasting skills are much better than my typing skills.  

There might be a space at the end of the title.  You wouldn't see it but it could prevent Autocrat from finding the column.

Rungrot Oranon

unread,
Apr 22, 2022, 11:18:12 AM4/22/22
to nv-autocr...@googlegroups.com
Thanks you

2565-04-22 20:20 GMT+07:00, Joseph Schmidt <glua...@gmail.com>:
> You are welcome. My coping and pasting skills are much better than my
> typing skills.
>
> There might be a space at the end of the title. You wouldn't see it but it
> could prevent Autocrat from finding the column.
>
> Joe Schmidt
>
> GLUA...@gmail.com
> <https://docs.google.com/drawings/d/e/2PACX-1vRBkmWG1gXlv26hGHOa4A-qIz88B3wv91yUKJhTt5caZBue0aeP7oiY6gO1JTzKVcZxdPsZhFLBtCgI/pub?w=960&h=720>
>
> New Visions Blog Entry - Joe Schmidt
> <http://www.newvisions.org/blog/entry/qa-joe-schmidt>
>
>
> On Fri, Apr 22, 2022 at 9:11 AM Amanda Brantley <aebra...@g.risd.org>
> wrote:
>
>> Well, I thought I had typed it in exactly like the column heading, but
>> your suggestion worked. Thank you!
>>
>> On Thursday, April 21, 2022 at 4:43:55 PM UTC-5 glua...@gmail.com wrote:
>>
>>> You need to use the title of the column. The best way to get that value
>>> is to click on the blue vertical bar and a popout will list the values.
>>> Click on the value and it will be copied to the clipboard.
>>>
>>>
>>> Joe Schmidt
>>>
>>> GLUA...@gmail.com
>>> <https://docs.google.com/drawings/d/e/2PACX-1vRBkmWG1gXlv26hGHOa4A-qIz88B3wv91yUKJhTt5caZBue0aeP7oiY6gO1JTzKVcZxdPsZhFLBtCgI/pub?w=960&h=720>
>>>
>>> New Visions Blog Entry - Joe Schmidt
>>> <http://www.newvisions.org/blog/entry/qa-joe-schmidt>
>>>
>>>
>>> On Thu, Apr 21, 2022 at 3:22 PM Amanda Brantley <aebra...@g.risd.org>
>>> wrote:
>>>
>>>> Here is the error I get: Document successfully created; Document
>>>> successfully merged; Failed to add <<TEACHER EMAIL>> as viewer: API call
>>>> to
>>>> drive.permissions.insert failed with error: Invalid permission value;
>>>> !!Error Sending Emails: Invalid email: <<TEACHER EMAIL>>; Run via form
>>>> trigger as aebra...@g.risd.org; Timestamp: Apr 21 2022 3:18 PM
>>>>
>>>> What am I doing wrong? I am typing <<TEACHER EMAIL>> into the space of
>>>> where to send the email because it is a different person each time. Why
>>>> wouldn't this work?
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "NV Autocrat Add-on" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to nv-autocrat-add...@googlegroups.com.
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/nv-autocrat-add-on/2afb49d7-5380-4f5d-b1b3-bc02bb0e5c50n%40googlegroups.com
>>>> <https://groups.google.com/d/msgid/nv-autocrat-add-on/2afb49d7-5380-4f5d-b1b3-bc02bb0e5c50n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>> --
>> You received this message because you are subscribed to the Google Groups
>> "NV Autocrat Add-on" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to nv-autocrat-add...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/nv-autocrat-add-on/c45737cd-de51-49b8-a586-0770f1120f32n%40googlegroups.com
>> <https://groups.google.com/d/msgid/nv-autocrat-add-on/c45737cd-de51-49b8-a586-0770f1120f32n%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "NV Autocrat Add-on" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to nv-autocrat-add...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTORRk6BrJywHi3B8rpzZZFzR9SstWEAE60FYSt0qQcyWMQ%40mail.gmail.com.
>


--
{[[Rungrot Saibudtdee]]}

ProjectAdmin Unknown

unread,
Apr 10, 2024, 3:54:42 PM4/10/24
to NV Autocrat Add-on
I am having the same issue.  I have three email address columns that need to be sent.  Should there be a space between the column name that I copy and paste?

Joseph Schmidt

unread,
Apr 10, 2024, 3:59:25 PM4/10/24
to nv-autocr...@googlegroups.com
I think there should be a comma.

Look at the status column that is added by Autocrat for any error messages.


NOTICE: This message is intended only for the use of the Addressee(s) and may contain information that is PRIVILEGED and CONFIDENTIAL. 
If you are not the intended recipient, dissemination of this communication is prohibited. If you have received this communication in error, please 
erase all copies of the message and its attachments and notify me immediately.  We have made all reasonable efforts to ensure that this email 
and any attachments are free from viruses but it is the responsibility of the recipient to carry out all necessary virus checks and the "company" 
accepts no liability in connection therewith. Thank you.

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages