Loving Make - so glad I discovered it.
Trying to work out the best way to send a summary of responses to a Google Form to telegram/discord. The form asks people to fill out a Multiple-choice grid question, ranking the finishing order of drivers in the upcoming grand prix. The row labels are the driver names, and participants select what position they will finish in (1st - 10th or out of the points).
I’d like to be able to use the data to send a summary of what people predicted in the following format:
1st - Driver
2nd - Driver
3rd - Driver
… and so on
I thought of using an “If” function in the mapping section, (eg: IF(Driver1=“1st”,“Driver Name”,etc) but I can’t work out how to return the question name which is also the driver name. choose the Question name but it returns [collection] rather than the name of the question.
I hope this makes sense - very keen to hear if anyone has any ideas to make this easier!
Can you provide a link to the form, or show us a screenshot of how this looks like?
Have you set up a scenario to watch new Google Form submissions, and can you provide an example output bundle of this trigger module?
1. Screenshots of module fields and filters
Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.
You can upload images here using the Upload icon in the text editor:
2. Scenario blueprint
Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
(Note: Exporting your scenario will not include private information or keys to your connections)
Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module, save the bundle contents in your text editor as a bundle.json file, and upload it here into this discussion thread.
Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.
Following these steps will allow others to assist you here. Thanks!