Discourse Surveys

:discourse2: Summary Discourse Surveys plugin allows you to create surveys directly within your Discourse forum posts using simple Markdown syntax.
:hammer_and_wrench: Repository Link https://github.com/discourse/discourse-surveys
:open_book: Install Guide How to install plugins in Discourse

The Discourse Surveys Plugin allows you to create surveys directly within your Discourse forum posts using simple Markdown syntax. The plugin currently supports a variety of question types such as radio buttons, checkboxes, dropdowns, number inputs, text areas, star ratings, and thumbs up/down ratings.

Features

  • 7 Different Field Types: Radio buttons, checkboxes, dropdowns, text areas, number selection, star ratings, and thumbs up/down

  • Required/Optional Fields: Mark fields as required to ensure completion

  • Emoji Support: Use emojis in your survey options

  • HTML Support: Rich text formatting in questions and options

  • User Authentication: Automatic login prompts for anonymous users

  • Response Tracking: Prevents duplicate submissions from the same user

  • Permission Aware: Respects topic and category permissions

  • Mobile Responsive: Works seamlessly on all devices

Usage

Basic Survey Structure

All surveys must be wrapped in [survey] tags:


[survey name="my-survey" title="Customer Feedback Survey"]

<!-- Survey fields go here -->

[/survey]

Survey Attributes

  • name: Unique identifier for the survey (defaults to “survey”)

  • title: Optional title displayed at the top of the survey

  • public: Set visibility (future feature)

  • status: Survey status (future feature)

Field Types

1. Radio Buttons (Single Choice)


[radio question="What is your favorite color?"]

- Red

- Blue

- Green

- Yellow

[/radio]

2. Checkboxes (Multiple Choice)


[checkbox question="Which features do you use? (Select all that apply)"]

- Email notifications

- Mobile app

- Desktop notifications

- API access

[/checkbox]

3. Dropdown Selection


[dropdown question="What is your age group?"]

- Under 18

- 18-24

- 25-34

- 35-44

- 45-54

- 55+

[/dropdown]

4. Text Area (Long Form Text)


[textarea question="Please provide detailed feedback:" required="false"]

[/textarea]

5. Number Selection


[number question="Rate this feature from 1-10:" min="1" max="10"]

[/number]

6. Star Rating


[star question="How would you rate your overall experience?"]

[/star]

7. Thumbs Up/Down


[thumbs question="Would you recommend this to others?"]

[/thumbs]

Field Attributes

All field types support these attributes:

  • question: The question text (required)

  • required: Whether the field must be filled (true/false, defaults to true)

  • min: Minimum value for number fields

  • max: Maximum value for number fields

Complete Example

Basic Survey Markdown

Here is a basic example of survey Markdown including all available fields:

[survey name="awesome-survey-thumbs" title="Awesome Survey"]

[radio question="Choose any one option:"]
- cat
- dog
[/radio]

[checkbox question="Choose multiple options:"]
- red
- blue
- green
[/checkbox]

[dropdown question="Gender:"]
- Male
- Female
[/dropdown]

[number question="Rate this survey from 1 to 10:"]
[/number]

[textarea question="What is your feedback about xyz?" required="false"]
[/textarea]

[star question="How would you rate overall experience?"]
[/star]

[thumbs question="Were you satisfied with our services?"]
[/thumbs]

[/survey]

Survey Rendering

Below is an example of how the above Markdown renders in Discourse:

Advanced Usage

Using Emojis in Options


[radio question="Choose your favorite animal:"]

- 🐈 Cat

- 🐶 Dog

- 🐦 Bird

- 🐠 Fish

[/radio]

HTML Formatting in Questions


[radio question="Which <strong>programming language</strong> do you prefer?"]

- JavaScript

- Python

- Ruby

- Go

[/radio]

Mixed Required and Optional Fields


[survey name="mixed-survey"]

[radio question="What is your role?" required="true"]

- Developer

- Designer

- Manager

- Other

[/radio]

[textarea question="Any additional thoughts?" required="false"]

[/textarea]

[/survey]

Survey Results

Currently, this plugin does not have any backend UX to view the survey results directly. Instead, you can rely on Data Explorer queries to fetch and analyze survey responses. Here is an example query:

-- [params]
-- text :survey_name = survey

SELECT s.id, s.name, s.post_id, sf.question, COALESCE(sr.value, sfo.html) AS value, sr.user_id, sr.created_at as responded_at
FROM surveys s
JOIN survey_fields sf ON sf.survey_id = s.id
JOIN survey_responses sr ON sr.survey_field_id = sf.id
LEFT JOIN survey_field_options sfo ON sfo.id = sr.survey_field_option_id
WHERE s.name = :survey_name
ORDER BY s.id DESC

