kelo/google-forms-to-discord-extended

Automatically send Google Forms to Discord! Now including support for longer responses and Forum channels!

I'm a Software Engineer who likes open source and collaboration.

I'm interested & learning about DevOps/DX.

google-forms-to-discord-extended's Issues

Enter on Description

Hi How do I add enter on the description ?

Multiple forum threads being created

There seems to be an issue where if the messages are divided into multiple parts, it creates a thread for each response. Likewise, a similar case is with pings, where it pings for each embed instead of just once.

Request failed for https://canary.discord.com returned code 400.

Followed the exact same code as the one from script.gs file, except modified the webhook URL.
Received the following error:

Exception: Request failed for https://canary.discord.com returned code 400. Truncated server response: {"embeds": ["0"]} (use muteHttpExceptions option to examine full response)

Searched previous issues and from the main repository and thought it would be something related to one of the following:

1. Too many characters
   This however does not seem to be the case - I logged currentEmbedCharacterNum and it outputted 25.
2. A question without "required" being enabled.
   I already have all questions required.

Unsure of what actually caused this so any help would be appreciated. Thanks in advance.

Split-Response Resends Content Field

Modified my Payload to the following

            "content": "Hey <@&457179386064535572>s and <@&457179122104270848>s, we've got a new application!",
            "embeds": [{
                "title": "Oakridge Application Response",
                "fields": items,
                "color": 1242520,
                "footer": {
                    "text": "Application submitted."
                },
                "timestamp": new Date().toISOString()
            }]
        })

But it resends the Content when a response is split between two messages. Not a big issue whatsoever but wanted to let you know anyway. Also, can this be PR'd to the original repo? You've done absolutely fantastic work.

What about it creating a thread in a normal channel?

So we have threads made in Forumss? But what about the normal threads you can make in a channel?
I just thought it was a general question I should ask.

as most people don't actually use the forum system, and I really wanted to know if it was possible.

Something isn't working

I have been using the forum_script.gs for several months now, and it has been working perfectly fine.

However, only a few weeks ago did issues start occurring where forums fail to be created. Here is a recent failed execution of what has occurred:

However, when I also test it myself, it works perfectly, it seems only to fail when others submit a response:

I have already read HELP.md and believe that each of these points was covered in my tests.

Changing Titles/Footer Examples

Hi Kelo,

I just discovered this bot today and I'm already having a blast getting it setup in my discord. I have everything setup, but at the moment I'm finding myself manually editing the titles and thread titles so that there is an easy way to distinguish them (see circled sections):

Would you be able to provide an example of how you get the forum threads/titles to change using the "Cosmetic" options in the readme? One other question I have is if it is possible to edit the thread title to be one of the answers in the form sheet. Thanks for managing this bot!

Cannot read property 'length' of null onSubmit

13:37:45 Fehler
TypeError: Cannot read property 'length' of null
onSubmit @ Code.gs:44

What can i do?

Tags on Newly Created Threads

Is there a way to add a Tag along with the newly created forum thread?

forum_script.gs

sorry, I'm having an issue figuring out where to put the thread id in the forum_script.gs script. If I want responses to only be sent to a specific thread, should "thread_name" be omitted? thank you in advance.

Checkboxes and Cont.

Hello,

I was able to get this script to work wonderfully. Unfortunately my google form has some questions with checkboxes. The script spits out those as follows:

`Question: (cont.)
Checkbox1SingleWordValue

Same: (cont.)
Checkbox2SingleWordValue
`

Putting checkboxe values with a comma and space between them would work much better but I'm not familiar with the language and the code enough to do so, and attempts to alter the code have had no effect.

Form responses on title thread Forum

Hello :)
Is there a possibility of putting a form variable in the title of a thread in the forum?

got some errors the title is not long lol

Apr 11, 2023, 9:06:13 PM Error Exception: Request failed for https://discord.com returned code 400. Truncated server response: {"embeds": ["0"]} (use muteHttpExceptions option to examine full response)
at onSubmit(WebHook:58:17)