Google Forms module

How To
1

I use the Google Forms module to extract data, which I then add to Google Sheets. The problem is that it doesn’t display the original question name, but rather the questionID number.

image
image884×746 71.9 KB

short bundle output

[
    {
        "responseId": "ACYDBNjlptJEtyz6y5B2LYymR8E_-FQb4BBBAOg_p9a9cAOOUiSH1VQCogjo9FapYHUFy2o",
        "createTime": "2024-04-09T12:18:46.326Z",
        "answers": {
            "18333121": {
                "questionId": "18333121",
                "textAnswers": {
                    "answers": [
                        {
                            "value": "2024-04-14"
                        }
                    ]
                }
            },
            "24777181": {
                "questionId": "24777181",
                "textAnswers": {
                    "answers": [
                        {
                            "value": "Macho"
                        }
                    ]
                }
            },

Any clue?

2

Welcome to the Make community!

You can use the built-in function toArray

e.g.:

{{ toArray(1.answers) }}

Then, you can use the Iterator module or map-get functions on it.

2 Likes
3

I’m sure you’re right, but this wasn’t happening to me a few days ago.

image
image888×876 87.3 KB

There might be something I’m not doing correctly, and I’m not sure what it is

In this bundle, it’s similar to the first one; that is, the question’s name isn’t visible, only its ID.
So the issue lies in how MAKE displays the information coming from the form

[
    {
        "responseId": "ACYDBNhkT8f1XJlk8JL7oQlJ-ng_ENtG33IZBdXJc0nSCd1c5qhuwnfNI-EA6RSaRGHg88M",
        "createTime": "2024-03-25T17:07:45.802Z",
        "answers": {
            "320744c8": {
                "questionId": "320744c8",
                "textAnswers": {
                    "answers": [
                        {
                            "value": "dfwgs"
                        }
                    ]
                }
            },
            "3f7b522a": {
                "questionId": "3f7b522a",
                "textAnswers": {
                    "answers": [
                        {
                            "value": "234"
                        }
                    ]
                }
            },
            "2d85be47": {
                "questionId": "2d85be47",
                "textAnswers": {
                    "answers": [
                        {
                            "value": "34"
                        }
                    ]
                }
            },
4

Does anyone have any idea why sometimes the question name appears and other times the ID? Could it be related to the form itself?

5

You’ll need to contact support about that. This is because it has something to do with the underlying code that only they have access to.

Hope you can share the resolution with us if you manage to solve this problem!

2 Likes