Permissions and Security

  • Login Required: Anonymous users must log in before submitting responses

  • One Response Per User: Each user can only submit one response per survey

  • Topic Permissions: Users must have read access to the topic to view surveys

  • Posting Permissions: Users must have posting permissions in the topic to submit responses

  • Archived Topics: Surveys in archived topics cannot accept new responses

  • Deleted Posts: Surveys in deleted posts are no longer accessible

Limitations

  • Only one survey is allowed per post

  • Survey structure cannot be modified after receiving responses

  • All survey field questions must be unique within a single survey

  • Survey field questions cannot be blank

Technical Details

Database Schema

The plugin creates four main database tables:

  • surveys: Main survey records

  • survey_fields: Individual fields within surveys

  • survey_field_options: Options for choice-based fields

  • survey_responses: User responses to survey fields

Styling

The plugin includes responsive CSS that adapts to your theme. Custom styling can be added by targeting these CSS classes:

  • .survey - Main survey container

  • .survey-field - Individual field wrapper

  • .field-[type] - Specific field type containers

  • .submit-response - Submit button

30 Likes

So users can’t see results (unless they have rights to use query) and this is totally for admins/background staff?

3 Likes

Yes, that is correct.

7 Likes

It doesn’t feel very practical :cry:

3 Likes

Need option to publish survey results. Otherwise better to use multiple polls.

3 Likes

Hello

The sample Markdown renders in a new Topic as per below. My Discourse is updated to the latest version.

What could the the problem?

Regards

Hey @ppcole,

The above is what is shown in composer preview when you’re creating the survey. Once you create the topic it will render properly as expected.

Thanks Arpit. It worked. Looking forward to enhancements

1 Like

May I know if you folks are working on this but not with actual priority?

It would be great to have this continue to be developed - it has masses of potential.

I found that the SQL above did pull out the results, but it wasn’t in an easy to work with format; basically it would require a tonne of transformation at the spreadsheet level to enable useful analysis.

However, with a bit of Gen AI help, I was able to produce a very sweet Data Explorer query. Due to some limitations of Data Explorer, it isn’t possible to make it dynamic enough to cope with a variety of surveys; basically you need a bespoke query per survey.

Fortunately, Gen AI can make that pretty straight forward. Here is a sample prompt that will probably work in most Gen AI services (if you don’t have the AI plugin active) - just plugin in your survey markdown and you should be away:

Gen AI Prompt to Produce Tailored SQL Query for a Specific Survey

I have a survey defined in markdown format, and I need a SQL query to extract the survey results from a Discourse database using the Data Explorer Plugin. The survey includes various types of questions such as radio, dropdown, star, checkbox, textarea, thumbs, and number. I want the query to output results with each user having a single row and each question having its own column. For checkbox questions, multiple responses should be concatenated into a single string.

Here is the survey markdown:

Paste your survey markdown here

Here is the original query used to obtain survey results:

-- [params]
-- text :survey_name = survey

SELECT s.id, s.name, s.post_id, sf.question, COALESCE(sr.value, sfo.html) AS value, sr.user_id, sr.created_at as responded_at
FROM surveys s
JOIN survey_fields sf ON sf.survey_id = s.id
JOIN survey_responses sr ON sr.survey_field_id = sf.id
LEFT JOIN survey_field_options sfo ON sfo.id = sr.survey_field_option_id
WHERE s.name = :survey_name
ORDER BY s.id DESC

Please generate a SQL query that:

  • Hardcodes the survey name.
  • Uses conditional aggregation to pivot the data, with each question as a column.
  • Utilizes STRING_AGG for checkbox questions to handle multiple responses.
  • Ensures the output is grouped by user_id and ordered by user_id.
  • Is formatted for readability and includes comments explaining the logic where necessary.

Additional Guidance for Data Explorer Plugin:

  • The query should be compatible with the Discourse Data Explorer Plugin, which means it should not end with a semicolon.
  • Use column names like user_id to leverage automatic linking features within the Data Explorer.
  • Avoid using dynamic SQL, as the plugin does not support it.
  • Ensure the query is efficient and optimized for performance, as it may be run on large datasets.
7 Likes

This is an excellent little plugin that is surprisingly feature rich. Thanks for making it.

@nathank great job on guide to quickly building results query. That makes the whole thing even more useful :rocket: (and should be moved to the OP)

4 Likes

I installed this on my self-hosted site to take it for a spin, and it’s quite nice indeed!

I realize this is anathema to discourse, but it would be helpful if it were possible to create surveys that can be completed anonymously, without logging in. Or at least to anonymize the results so they are not associated with specific users.

And of course yes the ability to look at the results like you can with polls without having to resort to data explorer would be fantastic.

4 Likes

Yes I faced the same issue. Hopefully there is a solution.

3 Likes